How do you solve the transportation problem?

You can use the Excel plugin 'Solver' tp to solve transportation problems which will then be available under Tools menu in Excel