Please show All work:

Question 13. You are given the following data on truck sales:

Month	Sales
January	15
February	13
March	17
April	12
May	20
June	14
July	17
August	14
September	12
October	14
November	19
December	16

1. Using Excels Data Analysis add in, construct a moving average with 3 period and determine the demand for trucks for next January

2. Using a weighted average with three periods, determine the sales demand for February. Using 1/2, 1/3, and 1/6 for weight of the most recent, second most recent and third most recent period, respectively Compare the two forecasting methods using MAD