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:
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 4year moving average forecasts o 3year weighted moving average forecasts using weights 5, 4 and 2, with emphasis placed on more recent periods - exponentially smoothed forecasts with a = 0.19 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 obtainec before rounding. Hint: Use =ROUND( ,3) in Excel. 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. Exponential 4-year Year 3-year Weighted Revenue Smoothing Moving Average Moving Average (a = 0.19) 2010 5.9 2011 4.7 2012 4.2 2013 5.6 2014 4.4 2015 5.8 2016 5.3 2017 5.5Download 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 4year moving average forecasts? C] % ||. What is the MAPE for the 3year weighted moving average forecasts? C] % "I. What is the MAPE for the exponentially smoothed (a = 0.19) forecasts?|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance