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.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Excel Macros, Excel VBA

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #17691633

26 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 30 päivässä
(776 arvostelua)

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 Lisää

$277 USD 10 päivässä
(400 arvostelua)

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 4 päivässä
(63 arvostelua)

- 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 Lisää

$400 USD 5 päivässä
(49 arvostelua)

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 Lisää

$30 USD 1 päivässä
(75 arvostelua)

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] Lisää

$250 USD 10 päivässä
(60 arvostelua)

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 Lisää

$350 USD 7 päivässä
(28 arvostelua)

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 Lisää

$155 USD 3 päivässä
(5 arvostelua)

"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 Lisää

$150 USD 10 päivässä
(12 arvostelua)

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 Lisää

$277 USD 3 päivässä
(2 arvostelua)

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 2 päivässä
(0 arvostelua)
$155 USD 3 päivässä
(0 arvostelua)
$277 USD 3 päivässä
(0 arvostelua)
$155 USD 3 päivässä
(0 arvostelua)

I can do the work

$166 USD 1 päivässä
(0 arvostelua)

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 3 päivässä
(0 arvostelua)

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 Lisää

$555 USD 3 päivässä
(0 arvostelua)

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 Lisää

$111 USD 2 päivässä
(0 arvostelua)

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 Lisää

$1000 USD 20 päivässä
(0 arvostelua)

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 3 päivässä
(0 arvostelua)