Solving the Capacitated Facility Location Model $($Fixed Charge Problem$)$ in Excel

TOTAL : $1$ COSTS AND Capacities input data

TOTAL : $1$ COSTS AND Capacities

Warehouses total logistics cost $($TL$/$UNIT$)$ FIXED COST$/$ TL$/$YEAR warehouse capac$$ty

Ayval$$k Edremit

Ayval$$k factory warehouses $11796\mathrm{.}200\mathrm{.}0007\mathrm{.}050\mathrm{.}000$

K$$kk$$y $16464\mathrm{.}900\mathrm{.}0004\mathrm{.}500\mathrm{.}000$

Alt$$nova $16297\mathrm{.}800\mathrm{.}0005\mathrm{.}750\mathrm{.}000$

Edrem$$t factory warehouses $82144\mathrm{.}400\mathrm{.}0003\mathrm{.}300\mathrm{.}000$

Burhaniye $38176\mathrm{.}100\mathrm{.}0002\mathrm{.}250\mathrm{.}000$

Alt$$noluk $54324\mathrm{.}200\mathrm{.}0003\mathrm{.}150\mathrm{.}000$

Total Product storage Requirement $18\mathrm{.}250\mathrm{.}0002\mathrm{.}750\mathrm{.}000$

decision variables: x$\_$ij quantity shipped from warehouses I to market j

y$\_$i: open facility in city I ; yes open ;$0$ no do not open

Warehouses total logistics cost $($TL$/$UNIT$)$ open facility I YES $/$NO sum of production at each location

Ayval$$k Edremit

Ayval$$k factory warehouses

K$$kk$$y

Alt$$nova

Edrem$$t factory warehouses

Burhaniye

Alt$$noluk

constraints

Warehouses total logistics cost $($TL$/$UNIT$)$

Ayval$$k Edremit

Ayval$$k factory warehouses

K$$kk$$y

Alt$$nova

Edrem$$t factory warehouses

Burhaniye

Alt$$noluk

Total Product storage Requirement $0$

$18\mathrm{.}250\mathrm{.}0002\mathrm{.}750\mathrm{.}000$

OBJECTIVE FUNCTION $=$ FIXED COST $+$VARIBALE COSTinput data

TOTAL : $1$ COSTS AND Capacities please solve us excel