Overview

Instructions
Data Input
Dashboard


Sheet 1: Instructions

INSTRUCTIONS FOR THE PERFORMANCE DASHBOARD





To complete this Performance Dashboard, you will need to fill in the yellow highlighted portions on



the “Data Input” tab. The data on the “Data Input” tab will then fill the “Dashboard” tab.









1. On the “Data Input” tab, enter your Local Unit Name and Local Unit Code in rows 3 and 4.







2. On the “Data Input” tab, fill in the yellow highlighted portions with your local unit’s information.



The Comments column includes information to assist with completing each metric.







3. If a metric does not apply, you can:




a. On the “Data Input” tab, change the metric



b. On the “Dashboard” tab, indicate N/A in columns B, C, D, and E



c. On the “Dashboard” tab, “Delete” or “Hide” the metric row






4. On the “Dashboard” tab, the Percentage Threshold may be adjusted from the 1% default



by changing the percentage in column F (red cell).







5. On the “Dashboard” tab, the Performance Indicator may be adjusted from the default by



changing the indicator in column F.




a. To change the Performance Indicator, select the cell, click the drop down arrow,




and change the selection.





Before publishing the Performance Dashboard on your website, we highly recommend



you "Hide" the "Instructions" tab and the "Data Input" tab so that this document will be



user-friendly. To hide a tab (or row), right click on the tab (or row) and select "Hide".








Make sure when you print or save this document to a PDF, you print the "Dashboard" tab.




Sheet 2: Data Input

DATA INPUT PAGE FOR PERFORMANCE DASHBOARD




Local Unit Name: Village of Colon
Local Unit Code: 753030
We suggest you "Hide" this tab before publishing the Excel file to your web site.







Metric 2013-14 2014-15
Population 1,154 1,154



Annual All Governmental Fund expenditures per capita

General Fund Expenditures 723,367 737,387
Expenditures per capita 627 639
Fund Balance as % of annual All Governmental expenditures

Fund Balance All Governmental 522,319 524,439
Fund Balance as % of Annual GF Expenditures 72.2% 71.1%
Unfunded pension & OPEB liability, as a % of annual General Fund revenue

Pension funding:

Actuarial value of assets

Actuarial accrued liability

Overfunded (Unfunded) - -
OPEB funding:

Actuarial value of assets

Actuarial accrued liability

Overfunded (Unfunded) - -
Combined overfunding (underfunding) - -
All Governmental Fund revenue 705,979 739,507
Unfunded OPEB liability as a % of annual GF revenue 0% 0%
Debt burden per capita

Total direct debt, from the FS:

Bonds, notes & contracts payable

Capital leases 20,000 20,000
Total direct debt 20,000 20,000
Debt burden per capita 17 17
Percentage of road funding provided by the General Fund

Road expenditures:

Major streets fund 88,711 70,466
Local streets fund 104,964 80,139
Municipal streets fund

Total road expenditures 193,675 150,605
Transfers from the General Fund into:

Major streets fund

Local streets fund 11,000
Municipal streets fund

Total General Fund funding 11,000 -
Ratio of road funding to total GF expenditures 5.7% 0.0%
Ratio of pensioners to employees

Number of retirees participating in the Defined Benefit pension systems - -
Number of current active employees 13 15
Ratio - -
Number of services delivered via cooperative venture

List the individual services delivered via cooperative venture: (place an "X" in each year the services were delivered cooperatively)
Library

Dispatch X X
Building inspections

Recreation

Finance dept. consolidation

Assessing X X
Fire X X
Police

Other:




Totals 3 3
Economic Strength

% of community with access to high speed broadband

Number of homes 650 650
Number of homes with access to highspeed internet 643 643
% of homes with access to highspeed internet 98.9% 98.9%



% of community age 25+ with Bachelor's degree or higher

Population aged 25 and over 769 769
Number with Bachelor's degree or higher 158 158
% of community age 25+ with bachelor's degree or higher 20.5% 20.5%



Average age of critical infrastructure (years)

Water lines

