Revenue forecasting columns

The revenue forecasting data exists in the CBS and Pay Item registers as shown in the following images:

  • CBS register revenue columns:

  • Pay Item register revenue columns:

The following table shows an overview of the revenue forecasting columns.

Overview – 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.