# Question: Suppose that a time series consisting of six years 2005 2010

Suppose that a time series consisting of six years (2005-2010) of quarterly data exhibits obvious seasonality. In fact, assume that the seasonal indexes turn out to be 0.75, 1.45, 1.25, and 0.55.

a. If the last four observations of the series (the four quarters of 2010) are 2502, 4872, 4269, and 1924, calculate the de-seasonalized values for the four quarters of 2010.

b. Suppose that a plot of the de-seasonalized series shows an upward linear trend, except for some random noise. Therefore, you estimate a linear regression equation for this series versus time and obtain the following equation: Predicted de-seasonalized value = 2250 + 51Quarter Here the time variable Quarter is coded so that

Quarter = 1 corresponds to first quarter 2005,

Quarter = 24 corresponds to fourth quarter 2010, and the others fall in between. Forecast the actual (not de-seasonalized) values for the four quarters of 2011.

a. If the last four observations of the series (the four quarters of 2010) are 2502, 4872, 4269, and 1924, calculate the de-seasonalized values for the four quarters of 2010.

b. Suppose that a plot of the de-seasonalized series shows an upward linear trend, except for some random noise. Therefore, you estimate a linear regression equation for this series versus time and obtain the following equation: Predicted de-seasonalized value = 2250 + 51Quarter Here the time variable Quarter is coded so that

Quarter = 1 corresponds to first quarter 2005,

Quarter = 24 corresponds to fourth quarter 2010, and the others fall in between. Forecast the actual (not de-seasonalized) values for the four quarters of 2011.

## Answer to relevant Questions

The file S12_61.xlsx contains monthly data on the number of nonfarm hires in the U.S. since 2000.a. What evidence is there that seasonality is important in this series? Find seasonal indexes (by any method you like) and ...Consider the file S12_59.xlsx, which contains total monthly U.S. retail sales data. Does a regression approach for estimating seasonality provide forecasts that are as accurate as those provided by (a)Winters’ method and ...The file S12_73.xlsx contains data on monthly U.S. permits for new housing units (in thousands of houses).a. Using Winters’ method, find values of α, β, and γ that yield an RMSE as small as possible. Does this method ...Other sensitivity analyses besides those discussed could be performed on the product mix model. Use Solver Table to perform each of the following. In each case keep track of the values in the changing cells and the objective ...Modify PC Tech’s product mix model so that there is no maximum sales constraint. Does this make the problem unbounded? Does it change the optimal solution at all? Explain its effect.Post your question