statistics
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) | ||||