Modeling and Simulation of Logistics Flows 2

Jean-Michel Réveillac is a consultant-adviser and lecturer for large companies. He currently teaches at the University of Burgundy, and CNAM in France and at IGA in Morocco.

About This Book ix

Introduction xv

Chapter 1 Operational Research Using a Spreadsheet 1

1.1 Foreword 1

1.2 Dynamic programming 1

1.3 Scheduling 6

1.3.1 Critical path calculation matrix 7

1.3.2 Classic Gantt chart 11

1.3.3 Gantt chart with a calendar 17

1.4 Maximal flows 23

1.5 Transport model 29

1.5.1 Customer delivery 30

1.5.2 Minimum-cost transport 33

1.6 Linear programming 36

1.6.1 Creating a calculation table 36

1.6.2 Entering data 37

1.6.3 Using the solver 38

Chapter 2 Dashboards, Spreadsheets and Pivot Tables 41

2.1 Spreadsheets: a versatile tool 41

2.2 Example database 42

2.2.1 Calculated field and formatting 43

2.2.2 Calendar sections, rankings and averages 47

2.2.3 Conditional calculated fields 50

2.2.4 Slicers, filtering and calculated fields 53

2.2.5 Calculated items 58

2.3 Multiple databases 61

2.3.1 New tables for the database 62

2.3.2 Creating data tables 64

2.3.3 Relationships between tables 65

2.3.4 Using multiple tables to create a pivot table 67

2.4 Limits and constraints with calculated fields 69

2.5 Conclusion 72

Chapter 3 Scheduling and Planning Using a Project Manager 73

3.1 Reminders and information 73

3.2 Example: designing and building a machine-tool 74

3.2.1 Scenario 74

3.2.2 Creating and configuring the project 77

3.2.3 Entering tasks and durations 80

3.2.4 Entering predecessors 81

3.2.5 MPM network visualization 82

3.2.6 Calculating slacks 83

3.2.7 Entering resources 84

3.2.8 Allocating resources 86

3.2.9 Resolving over-allocations 88

3.2.10 Viewing the project timeline 92

3.2.11 Using WBS coding 92

3.2.12 Generating dashboards and reports 94

3.3 Project monitoring 97

3.4 Conclusion 99

Chapter 4 Road Traffic Simulation 101

4.1 Before we start 101

4.2 Ring road 102

4.2.1 A simulation example 103

4.3 RoadTrafficSimulator 104

4.3.1 Constructing a model 106

4.3.2 Activating the simulation from the model 108

4.4 Intersection simulator 109

4.5 Green Light District (GLD) 115

4.5.1 GLD compilation 116

4.5.2 Launching the GLD 117

4.5.3 The editor toolbar 119

4.5.4 An example using GLD 121

4.6 AnyLogic 144

4.6.1 Downloading AnyLogic 144

4.6.2 Our example 145

4.6.3 A last word on AnyLogic 165

4.7 Conclusion 165

Conclusion 167

Appendices 171

Appendix 1 173

Appendix 2 181

Glossary 187

Bibliography 193

Index 201