Consider the following Linear Programming problem, in which X and Y denote the number of units of products X and Y to be produced, respectively, and Z denotes the overall resulting profit

Objective Function

Maximize Z = $4X + $5Y

Subject To

X + 2Y 10 (labor available, in hours)

6X + 6Y 36 (material available, in pounds)

8X + 4Y 40 (storage available, in square feet)

X, Y 0

The Excel Sensitivity Report for this problem is given below. Answer the following questions and provide calculations of your answers. Each question is independent of the others.

Adjustable Cells
	Cell	Name	Final Value	Reduced Cost	Objective Coefficient	Allowable Increase	Allowable Decrease
	$C$5	X	2	0	4	1	1.5
	$D$5	Y	4	0	5	3	1
Constraints
	Cell	Name	Final Value	Shadow Price	Constraint R.H. Side	Allowable Increase	Allowable Decrease
	$E$7	Labor	10	1	10	2	2
	$E$8	Material	36	0.5	36	4	6
	$E$9	Storage	32	0	40	1E+30	8

(A) How much excess labor and storage capacity there are in the optimal solution? Provide your answers in numerical digits only. Approximate to two decimal digits if needed. ANSWER: Excess Labor = ----Hours ANSWER: Excess Storage = ------Square Feet (B) How does the total profit change if you give up 1 hour of labor and get additional 1.5 pounds of material? ANSWER: The profit would----- by $----- (C) How does the total profit change if you decided to introduce a new product that has a profit contribution of $2 per unit, given that each unit of this product will use 1 hour of labor, 1 pound of material, and 2 square feet of storage? ANSWER: The profit would------by $ -----.