Budget Worksheets

0

This article covers worksheet types, header, settings, and totals. Two related articles, linked from this one, cover salary and benefit costs and other costs.

Worksheets: Primary and Added

A newly created budget will contain one worksheet with a default title of Primary Worksheet. You can rename the worksheet in its settings panel. This worksheet cannot be deleted.

Adding a Worksheet

Use the Add Worksheet link in the left navigation menu to create additional worksheets for your budget. When you select this link, a dialog will open. You can choose the type of worksheet you want to add, and edit its default title. The following image shows the dialog for adding a workheet.

add a worksheet dialog

The worksheet types are:

  • Internal UW Worksheet
    • Use when other departments within the UW are collaborating on a project
    • Values from this worksheet display on the Budget Summary under the corresponding object/sub-object codes.
  • Fabrication Worksheet
    • Use this type under certain circumstances when a defined portion of a larger project budget involves the fabrication of equipment and the sponsor is unwilling to pay indirect costs related to fabrication.
    • Values from this worksheet roll up to the Budget Summary under the (06) Equipment object code.
  • Subaward Worksheet
    • Use to capture the budget of an outside institution that the UW is subcontracting some portion of a project’s work to.
    • Values from this worksheet roll up to the Budget Summary under the (03) Other Contractual Services object code. Subawards support custom external F&A rates and external benefit rates.

Each additional worksheet will appear on the left navigation menu in the order added.

Deleting a Worksheet

On the left navigation menu, there is a “more options” menu icon (3 vertical dots) following each non-primary worksheet name. Click on the “more options” icon to display the menu and select Delete Worksheet.  A confirmation dialog displays stating “Deleting a worksheet is permanent and cannot be reversed. All costs on this worksheet will be lost.” The following image shows the dialog.

delete a worksheet confirmation dialog

You have the option to cancel and keep the worksheet, or to delete the worksheet.

If you are viewing the worksheet when you delete it, the Budget Summary will display. Otherwise you will stay where you were.

Worksheet Header

Every worksheet has a header that displays its title and number. This header is always visible when you are in the worksheet.

When you create a worksheet, you have the option to edit the default title. At any other time, you can edit the title for a worksheet in its Worksheet Settings section, described below.

Each worksheet has a unique identifier assigned by the system. This number starts with the letter W and is displayed in the header following the title. For example, W111234.

Worksheet Settings

This section of the worksheet displays just below the header. By default, it is collapsed. Click anywhere in the section to expand it.

There are several sections of data that you can edit.

General Information

The following image shows the general information section.

worksheet settings general information section

This section contains the following fields.

  • Worksheet Type
    • You selected this when you created the worksheet, It is not editable
  • Title
    • Use this field to edit the title; this is a required field.
  • Org Receiving Funding appears for the primary worksheet only; Fiscally Responsible Org appears for all other worksheets.
    • Use the type-ahead search to find a match by organization code or department abbreviation. A results list will appear after you’ve entered a few characters. Click on a result to select it.
  • Box Number for Official Correspondence
    • Enter the appropriate value; this field is optional.
  • Cascade Other Costs Entries
    • By default, other costs entries are not cascaded across periods, unless this option was selected in the Budget Settings. Click the toggle to enable cascading. This will affect newly added costs, not existing ones. You can override the cascade setting for any individual cost entry.

Worksheet Default Inflation Rates

The following image shows the inflation rates and the APL options.

worksheet settings inflation rates and A P L

There are three inflation rates that are used in calculating values. The rates apply to all budget periods.

If you edited the values in the Budget Settings, they will then be the defaults for newly created worksheet. However, Budget Settings changes will not affect any existing worksheet values.

  • Salary – applies to personnel salary entries; the default value is 2%
  • Tuition – applies only to tuition entries; the default value is 3%
  • General – applies to all other cost entries; the default value is 0%

You can edit these values for any individual worksheet, and the changes will be applied to any newly added costs.

APL

Click on the toggle switch to enable this option. The PDC Rate field will display with the default rate, which is editable. A message will appear briefly indicating that APL is being added to your budget, followed by a message saying the addition is complete.

Once enabled, when adding a personnel cost, you have the option of using APL benefits link for that person.

When you use the APL benefits for a person, an icon (atom) will appear following the person’s name.

Prorated Direct Costs (PDC) are automatically added when APL is enabled, except on fabrication worksheets. The system will add a 19-10 line item to the Other Costs section of the worksheet. The amount for a given period is equal to the PDC Rate time the period costs subject to the MTDC base (excluding any 19-xx costs).

Note: When APL is enabled on the primary worksheet and there is a subaward worksheet, PDC includes all of the costs on the primary worksheet (except 19-00 and 19-20 costs) including first $25K of any 03-62 cost on the primary worksheet and the first $25K of any subaward worksheets.

F&A Settings

There are no default settings for Facilities & Administrative costs. You will need to set these values for each worksheet. You can create a custom F&A, which is described following the non-custom options. The following image shows the F&A settings section.

worksheet settings f and a

Start by using the Activity Location drop-down menu to select a location. Choices are:

  • South Lake Union Campus
  • Off Campus
  • On Campus (includes Harborview)
  • Research Vessel
  • WA Natl Primate Research Center (WaNPRC)

Then select your Sponsored Program Activity Category from its drop-down menu. See GIM 13: Activity Types for definitions.  hoices are:

    • Organized Research
    • Instruction
    • Other Sponsored Activities

If appropriate, select the checkbox to indicate “This worksheet is part of an industry sponsored clinical trial.”

If you select WA Natl Primate Research Center (WaNPRC) for your Activity Location, then you will need to chose a Primate Center Rate Type rather than a Sponsored Program Activity Category.

For the Base Type, the system will use a default setting based on your choice of Activity Location. The defaulted Base Types are:

  • Modified Total Direct Costs (MTDC)
  • Total Direct Costs (TDC)
  • Salary & Wages (S&W)

The rules for Base Type are as follows.

Activity Location Base Type
South Lake Union Campus
OR Off Campus
OR On Campus (includes Harborview)
MTDC

If Clinical Trial is also selected, then TDC

WaNPRC MTDC
Research Vessel S&W

A table below the Base Type information displays the default F&A rate for each period. A second column displays the F&A rate in use.

Note: Fabrication worksheets cannot change any F&A costs, so a statement to that effect displays in place of the fields.

Custom F&A

To use a custom F&A rate for your worksheet, start by clicking on the toggle to enable this feature.  The Base Type field will become editable, as will the rates in the F&A Rate in Use column. These additional base types will display in the drop-down menu:

  • Indirect Cost Not Applicable
  • Total Direct Costs less Equipment & Tuition (TDC lest E&T)
  • Custom… – used to fully define what costs are subject to F&A

When you select a custom base type, a dialog will display, allowing you to select which costs to include. See Custom F&A Base Types for details.

Worksheet Totals

This section of your worksheet displays calculated totals, with one column for each period, and one for the All Periods value. The following image shows an example of this section.

worksheet totals section

There are three subsections:

  • Total Direct Costs – the total of all salary, benefit, and other cost entries
  • Facilities and Administrative – the amount of F&A, with details when the section is expanded
  • Total Worksheet Costs – the total of the direct costs plus F&A

When you expand the F&A section, you will see the base type and location in the Description column. For each period and the All Periods column, there are rows for the following values, to clearly show the calculation results.

  • Total Direct Costs
  • Costs Subject to F&A, or Costs Subject to Subrecipient F&A for subaward worksheets
  • F&A Rate, or Subrecipient F&A for subaward worksheets
  • F&A Costs, or Subrecipient F&A Costs for subaward worksheets

0 people found this article helpful.