Business Finance Homework Help

CUNY Lehman College Maximizing Profit for A Cabinet Manufacturer Question

2-26 A furniture cabinet maker produces two types of cabinets that house and hide plasma televisions. The Mission-style cabinet requires $340 in materials and 15 labor hours to produce, and it yields a profit of $910 per cabinet. The Rustic-style cabinet requires $430 in materials and 20 hours to produce, and it yields a profit of $1,200. The firm has a budget of $30,000 to spend on materials. To ensure full employment, the firm wishes to plan to maximize its profit but at the same time to keep all 30 workers fully employed, so all 1,200 available labor hours available must be used. What is the best combination of furniture cabinets to be made?

After you complete the model please copy it to a new sheet. The first sheet should be in solutions view and the second sheet in formula view.