CALCULATE:

estimated costs to complete

estimated gross profit @ completion

current % complete

GP to date

earned revenue to date

cost and profit in excess of billings

billings in excess of costs and profits

phase

current year revenue to book

formulas would be helpful

Paste Font Alignment Number G4 x v fx Revenue Recognition Process Final Total Estimated Estimated Contract Cost @ Billings to Job Amount Costs to Date Completion Date 1027 297,482 290,349 290,349 297,482 1028 1,462,324 1,478,580 1,478,580 1,462,324 1029 6,770,156 7,187,389 7,169,543 6,693,717 2 3 4 5 Sheet1 Ready colost