Question: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SSS Number to Make Chair 230 240 230 16 + 30

Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SSS Number to Make Chair 230 240 230 16 + 30 5CBS Number to Make Table 720 5035 Number to Make Armoire 600 120 Constraints Final Shadow Constraint Allowable Allowable Call Name Value Price Kill Side Increase Decrease SEE Assembly Minutes Used 3600 3600 4010 GOD SERIO Finishing Minutes Used 2090 20 0 0 40 0 490 SESII Wood Pounds Used 3600 40DU ALITY 400 1) What is the optimal solution 27 Suppose the profit per table changed to $950 . Will the optimal solution change and what can be said about the effect on total profit ? the rofit ? 3) Suppose the profit per table changed to $8DO . Will the optimal solution change , and what can be said about the effect on total profi 4 Suppose there are 300 less hours available for Assembly . What can be said about the effect on total profit ? 5 Suppose the company had an opportunity to acquire 507 hours of Finishing capacity for a total cost of $2300 . Should they do so Explain
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
