Winter Historical Inventory data ...

guru2009
 (Not rated)
 (Not rated)
Chat

        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