Cost_Breakdown_Summary.xlsx

XLSX spreadsheet 24 KB Posted

Attached to
Access Control Upgrade State and local contract opportunity
Solicitation number
074-2025-IFB-G
Issued by
Hamilton County, Cleveland City, Ohio

About this file

The document is a Cost Breakdown Summary spreadsheet for the Southwest Ohio Regional Transit Authority (SORTA) Access Control Upgrade project (Contract 074-2025), detailing a comprehensive electronic security system upgrade across seven facilities: Huntington Center, Queensgate, Bond Hill, Access, Riverfront Transit, Northside Transit, and Glenway Crossing Transit Center. The project involves replacing existing access control infrastructure with a new Genetec Security Center (version 5.12) system, including access control head-end equipment, work stations, badging systems, security devices, card readers, door controllers, and 1,500 HID Crescendo 144K Proximity Cards. The solicitation was released on August 21, 2025, with a pre-proposal meeting scheduled for September 9, 2025, and bid responses due by September 30, 2025, at 2:00 pm.

The cost breakdown spreadsheet provides a detailed line-item template for bidders to complete, with zero-dollar placeholders for unit costs across multiple facility locations. While specific budget allocations are not filled in, the project requires a firm-fixed price proposal covering all labor, installation, materials, parts, equipment, and delivery costs. The upgrade involves migrating from an existing AMAG Symmetry access control system to a new IP-based Ethernet network infrastructure, with requirements for 90-minute battery backup, comprehensive system testing, personnel training, and documentation. Though no specific Disadvantaged Business Enterprise (DBE) participation goal is established, the project includes federal requirements such as Davis-Bacon Act compliance and is designed to modernize SORTA's electronic security and access control systems across its transit facilities.

View the file

Other files for this state and local contract opportunity

