Question
A). Develop forecasts for periods 7 through 10 for the demand data in the table using a three period moving average, a weighted moving average
A). Develop forecasts for periods 7 through 10 for the demand data in the table using a three period moving average, a weighted moving average using 0.6, 0.3, and 0.1, and exponential smoothing with alpha = 0.7.
Use a 6thperiod forecast of 135 as the starting point for the exponential smoothing technique. (2 + 3 + 8 marks)
Period | Actual | MA n = 3 | WMA | Exp. Smoothing |
1 | 64 | |||
2 | 84 | |||
3 | 91 | |||
4 | 97 | |||
5 | 115 | |||
6 | 135 | |||
7 | 137 | |||
8 | 144 | |||
9 | 153 | |||
10 | 171 |
B). The Fast Track Ski Shoppe sells ski goggles during the four months of the ski season. Average demandfollows:
a.Calculatethedeseasonalizedsalesandtheseasonalindexforeachofthefourmonths. (4 marks)
b.Ifnextyear'sdemandisforecastat1200pairsofgoggles,whatwillbetheforecast sales for eachmonth?(8 marks)
Month | Average Past Demand | Seasonal Index | Forecast Demand Next Year |
December | 300 | ||
January | 400 | ||
February | 200 | ||
March | 150 | ||
Total |
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