Aggregate Production Planning

Chapter 9
Sales and Operations Planning and Integrated Business Planning

Post Graduate Program in Production Management
Aggregate Production Planning   •   Post Graduate

Sales and Operations Planning and Integrated Business Planning

Introduction and strategic context

Sales and Operations Planning (S&OP) is the recurring management process through which an organization reconciles market demand with its ability to supply products and services. Integrated Business Planning (IBP) extends S&OP by connecting operational plans explicitly with financial plans, strategic priorities, risk management, and executive decision-making. Both are planning systems rather than merely meetings or software applications.

The central problem is structural: commercial functions seek growth, variety, responsiveness, and high customer service, while operations seek stability, efficiency, manageable capacity, and economical inventory. Finance seeks profitable growth and cash discipline. S&OP/IBP creates a common decision environment in which these competing objectives are made visible and resolved at an appropriate organizational level.

A sound process does not attempt to predict the future perfectly. It creates a disciplined way to revise assumptions, evaluate alternatives, assign accountability, and commit the organization to one feasible plan. The planning horizon commonly extends from 12 to 24 months, with monthly executive reviews and more frequent operational updates when volatility is high.

Learning objectives

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

  1. Explain the purpose, scope, and evolution of S&OP and IBP.
  2. Design a cross-functional S&OP/IBP cycle and define its governance.
  3. Construct demand, supply, reconciliation, and executive-review processes.
  4. Integrate operational plans with revenue, margin, working capital, and cash considerations.
  5. Diagnose cross-functional conflict and establish accountability mechanisms.
  6. Evaluate technology, analytics, ethical, and implementation issues.

1. Foundations and terminology

1.1 Aggregate planning and S&OP

Aggregate production planning determines medium-term levels of production, workforce, inventory, capacity utilization, subcontracting, and backlog for product families or other meaningful aggregates. S&OP places this aggregate plan within a broader enterprise process. It incorporates customer, market, commercial, financial, and supply-network information.

Important terms include:

  • Unconstrained demand: the quantity customers are expected to purchase if supply limitations do not restrict sales.
  • Constrained demand or feasible demand: demand that can be served under available capacity, materials, labor, and policy constraints.
  • Consensus demand plan: the cross-functional demand view approved for planning purposes.
  • Supply plan: the feasible response involving capacity, inventory, production, procurement, distribution, and backlog.
  • Gap: a quantified difference between demand and feasible supply, or between the operational plan and financial target.
  • Scenario: a coherent set of assumptions and resulting actions, such as a base, upside, or disruption scenario.
  • Time fence: a boundary distinguishing periods in which changes are restricted from periods in which plans remain flexible.
  • Decision rights: explicit authority to approve, reject, or escalate a planning decision.

1.2 From traditional S&OP to IBP

Traditional S&OP often concentrated on production, inventory, and capacity. Modern IBP broadens the process in four ways. First, it includes commercial assumptions such as price, promotion, market entry, and product lifecycle. Second, it translates operational alternatives into financial consequences. Third, it incorporates strategic risks and opportunities. Fourth, it makes senior executives accountable for trade-offs rather than expecting operational departments to resolve every conflict.

IBP is not necessarily a separate process. In a mature organization, it is the strategic and financially integrated form of S&OP. The distinction is therefore one of scope and maturity, not a universal difference in terminology.

2. The S&OP/IBP operating model

A robust operating model has five features:

  1. A defined planning hierarchy: strategic, tactical, and operational decisions are separated but linked.
  2. A common data model: demand, supply, inventory, financial, and master-data definitions are consistent.
  3. A regular cadence: activities occur at known times with clear inputs and outputs.
  4. A single set of numbers: alternative assumptions may exist, but the committed plan is unambiguous.
  5. Explicit governance: owners, escalation thresholds, and decision rights are documented.

The usual monthly cycle contains the following stages:

