Retail Logistics & SCM

Chapter 5
Sales and Operations Planning and Collaborative Coordination

Post Graduate Program in Retail Management
Retail Logistics & SCM   •   Post Graduate

Sales and Operations Planning and Collaborative Coordination

Introduction

Retail supply chains operate under a persistent tension: customers expect high availability, variety, speed, and low prices, while firms must control inventory, capacity, working capital, and operating risk. A retailer may observe demand at the checkout, but upstream manufacturers and suppliers often see only replenishment orders. Without coordination, each organisation forecasts and plans locally, creating excess inventory in some locations, shortages in others, unstable production schedules, and avoidable logistics cost.

Sales and Operations Planning (S&OP) is the principal management process for reconciling demand, supply, capacity, inventory, and financial objectives. Integrated Business Planning (IBP) extends S&OP through stronger financial integration, scenario analysis, and executive decision-making. Interorganisational methods such as Collaborative Planning, Forecasting and Replenishment (CPFR) and Vendor-Managed Inventory (VMI) complement S&OP by improving coordination across organisational boundaries. Exception management focuses managerial attention on material deviations rather than requiring equal attention to every item and location.

This chapter examines how these approaches work together, why the bullwhip effect emerges, how it can be measured, and how retailers can design effective governance, data, technology, and performance systems.

Learning objectives

By the end of this chapter, the reader should be able to:

  1. Explain the purpose, structure, and operating cycle of S&OP and IBP.
  2. Integrate demand, supply, capacity, inventory, and financial plans.
  3. Distinguish CPFR, VMI, collaborative replenishment, and traditional transactions.
  4. Diagnose the bullwhip effect and identify its operational causes.
  5. Apply quantitative measures for forecast error, inventory performance, and demand amplification.
  6. Design exception-management rules and cross-functional governance.
  7. Evaluate the benefits, risks, ethical issues, and implementation requirements of collaborative planning.

1. The planning problem in retail supply chains

Retail planning occurs at several time horizons. Strategic planning concerns network design, sourcing, technology, and capacity investments over years. Tactical planning covers assortment, promotions, aggregate supply, workforce, and inventory over months. Operational planning covers orders, allocations, transport, and replenishment over days or weeks. S&OP connects these horizons by translating strategic intent into a feasible, financially coherent medium-term plan.

A typical retail chain has multiple demand streams: stores, e-commerce, marketplaces, wholesale channels, and click-and-collect. Demand is affected by price, promotions, weather, holidays, competitor activity, product availability, and macroeconomic conditions. Supply is constrained by supplier lead times, minimum order quantities, production capacity, transport, labour, cash, and regulatory requirements. A plan that is attractive from one functional viewpoint may be infeasible for the system as a whole.

For example, marketing may propose a deep promotion to increase traffic, merchandising may add product variety, finance may reduce inventory investment, and logistics may face fixed transport capacity. S&OP creates a formal forum in which these trade-offs are made explicitly.

2. S&OP and the evolution toward IBP

2.1 S&OP as a management process

S&OP is a recurring, cross-functional process—not merely a software module or a forecasting meeting. Its purpose is to produce one agreed plan for demand, supply, inventory, capacity, and management action. The plan is normally expressed at an aggregate level, such as product family, category, region, channel, or distribution centre, rather than at individual stock-keeping-unit (SKU) level.

A conventional monthly S&OP cycle includes five linked stages:

  1. Data and portfolio review: prior-period sales, shipments, inventory, forecasts, promotions, new products, discontinued products, and operational performance are validated.
  2. Demand review: a statistical baseline forecast is supplemented by commercial intelligence from merchandising, marketing, sales, and e-commerce.
  3. Supply review: procurement, manufacturing, distribution, labour, storage, and transport capacity are assessed against the demand plan.
  4. Reconciliation and pre-S&OP: alternative scenarios are evaluated, including overtime, subcontracting, inventory build, allocation, price changes, or demand-shaping actions.
  5. Executive S&OP: senior leaders approve one plan, resolve unresolved trade-offs, assign actions, and establish assumptions for the next cycle.

