Question: a . Construct a table in which you show the actual data, the centered moving - average trend, the seasonal factors, and the cycle factors

a. Construct a table in which you show the actual data, the centered moving-average trend, the seasonal factors, and the cycle factors for every quarter for which they can be calculated in years 2012 through 2015.
b. Look at the seasonal index for each quarter as calculated in forecastX. Do they make sense to you? Explain why or why not.
c. Make a forecast of the number of customers for each quarter of 2016.
d. The actual numbers of customers served per quarter in 2016 were 6.8,5.1,4.7, and 6.5 for quarters 1 through 4, respectively. Calculate the MAPE for 2016.
e. Using the results provided in the tables produced by ForecastX, prepare a time-series plot of the actual data, the centered moving averages, the long-term trend, and the values predicted by your model for 2012 through 2016.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!