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

1a. What is the optimal production plan?

1b. How many units of X1 are to be produced?

1c. How many units of X2 are to be produced?

1d. How many units of X3 are to be produced?

1e. How many units of X4 are to be produced?

2. What is the expected profit from this production plan?

3.What constraints are binding? (Circle your answer

):

3a. Material binding: yes or no

3b. Machine Hours binding: yes or no

3c. Labor Hours binding: yes or no

3d. Inspection Hours binding: yes or no

3e. Shipping binding: yes or no

** No other data given