Question 4
ICAN
•
2024
•
PERFORMANCE MANAGEMENT
•
mixed
Case Stimulus
Some time ago Robert launched a new product some years ago at first, sales were good but now the figures are causing concern. Robert wants a more accurate sales forecast to produce detailed cash forecasts. Since there is some seasonality present in the raw data, the series for sales shown below represents the underlying trend based on an averaging process:
Sales
Year Quarter Trend point (cartons)
2016 3rd 1 10,000
2016 4th 2 10,790
2017 1st 3 10,920
2017 2nd 4 11,000
2017 3rd 5 11,050
2017 4th 6 11,080
2018 1st 7 11,085
2018 2nd 8 11,095
2018 3rd 9 11,120
2018 4th 10 11,130
On average, quarters, 1 and 3 are 5% and 6% respectively above trend whilst quarters 2 and 4 are respectively 2% and 9% below trend. Some preliminary calculations on the above ten observations have been carried out and the results are summarised below:
Results from ten periods’ observations:
Linear regression y = a + bx
Slope = 82.67
Intercept = 10,472.33
Coefficient of determination = 0.535
It is required to make forecasts of sales for quarters 3 and 4 in 2019 and for quarters 1 and 2 in 2020 but there is some discussion on whether the ten-period data shown above are suitable for forecasting or whether only the last five periods would provide a better basis for forecasting. Linear analysis of the last five periods only gives the following intermediate results:
Results of last five periods’ observations:
Σy = 555.10
Σx = 330
Σy = 61,627.40
Σxy = 4,442.15
Note: the y values have been scaled down by 100 times for ease of calculation.
Additional Information
{
"label": "Supporting information 1",
"content": "| Year | Quarter | Trend point | Sales (cartons) |\n|------|---------|-------------|----------------|\n| 2016 | 3rd | 1 | 10,000 |\n| 2016 | 4th | 2 | 10,790 |\n| 2017 | 1st | 3 | 10,920 |\n| 2017 | 2nd | 4 | 11,000 |\n| 2017 | 3rd | 5 | 11,050 |\n| 2017 | 4th | 6 | 11,080 |\n| 2018 | 1st | 7 | 11,085 |\n| 2018 | 2nd | 8 | 11,095 |\n| 2018 | 3rd | 9 | 11,120 |\n| 2018 | 4th | 10 | 11,130 |"
}
{
"label": "Supporting information 2",
"content": "| Results from ten periods' observations: |\n|----------------------------------------|\n| Linear regression | y = a + bx |\n| Slope | = 82.67 |\n| Intercept | = 10,472.33 |\n| Coefficient of determination | = 0.535 |"
}
Requirements
(
a
)
Forecast the sales of the four quarters required using the ten-period observations results.
(
b
)
Prepare similar forecasts based on the last five periods’ observations.
(
c
)
Explain which forecasting basis produces the better forecast.
Detailed Solution & Marking Scheme
Get the step-by-step solution,
key points required by examiners
and detailed marking guidance
through the Edcrib AI Tutor.
Reveal Answer
About This Question
This is
Ican
2024
Performance Management
Question 4.
It is one of the
mixed
questions from the
2024
Ican
Performance Management
examination.