StagePrimary purposeTypical ownerPrincipal output
Data and portfolio reviewEstablish reliable baseline informationS&OP process ownerValidated planning data
Demand reviewBuild an unconstrained, consensus demand planSales/marketingDemand plan and assumptions
Supply reviewTest feasibility and formulate responsesOperations/supply chainConstrained supply plan and gaps
Pre-S&OP reconciliationCompare alternatives and quantify trade-offsS&OP manager, financeRecommended scenarios
Executive S&OP/IBPDecide on unresolved trade-offsExecutive sponsorApproved plan and decisions
Deployment and accountabilityConvert decisions into actions and measuresFunctional ownersAction register and performance review

The stages should be sequential enough to protect decision quality, yet iterative enough to allow clarification. A demand meeting should not be used to negotiate production feasibility; a supply meeting should not silently rewrite market assumptions.

3. Demand review: creating a credible market view

The demand review begins with a statistical baseline, but it does not end there. The baseline may use historical shipments, orders, installed-base information, market indicators, promotions, customer intelligence, and product-lifecycle assumptions. Sales and marketing then add documented overrides.

A basic forecast-error measure is:

et = At − Ft

where At is actual demand in period t, Ft is the forecast issued for that period, and et is forecast error in demand units. Positive error indicates underforecasting. For a set of n periods, mean absolute deviation is:

MAD = (∑|At − Ft|) ÷ n

MAD is expressed in units and is useful for describing typical absolute error. Mean absolute percentage error is:

MAPE = [∑(|At − Ft| ÷ |At|) ÷ n] × 100%

MAPE is unsuitable when actual demand is zero or close to zero, and it can overweight low-volume items. Forecast metrics should therefore be selected by demand pattern and decision purpose rather than used mechanically.

The demand review should answer:

  • What changed relative to the previous cycle?
  • Which assumptions explain the change?
  • What demand is genuinely incremental, and what is merely shifted between periods or channels?
  • What is the probability and timing of upside and downside scenarios?
  • Are sales incentives encouraging unprofitable or operationally harmful demand?

A useful demand plan distinguishes baseline demand from event-driven adjustments. Overrides should have an owner, rationale, expiry date, and confidence assessment. Otherwise, the process becomes a political contest in which the highest forecast wins.

Forecast bias and behavioral discipline

Bias is systematic over- or underforecasting. One simple measure is mean error:

ME = (∑(At − Ft)) ÷ n

A positive ME indicates systematic underforecasting under the stated sign convention. Bias is different from random forecast error: a forecast may have high variability but little bias, or low variability with persistent bias. Sales targets must not be confused with unbiased forecasts. A target expresses aspiration; a forecast expresses the most credible expectation given available evidence.

4. Supply review: testing feasibility and resilience

The supply review converts the demand plan into a feasible response. It examines production capacity, labor, materials, supplier capability, warehouse and transport capacity, inventory policy, lead times, quality constraints, and maintenance requirements.

At an aggregate level, the inventory balance for period t may be represented as:

It = It−1 + Pt + Rt − Dt − Lt

where It is ending inventory, Pt is production or internal supply, Rt is received external supply, Dt is demand served, and Lt is losses, scrappage, or other withdrawals. All variables must use the same units and time period. If backlog is permitted, demand not served in period t must be represented separately rather than incorrectly treated as inventory consumption.

A capacity balance can be stated as:

Required capacityt ≤ Available capacityt

If required capacity exceeds available capacity, management must choose among actions such as overtime, subcontracting, alternate routing, inventory prebuild, demand shaping, product prioritization, or capital investment. Capacity is multidimensional: labor hours, machine hours, tooling, qualified suppliers, storage, and distribution capacity may each be binding.

The supply review should distinguish:

  • Permanent capacity: normal available capability under standard policies.
  • Flexible capacity: overtime, alternate shifts, temporary labor, or subcontracting.
  • Strategic capacity: new equipment, facilities, technology, or supplier development.
  • Protected capacity: capability reserved for strategic customers, safety-critical products, or regulatory commitments.

