Please provide screenshot of excel with formulas or python code.

3. A company would like to choose the site of a new distribution center that will service four sales centers located in Arlington (A), Bainbridge (B), Charlotte (C) and Dryden (D). The table below gives the location of these sales centers in the plane, where the units are in miles. The table also gives the number of daily deliveries to each sales center from the distribution center. Suppose that truck delivery costs are $1 per mile. (a) (15 points) Where should the distribution center be located so as to minimize the daily trans- portation cost, assuming that the trucks travel in a straight line? Formulate the problem as an optimization problem. 1 Sales Center Code Daily Deliveries a coord. y coord. Arlington A 9 -3 Bainbridge B 6 4 Charlotte 5 7 14 Dryden D 5 2 7 9 (b) (20 points) Use Excel's solver / Python to determine the optimal solution: what are the optimal location for the distribution center and minimum transportation cost? Be sure to submit a screenshot of the Excel sheet and solver window or your code that you used to solve the problem. (c) (15 points) Suppose the desired location (x,y) needs to satisfy an additional constraint: cos(x) + sin(y)