Sales and Operations Planning and Integrated Business Planning

Introduction

Sales and Operations Planning (S&OP) is the managerial process through which an organisation reconciles market demand with its operational capacity over a medium-term planning horizon. Integrated Business Planning (IBP) extends S&OP by explicitly incorporating financial performance, strategic priorities, risk, and cross-functional decision rights. Together, these processes connect commercial plans with aggregate production, inventory, procurement, workforce, distribution, and financial plans.

The central managerial problem is not simply to forecast demand or maximise production. It is to select a feasible and economically attractive plan when demand, resources, lead times, inventories, service commitments, and financial objectives do not align. S&OP and IBP provide a disciplined governance mechanism for making these trade-offs visible and resolving them at the appropriate organisational level.

The planning hierarchy normally proceeds from strategic decisions to tactical and operational decisions:

• strategic network, product, and capacity decisions;
• aggregate S&OP or IBP plans;
• the Master Production Schedule (MPS);
• Material Requirements Planning (MRP);
• Distribution Requirements Planning (DRP);
• detailed scheduling, execution, and control.

This chapter explains how these layers interact and how constraints, financial objectives, technology, and managerial judgement shape integrated planning.

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. Distinguish aggregate planning, MPS, MRP, and DRP.
3. Construct basic aggregate capacity and material plans.
4. Apply forecasting, inventory, capacity, and constraint concepts to planning decisions.
5. Interpret the financial consequences of alternative supply–demand plans.
6. Evaluate planning-process design, technology, governance, and implementation risks.

1. The Planning Problem and the Planning Hierarchy

Demand is expressed in market terms—customers, channels, products, revenue, and margin. Supply is expressed in operational terms—machines, labour hours, materials, inventory, suppliers, and transport capacity. These representations are not naturally compatible. A sales forecast may be stated in product units by month, whereas a production facility may be constrained by hours on a particular work centre and by minimum batch sizes.

Aggregate planning resolves this mismatch by grouping products into families and resources into broad capacity categories. It generally covers a horizon of 12–24 months, although the appropriate horizon depends on product life cycles, procurement lead times, and capacity flexibility. The MPS then disaggregates the aggregate plan into specific end items, usually over a shorter and more detailed horizon. MRP translates the MPS into time-phased component and purchase requirements. DRP performs a similar time-phased planning function for inventories moving through a distribution network.

A useful distinction is:

The hierarchy is not purely sequential. Information must flow both downward and upward. For example, an MPS may reveal that a proposed aggregate plan is infeasible because a critical machine lacks capacity. Similarly, supplier constraints identified by MRP may require revision of the S&OP plan.

2. From S&OP to Integrated Business Planning

2.1 Sales and Operations Planning

S&OP is a recurring, cross-functional process that normally includes the following stages:

1. Data and performance review: actual sales, shipments, inventory, capacity, forecast accuracy, and service performance are analysed.
2. Demand review: sales, marketing, and demand-planning teams develop an unconstrained demand plan, including assumptions about promotions, pricing, new products, and market conditions.
3. Supply review: operations, procurement, logistics, and engineering test whether the demand plan can be supported by available resources.
4. Pre-S&OP reconciliation: alternative scenarios are evaluated, and unresolved trade-offs are prepared for executive decision.
5. Executive S&OP: senior leaders approve one integrated plan, authorise exceptions, and assign accountability.

S&OP is therefore more than a monthly forecast meeting. Its distinctive features are a common planning horizon, agreed data, explicit assumptions, scenario analysis, cross-functional participation, and executive decisions on exceptions.

2.2 Integrated Business Planning

IBP broadens S&OP in three ways. First, it links operational plans to financial outcomes such as revenue, contribution margin, working capital, cash flow, and capital expenditure. Second, it incorporates strategic decisions, including portfolio changes, outsourcing, market exits, and capacity investment. Third, it treats risk and uncertainty more explicitly.

The distinction is one of emphasis rather than a universally standard boundary. Some organisations use “advanced S&OP” and IBP interchangeably. In practice, an IBP process is credible only when the financial plan is derived from operational assumptions rather than being a separate target imposed after operations have completed their planning.

3. Demand Planning and Forecast Governance

An S&OP demand plan should distinguish between statistical baseline demand and managerial interventions. A baseline may be generated from historical sales, causal variables, or machine-learning models. Commercial teams may then add information about promotions, lost customers, competitor actions, or new product launches.

For a time series with observed demand D_t, a simple moving-average forecast over n periods is:

