180-25_RevA-pricing.xlsx

XLSX spreadsheet 30 KB Posted

Attached to
Competitive Selection OH|DOT18025-4
Contract number
DOT18025-4
Issued by
Ohio

About this file

This document is a comprehensive state and local contract pricing schedule for Ohio Traffic and Lighting Solutions, Inc., specifically appearing to be a state contract for the Ohio Department of Transportation (ODOT). The document is a detailed pricing spreadsheet (File ID: 67c0a30f80048c4702e0d982e3003e85) that outlines pricing for various lighting, electrical, and infrastructure components across multiple product groups.

The contract covers an extensive range of goods including high-pressure sodium lamps, hardware kits, distribution cables, transformer bases, LED luminaires, light poles, photocells, surge protective devices, and foundation components. Pricing is itemized by specific product specifications, with detailed unit prices for each item. The contract is structured into 16 distinct product groups, with multiple award options for certain categories. Manufacturers include Cooper Lighting Solutions and Millerbernd Mfg Co, with prices ranging from as low as $7.45 for hex nuts to $4,247 for 40-foot light poles. The pricing appears to be firm for the contract's duration, with specific technical requirements outlined for each product category, suggesting a comprehensive infrastructure and lighting procurement vehicle for state transportation projects.

View the file

Other files

File Type Posted
180-25_RevA-spec.pdf PDF
Affirmation_and_Disclosure__5_.pdf PDF
ODOT_Co-Op_Program_Information.pdf PDF
Signature__4___1___002_.pdf PDF

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

Pricing

