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 will be 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 will apply in the Modifications screen (Projects » Project Setup » Controls). If you enter the same ceiling for both the award value and the funded value, the system will use 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 changed the ceiling code since the last time revenue or billing was calculated. For example, if one of the fields was changed from a code of R to a code of B, the numeric value 1 would replace the B when the screen was saved. You cannot edit this field after the screen has been saved and it will display a numerical value until revenue or billing has been calculated. After the calculation, it will revert back to one of the four alpha characters noted and can then be edited. The alpha and numerical values are stored in the PROJ table and inform Costpoint of the type of ceiling code changes. This enhances the processing speed of the programs by limiting the projects that must be reviewed for changes. The tables of those projects that have incurred changes will then be adjusted to correct for the specific ceiling code change.
The following is a list of the ceiling code changes along with the action that will be taken by the program:
|
Original Code |
New Code |
Resulting Number |
Program Action |
|
R |
B |
1 |
The Compute Revenue screen (Projects » Cost and Revenue Processing » Revenue Processing) will reset the code to B and remove the over-ceiling amounts from the PROJ_SUM table. The Calculate Billings screen (Projects » Billing » Calculate Billings) will apply the ceilings and not change the code. |
|
B |
R |
2 |
The Calculate Billings screen (Projects » Billing » Calculate Billings) will reset the code to R and remove the over-ceiling amounts from new invoice amounts. The Compute Revenue screen (Projects » Cost and Revenue Processing » Revenue Processing) will apply the ceilings and not change the code. |
|
A |
B |
3 |
The Compute Revenue screen (Projects » Cost and Revenue Processing » Revenue Processing) will reset the code to B and remove the amounts from the PROJ_SUM table. The Calculate Billings screen (Projects » Billing » Calculate Billings) will apply the ceilings and not change the code. |
|
A |
R |
4 |
The Calculate Billings screen (Projects » Billing » Calculate Billings) will reset the code to R and remove the over-ceiling amounts from the new invoice amounts. The Compute Revenue screen (Projects » Cost and Revenue Processing » Revenue Processing) will apply the ceilings and not change the code. |
|
R |
N |
5 |
The Compute Revenue screen (Projects » Cost and Revenue Processing » Revenue Processing) will reset the code to N and remove the over-ceiling amounts from the PROJ_SUM table. |
|
B |
N |
6 |
The Calculate Billings screen (Projects » Billing » Calculate Billings) will reset the code to N and remove the over-ceiling amounts from the new invoice amounts. |
|
A |
N |
7 |
If the Compute Revenue screen (Projects » Cost and Revenue Processing » Revenue Processing) is executed first, it will reset the code to a 6 and remove the over-ceiling amounts from the PROJ_SUM table. The Calculate Billings screen (Projects » Billing » Calculate Billings) will reset the code to N and remove the over-ceiling amounts from the new invoice amounts. |
|
|
|
or |
|
|
|
|
|
If the Calculate Billings screen (Projects » Billing » Calculate Billings) is executed first, it will reset the code to a 5 and remove the over-ceiling amounts from the new invoice amounts. The Compute Revenue screen (Projects » Cost and Revenue Processing » Revenue Processing) will reset the code to N and remove 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.
Use Find or Query to select a valid project. The selected project and its description will display in these non-editable fields.
Use the fields in this group box to set ceilings on the funded value of the project.
Enter a ceiling code for the funded total value of the project. Valid codes are:
R - Revenue
B - Billing
A - All
N - None
This non-editable field displays the sum of all funded total modifications for this project branch and its lower levels.
This non-editable field displays the fee percent, which is calculated as the Fee value divided by the Cost value.
Enter a ceiling code for the funded cost value of the project. Valid codes are:
R - Revenue
B - Billing
A - All
N - None
This non-editable field displays the sum of all funded cost modifications for this project branch and its lower levels.
Enter a ceiling code for the funded fee value of the project. Valid codes are:
R - Revenue
B - Billing
A - All
N - None
This non-editable field displays the sum of all funded fee modifications for this project branch and its lower levels.
This non-editable field displays the cumulative funded value award fee. The funded 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 in the Modifications screen (Projects » Project Setup » Controls).
No ceilings can be entered for funded award fee in this screen. Ceilings are automatically calculated by award fee period during the Compute Revenue process using the amount entered in the Funded Award Fee column in the Award Fee subtask of the Modifications screen.
You can enter the funded value award fee in the Funded Award Fee column of the Award Fee subtask in the Modifications screen. The table window in that screen displays the funded award fees by modification number.
Use the fields in this group box to set ceilings on the award value of the project.
Enter a ceiling code for the awarded total value of the project. Valid codes are:
R - Revenue
B - Billing
A - All
N - None
This non-editable field displays the sum of all awarded total modifications for this project branch and its lower levels.
This non-editable field displays the fee percent, which is calculated as the Fee value divided by the Cost value.
Enter a ceiling code for the awarded cost value of the project. Valid codes are:
R - Revenue
B - Billing
A - All
N - None
This non-editable field displays the sum of all awarded cost modifications for this project branch and its lower levels.
Enter a ceiling code for the awarded fee value of the project. Valid codes are:
R - Revenue
B - Billing
A - All
N - None
This non-editable field displays the sum of all awarded fee modifications for this project branch and its lower levels.
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 in the Modifications screen (Projects » Project Setup » Controls).
No ceilings can be entered for contract award fee 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 in the Award Fee subtask of the Modifications screen.
You can enter the contract value award fee in the Contract Award Fee column of the Award Fee subtask in the Modifications screen. The table window in that screen displays the contract award fees by modification number.
Changes to the screen update the PROJ table.