Here F_t+1 is the forecast for the next period and D_t is demand in period t. The method assumes that recent observations are reasonably representative and gives equal weight to the selected periods. It is unsuitable when strong trend, seasonality, structural change, or intermittent demand is present unless adapted.

Forecast error may be measured as:

where e_t is the error in period t. Mean Absolute Deviation is:

where n is the number of evaluated periods. MAD is expressed in demand units and is useful for comparing forecasting performance across similar products. Percentage measures must be used cautiously when actual demand is zero or close to zero.

The demand review should document:

• the statistical method and data horizon;
• assumptions about price, promotion, and market development;
• one-time events and probable lost sales;
• forecast confidence or ranges;
• ownership of overrides;
• the financial and capacity consequences of bias.

A forecast is not a commitment to sell, and a sales target is not necessarily a statistically credible forecast. Confusing these concepts creates systematic bias and unstable capacity decisions.

4. Aggregate Planning and Capacity Balancing

Aggregate planning determines production, inventory, workforce, subcontracting, and backlog decisions for product families. Three classic strategies are commonly compared:

• Level strategy: maintain relatively stable production and workforce, using inventory or backlog to absorb demand variation.
• Chase strategy: vary production or workforce to follow demand.
• Hybrid strategy: combine stable core capacity with overtime, temporary labour, subcontracting, inventory, or backlog.

Let:

• P_t = production quantity in period t;
• I_t = ending inventory;
• D_t = demand;
• B_t = ending backlog;
• I₀ and B₀ = initial inventory and backlog.

A basic inventory–backlog balance is:

The equation assumes that production and demand are measured in the same units and period, and that inventory and backlog are represented as non-negative quantities. It is a conservation relationship: supply plus opening net inventory must equal demand plus closing net inventory.

A simplified aggregate cost objective can be written as:

where c_p, c_h, c_b, c_o, and c_s are unit costs for regular production, inventory holding, backlog, overtime, and subcontracting; O_t and S_t are overtime and subcontract quantities. This formulation is illustrative, not universal. Real models may include hiring, layoffs, setup, transport, quality, carbon, service penalties, and nonlinear costs.

Capacity feasibility requires that planned workload not exceed available capacity. If product i requires a_i hours per unit and the resource has C_t hours in period t, then:

The units are resource-hours on both sides. The constraint is valid only when the processing coefficients are stable and the relevant resource is correctly identified. It does not by itself address materials, sequence-dependent setups, labour skills, maintenance, or transportation constraints.

Worked Example: Comparing Level and Chase Logic

A product family has monthly demand of 800, 1,200, and 1,000 units. Opening inventory is 200 units, and the organisation does not permit backlog. A level plan produces 933 units per month, rounded as operationally feasible. Ending inventories are:

• Month 1: 200 + 933 − 800 = 333 units.
• Month 2: 333 + 933 − 1,200 = 66 units.
• Month 3: 66 + 933 − 1,000 = approximately 0 units after rounding.

Total production is approximately 2,799 units, while total demand is 3,000 units. The opening inventory of 200 units closes most of the gap; exact production quantities must be adjusted because the unrounded average requirement is:

A chase plan would produce 600 units in month 1 after using opening inventory, 1,200 in month 2, and 1,000 in month 3, subject to workforce and minimum-capacity rules. The level plan reduces production volatility but carries inventory earlier; the chase plan reduces inventory but requires greater capacity flexibility. Neither is automatically superior: the decision depends on holding cost, labour economics, service requirements, and strategic flexibility.

5. Master Production Scheduling

The MPS converts the approved aggregate plan into a time-phased statement of end-item production. It should be expressed at a level that is meaningful to customers and feasible for manufacturing. The MPS is not simply a copy of the sales forecast. It considers opening inventory, confirmed orders, safety stock, lot sizes, lead times, and available capacity.

A simplified projected available balance is:

where PAB_t is projected available balance. If safety stock is required, the schedule must ensure that projected inventory does not fall below the policy level, unless an authorised exception exists. In environments using available-to-promise, uncommitted supply is allocated to customer orders only after considering existing commitments and the approved MPS.

MPS quality depends on:

• a stable planning time fence;
• clear rules for changing near-term orders;
• realistic lot sizes and setup times;
• capacity checks at critical work centres;
• coordination with sales order promising;
• controlled treatment of engineering changes.

An MPS that is frequently rescheduled may appear responsive but can increase setup costs, expedite fees, supplier disruption, and customer confusion.

6. Material Requirements Planning

