transportation engineering trip distribution 0

Hello, please refer to the attachemnts for the hw discrption. 

 

Now I want the answer to include the excel files and the worked out solution step by step and in an easy to follow manner.