COST DISTRIBUTION SPREADSHEET <br />PRE-ASSESSMENT <br />10131/02 <br />JOB NAME: GARDEN WAY <br />DESCRIPTION: <br />JOB #: 3502 <br />CONTRACT: <br />BY: DAN KEPLEY <br />CK:STEVE GALLUP <br /> sli uyioui_ u m a-w-v M~ <br />~- _ _ <br />~ <br />• <br />' I <br />r i i,:l <br />Uid ` i I <br />i ~ - i <br />lh i~ <br />quit Jost <br />- <br />i, ni <br />I i, rr, <br />_~~~~ i <br />rfun I .,. <br />I i J . , ,. <br />C~tylh ~:~~ <br />i m <br />. ~ <br />„ <br />~ <br /> <br />I _ <br />i _ - - au <br />$ a8 <br />79'S <br />60 CURB & GUTTER, STD 8, 1st LINFT $ 6.00 $ 48,793.80 $ 4a,79s.au , <br />. <br />320 <br />80 <br />$ 7 <br />80 CURB & GUTTER, STD REVERSED 915 LINFT $ 8.00 $ 7,320.80 $ 7,320.80 . <br />, <br />30 00 <br />3 <br /> <br /> <br />55 <br />81 VALLEY GUTTER,STD <br /> <br />LINFT <br /> <br />fi.00 <br />$ 330.00 <br /> <br />$ <br />D <br />$ 330.0 <br /> <br /> <br /> <br />116,640.00 <br />100 CONCRETE 4" 59,420 SOFT $ 2.00 $ 118,840.00 $118,840.00 523.06 <br />$ 24 <br />120 CONCRETE 5" 6,202 SOFT $ 2.99 $ 24,523.06 $ 24,523.08 , <br />$ 1,313.90 <br />130 CONCRETE 7" 375 SOFT $ 3.50 $ 1,313.90 $ 1,313.90 517.72 <br />$ 62 $ 64,236.76 <br />140 9"CONCRETE 20,799 SOFT $ 4.05 $ 84,236.76 $ 21,719.04 , <br />967.80 <br />$ 7 $ 7,967.80 <br />160 CROSS WALK- CONCRETE COLOR 3,984 SOFT $ 2.00 $ 7,967.80 , <br />704.80 <br />$ 4 $ 4,704.80 <br />ROUNDABOUT- CONCRETE COLOR 2,352 SOFT $ 2.00 $ 4,704.80 , 50 <br />$ 2 <br />243 <br />180 CR 4" DEPTH 641 SOYD $ 3.50 $ 2,243.50 $ 1,574.50 $ 669.00 , <br />. <br />$ 2,000.00 <br />200 CURB & GUTTER, REMOV 250 LINFT $ 8.00 $ 2,000.00 $ 2,000.00 270.00 <br />$ 4 $ 183,330.00 <br />220 AC 7" DEPTH 6,111 TON $ 30.00 $ 183,330.00 $ 178,460.00 $ 600.00 , <br />104 <br />00 <br />$ 3 603.52 <br />$ 155 <br />240 CR 16" DEPTH 20,052 SOYD $ 7.76 $ 155,603.52 $ 151,999.52 $ 500.00 , <br />. , <br />029.00 <br />$ 22 <br />260 GEOTEXTILE FABRIC 22,029 SOYD $ 1.00 $ 22,029.00 $ 21,979.00 $ 50.00 00 <br />$ 960 , <br />00 <br />$ 100 <br />768 <br />280 EXCAVATION, UNCLASSIFIED 12,596 CUYD $ 8.00 $ 100,768.00 $ 98,618.00 $ 500.00 $ 690.00 . , <br />. <br />$ 7,000.00 <br />300 EXCAVATION, OVER 1,000 CUYD $ 7.OD $ 7,000.00 $ 7,000.00 $ 1,000.00 <br />320 TREE PROTECTION 1 LUMPSUM $ 1,000.00 $ 1,000.00 $ 1,000.00 400.00 <br />$ 30 <br />330 SAN SEWER SERVICE (STD 16 EACH $ 1,900.00 $ 30,400.00 $ 30,400.00 , <br />$ 93 <br />760.00 <br />340 SEWER PIPE 8" 2,344 LINFT $ 40.00 $ 93,760.00 $ 93,760.00 , <br />930 <br />00 <br />$ 24 <br />350 SEWER PIPE 10" 554 LINFT $ 45.00 $ 24,930.00 $ 19,944.00 $ 4,986.00 . <br />, <br />$ <br />360 SEWER PIPE 12" 0 LINFT $ 75.00 $ - $ - $ - <br />$ _ <br />$ <br />370 DRAIN PIPE PVC 16" 0 LINFT $ 25.00 $ - 05G.00 <br />$ 1 $ 1,050.00 <br />380 DRAIN PIPE PVC 21" 35 LINFT $ 30.00 $ 1,050.00 , <br />200.00 <br />$ 64 $ 84,200.00 <br />390 DRAIN PIPE PVC 12" 3,368 LINFT $ 25.00 $ 84,200.00 , $ 23,400.00 <br />400 DRAIN PIPE PVC 10" 936 LINFT $ 25.00 $ 23,400.00 $ 23,400.00 $ 9 <br />234.00 $ 9,234.00 <br />410 DRAIN PIPE RCCP 30" 162 LINFT $ 57.00 $ 9,234.00 , <br />000.OD <br />$ B $ 6,000.00 <br />420 MH 4"- 24" PIPE -STM 4 EACH $ 2,000.00 $ B,000.OD , <br />000.00 <br />$ 22 $ 22,000.00 <br />430 MH 4"- 24" PIPE -FLAT TOP STM 11 EACH $ 2,000.00 $ 22,000.00 , <br />000.00 <br />$ 10 $ 10,000.00 <br />440 MHs -BAY SAVER UNIT 1 EACH $ 10,000.00 $ 10,000.00 , 000.00 <br />$ 18 <br />450 MH4"-24"PIPE-SAN 9 EACH $ 2,000.00 $ 18,000.00 $ 18,000.00 , <br />000.00 <br />$ 2 <br />460 MH 4"- 24" PIPE -FLAT TOP SAN 1 EACH $ 2,000.00 $ 2,000.00 $ 2,000.00 , <br />$ 30,000.00 <br />470 CURB INLET 4A 30 EACH $ 1,000.00 $ 30,000.00 $ 30,000.00 864.00 <br />$ 3 $ 4,600.00 <br />460 TV INSPECTION-STM 4,600 LINFT $ 1.00 $ 4,800.00 $ 936.00 , 898 <br />00 <br />$ 2 <br />490 TV INSPECTION-SAN 2,898 LINFT $ 1.00 $ 2,896.00 $ 2,579.22 $ 318.76 . <br />, <br />$ 1,000.00 <br />500 SIGN, REMlREPL 10 EACH $ 100.00 $ 1,000.00 $ 1,000.00 000.00 <br />$100 $ 100,000.00 <br />510 LIGHTING 1 LUMPSUM $ 100,000.00 $ 100,000.00 , $ 20,350.00 <br />511 RETAINING WALL 925 SOFT $ 22.00 $ 20,350.00 $ 20,350.00 00 <br />$130 <br />000 $ 130,000.00 <br />520 CENTENNIAL SIGNAL IMPROVEMENTS 1 LUMPSUM $ 130,000.00 $ 130,000.00 , <br />. $ 500.00 $ 500.00 <br />530 BOLLARD 1 EACH $ 500.00 $ 500.00 $ 4,334.40 $ 4,334:40 <br />CENTENNIAL CURB & GUTTER- STD 722 LINFT $ 6.00 $ 4,334.40 $ 16,680.00 $ 16,680.00 <br />CENTENNIAL CONCRETE 4" 8,340 SOFT $ 2.00 $ 16,680.00 600.00 <br />$ 7 $ 7,600.00 <br />540 CENTENNIAL GUARDRAIL 360 LINFT $ 20.00 $ 7,600.00 000.00 <br />$ 3 , $ 3,000.00 <br />550 CENTENNIAL CURB INLET 4A 3 EACH $ .1,000.00 $ 3,000.00 , <br />52.00 <br />$ 11 $ 11,525.00 <br />560 CENTENNIAL DRAIN PIPE PVC 10" 461 LINFT $ 25.00 $ 11,525.00 , $ 3,050.00 $ 3,050.00 <br />570 CENTENNIAL SAWCUT 1,525 LINFT $ 2.00 $ 3,050.00 $ 10,000.00 <br />580 TRAFFIC MARKINGS 1 LUMPSUM $ 10,000.00 $ 10,000.00 $ 10,000.00 $ 2,000.00 <br />590 MAILBOX-R!R _.- 20 EACH $ 100.00 $ 2,000.00 $ 2,000.00 00 <br />$ 12 <br />144 <br />600 MEDIAN - 21"DEPTH LOAM BACKFILI 1,012 CUYD $ 12.00 $ 12,144.00 $ 12,144.00 , <br />. <br />755 <br />00 <br />$ 2 <br />610 MEDIAN - 3" DEPTH SPECIFIED MULCH 145 CUYD $ 19.00 $ 2,755.00 $ 2,755.00 . <br />, <br />00 <br />$ 5 <br />474 <br />620 MEDIAN PLANTING -TREE (1-112" Cal. 34 EACH $ 161.00 $ 5,474.00 $ 5,474.00 , <br />. <br />677 <br />00 <br />$ 1 <br />630 MEDIAN PLANTING-SHRUBS 5 al 78 EACH $ 21.50 $ 1,677.00 $ 1,677.00 . <br />, <br />75 <br />$ 3 <br />136 <br />640 MEDIAN PLANTING - SHUBS (2 gal 225 EACH $ 13.95 $ 3,138.75 $ 3,138.75 , <br />. <br />10 <br />$ 2 <br />552 <br />650 MEDIAN PLANTING - SHRUBSIPERENNIALS 1 al 362 EACH $ 7.05 $ 2,552.10 $ 2,552.10 , <br />. <br />00 <br />$ 872 <br />660 MEDIAN PLANTING-BULBS 1 LUMPSUM $ 672.00 $ 872.00 $ 872.00 . <br />250 <br />00 <br />$ 56 <br />670 MEDIAN IRRIGATION 1 LUMPSUM $ 56,250.00 $ 56,250.00 $ 56,250.00 . <br />, <br />748 <br />00 <br />$ 2 <br />680 PLANTER STRIP-TOPSOIL3"DEPTH) 229 CUYD $ 12.00 $ 2,748.00 $ 2,748.00 . <br />, <br />00 <br />$ 4 <br />351 <br />690 PLANTER STRIP- BARK MULCH (3" DEPTH THROUGHOUT 229 CUYD $ 19.00 $ 4,351.00 $ 4,351.00 , <br />. <br /> ~ <br /> __ - --. <br />Sub-Total _ - <br />$ 1;536,678.21 - -. - <br />6~~0,829.86 _- <br />$14a,6~b98. <br />1$ i,yau.ov i <br />$13n,~adL2 <br />$3U,4W.OD. <br />$ 5,304.10 <br />~' $ ~u,aYl.' o <br />y~~~~x~JO <br />- W ..::.i,~ <br />1 <br />4049EcA! .98,17. 1 <br /> <br />10 MOBILIZATION 1 LUMPSUM $ 110,000.00 $ 110,000.00 $ 44,383.08 $ 10,342.95 $ 141.55 $ 9,742.88 $ 2,173.29 $ 379.24 $ 7,194.86 $ 16,442.68 $ 10,926.88 $ 5,375.35 $ 2,895.23 $ 110,000.00 <br />20 CLEARING&GRUBBING 1 LUMPSUM 000.00 <br />$ 7 $ 7,000.00 $ 2,824.38 $ 656.19 $ 9.01 $ 620.00 $ 136.30 $ 24.13 $ 457.86 $ 1,046.35 $ 655.47 $ 342.07 $ 18424 $ 7,000.00 <br />30 TEMP PROTECTNlDIRECTN 1 LUMPSUM , <br />$ 10,000.00 $ 10,000.00 $ 4,034.83 $ 9.10.27 $ 12.87 $ 885.72 $ 197.57 $ 34.48 $ 654.08 $ 1,494.79 $ 993.53 $ 486.67 $ 263.20 $ 10,000.00 <br />40 EROSION CONTROL 1 LUMPSUM $ 5,000.00 $ 5,000.00 $ 2,017.41 $ 470.13 $ 6.43 $ 442.86 $ 98.79 $ 17.24 $ 327.04 $ 747.39 $ 496.77 $ 244.33 $ 131.60 $ 5,000.00 <br />50 SPECIAL SIGNS 2 EACH $ 500.00 $ 1,000.00 $ 403.48 $ 94.03 $ 1.29 $ 88.57 $ 19.76 $ 3.45 $ 65.41 $ 149.48 $ 99.35 $ 48.87 $ 26.32 $ 1,000.00 <br />620 (LAGGING 1,500 HOUR $ 27.00 $ 40,500.00 $ 16,341.04 $ 3,808.09 $ 52.12 $ 3,587.15 $ 800:17 $ 139.63 $ 2,649.02 $ 6,053.90 $ 4,023.82 $ 1,979.11 $ 1,065.97 $ 40,500.00 <br /> <br /> Conl[acfTofal a I,7i2,178.21 a x59,834.09 $160900.63 $. 2,203.26 $151,65040 I `. 33,827.88 $ 5,902.94 $ 111,989.91 $255,934.60 $170,110;82 $ 83,668.71 $ 45,064.96 $1,712,17821 <br />_ <br /> CONTINGENCIES 10°/ $ 171,217.82 $ 69,063.41 $ 16,099.06 $ 220.33 $ 15,165.04 $ 3,362.79 $ 590.29 $ 11,198.99 $ 25,593.46 $ 17,011.08 <br />11 <br />1 <br />7 <br />1 $ 8,366.67 <br />$ 836 <br />69 $ 4,506.50 <br />65 <br />$ 450 $ 171,217.82 <br />121 <br />78 <br />$ 17 <br /> TESTING 1 % $ 17,121.78 $ 6,908.34 $ 1,609.91 $ 22.03 $ 1,516.50 $ 336.28 $ 59.03 $ 1,119.90 $ 2,559.35 , <br />0 <br />. <br />$ . . . <br />, <br /> PERMITS 1 LUMPSUM 000.00 <br />$ 2 $ 2,000.00 $ 806.97 $ 186.05 $ 2.57 $ 177.14 $ 39.51 $ 6.90 $ 130.82 $ 298.96 $ 198.71 $ 97.73 $ 52.64 $ 2,000.00 <br /> , ~ $ 75,000.00 $ 75,000.00 <br /> EWEBTRANSMISSIONPOLES <br />RIGHT OF WAYACOUISITION 3 <br />1 EA <br />LUMPSUM $ 25,000.00 <br />$500,000.00 $ 75,000.00 <br />$ 500,000.00 $ 201,741.29 $ 47,013.40 $ 643.41 $ 44,285.81 $ 9,878.61 $ 1,723.81 $ 32,703.93 $ 74,739.47 $ 49,fi76.73 $ 24,433.41 $ 13,160.13 $ 500,000.00 <br /> <br /> _ ~ <br />Direct Tolal _- <br />' - , <br />$ 2,477;517.82 <br />4 5.9,374,10 <br />. $225,901.05 <br />$ .3,091.61 <br />$212,794.89 <br />$ 47,467.07 <br />$ 8,282.97 <br />$ 157,143.55 <br />$ 359,125.83 <br />$238,6;8.45 <br />$192,403.41 <br />$ 63,234.88 <br />$ 2,477,517.82 <br /> _ <br /> ENGINEERING CHARGE 23°k $ 569,829.10 $ 222,956.04 $ 51,957.24 $ 711.07 $ 48,942.83 $ 10,917.43 $ 1,905.08 $ 36,143.02 $ 82,598.94 $ 54,900.64 <br />9 <br />11 <br />9 $ 44,252.76 <br />9 <br />620 <br />17 $ 14,544.02 <br />74 <br />$ 3 <br />161 $ 569,829.10 <br />89 <br />$ 123 <br />875 <br /> ADMIN FEE 5% $ 123,875.89 $ 48,468.71 $ 11,295.05 $ 154.58 $ 10,639.74 $ 2,373.35 $ 414.15 $ 7,857.18 $ 17,956.29 34. <br />2 <br />$ <br />, , <br />. <br />$ , <br />. , <br />. <br /> CONSTRUCTION FINANCING 4% $ 99,100.71 $ 38,774.96 $ 9,036.04 $ 123.66 $ 8,511.80 $ 1,898.68 $ 331.32 $ 6,285.74 $ 14,365.03 $ 9,547.94 $ 7,696.14 $ 2,529.40 $ 99,100.71 <br /> <br /> _~ <br />TOTAL _- -_ ~ <br />_ _ <br />'- <br />$3,270;323.52 <br />$. x.1,279,573.81 <br />$298,189.39 <br />$ 4,080.92 <br />$280 889 26 <br />1 S 62,656.53 <br />$ 10,933.52. <br />$ 207,429.49 <br />$474,046.10 <br />$315081.96 <br />$253,97250 <br />$'83,470.04 <br />$3,270,323.52 <br />