Mathlinear programming
posted by Lena .
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.

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.
Respond to this Question
Similar Questions

math
"fashion furniture makes two kinds of chairs; rockers and recliners. two machinges a and b are used. machine a is limited to 20 hours per day. machine b is limited to 15 hours per day. machine a takes two hours to make each rocker … 
global strategic management
Research Chevron Using your research findings from the Library and the Internet, develop both an EFAS (External Factors Analysis Summary) table and an IFAS (Internal Factors Analysis Summary) table. The tables are to be submitted in … 
Budget
Which one of these categories would most likely be found in the operating budget of a day care center? 
college
Research the Bacardi website. Using your research findings from the Library and the Internet, develop both an EFAS (External Factors Analysis Summary) table and an IFAS (Internal Factors Analysis Summary) table. The tables are to be … 
math
Freddie Fast can make 6 4/5 chairs per hour on a furniture assembly line. Warren Weary makes 4 1/2 chairs per hour. In a 10hour shift, how many more chairs does freddie make than warren? 
Global Strategic Management
Research the Abercrombie and Fitch website. Using your research findings from the Library and the Internet, develop both an EFAS (External Factors Analysis Summary) table and an IFAS (Internal Factors Analysis Summary) table. The tables … 
Financing and Budget
which one of these categories would most likely be found in the operating budget of a day care center? 
math
Franklin Furniture Company sells chairs for $110 each and tables for $322 each. Last month the company sold 65 items for a total of $12,450. How many chairs and how many tables did they sell? 
Math
a furniture company makes similar chairs for adults and children. The height of the adult chair is 80cm while the height of the childrens chair is 50 cm. what is the ratio of their widths 
math
Amalgamated Furniture Company makes dining room tables and chairs. A table requires 8 laborhours for assembling and 2 laborhours for finishing. A chair requires 2 laborhours for assembly and 1 laborhour for finishing. The maximum …