Close window

Formulas included in the Operations Managment Spreadsheet

Inventory Management
Average Inventory
Economic Order Quantity
Reorder Point
Total Carrying Cost
Total Inventory Cost
Total Ordering Cost

Queueing Theory (Single Server)
Average Number of Customers in Queue
Average Number of Customers in the System
Average Time that a Customer spends in Queue
Average Time that a Customer spends in System
Economic Analysis
Probability that exactly n Customers are in System
Probability that No Customers are in System
Probability that the Server is Busy (there are customers)

Queueing Theory (Multiple Servers)
Average Number of Customers in Queue
Average Number of Customers in the System
Average Time that a Customer spends in Queue
Average Time that a Customer spends in System
Economic Analysis
Probability that an Arriving Customer Must Wait
Probability that exactly n Customers are in System
Probability that No Customers are in System
Probability that the Server is Busy (there are customers)

Here is a sample image of what a portion of the Operations Managment Spreadsheet looks like:

Click to close this window