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:

4-year moving average forecasts

3-year weighted moving average forecasts using weights 6, 4 and 2, with emphasis placed on more recent periods

exponentially smoothed forecasts with =0.9

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 =ROUND( ,3) in Excel.

Year	Revenue	4-year Moving Average	3-year Weighted Moving Average	Exponential Smoothing ( = 0.9)
2010	6.2
2011	7.2
2012	6.4
2013	5.6
2014	7.4
2015	7.2
2016	6.0
2017	5.5
2018	6.7
2019	5.9
2020	6.5
2021	5.9
2022

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? %

II) What is the MAPE for the 3-year weighted moving average forecasts? %

III) What is the MAPE for the exponentially smoothed ( = 0.9) forecasts? %

Based on MAPE, which of the methods provides the best forecast accuracy for the data?

a) 4 year moving average

b) 3 year weighted moving average

c) Exponential smoothing with =0.9