Simulate truck transport time - Microsoft Excel Tutorial

Contents

• Introduction Introduction

  • Analyze supply chain shipping scenarios

    35s
  • (Locked)
    What you should know

    1m 30s
• 1. Simulating Ocean Shipping 1. Simulating Ocean Shipping

  • (Locked)
    Transport goods over the ocean

    3m 18s
  • (Locked)
    Track a container's journey across the ocean

    2m 44s
  • (Locked)
    Model sailing time

    7m 50s
  • (Locked)
    Model wait time at the port

    5m 23s
  • Model unloading and customs time

    8m 22s
• 2. Simulating Land Transport to Warehouses 2. Simulating Land Transport to Warehouses

  • (Locked)
    Review land transport options

    5m 10s
  • (Locked)
    Compare rail and truck transport

    6m 16s
  • Simulate rail transport time

    5m 41s
  • (Locked)
    Simulate truck transport time

    5m 16s
  • (Locked)
    Analyze rail and truck transport time

    11m 4s
• 3. Projecting Warehouse and Store Inventory 3. Projecting Warehouse and Store Inventory

  • (Locked)
    Describe inventory reorder policies

    2m 53s
  • (Locked)
    Aggregate store inventories at the regional level

    8m 3s
  • (Locked)
    Calculate safety stock level based on level of service

    4m 42s
  • (Locked)
    Examine the impact of inaccurate demand forecasting

    3m 58s
  • (Locked)
    Minimize the bullwhip effect

    3m 10s
• 4. Creating an Integrated Solution Workbook 4. Creating an Integrated Solution Workbook

  • (Locked)
    Review the solution workbook

    3m 27s
  • (Locked)
    Combine modules into an integrated solution

    10m 27s
  • (Locked)
    Add known delays at each step

    3m 21s
  • (Locked)
    Create and run multiple simulations

    8m 32s
• 5. Simulating Local Delivery Routes 5. Simulating Local Delivery Routes

  • (Locked)
    Describe the local delivery problem

    4m 33s
  • (Locked)
    Organize the simulation worksheet

    4m 26s
  • (Locked)
    Define and run the Solver model

    7m 4s
  • (Locked)
    Explore scenarios using the Solver model

    7m 40s
• Conclusion Conclusion

  • (Locked)
    Next steps

    1m 48s