Excel Supply Chain Analysis - Solving Transportation Problems

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 01 - Introduction
• 01 - Solve supply chain transportation problems with Excel.mp4 (3.1 MB)
• 01 - Solve supply chain transportation problems with Excel.srt (1.0 KB)
• 02 - What you should know.mp4 (3.8 MB)
• 02 - What you should know.srt (3.2 KB)
02 - 1. Solving a Transportation Problem
• 01 - Describe the transportation problem.mp4 (4.1 MB)
• 01 - Describe the transportation problem.srt (3.7 KB)
• 02 - Outline a transportation model in Excel.mp4 (9.8 MB)
• 02 - Outline a transportation model in Excel.srt (6.0 KB)
• 03 - Define decision variables, constraints, and total cost.mp4 (9.3 MB)
• 03 - Define decision variables, constraints, and total cost.srt (5.2 KB)
• 04 - Create and run the Solver model.mp4 (12.4 MB)
• 04 - Create and run the Solver model.srt (6.5 KB)
03 - 2. Solving a Transshipment Problem
• 01 - Describe the transshipment problem.mp4 (4.4 MB)
• 01 - Describe the transshipment problem.srt (3.6 KB)
• 02 - Outline a transshipment problem in Excel.mp4 (13.4 MB)
• 02 - Outline a transshipment problem in Excel.srt (7.5 KB)
• 03 - Define decision variables, constraints, and total cost.mp4 (21.5 MB)
• 03 - Define decision variables, constraints, and total cost.srt (11.7 KB)
• 04 - Create and run the Solver model.mp4 (17.6 MB)
• 04 - Create and run the Solver model.srt (9.1 KB)
• 05 - Evaluate a Solver solution.mp4 (11.6 MB)
• 05 - Evaluate a Solver solution.srt (6.5 KB)
04 - 3. Analyzing Fixed Costs and Facility Opening Decisions
• 01 - Describe fixed cost and facility opening problems.mp4 (4.9 MB)
• 01 - Describe fixed cost and facility opening problems.srt (4.3 KB)
• 02 - Outline a linking constraint problem in Excel.mp4 (20.6 MB)
• 02 - Outline a linking constraint problem in Excel.srt (10.7 KB)
• 03 - Implement linking constraints in Excel.mp4 (9.7 MB)
• 03 - Implement linking constraints in Excel.srt (5.4 KB)
• 04 - Create and run the Solver model.mp4 (16.7 MB)
• 04 - Create and run the Solver model.srt (8.3 KB)
05 - 4. Enforcing Level of Service Constraints
• 01 - Describe level of service constraints.mp4 (3.9 MB)
• 01 - Describe level of service constraints.srt (3.4 KB)
• 02 - Outline level of service constraint analysis in Excel.mp4 (14.8 MB)
• 02 - Outline level of service constraint analysis in Excel.srt (8.1 KB)
• 03 - Calculate level of service metrics.mp4 (15.1 MB)
• 03 - Calculate level of service metrics.srt (8.4 KB)
• 04 - Create and run the Solver model.mp4 (17.0 MB)
• 04 - Create and run the Solver model.srt (9.2 KB)
06 - 5. Practicing Transportation Problem Analysis
• 01 - Challenge Analyze a transportation problem.mp4 (2.7 MB)
• 01 - Challenge Analyze a transportation problem.srt (2.0 KB)
• 02 - Solution Analyze a transportation problem.mp4 (18.3 MB)
• 02 - Solution Analyze a transportation problem.srt (9.7 KB)
• 03 - Challenge Analyze a transshipment problem.mp4 (4.3 MB)
• 03 - Challenge Analyze a transshipment problem.srt (3.1 KB)
• 04 - Solution Analyze a transshipment problem.mp4 (26.2 MB)
• 04 - Solution Analyze a transshipment problem.srt (12.7 KB)
• 05 - Challenge Which distribution centers to open.mp4 (4.0 MB)
• 05 - Challenge Which distribution centers to open.srt (3.0 KB)
• 06 - Solution Which distribution centers to open.mp4 (27.0 MB)
• 06 - Solution Which distribution centers to open.srt (14.0 KB)
• 07 - Challenge Level of service constraints problem.mp4 (3.7 MB)
• 07 - Challenge Level of service constraints problem.srt (3.1 KB)
• 08 - Solution Level of service constraints problem.mp4 (26.5 MB)
• 08 - Solution Level of service constraints problem.srt (13.9 KB)
07 - 6. Extending Your Transportation Analysis
• 01 - Change parameters by hand.mp4 (14.2 MB)
• 01 - Change parameters by hand.srt (6.7 KB)
• 02 - Adjust distances using factors.mp4 (10.6 MB)
• 02 - Adjust distances using factors.srt (5.6 KB)
• 03 - Explore extreme scenarios.mp4 (21.2 MB)
• 03 - Explore extreme scenarios.srt (9.9 KB)
• 04 - Find solutions based on a target cost.mp4 (15.3 MB)
• 04 - Find solutions based on a target cost.srt (6.9 KB)
• 05 - Perform sensitivity analysis.mp4 (25.9 MB)
• 05 - Perform sensitivity analysis.srt (12.7 KB)
08 - Conclusion
• 01 - Next steps.mp4 (1.9 MB)
• 01 - Next steps.srt (2.2 KB)
• Bonus Resources.txt (0.1 KB)
Ex_Files_Excel_Supply_Chain_2024 Exercise Files Chapter01
• 01_02_Outline.xlsx (10.5 KB)
• 01_03_Summary.xlsx (11.8 KB)
• 01_04_Solved.xlsx (12.0 KB)
Chapter02
• 02_02_Outline.xlsx (10.9 KB)
• 02_03_Summary.xlsx (11.2 KB)
• 02_04_Solved.xlsx (11.8 KB)
• 02_05_FactoryShipping.xlsx (11.3 KB)
• 02_05_Transshipment.xlsx (12.0 KB)
Chapter03
• 03_02_Outline.xlsx (12.1 KB)
• 03_03_Linking.xlsx (12.8 KB)
• 03_04_Solved.xlsx (12.9 KB)
Chapter04
• 04_02_Outline.xlsx (12.0 KB)
• 04_03_LevelOfService.xlsx (12.4 KB)
• 04_04_Solved.xlsx (13.0 KB)
Chapter05
• 05_02_Transportation.xlsx (11.8 KB)
• 05_04_Transshipment.xlsx (12.4 KB)
• 05_06_OpenOrClose.xlsx (12.0 KB)
• 05_08_LevelOfService.xlsx (11.9 KB)
Chapter06
• 06_01_ChangeValues.xlsx (12.9 KB)
• 06_02_DistanceFactors.xlsx (12.8 KB)
• 06_03_ExtremeScenarios.xlsx (13.0 KB)
• 06_04_TargetCost.xlsx (12.9 KB)
• 06_05_SensitivityAnalysis.xlsx (12.9 KB)