Build Sales, Recruiters, mark ups, commission calculation reports for IT Staffing firm

We are a Technical Recruiting firm based in Texas. We have sales reps (SR's) and Recruiters (REC) that are paid commission based on the jobs they fill with qualified consultants. The commission is based on the amount of hours their consultant works and the margin (spread) of that person. Spread = the money made each hour after burden (ie. straight profit).

Example: Recruiter1 has placed 5 consultants and their bill rate is $50/hr each. Each consultant worked 160 hours in a month. We would like to pay Rectruiter1 50% of the profit on each consultant after the spread. The spread can be different for each consultant based on their location and the cost incurred to place him in a project. We also need report that calculates the spreads. I also would like Grantt charts that shows how much each Recruiter is making per month etc on each consultant. Additionally, below is what I would like the report to handle.

Automatically calculate percentages and hourly profitability on each consultant – even for unbilled hours taking into account commissions and overheads.

Automatically calculate commission's payable – for all sales and recruitment staff with flexible configuration options.

Automatic calculation of bills and payments – Bills and Vendor payables can be calculated automatically.

We are looking for a custom built tool or Excel reports that allows us to populate recruiters and sales reps, company and consultants, and input spread and hours and have a system calculate commission. We also need a spread sheet that would calculate the spread

We would also like to be able to run reports if possible, such as company spread, individual recruiter spread for hour, week, month, year, etc.

I can give much more specifics and details, but this is the gist of it. We just need a excel specialist that can that can understand our business requirements and put them into a workable program.

Skills: Data Entry, Data Processing, Excel, Excel Macros, Excel VBA

See more: ups shipping calculation chart, commission calculation, commission calculation script, average staffing agency fees, headhunter fee percentage 2017, temp agency markup calculator, average staffing agency markup, staffing industry average markup, staffing agency pricing model, typical temp agency fees, recruiting fee structure, data entry, data processing, excel, visual basic, visual basic for apps, microsoft excel, real time usps fedex ups shipping calculation, commission calculation template, database design commission calculation

About the Employer:
( 0 reviews ) United States

Project ID: #17691633

25 freelancers are bidding on average $435 for this job


Hi, I am good at Excel and vba. I have referred the project summary details. I would like to discuss in detail with sample excel files containing data. -Chandra

$5000 USD in 30 days
(804 Reviews)

I am an excel expert and have completed many complicated excel related tasks. Can provide you sample if required of my past and current work. Read the project specs. Looks like this project is feasible. Just want to un More

$277 USD in 10 days
(408 Reviews)

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Good to go. Willing to take up your project. Thank you, Regards.

$200 USD in 4 days
(78 Reviews)

- For each SR and REC depending on the number of Consultants they were able to fullfill - Depending on tbe billling rate per each consultant - Calcualte the Recruter comission - Calculate the spread amount per co More

$400 USD in 5 days
(49 Reviews)

Let me review the spreadsheet with full specifications of the project to calculate the appropriate duration and cost as well. Let me review the spread sheet with data and your preferable format as well. Hi Mr. Employe More

$30 USD in 1 day
(77 Reviews)

I am an Excel specialist. I have a lot of experience in creating automation and data analysis tools using a combination of complex formulas and VBA macros. You can check some of my work here: [login to view URL] More

$250 USD in 10 days
(73 Reviews)

Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after com More

$350 USD in 7 days
(33 Reviews)

Aeronautical engineer and MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, genetic algorithms and other advanced models. I have a high perform More

$155 USD in 3 days
(14 Reviews)

Hello, my name is Nick. I've been using Excel since it first came on the market and Lotus 1-2-3 before that. What you're describing sounds like a mix of a timesheet and a reporting tool. I literally have decades of exp More

$277 USD in 3 days
(2 Reviews)
$155 USD in 3 days
(0 Reviews)

Hello, I am a business information specialist and I have made plenty of spreadsheets similar to what you are asking. If you provide me with the data I can tackle this project fairly quickly as I can start right away.

$200 USD in 2 days
(0 Reviews)
$155 USD in 3 days
(0 Reviews)

I read your project description. I'm understanding your requirement for this job. I've more than 3 years experience in related field. I've experience in Data entry, Internet Research, PDF conversation, Social Media More

$111 USD in 2 days
(0 Reviews)

Hi, I come with a rich experience in Excel and VBA. In my previous projects, I have worked on interactive dashboards to allow user to apply to filters or chose the date range to get the specific output post calculatio More

$250 USD in 10 days
(0 Reviews)

I can do the work

$166 USD in 1 day
(0 Reviews)

Hello, I have done 550+ projects on another website, here is my other profile link: [login to view URL] Contact me please if you're interested. I'm 100% sure I won't disappoint you! Thanks!

$155 USD in 3 days
(0 Reviews)

Hello, My name is Robert, from Romania. 34 years old. Wife and 2 year old son :) I work currently as a Pricing Manager, and have more than 14 years excel experience. We can discuss more details if you choose me to More

$555 USD in 3 days
(0 Reviews)

Hey , I'm good at the work you are providing. Looking forward to hear more from you. Thanks Relevant Skills and Experience I have an experiance of 5 years regarding this field.

$155 USD in 3 days
(0 Reviews)

Hi, Kindly share me more details so that i can give you estimated time and cost. Please check my below work.. 1. Case Management system. [login to view URL] you can crea More

$1000 USD in 20 days
(0 Reviews)
$35 USD in 10 days
(0 Reviews)