Revenue forecasting columns
The revenue forecasting data exists in the CBS and Pay Item registers as shown in the following images:
The following table shows an overview of the revenue forecasting columns.
Columns |
Register |
Description |
---|---|---|
Forecast total revenue |
CBS and Pay Items |
This is your expected final revenue at completion. The calculations vary by assigned billing method. This value is based on the Pay item’s final revenue * a percentage that can be earned by the cost item. |
Forecast total cost |
CBS and Pay Items |
Total cost (to date) + Forecast remaining cost. |
Revenue forecast method |
Pay Items |
For Fixed Final Price, you can select Default and Manual. For Cost Plus, you can select from Earned, Billed, and Manual. The roll-up revenue forecast method is automatically assigned for parent pay items, and not editable, as all forecast revenue for child pay items rolls up to the parent pay item. |
Billed revenue |
Pay Items |
Amount billed to the client for a single pay item. |
Fixed final price |
Pay Items |
Lump sum billing method (price agreed upon by a contractor and a client does not change without a contract order). |
Forecast % margin |
CBS and Pay Items |
Forecast final margin / forecast final revenue. |
Forecast total margin |
CBS and Pay Items |
Forecast final revenue – Forecast final cost. This is the total profit you’re forecasting to make at completion of the job. |
Forecast remaining revenue |
CBS |
Forecast final revenue – Forecast revenue earned, revenue remaining to earn. |
Forecast revenue unit cost |
CBS and Pay Items |
Forecast final revenue / Forecast take-off quantity, amount of revenue earned per quantity. |
Forecast revenue earned |
CBS |
% complete * Forecast final revenue. This is revenue that is earned based on completion of work. |