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)

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 e Final Value SB$18 Cost= 2693333.33 2693333.33 Variable Cells Cell Name Original Value Final Value Integer SB$15 x1 70.00 70.00 Contin SB$16 x2 120.00 120.00 Contin SB$17 x3 53.33 53.33 Contin Constraints Cell Name Cell Value Formula Status Slack SH$10 = Usage 70 SH$7>=$G$7 Binding 0 SH$8 >= Usage 120 SH$8>=$G$8 Not Binding 70 SH$9 >= Usage 53.33 SH$9>=$G$9 Not Binding 3.33 Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$15 x1 70 12000 E+30 1259.259259 $B$16 x2 120 9000 666.6666667 E+30 O SB$17 x3 53.33333333 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 IE+30 SH$9 >= Usage 53.33333333 0 50 3.333333333 1E+30