Math Sux (corrected)
GeeRockchapter_2_homework.xlsx
2-13
Problem 2-13 | |||||
X | Y | ||||
Number of Units | 2.30 | 3.90 | |||
Profit | 2 | 1 | $8.50 | ||
Constraints: | |||||
Constraint # 1 | 3 | 6 | 30.3 | <= | 32 |
Constraint # 2 | 7 | 1 | 20.0 | <= | 20 |
Constraint # 3 | 3 | -1 | 3.0 | >= | 3 |
LHS | Sign | RHS | |||
2-22
Problem 2-22 | |||||
X | Y | ||||
Number of Units | 24 | 4 | |||
Profit | $4 | $7 | $124.00 | ||
Constraints: | |||||
Constraint # 1 | 2 | 3 | 60.0 | >= | 60 |
Constraint # 2 | 4 | 2 | 104.0 | >= | 80 |
Constraint # 3 | 1 | 24.0 | <= | 24 | |
LHS | Sign | RHS | |||
2-28
2.28 - Treetops Hammock | |||||
X | Y | ||||
Double | Single | ||||
Number of Units | |||||
Revenue | $225 | $175 | |||
Direct Labor | $101.25 | $70.00 | |||
Production Cost | $38.75 | $30.00 | |||
Storage | $20 | $20 | |||
Profit | $65 | $55 | $0.00 | ||
Constraints: | |||||
Prod Hours | 3.2 | 2.4 | 0.0 | <= | 960 |
Limited Hammocks | 1 | 0.0 | <= | 200 | |
Total Hammocks | 1 | 1 | 0.0 | <= | 400 |
LHS | Sign | RHS | |||
2-29
2.29 - Latte Problem | |||||
X | Y | ||||
Regular Latte | Low-Fat Latte | ||||
Number of Units | 52 | 48 | |||
Profit | $1.58 | $1.65 | $161.36 | ||
Constraints: | |||||
Shot of Expresso | 1 | 1 | 100.0 | <= | 100 |
Cup 2% Milk | 1 | 52.0 | <= | 60 | |
Cup of Skim Milk | 1.25 | 60.0 | <= | 60 | |
Whipped Cream | 0.5 | 26.0 | <= | 30 | |
LHS | Sign | RHS | |||
2-34
2-34 - Plumbing Manufacturer | |||||
X | Y | ||||
Model A | Model B | ||||
Number of Units | 175 | 35 | |||
Profit | $90 | $70 | $18,200.00 | ||
Constraints: | |||||
Steel | 120 | 100 | 24,500.0 | <= | 24,500 |
Zinc | 20 | 30 | 4550.0 | <= | 6,000 |
Model A vs Model B | 1 | 0 | 175.0 | <= | 175 |
LHS | Sign | RHS | |||
175 | |||||
2-40
Photocopy Machine | |||||||
X | Y | ||||||
Print Jet | Print Desk | Print Pro | |||||
Number of Units | |||||||
Profit | $60.00 | $90.00 | $73.00 | $0.00 | |||
Constraints: | |||||||
Assembly Time | 2.9 | 3.7 | 3.0 | 0.0 | <= | 3600 | |
Testing Time | 1.4 | 2.1 | 1.7 | 0.0 | <= | 2000 | |
Total Production | 0.0 | >= | 0.4 | ||||
LHS | Sign | RHS | |||||
Multiply .40 | |||||||
Multiply .15 | |||||||