Spreadsheet: 027db182-8a6f-4cdf-8a64-562ba259394a
Sheet: Sheet1

Unnamed: 0 | Bid #13-008 Irrigation System Installation & Repair | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  | Great Gardens | [NAME] | Designs in Nature | [NAME]'s Sprinkler & Drainage | Mr. Landscape Inc. | AND, Inc. | McAllister's Landscape Inc. | American Landscape Systems Inc
size | Item
 | Repair/Replacement Items including Labor
1" | [NAME] | 180.89 | 175 | 65 | 205 | 163.68 | 127 | 150 | 60
1 1/2" | [NAME] | 207.69 | 225 | 82 | 330 | 191.27 | 135 | 175 | 80
2" | [NAME] | 246.06 | 300 | 110 | 375 | 280.22 | 168 | 250 | 105
 | Double Check Assembly Replacement
 | (Just Double Check that is already up to code)
1" | Watts Regulator Series 007 w/SS BV Handles | 369.38 | 320 | 100 | 340 | 384.75 | 205 | 257 | 480
1 1/2" | Watts Regulator Series 007 w/SS BV Handles | 548.63 | 690 | 300 | 625 | 564.13 | 499 | 457 | 870
2" | Watts Regulator Series 007 w/SS BV Handles | 729.74 | 1070 | 325 | 705 | 629.97 | 590 | 661 | 1150
1" | Febco 850 Series  w/SS BV Handles | 360.15 | 290 | 106 | 325 | 330.85 | 295 | 213 | 465
1 1/2" | Febco 850 Series  w/SS BV Handles | 544.76 | 650 | 270 | 575 | 534.57 | 490 | 457 | 660
2" | Febco 850 Series  w/SS BV Handles | 609.32 | 740 | 325 | 675 | 593.52 | 550 | 530 | 875
 | Double Check Concrete Box Replacement or new install
 | Brooks Products No. 65 C.I. Body | 81.33 | 120 | 45 | 245 | 160.65 | 425 | 280 | 45
 | Brooks Products No. 65 C.I. Cover | 187.33 | 300 | 50 | 69 | 187.35 | 218 | 244 | 35
 |  |  |  |  | plus 1 hr. min.
 | Concrete Valve Box Replacement or new install
 | Brooks Products No. 37T C.I. Body | 60.57 | 64 | 85 | 172 | 108.36 | 175 | 230 | 35
 | Brooks Products No. 37T C.I.Cover | 204.44 | 195 | 100 | 44 | 134.14 | 100 | 200 | 60
 |  |  |  |  | plus 1 hr. min.
 | [NAME] Valve Box Replacement
 | Ametek, 10" Circular Box with Lid | 72.81 | 29 | 18 | 15 | 28.34 | 35 | 76 | 12
 |  |  |  |  | plus 1 hr. min.
 | Brass Gate Valve Replacement
1/2" | Nibco T-113 Brass Gate Valve | 149.06 | 110 | 10 | 150.5 | 47.81 | 80 | 115 | 35
3/4" | Nibco T-113 Brass Gate Valve | 156.3 | 130 | 15 | 150.5 | 61.02 | 89 | 145 | 45
1" | Nibco T-113 Brass Gate Valve | 167.33 | 160 | 20 | 152.5 | 94.2 | 99 | 165 | 55
1 1/2" | Nibco T-113 Brass Gate Valve | 247.84 | 285 | 32 | 285 | 184.19 | 150 | 265 | 120
2" | Nibco T-113 Brass Gate Valve | 271.62 | 340 | 45 | 355 | 238.62 | 175 | 288 | 140
3" | Nibco T-113 Brass Gate Valve | 553.63 | 1090 | 110 | 735 | 677.02 | 490 | 737 | 395
 | PVC Ball Valve Replacement (socket)
1/2" | Spears Compact Unit | 122.73 | 40 | 10 | 103.5 | 43.77 | 57 | 75 | 5
3/4" | Spears Compact Unit | 124.52 | 57 | 15 | 103.5 | 48.08 | 64 | 80 | 15
1" | Spears Compact Unit | 128.85 | 60 | 20 | 115 | 58.87 | 80 | 90 | 25
1 1/2" | Spears Compact Unit | 181.89 | 138 | 30 | 155 | 93.78 | 140 | 200 | 35
2" | Spears Compact Unit | 193.55 | 150 | 37.5 | 220 | 131.13 | 150 | 230 | 40
3" | Spears Compact Unit | 277 | 480 | 105 | 475 | 262.48 | 395 | 300 | 45
4" | Spears Compact Unit | 374.02 | 620 | 160 | 575 | 430.06 | 699 | 365 | 65
 | Wire Replacement/Repair
 | Regency #14 Gauge, solid copper, UL-UF 24v. White Wire | $ 0.11* | 0.27 | 0.2 | 0.17 | 13.48 | 0.185 | 2.25 | 0.3
 | Regency #14 Gauge, solid copper, UL-UF 24v. Red Wire | $ 0.11* | 0.27 | 0.2 | 0.17 | 13.48 | 0.185 | 2.25 | 0.3
 |  |  |  |  | plus 1 hr. min.
 | Lateral Line PVE Pipe Repair
