HomeMy WebLinkAboutItem 06.eEle
December 17, 2012
Resolution Amending 2012 Budgets
Proposed Act
Item No.
Staff recommends adoption of the following motion: Move to approve the Resolution
Amenclingi the Budgets.
Overview
Various events have transpired during the year which requires an adjustment to the budget
for various City funds. Approval of the resolution authorizes the amendment of the budget to
more accurately reflect changes in operations.
A detailed explanation of the adjustments is attached to the respective exhibits.
Primary Issues to Consid
Affected Fund. Funds recommended to be adjusted include:
• Exhibit A: General Fund
• Exhibit B: Communications Fund
• Exhibit C Compensated Liability Fund
Supporting Information
. - Ira
fO
Financial Impact: $ See attached budgeted: N/ A Source: Various
Related Documents (CIP, ERP, etc.):
Notes:
CITY OF LAKEVILLE
RESOLUTION No.
RESOLUTION AMENDING THE 2012 BUDGETS
BE IT RESOLVED by the City Council of the City of Lakeville, Minnesota that the
2012 General Fund, Communications Special Revenue Fund and Compensation
Liability Internal Service Fund budgets are hereby approved and amended for the
fiscal year ending December 31, 2012 as per Exhibit A through C, respectively, as
attached hereto.
APPROVED AND AMENDED this 17th day of December 2012 by the City Council of
the City of Lakeville, Minnesota.
CITY OF LAKEVILLE, MINNESOTA
M
Mark Bellows, Mayor
ATTEST:
Charlene Friedges, City Clerk
Exhibit A
2012 GENERAL FUND BUDGET
(continued)
0
2012
2012
ADOPTED
AMENDED
BUDGET
ADJUST
BUDGET
NOTES
Revenues
General property taxes
$ 16,153,641
$
$16,153,641
Licenses and permits
972,953
972,953
Intergovernmental revenue
646,267
111,371
757,638
(1)(2)
Charges for services
1,526,681
5,168
1,531,849
(3)
Court fines
279,301
-
279,301
Investment income
91,795
-
91,795
Miscellaneous
58,857
10,690
69,547
(4)
Total revenues
19,729,495
127,229
19,856,724
Expenditures
Mayor and Council
94,724
-
94,724
Committees and Commissions
66,403
66,403
City administration
321,527
(2,312)
319
(5)
City Clerk
179,068
(718)
178,350
(5)
Legal
65,132
-
65,132
Planning
343,905
(2,351)
341,554
(5)
Community and economic development
300,178
(1,868)
298,310
(5)
Inspection
775,986
(5,294)
770,692
(5)
General government facilities
485,805
(21,744)
464,061
(3)(5)
Finance
614,709
(4,770)
609,939
(5)
Information systems
482,719
(2,253)
480,466
(5)
Human resources
361,001
(1,882)
359,119
(5)
Insurance
223,275
223,275
Police
8,619,053
(33,921)
8,585,132
(4)(5)
Fire
1,353,848
5,881
1,359,729
(1)(2)(5)
Engineering
728,506
(5,157)
723,349
(5)
Streets
2,576,134
92,066
2,668,200
(1)(5)
Parks
2,188,320
(8,671)
2,179,649
(5)
Recreation
599,246
(2,627)
596,619
(5)
Heritage Center
-
25,507
25,507
(3)
Arts Center
445,355
(1,657)
443,698
(5)
Other
104,000
(104,000)
-
(6)
Total expenditures
20,928,894
(75,771)
20,853,123
Other financing sources
Transfers from other funds
680,253
-
680,253
Net change in fund balance
(519,146)
203,000
(316,146)
Fund balance, January 1
9,636,644
911,694
10,548,338
(7)
Fund balance, December 31
$ 9,117,498
$ 1,114,694
$10,232,192
(continued)
0
Exhibit A(Cont.)
Taxes
GENERAL FUND
SCHEDULE OF REVENUES
2012
ADOPTED
BUDGET
$ 13,816,776 $
243,228
2,006,780
14,700
45,200
18,050
8,907
2012
AMENDED
ADJUST BUDGET NOTES
- $13,816,776
- 243,228
- 2,006,780
- 14,700
- 45,200
- 18,050
_ 8,907
Property taxes - current
Property taxes - delinquent
Fiscal disparities
Penalties and interest
Mobile home tax
Mobile home tax credit
Gravel tax
Total Taxes
Licenses and Permits
Licenses
Cigarette
Trash removal
Dog
Signs
On -sale liquor
Sunday liquor
Club special license
Non - intoxicating liquor on
Non - intoxicating liquor off
Wine
Tree removal
Arcade (amusement device)
Fireworks
Massage
Miscellaneous
Total Licenses
(continued)
$ 16,153,641 $ - $16,153,641
$ 18,000 $
- $ 18,000
3,750
- 3,750
13,652
- 13,652
4,882
- 4,882
128,600
- 128,600
4,400
- 4,400
500
- 500
1,500
- 1,500
900
- 900
1,500
- 1,500
650
- 650
2,985
- 2,985
1,650
- 1,650
1,675
- 1,675
500
- 500
185,144
- 185,144
E
Exhibit A(Cont.)
GENERAL FUND
SCHEDULE OF REVENUES
Licenses and Permits (continued)
2012
2012
ADOPTED
AMENDED
BUDGET ADJUST
BUDGET
$ 147,560 $
$ 147,560
424,499
424,499
46,153
46,153
19,399
19,399
59,637
59,637
250
250
750
750
600
600
3,800
3,800
20,000
20,000
875
875
63,786
63,786
500
500
787,809
787,809
NOTES
Permits
Plan review fees
Building
Plumbing
Water and sewer
Mechanical
Grading /Filling
Excavating /gravel
Driveway
Zoning
Right of Way
Fire burning
Electrical
Miscellaneous
Total Permits
Total Licenses and Permits
$ 972,953 $ - $ 972,953
Intergovernmental
State -aid police
State -aid fire relief
State -aid pensions
State POST Board grant
State performance aid
State gun range environmental grant
State snowmobile trail maintenance grant
Federal, State FEMA
Federal, State and County traffic safety grants
$ 342,585 $
- $ 342,585
213,067
6,891 219,958
21,303
- 21
18,616
- 18,616
7,834
- 7,834
40,562
- 40,562
200
- 200
-
104,480 104,480
2,100
- 2,100
(2)
Total Intergovernmental
(continued)
$ 646,267 $ 111,371 $ 757,638
3
(1)
Exhibit A(Cont.)
GENERAL FUND
SCHEDULE OF REVENUES
Public Safet
Police department charges
2012
2012
SRO - ISD 194 contribution
ADOPTED
AMENDED
Animal pickup
BUDGET ADJUST
BUDGET NOTES
Charges for Services
7,239
- 7,239
General Government
2,610
- 2,610
Rezoning fees
$ 1,000 $ -
$ 1,000
Platting fees
4,900 -
4,900
Variance fees
250 -
250
PUD application fees
1,000 -
1,000
CUP fees
3,200 -
3,200
Home occupation fees
400 -
400
Planner fees
42,000 -
42,000
Inspection fees
7,962 -
7,962
General government service charge
3,348 -
3,348
Tree escrow fund administration
500 -
500
Lodging tax fee
6,750 -
6,750
Fiscal Agent - Dakota Communication Center
61,800 -
61,800
Fiscal Agent - Ice arenas
32,000 -
32,000
Investment management fees
28,217 -
28,217
Sale of maps /copies
200 -
200
Finance charges
151
151
Total General Government
193,678
193,678
Public Safet
Police department charges
76,099
- 76,099
SRO - ISD 194 contribution
153,985
- 153,985
Animal pickup
3,876
- 3,876
Animal storage
7,239
- 7,239
Animal rabies
2,610
- 2,610
Restitution
3,000
- 3,000
Forfeiture - sale of assets
30,000
- 30,000
Fire contracts
34,240
- 34,240
Fire department charges
2,800
- 2,800
ALF - Administrative charge
12,300
- 12,300
Total Public Safety
326,149
- 326,149
(continued)
4
Exhibit A(Cont.)
GENERAL FUND
SCHEDULE OF REVENUES
NOTES
(3)
5
2012
2012
ADOPTED
AMENDED
BUDGET ADJUST
BUDGET
Charges for Services (continued)
Public Works
Engineering platting - preliminary
$ 9,000 $ -
$ 9,000
Engineering platting - final
5,500 -
5,500
Engineering plan review fees
7,000 -
7,000
Engineering drawing /base map prep
1,500 -
1,500
Engineering developer inspection fees
20,000 -
20,000
Engineering developer contract administration
30,000 -
30,000
Engineering improvement project design variable
107,600 -
107,600
Engineering improvement project const. inspection
89,625 -
89,625
Engineering street construction projects
89,800 -
89,800
Engineering G.I.S. fees
4,200 -
4,200
Special assessment admin charge
62,810 -
62,810
Special assessment searches
300 -
300
Document/map sales
500 -
500
Bid plans /specs deposits
600 -
600
Street department charges
12,000 -
12,000
Credit River - Judicial road maintenance
2,746 -
2,746
Developer street signs installation
2,400 -
2,400
Total Public Works
445,581 -
445,581
Parks and Recreation
Recreation activities
Brochure ad revenue
7,050 -
7,050
Youth activities
112,582 -
112,582
Youth sport surcharge
32,000 -
32,000
Youth special events
13,391 -
13,391
Youth special events donations
1,400 -
1,400
Adult activities
70,450 -
70,450
Puppet wagon donations
3,000 -
3,000
Safety Camp
3,000 -
3,000
Safety Camp donations
1,100 -
1,100
Senior Center donations
470 4,763
5,233
Senior Center excursion
20,000 -
20,000
Senior Center membership surcharge
4,010 -
4,010
Senior Center rental
440 -
440
Ritter Farm Park Environmental Learning Center
6,682 -
6,682
Excursions
7,920 -
7,920
Tennis lessons
9,606 -
9,606
Total recreation activities
293,101 4,763
297,864
NOTES
(3)
5
(continued)
Exhibit A(Cont.)
GENERAL FUND
SCHEDULE OF REVENUES
2012
ADOPTED
BUDGET
Charges for Services (continued)
Parks and Recreation (continued)
Park rental /maintenance /tournament fees
Tree sales (net)
Total Parks and Recreation
Heritage Center
Facility rental
Arts Center
Program fees
On -sale
Facility rental /event admissions
Total Arts Center
Total Charges for Services
Court Fines
Investment Income
Miscellaneous
Disposal of assets
Park rental farming Berres
Donations
Antenna site leases
Total Miscellaneous
Total Revenues
2012
AMENDED
ADJUST BUDGET NOTES
$ 27,231 $ $ 27,231
3,841 3,841
324,173 4,763 328,936
405 405 (3)
72,000
- 72,000
5,000
- 5,000
160,100
- 160,100
45,162
237,100
- 237,100
10,690 $ 69,547
$ 1,526,681 $
5,168 $ 1,531,849
$ 279,301 $
- $ 279,301
$ 91,795 $
- $ 91,795
$ 5,150 $
$ 5,150
400
400
8,145
10,690 18,835 (4)
45,162
- 45,162
$ 58,857 $
10,690 $ 69,547
$ 19,729,495 $
127,229 $19,856,724
I
(continued)
Exhibit A(Cont.)
GENERAL FUND
SCHEDULE OF EXPENDITURES
Expenditures
2012
ADOPTED
BUDGET
2012
AMENDED
ADJUST BUDGET NOTES
Mayor and Council
Personnel services
Commodities
Other charges and services
Total
Committees and Commissions
Personnel services
Commodities
Other charges and services
Total
City Administration
Personnel services
Commodities
Other charges and services
Capital outlay
Total
City Clerk
Personnel services
Commodities
Other charges and services
Capital outlay
Total
Legal
Other charges and services
Planning
Personnel services
Commodities
Other charges and services
Capital outlay
Total
$ 49,752 $
50
44,922
94,724
47,538
1,924
16,941
66,403
$ 49,752
50
44,922
94,724
47,538
1,924
16,941
66,403
308,853
(2,312)
306,541 (5)
900
15,439
900
10,742
1,377
10,742
1,032
-
1,032
321,527
(2,312)
319,215
104,248
(718)
103,530 (5)
1,900
-
1,900
61,367
61,367
11,553
-
11,553
179,068
(718)
178,350
65,132 65,132
324,879 (2,351)
322,528 (5)
2,210
2,210
15,439
15,439
1,377 -
1,377
343,905 (2,351)
341,554
7
(continued)
Exhibit A(Cont.)
GENERAL FUND
SCHEDULE OF EXPENDITURES
Expenditures
Community and Economic Development
Personnel services
Commodities
Other charges and services
Capital outlay
Total
Inspection
Personnel services
Commodities
Other charges and services
Capital outlay
Total
General Government Facilities
Personnel services
Commodities
Other charges and services
Capital outlay
Total
Finance
Personnel services
Commodities
Other charges and services
Capital outlay
Total
Information Systems
Personnel services
Commodities
Other charges and services
Capital outlay
Total
2012
2012
ADOPTED
AMENDED
BUDGET
ADJUST
BUDGET
NOTES
$ 253,105
$ (1,868)
$ 251,237
(5)
205
205
46,180
46,180
688
688
300,178
(1,868}
298,310
649,708
(5,294)
644,414
(5)
13,244
13,244
110,281
110,281
2,753
-
2,753
775,986
(5,294)
770,692
186,185
(1,405)
184,780
(5)
31,025
31,025
267,563
(20,339)
247,224
(3)
1,032
-
1,032
485,805
(21,744)
464,061
543,445
(4,770)
538,675
(5)
4,545
4,545
64,310
64,310
2,409
-
2,409
614,709
(4,770)
609,939
305,180
(2,253)
302,927
(5)
6,648
6,648
159,784
159,784
11,107
11,107
482,719
(2,253)
480,466
L
(continued)
Exhibit A(Cont.)
GENERAL FUND
SCHEDULE OF EXPENDITURES
Expenditures
Human Resources
Personnel services
Commodities
Other charges and services
Capital outlay
Total
Insurance
Other charges and services
Police
Personnel services
Commodities
Other charges and services
Capital outlay
Total
Fire
Personnel services
Commodities
Other charges and services
Total
Engineering
Personnel services
Commodities
Other charges and services
Capital outlay
Total
Streets
Personnel services
Commodities
Other charges and services
Total
2012 2012
ADOPTED AMENDED
BUDGET ADJUST BUDGET NOTES
$ 252,616 $ (1,882) $ 250,734 (5)
1,570 1,570
105,783 105,783
1,032 - 1,032
361,001 (1,882) 359,119
223,275 223,275
6,574,843
(44,611)
6,530,232
(5)
336,255
336,255
1,707,955
-
1,707,955
10,690
10,690
(4)
8,619,053
(33,921)
8,585,132
951,382
5,881
957,263
(1)(2)(5)
135,772
-
135,772
266,694
-
266,694
1,353,848
5,881
1,359,729
660,919
(5,157)
655,762
(5)
11,157
11,157
50,471
50,471
5,959
-
5,959
728,506
(5,157)
723,349
1,530,445
19,168
1,549,613
(1)(5)
786,690
1,402
788,092
(1)
258,999
71,496
330,495
(1)
2,576,134
92,066
2,668,200
F7
(continued)
Exhibit A(Cont.)
GENERAL FUND
SCHEDULE OF EXPENDITURES
Expenditures
Parks
Personnel services
Commodities
Other charges and services
Capital outlay
Total
Recreation
Personnel services
Commodities
Other charges and services
Capital outlay
Total
Heritage Center
Personnel services
Commodities
Other charges and services
Total
Arts Center
Personnel services
Commodities
Other charges and services
Capital outlay
Total
10110 -iil
Total Expenditures
Transfers From other funds
2012 2012
ADOPTED AMENDED
BUDGET ADJUST BUDGET NOTES
$ 1,540,362 $ (8,671) $ 1,531,691 (5)
254,196 254,196
391,010 391,010
2,752 - 2,752
2,188,320 (8,671) 2,179,649
329,124
(2,627)
326,497
(5)
23,444
23,444
244,613
244,613
2,065
-
2,065
599,246
(2,627)
596,619
-
7,303
7,303
(3)
3,512
3,512
(3)
14,692
14,692
(3)
25,507
25,507
221,848
(1,657)
220,191
22,500
22,500
200,319
200,319
688
688
445,355 (1,657) 443,698
104,000 (104,000) (5)
$ 20,928,894 $ (75,771) $20,853,123
Communications Fund $ 72,793 $ - $ 72,793
Liquor Fund 152,434 - 152,434
Utility Fund (Water, Sanitary Sewer, Street Light, Enviror 409,259 - 409,259
Municipal Reserves Fund 45,767- - 45,767
Total transfers from other funds $ 680,253 $ - $ 680,253
10
Exhibit A
2012 GENERAL FUND
BUDGET AMENDMENT NOTES
(1) Increase revenues and expenditures for Federal /State FEMA reimbursement
received for expenditures related to the June 19th storm damage
Revenues: Intergovernmental Federal /State FEMA
Expenditures: Fire personnel services
Expenditures: Streets personnel services
Expenditures: Streets commodities
Expenditures: Streets other charges and services
Net
(2) Increase Fire State Aid revenue to the 2012 actual amount received.
Revenues: Intergovernmental Revenues Fire State Aid
Expenditures: Fire Relief Association
Net
(3) Increase Heritage Center budget for operations effective October 1 st.
Revenues: Charges for services facility rental
Revenues: Charges for services senior center donations
Expenditures: General Government Facilities other charges and services
Expenditures: Heritage Center personnel services
Expenditures: Heritage Center commodities
Expenditures: Heritage Center other charges and services
Net
(4) Increase Police Department capital outlay budget for K -9 replacement. The
K -9 is funded by donations.
Revenues: Donations
Expenditures: Police capital outlay
Net
104,480
1,952
29,630
1,402
71,496
6,891
6,891
405
4,763
(20,339)
7,303
3,512
14,692
10,690
10,690
11
Exhibit A
2012 GENERAL FUND
BUDGET AMENDMENT NOTES
(5) Reverse 2012 Appropriations from General Fund to Compensation Liability
City Administration
City Clerk
Planning
Community and Economic Development
Inspections
General Government Facilities
Finance
Information Systems
Human Resources
Police
Fire
Engineering
Streets
Parks
Recreation
Arts Center
Fund Balance
Net
(6) Unused portion of contingency reverts to the fund balance.
Contingency
Fund Balance
Net
(7) Adjust the budgeted (estimated) January 1, 2012 Fund Balance to reflect the
actual January 1 Fund Balance
Actual Fund Balance, January 1, 2012
Budgeted Fund Balance, January 1, 2012
Increase Fund Balance, January 1, 2012
(2,312)
(718)
(2,351)
(1,868)
(5,294)
(1,405)
(4,770)
(2,253)
(1,882)
(44,611)
(2,962)
(5,157)
(10,462)
(8,671)
(2,627)
(1,657)
99,000
(104,000)
104,000
10,548,338
9,636,644
911,694
i[
Exhibit B
2012 COMMUNICATIONS FUND BUDGET
Revenues
Franchise fee
State -aid pensions
Investment income
Total Revenues
Expenditures
Personnel services
Commodities
Other charges and services
Capital outlay
Total Expenditures
Transfers
Transfer to General Fund
Transfer to Equipment Fund
Total Transfers
Net Change in Fund Balance
Fund Balance, January 1
Fund Balance, December 31
2012 2012
ADOPTED AMENDED
BUDGET ADJUST BUDGET NOTES
$ 607,523 $ - $ 607,523
516 516
4,106 - 4,106
612,145 - 612,145
318,770
(3,155)
315,615 (1)
8,876
8,876
107,995
40,175
148,170 (2)
27,227
-
27,227
462,868
37,020
499,888
(72,793)
-
(72,793)
148,416
148,416
221,209
221,209
(71,932)
(37,020)
(108,952)
843,285
16,231
859,516 (3)
$ 771,353 $ 2( 0789) $ 750,564
13
2012 COMMUNICATIONS FUND
BUDGET AMENDMENT NOTES
(1) Reverse 2012 Appropriations from Communications Fund to
Compensation Liability Fund
Fund Balance
(2) Additional legal and consultant service incurred related to the Cable
Franchise Renewal process as per discussion at the Council worksession
Other Charges and Services
Fund Balance
(3) Adjust the budgeted (estimated) January 1, 2012 Fund Balance to reflect
the actual January 1 Fund Balance
Actual Fund Balance, January 1, 2012
Budgeted Fund Balance, January 1, 2012
Increase Fund Balance, January 1, 2012
(3,155)
3,155
40,175
(40,175)
859,516
843,285
16,231
M
Exhibit C
2012 COMPENSATION LIABILITY FUND BUDGET
Operating Revenue
Charges for services
Operating expense
Personnel services
Operating income (loss)
Non - operating revenue (expense)
Investment income
Transfer to Equipment Fund
Total non - operating (net)
Change in net assets
Net assets, January 1
Net assets, December 31
2012 2012
ADOPTED AMENDED
BUDGET ADJUST BUDGET NOTES
$ 102,155 $ 102,155 $ (1)
13,639 71,675 85,314 (1)
88,516 (173,830) (85,314)
4,580 (750) 3,830 (1)
683,602 683,602 (3)
4,580 684,352 679,772
93,096 (858,182) (765,086)
786,047 (20,961) 765,086 (2)
879,143 879,143 -
2012 COMPENSATION LIABILITY FUND
BUDGET AMENDMENT NOTES
ADJUSTMENT
(1) Charges for Services $(102,155)
Investment Income (750)
Personnel Services 71,675
Fund Balance 31,230
(2) Increase the budgeted January 1, 2012 Fund Balance to reflect the actual
December 31, 2011 Fund Balance carryforward.
Actual Fund Balance, January 1, 2012 $ 765,086
Budget Fund Balance, January 1, 2012 786,047
Decrease Fund Balance, January 1, 2012 L129,9611
(3) Close Compensation Liability Fund to the Capital Project - Equipment Fund
Transfer out - Equipment Fund $(683,602)
Fund Balance 683,602
15