Use the Bank Location problem $($page $678-680)$ as a model for formulation. You are deciding to put warehouses in South Africa. Specifically, you will want to locate a warehouse in each prov$$nce or a province next door to minimize transportation time. Your objective would be to minimize the number of warehouses. You will need to formulate the problem and then optimize the location of the warehouses via excel solver. Please provide an explanation. $(4$ points$).$

Rerun your analysis. Add the following constraints to serve both Johannesburg and Cape Town $($they are large cities$).$ Make sure at least one warehouse is in the respective provinces of Johannesburg and Cape Town to serve metropolitan needs. Reformulate, optimize and discuss if there are any changes to the solution. Provide an explanation. $(3$ points$).$