Please show all work for better understanding.

The last six weeks of demand at a new car dealer are shown below. Week Sales 1 18 2 30 W 24 4 35 5 30 6 32 a) Use a four-period weighted moving average to determine a forecast for the week 5 and week 6 using weights of 1, 2, 3, and 4. (5 points) Weights Applied Time Period 4 Last week 3 Two weeks ago 2 Three weeks ago 1 Four weeks ago Week Sales Forecasting 1 18 2 30 3 24 4 35 5 30 6 32