Assigning Engineers. A small engineering firm has 4 senior designers available to work on the firms 4 current projects over the next 2 weeks. The firms manager has developed the following table of quality scores, which show each designers design quality on each type of project, on a scale of 100. Also shown is an estimate of the time (in hours) required for each project.

a. Assume that one designer is assigned to each project. What assignment of designers to projects maximizes the sum of the quality scores assigned? b. Suppose that each designer has 80 hours available over the next two weeks. Assuming that more than one designer can work on a project, what assignment schedule maximizes the sum of quality scores assigned?

please use excel, if solver required do it with solver with poper formulas.

Project Designer 1 2 3 4 50 65 1 2 3 4 4 Time 90 60 70 65 70 80 70 40 55 50 25 50 80 60 85 85 75 35