2024 Budget

CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 1 Period: 01/24 Dec 21, 2023 03:12PM 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 All Segments Tested for Total Breaks 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget GENERAL FUND TAXES 100-41-4111-000 GENERAL PROPERTY TAXES 855,167.00 855,167.00 1,019,024.00 .00 1,034,449.00 100-41-4112-000 MOBILE HOME TAXES 1,200.00 2,005.08 1,400.00 1,119.50 1,400.00 100-41-4115-000 PILOT TAX .00 3,720.70 3,720.70 3,040.65 930.00 100-41-4131-000 TAX ON UTILITIES 69,381.00 69,650.04 69,381.00 69,681.37 69,381.00 Total TAXES: 925,748.00 930,542.82 1,093,525.70 73,841.52 1,106,160.00 INTERGOVERNMENTAL REVENUES 100-43-4341-000 STATE SHARED TAXES 427,136.00 422,754.94 422,636.00 423,748.21 512,542.00 100-43-4341-100 EXPENDITURE RESTRAINT .00 .00 30,951.00 30,951.20 40,610.00 100-43-4342-000 FIRE INSURANCE TAX FROM STATE 4,000.00 4,670.36 4,500.00 5,584.73 4,500.00 100-43-4344-000 TOWN OF FOX LAKE-DAM WAGES 4,140.00 4,140.00 4,114.00 3,485.63 4,114.00 100-43-4352-000 STATE AID-POLICE TRAINING 480.00 480.00 600.00 .00 480.00 100-43-4353-000 STATE AID-ROAD ALLOTMENT 176,789.56 176,789.56 203,307.99 203,307.99 233,804.00 100-43-4355-000 STATE AID-RECYCLE GRANT 8,100.00 8,139.06 8,100.00 8,135.54 8,100.00 100-43-4356-000 STATE AID - EXEMPT COMPUTER .00 237.99 237.99 237.99 238.00 100-43-4357-000 STATE AID - VIDEO SVC PROVIDER .00 4,312.99 4,312.99 4,312.99 4,313.00 100-43-4359-000 STATE AID-OTHER GRANTS 5,492.83 942.84 942.84 4,641.89- .00 100-43-4362-000 DODGE COUNTY - OTHER .00 636.61 .00 .00 .00 Total INTERGOVERNMENTAL REVENUES: 626,138.39 623,104.35 679,702.81 675,122.39 808,701.00 LICENSES & PERMITS 100-44-4411-000 LIQUOR & MALT BEVERAGE LICENSE 2,015.00 2,343.11 2,015.00 1,995.00 2,015.00 100-44-4412-000 OPERATORS LICENSE 855.00 910.00 800.00 1,125.00 800.00 100-44-4413-000 CIGARETTE LICENSE 200.00 50.00 250.00 250.00 250.00 100-44-4415-000 DOG & CAT LICENSES 1,000.00 1,143.98 1,000.00 1,019.38 1,000.00 100-44-4417-000 OTHER LICENSES 150.00 110.00 100.00 85.00 100.00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 2 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-44-4421-000 CABLE TV FRANCHISE FEE 19,600.00 18,306.43 18,500.00 18,477.48 18,500.00 100-44-4431-000 BUILDING PERMITS 10,000.00 17,751.83 10,000.00 15,716.72 15,000.00 100-44-4432-000 ELECTRICAL PERMITS 2,000.00 4,146.80 2,000.00 2,748.32 2,000.00 100-44-4433-000 PLUMBING PERMITS 2,000.00 7,934.36 2,000.00 3,950.64 2,000.00 Total LICENSES & PERMITS: 37,820.00 52,696.51 36,665.00 45,367.54 41,665.00 FINES & FORFEITURES 100-45-4511-000 COURT PENALTIES & COSTS 30,000.00 20,515.74 25,000.00 21,498.47 25,000.00 Total FINES & FORFEITURES: 30,000.00 20,515.74 25,000.00 21,498.47 25,000.00 PUBLIC CHARGES FOR SERVICE 100-46-4612-000 PUBLICATION FEES 100.00 87.10 100.00 10.56- 100.00 100-46-4614-000 GENERAL GOVERNMENT 3,000.00 2,135.00 2,000.00 1,933.43 2,000.00 100-46-4621-000 POLICE DEPARTMENT FEES 2,000.00 2,149.00 2,000.00 1,514.50 2,000.00 100-46-4631-000 SNOW & ICE CONTROL 500.00 .00 500.00 300.00 500.00 100-46-4641-000 GARBAGE COLLECTION 95,800.00 97,529.12 98,300.00 93,098.40 127,400.00 100-46-4642-000 WEED CONTROL 150.00 118.65 125.00 .00 125.00 100-46-4650-000 SWIMMING POOL SPONSORSHIP .00 .00 .00 12,425.00 .00 100-46-4651-000 PARKS 150.00 110.00 100.00 210.00 100.00 100-46-4652-000 WATER RECREATION 14,000.00 10,768.48 11,000.00 10,835.36 10,000.00 100-46-4653-000 SWIMMING POOL 22,000.00 19,064.64 19,000.00 5,691.96 25,000.00 100-46-4654-000 COMMUNITY CENTER-RENT 3,250.00 3,300.00 2,500.00 8,123.01 4,500.00 100-46-4655-000 CEMETERY 5,000.00 9,810.00 5,000.00 10,030.00 6,000.00 100-46-4656-000 SWIMMING POOL-CONCESSIONS 2,000.00 2,265.95 2,000.00 5,771.26 5,000.00 100-46-4657-000 LIBRARY 46,034.33 48,012.90 51,160.00 51,161.45 60,130.00 100-46-4690-000 OTHER REVENUE 4,000.00 16,238.07 4,000.00 16,159.69- 4,000.00 Total PUBLIC CHARGES FOR SERVICE: 197,984.33 211,588.91 197,785.00 184,924.12 246,855.00 INTERDEPARTMENTAL CHARGES 100-47-4721-000 SANITATION SERVICES 800.00 1,189.00 1,000.00 2,099.00 1,000.00 Total INTERDEPARTMENTAL CHARGES: 800.00 1,189.00 1,000.00 2,099.00 1,000.00 MISCELLANEOUS REVENUE 100-48-4811-000 INTEREST ON TEMP . INVESTMENTS 500.00 4,780.91 1,500.00 22,957.53 1,500.00 100-48-4815-000 INTEREST ON TIF ADVANCE #2 .00 15,523.00 .00 .00 .00 100-48-4821-000 RENT OF CITY OWNED LAND 300.00 12,460.00 12,460.00 12,460.00 19,800.00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 3 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-48-4841-000 FINANCED PURCHASE .00 433,187.00 .00 .00 .00 100-48-4851-000 DONATIONS 3,000.00 22,917.55 3,000.00 22,875.00 13,907.00 100-48-4891-000 FIRE ASSOC SERVICE AWARD PROG .00 .00 .00 .00 .00 Total MISCELLANEOUS REVENUE: 3,800.00 488,868.46 16,960.00 58,292.53 35,207.00 OTHER FINANCING SOURCES 100-49-4900-206 TRANSFER IN FROM ARPA FUND .00 8,784.00 .00 .00 .00 100-49-4900-701 TRANSFER IN FROM CEMETARY .00 .00 20,000.00 20,000.00 .00 100-49-4910-150 BOND PROCEEDS .00 .00 .00 .00 .00 100-49-4930-000 FUNDS APPLIED 158,890.69 .00 64,700.00 .00 .00 Total OTHER FINANCING SOURCES: 158,890.69 8,784.00 84,700.00 20,000.00 .00 GENERAL GOVERMENT 100-51-5110-120 COUNCIL-WAGES 29,100.00 29,233.30 29,100.00 27,887.00 29,100.00 100-51-5110-130 COUNCIL-FICA 2,226.00 2,234.84 2,226.00 2,226.12 2,226.00 100-51-5110-320 COUNCIL-PUB/SUB/DUES 720.00 720.07 760.00 759.12 800.00 100-51-5110-330 COUNCIL-TRAVEL 540.00 .00 200.00 .00 200.00 100-51-5110-331 COUNCIL-TRAINING 300.00 .00 220.00 .00 220.00 100-51-5110-380 COUNCIL-UNIFORM ALLOWANCE .00 183.53 500.00 424.00 500.00 100-51-5110-390 COUNCIL-OTHER SUPPLIES 100.00 37.00 100.00 863.84 100.00 100-51-5120-120 MUNICIPAL COURT-WAGES 13,916.00 11,243.65 25,772.00 23,748.54 26,594.00 100-51-5120-130 MUNICIPAL COURT-FICA 1,065.00 859.31 1,972.00 1,826.95 2,034.00 100-51-5120-135 MUNICIPAL COURT-WI RET FUND 686.00 511.74 1,524.00 1,395.42 1,603.00 100-51-5120-140 MUNICIPAL COURT-INSURANCES .00 310.96 10,698.00 10,334.19 12,527.00 100-51-5120-220 MUNICIPAL COURT-UTILITIES 200.00 168.17 .00 14.69 .00 100-51-5120-310 MUNICIPAL COURT-OFFICE SUP/EXP .00 .00 1,200.00 957.38 1,200.00 100-51-5120-311 MUNICIPAL COURT-COMPUTER SUPP 11,800.00 9,640.25 10,200.00 8,253.27 10,500.00 100-51-5120-320 MUNICIPAL COURT-PUB/SUB/DUES 160.00 145.00 160.00 45.00 160.00 100-51-5120-330 MUNICIPAL COURT-TRAIN/TRAVEL 700.00 618.99 700.00 1,277.98 700.00 100-51-5120-390 MUNICIPAL COURT-OTHER SUPPLIES 1,000.00 803.53 .00 63.00 .00 100-51-5140-120 ADMINISTRATOR-WAGES 38,653.00 37,666.38 40,652.00 39,854.64 45,716.00 100-51-5140-130 ADMINISTRATOR- FICA 2,957.00 2,878.36 3,110.00 3,107.62 3,497.00 100-51-5140-135 ADMINISTRATOR-WIS RET FUND 2,512.00 2,445.72 2,764.00 2,762.36 3,154.00 100-51-5140-140 ADMINISTRATOR-INSURANCES 4,597.00 4,755.55 4,865.00 4,934.33 5,695.00 100-51-5140-210 ADMINISTRATOR-PROF SERVICES 695.00 695.00 1,000.00 845.00 1,000.00 100-51-5140-310 ADMINISTRATOR-OFFICE SUPP/EXP 2,000.00 1,629.37 2,000.00 1,690.99 2,000.00 100-51-5140-311 ADMINISTRATOR-COMPUTER SUP/EX 3,100.00 2,534.91 2,600.00 2,880.76 2,600.00 100-51-5140-320 ADMINISTRATOR-PUB/SUB/DUES 66.00 159.00 200.00 164.23 200.00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 4 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-51-5140-330 ADMINISTRATOR-TRAVEL 200.00 240.16 200.00 237.10 300.00 100-51-5140-340 ADMINISTRATOR-OPERATING SUPPL 100.00 50.00 .00 .00 .00 100-51-5140-380 ADMINISTRATOR-UNIFORM ALLOWAN .00 40.00 100.00 84.00 100.00 100-51-5140-390 ADMINISTRATOR-OTHER EXPENSES 200.00 331.31 300.00 371.10 500.00 100-51-5141-120 MAYOR-WAGES 7,200.00 7,200.00 7,200.00 6,900.00 7,200.00 100-51-5141-130 MAYOR-FICA 551.00 550.65 551.00 550.80 551.00 100-51-5141-390 MAYOR-EXPENSES 700.00 761.96 700.00 563.39 700.00 100-51-5142-120 CLERK-WAGES 24,751.00 25,632.88 24,591.00 29,431.89 30,657.00 100-51-5142-125 CLERK-VACATION PAYOUT .00 .00 667.00 .00 .00 100-51-5142-130 CLERK-FICA 1,893.00 2,086.17 1,932.00 2,314.00 2,345.00 100-51-5142-135 CLERK-WI RETIREMENT FUND 1,608.00 1,772.56 1,717.00 2,057.07 2,115.00 100-51-5142-140 CLERK-INSURANCES 1,784.00 1,905.03 1,809.00 37.77 1,784.00 100-51-5142-310 CLERK-OFFICE SUPPLIES/EXPENSES 4,000.00 4,658.14 4,300.00 4,001.94 4,500.00 100-51-5142-311 CLERK-COMPUTER SUPPORT/EXPEN 3,500.00 3,754.54 4,800.00 3,913.67 4,800.00 100-51-5142-320 CLERK-PUB/SUB/DUES 60.00 65.00 65.00 90.04 65.00 100-51-5142-330 CLERK-TRAVEL 425.00 .00 425.00 55.02 425.00 100-51-5142-331 CLERK-TRAINING 600.00 105.00 600.00 678.00 800.00 100-51-5142-340 CLERK-OPERATING SUPPLIES 300.00 .00 .00 .00 .00 100-51-5142-380 CLERK-UNIFORM ALLOWANCE .00 100.00 100.00 60.00 100.00 100-51-5144-120 ELECTIONS-WAGES 3,030.00 3,144.48 3,011.00 3,659.38 3,754.00 100-51-5144-130 ELECTIONS-FICA 232.00 232.90 230.00 287.61 287.00 100-51-5144-135 ELECTIONS-WI RETIREMENT FUND 197.00 197.90 205.00 251.56 259.00 100-51-5144-140 ELECTIONS-INSURANCES 218.00 3.04 221.00 4.62 218.00 100-51-5144-310 ELECTIONS-OFFICE EXPENSE 400.00 221.25 .00 .00 .00 100-51-5144-340 ELECTIONS-OPERATING SUPP/EXP 2,800.00 2,930.40 3,800.00 3,892.18 5,060.00 100-51-5144-390 ELECTIONS-POLL WORKERS 2,700.00 3,502.50 3,250.00 2,110.00 5,485.00 100-51-5151-120 TREASURER-WAGES 31,357.00 30,137.41 32,105.00 29,182.42 37,369.00 100-51-5151-130 TREASURER-FICA 2,399.00 2,281.16 2,456.00 2,313.10 2,859.00 100-51-5151-135 TREASURER-WI RETIREMENT FUND 2,038.00 1,928.40 2,183.00 1,931.28 2,578.00 100-51-5151-140 TREASURER-INSURANCES 13,651.00 13,698.47 14,027.00 13,011.67 16,392.00 100-51-5151-310 TREASURER-OFFICE SUPPLIES/EXP 2,200.00 3,607.30 2,500.00 2,952.22 2,500.00 100-51-5151-311 TREASURER-COMPUTER SUP/EXP 2,800.00 3,595.77 3,500.00 2,547.22 3,500.00 100-51-5151-320 TREASURER-PUB/SUB/DUES 60.00 60.00 60.00 60.00 65.00 100-51-5151-330 TREASURER-TRAVEL .00 .00 200.00 333.05 425.00 100-51-5151-331 TREASURER-TRAINING 1,000.00 50.00 600.00 534.00 750.00 100-51-5151-340 TREASURER-OPERATING SUPPLIES 200.00 117.60 .00 344.00 .00 100-51-5151-380 TREASURER-UNIFORM ALLOWANCE .00 100.00 100.00 116.00 100.00 100-51-5151-390 TREASURER-OTHER EXPENSE 100.00 18.75 .00 30.00 .00 100-51-5153-120 ASSESS OF PROPERTY-WAGES 400.00 200.00 400.00 200.00 400.00 100-51-5153-130 ASSESS OF PROPERTY-FICA 30.60 16.94 30.60 15.32 31.00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 5 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-51-5153-210 ASSESS OF PROPERTY-PROF SERV 27,050.00 10,572.10 13,375.00 27,062.21 13,500.00 100-51-5153-340 ASSESS OF PROPERTY-OPER SUPPL 50.00 44.33 50.00 60.00 50.00 100-51-5153-390 ASSESS OF PROPERTY-OTHER EXP 125.00 75.26 125.00 .00 125.00 100-51-5157-210 INDEPENDENT AUDITING-PRO SERVI 30,700.00 32,661.00 30,700.00 43,569.01 42,000.00 100-51-5161-210 ATTORNEY-PROFESSIONAL SERVICE 8,000.00 7,061.24 9,000.00 3,275.50 5,000.00 100-51-5161-290 ATTORNEY-PROSECUTION 1,000.00 2,992.50 2,500.00 1,057.50 2,500.00 100-51-5162-220 OTHER MUNI BLDG-UTILITY SERVIC 3,500.00 3,472.13 3,980.00 3,255.11 4,458.00 100-51-5162-350 OTHER MUNI BLDG-REP/MAIN SUPPL 585.00 .00 585.00 383.67 700.00 100-51-5162-390 OTHER MUNI BLDG-OTHER SUPP/EX 100.00 55.00 100.00 61.66 .00 100-51-5163-210 COD OF ORDIN.-PROFESSIONAL SER .00 .00 2,200.00 .00 2,200.00 100-51-5171-120 MUNI BLDG-WAGES 6,117.00 3,687.34 3,600.00 3,084.69 7,013.00 100-51-5171-130 MUNI BLDG-FICA 468.00 284.48 239.00 238.14 537.00 100-51-5171-135 MUNI BLDG-WI RET FUND 66.00 92.69 70.00 36.14 77.00 100-51-5171-140 MUNI BLDG-INSURANCES 404.00 612.53 400.00 182.10 484.00 100-51-5171-210 MUNI BLDG-PROFESSIONAL SERVICE 1,200.00 1,166.00 1,000.00 2,627.67 1,000.00 100-51-5171-220 MUNI BLDG-UTILITY SERVICES 13,000.00 16,321.89 17,220.00 14,654.77 19,286.00 100-51-5171-230 MUNI BLDG-REPAIR/MAIN SERVICES 100.00 .00 .00 .00 .00 100-51-5171-340 MUNI BLDG-OPERATING EXPENSE 1,000.00 943.92 .00 256.40 .00 100-51-5171-350 MUNI BLDG-REP/MAIN EXPENSE 3,000.00 3,144.78 3,000.00 2,277.63 3,000.00 100-51-5171-390 MUNI BLDG-SUPPLIES/EXPENSE 1,700.00 2,409.15 2,700.00 3,850.56 3,000.00 100-51-5194-510 PROPERTY/LIABILITY INSURANCE 23,552.00 21,139.76 24,380.00 23,058.33 26,818.00 100-51-5196-510 WORKER'S COMP INSURANCE 15,053.00 13,987.98 13,990.00 14,740.21 15,389.00 PUBLIC SAFTEY 100-52-5210-120 POLICE ADMIN-WAGES 92,160.00 101,474.91 90,782.00 93,092.61 94,099.00 100-52-5210-130 POLICE ADMIN-FICA 7,050.00 7,229.52 6,945.00 6,741.17 7,199.00 100-52-5210-135 POLICE ADMIN-WI RET FUND 5,225.00 5,244.66 5,034.00 4,360.03 5,113.00 100-52-5210-140 POLICE ADMIN-INSURANCES 14,706.00 9,764.91 25,404.00 19,374.33 27,233.00 100-52-5210-190 POLICE ADMIN-UNIFORM ALLOWANC 600.00 274.96 600.00 798.45 600.00 100-52-5210-320 POLICE ADMIN -PUB/SUB/DUES 150.00 .00 150.00 .00 150.00 100-52-5210-330 POLICE ADMIN-TRAIN/TRAVEL EXP .00 180.40 200.00 464.33 200.00 100-52-5210-390 POLICE ADMIN-OTHER SUP/EXPENSE 100.00 110.45 100.00 138.32 100.00 100-52-5211-120 POLICE PATROL-WAGES 146,713.00 111,377.89 114,052.00 110,478.48 137,095.00 100-52-5211-130 POLICE PATROL-FICA 11,224.00 8,653.45 8,725.00 8,758.24 10,488.00 100-52-5211-135 POLICE PATROL-WI RET FUND 15,260.00 13,662.66 15,055.00 15,135.11 19,605.00 100-52-5211-140 POLICE PATROL-INSURANCES 25,660.00 23,980.44 26,215.00 24,725.58 29,877.00 100-52-5211-190 POLICE PATROL-UNIFORM ALLOWAN 1,400.00 1,321.36 1,400.00 817.90 1,400.00 100-52-5211-210 POLICE PATROL-PROFESSIONAL SER 500.00 .00 500.00 133.00 500.00 100-52-5211-220 POLICE PATROL-TELEPHONE 3,800.00 3,582.98 3,800.00 3,100.64 3,800.00 100-52-5211-230 POLICE PATROL-VEHICLE LEASE 5,800.00 5,371.72 5,344.47 28,994.30 .00 100-52-5211-310 POLICE PATROL-OFFICE SUPPL/EXP 3,200.00 3,942.56 3,800.00 3,158.82 3,800.00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 6 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-52-5211-311 POLICE PATROL-COMPUTER SUPPO 10,800.00 11,071.88 12,000.00 13,184.28 12,000.00 100-52-5211-330 POLICE PATROL-TRAIN/TRAVEL EXP 2,000.00 418.15 2,500.00 1,079.73 3,000.00 100-52-5211-340 POLICE PATROL-OPERATING SUP/EX 1,300.00 820.44 1,300.00 624.45 1,300.00 100-52-5211-350 POLICE PATROL-REPAIR/MAIN SUPP 500.00 585.00 500.00 42.07 500.00 100-52-5211-370 POLICE PATROL-VEH MAINT/REPAIR 2,000.00 3,551.63 4,000.00 1,162.06 4,000.00 100-52-5211-371 POLICE PATROL-GAS 5,000.00 6,025.18 6,000.00 4,766.32 6,000.00 100-52-5211-390 POLICE PATROL-OTHER SUPP/EXPEN 1,000.00 1,405.59 1,500.00 270.66 1,500.00 100-52-5232-120 FIRE SUPPRESSION-WAGES .00 .00 .00 104.00- .00 100-52-5232-130 FIRE SUPPRESSION-FICA .00 .00 .00 .00 .00 100-52-5232-290 FIRE SUPPRESSION-HYDRANT RENT 139,389.00 139,389.00 139,389.00 139,389.00 150,540.00 100-52-5232-390 FIRE SUPPRESSION-OTHER/MAINT/R 1,000.00 822.00 1,000.00 1,326.15 1,000.00 100-52-5232-590 FIRE SUPPRESSION-FIRE CALLS 1,000.00 744.00 800.00 28,020.60 800.00 100-52-5232-591 FIRE SUPPRESSION-F.A. BUDGET 53,737.20 53,737.20 53,738.00 26,868.60 68,310.00 100-52-5232-592 FIRE SUPPRESSION-2% FIRE DUES 4,000.00 4,670.36 4,500.00 .00 4,500.00 100-52-5241-210 BUILDING INSPECTION-PRO SERVIC 14,000.00 26,751.21 14,000.00 21,202.11 19,000.00 100-52-5241-310 BUILDING INSPECTION-OFFICE SUP 50.00 49.48 50.00 16.19 50.00 PUBLIC WORKS 100-53-5323-120 GARAGE-WAGES 33,433.00 25,161.55 34,870.00 37,575.37 36,783.00 100-53-5323-125 GARAGE-VACATION PAYOUT .00 6,922.08 6,939.00 5,461.20 9,000.00 100-53-5323-130 GARAGE-FICA 2,558.00 2,417.13 3,197.00 3,344.43 3,386.00 100-53-5323-135 GARAGE-WI RETIREMENT FUND 2,061.00 2,034.38 2,710.00 2,938.79 3,401.00 100-53-5323-140 GARAGE-INSURANCES 12,583.00 9,612.48 12,927.00 18,716.74 15,061.00 100-53-5323-210 GARAGE-CELL PHONES 900.00 778.22 900.00 598.70 900.00 100-53-5323-220 GARAGE-UTILITY SERVICES 11,500.00 14,016.85 13,000.00 13,041.68 14,560.00 100-53-5323-320 GARAGE-LEASE PAYMENT 13,742.00 13,741.20 13,742.00 12,596.10 2,000.00 100-53-5323-340 GARAGE-OPERATING SUPPL/EXP 8,000.00 8,649.57 8,000.00 10,154.91 8,000.00 100-53-5323-341 GARAGE-TOOL REPLACEMENT 1,500.00 1,343.01 1,500.00 1,221.32 1,500.00 100-53-5323-380 GARAGE-UNIFORM ALLOWANCE 380.00 852.96 1,800.00 1,737.61 1,800.00 100-53-5323-390 GARAGE-OTHER EXPENSE 3,800.00 4,778.00 2,500.00 2,510.05 2,000.00 100-53-5324-120 MACH/EQUIPMENT-WAGES 43,903.00 40,646.59 36,327.00 36,973.11 38,320.00 100-53-5324-130 MACH/EQUIPMENT-FICA 3,358.00 3,118.01 2,779.00 2,874.62 2,931.00 100-53-5324-135 MACH/EQUIPMENT-WI RET FUND 2,707.00 2,649.29 2,332.00 2,555.21 2,485.00 100-53-5324-140 MACH/EQUIPMENT-INSURANCES 16,524.00 16,452.96 13,467.00 15,442.86 15,690.00 100-53-5324-340 MACH/EQUIPMENT-OPER SUP/EXP 4,000.00 2,563.40 4,000.00 1,865.11 4,000.00 100-53-5324-350 MACH/EQUIPMENT-REPAIR/MAINT 4,000.00 4,570.52 4,000.00 4,095.48 4,000.00 100-53-5324-370 MACH/EQUIPMENT-VEHICLE MAINT 3,500.00 4,445.55 3,500.00 3,763.15 8,500.00 100-53-5324-371 MACH/EQUIPMENT-GAS 2,000.00 1,671.61 2,000.00 1,961.40 2,000.00 100-53-5324-390 MACH/EQUIPMENT-OTHER 1,000.00 1,157.49 1,000.00 1,156.69 1,000.00 100-53-5330-120 STREETS/ALLEYS-WAGES 3,168.00 2,982.00 2,971.00 3,636.95 3,134.00 100-53-5330-125 STREETS/ALLEYS-VACATION PAYOUT .00 207.24 .00 32.34 .00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 7 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-53-5330-130 STREETS/ALLEYS-FICA 242.00 239.83 227.00 286.47 240.00 100-53-5330-135 STREETS/ALLEYS-WI RET FUND 195.00 183.58 190.00 236.95 203.00 100-53-5330-140 STREETS/ALLEYS-INSURANCES 1,192.00 1,224.27 1,101.00 1,534.74 1,283.00 100-53-5330-320 STREETS/ALLEYS-LEASE PAYMENT 10,900.00 10,899.38 10,900.00 10,899.38 10,900.00 100-53-5330-340 STREETS/ALLEYS-OPERATING SUP/E 1,000.00 326.02 .00 .00 .00 100-53-5330-350 STREETS/ALLEYS-REP/MAIN SUPPLI 2,000.00 .00 1,000.00 1,253.62 1,500.00 100-53-5330-370 STREETS/ALLEYS-ROADWAY SUPPLI 25,000.00 15,836.42 25,000.00 10,084.50 25,000.00 100-53-5330-390 STREETS/ALLEYS-OTHER SUP/EXP 200.00 53.18 200.00 147.00 200.00 100-53-5331-120 BRIDGES/CULVERTS-WAGES 75.00 27.72 66.00 .00 70.00 100-53-5331-130 BRIDGES/CULVERTS-FICA 6.00 4.66 5.00 .00 5.00 100-53-5331-135 BRIDGES/CULVERTS-WI RET FUND 5.00 35.10 4.00 .00 5.00 100-53-5331-140 BRIDGES/CULVERTS-INSURANCES 28.00 10.11 .00 .00 29.00 100-53-5331-340 BRIDGES/CULVERTS-OPERATING SU 500.00 .00 .00 .00 500.00 100-53-5332-120 CURB/GUTTER-WAGES 86.00 66.60 109.00 19.50 116.00 100-53-5332-130 CURB/GUTTER-FICA 7.00 5.09 8.00 1.49 9.00 100-53-5332-135 CURB/GUTTER-WI RET FUND 5.00 3.61 7.00 .00 8.00 100-53-5332-140 CURB/GUTTER-INSURANCES 32.00 33.13 40.00 .00 47.00 100-53-5333-120 STREET CLEANING-WAGES 2,435.00 839.52 2,348.00 1,047.87 2,478.00 100-53-5333-130 STREET CLEANING-FICA 186.00 64.21 179.00 80.16 190.00 100-53-5333-135 STREET CLEANING-WI RET FUND 152.00 54.57 150.00 71.26 161.00 100-53-5333-140 STREET CLEANING-INSURANCES 983.00 347.00 870.00 456.62 1,015.00 100-53-5333-320 ST CLEANING-LEASE PAYMENT 20,900.00 284,157.00 20,900.00 20,900.00 20,900.00 100-53-5333-350 STREET CLEANING-CONTRACTED SE .00 .00 .00 .00 .00 100-53-5333-370 STREET CLEANING-EQUIP REP/MAIN 500.00 .00 1,500.00 159.60 2,000.00 100-53-5333-371 STREET CLEANING-GAS 1,200.00 .00 400.00 400.00 400.00 100-53-5333-390 STREET CLEANING-OTHER SUP/EXP .00 1.56 .00 .00 .00 100-53-5334-120 SNOW/ICE REMOVAL-WAGES 12,783.00 9,647.48 13,218.00 11,721.13 13,944.00 100-53-5334-130 SNOW/ICE REMOVAL-FICA 977.00 779.31 1,011.00 932.39 1,067.00 100-53-5334-135 SNOW/ICE REMOVAL-WI RET FUND 788.00 662.20 848.00 828.80 904.00 100-53-5334-140 SNOW/ICE REMOVAL-INSURANCES 4,810.00 3,209.46 4,900.00 4,714.74 5,709.00 100-53-5334-320 SNOW/ICE REMOVAL-LEASE PAYMEN 10,900.00 10,899.39 10,900.00 40,566.74 40,600.00 100-53-5334-340 SNOW/ICE REMOVAL-OPERATING SU 4,000.00 .00 4,000.00 3,870.30 4,000.00 100-53-5334-370 SNOW/ICE REMOVAL-VEHICLE MAIN 6,000.00 1,463.96 6,000.00 6,146.27 6,000.00 100-53-5334-371 SNOW/ICE REMOVAL-GAS 3,500.00 4,942.20 3,500.00 3,848.29 4,000.00 100-53-5334-390 SNOW/ICE REMOVAL-MISC SUP/EXP 15,000.00 187,696.15 15,000.00 8,789.00 15,000.00 100-53-5335-120 TRAFFIC CONTROL-WAGES 1,330.00 2,340.03 1,974.00 1,230.53 2,083.00 100-53-5335-130 TRAFFIC CONTROL-FICA 101.00 179.03 151.00 94.14 159.00 100-53-5335-135 TRAFFIC CONTROL-WI RET FUND 82.00 152.12 126.00 83.70 135.00 100-53-5335-140 TRAFFIC CONTROL-INSURANCES 500.00 712.41 732.00 500.72 853.00 100-53-5335-340 TRAFFIC CONTROL-OPER SUPPLIES 2,500.00 1,369.58 1,500.00 2,494.81 2,500.00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 8 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-53-5335-390 TRAFFIC CONTROL-SUPP/EXP 2,000.00 2,181.70 2,500.00 .00 2,500.00 100-53-5336-120 TREE/BRUSH-WAGES 8,808.00 9,804.87 11,124.00 6,080.16 11,734.00 100-53-5336-130 TREE/BRUSH-FICA 673.00 763.22 850.00 474.45 898.00 100-53-5336-135 TREE/BRUSH-WI RET FUND 543.00 623.97 714.00 396.92 761.00 100-53-5336-140 TREE/BRUSH-INSURANCES 3,315.00 4,312.20 4,123.00 2,559.06 4,805.00 100-53-5336-370 TREE/BRUSH-VEHICLE MAINTENANC 500.00 139.52 500.00 174.70 500.00 100-53-5336-371 TREE/BRUSH-GAS 500.00 1,636.36 1,800.00 1,230.35 1,800.00 100-53-5336-390 TREE/BRUSH-SUPPLIES/EXPENSE 4,000.00 3,500.00 3,000.00 557.96 1,000.00 100-53-5342-220 STREET LIGHTING 27,500.00 29,441.05 32,800.00 25,522.14 36,736.00 100-53-5343-120 SDWALKS/CROSSWALKS-WAGES 29.00 250.47 110.00 57.95 117.00 100-53-5343-130 SDWALKS/CROSSWALKS-FICA 2.00 19.16 8.00 4.44 9.00 100-53-5343-135 SDWALKS/CROSSWALKS-WI RET FND 2.00 16.28 7.00 3.95 8.00 100-53-5343-140 SDWALKS/CROSSWALKS- INSURANC 11.00 113.56 41.00 22.39 48.00 100-53-5343-290 SDWALKS/CROSSWALKS-CONTRACT 1,500.00 3,193.94 1,500.00 .00 1,500.00 100-53-5344-120 STORM SEWER-WAGES 1,247.00 1,172.12 1,281.00 805.02 1,352.00 100-53-5344-130 STORM SEWER-FICA 95.00 89.66 98.00 61.59 103.00 100-53-5344-135 STORM SEWER-WI RET FUND 77.00 75.46 82.00 53.90 88.00 100-53-5344-140 STORM SEWER-INSURANCES 470.00 443.59 474.00 297.36 553.00 100-53-5344-350 STORM SEWER-REPAIR/MAIN SUPPLI 1,500.00 9,279.00 4,315.00 5,213.12 6,000.00 100-53-5344-390 STORM SEWER-SUPPLIES/EXPENSE 500.00 850.00 500.00 997.33 500.00 100-53-5345-120 PARKING LOTS-WAGES 529.00 43.56 80.00 57.94 85.00 100-53-5345-130 PARKING LOTS-FICA 41.00 3.33 6.00 4.44 7.00 100-53-5345-135 PARKING LOTS-WI RET FUND 32.00 2.83 5.00 3.94 6.00 100-53-5345-140 PARKING LOTS-INSURANCES 200.00 18.85 30.00 19.63 35.00 100-53-5345-220 PARKING LOTS-UTILITY SERVICES 420.00 683.38 729.00 814.47 816.00 100-53-5362-120 GARBAGE COLLECTION-WAGES 1,335.00 842.82 1,727.00 1,550.72 1,822.00 100-53-5362-130 GARBAGE COLLECTION-FICA 87.00 65.11 132.00 119.39 139.00 100-53-5362-135 GARBAGE COLLECTION-WI RET FND 70.00 54.61 110.00 103.94 118.00 100-53-5362-140 GARBAGE COLLECTION- INSURANCE 428.00 459.99 640.00 724.40 746.00 100-53-5362-210 GARBAGE COLLECTION-PROF SERVI 71,000.00 73,379.11 73,700.00 80,840.20 90,510.00 100-53-5362-371 GARBAGE COLLECTION-GAS 200.00 432.41 400.00 465.40 400.00 100-53-5362-390 GARBAGE COLLECTION-OTHER EXP 4,500.00 3,637.37 1,000.00 475.00 1,000.00 100-53-5363-120 TRANSFER STATION-WAGES 271.00 906.90 784.00 253.33 827.00 100-53-5363-130 TRANSFER STATION-FICA 20.00 69.36 60.00 19.38 63.00 100-53-5363-135 TRANSFER STATION-WI RET FUND 16.00 58.95 50.00 17.23 54.00 100-53-5363-140 TRANSFER STATION-INSURANCES 102.00 355.98 290.00 108.01 339.00 100-53-5363-220 TRANSFER STATION-UTILITY SERVI 300.00 326.91 360.00 302.27 403.00 100-53-5363-290 TRANSFER STATION-CONTRACT SER 2,500.00 2,448.00 2,100.00 2,732.00 5,600.00 100-53-5363-340 TRANSFER STATION-OPER. SUPPLIE .00 .00 .00 .00 .00 100-53-5363-390 TRANSFER STATION-OTHER SUPP/EP 1,500.00 165.00 3,000.00 590.00 3,000.00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 9 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-53-5365-120 RECYCLING-WAGES 6,483.00 9,705.86 8,766.00 7,812.73 9,248.00 100-53-5365-130 RECYCLING-FICA 497.00 743.96 670.00 607.10 707.00 100-53-5365-135 RECYCLING-WI RET FUND 398.00 632.14 562.00 534.79 600.00 100-53-5365-140 RECYCLING-INSURANCES 2,374.00 3,979.54 3,250.00 3,105.65 3,787.00 100-53-5365-210 RECYCLING-PROFESSIONAL SERVIC 25,000.00 25,836.50 25,950.00 29,306.74 36,890.00 100-53-5365-340 RECYCLING-OPERATING SUPP/EXP 200.00 635.15 800.00 1,297.50 1,500.00 100-53-5365-370 RECYCLING-VEHICLE MAINTENANCE 1,000.00 .00 1,000.00 48.90 1,000.00 100-53-5365-371 RECYCLING-GAS 1,000.00 2,054.52 2,000.00 1,733.82 2,000.00 100-53-5422-290 ENGINEERING-STORM SEWERS 1,000.00 .00 1,000.00 .00 1,000.00 100-53-5424-290 ENGINEERING-STREET 5,000.00 655.00 5,000.00 3,186.25 5,000.00 100-53-5429-290 ENGINEERING-OTHER 2,500.00 7,286.40 2,500.00 2,334.32 2,500.00 HEALTH AND HUMAN SERVICES 100-54-5410-290 RETIRED PERSONS HEALTH INSURA 6,094.80 .00 5,950.80 .00 7,021.00 100-54-5414-290 ANIMAL POUND-CONTRACT SERVICE 300.00 .00 300.00 .00 300.00 100-54-5910-120 CEMETERY-WAGES 9,947.00 17,314.99 15,155.00 16,057.10 15,806.00 100-54-5910-130 CEMETERY-FICA 761.00 1,318.63 1,159.00 1,234.31 1,209.00 100-54-5910-135 CEMETERY-WI RETIREMENT FUND 40.00 211.79 337.00 116.33 360.00 100-54-5910-140 CEMETERY-INSURANCES 251.00 1,432.34 1,948.00 658.66 2,270.00 100-54-5910-210 CEMETERY-CONTRACTED SERVICES 4,000.00 1,531.22 20,000.00 20,100.00 2,000.00 100-54-5910-220 CEMETERY-UTILITY SERVICES 400.00 356.48 360.00 339.90 403.00 100-54-5910-340 CEMETERY-OPERATING SUPPLIES 1,200.00 2,323.80 2,000.00 2,535.68 2,000.00 100-54-5910-350 CEMETERY-REPAIR/MAIN EXPENSE 1,000.00 1,525.34 1,000.00 2,580.51 1,000.00 100-54-5910-390 CEMETERY-SUPPLIES/EXPENSE 1,000.00 762.13 1,000.00 604.21 1,000.00 CULTURE,RECREATION & EDUCATION 100-55-5157-210 INDEPENDENT AUDITING-LIBRARY 2,500.00 2,000.00 2,500.00 2,396.59 2,500.00 100-55-5511-120 LIBRARY-WAGES 70,206.00 69,222.08 81,770.00 72,367.16 87,367.00 100-55-5511-130 LIBRARY-FICA 5,371.00 5,283.55 6,255.00 5,641.26 6,683.00 100-55-5511-135 LIBRARY-WI RETIREMENT FUND 2,767.00 2,751.56 3,041.00 2,926.29 3,350.00 100-55-5511-140 LIBRARY-INSURANCES 20,836.00 21,099.14 21,395.00 21,748.20 25,053.00 100-55-5511-145 LIBRARY-WORKERS COMP INS 1,768.00 1,641.62 1,642.00 1,729.89 1,806.00 100-55-5511-220 LIBRARY-UTILITY SERVICES 6,000.00 5,674.27 7,800.00 4,989.97 8,736.00 100-55-5511-290 LIBRARY-CONTRACTUAL SERVICES 9,500.00 8,872.57 9,700.00 8,527.99 9,900.00 100-55-5511-310 LIBRARY-OFFICE SUPPLIES 2,500.00 2,142.78 2,500.00 1,658.75 2,000.00 100-55-5511-315 LIBRARY-ADULT & JUVENILE PROGR 4,000.00 4,190.73 4,000.00 2,709.38 4,000.00 100-55-5511-320 LIBRARY-SUBSCRIPTIONS/MAGAZINE 1,200.00 1,043.39 1,300.00 937.79 1,300.00 100-55-5511-331 LIBRARY-TRAINING 1,000.00 1,116.60 1,000.00 1,045.49 1,000.00 100-55-5511-340 LIBRARY-OPERATING SUPP/MISC 3,000.00 2,685.35 3,000.00 2,749.43 2,500.00 100-55-5511-350 LIBRARY-REP/MAIN BLDG & EQUIPT 3,000.00 2,134.13 3,000.00 1,703.70 3,000.00 100-55-5511-390 LIBRARY-MATERIALS 20,000.00 18,409.50 20,000.00 18,721.92 20,000.00 100-55-5515-390 HARRIETT O'CONNELL SUP/EXPENSE 1,500.00 1,264.21 1,500.00 1,264.48 1,500.00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 10 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-55-5520-120 PARKS-WAGES 33,929.00 34,707.49 35,496.00 34,906.99 37,444.00 100-55-5520-130 PARKS-FICA 2,596.00 2,615.09 2,715.00 2,734.03 2,865.00 100-55-5520-135 PARKS-WI RETIREMENT FUND 2,093.00 2,017.27 2,279.00 2,087.08 2,429.00 100-55-5520-140 PARKS-INSURANCES 12,770.00 14,208.16 13,159.00 13,115.21 15,332.00 100-55-5520-220 PARKS-UTILITY SERVICES 2,100.00 1,727.90 1,792.00 1,667.48 2,007.00 100-55-5520-340 PARKS-OPERATING SUPPLIES 3,500.00 418.79 500.00 501.56 500.00 100-55-5520-350 PARKS-REPAIR/MAINT SUP/EXP 3,000.00 1,309.95 3,000.00 719.51 4,000.00 100-55-5520-370 PARKS-VEHICLE MAINTENANCE 1,500.00 .00 1,500.00 99.31 1,500.00 100-55-5520-371 PARKS-GAS 3,000.00 2,656.81 3,000.00 3,143.44 3,000.00 100-55-5520-390 PARKS-SUPPLIES/EXPENSE 2,000.00 1,645.45 1,000.00 829.13 1,000.00 100-55-5520-391 PARKS-OTHER EXPENSE .00 1,854.50 .00 1,723.76 1,000.00 100-55-5530-120 CELEBRATIONS-WAGES 791.00 628.68 706.00 462.70 745.00 100-55-5530-130 CELEBRATIONS-FICA 61.00 50.26 54.00 37.69 57.00 100-55-5530-135 CELEBRATIONS-WI RET FUND 49.00 42.65 45.00 33.51 48.00 100-55-5530-140 CELEBRATIONS-INSURANCES 298.00 263.23 261.00 209.48 305.00 100-55-5530-340 CELEBRATIONS-OPERATING SUP/EX 400.00 577.94 5,000.00 3,526.36 2,000.00 100-55-5530-390 CELEBRATIONS-OTHER EXPENSE 8,840.00 9,331.18 9,180.00 7,527.42 9,180.00 100-55-5541-120 WATER RECREATION-WAGES 191.00 .00 94.00 .00 100.00 100-55-5541-130 WATER RECREATION-FICA 15.00 .00 7.00 .00 8.00 100-55-5541-135 WATER RECREATION-WI RET FUND 11.00 .00 6.00 .00 6.00 100-55-5541-140 WATER RECREATION-INSURANCES 72.00 .00 35.00 .00 41.00 100-55-5541-340 WATER RECREATION-OPER SUP/EXP 2,000.00 3,437.93 5,000.00 3,863.40 5,000.00 100-55-5541-350 WATER RECREATION-REP/MAIN SUP 1,000.00 343.68 500.00 .00 1,000.00 100-55-5541-390 WATER RECREATION-OTHER SUP/EX .00 .00 .00 .00 .00 100-55-5542-120 SWIMMING POOL-WAGES 3,690.00 2,917.29 2,350.00 2,822.29 2,500.00 100-55-5542-130 SWIMMING POOL-FICA 282.00 223.15 180.00 215.91 190.00 100-55-5542-135 SWIMMING POOL-WI RET FUND 239.00 189.62 159.00 186.16 173.00 100-55-5542-140 SWIMMING POOL-INSURANCES 1,479.00 985.65 922.00 926.22 1,088.00 100-55-5542-210 SWIMMING POOL-PROFESSIONAL SE 500.00 80.00 100.00 25.00 100.00 100-55-5542-220 SWIMMING POOL-UTILITY SERVICES 9,800.00 12,091.63 12,034.00 15,150.06 13,478.00 100-55-5542-290 SWIMMING POOL-CONTRACTUAL SE 35,500.00 39,923.42 45,000.00 56,295.60 50,000.00 100-55-5542-310 SWIMMING POOL-OFFICE SUPPLIES 50.00 7.99 50.00 54.99 50.00 100-55-5542-331 SWIMMING POOL-CONCESSIONS 1,500.00 1,416.29 1,500.00 2,834.06 2,800.00 100-55-5542-340 SWIMMING POOL-OPERATING SUP/E 3,000.00 1,987.98 3,000.00 1,255.61 3,000.00 100-55-5542-350 SWIMMING POOL-CHEMICALS 4,000.00 2,885.66 5,500.00 4,315.53 5,500.00 100-55-5542-351 SWIMMING POOL-REP/MAINT SUP/EX 4,500.00 4,760.85 5,000.00 5,668.98 5,000.00 100-55-5542-390 SWIMMING POOL-SUPP/EXPENSE 2,000.00 4.00 .00 89.27 .00 100-55-5543-120 OTHER SUMMER REC-WAGES 560.00 .00 .00 .00 .00 100-55-5543-130 OTHER SUMMER REC-FICA 42.00 .00 .00 .00 .00 100-55-5543-135 OTHER SUMMER REC-WI RET FUND 34.00 .00 .00 .00 .00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 11 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-55-5543-140 OTHER SUMMER REC-INSURANCES 215.00 .00 .00 .00 .00 100-55-5543-390 OTHER SUMMER REC-SUP/EXP 220.00 .00 .00 .00 .00 100-55-5544-120 OTHER WINTER REC-WAGES 27.00 .00 .00 .00 .00 100-55-5544-130 OTHER WINTER REC-FICA 2.00 .00 .00 .00 .00 100-55-5544-135 OTHER WINTER REC-WI RET FUND 2.00 .00 .00 .00 .00 100-55-5544-140 OTHER WINTER REC-INSURANCES 10.00 .00 .00 .00 .00 CONSERVATION & DEVELOPMENT 100-56-5364-120 WEED CONTROL-WAGES 1,028.00 1,212.75 1,260.00 548.56 1,329.00 100-56-5364-130 WEED CONTROL-FICA 79.00 92.78 96.00 41.95 102.00 100-56-5364-135 WEED CONTROL-WI RET FUND 64.00 78.83 80.00 36.88 86.00 100-56-5364-140 WEED CONTROL-INSURANCES 387.00 430.60 467.00 125.42 544.00 100-56-5364-210 WEED CONTROL-PROFESSIONAL SE 500.00 1,200.00 1,000.00 .00 1,000.00 100-56-5364-350 WEED CONTROL-REPAIR/MAIN SUPP 100.00 240.77 500.00 41.52 500.00 100-56-5364-370 WEED CONTROL-VEHICLE MAINTENA 500.00 .00 .00 .00 .00 100-56-5364-371 WEED CONTROL-GAS 200.00 438.06 500.00 177.27 500.00 100-56-5364-390 WEED CONTROL-SUPP/EXPENSE 1,500.00 884.60 1,500.00 2,834.62 2,500.00 100-56-5611-120 FORESTRY-WAGES 1,582.00 1,457.96 1,556.00 434.55 1,642.00 100-56-5611-130 FORESTRY-FICA 121.00 111.54 119.00 33.24 126.00 100-56-5611-135 FORESTRY-WI RET FUND 98.00 94.76 99.00 29.55 107.00 100-56-5611-140 FORESTRY-INSURANCES 595.00 383.79 577.00 151.95 672.00 100-56-5611-210 FORESTRY-CONTRACTED SERVICES 2,000.00 2,000.00 8,000.00 8,150.00 8,000.00 100-56-5611-390 FORESTRY-SUPPLIES/EXPENSE 500.00 283.45 500.00 416.03 500.00 100-56-5670-120 ECON DEVELOPMENT-WAGES 31.00 76.23 53.00 .00 57.00 100-56-5670-130 ECON DEVELOPMENT-FICA 3.00 5.83 4.00 .00 4.00 100-56-5670-135 ECON DEVELOPMENT-WI RET FUND 2.00 4.95 3.00 .00 4.00 100-56-5670-140 ECON DEVELOPMENT-INSURANCES 12.00 28.19 19.00 .00 23.00 100-56-5670-390 ECON DEVELOPMENT-SUP/EXPENSE 300.00 481.61 503.00 500.65 503.00 100-56-5690-120 DAM-WAGES 3,625.00 3,002.63 3,107.00 2,855.62 3,278.00 100-56-5690-130 DAM-FICA 277.00 232.01 237.00 220.98 251.00 100-56-5690-135 DAM-WI RET FUND 223.00 197.18 199.00 195.06 212.00 100-56-5690-140 DAM-INSURANCES 1,365.00 1,187.24 1,152.00 1,121.41 1,342.00 100-56-5690-210 DAM-PROFESSIONAL SERVICES 500.00 .00 500.00 .00 212.00 100-56-5690-350 DAM-REPAIR/MAINTENANCE EXPENS 200.00 .00 1,200.00 357.50 1,200.00 100-56-5690-390 DAM-OTHER SUPPLIES/EXPENSE 200.00 .00 .00 .00 .00 DEBT SERVICE 100-58-5915-620 INTEREST - SHORT TERM LOAN .00 .00 .00 .00 .00 100-58-5946-210 SPECIAL EXPENDITURE FUND .00 .00 .00 400.00 .00 OTHER FINANCING USES 100-59-5900-301 TRANSFER OUT TO 301 148,655.81 148,655.81 220,561.64 220,561.64 205,700.00 100-59-5900-400 TRANSFER OUT TO 400 63,660.00 63,660.00 .00 .00 8,130.00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 12 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-59-5900-401 TRANSFERS OUT TO 401 .00 .00 64,700.00 .00 .00 GENERAL FUND Revenue Total: 1,981,181.41 2,337,289.79 2,135,338.51 1,081,145.57 2,264,588.00 GENERAL FUND Expenditure Total: 1,981,181.41 2,352,398.27 2,135,338.51 2,056,232.63 2,264,108.00 Net Total GENERAL FUND: .00 15,108.48- .00 975,087.06- 480.00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 13 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget REVOLVING LOAN S/R FUND MISCELLANEOUS REVENUE 202-48-4810-000 INTEREST 15.00 4.90 15.00 4.39 15.00 Total MISCELLANEOUS REVENUE: 15.00 4.90 15.00 4.39 15.00 CAPITAL OUTLAY 202-57-5710-310 ADMINISTRATIVE EXPENSE 500.00 3,460.76 500.00 .00 500.00 REVOLVING LOAN S/R FUND Revenue Total: 15.00 4.90 15.00 4.39 15.00 REVOLVING LOAN S/R FUND Expenditure Total: 500.00 3,460.76 500.00 .00 500.00 Net Total REVOLVING LOAN S/R FUND: 485.00- 3,455.86- 485.00- 4.39 485.00- CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 14 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget REDEVELOPMENT AUTHORITY FUND SOURCE: 43 205-43-4300-000 IGR TIF repayment of 1.2M .00 44,026.00 .00 .00 .00 Total SOURCE: 43: .00 44,026.00 .00 .00 .00 MISCELLANEOUS REVENUE 205-48-4800-000 TRANSFER IN 88,973.20 0.20 88,963.20 88,963.20 88,975.00 205-48-4810-000 INTEREST .00 14,554.00 .00 .00 .00 205-48-4850-000 MISCELLANEOUS REVENUE 16,000.00 10,032.84 12,300.00 14,859.36 12,900.00 Total MISCELLANEOUS REVENUE: 104,973.20 24,587.04 101,263.20 103,822.56 101,875.00 GENERAL GOVERMENT 205-51-5157-210 INDEPENDENT AUDITING 3,100.00 3,100.00 3,100.00 .00 3,100.00 CAPITAL OUTLAY 205-57-5710-310 ADMINISTRATIVE EXPENSE 3,000.00 7,558.00 3,000.00 2,214.98 3,000.00 DEBT SERVICE 205-58-5813-610 RDA 1.2M 2019 - PRINCIPAL 44,943.39 44,937.21 46,863.35 46,870.85 48,763.00 205-58-5813-620 RDA 1.2M 2019 - INTEREST 44,029.81 44,025.99 42,099.86 42,092.35 40,201.00 REDEVELOPMENT AUTHORITY FUND Revenue Total: 104,973.20 68,613.04 101,263.20 103,822.56 101,875.00 REDEVELOPMENT AUTHORITY FUND Expenditure Total: 95,073.20 99,621.20 95,063.21 91,178.18 95,064.00 Net Total REDEVELOPMENT AUTHORITY FUND: 9,900.00 31,008.16- 6,199.99 12,644.38 6,811.00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 15 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget ARPA FUND INTERGOVERNMENTAL REVENUES 206-43-4361-000 ARPA GRANT 75,832.37 10,610.05 .00 .00 .00 Total INTERGOVERNMENTAL REVENUES: 75,832.37 10,610.05 .00 .00 .00 OTHER FINANCING SOURCES 206-49-4930-000 FUNDS APPLIED 35,000.00 .00 109,043.68 .00 50,000.00 Total OTHER FINANCING SOURCES: 35,000.00 .00 109,043.68 .00 50,000.00 GENERAL GOVERNMENT 206-51-5140-120 COVID SICK LEAVE 2,332.37 .00 .00 .00 .00 206-51-5140-310 ADMINISTRATIVE EXPENSE 1,250.00 1,375.57 1,300.00 .00 .00 PUBLIC SAFETY 206-52-5210-000 PUBLIC HEALTH 62,250.00 .00 .00 .00 .00 CULTURE,RECREATION & EDUCATION 206-55-5520-000 RECREATION 45,000.00 .00 .00 .00 .00 OTHER FINANCING USES 206-59-5900-100 TRANSFERS OUT TO 100 .00 9,234.48 .00 63,541.87 .00 206-59-5900-401 TRANSFERS OUT TO 401 .00 .00 107,743.68 .00 50,000.00 ARPA FUND Revenue Total: 110,832.37 10,610.05 109,043.68 .00 50,000.00 ARPA FUND Expenditure Total: 110,832.37 10,610.05 109,043.68 63,541.87 50,000.00 Net Total ARPA FUND: .00 .00 .00 63,541.87- .00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 16 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget DEBT SERVICE FUND SOURCE: 48 301-48-4820-000 PREMIUM ON LONG TERM DEBT .00 22,963.00 .00 .00 .00 Total SOURCE: 48: .00 22,963.00 .00 .00 .00 OTHER FINANCING SOURCES 301-49-4900-100 TRANSFER IN FROM GENERAL FUND 148,655.81 148,655.81 220,561.64 220,561.64 205,700.00 301-49-4900-500 BOND PROCEEDS .00 1,044,999.52 .00 .00 .00 Total OTHER FINANCING SOURCES: 148,655.81 1,193,655.33 220,561.64 220,561.64 205,700.00 GENERAL GOVERMENT 301-51-5157-210 INDEPENDENT AUDITING 500.00 500.00 500.00 .00 .00 COST CATEGORY: 57 301-57-5711-521 BOND ISSUANCE EXPENSE .00 37,862.42 .00 .00 .00 DEBT SERVICE 301-58-5811-610 STFL 2018 $557,000 PRINCIPAL 19,591.85 444,926.97 .00 .00 .00 301-58-5811-620 STFL 2018 $557,000 INTEREST 20,021.71 24,833.59 .00 .00 .00 301-58-5820-610 $527,000 PRINC CITY SHARE 52% 6,307.17 6,378.92 6,594.19 6,594.19 .00 301-58-5820-620 $527,000 INT CITY SHARE 52% 8,529.47 8,457.72 8,242.45 8,242.45 .00 301-58-5827-610 STFL 2020 $150,000 PRINCIPLE 15,234.94 136,667.54 .00 .00 .00 301-58-5827-620 STFL 2020 $150,000 INTEREST 4,441.70 5,079.64 .00 .00 .00 301-58-5828-610 STFL 2021 $560,000 PRIN 68.68% 14,058.10 384,608.00 .00 .00 .00 301-58-5828-620 STFL 2021 $560,000 INT 68.68% 14,162.00 16,557.89 .00 .00 .00 301-58-5829-610 STFL 2021 $127,225 PRINCIPLE 24,404.87 127,225.00 .00 .00 .00 301-58-5829-620 STFL 2021 $127,225 INTEREST 2,927.92 3,343.43 .00 .00 .00 301-58-5830-610 STFL 2021 $86,000 PRINCIPLE 16,496.90 .00 .00 .00 .00 301-58-5830-620 STFL 2021 $86,000 INTEREST 1,979.18 0.05 .00 .00 .00 301-58-5831-610 2022 REFINANCE BOND $435 - PRI .00 .00 25,000.00 25,000.00 25,000.00 301-58-5831-620 2022 REFINANCE BOND $435 - INT .00 .00 17,170.00 17,170.00 11,925.00 301-58-5832-610 2022 REFINANCE BOND $125 - PRI .00 .00 15,000.00 15,000.00 15,000.00 301-58-5832-620 2022 REFINANCE BOND $125 - INT .00 .00 4,816.67 4,816.67 3,075.00 301-58-5833-610 2022 REFINANCE BOND $380 - PRI .00 .00 10,000.00 10,000.00 10,000.00 301-58-5833-620 2022 REFINANCE BOND $380 - INT .00 .00 15,176.67 15,176.67 10,950.00 301-58-5834-610 2022 REFINANCE BOND $105 - PRI .00 .00 25,000.00 25,000.00 25,000.00 301-58-5834-620 2022 REFINANCE BOND $105 - INT .00 .00 3,860.00 3,860.00 2,025.00 301-58-5835-610 2022 REFINANCE BOND $70 - PRI .00 .00 10,000.00 10,000.00 20,000.00 301-58-5835-620 2022 REFINANCE BOND $70 - INT .00 .00 2,673.33 2,673.33 1,500.00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 17 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 301-58-5836-610 2022 REFINANCE BOND $310 - PRI .00 .00 65,000.00 65,000.00 75,000.00 301-58-5836-620 2022 REFINANCE BOND $310 - INT .00 .00 11,528.33 11,528.33 6,225.00 301-58-5837-610 ERGO 39,293.62 PRINCIPAL A/C .00 .00 .00 .00 .00 301-58-5837-620 ERGO 39,293.62 INTEREST AC/HTG .00 .00 .00 .00 .00 DEBT SERVICE FUND Revenue Total: 148,655.81 1,216,618.33 220,561.64 220,561.64 205,700.00 DEBT SERVICE FUND Expenditure Total: 148,655.81 1,196,441.17 220,561.64 220,061.64 205,700.00 Net Total DEBT SERVICE FUND: .00 20,177.16 .00 500.00 .00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 18 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget CAPITAL IMPROVEMENTS FUND MISCELLANEOUS REVENUE 400-48-4850-000 MISCELLANEOUS REVENUES .00 15,301.00 .00 31,759.51 .00 400-48-4851-704 GRANT-CDBG-PF-2020 .00 53,620.00 .00 .00 .00 Total MISCELLANEOUS REVENUE: .00 68,921.00 .00 31,759.51 .00 OTHER FINANCING SOURCES 400-49-4900-100 FUNDS APPLIED .00 .00 57,421.00 .00 10,000.00 400-49-4900-101 LOAN PROCEEDS 305,000.00 .00 .00 39,293.62 125,605.00 400-49-4900-150 BOND PROCEEDS .00 309,999.86 .00 .00 .00 400-49-4900-204 TRANSFER IN FROM GENERAL FUND 63,660.00 63,660.00 .00 .00 8,130.00 400-49-4900-206 TRANSFERS IN FROM ARPA FUND .00 450.00 .00 .00 .00 Total OTHER FINANCING SOURCES: 368,660.00 374,109.86 57,421.00 39,293.62 143,735.00 GENERAL GOVERMENT 400-51-5120-820 MUNICIPAL COURT-CAPITAL IMPROV .00 2,695.00 .00 .00 .00 400-51-5140-810 MSA ADMINISTRATIVE COSTS .00 .00 .00 682.50 .00 400-51-5162-810 OTHER MUNI BLDG-CAPITAL EQUIPM 9,824.00 11,500.00 .00 3,462.00 .00 400-51-5162-820 OTHER MUNI BLDG-CAPITAL IMPROV .00 .00 11,200.00 .00 25,000.00 400-51-5171-820 MUNI BLDG-CAPITAL IMPROVEMENT .00 5,260.00 3,100.00 .00 .00 PUBLIC SAFTEY 400-52-5211-810 POLICE PATROL-CAPITAL EQUIPMT 5,600.00 1,797.00 5,500.00 16,191.60- .00 400-52-5232-810 FIRE SUPPRESSION-CAPITAL EQUIP 8,652.00 8,651.80 .00 .00 .00 400-52-5262-810 MUNI BLDG-CAPITAL EQUIPMENT .00 .00 .00 39,293.62 .00 PUBLIC WORKS 400-53-5323-810 GARAGE-CAPITAL EQUIPMENT .00 649.00 .00 19.50- .00 400-53-5324-810 MACH/EQUIP-CAPITAL EQUIPMENT 24,111.00 24,270.00 6,600.00 5,800.00 .00 400-53-5330-820 STREETS/ALLEYS-CAPITAL IMPROV 285,350.00 172,179.27 .00 8,911.71 .00 400-53-5330-850 GREEN ST-CAPITAL IMPROVEMENTS .00 41,097.31 .00 .00 .00 400-53-5334-810 SNOW/ICE REMOVAL-CAPITAL EQUIP .00 .00 10,000.00 .00 10,000.00 400-53-5344-820 STORM SEWER-CAPITAL IMPROVEME .00 1,413.92 .00 .00 .00 400-53-5344-825 STORM SEWER-CAPITAL IMPV-ARPA .00 450.00 .00 .00 .00 400-53-5424-850 GREEN ST-ENGINEERING .00 9,624.92 .00 1,882.50 .00 CULTURE,RECREATION & EDUCATION 400-55-5511-810 LIBRARY-CAPITAL EQUIPMENT 4,000.00 3,164.71 .00 .00 1,000.00 400-55-5511-820 LIBRARY-CAPITAL IMPROVEMENT 1,500.00 2,678.42 10,200.00 10,241.40 7,130.00 400-55-5520-810 PARKS-CAPITAL EQUIPMENT 6,000.00 5,847.73 .00 .00 .00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 19 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 400-55-5520-820 PARKS-CAPITAL IMPROVEMENT .00 12,026.00 4,800.00 4,750.00 .00 400-55-5542-810 SWIMMING POOL-CAPITAL EQUIPME 21,323.00 21,667.82 .00 .00 .00 400-55-5542-820 SWIMMING POOL-CAPITAL IMPROVE 2,300.00 .00 6,021.00 6,021.45 .00 CONSERVATION & DEVELOPMENT 400-56-5364-810 WEED CONTROL-CAPITAL EQUIPMEN .00 2,300.00 .00 .00 .00 DEBT SERVICE 400-58-5810-610 PRINCIPLE - SHORT TERM LOAN .00 .00 .00 .00 97,762.00 400-58-5810-620 INTEREST - SHORT TERM LOAN .00 683.40 .00 .00 2,843.00 CAPITAL IMPROVEMENTS FUND Revenue Total: 368,660.00 443,030.86 57,421.00 71,053.13 143,735.00 CAPITAL IMPROVEMENTS FUND Expenditure Total: 368,660.00 327,956.30 57,421.00 64,834.08 143,735.00 Net Total CAPITAL IMPROVEMENTS FUND: .00 115,074.56 .00 6,219.05 .00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 20 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget TIF #2 CAPITAL PROJECTS FUND TIF #2 INCREMENT 401-41-4112-000 TIF #2 INCREMENT 198,167.00 198,167.39 275,345.00 .00 351,121.00 Total TIF #2 INCREMENT: 198,167.00 198,167.39 275,345.00 .00 351,121.00 INTERGOVERNMENTAL REVENUES 401-42-4250-000 STATE AID-EXEMPT COMPUTERS "T" 2,382.39 2,382.39 2,382.39 2,382.39 2,382.00 401-42-4259-000 STATE AID-OTHER GRANTS 2,692.18 2,692.18 2,692.18 2,692.18 2,692.00 Total INTERGOVERNMENTAL REVENUES: 5,074.57 5,074.57 5,074.57 5,074.57 5,074.00 MISCELLANEOUS REVENUE 401-48-4820-000 PREMIUM ON LONG TERM DEBT .00 11,974.70 .00 .00 .00 401-48-4851-702 GRANTS-DEPT NATURAL RESOURCE .00 .00 314,166.00 .00 314,166.00 Total MISCELLANEOUS REVENUE: .00 11,974.70 314,166.00 .00 314,166.00 OTHER FINANCING SOURCES 401-49-4900-500 BOND PROCEEDS .00 1,010,000.48 .00 .00 .00 401-49-4910-000 LOAN PROCEEDS .00 .00 423,642.00 200,000.00 250,000.00 401-49-4920-100 TRANSFERS IN FROM GENERAL FUN .00 .00 64,700.00 .00 30,000.00 401-49-4920-206 TRANSFERS IN FROM ARPA .00 .00 107,743.68 .00 50,000.00 Total OTHER FINANCING SOURCES: .00 1,010,000.48 596,085.68 200,000.00 330,000.00 GENERAL GOVERMENT 401-51-5140-120 ADMIN/OFFICE-WAGES 15,408.00 16,941.39 16,065.00 15,847.00 18,317.00 401-51-5140-130 ADMIN/OFFICE-FICA 1,179.00 1,293.02 1,229.00 1,239.39 1,401.00 401-51-5140-135 ADMIN/OFFICE-WIS RET FUND 1,002.00 1,098.01 1,092.00 1,092.36 1,264.00 401-51-5140-140 ADMIN/OFFICE-INSURANCES 2,537.00 2,587.11 2,648.00 2,501.29 3,081.00 401-51-5140-310 ADMINISTRATIVE EXPENSE 10,000.00 7,682.61 1,000.00 4,262.32 1,000.00 401-51-5157-210 INDEPENDENT AUDITING 2,000.00 2,210.00 2,000.00 5,173.60 5,000.00 PUBLIC WORKS 401-53-5330-800 ROAD IMPROVEMENTS .00 .00 258,370.00 218.59 .00 401-53-5330-900 PARKING LOT IMPROVEMENT .00 .00 23,500.00 9,791.00 .00 401-53-5424-820 ENGINEERING-STREETS .00 .00 .00 15,252.27 5,000.00 401-53-5429-290 ENGINEERING-OTHER .00 554.50 .00 2,431.15 .00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 21 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget CAPITAL OUTLAY 401-57-5700-792 DOWNTOWN BUSINESS SUPPORT PR .00 7,520.00 .00 .00 .00 401-57-5700-794 CLAUSEN PARK IMPROVEMENTS .00 .00 628,332.00 .00 800,000.00 401-57-5710-820 TIF #2 EXPENDITURES .00 .00 10,000.00 3,150.00 10,000.00 401-57-5711-521 BOND ISSUANCE EXPENSE .00 28,222.42 .00 .00 .00 DEBT SERVICE 401-58-5810-610 STFL $390,000 PRINCIPAL 16,213.11 454,196.40 .00 .00 .00 401-58-5820-620 STFL $390,000 INTEREST 16,569.84 19,129.16 .00 .00 .00 401-58-5821-610 2022 REFINANCE BOND $360 - PRI .00 .00 10,000.00 10,000.00 20,000.00 401-58-5821-620 2022 REFINANCE BOND $360 - INT .00 .00 14,370.00 14,370.00 10,200.00 401-58-5830-610 STFL $800,000 PRI TIF#2 SHARE 23,505.41 588,934.33 .00 .00 .00 401-58-5830-620 STFL $800,000 INT TIF#2 SHARE 23,505.41 29,760.75 .00 .00 .00 401-58-5831-610 2022 REFINANCE BOND $580 - PRI .00 .00 25,000.00 25,000.00 25,000.00 401-58-5831-620 2022 REFINANCE BOND $580 - INT .00 .00 23,018.33 23,018.33 16,275.00 401-58-5840-620 STFL $86,000 INTEREST .00 2,260.00 .00 .00 .00 TIF #2 CAPITAL PROJECTS FUND Revenue Total: 203,241.57 1,225,217.14 1,190,671.25 205,074.57 1,000,361.00 TIF #2 CAPITAL PROJECTS FUND Expenditure Total: 111,919.77 1,162,389.70 1,016,624.33 133,347.30 916,538.00 Net Total TIF #2 CAPITAL PROJECTS FUND: 91,321.80 62,827.44 174,046.92 71,727.27 83,823.00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 22 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget TIF #3 FUND TAXES 402-41-4112-000 TIF #3 INCREMENT 102,733.00 102,733.33 119,178.00 .00 195,236.00 Total TAXES: 102,733.00 102,733.33 119,178.00 .00 195,236.00 MISCELLANEOUS REVENUE 402-48-4810-000 INTEREST 15.00 160.53 15.00 .00 15.00 402-48-4820-000 PREMIUM ON LONG TERM DEBT .00 2,887.35 .00 .00 .00 Total MISCELLANEOUS REVENUE: 15.00 3,047.88 15.00 .00 15.00 OTHER FINANCING SOURCES 402-49-4900-500 BOND PROCEEDS .00 180,000.46 .00 .00 .00 402-49-4910-000 LOAN PROCEEDS .00 1,522,650.00 .00 80,000.00 .00 Total OTHER FINANCING SOURCES: .00 1,702,650.46 .00 80,000.00 .00 GENERAL GOVERMENT 402-51-5140-120 ADMIN/OFFICE-WAGES 15,408.00 16,936.95 16,065.00 15,847.00 18,317.00 402-51-5140-130 ADMIN/OFFICE-FICA 1,179.00 1,292.67 1,229.00 1,239.39 1,401.00 402-51-5140-135 ADMIN/OFFICE-WIS RET FUND 1,002.00 1,097.71 1,092.00 1,092.36 1,264.00 402-51-5140-140 ADMIN/OFFICE-INSURANCES 2,537.00 2,585.12 2,648.00 2,501.29 3,081.00 402-51-5140-310 ADMINISTRATIVE EXPENSE 50,000.00 2,037.55 5,000.00 2,880.59 5,000.00 402-51-5157-210 INDEPENDENT AUDITING 2,000.00 2,210.00 2,000.00 5,173.60 5,000.00 PUBLIC WORKS 402-53-5424-820 ENGINEERING - STREETS .00 2,873.70 .00 .00 .00 TIF #3 CAPITAL PROJECTS 402-57-5700-793 DOLLAR GENERAL INCENTIVE 2,225.04 2,225.04 .00 .00 .00 402-57-5700-794 VALIDO HOMES INCENTIVE 100,000.00 40,000.00 60,000.00 60,000.00 .00 402-57-5700-795 TIF #3 LAND PURCHASES .00 1,522,780.45 .00 .00 .00 402-57-5700-796 BRYAN YOHN INCENTIVE .00 .00 .00 20,000.00 .00 402-57-5710-310 ADMINISTRATIVE EXPENSE .00 3,278.64 1,000.00 4,350.00 1,000.00 402-57-5711-521 BOND ISSUANCE EXPENSE .00 5,030.10 .00 .00 .00 DEBT SERVICE 402-58-5810-610 INTEREST SHORT TERM LOAN .00 18,876.69 .00 .00 .00 402-58-5820-610 ERGO BANK PRINCIPAL 1.2M .00 .00 .00 .00 .00 402-58-5820-620 ERGO BANK INTEREST 1.2M .00 44,026.00 .00 .00 .00 402-58-5820-630 INTEREST ON TIF ADVANCE .00 18,665.00 .00 .00 .00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 23 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 402-58-5830-610 STFL $800,000 PRI TIF#3 SHARE 7,576.13 189,821.87 .00 .00 .00 402-58-5830-620 STFL $800,000 INT TIF#3 SHARE 7,118.32 3,974.75 .00 .00 .00 402-58-5831-610 2022 REFINANCE BOND $180 - PRI .00 .00 10,000.00 10,000.00 10,000.00 402-58-5831-620 2022 REFINANCE BOND $180 - INT .00 .00 7,110.00 7,110.00 4,950.00 402-58-5832-610 ERGO BANK PRINCIPAL 1.5M .00 12,048.03 50,027.98 50,027.98 52,016.00 402-58-5832-620 ERGO BANK INTEREST 1.5M .00 16,311.13 63,408.66 63,408.66 61,421.00 402-58-5833-610 BCPL PRINCIPAL TID #3 $80,000 .00 .00 .00 .00 7,649.00 402-58-5833-620 BCPL INTEREST TID #3 $80,000 .00 .00 .00 .00 2,532.00 OTHER FINANCING USES 402-59-5900-205 TRANSFER OUT TO 205 88,973.20 0.20 88,963.20 88,963.20 88,963.00 TIF #3 FUND Revenue Total: 102,748.00 1,808,431.67 119,193.00 80,000.00 195,251.00 TIF #3 FUND Expenditure Total: 278,018.69 1,906,071.60 308,543.84 332,594.07 262,594.00 Net Total TIF #3 FUND: 175,270.69- 97,639.93- 189,350.84- 252,594.07- 67,343.00- CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 24 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget CAP PROJ-RURAL DEV GRANT FUND MISCELLANEOUS REVENUE 404-48-4800-000 TRANSFER IN .00 14,837.00 .00 .00 .00 Total MISCELLANEOUS REVENUE: .00 14,837.00 .00 .00 .00 CAPITAL OUTLAY 404-57-5711-620 INTEREST EXPENSE .00 8,458.00 .00 .00 .00 CAP PROJ-RURAL DEV GRANT FUND Revenue Total: .00 14,837.00 .00 .00 .00 CAP PROJ-RURAL DEV GRANT FUND Expenditure Total: .00 8,458.00 .00 .00 .00 Net Total CAP PROJ-RURAL DEV GRANT FUND: .00 6,379.00 .00 .00 .00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 25 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget WATER DEPARTMENT FUND WATER SALES REVENUE 610-41-4190-000 INTEREST AND FISCAL CHARGES 65.00 6,252.12 250.00 6,441.97 250.00 610-41-4610-000 RESIDENTIAL REVENUE 181,000.00 178,606.63 181,000.00 169,433.25 195,480.00 610-41-4612-000 COMMERCIAL REVENUE 25,700.00 25,369.36 25,700.00 23,619.55 27,756.00 610-41-4612-100 MULTI FAMILY REVENUE 14,600.00 16,090.25 16,000.00 15,635.20 17,280.00 610-41-4613-000 INDUSTRIAL REVENUE 48,500.00 30,396.10 31,000.00 33,869.86 33,480.00 610-41-4614-000 PUBLIC AUTHORITY REVENUE 7,495.00 8,027.84 8,900.00 8,091.15 9,612.00 610-41-4620-000 PRIVATE FIRE PROTECTION 5,600.00 5,592.00 5,600.00 4,194.00 6,048.00 610-41-4630-000 PUBLIC FIRE PROTECTION 139,389.00 139,389.00 139,500.00 145,723.67 150,660.00 610-41-4700-000 WATER PENALTIES 500.00 924.07 500.00 1,033.56 500.00 610-41-4740-000 MISC. OPERATING REVENUES 100.00 1,448.00 100.00 59.00 100.00 610-41-4750-000 WATER CONNECTION CHARGES .00 6,000.00 .00 7,000.00 .00 Total WATER SALES REVENUE: 422,949.00 418,095.37 408,550.00 415,101.21 441,166.00 OTHER FINANCING SOURCES 610-49-4900-150 BOND PROCEEDS .00 .00 .00 .00 .00 Total OTHER FINANCING SOURCES: .00 .00 .00 .00 .00 PUBLIC WORKS 610-53-0403-000 DEPRECIATION EXPENSE 77,500.00 86,145.00 83,000.00 .00 83,000.00 610-53-0403-001 DEPRECIATION EXPENSE-CIAC 27,000.00 28,355.00 28,000.00 .00 28,000.00 610-53-0408-000 WATER DEPARTMENT-FICA 6,093.00 6,410.14 6,630.00 7,028.24 8,439.00 610-53-0408-100 WATER DEPARTMENT-TAX EQUIVALE 76,500.00 67,794.04 76,500.00 76,016.04 76,500.00 610-53-0427-000 INTEREST ON LONG TERM DEBT 10,702.24 9,932.47 9,206.66 9,206.66 5,400.00 610-53-0600-000 WATER DEPARTMENT-WAGES 60,068.00 65,241.87 66,821.00 66,648.13 86,530.00 610-53-0600-125 WATER DEPARTMENT-VAC PAYOUT .00 1,126.62 551.00 2,181.75 1,000.00 610-53-0600-140 WATER DEPARTMENT-INSURANCE .00 2,717.95 .00 23,518.54 .00 610-53-0620-000 PURCHASED POWER - ALLIANT 9,500.00 11,732.11 12,182.00 12,880.77 13,644.00 610-53-0630-000 CHEMICALS 10,000.00 13,679.06 10,000.00 15,176.08 15,000.00 610-53-0640-000 OPERATING SUPPLIES & EXPENSE 12,500.00 13,209.71 10,000.00 10,278.67 10,000.00 610-53-0640-220 UTILITY SERVICES 1,000.00 3,685.97 40,000.00 9,953.77 10,000.00 610-53-0640-341 WATER - TOOL RELACEMENT .00 .00 .00 .00 750.00 610-53-0650-000 REPAIR TO WATER PLANT 26,000.00 42,559.96 26,000.00 11,021.90 25,000.00 610-53-0660-000 TRANSPORTATION EXPENSE 5,800.00 3,667.50 3,000.00 4,112.40 3,000.00 610-53-0670-000 WATER DEPARTMENT-CAPITAL EQUIP 6,000.00 0.08- 10,000.00 3,395.33- 10,000.00 610-53-0670-100 WATER DEPTARTMENT-CAPITAL IMPR 36,000.00 19,089.08 12,600.00 3,395.33 10,000.00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 26 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 610-53-0680-000 WATER DEPARTMENT-ADMIN SALARY 19,580.00 17,852.48 19,841.00 21,160.14 23,781.00 610-53-0680-140 WATER DEPARTMENT-ADMIN INSURA .00 381.12 .00 2,950.37 .00 610-53-0681-000 OFFICE SUPPLIES & EXPENSE 3,500.00 4,268.53 3,500.00 4,717.61 3,500.00 610-53-0682-000 OUTSIDE PROFESSIONAL SERVICES 12,000.00 9,965.40 7,000.00 10,808.71 7,000.00 610-53-0682-100 WATER DEPARTMENT-COMPUTER SU 5,000.00 5,580.08 5,600.00 5,982.96 5,600.00 610-53-0682-200 INDEPENDENT AUDITING 8,000.00 12,299.50 10,000.00 14,168.10 12,000.00 610-53-0683-000 CELL PHONE & ALARM CHARGES 950.00 516.80 550.00 464.28 550.00 610-53-0684-000 INSURANCE EXPENSE 12,483.00 10,844.20 12,922.00 12,221.54 14,214.00 610-53-0686-000 EMP PENSION/HEALTH/LIFE WATER 30,927.00 21,666.63 32,991.00 6,000.83 38,718.00 610-53-0686-100 WORKERS COMPENSATION INSURAN 1,526.00 1,418.20 1,417.00 1,494.45 1,559.00 610-53-0686-200 WATER DEPT EDUCATION-TRAINING 800.00 741.78 800.00 .00 800.00 610-53-0688-000 REGULATORY COMMISSION EXPENS 125.00 540.50 540.00 595.19 15,000.00 610-53-0689-000 MISCELLANEOUS GENERAL EXPENS 390.00 1,050.00 410.00 660.00 500.00 610-53-0689-100 WATER DEPARTMENT-UNIFORM ALL 350.00 365.03 500.00 425.74 .00 610-53-0690-000 BOND ISSUANCE EXPENSE .00 6,846.63 .00 .00 .00 DEBT SERVICE 610-58-5917-610 PRINCIPAL DEBT SERVICE 30,670.85 .00 .00 .00 40,000.00 WATER DEPARTMENT FUND Revenue Total: 422,949.00 418,095.37 408,550.00 415,101.21 441,166.00 WATER DEPARTMENT FUND Expenditure Total: 490,965.09 469,683.28 490,561.66 329,672.87 549,485.00 Net Total WATER DEPARTMENT FUND: 68,016.09- 51,587.91- 82,011.66- 85,428.34 108,319.00- CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 27 Period: 01/24 Dec 21, 2023 03:12PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget SEWER DEPARTMENT FUND SEWER SALES REVENUE 620-41-4190-000 INTEREST AND FISCAL CHARGES 36.00 5,096.60 350.00 12,185.39 350.00 620-41-4210-000 RESIDENTIAL REVENUE 380,000.00 402,625.53 403,000.00 389,720.30 419,120.00 620-41-4220-000 COMMERCIAL REVENUE 92,200.00 97,078.83 96,000.00 96,976.96 99,840.00 620-41-4230-000 INDUSTRIAL REVENUE 212,700.00 121,749.57 121,000.00 158,082.96 125,840.00 620-41-4240-000 PUBLIC AUTHORITY REVENUE 9,500.00 9,198.86 9,106.00 8,804.52 9,470.00 620-41-6320-000 SEWER PENALTIES 1,500.00 1,684.24 1,500.00 2,079.14 1,560.00 620-41-6340-000 MISC. OPERATING REVENUES 9,500.00 16,551.80 9,500.00 6,222.50 9,880.00 620-41-6350-000 SEWER CONNECTION CHARGES .00 4,000.00 .00 6,750.00 .00 Total SEWER SALES REVENUE: 705,436.00 657,985.43 640,456.00 680,821.77 666,060.00 OTHER FINANCING SOURCES 620-49-4900-150 BOND PROCEEDS .00 .00 .00 .00 .00 Total OTHER FINANCING SOURCES: .00 .00 .00 .00 .00 PUBLIC WORKS 620-53-0082-000 SEWER DEPARTMENT-WAGES 65,866.00 62,278.35 73,317.00 65,596.27 93,300.00 620-53-0082-125 SEWER DEPARTMENT-VAC PAYOUT .00 2,861.37 551.00 1,101.20 1,000.00 620-53-0082-140 SEWER DEPARTMENT - INSURANCE .00 2,878.94 .00 22,663.55 .00 620-53-0403-000 DEPRECIATION EXPENSE 160,000.00 170,626.00 165,000.00 .00 165,000.00 620-53-0408-000 SEWER DEPARTMENT-FICA 6,537.00 6,320.08 7,127.00 6,863.59 8,957.00 620-53-0427-000 INTEREST ON LONG TERM DEBT 38,076.57 38,384.15 37,589.07 37,589.07 43,077.00 620-53-0429-000 INCOME FROM JOINT VENTURE .00 23,423.00 .00 .00 .00 620-53-0620-000 PURCHASED POWER - ALLIANT 16,300.00 17,686.95 19,025.00 16,783.90 20,927.00 620-53-0826-000 CELL PHONE & ALARM CHARGES 1,000.00 895.64 1,000.00 464.23 1,000.00 620-53-0827-000 OPERATING SUPPLIES & EXPENSE 1,400.00 19,632.89 7,000.00 14,032.42 12,000.00 620-53-0827-220 UTILITY SERVICES 2,500.00 1,161.13 1,200.00 2,556.73 2,000.00 620-53-0827-341 SEWER - TOOL REPLACEMENT .00 .00 .00 .00 750.00 620-53-0828-000 TRANSPORTATION EXPENSE 3,500.00 4,081.50 3,500.00 3,303.11 3,500.00 620-53-0829-000 SEWER DEPARTMENT-CAPITAL EQUI .00 .00 10,000.00 .00 10,000.00 620-53-0829-100 SEWER DEPARTMENT-CAPITAL IMPR 15,000.00 14,738.00 23,500.00 18,712.15 23,500.00 620-53-0831-000 MAINT OF SEWERAGE COLL SYSTEM 6,000.00 7,456.96 6,000.00 .00 6,000.00 620-53-0832-000 MAINT OF PUMP STATION EQUIP 8,000.00 6,169.00 23,000.00 11,152.20 23,000.00 620-53-0833-000 MAINT OF CHALET GRINDER PUMP 1,000.00 .00 1,000.00 .00 1,000.00 620-53-0834-000 MAINT/REPAIR BLDGS & GROUNDS 3,800.00 3,203.70 3,800.00 11,183.02 3,800.00 620-53-0850-000 SEWER DEPARTMENT-ADMIN SALARI 19,580.00 17,847.70 19,841.00 21,194.69 23,781.00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 28 Period: 01/24 Dec 21, 2023 03:13PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 620-53-0850-140 SEWER DEPARTMENT- ADMIN INSUR .00 381.08 .00 2,966.66 .00 620-53-0851-000 OFFICE SUPPLIES & EXPENSE 3,500.00 4,268.36 3,500.00 4,119.99 3,500.00 620-53-0851-100 FLWCC BUDGET EXPENSE 120,000.00 139,689.54 165,000.00 183,373.57 170,000.00 620-53-0851-102 FLWCC COPPER SURCHARGE 1,000.00 1,139.92 2,000.00 .00 2,000.00 620-53-0851-103 FLWCC SLUDGE REMOVAL/LINER 56,250.00 19,500.00 19,500.00 26,933.32 22,000.00 620-53-0852-000 OUTSIDE PROFESSIONAL SERVICES 5,000.00 4,737.86 2,500.00 2,062.45 2,500.00 620-53-0852-100 SEWER DEPARTMENT-COMPUTER S 5,500.00 5,579.94 5,600.00 5,983.10 5,600.00 620-53-0852-200 INDEPENDENT AUDITING 9,000.00 7,687.50 9,000.00 14,168.10 12,000.00 620-53-0853-000 INSURANCE EXPENSE 6,439.00 7,737.66 6,665.00 6,304.14 7,331.00 620-53-0854-000 EMP PENSION/BENEFIT/HEALTH/LIF 31,620.00 20,067.36 33,858.00 5,770.76 39,717.00 620-53-0854-100 WORKERS COMPENSATION INSURAN 1,526.00 1,418.20 1,417.00 1,494.45 1,558.00 620-53-0856-100 SEWER DEPARTMENT-UNIFORM ALL 350.00 365.00 500.00 425.73 500.00 620-53-0857-000 RENT .00 3,264.00 .00 .00 .00 620-53-8860-000 BOND ISSUANCE EXPENSE .00 3,772.44 .00 .00 .00 DEBT SERVICE 620-58-5917-610 PRINCIPAL DEBT SERVICE 42,979.96 .00 38,618.29 .00 56,639.00 SEWER DEPARTMENT FUND Revenue Total: 705,436.00 657,985.43 640,456.00 680,821.77 666,060.00 SEWER DEPARTMENT FUND Expenditure Total: 631,724.53 619,254.22 690,608.36 486,798.40 765,937.00 Net Total SEWER DEPARTMENT FUND: 73,711.47 38,731.21 50,152.36- 194,023.37 99,877.00- CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 29 Period: 01/24 Dec 21, 2023 03:13PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget CEMETERY NONEXP TRUST FUND MISCELLANEOUS REVENUE 701-48-4810-000 INTEREST 750.00 1,171.05 1,000.00 4,490.94 1,000.00 Total MISCELLANEOUS REVENUE: 750.00 1,171.05 1,000.00 4,490.94 1,000.00 DEBT SERVICE 701-58-5800-000 TRANSFER OUT .00 .00 20,000.00 20,000.00 .00 CEMETERY NONEXP TRUST FUND Revenue Total: 750.00 1,171.05 1,000.00 4,490.94 1,000.00 CEMETERY NONEXP TRUST FUND Expenditure Total: .00 .00 20,000.00 20,000.00 .00 Net Total CEMETERY NONEXP TRUST FUND: 750.00 1,171.05 19,000.00- 15,509.06- 1,000.00 CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 30 Period: 01/24 Dec 21, 2023 03:13PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget ROBERTS EXP TRUST FUND MISCELLANEOUS REVENUE 802-48-4810-000 INTEREST 75.00 36.06 35.00 113.56 35.00 Total MISCELLANEOUS REVENUE: 75.00 36.06 35.00 113.56 35.00 OTHER FINANCING USES 802-59-5900-390 MISCELLANEOUS EXPENSE 250.00 .00 250.00 .00 250.00 ROBERTS EXP TRUST FUND Revenue Total: 75.00 36.06 35.00 113.56 35.00 ROBERTS EXP TRUST FUND Expenditure Total: 250.00 .00 250.00 .00 250.00 Net Total ROBERTS EXP TRUST FUND: 175.00- 36.06 215.00- 113.56 215.00- CITY OF FOX LAKE Budget Worksheet - Adopted Budget Page: 31 Period: 01/24 Dec 21, 2023 03:13PM 2022-22 2022-22 2023-23 2023-23 2024-24 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget LIBRARY S/R FUND INTERGOVERNMENTAL REVENUES 804-43-4374-000 HICKS GRANT 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 Total INTERGOVERNMENTAL REVENUES: 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 MISCELLANEOUS REVENUE 804-48-4810-000 INTEREST 15,000.00 11,582.08 15,000.00 1.58 15,000.00 804-48-4850-000 DONATIONS 2,000.00 3,508.00 1,000.00 1,841.50 1,000.00 804-48-4890-000 LIBRARY MISCELLANEOUS REVENUE 500.00 902.23 500.00 1,032.21 500.00 Total MISCELLANEOUS REVENUE: 17,500.00 15,992.31 16,500.00 2,875.29 16,500.00 CULTURE,RECREATION & EDUCATION 804-55-5500-000 LIBRARY EXPENDITURES 5,000.00 14,718.41 5,000.00 8,131.84 5,000.00 LIBRARY S/R FUND Revenue Total: 22,500.00 20,992.31 21,500.00 7,875.29 21,500.00 LIBRARY S/R FUND Expenditure Total: 5,000.00 14,718.41 5,000.00 8,131.84 5,000.00 Net Total LIBRARY S/R FUND: 17,500.00 6,273.90 16,500.00 256.55- 16,500.00 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 All Segments Tested for Total Breaks