Budget 2023

CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 1 Period: 01/23 Jun 29, 2023 10:47AM Report Criteria: Accounts to include: With balances or activity Print FUND Titles Page and Total by FUND Print SOURCE Titles Total by SOURCE Print COST CATEGORY Titles Total by COST CATEGORY All Segments Tested for Total Breaks 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget GENERAL FUND TAXES 100-41-4111-000 GENERAL PROPERTY TAXES 855,167.00 1,019,024.00 .00 100-41-4112-000 MOBILE HOME TAXES 1,200.00 1,400.00 .00 100-41-4115-000 PILOT TAX .00 3,720.70 .00 100-41-4131-000 TAX ON UTILITIES 69,381.00 69,381.00 .00 Total TAXES: 925,748.00 1,093,525.70 .00 INTERGOVERNMENTAL REVENUES 100-43-4341-000 STATE SHARED TAXES 427,136.00 422,636.00 .00 100-43-4341-100 EXPENDITURE RESTRAINT .00 30,951.00 .00 100-43-4342-000 FIRE INSURANCE TAX FROM STATE 4,000.00 4,500.00 .00 100-43-4344-000 TOWN OF FOX LAKE-DAM WAGES 4,140.00 4,114.00 .00 100-43-4352-000 STATE AID-POLICE TRAINING 480.00 600.00 .00 100-43-4353-000 STATE AID-ROAD ALLOTMENT 176,789.56 203,307.99 .00 100-43-4355-000 STATE AID-RECYCLE GRANT 8,100.00 8,100.00 .00 100-43-4356-000 STATE AID - EXEMPT COMPUTER .00 237.99 .00 100-43-4357-000 STATE AID - VIDEO SVC PROVIDER .00 4,312.99 .00 100-43-4359-000 STATE AID-OTHER GRANTS 5,492.83 942.84 .00 Total INTERGOVERNMENTAL REVENUES: 626,138.39 679,702.81 .00 LICENSES & PERMITS 100-44-4411-000 LIQUOR & MALT BEVERAGE LICENSE 2,015.00 2,015.00 .00 100-44-4412-000 OPERATORS LICENSE 855.00 800.00 .00 100-44-4413-000 CIGARETTE LICENSE 200.00 250.00 .00 100-44-4415-000 DOG & CAT LICENSES 1,000.00 1,000.00 .00 100-44-4417-000 OTHER LICENSES 150.00 100.00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 2 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget 100-44-4421-000 CABLE TV FRANCHISE FEE 19,600.00 18,500.00 .00 100-44-4431-000 BUILDING PERMITS 10,000.00 10,000.00 .00 100-44-4432-000 ELECTRICAL PERMITS 2,000.00 2,000.00 .00 100-44-4433-000 PLUMBING PERMITS 2,000.00 2,000.00 .00 Total LICENSES & PERMITS: 37,820.00 36,665.00 .00 FINES & FORFEITURES 100-45-4511-000 COURT PENALTIES & COSTS 30,000.00 25,000.00 .00 Total FINES & FORFEITURES: 30,000.00 25,000.00 .00 PUBLIC CHARGES FOR SERVICE 100-46-4612-000 PUBLICATION FEES 100.00 100.00 .00 100-46-4614-000 GENERAL GOVERNMENT 3,000.00 2,000.00 .00 100-46-4621-000 POLICE DEPARTMENT FEES 2,000.00 2,000.00 .00 100-46-4631-000 SNOW & ICE CONTROL 500.00 500.00 .00 100-46-4641-000 GARBAGE COLLECTION 95,800.00 98,300.00 .00 100-46-4642-000 WEED CONTROL 150.00 125.00 .00 100-46-4651-000 PARKS 150.00 100.00 .00 100-46-4652-000 WATER RECREATION 14,000.00 11,000.00 .00 100-46-4653-000 SWIMMING POOL 22,000.00 19,000.00 .00 100-46-4654-000 COMMUNITY CENTER-RENT 3,250.00 2,500.00 .00 100-46-4655-000 CEMETERY 5,000.00 5,000.00 .00 100-46-4656-000 SWIMMING POOL-CONCESSIONS 2,000.00 2,000.00 .00 100-46-4657-000 LIBRARY 46,034.33 51,160.00 .00 100-46-4690-000 OTHER REVENUE 4,000.00 4,000.00 .00 Total PUBLIC CHARGES FOR SERVICE: 197,984.33 197,785.00 .00 INTERDEPARTMENTAL CHARGES 100-47-4721-000 SANITATION SERVICES 800.00 1,000.00 .00 Total INTERDEPARTMENTAL CHARGES: 800.00 1,000.00 .00 MISCELLANEOUS REVENUE 100-48-4811-000 INTEREST ON TEMP . INVESTMENTS 500.00 1,500.00 .00 100-48-4821-000 RENT OF CITY OWNED LAND 300.00 12,460.00 .00 100-48-4851-000 DONATIONS 3,000.00 3,000.00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 3 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget Total MISCELLANEOUS REVENUE: 3,800.00 16,960.00 .00 OTHER FINANCING SOURCES 100-49-4900-701 TRANSFER IN FROM CEMETARY .00 20,000.00 .00 100-49-4930-000 FUNDS APPLIED 158,890.69 64,700.00 .00 Total OTHER FINANCING SOURCES: 158,890.69 84,700.00 .00 GENERAL GOVERMENT 100-51-5110-120 COUNCIL-WAGES 29,100.00 29,100.00 .00 100-51-5110-130 COUNCIL-FICA 2,226.00 2,226.00 .00 100-51-5110-320 COUNCIL-PUB/SUB/DUES 720.00 760.00 .00 100-51-5110-330 COUNCIL-TRAVEL 540.00 200.00 .00 100-51-5110-331 COUNCIL-TRAINING 300.00 220.00 .00 100-51-5110-380 COUNCIL-UNIFORM ALLOWANCE .00 500.00 .00 100-51-5110-390 COUNCIL-OTHER SUPPLIES 100.00 100.00 .00 100-51-5120-120 MUNICIPAL COURT-WAGES 13,916.00 25,772.00 .00 100-51-5120-130 MUNICIPAL COURT-FICA 1,065.00 1,972.00 .00 100-51-5120-135 MUNICIPAL COURT-WI RET FUND 686.00 1,524.00 .00 100-51-5120-140 MUNICIPAL COURT-INSURANCES .00 10,698.00 .00 100-51-5120-220 MUNICIPAL COURT-UTILITIES 200.00 .00 .00 100-51-5120-310 MUNICIPAL COURT-OFFICE SUP/EXP .00 1,200.00 .00 100-51-5120-311 MUNICIPAL COURT-COMPUTER SUPP 11,800.00 10,200.00 .00 100-51-5120-320 MUNICIPAL COURT-PUB/SUB/DUES 160.00 160.00 .00 100-51-5120-330 MUNICIPAL COURT-TRAIN/TRAVEL 700.00 700.00 .00 100-51-5120-390 MUNICIPAL COURT-OTHER SUPPLIES 1,000.00 .00 .00 100-51-5140-120 ADMINISTRATOR-WAGES 38,653.00 40,652.00 .00 100-51-5140-130 ADMINISTRATOR- FICA 2,957.00 3,110.00 .00 100-51-5140-135 ADMINISTRATOR-WIS RET FUND 2,512.00 2,764.00 .00 100-51-5140-140 ADMINISTRATOR-INSURANCES 4,597.00 4,865.00 .00 100-51-5140-210 ADMINISTRATOR-PROF SERVICES 695.00 1,000.00 .00 100-51-5140-310 ADMINISTRATOR-OFFICE SUPP/EXP 2,000.00 2,000.00 .00 100-51-5140-311 ADMINISTRATOR-COMPUTER SUP/EX 3,100.00 2,600.00 .00 100-51-5140-320 ADMINISTRATOR-PUB/SUB/DUES 66.00 200.00 .00 100-51-5140-330 ADMINISTRATOR-TRAVEL 200.00 200.00 .00 100-51-5140-340 ADMINISTRATOR-OPERATING SUPPL 100.00 .00 .00 100-51-5140-380 ADMINISTRATOR-UNIFORM ALLOWAN .00 100.00 .00 100-51-5140-390 ADMINISTRATOR-OTHER EXPENSES 200.00 300.00 .00 100-51-5141-120 MAYOR-WAGES 7,200.00 7,200.00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 4 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget 100-51-5141-130 MAYOR-FICA 551.00 551.00 .00 100-51-5141-390 MAYOR-EXPENSES 700.00 700.00 .00 100-51-5142-120 CLERK-WAGES 24,751.00 24,591.00 .00 100-51-5142-125 CLERK-VACATION PAYOUT .00 667.00 .00 100-51-5142-130 CLERK-FICA 1,893.00 1,932.00 .00 100-51-5142-135 CLERK-WI RETIREMENT FUND 1,608.00 1,717.00 .00 100-51-5142-140 CLERK-INSURANCES 1,784.00 1,809.00 .00 100-51-5142-310 CLERK-OFFICE SUPPLIES/EXPENSES 4,000.00 4,300.00 .00 100-51-5142-311 CLERK-COMPUTER SUPPORT/EXPEN 3,500.00 4,800.00 .00 100-51-5142-320 CLERK-PUB/SUB/DUES 60.00 65.00 .00 100-51-5142-330 CLERK-TRAVEL 425.00 425.00 .00 100-51-5142-331 CLERK-TRAINING 600.00 600.00 .00 100-51-5142-340 CLERK-OPERATING SUPPLIES 300.00 .00 .00 100-51-5142-380 CLERK-UNIFORM ALLOWANCE .00 100.00 .00 100-51-5144-120 ELECTIONS-WAGES 3,030.00 3,011.00 .00 100-51-5144-130 ELECTIONS-FICA 232.00 230.00 .00 100-51-5144-135 ELECTIONS-WI RETIREMENT FUND 197.00 205.00 .00 100-51-5144-140 ELECTIONS-INSURANCES 218.00 221.00 .00 100-51-5144-310 ELECTIONS-OFFICE EXPENSE 400.00 .00 .00 100-51-5144-340 ELECTIONS-OPERATING SUPP/EXP 2,800.00 3,800.00 .00 100-51-5144-390 ELECTIONS-POLL WORKERS 2,700.00 3,250.00 .00 100-51-5151-120 TREASURER-WAGES 31,357.00 32,105.00 .00 100-51-5151-130 TREASURER-FICA 2,399.00 2,456.00 .00 100-51-5151-135 TREASURER-WI RETIREMENT FUND 2,038.00 2,183.00 .00 100-51-5151-140 TREASURER-INSURANCES 13,651.00 14,027.00 .00 100-51-5151-310 TREASURER-OFFICE SUPPLIES/EXP 2,200.00 2,500.00 .00 100-51-5151-311 TREASURER-COMPUTER SUP/EXP 2,800.00 3,500.00 .00 100-51-5151-320 TREASURER-PUB/SUB/DUES 60.00 60.00 .00 100-51-5151-330 TREASURER-TRAVEL .00 200.00 .00 100-51-5151-331 TREASURER-TRAINING 1,000.00 600.00 .00 100-51-5151-340 TREASURER-OPERATING SUPPLIES 200.00 .00 .00 100-51-5151-380 TREASURER-UNIFORM ALLOWANCE .00 100.00 .00 100-51-5151-390 TREASURER-OTHER EXPENSE 100.00 .00 .00 100-51-5153-120 ASSESS OF PROPERTY-WAGES 400.00 400.00 .00 100-51-5153-130 ASSESS OF PROPERTY-FICA 30.60 30.60 .00 100-51-5153-210 ASSESS OF PROPERTY-PROF SERV 27,050.00 13,375.00 .00 100-51-5153-340 ASSESS OF PROPERTY-OPER SUPPL 50.00 50.00 .00 100-51-5153-390 ASSESS OF PROPERTY-OTHER EXP 125.00 125.00 .00 100-51-5157-210 INDEPENDENT AUDITING-PRO SERVI 30,700.00 30,700.00 .00 100-51-5161-210 ATTORNEY-PROFESSIONAL SERVICE 8,000.00 9,000.00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 5 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget 100-51-5161-290 ATTORNEY-PROSECUTION 1,000.00 2,500.00 .00 100-51-5162-220 OTHER MUNI BLDG-UTILITY SERVIC 3,500.00 3,980.00 .00 100-51-5162-350 OTHER MUNI BLDG-REP/MAIN SUPPL 585.00 585.00 .00 100-51-5162-390 OTHER MUNI BLDG-OTHER SUPP/EX 100.00 100.00 .00 100-51-5163-210 COD OF ORDIN.-PROFESSIONAL SER .00 2,200.00 .00 100-51-5171-120 MUNI BLDG-WAGES 6,117.00 3,600.00 .00 100-51-5171-130 MUNI BLDG-FICA 468.00 239.00 .00 100-51-5171-135 MUNI BLDG-WI RET FUND 66.00 70.00 .00 100-51-5171-140 MUNI BLDG-INSURANCES 404.00 400.00 .00 100-51-5171-210 MUNI BLDG-PROFESSIONAL SERVICE 1,200.00 1,000.00 .00 100-51-5171-220 MUNI BLDG-UTILITY SERVICES 13,000.00 17,220.00 .00 100-51-5171-230 MUNI BLDG-REPAIR/MAIN SERVICES 100.00 .00 .00 100-51-5171-340 MUNI BLDG-OPERATING EXPENSE 1,000.00 .00 .00 100-51-5171-350 MUNI BLDG-REP/MAIN EXPENSE 3,000.00 3,000.00 .00 100-51-5171-390 MUNI BLDG-SUPPLIES/EXPENSE 1,700.00 2,700.00 .00 100-51-5194-510 PROPERTY/LIABILITY INSURANCE 23,552.00 24,380.00 .00 100-51-5196-510 WORKER'S COMP INSURANCE 15,053.00 13,990.00 .00 Total GENERAL GOVERMENT: 367,547.60 390,672.60 .00 PUBLIC SAFTEY 100-52-5210-120 POLICE ADMIN-WAGES 92,160.00 90,782.00 .00 100-52-5210-130 POLICE ADMIN-FICA 7,050.00 6,945.00 .00 100-52-5210-135 POLICE ADMIN-WI RET FUND 5,225.00 5,034.00 .00 100-52-5210-140 POLICE ADMIN-INSURANCES 14,706.00 25,404.00 .00 100-52-5210-190 POLICE ADMIN-UNIFORM ALLOWANC 600.00 600.00 .00 100-52-5210-320 POLICE ADMIN -PUB/SUB/DUES 150.00 150.00 .00 100-52-5210-330 POLICE ADMIN-TRAIN/TRAVEL EXP .00 200.00 .00 100-52-5210-390 POLICE ADMIN-OTHER SUP/EXPENSE 100.00 100.00 .00 100-52-5211-120 POLICE PATROL-WAGES 146,713.00 114,052.00 .00 100-52-5211-130 POLICE PATROL-FICA 11,224.00 8,725.00 .00 100-52-5211-135 POLICE PATROL-WI RET FUND 15,260.00 15,055.00 .00 100-52-5211-140 POLICE PATROL-INSURANCES 25,660.00 26,215.00 .00 100-52-5211-190 POLICE PATROL-UNIFORM ALLOWAN 1,400.00 1,400.00 .00 100-52-5211-210 POLICE PATROL-PROFESSIONAL SER 500.00 500.00 .00 100-52-5211-220 POLICE PATROL-TELEPHONE 3,800.00 3,800.00 .00 100-52-5211-230 POLICE PATROL-VEHICLE LEASE 5,800.00 5,344.47 .00 100-52-5211-310 POLICE PATROL-OFFICE SUPPL/EXP 3,200.00 3,800.00 .00 100-52-5211-311 POLICE PATROL-COMPUTER SUPPO 10,800.00 12,000.00 .00 100-52-5211-330 POLICE PATROL-TRAIN/TRAVEL EXP 2,000.00 2,500.00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 6 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget 100-52-5211-340 POLICE PATROL-OPERATING SUP/EX 1,300.00 1,300.00 .00 100-52-5211-350 POLICE PATROL-REPAIR/MAIN SUPP 500.00 500.00 .00 100-52-5211-370 POLICE PATROL-VEH MAINT/REPAIR 2,000.00 4,000.00 .00 100-52-5211-371 POLICE PATROL-GAS 5,000.00 6,000.00 .00 100-52-5211-390 POLICE PATROL-OTHER SUPP/EXPEN 1,000.00 1,500.00 .00 100-52-5232-290 FIRE SUPPRESSION-HYDRANT RENT 139,389.00 139,389.00 .00 100-52-5232-390 FIRE SUPPRESSION-OTHER/MAINT/R 1,000.00 1,000.00 .00 100-52-5232-590 FIRE SUPPRESSION-FIRE CALLS 1,000.00 800.00 .00 100-52-5232-591 FIRE SUPPRESSION-F.A. BUDGET 53,737.20 53,738.00 .00 100-52-5232-592 FIRE SUPPRESSION-2% FIRE DUES 4,000.00 4,500.00 .00 100-52-5241-210 BUILDING INSPECTION-PRO SERVIC 14,000.00 14,000.00 .00 100-52-5241-310 BUILDING INSPECTION-OFFICE SUP 50.00 50.00 .00 Total PUBLIC SAFTEY: 569,324.20 549,383.47 .00 PUBLIC WORKS 100-53-5323-120 GARAGE-WAGES 33,433.00 34,870.00 .00 100-53-5323-125 GARAGE-VACATION PAYOUT .00 6,939.00 .00 100-53-5323-130 GARAGE-FICA 2,558.00 3,197.00 .00 100-53-5323-135 GARAGE-WI RETIREMENT FUND 2,061.00 2,710.00 .00 100-53-5323-140 GARAGE-INSURANCES 12,583.00 12,927.00 .00 100-53-5323-210 GARAGE-CELL PHONES 900.00 900.00 .00 100-53-5323-220 GARAGE-UTILITY SERVICES 11,500.00 13,000.00 .00 100-53-5323-320 GARAGE-LEASE PAYMENT 13,742.00 13,742.00 .00 100-53-5323-340 GARAGE-OPERATING SUPPL/EXP 8,000.00 8,000.00 .00 100-53-5323-341 GARAGE-TOOL REPLACEMENT 1,500.00 1,500.00 .00 100-53-5323-380 GARAGE-UNIFORM ALLOWANCE 380.00 1,800.00 .00 100-53-5323-390 GARAGE-OTHER EXPENSE 3,800.00 2,500.00 .00 100-53-5324-120 MACH/EQUIPMENT-WAGES 43,903.00 36,327.00 .00 100-53-5324-130 MACH/EQUIPMENT-FICA 3,358.00 2,779.00 .00 100-53-5324-135 MACH/EQUIPMENT-WI RET FUND 2,707.00 2,332.00 .00 100-53-5324-140 MACH/EQUIPMENT-INSURANCES 16,524.00 13,467.00 .00 100-53-5324-340 MACH/EQUIPMENT-OPER SUP/EXP 4,000.00 4,000.00 .00 100-53-5324-350 MACH/EQUIPMENT-REPAIR/MAINT 4,000.00 4,000.00 .00 100-53-5324-370 MACH/EQUIPMENT-VEHICLE MAINT 3,500.00 3,500.00 .00 100-53-5324-371 MACH/EQUIPMENT-GAS 2,000.00 2,000.00 .00 100-53-5324-390 MACH/EQUIPMENT-OTHER 1,000.00 1,000.00 .00 100-53-5330-120 STREETS/ALLEYS-WAGES 3,168.00 2,971.00 .00 100-53-5330-130 STREETS/ALLEYS-FICA 242.00 227.00 .00 100-53-5330-135 STREETS/ALLEYS-WI RET FUND 195.00 190.00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 7 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget 100-53-5330-140 STREETS/ALLEYS-INSURANCES 1,192.00 1,101.00 .00 100-53-5330-320 STREETS/ALLEYS-LEASE PAYMENT 10,900.00 10,900.00 .00 100-53-5330-340 STREETS/ALLEYS-OPERATING SUP/E 1,000.00 .00 .00 100-53-5330-350 STREETS/ALLEYS-REP/MAIN SUPPLI 2,000.00 1,000.00 .00 100-53-5330-370 STREETS/ALLEYS-ROADWAY SUPPLI 25,000.00 25,000.00 .00 100-53-5330-390 STREETS/ALLEYS-OTHER SUP/EXP 200.00 200.00 .00 100-53-5331-120 BRIDGES/CULVERTS-WAGES 75.00 66.00 .00 100-53-5331-130 BRIDGES/CULVERTS-FICA 6.00 5.00 .00 100-53-5331-135 BRIDGES/CULVERTS-WI RET FUND 5.00 4.00 .00 100-53-5331-140 BRIDGES/CULVERTS-INSURANCES 28.00 .00 .00 100-53-5331-340 BRIDGES/CULVERTS-OPERATING SU 500.00 .00 .00 100-53-5332-120 CURB/GUTTER-WAGES 86.00 109.00 .00 100-53-5332-130 CURB/GUTTER-FICA 7.00 8.00 .00 100-53-5332-135 CURB/GUTTER-WI RET FUND 5.00 7.00 .00 100-53-5332-140 CURB/GUTTER-INSURANCES 32.00 40.00 .00 100-53-5333-120 STREET CLEANING-WAGES 2,435.00 2,348.00 .00 100-53-5333-130 STREET CLEANING-FICA 186.00 179.00 .00 100-53-5333-135 STREET CLEANING-WI RET FUND 152.00 150.00 .00 100-53-5333-140 STREET CLEANING-INSURANCES 983.00 870.00 .00 100-53-5333-320 ST CLEANING-LEASE PAYMENT 20,900.00 20,900.00 .00 100-53-5333-350 STREET CLEANING-CONTRACTED SE .00 .00 .00 100-53-5333-370 STREET CLEANING-EQUIP REP/MAIN 500.00 1,500.00 .00 100-53-5333-371 STREET CLEANING-GAS 1,200.00 400.00 .00 100-53-5334-120 SNOW/ICE REMOVAL-WAGES 12,783.00 13,218.00 .00 100-53-5334-130 SNOW/ICE REMOVAL-FICA 977.00 1,011.00 .00 100-53-5334-135 SNOW/ICE REMOVAL-WI RET FUND 788.00 848.00 .00 100-53-5334-140 SNOW/ICE REMOVAL-INSURANCES 4,810.00 4,900.00 .00 100-53-5334-320 SNOW/ICE REMOVAL-LEASE PAYMEN 10,900.00 10,900.00 .00 100-53-5334-340 SNOW/ICE REMOVAL-OPERATING SU 4,000.00 4,000.00 .00 100-53-5334-370 SNOW/ICE REMOVAL-VEHICLE MAIN 6,000.00 6,000.00 .00 100-53-5334-371 SNOW/ICE REMOVAL-GAS 3,500.00 3,500.00 .00 100-53-5334-390 SNOW/ICE REMOVAL-MISC SUP/EXP 15,000.00 15,000.00 .00 100-53-5335-120 TRAFFIC CONTROL-WAGES 1,330.00 1,974.00 .00 100-53-5335-130 TRAFFIC CONTROL-FICA 101.00 151.00 .00 100-53-5335-135 TRAFFIC CONTROL-WI RET FUND 82.00 126.00 .00 100-53-5335-140 TRAFFIC CONTROL-INSURANCES 500.00 732.00 .00 100-53-5335-340 TRAFFIC CONTROL-OPER SUPPLIES 2,500.00 1,500.00 .00 100-53-5335-390 TRAFFIC CONTROL-SUPP/EXP 2,000.00 2,500.00 .00 100-53-5336-120 TREE/BRUSH-WAGES 8,808.00 11,124.00 .00 100-53-5336-130 TREE/BRUSH-FICA 673.00 850.00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 8 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget 100-53-5336-135 TREE/BRUSH-WI RET FUND 543.00 714.00 .00 100-53-5336-140 TREE/BRUSH-INSURANCES 3,315.00 4,123.00 .00 100-53-5336-370 TREE/BRUSH-VEHICLE MAINTENANC 500.00 500.00 .00 100-53-5336-371 TREE/BRUSH-GAS 500.00 1,800.00 .00 100-53-5336-390 TREE/BRUSH-SUPPLIES/EXPENSE 4,000.00 3,000.00 .00 100-53-5342-220 STREET LIGHTING 27,500.00 32,800.00 .00 100-53-5343-120 SDWALKS/CROSSWALKS-WAGES 29.00 110.00 .00 100-53-5343-130 SDWALKS/CROSSWALKS-FICA 2.00 8.00 .00 100-53-5343-135 SDWALKS/CROSSWALKS-WI RET FND 2.00 7.00 .00 100-53-5343-140 SDWALKS/CROSSWALKS- INSURANC 11.00 41.00 .00 100-53-5343-290 SDWALKS/CROSSWALKS-CONTRACT 1,500.00 1,500.00 .00 100-53-5344-120 STORM SEWER-WAGES 1,247.00 1,281.00 .00 100-53-5344-130 STORM SEWER-FICA 95.00 98.00 .00 100-53-5344-135 STORM SEWER-WI RET FUND 77.00 82.00 .00 100-53-5344-140 STORM SEWER-INSURANCES 470.00 474.00 .00 100-53-5344-350 STORM SEWER-REPAIR/MAIN SUPPLI 1,500.00 4,315.00 .00 100-53-5344-390 STORM SEWER-SUPPLIES/EXPENSE 500.00 500.00 .00 100-53-5345-120 PARKING LOTS-WAGES 529.00 80.00 .00 100-53-5345-130 PARKING LOTS-FICA 41.00 6.00 .00 100-53-5345-135 PARKING LOTS-WI RET FUND 32.00 5.00 .00 100-53-5345-140 PARKING LOTS-INSURANCES 200.00 30.00 .00 100-53-5345-220 PARKING LOTS-UTILITY SERVICES 420.00 729.00 .00 100-53-5362-120 GARBAGE COLLECTION-WAGES 1,335.00 1,727.00 .00 100-53-5362-130 GARBAGE COLLECTION-FICA 87.00 132.00 .00 100-53-5362-135 GARBAGE COLLECTION-WI RET FND 70.00 110.00 .00 100-53-5362-140 GARBAGE COLLECTION- INSURANCE 428.00 640.00 .00 100-53-5362-210 GARBAGE COLLECTION-PROF SERVI 71,000.00 73,700.00 .00 100-53-5362-371 GARBAGE COLLECTION-GAS 200.00 400.00 .00 100-53-5362-390 GARBAGE COLLECTION-OTHER EXP 4,500.00 1,000.00 .00 100-53-5363-120 TRANSFER STATION-WAGES 271.00 784.00 .00 100-53-5363-130 TRANSFER STATION-FICA 20.00 60.00 .00 100-53-5363-135 TRANSFER STATION-WI RET FUND 16.00 50.00 .00 100-53-5363-140 TRANSFER STATION-INSURANCES 102.00 290.00 .00 100-53-5363-220 TRANSFER STATION-UTILITY SERVI 300.00 360.00 .00 100-53-5363-290 TRANSFER STATION-CONTRACT SER 2,500.00 2,100.00 .00 100-53-5363-390 TRANSFER STATION-OTHER SUPP/EP 1,500.00 3,000.00 .00 100-53-5365-120 RECYCLING-WAGES 6,483.00 8,766.00 .00 100-53-5365-130 RECYCLING-FICA 497.00 670.00 .00 100-53-5365-135 RECYCLING-WI RET FUND 398.00 562.00 .00 100-53-5365-140 RECYCLING-INSURANCES 2,374.00 3,250.00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 9 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget 100-53-5365-210 RECYCLING-PROFESSIONAL SERVIC 25,000.00 25,950.00 .00 100-53-5365-340 RECYCLING-OPERATING SUPP/EXP 200.00 800.00 .00 100-53-5365-370 RECYCLING-VEHICLE MAINTENANCE 1,000.00 1,000.00 .00 100-53-5365-371 RECYCLING-GAS 1,000.00 2,000.00 .00 100-53-5422-290 ENGINEERING-STORM SEWERS 1,000.00 1,000.00 .00 100-53-5424-290 ENGINEERING-STREET 5,000.00 5,000.00 .00 100-53-5429-290 ENGINEERING-OTHER 2,500.00 2,500.00 .00 Total PUBLIC WORKS: 487,992.00 506,053.00 .00 HEALTH AND HUMAN SERVICES 100-54-5410-290 RETIRED PERSONS HEALTH INSURA 6,094.80 5,950.80 .00 100-54-5414-290 ANIMAL POUND-CONTRACT SERVICE 300.00 300.00 .00 100-54-5910-120 CEMETERY-WAGES 9,947.00 15,155.00 .00 100-54-5910-130 CEMETERY-FICA 761.00 1,159.00 .00 100-54-5910-135 CEMETERY-WI RETIREMENT FUND 40.00 337.00 .00 100-54-5910-140 CEMETERY-INSURANCES 251.00 1,948.00 .00 100-54-5910-210 CEMETERY-CONTRACTED SERVICES 4,000.00 20,000.00 .00 100-54-5910-220 CEMETERY-UTILITY SERVICES 400.00 360.00 .00 100-54-5910-340 CEMETERY-OPERATING SUPPLIES 1,200.00 2,000.00 .00 100-54-5910-350 CEMETERY-REPAIR/MAIN EXPENSE 1,000.00 1,000.00 .00 100-54-5910-390 CEMETERY-SUPPLIES/EXPENSE 1,000.00 1,000.00 .00 Total HEALTH AND HUMAN SERVICES: 24,993.80 49,209.80 .00 CULTURE,RECREATION & EDUCATION 100-55-5157-210 INDEPENDENT AUDITING-LIBRARY 2,500.00 2,500.00 .00 100-55-5511-120 LIBRARY-WAGES 70,206.00 81,770.00 .00 100-55-5511-130 LIBRARY-FICA 5,371.00 6,255.00 .00 100-55-5511-135 LIBRARY-WI RETIREMENT FUND 2,767.00 3,041.00 .00 100-55-5511-140 LIBRARY-INSURANCES 20,836.00 21,395.00 .00 100-55-5511-145 LIBRARY-WORKERS COMP INS 1,768.00 1,642.00 .00 100-55-5511-220 LIBRARY-UTILITY SERVICES 6,000.00 7,800.00 .00 100-55-5511-290 LIBRARY-CONTRACTUAL SERVICES 9,500.00 9,700.00 .00 100-55-5511-310 LIBRARY-OFFICE SUPPLIES 2,500.00 2,500.00 .00 100-55-5511-315 LIBRARY-ADULT & JUVENILE PROGR 4,000.00 4,000.00 .00 100-55-5511-320 LIBRARY-SUBSCRIPTIONS/MAGAZINE 1,200.00 1,300.00 .00 100-55-5511-331 LIBRARY-TRAINING 1,000.00 1,000.00 .00 100-55-5511-340 LIBRARY-OPERATING SUPP/MISC 3,000.00 3,000.00 .00 100-55-5511-350 LIBRARY-REP/MAIN BLDG & EQUIPT 3,000.00 3,000.00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 10 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget 100-55-5511-390 LIBRARY-MATERIALS 20,000.00 20,000.00 .00 100-55-5515-390 HARRIETT O'CONNELL SUP/EXPENSE 1,500.00 1,500.00 .00 100-55-5520-120 PARKS-WAGES 33,929.00 35,496.00 .00 100-55-5520-130 PARKS-FICA 2,596.00 2,715.00 .00 100-55-5520-135 PARKS-WI RETIREMENT FUND 2,093.00 2,279.00 .00 100-55-5520-140 PARKS-INSURANCES 12,770.00 13,159.00 .00 100-55-5520-220 PARKS-UTILITY SERVICES 2,100.00 1,792.00 .00 100-55-5520-340 PARKS-OPERATING SUPPLIES 3,500.00 500.00 .00 100-55-5520-350 PARKS-REPAIR/MAINT SUP/EXP 3,000.00 3,000.00 .00 100-55-5520-370 PARKS-VEHICLE MAINTENANCE 1,500.00 1,500.00 .00 100-55-5520-371 PARKS-GAS 3,000.00 3,000.00 .00 100-55-5520-390 PARKS-SUPPLIES/EXPENSE 2,000.00 1,000.00 .00 100-55-5530-120 CELEBRATIONS-WAGES 791.00 706.00 .00 100-55-5530-130 CELEBRATIONS-FICA 61.00 54.00 .00 100-55-5530-135 CELEBRATIONS-WI RET FUND 49.00 45.00 .00 100-55-5530-140 CELEBRATIONS-INSURANCES 298.00 261.00 .00 100-55-5530-340 CELEBRATIONS-OPERATING SUP/EX 400.00 5,000.00 .00 100-55-5530-390 CELEBRATIONS-OTHER EXPENSE 8,840.00 9,180.00 .00 100-55-5541-120 WATER RECREATION-WAGES 191.00 94.00 .00 100-55-5541-130 WATER RECREATION-FICA 15.00 7.00 .00 100-55-5541-135 WATER RECREATION-WI RET FUND 11.00 6.00 .00 100-55-5541-140 WATER RECREATION-INSURANCES 72.00 35.00 .00 100-55-5541-340 WATER RECREATION-OPER SUP/EXP 2,000.00 5,000.00 .00 100-55-5541-350 WATER RECREATION-REP/MAIN SUP 1,000.00 500.00 .00 100-55-5542-120 SWIMMING POOL-WAGES 3,690.00 2,350.00 .00 100-55-5542-130 SWIMMING POOL-FICA 282.00 180.00 .00 100-55-5542-135 SWIMMING POOL-WI RET FUND 239.00 159.00 .00 100-55-5542-140 SWIMMING POOL-INSURANCES 1,479.00 922.00 .00 100-55-5542-210 SWIMMING POOL-PROFESSIONAL SE 500.00 100.00 .00 100-55-5542-220 SWIMMING POOL-UTILITY SERVICES 9,800.00 12,034.00 .00 100-55-5542-290 SWIMMING POOL-CONTRACTUAL SE 35,500.00 45,000.00 .00 100-55-5542-310 SWIMMING POOL-OFFICE SUPPLIES 50.00 50.00 .00 100-55-5542-331 SWIMMING POOL-CONCESSIONS 1,500.00 1,500.00 .00 100-55-5542-340 SWIMMING POOL-OPERATING SUP/E 3,000.00 3,000.00 .00 100-55-5542-350 SWIMMING POOL-CHEMICALS 4,000.00 5,500.00 .00 100-55-5542-351 SWIMMING POOL-REP/MAINT SUP/EX 4,500.00 5,000.00 .00 100-55-5542-390 SWIMMING POOL-SUPP/EXPENSE 2,000.00 .00 .00 100-55-5543-120 OTHER SUMMER REC-WAGES 560.00 .00 .00 100-55-5543-130 OTHER SUMMER REC-FICA 42.00 .00 .00 100-55-5543-135 OTHER SUMMER REC-WI RET FUND 34.00 .00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 11 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget 100-55-5543-140 OTHER SUMMER REC-INSURANCES 215.00 .00 .00 100-55-5543-390 OTHER SUMMER REC-SUP/EXP 220.00 .00 .00 100-55-5544-120 OTHER WINTER REC-WAGES 27.00 .00 .00 100-55-5544-130 OTHER WINTER REC-FICA 2.00 .00 .00 100-55-5544-135 OTHER WINTER REC-WI RET FUND 2.00 .00 .00 100-55-5544-140 OTHER WINTER REC-INSURANCES 10.00 .00 .00 Total CULTURE,RECREATION & EDUCATION: 303,016.00 331,527.00 .00 CONSERVATION & DEVELOPMENT 100-56-5364-120 WEED CONTROL-WAGES 1,028.00 1,260.00 .00 100-56-5364-130 WEED CONTROL-FICA 79.00 96.00 .00 100-56-5364-135 WEED CONTROL-WI RET FUND 64.00 80.00 .00 100-56-5364-140 WEED CONTROL-INSURANCES 387.00 467.00 .00 100-56-5364-210 WEED CONTROL-PROFESSIONAL SE 500.00 1,000.00 .00 100-56-5364-350 WEED CONTROL-REPAIR/MAIN SUPP 100.00 500.00 .00 100-56-5364-370 WEED CONTROL-VEHICLE MAINTENA 500.00 .00 .00 100-56-5364-371 WEED CONTROL-GAS 200.00 500.00 .00 100-56-5364-390 WEED CONTROL-SUPP/EXPENSE 1,500.00 1,500.00 .00 100-56-5611-120 FORESTRY-WAGES 1,582.00 1,556.00 .00 100-56-5611-130 FORESTRY-FICA 121.00 119.00 .00 100-56-5611-135 FORESTRY-WI RET FUND 98.00 99.00 .00 100-56-5611-140 FORESTRY-INSURANCES 595.00 577.00 .00 100-56-5611-210 FORESTRY-CONTRACTED SERVICES 2,000.00 8,000.00 .00 100-56-5611-390 FORESTRY-SUPPLIES/EXPENSE 500.00 500.00 .00 100-56-5670-120 ECON DEVELOPMENT-WAGES 31.00 53.00 .00 100-56-5670-130 ECON DEVELOPMENT-FICA 3.00 4.00 .00 100-56-5670-135 ECON DEVELOPMENT-WI RET FUND 2.00 3.00 .00 100-56-5670-140 ECON DEVELOPMENT-INSURANCES 12.00 19.00 .00 100-56-5670-390 ECON DEVELOPMENT-SUP/EXPENSE 300.00 503.00 .00 100-56-5690-120 DAM-WAGES 3,625.00 3,107.00 .00 100-56-5690-130 DAM-FICA 277.00 237.00 .00 100-56-5690-135 DAM-WI RET FUND 223.00 199.00 .00 100-56-5690-140 DAM-INSURANCES 1,365.00 1,152.00 .00 100-56-5690-210 DAM-PROFESSIONAL SERVICES 500.00 500.00 .00 100-56-5690-350 DAM-REPAIR/MAINTENANCE EXPENS 200.00 1,200.00 .00 100-56-5690-390 DAM-OTHER SUPPLIES/EXPENSE 200.00 .00 .00 Total CONSERVATION & DEVELOPMENT: 15,992.00 23,231.00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 12 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget OTHER FINANCING USES 100-59-5900-301 TRANSFER OUT TO 301 148,655.81 220,561.64 .00 100-59-5900-400 TRANSFER OUT TO 400 63,660.00 .00 .00 100-59-5900-401 TRANSFERS OUT TO 401 .00 64,700.00 .00 Total OTHER FINANCING USES: 212,315.81 285,261.64 .00 GENERAL FUND Revenue Total: 1,981,181.41 2,135,338.51 .00 GENERAL FUND Expenditure Total: 1,981,181.41 2,135,338.51 .00 Net Total GENERAL FUND: .00 .00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 13 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget REVOLVING LOAN S/R FUND MISCELLANEOUS REVENUE 202-48-4810-000 INTEREST 15.00 15.00 .00 Total MISCELLANEOUS REVENUE: 15.00 15.00 .00 CAPITAL OUTLAY 202-57-5710-310 ADMINISTRATIVE EXPENSE 500.00 500.00 .00 Total CAPITAL OUTLAY: 500.00 500.00 .00 REVOLVING LOAN S/R FUND Revenue Total: 15.00 15.00 .00 REVOLVING LOAN S/R FUND Expenditure Total: 500.00 500.00 .00 Net Total REVOLVING LOAN S/R FUND: 485.00- 485.00- .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 14 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget REDEVELOPMENT AUTHORITY FUND MISCELLANEOUS REVENUE 205-48-4800-000 TRANSFER IN 88,973.20 88,963.20 .00 205-48-4850-000 MISCELLANEOUS REVENUE 16,000.00 12,300.00 .00 Total MISCELLANEOUS REVENUE: 104,973.20 101,263.20 .00 GENERAL GOVERMENT 205-51-5157-210 INDEPENDENT AUDITING 3,100.00 3,100.00 .00 Total GENERAL GOVERMENT: 3,100.00 3,100.00 .00 CAPITAL OUTLAY 205-57-5710-310 ADMINISTRATIVE EXPENSE 3,000.00 3,000.00 .00 Total CAPITAL OUTLAY: 3,000.00 3,000.00 .00 DEBT SERVICE 205-58-5813-610 RDA 1.2M 2019 - PRINCIPAL 44,943.39 46,863.35 .00 205-58-5813-620 RDA 1.2M 2019 - INTEREST 44,029.81 42,099.86 .00 Total DEBT SERVICE: 88,973.20 88,963.21 .00 REDEVELOPMENT AUTHORITY FUND Revenue Total: 104,973.20 101,263.20 .00 REDEVELOPMENT AUTHORITY FUND Expenditure Total: 95,073.20 95,063.21 .00 Net Total REDEVELOPMENT AUTHORITY FUND: 9,900.00 6,199.99 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 15 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget ARPA FUND INTERGOVERNMENTAL REVENUES 206-43-4361-000 ARPA GRANT 75,832.37 .00 .00 Total INTERGOVERNMENTAL REVENUES: 75,832.37 .00 .00 OTHER FINANCING SOURCES 206-49-4930-000 FUNDS APPLIED 35,000.00 109,043.68 .00 Total OTHER FINANCING SOURCES: 35,000.00 109,043.68 .00 GENERAL GOVERNMENT 206-51-5140-120 COVID SICK LEAVE 2,332.37 .00 .00 206-51-5140-310 ADMINISTRATIVE EXPENSE 1,250.00 1,300.00 .00 Total GENERAL GOVERNMENT: 3,582.37 1,300.00 .00 PUBLIC SAFETY 206-52-5210-000 PUBLIC HEALTH 62,250.00 .00 .00 Total PUBLIC SAFETY: 62,250.00 .00 .00 CULTURE,RECREATION & EDUCATION 206-55-5520-000 RECREATION 45,000.00 .00 .00 Total CULTURE,RECREATION & EDUCATION: 45,000.00 .00 .00 OTHER FINANCING USES 206-59-5900-401 TRANSFERS OUT TO 401 .00 107,743.68 .00 Total OTHER FINANCING USES: .00 107,743.68 .00 ARPA FUND Revenue Total: 110,832.37 109,043.68 .00 ARPA FUND Expenditure Total: 110,832.37 109,043.68 .00 Net Total ARPA FUND: .00 .00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 16 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget DEBT SERVICE FUND OTHER FINANCING SOURCES 301-49-4900-100 TRANSFER IN FROM GENERAL FUND 148,655.81 220,561.64 .00 Total OTHER FINANCING SOURCES: 148,655.81 220,561.64 .00 GENERAL GOVERMENT 301-51-5157-210 INDEPENDENT AUDITING 500.00 500.00 .00 Total GENERAL GOVERMENT: 500.00 500.00 .00 DEBT SERVICE 301-58-5811-610 STFL 2018 $557,000 PRINCIPAL 19,591.85 .00 .00 301-58-5811-620 STFL 2018 $557,000 INTEREST 20,021.71 .00 .00 301-58-5820-610 $527,000 PRINC CITY SHARE 52% 6,307.17 6,594.19 .00 301-58-5820-620 $527,000 INT CITY SHARE 52% 8,529.47 8,242.45 .00 301-58-5827-610 STFL 2020 $150,000 PRINCIPLE 15,234.94 .00 .00 301-58-5827-620 STFL 2020 $150,000 INTEREST 4,441.70 .00 .00 301-58-5828-610 STFL 2021 $560,000 PRIN 68.68% 14,058.10 .00 .00 301-58-5828-620 STFL 2021 $560,000 INT 68.68% 14,162.00 .00 .00 301-58-5829-610 STFL 2021 $127,225 PRINCIPLE 24,404.87 .00 .00 301-58-5829-620 STFL 2021 $127,225 INTEREST 2,927.92 .00 .00 301-58-5830-610 STFL 2021 $86,000 PRINCIPLE 16,496.90 .00 .00 301-58-5830-620 STFL 2021 $86,000 INTEREST 1,979.18 .00 .00 301-58-5831-610 2022 REFINANCE BOND $435 - PRI .00 25,000.00 .00 301-58-5831-620 2022 REFINANCE BOND $435 - INT .00 17,170.00 .00 301-58-5832-610 2022 REFINANCE BOND $125 - PRI .00 15,000.00 .00 301-58-5832-620 2022 REFINANCE BOND $125 - INT .00 4,816.67 .00 301-58-5833-610 2022 REFINANCE BOND $380 - PRI .00 10,000.00 .00 301-58-5833-620 2022 REFINANCE BOND $380 - INT .00 15,176.67 .00 301-58-5834-610 2022 REFINANCE BOND $105 - PRI .00 25,000.00 .00 301-58-5834-620 2022 REFINANCE BOND $105 - INT .00 3,860.00 .00 301-58-5835-610 2022 REFINANCE BOND $70 - PRI .00 10,000.00 .00 301-58-5835-620 2022 REFINANCE BOND $70 - INT .00 2,673.33 .00 301-58-5836-610 2022 REFINANCE BOND $310 - PRI .00 65,000.00 .00 301-58-5836-620 2022 REFINANCE BOND $310 - INT .00 11,528.33 .00 Total DEBT SERVICE: 148,155.81 220,061.64 .00 DEBT SERVICE FUND Revenue Total: 148,655.81 220,561.64 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 17 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget DEBT SERVICE FUND Expenditure Total: 148,655.81 220,561.64 .00 Net Total DEBT SERVICE FUND: .00 .00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 18 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget CAPITAL IMPROVEMENTS FUND OTHER FINANCING SOURCES 400-49-4900-100 FUNDS APPLIED .00 57,421.00 .00 400-49-4900-101 LOAN PROCEEDS 305,000.00 .00 .00 400-49-4900-204 TRANSFER IN FROM GENERAL FUND 63,660.00 .00 .00 Total OTHER FINANCING SOURCES: 368,660.00 57,421.00 .00 GENERAL GOVERMENT 400-51-5162-810 OTHER MUNI BLDG-CAPITAL EQUIPM 9,824.00 .00 .00 400-51-5162-820 OTHER MUNI BLDG-CAPITAL IMPROV .00 11,200.00 .00 400-51-5171-820 MUNI BLDG-CAPITAL IMPROVEMENT .00 3,100.00 .00 Total GENERAL GOVERMENT: 9,824.00 14,300.00 .00 PUBLIC SAFTEY 400-52-5211-810 POLICE PATROL-CAPITAL EQUIPMT 5,600.00 5,500.00 .00 400-52-5232-810 FIRE SUPPRESSION-CAPITAL EQUIP 8,652.00 .00 .00 Total PUBLIC SAFTEY: 14,252.00 5,500.00 .00 PUBLIC WORKS 400-53-5324-810 MACH/EQUIP-CAPITAL EQUIPMENT 24,111.00 6,600.00 .00 400-53-5330-820 STREETS/ALLEYS-CAPITAL IMPROV 285,350.00 .00 .00 400-53-5334-810 SNOW/ICE REMOVAL-CAPITAL EQUIP .00 10,000.00 .00 Total PUBLIC WORKS: 309,461.00 16,600.00 .00 CULTURE,RECREATION & EDUCATION 400-55-5511-810 LIBRARY-CAPITAL EQUIPMENT 4,000.00 .00 .00 400-55-5511-820 LIBRARY-CAPITAL IMPROVEMENT 1,500.00 10,200.00 .00 400-55-5520-810 PARKS-CAPITAL EQUIPMENT 6,000.00 .00 .00 400-55-5520-820 PARKS-CAPITAL IMPROVEMENT .00 4,800.00 .00 400-55-5542-810 SWIMMING POOL-CAPITAL EQUIPME 21,323.00 .00 .00 400-55-5542-820 SWIMMING POOL-CAPITAL IMPROVE 2,300.00 6,021.00 .00 Total CULTURE,RECREATION & EDUCATION: 35,123.00 21,021.00 .00 CAPITAL IMPROVEMENTS FUND Revenue Total: 368,660.00 57,421.00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 19 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget CAPITAL IMPROVEMENTS FUND Expenditure Total: 368,660.00 57,421.00 .00 Net Total CAPITAL IMPROVEMENTS FUND: .00 .00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 20 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget TIF #2 CAPITAL PROJECTS FUND TIF #2 INCREMENT 401-41-4112-000 TIF #2 INCREMENT 198,167.00 275,345.00 .00 Total TIF #2 INCREMENT: 198,167.00 275,345.00 .00 INTERGOVERNMENTAL REVENUES 401-42-4250-000 STATE AID-EXEMPT COMPUTERS "T" 2,382.39 2,382.39 .00 401-42-4259-000 STATE AID-OTHER GRANTS 2,692.18 2,692.18 .00 Total INTERGOVERNMENTAL REVENUES: 5,074.57 5,074.57 .00 MISCELLANEOUS REVENUE 401-48-4851-702 GRANTS-DEPT NATURAL RESOURCE .00 314,166.00 .00 Total MISCELLANEOUS REVENUE: .00 314,166.00 .00 OTHER FINANCING SOURCES 401-49-4910-000 LOAN PROCEEDS .00 423,642.00 .00 401-49-4920-100 TRANSFERS IN FROM GENERAL FUN .00 64,700.00 .00 401-49-4920-206 TRANSFERS IN FROM ARPA .00 107,743.68 .00 Total OTHER FINANCING SOURCES: .00 596,085.68 .00 GENERAL GOVERMENT 401-51-5140-120 ADMIN/OFFICE-WAGES 15,408.00 16,065.00 .00 401-51-5140-130 ADMIN/OFFICE-FICA 1,179.00 1,229.00 .00 401-51-5140-135 ADMIN/OFFICE-WIS RET FUND 1,002.00 1,092.00 .00 401-51-5140-140 ADMIN/OFFICE-INSURANCES 2,537.00 2,648.00 .00 401-51-5140-310 ADMINISTRATIVE EXPENSE 10,000.00 1,000.00 .00 401-51-5157-210 INDEPENDENT AUDITING 2,000.00 2,000.00 .00 Total GENERAL GOVERMENT: 32,126.00 24,034.00 .00 PUBLIC WORKS 401-53-5330-800 ROAD IMPROVEMENTS .00 258,370.00 .00 401-53-5330-900 PARKING LOT IMPROVEMENT .00 23,500.00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 21 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget Total PUBLIC WORKS: .00 281,870.00 .00 CAPITAL OUTLAY 401-57-5700-794 CLAUSEN PARK IMPROVEMENTS .00 628,332.00 .00 401-57-5710-820 TIF #2 EXPENDITURES .00 10,000.00 .00 Total CAPITAL OUTLAY: .00 638,332.00 .00 DEBT SERVICE 401-58-5810-610 STFL $390,000 PRINCIPAL 16,213.11 .00 .00 401-58-5820-620 STFL $390,000 INTEREST 16,569.84 .00 .00 401-58-5821-610 2022 REFINANCE BOND $360 - PRI .00 10,000.00 .00 401-58-5821-620 2022 REFINANCE BOND $360 - INT .00 14,370.00 .00 401-58-5830-610 STFL $800,000 PRI TIF#2 SHARE 23,505.41 .00 .00 401-58-5830-620 STFL $800,000 INT TIF#2 SHARE 23,505.41 .00 .00 401-58-5831-610 2022 REFINANCE BOND $580 - PRI .00 25,000.00 .00 401-58-5831-620 2022 REFINANCE BOND $580 - INT .00 23,018.33 .00 Total DEBT SERVICE: 79,793.77 72,388.33 .00 TIF #2 CAPITAL PROJECTS FUND Revenue Total: 203,241.57 1,190,671.25 .00 TIF #2 CAPITAL PROJECTS FUND Expenditure Total: 111,919.77 1,016,624.33 .00 Net Total TIF #2 CAPITAL PROJECTS FUND: 91,321.80 174,046.92 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 22 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget TIF #3 FUND TAXES 402-41-4112-000 TIF #3 INCREMENT 102,733.00 119,178.00 .00 Total TAXES: 102,733.00 119,178.00 .00 MISCELLANEOUS REVENUE 402-48-4810-000 INTEREST 15.00 15.00 .00 Total MISCELLANEOUS REVENUE: 15.00 15.00 .00 GENERAL GOVERMENT 402-51-5140-120 ADMIN/OFFICE-WAGES 15,408.00 16,065.00 .00 402-51-5140-130 ADMIN/OFFICE-FICA 1,179.00 1,229.00 .00 402-51-5140-135 ADMIN/OFFICE-WIS RET FUND 1,002.00 1,092.00 .00 402-51-5140-140 ADMIN/OFFICE-INSURANCES 2,537.00 2,648.00 .00 402-51-5140-310 ADMINISTRATIVE EXPENSE 50,000.00 5,000.00 .00 402-51-5157-210 INDEPENDENT AUDITING 2,000.00 2,000.00 .00 Total GENERAL GOVERMENT: 72,126.00 28,034.00 .00 TIF #3 CAPITAL PROJECTS 402-57-5700-793 DOLLAR GENERAL INCENTIVE 2,225.04 .00 .00 402-57-5700-794 VALIDO HOMES INCENTIVE 100,000.00 60,000.00 .00 402-57-5710-310 ADMINISTRATIVE EXPENSE .00 1,000.00 .00 Total TIF #3 CAPITAL PROJECTS: 102,225.04 61,000.00 .00 DEBT SERVICE 402-58-5830-610 STFL $800,000 PRI TIF#3 SHARE 7,576.13 .00 .00 402-58-5830-620 STFL $800,000 INT TIF#3 SHARE 7,118.32 .00 .00 402-58-5831-610 2022 REFINANCE BOND $180 - PRI .00 10,000.00 .00 402-58-5831-620 2022 REFINANCE BOND $180 - INT .00 7,110.00 .00 402-58-5832-610 ERGO BANK PRINCIPAL 1.5M .00 50,027.98 .00 402-58-5832-620 ERGO BANK INTEREST 1.5M .00 63,408.66 .00 Total DEBT SERVICE: 14,694.45 130,546.64 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 23 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget OTHER FINANCING USES 402-59-5900-205 TRANSFER OUT TO 205 88,973.20 88,963.20 .00 Total OTHER FINANCING USES: 88,973.20 88,963.20 .00 TIF #3 FUND Revenue Total: 102,748.00 119,193.00 .00 TIF #3 FUND Expenditure Total: 278,018.69 308,543.84 .00 Net Total TIF #3 FUND: 175,270.69- 189,350.84- .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 24 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget WATER DEPARTMENT FUND WATER SALES REVENUE 610-41-4190-000 INTEREST AND FISCAL CHARGES 65.00 250.00 .00 610-41-4610-000 RESIDENTIAL REVENUE 181,000.00 181,000.00 .00 610-41-4612-000 COMMERCIAL REVENUE 25,700.00 25,700.00 .00 610-41-4612-100 MULTI FAMILY REVENUE 14,600.00 16,000.00 .00 610-41-4613-000 INDUSTRIAL REVENUE 48,500.00 31,000.00 .00 610-41-4614-000 REVENUE-PUBLIC AUTHORITIES 7,495.00 8,900.00 .00 610-41-4620-000 PRIVATE FIRE PROTECTION 5,600.00 5,600.00 .00 610-41-4630-000 PUBLIC FIRE PROTECTION 139,389.00 139,500.00 .00 610-41-4700-000 FORFEITED DISCOUNTS 500.00 500.00 .00 610-41-4740-000 OTHER WATER REVENUE 100.00 100.00 .00 Total WATER SALES REVENUE: 422,949.00 408,550.00 .00 PUBLIC WORKS 610-53-0403-000 DEPRECIATION EXPENSE 77,500.00 83,000.00 .00 610-53-0403-001 DEPRECIATION EXPENSE-CIAC 27,000.00 28,000.00 .00 610-53-0408-000 WATER DEPARTMENT-FICA 6,093.00 6,630.00 .00 610-53-0408-100 WATER DEPARTMENT-TAX EQUIVALE 76,500.00 76,500.00 .00 610-53-0427-000 INTEREST ON LONG TERM DEBT 10,702.24 9,206.66 .00 610-53-0600-000 WATER DEPARTMENT-WAGES 60,068.00 66,821.00 .00 610-53-0600-125 WATER DEPARTMENT-VAC PAYOUT .00 551.00 .00 610-53-0620-000 PURCHASED POWER 9,500.00 12,182.00 .00 610-53-0630-000 CHEMICALS 10,000.00 10,000.00 .00 610-53-0640-000 OPERATING SUPPLIES & EXPENSE 12,500.00 10,000.00 .00 610-53-0640-220 UTILITY SERVICES 1,000.00 40,000.00 .00 610-53-0650-000 REPAIR TO WATER PLANT 26,000.00 26,000.00 .00 610-53-0660-000 TRANSPORTATION EXPENSE 5,800.00 3,000.00 .00 610-53-0670-000 WATER DEPARTMENT-CAPITAL EQUIP 6,000.00 10,000.00 .00 610-53-0670-100 WATER DEPTARTMENT-CAPITAL IMPR 36,000.00 12,600.00 .00 610-53-0680-000 WATER DEPARTMENT-ADMIN SALARY 19,580.00 19,841.00 .00 610-53-0681-000 OFFICE SUPPLIES & EXPENSE 3,500.00 3,500.00 .00 610-53-0682-000 OUTSIDE PROFESSIONAL SERVICES 12,000.00 7,000.00 .00 610-53-0682-100 WATER DEPARTMENT-COMPUTER SU 5,000.00 5,600.00 .00 610-53-0682-200 INDEPENDENT AUDITING 8,000.00 10,000.00 .00 610-53-0683-000 CELL PHONE & ALARM CHARGES 950.00 550.00 .00 610-53-0684-000 INSURANCE EXPENSE 12,483.00 12,922.00 .00 610-53-0686-000 EMP PENSION/HEALTH/LIFE WATER 30,927.00 32,991.00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 25 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget 610-53-0686-100 WORKERS COMPENSATION INSURAN 1,526.00 1,417.00 .00 610-53-0686-200 WATER DEPT EDUCATION-TRAINING 800.00 800.00 .00 610-53-0688-000 REGULATORY COMMISSION EXPENS 125.00 540.00 .00 610-53-0689-000 MISCELLANEOUS GENERAL EXPENS 390.00 410.00 .00 610-53-0689-100 WATER DEPARTMENT-UNIFORM ALL 350.00 500.00 .00 Total PUBLIC WORKS: 460,294.24 490,561.66 .00 DEBT SERVICE 610-58-5917-610 PRINCIPAL DEBT SERVICE 30,670.85 .00 .00 Total DEBT SERVICE: 30,670.85 .00 .00 WATER DEPARTMENT FUND Revenue Total: 422,949.00 408,550.00 .00 WATER DEPARTMENT FUND Expenditure Total: 490,965.09 490,561.66 .00 Net Total WATER DEPARTMENT FUND: 68,016.09- 82,011.66- .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 26 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget SEWER DEPARTMENT FUND SEWER SALES REVENUE 620-41-4190-000 INTEREST AND FISCAL CHARGES 36.00 350.00 .00 620-41-4210-000 RESIDENTIAL REVENUE 380,000.00 403,000.00 .00 620-41-4220-000 COMMERCIAL REVENUE 92,200.00 96,000.00 .00 620-41-4230-000 INDUSTRIAL REVENUE 212,700.00 121,000.00 .00 620-41-4240-000 PUBLIC AUTHORITY REVENUE 9,500.00 9,106.00 .00 620-41-6320-000 PENALTIES 1,500.00 1,500.00 .00 620-41-6340-000 MISC. OPERATING REVENUES 9,500.00 9,500.00 .00 Total SEWER SALES REVENUE: 705,436.00 640,456.00 .00 PUBLIC WORKS 620-53-0082-000 SEWER DEPARTMENT-WAGES 65,866.00 73,317.00 .00 620-53-0082-125 SEWER DEPARTMENT-VAC PAYOUT .00 551.00 .00 620-53-0403-000 DEPRECIATION OF EXPENSE 160,000.00 165,000.00 .00 620-53-0408-000 SEWER DEPARTMENT-FICA 6,537.00 7,127.00 .00 620-53-0427-000 INTEREST ON LONG TERM DEBT 38,076.57 37,589.07 .00 620-53-0620-000 POWER PURCHASED FOR PUMPING 16,300.00 19,025.00 .00 620-53-0826-000 CELL PHONE & ALARM CHARGES 1,000.00 1,000.00 .00 620-53-0827-000 OPERATING SUPPLIES & EXPENSE 1,400.00 7,000.00 .00 620-53-0827-220 UTILITY SERVICES 2,500.00 1,200.00 .00 620-53-0828-000 TRANSPORTATION EXPENSE 3,500.00 3,500.00 .00 620-53-0829-000 SEWER DEPARTMENT-CAPITAL EQUI .00 10,000.00 .00 620-53-0829-100 SEWER DEPARTMENT-CAPITAL IMPR 15,000.00 23,500.00 .00 620-53-0831-000 MAINT OF SEWERAGE COLL SYSTEM 6,000.00 6,000.00 .00 620-53-0832-000 MAINT OF PUMP STATION EQUIP 8,000.00 23,000.00 .00 620-53-0833-000 MAINT OF CHALET GRINDER PUMP 1,000.00 1,000.00 .00 620-53-0834-000 MAINT/REPAIR BLDGS & GROUNDS 3,800.00 3,800.00 .00 620-53-0850-000 SEWER DEPARTMENT-ADMIN SALARI 19,580.00 19,841.00 .00 620-53-0851-000 GEN OFFICE SUPPLIES & EXPENSE 3,500.00 3,500.00 .00 620-53-0851-100 FLWCC BUDGET EXPENSE 120,000.00 165,000.00 .00 620-53-0851-102 FLWCC COPPER SURCHARGE 1,000.00 2,000.00 .00 620-53-0851-103 FLWCC SLUDGE REMOVAL/LINER 56,250.00 19,500.00 .00 620-53-0852-000 OUTSIDE PROFESSIONAL SERVICES 5,000.00 2,500.00 .00 620-53-0852-100 SEWER DEPARTMENT-COMPUTER S 5,500.00 5,600.00 .00 620-53-0852-200 INDEPENDENT AUDITING 9,000.00 9,000.00 .00 620-53-0853-000 INSURANCE EXPENSE 6,439.00 6,665.00 .00 620-53-0854-000 EMP PENSION/BENEFIT/HEALTH/LIF 31,620.00 33,858.00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 27 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget 620-53-0854-100 WORKERS COMPENSATION INSURAN 1,526.00 1,417.00 .00 620-53-0856-100 SEWER DEPARTMENT-UNIFORM ALL 350.00 500.00 .00 Total PUBLIC WORKS: 588,744.57 651,990.07 .00 DEBT SERVICE 620-58-5917-610 PRINCIPAL DEBT SERVICE 42,979.96 38,618.29 .00 Total DEBT SERVICE: 42,979.96 38,618.29 .00 SEWER DEPARTMENT FUND Revenue Total: 705,436.00 640,456.00 .00 SEWER DEPARTMENT FUND Expenditure Total: 631,724.53 690,608.36 .00 Net Total SEWER DEPARTMENT FUND: 73,711.47 50,152.36- .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 28 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget CEMETERY NONEXP TRUST FUND MISCELLANEOUS REVENUE 701-48-4810-000 INTEREST 750.00 1,000.00 .00 Total MISCELLANEOUS REVENUE: 750.00 1,000.00 .00 DEBT SERVICE 701-58-5800-000 TRANSFER OUT .00 20,000.00 .00 Total DEBT SERVICE: .00 20,000.00 .00 CEMETERY NONEXP TRUST FUND Revenue Total: 750.00 1,000.00 .00 CEMETERY NONEXP TRUST FUND Expenditure Total: .00 20,000.00 .00 Net Total CEMETERY NONEXP TRUST FUND: 750.00 19,000.00- .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 29 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget ROBERTS EXP TRUST FUND MISCELLANEOUS REVENUE 802-48-4810-000 INTEREST 75.00 35.00 .00 Total MISCELLANEOUS REVENUE: 75.00 35.00 .00 OTHER FINANCING USES 802-59-5900-390 MISCELLANEOUS EXPENSE 250.00 250.00 .00 Total OTHER FINANCING USES: 250.00 250.00 .00 ROBERTS EXP TRUST FUND Revenue Total: 75.00 35.00 .00 ROBERTS EXP TRUST FUND Expenditure Total: 250.00 250.00 .00 Net Total ROBERTS EXP TRUST FUND: 175.00- 215.00- .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 30 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget LIBRARY S/R FUND INTERGOVERNMENTAL REVENUES 804-43-4374-000 HICKS GRANT 5,000.00 5,000.00 .00 Total INTERGOVERNMENTAL REVENUES: 5,000.00 5,000.00 .00 MISCELLANEOUS REVENUE 804-48-4810-000 INTEREST 15,000.00 15,000.00 .00 804-48-4850-000 DONATIONS 2,000.00 1,000.00 .00 804-48-4890-000 LIBRARY MISCELLANEOUS REVENUE 500.00 500.00 .00 Total MISCELLANEOUS REVENUE: 17,500.00 16,500.00 .00 CULTURE,RECREATION & EDUCATION 804-55-5500-000 LIBRARY EXPENDITURES 5,000.00 5,000.00 .00 Total CULTURE,RECREATION & EDUCATION: 5,000.00 5,000.00 .00 LIBRARY S/R FUND Revenue Total: 22,500.00 21,500.00 .00 LIBRARY S/R FUND Expenditure Total: 5,000.00 5,000.00 .00 Net Total LIBRARY S/R FUND: 17,500.00 16,500.00 .00 Total Asset: .00 .00 .00 Total Liability: .00 .00 .00 Total Equity: .00 .00 .00 Total Revenue: 4,172,017.36 5,005,048.28 .00 Total Expenditure: 4,222,780.87 5,149,516.23 .00 Net Grand Totals: 50,763.51- 144,467.95- .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 31 Period: 01/23 Jun 29, 2023 10:47AM 2022-22 2023-23 2024-24 Prior Year Approved Proposed Account Number Account Title Budget Budget Budget Report Criteria: Accounts to include: With balances or activity Print FUND Titles Page and Total by FUND Print SOURCE Titles Total by SOURCE Print COST CATEGORY Titles Total by COST CATEGORY All Segments Tested for Total Breaks