Cancelled

develop simple bonus payout structure for employee retention referral bonus

we would like to create a program that calculates a bonus for employees that refer other employees to work with the company.

the bonus is tied to the hours that the referred employees work with the organization.

there would be 2 tiers of payouts and 4 levels deep.

there would also be retention bonuses based on length of service for employees.

Caregiver Employee Referral Incentive Program

0.05c for every hour that they work

0.02c for every hour that anyone that employee refers to work with the company.

bonus amount hours worked in quarter

Suzie Michelle 0.05 457 1 22.85

Joe 0.05 525 1 26.25

amy 0.02 357 1 7.14

heather 0.02 254 1 5.08

jessie 0.02 500 1 10

fernanda 0.02 241 1 4.82

Total Pay 76.14

Suzie Refers Michelle and Joe

Michelle refers Amy and Heather

Joe Refers Jessie and Fernanda

Suzie would have a payout of $ X based on 0.05c (modifiable) on direct referrals of Michelle and Joe and the hours that they work quarterly.

Suzie would have a payout of $ X based on 0.02c (modifiable) on indirect referrals of amy and heather based on their hours worked quarterly.

Michelle would have a payout of $ X based on 0.05c (modifiable) on direct referrals of Amy and Heather and the hours that they work quarterly.

Joe would have a payout of $ X based on 0.05c (modifiable) on direct referrals of Jessie and Fernanda and the hours that they work quarterly.

We would have an excel spreadsheet that would be downloaded from our scheduling software with the hours quarterly that we would enter into the tree.

We would need spots to be able to add new trees as an employee is referred to the company.

As the tree expands we would need to continue to add people below (up to 4 levels deep)

We would like to be able to modify the bonus amount.

If an employee leaves they can stay in the tree but their hours would stay at zero for their hours and not generate any bonus moving forward in any of the trees.

We would like to be able to print out a master payout sheet to enter into payroll.

We would like to be able to print out individual payout calculators (optional if major added cost not needed)

Skills: Database Programming, Excel

See more: employee referral bonus, employee referral bonus flyers, employee referral bonus flyer, develop simple app gps coordinates blackberry, develop simple iphone app, develop simple flash, develop simple web browser, develop simple sliding iphone game, develop simple web based app updates database, develop simple task, develop simple app iphone, develop simple iphone application 2008, develop simple shopping cart application

About the Employer:
( 1 review ) windsor, Canada

Project ID: #15222081

Awarded to:

$500 CAD in 5 days
(160 Reviews)
6.6

26 freelancers are bidding on average $505 for this job

schoudhary1553

Hello Sir, Please give me chance to work on your project. i am the expert freelancer here and delivered almost 270 projects with 100% client satisfaction. Relevant Skills and Experience I have more than 5 years of ex More

$500 CAD in 5 days
(187 Reviews)
7.1
Neno585

Hello, your project sounds very interesting to me as I am skilled database/MS Excel and MS Access expert so feel free to contact me if you are interested in me developing your spreadsheet. Cheers Relevant Skills and E More

$736 CAD in 10 days
(21 Reviews)
7.0
fanninson45

I can assist to design, develop and maintain your database excel application. I provide technical consulting in design, and creation of a databases environments and creation of demo-able products Relevant Skills and E More

$333 CAD in 10 days
(14 Reviews)
5.4
yogesh701

Get the bonus system designed in excel with automation. Relevant Skills and Experience 1. I am an excel expert and have designed user friendly templates to match the client's requirement. 2. I keep my work simple and More

$555 CAD in 10 days
(13 Reviews)
4.3
sunny945

Hi there! I have read your project requirements. I can write you a Excel sheet for your calculations of Bonus or i do have some other suggestions for you that will make this calculation very easy. Relevant Skills and More

$300 CAD in 10 days
(4 Reviews)
3.8
usmanrana07

Hi! I've read and understood your details and i can deliver you this system with excellent quality. I'm expert developer having strong technical skills Contact me for quick and efficient services.. Relevant Skills and More

$666 CAD in 5 days
(1 Review)
3.6
startechoffshore

Hi there! Your project seems interesting to us and we believe we would be a perfect match for your requirement. Thank you! Relevant Skills and Experience Database Programming, Excel Proposed Milestones $250 CAD - More

$250 CAD in 10 days
(9 Reviews)
2.7
$555 CAD in 10 days
(4 Reviews)
3.4
bondilimahesh

I have extensive experience working on projects that require excel VBA skills. I'm keen on quality and delivering the project well advance in time.

$277 CAD in 10 days
(1 Review)
1.8
Nantiger3535

hello. how are you? i am expert of Microsoft Excel, excel VBA and data analyst. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best regard. Relevant Skills an More

$250 CAD in 3 days
(2 Reviews)
1.0
AhmedHassan1122

Excel VBA Developer. Can do this job perfectly. I make spreadsheet which make this work like charm. Relevant Skills and Experience Excel VBA Developer. Proposed Milestones $333 CAD - Full Price

$333 CAD in 3 days
(1 Review)
0.9
javacontext

I ENJOY EXCEL DATA HANDLING NOT LESS THAN ROLLER COASTER RIDE. Relevant Skills and Experience My expertise are in: Excel programming : 3+ years Database : 2 year 8 months Core Java : 4+ years Proposed Milestones More

$475 CAD in 10 days
(1 Review)
0.6
zunistia06

Hello, I am Adhy Wijaya. I think I can help you in this job because I have experience in Microsoft Excel with VBA and all functions. Best Regards, Adhy Relevant Skills and Experience You might want to see the feedba More

$277 CAD in 3 days
(0 Reviews)
0.0
RoyalCorpSer

. Relevant Skills and Experience . Proposed Milestones $250 CAD - . .

$250 CAD in 1 day
(0 Reviews)
0.0
vw7114083vw

Having more than 12 yrs of experience in .net technologies and worked on similar applications earlier. Relevant Skills and Experience .Net, MVC, HTML 5, Restful web services, Bootstrap, Jquey, JSON Proposed Milestone More

$500 CAD in 15 days
(0 Reviews)
0.0
nicholaiportelli

more than 10 years experience building similar tools. feel free to contact me for examples. Relevant Skills and Experience more than 10 years experience building similar tools. feel free to contact me for examples. More

$777 CAD in 5 days
(0 Reviews)
0.0
CretiveSolutions

A proposal has not yet been provided

$555 CAD in 14 days
(0 Reviews)
0.0
$1111 CAD in 25 days
(0 Reviews)
0.0
mike199

Hi, I’m a Web Designer/Developer from the UK. My name is Mike. Your project description sounds interesting to me and I do have skills & experience that are required to complete this project. Relevant Skills and Experi More

$555 CAD in 10 days
(0 Reviews)
0.0
safakerol

Hello i would programm this as a web app with a admin Interface. All based on Symfony so its clean and easy to maintance Relevante Fähigkeiten und Erfahrungen php symfony sql Vorgeschlagene Milestones $493 CAD - 1

$493 CAD in 2 days
(0 Reviews)
0.0