Risk analysis is essential. A plan that is feasible only if every supplier delivers perfectly is not robust. Scenario analysis should test demand volatility, supplier failure, transport disruption, labor shortages, quality holds, and sudden regulatory changes.

5. Pre-S&OP reconciliation and scenario evaluation

Pre-S&OP is the analytical and managerial bridge between functional reviews and executive decisions. Its purpose is not to produce a compromise by averaging incompatible proposals. It should expose alternatives and their consequences.

A scenario record should state:

  1. assumptions and probability where relevant;
  2. demand, supply, inventory, service, and financial results;
  3. constraints and implementation lead times;
  4. risks, reversibility, and trigger conditions;
  5. accountable owner and decision required.

Financial integration is central. A simplified contribution calculation is:

Contribution = Revenue − Variable cost

and:

Revenue = ∑(Selling pricei × Quantity soldi)

where i indexes products, customers, or channels. The calculation is meaningful only when selling prices, discounts, returns, variable manufacturing, logistics, and other included costs are defined consistently. Fixed costs should not be subtracted from contribution unless the analysis explicitly changes from contribution to operating profit.

Working capital implications can be approximated through inventory value, receivables, and payables. A common cash-conversion indicator is:

Cash conversion cycle = DIO + DSO − DPO

where DIO is days inventory outstanding, DSO is days sales outstanding, and DPO is days payables outstanding. The measure is a financial diagnostic, not a substitute for operational analysis; shortening it indiscriminately can damage service or supplier relationships.

Scenario selection should consider profit, cash, service, risk, strategic fit, and reversibility. A plan with the highest expected margin may be inferior if it creates unacceptable regulatory or continuity risk.

6. Executive decision-making and accountability

The executive review should focus on decisions that cannot or should not be made lower in the organization. Typical decisions include:

  • accepting or rejecting a demand–capacity gap;
  • prioritizing customers or product families;
  • approving overtime, subcontracting, inventory build, or capital expenditure;
  • changing prices, promotions, or launch timing;
  • accepting service or margin consequences;
  • allocating scarce supply across businesses;
  • authorizing contingency actions and trigger thresholds.

Executives should receive a concise decision pack containing the recommended plan, alternatives, assumptions, unresolved gaps, financial effects, risks, and required decisions. Discussion should begin with exceptions and decisions, not with a slide-by-slide recital of data.

Accountability requires more than naming a department. Each decision should have one accountable owner, supporting contributors, a due date, a measurable outcome, and an escalation route. A RACI matrix can distinguish who is Responsible, Accountable, Consulted, and Informed. The accountable role must have authority commensurate with the obligation.

Performance measures should combine outcome and process indicators:

DimensionIllustrative measures
Demand qualityForecast accuracy, bias, override value
Supply performanceSchedule attainment, capacity utilization, supplier reliability
Customer outcomeFill rate, on-time delivery, backlog age
Financial outcomeRevenue, contribution, inventory value, cash conversion
Process healthDecision closure, plan adherence, cycle timeliness

Metrics can create dysfunctional behavior. For example, maximizing utilization may increase inventory and reduce responsiveness. Therefore, measures should be interpreted as a balanced system rather than as isolated targets.

7. Cross-functional conflict resolution

Conflict is not evidence that S&OP has failed. It often reveals legitimate differences in objectives, information, risk tolerance, or time horizon. The goal is productive conflict followed by an explicit decision.

