Loading...
HomeMy WebLinkAbout#18 - Q4 Financials and Dashboards STAFF REPORT DATE: October 15, 2024 TO: Mayor and Council FROM: Clarissa Hadler, Finance Director REVIEWED BY: Nicole Miller, City Administrator AGENDA ITEM: 3rd Quarter Financial Reports BACKGROUND: Staff has prepared the 3rd Quarter Financial Report for review by the City Council. ISSUE BEFORE THE COUNCIL: Does the City Council have any questions about the 3rd Quarter Financial Report? DISCUSSION: The Budget vs. Actual for 3rd quarter 2024 is attached. YTD revenues and expenditures will fluctuate widely throughout the year depending on peak periods for each activity. Below are a few general notes regarding various items. Revenues: • Tax revenues are receipted in July and December. • General Fund non-tax revenues were expected to be lower this year compared to last year mainly due to decreased building permits, which are down slightly from this same time last year. • Utility Bills are typically reflected the following quarter due to the timing of mailings and payments. • Interest earnings are typically allocated at year-end. Expenditures: • Expenditures reflect a combination of ongoing expenses and items that are one-time payments per year. As such, YTD percentages on expenses other than personnel will fluctuate significantly. • We closed two budgetary departments; communications and city hall. The communications expenses are incorporated into the administration department. City Center expenses will be allocated to city departments based largely on a formula calculated using square footage of those departments within the building. Additional information regarding planned/budgeted changes is available in the 2024 Budget reports from the December 5, 2023 Council meeting, or upon request. FISCAL IMPACT: As noted. ATTACHMENTS: 1) 3rd Quarter Budget-to-Actual Reports Quarterly Financial Report As of September 30, 2024 The following report illustrates the progress of City Revenues and Expenses toward the 2024 Budgeted amounts. (These reports may not include various adjustments that occur infrequently or at year-end, and thus may not be fully representative of financial activity to date.) - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 General Water Sewer Storm Q3 -Year to Date Revenues vs. Expenses Revenues Expenses - 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 General Water Sewer Storm 2024 Budget vs. YTD Expenses (by Fund) Budget YTD Division Expenses as Portion of General Fund Total General Government Public Safety Public Works Parks & Recreation - 0.5 1.0 1.5 2.0 2.5 3.0 3.5 4.0 4.5 General Government Public Safety Public Works Parks & Recreation Millions Division Expenses vs. Budget Remaining (in millions --General Fund Only) Expenses Budget Remaining 1 General Fund Summary 2023 2024 2024 YTD % Revenues Actual Adopted Q3 of Budget Taxes 5,142,327 5,998,211 2,999,105 50% Licenses and Permits 1,148,190 933,580 790,966 85% Intergovernmental 215,178 269,555 340,951 126% Charges for Services 577,073 617,000 546,731 89% Fines and Forfeits 37,516 30,000 17,441 58% Investment Earnings 238,492 80,000 157,082 196% Miscellaneous 267,381 210,903 216,960 103% Total General Fund Revenues:7,626,157 8,139,249 5,069,236 62% Expenses by Department Total Mayor & Mayor & Council 56,842$ 66,121$ 26,786$ 41% Total AdminisAdministration 500,984$ 660,504$ 480,728$ 73% Total ElectionElections 6,295$ 16,658$ 14,766$ 89% Total Commu Communications 50,812$ -$ 260$ #DIV/0! Total Finance Finance 173,588$ 280,813$ 193,475$ 69% Total Plannin Planning & Zoning 217,109$ 473,188$ 289,064$ 61% Total Enginee Engineering Services 32,855$ 35,000$ 24,800$ 71% Total City Hal City Hall 36,687$ -$ -$ #DIV/0! Total Police Police 1,050,555$ 1,310,573$ 654,534$ 50% Total ProsecuProsecution 36,949$ 50,000$ 33,684$ 67% Total Fire Fire 1,387,730$ 1,642,953$ 1,129,262$ 69% Total Fire Rel Fire Relief -$ -$ -$ #DIV/0! Total Building Building Inspection 677,146$ 1,114,889$ 577,223$ 52% Total Emerge Emergency Communications 4,311$ 4,500$ 2,828$ 63% Total Animal Animal Control 19,172$ 14,500$ 17,801$ 123% Total Streets Streets 1,450,333$ 1,812,018$ 1,154,731$ 64% Total Parks & Parks & Recreation 412,051$ 455,204$ 377,463$ 83% Total Transfe Transfers 266,902$ 167,328$ 83,664$ 50% Total Conting Contingency Reserve -$ 35,000$ -$ 0% Total General Fund Expenses 6,380,322$ 8,139,249$ 5,061,069$ 62% Net General Fund Revenue Over/(Under) Expenses - 8,167 2 Water Fund Summary 2023 2024 2024 YTD % Actual Adopted Q3 of Budget Total Revenues 2,967,007 4,483,694 1,778,454 40% Expenses Personnel 449,930$ 517,395$ 310,864$ 60% Materials and Supplies 367,469$ 241,800$ 105,985$ 44% Charges and Services 532,550$ 498,475$ 270,777$ 54% Capital Outlay -$ 4,605,875$ 183,768$ 4% Miscellaneous and Non-operating 389,002$ 1,588,387$ 1,209,805$ 76% Total Water Fund Expenses 1,738,951$ 7,451,932$ 2,081,199$ 28% Net Water Fund Revenue Over/(Under) Expenses (302,745) Sewer Fund Summary 2023 2024 2024 YTD % Actual Adopted Q3 of Budget Total Revenues 1,805,146 3,235,721 1,800,786 56% Expenses Personnel 218,033$ 231,965$ 168,666$ 73% Materials and Supplies 22,496$ 29,900$ 15,563$ 52% Charges and Services -$ 823,099$ 666,070$ 81% Capital Outlay -$ 289,102$ 314,211$ 109% Miscellaneous and Non-operating 370,922$ 1,347,845$ 1,351,912$ 100% Total Sewer Fund Expenses 611,452$ 2,721,911$ 2,516,422$ 92% Net Sewer Fund Revenue Over/(Under) Expenses (715,636) Stormwater Fund Summary 2023 2024 2024 YTD % Actual Adopted Q3 of Budget Total Revenues 649,243 591,384 139,504 24% Expenses Personnel 101,505$ 123,971$ 90,029$ 73% Materials and Supplies 9,235$ 9,850$ 6,975$ 71%Summary Charges and Services 108,755$ 120,644$ 68,369$ 57%ends here. Capital Outlay -$ 800,000$ 202,361$ 25%The following pages Miscellaneous and Non-operating 832,719$ 259,538$ 259,609$ 100%show detailed Total Stormwater Fund Expenses 1,052,213$ 1,314,003$ 627,343$ 48%financials. Net Stormwater Fund Revenue Over/(Under) Expenses (487,839) Utility Fund Summaries 3 General Fund Revenues 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget Taxes 101-410-1320-31010 Current Ad Valorem Taxes 4,685,850 4,679,708 5,566,834 2,783,416 50.0% 101-410-1320-31020 Delinquent Ad Valorem Taxes 23,692 20,875 19,000 - 0.0% 101-410-1320-31030 Mobile Home Tax 22,171 16,781 22,000 11,000 50.0% 101-410-1320-31040 Fiscal Disparities 294,157 423,542 389,878 194,939 50.0% 101-410-1320-31910 Penalty & Interest on Taxes 944 (204) 500 250 50.0% Total Taxes 5,028,535$ 5,142,327$ 5,998,212$ 2,989,605$ 49.8% Licenses and Permits 101-410-1320-32110 Liquor License 14,100 12,050 13,400 1,700 12.7% 101-410-1320-32120 Massage Therapy Licenses 225 500 - - #DIV/0! 101-410-1320-32180 Wastehauler License 1,200 1,560 1,320 1,080 81.8% 101-410-1320-32181 General Contractor License 500 550 350 575 164.3% 101-420-2400-32210 Building Permits 888,486 725,852 750,000 581,363 77.5% 101-430-3100-32211 Driveway Permits 12,825 10,200 7,000 5,525 78.9% 101-420-2400-32212 Fireplace Permits 9,780 6,300 6,000 3,600 60.0% 101-420-2400-32220 Heating Permits 64,928 65,761 45,000 59,617 132.5% 101-420-2400-32230 Plumbing Permits 76,332 70,967 45,000 68,665 152.6% 101-420-2400-32232 Pool Permits 1,650 750 1,000 1,275 127.5% 101-420-2400-32213 Siding Permits 37,730 32,161 4,000 6,500 162.5% 101-420-2400-32214 Roof Permits 488,840 157,002 15,000 24,993 166.6% 101-430-3100-32250 Utility Permits 34,713 41,138 30,000 26,713 89.0% 101-420-2220-32260 Burning Permit 2,105 2,085 1,700 1,400 82.4% 101-420-2220-32275 Fire Suppression Permits 12,785 21,139 8,000 7,731 96.6% 101-410-1320-32281 Golf Cart Operation Permit 90 - 60 30 50.0% 101-410-1320-32282 Miscellaneous Permits 100 175 100 200 200.0% Total Licenses and Permits 1,646,389$ 1,148,190$ 928,080$ 790,966$ 85.2% Intergovernmental 101-430-3100-33418 MSA - Maintenance 198,154 202,220 208,287 234,264 112.5% 101-420-2220-33420 State Fire Aid 99,778 - - - #DIV/0! 101-420-2220-33426 Miscellaneous State Grants 4,709 2,000 3,500 - 0.0% 101-450-5200-33426 Miscellaneous State Grants 4,784 2,438 4,800 - 0.0% 101-410-1320-33623 Payment in Lieu of Taxes 34,779 (35,474) 36,212 - 0.0% 101-410-1320-33521 Recycling Grant 14,004 39,256 16,756 17,273 103.1% Total Intergovernmental 360,870$ 215,178$ 269,555$ 296,244$ 109.9% 4 General Fund Revenues 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget Charges for Services 101-410-1910-34103 Zoning & Subdivision Fees 115,965 85,876 93,000 95,415 102.6% 101-420-2400-34104 Plan Check Fees 574,075 467,420 487,000 395,123 81.1% 101-410-1520-34107 Assessment Searches 2,340 1,595 2,500 835 33.4% 101-410-1450-34111 Cable Operation Reimbursement - (0) 5,000 - 0.0% 101-420-2400-34112 Planning & Zoning Review Fee 21,400 200 - - #DIV/0! 101-430-3100-34114 Street Light Fee 816 516 2,000 4,853 242.7% 101-410-1910-34115 Base Map Upgrading Fee 1,025 1,075 2,500 5,650 226.0% 101-410-1910-36206 Escrow Administration Fee 20,700 17,100 25,000 6,800 27.2% Total Charges for Services 742,281$ 577,073$ 617,000$ 546,731$ 88.6% Fines and Forfeits 101-420-2100-35100 Fines 2,966 36,879 30,000 15,585 52.0% 101-420-2100-35130 Forfeitures - 93 - 99 #DIV/0! 101-420-2220-35102 Fire Alarm Fees 1,005 544 - 1,756 #DIV/0! Total Fines and Forfeits 3,972$ 37,516$ 30,000$ 17,441$ 58.1% Investment Earnings 101-410-1320-36210 Interest Earnings (81,535) 238,492 80,000 - 0.0% Total Investment Earnings (81,535)$ 238,492$ 80,000$ -$ 0.0% Miscellaneous 101-410-1320-31811 Cable Franchise Revenue 77,694 68,884 65,000 86,955 133.8% 101-410-1320-36200 Miscellaneous Revenue 15,955 14,560 5,000 195 3.9% 101-420-2220-36200 Miscellaneous Revenue 6,155 11,970 - 2,500 #DIV/0! 101-430-3100-36200 Miscellaneous Revenue 9,203 8,534 4,500 1,905 42.3% 101-410-1910-36200 Miscellaneous Revenue - - - - #DIV/0! 101-450-5200-36200 Miscellaneous Revenue 37 1,312 1,000 2,181 218.1% 101-410-1910-36236 Conservation Easement Fee - - - - #DIV/0! 101-420-2220-36204 Reimbursements - Fire 25,535 15,519 5,000 23,702 474.0% 101-420-2220-36230 Donations-Fire 2,185 2,759 1,000 4,135 413.5% 101-410-1320-36230 Donations 12,000 10,000 10,000 7,600 76.0% 101-410-1320-34120 Tower Rent 48,006 133,843 119,403 87,787 73.5% Total Miscellaneous 196,769$ 267,381$ 210,903$ 216,960$ 102.9% 5 General Fund Revenues 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget General Fund Revenue Summary 2022 Actual 2023 Actual 2024 Budget Q3 - YTD YTD % to Budget Taxes 5,028,535 5,142,327 5,998,212 2,989,605 49.8% Licenses and Permits 1,646,389 1,148,190 928,080 790,966 85.2% Intergovernmental 360,870 215,178 269,555 296,244 109.9% Charges for Services 742,281 577,073 617,000 546,731 88.6% Fines and Forfeits 3,972 37,516 30,000 17,441 58.1% Investment Earnings (81,535) 238,492 80,000 - 0.0% Miscellaneous 196,769 267,381 210,903 216,960 102.9% TOTAL 7,897,281$ 7,626,157$ 8,133,750$ 4,857,947$ 59.7% 6 410 General Government Division Expenses 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget #REF!#REF!#REF!#REF! 1110 Mayor & Council Personnel 101-410-1110-41030 Part-time Salaries 25,690 25,162 25,690 12,845 50.0% 101-410-1110-41220 FICA Contributions 1,593 1,560 1,593 796 50.0% 101-410-1110-41230 Medicare Contributions 373 365 373 186 49.9% 101-410-1110-41510 Workers Compensation 86 66 93 52 56.2% Total Personnel 27,741$ 27,153$ 27,749$ 13,880$ 50.0% Materials and Supplies 101-410-1110-42000 Office Supplies 64 67 125 250 199.8% 101-410-1110-42001 Computer Reimbursement - 2,000 - - #DIV/0! 101-410-1110-43310 Mileage 191 37 955 - 0.0% 101-410-1110-43185 IT Support 1,322 1,273 1,394 1,072 76.9% Total Materials and Supplies 1,577$ 3,377$ 2,474$ 1,322$ 53.4% Charges and Services 101-410-1110-44300 Miscellaneous 5,412 7,329 6,165 5,754 93.3% 101-410-1110-44330 Dues & Subscriptions 17,092 18,389 22,758 5,053 22.2% 101-410-1110-44370 Conferences & Training 1,301 594 6,975 777 11.1% Total Charges and Services 23,805$ 26,312$ 35,898$ 11,584$ 32.3% 1110 Total Mayor & Council 53,123$ 56,842$ 66,121$ 26,786$ 40.5% 1320 Administration Personnel 101-410-1320-41010 Full-time Salaries 161,134 196,912 261,516 173,674 66.4% 101-410-1320-41210 PERA Contributions 11,924 13,950 19,614 13,026 66.4% 101-410-1320-41216 MSRS Contributions -City Admin 1,540 1,677 1,704 1,223 71.8% 101-410-1320-41220 FICA Contributions 9,365 11,445 16,214 12,332 76.1% 101-410-1320-41230 Medicare Contributions 2,220 2,730 3,792 2,884 76.1% 101-410-1320-41300 Insurance 22,409 26,269 41,897 29,571 70.6% 101-410-1320-41325 Life Insurance 110 465 168 98 58.2% 101-410-1320-41330 STD/LTD 804 890 1,399 699 50.0% 101-410-1320-41420 Unemployment Benefits - - - - #DIV/0! 101-410-1320-41510 Workers Compensation 1,179 1,045 1,385 701 50.6% Total Personnel 210,686$ 255,382$ 347,688$ 234,207$ 67.4% Materials and Supplies 101-410-1320-42000 Office Supplies 754 2,234 3,200 2,362 73.8% 101-410-1320-42030 Printed Forms - - 100 - 0.0% Total Materials and Supplies 754$ 2,234$ 3,300$ 2,362$ 71.6% 7 410 General Government Division Expenses 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget #REF!#REF!#REF!#REF! Charges and Services 101-410-1320-43100 Assessing Services 107,874 112,968 112,959 113,783 100.7% 101-410-1320-43040 Legal Services 41,985 56,432 80,000 25,238 31.5% 101-410-1320-43150 Contract Services 33,472 13,276 25,000 18,954 75.8% 101-410-1320-43185 IT Support 5,262 5,032 7,830 5,226 66.7% 101-410-1320-42002 IT Hardware 1,139 5,195 4,600 - 0.0% 101-410-1320-43210 Telephone 569 602 1,002 430 43.0% 101-410-1320-43220 Postage 3,876 4,854 4,504 4,614 102.4% 101-410-1320-43310 Mileage 499 661 2,055 308 15.0% 101-410-1320-43510 Legal Publishing 1,286 3,638 1,500 3,104 206.9% 101-410-1320-43610 Insurance 43,543 36,273 26,087 42,291 162.1% 101-410-1320-44330 Dues & Subscriptions 1,557 1,321 3,800 915 24.1% 101-410-1320-44370 Conferences & Training 2,377 3,083 11,285 4,753 42.1% 101-410-1320-44371 Allocation to Building Inspections (1,998) (3,184) - - #DIV/0! Total Charges and Services 241,441$ 240,149$ 293,622$ 225,923$ 76.9% Miscellaneous 101-410-1320-44300 Miscellaneous 1,352 3,220 3,463 7,265 209.8% Total Miscellaneous 1,352$ 3,220$ 3,463$ 7,265$ 209.8% 1320 Total Administration 454,233$ 500,984$ 648,073$ 469,758$ 72.5% 1410 Elections Personnel 101-410-1410-41030 Part-time Salaries 8,649 2,649 11,008 8,937 81.2% 101-410-1410-41510 Workers Compensation - - - - #DIV/0! Total Personnel 8,649$ 2,649$ 11,008$ 8,937$ 81.2% Charges and Services 101-410-1410-43310 Travel Expense - - 75 - 0.0% 101-410-1410-42000 Office Supplies - 53 300 604 201.4% 101-410-1410-43510 Legal Notices Publishing 712 68 500 136 27.2% 101-410-1410-43150 Contract Services 3,195 3,525 3,525 3,854 109.3% Total Charges and Services 3,907$ 3,646$ 4,400$ 4,594$ 104.4% Miscellaneous 101-410-1410-44300 Miscellaneous 1,214 585 1,250 1,235 98.8% Total Miscellaneous - - - 1,235 #DIV/0! 1410 Total Elections 12,556$ 6,295$ 15,408$ 14,766$ 95.8% 8 410 General Government Division Expenses 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget #REF!#REF!#REF!#REF! 1450 Communications Personnel 101-410-1450-41010 Full-time Salaries 11,931 31,033 - - 101-410-1450-41210 PERA Contributions 845 2,327 - - 101-410-1450-41220 FICA Contributions 739 1,798 - - 101-410-1450-41230 Medicare Contributions 173 420 - - 101-410-1450-41300 Insurance 1,778 5,122 - - 101-410-1450-41325 Life Insurance 287 5 - - 101-410-1450-41330 STD/LTD 54 48 - - 101-410-1450-41510 Workers Compensation 189 256 - - Total Personnel 15,997$ 41,008$ -$ - Charges and Services 101-410-1450-43090 Newsletter 709 2,425 - - 101-410-1450-43185 IT Support 849 1,333 - - 101-410-1450-42002 IT Hardware - 106 - - 101-410-1450-43190 Software Programs 1,629 1,550 - - 101-410-1450-43220 Postage 309 349 - - 101-410-1450-43310 Mileage - - - - 101-410-1450-43152 Cable Operations 3,485 4,042 - - 101-410-1450-44370 Conferences and Training - - - - Total Charges and Services 6,981$ 9,804$ -$ - 1450 Total Communications 22,978$ 50,812$ -$ -$ #DIV/0! 1520 Finance Personnel 101-410-1520-41010 Full-time Salaries 42,139 72,262 160,980 113,949 70.8% 101-410-1520-41040 Temporary Employees - - - - #DIV/0! 101-410-1520-41210 PERA Contributions 3,034 5,419 12,074 8,545 70.8% 101-410-1520-41220 FICA Contributions 2,512 4,292 9,981 6,807 68.2% 101-410-1520-41230 Medicare Contributions 588 1,004 2,334 1,592 68.2% 101-410-1520-41300 Insurance 8,929 13,032 30,282 16,073 53.1% 101-410-1520-41325 Life Insurance 308 270 121 55 44.9% 101-410-1520-41330 STD/LTD 295 174 1,044 482 46.2% 101-410-1520-41420 Unemployment Benefits 414 - - - #DIV/0! 101-410-1520-41510 Workers Compensation 517 734 852 432 50.6% Total Personnel 58,735$ 97,188$ 217,669$ 147,934$ 68.0% Communications expenses moved to Administration Dept. 9 410 General Government Division Expenses 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget #REF!#REF!#REF!#REF! Materials and Supplies 101-410-1520-42000 Office Supplies 760 898 1,000 736 73.6% 101-410-1520-42030 Printed Forms 1,052 1,009 1,500 1,151 76.7% Total Materials and Supplies 1,811$ 1,907$ 2,500$ 1,887$ 75.5% Charges and Services 101-410-1520-43010 Audit Services 8,244 11,284 11,425 11,844 103.7% 101-410-1520-43150 Contract Services 39,493 49,054 10,000 7,901 79.0% 101-410-1520-43185 IT Support 2,266 4,459 4,287 4,661 108.7% 101-410-1520-42002 IT Hardware - 6,080 6,900 184 2.7% 101-410-1520-43190 Software Programs 4,018 4,319 7,000 3,849 55.0% 101-410-1520-43310 Mileage - 288 300 - 0.0% 101-410-1520-44330 Dues & Subscriptions 530 720 1,040 680 65.4% 101-410-1520-44370 Conferences & Training - 766 5,095 567 11.1% 101-410-1520-44371 Allocation to Building Inspections (1,231) (2,905) - - #DIV/0! Total Charges and Services 53,319$ 74,066$ 46,047$ 29,685$ 64.5% Miscellaneous 101-410-1520-44300 Miscellaneous 1,234 427 1,570 1,535 97.8% Total Miscellaneous 1,234$ 427$ 1,570$ 1,535$ 97.8% 1520 Total Finance 115,100$ 173,588$ 267,786$ 181,041$ 68% 1910 Planning & Zoning Personnel 101-410-1910-41010 Full-time Salaries 190,130 74,715 291,923 137,949 47.3% 101-410-1910-41040 Temporary Employees 390 4,522 9,620 - 0.0% 101-410-1910-41210 PERA Contributions 14,260 5,560 21,894 10,346 47.3% 101-410-1910-41220 FICA Contributions 11,471 4,740 18,696 8,159 43.6% 101-410-1910-41230 Medicare Contributions 2,683 1,109 4,372 1,908 43.6% 101-410-1910-41300 Insurance 18,703 12,168 61,162 24,534 40.1% 101-410-1910-41325 Life Insurance 664 305 245 70 28.6% 101-410-1910-41330 STD/LTD 739 313 1,600 374 23.4% 101-410-1910-41510 Workers Compensation 1,138 1,260 1,610 1,054 65.5% Total Personnel 240,176$ 104,691$ 411,122$ 184,394$ 44.9% Materials and Supplies 101-410-1910-42000 Office Supplies 574 389 1,000 698 69.8% 10 410 General Government Division Expenses 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget #REF!#REF!#REF!#REF! 101-410-1910-42120 Fuel, Oil and Fluids - 270 2,000 - 0.0% 101-410-1910-42030 Printed Forms - 51 600 - 0.0% Total Materials and Supplies 574$ 710$ 3,600$ 698$ 19.4% Charges and Services 101-410-1910-43020 Comprehensive Planning 101-410-1910-43030 Engineering Services 6,175 3,213 5,000 3,621 72.4% 101-410-1910-43150 Contract Services 17,216 92,875 15,000 72,421 482.8% 101-410-1910-43185 IT Support 5,291 11,445 11,273 9,494 84.2% 101-410-1910-42002 IT Hardware 2,091 1,283 9,200 4,937 53.7% 101-410-1910-43190 Software Programs 936 - 1,700 287 16.9% 101-410-1910-43210 Telephone 191 120 126 227 179.8% 101-410-1910-43220 Postage 80 - 200 - 0.0% 101-410-1910-43310 Mileage 380 - 600 218 36.4% 101-410-1910-43510 Legal Publishing 1,775 1,835 1,825 725 39.7% 101-410-1910-44330 Dues & Subscriptions 698 - 2,000 533 26.6% 101-410-1910-44370 Conferences & Training 2,032 356 3,500 3,820 109.1% Total Charges and Services 36,865$ 111,127$ 50,424$ 96,284$ 190.9% Miscellaneous 101-410-1910-44300 Miscellaneous 348 581 640 532 83.2% Total Miscellaneous 348$ 581$ 640$ 532$ 83.2% 1910 Total Planning & Zoning 277,963$ 217,109$ 465,787$ 281,908$ 60.5% 1930 Engineering Services Charges and Services 101-410-1930-43030 Engineering Services 30,975 32,855 35,000 24,800 70.9% 101-410-1930-43210 Telephone - - - - #DIV/0! Total Charges and Services 30,975$ 32,855$ 35,000$ 24,800$ 70.9% Capital Outlay 101-480-8000-45900 Construction Projects - - - - #DIV/0! Total Capital Outlay - - - - #DIV/0! 1930 Total Engineering Services 30,975$ 32,855$ 35,000$ 24,800$ 70.9% 1940 City Hall Materials and Supplies 101-410-1940-42110 Cleaning Supplies 345 227 - - #DIV/0! 101-410-1940-42230 Building Repair Supplies 491 232 - - #DIV/0! 11 410 General Government Division Expenses 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget #REF!#REF!#REF!#REF! Total Materials and Supplies 835$ 459$ -$ -$ #DIV/0! Charges and Services 101-410-1940-43185 IT Support 1,322 1,273 - - #DIV/0! 101-410-1940-42002 IT Hardware - - - - #DIV/0! 101-410-1940-43810 Utilities 25,083 54,231 - - #DIV/0! 101-410-1940-43840 Refuse 1,968 2,183 - - #DIV/0! 101-410-1940-44010 Repairs/Maint Contractual Bldg 14,855 18,028 - - #DIV/0! 101-410-1940-44040 Repairs/Maint Contractual Eqpt 2,840 993 - - #DIV/0! 101-410-1940-44371 Allocation to Building Inspections (26,476) (45,050) - - #DIV/0! Total Charges and Services 19,841$ 31,659$ -$ -$ #DIV/0! Miscellaneous 101-410-1940-44300 Miscellaneous 25,320 4,569 - - #DIV/0! Total Miscellaneous 25,320$ 4,569$ -$ -$ #DIV/0! 1940 Total City Hall 45,996$ 36,687$ -$ -$ #DIV/0! 9000 Transfers Transfers 101-900-9000-47201 Transfer to Project Fund 102,074 16,902 - - #DIV/0! 101-900-9000-47250 Transfer to Vehicle Replacement Fund - 250,000 167,328 83,664 50.0% Total Transfers 102,074$ 266,902$ 167,328$ 83,664$ 50.0% 9000 Total Transfers 102,074$ 266,902$ 167,328$ 83,664$ 50.0% 9001 Contingency Reserve Contingency Reserve Reserve - - - - #DIV/0! Total Contingency Reserve - - - - #DIV/0! 9001 Total Contingency Reserve -$ -$ -$ -$ #DIV/0! General Government Summary 2022 Actual 2023 Actual 2024 Budget Q3 - YTD YTD % to Budget 1110 Mayor & Council 53,123$ 56,842$ 66,121$ 26,786$ 40.5% 12 410 General Government Division Expenses 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget #REF!#REF!#REF!#REF! 1320 Administration 454,233$ 500,984$ 648,073$ 469,758$ 72.5% 1410 Elections 12,556$ 6,295$ 15,408$ 14,766$ 95.8% 1450 Communications 22,978$ 50,812$ -$ -$ #DIV/0! 1520 Finance 115,100$ 173,588$ 267,786$ 181,041$ 67.6% 1910 Planning & Zoning 277,963$ 217,109$ 465,787$ 281,908$ 60.5% 1930 Engineering Services 30,975$ 32,855$ 35,000$ 24,800$ 70.9% 1940 City Hall 45,996$ 36,687$ -$ -$ #DIV/0! 9000 Transfers 102,074$ 266,902$ 167,328$ 83,664$ 50.0% 9001 Contingency Reserve -$ -$ -$ -$ #DIV/0! TOTAL 1,114,999$ 1,342,075$ 1,665,503$ 1,082,724$ 65.0% 13 420 Public Safety Division Expenses 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget 2100 Police Charges and Services 101-420-2100-43150 Law Enforcement Contract 947,044 1,048,618 1,289,478 645,373 50.0% 101-420-2100-44301 Misc. - Community Event - - 1,800 - 0.0% Total Charges and Services 947,044$ 1,048,618$ 1,291,278$ 645,373$ 50.0% - - - 2100 Total Police 947,044$ 1,048,618$ 1,291,278$ 645,373$ 50.0% 2150 Prosecution Charges and Services 101-420-2150-43045 Attorney Criminal 48,141 36,949 50,000 33,684 67.4% Total Charges and Services 48,141$ 36,949$ 50,000$ 33,684$ 67.4% 2150 Total Prosecution 48,141$ 36,949$ 50,000$ 33,684$ 67.4% 2500 Emergency Communications Charges and Services 101-420-2500-43150 Contract Services 20,501 4,311 4,500 2,828 62.9% Total Charges and Services 20,501$ 4,311$ 4,500$ 2,828$ 62.9% - - - - 2500 Total Emergency Communications 20,501$ 4,311$ 4,500$ 2,828$ 62.9% 2700 Animal Control Charges and Services 101-420-2700-43150 Contract Services 13,550 19,172 14,500 17,801 122.8% Total Charges and Services 13,550$ 19,172$ 14,500$ 17,801$ 122.8% 2700 Total Animal Control 13,550$ 19,172$ 14,500$ 17,801$ 122.8% 2220 Fire Personnel 101-420-2220-41010 Full-time Salaries 249,451 415,118 623,384 456,280 73.2% 101-420-2220-41030 Part-time Salaries 61,057 6,351 7,500 1,250 16.7% 101-420-2220-41035 Paid On Call Salaries 75,897 144,681 196,859 125,125 63.6% 101-420-2220-41210 PERA Contributions 51,347 74,335 111,666 80,513 72.1% 101-420-2220-41220 FICA Contributions 5,145 9,524 12,205 7,764 63.6% 101-420-2220-41230 Medicare Contributions 5,389 8,174 12,002 8,302 69.2% 101-420-2220-41300 Insurance 31,967 49,440 131,818 55,042 41.8% 101-420-2220-41325 Life Insurance 145 704 529 273 51.6% 14 420 Public Safety Division Expenses 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget 101-420-2220-41330 STD/LTD 1,104 1,679 2,850 1,891 66.4% 101-420-2220-41510 Workers Compensation 28,673 57,030 66,882 44,861 67.1% Total Personnel 516,825$ 767,036$ 1,165,696$ 781,302$ 67.0% Materials and Supplies 101-420-2220-42000 Office Supplies 1,119 855 1,000 3,263 326.3% 101-420-2220-42080 EMS Supplies 968 2,606 2,400 2,096 87.3% 101-420-2220-42090 Fire Prevention 1,860 2,433 2,000 4,088 204.4% 101-420-2220-42120 Fuel, Oil and Fluids 25,109 18,248 29,700 12,780 43.0% 101-420-2220-42400 Small Tools & Equipment 37,573 82,102 25,419 15,669 61.6% Total Materials and Supplies 66,629$ 106,244$ 60,519$ 37,896$ 62.6% Charges and Services 101-420-2220-43050 Physicals 9,764 7,795 11,500 7,327 63.7% 101-420-2220-43150 Contract Services 1,100 2,600 1,150 966 84.0% 101-420-2220-43185 IT Support 19,824 23,189 23,513 18,634 79.2% 101-420-2220-42002 IT Hardware 1,715 3,000 8,920 6,716 75.3% 101-420-2220-43190 Software Programs 3,730 14,005 15,324 10,425 68.0% 101-420-2220-43210 Telephone 3,983 4,655 4,800 2,898 60.4% 101-420-2220-43230 Radio 16,555 17,709 17,500 8,202 46.9% 101-420-2220-43310 Mileage 180 - 600 - 0.0% 101-420-2220-43630 Insurance 10,112 22,157 21,950 35,907 163.6% 101-420-2220-43810 Utility 16,820 12,178 32,400 23,711 73.2% 101-420-2220-43840 Refuse 227 148 1,620 819 50.5% 101-420-2220-44010 Repairs/Maint Bldg 6,737 13,184 17,982 16,587 92.2% 101-420-2220-44040 Repairs/Maint Eqpt 54,027 60,987 43,920 43,494 99.0% 101-420-2220-44170 Uniforms 7,532 14,455 10,000 5,804 58.0% 101-420-2220-44330 Dues & Subscriptions 2,766 3,851 4,845 7,253 149.7% 101-420-2220-44350 Books 185 1,250 1,000 880 88.0% 101-420-2220-44370 Conferences & Training 23,015 39,564 27,000 23,300 86.3% Total Charges and Services 178,273$ 240,728$ 244,024$ 212,921$ 87.3% Capital Outlay 101-480-8000-45500 Vehicle - - - - #DIV/0! 101-420-2220-47200 Transfer to Vehicle Replacement Fund 51,537 67,112 94,914 47,457 50.0% 101-480-8000-45800 Equipment 78,628 204,815 - - #DIV/0! Total Capital Outlay 130,165$ 271,927$ 94,914$ 47,457$ 50.0% Miscellaneous 15 420 Public Safety Division Expenses 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget 101-420-2220-44300 Miscellaneous 1,854 1,795 2,540 859 33.8% Total Miscellaneous 1,854$ 1,795$ 2,540$ 859$ 33.8% 2220 Total Fire 893,746$ 1,387,730$ 1,567,693$ 1,080,434$ 68.9% 2400 Building Inspection Personnel 101-420-2400-41010 Full-time Salaries 343,456 357,891 648,216 345,540 53.3% 101-420-2400-41210 PERA Contributions 27,061 28,649 55,388 30,849 55.7% 101-420-2400-41216 MSRS Contributions -City Admin 519 565 574 412 71.8% 101-420-2400-41220 FICA Contributions 19,246 20,007 40,189 18,440 45.9% 101-420-2400-41230 Medicare Contributions 4,760 4,986 9,399 5,004 53.2% 101-420-2400-41300 Insurance 64,027 62,983 133,765 53,472 40.0% 101-420-2400-41325 Life Insurance 239 485 536 167 31.2% 101-420-2400-41330 STD/LTD 1,439 1,850 3,790 1,569 41.4% 101-420-2400-41510 Workers Compensation 3,074 2,258 8,172 6,957 85.1% Total Personnel 463,821$ 479,673$ 900,028$ 462,411$ 51.4% Materials and Supplies 101-420-2400-42000 Office Supplies 1,067 12,595 4,000 6,086 152.2% 101-420-2400-42030 Printed Forms - - 350 - 0.0% 101-420-2400-42120 Fuel, Oil and Fluids 5,424 6,939 7,500 2,467 32.9% Total Materials and Supplies 6,491$ 19,534$ 11,850$ 8,553$ 72.2% Charges and Services 101-420-2400-43030 Engineering 24 - 3,000 - 0.0% 101-420-2400-43150 Inspector Contract Services 274,617 85,421 80,000 31,520 39.4% 101-420-2400-43185 IT Support 13,378 17,361 23,030 15,053 65.4% 101-420-2400-42002 IT Hardware 174 1,709 15,500 9,206 59.4% 101-420-2400-43190 Software Programs 3,416 3,385 25,000 12,458 49.8% 101-420-2400-43210 Telephone 1,760 2,331 2,442 1,463 59.9% 101-420-2400-43630 Insurance 3,600 7,939 7,207 12,974 180.0% 101-420-2400-44040 Repairs/Maint Eqpt 7,322 6,259 7,750 3,727 48.1% 101-420-2400-44170 Uniforms 468 330 1,000 284 28.4% 101-420-2400-44330 Dues & Subscriptions 60 789 1,500 291 19.4% 101-420-2400-44350 Books 256 - 1,000 - 0.0% 101-420-2400-44370 Conferences & Training 2,224 783 5,000 2,128 42.6% Total Charges and Services 307,297$ 126,306$ 172,429$ 89,105$ 51.7% 16 420 Public Safety Division Expenses 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget Capital Outlay 101-480-2400-47200 Transfer to Vehicle Replacement - - 11,300 5,650 50.0% Total Capital Outlay -$ -$ 11,300$ 5,650$ 50.0% Miscellaneous 101-420-2400-44371 Allocations from Admin, Finance, City 29,706 51,139 - - #DIV/0! 101-420-2400-44300 Miscellaneous 1,205 494 3,140 530 16.9% Total Miscellaneous 30,911$ 51,633$ 3,140$ 530$ 16.9% 2400 Total Building Inspection 808,520$ 677,146$ 1,098,747$ 566,249$ 51.5% Public Safety Summary 2022 Actual 2023 Actual 2024 Budget Q3 - YTD YTD % to Budget 2100 Police 947,044$ 1,048,618$ 1,291,278$ 645,373$ 50.0% 2150 Prosecution 48,141$ 36,949$ 50,000$ 33,684$ 67.4% 2500 Emergency Communications 20,501$ 4,311$ 4,500$ 2,828$ 62.9% 2700 Animal Control 13,550$ 19,172$ 14,500$ 17,801$ 122.8% 2220 Fire 893,746$ 1,387,730$ 1,567,693$ 1,080,434$ 68.9% 2250 Fire Relief -$ -$ -$ -$ #DIV/0! 2400 Building Inspection 808,520$ 677,146$ 1,098,747$ 566,249$ 51.5% TOTAL 2,731,503$ 3,173,926$ 4,026,718$ 2,346,369$ 58.3% 17 430 Public Works* Division Expenses 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget 3100 Streets Personnel 101-430-3100-41010 Full-time Salaries 375,049 410,215 389,266 293,210 75.3% 101-430-3100-41020 Overtime 11,431 12,566 19,689 7,526 38.2% 101-430-3100-41040 Temporary Employees 9,585 12,880 19,240 21,190 110.1% 101-430-3100-41210 PERA Contributions 28,899 31,674 29,195 22,468 77.0% 101-430-3100-41220 FICA Contributions 23,414 25,855 26,548 19,267 72.6% 101-430-3100-41230 Medicare Contributions 5,476 6,042 6,209 4,506 72.6% 101-430-3100-41300 Insurance 75,099 84,751 81,029 60,749 75.0% 101-430-3100-41325 Life Insurance 334 344 378 240 63.3% 101-430-3100-41330 STD/LTD 1,929 2,339 2,145 1,647 76.8% 101-430-3100-41600 Safety Clothing Allowance 225 662 800 611 76.4% 101-430-3100-41510 Workers Compensation 36,194 25,374 22,806 19,863 87.1% Total Personnel 567,633$ 614,707$ 597,306$ 451,776$ 75.6% Materials and Supplies 101-430-3100-42000 Office Supplies 500 55 500 257 51.4% 101-430-3100-42120 Fuel, Oil and Fluids 41,375 43,317 48,000 16,975 35.4% 101-430-3100-42150 Operating Supplies 8,586 8,946 9,000 7,185 79.8% 101-430-3100-42210 Repair/Maint. Supplies 5,481 9,287 11,000 7,911 71.9% 101-430-3100-42212 Repair/Maint. Supplies S&I 10,414 8,651 11,000 4,583 41.7% 101-430-3100-42240 Street Maintenance & Landscaping - M 12,635 34,773 26,000 12,477 48.0% 101-430-3100-42260 Street Signs 4,254 4,414 4,000 1,077 26.9% 101-430-3100-42290 Sand/Salt S&I 57,401 67,773 97,000 75,780 78.1% 101-430-3100-42400 Small Tools & Minor Equipment 4,223 22,613 5,000 6,369 127.4% 101-430-3100-44375 Personal Protection Equipment 746 506 1,200 538 44.8% Total Materials and Supplies 145,613$ 200,335$ 212,700$ 133,152$ 62.6% Charges and Services 101-430-3100-43030 Engineering Services 9,934 26,526 16,000 18,234 114.0% 101-430-3100-43090 Sealcoating & Crack Sealing 817,304 217,913 - - #DIV/0! 101-430-3100-43150 Contract Services 14,139 32,401 45,000 33,891 75.3% 101-430-3100-43185 IT Support 18,509 14,600 15,273 12,109 79.3% 101-430-3100-42002 IT Hardware - - 2,032 1,936 95.3% 101-430-3100-43190 Software Programs 4,297 13,598 8,400 7,842 93.4% 101-430-3100-43210 Telephone 4,413 2,594 2,599 1,416 54.5% 101-430-3100-43230 Radio 6,834 4,401 6,750 2,200 32.6% 101-430-3100-43310 Mileage - - 125 - 0.0% 101-430-3100-43510 Public Notices - - 200 - 0.0% 18 430 Public Works* Division Expenses 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget 101-430-3100-43630 Insurance 24,915 12,836 11,525 13,077 113.5% 101-430-3100-43810 Utilities 31,704 29,224 39,000 17,894 45.9% 101-430-3100-43811 Street Lights 59,005 65,804 65,000 42,268 65.0% 101-430-3100-43840 Refuse 7,584 7,893 7,000 5,836 83.4% 101-430-3100-44010 Repairs/Maint Bldg.9,883 7,692 9,750 9,675 99.2% 101-430-3100-44030 Repairs/Maint Imp Other Than Bldg.- 501 950 223 23.5% 101-430-3100-44040 Repairs/Maint Equip 18,128 10,235 20,000 7,796 39.0% 101-430-3100-44041 Repairs/Maint Equip S&I 11,789 8,218 13,000 - 0.0% 101-430-3100-44130 Equipment Rental 1,065 3,862 1,250 477 38.1% 101-430-3100-44170 Uniforms 4,521 5,313 5,200 3,438 66.1% 101-430-3100-44330 Dues & Subscriptions 482 2,364 1,200 617 51.5% 101-430-3100-44370 Conferences & Training 3,057 2,489 4,000 3,842 96.1% Total Charges and Services 1,047,563$ 468,465$ 274,254$ 182,771$ 66.6% Capital Outlay 101-430-3100-47200 Transfer to Vehicle Replacement Fund 86,963 90,683 90,558 45,279 50.0% 101-430-3100-47205 Transfer to NEW Street Maintenance Fund - 600,000 300,000 50.0% 101-480-3100-45500 Capital Purchases 53,038 75,316 36,500 40,662 111.4% Total Capital Outlay 140,001$ 165,999$ 727,058$ 385,941$ 53.1% Miscellaneous 101-430-3100-44300 Miscellaneous 1,929 828 700 1,091 155.9% Total Miscellaneous 1,929$ 828$ 700$ 1,091$ 155.9% - 3100 Total Streets 1,902,740$ 1,450,333$ 1,812,018$ 1,154,731$ 63.7% * This title/designation is for Accounting purposes only. The Lake Elmo Public Works Department provides service within all the following accounts/departments; Streets, Park & Rec, Water, Sewer, and Stormwater. 19 450 Parks & Recreation Division Expenses 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget 5200 Parks & Recreation Personnel 101-450-5200-41010 Full-time Salaries 95,997 94,881 123,425 92,460 74.9% 101-450-5200-41030 Part-time Salaries - - - 74 #DIV/0! 101-450-5200-41020 Overtime 44 - - 74 #DIV/0! 101-450-5200-41040 Temporary Employees 9,803 9,760 9,620 21,995 228.6% 101-450-5200-41210 PERA Contributions 7,195 7,092 9,257 6,916 74.7% 101-450-5200-41220 FICA Contributions 6,255 6,261 8,249 6,904 83.7% 101-450-5200-41230 Medicare Contributions 1,462 1,469 1,929 1,615 83.7% 101-450-5200-41300 Insurance 19,281 14,667 24,995 15,293 61.2% 101-450-5200-41325 Life Insurance 352 61 111 57 51.7% 101-450-5200-41330 STD/LTD 461 461 657 439 66.7% 101-450-5200-41600 Safety Clothing Allowance 320 100 270 225 83.3% 101-450-5200-41420 Unemployment Benefits 952 - - - #DIV/0! 101-450-5200-41510 Workers Compensation 3,018 4,171 4,512 5,654 125.3% Total Personnel 145,142$ 138,923$ 183,024$ 151,705$ 82.9% Materials and Supplies 101-450-5200-42000 Office Supplies 457 160 450 70 15.6% 101-450-5200-42120 Fuel, Oil and Fluids 11,444 11,499 10,800 8,405 77.8% 101-450-5200-42150 Operating Supplies 964 988 800 103 12.9% 101-450-5200-42160 Chemicals - 56 500 63 12.6% 101-450-5200-42210 Repair/Maint. Supplies 11,334 8,539 8,600 7,648 88.9% 101-450-5200-42230 Building Repair Supplies 760 - 500 - 0.0% 101-450-5200-42250 Landscaping Materials 2,392 2,376 2,000 2,028 101.4% 101-450-5200-42400 Small Tools & Minor Equipment 3,597 9,770 3,500 3,562 101.8% Total Materials and Supplies 30,948$ 33,388$ 27,150$ 21,879$ 80.6% Charges and Services 101-450-5200-43030 Engineering Services - - - - #DIV/0! 101-450-5200-43150 Contracted Services 46,300 125,627 152,000 85,807 56.5% 101-450-5200-43185 IT Support 4,108 5,196 5,097 4,205 82.5% 101-450-5200-42002 IT Hardware - - 544 581 106.8% 101-450-5200-43190 Software Programs - - - 114 #DIV/0! 101-450-5200-43210 Telephone 631 1,317 2,039 1,198 58.8% 101-450-5200-43630 Insurance 7,593 22,890 23,717 24,150 101.8% 101-450-5200-43810 Utilities 11,754 8,774 12,500 6,836 54.7% 20 450 Parks & Recreation Division Expenses 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget 101-450-5200-43840 Refuse 3,580 4,889 4,250 1,596 37.6% 101-450-5200-44010 Repairs/Maint Bldg 3,439 2,327 3,000 6,258 208.6% 101-450-5200-44030 Repairs/Maint Imp Not Bldgs 964 2,667 3,000 7,284 242.8% 101-450-5200-44040 Repairs/Maint Eqpt 1,082 4,678 6,500 5,033 77.4% 101-450-5200-44120 Rentals - Buildings 8,203 10,797 8,880 10,728 120.8% 101-450-5200-44170 Uniforms 930 1,187 1,200 666 55.5% 101-450-5200-44301 Events 482 905 550 696 126.5% 101-450-5200-44302 Lakes 15,000 15,000 15,000 - 0.0% 101-450-5200-44330 Dues & Subscriptions - 167 75 65 86.7% 101-450-5200-44370 Conferences & Training 317 930 2,000 3,578 178.9% 101-450-5200-44130 Equipment Rental 882 1,175 650 477 73.3% 101-450-5200-44375 Personal Protection Equipment 136 858 250 243 97.1% Total Charges and Services 105,401$ 209,384$ 241,251$ 159,513$ 66.1% Capital Outlay 101-450-5200-47200 Transfer to Vehicle Replacement Fund 1,961 2,298 3,228 1,614 50.0% 101-900-5200-45500 Capital Purchases - - - - #DIV/0! Total Capital Outlay 1,961$ 2,298$ 3,228$ 1,614$ 50.0% Miscellaneous 101-450-5200-44300 Miscellaneous 1,300 28,058 550 42,751 7772.9% Total Miscellaneous 1,300$ 28,058$ 550$ 42,751$ 7772.9% - - - 5200 Total Parks & Recreation 284,752$ 412,051$ 455,204$ 377,463$ 82.9% 21 601 Water Fund Water, Sewer & Stormwater are separate Utility (aka Enterprise or Proprietary) Funds. 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget Water Fund Revenues: 601-000-0000-36210 Interest on Investments (66,764) 32,000 98,448 307.6% 601-000-0000-37100 Water Sales 1,634,375 1,804,464 1,962,564 212,068 10.8% 601-000-0000-37120 Bulk Water - - 33,455 - 0.0% 601-000-0000-37130 Water Lat Benefit Fee 12,400 13,200 - 7,000 #DIV/0! 601-000-0000-37140 Water Access Revenue 685,000 550,000 1,695,000 1,125,000 66.4% 601-000-0000-37150 Water Connections - Municipal 383,000 299,000 605,000 295,000 48.8% 601-000-0000-37170 Meter Sales 113,708 123,176 155,675 40,938 26.3% Total Water Fund Revenues:2,775,000$ 2,794,808$ 4,483,694$ 1,778,454$ 39.7% Water Fund Expenses: Personnel 601-494-9400-41010 Full-time Salaries 290,353 311,541 367,310 216,218 58.9% 601-494-9400-41020 Overtime 7,979 14,508 9,040 7,063 78.1% 601-494-9400-41210 PERA Contributions 64,026 24,063 27,548 16,358 59.4% 601-494-9400-41216 MSRS Contributions - City Admin 634 690 701 503 71.8% 601-494-9400-41220 FICA Contributions 17,069 19,266 23,334 14,255 61.1% 601-494-9400-41230 Medicare Contributions 4,003 4,529 5,457 3,333 61.1% 601-494-9400-41300 Insurance 57,068 63,158 74,341 40,899 55.0% 601-494-9400-41325 Life Insurance 243 240 299 148 49.5% 601-494-9400-41330 STD/LTD 1,514 1,671 2,008 1,009 50.2% 601-494-9400-41301 Unemployment Insurance - - - - #DIV/0! 601-494-9400-41600 Safety Clothing Allowance 675 432 665 310 46.6% 601-494-9400-41510 Workers Compensation 5,718 9,833 6,692 10,768 160.9% Total Personnel 453,261$ 449,930$ 517,395$ 310,864$ 60.1% Materials and Supplies 601-494-9400-42000 Office Supplies 954 225 800 992 124.0% 601-494-9400-42120 Fuel, Oil and Fluids 10,272 8,985 10,500 3,819 36.4% 601-494-9400-42030 Printed Forms 1,504 335 850 735 86.5% 601-494-9400-42150 Operating Supplies 763 1,762 2,500 506 20.2% 601-494-9400-42160 Chemicals 14,307 16,903 12,000 8,137 67.8% 601-494-9400-42210 Repair/Maint. Supplies 11,170 10,135 10,000 6,834 68.3% 601-494-9400-42300 Water Meters & Supplies 160,718 317,221 200,000 79,554 39.8% 601-494-9400-44375 Personal Protective Equipment 297 591 650 268 41.3% 601-494-9400-42400 Small Tools & Minor Equipment 3,779 11,312 4,500 5,000 111.1% Total Materials and Supplies 203,766$ 367,469$ 241,800$ 105,985$ 43.8% Charges and Services 601-494-9400-43030 Engineering Services 3,430 37,089 25,000 22,249 89.0% 22 601 Water Fund Water, Sewer & Stormwater are separate Utility (aka Enterprise or Proprietary) Funds. 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget 601-494-9400-43040 Legal Services 12,521 87,408 80,000 20,408 25.5% 601-494-9400-43010 Audit Services 8,244 9,825 11,425 11,844 103.7% 601-494-9400-43090 Newsletter 709 - 1,610 - 0.0% 601-494-9400-43150 Contract Services 45,472 76,965 50,000 27,571 55.1% 601-494-9400-43185 IT Support 10,417 12,924 13,190 10,706 81.2% 601-494-9400-42002 IT Hardware - 157 2,520 3,095 122.8% 601-494-9400-43190 Software Programs 10,354 10,469 13,500 7,336 54.3% 601-494-9400-43210 Telephone 1,925 2,282 2,709 1,634 60.3% 601-494-9400-43220 Postage 3,397 2,835 3,675 1,320 35.9% 601-494-9400-43310 Mileage 51 283 200 29 14.4% 601-494-9400-43610 Insurance 11,215 25,923 24,996 24,606 98.4% 601-494-9400-43810 Electric Utility 138,488 127,848 150,000 60,462 40.3% 601-494-9400-43820 Water Utility 36,393 48,846 43,850 23,130 52.7% 601-494-9400-44030 Repairs\Maint Imp Not Bldgs 66,291 56,099 35,000 24,608 70.3% 601-494-9400-44040 Repairs\Maint. Equip.4,443 6,236 7,000 1,541 22.0% 601-494-9400-44010 Repairs\Maint Imp Bldgs 14,224 11,451 15,000 21,829 145.5% 601-494-9400-44150 Equipment Rental 800 1,600 2,400 626 26.1% 601-494-9400-44170 Uniforms 873 1,098 1,000 608 60.8% 601-494-9400-44330 Dues & Subscriptions 450 570 400 261 65.1% 601-494-9400-44370 Conferences & Training 3,676 1,891 2,500 2,313 92.5% 601-494-9400-44377 Credit Card Fees 11,223 10,750 12,500 4,600 36.8% Total Charges and Services 400,131$ 532,550$ 498,474$ 270,777$ 54.3% Capital Outlay 601-494-9400-45300 Improvments Other Than Bldgs - - 4,605,875 183,768 #DIV/0! Total Capital Outlay -$ -$ 4,605,875$ 183,768$ 4.0% Miscellaneous and Non-operating 601-494-9400-44300 Miscellaneous 1,139 43,899 - 890 #DIV/0! 601-494-9400-46010 Bond Principal - - 1,120,000 860,000 76.8% 601-494-9400-46110 Bond Interest 271,308 344,395 374,262 348,916 93.2% 601-494-9400-46200 Fiscal Agent Fees - Bond Payments 495 495 - - #DIV/0! 601-494-9400-46250 Fiscal Agent Fees - Bond Issuance - 213 - - #DIV/0! 601-494-9400-46350 Bond Issuance Costs - - 94,125 - 0.0% 601-494-9400-47200 Transfer Out - - - - #DIV/0! Total Misc. and Non-operating 272,942$ 389,002$ 1,588,387$ 1,209,805$ 76.2% Total Water Fund Expenses:1,330,099$ 1,738,951$ 7,451,932$ 2,081,199$ 28% Net Water Fund Revs. Over/(Under) Expenses:1,444,901$ 1,055,857$ (2,968,238)$ (302,745)$ 23 602 Sewer Fund Water, Sewer & Stormwater are separate Utility (aka Enterprise or Proprietary) Funds. 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget Sewer Fund Revenues: 602-000-0000-36210 Interest on Investments (138,866) - 2,500 230,595 9224% 602-000-0000-37200 Sewer Sales 671,283 755,813 843,721 217,989 26% 602-000-0000-37220 SAC Early Pay discount/revenue 8,599 8,126 - 6,302 #DIV/0! 602-000-0000-37230 Sewer Lat Benefit Fee 13,100 13,700 - - #DIV/0! 602-000-0000-37240 Sewer Availability Charge 477,500 385,500 1,678,500 1,087,900 65% 602-000-0000-37260 Sewer Connection Fees Municipa 310,500 249,500 611,000 258,000 42% Total Sewer Fund Revenues:1,342,307$ 1,417,606$ 3,135,721$ 1,800,786$ 57.4% Sewer Fund Expenses: Personnel 602-495-9450-41010 Full-time Salaries 131,072 147,885 161,099 115,290 72% 602-495-9450-41020 Overtime 8,581 10,418 8,402 6,087 72% 602-495-9450-41210 PERA Contributions 30,413 11,720 12,082 8,984 74% 602-495-9450-41216 MSRS Contributions -City Admin 317 344 351 251 72% 602-495-9450-41220 FICA Contributions 8,013 9,423 10,509 7,716 73% 602-495-9450-41230 Medicare Contributions 1,881 2,214 2,458 1,805 73% 602-495-9450-41300 Insurance 27,098 30,814 33,348 23,088 69% 602-495-9450-41325 Life Insurance 115 110 115 86 75% 602-495-9450-41330 STD/LTD 738 776 876 568 65% 602-495-9450-41600 Safety Clothing Allowance - 225 140 140 100% 602-495-9450-41301 Unemployment Insurance - - - - #DIV/0! 602-495-9450-41510 Workers Compensation 1,978 4,104 2,586 4,651 180% Total Personnel 211,487$ 218,033$ 231,965$ 168,666$ 72.7% Materials and Supplies 602-495-9450-42210 Repair/Maint. Supplies 10,435 4,262 12,000 6,023 50% 602-495-9450-42000 Office Supplies 490 580 400 345 86% 602-495-9450-42030 Printed Forms 600 335 600 735 123% 602-495-9450-42120 Fuel, Oil and Fluids 11,742 9,687 10,750 3,742 35% 602-495-9450-42150 Operating Suppies 412 467 750 51 7% 602-495-9450-44375 Personal Protective Equipment 538 74 400 183 46% 602-495-9450-42400 Small Tools & Minor Equipment 1,821 7,092 5,000 4,002 80% Total Materials and Supplies 26,434$ 22,496$ 29,900$ 15,563$ 52.0% Charges and Services 602-495-9450-43030 Engineering Services 894 1,040 12,000 4,514 38% 602-495-9450-43010 Audit Services 8,244 9,825 11,425 11,844 104% 602-495-9450-43090 Newsletter 709 - 1,610 - 0% 602-495-9450-43150 Contract Services 34,367 88,351 52,500 32,370 62% 24 602 Sewer Fund Water, Sewer & Stormwater are separate Utility (aka Enterprise or Proprietary) Funds. 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget 602-495-9450-43185 IT Support 5,158 6,379 6,006 5,186 86% 602-495-9450-42002 IT Hardware - 128 2,520 3,095 123% 602-495-9450-43190 Software Programs 8,404 8,124 11,000 5,372 49% 602-495-9450-43210 Telephone 1,965 2,300 2,065 1,226 59% 602-495-9450-43220 Postage 2,222 2,820 3,675 1,390 38% 602-495-9450-43310 Mileage - - - - #DIV/0! 602-495-9450-43610 Insurance 4,477 15,790 16,372 14,308 87% 602-495-9450-43810 Electric Utility 24,076 24,420 30,000 17,471 58% 602-495-9450-43820 Sewer Utility - Met Council 422,284 526,641 644,326 537,388 83% 602-495-9450-44010 Repairs/Maint Imp Bldgs 591 2,988 1,000 10,084 1008% 602-495-9450-44040 Repairs/Maint. Equip.6,699 4,409 4,500 7,335 163% 602-495-9450-44150 Equipment Rental 9,063 11,500 1,500 - 0% 602-495-9450-44170 Uniforms 458 695 600 348 58% 602-495-9450-44030 Repairs\Maint Imp Not Bldgs 14,785 21,321 6,500 6,202 95% 602-495-9450-44370 Conferences & Training 2,919 2,472 2,500 3,338 134% 602-495-9450-44377 Credit Card Fees 11,223 10,750 13,000 4,600 35% Total Charges and Services 558,537$ 739,954$ 823,098$ 666,070$ 80.9% Capital Outlay 602-495-9450-45300 Improvements Other Than Bldgs 3,208 - 289,102 314,211 109% Total Capital Outlay 3,208$ -$ 289,102$ 314,211$ 108.7% Miscellaneous and Non-operating 602-495-9450-44300 Miscellaneous Expenses 70 37,587 350 4,418 1262% 602-495-9450-46010 Bond Principal - - 950,000 950,000 100% 602-495-9450-46110 Bond Interest 257,775 333,080 397,495 397,494 100% 602-495-9450-46220 Deferred Charges Amort - - - - #DIV/0! 602-495-9450-46350 Bond Issuance Costs - - - - #DIV/0! 602-495-9450-46200 Fiscal Agent Fees - 255 - - #DIV/0! 602-495-9450-47200 Transfer Out - - - - #DIV/0! Total Misc. and Non-operating 257,845$ 370,922$ 1,347,845$ 1,351,912$ 100.3% Total Sewer Fund Expenses:1,057,512$ 1,351,406$ 2,721,910$ 2,516,422$ 92.5% Net Sewer Fund Revs. Over/(Under) Expenses:284,795.05$ 66,200.49$ 413,810.82$ (715,635.68)$ 25 603 Stormwater Fund Water, Sewer & Stormwater are separate Utility (aka Enterprise or Proprietary) Funds. 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget Stormwater Fund Revenues: 603-000-0000-37300 Surface Water Utility Sales 507,204 574,045 597,622 103,912 17% 603-000-0000-34113 SW Review Fee Revenue 33,528 30,323 36,050 12,425 34% Total Stormwater Fund Revenues:525,869$ 604,367$ 638,072$ 143,587$ 22.5% Stormwater Fund Expenses: Personnel 603-496-9500-41010 Full-time Salaries 77,290 70,154 89,117 67,566 76% 603-496-9500-41020 Overtime - - - - #DIV/0! 603-496-9500-41210 PERA Contributions 17,472 5,261 6,684 4,439 66% 603-496-9500-41216 MSRS Contributions -City Admin 159 172 175 126 72% 603-496-9500-41220 FICA Contributions 4,432 4,240 5,525 3,770 68% 603-496-9500-41230 Medicare Contributions 1,039 997 1,292 881 68% 603-496-9500-41300 Insurance 16,087 14,888 18,601 11,391 61% 603-496-9500-41325 Life Insurance 67 41 59 39 66% 603-496-9500-41330 STD/LTD 421 332 488 274 56% 603-496-9500-41600 Safety Clothing Allowance 125 125 125 - 0% 603-496-9500-41510 Workers' Compensation 772 5,294 1,904 1,543 81% Total Personnel 118,676$ 101,505$ 123,971$ 90,029$ 72.6% Materials and Supplies 603-496-9500-42000 Office Supplies 357 28 300 - 0% 603-496-9500-42120 Fuel, Oil and Fluids 4,397 4,123 4,500 3,569 79% 603-496-9500-42030 Printed Forms 600 177 550 387 70% 603-496-9500-42270 Repair/Maint. Maint Supplies 1,265 1,154 2,500 1,606 64% 603-496-9500-42150 Operating Supplies 9 - - - #DIV/0! 603-496-9500-44375 Personal Protective Equipment 411 - - - #DIV/0! 603-496-9500-42400 Small Tools & Minor Equipment 2,457 3,753 2,000 1,413 71% Total Materials and Supplies 9,495$ 9,235$ 9,850$ 6,975$ 70.8% Charges and Services 603-496-9500-43030 Engineering Services 4,677 9,095 12,500 5,370 43% 603-496-9500-43010 Audit Services 8,244 9,825 11,425 11,844 104% 603-496-9500-43150 Contract Services 5,650 15,131 7,500 11,647 155% 603-496-9500-43185 IT Support 3,362 3,943 3,021 3,081 102% 603-496-9500-42002 IT Hardware - - 624 581 93% 26 603 Stormwater Fund Water, Sewer & Stormwater are separate Utility (aka Enterprise or Proprietary) Funds. 2022 2023 2024 2024 YTD Account Number Description Actual Actual Budget Q3 % of Budget 603-496-9500-43190 Software Programs 8,059 8,116 12,000 5,286 44% 603-496-9500-43210 Telephone 572 422 441 280 64% 603-496-9500-44377 Credit Card Fees 3,053 5,644 5,200 2,303 44% 603-496-9500-43220 Postage 5,173 (831) 2,100 537 26% 603-496-9500-43610 Insurance 7,029 3,728 3,793 4,117 109% 603-496-9500-44010 Street Sweeping 33,421 38,135 32,000 20,046 63% 603-496-9500-44040 Repairs/Maint Equip 1,949 - 2,500 - 0% 603-496-9500-44030 Repairs/Maint Not Bldg - 10,997 25,000 - 0% 603-496-9500-44150 Equipment Rental 1,813 3,500 750 - 0% 603-496-9500-44170 Uniforms 185 218 225 140 62% 603-496-9500-44330 Dues & Subscriptions 780 831 915 1,250 137% 603-496-9500-44370 Conferences & Training 1,664 - 650 1,010 155% Total Charges and Services 85,629$ 108,755$ 120,644$ 68,369$ 56.7% Capital Outlay 603-496-9500-45300 Improvements Other Than Bldgs - - 800,000 202,361 25% Total Capital Outlay -$ -$ 800,000$ 202,361$ 25.3% Miscellaneous and Non-operating 603-496-9500-44300 Miscellaneous Expenses 538 643 800 872 109% 603-496-9500-46010 Bond Principal - - 215,000 215,000 100% 603-496-9500-46110 Bond Interest 45,005 40,518 43,738 43,737 100% Total Misc. and Non-operating 737,382$ 832,719$ 259,538$ 259,609$ 100.0% Total Stormwater Fund Expenses:951,183$ 1,052,213$ 1,314,003$ 627,343$ 47.7% Net Stormwater Fund Revs. Over/(Under) Expenses:(425,314)$ (447,846)$ (675,931)$ (483,756)$ 27 1Q 24 2Q 24 3Q 24 4Q 24 2024 YTD 2023 2022 ADMINISTRATION Licenses & Permits 17 61 43 121 138 147 Communications metric 56924 63440 71674 192038 157452 n/a Recruitments Open 7 0 2 9 13 88% Recruitments Closed 0 3 2 5 11 Council Agenda Items processed 122 103 90 315 299 470 Data/Information Requests 2 6 3 11 28 470 BUILDING Value of Commercial/MF Projects Constructed $6,200,000.00 $35,100,000.00 $4,800,000.00 $46,100,000.00 $34,981,778.00 $25,189,354.00 Value of Residential New Homes Constructed $8,895,000.00 $9,188,000.00 $9,871,000.00 $27,954,000.00 $55,557,525.00 $69,557,246.00 Total Residential Permits (AT/TD)18 26 22 66 167 200 Total Number of Permits Issued 197 387 292 876 1923 2571 % permits reviewed within 10 days 92%93 94 93.00%93.00%90 Total Permit Revenue/Plan Review Fee $358,196.36 $954,373.12 $382,247.73 $1,694,817.21 $1,810,431.03 $2,403,176.96 Total Number of Inspections Performed 1819 1351 1507 4677 9831 9377 PUBLIC WORKS # of water leaks/breaks from main line 2 4 3 9 26 13 # of sewer related issues 2 5 5 12 8 6 # of weather events affecting streets or stormwater 5 6 2 13 38 29 # of issues at the 17 improved Parks for non-routine repair or maintenance 10 30 23 63 56 85 Total # of gallons of water pumped from wells per quarter 49,743,000 97,325,000 150,470,000 297,538,000 543,141,000 400090000 Average number of comm/residential complaints per week 5 6 15 26 27 4 PUBLIC SAFETY FIRE - Number of Fire/Rescue/EMS Responses: 264 270 305 839 1047 791 FIRE - Number of Fire Inspections:123 172 231 526 649 514 FIRE - Average Fire/Rescue Per 1,000 Residents (14,100 pop):6.32 6.87 10.99 24.18 9.95 5.89 FIRE - Average EMS Incidents per 1,000 Residents (14,100 pop):12.41 12.27 10.64 35.32 17.28 9.99 FIRE - Average Alarm to Enroute time in minutes:1.28 1.1 1.24 3.62 3.07 n/a FIRE - Average Alarm to Arrival time in minutes:7.53 6.5 7.29 7.11 10.62 n/a FIRE - Staffed turnout time within 90 seconds (Fire/Rescue) %:52%49%47%49.33%y n/a FIRE - Staffed turnout time within 60 seconds (EMS) %:70%79%56%68.33%y n/a Sheriff Department - Crime calls 102 57 79 238 266 n/a Sheriff Department - Quality of Life calls 380 438 544 1362 1057 n/a Sheriff Department - Traffic Incidents 949 1117 1179 3245 3026 n/a FINANCE # of Water customers / billed 3547 3554 3582 10683 13383 12645 # of Sewer customers / billed 2564 2574 2613 7751 9543 8626 # of Stormwater customers / billed 05 acct. (just storm - billed annually after Q4) 0 0 0 0 1928 2095 # of Stormwater customers / billed 01 acct. (both together)3477 3510 3537 10524 13251 4372 PLANNING Code Enforcement - Complaints Received (*updated definitions)15 42 25 82 74 127 Code Enforcement - Violaton Cases Closed 11 34 20 65 21 56 Zoning and Land Use Questions 380 420 370 1170 824 808 Zoning Permits 38 117 31 186 184 177 Land Use Applications and Long Range Planning 19 14 14 47 49 38 Water Sewer Stormwater 3140 2 65 63 31 3228 117 2515 52 2 13 1 20 35 191 36 17 192 12 Totals 3582 2613 3537 2023 2022 4779.64286 4516.07143 From Quarterly Bill Register