DONE IN EXCEL USING SOLVER!!! SHOW FORMULAS-- ILL LIKE (:

You manage a small software development company called GBR Systems. You have 10 employees available for assignment to 2 projects. Each employee has an assessed rating (higher means better performer) and youve noted which employees have earned certification A and certification B (see table below).

Project Pelini requires at least 3 team members. There needs to be at least 2 people assigned that have Certification A and at least 1 person assigned with Certification B. They can overlap, obviously. Because Pelini is an important project, the weighted average of the employees assigned to it must average at least 82.

Project Devaney also requires at least 3 team members, and 2 with Certification A. The weighted average of the employees assigned to this project must average at least 75.

More than 3 employees may be assigned to each project. Find the optimal assignment your objective is to maximize the total employee rating of all assigned staff members (aggregately for both projects).

Perhaps it should be mentioned that each employee can be assigned at most to one of the two projects.

Rating Cert A 80 Tagge Brownson Humm Cert B 1 1 76 1 69 65 74 Ferragamo Luck Garcia Sorley Quinn Hager Burns 90 88 62 71 74