Please do the calculations in excel and attach the file.

You run a local delivery company within a city that delivers product in recyclable totes. The table below lists the location of your distribution center and fifteen (15) customers that you have to deliver to today along with the quantity of totes required. Assume that you operate on a Euclidean plane (distance between points is a straight line) and that your delivery region is 20 miles by 20 miles. Your DC is located in the center of this region, at location (10,10) 1. Using the Clark-Wright algorithm, determine the optimal delivery routes for the demand listed. You have option to engage up to 8 (eight) trucks at your disposal. Each truck has a capacity of 200 totes each. Each truck costs Rs. 12000 per day and Rs. 45 per mile. If you do not use a truck, you do not have to pay the fixed charge. What is the minimal cost required? Show your work. 2. Suppose you had one vehicle that had unlimited capacity (you could fit all of the totes), how would you route it to deliver to each of these customer locations (starting at the DC, of course) to minimize the total distance? What would be total KMs. This Truck costs you Rs. 42000/day. What would be total cost. Justify your method and the resulting tour. 3. You are considering moving your DC to location (0,0). Comment on whether this is a good decision or not and provide cost estimates on why or why not. How much more (or less) will this cost you per day? 4. Using the VRP exact method algorithm, determine the optimal delivery routes for the demand listed. What would be the difference compared to part 1 of this problem solution considering total distance of routes and cost