In: Operations Management
Andalus Furniture Company has two manufacturing plants, one at Aynor and another at Spartanburg. The cost in dollars of producing a kitchen chair at each of the two plants is given here. The cost of producing Q1 chairs at Aynor is: 25Q1+2.5Q12+100 and the cost of producing Q2 kitchen chairs at Spartanburg is: 75Q2+2.5Q22+150. Andalus needs to manufacture a total of 40 kitchen chairs to meet an order just received. How many chairs should be made at Aynor, and how many should be made at Spartanburg in order to minimize total production cost? If required, round your answers to the nearest whole number. Round intermediate calculations to two decimal places.
Aynor
Spartanburg
Total cost $
We will use Excel -> Solver to solve this linear programming problem.
Setup Excel with details given in the linear programming formulation as shown.
Go to File-> Options -> Excel Add ins -> Solver Add ins
Now, go to Data -> Solver and setup Solver with decision variables, objective function and constraints.
Click on Solver to get optimal solution:
Final optimal solution for producing chairs is:
Aynor - 25
Spartanburg - 15
Total cost $ - $4,125
Please give thumbs up/ likes if you find this answer helpful. Thank
you!