Tag Archives: Salary Cap

Targets & Limits

If the Enable Targets & Limits check box is selected, values for all of the other fields will display.

The following image shows the check box selected and the default values for each field, as described below.

targets and limits tab fields

Use same target amounts for all periods

  • The default value is Yes.  A value of No allows a different target for each period.

Period target amount

  • The target amount(s) for each period.

Apply to

  • Indicates which budget amount is targeted:
    • Total Direct Costs only
    • Total Direct Costs Less Subcontract (Consortium) F&A
    • Total Costs

Include auto-adjusting entries to reach target

  • If Yes is selected, the Auto-Adjusting Entries section will display, as described below.

Auto-Adjusting Entries

SAGE Budget allocates funds to non-personnel costs based on the budget target and prioritization order. This function is generally used to optimize the funds available in specific areas.

Expand any of the line items to view the values.

initial auto-adjusting dialog for choosing object code

In the setup dialog, the entry Description will display followed by the selected UW Sub-Object Code.

Each line item has a period minimum and maximum amount and a priority. More than one item may have the same priority. This dialog is shown in the following image.

Targets and Limits auto-adjusting entries setup

When the total is less than the targeted amount, the system first adds the minimum amount for all lines. It then adds dollars to each entry up to its maximum if possible.

Note: SAGE indicates auto-adjusting entries on your worksheet by displaying a “TL” icon before the line item description.

Salary Cap

A custom salary cap is used when the sponsor requires one. From the worksheet, you can see what the cap is, and which personnel exceed it. In the details for individual personnel, their total uncapped salary displays in addition to their capped total for improved transparency. For details, see the Salary and Wages Update Periods article.

If the Enable Salary Cap check box is selected, two additional fields will display, as shown in the following image.

target and caps tab salary cap fields

  • Annual Salary Cap Amount: The maximum allowable salary amount specified by the Sponsor.
  • Salary Cap Notes: An optional field for any reference notes.

The Update Periods page displays personnel values for a selected individual, for all budget periods.

The selected individual’s name and title display above the values.

The sections are

Each section can be collapsed or expanded as desired.

Base Salary

The following image shows the Base Salary section of the Update Periods modal, for just one period as an example.

base salary section of update periods

This section includes

  • Monthly Base Salary
  • Update Salary
  • Salary Inflation Rate (%)
  • Adjusted Monthly Base Salary

The Monthly Base Salary for the first period is, by default, the value entered as the Starting Monthly Salary on the Line Setup page. For any following periods, the Monthly Base Salary will be the prior period’s Adjusted Monthly Base Salary value.

For personnel that are paid hourly, the Starting Monthly Salary value, on the Line Setup modal, will be equal to the hourly rate of pay times the number of hours in a standard month (173.3 hours). 

The Salary Inflation Rate is the value specified in the Inflation & Benefit Rates section of the Properties tab page.

The Adjusted Monthly Base Salary is automatically calculated. It equals the Monthly Base Salary amount increased by the Salary Inflation Rate.

Effort

The following image shows the Effort section of the Update Periods modal.

effort section of update periods

This section includes

  • Months
  • % Effort
  • Person Months

Months is auto-calculated based on two data values:

  • The length of the period in months
  • Worker Position Type (calendar vs. academic) on the Line Setup modal

A budget period that includes a leap year will not affect the Months calculation.

% Effort is auto-calculated based on the initial % Effort entered on the Line Setup page.

Person Months is automatically calculated and is equal to: Months times Effort.

Period Salary Totals

The Period Salary Totals row shows the total for each period and in the far right Summary column, the total for the project.

    • Period Salary Total = Adjusted Monthly Base Salary times Person Months
  • Project Total = sum of all period totals

If the budget has a Salary Cap enabled, this will be expandable section. It will also display the individual’s salary without the cap imposed.

Period Benefits Totals

The following image shows the Period Benefits Totals section. The values are described below.

benefits totals section of update periods

This read-only section is pre-populated based on data entered on the Line Setup page for this person (specific individual or a TBD one).

For more information on benefits rules and rates, see GIM 3 Fringe Benefit Rates and Sponsored Projects.

Field Description
Benefit Type The UW Sub-Object Code selected on the Line Setup modal determines the benefit type and rate.

“APL” is listed if Include APL Benefits was selected on the Line Setup modal.

Benefit Object Code The UW Sub-Object Code entered on the Line Setup modal determines the benefit type.
Benefit % The benefit rate is determined by the Benefit Object Code (above) and whether APL was selected.
Total Benefits This total is calculated by multiplying the Period Total Salary by all listed benefit rates. If you update the data on the Setup page, then this total will reflect the changes.

Total Salary + Benefits

The Total Salary + Benefits row shows the total for each period and in the far right Summary column, the total for the project. The values are the sum of the Period Salary Totals and the Period Benefits Totals.

Tuition

Tuition may be included for student personnel, which are UW Sub Object codes 33, 34, 43, 44, 51, 52, 53, 54, 91, 92, 93, and 94.

Note: UW Sub Object codes (88) Hourly Work Study and (89) Hourly Student Salary do not include Tuition Benefits.

The following image show the Tuition section of the Update Periods modal with some example values. Each field is described below.

tuition section of the update periods screen

Field Description
Academic Quarter Tuition Rate The tuition rate for student personnel. There may be different tuition rates for the summer and academic year quarters.
Number of Academic Quarters The number of quarters this student will be working on the project.
Academic Tuition Amount This is a calculated field. It is equal to the Academic Quarter Tuition Rate times the Number of Academic Quarters.
Summer Quarter Tuition Amount The summer tuition amount for student personnel included in your budget.
Increase % (Academic & Summer) An inflation rate for tuition, which is applied to both Academic and Summer amounts.
Total Tuition This is a calculated field. It is equal to the sum of the Academic Tuition Amount and the Summer Quarter Tuition Amount, multiplied by the Increase percentage.

The Total Tuition values display in the “(08) Student Aid” section of the budget worksheet.