Answered step by step
Verified Expert Solution
Question
1 Approved Answer
REC Question 4: Sensitivity Analysis (20 Points) Given results after developing the excel LP and Solver: Using the Excel Solver results in Table, address the
REC Question 4: Sensitivity Analysis (20 Points) Given results after developing the excel LP and Solver: Using the Excel Solver results in Table, address the following questions: Solver Smritivirg Report! a. What is the objective function and its optimal value? Variable Cdh Final Reduced Objective Allowable Allowable Call Name Value Com Coefficient Increase Decrease b. What are the slack/surplus values for different $8521 Number produced Star -10 10 10 15-15 constraints? BC$21 Member produced Shap 1E+30 C. What happens to the optimal solution if the Final Shadow | Constraint Allowable Allowable coefficient of "Number produced Star" changes to Call Same Valor Price R.H. Side Increase 38425 Speed Amount Used 1440 IE-30 307 1:30 350 360 20 360 360 d. What % of available "Labor amount used" can be decreased without it affecting the current (given) 20 minutes on slide optimum solution? e. How much should the "Star" product unit profit of 4 marks per question $10 be increased by so the manufacturer can produce them
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started