This is the demand of the ABC company's products.

Month Demand (Actual)

1 65

2 58

3 62

4 78

5 65

6 42

7 45

8 52

9 68

10 54

1.1) Find the forecasting data of week 4 to 11 with 3-period moving average forecasting method.

1.2) Find the forecasting data of week 4 to 11 with 3-period weighted moving average forecasting method (The weights of data are 0.6 for the current period, 0.3 for the previous period, 0.1 for two periods back)

1.3) Find the forecasting data for week 1 to 11 with the exponential method with a =0.5

1.4) From all of forecasting methods above, what is the best method? You need to use MAD for this calculation.

Question 2

Assume that the forecasting data from question 1 is for the assigned company in your project. So, please talk about what are the marketing plan for this company if you want to double its sales volumes. (the length of answers is 8 lines in A4 paper size)

Answer rating: 100% (QA)

The first step is to calculate the 3period moving average the 3period weighted moving average and the exponential smoothing for each of the data provi... View the full answer