Loading...
HomeMy WebLinkAboutCustomer Driven Service2011 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2010 2009 2009 2009 2009 2009 Jan Dec Nov Oct Sept Aug July June May Apr Mar Feb Jan Dec Nov Oct Sept Aug IX. Customer Driven Service Interaction/Workload and Timliness/Efficiency Data for Interactions Initiated by Residents/Citizens MIN Q2 MED Q3 MAX AVG 03/11 | 3QTR Feb 2011 Jan 2011 12/10 | 2QTR Nov 2010 Oct 2010 09/10 | 1QTR Aug 2010 July 2010 06/10 | 4QTR May 2010 Apr 2010 03/10 | 3QTR Feb 2010 Jan 2010 12/09 | 2QTR Nov 2009 Oct 2009 09/09 | 1QTR Aug 2009 NOTES: INQUIRIES City Clerk Records Requests Completed (right) 0 1.5 3 5 373 36.0666666666667 373 131 6 7 3 1 4 1 3 1 4 3 2 2 0 # completed on-time hidden for print, unhide required for some graphs Timeliness deadline = 48 hours unless otherwise noted. Online Pay data available starting in FEB How to we get more information on the timeliness and efficiency of our service activities? Utility data correlated, online payments should reduce city shutoffs, 3-mo pay pattern? Blank data likely submitted at next quarter No longer tracking this data. Internal customer service: in 3 days 0 1 3 5 373 35.8 373 131 6 6 3 1 4 1 3 1 4 2 1 1 0 Current data is enough to satisfy the TR/A3 task, but is very limited in scope. % On Time 0.5 0.892857142857143 1 1 1 0.894557823129252 1 1 1 0.857142857142857 1 1 1 1 1 1 1 0.666666666666667 0.5 0.5 N/A City Clerk Council Inquiries Qty 5 9.75 11.5 18 31 14.175 16 18 11 5 8 11 18 18 28 9 31 15 12 14.5 10 10 8 8 11 22 admins in 5 Days 3 6 8 10 25 9.86666666666667 8 7 8 3 5 8 5 6 25 6 24 15 8 11 9 On-time 0.277777777777778 0.55 0.666666666666667 0.766407119021135 1 0.655903344585213 0.5 0.388888888888889 0.727272727272727 0.6 0.625 0.727272727272727 0.277777777777778 0.333333333333333 0.892857142857143 0.666666666666667 0.774193548387097 1 0.666666666666667 0.758620689655172 0.9 INQ QTR 45 24 64 55 36.5 COMPLAINTS Reported Code Violations (City Hall) Reported 0 1.5 5 13.5 43 10.4545454545455 2 0 1 0 2 5 12 15 27 43 8 Graph removed until data can be verified On-time 0 0 0 0.5 2 0.5 0 0 0 2 On-time 0 0 0 0.5 1 0.333333333333333 0 0 1 Nuisance (PD) Reported 159 198.5 257 306 351 252.5 260 170 162 191 254 247 305 295 312 330 299 262 237 159 200 200 194 309 313 351 Unhide B, N-P columns for graph HUI QTR 592 692 912 891 596 703 Nuisance Data for Graph - HIDE FOR PRINT 2009 200 194 309 313 351 2010 191 254 247 305 295 312 330 299 262 237 159 200 2011 162 PERMITS & LICENSES Res. Build Completed 0 2 2.5 4.25 9 3.1 5 4 2 2 1 6 5 4 5 2 2 2 3 4 0 0 2 3 1 9 Special Event 0 1 2 2 2 1.4 1 2 0 1 2 2 2 2 0 2 Business License 7 10 11 16.25 20 12.8 16 15 8 7 18 11 11 11 7 10 17 17 17 10 20 10 16 13 11 11 Liquor License 0 1 2 3 4 1.95 3 1 0 1 0 3 0 4 1 2 3 3 1 2 1 4 2 4 0 4 UTILITY SERVICE New service Municipal Water Supply 209 233 262 288 383 264 264 211 301 254 285 258 295 291 383 295 275 214 217 209 262 247 219 258 278 Transfer 138 191 208 238 331 218.823529411765 238 174 208 186 306 212 331 208 184 196 191 138 229 196 191 254 278 User Shutoff 188 215 274 307.5 389 271.631578947368 207 188 389 327 285 293 322 253 367 308 207 215 215 196 274 307 262 287 259 City Shutoff 156 174.5 206 231 322 209.894736842105 207 156 322 215 217 238 266 206 272 234 167 178 171 174 228 170 175 199 193 Pays Process 15690 15535 12926 15627 15834 13162 16478 14393 12903 16390 14583 12974 15909 14866 13062 15748 13066 Online Pays PUBLIC SAFETY Fire Dispatched 46 47.5 51.5 58.5 74 55 74 46 49 47 54 60 EMS 617 641.5 669 686.75 712 665.333333333333 667 712 692 671 633 617 FD-Other 207 232.75 243.5 255 311 248.833333333333 311 249 231 207 238 257 PD Calls for Service 3433 3554.5 4123 4237 4574 3986.16666666667 4089 3433 3557 3547 3536 3831 4282 4222 4157 4574 4423 4183 11966 13668 14152 925 925 934 592 Implementation Plan (Green=Task On Time/Ahead - Yellow=Task Running Behind - Red=Task Late - X=Milestone Date) # 1 2 3 4 Leader GC-NB GC & DEPTS GC-NB GC-NB Tasks FEB - Follow-up with Insp/Planning to collect code data FEB - Identify 1st step to centralizing via staff discussion, determine workload overflow, determine additional steps as necessary MAR- Review metrics available with comparison data, select those applicable to City goals and tangible results. Implem. plan due APR. FEB - Soft launch online payments. MAR - promoted launch APR-JUN Review online/traditional payment data Milestone Dates Oct G G G G Nov G G G G Dec G Y G G Jan G Y G G Feb X X X Mar X X April X X May June July Aug Sept Tangible Result: Current Overall Rating of This Result: Measures (with desired trend and ultimate goal / benchmark) Measure Workload Indicators Timeliness Index Current State (should be Descriptive and\or A3Visual) for each measure Measure Workload Indicators Timeliness Index GOOD Records Requests Council Inquiries* Code Violations Reported Nuisances SF Residential Permits Records Requests Council Inquiries* Code Violations Reported Nuisances SF Residential Permits Records Requests Council Inquiries* Code Violations Reported Nuisances SF Residential Permits Records Requests Council Inquiries* Code Violations 3QTR 510 45 3 592 11 100% 51% 0% IX.Customer Driven Service Desired Trend DECREASE ▼ DECREASE ▼ DECREASE ▼ DECREASE ▼ INCREASE ▲ INCREASE TO FLAT INCREASE TO FLAT INCREASE TO FLAT INCREASE TO FLAT INCREASE TO FLAT Trend INCREASE ▲ DECREASE ▼ INCREASE ▲ FLAT DECREASE ▼ DECREASE ▼ Progress N Y Y Y N N Benchmark (3QTR 0910) n/a 37 30 596 10 1 0.7 N/A N/A N/A Rating/Comment Recently added PD and Court data - no comparisons available Higher than usual Council inquiries Data likely incomplete, working to improve reports INSIGNIFICANT CHANGE - Seasonal pattern INSIGNIFICANT CHANGE - Seasonal pattern INSIGNIFICANT CHANGE - Normal operation Higher than usual Council inquiries delayed responses Data likely incomplete, working to improve reports Goal 0 0 0 0 5 1 1 1 1 1 Red Yell Y Y Green G G G G G G Champion: Future State (If we do not change our strategy, what will the future result look like?) Implementation Plan (Green=Task On Time/Ahead - Yellow=Task Running Behind - Red=Task Late - X=Milestone Date) # 2 3 4 1 Recent Progress 1 City staff are managing the current workload well but there are ample opportunities to improve quality, cost and efficiency. We were laboring first to develop reporting procedures that will enable us to identify trends. The recent focus has been on the resident survey. PRIORITIES & Status 1. Improved evaluation/measurement of code/nuisance enforcement activity 2. Centralize records request activites 3. Plan to assess CS quality through survey component Leader GC & DEPTS GC-NB GC-NB GC-NB Modified Inspections/Planning division reporting procedures to include code enforcement workload and efficiency data CONRAD/BRENNAN Evaluate measurement methods Records requests are processed city-wide. Additional recordkeeping work will likely force City Clerk to delegate more tasks. Assess available metrics with comparison data, select those applicable to tangible results, review with management, plan to implement Tasks FEB - determine workload overflow, develop submission procedure, additional steps as necessary. DevelMAR - Begin collecting city-wide data. JUN - Determine next steps APR- Review metrics available with comparison data, select those applicable to City goals and tangible results. Write RFQ-MAY, post/select vendor JUNE, distribute survey by SEPT APR - Online Pay soft launch, MAY - Promote online payments, Review data for impact AUG JUN - Evaluate measurement methods, determine next steps (recent personnel changes in Inspections) Submitted: 4/19/2011 Milestone Dates Jan 4. Analyze utility data for online service impact ADMINISTRATIVE PRIORITIES Feb X Starting after online payment begins 1. Data focused heavily on workload. For more value from this exercise, we need more data related to the efficiency and quality of our customer service activities. 2. At the start, discussed smaller data items "rolling-up" into broader indeces. What is our plan for this? EX: Instead of reporting violations and nuisance, we report on complaints in general. Mar X April X X 3QTR - FY1011 May X X June X X X July Aug X Sept X Oct Nov Dec