Question: Monthly usage data for pallets used in a distribution center are as follows: Month 1 2 3 4 January 1937 1815 1413 1809 February 1886

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

Month 1 2 3 4
January 1937 1815 1413 1809
February 1886 1938 1516 1526
March 1645 1494 1763 1807
April 2464 1954 2344 2455
May 2332 2720 2858 2480
June 2236 2215 2203 2129
July 2061 2140 2908 2815
August 2206 2589 2549 2018
September 2683 1918 2086 2771
October 2085 2015 2921 2309
November 2949 2327 2670 2281
December 1904 2813 2873 2860

a. Calculate the monthly usage index for each month. (Do not round intermediate calculations. Round your answers to 3 decimal places.)

b. Use simple linear regression to forecast total usage of pallets. (Do not round intermediate calculations. Round your answer to 3 decimal places.)

c. Forecast the seasonally adjusted usage for pallets for each month in year 5. (Do not round intermediate calculations. Round your answers to 3 decimal places.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!