C39 1 DB 320 Forecasting Assignment 3 | Type full name in row 4 below 6 1. Industrial pump sales Month January February March April May June July August Mo Counter Sales 385 389 394 398 405 6 422 420 440 10 12 13 14 15 16 17 18 Based on this data, forecast sales for September using: 19 1a. A four month moving average 20 21 4 1b. A weighted three month moving average using these weights: August July 23 0.6 0.3 24 Sheet1 Sheet2 Sheet3+ C39 1b. A weighted three month moving 23 24 25 26 27 average using these weights: August June 0.6 0.3 0.1 28 lic. Exponential smoothing where 0.55 29 (assume the forecast for August was 420) 30 31 2. One of your employees developed two models for forecasting sales and tried to fit the model to past sales data, as show below. 4au're not sure which mehod is better than the other, so you decide to calculate the Mean Absolute Percentage Error to explain which forecasting method (Method 1 or Method 2) is "better." Show your work In calculating the MAPE and make a conclusion as to which is a "better" method for predicting future sales Month Mo Counter Sales Method 1 Method 2 322 321335350 353 340 Sheet1 Sheet2 Sheet3 + Method 1 Method 2 Mo CounterSales 353 321 Month 340 350 372 364 385 391 322 335 M. 340 370 382 377 392 404 4 362 370 400 405-1 391 400