HomeMy WebLinkAbout2023-05-15 G01 FY2023 Budget Amendment_PHAGENDA ITEM:
CITY OF WAUKEE, IOWA
CITY COUNCIL MEETING COMMUNICATION
MEETING DATE: May 15th, 2023
AGENDA ITEM:On an amendment to the FY2023 Budget
FORMAT:Public Hearing
SYNOPSIS INCLUDING PRO & CON:After review of the current FY23 budget, the following changes
were needed:
FISCAL IMPACT INCLUDING COST/BENEFIT ANALYSIS:
COMMISSION/BOARD/COMMITTEE COMMENT:
STAFF REVIEW AND COMMENT: Attached worksheets break down the increases by fund
and departments. Review these worksheets and approve the FY2023
budget amendment as presented.
RECOMMENDATION: Hold the public hearing.
ATTACHMENTS: FY23 Notice of Public Hearing Amendment of Current City Budget
FY23 Budget Amendment Worksheets
PREPARED BY:Linda Burkhart / lsb
Revenue Sources:
Other City Taxes 912,000$
Licenses & Permits 3,425,200$
Use of Money & Property 2,826,350$
Intergovernmental 2,959,620$
Charges for Services 7,986,570$
Miscellaneous 220,200$
Other Financing Sources 60,400$
Transfers In 207,752$
18,598,092$
Expenditure Programs:
Public Safety (215,700)$
Public Works 192,200$
Health & Social Services -$
Culture & Recreation 184,480$
Community & Econ Develop (131,010)$
General Government 1,696,950$
Debt Service 665,046$
Capital Projects 8,100,000$
Business Type Enterprises 10,795,480$
Transfers Out 207,752$
21,495,198$
G1
REVIEWED BY:
PUBLIC NOTICE INFORMATION –
NAME OF PUBLICATION: Dallas County News
DATE OF PUBLICATION: May 4th, 2023
REVENUES & OTHER FINANCING SOURCES
Total Budget
as Certified
or Last Amended
Current
Amendment
Total Budget After
Current Amendment
Taxes Levied on Property 1 19,652,698 0 19,652,698
Less: Uncollected Delinquent Taxes - Levy Year 2 0 0 0
Net Current Property Tax 3 19,652,698 0 19,652,698
Delinquent Property Tax Revenue 4 0 0 0
TIF Revenues 5 7,115,100 0 7,115,100
Other City Taxes 6 4,316,853 912,000 5,228,853
Licenses & Permits 7 2,166,980 3,425,200 5,592,180
Use of Money & Property 8 606,700 2,826,350 3,433,050
Intergovernmental 9 3,791,600 2,959,620 6,751,220
Charges for Service 10 29,960,840 7,986,570 37,947,410
Special Assessments 11 0 0 0
Miscellaneous 12 1,142,400 220,200 1,362,600
Other Financing Sources 13 14,000,000 60,400 14,060,400
Transfers In 14 11,803,252 207,752 12,011,004
Total Revenues & Other Sources 15 94,556,423 18,598,092 113,154,515
EXPENDITURES & OTHER FINANCING USES
Public Safety 16 10,948,440 -215,700 10,732,740
Public Works 17 4,824,335 192,200 5,016,535
Health and Social Services 18 54,000 0 54,000
Culture and Recreation 19 3,942,840 184,480 4,127,320
Community and Economic Development 20 2,225,440 -131,010 2,094,430
General Government 21 4,563,630 1,696,950 6,260,580
Debt Service 22 8,334,574 665,046 8,999,620
Capital Projects 23 16,694,000 8,100,000 24,794,000
Total Government Activities Expenditures 24 51,587,259 10,491,966 62,079,225
Business Type/Enterprise 25 43,332,609 10,795,480 54,128,089
Total Gov Activities & Business Expenditures 26 94,919,868 21,287,446 116,207,314
Transfers Out 27 11,803,252 207,752 12,011,004
Total Expenditures/Transfers Out 28 106,723,120 21,495,198 128,218,318
Excess Revenues & Other Sources Over
(Under) Expenditures/Transfers Out 29 -12,166,697 -2,897,106 -15,063,803
Beginning Fund Balance July 1, 2022 30 100,025,685 0 100,025,685
Ending Fund Balance June 30, 2023 31 87,858,988 -2,897,106 84,961,882
Explanation of Changes: Revenues - Increased LOSST, building permits, interest earnings, ARPA grant funds, and utility user fees
Expenditures - COGS utilities, liability insurance, land purchases and capital projects
NOTICE OF PUBLIC HEARING - AMENDMENT OF CURRENT BUDGET
City of WAUKEE
Fiscal Year July 1, 2022 - June 30, 2023
The City of WAUKEE will conduct a public hearing for the purpose of amending the current budget for fiscal year ending June 30, 2023
Meeting Date/Time: 5/15/2023 05:30 PM Contact: Linda Burkhart, Finance Director Phone: (515) 978-7919 ext: 7919
Meeting Location: Waukee City Hall - 230 W Hickman Rd, Waukee, IA or https://zoom.us/j/352651371 Meeting ID 352-651-371 or by phone: +1 646-558-
8656 or +1 301-715-8592
There will be no increase in taxes. Any residents or taxpayers will be heard for or against the proposed amendment at the time and place specified above. A
detailed statement of: additional receipts, cash balances on hand at the close of the preceding fiscal year, and proposed disbursements, both past and
anticipated, will be available at the hearing. Budget amendments are subject to protest. If protest petition requirements are met, the State Appeal Board will
hold a local hearing. For more information, consult https://dom.iowa.gov/local-gov-appeals.
04/28/2023 10:38 AM Page 1 of 1
Proposed
Revenue Expenditures Reserve
General Fund Inc/(Dec)Inc/(Dec)Inc/(Dec)
General Fund Non-Department 382,990$ -$ 382,990$
Public Safety Program
Police Dept (20,700)$ (281,400)$ 260,700$
Warning Sirens -$ -$
Emergency Management -$ -$
Westcom Dispatch (57,000)$ 57,000$
Fire 71,600$ 76,800$ (5,200)$
EMS 47,760$ 60,100$ (12,340)$
Code Compliance 451,600$ (14,200)$ 465,800$
Animal Control 3,000$ -$ 3,000$
553,260$ (215,700)$ 768,960$
Public Works Program
Public Works -$ 6,750$ (6,750)$
Public Works Building -$ -$ -$
Public Works Mechanic 90,850$ 73,000$ 17,850$
Engineering 192,500$ 126,050$ 66,450$
GIS -$ (15,250)$ 15,250$
283,350$ 190,550$ 92,800$
Health & Social Services Program
Community Services -$ -$ -$
-$ -$ -$
Culture & Recreation Program
Hotel / Motel Tax 114,000$ 17,000$ 97,000$
Library 6,500$ (600)$ 7,100$
Parks 643,400$ 14,260$ 629,140$
Recreation 67,300$ 39,420$ 27,880$
Triumph Park 63,000$ 112,400$ (49,400)$
Community Center 6,100$ -$ 6,100$
Vineyard Property -$ 2,000$ (2,000)$
900,300$ 184,480$ 715,820$
Community & Economic Development Program
Median Maintenance -$ -$ -$
Community Development -$ 31,590$ (31,590)$
Development Services -$ (162,600)$ 162,600$
-$ (131,010)$ 131,010$
General Government
Mayor & Council -$ -$ -$
Elections -$ -$ -$
Communications -$ (73,500)$ 73,500$
Administration -$ 1,493,100$ (1,493,100)$
City Hall -$ 288,700$ (288,700)$
Human Resources -$ 7,500$ (7,500)$
Finance -$ (36,350)$ 36,350$
City Attorney -$ -$ -$
Information Technology -$ 17,500$ (17,500)$
-$ 1,696,950$ (1,696,950)$
Other Financing Sources/Uses
Transfers In/Out -$ -$ -$
Sale Property 60,400$ -$ 60,400$
60,400$ -$ 60,400$
General Fund Totals 2,180,300$ 1,725,270$ 455,030$
FY2023 - Budget Amendment Summary
FY2023 - Budget Amendment Summary
Proposed
Revenue Expenditures Reserve
Other Funds Inc/(Dec)Inc/(Dec)Inc/(Dec)
Road Use Fund 30,000$ 1,650$ 28,350$
TIF Funds -$ -$
Debt Service & Special Assessment Funds 219,000$ 665,046$ (446,046)$
Employee Benefits Fund 351,000$ 351,000$
Local Option Sales Tax Fund 1,207,000$ -$ 1,207,000$
Project Improvement Fund 81,000$ 81,000$
Capital Projects Funds 3,692,600$ 8,100,000$ (4,407,400)$
Water Fund 3,798,290$ 1,017,600$ 2,780,690$
Sewer Fund 4,492,400$ 5,096,100$ (603,700)$
Gas Fund 2,024,000$ 4,490,250$ (2,466,250)$
Storm Water Fund 140,500$ 3,210$ 137,290$
Utility Billing Fund 42,000$ 26,000$ 16,000$
Solid Waste Fund 16,250$ 103,450$ (87,200)$
Golf Course Fund 116,000$ 58,870$ 57,130$
Transfers In / Out 207,752$ 207,752$ -$
Other Fund Totals 16,417,792$ 19,769,928$ (3,352,136)$
FY23 Grand Totals 18,598,092$ 21,495,198$ (2,897,106)$
Current
G/L Acct #Description Budget Change Budget
Property Taxes
-$
Other City Taxes
010-00.0000.3010500 MOBILE HOME TAXES 14,000$ (2,000)$ 12,000$
011-00.0000.3011000 HOTEL/MOTEL TAXES 36,000$ 114,000$ 150,000$
112,000$
Licenses, Permits & Fees
010-00.0000.3210100 BEER PERMITS 1,000$ 1,000$ 2,000$
010-00.0000.3210200 LIQUOR LICENSES 21,000$ 6,000$ 27,000$
010-00.0000.3230100 PEDDLERS LICENSES 2,000$ 6,000$ 8,000$
010-00.0000.3240100 CABLE TELEVISION FRANCHISE 65,000$ (5,000)$ 60,000$
010-10.1400.4320150 PLAN REVIEW FEES -$ 1,100$ 1,100$
010-10.1900.4300000 BUILDING PERMITS 1,500,000$ 400,000$ 1,900,000$
010-10.1900.4300010 RENTAL INSPECTION FEES 30,000$ 15,000$ 45,000$
010-10.1900.4310100 SUBDIVISION PLATING FEES 10,000$ 6,000$ 16,000$
010-10.1900.4320100 SITE PLAN REVIEW FEES 12,000$ 10,000$ 22,000$
010-20.8900.4320000 ENGINEER REVIEW REIMBURSEMENT 75,000$ 100,000$ 175,000$
010-20.8900.4320600 CONSTRUCTION INSPECT FEES 350,000$ 90,000$ 440,000$
010-20.8900.4320700 ENGINEER ADMINISTRATIVE FEES 7,500$ 2,500$ 10,000$
010-40.4100.4520000 PARKLAND DEDICATION FEES -$ 570,000$ 570,000$
1,202,600$
Use of Money & Property
010-00.0000.3610000 INTEREST ON DEPOSITS 20,000$ 230,000$ 250,000$
010-00.0000.4532000 CITY PROPERTY RENT 79,000$ (14,000)$ 65,000$
010-40.4100.453000 PARK SHELTER RENT 25,000$ 20,000$ 45,000$
010-40.4100.4530050 PARK LAND RENT -$ 41,200$ 41,200$
010-40.4100.4530200 BALL FIELD RENT -$ 8,000$ 8,000$
010-40.4300.4531000 COMMUNITY CENTER RENT 20,000$ 5,000$ 25,000$
011-00.0000.3610000 INTEREST ON DEPOSITS 100$ 4,900$ 5,000$
295,100$
Intergovernmental
010-00.0000.3010100 COMMERCIAL & INDUSTRIAL BACKFILL 50,000$ 95,290$ 145,290$
010-10.1100.4020210 OFFICER CONTRACT BUY OUT -$ 9,700$ 9,700$
010-10.1100.4020310 COUNTY MENTAL HELTH REIMBURSEMENT 202,500$ (92,500)$ 110,000$
010-10.1400.4020100 FIRE PREVENTION GRANT -$ 14,200$ 14,200$
010-10.1400.4110000 TOWNSHIP FIRE TAX 40,000$ 38,000$ 78,000$
010-10.1400.4131000 FIRE EQUIPMENT GRANT -$ 1,000$ 1,000$
010-40.3100.4410000 LIBRARY OPEN ACCESS 20,000$ (1,500)$ 18,500$
010-40.3100.4430000 COUNTY LIBRARY SERVICES 10,000$ 8,000$ 18,000$
010-40.4100.4400100 IOWA DEPT NAT RESOURCES GRANT -$ 2,500$ 2,500$
74,690$
Charges For Services
010-10.1100.4010300 SAFETY CITY REGISTRATION FEES 2,000$ 10,000$ 12,000$
010-10.1100.4030201 POLICE OFFICER LABOR REIMBURSEMENT 20,000$ 21,000$ 41,000$
010-10.1400.4010300 HAZ MAT FEES -$ 1,500$ 1,500$
010-10.1500.3529900 AMBULANCE TRANSPORTS 630,000$ 45,000$ 675,000$
010-10.1500.4517400 CPR/FIRST AID TRAINING CLASS -$ 2,760$ 2,760$
010-10.1900.3770210 CREDIT CARD PROCESSING FEES -$ 19,000$ 19,000$
010-10.1900.3988300 ADMIN/RECORDING FEES 1,000$ 1,600$ 2,600$
010-10.2400.4030200 ANIMAL IMPOUNDMENT -$ 3,000$ 3,000$
010-40.4100.6010010 PLANT SOME SHADE 12,000$ (1,400)$ 10,600$
010-40.4200.4517000 WINTER PROGRAMS 20,000$ 26,500$ 46,500$
010-40.4200.4517500 SUMMER PROGRAMS 60,000$ 24,000$ 84,000$
010-40.4200.4540200 SOFTBALL-YOUTH REGISTRATIONS 45,000$ 10,000$ 55,000$
010-20.6150.6200600 MECHANIC FEES - ROADS 65,000$ 25,000$ 90,000$
010-20.6150.6201100 MECHANIC FEES - POLICE 9,000$ 9,000$ 18,000$
010-20.6150.6201400 MECHANIC FEES - FIRE 10,000$ (4,000)$ 6,000$
010-20.6150.6201900 MECHANIC FEES - BLDG INSPECT 2,400$ 2,600$ 5,000$
010-20.6150.6205100 MECHANIC FEES - WATER 50,000$ 10,000$ 60,000$
010-20.6150.6205200 MECHANIC FEES - SEWER 53,000$ 17,000$ 70,000$
010-20.6150.6205400 MECHANIC FEES - GAS 48,000$ 12,000$ 60,000$
010-20.6150.6205600 MECHANIC FEES - STORM WATER 12,000$ (5,000)$ 7,000$
010-20.6150.6206000 MECHANIC FEES - PUBLIC WORKS 12,000$ 23,000$ 35,000$
Proposed
General Fund - FY2023 Proposed Revenue Budget Amendment
Total Licenses, Permits & Fees
Total Use of Money & Property
Total Intergovernmental
Total Property Taxes
Total Other City Taxes
Current
G/L Acct #Description Budget Change Budget
Proposed
010-20.6150.6208950 MECHANIC FEES - GIS 750$ 1,250$ 2,000$
253,810$
Miscellaneous
010-00.0000.3770000 MISCELLANEOUS 5,000$ 8,200$ 13,200$
010-00.0000.3775000 DAMAGE REIMBURSEMENT -$ 56,000$ 56,000$
010-00.0000.3775600 PATRONAGE REBATE 600$ 1,600$ 2,200$
010-00.0000.6120000 LATE FEES PENALTIES 5,000$ (5,000)$ -$
010-10.1100.4030000 POLICE DONATIONS -$ 29,650$ 29,650$
010-10.1100.4030100 COMMUNITY POLICING / DARE DONATIONS -$ 1,450$ 1,450$
010-10.1400.3760300 SALE OF EQUIPMENT (FIRE)35,000$ 11,800$ 46,800$
010-10.1400.4120000 FIRE/EMS DONATIONS -$ 1,200$ 1,200$
010-10.1400.4320160 INSPECTION VIOLATION FINES -$ 2,800$ 2,800$
010-40.4100.3760800 PARK DONATIONS -$ 2,100$ 2,100$
010-40.4100.3770450 COMMUNITY GRANTS -$ 1,000$ 1,000$
010-40.4200.3761200 CORPORATE SPONSORSHIP -$ 2,800$ 2,800$
010-40.4200.4510200 4TH OF JULY CELEBRATION 1,000$ 4,000$ 5,000$
010-40.4210.4516200 TP CONCESSIONS 177,000$ 63,000$ 240,000$
010-40.4300.3760300 SALE OF EQUIPMENT (COMM CNTR)-$ 1,100$ 1,100$
181,700$
Other Financing Sources
010-00.0000.3755000 SALE OF PROPERTY -$ 60,400$ 60,400$
010-00.0000.3980300 TRANSFER FROM TIF (LMI)-$ -$
60,400$
2,180,300$
1,725,270$
455,030$ Total Proposed FY23 Excess to General Fund Reserves
Total Proposed FY23 General Fund Revenue Increase
Total Proposed FY23 General Fund Expenditure Increase
Total Charges For Services
Total Miscellaneous
Total Other Financing Sources
Current Proposed
G/L Acct #Description Budget Recommend Budget
Police
010-10.1100.010000 SALARIES 2,959,000$ (209,000)$ 2,750,000$
010-10.1100.010500 OVERTIME PAY 200,000$ 25,000$ 225,000$
010-10.1100.011000 PART TIME -$ 20,000$ 20,000$
010-10.1100.060000 FICA CONTRIBUTION 197,000$ (10,000)$ 187,000$
010-10.1100.070000 MEDICARE CONTRTIBUTION 46,500$ (2,300)$ 44,200$
010-10.1100.080000 IPERS CONTRTIBUTION 295,000$ (15,000)$ 280,000$
010-10.1100.090000 CITY SHARE ICMA -$ 3,800$ 3,800$
010-10.1100.100000 HEALTH & LIFE INSURANCE 605,000$ (130,000)$ 475,000$
010-10.1100.102100 RETIREMENT HEALTH SAVINGS -$ 11,300$ 11,300$
010-10.1100.110000 WORKERS COMPENSATION 24,000$ (3,000)$ 21,000$
010-10.1100.290100 VEHICLE INSURANCE 6,000$ 400$ 6,400$
010-10.1100.290300 BUILDING & CONTENTS INSURANCE 9,000$ 1,550$ 10,550$
010-10.1100.290400 LAW ENFORCEMENT LIABILITY INSUR 11,700$ 6,850$ 18,550$
010-10.1100.410050 REPAIR/MAINT - WAUKEE MECHANIC 9,000$ 9,000$ 18,000$
010-10.1100.570000 FUEL 47,500$ 10,000$ 57,500$
(281,400)$ `
Warning Sirens
010-10.1110.760100 WARNING SIRENS -$ -$
-$
Emergency Management
010-10.1130.460220 COVID19 EMERGENCY EXPENDITURES -$ -$
-$
Westcom Dispatch
010-10.1300.230010 WESTCOM DISPATCH SERVICES 732,000$ (57,000)$ 675,000$
(57,000)$
Fire
010-10.1400.010000 SALARIES 571,000$ 79,000$ 650,000$
010-10.1400.010500 OVERTIME PAY 40,000$ 5,000$ 45,000$
010-10.1400.060000 FICA CONTRIBUTION 44,000$ 5,200$ 49,200$
010-10.1400.070000 MEDICARE CONTRIBUTION 11,000$ 1,200$ 12,200$
010-10.1400.080000 IPERS CONTRIBUTION 66,500$ 7,800$ 74,300$
010-10.1400.100000 HEALTH & LIFE INSURANCE 137,000$ (37,000)$ 100,000$
010-10.1400.110000 WORKERS COMPENSATION 72,000$ (21,000)$ 51,000$
010-10.1400.270000 DATA PROCESSING 3,800$ 2,200$ 6,000$
010-10.1400.410050 REPAIR/MAINT WAUKEE MECHANIC 10,000$ (4,000)$ 6,000$
010-10.1400.410100 REPAIR/MAINT WAUKEE EQUIPMENT 6,000$ 11,500$ 17,500$
010-10.1400.450000 TELEPHONE 2,400$ 1,400$ 3,800$
010-10.1400.460150 FIRE PREVENTION GRANT EXPEND -$ 14,500$ 14,500$
010-10.1400.480000 UTILITY SERVICES 13,000$ 4,000$ 17,000$
010-10.1400.570000 FUEL 8,000$ 7,000$ 15,000$
76,800$
EMS
010-10.1500.010000 SALARIES 1,159,000$ (30,000)$ 1,129,000$
010-10.1500.010500 OVERTIME PAY 130,000$ 30,000$ 160,000$
010-10.1500.110000 WORKERS COMPENSATION 165,500$ 11,500$ 177,000$
010-10.1500.130000 TUITION REIMBURSEMENT 8,000$ 1,700$ 9,700$
010-10.1500.450000 TELEPHONE 7,000$ 1,500$ 8,500$
010-10.1500.460150 GRANT EXPENDITURES -$ 32,900$ 32,900$
010-10.1500.480000 UTILITY SERVICES 8,500$ 5,500$ 14,000$
010-10.1500.570000 FUEL 8,000$ 7,000$ 15,000$
General Fund - FY2023 Proposed Expenditure Budget Amendment
Total Police Dept Proposed Amendment
Total Warning Sirens Dept Proposed Amendment
Total Westcom Dispatch Dept Proposed Amendment
Total Fire Dept Proposed Amendment
Total Emergency Management Dept Proposed Amendment
Current Proposed
G/L Acct #Description Budget Recommend Budget
60,100$
Code
010-10.1900.010000 SALARIES 595,000$ (35,000)$ 560,000$
010-10.1900.060000 FICA CONTRIBUTION 38,000$ (2,000)$ 36,000$
010-10.1900.070000 MEDICARE CONTRIBUTION 9,000$ (500)$ 8,500$
010-10.1900.080000 IPERS CONTRIBUTION 57,500$ (3,300)$ 54,200$
010-10.1900.100000 HEALTH & LIFE INSURANCE 150,000$ (40,000)$ 110,000$
010-10.1900.110000 WORKERS COMPENSATION 3,500$ (2,100)$ 1,400$
010-10.1900.230000 CONSULTANT & PROFESSIONAL -$ 44,100$ 44,100$
010-10.1900.410050 REPAIR/MAINTENANCE WAUKEE MECH 2,400$ 2,600$ 5,000$
010-10.1900.450000 TELEPHONE 4,500$ 3,000$ 7,500$
010-10.1900.450200 CREDIT CARD FEES -$ 19,000$ 19,000$
(14,200)$
Animal Control
010-10.2400.340000 Miscellaneous Contractual -$
-$
(215,700)$
Public Works
010-20.6000.090000 CITY SHARE ICMA 5,040$ 2,500$ 7,540$
010-20.6000.100000 HEALTH & LIFE INSURANCE 112,000$ (12,000)$ 100,000$
010-20.6000.110000 WORKERS COMPENSATION 2,500$ (1,000)$ 1,500$
010-20.6000.270100 COMPUTER SUPPORT -$ 1,500$ 1,500$
010-20.6000.290000 GENERAL LIABILITY INSURANCE 6,500$ 1,000$ 7,500$
010-20.6000.290100 VEHICLE INSURANCE 600$ 400$ 1,000$
010-20.6000.450000 TELEPHONE 450$ 5,600$ 6,050$
010-20.6000.570000 FUEL 2,000$ 4,000$ 6,000$
010-20.6000.590000 OPERATING SUPPLIES & MATERIALS 500$ 1,500$ 2,000$
010-20.6000.691100 PUBLIC WORKS BLDG REIMBURSE 16,580$ 3,250$ 19,830$
6,750$
Public Works Building
010-20.6010.400100 CUSTODIAL SERVICES 17,000$ 6,000$ 23,000$
010-20.6010.410050 REPAIR/MAINT - WAUKEE MECHANIC -$ 22,250$ 22,250$
010-20.6010.450000 TELEPHONE 10,000$ 1,000$ 11,000$
010-20.6010.480000 UTILITY SERVICES 55,000$ 18,000$ 73,000$
010-20.6010.510100 GARBAGE PICK UP 1,300$ 2,700$ 4,000$
010-20.6010.590000 OPERATING SUPPLIES & MATERIALS 20,000$ 4,000$ 24,000$
010-20.6010.690100 REIMBURSEMENT-PARKS (8,290)$ (1,620)$ (9,910)$
010-20.6010.690200 REIMBURSEMENT-RECREATION (8,290)$ (1,620)$ (9,910)$
010-20.6010.690300 REIMBURSEMENT-ENGINEERING (16,580)$ (3,250)$ (19,830)$
010-20.6010.690400 REIMBURSEMENT-PUBLIC WORKS (16,580)$ (3,250)$ (19,830)$
010-20.6010.690500 REIMBURSEMENT-ROADS (52,500)$ (10,250)$ (62,750)$
010-20.6010.690600 REIMBURSEMENT-WATER (52,500)$ (10,250)$ (62,750)$
010-20.6010.690700 REIMBURSEMENT-SEWER (52,500)$ (10,250)$ (62,750)$
010-20.6010.690800 REIMBURSEMENT-GAS (52,500)$ (10,250)$ (62,750)$
010-20.6010.690900 REIMBURSEMENT-STORM WATER (16,560)$ (3,210)$ (19,770)$
-$
Public Works Mechanic
010-20.6150.270100 COMPUTER SUPPORT 500$ 3,000$ 3,500$
010-20.6150.410050 REPAIR/MAINT-WAUKEE MECHANIC -$ 750$ 750$
010-20.6150.450000 TELEPHONE 750$ 2,250$ 3,000$
010-20.6150.570130 COGS - PARTS 80,000$ 60,000$ 140,000$
010-20.6150.590000 OPERATING SUPPLIES & MATERIALS 23,000$ 7,000$ 30,000$
73,000$ Total Public Works Mechanic Proposed Amendment
Total Public Safety Program Proposed Amendment
Total Public Works Proposed Amendment
Total Public Works Building Proposed Amendment
Total Code Dept Proposed Amendment
Total EMS Dept Proposed Amendment
Total Animal Control Proposed Amendment
Current Proposed
G/L Acct #Description Budget Recommend Budget
Engineering
010-20.8900.010500 OVERTIME PAY 80,000$ (30,000)$ 50,000$
010-20.8900.060000 FICA CONTRIBUTION 28,500$ (1,500)$ 27,000$
010-20.8900.080000 MEDICARE CONTRIBUTION 7,000$ (400)$ 6,600$
010-20.8900.080000 IPERS CONTRIBUTION 43,500$ (2,800)$ 40,700$
010-20.8900.110000 WORKERS COMPENSATION 3,000$ (1,500)$ 1,500$
010-20.8900.120000 UNIFORMS 2,500$ 1,500$ 4,000$
010-20.8900.230000 CONSULTANT & PROFESSIONAL FEES 3,000$ 12,000$ 15,000$
010-20.8900.231200 DEVELOPERS ENGINEERING REVIEW 75,000$ 125,000$ 200,000$
010-20.8900.410050 REPAIR/MAINT WAUKEE MECH (10,000)$ 20,000$ 10,000$
010-20.8900.450000 TELEPHONE 4,500$ 500$ 5,000$
010-20.8900.691100 PUBLIC WORKS BLDG REIMBURSE 16,580$ 3,250$ 19,830$
126,050$
GIS
010-20.8950.100000 HEALTH & LIFE INSURANCE 32,000$ (22,000)$ 10,000$
010-20.8950.110000 WORKERS COMPENSATION 1,500$ (750)$ 750$
010-20.8950.450000 TELEPHONE 1,500$ 7,500$ 9,000$
(15,250)$
190,550$
Community Services
010-30.3610.210212 WAUKEE AREA CHRISTIAN SERVICES -$
-$
Total Health & Social Services Program Proposed Amendment -$
Library
010-40.3100.090000 CITY SHARE ICMA 5,040$ 2,500$ 7,540$
010-40.3100.100000 HEALTH & LIFE INSURANCE 121,000$ (21,000)$ 100,000$
010-40.3100.210100 PROMOTION 5,000$ 2,500$ 7,500$
010-40.3100.270000 DATA PROCESSING 30,000$ 5,000$ 35,000$
010-40.3100.270100 COMPUTER SUPPORT -$ 2,200$ 2,200$
010-40.3100.270110 COPIER / PRINTER LEASE & MAINT -$ 3,100$ 3,100$
010-40.3100.290300 BUILDING & CONTENTS INSURANCE 14,000$ 2,300$ 16,300$
010-40.3100.450200 CREDIT CARD FEES 500$ 800$ 1,300$
010-40.3100.480000 UTILITY SERVICES 40,000$ 2,000$ 42,000$
(600)$
Parks
010-40.4100.100000 HEALTH & LIFE INSURANCE 58,000$ (8,000)$ 50,000$
010-40.4100.290000 GENERAL LIABILITY INSURANCE 5,000$ 1,300$ 6,300$
010-40.4100.290100 VEHICLE INSURANCE 2,500$ (610)$ 1,890$
010-40.4100.290300 BUILDING & CONTENTS INSURANCE 22,000$ 3,950$ 25,950$
010-40.4100.480000 UTILITY SERVICES 13,000$ 9,000$ 22,000$
010-40.4100.480011 UTILITIES-FOX CREEK SPLASH PAD 7,000$ 3,000$ 10,000$
010-40.4100.480100 UTILITIES-PARK IRRIGATION 14,000$ 1,000$ 15,000$
010-40.4100.570000 FUEL 12,000$ 3,000$ 15,000$
010-40.4100.691100 PUBLIC WORKS BLDG REIMBURSE 8,290$ 1,620$ 9,910$
14,260$
Recreation
010-40.4200.100000 HEALTH & LIFE INSURANCE 66,500$ (10,500)$ 56,000$
010-40.4200.290000 GENERAL LIABILITY INSURANCE 4,500$ 1,600$ 6,100$
010-40.4200.350100 PRINTING 2,500$ 1,000$ 3,500$
010-40.4200.450000 TELEPHONE 3,000$ 1,000$ 4,000$
010-40.4200.450200 CREDIT CARD FEES 9,000$ 3,000$ 12,000$
Total Parks Proposed Amendment
Total Community Servicesl Proposed Amendment
Total GIS Proposed Amendment
Total Public Works Program Proposed Amendment
Total Library Proposed Amendment
Total Enginerring Proposed Amendment
Current Proposed
G/L Acct #Description Budget Recommend Budget
010-40.4200.460000 COMMUNITY SERVICES 36,500$ 5,000$ 41,500$
010-40.4200.460500 SUMMER RECREATION PROGRAMS 45,000$ 20,000$ 65,000$
010-40.4200.460550 WINTER RECREATION PROGRAMS 14,000$ 16,700$ 30,700$
010-40.4200.691100 PUBLIC WORKS BLDG REIMBURSE 8,290$ 1,620$ 9,910$
39,420$
Triumph Park
010-40.4210.290300 BUILDING & CONTENTS INSUR -$ 23,400$ 23,400$
010-40.4210.480000 UTILITY SERVICES 15,000$ 42,000$ 57,000$
010-40.4210.570000 FUEL 5,000$ 5,000$ 10,000$
010-40.4210.650100 COGS-BEVERAGES 25,000$ 12,000$ 37,000$
010-40.4210.650200 COGS-SNACKS/CANDY -$ 5,000$ 5,000$
010-40.4210.650250 COGS-FOOD/GRILL 40,000$ 25,000$ 65,000$
112,400$
Community Center
010-40.4300.290000 GENERAL LIABILITY INSURANCE -$
-$
Centennial West Property
010-40.4310.480000 UTILITY SERVICES 2,000$ 2,000$ 4,000$
2,000$
Hotel / Motel Tax
011-40.0000.459001 BRAVO GREATER DES MOINES 28,000$ 17,000$ 45,000$
17,000$
184,480$
Median Maintenance
010-50.6500.480050 UTILITIES - TRAILS -$
-$
Community Development
010-50.8500.010000 SALARIES 105,000$ 5,000$ 110,000$
010-50.8500.060000 FICA CONTRIBUTION 7,000$ 300$ 7,300$
010-50.8500.080000 IPERS CONTRIBUTION 10,000$ 500$ 10,500$
010-50.8500.090000 CITY SHARE ICMA -$ 7,540$ 7,540$
010-50.8500.270000 DATA PROCESSING 13,250$ 14,250$ 27,500$
010-50.8500.280000 DUES MEMBERSHIPS & SUBSCRIPTIONS 3,000$ 4,000$ 7,000$
31,590$
Development Services
010-50.8700.010000 SALARIES 430,000$ (120,000)$ 310,000$
010-50.8700.060000 FICA CONTRIBUTION 27,000$ (7,400)$ 19,600$
010-50.8700.070000 MEDICARE CONTRIBUTION 6,500$ (1,700)$ 4,800$
010-50.8700.080000 IPERS CONTRIBUTION 41,500$ (11,000)$ 30,500$
010-50.8700.090000 CITY SHARE ICMA 5,040$ 2,500$ 7,540$
010-50.8700.100000 HEALTH & LIFE INSURANCE 63,000$ (25,000)$ 38,000$
(162,600)$
Total Community & Economic Development Program Proposed Amendment (131,010)$
Mayor & Council
010-60.8100.290000 GENERAL LIABILITY INSURANCE 12,000$ 4,500$ 16,500$
010-60.8100.470000 TRAINING/TRAVEL EXPENSE 15,000$ (4,500)$ 10,500$
-$ Total Mayor & Council Proposed Amendment
Total Median Maintenance Proposed Amendment
Total Culture & Recreation Program Proposed Amendment
Total Triumph Park Proposed Amendment
Total Vineyard Property Proposed Amendment
Total Hotel / Motel Tax Proposed Amendment
Total Recreation Proposed Amendment
Total Community Center Proposed Amendment
Total Planning Proposed Amendment
Total Community Development Proposed Amendment
Current Proposed
G/L Acct #Description Budget Recommend Budget
Elections
010-60.8110.231600 ELECTION EXPENSE -$
-$
Communications
010-60.8200.010000 SALARIES 185,000$ (60,000)$ 125,000$
010-60.8200.060000 FICA CONTRIBUTION 12,000$ (3,700)$ 8,300$
010-60.8200.070000 MEDICARE CONTRIBUTION 3,000$ (800)$ 2,200$
010-60.8200.080000 IPERS CONTRIBUTION 18,000$ (5,500)$ 12,500$
010-60.8200.090000 CITY SHARE ICMA 5,040$ 2,500$ 7,540$
010-60.8200.100000 HEALTH & LIFE INSURANCE 32,000$ (6,000)$ 26,000$
(73,500)$
Administration
010-60.8300.010000 SALARIES 440,000$ (20,000)$ 420,000$
010-60.8300.060000 FICA CONTRIBUTION 29,500$ (1,200)$ 28,300$
010-60.8300.070000 MEDICARE CONTRIBUTION 7,000$ (300)$ 6,700$
010-60.8300.080000 IPERS CONTRIBUTION 44,500$ (1,900)$ 42,600$
010-60.8300.090000 CITY SHARE ICMA 18,500$ 23,500$ 42,000$
010-60.8300.100000 HEALTH & LIFE INSURANCE 67,000$ (17,000)$ 50,000$
010-60.8300.210000 PUBLIC NOTIFICATION/ADVERTISING 15,000$ 5,000$ 20,000$
010-60.8300.390400 RENTAL PROPERTY EXPENSES -$ 4,500$ 4,500$
010-60.8300.450000 TELEPHONE 16,000$ (13,500)$ 2,500$
010-60.8300.470000 TRAINING/TRAVEL EXPENSES 12,000$ 14,000$ 26,000$
010-60.8300.850000 LAND PURCHASES 2,600,000$ 1,500,000$ 4,100,000$
1,493,100$
City Hall
010-60.8310.290000 CITY HALL ANNEX INSURANCE 1,500$ 400$ 1,900$
010-60.8310.290300 BUILDING & CONTENTS INSURANCE 12,000$ 1,300$ 13,300$
010-60.8310.400100 CUSTODIAL SERVICES 18,000$ 3,000$ 21,000$
010-60.8310.480000 UTILITY SERVICES 15,000$ 4,000$ 19,000$
010-60.8310.832000 PROFESSIONAL PLAZA BUILDING -$ 280,000$ 280,000$
288,700$
Human Resources
010-60.8350.090000 CITY SHARE ICMA 5,040$ 2,500$ 7,540$
010-60.8350.100000 HEALTH & LIFE INSURANCE 45,000$ (5,000)$ 40,000$
010-60.8350.100050 EMPLOYEE WELLNESS 40,000$ 10,000$ 50,000$
7,500$
Finance
010-60.8400.011000 PART TIME 61,500$ (11,500)$ 50,000$
010-60.8400.060000 FICA CONTRIBTUION 28,500$ (700)$ 27,800$
010-60.8400.070000 MEDICARE CONTRIBTUION 7,000$ (150)$ 6,850$
010-60.8400.080000 IPERS CONTRIBTUION 43,000$ (1,000)$ 42,000$
010-60.8400.100000 HEALTH & LIFE INSURANCE 73,000$ (28,000)$ 45,000$
010-60.8400.270000 DATA PROCESSING 15,000$ 3,500$ 18,500$
010-60.8400.270110 COPIER / PRINTER LEASE & MAINT 500$ 1,500$ 2,000$
(36,350)$
City Attorney
010-60.8600.230000 CONSULTANT & PROFESSIONAL FEES -$
-$
Information Technology
010-60.8800.010500 OVERTIME PAY 1,000$ (1,000)$ -$
010-60.8800.090000 CITY SHARE ICMA 5,040$ 2,500$ 7,540$
Total City Hall Proposed Amendment
Total Human Resources Proposed Amendment
Total Elections Proposed Amendment
Total Communications Proposed Amendment
Total Administration Proposed Amendment
Total Finance Proposed Amendment
Total City Attorney Proposed Amendment
Current Proposed
G/L Acct #Description Budget Recommend Budget
010-60.8800.100000 HEALTH & LIFE INSURANCE 73,000$ (9,000)$ 64,000$
010-60.8800.450000 TELEPHONE 4,000$ 3,000$ 7,000$
010-60.8800.540000 MINOR EQUIPMENT 15,500$ 19,500$ 35,000$
010-60.8800.590000 OPERATING SUPPLIES & MATERIALS 1,500$ 2,500$ 4,000$
17,500$
Total General Government Program Proposed Amendment 1,696,950$
Transfers
010-60.8400.970100 Transfer To Commerce Bank Reserve
-$
1,725,270$
Total Transfers Proposed Amendment
Total General Fund Changes
Total Information Technology Proposed Amendment
Current
Amended
G/L Acct #Description Fund Budget Inc/Dec Budget
Property Taxes
-$ -$ -$
-$
Other City Taxes
211-00.0000.3011200 PROPERTY TAX RELIEF (50%)LOCAL OPTION SALES 2,100,000$ 400,000$ 2,500,000$
211-00.0000.3011205 QUALITY OF LIFE (50%)LOCAL OPTION SALES 2,100,000$ 400,000$ 2,500,000$
800,000$
Licenses, Permits, Fees
060-30.1600.4310300 DEVELOPER STREET LIGHT REIMB ROAD USE TAX FUND -$ 5,000$ 5,000$
060-30.7100.4310300 DEVELOPER STREET SIGN FEES ROAD USE TAX FUND 5,000$ 5,000$ 10,000$
327-90.2130.4321500 CONTRACTOR REIMBURSEMENT CAPITAL PROJECTS -$ 277,000$ 277,000$
327-90.7200.43210000 DEVELOPER REIMBURSEMENT CAPITAL PROJECTS -$ 1,935,600$ 1,935,600$
2,222,600$
Use of Money & Property
110-30.7800.3610000 INTEREST ON DEPOSITS DEBT SERVICE FUND 11,000$ 219,000$ 230,000$
210-00.0000.3610000 INTEREST ON DEPOSITS EMPLOYEE BENEFITS 3,000$ 47,000$ 50,000$
211-00.0000.3610000 INTEREST ON DEPOSITS LOCAL OPTION SALES 18,000$ 407,000$ 425,000$
212-00.0000.3610000 INTEREST ON DEPOSITS PUBLIC IMPROVE 4,000$ 81,000$ 85,000$
327-90.2200.3610000 INTEREST ON DEPOSITS CAPITAL PROJECTS -$ 700,000$ 700,000$
510-30.6510.3610000 INTEREST ON DEPOSITS WATER FUND 40,000$ 485,000$ 525,000$
510-30.6510.3620000 WATER TOWER RENTAL WATER FUND 71,000$ 8,000$ 79,000$
520-30.6520.3610000 INTEREST ON DEPOSITS WASTE WATER FUND 45,000$ 345,000$ 390,000$
540-30.6540.3610000 INTEREST ON DEPOSITS GAS FUND 12,000$ 178,000$ 190,000$
560-80.5300.3610000 INTEREST ON DEPOSITS STORM WATER FUND 1,500$ 37,500$ 39,000$
590-30.5400.3610000 INTEREST ON DEPOSITS SOLID WASTE FUND 750$ 16,250$ 17,000$
750-80.8750.3610000 INTEREST ON DEPOSITS GOLF COURSE FUND -$ 7,500$ 7,500$
2,531,250$
Intergovernmental
210-00.0000.3071950 COMMERCIAL & INDUSTR BACKFILL EMPLOYEE BENEFITS 12,000$ 304,000$ 316,000$
327-90.1601.3350000 FEDERAL GRANT FUNDS CAPITAL PROJECTS -$ 780,000$ 780,000$
510-30.6510.3350010 ARPA GRANT FUNDS WATER FUND -$ 1,800,930$ 1,800,930$
2,884,930$
Charges For Services
510-30.6510.6010000 METERED SALES WATER FUND 7,065,640$ 734,360$ 7,800,000$
510-30.6510.6140100 METER FEES WATER FUND 255,000$ 245,000$ 500,000$
510-30.6510.6140500 DEVELOPMENT CAPITAL FEES WATER FUND 200,000$ 525,000$ 725,000$
520-30.6520.6010000 METERED SALES WASTE WATER FUND 6,093,000$ 307,000$ 6,400,000$
520-30.6520.6140100 CONNECTION FEES WASTE WATER FUND 200,000$ 1,900,000$ 2,100,000$
520-30.6520.6140120 CONNECTION FEE-ALICES ROAD WASTE WATER FUND -$ 40,400$ 40,400$
520-30.6520.6140500 DEVELOPMENT CAPITAL FEES WASTE WATER FUND 300,000$ 1,900,000$ 2,200,000$
540-30.6540.6010000 METERED SALES GAS FUND 10,490,000$ 1,810,000$ 12,300,000$
540-30.6540.6140150 COMMERCIAL METER FEES GAS FUND 74,000$ 36,000$ 110,000$
560-80.5300.6010100 RESIDENTIAL FEES STORM WATER FUND 708,000$ 67,000$ 775,000$
560-80.5300.6010200 COMMERCIAL FEES STORM WATER FUND 565,000$ 28,000$ 593,000$
560-80.5300.6145100 RESIDENTIAL COMPLIANCE FEES STORM WATER FUND 70,000$ 8,000$ 78,000$
570-30.6550.3370300 POSTING FEES UTILITY BILLING FUND -$
570-30.6550.3770210 CREDIT CARD PROCESSING FEES UTILITY BILLING FUND 70,000$ 42,000$ 112,000$
590-30.5400.3431000 SOLID WASTE COLLECTION SOLID WASTE FUND -$
750-80.8750.4600000 ADMISSIONS-WEEKDAYS GOLF COURSE FUND 120,000$ 40,000$ 160,000$
750-80.8750.4600200 SEASON PASSES GOLF COURSE FUND 30,000$ 15,000$ 45,000$
750-80.8750.4601000 CART RENTAL FEES GOLF COURSE FUND 140,000$ 35,000$ 175,000$
7,732,760$
Miscellaneous
060-30.1600.3775600 PATRONAGE REBATE ROAD USE FUND -$ 900$ 900$
060-30.1601.3775000 DAMAGE/DEVELOPER REIMBURSE ROAD USE FUND -$ 10,600$ 10,600$
060-30.7100.3760300 SALE OF OLD EQUIPMENT ROAD USE FUND 14,500$ 7,000$ 21,500$
060-30.7100.3775000 DAMAGE REIMBURSE ROAD USE FUND -$ 1,500$ 1,500$
510-30.6510.3770000 MISCELLANEOUS WATER FUND -$ -$
750-80.8750.4602000 PRO SHOP MERCHANDISE SALES GOLF COURSE FUND 15,000$ 5,000$ 20,000$
750-80.8750.4603000 CONCESSIONS-BEER/ALCOHOL GOLF COURSE FUND 50,000$ 9,000$ 59,000$
750-80.8750.4603100 CONCESSIONS-POP/WATER GOLF COURSE FUND 13,000$ 3,000$ 16,000$
Other Funds - FY2023 Proposed Revenue Budget Amendment
Proposed
Current
Amended
G/L Acct #Description Fund Budget Inc/Dec Budget
Proposed
750-80.8750.4603200 CONCESSIONS-SNACKS/CANDY GOLF COURSE FUND 2,500$ 1,500$ 4,000$
38,500$
Other Financing Sources
110-30.7800.3980305 TRANSFER FROM NORTH RES TIF DEBT SERVICE FUND 191,250$ 56,322$ 247,572$
110-30.7800.3980321 TRANSFER FROM GATEWAY TIF DEBT SERVICE FUND 1,820,226$ 151,430$ 1,971,656$
110-30.7800.3980211 TRANSFER FROM LOST DEBT SERVICE FUND -$
207,752$
16,417,792$ Total Proposed Other Funds Revenue Changes
Current
Amended
G/L Acct #Description Fund Budget Inc/Dec Budget
Road Use Tax Fund
060-30.1600.290350 PROPERTY INSURANCE ROAD USE TAX FUND 5,000$ 2,200$ 7,200$
060-30.1600.760000 OTHER CAPITAL EQUIPMENT ROAD USE TAX FUND -$
060-30.1601.230000 CONSULTANT & PROFESSIONAL FEES ROAD USE TAX FUND 10,000$ 5,000$ 15,000$
060-30.1601.290350 PROPERTY INSURANCE ROAD USE TAX FUND 6,500$ 2,700$ 9,200$
060-30.1601.480000 UTILITY SERVICES ROAD USE TAX FUND 15,000$ 8,000$ 23,000$
060-30.1601.760000 OTHER CAPITAL EQUIPMENT ROAD USE TAX FUND 180,000$ 75,000$ 255,000$
060-30.7100.100000 HEALTH & LIFE INSURANCE ROAD USE TAX FUND 180,000$ (30,000)$ 150,000$
060-30.7100.110000 WORKERS COMPENSATION ROAD USE TAX FUND 11,500$ (2,500)$ 9,000$
060-30.7100.230000 CONSULTANT & PROFESSIONAL FEES ROAD USE TAX FUND 40,000$ (116,000)$ (76,000)$
060-30.7100.410050 REPAIR/MAINT-WAUKEE MECHANIC ROAD USE TAX FUND 65,000$ 25,000$ 90,000$
060-30.7100.470000 TRAINING/TRAVEL EXPENSE ROAD USE TAX FUND 20,000$ 5,000$ 25,000$
060-30.7100.570000 FUEL ROAD USE TAX FUND 28,000$ 17,000$ 45,000$
060-30.7100.691100 PUBLIC WORKS BLDG REIMBURSE ROAD USE TAX FUND 52,500$ 10,250$ 62,750$
1,650$
TIF Fund
094-30.7850.210530 DEVELOPER REBATE-KC KETTLESTONE TIF FUND -$
-$
Debt Service Fund
110-30.7800.914628 GO 22A CIP - PRINCIPAL DEBT SERVICE FUND -$ 245,000$ 245,000$
110-30.7800.924628 GO 22A CIP - INTEREST DEBT SERVICE FUND -$ 420,046$ 420,046$
110-30.7850.918423 TIF 21B - PRINCIPAL DEBT SERVICE FUND -$
110-30.7850.928423 TIF 21B - INTEREST DEBT SERVICE FUND -$
665,046$
211-00.0000.970500 LOCAL OPTION SALES
-$
Capital Projects Fund
327-90.4100.880091 STRATFORD CROSSING PARK CAPITAL PROJECTS 750,000$ 500,000$ 1,250,000$
327-90.5020.881111 ASHWORTH TRAILHEAD CAPITAL PROJECTS -$ 300,000$ 300,000$
327-90.7100.880820 T AVENUE CORRIDOR CAPITAL PROJECTS -$ 520,000$ 520,000$
327-90.7100.880830 SE ARCHER AVE EXTENSION CAPITAL PROJECTS -$ 130,000$ 130,000$
327-90.7200.235020 10TH STREET IMPROVEMENTS CAPITAL PROJECTS -$ 750,000$ 750,000$
327-90.7200.235030 DOUGLAS PARKWAY-PHASE IIA CAPITAL PROJECTS -$ 200,000$ 200,000$
327-90.7200.235040 NW 2ND STREET-PHASE 1B CAPITAL PROJECTS -$ 1,000,000$ 1,000,000$
327-90.7740.230000 CONSULT-NE DOUGLAS EXPANSION CAPITAL PROJECTS -$ 500,000$ 500,000$
327-90.7740.235030 NW DOUGLAS PKWY BRIDGE CAPITAL PROJECTS -$ 1,700,000$ 1,700,000$
327-90.7750.230000 CONSULT-UNIV AVE EXTENSION CAPITAL PROJECTS -$ 1,000,000$ 1,000,000$
327-90.7770.235000 UTE/ASHWORTH CAPITAL PROJECTS -$ 2,500,000$ 2,500,000$
327-90.8020.235200 WARRIOR LANE IMPROVEMENTS CAPITAL PROJECTS 3,390,000$ (1,000,000)$ 2,390,000$
8,100,000$
Business Type/Enterprise Funds
510-30.6510.100000 HEALTH & LIFE INSURANCE WATER FUND 93,500$ (45,500)$ 48,000$
510-30.6510.102100 RETIREMENT HEALTH SAVINGS WATER FUND -$ 3,850$ 3,850$
510-30.6510.120000 UNIFORMS WATER FUND 2,500$ 2,500$ 5,000$
510-30.6510.280000 DUES MEMBERSHIPS & SUBSCRIPT WATER FUND 6,000$ 12,000$ 18,000$
510-30.6510.410050 REPAIR/MAINT WAUKEE MECHANIC WATER FUND 50,000$ 10,000$ 60,000$
510-30.6510.410100 REPAIR/MAINT EQUIPMENT WATER FUND 7,000$ 8,000$ 15,000$
510-30.6510.410400 REPAIR/MAINT DELIVERY SYSTEM WATER FUND 10,000$ 25,000$ 35,000$
510-30.6510.470000 TRAINING/TRAVEL EXPENSE WATER FUND 13,500$ 3,500$ 17,000$
510-30.6510.480000 UTILITY SERVICES WATER FUND 15,000$ 11,000$ 26,000$
510-30.6510.570000 FUEL WATER FUND 15,000$ 6,000$ 21,000$
510-30.6510.590000 OPERATING SUPPLIES & MATERIALS WATER FUND 10,000$ 5,000$ 15,000$
510-30.6510.592000 METER PURCHASE WATER FUND 450,000$ 130,000$ 580,000$
510-30.6510.650000 COST OF GOOD SOLD WATER FUND 2,550,000$ 750,000$ 3,300,000$
510-30.6510.650010 DSMWW OPERATING & MAINTENANCE WATER FUND 124,000$ 86,000$ 210,000$
510-30.6510.691100 PUBLIC WORKS BLDG REIMBURSE WATER FUND 52,500$ 10,250$ 62,750$
1,017,600$
520-30.6520.102100 RETIREMENT HEALTH SAVINGS WASTE WATER FUND -$ 3,850$ 3,850$
520-30.6520.410050 REPAIR/MAINT WAUKEE MECH WASTE WATER FUND 53,000$ 17,000$ 70,000$
520-30.6520.480000 UTILITY SERVICES WASTE WATER FUND 25,000$ 7,000$ 32,000$
520-30.6520.650010 WRA OPERATING & MAINTENANCE WASTE WATER FUND 542,000$ 58,000$ 600,000$
520-30.6520.691100 PUBLIC WORKS BLDG REIMBURSE WASTE WATER FUND 52,500$ 10,250$ 62,750$
520-30.6520.883095 WEST AREA TRUNK SEWER WASTE WATER FUND -$ 5,000,000$ 5,000,000$
5,096,100$
Proposed
Other Funds - FY2023 Proposed Expenditure Budget Amendment
WATER FUND TOTAL
WASTE WATER FUND TOTAL
Local Option Sales Tax Fund
Current
Amended
G/L Acct #Description Fund Budget Inc/Dec Budget
Proposed
540-30.6540.100000 HEALTH & LIFE INSURANCE GAS FUND 105,000$ (20,000)$ 85,000$
540-30.6540.230000 CONSULTANT & PROFESSIONAL FEES GAS FUND 30,000$ 135,000$ 165,000$
540-30.6540.280000 DUES MEMBERSHIPS & SUBSCRIPT GAS FUND 35,000$ 15,000$ 50,000$
540-30.6540.410050 REPAIR/MAINT-WAUKEE MECH GAS FUND 48,000$ 12,000$ 60,000$
540-30.6540.590000 OPERATING SUPPLIES & MATERIALS GAS FUND 15,000$ 13,000$ 28,000$
540-30.6540.590100 DEVELOPER MATERIALS GAS FUND 150,000$ 100,000$ 250,000$
540-30.6540.590200 INSTALLATION MATERIALS GAS FUND 75,000$ 35,000$ 110,000$
540-30.6540.592000 METER PURCHASE GAS FUND 250,000$ 475,000$ 725,000$
540-30.6540.650000 COST OF GAS SOLD GAS FUND 5,485,000$ 2,515,000$ 8,000,000$
540-30.6540.691100 PUBLIC WORKS BLDG REIMBURSE GAS FUND 52,500$ 10,250$ 62,750$
540-30.6540.880100 DISTRIBUTION SYSTEM IMPROVEMENT GAS FUND 2,515,000$ 1,200,000$ 3,715,000$
4,490,250$
560-80.5300.100000 HEALTH & LIFE INSURANCE STORM WATER FUND 38,000$ 5,000$ 43,000$
560-80.5300.410050 REPAIR/MAINT WAUKEE MECHANIC STORM WATER FUND 12,000$ (5,000)$ 7,000$
560-80.5300.290000 GENERAL LIABILITY INSURANCE STORM WATER FUND -$
560-80.5300.390000 RENTAL/LEASE OF EQUIPMENT STORM WATER FUND -$
560-80.5300.691100 PUBLIC WORKS BLDG REIMBURSE STORM WATER FUND 16,560$ 3,210$ 19,770$
3,210$
570-30.6550.100000 HEALTH & LIFE INSURANCE UTILITY BILLING FUND 40,000$ (13,000)$ 27,000$
570-30.6550.350100 PRINTING UTILITY BILLING FUND 15,000$ 7,000$ 22,000$
570-30.6550.450200 CREDIT CARD FEES UTILITY BILLING FUND 75,000$ 32,000$ 107,000$
26,000$
590-30.5400.231300 RESIDENTIAL SOLID WASTE COLLECTION SOLID WASTE FUND 1,690,000$ 91,000$ 1,781,000$
590-30.5400.240400 NDCL PLANNING FEES 28E SOLID WASTE FUND 27,500$ 2,450$ 29,950$
590-30.5400.245500 SPRING CLEANUP SOLID WASTE FUND -$ 10,000$ 10,000$
103,450$
750-80.8750.100000 HEALTH & LIFE INSURANCE GOLF COURSE FUND 35,000$ (7,000)$ 28,000$
750-80.8750.270100 COMPUTER SUPPORT GOLF COURSE FUND 1,000$ 650$ 1,650$
750-80.8750.290000 GENERAL LIABILITY INSURANCE GOLF COURSE FUND 3,000$ 650$ 3,650$
750-80.8750.290300 BUILDING & CONTENTS INSURANCE GOLF COURSE FUND 6,500$ 670$ 7,170$
750-80.8750.350100 PRINTING GOLF COURSE FUND 1,500$ 1,200$ 2,700$
750-80.8750.590000 OPERATING SUPPLIES & MATERIALS GOLF COURSE FUND 14,000$ 2,000$ 16,000$
750-80.8750.650100 COGS-BEER/ALCOHOL GOLF COURSE FUND 21,000$ 11,000$ 32,000$
750-80.8750.650150 COGS-POP/WATER GOLF COURSE FUND 11,000$ (2,000)$ 9,000$
750-80.8750.650200 COGS-SNACKS/CANDY GOLF COURSE FUND 2,000$ 1,000$ 3,000$
750-80.8750.651000 PRO SHOP MERCHANDISE GOLF COURSE FUND 19,000$ 6,000$ 25,000$
750-80.8750.760000 OTHER CAPITAL EQUIPMENT GOLF COURSE FUND 6,300$ 44,700$ 51,000$
58,870$
10,795,480$
Transfers
120-30.7850.970500 TRANSFER TO DEBT SERVICE TIF FUND 191,250$ 56,322$ 247,572$
124-30.7850.970500 TRANSFER TO DEBT SERVICE TIF FUND 1,820,226$ 151,430$ 1,971,656$
095-30.7850.970600 TRANSFER TO GENERAL FUND (LMI)TIF FUND -$
211-00.0000.970500 TRANSFER TO DEBT SERVICE LOCAL OPTION SALES -$
327-90.2200.970600 TRANSFER TO GENERAL FUND CAPITAL PROJECTS -$
207,752$
19,769,928$ Total Proposed Expenditure Changes
GAS FUND TOTAL
STORM WATER FUND TOTAL
UTILITY BILLING FUND TOTAL
GOLF COURSE FUND TOTAL
SOLID WASTE FUND TOTAL
Business Type/Enterprise Funds Total