Question

Question 6 :In the following Excel Solver sensitivity report, some values are missing as shown below.

  

Adjustable Cells
			Final	Reduced	Objective	Allowable	Allowable
	Cell	Name	Value	Cost	Coefficient	Increase	Decrease
	$B$17	lbs used A1 (whole)	525000	j?	0.006667	1E+30	0.0148889
	$C$17	lbs used A2 (juice)	75000		-0.0045	0.0148889	1E+30
	$D$17	lbs used A3 (paste)	k?	-0.02233	0.0048	l?
	$E$17	lbs used B1 (whole)	175000		0.006667	1E+30	0.0148889
	$F$17	lbs used B2 (juice)	225000		-0.0045	0.0132296	1E+30
	$G$17	lbs used B3 (paste)	2000000		0.0048	1E+30	0.0148833
Constraints
			Final	Shadow	Constraint	Allowable	Allowable
	Cell	Name	Value	Price	R.H. Side	Increase	Decrease
	$B$23		m?	0.01225	600000	600000	466666.67
	$B$24			-0.01008	2400000	466666.67	200000
	$B$25		300000	n?	1000000		o?
	$B$26			0.014883	2000000	200000	466666.67
	$B$27			-0.00558	0	466666.67	600000
	$B$28			-0.00558	0	1400000	200000

Determine the values of ONLY those missing items which are shaded in greyAND labeled by a circled number and a question mark.  Please fill in correct values in the space provided below:

1.       

2.

3.

4.

5.

6.

Answer 1

(1) Answer is 0. Reduced cost of A1 is 0 as A is included in the optimal solution
(2) Answer is 0. Final value of A3 is 0 as there is a reduced cost of 0.022333 for A2 which means A3 is not included in the optimal solution
(3) Answer is 0.022333. Allowable increase of A3 is 0.022333 as this much increase in objective coefficient of A3 is needed to make A3 lucrative enough to be included in the optimal solution
(4) Answer is 600000 . There is Shadow price for the constraint which means final value of the constraint matches with constraint R.H side
(5) Answer is 0. Final value is less than Constraint R.H side which means there is slack or unused resource in the constraint causing shadow price to be 0
(6) Answer is 700000. Allowable decrease for the constraint is the amount of slack 1000000-300000 = 700000

NOTE:If you satisfy with this solution.Please give me a thumb up.