Reference no: EM13907008
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.
|
How many distinct exams can she give
: A chemistry professor at ASU has 36 questions that she uses on her exams. Her exams always have 11 questions. How many distinct exams can she give? The order of the questions does not matter
|
|
What tax basis will jasmine have for the land
: Jasmine received a parcel of land as a gift from her Uncle Eustace. At the time of the gift, the land had a fair market value of $83,000 and an adjusted basis of $23,000. This was the only gift that Jasmine received from Eustace during 2014. If Eusta..
|
|
What are some of the benefits of cycling chemicals?
: What are some of the benefits of cycling chemicals?
|
|
Interest expense and corporate tax rate
: Talbot Enterprises recently reported an EBITDA of $7.0 million and net income of $2.45 million. It had $2.1 million of interest expense, and its corporate tax rate was 30%. What was its charge for depreciation and amortization?
|
|
What are the decisions that need to be made
: 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?
|
|
Formulate the given situation as a strategic game
: Each party's prefer- ences are represented by the expected number of votes it gains. Formulate this situation as a strategic game and find its mixed strategy equilibria.
|
|
Issue-ruling-analysis and conclusion tax memo format
: Dr. Tooth is a 40-year old dentist in Small Town, USA. He graduated from dental school seven years ago and built a thriving practice. In 2001, however, Dr. Tooth had an ugly billing disagreement with a patient. As a result of the stress of losing his..
|
|
What are mineral salts
: What are mineral salts? Where can mineral salts be found in living organisms?
|
|
What would happen to prices of your exports
: Suppose the US dollar appreciates in its value against the Euro. If you were exporting US made products to Europe, what would happen to prices of your exports?
|