Monthly usage data for pallets used in a distribution center are as follows:
|
Year
|
1
|
2
|
3
|
4
|
|
January
|
1484
|
1482
|
1792
|
1902
|
|
February
|
1394
|
1400
|
1586
|
1722
|
|
March
|
1552
|
1548
|
1770
|
1876
|
|
April
|
1796
|
1864
|
2110
|
2218
|
|
May
|
2060
|
2198
|
2408
|
2548
|
|
June
|
2214
|
2446
|
2652
|
2844
|
|
July
|
2330
|
2580
|
2606
|
2972
|
|
August
|
2432
|
2698
|
2872
|
3110
|
|
September
|
2416
|
2682
|
2946
|
3208
|
|
October
|
2262
|
2592
|
2906
|
3200
|
|
November
|
1942
|
2132
|
2340
|
2806
|
|
December
|
1566
|
1802
|
2046
|
2418
|
a. Calculate the monthly usage index for each month.
b. Use simple linear regression to forecast total usage of pallets for year 5.
c. Forecast the seasonally adjusted usage for pallets for each month in year 5.