Make the application that will optimize transportation costs

Job ID: 37924430

Budget: $30 – $250 USD

Application should optimize cost of transportation for the company employees. Based on demand for a specific date which departments of company are working, it should provide the list of people who are most cost-effective to transport to destination. There are predefined bus routes with addresses of employees.
Based on this information application should provide list of names, which employees should be working on that day and provide, which lanes should be active, keeping in mind the cost effectiveness. Cost-effectiveness can be calculated based on mileage on the route and the number of routes (buses).
At the moment all that is present in excel, but it can be modified and delivered in whatever format it is needed.
Related categories: Python Excel SQL Google Maps API Qt