Question: Create a spreadsheet to solve Problem 3. Determine over- and underbillings for a company with the following information: Job Number: 318 Job Name: Mountain Peak
Create a spreadsheet to solve Problem 3.
Determine over- and underbillings for a company with the following information:
Job Number: 318
Job Name: Mountain Peak Office Remodel
Current Contract Amount: $256,852
Total Estimated Cost at Completion: $225,236
Actual Costs to Date: $202,138
Total Billed: $252,253
Job Number: 319
Job Name: East Street Restaurant
Current Contract Amount: $350,199
Total Estimated Cost at Completion: $310,564
Actual Costs to Date: $152,364
Total Billed: $178,256
Job Number: 320
Job Name: Market Street Warehouse
Current Contract Amount: $55,123
Total Estimated Cost at Completion: $45,224
Actual Costs to Date: $5,211
Total Billed: $5,500
Step by Step Solution
3.35 Rating (167 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 (1782).xlsx
300 KBs Excel File
Study Help