I want a one page tool that does the following:
I have a pool of 20-30 applicants.
6 applicants are billing applicants only.
6 applicants are customer service applicants only.
6 applicants are sales and marketing applicants only.
6 applicants are technical support agents only.
6 applicants are Operator applicants only.
There is no applicant that applies to two separate departments.
I want to hire only the 9 best employees. Each department I need to hire 2 employees except for the last department I only need to hire one operator.
I have 5 Departments
Department 1: Billing (2 employees)
Department 2: Customer Service (2 Employees)
Department 3: Technical Support (2 employees)
Department 4: Sales & Marketing (2 Employees)
Department 5: Operator (1 employee)
Each employee has their own salary requirement.The Salary per employee ranges from $3000 to $10,000 per month.
My budget is $50,000 or less per month for all 9 employees.
Here is what I need:
I need a tool that will generate a different combination of 9 applicants, 2 for each department except for the operator which I only need 1 applicant.
Based on the applicants salary requirement, I don't want any combination to exceed $60,000 per month. The more the salary requirement, the better the employee. I would like to mix and match. Each applicant needs to work at least 8 new faces without their total salary exceeding $50,000. I don't want to see one applicant working in more than one department.
I also want the ability to remove the applicants that I don't like and still get all the maximum combinations when I run the tool the second time.
I need the tool created right away. It sounds hard than it really is but it is just a formula is what I need.
Lowest bidder, fastest delivery wins the job.
Budget: $100
Posted On: November 20, 2014 19:39 UTC
ID: 204814958
Category: Web Development > Web Programming
Skills: Array
Country: United States
click to apply
from Online Job Search
I have a pool of 20-30 applicants.
6 applicants are billing applicants only.
6 applicants are customer service applicants only.
6 applicants are sales and marketing applicants only.
6 applicants are technical support agents only.
6 applicants are Operator applicants only.
There is no applicant that applies to two separate departments.
I want to hire only the 9 best employees. Each department I need to hire 2 employees except for the last department I only need to hire one operator.
I have 5 Departments
Department 1: Billing (2 employees)
Department 2: Customer Service (2 Employees)
Department 3: Technical Support (2 employees)
Department 4: Sales & Marketing (2 Employees)
Department 5: Operator (1 employee)
Each employee has their own salary requirement.The Salary per employee ranges from $3000 to $10,000 per month.
My budget is $50,000 or less per month for all 9 employees.
Here is what I need:
I need a tool that will generate a different combination of 9 applicants, 2 for each department except for the operator which I only need 1 applicant.
Based on the applicants salary requirement, I don't want any combination to exceed $60,000 per month. The more the salary requirement, the better the employee. I would like to mix and match. Each applicant needs to work at least 8 new faces without their total salary exceeding $50,000. I don't want to see one applicant working in more than one department.
I also want the ability to remove the applicants that I don't like and still get all the maximum combinations when I run the tool the second time.
I need the tool created right away. It sounds hard than it really is but it is just a formula is what I need.
Lowest bidder, fastest delivery wins the job.
Budget: $100
Posted On: November 20, 2014 19:39 UTC
ID: 204814958
Category: Web Development > Web Programming
Skills: Array
Country: United States
click to apply
from Online Job Search
No comments:
Post a Comment