Estimate against actual: variance and margin on one job

Price

Contract price (USD)

Change order revenue, priced (USD)

Overhead rate (USD per labour hour)

Labour

Estimated hours

Estimated loaded rate (USD per hour)

Actual hours, original scope

Actual loaded rate (USD per hour)

Change order hours

Other direct costs (USD): estimate, actual on original scope, change order

Materials: estimate

Materials: actual

Materials: change order

Subcontractors: estimate

Subcontractors: actual

Subcontractors: change order

Equipment: estimate

Equipment: actual

Equipment: change order

Every starting value is invented, not survey or vendor data. Variance is actual minus estimate: a positive number is over the estimate (unfavourable), a negative one is under (favourable). Overhead is allocated as the rate times labour hours, so it moves with hours and is not extra cash spent. The labour split uses the original-scope hours and rates. Type 2500 or 2,500; 2.5 and 2,5 are read as decimals; 1.000 is rejected as ambiguous.