The following data represent the annual revenue (in millions of dollars] for a cloud software company from 2010 to 2021. Complete the table by developing: O 4-year moving average forecasts O 3-year weighted moving average forecasts using weights 4, 3 and 2, with emphasis placed on more recent periods O exponentially smoothed forecasts with a: : 0.5 Round all results to 3 decimal places. If a posted result is being reused, ensure that the value being reused is the rounded value and not the original result obtained before rounding. Hint: Use =ROUNM ,3) in Excel. Exponential Smoothing (o: = 0.5) 4-year 3-year Weighted Year Revenue , . Movmg Average Movrng Average DDEEJJJUUUUD Download CSV Calculate Absolute Percent Error for each applicable period of each method, rounded to 3 decimal places. Use the results to answer the following. I. What is the MAPE for the 4-year moving average forecasts? C] \"A ll. What is the MAPE for the 3-year weighted moving average forecasts? Cw