cost estimation

 

excel and as much math and detail shown for each step to show work, as well as understand the process. My document attached is the assignment and there is a diagram provided as well as the supplemental information necessary to answer the question

CEM612 Construction Estimating
Spring 2017
Quiz #1 Pag

e1

The Section above is taken from a planned 50’ x 30’ (exterior dimensions) building to be built in Northern Maine.
Equipment Available:
Dump Truck – 12 cu. yd. max. volume, owned by the company (no cost charges to the project for use)
Hand Shovel – owned by the company (no cost charges to the project for use)
Loader/Backhoe – available for rent which includes delivery, fuel, and pick up at the jobsite
$50.00 / hour or a daily rate of $300.00 / day
Production Rates
Excavation: 12 cu. yd. / hour (bank)
Backfill: 18 cu. yd. / hour (loose)
Labor Available and wages:
Foreman (always onsite when someone is working): $40.00 / hour
Machine Operator: $30.00 / hour
Laborer: $10.00 / hour
Excavate and Backfill at 2 cu. yd. / hour (loose)
Soil Information Available:
Onsite soils (not suitable as backfill) Gavel (trucked onsite and dumped adjacent to work)
Sw: 20% Sw: 10%
Sh: 15% Sh: 10%
Disposal Charge: $0/yard (loose) Cost: $12/yard (bank)

CEM612 Construction Estimating
Spring 2017
Quiz #1 Pag

e2

Concrete placing
Footing waste: 4%
Wall waste: 2%
Note: The notch shown in the top of the wall to receive the slab is formed by placing 2-2×6’s in
the form.

The construction company pays typical federal taxes, insurance, and fringe benefits:

FICA: 6.2% up to $68,400
Med: 1.45%
Workers Comp.: 1.5% up to $25,000 of income
Fed. Unemployment: 2% up to $25,000 of income
State Unemployment: 0.5% up to $35,000 of income
Sick/Personal Time: 5 days per year
Holidays: 8 days per year
Vacation: Foreman – 3 Weeks per year; Operator and Laborer – hourly employee, no vacation
There is a strict company policy prohibiting overtime for hourly employees.

Canadian Dollar Exchange rates $(C)/$(US)

Day of Excavation 1.05
Day of Concrete Pour 0.95
Day of Backfilling 1.05

Determine

1. The effective hourly wage for each type of employee.
2. Determine the volume of excavation and number of truckloads required to remove it from the

site.
3. Determine the volume of backfill gravel required and truckloads required to deliver it.
4. Determine the cost to rent the backhoe for excavation and backfilling.
5. Determine the cost (excluding supervision) to undertake the excavation and backfilling with

manual labor.
6. Determine the necessary crew size to complete the work in the time undertaken by the

backhoe.
7. Determine the quantity of concrete required in the footing and walls.

Note: Show all work or submit a clear spreadsheet.