+ Reply to Thread
Results 1 to 2 of 2

Calculating Employee Bonuses based on Salary AND Tenure

  1. #1
    Registered User
    Join Date
    07-16-2013
    Location
    Dallas, TX
    MS-Off Ver
    Excel for Mac 2011
    Posts
    15

    Calculating Employee Bonuses based on Salary AND Tenure

    I am having a major brain cramp in how to calculate Column H in the attached.

    What I'm looking to do is create a "fair" allocation of a bonus pool for our company. The idea is to reward employees with an emphasis on their tenure with the company, as they've worked from the ground up, but also keep salaries in mind. Is there a formula-based way to take a bonus pool of money, and divy it up based on time with the company while also factoring in annual salary? I need to include their salaries so that it feels like a true bonus to each individual based on their various individual compensation levels.

    Thanks in advance for any advice along the way!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,077

    Re: Calculating Employee Bonuses based on Salary AND Tenure

    I would add together multiple calculations.

    1. 33% of the bonus pool based on % of all days, plus
    2. 33% or the bonus pool based on % of all salaries, plus
    3. the remainder of the pool as a fixed share.

    I have used this formula in the attachment - =($I$4*F6)+($J$4*H6)+($K$4/COUNTA($C$6:$C$12))
    Attached Files Attached Files
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 03-27-2015, 03:39 AM
  2. Time Sheet , Salary and Bonuses
    By AgusDragon85 in forum Excel General
    Replies: 3
    Last Post: 01-04-2015, 05:40 PM
  3. Replies: 2
    Last Post: 05-27-2014, 01:17 AM
  4. Help! Need to calculate bonuses based on years and salary.....
    By larasmomma in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-26-2012, 05:57 PM
  5. Replies: 7
    Last Post: 09-18-2012, 11:33 AM
  6. Replies: 3
    Last Post: 09-17-2012, 01:03 PM
  7. Employee Bonuses
    By dengar169 in forum Excel General
    Replies: 9
    Last Post: 12-24-2010, 03:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1