Abstract Spreadsheet.pdf

Solicitation IBM10B0004 RECOVERY - Construct Sunland Park Levee System Ultimate Concrete

Division No. Item No. Desd Code Description Unit Price Estimated Amount Unit Price Estimated Amount Unit Price Estimated Amount Unit Price Estimated Amount Unit Price Estimated Amount Unit Price Estimated Amount Unit Price Estimated Amount Unit Price Estimated Amount Unit Price Estimated Amount Unit Price Estimated Amount Unit Price Estimated Amount Unit Price Estimated Amount Unit Price Estimated Amount

001 01 57 01 Temp Erosi LF 124,921 $3.50 $437,223.50 $1.80 $224,857.80 $2.10 $262,334.10 $1.50 $187,381.50 $2.00 $249,842.00 $3.96 $494,687.16 $2.00 $249,842.00 $4.20 $524,668.20 $2.50 $312,302.50 $1.25 $156,151.25 $2.00 $249,842.00 $2.50 $312,302.50 $1.50 $187,381.50 002 01 57 02 Temp Erosi SY 858 $22.50 $19,305.00 $26.00 $22,308.00 $20.00 $17,160.00 $15.00 $12,870.00 $12.00 $10,296.00 $17.12 $14,688.96 $12.00 $10,296.00 $18.11 $15,538.38 $60.00 $51,480.00 $27.00 $23,166.00 $25.00 $21,450.00 $25.00 $21,450.00 $20.00 $17,160.00 003 01 70 01 Mobilization LS 1 $1,425,954.00 $1,425,954.00 $400,000.00 $400,000.00 $953,400.00 $953,400.00 $950,000.00 $950,000.00 $1,200,000.00 $1,200,000.00 $398,040.00 $398,040.00 $1,370,000.00 $1,370,000.00 $861,429.41 $861,429.41 $1,370,000.00 $1,370,000.00 $1,278,500.00 $1,278,500.00 $1,500,000.00 $1,500,000.00 $1,600,000.00 $1,600,000.00 $1,702,000.00 $1,702,000.00

039 02 91 10

Remove/R elocate Exist Fence LF 210 $40.00 $8,400.00 $30.00 $6,300.00 $40.00 $8,400.00 $4.50 $945.00 $20.00 $4,200.00 $23.54 $4,943.40 $24.00 $5,040.00 $25.40 $5,334.00 $12.00 $2,520.00 $30.00 $6,300.00 $15.00 $3,150.00 $25.00 $5,250.00 $15.00 $3,150.00

