Modeling and Simulation of Logistics Flows : Dashboards, Traffic Planning and Management

Cover -- Title Page -- Copyright -- Contents -- About This Book -- Intended public -- Organization and contents of the book -- Conventions -- Vocabulary and definition -- Acknowledgments -- Introduction -- I.1. Logistics, information systems and software -- 1. Operational Research Using a Spreadsheet -- 1.1. Foreword -- 1.2. Dynamic programming -- 1.3. Scheduling -- 1.3.1. Critical path calculation matrix -- 1.3.2. Classic Gantt chart -- 1.3.3. Gantt chart with a calendar -- 1.4. Maximal flows -- 1.5. Transport model -- 1.5.1. Customer delivery -- 1.5.2. Minimum-cost transport -- 1.6. Linear programming -- 1.6.1. Creating a calculation table -- 1.6.2. Entering data -- 1.6.3. Using the solver -- 2. Dashboards, Spreadsheets and Pivot Tables -- 2.1. Spreadsheets: a versatile tool -- 2.2. Example database -- 2.2.1. Calculated field and formatting -- 2.2.2. Calendar sections, rankings and averages -- 2.2.3. Conditional calculated fields -- 2.2.4. Slicers, filtering and calculated fields -- 2.2.5. Calculated items -- 2.3. Multiple databases -- 2.3.1. New tables for the database -- 2.3.2. Creating data tables -- 2.3.3. Relationships between tables -- 2.3.4. Using multiple tables to create a pivot table -- 2.4. Limits and constraints with calculated fields -- 2.5. Conclusion -- 3. Scheduling and Planning Using a Project Manager -- 3.1. Reminders and information -- 3.2. Example: designing and building a machine-tool -- 3.2.1. Scenario -- 3.2.2. Creating and configuring the project -- 3.2.3. Entering tasks and durations -- 3.2.4. Entering predecessors -- 3.2.5. MPM network visualization -- 3.2.6. Calculating slacks -- 3.2.7. Entering resources -- 3.2.8. Allocating resources -- 3.2.9. Resolving over-allocations -- 3.2.10. Viewing the project timeline -- 3.2.11. Using WBS coding -- 3.2.12. Generating dashboards and reports -- 3.3. Project monitoring.