1/2" lf | Lateral Line PVC Pipe Repair (Class 200 pipe) | $75/hour for crew of 2 plus 15% markup | 0.45 | 0.15 | $14/lf | 25.03 | 1.59 | 2 | 0.55
3/4" lf | Lateral Line PVC Pipe Repair (Class 200 pipe) | $75/hour for crew of 2 plus 15% markup | 0.55 | 0.2 | $17/lf | 25.37 | 1.67 | 2.25 | 0.65
1" lf | Lateral Line PVC Pipe Repair (Class 200 pipe) | $75/hour for crew of 2 plus 15% markup | 0.75 | 0.25 | $22/lf | 26.42 | 1.74 | 2.5 | 0.75
1 1/4" lf | Lateral Line PVC Pipe Repair (Class 200 pipe) | $75/hour for crew of 2 plus 15% markup | 1.15 | 0.35 | $25/lf | 30.19 | 1.9 | 3 | 1.25
1 1/2" lf | Lateral Line PVC Pipe Repair (Class 200 pipe) | $75/hour for crew of 2 plus 15% markup | 1.55 | 0.5 | $32/lf | 31.78 | 2.05 | 3.25 | 1.65
2" lf | Lateral Line PVC Pipe Repair (Class 200 pipe) | $75/hour for crew of 2 plus 15% markup | 2.45 | 0.8 | $39/lf | 55.33 | 3.05 | 3.5 | 1.75
2 1/2" lf | Lateral Line PVC Pipe Repair (Class 200 pipe) | $75/hour for crew of 2 plus 15% markup | 3.5 | 1.25 | $45/lf | 90.92 | 3.47 | 4 | 1.8
3" lf | Lateral Line PVC Pipe Repair (Class 200 pipe) | $75/hour for crew of 2 plus 15% markup | 5.2 | 2 | $58/lf | 216.91 | 5.66 | 5.15 | 2.6
4" lf | Lateral Line PVC Pipe Repair (Class 200 pipe) | $75/hour for crew of 2 plus 15% markup | 8.3 | 3 | $68/lf | 275.83 | 7 | 6 | 3.6
 |  |  |  |  | various minimums for above
 | Main Line PVC Pipe Repair
3/4" lf | Main Line PVC Pipe Repair (Schedule 40 pipe) | $75/hour for crew of 2 plus 15% markup | 0.99 | 0.35 | $19/lf | 68.91 | 1.85 | 2.1 | 0.75
1" lf | Main Line PVC Pipe Repair (Schedule 40 pipe) | $75/hour for crew of 2 plus 15% markup | 1.45 | 0.5 | $24/lf | 100.94 | 2.1 | 3 | 0.95
1 1/4" lf | Main Line PVC Pipe Repair (Schedule 40 pipe) | $75/hour for crew of 2 plus 15% markup | 1.95 | 0.75 | $27/lf | 106.74 | 2.3 | 4 | 1.25
1 1/2" lf | Main Line PVC Pipe Repair (Schedule 40 pipe) | $75/hour for crew of 2 plus 15% markup | 2.25 | 1 | #34/lf | 113.39 | 2.45 | 4.5 | 1.65
2" lf | Main Line PVC Pipe Repair (Schedule 40 pipe) | $75/hour for crew of 2 plus 15% markup | 2.95 | 1.45 | $41/lf | 209.14 | 3.3 | 5 | 1.75
2 1/2" lf | Main Line PVC Pipe Repair (Schedule 40 pipe) | $75/hour for crew of 2 plus 15% markup | 5.1 | 2.25 | $47/lf | 288.3 | 3.97 | 5.1 | 1.8
3" lf | Main Line PVC Pipe Repair (Class 200 pipe) | $75/hour for crew of 2 plus 15% markup | 5.2 | 2 | $58/lf | 307.58 | 5.66 | 5.18 | 2.6
4" lf | Main Line PVC Pipe Repair (Class 200 pipe) | $75/hour for crew of 2 plus 15% markup | 8.3 | 3 | $68/lf | 366.5 | 7 | 6 | 3.6
 |  |  |  |  | various minimums for above
 | Replacement Head with [NAME], Nipple and swing joint
