Question 1. A small manufacturing facility is being planned that will feed parts to three heavy manufacturing facilities. The location of the current plants with their coordinates and volume requirements are given in the following table: Use the centroid method to determine a location for this new facility. Question 2. Rent' R Car is a multisite car rental company in the city. It is trying out a new "return the car to the location most convenient for you" policy to improve customer service. But this means that the company has to constantly move cars around the city to maintain required level of vehicle availability. The supply and demand for economy cars, and the total cost of moving these vehicle between sites, are shown below. a. Formulate the problem in mathematical terms (Linear programming). b. Find a solution that minimizes moving costs using Microsoft Excel solver