Create a spreadsheet to solve Problem 1. A contractor has a contract to construct the sanitary sewer,

Question:

Create a spreadsheet to solve Problem 1.

A contractor has a contract to construct the sanitary sewer, water line, storm drain, and street lighting for a new subdivision. The contractor uses the cost codes in Figure 2-6. The original estimate for the sewer was $25,000 and a $3,200 change order has been approved to add a manhole. The sewer work has been completed at a cost of $27,365. The original estimate for the water line was $31,000 and no changes have been made to the budget. The costs to date for the water line are $31,300 and it is estimated that it will take another $450 to complete the water line. The original estimate for the storm drain was $17,000 and no changes have been made to the budget. The contractor has paid $7,236 for materials and estimates that it will cost $9,764 to install the storm drain. The original estimate for the outside lighting was $23,600 and no changes have been made to the budget. The contractor has subcontracted the outside lighting for $23,600. The subcontractor has billed $11,230 for materials. Determine the total estimated cost at completion for the project and the variance for each cost code.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: