PLEASE SHOW ME HOW TO DO THIS IN EXCEL. I WOULD ALSO GREATLY APPRECIATE IT IF YOU COULD SHOW WHAT FORMULAS TO USE.

In the MBA program at a prestigious university in the Southeastern United States, students bid for electives in the second year of their program. Each student has 150 points to bid (total) and must take three electives. There are four electives available: Management Science, Finance, Operations Management, and Marketing. Each class is limited to 9 students. The bids submitted for each of the 10 students are shown in the table below. The decisions to be made in this problem are whether or not to assign each student to each class. 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. This is an assignment problem. 1. From your spreadsheet... what is the total points (the sumproduct of class assignment times the points bid)? (Do this in cell I29) 2. Solve for class assignments for each student and their bids. 3. Place the approbriate data into the model. Label vour constraints aporopriatelv