HomeMy WebLinkAboutItem 06.p
December 21, 2020 Item No.
RESOLUTION AMENDING THE 2020 BUDGETS
Proposed Action
Staff recommends adoption of the following motion: Move to approve the Resolution
Amending the 2020 Budgets.
Overview
Various events have transpired during the year which require an adjustment to the 2020
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/21/2020 Amended
Budget Amended Amendment Budget
Revenues 29,726,551$ 29,752,440$ 202,499$ 29,954,939$
Expenditures 30,756,597 30,902,186 254,721 31,156,907
Excess (Deficiency) (1,030,046) (1,149,746) (52,222) (1,201,968)
Other Financing Sources (Uses) 280,371 280,371 (102,000) 178,371
Net Change in Fund Balance (749,675) (869,375) (154,222) (1,023,597)
Fund Balance, January 1 16,012,291 16,012,291 1,190,957 17,203,248
Fund Balance, December 31 15,262,616$ 15,142,916$ 1,036,735$ 16,179,651$
Final
Adopted YTD 12/21/2020 Amended
Budget Amended Amendment Budget
Revenues -$ -$ 868,947$ 868,947$
Expenditures - - 868,947 868,947
Net Change in Fund Balance - - - -
Fund Balance, January 1 - - - -
Fund Balance, December 31 -$ -$ -$ -$
General Fund
Small Business Grant Fund
Final
Adopted YTD 12/21/2020 Amended
Budget Amended Amendment Budget
Revenues 451,606$ 457,606$ -$ 457,606$
Expenditures 910,048 916,048 41,774 957,822
Excess (Deficiency) (458,442) (458,442) (41,774) (500,216)
Other Financing Sources (Uses )200,000 200,000 - 200,000
Net Change in Fund Balance (258,442) (258,442) (41,774) (300,216)
Fund Balance, January 1 1,193,272 1,193,272 40,538 1,233,810
Fund Balance, December 31 934,830$ 934,830$ (1,236)$ 933,594$
Final
Adopted YTD 12/21/2020 Amended
Budget Amended Amendment Budget
Revenues 984,856$ 994,856$ (102,000)$ 892,856$
Expenditures 1,383,515 1,519,515 362,684 1,882,199
Excess (Deficiency) (398,659) (524,659) (464,684) (989,343)
Other Financing Sources (Uses )881,000 881,000 102,000 983,000
Net Change in Fund Balance 482,341 356,341 (362,684) (6,343)
Net Position, January 1 1,173,621 1,173,621 452,321 1,625,942
Net Position, December 31 1,655,962$ 1,529,962$ 89,637$ 1,619,599$
Final
Adopted YTD 12/21/2020 Amended
Budget Amended Amendment Budget
Revenues 11,242,861$ 11,242,861$ -$ 11,242,861$
Expenditures 14,296,297 14,468,370 1,071,064 15,539,434
Excess (Deficiency) (3,053,436) (3,225,509) (1,071,064) (4,296,573)
Other Financing Sources (Uses )3,116,716 3,288,789 421,664 3,710,453
Net Change in Fund Balance 63,280 63,280 (649,400) (586,120)
Net Position, January 1 25,196 25,196 2,016,992 2,042,188
Net Position, December 31 88,476$ 88,476$ 1,367,592$ 1,456,068$
Municipal State Aid Fund
Building Fund
Equipment Fund
Final
Adopted YTD 12/21/2020 Amended
Budget Amended Amendment Budget
Revenues 1,605,281$ 1,605,281$ -$ 1,605,281$
Expenditures 15,956,113 15,956,113 (2,152,128) 13,803,985
Excess (Deficiency) (14,350,832) (14,350,832) 2,152,128 (12,198,704)
Other Financing Sources (Uses )14,350,832 14,350,832 (2,637,128) 11,713,704
Net Change in Fund Balance - - (485,000) (485,000)
Fund Balance, January 1 1,191,404 1,191,404 5,523,570 6,714,974
Fund Balance, December 31 1,191,404$ 1,191,404$ 5,038,570$ 6,229,974$
Final
Adopted YTD 12/21/2020 Amended
Budget Amended Amendment Budget
Revenues 1,960,700$ 1,960,700$ -$ 1,960,700$
Expenditures 998,443 998,443 - 998,443
Excess (Deficiency) 962,257 962,257 - 962,257
Other Financing Sources (Uses )(1,836,308) (1,836,308) (69,164) (1,905,472)
Net Change in Fund Balance (874,051) (874,051) (69,164) (943,215)
Net Position, January 1 9,644,248 9,644,248 953,177 10,597,425
Net Position, December 31 8,770,197$ 8,770,197$ 884,013$ 9,654,210$
Final
Adopted YTD 12/21/2020 Amended
Budget Amended Amendment Budget
Revenues 1,090,462$ 1,090,462$ -$ 1,090,462$
Expenditures 626,132 686,306 420,879 1,107,185
Excess (Deficiency) 464,330 404,156 (420,879) (16,723)
Other Financing Sources (Uses )(1,069,516) (1,195,491) (352,500) (1,547,991)
Net Change in Fund Balance (605,186) (791,335) (773,379) (1,564,714)
Net Position, January 1 7,882,174 7,882,174 1,100,401 8,982,575
Net Position, December 31 7,276,988$ 7,090,839$ 327,022$ 7,417,861$
Stormwater Infrastructure Fund
Improvement Constuction fund
Water Trunk Fund
Final
Adopted YTD 12/21/2020 Amended
Budget Amended Amendment Budget
Revenues 5,930,055$ 5,930,055$ -$ 5,930,055$
Expenditures 4,158,639 4,319,655 304,104 4,623,759
Excess (Deficiency) 1,771,416 1,610,400 (304,104) 1,306,296
Other Financing Sources (Uses )(2,976,891) (2,976,891) - (2,976,891)
Net Change in Fund Balance (1,205,475) (1,366,491) (304,104) (1,670,595)
Net Position, January 1 92,266,368 92,266,368 4,846,321 97,112,689
Net Position, December 31 91,060,893$ 90,899,877$ 4,542,217$ 95,442,094$
Water Operating Fund
Detailed explanations for the adjustments are included as part of the exhibits to the
resolution.
The General Fund exhibit includes some amendments related to COVID-19 expenses for
departments that are currently projected to exceed their budget due to the additional
expense. Staff has included verbiage in the resolution to further amend the budget for CARES
Act eligible expenses in the event additional departments exceed their current amended
budgets.
Primary Issues to Consider
N/A
Supporting Information
Resolution
o Exhibit A: General Fund
o Exhibit B: Small Business Grant Fund
o Exhibit C: Building Fund
o Exhibit D: Equipment Fund
o Exhibit E: Municipal State Aid Fund
o Exhibit F: Improvement Construction Fund
o Exhibit G: Water Trunk Fund
o Exhibit H: Storm Water Infrastructure Fund
o Exhibit I: Water Operating 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
2020 Budget
CITY OF LAKEVILLE
RESOLUTION NO. ________
RESOLUTION AMENDING THE 2020 BUDGETS
WHEREAS, the City of Lakeville approved resolution #20-121 acknowledging receipt and
use of CARES Act funding.
NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Lakeville, Minnesota
as follows:
1. The 2020 budgets for General Fund, Small Business Grant Fund, Building Fund,
Equipment Fund, Municipal State Aid Fund, Improvement Construction Fund, Water
Trunk Fund, Storm Water Infrastructure Fund and the Water Operating Fund are
hereby amended for the fiscal year ending December 31, 2020 as per Exhibits A-I, as
attached hereto.
2. Staff is authorized to further amend the budget as needed to comply with the CARES
Act agreement for expenditures in the General Fund, Communications Fund, Small
Business Grant Fund, Utility Fund and Liquor Fund.
ADOPTED by the Lakeville City Council this 21st day of December 2020.
________________________________
Douglas P. Anderson, Mayor
________________________________
Charlene Friedges, City Clerk
Exhibit A
2020 2020 2020 2020
YTD 12/21/2020 Final
Adopted Amended Adjust Amended
Budget Budget Res. No. 20-###Budget Notes
Revenues
General property taxes 22,509,080$ 22,509,080$ -$ 22,509,080$
Licenses and permits 2,657,099 2,657,099 15,000 2,672,099 (6)
Intergovernmental 1,053,453 1,053,453 144,499 1,197,952 (1)(2)(3)
Charges for services 2,976,026 2,976,026 43,000 3,019,026 (8)
Court fines 360,000 360,000 - 360,000
Investment income 128,000 128,000 - 128,000
Miscellaneous 42,893 68,782 - 68,782
Total revenues 29,726,551 29,752,440 202,499 29,954,939
Expenditures
General government
Mayor and Council 121,006 121,006 - 121,006
Committees and Commissions 91,616 91,616 - 91,616
City administration 498,062 498,062 - 498,062
City Clerk 265,446 265,446 32,872 298,318 (2)
Legal counsel 83,500 83,500 - 83,500
Planning 597,315 597,315 3,464 600,779 (3)
Community and econ. development 382,316 382,316 - 382,316
Inspections 1,439,695 1,439,695 38,322 1,478,017 (4)(6)
General government facilities 637,091 637,091 39,616 676,707 (3)(5)
Finance 859,493 879,693 8,772 888,465 (3)
Information systems 818,247 850,247 - 850,247
Human resources 557,705 557,705 3,007 560,712 (3)
Insurance 285,000 285,000 - 285,000
Public safety
Police 12,428,732 12,506,121 43,000 12,549,121 (8)
Fire 2,103,412 2,119,412 85,668 2,205,080 (1)(3)
Public works
Engineering 1,024,200 1,024,200 - 1,024,200
Operations and Maintenance 620,977 620,977 - 620,977
Streets 3,547,487 3,547,487 - 3,547,487
Parks and recreation
Parks 2,869,618 2,869,618 - 2,869,618
Recreation 786,925 786,925 - 786,925
Heritage Center 151,221 151,221 - 151,221
Arts Center 633,472 633,472 - 633,472
Other (45,939) (45,939) - (45,939)
Total expenditures 30,756,597 30,902,186 254,721 31,156,907
Excess (deficiency) of revenues
over expenditures (1,030,046) (1,149,746) (52,222) (1,201,968)
Other financing sources (uses)
Transfer from other funds 830,371 830,371 - 830,371
Transfer to other funds (550,000) (550,000) (102,000) (652,000) (7)
Total other financing sources (uses) 280,371 280,371 (102,000) 178,371
Net change in fund balance (749,675) (869,375) (154,222) (1,023,597) (4)(5)(7)
Fund balance, January 1 16,012,291 16,012,291 1,190,957 17,203,248 (9)
Fund balance, December 31 15,262,616$ 15,142,916$ 1,036,735$ 16,179,651$
2020 GENERAL FUND BUDGET
CITY OF LAKEVILLE, MINNESOTA
General Fund
Schedule of Revenues, Expenditures and Changes in Fund Balances
For the Year Ending December 31, 2020
Exhibit A
Exhibit A
(1)
Expenditures:
Other Charges and Services 33,668
Revenues:
Intergovernmental 33,668
(2)
Expenditures:
Personnel Services 3,500
Commodities 5,659
Other Charges and Services 23,713
Revenues:
Intergovernmental Grants 32,872
(3)
Expenditures:
Finance ‐ Capital Outlay 8,772
Human Resources ‐ Capital Outlay 3,007
Planning ‐ Capital Outlay 3,464
General Government Facilities ‐ Commodities 10,716
Fire ‐ Personnel Services (Extra Duty Crews)52,000
Revenues:
Intergovernmental Grants 77,959
(4)
Expenditures:
Other Charges and Services 23,322
Revenues:
Use of Fund Balance 23,322
(5)
Expenditures:
Other Charges and Services 28,900
Revenues:
Use of Fund Balance 28,900
Amend Inspections Department budget for vehicle budgeted in 2019 but not purchased until 2020
due to delays in vehicle inventories from automotive dealers.
Amend General Government Facilities budget for telephone contract with Vonage which wasn't
budgeted.
Amend Fire Relief Association contribution resulting from increase in state aid.
Amend City Clerk budget for additional cost related to early voting for the 2020 election.
Amend various departments for CARES Act qualified expenses. This amendment doesn’t cover all
CARES Act eligible expenses. The amendment just includes departments that will go over budget.
Exhibit A
(6)
Expenditures:
Other Charges and Services 15,000
Revenues:
Permits ‐ Electrical 15,000
(7)
Other financing uses:
Transfer to Equipment Fund 102,000
Revenues:
Use of Reserve Fund Balance 102,000
(8)
Expenditures:
Personnel Services 43,000
Revenues:
Charges for Services 43,000
(9)
Actual Fund Balance, January 1, 2020 17,203,248
Budgeted Fund Balance, January 1, 2020 16,012,291
Increase Fund Balance, January 1, 2020 1,190,957
‐
Amend the budgeted (estimated) January 1, 2020 Fund Balance to reflect the actual January 1 Fund
Balance.
Amend the Police Department budget for the addition of a third SRO Officer funded 100% by ISD
194.
Amend the Inspections Department budget to account for increased contractual electrical
inspections and the offsetting electrical permit revenues.
Transfer the reserve fund balance for Police forfeitures to the equipment fund appropriated towards
the cost of squad replacements. The Equipment Fund anticipated these funds in 2020, but the
transfer was not set up in the General Fund.
Exhibit B
2020 SMALL BUSINESS GRANT FUND BUDGET
2020 2020
YTD Final
Amended 12/21/2020 Amended
Budget Adjust Budget Notes
Revenues
Intergovernmental ‐$ 868,947$ 868,947$ (1)
Total revenues ‐ 868,947 868,947
Expenditures ‐ Capital outlay
General Government ‐ 868,947 868,947 (1)
Total expenditures ‐ 868,947 868,947
Net change in fund balance ‐ ‐ ‐
Fund balance, January 1 ‐ ‐ ‐
Fund balance, December 31 ‐$ ‐$ ‐$
Exhibit B
(1)Amend budget to recognize CARES Act grant funding appropriated to
local small businesses impacted by the COVID‐19 pandemic.
Expenditures:
Other Charges and Services 868,947
Revenues:
Intergovernmental Grants 868,947
Exhibit C
2020 BUILDING FUND BUDGET
2020 2020
2020 YTD Final
Adopted Amended 12/21/2020 Amended
Budget Budget Adjust Budget Notes
Revenues
Investment income 21,504$ 21,504$ ‐$ 21,504$
Donations ‐ 6,000 ‐ 6,000
Miscellaneous ‐ antenna rental 430,102 430,102 ‐ 430,102
Total revenues 451,606 457,606 ‐ 457,606
Expenditures ‐ Capital outlay
General Government 409,040 409,040 409,040
Public safety 109,707 109,707 41,774 151,481 (1)
Public works 158,095 158,095 ‐ 158,095
Parks and recreation 233,206 239,206 ‐ 239,206
Total expenditures 910,048 916,048 41,774 957,822
Excess (deficiency) of revenues
over expenditures (458,442) (458,442) (41,774) (500,216) (1)
Other financing sources
Transfer from
General Fund 200,000 200,000 ‐ 200,000
Net change in fund balance (258,442) (258,442) (41,774) (300,216)
Fund balance, January 1 1,193,272 1,193,272 40,538 1,233,810 (2)
Fund balance, December 31 934,830$ 934,830$ (1,236)$ 933,594$
Exhibit C
(1) Amend the budget for the Police facility for the addition of a perimeter
fence around the facility per contract approved on November 16, 2020.
Expenditures:
Capital outlay ‐ Police Station 41,774
Revenues:
Use of fund balance 41,774
(2) Amend the budgeted (estimated) January 1, 2020 Fund Balance to reflect
the actual January 1 Fund Balance.
Actual Fund Balance, January 1, 2020 1,233,810
Budgeted Fund Balance, January 1, 2020 1,193,272
Increase Fund Balance, January 1, 2020 40,538
Exhibit D
2020 EQUIPMENT FUND BUDGET
2020 2020
2020 YTD Final
Adopted Amended 12/21/2020 Amended
Budget Budget Adjust Budget Notes
Revenues
General property taxes 675,000$ 675,000$ ‐$ 675,000$
Investment income 18,331 18,331 ‐ 18,331
Donations 20,000 20,000 ‐ 20,000
Miscellaneous 271,525 281,525 (102,000) 179,525 (4)
Total revenues 984,856 994,856 (102,000) 892,856
Expenditures ‐ Capital outlay
Public safety
Police 226,595 226,595 355,678 582,273 (1)(2)
Fire ‐ ‐ ‐ ‐
Public works 924,054 1,060,054 7,006 1,067,060 (3)
Parks and recreation 232,866 232,866 ‐ 232,866
Total expenditures 1,383,515 1,519,515 362,684 1,882,199
Excess (deficiency) of revenues
over expenditures (398,659) (524,659) (464,684) (989,343) (1)(2)(3)
Other financing sources
Transfer from
General Fund 350,000 350,000 ‐ 350,000
General Fund ‐ Forfeitures Funds ‐ ‐ 102,000 102,000 (4)
Liquor Fund 500,000 500,000 ‐ 500,000
Utility Fund 31,000 31,000 ‐ 31,000
Total other financing sources 881,000 881,000 102,000 983,000
Net change in fund balance 482,341 356,341 (362,684) (6,343)
Fund balance, January 1 1,173,621 1,173,621 452,321 1,625,942 (5)
Fund balance, December 31 1,655,962$ 1,529,962$ 89,637$ 1,619,599$
Exhibit D
(1)Amend the Police Department budget for equipment budgeted in 2019
but carried over into 2020 due to delays by the auto dealers obtaining
vehicle inventory.
Expenditures:
Capital Outlay ‐ Squads (9) 325,059
Capital Outlay ‐ Lightbars and siren controls 16,818
Revenues:
Use of Fund Balance 341,877
(2)Amend the Police Department budget for AED's budgeted in 2018 but
carried over into 2020 due to delays by the manufacturer.
Expenditures:
Capital Outlay ‐ 'AED's 13,801
Revenues:
Use of Fund Balance 13,801
(3)Amend the Streets Department budget for vehicle licensing fees
budgeted in 2019, but due to the late delivery the license fees were not
incurred until 2020.
Expenditures:
Capital Outlay 7,006
Revenues:
Use of Fund Balance 7,006
(4)Amend transfers in for the forfeiture funds proposed to be used to fund a
portion of the police squad purchases. The budget initially reported this
as a miscellaneous revenue but should be shown as a transfer from the
General Fund.
Other Financing Sources:
Transfers In: 102,000
Revenues:
Miscellaneous Revenue (102,000)
(5)Amend the budgeted (estimated) January 1, 2020 Fund Balance to reflect
the actual January 1 Fund Balance.
Actual Fund Balance, January 1, 2020 1,173,621
Budgeted Fund Balance, January 1, 2020 1,625,942
Increase Fund Balance, January 1, 2020 452,321
Exhibit E
2020 MUNICIPAL STATE AID FUND BUDGET
2020 2020
2020 YTD Final
Adopted Amended 12/21/2020 Amended
Budget Budget Adjust Budget Notes
Revenues
Intergovernmental 10,669,733$ 10,669,733$ ‐$ 10,669,733$
Investment income (charges) 15,800 15,800 ‐ 15,800
Special Assessments 217,328 217,328 ‐ 217,328
Miscellaneous ‐ pass‐through developer
obligations 340,000 340,000 ‐ 340,000
Total revenues 11,242,861 11,242,861 ‐ 11,242,861
Expenditures ‐ Capital outlay
Public works 14,296,297 14,468,370 1,071,064 15,539,434 (1)(3)(4)(5)
Total expenditures 14,296,297 14,468,370 1,071,064 15,539,434
Excess (deficiency) of revenues
over expenditures (3,053,436) (3,225,509) (1,071,064) (4,296,573)
Other financing sources
Transfer from Capital Projects
Water Trunk Fund 1,225,000 1,225,000 69,164 1,294,164 (1)
Sanitary Sewer Trunk Fund 142,500 142,500 ‐ 142,500
Park Dedication Fund 964,516 964,516 ‐ 964,516
Stormwater Infrastructure Fund 784,700 956,773 352,500 1,309,273 (1)
Total other financing sources (uses) 3,116,716 3,288,789 421,664 3,710,453
Net change in fund balance 63,280 63,280 (649,400) (586,120) (1)(3)(4)(5)
Fund balance, January 1 25,196 25,196 2,016,992 2,042,188 (2)
Fund balance, December 31 88,476$ 88,476$ 1,367,592$ 1,456,068$
Exhibit E
(1)Amend the budget for revised estimates on the County Road 50 project,
#15‐12. This was a County led project and the City is expected to
reimburse the County early in 2021 for the City share of costs incurred in
2018, 2019 and 2020.
Expenditures:
Capital Outlay ‐ Public Works 955,407
Other Financing Sources:
Stormwater Infrastructure Fund 352,500
Water Trunk Fund 69,164
Use of Fund Balance 533,743
(2)Amend the budgeted (estimated) January 1, 2020 Fund Balance to reflect
the actual January 1 Fund Balance.
Actual Fund Balance, January 1, 2020 2,042,188
Budgeted Fund Balance, January 1, 2020 25,196
Increase Fund Balance, January 1, 2020 2,016,992
(3)Amend the budget for actual costs paid to the County in 2020 for the
Dodd Blvd/Glacier Way signal, project #18‐08.
Expenditures:
Capital Outlay ‐ Public Works 46,157
Revenues:
Use of Fund Balance 46,157
(4)Amend the budget for estimated costs incurred in 2020 for the
Dodd/Heritage Dr/Icenic Way intersection improvements, project #20‐
07.
Expenditures:
Capital Outlay ‐ Public Works 50,000
Revenues:
Use of Fund Balance 50,000
(5)Amend the budget for costs incurred in 2020 for the Dodd & 194th St
intersection improvements, project #20‐12.
Expenditures:
Capital Outlay ‐ Public Works 19,500
Revenues:
Use of Fund Balance 19,500
Exhibit F
2020 IMPROVEMENT CONSTRUCTION FUND BUDGET
2020 2020
2020 YTD Final
Adopted Amended 12/21/2020 Amended
Budget Budget Adjust Budget Notes
Revenues
Intergovernmental 690,000$ 690,000$ ‐$ 690,000$
Escrow 120,000 120,000 ‐ 120,000
Miscellaneous ‐ pass‐through developer
obligations 795,281 795,281 ‐ 795,281
Total revenues 1,605,281 1,605,281 ‐ 1,605,281
Expenditures ‐ Capital outlay
Public works 15,956,113 15,956,113 (2,152,128) 13,803,985 (1)(3)(4)(5)
Total expenditures 15,956,113 15,956,113 (2,152,128) 13,803,985
Excess (deficiency) of revenues
over expenditures (14,350,832) (14,350,832) 2,152,128 (12,198,704)
Other financing sources
Transfer from Capital Projects
Stormwater Infrastructure Fund 105,000 105,000 ‐ 105,000
Transfer from Debt Service 200,000 200,000 ‐ 200,000
Issuance of debt 14,045,832 14,045,832 (4,883,312) 9,162,520 (3)
Premium on bonds issued ‐ ‐ 2,246,184 2,246,184 (3)
Total other financing sources (uses) 14,350,832 14,350,832 (2,637,128) 11,713,704
Net change in fund balance ‐ ‐ (485,000) (485,000) (1)(4)(5)
Fund balance, January 1 1,191,404 1,191,404 5,523,570 6,714,974 (2)
Fund balance, December 31 1,191,404$ 1,191,404$ 5,038,570$ 6,229,974$
Exhibit F
(1) Amend the budget for the cost of additional legal costs incurred related
to project 15‐02 during 2020. This amount includes an estimate for
additional costs to be incurred through the end of 2020.
Expenditures:
Capital Outlay ‐ Public Works 45,000
Revenues:
Use of Fund Balance 45,000
(2) Amend the budgeted (estimated) January 1, 2020 Fund Balance to reflect
the actual January 1 Fund Balance.
Actual Fund Balance, January 1, 2020 6,714,974
Budgeted Fund Balance, January 1, 2020 1,191,404
Increase Fund Balance, January 1, 2020 5,523,570
(3) Amend the budget to reflect final bond proceed amounts recorded in the
Improvement Construction Fund in 2020 from the 2020A bonds, and the
related decrease in anticipated project expenditures.
Expenditures:
Capital Outlay ‐ Public Works (2,637,128)
Revenues:
Bond Proceeds (4,883,312)
Bond Premium 2,246,184
(4) Amend the budget to reflect additional costs incurred during 2020 for
project 22‐03 engineering costs.
Expenditures:
Capital Outlay ‐ Public Works 240,000
Revenues:
Use of Fund Balance (Bond Proceeds) 240,000
(5) Amend the budget to reflect additional costs incurred during 2020 for
the 2019 street projects (19‐02 and 19‐05), which were paid for by bond
proceeds received in 2019.
Expenditures:
Capital Outlay ‐ Public Works 200,000
Revenues:
Use of Fund Balance (Bond Proceeds) 200,000
Exhibit G
2020 WATER TRUNK FUND BUDGET
2020 2020
2020 YTD Final
Adopted Amended 12/21/2020 Amended
Budget Budget Adjust Budget Notes
Revenues
Charges for services 1,828,600$ 1,828,600$ ‐$ 1,828,600$
Special Assessments 59,000 59,000 ‐ 59,000
Investment income (charges) 73,100 73,100 ‐ 73,100
Total revenues 1,960,700 1,960,700 ‐ 1,960,700
Expenditures ‐ Capital outlay
Public works 998,443 998,443 ‐ 998,443
Total expenditures 998,443 998,443 ‐ 998,443
Excess (deficiency) of revenues
over expenditures 962,257 962,257 ‐ 962,257
Other financing sources
Transfer to
Debt Service ‐ Water Revenue bonds (611,308) (611,308) ‐ (611,308)
Capital Proj. ‐ Municipal State Aid (1,225,000) (1,225,000) (69,164) (1,294,164) (1)
Total other financing sources (uses) (1,836,308) (1,836,308) (69,164) (1,905,472)
Net change in fund balance (874,051) (874,051) (69,164) (943,215) (1)
Fund balance, January 1 9,644,248 9,644,248 953,177 10,597,425 (2)
Fund balance, December 31 8,770,197$ 8,770,197$ 884,013$ 9,654,210$
Exhibit G
(1)Amend the budget for revised transfer estimates on the County Road 50
project, #15‐12. This was a County led project and the City is expected to
reimburse the County early in 2021 for the City share of costs incurred in
2018, 2019 and 2020.
Other Financing Uses:
Transfer to Municipal State Aid Fund 69,164
Revenues:
Use of Fund Balance (69,164)
(2)Amend the budgeted (estimated) January 1, 2020 Fund Balance to reflect
the actual January 1 Fund Balance.
Actual Fund Balance, January 1, 2020 10,597,425
Budgeted Fund Balance, January 1, 2020 9,644,248
Increase Fund Balance, January 1, 2020 953,177
Exhibit H
2020 STORMWATER INFRASTRUCTURE FUND BUDGET
2020 2020
2020 YTD Final
Adopted Amended 12/21/2020 Amended
Budget Budget Adjust Budget Notes
Revenues
Charges for services 1,052,264$ 1,052,264$ ‐$ 1,052,264$
Escrow 198 198 ‐ 198
Investment income (charges) 38,000 38,000 ‐ 38,000
Total revenues 1,090,462 1,090,462 ‐ 1,090,462
Expenditures ‐ Capital outlay
Public works 626,132 686,306 420,879 1,107,185 (3)(4)
Total expenditures 626,132 686,306 420,879 1,107,185
Excess (deficiency) of revenues
over expenditures 464,330 404,156 (420,879) (16,723)
Other financing sources
Transfer to
Capital Proj. ‐ Improv Const (105,000) (105,000) ‐ (105,000)
Capital Proj. ‐ Municipal State Aid (964,516) (1,090,491) (352,500) (1,442,991) (1)
Total other financing sources (uses) (1,069,516) (1,195,491) (352,500) (1,547,991)
Net change in fund balance (605,186) (791,335) (773,379) (1,564,714) (1)(3)(4)
Fund balance, January 1 7,882,174 7,882,174 1,100,401 8,982,575 (2)
Fund balance, December 31 7,276,988$ 7,090,839$ 327,022$ 7,417,861$
Exhibit H
(1)Amend the budget for revised transfer estimates on the County Road 50
project, #15‐12. This was a County led project and the City is expected to
reimburse the County early in 2021 for the City share of costs incurred in
2018, 2019 and 2020.
Other Financing Uses:
Transfer to Municipal State Aid Fund 352,500
Revenues:
Use of Fund Balance (352,500)
(2)Amend the budgeted (estimated) January 1, 2020 Fund Balance to reflect
the actual January 1 Fund Balance.
Actual Fund Balance, January 1, 2020 8,982,575
Budgeted Fund Balance, January 1, 2020 7,882,174
Increase Fund Balance, January 1, 2020 1,100,401
(3)Amend the budget for the stormwater portion of the purchase of 20308
Icalee Path (Doudrick property) in 2020.
Expenditures:
Capital Outlay ‐ Public Works 120,879
Revenues:
Use of Fund Balance 120,879
(4)Amend the budget for additional stormwater outlot and trunk storm
oversizing costs (developer credits) incurred in 2020.
Expenditures:
Capital Outlay ‐ Public Works 300,000
Revenues:
Use of Fund Balance 300,000
Exhibit I
2020 WATER OPERATING FUND BUDGET
2020 2020
2020 YTD Final
Adopted Amended 12/21/2020 Amended
Budget Budget Adjust Budget Notes
Operating revenues
User charges for services 5,762,460$ 5,762,460$ ‐$ 5,762,460$
Other 133,479 133,479 ‐ 133,479$
Total operating revenue 5,895,939 5,895,939 ‐ 5,895,939
Operating expenses
Personnel services 1,279,486 1,279,486 ‐ 1,279,486
Commodities 359,080 359,080 32,350 391,430 (3)
Other charges and services 1,409,280 1,409,280 48,879 1,458,159 (5)
Major maintenance 1,100,793 1,261,809 222,875 1,484,684 (1), (4)
Total operating expenses 4,148,639 4,309,655 304,104 4,613,759
Operating income (loss)1,747,300 1,586,284 (304,104) 1,282,180
Non‐operating revenue
Intergovernmental 1,632 1,632 ‐ 1,632
Investment income 32,484 32,484 ‐ 32,484
Disposal of assets (10,000) (10,000) ‐ (10,000)
Total non‐operating revenue 24,116 24,116 ‐ 24,116
1,771,416 1,610,400 (304,104) 1,306,296
Contributed capital 1,000,000 1,000,000 ‐ 1,000,000
Bond expense (333,737) (333,737) ‐ (333,737)
Transfers to other funds (703,367) (703,367) ‐ (703,367)
Depreciation (2,939,787) (2,939,787) ‐ (2,939,787)
(2,976,891) (2,976,891) ‐ (2,976,891)
Change in net position (1,205,475) (1,366,491) (304,104) (1,670,595) (1)(3)(4)(5)
Net position, January 1 92,266,368 92,266,368 4,846,321 97,112,689 (2)
Net position, December 31 91,060,894$ 90,899,878$ 4,542,217$ 95,442,094$
Capital outlay acquisitions 2,810,808$ 2,810,808$ 3,540$ 2,814,348$ (3)(6)
Bond proceeds 3,470,000$ 3,470,000$ ‐$ 3,470,000$
Debt principal payments 470,000$ 470,000$ ‐$ 470,000$
Total contributions, transfers,
and depreciation (net)
Income (loss) before
contributions, transfers, and
depreciation
Exhibit I
(1) Amend the budget for revised estimates on the County Road 70 project,
#20‐05. This is a County led project and this is the anticipated adjustment
needed to cover watermain‐related costs incurred on the project during
2020.
Expenses:
Major Maintenance 72,875
Revenues:
Use of Net Position 72,875
(2) Amend the budgeted (estimated) January 1, 2020 Net position to reflect
the actual January 1 Net position
Actual Net Position, January 1, 2020 97,112,689
Budgeted Net Position, January 1, 2020 92,266,368
Increase Net Position, January 1, 2020 4,846,321
(3) Amend the budget for Motorola radios, which were budgeted in capital
equipment but do not meet the capitalization threshold and thus recorded
in expenses.
Expenses:
Commodities 32,350
Offsetting adjustment:
Capital Outlay Acquisitions 32,350
(4) Amend the budget for estimated costs incurred in 2020 for a watermain
break at 165th St and Ipava Ave.
Expenses:
Major Maintenance 150,000
Revenues:
Use of Net Position 150,000
(5) Amend the budget for WonderWare SCADA costs incurred in 2020, which
were initially budgeted in 2019.
Expenses:
Other Charges and Services 48,879
Revenues:
Use of Net Position 48,879
(6) Amend the budget for the purchase of two new pickup truck costs
incurred in 2020, which were initially budgeted in 2019. Note this amount
is half of the total cost as the cost is split with the Sanitary Sewer
Operating Fund.
Expenses:
Capital Outlay Acquisitions 35,890
Revenues:
Use of Net Position 35,890