MANAGE BURDEN COST CEILINGS

Use this screen to impose a ceiling rate for project/account/pool combinations, which are used in the revenue and billing computations. This ceiling rate becomes the "not-to-exceed" rate for the project. Additionally, you can specify an override rate or a fixed rate to be used for reporting purposes only.

You must add a new record for each project/fiscal year combination at the beginning of each fiscal year. Indirect cost pools are unique by fiscal year and, as a result, require new ceilings/overrides at the beginning of each fiscal year. Failure to add these records results in inaccurate revenue and billing calculations.

Initialize this screen before computing burden cost and before calculating billing or revenue. You should have already set up the following screens: Manage Project Account Groups, the Basic Info tab of the Manage Project User Flow, Manage Cost Pools, Manage Revenue Information, and Manage Project Billing Information.

Additional maintenance of this screen is required only when you begin a new fiscal year, when a ceiling changes, or when a new ceiling must be added.

This screen is also available as a subtask of the Manage Project User Flow: Burden Cost Ceilings.

Location

Identification

Project

Enter, or click to select, a project to which the ceiling or override rate is applicable.

Fiscal Year

Enter, or click   to select, the fiscal year to which the ceiling or override rate is applicable.

You can select a fiscal year only if you have defined it with a status of Open on the Manage Fiscal Years screen.

Burden Cost Ceiling Details

Account

Enter, or click to select, an account number for which you want to enter a ceiling or override. This column can display any of the account numbers at any level (including summary levels) contained in the Account Group for the project, exclusive of the accounts that have a function code of Revenue, Billed, or Unbilled-General

If you do not select an account as part of the pool base on the Manage Cost Pools screen, Costpoint displays the following warning: "This account is not in the base of the pool specified."

Burden cost ceilings can be imposed on an account at any level, including the summary level.

Account Name

This non-editable field displays the name of the account selected. Account names are defined on the Manage Accounts screen.

Pool

Enter, or click to select, the pool number to which the ceiling or override rate is applicable. All pool numbers entered must have already been set up on the Manage Cost Pools screen for the appropriate fiscal year, with the allocation group number equal to one. 

If you did not set up the allocation group number and fiscal year/pool number, Costpoint displays the following warning: "The combination of Allocation Group No., Fiscal Year, and Pool Number must exist on the Manage Cost Pools screen."

This is a required field.

Pool Name

This non-editable field displays the name of the pool selected. You can define pool names on the Manage Cost Pools screen.

Rate Ceiling

Enter the ceiling or override value. Ceilings can be positive or zero. If the cost pool is hours-based, the rate displays as a currency amount followed by Amt/Hr in the Rate Format field. If the cost pool is cost-based, the rate displays as a whole number followed by % in the Rate Format field.

Rate Format

This field displays the type of number in the Rate Ceiling field. If the pool is hours-based, this field displays Amt/Hr, and if the pool is cost-based, it displays %.

Cost of Money Ceiling

Enter a COM ceiling or override value. You can enter COM ceilings only if you selected the Apply Cost of Money Rates check box on the Basic Info tab. If the cost pool is hours-based, the rate displays as a currency amount followed by Amt/Hr in the Rate Format field. If the cost pool is cost-based, the rate displays as a whole number followed by % in the Rate Format field.

Rate Format

This field displays the type of number in the Rate Ceiling field. If the pool is hours-based, this field displays Amt/Hr, and if the pool is cost-based, it displays %.

Ceiling Method

Use this drop-down list to select a code to specify whether the rate entered is a ceiling, an override, or a fixed rate. Available codes:

The following table shows a summary as to when the Fixed or Override rate is applied.

Rate/Item

Fixed

Override

Target Costs

Not applied

Yes

Target Revenue

Yes

Yes

Actual Costs

Not applied

Not applied

Actual Revenue

Yes

Not applied

Provisional (Billing)

Yes

Yes

 

Apply to R/B/A

Use this drop-down list to select the code that determines whether the ceiling percent applies to the Revenue, Billing, or Both computations. Available codes include the following:

Any rows that display an Apply to R/B/A code are saved. Rows that have a "0.00" Ceiling Percent entered and no Apply to R/B/A code are not saved. To place a ceiling on a particular account, you must enter both the Rate Ceiling (and/ or COM Ceiling) and the Apply to R/B/A code.