Simulation of Industrial Systems: Discrete Event Simulation Using Excel/VBA (Resource Management)

In any production environment, discrete event simulation is a powerful tool for the analysis, planning, and operating of a manufacturing facility. Operations managers can use simulation to improve their production systems by eliminating bottlenecks, reducing cycle time and cost, and increasing capacity utilization. Offering a hands-on tutorial on how to model traditional applications to optimize production operations, Simulation of Industrial Systems: Discrete Event Simulation Using Excel/VBA— · Introduces the Design Environment for Event Driven Simulation (DEEDS), an original simulator, which facilitates the modeling of complex situations using four (self-contained) nodes: source, queue, facility, and delay. · Demonstrates how to use discrete event simulation as a powerful tool for the analysis, planning, design, and operation of diverse production systems · Shows how to model application areas such as facilities layout, material handling, inventory control, scheduling, maintenance, quality control, and supply chain logistics · Integrates the design of experiments and optimization techniques for improving production systems With the comprehensive instruction provided within these pages, in combination with the flexibility of the DEEDS program environment, operations managers will be able to harness the power of discrete event simulation to streamline their production environments. The authors have created a website with a variety of teaching aids that professors will be able to access Front cover 1 Dedication 6 Contents 8 Preface 16 Acknowledgments 22 The Authors 24 PART I: SIMULATION 26 Chapter 1. Simulation Modeling 28 Chapter 2. Probability and Statistics in Simulation 38 Chapter 3. Elements of Discrete Simulation 62 Chapter 4. Gathering Statistical Observations in Simulation 98 Chapter 5. Ovewview of DEEDS 114 Chapter 6. DEEDS Network Representation 126 PART II: EXCEL/VBA AND DESIGN ENVIRONMENT FOR DISCRETE EVENT SIMULATION 136 Chapter 7. VBA Programming 138 Chapter 8. User Interface 158 Chapter 9. Modeling Procedures 184 Chapter 10. Simulation Output 230 Chapter 11. Analysis of Simulation Results 250 Chapter 12. Modeling Special Effects 262 Chapter 13. Advanced Routing Techniques 284 Chapter 14. Simulation Project Management 306 Chapter 15. Facilities Layout Models 320 Chapter 16. Materials-Handling Models 344 Chapter 17. Inventory Control Models 368 Chapter 18. Scheduling Models 384 Chapter 19. Maintenance and Reliability Models 406 Chapter 20.Quality Control Models 422 Chapter 21. Supply Chain Models 436 Chapter 22. Advanced Analysis Techniques 472 Appendix A: Initializing DEEDS 492 Appendix B: Classes and Procedures 504 Appendix C: Historgrams Using Excel 514 Index 520 Back cover 538 Features the concepts of discrete simulation, covers the design Environment for Event Driven Simulation (DEEDS), and discusses a variety of applications using DEEDS. In this work, the DEEDS research features are demonstrated and genetic algorithm techniques are integrated into the DEEDS environment to produce a powerful tool.