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 labor hours available must be used. Formulate a linear programming problem to determine the best combination of furniture cabinets to be made and use Excel’s Solver to obtain the optimal solution.
solution
Solution:
15% off for this assignment.
Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!
Why US?
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Money Back
If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.