90.2K

Verified Solution

Link Copied!

1. Given below is a fictitious Excel output (numbers might be allmade up) Answer the questions that follow. You are being tested foryour ability to read the output and your skill in sensitivityanalysis as taught in class.)
   

Variable Cells
			Final	Reduced	Objective	Allowable	Allowable
	Cell	Name	Value	Cost	Coefficient	Increase	Decrease
	$B$6	X1	45	0	12	10	8
	$C$6	X2	0	-6	8	15	12
	$D$6	X3	10	0	5	20	15
	$E$6	X4	35	0	6	8	10
Constraints
			Final	Shadow	Constraint	Allowable	Allowable
	Cell	Name	Value	Price	R.H. Side	Increase	Decrease
		Const1	74	        12	74	50	20
		Const2	54	8.5	54	42	40
		Const3	35	-5	35	25	20
		Conts4	80	0	120	30	25

(a)        What is the objectivefunction? You will write the algebraic version like
                         Z= 2X1+ 3X2+…etc (10)




(b)         What is theoptimal solution, and the optimal value of the objective function?(15)

(b)         Can we makethe following change to the RHS of the constraints as follows:(20)

                            const. 1   +20
                            const. 2    -10
                            const. 3     -5

                            
If so, what is the value of the objective function after thechange. (you will show FULL work)