Question: The Excel Sensitivity Report for Feed problem where the objective is minimization of cost is provided below. Variable Cells Final Reduced Objective Allowable Allowable Cell

The Excel Sensitivity Report for Feed problem

The Excel Sensitivity Report for Feed problem where the objective is minimization of cost is provided below. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$4 Feed A 8 0 0.96 1E+30 0.51 $C$4 Feed B 2 0 0.85 1E+30 0.475 $D$4 Feed C 2. 0 0.775 1E+30 0.4 $E$4 Feed D 12 0 0.45 0.51 0.075 $F$4 Feed E 16 0 0.375 0.075 1E+30 Constraints Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 14 Cell Name Max B, C, & E $G$7 requirement $G$14 Size requirement $G$8 Min A requirement $G$9 Min B requirement $G$10 Min C requirement $G$11 Min D requirement $G$12 Min E requirement $G$13 Min B & D requirement 20 40 8 2 2 12 16 -0.075 0.45 0.51 0.475 0.4 0 0 0 20 40 8 2 2 2 2 2 1E+30 2 14 14 10 14 2 2 8 2 2 1E+30 1E+30 1E+30 14 12 Answer the following questions: a. What is the impact on cost if we increase Min E requirement by 10 units? b. If the objective function coefficient of Feed B decreases by $0.15, will the optimal solution and the value of the objective function change? c. We can decrease Min A requirement by 3 units, while increasing Min B & D requirement by 1 unit. Is it worth the effort? d. If the objective function coefficient of Feed C decreases by $0.2 and the objective function coefficient of Feed E increases by $0.04, what will be the impact on cost

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!