Spreadsheet: 329392d1404300464-bands-for-incentive-payments-140702-incentive-calculator
Sheet: Under

 | Force Incentive and Performance Prgram for ASM: [NAME]
 |  |  | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Total |  |  |  | Period | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | Grand Total
 |  | Target | 166666.6666666667 | 166666.6666666667 | 166666.6666666667 | 166666.6666666667 | 166666.6666666667 | 145000 | 155000 | 188333.3333333332 | 166666.6666666667 | 166666.6666666667 | 170000 | 175000 |  |  |  |  | Target | 100000 | 100000 | 100000 | 100000 | 120000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000
 |  | Actual | 166667 | 140000 | 100000 | 185000 | 140000 | 100000 | 175000 | 140000 | 100000 | 195000 | 135000 | 100000 |  |  |  |  | Actual | 49000 | 55000 | 75000 | 95000 | 100000 | 110000 | 120000 | 100000 | 100000 | 100000 | 100000 | 100000
 |  | % Act vs Target |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % of Target achieved
 | [NAME]
 | % Target | Incentive
First | 0.5 | 0.015 | 1500 | 1250 | 1250 | 1250 | 1250 | 1087.5 | 1162.5 | 1412.499999999999 | 1250 | 1250 | 1275 | 1312.5
Next | 0.2 | 0.03 | 1000.002 | 1000 | 500.0000000000001 | 1000 | 1000 | 825 | 930 | 1129.999999999999 | 500.0000000000001 | 1000 | 1020 | 375
Next | 0.2 | 0.06 | 2000.004 | 1400.04 | 0 | 2000 | 1400.04 | 0 | 1860 | 1400.04 | 0 | 2000 | 960 | 0
Next | 0.1 | 0.08 | 1333.336 | 0 | 0 | 1333.333333333333 | 0 | 0 | 1240 | 0 | 0 | 1333.333333333333 | 0 | 0
Above | Above | 0.1 |  | 0 | 0 | 1833.333333333334 | 0 | 0 | 2000 | 0 | 0 | 2833.333333333334 | 0 | 0
 |  | Total Incentive
 |  | Cumulative Incentive
 |  | Total Incentive %
 | HI I have really spent a day to under stand the logic really typical to me anyway please find the updated
 | Note 1 | Need check from u r end for K 29 as per manual calculation
 | Note 2 | Drag the fromulas in colums D
 | Force Incentive and Performance Prgram for ASM: [NAME]
 |  |  | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Total |  |  |  | Period | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | Grand Total
 |  | Target | 166666 | 166666.6666666667 | 166666.6666666667 | 166666 | 166666.6666666667 | 145000 | 155000 | 188333.3333333332 | 166666.6666666667 | 166666.6666666667 | 170000 | 175000 |  |  |  |  | Target | 100000 | 100000 | 100000 | 100000 | 120000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000
 |  | Actual | 166666 | 140000 | 100000 | 185000 | 140000 | 100000 | 175000 | 140000 | 100000 | 195000 | 135000 | 100000 |  |  |  |  | Actual | 49000 | 55000 | 75000 | 95000 | 100000 | 110000 | 120000 | 100000 | 100000 | 100000 | 100000 | 100000
 |  | % Act vs Target |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % of Target achieved
 | [NAME]
 | % Target | Incentive
First | 0.5 | 0.015
Next | 0.2 | 0.03
Next | 0.2 | 0.06
Next | 0.1 | 0.08
Above | Above | 0.1
 |  | Total Incentive
 |  | Cumulative Incentive
 |  | Total Incentive %