2024-08-13 VB Packet

VILLAGE OF MAPLE BLUFF DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 100 - GENERAL FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 1 TAXES 100-41-40411-000 GENERAL PROPERTY TAXES 3,735,751.00 0 0 0 0 100-41-40413-000 WATER UTILITY TAX EQUIVALENT 80,000.00 0 0 0 0 TOTAL TAXES 3,815,751.00 0 0 0 0 INTERGOVERNMENTAL REVENUE 100-43-41432-000 STATE EXPENDITURE RESTRAINT 56,468.00 0 0 0 0 100-43-41433-000 STATE SHARED REVENUES 70,910.00 0 0 54,349 0 100-43-41434-000 FIRE DUES DISTRIBUTION 15,000.00 0 0 16,028 0 100-43-41435-000 LOCAL TRANSPORTATION AIDS 192,277.00 0 96,139 160,231 50 100-43-41436-000 PAYMENTS FOR MUNICIPAL SERVICE 5,824.00 0 5,802 4,603 100 100-43-41437-000 RECYCLING & DISASTER GRANTS 31,000.00 0 31,478 31,432 102 100-43-41440-000 EXEMPT COMPUTER AID 136.00 0 0 136 0 100-43-41446-000 FEMA ARPA GRANT .00 0 0 1,914 0 100-43-41454-000 PERSONAL PROPERTY AID 2,659.00 0 2,659 2,659 100 100-43-41460-000 STORMWATER PROJECT YRLY PMT 7,971.00 0 0 7,971 0 100-43-41461-000 STORMWATER PROJECT YRLY INT 1,790.00 0 0 2,391 0 100-43-43210-000 FED JAG RMS GRANT .00 0 0 3,295 0 100-43-44430-000 AMBULANCE FUNDING ASSIST GRAN .00 0 0 55,128 0 TOTAL INTERGOVERNMENTAL REVE 384,035.00 0 144,916 340,138 38 LICENSES & PERMITS 100-44-42440-000 LIQUOR LICENSE FEES 3,000.00 3,470 3,470 2,850 116 100-44-42441-000 CABLE TV FRANCHISE FEE 20,000.00 530 7,088 11,691 35 100-44-42442-000 CAT/DOG LICENSES 2,000.00 130 4,190 3,033 210 100-44-42443-000 BUILDING PERMITS 30,000.00 3,205 22,214 24,568 74 100-44-42444-000 OPERATORS LICENSES 700.00 240 270 640 39 100-44-42445-000 SELLERS/SOLICITOR PERMITS 50.00 0 0 0 0 100-44-42446-000 CIGARETTE LICENSES 200.00 300 400 200 200 100-44-42447-000 BIKE LICENSES .00 0 3 3 0 TOTAL LICENSES & PERMITS 55,950.00 7,875 37,635 42,985 67 FINES & FORFEITURES 100-45-43451-000 LAW/ORDINANCE VIOLATIONS 25,000.00 1,507 12,621 16,087 50 TOTAL FINES & FORFEITURES 25,000.00 1,507 12,621 16,087 50 VILLAGE OF MAPLE BLUFF DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 100 - GENERAL FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 2 PUBLIC CHARGES FOR SERVICES 100-46-46435-000 RECYCLING 34,500.00 0 6,421 14,479 19 TOTAL PUBLIC CHARGES FOR SERVI 34,500.00 0 6,421 14,479 19 MISCELLANEOUS REVENUE 100-48-44489-000 OTHER REVENUES 15,000.00 50 88,154 33,159 588 100-48-45485-000 SUMMER PROGRAMS REGISTRATION 2,300.00 0 0 1,410 0 100-48-45490-000 ARTS & ATHLETICS PROGRAM 11,000.00 0 15,225 10,375 138 100-48-45491-000 OUTDOOR CO REGISTRATION FEES 2,500.00 0 0 3,020 0 100-48-45492-000 CAMP YAGOTTAWANNA TUITION 23,500.00 25 29,845 23,315 127 100-48-45493-000 WINTERFEST 1,500.00 0 1,080 1,844 72 100-48-45494-000 GYM & ROOM RESERVATION FEES 4,500.00 90 3,367 3,004 75 100-48-45495-000 FEST ON THE 4TH 2,500.00 875 1,925 2,690 77 100-48-45497-000 BEACH HOUSE RESERVATION FEES 4,500.00 415 3,174 4,873 71 100-48-45498-000 VILLAGE CENTER & OPEN GYM PRO 11,000.00 560 10,821 8,828 98 100-48-45499-000 BOCCE BASH 40,000.00 375 73,154 62,840 183 100-48-45500-000 SALES TAX .00 ( 323) 60 204 0 100-48-45502-000 SPECIAL EVENT FEES 8,000.00 1,190 11,552 8,925 144 100-48-45511-000 DAILEY CABIN RESERVATION FEES 1,000.00 0 299 820 30 100-48-45512-000 NEWSLETTER ADVERTISING 10,000.00 0 5,400 9,600 54 100-48-45513-000 PARKS KEY FOB REVENUE 5,500.00 80 8,304 5,460 151 100-48-45520-000 FLAG FOOTBALL REVENUE 1,763.00 0 0 0 0 100-48-45530-000 BASKETBALL REVENUE 3,000.00 0 250 250 8 100-48-46485-000 SALE OF PROPERTY .00 0 2,500 0 0 100-48-47482-000 M.B.C.C. RENT 115,000.00 9,681 76,302 79,099 66 100-48-47486-000 BOAT STORAGE FEES 44,000.00 0 51,097 42,193 116 100-48-47487-000 AT THE DOOR REFUSE FEE 1,350.00 0 1,368 1,398 101 100-48-47489-000 APPLIANCE DISPOSAL FEE 2,000.00 50 675 1,060 34 100-48-48481-000 INTEREST ON INVESTMENTS 40,000.00 0 93,026 106,740 233 TOTAL MISCELLANEOUS REVENUE 349,913.00 13,067 477,576 411,108 136 OTHER FINANCING SOURCES 100-49-49493-000 SURPLUS/FUND BALANCE APPLIED 85,613.00 0 0 0 0 TOTAL OTHER FINANCING SOURCES 85,613.00 0 0 0 0 TOTAL FUND REVENUE 4,750,762.00 22,449 679,169 824,796 14 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 100 - GENERAL FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 3 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 100 - GENERAL FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 4 GENERAL GOVERNMENT VILLAGE BOARD 100-51-11110-310 VILLAGE BOARD - SUPPLIES & EXP 6,000 4,279 5,985 9,121 100 100-51-11110-320 VILLAGE BOARD SUBSCRIPTIONS 3,800 0 2,075 2,488 55 TOTAL VILLAGE BOARD 9,800 4,279 8,059 11,609 82 COURT CLERK 100-51-12110-110 COURT CLERK SALARY 26,602 1,764 12,372 11,650 47 100-51-12110-128 COURT CLERK EMPLOYEE BENEFITS0 300 2,074 1,957 0 100-51-12110-129 EMPLOYEE SHARE RETIREMENT 0 153 918 980 0 100-51-12110-130 COURT CLERK WIS. RETIREMENT 1,836 153 918 980 50 100-51-12110-131 COURT CLERK & JUDGE EMPLR SS 2,265 172 1,206 1,118 53 100-51-12110-132 COURT CLERK EMPLR LIFE INS 57 5 34 33 59 100-51-12110-133 COURT CLERK EMPLR HEALTH INS 8,991 749 5,245 4,934 58 100-51-12110-135 COURT CLERK DENTAL INSURANCE 720 29 202 202 28 100-51-12110-140 MUNICIPAL JUDGE SALARY 3,000 250 1,750 1,400 58 100-51-12110-310 COURT - SUPPLIES/EXPENSES 1,800 0 1,251 1,200 70 100-51-12110-320 COURT - SEMINARS/TRAINING 2,000 681 1,856 1,530 93 TOTAL COURT CLERK 47,271 4,256 27,824 25,983 59 LEGAL SERVICES 100-51-13130-210 LEGAL SERVICES 15,000 1,211 13,866 31,518 92 100-51-13130-211 JUDICIAL LEGAL SERVICES 9,000 259 3,160 3,063 35 TOTAL LEGAL SERVICES 24,000 1,470 17,026 34,581 71 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 100 - GENERAL FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 5 VILLAGE ADMINISTRATION 100-51-14141-110 ADMINISTRATIVE SALARIES - FT 229,117 19,376 134,919 115,739 59 100-51-14141-120 ADMINISTRATIVE SALARIES - PT 24,000 1,295 10,342 10,287 43 100-51-14141-128 ADMIN EMPLOYEE BENEFITS 0 922 6,393 6,624 0 100-51-14141-129 EMPLOYEE SHARE RETIREMENT 0 1,544 9,267 8,977 0 100-51-14141-130 WISCONSIN RETIREMENT 17,212 1,544 9,266 8,977 54 100-51-14141-131 EMPLR SOC SEC/MEDICARE 19,363 1,711 12,048 10,482 62 100-51-14141-132 EMPLR LIFE INS 165 16 104 95 63 100-51-14141-133 EMPLR HEALTH 59,339 3,465 24,257 17,534 41 100-51-14141-135 DENTAL INS 4,724 298 2,084 1,842 44 100-51-14141-136 ADMIN EMPLOYEE ASST PROG 1,000 0 0 325 0 100-51-14141-210 VILLAGE PLANNER 8,000 1,723 7,466 0 93 100-51-14141-310 SUPPLIES & EXPENSES 6,500 0 3,104 5,101 48 100-51-14141-320 SUBCRIPTIONS & DUES 500 0 1,775 1,564 355 100-51-14141-330 SEMINARS & TRAINING 6,000 0 758 375 13 100-51-14141-340 CLERK/TREAS MILEAGE 500 0 0 36 0 100-51-14141-350 MISC COMPENSATION 6,000 0 4,796 1,832 80 TOTAL VILLAGE ADMINISTRATION 382,420 31,894 226,578 189,789 59 ELECTIONS 100-51-14144-140 ELECTION PERSONNEL 5,000 0 1,225 1,311 25 100-51-14144-310 ELECTION EXPENSES 3,500 60 1,225 1,900 35 TOTAL ELECTIONS 8,500 60 2,450 3,211 29 ACCOUNTING SERVICES 100-51-15151-210 AUDIT SERVICES 34,000 0 30,103 30,713 89 TOTAL ACCOUNTING SERVICES 34,000 0 30,103 30,713 89 ASSESSMENT OF PROPERTY 100-51-15153-210 ASSESSMENT SERVICES 13,000 1,003 7,114 6,976 55 TOTAL ASSESSMENT OF PROPERTY 13,000 1,003 7,114 6,976 55 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 100 - GENERAL FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 6 GENERAL BUILDINGS/PLANT 100-51-16160-200 COMMUNICATIONS SPLIT 9,000 719 5,196 5,114 58 100-51-16160-201 VILLAGE OFFICE SUPPLIES SPLIT 6,000 272 3,781 3,881 63 100-51-16160-220 GENL BLDG & PLANT UTILITIES SP 35,000 4,910 20,727 20,006 59 100-51-16160-240 MAINTENANCE CONTRACTS SPLIT 16,000 2,477 10,423 10,794 65 100-51-16160-340 GEN BLDG EQUIP PURCH/MAINT SPL 10,000 942 4,932 4,481 49 100-51-16160-341 GEN BLDG MAINT SUPPLIES SPLIT 2,000 0 209 1,376 10 100-51-16160-342 VILLAGE CNT OUTDOOR MAINT SPL 1,000 0 0 0 0 100-51-16160-350 GEN BLDG CLEANING SUPPLIES SPL 3,500 124 901 3,361 26 100-51-16160-360 COMPUTER MAINT/SUPPORT SPLIT 45,000 3,353 19,344 16,820 43 100-51-16160-365 WEB PAGE MAINT/SUPPORT SPLIT 2,000 0 407 592 20 100-51-16160-375 VILLAGE CODE EXPENSES SPLIT 2,500 439 439 0 18 TOTAL GENERAL BUILDINGS/PLANT 132,000 13,236 66,359 66,425 50 OTHER GENERAL GOVERNMENT 100-51-19190-291 GEN GOV PUBLICATIONS/MAILINGS 12,000 1,983 8,742 7,764 73 100-51-19190-292 VILLAGE DIRECTORY EXPENSE 3,500 0 0 0 0 100-51-19190-400 INS-GENERAL LIABILITY 45,413 0 0 0 0 100-51-19190-405 INS-CRIME 961 0 0 0 0 100-51-19190-407 INS-VOLUNTEER FIREFIGHTERS 1,300 0 0 0 0 100-51-19190-408 INS-WORKERS COMPENSATION 46,914 0 0 0 0 100-51-19190-409 INS-CYBER 2,760 0 0 0 0 100-51-19190-510 GEN GOV PROP/LIABILITY INS. 12,573 0 0 0 0 100-51-19190-520 DOG LICENSE PMT TO COUNTY 1,600 0 0 50 0 100-51-19190-530 BUILDING INSPECTION EXPENSES 24,000 1,526 14,526 18,071 61 100-51-19190-570 COVID-19 0 0 0 202 0 TOTAL OTHER GENERAL GOVERNME 151,021 3,509 23,268 26,087 15 TOTAL GENERAL GOVERNMENT 802,012 59,706 408,780 395,374 51 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 100 - GENERAL FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 7 PUBLIC SAFETY LAW ENFORCEMENT 100-52-21210-110 POLICE SALARIES 610,765 50,630 324,649 298,265 53 100-52-21210-111 POLICE SALARIES - OVERTIME 15,000 0 0 0 0 100-52-21210-120 POLICE WAGES (PARTTIME) 100,000 7,785 46,822 48,674 47 100-52-21210-128 POLICE EMPLOYEE BENEFITS 0 2,244 18,092 13,120 0 100-52-21210-129 EMPLOYEE SHARE RETIREMENT 0 3,884 21,389 21,993 0 100-52-21210-130 POLICE WIS RETIREMENT 87,462 8,060 44,389 42,487 51 100-52-21210-131 POLICE EMPLR SOCIAL SECURITY 55,521 4,846 31,018 28,878 56 100-52-21210-132 POLICE EMPLR LIFE INSURANCE 254 23 146 107 57 100-52-21210-133 POLICE EMPLR HEALTH INSURANCE 161,460 9,234 63,070 41,748 39 100-52-21210-135 POLICE DENTAL INSURANCE 12,600 634 4,366 3,718 35 100-52-21210-220 COMMUNICATIONS 5,500 541 2,509 2,801 46 100-52-21210-225 POLICE RECORDS MANAGEMENT 8,500 0 0 3,851 0 100-52-21210-226 POLICE RECORDS MGMT GRANT EXP0 0 0 13,636 0 100-52-21210-300 POLICE UNIFORMS 9,250 616 3,383 2,844 37 100-52-21210-310 POLICE SUPPLIES/EXPENSES 9,000 33 1,400 1,606 16 100-52-21210-320 POLICE SUBSCRIPTIONS/DUES 12,000 219 10,280 9,140 86 100-52-21210-330 POLICE SEMINARS/TRAINING 7,500 1,320 4,521 1,294 60 100-52-21210-331 POLICE - RECRUITMENT/RETENTION 15,000 1,214 5,292 7,415 35 100-52-21210-335 RADIO/POLICY CONTRACTS 4,000 0 2,003 1,041 50 100-52-21210-340 POLICE EQUIPMENT PURCHASES 3,500 0 124 1,023 4 100-52-21210-350 POLICE EQUIP MAINTENANCE 1,000 0 41 835 4 100-52-21210-360 POLICE VEHICLE MAINTENANCE 4,000 135 945 6,305 24 100-52-21210-370 POLICE GAS AND OIL 15,000 1,434 8,115 8,735 54 100-52-21210-530 PUBLIC RELATIONS 1,000 0 0 0 0 100-52-21210-545 POLICE GENERAL GRANT EXPENSES0 0 0 6,888 0 TOTAL LAW ENFORCEMENT 1,138,312 92,852 592,554 566,407 52 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 100 - GENERAL FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 8 FIRE PROTECTION 100-52-22220-110 FIRE SALARIES 282,558 17,364 120,202 144,090 43 100-52-22220-120 FIRE PT WAGES/STIPEND 109,158 24,159 111,878 83,844 102 100-52-22220-128 FIRE EMPLOYEE BENEFITS 0 836 4,718 5,559 0 100-52-22220-129 EMPLOYEE SHARE RETIREMENT 0 1,325 9,075 11,487 0 100-52-22220-130 FIRE WISCONSIN RETIREMENT 54,025 3,671 25,148 30,399 47 100-52-22220-131 FIRE EMPLR SOCIAL SECURITY 12,448 2,130 10,556 8,746 85 100-52-22220-132 FIRE EMPLR LIFE INSURANCE 93 3 19 19 21 100-52-22220-133 FIRE EMPLR HEALTH INSURANCE 89,908 3,746 20,604 24,671 23 100-52-22220-135 FIRE DENTAL INSURANCE 7,200 220 1,121 1,538 16 100-52-22220-220 CELL PHONE COMMUNICATIONS 2,400 182 1,274 2,659 53 100-52-22220-224 RADIO & PAGER BATTERY REPLACE 500 0 0 0 0 100-52-22220-225 RADIO & PAGER BATTERY MAINT 3,000 89 89 0 3 100-52-22220-300 FIRE UNIFORMS 3,350 262 2,379 3,079 71 100-52-22220-305 FIRE SOFTWARE SUPPORT 10,660 0 8,430 4,819 79 100-52-22220-310 FIRE SUPPLIES/EXPENSES 1,500 20 404 224 27 100-52-22220-315 EMS SUPPLIES & EXPENSES 3,000 93 93 67 3 100-52-22220-320 FIRE SUBSCRIPTIONS/DUES 1,600 500 1,015 4,221 63 100-52-22220-329 FIRE EDUCATION REIMB 16,000 ( 1,000) 1,472 999 9 100-52-22220-330 FIRE SEMINARS/TRAINING 19,100 312 10,347 11,749 54 100-52-22220-331 FIRE RECRUITMENT 1,600 0 996 2,421 62 100-52-22220-335 FIRE AWARDS BANQUET 2,500 0 431 0 17 100-52-22220-336 FIRE MEETING EXPENSES 1,500 ( 230) 382 567 25 100-52-22220-340 FIRE EQUIPMENT PURCHASES 30,400 1,342 19,302 27,974 63 100-52-22220-345 FIRE - COMPRESSED AIR SUPPLY 700 647 897 250 128 100-52-22220-350 FIRE EQUIPMENT MAINTENANCE 7,150 657 2,015 1,341 28 100-52-22220-360 FIRE VEHICLE MAINTENANCE 11,000 3,968 7,914 11,142 72 100-52-22220-370 FIRE GAS AND OIL 3,350 391 1,353 2,304 40 100-52-22220-380 FIRE - HEALTH & WELLNESS 800 65 65 0 8 100-52-22220-390 FIRE - PREVENTION 800 0 1,195 96 149 100-52-22220-520 FIRE SERVICE AWARD PROGRAM 8,000 0 0 0 0 TOTAL FIRE PROTECTION 684,300 60,751 363,375 384,266 53 EMS 100-52-23230-230 AMBULANCE EXPENSES 0 0 0 4,258 0 TOTAL EMS 0 0 0 4,258 0 TOTAL PUBLIC SAFETY 1,822,612 153,602 955,928 954,931 52 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 100 - GENERAL FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 9 PUBLIC WORKS HIGHWAY/STREET ADMINISTRATION 100-53-31310-110 STREETS-SALARIES 59,057 12,260 37,681 32,164 64 100-53-31310-111 STREET SALARIES - OVERTIME 1,500 0 0 0 0 100-53-31310-120 STREETS SALARIES - PART TIME 4,800 0 1,380 3,593 29 100-53-31310-128 STREETS EMPLOYEE BENEFITS 0 101 1,985 2,439 0 100-53-31310-129 EMPLOYEE SHARE RETIREMENT 0 339 2,022 2,447 0 100-53-31310-130 STREETS WISCONSIN RETIREMENT 4,075 339 2,022 2,447 50 100-53-31310-131 STREETS EMPLR SOCIAL SECURITY 5,000 1,011 3,250 3,020 65 100-53-31310-132 STREETS EMPLR LIFE INSURANCE 70 7 44 43 63 100-53-31310-133 STREETS EMPLR HEALTH INSURANC 19,106 375 8,046 6,080 42 100-53-31310-135 STREETS DENTAL INSURANCE 1,530 36 374 467 24 100-53-31310-210 COMMUNICATIONS 1,700 82 575 544 34 100-53-31310-215 DOT MANDATORY DRUG TESTING 400 0 422 929 105 100-53-31310-225 PUBLIC WORKS SEMINARS/TRAINING 5,000 0 3,000 0 60 100-53-31310-230 STREET MAINTENANCE/CONSTRUCT. 30,000 0 240 4,298 1 100-53-31310-235 SIDEWALK MAINTENANCE 10,000 0 0 0 0 100-53-31310-240 SNOW/ICE REMOVAL 6,800 0 4,236 3,789 62 100-53-31310-250 STREET SIGNS 2,000 0 1,167 118 58 100-53-31310-260 STREET LIGHTING 20,000 898 5,858 6,114 29 100-53-31310-300 ENGINEERING SERVICES 4,500 0 0 0 0 100-53-31310-340 STORM WATER DISCHARGE PERMIT 10,000 0 5,092 8,129 51 100-53-31310-345 STORM WATER MAINTENANCE 12,000 1,305 10,158 1,714 85 100-53-31310-360 STREETS EQUIP/TRUCK MAINTENCE 7,000 0 3,701 1,827 53 100-53-31310-370 STREET - GAS & OIL 6,000 489 2,782 2,739 46 TOTAL HIGHWAY/STREET ADMINISTR 210,538 17,242 94,035 82,901 45 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 100 - GENERAL FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 10 SOLID WASTE DISPOSAL 100-53-36363-110 SOLID WASTE DISPOSAL SALARIES 162,408 13,233 83,140 88,268 51 100-53-36363-111 SOLID WASTE DISPOSAL OVERTIME 4,500 0 0 0 0 100-53-36363-120 SOLID WASTE DISPOSAL P-T WAGES 13,500 0 3,795 7,190 28 100-53-36363-128 SOLID WASTE EMPLOYEE BENEFITS0 247 5,375 6,892 0 100-53-36363-129 EMPLOYEE SHARE RETIREMENT 0 933 5,562 6,730 0 100-53-36363-130 S.WASTE DISPOSAL WIS RETIREMNT 11,206 933 5,562 6,730 50 100-53-36363-131 S.WASTE DISPOSAL EMPLR SOC SEC 13,801 1,097 7,254 8,085 53 100-53-36363-132 S. WASTE DISPSL EMPLR LIFE INS 192 18 122 118 63 100-53-36363-133 S. WASTE DIS. EMPLR HEALTH INS 52,540 1,030 22,126 16,721 42 100-53-36363-135 S WASTE DISP DENTAL INSURANCE 4,208 100 836 1,539 20 100-53-36363-290 SOLID WASTE DISPOSAL 27,000 1,840 15,466 11,148 57 100-53-36363-291 RECYCLING FEES 32,000 2,514 15,393 15,215 48 100-53-36363-292 WHITE GOODS DISPOSAL FEES 900 0 0 360 0 100-53-36363-300 SOLID WASTE DISPOSAL-UNIFORMS 3,500 269 670 331 19 100-53-36363-310 S.WASTE DISP. SUPPLIES/EXPENSE 1,800 0 1,129 408 63 100-53-36363-360 S.WASTE EQUIP/TRUCK MAINTENCE 14,000 1,451 20,208 4,711 144 100-53-36363-370 S WASTE - GAS & OIL 2,250 144 1,068 1,160 47 TOTAL SOLID WASTE DISPOSAL 343,805 23,808 187,705 175,605 55 WEED/NUISANCE CONTROL 100-53-36364-240 LAKE WEED CONTROL 400 0 0 0 0 TOTAL WEED/NUISANCE CONTROL 400 0 0 0 0 TOTAL PUBLIC WORKS 554,743 41,051 281,739 258,506 51 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 100 - GENERAL FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 11 PARKS & CULTURE/PARKS PARKS 100-55-52520-110 PARKS SALARIES 44,293 3,609 22,674 24,073 51 100-55-52520-111 PARKS SALARIES - OVERTIME 1,100 0 0 0 0 100-55-52520-120 PARKS SALARIES - PART TIME 3,800 1,976 4,417 1,961 116 100-55-52520-128 PARKS EMPLOYEE BENEFITS 0 65 1,461 1,953 0 100-55-52520-129 EMPLOYEE SHARE RETIREMENT 0 254 1,517 1,835 0 100-55-52520-130 PARKS WISCONSIN RETIREMENT 3,056 254 1,517 1,835 50 100-55-52520-131 PARKS EMPLR SOCIAL SECURITY 3,763 450 2,237 2,205 59 100-55-52520-132 PARKS EMPLR LIFE INSURANCE 52 5 33 32 64 100-55-52520-133 PARKS EMPLR HEALTH INSURANCE 14,329 281 6,034 4,560 42 100-55-52520-135 PARKS DENTAL INSURANCE 1,148 27 228 420 20 100-55-52520-310 PARKS SUPPLIES/EXPENSES 7,000 2,074 4,195 4,586 60 100-55-52520-311 PARKS MAINTENANCE 15,000 1,013 2,837 6,169 19 100-55-52520-312 VILLAGE TRIANGLE EXPENSE 2,000 369 1,712 441 86 100-55-52520-320 FORESTRY EXPENSES 18,000 2,650 9,209 15,588 51 100-55-52520-325 FORESTRY GRANT EXPENSES 0 0 0 10,625 0 100-55-52520-360 PARKS - EQUIPMENT MAINTENANCE 2,000 0 1,319 22 66 100-55-52520-370 PARKS - GAS & OIL 6,000 939 4,183 4,335 70 TOTAL PARKS 121,541 13,967 63,574 80,641 52 CULTURE/PARKS 100-55-53530-110 CULTURE/PARKS WAGES FULL TIME 29,529 2,406 15,116 16,049 51 100-55-53530-111 CULTURE/PARKS WAGES - OVERTIME 700 0 0 0 0 100-55-53530-120 CULTURE/PARKS WAGES (PARTTIME) 2,400 0 690 1,307 29 100-55-53530-128 CULTURE/PARK EMPLOYEE BENEFIT0 43 974 1,270 0 100-55-53530-129 EMPLOYEE SHARE RETIREMENT 0 170 1,011 1,224 0 100-55-53530-130 CULTURE/PARKS WIS RETIREMENT 2,037 170 1,011 1,224 50 100-55-53530-131 CULTURE/PARKS EMPLR SOC SEC 2,496 199 1,319 1,470 53 100-55-53530-132 CULTURE/PARKS EMPLR LIFE INS 35 3 22 22 63 100-55-53530-133 CULTURE/PARKSEMPLR HEALTH INS. 9,553 187 4,023 3,040 42 100-55-53530-135 CULTURE/PARKS DENTAL INSURANC 765 18 152 280 20 100-55-53530-220 CULTURE/PARKS UTILITIES 2,000 711 1,572 642 79 100-55-53530-310 BEACH HOUSE SUPPLIES/EXPENSES 4,000 838 2,132 3,326 53 100-55-53530-311 DAILEY CABIN-SUPPLIES/EXPENSES 2,000 46 1,210 977 61 100-55-53530-312 HOLIDAY EXPENSES 1,200 0 0 0 0 100-55-53530-315 CULTURE/PARKS FIREWORKS 15,000 15,000 15,000 15,000 100 100-55-53530-340 CULTURE/PARKS HOIST INSTALL 13,100 0 0 1,460 0 TOTAL CULTURE/PARKS 84,815 19,791 44,233 47,290 52 TOTAL PARKS & CULTURE/PARKS 206,356 33,757 107,807 127,930 52 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 100 - GENERAL FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 12 RECREATION RECREATION PROGRAMS & EVENTS 100-56-53530-110 RECREATION DIRECTOR WAGES 63,290 4,921 33,072 31,756 52 100-56-53530-128 RECREATION EMPLOYEE BENEFITS0 223 1,531 944 0 100-56-53530-129 EMPLOYEE SHARE RETIREMENT 0 364 2,184 2,349 0 100-56-53530-130 RECREATION DIRECTOR RETIREMEN 4,367 364 2,184 2,349 50 100-56-53530-131 RECREATION DIRECTOR SOC SEC 4,842 410 2,760 2,645 57 100-56-53530-132 REC DIRECTOR LIFE INSURANCE 21 2 14 8 65 100-56-53530-133 REC DIRECTOR EMPLR HEALTH INS 16,858 1,405 9,834 9,251 58 100-56-53530-135 REC DIRECTOR EMPLR DENTAL INS 1,238 104 730 730 59 100-56-53530-140 REC DIRECTOR SEMINARS/TRAINING 2,000 150 1,790 70 89 100-56-53530-150 REC DIRECTOR SUPPLIES/EXPENSE 2,000 43 857 855 43 100-56-53530-152 REC VEHICLE MAINT/GAS/OIL 2,500 162 659 0 26 100-56-53530-155 RECREATION SOFTWARE 7,000 0 6,742 6,565 96 100-56-53530-170 SUMMER STAFF HIRING EXPENSES 1,000 170 287 1,271 29 100-56-53530-210 LIFEGUARD/SUMMER STAFF WAGES 33,000 14,489 27,676 20,883 84 100-56-53530-231 LIFEGUARD/SUMMER STAFF SOC SE 2,525 1,108 2,117 1,598 84 100-56-53530-240 SUMMER PROGRAM SUPPLIES/EXPE 800 0 0 1,200 0 100-56-53530-241 LIFEGUARD SUPPLIES & TRAINING 1,000 56 555 1,066 55 100-56-53530-242 ARTS & ATHLETICS SUPPLIES/EXP 1,500 816 966 1,920 64 100-56-53530-310 OUTDOOR COMPANY WAGES 300 0 0 0 0 100-56-53530-331 OUTDOOR COMPANY EMPLR SOC SE 23 0 0 0 0 100-56-53530-340 OUTDOOR CO SUPPLIES/EXPENSES 2,750 0 0 2,544 0 100-56-53530-410 CAMP YAGOTTAWANNA WAGES 28,000 8,113 13,062 13,304 47 100-56-53530-431 CAMP YAGOTTAWANNA SOC SEC 2,142 621 999 1,018 47 100-56-53530-440 CAMP YAGOTTAWANNA SUPPLIES/EX 3,000 200 1,191 1,683 40 100-56-53530-510 GYM SUPERVISOR WAGES 3,700 0 0 0 0 100-56-53530-531 GYM SUPERVISOR SOCIAL SECURIT 283 0 0 0 0 100-56-53530-532 GYM SUPPLIES & EXPENSES 500 0 0 268 0 100-56-53530-610 VILLAGE CENTER PROGRAM WAGES 5,000 0 450 0 9 100-56-53530-631 VILLAGE CENTER PROGRAM SOC SE 383 0 34 0 9 100-56-53530-632 SPECIAL EVENT SUPPLIES/EXPENSE 8,000 4,182 9,015 6,003 113 100-56-53530-640 VILLAGE CENTER PROGRAM EXPEN 4,000 0 6,827 4,735 171 100-56-53530-670 BEACH OPERATING LICENSE 180 0 190 180 106 100-56-53530-700 WINTERFEST SUPPLIES & EXPENSES 1,500 0 251 966 17 100-56-53530-710 4TH FEST SUPPLIES & EXPENSES 2,500 2,915 4,461 4,013 178 100-56-53530-720 BOCCE BASH SUPPLIES & EXPENSE 40,000 0 15,287 14,314 38 100-56-53530-800 FLAG FOOTBALL EXPENSES 700 0 0 0 0 100-56-53530-810 FLAG FOOTBALL WAGES 500 0 0 0 0 100-56-53530-831 FLAG FOOTBALL SOCIAL SECURITY 38 0 0 0 0 100-56-53530-900 BASKETBALL EXPENSES 2,100 0 1,369 1,569 65 100-56-53530-910 BASKETBALL WAGES 2,700 0 0 1,025 0 100-56-53530-931 BASKETBALL SOCIAL SECURITY 207 0 0 11 0 TOTAL RECREATION PROGRAMS & E 252,447 40,817 147,093 137,095 58 TOTAL RECREATION 252,447 40,817 147,093 137,095 58 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 100 - GENERAL FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 13 CAPITAL EQUIP OUTLAY BUDGET CAPITAL EQUIP OUTLAY 100-57-71712-810 CAPITAL EQUIPMENT OUTLAY 0 100,002 324,391 163,991 0 TOTAL CAPITAL EQUIP OUTLAY 0 100,002 324,391 163,991 0 TOTAL CAPITAL EQUIP OUTLAY BUDG 0 100,002 324,391 163,991 0 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 100 - GENERAL FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 14 CAPITAL PROJECTS BUDGET 100-58-82821-810 CAPITAL PROJECTS 0 0 225,172 0 0 100-58-82821-850 TRANS TO CAPITAL PROJECTS FUND0 0 710 0 0 TOTAL DEPARTMENT 82821 0 0 225,882 0 0 TOTAL CAPITAL PROJECTS BUDGET 0 0 225,882 0 0 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 100 - GENERAL FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 15 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 100 - GENERAL FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 16 TOTAL FUND EXPENDITURES 3,638,170 428,936 2,451,621 2,037,827 67 NET REVENUES OVER EXPENDITURE 1,112,592 ( 406,487) ( 1,772,452) ( 1,213,031) VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 200 - EMS FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACTUAL BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 17 200-46-46200-000 AMBULANCE TRANSPORT FEES 0 0 5,990 0 0 TOTAL SOURCE 46 0 0 5,990 0 0 SOURCE 48 200-48-46480-000 EMS FUNDING ASSISTANCE PROGRA0 0 6,860 0 0 TOTAL SOURCE 48 0 0 6,860 0 0 TOTAL FUND REVENUE 0 0 12,849 0 0 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 200 - EMS FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 18 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 200 - EMS FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 19 200-52-52300-200 AMBULANCE BILLING SERVICES 0 200 380 0 0 200-52-52300-340 EMS EQUIPMENT PURCHASES 0 0 791 33 0 200-52-52300-360 AMBULANCE MAINTENANCE 0 0 23 0 0 200-52-52300-365 EMS SUPPLIES & EXPENSES 0 75 2,888 4,281 0 200-52-52300-370 AMBULANCE GAS & OIL 0 80 454 486 0 TOTAL DEPARTMENT 52300 0 356 4,537 4,800 0 TOTAL COST CENTER 52 0 356 4,537 4,800 0 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 200 - EMS FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 20 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 200 - EMS FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 21 TOTAL FUND EXPENDITURES 0 356 4,537 4,800 0 NET REVENUES OVER EXPENDITURE 1,112,592 ( 406,842) ( 1,764,140) ( 1,217,832) VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 300 - CAPITAL PROJECTS FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACTUAL BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:37AM PAGE: 22 CAPITAL PROJECTS REVENUE 300-48-48510-000 VETERANS MEMORIAL DONATIONS 0 0 0 2,000 0 TOTAL CAPITAL PROJECTS REVENUE 0 0 0 2,000 0 TOTAL FUND REVENUE 0 0 0 2,000 0 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 300 - CAPITAL PROJECTS FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 23 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 300 - CAPITAL PROJECTS FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 24 CAPITAL PROJECTS EXPENSE CAPITAL PROJECT EXPENSE 300-58-82821-881 VETERANS MEMORIAL EXPENSE 0 295 295 542 0 300-58-82821-885 BEACH HOUSE PROJECT 0 0 0 ( 4,800) 0 300-58-82821-888 2023 WA/SEW/STORM IMPROVMENTS0 20,384 68,727 46,149 0 300-58-82821-889 ZONING RECODIFICATION 2023 0 0 15,277 4,968 0 300-58-82821-890 2024 JOHNSON PARK 0 5,698 181,191 0 0 TOTAL CAPITAL PROJECT EXPENSE 0 26,377 265,491 46,859 0 TOTAL CAPITAL PROJECTS EXPENSE 0 26,377 265,491 46,859 0 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 300 - CAPITAL PROJECTS FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 25 TOTAL FUND EXPENDITURES 0 26,377 265,491 46,859 0 NET REVENUES OVER EXPENDITURE 1,112,592 ( 433,220) ( 2,029,631) ( 1,262,690) VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 400 - DEBT SERVICE FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 26 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 400 - DEBT SERVICE FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 27 DEBT SERVICE EXPENSES 400-60-58000-365 PRINCIPAL PAYMENTS 0 0 486,902 442,404 0 400-60-58000-366 INTEREST AND FISCAL CHARGES 0 0 50,762 77,343 0 400-60-58000-367 PAYING AGENT FEES 0 475 2,700 2,700 0 TOTAL DEPARTMENT 58000 0 475 540,364 522,448 0 TOTAL DEBT SERVICE EXPENSES 0 475 540,364 522,448 0 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 400 - DEBT SERVICE FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 28 TOTAL FUND EXPENDITURES 0 475 540,364 522,448 0 NET REVENUES OVER EXPENDITURE 1,112,592 ( 433,695) ( 2,569,995) ( 1,785,138) VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 410 - FUND 410 ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACTUAL BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 29 SOURCE 43 410-43-41440-000 EXEMPT COMPUTER AID 0 0 0 255 0 410-43-41454-000 PERSONAL PROPERTY AID-TID 0 0 1,867 1,867 0 TOTAL SOURCE 43 0 0 1,867 2,122 0 TOTAL FUND REVENUE 0 0 1,867 2,122 0 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 410 - FUND 410 ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 30 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 410 - FUND 410 ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 31 410-60-50000-201 ENGINEERING/LEGAL EXPENSE 0 0 0 36 0 410-60-50000-202 DEVELOPER INCENTIVES 0 0 102,241 91,324 0 TOTAL DEPARTMENT 50000 0 0 102,241 91,360 0 TOTAL COST CENTER 60 0 0 102,241 91,360 0 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 410 - FUND 410 ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 32 COST CENTER 61 410-61-50000-300 MISCELLANEOUS EXPENSE 0 0 1,750 1,650 0 TOTAL DEPARTMENT 50000 0 0 1,750 1,650 0 TOTAL COST CENTER 61 0 0 1,750 1,650 0 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 410 - FUND 410 ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 33 TOTAL FUND EXPENDITURES 0 0 103,991 93,010 0 NET REVENUES OVER EXPENDITURE 1,112,592 ( 433,695) ( 2,672,119) ( 1,876,026) VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 600 - WATER UTILITY FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACTUAL BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 34 CHARGES FOR SERVICE 600-46-49400-000 WATER METERED SALES-RESIDENT0 0 94,530 207,917 0 600-46-49402-000 WATER METERED SALES-COMMERCI0 0 2,699 8,866 0 600-46-49404-000 WATER METERED SALES-PUB AUTH0 0 2,140 5,748 0 600-46-49410-000 WATER PENALTIES 0 0 0 ( 27) 0 600-46-49463-000 WATER HYDRANT RENTAL/FR PROTE0 0 42,849 82,100 0 600-46-49474-000 WATER OTHER SALES 0 0 305 1,103 0 600-46-49476-000 WATER MISCELLANEOUS 0 340 249 0 0 TOTAL CHARGES FOR SERVICE 0 340 142,772 305,707 0 TOTAL FUND REVENUE 0 340 142,772 305,707 0 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 600 - WATER UTILITY FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 35 WATER UTILITY WATER PURCHASES 600-50-51200-210 WATER AUDIT FEE 0 0 5,006 5,350 0 600-50-51200-220 WATER PURCHASES FOR RESALE 0 24,543 113,208 124,221 0 600-50-51200-240 WATER - REPAIR OF PLANT 0 0 740 8,994 0 600-50-51200-688 REGULATORY COMISSION EXPENSE0 0 57 5,100 0 TOTAL WATER PURCHASES 0 24,543 119,011 143,664 0 MISCELLANEOUS EXPENSES 600-50-51300-300 WATER SEMINARS & TRAINING 0 170 170 528 0 600-50-51300-310 WATER OFFICE SUPPLIES 0 32 1,577 1,779 0 600-50-51300-320 WATER VEHICLE MAINT/GAS & OIL 0 245 3,268 1,228 0 600-50-51300-330 WATER BLDG UTILITIES 0 578 2,439 2,354 0 600-50-51300-340 WATER BLDG MAINT 0 111 539 694 0 600-50-51300-341 WATER BLDG CLEANING SUPPLIES 0 15 106 426 0 600-50-51300-350 COMPUTER MAINT/SUPPORT/UPDAT0 394 2,276 1,794 0 600-50-51300-355 WEB PAGE MAINT/SUPPORT 0 0 48 70 0 600-50-51300-356 VILLAGE CODE WEB MAINT 0 52 52 0 0 600-50-51300-360 COMMUNICATIONS 0 92 662 766 0 600-50-51300-370 MAINTENANCE CONTRACTS 0 291 1,292 1,254 0 600-50-51300-390 WATER MISCELLANEOUS 0 750 1,829 1,413 0 TOTAL MISCELLANEOUS EXPENSES 0 2,730 14,257 12,304 0 TOTAL WATER UTILITY 0 27,273 133,267 155,968 0 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 600 - WATER UTILITY FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 36 WATER UTILITY DEBT SERVICE DEBT SERVICE 600-52-52210-365 PRINICIPAL - LONG TERM DEBT 0 0 162,273 150,743 0 600-52-52210-366 INTEREST EXPENSE 0 0 17,517 25,000 0 TOTAL DEBT SERVICE 0 0 179,790 175,743 0 TOTAL WATER UTILITY DEBT SERVIC 0 0 179,790 175,743 0 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 600 - WATER UTILITY FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 37 TOTAL FUND EXPENDITURES 0 27,273 313,057 331,711 0 NET REVENUES OVER EXPENDITURE 1,112,592 ( 460,628) ( 2,842,404) ( 1,902,030) VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 610 - SEWER UTILITY FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACTUAL BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 38 CHARGES FOR SERVICE 610-46-49400-000 SEWER METERED SALES-RESIDENT0 0 75,417 162,578 0 610-46-49402-000 SEWER METERED SALES-COMMERCI0 0 2,007 12,663 0 610-46-49404-000 SEWER METERED SALES-PUB AUTH0 0 1,791 2,409 0 610-46-49410-000 SEWER PENALTIES 0 0 0 ( 27) 0 610-46-49474-000 SEWER OTHER SALES 0 0 226 679 0 TOTAL CHARGES FOR SERVICE 0 0 79,440 178,301 0 TOTAL FUND REVENUE 0 0 79,440 178,301 0 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 610 - SEWER UTILITY FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 39 SEWER UTILITY SEWER PURCHASES 610-50-51200-210 SEWER AUDIT FEES 0 0 4,960 9,588 0 610-50-51200-220 SEWER TREATMENT 0 58,331 102,819 94,606 0 610-50-51200-221 SEWER PWR PURCHASED FOR PUMP0 325 1,731 2,076 0 610-50-51200-240 SEWER MAINTENANCE 0 81 17,724 10,254 0 TOTAL SEWER PURCHASES 0 58,737 127,234 116,524 0 MISCELLANEOUS EXPENSES 610-50-51300-310 SEWER POSTAGE & SUPPLIES 0 16 586 718 0 610-50-51300-320 SEWER VEHICLE MAINT/GAS & OIL 0 123 1,631 614 0 610-50-51300-330 SEWER BLDG UTILITIES 0 289 1,219 1,177 0 610-50-51300-340 SEWER BLDG MAINT 0 158 626 630 0 610-50-51300-341 SEWER BLDG CLEANING SUPPLIES 0 7 53 213 0 610-50-51300-350 COMPUTER MAINT/SUPPORT/UPDAT0 197 1,121 897 0 610-50-51300-355 WEB PAGE MAINT/SUPPORT 0 0 24 35 0 610-50-51300-356 VILLAGE CODE WEB MAINT 0 26 26 0 0 610-50-51300-360 COMMUNICATIONS 0 46 331 383 0 610-50-51300-370 MAINTENANCE CONTRACTS 0 43 306 309 0 610-50-51300-390 SEWER MISCELLANEOUS 0 227 431 403 0 TOTAL MISCELLANEOUS EXPENSES 0 1,132 6,354 5,379 0 TOTAL SEWER UTILITY 0 59,869 133,588 121,902 0 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 610 - SEWER UTILITY FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 40 SEWER UTILITY DEBT SERVICE DEBT SERVICE 610-52-52210-365 PRINICIPAL - LONG TERM DEBT 0 0 109,825 111,853 0 610-52-52210-366 INTEREST EXPENSE 0 0 16,614 19,622 0 TOTAL DEBT SERVICE 0 0 126,439 131,475 0 TOTAL SEWER UTILITY DEBT SERVIC 0 0 126,439 131,475 0 VILLAGE OF MAPLE BLUFF DETAIL EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 7 MONTHS ENDING JULY 31, 2024 FUND 610 - SEWER UTILITY FUND ANNUAL CURRENT CURRENT PRIOR % OF BUDGET PRD ACT YTD ACT YTD ACT BUDGET FOR ADMINISTRATION USE ONLY 58 % OF THE FISCAL YEAR HAS ELAPSED 08/09/2024 10:38AM PAGE: 41 TOTAL FUND EXPENDITURES 0 59,869 260,027 253,377 0 NET REVENUES OVER EXPENDITURE 1,112,592 ( 520,497) ( 3,022,990) ( 1,977,106) NET REVENUES OVER EXPENDITURE 1,112,592 ( 520,497) ( 3,022,990) ( 1,977,106)