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.