MRP translates the MPS into component and purchased-material requirements through three principal inputs:

1. the MPS;
2. the bill of material (BOM);
3. inventory records, including on-hand stock, scheduled receipts, lead times, and lot-sizing rules.

For a component with gross requirement GR_t, scheduled receipt SR_t, projected available inventory before planned receipt PA_t−1, and safety stock SS, a simplified net requirement is:

This equation assumes that inventory units are interchangeable, requirements are correctly time-phased, and scrap, yield, and reservations are either absent or separately incorporated. If a fixed lot size L applies, the planned order receipt may be rounded upward to the smallest multiple of L that covers NR_t. Planned order release is then offset by the component lead time.

MRP is highly sensitive to data quality. Errors in BOM quantities, lead times, inventory balances, or order status generate either shortages or excess stock. MRP also assumes that the planning parameters are sufficiently reliable; it does not independently discover that a supplier has no capacity or that a production sequence is impractical.

7. Distribution Requirements Planning

DRP extends time-phased planning to distribution networks. Each stocking location has forecast or dependent demand, opening inventory, scheduled receipts, safety stock, and replenishment lead time. The distribution centre’s planned order release becomes a gross requirement for the supplying plant or upstream warehouse.

DRP coordinates replenishment across locations and can reduce both stockouts and unnecessary emergency shipments. However, it must account for transportation calendars, shipment minimums, delivery frequency, allocation rules, and inventory visibility. A theoretically optimal replenishment plan may be infeasible if transport capacity or dock availability is ignored.

8. Constraint-Based Planning and Theory of Constraints

Traditional planning often treats capacity as a fixed check performed after a plan is developed. Constraint-based planning instead identifies scarce resources during plan construction. Constraints may include:

• bottleneck machine hours;
• specialised labour;
• supplier capacity;
• cash or working-capital limits;
• tooling and maintenance windows;
• warehouse space;
• transport lanes;
• regulatory or quality-release capacity.

The Theory of Constraints proposes five focusing steps: identify the constraint, exploit it, subordinate other activities to it, elevate it, and repeat the process when the constraint moves. The practical implication is that local utilisation is not the same as system performance. Producing more on a non-bottleneck resource can increase work-in-process without increasing customer throughput.

Finite-capacity planning and optimisation models may use linear programming, mixed-integer programming, or constraint programming. These methods are valuable when product mix, setups, allocation, and capacity interactions are complex. Nevertheless, model results depend on assumptions, data, objective weights, and computational tractability. A mathematically optimal answer based on poor data is not a sound managerial decision.

9. Financial Integration and Decision Quality

IBP requires translation between operational quantities and financial outcomes. Revenue may be estimated as:

Contribution margin, in a simplified form, is:

Working capital is affected by inventory, receivables, and payables. A plan that improves service through higher inventory may increase revenue but reduce cash and return on invested capital. Conversely, aggressive inventory reduction may improve cash temporarily while increasing lost sales and expediting costs.

Financial reconciliation should therefore expose assumptions rather than apply an arbitrary percentage to an operational plan. Senior management should be able to see how a proposed promotion affects volume, capacity, inventory, margin, cash, and risk.

Useful IBP scenario questions include:

• What is the financial effect of accepting only part of peak demand?
• What is the value of additional bottleneck capacity?
• How does a supplier disruption change service and cash requirements?
• Is outsourcing attractive after quality, logistics, and working-capital effects?
• Does a new product justify the capacity displaced from an existing product?

10. Governance, Performance Measures, and Technology

Effective governance defines decision rights. Sales should not unilaterally promise constrained supply; operations should not silently reject profitable demand; finance should not impose targets disconnected from physical feasibility. Escalation rules should specify which decisions are made by planners, functional managers, and executives.

A balanced performance system may include:

• forecast bias and forecast accuracy;
• customer service or case-fill rate;
• schedule adherence;
• inventory turns and days of supply;
• capacity utilisation and bottleneck throughput;
• premium freight and expediting;
• contribution margin and cash conversion;
• plan stability and exception closure.

No single metric is sufficient. High utilisation may coexist with poor service; high forecast accuracy may reflect a biased forecast; low inventory may reflect stockouts rather than excellence.

Enterprise resource planning systems provide transactional records and planning engines. Advanced planning systems support scenario modelling, finite-capacity analysis, and network planning. AI and machine learning can assist demand sensing, anomaly detection, parameter tuning, and scenario generation. They do not remove the need for governance. Models can amplify promotional bias, encode unfair allocation rules, or produce confident outputs from incomplete data. Human review, traceability, version control, access security, and override monitoring are essential.

