Determining Supply Requirement in the Sales-and-Operations-Planning (S&OP) Process Under Demand Uncertainty: A Stochastic Programming Formulation and a Spreadsheet Implementation
Journal of the Operational Research Society, Forthcoming
26 Pages Posted: 16 Jul 2010
Date Written: May 5, 2010
Abstract
We show how to extend the demand planning stage of the sales-and-operations-planning (S&OP) process with a spreadsheet implementation of a stochastic programming model that determines the supply requirement while optimally trading off risks of unmet demand, excess inventory and inadequate liquidity in the presence of demand uncertainty. We first present the model that minimizes the weighted sum of respective conditional value-at-risk (cVaR) metrics over demand scenarios in the form of a binomial tree. The output of this model is the supply requirement to be used in the supply planning stage of the S&OP process. Next we show how row-and-column aggregation of the model reduces its size from exponential (2^T) in the number of time periods T in the planning horizon to merely square (T^2). Finally, we demonstrate the tractability of this aggregated model in an Excel spreadsheet implementation with a numerical example with 26 time periods.
Keywords: Supply Chain Risk Management, Risk Models, Stochastic Programming, Supply-Chain Planning, Demand Planning, Demand Uncertainty, Sales-and-Operations Planning (S&OP), Risk Metrics, Conditional Value-at-Risk (Cvar), Spreadsheet, Newsvendor Problem
Suggested Citation: Suggested Citation
Do you have a job opening that you would like to promote on SSRN?
Recommended Papers
-
Coordination of Supply Chains with Risk-Averse Agents
By Xianghua Gan, Suresh Sethi, ...
-
Channel Coordination with a Risk-Neutral Supplier and a Downside-Risk-Averse Retailer
By Xianghua Gan, Suresh Sethi, ...
-
A Multi-Product Risk-Averse Newsvendor with Law-Invariant Coherent Measures of Risk
By Sungyong Choi, Andrzej Ruszczynski, ...
-
A Risk-Averse Newsvendor Model under CVaR Decision Criterion
By Frank Chen, Minghui Xu, ...
-
Managing Demand Risk in Tactical Supply Chain Planning for a Global Consumer Electronics Company
-
Economic Evaluation of Scale Dependent Technology Investments
By Phillip J. Lederer and Tushar Mehta
-
The Effects of Sharing Upstream Information on Product Rollover
By Zhaolin Li and Long Gao
-
Contracting and Coordination Under Asymmetric Production Cost Information
By M. Çakanyıldırım, Qi Feng, ...
