Skip to content

Machine Learning for Forecasting: When It Beats Simple Models

By Newtown Analytics · · 9 min read

For finance, fp&a & accounting managers

Machine learning for forecasting uses algorithms that learn patterns from many series and many drivers at once, instead of relying on a single trend or seasonal formula for each item. This guide is part of business analytics for finance and operations, follows predictive analytics for business and analytics automation, and leads to AI in finance and AI in FP&A. The pitch is attractive: better accuracy, automatic handling of promotions and price changes, fewer manual overrides. The reality is more nuanced. On some problems machine learning methods beat traditional statistical models by a wide margin. On others, a seasonal average does as well and is far easier to run, explain and fix. The honest answer to "Will machine learning improve my forecast?" is "It depends on the data, the horizon and whether the improvement is worth the cost." This guide explains where machine learning helps, where simple models win, how to compare them fairly with a worked holdout example and checked arithmetic, how to translate accuracy gains into inventory and cash value, and how to run a bake-off. Forecast quality feeds demand planning and inventory optimization and budgeting and forecasting.

What counts as machine learning here

Traditional statistical forecasting methods include moving averages, exponential smoothing, ARIMA and regression with seasonal terms. They model each series on its own history, with a small number of parameters. Machine learning methods, such as gradient boosted trees, random forests and neural networks, learn a flexible relationship between a target and many inputs, and often train a single model across many items. They can use extra information: price, promotions, weather, holidays, product attributes, store characteristics, and the sales of related items. Hybrid approaches combine statistical baselines with machine learning corrections.

Where machine learning tends to help

  1. Many related series. When you forecast thousands of items by location, a single model can learn shared patterns and improve forecasts for items with short or noisy history.
  2. Strong external drivers. Promotions, price changes, events, weather and marketing spend that explain large swings.
  3. Cold starts. New items with no history, where attributes of similar items provide a starting point.
  4. Complex interactions. Where the effect of price depends on the season or the channel.
  5. Intermittent demand with patterns that simple methods smooth away.
  6. Large data and automation needs, where forecasts must be generated frequently across a big catalog.

Where simple models win

  1. Few series with a long, stable history, such as total company revenue or a handful of major products.
  2. Short history, where a complex model has too little to learn from.
  3. Weak or unknown drivers, so there is little extra information to exploit.
  4. A need for explainability. Planners and executives who must understand and defend the number.
  5. Limited maintenance capacity, since machine learning models must be monitored, retrained and fixed.
  6. Small financial stakes, where a small accuracy gain is not worth the cost.

Published forecasting competitions have repeatedly found that simple methods are hard to beat on many series, and that combinations of methods tend to do better than any single one. That is a reason to test, not to dismiss machine learning.

A fair comparison: a worked holdout example

Compare methods on data none of them has seen. Suppose you hold out the last six months of an item's demand and generate forecasts from earlier history (hypothetical).

MonthActualSeasonal naive forecastMachine learning forecast
11009897
2110104107
39510099
4120112114
5105108108
6115110112
Total645

The absolute errors for the seasonal naive method are 2, 6, 5, 8, 3 and 5, totaling 29. For the machine learning method they are 3, 3, 4, 6, 3 and 3, totaling 22. The weighted absolute percentage error (WAPE) is total absolute error divided by total actual demand: 29 / 645 = 4.5 percent for the seasonal method and 22 / 645 = 3.4 percent for machine learning. Check the actual total: 100 + 110 + 95 + 120 + 105 + 115 = 645. The machine learning method reduces error by (29 - 22) / 29 = 24 percent in relative terms, or 1.1 points in absolute terms. That is a real improvement, but is it worth it? Test also for bias: the seasonal method's signed errors (forecast minus actual) are -2, -6, +5, -8, +3, -5, summing to -13, a bias of -13 / 645 = -2.0 percent, so it under-forecasts slightly. The machine learning method's signed errors are -3, -3, +4, -6, +3, -3, summing to -8, a bias of -1.2 percent. Both lean low. Six periods is also a very small test: a fair evaluation should cover many items and multiple forecast origins, not one series over six months.

Turning accuracy into money

Forecast error drives the safety stock needed to protect service. As a rough approximation, safety stock is proportional to the standard deviation of forecast error over the lead time. If the error falls by 24 percent, safety stock could fall by about the same share. Suppose this product family carries $500,000 of safety stock and the carrying cost rate is 20 percent a year (hypothetical).

  • Stock reduction: 0.24 × $500,000 = $120,000 (using the unrounded 24.1 percent gives about $120,700)
  • Annual carrying cost saving: 0.20 × 120,000 = $24,000
  • One-time cash release: $120,000

Compare with the cost of the machine learning approach: data preparation, model development, monitoring, retraining and the specialist time to support it. If that costs $30,000 a year for this one product family, the annual saving of $24,000 does not cover it. If the same approach runs across ten product families with similar gains, the saving is about $240,000 a year, and the cost grows far less than proportionally, so the case is strong. The lesson is that machine learning pays when applied at scale or where error is expensive, and may not pay for a single small series. It also shows why you should calculate the value before buying the technology.

