Integer Programming: Fixed Costs and Linking of Variables (Facility Location) with Excel Solver

Enjoyed this content & want to support my channel? You can get the spreadsheet I build in the video or buy me a coffee! Links below:

Buy me a coffee: https://www.buymeacoffee.com/tallysyunes
Buy complete spreadsheet: https://www.buymeacoffee.com/tallysyu...
Buy me an item from my wishlist: https://www.buymeacoffee.com/tallysyu...

Given potential locations for opening facilities and target markets that can be served by these facilities, decide which facilities to open and how much of each market's demand to serve out of each open facility in order to minimize your total cost. The cost has two components: fixed costs of opening the facilities and variable costs of serving the demand out of each open facility. In this video we also learn about the need for linking variables representing decisions that are related to each other, and how to implement this linkage mathematically and in Excel.