Tom and Hanks is a regional convenience store with locations in several small towns along the Mississippi

Question:

Tom and Hank’s is a regional convenience store with locations in several small towns along the Mississippi River. The quarterly revenue for the store beginning with the first quarter of 2005 and ending with the second quarter of 2011 is shown below:

image text in transcribed
a. Produce a time-series plot of the store’s revenues by quarter. What time-series components appear to be present in the data?
b. Determine a seasonal index for each quarter.
c. Use the seasonal indexes from part b to deseasonalize the data.
d. Graph and fit a linear trend line to the deseasonalized data.
e. Use the linear trend line and the seasonal indexes to produce a seasonally adjusted forecast for each quarter beginning with quarter 1 of 2005 and ending with quarter 2 of 2011.f. Calculate a forecast error for each period.
g. Calculate the MAD and the MSE for the forecasts you developed in part e.
h. Using the seasonal indexes and the estimated trend line, produce a forecast for quarters 3 and 4 for 2011.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Statistics A Decision Making Approach

ISBN: 9780133021844

9th Edition

Authors: David F. Groebner, Patrick W. Shannon, Phillip C. Fry

Question Posted: