(C) Given your answers to (A) and (B), what type of forecast do you recommend? Explain your answer.
(D) Use your answer to (C), to obtain a forecast for the next quarter (4 months). How reliable do you think this forecast is?
The table below contains the monthly number of airline tickets sold by a travel agency in Grand Rapids, Michigan
97. (A) Is this time series random? Perform a runs test and compute a few autocorrelations to support your answer.
(B) Does a linear trend appear to fit these data well? If so, estimate the linear-trend model for this time series, and
interpret the value.
(C) Is there evidence of some seasonal pattern in these sales data? If so, characterize the seasonal pattern, and explain
how to forecast future values.
Suppose that simple exponential smoothing with is used to forecast monthly wine sales at a liquor store. After
April’s demand is observed, the forecasted demand for May is 4500 bottles of wine.
98. (A) At the beginning of May, what is the forecast of July’s wine sales?
(B) Suppose that actual demands during May and June are as follows: May, 5000 bottle of wine; June 4000 bottle of wine.
After observing June’s demand, what is the forecast for July’s demand?
(C) Based on the data from (B), the demands during May and June average (5000+4000)/2 = 4500 bottle per month. This
is the same as the forecast for monthly sales before we observed the May and June data. Yet after we observe the May
and June demands for wine, our forecast for July demand has decreased from what it was at the end of April. Why?
Suppose that simple exponential smoothing with is used to forecast monthly Pepsi sales at a small grocery store.
After March’s demand is observed, the forecasted demand for April is 5000 cans of Pepsi.
99. (A) Suppose that actual demands during April and May are as follows: May, 5500 cans; June 4500 cans. After
observing May’s demand, what is the forecast for June’s demand?
(B) Based on the data from (A), the demands during April and May average (5500+4500)/2 = 5000 cans per month. This
is the same as the forecast for monthly sales before we observed the April and May data. Yet after we observed the April
and May demands for Pepsi, our forecast for June demand has decreased from what it was at the end of March. Why?
100. The number of reported accidents at a manufacturing plant located in Flint, Michigan, was recorded at the start of
each month. These data are provided in the table below: