Question: Each approved project must be led by a project manager. Eight project managers are available, and each manager can manage one project. This information is
Each approved project must be led by a project manager. Eight project managers are available, and each manager can manage one project. This information is summarized in the table below, where 1 indicates that the project manager is qualified for the project and 0 indicates otherwise. Using Microsoft Excel Solver determine which manager should be assigned to each approved project. Of course, a project cant be approved unless a qualified manager is assigned to it.
| Manager 1 | Manager 2 | Manager 3 | Manager 4 | Manager 5 | Manager 6 | Manager 7 | Manager 8 | |
| Project 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 |
| Project 2 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 |
| Project 3 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 1 |
| Project 4 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 |
| Project 5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 |
| Project 6 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Project 7 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 |
| Project 8 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 0 |
| Project 9 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 |
| Project 10 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 |
| Project 11 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 |
| Project 12 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 1 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help