Answer Happy

2. This morning, IMSE Logistics must deliver all the parcels to the customers in three different regions. Couriers are deployed to deliver the parcels to the customers. Below are the timeline to complete all the deliveries and labor requirement for each region. Region Timeline A 11:00 Labor requirement* 10 courier-hours 11 courier-hours 9 courier-hours B 12:00 с 13:00 *Note: A courier-hour defines the workload to be done by one courier in an hour. For example, labor requirement of 8 courier-hours can be done by 8 couriers in 1 hour, 4 couriers in 2 hours, or 2 couriers in 4 hours. There are 8 couriers on duty. In each hour, a courier can only work in one region, and no more than 6 couriers can work in any region. However, couriers are free to move to another region in another hour. Suppose that the regions are not so far from each other such that transportation time for a courier to move between regions is negligible. a. [15marks] Now it is 09:00. Formulate the problem as a maximum flow problem. Determine whether all the items in the three regions can be delivered on time and the detailed plan of how the couriers are deployed (i.e., the number of couriers deployed for each project in each hour). b. [10marks] Please formulate it as an optimization model and use Excel Solver Add-in to solve it.