Winter Historical Inventory data ...
(Not rated)
(Not rated)
Convert the following data into an index and carry out the forecast. Actual Demands (in units) Month Year 1 Year 2 Year 3 Year 4 1 55200 39800 32180 62300 2 57350 64100 38600 66500 3 15400 47600 25020 31400 4 27700 43050 51300 36500 5 21400 39300 31790 16800 6 17100 10300 31100 18900 7 18000 45100 59800 35500 8 19800 46530 30740 51250 9 15700 22100 47800 34400 10 53600 41350 73890 68000 11 83200 46000 60200 68100 12 72900 41800 55200 61100
7 years ago
(a) Find seasonal indexes and get deseasonalized inventory units ...
NOT RATED
Purchase the answer to view it
- WinterHistoricalInventoryDataTypicalSeasonalDemandforWinterHighs.xls