Management Science 101: Deliver2You Product Logistics and Distribution using Excel

In this video, I walk you through how to set up and solve a logistics problem in Microsoft Excel using the Solver Add-In. The goal is to utilize the firm's shipping lanes in a manner that minimizes shipping costs while meeting warehouse demand. However, the shipping arcs in this problem carry capacity constraints. Some product ships direct and some product passes through a distribution center. It will be our job to meet those constraints at the lowest possible cost.

My playlist table of contents, Video Companion Guide PDF documents, and file downloads can be found on my website: https://www.bcfoltz.com

This problem comes from the book "Introduction to Management Science 3/e" by Hiller and Hiller.

• #education
• #exel_logistics
• #excel_logistic
• #logistics_in_excel
• #excel_for_logistics
• #excel_in_logistics
• #excel_logistics
• #deliver2you
• #logistics_excel
• #supply_chain_management_excel
• #supply_chain_excel
• #logistic_excel
• #workforce_management_training
• #workforce_management
• #logistics_analyst
• #microsoft_excel
• #microsoft_excel_software
• #transportation_problem
• #excel
• #statistics_101
• #anova
• #logistics
• #linear_programming
• #distribution_and_logistics_management
• #logistic_regression
• #management