Question
Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of
Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here.
ACTUAL | |
June | 148 |
July | 188 |
August | 212 |
a. | Using a simple three-month moving average, what is the forecast for September? (Round your answer to 2 decimal places.) |
Forecast for September |
b. | Using a weighted moving average, what is the forecast for September with weights of 0.20, 0.30, and 0.50 for June, July, and August, respectively? (Do not round intermediate calculations. Round your answer to 2 decimal places.) |
Forecast for September |
c. | Using single exponential smoothing and assuming that the forecast for June had been 142, forecast sales for September with a smoothing constant alpha of 0.30. (Round your answer to 2 decimal places.) |
Forecast for September |
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