Targets & Caps Tab

Use the Targets & Caps tab to enable the Targets & Limits and Salary Cap features and select appropriate settings.

Targets & Limits

Once you select the Enable Targets & Limits check box, all of the other fields will become editable. If you later un-check the box, all of the values will be cleared.

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

targets and limits tab fields

Field Description
Use same target amounts for all periods The default value is Yes.  If you want to set a different target for each period, select No.
Period target amount Enter the target amount you want for each period in this field. The default value is zero (0).
Apply to You have three options for where to apply your target budget amounts:

  • Total Direct Costs only (default value)
  • Total Direct Costs Less Subcontract (Consortium) F&A
  • Total Costs
Include auto-adjusting entries to reach target The default value is No. When you select Yes for auto-adjusting entries, the Auto-Adjusting Entries section will display. This is described below.

Auto-Adjusting Entries

When you select Yes for auto-adjusting entries, this section will display.

SAGE Budget allocates funds to non-personnel costs based on your budget target and prioritization order. This function is particularly helpful when you anticipate having some unspent dollars in your budget and would like to optimize the funds available in specific areas.

Expand any of the line items to add a specific entry.

initial auto-adjusting dialog for choosing object code

In the setup dialog, you can add a Description, and select the appropriate UW Sub-Object Code. Add a period minimum and maximum amount and set a priority for the line item. You can have more than one item with the same priority. This dialog is shown in the following image.

Targets and Limits auto-adjusting entries setup

For example: assume you have established a target of $500,000 for your budget. You enable auto-adjusting entries and add two entries:

  • Travel is priority 1 with a minimum of $2,000 and a maximum of $5000
  • Equipment is priority 2 with a maximum of $1,500 and a maximum of $3000.

When you finish entering all the data into your budget worksheet, your total budget is only $492,000, so there is $8,000 in remaining funds.

The system

  • first adds the minimum amount for all lines for a total of $3,500, leaving $4,500 to allocate
    • $2,000 for travel
    • $1,500 for equipment
  • next by priority adds dollars to each entry up to its maximum if possible
    • travel gets an additional $3,000 for its maximum of $5000.
  • finally, allocates the remaining $1,500 to the equipment line minimum for a total of $3,000
Allocation Steps Description Amounts
Target Amount 500,000
Less:  Total Budget  –  492,000
Equals:  amount to allocate =      8,000
Less:  total of all minimum amounts ($2,000 + $1,500) –       3,500
Equals:  remaining amount to allocate =       4,500
Less: amount for Priority 1 entry, up to maximum –       3,000
Equals:  remaining amount to allocate =       1,500
Less: amount for Priority 2 entry – less than maximum for this example –       1,500

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

Salary Cap

You can set a custom salary cap when your sponsor requires one. From the worksheet, you’ll be able to see what the cap is, and which personnel exceed it. When you open 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.

To use the Salary Cap

Start by selecting the Enable Salary Cap check box on the Targets & Caps tab. The two additional fields will become editable. If you later remove the cap, the system will clear the values for those fields.

The following image shows the check box selected and the additional fields, as described in the table below.

target and caps tab salary cap fields

Field Description
Annual Salary Cap Amount Enter the maximum allowable salary amount specified by your Sponsor.
Salary Cap Notes This is an optional field. Enter any notes you want for reference.