Month Units sold Q1) The table below shows the sales of a gaming console for the
ID: 389676 • Letter: M
Question
Month Units sold Q1) The table below shows the sales of a gaming console for the first 6 months of the year 2011 The forecaster uses the weighted average model to determine the forecasts. He assumes a 40% weight for the most recent reading, 30% weight for the second most recent reading, 20% for the third most recent reading, and 10% for the fourth most recent reading. From the given data, determine the forecast for the 5th month. A) 24.20 units B)42.20 units. C) 35.80 units. D) 58.80 units 21 20 30 4 6 Week 1 Units soldQ2) The sales details for 6 weeks of a particular type of switches, called the "Twitch," are shown in the table below. The value of k is set at 2. For the data given above, the forecast for week 5 is A) 35 units B)33 units c)25 units D)30 units 27 4 36 43 6 Q3) The data for the number of guitars sold for the past 6 weeks are 25 units, 20 units, 25 units, 25 units, 20 units, and 18 units respectively. The time series appears to be relatively stable, without trend, seasonal, or cyclical effects; thus, a moving average model would be appropriate. Setting k - 3 the three-period moving average forecast for week 7 i:s A) 21 units B)18 units C)25 units D)19 units be relativel 1 moving average model wouldhesExplanation / Answer
Answer:-
1) Option "A" ------ 24.20 units
Explanation: - Forecast for the 5th month = 33*0.1 + 33*0.2 + 21*0.3 + 20*0.4 = 24.20 units
2) Option "D" ------ 30 units
Explanation: - Where k = 2 means two period moving average, so forecast for week 5 is
= (week 3 + week 4) / 2
= (27 + 33) / 2 = 30 units
3) Option "A" ------ 21 units
Explanation: - Three period moving average forecast for week 7
= (week 4 + week 5 + week 6) / 3
= (25 + 20 + 18) / 3 = 63 / 3 = 21 units.