Question: Please Help ! Thank You 3. [25 Pt. Below tables show the answer Report and the Sensitivity Report of the optimization problem. Based on these

Please Help ! Thank You
Please Help ! Thank You 3. [25 Pt. Below tables
Please Help ! Thank You 3. [25 Pt. Below tables
Please Help ! Thank You 3. [25 Pt. Below tables
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 Pt.) Write the objective function. b) |3 Pt. What is the z value (objective function's value) c) 14 Pt.1 Identify the sensitivity ranges for the objective function. d) [3 Pt.) Write the constraint quantity values. ) 14 Pt. Identify the sensitivity ranges for the constraint quantity values. D 13 Pt.) How many shadow prices are there? g) [4 Pt. What is the unknown shadow price? (Shown as yellow) Objective Cell (Min) Cell Name Original Value $B$18 Cost= 2693333.33 Final Value 2693333.33 Variable Cells Cell Name Original Value $B$15 x1 70.00 $B$16 X2 120.00 $B$17 x3 53.33 Final Value Integer 70.00 Contin 120.00 Contin 53.33 Contin Constraints Cell Name SH$10 Usage SHS8 >= Usage SH$9 >= Usage Cell Value Formula Status Slack 70 SH$10=$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 $B$15 x1 SB$16 x2 $B$17 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 Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SH$10 = Usage 70 1259.259259 70 4.5 70 SH$8 >= Usage 120 50 70 1E+30 SHS9 >= Usage 53.33333333 0 50 3.333333333 1E+30

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!