please show the solver commands in excel and what it looks like in excel after

A rent-a-car company has to fulfill the excess demand for cars in 4 citiec: The company has excess subolv of cars in 3 cities: The distances between the cities (in 100km ) are: Formulate this problem as a transportation model and use Solver's Simplex LP to determine how many cars are to be transported from each supply city to each demand city in order to minimize total distances travelled subject to meeting the demands and not exceeding the supplies. Hint: Use Transportation model a, i.e., a rectange range of decision variables, as opposed to a column. It is easier