*** I NEED THE EXCEL FORMULAS USED TO GET THE ANSWERS*** THANKS!!!

Period Demand Period Demand Period Demand 1 850 6 890 11 880 2 890 7 920 12 850 3 925 8 895 13 865 4 880 9 865 14 890 5 860 10 910 15 895 3) What is the MAD for the three-period moving average forecast as of period 15? A) B) C) D) E) Less than or equal to 18.00 Greater than 18.00 but less than or equal to 20.00 Greater than 20.00 but less than or equal to 22.00 Greater than 22.00 but less than or equal to 24.00 Greater than 24.00 4) What is the MAPE for the three-period moving average forecast as of period 15? A) B) C) D) E) Less than or equal to 1.00% Greater than 1.00% but less than or equal to 1.50% Greater than 1.50% but less than or equal to 2.00% Greater than 2.00%but less than or equal to 2.50% Greater than 2.50% 5) What is the MAD for the four-period moving average forecast as of period 15? A) ) C) D) E) Less than or equal to 18.00 Greater than 18.00 but less than or equal to 20.00 Greater than 20.00 but less than or equal to 22.00 Greater than 22.00 but less than or equal to 24.00 Greater than 24.00 6) What is the MAPE for the four-period moving average forecast as of period 15? A) B) C) D) E) Less than or equal to 1.00% Greater than 1.00% but less than or equal to 1.50% Greater than 1.50% but less than or equal to 2.00% Greater than 2.00% but less than or equal to 2.50% Greater than 2.50% 7) Which forecast is the best (the three-period or four-period simple moving average method)? A) B) The 3-period moving average is the best forecast because the MAD and MAPE are less than the 4-period moving average MAD and MAPE. The 3-period moving average is the best forecast because the MAD and MAPE are greater than the 4-period moving average MAD and MAPE. The 4-period moving average is the best forecast because the MAD and MAPE are less than the 3-period moving average MAD and MAPE. The 4-period moving average is the best forecast because the MAD and MAPE are greater than the 3-period moving average MAD and MAPE. C) D)