Help with Optimization and Decision Support Modeling for Business HW2
Redhand
HW2_Template.xlsxQ2-b
| Full Time | Full Time | Full Time | Part Time | Part Time | Part Time | Part Time | ||||
| 8am-4pm | noon-8pm | 4pm-midnight | 8am-noon | noon-4pm | 4pm-8pm | 8pm-midnight | ||||
| Cost per Shift | ||||||||||
| Total | Total | |||||||||
| Shift Covers Time of Day? (1=yes, 0=no) | Working | Needed | ||||||||
| 8am-noon | >= | |||||||||
| noon-4pm | >= | |||||||||
| 4pm-8pm | >= | |||||||||
| 8pm-midnight | >= | |||||||||
| Workers per Shift | ||||||||||
| Total | Times Total | Total | ||||||||
| Time of Day | Full Time | Part Time | Cost | |||||||
| 8am-noon | >= | |||||||||
| noon-4pm | >= | |||||||||
| 4pm-8pm | >= | |||||||||
| 8pm-midnight | >= |
Q3-a
| Large | Medium | Small | ||||||||
| Unit Profit | ||||||||||
| Space Required | ||||||||||
| (sq.ft. per unit) | ||||||||||
| Total | Space | Space | ||||||||
| Production | Large | Medium | Small | Produced | Capacity | Required | Available | |||
| Plant 1 | <= | <= | ||||||||
| Plant 2 | <= | <= | ||||||||
| Plant 3 | <= | <= | ||||||||
| Total Produced | ||||||||||
| <= | <= | <= | Total Profit | |||||||
| Sales Forecast | ||||||||||
| Percentage of Plant 1 Capacity | = | Percentage of Plant 2 Capacity | ||||||||
| Percentage of Plant 1 Capacity | = | Percentage of Plant 3 Capacity |
Q4
| Unit Cost | Retail Outlet | |||||||
| 1 | 2 | 3 | 4 | |||||
| 1 | ||||||||
| Plant | 2 | |||||||
| 3 | ||||||||
| 4 | ||||||||
| Shipments | Retail Outlet | |||||||
| 1 | 2 | 3 | 4 | Total Shipped | Supply | |||
| 1 | = | |||||||
| Plant | 2 | = | ||||||
| 3 | = | |||||||
| 4 | = | |||||||
| Total Received | ||||||||
| = | = | = | = | Total Cost | ||||
| Demand |
Q5
| Unit Cost | Port | |||||||
| 1 | 2 | 3 | 4 | |||||
| 1 | ||||||||
| Ship | 2 | |||||||
| 3 | ||||||||
| 4 | ||||||||
| Assignments | Port | Total | ||||||
| 1 | 2 | 3 | 4 | Assignments | Supply | |||
| 1 | = | |||||||
| Ship | 2 | = | ||||||
| 3 | = | |||||||
| 4 | = | |||||||
| Total Assigned | ||||||||
| = | = | = | = | Total Cost | ||||
| Demand |
