IDEAS home Printed from https://ideas.repec.org/a/inm/orinte/v43y2013i6p503-517.html
   My bibliography  Save this article

A Specialty Steel Bar Company Uses Analytics to Determine Available-to-Promise Dates

Author

Listed:
  • Foad Mahdavi Pajouh

    (Department of Industrial and Systems Engineering, University of Florida, Shalimar, Florida 32579)

  • Dahai Xing

    (Operations Analysis, FedEx Corporate, Memphis, Tennessee 38120)

  • Yingjue Zhou

    (School of Industrial Engineering and Management, Oklahoma State University, Stillwater, Oklahoma 74078)

  • Sharethram Hariharan

    (Global Planning Business Intelligence, Dell Inc., Round Rock, Texas 78682)

  • Balabhaskar Balasundaram

    (School of Industrial Engineering and Management, Oklahoma State University, Stillwater, Oklahoma 74078)

  • Tieming Liu

    (School of Industrial Engineering and Management, Oklahoma State University, Stillwater, Oklahoma 74078)

  • Ramesh Sharda

    (Department of Management Science and Information Systems, Spears School of Business, Oklahoma State University, Stillwater, Oklahoma 74078)

Abstract

In this paper, we describe an application of prescriptive analytics to enhance data-driven decision making at a specialty steel bar products supplier and manufacturer in North America. As part of the company’s daily business, it must make available-to-promise (ATP) decisions, which determine in real time the dates by which it can promise delivery of products that customers requested during the quotation stage. Previously, a salesperson had to make such decisions by analyzing reports on available inventory. To support these ATP decisions, we developed a real-time decision support system (DSS) to find an optimal assignment of the available inventory and to support additional what-if analysis. The DSS uses a suite of mixed-integer programming models and commercial software to solve the models. The company has incorporated the DSS into its enterprise resource planning system to seamlessly facilitate its use of business analytics.

