Total Ceilings Subtask

Use this screen to set project total ceilings. These ceilings are imposed on the entire project rather than on the individual elements.

You can place ceilings on the cost of the project, the fee, or the total of the cost and the fee. You can also designate whether each of these ceilings is in effect for revenue, billing, both, or neither. You can also place the ceiling on the contract value or the funded value of the project.

Ceilings are considered when revenue is computed and/or when bills are calculated, depending on the ceiling code entered. You can enter them at any branch of the project tree, and they are in effect for all lower levels of the tree. You can also enter ceilings at multiple levels on the same project tree. You enter the values to which the ceilings apply on the Mods subtask. If you enter the same ceiling for both the award value and the funded value, Costpoint uses the lower of the two.

Valid ceiling codes are R (Revenue), B (Billing), A (All), or N (None). These are the codes that normally display on the screen. If you see a numeric value ranging from "1" to "7" in any of the six code fields, this means that a user has modified the ceiling code since the last time revenue or billing was calculated. For example, if one of the fields was modified from a code of R to a code of B, the numeric value 1 replaced the B when the screen was saved. You cannot modify this field after the screen has been saved, and it displays a numerical value until revenue or billing has been calculated. After the calculation, it reverts back to one of the four alpha characters noted and can then be modified. The alpha and numerical values are stored in the PROJ table and inform Costpoint of the type of ceiling code modifications. This enhances the processing speed of the programs by limiting the projects that must be reviewed for modifications. The tables of those projects that have incurred modifications are then adjusted to correct for the specific ceiling code modification.

The following is a list of the ceiling code modifications along with the action that is taken by the program:

Original Code New Code Resulting Number Program Action
R B 1 The Compute Revenue screen resets the code to B and removes the over-ceiling amounts from the PROJ_SUM table. The Calculate Standard Bills screen applies the ceilings and does not modify the code.
B R 2 The Calculate Standard Bills screen resets the code to R and removes the over-ceiling amounts from new invoice amounts. The Compute Revenue screen applies the ceilings and does not modify the code.
A B 3 The Compute Revenue screen resets the code to B and removes the amounts from the PROJ_SUM table. The Calculate Standard Bills screen applies the ceilings and does not modify the code.
A R 4 The Calculate Standard Bills screen resets the code to R and removes the over-ceiling amounts from the new invoice amounts. The Compute Revenue screen applies the ceilings and does not modify the code.
R N 5 The Compute Revenue screen resets the code to N and removes the over-ceiling amounts from the PROJ_SUM table.
B N 6 The Calculate Standard Bills screen resets the code to N and removes the over-ceiling amounts from the new invoice amounts.
A N 7 If the Compute Revenue screen is executed first, it resets the code to 6 and removes the over-ceiling amounts from the PROJ_SUM table. The Calculate Standard Bills screen resets the code to N and removes the over-ceiling amounts from the new invoice amounts.

Or

If the Calculate Standard Bills screen is executed first, it resets the code to 5 and removes the over-ceiling amounts from the new invoice amounts. The Compute Revenue screen resets the code to N and removes over-ceiling amounts from the PROJ_SUM table.

Initialize this screen before you compute revenue or calculate bills, depending on the code (revenue, billing, all, or none) entered. Maintenance is required only if one of the codes changes.

This screen is also available as a standalone application: Manage Total Ceilings.

Funding Info

Use the fields in this group box to set ceilings on the funded value of the project.

Field Description
Total

Enter a ceiling code for the funded total value of the project. Valid codes are:

  • R: Revenue
  • B: Billing
  • A: All
  • N: None
Total

This non-editable field displays the sum of all funded total modifications for this project branch and its lower levels.

Fee %

This non-editable field displays the fee percent, which is calculated as the Fee value divided by the Cost value.

Cost

Enter a ceiling code for the funded cost value of the project. Valid codes are:

  • R: Revenue
  • B: Billing
  • A: All
  • N: None
Costs

This non-editable field displays the sum of all funded cost modifications for this project branch and its lower levels.

Fee

Enter a ceiling code for the funded fee value of the project. Valid codes are:

  • R: Revenue
  • B: Billing
  • A: All
  • N: None
Fee

This non-editable field displays the sum of all funded fee modifications for this project branch and its lower levels.

Value Info

Use the fields in this group box to set ceilings on the award value of the project.

Field Description
Total

Enter a ceiling code for the awarded total value of the project. Valid codes are:

  • R: Revenue
  • B: Billing
  • A: All
  • N: None
Total

This non-editable field displays the sum of all awarded total modifications for this project branch and its lower levels.

Fee %

This non-editable field displays the fee percent, which is calculated as the Fee value divided by the Cost value.

Cost

Enter a ceiling code for the awarded cost value of the project. Valid codes are:

  • R: Revenue
  • B: Billing
  • A: All
  • N: None
Costs

This non-editable field displays the sum of all awarded cost modifications for this project branch and its lower levels.

Fee

Enter a ceiling code for the awarded fee value of the project. Valid codes are:

  • R: Revenue
  • B: Billing
  • A: All
  • N: None
Fee

This non-editable field displays the sum of all awarded fee modifications for this project branch and its lower levels.

Award Fee

This non-editable field displays the cumulative contract value award fee. The contract value award fee is summarized at the level of the project displayed in the Project field and all levels below. This amount includes all modifications for this project that have been entered on the Mods subtask.

You cannot enter ceilings for contract award fees in this screen. Ceilings are automatically calculated by award fee period during the Compute Revenue process using the amount entered in the Contract Award Fee column on the Award Fee subtask of the Mods subtask.

You can enter the contract value award fee in the Contract Award Fee column on the Award Fee subtask of the Mods subtask. The table window in that screen displays the contract award fees by modification number.