CR 12-013 Approve 2012 Budget Modifications to General FundFebruary 6, 2012 -4a Council Report 2012-013
City of Hopkins
APPROVE 2012 BUDGET MODIFICATIONS TO GENERAL FUND
Proposed Action
Staff recommends adoption of the following: Move to approve 2012 budizet modifications to the General Fund by
increasing revenues and expenditures by $85,999 for Community Development activities.
Adoption of this motion will result in a modification to the General Fund by increasing both the revenues and
expenditures by $85,999. The General Fund will then reflect $10,556,525 in revenues and expenditures.
Overview
Due to changes in accounting standards as promulgated by GASB 54 any Special Revenue Fund that does not have
a revenue source dedicated to specific expenditures cannot exist as a Special Revenue Fund. The Housing Rehab
Special Revenue Fund while having a December 31, 2011 fund balance of $495,006 does not have a revenue
stream. Expenditures from this fund have come from an annual appropriation of fund balance. Staff proposes to
move the activities of this fund into the General Fund by creating a Community Development department. The
expenditures of this department would continue to be funded by the existing fund balance until those funds run out.
Since the existing Housing Rehab fund has no revenue stream, staff has been aware that when the existing fund
balance runs out we were going to have to come to a decision on how to continue the activities of this fund. After
reviewing the activities of this fund it was determined that the General Fund would be the most appropriate
• accounting for these activities. GASB 54 has just accelerated the decision with regards to the eventual disposition
of this fund.
•
Primary Issues to Consider
• Accounting standard changes
• Appropriate accounting for Community Development activities
Staff Recommendation
• Finance recommends approving the aforementioned budget adjustment.
Supporting Information
• 2012 General Fund Budget
• 2012 Community Development Departmental Budget
Christine Harkess, CPA, CGFM
Finance Director
Financial Impact: $ 85,999 Budget Y/N: N
Source: Old Fund 213
Related Documents (CIP, ERP, etc): 2012 Budget
Notes:
Licenses, Permits & Fees
CITY OF HOPKINS
PROPOSED GENERAL
FUND REVENUE BUDGET
135,000
115,000
115,000
-14.81%
Building Permit & Inspection Fees
•
246,500
246,500
O'tgtll�il
Pe V75£:Cf
7,500
5,000
2011
2012
2012
%
Department
Budget
Budget
Budget
Incr/(Decr)
Property Taxes & PERA Special Levy
630,564
8,887,591
8,887,591
2.98%
Intergovernmental Revenue
3,500
-33.96%
PW - Licenses & Permits
9,490
PERA Aid
20,510
20,510
20,510
0.00%
MVHC unallotment
1,000
0
0
544,790
Police - Federal Grant
0
0
0
0
Police - State Aid
177,700
177,000
177,000
-0.39%
Police - POST Reimbursement
10,000
9,000
9,000
-10.00%
Police - Misc Grants
4,000
86,000
86,000
2050.00%
Police - 911 Service Fee
24,860
24,860
24,860
0.00%
Fire - State Aid
85,000
70,000
70,000
-17.65%
Fire - County
0
0
0
PW - State Aid
120,000
125,000
125,000
4.17%
Total Intergovernmental Revenue
442,070
512,370
512,370
15.90%
Licenses, Permits & Fees
Court Fines
135,000
115,000
115,000
-14.81%
Building Permit & Inspection Fees
283,100
246,500
246,500
-12.93%
Business Licenses
7,500
5,000
5,000
-33.33%
Administrative Citations
6,000
8,000
8,000
33.33%
Liquor, Animal Licenses & Penalties
95,900
98,700
98,700
2.92%
Fire Licenses & Permits
5,300
3,500
3,500
-33.96%
PW - Licenses & Permits
9,490
9,415
9,415
-0.79%
P&Z- License&Permits
2,500
1,000
1,000
-60.00%
Total Licenses, Permits & Fines
544,790
487,115
487,115
-10.59%
•
Charges for Service
Finance Department
5,200
5,750
5,750
10.58%
Municipal Building
2,500
2,500
2,500
0.00%
Assessing
1,000
1,200
1,200
20.00%
City Clerk
11,100
0
0
-100.00%
Inspections
43,450
71,950
71,950
65.59%
Police
43,500
40,000
40,000
-8.05%
Fire
6,200
70,000
70,000
1029.03%
Public Works
2,250
2,750
2,750
22.22%
Activity Center
46,000
49,500
49,500
7.61%
Planning & Zoning
0
1,500
1,500
-66.67%
Community Development
0
0
85,999
Total Charges for Service
161,200
245,150
331,149
105.43%
Miscellaneous Revenue
Franchise Fees
290,000
290,000
290,000
0.00%
Unallocated Misc
500
0
0
-100.00%
Finance Department
4,800
4,800
4,800
0.00%
Elections
0
0
0
Police
500
1,000
1,000
100.00%
Fire
0
0
0
Public Works
2,100
4,000
4,000
90.48%
Acitivty Center
17,000
13,500
13,500
-20.59%
Total Miscellaneous Revenue
314,900
313,300
313,300
-0.51%
Interest Earnings
75,000
25,000
25,000
-66.67%
Use of 2009 Budget Savings
130,803
Total Revenues
$ 10,299,327
$ 10,470,526
$10,
2.50%
CITY OF HOPKINS
PROPOSED GENERAL FUND EXPENDITURE BUDGET
Original Revised
2011 2012 2012 Budget %
Department Budget Budget Budget Incr/(Decr)
Citv Council 71,547 68,697 68,697 -3.98%
Administrative Services
Administration
167,300
171,090
171,090
2.27%
Personnel
43,924
44,405
44,405
1.10%
Wellness
2,000
2,000
2,000
0.00%
Information Services
238,446
251,637
251,637
5.53%
Total Administrative Services
451,670 1
469,132 1
469,132
3.87%
Finance
Budget
23,066
26,249
26,249
13.80%
Debt Management
0
0
0
0.00%
General Accounting
129,448
133,402
133,402
3.05%
Payroll
46,729
45,075
45,075
-3.54%
TIF Administration
0
0
0
0.00%
Utility Billing
4,000
5,000
5,000
25.00%
Total Finance
203,243
209,726
209,726
3.19%
Le al
135,000
135,000
135,000
0.00%
Munici al Building
294,818
296,863
296 863
0.69%
•
Receptionist
44,172
44,846
44,846
1.53%
lAssessing
167,236
173,091
173,091
3.50%
City Clerk
City Clerk
19,360
16,822
16,822
-13.11%
Records Management
29,833
32,273
32,273
8.18%
Elections
50,222
60,875
60,875
21.21%
Total City Clerk
99,415
109,970 1
109,970
10.62%
Inspections
Building Code Inspections
252,170
268,598
268,598
6.51%
Fire Inspections
38,205
34,494
34,494
-9.71%
Heating & Plumbing Inspections
90,400
91,358
91,358
1.06%
Housing Inspections
134,680
135,597
135,597
0.68%
Restaurant & Hotel Inspections
23,309
1,160
1,160
-95.02%
Misc. Community Inspections
75,143
79,260
79,260
5.48%
Vacant Property Management
2,700
2,700
2,700
0.00%
Total Inspections
616,607
613,167
613,167
-0.56%
Police
Police Administration
480,615
486,499
486,499
1.22%
Patrol
2,360,705
2,466,299
2,466,299
4.47%
Heat Team
73,298
58,906
58,906
-19.63%
Reserves
33,620
24,467
24,467
-27.22%
• Investigations
499,148
430,357
430,357
-13.78%
Metro Drug Task Force
105,737
105,292
105,292
-0.42%
Pawn Shop
3,436
3,493
3,493
1.66%
Outreach
80,804
84,036
84,036
4.00%
Fire
Fire 833,587 851,559 851,559 2.16%
Emergency Preparedness 4,671 3,865 3,865 -17.26%
Total Fire 838,258 855,424 8 55,-4-24-1 2.05%
Public Works
PW Building
2011
2012
2012
Budget%
Department
Budget
Budget
Budget
Incr/(Decr)
Dispatch
526,782
553,145
553,145
5.00%
Reception -Records
255,560
252,356
252,356
-1.25%
Systems Management
64,682
65,182
65,182
0.77%
Total Police
4,484,387
4,530,032
4,530,032
1.02%
Fire
Fire 833,587 851,559 851,559 2.16%
Emergency Preparedness 4,671 3,865 3,865 -17.26%
Total Fire 838,258 855,424 8 55,-4-24-1 2.05%
Public Works
PW Building
33,692
Equipment Services
78,446
Administration
26,478
Engineering
137,802
Street & Alleys
853,812
Snow & Ice Removal
205,615
32,739
32,739
-2.83%
86,229
86,229
9.92%
27,442
27,442
3.64%
132,267
132,267
-4.02%
859,205
859,205
0.63%
197,550
197,550
-3.92%
Parks 628,101 652,465 652,465 3.88%
Tree Service 210,454 210,780 210,780 0.15%
Total Public Works 2,174,400 2,198 677 2,198 677 1.12%
Recreation
Transfers to other funds
Playground
20,198
21,034
21,034
4.14%
Ice Rink
12,284
12,192
12,192
-0.75%
Park Service
12,518
12,810
12,810
2.33%
Joint Recreation
147,000
152,000
152,000
3.40%
Skate Park
7,721
7,063
7,063
-8.52%
Total Recreation
199,721
205,099
205,099
2.69%
Activity Center
Transfers to other funds
Act Ctr - Community Use
274,008
264,914
264,914
-3.32%
Act Ctr - Maintenance
59,463
58,851
58,851
-1.03%
Total Activity Center
333,471
323,765
323,765
-2.91%
Planning & Zoning
125,182
126,837
126,837
1.32%
lCommunity Development
0
0
85,999
Tuition Reimbursement
10,200
10,200
10,200
0.00%
lContingency
50,000
90,000
90,000
80.00%
Total Expenditures
10,299,327
10,460,526
10,546,525
2.40%
Other Financing Uses
Transfers to other funds
0
10,000
10,000
Total Other Financing Uses
0
10,000
10,000
Grand Total Expenditures
$10,299,327
$10,470,526
$10,556,525 2.50%
Total Revenues
$10,299,327
$10,470,526
1 $10,556,525
Revenues Over (Under) Expenditures $ - $
•
•
•
247
PROGRAM 46320
REVENUE AND EXPENDITURE SUMMARY
FUND 101
COMMUNITY DEVELOPMENT
Actual
Actual
Actual
Budget
Budget
Percent
CODE
2009
2010
2011
2011
2012
Change
REVENUES
449
Other Miscellaneous
$
-
$
-
$
-
$
-
$
85,999
EXPENDITURES
Salaries and Employee Benefits
500
Regular Employees
$
56,832
$
56,018
$
54,605
$
57,219
$
58,762
2.70%
524
SL Converted/LTD
92
92
95
450
463
2.89%
525
P.E.R.A. Contribution
3,625
3,766
3,797
4,148
4,260
2.70%
526
F.I.C.A. Contribution
4,121
4,091
4,015
4,378
4,495
2.67%
527
Employee Benefit Plan
9,597
10,386
9,873
10,746
11,037
2.71%
531
Workers' Compensation Insurance
435
394
334
491
491
535
Paid Leave Accrual
2,127
682
660
716
734
2.51%
TOTAL
76,829
75,429
73,379
78,148
80,242
2.68%
Materials, Supplies and Services
540
Office Supplies
542
499
296
950
700
-26.32%
542
General Supplies
429
-
107
200
200
560
Postage
29
11
9
1,000
900
-10.00%
581
Advertising and Publication
57
57
60
200
200
582
Expert & Professional Services
886
666
-
500
500
583
Other Contractual Services
42
42
42
60
100
66.67%
624
Equipment Allocation
246
226
192
192
123
-35.94%
•633
635
Dues and Memberships
Travel/Mileage
28
73
-
107
-
115
200
350
175
350
-12.50%
636
Conference Fees
-
-
105
750
750
637
Meals and Lodging
24
-
-
700
700
651
Fleet Liability
24
19
19
34
35
2.94%
652
General Liability
1,116
761
875
984
1,024
4.07%
TOTAL
3,496
2,388
1,820
6,120
5,757
-5.93%
EXPENDITURE TOTAL
$
80,325
$
77,817
$
75,199
$
84,268
$
85,999
2.05%
NET TAX AND GENERAL
REVENUE SUPPORTED
$
80,325
$
77,817
$
75,199
$
84,268
$
-
-100.00%
•
247