Cost_Breakdown_Summary.xlsx

The file is a detailed Cost Breakdown Summary for an Access Control Upgrade project by the Southwest Ohio Regional Transit Authority (SORTA), covering seven facilities: Huntington Center, Queensgate, Bond Hill, Access, Riverfront Transit, Northside Transit, and Glenway Crossing Transit Facilities. The project involves updating the existing electronic access control system and migrating it into SORTA's Genetec Security Center (version 5.12) unified electronic security management system. The cost breakdown includes comprehensive line items for access control head-end systems, work stations, badging systems, database modifications, security devices (such as card readers, door controllers, and enclosure kits), and proximity cards. Each facility has a detailed breakdown of equipment and installation components, with a total of 375 HID Crescendo 144K Proximity Cards specified across the facilities.

The cost breakdown spreadsheet is structured to allow bidders to input unit costs and quantities, with automatic calculation of total costs. While the current document shows zero-dollar placeholder values, it provides a comprehensive template for pricing out the access control upgrade project. The scope includes pre-testing of wiring and devices, report generation, and miscellaneous expenses such as permits. The project appears to involve significant technical infrastructure upgrades, focusing on modernizing access control systems across multiple SORTA facilities with standardized equipment from manufacturers like Mercury, Altronix, HID, and CTE Wiring Systems. The spreadsheet suggests a systematic approach to replacing and upgrading access control infrastructure, with consistent equipment specifications across different transit and administrative facilities.