Problem #1: (25 points, Forecasting Moving Average and Forecasting Error powerpoints) Fill out the following problem table and show full work for at least two of the months. Demand for Month Bulldozers Error 4MA Error 1 8 2. 12 3 7 4 9 5 15 6 11 7 10 8 12 9 ? AE = AE = WNA N | | 000 a) Compute three- month moving average for months 4-9 and four- month moving average for months 5-9. Use at least one decimal place: so your forecast should be 10.3, etc. Show your work for at least Month 5 and 6. b) Compute the errors for each forecast (note: can't do this for month 9). Use the Demand Forecast formula for Forecast Error (see page 118 of textbook, or the Forecasting Error powerpoint). Then calculate AE (Average Error) for only months 5-8 for each. (Note: it's important to compare the two forecasts over the same time periods)