Based on Lee and Moore (1974). Faber College is admitting students for the class of 2007. Data on its applicants are shown in the file P09_10.xlsx. Each row indicates the number of in-state or out-of-state applicants with a given SAT score who plan to be business or nonbusiness majors. For example, 1900 of its instate applicants have a 700 SAT score, and 1500 of these applicants plan to major in business. Faber has set four goals for this class, listed in order of priority:

■ Goal 1: The entering class should include at least 5000 students.

■ Goal 2: The entering class should have an average SAT score of at least 640.

■ Goal 3: The entering class should consist of at least 25% out-of-state students.

■ Goal 4: At least 2000 members of the entering class should not be business majors.

Use goal programming to determine how many applicants of each type to admit. Assume that all applicants who are admitted will decide to attend Faber.