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.

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