Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following data represent the annual revenue (in millions of dollars) for a cloud software company from 2009 to 2020. Complete the table by developing:
The following data represent the annual revenue (in millions of dollars) for a cloud software company from 2009 to 2020. Complete the table by developing:
- 4-year moving average forecasts
- 3-year weighted moving average forecasts using weights 5, 4 and 1, with emphasis placed on more recent periods
- exponentially smoothed forecasts with ==0.88
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.
Year | Revenue | 4-year Moving Average | 3-year Weighted Moving Average | Exponential Smoothing ( = 0.88) |
---|---|---|---|---|
2009 | 6.0 | |||
2010 | 5.6 | |||
2011 | 6.2 | |||
2012 | 5.2 | |||
2013 | 5.7 | |||
2014 | 6.4 | |||
2015 | 4.9 | |||
2016 | 6.6 | |||
2017 | 5.8 | |||
2018 | 5.4 | |||
2019 | 6.0 | |||
2020 | 5.6 | |||
2021 |
- What is the MAPE for the 4-year moving average forecasts?
- What is the MAPE for the 3-year weighted moving average forecasts?
- What is the MAPE for the exponentially smoothed ( = 0.88) forecasts?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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
Get Started