Question
Weighted Moving Average Forecast Compute the sales forecast for the month of January 2023 using the Weighted Moving Average forecasting technique and the last 6
Weighted Moving Average Forecast
Compute the sales forecast for the month of January 2023using the Weighted Moving Average forecasting technique and the last 6 months of 2022data with the following monthly weights:
Weights: 0.40 for the previous month, 0.20 for 2 months prior, 0.10 for 3 months prior, 0.10 for 4 months prior, 0.10 for 5 months prior, and 0.10 for 6 months prior.
Monthly sales for the RUOK Company for the last 12 months are as follows:
MONTH | ACTUAL SALES |
January 2022 | 140,235 |
February 2022 | 116,550 |
March 2022 | 78,225 |
April 2022 | 63,045 |
May 2022 | 17,460 |
June 2022 | 122,400 |
July 2022 | 16,980 |
August 2022 | 41,850 |
September 2022 | 57,270 |
October 2022 | 73,820 |
November 2022 | 33,780 |
December 2022 | 79,830 |
MONTH | FORECAST |
January 2023 | ??,??? |
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