Spreadsheets in Operations Management Modeling: IBM Research Experience

Many academics and practitioners have found spreadsheets to be a viable platform for quantitative analysis of supply chain related problems. This paper will give an IBM Research account of the way spreadsheets have been helping us in our projects. We will briefly describe a number of projects that benefitted from the use of spreadsheets. For each project, we will mention the reasons and considerations that led to the choice of spreadsheet usage, and explain how this choice impacted the success of the project. We will summarize the lessons learned and try to put them in perspective as to when and how spreadsheets can be used under different circumstances. We will give a prescriptive view of what factors to consider, what questions to ask, what advantages/disadvantages and weaknesses/strengths to consider about the use spreadsheets. We will do this from both technical and business perspectives.

By: Sheneeta W. White; Kaan Katircioglu; Tarun Kumar

Published in: RC24041 in 2006


This Research Report is available. This report has been submitted for publication outside of IBM and will probably be copyrighted if accepted for publication. It has been issued as a Research Report for early dissemination of its contents. In view of the transfer of copyright to the outside publisher, its distribution outside of IBM prior to publication should be limited to peer communications and specific requests. After outside publication, requests should be filled only by reprints or legally obtained copies of the article (e.g., payment of royalties). I have read and understand this notice and am a member of the scientific community outside or inside of IBM seeking a single copy only.


Questions about this service can be mailed to reports@us.ibm.com .