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

1. Does the optimal solution change if the unit profit of X1 changes to $380 per unit? If yes, then what is the new Objective Function Value? Show your work.
2. 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.
3. Does the optimal solution change if the unit profit of X3 changes to $1700 per unit? If yes, then what is the new Objective Function Value? Show your work.
4. Does the optimal solution change if the unit profit of X4 changes to $1000 per unit? If yes, then what is the new Objective Function Value? Show your work.
5. Does the optimal solution change if the unit profit of X1 changes to $500 per unit and at the same time the unit profit on X2 changes to $600? If yes, then what is the new Objective Function Value? Show your work.
6. Does the optimal solution change if the unit profit of X1 changes to $450 per unit, the unit profit on X2 changes to $1100, and the unit profit on X4 changes to $650? If yes, then what is the new Objective Function Value? Show your work.
7. Does the optimal solution change if the amount of Material (a resource constraint) increases to 400 lbs.? If yes, then what is the new Objective Function Value? Show your work.
8. Does the optimal solution change if the amount of Machine Hours (a resource constraint) decreases to 153 hours? If yes, then what is the new Objective Function Value? Show your work.
9. Does the optimal solution change if the amount of Labor Hours (a resource constraint) increases to 400 hours? If yes, then what is the new Objective Function Value? Show your work.
10. Does the optimal solution change if the amount of Inspection Hours (a resource constraint) decreases to 38 hours? If yes, then what is the new Objective Function Value? Show your work.
11. Does the optimal solution change if the amount of Inspection Hours (a resource constraint) increases to 41 hours? If yes, then what is the new Objective Function Value? Show your work.
12. 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.
13. 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.
14. 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