1 Tyremart has collected the data on sales of one of their tyres over the last...

 

Transcribed Image Text:

1 Tyremart has collected the data on sales of one of their tyres over the last ten months. Calculate the forecast of sales from month 6 to month 10 using a three- month weighted moving average technique with weights of 0.20, 0.30 and 0.50: 2 The sales of Samsung galaxy watches at Samsung Mall of Africa for the past 10 months are shown below. Management prepared a forecast using a combination of exponential smoothing and its collective judgement. Complete the table below so as to determine the mean absolute deviation and the tracking signal of their forecasting technique: Month 1 2 3 4 5 678 4 5 6 7 Month 1 2 3 8 9 10 Sales 20 22 30 45 15 18 50 16 24 36 9 10 Actual Forecast Forecast Demand Demand Error 20 22 26 23 27 29 25 30 32 29 20 20 21 24 25 27 28 29 29 30 Absolute Cumulative Cumulative Cumulative forecast Absolute Mean error Forecast Error Forecast Error/RSFE Absolute Deviation (5) (12) Tracking Signal 1 Tyremart has collected the data on sales of one of their tyres over the last ten months. Calculate the forecast of sales from month 6 to month 10 using a three- month weighted moving average technique with weights of 0.20, 0.30 and 0.50: 2 The sales of Samsung galaxy watches at Samsung Mall of Africa for the past 10 months are shown below. Management prepared a forecast using a combination of exponential smoothing and its collective judgement. Complete the table below so as to determine the mean absolute deviation and the tracking signal of their forecasting technique: Month 1 2 3 4 5 678 4 5 6 7 Month 1 2 3 8 9 10 Sales 20 22 30 45 15 18 50 16 24 36 9 10 Actual Forecast Forecast Demand Demand Error 20 22 26 23 27 29 25 30 32 29 20 20 21 24 25 27 28 29 29 30 Absolute Cumulative Cumulative Cumulative forecast Absolute Mean error Forecast Error Forecast Error/RSFE Absolute Deviation (5) (12) Tracking Signal

Answer rating: 100% (QA)

1 To calculate the forecast of sales for month 10 using the threemonth weighted average technique you need to take the average of the sales data for t... View the full answer