Loading...
HomeMy WebLinkAboutA8_NCS000249 Performance Measure Tracking in DataHubStormwater citizens in public involvement Public Works Owner Laura Smith (Public Works) Methodology Total attendees/participants from sign -in sheets from stream cleanups, reports from storm drain ID, adopt a stream participant database, public participation/comment meetings (watershed plans, retrofit projects, etc.) Target Stormwater citizens in public involvement 1,500.00 1,000.00 500.00 0.00 F< Ik Q Total/YTD - Target Estimate M a r-22 Measure Data Period Status Jul-16 Not Defined Aug-16 Not Defined Sep-16 Not Defined Oct-16 Not Defined Nov-16 Not Defined Dec-16 Not Defined Jan-17 Not Defined Feb-17 Not Defined Mar-17 Not Defined City of Durham, INC Mar-22 Report Analysis Action/Improvement Plan Stormwater citizens in public involvement (Monthly) 600.00 400.00 200.00 0.00 . 1 __1 1 __.I o o o ° ° ^ ^ ° �^ ^ ^ eC" e'Q Monthly Actual Monthly Actual Total/YTD 0.00 0.00 0.00 0.00 0.00 0.00 590.00 590.00 0.00 590.00 0.00 590.00 20.00 610.00 22.00 632.00 245.00 877.00 Created in Data Hub Target Estimate 850.00 850.00 850.00 850.00 850.00 850.00 850.00 850.00 850.00 Generated 04/27/2022 9:19:40 am, Page 1 Period Status Monthly Actual Total/YTD Apr-17 Not Defined 75.00 952.00 May-17 Not Defined 21.00 973.00 Jun-17 Not Defined 76.00 1,049.00 Jul-17 Not Defined 50.00 50.00 Aug-17 Not Defined 0.00 50.00 Sep-17 Not Defined 60.00 110.00 Oct-17 Not Defined 500.00 610.00 Nov-17 Not Defined 38.00 648.00 Dec-17 Not Defined 0.00 648.00 Jan-18 Not Defined 20.00 668.00 Feb-18 Not Defined 70.00 738.00 Mar-18 Not Defined 475.00 1,213.00 Apr-18 Not Defined 85.00 1,298.00 May-18 Not Defined 14.00 1,312.00 Jun-18 Not Defined 16.00 1,328.00 Jul-18 Not Defined 15.00 15.00 Aug-18 Not Defined 0.00 15.00 Sep-18 Not Defined 0.00 15.00 Oct-18 Not Defined 539.00 554.00 Nov-18 Not Defined 0.00 554.00 Dec-18 Not Defined 0.00 554.00 Jan-19 Not Defined 25.00 579.00 Feb-19 Not Defined 25.00 604.00 Mar-19 Not Defined 626.00 1,230.00 Apr-19 Not Defined 0.00 1,230.00 May-19 Not Defined 0.00 1,230.00 Jun-19 Not Defined 0.00 1,230.00 Jul-19 Not Defined 25.00 25.00 Aug-19 Not Defined 0.00 25.00 Sep-19 Not Defined 4.00 29.00 Oct-19 Not Defined 659.00 688.00 Nov-19 Not Defined 0.00 688.00 Dec-19 Not Defined 0.00 688.00 Jan-20 Not Defined 20.00 708.00 Feb-20 Not Defined 80.00 788.00 Mar-20 Not Defined 15.00 803.00 Apr-20 Not Defined 20.00 823.00 May-20 Not Defined 0.00 823.00 Jun-20 Not Defined 0.00 823.00 Jul-20 Not Defined 0.00 0.00 Aug-20 Not Defined 0.00 0.00 Sep-20 Not Defined 0.00 0.00 Oct-20 Not Defined 50.00 50.00 Nov-20 Not Defined 3.00 53.00 Dec-20 Not Defined 0.00 53.00 Jan-21 Not Defined 15.00 68.00 Feb-21 Not Defined 15.00 83.00 Mar-21 Not Defined 264.00 347.00 Apr-21 Not Defined 0.00 347.00 May-21 Not Defined 0.00 347.00 Jun-21 Not Defined 0.00 347.00 Target Estimate 850.00 850.00 850.00 850.00 850.00 850.00 850.00 850.00 850.00 850.00 850.00 850.00 850.00 850.00 850.00 850.00 :Y11z11a11zf City of Durham, INC Mar-22 Report Created in Data Hub Generated 04/27/2022 9:19:40 am, Page 2 Period — Status Monthly Actual Total/YTD Jul-21 — Not Defined 0.00 0.00 Aug-21 — Not Defined 0.00 0.00 Sep-21 — Not Defined 0.00 0.00 Oct-21 — Not Defined 118.00 118.00 Nov-21 — Not Defined 0.00 118.00 Dec-21 — Not Defined 18.00 136.00 Jan-22 — Not Defined 18.00 154.00 Feb-22 — Not Defined 26.00 180.00 Mar-22 — Not Defined 462.00 642.00 Apr-22 — Not Defined 642.00 May-22 — Not Defined 642.00 Jun-22 — Not Defined 642.00 FY 23 Target — Not Defined Target Estimate 500.00 City of Durham, NC Mar-22 Report Created in DataHub Generated 04/27/2022 9:19:40 am, Page 3 Stormwater public presentations Public Works Owner Laura Smith (Public Works) Methodology Counts at each event are tracked in contemporaneous calendar; event data is entered monthly into Public Education database to support regulatory reporting. Target Stormwater public presentations 100.00 50.00 0.00 ti Q Total/YTD - Target Estimate Measure Data Period Status Jul-16 Not Defined Aug-16 Not Defined Sep-16 Not Defined Oct-16 Not Defined Nov-16 Not Defined Dec-16 Not Defined Jan-17 Not Defined Feb-17 Not Defined Mar-17 Not Defined Apr-17 Not Defined City of Durham, INC Apr-22 Report Analysis Action/Improvement Plan Stormwater public presentations (Monthly) 20.00 15.00 10.00 5.00 0.00 No Monthly Actual Total/YTD 7.00 7.00 7.00 14.00 5.00 19.00 12.00 31.00 3.00 34.00 4.00 38.00 1.00 39.00 2.00 41.00 20.00 61.00 8.00 69.00 Created in Data Hub N ^ N ^ N ^ ti ti Monthly Actual Target Estimate 82.00 82.00 82.00 82.00 82.00 82.00 82.00 82.00 82.00 82.00 Generated 05/04/2022 9:04:35 am, Page 1 Period Status Monthly Actual Total/YTD May-17 Not Defined 10.00 79.00 Jun-17 Not Defined 3.00 82.00 Jul-17 Not Defined 5.00 5.00 Aug-17 Not Defined 5.00 10.00 Sep-17 Not Defined 6.00 16.00 Oct-17 Not Defined 13.00 29.00 Nov-17 Not Defined 8.00 37.00 Dec-17 Not Defined 3.00 40.00 Jan-18 Not Defined 5.00 45.00 Feb-18 Not Defined 6.00 51.00 Mar-18 Not Defined 8.00 59.00 Apr-18 Not Defined 6.00 65.00 May-18 Not Defined 21.00 86.00 Jun-18 Not Defined 7.00 93.00 Jul-18 Not Defined 4.00 4.00 Aug-18 Not Defined 3.00 7.00 Sep-18 Not Defined 3.00 10.00 Oct-18 Not Defined 11.00 21.00 Nov-18 Not Defined 2.00 23.00 Dec-18 Not Defined 4.00 27.00 Jan-19 Not Defined 10.00 37.00 Feb-19 Not Defined 2.00 39.00 Mar-19 Not Defined 16.00 55.00 Apr-19 Not Defined 10.00 65.00 May-19 Not Defined 8.00 73.00 Jun-19 Not Defined 7.00 80.00 Jul-19 Not Defined 6.00 6.00 Aug-19 Not Defined 6.00 12.00 Sep-19 Not Defined 7.00 19.00 Oct-19 Not Defined 16.00 35.00 Nov-19 Not Defined 5.00 40.00 Dec-19 Not Defined 3.00 43.00 Jan-20 Not Defined 3.00 46.00 Feb-20 Not Defined 2.00 48.00 Mar-20 Not Defined 1.00 49.00 Apr-20 Not Defined 0.00 49.00 May-20 Not Defined 0.00 49.00 Jun-20 Not Defined 1.00 50.00 Jul-20 Not Defined 1.00 1.00 Aug-20 Not Defined 2.00 3.00 Sep-20 Not Defined 1.00 4.00 Oct-20 Not Defined 4.00 8.00 Nov-20 Not Defined 3.00 11.00 Dec-20 Not Defined 1.00 12.00 Jan-21 Not Defined 2.00 14.00 Feb-21 Not Defined 2.00 16.00 Mar-21 Not Defined 11.00 27.00 Apr-21 Not Defined 4.00 31.00 May-21 Not Defined 2.00 33.00 Jun-21 Not Defined 3.00 36.00 Jul-21 Not Defined 2.00 2.00 Target Estimate 82.00 82.00 82.00 82.00 82.00 82.00 82.00 82.00 82.00 82.00 82.00 82.00 82.00 82.00 82.00 50.00 50.00 49.00 49.00 49.00 50.00 City of Durham, INC Apr-22 Report Created in Data Hub Generated 05/04/2022 9:04:35 am, Page 2 Period — Status Monthly Actual Total/YTD Aug-21 — Not Defined 2.00 4.00 Sep-21 — Not Defined 1.00 5.00 Oct-21 — Not Defined 6.00 11.00 Nov-21 — Not Defined 6.00 17.00 Dec-21 — Not Defined 1.00 18.00 Jan-22 — Not Defined 2.00 20.00 Feb-22 — Not Defined 1.00 21.00 Mar-22 — Not Defined 10.00 31.00 Apr-22 — Not Defined 18.00 49.00 May-22 — Not Defined 49.00 Jun-22 — Not Defined 49.00 FY 23 Target — Not Defined Target Estimate City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 9:04:35 am, Page 3 Completed Stormwater video inspection projects Public Works Owner Q Donald Perry (Public Works) Methodology Analysis Action/Improvement Plan The number of completed stormwater video inspection projects during each month. List kept in an Access database maintained by staff. Monthly: Completed Stormwater video inspection projects Database location: \\durham_pw\Public_Works\SW\DivisionFiles\Infrastructure\DrainageProj 6 Target Annual: Completed Stormwater video inspection projects 10 0 ATO�R, Actual/YTD — Target Estimate Measure Data Period — Status Jul-16 — Not Defined Aug-16 — Not Defined Sep-16 — Not Defined Oct-16 — Not Defined Nov-16 — Not Defined Dec-16 — Not Defined Jan-17 — Not Defined City of Durham, NC Apr-22 Report 2 — 0 ti, , , N tititir r r ti^ r titi titi titi ,Jc Actual (Monthly) Actual (Monthly) Target Created in DataHub Estimate Actual/YTD Generated 05/04/2022 9:06:52 am, Page 1 Period Status Actual (Monthly) Target Estimate Actual/YTD Feb-17 Not Defined Mar-17 Not Defined Apr-17 Not Defined May-17 Not Defined Jun-17 Not Defined Jul-17 Not Defined 0 15 0 Aug-17 Not Defined 0 15 0 Sep-17 Not Defined 5 15 5 Oct-17 Not Defined 0 15 5 Nov-17 Not Defined 0 15 5 Dec-17 Not Defined 1 15 6 Jan-18 Not Defined 0 15 6 Feb-18 Not Defined 6 15 12 Mar-18 Not Defined 0 15 12 Apr-18 Not Defined 0 15 12 May-18 Not Defined 7 15 19 Jun-18 Not Defined 2 15 21 Jul-18 ♦ Needs Improvement 0 15 0 Aug-18 jr On Target 7 15 7 Sep-18 ♦ On Target 0 15 7 Oct-18 ♦ On Target 2 15 9 Nov-18 ♦ On Target 1 15 10 Dec-18 ♦ On Target 0 15 10 Jan-19 ♦ On Target 0 15 10 Feb-19 ♦ On Target 0 15 10 Mar-19 ♦ On Target 2 15 12 Apr-19 ♦ On Target 7 15 19 May-19 ♦ On Target 2 15 21 Jun-19 ♦ On Target 0 15 21 21 Jul-19 ♦ On Target 0 15 0 Aug-19 ♦ On Target 5 15 5 Sep-19 ♦ On Target 0 15 5 Oct-19 ♦ On Target 0 15 5 Nov-19 ♦ On Target 0 15 5 Dec-19 ♦ On Target 0 15 5 Jan-20 ♦ On Target 0 15 5 Feb-20 ♦ On Target 0 15 5 Mar-20 ♦ On Target 0 15 5 Apr-20 ♦ On Target 9 15 14 May-20 ♦ On Target 0 15 14 Jun-20 Close to Target 0 15 14 14 Jul-20 ♦ On Target 0 20 20 0 Aug-20 ♦ On Target 0 20 20 0 Sep-20 ♦ On Target 0 20 20 0 Oct-20 ♦ On Target 6 20 20 6 Nov-20 ♦ On Target 1 20 20 7 Dec-20 ♦ On Target 0 20 20 7 Jan-21 Close to Target 0 20 15 7 Feb-21 Close to Target 1 20 15 8 Mar-21 Close to Target 0 20 15 8 Apr-21 Close to Target 4 20 15 12 City of Durham, INC Apr-22 Report Created in Data Hub Generated 05/04/2022 9:06:52 am, Page 2 Period — Status May-21 Close to Target Jun-21 =j Close to Target Jul-21 ♦ On Target Aug-21 ♦ On Target Sep-21 ♦ On Target Oct-21 ♦ On Target Nov-21 ♦ On Target Dec-21 ♦ On Target Jan-22 ♦ On Target Feb-22 ♦ Needs Improvement Mar-22 Close to Target Apr-22 — Not Defined May-22 — Not Defined Jun-22 — Not Defined FY 23 Target — Not Defined Actual (Monthly) Target 1 2 3 0 0 3 0 0 1 0 6 Estimate 20 15 20 15 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 Actual/YTD 13 15 3 3 3 6 6 6 7 7 13 13 13 13 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 9:06:52 am, Page 3 # of annual SCM inspection reports assessed Public Works Owner 10 Shea Bolick (Public Works) Methodology Summarization of the number of as -built plans/certifications received for review. This is tracked via the Stormwater Development Review logbook. The logbook is found at \\Durham_pw\public_works\SW\Division Files\Quality\Docs\REVIEWS\Stormwater logbooks (as builts, CDs, site plans, stream ID).xls. Analysis Action/Improvement Plan # of annual SCM inspection reports assessed (Monthly) 150.00 1 Target 00.00 50.00 # of annual SCM inspection reports assessed 0.00 - 1,500.00 Monthly Actual 1,000.00 500.00 0.00 `Lo0`L ao'� <k Q� <k F1 F1 " Q Total/YTD — Target Estimate Measure Data Period Status Jul-16 Not Defined Aug-16 Not Defined Sep-16 Not Defined Oct-16 Not Defined Nov-16 Not Defined Dec-16 Not Defined Jan-17 Not Defined City of Durham, NC Apr-22 Report Monthly Actual Total/YTD 58.00 58.00 64.00 122.00 44.00 166.00 38.00 204.00 61.00 265.00 63.00 328.00 82.00 410.00 Created in DataHub Target Estimate 732 732 732 732 732 732 732 Generated 05/04/2022 9:17:15 am, Page 1 Period Status Monthly Actual Total/YTD Target Estimate Feb-17 Not Defined 39.00 449.00 732 Mar-17 Not Defined 59.00 508.00 732 Apr-17 Not Defined 61.00 569.00 732 May-17 Not Defined 64.00 633.00 732 Jun-17 Not Defined 99.00 732.00 732 Jul-17 Not Defined 49.00 49.00 750 Aug-17 Not Defined 56.00 105.00 750 Sep-17 Not Defined 60.00 165.00 750 Oct-17 Not Defined 50.00 215.00 750 Nov-17 Not Defined 70.00 285.00 750 Dec-17 Not Defined 48.00 333.00 750 Jan-18 Not Defined 90.00 423.00 750 Feb-18 Not Defined 80.00 503.00 750 Mar-18 Not Defined 72.00 575.00 750 Apr-18 Not Defined 62.00 637.00 750 May-18 Not Defined 76.00 713.00 750 Jun-18 ♦ On Target 58.00 771.00 750 Jul-18 ♦ On Target 84.00 84.00 755 Aug-18 ♦ On Target 136.00 220.00 755 Sep-18 ♦ On Target 32.00 252.00 755 Oct-18 ♦ On Target 85.00 337.00 755 Nov-18 ♦ On Target 102.00 439.00 755 Dec-18 ♦ On Target 85.00 524.00 755 Jan-19 ♦ On Target 115.00 639.00 755 Feb-19 ♦ On Target 121.00 760.00 755 Mar-19 Complete 73.00 833.00 755 Apr-19 Complete 124.00 957.00 755 May-19 Complete 95.00 1,052.00 755 Jun-19 Complete 118.00 1,170.00 755 Jul-19 ♦ On Target 98.00 98.00 880 Aug-19 ♦ On Target 132.00 230.00 880 Sep-19 ♦ On Target 81.00 311.00 880 Oct-19 ♦ On Target 86.00 397.00 880 Nov-19 ♦ On Target 98.00 495.00 880 Dec-19 ♦ On Target 106.00 601.00 880 Jan-20 ♦ On Target 111.00 712.00 880 Feb-20 ♦ On Target 122.00 834.00 880 Mar-20 ♦ On Target 26.00 860.00 880 Apr-20 Complete 98.00 958.00 880 May-20 Complete 53.00 1,011.00 880 Jun-20 ✓ Complete 87.00 1,098.00 880 Jul-20 ♦ On Target 80.00 80.00 950 Aug-20 ♦ On Target 74.00 154.00 950 Sep-20 ♦ On Target 121.00 275.00 950 Oct-20 ♦ On Target 69.00 344.00 950 Nov-20 ♦ On Target 104.00 448.00 950 Dec-20 ♦ On Target 69.00 517.00 950 Jan-21 ♦ On Target 99.00 616.00 950 Feb-21 ♦ On Target 115.00 731.00 950 Mar-21 ♦ On Target 92.00 823.00 950 Apr-21 ♦ On Target 67.00 890.00 950 City of Durham, INC Apr-22 Report Created in Data Hub Generated 05/04/2022 9:17:15 am, Page 2 Period Status Monthly Actual Total/YTD May-21 ♦ On Target 54.00 944.00 Jun-21 Complete 139.00 1,083.00 Jul-21 ♦ On Target 86.00 86.00 Aug-21 ♦ On Target 149.00 235.00 Sep-21 ♦ On Target 112.00 347.00 Oct-21 ♦ On Target 116.00 463.00 Nov-21 ♦ On Target 124.00 587.00 Dec-21 ♦ On Target 102.00 689.00 Jan-22 ♦ On Target 112.00 801.00 Feb-22 ♦ On Target 106.00 907.00 Mar-22 Complete 116.00 1,023.00 Apr-22 Not Defined 1,023.00 May-22 Not Defined 1,023.00 Jun-22 Not Defined 1,023.00 FY 23 Target Not Defined Target Estimate 950 950 950 950 950 950 950 950 950 950 950 950 950 950 City of Durham, INC Apr-22 Report Created in Data Hub Generated 05/04/2022 9:17:15 am, Page 3 of annual SCM inspection reports submitted Public Works Owner Shea Bolick (Public Works) Methodology Calculation taken from Cityworks using crystal reports. Target % of annual SCM inspection reports submitted 1.00 0.50 0.00 Q Total/YTD - Target Estimate Measure Data Period Status Jul-16 Not Defined Aug-16 Not Defined Sep-16 Not Defined Oct-16 Not Defined Nov-16 Not Defined Dec-16 Not Defined Jan-17 Not Defined Feb-17 Not Defined Mar-17 Not Defined Apr-17 Not Defined May-17 Not Defined City of Durham, INC Apr-22 Report Analysis Action/Improvement Plan % of annual SCM inspection reports submitted (Monthly) i nn 0.75 0.50 0.25 0.00 ,Z) tiIZ� ti^ ti^ ti^ ti^ ti^ ti^ titi ti� Monthly Denominator Monthly Actual Performance 66.00 66.00 1.00 73.00 75.00 0.97 39.00 39.00 1.00 50.00 52.00 0.96 50.00 52.00 0.96 66.00 66.00 1.00 72.00 73.00 0.99 40.00 40.00 1.00 41.00 42.00 0.98 54.00 54.00 1.00 59.00 59.00 1.00 Created in Data Hub Monthly Performance - Target Total/YTD Target Estimate 1.00 0.96 0.99 0.96 0.99 0.96 0.98 0.96 0.98 0.96 0.98 0.96 0.98 0.96 0.99 0.96 0.98 0.96 0.99 0.96 0.99 0.96 Generated 05/04/2022 9:08:16 am, Page 1 Period Status Monthly Denominator Monthly Total/YTD Target Estimate Actual Performance Jun-17 Not Defined 66.00 78.00 0.85 0.98 0.96 Jul-17 Not Defined 66.00 66.00 1.00 1.00 0.96 Aug-17 Not Defined 78.00 79.00 0.99 0.99 0.96 Sep-17 Not Defined 42.00 43.00 0.98 0.99 0.96 Oct-17 Not Defined 54.00 54.00 1.00 0.99 0.96 Nov-17 Not Defined 52.00 53.00 0.98 0.99 0.96 Dec-17 Not Defined 70.00 73.00 0.96 0.98 0.96 Jan-18 Not Defined 74.00 79.00 0.94 0.98 0.96 Feb-18 Not Defined 34.00 40.00 0.85 0.96 0.96 Mar-18 Not Defined 34.00 44.00 0.77 0.94 0.96 Apr-18 Not Defined 61.00 63.00 0.97 0.94 0.96 May-18 Not Defined 42.00 44.00 0.95 0.94 0.96 Jun-18 Close to Target 68.00 81.00 0.84 0.94 0.96 Jul-18 ♦ On Target 68.00 70.00 0.97 0.97 0.96 Aug-18 Close to Target 77.00 83.00 0.93 0.95 0.96 Sep-18 Close to Target 52.00 53.00 0.98 0.96 0.96 Oct-18 Close to Target 64.00 65.00 0.98 0.97 0.96 Nov-18 0 Close to Target 56.00 58.00 0.97 0.97 0.96 Dec-18 ♦ Needs Improvement 86.00 87.00 0.99 0.97 0.96 Jan-19 ♦ Needs Improvement 83.00 84.00 0.99 0.97 0.96 Feb-19 Close to Target 42.00 44.00 0.95 0.97 0.96 Mar-19 Close to Target 43.00 45.00 0.96 0.97 0.96 Apr-19 Close to Target 67.00 71.00 0.94 0.97 0.96 May-19 Close to Target 73.00 75.00 0.97 0.97 0.96 Jun-19 Close to Target 83.00 90.00 0.92 0.96 0.96 Jul-19 Close to Target 79.00 79.00 1.00 1.00 0.94 Aug-19 Close to Target 95.00 100.00 0.95 0.98 0.94 Sep-19 Close to Target 60.00 62.00 0.97 0.97 0.94 Oct-19 Close to Target 72.00 76.00 0.95 0.97 0.94 Nov-19 Close to Target 63.00 65.00 0.97 0.97 0.94 Dec-19 Not Defined 88.00 90.00 0.98 0.97 0.94 Jan-20 Close to Target 80.00 81.00 0.99 0.97 0.94 Feb-20 Close to Target 41.00 45.00 0.91 0.96 0.94 Mar-20 Close to Target 38.00 44.00 0.86 0.95 0.94 Apr-20 Close to Target 45.00 63.00 0.71 0.93 0.94 May-20 Close to Target 64.00 83.00 0.77 0.91 0.94 Jun-20 Close to Target 65.00 97.00 0.67 0.89 0.94 Jul-20 Close to Target 78.00 89.00 0.88 0.88 0.80 Aug-20 Close to Target 89.00 104.00 0.86 0.87 0.80 Sep-20 Close to Target 57.00 65.00 0.88 0.87 0.80 Oct-20 Close to Target 73.00 90.00 0.81 0.86 0.80 Nov-20 Close to Target 58.00 66.00 0.88 0.86 0.80 Dec-20 Close to Target 76.00 81.00 0.94 0.87 0.80 Jan-21 Close to Target 69.00 92.00 0.75 0.86 0.80 Feb-21 ! Close to Target 50.00 67.00 0.75 0.84 0.80 Mar-21 ♦ On Target 63.00 64.00 0.98 0.86 0.80 Apr-21 ♦ On Target 69.00 71.00 0.97 0.87 0.80 May-21 ♦ On Target 75.00 81.00 0.93 0.87 0.80 Jun-21 Complete 66.00 82.00 0.80 0.87 0.80 Jul-21 ♦ On Target 82.00 83.00 0.99 0.99 0.80 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 9:08:16 am, Page 2 Period - Status Monthly Denominator Monthly Actual Performance Aug-21 ♦ On Target 109.00 116.00 0.94 Sep-21 ♦ On Target 62.00 65.00 0.95 Oct-21 ♦ On Target 85.00 93.00 0.91 Nov-21 ♦ On Target 67.00 69.00 0.97 Dec-21 ♦ On Target 77.00 81.00 0.95 Jan-22 ♦ On Target 91.00 92.00 0.99 Feb-22 ♦ On Target 64.00 70.00 0.91 Mar-22 ♦ On Target 57.00 69.00 0.83 Apr-22 - Not Defined May-22 - Not Defined Jun-22 - Not Defined FY 23 Target - Not Defined City of Durham, NC Apr-22 Report Created in DataHub Total/YTD Target 0.96 0.80 0.96 0.80 0.95 0.80 0.95 0.80 0.95 0.80 0.96 0.80 0.95 0.80 0.94 0.80 0.94 0.80 0.94 0.80 0.94 0.80 Estimate Generated 05/04/2022 9:08:16 am, Page 3 # of annual SCM maintenance inspections (QA/QC reports & TCRs) Public Works Owner Shea Bolick (Public Works) Methodology This number is currently tracked by the senior engineering technicians by Outlook. This tracking method will change this fiscal year due to the evolution of the SCM Tool and a query of reviewed results input in the SCM Tool. Target # of annual SCM maintenance inspections (QA/QC reports & TCRs) 750.00 500.00 250.00 0.00 11 41:1 F Total/YTD - Target Estimate Measure Data Period Status Jul-16 Not Defined Aug-16 Not Defined Sep-16 Not Defined Oct-16 Not Defined Nov-16 Not Defined Dec-16 Not Defined Jan-17 Not Defined Feb-17 Not Defined City of Durham, INC Apr-22 Report Analysis Action/Improvement Plan # of annual SCM maintenance inspections (QA/QC reports & TCRs) (Monthly) 150.00 100.00 50.00 Monthly Actual Total/YTD 18.00 18.00 17.00 35.00 7.00 42.00 9.00 51.00 5.00 56.00 8.00 64.00 10.00 74.00 7.00 81.00 Created in Data Hub Monthly Actual Target Estimate 163.00 163.00 163.00 163.00 163.00 163.00 163.00 163.00 Generated 05/04/2022 9:28:29 am, Page 1 Period Status Monthly Actual Total/YTD Target Estimate Mar-17 Not Defined 10.00 91.00 163.00 Apr-17 Not Defined 18.00 109.00 163.00 May-17 Not Defined 18.00 127.00 163.00 Jun-17 Not Defined 19.00 146.00 163.00 Jul-17 Not Defined 13.00 13.00 300.00 Aug-17 Not Defined 10.00 23.00 300.00 Sep-17 Not Defined 16.00 39.00 300.00 Oct-17 Not Defined 21.00 60.00 300.00 Nov-17 Not Defined 46.00 106.00 300.00 Dec-17 Not Defined 46.00 152.00 300.00 Jan-18 Not Defined 55.00 207.00 300.00 Feb-18 Not Defined 60.00 267.00 300.00 Mar-18 Not Defined 55.00 322.00 300.00 Apr-18 Not Defined 29.00 351.00 300.00 May-18 Not Defined 20.00 371.00 300.00 Jun-18 ♦ On Target 20.00 391.00 300.00 Jul-18 ♦ Needs Improvement 9.00 9.00 400.00 Aug-18 ♦ Needs Improvement 11.00 20.00 400.00 Sep-18 ♦ Needs Improvement 15.00 35.00 400.00 Oct-18 ♦ Needs Improvement 34.00 69.00 400.00 Nov-18 ♦ Needs Improvement 58.00 127.00 400.00 Dec-18 ♦ On Target 58.00 185.00 400.00 Jan-19 ♦ On Target 89.00 274.00 400.00 Feb-19 ♦ On Target 69.00 343.00 400.00 Mar-19 Complete 61.00 404.00 400.00 Apr-19 Complete 80.00 484.00 400.00 May-19 Complete 70.00 554.00 400.00 Jun-19 Complete 95.00 649.00 400.00 Jul-19 ♦ On Target 73.00 73.00 600.00 Aug-19 ♦ On Target 70.00 143.00 600.00 Sep-19 ♦ On Target 70.00 213.00 600.00 Oct-19 ♦ On Target 67.00 280.00 600.00 Nov-19 ♦ On Target 81.00 361.00 600.00 Dec-19 ♦ On Target 85.00 446.00 600.00 Jan-20 ♦ On Target 79.00 525.00 600.00 Feb-20 ♦ On Target 92.00 617.00 600.00 Mar-20 ♦ On Target 19.00 636.00 600.00 Apr-20 ♦ On Target 0.00 636.00 600.00 May-20 Complete 4.00 640.00 600.00 Jun-20 Complete 48.00 688.00 600.00 Jul-20 ♦ On Target 31.00 31.00 600.00 Aug-20 Close to Target 40.00 71.00 600.00 Sep-20 ♦ On Target 92.00 163.00 600.00 Oct-20 ♦ On Target 58.00 221.00 600.00 Nov-20 ♦ On Target 83.00 304.00 600.00 Dec-20 ♦ On Target 47.00 351.00 600.00 Jan-21 ♦ On Target 78.00 429.00 600.00 Feb-21 ♦ On Target 73.00 502.00 600.00 Mar-21 ♦ On Target 42.00 544.00 600.00 Apr-21 Complete 59.00 603.00 600.00 May-21 Complete 45.00 648.00 600.00 City of Durham, INC Apr-22 Report Created in Data Hub Generated 05/04/2022 9:28:29 am, Page 2 Period Status Monthly Actual Total/YTD Jun-21 Complete 95.00 743.00 Jul-21 ♦ On Target 67.00 67.00 Aug-21 ♦ On Target 112.00 179.00 Sep-21 ♦ On Target 94.00 273.00 Oct-21 ♦ On Target 83.00 356.00 Nov-21 ♦ On Target 83.00 439.00 Dec-21 ♦ On Target 73.00 512.00 Jan-22 ♦ On Target 94.00 606.00 Feb-22 ♦ On Target 65.00 671.00 Mar-22 Complete 42.00 713.00 Apr-22 - Not Defined 713.00 May-22 Not Defined 713.00 Jun-22 Not Defined 713.00 FY 23 Target Not Defined Target Estimate 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 9:28:29 am, Page 3 # of as -built plans / certifications reviewed Public Works Owner 10 Shea Bolick (Public Works) Methodology Summarization of the number of plats received for review This is tracked via the Stormwater Development Review logbook. The logbook is found at \\Durham_pw\public_works\SW\Division Files\Quality\Docs\REVIEWS\Stormwater logbooks (as builts, CDs, site plans, stream ID).xls. All planning case numbers that begin with a S represent site plats. Target # of as -built plans / certifications reviewed 200.00 150.00 100.00 50.00 0.00 Apr-22 ti Lo^ ti�^b ti�^9 ti�0o tidy^ ti�OL 41:1 Qk� Q Total/YTD — Target Estimate Measure Data Period Status Jul-16 Not Defined Aug-16 Not Defined Sep-16 Not Defined Oct-16 Not Defined Nov-16 Not Defined Dec-16 Not Defined Jan-17 Not Defined City of Durham, NC Apr-22 Report Analysis Action/Improvement Plan 4M # of as -built plans / certifications reviewed (Monthly) 30.00 20.00 Monthly Actual Total/YTD 16.00 16.00 12.00 28.00 6.00 34.00 1.00 35.00 5.00 40.00 13.00 53.00 3.00 56.00 Created in DataHub N N o^ N N ti ti Monthly Actual Target Estimate 80.00 80.00 80.00 80.00 80.00 80.00 80.00 Generated 05/04/2022 10:37:13 am, Page 1 Period Status Monthly Actual Total/YTD Target Estimate Feb-17 Not Defined 2.00 58.00 80.00 Mar-17 Not Defined 9.00 67.00 80.00 Apr-17 Not Defined 6.00 73.00 80.00 May-17 Not Defined 11.00 84.00 80.00 Jun-17 Not Defined 14.00 98.00 80.00 Jul-17 Not Defined 3.00 3.00 80.00 Aug-17 Not Defined 9.00 12.00 80.00 Sep-17 Not Defined 4.00 16.00 80.00 Oct-17 Not Defined 24.00 40.00 80.00 Nov-17 Not Defined 23.00 63.00 80.00 Dec-17 Not Defined 9.00 72.00 80.00 Jan-18 Not Defined 6.00 78.00 80.00 Feb-18 Not Defined 18.00 96.00 80.00 Mar-18 Not Defined 7.00 103.00 80.00 Apr-18 Not Defined 8.00 111.00 80.00 May-18 Not Defined 11.00 122.00 80.00 Jun-18 ♦ On Target 23.00 145.00 80.00 Jul-18 ♦ On Target 12.00 12.00 110.00 Aug-18 ♦ On Target 14.00 26.00 110.00 Sep-18 Close to Target 1.00 27.00 110.00 Oct-18 Close to Target 8.00 35.00 110.00 Nov-18 ♦ On Target 11.00 46.00 110.00 Dec-18 ♦ On Target 16.00 62.00 110.00 Jan-19 ♦ On Target 15.00 77.00 110.00 Feb-19 ♦ On Target 4.00 81.00 110.00 Mar-19 ♦ On Target 8.00 89.00 110.00 Apr-19 ♦ On Target 2.00 91.00 110.00 May-19 ♦ On Target 3.00 94.00 110.00 Jun-19 Close to Target 12.00 106.00 110.00 Jul-19 ♦ On Target 10.00 10.00 110.00 Aug-19 Close to Target 5.00 15.00 110.00 Sep-19 ♦ On Target 14.00 29.00 110.00 Oct-19 ♦ On Target 8.00 37.00 110.00 Nov-19 ♦ On Target 10.00 47.00 110.00 Dec-19 Not Defined 10.00 57.00 110.00 Jan-20 ♦ On Target 22.00 79.00 110.00 Feb-20 ♦ On Target 9.00 88.00 110.00 Mar-20 ♦ On Target 13.00 101.00 110.00 Apr-20 ♦ On Target 7.00 108.00 110.00 May-20 Complete 11.00 119.00 110.00 Jun-20 Complete 21.00 140.00 110.00 Jul-20 ♦ On Target 19.00 19.00 110.00 Aug-20 ♦ On Target 6.00 25.00 110.00 Sep-20 ♦ On Target 13.00 38.00 110.00 Oct-20 ♦ On Target 18.00 56.00 110.00 Nov-20 ♦ On Target 19.00 75.00 110.00 Dec-20 ♦ On Target 16.00 91.00 110.00 Jan-21 ♦ On Target 7.00 98.00 110.00 Feb-21 ♦ On Target 9.00 107.00 110.00 Mar-21 ♦ On Target 10.00 117.00 110.00 Apr-21 Complete 12.00 129.00 110.00 City of Durham, INC Apr-22 Report Created in Data Hub Generated 05/04/2022 10:37:13 am, Page 2 Period Status Monthly Actual Total/YTD May-21 Complete 18.00 147.00 Jun-21 Complete 20.00 167.00 Jul-21 ♦ On Target 6.00 6.00 Aug-21 ♦ On Target 14.00 20.00 Sep-21 ♦ On Target 19.00 39.00 Oct-21 ♦ On Target 11.00 50.00 Nov-21 ♦ On Target 15.00 65.00 Dec-21 ♦ On Target 11.00 76.00 Jan-22 ♦ On Target 10.00 86.00 Feb-22 ♦ On Target 12.00 98.00 Mar-22 * On Target 11.00 109.00 Apr-22 Not Defined 109.00 May-22 Not Defined 109.00 Jun-22 Not Defined 109.00 FY 23 Target Not Defined Target Estimate 110.00 110.00 110.00 110.00 110.00 110.00 110.00 110.00 110.00 110.00 110.00 110.00 110.00 110.00 City of Durham, INC Apr-22 Report Created in Data Hub Generated 05/04/2022 10:37:13 am, Page 3 % of assessments/inspections performed within established timeframes Public Works Owner 10 Shea Bolick (Public Works) Methodology Target of assessments/inspections performed within established timeframes inn nn u 50.00% 0% F-l0 Total/YTD - Target 0 Estimate Measure Data Period - Status Jul-16 - Not Defined Aug-16 - Not Defined Sep-16 - Not Defined Oct-16 - Not Defined Nov-16 - Not Defined Dec-16 - Not Defined Jan-17 - Not Defined Feb-17 - Not Defined Mar-17 - Not Defined Apr-17 - Not Defined May-17 - Not Defined City of Durham, NC Apr-22 Report Analysis Action/Improvement Plan of assessments/inspections performed within established timeframes (Monthly) 100.00% 75.00% 50.00% 25.00% V %o tiQ) ti�Z) x tit 1 ^ ti^ ti^ 1 N 1 ^ ti^ 1 ti� 1 9�`a� S 41 ' ° 11ac Monthly Performance - Target Monthly Denominator Monthly Actual Performance 64.00 66.00 96.97% 36.00 58.00 62.07% 16.00 42.00 38.10% 21.00 38.00 55.26% 26.00 61.00 42.62% 59.00 63.00 93.65% 81.00 82.00 98.78% 36.00 39.00 92.31 55.00 59.00 93.22% 61.00 61.00 100.00% 62.00 64.00 96.88% Created in DataHub Total/YTD Target Estimate 96.97% 85.00% 79.52% 85.00% 65.71 % 85.00% 63.10% 85.00% 59.00% 85.00% 64.78% 85.00% 69.64% 85.00% 72.47% 85.00% 74.78% 85.00% 77.30% 85.00% 79.08% 85.00% Generated 05/04/2022 9:30:07 am, Page 1 Period - Status Monthly Denominator Monthly Total/YTD Target Estimate Actual Performance Jun-17 - Not Defined 85.00 99.00 85.86% 79.64% 85.00% Jul-17 - Not Defined 39.00 49.00 79.59% 79.59% 85.00% Aug-17 - Not Defined 51.00 56.00 91.07% 85.33% 85.00% Sep-17 - Not Defined 43.00 60.00 71.67% 80.78% 85.00% Oct-17 - Not Defined 48.00 50.00 96.00% 84.58% 85.00% Nov-17 - Not Defined 69.00 70.00 98.57% 87.38% 85.00% Dec-17 - Not Defined 48.00 48.00 100.00% 89.48% 85.00% Jan-18 - Not Defined 90.00 90.00 100.00% 90.99% 85.00% Feb-18 - Not Defined 43.00 43.00 100.00% 92.11% 85.00% Mar-18 - Not Defined 38.00 38.00 100.00% 92.99% 85.00% Apr-18 - Not Defined 48.00 62.00 77.42% 91.43% 85.00% May-18 - Not Defined 62.00 76.00 81.58% 90.54% 85.00% Jun-18 ♦ On Target 82.00 82.00 100.00% 91.33% 85.00% Jul-18 ♦ On Target 81.00 84.00 96.43% 96.43% 85.00% Aug-18 ♦ On Target 136.00 136.00 100.00% 98.21% 85.00% Sep-18 ♦ On Target 27.00 32.00 84.38% 93.60% 85.00% Oct-18 ♦ On Target 70.00 85.00 82.35% 90.79% 85.00% Nov-18 ♦ On Target 86.00 102.00 84.31% 89.49% 85.00% Dec-18 ♦ On Target 85.00 85.00 100.00% 91.25% 85.00% Jan-19 ♦ On Target 115.00 115.00 100.00% 92.50% 85.00% Feb-19 ♦ On Target 121.00 121.00 100.00% 93.43% 85.00% Mar-19 ♦ On Target 73.00 73.00 100.00% 94.16% 85.00% Apr-19 ♦ On Target 124.00 124.00 100.00% 94.75% 85.00% May-19 ♦ On Target 79.00 80.00 98.75% 95.11 % 85.00% Jun-19 Complete 118.00 118.00 100.00% 95.52% 85.00% Jul-19 ♦ On Target 98.00 98.00 100.00% 100.00% 85.00% Aug-19 ♦ On Target 132.00 132.00 100.00% 100.00% 85.00% Sep-19 ♦ On Target 81.00 81.00 100.00% 100.00% 85.00% Oct-19 ♦ On Target 86.00 86.00 100.00% 100.00% 85.00% Nov-19 ♦ On Target 98.00 98.00 100.00% 100.00% 85.00% Dec-19 - Not Defined 106.00 106.00 100.00% 100.00% 85.00% Jan-20 ♦ On Target 111.00 111.00 100.00% 100.00% 85.00% Feb-20 ♦ On Target 122.00 122.00 100.00% 100.00% 85.00% Mar-20 ♦ On Target 26.00 26.00 100.00% 100.00% 85.00% Apr-20 ♦ On Target 78.00 98.00 79.59% 97.96% 85.00% May-20 ♦ On Target 52.00 53.00 98.11% 97.97% 85.00% Jun-20 Complete 80.00 87.00 91.95% 97.47% 85.00% Jul-20 Close to Target 6.00 80.00 7.50% 7.50% 85.00% Aug-20 Close to Target 11.00 74.00 14.86% 11.18% 85.00% Sep-20 Close to Target 121.00 121.00 100.00% 40.79% 85.00% Oct-20 Close to Target 69.00 69.00 100.00% 55.59% 85.00% Nov-20 Close to Target 104.00 104.00 100.00% 64.47% 85.00% Dec-20 Close to Target 69.00 69.00 100.00% 70.39% 85.00% Jan-21 Close to Target 99.00 99.00 100.00% 74.62% 85.00% Feb-21 Close to Target 115.00 115.00 100.00% 77.80% 85.00% Mar-21 Close to Target 92.00 92.00 100.00% 80.26% 85.00% Apr-21 Close to Target 67.00 67.00 100.00% 82.24% 85.00% May-21 ♦ On Target 54.00 54.00 100.00% 83.85% 85.00% Jun-21 Complete 139.00 139.00 100.00% 85.20% 85.00% Jul-21 ♦ On Target 86.00 86.00 100.00% 100.00% 85.00% City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 9:30:07 am, Page 2 Period Status Monthly Denominator Monthly Actual Performance Aug-21 ♦ On Target 148.00 149.00 99.33% Sep-21 ♦ On Target 112.00 112.00 100.00% Oct-21 ♦ On Target 116.00 116.00 100.00% Nov-21 ♦ On Target 124.00 124.00 100.00% Dec-21 ♦ On Target 102.00 102.00 100.00% Jan-22 ♦ On Target 112.00 112.00 100.00% Feb-22 ♦ On Target 105.00 106.00 99.06% Mar-22 Complete 116.00 116.00 100.00% Apr-22 — Not Defined May-22 — Not Defined Jun-22 — Not Defined FY 23 Target Not Defined City of Durham, NC Apr-22 Report Created in DataHub Total/YTD Target 99.66% 85.00% 99.78% 85.00% 99.83% 85.00% 99.87% 85.00% 99.89% 85.00% 99.90% 85.00% 99.80% 85.00% 99.82% 85.00% 99.82% 85.00% 99.82% 85.00% 99.82% 85.00% Estimate Generated 05/04/2022 9:30:07 am, Page 3 # of construction drawings Public Works Owner 10 Shea Bolick (Public Works) Methodology Summarization of the number of site plans received for review. This is tracked via the Stormwater Development Review logbook. The logbook is found at \\Durham_pw\public_works\SW\Division Files\Quality\Docs\REVIEWS\Stormwater logbooks (as builts, CDs, site plans, stream ID).xls. All planning case numbers that begin with a D represent site plans. Target # of construction drawings (Monthly) 40.00 30.00 20.00 10.00 0.00 �O �O �C �O Measure Data N ^ N ^ N ^ ti . Monthly Actual Period — Status Jul-16 Not Defined Aug-16 Not Defined Sep-16 Not Defined Oct-16 Not Defined Nov-16 Not Defined Dec-16 Not Defined City of Durham, NC Apr-22 Report Analysis Action/Improvement Plan # of construction drawings 200.00 0.00 1141:1 10 F Total/YTD — Target Estimate Monthly Actual Total/YTD 22.00 22.00 35.00 57.00 30.00 87.00 35.00 122.00 20.00 142.00 34.00 176.00 Created in DataHub Target Estimate 250.00 250.00 250.00 250.00 250.00 250.00 Generated 05/04/2022 10:35:16 am, Page 1 Period - Status Monthly Actual Total/YTD Target Estimate Jan-17 - Not Defined 25.00 201.00 250.00 Feb-17 - Not Defined 35.00 236.00 250.00 Mar-17 - Not Defined 38.00 274.00 250.00 Apr-17 - Not Defined 24.00 298.00 250.00 May-17 - Not Defined 34.00 332.00 250.00 Jun-17 - Not Defined 39.00 371.00 250.00 Jul-17 - Not Defined 30.00 30.00 250.00 Aug-17 - Not Defined 30.00 60.00 250.00 Sep-17 - Not Defined 29.00 89.00 250.00 Oct-17 - Not Defined 26.00 115.00 250.00 Nov-17 - Not Defined 32.00 147.00 250.00 Dec-17 - Not Defined 25.00 172.00 250.00 Jan-18 - Not Defined 16.00 188.00 250.00 Feb-18 - Not Defined 21.00 209.00 250.00 Mar-18 - Not Defined 39.00 248.00 250.00 Apr-18 - Not Defined 20.00 268.00 250.00 May-18 - Not Defined 28.00 296.00 250.00 Jun-18 Close to Target 26.00 322.00 250.00 Jul-18 ♦ On Target 36.00 36.00 270.00 Aug-18 ♦ On Target 38.00 74.00 270.00 Sep-18 ♦ On Target 36.00 110.00 270.00 Oct-18 ♦ On Target 37.00 147.00 270.00 Nov-18 ♦ On Target 25.00 172.00 270.00 Dec-18 ♦ On Target 25.00 197.00 270.00 Jan-19 ♦ On Target 20.00 217.00 270.00 Feb-19 ♦ On Target 33.00 250.00 270.00 Mar-19 Complete 24.00 274.00 270.00 Apr-19 ✓ Complete 35.00 309.00 270.00 May-19 ✓ Complete 24.00 333.00 270.00 Jun-19 Complete 33.00 366.00 270.00 Jul-19 ♦ On Target 35.00 35.00 300.00 Aug-19 ♦ On Target 24.00 59.00 300.00 Sep-19 ♦ On Target 20.00 79.00 300.00 Oct-19 ♦ On Target 23.00 102.00 300.00 Nov-19 ♦ On Target 23.00 125.00 300.00 Dec-19 - Not Defined 15.00 140.00 300.00 Jan-20 Close to Target 26.00 166.00 300.00 Feb-20 Close to Target 21.00 187.00 300.00 Mar-20 Close to Target 11.00 198.00 300.00 Apr-20 Close to Target 21.00 219.00 300.00 May-20 Close to Target 23.00 242.00 300.00 Jun-20 Close to Target 31.00 273.00 300.00 Jul-20 ♦ On Target 30.00 30.00 275.00 Aug-20 ♦ On Target 19.00 49.00 275.00 Sep-20 ♦ On Target 25.00 74.00 275.00 Oct-20 ♦ On Target 18.00 92.00 275.00 Nov-20 ♦ On Target 29.00 121.00 275.00 Dec-20 ♦ On Target 17.00 138.00 275.00 Jan-21 ♦ On Target 19.00 157.00 275.00 Feb-21 ♦ On Target 18.00 175.00 275.00 Mar-21 Close to Target 24.00 199.00 275.00 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 10:35:16 am, Page 2 Period - Status Monthly Actual Total/YTD Apr-21 ♦ On Target 21.00 220.00 May-21 ♦ On Target 20.00 240.00 Jun-21 Complete 27.00 267.00 Jul-21 ♦ On Target 23.00 23.00 Aug-21 ♦ On Target 25.00 48.00 Sep-21 ♦ On Target 26.00 74.00 Oct-21 ♦ On Target 28.00 102.00 Nov-21 ♦ On Target 25.00 127.00 Dec-21 ♦ On Target 29.00 156.00 Jan-22 ♦ On Target 22.00 178.00 Feb-22 ♦ On Target 29.00 207.00 Mar-22 ♦ On Target 34.00 241.00 Apr-22 - Not Defined 241.00 May-22 - Not Defined 241.00 Jun-22 - Not Defined 241.00 FY 23 Target - Not Defined Target Estimate 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 260.00 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 10:35:16 am, Page 3 # of final plats Public Works Owner Analysis 10 Shea Bolick (Public Works) Action/Improvement Plan Methodology Summarization of the number of SCMs. This is tracked via the Stormwater Development Review logbook. The logbook is found at \\Durham_pw\public_works\SW\Division # of final plats (Monthly) Files\Quality\Docs\REVIEWS\Stormwater logbooks (as builts, CDs, site plans, stream ID).xls. 20.00 Target # of final plats 200.00 100.00 0.00 - �o� Qk Q Total/YTD - Target Estimate Measure Data Period Status Jul-16 - Not Defined Aug-16 - Not Defined Sep-16 - Not Defined Oct-16 - Not Defined Nov-16 - Not Defined Dec-16 - Not Defined Jan-17 - Not Defined Feb-17 - Not Defined City of Durham, NC Apr-22 Report 15.00 10.00 5.00 0.00 - Apr-22 o ,o\Oo�eQOooN NN ,JN N N,� Monthly Actual Monthly Actual Total/YTD 16.00 16.00 28.00 44.00 15.00 59.00 17.00 76.00 24.00 100.00 13.00 113.00 13.00 126.00 18.00 144.00 Created in DataHub Target Estimate 110.00 110.00 110.00 110.00 110.00 110.00 110.00 110.00 Generated 05/04/2022 10:31:05 am, Page 1 Period Status Monthly Actual Total/YTD Target Estimate Mar-17 Not Defined 16.00 160.00 110.00 Apr-17 Not Defined 18.00 178.00 110.00 May-17 Not Defined 13.00 191.00 110.00 Jun-17 Not Defined 6.00 197.00 110.00 Jul-17 Not Defined 10.00 10.00 110.00 Aug-17 Not Defined 14.00 24.00 110.00 Sep-17 Not Defined 9.00 33.00 110.00 Oct-17 Not Defined 12.00 45.00 110.00 Nov-17 Not Defined 10.00 55.00 110.00 Dec-17 Not Defined 18.00 73.00 110.00 Jan-18 Not Defined 9.00 82.00 110.00 Feb-18 Not Defined 8.00 90.00 110.00 Mar-18 Not Defined 18.00 108.00 110.00 Apr-18 Not Defined 11.00 119.00 110.00 May-18 Not Defined 12.00 131.00 110.00 Jun-18 Close to Target 15.00 146.00 110.00 Jul-18 Close to Target 10.00 10.00 125.00 Aug-18 ♦ On Target 16.00 26.00 125.00 Sep-18 ♦ On Target 16.00 42.00 125.00 Oct-18 ♦ On Target 16.00 58.00 125.00 Nov-18 ♦ On Target 17.00 75.00 125.00 Dec-18 ♦ On Target 11.00 86.00 125.00 Jan-19 ♦ On Target 19.00 105.00 125.00 Feb-19 ♦ On Target 25.00 130.00 125.00 Mar-19 Complete 12.00 142.00 125.00 Apr-19 Complete 19.00 161.00 125.00 May-19 Complete 19.00 180.00 125.00 Jun-19 Complete 8.00 188.00 125.00 Jul-19 ♦ On Target 11.00 11.00 130.00 Aug-19 ♦ On Target 14.00 25.00 130.00 Sep-19 ♦ On Target 9.00 34.00 130.00 Oct-19 ♦ On Target 14.00 48.00 130.00 Nov-19 ♦ On Target 11.00 59.00 130.00 Dec-19 Not Defined 9.00 68.00 130.00 Jan-20 ♦ On Target 15.00 83.00 130.00 Feb-20 ♦ On Target 14.00 97.00 130.00 Mar-20 ♦ On Target 7.00 104.00 130.00 Apr-20 ♦ On Target 10.00 114.00 130.00 May-20 ♦ On Target 9.00 123.00 130.00 Jun-20 Complete 18.00 141.00 130.00 Jul-20 ♦ On Target 19.00 19.00 140.00 Aug-20 ♦ On Target 12.00 31.00 140.00 Sep-20 ♦ On Target 11.00 42.00 140.00 Oct-20 Close to Target 3.00 45.00 140.00 Nov-20 Close to Target 12.00 57.00 140.00 Dec-20 ♦ On Target 12.00 69.00 140.00 Jan-21 ♦ On Target 15.00 84.00 140.00 Feb-21 ♦ On Target 14.00 98.00 140.00 Mar-21 ♦ On Target 13.00 111.00 140.00 Apr-21 ♦ On Target 15.00 126.00 140.00 May-21 ♦ On Target 9.00 135.00 140.00 City of Durham, INC Apr-22 Report Created in Data Hub Generated 05/04/2022 10:31:05 am, Page 2 Period Status Monthly Actual Total/YTD Jun-21 Complete 12.00 147.00 Jul-21 ♦ On Target 5.00 5.00 Aug-21 ♦ On Target 13.00 18.00 Sep-21 ♦ On Target 8.00 26.00 Oct-21 ♦ On Target 17.00 43.00 Nov-21 ♦ On Target 9.00 52.00 Dec-21 ♦ On Target 12.00 64.00 Jan-22 ♦ On Target 11.00 75.00 Feb-22 ♦ On Target 12.00 87.00 Mar-22 ♦ On Target 14.00 101.00 Apr-22 - Not Defined 101.00 May-22 - Not Defined 101.00 Jun-22 - Not Defined 101.00 FY 23 Target Not Defined Target Estimate 140.00 140.00 140.00 140.00 140.00 140.00 140.00 140.00 140.00 140.00 140.00 140.00 140.00 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 10:31:05 am, Page 3 # of SCMs certified Public Works Owner Analysis Shea Bolick (Public Works) Action/Improvement Plan Methodology Source: Derived directly from GIS via attribute query. The query selects all projects that have been created (CREATEDATE) during the month. # of SCMs certified Target # of SCMs certified (Monthly) 15.00 10.00 5.00 0.00 �O �O �O �O Measure Data NNNNN ^ ti ti Monthly Actual Period Status Jul-16 Not Defined Aug-16 Not Defined Sep-16 Not Defined Oct-16 Not Defined Nov-16 Not Defined Dec-16 Not Defined Jan-17 Not Defined Feb-17 Not Defined Mar-17 Not Defined Apr-17 Not Defined City of Durham, INC Apr-22 Report 100.00 75.00 50.00 25.00 0.00 Monthly Actual Total/YTD 5.00 5.00 5.00 10.00 5.00 15.00 2.00 17.00 1.00 18.00 5.00 23.00 4.00 27.00 5.00 32.00 3.00 35.00 1.00 36.00 Created in Data Hub 1141:1 10 Q Total/YTD - Target 10 Estimate Target Estimate 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 Generated 05/04/2022 9:07:44 am, Page 1 Period Status Monthly Actual Total/YTD Target Estimate May-17 Not Defined 4.00 40.00 50.00 Jun-17 Not Defined 4.00 44.00 50.00 Jul-17 Not Defined 5.00 5.00 50.00 Aug-17 Not Defined 2.00 7.00 50.00 Sep-17 Not Defined 6.00 13.00 50.00 Oct-17 Not Defined 7.00 20.00 50.00 Nov-17 Not Defined 7.00 27.00 50.00 Dec-17 Not Defined 15.00 42.00 50.00 Jan-18 Not Defined 5.00 47.00 50.00 Feb-18 Not Defined 4.00 51.00 50.00 Mar-18 Not Defined 3.00 54.00 50.00 Apr-18 Not Defined 6.00 60.00 50.00 May-18 Not Defined 10.00 70.00 50.00 Jun-18 ♦ On Target 9.00 79.00 50.00 Jul-18 ♦ On Target 7.00 7.00 65.00 Aug-18 ♦ On Target 3.00 10.00 65.00 Sep-18 Close to Target 4.00 14.00 65.00 Oct-18 ♦ On Target 12.00 26.00 65.00 Nov-18 ♦ On Target 6.00 32.00 65.00 Dec-18 ♦ On Target 7.00 39.00 65.00 Jan-19 ♦ On Target 12.00 51.00 65.00 Feb-19 ♦ On Target 3.00 54.00 65.00 Mar-19 ♦ On Target 0.00 54.00 65.00 Apr-19 ♦ On Target 0.00 54.00 65.00 May-19 Close to Target 1.00 55.00 65.00 Jun-19 Close to Target 5.00 60.00 65.00 Jul-19 Close to Target 2.00 2.00 65.00 Aug-19 Close to Target 3.00 5.00 65.00 Sep-19 Close to Target 6.00 11.00 65.00 Oct-19 Close to Target 5.00 16.00 65.00 Nov-19 ! Close to Target 9.00 25.00 65.00 Dec-19 Not Defined 1.00 26.00 65.00 Jan-20 Close to Target 7.00 33.00 65.00 Feb-20 Close to Target 5.00 38.00 65.00 Mar-20 Close to Target 4.00 42.00 65.00 Apr-20 Close to Target 6.00 48.00 65.00 May-20 Close to Target 9.00 57.00 65.00 Jun-20 Close to Target 2.00 59.00 65.00 Jul-20 ♦ On Target 4.00 4.00 60.00 Aug-20 ♦ On Target 9.00 13.00 60.00 Sep-20 ♦ On Target 4.00 17.00 60.00 Oct-20 ♦ On Target 2.00 19.00 60.00 Nov-20 Close to Target 3.00 22.00 60.00 Dec-20 ♦ On Target 10.00 32.00 60.00 Jan-21 Close to Target 5.00 37.00 60.00 Feb-21 ♦ On Target 4.00 41.00 60.00 Mar-21 Close to Target 2.00 43.00 60.00 Apr-21 Close to Target 3.00 46.00 60.00 May-21 ♦ On Target 11.00 57.00 60.00 Jun-21 Complete 4.00 61.00 60.00 Jul-21 ♦ On Target 11.00 11.00 60.00 City of Durham, INC Apr-22 Report Created in Data Hub Generated 05/04/2022 9:07:44 am, Page 2 Period — Status Monthly Actual Total/YTD Target Aug-21 ♦ On Target 3.00 14.00 60.00 Sep-21 ♦ On Target 3.00 17.00 60.00 Oct-21 ♦ On Target 4.00 21.00 60.00 Nov-21 Close to Target 1.00 22.00 60.00 Dec-21 ♦ On Target 8.00 30.00 60.00 Jan-22 ♦ On Target 0.00 30.00 60.00 Feb-22 Close to Target 1.00 31.00 60.00 Mar-22 Close to Target 6.00 37.00 60.00 Apr-22 — Not Defined 37.00 60.00 May-22 — Not Defined 37.00 60.00 Jun-22 — Not Defined 37.00 60.00 FY 23 Target — Not Defined Estimate City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 9:07:44 am, Page 3 # of site plans Public Works Owner Analysis 10 Shea Bolick (Public Works) Action/Improvement Plan Methodology Summarization of the number of rezoning plans received for review. This is tracked via the Stormwater Development Review logbook. The logbook is found at # of site plans (Monthly) \\Durham_pw\public_works\SW\Division Files\Quality\Docs\REVIEWS\Stormwater logbooks (as builts, CDs, site plans, stream ID).xls. All planning case numbers that 60.00 begin with a Z represent rezoning plans. Target # of site plans 600.00 400.00 200.00 0.00 L� ti Q Total/YTD — Target Estimate Measure Data Period — Status Jul-16 Not Defined Aug-16 Not Defined Sep-16 Not Defined Oct-16 Not Defined Nov-16 Not Defined Dec-16 Not Defined City of Durham, NC Apr-22 Report 40.00 20.00 0.00 — Apr-22 o ,o\Oo�eQOooN NN ,JN N N,� Monthly Actual Monthly Actual Total/YTD 34.00 34.00 40.00 74.00 28.00 102.00 37.00 139.00 43.00 182.00 36.00 218.00 Created in DataHub Target Estimate 450.00 450.00 450.00 450.00 450.00 450.00 Generated 05/04/2022 10:30:12 am, Page 1 Period Status Monthly Actual Total/YTD Target Estimate Jan-17 Not Defined 37.00 255.00 450.00 Feb-17 Not Defined 34.00 289.00 450.00 Mar-17 Not Defined 40.00 329.00 450.00 Apr-17 Not Defined 39.00 368.00 450.00 May-17 Not Defined 49.00 417.00 450.00 Jun-17 Not Defined 34.00 451.00 450.00 Jul-17 Not Defined 36.00 36.00 450.00 Aug-17 Not Defined 45.00 81.00 450.00 Sep-17 Not Defined 39.00 120.00 450.00 Oct-17 Not Defined 38.00 158.00 450.00 Nov-17 Not Defined 31.00 189.00 450.00 Dec-17 Not Defined 31.00 220.00 450.00 Jan-18 Not Defined 21.00 241.00 450.00 Feb-18 Not Defined 37.00 278.00 450.00 Mar-18 Not Defined 40.00 318.00 450.00 Apr-18 Not Defined 36.00 354.00 450.00 May-18 Not Defined 37.00 391.00 450.00 Jun-18 Close to Target 36.00 427.00 450.00 Jul-18 ♦ On Target 42.00 42.00 425.00 Aug-18 ♦ On Target 30.00 72.00 425.00 Sep-18 Close to Target 29.00 101.00 425.00 Oct-18 ♦ On Target 42.00 143.00 425.00 Nov-18 ♦ On Target 32.00 175.00 425.00 Dec-18 ♦ On Target 44.00 219.00 425.00 Jan-19 Close to Target 24.00 243.00 425.00 Feb-19 Close to Target 16.00 259.00 425.00 Mar-19 Close to Target 34.00 293.00 425.00 Apr-19 Close to Target 43.00 336.00 425.00 May-19 Close to Target 37.00 373.00 425.00 Jun-19 Close to Target 41.00 414.00 425.00 Jul-19 Close to Target 17.00 17.00 400.00 Aug-19 Close to Target 37.00 54.00 400.00 Sep-19 Close to Target 33.00 87.00 400.00 Oct-19 Close to Target 44.00 131.00 400.00 Nov-19 ♦ On Target 36.00 167.00 400.00 Dec-19 Not Defined 44.00 211.00 400.00 Jan-20 ♦ On Target 32.00 243.00 400.00 Feb-20 ♦ On Target 35.00 278.00 400.00 Mar-20 ♦ On Target 27.00 305.00 400.00 Apr-20 ♦ On Target 27.00 332.00 400.00 May-20 Close to Target 24.00 356.00 400.00 Jun-20 Close to Target 27.00 383.00 400.00 Jul-20 ♦ On Target 38.00 38.00 380.00 Aug-20 ♦ On Target 27.00 65.00 380.00 Sep-20 ♦ On Target 37.00 102.00 380.00 Oct-20 ♦ On Target 28.00 130.00 380.00 Nov-20 ♦ On Target 31.00 161.00 380.00 Dec-20 ♦ On Target 34.00 195.00 380.00 Jan-21 ♦ On Target 20.00 215.00 380.00 Feb-21 ♦ On Target 40.00 255.00 380.00 Mar-21 ♦ On Target 38.00 293.00 380.00 City of Durham, INC Apr-22 Report Created in Data Hub Generated 05/04/2022 10:30:12 am, Page 2 Period - Status Monthly Actual Total/YTD Apr-21 ♦ On Target 37.00 330.00 May-21 ♦ On Target 29.00 359.00 Jun-21 Complete 39.00 398.00 Jul-21 ♦ On Target 34.00 34.00 Aug-21 ♦ On Target 42.00 76.00 Sep-21 ♦ On Target 28.00 104.00 Oct-21 ♦ On Target 39.00 143.00 Nov-21 ♦ On Target 37.00 180.00 Dec-21 ♦ On Target 36.00 216.00 Jan-22 ♦ On Target 37.00 253.00 Feb-22 ♦ On Target 35.00 288.00 Mar-22 ♦ On Target 53.00 341.00 Apr-22 - Not Defined 341.00 May-22 - Not Defined 341.00 Jun-22 - Not Defined 341.00 FY 23 Target - Not Defined Target Estimate 380.00 380.00 380.00 380.00 380.00 380.00 380.00 380.00 380.00 380.00 380.00 380.00 380.00 380.00 380.00 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 10:30:12 am, Page 3 % of Total plans reviewed on time Public Works Owner 10 Shea Bolick (Public Works) Methodology Produce a weighted average of on -time items. Number of DRB items multiplied by on time percentage of DRB items, plus Construction Drawings, plus Building Permits (501), plus License and Extension Agreements. Target of Total plans reviewed on time 100.00% 50.00% 0 °/ I°titi 4" F TotalNTD — Target 0 Estimate Measure Data Analysis Action/Improvement Plan of Total plans reviewed on time (Monthly) 100.00% 75.00% 50.00% 25.00% n-1 ,yo ,yo ,yo ,yo Period Status Monthly Denominator Monthly Actual Performance Jul-16 Not Defined 56.00 75.00 74.67% Aug-16 Not Defined 74.00 110.00 67.27% Sep-16 Not Defined 65.00 77.00 84.42% Oct-16 Not Defined 60.00 85.00 70.59% Nov-16 Not Defined 78.00 92.00 84.78% Dec-16 Not Defined 71.00 86.00 82.56% Jan-17 Not Defined 71.00 80.00 88.75% Feb-17 Not Defined 83.00 92.00 90.22% City of Durham, NC Apr-22 Report Created in DataHub Apr-22 c0^ N �I,^ ^ Q0^ ^ titi anti Monthly Performance — Target Total/YTD Target Estimate 74.67% 85.00% 70.27% 85.00% 74.43% 85.00% 73.49% 85.00% 75.85% 85.00% 76.95% 85.00% 78.51 % 85.00% 80.06% 85.00% Generated 05/04/2022 10:36:34 am, Page 1 Period - Status Monthly Denominator Monthly Total/YTD Target Estimate Actual Performance Mar-17 - Not Defined 91.00 99.00 91.92% 81.53% 85.00% Apr-17 - Not Defined 75.00 85.00 88.24% 82.18% 85.00% May-17 - Not Defined 97.00 100.00 97.00% 83.69% 85.00% Jun-17 - Not Defined 81.00 82.00 98.78% 84.85% 85.00% Jul-17 - Not Defined 76.00 77.00 98.70% 98.70% 85.00% Aug-17 - Not Defined 94.00 97.00 96.91 % 97.70% 85.00% Sep-17 - Not Defined 73.00 80.00 91.25% 95.67% 85.00% Oct-17 - Not Defined 73.00 77.00 94.81 % 95.47% 85.00% Nov-17 - Not Defined 70.00 80.00 87.50% 93.92% 85.00% Dec-17 - Not Defined 73.00 77.00 94.81% 94.06% 85.00% Jan-18 - Not Defined 47.00 47.00 100.00% 94.58% 85.00% Feb-18 - Not Defined 68.00 68.00 100.00% 95.19% 85.00% Mar-18 - Not Defined 101.00 103.00 98.06% 95.61% 85.00% Apr-18 - Not Defined 65.00 68.00 95.59% 95.61% 85.00% May-18 - Not Defined 81.00 83.00 97.59% 95.80% 85.00% Jun-18 ♦ On Target 77.00 79.00 97.47% 95.94% 85.00% Jul-18 ♦ On Target 90.00 92.00 97.83% 97.83% 86.00% Aug-18 ♦ On Target 86.00 87.00 98.85% 98.32% 86.00% Sep-18 ♦ On Target 86.00 86.00 100.00% 98.87% 86.00% Oct-18 ♦ On Target 89.00 101.00 88.12% 95.90% 86.00% Nov-18 ♦ On Target 79.00 80.00 98.75% 96.41% 86.00% Dec-18 ♦ On Target 82.00 84.00 97.62% 96.60% 86.00% Jan-19 ♦ On Target 64.00 64.00 100.00% 96.97% 86.00% Feb-19 ♦ On Target 78.00 78.00 100.00% 97.32% 86.00% Mar-19 ♦ On Target 75.00 76.00 98.68% 97.46% 86.00% Apr-19 ♦ On Target 103.00 103.00 100.00% 97.77% 86.00% May-19 ♦ On Target 80.00 80.00 100.00% 97.96% 86.00% Jun-19 Complete 80.00 80.00 100.00% 98.12% 86.00% Jul-19 ♦ On Target 87.00 87.00 100.00% 100.00% 88.00% Aug-19 ♦ On Target 88.00 88.00 100.00% 100.00% 88.00% Sep-19 ♦ On Target 65.00 67.00 97.01% 99.17% 88.00% Oct-19 ♦ On Target 88.00 90.00 97.78% 98.80% 88.00% Nov-19 ♦ On Target 75.00 75.00 100.00% 99.02% 88.00% Dec-19 - Not Defined 63.00 63.00 100.00% 99.15% 88.00% Jan-20 ♦ On Target 78.00 80.00 97.50% 98.91% 88.00% Feb-20 ♦ On Target 77.00 77.00 100.00% 99.04% 88.00% Mar-20 ♦ On Target 48.00 48.00 100.00% 99.11% 88.00% Apr-20 ♦ On Target 65.00 65.00 100.00% 99.19% 88.00% May-20 ♦ On Target 65.00 65.00 100.00% 99.25% 88.00% Jun-20 Complete 80.00 82.00 97.56% 99.10% 88.00% Jul-20 ♦ On Target 89.00 89.00 100.00% 100.00% 88.00% Aug-20 ♦ On Target 60.00 60.00 100.00% 100.00% 88.00% Sep-20 ♦ On Target 76.00 78.00 97.44% 99.12% 88.00% Oct-20 ♦ On Target 52.00 53.00 98.11% 98.93% 88.00% Nov-20 ♦ On Target 76.00 76.00 100.00% 99.16% 88.00% Dec-20 ♦ On Target 67.00 67.00 100.00% 99.29% 88.00% Jan-21 ♦ On Target 61.00 61.00 100.00% 99.38% 88.00% Feb-21 ♦ On Target 77.00 77.00 100.00% 99.47% 88.00% Mar-21 ♦ On Target 85.00 85.00 100.00% 99.54% 88.00% Apr-21 ♦ On Target 76.00 78.00 97.44% 99.31% 88.00% City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 10:36:34 am, Page 2 Period Status Monthly Denominator Monthly Actual Performance May-21 ♦ On Target 65.00 66.00 98.48% Jun-21 Complete 84.00 85.00 98.82% Jul-21 ♦ On Target 70.00 70.00 100.00% Aug-21 ♦ On Target 84.00 84.00 100.00% Sep-21 ♦ On Target 70.00 70.00 100.00% Oct-21 ♦ On Target 86.00 86.00 100.00% Nov-21 ♦ On Target 77.00 77.00 100.00% Dec-21 ♦ On Target 84.00 86.00 97.67% Jan-22 ♦ On Target 77.00 77.00 100.00% Feb-22 ♦ On Target 82.00 82.00 100.00% Mar-22 ♦ On Target 104.00 104.00 100.00% Apr-22 - Not Defined May-22 - Not Defined Jun-22 - Not Defined FY 23 Target Not Defined Total/YTD Target 99.24% 88.00% 99.20% 88.00% 100.00% 90.00% 100.00% 90.00% 100.00% 90.00% 100.00% 90.00% 100.00% 90.00% 99.58% 90.00% 99.64% 90.00% 99.68% 90.00% 99.73% 90.00% 99.73% 90.00% 99.73% 90.00% 99.73% 90.00% Estimate City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 10:36:34 am, Page 3 # SCMs reviewed Public Works Owner 10 Shea Bolick (Public Works) Methodology Summarization of the number of construction drawings received for review. This is tracked via the Stormwater Development Review logbook. The logbook is found at \\Durham_pw\public_works\SW\Division Files\Quality\Docs\REVIEWS\Stormwater logbooks (as builts, CDs, site plans, stream ID).xls. Target # SCMs reviewed 750.00 500.00 250.00 Analysis Action/Improvement Plan # SCMs reviewed (Monthly) 75.00 ® 50.00 0.00 ti Lo^ ti�^b ti�^9 ti�0o tidy^ ti�OL 41:1 Qk C Q Total/YTD — Target Estimate Measure Data Period Status Jul-16 Not Defined Aug-16 Not Defined Sep-16 Not Defined Oct-16 Not Defined Nov-16 Not Defined Dec-16 Not Defined Jan-17 Not Defined City of Durham, NC Apr-22 Report 25.00 0.00 yo ,yo ,yo do Monthly Actual Total/YTD 40.00 40.00 55.00 95.00 26.00 121.00 52.00 173.00 42.00 215.00 77.00 292.00 33.00 325.00 Created in DataHub tiN ti^ I N tiN ti^ ti^ tiI Monthly Actual Target Estimate 280.00 280.00 280.00 280.00 280.00 280.00 280.00 Generated 05/04/2022 9:27:28 am, Page 1 Period Status Monthly Actual Total/YTD Target Estimate Feb-17 Not Defined 57.00 382.00 280.00 Mar-17 Not Defined 40.00 422.00 280.00 Apr-17 Not Defined 32.00 454.00 280.00 May-17 Not Defined 59.00 513.00 280.00 Jun-17 Not Defined 53.00 566.00 280.00 Jul-17 Not Defined 40.00 40.00 280.00 Aug-17 Not Defined 47.00 87.00 280.00 Sep-17 Not Defined 44.00 131.00 280.00 Oct-17 Not Defined 50.00 181.00 280.00 Nov-17 Not Defined 55.00 236.00 280.00 Dec-17 Not Defined 36.00 272.00 280.00 Jan-18 Not Defined 24.00 296.00 280.00 Feb-18 Not Defined 31.00 327.00 280.00 Mar-18 Not Defined 49.00 376.00 280.00 Apr-18 Not Defined 28.00 404.00 280.00 May-18 Not Defined 28.00 432.00 280.00 Jun-18 Close to Target 43.00 475.00 280.00 Jul-18 ♦ On Target 58.00 58.00 340.00 Aug-18 ♦ On Target 72.00 130.00 340.00 Sep-18 ♦ On Target 46.00 176.00 340.00 Oct-18 ♦ On Target 52.00 228.00 340.00 Nov-18 ♦ On Target 37.00 265.00 340.00 Dec-18 ♦ On Target 38.00 303.00 340.00 Jan-19 ♦ On Target 37.00 340.00 340.00 Feb-19 ♦ On Target 45.00 385.00 340.00 Mar-19 Complete 40.00 425.00 340.00 Apr-19 Complete 51.00 476.00 340.00 May-19 Complete 36.00 512.00 340.00 Jun-19 Complete 37.00 549.00 340.00 Jul-19 ♦ On Target 54.00 54.00 400.00 Aug-19 ♦ On Target 38.00 92.00 400.00 Sep-19 ♦ On Target 32.00 124.00 400.00 Oct-19 ♦ On Target 29.00 153.00 400.00 Nov-19 ♦ On Target 34.00 187.00 400.00 Dec-19 Not Defined 21.00 208.00 400.00 Jan-20 ♦ On Target 42.00 250.00 400.00 Feb-20 ♦ On Target 27.00 277.00 400.00 Mar-20 Close to Target 11.00 288.00 400.00 Apr-20 Close to Target 33.00 321.00 400.00 May-20 Close to Target 23.00 344.00 400.00 Jun-20 Close to Target 50.00 394.00 400.00 Jul-20 ♦ On Target 46.00 46.00 400.00 Aug-20 ♦ On Target 19.00 65.00 400.00 Sep-20 ♦ On Target 27.00 92.00 400.00 Oct-20 Close to Target 27.00 119.00 400.00 Nov-20 Close to Target 32.00 151.00 400.00 Dec-20 Close to Target 25.00 176.00 400.00 Jan-21 Close to Target 22.00 198.00 400.00 Feb-21 Close to Target 32.00 230.00 400.00 Mar-21 Close to Target 46.00 276.00 400.00 Apr-21 ♦ On Target 22.00 298.00 350.00 City of Durham, INC Apr-22 Report Created in Data Hub Generated 05/04/2022 9:27:28 am, Page 2 Period Status Monthly Actual Total/YTD May-21 ♦ On Target 29.00 327.00 Jun-21 Complete 46.00 373.00 Jul-21 ♦ On Target 34.00 34.00 Aug-21 ♦ On Target 33.00 67.00 Sep-21 ♦ On Target 42.00 109.00 Oct-21 ♦ On Target 50.00 159.00 Nov-21 ♦ On Target 41.00 200.00 Dec-21 ♦ On Target 59.00 259.00 Jan-22 ♦ On Target 38.00 297.00 Feb-22 ♦ On Target 50.00 347.00 Mar-22 Complete 78.00 425.00 Apr-22 Not Defined 425.00 May-22 Not Defined 425.00 Jun-22 Not Defined 425.00 FY 23 Target Not Defined Target Estimate 350.00 350.00 350.00 350.00 350.00 350.00 350.00 350.00 350.00 350.00 350.00 350.00 350.00 350.00 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 9:27:28 am, Page 3 Total number of construction inspections Public Works Owner Shea Bolick (Public Works) Methodology Collect information from group's tracking sheet (location: F:\Eng\Division Files\Review\Failed Developments Project\Engineering TimeSheet.xlsx) Target Total number of construction inspections 400.00 200.00 0.00 ti Q TotaINTD - Target Estimate Measure Data Period Status jul-16 Not Defined Aug-16 Not Defined Sep-16 Not Defined Oct-16 Not Defined Nov-16 Not Defined Dec-16 Not Defined Jan-17 Not Defined Feb-17 Not Defined Mar-17 Not Defined Apr-17 Not Defined City of Durham, INC Apr-22 Report Analysis Action/Improvement Plan Total number of construction inspections (Monthly) 60.00 40.00 20.00 0.00 �O �O Monthly Actual Total/YTD 22.00 22.00 8.00 30.00 6.00 36.00 8.00 44.00 17.00 61.00 15.00 76.00 15.00 91.00 12.00 103.00 5.00 108.00 14.00 122.00 Created in Data Hub N ^ N ^ N ^ ti ti I , Monthly Actual Target Estimate 380.00 380.00 380.00 380.00 380.00 380.00 380.00 380.00 380.00 380.00 Generated 05/04/2022 10:34:33 am, Page 1 Period Status Monthly Actual Total/YTD Target Estimate May-17 Not Defined 14.00 136.00 380.00 Jun-17 Not Defined 10.00 146.00 380.00 Jul-17 Not Defined 19.00 19.00 220.00 Aug-17 Not Defined 16.00 35.00 220.00 Sep-17 Not Defined 27.00 62.00 220.00 Oct-17 Not Defined 17.00 79.00 220.00 Nov-17 Not Defined 16.00 95.00 220.00 Dec-17 Not Defined 22.00 117.00 220.00 Jan-18 Not Defined 16.00 133.00 220.00 Feb-18 Not Defined 11.00 144.00 220.00 Mar-18 Not Defined 16.00 160.00 220.00 Apr-18 Not Defined 15.00 175.00 220.00 May-18 Not Defined 19.00 194.00 220.00 Jun-18 Close to Target 15.00 209.00 220.00 Jul-18 ♦ Needs Improvement 9.00 9.00 240.00 Aug-18 ♦ Needs Improvement 10.00 19.00 240.00 Sep-18 ♦ Needs Improvement 7.00 26.00 240.00 Oct-18 ♦ Needs Improvement 26.00 52.00 240.00 Nov-18 Not Defined 9.00 61.00 240.00 Dec-18 ♦ Needs Improvement 12.00 73.00 240.00 Jan-19 ♦ On Target 87.00 160.00 240.00 Feb-19 ♦ On Target 55.00 215.00 240.00 Mar-19 Complete 51.00 266.00 240.00 Apr-19 ♦ On Target 32.00 298.00 240.00 May-19 Complete 44.00 342.00 240.00 Jun-19 Complete 33.00 375.00 240.00 Jul-19 Close to Target 17.00 17.00 280.00 Aug-19 Close to Target 15.00 32.00 280.00 Sep-19 Close to Target 35.00 67.00 280.00 Oct-19 ♦ On Target 29.00 96.00 280.00 Nov-19 ♦ On Target 47.00 143.00 280.00 Dec-19 ♦ On Target 26.00 169.00 280.00 Jan-20 ♦ On Target 48.00 217.00 280.00 Feb-20 ♦ On Target 50.00 267.00 280.00 Mar-20 ♦ On Target 26.00 293.00 280.00 Apr-20 Complete 0.00 293.00 280.00 May-20 Complete 9.00 302.00 280.00 Jun-20 Complete 8.00 310.00 280.00 Jul-20 ♦ On Target 25.00 25.00 280.00 Aug-20 ♦ On Target 21.00 46.00 280.00 Sep-20 ♦ On Target 46.00 92.00 280.00 Oct-20 ♦ On Target 42.00 134.00 280.00 Nov-20 ♦ On Target 22.00 156.00 280.00 Dec-20 ♦ On Target 24.00 180.00 280.00 Jan-21 ♦ On Target 19.00 199.00 280.00 Feb-21 ♦ On Target 32.00 231.00 280.00 Mar-21 ♦ On Target 43.00 274.00 280.00 Apr-21 Complete 38.00 312.00 280.00 May-21 Complete 33.00 345.00 280.00 Jun-21 ✓ Complete 40.00 385.00 280.00 Jul-21 ♦ On Target 28.00 28.00 300.00 City of Durham, INC Apr-22 Report Created in Data Hub Generated 05/04/2022 10:34:33 am, Page 2 Period — Status Monthly Actual Total/YTD Aug-21 ♦ On Target 29.00 57.00 Sep-21 ♦ On Target 38.00 95.00 Oct-21 ♦ On Target 18.00 113.00 Nov-21 ♦ On Target 12.00 125.00 Dec-21 ♦ On Target 17.00 142.00 Jan-22 ♦ On Target 18.00 160.00 Feb-22 ♦ On Target 28.00 188.00 Mar-22 ♦ On Target 34.00 222.00 Apr-22 — Not Defined 222.00 May-22 — Not Defined 222.00 Jun-22 — Not Defined 222.00 FY 23 Target — Not Defined Target Estimate 300.00 300.00 300.00 300.00 300.00 300.00 300.00 300.00 300.00 300.00 300.00 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 10:34:33 am, Page 3 # of rezoning plans Public Works Owner Shea Bolick (Public Works) Methodology Tracked in Cityworks service requests. Target # of rezoning plans 100.00 75.00 50.00 25.00 0.00 F Total/YTD - Target Estimate Measure Data Period Status Jul-16 Not Defined Aug-16 Not Defined Sep-16 Not Defined Oct-16 Not Defined Nov-16 Not Defined Dec-16 Not Defined Jan-17 Not Defined Feb-17 Not Defined Mar-17 Not Defined Apr-17 Not Defined May-17 Not Defined City of Durham, INC Apr-22 Report Analysis Action/Improvement Plan # of rezoning plans (Monthly) 10.00 5.00 0.00 �O �O Monthly Actual Total/YTD 3.00 3.00 7.00 10.00 4.00 14.00 5.00 19.00 5.00 24.00 3.00 27.00 5.00 32.00 5.00 37.00 5.00 42.00 4.00 46.00 4.00 50.00 Created in Data Hub N ^ N ^ N ^ ti ti Monthly Actual Target Estimate 45.00 45.00 45.00 45.00 45.00 45.00 45.00 45.00 45.00 45.00 45.00 Generated 05/04/2022 10:48:51 am, Page 1 Period Status Monthly Actual Total/YTD Target Estimate Jun-17 Not Defined 3.00 53.00 45.00 Jul-17 Not Defined 1.00 1.00 45.00 Aug-17 Not Defined 8.00 9.00 45.00 Sep-17 Not Defined 3.00 12.00 45.00 Oct-17 Not Defined 1.00 13.00 45.00 Nov-17 Not Defined 7.00 20.00 45.00 Dec-17 Not Defined 3.00 23.00 45.00 Jan-18 Not Defined 1.00 24.00 45.00 Feb-18 Not Defined 2.00 26.00 45.00 Mar-18 Not Defined 6.00 32.00 45.00 Apr-18 Not Defined 1.00 33.00 45.00 May-18 Not Defined 6.00 39.00 45.00 Jun-18 Close to Target 2.00 41.00 45.00 Jul-18 ♦ On Target 4.00 4.00 40.00 Aug-18 ♦ On Target 5.00 9.00 40.00 Sep-18 ♦ On Target 5.00 14.00 40.00 Oct-18 ♦ On Target 6.00 20.00 40.00 Nov-18 ♦ On Target 6.00 26.00 40.00 Dec-18 ♦ On Target 4.00 30.00 40.00 Jan-19 ♦ On Target 1.00 31.00 40.00 Feb-19 ♦ On Target 4.00 35.00 40.00 Mar-19 Complete 6.00 41.00 40.00 Apr-19 Complete 6.00 47.00 40.00 May-19 Complete 8.00 55.00 40.00 Jun-19 Complete 6.00 61.00 40.00 Jul-19 ♦ On Target 4.00 4.00 48.00 Aug-19 ♦ On Target 13.00 17.00 48.00 Sep-19 ♦ On Target 5.00 22.00 48.00 Oct-19 ♦ On Target 9.00 31.00 48.00 Nov-19 ♦ On Target 5.00 36.00 48.00 Dec-19 Not Defined 10.00 46.00 48.00 Jan-20 ♦ On Target 7.00 53.00 48.00 Feb-20 ♦ On Target 7.00 60.00 48.00 Mar-20 ♦ On Target 3.00 63.00 48.00 Apr-20 Complete 7.00 70.00 48.00 May-20 ♦ On Target 9.00 79.00 48.00 Jun-20 Complete 6.00 85.00 48.00 Jul-20 ♦ On Target 2.00 2.00 50.00 Aug-20 Close to Target 2.00 4.00 50.00 Sep-20 Close to Target 5.00 9.00 50.00 Oct-20 Close to Target 4.00 13.00 50.00 Nov-20 Close to Target 4.00 17.00 50.00 Dec-20 Close to Target 4.00 21.00 50.00 Jan-21 Close to Target 7.00 28.00 50.00 Feb-21 Close to Target 5.00 33.00 50.00 Mar-21 ♦ On Target 10.00 43.00 50.00 Apr-21 ♦ On Target 5.00 48.00 50.00 May-21 Complete 8.00 56.00 50.00 Jun-21 Complete 7.00 63.00 50.00 Jul-21 ♦ On Target 8.00 8.00 50.00 Aug-21 ♦ On Target 4.00 12.00 50.00 City of Durham, INC Apr-22 Report Created in Data Hub Generated 05/04/2022 10:48:51 am, Page 2 Period — Status Monthly Actual Total/YTD Sep-21 ♦ On Target 8.00 Oct-21 ♦ On Target 2.00 Nov-21 ♦ On Target 6.00 Dec-21 ♦ On Target 9.00 Jan-22 ♦ On Target 7.00 Feb-22 ♦ On Target 6.00 Mar-22 Complete 3.00 Apr-22 — Not Defined May-22 — Not Defined Jun-22 — Not Defined FY 23 Target — Not Defined Target 20.00 50.00 22.00 50.00 28.00 50.00 37.00 50.00 44.00 50.00 50.00 50.00 53.00 50.00 53.00 50.00 53.00 50.00 53.00 50.00 Estimate City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 10:48:51 am, Page 3 Curb miles swept (CORE Measure) Public Works Owner Trudy Boehm (Public Works) Methodology Workorders, which contain the information about sweeping operations completed by the Street Maintenance street cleaning crews, are entered daily into Cityworks, an Asset Management System. Miles swept is recorded on the Workorder. The monthly curb mile data is extracted from the Workorders in Cityworks using Crystal Reports. Target Annual: Curb miles swept 30,000 20,000 10,000 0 F���oa �y�otio F���o�ti Aa�Ae ti� Total/YTD - Target Estimate Measure Data Analysis The number of sweeping miles year-to-date total is over 19,000 so this measure continues to stay on target. There should be no problem reaching the FY22 goal of 20,000 miles. Even though the number of miles swept decreases during the leaf season, this measure has stayed on target for the past several years. Impacts to normal operations during April: • 2 rain days • FY22 year-end EPEP self appraisals • staff vacancies at 25 Action/Improvement Plan Curb miles swept (monthly) 4,000 3,000 2,000 1,000 0 � Monthly Performance Period Status Monthly Total/YTD Target Estimate Monthly Monthly Performance Target Target YTD Jul-16 Not Defined 1,600 1,600 20,000 1,667 1,667 Aug-16 Not Defined 2,442 4,042 20,000 1,667 3,333 Sep-16 Not Defined 1,850 5,892 20,000 1,667 5,000 Oct-16 Close to Target 2,066 7,958 20,000 1,667 6,667 Nov-16 Close to Target 1,535 9,493 20,000 1,667 8,333 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 11:30:22 am, Page 1 Period Status Monthly Total/YTD Target Estimate Monthly Monthly Performance Target Target YTD Dec-16 ♦ Needs Improvement 1,458 10,951 20,000 1,667 10,000 Jan-17 ♦ Needs Improvement 1,160 12,111 20,000 1,667 11,667 Feb-17 ♦ Needs Improvement 1,696 13,807 20,000 1,667 13,333 Mar-17 ♦ Needs Improvement 1,365 15,172 20,000 1,667 15,000 Apr-17 Close to Target 1,204 16,376 20,000 1,667 16,667 May-17 - Not Defined 2,241 18,617 20,000 1,667 18,333 Jun-17 - Not Defined 2,500 21,117 20,000 1,667 20,000 Jul-17 - Not Defined 2,841 2,841 20,000 1,667 1,667 Aug-17 - Not Defined 3,466 6,307 20,000 1,667 3,333 Sep-17 Close to Target 2,785 9,092 20,000 1,667 5,000 Oct-17 ♦ On Target 1,574 10,666 20,000 1,667 6,667 Nov-17 ♦ On Target 1,333 11,999 20,000 1,667 8,333 Dec-17 ♦ On Target 1,063 13,062 20,000 1,667 10,000 Jan-18 - Not Defined 745 13,807 20,000 1,667 11,667 Feb-18 ♦ On Target 867 14,674 20,000 1,667 13,333 Mar-18 ♦ On Target 737 15,411 20,000 1,667 15,000 Apr-18 ♦ On Target 1,696 17,107 20,000 1,667 16,667 May-18 ♦ On Target 1,627 18,734 20,000 1,667 18,333 Jun-18 ♦ On Target 1,796 20,530 20,000 1,667 20,000 Jul-18 ♦ On Target 1,479 1,479 20,000 1,667 1,667 Aug-18 ♦ On Target 1,833 3,312 20,000 1,667 3,333 Sep-18 Close to Target 1,367 4,679 20,000 1,667 5,000 Oct-18 Close to Target 1,467 6,146 20,000 1,667 6,667 Nov-18 Close to Target 1,246 7,392 20,000 1,667 8,333 Dec-18 ♦ Needs Improvement 780 8,172 20,000 1,667 10,000 Jan-19 ♦ Needs Improvement 1,545 9,717 20,000 1,667 11,667 Feb-19 ♦ Needs Improvement 1,043 10,760 20,000 1,667 13,333 Mar-19 ♦ Needs Improvement 1,226 11,986 20,000 1,667 15,000 Apr-19 ♦ Needs Improvement 1,311 13,297 20,000 1,667 16,667 May-19 ♦ Needs Improvement 1,575 14,872 20,000 1,667 18,333 Jun-19 Close to Target 2,001 16,873 20,000 1,667 20,000 Jul-19 ♦ On Target 3,088 3,088 20,000 1,667 1,667 Aug-19 ♦ On Target 3,578 6,666 20,000 1,667 3,333 Sep-19 ♦ On Target 2,649 9,315 20,000 1,667 5,000 Oct-19 ♦ On Target 2,503 11,818 20,000 1,667 6,667 Nov-19 ♦ On Target 1,786 13,604 20,000 1,667 8,333 Dec-19 ♦ On Target 1,720 15,324 20,000 1,667 10,000 Jan-20 ♦ On Target 1,714 17,038 20,000 1,667 11,667 Feb-20 ♦ On Target 1,681 18,719 20,000 1,667 13,333 Mar-20 ♦ On Target 1,886 20,605 20,000 1,667 15,000 Apr-20 ♦ On Target 302 20,907 20,000 1,667 16,667 May-20 ♦ On Target 1,747 22,654 20,000 1,667 18,333 Jun-20 ♦ On Target 2,759 25,413 20,000 1,667 20,000 Jul-20 ♦ On Target 2,650 2,650 20,000 1,667 1,667 Aug-20 ♦ On Target 2,853 5,503 20,000 1,667 3,333 Sep-20 ♦ On Target 2,104 7,607 20,000 1,667 5,000 Oct-20 ♦ On Target 2,273 9,880 20,000 1,667 6,667 Nov-20 ♦ On Target 940 10,820 20,000 1,667 8,333 Dec-20 ♦ On Target 1,247 12,067 20,000 1,667 10,000 Jan-21 ♦ On Target 1,567 13,634 20,000 1,667 11,667 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 11:30:22 am, Page 2 Period - Status Monthly Total/YTD Target Estimate Monthly Monthly Performance Target Target YTD Feb-21 ♦ On Target 1,587 15,221 20,000 1,667 13,333 Mar-21 ♦ On Target 2,151 17,372 20,000 1,667 15,000 Apr-21 ♦ On Target 2,307 19,679 20,000 1,667 16,667 May-21 ♦ On Target 1,835 21,514 20,000 1,667 18,333 Jun-21 ♦ On Target 3,197 24,711 20,000 1,667 20,000 Jul-21 ♦ On Target 2,655 2,655 20,000 1,667 1,667 Aug-21 ♦ On Target 3,007 5,662 20,000 1,667 3,333 Sep-21 ♦ On Target 2,533 8,195 20,000 1,667 5,000 Oct-21 ♦ On Target 2,155 10,350 20,000 1,667 6,667 Nov-21 ♦ On Target 1,557 11,907 20,000 1,667 8,333 Dec-21 ♦ On Target 1,109 13,016 20,000 1,667 10,000 Jan-22 ♦ On Target 579 13,595 20,000 1,667 11,667 Feb-22 ♦ On Target 1,058 14,653 20,000 1,667 13,333 Mar-22 ♦ On Target 2,498 17,151 20,000 1,667 15,000 Apr-22 ♦ On Target 2,340 19,491 20,000 1,667 16,667 May-22 - Not Defined 19,491 20,000 1,667 18,333 Jun-22 - Not Defined 19,491 20,000 20,000 1,667 20,000 FY 23 Target - Not Defined 20,000 1,667 1,667 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 11:30:22 am, Page 3 Cost per curb mile swept Public Works Owner Trudy Boehm (Public Works) Methodology Street cleaning Workorders contain the information about all sweeping work completed by the Street Maintenance street cleaning crews. These are entered daily into Cityworks, an Asset Management System. Costs for labor and equipment, as well as total miles swept is recorded on the Workorder. Total costs are divided by the number of miles swept to determine cost per curb mile. The data is extracted from the Workorders in Cityworks using Crystal Reports. Target Cost per curb mile swept $ 75.00 $ 50.00 $ 25.00 $ 0.00 F Total/YTD — Target Estimate Measure Data Period Status Jul-16 — Not Defined Aug-16 Not Defined Sep-16 Not Defined City of Durham, NC Apr-22 Report Analysis Action/Improvement Plan Cost per curb mile swept (Monthly) $ 150.00 $ 100.00 $ 50.00 $nnn ' do To �o yo dal 'Sy'PQ Nos Monthly Denominator Monthly Actual Performance $ 33,521.00 1,600 $ 20.95 $ 51,886.38 2,442 $ 21.25 $ 39,910.91 1,850 $ 21.57 Created in DataHub N N N . ,ti � L �� L���ti ,J�L��Q L�o�ti -.10 � t Monthly Performance — Target Total/YTD Target Estimate $ 20.95 $ 21.00 $ 21.13 $ 21.00 $ 21.27 $ 21.00 Generated 05/04/2022 11:30:43 am, Page 1 Period - Status Monthly Denominator Monthly Total/YTD Target Estimate Actual Performance Oct-16 - Not Defined $ 49,348.95 2,066 $ 23.89 $ 21.95 $ 21.00 Nov-16 - Not Defined $ 42,295.40 1,535 $ 27.55 $ 22.86 $ 21.00 Dec-16 - Not Defined $ 52,932.00 1,458 $ 36.30 $ 24.65 $ 21.00 Jan-17 - Not Defined $ 44,415.50 1,160 $ 38.29 $ 25.95 $ 21.00 Feb-17 - Not Defined $ 57,970.81 1,696 $ 34.18 $ 26.96 $ 21.00 Mar-17 - Not Defined $ 51,396.79 1,365 $ 37.65 $ 27.93 $ 21.00 Apr-17 - Not Defined $ 37,457.16 1,204 $ 31.11 $ 28.16 $ 21.00 May-17 - Not Defined $ 63,603.28 2,241 $ 28.38 $ 28.19 $ 21.00 Jun-17 - Not Defined $ 64,403.41 2,500 $ 25.76 $ 27.90 $ 21.00 Jul-17 - Not Defined $ 66,187.88 2,841 $ 23.30 $ 23.30 $ 21.00 Aug-17 - Not Defined $ 81,578.21 3,466 $ 23.54 $ 23.43 $ 21.00 Sep-17 - Not Defined $ 71,321.54 2,785 $ 25.61 $ 24.10 $ 21.00 Oct-17 - Not Defined $ 44,814.27 1,574 $ 28.47 $ 24.74 $ 21.00 Nov-17 - Not Defined $ 61,466.44 1,333 $ 46.11 $ 27.12 $ 21.00 Dec-17 - Not Defined $ 68,364.75 1,063 $ 64.31 $ 30.14 $ 21.00 Jan-18 - Not Defined $ 45,882.20 745 $ 61.59 $ 31.84 $ 21.00 Feb-18 - Not Defined $ 53,934.00 867 $ 62.21 $ 33.63 $ 21.00 Mar-18 - Not Defined $ 51,051.27 737 $ 69.27 $ 35.34 $ 21.00 Apr-18 - Not Defined $ 89,702.18 1,696 $ 52.89 $ 37.08 $ 21.00 May-18 - Not Defined $ 80,865.53 1,627 $ 49.70 $ 38.17 $ 21.00 Jun-18 ♦ Needs Improvement $ 88,513.92 1,796 $ 49.28 $ 39.15 $ 21.00 Jul-18 Close to Target $ 89,291.16 1,479 $ 60.37 $ 60.37 $ 55.00 Aug-18 ♦ On Target $ 95,331.28 1,834 $ 51.99 $ 55.73 $ 55.00 Sep-18 ♦ On Target $ 74,854.86 1,367 $ 54.76 $ 55.45 $ 55.00 Oct-18 ♦ On Target $ 74,822.95 1,467 $ 51.00 $ 54.39 $ 55.00 Nov-18 ♦ On Target $ 69,757.28 1,246 $ 55.99 $ 54.66 $ 55.00 Dec-18 ♦ On Target $ 44,649.56 780 $ 57.24 $ 54.90 $ 55.00 Jan-19 ♦ On Target $ 85,911.48 1,545 $ 55.61 $ 55.02 $ 55.00 Feb-19 ♦ On Target $ 64,154.51 1,043 $ 61.51 $ 55.65 $ 55.00 Mar-19 ♦ On Target $ 64,232.91 1,226 $ 52.39 $ 55.31 $ 55.00 Apr-19 ♦ On Target $ 68,853.14 1,311 $ 52.52 $ 55.04 $ 55.00 May-19 ♦ On Target $ 81,084.90 1,575 $ 51.48 $ 54.66 $ 55.00 Jun-19 ♦ On Target $ 100,783.31 2,001 $ 50.37 $ 54.15 $ 55.00 $ 58.00 Jul-19 ♦ On Target $ 143,074.07 3,088 $ 46.33 $ 46.33 $ 55.00 Aug-19 ♦ On Target $ 148,690.77 3,578 $ 41.56 $ 43.77 $ 55.00 Sep-19 ♦ On Target $ 112,019.08 2,649 $ 42.29 $ 43.35 $ 55.00 Oct-19 ♦ On Target $ 111,111.93 2,503 $ 44.39 $ 43.57 $ 55.00 Nov-19 ♦ On Target $ 80,054.79 1,786 $ 44.82 $ 43.73 $ 55.00 Dec-19 ♦ On Target $ 85,476.41 1,720 $ 49.70 $ 44.40 $ 55.00 Jan-20 ♦ On Target $ 82,253.38 1,714 $ 47.99 $ 44.76 $ 55.00 Feb-20 ♦ On Target $ 73,078.49 1,681 $ 43.47 $ 44.65 $ 55.00 Mar-20 ♦ On Target $ 77,268.74 1,886 $ 40.97 $ 44.31 $ 55.00 Apr-20 ♦ On Target $ 15,430.41 302 $ 51.09 $ 44.41 $ 55.00 May-20 ♦ On Target $ 76,968.60 1,747 $ 44.06 $ 44.38 $ 55.00 Jun-20 ♦ On Target $ 100,908.48 2,759 $ 36.57 $ 43.53 $ 55.00 $ 46.00 Jul-20 ♦ On Target $ 94,483.78 2,650 $ 35.65 $ 35.65 $ 55.00 Aug-20 ♦ On Target $ 106,574.66 2,853 $ 37.36 $ 36.54 $ 55.00 Sep-20 ♦ On Target $ 80,905.16 2,104 $ 38.45 $ 37.07 $ 55.00 Oct-20 ♦ On Target $ 125,095.76 2,273 $ 55.04 $ 41.20 $ 55.00 Nov-20 ♦ On Target $ 66,676.15 940 $ 70.93 $ 43.78 $ 55.00 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 11:30:43 am, Page 2 Period - Status Monthly Denominator Monthly Actual Performance Dec-20 ♦ On Target $ 86,771.19 1,247 $ 69.58 Jan-21 ♦ On Target $ 81,126.46 1,567 $ 51.77 Feb-21 ♦ On Target $ 73,434.95 1,587 $ 46.27 Mar-21 ♦ On Target $ 84,834.43 2,151 $ 39.44 Apr-21 ♦ On Target $ 101,863.24 2,307 $ 44.15 May-21 ♦ On Target $ 51,272.84 1,211 $ 42.34 Jun-21 ♦ On Target $ 119,965.64 3,197 $ 37.52 Jul-21 ♦ On Target $ 115,916.47 2,655 $ 43.66 Aug-21 ♦ On Target $ 115,623.74 3,007 $ 38.45 Sep-21 ♦ On Target $ 99,382.34 2,533 $ 39.24 Oct-21 ♦ On Target $ 108,533.00 2,155 $ 50.36 Nov-21 ♦ On Target $ 88,966.79 1,557 $ 57.14 Dec-21 ♦ On Target $ 108,554.73 1,109 $ 97.89 Jan-22 ♦ On Target $ 66,841.81 579 $ 115.44 Feb-22 ♦ On Target $ 44,409.15 1,058 $ 41.97 Mar-22 ♦ On Target $ 117,738.49 2,498 $ 47.13 Apr-22 ♦ On Target $ 99,284.34 2,340 $ 42.43 May-22 - Not Defined Jun-22 - Not Defined FY 23 Target - Not Defined Total/YTD Target $ 46.45 $ 55.00 $ 47.06 $ 55.00 $ 46.98 $ 55.00 $ 46.05 $ 55.00 $ 45.82 $ 55.00 $ 45.62 $ 55.00 $ 44.55 $ 55.00 $ 43.66 $ 55.00 $ 40.89 $ 55.00 $ 40.38 $ 55.00 $ 42.46 $ 55.00 $ 44.38 $ 55.00 $ 48.94 $ 55.00 $ 51.77 $ 55.00 $ 51.06 $ 55.00 $ 50.49 $ 55.00 $ 49.52 $ 55.00 $ 49.52 $ 55.00 $ 49.52 $ 55.00 $ 55.00 Estimate $ 55.00 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 11:30:43 am, Page 3 of street sweeping requests responded to within 3 business days of notification Public Works Owner Trudy Boehm (Public Works) Methodology All of the data is extracted from Cityworks using Crystal Reports, using the information from both Service Requests and Workorders. There are numerous Service Requests that are received throughout the month, from residents, and each of them is addressed by the street cleaning crews. The number of days between the creation date of a Sweeping Repair Service Request and the Actual Finish Date on the attached completed Workorder is calculated, with the goal being 3 business days or less to complete the request. Target % of street sweeping requests responded to within 3 business days of notification 100.00% 50.00% 0 °% ti 2�0'O Fy Fy Fy Fy yl C Q 10 Total/YTD — Target 0 Estimate Measure Data Period Status Jul-16 Not Defined Aug-16 Not Defined Sep-16 Not Defined City of Durham, INC Apr-22 Report Analysis Action/Improvement Plan % of street sweeping requests responded to within 3 business days of notification (monthly) 100.00% _ _ _ ■ 75.00°% 50.00% 25.00% 0% X� �� ti� �� �� �� r � I Monthly Performance Monthly Denominator Monthly Actual Performance 38.00 42.00 90.48% 71.00 71.00 100.00% 34.00 35.00 97.14% Created in Data Hub Total/YTD Target Estimate 90.48% 100.00% 95.24% 100.00% 95.87% 100.00% Generated 05/04/2022 11:31:10 am, Page 1 Period - Status Monthly Denominator Monthly Total/YTD Target Estimate Actual Performance Oct-16 Close to Target 50.00 51.00 98.04% 96.41% 100.00% Nov-16 Close to Target 60.00 67.00 89.55% 95.04% 100.00% Dec-16 - Not Defined 23.00 60.00 38.33% 85.59% 100.00% Jan-17 - Not Defined 48.00 79.00 60.76% 82.04% 100.00% Feb-17 ♦ Needs Improvement 56.00 102.00 54.90% 78.65% 100.00% Mar-17 - Not Defined 31.00 59.00 52.54% 75.75% 100.00% Apr-17 ♦ Needs Improvement 27.00 39.00 69.23% 75.10% 100.00% May-17 - Not Defined 28.00 34.00 82.35% 75.76% 100.00% Jun-17 - Not Defined 45.00 47.00 95.74% 77.42% 100.00% Jul-17 - Not Defined 53.00 63.00 84.13% 84.13% 100.00% Aug-17 - Not Defined 60.00 67.00 89.55% 86.84% 100.00% Sep-17 - Not Defined 69.00 71.00 97.18% 90.29% 100.00% Oct-17 - Not Defined 56.00 87.00 64.37% 83.81 % 100.00% Nov-17 ♦ Needs Improvement 33.00 40.00 82.50% 83.55% 100.00% Dec-17 ♦ Needs Improvement 49.00 83.00 59.04% 79.46% 100.00% Jan-18 - Not Defined 44.00 62.00 70.97% 78.25% 100.00% Feb-18 Close to Target 83.00 94.00 88.30% 79.50% 100.00% Mar-18 ♦ On Target 45.00 48.00 93.75% 81.09% 100.00% Apr-18 - Not Defined 68.00 73.00 93.15% 82.29% 100.00% May-18 - Not Defined 54.00 64.00 84.38% 82.48% 100.00% Jun-18 Close to Target 41.00 46.00 89.13% 83.04% 100.00% Jul-18 ♦ Needs Improvement 36.00 48.00 75.00% 75.00% 100.00% Aug-18 Close to Target 79.00 85.00 92.94% 83.97% 100.00% Sep-18 Close to Target 48.00 53.00 90.57% 86.17% 100.00% Oct-18 Close to Target 55.00 63.00 87.30% 86.45% 100.00% Nov-18 Close to Target 48.00 66.00 72.73% 83.71% 100.00% Dec-18 Close to Target 39.00 55.00 70.91% 81.57% 100.00% Jan-19 Close to Target 107.00 134.00 79.85% 81.33% 100.00% Feb-19 Close to Target 90.00 104.00 86.54% 81.98% 100.00% Mar-19 Close to Target 53.00 73.00 72.60% 80.94% 100.00% Apr-19 Close to Target 66.00 72.00 91.67% 82.01% 100.00% May-19 Close to Target 71.00 77.00 92.21% 82.94% 100.00% Jun-19 Close to Target 69.00 73.00 94.52% 83.90% 100.00% Jul-19 Close to Target 76.00 77.00 98.70% 98.70% 100.00% Aug-19 Close to Target 74.00 91.00 81.32% 90.01 % 100.00% Sep-19 Close to Target 80.00 91.00 87.91 % 89.31 % 100.00% Oct-19 Close to Target 57.00 62.00 91.94% 89.97% 100.00% Nov-19 Close to Target 63.00 76.00 82.89% 88.55% 100.00% Dec-19 Close to Target 86.00 99.00 86.87% 88.27% 100.00% Jan-20 Close to Target 73.00 87.00 83.91% 87.65% 100.00% Feb-20 Close to Target 72.00 76.00 94.74% 88.53% 100.00% Mar-20 Close to Target 15.00 16.00 93.75% 89.11% 100.00% Apr-20 Close to Target 69.00 77.00 89.61 % 89.16% 100.00% May-20 Close to Target 48.00 51.00 94.12% 89.61 % 100.00% Jun-20 Close to Target 40.00 43.00 93.02% 89.90% 100.00% Jul-20 ♦ On Target 68.00 73.00 93.15% 93.15% 90.00% Aug-20 ♦ On Target 41.00 42.00 97.62% 95.38% 90.00% Sep-20 ♦ On Target 26.00 34.00 76.47% 89.08% 90.00% Oct-20 ♦ On Target 39.00 42.00 92.86% 90.02% 90.00% Nov-20 ♦ On Target 44.00 47.00 93.62% 90.74% 90.00% City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 11:31:10 am, Page 2 Period - Status Monthly Denominator Monthly Actual Performance Dec-20 ♦ On Target 71.00 87.00 81.61 % Jan-21 ♦ On Target 66.00 72.00 91.67% Feb-21 ♦ On Target 42.00 46.00 91.30% Mar-21 ♦ On Target 102.00 104.00 98.08% Apr-21 ♦ On Target 69.00 70.00 98.57% May-21 ♦ On Target 69.00 71.00 97.18% Jun-21 ♦ On Target 86.00 87.00 98.85% Jul-21 ♦ On Target 63.00 66.00 95.45% Aug-21 ♦ On Target 92.00 94.00 97.87% Sep-21 ♦ On Target 62.00 62.00 100.00% Oct-21 ♦ On Target 72.00 74.00 97.30% Nov-21 ♦ On Target 72.00 77.00 93.51 % Dec-21 ♦ On Target 114.00 134.00 85.07% Jan-22 ♦ On Target 56.00 72.00 77.78% Feb-22 ♦ On Target 66.00 73.00 90.41 % Mar-22 ♦ On Target 74.00 76.00 97.37% Apr-22 ♦ On Target 46.00 46.00 100.00% May-22 - Not Defined Jun-22 - Not Defined FY 23 Target - Not Defined Total/YTD Target 89.22% 90.00% 89.57% 90.00% 89.79% 90.00% 90.71 % 90.00% 91.49% 90.00% 92.01 % 90.00% 92.58% 90.00% 95.45% 90.00% 96.66% 90.00% 97.78% 90.00% 97.66% 90.00% 96.83% 90.00% 94.87% 90.00% 92.43% 90.00% 92.17% 90.00% 92.75% 90.00% 93.48% 90.00% 93.48% 90.00% 93.48% 90.00% 90.00% Estimate 90.00% City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 11:31:10 am, Page 3 Linear feet of storm drainpipe flushed Public Works Owner Aft Trudy Boehm (Public Works) Methodology Workorders are created for any pipe flushing work that is completed by the stormwater maintenance crews (part of the Street Maintenance Division of Public Works). The Workorders are entered daily into Cityworks, an Asset Management System, and they contain labor, equipment, and material costs associated with the work, and also the amount of pipe feet completed. The pipe footage is extracted from the Workorders in Cityworks using Crystal Reports. Target Linear feet of storm drain pipe flushed 100,000.00 50,000.00 0.00 Qy Fy Q� F� Fy Qy ��� Q Total/YTD — Target 0 Estimate Measure Data Analysis Action/Improvement Plan Linear feet of storm drain pipe flushed (Monthly) 4,000.00 3,000.00 2,000.00 1,000.00 n nn ti° ti° ti° ti° ti^ ti'` ti^ ti^ ti'` ti° ti� titi Monthly Performance — Monthly Target Apr-22 Period Status Monthly Total/YTD Target Performance Jul-16 Not Defined 8,544.00 8,544.00 100,000.00 Aug-16 Not Defined 10,487.00 19,031.00 100,000.00 Sep-16 Not Defined 4,098.00 23,129.00 100,000.00 Oct-16 — Not Defined 7,482.00 30,611.00 100,000.00 City of Durham, NC Apr-22 Report Created in DataHub Estimate Monthly Monthly Target Target YTD 8,333 8,333 8,333 16,667 8,333 25,000 8,333 33,333 Generated 05/04/2022 11:32:07 am, Page 1 Period - Status Monthly Total/YTD Target Estimate Monthly Monthly Performance Target Target YTD Nov-16 - Not Defined 5,212.00 35,823.00 100,000.00 8,333 41,667 Dec-16 - Not Defined 2,905.00 38,728.00 100,000.00 8,333 50,000 Jan-17 - Not Defined 7,138.00 45,866.00 100,000.00 8,333 58,333 Feb-17 - Not Defined 8,634.00 54,500.00 100,000.00 8,333 66,667 Mar-17 - Not Defined 5,898.00 60,398.00 100,000.00 8,333 75,000 Apr-17 - Not Defined 5,544.00 65,942.00 100,000.00 8,333 83,333 May-17 - Not Defined 9,628.00 75,570.00 100,000.00 8,333 91,667 Jun-17 - Not Defined 6,301.00 81,871.00 100,000.00 8,333 100,000 Jul-17 - Not Defined 7,420.00 7,420.00 100,000.00 8,333 8,333 Aug-17 - Not Defined 8,257.00 15,677.00 100,000.00 8,333 16,667 Sep-17 - Not Defined 1,397.00 17,074.00 100,000.00 8,333 25,000 Oct-17 - Not Defined 1,336.00 18,410.00 100,000.00 8,333 33,333 Nov-17 - Not Defined 1,128.00 19,538.00 100,000.00 8,333 41,667 Dec-17 - Not Defined 636.00 20,174.00 100,000.00 8,333 50,000 Jan-18 - Not Defined 253.00 20,427.00 100,000.00 8,333 58,333 Feb-18 - Not Defined 2,021.00 22,448.00 100,000.00 8,333 66,667 Mar-18 - Not Defined 1,583.00 24,031.00 100,000.00 8,333 75,000 Apr-18 - Not Defined 1,428.00 25,459.00 100,000.00 8,333 83,333 May-18 - Not Defined 1,728.00 27,187.00 100,000.00 8,333 91,667 Jun-18 Close to Target 1,058.00 28,245.00 30,000.00 2,500 94,167 Jul-18 ♦ On Target 2,040.00 2,040.00 20,000.00 1,667 1,667 Aug-18 ♦ On Target 2,450.00 4,490.00 20,000.00 1,667 3,333 Sep-18 ♦ On Target 1,102.00 5,592.00 20,000.00 1,667 5,000 Oct-18 ♦ On Target 1,702.00 7,294.00 20,000.00 1,667 6,667 Nov-18 Close to Target 427.00 7,721.00 20,000.00 1,667 8,333 Dec-18 Close to Target 778.00 8,499.00 20,000.00 1,667 10,000 Jan-19 Close to Target 2,014.00 10,513.00 20,000.00 1,667 11,667 Feb-19 Close to Target 2,036.00 12,549.00 20,000.00 1,667 13,333 Mar-19 Close to Target 2,104.00 14,653.00 20,000.00 1,667 15,000 Apr-19 ♦ On Target 2,317.00 16,970.00 20,000.00 1,667 16,667 May-19 ♦ On Target 1,555.00 18,525.00 20,000.00 1,667 18,333 Jun-19 ♦ On Target 1,313.00 19,838.00 20,000.00 15,000.00 1,667 20,000 Jul-19 ♦ On Target 2,055.00 2,055.00 20,000.00 1,667 1,667 Aug-19 ♦ On Target 2,274.00 4,329.00 20,000.00 1,667 3,333 Sep-19 ♦ On Target 1,862.00 6,191.00 20,000.00 1,667 5,000 Oct-19 ♦ On Target 586.00 6,777.00 20,000.00 1,667 6,667 Nov-19 ♦ On Target 1,446.00 8,223.00 20,000.00 1,667 8,333 Dec-19 ♦ On Target 1,175.00 9,398.00 20,000.00 1,667 10,000 Jan-20 E Close to Target 1,739.00 11,137.00 20,000.00 1,667 11,667 Feb-20 E Close to Target 1,101.00 12,238.00 20,000.00 1,667 13,333 Mar-20 E Close to Target 2,138.00 14,376.00 20,000.00 1,667 15,000 Apr-20 E Close to Target 240.00 14,616.00 20,000.00 1,667 16,667 May-20 E Close to Target 1,493.00 16,109.00 20,000.00 1,667 18,333 Jun-20 E Close to Target 2,740.00 18,849.00 20,000.00 16,500.00 1,667 20,000 Jul-20 ♦ On Target 1,933.00 1,933.00 20,000.00 1,667 1,667 Aug-20 ♦ On Target 3,240.00 5,173.00 20,000.00 1,667 3,333 Sep-20 ♦ On Target 1,928.00 7,101.00 20,000.00 1,667 5,000 Oct-20 ♦ On Target 1,771.00 8,872.00 20,000.00 1,667 6,667 Nov-20 ♦ On Target 2,070.00 10,942.00 20,000.00 1,667 8,333 Dec-20 ♦ On Target 1,315.00 12,257.00 20,000.00 1,667 10,000 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 11:32:07 am, Page 2 Period - Status Monthly Total/YTD Target Estimate Monthly Monthly Performance Target Target YTD Jan-21 ♦ On Target 2,541.00 14,798.00 20,000.00 1,667 11,667 Feb-21 ♦ On Target 1,609.00 16,407.00 20,000.00 1,667 13,333 Mar-21 ♦ On Target 3,199.00 19,606.00 20,000.00 1,667 15,000 Apr-21 ♦ On Target 1,192.00 20,798.00 20,000.00 1,667 16,667 May-21 ♦ On Target 420.00 21,218.00 20,000.00 1,667 18,333 Jun-21 ♦ On Target 1,582.00 22,800.00 20,000.00 21,500.00 1,667 20,000 Jul-21 Close to Target 1,295.00 1,295.00 20,000.00 1,667 1,667 Aug-21 Close to Target 1,261.00 2,556.00 20,000.00 1,667 3,333 Sep-21 Close to Target 1,270.00 3,826.00 20,000.00 1,667 5,000 Oct-21 Close to Target 1,619.00 5,445.00 20,000.00 1,667 6,667 Nov-21 Close to Target 374.00 5,819.00 20,000.00 1,667 8,333 Dec-21 ♦ Needs Improvement 639.00 6,458.00 20,000.00 1,667 10,000 Jan-22 ♦ Needs Improvement 701.00 7,159.00 20,000.00 1,667 11,667 Feb-22 ♦ Needs Improvement 950.00 8,109.00 20,000.00 1,667 13,333 Mar-22 ♦ Needs Improvement 1,792.00 9,901.00 20,000.00 1,667 15,000 Apr-22 ♦ Needs Improvement 1,249.00 11,150.00 20,000.00 1,667 16,667 May-22 - Not Defined 11,150.00 20,000.00 1,667 18,333 Jun-22 - Not Defined 11,150.00 20,000.00 11,000.00 1,667 20,000 FY 23 Target - Not Defined City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 11:32:07 am, Page 3 Pollution Sources Controlled Public Works Owner 4 Jim Azarelo (Public Works) Methodology Each investigation is tracked in the Water Quality Investigations database, including a tag for investigation resolution. Count of pollution sources controlled from Investigations database, based on report of investigations initiated during the month. Target Annual: Pollution Sources Controlled 100 0 Total/YTD — Target Estimate Measure Data Period — Status Jul-16 — Not Defined Aug-16 — Not Defined Sep-16 — Not Defined Oct-16 ♦ On Target Nov-16 ♦ On Target Dec-16 — Not Defined Jan-17 — Not Defined Feb-17 ♦ On Target Mar-17 — Not Defined City of Durham, NC Apr-22 Report Analysis Action/Improvement Plan Pollution Sources Controlled (monthly) 20 10 Ill I ll�l �I �I o ^L ^5 ^'t� ^t. ^a N`' N'- N6 <\ NA .'.b Nib N9 ti� ti� ti^ o^ titi So" ;S O"QQ� dos ��c lac Pao mac, Monthly Actual Estimate Target Total/YTD Monthly Actual 120 23 23 120 45 22 120 57 12 120 65 8 120 84 19 120 106 22 120 118 12 120 131 13 120 147 16 Created in DataHub Generated 05/04/2022 11:32:59 am, Page 1 Period Status Estimate Target Total/YTD Monthly Actual Apr-17 T On Target 120 167 20 May-17 Not Defined 120 192 25 Jun-17 Not Defined 120 204 12 Jul-17 Not Defined 128 25 25 Aug-17 Not Defined 128 51 26 Sep-17 Not Defined 128 60 9 Oct-17 Not Defined 128 84 24 Nov-17 ♦ On Target 128 96 12 Dec-17 ♦ On Target 128 108 12 Jan-18 ♦ On Target 128 116 8 Feb-18 ♦ On Target 128 127 11 Mar-18 ♦ On Target 128 136 9 Apr-18 ♦ On Target 128 150 14 May-18 ♦ On Target 128 171 21 Jun-18 ♦ On Target 128 186 15 Jul-18 ♦ On Target 128 11 11 Aug-18 Not Defined 128 31 20 Sep-18 Not Defined 128 36 5 Oct-18 ♦ On Target 128 50 14 Nov-18 Not Defined 128 57 7 Dec-18 Not Defined 128 65 8 Jan-19 ♦ On Target 128 85 20 Feb-19 ♦ On Target 128 99 14 Mar-19 ♦ On Target 128 111 12 Apr-19 Not Defined 128 121 10 May-19 Not Defined 128 139 18 Jun-19 Complete 128 149 10 Jul-19 Not Defined 128 18 18 Aug-19 Not Defined 128 35 17 Sep-19 Not Defined 128 53 18 Oct-19 Not Defined 128 68 15 Nov-19 Not Defined 128 79 11 Dec-19 ♦ On Target 128 83 4 Jan-20 Not Defined 128 91 8 Feb-20 ♦ On Target 128 103 12 Mar-20 Not Defined 128 106 3 Apr-20 Not Defined 128 106 0 May-20 Close to Target 128 106 0 Jun-20 Close to Target 128 108 2 Jul-20 Not Defined 160 130 5 5 Aug-20 Not Defined 160 130 12 7 Sep-20 Not Defined 160 130 17 5 Oct-20 Not Defined 160 130 25 8 Nov-20 Not Defined 160 130 32 7 Dec-20 Not Defined 38 6 Jan-21 Not Defined 47 9 Feb-21 Not Defined 110 54 7 Mar-21 * On Target 85 85 64 10 Apr-21 Not Defined 85 85 73 9 May-21 Not Defined 82 85 82 9 Jun-21 ♦ On Target 85 93 11 City of Durham, INC Apr-22 Report Created in Data Hub Generated 05/04/2022 11:32:59 am, Page 2 Period — Status Jul-21 — Not Defined Aug-21 — Not Defined Sep-21 ♦ On Target Oct-21 — Not Defined Nov-21 — Not Defined Dec-21 ♦ On Target Jan-22 — Not Defined Feb-22 ♦ On Target Mar-22 — Not Defined Apr-22 — Not Defined May-22 — Not Defined Jun-22 — Not Defined FY 23 Target — Not Defined Estimate Target 8 85 7 85 6 85 8 85 12 85 14 85 13 85 9 85 18 95 Total/YTD Monthly Actual 8 15 21 29 41 55 68 77 95 95 95 95 8 7 6 8 12 14 13 9 18 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 11:32:59 am, Page 3 Linear feet of street ditching excavated Public Works Owner Aft Trudy Boehm (Public Works) Methodology Workorders are created for any ditching work that is completed by the stormwater maintenance crews (part of the Street Maintenance Division of Public Works). The Workorders are entered daily into Cityworks, an Asset Management System, and they contain labor, equipment, and material costs associated with the work, and also the amount of feet completed. The ditching footage is extracted from the Workorders in Cityworks using Crystal Reports. Target Linear feet of street ditching excavated 30,000.00 — 20,000.00 10, 000.00 0.00 ek� Total/YTD — Target 0 Estimate Measure Data Period Status Jul-16 — Not Defined Aug-16 Not Defined Sep-16 Not Defined Oct-16 Not Defined Nov-16 Not Defined City of Durham, NC Apr-22 Report Analysis Action/Improvement Plan Linear feet of street ditching excavated (Monthly) 4,000.00 3,000.00 2,000.00 1,000.00 0.00 ti� ti� ti� ti� ti^ ti^ ti^ ti� ti^ ti° ti� ti� No? S110 Monthly Performance — Monthly Target Apr-22 Monthly Total/YTD Target Performance 3,030.00 3,030.00 29,000.00 3,348.00 6,378.00 29,000.00 568.00 6,946.00 29,000.00 1,789.00 8,735.00 29,000.00 905.00 9,640.00 29,000.00 Created in DataHub Estimate Monthly Monthly Target Target YTD 2,417 2,417 2,417 4,833 2,417 7,250 2,417 9,667 2,417 12,083 Generated 05/04/2022 11:31:44 am, Page 1 Period - Status Monthly Total/YTD Target Estimate Monthly Monthly Performance Target Target YTD Dec-16 - Not Defined 575.00 10,215.00 29,000.00 2,417 14,500 Jan-17 - Not Defined 757.00 10,972.00 29,000.00 2,417 16,917 Feb-17 - Not Defined 1,835.00 12,807.00 29,000.00 2,417 19,333 Mar-17 - Not Defined 1,661.00 14,468.00 29,000.00 2,417 21,750 Apr-17 - Not Defined 986.00 15,454.00 29,000.00 2,417 24,167 May-17 - Not Defined 1,783.00 17,237.00 29,000.00 2,417 26,583 Jun-17 - Not Defined 1,717.00 18,954.00 29,000.00 2,417 29,000 Jul-17 - Not Defined 2,704.00 2,704.00 29,000.00 2,417 2,417 Aug-17 - Not Defined 2,662.00 5,366.00 29,000.00 2,417 4,833 Sep-17 - Not Defined 2,454.00 7,820.00 29,000.00 2,417 7,250 Oct-17 Not Defined 1,320.00 9,140.00 29,000.00 2,417 9,667 Nov-17 - Not Defined 355.00 9,495.00 29,000.00 2,417 12,083 Dec-17 - Not Defined 1,227.00 10,722.00 29,000.00 2,417 14,500 Jan-18 - Not Defined 578.00 11,300.00 29,000.00 2,417 16,917 Feb-18 - Not Defined 1,430.00 12,730.00 29,000.00 2,417 19,333 Mar-18 - Not Defined 2,738.00 15,468.00 29,000.00 2,417 21,750 Apr-18 - Not Defined 1,340.00 16,808.00 29,000.00 2,417 24,167 May-18 - Not Defined 1,219.00 18,027.00 29,000.00 2,417 26,583 Jun-18 ♦ Needs Improvement 1,927.00 19,954.00 29,000.00 2,417 29,000 Jul-18 ♦ Needs Improvement 1,101.00 1,101.00 20,000.00 1,667 1,667 Aug-18 ♦ Needs Improvement 1,147.00 2,248.00 20,000.00 1,667 3,333 Sep-18 ♦ On Target 2,142.00 4,390.00 20,000.00 1,667 5,000 Oct-18 ♦ On Target 1,705.00 6,095.00 20,000.00 1,667 6,667 Nov-18 Close to Target 1,340.00 7,435.00 20,000.00 1,667 8,333 Dec-18 Close to Target 232.00 7,667.00 20,000.00 1,667 10,000 Jan-19 ♦ Needs Improvement 430.00 8,097.00 20,000.00 1,667 11,667 Feb-19 ♦ Needs Improvement 1,069.00 9,166.00 20,000.00 1,667 13,333 Mar-19 ♦ Needs Improvement 703.00 9,869.00 20,000.00 1,667 15,000 Apr-19 ♦ Needs Improvement 834.00 10,703.00 20,000.00 1,667 16,667 May-19 ♦ Needs Improvement 462.00 11,165.00 20,000.00 1,667 18,333 Jun-19 ♦ Needs Improvement 649.00 11,814.00 20,000.00 12,000.00 1,667 20,000 Jul-19 ` Close to Target 1,347.00 1,347.00 20,000.00 1,667 1,667 Aug-19 Close to Target 1,563.00 2,910.00 20,000.00 1,667 3,333 Sep-19 Close to Target 1,783.00 4,693.00 20,000.00 1,667 5,000 Oct-19 Close to Target 1,675.00 6,368.00 20,000.00 1,667 6,667 Nov-19 Close to Target 380.00 6,748.00 20,000.00 1,667 8,333 Dec-19 Close to Target 1,097.00 7,845.00 20,000.00 1,667 10,000 Jan-20 Close to Target 2,210.00 10,055.00 20,000.00 1,667 11,667 Feb-20 ♦ Needs Improvement 629.00 10,684.00 20,000.00 1,667 13,333 Mar-20 ' Close to Target 2,321.00 13,005.00 20,000.00 1,667 15,000 Apr-20 ♦ Needs Improvement 60.00 13,065.00 20,000.00 1,667 16,667 May-20 ♦ Needs Improvement 755.00 13,820.00 20,000.00 1,667 18,333 Jun-20 ♦ Needs Improvement 1,652.00 15,472.00 20,000.00 14,000.00 1,667 20,000 Jul-20 ♦ On Target 1,872.00 1,872.00 20,000.00 1,667 1,667 Aug-20 ♦ On Target 1,940.00 3,812.00 20,000.00 1,667 3,333 Sep-20 ♦ On Target 1,894.00 5,706.00 20,000.00 1,667 5,000 Oct-20 ♦ On Target 2,090.00 7,796.00 20,000.00 1,667 6,667 Nov-20 ♦ On Target 1,758.00 9,554.00 20,000.00 1,667 8,333 Dec-20 ♦ On Target 2,006.00 11,560.00 20,000.00 1,667 10,000 Jan-21 ♦ On Target 1,107.00 12,667.00 20,000.00 1,667 11,667 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 11:31:44 am, Page 2 Period - Status Monthly Total/YTD Target Estimate Monthly Monthly Performance Target Target YTD Feb-21 ♦ On Target 2,467.00 15,134.00 20,000.00 1,667 13,333 Mar-21 ♦ On Target 2,037.00 17,171.00 20,000.00 1,667 15,000 Apr-21 ♦ On Target 2,191.00 19,362.00 20,000.00 1,667 16,667 May-21 ♦ On Target 809.00 20,171.00 20,000.00 1,667 18,333 Jun-21 ♦ On Target 3,568.00 23,739.00 20,000.00 1,667 20,000 Jul-21 Close to Target 981.00 981.00 20,000.00 1,667 1,667 Aug-21 ♦ On Target 2,079.00 3,060.00 20,000.00 1,667 3,333 Sep-21 ♦ On Target 1,907.00 4,967.00 20,000.00 1,667 5,000 Oct-21 ♦ On Target 2,168.00 7,135.00 20,000.00 1,667 6,667 Nov-21 ♦ On Target 1,509.00 8,644.00 20,000.00 1,667 8,333 Dec-21 ♦ On Target 2,911.00 11,555.00 20,000.00 1,667 10,000 Jan-22 ♦ On Target 1,381.00 12,936.00 20,000.00 1,667 11,667 Feb-22 ♦ On Target 1,432.00 14,368.00 20,000.00 1,667 13,333 Mar-22 ♦ On Target 2,229.00 16,597.00 20,000.00 1,667 15,000 Apr-22 ♦ On Target 1,224.00 17,821.00 20,000.00 1,667 16,667 May-22 - Not Defined 17,821.00 20,000.00 1,667 18,333 Jun-22 - Not Defined 17,821.00 20,000.00 20,000.00 1,667 20,000 FY 23 Target - Not Defined City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 11:31:44 am, Page 3 Avg # of Business days needed to issue violation letter/referral Public Works Owner Analysis Jim Azarelo (Public Works) Action/Improvement Plan Methodology REPORTS LAG A MONTH due to time necessary to process pay requisitions. Cost of sidewalk linear feet installed and paid for in a given month Target Avg # of Business days needed to issue violation letter/referral 15.00 10.00 5.00 0.00 F Monthly Actual - Target Estimate Measure Data Period Status Jul-16 Not Defined Aug-16 Not Defined Sep-16 Not Defined Oct-16 Not Defined Nov-16 Not Defined Dec-16 Not Defined Jan-17 Not Defined Feb-17 Not Defined Mar-17 Not Defined City of Durham, INC Apr-22 Report Denominator Monthly Actual 19.00 27.00 9.00 22.00 2.00 4.00 6.00 11.00 7.00 21.00 6.00 10.00 7.00 7.00 5.00 15.00 10.00 12.00 Created in Data Hub Target Monthly Performance 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 Apr-22 Estimate Total/YTD Generated 05/04/2022 11:33:24 am, Page 1 Period Status Denominator Monthly Target Monthly Estimate Total/YTD Actual Performance Apr-17 Not Defined 11.00 25.00 4.00 May-17 Not Defined 14.00 30.00 4.00 Jun-17 Not Defined 11.00 12.00 4.00 Jul-17 Not Defined 1.00 0.00 4.00 Aug-17 Not Defined 4.00 3.30 4.00 Sep-17 Not Defined 2.00 5.00 4.00 Oct-17 Not Defined 10.00 0.90 4.00 Nov-17 Not Defined 2.00 2.00 4.00 Dec-17 Not Defined 5.00 1.00 4.00 Jan-18 Not Defined 2.00 2.00 4.00 Feb-18 Not Defined 2.00 0.00 4.00 Mar-18 Not Defined 6.00 0.60 4.00 Apr-18 Not Defined 8.00 0.83 4.00 May-18 Not Defined 7.00 0.40 4.00 Jun-18 ♦ On Target 1.00 4.00 Jul-18 ♦ On Target 1.00 4.00 Aug-18 Not Defined 0.00 4.00 Sep-18 Not Defined 3.00 4.00 Oct-18 ♦ On Target 2.50 4.00 Nov-18 Not Defined 3.00 4.00 Dec-18 Not Defined 0.00 4.00 Jan-19 ♦ On Target 0.67 4.00 Feb-19 Not Defined 0.00 4.00 Mar-19 Not Defined 1.67 4.00 Apr-19 ♦ On Target 2.50 4.00 May-19 Not Defined 1.75 4.00 Jun-19 ♦ On Target 1.20 4.00 Jul-19 Not Defined 3.00 4.00 Aug-19 Not Defined 2.00 4.00 Sep-19 Not Defined 0.00 4.00 Oct-19 Not Defined 0.00 4.00 Nov-19 Not Defined 0.00 4.00 Dec-19 * On Target 0.00 4.00 Jan-20 Not Defined 2.00 4.00 Feb-20 Not Defined 0.00 4.00 Mar-20 Not Defined 2.50 4.00 Apr-20 Not Defined 0.00 4.00 May-20 Not Defined 3.00 4.00 Jun-20 ♦ On Target 0.00 4.00 Jul-20 Not Defined 6.00 5.00 Aug-20 Not Defined 0.00 5.00 Sep-20 Not Defined 0.50 5.00 Oct-20 Not Defined 4.00 5.00 Nov-20 Not Defined 0.00 5.00 Dec-20 Not Defined 0.00 5.00 Jan-21 Not Defined 0.00 5.00 Feb-21 Not Defined 0.00 5.00 Mar-21 ♦ On Target 0.00 5.00 Apr-21 Not Defined 0.00 5.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 5.00 3.60 3.60 City of Durham, INC Apr-22 Report Created in Data Hub Generated 05/04/2022 11:33:24 am, Page 2 Period Status Denominator Monthly Target Actual May-21 Not Defined 0.00 5.00 Jun-21 ♦ On Target 0.00 5.00 Jul-21 Not Defined 0.00 5.00 Aug-21 Not Defined 4.00 5.00 Sep-21 ♦ On Target 0.00 5.00 Oct-21 Not Defined 0.00 5.00 Nov-21 Not Defined 4.00 5.00 Dec-21 ♦ On Target 0.00 5.00 Jan-22 Not Defined 0.00 5.00 Feb-22 Not Defined 0.00 5.00 Mar-22 Not Defined 0.00 5.00 Apr-22 Not Defined May-22 Not Defined Jun-22 Not Defined FY 23 Target Not Defined Monthly Estimate Performance 3.60 3.60 3.00 3.00 3.00 3.00 4.00 4.00 4.00 4.00 4.00 Total/YTD City of Durham, INC Apr-22 Report Created in Data Hub Generated 05/04/2022 11:33:24 am, Page 3 Industrial stormwater inspections & follow up Public Works Owner Jim Azarelo (Public Works) Methodology Count of initial and follow-up inspections of private and municipal industrial sites and target priority businesses produced as a monthly report from the inspections database Target Annual: Industrial stormwater inspections & follow up 300.00 200.00 100.00 0.00 fl 11 ti Q Total/YTD - Target Estimate Measure Data Period Status Jul-16 Not Defined Aug-16 Not Defined Sep-16 Not Defined Oct-16 Not Defined Nov-16 Not Defined Dec-16 Not Defined Jan-17 Not Defined Feb-17 Not Defined Mar-17 Not Defined City of Durham, INC Apr-22 Report Analysis Action/Improvement Plan Industrial stormwater inspections & follow up 30.00 20.00 10.00 Apr-22 N ^ N ^ N ^ ti ti I , Monthly Actual Monthly Total/YTD Target Estimate Denominator Monthly Actual Performance 18.00 18.00 190.00 21.00 39.00 190.00 28.00 67.00 190.00 15.00 82.00 190.00 26.00 108.00 190.00 29.00 137.00 190.00 18.00 155.00 190.00 24.00 179.00 190.00 30.00 209.00 190.00 Created in Data Hub Generated 05/04/2022 11:33:52 am, Page 1 Period Status Monthly Total/YTD Target Estimate Denominator Monthly Actual Performance Apr-17 Not Defined 17.00 226.00 190.00 May-17 Not Defined 31.00 257.00 190.00 Jun-17 Not Defined 25.00 282.00 190.00 Jul-17 Not Defined 4.00 4.00 190.00 Aug-17 Not Defined 22.00 26.00 190.00 Sep-17 Not Defined 27.00 53.00 190.00 Oct-17 Not Defined 11.00 64.00 190.00 Nov-17 Not Defined 12.00 76.00 190.00 Dec-17 Not Defined 8.00 84.00 190.00 Jan-18 Not Defined 20.00 104.00 190.00 Feb-18 Not Defined 14.00 118.00 190.00 Mar-18 Not Defined 24.00 142.00 190.00 Apr-18 Not Defined 10.00 152.00 190.00 May-18 Not Defined 28.00 180.00 190.00 Jun-18 ♦ On Target 9.00 189.00 190.00 Jul-18 41L On Target 18.00 18.00 190.00 Aug-18 Not Defined 22.00 40.00 190.00 Sep-18 Not Defined 12.00 52.00 190.00 Oct-18 ♦ On Target 20.00 72.00 190.00 Nov-18 Not Defined 23.00 95.00 190.00 Dec-18 Not Defined 12.00 107.00 190.00 Jan-19 ♦ On Target 21.00 128.00 190.00 Feb-19 Not Defined 28.00 156.00 190.00 Mar-19 Not Defined 33.00 189.00 190.00 Apr-19 ♦ On Target 16.00 205.00 190.00 May-19 Not Defined 28.00 233.00 190.00 Jun-19 Complete 6.00 239.00 190.00 240.00 Jul-19 Not Defined 18.00 18.00 190.00 Aug-19 Not Defined 10.00 28.00 190.00 Sep-19 Not Defined 12.00 40.00 190.00 Oct-19 Not Defined 10.00 50.00 190.00 Nov-19 Not Defined 11.00 61.00 190.00 Dec-19 On Target 9.00 70.00 190.00 Jan-20 Not Defined 14.00 84.00 190.00 Feb-20 Not Defined 13.00 97.00 190.00 Mar-20 Not Defined 2.00 99.00 190.00 Apr-20 Not Defined 0.00 99.00 190.00 May-20 Not Defined 0.00 99.00 190.00 103.00 Jun-20 ♦ Needs Improvement 1.00 100.00 Jul-20 Not Defined 0.00 0.00 80.00 Aug-20 Not Defined 10.00 10.00 80.00 Sep-20 Not Defined 9.00 19.00 Oct-20 Not Defined 4.00 23.00 Nov-20 Not Defined 5.00 28.00 Dec-20 Not Defined 7.00 35.00 Jan-21 Not Defined 12.00 47.00 Feb-21 ♦ On Target 19.00 66.00 Mar-21 ♦ On Target 13.00 79.00 100.00 103.00 Apr-21 Not Defined 10.00 89.00 100.00 102.00 May-21 Not Defined 18.00 107.00 100.00 115.00 City of Durham, INC Apr-22 Report Created in Data Hub Generated 05/04/2022 11:33:52 am, Page 2 Period Status Monthly Total/YTD Target Estimate Denominator Monthly Actual Performance Jun-21 ♦ On Target 6.00 113.00 100.00 114.00 Jul-21 Not Defined 11.00 11.00 11.00 10.00 Aug-21 Not Defined 15.00 26.00 26.00 10.00 Sep-21 ♦ On Target 18.00 44.00 44.00 10.00 Oct-21 Not Defined 16.00 60.00 60.00 15.00 Nov-21 Not Defined 7.00 67.00 67.00 7.00 Dec-21 ♦ On Target 16.00 83.00 83.00 16.00 Jan-22 Not Defined 10.00 93.00 93.00 10.00 Feb-22 Not Defined 23.00 116.00 116.00 23.00 Mar-22 Not Defined 23.00 139.00 139.00 23.00 Apr-22 Not Defined 139.00 May-22 Not Defined 139.00 Jun-22 Not Defined 139.00 155.00 FY 23 Target Not Defined City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 11:33:52 am, Page 3 Violations Notices issued Stormwater Public Works Owner Jim Azarelo (Public Works) Methodology The total ticket count is printed out by 811 who submits the tickets to Durham. Target Violations Notices issued Stormwater 4.00 3.00 2.00 1.00 I I I I II I 0.00 — ��� Measure Data ti^ ti^ tiN ti^ titi ti� Monthly Actual Period Status Jul-16 Not Defined Aug-16 Not Defined Sep-16 Not Defined Oct-16 Not Defined Nov-16 Not Defined Dec-16 Not Defined Jan-17 Not Defined Feb-17 Not Defined Mar-17 Not Defined Apr-17 Not Defined Analysis Action/Improvement Plan Monthly Monthly Denominator Estimate Actual Performance 25.00 16.00 13.00 11.00 12.00 13.00 12.00 9.00 19.00 17.00 City of Durham, INC Apr-22 Report Created in Data Hub Apr-22 Target Total/YTD 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 Generated 05/04/2022 11:35:36 am, Page 1 Period Status Monthly Monthly Denominator Estimate Target Total/YTD Actual Performance May-17 Not Defined 15.00 Jun-17 Not Defined 23.00 Jul-17 Not Defined 7.00 Aug-17 Not Defined 14.00 Sep-17 Not Defined 6.00 Oct-17 Not Defined 29.00 Nov-17 Not Defined 5.00 Dec-17 Not Defined 11.00 Jan-18 Not Defined 5.00 Feb-18 Not Defined 11.00 Mar-18 Not Defined 21.00 Apr-18 Not Defined 26.00 May-18 Not Defined 13.00 Jun-18 ♦ On Target 14.00 Jul-18 On Target 16.00 Aug-18 Not Defined 21.00 Sep-18 Not Defined 12.00 Oct-18 ♦ On Target 12.00 Nov-18 Not Defined 13.00 Dec-18 Not Defined 5.00 Jan-19 ♦ On Target 15.00 Feb-19 Not Defined 9.00 Mar-19 Not Defined 12.00 Apr-19 ♦ On Target 13.00 May-19 Not Defined 16.00 Jun-19 ♦ On Target 11.00 Jul-19 Not Defined 11.00 Aug-19 Not Defined 9.00 Sep-19 Not Defined 10.00 Oct-19 Not Defined 7.00 Nov-19 Not Defined 2.00 Dec-19 ♦ On Target 3.00 Jan-20 Not Defined 14.00 Feb-20 Not Defined 4.00 Mar-20 Not Defined 2.00 Apr-20 Not Defined 0.00 May-20 Not Defined 1.00 Jun-20 Close to Target 2.00 Jul-20 Not Defined 1.00 Aug-20 Not Defined 0.00 Sep-20 Not Defined 4.00 Oct-20 Not Defined 3.00 Nov-20 Not Defined 1.00 Dec-20 Not Defined 0.00 Jan-21 Not Defined 1.00 Feb-21 Not Defined 0.00 Mar-21 ♦ On Target 0.00 Apr-21 Not Defined 0.00 May-21 Not Defined 3.00 Jun-21 ♦ On Target 0.00 150.00 12.00 12.00 14.00 13.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 84.00 12.00 12.00 14.00 13.00 1.00 1.00 5.00 8.00 9.00 9.00 10.00 10.00 10.00 City of Durham, INC Apr-22 Report Created in Data Hub Generated 05/04/2022 11:35:36 am, Page 2 Period - Status Jul-21 - Not Defined Aug-21 - Not Defined Sep-21 ♦ On Target Oct-21 - Not Defined Nov-21 - Not Defined Dec-21 ♦ On Target Jan-22 - Not Defined Feb-22 - Not Defined Mar-22 - Not Defined Apr-22 - Not Defined May-22 - Not Defined Jun-22 - Not Defined FY 23 Target - Not Defined Monthly Monthly Denominator Estimate Actual Performance 0.00 0.00 1.00 1.00 1.00 1.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 2.00 2.00 0.00 0.00 Target Total/YTD 0.00 0.00 1.00 1.00 1.00 2.00 0.00 2.00 0.00 2.00 0.00 2.00 0.00 2.00 2.00 4.00 0.00 4.00 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 11:35:36 am, Page 3 # of New water quality investigations Public Works Owner 4 Jim Azarelo (Public Works) Methodology REPORTS LAG A MONTH due to time necessary to process pay requisitions. Linear feet of sidewalk installed and paid for in a given month Target # of New water quality investigations 400.00 300.00 200.00 100.00 0.00 ti Q Total/YTD - Target Estimate Measure Data Period - Status Jul-16 - Not Defined Aug-16 - Not Defined Sep-16 - Not Defined Oct-16 - Not Defined Nov-16 - Not Defined Dec-16 - Not Defined Jan-17 - Not Defined Feb-17 - Not Defined Mar-17 - Not Defined City of Durham, NC Apr-22 Report Analysis Action/Improvement Plan Denominator Monthly Target Estimate Monthly Total/YTD Actual Performance 34.00 250.00 34.00 40.00 250.00 74.00 12.00 250.00 86.00 31.00 250.00 117.00 28.00 250.00 145.00 37.00 250.00 182.00 24.00 250.00 206.00 31.00 250.00 237.00 30.00 250.00 267.00 Created in DataHub Generated 05/04/2022 11:36:03 am, Page 1 Period - Status Denominator Monthly Target Estimate Monthly Total/YTD Actual Performance Apr-17 - Not Defined 35.00 250.00 302.00 May-17 - Not Defined 34.00 250.00 336.00 Jun-17 - Not Defined 30.00 250.00 366.00 Jul-17 - Not Defined 37.00 250.00 37.00 Aug-17 - Not Defined 35.00 250.00 72.00 Sep-17 - Not Defined 27.00 250.00 99.00 Oct-17 - Not Defined 35.00 250.00 134.00 Nov-17 - Not Defined 26.00 250.00 160.00 Dec-17 - Not Defined 22.00 250.00 182.00 Jan-18 - Not Defined 14.00 250.00 196.00 Feb-18 - Not Defined 21.00 250.00 217.00 Mar-18 - Not Defined 35.00 250.00 252.00 Apr-18 - Not Defined 48.00 250.00 300.00 May-18 - Not Defined 37.00 250.00 337.00 Jun-18 ♦ On Target 30.00 250.00 367.00 Jul-18 ♦ On Target 23.00 250.00 23.00 Aug-18 - Not Defined 39.00 250.00 62.00 Sep-18 - Not Defined 15.00 250.00 77.00 Oct-18 ♦ On Target 35.00 250.00 112.00 Nov-18 - Not Defined 30.00 250.00 142.00 Dec-18 - Not Defined 14.00 250.00 156.00 Jan-19 ♦ On Target 35.00 250.00 191.00 Feb-19 - Not Defined 27.00 250.00 218.00 Mar-19 - Not Defined 37.00 250.00 255.00 Apr-19 ♦ On Target 26.00 250.00 281.00 May-19 - Not Defined 36.00 250.00 317.00 Jun-19 ♦ On Target 18.00 250.00 345.00 335.00 Jul-19 - Not Defined 25.00 250.00 25.00 Aug-19 - Not Defined 26.00 250.00 51.00 Sep-19 - Not Defined 26.00 250.00 77.00 Oct-19 - Not Defined 24.00 250.00 101.00 Nov-19 - Not Defined 15.00 250.00 116.00 Dec-19 ♦ On Target 16.00 250.00 132.00 Jan-20 - Not Defined 23.00 250.00 155.00 Feb-20 - Not Defined 27.00 250.00 182.00 Mar-20 - Not Defined 6.00 250.00 188.00 Apr-20 - Not Defined 2.00 250.00 190.00 May-20 - Not Defined 12.00 250.00 225.00 202.00 Jun-20 Close to Target 8.00 250.00 225.00 210.00 Jul-20 - Not Defined 14.00 250.00 14.00 Aug-20 - Not Defined 13.00 250.00 225.00 27.00 Sep-20 - Not Defined 16.00 43.00 Oct-20 - Not Defined 20.00 63.00 Nov-20 - Not Defined 16.00 250.00 225.00 79.00 Dec-20 - Not Defined 20.00 99.00 Jan-21 - Not Defined 12.00 111.00 Feb-21 - Not Defined 20.00 131.00 Mar-21 ♦ On Target 26.00 210.00 209.00 157.00 Apr-21 - Not Defined 20.00 177.00 May-21 - Not Defined 19.00 212.00 212.00 196.00 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 11:36:03 am, Page 2 Period - Status Jun-21 ♦ On Target Jul-21 - Not Defined Aug-21 - Not Defined Sep-21 ♦ On Target Oct-21 - Not Defined Nov-21 - Not Defined Dec-21 ♦ On Target Jan-22 - Not Defined Feb-22 - Not Defined Mar-22 - Not Defined Apr-22 - Not Defined May-22 - Not Defined Jun-22 - Not Defined FY 23 Target - Not Defined Denominator Monthly Target Estimate Monthly Total/YTD Actual Performance 16.00 212.00 212.00 212.00 17.00 17.00 17.00 17.00 18.00 18.00 35.00 10.00 10.00 10.00 45.00 16.00 16.00 16.00 61.00 21.00 21.00 21.00 82.00 30.00 30.00 30.00 112.00 24.00 24.00 24.00 136.00 18.00 18.00 18.00 154.00 32.00 32.00 32.00 186.00 186.00 186.00 186.00 City of Durham, NC Apr-22 Report Created in DataHub Generated 05/04/2022 11:36:03 am, Page 3