The sales data of 3 different product families of a company in the last 3 years is given in Table 1 in monthly units. The number of monthly production days, safety stocks, costs and capacity values for the 3 product families are given in the Table 2 and Table 3.
-
By using the estimated sales values, and considering inventory holding/stockout, regular/overtime working, labor hiring/layoff and subcontracting, apply different strategies (Level, Chase and Mixed) and determine the Aggregate Production Plan with the lowest cost for the 12 months of 2021. Comment on your results.(you can do with excel then upload photo here, thank you)
Table 1. Sales quantities of three product families for 2019, 2020, 2021 (units). Table 3. Production costs and capacities for each product family. Table 2. Production days and desired safety stock amounts Safety Safety Safety Production stock for MONTH stock for stock for days Volkswage Skoda n 2019 2020 2021 Audi Skoda Volkswagen Units Audi n MONTH Audi 21 160 140 90 70 60 20 140 90 140 Skoda Volkswagel Audi 1580 1423 1155 1702 1506 1266 1878 1626 1334 Skoda Volkswagen 1563 2981 1291 1525 1286 1413 1999 1608 1487 160 160 120 25 23 140 90 30 21 160 140 90 290 198 1626 1334 1973 22 160 140 90 480 520 1590 1609 1633 2001 22 160 140 1487 1493 1282 200 January February March April May June July August September October November 150 Skoda Volkswagei Audi 1558 1408 932 1676 1488 942 1852 1608 1256 1779 1558 1250 1740 1532 1247 1483 1357 926 1612 1445 937 1728 1524 946 1755 1542 1148 1884 1630 1159 1667 1482 941 1878 1888 1692 1499 1339 965 January February March April May June July August September October November December 90 110 Inventory holding cost Inventory stockout cost Regular work cost Overtime cost Subcontracting cost Regular work capacity Overtime capacity Subcontracting capacity Labor hiring cost Labor layoff cost Beginning inventory Labor productivity 30 $/unit*mont 60 $/unit*mont 65 $/unit 189 $/unit 550 $/unit 120 unit/day 77 unit/day 40 unit/day 3000 $/labor 2500 $/labor 90 unit 9 unit/day 1499 1604 1339 21 200 160 143 100 1368 948 1641 1365 1263 23 200 160 110 77 100 3000 1458 960 2046 1640 22 200 3000 1632 1845 1276 1527 160 160 110 110 1370 2020 1622 21 200 3600 3100 1603 1534 1743 2063 1652 1494 22 110 160 1340 1175 200 200 160 160 140 7 1558 1408 1846 1504 1313 22 110 6 Table 1. Sales quantities of three product families for 2019, 2020, 2021 (units). Table 3. Production costs and capacities for each product family. Table 2. Production days and desired safety stock amounts Safety Safety Safety Production stock for MONTH stock for stock for days Volkswage Skoda n 2019 2020 2021 Audi Skoda Volkswagen Units Audi n MONTH Audi 21 160 140 90 70 60 20 140 90 140 Skoda Volkswagel Audi 1580 1423 1155 1702 1506 1266 1878 1626 1334 Skoda Volkswagen 1563 2981 1291 1525 1286 1413 1999 1608 1487 160 160 120 25 23 140 90 30 21 160 140 90 290 198 1626 1334 1973 22 160 140 90 480 520 1590 1609 1633 2001 22 160 140 1487 1493 1282 200 January February March April May June July August September October November 150 Skoda Volkswagei Audi 1558 1408 932 1676 1488 942 1852 1608 1256 1779 1558 1250 1740 1532 1247 1483 1357 926 1612 1445 937 1728 1524 946 1755 1542 1148 1884 1630 1159 1667 1482 941 1878 1888 1692 1499 1339 965 January February March April May June July August September October November December 90 110 Inventory holding cost Inventory stockout cost Regular work cost Overtime cost Subcontracting cost Regular work capacity Overtime capacity Subcontracting capacity Labor hiring cost Labor layoff cost Beginning inventory Labor productivity 30 $/unit*mont 60 $/unit*mont 65 $/unit 189 $/unit 550 $/unit 120 unit/day 77 unit/day 40 unit/day 3000 $/labor 2500 $/labor 90 unit 9 unit/day 1499 1604 1339 21 200 160 143 100 1368 948 1641 1365 1263 23 200 160 110 77 100 3000 1458 960 2046 1640 22 200 3000 1632 1845 1276 1527 160 160 110 110 1370 2020 1622 21 200 3600 3100 1603 1534 1743 2063 1652 1494 22 110 160 1340 1175 200 200 160 160 140 7 1558 1408 1846 1504 1313 22 110 6
