Below are the commonly used project types.
Normal (N)
The JTD Margin is calculated using the percentage of Cost Completion applied to the FFM, subject to any Profit Taking Threshold defined.
If a Loss Job is forecast (negative Forecast Final Margin), then 100% of the loss is recognised, irrespective of the level of In-stage completion achieved. A Loss Provision is calculated by the system.
JTD Margin = (CWIP/FFC) * FFM if FFM is positive
JTD Margin = FFM if FFM is negative.
Original Contract values and variation and scope changes are included in Order Intake Analysis.
Load on Values (L)
When first implementing the BFM Contract Valuation module a frequent requirement is to allow client supplied JTD Margin and WIP Project Values to be loaded. The "L" – Load on Values project type is supplied for this purpose.
There is no validation on Project Locking so unallocated Work in Hand values can exist.
The JTD Margin is calculated as the difference between JTD Turnover (JTD Revenue, Under/Over claim, WIP) and Cost of Work in Progress (CWIP).
This BFM Project type can be used if there is no requirement to calculate a WIP journal.
Original Contract values and variation and scope changes are included in Order Intake Analysis.
JTD Recognition (J)
The JTD Margin is calculated as the difference between JTD Turnover (JTD Revenue, Under/Over claim, WIP) and Cost of Work in Progress (CWIP), unless
- a Loss has been forecast (a).
- the Cost Percentage Completion is 100% complete (b).
If either (a) or (b) occur, then 100% of FFM is brought to account.
Original Contract values and variation and scope changes are included in Order Intake Analysis.
Revenue (Billings) (R)
The JTD Margin is calculated using the percentage of Revenue (Claimed plus Over/Under claims) completion applied to the FFM, with consideration of any Profit Taking Threshold defined (see Profit Taking Threshold Maintenance).
If a Loss Job is forecast (negative Forecast Final Margin), then 100% of the loss is to be recognised, irrespective of the level of In-stage completion achieved.
This will generate a Cost Accrual against the Job (no cost centre involved). The value can be seen in the Cost option in the Actions button.
Original Contract values and variation and scope changes are included in Order Intake Analysis.
Cost Collector (C)
This can be used for projects where no revenue is processed and the project structure is used only to collect and manage costs. The Cost of Work in Progress (CWIP) recorded to date is brought to account as effectively, a negative Gross Margin impact.
The forecast at completion information relating to a cost collector is still recorded to allow forecast projection of anticipated future costs, but the FFM does not impact the JTD Margin calculation.
If there is Forecast Final Revenue on the project, then this BFM project type will revert to the same calculations as N.
If there is revenue on the project, then a WIP entry to reverse the revenue is automatically produced.
This project type is excluded from Order Intake Analysis.
Parent Projects (Z)
This project type is used only with Parent Projects. It indicates that the parent will be the sum of the Child projects, which can be any project type. The only WIP transaction at a Parent Project Level is Loss Provision, where the sum of the FFM at the Parent Project Level is negative.
Exclude (X)
This project type completely excludes a Jobpac project from all BFM processing. This should only be used for projects that do not contribute to Direct Cost and Revenue component of the P&L. It should never be used for projects that have contributed to Direct Costs and Revenue in the past. These projects should be set to Project Type L and then set to Financially Complete.