HomeMy WebLinkAboutItem 51
City of Lakeville
Finance Department
Memorandum
To: Mayor and City Council
From: Justin Miller, City Administrator
Jerilyn Erickson, Finance Director
Date: August 26, 2019
Subject: 2020 Preliminary Budget & Property Tax Levy;
CIP-Equipment, Facility & Technology Plans
The purpose of this report is to provide the City Council with an overview of community growth,
proposed 2020 property tax levy, property tax supported-funds, primary drivers of the revenues
and expenditure changes in the General Fund as well as the impact of such on the median valued
home, commercial property and fund balance reserves.
City staff has been preparing their 2020 budget requests over the past few months. The
proposed budgets reflect some of additional resources needed because of community growth,
increased costs for personnel, commodities, replacement of existing vehicles and equipment,
technology updates and maintenance of facilities.
Community Growth
The City of Lakeville has experienced significant growth during these past ten years. Since 2010,
growth from new construction has added $1.30 billion to the taxable market value of which $899
million or 69% of the growth has occurred in the past five years. The following chart provides a
breakdown of that growth:
Type 10-Yr Growth 5-Yr Growth
Residential $ 1,096,491,700 84.0% $ 761,217,400 84.6%
Commercial/Industrial 112,880,400 8.7% 84,097,500 9.4%
Apartments 93,993,200 7.2% 53,555,700 6.0%
Other 1,159,700 0.1% 267,500 0.0%
Total $1,304,525,000 100.0% $ 899,138,100 100.0%
The population has grown from 55,954 in 2010 (U.S. Federal Census) to approximately 65,000
(16% growth). As we add commercial and industrial businesses, this also increases the amount
of traffic and number of people requiring services from the City (i.e. streets, parks, police, fire,
2
etc). The following chart reflects capital asset statistics as shown in the 2018 Comprehensive
Annual Financial Report:
2010 2018 CAFR* Change (#) Change (%)
City Streets (miles)259 295 36 13.9%
Acres of parks, conservation areas,
and greenways
1,579 1,600 21 1.3%
Trails and sidewalks (paved miles) 97 117 20 20.6%
Playgrounds 41 46 5 12.2%
Utility:
Water mains (miles)311 350 39 12.5%
Fire hydrants 3,386 3,885 499 14.7%
Wells 17 19 2 11.8%
Water Towers 5 6 1 20.0%
Sanitary sewer mains (miles)259 264 5 1.9%
*Comprehensive Annual Financial Report (CAFR)
Preliminary taxable market values have increased $752 million or 10.2% from 2019 to 2020, of
which approximately $235 million or 3.2% is from new construction. Based on the 2019 tax rate,
new construction will generate about $917,000 in property taxes. This equates to about 3.06% of
the 2019 property tax levy.
City Tax Rate
The City has been fortunate to keep its tax rate relatively low. Since 2013, the tax rate has
declined primarily due to significant new construction growth.
0.33973
0.41234
0.34827
0.00000
0.05000
0.10000
0.15000
0.20000
0.25000
0.30000
0.35000
0.40000
0.45000
2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020
Est
City of Lakeville Tax Capacity Rates
3
Proposed Property Tax Levy
The following chart provides a guide for establishing the 2020 tax levy based on factors that
impact the Lakeville community:
Growth (New Construction) 3.20%
CPI-U (MSP)# 2.80%
Debt Service 1.61%
Total 7.61%
# Dec 2018 to July 2019
The proposed 2020 property tax levy is comprised of the following components:
Fund Proposed
2020
Levy
Change
from 2019
($)
General Fund $22,561,400 $1,217,330
Street Reconstruction 0 0
Pavement Management Fund 1,100,000 0
Building Fund 0 0
Equipment Fund 675,000 423,000
Park Improvement Fund 350,000 175,000
Trail Improvement Fund 0 0
Debt Service Funds 7,560,365 482,545
TOTAL LEVY $32,246,765 $2,297,875
The proposed 2020 tax levy includes an additional $2.3 million to fund ongoing services to the
community, replacement of capital assets, and to make payments on the City’s $120 million of
debt. The estimated tax capacity rate is 34.827%, which equates to a 2.2% decrease from the 2019
tax rate of 35.607%. The estimated 2020 tax rate is the lowest since 2010.
Impact on Median Valued Home and Commercial Property
The median valued home value increased 7.85% from $304,600 to $328,500. A $2.3 million
increase in the property tax levy would result in the city portion of the property taxes increasing
by approximately $68. The additional $68 will provide resources for the following Funds:
Fund Amount
General Fund $35.89
Equipment Fund 12.47
Park Improvement Fund 5.16
Debt Service Funds 14.23
Total $67.74
Existing commercial properties in Lakeville, in the aggregate, increased in market value by 3.7%.
The proposed 2020 City tax levy will result in an estimated $108 increase on a commercial
property valued at $1 million with a 3.7% increase in value.
4
Primary Drivers of Revenue Changes in the General Fund
The primary drivers of the change in revenues for the preliminary 2020 General Fund budget are
as follows:
General Fund Revenues Totals
Property Taxes 1,205,000$
Licenses & Permits 243,000
Licenses 6,000
Permits* 237,000
Intergovernmental 38,000
Fire Relief State Aid 11,000
Art Center Grant 19,000
Downtown Development Guide (6,000)
Elections - State reimbursment 19,000
Other Grants (Traffic Safety/Met Council) (5,000)
Charges for Services 233,000
General Governement 4,000
Public Safety 4,000
Public Works 116,000
Recreation 109,000
Court Fines 14,000
Investment income 8,000
Donations/Other (2,703)
Total 1,738,297
Change shown from 2019 Amended Budget
*Single family building permits are budgeted at 350 for 2020.
Primary Drivers of Expenditure Changes in the General Fund
The primary drivers of the change in expenditure levels for the preliminary 2020 General Fund
budget are as follows:
5
General Fund Expenditures Totals
Personnel: 1,339,532$
2019 New Positions-Transition to Full Year for 2020 61,400
2020 New Positions 145,000
2020 Fire Department Transition to Pay-Per-Hour 14,000
2020 COLA 481,000
2019 Step Increases 166,000
2019 Compensation Study Impact 232,000
Workers Compensation 32,000
Health/Dental Insurance (196,000)
Police & Fire PERA Rate Increase 89,000
Change in Benefits-FICA, Medicare, PERA, etc. 208,000
Election-Judges/Staff Overtime 96,000
Other 11,132
Commodities: 122,494
De-icing Chemicals 117,000
Motor Fuels 23,000
Street Equipment Parts 12,800
Police - Clothing Replacement (15,000)
Other Departments (15,306)
Other Charges/Services: 281,867
City Wide - LOGIS 57,000
Association of Metro. Municipalities Membership 6,500
City Clerk-Election Supplies 8,000
Planning - Zoning Ordinance (10,000)
Community Development - Open To Business Program 8,300
Community Development - Strategic Plan Update (6,000)
Inspections - Contractual Electrical Inspector 10,000
Finance - Financial Software Needs Analysis 10,000
Human Resources - City-Wide Employee Training 10,000
Police - Attorney Fees (Body-Worn Cameras) 22,000
Police - Body-Worn Cameras Support/Storage 56,000
Police - In-Car Video Support/Storage 32,000
Police - Taser Support Agreement 15,000
Police - DCC Operations (14,780)
Police - Civil Defense Siren Relocation 13,000
Fire Station Building Maintenance (Various) (16,000)
Fire - Streetwise (MDT/CAD Link) 10,000
Engineering - Construction Management Software 6,500
Streets - Overhead Door Maintenance (7,000)
Street - HVAC/Boiler Repair and Maintenance (7,000)
Parks-Major Maintenance Projects 14,000
Recreation Programs 12,000
Heritage Center - Building & Equipment Repairs/Maintenance 13,000
Art Center - Contractual Services 13,000
Art Center Building Maintenance Projects (4,000)
Other Departments 30,347
Capital Outlay: 8,125
Total 1,752,018$
Change shown from 2019 Amended Budget
6
Personnel Requests
New positions or position changes included in the 2020 proposed budget:
o General Fund:
Community & Economic Development – Promotion from Economic
Development Specialist to Economic Development Coordinator
Police Dept – Police Officer - effective 04/01/2020 (full-time)
Streets Dept – Maintenance II – effective 07/01/2020 (full-time)
Police Dept – Police Officer - effective 12/15/2020 (full-time)
o Utility Funds:
Engineering Dept – GIS Technician (04/01/2020)
New positions/reclassifications requested but NOT included in the 2020 proposed
budget:
o Facilities Dept – Facility Attendant (increase in hours)
o Fire Dept – Administrative Assistant (change from part-time to full-time)
o Fire Dept – Fire Inspector (04/01/2020) Proposed grant funded
o Fire Dept – Duty Crew (Extended shifts to include Friday night-Sunday)
o Parks – Maintenance III (Seasonal)
The financial impact of the new positions included the General Fund budget is approximately
$166,300 (personnel and other commodity costs).
Preliminary Yearend 2019 Estimates
The following chart provides a summary of the anticipated changes in revenues and expenditures
for 2019 and the impact on the fund balance:
Fund Balance
The Fund Balance Policy states that the City will endeavor to maintain an unrestricted fund
balance in the General Fund of an amount not less than 40% and not greater than 50% of the
next year’s budgeted expenditures of the General Fund.
2019 2019 Variance
Budget YE Estimate Positive (Negative)
Revenues 27,954,927 29,670,647 1,715,720
Expenditures 28,796,909 29,024,879 (227,970)
Excess (deficiency) of revenues over
expenditures (841,982) 645,768 1,487,750
Transfers from other funds 766,482 766,482 -
Transfers to other funds (630,000) (1,185,000) (555,000)
Net change in fund balance (705,500) 227,250 932,750
7
Staff is recommending the following additional transfer in 2019 of General Fund reserves (from
2019 operations) which will result in an estimated reserve balance of 48.6% at 12/31/2019:
Use of Funds
Equipment Fund $400,000
Technology Fund 155,000
TOTAL $555,000
The preliminary 2020 budget includes the use of reserves for one-time or long-term purchases as
follows:
Use of Funds
Equipment Fund $350,000
Building Fund 200,000
Elections (1/2) 65,000
Ordinance Updates 23,050
Civil Defense Siren Relocation 13,000
TOTAL $651,050
The following table shows the estimated impact on the General Fund reserve balance at year
ending 12/31/2020:
Levy
Proposed
Change ($) Change (%) FB/Est 2021 Exp*
$32,246,765 $2,297,875 7.67% 44.8%
*2021 Expenses include 3% growth plus transition costs, but no additional positions
25.0%
30.0%
35.0%
40.0%
45.0%
50.0%
55.0%
60.0%
YE 2015 YE 2016 YE 2017 YE 2018 Projected YE
2019
Projected YE
2020
General Fund
Fund Balance
Target Range
8
Street Reconstruction
Due to the many demands on the property tax levy, the levy designated for funding a portion of
the City’s share of the street reconstruction projects was eliminated for 2020.
Pavement Management Fund
The proposed tax levy includes $1,100,000 to be designated for funding the City’s pavement
management program. No change from 2019.
Facility Plan
A Facilities Plan has been established to determine what the long-term funding needs are for
maintaining the City’s buildings. The Facilities Plan summary shows the uses of funds by facility
and the various funding sources. Starting in 2019, the primary funding source is antenna
revenue received from cellular carriers. Staff will seek other funding sources when appropriate
such as energy rebates. As directed by the Council during the discussion about the energy
savings improvement project with APEX, the lighting upgrades at many of the city facilities has
been incorporated in the Plan over a span of years (see below).
The Facilities Plan strives to provide a stable funding source recognizing that the expenditures
will fluctuate from year to year. The Plan reflects a transfer of $200,000 in both 2020 and 2021
from the General Fund.
Major facility improvements planned in 2020 include:
Arts Center
o Exterior masonry repairs;
o Balcony and stairs carpet replacement;
o Lobby & restroom panting;
o Furniture for manager’s office;
o Loading dock/elevator engineering study;
Central Maintenance Facility
o Trench drain replacement;
o Lighting upgrades;
City Hall
o Lobby remodel and reception desk upgrade;
o Rooftop unit replacement;
o Landscape and front entrance sidewalk replacement;
o Card access system;
o Emergency back-up generator replacement;
Fire Department
o FS#1 – Lighting upgrades;
o FS#4 – RTU #3 & unit heater #1 & #2 replacements;
9
Heritage Center
o Lighting upgrades;
o Carpet and VCT replacement;
o Divider walls for game room;
o Atrium chairs;
o Office workstations;
Police Department
o Investigations sit-stand workstations;
o Office chairs;
o Carpet replacement (Investigations/conference rooms/other areas);
o Front bollard termination & add pole lights;
Liquor Stores
o Galaxie – checkout counter wrap;
o Heritage – Replace receiving door;
o Heritage – Replace condenser unit;
o Heritage – Office furniture;
Water Treatment Facility
o Condenser replacement;
o Gate controllers;
o Epoxy floors in lunchroom, halls, supervisor’s office and Gopher State room;
o Lobby & office furniture;
o Well #6 roof replacement;
o PLC replacement;
o Automatic shut off for chlorine tanks;
o Boiler plant replacement;
o Air compressor replacement;
Major facility improvements requested but not included in 2020:
Arts Center
o Storage building repairs ($41,000) – Removed from plan;
o Lighting upgrades ($27,000) – Delayed to 2021;
Central Maintenance Facility
o Commodities bunkers ($350,000) – Delayed to 2021;
o Administration office remodel ($25,000) – Delayed to 2021;
City Hall
o Lighting upgrades ($164,000) – Delayed to 2021;
o Restroom remodel ($34,000) – Delayed to 2021;
o Council chambers lighting upgrades ($82,000) – Delayed to 2022;
o Mother’s privacy room ($28,000) – room is currently available;
10
Fire Department
o Lighting upgrades FS #2, #3 & #4 ($48,000) – Delayed to 2021;
o FS #4 Electronic monument sign ($45,000) – Delayed to 2021;
Police Department
o Chilled water plant tanks ($124,000) – Delayed to 2022;
o Lighting upgrades ($129,000) – Delayed to 2022;
Liquor Stores
o Galaxie – Lighting upgrades ($60,000) -Delayed to 2022;
o Kenrick – Lighting upgrades ($20,000) -Delayed to 2021;
Radio Communications Building
o Roof replacement ($35,000) -Delayed to 2021;
Water Treatment Facility
o Lighting upgrades ($198,000) – Delayed to 2022;
The following projects/expenses are not reflected in the Facilities Plan at this point but are
anticipated to be of significant cost:
Construction of a fourth liquor store;
Construction of a shooting range;
Improvements to the Lakeville Arenas facilities and parking lot.
Equipment Plan
The Equipment Plan has been established to determine what the long-term funding needs are for
replacement of the City’s vehicles and equipment at the end of their useful lives as well as the
addition of new equipment as the City continues to grow. The Equipment Plan summary shows
the use of funds by department and the various funding sources. The primary funding sources
have been contributions from the Liquor Fund, property tax levies and auction proceeds.
Occasional contributions from other funds have been utilized when available and appropriate
such as General Fund, Pavement Management Fund, and Communications Fund.
In 2018, staff initiated a process of evaluation based upon a point system developed by Dakota
County. Metrics include miles driven, engine hours, vehicle or equipment usage (daily use vs.
periodic use; snowplowing vs. hauling), cost of maintenance and repairs, and maintenance hours
vs. operational hours.
The Equipment Plan strives to provide a stable funding source recognizing that the expenditures
will fluctuate from year to year. Historical funding has been significantly less than the projected
expenditures. Recognizing that the City Council is striving to reduce its level of debt and that
the current resources should be set aside to replace shorter term operational vehicles/equipment,
the use of equipment certificates is shown only for the purchase of fire trucks which have an
approximate useful life of 20 years.
11
The City has approximately $28.6 million in vehicles and equipment as of 12/31/2018 of which
$24.9 million is for governmental activities (property-tax supported). The useful life will range
from three (3) to 25 years, depending on the vehicle or piece of equipment. 2018 depreciation on
the governmental assets ($24.0 million) was $2.0 million which equates to an approximate 12-
year amortization. This amount is based on historical cost and does not reflect the impacts of
inflation. The City should strive to funding the Equipment Plan at a level consistent with this
estimate on an annual basis using property taxes and other funding sources such as the Liquor
Fund and estimated auction/sale proceeds. The current Equipment Plan does not achieve this
level of funding until 2026 and, therefore, requires continual delays in replacement and,
potentially, the issuance of debt. The Council has also placed a significant reliance on excess
funds being available from the General Fund to fund an ongoing cost of capital asset
replacement.
Staff recommends increasing the annual property tax funding to stabilize the position of the
Fund.
Major equipment purchases planned in 2020 include:
Police
o Replace (2) 2014 squad vehicles;
o Replace (1) 2012 CSO pickup;
o Replace (11) mobile radios;
o Replace (6) radar units;
Fire
o None;
Streets
o Replace (4) 2007 Sterling dump trucks;
o Replace (1) 2006 and (1) 2007 ¾-ton trucks;
Parks
o Replace (1) 2013 Toro Groundsmaster;
o New “SportsTraq” for paint striper;
o Replace (1) 2003 ½-ton pickup;
o Replace (1) 1985 pontoon;
Major equipment requested but not included in 2020:
Police
o Swat equipment ($44,000) – removed from plan;
o Replace (1) 2017 squad vehicle ($45,500) - Deferred to 2021;
o Replace (2) 2008 investigations vehicles (71,000) – Deferred to 2021;
o Mobile radios (14) ($70,000) – Deferred to 2021;
o AED Replacements (13,500) – Deferred to 2021;
12
Fire
o Rescue pumper chassis ($305,000) – replacement deferred to 2021;
o Rescue pumper chassis ($305,000) – replacement deferred to 2022;
o Rescue engine chassis ($200,000) – replacement deferred to 2021;
o Replace (1) 2013 and (1) 2017 Staff vehicles – deferred to 2021;
Streets
o (1) 2001 Sterling dump truck – replacement deferred to 2021;
o Fleet maintenance service truck ($139,000) – replacement deferred to 2021;
Parks
o Refuse compactor truck ($203,000) – removed from plan;
Technology Plan
Starting in 2020, staff have separated technology purchases in a separate plan from other
equipment-type purchases. The primary funding source for the Technology Plan will be
property taxes. Staff recommends using General Fund reserves to fund the initial year of the
Technology Plan.
Major equipment/software purchases planned in 2020 include:
Information Systems
o Replacement computers and printers;
o Replacement (2) interactive white boards
The following projects/expenses are not reflected in the Technology Plan at this point but are
anticipated to be of significant cost:
Financial / Human Resources / Payroll System Upgrade;
Utility Billing System Upgrade (per LOGIS, projected to occur within 2-3 years);
Laserfiche (document retention repository) Expansion.
The General Fund proposed budget includes funding in 2020 for conducting a needs analysis
related to the financial/HR/payroll system.
Park Improvement Fund
Preliminary 2020-2024 Capital Improvement Program discussions included funding and
expenditures associated with the replacement of park amenities including parking lots. Over the
five years of the CIP, the average annual expenditure is $560,000. Staff recommends increasing
the annual property tax funding to address the ongoing replacement expenses of the park system
and to stabilize the position of the Fund. Staff has proposed a $350,000 tax levy for 2020 (an
increase of $125,000 from 2019). Significant increases would be needed in 2021 and 2022 for
parking lot improvements; therefore, staff will be researching opportunities to possibly include
them with the annual street reconstruction projects (using bonds as a funding source).
13
Trail Improvement Fund
Preliminary 2020-2024 Capital Improvement Program discussions included funding and
expenditures associated with the replacement of trail segments. In 2018, the remaining sales
proceeds ($743k) from the sale of land adjacent to the police station was transferred to the Trail
Improvement Fund. These funds were intended to replace the needed tax levy in 2019 and to
offset some of the tax levy needed in 2020 and 2021. Based on yearend fund projections and
updated project costs, staff is not recommending a 2020 tax levy for the Trail Improvement
Fund.
Debt Service Funds
The 2020 property tax levy includes new debt issued in 2019 and cash balances in the debt funds.
Staff will continue to review cash balances but is not anticipating any further reductions for 2020.
Debt projections do not include debt that may be issued for improvements to the Lakeville
Arenas facilities or Ames Arena parking lot or the construction of a shooting range.
Other Considerations
The Utility Funds and Liquor Fund are not being presented for your review and feedback today.
They will be presented at a subsequent budget workshop.
Financial Sustainability
The Finance Committee has had preliminary discussions regarding the importance of long-term
planning and financial sustainability, recognizing that as a growing community, additional
resources will be needed to provide services for a larger population, to maintain more streets and
parks, etc. in addition to maintaining our current assets on an ongoing basis. The Committee
plans to make a recommendation to the City Council in the coming months.
Projected Future Tax Levies
Based on the proposed Capital Improvement Program (projects, issuance of debt, tax levy
funding, etc.), a 3% inflationary factor for the General Fund levy, and conservative additions of
staff resources (in even years) the following increases in tax levies are projected:
2020 2021 2022 2023 2024
7.67% 10.28% 11.06% 2.53% 7.96%
Also based on the issuance of debt as proposed in the Capital Improvement Program, debt is
projected to comprise the following percentage of the total levy in the respective years:
2020 2021 2022 2023 2024
23.45% 24.27% 27.85% 28.20% 30.74%
14
Budget & CIP Schedule
Aug 26 Workshop – Review Preliminary Tax Levy and Budget; Final CIP Review / Debt
Analysis
Sept 16 Meeting – Adopt Preliminary Tax Levy & Budget; Announce Public Budget Meeting
Date
Sept 19 Planning Commission – Review CIP for compliance with Comp Plan
Sept 23 Workshop – IF NEEDED – CIP Review
Oct 7 Meeting – Public Hearing on CIP/Street Reconstruction Plan; Adopt CIP & Street
Reconstruction Plan.
Oct 28 Workshop – Budget Review – Utility Funds and Liquor Fund; 2020 Proposed Fee
Schedule
Nov 25 Workshop – Final 2020 Budget Review / 2019 Yearend Preview
Dec 2 Meeting – Public Budget Meeting (Truth in Taxation); Adopt 2020 Budget & Tax
Levy; Adopt 2020 Fee Schedule
Council Direction
Staff is seeking direction regarding the 2020 property tax levy and the Equipment, Facility and
Technology Plans.
Attachments:
1)General Fund Summary;
2)Equipment Plan 2020-2029;
3)Facility Plan 2020-2029;
4)Technology Plan 2020-2029.
2019 2019 2020 Percent
2018 Adopted Amended 2019 Working of
Actual Budget Budget Estimate Budget Total
Revenues (Amount) (Percent) (Amount) (Percent)
General property taxes 20,116,949$ 21,327,427$ 21,327,427$ 21,339,969$ 22,532,858$ 75.9%1,205,431$ 5.7%1,192,889$ 5.6%
Licenses and permits 3,208,279 2,390,498 2,390,498 3,804,578 2,633,930 8.9%243,432 10.2%(1,170,648) -30.8%
Intergovernmental 1,180,340 989,590 989,590 1,027,791 1,028,110 3.5%38,520 3.9%319 0.0%
Charges for services 3,415,540 2,734,249 2,734,249 2,952,741 2,967,433 10.0%233,184 8.5%14,692 0.5%
Court fines 347,203 346,000 346,000 372,602 360,000 1.2%14,000 4.0%(12,602) -3.4%
Investment income 174,680 120,000 120,000 128,000 128,000 0.4%8,000 6.7%- 0.0%
Miscellaneous 68,725 47,163 47,163 44,966 42,893 0.1%(4,270) -9.1%(2,073) -4.6%
Total revenues 28,511,716 27,954,927 27,954,927 29,670,647 29,693,224 100.0%1,738,297 6.2%22,577 0.1%
Expenditures
General government
Mayor and council 96,770 113,250 113,250 120,978 121,006 0.4%7,756 6.8%28 0.0%
Committees and commissions 96,261 68,218 68,218 100,744 91,616 0.3%23,398 34.3%(9,128) -9.1%
City administration 477,629 477,506 477,506 473,430 491,312 1.6%13,806 2.9%17,882 3.8%
City clerk 205,165 148,586 148,586 148,537 265,206 0.9%116,620 78.5%116,669 78.5%
Legal counsel 71,584 81,000 81,000 81,000 83,500 0.3%2,500 3.1%2,500 3.1%
Planning 547,225 580,515 580,515 557,557 597,315 2.0%16,800 2.9%39,758 7.1%
Community and econ. development 378,639 375,237 375,237 374,756 390,616 1.3%15,379 4.1%15,860 4.2%
Inspections 1,231,553 1,273,544 1,273,544 1,304,814 1,317,901 4.3%44,357 3.5%13,087 1.0%
General government facilities 564,459 607,324 607,324 607,995 637,091 2.1%29,767 4.9%29,096 4.8%
Finance 770,487 804,429 804,429 811,518 859,493 2.8%55,064 6.8%47,975 5.9%
Information technology 648,058 788,545 788,545 789,372 818,247 2.7%29,702 3.8%28,875 3.7%
Human resources 505,281 527,997 527,997 511,677 557,705 1.8%29,708 5.6%46,028 9.0%
Insurance 425,000 285,000 285,000 435,727 285,000 0.9%- 0.0%(150,727) -34.6%
Public safety - 0%
Police 11,169,958 11,628,288 11,628,288 11,615,684 12,418,460 40.7%790,172 6.8%802,776 6.9%
Fire 1,891,614 2,034,937 2,034,937 2,046,977 2,103,412 6.9%68,475 3.4%56,435 2.8%
Public works - 0%
Engineering 875,303 881,757 881,757 883,891 950,671 3.1%68,914 7.8%66,780 7.6%
Construction services 489,188 573,870 573,870 546,408 620,977 2.0%47,107 8.2%74,569 13.6%
Streets 3,405,461 3,288,617 3,288,617 3,398,613 3,548,737 11.6%260,120 7.9%150,124 4.4%
Parks and recreation - 0%
Parks 2,619,972 2,744,963 2,744,963 2,726,338 2,868,368 9.4%123,405 4.5%142,030 5.2%
Recreation 715,605 745,137 745,137 755,893 786,925 2.6%41,788 5.6%31,032 4.1%
Heritage center 119,597 138,674 138,674 133,494 147,836 0.5%9,162 6.6%14,342 10.7%
Arts center 550,822 550,049 550,049 599,476 633,472 2.1%83,423 15.2%33,996 5.7%
Other - 79,466 79,466 - (45,939) -0.2%(125,405) -157.8%(45,939) 0%
Total expenditures 27,855,631 28,796,909 28,796,909 29,024,879 30,548,927 100.0%1,752,018 6.1%1,524,048 5.3%
Excess (deficiency) of revenues
over expenditures 656,085 (841,982) (841,982) 645,768 (855,703) (13,721) 1.6%(1,501,471) -232.5%
Other financing sources (uses)
Transfer from other funds 765,232 766,482 766,482 766,482 754,653 (11,829) -1.5% (11,829) -1.5%
Transfer to other funds (958,026) (630,000) (630,000) (1,185,000) (550,000) 80,000 -12.7%635,000 -53.6%
Total other financing sources (uses) (192,794) 136,482 136,482 (418,518) 204,653 68,171 49.9%623,171 -148.9%
Net change in fund balance 463,291 (705,500) (705,500) 227,250 (651,050) 54,450 -7.7%(878,300) -386.5%
Fund balance, January 1 15,128,923 15,597,339 15,597,339 15,592,214 15,819,464 222,125 1.4%227,250 1.5%
Fund balance, December 31 15,592,214$ 14,891,839$ 14,891,839$ 15,819,464$ 15,168,414$ 276,575$ 1.9%(651,050) -4.1%
Adj Fund Balance, Dec 31 (net of restricted)14,612,839$ 13,777,464$ 13,777,464$ 14,840,089$ 14,189,039$
Ratio: Fund balance to CY expenditures 51.9%47.8%47.8%51.1%46.4%
Ratio: Fund balance to NY expenditures 50.7%46.4%46.4%48.6%44.8%
2019 2019 2020
2018 Adopted Amended 2019 Working
Actual Budget Budget Estimate Budget
Function (Amount) (Percent) (Amount) (Percent)
General government 6,018,111 6,131,151 6,131,151 6,318,105 6,516,008 384,857 6.3%197,903 3.1%
Public safety 13,061,572 13,663,225 13,663,225 13,662,661 14,521,872 858,647 6.3%859,211 6.3%
Public works 4,769,952 4,744,244 4,744,244 4,828,912 5,120,385 376,141 7.9%291,473 6.0%
Parks and recreation 4,005,996 4,178,823 4,178,823 4,215,201 4,436,601 257,778 6.2%221,400 5.3%
Contingency - 79,466 79,466 - (45,939) (125,405) -157.8%(45,939) 0%
27,855,631 28,796,909 28,796,909 29,024,879 30,548,927 1,752,018 6.1%1,524,048 5.3%
Classification
Personnel services 20,593,471 21,502,338 21,502,338 21,453,121 22,841,870 1,339,532 6.2%1,388,749 6.5%
Commodities 1,932,193 1,757,479 1,749,479 1,799,285 1,871,973 122,494 7.0%72,688 4.0%
Other charges and services 5,286,965 5,537,092 5,545,092 5,747,183 5,826,959 281,867 5.1%79,776 1.4%
Capital outlay 43,002 - - 25,290 8,125 8,125 0%(17,165) -67.9%
27,855,631 28,796,909 28,796,909 29,024,879 30,548,927 1,752,018 6.1%1,524,048 5.3%
- - - -
CITY OF LAKEVILLE, MINNESOTA
General Fund
Schedule of Revenues, Expenditures and Changes in Fund Balances
For the Year Ending December 31, 2020
Change from Change from
2019 Amended
Budget
2019 Amended
Budget
Change from
2019
Estimate
Change from
2019
Estimate
CITY OF LAKEVILLE Council Workshop
2020 - 2029 EQUIPMENT PLAN 8/26/2019
2019 2018 CF +2020 - 2029
Funding ADOPTED 2019 Est'd 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Totals
Use of Funds:
Information Technology 134,580$ 26,638$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Facilities GEN FUND - - - - - - 30,095 - 35,383 - - - 65,478
Planning GEN FUND - - - - 27,250 - - - - - - - 27,250
Inspections GEN FUND - 24,225 - 24,930 25,636 26,341 - - 28,458 - - - 105,365
Police EQ FUND 763,831 802,426 226,595 699,616 530,158 384,665 403,582 317,956 614,528 593,708 303,619 922,350 4,996,777
Fire EQ FUND - - - 1,098,493 1,108,731 788,670 108,020 1,256,700 - - 82,550 - 4,443,164
Engineering GEN FUND - - - - - - - - - - - 32,500 32,500
Construction Services GEN FUND - - - 26,500 - - - 31,860 32,670 31,000 - - 122,030
Streets EQ FUND 579,064 559,179 942,449 1,829,999 931,337 159,898 976,082 1,283,193 1,418,643 1,229,774 1,247,649 577,047 10,596,071
Parks EQ FUND 171,290 176,722 232,865 244,695 355,570 293,289 149,960 409,119 368,516 392,722 592,030 566,383 3,605,148
Environmental Resources ENV RES - - - - 30,520 - - - - - - - 30,520
Forestry ENV RES - - - - 22,083 - - - - - - - 22,083
Communications COMM 66,500 38,485 80,000 51,500 60,000 55,000 36,000 25,000 79,500 21,000 55,000 - 463,000
Utilities UTILITY 65,022 65,022 132,521 489,457 - - 312,026 77,040 688,233 40,479 103,428 330,057 2,173,241
Liquor LIQUOR - - - - - - - - - - - - -
- - - - - - - - - - - - -
Total Use of Funds 1,780,287$ 1,692,697$ 1,614,431$ 4,465,190$ 3,091,285$ 1,707,863$ 2,015,765$ 3,400,868$ 3,265,931$ 2,308,681$ 2,384,275$ 2,428,337$ 26,682,627$
Source of Funds:
Interest Earnings (2%) 18,331$ 18,331$ 18,331$ 32,352$ 6,363$ (4,918)$ 11,174$ 14,264$ 11,930$ 7,635$ 8,964$ 10,126$ 116,221$
Annual Levy 252,000 252,000 675,000 875,000 1,075,000 1,075,000 1,075,000 1,250,000 1,500,000 1,600,000 1,600,000 1,600,000 12,325,000
General Fund Contribution 480,000 880,000 350,000 350,000 - - - - - - - - 700,000
Liquor Fund Contribution 400,000 400,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 500,000 5,000,000
Pavement Mgmt Fund Contribution - - - - - - - - - - - - -
Environmental Res Fund Contribution 31,000 31,000 31,000 31,000 31,000 31,000 31,000 31,000 - - - - 186,000
Utility Fund Contribution - - - - - - - - - - - -
Funding outside Equipment Fund
General Fund 17,488 24,225 - 51,430 52,886 26,341 30,095 31,860 96,511 31,000 - 32,500 352,623
Communications Fund 66,500 38,485 80,000 51,500 60,000 55,000 36,000 25,000 79,500 21,000 55,000 - 463,000
Utility Fund 69,804 65,022 132,521 489,457 - - 312,026 77,040 688,233 40,479 103,428 330,057 2,173,241
Liquor Fund - - - - - - - - - - - - -
Lakeville Arenas 4,660 - -
Intergovernmental Grants 35,000 35,000 - - - - - - - - - - -
Auction/Sale Proceeds 94,300 142,150 169,525 175,000 175,000 175,000 175,000 175,000 175,000 175,000 175,000 175,000 1,744,525
Donations - - 20,000 - - - - - - - - - 20,000
Bond Proceeds - - - 610,000 627,000 655,000 - 1,180,000 - - - 3,072,000
Forfeiture Funds - - 102,000 - - - - - - - - - 102,000
Total Source of Funds 1,469,083$ 1,886,213$ 2,078,377$ 3,165,739$ 2,527,249$ 2,512,423$ 2,170,295$ 3,284,164$ 3,051,174$ 2,375,114$ 2,442,392$ 2,647,683$ 26,254,610$
Change in Fund Balance (311,204)$ 193,516$ 463,946$ (1,299,450)$ (564,037)$ 804,560$ 154,530$ (116,704)$ (214,757)$ 66,432$ 58,116$ 219,346$ (428,017)$
Beginning Fund Balance $862,962 $960,146 $1,153,662 $1,617,608 $318,158 ($245,879)$558,681 $713,211 $596,507 $381,750 $448,182 $506,298
Ending Fund Balance $551,758 $1,153,662 $1,617,608 $318,158 ($245,879)$558,681 $713,211 $596,507 $381,750 $448,182 $506,298 $725,645
(0) -
2019-2028 CIP Adopted 10/2018* 1,780,287 1,780,287 3,586,354 2,712,401 1,857,931 2,024,849 2,095,557 3,391,671 1,903,477 2,880,192 4,308,964 - 26,541,683
Variance 0 (87,590) (1,971,923) 1,752,789 1,233,354 (316,986) (79,792) 9,197 1,362,454 (571,511) (1,924,689) 2,428,337 140,944
*Information Technology expenses have been subtracted from the Equipment Plan and added to the Technology Plan (excluding 2019).
CITY OF LAKEVILLE Council Worksession
2020 - 2029 FACILITY PLAN 8/26/2019
2018 CF + 2020 - 2029
2019 2019 Est'd 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Totals
Use of Funds:
Art Center 63,625$ 64,989$ 140,500$ 135,642$ 50,000$ 8,250$ -$ 210,000$ 65,000$ 25,000$ -$ 252,368$ 886,760$
Central Maintenance Facility 179,325 177,278 158,095 10,133,800 - 97,000 - 75,000 - - - 808,152 11,272,047
City Hall 88,435 105,435 409,040 307,949 82,055 236,250 - 1,500 135,000 - - 19,607 1,191,401
Fire Station #1 6,600 6,600 24,857 5,000 25,000 35,975 - - - - 7,800 186,014 284,646
Fire Station #2 2,100 2,100 - 11,076 5,500 25,000 - 5,900 7,500 7,800 - 134,210 196,986
Fire Station #3 2,100 2,100 - 23,874 11,000 5,000 - - - - - 129,115 168,989
Fire Station #4 4,500 4,500 27,500 266,435 - - 30,000 - 5,500 - - 2,970 332,405
Heritage Center 37,905 37,905 92,706 - - - - - - 375,000 - 1,616 469,322
Police Station 140,935 223,384 57,350 85,000 293,658 - - 200,000 75,000 - - 268,184 979,192
Public Works Storage Facility 67,000 67,000 - - - - - - - - - - -
Heritage Liquor Store - - 26,250 104,125 - - - - - - - - 130,375
Galaxie Liquor Store 79,785 79,785 5,550 137,100 91,280 60,000 - - - - - 280,657 574,587
Kenrick Liquor Store - - - 84,280 - - - - - - - 4,368 88,648
Radio Communications Building - - - 35,000 - - - - - - - - 35,000
Water Treatment Facility 136,055 98,692 807,511 44,500 73,420 - - - - 33,892,000 - 6,496 34,823,927
Total Use of Funds 768,175$ 869,768$ 1,749,359$ 11,373,781$ 631,913$ 467,475$ 30,000$ 492,400$ 288,000$ 34,299,800$ 7,800$ 2,093,757$ 51,434,285$
Source of Funds:
Interest Earnings (2%) 24,735$ 24,735$ 21,504$ 16,335$ 4,661$ 4,568$ 5,462$ 14,209$ 14,220$ 18,710$ 20,652$ 30,943$ 151,264$
Annual Levy (Building Fund) - - - - - - - - - - - - -
General Fund Contribution - - 200,000 200,000 - - - - - - - - 400,000
Antenna Rental 421,761 416,869 430,102 443,733 457,893 447,614 461,889 478,743 498,286 486,165 501,702 517,738 4,723,867
Unencumbered 20XX GF - - - - - - - - - - - - -
Liquor Fund 79,785 79,785 31,800 325,505 91,280 60,000 - - - - - 285,025 793,610
Water & Sewer Funds/Bonds 136,055 98,692 807,511 44,500 73,420 - - - - 33,892,000 - 6,496 34,823,927
Donations/Fundraising - - - - - - - - - - - - -
Energy Rebates - - - - - - - - - - - - -
Other/Partnership 7,380 7,380 - - - - - - - - - - -
Bond Proceeds - - - 9,760,000 - - - - - - - - 9,760,000
Other - - - - - - - - - - - - -
Total Source of Funds 669,716$ 627,461$ 1,490,917$ 10,790,073$ 627,254$ 512,182$ 467,351$ 492,952$ 512,506$ 34,396,875$ 522,354$ 840,202$ 50,652,668$
Change in Fund Balance (98,459)$ (242,307)$ (258,442)$ (583,708)$ (4,659)$ 44,707$ 437,351$ 552$ 224,506$ 97,075$ 514,554$ (1,253,555)$ (781,617)$
Beginning Fund Balance 1,198,111$ 1,317,522$ 1,075,215$ 816,773$ 233,065$ 228,406$ 273,113$ 710,465$ 711,017$ 935,523$ 1,032,598$ 1,547,153$
Ending Fund Balance 1,099,652$ 1,075,215$ 816,773$ 233,065$ 228,406$ 273,113$ 710,465$ 711,017$ 935,523$ 1,032,598$ 1,547,153$ 293,598$
2019-2023 CIP Adopted 10/2018 768,175 768,175 1,618,000 9,469,875 110,250 501,250 - 532,400 23,000,000 45,000 - - 36,044,950
Variance - 101,593 131,359 1,903,906 521,663 (33,775) 30,000 (40,000) (22,712,000) 34,254,800 7,800 2,093,757 15,389,335
CITY OF LAKEVILLE Council Worksession
2020 - 2029 TECHNOLOGY PLAN 8/26/2019
2018 CF + 2020 - 2029
2019 2019 Est'd 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Totals
Use of Funds:
Administration -$ -$ 3,252$ 2,534$ 3,312$ 561$ 3,873$ 4,478$ 1,713$ 6,272$ 650$ 1,339$ 27,983$
Arts Center - - 1,374 - - 3,974 - 5,092 2,336 633 3,955 - 17,364
Building Inspection - - 3,834 1,478 6,592 1,811 3,331 4,578 1,713 7,642 2,099 - 33,079
Comm/Econ Development - - 1,609 3,017 3,312 1,600 4,645 1,921 3,498 3,840 1,855 1,911 27,209
Engineering - - - 4,853 3,966 4,529 5,699 - 6,361 3,840 5,250 2,704 37,201
Facilities Maintenance - - - - - - 1,865 - 393 - - 2,162 4,420
Finance - - 1,377 1,707 1,318 13,014 3,403 1,644 1,979 1,528 15,087 - 41,057
Fire - - 1,891 17,901 15,992 3,729 858 17,335 5,175 25,960 11,310 4,685 104,836
Heritage Center - - 2,906 1,509 - 7,378 - 6,055 1,749 - 3,955 - 23,551
Human Resources - - 2,844 - 6,195 1,600 1,516 3,396 - 5,641 1,855 - 23,048
Information Technology - - 1,206 4,693 2,872 4,182 1,146 1,440 5,441 3,960 5,556 - 30,497
Operations & Maintenance - - 1,377 3,216 2,743 - 2,703 2,788 4,340 2,549 - 2,704 22,419
Parks Administration - - 1,609 - 1,554 - 776 1,921 - 1,801 - - 7,662
Parks Maintenance - - - 5,774 1,973 3,411 - 716 8,695 1,528 4,738 - 26,837
Police - - 1,206 8,303 21,601 47,751 3,297 1,440 10,360 58,637 53,783 5,443 211,821
Recreation - - 400 - 6,388 - 870 1,144 - 7,406 522 - 16,729
Streets Maintenance - - 5,528 3,017 10,365 2,958 3,362 4,578 13,574 3,055 4,066 12,747 63,250
Arenas - - - 3,414 - 5,919 10,714 578 3,958 3,059 3,711 3,242 34,594
Communications - - 1,206 4,297 3,312 - 1,850 1,440 4,981 3,840 - - 20,926
Liquor - - 57,877 - 3,312 19,376 842 68,189 7,582 3,840 - - 161,017
Environmental Resources 1,377 - - 4,084 1,110 1,644 - 758 3,955 - 12,928
Utilities - - 1,609 5,805 18,449 1,600 5,868 5,522 6,730 10,147 4,204 9,506 69,440
Printers/Scanners - - 5,424 2,734 3,791 7,913 8,108 18,118 1,349 2,178 31,670 2,035 83,319
Network Infrastructure - - 35,000 22,674 162,545 306,064 - 42,866 18,511 188,435 146,677 8,495 931,268
Miscellaneous - - 4,000 8,212 - - 3,332 - - 16,810 10,100 - 42,455
Total Use of Funds -$ -$ 136,906$ 105,138$ 279,591$ 441,455$ 69,168$ 196,884$ 110,438$ 363,356$ 314,998$ 56,972$ 2,074,906$
Source of Funds:
Interest Earnings (2%) -$ -$ 3,100$ 2,289$ 4,315$ 2,823$ (1,817)$ 992$ 1,099$ 3,006$ (126)$ (2,340)$ 13,341$
Annual Levy - - - 155,000 155,000 155,000 155,000 155,000 155,000 155,000 155,000 155,000 1,395,000
Contributions:
General Fund - 155,000 - - - - - - - - - - -
Communications Fund - - 4,400 4,400 4,400 4,400 4,400 4,400 4,400 4,400 4,400 4,400 44,000
Liquor Fund - - 69,677 22,100 22,100 22,100 22,100 22,100 22,100 22,100 22,100 22,100 268,577
Environmental Resources - - 3,600 3,600 3,600 3,600 3,600 3,600 3,600 3,600 3,600 3,600 36,000
Utility (Water/Sewer) Fund - - 15,600 15,600 15,600 15,600 15,600 15,600 15,600 15,600 15,600 15,600 156,000
Direct Costs:
Lakeville Arenas - - - 3,414 - 5,919 10,714 578 3,958 3,059 3,711 3,242 34,594
Total Source of Funds -$ 155,000$ 96,377$ 206,403$ 205,015$ 209,442$ 209,597$ 202,270$ 205,757$ 206,765$ 204,285$ 201,602$ 1,947,512$
Change in Fund Balance -$ 155,000$ (40,529)$ 101,265$ (74,576)$ (232,014)$ 140,429$ 5,386$ 95,319$ (156,591)$ (110,713)$ 144,630$ (127,394)$
Beginning Fund Balance -$ -$ 155,000$ 114,471$ 215,736$ 141,160$ (90,853)$ 49,575$ 54,961$ 150,280$ (6,311)$ (117,024)$
Ending Fund Balance -$ 155,000$ 114,471$ 215,736$ 141,160$ (90,853)$ 49,575$ 54,961$ 150,280$ (6,311)$ (117,024)$ 27,606$
2019-2023 CIP Adopted 10/2018* - - 223,109 118,355 313,029 494,730 73,713 301,426 192,216 400,209 323,933 - 2,440,720
Variance - - (86,203) (13,217) (33,438) (53,275) (4,545) (104,542) (81,778) (36,853) (8,935) 56,972 (365,814)
*Information Technology expenses have been subtracted from the Equipment Plan and added to the Technology Plan (excluding 2019).