Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

The Pine Furniture Company makes fine country furniture. The company's current product lines consist of end tables, coffee tables, and dining room tables. The production of each of these tables requires 8, 15, and 80 pounds of pine wood, respectively. The tables are handmade and require one hour, two hours, and four hours. Each table sold generates $50, $100, and $220 profit. The company has 3,000 pounds of pine wood and 200 hours of labor available for the coming week's production. The chief operating officer (COO) has asked you to do some spreadsheet modeling with this data to analyze what the product mix should be for the coming week and make a recommendation.

a. Visualize where you want to finish. What numbers will the COO need? What are the decisions that need to be made? What should the objective be?

b. Suppose that Pine furniture were to produce three end tables and three dining room tables. find out by hand the amount of pine wood and labor that would be required, as well as the profit generated from sales.

c. Make a rough sketch of a spreadsheet model, with blocks laid out for the data cells, changing cells, output cells, and target cell.

d. Build a spreadsheet model and then solve it.

 

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M926992

Have any Question? 


Related Questions in Basic Finance

Tim smith is shopping for a used car he has found one

Tim Smith is shopping for a used car. He has found one priced at $5,900. The salesman has told Tim that if he can come up with a down payment of $1,200 the dealer will finance the balance of the price at an annual rate o ...

Following table shows the price information for three

Following table shows the price information for three stocks:  Stock Price 0 Quantity 0 P 1 Q 1 A $70 50 $85 50 B 10 150 12 150 C 100 30 50 60 1. What happened for stock C during this period? 2. Calculate the price-weigh ...

Please help me solve this questionconsider a bond that

Please help me solve this. question. Consider a bond that promises the following cash flows. The yield to maturity is 12%. Year 0 1 2 3 4 Promised Payments 160 160 170 180 230 You plan to buy this bond, hold it for 2.5 y ...

The fed briefly describe the origin of the federal reserve

The Fed Briefly describe the origin of the Federal Reserve System. Describe the functions of the Fed district banks.

Discussioncourse wrap-up please respond to the

Discussion "Course Wrap-Up" Please respond to the following: Imagine you have completed your bachelor's degree at University and you are searching for a job in finance, accounting or business. Using various employment we ...

Assignmentlife situationfinancial datasinglemonthly

Assignment Life Situation Financial Data Single Monthly income $2,600 Age 22 Living expenses $2,180 Starting a career Assets $8,200 No dependents Liabilities $3,470 Emergency fund $530 Since the major portion of Pam's in ...

Explain the changes in m1 and m2 if an individual moves

Explain the changes in M1 and M2, if an individual moves money from a small denomination time deposit to a demand deposit account?

We have stressed that the goals of efficiency and

We have stressed that the goals of efficiency and competition may conflict with the goals of safety and soundness. Give an example of when this could occur.

What will be the worth of a bond with a par value of 1000

What will be the worth of a bond with a par value of $1000 earning a coupon interest rate of 12% and paying interest semi-annually at the end of the fifth year if the cost of capital is 8%.

Impact of stock market crises during periods when investors

Impact of Stock Market Crises : During periods when investors suddenly become fearful that stocks are overvalued, they dump their stocks and the stock market experiences a major decline. During these periods, interest ra ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate