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.

Habilidades: Entrada de datos, Procesamiento de datos, Excel, Excel Macros, Excel VBA

Ver más: 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

Información del empleador:
( 0 comentarios ) United States

Nº del proyecto: #17691633

25 freelancers están ofertando el promedio de $435 para este trabajo


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 en 30 días
(804 comentarios)

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 Más

$277 USD en 10 días
(408 comentarios)

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 en 4 días
(78 comentarios)

- 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 Más

$400 USD en 5 días
(49 comentarios)

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 Más

$30 USD en 1 día
(77 comentarios)

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] Más

$250 USD en 10 días
(73 comentarios)

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 Más

$350 USD en 7 días
(33 comentarios)

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 Más

$155 USD en 3 días
(14 comentarios)

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 Más

$277 USD en 3 días
(2 comentarios)
$155 USD en 3 días
(0 comentarios)

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 en 2 días
(0 comentarios)
$155 USD en 3 días
(0 comentarios)

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 Más

$111 USD en 2 días
(0 comentarios)

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 Más

$250 USD en 10 días
(0 comentarios)

I can do the work

$166 USD en 1 día
(0 comentarios)

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 en 3 días
(0 comentarios)

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 Más

$555 USD en 3 días
(0 comentarios)

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 en 3 días
(0 comentarios)

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 Más

$1000 USD en 20 días
(0 comentarios)
$35 USD en 10 días
(0 comentarios)