Common conflict patterns include sales requesting a high forecast to secure capacity, operations resisting volatility, finance challenging margin assumptions, and procurement seeking volume commitments that conflict with inventory objectives. Resolution should follow a structured sequence:

  1. Clarify the decision: State what must be decided, by when, and at what level.
  2. Separate facts from assumptions: Identify data sources, confidence, and missing evidence.
  3. Make trade-offs visible: Quantify service, cost, cash, margin, risk, and strategic effects.
  4. Generate options: Include demand, supply, timing, pricing, and investment responses.
  5. Apply agreed decision criteria: Use organizational priorities rather than departmental preferences.
  6. Escalate by rule: Escalate when thresholds, policy limits, or unresolved conflicts are reached.
  7. Record and review: Document the decision, owner, trigger, and learning.

A “one-number” culture should not suppress uncertainty. A single committed plan can coexist with probability-weighted scenarios and explicit ranges. Psychological safety is also important: employees must be able to report bad news without being punished for revealing a gap.

8. Technology, data governance, and artificial intelligence

S&OP/IBP technology may include enterprise resource planning, advanced planning systems, demand-planning tools, business-intelligence dashboards, scenario engines, and collaborative workflow platforms. Technology improves speed and transparency only when master data, calendars, units of measure, hierarchies, and ownership are controlled.

Artificial intelligence can support demand sensing, anomaly detection, promotion analysis, supplier-risk monitoring, and scenario generation. It should not be treated as an autonomous decision-maker. Governance should address:

  • data lineage and quality;
  • explainability of recommendations;
  • bias across customers or products;
  • privacy and commercial confidentiality;
  • human approval for material decisions;
  • model drift and performance monitoring;
  • cybersecurity and access control.

A sophisticated model with unreliable product hierarchies can produce precise but misleading recommendations. The process must therefore distinguish analytical confidence from numerical precision.

9. Illustrative case: Meridian Appliances

Background

Meridian Appliances, a fictional mid-sized manufacturer, sells refrigerators through retailers and direct channels. Its monthly S&OP meeting had become a dispute between sales, operations, and finance. Sales forecasts were frequently increased before executive meetings; operations responded with overtime and premium freight; finance later reported excess inventory and weak contribution.

Problem

A new energy-efficient refrigerator was planned for a major promotion in August. Marketing expected demand of 18,000 units, while the statistical baseline was 12,000. Available August capacity was 14,000 units, and an additional 3,000 units could be produced through approved overtime. Component supplier lead time was ten weeks, so a late decision would not create immediate supply.

The demand team assessed a 60% probability of 18,000 units and a 40% probability of 12,000 units. The supply team proposed producing 14,000 units in August, prebuilding 2,000 units in July, and reserving overtime for confirmed retailer orders. Finance warned that unsold finished goods would tie up cash and that premium components would reduce contribution.

Analysis and reconciliation

The executive team considered three scenarios:

ScenarioSupply responseService implicationPrincipal risk
A: AggressivePrebuild 4,000; use all overtimeStrong service under upsideExcess inventory and cash exposure
B: BalancedPrebuild 2,000; conditional overtimeGood service with flexibilityRequires rapid order visibility
C: ConservativeNo prebuild; normal capacity onlyShortfall under upsideLost sales and retailer dissatisfaction

The team separated the market forecast from the sales target, verified retailer commitments, and established a trigger: if confirmed orders reached 15,000 by the first July review, overtime would be released. If orders remained below 13,000, no further prebuild would occur.

Decision and outcome

The executive team selected Scenario B. Marketing revised the promotion to stagger retailer advertising; operations reserved, but did not immediately consume, overtime; procurement secured a limited component option rather than a full-volume commitment. The decision record assigned owners for order monitoring, component release, and cash reporting.

After the promotion, actual demand was 16,200 units. Meridian served the strategic retailers, avoided most premium freight, and ended with materially less excess inventory than under Scenario A. The result was not a perfect forecast; it was a disciplined response to uncertainty.

Learning points

The case illustrates that S&OP/IBP creates value through decision quality, not forecast accuracy alone. It also demonstrates the importance of conditional decisions, trigger points, financial integration, and explicit ownership. The process converted disagreement into a managed option rather than an unrecorded compromise.

10. Implementation roadmap and limitations

