Common Compensation Terms & Formulas
[Pages:17]Common Compensation Terms & Formulas
Common Compensation Terms & Formulas
ERI Economic Research Institute is pleased to provide the following commonly used compensation terms and formulas for your ongoing reference:
Base Pay
Short-Term
+ = + Incentives (Typically 1 year
Total Cash Compensation
or less outlook)
Long-Term Incentives
(Typically 2 - 5 year outlook)
= Total Direct Compensation
Aging Salary Survey Data Age your surveys by using the annual market movement of salaries to pro-rate salary surveys from the effective date of the survey data to the desired effective date of a salary structure.
Survey Aging Factor = (# Months to Age Data/12 Months) x % Annual Market Movement of Salaries Example: 2% Survey Aging Factor = (8 Months/12 Months) x 3% Annual Market Movement of Salaries Survey
Compa-Ratio A comparison of employee pay to the salary range midpoint calculated as follows: Compa-Ratio = Employee Salary / Midpoint
Example: 0.98 = $78,400 Employee Salary / $80,000 Midpoint It is expressed as a decimal (e.g., 0.98).
ERI Economic Research Institute I Common Compensation Terms & Formulas
2
Compensation Mix Compensation Mix (also known as "Pay Mix") represents the relationship of base pay and short-term incentives to total cash compensation. This term is commonly used in sales and executive compensation plan design.
100% = (Base Salary / Total Target Compensation) + (Short-Term Incentive / Total Target Compensation)
Example: 40% = $40,000 Base Salary / $100,000 Total Target Compensation 60% = $60,000 Commission / $100,000 Total Target Compensation Compensation Mix = 40/60
For example, a 60/40 plan will have 60% of total target compensation managed at base salary and 40% of total target compensation managed through a short-term incentive plan (e.g., commission).
Excel Pivot Chart -- Displaying an Equation Displaying an equation and R? on an Excel pivot chart can be tricky if it is not used often. If needed, follow these instructions:
1. Click within the pivot chart 2. Under Pivot Chart Tools (top of screen), click on Design 3. Click on Add Chart Element (left side of screen) 4. Click on Trendline 5. Click on More Trendline Options 6. Under Format Trendline (right side of screen), go to Trendline Option 7. Select Display Equation on Chart 8. Select Display R? Value on Chart
FICA Taxation The 3 tiers of the 2018 FICA taxes are described below:
1. 6.2% Social Security taxes on FICA wages up to the social security wage base of $128,400 for 2018 pay by both the employer and employee (12.4% in total).
2. 1.45% Medicare tax on all FICA wages paid by both the employee and employer (2.9% in total).
3. 0.9% additional Medicare tax withholding on FICA wages greater than $200,000 in a calendar year (paid by the employee).
For more information, see
ERI Economic Research Institute I Common Compensation Terms & Formulas
3
Grandfathering Upon implementation of a new or revised compensation plan, grandfathering will protect the current compensation opportunity of existing employees when performing the same role in the organization. Grandfathering will support in minimizing employee relations issues to contribute to a successful program implementation.
Gross Up A payment, such as a one-time award, may be grossed up so that an employee will receive the full amount even after taxes. In this instance, the company will bear the cost of the tax gross up.
Gross Amount = Net Amount / (1.00 -- the sum of all the payroll taxes expressed as a decimal)
Hours of Work Assuming a regular, full-time equivalent at 40 hours per week, there are 173.33 work hours per month and 2,080 work hours per year.
Total Hours of Work 173.33 per month 2,080 per year
Formula = (40 hours per week x 52 weeks per year) / 12 months per year = 40 hours per week x 52 weeks per year
Linear Regression Analysis Simple linear regression analysis shows the relationship between an independent variable such as Pay Grade (x-axis) and a dependent variable such as Salary Range Midpoint (y-axis).
Example:
Midpoint $ (Y) = ($5,714.30 x Pay Grade (X)) + $19,286 (this is the amount of the Y intercept)
ERI Economic Research Institute I Common Compensation Terms & Formulas
4
Market Pricing Market pricing is a job evaluation methodology that creates a job-worth hierarchy based on the "applicable market rate" for benchmark jobs in the external marketplace relevant to the business.
Market Ratio Market Ratio (also known as "Market Index") is a comparison of employee pay to the market rate calculated as follows:
Employee Salary / Market Rate = Market Ratio It is expressed as a decimal (e.g., 0.98).
Mean (Unweighted Average) Calculates the average of what all companies pay in a salary survey for a job.
Mean (Unweighted Average) = sum of all numbers in a data set / # of items in a data set
ERI Economic Research Institute I Common Compensation Terms & Formulas
5
Mean (Weighted Average) Calculates the average of what all employees are paid in a salary survey for a job. Mean (Weighted Average) = ((Company 1 Pay x # of Employees in Company 1) + (Company 2 Pay x # of Employees in Company 2) + (Company 3 Pay x # of Employees in Company 3) + (Company 4 Pay x # of Employees in Company 4) + (Company 5 Pay x # of Employees in Company 5)) / Total # of Employees Reported
Median Describes the central tendency of the data to minimize the effect of extreme values. It is the middle value in a set of ranked salaries and is also known as the 50th Percentile.
ERI Economic Research Institute I Common Compensation Terms & Formulas
6
Mileage (2018 IRS Standard Mileage Rate)
Business Travel Medical Travel/Moving Costs Charitable Mileage Rate
54.5 cents per mile 18 cents per mile 14 cents per mile
For more information, see
Mode The number that is reported most frequently in a data set.
Example (in low to high order): 2%, 3%, 3%, 3%, 3%, 3.5%, 4%, 5% 3% is the mode because it is reported most frequently (4x)
On Target Earning (OTE) Equivalent to total target cash compensation.
Example: $100,000 OTE = $70,000 Base Pay + $30,000 Short-Term Incentives at Target
Percentile A percentile of a data set will have the same percentage of data falling below it (e.g., 50th, 75th, 90th percentiles).
To calculate a desired percentile, use the following formula: Desired Percentile = (# of Data Points + 1) x Desired Percentile = # from the bottom
Promotional Budgets Approximately one-half of companies budget for promotions, while the other half of companies typically do not. When promotional increases are not budgeted, they are typically paid for from turnover, vacancies, and other compensation cost savings. A 1% budget is commonly used when budgeting for promotions.
ERI Economic Research Institute I Common Compensation Terms & Formulas
7
Quartiles Quartiles are three values obtained by dividing the sorted dataset into four equal parts. The lower or first quartile is the 25th percentile. The median or second quartile is the 50th percentile. The upper or third quartile is the 75th percentile.
Range The difference between the high and low values of a data set.
Range = High Value of Data Set ? Low Value of Data Set
Example: Data Set: $25,000, $35,000, $46,000, $50,000, $63,000, $78,000, $80,000, $94,000, $100,000
Range = $100,000 High Value - $25,000 Low Value
ERI Economic Research Institute I Common Compensation Terms & Formulas
8
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- numerical reasoning formula sheet
- common compensation terms formulas
- percentage change and percentage point change a
- how to calculate a percentage cso
- calculating and displaying regression statistics in excel
- a b c d e f g h i j k l m percentage formulas to help
- 01110000 01110101 01110010 01110000 01101100 01100101
- microsoft excel 2013 formulas and functions
- alamance burlington school system
- during this excel practice test you will work with a
Related searches
- common financial terms and definitions
- common excel formulas cheat sheet
- common accounting terms and definitions
- common military terms and acronyms
- common latin terms in english
- common medical terms and abbreviations
- common medical terms in spanish
- common medical terms and definitions
- common medical terms for patients
- common excel formulas list
- common formulas for excel
- common computer terms for beginners