Question: Given results after developing the excel LP and Solver: Question 4: Sensitivity Analysis (20 Points) Using the Excel Solver results in Table, address the following
Given results after developing the excel LP and Solver: Question 4: Sensitivity Analysis (20 Points) Using the Excel Solver results in Table, address the following questions: (4 points per question) Exodogs Star Slurp 3 Availability 3500 S 5 a. What is the objective function and its optimal value? 0 1 350 3 2 360 Profit $10 320 b. What are the slack/surplus values for different constraints? 0 180.0 Number produce Potit contribution Total (per wed) 33600 50 $3600 c. What happens to the optimal solution if the coefficient of "Number produced Star" changes to 20 minutes on slide 30? Sathy Raw Vartable Fiul Raluced Objective Allowable Allowable Value Collidest er Decrease Cell Name Cou d. What % of available "Labor amount used" can be decreased without it affecting the current (given) optimam solution? -10 10 10 TES berdeel te SHINero Sur 10 20 1E10 Saw Cost Allowable Aliwale N. le Der How much should the "Star" product unit profit of S10 be increased by so the manufacturer can produce them? C 35 1136 LAU al Show Criat Valse ILLS 140 3500 11 30 10 300
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
