Solve using excel only no other solution please

*9-12. Graves and Associates (1993). Ulern University uses a mathematical model that optimizes student preferences taking into account the limitation of classroom and faculty resources. To demonstrate the application of the model, consider the simplified case of 10 students who are required to select two courses out of six offered electives. The table below gives scores that represent each student's preference for individual courses, with a score of 100 being the highest. For simplicity, it is assumed that the preference score for a two-course selection is the sum of the individual score. Course capacity is the maximum number of students allowed to take the class. Preference score for course Student 1 2 3 4 5 6 50 80 30 60 1 2 3 4 5 6 7 8 9 10 90 25 80 75 60 45 30 80 40 40 100 40 50 60 40 40 100 60 60 30 70 80 80 100 10 60 70 90 10 95 30 50 80 55 90 65 90 100 40 90 40 40 80 60 55 80 10 90 70 40 100 80 70 100 Course capacity 6 8 8 5 5 6 5 Formulate the problem as an ILP and find the optimum solution. 9-13. You have three currency denominations with 11 coins each. The total worth (of all 11 coins) is 15 bits for denomination 1, 16 bits for denomination 2, and 17 bits for denomination 3. You need to buy one 11-bit item. Use ILP to determine the smallest number of coins of the three denominations needed to make the purchase. 10 10 Problems 9-13 to 9-16 are adapted from puzzles compiled in http://www.chlond.demon.co.uk/puzzles/puzzles1.html