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 functions value)

c) Identify the sensitivity ranges for the objective function.

d) Write the constraint quantity values.

e) Identify the sensitivity ranges for the constraint quantity values.

f) How many shadow prices are there?

g) What is the unknown shadow price? (Shown as yellow)

Objective Cell (Min) Cell Name Original Value Final Value $B$18 Cost= 2693333.33 2693333.33 Variable Cells Cell Name Original Value Final Value Integer $B$15 x1 70.00 70.00 Contin $B$16 x2 120.00 120.00 Contin $B$17 x3 53.33 53.33 Contin Constraints Cell Name SHS10 = Usage SHS8 >= Usage SH$9 >= Usage Cell Value Formula Status Slack 70 SH$10=$G$7 Binding 0 120 $H$8>=$G$8 Not Binding 70 53.33 $H$9>=$G$9 Not Binding 3.33 Variable Cells Cell Name $B$15 x1 $B$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 SH$9 >= Usage 53.33333333 0 50 3.333333333 1E+30 70 Objective Cell (Min) Cell Name Original Value Final Value $B$18 Cost= 2693333.33 2693333.33 Variable Cells Cell Name Original Value Final Value Integer $B$15 x1 70.00 70.00 Contin $B$16 x2 120.00 120.00 Contin $B$17 x3 53.33 53.33 Contin Constraints Cell Name SHS10 = Usage SHS8 >= Usage SH$9 >= Usage Cell Value Formula Status Slack 70 SH$10=$G$7 Binding 0 120 $H$8>=$G$8 Not Binding 70 53.33 $H$9>=$G$9 Not Binding 3.33 Variable Cells Cell Name $B$15 x1 $B$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 SH$9 >= Usage 53.33333333 0 50 3.333333333 1E+30 70