**** I NEED THE EXCEL FORMULAS USED TO FIND THE ANSWERS***** PLEASE AND THANK YOU!!!!!!******

Excelsior flashlights. has recorded the number of flashlights it has sold in each of the last 15 months of business. Use the recorded demand data below to develop three-period and fourperiod simple moving-average forecasts for flashlights. Round off all calculations to two decimal places. Maintaining two decimal places is required fo all calculations. 3) What is the MAD for the three-period moving-average forecast as of period 15 ? A) Less than or equal to 68.00 B) Greater than 68.00 but less than or equal to 70.00 C) Greater than 70.00 but less than or equal to 72.00 D) Greater than 72.00 but less than or equal to 74.00 E) Greater than 74.00 4) What is the MAPE for the three-period moving average forecast as of period 15 ? A) Less than or equal to 8.00% B) Greater than 8.00% but less than or equal to 8.50% C) Greater than 8.50% but less than or equal to 9.00% D) Greater than 9.00% but less than or equal to 9.50% E) Greater than 9.50% 5) What is the MAD for the four-period moving average forecast as of period 15 ? A) Less than or equal to 68.00 B) Greater than 68.00 but less than or equal to 70.00 C) Greater than 70.00 but less than or equal to 72.00 D) Greater than 72.00 but less than or equal to 74.00 E) Greater than 74.00 6) What is the MAPE for the four-period moving average forecast as of period 15 ? A) Less than or equal to 8.00% B) Greater than 8.00% but less than or equal to 8.50% C) Greater than 8.50% but less than or equal to 9.00% D) Greater than 9.00% but less than or equal to 9.50% E) Greater than 9.50% 7) Which forecast is the best (the three-period or four-period simple moving average method)? A) 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. 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. C) 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. D) 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