Refer to the table in Appendix 1. Calculate: (i) seasonal variation in 2015 Quarter 1
- (a)(i)Refer to the table in Appendix 1. Calculate: (i) seasonal variation in 2015 Quarter 1[1]
- (a)(ii)average seasonal variation in Quarter 4.[1]
- (b)Refer to the table and graph in Appendix 1. Calculate PV's forecast sales for Quarter 3 in 2017.[3]
- (c)Discuss the usefulness of sales forecasts to PV when making marketing decisions. Refer to your result from 2(b).[12]
This question uses a diagram from the original paper, which isn't shown here. Open the full paper from the past papers archive to see it.
Mark scheme
Marking points from the official mark scheme (May/June 2017). The mark or mark type is shown in brackets.
- [1] $30m – 21.375 = $+8.625m
- $m not required
- [1] ($m(-1.375 – 1.125 – 1.875) / 3 = $–1.458 ($–1.46m 2 decimal places or – 1.5)
- $m not required
- [1] Predicted trend from inspection of graph: $23.8m (error margin 23.75 – 23.85)
- [1] Add average seasonal variation: $-6.125m
- [3] = $17.675m
- Accept 17.68 or 17.7 (3 marks) (error margin 17.625 – 17.725)
- $m not required
- OFR
- Up to 2 marks can be awarded for:
- [1] Logical attempt to predict trend using the table (e.g. by considering the average of the Quarter 3s)
- [1] Correct use of seasonal variation
- Note to examiners: No reference to result from 2(b) limits AN and EVAL to L1
- Answers could include:
- Methods of forecasting sales
- Sales forecasting using Time Series Analysis takes account of seasonal variations and gives a realistic prediction.
- Forecasting enables planning, this method fits sales pattern well i.e.
- PV faces clear seasonal variation and consistent past trends so it is reasonable to assume that the future will be similar, making forecasting valuable for planning.
- Case indicates possible changes to the market – buyer's comments, change in buyers' requirements, increasingly fragmented relationships with buyers, possibility of direct selling, thus decreasing value of forecasting.
- May be advisable to introduce an element of probability to the forecasts – what if analysis.
- How forecasts contribute to market planning and production planning
- If Pedro is certain the forecast indicates future success PV may not make the changes that other evidence indicates are necessary.
- Application
- Forecast only refers to export market, not 20% domestic sales
- Multinational shoe retailer buyers, takeovers by larger shoe manufacturers
- Possible more efficient working methods may lower costs
- Possible effects of investment in new machinery
- Use of graph to indicate changes in pattern (lower growth rate in 2016)
- Forecast shows increased sales
- PV faces clear seasonal variation and consistent past
- Evaluation
- More reliable than simple forecasting or just projecting a trend
- Relies on future events behaving as in past patterns so may not be reliable
- Other evidence needs to be taken into account e.g. prediction of competitors' behaviour, likely future government actions, and / or economic changes
- Forecast only refers to exports, information on domestic market needed.
Write your answer and get it marked
On Oracle Prep you can write or photograph your own answer and have it marked by AI against this mark scheme, with feedback on what you missed.
Sign up free →