Chapter 4
Global Demand Planning and Integrated Business Planning
Post Graduate Program in Supply Chain Management
Global Supply Chain Management
•
Post Graduate Diploma
Global Demand Planning and Integrated Business Planning
Introduction and Context
Global supply chains operate in environments characterized by geographically dispersed customers, long replenishment lead times, exchange-rate movements, seasonal demand, volatile commodity prices, trade restrictions, and unequal access to information. In this setting, demand planning is not simply the production of a sales forecast. It is the disciplined process of converting market intelligence, historical demand, customer commitments, commercial plans, and economic assumptions into a time-phased view of probable demand. Integrated business planning (IBP) extends this process by connecting demand with supply, capacity, inventory, risk, and financial performance.
The central managerial problem is not to predict the future perfectly. Perfect prediction is impossible. The objective is to create a sufficiently reliable and transparent basis for decisions, identify uncertainty explicitly, and coordinate responses across functions and countries. A forecast can therefore be judged not only by statistical accuracy but also by whether it improves decisions, exposes assumptions, and supports profitable customer service.
Learning Objectives
After studying this chapter, the learner should be able to:
Distinguish demand planning, forecasting, demand sensing, S&OP, and IBP.
Select and apply qualitative and quantitative forecasting methods.
Calculate and interpret forecast-error measures.
Explain collaborative planning and the role of CPFR and consensus forecasting.
Use scenario analysis to evaluate demand, supply, capacity, and financial alternatives.
Explain how an effective S&OP/IBP process integrates operational and financial plans.
Evaluate governance, technology, ethical, and implementation issues in global demand planning.
1. Demand Planning as a Managerial Capability
Demand is the quantity customers actually purchase, whereas sales may represent orders received, shipments, or invoiced transactions. These measures are not interchangeable. For example, a distributor may order heavily before a price increase, creating a sales spike that does not represent underlying consumer demand. Demand planning seeks to estimate unconstrained demand: the quantity customers would buy if product availability and commercial restrictions did not limit them. This estimate must then be reconciled with supply capability.
A useful distinction is:
Demand forecast: an estimate of future demand over a stated horizon.
Demand plan: a managed forecast incorporating assumptions, events, risks, and decisions.
Supply plan: a feasible response involving sourcing, production, inventory, and distribution.
Financial plan: the expected revenue, cost, margin, working capital, and cash consequences.
The forecast is an input to planning, not a commitment that the future will follow a single number. Professional planners should communicate a baseline forecast, a range of plausible outcomes, and the assumptions that explain changes from the previous cycle.
Time horizons and planning levels
Strategic planning considers network design, market entry, supplier strategy, and capacity investments over years. Tactical planning commonly covers several months to approximately two years and supports aggregate capacity, inventory, workforce, and supplier decisions. Operational planning may cover weeks or days and supports replenishment, production sequencing, and allocation.
Planning should be performed at an appropriate level of aggregation. Forecasting demand for every product-location combination may produce excessive noise, while forecasting only total global demand may conceal regional constraints. Hierarchies—global, region, country, channel, customer, product family, and stock-keeping unit—allow decisions to be made at the level where information is most useful.
2. Qualitative Forecasting
Qualitative methods are especially valuable when historical data are limited, structural change is significant, or the forecast concerns a new product, market, regulation, or disruption. They are not inherently inferior to quantitative methods; however, they require controlled judgment because incentives and cognitive biases can distort estimates.
Important methods include:
Executive opinion: senior managers provide an assessment based on strategic and market knowledge. It is fast but can be dominated by hierarchy.
Sales-force composite: sales representatives estimate customer-level demand. It captures local information but may reflect quota negotiations or optimism.
Customer surveys and market research: prospective buyers indicate intentions or preferences. Stated intention may differ from actual purchase behavior.
Delphi method: experts provide anonymous, iterative estimates until a reasoned convergence is reached. Anonymity reduces status effects, although consensus may conceal genuine disagreement.
Analogy: demand is estimated by comparing a new item with a similar product or market. The quality of the analogy is critical.
Scenario judgment: experts construct coherent high, base, and low cases linked to explicit drivers such as regulation, competitor entry, or economic growth.
A sound judgment process separates data from assumptions, records who contributed each input, challenges extreme estimates, and reviews forecast bias after outcomes are known. Judgment should adjust a statistical baseline for identifiable causal information—not merely replace it because a manager prefers a different number.
3. Quantitative Forecasting Methods
Quantitative methods use historical observations and, in some cases, explanatory variables. Their usefulness depends on data quality, stability of relationships, forecast horizon, and the cost of error.
3.1 Naïve and seasonal-naïve forecasts
A naïve forecast uses the latest actual value:
Ft+1 = At
where At is actual demand in period t and Ft+1 is the forecast for the next period. The method is a benchmark and can perform well for a random-walk series.
A seasonal-naïve forecast uses the observation from the equivalent prior season:
Ft+h = At+h-s
where s is the seasonal cycle length and h is the forecast horizon. This is appropriate when seasonal behavior is persistent and no stronger information is available.
3.2 Moving averages
A simple moving average of the latest n observations is:
Ft+1 = (At + At-1 + ... + At-n+1) ÷ n
All observations receive equal weight. A shorter window reacts more quickly to changes but is more variable; a longer window is smoother but may lag a trend. The method assumes that recent observations are informative and that no major structural break has occurred.
A weighted moving average is:
Ft+1 = ∑i=1n wi At+1-i
where wi are non-negative weights whose sum is 1. Greater weight may be assigned to recent observations.
3.3 Exponential smoothing
Simple exponential smoothing is suitable for level data without a systematic trend or seasonality:
Ft+1 = αAt + (1 - α)Ft
where 0 < α ≤ 1 is the smoothing constant. A high α responds rapidly to new information; a low value produces greater smoothing. The forecast and actual demand must use the same units and period definition.
For data with trend, Holt’s method estimates a level and trend. For seasonal data, Holt–Winters methods add a seasonal component. The exact additive or multiplicative form should be selected according to whether seasonal variation is approximately constant in absolute terms or proportional to the level. Automated selection is useful, but parameters and exceptions still require managerial review.
3.4 Causal and explanatory models
Regression relates demand to explanatory variables such as price, advertising, income, weather, exchange rates, or distribution coverage. A simple linear model is:
Dt = β0 + β1X1,t + ... + βkXk,t + εt
where Dt is demand, Xj,t are explanatory variables, βj are estimated coefficients, and εt is unexplained error. The model is useful only when explanatory variables are available or forecastable for the required horizon and the relationship is sufficiently stable. Correlation does not establish causation, and omitted variables, multicollinearity, endogeneity, and structural breaks can make coefficients misleading.
Worked Example 1: Exponential smoothing
Actual demand in month 1 is 1,000 units and the forecast for month 1 was 900 units. If α = 0.30, the forecast for month 2 is:
F2 = 0.30(1,000) + 0.70(900) = 930 units
If actual month-2 demand is 950 units, the month-3 forecast is:
F3 = 0.30(950) + 0.70(930) = 936 units
The calculation assumes one consistent monthly demand series and no explicit trend or seasonal component.
4. Forecast Accuracy, Error, and Bias
Let actual demand be At and forecast demand be Ft. Define forecast error as:
et = At - Ft
Under this convention, a positive error means demand exceeded the forecast. Organizations must state their convention because some systems use forecast minus actual.
Common measures
Measure
Formula
Interpretation
Mean Error (ME)
ME = ∑et ÷ n
Signed bias; positive indicates under-forecasting under the stated convention
Mean Absolute Error (MAE)
[[MATH:MAE = ∑
e_t
Mean Squared Error (MSE)
MSE = ∑et2 ÷ n
Penalizes large errors disproportionately; units are squared
Root Mean Squared Error (RMSE)
RMSE = √MSE
Error in original demand units
Mean Absolute Percentage Error (MAPE)
[[MATH:MAPE = (100 ÷ n)∑(
e_t
Weighted Absolute Percentage Error (WAPE)
[[MATH:WAPE = 100∑
e_t
MAE and RMSE are appropriate when absolute unit error matters. MAPE becomes unstable or undefined when actual demand is zero or very small; WAPE is often more useful for aggregated portfolios but can hide poor performance on low-volume items. No single metric is universally best.
Worked Example 2: Error measures
Suppose actual demand for three months is 100, 120, and 80 units, while forecasts are 90, 130, and 100 units. Errors are 10, −10, and −20 units. Therefore:
The negative ME indicates net over-forecasting under the stated error convention. A planner should not interpret the 13.33% WAPE as proof that every item has that accuracy; it is an aggregate measure.
Forecast accuracy should be measured at the decision-relevant horizon and hierarchy. Measures should be segmented by product maturity, market, customer, and forecastability. Bias is particularly important because persistent over-forecasting creates excess inventory, while persistent under-forecasting creates shortages and lost sales.
5. Demand Sensing and Collaborative Planning
Demand sensing is the short-horizon use of rapidly arriving signals to update a forecast or operational response. Signals may include point-of-sale data, web searches, orders, shipment patterns, inventory at distributors, promotions, weather, mobility, and competitor activity. Demand sensing does not eliminate the need for a baseline forecast; it complements longer-horizon planning by identifying changes sooner.
Its effectiveness depends on signal latency, data reliability, causal relevance, and the time required to act. An organization should avoid reacting to every fluctuation. Excessive overrides can amplify noise, create nervousness in production, and destabilize suppliers. Control limits, exception rules, and a documented override reason are useful safeguards.
Collaborative planning shares information and decisions among manufacturers, suppliers, distributors, retailers, and customers. CPFR—collaborative planning, forecasting, and replenishment—typically involves agreement on objectives, exchange of data, joint identification of exceptions, and coordinated replenishment. Collaboration creates value when partners have complementary information and can act on it. It creates little value when data are delayed, incentives conflict, or partners use shared forecasts merely to transfer blame.
Practical collaboration requires common product and location identifiers, agreed calendars, data-quality standards, confidentiality rules, exception thresholds, and a process for resolving disagreements. The forecast owner must be clear: a retailer may own a consumer demand forecast, while a manufacturer owns a production response, but both may jointly review assumptions.
6. S&OP and Integrated Business Planning
Sales and operations planning (S&OP) is a recurring cross-functional process that balances demand and supply at an aggregate level. IBP is a broader maturity model in which the S&OP process explicitly integrates strategic priorities, financial consequences, risk, and executive decision-making. Terminology varies across firms; the important issue is process quality, not the label.
A typical monthly cycle contains the following stages:
Data gathering and portfolio review: actuals, forecast performance, inventory, orders, capacity, supply risks, and market intelligence are assembled.
Demand review: a statistical baseline is supplemented by commercial intelligence, promotions, product launches, and customer information. The result is an unconstrained consensus demand plan.
Supply review: procurement, manufacturing, logistics, and inventory teams test feasibility against capacity, lead times, materials, labor, and transport.
Pre-IBP reconciliation: gaps, scenarios, financial effects, and decisions requiring executive attention are documented.
Executive IBP: leaders approve a plan, choose among scenarios, assign actions, and accept or mitigate risks.
Execution and learning: decisions are translated into operational plans and performance is reviewed in the next cycle.
Integrated business planning cycle
Figure: Integrated business planning cycle
Figure: The recurring IBP cycle connects evidence, functional plans, decisions, execution, and learning.
Integrating operational and financial plans
Operational quantities must be translated into value. If expected sales volume is Q, unit selling price is p, and variable cost per unit is v, then contribution margin is:
CM = Q(p - v)
This simplified relationship assumes constant unit price and variable cost and excludes fixed costs, taxes, and working-capital effects. A fuller IBP evaluation may include inventory carrying cost, expedite cost, lost-margin cost, capacity investment, duties, currency exposure, and cash timing. The same demand scenario can therefore be operationally feasible but financially unattractive.
Aggregate planning often uses product families rather than individual SKUs. A family-level plan may allocate production, inventory, and capacity while operational systems later disaggregate it using a controlled process. Unconstrained demand should not be reduced silently to match supply. The gap should be visible, with decisions such as prioritization, substitution, overtime, subcontracting, allocation, or investment recorded explicitly.
7. Scenario Analysis and Decision Quality
Scenario analysis examines coherent combinations of assumptions rather than changing one variable in isolation. A useful set may include:
Base case: most probable assumptions.
Upside case: stronger demand, successful promotion, or improved supply.
Downside case: recession, disruption, regulatory delay, or competitor action.
Stress case: low-probability but high-impact events such as port closure or major supplier failure.
Each scenario should specify demand drivers, supply assumptions, capacity, inventory policy, lead times, financial consequences, trigger indicators, and actions. Sensitivity analysis changes one or more variables to test exposure, while scenario analysis preserves an internally consistent story. Probabilities may be used when defensible, but false precision should be avoided.
Decision-makers should distinguish reversible from irreversible decisions. Temporary overtime or inventory positioning may be reversible; a new factory or supplier qualification may not be. Real options thinking encourages investment in flexibility when uncertainty is high, such as dual sourcing, modular capacity, postponement, or contractual volume bands.
8. Global Governance, Technology, and Ethics
Technology can improve demand planning through cloud collaboration, automated data integration, machine learning, probabilistic forecasts, and exception management. Machine-learning systems can detect nonlinear patterns and interactions, but they require representative data, stable definitions, monitoring, and human accountability. A highly accurate model trained on biased or censored sales data may reproduce poor decisions: observed sales may be lower than true demand because stockouts prevented purchases.
Important controls include version history, forecast lineage, role-based access, model validation, drift monitoring, override logs, and clear ownership. AI-generated recommendations should be explainable enough for managers to challenge them. Automation should support judgment, not conceal responsibility.
Global planning also involves ethical and regulatory issues. Customer and point-of-sale data must be collected and used consistently with privacy law, contractual rights, and legitimate business purpose. Data shared across borders may require transfer safeguards. Suppliers and smaller partners should not be pressured to reveal sensitive information without fair governance. Forecasts should not be manipulated to inflate performance metrics, secure excess capacity, or shift inventory risk unfairly to another party.
Currency conversion, differing fiscal calendars, tax regimes, trade restrictions, sanctions, local holidays, and product regulations must be represented explicitly. A global consensus forecast is meaningful only when units, currencies, calendars, product hierarchies, and time zones are harmonized.
9. Implementation Best Practices and Limitations
A practical implementation sequence is:
Define the decision calendar, horizons, planning levels, and ownership.
Establish one set of product, customer, location, and calendar master data.
Create a transparent statistical baseline before adding judgment.
Segment products by volume, value, variability, lifecycle, and strategic importance.
Measure error and bias at relevant levels, avoiding a single corporate average.
Introduce collaborative inputs with documented assumptions and deadlines.
Design exception-based demand sensing rather than unrestricted overrides.
Test supply feasibility and financial consequences through scenarios.
Use executive meetings for decisions and trade-offs, not for reading reports.
Review outcomes, model performance, bias, and process behavior continuously.
Forecasting has unavoidable limitations. Historical methods fail at structural breaks; causal models fail when drivers are unavailable or unstable; judgment is vulnerable to politics; aggregated accuracy can conceal local failure; and improved accuracy does not automatically create value if the supply chain cannot respond. The correct response is not to promise certainty but to design resilience, visibility, and rapid decision-making around uncertainty.
Applied Case: Illustrative Global Medical-Device Company
Background
MedSure, a fictional global manufacturer of infusion pumps, sells through hospitals and distributors in North America, Europe, and Asia. Demand is seasonal, regulatory approval differs by country, and a critical electronic component has a twelve-week lead time. Regional sales teams independently adjust forecasts, while finance uses a separate revenue plan.
Problem
The company repeatedly experiences excess inventory in one region and shortages in another. The global forecast is 8,000 units per month, but the sales organization submits 9,500 units to protect its targets. Actual demand averages 8,200 units, yet stockouts in Asia suppress recorded sales. Forecast accuracy measured only against shipments appears acceptable, and senior managers cannot see the lost-demand effect.
Analysis
The company first separates unconstrained hospital demand, distributor orders, and shipments. It creates a common product-location hierarchy and identifies stockout periods. A seasonal-naïve benchmark is compared with exponential smoothing and a causal model using hospital tender calendars and regulatory approvals. The causal model is used only where tender data are available and reliable.
The demand review produces base, upside, and downside scenarios. The supply review identifies the electronic component as the bottleneck and calculates that adding assembly overtime without more components cannot solve the problem. Finance translates each scenario into revenue, contribution margin, inventory, and expedited-freight effects.
Approach and solution
MedSure establishes a monthly IBP cycle with weekly demand-sensing exceptions. Regional teams may override the baseline only when they document a customer, tender, regulatory, or competitive driver. A cross-functional committee reviews persistent bias. Component capacity is allocated using strategic hospital commitments, shortage cost, and regulatory urgency rather than regional influence. A second supplier is qualified, and limited postponement is introduced so final configuration occurs nearer to demand.
Outcome
After two planning cycles, the organization has not eliminated uncertainty, but it can distinguish true demand from constrained shipments. The approved plan includes explicit shortage risks and financial consequences. Inventory is repositioned, component commitments are tied to scenarios, and executives make an informed choice about supplier qualification.
Learning points
Shipment history may understate demand when stockouts exist.
Forecast accuracy requires consistent definitions and bias analysis.
A demand plan is not useful unless supply and finance can respond to it.
Governance of overrides is as important as model selection.
Scenario transparency improves decisions even when forecasts remain uncertain.
Chapter Summary
Global demand planning converts diverse market and operational information into a structured, time-phased view of probable demand. Qualitative methods are valuable for new products and structural change, while quantitative methods provide disciplined baselines and repeatability. Naïve methods, moving averages, exponential smoothing, and causal models each have assumptions and limitations. Forecast error should be defined consistently and evaluated with measures such as ME, MAE, RMSE, MAPE, and WAPE; bias and decision relevance matter as much as aggregate accuracy.
Demand sensing uses recent signals for short-horizon response, while collaborative planning coordinates information and replenishment across supply-chain partners. S&OP and IBP integrate demand, supply, capacity, inventory, and financial plans through a recurring governance cycle. Scenario analysis makes uncertainty explicit and supports choices involving flexibility, risk, and investment. Effective implementation depends on data governance, transparent assumptions, controlled overrides, ethical use of information, and human accountability for technology-enabled decisions.
Key Terms
Demand planning: The process of estimating and managing future market requirements.
Unconstrained demand: Demand that would occur if product availability did not restrict purchases.
Forecast: A time-specific estimate of future demand.
Demand sensing: Short-horizon updating using rapidly arriving demand signals.
Consensus forecast: A forecast agreed through cross-functional review.
Naïve forecast: A forecast based on a recent or comparable prior observation.
Exponential smoothing: A method that weights recent observations more heavily through a smoothing constant.
Causal model: A forecast model using explanatory variables linked to demand.
Forecast error: The difference between actual and forecast demand.
Bias: Persistent directional error in forecasts.
MAE: Mean absolute error, expressed in demand units.
WAPE: Weighted absolute percentage error across observations.
CPFR: Collaborative planning, forecasting, and replenishment.
S&OP: Sales and operations planning.
IBP: Integrated business planning connecting operations, strategy, and finance.
Scenario analysis: Evaluation of internally consistent alternative futures.
Capacity constraint: A limit on production, labor, material, transport, or other supply capability.
Forecast hierarchy: Linked aggregation levels such as global, region, product family, and SKU.
Forecast override: A deliberate adjustment to a statistical baseline.
Demand bias: Systematic over- or under-estimation of demand.
Review Questions
Short Answer Questions
Distinguish unconstrained demand from shipments.
What is the purpose of a statistical baseline forecast?
State one limitation of MAPE.
What is the role of demand sensing?
Identify the main stages of an IBP cycle.
Long Answer Questions
Compare qualitative forecasting methods and explain when each may be appropriate.
Explain exponential smoothing, including the effect of changing the smoothing constant.
Discuss why forecast accuracy and forecast bias should be evaluated separately.
Explain how CPFR can create value and identify conditions that may prevent collaboration from working.
Describe how S&OP develops into financially integrated IBP.
Analytical / Application Questions
A product has actual monthly demand of 500, 550, and 450 units and forecasts of 480, 600, and 500 units. Calculate ME, MAE, and WAPE using the error convention in this chapter, then interpret the results.
A global firm faces a likely demand increase but a constrained supplier. Construct base, upside, and downside scenarios and specify the operational and financial decisions that should be reviewed.
A retailer’s shipments fall while online searches and stockout records rise. Explain how the planning team should distinguish declining demand from supply-constrained observed sales and redesign its forecast process.
Multiple Choice Questions with Answers
Question 1
Which statement best distinguishes a demand forecast from a supply plan?
A. A demand forecast estimates likely requirements; a supply plan tests how those requirements can be fulfilled.
B. A demand forecast is always a financial commitment; a supply plan is only a statistical estimate.
C. A demand forecast applies only to finished goods; a supply plan applies only to services.
D. A demand forecast is created after production decisions; a supply plan is created before market analysis.
Correct Answer: A. A demand forecast estimates likely requirements; a supply plan tests how those requirements can be fulfilled.
Question 2
If actual demand is 1,000 units, the forecast is 900 units, and α = 0.30, what is the next exponential-smoothing forecast?
A. 870 units
B. 900 units
C. 930 units
D. 970 units
Correct Answer: C. 930 units
Question 3
Under the chapter’s error convention, a negative mean error indicates:
A. Persistent under-forecasting
B. Net over-forecasting
C. Zero forecast variability
D. Perfect forecast accuracy
Correct Answer: B. Net over-forecasting
Question 4
Which measure is especially problematic when actual demand is zero?
A. MAE
B. RMSE
C. ME
D. MAPE
Correct Answer: D. MAPE
Question 5
What is the primary purpose of demand sensing?
A. To replace all annual strategic planning
B. To use recent signals to improve short-horizon response
C. To eliminate the need for inventory
D. To convert all forecasts into financial statements
Correct Answer: B. To use recent signals to improve short-horizon response
Question 6
Which activity normally belongs to the supply review in an S&OP cycle?
A. Testing capacity, materials, labor, and logistics feasibility
B. Setting individual salesperson quotas
C. Conducting only consumer attitude surveys
D. Removing all demand uncertainty from the plan
Correct Answer: A. Testing capacity, materials, labor, and logistics feasibility
Question 7
What distinguishes scenario analysis from a one-variable sensitivity test?
A. Scenario analysis changes no assumptions
B. Scenario analysis evaluates a coherent combination of assumptions
C. Sensitivity analysis always uses probabilities
D. Scenario analysis can be used only for financial data
Correct Answer: B. Scenario analysis evaluates a coherent combination of assumptions
Question 8
Why can shipment history understate true demand?
A. Shipments always include returns
B. Stockouts can prevent customers from purchasing
C. Forecasts are never recorded in systems
D. Capacity constraints increase observed sales
Correct Answer: B. Stockouts can prevent customers from purchasing
Question 9
Which practice provides the strongest governance for forecast overrides?
A. Allowing unlimited changes without explanation
B. Accepting only executive overrides
C. Requiring documented, evidence-based reasons and later review
D. Replacing the baseline with the highest submitted forecast
Correct Answer: C. Requiring documented, evidence-based reasons and later review
Question 10
In the simplified contribution-margin formula CM = Q(p - v), what does v represent?