Math-linear programming

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.

  1. 👍 0
  2. 👎 0
  3. 👁 158
  1. 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.

    1. 👍 0
    2. 👎 0

Respond to this Question

First Name

Your Response

Similar Questions

  1. math

    The manger at Gabriela's Furniture Store is trying to figure out how much to charge for a book shelf that just arrived. The bookshelf was bought at a wholesale price of $147.00, and Gabriela's Furniture Store marks up all new

    asked by Raley on December 12, 2019
  2. physics

    A horizontal force of 100 N is required to push a piece of furniture across a floor at a constant velocity. what is the net force acting on the furniture? How much is the friction force that acts on the sliding furniture? How much

    asked by m on September 21, 2010
  3. Algebra

    david makes and sells chairs. The function p(x)=-10x^2+100x-210, graphed below, indicated how much profit he makes in a month if he sells the chairs for 10-x dollars each. what should david charge per chair to make the maximum

    asked by Starcatcher on December 5, 2016
  4. science help

    A student did an experiment with two identical plants, Plant 1 and Plant 2. About 10 mL fertilizer was added to Plant 1. About 200 mL of water was added to each plant every day. The height of the plants was recorded over a period

    asked by Oscar on January 13, 2016
  5. Maths

    A tall stool weighs 3.6kg. A table is twice as heavy as a chair. Together, 5 chairs and 2 tall stools weigh 15.3kg more than the table. Find the weight of the table.

    asked by Amy on March 25, 2020
  1. math

    Mr.Edstrom had a budget of $1500 to spend on a table and 6 chairs. The total price was $249 under her budget amount. The table cost 3 times as much as a chair. What was the price of the table?

    asked by ikram on December 8, 2011
  2. Biology

    CAM (crassulacean acid metabolism) plants such as the cacti differ from standard C4 plants such as corn in which of the following ways? a. CAM plants minimize photorespiration whereas C4 plants do not. b. CAM plants use both

    asked by John Joseph on October 6, 2009
  3. math

    You run a small furniture business. You sign a deal with a customer to deliver up to 700 chairs, the exact number to be determined by the customer later. The price will be $150 per chair up to 600 chairs, and above 600 the price

    asked by Leila on October 29, 2015
  4. math

    need help with a homework please explain how to get answer to ms hernandez has 17 tomato plants that she want to plant in rows. she will put 2 plants in some rows and 1 plant in the others. how many different ways can she plant

    asked by C C on November 18, 2015
  5. Math

    School A has 480 students and 16 classrooms. School b has 192 students and 12 classrooms. A. what is the ratio of students to classrooms at School A? 480:16 B. what is the ratio of students to classrooms at School B? 192:12 C. How

    asked by Jay on April 17, 2015
  6. Math

    You run a small furniture business. You sign a deal with a customer to deliver up to 500 chairs, the exact number to be determined by the customer later. The price will be $120 per chair up to 400 chairs, and above 400 the price

    asked by Lucas on May 4, 2016

You can view more similar questions or ask a new question.