i need this answer in excel file (solver), formulas should be mentioned there.

16. A rental car company has an imbalance of cars at seven of its locations. The following net- work shows the locations of concem (the nodes) and the cost to move a car between loca- tions. A positive number by a node indicates an excess supply at the node, and a negative number indicates an excess demand. 30 22 30 45 20 15 +6 25 +2 28 25 20 12 3 6 35 +3 a. Develop a linear programming model of this problem. b. Solve the model formulated in part (a) to determine how the cars should be redistrib- uted among the locations