The process must have a defined planning horizon, data cut-off, decision rights, escalation rules, and calendar. A twelve- to eighteen-month horizon is common for tactical planning, although the appropriate horizon depends on lead times and capacity commitments.

2.2 IBP: integration beyond conventional S&OP

Integrated Business Planning extends S&OP in three important ways. First, it links operational plans to financial statements, budgets, cash requirements, margin, and return on invested capital. Second, it formalises scenario planning and sensitivity analysis. Third, it makes executive decisions more explicit when strategic, commercial, and operational objectives conflict.

S&OP may ask, “Can supply meet the proposed demand?” IBP additionally asks, “What revenue, margin, working capital, risk, and strategic consequences follow from each feasible alternative?” IBP is therefore not simply a more sophisticated forecast. It is an integrated decision system.

A financially translated plan may include:

  • expected sales revenue by channel and category;
  • gross margin after discounts, markdowns, and variable costs;
  • inventory investment and working-capital implications;
  • capacity, labour, freight, and outsourcing costs;
  • cash timing and supplier-payment exposure; and
  • service, compliance, sustainability, and risk consequences.

Financial integration must not encourage manipulation of operational data to meet budget targets. A credible IBP process preserves the distinction between an unbiased operational forecast, a commercial target, and a management commitment.

3. Integrating demand, supply, capacity, and finance

3.1 Demand planning

Demand planning begins with a baseline forecast generated from historical demand and relevant causal variables. Forecasts should distinguish observed sales from unconstrained demand. If an item was out of stock, recorded sales may understate what customers wanted. Similarly, a promotion may create temporary forward buying rather than permanent growth.

A simple moving-average forecast for period t+1 based on the previous n observations is:

Ft+1 = (1/n) ∑i=0n-1 Dt-i

Here, Ft+1 is the forecast for the next period, Dt-i is observed demand in a prior period, and n is the number of observations. The method assumes that recent observations are relevant and that no strong trend or seasonal structure is being ignored. It is inappropriate when demand is strongly seasonal unless seasonality is separately modelled.

Exponential smoothing gives greater weight to recent observations:

Ft+1 = αDt + (1-α)Ft, 0 ≤ α ≤ 1

α is the smoothing parameter, Dt is current demand, and Ft is the prior forecast. A higher α responds more quickly to changes but may be more sensitive to random variation.

Forecast accuracy should be evaluated using measures appropriate to the decision. Forecast error is:

et = Dt - Ft

Mean absolute error (MAE) is:

MAE = (1/n) ∑t=1n |et|

MAE is expressed in units and is easy to interpret. Mean absolute percentage error can be useful, but it becomes unstable or undefined when actual demand is zero or close to zero. For intermittent retail demand, scaled errors, bias, or measures based on aggregate value may be preferable.

Forecast accuracy is not the same as forecast value. A slightly less accurate forecast may be more useful if it supports better allocation, replenishment, promotion timing, or capacity decisions. Forecast bias is especially important: persistent over-forecasting creates excess inventory, whereas persistent under-forecasting creates shortages and lost sales.

3.2 Supply and capacity planning

The supply review converts the demand plan into requirements for suppliers, factories, distribution centres, stores, transport, labour, and cash. It should identify both nominal capacity and effective capacity. Effective capacity accounts for changeovers, maintenance, absenteeism, quality losses, congestion, and operational variability.

A capacity-load ratio is:

ρ = L/C

where L is required workload in consistent units and C is available effective capacity in the same period. If ρ > 1, the plan is infeasible without changing demand, timing, capacity, sourcing, or inventory. Even when ρ is below 1, a high ratio may produce long queues and poor responsiveness because variability consumes practical flexibility. Capacity must therefore be analysed by resource and time bucket, not only in aggregate.

Supply responses include:

  • changing production or purchase timing;
  • using alternative suppliers or transport modes;
  • reallocating inventory among channels or stores;
  • adding overtime, shifts, or temporary labour;
  • substituting products or materials;
  • building inventory before a seasonal peak; and
  • changing the promotion, price, or promised service level.

Each response has cost, lead-time, quality, resilience, and ethical implications.

3.3 Inventory and service trade-offs

