Processing freshman applications

Assignment Help Operation Management

Reference no: EM132151034

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)

Reference no: EM132151034

Questions Cloud

Improve the performance of a classifier : You get hired as a Machine learning expert at movies.com. Your task on day one is to improve the performance of a classifier

Write a rationale that defends your choices : Anticipate possible concerns his parent or guardian may have, addressing each with applicable strategies.

Implementation and maintenance process of it governances : What outside resources are available to assist technology managers in the implementation and maintenance process of IT governances? Outline two resources.

Companies in the ukraine received email purporting : In the Spring of 2015, three utility companies in the Ukraine received email purporting to come from Ukraine's parliament

Processing freshman applications : An admission office at a university is processing freshman applications which fall into three groups: in-state, out-of-state, and international.

Cancellation ensure that thread termination occurs : How can deferred cancellation ensure that thread termination occurs in an orderly manner as compared to asynchronous cancellation?

What might possibly deter you from the field : What was the biggest misconception you had about interpersonal and organizational communications? What cleared the misconception for you?

How does a database that is associated with a mobile device : How does a database that is associated with a mobile device and with mobile apps differ from a database that is stored and created using a more traditional.

Influences on special education student-teachers teaching : Think of two ways you can incorporate a TEDEd lesson into a typical 50-70 minute class period. How could you deliver it? How could students access it?.

User Account

All Pages