Attachment B - Water Pipe Replacement.xls
XLS spreadsheet 80 KB Posted
- Solicitation number
- RFP-AFRCRO-FAC-23-0003
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment A - AFRH-WaterSewer Replacement.pdf | ||
| RFP-AFRCRO-FAC-23-003.pdf | ||
| Attachment C - SF 1019A - Subcontracting Plan (3-22).docx | DOCX document |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
5-21-19
| Attachment B | |||||||||||
| Water Distribution System Replacement Campus West Side | |||||||||||
| ESTIMATED INSTALLED COST OF C900/C905 PVC PIPE Fittings: | |||||||||||
| Material | Quantity | Material Cost | Install Rate | Labor & Equipment Cost | Total Installed Cost | ||||||
| # | ($/#) | (Total $) | (#/HR) | ($/HR) | (Total $) | (Total $) | |||||
| 8 x 8 x 2 Tee (D-D-D) 294 | 1 | 2 | $0.00 | ||||||||
| 8 x 8 x 8 Tee (D-D-D) 110 | 3 | 2 | $0.00 | ||||||||
| 12 x 12 x 4 Tee (D-D-D) 67 | 7 | 2 | $0.00 | ||||||||
| 12 x 12 x 8 Tee (D-D-D) 295 | 1 | 2 | $0.00 | ||||||||
| 4, 45 Bend | 10 | 5 | $0.00 | ||||||||
| 4, 90 Bend (D) 70 | 3 | 5 | $0.00 | ||||||||
| 8, 45 Bend | 5 | 5 | $0.00 | ||||||||
| 12, 45 Bend | 3 | 5 | $0.00 | ||||||||
| 12, 90 Bend (D-D) 150 | 1 | 2 | $0.00 | ||||||||
| 12, Pipe - Ftg, Valve JR (D) 68 | 2 | 5 | $0.00 | ||||||||
| 8, Pipe - Ftg, Valve JR (D) 30 | 6 | 5 | $0.00 | ||||||||
| 4, Pipe - Ftg, Valve JR (D) 15 | 8 | 5 | $0.00 | ||||||||
| 3/4", Pipe - Ftg, Valve | 15 | 5 | $0.00 | ||||||||
| Total | $0.00 | Total | $0.00 | Total | $0.00 | ||||||
| ESTIMATED INSTALLED COST OF C900/C905 PVC PIPE: | |||||||||||
| Pipe Size | Total Length | Material Cost | Install Rate | Labor & Equipment Cost | Backfill Cost | Total Installed Cost | |||||
| (IN) | (LF) | ($/LF) | (Total $) | (LF/HR) | ($/LF) | (Total $) | ($/LF) | (Total $) | ($/LF) | (Total $) | |
| 3/4" | 750 | 200 | $ 14.97 | $0.00 | $ - 0 | ||||||
| 2 | 175 | $ 14.97 | $0.00 | $ - 0 | |||||||
| 4 | 3,500 | 150 | $ 14.97 | $0.00 | $ - 0 | ||||||
| 6 | 125 | $ 17.16 | $0.00 | $ - 0 | |||||||
| 8 | 1,750 | 115 | $ 19.45 | $0.00 | $ - 0 | ||||||
| 10 | 100 | $ 21.67 | $0.00 | $ - 0 | |||||||
| 12 | 2,500 | 100 | $ 24.00 | $0.00 | $ - 0 | ||||||
| Total | $ - 0 | Total | $ - 0 | Total | $ - 0 | Total | $ - 0 | ||||
| ESTIMATED CONSTRUCTION EQUIPMENT RENTAL AND MISC. | |||||||||||
| Material | Quantity | Unit | Material Cost | Install Rate | Labor & Equipment Cost | Total Installed Cost | |||||
| # | ($/#) | (Total $) | (HR) | ($/HR) | (Total $) | (Total $) | |||||
| Excavator | 1 | 2080 | |||||||||
| Track Skid Steer | 1 | 2080 | |||||||||
| Grass Seed | 20 | Bags | 40 | ||||||||
| Straw | 200 | Bails | 40 | ||||||||
| Total | $0.00 | Total | $0.00 | Total | $0.00 | ||||||
| ESTIMATED RECONSTRUCTION COST OF ASPHALT ROADS AND RETAINING WALL: | |||||||||||
| Material | Quantity | Unit | Material Cost | Install Rate | Labor & Equipment Cost | Total Installed Cost | |||||
| # | ($/#) | (Total $) | (HR) | ($/HR) | (Total $) | (Total $) | |||||
| Hot mix asphalt and concrete aggregate surfacing | 3000 | Sq. Ft. | $0.00 | ||||||||
| Asphaltic Labor, Basic | 160 | $0.00 | |||||||||
| Surface preparation material, sealant | 3000 | Sq. Ft. | $0.00 | ||||||||
| Asphaltic Equipment Allowance | 1 | Item | $0.00 | ||||||||
| Total | $0.00 | Total | $0.00 | Total | $0.00 | ||||||
| Project SubTotal | $0.00 | ||||||||||
| Project Misc. Supplies, Parts, Fuel and Rentals; 15% | $0.00 | ||||||||||
| Project Total | $0.00 | ||||||||||
| Locality Adjustment 7% | $0.00 | ||||||||||
| Overhead 10% | $0.00 | ||||||||||
| Profit 8.5% | $0.00 | ||||||||||
| Sub-Total | $ - 0 | ||||||||||
| Contingency 25% | $ - 0 | ||||||||||
| Total | $ - 0 |
Cost Tables
| Pipe Material Cost: | Install Rates: | ||||||||||
| Diameter | PVC C900/905 | Ductile Iron | PVC C905 | Ductile Iron | Diameter | PVC C900/905 | Ductile Iron | ||||
| DR 18 Pipe | PC 350 Pipe | DR 25 Pipe | PC 250 Pipe | ||||||||
| (IN) | ($/LF) | ($/LF) | ($/LF) | ($/LF) | (IN) | (LF/HR) | (LF/HR) | ||||
| 4 | $1.88 | $9.00 | 4 | 150 | 100 | ||||||
| 6 | $3.68 | $14.74 | 6 | 125 | 100 | ||||||
| 8 | $6.30 | $18.38 | 8 | 115 | 100 | ||||||
| 10 | $9.59 | $23.75 | 10 | 100 | 90 | ||||||
| 12 | $13.51 | $30.43 | 12 | 100 | 85 | ||||||
| 14 | $17.51 | $40.30 | $13.44 | 14 | 80 | 70 | |||||
| 16 | $24.06 | $50.17 | $17.51 | $43.73 | 16 | 64 | 58 | ||||
| 18 | $30.32 | $62.38 | $22.08 | $50.59 | 18 | 56 | 50 | ||||
| 20 | $37.42 | $27.23 | $58.30 | 20 | 50 | 45 | |||||
| 24 | $53.80 | $39.32 | $65.93 | 24 | 40 | 35 | |||||
| 30 | 30 | ||||||||||
| 36 | 36 | ||||||||||
| 42 | 42 | ||||||||||
| 48 | 48 | ||||||||||
| Notes: | |||||||||||
| 1. PVC pipe prices obtained on 2/7/11 and represent JM Eagle Block 45 | |||||||||||
| 2. Ductile Iron pipe prices obtained 2/7/11 | |||||||||||
| 3. All stated prices are marked up 20% to accomadate distribution margins and market price fluctuations | |||||||||||
| 4. PVC C900 referrs to 4" - 12" diameter pipe | Backfill Cost & Scenario: | ||||||||||
| 5. PVC C905 referrs to 14" - 48" diameter pipe | 3" Bedding Only | 0.00 | $/Ton | ||||||||
| 6. DR 18 PVC pipe rated at 235 psi | Springline of Pipe (1/2 Dia) | 0 | Density (LBS/FT^3) | ||||||||
| 7. DR 25 PVC pipe rated at 165 psi | Top of Pipe | or | |||||||||
| 8. Ductile Iron PC 350 pipe is rated at 350 psi | 6" Above Top of Pipe | 0.00 | $/CY | ||||||||
| 9. Ductile Iron PC 250 pipe is rated at 250 psi | 12" Above Top of Pipe | ||||||||||
| 0.00 | |||||||||||
| Labor & Equipment Cost: | |||||||||||
| Item | Qty (EA) | Unit Cost ($/LF) | Extended Cost ($/LF) | Diameter (IN) | OD (IN) | 3" Bedding Only | Springline of Pipe (1/2 Dia) | Top of Pipe | 6" Above Top of Pipe | 12" Above Top of Pipe | |
| Laborer | 3 | $40.42 | $121.26 | 4 | 4.80 | 0.02 | 0.06 | 0.08 | 0.12 | 0.16 | |
| Operator | 3 | $54.81 | $164.43 | 6 | 6.90 | 0.02 | 0.07 | 0.09 | 0.14 | 0.19 | |
| Foreman1 | 1 | $62.03 | $62.03 | 8 | 9.05 | 0.03 | 0.08 | 0.11 | 0.16 | 0.21 | |
| CAT 330 Excavator | 2 | $120.00 | $240.00 | 10 | 11.10 | 0.03 | 0.09 | 0.13 | 0.18 | 0.24 | |
| CAT 966G Wheel Tire Loader | 1 | $71.00 | $71.00 | 12 | 13.20 | 0.03 | 0.10 | 0.15 | 0.21 | 0.26 | |
| Notes: | Total ($/HR): | $658.72 | 14 | 15.30 | 0.03 | 0.11 | 0.17 | 0.23 | 0.29 | ||
| 1. Foreman rate equals Operator rate plus 15% | 16 | 17.40 | 0.03 | 0.13 | 0.19 | 0.25 | 0.32 | ||||
| 2. Labor rates based on RS Means: Labor Rate for Construction Industry, 36th Edition | 18 | 19.50 | 0.03 | 0.14 | 0.21 | 0.28 | 0.34 | ||||
| 3. Equipment rates based on Rental Rate Blue Book for Construction Equipment, Volume 1 | 20 | 21.60 | 0.04 | 0.15 | 0.23 | 0.30 | 0.37 | ||||
| 24 | 25.80 | 0.04 | 0.17 | 0.27 | 0.35 | 0.43 | |||||
| 30 | 32.00 | 0.04 | 0.21 | 0.34 | 0.43 | 0.51 | |||||
| 36 | 38.30 | 0.05 | 0.25 | 0.41 | 0.51 | 0.61 | |||||
| 42 | 44.50 | 0.05 | 0.30 | 0.49 | 0.60 | 0.70 | |||||
| 48 | 50.80 | 0.06 | 0.34 | 0.57 | 0.69 | 0.80 |
File details come from the government source that posted it. Updated .