This Article Full Text (PDF) References Alert me when this article is cited Alert me if a correction is posted Services Email this article to a friend Similar articles in this journal Alert me to new issues of the journal Download to citation manager Citing Articles Citing Articles via Google Scholar Google Scholar Articles by Amaral, J. Articles by Kuettner, D. Search for Related Content

Analyzing Supply Chains at HP Using Spreadsheet Models

Emeraldwise, LLC, Woodside, California 94062
Athena Insight, LLC, Menlo Park, California 94025
jamaral{at}emeraldwise.com
dk{at}athenainsight.com

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.

Key Words: computers/computer science; system design/operation; cost analysis; planning; corporate