Inventory is held to decouple uncertain demand and supply, achieve economies of scale, support variety, and protect service. It also creates holding cost, obsolescence, shrinkage, markdown exposure, and working-capital requirements.

For a continuous-review item with approximately independent demand and lead-time uncertainty, a common reorder-point expression is:

ROP = μLT + zσLT

ROP is the reorder point in units, μLT is expected demand during lead time, σLT is the standard deviation of demand during lead time, and z is the standard-normal safety factor associated with the target cycle-service probability. This expression assumes that demand during lead time is reasonably represented by a distribution for which the selected service factor is meaningful, and that lead time and demand parameters are estimated consistently.

If periodic review is used, the protection period is generally the review interval plus lead time. The calculation must include uncertainty over that entire period. The formula is not universal: correlated demand, intermittent demand, supply disruption, minimum order quantities, lost sales, and non-normal distributions may require simulation or specialised methods.

S&OP should examine inventory by category and purpose rather than apply one service target to every SKU. A high-value, predictable item, a critical spare, a fashion item, and a low-value intermittent item require different policies.

3.4 Financial reconciliation

Suppose a category plan estimates unit sales Q, selling price p, unit variable cost v, and period fixed operating cost K. A simplified contribution estimate is:

Contribution = Q(p-v) - K

This identity is useful for scenario comparison, but it excludes taxes, financing, inventory carrying cost, markdowns, returns, and shared overhead unless those elements are explicitly incorporated. The purpose of financial reconciliation is not to reduce every decision to a single number. It is to expose trade-offs and ensure that operational commitments are economically and strategically coherent.

4. The S&OP operating model and governance

Effective S&OP depends on organisational design as much as on analytical technique. A process charter should specify:

  • the executive owner and process coordinator;
  • participating functions and external parties;
  • planning levels, horizons, and calendar;
  • data ownership and definitions;
  • decision rights and escalation thresholds;
  • approved scenarios and assumptions; and
  • measures of plan quality and execution.

The process should use one set of agreed definitions. “Sales” may mean orders, shipments, point-of-sale demand, or invoiced revenue; these are not interchangeable. “Inventory” may mean physical stock, available stock, blocked stock, or inventory in transit. Ambiguous definitions create apparent disagreement that is actually a data problem.

Useful performance measures include forecast bias, forecast accuracy, on-shelf availability, case-fill rate, inventory turns, stockout rate, aged inventory, schedule adherence, supplier reliability, plan stability, gross margin, and cash conversion. Measures should be balanced. Rewarding only forecast accuracy can encourage deliberate under-forecasting; rewarding only availability can create excessive inventory.

5. Collaborative coordination across organisations

5.1 CPFR

CPFR is a structured collaboration in which trading partners jointly develop plans, forecasts, promotion assumptions, replenishment actions, and exception responses. A typical CPFR cycle contains:

  1. agreement on collaboration objectives, scope, roles, and data;
  2. creation of a joint business plan;
  3. development and comparison of independent forecasts;
  4. identification of forecast exceptions;
  5. agreement on a shared forecast or order plan;
  6. execution of replenishment and logistics; and
  7. measurement, review, and continuous improvement.

CPFR is most valuable where partners have substantial mutual dependence, demand volatility, promotional complexity, or high stockout cost. It is less attractive when transaction volume is small, data quality is poor, products are highly substitutable, or one partner is unwilling to share relevant information.

Collaboration does not mean that all information or decisions must be shared. Partners should share information that improves total system performance while protecting commercially sensitive data through contracts, access controls, aggregation, and governance.

5.2 Vendor-Managed Inventory

Under VMI, the supplier is responsible for monitoring agreed inventory and demand information and proposing or initiating replenishment within defined constraints. Ownership of stock, title transfer, payment terms, service targets, and risk allocation remain matters of contract; VMI does not automatically mean that the supplier owns the inventory.

VMI can reduce duplicated forecasting, improve replenishment frequency, and use the supplier’s product knowledge. It may also create risks: supplier dominance, inappropriate replenishment, overstocking, loss of retailer control, data misuse, and disputes about accountability. A sound VMI agreement defines inventory ownership, target ranges, order authority, minimum and maximum levels, lead times, service levels, data frequency, exception rules, returns, obsolete stock, audit rights, and exit conditions.

