Need help to solve the problem with EXCEL SOLVER

Repositioning Supply The American Rent-a-Car Company has eight outlets in a metropolitan area. American operates under a policy that calls for a specific target" percentage of all available cars to be located at each outlet at the start of each day. These percentages are summarized in the following table. Outlet 1 2 3 4 5 6 7 8 Percentage 20 10 20 5 10 20 5 10 For example, if 50 cars are available, 10 should be at outlet I at the start of the day. At the end of a day. if the current distribution of cars does not comply with the targets, American employees drive the cars overnight from outlet to outlet so that the new distribution meets the specified targets. The distance between each pair of outlets is given in the attached Excel table. At the end of a particular day, American finds dial the 100 cars currently available are distributed at the outlets as follows. Outlet 1 2 3 4 5 6 7 8 Cars 4 14 5 17 22 7 10 21 (a) Given this distribution of cars, find a schedule for minimizing the total distance traveled during the overnight redistribution of the cars. (b) Show the network diagram corresponding to the solution in (a). That is, draw in just the arcs used and verify that the flows are consistent with the given information. To outlet 4 5 1 3 6 7 8 2 8 - 6 7 5 4 2 w NP 8 6 5 5 3 8 3 9 7 4 4 6 00 6 5 4 5 7 8 From Outlet st - 8 8 7 7 5 5 5 8 9 6 B 5 4 2 B 6 4 4 3 5 6 7 6 6 vw un 3 4 8 N 7 7 2 3 4