Aggregate Planning, S&OP and Integrated Business Planning

Introduction and Context

Supply chains rarely fail because an organization lacks a forecast or a production schedule in isolation. They fail because demand, supply, capacity, inventory, finance and customer commitments are planned independently. Aggregate planning and Sales and Operations Planning (S&OP) provide structured mechanisms for integrating these decisions across a medium-term horizon. Integrated Business Planning (IBP) extends S&OP by connecting operational plans more explicitly with financial, strategic, risk and portfolio decisions.

The central managerial problem is one of reconciliation. Market demand may exceed available capacity; procurement may face long lead times; finance may impose working-capital limits; and sales teams may promise delivery dates that operations cannot support. A robust planning process makes these conflicts visible, evaluates alternatives and produces one agreed plan.

Aggregate planning determines broad levels of production, workforce, inventory, backlog and capacity over an intermediate horizon, commonly 3–18 months. Material Requirements Planning (MRP) then translates the production plan into time-phased component requirements. Distribution Requirements Planning (DRP) extends planning through the distribution network. Available-to-Promise (ATP) and Capable-to-Promise (CTP) connect plans to realistic customer commitments.

Learning Objectives

After studying this chapter, the learner should be able to:

1. Explain the purpose, scope and logic of aggregate planning, S&OP and IBP.
2. Construct demand, supply and capacity plans using appropriate assumptions.
3. Apply chase, level and hybrid aggregate-planning strategies.
4. Explain how MRP, DRP, ATP and CTP connect tactical planning with execution.
5. Evaluate scenarios using cost, service, capacity, cash and risk criteria.
6. Diagnose common S&OP failures and recommend governance and technology practices.

1. Planning Horizons and Decision Hierarchy

Planning decisions are commonly organized into three horizons:

These horizons are linked but not interchangeable. A tactical plan should respect strategic capacity decisions, while operational schedules should remain consistent with the approved tactical plan. Feedback is also necessary: repeated operational infeasibility may indicate that the tactical or strategic plan requires revision.

Aggregate planning normally uses product families rather than individual stock-keeping units (SKUs). For example, a manufacturer may plan “industrial pumps” as one family even though the family contains many models. This reduces computational complexity and focuses management attention on total capacity and market balance.

2. Aggregate Planning Fundamentals

2.1 Demand, supply and balance variables

For each period t, a basic inventory balance is:

where:

• I_t = ending inventory in period t, in units;
• I_{t−1} = opening inventory;
• P_t = regular production;
• R_t = receipts from subcontracting or other external supply;
• D_t = demand or shipments;
• B_t = increase in backlog during the period.

If demand is fully met on time and no backlog is permitted, B_t = 0. If backlog is represented directly as a positive variable, an alternative convention is to write ending net inventory as inventory minus backlog. The convention must be stated because different planning systems use different signs.

A more general flow equation is:

This identity is dimensionally consistent: every term is measured in units. It applies to period-based planning when production and demand are aggregated within each period and timing within the period is not modeled.

2.2 Capacity

Capacity is not simply the number of machines. It depends on available time, staffing, efficiency, product mix, maintenance and quality losses. A practical capacity estimate is:

where C_t is effective capacity in standard units, N_t is the number of resources, H_t is scheduled hours per resource, S_t is the standard output rate per hour, and E_t is the combined availability and efficiency factor, expressed as a decimal. If 10 machines operate for 160 hours at 5 units per hour with an efficiency factor of 0.85, capacity is 6,800 units.

The formula assumes that the resources are sufficiently interchangeable and that the output rate is represented in common standard units. In a highly mixed environment, capacity must instead be modeled by work centre, product family or constraint resource.

A useful capacity-load ratio is:

where L_t is required load and C_t is available effective capacity. A ratio above 1 indicates infeasibility unless overtime, subcontracting, backlog or other capacity actions are available. Sustained utilization near 100% is also risky because variability and downtime reduce effective service performance.

2.3 Planning costs

An aggregate plan may include:

• regular-time production cost;
• overtime cost;
• subcontracting cost;
• hiring and training cost;
• layoff or severance cost;
• inventory holding cost;
• backlog, expediting or lost-sales cost;
• transportation and changeover cost;
• fixed capacity and working-capital cost.

