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. 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. 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.
    3. 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.
    4. 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.
    5. 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.
    6. 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.
    7. 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.
    8. 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.
    9. 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.
    10. 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.
    11. 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.
    12. John Miltenburg, 2019. "Online Teaching in a Large, Required, Undergraduate Management Science Course," INFORMS Transactions on Education, INFORMS, vol. 19(2), pages 89-104, January.
    13. John M. Bossert & Sean P. Willems, 2007. "A Periodic-Review Modeling Approach for Guaranteed Service Supply Chains," Interfaces, INFORMS, vol. 37(5), pages 420-436, October.
    14. Vladimir Modrak & Zuzana Soltysova, 2017. "Novel Complexity Indicator of Manufacturing Process Chains and Its Relations to Indirect Complexity Indicators," Complexity, Hindawi, vol. 2017, pages 1-15, June.
    15. 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.
    16. Wallace J. Hopp & Mark L. Spearman, 2004. "To Pull or Not to Pull: What Is the Question?," Manufacturing & Service Operations Management, INFORMS, vol. 6(2), pages 133-148, August.
    17. 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.
    18. Crespo Marquez, Adolfo & Bianchi, Carmine & Gupta, Jatinder N. D., 2004. "Operational and financial effectiveness of e-collaboration tools in supply chain integration," European Journal of Operational Research, Elsevier, vol. 159(2), pages 348-363, December.
    19. Sneha Kumari & Shirish Jeble & V. G. Venkatesh & Chandrasekaran Nagarajan & Yangyan Shi, 2023. "Antecedents of agriculture supply chain performance during COVID-19: an emerging economy perspective," Operations Management Research, Springer, vol. 16(1), pages 489-510, March.
    20. 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.

    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.