← Back to Unit 4 — Marketing

Sales Forecasting (HL)

Beginner Investing • 10 min

What this lesson is about

Separating the underlying trend from seasonal swings using moving averages, and knowing how far an extrapolation can honestly be pushed.

Key termsSales, forecastingTime, series, analysistrendSeasonal, variationCyclical, variation

3 parts · a quick check after each · then the quiz

Part 1 of 3

Sales, forecasting, predicts, future, sales, based, on, past, data., Its, value?, Almost, every, other, plan, relies, on, it., Production, schedules,, staffing,, cash, flow, forecasts,, and, budgets, all, start, with, the, sales, forecast., An, error, here, spreads, everywhere.

Time, series, analysis, breaks, down, historical, sales, into, four, parts., The, trend, shows, the, long-run, direction., Seasonal, variation, reflects, regular, patterns, that, repeat, each, year,, like, ice, cream, in, summer, or, toys, in, December., Cyclical, variation, involves, longer, swings, tied, to, the, economic, cycle,, often, lasting, several, years., Finally, random, variation, covers, everything, unpredictable:, weather,, strikes,, or, viral, posts.

A, moving, average, helps, reveal, the, trend, by, removing, seasonal, and, random, noise., When, using, quarterly, data,, a, four-quarter, moving, average, is, ideal., This, averages, one, full, cycle, of, seasons,, canceling, out, seasonal, effects., For, example,, if, quarterly, sales, are, 100,, 140,, 180,, and, 120,, the, four-quarter, moving, average, would, be, (100, +, 140, +, 180, +, 120), ÷, 4, =, 135.

SeasonalityOnly the year-on-year number is growth. The other is mostly the season.

Quick check

The four components a time series is decomposed into are trend, seasonal, random and

Part 2 of 3

Once, you, know, the, trend,, you, can, estimate, seasonal, variation, for, a, period., This, is, done, by, taking, the, actual, figure, and, subtracting, the, trend, figure, for, that, period., If, actual, sales, are, 180, against, a, trend, of, 135,, the, seasonal, variation, is, +45., This, number, adjusts, future, trend, projections, upward, for, that, quarter.

Extrapolation, takes, the, trend, and, pushes, it, forward., This, is, valid, but, limited., The, key, limitation, is, this:, extrapolation, assumes, that, the, conditions, producing, the, past, trend, continue., The, further, you, project,, the, weaker, this, assumption, becomes., It, often, fails, at, critical, moments,, like, when, a, new, competitor, enters, the, market,, regulations, change,, technology, shifts,, or, a, recession, hits., A, forecast, reflects, past, trends,, not, future, predictions.

Quick check

Quarterly sales of 100, 140, 180 and 120 give a four-quarter moving average of

Part 3 of 3

Insider, Angle:, Evaluation, marks, on, forecasting, come, from, identifying, what, could, break, the, forecast,, not, from, general, doubts., Saying,, "The, forecast, may, be, inaccurate,", earns, nothing, because, that’s, true, for, all, forecasts., What, earns, credit, is, pinpointing, the, specific, assumption, and, event, that, would, disrupt, it:, this, extrapolation, assumes, no, new, entrants,, and, if, a, competitor, launches, next, quarter,, the, trend, line, becomes, unreliable., Connect, the, limitation, to, something, in, the, stimulus, material.
Try, This:, Quarterly, sales, are, 200,, 260,, 340,, and, 240., Calculate, the, four-quarter, moving, average, and, then, the, seasonal, variation, for, the, third, quarter., Write, one, sentence, on, what, you’d, need, to, know, before, extrapolating, this, two, years, forward.

Quick check

A four-quarter moving average is used on quarterly data specifically because

Quiz

Master this lesson

Test what you just learned. Correct moves you up, wrong moves you down - reach 100 to master this lesson.

0
/ 100
Log in to save your progress and earn XP.

Related lessons

Swipe for more