SCM (4): Mixed integer linear programming | Network optimization models for demand allocation

Mixed integer linear programming for network optimization problems of demand allocation to production facilities. The case of HighOptic, TelecomOne and TelecomOptic from the Supply Chain Management book by Chopra and Meindl.
#SupplyChain #NetworkOptimization #DemandAllocation #ExcelSolver #MILP #ResearchHUB
.
Published papers using optimization methods:
.
.
Join the ResearchHUB Community:
.
Follow the RHUB Founder:

[kunjinjaalamohammedaminhil]

Hi, thanks for these videos. The book that you are referring to, can we have a link to the online version, please...

[lucarioAK]

thanks, could you provide the link to the excel file.

[sergiomensitieri]

Could you suggest a textbook where i can find exaples regardi

[sidkuppa]

I cannot find the excel files used in the video

[carlwilliams]

Question 1: How would the network design obtained in Activity 3 change if a new constraint is introduced which states that all five plants must stay open? Run this in solver and obtain the new production allocation. Attach the input and output tables as image files to your report and explain your observations.
Question 2: Is there a major difference in total cost between the optimal network design for TelecomOne and HighOptic individually (see activity 2), for TelcomOptic (see activity 3), and for the design requiring all the TelecomOptic plants to remain open (your answer to above Question 1)? What is another way to determine whether this is an efficient solution or not? Attach the input and output tables as image files to your report and explain your observations.

[v.gedace]

Really? A 360p video in 2020? So, we should feel lucky that the video is not in black and white?