Other files attached to Access Control Upgrade, newest first.
File Type Posted
Access_Control_Upgrade_(Addendum_#6_Revision).pdf PDF
Access_Control_Upgrade_(Addendum_#6_Revision).pdf PDF
Access_Control_Upgrade_(Addendum_#6_Revision).pdf PDF
Revised_Specifications.pdf PDF
Revised_Specifications.pdf PDF
Revised_Specifications.pdf PDF
Cost_Breakdown_Summary.xlsx XLSX spreadsheet
Cost_Breakdown_Summary.xlsx XLSX spreadsheet
Prevailing_Wage_Determination.pdf PDF
Prevailing_Wage_Determination.pdf PDF
Prevailing_Wage_Determination.pdf PDF
CD_ProjectNarrative-2024.09.25.pdf PDF
CD_Product_Data_Sheets.pdf PDF
CDDrawings-FINAL-2024.09.25.pdf PDF
CD_Product_Data_Sheets.pdf PDF
CD_Product_Data_Sheets.pdf PDF
CD_ProjectNarrative-2024.09.25.pdf PDF
CD_Specifications-09.25.2024.pdf PDF
CDDrawings-FINAL-2024.09.25.pdf PDF
CD_Specifications-09.25.2024.pdf PDF
CDDrawings-FINAL-2024.09.25.pdf PDF
CD_ProjectNarrative-2024.09.25.pdf PDF
CD_Specifications-09.25.2024.pdf PDF
General_Terms_and_Conditions.pdf PDF
Federal_Clauses_-_Terms_and_Conditions_-_Construction.pdf PDF
General_Terms_and_Conditions.pdf PDF
Federal_Clauses_-_Terms_and_Conditions_-_Construction.pdf PDF
Federal_Clauses_-_Terms_and_Conditions_-_Construction.pdf PDF
General_Terms_and_Conditions.pdf PDF
Show all 29

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Cost Breakdown 074-2025 COST BREAKDOWN SUMMARY 074-2025 Access Control Upgrade Submit All Inclusive Pricing (Manufacturer brand names are examples only)

Div. 28 Electronic Safety and Security
Item DescriptionHrly RateComments
Shift Work Premium$ - 0
Item DescriptionQuantityUnitUnit CostTotalComments
Enter #Enter $Auto Fills
HUNTINGTON CENTER FACILITY
Access Control Head End1Unit$ - 0$ - 0
Work StationUnit$ - 0$ - 0
Badging SystemUnit$ - 0$ - 0
Export Existing Data Base and ModifyUnit$ - 0$ - 0
Download New Data Base into New SystemUnit$ - 0$ - 0
Security Devices: Card ReadersEA$ - 0$ - 0
Altronix T1MK1F4D 8-Door Enclosure KitEA$ - 0$ - 0
Altronix T1MK1F4D 16-Door Enclosure KitEA$ - 0$ - 0
Syngergis Cloud LinkEA$ - 0$ - 0
Intelligent Door Controller (Mercury 1502)EA$ - 0$ - 0
Door Controller (Mercury 52)EA$ - 0$ - 0
Door Controller/Gateway (CTE Wiring Systems)EA$ - 0$ - 0
Wire Trough & CoversLF$ - 0$ - 0
HID Crescendo 144K Proximity Cards375EA$ - 0$ - 0
Pre-testing: Wiring and device testing; ReportsEA$ - 0$ - 0
Relocate Sound Masking Control Panel and Power SuppliesUnit$ - 0$ - 0
Testing, Permit, EtcLOT$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
QUEENSGATE FACILITY
Access Control Head End1Unit$ - 0$ - 0
Work StationUnit$ - 0$ - 0
Badging SystemUnit$ - 0$ - 0
Export Existing Data Base and ModifyUnit$ - 0$ - 0
Download New Data Base into New SystemUnit$ - 0$ - 0
Security Devices: Card ReadersEA$ - 0$ - 0
Altronix T1MK1F4D 8-Door Enclosure KitEA$ - 0$ - 0
Altronix T1MK1F4D 16-Door Enclosure KitEA$ - 0$ - 0
Syngergis Cloud LinkEA$ - 0$ - 0
Intelligent Door Controller (Mercury 1502)EA$ - 0$ - 0
Door Controller (Mercury 52)EA$ - 0$ - 0
Door Controller/Gateway (CTE Wiring Systems)EA$ - 0$ - 0
Wire Trough & CoversLF$ - 0$ - 0
HID Crescendo 144K Proximity Cards375EA$ - 0$ - 0
Pre-testing: Wiring and device testing; ReportsEA$ - 0$ - 0
Testing, Permit, EtcLOT$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
Div. 28 Electronic Safety and Security
Item DescriptionQuantityUnitUnit CostTotalComments
Enter #Enter $Auto Fills
BOND HILL FACILITY
Access Control Head End1Unit$ - 0$ - 0
Work StationUnit$ - 0$ - 0
Badging SystemUnit$ - 0$ - 0
Export Existing Data Base and ModifyUnit$ - 0$ - 0
Download New Data Base into New SystemUnit$ - 0$ - 0
Security Devices: Card ReadersEA$ - 0$ - 0
1F4D 8-Door Enclosure KitEA$ - 0$ - 0
Altronix T1MK1F4D 16-Door Enclosure KitEA$ - 0$ - 0
Syngergis Cloud LinkEA$ - 0$ - 0
Intelligent Door Controller (Mercury 1502)EA$ - 0$ - 0
Door Controller (Mercury 52)EA$ - 0$ - 0
Door Controller / Gateway (CTE Wiring Systems)EA$ - 0$ - 0
Wire Trough & CoversLF$ - 0$ - 0
HID Crescendo 144K Proximity Cards375EA$ - 0$ - 0
Pre-testing: Wiring and device testing; ReportsEA$ - 0$ - 0
Testing, Permit, EtcLOT$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
ACCESS FACILITY
Access Control Head End1Unit$ - 0$ - 0
Work StationUnit$ - 0$ - 0
Badging SystemUnit$ - 0$ - 0
Export Existing Data Base and ModifyUnit$ - 0$ - 0
Download New Data Base into New SystemUnit$ - 0$ - 0
Security Devices: Card ReadersEA$ - 0$ - 0
Altronix T1MK1F4D 16-Door Enclosure KitEA$ - 0$ - 0
Syngergis Cloud LinkEA$ - 0$ - 0
Intelligent Door Controller (Mercury 1502)EA$ - 0$ - 0
Door Controller (Mercury 52)EA$ - 0$ - 0
Door Controller / Gateway (CTE Wiring Systems)EA$ - 0$ - 0
Door Controller (Extend Wiring to New Enclosure Location)LF$ - 0$ - 0
Wire Trough & CoversLF$ - 0$ - 0
HID Crescendo 144K Proximity Cards375EA$ - 0$ - 0
Pre-testing: Wiring and device testing; ReportsEA$ - 0$ - 0
Testing, Permit, EtcLOT$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
Div. 28 Electronic Safety and Security
Item DescriptionQuantityUnitUnit CostTotalComments
Enter #Enter $Auto Fills
RIVERFRONT TRANSIT FACILITY
Access Control Head End1Unit$ - 0$ - 0
Export Existing Data Base and ModifyUnit$ - 0$ - 0
Download New Data Base into New SystemUnit$ - 0$ - 0
Security Devices: Card ReadersEA$ - 0$ - 0
Altronix T1MK1F4D 4-Door Enclosure KitEA$ - 0$ - 0
Syngergis Cloud LinkEA$ - 0$ - 0
Intelligent Door Controller (Mercury 1502)EA$ - 0$ - 0
Door Controller / Gateway (CTE Wiring Systems)EA$ - 0$ - 0
Pre-testing: Wiring and device testing; ReportsEA$ - 0$ - 0
Testing, Permit, EtcLOT$ - 0$ - 0
NORTHSIDE TRANSIT FACILITY
Access Control Head End1Unit$ - 0$ - 0
Export Existing Data Base and ModifyUnit$ - 0$ - 0
Download New Data Base into New SystemUnit$ - 0$ - 0
Security Devices: Card ReadersEA$ - 0$ - 0
Altronix T1MK1F4D 4-Door Enclosure KitEA$ - 0$ - 0
Syngergis Cloud LinkEA$ - 0$ - 0
Intelligent Door Controller (Mercury 1502)EA$ - 0$ - 0
Door Controller/ Gateway (CTE Wiring Systems)EA$ - 0$ - 0
Pre-testing: Wiring and device testing; ReportsEA$ - 0$ - 0
Testing, Permit, EtcLOT$ - 0$ - 0
GLENWAY CROSSING TRANSIT FACILITY
Access Control Head End1Unit$ - 0$ - 0
Export Existing Data Base and ModifyUnit$ - 0$ - 0
Download New Data Base into New SystemUnit$ - 0$ - 0
Security Devices: Card ReadersEA$ - 0$ - 0
Altronix T1MK1F4D 4-Door Enclosure KitEA$ - 0$ - 0
Syngergis Cloud LinkEA$ - 0$ - 0
Intelligent Door Controller (Mercury 1502)EA$ - 0$ - 0
Door Controller (Mercury 52)EA$ - 0$ - 0
Door Controller (CTE Wiring Systems)EA$ - 0$ - 0
Pre-testing: Wiring and device testing; ReportsEA$ - 0$ - 0
Testing, Permit, EtcLOT$ - 0$ - 0

&P of &N

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