Cerrado

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

26 freelancers están ofertando el promedio de $424 para este trabajo

cgullapalli

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
(776 comentarios)
7.8
ponnarasiBabu

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
(400 comentarios)
7.4
periyannas

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
(63 comentarios)
5.6
satishtl

- 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)
6.0
royalcalif

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
(75 comentarios)
5.3
aubrey03

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
(60 comentarios)
5.2
jasalaz100

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
(28 comentarios)
4.8
Capitan0Trueno

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
(5 comentarios)
3.5
dataexplorer

"Hello Dear, Happy to inform you that I'm an efficient Web Researcher and Data Entry Worker. I've reviewed you project "" "". I am able to visit the Organization’s website and research them. After all that put the Más

$150 USD en 10 días
(12 comentarios)
3.3
KolyaEnterprises

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)
3.2
MattMan

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

I can do the work

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

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)
0.0
fubulea

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)
0.0
alimransisir

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)
0.0
lavizsolutions

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)
0.0
Mehakadaa111

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)
0.0