Question

1. The table below shows the monthly sales of a motorcycle store during the last two years. The commission for each motorcycle sale is $1,000. The manager wants to estimate how much money he will need for month 25.

Month	Sales		Month	Sales
1	195		13	155
2	210		14	120
3	190		15	135
4	170		16	110
5	180		17	122
6	156		18	97
7	134		19	85
8	155		20	110
9	145		21	85
10	165		22	78
11	128		23	66
12	135		24	45

1. Plot and analyze your data
2. Forecast motorcycle sales and amount of money needed for month 25 using the Naïve method.
3. Forecast motorcycle sales and the amount of money needed for month 25 using MA3.
4. Forecast motorcycle sales and amount of money needed for month 25 using ES with α=0.2.
5. Forecast motorcycle sales and amount of money needed for month 25 using ES with α=0.6.
6. Plot the data and identify the best method to forecast motorcycle sales.

Answer 1