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. 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, April.
    3. 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.
    4. 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.
    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 & 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.
    4. 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.
    5. 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.
    6. 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.
    7. 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.
    8. 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.
    9. François Clautiaux & Cláudio Alves & José Valério de Carvalho & Jürgen Rietz, 2011. "New Stabilization Procedures for the Cutting Stock Problem," INFORMS Journal on Computing, INFORMS, vol. 23(4), pages 530-545, November.
    10. de Lima, Vinícius L. & Alves, Cláudio & Clautiaux, François & Iori, Manuel & Valério de Carvalho, José M., 2022. "Arc flow formulations based on dynamic programming: Theoretical foundations and applications," European Journal of Operational Research, Elsevier, vol. 296(1), pages 3-21.
    11. Omid Shahvari & Rasaratnam Logendran & Madjid Tavana, 2022. "An efficient model-based branch-and-price algorithm for unrelated-parallel machine batching and scheduling problems," Journal of Scheduling, Springer, vol. 25(5), pages 589-621, October.
    12. Ramos, Francisco López & Batres, Rafael & De-la-Cruz-Márquez, Cynthia Griselle & Anzures, Melina López, 2023. "Optimization models for nopal crop planning with land usage expansion and government subsidy," Socio-Economic Planning Sciences, Elsevier, vol. 89(C).
    13. Letchford, Adam N. & Amaral, Andre, 2001. "Analysis of upper bounds for the Pallet Loading Problem," European Journal of Operational Research, Elsevier, vol. 132(3), pages 582-593, August.
    14. Ibrahim Muter & Tevfik Aytekin, 2017. "Incorporating Aggregate Diversity in Recommender Systems Using Scalable Optimization Approaches," INFORMS Journal on Computing, INFORMS, vol. 29(3), pages 405-421, August.
    15. Rostami, Borzou & Malucelli, Federico & Belotti, Pietro & Gualandi, Stefano, 2016. "Lower bounding procedure for the asymmetric quadratic traveling salesman problem," European Journal of Operational Research, Elsevier, vol. 253(3), pages 584-592.
    16. Melega, Gislaine Mara & de Araujo, Silvio Alexandre & Jans, Raf, 2018. "Classification and literature review of integrated lot-sizing and cutting stock problems," European Journal of Operational Research, Elsevier, vol. 271(1), pages 1-19.
    17. Zgajnar, Jaka & Kavcic, Stane, 2012. "Farm management support based on mathematical programming; an example of fertilization planning," Agroeconomia Croatica, Croatian Society of Agricultural Economists, vol. 2(01), pages 1-8, March.
    18. W. D. D. Madhavee & N. Saldin & U. C. Vaidyarathna & C. J. Jayawardene, 2018. "A Practical Application of the Generalized Cutting Stock Algorithm," Academic Journal of Applied Mathematical Sciences, Academic Research Publishing Group, vol. 4(3), pages 15-21, 03-2018.
    19. Mhand Hifi & Rym M'Hallah, 2005. "An Exact Algorithm for Constrained Two-Dimensional Two-Staged Cutting Problems," Operations Research, INFORMS, vol. 53(1), pages 140-150, February.
    20. Barry C. Smith & Ellis L. Johnson, 2006. "Robust Airline Fleet Assignment: Imposing Station Purity Using Station Decomposition," Transportation Science, INFORMS, vol. 40(4), pages 497-516, November.

    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.