Billing Item Analysis Report - Report Calculations (Expanded, Proj. Cost = Yes)

Contract

Field

Description

Quantity

The original contract quantity for each billing item displays from Contracts.

U/m

The unit-of-measure for each billing item displays from Contracts.

Unit Price

The unit price for each billing item displays from Contracts.

Amount

The dollar amount for each billing item displays from Contracts. This figure is calculated as the product of the quantity and unit price.

Current Period

Field

Description

Quantity

For each billing item, the quantity used during the current period displays.

Revenue

For each billing item, the revenue for the current period displays.

Cost

For each billing item, the cost for the current period displays.

Gain (Loss)

For each billing item, the gain or loss for the current period displays. This figure is calculated as the difference between the two preceding columns, that is, revenue less cost.

Job-to-Date

Field

Description

Quantity

For each billing item, the quantity used to date on this job displays.

Revenue

For each billing item, the revenue to date on this job displays.

Cost

For each billing item, the cost to date on this job displays.

Gain (Loss)

For each billing item, the gain or loss to date on this job displays. This figure is calculated as the difference between the two preceding columns, that is, revenue less cost.

Projected Cost

Field

Description

Quantity

For each billing item, the projected quantity displays from the Contracts screen.

Revenue

For each billing item, the projected revenue displays.

Cost

For each billing item, the projected cost displays.

Gain (Loss)

For each billing item, the projected gain or loss displays. This figure is calculated as the difference between the two preceding columns, that is, revenue less cost.