Problem 2: Consider the following data (also available in Student Assignment INPUT.xlsx) Solve the problem formulated in problem 1 if you allow only 9 students in each seminar. a) What is the total ranking? What is the average ranking? b) What is the worst assignment (the maximum assignment over all students and all seminars)? c) Add a constraint that limits (or find some other way to limit) the worst assignment to 3. What is the new total ranking? What is the new average ranking? Note that you may need to use OpenSolver (available at OpenSolver.org) depending on the version of Excel that you have installed. If you cannot install this and/or if you do not want to install it, you can also solve this problem by suitably changing the inputs (e.g., the rankings). I would encourage you to think about that a bit. d) Why are the total and average rankings worse in part (c) than in part (a) even though no student can be assigned to anything worse than his/her third ranked seminar in part (c)? e) Now leave out the constraint you added in part (c), and allow the maximum seminar capacity to be 10 instead of 9 . What is the total assigned ranking? What is the average ranking