Performance Evaluation of Industrial Systems Discrete Event Simulation in Using Excel/VBA, Second Edition

SIMULATION FUNDAMENTALS

Simulation Modeling
Why Simulate
Types of Simulation
The Simulation Clock
Randomness in Simulation
Discrete Simulation Languages
Design Environment for Event Driven Simulation (DEEDS)
The Two Sides of Simulation
Organization of this Book
Selected References
Problems

Probability and Statistics In Simulation
Role of Probability and Statistics in Simulation
Characterization of Common Distributions in Simulation
Statistical Output Analysis
Summary
Selected References
Problems

Elements of Discrete Simulation
Concept of Events in Simulation
Common Simulation Approaches
Computations of Random Deviates
Collecting Data in Simulation
Summary
Selected References
Problems

Gathering Statistical Observations in Simulation
Introduction
Peculiarities of the Simulation Experiment
Accounting for the Peculiarities of the Simulation Experiment
Methods of Gathering Simulation Observations
Variance Reduction Technique
Summary
Selected References
Problems

Overview of Deeds
Introduction
Modeling Philosophy
Basic Elements
Basic Features
Develop and Execute a Model
Summary

Network Representation
Components of the Model
Program Initial Conditions
Summary
Problems
ExcelNBA and Design Environment for Discrete Event Simulation

VBA
Introduction
Visual Basic Names
VBA Data Types
Variable Definitions
Constants
Expressions
Assignment Statements
Control Structures
Procedures
Arrays
Summary
Selected References
Problems

User Interface
Introduction
Overview of Program Manager
Source Nodes
Queue Nodes
Facility Nodes
Initial Model
Delay Nodes
Statistical Variables
User Defined Probability Distribution Functions
User Defined Tables
Program Execution Expanded
Summary
Problems

Modeling Procedures
Introduction
VIBA Procedures
Simulator Procedures
DEEDS Classes
Distribution Functions
Visual Basic Functions
Excel WorkSheetFunctions
Summary
Problems

Simulation Output
Introduction
Gathering Observations
Simulation Messages
Monitoring Simulation During Execution
Forced Model Tennination
Standard Output
Model Verification
Interactive Debugger
Summary
Selected References
Problems

Analysis of Simulation Results
Introduction
Effect of Transient State
Gathering Statistical Observations
Establish Confidence Intervals
Hypothesis Testing in Simulation Experiments
Summary

Model Visualization
Introduction
Visualization Philosophy
Basic Features
Develop and Execute Models
Summary

Modeling Special Effects
Introduction
A Multi-server Facility to Represent Indepeudent Facilities
Facility Preemption Operation
Limit on Waiting Time in Queues
Time-Dependent Inter-Creation Time at a Source
Network Logic Change Using Queue Nodes
Controlled Blockage of a Facility
Assemble and Match Sets with Common Queues
Jackson Networks
Sampling Without Replacement
Summary

Advanced Routing Techniques
Introduction
Routing Transactions
Synchronized Queues
Assemble Transactions
Summary
Selected References
Problems

APPLICATIONS

Model Design and Development
Introduction
System Specification
Simulation Constants, Decision Variables, and Constraints
Data Specifications
Project Management
Summary

Facilities Layout Models
Introduction
Facilities Management
Line Balancing Model
AGVS and Flexible Manufacturing

Material Handling Models
Introduction
Transporter Car
Overhead Crane
Carousel Conveyor
Belt Conveyor Plywood Mill Operation
Summary

Inventory Control Models
Introduction
Discount Store Model
Periodic Review Model
Continuous Review Model
Summary

Scheduling Models
Introduction
Job Shop Scheduling
PERT Project Scheduling
Daily Manpower Allocation
Summary

Maintenance Models
Introduction
General Reliability Model
Maintenance Planning Model
Summary

Quality Control Models
Introduction
Inspection Process Model
Control Chart Model
Summary

Supply Chain Logistics Models
Introduction
POIt Operation Model
Automatic Warehouse Operation
Cross Dock Model
Summary

ANALYSIS OF LARGE SCALE MODELS

Introduction
Evaluation of Alternatives
Design of Experiments
Genetic Algorithms
Summary

Appendix A: DEEDS AddIn Installation
Appendix B: Simulator Quick Guide
Appendix C: Histograms with Excel

Biography

David Elizandro, Tennessee Tech University

Hamdy Taha, University of Arkansas