A simplified total-cost objective is:

Here, T is the number of periods; P^r, P^o and P^s are regular, overtime and subcontracted production; I is ending inventory; B is backlog; H and L are hiring and layoff quantities; and the c and h terms are unit costs. The model is meaningful only when costs are comparable, units are defined consistently and constraints such as capacity, workforce and minimum inventory are included.

This formulation is a linear programming representation when all costs are linear and variables are continuous. Integer or mixed-integer programming is needed when decisions involve indivisible machines, shifts, trucks, setup choices or fixed charges.

3. Aggregate-Planning Strategies

3.1 Level strategy

A level strategy keeps production and, where possible, workforce relatively stable. Demand variation is absorbed through inventory, backlog, overtime or temporary capacity. Advantages include workforce stability, simpler operations and lower hiring-and-layoff disruption. Disadvantages include inventory investment, obsolescence and possible backlog.

3.2 Chase strategy

A chase strategy adjusts production or workforce to follow demand. It can reduce inventory and is attractive for perishable or highly configurable products. However, frequent hiring, layoffs, training, schedule changes and supplier instability may create hidden costs and quality problems.

3.3 Hybrid strategy

Most organizations use a hybrid approach. A stable core workforce provides baseline capacity; overtime handles peaks; inventory is built before predictable seasons; subcontractors provide flexibility; and selected demand-shaping actions shift demand away from constrained periods.

Demand shaping includes pricing, promotions, reservations, allocation rules, product substitution and differentiated service levels. It is important to distinguish demand shaping from demand distortion: a promotion that creates genuine incremental demand is different from a sales forecast inflated merely to obtain capacity.

4. Worked Aggregate-Planning Example

Consider a product family planned over three months. Opening inventory is 100 units, and management requires ending inventory of at least 50 units. Forecast demand is 800, 1,200 and 700 units. Regular capacity is 900 units per month, overtime capacity is 200 units per month, and subcontracting is available without a stated upper limit. Assume no beginning backlog.

A feasible hybrid plan is:

Using the inventory identity:

• Month 1: 100 + 900 − 800 = 200.
• Month 2: 200 + 900 + 200 − 1,200 = 100.
• Month 3: 100 + 900 − 700 = 300.

The plan is feasible and finishes above the required safety level. Its utilization of regular capacity is 100% in every month, while overtime is used only in month 2. Whether this is the preferred plan cannot be determined from feasibility alone. Management must compare its cost with alternatives involving early inventory, subcontracting or demand shifting.

Suppose regular production costs 10 per unit, overtime costs 14, subcontracting costs 18, inventory holding costs 1 per unit per month and the ending inventory requirement has no separate penalty. The production cost of the plan is:

3 × 900 × 10 + 200 × 14 = 30,800

Inventory holding cost depends on the organization’s convention. If the cost is charged on ending inventory each month, it is 1 × (200 + 100 + 300) = 600, giving a subtotal of 31,400. If average inventory is used, the calculation differs. This illustrates why cost definitions must be agreed before comparing scenarios.

5. Sales and Operations Planning

S&OP is a recurring cross-functional process that converts market intelligence and operational capability into one approved medium-term plan. It is not merely a meeting and not merely a forecast. Its value lies in structured reconciliation and executive decision-making.

A typical monthly S&OP cycle includes:

1. Data gathering and portfolio review: collect shipments, orders, inventory, capacity, supplier information and product changes.
2. Demand review: produce an unconstrained, consensus demand plan using statistical forecasts, customer intelligence, promotions and market assumptions.
3. Supply review: test capacity, labour, materials, suppliers, inventory policies, logistics and constraints.
4. Pre-S&OP reconciliation: develop scenarios and identify gaps, risks, trade-offs and decisions requiring executive attention.
5. Executive S&OP: approve one plan, decide on exceptions and assign accountability.
6. Implementation and monitoring: translate the plan into MRP, DRP, procurement, production, allocation and financial actions.

The unconstrained demand plan answers “What might customers require?” The constrained supply plan answers “What can the network provide?” The agreed plan answers “What will the organization pursue, and under what rules?”