Running a bake-off

  1. Define the decision and the horizon. Forecasting next week's demand by item and store differs from forecasting next year's revenue.
  2. Choose the accuracy measure that matches the use. WAPE and bias are robust choices for demand. Measure at the level where decisions are made.
  3. Set baselines: naive (last value), seasonal naive, and a good statistical method such as exponential smoothing.
  4. Use rolling-origin testing: forecast from several cut-off dates, not just one, and average the results.
  5. Compare on the same data with the same information available at forecast time.
  6. Segment the results: fast movers, slow movers, new items, promoted items. Machine learning may win in some segments and lose in others.
  7. Measure value: translate error reduction into inventory, service and cash.
  8. Consider operating cost: the people, systems and time to run and monitor each method.
  9. Consider a combination: averaging statistical and machine learning forecasts often beats either.

After you choose

Monitor accuracy and bias continuously. Compare against the baseline each month to confirm the model is still adding value. Retrain on a schedule or when performance degrades. Keep planners in the loop: allow documented overrides for known events, and track whether overrides improve or worsen the forecast (forecast value added). See operations KPIs. Keep the simple baseline running in parallel, so you always know what the complex model is buying you.

Common mistakes

  1. Comparing on training data and not on a holdout.
  2. Testing on one series or one period.
  3. No simple baseline.
  4. Ignoring bias.
  5. Measuring accuracy at an irrelevant level.
  6. Ignoring operating costs and skills.
  7. Using future information that would not be available at forecast time.
  8. Trusting a black box with no explanation for planners.

From forecast error to safety stock: a per-item view

The connection between accuracy and inventory can be made precise. A common formula for safety stock is the service factor times the standard deviation of demand error over the lead time. Take an item with a weekly forecast error standard deviation of 20 units and a lead time of 4 weeks (hypothetical). The error over the lead time scales with the square root of time: 20 × the square root of 4 = 20 × 2 = 40 units. For a 95 percent cycle service level, the service factor is 1.645, so safety stock is 1.645 × 40 = 65.8 units. Now suppose a better forecasting method reduces the weekly error standard deviation to 15 units. The lead-time error is 15 × 2 = 30 units, and safety stock is 1.645 × 30 = 49.4 units. The reduction is 65.8 - 49.4 = 16.4 units, or 25 percent. At a unit cost of $40, that is 16.4 × 40 = $658 less stock per item, and at a 20 percent carrying rate, $132 a year. Across 500 items the stock reduction is about $329,000 and the annual saving about $65,800. The figures show how a modest improvement in accuracy, applied across a catalog, becomes meaningful money, and also how little it is worth on a single item. They also show why the shape of the error matters: the formula uses the spread of errors, so a method that reduces large misses helps more than one that tightens small errors.

Hierarchies and reconciliation

Companies forecast at several levels: item, product family, region and total. Forecasts made separately at each level will not add up. Suppose item forecasts for a family sum to 1,000 units while the family-level forecast is 1,050, a 5 percent gap. Reconciliation methods adjust the forecasts so that they are coherent: bottom-up (sum the items), top-down (split the family forecast by historical shares) or a combination that weights each level by its reliability. Machine learning models trained across the hierarchy can produce consistent forecasts but still need a reconciliation check. In practice, planners need a single agreed number at each level, and the choice of method should be tested on accuracy at the level where decisions are made.

Probabilistic forecasts

A single number hides uncertainty. Many machine learning methods can produce a range, for example a median and a 90th percentile. If the median forecast for next month is 100 units and the 90th percentile is 130, a planner who wants a 90 percent chance of covering demand stocks 130 and carries 30 units of safety stock. Ranges also help finance: a revenue forecast of $4.8 million with a 10th to 90th percentile range of $4.3 to $5.2 million communicates risk better than a single figure. Check that the ranges are calibrated: about 90 percent of actuals should fall below the 90th percentile forecast over time. If only 75 percent do, the ranges are too narrow and the safety stock will be too low.

Governance for forecasting models

Keep a register of models in use: the purpose, owner, method, data, last retrain date, accuracy against baseline and approved use. Require a review before a model goes live and a periodic review thereafter. Record planner overrides and measure whether they improve the forecast. Document known limitations, such as poor performance on new products. When a model's results are used in the budget or in decisions about inventory purchases, finance and operations leaders should understand what drives it, even if they don't understand the algorithm.

FAQs

Is machine learning better than traditional forecasting?

Sometimes. It tends to help with many related series, strong external drivers and new items. For few stable series or short histories, simple methods often do as well.

How do I compare forecasting methods fairly?

Test on a holdout period using several forecast origins, the same data for each method, and an accuracy measure that matches your decision, along with bias.

How much data do I need?

For seasonal forecasts, at least two to three years of history per series, or many series to learn from in a pooled model.

Does a more accurate forecast always pay off?

Not always. Translate the error reduction into inventory and service value, and compare with the cost of the method.

What is forecast value added?

The change in accuracy contributed by each step in the forecasting process compared with a naive forecast, used to show which steps help.

This article is for general information. It is not accounting, tax, legal or investment advice, and examples use illustrative numbers rather than client data. Confirm decisions that carry financial or legal consequences with a qualified professional.

Better forecasts. Healthier inventory. More working capital.

Newtown Analytics advises growing consumer-product companies on demand planning and inventory optimization.