4" | Rainbird -1804- | 16.32 | 15.5 | 15 | 7.5 | 13.87 | 14.5 | 15 | 1.25
6" | Rainbird -1806- | 19.52 | 24.3 | 22.5 | 16.75 | 20.2 | 19.8 | 17 | 5.25
12" | Rainbird -1812- | 21.42 | 32.3 | 30 | 21 | 25.13 | 21.5 | 20 | 6.5
 | [NAME] i20 | 36.3 | 64 | 22.5 | 22 | 29.74 | 58 | 40 | 15.25
 | [NAME] i25 | 52.89 | 110 | 45 | 45.5 | 57.62 | 85 | 54 | 19.75
 | [NAME] Rotor [NAME] | 26.28 | 53 | 17.5 | 15.5 | 25.46 | 58 | 40 | 7.75
 |  |  |  |  | 1 hour min. for above
 | Controller Replacement
 | Battery operated [NAME] node - 100 | 132.87 | 210 | 125 | 114.1 | 142.69 | 130 | 200 | 70
 | Battery operated [NAME] node - 200 | 155.13 | 270 | 150 | 145.5 | 188.79 | 175 | 220 | 90
 | Battery operated [NAME] node - 400 | 177.37 | 340 | 175 | 175 | 240.86 | 240 | 230 | 110
 | Rain Bird ESP Outdoor -up to 4 Station | 165.07 | 248 | 200 | 295 | 161.26 | 188 | 300 | 95
 | Rain Bird ESP Outdoor - up to 7 Station | 193.8 | 324 | 200 | 325 | 217.63 | 288 | 350 | 120
 | Rain Bird ESP Outdoor - up to 10 Station | 222.51 | 400 | 250 | 375 | 274 | 377 | 390 | 145
 | Rain Bird ESP Outdoor - up to 13 Station | 269.96 | 477 | 275 | 425 | 330.37 | 475 | 440 | 170
 | Rain Bird LXM Outdoor -up to 16 Station | 346.69 | 710 | 275 | 525 | 457.8 | 600 | 420 | 255
 | Rain Bird LXM Outdoor -up to 24 Station | 449.69 | 920 | 375 | 675 | 606.31 | 850 | 510 | 345
 | Rain Bird LXM Outdoor -up to 32 Station | 562.49 | 1090 | 475 | 825 | 754.82 | 1090 | 600 | 460
 | Rain Bird LXM Outdoor -up to 48 Station | 759.2 | 1390 | 600 | 1350 | 1027.46 | 1695 | 700 | 640
 |  |  |  |  | 1 hour min. for [NAME] node
 | Rain/Freezer Sensor Installation Existing System
 | Wired Hunter Rain and [NAME] | 80.2 | 84 | 65 | 155 | 92.31 | 125 | 150 | 55
 |  |  |  |  | add $40 post
 | TOTAL FOR REPAIR AND REPLACEMENT COSTS |  | 15642.73 | 5928.199999999999 |  | 13695.39 | 13226.93 | 12002.03 | 8592.300000000001
 | New Landscape Irrigation System Installation
 | PVC Pipe Installation with Trencher (Lateral Line)
1/2"l.f. | Pipe Installation, class 200 pipe | 3.47 | 1 | 1 | $3.00/lf | 1.36 | 1.05 |  | 0.3
3/4"l.f. | Pipe Installation, class 200 pipe | 3.49 | 1.1 | 1 | $5.00/lf | 1.37 | 1.1 |  | 0.2875
1"l.f. | Pipe Installation, Schedule 200 PVC | 3.71 | 1.75 | 1 | $5.00/lf | 1.44 | 1.16 |  | No Bid
1"l.f. | Pipe Installation, class 200 pipe | 3.53 | 1.75 | 1 | $5.00/lf | 1.44 | 1.16 |  | 0.385
1 1/4"l.f. | Pipe Installation, class 200 pipe | 3.64 | 2.75 | 1.25 | $6.00/lf | 1.61 | 1.32 |  | 0.64
1 1/2"l.f. | Pipe Installation, class 200 pipe | 3.73 | 3.5 | 1.5 | $8.50/lf | 1.75 | 1.47 |  | 0.8575
2"l.f. | Pipe Installation, class 200 pipe | 3.94 | 4.25 | 1.5 | $11.00/lf | 2.12 | 1.77 |  | 1.29
2 1/2"l.f. | Pipe Installation, class 200 pipe | 4.19 | 5.25 | 2 | $15.00/lf | 2.52 | 2.38 |  | 1.8575
3"l.f. | Pipe Installation, class 200 pipe | 4.67 | 11 | 2.5 | $21.00/lf | 3.56 | 3.17 |  | 2.925
4"l.f. | Pipe Installation, class 200 pipe | 5.53 | 14 | 3 | $25.00/lf | 4.63 | 4.79 |  | 4.72
 | PVC Pipe Installation with Hand Trenching (Lateral Line)
