please use excel to gather numeric answers as well as options and show formulas. thank you. other answers posted about this are wrong.

Q1 (100 points) Inc. is trying to a) identify a good location for their newly planned warehouse (WH) in the San Diego area and then b) plan delivery routes to five major local retailers from their WH, The customer locations and their weekly lamp demand is given below: Assume that cost of shipping per unit per mile to each delivery location is the same. a) (20 points) What would be the optimal coordinates for the planned WH? b) ( 40 points) If truck capacity is 1625 units what would be the load assignment for each truck to serve these customers to minimize transportation costs? How many trucks do we need? What are the utilizations of the trucks? c) (20 points) For each truck identify the sequence of the milk run (route) using the nearest neighbor heuristic. d) (20 points) For each truck identify the sequence of the milk run (route) using the sweep heuristic. How does this result compare to part (c)