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
| 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 |
||
| 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 |
|||
| 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 |
|||
| 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 |
|||
| Monthly-FY
| Actual
| 3.47%
| 3.52%
| 3.49%
| 3.62%
| 3.98%
| 4.06%
| |
|||
| 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 |
|||
| Monthly-FY
| Actual
| 1.27
| 1.27
| 1.30
| 1.84
| 2.01
| 3.04
| |
|||
| Monthly-FY
| Actual
| 0.30
| 0.44
| 0.30
| 0.22
| 0.22
| 0.06
| |
|||
| Annual-FY
| FT of pipe at stage 5
| | | | | | 17,921.00
| |
|||
| 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
| 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. |
||
| Quarterly-FY
| Actual
| | | $ 101.19
| | | $ 117.22
| |
|||
| Annual-FY
| Positions per 1,000 Population
| | | | | | 0.53
| |
|||
| Annual-FY
| Positions per 1,000 Population
| | | | | | 0.60
| |
|||
| Annual-FY
| % of CIP Appropriated
| | | | | | 99.41%
| |
|||
| Annual-FY
| Gallons per capita per day
| | | | | | | This KPI is reported Annually and it will be available in November 2021. |
|||
| Quarterly-FY
| Apparent Loss %
| | | | | | | KPI number will be available at end of FY21 |
|||
| Quarterly-FY
| Real loss
| | | | | | | KPI number will be available at end of FY21 |
|||
| Annual-FY
| Actual
| | | | | | | This KPI is reported Annually and it will be available in November 2021. |
|||
| 3. Innovation & Learning
| 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. |
||
| 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
|
|||||
| 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. |
|||
| 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. |
|||
| 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
|
|||||
| 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
| 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. |
||
| 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. |
|||
| 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. |
|||
| 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 |
|||
| 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 |
|||
| Quarterly-FY
| FYTD # of validated complaints
| | | 5.00
| | | 6.00
| |
|||
| Monthly-FY
| Actual
| 0.10
| 0.05
| 0.07
| 0.06
| 0.06
| 0.06
| |
|||
| Monthly-FY
| % of complaints resolved in 120 hours
| 100.00%
| 93.75%
| 100.00%
| 100.00%
| 100.00%
| 100.00%
| |
|||
| 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. |
|||
| 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
|
|||||
| 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. |
|||
| Monthly-FY
| % biosolids reused
| 100.00%
| 100.00%
| 100.00%
| 100.00%
| 100.00%
| 100.00%
| All biosolids hauled offsite were land applied. |
|||
| Monthly-FY
| Avg % dewatered biosolids leaving facility
| 20.17%
| 22.71%
| 22.53%
| 22.31%
| 21.78%
| 21.76%
| Centrifuges online. |
|||
| Monthly-FY
| Village Creek % Sustainability
| 46.06%
| 39.72%
| 40.88%
| 43.41%
| 43.40%
| 46.09%
| Steam blowers off whole month. |
|||
| Annual-CY
| Total Gallons Saved (Evaluated)
| | | | | | | Available at the end of the Calendar Year. |
|||