5.1 S&OP governance

Effective S&OP requires a common calendar, defined data ownership, decision rights, escalation thresholds and disciplined assumptions. The process should distinguish facts from assumptions. For example, confirmed customer orders are not equivalent to a sales estimate, and a supplier’s quoted capacity is not equivalent to validated available capacity.

Useful S&OP measures include forecast bias, forecast accuracy, service level, inventory turns, plan adherence, capacity utilization, backlog, revenue attainment and working capital. No single measure is sufficient. Optimizing forecast accuracy while creating excessive inventory is not successful planning.

Forecast error can be summarized in several ways. Mean absolute deviation is:

where D_t is actual demand, F_t is forecast demand and n is the number of observations. MAD is expressed in demand units and is less sensitive to cancellation of positive and negative errors than mean error. Forecast accuracy metrics must specify their denominator and treatment of zero demand; otherwise comparisons can be misleading.

6. Integrated Business Planning

IBP extends S&OP in four important directions. First, it links operational scenarios to financial outcomes such as revenue, gross margin, cash and capital expenditure. Second, it integrates the product portfolio, innovation pipeline and end-of-life decisions. Third, it includes strategic risks such as geopolitical disruption, supplier concentration and regulatory change. Fourth, it uses broader enterprise governance rather than treating supply-chain planning as an operations-only responsibility.

IBP should not become an unnecessarily elaborate reporting process. Its purpose is to improve decisions, not to produce more slides. A sound IBP process asks:

• What demand and market assumptions are changing?
• What physical and organizational constraints limit response?
• Which trade-offs affect service, margin, cash and resilience?
• Which decision must be made now, and which can be deferred?
• What early-warning indicators will trigger plan revision?

A scenario should include assumptions, decisions, time-phased consequences, risks and ownership. “Increase supply” is not a complete scenario unless it identifies the required labour, materials, capacity investment, lead time, cost and service effect.

7. MRP, DRP, ATP and CTP Connections

7.1 Material Requirements Planning

MRP translates a master production schedule into planned orders for components and materials. It requires a bill of materials, inventory records, scheduled receipts, lead times, lot-sizing rules and a time-phased requirement schedule.

For a simple item with no safety stock and fixed lead time, net requirements in period t can be expressed as:

where NR_t is net requirement, GR_t is gross requirement, OH_t is projected available on-hand inventory before the receipt, SR_t is usable scheduled receipt and SS_t is desired safety stock. The exact sign convention varies by software, so the planning logic and record definitions must be documented.

If a planned receipt is required in period t and the item lead time is ℓ periods, the planned order release is normally scheduled in period t − ℓ. This assumes deterministic lead time and no capacity limitation. In practice, supplier reliability, transportation variability, order calendars and lot sizes may require buffers.

MRP is highly sensitive to data quality. An inaccurate bill of materials, obsolete inventory record or unrealistic lead time can generate apparently precise but operationally wrong recommendations.

7.2 Distribution Requirements Planning

DRP applies time-phased planning to distribution networks. It uses forecast and order requirements at stocking locations, transportation lead times, distribution policies, safety stock and available inventory to determine replenishment from supplying locations. DRP coordinates factory, central warehouse, regional warehouses and sometimes customer-facing locations.

The key distinction is that MRP primarily plans dependent material demand arising from a production structure, while DRP plans replenishment across a distribution structure. Both use time-phased balances and planned-order logic, and both must be reconciled with transportation and warehouse capacity.

7.3 Available-to-Promise

ATP indicates how much uncommitted supply can be promised to customers. In a simple discrete-order environment, ATP for the first period is often calculated as:

For later periods, ATP is generally:

MPS is the master production schedule. The exact formula depends on whether customer orders, forecasts, safety stock and planned receipts are included in the organization’s ATP convention. Therefore ATP values should always be accompanied by a definition.

ATP is not the same as physical inventory. It is an allocation concept: inventory may exist but be reserved for another customer, quality inspection or a different channel. Conversely, future production may be promiseable if the schedule and materials are credible.

7.4 Capable-to-Promise

