Spreadsheet Decision-Support Tools: Lessons Learned at Hewlett-Packard

Thomas Olavson () and Chris Fry ()
Additional contact information
Thomas Olavson: Hewlett-Packard Company, Palo Alto, California 94304
Chris Fry: Strategic Management Solutions, Redwood Shores, California 94065

Interfaces, 2008, vol. 38, issue 4, 300-310

Abstract: Spreadsheet tools are an inexpensive and flexible way to provide analytical support for repeated decisions. However, good modeling and analysis alone are not enough to create an effective tool. Using examples from Hewlett-Packard in forecasting, planning, procurement, and product management, we discuss lessons learned for creating reusable spreadsheet tools to support fact-based decision making. These lessons pertain to the entire life cycle of tool development: Before starting development, what role should analytics play in solving your business problem? Is a spreadsheet tool an appropriate solution? During development, are you partnering with end users to discover key insights and building a simple tool to capture those insights without unneeded complexity? Can you develop an OR champion in the process? When handing off a tool, are you providing a complete solution including roles and responsibilities, processes, and metrics? Ensuring that spreadsheet tools have maximum impact in an organization requires smart decision making before the first prototype is drafted, customer-focused management during development, and a complete handoff to users.

Keywords: spreadsheets; philosophy of modeling; OR/MS implementation; inventory/production; supply contracts; forecasting; product policy; cost analysis (search for similar items in EconPapers)
Date: 2008
References: Add references at CitEc
Citations: View citations in EconPapers (3)

Downloads: (external link)
http://dx.doi.org/10.1287/inte.1080.0368 (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:300-310

Access Statistics for this article

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