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) Formulate a Goal Programming model for this problem to meet these goals in the order presented. Clearly define your decision variables, constraints and objective(s)
b) Solve this problem using Excel Solver. Make sure you label your sheets appropriately and use short comments to describe what you did on each sheet. Include organized snapshots of your Excel solution in the report.