solution

QUESTION:

  1. Company A wants to test three major forecasting techniques on a historical data that they have in terms of the forecasting accuracy on a certain product’s weekly sales data. They have recorded the sales values in the last 13 weeks and you can see the corresponding value of each week as a time series data in the below table.

Period

Actual

1

141

2

104

3

145

4

147

5

150

6

150

7

132

8

136

9

108

10

103

11

113

12

141

13

121

Please use this historical data to perform the following actions:

  1. Plot the time series as a scatter plot
  1. Make forecasts starting from the 9th period for five periods using moving average method (you can choose n=5; that is the number of historical data points you should use in calculation)
  1. Make forecasts starting from the 9th period for five periods using weighted moving average method (you can use the following weight scheme wt-1= 0.3, wt-1= 0.2, wt-1= 0.2, wt-1= 0.15, wt-1= 0.15 )
  1. Make forecasts starting from the 9th period for five periods using exponential smoothing method (you can use smoothing factor as 0.25 )
  2. Calculate the accuracy metrics we covered in class for all the methods you used above. Make a comparison between the techniques.
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
Looking for a Similar Assignment? Our Experts can help. Use the coupon code SAVE30 to get your first order at 30% off!

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp