Posted by Lena on Monday, December 28, 2009 at 9:28pm.
The Furniture Co has two plants. The Eastside one makes Table and Chairs for school classrooms and the Westside one makes Desks and Computer Workstations. (See tables attached in excel).
The Furniture Co is considering combining operations of both plants into a single one. This consolidation will combine the weekly available resources so that 12,000 sq.ft. of pressed wood, 800 boxes of aluminum fittings and 600 production hours will be available weekly . However the accounting department estimates the cost of renovating the plant will be $5000/weekly , on an amortization bases.
1. Find the optimal solution for each plant separately.
2. Analyze the recommendations to Furniture Co for combining operations at both plants into a single plant.

Linear programming  MathMate, Tuesday, December 29, 2009 at 6:23pm
We don't see the excel file, so are not able to process the given data.
However, I assume the file gives the resources, namely the number of square feet of plywood, boxes of aluminium fittings and the number of production hours for each plant, together with the required resources and profit for each product.
To solve the problem, you would set up a simplex tableau for each plant, and solve both to get the total production, or rather the total profit.
Repeat the same exercise for the combined plant and compare profitability.
Answer This Question
Related Questions
 Financing and Budget  which one of these categories would most likely be found ...
 math  Franklin Furniture Company sells chairs for $110 each and tables for $322...
 math  "fashion furniture makes two kinds of chairs; rockers and recliners. two ...
 math  Freddie Fast can make 6 4/5 chairs per hour on a furniture assembly line...
 Math  a furniture company makes similar chairs for adults and children. The ...
 college  Research the Bacardi website. Using your research findings from the ...
 global strategic management  Research Chevron Using your research findings from...
 Budget  Which one of these categories would most likely be found in the ...
 Global Strategic Management  Research the Abercrombie and Fitch website. Using ...
 Math  Cathy is buying new living room furniture. She wants to purchase a set ...
More Related Questions