An admission office at a university is processing freshman applications which fall into three groups: in-state, out-of-state, and international. The male–female ratios for in-state and out-ofstate applicants are 1:1 and 3:2, respectively. For international students, the corresponding ratio is 8:1. The ACT score is an important factor in accepting new students. The statistics gathered by the university indicate that the average ACT scores for in-state, out-of-state, and international students are 27, 26, and 23, respectively. The admission committee has established the following desirable goals in priority order for the new freshman class:
1. The incoming class is at least 1200 freshmen.
2. The average ACT score for all incoming students is at least 25
3. International students constitute at least 10% of the incoming class.
4. The female–male ratio is at least 3:4.
5. Out-of-state students constitute at least 20% of the incoming class.
a) Solve this problem using Excel Solver, label the sheets appropriately and use short comments for describtion.
Formulate a Goal Programming model to meet these goals presented, define your decision variables, constraints and objective(s)