Historical cost 4,514,755 4,478,505
Accumulated depreciation 1,887,745 2,044,072
Average depreciable life (in years) 21 21
Average age 9 10
component of the weighted average 4.65 5.06
Sewer lines

Historical cost 3,913,871 3,899,016
Accumulated depreciation 2,685,578 2,757,776
Average depreciable life (in years) 26 26
Average age 18 18
component of the weighted average 8.18 8.45
Roads

Historical cost 75,000 75,000
Accumulated depreciation 75,000 75,000
Average depreciable life (in years) 20 20
Average age 20 20
component of the weighted average 0.18 0.18
Storm drains

Historical cost 30,000 30,000
Accumulated depreciation 30,000 30,000
Average depreciable life (in years) 40 40
Average age 40 40
component of the weighted average 0.14 0.14
Enter Your Own Critical Infrastructure

Historical cost

Accumulated depreciation

Average depreciable life (in years)

Average age
component of the weighted average
Enter Your Own Critical Infrastructure

Historical cost

Accumulated depreciation

Average depreciable life (in years)

Average age
component of the weighted average



Weighted average:

Total cost of critical infrastructure 8,533,626 8,482,521
Average age of critical infrastructure 13.1 13.8



Public Safety

Violent crimes per thousand

Violent crimes 10 13
Violent crimes per thousand 9 11



Property crimes per thousand

Property crimes 31 33
Property crimes per thousand 27 29



Traffic injuries or fatalities

Traffic incidents from the UD-10 24 24



Quality of Life

Miles of sidewalks and non-motorized paths/trails as a factor of total miles of local/major roads & streets

Miles of sidewalks and non-motorized paths/trails 10 10
Total miles of local/major roads & streets 12 12

0.833 0.833



Percent of General Fund expenditures committed to arts, culture and recreation

Arts, recreation & culture expenditures 27,706 41,041

3.8% 5.6%



Acres of parks per thousand residents

Acres of parks 3 3

2.60 2.60



Percent of community being provided with curbside recycling - 100
Population where curbside recycling is offered
1,154

0% 100%

























Sheet 3: Dashboard

Performance Dashboard








Local Unit Name: Village of Colon



Hide columns F,G, H & I before publishing. Also, hide the "Data Input" tab.
Local Unit Code: 753030













2013-14 2014-15 Trend Performance 1.0% Percentage Threshold for Good or Bad
Fiscal Stability


Performance Indicator (is an increase Good, Bad, or Neutral)
Annual All Governmental Fund expenditures per capita $627 $639 1.9% Negative Bad
Fund Balance as % of annual All Governmental expenditures 72.2% 71.1% -1.5% Negative Good
Unfunded pension & OPEB liability, as a % of annual General Fund revenue 0% 0% #DIV/0! #DIV/0! Bad
Debt burden per capita $17 $17 0.0% Neutral Bad
Percentage of road funding provided by the General Fund 5.7% 0.0% -100.0% Neutral Neutral
Ratio of pensioners to employees - - #DIV/0! #DIV/0! Bad
Number of services delivered via cooperative venture 3 3 0.0% Neutral Good
Economic Strength





% of community with access to high speed broadband 99% 99% 0.0% Neutral Good
% of community age 25+ with Bachelor's degree or higher 21% 21% 0.0% Neutral Good
Average age of critical infrastructure (years) 13.1 13.8 5.2% Negative Bad
Public Safety





Violent crimes per thousand 9 11 30.0% Negative Bad
Property crimes per thousand 27 29 6.5% Negative Bad
Traffic injuries or fatalities 24 24 0.0% Neutral Bad
Quality of Life





Miles of sidewalks and non-motorized paths/trails as a factor of total miles of local/major roads & streets 0.83 0.83 0.0% Neutral Good
Percent of General Fund expenditures committed to arts, culture and recreation 3.8% 5.6% 45.3% Neutral Neutral
Acres of parks per thousand residents 2.6 2.6 0.0% Neutral Good
Percent of community being provided with curbside recycling 0% 100% #DIV/0! #DIV/0! Good