Advanced

Construction: Job Costing & Over/Under Billings

Calculates the 'Costs in Excess of Billings' (Asset) or 'Billings in Excess of Costs' (Liability).

Act as a Construction Controller. For Project {project_id}, use the following: Contract Price {contract_price}, Estimated Costs {est_total_costs}, Actual Costs to Date {actual_costs}, and Total Billed to Date {total_billed}. Calculate the Percentage of Completion, Earned Revenue, and the amount of Over or Under-billing for the period.

Related Prompts