Results 1 to 1 of 1

Thread: Automate Commission Accelerator calculations based on quota attainment range.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Seeker INMD13's Avatar
    Join Date
    Mar 2013
    Posts
    6
    Articles
    0
    Excel Version
    Mac Version 16.21.1

    Automate Commission Accelerator calculations based on quota attainment range.

    Hi

    I was hoping someone would be able to help with the following scenario.

    I have a tiered accelerator component to my commission plan calculator and wanted to automate the calculations.


    Summary:

    Tier Rate . Range above Quota
    T1 125% 101% - 125%
    T2 150% 126% - 150%
    T3 175% 151% - 199%
    T4 200% 200%+

    Scenario:

    If an individual gets to 205% of quota they would hit all four tiers of accelerator (See calcualtions in attachment highlighted in yellow). I would like to have this automatically calculate. Any help would be greatly appreciated.
    Note: Only the amount over quote within a given range is eligible for the accelerated rate in a given tier.

    For example:

    Rep's quota = $10,000
    Rep's actual performance = $14,000. (140% of quota)
    Accelerator: The rep in this case would hit T1 and T2 accelerators

    T1 = $10,000 x 1.25 (range 101 - 125%) = $12,500 less quota $10,000 = $2500 eligible for T1 rate
    T2 = $10,000 x 1.40 (range 126 - 150%) = $14,000 less T1 attainment $12,500 = $1,500 eligible for T2 rate


    T1 = $2500 x 125% = $3125
    T2 = $1500 x 150% = $2250

    Attached Files Attached Files

Tags for this Thread

Posting Permissions

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