In the WDS delivery example covered in lesson 5 in Module 8 we determined a delivery route that minimized the amount of time the driver actually spent driving. However, if the driver arrived at a location prior to its opening time window the driver had to wait the until the opening of the time window at that location. Suppose management at WDS has decided that they would prefer to have the driver wait at the depot (where the driver could do some work loading other trucks) rather than sit at a customer site waiting for the customer's delivery time window to open. Modify the spreadsheet and Solver settings to: 1) allow the driver to leave the depot at any time between 3:00 PM and 4:00 PM, and 2) if possible, arrive at each customer location within the allowable time windows. Assuming WDS still is interested in minimizing driving time, a. At what time should the driver leave the depot, b. What is the total minimum travel time required? In the WDS delivery example covered in lesson 5 in Module 8 we determined a delivery route that minimized the amount of time the driver actually spent driving. However, if the driver arrived at a location prior to its opening time window the driver had to wait the until the opening of the time window at that location. Suppose management at WDS has decided that they would prefer to have the driver wait at the depot (where the driver could do some work loading other trucks) rather than sit at a customer site waiting for the customer's delivery time window to open. Modify the spreadsheet and Solver settings to: 1) allow the driver to leave the depot at any time between 3:00 PM and 4:00 PM, and 2) if possible, arrive at each customer location within the allowable time windows. Assuming WDS still is interested in minimizing driving time, a. At what time should the driver leave the depot, b. What is the total minimum travel time required