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

A project is expected to create operating cash flows of

A project is expected to create operating cash flows of $29,000 a year for three years. The initial cost of the fixed assets is $60,000. These assets will be worthless at the end of the project. An additional $4,000 of n ...

1 what is meant by a real option2 what is meant by the term

1. What is meant by a "real option"? 2. What is meant by the term overage for retail space? 3. How does the use of scenarios differ from sensitivity analysis?

1 what does assignment mean and why would a lender want to

1. What does "assignment" mean and why would a lender want to assign a mortgage loan? 2. What is meant by a "purchase-money" mortgage loan? When could a loan not be a purchasemoney mortgage loan? 3. What does default mea ...

1 budgets of government entitiesare integrated with the

1. Budgets of government entities: Are integrated with the financial accounting system. Enable governments to demonstrate compliance with laws and to communicate performance effectiveness. Are adopted by governments afte ...

1read the following article on dimensional fund

1. Read the following article on Dimensional Fund Advisors: http://www.wsj.com/articles/making-billions-with-one-belief-the-markets-cant-be-beat-1476989975 Write a composed essay (1 page max) addressing the following que ...

1 the interested student should rewrite the equations for

1. The interested student should rewrite the equations for the vertically integrated utility to show that the total revenue received from all activities is equal to the sum of all input costs, plus the sum of all capacit ...

Use psycinfo or a similar database to locate a research

Use PsycINFO or a similar database to locate a research study using a factorial design. (Note: You can try a subject term based on an area of interest, but the most direct path to finding factorial designs is to use a se ...

Why do higher interest rates lead to higher call option

Why do higher interest rates lead to higher call option prices but lower put option prices? Suppose a European put price exceeds the value predicted by put-call parity. How could an investor profit? Demonstrate that your ...

Based on the corporate valuation model abc corps value of

Based on the corporate valuation model, ABC Corp's value of operations is $1,600 million. Its balance sheet shows $625 million of current assets which includes $125 million of short-term investments that are unrelated to ...

1 discuss the conditions where a multidomestic or regional

1. Discuss the conditions where a multidomestic or regional strategy might perform better than a transnational or international strategy. 2. Explain how global integration and local responsiveness might be successful in ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro