Welcome to the homepage for
Process Simulation with Excel
Mendoza College of Business
University of Notre Dame
Prentice Hall 2004
SimQuick is an Excel spreadsheet (with some macros) that allows the user to model and simulate simple processes:
- Waiting lines (e.g., banks, fast-food restaurants, call centers).
- Inventory and supply chains (e.g., stores, warehouses, and simple combinations of these).
- Manufacturing (e.g., assembly lines, batch processes, simple job shops)
- Projects with uncertain task times.
SimQuick requires no “installation.” It’s just an Excel file. If you have a PC (stand-alone or networked) with Excel 2003, 2007, or 2010 (under any version of Windows), then you can immediately use SimQuick.
SimQuick is accompanied by a 115 page booklet (shown above) that introduces the technique of process simulation through realistic examples and exercises that utilize SimQuick.
SimQuick is designed to be easy to learn and use: A wide variety of processes can be modeled after an hour of class time or independent reading.
SimQuick has been used by a number of companies and by at least 40 colleges and universities, typically as a supplement to an Operations Management or Decision Science course.
The SimQuick software with booklet currently costs about $20 per copy.
Excerpts from the booklet:
Read an article about SimQuick and how it works in
SimQuick is discussed, in detail, in the following textbooks:
Operations Management, Processes and Supply Chains, 9th Edition by L.J. Krajewski, L.P. Ritzman, and M.K. Malhotra; Prentice Hall, 2010.
Successful Service Operations Management, 2nd Edition by R. Metters, K. King-Metters, M. Pullman, and S. Walton; Thomson, South-Western, 2006.
Statistics, Data Analysis, & Decision Modeling, 5th Edition by J.R. Evans; Prentice Hall, 2013.
Introduction to Operations and Supply Chain Management, 2nd Edition by C.C. Bozarth and R.B. Handfield; Prentice Hall, 2008
Advanced Decision Support Tools by C.C. Bozarth; Prentice Hall, 2006.
SimQuick was reviewed in Interfaces, Vol 32, No. 5, Sept.-Oct. 2002 by J.K. Visich:
"... as a pedagogical tool for introducing the basics of simulation, SimQuick is an outstanding workbook and software package. A student with a basic understanding of Excel should be able to build and analyze simulation models with little to no help from the instructor."
To order SimQuick:
Links to the world of simulation: