Question: Create a spreadsheet to solve Problem 4. Determine over- and underbillings for a company with the following information: Job Number: 311 Job Name: Smith Remodel
Create a spreadsheet to solve Problem 4.
Determine over- and underbillings for a company with the following information:
Job Number: 311
Job Name: Smith Remodel
Current Contract Amount: $22,530
Total Estimated Cost at Completion: $17,264
Actual Costs to Date: $16,538
Total Billed: $21,000
Job Number: 316
Job Name: Redd Remodel
Current Contract Amount: $35,624
Total Estimated Cost at Completion: $28,221
Actual Costs to Date: $22,345
Total Billed: $28,500
Job Number: 318
Job Name: Winter Remodel
Current Contract Amount: $17,954
Total Estimated Cost at Completion: $14,567
Actual Costs to Date: $4,562
Total Billed: $6,000
Job Number: 322
Job Name: Richardson Remodel
Current Contract Amount: $5,213
Total Estimated Cost at Completion: $3,721
Actual Costs to Date: $1,956
Total Billed: $0
Step by Step Solution
3.45 Rating (168 Votes )
There are 3 Steps involved in it
Costs Billings in Total Actual Costs Profits in Excess ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
246-B-F-F-M (1783).xlsx
300 KBs Excel File
Study Help