11. Illustrative Case: Northstar Appliances

Background

Northstar Appliances manufactures refrigerators in two product families: standard and premium. Demand rises sharply before the summer season. The plant has one compressor-testing cell, which is the principal bottleneck. Sales wants to accept all projected premium demand, while operations proposes protecting service for standard products.

Problem

The unconstrained three-month demand plan requires 9,000 bottleneck hours. Available regular capacity is 7,800 hours. Overtime can add 600 hours at a premium cost, and an approved supplier can provide 400 equivalent hours through outsourced testing. The remaining gap is 200 hours. Inventory of standard products is available for the first month, but premium products have no opening stock.

Analysis

The executive team asks for three scenarios:

1. reject 200 hours of demand;
2. add overtime and outsource all possible work;
3. change the product mix toward the higher-margin premium family.

The demand review identifies that 300 hours of the standard-family forecast is promotion-driven and uncertain. The supply review confirms that outsourcing premium testing requires an additional quality-release step and a two-week transport lead time. Finance estimates that overtime and outsourcing preserve contribution margin, but the service penalty for late standard products is lower than the penalty for late premium products because premium customers have fewer alternatives.

Approach and Solution

The IBP team classifies the bottleneck hours by contribution per constrained hour rather than by total unit margin alone. It protects contractual premium orders, uses 600 overtime hours, outsources 400 hours after validating quality capacity, and defers the uncertain 300-hour standard promotion. The remaining gap is managed through a controlled allocation rather than an unplanned backlog.

The MPS is revised to reflect the bottleneck sequence. MRP checks compressor and electronic-component availability, while DRP reallocates scarce premium inventory to strategic regions. Finance records the effect on revenue, contribution, overtime, outsourcing, and working capital.

Outcome and Learning Points

Northstar does not maximise short-term volume, but it protects the most valuable and strategically important demand. The case demonstrates that an integrated plan requires a common constraint model, explicit prioritisation, and financial translation. It also shows why an unconstrained sales forecast should not automatically become a production commitment.

12. Implementation Challenges and Best Practices

Common implementation failures include:

• treating S&OP as a forecast meeting rather than a decision process;
• allowing multiple versions of demand and inventory data;
• ignoring capacity or supplier constraints until execution;
• measuring functions with conflicting local targets;
• changing the plan without time fences or governance;
• using excessive model detail before basic data quality exists;
• presenting financial reconciliation as a finance-only exercise.

Best practices include:

1. establish one calendar, one data foundation, and one approved version of the plan;
2. separate baseline forecast, commercial assumptions, and committed orders;
3. plan at the right level of aggregation and disaggregate only when useful;
4. identify bottlenecks and material constraints early;
5. use scenarios to support decisions, not to avoid decisions;
6. connect operational quantities to margin, cash, and risk;
7. define escalation rules and executive accountability;
8. measure plan stability as well as forecast and service performance;
9. maintain disciplined master data and parameter governance;
10. review outcomes and improve the process through a learning loop.

Chapter Summary

S&OP is a cross-functional medium-term process for balancing demand and supply. IBP extends this process by integrating financial, strategic, and risk considerations. Aggregate planning establishes family-level production, inventory, workforce, subcontracting, and backlog decisions. The MPS converts these decisions into end-item schedules; MRP plans component requirements; and DRP coordinates replenishment across distribution locations.

The fundamental inventory–backlog balance is a conservation relationship, while capacity constraints ensure that planned workload does not exceed available resources. Forecasts support planning but do not replace managerial judgement or customer commitments. Constraint-based planning focuses attention on scarce resources, and financial integration makes trade-offs explicit. Successful implementation depends on reliable data, governance, scenario discipline, cross-functional accountability, appropriate technology, and balanced performance measures.

Key Terms

S&OP: A cross-functional process for reconciling demand and supply over a medium-term horizon.

Integrated Business Planning: An expanded S&OP process linking operations with finance, strategy, and risk.

Aggregate planning: Planning at product-family and broad-resource level.

Master Production Schedule: A time-phased plan for producing specific finished products.

MRP: A system that translates the MPS into component and material requirements.

DRP: Time-phased replenishment planning for distribution locations.

Demand plan: A quantified view of expected market requirements.

Capacity constraint: A resource limitation that restricts feasible output.

Bottleneck: A resource whose limited capacity constrains system throughput.

