number 12 only

60 CHAPTER FOUR Code Description Cost To Date 1100 Supervision 7,985 1700 1,615 Total Estimated Cost at Completion: $17,264 Actual Costs to Date: $16,538 Total Billed: $21,000 Temporary Utilities 3300 Footing and Foundation-Labor 3,685 Job Number: 316 3400 Footing and Foundation-Concrete 3,321 3450 Concrete Pump 1,569 3500 Slab/Floor-Labor 1,896 3600 Slab/Floor-Concrete 6,955 3900 Rebar 4100 Masonry 31100 Grading and Excavation FIGURE 4-15 Cost for Problem 10 999 36,000 3,150 prorated over the life of the project. The pouring of the footings, foundations, and floor slab are complete. 12. 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 13. Determine over- and underbillings for a company with the following information: Job Number: 311 Job Name: Smith Remodel Current Contract Amount: $22,530 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 14. Using the chart of accounts in Figure 2-1, determine the changes to the balance sheet, income statement, job cost ledger, and equipment ledger as a result of recording the over- and underbillings from Problem 12. The balance sheet from the beginning of the month had $5,716 costs and profits in excess of billings and $17,235 in bil- ings in excess of costs and profits. 15. Using the chart of accounts in Figure 2-1, determine the changes to the balance sheet, income statement, job co ledger, and equipment ledger as a result of recording the over- and underbillings from Problem 13. The balance sheet from the beginning of the month had $1,562 costs and profits in excess of billings and $2,125 in bil- ings in excess of costs and profits. 16. Create a committed cost spreadsheet like the one Figure 4-1. Use the spreadsheet to solve Problems through 11. 17. Create a work on hand worksheet like the one in Figur 4-3. Use the spreadsheet to solve Problems 12 and 13