4. Assigning Engineers. Your company has 4 senior engineers (E1 - E 4) available to work on the firm's 4 current projects (P1-PA) over the next 2 weeks. The firm's chief engineer has developed the following table of quality scores, which show each engineer's quality on each type of project, on a scale of 100. Also shown is the estimate of the time in hours) required for each project. P1 P2 P3 P4 Engineer 1 90 28 71 76 Engineer 2 71 66 52 40 Engineer 3 29 26 36 46 Engineer 4 48 51 78 56 Time 84 21 72 67 A a. Assume that one engineer is assigned to each project. What assignment of engineers to projects maximizes the sum of the quality scores assigned? b. Suppose that each engineer has 80 hours available over the next two weeks. Assuming that more than one engineer can work on a project, what assignment schedule maximizes the sum of quality scores assigned? You only need to submit a write-up for part b. (You should submit an Excel solution for both parta) and b). Note: To determine the amount of quality an engineer gives to a project, just multiply the quality for that project times the number of hours assigned. For example, if E1 works 30 hours on P1 and 50 hours on P2, he has added 30-90 quality to P1, and 50*28 quality to P2. Hint: In Excel, create different tabs for part a. and b. Solve independently of each other