using solver excel with simplex lp

A B C D F G H 1 Autos Roma is a car rental company with multiple sites in the city. You are testing a new "return the car to the place that suits you best" policy to improve 2 customer service. However, this implies that the company has to constantly move around the city to maintain the required levels of vehicle availability. The 3 supply and demand for economy cars and the total cost of moving these vehicles between the sites are shown in the attached table. 4 1 2 3 4 Offer 5 10 A 9 7 5 6 60 7 B 10 9 9 0 8 40 6 4 4 10 65 10 11 Demand 60 50 25 30 165 12 13 a) Find the solution that minimizes the costs of movement through the Solver of Excel. 15 b) What impact would it have on the total cost to ensure that from origin C always sends a car to site 3 as part of the optimal solution? 16 17 c) it is considering adding an additional origin to choose between L1 and L2 The costs associated with L1 are: 8,3,4,7 respectively for 18 destinations 1.2.3 and 4: the offer is 30. The costs associated with 2 are: 5.3.9 and 7 respectively for destinations 1. 2. 3 and 4; the 19 offer is 20. Which of the two, L1 or L2, is better to minimize the cost? 20 21