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 HighWire Citing Articles via Google Scholar Google Scholar Articles by Olavson, T. Articles by Fry, C. Search for Related Content

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

Hewlett-Packard Company, Palo Alto, California 94304
Strategic Management Solutions, Redwood Shores, California 94065
thomas.olavson{at}hp.com
chris{at}strategicmgmtsolutions.com

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.

Key Words: spreadsheets; philosophy of modeling; OR/MS implementation; inventory/production; supply contracts; forecasting; product policy; cost analysis

This article has been cited by other articles:

				J. D. Camm From the Editor: Is Interfaces Meeting Its Mission? Interfaces, July 1, 2009; 39(4): 305 - 306. [Abstract] [PDF]