Please provide excel formulas!

1- A larger and more modern main post office is to be constructed at a new location in Davis, California. Growing suburbs caused a shift in the population density from where it was 40 years ago, when the current facility was built. Annette Werk, the postmaster, asked her assistants to draw a grid map of the seven points where mail is picked up and delivered in bulk. The coordinates and trips per day to and from the seven mail source points and the current main post office, M, are shown in the following table. M will continue to act as a mail source point after relocation. 2 3 Mail Source Point Round Trips x, y Coordinates (miles) Per Day 1 6 (2,8) 3 (6, 1) 3 (8,5) 3 (13,3) 5 2 (15, 10) 6 7 (6, 14) 7 5 (18,1) M 3 (10,3) 4 a. (20 Points) Calculate the center of gravity as a possible location for the new facility. b. (20 points) Compare the load-distance scores for the location in part (a) and the current location, using rectilinear distance. 2- Wiebe Trucking, Inc., is planning a new warehouse to serve the western United States. Denver, Santa Fe, and Salt Lake City are under consideration. For each location, annual fixed costs (rent, equipment, and insurance) and average variable costs per shipment (labor, transportation, and utilities) are listed in the following table. Sales projections range from 550,000 to 600,000 shipments per year. Location Annual Fixed Variable Costs Costs per Shipment Denver $5,000,000 $ 4.65 Santa Fe $ 4,200,000 $6.25 Salt Lake City $ 3,500,000 $ 7.25 a. (20 points) Plot the total cost curves for all the locations on a single graph. b. (20 points) Find the break-even point and indicate which city provides the lowest overall costs? 3- (20 Points) Beagle Clothiers uses a weighted score for the evaluation and selection of its suppliers of trendy fashion garments. Each supplier is rated on a 10-point scale (10 = highest) for four different criteria: price, quality, delivery, and flexibility (to accommodate changes in quantity and timing). Because of the volatility of the business in which Beagle operates, flexibility is given twice the weight of each of the other three criteria, which are equally weighted. The table below shows the scores for three potential suppliers for the four performance criteria. Based on the highest weighted score, which supplier should be selected? Criteria Price Supplier Supplier Supplier B C 7 5 6 6 9 8 9 7 5 5 6 9 Quality Delivery Flexibility