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

Volumn 62, Issue 3, 2011, Pages 526-536

  Sodhi, M S ^a   Tang, C S ^b  

^a CITY UNIVERSITY   (United Kingdom)

^b UNIVERSITY OF CALIFORNIA   (United States)

Author keywords

conditional value at risk (cVaR); demand uncertainty; sales and operations planning (S OP); spreadsheet; stochastic programming; supply chain planning

Indexed keywords

RISK PERCEPTION; SALES; SPREADSHEETS; STOCHASTIC PROGRAMMING; STOCHASTIC SYSTEMS; SUPPLY CHAINS; VALUE ENGINEERING;

AGGREGATED MODELING; CONDITIONAL VALUE-AT-RISK; DEMAND UNCERTAINTY; EXCEL SPREADSHEETS; PLANNING HORIZONS; SALES AND OPERATIONS PLANNING; STOCHASTIC PROGRAMMING MODEL; SUPPLY CHAIN PLANNING;

STOCHASTIC MODELS;

EID: 79951596948     PISSN: 01605682     EISSN: 14769360     Source Type: Journal    
DOI: 10.1057/jors.2010.93     Document Type: Article

References (25)

1. Aghezzaf E (2005). Capacity planning and warehouse location in supply chains with uncertain demands. J Opl Res Soc 56: 453-462. (Pubitemid 40424120)
2. Birge JR (1985). Aggregation bounds in stochastic linear programming. Math Program 31: 25-41.
3. Birge JR and Louveaux F (1997). Introduction to Stochastic Programming. Springer Verlag: New York.
4. Dormer A, Vazacopoulos A, Verma N and Tipi H (2005). Modeling and solving stochastic programming problems in supply chain management using Xpress-SP. In: Geunes J and Pardalos P (eds). Supply Chain Optimization. Springer Publishers: New York, pp. 307-354.
5. Eppen GD, Martin RK and Schrage L (1989). A scenario approach to capacity planning. Opns Res 37: 517-524.
6. Geoffrion A and Powers R (1995). Twenty years of strategic distribution system design: An evolutionary perspective. Interfaces 25(5): 105-127.
7. Hoyland K and Wallace S (2001). Generating scenario trees for multistage decision problems. Mngt Sci 47: 295-307. (Pubitemid 34192765)
8. Iassinovski S, Artiba A, Bachelet V and Riane F (2003). Integration of simulation and optimization for solving complex decision making problems. Int J Prod Econ 85: 3-10.
9. Kamrad B and Ritchken R (1991). Multinomial approximating models for options with k state variables. Mngt Sci 37: 1640-1652.
10. Leung SCH, Wu Y and Lai KK (2006). A stochastic programming approach for multi-site aggregate production planning. J Opl Res Soc 57: 123-132. (Pubitemid 43149278)
11. Mula J, Poler R, Garcia-Sabtel JP and Lario FC (2006).Models for production planning under uncertainty: A review. Int Prod Econ 103: 271-285. (Pubitemid 43866480)
12. Nagali V, Hwang J, Sanghera D, Gaskins M, Pridgen M, Thurston T, Mackenroth P, Branvold D, Scholler P and Shoemaker G (2008). Procurement risk management (PRM) at Hewlett- Packard company. Interfaces 38: 51-60.
13. Olhager J, Rudberg M and Wikner J (2001). Long-term capacity management: Linking the perspectives from manufacturing strategy and sales and operations planning. Int J Prod Econ 69: 215-225. (Pubitemid 32035380)
14. Poojari CA, Lucas C and Mitra G (2008). Robust solutions and risk measures for a supply chain planning problem under uncertainty. J Opl Res Soc 59: 2-12. (Pubitemid 350261768)
15. Rockafellar RT and Uryasev S (2000). Optimization of conditional value-at-risk. J Risk 2(3): 21-41.
16. Sen S (2001). Stochastic programming: Computational issues and challenges. In: Gass S and Harris C (eds). Encyclopedia of Operations Research and Management Science. Springer: New York, pp. 784-788.
17. Sheldon DH (2007). World Class Sales-and-Operations-Planning: A Guide to Successful Implementation and Robust Execution. APICS and J. Ross Publishing: Fort Lauderdale, Florida.
18. Sodhi M (2005a). LP modeling for asset-liability management: A survey of choices and simplifications. Opns Res 53: 181-196. (Pubitemid 40666153)
19. Sodhi M (2005b). Managing tactical supply chain planning risk at a global consumer electronics company. Prod Opns Mngt 14(1): 69-79. (Pubitemid 40763477)
20. Sodhi M and Lee S (2007). An analysis of sources of risk in the consumer electronics industry. J Opl Res Soc 58: 1430-1439. (Pubitemid 47585084)
21. Sodhi M and Tang CS (2009). Modeling supply chain planning under demand uncertainty using stochastic programming: A survey motivated by asset-liability management. Intl J Prod Econ 121: 728-738.
22. Vollmann TE, Berry WL, Whybark DC and Jacobs FR (2005). Manufacturing Planning and Control Systems for Supply Chain Management. 5th edn, McGraw-Hill Professional: New York.
23. Wright SE (1994). Primal-dual aggregation and disaggregation for stochastic linear programs. Math Opns Res 19: 893-908.
24. Zipkin P (1980a). Bounds on the effect of aggregating variables in linear programs. Opns Res 28: 403-418. (Pubitemid 10474403)
25. Zipkin P (1980b). Bounds for row-aggregation in linear programming. Opns Res 28: 903-916.