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 Description | Hrly Rate | Comments |
| Shift Work Premium | $ - 0 |
| Item Description | Quantity | Unit | Unit Cost | Total | Comments |
| Enter # | Enter $ | Auto Fills | |||
| HUNTINGTON CENTER FACILITY | |||||
| Access Control Head End | 1 | Unit | $ - 0 | $ - 0 | |
| Work Station | Unit | $ - 0 | $ - 0 | ||
| Badging System | Unit | $ - 0 | $ - 0 | ||
| Export Existing Data Base and Modify | Unit | $ - 0 | $ - 0 | ||
| Download New Data Base into New System | Unit | $ - 0 | $ - 0 | ||
| Security Devices: Card Readers | EA | $ - 0 | $ - 0 | ||
| Altronix T1MK1F4D 8-Door Enclosure Kit | EA | $ - 0 | $ - 0 | ||
| Altronix T1MK1F4D 16-Door Enclosure Kit | EA | $ - 0 | $ - 0 | ||
| Syngergis Cloud Link | EA | $ - 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 & Covers | LF | $ - 0 | $ - 0 | ||
| HID Crescendo 144K Proximity Cards | 375 | EA | $ - 0 | $ - 0 | |
| Pre-testing: Wiring and device testing; Reports | EA | $ - 0 | $ - 0 | ||
| Relocate Sound Masking Control Panel and Power Supplies | Unit | $ - 0 | $ - 0 | ||
| Testing, Permit, Etc | LOT | $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | ||||
| QUEENSGATE FACILITY | |||||
| Access Control Head End | 1 | Unit | $ - 0 | $ - 0 | |
| Work Station | Unit | $ - 0 | $ - 0 | ||
| Badging System | Unit | $ - 0 | $ - 0 | ||
| Export Existing Data Base and Modify | Unit | $ - 0 | $ - 0 | ||
| Download New Data Base into New System | Unit | $ - 0 | $ - 0 | ||
| Security Devices: Card Readers | EA | $ - 0 | $ - 0 | ||
| Altronix T1MK1F4D 8-Door Enclosure Kit | EA | $ - 0 | $ - 0 | ||
| Altronix T1MK1F4D 16-Door Enclosure Kit | EA | $ - 0 | $ - 0 | ||
| Syngergis Cloud Link | EA | $ - 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 & Covers | LF | $ - 0 | $ - 0 | ||
| HID Crescendo 144K Proximity Cards | 375 | EA | $ - 0 | $ - 0 | |
| Pre-testing: Wiring and device testing; Reports | EA | $ - 0 | $ - 0 | ||
| Testing, Permit, Etc | LOT | $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | ||||
| Div. 28 Electronic Safety and Security | |||||
| Item Description | Quantity | Unit | Unit Cost | Total | Comments |
| Enter # | Enter $ | Auto Fills | |||
| BOND HILL FACILITY | |||||
| Access Control Head End | 1 | Unit | $ - 0 | $ - 0 | |
| Work Station | Unit | $ - 0 | $ - 0 | ||
| Badging System | Unit | $ - 0 | $ - 0 | ||
| Export Existing Data Base and Modify | Unit | $ - 0 | $ - 0 | ||
| Download New Data Base into New System | Unit | $ - 0 | $ - 0 | ||
| Security Devices: Card Readers | EA | $ - 0 | $ - 0 | ||
| 1F4D 8-Door Enclosure Kit | EA | $ - 0 | $ - 0 | ||
| Altronix T1MK1F4D 16-Door Enclosure Kit | EA | $ - 0 | $ - 0 | ||
| Syngergis Cloud Link | EA | $ - 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 & Covers | LF | $ - 0 | $ - 0 | ||
| HID Crescendo 144K Proximity Cards | 375 | EA | $ - 0 | $ - 0 | |
| Pre-testing: Wiring and device testing; Reports | EA | $ - 0 | $ - 0 | ||
| Testing, Permit, Etc | LOT | $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | ||||
| ACCESS FACILITY | |||||
| Access Control Head End | 1 | Unit | $ - 0 | $ - 0 | |
| Work Station | Unit | $ - 0 | $ - 0 | ||
| Badging System | Unit | $ - 0 | $ - 0 | ||
| Export Existing Data Base and Modify | Unit | $ - 0 | $ - 0 | ||
| Download New Data Base into New System | Unit | $ - 0 | $ - 0 | ||
| Security Devices: Card Readers | EA | $ - 0 | $ - 0 | ||
| Altronix T1MK1F4D 16-Door Enclosure Kit | EA | $ - 0 | $ - 0 | ||
| Syngergis Cloud Link | EA | $ - 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 & Covers | LF | $ - 0 | $ - 0 | ||
| HID Crescendo 144K Proximity Cards | 375 | EA | $ - 0 | $ - 0 | |
| Pre-testing: Wiring and device testing; Reports | EA | $ - 0 | $ - 0 | ||
| Testing, Permit, Etc | LOT | $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | ||||
| $ - 0 | $ - 0 | ||||
| Div. 28 Electronic Safety and Security | |||||
| Item Description | Quantity | Unit | Unit Cost | Total | Comments |
| Enter # | Enter $ | Auto Fills | |||
| RIVERFRONT TRANSIT FACILITY | |||||
| Access Control Head End | 1 | Unit | $ - 0 | $ - 0 | |
| Export Existing Data Base and Modify | Unit | $ - 0 | $ - 0 | ||
| Download New Data Base into New System | Unit | $ - 0 | $ - 0 | ||
| Security Devices: Card Readers | EA | $ - 0 | $ - 0 | ||
| Altronix T1MK1F4D 4-Door Enclosure Kit | EA | $ - 0 | $ - 0 | ||
| Syngergis Cloud Link | EA | $ - 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; Reports | EA | $ - 0 | $ - 0 | ||
| Testing, Permit, Etc | LOT | $ - 0 | $ - 0 | ||
| NORTHSIDE TRANSIT FACILITY | |||||
| Access Control Head End | 1 | Unit | $ - 0 | $ - 0 | |
| Export Existing Data Base and Modify | Unit | $ - 0 | $ - 0 | ||
| Download New Data Base into New System | Unit | $ - 0 | $ - 0 | ||
| Security Devices: Card Readers | EA | $ - 0 | $ - 0 | ||
| Altronix T1MK1F4D 4-Door Enclosure Kit | EA | $ - 0 | $ - 0 | ||
| Syngergis Cloud Link | EA | $ - 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; Reports | EA | $ - 0 | $ - 0 | ||
| Testing, Permit, Etc | LOT | $ - 0 | $ - 0 | ||
| GLENWAY CROSSING TRANSIT FACILITY | |||||
| Access Control Head End | 1 | Unit | $ - 0 | $ - 0 | |
| Export Existing Data Base and Modify | Unit | $ - 0 | $ - 0 | ||
| Download New Data Base into New System | Unit | $ - 0 | $ - 0 | ||
| Security Devices: Card Readers | EA | $ - 0 | $ - 0 | ||
| Altronix T1MK1F4D 4-Door Enclosure Kit | EA | $ - 0 | $ - 0 | ||
| Syngergis Cloud Link | EA | $ - 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; Reports | EA | $ - 0 | $ - 0 | ||
| Testing, Permit, Etc | LOT | $ - 0 | $ - 0 |
&P of &N
File details come from the government source that posted it. Updated .