Trip distribution! Transportation engineering Needed in 6 hours

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