Explore BrainMass

Linear Programming : Maximizing Profit

Furniture Unlimited has the capability to manufacture desks, cabinets, and chairs. In order to manufacture these product, it must rent the appropriate equipment at a weekly cost of $2,000 for the desks, $2,500 for the cabinets, and $1,500 for the chairs. The labor and material requirements for each product are shown iii the following table, along with the sellin price and variable cost to manufacture.
There are 2500 labor hours and 4,000 square feet of lumber available each week. Determine the product mix that maximizes weekly profit.

Please see the attached file for the fully formatted problems.


Solution Summary

An LP problem is solved using EXCEL.