$[$Hint: You need to build a facility location model in your spreadsheet, following the steps of the lessons. To check your spreadsheet, try setting each decision variable $($the flow on each of the $40$ arcs and the five binary open$-$or$-$not variables$)=1.$ Your total cost should be $500,199.$ If this is not the case, check your model!$]$ Trucks that can operate on the roads after the hurricane are in short supply, so you want to choose the location of the DC to minimize the transport work $($tonkm$,$ or the total kit$-$miles travelled$)$ in the temporary network. Note that transport work per kit is proportional to distance. Which of the five locations should the NGO choose to minimize the transport work in the temporary network? DC $1$ DC $2$ DC $3$ DC $4$ DC $5$ Part $2$ Due to road conditions, the shelters furthest away from the center may suffer from late and unreliable deliveries. As a result you are thinking about opening more than one DC$.$ To trade$-$off the fixed costs with the variable costs, you estimate that each transported mile costs $$2$ per kit. Assuming the military is ok with delivering your supplies to more than one DC$,$ what is the optimal number of DCs$?$