Sales forecasting — Edexcel A-Level Business
Test yourself on Sales forecasting with PEARSON EDEXCEL A-Level practice questions.
7 days Premium · Then free forever · No card, no charge
Sales forecasting explained
An estimate of how many units will sell and what they will be worth over a coming period, and it is the first number in the business because almost every other plan is derived from it.
Read the full explanation
Production schedules, capacity and shift patterns, raw material orders, recruitment, the marketing budget, the cash-flow forecast, the break-even calculation and any investment appraisal all start there. Methods run from extrapolating a time series and smoothing it with moving averages, through correlation with an economic variable, to test marketing a new line in one region. The trade-off is symmetric and expensive. Forecast too high and a firm carries unsold inventory, idle capacity and staff it cannot use. Forecast too low and it stocks out, loses customers to rivals and pays overtime rates to catch up.
b) Factors affecting sales forecasts: consumer trends; economic variables; actions of competitors
Three families of influence shift the demand line. Tastes move with fashion, demographics, health and sustainability concerns and social media, and back data from a period when tastes were different forecasts the wrong future. Macroeconomic conditions move real incomes, interest rates, unemployment, exchange rates and consumer confidence, which is why income elasticity matters: percentage change in quantity demanded divided by percentage change in real income, greater than one for a luxury such as a new car and negative for an inferior good such as a value own label range. Rivals then move too, cutting price, launching a substitute or opening nearby, and price elasticity tells you how much volume that costs. Porter five forces frames the rivalry but is a snapshot that ignores complements, government and the speed of technological change.
c) Difficulties of sales forecasting
Accuracy decays with distance and with novelty. Extrapolating a trend assumes the past continues, which fails at exactly the moments that matter, and a genuinely new product has no series to extrapolate from at all. One off events do not appear in any model: a heatwave, a tournament, a supply chain seizure, a viral clip. Rivals move without warning. Primary research suffers from small biased samples and from people saying they would buy something they never buy. Inside the firm, optimism bias and a sales team whose bonus depends on the number both bend the estimate. The usual answers are scenario planning, sensitivity analysis, rolling monthly revisions and buying flexibility through short lead time suppliers or temporary staff, all of which cost money, which is the trade-off.
Your focus
- a) Purpose of sales forecasts
- b) Factors affecting sales forecasts: consumer trends; economic variables; actions of competitors
- c) Difficulties of sales forecasting
Sales forecasting exam tips
Marking Points
- State the purpose as a planning input rather than a prediction for its own sake, and name at least two functions that depend on it such as operations scheduling and cash planning.
- Apply it to the lead times of the named business, since a retailer sourcing from Asia commits months ahead while a local bakery can adjust within a day.
- Show the cost of being wrong in both directions, excess inventory and tied up cash against stock-outs and lost sales.
- Name a method and say why it suits this firm, for example extrapolation for a mature product with years of data and test marketing for a new launch with none.
- Separate the three factors clearly and take one properly rather than mentioning all nine things the specification could cover.
- Use elasticity numerically where the extract allows, income elasticity for a change in incomes and price elasticity for a competitor price cut, with the sign and size interpreted.
- Apply the direction of travel to the named firm, so a rise in interest rates hits a kitchen fitter selling on credit far harder than a discount grocer.
- Judge which factor dominates for this business and over what time frame, which is where the evaluation marks sit.
- Give a named difficulty with a mechanism, for example that back data based extrapolation breaks when the trend itself changes, rather than listing that forecasts can be wrong.
- Tie the difficulty to the product or market in the case, such as a fashion range with a short life cycle or a new technology with no comparable history.
- Explain the consequence in business terms, lost sales and stock-outs or unsold inventory and cash tied up, so the difficulty has a cost attached.
- Offer a mitigation and its price, such as holding buffer inventory, using flexible contracts or forecasting on a rolling basis rather than annually.
Examiner Tips
- 💡Usually a four to six mark explain or analyse, sometimes as the first strand of a longer evaluate on planning, so give one developed chain rather than five unconnected purposes.
- 💡Build the chain fully: an accurate forecast means the right inventory means fewer stock-outs means retained customers means revenue protected.
- 💡If the extract gives a lead time, a seasonal pattern or a perishable product, use it, because that is where the application marks are hidden.
- 💡Extracts usually plant one of the three deliberately, an interest rate rise or a new entrant, so search for it before writing and build the answer around it.
- 💡An income elasticity or price elasticity figure in the data is an instruction to calculate, so use it rather than describing the relationship in words.
- 💡For twelve and twenty mark questions, rank the factors and justify the ranking on the evidence rather than concluding that all three matter.
- 💡This is normally the evaluative half of a question whose first half asked for the purpose, so hold the difficulties back for the judgement paragraph.
- 💡Anchor the judgement in a condition such as the length of the lead time, the volatility of the market or whether the product is perishable.
- 💡Do not spend the answer proving forecasts are hard, spend it showing how much accuracy actually matters to this particular firm.
Common Mistakes
- Treating a sales forecast as a target set by management rather than an estimate of demand, which confuses motivation with planning.
- Forecasting revenue and calling it volume, then using the pounds figure to plan how many units to make.
- Listing purposes generically without touching the case business, so the answer would fit any firm on any paper.
- Saying a recession reduces sales for everyone, when inferior goods, repair services and discount retailers commonly gain share as incomes fall.
- Confusing a movement along the demand curve caused by the firm own price with a shift caused by incomes, tastes or a rival action.
- Writing that competitors will react without saying how, so no consequence for volume, price or market share is ever reached.
- Saying forecasts are unreliable because the future is uncertain, which earns nothing without a specific variable and a reason it would move.
- Blaming only external shocks and never the internal causes such as optimism bias, pressure to hit a target or poorly designed market research.
- Concluding that a firm should therefore not forecast, when the realistic conclusion is that it should forecast differently and revise more often.