cost

profiledan12345
20180205195505example_estimating_project1.xlsx
Home>Business & Finance homework help>Accounting homework help>cost

Sheet1

29-Jan-17
Project Estimate - CE 410
Project Estimate - CE 410
ITEM: DESCRIPTION: ITEM COST
1 CONTRACTOR'S OVERHEAD $ 297,093
2 DIRECT CONSTRUCTION / SUB COSTS $ 192,976
SUBTOTAL $ 490,069
HOME OFFICE OVERHEAD @3% $ 14,702.06
SUBTOTAL $ 504,771
PROFIT @ 10% $ 50,477
SUBTOTAL $ 555,248
BOND @ 1.0% $ 5,552
TOTAL CONSTRUCTION COST $ 560,800

Sheet2

ITEM DESCRIPTION UNITS OF Number OF UNITS LABOR LABOR MATERIAL MATERIAL SUB/EQUIP SUB/EQUIP ITEM
UNIT TOTAL UNIT TOTAL UNIT TOTAL TOTAL
DIV SECTION COST COST COST COST
ESTIMATE DETAIL
2 02100 Excavate diesel contaminated soil CY 436.5 2.28 995.22 0 0 995.22
02100 Haul contaminated soil to landfill 6-8 miles CY 426.5 2.67 1138.755 0 0 1138.755
02100 Contamined soil disposal fee CY 426.5 52.14 22237.71 0 0 22237.71
02100 Fill excavated site from diesel CY 426.5 0.99 422.235 0 0 422.235
02100 Haul new soil 6-8 miles CY 426.5 2.67 1138.755 0 0 1138.755
02200 Clear and grub entire site ACR 0.6 3234.09 1940.454 0 0 1940.454
02200 Rough grading large area 300hp dozer CY 992.0 1.78 1765.76 0 0 1765.76
02200 Finish grading roadway and pad leveling MSY 0.7544 634.84 478.923296 0 0 478.923296
02200 Road subgrade and fine grading MSY 0.309 230.82 71.32338 0 0 71.32338
02200 Fill for excavated gravel CY 69.21 0.99 68.5179 0 0 68.5179
02200 Haul fill for excavated gravel CY 69.21 2.67 184.7907 0 0 184.7907
02200 Topsoil for grassed areas CY 160.0 34.66 5545.6 0 0 5545.6
02900 1" Bermuda sod MSY 13.0 359.97 4679.61 0 0 4679.61
4 04050 Brick face masonry SF 6000.0 0.63 3780 0 0 3780
04050 12" CMU Foundation Wall EA 675.0 2.33 1572.75 2.14 1444.5 0 3017.25
04050 12" CMU Regular Wall EA 570.0 3.09 1761.3 3.31 1886.7 0 3648
04050 Paint SF 6358.0 0.61 3878.38 0.2 1271.6 0 5149.98
5 05100 Structural Metal Framing W 18-35 TON 5.25 335.7 1762.425 3090.04 16222.71 0 17985.135
05100 Structural Metal Framing W 18-40 TON 19.42 335.7 6519.294 3090.04 60008.5768 0 66527.8708
05100 Structural Steel Tube Column TON 4.2 377.66 1586.172 2722.59 11434.878 0 13021.05
05050 Hangers EA 3.0 26.3 78.9 0 0 78.9
05050 Levelinf Plate Prewelded 0 0 0 0
05050 Bolt Connection 0 0 0 0
05050 Anchor Bolts 0 0 0 0
05050 Steel Pipe Bollards EA 2.0 64.68 129.36 79.63 159.26 0 288.62
05050 Frames for exhaust fans EA 4.0 0 92.23 368.92 0 368.92
05050 Metal Roof EA 120.0 0 45.98 5517.6 0 5517.6
TIES 0 0 0 0
2 02600 Erosion control netting 4' SY 288.9 1.45 418.905 0 0 418.905
02600 Precast catch basin 4'x4' EA 1.0 0 0 0 0
02600 12" class III rcp without gaskets LF 51.0 16.77 855.27 0 0 855.27
02600 18" class III rcp without gaskets LF 150.0 23.89 3583.5 0 0 3583.5
33 1000 1" diameter type K copper water dist LF 71.0 4.84 343.64 0 0 343.64
3000 4" PVC SDR 35 gasketed pipe LF 72.0 2.87 206.64 0 0 206.64
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
SUBTOTAL 67144.190276 98314.7448 0 165458.935076
TAXES / SUB MARKUP 30 20143.2570828 7.5 7373.60586 15 0
TOTAL 87287.4473588 105688.35066 0 $ 192,976

Sheet3

DIV SECTION ITEM DESCRIPTION UNITS OF LABOR LABOR MATERIAL MATERIAL EQUIP OR LUMP SUM EQUIP OR LUMP SUM ITEM
MEASURE # OF UNITS UNIT TOTAL UNIT TOTAL UNIT TOTAL TOTAL
COST COST COST W/O TAXES
s-1 CONTRACTOR'S OVERHEAD
s-1 CAD Technician/Draftsperson HR 24 85 2040 0 0 2040
s-1 Geotechnical Engineer HR 960 150 144000 0 0 144000
s-1 Architect SF 6790 1 6790 0 0 6790
s-1 Survey 3 Man Crew HR 24 160 3840 0 0 3840
s-1 Construction supervisor HR 960 58 55680 0 0 55680
s-1 Grade Surveying HR 24 160 3840 0 0 3840
s-1 Porta Potti MO 6 150 900 0 0 900
s-1 Construction Trailer MO 6 450 2700 0 0 2700
s-1 Safety Manager HR 960 35 33600 0 0 33600
s-1 Scissor lift to 25' rental MO 6 1588.6 9531.6 0 0 9531.6
s-1 Rolling scaffolding 14-20' MO 6 160.7 964.2 0 0 964.2
s-1 20 CY dumpster cost per dump EA 24 125 3000 0 0 3000
s-1 Fuel GAL 2400 1.75 4200 0 0 4200
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
TOTALS 271085.8 0 0 $ 271,086