Year 1 2 3 4 Sales 5.2 4.9 5.5 4.9 Year 13 14 15 16 56789...

 

Transcribed Image Text:

Year 1 2 3 4 Sales 5.2 4.9 5.5 4.9 Year 13 14 15 16 56789 10 11 12 5.2 5.7 5.4 5.8 5.9 6.0 5.2 4.8 17 18 19 20 21 22 23 24 Sales 4.6 5.9 5.0 4.7 5.6 7.4 8.7 9.6 6.4 7.7 9.8 9.9 Year 25 26 27 28 29 30 31 32 33 34 35 36 Sales 5.8 7.7 5.7 9.7 9.6 9.0 7.9 8.9 8.7 9.0 9.9 8.4 i. Calculate the 5-year Weighted Moving Average forecast. ii. Calculate the 6-year Weighted Moving Average forecast. iii. Calculate the MSE and MAD for each year weighted. Year 1 2 3 4 Sales 5.2 4.9 5.5 4.9 Year 13 14 15 16 56789 10 11 12 5.2 5.7 5.4 5.8 5.9 6.0 5.2 4.8 17 18 19 20 21 22 23 24 Sales 4.6 5.9 5.0 4.7 5.6 7.4 8.7 9.6 6.4 7.7 9.8 9.9 Year 25 26 27 28 29 30 31 32 33 34 35 36 Sales 5.8 7.7 5.7 9.7 9.6 9.0 7.9 8.9 8.7 9.0 9.9 8.4 i. Calculate the 5-year Weighted Moving Average forecast. ii. Calculate the 6-year Weighted Moving Average forecast. iii. Calculate the MSE and MAD for each year weighted.