bus

DoublesSinglesTotalInequalityConstraint
Variables150200
Labor3.22.4=SUMPRODUCT(B$3:C$3,B4:C4)<=960
Single1=SUMPRODUCT(B$3:C$3,B5:C5)<=200
Combination11=SUMPRODUCT(B$3:C$3,B6:C6)<=400
Production Cost38.7530
Labor Cost101.2570
Equipment2020
Selling Price225175
Profit=B11-B10-B9-B8=C11-C10-C9-C8=SUMPRODUCT(B$3:C$3,B13:C13)