Help with Optimization and Decision Support Modeling for Business HW4
Redhand
HW4_Template_Ch7_Integer.xlsxQ1
| Route | ||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |||
| Time (hours) | ||||||||||||
| Total on | ||||||||||||
| Location | Delivery Location on Route? | Route | ||||||||||
| A | >= | |||||||||||
| B | >= | |||||||||||
| C | >= | |||||||||||
| D | >= | |||||||||||
| E | >= | |||||||||||
| F | >= | |||||||||||
| G | >= | |||||||||||
| H | >= | |||||||||||
| I | >= | |||||||||||
| Route | ||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Total | ||
| Do Route? | <= | |||||||||||
| Total Time (hours) |
Q2
| Bellevue School District Computer Purchase | |||||||
| Educomp | Macwin | McElectronics | |||||
| Capacity | Fixed Cost | ||||||
| Fixed Cost | Variable Cost | ||||||
| Variable Cost | Total Cost | ||||||
| x | |||||||
| Total | Computers | ||||||
| Educomp | Macwin | McElectronics | Purchased | Needed | |||
| Number to Purchase | >= | ||||||
| <= | <= | <= | |||||
| Maximum | |||||||
| Use Vendor? |
