IDEAS home Printed from https://ideas.repec.org/a/inm/orinte/v38y2008i4p300-310.html
   My bibliography  Save this article

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

Author

Listed:
  • Thomas Olavson

    (Hewlett-Packard Company, Palo Alto, California 94304)

  • Chris Fry

    (Strategic Management Solutions, Redwood Shores, California 94065)

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.

Suggested Citation

  • Thomas Olavson & Chris Fry, 2008. "Spreadsheet Decision-Support Tools: Lessons Learned at Hewlett-Packard," Interfaces, INFORMS, vol. 38(4), pages 300-310, August.
    • Handle: RePEc:inm:orinte:v:38:y:2008:i:4:p:300-310
    DOI: 10.1287/inte.1080.0368
    as

    Download full text from publisher

    File URL: http://dx.doi.org/10.1287/inte.1080.0368
    Download Restriction: no
    File URL: https://libkey.io/10.1287/inte.1080.0368?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
    ---><---

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Diana Sánchez-Partida & Rodolfo Rodríguez-Méndez & José Luis Martínez-Flores & Santiago-Omar Caballero-Morales, 2018. "Implementation of Continuous Flow in the Cabinet Process at the Schneider Electric Plant in Tlaxcala, Mexico," Interfaces, INFORMS, vol. 48(6), pages 566-577, November.
    2. Michael F. Gorman, 2016. "From Magnum Opus to Mea Culpa: A Cautionary Tale of Lessons Learned from a Failed Decision Support System," Interfaces, INFORMS, vol. 46(2), pages 183-195, April.
    3. Thomas A. Grossman & Vijay Mehrotra & Mouwafac Sidaoui, 2016. "A Student-Centered Approach to the Business School Management Science Course," INFORMS Transactions on Education, INFORMS, vol. 16(2), pages 42-53, January.

    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:300-310. 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.

    We have no bibliographic references for this item. You can help adding them by using 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.