HomeMy WebLinkAboutItem 06.o
December 3, 2018 Item No.
RESOLUTION AMENDING THE 2018 GENERAL FUND,
COMMUNICATIONS FUND, BUILDING FUND, IMPROVEMENT
CONSTRUCTION FUND AND LIQUOR FUND BUDGETS
Proposed Action
Staff recommends adoption of the following motion: Move to approve the Resolution Amending
the 2018 General Fund, Communications Fund, Building Fund, Improvement Construction Fund
and Liquor Fund Budgets.
Overview
Various events have transpired during the year which require an adjustment to the 2018 budget.
Various amendments have been approved by the City Council during the year. Approval of this
resolution authorizes the amendment of the budget to more accurately reflect changes in
operations.
Final
Adopted YTD 12/3/2018 Amended
Budget Amended Amendment Budget
Revenues 26,907,063$ 26,917,063$ 278,716$ 27,195,779$
Expenditures 27,753,295 27,763,295 624,454 28,387,749
Excess (Deficiency) (846,232) (846,232) (345,738) (1,191,970)
Other Financing Sources (Uses) 104,368 (20,632) (172,162) (192,794)
Net Change in Fund Balance (741,864) (866,864) (517,900) (1,384,764)
Fund Balance, January 1 14,288,353 14,288,353 840,570 15,128,923
Fund Balance, December 31 13,546,489$ 13,421,489$ 322,670$ 13,744,159$
Final
Adopted YTD 12/3/2018 Amended
Budget Amended Amendment Budget
Revenues 753,002$ 753,002$ 22,007$ 775,009$
Expenditures 996,287 996,287 94,573 1,090,860
Excess (Deficiency) (243,285) (243,285) (72,566) (315,851)
Other Financing Sources (Uses) 176,322 176,322 35,735 212,057
Net Change in Fund Balance (66,963) (66,963) (36,831) (103,794)
Fund Balance, January 1 331,225 331,225 271,951 603,176
Fund Balance, December 31 264,262$ 264,262$ 235,120$ 499,382$
General Fund
Communications Fund
Final
Adopted YTD 12/3/2018 Amended
Budget Amended Amendment Budget
Revenues 414,076$ 880,257$ -$ 880,257$
Expenditures 714,971 778,152 22,162 800,314
Excess (Deficiency) (300,895) 102,105 (22,162) 79,943
Other Financing Sources (Uses) 300,000 300,000 22,162 322,162
Net Change in Fund Balance (895) 402,105 - 402,105
Fund Balance, January 1 713,008 713,008 - 713,008
Fund Balance, December 31 712,113$ 1,115,113$ -$ 1,115,113$
Final
Adopted YTD 12/3/2018 Amended
Budget Amended Amendment Budget
Revenues 673,315$ 673,315$ -$ 673,315$
Expenditures 12,086,013 12,086,013 - 12,086,013
Excess (Deficiency) (11,412,698) (11,412,698) - (11,412,698)
Other Financing Sources (Uses) 11,412,698 11,412,698 150,000 11,562,698
Net Change in Fund Balance - - 150,000 150,000
Fund Balance, January 1 279,959 279,959 657,265 937,224
Fund Balance, December 31 279,959$ 279,959$ 807,265$ 1,087,224$
Final
Adopted YTD 12/3/2018 Amended
Budget Amended Amendment Budget
Revenues 15,003,435$ 15,003,435$ -$ 15,003,435$
Expenditures 14,209,309 14,209,309 - 14,209,309
Excess (Deficiency) 794,126 794,126 - 794,126
Other Financing Sources (Uses) 977,634 977,634 35,735 1,013,369
Net Change in Fund Balance 1,771,760 1,771,760 35,735 1,807,495
Net Position, January 1 4,245,048 4,245,048 121,281 4,366,329
Net Position, December 31 6,016,808$ 6,016,808$ 157,016$ 6,173,824$
Improvement Construction Fund
Liquor Fund
Building Fund
Detailed explanations for the adjustments are included as part of the exhibits to the resolution.
Primary Issues to Consider
N/A
Supporting Information
Resolution
o Exhibit A: General Fund
o Exhibit B: Communications Fund
o Exhibit C: Building Fund
o Exhibit D: Improvement Construction Fund
o Exhibit E: Liquor Fund
Financial Impact: $ Budgeted: Y☐ N☐ Source:
Related Documents: (CIP, ERP, etc.):
Envision Lakeville Community Values: Good Value for Public Services
Report Completed by: Jerilyn Erickson, Finance Director
See attached Various
2018 Budget
CITY OF LAKEVILLE
RESOLUTION NO. ________
RESOLUTION AMENDING THE 2018 GENERAL FUND,
COMMUNICATIONS FUND, BUILDING FUND, IMPROVEMENT
CONSTRUCTION FUND AND LIQUOR FUND BUDGETS
BE IT RESOLVED by the City Council of the City of Lakeville, Minnesota that the 2018 General
Fund budget, the 2018 Communications Fund budget, the 2018 Building Fund budget, the 2018
Improvement Construction Fund budget and the 2018 Liquor Fund Budget are hereby amended
for the fiscal year ending December 31, 2018 as per Exhibit A, B, C, D and E, as attached hereto.
ADOPTED by the Lakeville City Council this 3rd day of December 2018.
________________________________
Douglas P. Anderson, Mayor
________________________________
Charlene Friedges, City Clerk
Exhibit A
2018 2018 2018 2018 2018 2018
YTD 12/3/2018 Final
Adopted Amendment Amendment Amended Adjust Amended
Budget Res. No. 18-099 Res. No. 18-063 Budget Res. No. 18-###Budget Notes
Revenues
General property taxes 20,055,586$ -$ -$ 20,055,586$ -$ 20,055,586$
Licenses and permits 2,356,882 - - 2,356,882 30,000 2,386,882 (4)
Intergovernmental 1,005,921 - - 1,005,921 35,966 1,041,887 (1)(7)
Charges for services 2,926,300 - - 2,926,300 212,750 3,139,050 (3)(11)(12)
Court fines 425,000 - - 425,000 - 425,000
Investment income 90,071 - - 90,071 - 90,071
Miscellaneous 47,303 - 10,000 57,303 - 57,303
Total revenues 26,907,063 - 10,000 26,917,063 278,716 27,195,779
Expenditures
General government
Mayor and Council 107,230 - - 107,230 - 107,230
Committees and Commissions 87,600 - 10,000 97,600 - 97,600
City administration 478,570 - - 478,570 - 478,570
City Clerk 201,157 - - 201,157 14,000 215,157 (2)
Legal counsel 80,000 - - 80,000 - 80,000
Planning 585,768 - - 585,768 - 585,768
Community and econ. development 366,222 - - 366,222 21,900 388,122 (7)
Inspections 1,225,953 - - 1,225,953 30,000 1,255,953 (4)
General government facilities 557,962 - - 557,962 11,900 569,862 (8)
Finance 781,534 - - 781,534 - 781,534
Information systems 673,236 - - 673,236 - 673,236
Human resources 511,685 - - 511,685 12,000 523,685 (6)
Insurance 285,000 - - 285,000 140,000 425,000 (15)
Public safety
Police 11,259,374 - - 11,259,374 172,838 11,432,212 (3)(13)
Fire 1,855,127 - - 1,855,127 35,066 1,890,193 (1)(9)
Public works
Engineering 974,588 - - 974,588 - 974,588
Operations and Maintenance 587,152 - - 587,152 - 587,152
Streets 3,194,298 - - 3,194,298 169,000 3,363,298 (10)
Parks and recreation
Parks 2,643,982 - - 2,643,982 - 2,643,982
Recreation 700,028 - - 700,028 9,750 709,778 (12)
Heritage Center 129,549 - - 129,549 - 129,549
Arts Center 510,370 - - 510,370 8,000 518,370 (11)
Other (43,090) - - (43,090) - (43,090)
Total expenditures 27,753,295 - 10,000 27,763,295 624,454 28,387,749
Excess (deficiency) of revenues
over expenditures (846,232) - - (846,232) (345,738) (1,191,970)
Other financing sources (uses)
Transfer from other funds 765,232 - - 765,232 - 765,232
Transfer to other funds (660,864) (125,000) - (785,864) (172,162) (958,026) (13)(14)
Committed Fund Balance - EAB - - - - - -
Total other financing sources (uses) 104,368 (125,000) - (20,632) (172,162) (192,794)
Net change in fund balance (741,864) (125,000) - (866,864) (517,900) (1,384,764) (2)(6)(8)(9)
(10)(14)(15)
Fund balance, January 1 14,288,353 14,288,353 840,570 15,128,923 (5)
Fund balance, December 31 13,546,489$ 13,421,489$ 322,670$ 13,744,159$
2018 GENERAL FUND BUDGET
Exhibit A
(1)
Expenditures:
Other Charges and Services 14,066
Revenues:
Intergovernmental 14,066
(2)
Expenditures:
Commodities 3,100
Other Charges and Services 10,900
Revenues:
Use of Fund Balance 14,000
(3)
Expenditures:
Personnel Services 195,000
Revenues:
Charges for Services - Police Security Services 195,000
(4)
Expenditures:
Other Charges and Services 30,000
Revenues:
Permits - Electrical 30,000
(5)
Actual Fund Balance, January 1, 2018 15,128,923
Budgeted Fund Balance, January 1, 2018 14,288,353
Increase Fund Balance, January 1, 2018 840,570
(6)
Expenditures:
Other Charges and Services 12,000
Revenues:
Use of Fund Balance 12,000
Amend Fire Relief Association contribution resulting from increase in state aid.
Amend the City Clerk elections budget to reflect the addional costs of supplies required for the new
voting equipment and additional hours worked by the election judges.
Amend the Inspections Department budget to account for the increase in contractual electrical
inspections expense and the offsetting electrical permit revenues.
Amend the budgeted (estimated) January 1, 2018 Fund Balance to reflect the actual January 1 Fund
Balance.
Amend the Human Resources budget to carry forward appropriations in the 2017 Adopted Budget
for the Compensation and Classification Study completed in 2018.
Amend the Police Department for security coverage at Samaritan's Purse during the months of
Nobember and December.
Exhibit A
(7)
Expenditures:
Other Charges and Services - DARTS bus services 6,900
Other Charges and Services - DARTS Senior Chores/Repairs 15,000
Revenue:
Intergovernmental 21,900
(8)
Expenditures:
Personnel Services 11,900
Revenues:
Use of Fund Balance 11,900
(9)
Expenditures:
Personnel Services 21,000
Revenues:
Use of Fund Balance 21,000
(10)
Expenditures:
Commodities 169,000
Other Charges and Services -
Revenues:
Use of Fund Balance 169,000
(11)
Expenditures:
Other Charges and Services 8,000
Revenue:
Charges for Services - Facility Rental 8,000
(12)
Expenditures:
Other Charges and Services 9,750
Revenue:
Charges for Services - Recreation Program Revenues 9,750
Amend General Government Facilities for added health insurance election that was previously
waived.
Amend the Fire Department for increase WC insurance rate increase determined after the budget
preparation.
Amend the Street Department budget for additional salt purchased for inventory.
Amend the Recreation Department for increases other contractual services resulting from increase
recreation program revenues.
Amend arts center facility budget for the cost to Charter for fiber contract and increase in contracted
performers. Increase is offset by increases in rental income.
Amend the Community and Economic Development budget for Darts bus service (6,900) and senior
chores/repairs (8,000) funded by CDBG.
Exhibit A
(13)
Expenditures:
Other Charges and Services (22,162)
Transfers out 22,162
(14)
Expenditures:
Transfers out 150,000
Revenues:
Use of Fund Balance 150,000
(15)
Expenditures:
Other Charges and Services 140,000
Revenues:
Use of Fund Balance 140,000
Total Expenses 796,616
Revenues 278,716
Use of FB Reserves 517,900
Total Funding 796,616
Amend the General Fund insurance allocation to the Municipal Reserves Fund.
Amend the Police Department budget to transfer unused appropriations from the operating budget to
the Building Fund to cover the additional cost of the building display project.
Amend the general fund transfers to transfer $150,000 to the Improvement Construction Fund for
street reconstruction design costs.
Exhibit B
2018 2018 2018
YTD 12/3/2018 Final
Amended Adjust Amended
Budget Res. No. 18-###Budget Notes
Revenues
Franchise fees 688,473$ 688,473$
P.E.G. fees 60,858 60,858
State-aid pensions 516 516
Charges for services - 22,007 22,007 (5)
Investment income 3,155 - 3,155
Total Revenues 753,002 22,007 775,009
Expenditures
Personnel services 446,728 446,728
Commodities 9,279 9,279
Other charges and services 488,930 94,573 583,503 (3)(4)(5)
Capital outlay 51,350 - 51,350
Total Expenditures 996,287 94,573 1,090,860
Other financing sources/(uses)
Transfer from General Fund 260,864 - 260,864
Transfer from Enterprise Funds 169,121 35,735 204,856 (2)
Transfer to General Fund (78,663) (78,663)
Transfer to Improvement Constr. Fund (175,000) - (175,000)
Total Transfers 176,322 35,735 212,057
Net Change in Fund Balance (66,963) (36,831) (103,794) (2)(3)(4)
Fund Balance, January 1 331,225 271,951 603,176 (1)
Fund Balance, December 31 264,262$ 235,120$ 499,382$
2018 COMMUNICATIONS FUND BUDGET
Exhibit B
(1)Adjust the budgeted (estimated) January 1, 2018 Fund Balance to reflect the
actual January 1 Fund Balance
Actual Fund Balance, January 1, 2018 603,176
Budgeted Fund Balance, January 1, 2018 331,225
Increase Fund Balance, January 1, 2018 271,951
(2)Amend transfers in to include the Liquor Fund's share of the Marketing
Specialist costs incurred in 2017. The transfer was appropriated in 2017 but
was inadvertently missed in 2017.
Other Financing Sources:
Transfers In - Enterprise Fund 35,735
Increase Fund Balance 35,735
(3)Amend the 2018 adopted budget for the Phase II Fiber Project that was carried
over from 2017. Funding from other funds was transferred in 2017 and
adjustments to 2018 based on actual costs.
Expenditures:
Other Charges and Services - Fiber Project Phase II 242,148
Revenues
Use of Fund Balance 242,148
(4)Amend the 2018 adopted budget for the Phase III Fiber Project that will be
carried over to 2019. (Will be referred to as Phase IV). Funding from other
funds to remain in 2018.
Expenditures:
Other Charges and Services - Fiber Project Phase III (169,582)
Increase Fund Balance 169,582
Total Expenses 72,566
(5)Amend the 2018 budget for Dakota County's share of the fiber cost. (Phase III)
Expenditures:
Other Charges and Services - Fiber Project Phase III 22,007
Revenues
Charges for services 22,007
Revenues 57,742
Use of FB Reserves 36,831
Total Funding 94,573
Exhibit C
2018 2018 2018
2018 Res. 18-099 Res. 18-131 Final 12/3/2018 Final
Adopted 9/17/2018 11/5/2018 Amended Adjust Amended
Budget Adjust Adjust Budget Res. 18-###Budget Notes
Revenues
General property taxes 400,000$ -$ -$ 400,000$ -$ 400,000$
Charges for services - Antenna Rental - 403,000 403,000 - 403,000
Investment income 14,076 - - 14,076 - 14,076
Donations - - 63,181 63,181 - 63,181
Total revenues 414,076 403,000 63,181 880,257 - 880,257
Expenditures - Capital outlay
General government 149,500 - - 149,500 - 149,500
Public safety
Police 113,486 - - 113,486 22,162 135,648 (1)
Fire 40,350 - - 40,350 - 40,350
Public works 46,000 - - 46,000 - 46,000
Parks and recreation 365,635 - 63,181 428,816 - 428,816
Total expenditures 714,971 - 63,181 778,152 22,162 800,314
Excess (deficiency) of revenues
over expenditures (300,895) 403,000 - 102,105 (22,162) 79,943
Other financing sources (uses)
Transer from - 'General Fund 300,000 - - 300,000 22,162 322,162 (1)
Total other financing sources (uses)300,000 - - 300,000 22,162 322,162
Net change in fund balance (895) 403,000 - 402,105 - 402,105
Fund balance, January 1 713,008 713,008 713,008
Fund balance, December 31 712,113$ 1,115,113$ 1,115,113$
2018 BUILDING FUND BUDGET
Exhibit C
(1)
Expenditures:
Capital Outlay - Police (22,162)
Transfers in - General Fund 22,162
Amend the Police Department budget to transfer unused appropriations from the operating
budget to the Building Fund to cover the additional cost of the building display project.
Exhibit D
2018
2018 Res. 18-### Final
Adopted 12/3/2018 Amended
Budget Adjust Budget Notes
Revenues
General property taxes 50,000$ -$ 50,000$
Intergovernmental 457,500 - 457,500
Investment income - - -
Miscellaneous (Escrow)165,815 - 165,815
Total revenues 673,315 - 673,315
Expenditures - Capital outlay
Public works 12,086,013 - 12,086,013
Total expenditures 12,086,013 - 12,086,013
Excess (deficiency) of revenues
over expenditures (11,412,698) - (11,412,698)
Other financing sources (uses)
Transfer from
General Fund - 150,000 150,000 (1)
Communications Fund 175,000 - 175,000
Water Operating Fund 230,000 230,000
Issuance of Debt 11,007,698 - 11,007,698
Total other financing sources (uses)11,412,698 150,000 11,562,698
Net change in fund balance - 150,000 150,000
Fund balance, January 1 279,959 657,265 937,224 (2)
Fund balance, December 31 279,959$ 1,087,224$
2018 IMPROVEMENT CONSTRUCTION FUND BUDGET
Exhibit D
(1)
Revenues:
Transfers In - General Fund 150,000
Increase Fund Balance 150,000
(2)
Actual Fund Balance, January 1, 2018 937,224
Budgeted Fund Balance, January 1, 2018 279,959
Increase Fund Balance, January 1, 2018 657,265
Amend the 2018 transfers in from General Fund for street reconstruction design costs.
Amend the budgeted (estimated) January 1, 2018 Fund Balance to reflect the actual January 1
Fund Balance.
Exhibit E
2018
2018 Res. 18-### Final
Adopted 12/3/2018 Amended
Budget Adjust Budget Notes
Sales and cost of sales
Sales 15,003,435$ -$ 15,003,435$
Cost of sales 11,307,073 - 11,307,073
Gross profit 3,696,362 - 3,696,362
Operating expenses
Personnel services 1,693,665 - 1,693,665
Commodities 77,818 - 77,818
Other charges and services 1,037,408 - 1,037,408
Total operating expenses 2,808,891 - 2,808,891
Operating income 887,471 - 887,471
Non-operating revenue (expense)
Intergovernmental 3,900 - 3,900
Investment income 19,110 - 19,110
Miscellaneous 3,600 - 3,600
Disposal of assets (net)1,799,601 - 1,799,601
Total non-operating (net)1,826,211 - 1,826,211
2,713,682 - 2,713,682
Transfers to other funds (848,577) (35,735) (884,312) (2)
Depreciation (93,345) - (93,345)
(941,922) (35,735) (977,657)
Change in net position 1,771,760 (35,735) 1,736,025
Net position, January 1 4,245,048 121,281 4,366,329 (1)
Net position, December 31 6,016,808$ 85,546$ 6,102,354$
Capital outlay acquisitions 7,300$ -$ 7,300$
2018 LIQUOR FUND BUDGET
Income before transfers, bond
expense, and depreciation
Total transfers, bond expense and
depreciation
Exhibit E
(1)Adjust the budgeted (estimated) January 1, 2018 Net Position to reflect the
actual January 1 Net Position.
Actual Net Position, January 1, 2018 4,366,329
Budgeted Net Position, January 1, 2018 4,245,048
Increase Net Position, January 1, 2018 121,281
(2)Amend transfers in to include the Liquor Fund's share of the Marketing
Specialist costs incurred in 2017. The transfer was appropriated in 2017 but
was inadvertently missed in 2017.
Other Financing Uses:
Transfer To - Communications Fund 35,735
Decrease Net Position 35,735