# Barbara Lynch is the product manager for a line of skiwear produced by HeathCo Industries and privately

## Question:

a. Because Ms. Lynch has so many other job responsibilities, she has hired you to help with the forecasting effort. First, she would like you to prepare a time-series plot of the data and to write her a memo indicating what the plot appears to show and whether it seems likely that a simple linear trend would be useful in preparing forecasts.

b. In addition to plotting the data over time, you should estimate the least-squares trend line in the form:

SALES = a + b (TIME)

Set TIME = 1 for 1994 Q1 through TIME = 40 for 2003 Q4. Write the trend equation:

SALES = ______ +/- ______(TIME)

(Circle + or – as appropriate)

c. Do your regression results indicate to you that there is a significant trend to the data? Explain why or why not.

d. On the basis of your results, prepare a forecast for the four quarters of 2008.

e. A year later, Barbara gives you a call and tells you that the actual sales for the four quarters of 2008 were: Ql = 334,271, Q2 = 328,982, Q3 = 317, 921, and Q4 = 350,118. How accurate was your model? What was the root-mean-squared error?

## Step by Step Answer:

**Related Book For**

## Business Forecasting with Forecast X

**ISBN:** 978-0073373645

6th edition

**Authors:** Holton wilson, barry keating, john solutions inc