Question
Consider the following sales data measured in millions of dollars. Date Time Sales (millions of dollars) MA CMA Seasonal Factors Seasonal Index 2015Q1 1 14
- Consider the following sales data measured in millions of dollars.
| Date | Time | Sales (millions of dollars) | MA | CMA | Seasonal Factors | Seasonal Index |
| 2015Q1 | 1 | 14 | ||||
| 2015Q2 | 2 | 16 | ||||
| 2015Q3 | 3 | 18 | ||||
| 2015Q4 | 4 | 30 | ||||
| 2016Q1 | 5 | 17 | ||||
| 2016Q2 | 6 | 19 | ||||
| 2016Q3 | 7 | 19 | ||||
| 2016Q4 | 8 | 28 | ||||
| 2017Q1 | 9 | 12 | ||||
| 2017Q2 | 10 | 17 | ||||
| 2017Q3 | 11 | 20 | ||||
| 2017Q4 | 12 | 29 |
- Find a four-period moving average for each quarter.
b) Find the centered moving averages for the sample.
Find the seasonal factors for the sample.
Find the seasonal index. Interpret the index for each quarter.
Please describe how would you estimate the long-term trend and measure the cyclical factor (no need for computation, just explain).
Step by Step Solution
3.42 Rating (155 Votes )
There are 3 Steps involved in it
Step: 1
To find the fourperiod moving average MA for each quarter we can calculate the average sales fo...
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
Business Forecasting With Forecast X
Authors: Holton Wilson, Barry Keating, John Solutions Inc
6th Edition
73373648, 978-9339220426, 9339220420, 978-0073373645
