Using the below sensitivity report, answer the following questions:

SENSITIVITY REPORT ANALYSIS PROBLEM

a. If this is a LP product mix problem report, how many units of each product should be produced?

b. If one unit of French is force produced, what will happen to the Objective Function value?

c. The Caribbean’s Objective Coefficient is increased to 80. How will the new Objective Function value be determined?

d. Which constraints are binding?

e. If Finishing is decreased by one unit, how will the Objective Function value be affected?

Variable Cells Final Reduced Objective Allowable Allowable Value Cell Name Cost Coefficient Increase Decrease SBS4 Number of units Itallian SCS4 Number of units French SD$4 Number of units Caribbean 120 72 22 3 -4 65 4 1E+30 400 78 4 Constraints Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase 1360 Cell Name Decrease SEST Carpentry SES8 Painting SE$9 Finishing 1360 4 40 95 680 700 1E+30 20 430 80 430 32 90