Monthly usage data for pallets used in a distribution center are as follows:

a. Calculate the monthly usage index for each month.

b. Use simple linear regression to forecast the total usage of pallets for year 5.

c. Forecast the seasonally adjusted usage for pallets for each month in the year

Year 1 2 3 4 1792 1902 1400 1586 1722 1548 1770 1876 January 1484 1482 February 1394 March 1552 April 1796 1864 2110 2218 2198 2408 2446 2652 ay 2060 2548 June 2214 2844 July 2330 2580 2606 2972 August 2432 2698 2872 3110 September 2416 2682 2946 3208 2592 2906 November 1942 2132 December 1566 October 2262 3200 2340 2806 1802 2046 2418