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 Mods screen. If you enter the same ceiling for both the award value and the funded value, the system will use the lower of the two.
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.
What are the definitions of the alphanumeric values in the code fields?
Valid ceiling codes are "R," "B," "," or "N." 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 ceiling code has been changed 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 valid ceiling codes noted and can then be edited. The alpha and numerical values are stored in the PROJ table and inform the system 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 process will reset the code to "B" and remove the over-ceiling amounts from the PROJ_SUM table. The Calculate Bills process (Projects\Process\Billing) will apply the ceilings and not change the code. |
|
B |
R |
2 |
The Calculate Bills process (Projects\Process\Billing) will reset the code to "R" and remove the over-ceiling amounts from new invoice amounts. The Compute Revenue process (Projects\Process\Revenue) will apply the ceilings and not change the code. |
|
A |
B |
3 |
The Compute Revenue process (Projects\Process\Revenue) will reset the code to "B" and remove the amounts from the PROJ_SUM table. The Calculate Billings process will apply the ceilings and not change the code. |
|
A |
R |
4 |
The Calculate Bills process (Projects\Process\Billing) will reset the code to "R" and remove the over-ceiling amounts from the new invoice amounts. The Compute Revenue process will apply the ceilings and not change the code. |
|
R |
N |
5 |
The Compute Revenue process (Projects\Process\Revenue) will reset the code to "N" and remove the over-ceiling amounts from the PROJ_SUM table. |
|
B |
N |
6 |
The Calculate Bills process (Projects\Process\Billing) will reset the code to "N" and remove the over-ceiling amounts from the new invoice amounts. |
|
A |
N |
7 |
If the Compute Revenue process (Projects\Process\Revenue) is executed first, it will reset the code to a "6" and remove the over-ceiling amounts from the PROJ_SUM table. The Calculate Bills process (Projects\Process\Billing) will reset the code to "N" and remove the over-ceiling amounts from the new invoice amounts. |
|
|
|
or |
|
|
|
|
|
If the Calculate Bills process (Projects\Process\Billing) 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 process (Projects\Process\Revenue) will reset the code to "N" and remove over-ceiling amounts from the PROJ_SUM table. |
Use the fields in this block to enter ceiling codes for contract and funded values.
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), or "N" (None).
Enter a ceiling code for the funded cost value of the project. Valid codes are "R" (Revenue), "B" (Billing), "A" (All), or "N" (None).
Enter a ceiling code for the funded fee value of the project. Valid codes are "R" (Revenue), "B" (Billing), "A" (All), or "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.
This non-editable field displays the sum of all funded cost modifications for this project branch and its lower levels.
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 Mods screen.
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 (Projects\Process\Revenue) using the amount entered in the Funded Award Fee column in the Award Fee subtask of the Mods screen.
You can enter the funded value award fee in the Funded Award Fee column of the Award Fee subtask in the Mods 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 contract value of the project.
Enter a ceiling code for the contract total value of the project. Valid codes are "R" (Revenue), "B" (Billing), "A" (All), or "N" (None).
Enter a ceiling code for the awarded cost value of the project. Valid codes are "R" (Revenue), "B" (Billing), "A" (All), or "N" (None).
Enter a ceiling code for the contract fee value of the project. Valid codes are "R" (Revenue), "B" (Billing), "A" (All), or "N" (None).
This non-editable field displays the sum of all contract 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.
This non-editable field displays the sum of all contract cost modifications for this project branch and its lower levels.
This non-editable field displays the sum of all contract 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 Mods screen.
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 (Projects\Process\Revenue) using the amount entered in the Contract Award Fee column in the Award Fee subtask of the Mods screen.
You can enter the contract value award fee in the Contract Award Fee column of the Award Fee subtask in the Mods screen. The table window in that screen displays the contract award fees by modification number.
* A red asterisk denotes a required field.
Changes to this screen update the PROJ (Projects) table.
