Question: 5) Using the Solver in Excel: Solve this problem: GBR Systems You manage a small software development company called GBR Systems. You have 10 employees
5) Using the Solver in Excel: Solve this problem:
GBR Systems 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 you've 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.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help