CTP extends ATP by checking whether a requested order can be produced or procured, considering finite capacity, material availability, routings and lead times. CTP is especially important when products are configured to order or when the standard production schedule is frequently constrained. It may propose a realistic delivery date, an alternative configuration or a split shipment.

8. Scenario Analysis and Reconciliation

Scenario analysis should compare feasible alternatives rather than merely optimistic and pessimistic narratives. A scenario model may vary demand, capacity, supplier lead time, labour availability, prices, inventory policy and service commitments.

A practical scenario table is:

Reconciliation requires explicit prioritization. For example, a firm may protect strategic customers, preserve regulatory service levels and allow lower-priority orders to move to later dates. Such rules should be transparent and approved before a crisis.

Multi-criteria evaluation is often better than a single cost objective. A weighted score may be used for screening:

where C, S, R and K are normalized cost, service, resilience and cash measures, and the weights sum to 1. This is not an objective economic law; it is a managerial decision model. Results depend on normalization and weights, so sensitivity analysis is essential.

9. Illustrative Case: Northstar Appliances

Background

Northstar Appliances manufactures a family of energy-efficient refrigeration units. Demand is seasonal, rising sharply before summer. The company has one main plant, two regional distribution centres and a concentrated supplier base for compressors. Sales, operations and finance currently maintain separate spreadsheets.

Problem

The unconstrained sales forecast for May is 14,000 units, while the plant’s regular capacity is 10,000 units. The firm has 2,000 units of opening inventory, a minimum desired ending inventory of 1,000 units and a maximum overtime capacity of 2,500 units. A compressor supplier can provide only 11,500 units in May. Sales has already offered a short lead time to several large retailers.

Analysis

The total units available before considering the ending inventory requirement are:

2,000 + 10,000 + 2,500 = 14,500

However, supply of finished units is also constrained by compressors to 11,500 units unless inventory contains usable finished units or another source is approved. With a required ending inventory of 1,000 units, the maximum May shipments supported by the compressor constraint are approximately:

2,000 + 11,500 − 1,000 = 12,500

Thus, the 14,000-unit demand plan has a 1,500-unit gap before considering quality, transportation or other components. The gap cannot be solved by authorizing more plant overtime alone.

Approach and solution

The cross-functional team develops three scenarios:

1. Expedite compressors: pay premium freight and supplier overtime for 1,000 additional units, while allocating the remaining 500 units to June.
2. Substitute product: offer a technically compatible model to selected retailers, subject to regulatory and customer approval.
3. Protect strategic demand: allocate available units to contractual and high-margin customers, defer low-priority orders and use a targeted promotion to shift some demand into June.

The executive team selects a combination of scenarios 1 and 3. The decision includes a revised ATP file, customer allocation rules, a June recovery schedule and an approved premium-freight budget. Finance records the margin effect rather than evaluating the decision only through unit volume.

Outcome

Northstar avoids promising 14,000 units without supply support. It ships 13,500 units in May, protects strategic accounts, carries 1,000 units of ending inventory and schedules the balance for June. The company then approves a second compressor source and introduces a monthly IBP review of supplier concentration.

Learning points

The case demonstrates that aggregate planning is not simply a production exercise. The binding constraint was a component supplier, while the commercial decision involved ATP, allocation and customer priorities. The preferred solution was a coordinated trade-off among service, margin, resilience and cash.

10. Technology, AI and Data Governance

Advanced planning systems can integrate enterprise resource planning, customer orders, supplier portals, warehouse data, transportation information and financial models. They can simulate constraints, calculate ATP, generate MRP and DRP proposals and expose scenario impacts.

Artificial intelligence and machine learning can support demand sensing, anomaly detection, promotion analysis and risk prediction. However, AI does not remove the need for managerial judgment. A model trained on historical stockouts may interpret constrained sales as low demand. A model trained on past allocations may reproduce discriminatory or commercially inappropriate customer priorities. Planners should therefore examine data lineage, forecast bias, explainability, override policies and performance by segment.

Important controls include:

