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

Analyzing Supply Chains at HP Using Spreadsheet Models

Author

Listed:
  • Jason Amaral

    (Emeraldwise, LLC, Woodside, California 94062)

  • Dorothea Kuettner

    (Athena Insight, LLC, Menlo Park, California 94025)

Abstract

To satisfy shifting customer demand for an evolving product offering, every manufacturing company must reconfigure its supply chain network periodically. The network can be simple or complex. It may include suppliers, factories, final assembly locations, and distribution centers. Hewlett-Packard's (HP's) Strategic Planning and Modeling (SPaM) team has helped company executives to analyze numerous supply chain networks using spreadsheets (with and without Visual Basic for Applications (VBA)), spreadsheets with add-ins, custom-written software programs, and packaged software applications. Spreadsheets with and without VBA and add-ins are the most frequently used approach for analyzing supply chain networks. The team employs many advanced spreadsheet and VBA capabilities. It also minimizes unnecessary modeling complexity wherever possible. In this paper, we review why and how we use spreadsheets to analyze supply chains and discuss some of the ways of overcoming their limitations.

Suggested Citation

  • Jason Amaral & Dorothea Kuettner, 2008. "Analyzing Supply Chains at HP Using Spreadsheet Models," Interfaces, INFORMS, vol. 38(4), pages 228-240, August.
    • Handle: RePEc:inm:orinte:v:38:y:2008:i:4:p:228-240
    DOI: 10.1287/inte.1070.0336
    as

    Download full text from publisher

    File URL: http://dx.doi.org/10.1287/inte.1070.0336
    Download Restriction: no
    File URL: https://libkey.io/10.1287/inte.1070.0336?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. Billington, CA & Davis, TC, 1992. "Manufacturing strategy analysis: Models and practice," Omega, Elsevier, vol. 20(5-6), pages 587-595.
    2. Hau L. Lee & Corey Billington, 1995. "The Evolution of Supply-Chain-Management Models and Practice at Hewlett-Packard," Interfaces, INFORMS, vol. 25(5), pages 42-63, October.
    3. Corey Billington & Gianpaolo Callioni & Barrett Crane & John D. Ruark & Julie Unruh Rapp & Trace White & Sean P. Willems, 2004. "Accelerating the Profitability of Hewlett-Packard's Supply Chains," Interfaces, INFORMS, vol. 34(1), pages 59-72, February.
    4. Claude Laval & Marc Feyhl & Steve Kakouros, 2005. "Hewlett-Packard Combined OR and Expert Knowledge to Design Its Supply Chains," Interfaces, INFORMS, vol. 35(3), pages 238-247, June.
    5. Thomas A. Grossman, 2006. "Integrating Spreadsheet Engineering in a Management Science Course: A Hierarchical Approach," INFORMS Transactions on Education, INFORMS, vol. 7(1), pages 18-36, September.
    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. Richard Job Madapat Job & Quintin Williams Jr. & Michael Cailas & Matthew Liotine & Jim Novotny, 2021. "Evaluation of Critical Infrastructure Essential Businesses Amidst Covid -19 Using Network Optimization Models," International Journal of Business Research and Management (IJBRM), Computer Science Journals (CSC Journals), vol. 12(5), pages 289-307, October.

    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. 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.
    2. Ganesh, Gopala & Paswan, Audhesh K., 2010. "Teaching basic marketing accountability using spreadsheets: An exploratory perspective," Journal of Business Research, Elsevier, vol. 63(2), pages 182-190, February.
    3. Judit Oláh & Attila Bai & György Karmazin & Péter Balogh & József Popp, 2017. "The Role Played by Trust and Its Effect on the Competiveness of Logistics Service Providers in Hungary," Sustainability, MDPI, vol. 9(12), pages 1-22, December.
    4. Osman, Hany & Demirli, Kudret, 2010. "A bilinear goal programming model and a modified Benders decomposition algorithm for supply chain reconfiguration and supplier selection," International Journal of Production Economics, Elsevier, vol. 124(1), pages 97-105, March.
    5. William W. Wilson & Donald C.E. Carlson & Bruce L. Dahl, 2004. "Logistics and supply chain strategies in grain exporting," Agribusiness, John Wiley & Sons, Ltd., vol. 20(4), pages 449-464.
    6. Charles L. Munson & Jianli Hu & Meir J. Rosenblatt, 2003. "Teaching the Costs of Uncoordinated Supply Chains," Interfaces, INFORMS, vol. 33(3), pages 24-39, June.
    7. Morris A. Cohen & Suman Mallik, 1997. "Global Supply Chains: Research And Applications," Production and Operations Management, Production and Operations Management Society, vol. 6(3), pages 193-210, September.
    8. Johnson, Mark & Mena, Carlos, 2008. "Supply chain management for servitised products: A multi-industry case study," International Journal of Production Economics, Elsevier, vol. 114(1), pages 27-39, July.
    9. Steffen T. Klosterhalfen & Stefan Minner & Sean P. Willems, 2014. "Strategic Safety Stock Placement in Supply Networks with Static Dual Supply," Manufacturing & Service Operations Management, INFORMS, vol. 16(2), pages 204-219, May.
    10. Mark Nissen, 2000. "Agent‐based supply chain disintermediation versus re‐intermediation: economic and technological perspectives," Intelligent Systems in Accounting, Finance and Management, John Wiley & Sons, Ltd., vol. 9(4), pages 237-256, December.
    11. Mustapha Ouhimmou & Sophie D'Amours & Robert Beauregard & Daoud Ait-Kadi & Satyaveer Singh Chauhan, 2009. "Optimization Helps Shermag Gain Competitive Edge," Interfaces, INFORMS, vol. 39(4), pages 329-345, August.
    12. John J. Neale & Sean P. Willems, 2009. "Managing Inventory in Supply Chains with Nonstationary Demand," Interfaces, INFORMS, vol. 39(5), pages 388-399, October.
    13. Manisha Seth & D.P. Goyal & Ravi Kiran, 2015. "Development of a Model for Successful Implementation of Supply Chain Management Information System in Indian Automotive Industry," Vision, , vol. 19(3), pages 248-262, September.
    14. Vikram Tiwari & Srinagesh Gavirneni, 2007. "ASP, The Art and Science of Practice: Recoupling Inventory Control Research and Practice: Guidelines for Achieving Synergy," Interfaces, INFORMS, vol. 37(2), pages 176-186, April.
    15. van der Vorst, Jack G. A. J. & Beulens, Adrie J. M. & van Beek, Paul, 2000. "Modelling and simulating multi-echelon food systems," European Journal of Operational Research, Elsevier, vol. 122(2), pages 354-366, April.
    16. Alexandra Ioana FLOREA, 2014. "Challenges And Strategies Of Supply Chain Management In A Competitive Environment," Business Excellence and Management, Faculty of Management, Academy of Economic Studies, Bucharest, Romania, vol. 4(2), pages 36-43, June.
    17. de Kok, Ton & Grob, Christopher & Laumanns, Marco & Minner, Stefan & Rambau, Jörg & Schade, Konrad, 2018. "A typology and literature review on stochastic multi-echelon inventory models," European Journal of Operational Research, Elsevier, vol. 269(3), pages 955-983.
    18. Roberta Pellegrino & Nicola Costantino & Danilo Tauro, 2020. "Advance Purchase Discounts for Supply Chain Finance System Coordination," Sustainability, MDPI, vol. 12(23), pages 1-20, December.
    19. Biswas, S. & Narahari, Y., 2004. "Object oriented modeling and decision support for supply chains," European Journal of Operational Research, Elsevier, vol. 153(3), pages 704-726, March.
    20. Chong, Alain Yee-Loong & Ooi, Keng-Boon & Sohal, Amrik, 2009. "The relationship between supply chain factors and adoption of e-Collaboration tools: An empirical examination," International Journal of Production Economics, Elsevier, vol. 122(1), pages 150-160, 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:38:y:2008:i:4:p:228-240. 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.