Help with Optimization and Decision Support Modeling for Business HW1
Redhand
M2_PracticeProblems_Ch2_Solution.xlsxQ1-d
| First Friend | Second Friend | ||||
| Unit Profit | $9,000 | $9,000 | |||
| Resource | Resource | ||||
| Resource Usage | Used | Available | |||
| Money | $10,000 | $8,000 | $12,000 | <= | $12,000 |
| Work Hours | 400 | 500 | 600 | <= | 600 |
| First Friend | Second Friend | Total Profit | |||
| Share | 0.667 | 0.667 | $12,000 | ||
| <= | <= | ||||
| 1 | 1 |
Q3-c
| Frankfurters | Buns | ||||
| Unit Profit | $0.40 | $0.20 | |||
| Resource | Resource | ||||
| Resource Usage | Used | Available | |||
| Flour | 0 | 0.1 | 120 | <= | 200 |
| Pork | 0.25 | 0 | 800 | <= | 800 |
| Work Hours | 3 | 2 | 12,000 | <= | 12,000 |
| Frankfurters | Buns | Total Profit | |||
| Decision | 3,200 | 1,200 | $1,520 |
Q4-a
| Beef | Gravy | Peas | Carrots | Roll | ||||||
| Unit Cost | $0.40 | $0.35 | $0.15 | $0.18 | $0.10 | |||||
| (per ounce) | ||||||||||
| Nutritional Data (per ounce) | Total in Diet | Needed | Maximum | |||||||
| Calories | 54 | 20 | 15 | 8 | 40 | 320.0000000096 | >= | 280 | <= | 320 |
| Fat Calories | 19 | 15 | 0 | 0 | 10 | 95.9999999969 | ||||
| Vitamin A (IU) | 0 | 0 | 15 | 350 | 0 | 600 | >= | 600 | ||
| Vitamin C (mg) | 0 | 1 | 3 | 1 | 0 | 12.38 | >= | 10 | ||
| Protein (g) | 8 | 0 | 1 | 1 | 1 | 29.9999999984 | >= | 30 | ||
| Beef | Gravy | Peas | Carrots | Roll | Total Cost | |||||
| Diet (ounces) | 2.94 | 1.47 | 3.11 | 1.58 | 1.82 | $2.62 | ||||
| >= | ||||||||||
| Minimums | 2 | |||||||||
| Fat Calories | 96 | <= | 96.0000000029 | 30% | of Total Calories | |||||
| Gravy | 1.47 | >= | 1.47 | 50% | of Beef |
Q5-d
| Activity 1 | Activity 2 | ||||
| Unit Cost | 40 | 50 | |||
| Totals | Limit | ||||
| Constraint 1 | 2 | 3 | 30 | >= | 30 |
| Constraint 2 | 1 | 1 | 12.5 | >= | 12 |
| Constraint 3 | 2 | 1 | 20 | >= | 20 |
| Activity 1 | Activity 2 | Total Cost | |||
| Decision | 7.5 | 5 | 550 |
Q5-e(b)
| Activity 1 | Activity 2 | ||||
| Unit Cost | 40 | 70 | |||
| Totals | Limit | ||||
| Constraint 1 | 2 | 3 | 30 | >= | 30 |
| Constraint 2 | 1 | 1 | 15 | >= | 12 |
| Constraint 3 | 2 | 1 | 30 | >= | 20 |
| Activity 1 | Activity 2 | Total Cost | |||
| Decision | 15 | 0 | 600 |
Q5-e(c)
| Activity 1 | Activity 2 | ||||
| Unit Cost | 40 | 50 | |||
| Totals | Limit | ||||
| Constraint 1 | 2 | 3 | 30 | >= | 30 |
| Constraint 2 | 1 | 1 | 12 | >= | 12 |
| Constraint 3 | 2 | 1 | 18 | >= | 15 |
| Activity 1 | Activity 2 | Total Cost | |||
| Decision | 6 | 6 | 540 |
