Question: Assignment 4 Interpretation of Solver Output Based on the objective function and the Solver output of the solution, answer the questions below the table. Max

Assignment 4 Interpretation of Solver Output
Assignment 4 Interpretation of Solver Output
Assignment 4 Interpretation of Solver Output Based on the objective function and the Solver output of the solution, answer the questions below the table. Max Z-10 xl + 10 x2 + 23 x3 (where xl= no. of shirts, x2=no. of shorts & x3=no. of pants) ( Awer Report Cell Name Original Value Final Ver SP54 Objective functie Adjustable Cells Cell Name Original VW SCE SDShorts 80 KO Cell Name ce Value SF57 Department Acht For Slack SEST SGSN Binding Se prepartments SFS9 Material (Yards) 120 STS- Sanding SPSP-SGST Sensitivity Report Adjustable Cells cell Name SCS2Shirt Shot SEP Pinal Reduced the wallowable Cost Coefficaceae Decrease 40 10 10 10 F1 23 1E30 Consis Final Shadow Controle hewable Cell Name NwPrice RHS Per SFST Department A 160 220 TE300 ho SF58 Department 100 hours) SFS Material yards) 120 120 a. What is the maximum that you would be willing to pay to increase the capacity of Department B by 20 hours? Give reasons. (3 points) b. To cut costs, you Buduction Manage has recommended 10 111 Sitivity Report Adjustable Cells Final Reduced Objective Allowable Allowed Voc Casi Coefficient Increase Decrease 10 110 0635 le DO 20 1135 1-1 23 1E30 ce Name SCS2 Shirt Iss Shorts SES 140 110 Constraints Name SE57 Depan Final Shadow Constraint Allowable Allowable Vale Price R. Side Increase Decrease 100 120 TIE. 10 SE58epartment B 160 100 SF59 May 130 120 73 . a. What is the maximum that you would be willing to pay to increase the capacity of Department B by 20 hours? Give reasons. (3 points) b. To cut costs, your Production Manager has recommended reducing the capacity of Department A by 40 hours. What effect will this have on the optimal production plan? Give reasons. (3 points) c. If the profit on pants went up by $ 1 per pant what impact will it have on the production plan i.e. the optimal solution? Give reasons. (3 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!