5.3 Comparison of coordination mechanisms

MechanismPrimary decision ownerMain information sharedTypical benefitMain risk
Traditional replenishmentBuyer/retailerOrders and basic forecastsSimple administrationLocal optimisation
CPFRJointForecasts, promotions, plans, exceptionsShared visibility and better synchronisationCoordination cost and data disputes
VMISupplier within agreed rulesInventory, sales, stock statusFaster, less duplicated replenishmentLoss of control or supplier bias
S&OP/IBPFocal enterprise with executive governanceAggregate demand, supply, finance, scenariosCross-functional alignmentSlow decisions or weak accountability

These methods are complementary. A retailer may use IBP for category and network decisions, CPFR with strategic suppliers, and VMI for selected replenishment-intensive categories.

6. The bullwhip effect

The bullwhip effect is the tendency for variability in orders to increase as one moves upstream from final demand toward suppliers. The phenomenon is not simply a forecasting error. It is a dynamic outcome of local decision rules, delays, incentives, and information distortion.

Common causes include:

  • demand forecasting based on orders rather than consumer sales;
  • order-up-to policies that react to inventory and pipeline changes;
  • long and variable lead times;
  • order batching caused by fixed ordering or transport costs;
  • temporary promotions and forward buying;
  • shortage gaming, in which customers inflate orders during constrained supply; and
  • separate performance targets that reward local rather than total-chain outcomes.

A simple diagnostic measure is the variance amplification ratio:

B = Var(O) / Var(D)

O is the order quantity issued by a downstream stage, D is consumer demand over comparable time intervals, and Var(·) denotes variance. B > 1 indicates that order variability exceeds demand variability. The comparison is meaningful only when the data use comparable time buckets, product scope, aggregation, and treatment of promotions and stockouts. A ratio below one does not automatically prove superior coordination because aggregation or delayed ordering may conceal instability.

The bullwhip effect can be reduced by:

  • sharing point-of-sale and inventory data;
  • shortening and stabilising lead times;
  • reducing order batching through smaller, more frequent orders;
  • using every-day-low-price or carefully governed promotion policies;
  • allocating scarce supply based on realistic consumption signals;
  • separating baseline demand from promotion uplift;
  • aligning incentives and measuring total supply-chain performance; and
  • applying collaborative forecasts and replenishment rules.

Information sharing alone is insufficient. If partners receive accurate data but continue to use incompatible incentives and unstable ordering rules, amplification may remain.

7. Exception management

Exception management is the disciplined prioritisation of decisions that materially depart from plan. It prevents planners from spending equal time on routine items and urgent risks.

An exception should be defined by a measurable threshold, an owner, a deadline, and an action path. Examples include:

  • forecast change above a defined percentage or unit threshold;
  • projected stockout before replenishment;
  • supplier confirmation below the committed quantity;
  • capacity load above the agreed operating limit;
  • promotion uplift outside the approved confidence range;
  • inventory age exceeding policy; or
  • margin falling below the approved floor.

A useful design principle is to combine magnitude, probability, and consequence. A small deviation in a critical medicine category may deserve more attention than a larger deviation in a low-value, substitutable category. Alert systems should therefore support prioritisation rather than merely generate large volumes of notifications.

An exception workflow normally records the signal, validates the data, diagnoses the cause, evaluates alternatives, assigns a decision owner, records the decision and assumptions, and reviews the outcome. Root-cause coding is important: otherwise the organisation repeatedly treats symptoms such as stockouts without correcting inaccurate lead times, poor master data, or promotion misalignment.

8. Technology, analytics, and artificial intelligence

Enterprise resource planning, supply-chain planning, warehouse, transport, point-of-sale, supplier portals, and collaborative platforms can provide the data foundation for S&OP and CPFR. Application programming interfaces and event-driven systems may enable near-real-time inventory and order visibility. However, technical integration does not create organisational trust or decision rights.

Advanced analytics can improve demand sensing, promotion estimation, allocation, anomaly detection, and scenario simulation. Machine-learning models may identify nonlinear relationships among weather, price, digital traffic, and demand. They require stable definitions, sufficient historical data, monitoring for drift, and controls for bias. A model trained on stock-constrained sales may learn that low availability means low demand. Human review remains essential when structural breaks occur, such as a new competitor, disruption, regulatory change, or product launch.

