Step by step answer the quetion by showing your work
A small ice-cream manufacturer who supplies a supermarket chain reports sales figures
of K50, 000 for the last quarter.
Is this amount good or bad? Can this single figure be used to forecast future sales?
With only one figure we never have sufficient data to make either a judgment or a
forecast.
We also need to compare the figure with:
that for the previous quarter;
that for the corresponding quarter of the previous year;
that which would be expected from the current trend, if that can be identified.
We need to identify any past pattern and use it for future sales predictions.
We also need to estimate how accurate those predictions are likely to be.
In order to understand the situation more fully, the following data was collected. It
represents the quarterly sales figures for the four years preceding the figure of K50 000
quoted above.
Sales (K'000)
Year Quarter 1 Quarter 2 Quarter 3 Quarter 4
1997 40 60 80 35
1998 30 50 60 30
1999 35 60 80 40
2000 50 70 100 50
Method
1 First plot the data in chronological order on a graph against time. (Grid on back page)
What do you think? Does this data exhibit a 'four point pattern'? It does and therefore,
since it is quarterly data, the sales are judged to exhibit a quarterly seasonal effect. We
shall use an additive model to identify how much has been 'added' to the sales because
it is a particular quarter of the year.
Additive model
Observed
Sales value
=
Trend
value
+
Seasonal
factor
+
Random
factor
A = T + S + R
The Trend value, T, is the value of the sales had the seasonal effect been 'averaged out'.
The Seasonal factor, S, is the average effect of it being a particular quarter, e.g.
summer.
The Random factor, R, is the random variation due to neither of the previous variables.
This cannot be eliminated but is a useful measure of the goodness of fit of the model and
therefore of the quality of any forecasts made from it.
2 We can calculate the missing trend values from the table on the next page which includes:
The observed sales figures.
The cycle average which is the moving average of four consecutive quarters, i.e. one
from each season. As this value is not centered on any quarter its deviation from the
observed sales cannot be found.
The trend which is the moving average of two consecutive cycle averages and is
centered on a quarter. This second calculation is only necessary for cycles with even
numbers of periods as an odd number would produce a cycle average which was
already centered.
The first residual is the difference between the observed values and the trend. This will
be largely due to the seasonality of the data. From these first residuals we calculate
the seasonal factor which is the deviation from the trend due to it being a particular
season.
The fitted values are those produced by the model. i. e. trend + seasonal factor.
The second residual is the difference between the observed and fitted model values.
1 answer
For 1997, Q1 to Q4:
(40 + 60 + 80 + 35) / 4 = 53.75
For 1998, Q1 to Q4:
(30 + 50 + 60 + 30) / 4 = 42.5
For 1999, Q1 to Q4:
(35 + 60 + 80 + 40) / 4 = 53.75
For 2000, Q1 to Q4:
(50 + 70 + 100 + 50) / 4 = 67.5
4. Calculate the trend:
For 1997 and 1998:
(53.75 + 42.5) / 2 = 48.125
For 1999 and 2000:
(53.75 + 67.5) / 2 = 60.625
5. Calculate the first residuals:
For 1997:
Trend value: 48.125
Observed value: 40
Residual: 40 - 48.125 = -8.125
For 1998:
Trend value: 48.125
Observed value: 30
Residual: 30 - 48.125 = -18.125
For 1999:
Trend value: 60.625
Observed value: 35
Residual: 35 - 60.625 = -25.625
For 2000:
Trend value: 60.625
Observed value: 50
Residual: 50 - 60.625 = -10.625
6. Calculate the seasonal factors:
For 1997:
Average of first residuals: (-8.125 + -18.125) / 2 = -13.125
Seasonal factor: -8.125 - (-13.125) = 5
Repeat this process for all quarters.
After calculating the seasonal factors for each quarter, you can use the additive model to forecast future sales based on the trend and seasonal factors. This will give you a more accurate prediction than just using a single figure of sales for one quarter.