• one governed definition for demand, inventory, capacity and service;
• role-based access and approval of master-data changes;
• version control for scenarios and assumptions;
• audit trails for overrides and customer allocations;
• monitoring for model drift and systematic bias;
• cybersecurity protection for supplier and customer data;
• human approval for material commercial or safety decisions.

Technology improves visibility and speed, but poor process design can automate inconsistency. A sophisticated system with unreliable bills of material, stale lead times or conflicting calendars will produce confident errors.

11. Challenges and Limitations

Aggregate planning models simplify reality. Common limitations include:

1. Aggregation error: product families may conceal bottleneck differences, mix effects and substitution constraints.
2. Forecast uncertainty: a consensus forecast remains uncertain and should be represented with ranges or scenarios.
3. Linear-cost assumptions: hiring, setup and transportation costs may be discontinuous.
4. Capacity ambiguity: nominal capacity may overstate feasible output under variability.
5. Lead-time instability: MRP and DRP plans become unreliable when lead times are treated as fixed but are not.
6. Organizational incentives: sales may prefer optimistic forecasts, while operations may prefer conservative commitments.
7. Excessive meeting focus: S&OP can deteriorate into reporting rather than decision-making.
8. Working-capital neglect: a plan can meet demand while creating unaffordable inventory.

Best practice is to combine quantitative models with clear assumptions, sensitivity testing, operational validation and executive accountability.

12. Best-Practice Checklist

A professional aggregate planning and IBP system should:

• use a common calendar and agreed planning horizon;
• plan at the right level of aggregation;
• separate unconstrained demand from constrained supply;
• model bottleneck resources and material constraints explicitly;
• include inventory, backlog, overtime and subcontracting policies;
• connect aggregate plans to MRP, DRP, ATP and CTP;
• compare scenarios using service, cost, cash, margin and resilience;
• document assumptions, ownership and decision rights;
• use exception-based escalation rather than endless detail;
• review forecast bias and plan adherence;
• protect data quality and maintain auditability;
• convert executive decisions into measurable actions.

Chapter Summary

Aggregate planning establishes medium-term production, workforce, inventory, sourcing and capacity decisions at the product-family level. Level, chase and hybrid strategies represent different ways of balancing demand variability and operational stability. Inventory-balance equations and capacity calculations provide the foundation for feasibility analysis, while cost models help compare alternatives.

S&OP is a cross-functional process that reconciles unconstrained demand with constrained supply and produces one agreed plan. IBP extends this discipline by integrating financial, portfolio, strategic and risk considerations. MRP translates the plan into material requirements; DRP coordinates distribution replenishment; ATP governs promiseable supply; and CTP checks realistic production capability.

Effective planning depends on scenario analysis, transparent assumptions, sound governance and reliable data. Technology and AI can improve speed and visibility, but they require controls, human judgment and attention to bias. The managerial objective is not to eliminate trade-offs but to make them explicit and choose them deliberately.

Key Terms

Aggregate planning: Medium-term planning of production, inventory, workforce and capacity, usually by product family.

Available-to-Promise (ATP): Uncommitted supply that can be promised to customers under a defined planning convention.

Backlog: Demand accepted but not yet fulfilled.

Capacity: The effective ability of a resource or system to produce output within a period.

Capable-to-Promise (CTP): A promise calculation that verifies material and finite-capacity feasibility.

Chase strategy: A plan that adjusts production or workforce to follow demand.

Consensus demand plan: A cross-functional demand estimate agreed after combining statistical and market information.

Distribution Requirements Planning (DRP): Time-phased replenishment planning across a distribution network.

Integrated Business Planning (IBP): An extended S&OP process linking operational, financial, portfolio and strategic decisions.

Level strategy: A plan that maintains relatively stable production or workforce levels.

Master Production Schedule (MPS): A time-phased schedule for end items or product families.

Material Requirements Planning (MRP): A system that calculates time-phased component requirements from production plans, bills of material and inventory records.

Plan adherence: The degree to which actual execution follows the approved plan.

Safety stock: Inventory held to protect against demand or supply uncertainty.

Sales and Operations Planning (S&OP): A recurring process for reconciling demand, supply and management decisions.

Scenario analysis: Evaluation of alternative assumptions and their operational and financial consequences.

