bus

	Doubles	Singles	Total	Inequality	Constraint
Variables	150	200
Labor	3.2	2.4	=SUMPRODUCT(B$3:C$3,B4:C4)	<=	960
Single		1	=SUMPRODUCT(B$3:C$3,B5:C5)	<=	200
Combination	1	1	=SUMPRODUCT(B$3:C$3,B6:C6)	<=	400
Production Cost	38.75	30
Labor Cost	101.25	70
Equipment	20	20
Selling Price	225	175
Profit	=B11-B10-B9-B8	=C11-C10-C9-C8	=SUMPRODUCT(B$3:C$3,B13:C13)

 

"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"