Cell 117. Enter mean absolute deviation (MAD) for F2 forecast for the period from April 2020 through January 2021, must be a whole number. 2 pts Question 5 Cell J17. Enter mean absolute percent error (MAPE) for F2 forecast for the period from April 2020 through January 2021. Enter as a percentage with 2 decimals, e.g., 12.34. Do not enter the % sign. I Question 6 2 pts Over the considered period, the forecast model F1 (simple moving average)... has a negative CFE (blas) that underestimates the demand. has a negative CFE (bias) that overestimates the demand has a positive CFE (bias) that underestimates the demand. has a positive CFE (bias) that overestimates the demand has no bias and estimates the demand accurately, Homework - Moving Average Forecasts Forecast 1 (F1) Absolute Error F1 Absolute % Error Forecast 2 Absolute F1 (F2) Error F2 Absolute % Error F2 Error F1 Round to decima ROUND Action Discum Round Round to Round to decimals with decimal decimals with Use ABS hunction ROUND function HOUND Runction Uwe ABS function ROUND function In this column in this column celum In this column In this colum Actual Year Month Demand 2020 Jan 500 2020 Feb 450 2020 Mar 475 2020 Apr 575 2020 May 460 2020 Jun 480 2020 Jul 500 2020 Aug 510 2020 Sep 600 2020 Oct 515 2020 Nov 465 2020 Dec 505 2021 Jan 495 Enter MAD Enter MAPE above Enter Means above, round Enter CPE Enter MAD Enter MAPE Enter Sum to decimals above above, o dec above above above, o dec. You want to compare accuracy of two types of 3-month moving average forecasts of sales for a machine part. Based on the above data, calculate a simple 3-month moving average (forecast 1). Then calculate a weighted 3-month moving average (forecast 2). In forecast 2, the sales of the most recent month, i.e "one month ago," have double the weight of any of the two preceding months, i.e. "two months ago" and "three months ago." Tip: you will need to flex your analytical abilities by creating and solving an equation for weights first, keeping in mind that all weights must add up to 1. Calculate forecast errors and make a conclusion about the relative accuracy of one method over the other for this data set based on MAD and mean absolute percentage error (MAPE). Use formulas in all cells, including the ROUND formula to round to integer number of units and the ABS formula for absolute numbers where applicable. Color legend: Test your answers in these cells in the Help Tool, unlimited attempts Enter final answers in these cells in the final quiz when ready Note on rounding of values expressed in percent, such as MAPE: If your formula looks like a/b and then you click on the % icon in the menu to display the value in %, round to 4 decimals. If you use the formula a/b 100, then round to 2 decimals