# 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

( 1 review ) windsor, Canada

Project ID: #15222081

(179 Reviews)
6.7

## 23 freelancers are bidding on average \$520 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

(257 Reviews)
7.5
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

(21 Reviews)
7.2
(50 Reviews)
6.1
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

(19 Reviews)
5.7
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

(18 Reviews)
4.8
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

(4 Reviews)
3.8
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

(8 Reviews)
4.1
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

(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

(27 Reviews)
3.7
kkc1985612

Hello,. I have been working as developer for 6 years.I am proficient in mobile phone,HTML5, CSS, PHP, Wordpress.I can begin to work your project now.I am waiting for your [login to view URL] thanks! Relevant Skills and Experie More

(3 Reviews)
2.8
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.

(2 Reviews)
2.4
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

(1 Review)
0.6
(0 Reviews)
0.0
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

(0 Reviews)
0.0
CretiveSolutions

A proposal has not yet been provided

(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

(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

(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