IDEAS home Printed from https://ideas.repec.org/a/pal/jorsoc/v62y2011i3d10.1057_jors.2010.93.html
   My bibliography  Save this article

Determining supply requirement in the sales-and-operations-planning (S&OP) process under demand uncertainty: a stochastic programming formulation and a spreadsheet implementation

Author

Listed:
  • M S Sodhi

    (City University of London)

  • C S Tang

    (University of California Los Angeles)

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.

Suggested Citation

  • M S Sodhi & C S Tang, 2011. "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, Palgrave Macmillan;The OR Society, vol. 62(3), pages 526-536, March.
    • Handle: RePEc:pal:jorsoc:v:62:y:2011:i:3:d:10.1057_jors.2010.93
    DOI: 10.1057/jors.2010.93
    as

    Download full text from publisher

    File URL: http://link.springer.com/10.1057/jors.2010.93
    File Function: Abstract
    Download Restriction: Access to full text is restricted to subscribers.
    File URL: https://libkey.io/10.1057/jors.2010.93?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Venu Nagali & Jerry Hwang & David Sanghera & Matt Gaskins & Mark Pridgen & Tim Thurston & Patty Mackenroth & Dwight Branvold & Patrick Scholler & Greg Shoemaker, 2008. "Procurement Risk Management (PRM) at Hewlett-Packard Company," Interfaces, INFORMS, vol. 38(1), pages 51-60, February.
    2. Iassinovski, S. & Artiba, A. & Bachelet, V. & Riane, F., 2003. "Integration of simulation and optimization for solving complex decision making problems," International Journal of Production Economics, Elsevier, vol. 85(1), pages 3-10, July.
    3. Paul H. Zipkin, 1980. "Bounds on the Effect of Aggregating Variables in Linear Programs," Operations Research, INFORMS, vol. 28(2), pages 403-418, April.
    4. Arthur M. Geoffrion & Richard F. Powers, 1995. "Twenty Years of Strategic Distribution System Design: An Evolutionary Perspective," Interfaces, INFORMS, vol. 25(5), pages 105-127, October.
    5. AGHEZZAF, El-Houssaine, 2005. "Capacity planning and warehouse location in supply chains with uncertain demands," LIDAM Reprints CORE 1808, Université catholique de Louvain, Center for Operations Research and Econometrics (CORE).
    6. S. E. Wright, 1994. "Primal-Dual Aggregation and Disaggregation for Stochastic Linear Programs," Mathematics of Operations Research, INFORMS, vol. 19(4), pages 893-908, November.
    7. S C H Leung & Y Wu & K K Lai, 2006. "A stochastic programming approach for multi-site aggregate production planning," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 57(2), pages 123-132, February.
    8. M S Sodhi & S Lee, 2007. "An analysis of sources of risk in the consumer electronics industry," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 58(11), pages 1430-1439, November.
    9. C A Poojari & C Lucas & G Mitra, 2008. "Robust solutions and risk measures for a supply chain planning problem under uncertainty," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 59(1), pages 2-12, January.
    10. Kjetil Høyland & Stein W. Wallace, 2001. "Generating Scenario Trees for Multistage Decision Problems," Management Science, INFORMS, vol. 47(2), pages 295-307, February.
    11. Gary D. Eppen & R. Kipp Martin & Linus Schrage, 1989. "OR Practice—A Scenario Approach to Capacity Planning," Operations Research, INFORMS, vol. 37(4), pages 517-527, August.
    12. Bardia Kamrad & Peter Ritchken, 1991. "Multinomial Approximating Models for Options with k State Variables," Management Science, INFORMS, vol. 37(12), pages 1640-1652, December.
    13. Olhager, Jan & Rudberg, Martin & Wikner, Joakim, 2001. "Long-term capacity management: Linking the perspectives from manufacturing strategy and sales and operations planning," International Journal of Production Economics, Elsevier, vol. 69(2), pages 215-225, January.
    14. Paul H. Zipkin, 1980. "Bounds for Row-Aggregation in Linear Programming," Operations Research, INFORMS, vol. 28(4), pages 903-916, August.
    15. Sodhi, ManMohan S. & Tang, Christopher S., 2009. "Modeling supply-chain planning under demand uncertainty using stochastic programming: A survey motivated by asset-liability management," International Journal of Production Economics, Elsevier, vol. 121(2), pages 728-738, October.
    16. Mula, J. & Poler, R. & Garcia-Sabater, J.P. & Lario, F.C., 2006. "Models for production planning under uncertainty: A review," International Journal of Production Economics, Elsevier, vol. 103(1), pages 271-285, September.
    17. E Aghezzaf, 2005. "Capacity planning and warehouse location in supply chains with uncertain demands," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 56(4), pages 453-462, April.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Wang, Gang & Gunasekaran, Angappa & Ngai, Eric W.T. & Papadopoulos, Thanos, 2016. "Big data analytics in logistics and supply chain management: Certain investigations for research and applications," International Journal of Production Economics, Elsevier, vol. 176(C), pages 98-110.
    2. Tuomikangas, Nina & Kaipia, Riikka, 2014. "A coordination framework for sales and operations planning (S&OP): Synthesis from the literature," International Journal of Production Economics, Elsevier, vol. 154(C), pages 243-262.
    3. Pereira, Daniel Filipe & Oliveira, José Fernando & Carravilla, Maria Antónia, 2020. "Tactical sales and operations planning: A holistic framework and a literature review of decision-making models," International Journal of Production Economics, Elsevier, vol. 228(C).
    4. Pereira, Daniel Filipe & Oliveira, José Fernando & Carravilla, Maria Antónia, 2022. "Merging make-to-stock/make-to-order decisions into sales and operations planning: A multi-objective approach," Omega, Elsevier, vol. 107(C).
    5. Michal Adamczak & Piotr Cyplik, 2017. "Influence Of Task Environment On Efficiency Of Material Flow In Companies With Different Level Of Integration Of Planning Processes," Business Logistics in Modern Management, Josip Juraj Strossmayer University of Osijek, Faculty of Economics, Croatia, vol. 17, pages 125-138.
    6. Ben Ali, M. & D’Amours, S. & Gaudreault, J. & Carle, M-A., 2018. "Configuration and evaluation of an integrated demand management process using a space-filling design and Kriging metamodeling," Operations Research Perspectives, Elsevier, vol. 5(C), pages 45-58.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Sodhi, ManMohan S. & Tang, Christopher S., 2009. "Modeling supply-chain planning under demand uncertainty using stochastic programming: A survey motivated by asset-liability management," International Journal of Production Economics, Elsevier, vol. 121(2), pages 728-738, October.
    2. Tang, Christopher S. & Davarzani, Hoda & Sarkis, Joseph, 2015. "Quantitative models for managing supply chain risks: A reviewAuthor-Name: Fahimnia, Behnam," European Journal of Operational Research, Elsevier, vol. 247(1), pages 1-15.
    3. ManMohan S. Sodhi, 2005. "LP Modeling for Asset-Liability Management: A Survey of Choices and Simplifications," Operations Research, INFORMS, vol. 53(2), pages 181-196, April.
    4. Nickel, Stefan & Saldanha-da-Gama, Francisco & Ziegler, Hans-Peter, 2012. "A multi-stage stochastic supply network design problem with financial decisions and risk management," Omega, Elsevier, vol. 40(5), pages 511-524.
    5. Hahn, G.J. & Kuhn, H., 2012. "Simultaneous investment, operations, and financial planning in supply chains: A value-based optimization approach," International Journal of Production Economics, Elsevier, vol. 140(2), pages 559-569.
    6. Sabet, Ehsan & Yazdani, Baback & Kian, Ramez & Galanakis, Kostas, 2020. "A strategic and global manufacturing capacity management optimisation model: A Scenario-based multi-stage stochastic programming approach," Omega, Elsevier, vol. 93(C).
    7. Zhizhu Lai & Qun Yue & Zheng Wang & Dongmei Ge & Yulong Chen & Zhihong Zhou, 2022. "The min-p robust optimization approach for facility location problem under uncertainty," Journal of Combinatorial Optimization, Springer, vol. 44(2), pages 1134-1160, September.
    8. De Rosa, Vincenzo & Gebhard, Marina & Hartmann, Evi & Wollenweber, Jens, 2013. "Robust sustainable bi-directional logistics network design under uncertainty," International Journal of Production Economics, Elsevier, vol. 145(1), pages 184-198.
    9. Murwan Siddig & Yongjia Song, 2022. "Adaptive partition-based SDDP algorithms for multistage stochastic linear programming with fixed recourse," Computational Optimization and Applications, Springer, vol. 81(1), pages 201-250, January.
    10. Beltran-Royo, C., 2017. "Two-stage stochastic mixed-integer linear programming: The conditional scenario approach," Omega, Elsevier, vol. 70(C), pages 31-42.
    11. Kiya, Farhad & Davoudpour, Hamid, 2012. "Stochastic programming approach to re-designing a warehouse network under uncertainty," Transportation Research Part E: Logistics and Transportation Review, Elsevier, vol. 48(5), pages 919-936.
    12. Alexander H. Gose & Brian T. Denton, 2016. "Sequential Bounding Methods for Two-Stage Stochastic Programs," INFORMS Journal on Computing, INFORMS, vol. 28(2), pages 351-369, May.
    13. John Turner, 2012. "The Planning of Guaranteed Targeted Display Advertising," Operations Research, INFORMS, vol. 60(1), pages 18-33, February.
    14. M. Fattahi & M. Mahootchi & S. M. Moattar Husseini, 2016. "Integrated strategic and tactical supply chain planning with price-sensitive demands," Annals of Operations Research, Springer, vol. 242(2), pages 423-456, July.
    15. Merrick, James H. & Weyant, John P., 2019. "On choosing the resolution of normative models," European Journal of Operational Research, Elsevier, vol. 279(2), pages 511-523.
    16. Laurent Lim, Lâm & Alpan, Gülgün & Penz, Bernard, 2014. "Reconciling sales and operations management with distant suppliers in the automotive industry: A simulation approach," International Journal of Production Economics, Elsevier, vol. 151(C), pages 20-36.
    17. Gong, Hailei & Zhang, Zhi-Hai, 2022. "Benders decomposition for the distributionally robust optimization of pricing and reverse logistics network design in remanufacturing systems," European Journal of Operational Research, Elsevier, vol. 297(2), pages 496-510.
    18. D. Kuhn, 2009. "Convergent Bounds for Stochastic Programs with Expected Value Constraints," Journal of Optimization Theory and Applications, Springer, vol. 141(3), pages 597-618, June.
    19. Merrick, James H. & Bistline, John E.T. & Blanford, Geoffrey J., 2024. "On representation of energy storage in electricity planning models," Energy Economics, Elsevier, vol. 136(C).
    20. Correia, Isabel & Melo, Teresa, 2019. "Dynamic facility location problem with modular capacity adjustments under uncertainty," Technical Reports on Logistics of the Saarland Business School 17, Saarland University of Applied Sciences (htw saar), Saarland Business School.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:pal:jorsoc:v:62:y:2011:i:3:d:10.1057_jors.2010.93. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Sonal Shukla or Springer Nature Abstracting and Indexing (email available below). General contact details of provider: http://www.palgrave-journals.com/ .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.