Mailings Review View Help Using the following demand, create a spreadsheet or calculate by hand (showing your workl) the answers to the following forecasting questions: Perlod/Month Demand January 154 February 148 March 214 April 180 May 225 June 245 1. What is the forecast for luly using a three period moving average? (2 points) 2. Using simple exponential smoothing and an a= 2 and a forecast of 185 for April, what would the forecast be for July (2 points) 3. Using the simple Naive method, what would the forecast be for July? (2 points) Using the following demand and forecast to answer questions 4 & 5. Period/Month January February March April May June Demand 154 148 214 180 225 245 Forecast 158 145 210 185 220 240 4. What is the MAD for this forecasting technique? (2 points) 5. What is the MSE for this forecasting technique? (2 points) D Focus E ing Assignment Protected View - Saved to this PC Walker-Miller, Joshua Christian W ces Mailings Review View Help Using the following demand, create a spreadsheet or calculate by hand (showing your workl) the answers to the following forecasting questions: Period/Month Demand January 154 February 148 March 214 April May June 180 225 245 1. What is the forecast for July using a three period moving average? (2 points) 2. Using simple exponential smoothing and an a2 and a forecast of 185 for April, what would the forecast be for July (2 points) 3. Using the simple Naive method, what would the forecast be for July? (2 points) Using the following demand and forecast to answer questions 4 & 5. Period/Month January February March April May June Demand 154 148 214 180 225 245 Forecast 158 145 210 185 220 240 4. What is the MAD for this forecasting technique? (2 points) 5. What is the MSE for this forecasting technique? (2 points) Droo w 99+