Aggregate planning
el
hw1_2014_data_new.xlsxData
| Aggregate planning in Union brewery | ||||||
| Don't miss the commnets in the cells below! | ||||||
| Table 1: Sales data for the regular Union (0.5 liter can) in 1000s for the last 3 years | ||||||
| Units (where 1 unit is 1000 products) | ||||||
| month | 2011 | 2012 | 2013 | 2014 | ||
| Jan | 493 | 498 | 564 | |||
| Feb | 415 | 389 | 604 | |||
| Mar | 635 | 880 | 1088 | |||
| Apr | 895 | 1198 | 1267 | |||
| May | 1004 | 902 | 1145 | |||
| Jun | 1236 | 1321 | 1261 | |||
| Jul | 1610 | 1567 | 1485 | |||
| Avg | 1781 | 1926 | 2061 | |||
| Sep | 1504 | 1727 | 1901 | |||
| Oct | 1076 | 1319 | 1402 | |||
| Nov | 338 | 287 | 215 | |||
| Dec | 255 | 303 | 578 | |||
| Tabela 2: Data on production and cost parameters | ||||||
| Starting number of workers | 18 | |||||
| Worker capacity (units/worker/month) | 40 | |||||
| Number of regular hours/month | 176 | |||||
| Starting inventory | 230 | |||||
| Safety stock Jakšič, Marko: Safety stock should equal a given % of predicted sales in that month (this means that the safety stock level will be changing from month to month according to the predicted sales). | 20% | of predicted monthly sales | ||||
| Cost of regular work (€/hour) | 8 | |||||
| Cost of hiring (€/worker) | 800 | |||||
| Cost of letting off (€/worker) | 1000 | |||||
| Inventory holding cost (€/unit/month) | 2 |
