Problem $12-12($Algo$)$

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

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

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

Note: Do not round intermediate calculations. Round your answer to $2$ decimal places. Required A

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

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

Required $\backslash ($ B $\backslash )$

Calculate the monthly usage index for each month.

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

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

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

Note: Do not round intermediate calculations. Round your answer to $2$ decimal places.

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

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