004 31 11 10 Prep Right o EA 630.90 $480.00 $302,832.00 $400.00 $252,360.00 $430.00 $271,287.00 $950.00 $599,355.00 $210.00 $132,489.00 $208.65 $131,637.29 $660.00 $416,394.00 $220.88 $139,353.19 $560.00 $353,304.00 $400.00 $252,360.00 $450.00 $283,905.00 $500.00 $315,450.00 $500.00 $315,450.00 005 31 14 01 Removal/sto CD 7,976 $4.50 $35,892.00 $2.75 $21,934.00 $4.00 $31,904.00 $4.50 $35,892.00 $1.50 $11,964.00 $2.57 $20,498.32 $2.75 $21,934.00 $2.65 $21,136.40 $4.50 $35,892.00 $5.35 $42,671.60 $11.00 $87,736.00 $6.00 $47,856.00 $7.00 $55,832.00 006 31 92 01 Seeding (pe SY 260,893 $0.30 $78,267.90 $0.40 $104,357.20 $0.22 $57,396.46 $0.15 $39,133.95 $0.15 $39,133.95 $0.34 $88,703.62 $0.40 $104,357.20 $0.36 $93,921.48 $0.15 $39,133.95 $0.20 $52,178.60 $0.20 $52,178.60 $0.25 $65,223.25 $0.60 $156,535.80

007 31 92 02 Vegetative Watering EA 521.68 $103.00 $53,733.04 $95.00 $49,559.60 $70.00 $36,517.60 $45.00 $23,475.60 $85.00 $44,342.80 $111.28 $58,052.55 $100.00 $52,168.00 $117.07 $61,073.08 $80.00 $41,734.40 $175.00 $91,294.00 $125.00 $65,210.00 $100.00 $52,168.00 $100.00 $52,168.00

008 34 01 01

Clean Existing Channel LF 20 $40.00 $800.00 $400.00 $8,000.00 $50.00 $1,000.00 $100.00 $2,000.00 $100.00 $2,000.00 $47.08 $941.60 $50.00 $1,000.00 $49.70 $994.00 $95.00 $1,900.00 $100.00 $2,000.00 $200.00 $4,000.00 $25.00 $500.00 $516.00 $10,320.00

009 35 41 01 Raise Levee CD 388,160 $4.00 1,552,640.00 $3.50 1,358,560.00 $3.75 $1,455,600.00 $4.50 $1,746,720.00 $8.00 $3,105,280.00 $4.28 $1,661,324.80 $4.00 $1,552,640.00 $4.42 $1,715,667.20 $5.00 $1,940,800.00 $3.95 $1,533,232.00 $5.75 $2,231,920.00 $11.00 $4,269,760.00 $5.60 $2,173,696.00 010 35 41 02 Raise Levee CD 586,422 $3.50 2,052,477.00 $9.00 5,277,798.00 $7.35 $4,310,201.70 $7.00 $4,104,954.00 $7.00 $4,104,954.00 $11.50 $6,743,853.00 $10.75 $6,304,036.50 $12.04 $7,060,520.88 $11.08 $6,497,555.76 $13.55 $7,946,018.10 $11.25 $6,597,247.50 $15.00 $8,796,330.00 $15.85 $9,294,788.70

011 35 41 03

Raise Levee (topsoil) CD 43,246 $5.00 216,230.00 $4.50 194,607.00 $9.25 $400,025.50 $3.00 $129,738.00 $4.00 $172,984.00 $4.01 $173,416.46 $4.00 $172,984.00 $4.20 $181,633.20 $6.00 $259,476.00 $5.70 $246,502.20 $8.00 $345,968.00 $7.50 $324,345.00 $20.00 $864,920.00

012 35 42 01 RipRap Con CD 257.91 $320.00 82,531.20 $320.00 82,531.20 $560.00 $144,429.60 $285.00 $73,504.35 $600.00 $154,746.00 $291.04 $75,062.13 $310.00 $79,952.10 $307.02 $79,183.53 $400.00 $103,164.00 $335.00 $86,399.85 $600.00 $154,746.00 $450.00 $116,059.50 $428.00 $110,385.48 013 35 43 01 Toe Drain LF 59,615 $26.00 1,549,990.00 $16.00 953,840.00 $21.75 $1,296,626.25 $27.00 $1,609,605.00 $26.00 $1,549,990.00 $21.94 $1,307,953.10 $24.00 $1,430,760.00 $23.19 $1,382,471.85 $31.00 $1,848,065.00 $27.00 $1,609,605.00 $22.00 $1,311,530.00 $15.00 $894,225.00 $47.75 $2,846,616.25

014 50 20 02 Roadway fle CD 21,215 $26.00 $551,590.00 $25.00 $530,375.00 $16.50 $350,047.50 $20.00 $424,300.00 $33.00 $700,095.00 $40.66 $862,601.90 $35.00 $742,525.00 $42.46 $900,788.90 $25.00 $530,375.00 $37.00 $784,955.00 $32.00 $678,880.00 $11.00 $233,365.00 $39.90 $846,478.50

040 50 91 01

Remove & reinstall traffic signs EA 6 $650.00 $3,900.00 $500.00 $3,000.00 $360.00 $2,160.00 $450.00 $2,700.00 $330.00 $1,980.00 $165.85 $995.10 $175.00 $1,050.00 $174.49 $1,046.94 $200.00 $1,200.00 $100.00 $600.00 $300.00 $1,800.00 $500.00 $3,000.00 $205.00 $1,230.00

041 50 91 02

Provide & Install new traffice signs EA 13 $500.00 $6,500.00 $1,200.00 $15,600.00 $300.00 $3,900.00 $750.00 $9,750.00 $550.00 $7,150.00 $264.29 $3,435.77 $280.00 $3,640.00 $279.41 $3,632.33 $400.00 $5,200.00 $350.00 $4,550.00 $350.00 $4,550.00 $500.00 $6,500.00 $450.00 $5,850.00

015 60 23 01 Retaining w SF 2,543.57 $49.00 $124,634.93 $50.00 $127,178.50 $24.00 $61,045.68 $65.00 $165,332.05 $60.00 $152,614.20 $63.13 $160,575.57 $100.00 $254,357.00 $66.60 $169,401.76 $22.00 $55,958.54 $75.00 $190,767.75 $120.00 $305,228.40 $35.00 $89,024.95 $80.00 $203,485.60 016 60 34 01 Structure ap CD 118.80 $290.00 $34,452.00 $600.00 $71,280.00 $500.00 $59,400.00 $550.00 $65,340.00 $210.00 $24,948.00 $463.31 $55,041.23 $490.00 $58,212.00 $499.19 $59,303.77 $450.00 $53,460.00 $565.00 $67,122.00 $1,000.00 $118,800.00 $525.00 $62,370.00 $510.00 $60,588.00 017 60 50 10 Rail (T221) LF 22.35 $350.00 $7,822.50 $120.00 $2,682.00 $200.00 $4,470.00 $95.00 $2,123.25 $125.00 $2,793.75 $205.44 $4,591.58 $220.00 $4,917.00 $216.46 $4,837.88 $300.00 $6,705.00 $45.00 $1,005.75 $175.00 $3,911.25 $75.00 $1,676.25 $200.00 $4,470.00 018 60 50 11 Rail (T223) LF 9.59 $350.00 $3,356.50 $190.00 $1,822.10 $250.00 $2,397.50 $110.00 $1,054.90 $125.00 $1,198.75 $99.51 $954.30 $100.00 $959.00 $104.92 $1,006.18 $300.00 $2,877.00 $50.00 $479.50 $175.00 $1,678.25 $80.00 $767.20 $520.00 $4,986.80 019 60 50 12 Rail (T551) LF 14.18 $350.00 $4,963.00 $135.00 $1,914.30 $300.00 $4,254.00 $120.00 $1,701.60 $125.00 $1,772.50 $59.92 $849.67 $100.00 $1,418.00 $62.95 $892.63 $300.00 $4,254.00 $55.00 $779.90 $175.00 $2,481.50 $100.00 $1,418.00 $380.00 $5,388.40 020 60 50 13 Rail (T552) LF 17.34 $350.00 $6,069.00 $140.00 $2,427.60 $350.00 $6,069.00 $130.00 $2,254.20 $125.00 $2,167.50 $72.76 $1,261.66 $100.00 $1,734.00 $77.31 $1,340.56 $300.00 $5,202.00 $60.00 $1,040.40 $175.00 $3,034.50 $105.00 $1,820.70 $370.00 $6,415.80 021 60 50 01 Crash Cuss EA 2 $10,000.00 $20,000.00 $15,000.00 $30,000.00 $7,500.00 $15,000.00 $4,500.00 $9,000.00 $20,000.00 $40,000.00 $21,400.00 $42,800.00 $22,000.00 $44,000.00 $22,542.95 $45,085.90 $25,000.00 $50,000.00 $4,655.00 $9,310.00 $10,000.00 $20,000.00 $18,500.00 $37,000.00 $22,000.00 $44,000.00

022 60 63 01

RC Box culvert - Delete LF 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

023 60 63 04

RC Box Culvert (5x5 LF 45 $900.00 $40,500.00 $650.00 $29,250.00 $300.00 $13,500.00 $1,000.00 $45,000.00 $460.00 $20,700.00 $556.40 $25,038.00 $520.00 $23,400.00 $584.23 $26,290.35 $460.00 $20,700.00 $575.00 $25,875.00 $1,500.00 $67,500.00 $625.00 $28,125.00 $830.00 $37,350.00

024 60 64 13 RC Pipe (48 LF 27 $225.00 $6,075.00 $250.00 $6,750.00 $400.00 $10,800.00 $400.00 $10,800.00 $220.00 $5,940.00 $112.35 $3,033.45 $120.00 $3,240.00 $118.17 $3,190.59 $250.00 $6,750.00 $215.00 $5,805.00 $600.00 $16,200.00 $225.00 $6,075.00 $280.00 $7,560.00

025 60 64 19 RC Pi (30 IN) LF 22 $152.00 $3,344.00 $220.00 $4,840.00 $300.00 $6,600.00 $385.00 $8,470.00 $200.00 $4,400.00 $64.20 $1,412.40 $68.00 $1,496.00 $68.47 $1,506.34 $230.00 $5,060.00 $100.00 $2,200.00 $500.00 $11,000.00 $200.00 $4,400.00 $175.00 $3,850.00

026 60 66 92 Conc Hdwl (12 in) EA 2 $10,000.00 $20,000.00 $3,000.00 $6,000.00 $3,500.00 $7,000.00 $3,400.00 $6,800.00 $6,000.00 $12,000.00 $1,768.71 $3,537.42 $1,850.00 $3,700.00 $1,866.43 $3,732.86 $12,000.00 $24,000.00 $2,500.00 $5,000.00 $10,000.00 $20,000.00 $3,200.00 $6,400.00 $15,000.00 $30,000.00

027 60 66 94 Conc Hdwl (48 in) EA 1 $8,635.00 $8,635.00 $7,000.00 $7,000.00 $7,000.00 $7,000.00 $7,000.00 $7,000.00 $6,000.00 $6,000.00 $3,534.21 $3,534.21 $3,500.00 $3,700.00 $3,729.55 $3,729.55 $7,000.00 $7,000.00 $4,500.00 $4,500.00 $25,000.00 $25,000.00 $8,200.00 $8,200.00 $12,000.00 $12,000.00

028 60 66 98 Conc Hdwl (30 in) EA 2 $6,200.00 $12,400.00 $5,000.00 $10,000.00 $5,000.00 $10,000.00 $5,500.00 $11,000.00 $6,000.00 $12,000.00 $2,872.95 $5,745.90 $3,000.00 $6,000.00 $3,031.57 $6,063.14 $6,000.00 $12,000.00 $3,250.00 $6,500.00 $17,500.00 $35,000.00 $4,700.00 $9,400.00 $11,000.00 $22,000.00

029 60 68 12 Sluice Gate (30") EA 2 $8,300.00 $16,600.00 $33,000.00 $66,000.00 $9,000.00 $18,000.00 $12,000.00 $24,000.00 $12,000.00 $24,000.00 $14,980.00 $29,960.00 $14,000.00 $28,000.00 $15,822.69 $31,645.38 $11,000.00 $22,000.00 $11,000.00 $22,000.00 $12,500.00 $25,000.00 $11,600.00 $23,200.00 $18,000.00 $36,000.00

030 60 68 14 Sluice Gate (48") EA 1 $10,200.00 $10,200.00 $17,000.00 $17,000.00 $18,000.00 $18,000.00 $14,000.00 $14,000.00 $15,000.00 $15,000.00 $21,293.00 $21,293.00 $22,000.00 $22,000.00 $22,479.99 $22,479.99 $13,000.00 $13,000.00 $14,000.00 $14,000.00 $15,000.00 $15,000.00 $13,800.00 $13,800.00 $20,000.00 $20,000.00

031 60 68 16 Sluice Gate (60") EA 3 $19,830.00 $59,490.00 $16,000.00 $48,000.00 $26,500.00 $79,500.00 $24,000.00 $72,000.00 $27,000.00 $81,000.00 $34,159.75 $102,479.25 $35,000.00 $105,000.00 $36,050.82 $108,152.46 $26,000.00 $78,000.00 $27,750.00 $83,250.00 $30,000.00 $90,000.00 $24,500.00 $73,500.00 $32,000.00 $96,000.00

032 60 69 01 Sluice Gate Maint EA 2 $5,000.00 $10,000.00 $6,000.00 $12,000.00 $2,300.00 $4,600.00 $2,500.00 $5,000.00 $2,200.00 $4,400.00 $2,675.00 $5,350.00 $2,700.00 $5,400.00 $2,766.51 $5,533.02 $3,000.00 $6,000.00 $500.00 $1,000.00 $5,000.00 $10,000.00 $5,000.00 $10,000.00 $13,000.00 $26,000.00

033 60 70 01 Flapgate EA 4 $1,380.00 $5,520.00 $2,400.00 $9,600.00 $1,425.00 $5,700.00 $7,000.00 $28,000.00 $2,500.00 $10,000.00 $4,241.48 $16,965.92 $18,000.00 $72,000.00 $4,477.22 $17,908.88 $4,000.00 $16,000.00 $3,000.00 $12,000.00 $3,500.00 $14,000.00 $3,500.00 $14,000.00 $5,400.00 $21,600.00

034 60 80 01

Auto floodgate, paved 48' EA 1 $158,544.00 $158,544.00 $80,000.00 $80,000.00 $270,000.00 $270,000.00 $240,000.00 $240,000.00 $226,000.00 $226,000.00 $216,249.14 $216,249.14 $230,000.00 $230,000.00 $228,212.53 $228,212.53 $225,000.00 $225,000.00 $185,000.00 $185,000.00 $300,000.00 $300,000.00 $225,000.00 $225,000.00 $231,000.00 $231,000.00

035 60 80 02

Auto floodgate, pave 59' EA 1 $260,000.00 $260,000.00 $125,000.00 $125,000.00 $250,000.00 $250,000.00 $240,000.00 $240,000.00 $196,000.00 $196,000.00 $185,080.04 $185,080.04 $198,000.00 $198,000.00 $195,316.97 $195,316.97 $200,000.00 $200,000.00 $175,000.00 $175,000.00 $300,000.00 $300,000.00 $200,000.00 $200,000.00 $251,000.00 $251,000.00

036 60 96 10 Remove str EA 5 $600.00 $3,000.00 $2,500.00 $12,500.00 $500.00 $2,500.00 $1,600.00 $8,000.00 $612.00 $3,060.00 $1,123.50 $5,617.50 $1,200.00 $6,000.00 $1,183.91 $5,919.55 $2,000.00 $10,000.00 $1,300.00 $6,500.00 $1,200.00 $6,000.00 $3,400.00 $17,000.00 $4,600.00 $23,000.00

042 60 66 40

Conc Headwall (raise) EA 1 $750.00 $750.00 $5,000.00 $5,000.00 $2,500.00 $2,500.00 $4,500.00 $4,500.00 $3,060.00 $3,060.00 $1,734.47 $1,734.47 $1,800.00 $1,800.00 $1,833.30 $1,833.30 $1,300.00 $1,300.00 $5,020.00 $5,020.00 $4,500.00 $4,500.00 $10,000.00 $10,000.00 $6,400.00 $6,400.00

037 90 79 10 Vehicular Gate EA 6 $3,000.00 $18,000.00 $2,000.00 $12,000.00 $2,500.00 $15,000.00 $500.00 $3,000.00 $2,000.00 $12,000.00 $4,265.02 $25,590.12 $4,500.00 $27,000.00 $4,500.42 $27,002.52 $4,500.00 $27,000.00 $2,500.00 $15,000.00 $10,000.00 $60,000.00 $5,000.00 $30,000.00 $6,100.00 $36,600.00

043 90 80 01 Remove, Re EA 6 $2,000.00 $12,000.00 $2,000.00 $12,000.00 $1,500.00 $9,000.00 $2,000.00 $12,000.00 $1,340.00 $8,040.00 $3,124.40 $18,746.40 $3,345.00 $20,070.00 $3,291.10 $19,746.60 $3,000.00 $18,000.00 $850.00 $5,100.00 $4,000.00 $24,000.00 $3,000.00 $18,000.00 $6,100.00 $36,600.00 044 90 81 01 Boulders EA 50 $500.00 $25,000.00 $200.00 $10,000.00 $145.00 $7,250.00 $750.00 $37,500.00 $415.00 $20,750.00 $665.54 $33,277.00 $570.00 $28,500.00 $702.40 $35,120.00 $500.00 $25,000.00 $550.00 $27,500.00 $500.00 $25,000.00 $500.00 $25,000.00 $350.00 $17,500.00

Receiving Report Purpose Only MO 11 $100.00 $1,100.00 $400.00 $4,400.00 $1.00 $11.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $25.40 $279.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,500.00 $27,500.00 $1.00 $11.00

$9,250,721.57 $10,220,632.30 $10,491,986.89 $10,976,200.40 $12,381,291.45 $13,011,553.38 $13,669,521.80 $14,073,925.08 $14,289,369.15 $14,988,238.90 $15,097,447.00 $18,007,461.35 $19,887,767.83

Division 90 - Miscellaneous

Total Bid Amount

Quarry Hills, LTDEstimated Quantity

Contract Line Item No. (CLIN)

BID ITEM

Unit

Division 02 - Existing Conditions

Division 31 / 34 - Site Grading

Division 35 - Waterway / Marine

Division 50 - Roadway Construction

Division 60 - Structures

Cerrudo Service Inc

Division 01 - General Requirements

Vistacon, Inc Milestone Excavation Inc H Squared Industries, Inc SBBI, Inc Amigo Building Corp Overland CorpTarget Construction MV Industries, Inc Briston Construction Inc Aspen Construction Co