Question
SAM SALES FIGURE MONTH UNIT SALES FIGURE JAN 14 FEB 16 MARCH 23 APRIL 25 MAY 24 a) Make a forecast for June using a
SAM SALES FIGURE
MONTH | UNIT SALES FIGURE |
JAN | 14 |
FEB | 16 |
MARCH | 23 |
APRIL | 25 |
MAY | 24 |
a) Make a forecast for June using a three-period moving average and a four-period moving average. (Clearly show all formulas and calculations and round to one decimal place).
b) Using the data presented above, what will be the forecast for July (using both the three-period moving average and four-period moving average) if the actual unit sales figure for June turns out to be 20? (Clearly show all formulas and calculations and round to one decimal place).
c) Using the data presented above, what will be the forecasts for June and July using the exponential smoothing method? Compile two different forecasts for both months (four forecasts in all) using alpha values of 0.1 and 0.6 and with a forecast value for May of 23; actual sales for June would be 20. (Clearly show all formulas and calculations and round to one decimal place).
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