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. 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.
    3. 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.
    4. 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.
    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. 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.
    2. 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.
    3. 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.
    4. 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.
    5. 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.
    6. Y H Yang & Y V Hui & L C Leung & G Chen, 2010. "An analytic network process approach to the selection of logistics service providers for air cargo," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 61(9), pages 1365-1376, September.
    7. Khalid Al-Shuaibi, 2016. "Reaping the Benefits of Long Term Relationship with Suppliers: An Evidence from the Saudi Chemical Industry," International Journal of Business and Management, Canadian Center of Science and Education, vol. 11(8), pages 203-203, July.
    8. Wang, Juite & Shu, Yun-Feng, 2007. "A possibilistic decision model for new product supply chain design," European Journal of Operational Research, Elsevier, vol. 177(2), pages 1044-1061, March.
    9. 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.
    10. LeBlanc, Larry J. & Grossman, Thomas A. & Bartolacci, Michael R., 2019. "Ensuring scalability and reusability of spreadsheet linear programming models," Omega, Elsevier, vol. 84(C), pages 55-69.
    11. Chenhall, Robert H., 2005. "Integrative strategic performance measurement systems, strategic alignment of manufacturing, learning and strategic outcomes: an exploratory study," Accounting, Organizations and Society, Elsevier, vol. 30(5), pages 395-422, July.
    12. Abdullah Dasci & Vedat Verter, 2005. "Evaluation of Plant Focus Strategies: A Continuous Approximation Framework," Annals of Operations Research, Springer, vol. 136(1), pages 303-327, April.
    13. Lawrence C. Leung & Yer Van Hui & Yong Wang & Gang Chen, 2009. "A 0--1 LP Model for the Integration and Consolidation of Air Cargo Shipments," Operations Research, INFORMS, vol. 57(2), pages 402-412, April.
    14. Thomas A. Grossman & Vijay Mehrotra & Mouwafac Sidaoui, 2016. "A Student-Centered Approach to the Business School Management Science Course," INFORMS Transactions on Education, INFORMS, vol. 16(2), pages 42-53, January.
    15. Yavuz Acar, 2014. "Forecasting Method Selection Based on Operational Performance," Bogazici Journal, Review of Social, Economic and Administrative Studies, Bogazici University, Department of Economics, vol. 28(1), pages 95-114.
    16. Gu, Qiannong & Jitpaipoon, Thawatchai & Yang, Jie, 2017. "The impact of information integration on financial performance: A knowledge-based view," International Journal of Production Economics, Elsevier, vol. 191(C), pages 221-232.
    17. Moritz Julius Ziegler & Kilian Seifried & Philipp Kuske & Moritz Fleischmann, 2019. "TRUMPF Uses a Mixed Integer Model as Decision Support for Strategic Production Network Design," Interfaces, INFORMS, vol. 49(3), pages 213-226, May.
    18. John J. Neale & Sean P. Willems, 2009. "Managing Inventory in Supply Chains with Nonstationary Demand," Interfaces, INFORMS, vol. 39(5), pages 388-399, October.
    19. 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.
    20. 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.

    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.