IDEAS home Printed from https://ideas.repec.org/a/wut/journl/v31y2021i4p117-127id1604.html
   My bibliography  Save this article

Stochastic programming model for production planning with stochastic aggregate demand and spreadsheet-based solution heuristics

Author

Listed:
  • Nasreddine Saadouli

Abstract

By discretising the stochastic demand, a deterministic nonlinear programming formulation is developed. Then, a hybrid simulation-optimisation heuristic that capitalises on the nature of the problem is designed. The outcome is an evaluation problem that is efficiently solved using a spreadsheet model. The main contribution of the paper is providing production managers with a tractable formulation of the production planning problem in a stochastic environment and an efficient solution scheme. A key benefit of this approach is that it provides quick near-optimal solutions without requiring in-depth knowledge or significant investments in optimisation techniques and software.

Suggested Citation

  • Nasreddine Saadouli, 2021. "Stochastic programming model for production planning with stochastic aggregate demand and spreadsheet-based solution heuristics," Operations Research and Decisions, Wroclaw University of Science and Technology, Faculty of Management, vol. 31(4), pages 117-127.
    • Handle: RePEc:wut:journl:v:31:y:2021:i:4:p:117-127:id:1604
    DOI: 10.37190/ord210406
    as

    Download full text from publisher

    File URL: https://ord.pwr.edu.pl/assets/papers_archive/1604%20-%20published.pdf
    Download Restriction: no
    File URL: https://libkey.io/10.37190/ord210406?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
    ---><---

    References listed on IDEAS

    as
    1. V. Krishnan & Karl T. Ulrich, 2001. "Product Development Decisions: A Review of the Literature," Management Science, INFORMS, vol. 47(1), pages 1-21, January.
    2. Tarik Aouam & Reha Uzsoy, 2015. "Zero-order production planning models with stochastic demand and workload-dependent lead times," International Journal of Production Research, Taylor & Francis Journals, vol. 53(6), pages 1661-1679, March.
    3. Klaus Altendorfer & Thomas Felberbauer & Herbert Jodlbauer, 2016. "Effects of forecast errors on optimal utilisation in aggregate production planning with stochastic customer demand," International Journal of Production Research, Taylor & Francis Journals, vol. 54(12), pages 3718-3735, June.
    4. C Lucas & S A MirHassani & G Mitra & C A Poojari, 2001. "An application of Lagrangian relaxation to a capacity planning problem under uncertainty," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 52(11), pages 1256-1266, November.
    5. Alexandar Angelus & Evan L. Porteus, 2002. "Simultaneous Capacity and Production Management of Short-Life-Cycle, Produce-to-Stock Goods Under Stochastic Demand," Management Science, INFORMS, vol. 48(3), pages 399-413, March.
    6. Nazrul Shaikh & Vittal Prabhu & Danilo Abril & David Sánchez & Jorge Arias & Esteban Rodríguez & Germán Riaño, 2011. "Kimberly-Clark Latin America Builds an Optimization-Based System for Machine Scheduling," Interfaces, INFORMS, vol. 41(5), pages 455-465, October.
    7. S. P. Sethi & H. Yan & H. Zhang & Q. Zhang, 2002. "Optimal and Hierarchical Controls in Dynamic Stochastic Manufacturing Systems: A Survey," Manufacturing & Service Operations Management, INFORMS, vol. 4(2), pages 133-170.
    8. H. Heitsch & H. Leövey & W. Römisch, 2016. "Are Quasi-Monte Carlo algorithms efficient for two-stage stochastic programs?," Computational Optimization and Applications, Springer, vol. 65(3), pages 567-603, December.
    9. E A Silver, 2004. "An overview of heuristic solution methods," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 55(9), pages 936-956, September.
    10. Golmohammadi, Amirmohsen & Hassini, Elkafi, 2019. "Capacity, pricing and production under supply and demand uncertainties with an application in agriculture," European Journal of Operational Research, Elsevier, vol. 275(3), pages 1037-1049.
    11. Po-Chen Lin & Reha Uzsoy, 2016. "Chance-constrained formulations in rolling horizon production planning: an experimental study," International Journal of Production Research, Taylor & Francis Journals, vol. 54(13), pages 3927-3942, July.
    Full references (including those not matched with items on IDEAS)

    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. Lijian Lu & Xiaoming Yan, 2016. "Capacity investment decisions under risk aversion," Naval Research Logistics (NRL), John Wiley & Sons, vol. 63(3), pages 218-235, April.
    2. Jan A. Van Mieghem, 2003. "Commissioned Paper: Capacity Management, Investment, and Hedging: Review and Recent Developments," Manufacturing & Service Operations Management, INFORMS, vol. 5(4), pages 269-302, July.
    3. Jodlbauer, Herbert & Altendorfer, Klaus, 2010. "Trade-off between capacity invested and inventory needed," European Journal of Operational Research, Elsevier, vol. 203(1), pages 118-133, May.
    4. Jan A. Van Mieghem & Nils Rudi, 2002. "Newsvendor Networks: Inventory Management and Capacity Investment with Discretionary Activities," Manufacturing & Service Operations Management, INFORMS, vol. 4(4), pages 313-335, August.
    5. Hazhir Rahmandad & Nelson Repenning, 2016. "Capability erosion dynamics," Strategic Management Journal, Wiley Blackwell, vol. 37(4), pages 649-672, April.
    6. Bookhagen, Andrea & Sperber, Sonja, 2017. "Kundenintegration in den Entwicklungsprozess von Produktinnovationen durch Crowdsourcing," PraxisWISSEN Marketing: German Journal of Marketing, AfM – Arbeitsgemeinschaft für Marketing, vol. 2(01/2017), pages 21-37.
    7. Wallace J. Hopp & Xiaowei Xu, 2005. "Product Line Selection and Pricing with Modularity in Design," Manufacturing & Service Operations Management, INFORMS, vol. 7(3), pages 172-187, August.
    8. Barry L. Bayus, 2013. "Crowdsourcing New Product Ideas over Time: An Analysis of the Dell IdeaStorm Community," Management Science, INFORMS, vol. 59(1), pages 226-244, June.
    9. Galbreath, Jeremy, 2017. "Drivers Of Environmental Sustainability In Wine Firms: The Role And Effect Of Women In Leadership," Working Papers 253851, American Association of Wine Economists.
    10. M. Bierlaire & M. Thémans & N. Zufferey, 2010. "A Heuristic for Nonlinear Global Optimization," INFORMS Journal on Computing, INFORMS, vol. 22(1), pages 59-70, February.
    11. Smirnov, Dina & van Jaarsveld, Willem & Atan, Zümbül & de Kok, Ton, 2021. "Long-term resource planning in the high-tech industry: Capacity or inventory?," European Journal of Operational Research, Elsevier, vol. 293(3), pages 926-940.
    12. Nguyen Trong Luan & Doan Nguyen Duy Hau & Nguyen Thi Anh Thu, 2022. "The Influence of Green Product Development Performance to Enhance Enterprise Effectiveness and Innovation," Economies, MDPI, vol. 10(5), pages 1-21, May.
    13. Schriber, Svante & Löwstedt, Jan, 2015. "Tangible resources and the development of organizational capabilities," Scandinavian Journal of Management, Elsevier, vol. 31(1), pages 54-68.
    14. Caniato, Federico & Caridi, Maria & Moretto, Antonella & Sianesi, Andrea & Spina, Gianluca, 2014. "Integrating international fashion retail into new product development," International Journal of Production Economics, Elsevier, vol. 147(PB), pages 294-306.
    15. Zeki Ayağ, 2016. "An integrated approach to concept evaluation in a new product development," Journal of Intelligent Manufacturing, Springer, vol. 27(5), pages 991-1005, October.
    16. Hongmin Li & Stephen C. Graves & Woonghee Tim Huh, 2014. "Optimal Capacity Conversion for Product Transitions Under High Service Requirements," Manufacturing & Service Operations Management, INFORMS, vol. 16(1), pages 46-60, February.
    17. Abedi, Vahideh Sadat, 2019. "Compartmental diffusion modeling: Describing customer heterogeneity & communication network to support decisions for new product introductions," Physica A: Statistical Mechanics and its Applications, Elsevier, vol. 536(C).
    18. Berchicci, L. & Tucci, C.L., 2008. "Market Feedback and Team Commitment in Radical Product Innovation Process," ERIM Report Series Research in Management ERS-2008-069-ORG, Erasmus Research Institute of Management (ERIM), ERIM is the joint research institute of the Rotterdam School of Management, Erasmus University and the Erasmus School of Economics (ESE) at Erasmus University Rotterdam.
    19. Eric Stevens & Ronald Boucher, 2020. "Designing Co-Creation Platforms: The Case of Configurators Toolkits," Post-Print hal-02872485, HAL.
    20. L. G. Pee, 2016. "Customer co-creation in B2C e-commerce: does it lead to better new products?," Electronic Commerce Research, Springer, vol. 16(2), pages 217-243, June.

    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:wut:journl:v:31:y:2021:i:4:p:117-127:id:1604. 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: Adam Kasperski (email available below). General contact details of provider: https://edirc.repec.org/data/iopwrpl.html .

    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.