Exhibit_4_-_Quantitative_Assumptions.pdf
PDF 275 KB Posted
- Attached to
- Enterprise Asset Management - Software & Implementation State and local contract opportunity
- Solicitation number
- RFP 26-0007
- Issued by
- Maricopa County, Phoenix City, Arizona
About this file
Exhibit 4 - Quantitative Assumptions Summary
Exhibit 4 is a quantitative assumptions document supporting the City of Phoenix's Enterprise Asset Management software and implementation solicitation across four municipal departments: Public Works, Aviation, Street Transportation, and Water Services. The document establishes baseline metrics for system sizing, licensing, and implementation planning. Public Works manages 443 properties encompassing 863 buildings and 10,496,280 square feet across 11 client departments, with an average of 21,836 annual work orders distributed among preventive maintenance, reactive maintenance, and project-based activities, supported by approximately 338 estimated system users including technicians, planners, supervisors, administrative staff, and contractors. Aviation manages three airports (Phoenix Sky Harbor, Deer Valley, and Goodyear) with combined assets including 221 buildings, 31.3 million square feet of building space valued at $19.12 billion, and airfield/ramp/roadway pavement totaling 9.6 million square yards, generating approximately 45,500 annual work orders with approximately 785 system users. Street Transportation oversees 4,850 street miles and manages 362,813 discrete assets including traffic signals, streetlights, curb ramps, and storm drain facilities, with 26,110 annual work orders supported by approximately 534 users. Water Services manages 2,128,271 total assets including wastewater and water treatment plants, lift stations, remote facilities, and linear distribution systems totaling 348,823 water main segments and 440,211 lateral taps, with potential future asset expansion to 340,000 additional assets, generating approximately 60,113 annual work orders across primary, secondary, and casual user categories.
The quantitative assumptions establish contractual benchmarks for vendor proposals regarding transaction volumes, user licensing requirements, data migration scope, and system configuration specifications. The metrics differentiate user types by functional role and system usage intensity, from full-time field technicians and planners requiring primary access to administrative and support staff requiring secondary or casual access. The document does not establish specific pricing terms, set-asides, or funding allocations but provides the foundation for vendors to develop accurate implementation timelines, training requirements, and total cost of ownership calculations based on documented asset quantities, work order volumes, and user populations across all four departments.
View the file
Other files for this state and local contract opportunity
Show all 50
Enterprise Asset Management - Software & Implementation has more files on GovTribe.
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
EXIHBIT 4 – QUANTITATIVE ASSUMPTIONS
Proposers should use the following quantities and counts for the calculation of licenses, maintenance, transaction volumes, sizing, training requirements, etc.:
The Public Works Department: The Public Works department includes the Facilities Management divisions. Public Works is responsible for the maintenance of Public Works properties and provides facilities maintenance services to other city departments. Service level agreements are in place for services to be rendered. The other city departments are referred to as “client departments” for this reason. Public Works provides facilities maintenance and asset renewal services (project management) to other City departments. The table below provides a current overview of client department facilities:
Client Department Properties Buildings Facility Square Footage
Land Acreage
Arts & Culture 11 36 599,215 99 City Clerk 1 3 51,935 5 Fire 64 93 894,682 199 Human Services 13 27 727,808 81 Information Technology
19 19 15,129 802
Library 17 17 507,390 411 Neighborhood Services
5 5 49,768 9
Parks & Recreation 260 478 1,799,339 9,122 Police 17 69 1,048,807 563 Public Works 31 109 4,720,482 3,411 Streets Transportation 5 7 81,725 7 Total 443 863 10,496,280 14,709
The Public Works Department Work Order Count and Type:
Work Order Type Fiscal Year 2020/21
Fiscal Year 2021/22
Fiscal Year 2022/23
Fiscal Year 2023/24
Fiscal Year 2024/25
Preventive Maintenance
11,173 11,694 11,489 11,830 11,472
Reactive Maintenance
7,876 10,310 8,872 9,732 10,679
Minor Maintenance Projects
251 302 262 276 246
Major Maintenance Projects
545 230 215 322 361
Total 19,845 22,536 20,838 22,160 22,758
The Public Works Department Estimated EAM and FSM Users:
EAM and FSM Users Group Function Performed Total (estimated) Technicians/Field Staff Maintenance, Contract Compliance 104 Planners/Energy Mgmt Project and Energy Management 14 Supervisors Work Assignment & Tracking 21 Administrative Staff Asset Management, Fiscal 25 Executive and Middle Mgmt Reporting and Dashboards 14 Contractors Contracted Maintenance, Repair, or
Replacement
Total 338
The Aviation Department provides the Phoenix Metropolitan area with a self-supporting system of airports that accommodate general and commercial aviation in a safe, effective, and convenient manner.
The Aviation Department includes a Facilities section and manages the three airports.
Aviation Properties:
Aviation Asset Statistics Category Statistic
Phoenix Sky Harbor Airport (PHX) Buildings 95
Building SQ FT (Total) 21.6M Building Value $17.3B
Airfield/Ramp/Roadways (Pavement SQ YD) 8.7M Airfield Value $3.2B
Landscape (Acres) 287 Landscape Value $287M
Deer Valley Airport (DVT) Buildings 88
Building SQ FT (Total) 1.45M Building Value $1.12B
Airfield/Ramp/Roadways (Pavement SQ YD) 582K Airfield Value $218M
Landscape (Acres) 2 Landscape Value $2M
Goodyear Airport (GYR) Buildings 38
Aviation Asset Statistics Category Statistic
Building SQ FT (Total) 865K Building Value $700M
Airfield/Ramp/Roadways (Pavement SQ YD) 329K Airfield Value $122M
Landscape (Acres) 2 Landscape Value $2M
Aviation 2024 Work Metrics Work Type W/O Count
Work Orders:
Regular/Service Work 23,500 Preventive Maintenance 22,000
Aviation EAM and FSM Users
Group Functions Performed Number
Maintenance Field Technicians 375 Management Foreman/Administrative 55 WO Center/Dispatchers WO Creation, Crew Notification/Dispatching 40 Finance Accounts Receivable/Payable, SAP, KPI’s 25 Leadership Reporting and Executive Dashboards 20 Support Roles Warehouse Staff, IT, GIS, etc. 120 Contractors Contracted Maintenance 150 Customers Internal Stakeholders, Airlines, Tenants - Service Requests Unlimited
Aviation Warehouse Statistics Category Statistic
Work Order Parts Issued (Transactions) 6283 Work Order Parts Returns (Transactions) 331 Total Storeroom Items 3714 Total Supply Warehouses 3 Total Cost Centers (Citywide) 476 Cost Centers Aviation Issued Against 78 Total Purchase Requisitions 7159 Non-inventory Purchase Requisitions 4962 Stores Inventory Purchase Requisitions 2197
STREET TRANSPORTATION
The Street Transportation (Streets) is responsible for the city’s street network consisting of over 4,800 street miles. Streets is responsible for maintenance of infrastructure in the public right-of-way including pavement, traffic signals, landscaping, and storm drain facilities.
Asset Metrics Facilities Approximate Number of Assets
Street Miles 4,850 Traffic Signal Components 70,923 Curb Ramps 75,626 Streetlights 99,598 Speed humps 3,314 Parking Meters 2,320 Dams 8 Guardrail (lineal feet) Unknown Storm Drain Facility Components 101,954
FY2025 Work Metrics
Work Orders:
Street Maintenance 19,910 Traffic Services 6,200
Street Transportation EAM and FSM Users
Group Functions Performed Number
Field Technicians Construction and Maintenance 368 Foreman Foreman/Administrative 67 Administrative Management, Administrative, Engineering 84 Asset Managers GIS Staff and Specialized Administrative 15
WATER SERVICES
The following table represents the assets currently managed and maintained by the Water Service in WAM 1.9X and an estimation of future assets to be added:
Facilities Approximate Number of Assets 2 Wastewater Treatment Plants / 1 Reclamation Plant
29,620
29 Wastewater Lift Stations 3,544 5 Water Treatment Plants 25,682 350 Water Remote Facilities 20,851
Linear Assets for Wastewater Collection System 114,602 asset segments (5,064 miles of gravity sewers) 223 asset segments (82 miles of force mains) 440,211 lateral taps 101,834 manholes
Linear Assets for Water Distribution System 348,823 asset segments (7,226 miles of water mains) 57,106 fire hydrants 170,598 system valves 475,177 service connections
Sub-Total 1,788,271 Potential Future Asset Expansion 340,000 Total Assets 2,128,271
Work Metrics
Work Orders (Yearly):
Regular Work 19,795 Preventive Maintenance 32,372 Service Request 7,946
Primary Users – Use the system 4 to 8 hours per day.
Secondary Users – Use the system 2 to 4 hours per day.
Casual Users – Use the system less than 2 hours per day.
WAM Users
Group Functions Performed Numbe r
EAM FSM
EAM Users Back office functions 12 Primary Secondary (at least few may need access for testing and troubleshooting purposes)
Management Managers: reporting and executive dashboards 110 Secondary Work Planners Scheduling and dispatching 75 Primary Primary
Field Techs Field Technicians 600 Primary
Contractors Contracted field work crews TBD Primary
Warehouse Warehouse Staff 30 Primary Secondary Technical Support IT and other support functions – GIS, etc. 8 Secondary Secondary
Casual Users Admin support and other users’ access EAM for research 80 Secondary
EXIHBIT C – QUANTITATIVE ASSUMPTIONS
File details come from the government source that posted it. Updated .