Computer spreadsheets are widely used for a variety of modelling tasks and provide an interface that is well understood by most users. This paper presents a discrete-event simulation system using a spreadsheet as an input/output device which provides a platform on which to widen the base of simulation users. In an educational setting the system can provide an introduction to the student of the concepts behind the discrete-event method. Once the students grasp these concepts, they are better equipped to construct models using specialised simulation software. In a business setting the system could provide an introduction to the technique to a new set of end-users. A case study of a supermarket system is presented to show how the software can be used in an educational context.
Simulation Study Group.1991 . Simulation in UK Manufacturing Industry, Management Consulting Group.
2.
Greasley, A. and Kerrin, M.1996. "The Use of Simulation Modelling in an Organisational Context." Proceedings of the IASTED/ISMM International Conference on Modelling and Simulation, pp. 224-226.
3.
Schriber, T.J.1995. "How Discrete-Event Simulation Software Works." Proceedings of the 1995 EUROSIM Conference, pp. 17-28.
4.
Hollocks, B.W.1995. "Simulation may be Dangerous— Experimentation Practice and the Implications for Simulation Software." Proceedings of the 1995 EUROSIM Conference, pp. 153-158.
5.
Anthony, S. , and Wilson, J.M.1990. "Manpower Modelling Using a Spreadsheet." OMEGA International Journal of Management Science, 18:5, pp. 505-510.
6.
Armacost, R.L., Penlesky, R.J. and Ross, S.C.1990. "Avoiding Problems Inherent in Spreadsheet-Based Simulation Models: An Aggregate Planning Application ." Production and Inventory Management Journal, Second Quarter, pp. 62-68.
7.
Cornwell, L.W. and Modianos, D.T.1990. "Management Tool: Using Spreadsheets for Simulation Models." Production and Inventory Management Journal, Third Quarter, pp. 8-17.
8.
Leon, L.A. and Przasnyski, Z.H.1995. "Spreadsheet Analysis of Linear Programs with Uncertainty." SIMULATION, 64:2, pp. 113-130.
9.
Parekh, R.1990. "Capacity/Inventory Planning using a Spreadsheet." Production and Inventory Management Journal, First Quarter, pp. 1-3.
10.
Przasnyski, Z.H.1994. "Spreadsheet Simulation Model for Inventory Management." SIMULATION, 63:1, pp. 32-43.
11.
Schuster, E.D. and Finch, B.J.1990. "A Deterministic Spreadsheet Simulation Model for Production Scheduling in a Lumpy Demand Environment." Production and Inventory Management Journal, First Quarter, pp. 39-43.
12.
Seila, A.F. and Banks, J.1990. "Spreadsheet Risk Analysis Using Simulation." SIMULATION, 55:3, pp. 163-169.
13.
Stent, A.F. and McCallum, I.R.1995. "Dynamic Simulation Modelling on a Spreadsheet." SIMULATION, 64:6, pp. 373-379.
14.
Kalaban, K.Y., El-Hajj, A., Diab, H. and Fakhreddine , S.1997. " Analog Computer Simulation Using Spreadsheets." SIMULATION , 68:2, pp. 101-106.
15.
Taylor, G.D. and English, J.R.1996. "Simulation as a Pragmatic Tool for Industrial Engineering Education." Proceedings of the 1996 Summer Computer Simulation Conference, pp. 454-459.
16.
Pidd, M.1984. "Computer Simulation for Operational Research in 1984 ." Developments in Operational Research , edited by R. W. Eglese and G. K. Rand, Pergamon Press, pp. 19-30.
17.
Paul, R.J.1991. "Recent Developments in Simulation Modelling." Journal of the Operational Research Society, 42:3, pp. 217-226.
18.
Davies, R.M. and O'Keefe, R.M.1989. Simulation Modelling with PASCAL, Prentice Hall Ltd.
19.
Thesen, A. and Travis, L.E.1992. Simulation for Decision Making, West Publishing.
