MENU
    Compensation Basis Examples
    • 8 Minutes to read
    • Dark
    • PDF

    Compensation Basis Examples

    • Dark
    • PDF

    Article summary

    Wage Type Example

    Wage Type Without Reviews Example

    Direct Data Input Example

    Fixed Amount Based on Employee Attribute Example

    Fixed Amount per FTE Example

    Fixed Amount Example

    % of Wages Example

    % of Wages with Annual Cap Example

    Tiers on Employee Attribute – Value in % Wages Example

    Tiers on Employee Attribute – Value in % Wages with Annual Cap Example

    Tiers on Employee Attribute – Value in Hours per Month Example

    Tiers on Employee Attribute – Value in Hours per Month with Annual Cap Example

    Tiers on Employee Attribute – Value in Amount Example

    Rate x Hours Example

    Wage Type Example

    The Wage Type compensation item is used for calculating salary compensation items and includes the capability to provide mid-period salary review dates.

    Wage Type calculation basis uses the following data to calculate employee compensation amounts in Workforce Budget:

    • Employee hours per month

    • Current wage rate in $ / hour (wage rate at the time of Workforce Data upload)

    • Current year review - wage review date and review % (review date after budget setup date & before budget year start date)

    • Budget year review - wage review date and review % (review date between budget period start date and end date)

    Illustration of Use

    Wage type calculation is typically used for calculating the budgeted salaries of employees. For example; full time Salary for an employee named Jonas Williams.

    Employee : Jonas Williams

    Date of Hire : 15-May-2010

    Budget Setup Date: 1-Feb-2017

    Budget Period : 1-July-2017 to 30-June-2018

    Current Salary Rate as on 1-Feb-2017: $30/hour

    Salary Review Current Year

    Review Date: 15-May-2017

    Review Percentage: 10% (i.e. $30x1.10 = $33/Hour effective from 15-May-2017)

    Salary review during Budget Period:

    Review Date: 15-May-2018

    Review Percentage: 5% (i.e. $33x1.05=$34.65/Hour effective from 15-May-2018)

    Wage Type Without Reviews Example

    The Wage Type without Reviews compensation item is used for calculating the base salary compensation item, but does not include the capability to provide mid-period salary review dates.

    • Employee hours per month

    • Wage rate in $ / hour

    Illustration of Use

    Employee: William Magor

    Employee Type: Intern

    Wage Rate: $15 per hour

    Number of hours per month: 20 hours

    Direct Data Input Example

    The Direct Data Input type Compensation item allows you to directly enter the relevant budget amounts for the compensation item.

    Illustration of Use

    Employee: Jonas Williams


    Jul '19


    Aug '19


    Sep '19


    Oct '19


    Dec '19


    Jan '20


    Feb '20


    Bonus

     

    1000

     

     

     

    500

     

    In the above example, this Budget manager directly budgeted for a bonus of $1000 in Aug 2019 and another bonus of $500 in Jan 2020 for Jonas Williams.

    Fixed Amount Based on Employee Attribute Example

    Fixed Amount Based on Employee Attribute is typically used for fixed dollar compensation payment based on the employee attribute.

    Illustration of Use

    Employee: Jonas Williams

    Compensation Item: Workmen Compensation

    Workmen Compensation Class Attribute: WC1 (construction worker)

    Fixed $ amount per month: $125 per month


    Jul 2019


    Aug 2019


    Sep 2019


    Oct 2019


    Nov 2019


    Dec 2019


    Jan 2020


    Feb 2020


    Workman's Comp

    125

    125

    125

    125

    125

    125

    125

    125

    Fixed Amount per FTE Example

    Fixed Amount per FTE is typically used for fixed dollar compensation payment based on the FTE of the employee.

    Illustration of Use

    Employee: Jonas Williams

    FTE Value for Jonas Williams: 0.5

    Compensation Item: lunch allowance

    Fixed Amount of Lunch Allowance per FTE: $250 per month/FTE

    Fixed Amount Example

    The Fixed Amount basis opens the same compensation amount for all periods and all employee types that use this basis.

    Illustration of Use

    All Full Time employees get a lunch allowance of $100 per month.

    % of Wages Example

    The % of Wages type compensation item opens the Workforce Administrator to enforce a calculation such as % of Gross Pay. This calculation would involve two steps:

    • Identifying the compensation items that add up to Gross Pay

    • Entering a % for calculating the compensation item

    Illustration of Use

    Compensation Item – Employer Match of Medicare Tax is setup with basis type of % of Wages and is calculated as 1.45% of Gross Pay

    Gross Pay: Fulltime Salary + Overtime Salary + Accrued Vacation


    %

    Jul 2019


    Aug 2019


    Sep 2019


    Oct 2019


    Nov 2019


    Dec 2019


    Jan 2020


     

    %

    Jul 2019

    Aug 2019

    Sep 2019

    Oct 2019

    Nov 2019

    Dec 2019

    Jan 2020

    FT Salary

     

    1000

    1000

    1100

    1100

    1100

    1100

    1100

    Overtime

     

    100

    100

    100

    100

    100

    100

    100

    Accrued Vacation

     

    100

    100

    110

    110

    110

    110

    110

     

     

     

     

     

     

     

     

     

    Medicare Tax

    1.45

    17.4

    17.4

    19

    19

    19

    19

    19

    % of Wages with Annual Cap Example

    % of Wages with Annual Cap works similar to % of Wages with an additional ability to specify an annual cap on the compensation item. Annual cap is calculated based on the budget year.

    Illustration of Use

    Suitable for compensation item such as FICA Tax, which is calculated as 6.2% of Wages with a cap of $5264 per year.

    Tiers on Employee Attribute – Value in % Wages Example

    Tiers on Employee Attribute – Value in % Wages can be used to build a tier structure of an employee benefit plan and to specify the compensation value as a % of Wages.

    Illustration of Use

    Compensation Item: Contribution to Employee Retirement Plan
    Basis: Years of Service of the Employee

    • 0 < Employee Years of Service <= 5 Years : 5% of Wages

    • 5 < Employee Years of Service <= 10 Years : 6% of Wages

    • 10 < Employee Years of Service : 7% of Wages

    Employee: Jonas Williams

    Date of Hire: 1-Aug-2014

    (Notice that Years of service for this employee crosses 5 in September 2019)


    Jul 2019


    Aug 2019


    Sep 2019


    Oct 2019


    Nov 2019


    Dec 2019


    Jan 2020


    Full Time Salary

    1000

    1000

    1100

    1100

    1100

    1100

    1100

    Overtime

    100

    100

    100

    100

    100

    100

    100

    Accrued Vacation

    100

    100

    110

    110

    110

    110

    110

     

     

     

     

     

     

     

     

    Days of Service

    1795

    1826

    1857

    1887

    1918

    1948

    1979

    Years of Service

    4.92

    5.00

    5.09

    5.17

    5.25

    5.34

    5.42

    Retirement Contribution %

    5

    5

    6

    6

    6

    6

    6

     

     

     

     

     

     

     

     

    Retirement Contribution $

    60

    60

    78.6

    78.6

    78.6

    78.6

    78.6

    Tiers on Employee Attribute – Value in % Wages with Annual Cap Example

    Tiers on Employee Attribute – Value in % Wages with Annual Cap works the same as the above but with an annual cap.

    Illustration of Use

    In the above example, assume that annual cap for Employers Match of Retirement Plan has an annual limit of $200 per year. In this case the above calculation would be as follows:


    Jul 2019


    Aug 2019


    Sep 2019


    Oct 2019


    Nov 2019


    Dec 2019


    Jan 2020


    Full Time Salary

    1000

    1000

    1100

    1100

    1100

    1100

    1100

    Overtime

    100

    100

    100

    100

    100

    100

    100

    Accrued Vacation

    100

    100

    110

    110

    110

    110

    110

     

     

     

     

     

     

     

     

    Days of Service

    1795

    1826

    1857

    1887

    1918

    1948

    1979

    Years of Service

    4.92

    5.00

    5.09

    5.17

    5.25

    5.34

    5.42

    Retirement Contribution %

    5

    5

    6

    6

    6

    6

    6

     

     

     

     

     

     

     

     

    Retirement Contribution $

    60

    60

    78.6

    1.4

    0

    0

    0

    Tiers on Employee Attribute – Value in Hours per Month Example

    Tiers on Employee Attribute – Value in Hours per Month works similar to the above but compensation value is specified in Hours per Month instead of % of Wages.

    Illustration of Use

    Compensation Item: Accrued Vacation

    Basis: Years of Service of the Employee

    • 0 < Employee Years of Service <= 5 Years : 10 Hours/Month

    • 5 < Employee Years of Service <= 10 Years : 12 Hours/Month

    • 10 < Employee Years of Service : 14 Hours/Month

    Employee: Jonas Williams

    Date of Hire: 1-Aug-2014

    (Notice that Years of Service for this employee crosses 5 in the September 2019 and Rate per Hour also changes in the same month.)  


    Jul 2019


    Aug 2019


    Sep 2019


    Oct 2019


    Nov 2019


    Dec 2019


    Jan 2020


    Full Time Salary

    1000

    1000

    1100

    1100

    1100

    1100

    1100

    Overtime

    100

    100

    100

    100

    100

    100

    100

    Accrued Vacation

    100

    100

    110

    110

    110

    110

    110

     

     

     

     

     

     

     

     

    Days of Service

    1795

    1826

    1857

    1887

    1918

    1948

    1979

    Years of Service

    4.92

    5.00

    5.09

    5.17

    5.25

    5.34

    5.42

    Vacation Hours/Month

    10

    10

    12

    12

    12

    12

    12

    Rate per Hour

    10

    10

    11

    11

    11

    11

    11

    Accrued Vacation $

    100

    100

    132

    132

    132

    132

    132

    Tiers on Employee Attribute – Value in Hours per Month with Annual Cap Example

    Tiers on Employee Attribute – Value in Hours per Month with Annual Cap works similar to the above but with an annual cap.

    Illustration of Use

    Using the case above, place a $400 restriction on maximum accrued vacation cost per year.


    Jul 2019


    Aug 2019


    Sep 2019


    Oct 2019


    Nov 2019


    Dec 2019


    Jan 2020


    Full Time Salary

    1000

    1000

    1100

    1100

    1100

    1100

    1100

    Overtime

    100

    100

    100

    100

    100

    100

    100

    Accrued Vacation

    100

    100

    110

    110

    110

    110

    110

     

     

     

     

     

     

     

     

    Days of Service

    1795

    1826

    1857

    1887

    1918

    1948

    1979

    Years of Service

    4.92

    5.00

    5.09

    5.17

    5.25

    5.34

    5.42

    Vacation Hours/Month

    10

    10

    12

    12

    12

    12

    12

    Rate per Hour

    10

    10

    11

    11

    11

    11

    11

    Accrued Vacation $

    100

    100

    132

    68

    0

    0

    0

    Tiers on Employee Attribute – Value in Amount Example

    Tiers on Employee Attribute – Value in Amount works similar to the above with one difference; the compensation amount is fixed.

    Illustration of Use

    Compensation Item: Car parking allowance

    Basis: Age of the employee

    (i.e. Aged employees need to have access to premium parking slots)

    • Employee Age <= 45 Years : $50/Month

    • 45 < Employee Age <= 60 Years : $75/Month

    • 60 < Employee Age : $150/Month

    Employee: Jonas Williams

    (Notice that Years of service for this employee age crosses 45 in Dec 19)


    Jul 2019


    Aug 2019


    Sep 2019


    Oct 2019


    Nov 2019


    Dec 2019


    Jan 2020


    Age in days

    16283

    16314

    16345

    16375

    16406

    16436

    16467

    44.61

    44.61

    44.69

    44.78

    44.86

    44.94

    45.03

    45.11

     

     

     

     

     

     

     

     

    Parking Allowance in $

    50

    50

    50

    50

    50

    75

    75

    Rate x Hours Example

    The Rate x Hours type compensation item would use the following data to calculate employee compensation amounts in Workforce Budget:

    • Rate per Hour in $ (not wage rate – for wage calculations, wage type calculation basis is recommended)

    • Hours per Month

    • Compensation Amount = Rate per Hour x Hours per Month

    Illustration of Use

    Example 1

    Employee: Jonas Williams (Full time Employee)

    Over Time Compensation

    Rate per Hour: $40 per Hour

    Budgeted Overtime Hours: 10 Hours per month

    Budgeted Overtime Compensation per month: $400 per month

    Example 2

    Employee: Janitorial Staff (Hourly Worker)

    Rate per Hour: $10 per Hour

    No of hours per month: 20 Hours

    Monthly Pay: $200 per month

    Profit Sharing Setup Example with Multiple Caps And Different Percentages

    Lets say you need to setup an item or items in Workforce Planning that would calculate a different percentage of wages based on a salary threshold AND you need it to be delayed for the first two years of employment.

    Here are the details for profit sharing:

    • You want the employee to get 0% for the first 2 years of employment

    • After the first 2 years, the employee gets 5% of the first $118,000 of wages earned

    • For the wages earned above $118,000, the employee gets 10% up to a max of $256,000 in wages

    Example Solution

    1. Set up 3 compensation items as follows:

    Comp Item #1
    · % of Wages with Annual Cap
    · % = 5
    · Annual Cap = $5,900
    · Account = Stat #1
    · Wages = Appropriate Wage Items
    Comp Item #2
    · % of Wages with Annual Cap
    · % = 10
    · Annual Cap = $25,600
    · Account = Stat #2
    · Wages = Appropriate Wage Items
    Comp Item #3
    · % of Wages with Annual Cap
    · % = 10
    · Annual Cap = $11,800
    · Account = Stat #3
    · Wages = Appropriate Wage Items

    1. Next, address the employment length requirement. To do this, create 3 more comp items, which will reference the statistical account value posted from the first 3 comp items.

    Comp Item #4
    · Tiers on Employee Attribute - Value in % of Wages
    · Account = Profit Sharing GL Account
    · Attribute = Derived Years mentioned above
    · # tiers = 2
    · Tier 1 = From 0 To 2 = 0%
    · Tier 2 = From 2 To 99 = 100%
    · Wages = Comp Item #1 Stat Account
    Comp Item #5
    · Tiers on Employee Attribute - Value in % of Wages
    · Account = Profit Sharing GL Account
    · Attribute = Derived Years mentioned above
    · # tiers = 2
    · Tier 1 = From 0 To 2 = 0%
    · Tier 2 = From 2 To 99 = 100%
    · Wages = Comp Item #2 Stat Account
    Comp Item #6
    · Tiers on Employee Attribute - Value in % of Wages
    · Account = Profit Sharing GL Account
    · Attribute = Derived Years mentioned above
    · # tiers = 2
    · Tier 1 = From 0 To 2 = 0%
    · Tier 2 = From 2 To 99 = -100%
    · Wages = Comp Item #3 Stat Account

    This will post the proper net amounts.


    Was this article helpful?