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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!