HOW DO I SOLVE THIS EXCEL? PLEASE HELP WITH THE ANSWERS FOR 1 and 2

A used-car broker needs to transport his inventory of cars from locations 1 and 2 in the below Fig. to used-car auctions being held at locations 4 and 5. The costs of transporting cars along each of the routes are indicated on the arcs. The trucks used to carry the cars can hold a maximum of 10 cars. Therefore, the maximum number of cars that can flow over any arc is 10.

Formulate an LP model to determine the least costly method of distributing the cars from locations 1 and 2 so that 20 cars will be available for sale at location 4, and 10 cars will be available for sale at location 5.

1) Use Solver in excel to find the optimal solution to this problem

2) Generate sensitivity report and find the range for transportation cost ($16, from location 2 to location 4) within which the solution remains optimal. Provide management implications.

$15 4+20 $6 $8 $12 $12 S7 So +10 15 S16