- November 2012 Biocidal Products Directive Annex I Inclusion Decisions February 22, 2012Details on the active substances that will be Included onto Annex I of the Biocidal Products Directive (BPD) on the 1 November 2012. […]
- Nanotechnology – What are nanomaterials? February 22, 2012Nanotechnology involves the creation and/or manipulation of materials at the nanometre (nm) scale. One nanometre is 10-9 m or one millionth of a millimetre. Nanoparticles are also manufactured or produced as a by-product of many long standing processes, such as fires, diesel engines and high energy manufacturing processing such as welding or grinding. […]
Compa Ratios
Using Excel to calculate Compa Ratios:
Compa ratio (CP) is a salary expressed as a percentage of or indexed to the salary range midpoint/market rate (salary/midpoint or market rate = compa ratio).
The CP may be used as an indicator of how an individual is doing against plan. If the CP = 100, the salary of the individual is equal to the midpoint/market point (MP/MR). This may also be used to assess incumbents in a job, job family or entire organization by dividing the collective salaries by the collective MP/MR.
When the CP is significantly below 100, an increased risk of turnover exists. Conversely, if the CP is significantly above 100 you may be overpaying and driving unnecessary costs into the business. If your CP is significantly above 100 and turnover is high, check your source of market data and look for other contributing factors.
Example of annual salary spreadsheet:
| A | B | C | D | E | F | ||||||
|
Current Salary | Proposed Increase % | Proposed Inc £ rounded | Proposed new salary rounded | Compa ratio based on mid point of Grade | ||||||
| F | 55,000.00 | 5.00% | 2,750.00 | 57,750.00 | 103.36 | ||||||
| F | 50,000.00 | 4.00% | 2,000.00 | 52,000.00 | 93.06 | ||||||
| F | 45,624.00 | 7.00% | 3,194.00 | 48,818.00 | 87.37 | ||||||
| F | 43,000.00 | 3.00% | 1,290.00 | 44,290.00 | 79.27 | ||||||
| C | 30,720.00 | 4.00% | 1,229.00 | 31,949.00 | 123.59 | ||||||
| B | 19,000.00 | 5.00% | 950.00 | 19,950.00 | 92.79 | ||||||
| D | 32,395.00 | 4.50% | 1,458.00 | 33,853.00 | 104.97 | ||||||
| F | 44,462.00 | 4.00% | 1,778.00 | 46,240.00 | 82.76 | ||||||
| Salary Grade Ranges | |||||||||||
| GRADE | Minimum | Mid Pt | Maximum | ||||||||
| A | 12900 | 16125 | 19350 | ||||||||
| B | 17200 | 21500 | 25800 | ||||||||
| C | 20700 | 25850 | 31000 | ||||||||
| D | 25800 | 32250 | 38700 | ||||||||
| E | 32700 | 40850 | 49000 | ||||||||
| F | 44750 | 55875 | 67000 | ||||||||
|
Use the following formula in F2:F9 to calculate Compa ratio based on Mid point of grade in above table:
=(1+((E2-VLOOKUP(A2,$A$14:$D$19,3,FALSE)))/(VLOOKUP(A2,$A$14:$D$19,3,FALSE))))*100 |
Leave a Reply
- GPs to ‘prescribe’ apps for patients February 22, 2012Best health apps and ideas to revolutionise NHS for patients […]
- People covering their own backs instead of taking responsibility February 21, 2012At a speech to health and social care professionals today, Care Services Minister Paul Burstow took a stand against the worrying trend in safeguarding, saying that its definition has been widened to a ridiculous degree. […]
- Cash boost for electric van man February 21, 2012The first vans eligible for the Government’s new Plug-in Van Grant, have been announced by Transport Secretary Justine Greening and Business Minister Mark Prisk today. […]
- HMRC issues tax return penalties February 20, 2012850,000 penalties for late tax returns will be issued over the next fortnight, 550,000 fewer than the same time last year, HM Revenue & Customs (HMRC) announced today. […]
CIPD
Fareham Businesses – BNI Fortress Fareham