Documert5 -ces Mailings Review view A GE ABCD AaBbCcDc ABOCCD Ad Company D sells smart phones and uses a variety of sales forecasting methods. It's been selling its popular Basic model for many years. Basic sales don't vary by time of year so it uses a Naive or 2-Year Moving Average method. One of these two methods is selected based on each method's Mean Absolute Percent Error (MAPE). Below is a spreadsheet analyzing the forecasting performance for each method for the past 6 years, ending in 2019 (sales are in in M phones, where M stands for millions). Forecast Absolute Percent Error 2-Year Moving I 2-Year Moving Nalve Average Nalve Annual sales 2 Year (M phones) 3 2014 4 201530 5201622 6 2017 27 7 2018 A 2019 9 2020 30 25 36% 2617% a. What Excel formula was entered in C to do a Fill Down to C9 and compute Naive forecasts to 20207 CS: b. What Excel formula cell was put into cell D9. the 2-Year Moving Average forecast for 20207 D9:- e. What formula is in cell F10 to compute the MAPE for the 2-Year Moving Average forecasts from 2016 to 2019? FIO: d. Sales of Shudent phones vary by month, so a seasonal forecasting method is used. The table below shows the Seasonal Indices analysis (in K[000) phones) that was done for 2018 and 2019 to determine 2020's sales forecast by month (Note: the months of February through September are hidden.) ABDE 2019 Sales (K phones) Monthly Index 0.6 2 Month 13 January 12 October 13 November 14 December 15 Total Year 2018 Sales (Kphones) 100 150 350 SOO 1800 250 350 550 2400 Monthly Average 105 200 350 525 175 20 3.0 d. What formula was put into cell D3 to do a Fill Down to D14 and compute cach month's Monthly Average for 2018 and 20192