AI-generated recommendations should be explainable enough for planners to challenge them, especially when they affect supplier commitments, employment, customer access, or waste. Access to commercially sensitive data must be restricted, and data-sharing agreements should define permitted uses, retention, cybersecurity responsibilities, and breach notification.

9. Illustrative case: FreshMart and NorthStar Foods

Background

FreshMart is a regional supermarket chain supplied by NorthStar Foods, a packaged chilled-food manufacturer. FreshMart experienced frequent stockouts during promotions and excessive post-promotion inventory. NorthStar observed highly variable orders and responded by holding finished goods and adding production overtime.

Problem

FreshMart’s promotional calendar was shared late and in a format that did not distinguish baseline demand from promotional uplift. The retailer forecast store replenishment using shipments to stores, while NorthStar forecast production using FreshMart’s orders. A fixed weekly ordering cycle encouraged large batches. During shortages, FreshMart’s buyers increased orders to protect their allocation.

For one product family, weekly consumer demand had a variance of 400 cases², while FreshMart’s weekly orders to NorthStar had a variance of 1,000 cases². The diagnostic ratio was:

B = 1,000 / 400 = 2.5

Thus, order variance was 2.5 times consumer-demand variance over the selected comparable period. This result does not by itself identify every cause, but it indicates material amplification.

Analysis and approach

The partners established a CPFR pilot covering ten high-volume products. They agreed to share point-of-sale sales, store inventory, promotion dates, expected discount depth, distribution-centre stock, and supplier capacity. They separated baseline demand from promotional uplift and created a joint twelve-week rolling forecast.

NorthStar also introduced VMI for two stable products. It could recommend replenishment within minimum and maximum inventory limits, while FreshMart retained approval rights for promotions and exceptional orders. Weekly deliveries were replaced by smaller, more frequent deliveries where transport economics permitted. A joint exception dashboard flagged projected stockouts, forecast changes above 20%, and supplier confirmation below 95% of plan.

A monthly executive review reconciled the operational plan with margin, waste, service, and working-capital objectives. Neither partner was permitted to claim success solely through shifting inventory or shortages to the other.

Outcome

After three months, the pilot recorded fewer emergency orders, more stable production schedules, and improved promotion availability. The partners also identified that one product’s apparent forecast error was actually caused by frequent stockouts; correcting availability data improved the baseline forecast. The case illustrates that collaboration is a system of shared data, rules, incentives, and governance—not merely a technology installation.

Learning points

  1. Consumer demand signals are generally more informative than downstream orders.
  2. Promotional assumptions must be visible to both commercial and operational planners.
  3. VMI requires explicit control boundaries and accountability.
  4. Exception thresholds should lead to decisions, not just alerts.
  5. Results must be evaluated across total cost, service, waste, and working capital.

10. Challenges, limitations, and ethical governance

S&OP and collaborative planning can fail when senior leaders treat the process as a reporting ritual, when functions protect local targets, or when data definitions are contested. Collaboration also has transaction costs: meetings, integration, training, data cleansing, contract design, and dispute resolution. Not every supplier relationship warrants intensive collaboration.

Power asymmetry is a significant issue in retail. A large retailer may impose data, service, payment, or inventory requirements that transfer risk to small suppliers. Ethical governance requires fair negotiation, transparent performance rules, reasonable notice of changes, protection against coercive forecasting practices, and mechanisms for suppliers to challenge inaccurate deductions or allocations.

Competition law and confidentiality must also be considered. Sharing information about future prices, market strategy, or competitors can create legal risk. Collaboration should be limited to legitimate supply-chain coordination and supported by legal review where appropriate. Personal data from loyalty programmes must be handled under applicable privacy law, with purpose limitation, access controls, retention limits, and appropriate consent or lawful basis.

Sustainability should be integrated into S&OP rather than treated as a separate public-relations measure. Decisions about order frequency, packaging, transport mode, refrigeration, markdowns, food waste, labour, and supplier resilience have environmental and social consequences. A lower-cost plan may be undesirable if it creates excessive waste, unsafe work, or unfair supplier risk.

