Question: Prescott Aero Software Inc. specializes in software products for general aviation. Management is putting together a team of programmers to develop version 3.0 of its popular personal computer flight simulator program, PCFly. The job has been divided into 10 tasks, with a different programmer to be assigned to each. The possibilities follow. Each programmer has been subjectively evaluated in terms of an efficiency index for each task.

Set up the linear program plan to find an assignment schedule that will maximize the aggregate project efficiency index. Then use Excel’s Solver to determine the maximizing assignment and the maximized aggregate efficiency index.

Hint: Each task has a capacity of 1 and each programmer has a capacity of 1.