Level strategy: A plan using relatively stable production and inventory to absorb demand variation.

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

Hybrid strategy: A plan combining level and chase mechanisms.

Projected available balance: Expected inventory after planned receipts and demand.

Bill of material: A structured specification of components required for a product.

Safety stock: Inventory held to protect against uncertainty.

Backlog: Demand not fulfilled by its requested or planned date.

Time fence: A boundary controlling how freely a schedule may be changed.

Finite-capacity planning: Planning that explicitly limits schedules by available resource capacity.

Forecast bias: Systematic tendency for forecasts to be above or below actual demand.

Available-to-promise: Uncommitted supply that can be promised to customers.

Review Questions

Short Answer Questions

1. What is the principal purpose of S&OP?
2. How does IBP extend conventional S&OP?
3. Distinguish the MPS from MRP.
4. What is a bottleneck resource?
5. Why must financial assumptions be reconciled with operational plans?

Long Answer Questions

1. Explain the planning hierarchy from aggregate planning to execution, including upward and downward information flows.
2. Compare level, chase, and hybrid aggregate-planning strategies and discuss when each may be appropriate.
3. Explain the inputs, logic, and limitations of MRP.
4. Discuss how governance and performance measurement influence S&OP effectiveness.
5. Critically evaluate the role of AI and advanced planning systems in IBP.

Analytical / Application Questions

1. A firm begins a three-month period with 300 units of inventory and faces demand of 900, 1,100, and 1,000 units. Develop a constant-production plan with no backlog and explain any rounding or feasibility issues.
2. A bottleneck provides 4,000 hours. Product A requires 2 hours per unit and contributes 40 currency units; product B requires 1 hour and contributes 25 currency units. Which product has the higher contribution per bottleneck hour, and how should this information influence allocation?
3. A proposed sales promotion increases demand but requires overtime, additional inventory, and premium transport. Design an IBP scenario analysis identifying the operational, financial, service, and risk variables that should be evaluated.

Multiple Choice Questions with Answers

Question 1

Which activity is normally part of the executive S&OP stage?

A. Entering individual purchase orders

B. Approving cross-functional trade-offs and exceptions

C. Calculating every component requirement manually

D. Assigning operators to hourly tasks

Correct Answer: B. Approving cross-functional trade-offs and exceptions

Question 2

IBP extends S&OP primarily by integrating which additional perspective?

A. Only shop-floor sequencing

B. Only statistical forecasting

C. Financial, strategic, and risk considerations

D. Only warehouse picking

Correct Answer: C. Financial, strategic, and risk considerations

Question 3

If opening inventory is 200 units, production is 900 units, and demand is 800 units, ending inventory is:

A. 100 units

B. 300 units

C. 900 units

D. 1,900 units

Correct Answer: B. 300 units

Question 4

Which planning system translates an MPS into component requirements?

A. DRP

B. MRP

C. CRM

D. GL accounting

Correct Answer: B. MRP

Question 5

A resource requires 3 hours per unit for Product X and has 600 available hours. Ignoring other constraints, its maximum output is:

A. 180 units

B. 200 units

C. 300 units

D. 1,800 units

Correct Answer: B. 200 units

Question 6

What is the defining characteristic of a chase strategy?

A. Production remains constant regardless of demand

B. Production or workforce changes to follow demand

C. All demand is outsourced

D. Inventory is always zero

Correct Answer: B. Production or workforce changes to follow demand

Question 7

In the simplified MRP equation, safety stock increases net requirements when:

A. It is included as an additional inventory protection requirement

B. Demand is zero

C. Lead time is negative

D. Scheduled receipts exceed all requirements

Correct Answer: A. It is included as an additional inventory protection requirement

Question 8

Why is a bottleneck important in constraint-based planning?

A. It determines the colour of finished goods

B. Its limited capacity can restrict total system throughput

C. It always has the lowest labour cost

D. It eliminates the need for forecasting

Correct Answer: B. Its limited capacity can restrict total system throughput

Question 9

Which measure is expressed in demand units rather than a percentage?

A. MAD

B. Forecast bias percentage

C. Fill-rate percentage

D. Capacity utilisation percentage

Correct Answer: A. MAD

Question 10

What is a major governance risk when sales targets are treated automatically as unconstrained forecasts?

A. The plan may create infeasible capacity and inventory commitments

B. The BOM becomes shorter

C. Lead times become zero

D. Financial reconciliation becomes unnecessary

Correct Answer: A. The plan may create infeasible capacity and inventory commitments