CompPlan-2021-DEV
***If you are having any issues with fields not calculating, please clear all browser cache in you browser history***
Plan Inputs
Target Information (USD)
Estimated Sales Inputs (USD)
| Actual Results | % of Target | |
| Measure 1 Sales: $ | ||
| Hurdle Sales: $ | ||
| Measure 2 Sales: $ |
Estimated Payout Based on Sales Inputs
| % Attainment | Hurdle Met | Payout % | Payout | |
| Measure 1: | ||||
| Measure 2: | ||||
| Estimated Variable Earnings: | ||||
| Estimated Total Earnings: |
Instructions
Step 1: Enter your On Target Earnings (OTE) in the highlighted cell below:
Step 2: Enter your Base Pay in the highlighted cell below:
The Variable Pay amount will automatically populate based on the calculation of OTE minus Variable Pay.
Step 3: Enter the weight percentage for Measure 1 in the highlighted cell below:
The Measure 2 Weight amount will automatically populate based on the calculation of both Measures totaling 100%. If your specific Plan only has one Measure, please enter “100” in this field.
Step 4: Select your Role:
The Accelerator Value will automatically populate when you enter in your Measure 1 Quota Value.
Step 5: Enter the Measure 1 Quota value in the highlighted cell below:
Step 6: Enter the Hurdle Quota value in the highlighted cell below:
If there is no Hurdle Quota value to enter, please enter “0” into this field.
Step 7: Enter the Measure 2 Quota value in the highlighted cell below:
If there no Measure 2 Quota for your specific plan, please enter “0” into this field.
Step 8: Enter your Actual or Estimated values for Measure 1 Sales, Hurdle Sales, and Measure 2 Sales fields in the highlighted cells below:
If there no Hurdle Sales or Measure 2 Quota for your specific plan, please enter “0” in these fields.
* In the example below, Measure 2 Quota Target was met with no Hurdle required so the percent of performance to plan and the percent of payout are both 100%.
Step 9: Review Payout based on Sales inputs.
* In the example below, the Quota Targets for Measure 1 was exceeded, the Hurdle was met, and the Accelerator was applied resulting in an estimated payout higher than the On Target Earnings.