Question: need help with E,F, and G only thank you! 3. [25 Pt) Below tables show the answer Report and the Sensitivity Report of the optimization

need help with E,F, and G only thank you! 3. [25
need help with E,F, and G only thank you! 3. [25need help with E,F, and G only thank you!
3. [25 Pt) 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 P.) Write the objective function. b) 13 Pt.) What is the z value (objective function's value) c) 14 Pt. Identify the sensitivity ranges for the objective function, d) 13 PL. Write the constraint quantity values. e) [4 Pt.) Identify the sensitivity ranges for the constraint quantity values. 13 P.) How many shadow prices are there? 1) [4 P.) What is the unknown shadow price? (Shown as yellow) Objective Cell (Min) Cell Name SBSTB Costa Original Value 269333333 Final Value 269333333 Variable Cells Cell Name $B$15 x1 $B$16 x2 $B$17 x3 Original Value 70 00 120 00 53.33 Final Value Integer 70 00 Contin 120 00 Contin 53 33 Contin Constraints Cell Name SH$10 Usage SH$11 Usage SH$8 > Usage SH$9 > Usage Cell Value Formula Status Slack 70 SHS10$G$7 Binding 0 120 SH$8>=$G$8 Not Binding 70 53 33 SH$9:$G$9 Not Binding 3.33 Variable Cells Cell Name SB515 x1 $8516 x2 $8517 x3 Final Value 70 120 53.33333333 Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease 0 12000 1E+30 1259 259259 0 9000 666,6666667 1E+30 0 14500 1700 1000 Constraints Final Shadow Cell Name Value Price SHS10 Usage 70 0 SHS11 Usage 120 666,6666667 SHS12

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!