(Solved): Problem 12-12 (Algo) Monthly usage data for pallets used in a distribution center are as follows: ...

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. Required A Required B 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.