Contract Forecasting Column Explanations









 


                                                                                                                       

1

Notes: A pencil and paper icon will show up in this column, if you have added a note to this line.

2

Attachments: A paper clip icon will show up in this column, if you have added an attachment to this line.

3

Freeze: Check the box in this column if you want to freeze the line and prevent any new transactions from updating it when you “Refresh” during the forecasting process.

4 Job Number

5

Phase Code

6

Phase Code Name

7

Category Code

8 Phase Type
9 Method: ("P" for Labor Productivity and "A" for Non Labor Productivity Items)

A

Current Cost Budget = Original Cost Budget + Posted Internal and External PCIs


1. The Current Cost Budget should be the estimated final cost at the end of the job, excluding unposted PCI Cost amounts in columns D and E (as adjusted in F)


2. If there are no unposted PCI Costs in columns B or C, the Current Cost Budget should be equal to, or greater than, the Spent/Committed Total


3. At the end of the job, the Current Cost Budget and the Spent/Committed Total should be the same for each line (since unposted PCIs will be 0, this will also equal the Cost Forecast)


4. NCTOs can be posted as frequently as needed to manage the Current Cost Budget and reduce the need for overrides to the Cost Forecast

B

Spent/Committed (Less Advance SCOs): Committed Amounts + Amounts Spent Outside Commitments - Any advanced SCOs issued to Subcontractors (Advanced SCOs occur when a SCO is issued prior to posting a PCI/OCO) **THIS IS NOT A BEST PRACTICE**

C

Spent/Committed Total: Committed Amounts + Amounts Spent Outside Commitments
10 Current Period Cost: Costs hitting your project only for the current month period

D

Unposted Internal PCI Cost Budget: Unposted Internal PCIs (NCTO, BC) (This column does not reflect any adjustments that may have been made in PCI Projections.)

E

Unposted External PCI Cost Budget: Unposted External PCIs (CTO, ALLOW, CONT, TRANSFER) (This column does not reflect any adjustments that may have been made in PCI Projections.)

F

Unposted Int & Ext PCI Cost Budget Adjusted: Equals columns D + E, unless adjustments have been made in PCI Projections. If so, those adjustments are reflected in this column.

G

Cost to Complete:

    1.  If Current Cost Budget (A) is higher than Spent/Committed Total (C)  the calculation is:     A - B = Cost to Complete 
    2.  If Current Cost Budget (A) is lower than Spent/Committed Total (C) the calculation is:        Cost to Complete = 0    

       (The system is going to assume you are done since you spent more money than you budgeted)

11

Cost Detail Pop Up: The magnifying glass is in this column that will allow you to open the Cost to Complete Detail Pop Up

12

Override Visual: A checkmark will appear in this box, if the Cost to Complete column N has been overridden.

H

Cost to Complete Unposted PCIs: This should equal the Unposted Int & Ext PCI Cost Budget (Adjusted) column F, unless there has been an Advanced SCO given.  (NEVER best practice)

I

Cost Forecast: Calculation:   Spent/Committed Total + Cost to Complete + Cost to Complete Unposted PCIs = Cost Forecast.   (C+G+H)  

This should be looked at on a line by line basis and always reflect where you expect to be by the end of the project.

13

Override Visual: A checkmark will appear in this box, if the Cost Forecast in column R has been overridden

J

 Current Revenue Budget = Original Revenue Budget + Posted External PCIs (CTO, ALLOW, CONT, TRANSFER)

K

Unposted PCI Revenue Budget: Unposted External PCIs (CTO,ALLOW,CONT, TRANSFER)

L

Unposted PCI revenue Budget Adjusted: Equals column K, unless adjustments have been made in PCI Projections. If so, those adjustments are reflected in this column.

M

Revenue Forecast: Columns J +L (Can be overridden)

14

Override Visual: A checkmark appears in this box, if the Revenue Forecast in column Q has been overridden.

N

Projected Gain/Loss: Columns M - I


Contract Forecasting Highlighting Explanations

Field Color Hover Text
Cost to Complete (CTC) Yellow Cost to complete has detail lines






Field Color Hover Text
Cost to Complete (CTC) Red Cost to Complete Detail lines are not in sync with the Projected Cost
Cost Forecast Orange Projected Cost exceeds the override from the previous forecast
Cost Forecast Red The override from the previous stored forecast has been cleared
Cost Forecast Yellow
When the Spent/Committed Total amount is greater than the Current budget (Cost) amount and there isn't an override by the user





Field Color Hover Text
Cost Forecast Green When there is a previous period override for the line