Analyzing Supply Chains at HP Using Spreadsheet Models

Jason Amaral () and Dorothea Kuettner ()
Additional contact information
Jason Amaral: Emeraldwise, LLC, Woodside, California 94062
Dorothea Kuettner: Athena Insight, LLC, Menlo Park, California 94025

Interfaces, 2008, vol. 38, issue 4, 228-240

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.

Keywords: computers/computer science; system design/operation; cost analysis; planning; corporate (search for similar items in EconPapers)
Date: 2008
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (1)

Downloads: (external link)
http://dx.doi.org/10.1287/inte.1070.0336 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:inm:orinte:v:38:y:2008:i:4:p:228-240

Access Statistics for this article

More articles in Interfaces from INFORMS Contact information at EDIRC.
Bibliographic data for series maintained by Chris Asher ().