11. Best-practice implementation roadmap

A practical implementation can proceed through the following sequence:

  1. Diagnose: map planning flows, decision rights, data definitions, lead times, variability, and current performance.
  2. Establish governance: appoint an executive sponsor, process owner, cross-functional team, and meeting calendar.
  3. Create a common data foundation: reconcile product, location, calendar, inventory, sales, promotion, and capacity master data.
  4. Pilot at an appropriate scope: select a category, channel, or supplier with meaningful value and manageable complexity.
  5. Separate baseline and event demand: record promotions, launches, closures, stockouts, and exceptional events.
  6. Define policies: set service targets, inventory boundaries, escalation thresholds, ownership, and approval rights.
  7. Integrate financial scenarios: translate operational alternatives into margin, cash, working capital, risk, and sustainability effects.
  8. Measure outcomes: use balanced metrics and compare results against a credible baseline.
  9. Scale selectively: expand only when data quality, trust, capability, and governance are adequate.
  10. Improve continuously: review forecast bias, exception causes, plan stability, and partner behaviour.

Chapter Summary

S&OP is a recurring cross-functional process that reconciles demand, supply, capacity, inventory, and business objectives. IBP extends this process by integrating financial consequences, strategic scenarios, risk, and executive decisions. Demand planning requires careful distinction between consumer demand, shipments, orders, promotions, and stock-constrained sales. Capacity and inventory decisions must reflect lead times, variability, service objectives, and practical constraints.

CPFR coordinates forecasts, promotions, replenishment, and exceptions across trading partners. VMI delegates replenishment responsibility to a supplier within explicit contractual and operational boundaries. Both methods require reliable data, aligned incentives, governance, and mutual trust. The bullwhip effect arises when local decisions, delays, batching, promotions, shortage gaming, and poor information cause order variability to exceed consumer-demand variability. Shared point-of-sale data, shorter lead times, stable policies, aligned measures, and collaborative replenishment can reduce amplification.

Exception management concentrates scarce managerial attention on deviations with meaningful operational, financial, customer, or ethical consequences. Technology and AI can improve visibility and analysis, but they cannot replace sound definitions, accountable governance, human judgement, and fair interorganisational relationships. The central managerial principle is systems thinking: performance should be improved across the total supply chain rather than by transferring cost or risk from one participant to another.

Key Terms

Sales and Operations Planning (S&OP): A recurring process that aligns demand, supply, capacity, inventory, and business decisions.

Integrated Business Planning (IBP): An expanded S&OP approach linking operational plans with finance, strategy, scenarios, and executive governance.

Demand sensing: Use of recent and contextual signals to detect short-term changes in demand.

Forecast bias: Persistent tendency of forecasts to be higher or lower than actual demand.

Effective capacity: Usable capacity after allowing for downtime, changeovers, labour constraints, and operational losses.

Capacity-load ratio: Required workload divided by available effective capacity.

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

Reorder point: Inventory position at which replenishment is triggered.

CPFR: Collaborative Planning, Forecasting and Replenishment among trading partners.

Vendor-Managed Inventory (VMI): A system in which a supplier monitors agreed inventory information and manages or recommends replenishment.

Point-of-sale data: Consumer transaction data captured at the retail selling point.

Bullwhip effect: Amplification of demand variability as information and orders move upstream.

Variance amplification ratio: Order variance divided by comparable consumer-demand variance.

Order batching: Accumulation of demand into less frequent, larger orders.

Forward buying: Purchasing extra quantity during a temporary discount or promotion.

Exception management: Identification, prioritisation, and resolution of material deviations from plan.

Plan stability: Degree to which an agreed plan changes over time.

Service level: A specified measure of availability or fulfilment performance.

Scenario planning: Evaluation of alternative assumptions and response options before commitment.

Review Questions

5 Short Answer Questions

  1. What is the central purpose of S&OP?
  2. How does IBP extend conventional S&OP?
  3. Define the bullwhip effect.
  4. State two differences between CPFR and VMI.
  5. Why should exception thresholds include an owner and an action path?

