COST DISTRIBUTION SPREADSHEET <br /> POST BID LID FORMATION-ASSESSMENT <br /> <br /> 2/5/2008 <br /> <br /> JOB NAME: 6th Alley <br /> DESCRIPTION: <br /> <br /> JOB 4527 <br /> <br /> CONTRACT: <br /> <br /> BY: John Bonham <br /> <br /> CK: <br /> Bid Schell: Description QTY Unit Unii Cost Total Paving CityWW City Storm City Pave Total <br /> llem <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 ad'ustments of manholes 1.00 EACH $300.00 $ 300.00 $ 300.00 $ 300.00 <br /> 80 General Excavation 205.00 CUYD $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 Pie 11.00 FEET $48.00 $ 528.00 $ 528.00 $ 528.00 $ - <br /> 110 8 inch vc wastewater pi a 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 ualit structure 1.00 EACH $9,700.00 $ 9,700.00 $ 9,700.00 $ 9,700.00 <br /> 140 level 2,1/2 inch dense hmac 25.00 TON $150.00 $ 3,750.00 $ 3,750.00 $ - $ 3,750.00 <br /> 150 plain concrete avement, undowelled, 7" thick 5164.00 SOFT $5.60 $ 28,918.40 $ 28,918.40 $ 28,918.40 <br /> 160 to soil 1.50 CUYD $100.00 $ 150.00 $ 150.00 $ - $ 150.00 <br /> $ - <br /> EST- <br /> EST - <br /> INSERT ESTIMATES ABOVE THIS LINE ~ <br /> Sub-Total $ &5,466.90 $ 55,243.90 $ 23,159.00 $ 7,064.00 $ - $ 85,466.90 <br /> % 64.64% 27.10% 8.27% 0.00% 100.00% 100.00% <br /> 10 MOBILIZATION 1 LUMPSUM. $10,000.00 $ 10,000.00 $ 6,463.78 $ 2,709.70 $ 826.52 $ - $ 10,000.00 $ - <br /> 20 TPDT 1 LUMPSUM $4,000.00 $ 4,000.00 $ 2,585.51 $ 1,083.88 $ 330.61 $ - $ 4,000.00 $ - <br /> 30 Erosion Control 1 LUMPSUM $650.00 $ 650.00 $ 420.15 $ 176.13 $ 53.72 $ - $ 650.00 <br /> EST- <br /> EST- <br /> INSERT ESTIMATES ABOVE THIS LINE <br /> Contractor Total $ 100,116.90 $ 64,713.33 $ 27,128.72 $ 8,274.85 $ - $ 100,116.90 $ - <br /> % 64.64% 27.10% 8.27% 0.00% 100.00% 100.00% <br /> TESTING $ 1.,200.00 $ 775.65 $ 325.16 $ 99.18 $ - $ 1,200.00 $ - <br /> ADVERTISING $ 600.00 $ 387.83 $ 162.58 $ 49.59 $ - $ 600.00 $ , - <br /> EROSION PERMIT FEES $ - $ - $ - $ - $ - $ - $ - <br /> CONTINGENCY $ 10,011.69 $ 6,471.33 $ 2,712.87 $ 827.49 $ - $ 10,011.69 $ - <br /> Ties to GL AS OF DATE: <br /> EST- <br /> EST- <br /> EST- <br /> INSERTESTIMATES ABOVE THIS LINE <br /> Total Direct Costs-Iracludin Estimates $ 111,928.59 $ 72,348.14 $ 30,329.34 $ 9,251.11 $ - $ 111,928.59_ $ - <br /> 64.64% 27.10% 8.27% 0.00% 100.00% 100.00% <br /> ENGINEERING CHARGE 43% $ `48,129.29 $ 31,109.70 $ 13,041.62 $ 3,977.97 $ - $ 48,129.29 $ - <br /> ADMINFEE 5% $ 5,596.43 $ 3,617.41 $ 1,516.47 $ 462.56 $ - $ 5,596.43 $ - <br /> CONSTRUCTION FINANCING 3.511980% LUMPSUM $3,930.91 $ 3,930.91 $ 2,540.85 $ 1,065.16 $ 324.90 $ - $ 3,930.91 $ - <br /> GRAND TOTAL includes Cit Share Admin Fee $ 169,585.22 $ 109,616.10 $ 45,952.58 $ 14,016.54 $ - $ 969,58522,.. $ - <br /> GRAND TOTAL includes Cit Share Admin Fee $ 169,585.22 $ 109,616.10 $ 45,952.58 $ 14,016.54 $ - $ 169,585.22 $ - <br /> TOTAL COSTS TO BE RECORDED (excludes City Share Admin Fee) $ 167,606.19 $ 167,606.19 $ - <br /> <br />