1/2"l.f. | Pipe Installation, class 200 pipe | 4.18 | 1.5 | 2 | $5.50/lf | 1.29 | 3.13 |  | 1.3
3/4"l.f. | Pipe Installation, class 200 pipe | 4.18 | 1.65 | 2 | $5.50/lf | 1.34 | 3.2 |  | 1.2875
1"l.f. | Pipe Installation, class 200 PVC | 4.22 | 2.6 | 2 | $6.50/lf | 1.38 | 3.25 |  | No Bid
1"l.f. | Pipe Installation, class 200 pipe | 4.22 | 2.6 | 2 | $6.50/lf | 1.38 | 3.25 |  | 1.385
1 1/4"l.f. | Pipe Installation, class 200 pipe | 4.33 | 4.1 | 2.5 | $8.00/lf | 1.55 | 3.4 |  | 1.64
1 1/2"l.f. | Pipe Installation, class 200 pipe | 4.42 | 5.2 | 3 | $11.50/lf | 1.69 | 3.55 |  | 1.8575
2"l.f. | Pipe Installation, class 200 pipe | 4.63 | 5.9 | 3 | $13.50/lf | 2.06 | 3.82 |  | 2.79
2 1/2"l.f. | Pipe Installation, class 200 pipe | 4.88 | 7 | 4 | $18.00/lf | 2.46 | 4.58 |  | 3.3575
3"l.f. | Pipe Installation, class 200 pipe | 5.36 | 14 | 5 | $27.00/lf | 3.5 | 5.67 |  | 4.925
4"l.f. | Pipe Installation, class 200 pipe | 6.22 | 18 | 6 | $37.50/lf | 4.57 | 7 |  | 6.72
 | PVC Pipe Installation with Trencher (Main Line)
1/2"l.f. | Pipe Installation, Schedule 40 PVC | 3.66 | 1.55 | 1 | $3.50/lf | 1.76 | 1.17 |  | 0.3
3/4"l.f. | Pipe Installation, Schedule 40 PVC | 3.66 | 2 | 1 | $5.50/lf | 1.77 | 1.24 |  | 0.2875
1"l.f. | Pipe Installation, Schedule 40 PVC | 3.71 | 2.45 | 1 | $5.50/lf | 1.96 | 1.36 |  | No Bid
1"l.f. | Pipe Installation, Schedule 40 PVC | 3.71 | 2.45 | 1 | $5.50/lf | 1.96 | 1.36 |  | 0.385
1 1/4"l.f. | Pipe Installation, Schedule 40 PVC | 3.84 | 3.55 | 1.25 | $7.50/lf | 2.3 | 1.56 |  | 0.64
1 1/2"l.f. | Pipe Installation, Schedule 40 PVC | 3.94 | 4.75 | 1.5 | $9.50/lf | 2.44 | 1.67 |  | 0.8575
2"l.f. | Pipe Installation, Schedule 40 PVC | 4.12 | 4.75 | 1.5 | $12.50/lf | 2.89 | 1.99 |  | 1.29
2 1/2"l.f. | Pipe Installation, Schedule 40 PVC | 4.61 | 6.8 | 2 | $16.00/lf | 3.59 | 2.88 |  | 1.8575
3"l.f. | Pipe Installation, class 200 pipe | 4.68 | 11 | 2.5 | $22.00/lf | 3.75 | 3.17 |  | 2.925
4"l.f. | Pipe Installation, class 200 pipe | 5.53 | 14 | 3 | $26.00/lf | 4.82 | 4.79 |  | 4.72
 | PVC Pipe Installation with Hand Trenching (Main Line)