5 Long Answer Questions

  1. Explain the stages of a monthly S&OP cycle and the decision outputs expected from each stage.
  2. Discuss how demand, supply, capacity, inventory, and finance should be reconciled in IBP.
  3. Evaluate the operational benefits and governance risks of VMI.
  4. Explain the main causes of the bullwhip effect and assess methods for reducing it.
  5. Discuss the role of technology and AI in collaborative retail planning, including data and ethical limitations.

3 Analytical / Application Questions

  1. A retailer’s consumer-demand variance is 625 units² and its supplier-order variance is 1,500 units² over comparable weekly periods. Calculate the variance amplification ratio and interpret the result.
  2. Design an exception-management policy for a seasonal fashion category. Specify at least four triggers, responsible owners, response times, and possible corrective actions.
  3. A retailer is considering CPFR and VMI with a major supplier. Develop a recommendation framework that considers demand volatility, data quality, power balance, service requirements, inventory ownership, legal risk, and total cost.

Multiple Choice Questions with Answers

Question 1

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

A. To replace all operational replenishment decisions with an annual budget

B. To reconcile demand, supply, capacity, inventory, and business objectives

C. To maximise supplier production regardless of customer demand

D. To create a statistical forecast without commercial input

Correct Answer: B. To reconcile demand, supply, capacity, inventory, and business objectives

Question 2

In the exponential-smoothing equation Ft+1 = αDt + (1-α)Ft, increasing α generally makes the forecast:

A. More responsive to recent demand

B. Independent of recent demand

C. Always less accurate

D. Equal to the long-run average

Correct Answer: A. More responsive to recent demand

Question 3

If required workload is 9,000 labour-hours and effective capacity is 10,000 labour-hours, the capacity-load ratio is:

A. 0.09

B. 0.90

C. 1.11

D. 9.00

Correct Answer: B. 0.90

Question 4

Which activity is most characteristic of CPFR?

A. A supplier replenishes inventory without any agreed rules

B. Trading partners jointly develop forecasts and manage exceptions

C. A retailer withholds point-of-sale information from suppliers

D. A manufacturer plans only from its internal production schedule

Correct Answer: B. Trading partners jointly develop forecasts and manage exceptions

Question 5

Under VMI, which statement is correct?

A. The supplier automatically owns all inventory at the retailer

B. The retailer has no contractual control over replenishment

C. The supplier monitors agreed information and manages or recommends replenishment

D. The retailer is prohibited from setting inventory boundaries

Correct Answer: C. The supplier monitors agreed information and manages or recommends replenishment

Question 6

Consumer-demand variance is 400 units² and supplier-order variance is 1,000 units². The variance amplification ratio is:

A. 0.40

B. 1.50

C. 2.50

D. 4.00

Correct Answer: C. 2.50

Question 7

Which practice is most likely to reduce the bullwhip effect?

A. Increasing order batching and withholding sales data

B. Sharing point-of-sale data and stabilising replenishment policies

C. Encouraging shortage gaming by customers

D. Extending lead times without changing planning rules

Correct Answer: B. Sharing point-of-sale data and stabilising replenishment policies

Question 8

Why can MAPE be problematic for intermittent retail demand?

A. It cannot be expressed as a percentage

B. It is always larger than MAE

C. It becomes unstable or undefined when actual demand is zero or near zero

D. It measures inventory rather than forecast error

Correct Answer: C. It becomes unstable or undefined when actual demand is zero or near zero

Question 9

Which is the strongest example of an exception-management trigger?

A. Every SKU is reviewed for the same amount of time each day

B. A forecast change above a defined threshold creates an assigned investigation

C. Only annual sales are reviewed

D. Alerts are generated without owners or deadlines

Correct Answer: B. A forecast change above a defined threshold creates an assigned investigation

Question 10

Which statement best reflects responsible use of AI in retail planning?

A. AI recommendations never require human review

B. A model trained on stock-constrained sales always measures true demand

C. AI should be monitored for bias, drift, data quality, and explainability

D. Commercially sensitive data can be shared without governance

Correct Answer: C. AI should be monitored for bias, drift, data quality, and explainability

Retail Logistics & SCM
Chapter 5 of 15