• SCORECARD: Department Overview
  • SCORECARD: Red Status Details
  • SCORECARD: 12-month Rolling Status
  • SCORECARD: 6-month Rolling Status (ACM Report)
  • DASHBOARD: All Charts
  • REFERENCE: Measure Info
  • Fort Worth Department Performance Scorecards (Current)
  • AV-Aviation
  • CAO-City Attorney's Office
  • CSO-City Secretary's Office
  • FD-Fire Department
  • CC-Code Compliance
  • CMO-City Manager's Office
  • PARD-Parks & Recreation
  • CPE-Communications
  • ED-Economic Development
  • FMS-Financial Mgmt Services
  • HR-Human Resources
  • IA-Internal Audit
  • ITS-Information Technology
  • LIB-Library
  • MC-Municipal Court
  • NS-Neighborhood Services
  • P&D-Planning & Development
  • P&DA-Planning & Data Analytics
  • PD-Police Department
  • PE-Public Events
  • PM-Property Management
  • TPW - Transportation / Public Works
  • WTR-Water
  • D&I - Diversity and Inclusion
  • DS- Development Services
  • WTR.1.1 Financial Viability
  • WTR.1.2 Infrastructure Strategy & Performance
  • WTR.2.1 Operational Optimization
  • WTR.2.2 Water Resource Sustainability
  • WTR.3.1 Employee & Leadership Development
  • WTR.3.2 Enterprise Resiliency
  • WTR.4.1 Customer Satisfaction
  • WTR.4.2 Product Quality
  • WTR.4.3 Stakeholder Understanding & Support
  • WTR.4.4 Community Sustainability
  • Days funded operating ratio
  • Debt service cover ratio
  • Level of Working Capital Actual as a % of Goal
  • Ratio of Outstanding Debt to Total Assets
  • % of accounts that are delinquent
  • Infrastructure Leakage Index
  • Main Breaks & Leaks per 100 Miles of Main
  • Sewer Overflows per 100 Miles of Main
  • Linear Feet of Large Diameter sa(>=24") Sewer Pipe at Stage 5 Critical Failure (ICAP)
  • Percent of Permanent Replacement of Pavement After Utility Work Within 10 Days
  • Direct energy cost per million gallons treated - Water
  • Direct energy cost per million gallons treated - Wastewater
  • Authorized Sewer Positions per 1,000 Population Total
  • Authorized Water Positions per 1,000 Population Total
  • % of CIP Appropriated vs. Plan
  • Gallons per Capita per Day (GPCD) 5 year rolling average
  • Apparent Loss Percentage
  • Real Loss Percentage
  • Water billed as a % of raw water purchased
  • Reduce Number of Preventable Injuries by 5% Annually
  • Professional and License Training Hours per Employee (FY)
  • OSHA Recordable Incident Rate
  • Completion of 85% Required Safety Training
  • Employee turnover rate
  • AWWA Employee Health and Safety Severity Rate
  • Call abandonment rate of less than 6%
  • % of calls answered within 60 seconds
  • JD Power Score
  • Percent of Field Operations' Water Taps Installed within 14 Calendar Days after allowing 72 hours for locates
  • Percent of Field Operations' Sewer Taps Installed within 14 Calendar Days after allowing 72 hours for locates
  • No. of Validated Biosolids Nuisance Odor Complaints (land application sites)
  • # of Water Quality Complaints received per 1000 customers
  • % of Water Quality Complaints received by the Central Lab and Investigated Within 120 Hours
  • Number of people reached through presentations, public events and plant tours
  • Increase number of followers by 40% per year on each social media platform
  • Increase the number of total engagements across Facebook, Twitter and Instagram
  • Biosolids Beneficial Use
  • Biosolids Dewaterability
  • Village Creek WRF Energy Sustainability
  • Water Savings from Water Efficiency Incentive Program
  • (ARCHIVED) Gallons per capita per day (GPCD).
  • (ARCHIVE) Average hours of professional and license training per employee.
  • (ARCHIVED) Ensure a minimum of 75% total water storage capacity available at all times
  • (ARCHIVED) Water delivery reliability at 99.99%.
  • (ARCHIVED) 100% Drinking water treatment compliance.
  • (ARCHIVED) 100% Wastewater treatment compliance.
  • (ARCHIVED) Number of Internships Resulting in Permanent Employment
  • (ARCHIVED) Number of Twitter Impressions for @FWWater and @FWAgua
  • (ARCHIVED) Number of Total Page "Likes" for Ft Worth Water (and Ft Worth Aqua) Facebook Page
  • (ARCHIVED) % of Water Quality Complaints Resolved Within 48 Hours
  • (ARCHIVED) Number of online surveys per year
  • (ARCHIVE) Percentage of Water System with a Risk-based Rating (WECAP)
  • (ARCHIVE) TBD - Plant infrastructure & asset management (Future KPI)
  • (ARCHIVE) Village Creek Key Process Equipment Availability
  • (ARCHIVED) Total population served per FTE - Water
  • (ARCHIVED) Total population served per FTE - Wastewater
  • (ARCHIVED) Increase the % of employees receiving safety bonus by 5% points annually.
  • (ARCHIVED) Water billing accuracy rate.
  • test kpi
  • Safety Training Hours per Employee ARCHIVE
  • Completion of 85% Required Safety Training
  • FO. Develop and implement a Cathodic protection testing, maintenance and record keeping plan.
  • FO. Implement I/I (Inflow/Infiltration) Reduction Plan
  • PO. Implement a Risk Assessment Framework.
  • SO. Finalize the Water Department Strategic Asset Management plan.
  • EX. Identify and implement a new operating system for XYZ.
  • CC. Convert pre-treatment data management system (PDMS) to SQL database.
  • CC. Revise the cross connection (backflow) ordinance.
  • MS. Implement and evaluate the process management plan for Blueworks process documentation.
  • SO. Replace and upgrade SCADA system with TWDB low interest loan.
  • SO. Plan the District Meter Areas (DMA) with collaboration of the MyH2O’s multi-year meter install program.
  • MS. Continue to develop and implement a training program for professional, technical development and licensing requirements.
  • MS. Expand the FWISD PTECH internship multi-phase program with curriculum additions and expansion of the work-based learning opportunities.
  • MS. Implement high priority recommendations from the new department-wide document management plan and provide training to assigned personnel.
  • MS. Complete a risk assessment for technology resilience and business continuity. Develop strategy for mitigating potential exposures.
  • MS. Create and implement a integrated safety and health management system for the entire utility.
  • MS. Develop and implement a department wide Contract Administration Program that includes a Procurement Services Hub.
  • CC. Develop plan to increase operational knowledge and improved performance on JD Powers and Customer Surveys.
  • CC. Develop tracking process to assess conformance to MOU between Development Services and the Water Utility.
  • SO. Prepare for the finalization of lead and cooper rule requirements.
  • CC. Develop, design, and implement a teacher’s online resource page.
  • CC. Implement Communications Plan for the MyH2O Portal.
  • SO. Asset Management Program Communication Plan.
  • FO. Implement recommendations of Real Water Loss Plan.

SCORECARD: 6-month Rolling Status (ACM Report)

WTR-Water
Perspectiv Attributes Measures Reporting Frequency Series Name Series Status Analysis
Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21
1. Financial
On Target
WTR.1.1 Financial Viability
Monitoring/No Info
Days funded operating ratio
Annual-FY
Days Funded
 
 
 
 
 

This data comes from the CAFR and will be available in March 2022. Email to FIN_FINANCIAL_REPORTING to request Reserve Requirement Supplement

Monitoring/No Info
Debt service cover ratio
Annual-FY
Debt service cover ratio
 
 
 
 
 

This data comes from the CAFR and will be available in March 2022. Email to FIN_FINANCIAL_REPORTING to request Reserve Requirement Supplement

Monitoring/No Info
Level of Working Capital Actual as a % of Goal
Annual-FY
Actual
 
 
 
 
 

This data comes from the CAFR and will be available in March 2022. Email to FIN_FINANCIAL_REPORTING to request Reserve Requirement Supplement

Monitoring/No Info
Ratio of Outstanding Debt to Total Assets
Annual-FY
Debt Ratio
 
 
 
 
 

This data comes from the CAFR and will be available in March 2022. Email to FIN_FINANCIAL_REPORTING to request Reserve Requirement Supplement

On Target
% of accounts that are delinquent
Monthly-FY
Actual
3.47%
3.52%
3.49%
3.62%
3.98%
4.06%
On Target
WTR.1.2 Infrastructure Strategy & Performance
Lagging
Infrastructure Leakage Index
Annual-CY
Infrastructure Leakage Index
 
 
 
 
 
 

This KPI is reported Annually and it will be available in March 2022. 

Jan - March 2021 ILI = 6.80  based on the data provided by various section within the Water Department
Notes:  Based on the discussion with Water IT Manager (Rick). I am planning to have an education session with Billing/Water IT to give them an overview about water loss, Why it is important and data that I need from Datalake/datawarehouse  to make sure we are all on the same page.

Lagging
Main Breaks & Leaks per 100 Miles of Main
Monthly-FY
Actual
1.27
1.27
1.30
1.84
2.01
3.04
On Target
Sewer Overflows per 100 Miles of Main
Monthly-FY
Actual
0.30
0.44
0.30
0.22
0.22
0.06
On Target
Linear Feet of Large Diameter sa(>=24") Sewer Pipe at Stage 5 Critical Failure (ICAP)
Annual-FY
FT of pipe at stage 5
 
 
 
 
 
17,921.00
Insufficient Progress
Percent of Permanent Replacement of Pavement After Utility Work Within 10 Days
Monthly-FY
% of pavement replaced within 10 days
69.00%
68.00%
52.00%
57.00%
67.00%
60.00%

Staffing issues continue to be an issue.  The overall annual percentage is 69% and includes the winter weather event.

2. Internal Business
On Target
WTR.2.1 Operational Optimization
Monitoring/No Info
Direct energy cost per million gallons treated - Water
Annual-FY
Actual
 
 
 
 
 

Don’t have Sept 2021 Electricity Bill to complete this KPI. Juanita stated it will be available first week of Nov 2021.

On Target
Direct energy cost per million gallons treated - Wastewater
Quarterly-FY
Actual
 
 
$ 101.19
 
 
$ 117.22
On Target
Authorized Sewer Positions per 1,000 Population Total
Annual-FY
Positions per 1,000 Population
 
 
 
 
 
0.53
On Target
Authorized Water Positions per 1,000 Population Total
Annual-FY
Positions per 1,000 Population
 
 
 
 
 
0.60
On Target
% of CIP Appropriated vs. Plan
Annual-FY
% of CIP Appropriated
 
 
 
 
 
99.41%
On Target
WTR.2.2 Water Resource Sustainability
Monitoring/No Info
Gallons per Capita per Day (GPCD) 5 year rolling average
Annual-FY
Gallons per capita per day
 
 
 
 
 

This KPI is reported Annually and it will be available in November 2021.

Monitoring/No Info
Apparent Loss Percentage
Quarterly-FY
Apparent Loss %
 
 
 
 

KPI number will be available at end of FY21

Monitoring/No Info
Real Loss Percentage
Quarterly-FY
Real loss
 
 
 
 

KPI number will be available at end of FY21

Monitoring/No Info
Water billed as a % of raw water purchased
Annual-FY
Actual
 
 
 
 
 

This KPI is reported Annually and it will be available in November 2021.

3. Innovation & Learning
Lagging
WTR.3.1 Employee & Leadership Development
Monitoring/No Info
Reduce Number of Preventable Injuries by 5% Annually
Annual-FY
Percent Change (YOY FYTD)
 
 
 
 
 

Risk management changed the information that is being reported out during the last quarter so it is taking some time to decipher the information.

On Target
Professional and License Training Hours per Employee (FY)
Monthly-FY
Avg Training Hours per Employee - All Divisions
0.39
0.65
0.57
0.94
0.96
0.90

FY21 Summary - Department training hours per employee is 8.07; lower than goal of 10. Although a lack of training due to the COVID-19 pandemic is a factor in not reaching the goal, it remains important for all Divisions to ensure completed training is documented to improve reporting toward this KPI

AVG Training HRS Per Employee - All Divs (FYTD)
4.05
4.70
5.28
6.21
7.17
8.07
Not Defined
OSHA Recordable Incident Rate
Annual-FY
Incident Rate
 
 
 
 
 

Risk management changed the information that is being reported out during the last quarter so it is taking some time to decipher the information.

Insufficient Progress
Completion of 85% Required Safety Training
Quarterly-FY
85% Required Safety Training CMPLT-All Divisions
 
 
31.00%
 
 
60.00%

While there was an increase in participation across the Utility, there is still 59% of employees who are missing 1 or more required trainings.

Not Defined
WTR.3.2 Enterprise Resiliency
Insufficient Progress
Employee turnover rate
Annual-FY
Turnover Rate
 
 
 
 
 
21.72%

This year the utility experienced a sharp rise in turnover. This can be attributed to numerous factors. First, almost 1/3 of the utility is eligible to retire and the utility is starting to see more and more employees opt to retire. Secondly, the impacts of the pandemic are starting to become evident. More and more employees are looking for remote work or positions that are more flexible when it comes to work-life balance. Lastly, the workforce is changing on a national level.  It is becoming increasingly harder to attract qualified candidates. Which has resulted in the private sector offering higher salaries and more benefits. This has greatly impacted our ability to retain employees as the utility cannot compete with the salaries offered in the private sector.  

# Employees Termed (DL)
 
 
 
 
 
217.00
# Authorized Positions (DL)
 
 
 
 
 
999.00
Not Defined
AWWA Employee Health and Safety Severity Rate
Annual-FY
 
 
 
 
 
 
 

Risk management changed the information that is being reported out during the last quarter so it is taking some time to decipher the information.

4. Customer
On Target
WTR.4.1 Customer Satisfaction
On Target
Call abandonment rate of less than 6%
Monthly-FY
Actual
7.67%
3.94%
5.62%
13.35%
14.72%
6.15%

FY21 Summary: COVID impacts, high call volume, increased average handle time, high absenteeism and staffing shortages all contributed to the high abandon rate for FY21.

Insufficient Progress
% of calls answered within 60 seconds
Monthly-FY
% answered within 60 seconds
67.80%
78.00%
67.80%
58.20%
40.80%
76.10%

Monthly Analysis: While the service level was still under the goal, great improvement was made in the monthly performance.  

FY21 Summary: COVID impacts, high call volume, increased average handle time, high absenteeism and staffing shortages all contributed to the low service level for FY21.

On Target
JD Power Score
Annual-FY
JD Power Score
 
 
 
 
 
735.00

The JD Power score for FY21 was 735 as compared to a national average of 747.  The annual score increased year over year from FY20 (722) to FY21 (735).  An initiative has been included in the FY20 & FY21 Business Plan to create a cross functional team both to analyze the data and develop initiatives to focus/improve on 2 of the areas that need improvement.  In addition, it is expected that the new Customer Portal (which has been delayed) will improve scores in multiple areas of the survey over time.

On Target
Percent of Field Operations' Water Taps Installed within 14 Calendar Days after allowing 72 hours for locates
Monthly-FY
% of water taps installed within 10 days
19.00%
92.00%
100.00%
100.00%
100.00%
100.00%

27 of 27 completed and 2 pending but not staked

On Target
Percent of Field Operations' Sewer Taps Installed within 14 Calendar Days after allowing 72 hours for locates
Monthly-FY
% of sewer taps installed within 10 days
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%

20 taps installed within the required timeline

On Target
WTR.4.2 Product Quality
On Target
No. of Validated Biosolids Nuisance Odor Complaints (land application sites)
Quarterly-FY
FYTD # of validated complaints
 
 
5.00
 
 
6.00
On Target
# of Water Quality Complaints received per 1000 customers
Monthly-FY
Actual
0.10
0.05
0.07
0.06
0.06
0.06
On Target
% of Water Quality Complaints received by the Central Lab and Investigated Within 120 Hours
Monthly-FY
% of complaints resolved in 120 hours
100.00%
93.75%
100.00%
100.00%
100.00%
100.00%
Monitoring/No Info
WTR.4.3 Stakeholder Understanding & Support
Insufficient Progress
Number of people reached through presentations, public events and plant tours
Monthly-FY
Total # educated (FYTD)
2,426.00
3,315.00
3,683.00
5,173.00
9,858.00
10,033.00

Due to the public health contingency all outreach activities have gone virtual and others have completely stopped, which is reflective of our engagement numbers.

On Target
Increase number of followers by 40% per year on each social media platform
Annual-FY
% Change, all subscribers for all accounts (YOY)
 
 
 
 
 
119.98%
Total subscribers, all accounts
 
 
 
 
 
24,745.00
Facebook (Total)
 
 
 
 
 
18,937.00
Twitter (Total)
 
 
 
 
 
4,417.00
On Target
Increase the number of total engagements across Facebook, Twitter and Instagram
Annual-FY
Yearly Total
 
 
 
 
 
10,700,000.00

These engagements are likes, comments, shares, retweets, downloads, and impressions (views) of posts from our social media accounts (Twitter English & Spanish, Facebook English & Spanish, Instagram, YouTube, Podcast) plus impressions (views) of GIFs we created and uploaded to our Giphy account.

Lagging
WTR.4.4 Community Sustainability
On Target
Biosolids Beneficial Use
Monthly-FY
% biosolids reused
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%

All biosolids hauled offsite were land applied.

On Target
Biosolids Dewaterability
Monthly-FY
Avg % dewatered biosolids leaving facility
20.17%
22.71%
22.53%
22.31%
21.78%
21.76%

Centrifuges online.

Insufficient Progress
Village Creek WRF Energy Sustainability
Monthly-FY
Village Creek % Sustainability
46.06%
39.72%
40.88%
43.41%
43.40%
46.09%

Steam blowers off whole month.

Insufficient Progress
Water Savings from Water Efficiency Incentive Program
Annual-CY
Total Gallons Saved (Evaluated)
 
 
 
 
 
 

Available at the end of the Calendar Year.