answer the question a and b, translate into excel

12. Project Team Assignment. A project-based course assigns students to project teams at the start of the term. For this purpose, each student is asked to examine the set of projects available and to identify three of the alternatives as preferred assignments. A preference of 3 indicates the most preferred project. When these preferences are collected, the instructor assigns the students to project teams, aiming for an optimal assignment of students to teams. The criterion for the assignment is to maximize the total of the preferences assigned. This year, there are 10 available projects and 16 students enrolled. There is a maximum team size between 2 and 4 on each project, according to the nature of the work to be done. It is not permissible for a student to work alone on a project (that is, in a team of size 1). The table below shows the student preferences and the limits for the team sizes. a. What is the best value of the criterion-that is, the maximum sum of assigned preferences? b. In the solution of part (a), how many students are assigned to their first choice? What is the maximum number of students who could be assigned to their first choice, if that were the only criterion