University is processing freshman applications

Assignment Help Operation Management

Reference no: EM132148260

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.

Reference no: EM132148260

Questions Cloud

What it means beyond the mere formulas : Based upon the input from Units 1 and 2, you have just received your next assignment that will contribute to your next decision. For the outdoor sporting goods.

Show how to make use of the bernoulli equation : HNCB038 Hydraulic Principles and Applications - what would the pressure difference between the bottom of a freshwater lake of depth 30m and 30m

How did you decide on an evaluation process : What have you learned about the implementation process of your new program? What are some major roadblocks that you can come up against?

Consultant to implement full enterprise resource planning : You have been hired as a consultant to implement a full Enterprise Resource Planning (ERP) solution called SAP at a business entity. W

University is 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.

Inspects a representative sample of goods : If products are delivered that do not meet quality, quantity, and price, the buyer can return these goods if he or she

What features distinguish it from most functional groups : What features does it share with most functional groups? What features distinguish it from most functional groups?

Define differences in contingency and situational leadership : Compare and contrast the differences in contingency and situational leadership. Then, determine the key influences they each have on organizational performance.

Observe about the results of switch : After a few months, what does Ricardo most likely observe about the results of this switch?

User Account

All Pages