Service level: A measure of the extent to which customer demand is fulfilled according to the agreed promise.

Supply constraint: A limitation on materials, labour, capacity, logistics or other resources.

Working capital: Funds tied up in operating assets such as inventory and receivables, net of relevant operating liabilities.

Review Questions

Short Answer Questions

1. What is the principal purpose of aggregate planning?
2. Distinguish between a level strategy and a chase strategy.
3. Why must unconstrained demand be separated from constrained supply?
4. What is the difference between ATP and CTP?
5. State two data requirements for a reliable MRP system.

Long Answer Questions

1. Explain the stages of a monthly S&OP cycle and the decision outputs of each stage.
2. Compare level, chase and hybrid aggregate-planning strategies, including their operational and financial implications.
3. Explain how MRP and DRP connect tactical planning with execution across a supply chain.
4. Discuss how IBP extends conventional S&OP and why financial integration matters.
5. Evaluate the governance, data and technology requirements for an effective S&OP process.

Analytical / Application Questions

1. A firm begins a month with 500 units, produces 1,000 units and faces demand of 1,300 units. Calculate ending inventory assuming no receipts or backlog, and explain whether the result satisfies a required safety stock of 250 units.
2. A three-month demand plan is 900, 1,400 and 800 units. Regular capacity is 1,000 units per month, overtime capacity is 200 units per month and opening inventory is 100 units. Construct a feasible plan that ends with at least 100 units, stating any assumptions.
3. A key supplier announces a six-week disruption during a seasonal peak. Design an S&OP/IBP scenario process covering demand allocation, alternative supply, ATP revision, financial evaluation and executive governance.

Multiple Choice Questions with Answers

Question 1

Which planning horizon is most commonly associated with aggregate planning?

A. Minutes to hours

B. 3–18 months

C. 10–30 years only

D. Only the current shift

Correct Answer: B. 3–18 months

Question 2

In the inventory balance equation, what does P_t usually represent?

A. Period demand

B. Ending backlog

C. Production during period t

D. Safety stock policy

Correct Answer: C. Production during period t

Question 3

A chase strategy primarily responds to demand variation by changing which factor?

A. Production or workforce levels

B. Product warranty terms

C. Accounting depreciation

D. Bill-of-materials structure

Correct Answer: A. Production or workforce levels

Question 4

What is the main purpose of S&OP?

A. To replace all operational scheduling

B. To reconcile demand and supply into an agreed plan

C. To calculate employee tax deductions

D. To eliminate all demand uncertainty

Correct Answer: B. To reconcile demand and supply into an agreed plan

Question 5

Which system translates an end-item production schedule into component requirements?

A. DRP

B. ATP

C. MRP

D. CRM

Correct Answer: C. MRP

Question 6

A plant has 10 machines, 160 scheduled hours per machine, an output rate of 5 units per hour and efficiency of 0.85. What is effective capacity?

A. 800 units

B. 4,000 units

C. 6,800 units

D. 8,000 units

Correct Answer: C. 6,800 units

Question 7

What additional issue does CTP examine beyond a basic ATP calculation?

A. Whether production capacity and materials can support the promise

B. Whether a customer has paid income tax

C. Whether historical demand was seasonal

D. Whether a product has a barcode

Correct Answer: A. Whether production capacity and materials can support the promise

Question 8

Which statement best describes IBP?

A. It focuses only on warehouse picking

B. It extends S&OP by linking operational plans with financial, portfolio and strategic decisions

C. It is a replacement for all enterprise strategy

D. It excludes risk analysis

Correct Answer: B. It extends S&OP by linking operational plans with financial, portfolio and strategic decisions

Question 9

If beginning inventory is 100 units, production is 900 units and demand is 800 units, what is ending inventory assuming no backlog or other receipts?

A. 0 units

B. 100 units

C. 200 units

D. 1,800 units

Correct Answer: C. 200 units

Question 10

Which is a critical control for AI-supported supply-chain planning?

A. Removing all human review

B. Ignoring data lineage

C. Monitoring model drift and maintaining audit trails

D. Using only historical stockout-constrained sales as demand

Correct Answer: C. Monitoring model drift and maintaining audit trails