I also need step by step explanation on how to do the others parts of this porblem. Also, a general definition for "weighted moving average" would be helpful. thanks

Arial Paste $ %) BIU - A Merge & Center Number Clipboard Font Alignment D29 431 D E G 1b. A weighted three month moving average using these weights: 222 4322 24 August July June 0.6 0.3 0.1 25 28 28 1c. Exponential smoothing where a = 0.55 2 (assume the forecast for August was 420) 431 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. You'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 32 sales Sheet1 Sheet2 Sheet Ente BB B DB 320 Forecasting Assignment Type full name in row 4 below 4 Santana Wallace 5 6 1. Industrial pump sales 7 8 Mo Counter 9 1 10 Month January February March April 12 Sales 385 389 394 398 405 422 420 440 13 2 3 4 5 6 7 8 May 15 June July August 16 17 18 Based on this data, forecast sales for September using: 19 1a. A four month moving average 421.75 20 21 Sheet1 Sheet2 Sheet O of your employees developed two models for forecasting d tried to fit the model to past sales data, as show below. ot sure which mehod is better than the other, so you to calculate the Mean Absolute Percentage Error to which forecasting method (Method 1 or Method 2) is "Show your work in calculating the MAPE and make a asion as to which is a "better" method for predicting future Month Mo Counter 2 1 03 F M A M 2 3 4 5 6 7 8 Sales 353 321 362 370 382 377 392 404 Method 1 322 335 331 340 362 370 400 405 Method 2 340 350 372 364 385 391 391 400 J J Sheet1 Sheet2 Sheets