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)
26 freelancers are bidding on average $505 for this job
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
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