Pyramid Forecasting
Definition
Pyramid forecasting is a technique that reconciles forecasts made at different levels of aggregation — item, product family, and total business — so that detailed and summary plans always roll up and force down to consistent numbers.
In Practice
Forecasts are naturally made at different altitudes: sales leadership commits to a revenue number, demand planners forecast product families, and MRP needs item-level detail. Pyramid forecasting first rolls item forecasts up to family and business level, then management adjusts the totals, and finally the approved totals are forced back down proportionally so every level tells the same story.
For example, if item forecasts roll up to 9,500 units for a family but S&OP approves 10,000, each item forecast is scaled by 10,000/9,500. Aggregate forecasts are also statistically more accurate, so the pyramid lets accuracy at the top discipline noise at the bottom.
Frequently Asked Questions
How does pyramid forecasting work?
In two passes: roll-up and force-down. Item-level forecasts are summed to product family and business totals; management reviews and adjusts the aggregate numbers in S&OP; the approved totals are then pushed back down, scaling each item proportionally so all levels reconcile to one consistent plan.
Why forecast at aggregate levels at all?
Aggregate forecasts are more accurate because random errors at item level partially cancel out — a family forecast might run 10% error while its items run 30%. Forecasting families and forcing down lets planners exploit that accuracy while still producing the item detail MRP needs.
Related Calculators
Related Terms
Demand forecasting is the practice of estimating future customer demand using historical data, statistical models, and market knowledge. It provides the quantitative foundation for demand planning, inventory targets, and capacity decisions.
Product FamilyA product family is a group of products that share common characteristics — similar materials, processes, or market purpose — and are planned together as one unit in forecasting, S&OP, and capacity planning.
Demand PlanningDemand planning is the process of predicting future customer demand and shaping it into a consensus plan that drives supply, inventory, and financial decisions. It combines statistical forecasting with market intelligence from sales, marketing, and customers.
OutlierAn outlier is a data point that falls far outside the normal pattern of a series — such as a demand spike from a one-time bulk order — and can distort forecasts, safety stocks, and performance metrics if left untreated.