180-24 PRICING
Vendor Name:Ohio Traffic and Lighting Solutions, Inc.
Please quote and insert below, your lowest net delivered prices for the commodities (or services) herein described, guaranteed firm for the contract duration.
ItemQty.UnitDescriptionUnit Bid PriceManufacturer NameModel Number
11EachLamp, 100 Watt HPS as described in Section 17 of the specificationsXXXXXXXXXXXX
21EachLamp, 200 Watt HPS as described in Section 18 of the specifications.XXXXXXXXXXXX
31EachLamp, 250 Watt HPS as described in Section 19 of the specifications.XXXXXXXXXXXX
41EachLamp, 310 Watt HPS as described in Section 20 of the specifications.XXXXXXXXXXXX
51EachLamp, 400 Watt HPS as described in Section 21 of the specifications.XXXXXXXXXXXX
61EachLamp, 1000 Watt HPS as described in Section 22 of the specificationsXXXXXXXXXXXX
GROUP 1-- FOR HISTORICAL REFERENCE ONLY-- DO NOT BID
71EachHardware Kit for Fused Pull-Apart Connection, 4 AWG Line, 10 AWG Load as described in Section 23 of the specifications.
81EachHardware Kit for Fused Pull-Apart Connection, 2 AWG Line, 10 AWG Load as described in Section 24 of the specifications.
91EachHardware Kit for Unfused Pull-Apart Connection, 4 AWG Line, 10 AWG Load as described in Section 25 of the specifications.
101EachHardware Kit for Unfused Pull-Apart Connection, 2 AWG Line, 10 AWG Load as described in Section 26 of the specifications.
111EachHardware Kit for Unfused Bolted Connection, 4 AWG as described in Section 27 of the specifications.
121EachHardware Kit for Unfused Bolted Connection, 2 AWG as described in Section 28 of the specifications.
131EachHardware Kit for Unfused Permanent Connection, 2-wire, as described in Section 29 of the specifications.
141EachHardware Kit for Unfused Permanent Connection, 3-wire, as described in Section 29 of the specifications.
151EachGround Enhancing Material- for increasing performance of grounding electrodes, meeting IEC 62561-7, dry, 25 lb. bag (min.)
161EachSplit Grounding Bushing, 2-inch NPT, die cast zinc, Garvin SGB series or equal
171EachSplit Grounding Bushing, 2-1/2-inch NPT, die cast zinc, Garvin SGB series or equal
181EachSplit Grounding Bushing, 3-inch NPT, die cast zinc, Garvin SGB series or equal
GRAND TOTAL FOR GROUP 2, Miscellaneous Lighting Hardware (low bid)$0.00
191SpoolDistribution Cable 4 AWG UL, 2.4kV, 500 Ft. Spool as described in Section 30 of the specifications.
201SpoolDistribution Cable 2 AWG UL, 2.4kV, 500 Ft. Spool as described in Section 30 of the specifications.
211SpoolDistribution Cable 1/0 AWG UL, 2.4kV, 500 Ft. Spool as described in Section 30 of the specifications, for ITS use. Black.
221SpoolDistribution Cable 2 AWG UL, 600V, 500 Ft. Spool as described in Section 30 of the specifications. Color as specified (KRWGB).
231SpoolDistribution Cable 4 AWG UL, 600V, 500 Ft. Spool as described in Section 30 of the specifications. Color as specified (KRWGB).
241SpoolDistribution Cable 6 AWG UL, 600V, 500 Ft. Spool as described in Section 30 of the specifications. Color as specified (KRWGB).
251SpoolPole and Bracket Cable, 10 AWG UL, 2.4kV, 500 Ft spool as described in Section 31 of the specifications
261SpoolPole and Bracket Cable, 10 AWG UL, 600 Volt, 500 Ft spool as described in Section 32 of the specifications
271SpoolDuct Cable 1-1/2" with three 4 AWG UL, 2.4kV Cables, 500 Ft. spool as described in Section 33 of the specifications.
281SpoolDuct Cable 2-1/2" with three 2 AWG UL, 2.4kV Cables, 500 Ft. spool as described in Section 33 of the specifications.
291SpoolDistribution Cable 4 AWG UL, 2.4kV, 2500 Ft. Spool as described in Section 30 of the specifications.
301SpoolDistribution Cable 2 AWG UL, 2.4kV, 2500 Ft. Spool as described in Section 30 of the specifications.
311SpoolDistribution Cable 1/0 AWG UL, 600V, 2500 Ft. Spool as described in Section 30 of the specifications, for ITS use. Black.
321SpoolDistribution Cable 2 AWG UL, 600V, 2500 Ft. Spool as described in Section 30 of the specifications. Color as specified (KRWGB).
331SpoolDistribution Cable 4 AWG UL, 600V, 2500 Ft. Spool as described in Section 30 of the specifications. Color as specified (KRWGB).
341SpoolDistribution Cable 6 AWG UL, 600V, 2500 Ft. Spool as described in Section 30 of the specifications. Color as specified (KRWGB).
351SpoolPole and Bracket Cable, 10 AWG UL, 2.4kV, 2500 Ft spool as described in Section 31 of the specifications
361SpoolPole and Bracket Cable, 10 AWG UL, 600 Volt, 2500 Ft spool as described in Section 32 of the specifications
371SpoolDuct Cable 1-1/2" with three 4 AWG UL, 2.4kV Cables, 2500 Ft. spool as described in Section 33 of the specifications.
381SpoolDuct Cable 2-1/2" with three 2 AWG UL, 2.4kV Cables, 2500 Ft. spool as described in Section 33 of the specifications.
GRAND TOTAL FOR GROUP 3, Wire for Highway Lighting (low bid)$0.00
391EachFrangible Transformer Base, ODOT Type AT-A, 1985 AASHTO Criteria, as described in Section 34 of the specifications.$656.00Millerbernd Mfg CoAKRON FOUNDRY FRANGIBLE T-BASE, ODOT TYPE AT-A, TB1-17
401EachFrangible Transformer Base, ODOT Type AT-C, 1985 AASHTO Criteria, as described in Section 35 of the specifications.$938.00Millerbernd Mfg CoAKRON FOUNDRY FRANGIBLE T-BASE, ODOT TYPE AT-C, TB3-17
411EachFrangible Transformer Base, ODOT Type AT-A, 1975 AASHTO Criteria, as described in Section 36 of the specifications.$724.00Millerbernd Mfg CoAKRON FOUNDRY FRANGIBLE T-BASE, ODOT TYPE AT-A, TB1-20
421EachFrangible Transformer Base, ODOT Type AT-C, 1975 AASHTO Criteria, as described in Section 37 of the specifications.$1,009.00Millerbernd Mfg CoAKRON FOUNDRY FRANGIBLE T-BASE, ODOT TYPE AT-C, TB3-20
431EachTbase Bolt, 1" x 4", A-325, Hot Dipped Galvanized as described in Section 38 of the specifications$10.40Millerbernd Mfg CoT-BASE BOLT, 1" X 4" A-325 - HD GALVANIZED
441EachTbase Hex Nut, 1", A-194-2h, Hot Dipped Galvanized as described in Section 39 of the specifications$7.45Millerbernd Mfg CoT-BASE HEX NUT, 1" A-194-2H - HD GALVANIZED
451EachTbase Bolt, 1.25" x 5", A-325, Hot Dipped Galvanized as described in Section 38 of the specifications$23.75Millerbernd Mfg CoT-BASE BOLT, 1.25" X 5" A-325 - HD GALVANIZED
461EachTbase Hex Nut, 1.25", A-194-2h, Hot Dipped Galvanized as described in Section 39 of the specifications$14.85Millerbernd Mfg CoT-BASE HEX NUT, 1.25" A-194-2H - HD GALVANIZED
GRAND TOTAL FOR GROUP 4, Transformer Bases and Hardware (Multiple Award)$3,383.45
471EachPull Box with Cover, Lightweight Polymer Concrete or Plastic, 725.06 or 725.07, 12" x 24" x 24" nominal, Tier 15, per Section 40 of the Specifications.
GRAND TOTAL FOR GROUP 5, Lightweight Pull Box (low bid)$0.00
481EachLuminaire, Solid-State, Conventional type, IES Type II, III, or V as specified at time of order, Medium distribution, must be on ODOT SS 813 Approved List, no photocell socket, silver or grey enclosure, 120V-277V universal input. 8K-9.999K lumens.$348.80Cooper Lighting SolutionsARCH-M-PA2-60-730-U-T(2, 3, OR 5)-AP-10K-4B-10X
491EachLuminaire, Solid-State, Conventional type, IES Type II, III, or V as specified at time of order, Medium distribution, must be on ODOT SS 813 Approved List, no photocell socket, silver or grey enclosure, 480V L-L or L-N compatible input as specified at time of order. 8K-9.999K lumens.$383.65Cooper Lighting SolutionsARCH-M-PA2-60-730-8-T(2, 3, OR 5)-AP-20KI-4B-10X
501EachLuminaire, Solid-State, Conventional type, IES Type II, III, or V as specified at time of order, Medium distribution, must be on ODOT SS 813 Approved List, no photocell socket, silver or grey enclosure, 120V-277V universal input. 10K-12.999K lumens.$348.80Cooper Lighting SolutionsARCH-M-PA2-70-730-U-T(2, 3, OR 5)-AP-10K-4B-10X
511EachLuminaire, Solid-State, Conventional type, IES Type II, III, or V as specified at time of order, Medium distribution, must be on ODOT SS 813 Approved List, no photocell socket, silver or grey enclosure, 480V L-N or L-L compatible input as specified at time of order. 10K-12.999K lumens.$383.65Cooper Lighting SolutionsARCH-M-PA2-70-730-8-T(2, 3, OR 5)-AP-20KI-4B-10X
521EachLuminaire, Solid-State, Conventional type, IES Type II, III, or V as specified at time of order, Medium distribution, must be on ODOT SS 813 Approved List, no photocell socket, silver or grey enclosure, 120V-277V universal input. 13K-15.999K lumens.$348.80Cooper Lighting SolutionsARCH-M-PA2-90-730-U-T(2, 3, OR 5)-AP-10K-4B-10X
531EachLuminaire, Solid-State, Conventional type, IES Type II or III as specified at time of order, Medium distribution, must be on ODOT SS 813 Approved List, no photocell socket, silver or grey enclosure, 480V L-N or L-L compatible input as specified at time of order. 13K-15.999K lumens.$383.65Cooper Lighting SolutionsARCH-M-PA2-90-730-8-T(2, 3, OR 5)-AP-20KI-4B-10X
541EachLuminaire, Solid-State, Conventional type, IES Type II, III, or V as specified at time of order, Medium distribution, must be on ODOT SS 813 Approved List, no photocell socket, silver or grey enclosure, 120V-277V universal input. 16K-20.999K lumens.$364.15Cooper Lighting SolutionsARCH-M-PA2-120-730-U-T(2, 3, OR 5)-AP-10K-4B-10X
551EachLuminaire, Solid-State, Conventional type, IES Type II or III as specified at time of order, Medium distribution, must be on ODOT SS 813 Approved List, no photocell socket, silver or grey enclosure, 480V L-N or L-L compatible input as specified at time of order. 16K-20.999K lumens.$399.00Cooper Lighting SolutionsARCH-M-PA2-120-730-8-T(2, 3, OR 5)-AP-20KI-4B-10X
561EachLuminaire, Solid State, Underpass, IES Type IV or equivalent, input voltage as specified at time of order, must be on SS 813 Approved List, 8000-10000 lumens.$405.95Cooper Lighting SolutionsWKP-XXLED-730-U-GL-AP-20MSP-FADC-U125292
571EachOutput Adjust Potentiometer (~10%-100%) for Luminaires above, with 8" (min) pigtail wires and wire nuts for attaching to LED Driver dimming input wires.$20.95Cooper Lighting SolutionsFADC (FOR ABOVE)
581EachHouse-Side Shield for Conventional Luminaire as bid above, silver or grey to match luminaire.$90.10Cooper Lighting Solutions(2) HS/ARCH
GRAND TOTAL FOR GROUP 6, LED Conventional and Underpass Luminaires (multiple award)$3,477.50
591EachLuminaire, Solid State, High Mast, Distribution as Specified at time of order, 55K-64.999K lumens, input voltage as specified at time of order, must be on ODOT SS 813 Approved List.$1,145.35Cooper Lighting SolutionsCST-CA8-400-730-8-T*-AP-20KI-SS-10X
601EachLuminaire, Solid State, High Mast, Distribution as Specified at time of order, 65K-74.999K lumens, input voltage as specified at time of order, must be on ODOT SS 813 Approved List.$1,145.35Cooper Lighting SolutionsCST-CA8-430-730-8-T*-AP-20KI-SS-10X
611EachLuminaire, Solid State, High Mast, Distribution as Specified at time of order, 75K-84.999K lumens, input voltage as specified at time of order, must be on ODOT SS 813 Approved List.$1,282.50Cooper Lighting SolutionsCST-CA10-490-730-8-T*-AP-20KI-SS-10X
621EachLuminaire, Solid State, High Mast, Distribution as Specified at time of order, 85K-94.999K lumens, input voltage as specified at time of order, must be on ODOT SS 813 Approved List.$1,282.50Cooper Lighting SolutionsCST-CA10-630-730-8-T*-AP-20KI-SS-10X
631EachOutput adjustment resistor module for the LED high/low mast luminaires above, when needed to adjust lumen output downward from maximum.$20.95Cooper Lighting SolutionsFADC (FOR ABOVE)
641EachHouse-side shield for High Mast Luminaires above, maximum shielding available.$108.15Cooper Lighting SolutionsHSS-HM-EX120
GRAND TOTAL FOR GROUP 7, High and Low Mast LED Luminaires (multiple award)$4,984.80
651EachLuminaire, Solid-State, Conventional type, with glass secondary optics, IES Type II or III as specified, Medium distribution, 8500-12000 lumens, must be on ODOT SS 813 Approved List, no photocell socket, silver or grey enclosure, 120V-277V universal input.
661EachLuminaire, Solid-State, Conventional type, with glass secondary optics, IES Type II or III as specified, Medium distribution, 8500-12000 lumens, must be on ODOT SS 813 Approved List, no photocell socket, silver or grey enclosure, 480V input, L-N or L-L as specified at time of order.
671EachLuminaire, Solid-State, Conventional type, with glass secondary optics, IES Type II or III as specified, Medium distribution, 12000-16000 lumens, must be on ODOT SS 813 Approved List, no photocell socket, silver or grey enclosure, 120V-277V universal input.
681EachLuminaire, Solid-State, Conventional type, with glass secondary optics, IES Type II or III as specified, Medium distribution, 12000-16000 lumens, must be on ODOT SS 813 Approved List, no photocell socket, silver or grey enclosure, 480V input, L-N or L-L as specified at time of order.
691EachLuminaire, Solid State, Underpass, with glass secondary optics, IES Type IV, must be on SS 813 Approved List
GRAND TOTAL FOR GROUP 8, Urban-Area (Glass) LED Luminaires (multiple award)$0.00
701EachPrecast Support Foundation, 6', meeting Supplemental Specification 812, delivery within District 1 or 2 (See Section 41)
711EachPrecast Support Foundation, 8', meeting Supplemental Specification 812, delivery within District 1 or 2 (See Section 41)
721EachPrecast Support Foundation, 6', meeting Supplemental Specification 812, delivery within District 3 or 12 (See Section 41)
731EachPrecast Support Foundation, 8', meeting Supplemental Specification 812, delivery within District 3 or 12 (See Section 41)
741EachPrecast Support Foundation, 6', meeting Supplemental Specification 812, delivery within District 4 or 11 (See Section 41)
751EachPrecast Support Foundation, 8', meeting Supplemental Specification 812, delivery within District 4 or 11 (See Section 41)
761EachPrecast Support Foundation, 6', meeting Supplemental Specification 812, delivery within District 7 or 8 (See Section 41)
771EachPrecast Support Foundation, 8', meeting Supplemental Specification 812, delivery within District 7 or 8 (See Section 41)
781EachPrecast Support Foundation, 6', meeting Supplemental Specification 812, delivery within District 9 or 10 (See Section 41)
791EachPrecast Support Foundation, 8', meeting Supplemental Specification 812, delivery within District 9 or 10 (See Section 41)
801EachPrecast Support Foundation, 6', meeting Supplemental Specification 812, delivery within District 5 or 6 (See Section 41)
811EachPrecast Support Foundation, 8', meeting Supplemental Specification 812, delivery within District 5 or 6 (See Section 41)
GRAND TOTAL FOR GROUP 9, Precast Light Pole Foundations (multiple award)$0.00
821EachMechanical lighting wire connector, multiport, Ilsco PBTS-2-4 or equal
831EachMechanical lighting wire connector, multiport, Ilsco PBTS-3-4 or equal
841EachMechanical lighting wire connector, multiport, Ilsco PBTS-4-4 or equal
851EachMechanical lighting wire connector, multiport, Ilsco PBTD-2-4 or equal
861EachMechanical lighting wire connector, multiport, Ilsco PBTD-3-4 or equal
871EachMechanical lighting wire connector, multiport, Ilsco PBTD-4-4 or equal
GRAND TOTAL FOR GROUP 10, Mechanical Wire Connections (low bid)$0.00
881EachStainless Steel Hoist Cable Set with hardware for Holophane High Mast Lowering Device cable Replacement, sufficient for 100-120 foot tower.
GRAND TOTAL FOR GROUP 11, Holophane Hoist Cable Replacement Set (low bid)$0.00
891EachSurge Protective Device (SPD) for luminaire, 120V-277V (min.), meeting SS 913.5
901EachSurge Protective Device (SPD) for luminaire, 480V, L-N or L-L as specified at time of order, meeting SS 913.5
911EachSurge Protective Device (SPD) for HL-40.20 LCC, external, 120-277V, L-N or L-L as specified at time of order
921EachSurge Protective Device (SPD) for HL-40.20 LCC, external, 480V, L-N or L-L as specified at time of order
931EachSurge Protective Device (SPD) for HL-40.20 LCC, internal, 120-277V, L-N or L-L as specified at time of order
941EachSurge Protective Device (SPD) for HL-40.20 LCC, internal, 480V, L-N or L-L as specified at time of order
GRAND TOTAL FOR GROUP 12, Surge Protective Devices for Luminaires and Lighting Control Centers (LCCs) (Multiple Award)$0.00
951EachLight Pole, aluminum or steel as specified at time of order, 4-bolt attachments for single low-rise truss arm, square base or HL-20.13 median mount base as specified, 30' luminaire MH$3,622.00Millerbernd Mfg CoLIGHT POLE, STEEL - 30' LMH, A-BASE, 4-BOLT - GV
961EachLight Pole, aluminum or steel as specified at time of order, 4-bolt attachments for single low-rise truss arm, square base or HL-20.13 median mount base as specified, 40' luminaire MH$4,247.00Millerbernd Mfg CoLIGHT POLE, STEEL - 40' LMH, A-BASE, 4-BOLT - GV
971EachArm, low-rise truss, to match pole above, aluminum or steel as specified at time of order, 16-20 feet as specified$1,284.00Millerbernd Mfg CoARM, STEEL - HIGH-RISE TRUSS - 16'-20' - GV
981EachArm, low-rise truss, to match pole above, aluminum or steel as specified at time of order, 22-26 feet as specified$1,745.00Millerbernd Mfg CoARM, STEEL - HIGH-RISE TRUSS - 22'-26' - GV
991EachArm, low-rise truss, to match pole above, aluminum or steel as specified at time of order, 28-32 feet as specified$1,904.00Millerbernd Mfg CoARM, STEEL - HIGH-RISE TRUSS - 28'-30' - GV
GRAND TOTAL FOR GROUP 13, Conventional Light Poles (multiple award)$12,802.00
1001EachLight pole Breakaway Coupler Kit for installation on existing 1-inch anchor bolt foundation, OAH 5-7 inches, FHWA-accepted (NCHRP 350), set of four.$581.00Millerbernd Mfg CoTRANSPO, 1" BREAK-AWAY COUPLING SET OF (4)
1011EachWrap-around varmint guard for breakaway couplers above, steel or aluminum and length as specified at time of order$98.00Millerbernd Mfg CoTRANSPO, 1" COUPLING SKIRT
GRAND TOTAL FOR GROUP 14, Breakaway Couplers (Multiple Award)$679.00
1021EachAuger-in foundation for traffic pedestal use, galvanized steel, compatible with ODOT standard TC-83.20 T-bases, 4" min shaft diameter x 84" min. length (See Section 42)
1031EachAuger-in foundation for light pole use, galvanized steel, compatible with ODOT standard HL-10.13 AT-A and AT-C T-bases, 10" min shaft diameter x 120" min. length (See Section 42)
GRAND TOTAL FOR GROUP 15, Auger-In Foundations (Multiple Award)$0.00
1041EachPhotocell, UG, CdS, meeting 725.19.E, 120-277 VAC nom.$32.65Cooper Lighting SolutionsOA/RA1016
1051EachPhotocell, UG, CdS, meeting 725.19.E, 480 VAC nom.$39.80Cooper Lighting SolutionsOA/RA1027
1061EachPhotocell, UG, Si Photodiode, meeting 725.19.E setpoints, 120-277VAC nom. VAC (blue)
1071EachPhotocell, UG, Si photodiode, meeting 725.19.E setpoints, 480 VAC nom.
GRAND TOTAL FOR GROUP 16, Photocells for LED luminaires and Lighting Control Centers (Multiple Award)$72.45

&G

File details come from the government source that posted it. Updated .