Forecasting - Operations Management . Please show all work.

The actual demand for germicidal chemicals at one of Health First clinics is as follows: Quarter 1 2 3 4 5 6 7 8 9 10 Gallons of Germicidal Chemicals Used 550 490 510 590 595 550 565 610 635 565 572 655 11 12 a. Plot the data in the previous table on a graph. Do you detect any trend or seasonal pattern? b. Forecast demand from quarter 5 to quarter 13 using 4-quarter simple moving average. Plot your forecast on the same graph as the actual demand c. Forecast demand from quarter 3 to quarter 13 using a weighted moving with a weight of 3 for Demand t-1 and weight of 2 for Demand +-2 (for example, for if you are calculating the forecast for quarter 7, then quarter 6 will have a weight of 3 and quarter 5 a weight of 2). Plot your forecast on the same graph as the actual demand and the simple moving average. d. Looking at the graph in part c, which forecasting method seems to be more appropriate? Explain