|
0259611 SEQ.xlsx
<br />11/03/2010 2:22 PM
<br />ITEM NO. ITEM DESCRIPTION
<br />UNIT
<br />PRICE UNIT
<br />TOTAL PROJECT
<br />ESTIMATED
<br />QUANTITY COST
<br />SP 02-596-11
<br />ANOKA COUNTY
<br />ROADWAY
<br />SEGMENT
<br />QUANTITIES COST
<br />ESTIMATED
<br />PARTICIPATING -FEDERAL FUNDS
<br />SAP 199-107-007 (ALPINE DR) SAP 199-020-009 (CR 57)
<br />CITY OF RAMSEY CITY OF RAMSEY STORM SEWER
<br />ROADWAY ROADWAY
<br />SEGMENT SEGMENT ESTIMATED
<br />QUANTITIES COST QUANTITIES COST QUANTITY SEGMENT COST
<br />ESTIMATED ESTIMATED
<br />2575.501 SEEDING
<br />ACRE
<br />$85.00
<br />4
<br />$366.35
<br />4.31
<br />$366.35
<br />$698.700.00
<br />$361,565.35
<br />2575.502 SEED MIXTURE 325
<br />POUND
<br />$10.00
<br />5
<br />$50.00
<br />5
<br />$50.00
<br />$151,211.50
<br />$99,650.00
<br />2575.502 SEED MIXTURE 328
<br />POUND
<br />$10.00
<br />25
<br />$250.00
<br />25
<br />$250.00
<br />$1,488,645.35
<br />$1,211,476.85
<br />2575.502 SEED MIXTURE 340
<br />POUND
<br />$10.00
<br />239
<br />$2,390.00
<br />239
<br />$2,390.00
<br />8% CONSTRUCTION ENGINEERING
<br />$119,091.63
<br />2575.505 SODDING TYPE SALT RESISTANT
<br />SQ YD
<br />$3.00
<br />1920
<br />$5,760.00
<br />1,920
<br />$5.760.00
<br />PROJECT TOTAL
<br />2575.511 MULCH MATERIAL TYPE 1
<br />TON
<br />$120.00
<br />1
<br />$132.00
<br />1.1
<br />$132.00
<br />$116,691.98
<br />2575.519 DISK ANCHORING
<br />ACRE
<br />$50.00
<br />1
<br />$30.00
<br />0.60
<br />$30.00
<br />2575.523 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 FERTILIZER TYPE 3
<br />POUND
<br />$0.60
<br />435
<br />$261.00
<br />435
<br />$261.00
<br />2575.571 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 HYDROSEEDING
<br />M GALLONS
<br />$220.00
<br />1
<br />$121.00
<br />0.55
<br />$121.00
<br />2582.501 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 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 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 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 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" SOLID LINE YELLOW-EPDXY
<br />LIN FT
<br />$0.501
<br />1419
<br />$709.501
<br />1,419
<br />$709.50
<br />2582.50214" DOUBLE SOLID LINE YELLOW-EPDXY
<br />LIN FT 1
<br />$2.001
<br />4889
<br />$9,778.001
<br />4,889
<br />$9,778.00
<br />2582.503 CROSSWALK MARKING -PREFORMED THERMOPLASTIC
<br />SQ FT 1
<br />$12.00
<br />39
<br />$468.00
<br />39
<br />$468.00
<br />TOTAL 1
<br />$1,488,645.35
<br />$1,060,265.351
<br />1 $156,253.501
<br />1 $120,915.00 $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 />P:\02-596-11\Documents\Road & Bridge Design\Estimate\0259611 SEQ.xlsx Page 2 of 2
<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 />
|