RedBrand shipping model Range names used

Arc$\_$Capacity $=$Model!$F$$8$:$F$$33$

Inputs Customer$\_$demand $=$Model!$K$$20$:$K$$21$

Common arc capacity $200$ Customer$\_$net$\_$inflow $=$Model!$I$$20$:$I$$21$

Destination $=$Model!$B$$8$:$B$$33$

Network structure, flows, and arc capacity constraints Node balance constraints Flow $=$Model!$D$$8$:$D$$33$

Origin Destination Unit Cost Flow Arc Capacity Plant constraints Origin $=$Model!$A$$8$:$A$$33$

$1250<=200$ Node Plant net outflow Plant capacity Plant$\_$capacity $=$Model!$K$$9$:$K$$11$

$133180<=2001180<=200$ Plant$\_$net$\_$outflow $=$Model!$I$$9$:$I$$11$

$1450<=2002300<=300$ Total$\_$cost $=$Model!$B$$36$

$1550<=2003100<=100$ Unit$\_$Cost $=$Model!$C$$8$:$C$$33$

$16200<=200$ Warehouse$\_$net$\_$outflow $=$Model!$I$$15$:$I$$16$

$17200<=200$ Warehouse constraints

$2190<=200$ Node Warehouse net outflow Required

$2390<=20040=0$

$241120<=20050=0$

$2510<=200$

$268180<=200$ Customer constraints

$27150<=200$ Node Customer net inflow Customer demand

$310\mathrm{.}40<=2006400>=400$

$3280<=2007180>=180$

$34180<=200$

$350\mathrm{.}5200<=200$

$36100<=200$

$37120<=200$

$451\mathrm{.}20<=200$

$462200<=200$

$47120<=200$

$540\mathrm{.}80<=200$

$562200<=200$

$57120<=200$

$671180<=200$

$7670<=200$

Objective to minimize

Total cost $$3,260$

Additional output variable $($for sensitivity analysis$)$

Arcs at capacity $3$