Hello,
I am in need of some assistance with the Solver function in Excel. We are trying to find where we should place employees to maximize the performance of all four jobs?

Each employee is rated on the ability to perform each job.

Job A requirements: minimum performance: 25%, minimum experience 0, minimum staff 10, and maximum performance is 100%.


Job B requirements: minimum performance: 60%, minimum experience 0, minimum staff 8, and maximum performance is 100%.
Job C requirements: minimum performance: 47%, minimum experience 0, minimum staff 6, and maximum performance is 100%.
Job D requirements: minimum performance: 37%, minimum experience 6, minimum staff 6, and maximum performance is 100%.

Not sure how to use solver to do this. I know how to use goal seeker but need to account for constraints.

Attached Files

Employee for Job Type.xlsx (10.8 KB, 11 views)