Solve on Excel and if required use Solver. Needed step by step answers with explanation asap. will definitely upvote.

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 criterionthat 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?

S1 S2 S3 S4 S5 S6 S7 S8 6S S10 S11 S12 S13 S14 S15 S16 Limit P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 OWO-OONOO OOO OOONOW OM OOOOOO ONOOOOOOW OO WOONOOO OOO OOONOW OO OOONOWO NOOOOOOO OOOOOOO OM OOOOOO SN-WOOOOOO OOOWO-ONOO OOOOOOO ONOOMOO OO OOOOO WOON -OOWNOOOOO NNN 1 1 1