|
0259611 SEQ.xlsx
<br />11/03/2010 2:22 PM
<br />ITEM NO.
<br />ITEM DESCRIPTION
<br />UNIT
<br />PRICE UNIT
<br />TOTAL PROJECT
<br />PARTICIPATING - FEDERAL FUNDS
<br />SP 02- 596 -11
<br />ANOKA COUNTY
<br />SAP 199 - 107 -007 (ALPINE DR)
<br />CITY OF RAMSEY
<br />SAP 199 - 020 -009 (CR 57)
<br />CITY OF RAMSEY
<br />STORM SEWER
<br />ESTIMATED
<br />QUANTITY
<br />COST
<br />ROADWAY
<br />QUANTITIES
<br />ESTIMATED
<br />SEGMENT
<br />COST
<br />ROADWAY
<br />QUANTITIES
<br />ESTIMATED
<br />SEGMENT
<br />COST
<br />ROADWAY
<br />QUANTITIES
<br />ESTIMATED
<br />SEGMENT
<br />COST
<br />ESTIMATED
<br />QUANTITY
<br />SEGMENT COST
<br />2575.501
<br />SEEDING
<br />ACRE
<br />$85.00
<br />4
<br />$366.35
<br />4.31
<br />$366.35
<br />CONSTRUCTION TOTAL
<br />$1,488,645.35
<br />$1,211,476.85
<br />$798,350.00
<br />2575.502
<br />SEED MIXTURE 325
<br />POUND
<br />$10.00
<br />5
<br />$50.00
<br />5
<br />$50.00
<br />$96,918.15
<br />$96,918.15
<br />$22,173.48
<br />2575.502
<br />SEED MIXTURE 328
<br />POUND
<br />$10.00
<br />25
<br />$250.00
<br />25
<br />$250.00
<br />$299,341.98
<br />$182,650.00
<br />$116,691.98
<br />2575.502
<br />SEED MIXTURE 340
<br />POUND
<br />$10.00
<br />239
<br />$2,390.00
<br />239
<br />$2.390.00
<br />2575.505
<br />SODDING TYPE SALT RESISTANT
<br />SQ YD
<br />$3.00
<br />1920
<br />$5,760.00
<br />1,920
<br />$5,760.00
<br />2575.511
<br />MULCH MATERIAL TYPE 1
<br />TON
<br />$120.00
<br />1
<br />$132.00
<br />1.1
<br />$132.00
<br />2575.519
<br />DISK ANCHORING
<br />ACRE
<br />$50.00
<br />1
<br />$30.00
<br />0.60
<br />$30.00
<br />2575.523
<br />EROSION CONTROL BLANKETS CATEGORY 3
<br />SQ YD
<br />$1.00
<br />11517
<br />$11,517.00
<br />11,517
<br />$11,517.00
<br />2575.532
<br />FERTILIZER TYPE 3
<br />POUND
<br />$0.60
<br />435
<br />$261.00
<br />435
<br />$261.00
<br />2575.571
<br />RAPID STABILIZATION METHOD 3
<br />M GALLONS
<br />$275.00
<br />15
<br />$4,070.00
<br />14.8
<br />$4,070.00
<br />2575.623
<br />HYDROSEEDING
<br />M GALLONS
<br />$220.00
<br />1
<br />$121.00
<br />0.55
<br />$121.00
<br />2582.501
<br />PAVT MESSAGE (LT ARROW) PREFORMED THERMOPLASTI
<br />EACH
<br />$300.00
<br />6
<br />$1,800.00
<br />6
<br />$1.800.00
<br />2582.501
<br />PAVT MESSAGE (RT ARROW) PREFORMED THERMOPLAST
<br />EACH
<br />$300.00
<br />6
<br />$1,800.00
<br />6
<br />$1,800.00
<br />2582.502
<br />24" SOLID LINE WHITE- PREFORMED THERMOPLASTIC
<br />LIN FT
<br />$20.00
<br />141
<br />$2,820.00
<br />141
<br />$2,820.00
<br />2582.502
<br />24" SOLID LINE YELLOW- PREFORMED THERMOPLASTIC
<br />LIN FT
<br />$20.00
<br />1826
<br />$36,520.00
<br />1,826
<br />$36,520.00
<br />2582.502
<br />4" SOLID LINE WHITE -EPDXY
<br />LIN FT
<br />$0.50
<br />8378
<br />$4,189.00
<br />8,378
<br />$4,189.00
<br />2582.50214"
<br />SOLID LINE YELLOW -EPDXY
<br />LIN FT
<br />$0.501
<br />1419
<br />$709.501
<br />1,419
<br />$709.50
<br />2582.50214"
<br />DOUBLE SOLID LINE YELLOW -EPDXY
<br />LIN FT
<br />1 $2.001
<br />4889
<br />$9,778.001
<br />4,889
<br />$9,778.00
<br />2582.503
<br />CROSSWALK MARKING - PREFORMED THERMOPLASTIC
<br />SQ FT
<br />1 $12.00
<br />39
<br />$468.00
<br />39
<br />$468.00
<br />TOTAL
<br />1 $1,488,645.35
<br />$1,060,265.351
<br />1 $156,253.501
<br />1 $120,915.00
<br />$151,211.50
<br />FUNDING GROUP
<br />TOTALS
<br />TOTAL FEDERAL ELIGIBLE ITEMS
<br />FEDERAL FUNDS AVAILABLE
<br />% FEDERAL FUNDING
<br />$1,488,645.35
<br />$1,488,645.35
<br />$981,000.00
<br />65.9%
<br />Group 1
<br />$1,060,265.35
<br />$1,060,265.35
<br />$698,702.55
<br />$698,700.00
<br />Group 2
<br />$156,253.50
<br />$156,253.50
<br />$102,969.24
<br />$102,970.00
<br />PRORATA PERCENTAGE
<br />PROJECT
<br />TOTALS
<br />ANOKA COUNTY
<br />TOTALS
<br />ANOKA COUNTY
<br />FEDERAL FUNDS
<br />ANOKA COUNTY
<br />STATE AID FUNDS
<br />ANOKA COUNTY
<br />LOCAL FUNDS
<br />CITY OF RAMSEY
<br />TOTALS
<br />CITY OF RAMSEY
<br />FEDERAL FUNDS
<br />CITY OF RAMSEY
<br />STATE AID FUNDS
<br />CITY OF RAMSEY
<br />LOCAL FUNDS
<br />ROADWAY
<br />$1,337,433.85
<br />$1,060,265.35
<br />$698,700.00
<br />$361,565.35
<br />Prorata Percentage
<br />$277,168.50
<br />$182,650.00
<br />$94,518.50
<br />10.48
<br />DRAINAGE (100.0% County, 0.0% Ramsey)
<br />$151,211.50
<br />$151,211.50
<br />$99,650.00
<br />$51,561.50
<br />CONSTRUCTION TOTAL
<br />$1,488,645.35
<br />$1,211,476.85
<br />$798,350.00
<br />$413,126.85
<br />$277,168.50
<br />$182,650.00
<br />$94,518.50
<br />8% CONSTRUCTION ENGINEERING
<br />$119,091.63
<br />$96,918.15
<br />$96,918.15
<br />$22,173.48
<br />$22,173.48
<br />PROJECT TOTAL
<br />$1,607,736.98
<br />$1,308,395.00
<br />$798,350.00
<br />$510,045.00
<br />$299,341.98
<br />$182,650.00
<br />$116,691.98
<br />PRORATA PERCENTAGE
<br />Calculation of Prorata Percentage
<br />Prorata Items: Mobilization, Field Office and Traffic Control
<br />TOTAL
<br />COST EXCLUDING PRORATA ITEMS
<br />ANOKA COUNTY
<br />CITYOF RAMSEY
<br />ROADWAY
<br />STORM SEWER
<br />199 -107 -007
<br />199 - 020 -009
<br />$1,443,645.35
<br />$1,028,315.35
<br />$146,711.50
<br />$151,303.50
<br />$117,315.00
<br />Prorata Percentage
<br />100.0
<br />71.23
<br />10.16
<br />10.48
<br />8.13
<br />Group 3
<br />$120,915.00
<br />$120,915.00
<br />$79,681.58
<br />$79,680.00
<br />Group 4
<br />$151,211.50
<br />$151,211.50
<br />$99,646.62
<br />$99,650.00
<br />P:\02- 596 -11 \Documents \Road & Bridge Design \Estimate \0259611 SEQ.xlsx Page 2 of 2
<br />
|