Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Charleston Stores is a retailer of office supplies. The monthly retail demand for a product is provided below from January 2021 to October 2022. Demand
Charleston Stores is a retailer of office supplies. The monthly retail demand for a product is provided below from January 2021 to October 2022.
Demand Data | Year | |
Month | 2021 | 2022 |
January | 616 | 758 |
February | 832 | 974 |
March | 898 | 940 |
April | 964 | 1126 |
May | 880 | 1032 |
June | 1016 | 988 |
July | 912 | 1004 |
August | 828 | 870 |
September | 894 | 1056 |
October | 850 | 1020 |
November | 1010 | |
December | 969 |
- Use the nave method to forecast the demand for November and December 2022.
- Use the moving average method with 4 periods to forecast the demand for November and December 2022.
- Use the exponential smoothing method with smoothing constant 0.7 to forecast the demand for November and December 2022. Initialize the forecasting method using the actual demand in January 2021.
- Fit a trend line to the demand data from January 2021 to December 2021. What is the trend line equation?
- What is the forecasted demand for November and December 2022 if you use this trend line equation?
- How reliable is this forecast from a statistical perspective?
- Compute the MAD of the trend line method used in part (d). Use the forecasts from January 2022 to October 2022 to compute the MAD of the method.
- What is the interpretation of MAD?
- Explain clearly why it is important to compute and track forecast accuracy.
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