Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Must be completed in Excel spreadsheet format A contractor has a contract to remove and replace the existing landscape and sidewalks around an office building.

Must be completed in Excel spreadsheet format

image text in transcribedimage text in transcribed

A contractor has a contract to remove and replace the existing landscape and sidewalks around an office building. The work includes demolition of the existing landscaping and sidewalks, importing fill and grading around the office building, constructing new concrete sidewalks, and new landscaping. The contractor uses the cost codes in Figure. The contractor will perform all of the work except placing the site concrete and the landscaping. The original estimate for the demolition was $30,000 and a $5,000 change order has been approved to remove some unexpected debris found during the demolition. The demolition work has been completed at a cost of $33,562. The original estimate for the fill and grading was $17,500 and a $2,000 change order for importing additional fill to replace the debris has been approved. The fill and grading costs to date are $17,264 and the estimated cost to complete has been estimated at $2,236. The original budget for the labor to pour the concrete was $19,200 and no changes have been made. The concrete labor has been subcontracted out for $19,200, for which the contractor has received a bill for $15,200. The original budget for the concrete for the sidewalks was $9,900 and no changes have been made. The contractor has spent $7,425 for concrete and estimates that $1,950 of concrete will be needed to complete the project. The original estimate for the landscaping was $37,500 and no changes have been made. The landscape work has been subcontracted out for $37,500. The landscaping work has yet to start and no bills have been received. Determine the total estimated cost at completion for the project and the variance for each cost code

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Maintenance Audits Handbook A Performance Measurement Framework

Authors: Diego Galar Pascual, Uday Kumar

1st Edition

1466583916, 978-1466583917

More Books

Students also viewed these Accounting questions

Question

10. What is meant by a feed rate?

Answered: 1 week ago