Implementation should proceed in stages:

  1. define purpose, scope, hierarchy, and executive sponsor;
  2. map current decisions, data flows, and pain points;
  3. establish common calendars, product families, measures, and ownership;
  4. pilot the process in one business or value stream;
  5. introduce disciplined demand and supply reviews;
  6. integrate financial reconciliation and scenario analysis;
  7. automate workflow and dashboards only after process stability;
  8. audit decisions, outcomes, and behavioral effects.

Typical failure modes include treating S&OP as a forecasting meeting, allowing multiple unofficial plans, using an excessive level of SKU detail, omitting finance, measuring departments in conflict, and failing to close decisions. Another limitation is that S&OP cannot remove structural shortages, poor strategy, weak data, or unresolved organizational incentives. It makes these issues visible; leadership must still act on them.

Ethically, organizations should avoid manipulating forecasts to obtain resources, concealing supply risks, prioritizing customers using discriminatory criteria, or shifting costs and disruption onto vulnerable suppliers. Regulatory obligations may affect allocation, product safety, environmental claims, labor practices, and data protection. Governance should make such constraints part of the planning model rather than after-the-fact exceptions.

Chapter Summary

S&OP is a cross-functional medium-term planning and decision process that aligns demand, supply, and organizational priorities. IBP extends it by integrating strategy, finance, risk, and executive accountability. The cycle normally includes data preparation, demand review, supply review, pre-S&OP reconciliation, executive decision-making, and action deployment. Demand plans must distinguish forecasts from targets; supply plans must test capacity and material feasibility. Reconciliation should present transparent scenarios and quantify service, margin, cash, risk, and strategic consequences. Effective governance assigns decision rights, records assumptions and actions, and uses balanced measures. Technology and AI can improve analysis but cannot replace data governance, human judgment, or ethical accountability. The mature organization does not seek to eliminate uncertainty; it makes uncertainty visible and responds to it deliberately.

Key Terms

S&OP: Cross-functional process for balancing demand and supply.

Integrated Business Planning: S&OP expanded to include finance, strategy, risk, and executive decisions.

Aggregate planning: Medium-term planning at product-family or resource-group level.

Unconstrained demand: Expected demand without supply limitations.

Consensus demand: Cross-functional demand plan accepted for planning.

Supply plan: Feasible response using capacity, inventory, procurement, and distribution.

Pre-S&OP: Reconciliation stage before executive review.

Executive S&OP: Senior-management decision stage.

IBP cycle: Recurring sequence of planning, reconciliation, decision, and deployment.

Forecast bias: Systematic tendency to overforecast or underforecast.

Time fence: Boundary controlling the flexibility of plan changes.

Capacity gap: Difference between required and available capability.

Scenario: Coherent assumptions, actions, and consequences.

Decision rights: Authority to approve or escalate decisions.

Contribution: Revenue minus defined variable costs.

Working capital: Current operating investment in inventory, receivables, and related accounts.

RACI: Framework identifying Responsible, Accountable, Consulted, and Informed roles.

Demand shaping: Actions that influence timing, quantity, channel, or mix of demand.

Data lineage: Traceable origin and transformation of data.

Plan adherence: Degree to which approved plans are executed or deviations are explained.

Review Questions

Short Answer Questions

  1. What is the principal purpose of S&OP?
  2. How does IBP extend traditional S&OP?
  3. Distinguish a forecast from a sales target.
  4. What is the purpose of pre-S&OP reconciliation?
  5. Why should forecast overrides have an owner and rationale?

Long Answer Questions

  1. Explain the stages of a monthly S&OP/IBP cycle and the outputs of each stage.
  2. Discuss how financial integration changes operational planning decisions.
  3. Explain the role of executive decision rights and accountability in S&OP.
  4. Evaluate the advantages and limitations of scenario-based planning.
  5. Discuss how cross-functional conflict can be converted into productive decision-making.

