The Project/Dept Financial Forecast - Roll Up to Contract Base Currency
- Last UpdatedJan 02, 2024
- 3 minute read
The Roll Up to Contract Base Currency tab of the Project/Dept Financial Forecast displays total values for all contract base currencies used in the project/dept, with a total for all contracts shown converted to the project/dept base currency.
For each contract, the values of its individual communications have been rolled up into values in the contract base currency, using the currency rates defined in the Contract Configuration for that contract.
Organization currency rates are used to calculate the total for all contracts. To perform an ad hoc calculation using a different set of currency exchange rates, you can change the exchange rates used and recalculate the values. Note that these alternative exchanges rates are not stored in the system; they are used only for the purpose of performing this ad hoc calculation.
To view the Roll Up to Contract Base Currency tab:
-
Navigate to the Project/Dept Summary page for the project you want to work on.
-
Click
and select 
Financial Forecast from the menu.
The Financial Forecast page is displayed, showing the By Contract tab.
-
Click the Roll Up to Contract Base Currency tab.
-
To recalculate the exchange rates:
-
Enter the required conversion rates in the Currency Conversion field for the currency rates you want to update.
-
Click Recalculate.
-
The following fields are shown for each currency, and for the total of all currencies converted to the project/dept base currency.
|
Field ID |
Field |
Description |
Calculation |
|
Currency |
The currency of the values. |
||
|
A |
Approved Contract Expenditure |
The value of all communications in the Approved Contract Expenditure reporting category. |
|
|
B |
Pending Contract Expenditure |
The value of all communications in the Pending Contract Expenditure reporting category. |
|
|
C |
Potential Contract Expenditure |
The value of all communications in the Potential Contract Expenditure reporting category. |
|
|
D |
Remaining Contract Expenditure |
The approved contract commitment MINUS the approved contract expenditure. |
D = G - A |
|
E |
Contract Award Value |
The total award values of the contracts. |
|
|
F |
Approved Contract Changes |
The value of all communications in the Approved Contract Changes reporting category. |
|
|
G |
Approved Contract Commitment |
The contract award value PLUS the approved contract changes. |
G = E + F |
|
H |
Approved Contract Changes vs Contract Award Value (%) |
The approved contract changes as a percentage of the contract award value. |
H = F / E [as a percentage] |
|
I |
Pending Contract Changes |
The value of all communications in the Pending Contract Changes reporting category. |
|
|
J |
Pending Contract Commitment |
The approved contract commitment PLUS the pending contract changes. |
J = G + I |
|
K |
Potential Contract Changes |
The value of all communications in the Potential Contract Changes reporting category. |
|
|
L |
Potential Contract Commitment |
The pending contract commitment PLUS the potential contract changes. |
L = J + K |
|
M |
Not to Exceed Contract Value |
The total Not to Exceed value of the contracts; a financial commitment value related to the contract award value, which includes contingency for unplanned variations. |
|
|
N |
Approved Contract Budget |
The value of the approved budgets for the contracts, which can include internal costs unrelated to the contractor. |
|
|
O |
Approved Contract Expenditure vs Approved Contract Commitment (%) |
The approved contract expenditure as a percentage of the approved contract commitment. |
O = A / G [as a percentage] |
|
P |
Potential Contract Change vs Approved Contract Budget (%) |
The potential contract changes as a percentage of the approved contract budget. |
P = K / N [as a percentage] |
|
Q |
Potential Contract Commitment vs Not to Exceed Contract Value (%) |
The potential contract commitment as a percentage of the Not to Exceed contract value. |
Q = L / M [as a percentage] |