Results 1 to 4 of 4

Tiered Bonus Structure

Threaded View

fwendly Tiered Bonus Structure 06-18-2009, 03:23 PM
NBVC Re: Tiered Bonus Structure 06-18-2009, 03:47 PM
fwendly Re: Tiered Bonus Structure 06-18-2009, 04:09 PM
NBVC Re: Tiered Bonus Structure 06-18-2009, 04:14 PM
  1. #1
    Registered User
    Join Date
    06-18-2009
    Location
    Boce Raton, Fl
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question Tiered Bonus Structure

    I need to present dollar values to my boss for a proposed tiered bonus structure and am trying to figure out how to create the necessary formula.

    The bonus structure is as follows:
    Level 1 $8,500 = 3% of fees up to $8,500
    Level 2 $10,500 = 5% of fees between $8,501 and $10,500
    Level 3 $15,000 = 7% of fees between $10,500 and $15,000

    Tricky part is bonus amounts do not go back to dollar zero. The percentages are only for the stated range.

    EX: Level 1 = $255, Level 2 = 99.95, Level 3 = 314.93
    Therefore collecting $15,000 would net $669.88

    PLEASE HELP - NEED AS SOON AS POSSIBLE.
    Thanks!
    Last edited by fwendly; 06-18-2009 at 04:16 PM.

Thread Information

Users Browsing this Thread

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

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