Analytical / Application Questions

  1. A product has forecast demand of 10,000 units, available normal capacity of 8,000 units, and overtime capacity of 1,500 units. Develop two supply scenarios and identify the unresolved gap in each.
  2. A sales team proposes a 25% forecast increase for a promotion, but provides no customer evidence. Design a demand-review protocol that tests the proposal without suppressing legitimate upside.
  3. Using the Meridian Appliances case, explain why the conditional overtime trigger can be superior to either committing all overtime immediately or refusing overtime entirely.

Multiple Choice Questions with Answers

Question 1

Which statement best describes the primary purpose of S&OP?

A. To maximize machine utilization regardless of demand

B. To reconcile demand, supply, and business priorities through cross-functional decisions

C. To replace the annual financial budget

D. To create detailed daily production schedules

Correct Answer: B. To reconcile demand, supply, and business priorities through cross-functional decisions

Question 2

What is the correct inventory balance relationship when all quantities use the same units and period?

A. I_t = I_{t−1} − P_t − R_t + D_t

B. I_t = I_{t−1} + P_t + R_t − D_t − L_t

C. I_t = P_t + D_t − R_t

D. I_t = D_t − P_t − R_t − L_t

Correct Answer: B. I_t = I_{t−1} + P_t + R_t − D_t − L_t

Question 3

A positive mean forecast error defined as ME = ∑(A_t − F_t) ÷ n indicates, on average, that the organization has:

A. Overforecast demand

B. Underforecast demand

C. Eliminated all random error

D. Measured capacity utilization

Correct Answer: B. Underforecast demand

Question 4

Which activity belongs primarily in the supply review?

A. Approving a brand slogan

B. Testing labor, material, and machine feasibility

C. Setting the corporate tax rate

D. Defining customer segmentation only

Correct Answer: B. Testing labor, material, and machine feasibility

Question 5

Why is MAPE problematic when actual demand is zero?

A. It cannot be expressed as a percentage

B. Its denominator becomes zero or nearly zero

C. It always equals MAD

D. It measures capacity instead of demand

Correct Answer: B. Its denominator becomes zero or nearly zero

Question 6

Which item is most appropriate for executive S&OP/IBP decision-making?

A. Whether a single operator should change a work sequence

B. Whether to accept a major demand-capacity gap and authorize overtime or investment

C. Whether to correct a typographical error in a report

D. Whether to archive an old email

Correct Answer: B. Whether to accept a major demand-capacity gap and authorize overtime or investment

Question 7

If revenue is 500,000 monetary units and defined variable cost is 320,000 monetary units, contribution is:

A. 180,000 monetary units

B. 320,000 monetary units

C. 500,000 monetary units

D. 820,000 monetary units

Correct Answer: A. 180,000 monetary units

Question 8

What is a key distinction between a forecast and a target?

A. A forecast is an aspiration, while a target is an evidence-based expectation

B. A forecast is the most credible expectation, while a target expresses an aspiration

C. They are always identical by definition

D. A target can never be changed, whereas a forecast is never reviewed

Correct Answer: B. A forecast is the most credible expectation, while a target expresses an aspiration

Question 9

Which practice best supports accountability in an S&OP process?

A. Assigning every action to the entire organization

B. Recording an accountable owner, due date, outcome, and escalation route

C. Avoiding written decisions to preserve flexibility

D. Allowing each function to maintain its own unofficial plan

Correct Answer: B. Recording an accountable owner, due date, outcome, and escalation route

Question 10

Why should AI recommendations in IBP remain subject to governance and human approval?

A. AI cannot process any historical data

B. Models may contain bias, data-quality problems, limited explainability, or drift

C. AI always produces slower calculations than manual analysis

D. Governance prevents any use of scenario analysis

Correct Answer: B. Models may contain bias, data-quality problems, limited explainability, or drift

Aggregate Production Planning
Chapter 9 of 14