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.

Fähigkeiten: Datenerfassung, Datenverarbeitung, Excel, Excel Macros , Excel VBA

Mehr darüber 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

Über den Arbeitgeber:
( 0 Bewertungen ) United States

Projekt-ID: #17691633

25 Freelancer bieten im Durchschnitt $435 für diesen 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 Tagen
(804 Bewertungen)

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 Mehr

$277 USD in 10 Tagen
(408 Bewertungen)

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 Tagen
(78 Bewertungen)

- 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 Mehr

$400 USD in 5 Tagen
(49 Bewertungen)

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 Mehr

$30 USD in 1 Tag
(77 Bewertungen)

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] Mehr

$250 USD in 10 Tagen
(73 Bewertungen)

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 Mehr

$350 USD in 7 Tagen
(33 Bewertungen)

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 Mehr

$155 USD in 3 Tagen
(14 Bewertungen)

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 Mehr

$277 USD in 3 Tagen
(2 Bewertungen)
$155 USD in 3 Tagen
(0 Bewertungen)

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 Tagen
(0 Bewertungen)
$155 USD in 3 Tagen
(0 Bewertungen)

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 Mehr

$111 USD in 2 Tagen
(0 Bewertungen)

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 Mehr

$250 USD in 10 Tagen
(0 Bewertungen)

I can do the work

$166 USD in 1 Tag
(0 Bewertungen)

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 Tagen
(0 Bewertungen)

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 Mehr

$555 USD in 3 Tagen
(0 Bewertungen)

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 Tagen
(0 Bewertungen)

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 Mehr

$1000 USD in 20 Tagen
(0 Bewertungen)
$35 USD in 10 Tagen
(0 Bewertungen)