Based on LeBlanc et al. (2000). A construction company has eight project managers and has 14…

Based on LeBlanc et al. (2000). A construction company has eight project managers and has 14 projects scheduled for the next 12 weeks. Each project must be assigned a project manager. The start and finish week for each project as well as the hours per week each project manager would need to spend on a project are given in file P15_37.xlsx. For example, project 1 starts at the beginning of week 4 and finishes at the end of week 10, for a duration of seven weeks. Also note that if manager 2 is assigned to project 1, he will work 50 hours per week on the project. In assigning managers, the company has a policy of not allowing a manager to work more than 70 hours a week. Given this constraint and the fact that all projects must be done, the company wants to minimize the total number of weeks during which managers work more than 50 or less than 30 hours. (Note that, given the data for the problem, working fewer than 30 hours in a week means not working that week at all.) How would you assign managers to projects?