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.
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.
Quick check
The four components a time series is decomposed into are trend, seasonal, random and
Cyclical variation is the multi-year swing associated with the economic cycle, distinct from the within-year seasonal pattern.
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
(100 + 140 + 180 + 120) ÷ 4 = 540 ÷ 4 = 135.
Part 3 of 3
Quick check
A four-quarter moving average is used on quarterly data specifically because
Spanning a full seasonal cycle causes the seasonal terms to net out, leaving the trend visible.
Test what you just learned. Correct moves you up, wrong moves you down - reach 100 to master this lesson.