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 2012 to 2023. Complete the table by developing:
The following data represent the annual revenue (in millions of dollars) for a cloud software company from 2012 to 2023. Complete the table by developing:
- 4-year moving average forecasts
- 3-year weighted moving average forecasts using weights 6, 2 and 1, with emphasis placed on more recent periods
- exponentially smoothed forecasts with ==0.37
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.