Based on Klingman and Phillips XXXXXXXXXXThe Marines need to fill three types of jobs in two cities (Los Angeles and Chicago). The numbers of jobs of each type that must be filled in each city are...

Based on Klingman and Phillips (1984). The Marines need to fill three types of jobs in two cities (Los Angeles and Chicago). The numbers of jobs of each type that must be filled in each city are shown in the file P09_17.xlsx. The Marines available to fill these jobs have been classified into six groups according to the types of jobs each person is capable of doing, the type of job each person prefers, and the city in which each person prefers to live. The data for each of these six groups are also listed in this file. The Marines have the following three goals, listed from highest priority to lowest priority: ■ Goal 1: Ensure that all jobs are filled by qualified workers.

■ Goal 2: Ensure that at least 8000 employees are assigned to the jobs they prefer.


■ Goal 3: Ensure that at least 8000 employees are assigned to their preferred cities.

Determine how the Marines should assign their workers. (Note: You may allow fractional assignments of workers.)