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

This document is Exhibit 4 - Quantitative Assumptions for the City of Phoenix, detailing asset and operational metrics across multiple municipal departments including Public Works, Aviation, Street Transportation, and Water Services. The exhibit provides comprehensive data on facilities, properties, work orders, maintenance activities, and enterprise asset management (EAM) and facility service management (FSM) user groups across these departments. The document includes detailed breakdowns of physical assets such as buildings, land acreage, street miles, traffic signal components, treatment plants, and other infrastructure, along with work order counts, user statistics, and projected metrics for fiscal years 2020/21 through 2024/25.

The quantitative assumptions serve as a strategic resource for potential proposers to understand the current operational landscape and scale of municipal infrastructure management. Key highlights include the Public Works Department managing 863 buildings across 443 properties totaling 10,496,280 square feet, the Aviation Department overseeing three airports with significant building and landscape values, Street Transportation managing 4,850 street miles and nearly 100,000 streetlights, and Water Services maintaining an extensive network of wastewater and water distribution assets comprising over 2.1 million total assets. The document also provides insights into work order volumes, user group compositions, and system usage patterns, which can inform resource allocation, technology implementation, and maintenance strategy planning.

View the file

Other files for this state and local contract opportunity

Other files attached to Enterprise Asset Management - Software & Implementation, newest first.
File Type Posted
Enterprise_Asset_Management_-_Software_&_Implementation_(Addendum_#4_Revision).pdf PDF
RFP_26-0007_Exhibit_6_-_Sensitive_System_Information_Acknowledgement_Form.docx DOCX document
Attachment_1_-_Pricing_Proposal_rev._A4.xlsx XLSX spreadsheet
Exhibit_2-Integration_Inventory_rev._A4.xlsx XLSX spreadsheet
Enterprise_Asset_Management_-_Software_&_Implementation_(Addendum_#1_Revision).pdf PDF
RFP_26-0007_-_Evaluation_Criteria_Questionaire_Rev._A1.pdf PDF
RFP_26-0007_-_Evaluation_Criteria_Questionaire_Rev._A1.pdf PDF
Enterprise_Asset_Management_-_Software_&_Implementation.pdf PDF
Enterprise_Asset_Management_-_Software_&_Implementation.pdf PDF
Attachment_3_-_RFP_26-0007_-_Evaluation_Criteria_Questionnaire.pdf PDF
Attachment_2_-RFP_Data_Privacy_Questionnaire.xlsx XLSX spreadsheet
Attachment_2_-RFP_Data_Privacy_Questionnaire.xlsx XLSX spreadsheet
Attachment_2_-RFP_Data_Privacy_Questionnaire.xlsx XLSX spreadsheet
Attachment_3_-_RFP_26-0007_-_Evaluation_Criteria_Questionnaire.pdf PDF
Attachment_2_-RFP_Data_Privacy_Questionnaire.xlsx XLSX spreadsheet
Exhibit_5_-_Physical_Assets_and_Equipment_Inventory.xlsx XLSX spreadsheet
Exhibit_5_-_Physical_Assets_and_Equipment_Inventory.xlsx XLSX spreadsheet
Exhibit_5_-_Physical_Assets_and_Equipment_Inventory.xlsx XLSX spreadsheet
Exhibit_5_-_Physical_Assets_and_Equipment_Inventory.xlsx XLSX spreadsheet
Exhibit_1_-_Detailed_System_Application_Requirements.xlsm XLSM spreadsheet
Exhibit_1_-_Detailed_System_Application_Requirements.xlsm XLSM spreadsheet
Exhibit_1_-_Detailed_System_Application_Requirements.xlsm XLSM spreadsheet
Exhibit_1_-_Detailed_System_Application_Requirements.xlsm XLSM spreadsheet
Exhibit_1_-_Detailed_System_Application_Requirements.xlsm XLSM spreadsheet
RFP_26-0007_ATTACHMENT_4.docx DOCX document
RFP_26-0007_ATTACHMENT_4.docx DOCX document
RFP_26-0007_ATTACHMENT_4.docx DOCX document
Attachment_1_-_Pricing_Proposal.xlsx XLSX spreadsheet
Attachment_1_-_Pricing_Proposal.xlsx XLSX spreadsheet
Attachment_1_-_Pricing_Proposal.xlsx XLSX spreadsheet
Exhibit_3_-_Complexity_Guidelines.xlsx XLSX spreadsheet
Exhibit_3_-_Complexity_Guidelines.xlsx XLSX spreadsheet
Exhibit_4_-_Quantitative_Assumptions.pdf PDF
Exhibit_3_-_Complexity_Guidelines.xlsx XLSX spreadsheet
Exhibit_2_-_Integration_Inventory.xlsx XLSX spreadsheet
Exhibit_2_-_Integration_Inventory.xlsx XLSX spreadsheet
Exhibit_2_-_Integration_Inventory.xlsx XLSX spreadsheet
Supplemental_Terms_And_Conditions_To_All_Airport_Agreements_(Rev._5-22-24-Formatting_Rev._7-11-24).pdf PDF
Acceptance_of_Offer_Form_2025.pdf PDF
Acceptance_of_Offer_Form_2025.pdf PDF
Attachment_B_-_FTA_-_Federal_Certifications_(March_2025).pdf PDF
Acceptance_of_Offer_Form_2025.pdf PDF
Attachment_B_-_FTA_-_Federal_Certifications_(March_2025).pdf PDF
Acceptance_of_Offer_Form_2025.pdf PDF
Attachment_B_-_FTA_-_Federal_Certifications_(March_2025).pdf PDF
Attachment_B_-_FTA_-_Federal_Certifications_(March_2025).pdf PDF
Addendum_Form.docx DOCX document
Addendum_Form.docx DOCX document
Addendum_Form.docx DOCX document
Addendum_Form.docx DOCX document
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 .