![IEE 475: Simulating Stochastic Systems artwork](https://is4-ssl.mzstatic.com/image/thumb/Features/v4/5f/88/96/5f8896e9-9be5-529a-af14-cc807367568a/mza_1382744875394257421.png/100x100bb.jpg)
Lecture C1 (2021-09-09): Basic Simulation Tools and Techniques
IEE 475: Simulating Stochastic Systems
English - September 09, 2021 20:40Courses Education simulation stochastic des dess discrete event system industrial engineering modeling Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed
In this lecture, we discuss more sophisticated dynamical simulation models that can be implemented within spreadsheets. We start with a review of the M/M/1 single-channel, single-server queueing node and then show how more explicit state variables can be introduced in an M/M/2 version (i.e., with two servers). We then discuss two different popular inventory management models (implemented within a spreadsheet) -- the "Order-up-to (M,N)" model as well as the "newsvendor (single-period/perishable) model". We close with some discussion of Monte Carlo methods -- which apply simulation techniques as numerical methods to solve mathematical problems that might otherwise be intractable analytically. Despite all of these examples of the power of spreadsheets, we end with a hint that much more is possible in terms of simulation of complex systems if we use specialized simulation tools. We will introduce some of those more specialized tools starting in the next lecture.