Page 197 - City of Bedford FY21 Budget

Fund: General
Department: Administrative Services
Division: Finance

PERFORMANCE MEASURES

ACTUAL TARGET PROJECTED TARGET
Indicator
18/19 19/20 19/20 20/21
INPUTS
# of Manual Journal Entries 1,144 1,025 1,100 1,100
# of Purchase Card Users 195 203 203 203
# of A/P Invoices 3,419 3,300 3,300 3,350
# of Checks 2,944 2,800 2,850 2,900
# of Purchase Card Transactions 10,156 10,000 10,580 10,600
# of Total A/P Transactions 13,100 13,000 13,460 13,600
# of FTE's 5.5 5.5 5.5 5.5
OUTPUTS
Total Interest Earnings 3,194,252 2,000,000 2,500,000 2,000,000
Average % of Portfolio Yield 2.48% 2.00% 1.75% 1.60%
Total Outstanding Debt (thousands) 137,720 131,335 140,315 133,260
A/P Purchase Cards in Dollar Volume 2,903,696 3,000,000 3,000,000 3,500,000
Overall City Purchases in Dollar Volume 34,090,108 36,000,000 34,000,000 34,500,000
EFFICIENCY
# of Days to Reconcile City Bank Accounts 15 15 15 15
% of City Funds Invested 98.60% 98.20% 98.70% 98.50%
% of Property Taxes Collected 99.67% 99.50% 99.50% 99.60%
Average A/P Transaction Value $11,488 $8,150 $11,300 $11,500
Average Purchase Card Transaction Value $286 $275 $280 $285
Division Budget as a % of General Fund 1.87% 1.88% 1.82% 2.35%
EFFECTIVENESS & OUTCOMES
Received Unmodified Audit Opinion Yes Yes Yes Yes
Received GFOA Certificate of Achievement Award Yes Yes Yes Yes
CAFR submitted to City Council by February Yes Yes Yes Yes
Bond Rating on General Obligation Bonds AA AA AA AA
% of Purchase Card Usage vs. Total City Purchases 8.55% 15.00% 15.00% 15.00%
% of Payroll that is electronic vs. Paper 99.76% 99.96% 99.9% 99.9%
Rebate amount for the Purchase Card Program $45,696 $50,000 $45,800 $46,000

168