The worksheets in this spreadsheet implement the simple queueing models described
in Chapter 6 of Banks, Carson, Nelson and Nicol, Discrete-Event System Simulation,
5th edition.
Some important notes:
0. Go to the worksheet with the desired model.
1. Make

Queuing
Models
(Waiting
Lines)
1
Introduction (1/2)
Queuing is the study of waiting lines, or
queues.
The objective of queuing analysis is to
design systems that enable organizations to
perform optimally according to some
criterion.
Possible Criteria

Queuing models practice questions-part 2
Q1. Customers arrive at an automated coffee vending machine at a rate of 4 per minute, following a
Poisson distribution. The coffee machine dispenses a cup of coffee at a constant rate of 10 seconds.
(a) What is th

LP Model
Developing a LP Model
All LP models can be viewed in terms of the three distinct steps
1. Formulation of simple mathematical expressions
2. Solution to identify an optimal (or best) solution to the model
3. Interpretation of the results and answe

Excel Solver Summary
Target cell: a cell on the spreadsheet which computes a quantity you want to make as big
(or small) as possible. Examples: profit, cost
Changing cells: the Solver will substitute values into these cells until it finds the values
that

Regular
Total
Resources
Available
Deluxe
Labor - (Hrs)
Material - (Sq.m)
1
5
2
6
Profit per unit
5
8
Solution
# of units, Regular
# of units, Deluxe
Objective: Maximize profits =
160
600
Actual
Values
0
0