Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started