1/2"l.f. | Pipe Installation, Schedule 40 PVC | 4.35 | 2.25 | 1 | $4.50/lf | 2.14 | 3.25 |  | 1.3
3/4"l.f. | Pipe Installation, Schedule 40 PVC | 4.35 | 2.7 | 1 | $6.50/lf | 2.2 | 3.55 |  | 1.2875
1"l.f. | Pipe Installation, Schedule 40 PVC | 4.4 | 3.3 | 1 | $6.50/lf | 2.39 | 4.05 |  | No Bid
1"l.f. | Pipe Installation, Schedule 40 PVC | 4.4 | 3.3 | 1 | $6.50/lf | 2.39 | 4.05 |  | 1.385
1 1/4"l.f. | Pipe Installation, Schedule 40 PVC | 4.53 | 4.8 | 1.25 | $8.50/lf | 2.73 | 4.25 |  | 1.64
1 1/2"l.f. | Pipe Installation, Schedule 40 PVC | 4.63 | 5.7 | 1.5 | $10.50/lf | 2.87 | 4.6 |  | 1.8575
2"l.f. | Pipe Installation, Schedule 40 PVC | 4.81 | 6.4 | 2 | $14.50/lf | 3.31 | 5.65 |  | 2.79
2 1/2"l.f. | Pipe Installation, Schedule 40 PVC | 5.3 | 9.1 | 2.5 | $18.00/lf | 4.01 | 6.25 |  | 3.3575
3"l.f. | Pipe Installation, class 200 pipe | 5.36 | 14 | 3 | $25.00/lf | 4.17 | 6.84 |  | 4.925
4"l.f. | Pipe Installation, class 200 pipe | 6.22 | 18 | 4 | $30.00/lf | 5.24 | 8.15 |  | 6.72
 | Entire Double Check Assembly with Isolation valve,
 | Wye strainer, box, and  Backflow Test
1" | Watts Regulator Series 007 w/SS BV Handles | 661.53 | 540 | 450 | 440 | 618.09 | 937 | 400 | 925
1 1/2" | Watts Regulator Series 007 w/SS BV Handles | 841.8 | 1010 | 650 | 725 | 845.19 | 1250 | 700 | 1575
2" | Watts Regulator Series 007 w/SS BV Handles | 1023.74 | 1450 | 675 | 805 | 989.17 | 1325 | 800 | 1750
1" | Febco 850 Series  w/SS BV Handles | 651.89 | 500 | 450 | 425 | 596.7 | 940 | 365 | 780
1 1/2" | Febco 850 Series  w/SS BV Handles | 837.76 | 920 | 650 | 675 | 848.13 | 1175 | 700 | 1375
2" | Febco 850 Series  w/SS BV Handles | 898.08 | 1220 | 675 | 775 | 985.73 | 1300 | 730 | 1525
 | Electronic Valves with [NAME]
1" | [NAME] | 156.29 | 210 | 125 | 95 | 153.83 | 358 | 150 | 180
1 1/2" | [NAME] | 177.58 | 260 | 175 | 205 | 177.05 | 390 | 200 | 225
2" | [NAME] | 209.9 | 335 | 200 | 250 | 231.7 | 425 | 250 | 295
 | New Irrigation System Wiring
lf | #14 Gauge, solid copper, UL-UF 24v. Wire only | 0.11 | 0.27 | 0.2 | 0.15 | 0.14 | 0.121 |  | 0.135
lf | Labor to install wire | $75/hour for crew of 2 | 0.05 | 0.2 | 5 | 0.01 | 0.06 |  | 0.1
 | New Installation System Heads with [NAME] and swing joints
4" | Rainbird -1804 | 16.32 | 15.5 | 2 | 9.75 | 9.84 | 14.5 |  | 8.75
6" | Rainbird -1806 | 19.52 | 24.3 | 3 | 19.75 | 16.18 | 19 |  | 15
12" | Rainbird -1812 | 21.42 | 32.3 | 3.5 | 27.5 | 19.09 | 23 |  | 22.5
 | [NAME] i20 | 36.3 | 64 | 3.75 | 32 | 23.7 | 57 |  | 47
 | [NAME] i25 | 52.86 | 110 | 3.75 | 55.5 | 52.78 | 89 |  | 110
 | [NAME] Rotor [NAME] | 26.28 | 53 | 3.75 | 25.5 | 19.42 | 52.5 |  | 40
 | New Installation Quick Coupler Valve & Box
 | Rain [NAME] | 112.04 | 195 | 125 | 152 | 178.81 | 253 | 175 | 177.5
 | Hourly Rates
HR | Minimum Service Call | 1 hour |  |  | 95 | 230 |  |  | 75
HR | 2 man service truck | 75 | 78 | 150 | 95 | 115 | 130 | 150 | 110
HR | 3 man service truck | 105 | 104 | 200 | 135 | 148 | 185 | 185 | 140
HR | 4 man service truck | 135 | 130 | 250 | 175 | 132 | 220 | 210 | 165
 | TOTAL FOR NEW IRRIGATION SYSTEM INSTALLATION COSTS |  | 7483.170000000001 | 4876.4 |  | 6492.270000000002 | 9275.230999999998 |  | 9618.035
 |  | * + $75/hour for crew of 2