Objective Cell (Max)
	Cell	Name	Original Value	Final Value
	$I$7	Max	80888.89	80888.89
Variable Cells
	Cell	Name	Original Value	Final Value	Integer
	$E$6	X1	111.1	111.1	Contin
	$F$6	X2	4	4	Contin
	$G$6	X3	0	0	Contin
	$H$6	X4	36.9	36.9	Contin
Constraints
	Cell	Name	Cell Value	Formula	Status	Slack
	$K$9	Material	300	$K$9<=$M$9	Binding	0
	$K$10	Machine Hours	156	$K$10<=$M$10	Not Binding	4
	$K$11	Labor Hours	192.9	$K$11<=$M$11	Not Binding	87.1
	$K$12	Inspection Hours	40	$K$12<=$M$12	Binding	0
	$K$13	Shipping	2500	$K$13<=$M$13	Binding	0

Variable Cells
			Final	Reduced	Objective	Allowable	Allowable
	Cell	Name	Value	Cost	Coefficient	Increase	Decrease
	$E$6	X1	111.1	0	500	100	140
	$F$6	X2	4	0	800	583.3	500
	$G$6	X3	0	-704.4	1000	704.4	1E+30
	$H$6	X4	36.9	0	600	500	100
Constraints
			Final	Shadow	Constraint	Allowable	Allowable
	Cell	Name	Value	Price	R.H. Side	Increase	Decrease
	$K$9	Material	300	116.7	300	20	133.3
	$K$10	Machine Hours	156	0	160	1E+30	4
	$K$11	Labor Hours	192.9	0	280	1E+30	87.1
	$K$12	Inspection Hours	40	800	40	1.7	2.5
	$K$13	Shipping	2500	5.6	2500	1568	664

Answer the following questions without re-running Solver. Place your answer in the adjacent box. Please note that if there is not enough information available to answer a question without re-running Solver then answer the question with the caption, Not enough information. Show your math work if the answer requires math to assess.

1. Does the optimal solution change if the unit profit of X2 changes to $1400 per unit? If yes, then what is the new Objective Function Value? Show your work.
2. Does the optimal solution change if the Shipping budget (a resource constraint) increases to $4000? If yes, then what is the new Objective Function Value? Show your work.
3. Does the optimal solution change if the following resource constraints change simultaneously:Shipping budget decreases to $2000 and the amount of available Material decreases to 200. Show your work.
4. Does the optimal solution change if the following resource constraints change simultaneously:The Shipping budget increases to $3000, the amount of available Material decreases to 270 lbs., and the available Inspection hours increase to 41 hours. Show your work