3. Microsoft Excel 16.0 Sensitivity Report
Variable Cells
			Final	Reduced	Objective	Allowable	Allowable
	Cell	Name	Value	Cost	Coefficient	Increase	Decrease
	$B$2	Decision Values A	0.0	-17.7	25.0	17.7	Unlimited
	$C$2	Decision Values B	6.7	0.0	32.0	Unlimited	13.3
	$D$2	Decision Values C	50.0	0.0	15.0	49.0	Unlimited
Constraints
			Final	Shadow	Constraint	Allowable	Allowable
	Cell	Name	Value	Price	R.H. Side	Increase	Decrease
	$E$6	Assembly Usage	160.0	21.3	160.0	78.8	10.0
	$E$7	Finishing Usage	82.5	0.0	240.0	Unlimited	157.5
	$E$8	Management Rule Usage	50.0	-49.0	50.0	3.3	33.2

(i) Will the optimal solution change if the objective coefficient for decision value B changes from 32 to 20?

(ii) Will the optimal solution change if the objective coefficient for decision value A becomes 45?

(iii) What is the value of one additional unit of assembly usage time?

(iv) Is it worthwhile for one additional unit of assembly time to be acquired for $ 20?

(v) What is the result of decreasing the management rule requirement by one unit, i.e., changing it from 50 to 49 units?