The following videos show two different approaches for spreadsheet simulation of a single server queueing system:
Spreadsheet Simulation Model - Single Server Queueing System BY MINUTE (Model 1)
In this video, I show the steps to build a spreadsheet simulation model for a Single Server Queueing System with Poisson Arrivals and Exponential Service Times. In this model, we use rows to simulate each MINUTE. This modeling approach is from:
Klein MG, Reinhardt G (2012). Emergency Department Patient Flow Simulations using Spreadsheets. Simulation in Healthcare. 7(1):40-47. DOI: 10.1097/SIH.0b013e3182301005.
Spreadsheet Simulation Model - Single Server Queueing System BY CUSTOMER (Model 2)
In this video, I show a more common approach used to build a spreadsheet simulation model of a Single Server Queueing System with Poisson arrivals and Exponential service times. In this model, we use rows to simulate each CUSTOMER. As a result, the model includes Exponential inter-arrival times and Exponential service times.
The following videos show the steps to create spreadsheet simulation models for the sum of two dice, a call center and a bookstore.
Spreadsheet Simulation for the Sum of Two Dice
Demonstrates how to build a spreadsheet simulation model for the sum of two dice. This spreadsheet simulation model uses the "RAND()" and "VLOOKUP" functions.
Binomial Distribution Spreadsheet Simulation - Call Center Example
Builds a spreadsheet simulation for the call center example using the BINOM.INV formula together with RAND(). The COUNTIF formula is also used to determine the frequency that the desired outcome occurs.
Spreadsheet Simulation with Discrete Empirical Distribution: Calendars for Walton's Bookstore
Using a discrete empirical distribution for calendar demand, we build a spreadsheet simulation model for ordering calendars for Walton's Bookstore. The spreadsheet simulation model uses the VLOOKUP formula together with RAND(). The COUNTIF formula is also used to determine the frequency of different profit/loss outcomes.
Spreadsheet Simulation with Normal Distribution: Calendars for Walton's Bookstore
Using a normal distribution for calendar demand, we build a spreadsheet simulation model for ordering calendars for Walton's Bookstore. The spreadsheet simulation model uses the NORMINV formula together with RAND().
Reviews the steps to build Simio Simulation models for a Driver’s License Office. The simulations model networks of queues with multiple stages. Models of both the current configuration and updated configuration with proposed modifications are provided. These models can help evaluate different changes to the Driver's License Office before implementation.
Simio Simulation - Serial Manufacturing Line
In this example, the Manufacturing Process includes Machining, Grinding and Packaging. Some parts require re-machining and some need to be scrapped after grinding. Steps are also included to show how to create Experiment Responses and view the corresponding Simio Measure of Risk and Error (SMORE) Plots. Five responses are included: Machine Utilization (MUtil), Grind Utilization (GUtil), Package Utilization (PUtil), Time in System (TIS) and Number in System (NIS).
Simio Simulation - Healthcare Clinic
This example demonstrates routing entities with sequences and the "free space" travel mode. The clinic includes the following stations/offices: registration, triage, treatment, lab, x-ray, MRI, EKG and Accounting. Five different patient types are considered: walk-in, lab only, x-ray, MRI and EKG with routing sequence tables created for each patient type. Symbols for the entities are set to different people to represent different patient types and the healthcare clinic is simulated in 3D mode.
Simio Simulation - Hot Dog Stand with Time-Varying Arrivals
This example includes time-varying arrivals, time-varying staffing and queueing behavior (balking and reneging). In Simio, time-varying arrivals are modeled with rate tables and time-varying staffing is modeled with work schedules. The steps to create animation plots are also included. The busy lunch period is animated using the status plots to visualize the impact of having time-varying staffing with two servers rather than one during the busy lunch period.
Simio Simulation with Vehicles
Reviews the steps to build a Simio Simulation model with Vehicles, including three methods to change vehicle capacity.
Simio Simulation with Conveyors
Reviews the steps to build a Simio Simulation model with Conveyors. The model includes a merge point with different speeds for different segments of the conveyor.
Reviews the simple moving average forecasting method. Also includes graphing actual demand and forecasts, plus calculations for Mean Absolute Deviation (MAD) and Mean Squared Error (MSE).
Forecasting - Weighted Moving Average
Reviews the weighted moving average forecasting method. Also includes graphing actual demand and forecasts, plus calculations for Mean Absolute Deviation (MAD) and Mean Squared Error (MSE).
Forecasting - Simple Exponential Smoothing
Reviews the Simple Exponential Smoothing forecasting method. Also includes graphing actual demand and forecasts, plus calculations for Mean Absolute Deviation (MAD) and Mean Squared Error (MSE).
Forecasting - Holt's Method
Reviews Holt's forecasting method. Also includes graphing actual demand and forecasts, plus calculations for Mean Absolute Deviation (MAD) and Mean Squared Error (MSE).
Reviews the steps to set up a linear optimization model in an Excel spreadsheet and use the Solver Add-in to find the optimal solution.
Transportation Problem - Excel Solver
Reviews the steps to set up a linear optimization model of the transportation problem in an Excel spreadsheet and use the Solver Add-in to find the optimal solution.
