Excel: Supply Chain Shipping Analysis
2h 17mIntermediate2024-11-21
Authors
Curt Frye
President of Technology and Society, Incorporated
Course details
Microsoft Excel is one of the world’s most widely used spreadsheet applications, and for good reason. It’s an essential everyday tool if you work in logistics and shipping, or are interested in landing a role in the field. In this course, instructor Curt Frye covers advanced Excel skills for performing supply chain shipping analysis, including shipping modes and costs, logistics and transportation networks, distribution, inventory management, route creation and evaluation with the Solver model, and more. By the end of this course, you’ll be prepared to evaluate complex shipping scenarios to make informed data-driven business decisions.
Learning objectives
Identify shipping simulation problems.
Create models to represent shipping scenarios.
Develop worksheets to implement shipping scenario models.
Integrate simulation modules into solutions.
Build workbooks to run and analyze multiple complex shipping scenarios.
Learning objectives
Identify shipping simulation problems.
Create models to represent shipping scenarios.
Develop worksheets to implement shipping scenario models.
Integrate simulation modules into solutions.
Build workbooks to run and analyze multiple complex shipping scenarios.
Skills covered
Supply Chain ManagementSpreadsheetsMicrosoft ExcelBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftOne-Off
Concepts
0. Introduction
- 01 - Analyze supply chain shipping scenarios
- 02 - What you should know
1. Simulating Ocean Shipping
- 03 - Transport goods over the ocean
- 04 - Track a container's journey across the ocean
- 05 - Model sailing time
- 06 - Model wait time at the port
- 07 - Model unloading and customs time
2. Simulating Land Transport to Warehouses
- 08 - Review land transport options
- 09 - Compare rail and truck transport
- 10 - Simulate rail transport time
- 11 - Simulate truck transport time
- 12 - Analyze rail and truck transport time
3. Projecting Warehouse and Store Inventory
- 13 - Describe inventory reorder policies
- 14 - Aggregate store inventories at the regional level
- 15 - Calculate safety stock level based on level of service
- 16 - Examine the impact of inaccurate demand forecasting
- 17 - Minimize the bullwhip effect
4. Creating an Integrated Solution Workbook
- 18 - Review the solution workbook
- 19 - Combine modules into an integrated solution
- 20 - Add known delays at each step
- 21 - Create and run multiple simulations
5. Simulating Local Delivery Routes
- 22 - Describe the local delivery problem
- 23 - Organize the simulation worksheet
- 24 - Define and run the Solver model
- 25 - Explore scenarios using the Solver model
Conclusion
- 26 - Next steps