HomeMy WebLinkAbout23-154 Resolution Amending the 2023 and 2024 Budgets CITY OF LAKEVILLE
RESOLUTION NO. 23-154
Resolution Amending the 2023 and 2024 Budgets
BE IT RESOLVED by the City Council of the City of Lakeville, Minnesota as follows:
1. The 2023 budget for the General Fund is hereby amended for the fiscal year ending
December 31, 2023 as per Exhibit A, as attached hereto.
2. The 2023 and 2024 budgets for construction/improvement or other projects are hereby
amended for the fiscal years ending December 31, 2023 and 2024 as per Exhibit B, as
attached hereto.
3. The 2023 budgets for all funds are hereby amended to reflect the actual January l,2023
fund balance.
ADOPTED by the Lakeville City Council this 18th day of December 2023. �
�
Luke M. Hellier, Mayor
Ann Orlofsky, City Clerk
CITY OF LAKEVILLE,MINNESOTA Eahibit A
General Fund
Schedule of Revenues,Expenditures and Changes in Fund Balances
For the Year Ending December 31,2023
2023 GENERAL FUND BUDGET
2023 2023 2023
2023 YTD 12/18/2023 Final
Adopted Amended Adjust Amended
Budget Budget Res.No.23-s+s Budget �Ss
Revenues
General property taxes $ 26,954,R75 $ 26,954,875 $ - $ 26,954,875
Licenses and permits 2,943,346 2,939,596 373,000 3>312,596 (15)
Intergovernmental 1,512,699 1,512,699 1,991,476 3,504,175 (1)(2)(3)(13)
Charges for services 3,392,946 3,461,591 245,910 3,707,501 (4)(7)(18)
Court fines 240,000 240,000 - 240,000
Investment income 281,000 281,000 - 281,000
Miscellaneous 46,257 46,257 - 46,257
Total revenues 35,371,123 35,436,018 2,610,386 38,046,404
�penditures
General govemment
Mayor and Council 138,778 138,778 (6,909) 131,869 (12)(17)
Committees and Commissions 127,877 127,877 885 128,762 (12)(17)
City administration 629,559 629,559 (69,503) 560,056 (12)(17)
City Clerk 183,931 183,931 185 184,116 (17)
Legal counsel 97,350 97,350 - 97,350
Planning 662,843 662,843 993 663,836 (17)
Community and econ.development 519,673 519,673 593 520,266 (17)
Inspections 1,936,637 1,987,477 69,523 2,057,000 (16)(17)
General government facilities 684,889 684,889 (91,676) 593,213 (12)(17)
Finance 1,134,847 1,191,943 42,463 1,234,406 (12)(16)(17)
Information systems 1,072,579 1,072,579 (170,515) 902,064 (12)(16)(17)
Human resources 887,396 895,198 (137,885) 757,313 (I1)(12)(17)
Insurance 250.000 250,000 - 250,000
Public safetv
Police 14,311,128 14,311,128 288,937 14,600,065 (10)(16)(17)
Fire 2,666,423 2,666,423 202,628 2,869,051 (1)(9)(17)
Public works
Engineering 1,120,397 1,120,397 (213,840) 906,557 (12)(17)
Forestry 566,047 566,047 332 566,379 (1�)
Operations and Maintenance 621,899 621,899 79,429 701,328 (8)(14)(17)
Streets 4,064,622 4,064,622 16,210 4,080,832 (12)(16)(17)
Pazks and recreation
Parks 3,470,194 3,470,194 28,033 3,498,227 (17)
Recreation 847,937 847,937 53,748 901,685 (4)(17)
Heritage Center 140,673 140,673 373 141,046 (17)
Arts Center 763,663 763,663 207,931 971,594 (6)(7)(16)(17)
Total expenditures 36,899,342 37,015,080 301,935 37,317,015
Excess(deFiciency)of revenues
over e�cpenditures (1,528,219) (1,579,062) 2,308,451 729,389
Other financing sources(usesl
Transfer from other funds 1,171,099 1,285,453 (413,520) 871,933 (5)(12)(16)
Transfer to other funds (2,353,880) (2,353,880) - (2,353,880)
Total other financing sources(uses) (1,182,781) (1,068,427) (413,520) (1,481,947)
Net change in fund balance (2,71 I,000) (2,647,489) 1,894,931 (752.559)
Fund balance,January 1 21,881,813 21,881,813 125,594 22,007,407 (19)
Fund balance,December 31 $ 19,170,813 $ 19,234,324 $ 2,020,525 $ 21,254,849
Eahibit A
Exhibit A
(1) Amend Fire Relief Association contribution resulting from increase in state aid.
Expenditures:
Other Charges and Services 54,000
Revenues:
Intergovernmental 54,000
(2) Amend Police state aid
Revenues:
Intergovernmental 62,476
Increase Fund Balance 62,476
(3) Adjust Dakota County reimbursement for boulevard mowing
Revenues:
Other Intergovernmentai Revenue 25,000
Increase Fund Balance 25,000
(4) Adjust Recreation Revenue&Expenditures Based on Program Registrations
Expenditures:
Other Charges and Services 1,000
Other Charges and Services 2,000
Other Charges and Services 7,500
Other Charges and Services 500
Other Charges and Services 15,000
Other Charges and Services 1,000
Other Charges and Services 7,500
Other Charges and Services 500
Other Charges and Services 6,000
Other Charges and Services 250
Other Charges and Services 10,000
Other Charges and Services 1,000
Revenues:
Senior Center/Recreation Surcharges 11,000
Recreation Charges 11,000
Recreation Charges 11,000
Recreation Charges 20,000
Recreation Charges 10,000
Eahibit A
Recreation Charges 6,000
Increase Fund Balance 16,750
(5) Repayment of Amounts Part of Environmental Rates But Not Spent
Revenues:
From Utility Fund 157,169
Increase Fund Balance 157,169
(6) Adjust for 4 Months Operating in Fine Arts Building
Expenditures:
Personnel Services 25,000
Commodities 18,000
Commodities 5,000
Other Charges and Services 9,000
Other Charges and Services 6,000
Revenues:
Use of Fund Balance 63,000
(7) Program Registrations-Art Center
Expenditures:
Commodities 4,000
Other Charges and Services 10,000
Personnel Services Z,500
Other Charges and Services 35,000
Personnel Services 10,000
Other Charges and Services 27,000
Personnel Services 3,500
Commodities 28,000
Other Charges and Services 30,000
Revenues:
Performing Arts Admissions 6,000
Park/Building Rental 30,000
Art Center Charges 65,000
Art Center Charges 6,500
Art Center Charges 9,000
Recreation Charges 6,000
Use of Fund Balance 7,500
(8) New GPS Unit
Expenditures:
Capital Outlay Machine& Equipment 25,477
Revenues:
Eahibit A
Use of Fund Balance 25,477
(9) Adjust Duty Crew;Pay for Calls
Expenditures:
Personnel Charges-Duty Crew Pay 80,000
Personnel Charges-Pay for Fire Calls 20,000
Revenues:
Use of Fund Balance 100,000
(10) Adjust Police Personnel Charges
Expenditures:
Personnel Charges-Salaries 20,000
Revenues:
Use of Fund Balance 20,000
(11) Andrews Technology ERP costs
Expenditures:
Other Charges and Services 62,400
Revenues:
Use of Fund Balance 62,400
(12) Remove Transfers into the General Fund as Originally Adopted due to Allocating Amounts Instead
Expenditures:
Human Resources (201,147)
IT (174,398)
General Government Facilities (96,072)
Administration (70,370)
City Council/Mayor (6,939)
GIS (184,547)
Streets-Sweeping (65,237)
Streets(City Vehicle Maint Program 1581) (42,232)
Engineering (30,747)
Finance(Insurance Admin) (30,000)
Revenues:
From Special Revenue Funds (82,212)
From Liquor Funds (183,876)
From Utility Funds (605,601)
From Internal Service Funds (30,000) i
(13) One-Time Public Safety Aid I
Eahibit A
Revenues:
Intergovernmental 1,850,000
Increase Fund Balance 1,850,000
(14) New Vehicle Purchased by Construction Services
Expenditures:
Capital Outlay Machine&Equipment 53,005
Revenues:
Use of Fund Balance 53,005
(15) Adjust Building Permit Revenues
Revenues:
Building Permits 373,000
Increase Fund Balance 373,000
(16) Separation Payouts-Transfer from Compensated Leave Fund(to be used if needed based on fund bala
Expenditures:
Personnel Services-Arts 13,000
Personnel Services-Streets 91,000
Personnel Services-Patrol 88,000
Personnel Services-Inspections 65,000
Personnel Services-IT 3,000
Personnel Services-Finance 71,000
Revenues:
Transfer from Compensated Leave Fund 331,000
(17) Adjust Workers Compensation Premium Amount
Expenditures:
Personnel Services-Mayor and Council 30
Personnel Services-Committees/Commissions 885
Personnel Services-City Administration 867
Personnel Services-City Clerk 185
Personnel Services-Finance 1,463
Personnel Services-IT 883
Personnel Services-Human Resources 862
Personnel Services-Planning 993
Personnel Services-Community and Economic Development 593
Personnel Services-Inspections 4,523
Personnel Services-General Government Facilities 4,396
Eahibit A
Personnel Services-Police Administration 11,343
Personnel Services-Investigations 27,389
Personnel Services-Patrol 120,724
Personnel Services-Drug Enforcement 2,781
Personnel Services-K-9 Unit 5,434
Personnel Services-Police Reserves 1,058
Personnel Services-Community Service O�cer 2,594
Personnel Services-Records Management 1,157
Personnel Services-School Resource Officer 8,457
Personnel Services-Fire 48,628
Personnel Services-Engineering 1,022
Personnel Services-GIS 432
Personnel Services-Forestry 332
Personnel Services-Construction Services 947
Personnel Services-Streets 32,679
Personnel Services-Parks 28,033
Personnel Services-Recreation 617
Personnel Services-Active Adults 881
Personnel Services-Heritage Center 373
Personnel Services-Arts Center 1,931
Revenues:
Use of Fund Balance 312,492
(18) Payment from Liquor in Lieu of Taxes
Revenues:
General Govt Svc Chrg 54,410
Increase Fund Balance 54,410
(19) Amend the budgeted (estimated)January 1,2023 Fund Balance to reflect the actual January 1 Fund
Balance.
Actual Fund Balance,January 1,2023 22,007,407
Budgeted Fund Balance,lanuary 1, 2023 21,881,813
Increase Fund Balance,January 1,2023 125,594
Total Expenses&Transfers 301,935
Revenues 2,196,866
(Increase)/Use of FB Reserves (1,894,932j
Total Funding 301,935
Use of FB Test
Per above 1,894,932
Exhibit A
Per Gen Summ 1,894,931
Diff(Should be Zero) 1
ExhfbR B
(l) Royal M!k Pmperty Acqrdsitlon-8860 Uppe►208tl�SX,dty proJect 21-26
Amend the Debt Service Fund budget and Improvement Construdion Fund budget for trensfers from the Southfork TIF fund(DSF)to the
Improvement Construction Fund for the Royal Milc property acquisition,demdition,and other related cosu.The flrst tnnsfer amount is based on
actual cosu incurred in 2023 to date.The second Vansfer is an estimate of the mabmum additional cosu to be reported/paid through the end of
2023,but trensfer will be recorded based on adual cosu incurred.
T2nsfer Out(DSF,Southfork TIF,BU 3207► 109,547
Trensfer In(Improvement Construction Fund,BU 6587) 109,547
Trensfer Out(DSF,Southfork TIF,BU 3207) 30,000
Trensfer In(Improvement Construction Fund,BU 6587) 30,000
(2) Lakevflle Arts Center Loadin`dock,cily p►oject f22-19
A)Amend the Park Bonds Fund budget for cosu incurred in 2023 related to the project,which were originally planned for 2022.
B)Amend the Park Dedication Fund and Park Bond Fund budgets for a transfer from the Park Dediwtion Fund to the Park Bond Fund for the
remaining estimated costs of the Arts Center loading dock project that will not be funded by the 2022C bonds or previous uansfero to the project.
This amount is an estimate of the amount that will be needed to cover cosu incurred to date plus remafning 2023 expenses not yet invoiced.
A) Expenditures:
Capital Outlay-Parks and Recreation,BU 4701 223,188
Revenues:
Bond Proceeds(2022C) 223,188
B) 7ransfer Out(CPF,Park Dedication Fund BU 4201) 64,137
Trensfer In(CPF,Park Bonds Fund,LAAC Improvements,BU 4701) 64,137
�a► Rktrr Farm Improvements,dry proJect M22-17
A)Amend the Park Bond Fund budgets for a trensfer of excess 2021C bond proceeds from the Ritter Park desig�phase to the Ritter park consuudion
phase.The amount below is an estimate,as the transfer amount may increase slighdy due to interest revenues applied to project during the
remainder of 2023.Staff is seeking authorizing to move all remaining funds fn BU 4706 to BU 4712 to cover project cosu incuned during the
construction phase of the projea.
B)Amend the Park Dedlcation Fund and Park Bond fund budgets for a transfer from the Park Dedicatio�Fund to the Park Bond Fund for the
remaining estimated cosu of the Ritter park project that will not be funded by the 2021C or 2022C bonds or other contributions to the project.This
amount is an atimate of the amount that will be needed to cover cosu incurred to date plus remaining 2023 e�enses not yet invoiced.Actual
transfer amount will be based on adual cosu incurred.
A� Tronsfer Out(Park Bonds Fund,Ritter Farm CP 22-17,BU 4706) 286,160
Transfer In(Vark Bonds Fund,Ritter Farm CP 22-17,BU 4712) 286,160
B) Transfer Out(CPF,Park Dedication Fund BU 4201) 50,000
Transfer In(Park Bonds Fund,Ritter Farm CV 22-17,BU 4712) 50,000
(a) Poilr�o stpn replacemencs,dtr wek�+�u-2o
Amend the Park Bond Fund budgets for a trensfer of excess 2022C bond proceeds from the Park ID sign replacement project NCP22-20 to the 2024
Avonlea park project q24-O8.Cosu incurred on the project were less than anticipated.The amount below is the maximum transfer amount and will
be adjusted if additional cosu on CP 22-20 are reported in 2023.
A) Expenditures:
Capital Outlay-Parks and Recreation,BU 4702 119,829
Revenues:
Bond Proceeds�2022C� 119,829
B) Transfer Out(Park Bonds Fund,Park ID sign replacements,BU 4702� 65,323
7ransfer In(Park Bonds Fund,Avonlea Park project,BU 4721) 65,323
E�dfibit B
(5) Tro11 Gops projecR,tky pro/ttt N21-17
Amend the Park Bond Fund budgets for a uansfer of excess 2021C bond proceeds from the trail gaps project design phase to the 7reil gaps project
construction phase.The amount below is an atimate,as the transfer amount may increase slightly due to interat revenua applied to project during
the remainder of 2023.Staff is seeking authorizing to move all remaining funds in BU 4705 to BU 4711 to crner project costs fncurced du�ing ffie ',
construction phase of the project.
Transfer Out(Park Bonds Fund,Treil Gaps CP 23-06,BU 4705) 265,597
Transfer In(Park Bonds Fund,Trail Gaps CP 23-06,BU 4711) 265,597
(6) Awn/ta Po►ly dty proJed N2I-08
Amend the Park Dedication Fund and Park eond Fund budgeu for a trensfer from the Park Dedication Fund to the Park eond Fund for the cosu
incurred in 2023 that will not be funded by other transfers to the projecc.The amount below is an estimate and the actual transfer amount will be
based on actual costs incuned through the end of 2023.
Transfer Out(CPF,Park Dedication Fund BU 4201) 504,000
Transier In(CPF,Park Bonds Fund,Avonlea Park,BU 4721) 504,000
(7) Co 21-18,202nd St Exttnslon/Cedar Nilh
Transfer excess funds on this projed to be generally available for any future project in the Improvement Consuudion Fund.
Transfer Out(CPF,Improvement Construction Fund,BU 6583) 13,265
Transfer In(CPF,Improvement Construction Fund,BU 6000) 13,265
(8) qberlPA with ISD 194
Amend the Sanitary Sewer Operating Fund budget for estimated fiber costs on a joint project with District 194,and the related revenues from Distrid
194 for their contribution to the project.
Expenditures:
Gpital Outlay-Public Works(7701.6280) 55,000
Revenues:
IntergovernmentalRevenues(7700.4350) 75,000
Net assets 50,000
(9) ��e of qne Ar[s BuU�np(Jomxr ALC buU�np}20950 Howland Ave
The opportunity to purchase this building presented iuelf during 2023.Council approved the purchase earlier in 2023,but the Building Fund budget
needs an amendment for the following amounu related to the building purchase and the costs incurred to ready the space for use as the Fine Arts
Building in 2023.
Expenditures:
Capital Outlay-Parks&Recreation(building purchase) 1,193,256
Capital Outlay-Parks&Recreation(building repairs/engineering/other) 68,275
Revenues:
Transfer in from Liquor Fund/Use of Fund balance 1,261,531
(10) TronsJer oJnmaJnirp Forcsby-rolaped Junds Jrom Emiironmentol Resources FwM to General Fund.
The Forestry division moved ftom an Enterprise Fund to the Generel Fund effective 1/1/23.The original budget of$185K for 2023 eupenses was
trensferred from F7455 and included in the 2023 adopted budget.Calculating final expenses vs budgeted historical amounu for the Forestry activities
resulted in an additional trensfer amount of 5157,169,for a total of$342K transfer in 2023.
Expenditures:
Tronsfer out of E�viro�mental Resources Fund(7455.7430) 157,169
Revenues:
Trensfer into General Fund(1000.5410) 157,169
(11) CommunitaUons Fund amendments
A)2022 Councfl chambers microphone project carryover(move to 2023 budget)
B)Add office furniture and equipment for new employee to 2023 budget
C)Add new quarterly print newsletter to 2023 budget
D)Adjust for unanticipated cost increase for Cfvicplus website annual fees in 2023
A) Expenditures:
Gpital Outlay-PEG-eligible capital outlay(2009.6540) 21,419
Revenues:
Exhibk B
fund balance 21,419
B) Ezpenditures:
Capital Outlay-PEG-eligible capital outiay(2009.6540) 14,000
Revenues:
Fund balance 14,000
[) Expenditures:
Generel Government-Print newsletter(2007.6252) il,%1
Revenues:
Fund balance 11,%1
(12) State of Minnesota Aidfor Pubifc Safety
The City anticipates receiving$1,306,564 of ono-time aid for public safety(police/flre)toward the end of December 2023.SWff is proposing Council
provide flexibility for Staff to amend either the Equipment Fund or Building Fund budget(or a combination of both)upon receipt of this amount.Staff
is cunently discussing options for using these funds for public safety equipment purchasa and/or fire infnstructure improvements.
Revenues:
Intergovernmental Revenues(4300.4280 or 4000.4280) 1,306,564
Increasefund balance(Restricted) 1,306,564
(13) ReclassifkaUon of intn-eMky cash flows
7he adopted 2023 and 2024 budgets include trensfers into the General Fund from Enterprise and Special Revenue funds for services provided by
6eneral Fund departmenu(IT support,HR support,City Hall building ovefiead,other General Fund department staff support�.Recent clariflcation
from GFOA(Government Finance Officers Association)indicates that these internal resource flows should be recorded as cost allocations instead of
tronsfers.This change resulu in NO net impact to the General Fund,however,Staff needs a formal budget amendment for 2023 and 2024 to correct
the prese�tation.The amounu by fund and by year are Iisted below.
�� �
Budgets as adopted indude the following transfers IN to General Fund:
FROM SPEqAL REVENUE FUNDS $2,212 86,493
FROM LIQUOR FUNDS 268,286 269,036
fROM UTILITY FUNDS 790,601 665,886
FROM INTERNAL SERVICE FUNDS 30,000 30,000
1,171,099 1,051,415
AmouiKs above that will be shHted to cost alloaUons into the folbwing funds:
Expenditures•
Water Operating Fund-Personnel/Commodities/Other contrectual 198,523 212,772
Sanitary Sewer Operating Fund-Personnei/Commodities/Other contractual 200,368 209,591
Environmental Resources Fund-Personnel/Commodities/Other contractual 201,225 238,097
Street Light Operoting Fund-Personnel/Commodities/Other contractual 5,485 5,426
Liquor Fund-Personnel/Commodities/Other contractual 183,876 184,626
Municipal Reserves Fund-Personnel/Commodities/Other contrectual 30,000 30,000
Communications Fund-Personnel/Commodities/Other contractual 82,212 86,493
901,689 967,005
•Amounts are summarized here and will be recorded to various expenditure accounts 6osed on rnst type.
Remove trensfers IN to Generel Fund
FROM SPECIAL REVENUE FUNDS (82,212) �86,493)
FROM LIQUOR FUNDS (383,876) (184,626)
FROM UTIIITY FUNDS (605,601) (665,886)
FROM INTERNAL SERVICE FUNOS (30,000) (30,000)
(901,689) (967,005)
Expenditures:
Liquor Fund-Payment in lieu of taxes(property taz expense) 54,410 54,430
Revenues:
General Fund-3000.4350(Charges for services) 54,410 54,430
AmourKs that will rcmain as transfers(ra budget amendmern needed)
Exhibit B
Liquor Fund-Firework contriobuition 30,000 30,000
Forestry transfer from Environmental Resources Fund 185,000
215,000 30,000
Total 1,171,099 1,051,415