SCORECARD: 6-month Rolling Status (ACM Report)FMS-Financial Mgmt Services |
| Divisions | Service Areas | Measure ID | Measures | Reporting Frequency | Series Name | Series Status | Analysis | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Apr-21 | May-21 | Jun-21 | Jul-21 | Aug-21 | Sep-21 | |||||||
| 1. Operational & Transactional
| 545543
| Monthly-FY
| % of fund reviews completed on time
| 100.00%
| 100.00%
| 100.00%
| 100.00%
| 100.00%
| | |
||
| Total fund reviews completed on time
| 141.00
| 141.00
| 141.00
| 141.00
| 141.00
| |
||||||
| Total fund reviews
| 141.00
| 141.00
| 141.00
| 141.00
| 141.00
| |
||||||
| 683780
| Monthly-FY
| % of M&C entries completed on time
| 92.31%
| 100.00%
| 100.00%
| 100.00%
| 100.00%
| 100.00%
| |
|||
| # of M&C entries completed on time
| 12.00
| 8.00
| 35.00
| 0.00
| 23.00
| 14.00
|
||||||
| Total # of M&C Entries
| 13.00
| 8.00
| 35.00
| 0.00
| 23.00
| 14.00
|
||||||
| 545546
| Monthly-FY
| % approved/denied/posted on time
| 93.93%
| 97.24%
| 94.05%
| 95.15%
| 89.41%
| | |
|||
| # approved/denied/posted in 3 days
| 480.00
| 529.00
| 617.00
| 608.00
| 515.00
| |
||||||
| total # journals submitted
| 511.00
| 544.00
| 656.00
| 639.00
| 576.00
| |
||||||
| 714290
| Monthly-FY
| Active Return
| 0.19%
| 0.19%
| 0.17%
| 0.13%
| 0.14%
| 0.17%
| |
|||
| City Yield
| 0.35%
| 0.33%
| 0.42%
| 0.32%
| 0.34%
| 0.45%
|
||||||
| Portfolio Book
| $ 883,262,824.49
| $ 858,687,925.45
| $ 858,651,153.89
| $ 858,534,931.64
| $ 858,414,787.15
| $ 873,067,545.05
|
||||||
| Monthly $ Impact
| $ 137,273.76
| $ 137,390.07
| $ 121,642.25
| $ 94,081.12
| $ 100,148.39
| $ 121,138.12
|
||||||
| 714476
| Monthly-FY
| % of invoices paid within 30 days
| 84.48%
| 81.88%
| 80.89%
| 82.56%
| 79.85%
| 73.04%
| |
|||
| # of invoices paid within 30 days
| 5,013.00
| 4,920.00
| 5,188.00
| 5,155.00
| 4,196.00
| 5,608.00
|
||||||
| Total # of invoices
| 5,934.00
| 6,009.00
| 6,414.00
| 6,244.00
| 5,255.00
| 7,678.00
|
||||||
| 714540
| Monthly-FY
| % of receivables current
| 26.64%
| 23.94%
| 14.94%
| 9.91%
| 11.92%
| 0.61%
| |
|||
| $ value of invoices not yet due
| $ 1,739,859.43
| $ 1,343,689.81
| $ 830,110.29
| $ 562,941.12
| $ 669,669.71
| $ 34,389.42
|
||||||
| Total $ value of recievables
| $ 6,532,093.16
| $ 5,613,270.76
| $ 5,555,398.33
| $ 5,682,389.45
| $ 5,616,707.57
| $ 5,628,941.94
|
||||||
| 714395
| Monthly-FY
| % of reimbursements processed within 15 days
| | | | | | | |
|||
| # of reimbursements processed on time
| | | | | | |
||||||
| # of reimbursements processed
| | | | | | |
||||||
| 714378
| Monthly-FY
| Average # of days to close helpdesk tickets
| | | | | | | |
|||
| # of days open
| | | | | | |
||||||
| # of helpdesk tickets
| | | | | | |
||||||
| 779405
| Quarterly-FY
| Bids Awarded
| | | 29.00
| | | 68.00
| |
|||
| Overall Target
| | | 100.00
| | | 100.00
|
||||||
| High Variance (FY Target)
| | | 85.00
| | | 85.00
|
||||||
| Low Variance
| | | 80.00
| | | 80.00
|
||||||
| 779406
| Monthly-FY
| Completed Peoplesoft contracts within 3 days
| 6.61
| 5.88
| 7.58
| 6.30
| 10.30
| 5.00
| |
|||
| Overall Target
| | | | | | |
||||||
| High Variance (FY Target)
| 3.00
| 3.00
| 3.00
| 3.00
| 3.00
| 3.00
|
||||||
| Low Variance
| 5.00
| 5.00
| 5.00
| 5.00
| 5.00
| 5.00
|
||||||
| 779407
| Monthly-FY
| % of expedited requests
| 14.00%
| 0%
| 44.00%
| 0%
| 17.00%
| 26.00%
| |
|||
| Overall Target
| 100.00
| 100.00
| 100.00
| 100.00
| 100.00
| 100.00
|
||||||
| High Variance (FY Target)
| 30.00
| 30.00
| 30.00
| 30.00
| 30.00
| 30.00
|
||||||
| Low Variance
| 50.00
| 50.00
| 50.00
| 50.00
| 50.00
| 50.00
|
||||||
| 779410
| Monthly-FY
| % Peoplesoft contracts renewed
| 92.00%
| 84.00%
| | | | | |
|||
| Overall Target
| 100.00
| 100.00
| 100.00
| 100.00
| 100.00
| 100.00
|
||||||
| High Variance (FY Target)
| 85.00
| 85.00
| 85.00
| 85.00
| 85.00
| 85.00
|
||||||
| Low Variance
| 80.00
| 80.00
| 80.00
| 80.00
| 80.00
| 80.00
|
||||||
| 779408
| Monthly-FY
| Bidder and user requests reviewed in 5 days
| 2.50
| 2.00
| 2.50
| 2.00
| 2.00
| 2.50
| |
|||
| Overall Target
| | | | | | |
||||||
| High Variance (FY Target)
| 3.00
| 3.00
| 3.00
| 3.00
| 3.00
| 3.00
|
||||||
| Low Variance
| 5.00
| 5.00
| 5.00
| 5.00
| 5.00
| 5.00
|
||||||
| 779409
| Monthly-FY
| Completed assignments of contracts and name change
| 7.00
| 4.30
| 10.50
| 3.50
| 3.70
| 3.00
| |
|||
| Overall Target
| 30.00
| 30.00
| 30.00
| 30.00
| 30.00
| 30.00
|
||||||
| High Variance (FY Target)
| 50.00
| 50.00
| 50.00
| 50.00
| 50.00
| 50.00
|
||||||
| Low Variance
| 60.00
| 60.00
| 60.00
| 60.00
| 60.00
| 60.00
|
||||||
| 2. Regulatory/Reporting
| 714426
| Annual-FY
| Number of external audit findings
| | | | | | | |
||
| 714444
| Annual-FY
| External audit findings (component unit/other)
| | | | | | | |
|||
| 714473
| Annual-FY
| # of days to produce the CAFR
| | | | | | | |
|||
| 714474
| Annual-FY
| % of funds in compliance
| | | | | | | |
|||
| # of funds in reserve compliance
| | | | | | |
||||||
| # of funds
| | | | | | |
||||||
| 714475
| Annual-FY
| Actual
| | | | | | | |
|||
| 714548
| Annual-FY
| Moody's
| | | | | | | |
|||
| S&P
| | | | | | |
||||||
| Fitch
| | | | | | |
||||||
| Kroll
| | | | | | |
||||||
| 714549
| Annual-FY
| Moody's
| | | | | | | |
|||
| Fitch
| | | | | | |
||||||
| S&P
| | | | | | |
||||||
| Kroll
| | | | | | |
||||||
| 714550
| Annual-FY
| Standard & Poor's
| | | | | | | |
|||
| Fitch
| | | | | | |
||||||
| 714551
| Annual-FY
| Moody's
| | | | | | | |
|||
| Standard & Poor's
| | | | | | |
||||||
| Fitch
| | | | | | |
||||||
