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

$\backslash$table$[[$Month$,1,2,3,4],[$January$,1,484,1,482,1,792,1,902],[$February$,1,394,1,400,1,586,1,722],[$March$,1,552,1,548,1,770,1,876],[$April$,1,796,1,864,2,110,2,218],[$May$,2,060,2,198,2,408,2,548],[$June$,2,214,2,446,2,652,2,844],[$July$,2,330,2,580,2,606,2,972],[$August$,2,432,2,698,2,872,3,110],[$September$,2,416,2,682,2,946,3,208],[$October$,2,262,2,592,2,906,3,200],[$November$,1,942,2,132,2,340,2,806],[$December$,1,566,1,802,2,046,2,418]]$

Click here for the Excel Data File

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.$

Required A

Required B

Required $C$

Calculate the monthly usage index for each month.

Note: Do not round intermediate calculations. Round your answers to $3$ decimal places.