Data collected on the monthly demand for a certain product in thousands of dollars are shown in the following table. (attached) a) Using a weighted moving average with three periods, determine the...

Data collected on the monthly demand for a certain product in thousands of dollars are shown in the following table. (attached)

a) Using a weighted moving average with three periods, determine the demand for period 13. Use 3, 2, and 1 for the weights of the most recent, second most recent, and third most recent periods, respectively
b) Find the MAD, MSE and MAPE

b) Use exponential smoothing with a smoothing constant of 0.30 to forecast the sales.
Assume that the last period’s forecast for month 1 is equal to actual to begin the procedure. Which method do you think is best? Is this an improvement over the weighted average- use MAD only
c) Use regression analysis to estimate the line of best fit -use the manual method with the formulas shown below.

Extracted text: y=a+bx where: nE xy – ExEy b = nE x² – (Ex)* a = ỹ – bx


Extracted text: Month Demand 1 145.5 2 160 3 71 4 99 5 194.5 6. 206 7 135.5 8 152.5 9. 246 10 259 11 181.5 12 194