Budget 2021 Final 10-30-20.pdf

CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 1 Period: 10/20 Oct 30, 2020 03:00PM 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 2019-19 2019-19 2020-20 2020-20 2021-21 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 830,606.00 830,606.00 838,732.00 838,732.37 805,623.00 100-41-4112-000 MOBILE HOME TAXES 3,000.00 2,134.99 2,200.00 1,526.09 1,700.00 100-41-4131-000 TAX ON UTILITIES 70,000.00 78,488.04 73,304.00 62,216.70 78,500.00 100-41-4180-000 INTEREST & PENALTIES-TAXES 30.38 423.11 .00 .00 .00 Total TAXES: 903,636.38 911,652.14 914,236.00 902,475.16 885,823.00 SPECIAL ASSESSMENTS 100-42-4214-000 GRAVEL, BLACK DIRT, BLACKTOP .00 .00 .00 227.36 .00 Total SPECIAL ASSESSMENTS: .00 .00 .00 227.36 .00 INTERGOVERNMENTAL REVENUES 100-43-4341-000 STATE SHARED TAXES 427,147.00 373,258.50 455,423.00 81,365.34 427,127.00 100-43-4342-000 FIRE INSURANCE TAX FROM STATE 3,600.00 4,000.29 3,600.00 4,029.64 4,000.00 100-43-4344-000 TOWN OF FOX LAKE-DAM WAGES .00 7,065.79 4,140.00 3,105.00 4,140.00 100-43-4352-000 STATE AID-POLICE TRAINING 480.00 640.00 480.00 .00 480.00 100-43-4353-000 STATE AID-ROAD ALLOTMENT 116,242.00 116,242.00 133,678.30 133,678.42 153,730.00 100-43-4355-000 STATE AID-RECYCLE GRANT 8,000.00 8,083.77 8,000.00 8,077.76 8,000.00 100-43-4359-000 STATE AID-OTHER GRANTS 1,000.00 7,064.15 5,600.00 5,675.82 6,933.37 100-43-4361-000 COVID-19 CARES GRANT .00 .00 .00 1,064.60 .00 100-43-4372-000 STATE AID-OTHER GRANTS LIBRARY .00 .00 .00 343.00 .00 Total INTERGOVERNMENTAL REVENUES: 556,469.00 516,354.50 610,921.30 237,339.58 604,410.37 LICENSES & PERMITS 100-44-4411-000 LIQUOR & MALT BEVERAGE LICENSE 2,000.00 2,046.84 2,000.00 584.25 2,000.00 100-44-4412-000 OPERATORS LICENSE 1,000.00 1,020.00 1,000.00 45.00 1,000.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 2 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-44-4413-000 CIGARETTE LICENSE 150.00 300.00 150.00 200.00 200.00 100-44-4415-000 DOG & CAT LICENSES 1,600.00 1,213.17 1,400.00 1,439.31 1,200.00 100-44-4417-000 OTHER LICENSES 85.00 80.00 75.00 75.00 75.00 100-44-4421-000 CABLE TV FRANCHISE FEE 19,000.00 21,697.82 20,000.00 15,422.82 19,600.00 100-44-4431-000 BUILDING PERMITS 5,000.00 21,331.99 6,000.00 9,558.92 6,000.00 100-44-4432-000 ELECTRICAL PERMITS 2,000.00 4,563.95 2,000.00 2,530.16 1,500.00 100-44-4433-000 PLUMBING PERMITS 1,000.00 3,701.60 1,000.00 1,873.52 600.00 Total LICENSES & PERMITS: 31,835.00 55,955.37 33,625.00 31,728.98 32,175.00 FINES & FORFEITURES 100-45-4511-000 COURT PENALTIES & COSTS 20,000.00 23,595.17 30,000.00 12,984.06 25,000.00 100-45-4522-000 JUDGEMENTS & DAMAGES .00 75.68 .00 .00 .00 Total FINES & FORFEITURES: 20,000.00 23,670.85 30,000.00 12,984.06 25,000.00 PUBLIC CHARGES FOR SERVICE 100-46-4612-000 PUBLICATION FEES 200.00 19.80- 200.00 6.33- 100.00 100-46-4613-000 SALE OF MATERIALS & SUPPLIES 200.00 1,980.00 .00 .00 .00 100-46-4614-000 GENERAL GOVERNMENT 2,000.00 1,950.53 2,000.00 2,882.63 2,500.00 100-46-4621-000 POLICE DEPARTMENT FEES 1,000.00 1,182.18 1,000.00 4,953.50 1,500.00 100-46-4631-000 SNOW & ICE CONTROL 1,000.00 450.00 500.00 750.00 500.00 100-46-4641-000 GARBAGE COLLECTION 94,255.00 91,412.25 91,200.00 70,279.74 95,800.00 100-46-4642-000 WEED CONTROL 2,000.00 .00 250.00 .00 150.00 100-46-4651-000 PARKS 150.00 500.00 300.00 150.00 100.00 100-46-4652-000 WATER RECREATION 9,000.00 13,088.22 10,000.00 20,167.59 15,000.00 100-46-4653-000 SWIMMING POOL 15,000.00 18,726.69 16,500.00 6,091.25 16,000.00 100-46-4654-000 COMMUNITY CENTER-RENT 2,500.00 5,780.00 3,250.00 300.00 1,200.00 100-46-4655-000 CEMETERY 6,000.00 8,160.00 6,500.00 2,250.00 3,000.00 100-46-4656-000 SWIMMING POOL-CONCESSIONS .00 1,973.27 2,000.00 .00 1,500.00 100-46-4657-000 LIBRARY 33,702.00 36,792.00 38,138.61 37,477.94 33,535.00 100-46-4690-000 OTHER REVENUE 3,000.00 8,637.59 3,000.00 3,699.56 4,000.00 Total PUBLIC CHARGES FOR SERVICE: 170,007.00 190,612.93 174,838.61 148,995.88 174,885.00 INTERDEPARTMENTAL CHARGES 100-47-4721-000 SANITATION SERVICES 500.00 853.10 500.00 1,158.49 800.00 Total INTERDEPARTMENTAL CHARGES: 500.00 853.10 500.00 1,158.49 800.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 3 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget MISCELLANEOUS REVENUE 100-48-4811-000 INTEREST ON TEMP . INVESTMENTS 2,600.00 11,882.90 5,000.00 3,296.67 4,000.00 100-48-4815-000 INTEREST ON TIF ADVANCE .00 3,645.00 .00 .00 .00 100-48-4821-000 RENT OF CITY OWNED LAND 200.00 200.00 200.00 200.00 200.00 100-48-4831-000 SALE OF CITY PROPERTY .00 667.92 .00 .00 .00 100-48-4832-000 SALE OF RECYCLABLES .00 51.70 .00 .00 .00 100-48-4840-000 INSURANCE RECOVERIES .00 2,711.40 .00 .00 .00 100-48-4851-000 DONATIONS 2,500.00 22,908.89 2,500.00 3,365.50 3,000.00 100-48-4891-000 FIRE ASSOC SERVICE AWARD PROG .00 .00 .00 .00 .00 Total MISCELLANEOUS REVENUE: 5,300.00 42,067.81 7,700.00 6,862.17 7,200.00 OTHER FINANCING SOURCES 100-49-4900-400 TRANSFER IN FROM CAP . IMP FUND .00 .00 .00 500.00 .00 100-49-4930-000 FUNDS APPLIED 75,000.00 .00 94,253.25 .00 150,425.22 Total OTHER FINANCING SOURCES: 75,000.00 .00 94,253.25 500.00 150,425.22 GENERAL GOVERMENT 100-51-5110-120 COUNCIL-WAGES 21,900.00 21,800.00 24,090.00 18,289.91 29,100.00 100-51-5110-130 COUNCIL-FICA 1,675.00 1,528.07 1,951.00 1,538.76 2,226.00 100-51-5110-320 COUNCIL-PUB/SUB/DUES 580.00 638.77 630.00 630.09 608.55 100-51-5110-330 COUNCIL-TRAVEL 100.00 113.68 100.00 .00 100.00 100-51-5110-390 COUNCIL-OTHER SUPPLIES 500.00 247.15 100.00 .00 100.00 100-51-5120-120 MUNICIPAL COURT-WAGES 9,000.00 9,678.60 12,748.00 5,786.20 13,526.00 100-51-5120-125 MUNICIPAL COURT-VAC PAYOUT 101.78 .00 .00 .00 .00 100-51-5120-130 MUNICIPAL COURT-FICA 933.00 728.29 975.00 454.84 1,035.00 100-51-5120-135 MUNICIPAL COURT-WI RET FUND 579.00 439.45 579.00 401.31 686.00 100-51-5120-220 MUNICIPAL COURT-UTILITIES 700.00 624.13 700.00 169.69 525.00 100-51-5120-311 MUNICIPAL COURT-COMPUTER SUPP 4,200.00 7,229.14 7,000.00 6,619.32 7,250.00 100-51-5120-320 MUNICIPAL COURT-PUB/SUB/DUES 140.00 845.00 845.00 845.00 845.00 100-51-5120-330 MUNICIPAL COURT-TRAVEL 350.00 412.24 700.00 255.28 425.00 100-51-5120-390 MUNICIPAL COURT-OTHER SUPPLIES 1,600.00 2,260.53 1,000.00 441.25 1,000.00 100-51-5140-210 ADMINISTRATOR-PROF SERVICES 28,000.00 27,745.41 28,000.00 25,665.36 30,000.00 100-51-5140-310 ADMINISTRATOR-OFFICE EXPENSE 1,000.00 1,220.94 1,000.00 2,111.66 1,500.00 100-51-5140-311 ADMINISTRATOR-COMPUTER SUP/EX 4,000.00 5,288.91 4,400.00 2,384.05 2,750.00 100-51-5140-320 ADMINISTRATOR-PUB/SUB/DUES 200.00 66.00 .00 66.00 66.00 100-51-5140-330 ADMINISTRATOR-TRAVEL 200.00 .00 200.00 .00 200.00 100-51-5140-331 ADMINISTRATOR-TRAINING 300.00 .00 .00 .00 .00 100-51-5140-390 ADMINISTRATOR-OTHER EXPENSES .00 75.00 530.00 105.11 200.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 4 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-51-5141-120 MAYOR-WAGES 6,000.00 5,950.00 6,830.00 5,129.97 7,200.00 100-51-5141-130 MAYOR-FICA 459.00 416.93 551.00 430.69 551.00 100-51-5141-390 MAYOR-EXPENSES 700.00 812.10 700.00 205.65 700.00 100-51-5142-120 CLERK-WAGES 34,217.00 37,837.28 34,905.00 39,503.99 31,240.00 100-51-5142-125 CLERK-VACATION PAYOUT 4,179.81 1,690.96 .00 4,399.76 .00 100-51-5142-130 CLERK-FICA 2,618.00 2,848.47 2,670.00 3,568.60 2,390.00 100-51-5142-135 CLERK-WI RETIREMENT FUND 2,241.00 2,654.83 2,304.00 3,148.63 2,109.00 100-51-5142-140 CLERK-INSURANCES 13,398.00 12,014.97 14,282.00 7,663.86 2,576.00 100-51-5142-310 CLERK-OFFICE EXPENSE 2,900.00 4,011.00 3,400.00 3,322.84 3,400.00 100-51-5142-311 CLERK-COMPUTER SUPPORT/EXPEN 2,080.00 4,789.96 4,000.00 2,713.39 4,000.00 100-51-5142-320 CLERK-PUB/SUB/DUES 2,500.00 1,860.55 2,500.00 1,783.47 2,500.00 100-51-5142-330 CLERK-TRAVEL 425.00 308.59 425.00 48.24 425.00 100-51-5142-331 CLERK-TRAINING 575.00 378.00 575.00 644.00 600.00 100-51-5142-340 CLERK-OPERATING SUPPLIES 150.00 98.59 150.00 183.19 175.00 100-51-5142-390 CLERK-OTHER EXPENSE .00 75.00 .00 .00 .00 100-51-5144-120 ELECTIONS-WAGES 320.00 160.00 680.00 1,929.04 840.00 100-51-5144-130 ELECTIONS-FICA 23.00 12.24 55.00 134.18 64.00 100-51-5144-135 ELECTIONS-WI RETIREMENT FUND 21.00 11.48 .00 118.40 57.00 100-51-5144-140 ELECTIONS-INSURANCES 120.00 .00 .00 251.40 46.00 100-51-5144-310 ELECTIONS-OFFICE EXPENSE .00 .00 .00 97.03 .00 100-51-5144-340 ELECTIONS-OPERATING EXPENSE 2,400.00 1,680.12 5,880.00 3,750.05 2,800.00 100-51-5144-390 ELECTIONS-POLL WORKERS 1,600.00 747.78 4,080.00 2,363.38 1,900.00 100-51-5151-120 TREASURER-WAGES 30,233.00 29,096.82 30,837.00 25,427.56 33,180.00 100-51-5151-130 TREASURER-FICA 2,313.00 2,225.84 2,359.00 2,082.94 2,538.00 100-51-5151-135 TREASURER-WI RETIREMENT FUND 1,980.00 2,074.80 2,035.00 1,837.80 2,233.00 100-51-5151-140 TREASURER-INSURANCES 7,500.00 4,617.98 6,199.00 9,907.93 14,691.00 100-51-5151-310 TREASURER-OFFICE EXPENSE 1,200.00 1,496.96 1,200.00 2,489.46 2,500.00 100-51-5151-311 TREASURER-COMPUTER SUP/EXP 3,100.00 6,246.37 5,500.00 2,847.20 3,500.00 100-51-5151-320 TREASURER-PUB/SUB/DUES 100.00 312.40 120.00 105.00 100.00 100-51-5151-330 TREASURER-TRAVEL 200.00 129.22 200.00 .00 .00 100-51-5151-331 TREASURER-TRAINING 1,500.00 465.70 1,500.00 644.00 1,000.00 100-51-5151-340 TREASURER-OPERATING SUPPLIES 700.00 979.57 500.00 606.91 500.00 100-51-5151-390 TREASURER-OTHER EXPENSE 400.00 .00 100.00 2,093.72 100.00 100-51-5153-120 ASSESS OF PROPERTY-WAGES 200.00 300.00 200.00 150.00 300.00 100-51-5153-130 ASSESS OF PROPERTY-FICA 20.00 22.98 30.00 11.49 19.00 100-51-5153-210 ASSESS OF PROPERTY-PROF SERV 12,650.00 12,622.84 12,200.00 12,200.00 12,900.00 100-51-5153-390 ASSESS OF PROPERTY-OTHER EXP 200.00 97.75 150.00 81.36 100.00 100-51-5157-210 INDEPENDENT AUDITING-PRO SERVI 32,000.00 34,096.00 25,000.00 37,570.00 30,000.00 100-51-5161-210 ATTORNEY-PROFESSIONAL SERVICE 10,000.00 11,183.00 10,000.00 4,500.00 7,000.00 100-51-5161-290 ATTORNEY-PROSECUTION 3,000.00 1,960.00 2,000.00 490.00 1,000.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 5 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-51-5162-120 OTHER MUNI BLDG-WAGES .00 .00 .00 .00 .00 100-51-5162-220 OTHER MUNI BLDG-UTILITY SERVIC 3,500.00 4,219.19 4,365.00 2,716.38 4,000.00 100-51-5162-350 OTHER MUNI BLDG-REP/MAIN SUPPL .00 858.77 .00 463.97 785.00 100-51-5162-390 OTHER MUNI BLDG-OTHER SUPP/EX 100.00 6,428.64 100.00 107.77 100.00 100-51-5163-210 COD OF ORDIN.-PROFESSIONAL SER .00 .00 .00 .00 2,400.00 100-51-5171-120 MUNI BLDG-WAGES 2,880.00 3,273.30 2,307.00 3,873.98 5,893.00 100-51-5171-130 MUNI BLDG-FICA 220.00 263.00 176.00 296.39 451.00 100-51-5171-135 MUNI BLDG-WI RET FUND 56.00 81.46 170.00 56.38 367.00 100-51-5171-140 MUNI BLDG-INSURANCES 260.00 360.13 1,228.00 300.43 64.00 100-51-5171-210 MUNI BLDG-PROFESSIONAL SERVICE 4,000.00 2,968.89 4,000.00 1,090.21 2,000.00 100-51-5171-220 MUNI BLDG-UTILITY SERVICES 16,000.00 16,412.73 15,000.00 9,824.87 15,000.00 100-51-5171-230 MUNI BLDG-REPAIR/MAIN SERVICES 500.00 93.20 500.00 .00 100.00 100-51-5171-340 MUNI BLDG-OPERATING EXPENSE 1,800.00 1,864.10 1,500.00 712.30 1,500.00 100-51-5171-350 MUNI BLDG-REP/MAIN EXPENSE 1,000.00 1,642.81 1,000.00 341.50 1,300.00 100-51-5171-390 MUNI BLDG-SUPPLIES/EXPENSE 4,000.00 2,236.34 2,000.00 1,343.62 2,000.00 100-51-5194-510 PROPERTY/LIABILITY INSURANCE 34,000.00 26,811.00 34,000.00 34,198.00 47,163.00 100-51-5195-390 UNEMPLOYMENT ASSESSMENT 1,400.00 .00 1,400.00 .00 .00 100-51-5196-510 WORKER'S COMP INSURANCE 16,000.00 14,265.00 16,000.00 10,637.00 26,311.00 PUBLIC SAFTEY 100-52-5210-120 POLICE ADMIN-WAGES 83,921.00 86,266.65 85,591.00 68,990.36 89,625.00 100-52-5210-125 POLICE ADMIN-VACATION PAYOUT 915.97 .00 .00 113.72 .00 100-52-5210-130 POLICE ADMIN-FICA 6,420.00 6,340.92 6,548.00 5,682.66 6,856.00 100-52-5210-135 POLICE ADMIN-WI RET FUND 5,007.00 5,408.50 7,842.00 4,524.91 5,226.00 100-52-5210-140 POLICE ADMIN-INSURANCES 19,048.00 15,135.44 19,525.00 12,062.49 14,439.00 100-52-5210-190 POLICE ADMIN-UNIFORM ALLOWANC 600.00 414.00 600.00 49.99 600.00 100-52-5210-320 POLICE ADMIN -PUB/SUB/DUES 150.00 .00 150.00 .00 150.00 100-52-5210-390 POLICE ADMIN-OTHER SUP/EXPENSE 600.00 193.00 100.00 28.72 100.00 100-52-5211-120 POLICE PATROL-WAGES 115,818.00 93,616.17 123,262.00 87,883.98 132,147.00 100-52-5211-125 POLICE PATROL-VACATION PAYOUT 3,068.52 921.60 .00 1,932.82 .00 100-52-5211-130 POLICE PATROL-FICA 8,860.00 6,895.24 9,430.00 7,322.65 10,109.00 100-52-5211-135 POLICE PATROL-WI RET FUND 2,528.00 10,086.39 9,794.00 10,477.49 13,198.00 100-52-5211-140 POLICE PATROL-INSURANCES 38,491.00 17,095.89 39,407.00 18,846.96 23,559.00 100-52-5211-190 POLICE PATROL-UNIFORM ALLOWAN 1,400.00 921.64 1,400.00 65.98 1,400.00 100-52-5211-210 POLICE PATROL-PROFESSIONAL SER 1,000.00 .00 1,000.00 .00 500.00 100-52-5211-220 POLICE PATROL-TELEPHONE 4,000.00 5,200.05 6,500.00 3,167.97 3,800.00 100-52-5211-230 POLICE PATROL-VEHICLE LEASE .00 5,643.97 5,800.00 4,780.40 5,800.00 100-52-5211-310 POLICE PATROL-OFFICE SUPPL/EXP 4,000.00 1,496.40 2,000.00 964.67 1,000.00 100-52-5211-311 POLICE PATROL-COMPUTER SUPPO 4,000.00 11,595.25 7,800.00 11,092.84 12,000.00 100-52-5211-330 POLICE PATROL-TRAIN/TRAVEL EXP 2,000.00 938.15 1,000.00 671.82 1,000.00 100-52-5211-340 POLICE PATROL-OPERATING SUP/EX 2,000.00 2,020.07 1,000.00 2,338.24 2,200.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 6 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-52-5211-350 POLICE PATROL-REPAIR/MAIN SUPP .00 .00 .00 267.01 100.00 100-52-5211-370 POLICE PATROL-VEH MAINT/REPAIR 3,000.00 3,910.76 2,000.00 673.32 2,000.00 100-52-5211-371 POLICE PATROL-GAS 5,000.00 4,914.05 5,000.00 3,236.60 5,000.00 100-52-5211-390 POLICE PATROL-OTHER SUPP/EXPEN 1,200.00 1,613.89 1,200.00 121.48 1,000.00 100-52-5232-290 FIRE SUPPRESSION-HYDRANT RENT 139,389.00 139,389.00 139,389.00 116,157.50 139,389.00 100-52-5232-390 FIRE SUPPRESSION-OTHER .00 401.72 500.00 1,589.58 1,590.00 100-52-5232-590 FIRE SUPPRESSION-FIRES 1,000.00 1,530.00 1,000.00 1,030.00 1,200.00 100-52-5232-591 FIRE SUPPRESSION-F.A. BUDGET 40,338.00 40,338.00 44,073.00 44,073.00 44,073.00 100-52-5232-592 FIRE SUPPRESSION-2% FIRE DUES 3,400.00 8,174.79 3,400.00 4,029.64 4,060.00 100-52-5241-210 BUILDING INSPECTION-PRO SERVIC 8,000.00 22,336.97 8,000.00 12,574.84 8,000.00 PUBLIC WORKS 100-53-5323-120 GARAGE-WAGES 22,405.00 19,088.94 20,910.00 18,831.46 26,068.00 100-53-5323-125 GARAGE-VACATION PAYOUT 2,550.18 375.53 .00 120.18 6,601.20 100-53-5323-130 GARAGE-FICA 1,507.00 1,423.70 1,660.00 1,515.17 2,500.00 100-53-5323-135 GARAGE-WI RETIREMENT FUND 1,161.00 1,224.60 1,544.00 1,336.96 2,105.00 100-53-5323-140 GARAGE-INSURANCES 6,821.00 5,066.82 11,134.00 6,330.57 9,457.00 100-53-5323-210 GARAGE-CELL PHONES .00 969.95 900.00 545.45 1,275.00 100-53-5323-220 GARAGE-UTILITY SERVICES 12,000.00 13,611.83 12,000.00 8,476.97 12,000.00 100-53-5323-320 GARAGE-LEASE PAYMENT .00 .00 .00 .00 13,742.00 100-53-5323-340 GARAGE-OPERATING SUPPLIES 7,000.00 7,148.25 7,000.00 8,026.51 7,000.00 100-53-5323-341 GARAGE-TOOL REPLACEMENT 1,500.00 1,437.13 1,000.00 1,276.80 1,500.00 100-53-5323-390 GARAGE-OTHER EXPENSE 2,500.00 3,289.33 2,500.00 3,618.38 2,880.00 100-53-5324-120 MACH/EQUIPMENT-WAGES 27,169.00 33,756.84 27,841.00 30,680.89 40,450.00 100-53-5324-125 MACH/EQUIP-VACATION PAYOUT .00 203.68 .00 200.30 .00 100-53-5324-130 MACH/EQUIPMENT-FICA 2,007.00 2,464.22 2,130.00 2,496.03 3,171.00 100-53-5324-135 MACH/EQUIPMENT-WI RET FUND 1,546.00 2,216.96 2,055.00 2,201.50 2,638.00 100-53-5324-140 MACH/EQUIPMENT-INSURANCES 9,081.00 10,513.55 14,824.00 12,679.15 15,038.00 100-53-5324-340 MACH/EQUIPMENT-OPER SUP/EXP 2,500.00 1,725.75 2,300.00 2,235.31 3,500.00 100-53-5324-350 MACH/EQUIPMENT-REPAIR/MAINT 4,000.00 4,000.00 1,000.00 1,256.92 2,000.00 100-53-5324-370 MACH/EQUIPMENT-VEHICLE MAINT 3,000.00 3,350.92 3,000.00 3,144.63 3,300.00 100-53-5324-371 MACH/EQUIPMENT-GAS 2,000.00 1,931.68 1,500.00 1,226.94 1,500.00 100-53-5324-390 MACH/EQUIPMENT-OTHER 500.00 .00 250.00 389.04 500.00 100-53-5330-120 STREETS/ALLEYS-WAGES 2,361.00 3,125.97 2,419.00 2,082.06 2,991.00 100-53-5330-125 STREETS/ALLEYS-VACATION PAYOUT .00 301.88 .00 160.24 .00 100-53-5330-130 STREETS/ALLEYS-FICA 174.00 256.69 185.00 177.03 229.00 100-53-5330-135 STREETS/ALLEYS-WI RET FUND 134.00 227.34 179.00 154.95 190.00 100-53-5330-140 STREETS/ALLEYS-INSURANCES 789.00 810.24 1,288.00 845.58 1,085.00 100-53-5330-320 STREETS/ALLEYS-LEASE PAYMENT .00 .00 10,996.00 10,899.39 10,900.00 100-53-5330-340 STREETS/ALLEYS-OPERATING SUP/E 2,000.00 3,903.57 2,000.00 568.58 1,000.00 100-53-5330-350 STREETS/ALLEYS-REP/MAIN SUPPLI 1,500.00 1,735.61 1,500.00 788.40 1,000.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 7 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-53-5330-370 STREETS/ALLEYS-ROADWAY SUPPLI 25,000.00 12,772.25 25,000.00 19,671.33 25,000.00 100-53-5330-390 STREETS/ALLEYS-OTHER SUP/EXP 2,000.00 1,888.20 1,600.00 28.32 100.00 100-53-5331-120 BRIDGES/CULVERTS-WAGES 59.00 .00 60.00 .00 72.00 100-53-5331-130 BRIDGES/CULVERTS-FICA 4.00 .00 5.00 .00 6.00 100-53-5331-135 BRIDGES/CULVERTS-WI RET FUND 3.00 .00 4.00 .00 5.00 100-53-5331-140 BRIDGES/CULVERTS-INSURANCES 20.00 .00 32.00 .00 26.00 100-53-5331-340 BRIDGES/CULVERTS-OPERATING SU 200.00 .00 200.00 490.11 200.00 100-53-5332-120 CURB/GUTTER-WAGES 124.00 37.00 127.00 56.06 82.00 100-53-5332-130 CURB/GUTTER-FICA 9.00 2.82 10.00 4.28 6.00 100-53-5332-135 CURB/GUTTER-WI RET FUND 7.00 0.60 9.00 3.78 5.00 100-53-5332-140 CURB/GUTTER-INSURANCES 42.00 11.04 68.00 23.98 30.00 100-53-5332-290 CURB/GUTTER-CONTRACT SERVICE 3,000.00 .00 .00 .00 .00 100-53-5333-120 STREET CLEANING-WAGES 713.00 450.58 730.00 .00 106.00 100-53-5333-125 STREET CLEANING-VACATION PAYOU .00 203.68 .00 .00 .00 100-53-5333-130 STREET CLEANING-FICA 53.00 50.08 56.00 .00 8.00 100-53-5333-135 STREET CLEANING-WI RET FUND 41.00 45.64 54.00 .00 7.00 100-53-5333-140 STREET CLEANING-INSURANCES 238.00 154.11 389.00 .00 39.00 100-53-5333-350 STREET CLEANING-CONTRACTED SE 800.00 .00 6,000.00 3,877.50 7,000.00 100-53-5333-370 STREET CLEANING-VEHICLE MAINT 150.00 930.24 .00 .00 .00 100-53-5333-371 STREET CLEANING-GAS 275.00 580.15 .00 .00 .00 100-53-5333-390 STREET CLEANING-OTHER SUP/EXP .00 244.75 .00 .00 .00 100-53-5334-120 SNOW/ICE REMOVAL-WAGES 10,396.00 13,148.28 10,653.00 10,724.21 11,901.00 100-53-5334-125 SNOW/ICE REMOVAL-VAC PAYOUT .00 203.68 .00 360.54 .00 100-53-5334-130 SNOW/ICE REMOVAL-FICA 768.00 1,016.96 815.00 852.43 882.00 100-53-5334-135 SNOW/ICE REMOVAL-WI RET FUND 592.00 934.89 787.00 752.13 734.00 100-53-5334-140 SNOW/ICE REMOVAL-INSURANCES 3,475.00 3,835.52 5,672.00 2,268.39 4,183.00 100-53-5334-320 SNOW/ICE REMOVAL-LEASE PAYMEN .00 .00 10,996.00 10,899.38 10,900.00 100-53-5334-340 SNOW/ICE REMOVAL-OPERATING SU 3,000.00 2,044.50 3,000.00 2,044.70 3,000.00 100-53-5334-370 SNOW/ICE REMOVAL-VEHICLE MAIN 6,000.00 8,660.48 6,000.00 4,725.86 6,000.00 100-53-5334-371 SNOW/ICE REMOVAL-GAS 2,000.00 2,394.59 3,000.00 2,204.01 3,000.00 100-53-5334-390 SNOW/ICE REMOVAL-MISC SUP/EXP 10,000.00 11,747.83 13,000.00 .00 13,000.00 100-53-5335-120 TRAFFIC CONTROL-WAGES 1,284.00 593.18 1,315.00 1,091.28 1,257.00 100-53-5335-125 TRAFFIC CONTROL-VACATION PAYOU .00 203.68 .00 .00 .00 100-53-5335-130 TRAFFIC CONTROL-FICA 95.00 56.90 101.00 87.54 96.00 100-53-5335-135 TRAFFIC CONTROL-WI RET FUND 73.00 45.44 97.00 77.22 80.00 100-53-5335-140 TRAFFIC CONTROL-INSURANCES 429.00 137.95 700.00 528.20 455.00 100-53-5335-340 TRAFFIC CONTROL-OPER SUPPLIES 2,500.00 3,052.50 2,500.00 2,143.14 2,500.00 100-53-5335-390 TRAFFIC CONTROL-SUPP/EXP 2,000.00 2,368.22 1,000.00 1,489.87 1,500.00 100-53-5336-120 TREE/BRUSH-WAGES 4,095.00 5,928.80 4,197.00 6,859.18 8,316.00 100-53-5336-125 TREE/BRUSH-VACATION PAYOUT .00 282.24 .00 80.12 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 8 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-53-5336-130 TREE/BRUSH-FICA 302.00 464.81 321.00 541.29 636.16 100-53-5336-135 TREE/BRUSH-WI RET FUND 233.00 357.46 310.00 475.11 529.00 100-53-5336-140 TREE/BRUSH-INSURANCES 1,369.00 1,495.61 2,234.00 3,004.60 3,017.00 100-53-5336-340 TREE/BRUSH-OPERATING SUPPLIES 100.00 .00 .00 .00 .00 100-53-5336-370 TREE/BRUSH-VEHICLE MAINTENANC 100.00 631.27 500.00 371.66 500.00 100-53-5336-371 TREE/BRUSH-GAS 175.00 249.95 300.00 526.83 300.00 100-53-5336-390 TREE/BRUSH-SUPPLIES/EXPENSE 100.00 .00 .00 .00 .00 100-53-5342-220 STREET LIGHTING 27,500.00 33,889.25 27,500.00 22,613.80 27,500.00 100-53-5343-120 SDWALKS/CROSSWALKS-WAGES 548.00 267.33 561.00 .00 27.00 100-53-5343-130 SDWALKS/CROSSWALKS-FICA 40.00 20.46 43.00 .00 2.00 100-53-5343-135 SDWALKS/CROSSWALKS-WI RET FND 31.00 19.51 41.00 .00 2.00 100-53-5343-140 SDWALKS/CROSSWALKS- INSURANC 183.00 37.24 299.00 .00 10.00 100-53-5343-290 SDWALKS/CROSSWALKS-CONTRACT 1,000.00 .00 .00 .00 1,500.00 100-53-5343-350 SDWALKS/CROSSWALKS-REP/MAINT 200.00 .00 .00 .00 .00 100-53-5343-390 SDWALKS/CROSSWALKS-OTHER SUP .00 87.78 .00 .00 .00 100-53-5344-120 STORM SEWER-WAGES 1,090.00 869.81 1,117.00 782.85 1,140.00 100-53-5344-130 STORM SEWER-FICA 81.00 66.57 85.00 59.91 90.00 100-53-5344-135 STORM SEWER-WI RET FUND 62.00 51.73 83.00 52.84 75.00 100-53-5344-140 STORM SEWER-INSURANCES 365.00 165.02 595.00 296.28 427.00 100-53-5344-350 STORM SEWER-REPAIR/MAIN SUPPLI 1,000.00 560.00 500.00 436.33 4,500.00 100-53-5344-390 STORM SEWER-SUPPLIES/EXPENSE 500.00 426.09 500.00 466.90 500.00 100-53-5345-120 PARKING LOTS-WAGES 47.00 .00 49.00 .00 500.00 100-53-5345-130 PARKING LOTS-FICA 4.00 .00 4.00 .00 39.00 100-53-5345-135 PARKING LOTS-WI RET FUND 3.00 .00 4.00 .00 32.00 100-53-5345-140 PARKING LOTS-INSURANCES 16.00 .00 20.00 .00 181.00 100-53-5345-220 PARKING LOTS-UTILITY SERVICES 400.00 423.12 350.00 243.48 350.00 100-53-5345-350 PARKING LOTS-REP/MAINT SUPPLIE 200.00 .00 .00 .00 .00 100-53-5362-120 GARBAGE COLLECTION-WAGES 1,173.00 1,226.88 1,202.00 1,327.26 1,072.00 100-53-5362-125 GARBAGE COLLECTION-VAC PAYOUT .00 203.68 .00 .00 .00 100-53-5362-130 GARBAGE COLLECTION-FICA 87.00 107.95 92.00 103.04 90.00 100-53-5362-135 GARBAGE COLLECTION-WI RET FND 67.00 72.31 89.00 90.89 68.00 100-53-5362-140 GARBAGE COLLECTION- INSURANCE 392.00 313.20 640.00 671.33 388.00 100-53-5362-210 GARBAGE COLLECTION-PROF SERVI 66,395.00 68,724.50 68,387.00 58,463.49 71,000.00 100-53-5362-371 GARBAGE COLLECTION-GAS 100.00 .00 100.00 .00 .00 100-53-5362-390 GARBAGE COLLECTION-OTHER EXP 600.00 950.00 300.00 .00 950.00 100-53-5363-120 TRANSFER STATION-WAGES 794.00 84.38 814.00 88.37 257.00 100-53-5363-125 TRANSFER STATION-VAC PAYOUT .00 .00 .00 80.12 .00 100-53-5363-130 TRANSFER STATION-FICA 59.00 6.45 62.00 12.89 20.00 100-53-5363-135 TRANSFER STATION-WI RET FUND 45.00 6.53 60.00 11.38 16.00 100-53-5363-140 TRANSFER STATION-INSURANCES 266.00 23.65 433.00 37.44 93.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 9 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-53-5363-220 TRANSFER STATION-UTILITY SERVI 300.00 363.90 350.00 245.03 300.00 100-53-5363-290 TRANSFER STATION-CONTRACT SER 2,500.00 1,819.00 2,500.00 1,691.00 2,000.00 100-53-5363-350 TRANSFER STATION-REP/MAIN SUPP .00 53.79 .00 .00 .00 100-53-5363-390 TRANSFER STATION-OTHER SUPP/EP 3,000.00 784.68 1,000.00 1,246.06 1,500.00 100-53-5365-120 RECYCLING-WAGES 6,752.00 4,127.34 6,920.00 5,203.47 9,413.00 100-53-5365-125 RECYCLING-VACATION PAYOUT .00 .00 .00 120.18 .00 100-53-5365-130 RECYCLING-FICA 499.00 300.21 529.00 422.86 720.00 100-53-5365-135 RECYCLING-WI RET FUND 384.00 241.95 511.00 371.89 599.00 100-53-5365-140 RECYCLING-INSURANCES 2,257.00 1,418.94 3,684.00 1,992.05 3,415.00 100-53-5365-210 RECYCLING-PROFESSIONAL SERVIC 27,860.00 24,243.04 25,000.00 20,729.36 25,000.00 100-53-5365-350 RECYCLING-REP/MAIN SUPPLIES 100.00 .00 .00 .00 .00 100-53-5365-370 RECYCLING-VEHICLE MAINTENANCE 100.00 .00 .00 1,473.19 1,000.00 100-53-5365-371 RECYCLING-GAS 100.00 100.00 100.00 109.56 200.00 100-53-5365-390 RECYCLING-OTHER SUPPLIES 50.00 1,459.80 .00 .00 .00 100-53-5422-290 ENGINEERING-STORM SEWERS 3,000.00 7,544.30 1,500.00 1,661.50 1,000.00 100-53-5424-290 ENGINEERING-STREET 6,000.00 10,904.54 10,000.00 2,111.50 5,000.00 100-53-5429-290 ENGINEERING-OTHER 30,000.00 6,242.30 5,000.00 253.00 2,500.00 HEALTH AND HUMAN SERVICES 100-54-5410-290 RETIRED PERSONS HEALTH INSURA 13,553.00 13,553.00 .00 .00 5,297.00 100-54-5414-290 ANIMAL POUND-CONTRACT SERVICE 550.00 .00 300.00 .00 300.00 100-54-5910-120 CEMETERY-WAGES 10,564.00 13,357.21 13,362.00 13,130.95 14,320.00 100-54-5910-125 CEMETERY-VACATION PAYOUT .00 .00 .00 40.06 .00 100-54-5910-130 CEMETERY-FICA 804.00 1,027.68 1,022.00 1,007.56 1,097.00 100-54-5910-135 CEMETERY-WI RETIREMENT FUND 570.00 159.91 .00 58.12 229.00 100-54-5910-140 CEMETERY-INSURANCES 386.00 697.34 .00 315.96 40.00 100-54-5910-210 CEMETERY-CONTRACTED SERVICES 3,000.00 76.38 3,000.00 115.00 2,000.00 100-54-5910-220 CEMETERY-UTILITY SERVICES 350.00 441.75 350.00 308.75 380.00 100-54-5910-340 CEMETERY-OPERATING SUPPLIES 1,600.00 1,155.98 1,200.00 957.86 1,000.00 100-54-5910-350 CEMETERY-REPAIR/MAIN EXPENSE 550.00 337.97 1,000.00 1,519.69 1,000.00 100-54-5910-390 CEMETERY-SUPPLIES/EXPENSE 200.00 457.30 450.00 39.34 450.00 CULTURE,RECREATION & EDUCATION 100-55-5157-210 INDEPENDENT AUDITING-LIBRARY 1,000.00 1,259.00 1,100.00 1,018.00 1,200.00 100-55-5511-120 LIBRARY-WAGES 64,144.00 58,119.42 66,793.00 49,880.61 66,396.00 100-55-5511-130 LIBRARY-FICA 4,907.00 4,269.00 5,110.00 3,992.93 5,079.00 100-55-5511-135 LIBRARY-WI RETIREMENT FUND 2,879.00 2,569.50 2,520.00 2,259.89 2,648.00 100-55-5511-140 LIBRARY-INSURANCES 18,500.00 16,315.10 19,836.00 14,838.88 19,514.00 100-55-5511-145 LIBRARY-WORKERS COMP INS .00 .00 .00 .00 1,453.00 100-55-5511-220 LIBRARY-UTILITY SERVICES 6,500.00 7,150.21 6,000.00 4,307.42 6,000.00 100-55-5511-290 LIBRARY-CONTRACTUAL SERVICES 8,000.00 8,853.28 8,500.00 8,706.88 9,000.00 100-55-5511-310 LIBRARY-OFFICE SUPPLIES 2,500.00 2,148.67 2,500.00 500.35 2,500.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 10 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-55-5511-315 LIBRARY-ADULT & JUVENILE PROGR 3,500.00 2,783.83 4,000.00 2,036.92 4,000.00 100-55-5511-320 LIBRARY-SUBSCRIPTIONS/MAGAZINE 2,000.00 2,034.89 2,000.00 815.60 1,500.00 100-55-5511-331 LIBRARY-TRAINING 1,000.00 744.75 1,000.00 985.70 1,000.00 100-55-5511-340 LIBRARY-OPERATING SUPP/MISC 3,000.00 2,340.71 3,000.00 2,775.18 3,000.00 100-55-5511-350 LIBRARY-REP/MAIN BLDG & EQUIPT 3,000.00 2,067.49 8,480.80 6,830.22 3,000.00 100-55-5511-390 LIBRARY-MATERIALS 18,000.00 19,215.56 14,519.20 13,960.94 20,000.00 100-55-5515-390 HARRIET O'CONNELL SUPP/EXPENSE 1,000.00 553.19 1,500.00 497.78 1,500.00 100-55-5520-120 PARKS-WAGES 27,371.00 29,194.77 25,999.00 30,239.67 37,433.00 100-55-5520-125 PARKS-VACATION PAYOUT 3,550.17 400.08 .00 280.42 .00 100-55-5520-130 PARKS-FICA 1,874.00 2,201.44 1,989.00 2,397.31 2,864.00 100-55-5520-135 PARKS-WI RETIREMENT FUND 1,444.00 1,474.96 1,919.00 2,086.89 2,383.00 100-55-5520-140 PARKS-INSURANCES 8,482.00 6,234.70 13,843.00 12,333.92 13,580.00 100-55-5520-220 PARKS-UTILITY SERVICES 2,200.00 2,475.84 2,500.00 2,048.61 2,250.00 100-55-5520-340 PARKS-OPERATING SUPPLIES 2,000.00 1,778.51 3,400.00 3,487.10 3,400.00 100-55-5520-350 PARKS-REPAIR/MAINT SUP/EXP 2,000.00 539.31 1,000.00 1,736.53 1,250.00 100-55-5520-370 PARKS-VEHICLE MAINTENANCE 1,500.00 1,085.65 1,500.00 338.58 1,250.00 100-55-5520-371 PARKS-GAS 1,500.00 573.72 1,500.00 1,389.68 1,500.00 100-55-5520-390 PARKS-SUPPLIES/EXPENSE 2,500.00 5,061.61 1,000.00 1,337.60 1,000.00 100-55-5520-820 PARKS-CAPITAL IMPROVEMENTS .00 6,459.00 .00 .00 .00 100-55-5530-120 CELEBRATIONS-WAGES 1,270.00 1,045.75 1,302.00 373.80 748.00 100-55-5530-130 CELEBRATIONS-FICA 94.00 80.04 100.00 28.56 57.00 100-55-5530-135 CELEBRATIONS-WI RET FUND 72.00 58.67 96.00 25.22 48.00 100-55-5530-140 CELEBRATIONS-INSURANCES 425.00 302.47 693.00 87.53 271.00 100-55-5530-340 CELEBRATIONS-OPERATING SUPPLIE .00 .00 .00 62.09 .00 100-55-5530-390 CELEBRATIONS-OTHER SUP/EXPENS 7,200.00 7,787.66 8,790.00 5,279.77 7,540.00 100-55-5541-120 WATER RECREATION-WAGES .00 12.73 50.00 164.24 181.00 100-55-5541-130 WATER RECREATION-FICA .00 0.98 4.00 12.56 14.00 100-55-5541-135 WATER RECREATION-WI RET FUND .00 0.84 4.00 11.09 12.00 100-55-5541-140 WATER RECREATION-INSURANCES .00 3.95 10.00 .00 66.00 100-55-5541-340 WATER RECREATION-OPER SUP/EXP 2,200.00 730.97 1,200.00 1,175.79 1,200.00 100-55-5541-350 WATER RECREATION-REP/MAIN SUP 200.00 .00 100.00 8.00 500.00 100-55-5542-120 SWIMMING POOL-WAGES 3,378.00 4,420.68 3,885.00 3,132.98 3,732.00 100-55-5542-130 SWIMMING POOL-FICA 258.00 338.20 296.00 239.66 285.00 100-55-5542-135 SWIMMING POOL-WI RET FUND 221.00 272.94 255.00 175.95 252.00 100-55-5542-140 SWIMMING POOL-INSURANCES 1,425.00 1,286.03 1,581.00 819.41 1,373.00 100-55-5542-210 SWIMMING POOL-PROFESSIONAL SE 2,000.00 1,685.85 1,000.00 1,702.44 1,700.00 100-55-5542-220 SWIMMING POOL-UTILITY SERVICES 12,000.00 9,366.45 9,000.00 5,701.78 9,000.00 100-55-5542-290 SWIMMING POOL-CONTRACTUAL SE 35,547.00 30,945.80 35,500.00 26,479.17 32,500.00 100-55-5542-310 SWIMMING POOL-OFFICE SUPPLIES 40.00 11.74 20.00 .00 20.00 100-55-5542-331 SWIMMING POOL-CONCESSIONS .00 1,009.90 1,500.00 .00 1,500.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 11 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-55-5542-340 SWIMMING POOL-OPERATING SUPPL 3,500.00 3,377.72 3,500.00 3,193.38 3,500.00 100-55-5542-350 SWIMMING POOL-CHEMICALS 8,500.00 6,132.52 8,000.00 1,663.87 5,000.00 100-55-5542-390 SWIMMING POOL-SUPP/EXPENSE 4,500.00 3,531.86 4,000.00 3,924.40 4,000.00 100-55-5543-120 OTHER SUMMER REC-WAGES 23.00 98.20 23.00 .00 538.00 100-55-5543-130 OTHER SUMMER REC-FICA 2.00 7.52 2.00 .00 41.00 100-55-5543-135 OTHER SUMMER REC-WI RET FUND 1.00 7.42 2.00 .00 34.00 100-55-5543-140 OTHER SUMMER REC-INSURANCES 8.00 .00 12.00 .00 195.00 100-55-5543-390 OTHER SUMMER REC-SUP/EXP 1,400.00 1,526.52 .00 158.59 200.00 100-55-5544-120 OTHER WINTER REC-WAGES .00 .00 .00 .00 26.00 100-55-5544-130 OTHER WINTER REC-FICA .00 .00 .00 .00 2.00 100-55-5544-135 OTHER WINTER REC-WI RET FUND .00 .00 .00 .00 2.00 100-55-5544-140 OTHER WINTER REC-INSURANCES .00 .00 .00 .00 10.00 CONSERVATION & DEVELOPMENT 100-56-5364-120 WEED CONTROL-WAGES 1,481.00 510.90 1,518.00 1,238.29 942.00 100-56-5364-125 WEED CONTROL-VACATION PAYOUT .00 .00 .00 160.24 .00 100-56-5364-130 WEED CONTROL-FICA 109.00 39.10 116.00 106.98 72.00 100-56-5364-135 WEED CONTROL-WI RET FUND 84.00 33.44 112.00 94.39 60.00 100-56-5364-140 WEED CONTROL-INSURANCES 495.00 144.12 808.00 285.94 342.00 100-56-5364-210 WEED CONTROL-PROFESSIONAL SE 2,000.00 340.00 500.00 200.00 500.00 100-56-5364-350 WEED CONTROL-REPAIR/MAIN SUPP 150.00 24.22 100.00 809.35 100.00 100-56-5364-370 WEED CONTROL-VEHICLE MAINTENA .00 .00 .00 356.67 500.00 100-56-5364-371 WEED CONTROL-GAS 100.00 .00 100.00 .00 100.00 100-56-5364-390 WEED CONTROL-SUPP/EXPENSE 1,000.00 998.53 1,000.00 1,616.27 1,800.00 100-56-5611-120 FORESTRY-WAGES 396.00 663.88 406.00 747.11 1,494.00 100-56-5611-125 FORESTRY-VACATION PAYOUT .00 203.68 .00 .00 .00 100-56-5611-130 FORESTRY-FICA 29.00 66.38 31.00 57.14 114.00 100-56-5611-135 FORESTRY-WI RET FUND 23.00 60.00 30.00 50.42 95.00 100-56-5611-140 FORESTRY-INSURANCES 132.00 243.35 216.00 252.44 542.00 100-56-5611-210 FORESTRY-CONTRACTED SERVICES 5,000.00 1,500.00 3,000.00 600.00 2,000.00 100-56-5611-340 FORESTRY-OPERATING SUPPLIES 100.00 .00 .00 36.83 .00 100-56-5611-390 FORESTRY-SUPPLIES/EXPENSE 500.00 3.12 500.00 453.59 600.00 100-56-5670-120 ECON DEVELOPMENT-WAGES .00 313.31 .00 26.47 29.00 100-56-5670-130 ECON DEVELOPMENT-FICA .00 23.96 .00 2.02 2.00 100-56-5670-135 ECON DEVELOPMENT-WI RET FUND .00 19.49 .00 1.79 2.00 100-56-5670-140 ECON DEVELOPMENT-INSURANCES .00 94.90 .00 8.50 11.00 100-56-5670-390 ECON DEVELOPMENT-SUP/EXPENSE 700.00 747.89 240.00 205.21 240.00 100-56-5690-120 DAM-WAGES 4,000.00 4,301.32 5,000.00 2,708.62 3,423.00 100-56-5690-130 DAM-FICA 300.00 320.96 400.00 215.34 262.00 100-56-5690-135 DAM-WI RET FUND 22.00 217.44 300.00 189.93 218.00 100-56-5690-140 DAM-INSURANCES 128.00 869.45 2,000.00 954.75 1,242.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 12 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 100-56-5690-210 DAM-PROFESSIONAL SERVICES .00 5,864.84 1,000.00 300.00 500.00 100-56-5690-350 DAM-REPAIR/MAINTENANCE EXPENS 200.00 .00 .00 .00 200.00 100-56-5690-390 DAM-OTHER SUPPLIES/EXPENSE 500.00 479.72 200.00 40.03 200.00 DEBT SERVICE 100-58-5915-610 PRINCIPLE - SHORT TERM LOAN .00 .00 .00 .00 35,500.00 100-58-5915-620 INTEREST - SHORT TERM LOAN .00 .00 .00 .00 172.64 100-58-5918-610 PRINCIPAL - R.D.A. 62,400.00 62,400.00 48,535.88 41,385.46 .00 100-58-5918-620 INTEREST - R.D.A. 8,092.52 8,092.50 1,688.90 1,688.90 .00 100-58-5921-620 INTEREST - $557,000 .00 0.39 .00 .00 .00 OTHER FINANCING USES 100-59-5900-205 TRANSFER OUT TO 205 .00 .00 88,963.20 .00 88,963.20 100-59-5900-301 TRANSFER OUT TO 301 98,732.43 170,842.43 124,488.18 .00 74,626.84 GENERAL FUND Revenue Total: 1,762,747.38 1,741,166.70 1,866,074.16 1,342,271.68 1,880,718.59 GENERAL FUND Expenditure Total: 1,732,747.38 1,764,030.99 1,866,074.16 1,360,700.95 1,880,718.59 Net Total GENERAL FUND: 30,000.00 22,864.29- .00 18,429.27- .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 13 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 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 .00 141.06 100.00 62.17 80.00 Total MISCELLANEOUS REVENUE: .00 141.06 100.00 62.17 80.00 CAPITAL OUTLAY 202-57-5710-310 ADMINISTRATIVE EXPENSE .00 27,528.46 500.00 30.00 100.00 REVOLVING LOAN S/R FUND Revenue Total: .00 141.06 100.00 62.17 80.00 REVOLVING LOAN S/R FUND Expenditure Total: .00 27,528.46 500.00 30.00 100.00 Net Total REVOLVING LOAN S/R FUND: .00 27,387.40- 400.00- 32.17 20.00- CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 14 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget REDEVELOPMENT AUTHORITY FUND MISCELLANEOUS REVENUE 205-48-4800-000 TRANSFER IN .00 .00 88,963.02 .00 88,963.20 205-48-4810-000 INTEREST 200.00 41.29 50.00 .00 .00 205-48-4815-000 RDA 1.2M 2019-INTEREST REVENUE .00 1,804.00 .00 .00 .00 205-48-4850-000 MISCELLANEOUS REVENUE 19,000.00 74,900.56 19,440.00 15,226.48 17,812.00 Total MISCELLANEOUS REVENUE: 19,200.00 76,745.85 108,453.02 15,226.48 106,775.20 OTHER FINANCING SOURCES 205-49-4910-000 PROCEEDS FROM BORROWING 88,963.20 .00 .00 .00 .00 Total OTHER FINANCING SOURCES: 88,963.20 .00 .00 .00 .00 GENERAL GOVERMENT 205-51-5157-210 INDEPENDENT AUDITING 5,700.00 4,703.00 3,100.00 .00 3,100.00 CONSERVATION & DEVELOPMENT 205-56-5670-000 BUSINESS INCENTIVES 12,000.00 18,500.00 .00 .00 .00 CAPITAL OUTLAY 205-57-5710-310 ADMINISTRATIVE EXPENSE 1,500.00 4,917.52 1,500.00 19,129.48 10,000.00 DEBT SERVICE 205-58-5813-610 RDA 1.2M 2019 - PRINCIPAL 39,612.76 38,826.47 41,179.61 19,798.84 43,083.92 205-58-5813-620 RDA 1.2M 2019 - INTEREST 49,350.44 50,136.73 47,783.59 24,682.76 45,880.28 REDEVELOPMENT AUTHORITY FUND Revenue Total: 108,163.20 76,745.85 108,453.02 15,226.48 106,775.20 REDEVELOPMENT AUTHORITY FUND Expenditure Total: 108,163.20 117,083.72 93,563.20 63,611.08 102,064.20 Net Total REDEVELOPMENT AUTHORITY FUND: .00 40,337.87- 14,889.82 48,384.60- 4,711.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 15 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget DEBT SERVICE FUND OTHER FINANCING SOURCES 301-49-4900-100 TRANSFER IN FROM GENERAL FUND 98,732.43 170,842.43 124,488.18 .00 74,626.84 Total OTHER FINANCING SOURCES: 98,732.43 170,842.43 124,488.18 .00 74,626.84 GENERAL GOVERMENT 301-51-5157-210 INDEPENDENT AUDITING 1,200.00 1,176.00 800.00 .00 500.00 DEBT SERVICE 301-58-5811-610 STFL 2018 $557,000 PRINCIPAL .00 75,440.82 17,884.03 17,884.03 18,748.18 301-58-5811-620 STFL 2018 $557,000 INTEREST .00 12,704.18 21,729.53 21,729.53 20,865.38 301-58-5812-610 STFL PRINCIPAL 78,330.00 78,329.43 67,215.98 67,215.98 .00 301-58-5812-620 STFL INTEREST 4,367.00 4,366.36 2,022.00 2,022.00 .00 301-58-5820-610 $527,000 PRINC CITY SHARE 52% 5,517.72 5,519.00 5,770.07 5,770.07 6,032.65 301-58-5820-620 $527,000 INT CITY SHARE 52% 9,317.71 9,318.00 9,066.57 9,066.57 8,803.99 301-58-5827-610 STFL 2020 $150,000 PRINCIPLE .00 .00 .00 .00 13,332.46 301-58-5827-620 STFL 2020 $150,000 INTEREST .00 .00 .00 .00 6,344.18 DEBT SERVICE FUND Revenue Total: 98,732.43 170,842.43 124,488.18 .00 74,626.84 DEBT SERVICE FUND Expenditure Total: 98,732.43 186,853.79 124,488.18 123,688.18 74,626.84 Net Total DEBT SERVICE FUND: .00 16,011.36- .00 123,688.18- .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 16 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 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 .00 .00 1,577.00 .00 400-48-4851-702 GRANT-CDBG-PF 2017 .00 .00 .00 .00 .00 400-48-4851-703 GRANT-CDBG-PF 2019 483,000.00 .00 .00 .00 .00 400-48-4851-704 GRANT-CDBG-PF-2020 .00 .00 .00 .00 703,491.00 Total MISCELLANEOUS REVENUE: 483,000.00 .00 .00 1,577.00 703,491.00 OTHER FINANCING SOURCES 400-49-4900-101 LOAN PROCEEDS .00 .00 .00 35,500.00 127,225.00 400-49-4900-102 LOAN PROCEEDS-GREEN STREET .00 .00 .00 .00 560,000.00 400-49-4900-103 LOAN PROCEEDS-TRENTON STREET 717,750.00 150,000.00 .00 .00 .00 400-49-4900-400 TRSFR IN FROM GENERAL OUTLAY .00 .00 139,616.00 .00 .00 400-49-4900-701 TRANSFER IN FROM CEMETERY PC .00 .00 7,400.00 7,400.00 3,000.00 400-49-4930-000 FUNDS APPLIED 115,022.00 .00 .00 .00 228,597.00 Total OTHER FINANCING SOURCES: 832,772.00 150,000.00 147,016.00 42,900.00 918,822.00 GENERAL GOVERMENT 400-51-5120-810 MUNICIPAL COURT-CAPITAL EQUIPM 2,000.00 1,149.90 3,836.00 3,607.00 2,320.00 400-51-5140-810 MSA ADMINISTRATIVE COSTS 10,000.00 .00 .00 .00 .00 400-51-5142-810 CLERK-CAPITAL EQUIPMENT 1,500.00 1,260.80 .00 .00 .00 400-51-5144-810 ELECTIONS-CAPITAL EQUIPMENT 2,000.00 .00 .00 .00 .00 400-51-5151-810 TREASURER-CAPITAL EQUIPMENT 4,875.00 9,881.83 1,500.00 .00 .00 400-51-5157-210 INDEPENDENT AUDITING 500.00 .00 .00 .00 .00 400-51-5162-810 OTHER MUNI BLDG-CAPITAL EQUIPM .00 .00 .00 .00 8,700.00 400-51-5171-810 MUNI BLDG-CAPITAL EQUIPMENT 200.00 .00 17,980.00 17,980.00 .00 400-51-5171-820 MUNI BLDG-CAPITAL IMPROVEMENT 800.00 2,430.59 11,400.00 5,163.40 .00 PUBLIC SAFTEY 400-52-5211-810 POLICE PATROL-CAPITAL EQUIPMT 10,000.00 11,765.26 15,500.00 .00 .00 400-52-5211-811 POLICE PATROL-CAPITAL CARRY 20,000.00- .00 .00 .00 .00 400-52-5211-820 POLICE PATROL-CAPITAL IMPROV .00 .00 1,600.00 1,761.60 19,069.00 400-52-5232-810 FIRE SUPPRESSION-CAPITAL EQUIP .00 .00 .00 .00 146,725.00 PUBLIC WORKS 400-53-5323-810 GARAGE-CAPITAL EQUIPMENT 1,120.00 1,115.00 11,550.00 7,600.00 .00 400-53-5323-820 GARAGE-CAPITAL IMPROVEMENT .00 .00 .00 .00 .00 400-53-5324-810 MACH/EQUIP-CAPITAL EQUIPMENT 15,500.00 15,500.00 11,500.00 10,240.00 .00 400-53-5330-810 STREETS/ALLEYS-CAPITAL EQUIP 5,300.00 6,282.50 .00 1,940.00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 17 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 400-53-5330-820 STREETS/ALLEYS-CAPITAL IMPROV 750,600.00 35,010.00 23,000.00 22,768.00 43,854.00 400-53-5330-830 TRENTON ST-CAPITAL IMPROVEMEN .00 148,757.86 .00 391.58 .00 400-53-5330-840 CONTINGENCY EXPENSE 483,000.00 .00 .00 .00 .00 400-53-5330-845 SECOND ST-CAPITAL IMPROVEMENT .00 .00 .00 .00 .00 400-53-5330-850 GREEN ST-CAPITAL IMPROVEMENTS .00 .00 .00 2,988.93 1,132,737.00 400-53-5344-810 STORM SEWER-CAPITAL EQUIPMENT .00 .00 .00 35,500.00 .00 400-53-5344-820 STORM SEWER-CAPITAL IMPROVEME .00 9,611.00 .00 760.00 66,218.00 400-53-5424-830 TRENTON STREET- ENGINEERING .00 6,607.24 .00 662.46 .00 400-53-5424-850 GREEN ST-ENGINEERING .00 .00 .00 12,821.25 130,754.00 HEALTH AND HUMAN SERVICES 400-54-5910-810 CEMETERY-CAPITAL EQUIPMENT 5,300.00 6,282.50 7,400.00 7,400.00 3,000.00 400-54-5910-820 CEMETERY-CAPITAL IMPROVEMENT 2,300.00 2,300.00 .00 .00 .00 CULTURE,RECREATION & EDUCATION 400-55-5511-810 LIBRARY-CAPITAL EQUIPMENT .00 .00 .00 .00 2,500.00 400-55-5511-820 LIBRARY-CAPITAL IMPROVEMENT .00 .00 .00 4,046.63 3,750.00 400-55-5520-810 PARKS-CAPITAL EQUIPMENT 1,500.00 1,500.00 11,500.00 10,239.99 2,500.00 400-55-5520-820 PARKS-CAPITAL IMPROVEMENT 600.00 600.00 .00 .00 10,000.00 400-55-5542-810 SWIMMING POOL-CAPITAL EQUIPME 3,677.00 2,826.52 30,250.00 55,480.75 50,186.00 400-55-5542-820 SWIMMING POOL-CAPITAL IMPROVE 5,000.00 3,390.00 .00 .00 .00 DEBT SERVICE 400-58-5820-620 INTEREST ON LOANS .00 1,134.00 .00 .00 .00 OTHER FINANCING USES 400-59-5900-100 TRANSFER OUT TO GENERAL FUND .00 .00 .00 500.00 .00 CAPITAL IMPROVEMENTS FUND Revenue Total: 1,315,772.00 150,000.00 147,016.00 44,477.00 1,622,313.00 CAPITAL IMPROVEMENTS FUND Expenditure Total: 1,285,772.00 267,405.00 147,016.00 201,851.59 1,622,313.00 Net Total CAPITAL IMPROVEMENTS FUND: 30,000.00 117,405.00- .00 157,374.59- .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 18 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 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 62,286.00 63,443.00 63,443.00 67,824.00 62,831.00 Total TIF #2 INCREMENT: 62,286.00 63,443.00 63,443.00 67,824.00 62,831.00 INTERGOVERNMENTAL REVENUES 401-42-4250-000 STATE AID-EXEMPT COMPUTERS 2,292.00 2,382.00 .00 .00 .00 401-42-4259-000 STATE AID-OTHER GRANTS .00 .00 .00 2,692.18 5,334.20 Total INTERGOVERNMENTAL REVENUES: 2,292.00 2,382.00 .00 2,692.18 5,334.20 MISCELLANEOUS REVENUE 401-48-4851-700 GRANT-WI DEPT OF TRANSPORTATIO .00 .00 .00 .00 31,759.51 Total MISCELLANEOUS REVENUE: .00 .00 .00 .00 31,759.51 OTHER FINANCING SOURCES 401-49-4910-000 LOAN PROCEEDS 605,000.00 604,999.63 .00 .00 .00 Total OTHER FINANCING SOURCES: 605,000.00 604,999.63 .00 .00 .00 GENERAL GOVERMENT 401-51-5157-210 INDEPENDENT AUDITING 4,100.00 10,224.00 4,250.00 1,884.50 2,000.00 PUBLIC WORKS 401-53-5330-800 MILL RD-CAPITAL IMPROVEMENTS .00 .00 .00 .00 116,880.00 CAPITAL OUTLAY 401-57-5700-790 BUSINESS INCENTIVES 605,000.00 .00 .00 504,999.00 .00 401-57-5700-791 COVID-19 BUSINESS LOANS .00 .00 .00 26,600.00 .00 401-57-5700-795 TIF #2 LAND PURCHASES .00 63,881.63 .00 5,350.00 .00 401-57-5710-310 ADMINISTRATIVE EXPENSE 20,478.00 743.75 2,650.00 10,260.90 3,000.00 401-57-5710-330 CONTINGENCY EXPENSE 40,000.00 .00 .00 .00 .00 DEBT SERVICE 401-58-5810-610 STFL $390,000 PRINCIPAL .00 .00 6,288.66 6,288.66 15,514.94 401-58-5820-610 STFL $390,000 PRINCIPAL .00 .00 .00 .00 .00 401-58-5820-620 STFL $390,000 INTEREST .00 2,800.45 26,493.29 26,493.29 17,267.01 401-58-5820-630 INTEREST ON TIF ADVANCE .00 344.00 .00 .00 .00 401-58-5830-610 STFL $800,000 PRI TIF#2 SHARE .00 .00 .00 .00 16,065.62 401-58-5830-620 STFL $800,000 INT TIF#2 SHARE .00 .00 .00 .00 29,524.83 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 19 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget TIF #2 CAPITAL PROJECTS FUND Revenue Total: 669,578.00 670,824.63 63,443.00 70,516.18 99,924.71 TIF #2 CAPITAL PROJECTS FUND Expenditure Total: 669,578.00 77,993.83 39,681.95 581,876.35 200,252.40 Net Total TIF #2 CAPITAL PROJECTS FUND: .00 592,830.80 23,761.05 511,360.17- 100,327.69- CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 20 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 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 15,895.00 16,190.00 16,190.00 75,030.00 37,910.00 Total TAXES: 15,895.00 16,190.00 16,190.00 75,030.00 37,910.00 MISCELLANEOUS REVENUE 402-48-4810-000 INTEREST .00 1,749.52 120.00 1,272.69 60.00 402-48-4851-701 GRANT-CDBG-PFED .00 .00 .00 .00 .00 Total MISCELLANEOUS REVENUE: .00 1,749.52 120.00 1,272.69 60.00 OTHER FINANCING SOURCES 402-49-4910-000 LOAN PROCEEDS 390,000.00 195,000.37 .00 .00 .00 Total OTHER FINANCING SOURCES: 390,000.00 195,000.37 .00 .00 .00 GENERAL GOVERMENT 402-51-5157-210 INDEPENDENT AUDITING 4,100.00 10,224.00 4,250.00 1,884.50 2,000.00 PUBLIC WORKS 402-53-5330-820 STREETS/ALLEYS -CAPITAL IMPROV 121,802.00 62,983.25 .00 3,149.00- .00 402-53-5429-290 ENGINEERING-OTHER 20,000.00 .00 .00 .00 .00 TIF #3 CAPITAL PROJECTS 402-57-5700-330 CONTINGENCY EXPENSE 168,030.00 .00 .00 .00 .00 402-57-5700-790 BUSINESS INCENTIVES .00 .00 .00 .00 .00 402-57-5700-791 LEROY MEATS INCENTIVE 40,000.00 39,000.00 22,500.00 22,500.00 4,500.00 402-57-5700-792 GLOBAL TECH INCENTIVE 12,000.00 12,000.00 10,000.00 10,000.00 .00 402-57-5700-793 DOLLAR GENERAL INCENTIVE 20,000.00 .00 20,000.00 24,034.46 25,965.54 402-57-5710-310 ADMINISTRATIVE EXPENSE 20,000.00 10,435.85 15,000.00 1,702.00 1,650.00 DEBT SERVICE 402-58-5820-620 ERGO BANK INTEREST 1.2M 16,000.00 50,283.48 .00 .00 .00 402-58-5820-630 INTEREST ON TIF ADVANCE .00 5,105.00 .00 .00 .00 402-58-5830-610 STFL $800,000 PRI TIF#3 SHARE .00 .00 .00 .00 5,178.18 402-58-5830-620 STFL $800,000 INT TIF#3 SHARE .00 .00 .00 .00 9,516.27 OTHER FINANCING USES 402-59-5900-205 TRANSFER OUT TO 205 88,963.00 .00 .00 .00 .00 TIF #3 FUND Revenue Total: 405,895.00 212,939.89 16,310.00 76,302.69 37,970.00 TIF #3 FUND Expenditure Total: 510,895.00 190,031.58 71,750.00 56,971.96 48,809.99 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 21 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget Net Total TIF #3 FUND: 105,000.00- 22,908.31 55,440.00- 19,330.73 10,839.99- CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 22 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget CAP PROJ-MUNICIPAL BLDG FUND MISCELLANEOUS REVENUE 403-48-4811-000 INTEREST 200.00 1,899.81 100.00 76.24 .00 403-48-4815-000 CAPITAL LEASE INTEREST REVENUE 8,092.52 8,092.50 1,688.90 1,688.90 .00 403-48-4915-000 CAPITAL LEASE PRINCIPAL REVENU 62,400.00 62,400.00 48,535.88 41,385.46 .00 Total MISCELLANEOUS REVENUE: 70,692.52 72,392.31 50,324.78 43,150.60 .00 GENERAL GOVERMENT 403-51-5157-210 INDEPENDENT AUDITING 200.00 784.00 500.00 .00 .00 DEBT SERVICE 403-58-5919-610 RDA 4/19/96 1M PRINCIPAL 62,400.00 62,400.00 48,535.88 134,800.00 .00 403-58-5919-620 RDA 4/19/96 1M INTEREST 8,092.52 8,092.50 1,688.90 1,688.90 .00 CAP PROJ-MUNICIPAL BLDG FUND Revenue Total: 70,692.52 72,392.31 50,324.78 43,150.60 .00 CAP PROJ-MUNICIPAL BLDG FUND Expenditure Total: 70,692.52 71,276.50 50,724.78 136,488.90 .00 Net Total CAP PROJ-MUNICIPAL BLDG FUND: .00 1,115.81 400.00- 93,338.30- .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 23 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 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 9,256.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 9,256.00 .00 .00 .00 Net Total CAP PROJ-RURAL DEV GRANT FUND: .00 5,581.00 .00 .00 .00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 24 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 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 ON TEMP INVESTMENT 100.00 1,409.68 360.00 1,140.56 205.00 610-41-4601-000 UNMETERED SALE OF GEN CUSTOM .00 170.35 .00 .00 .00 610-41-4610-000 RESIDENTIAL REVENUE 167,000.00 166,622.05 167,000.00 136,438.23 167,000.00 610-41-4612-000 COMMERCIAL REVENUE 20,000.00 23,648.83 20,000.00 18,163.24 24,000.00 610-41-4612-100 MULTI FAMILY REVENUE 17,000.00 15,033.24 17,000.00 10,166.14 17,000.00 610-41-4613-000 INDUSTRIAL REVENUE 33,000.00 34,751.07 33,000.00 24,057.72 33,000.00 610-41-4614-000 REVENUE-PUBLIC AUTHORITIES 11,000.00 8,399.06 11,000.00 6,214.99 8,500.00 610-41-4620-000 PRIVATE FIRE PROTECTION 5,000.00 5,592.00 5,000.00 4,194.00 5,600.00 610-41-4630-000 PUBLIC FIRE PROTECTION 139,389.00 139,389.00 139,389.00 116,157.50 139,389.00 610-41-4700-000 FORFEITED DISCOUNTS 1,000.00 1,395.24 1,000.00 312.49 1,000.00 610-41-4720-000 FUNDS APPLIED 7,500.00 .00 .00 .00 .00 610-41-4740-000 OTHER WATER REVENUE 500.00 6,204.49 500.00 72.00 100.00 610-41-4750-000 WATER CONNECTION CHARGES .00 2,500.00 1,000.00 .00 .00 Total WATER SALES REVENUE: 401,489.00 405,115.01 395,249.00 316,916.87 395,794.00 OTHER FINANCING SOURCES 610-49-4900-200 TRANS IN FROM LGIP WATER OUTLA .00 .00 235,000.00 .00 .00 Total OTHER FINANCING SOURCES: .00 .00 235,000.00 .00 .00 PUBLIC WORKS 610-53-0403-000 DEPRECIATION EXPENSE 66,750.00 71,680.00 75,000.00 .00 75,000.00 610-53-0403-001 DEPRECIATION EXPENSE-CIAC 27,324.00 27,343.00 29,000.00 .00 29,000.00 610-53-0404-000 AMORTIZATION EXPENSE 1,029.00 .00 .00 .00 .00 610-53-0408-000 WATER DEPARTMENT-FICA 5,299.00 5,810.85 5,442.00 5,148.48 5,544.00 610-53-0408-100 WATER DEPARTMENT-TAX EQUIVALE 70,000.00 76,466.04 73,304.00 62,644.67 76,500.00 610-53-0427-000 INTEREST ON LONG TERM DEBT-FHA 16,770.00 11,638.68 7,630.68 11,459.29 10,349.11 610-53-0600-000 WATER DEPARTMENT-WAGES 57,580.00 59,189.11 59,299.00 51,909.78 60,794.00 610-53-0600-125 WATER DEPARTMENT-VAC PAYOUT 1,183.95 2,015.00 .00 .00 .00 610-53-0600-140 WATER DEPARTMENT-INSURANCE 3,600.00 3,150.00 .00 1,917.03 .00 610-53-0620-000 PURCHASED POWER 10,000.00 10,569.89 10,000.00 7,647.48 9,500.00 610-53-0630-000 CHEMICALS 7,000.00 6,647.50 7,000.00 7,523.54 7,500.00 610-53-0640-000 OPERATING SUPPLIES & EXPENSE 9,000.00 11,520.70 8,000.00 10,706.96 11,400.00 610-53-0640-220 UTILITY SERVICES .00 172.64 1,000.00 931.83 1,100.00 610-53-0640-311 COMPUTER SUPPORT .00 540.35 .00 .00 .00 610-53-0650-000 REPAIR TO WATER PLANT 10,000.00 5,506.11 7,000.00 3,530.63 10,000.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 25 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 610-53-0660-000 TRANSPORTATION EXPENSE 3,500.00 2,984.12 3,500.00 2,809.74 3,000.00 610-53-0670-000 WATER DEPARTMENT-CAPITAL EQUIP 35,200.00 355.86 42,830.00 30,807.85 13,889.00 610-53-0670-100 WATER DEPTARTMENT-CAPITAL IMPR 8,200.00 949.00 235,000.00 96,524.65 .00 610-53-0670-811 WATER DEPARTMENT-CAPITAL CARR 7,500.00 .00 15,000.00 35,911.12 .00 610-53-0680-000 WATER DEPARTMENT-ADMIN SALARY 11,692.00 11,435.22 11,927.00 12,872.79 11,680.00 610-53-0680-140 WATER DEPARTMENT-ADMIN INSURA .00 .00 .00 160.72 .00 610-53-0681-000 OFFICE SUPPLIES & EXPENSE 5,000.00 7,362.38 4,400.00 2,397.87 2,500.00 610-53-0682-000 OUTSIDE PROFESSIONAL SERVICES 22,000.00 13,811.25 11,500.00 2,882.18 10,000.00 610-53-0682-100 WATER DEPARTMENT-COMPUTER SU 1,500.00 405.20 200.00 2,441.71 3,750.00 610-53-0682-200 INDEPENDENT AUDITING .00 .00 10,500.00 8,558.39 10,000.00 610-53-0683-000 CELL PHONE & ALARM CHARGES .00 818.83 800.00 448.98 800.00 610-53-0684-000 INSURANCE EXPENSE .00 .00 .00 .00 7,413.00 610-53-0686-000 EMP PENSION/HEALTH/LIFE WATER 25,678.00 25,429.33 26,382.00 21,258.05 28,245.00 610-53-0686-100 WORKERS COMPENSATION INSURAN .00 .00 .00 .00 1,102.00 610-53-0688-000 REGULATORY COMMISSION EXPENS 125.00 124.75 125.00 125.00 125.00 610-53-0689-000 MISCELLANEOUS GENERAL EXPENS 2,000.00 594.98 2,000.00 .00 .00 610-53-0689-100 WATER DEPARTMENT-UNIFORM ALL 700.00 740.64 350.00 243.49 350.00 DEBT SERVICE 610-58-5917-610 PRINCIPAL DEBT SERVICE 30,800.42 .00 26,972.00 .00 28,081.99 WATER DEPARTMENT FUND Revenue Total: 401,489.00 405,115.01 630,249.00 316,916.87 395,794.00 WATER DEPARTMENT FUND Expenditure Total: 439,431.37 357,261.43 674,161.68 380,862.23 417,623.10 Net Total WATER DEPARTMENT FUND: 37,942.37- 47,853.58 43,912.68- 63,945.36- 21,829.10- CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 26 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 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 ON TEMP INVEST 300.00 2,287.90 2,700.00 576.46 205.00 620-41-4210-000 RESIDENTIAL REVENUE 360,000.00 358,655.68 360,000.00 287,503.56 360,000.00 620-41-4220-000 COMMERCIAL REVENUE 87,000.00 92,320.20 87,000.00 64,726.02 87,000.00 620-41-4230-000 INDUSTRIAL REVENUE 130,000.00 145,425.89 130,000.00 97,964.29 130,000.00 620-41-4240-000 PUBLIC AUTHORITY REVENUE 12,000.00 11,907.00 12,000.00 7,999.80 12,000.00 620-41-4720-000 FUNDS APPLIED 7,500.00 .00 .00 .00 82,500.00 620-41-6320-000 PENALTIES 1,500.00 3,280.23 1,500.00 623.37 1,500.00 620-41-6340-000 MISC. OPERATING REVENUES 3,500.00 11,236.15 3,500.00 11,240.50 9,250.00 Total SEWER SALES REVENUE: 601,800.00 625,113.05 596,700.00 470,634.00 682,455.00 PUBLIC WORKS 620-53-0082-000 SEWER DEPARTMENT-WAGES 54,600.00 48,519.82 55,414.00 60,371.61 63,622.00 620-53-0082-125 SEWER DEPARTMENT-VAC PAYOUT 1,183.95 1,954.79 .00 .00 .00 620-53-0082-140 SEWER DEPT/INS/DISABLE/DENTAL .00 .00 .00 1,475.25 .00 620-53-0403-000 DEPRECIATION OF EXPENSE 144,695.00 158,837.00 156,000.00 .00 159,000.00 620-53-0408-000 SEWER DEPARTMENT-FICA 5,071.00 5,006.55 5,145.00 4,710.56 5,761.00 620-53-0427-000 INTEREST ON LONG TERM DEBT 44,891.00 35,411.67 43,910.00 30,796.63 33,945.31 620-53-0620-000 POWER PURCHASED FOR PUMPING 17,000.00 18,658.71 17,000.00 12,041.49 16,000.00 620-53-0826-000 CELL PHONE & ALARM CHARGES .00 1,221.69 1,100.00 754.82 1,100.00 620-53-0827-000 OPERATING SUPPLIES & EXPENSE 17,000.00 18,856.74 15,200.00 5,599.93 7,000.00 620-53-0827-220 UTILITY SERVICES .00 294.63 1,800.00 1,975.74 2,500.00 620-53-0827-311 COMPUTER SUPPORT .00 540.34 .00 .00 .00 620-53-0828-000 TRANSPORTATION EXPENSE 3,500.00 2,821.42 3,500.00 2,268.58 3,000.00 620-53-0829-000 SEWER DEPARTMENT-CAPITAL EQUI 69,300.00 355.87 29,330.00 32,380.70 13,889.00 620-53-0829-100 SEWER DEPARTMENT-CAPITAL IMPR .00 .00 .00 .00 82,500.00 620-53-0829-811 SEWER DEPARTMENT-CAPITAL CARR .00 .00 .00 46,978.88 .00 620-53-0831-000 MAINT OF SEWERAGE COLL SYSTEM .00 .00 .00 4,977.46 6,000.00 620-53-0832-000 MAINT OF PUMP STATION EQUIP 8,000.00 4,694.76 8,000.00 29,275.84 8,000.00 620-53-0833-000 MAINT OF CHALET GRINDER PUMP 500.00 .00 500.00 1,080.86 1,000.00 620-53-0834-000 MAINT/REPAIR BLDGS & GROUNDS 500.00 2,838.50 1,000.00 1,818.04 1,500.00 620-53-0850-000 SEWER DEPARTMENT-ADMIN SALARI 11,692.00 11,409.20 11,927.00 12,872.79 11,680.00 620-53-0850-140 SEWER DEPARTMENT-OFF WAGES/IN .00 .00 .00 160.73 .00 620-53-0851-000 GEN OFFICE SUPPLIES & EXPENSE 4,500.00 3,175.14 4,500.00 2,680.29 3,500.00 620-53-0851-100 FLWCC BUDGET EXPENSE 120,000.00 132,487.74 120,000.00 97,180.00 120,000.00 620-53-0851-101 FLWCC FUTURE RESERVE FUND 20,000.00 .00 .00 .00 .00 620-53-0851-102 FLWCC COPPER SURCHARGE 1,000.00 1,119.65- 1,000.00 .00 1,000.00 CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 27 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 Prior Year Prior Year Approved Current year Beginning Account Number Account Title Budget Actual Budget Actual Budget 620-53-0851-103 FLWCC SLUDGE REMOVAL/LINER .00 23,438.00 56,250.00 36,062.50 56,250.00 620-53-0852-000 OUTSIDE PROFESSIONAL SERVICES 18,000.00 13,905.23 7,500.00 2,364.71 7,600.00 620-53-0852-100 SEWER DEPARTMENT-COMPUTER S 1,500.00 557.85 500.00 2,506.19 3,750.00 620-53-0852-200 INDEPENDENT AUDITING .00 .00 10,200.00 7,945.90 9,500.00 620-53-0853-000 INSURANCE EXPENSE .00 .00 .00 .00 7,427.00 620-53-0854-000 EMP PENSION/BENEFIT/HEALTH/LIF 25,678.00 23,620.92 26,382.00 20,069.06 28,882.00 620-53-0854-100 WORKERS COMPENSATION INSURAN .00 .00 .00 .00 1,102.00 620-53-0856-000 MISC. GENERAL EXPENSE 500.00 94.97 .00 .00 .00 620-53-0856-100 SEWER DEPARTMENT-UNIFORM ALL 700.00 740.64 350.00 243.50 350.00 620-53-0857-000 RENT 10,000.00 .00 10,000.00 .00 .00 DEBT SERVICE 620-58-5917-610 PRINCIPAL DEBT SERVICE 51,226.00 .00 52,606.00 .00 52,606.00 SEWER DEPARTMENT FUND Revenue Total: 601,800.00 625,113.05 596,700.00 470,634.00 682,455.00 SEWER DEPARTMENT FUND Expenditure Total: 631,036.95 508,322.53 639,114.00 418,592.06 708,464.31 Net Total SEWER DEPARTMENT FUND: 29,236.95- 116,790.52 42,414.00- 52,041.94 26,009.31- CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 28 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 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 400.00 5,330.01 300.00 641.40 1,190.00 Total MISCELLANEOUS REVENUE: 400.00 5,330.01 300.00 641.40 1,190.00 DEBT SERVICE 701-58-5800-000 TRANSFER OUT .00 .00 7,400.00 7,400.00 3,000.00 CEMETERY NONEXP TRUST FUND Revenue Total: 400.00 5,330.01 300.00 641.40 1,190.00 CEMETERY NONEXP TRUST FUND Expenditure Total: .00 .00 7,400.00 7,400.00 3,000.00 Net Total CEMETERY NONEXP TRUST FUND: 400.00 5,330.01 7,100.00- 6,758.60- 1,810.00- CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 29 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 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 40.00 153.39 40.00 74.89 75.00 Total MISCELLANEOUS REVENUE: 40.00 153.39 40.00 74.89 75.00 OTHER FINANCING USES 802-59-5900-390 MISCELLANEOUS EXPENSE 40.00 200.00 150.00 225.00 200.00 ROBERTS EXP TRUST FUND Revenue Total: 40.00 153.39 40.00 74.89 75.00 ROBERTS EXP TRUST FUND Expenditure Total: 40.00 200.00 150.00 225.00 200.00 Net Total ROBERTS EXP TRUST FUND: .00 46.61- 110.00- 150.11- 125.00- CITY OF FOX LAKE Budget Worksheet - All Accounts with Balances & Activity Page: 30 Period: 10/20 Oct 30, 2020 03:00PM 2019-19 2019-19 2020-20 2020-20 2021-21 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-4372-000 COUNTY AID .00 2,799.73 5,746.61 .00 .00 Total INTERGOVERNMENTAL REVENUES: .00 2,799.73 5,746.61 .00 .00 MISCELLANEOUS REVENUE 804-48-4810-000 INTEREST 20,000.00 64,764.45 25,000.00 7,818.70 15,000.00 804-48-4850-000 DONATIONS 4,000.00 10,321.38 4,000.00 11,570.00 4,000.00 804-48-4890-000 LIBRARY MISCELLANEOUS REVENUE .00 .00 .00 744.43 500.00 Total MISCELLANEOUS REVENUE: 24,000.00 75,085.83 29,000.00 20,133.13 19,500.00 CULTURE,RECREATION & EDUCATION 804-55-5500-000 LIBRARY EXPENDITURES 15,000.00 5,549.47 12,000.00 7,614.97 5,000.00 LIBRARY S/R FUND Revenue Total: 24,000.00 77,885.56 34,746.61 20,133.13 19,500.00 LIBRARY S/R FUND Expenditure Total: 15,000.00 5,549.47 12,000.00 7,614.97 5,000.00 Net Total LIBRARY S/R FUND: 9,000.00 72,336.09 22,746.61 12,518.16 14,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