a)formulate linear integer program model that selects three routes minimizing their total time

b) solve the resuling model in Excel solver

All in Here E-commerce company provides two-days delivery service for all customer around Turkey. At the distribution center, parcels are loaded to trucks in every morning for delivery. The company wants to deliver parcels as soon as possible. Therefore, parcels are divided among the trucks based on destinations to minimize delivery time. Today, they have 9 parcels to deliver. In the following table, possible routes, and destinations for each route are given. For example, route 1 will deliver parcels to locations A, D and G. The bottom row of the table shows the time required to traverse the route. Since the company owns only three trucks, three routes should be selected. Also each delivery location must be included on exactly one route. 1 Table 1: Possible Routes Destinations 1 2 3 4 5 6 7 8 9 10 A 1 1 B 1 1 1 1 1 11 1 D 1 E 11 F G 11 1 H 1 1 1 I 1 1 Time in hours) 6 4 7 5 4 6 537 6 OA 1 1 a) Formulate an IP model that selects three routes minimizing their total time. b) Solve the resulting model in Excel Solver