Search Abdullah Dauda AD Pic EG_MGMT31_Wee12_083_Assigement - Protected View - Saved to this PC- H Insert Draw Design Layout References Mailings Review View Help PROTECTED VIEW Be cardul files from the latenet can contain viruses. Unless you need to ecit, it's safe to stay in Protected View. Share Comments Erase id ting MGMT 430 Sensitivity Analysis Assignment - Week 2 - Dropbox 3 Reference the following sensitivity report to answer the questions: Variable Cells Cell Name $$s Number to Make Chali SCSS Number to Make Table SUSS Number to Make Armoire Constraints Final Reduced Objective Allowable Allowable Value Cost Coefficient increase Decrease 0 -230 240 2:30 15:30 10 0 720 180 120 15 0 GUO 120 120 CALL Name SES Assembly Minutes Used SE510 Finishing Minutes Used SES11 Wood Pounds Used Final Shadow Constraint Allowable Allowable Value Price T.H. Side Increase Decrease 3600 3600 000 G00 2000 4.5 2000 400 3600 0 4000 15.30 400 400 1) What is the optimal solution? 2) Suppose the protit per table changed to $950. Will the optimal solution change, and what can be said about the street on total profit? 3) Suppose the proper table changed to $800. Will the optimal solution change, and what can be said about the effect on total profil 4) Suppose there are 300 less minutes available for Assembly. What can be said about the effect on total profit? S) Suppose the company had an opportunity to acquire Se minutes of Finishing capacity for a total cost of $2300. Should they do so? Explain. Page 1 of 204 204 worth Crocus 100% Search for anything E. a 1202 PM 514/2011 Search Abdullah Dauda AD Pic EG_MGMT31_Wee12_083_Assigement - Protected View - Saved to this PC- H Insert Draw Design Layout References Mailings Review View Help PROTECTED VIEW Be cardul files from the latenet can contain viruses. Unless you need to ecit, it's safe to stay in Protected View. Share Comments Erase id ting MGMT 430 Sensitivity Analysis Assignment - Week 2 - Dropbox 3 Reference the following sensitivity report to answer the questions: Variable Cells Cell Name $$s Number to Make Chali SCSS Number to Make Table SUSS Number to Make Armoire Constraints Final Reduced Objective Allowable Allowable Value Cost Coefficient increase Decrease 0 -230 240 2:30 15:30 10 0 720 180 120 15 0 GUO 120 120 CALL Name SES Assembly Minutes Used SE510 Finishing Minutes Used SES11 Wood Pounds Used Final Shadow Constraint Allowable Allowable Value Price T.H. Side Increase Decrease 3600 3600 000 G00 2000 4.5 2000 400 3600 0 4000 15.30 400 400 1) What is the optimal solution? 2) Suppose the protit per table changed to $950. Will the optimal solution change, and what can be said about the street on total profit? 3) Suppose the proper table changed to $800. Will the optimal solution change, and what can be said about the effect on total profil 4) Suppose there are 300 less minutes available for Assembly. What can be said about the effect on total profit? S) Suppose the company had an opportunity to acquire Se minutes of Finishing capacity for a total cost of $2300. Should they do so? Explain. Page 1 of 204 204 worth Crocus 100% Search for anything E. a 1202 PM 514/2011