|
COST DISTRIBUTION SPREADSHEET d~
<br />FINAL-ASSESSMENT y~ ~r~ ~ ~~
<br />2/5/2008 ~~ ~ ` ,~ i~, .~~
<br />JOB NAME: 6th Ave Alley ,/ _ ,~
<br />DESCRIPTION: ~j ~ ~ tf~, a ~ ,~.~
<br />JOB #: 4527 l~ ~ ~ ~' ~~ i~, ~~ ,
<br />CONTRACT: ~~~ j ~ d ~'~°~ ~
<br />BY: John Bonham ! ~ ~~
<br />CK: ~~~ ~rl ~ 1ff.(
<br />~~v ~~~ ,~~'V
<br />Bid Schell.
<br />Item Description QTY Unit Unit Cost Total Paving CityWW City Storm Clty Pave Total
<br />40 8 inch Sub rade stabilization 154.00 s $16.25 $ 2,502.50 $ 2,502.50 $ 2,502.50
<br />50 72 inch Saddle manhole over ex pipe 1.00 each $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 5,000.00
<br />60 Catch Basin 1.00 Each $1,345.00 $ 1,345.00 $ 1,345,00 $ 1,345.00
<br />70 minor adjustments of manholes 1.00 Each $300.00 $ 300.00 $ 300.00 $ 300.00
<br />80 General Excavation 205.00 CY $10.00 $ 2,050.00 $ 2,050.00 $ 2,050.00
<br />90 12 inch Storm Sewer Pi a 168.00 Each $48.00 $ 8,064.00 $ 6,000.00 $ 2,064.00 $ 8,064.00
<br />100 10 Inch Storm Sewer Pipe 11.00 feet $48.00 $ 528.00 $ 528.00 $ 528.00
<br />110 8 inch pvc wastewater pipe 367.00 feet $57.00 $ 20,919.00 $ 20,919.00 $ 20,919.00
<br />120 wastewater service, 6" 56.00 feet $40.00 $ 2,240.00 $ 2,240.00 $ 2,240.00
<br />130 water quali structure 1.00 Each $9,700.00 $ 9,700.00 $ 9,700.00 $ 9,700.00
<br />140 level 2,112 inch Bence hmac 25.00 ton $150.00 $ 3,750.00 $ 3,750.00 $ 3,750.00
<br />150 plain concrete pavement, undowelled, 7"thick 5164.00 SQFT $5.60 $ 28,918.40 $ 28,918.40 $ 28,918.40
<br />160 topsoil 1.50 cud $100.00 $ 150.00 $ 150.00 $ 150.00
<br />
<br /> EST•
<br /> EST
<br /> INSERT ESTIMATES ABOVE THIS LINE
<br /> Sub-Total `; 85,466.90 S 51,343.90 $ 23,159,00 ~ 7,064.00 $ 3,900.00 $ 85,466.90
<br /> 60.07% 27,10% 8.27% 4.56% 100.00%
<br />
<br />10 MOBILIZATION 1 Lumpsum $ 10,000.00 $ 10,000.00 $ 6,007.46 $ 2,709.70 $ 826.52 $ 456.32 $ 10,000.00
<br />20 TPDT 1 Lumpsum $ 4,000.00 $ 4,000.00 $ 2,402.98 $ 1,083.88 $ 330.61 $ 182.53 $ 4,000.00
<br />30 Erosion Control 1 Lumpsum $ 650.00 $ 650.00 $ 390.48 $ 176.13 $ 53.72 $ 29.66 $ 650.00
<br />
<br /> EST-
<br /> EST
<br /> INSERT ESTIMATES ABOVE THIS LINE
<br /> ConfractorTotal $ 100,116.90 $ 60,144,83 ~ 27,128.72 $ 8,274.85 ~ 4,568.50 $ 100,116.90
<br /> 60.07% 27.10% 8.27% 4.56% 100.00%
<br />
<br /> TESTING $ 1,200.00 720.90 $ 325.16 $ 99.18 $ 54.76 $ 1,200.00
<br /> ADVERTISING $ 600.00 $ 360.45 $ 162.58 $ 49.59 $ 27.38 $ 600.00
<br /> EROSION PERMIT FEES $ - $ - $ - $ - $ - $ -
<br /> CONTINGENCY $ 10,011.69 $ 6,014.48 $ 2,712.87 $ 827.49 $ 456.85 $ 10,011.69
<br />
<br /> Ties to GL AS OF DATE,
<br /> EST-
<br /> EST
<br /> EST-
<br /> INSERT ESTIMATES ABOVE THIS LINE
<br /> Total Direct Costs - includin Estimates $ 111,928.59 $ 67,241.26 5 30,329.61 $ 9,251.19 ~ 5,107.53 $ 111,929.59
<br /> 60.08% 27.10% 8.27% 4.56% 100.00%
<br />
<br /> ENGINEERING CHARGE 43% $ 48,000.00 $ 28,836.07 $ 13,006.70 $ 3,967.33 $ 2,190.34 $ 48,000.43
<br /> ADMIN FEE 5% $ 5,596.43 $ 3,362.06 $ 1,516.48 $ 462.56 $ 255.38 $ 5,596.48
<br /> CONSTRUCTION FINANCING 3.511980% LUMPSUM $ 3,930.91 $ 3,930.91 $ 2,361.50 $ 1,065.17 $ 324.90 $ 179.38 $ 3,930.94
<br />
<br /> TOTAL $ 1fi9,455.93 $ 101.800.89 ~ 45,917.96 $ 14,005.97 S 7,732.62 $ 169,457.44
<br />OF DIRECT CITY COSTS ~1n9.v~ ~RjS '~ \vi ~ ~ ~~ }~
<br />ENGINEERING CHARGES OVER 23%
<br />DISTRIBUTE ACROSS CITY COSTS J ' ~ n, ~~ ~ ~
<br />GRAND TOTALS $ 169,455.93
<br />0.678692011 0.207015729 0.11429226 $ 1.00
<br />$0.00 $0.00 $0.00 $0.00
<br />$ 45,917.96 S 14,005.97 ~ 7,732.62 $ 169,457,44
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />100.00%
<br />$ -
<br />$ -
<br />
<br />$ 1.00
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ -
<br />$ 1.00
<br />$ 1.00
<br />$ 0.43
<br />$ 0.05
<br />$ 0.03
<br />6 1.51
<br />
|