Suggested Citation

  • Foad Mahdavi Pajouh & Dahai Xing & Yingjue Zhou & Sharethram Hariharan & Balabhaskar Balasundaram & Tieming Liu & Ramesh Sharda, 2013. "A Specialty Steel Bar Company Uses Analytics to Determine Available-to-Promise Dates," Interfaces, INFORMS, vol. 43(6), pages 503-517, December.
    • Handle: RePEc:inm:orinte:v:43:y:2013:i:6:p:503-517
    DOI: 10.1287/inte.2013.0693
    as

    Download full text from publisher

    File URL: http://dx.doi.org/10.1287/inte.2013.0693
    Download Restriction: no
    File URL: https://libkey.io/10.1287/inte.2013.0693?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. P. C. Gilmore & R. E. Gomory, 1961. "A Linear Programming Approach to the Cutting-Stock Problem," Operations Research, INFORMS, vol. 9(6), pages 849-859, December.
    2. Zhenying Zhao & Michael Ball & Masahiro Kotake, 2005. "Optimization-Based Available-To-Promise with Multi-Stage Resource Availability," Annals of Operations Research, Springer, vol. 135(1), pages 65-85, March.
    3. Pibernik, Richard, 2005. "Advanced available-to-promise: Classification, selected methods and requirements for operations and inventory management," International Journal of Production Economics, Elsevier, vol. 93(1), pages 239-252, January.
    4. Dylan Jones & Mehrdad Tamiz, 2010. "Practical Goal Programming," International Series in Operations Research and Management Science, Springer, edition 1, number 978-1-4419-5771-9, September.
    5. Vastag, Gyula & Whybark, D. Clay, 1993. "Global relations between inventory, manufacturing lead time and delivery date promises," International Journal of Production Economics, Elsevier, vol. 30(1), pages 563-569, July.
    6. Kingsman, Brian & Worden, Lee & Hendry, Linda & Mercer, Alan & Wilson, Elaine, 1993. "Integrating marketing and production planning in make-to-order companies," International Journal of Production Economics, Elsevier, vol. 30(1), pages 53-66, 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. Gössinger, Ralf & Kalkowski, Sonja, 2015. "Robust order promising with anticipated customer response," International Journal of Production Economics, Elsevier, vol. 170(PB), pages 529-542.
    2. Seitz, Alexander & Grunow, Martin & Akkerman, Renzo, 2020. "Data driven supply allocation to individual customers considering forecast bias," International Journal of Production Economics, Elsevier, vol. 227(C).
    3. Alexander Seitz & Martin Grunow, 2017. "Increasing accuracy and robustness of order promises," International Journal of Production Research, Taylor & Francis Journals, vol. 55(3), pages 656-670, February.
    4. Xiong, M.H. & Tor, S.B. & Bhatnagar, Rohit & Khoo, L.P. & Venkat, S., 2006. "A DSS approach to managing customer enquiries for SMEs at the customer enquiry stage," International Journal of Production Economics, Elsevier, vol. 103(1), pages 332-346, September.
    5. Alexander Seitz & Hans Ehm & Renzo Akkerman & Sarah Osman, 2016. "A robust supply chain planning framework for revenue management in the semiconductor industry," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 15(6), pages 523-533, December.
    6. Ali Hojjat & John Turner & Suleyman Cetintas & Jian Yang, 2017. "A Unified Framework for the Scheduling of Guaranteed Targeted Display Advertising Under Reach and Frequency Requirements," Operations Research, INFORMS, vol. 65(2), pages 289-313, April.
    7. Valerio de Carvalho, J. M., 2002. "LP models for bin packing and cutting stock problems," European Journal of Operational Research, Elsevier, vol. 141(2), pages 253-273, September.
    8. Francisco Salas-Molina & Filippo Bistaffa & Juan A. Rodriguez-Aguilar, 2024. "A General Approach for Computing a Consensus in Group Decision Making That Integrates Multiple Ethical Principles," Papers 2401.07818, arXiv.org, revised Mar 2024.
    9. Mhand Hifi & Rym M'Hallah & Toufik Saadi, 2008. "Algorithms for the Constrained Two-Staged Two-Dimensional Cutting Problem," INFORMS Journal on Computing, INFORMS, vol. 20(2), pages 212-221, May.
    10. Thomas L. Magnanti, 2021. "Optimization: From Its Inception," Management Science, INFORMS, vol. 67(9), pages 5349-5363, September.
    11. Song, X. & Chu, C.B. & Nie, Y.Y. & Bennell, J.A., 2006. "An iterative sequential heuristic procedure to a real-life 1.5-dimensional cutting stock problem," European Journal of Operational Research, Elsevier, vol. 175(3), pages 1870-1889, December.
    12. Corti, Donatella & Pozzetti, Alessandro & Zorzini, Marta, 2006. "A capacity-driven approach to establish reliable due dates in a MTO environment," International Journal of Production Economics, Elsevier, vol. 104(2), pages 536-554, December.
    13. Amanda O. C. Ayres & Betania S. C. Campello & Washington A. Oliveira & Carla T. L. S. Ghidini, 2021. "A Bi-Integrated Model for coupling lot-sizing and cutting-stock problems," OR Spectrum: Quantitative Approaches in Management, Springer;Gesellschaft für Operations Research e.V., vol. 43(4), pages 1047-1076, December.
    14. Alarcón, F. & Alemany, M.M.E. & Ortiz, A., 2009. "Conceptual framework for the characterization of the order promising process in a collaborative selling network context," International Journal of Production Economics, Elsevier, vol. 120(1), pages 100-114, July.
    15. François Vanderbeck, 2000. "Exact Algorithm for Minimising the Number of Setups in the One-Dimensional Cutting Stock Problem," Operations Research, INFORMS, vol. 48(6), pages 915-926, December.
    16. Lee, Taehan & Park, Sungsoo, 2001. "An integer programming approach to the time slot assignment problem in SS/TDMA systems with intersatellite links," European Journal of Operational Research, Elsevier, vol. 135(1), pages 57-66, November.
    17. Erjavec, J. & Gradisar, M. & Trkman, P., 2012. "Assessment of stock size to minimize cutting stock production costs," International Journal of Production Economics, Elsevier, vol. 135(1), pages 170-176.
    18. Umetani, Shunji & Yagiura, Mutsunori & Ibaraki, Toshihide, 2003. "One-dimensional cutting stock problem to minimize the number of different patterns," European Journal of Operational Research, Elsevier, vol. 146(2), pages 388-402, April.
    19. Sankaran, Jayaram K., 1995. "Column generation applied to linear programs in course registration," European Journal of Operational Research, Elsevier, vol. 87(2), pages 328-342, December.
    20. Sesh Murthy & Rama Akkiraju & Richard Goodwin & Pinar Keskinocak & John Rachlin & Frederick Wu & James Yeh & Robert Fuhrer & Santhosh Kumaran & Alok Aggarwal & Martin Sturzenbecker & Ranga Jayaraman &, 1999. "Cooperative Multiobjective Decision Support for the Paper Industry," Interfaces, INFORMS, vol. 29(5), pages 5-30, October.

    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:inm:orinte:v:43:y:2013:i:6:p:503-517. 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: Chris Asher (email available below). General contact details of provider: https://edirc.repec.org/data/inforea.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.