Appendix C. Model C; Bidding for Classes (BFC) In the MBA program at a prestigious university in the UAE, students bid for electives in the second year of their program. Each student has 100 points to bid (total) and must take two electives. There are five electives available: MBA501 (Management Science), MBA502 (Finance), MBA503 (Operations Management), MBA504 (Accounting), and MBA505 (Marketing). Each class is limited to 6 students. The bids submitted for each of the 15 students are shown in the table below. Formulate and solve a spreadsheet model to determine an assignment of students to classes so as to maximize the total bid points of the assignments. Hints: This is a special kind of assignment problem. The assignees are the students and the tasks are the classes. Each efudent is assigned to take two classes. Each class has a limit of 6 students. The data for this problem are the bid points for each student for each class. The decisions to be made in this problem are whether or not to assign each student to each class. The goal is to maximize the total bid points of the assignments. The functional constraints in this problem are that each student must be assigned to two classes, each class is limited to 6 students, and each student can take each class at most once. The number of classes a student is assigned to is just the sum of the row of changing cells for each student. Please consider using the template given below as a starting point (you will need to modify it)