1.

A small company gathered sales data over the last 7 months as follows: Month Sales January 237 February 225 March 227 April 252 May 288 June 288 July 273 August Download CSV Do not round answers. a) What is the 3-month moving average forecast for May? b) What is the 2-month weighted moving average forecast for August using weights 5 and 37 Assign hi weight to the most recent period. c) Given that the exponentially smoothed forecast for February is 237, what is the simple exponent smoothing forecast for March with a = 0.1?The following table shows actual sales and 2-period moving average forecasts. Determine the missing actual demands, A, and A4. Period Actual Forecast t A F 252 2 A2 242 260 255 5 238 255 222 253 7 230 A2 = A4Below is a transportation company's records of actual on-time delivery indexes over the last 7 periods along with some 3-period weighted moving average forecasts. Compute the mean squared error MSE. Do not round results. Period Actual Forecast 85 102 1 AWN 105 90 101 104 97 96 99 7 80 98 Mean Squared Error =Given the following actual and forecast values, calculate the mean absolute percent error, MAPE. Do not round results. Period Actual Forecast 1 264 IN 274 286 262 305.23 268 235.84 6 254 246.38 Express your answer as a percentage. Do not enter the * sign into the answerbox. MAPE =