Question: 4. Below tables show the Answer Report and the Sensitivity Report of the optimization problem. Based on these two tables, answer the following questions. a)

4. Below tables show the Answer Report and the
4. Below tables show the Answer Report and the
4. Below tables show the Answer Report and the Sensitivity Report of the optimization problem. Based on these two tables, answer the following questions. a) Write the objective function. b) What is the z value (objective function's value) b) Identify the sensitivity ranges for the objective function. c) Write the constraint quantity values. d) Identify the sensitivity ranges for the constraint quantity values. e) What is the unknown shadow price? (Shown as yellow) f) Why are there 4 shadow prices? Objective Cell (Max) Cell Name Original Value Final Value $C$15 Profit 1503 1503 Variable Cels Cell Name Original Value Final Value Integer SCS11 xt 26 26 Contin SC$12 2 34 34 Contin SCS13 x3 09 00 Contin SC514 x4 154 15.4 Contin Constraints Call Now SH56 Used SH57 Used SHS8 Used SHS9 Used Cell Value Formula Status Sch 74 SH 56656 Dinding 214 SHS7637 Not Binding 2598743268 365584658 Binding 0 410 HSSSG59 Binding 0 Variable Cells Cell Name $C$11 x1 $C$12 x2 $C$13 x3 $C$14 x4 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 2.560143627 0 12 0.628571429 6.444444444 3.364452424 0 8 8.546583851 0.75862069 0-6.691561939 10 6.691561939 1E+30 15.43985637 0 6 6.444444444 0.628571429 Constraints Cell Name $H$6 Used SH$7 Used SH$8 Used $H$9 Used Final Shadow Value Price 74 0.078994614 21.40125673 0 36 480 0.208258528 Constraint Allowable Allowable R.H. Side Increase Decrease 74 20.37142857 26.08108108 24 1E+30 2.598743268 36 7.170278638 25.67164179 480 79.31506849 79.22222222

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!