please use excel and show formulas

An MBA program is reviewing the applications of 16 prospective students for scholarships funded by a wealthy alumnus. They will select exactly 9 students to receive the scholarship. To simplify data entry, the students are identified by letters from A to P. Table 1 below shows the parameters relevant to the selection process that include sex, undergraduate major, years of postgraduate employment experience and GMAT score. Student Code A B Years 11 8 C Table 1. Scholarship selection parameters Major OTHER ENG A&S BUS ENG ENG OTHER 7 D 5 E F G H SEX F M F F F M F M F M M M M M F M A&S GMAT 633 639 620 632 640 642 642 579 609 644 620 585 565 586 614 620 1 7 4 6 2 7 10 9 9 J ENG BUS BUS ENG OTHER BUS A&S OTHER L M 8 N 0 9 4 P Although aware that not all can be met, the selection committee has six goals for the selection of the 9 students. 1. Approximately the same number of males and females. a. HINT: Treat this as a single goal that the number of males selected is as close to 4.5 as possible b. HINT: Do not force any deviational cell to be an integer. 2. The average number of years of postgraduate employment at least 7.5 3. The average GMAT score at least 630 4. At least 4 Engineering undergraduate majors. 5. At least 3 Business undergraduate majors. 6. At least 3 Arts and Sciences undergraduate majors. Develop a SOLVER enabled spreadsheet based on goal programming to determine which students should be selected in order to minimize a weighted sum of percentage deviations. Comments and Hints: Use only O's and 1's for the under and over weights. For this problem, the decision maker wants to avoid being under each of the 6 goals. In addition, the decision maker does not mind going over any goal except for the goal related to gender