Make a rough sketch of a spreadsheet model

Assignment Help Corporate Finance

Reference no: EM1346189

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. Calculate 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.

Reference no: EM1346189

Questions Cloud

Communication management plan address : Explain what items should a communication management plan address and how can a stakeholder analysis assist in preparing and implementing parts of this plan?

Illustrate what is the macroeconomic relationship : Illustrate what is the macroeconomic relationship with the article, "Squaring the Economic Circle" by Art Buchwald.

What was the velocity of the cannon ball : The other end of the spring braced against a post that was firmly anchored to the ship's frame. What was the speed of the cannon ball if the spring compressed 50cm as the cannon was fired.

Formal and informal communication : Explain techniques and behaviors to overcome communication barriers and provide effective feedback - Explain assertiveness techniques that can be used to improve communication

Make a rough sketch of a spreadsheet model : The Pine Furniture Corporation makes fine country furniture. The firm's current product lines consist of coffee tables, end tables, & dining room tables.

Find the velocity at which the water shoots out of the tank : A wooden raft has a mass of 85 kg. while empty it floats in water (density 1000 kg/m3) with 61 percent of its volume submerged. What mass of sand can be put on the raft without it sinking.

Find the communication plan : The first step in building a communication plan is to identify your key stakeholders. How would one identify a key stakeholder?

Illustrate what other additional information do you need : Illustrate what other additional information do you need, and how would you proceed if you had that information.

How do you exchange business cards : How should you handle the introduction, greeting, and handshaking and how do you exchange business cards

User Account

All Pages