v

Question 12 (2 points) Listen Mixed Problems. Use Excel Spreadsheet (Copy the table below and Paste it into Excel). Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period. Forecast September using a three-month moving average. (Round your answers to 2 decimal places.) Month January February March April May June July August September Actual 111 129 152 165 168 174 147 140 147