Cost_Breakdown_Summary.xlsx

XLSX spreadsheet 24 KB Posted

Attached to
Access Control Upgrade
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

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

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 .