HomeMy WebLinkAbout#29 - 3rd Quarter Dashboards1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total
Licenses 8 7 1 16
ROW Permits 15 27 27 69
FRESH Opens 7346 8534 9562 25442
Facebook Posts 20 39 51 110
Unique Website
Visits 15313 14506 17885 47704
Recruitments
Open/Closed 5/6 1/1 1-Apr 6/7
Council Agenda
Items Processed 122 97 106 325
Data Requests
Submitted/# of
Docs to Fulfill 5/7 9/433 5 / 5
Deposits Made 22 42 40 104
Scanned files 304 138 117 559
Notes: Q.1 - 3 driveway conrtactor lic., 1 chichen permit, 4 waste haulers lic.
Q.2 - 3 driveway contractor lic., 2 waste haulers lic, 1 bee.
Q.3 - 2 driveway contractor lic, 1 chicken
Polco Survey Results Attached
Summary of 2022 Administration Department Activity
STAFF REPORT
DATE: October 18, 2022
TO: Mayor and Council FROM: Kristina Handt, City Administrator
AGENDA ITEM: 3rd Quarter Financial Reports
BACKGROUND: Staff has prepared the 3rd Quarter Financial Reports for review by the City Council. ISSUE BEFORE THE COUNCIL: Does the Council have any questions on the 3rd Quarter Financial Report? DISCUSSION: The Budget vs. Actual for 3rd quarter 2022 is attached with explanations alongside line items to explain variances from the budget. This format aligns with the budget worksheets used during the 2022 budget
cycle. Revenues: While the City received over half of its annual property tax allotment in July, staff has funded the debt levy 100% first and will allocate the remaining amount of funds to the general fund with the December and January collections. Licenses and Permits and Charges for Services have exceeded budget for the year due to commercial building activity, about 900 roof permits due to the hail storm, and AUAR fees from Wildflower along with fence and encroachment agreements. Fines and forfeitures are below expectations and interest income will be booked at the end of the year. See the attachments related to investment for more info on interest income earned.
Water and Sewer bills were mailed the first week of October so that’s why sales revenues appear off (timing issue). We are seeing fewer plats than expected and that is resulting in WAC and SAC being below budgeted numbers. Only one plat was planned for the moratorium area the rest were outside the moratorium but
experiencing delays (Shiltgen, Easton Village, Apts on Hudson, etc.). Expenditures: Expenditures reflect a combination of ongoing expenses and items that are one-time payments per year. Personnel costs in almost all areas are below were anticipated due to vacancies and hire dates. Last quarter we noted this for planning, building and fire. This quarter we are also seeing it in administration, communications, finance and utilities. We are also seeing the impact of fuel price increase on many of our departments. A number of parks items have been purchased for the season already so those line items are nearly spent for the year. Water fund expenses overall are lower than expected. Less staff time spent in this area due to the challenges in getting meters to continue the meter change out program. Capital outlay will also come in less than
budgeted with respect to the use of cash. Of the $6.2 million budgeted, $4.1 million was to be for the water
tower which has been bonded for instead due to the sale of land not occurring. Overall sewer expense are where they were anticipated to be at 72% of the budget year to date. One of the
lift stations was hit by lightning and reimbursed by insurance. Stormwater expenses are for the most part where they were expected to be. A couple of exceptions and
expected budget overages are for postage and credit card fees (due to switch to quarterly billing). FISCAL IMPACT: As noted. ATTACHMENTS:
1) 3rd Quarter Budget-to-Actual Reports 2) 3rd Quarter Investment Update
2022 2022 YTD % of
Account Number Description Adopted 9/30/2022 Budget
General Fund Revenues:
Taxes
101-410-1320-31010 Current Ad Valorem Taxes 4,689,073 1,297,122$ 27.66%
101-410-1320-31020 Delinquent Ad Valorem Taxes 15,000 20,575 137.17%
101-410-1320-31030 Mobile Home Tax 15,000 2,539 16.93%
101-410-1320-31040 Fiscal Disparities 294,401 182,108 61.86%
101-410-1320-31910 Penalty & Interest on Taxes 100 528 528.00%
Total Taxes 5,013,574 1,502,872$ 29.98%
Property taxes are collected in 3 instalements ( July, December and
January of the following year) with debt paid 100% in July settlement
Licenses and Permits
101-410-1320-32110 Liquor License 10,000 0.00%Receipt in Q4
101-410-1320-32180 Wastehauler License 720 1,200 166.67%More than anticipated. Paid at the beginning of year
101-410-1320-32181 General Contractor License 300 450 150.00%Paid in the first quarter
101-420-2400-32210 Building Permits 800,000 737,397 92.17%commercial permits were unbudgeted
101-430-3100-32211 Driveway Permits 12,500 10,650 85.20%
101-420-2400-32212 Fireplace Permits 16,000 8,340 52.13%
101-420-2400-32220 Heating Permits 70,000 51,436 73.48%
101-420-2400-32230 Plumbing Permits 80,000 63,726 79.66%
101-420-2400-32232 Pool Permits 1,500 1,650 110.00%
101-420-2400-32213 Siding Permits 4,000 24,118 602.95%greater activity than expected due to hail storms
101-420-2400-32214 Roof Permits 15,000 360,823 2405.49%greater activity than expected due to hail storms-900 roofing permits
101-430-3100-32250 Utility Permits 30,000 28,892 96.31%
101-420-2220-32260 Burning Permit 1,700 1,675 98.53%
101-410-1320-32270 Massage Therapy Licenses 150 0.00%Receipt in Q4
101-420-2400-32275 Fire Suppression Permits 5,000 9,472 189.44%
101-420-2400-32278 Fire Permit Plan Check Fee 1,000 0.00%
101-410-1320-32281 Golf Cart Operation Permit 30 90 300.00%
101-410-1320-32282 Miscellaneous Permits 100 50 50.00%
Total Licenses and Permits 1,048,000 1,299,969$ 124.04%
Intergovernmental
101-430-3100-33418 MSA - Maintenance 168,689 198,154 117.47%
101-420-2220-33420 State Fire Aid 76,608 0.00%pass through in Q4
101-420-2220-33426 Miscellaneous State Grants 3,500 3,664 104.69%
101-450-5200-33426 Miscellaneous State Grants 4,820 3,159 65.54%
101-410-1320-33623 Payment in Lieu of Taxes 34,779 0.00%Receipt in Q4
101-410-1320-33521 Recycling Grant 10,000 14,004 140.04%
Total Intergovernmental 298,396 218,981$ 73.39%
Charges for Services
101-410-1910-34103 Zoning & Subdivision Fees 45,000 82,925 184.28%
Village AUAR fee for Wildflower 4th, signficant fence and
encroachment fees
101-420-2400-34104 Plan Check Fees 520,000 480,645 92.43%commercial permits unbudgeted
101-410-1520-34107 Assessment Searches 2,500 2,080 83.20%
101-410-1450-34111 Cable Operation Reimbursement 5,000 0.00%
101-420-2400-34112 Planning & Zoning Review Fee 25,000 17,500 70.00%
101-430-3100-34114 Street Light Fee 1,500 966 64.40%
101-410-1910-34115 Base Map Upgrading Fee 6,200 1,025 16.53%
101-410-1910-36206 Escrow Administration Fee 25,000 16,800 67.20%
Total Charges for Services 630,200 601,941$ 95.52%
Fines and Forfeits
101-420-2100-35100 Fines 35,000 20,407 58.31%
101-420-2100-35130 Forfeitures
Total Fines and Forfeits 35,000 20,407$ 58.31%
Investment Earnings
101-410-1320-36210 Interest Earnings 38,500 0.00%will book at end of year
Total Investment Earnings 38,500 -$ 0.00%
Miscellaneous
101-410-1320-31811 Cable Franchise Revenue 50,000 77,694 155.39%
101-410-1320-36200 Miscellaneous Revenue 3,000 4,617 153.90%
101-420-2220-36200 Miscellaneous Revenue 300
101-430-3100-36200 Miscellaneous Revenue 500 6,666 1333.20%insurance refund and scrap revenue
101-410-1910-36200 Miscellaneous Revenue 100 0.00%
101-420-2220-36204 Reimbursements - Fire 5,000 25,535 510.70%$20k in employer SS reimbursement
101-420-2220-36230 Donations-Fire 1,000 100 10.00%
101-410-1320-36230 Donations 10,000 12,000 120.00%jaycees
101-410-1320-34120 Tower Rent 114,767 96,913 84.44%
Total Miscellaneous 184,367 223,825$ 121.40%
Prior Period Adjustments
Total General Fund Revenues:7,248,537 3,867,995$ 53.36%
General Fund Expenditures:
1110 Mayor & Council
Personnel
101-410-1110-41030 Part-time Salaries 25,690 12,845 50.00%
101-410-1110-41220 FICA Contributions 1,593 796 49.97%
101-410-1110-41230 Medicare Contributions 373 186 49.87%
101-410-1110-41510 Workers Compensation 150 86 57.33%
Total Personnel 27,806 13,913$ 50.04%
Materials and Supplies
101-410-1110-42000 Office Supplies 125 0.00%
101-410-1110-42001 Computer Reimbursement
101-410-1110-43310 Mileage 300 191 63.67%
101-410-1110-43185 IT Support 1,322 991 74.96%
Total Materials and Supplies 1,747 1,182$ 67.66%
Charges and Services
101-410-1110-44300 Miscellaneous 7,500 5,412 72.16%
101-410-1110-44330 Dues & Subscriptions 18,150 17,092 94.17%
101-410-1110-44370 Conferences & Training 1,000 1,301 130.10%
Total Charges and Services 26,650 23,805$ 89.32%
1110 Total Mayor & Council 56,203 38,900$ 69.21%
1320 Administration
Personnel
101-410-1320-41010 Full-time Salaries 176,559 116,450 65.96%no asst admin since may
101-410-1320-41210 PERA Contributions 13,242 8,684 65.58%
101-410-1320-41216 MSRS Contributions -City Admin 1,540 1,093 70.97%
101-410-1320-41220 FICA Contributions 10,947 6,919 63.20%
101-410-1320-41230 Medicare Contributions 2,560 1,618 63.20%
101-410-1320-41300 Insurance 34,278 16,196 47.25%
101-410-1320-41325 Life Insurance 127 81 63.78%
101-410-1320-41330 STD/LTD 927 581 62.68%
101-410-1320-41420 Unemployment Benefits
101-410-1320-41510 Workers Compensation 2,313 1,179 50.97%
Total Personnel 242,493 152,801$ 63.01%
Materials and Supplies
101-410-1320-42000 Office Supplies 3,200 555 17.34%
101-410-1320-42030 Printed Forms 100 0.00%
Total Materials and Supplies 3,300 555$ 16.82%
Charges and Services
101-410-1320-43100 Assessing Services 107,388 107,874 100.45%
101-410-1320-43040 Legal Services 87,500 22,152 25.32%
101-410-1320-43150 Contract Services 45,000 29,470 65.49%
101-410-1320-43185 IT Support 5,262 3,947 75.01%
101-410-1320-42002 IT Hardware 1,200 0.00%
101-410-1320-43210 Telephone 2,200 368 16.73%
101-410-1320-43220 Postage 3,600 3,376 93.78%increase in mailings for projects
101-410-1320-43310 Mileage 1,100 408 37.09%
101-410-1320-43510 Legal Publishing 2,500 1,260 50.40%
101-410-1320-43610 Insurance 45,294 43,543 96.13%paid for year
101-410-1320-44330 Dues & Subscriptions 2,200 1,454 66.09%
101-410-1320-44370 Conferences & Training 5,000 2,377 47.54%
101-410-1320-44371 Allocation to Building Inspections (2,606)0.00%calculated at end of year
Total Charges and Services 305,638 216,229$ 70.75%
Miscellaneous
101-410-1320-44300 Miscellaneous 3,750 374 9.97%
Total Miscellaneous 3,750 374$ 9.97%
1320 Total Administration 555,181 369,959$ 66.64%
1410 Elections
Personnel
101-410-1410-41030 Part-time Salaries 8,500 3,575 42.06%
101-410-1410-41510 Workers Compensation
Total Personnel 8,500 3,575$ 42.06%
Charges and Services
101-410-1410-43310 Travel Expense 50 0.00%
101-410-1410-42000 Office Supplies 300 0.00%
101-410-1410-43510 Legal Notices Publishing 350 90 25.71%
101-410-1410-43150 Contract Services 3,195 3,195 100.00%election machine annual fee
Total Charges and Services 3,895 3,285$ 84.34%
Capital Outlay
101-480-8000-45800 Other Equipment
Total Capital Outlay
Miscellaneous
101-410-1410-44300 Miscellaneous 1,000 464 46.40%
Total Miscellaneous 1,000 464$ 46.40%
1410 Total Elections 13,395 7,324$ 54.68%
1450 Communications
Personnel
101-410-1450-41010 Full-time Salaries 28,778 11,931 41.46%position vacant since May
101-410-1450-41210 PERA Contributions 2,158 845 39.16%
101-410-1450-41220 FICA Contributions 1,784 739 41.42%
101-410-1450-41230 Medicare Contributions 417 173 41.49%
101-410-1450-41300 Insurance 7,438 1,134 15.25%
101-410-1450-41325 Life Insurance 28 10 35.71%
101-410-1450-41330 STD/LTD 158 54 34.18%
101-410-1450-41510 Workers Compensation 338 189 55.92%
Total Personnel 41,099 15,075$ 36.68%
Charges and Services
101-410-1450-43090 Newsletter 1,400 709 50.64%
101-410-1450-43185 IT Support 1,134 365 32.19%
101-410-1450-42002 IT Hardware
101-410-1450-43190 Software Programs 700 1,200 171.43%website fee
101-410-1450-43210 Telephone
101-410-1450-43220 Postage 642 309 48.13%spring newsletter
101-410-1450-43310 Mileage
101-410-1450-43510 Public Notices
101-410-1450-43152 Cable Operations 5,000 2,192 43.84%
101-410-1450-44370 Conferences and Training
Total Charges and Services 8,876 4,775$ 53.80%
1450 Total Communications 49,975 19,850$ 39.72%
1520 Finance
Personnel
101-410-1520-41010 Full-time Salaries 79,358 38,244 48.19%finance director vacancy since June
101-410-1520-41210 PERA Contributions 5,952 2,742 46.07%
101-410-1520-41220 FICA Contributions 4,920 2,273 46.20%
101-410-1520-41230 Medicare Contributions 1,151 532 46.22%
101-410-1520-41300 Insurance 14,631 7,257 49.60%
101-410-1520-41325 Life Insurance 54 28 51.85%
101-410-1520-41330 STD/LTD 468 272 58.12%
101-410-1520-41420 Unemployment Benefits 414
101-410-1520-41510 Workers Compensation 781 517 66.20%
Total Personnel 107,315 52,279$ 48.72%
Materials and Supplies
101-410-1520-42000 Office Supplies 880 507 57.61%
101-410-1520-42030 Printed Forms 1,670 1,001 59.94%
Total Materials and Supplies 2,550 1,508$ 59.14%
Charges and Services
101-410-1520-43010 Audit Services 8,706 8,244 94.69%
101-410-1520-43150 Contract Services 30,000 18,013 60.04%
101-410-1520-43185 IT Support 2,266 1,700 75.02%
101-410-1520-42002 IT Hardware
101-410-1520-43190 Software Programs 7,192 775 10.78%
101-410-1520-43210 Telephone
101-410-1520-43310 Mileage 200 0.00%
101-410-1520-44330 Dues & Subscriptions 1,470 530 36.05%
101-410-1520-44370 Conferences & Training 1,600 0.00%
101-410-1520-44371 Allocation to Building Inspections (1,751)0.00%allocated end of year
Total Charges and Services 49,683 29,262$ 58.90%
Miscellaneous
101-410-1520-44300 Miscellaneous 3,500 680 19.43%
Total Miscellaneous 3,500 680$ 19.43%
1520 Total Finance 163,048 83,729$ 51.35%
1910 Planning & Zoning
Personnel
101-410-1910-41010 Full-time Salaries 223,805 130,510 58.31%No City Planner in Q1
101-410-1910-41040 Temporary Employees 390
101-410-1910-41210 PERA Contributions 16,785 9,788 58.31%No City Planner in Q1
101-410-1910-41220 FICA Contributions 13,876 7,885 56.82%No City Planner in Q1
101-410-1910-41230 Medicare Contributions 3,245 1,844 56.83%No City Planner in Q1
101-410-1910-41300 Insurance 48,925 10,916 22.31%No City Planner in Q1
101-410-1910-41325 Life Insurance 182 62 34.07%No City Planner in Q1
101-410-1910-41330 STD/LTD 1,268 427 33.68%
101-410-1910-41510 Workers Compensation 1,913 1,138 59.49%
Total Personnel 309,999 162,960$ 52.57%
Materials and Supplies
101-410-1910-42000 Office Supplies 250 453 181.20%maping costs due to plotter being broken
101-410-1910-42030 Printed Forms
Total Materials and Supplies 250 453$ 181.20%
Charges and Services
101-410-1910-43030 Engineering Services 10,000 4,583 45.83%
101-410-1910-43150 Contract Services 10,000 8,622 86.22%BMI in Q1 before planner hired
101-410-1910-43185 IT Support 5,291 3,968 75.00%
101-410-1910-42002 IT Hardware 480 2,091 435.63%CEO Computer
101-410-1910-43190 Software Programs 500 936 187.20%CEO adobe and office
101-410-1910-43210 Telephone 680 151 22.21%
101-410-1910-43220 Postage 100 80 80.00%
101-410-1910-43310 Mileage 300 0.00%
101-410-1910-43510 Legal Publishing 700 1,441 205.86%city code notices-fences, pools, screening, etc
101-410-1910-44330 Dues & Subscriptions 500 698 139.60%
101-410-1910-44350 Books
101-410-1910-44370 Conferences & Training 1,000 1,396 139.60%
Total Charges and Services 29,551 23,966$ 81.10%
Miscellaneous
101-410-1910-44300 Miscellaneous 100 228 228.00%CEO safety boots
Total Miscellaneous 100 228$ 228.00%
1910 Total Planning & Zoning 339,900 187,607$ 55.19%
1930 Engineering Services
Charges and Services
101-410-1930-43030 Engineering Services 35,000 20,975 59.93%
Total Charges and Services 35,000 20,975$ 59.93%
Capital Outlay
101-480-8000-45900 Construction Projects
Total Capital Outlay
1930 Total Engineering Services 35,000 20,975$ 59.93%
1940 City Hall
Materials and Supplies
101-410-1940-42110 Cleaning Supplies 200 331 165.50%high efficiency toilets, rebate offsets $297
101-410-1940-42230 Building Repair Supplies 1,000 225 22.50%
Total Materials and Supplies 1,200 556$ 46.33%
Charges and Services
101-410-1940-43185 IT Support 1,322 991 74.96%
101-410-1940-42002 IT Hardware
101-410-1940-43190 Software Programs
101-410-1940-43210 Telephone 250
101-410-1940-43810 Utilities 17,592 17,788 101.11%
increased usage do to more staff in builidng and covering brookfield
costs from earlier in year
101-410-1940-43840 Refuse 1,697 1,349 79.49%
101-410-1940-44010 Repairs/Maint Contractual Bldg 13,200 10,132 76.76%
101-410-1940-44040 Repairs/Maint Contractual Eqpt 16,000 2,840 17.75%
101-410-1940-44371 Allocation to Building Inspections (32,623)0.00%calculated end of year
Total Charges and Services 17,188 33,350$ 194.03%
Miscellaneous
101-410-1940-44300 Miscellaneous 30,000 18,331 61.10%
Total Miscellaneous 30,000 18,331$ 61.10%
1940 Total City Hall 48,388 52,237$ 107.95%
2100 Police
Charges and Services
101-420-2100-43150 Law Enforcement Contract 946,410 473,839 50.07%first half paid in July
101-420-2100-44301 Misc. - Community Event 1,800 0.00%
Total Charges and Services 948,210 473,839$ 49.97%
2100 Total Police 948,210 473,839$ 49.97%
2150 Prosecution
Charges and Services
101-420-2150-43045 Attorney Criminal 51,000 32,094 62.93%
Total Charges and Services 51,000 32,094$ 62.93%
2150 Total Prosecution 51,000 32,094$ 62.93%
2220 Fire
Personnel
101-420-2220-41010 Full-time Salaries 344,251 176,446 51.26%late start for new FF
101-420-2220-41030 Part-time Salaries 94,240 48,257 51.21%vacant pt admin and other shifts
101-420-2220-41035 Paid On Call Salaries 94,229 50,529 53.62%a month behind due to process
101-420-2220-41210 PERA Contributions 72,932 37,405 51.29%late start for new FF
101-420-2220-41220 FICA Contributions 33,029 3,669 11.11%budget wrong to include FT FF
101-420-2220-41230 Medicare Contributions 7,724 3,912 50.65%late start for new FF
101-420-2220-41300 Insurance 69,741 22,631 32.45%late start for new FF
101-420-2220-41325 Life Insurance 252 91 36.11%late start for new FF
101-420-2220-41330 STD/LTD 2,286 709 31.01%late start for new FF
101-420-2220-41420 Unemployment Benefits 6,652
101-420-2220-41510 Workers Compensation 43,316 28,673 66.19%
Total Personnel 762,000 378,974$ 49.73%
Materials and Supplies
101-420-2220-42000 Office Supplies 1,000 834 83.40%
101-420-2220-42080 EMS Supplies 2,400 786 32.75%
101-420-2220-42090 Fire Prevention 2,000 217 10.85%
101-420-2220-42120 Fuel, Oil and Fluids 14,000 17,436 124.54%increase in fuel prices
101-420-2220-42400 Small Tools & Equipment 25,419 11,526 45.34%
Total Materials and Supplies 44,819 30,799$ 68.72%
Charges and Services
101-420-2220-43050 Physicals 8,500 1,542 18.14%
101-420-2220-43150 Contract Services 3,500 0.00%
101-420-2220-43185 IT Support 19,418 14,857 76.51%
101-420-2220-42002 IT Hardware 3,400 174 5.12%
101-420-2220-43190 Software Programs 3,730 2,995 80.29%
101-420-2220-43210 Telephone 4,660 2,352 50.47%
101-420-2220-43230 Radio 21,499 8,202 38.15%
101-420-2220-43310 Mileage 500 180 36.00%
101-420-2220-43630 Insurance 11,514 10,112 87.82%paid in full for year
101-420-2220-43810 Utility 15,914 11,728 73.70%
101-420-2220-43840 Refuse 1,061 167 15.74%
101-420-2220-44010 Repairs/Maint Bldg 9,000 2,844 31.60%
101-420-2220-44040 Repairs/Maint Eqpt 43,920 26,350 60.00%
101-420-2220-44170 Uniforms 10,000 5,581 55.81%
101-420-2220-44330 Dues & Subscriptions 3,450 2,476 71.77%
101-420-2220-44350 Books 1,000 112 11.20%
101-420-2220-44370 Conferences & Training 24,568 13,444 54.72%
Total Charges and Services 185,634 103,116$ 55.55%
Capital Outlay
101-420-2220-47200 Transfer to Vehicle Replacement Fund 51,537 0.00%end of year
101-480-8000-45800 Equipment 92,286 0.00%turnout gear invoiced 4th qtr
Total Capital Outlay 143,823 0.00%
Miscellaneous
101-420-2220-44300 Miscellaneous 2,000 1,385 69.25%
Total Miscellaneous 2,000 1,385$ 69.25%
2220 Total Fire 1,138,276 514,274$ 45.18%
2220 Fire Relief
Charges and Services
101-420-2220-44920 Fire State Aid 76,608 0.00%pass through Q4
Total Charges and Services 76,608 0.00%
2250 Total Fire Relief 76,608 0.00%
2400 Building Inspection
Personnel
101-420-2400-41010 Full-time Salaries 427,111 244,241 57.18%one less inspector Feb-Aug
101-420-2400-41210 PERA Contributions 32,033 19,120 59.69%one less inspector Feb-Aug
101-420-2400-41216 MSRS Contributions -City Admin 519 368 70.91%
101-420-2400-41220 FICA Contributions 26,481 13,724 51.83%one less inspector Feb-Aug
101-420-2400-41230 Medicare Contributions 6,193 3,385 54.66%one less inspector Feb-Aug
101-420-2400-41300 Insurance 90,962 46,029 50.60%one less inspector Feb-Aug
101-420-2400-41325 Life Insurance 344 164 47.67%one less inspector Feb-Aug
101-420-2400-41330 STD/LTD 2,473 938 37.93%one less inspector Feb-Aug
101-420-2400-41510 Workers Compensation 4,644 3,074 66.19%
Total Personnel 590,760 331,043$ 56.04%
Materials and Supplies
101-420-2400-42000 Office Supplies 1,750 500 28.57%
101-420-2400-42030 Printed Forms 350 0.00%
101-420-2400-42120 Fuel, Oil and Fluids 4,000 3,200 80.00%increase in fuel prices
Total Materials and Supplies 6,100 3,700$ 60.66%
Charges and Services
101-420-2400-43030 Engineering 5,000 24 0.48%
101-420-2400-43150 Inspector Contract Services 328,879 249,145 75.76%extra coverage due to commercial acitivty and one less inspector
101-420-2400-43185 IT Support 13,378 10,033 75.00%
101-420-2400-42002 IT Hardware 2,520 0.00%
101-420-2400-43190 Software Programs 3,500 3,416 97.60%additional adobe subscription to allow for electronic plan review
101-420-2400-43210 Telephone 6,170 878 14.23%
101-420-2400-43510 Legal Publishing
101-420-2400-43630 Insurance 5,458 3,600 65.96%paid in full for year
101-420-2400-44040 Repairs/Maint Eqpt 1,500 5,060 337.33%includes copier cost allocation
101-420-2400-44170 Uniforms 1,200 118 9.83%
101-420-2400-44330 Dues & Subscriptions 500 60 12.00%
101-420-2400-44350 Books 1,800 256 14.22%
101-420-2400-44370 Conferences & Training 4,000 944 23.60%
Total Charges and Services 373,905 273,534$ 73.16%
Capital Outlay
101-480-2400-47200 Transfer to Vehicle Replacement 9,539 0.00%end of year
Total Capital Outlay 9,539 0.00%
Miscellaneous
101-420-2400-44371 Allocations from Admin, Finance, City Hall 36,981 0.00%end of year calculation
101-420-2400-44300 Miscellaneous 1,000 670 67.00%
Total Miscellaneous 37,981 670$ 1.76%
2400 Total Building Inspection 1,018,285 608,947$ 59.80%
2500 Emergency Communications
Charges and Services
101-420-2500-43150 Contract Services 20,136 18,841 93.57%
Total Charges and Services 20,136 18,841$ 93.57%
2500 Total Emergency Communications 20,136 18,841$ 93.57%
2700 Animal Control
Charges and Services
101-420-2700-43150 Contract Services 13,000 9,288 71.45%
Total Charges and Services 13,000 9,288$ 71.45%
2700 Total Animal Control 13,000 9,288$ 71.45%
3100 Streets
Personnel
101-430-3100-41010 Full-time Salaries 386,752 258,986 66.96%
101-430-3100-41020 Overtime 9,748 7,433 76.25%
101-430-3100-41040 Temporary Employees 18,000 9,585 53.25%
101-430-3100-41210 PERA Contributions 29,738 19,982 67.19%
101-430-3100-41220 FICA Contributions 25,699 16,367 63.69%
101-430-3100-41230 Medicare Contributions 6,010 3,828 63.69%
101-430-3100-41300 Insurance 86,942 53,509 61.55%
101-430-3100-41325 Life Insurance 379 234 61.74%
101-430-3100-41330 STD/LTD 2,166 1,352 62.42%
101-430-3100-41600 Safety Clothing Allowance 800 225 28.13%
101-430-3100-41420 Unemployment Benefits -
101-430-3100-41510 Workers Compensation 54,483 36,065 66.19%
Total Personnel 620,717 407,566$ 65.66%
Materials and Supplies
101-430-3100-42000 Office Supplies 500 289 57.80%
101-430-3100-42120 Fuel, Oil and Fluids 22,000 25,938 117.90%increase in fuel prices
101-430-3100-42150 Operating Supplies 9,500 6,249 65.78%
101-430-3100-42210 Repair/Maint. Supplies 10,000 4,887 48.87%
101-430-3100-42212 Repair/Maint. Supplies S&I 10,000 5,649 56.49%
101-430-3100-42240 Street Maintenance & Landscaping - Materials 35,000 11,084 31.67%
101-430-3100-42260 Street Signs 4,000 2,435 60.88%
101-430-3100-42290 Sand/Salt S&I 62,000 57,401 92.58%purchased for the year
101-430-3100-42400 Small Tools & Minor Equipment 4,500 2,698 59.96%
101-430-3100-44375 Personal Protection Equipment 1,200 746 62.17%
Total Materials and Supplies 158,700 117,376$ 73.96%
Charges and Services
101-430-3100-43030 Engineering Services 14,000 5,477 39.12%
101-430-3100-43090 Sealcoating & Crack Sealing 1,015,000 106,454 10.49%payments will come in Q4
101-430-3100-43150 Contract Services 24,000 44,462 185.26%included payment on Manning/TH36 which was budgeted above
101-430-3100-43185 IT Support 17,309 13,476 77.86%
101-430-3100-42002 IT Hardware 750 0.00%
101-430-3100-43190 Software Programs 8,263 4,297 52.00%
101-430-3100-43210 Telephone 5,000 3,171 63.42%
101-430-3100-43230 Radio 6,750 4,634 68.65%
101-430-3100-43310 Mileage 100 0.00%
101-430-3100-43510 Public Notices 212 0.00%
101-430-3100-43630 Insurance 28,366 24,915 87.83%paid in full for year
101-430-3100-43810 Utilities 30,000 23,296 77.65%
101-430-3100-43811 Street Lights 45,000 38,514 85.59%
101-430-3100-43840 Refuse 5,500 5,543 100.78%mattress dumping-$1,253
101-430-3100-44010 Repairs/Maint Bldg.12,000 2,323 19.36%
101-430-3100-44030 Repairs/Maint Imp Other Than Bldg.850 0.00%
101-430-3100-44040 Repairs/Maint Equip 20,000 10,889 54.45%
101-430-3100-44041 Repairs/Maint Equip S&I 13,000 10,833 83.33%
101-430-3100-44130 Equipment Rental 1,250 540 43.20%
101-430-3100-44170 Uniforms 5,700 3,052 53.54%
101-430-3100-44330 Dues & Subscriptions 750 482 64.27%
101-430-3100-44370 Conferences & Training 4,175 2,445 58.56%
Total Charges and Services 1,257,975 304,803$ 24.23%
Capital Outlay
101-430-3100-47200 Transfer to Vehicle Replacement Fund 86,963 0.00%end of year
101-480-3100-45500 Capital Purchases 256,350 58,110 22.67%
Total Capital Outlay 343,313 58,110$ 16.93%
Miscellaneous
101-430-3100-44300 Miscellaneous 475 1,481 311.79%License renewals, increase in vehicles
Total Miscellaneous 475 1,481$ 311.79%
3100 Total Streets 2,381,180 889,336$ 37.35%
5200 Parks & Recreation
Personnel
101-450-5200-41010 Full-time Salaries 91,652 69,271 75.58%
101-450-5200-41020 Overtime 44
101-450-5200-41040 Temporary Employees 10,500 8,873 84.50%
101-450-5200-41210 PERA Contributions 6,874 5,199 75.63%
101-450-5200-41220 FICA Contributions 6,333 4,628 73.08%
101-450-5200-41230 Medicare Contributions 1,481 1,082 73.06%
101-450-5200-41300 Insurance 19,748 12,878 65.21%
101-450-5200-41325 Life Insurance 81 52 64.20%
101-450-5200-41330 STD/LTD 514 306 59.53%
101-450-5200-41600 Safety Clothing Allowance 270 0.00%
101-450-5200-41420 Unemployment Benefits
101-450-5200-41510 Workers Compensation 11,991 3,018 25.17%
Total Personnel 149,444 105,351$ 70.50%
Materials and Supplies
101-450-5200-42000 Office Supplies 450 260 57.78%
101-450-5200-42120 Fuel, Oil and Fluids 6,250 7,638 122.21%increase in fuel prices
101-450-5200-42150 Operating Supplies 750 964 128.53%most supplies have been purchased for the year
101-450-5200-42210 Repair/Maint. Supplies 7,250 9,445 130.28%most repairs have been done at parks for the year
101-450-5200-42230 Building Repair Supplies 500 740 148.00%staining, painting and repair projects complete for the year
101-450-5200-42250 Landscaping Materials 650 2,392 368.00%seeding at Lions, VFW, Goose lake, firefly
101-450-5200-42400 Small Tools & Minor Equipment 4,550 3,597 79.05%rakes, shovels, paint brushes, etc purchased at beginnign of season
Total Materials and Supplies 20,400 25,036$ 122.73%
Charges and Services
101-450-5200-43030 Engineering Services
101-450-5200-43150 Contracted Services 74,500 39,006 52.36%
101-450-5200-43185 IT Support 2,909 2,676 91.99%
101-450-5200-42002 IT Hardware
101-450-5200-43190 Software Programs
101-450-5200-43210 Telephone 1,750 430 24.57%
101-450-5200-43510 Public Notices
101-450-5200-43630 Insurance 8,644 7,593 87.84%paid in full for year
101-450-5200-43810 Utilities 11,139 9,334 83.80%
101-450-5200-43840 Refuse 4,000 1,933 48.33%
101-450-5200-44010 Repairs/Maint Bldg 3,000 2,708 90.27%plumbing repair at Lions due to freeze over winter
101-450-5200-44030 Repairs/Maint Imp Not Bldgs 3,200 912 28.50%
101-450-5200-44040 Repairs/Maint Eqpt 14,000 782 5.59%
101-450-5200-44120 Rentals - Buildings 7,000 6,135 87.64%
101-450-5200-44170 Uniforms 1,100 645 58.64%
101-450-5200-44301 Events 550 482 87.64%tree giveaway
101-450-5200-44302 Lakes 15,000 5,000 33.33%
101-450-5200-44330 Dues & Subscriptions
101-450-5200-44370 Conferences & Training 3,000 0.00%
101-450-5200-44130 Equipment Rental 750 882 117.60%added portapotties
101-450-5200-44375 Personal Protection Equipment 400 136 34.00%
Total Charges and Services 150,942 78,654$ 52.11%
Capital Outlay
101-450-5200-47200 Transfer to Vehicle Replacement Fund 1,961 0.00%end of year
101-900-5200-45500 Capital Purchases
Total Capital Outlay 1,961 0.00%
Miscellaneous
101-450-5200-44300 Miscellaneous 750 168 22.40%
Total Miscellaneous 750 168$ 22.40%
5200 Total Parks & Recreation 323,497 209,209$ 64.67%
9000 Transfers
Transfers
101-900-9000-47201 Transfer to Project Fund 17,254 0.00%end of year
Total Transfers 17,254 0.00%
9000 Total Transfers 17,254 0.00%
Total General Fund Expenditures:7,248,536 3,536,409$ 48.79%
Total Gen Fund Revs. Over/(Under) Expenditures:1 331,586$
601 Water Fund
Water Fund Revenues:
601-000-0000-36210 Interest on Investments 32,689 0.00%booked end of year
601-000-0000-37100 Water Sales 1,147,441 570,997 49.76%Q3 billed in Oct
601-000-0000-37120 Bulk Water 2,000 0.00%
601-000-0000-37130 Water Lat Benefit Fee 6,200
601-000-0000-37140 Water Access Revenue 1,104,000 337,000 30.53%fewer plats than anticpated
601-000-0000-37150 Water Connections - Municipal 456,000 271,000 59.43%fewer new connections than anticipated
601-000-0000-37170 Meter Sales 130,600 92,720 71.00%
Total Water Fund Revenues:2,872,730 1,277,917$ 44.48%
Water Fund Expenses:
Personnel
601-494-9400-41010 Full-time Salaries 309,664 205,553 66.38%
601-494-9400-41020 Overtime 8,395 5,441 64.81%
601-494-9400-41210 PERA Contributions 23,854 15,805 66.26%
601-494-9400-41216 MSRS Contributions -City Admin 634 450 70.98%
601-494-9400-41220 FICA Contributions 19,720 12,455 63.16%
601-494-9400-41230 Medicare Contributions 4,612 2,912 63.14%
601-494-9400-41300 Insurance 68,291 40,639 59.51%
601-494-9400-41325 Life Insurance 251 171 68.13%
601-494-9400-41330 STD/LTD 1,755 939 53.50%
601-494-9400-41301 Unemployment Insurance
601-494-9400-41600 Safety Clothing Allowance 665 225 33.83%
601-494-9400-41510 Workers Compensation 8,638 5,718 66.20%
Total Personnel 446,479 290,308$ 65.02%
Materials and Supplies
601-494-9400-42000 Office Supplies 750 651 86.80%
601-494-9400-42120 Fuel, Oil and Fluids 9,000 6,830 75.89%
601-494-9400-42030 Printed Forms 850 1,000 117.65%
601-494-9400-42150 Operating Supplies 3,200 763 23.84%
601-494-9400-42160 Chemicals 12,000 10,328 86.07%
601-494-9400-42210 Repair/Maint. Supplies 12,000 6,105 50.88%
601-494-9400-42300 Water Meters & Supplies 205,600 136,139 66.22%
601-494-9400-44375 Personal Protective Equipment 900 160 17.78%
601-494-9400-42400 Small Tools & Minor Equipment 7,500 969 12.92%
Total Materials and Supplies 251,800 162,945$ 64.71%
Charges and Services
601-494-9400-43030 Engineering Services 25,000 1,860 7.44%
601-494-9400-43040 Legal Services 40,000 9,778 24.45%
601-494-9400-43010 Audit Services 8,706 8,244 94.69%
601-494-9400-43090 Newsletter 1,300 709 54.54%
601-494-9400-43150 Contract Services 40,000 28,418 71.05%
601-494-9400-43180 Software Support 6,689
601-494-9400-43185 IT Support 9,817 7,407 75.45%
601-494-9400-42002 IT Hardware 1,350 0.00%
601-494-9400-43190 Software Programs 12,670 0.00%
601-494-9400-43210 Telephone 2,600 1,259 48.42%
601-494-9400-43220 Postage 4,142 1,998 48.24%
601-494-9400-43310 Mileage 200 51 25.50%
601-494-9400-43610 Insurance 12,768 11,215 87.84%paid in full for year
601-494-9400-43810 Electric Utility 78,020 93,612 119.98%new well
601-494-9400-43820 Water Utility 28,000 21,406 76.45%
601-494-9400-44030 Repairs\Maint Imp Not Bldgs 45,000 13,157 29.24%
601-494-9400-44040 Repairs/Maint. Equip.8,500 2,034 23.93%
601-494-9400-44010 Repairs\Maint Imp Bldgs 18,000 13,924 77.36%
601-494-9400-44150 Equipment Rental 1,000 0.00%
601-494-9400-44170 Uniforms 1,000 540 54.00%
601-494-9400-44330 Dues & Subscriptions 400 150 37.50%
601-494-9400-44370 Conferences & Training 2,450 3,372 137.63%more employees moved to next level of certification
601-494-9400-44377 Credit Card Fees 9,809 8,046 82.03%
601-494-9400-44386 Real Estate Taxes 16,119 15,416 95.64%paid in full for year
Total Charges and Services 366,851 249,285$ 67.95%
Capital Outlay
601-494-9400-45300 Improvments Other Than Bldgs 6,236,219 167,695 2.69%$4.1 m for water tower was bonded for instead of using cash
Total Capital Outlay 6,236,219 167,695$ 2.69%
Miscellaneous and Non-operating
601-494-9400-44300 Miscellaneous 2,000 1,139 56.95%
601-494-9400-46010 Bond Principal 880,000 545,000 61.93%
601-494-9400-46110 Bond Interest 235,572 186,326 79.10%
601-494-9400-46200 Fiscal Agent Fees - Bond Payments
Total Misc. and Non-operating 1,117,572 732,465$ 65.54%
Total Water Fund Expenses:8,418,921 1,602,698$ 19.04%
Total Water Fund Revs. Over/(Under) Expenses:(5,546,191)(324,781)$ 5.86%
602 Sewer Fund
Sewer Fund Revenues:
602-000-0000-36210 Interest on Investments 36,834 - 0.00%booked end of year
602-000-0000-37200 Sewer Sales 544,013 344,075 63.25%Q3 billed in October
602-000-0000-37220 SAC Early Pay discount/revenue 8,500 6,661 78.36%
602-000-0000-37230 Sewer Lat Benefit Fee 13,100
602-000-0000-37240 Sewer Connecton Fee Revenue (SAC)727,500 234,500 32.23%fewer plats than anticipated
602-000-0000-37260 Sewer Connection Fees Municipa 367,000 233,500 63.62%fewer connections than anticipated
Total Sewer Fund Revenues:1,683,847 831,836$ 49.40%
Sewer Fund Expenses:
Personnel
602-495-9450-41010 Full-time Salaries 132,323 93,266 70.48%
602-495-9450-41020 Overtime 7,676 6,084 79.26%
602-495-9450-41210 PERA Contributions 10,500 7,440 70.86%
602-495-9450-41216 MSRS Contributions -City Admin 317 225 70.98%
602-495-9450-41220 FICA Contributions 8,680 5,851 67.41%
602-495-9450-41230 Medicare Contributions 2,030 1,369 67.44%
602-495-9450-41300 Insurance 30,046 19,365 64.45%
602-495-9450-41325 Life Insurance 95 81 85.26%
602-495-9450-41330 STD/LTD 727 411 56.53%
602-495-9450-41600 Safety Clothing Allowance 140 0.00%
602-495-9450-41301 Unemployment Insurance
602-495-9450-41510 Workers Compensation 4,000 1,978 49.45%
Total Personnel 196,534 136,070$ 69.23%
Materials and Supplies
602-495-9450-42210 Repair/Maint. Supplies 10,000 9,522 95.22%
602-495-9450-42000 Office Supplies 400 490 122.50%
602-495-9450-42030 Printed Forms 650 300 46.15%
602-495-9450-42120 Fuel, Oil and Fluids 8,000 7,875 98.44%
602-495-9450-42150 Operating Suppies 1,250 322 25.76%
602-495-9450-42270 Repair/Maint. Supplies 396
602-495-9450-44375 Personal Protective Equipment 450 160 35.56%
602-495-9450-42400 Small Tools & Minor Equipment 2,500 527 21.08%
Total Materials and Supplies 23,250 19,592$ 84.27%
Charges and Services
602-495-9450-43030 Engineering Services 12,500 536 4.29%
602-495-9450-43010 Audit Services 8,706 8,244 94.69%
602-495-9450-43090 Newsletter 1,300 709 54.54%
602-495-9450-43150 Contract Services 50,000 25,277 50.55%
602-495-9450-43185 IT Support 4,558 3,463 75.98%
602-495-9450-42002 IT Hardware 1,350 0.00%
602-495-9450-43190 Software Programs 12,670 4,619 36.46%
602-495-9450-43210 Telephone 3,100 1,345 43.39%
602-495-9450-43220 Postage 3,392 1,373 40.48%
602-495-9450-43310 Mileage 100 0.00%
602-495-9450-43610 Insurance 6,000 4,477 74.62%paid in full for year
602-495-9450-43810 Electric Utility 16,500 15,751 95.46%
602-495-9450-43820 Sewer Utility - Met Council 421,861 351,974 83.43%
602-495-9450-44010 Repairs/Maint Imp Bldgs 1,000 591 59.10%
602-495-9450-44040 Repairs/Maint. Equip.4,500 3,349 74.42%
602-495-9450-44150 Equipment Rental 8,000 9,063 113.29%
602-495-9450-44170 Uniforms 600 309 51.50%
602-495-9450-44030 Repairs\Maint Imp Not Bldgs 4,500 14,785 328.56%lift station lightning strike
602-495-9450-44370 Conferences & Training 2,700 2,632 97.48%
602-495-9450-44377 Credit Card Fees 9,809 8,046 82.03%
Total Charges and Services 573,146 456,543$ 79.66%
Capital Outlay
602-495-9450-45300 Improvements Other Than Bldgs 22,438 3,208 14.30%
Total Capital Outlay 22,438 3,208$ 14.30%
Miscellaneous and Non-operating
602-495-9450-44300 Miscellaneous Expenses 500 0.00%
602-495-9450-46010 Bond Principal 475,000 315,000 66.32%
602-495-9450-46110 Bond Interest 161,519 121,009 74.92%
Total Misc. and Non-operating 637,019 436,009$ 68.45%
Total Sewer Fund Expenses:1,452,387 1,051,422$ 72.39%
Total Sewer Fund Revs. Over/(Under) Expenses:231,460 (219,586)$ -94.87%
603 Storm Water Fund
Storm Water Fund Revenues:
603-000-0000-36210 Interest on Investment 4,463 0.00%booked at end of year
603-000-0000-37300 Surface Water Utility Sales 464,080 145,867 31.43%began quarterly billing in Q1 for other utility customers
603-000-0000-34113 SW Review Fee Revenue 39,375 27,163 68.99%
Total Storm Water Fund Revenues:507,918 173,030$ 34.07%
Storm Water Fund Expenses:
Personnel
603-496-9500-41010 Full-time Salaries 81,316 48,857 60.08%
603-496-9500-41020 Overtime 1,000 0.00%
603-496-9500-41210 PERA Contributions 6,174 3,654 59.18%
603-496-9500-41216 MSRS Contributions -City Admin 158 113 71.52%
603-496-9500-41220 FICA Contributions 5,104 2,886 56.54%
603-496-9500-41230 Medicare Contributions 1,194 675 56.53%
603-496-9500-41300 Insurance 18,616 10,365 55.68%
603-496-9500-41325 Life Insurance 55 41 74.55%
603-496-9500-41330 STD/LTD 477 189 39.62%
603-496-9500-41600 Safety Clothing Allowance 125 0.00%
603-496-9500-41301 Unemployment Insurance
603-496-9500-41510 Workers' Compensation 2,455 772 31.45%
Total Personnel 116,674 67,552$ 57.90%
Materials and Supplies
603-496-9500-42000 Office Supplies 350 0.00%
603-496-9500-42120 Fuel, Oil and Fluids 3,750 1,861 49.63%
603-496-9500-42030 Printed Forms 500 300 60.00%
603-496-9500-42270 Repair/Maint. Maint Supplies 2,500 434 17.36%
603-496-9500-42150 Operating Supplies 750 9 1.20%
603-496-9500-44375 Personal Protective Equipment 500 0.00%
603-496-9500-42400 Small Tools & Minor Equipment 2,500 2,357 94.28%
Total Materials and Supplies 10,850 4,961$ 45.72%
Charges and Services
603-496-9500-43030 Engineering Services 12,000 3,887 32.39%
603-496-9500-43010 Audit Services 8,706 8,244 94.69%
603-496-9500-43040 Legal Services
603-496-9500-43150 Contract Services 6,700 3,478 51.91%
603-496-9500-43185 IT Support 2,163 2,116 97.83%
603-496-9500-42002 IT Hardware 600 0.00%
603-496-9500-43190 Software Programs 11,955 4,275 35.76%
603-496-9500-43210 Telephone 1,100 431 39.18%
603-496-9500-44377 Credit Card Fees 500 1,465 293.00%increased due to quarterly billing
603-496-9500-43220 Postage 1,750 1,675 95.71%
will likely exceed budget due to switch to quarterly billing for some
accounts
603-496-9500-43510 Legal Publishing 75 0.00%
603-496-9500-43610 Insurance 8,005 7,029 87.81%paid in full for year
603-496-9500-44010 Street Sweeping 25,000 21,609 86.44%extra sweeping due to last year's seal coat project
603-496-9500-44040 Repairs/Maint Equip 2,500 1,949 77.96%
603-496-9500-44015 Repairs/Maint Bldg 100 0.00%
603-496-9500-44030 Repairs/Maint Not Bldg 25,000 0.00%
603-496-9500-44150 Equipment Rental 1,000 1,813 181.30%
603-496-9500-44170 Uniforms 250 125 50.00%
603-496-9500-44330 Dues & Subscriptions 780
603-496-9500-44370 Conferences & Training 1,425 0.00%
Total Charges and Services 108,829 58,876$ 54.10%
Capital Outlay
603-496-9500-45300 Improvements Other Than Bldgs
Total Capital Outlay
Miscellaneous and Non-operating
603-496-9500-44300 Miscellaneous Expenses 5,000 538 10.76%
603-496-9500-46010 Bond Principal 205,000 20,500 10.00%
603-496-9500-46110 Bond Interest 52,713 52,714 100.00%
Total Misc. and Non-operating 262,713 73,752$ 28.07%
Prior Period Adjustment
Total Storm Water Fund Expenses:499,066 205,141$ 41.10%
Total Storm Water Fund Revs. Over/(Under) Expenses:8,852 (32,111)$ -362.75%
Category Total Concentration Face / Cost
Yield to
Maturity
Annualized
Cost Yield
Amount
Market Value
Money Market 55% 28,068,058$ 0.34% 96,568$ 28,068,058$
Brokered CD 8% 4,129,646$ 1.24% 51,246$ 3,900,261$
Non-Brokered CD 12% 6,001,613$ 0.97% 58,010$ 6,001,613$
Government Securities 17% 8,515,000$ 0.71% 60,881$ 7,684,685$
Municipal Securities 6% 3,159,873$ 2.44% 77,247$ 2,907,594$
Checking 3% 1,561,612$ 0.00% -$ 1,561,612$
100%51,435,802$ 0.67%343,953$ 50,123,823$
Category Total Concentration Face / Cost
Yield to
Maturity
Annualized
Cost Yield
Amount
Market Value
Money Market 45% 21,730,348$ 0.33% 72,572$ 21,730,348$
Brokered CD 9% 4,329,646$ 1.28% 55,466$ 4,154,730$
Non-Brokered CD 13% 6,000,792$ 0.97% 58,005$ 6,000,792$
Government Securities 17% 8,515,000$ 0.71% 60,881$ 7,996,553$
Municipal Securities 6% 3,159,873$ 2.44% 77,247$ 3,019,254$
Checking 11% 5,039,496$ 0.00% -$ 5,039,496$
100%48,775,155$ 0.66%324,172$ 47,941,174$
Category Total Concentration Face / Cost
Yield to
Maturity
Annualized
Cost Yield
Amount
Market Value
Money Market 53% 25,315,745$ 0.43% 109,582$ 25,315,745$
Brokered CD 9% 4,138,000$ 1.26% 52,017$ 4,028,722$
Non-Brokered CD 13% 6,000,000$ 0.63% 37,500$ 6,000,000$
Government Securities 18% 8,515,000$ 0.71% 60,881$ 8,101,677$
Municipal Securities 7% 3,159,873$ 2.44% 77,247$ 3,097,629$
Checking 2% 801,573$ 0.00% -$ 801,573$
100%47,930,191$ 0.70%337,227$ 47,345,346$
Change
Face/Cost 2,660,647$
5.45%
Yield to Maturity 0.00%
Concentration 22.58%
As of September 30, 2022
Overall the rates in Q3 2022 remained comparable with Q2 2022 rates
as there was minimal change in the investment securities held. Going
forward the greatest impact will be when investments mature and
higher yields are realized through new investments. Since the market
has improved, calls are not anticipated on the lower yielding securities
held and it is anticipated that returns will improve as new investments
are purchased at higher yields.
As of June 30, 2022
As of March 31, 2022
Money market increased 22.58% from the previous quarter or $6.3
million. This is the result of the aforementioned 2022A bond proceeds
recived in August; these funds are kept in a Money Market account since
they are expected to be spent within the next 12-18 months.
The total Cash & Investments increased 5.45% or $2,660,647 due to
2022A bond proceeds of $12,495,000 received in August. This was offset
by the August 1st interest payment on existing debt as well as large
payments made for 2022 CIP projects.
Money Market
$28,068,058
56%
Brokered CD
$3,900,261
8%
Non-Brokered CD
$6,001,613
12%
Government Securities
$7,684,685
15%
Municipal Securities
$2,907,594
6%
Checking
$1,561,612
3%
Market Value as of 09/30/2022
Money Market Brokered CD Non-Brokered CD Government Securities Municipal Securities Checking
20,222 16,901 25,193 24,838 36,944 45,259 30,700 56,222 71,163
327,441
-
50,000
100,000
150,000
200,000
250,000
300,000
350,000
January February March April May June July August September October November December Total
2022 Interest Earnings from Investments
STAFF REPORT
3rd QUARTER DASHBOARD
DATE: October 17, 2022
SUBMITTED BY: John Taylor, Building Official
Below is a snapshot of the total statistics for the Third Quarter of 2022. Comparison data is also included
from prior years 3rd Quarters for new single family home attached/detached, Commercial and other
miscellaneous YTD totals.
2022 2021 2020
New Commercial 3 0 1
New Commercial Valuation $3,285,000 0 $6,402,899
New Single Family Homes (AT/DT) 28 65 77
Total Residential YTD 193 250 248
Total New SFH Valuation $11,617,916 $24,115,231 $22,610,119
Average Home Value 3rd Quarter $414,926 $371,004 $297,502
Multi Family Bldgs 0 0 0
MF Valuation 0 0 0
Total Permits Pulled To Date 1,984 1,177 891
Total Permit Valuation YTD $116,946,006 $93,816,159 $86,025,023
Total Inspections 3rd Quarter 2823 2881 2,279
As-Built/Escrow Review/Release 154 No Data No Data
Avg SFD Permit Review Time (No/Days) 21/7D No Data No Data
Avg Com Permit Review Time (No/Days) 21/10D No Data No Data
The Building Permit Plan Review Dashboard tracks the submittal dates and the Permit release date. We
do have some that extend beyond these dates but have either Planning/Survey issues, need a variance or
missing paperwork and is so noted on the Dashboard. No data on previous years.
All other information is from reports generated by Permit Works.
The SFD Attached/Detached slowed down this quarter. Supply and economic concerns probably fueled
the most in the slow down. Two plats were approved to start some building permits at the end of
September. Have received 30 permits since the release and about 21 have been reviewed and ready to
release. Have a few that are on hold for not matching the approved grading for setbacks on the plats. The
average cost of a home has gone up probably because of rising material/labor cost.
We also had another 11 permits for Commercial Alterations/Tenant Improvements for $1,978,392 in
valuations.
The weather event causing hail damage has resulted in over 800 permits for roof or siding replacement. We
have been working together to get the inspections done in between scheduled inspections or when time
allows during the day.
(AT/DT) Attached & Detached Homes (No/Days) Permits submitted/Days to Review
Fire Response Activity:Jan Feb Mar Apr May June July Aug Sept Oct Nov
Fire 1 6 1 3 3 5 1 2 3
Explosion/Overheat 1 0 0 0 0 0 0 0 0
MV Crash / Rescue 11 5 5 2 4 4 49 38 44
Medical Emergency 40 25 31 37 47 36 4 9 8
Hazardous Condition (No Fire) 1 2 3 4 2 2 3 4 1
Service Call 1 1 2 0 3 0 1 0 6
Good Intent Call 2 6 9 5 6 7 10 3 10
False Alarm & False Call 6 2 10 6 7 2 8 3 3
Weather / Disaster 0 0 0 0 0 0 0 0 0
Total Fire Responses:63 47 61 57 72 56 76 59 75
Average Per 1,000 Residents 4.98 3.71 4.82 4.50 5.69 4.43 6.01 4.66 5.93
Average Enroute Time (min:sec)
Average Arrival Time (min:sec)
Fire Inspection Activity:Jan Feb Mar Apr May June July Aug Sept Oct Nov
Inspections/Preplans 47 35 26 4 9 3 21 9 8
System Rough-In and Final 6 14 3 6 8 13 19 1 8
Key Box Updates/Installs 9 6 1 5 1 0 9 1 1
Request for Data 0 1 0 1 0 1 0 1 2
Consultations 4 6 3 1 2 1 6 3 1
Hazardous Materials Plan 1 1 3 0 0 0 0 0 0
Plan and Permit Review 5 4 1 5 11 14 16 17 9
Investigation/Follow Up 2 2 1 5 2 2 3 5 2
Total Fire Inspections:74 69 38 27 33 34 74 37 31
Year-to-date Incident Total
9/30/21: 404
10:12 7:08 7:49
Summary of Lake Elmo Fire Department Activity - 202
4:12 2:35 2:29
Dec Total
25
1
162
237
22
14
58
47
0
566
44.73
Dec Total
162
78
33
6
27
5
82
24
417
2
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total
Complaint Received 24 50 27 101
Violation Case Opened 29 20 15 64
Violation Case Closed 12 15 19 46
Zoning Inquiries 144 261 258 663
Inspections (Zoning & Code Enf.)68 190 108 366
Fence 20 19 16 55
Deck 21 43 31 95
Driveway 6 16 12 34
Sign 3 0 6 9
Encroachment Agrements 15 16 10 41
Comprehensive Plan Amend 1 1 1 3
Future Land Use Map Amend 1 1 1 3
Conditional Use Permit (CUP)/ Interim Use
Permit (IUP)0 4 2 6
Subdivision/Plat 4 5 1 10
Development Agreement 3 1 2 6
Planned Unit Development (PUD)4 5 1 10
Variance 4 4 3 11
Zoning Map Amendment 1 4 2 7
Zoning Text Amendment 1 7 3 11
Summary of 2022 Planning Department Activity
Code Enforce mentZoning Adminis trationZoning PermitsLand Use Applications & Long Range Planning
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total
# Gallons of Water
Pumped 45,455,000 134,461,763 180,650,000 360,566,763
# of Locates 772 1,972 2,305 5,049
# of water leaks/breaks 1 4 3 8# of water meters
installed/replaced 83 117 97 297
# of hours spent on the
sanitary sewer
maintence 345.78 141.00 296.00 782.78
Tons of asphalt mix
used for potholes 4.50 86.00 34.50 125.00
Avg time it takes to
clear snow from the
streets?6.50 no snow no snow 6.50
# of winter events
attended to 17 0 0 17
# of Parks Inspected 17 17 17 51
# of Park Issues found 24 32 20 76
# of Park reservations 1 8 12 21
# of hours spent on ball
fields , trails and ice
rinks 138.0 216.0 696.0 1,050.0
# of man hrs of tree
removal/trimming 372.0 232.0 264.0 868.0
# of Gallons of fuel used 5,037.4 4,205.6 4,518.7 13,761.7
Notes: PW staff started mowing all city property August 1st after contractor prematurelly ended the contract. Park issues found include:
Bolts, removed the unsafe klies swing, net repiar, theft and vandalism, junk/mattress dumping, tree trimming needs, regraded park
lawns to improve drainage at Demontriville and Pilot parks, added more drain tile at Pilot Park, painted the parks building on upper 33rd,
Stained all wood structiures in parks (fences, bridges, stairs, etc.) Seal Coated Asphalt Trails
Water System-Replaced a failed check valve in the booster station, replaced the failed the well 2 flow meter, the Ideal water tower was
upgraded with an intrusion alarm, after this quarter we have exceeded our well appropriatioins permit of 260 million per yr.
Streets-chip seal roads were swept several times and will be swept again before winter
Summary of 2022 Public Works Activity
gallons pumped comes from well logs each month
number of locates are tracked by mike coleman
between jim and I we track water main breaks/leaks
number of hours spent on sewer comes from timecards, micheal kuehn
tons of ashaplt is tracked by joe effinger
avg time to clear snow from streets is tracked in snow event log book on Ricks desk
Number of snow events are track in snow event log book on ricks desk
number of parks inspected and issues found are tracked by park inspector monroe
number of park reservactions are tracked by rebecca on s drive, public works, park reservation, spreads
hours spent on ball field, trails and ice rinks are tracked by belde (ball fields and ice rinks) joe effinger fi
jamie tracks number of man hrs tree trimming
jamie tracks gallons of fuel used
sheet
ills out a grooming log book, I track trail maintence
LAKE ELMO STATISTICS - Quarterly
Calls Per Hour Total Incidents
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr 1st Qtr
0000 98 122 128 2021 961
0100 65 92 103 2022 879
0200 62 72 93
0300 49 46 52
0400 23 15 24
0500 29 26 21
0600 31 28 42
0700 58 54 65
0800 82 85 79
0900 83 96 89
1000 86 98 91
1100 76 82 78
1200 71 77 97
1300 96 93 109
1400 74 104 95
1500 129 124 134
1600 99 131 130
1700 107 122 143
1800 110 113 154
1900 63 82 113
2000 82 97 120
2100 97 120 162
2200 62 75 106
2300 71 108 122
LAKE ELMO CRIME STATISTICS - Quarterly
Crime Incidents
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
Theft 21 18 22 0
Theft from Business 4 2 6
Theft from Person 6 8 7
Theft from MV 3 3 5
Theft of MV Parts 3 3 3
Mail Theft 2 1 0
Identity Theft 3 1 1
MV Theft 5 2 3
Drugs 17 11 9
Fraud 13 8 17
Criminal Damage To Property 7 7 10
Burglary 0 3 2
Domestic Assault 3 8 2
Court Order Violation 1 2 5
Aggravated Assault 2 0 2
Simple Assault 1 2 0
Robbery 1 0 0
Rape 0 0 1
Homicide 0 0 0
Quality of Life
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
Medical 109 93 132
Citizen Assist 76 122 125
Mental Health/Crisis Calls 7 16 43
Alarm 82 70 105
Suspicious Activity 65 63 62
Animal 30 41 35
Disturbance/Noise 7 42 45
Overdoses 1 5 2
Harassment 7 15 7
Threats 4 6 5
Disorderly 0 3 1
Trespassing 1 3 9
Traffic Incidents
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
DWI 6 6 5
Traffic Stops Made 281 421 581
Citations Issued 62 85 124
Warning Citations Issued 1 6 9
Traffic - Moving Violation 30 69 86
Traffic - Non Moving Violation 29 26 60
Parking 15 17 31
MV Accident 70 67 45 0
Fatal 0 0 1
Property Damage 57 52 34
Personal Injury 4 3 3
Animal Related 9 12 7
2nd Qtr 3rd Qtr 4th Qtr
1225 1283 1097
985 1131