Loading...
HomeMy WebLinkAbout#09 - Second Quarter Financials STAFF REPORT DATE: July 20, 2021 TO: City Council FROM: Sam Magureanu, Finance Director AGENDA ITEM: 2nd Quarter Financial Reports BACKGROUND: The finance director has prepared the 2nd Quarter Financial Reports on July 20th. The finance director is recommending acceptance of the 2nd Quarter Financial Reports. ISSUE BEFORE THE COUNCIL: 1) Does the City Council have any questions regarding the 2nd Quarter Financial Reports? DISCUSSION: The Budget vs. Actual for 2nd quarter 2021 is attached with explanations alongside line items to explain variances from the budget. This format aligns with the budget worksheets used during the 2021 budget cycle. Please note that revenue figures are low on property taxes and utilities do to timing of when the revenue is received and bills are processed. Taxes are only received in July for those collected in May, December for those collected in October, and a clean-up payment for any delinquent taxes collected by the end of December in January of the next year. Water and sewer utilities are billed quarterly. Revenues are recognized when billed rather than received. Storm Water is billed annually in January for the previous year. Expenditures reflect a combination of ongoing expenses and items that are one-time payments per year. Also includes is a summary of the investment portfolio through June 30, 2021. FISCAL IMPACT: N/A RECOMMENDATION: “Motion to accept the 2nd Quarter Financial Reports.” ATTACHMENTS: 1) 2nd Quarter Budget-to-Actual Reports 2) 2nd Quarter Investment Portfolio Summary CITY OF LAKE ELMO2021 YTD ActualsMaster Worksheet 7/20/20212:40 PM2021 Actual YTD % ofAccount NumberDescriptionAdopted6/30/2021BudgetCommentsAccount NumberDescriptionGeneral Fund Revenues:Taxes101‐410‐1320‐31010 Current Ad Valorem Taxes 3,522,782.00                       ‐                                0.00%101‐410‐1320‐31020 Delinquent Ad Valorem Taxes 15,000.00                              ‐                                0.00%101‐410‐1320‐31030 Mobile Home Tax 15,000.00                              ‐                                0.00%101‐410‐1320‐31040 Fiscal Disparities 271,597.00                            ‐                                0.00%101‐410‐1320‐31045 Delinquent Fiscal Disparities‐                                         ‐                                #DIV/0!101‐410‐1320‐31050 Tax Abatement‐                                         ‐                                #DIV/0!101‐410‐1320‐31520 30% Rental ‐ County‐                                         ‐                                #DIV/0!101‐410‐1320‐31910 Penalty & Interest on Taxes 500.00                                   ‐                                0.00%101‐410‐1320‐31920 Forfeited Tax Sale Apportionment‐                                         ‐                                #DIV/0!Total Taxes3,824,879.00                       ‐                                0.00%No revenues from taxes collected in Q1 and Q2. First Settlement will be in Q3. Collected July 2ndLicenses and Permits101‐410‐1320‐32110 Liquor License 8,300.00                                ‐                                0.00%Receipt in Q4101‐410‐1320‐32180 Wastehauler License 720.00                                   ‐                                0.00%101‐410‐1320‐32181 General Contractor License 150.00                                  300.00                          200.00%101‐420‐2400‐32210 Building Permits 800,000.00                           664,422.03                  83.05%101‐430‐3100‐32211 Driveway Permits 12,000.00                             10,000.00                    83.33%101‐420‐2400‐32212 Fireplace Permits 16,000.00                             10,860.00                    67.88%101‐420‐2400‐32220 Heating Permits 60,000.00                             73,789.70                    122.98%Continental ‐ permits101‐420‐2400‐32230 Plumbing Permits 75,000.00                             93,302.50                    124.40%Continental ‐ permits101‐420‐2400‐32232 Pool Permits 1,000.00                               1,200.00                      120.00%More than anticipated101‐420‐2400‐32213 Siding Permits 5,000.00                               3,823.95                      76.48%101‐420‐2400‐32214 Roof Permits 10,000.00                             13,032.05                    130.32%More than anticipated101‐430‐3100‐32250 Utility Permits 21,600.00                             23,398.20                    108.33%More than anticipated101‐420‐2220‐32260 Burning Permit 1,500.00                               1,275.00                      85.00%101‐410‐1320‐32120 Massage Therapy Licenses 100.00                                  100.00                          100.00%101‐420‐2400‐32275 Fire Suppression Permits 2,000.00                               12,323.05                    616.15%Continental ‐ permits101‐420‐2400‐32278 Fire Permit Plan Check Fee‐                                        5,460.00                      #DIV/0!Continental ‐ permits101‐410‐1320‐32281 Golf Cart Operation Permit 30.00                                    30.00                            100.00%101‐410‐1320‐32282 Miscellaneous Permits 100.00                                  88.00                            88.00%Total Licenses and Permits1,013,500.00                      913,404.48                 90.12%Intergovernmental101‐430‐3100‐33418 MSA ‐ Maintenance 151,755.00                           81,888.00                    53.96%Two payments a year101‐420‐2220‐33420 State Fire Aid 64,000.00                              ‐                                0.00%Pass through in Nov101‐430‐3100‐33630 Miscellaneous State Grants 1,500.00                                ‐                                0.00%101‐450‐5200‐33426 Miscellaneous State Grants 4,820.00                               2,675.60                      55.51%101‐410‐1320‐33623 Payment in Lieu of Taxes 34,097.00                              ‐                                0.00%Receipt in Q4Total Intergovernmental256,172.00                          84,563.60                    33.01%Charges for Services101‐410‐1910‐34103 Zoning & Subdivision Fees 40,000.00                             24,325.00                    60.81%Legacy at North Start 4th ‐ AUAR fees in Q2 $14,260101‐420‐2400‐34104 Plan Check Fees 520,000.00                           443,795.77                  85.35%Continental101‐410‐1320‐34105 Sale of Copies, Books, Maps 50.00                                     ‐                                0.00%101‐410‐1520‐34107 Assessment Searches 2,000.00                               1,880.00                      94.00%101‐410‐1450‐34111 Cable Operation Reimbursement 5,000.00                                ‐                                0.00%101‐420‐2400‐34112 Planning & Zoning Review Fee 20,000.00                             20,634.00                    103.17%More than anticipated101‐430‐3100‐34114 Street Light Fee 1,000.00                               1,548.00                      154.80%101‐410‐1910‐34115 Base Map Upgrading Fee 3,000.00                               5,875.00                      195.83%101‐410‐1910‐36206 Escrow Administration Fee 20,000.00                             20,286.81                    101.43%More than anticipated activityTotal Charges for Services611,050.00                          518,344.58                 84.83%Fines and Forfeits1 CITY OF LAKE ELMO2021 YTD ActualsMaster Worksheet 7/20/20212:40 PM2021 Actual YTD % ofAccount NumberDescriptionAdopted6/30/2021BudgetComments101‐410‐2100‐35100 Fines 35,000.00                             19,569.21                    55.91%Total Fines and Forfeits35,000.00                             19,569.21                    55.91%Within expectationInvestment Earnings101‐410‐1320‐36210 Interest Earnings 77,000.00                             0.00%Interest is allocated at EOY in Q4Total Investment Earnings77,000.00                              ‐                                0.00%Miscellaneous101‐410‐1320‐31811 Cable Franchise Revenue 85,000.00                             81,019.18                    95.32%Colected in June. Cable Franchise Ramsey/Washington Cty Cable Commission.101‐410‐1320‐36200 Miscellaneous Revenue 3,000.00                               153.82                          5.13%101‐430‐3100‐36200 Miscellaneous Revenue 500.00                                  2,083.20                      416.64%Disposal of PW items101‐410‐1910‐36200 Miscellaneous Revenue 15,000.00                             14,285.00                    95.23%101‐410‐1910‐36236 Conservation Easement Fee 20,000.00                              ‐                                0.00%Not yet collected in 2021. Last collected in 2018101‐410‐1320‐36230 Donations 10,000.00                             9,000.00                      90.00%Jaycees101‐410‐1320‐34120 Tower Rent 112,517.00                           47,000.49                    41.77%Within expectation. Sprint to be collected in Q3Total Miscellaneous246,017.00                          153,541.69                 62.41%Prior Period AdjustmentsTotal General Fund Revenues:6,063,618.00                   1,689,423.56           27.86%General Fund Expenditures:1110Mayor & CouncilPersonnel101‐410‐1110‐41030 Part‐time Salaries 25,690.00                             12,845.00                    50.00%101‐410‐1110‐41220 FICA Contributions 1,593.00                               796.39                          49.99%101‐410‐1110‐41230 Medicare Contributions 373.00                                  186.27                          49.94%101‐410‐1110‐41510 Workers Compensation 130.00                                  117.71                          90.55%Paid in Q2Total Personnel27,786.00                             13,945.37                    50.19%Mayor and Council June/Dec PaymentsMaterials and Supplies101‐410‐1110‐42000 Office Supplies 125.00                                   ‐                                0.00%101‐410‐1110‐42001 Computer Reimbursement 3,000.00                               2,858.99                      95.30%101‐410‐1110‐43310 Mileage 300.00                                   ‐                                0.00%101‐410‐1110‐43185 IT Support 1,332.00                               501.20                          37.63%Total Materials and Supplies4,757.00                               3,360.19                      70.64%Charges and Services101‐410‐1110‐44300 Miscellaneous 7,250.00                               1,785.00                      24.62%PY there was an expense from Youth Service Bureau for $5,250101‐410‐1110‐44330 Dues & Subscriptions 16,500.00                             4,229.00                      25.63%101‐410‐1110‐44370 Conferences & Training 1,000.00                               175.00                          17.50%Total Charges and Services24,750.00                             6,189.00                      25.01%1110Total Mayor & Council 57,293.00                             23,494.56                    41.01%1320AdministrationPersonnel101‐410‐1320‐41010 Full‐time Salaries 169,407.00                           76,987.01                    45.44%101‐410‐1320‐41040 Temporary Employees‐                                        1,532.40                      #DIV/0!This is offset by the MCMA Grant101‐410‐1320‐41210 PERA Contributions 12,706.00                             6,016.84                      47.35%101‐410‐1320‐41216 MSRS Contributions ‐City Admin 1,649.00                               515.47                          31.26%101‐410‐1320‐41220 FICA Contributions 10,503.00                             4,838.52                      46.07%101‐410‐1320‐41230 Medicare Contributions 2,456.00                               1,131.59                      46.07%101‐410‐1320‐41300 Insurance 31,837.00                             11,636.11                    36.55%101‐410‐1320‐41325 Life Insurance 127.00                                  53.44                            42.08%101‐410‐1320‐41330 STD/LTD 905.00                                  396.81                          43.85%101‐410‐1320‐41510 Workers Compensation 2,103.00                               1,619.14                      76.99%Paid in Q2Total Personnel231,693.00                          104,727.33                 45.20%Within ExpectationMaterials and Supplies2 CITY OF LAKE ELMO2021 YTD ActualsMaster Worksheet 7/20/20212:40 PM2021 Actual YTD % ofAccount NumberDescriptionAdopted6/30/2021BudgetComments101‐410‐1320‐42000 Office Supplies 3,200.00                               321.62                          10.05%101‐410‐1320‐42030 Printed Forms 100.00                                   ‐                                0.00%Total Materials and Supplies3,300.00                               321.62                          9.75%Charges and Services101‐410‐1320‐43100 Assessing Services 97,625.00                             100,474.88                  102.92%Billed in Q2101‐410‐1320‐43040 Legal Services 87,500.00                             26,598.94                    30.40%101‐410‐1320‐43150 Contract Services 3,000.00                               286.34                          9.54%101‐410‐1320‐43180 Information Technology/Web 7,350.00                                ‐                                0.00%101‐410‐1320‐43185 IT Support‐                                        3,041.65                      #DIV/0!Budgeted in -43190101‐410‐1320‐42002 IT Hardware 600.00                                   ‐                                0.00%101‐410‐1320‐43190 Software Programs 2,540.00                                ‐                                0.00%LF,ADOBE, PLANIT101‐410‐1320‐43210 Telephone 2,664.00                               586.06                          22.00%101‐410‐1320‐43220 Postage 2,500.00                               1,799.40                      71.98%101‐410‐1320‐43310 Mileage 1,100.00                                ‐                                0.00%101‐410‐1320‐43510 Legal Publishing 2,000.00                               1,255.27                      62.76%101‐410‐1320‐43610 Insurance 45,067.00                             41,176.74                    91.37%Billed in Q2101‐410‐1320‐44330 Dues & Subscriptions 2,200.00                               1,412.87                      64.22%101‐410‐1320‐44370 Conferences & Training 5,000.00                               30.00                            0.60%101‐410‐1320‐44371 Allocation to Building Inspections (2,810.00)                               ‐                                0.00%Total Charges and Services256,336.00                          176,662.15                 68.92%Miscellaneous101‐410‐1320‐44300 Miscellaneous 1,500.00                               272.88                          18.19%Total Miscellaneous1,500.00                               272.88                          18.19%1320Total Administration 492,829.00                          281,983.98                 57.22%1410ElectionsPersonnel101‐410‐1410‐41030 Part‐time Salaries‐                                         ‐                                #DIV/0!101‐410‐1410‐41510 Workers Compensation‐                                         ‐                                #DIV/0!Total Personnel‐                                         ‐                                #DIV/0!Charges and Services101‐410‐1410‐43150 Contract Services 3,150.00                               3,100.00                      98.41%Total Charges and Services3,150.00                               3,100.00                      98.41%Capital Outlay101‐410‐1410‐45800 Other Equipment‐                                         ‐                                #DIV/0!101‐480‐8000‐45800 Other Equipment‐                                         ‐                                #DIV/0!Total Capital Outlay‐                                         ‐                                #DIV/0!Miscellaneous101‐410‐1410‐44300 Miscellaneous‐                                         ‐                                #DIV/0!Total Miscellaneous‐                                         ‐                                #DIV/0!1410Total Elections 3,150.00                               3,100.00                      98.41%1450CommunicationsPersonnel101‐410‐1450‐41010 Full‐time Salaries 27,128.00                             11,805.20                    43.52%101‐410‐1450‐41210 PERA Contributions 2,035.00                               884.92                          43.49%101‐410‐1450‐41220 FICA Contributions 1,682.00                               731.51                          43.49%101‐410‐1450‐41230 Medicare Contributions 393.00                                  171.13                          43.54%101‐410‐1450‐41300 Insurance 6,909.00                               1,357.00                      19.64%101‐410‐1450‐41325 Life Insurance 28.00                                    12.87                            45.96%101‐410‐1450‐41330 STD/LTD 145.00                                  67.53                            46.57%3 CITY OF LAKE ELMO2021 YTD ActualsMaster Worksheet 7/20/20212:40 PM2021 Actual YTD % ofAccount NumberDescriptionAdopted6/30/2021BudgetComments101‐410‐1450‐41510 Workers Compensation 307.00                                  259.28                          84.46%Paid in Q2Total Personnel38,627.00                             15,289.44                    39.58%Within expectationCharges and Services101‐410‐1450‐43090 Newsletter1,200.00                               614.95                          51.25%101‐410‐1450‐43180 Information Technology/Web 2,200.00                               250.00                          11.36%101‐410‐1450‐43185 IT Support 589.00                                  243.55                          41.35%101‐410‐1450‐43220 Postage 1,650.00                               821.97                          49.82%101‐410‐1450‐43152 Cable Operations 5,000.00                               550.00                          11.00%101‐410‐1450‐44370 Conferences and Training 500.00                                   ‐                                0.00%Total Charges and Services11,139.00                             2,480.47                      22.27%1450Total Communications49,766.00                             17,769.91                    35.71%1520FinancePersonnel101‐410‐1520‐41010 Full‐time Salaries 74,290.00                             28,450.98                    38.30%101‐410‐1520‐41040 Temporary Employees 7,102.00                               1,839.50                      25.90%101‐410‐1520‐41210 PERA Contributions 5,572.00                               2,132.53                      38.27%101‐410‐1520‐41220 FICA Contributions 5,046.00                               1,832.40                      36.31%101‐410‐1520‐41230 Medicare Contributions 1,180.00                               428.55                          36.32%101‐410‐1520‐41300 Insurance 13,589.00                             4,838.48                      35.61%101‐410‐1520‐41325 Life Insurance 54.00                                    4.64                               8.59%101‐410‐1520‐41330 STD/LTD 457.00                                  28.22                            6.18%101‐410‐1520‐41510 Workers Compensation 935.00                                  710.04                          75.94%Paid in Q2Total Personnel108,225.00                          40,265.34                    37.21%Within expectation. Not fully staffed. See Additional Contracted services over budget.Materials and Supplies101‐410‐1520‐42000 Office Supplies 800.00                                  207.65                          25.96%101‐410‐1520‐42030 Printed Forms 1,000.00                               152.96                          15.30%Total Materials and Supplies1,800.00                               360.61                          20.03%Charges and Services101‐410‐1520‐43010 Audit Services 8,227.00                               1,464.50                      17.80%101‐410‐1520‐43150 Contract Services 10,000.00                             14,959.00                    149.59%AEM financial Services for finance. Due to Staff changes and no Finance Director. Offset by reduced salary expenditures in finance. 101‐410‐1520‐43185 IT Support 4,157.00                               1,720.10                      41.38%101‐410‐1520‐42002 IT Hardware 1,500.00                                ‐                                0.00%101‐410‐1520‐43190 Software Programs 2,919.00                               330.00                          11.31%101‐410‐1520‐43210 Telephone 613.00                                   ‐                                0.00%101‐410‐1520‐43310 Mileage 500.00                                   ‐                                0.00%101‐410‐1520‐44330 Dues & Subscriptions 2,300.00                                ‐                                0.00%GFOA annual Review and Subscription paid in Q3101‐410‐1520‐44370 Conferences & Training 3,200.00                                ‐                                0.00%101‐410‐1520‐44371 Allocation to Building Inspections (2,324.00)                               ‐                                0.00%Total Charges and Services31,092.00                             18,473.60                    59.42%Miscellaneous101‐410‐1520‐44300 Miscellaneous 5,000.00                               314.80                          6.30%Total Miscellaneous5,000.00                               314.80                          6.30%1520Total Finance 146,117.00                          59,414.35                    40.66%1910Planning & ZoningPersonnel101‐410‐1910‐41010 Full‐time Salaries 163,494.00                           70,581.48                    43.17%101‐410‐1910‐41040 Temporary Employees 7,102.00                               2,411.50                      33.96%101‐410‐1910‐41210 PERA Contributions 12,262.00                             5,290.82                      43.15%101‐410‐1910‐41220 FICA Contributions 10,577.00                             4,481.76                      42.37%101‐410‐1910‐41230 Medicare Contributions 2,474.00                               1,048.25                      42.37%4 CITY OF LAKE ELMO2021 YTD ActualsMaster Worksheet 7/20/20212:40 PM2021 Actual YTD % ofAccount NumberDescriptionAdopted6/30/2021BudgetComments101‐410‐1910‐41300 Insurance 32,222.00                             10,373.83                    32.19%101‐410‐1910‐41325 Life Insurance 129.00                                  24.33                            18.86%101‐410‐1910‐41330 STD/LTD 935.00                                  388.90                          41.59%101‐410‐1910‐41510 Workers Compensation 1,739.00                               1,562.63                      89.86%Paid in Q2Total Personnel230,934.00                          96,163.50                    41.64%Within expectationMaterials and Supplies101‐410‐1910‐42000 Office  Supplies 150.00                                  158.16                          105.44%101‐410‐1910‐42030 Printed Forms‐                                         ‐                                Total Materials and Supplies150.00                                  158.16                          105.44%CDBG101‐410‐1910‐43010 Comm Facilities 400.00                                   ‐                                0.00%Total CDBG400.00                                   ‐                                Charges and Services101‐410‐1910‐43020 Comprehensive Planning‐                                         ‐                                101‐410‐1910‐43030 Engineering Services 12,000.00                             1,583.75                      13.20%101‐410‐1910‐43150 Contract Services 21,000.00                             710.98                          3.39%101‐410‐1910‐43185 IT Support 6,160.00                               2,505.85                      40.68%101‐410‐1910‐43190 Software Programs 1,514.00                                ‐                                0.00%101‐410‐1910‐43210 Telephone 600.00                                   ‐                                0.00%Expensed in ‐43185101‐410‐1910‐43220 Postage 150.00                                   ‐                                0.00%101‐410‐1910‐43310 Mileage 100.00                                   ‐                                0.00%101‐410‐1910‐43510 Legal Publishing 1,200.00                               371.30                          30.94%101‐410‐1910‐44330 Dues & Subscriptions 500.00                                   ‐                                0.00%101‐410‐1910‐44370 Conferences & Training 500.00                                   ‐                                0.00%Total Charges and Services43,724.00                             5,171.88                      11.83%Miscellaneous101‐410‐1910‐44300 Miscellaneous 200.00                                   ‐                                0.00%Total Miscellaneous200.00                                   ‐                                0.00%1910Total Planning & Zoning 275,408.00                          101,493.54                 36.85%1930Engineering ServicesCharges and Services101‐410‐1930‐43030 Engineering Services 40,000.00                             12,500.00                    31.25%101‐410‐1930‐43210 Telephone‐                                         ‐                                Total Charges and Services40,000.00                             12,500.00                    31.25%Capital Outlay101‐480‐8000‐45900 Construction Projects‐                                         ‐                                #DIV/0!Total Capital Outlay‐                                         ‐                                #DIV/0!1930Total Engineering Services 40,000.00                             12,500.00                    31.25%1940City HallMaterials and Supplies101‐410‐1940‐42110 Cleaning Supplies 100.00                                   ‐                                101‐410‐1940‐42230 Building Repair Supplies 800.00                                  71.98                            9.00%Total Materials and Supplies900.00                                  71.98                            8.00%Charges and Services101‐410‐1940‐43180 Information Technology/Web 440.00                                   ‐                                0.00%101‐410‐1940‐43185 IT Support 5,599.00                               2,317.15                      41.39%101‐410‐1940‐43210 Telephone 903.00                                   ‐                                0.00%Expensed in ‐43185101‐410‐1940‐43810 Utilities 4,555.00                               1,575.11                      34.58%101‐410‐1940‐43840 Refuse 1,648.00                               730.46                          44.32%5 CITY OF LAKE ELMO2021 YTD ActualsMaster Worksheet 7/20/20212:40 PM2021 Actual YTD % ofAccount NumberDescriptionAdopted6/30/2021BudgetComments101‐410‐1940‐44010 Repairs/Maint Contractual Bldg 6,600.00                               2,654.37                      40.22%101‐410‐1940‐44040 Repairs/Maint Contractual Eqpt 16,000.00                             6,398.16                      39.99%101‐410‐1940‐44371 Allocation to Building Inspections (15,482.00)                             ‐                                0.00%Total Charges and Services20,263.00                             13,675.25                    67.49%Miscellaneous101‐410‐1940‐44300 Miscellaneous 1,800.00                               443.45                          24.64%Total Miscellaneous1,800.00                               443.45                          24.64%1940Total City Hall 22,963.00                             14,190.68                    61.80%2100PoliceCharges and Services101‐420‐2100‐43150 Law Enforcement Contract 920,183.00                           634.22                          0.07%101‐420‐2100‐44300 Misc. ‐ Community Event 1,800.00                                ‐                                0.00%Total Charges and Services921,983.00                          634.22                          0.07%2100Total Police 921,983.00                          634.22                          0.07%2150ProsecutionCharges and Services101‐420‐2150‐43045 Attorney Criminal 51,000.00                             16,734.00                    32.81%Total Charges and Services51,000.00                             16,734.00                    32.81%2150Total Prosecution 51,000.00                             16,734.00                    32.81%2220FirePersonnel101‐420‐2220‐41010 Full‐time Salaries 169,562.00                           51,474.93                    30.36%inspector not hired until April101‐420‐2220‐41030 Part‐time Salaries 191,527.00                           46,795.68                    24.43%101‐420‐2220‐41035 Paid On Call Salaries 75,000.00                             45,742.05                    60.99%101‐420‐2220‐41210 PERA Contributions 42,012.00                             18,635.62                    44.36%101‐420‐2220‐41220 FICA Contributions 27,038.00                             2,283.99                      8.45%101‐420‐2220‐41230 Medicare Contributions 6,323.00                               2,051.57                      32.45%101‐420‐2220‐41300 Insurance 31,726.00                             9,442.81                      29.76%101‐420‐2220‐41325 Life Insurance 120.00                                  15.18                            12.65%101‐420‐2220‐41330 STD/LTD 1,108.00                               172.56                          15.57%101‐420‐2220‐41420 Unemployment Benefits 2,500.00                                ‐                                0.00%101‐420‐2220‐41510 Workers Compensation 52,023.00                             39,378.37                    75.69%Paid in Q2Total Personnel598,939.00                          215,992.76                 36.06%Within expectationMaterials and Supplies101‐420‐2220‐42000 Office Supplies 1,000.00                               418.01                          41.80%101‐420‐2220‐42080 EMS Supplies 2,400.00                               910.07                          37.92%101‐420‐2220‐42090 Fire Prevention 2,000.00                               69.64                            3.48%101‐420‐2220‐42120 Fuel, Oil and Fluids 14,000.00                             4,524.18                      32.32%101‐420‐2220‐42400 Small Tools & Equipment 24,679.00                             20,901.91                    84.70%Total Materials and Supplies44,079.00                             26,823.81                    60.85%Charges and Services101‐420‐2220‐43050 Physicals 8,300.00                               4,506.00                      54.29%101‐420‐2220‐43150 Contract Services 3,500.00                               2,550.00                      72.86%Valuation101‐420‐2220‐43185 IT Support 18,843.00                             8,253.15                      43.80%101‐420‐2220‐42002 IT Hardware 1,200.00                                ‐                                0.00%101‐420‐2220‐43210 Telephone 4,674.00                               1,697.92                      36.33%101‐420‐2220‐43220 Postage‐                                        10.10                            #DIV/0!101‐420‐2220‐43230 Radio 20,000.00                             4,055.68                      20.28%Paid Q1 in April101‐420‐2220‐43310 Mileage 500.00                                   ‐                                0.00%6 CITY OF LAKE ELMO2021 YTD ActualsMaster Worksheet 7/20/20212:40 PM2021 Actual YTD % ofAccount NumberDescriptionAdopted6/30/2021BudgetComments101‐420‐2220‐43630 Insurance 10,467.00                             9,562.97                      91.36%Not yet paid. Q2101‐420‐2220‐43810 Utility 15,450.00                             6,383.72                      41.32%101‐420‐2220‐43840 Refuse 1,030.00                               350.63                          34.04%101‐420‐2220‐44010 Repairs/Maint Bldg 9,000.00                               6,981.14                      77.57%101‐420‐2220‐44040 Repairs/Maint Eqpt 43,920.00                             10,612.76                    24.16%101‐420‐2220‐44170 Uniforms 10,000.00                             7,677.70                      76.78%101‐420‐2220‐44330 Dues & Subscriptions 6,330.00                               5,705.00                      90.13%101‐420‐2220‐44350 Books 1,000.00                               243.74                          24.37%101‐420‐2220‐44370 Conferences & Training 20,580.00                             3,878.00                      18.84%Total Charges and Services174,794.00                          72,468.51                    41.46%Capital Outlay101‐480‐8000‐45500 Vehicle‐                                         ‐                                #DIV/0!101‐480‐8000‐45800 Equipment‐                                         ‐                                #DIV/0!101‐900‐9000‐47200 Transfer to Vehicle Replacement Fund‐                                         ‐                                #DIV/0!Total Capital Outlay‐                                         ‐                                #DIV/0!Miscellaneous101‐420‐2220‐44300 Miscellaneous 2,000.00                               343.80                          17.19%Total Miscellaneous2,000.00                               343.80                          17.19%2220Total Fire 819,812.00                          315,628.88                 38.50%2220Fire ReliefCharges and Services101‐420‐2220‐44920 Fire State Aid 64,000.00                              ‐                                0.00%Pass through in NovTotal Charges and Services64,000.00                              ‐                                0.00%2250Total Fire Relief 64,000.00                              ‐                                0.00%2400Building InspectionPersonnel101‐420‐2400‐41010 Full‐time Salaries 400,707.00                           127,442.92                  31.80%no B.O. offset by increase in contracted services101‐420‐2400‐41210 PERA Contributions 30,053.00                             9,902.76                      32.95%101‐420‐2400‐41216 MSRS Employer Contribution 504.00                                  173.68                          34.46%101‐420‐2400‐41220 FICA Contributions 24,844.00                             7,268.00                      29.25%101‐420‐2400‐41230 Medicare Contributions 5,810.00                               1,757.75                      30.25%101‐420‐2400‐41300 Insurance 81,179.00                             23,113.71                    28.47%Not yet billed Expense in Q2101‐420‐2400‐41325 Life Insurance 331.00                                  74.46                            22.50%101‐420‐2400‐41330 STD/LTD 2,341.00                               473.03                          20.21%101‐420‐2400‐41510 Workers Compensation 4,815.00                               4,221.92                      87.68%Paid in Q2Total Personnel550,584.00                          174,428.23                 31.68%Materials and Supplies101‐420‐2400‐42000 Office Supplies 1,750.00                               0.84                               0.05%101‐420‐2400‐42030 Printed Forms 350.00                                   ‐                                0.00%101‐420‐2400‐42120 Fuel, Oil and Fluids 3,600.00                               1,641.85                      45.61%Total Materials and Supplies5,700.00                               1,642.69                      28.82%Charges and Services101‐420‐2400‐43030 Engineering 5,000.00                                ‐                                0.00%101‐420‐2400‐43150 Inspector Contract Services 319,300.00                           346,612.13                  108.55%MNSPECT services101‐420‐2400‐43180 Information Technology/Web‐                                        3,280.00                      #DIV/0!101‐420‐2400‐43185 IT Support 6,820.00                               2,573.65                      37.74%101‐420‐2400‐42002 IT Hardware 700.00                                  545.78                          77.97%101‐420‐2400‐43190 Software Programs 1,100.00                                ‐                                0.00%101‐420‐2400‐43210 Telephone 3,760.00                               1,170.71                      31.14%101‐420‐2400‐43630 Insurance 4,962.00                               3,404.01                      68.60%101‐420‐2400‐44040 Repairs/Maint Eqpt 1,500.00                                ‐                                0.00%7 CITY OF LAKE ELMO2021 YTD ActualsMaster Worksheet 7/20/20212:40 PM2021 Actual YTD % ofAccount NumberDescriptionAdopted6/30/2021BudgetComments101‐420‐2400‐44170 Uniforms 800.00                                  89.75                            11.22%101‐420‐2400‐44330 Dues & Subscriptions 500.00                                  65.00                            13.00%101‐420‐2400‐44350 Books 600.00                                  317.20                          52.87%101‐420‐2400‐44370 Conferences & Training 3,200.00                               850.00                          26.56%Total Charges and Services348,242.00                          358,908.23                 103.06%Capital Outlay101‐480‐2400‐45500 Vehicle‐                                         ‐                                #DIV/0!Total Capital Outlay‐                                         ‐                                #DIV/0!Miscellaneous101‐420‐2400‐44371 Allocations from Admin, Finance, City Hall 20,616.00                              ‐                                0.00%101‐420‐2400‐44300 Miscellaneous 1,000.00                               325.00                          32.50%Total Miscellaneous21,616.00                             325.00                          1.50%2400Total Building Inspection 926,142.00                          535,304.15                 57.80%2500Emergency CommunicationsCharges and Services101‐420‐2500‐43150 Contract Services 3,350.00                               1,254.00                      37.43%Total Charges and Services3,350.00                               1,254.00                      37.43%2500Total Emergency Communications3,350.00                               1,254.00                      37.43%2700Animal ControlCharges and Services101‐420‐2700‐43150 Contract Services 13,000.00                             4,400.15                      33.85%Total Charges and Services13,000.00                             4,400.15                      33.85%2700Total Animal Control 13,000.00                             4,400.15                      33.85%3100StreetsPersonnel101‐430‐3100‐41010 Full‐time Salaries 412,315.00                           142,147.28                  34.48%101‐430‐3100‐41020 Overtime 6,000.00                               4,020.50                      67.01%101‐430‐3100‐41040 Temporary Employees 12,500.00                             336.00                          2.69%101‐430‐3100‐41210 PERA Contributions 31,374.00                             10,957.16                    34.92%101‐430‐3100‐41220 FICA Contributions 26,711.00                             8,709.26                      32.61%101‐430‐3100‐41230 Medicare Contributions 6,247.00                               2,036.74                      32.60%101‐430‐3100‐41300 Insurance 92,920.00                             30,087.06                    32.38%101‐430‐3100‐41325 Life Insurance 427.00                                  128.15                          30.01%101‐430‐3100‐41330 STD/LTD 2,267.00                               783.44                          34.56%101‐430‐3100‐41600 Safety Clothing Allowance 600.00                                   ‐                                0.00%101‐430‐3100‐41510 Workers Compensation 41,208.00                             49,530.06                    120.20%Paid in Q2Total Personnel632,569.00                          248,735.65                 39.32%Materials and Supplies101‐430‐3100‐42000 Office Supplies 500.00                                  232.99                          46.60%101‐430‐3100‐42120 Fuel, Oil and Fluids 21,000.00                             9,703.34                      46.21%101‐430‐3100‐42150 Operating Supplies 9,500.00                               3,867.29                      40.71%101‐430‐3100‐42210 Repair/Maint. Supplies 10,000.00                             5,478.30                      54.78%101‐430‐3100‐42212 Repair/Maint. Supplies S&I 10,000.00                             6,301.35                      63.01%101‐430‐3100‐42240 Street Maintenance & Landscaping ‐ Materials 39,000.00                             8,943.98                      22.93%101‐430‐3100‐42260 Street Signs 4,000.00                               354.06                          8.85%101‐430‐3100‐42290 Sand/Salt S&I 85,000.00                             53,324.81                    62.74%101‐430‐3100‐42400 Small Tools & Minor Equipment 4,500.00                               2,465.87                      54.80%101‐430‐3100‐44375 Personal Protection Equipment 1,200.00                               58.85                            4.90%Total Materials and Supplies184,700.00                          90,730.84                    49.12%8 CITY OF LAKE ELMO2021 YTD ActualsMaster Worksheet 7/20/20212:40 PM2021 Actual YTD % ofAccount NumberDescriptionAdopted6/30/2021BudgetCommentsCharges and Services101‐430‐3100‐43030 Engineering Services 14,000.00                             2,209.50                      15.78%101‐430‐3100‐43090 Sealcoating & Crack Sealing 565,000.00                           275,228.06                  48.71%101‐430‐3100‐43150 Contract Services 24,000.00                             4,929.63                      20.54%101‐430‐3100‐43185 IT Support 12,976.00                             3,659.47                      28.20%101‐430‐3100‐42002 IT Hardware 750.00                                   ‐                                0.00%101‐430‐3100‐43190 Software Programs 1,750.00                               5,076.00                      290.06%Beehive101‐430‐3100‐43210 Telephone 5,500.00                               2,221.20                      40.39%101‐430‐3100‐43230 Radio 5,000.00                               1,120.20                      22.40%101‐430‐3100‐43310 Mileage 250.00                                   ‐                                0.00%101‐430‐3100‐43510 Public Notices 212.00                                   ‐                                0.00%101‐430‐3100‐43630 Insurance 25,787.00                             23,561.52                    91.37%Billed in Q2101‐430‐3100‐43810 Utilities 25,000.00                             12,015.65                    48.06%101‐430‐3100‐43811 Street Lights 39,000.00                             23,802.99                    61.03%101‐430‐3100‐43840 Refuse 4,600.00                               2,461.71                      53.52%101‐430‐3100‐44010 Repairs/Maint Bldg. 12,000.00                             2,027.87                      16.90%101‐430‐3100‐44030 Repairs/Maint Imp Other Than Bldg. 650.00                                  360.97                          55.53%101‐430‐3100‐44040 Repairs/Maint Equip 29,500.00                             6,265.85                      21.24%101‐430‐3100‐44041 Repairs/Maint Equip S&I 14,000.00                             2,219.99                      15.86%101‐430‐3100‐44130 Equipment Rental 2,000.00                                ‐                                0.00%101‐430‐3100‐44170 Uniforms 5,700.00                               2,604.57                      45.69%101‐430‐3100‐44330 Dues & Subscriptions 750.00                                  294.37                          39.25%101‐430‐3100‐44370 Conferences & Training 4,500.00                               415.00                          9.22%101‐430‐3100‐44380 Clean‐up Days‐                                         ‐                                #DIV/0!Total Charges and Services792,925.00                          370,474.55                 46.72%Capital Outlay101‐900‐9000‐47200 Transfer to Vehicle Replacement Fund101‐480‐3100‐45500 Capital Purchases‐                                         ‐                                #DIV/0!Total Capital Outlay‐                                         ‐                                #DIV/0!Miscellaneous101‐430‐3100‐44300 Miscellaneous 1,000.00                               461.30                          46.13%Total Miscellaneous1,000.00                               461.30                          46.13%3100Total Streets 1,611,194.00                      710,402.34                 44.09%5200Parks & RecreationPersonnel101‐450‐5200‐41010 Full‐time Salaries 72,988.00                             41,225.16                    56.48%101‐450‐5200‐41040 Temporary Employees 10,000.00                             1,232.00                      12.32%101‐450‐5200‐41210 PERA Contributions 5,474.00                               3,090.40                      56.46%101‐450‐5200‐41220 FICA Contributions 5,145.00                               2,540.12                      49.37%101‐450‐5200‐41230 Medicare Contributions 1,203.00                               594.05                          49.38%101‐450‐5200‐41300 Insurance 15,415.00                             8,673.14                      56.26%101‐450‐5200‐41325 Life Insurance 67.00                                    36.85                            55.00%101‐450‐5200‐41330 STD/LTD 401.00                                  228.78                          57.05%101‐450‐5200‐41600 Safety Clothing Allowance 350.00                                  269.74                          77.07%101‐450‐5200‐41510 Workers Compensation 10,901.00                             4,144.89                      38.02%Paid in Q2Total Personnel121,944.00                          62,035.13                    50.87%Materials and Supplies101‐450‐5200‐42000 Office Supplies 450.00                                  105.68                          23.48%101‐450‐5200‐42120 Fuel, Oil and Fluids 5,500.00                               3,157.35                      57.41%101‐450‐5200‐42150 Operating Supplies 750.00                                  224.86                          29.98%101‐450‐5200‐42210 Repair/Maint. Supplies 6,000.00                               3,738.01                      62.30%101‐450‐5200‐42230 Building Repair Supplies 500.00                                  79.87                            15.97%101‐450‐5200‐42250 Landscaping Materials 550.00                                  455.93                          82.90%101‐450‐5200‐42400 Small Tools & Minor Equipment 4,550.00                               1,563.68                      34.37%9 CITY OF LAKE ELMO2021 YTD ActualsMaster Worksheet 7/20/20212:40 PM2021 Actual YTD % ofAccount NumberDescriptionAdopted6/30/2021BudgetCommentsTotal Materials and Supplies18,300.00                             9,325.38                      50.96%Charges and Services101‐450‐5200‐43150 Contracted Services 56,000.00                             10,412.39                    18.59%101‐450‐5200‐43185 IT Support 5,500.00                               2,362.65                      42.96%101‐450‐5200‐43210 Telephone 1,750.00                               422.43                          24.14%101‐450‐5200‐43630 Insurance 7,858.00                               7,180.24                      91.37%Billed in Q2101‐450‐5200‐43810 Utilities 10,815.00                             3,379.19                      31.25%101‐450‐5200‐43840 Refuse 4,000.00                               1,334.03                      33.35%101‐450‐5200‐44010 Repairs/Maint Bldg 3,000.00                               1,677.72                      55.92%101‐450‐5200‐44030 Repairs/Maint Imp Not Bldgs 3,200.00                               1,345.61                      42.05%101‐450‐5200‐44040 Repairs/Maint Eqpt 14,000.00                             1,975.13                      14.11%101‐450‐5200‐44120 Rentals ‐ Buildings 7,000.00                               4,392.81                      62.75%101‐450‐5200‐44170 Uniforms 1,100.00                               525.26                          47.75%101‐450‐5200‐44302 Lakes 15,000.00                              ‐                                0.00%101‐450‐5200‐44370 Conferences & Training 3,000.00                               815.00                          27.17%101‐450‐5200‐44130 Equipment Rental 1,000.00                                ‐                                0.00%101‐450‐5200‐44375 Personal Protection Equipment 400.00                                   ‐                                0.00%Total Charges and Services133,623.00                          35,822.46                    26.81%Capital Outlay101‐900‐9000‐47200 Transfer to Vehicle Replacement Fund101‐900‐5200‐45500 Capital Purchases‐                                         ‐                                #DIV/0!Total Capital Outlay‐                                         ‐                                #DIV/0!10 CITY OF LAKE ELMO2021 YTD ActualsMaster Worksheet 7/20/20212:40 PM2021 Actual YTD % ofAccount NumberDescriptionAdopted6/30/2021BudgetCommentsMiscellaneous101‐450‐5200‐44300 Miscellaneous 1,000.00                                ‐                                0.00%Total Miscellaneous1,000.00                                ‐                                0.00%5200Total Parks & Recreation 274,867.00                          107,182.97                 38.99%9000TransfersTransfers101‐900‐9000‐47205 Operating Transfer to EDA 30,000.00                              ‐                                0.00%Will do at YE101‐900‐9000‐47250 Operating Trans to Vehicle‐Add 125,000.00                            ‐                                0.00%Will do at YE101‐900‐9000‐47200 Transfer to Vehicle Replacement Fund 135,746.00                            ‐                                0.00%Will do at YETotal Transfers290,746.00                           ‐                                0.00%9000Total Transfers 290,746.00                           ‐                                0.00%9000Contingency ReserveContingency ReserveReserve for possible Insurance Increase‐                                         ‐                                #DIV/0!Total Contingency Reserve‐                                         ‐                                #DIV/0!9000Contingency Reserve‐                                         ‐                                #DIV/0!Prior Period AdjustmentsTotal General Fund Expenditures:6,063,620.00                   2,205,487.73           36.37%Total Gen Fund Revs. Over/(Under) Expenditures:(2.00)                             (516,064.17)             601Water FundWater Fund Revenues:601‐000‐0000‐36100 Special Assessments 10,740.00                              ‐                                0.00%Booked with SA collections from County601‐494‐8000‐36103 Prepaid Special Assessments‐                                        18,421.77                    #DIV/0!601‐000‐0000‐37100 Water Sales 1,029,177.00                      146,399.83                  14.22%Q1 typically lower since winter months. Q2 billing will be booked in July601‐000‐0000‐37120 Bulk Water 1,000.00                               602.39                          60.24%601‐000‐0000‐37140 Water Access Revenue 1,617,000.00                      1,218,000.00              75.32%Fluctuates with timing and number of developments/projects. 601‐000‐0000‐37150 Water Connections ‐ Municipal 451,000.00                           351,000.00                  77.83%Continental601‐000‐0000‐37170 Meter Sales 95,000.00                             73,468.42                    77.34%601‐000‐0000‐36220 Rent 26,000.00                             8,000.00                      30.77%Farmland Rent Keene Faarms LLCTotal Water Fund Revenues:3,229,917.00                      1,815,892.41              56.22%Water Fund Expenses:Personnel601‐494‐9400‐41010 Full‐time Salaries 217,707.00                           129,113.19                  59.31%601‐494‐9400‐41030 Part‐time Salaries 13,992.00                              ‐                                0.00%No part time salaries since utility billing clerk made ft position601‐494‐9400‐41020 Overtime 6,000.00                               3,793.52                      63.23%601‐494‐9400‐41040 Temporary Employees‐                                         ‐                                #DIV/0!601‐494‐9400‐41210 PERA Contributions 17,827.00                             9,873.44                      55.38%601‐494‐9400‐41216 MSRS Contributions ‐City Admin 461.00                                  212.02                          45.99%601‐494‐9400‐41220 FICA Contributions 14,737.00                             7,785.72                      52.83%601‐494‐9400‐41230 Medicare Contributions 3,447.00                               1,820.90                      52.83%601‐494‐9400‐41300 Insurance 44,902.00                             27,544.09                    61.34%601‐494‐9400‐41325 Life Insurance 197.00                                  110.22                          55.95%601‐494‐9400‐41330 STD/LTD 1,177.00                               678.31                          57.63%601‐494‐9400‐41600 Safety Clothing Allowance 400.00                                   ‐                                0.00%601‐494‐9400‐41510 Workers Compensation 7,682.00                               7,853.08                      102.23%Total Personnel328,529.00                          188,784.49                 57.46%Within expectation11 CITY OF LAKE ELMO2021 YTD ActualsMaster Worksheet 7/20/20212:40 PM2021 Actual YTD % ofAccount NumberDescriptionAdopted6/30/2021BudgetCommentsMaterials and Supplies601‐494‐9400‐42000 Office Supplies 800.00                                  191.23                          23.90%601‐494‐9400‐42120 Fuel, Oil and Fluids 9,000.00                               3,408.50                      37.87%601‐494‐9400‐42030 Printed Forms 750.00                                  391.13                          52.15%601‐494‐9400‐42150 Operating Supplies 3,500.00                               772.35                          22.07%601‐494‐9400‐42160 Chemicals 11,000.00                             2,754.51                      25.04%601‐494‐9400‐42210 Repair/Maint. Supplies 16,000.00                             2,397.38                      14.98%601‐494‐9400‐42300 Water Meters & Supplies 145,000.00                           148,671.55                  102.53%Purchase at beginning of year601‐494‐9400‐44375 Personal Protective Equipment 800.00                                  (200.00)                          ‐25.00%601‐494‐9400‐42400 Small Tools & Minor Equipment 9,800.00                               2,219.77                      22.65%Total Materials and Supplies196,650.00                          160,606.42                 81.67%Charges and Services601‐494‐9400‐43030 Engineering Services 25,000.00                             5,435.75                      21.74%601‐494‐9400‐43010 Audit Services 8,227.00                               1,464.50                      17.80%601‐494‐9400‐43090 Newsletter1,100.00                               571.03                          51.91%601‐494‐9400‐43150 Contract Services 30,000.00                             30,862.66                    102.88%More than anticipated601‐494‐9400‐43185 IT Support 8,027.00                               3,573.25                      44.52%601‐494‐9400‐42002 IT Hardware 1,000.00                                ‐                                0.00%601‐494‐9400‐43190 Software Programs 9,900.00                               3,966.67                      40.07%601‐494‐9400‐43210 Telephone 2,000.00                               531.06                          26.55%601‐494‐9400‐44377 Credit Card Fees 7,262.00                               4,761.72                      65.57%601‐494‐9400‐43220 Postage 4,000.00                               825.33                          20.63%601‐494‐9400‐43310 Mileage 200.00                                   ‐                                0.00%601‐494‐9400‐43610 Insurance 11,607.00                             10,605.41                    91.37%Billed in Q2601‐494‐9400‐43810 Electric Utility 80,000.00                             25,778.09                    32.22%601‐494‐9400‐43820 Water Utility 23,000.00                             11,492.00                    49.97%601‐494‐9400‐44030 Repairs\Maint Imp Not Bldgs 45,000.00                             5,524.71                      12.28%601‐494‐9400‐44040 Repairs/Maint. Equip. 7,500.00                               129.55                          1.73%601‐494‐9400‐44010 Repairs\Maint Imp Bldgs 4,000.00                               1,562.93                      39.07%601‐494‐9400‐44150 Equipment Rental 1,000.00                                ‐                                0.00%601‐494‐9400‐44170 Uniforms 1,000.00                               488.54                          48.85%601‐494‐9400‐44330 Dues & Subscriptions 400.00                                   ‐                                0.00%601‐494‐9400‐44370 Conferences & Training 2,500.00                               1,040.00                      41.60%601‐494‐9400‐44386 Real Estate Taxes 23,777.00                             23,474.00                    98.73%Total Charges and Services296,500.00                          132,087.20                 44.55%Capital Outlay601‐494‐9400‐45300 Improvments Other Than Bldgs 658,844.00                           13,188.38                    2.00%Total Capital Outlay658,844.00                          13,188.38                    2.00%Miscellaneous and Non‐operating601‐494‐9400‐44300 Miscellaneous 2,000.00                                ‐                                0.00%601‐494‐9400‐46010 Bond Principal 790,000.00                           585,000.00                  74.05%601‐494‐9400‐46110 Bond Interest 252,402.00                           215,026.63                  85.19%Total Misc. and Non‐operating1,044,402.00                      800,026.63                 76.60%Prior Period AdjustmentsTotal Water Fund Expenses:2,524,925.00                   1,294,693.12           51.28%Total Water Fund Revs. Over/(Under) Expenses:704,992.00                  521,199.29           73.93%602Sewer FundSewer Fund Revenues:602‐000‐0000‐36100 Special Assessments 162,570.00                            ‐                                0.00%Booked with SA collections from County. Booked in Q3 and Q4602‐495‐8055‐36103 Special Assessments‐                                        3,745.95                      #DIV/0!SA payoffs602‐495‐8000‐36103 Prepaid Special Assessments‐                                        59,670.80                    #DIV/0!SA payoffs602‐000‐0000‐37200 Sewer Sales 466,378.00                           104,548.98                  22.42%Q1 billed. Q2 Billed in July12 CITY OF LAKE ELMO2021 YTD ActualsMaster Worksheet 7/20/20212:40 PM2021 Actual YTD % ofAccount NumberDescriptionAdopted6/30/2021BudgetComments602‐000‐0000‐37220 SAC Early Pay discount/revenue 7,500.00                               3,876.60                      51.69%602‐000‐0000‐37240 Sewer Connecton Fee Revenue (SAC) 1,359,000.00                      1,200,000.00              88.30%Fluctuates with timing and number of developments/projects. PY Continental properties602‐000‐0000‐37260 Sewer Connection Fees Municipa 389,000.00                           345,000.00                  88.69%Continental PropertiesTotal Sewer Fund Revenues:2,384,448.00                      1,716,842.33              72.00%Sewer Fund Expenses:Personnel602‐495‐9450‐41010 Full‐time Salaries 82,123.00                             40,840.63                    49.73%602‐495‐9450‐41030 Part‐time Salaries 12,243.00                              ‐                                0.00%No part time salaries since utility billing clerk made ft position602‐495‐9450‐41020 Overtime 6,000.00                               3,444.72                      57.41%602‐495‐9450‐41210 PERA Contributions 7,527.00                               3,245.63                      43.12%602-495-9450-41216MSRS Contributions ‐City Admin 308.00                                  106.04                          34.43%602‐495‐9450‐41220 FICA Contributions 6,223.00                               2,549.66                      40.97%602‐495‐9450‐41230 Medicare Contributions 1,455.00                               596.22                          40.98%602‐495‐9450‐41300 Insurance 16,435.00                             8,404.75                      51.14%602‐495‐9450‐41325 Life Insurance 69.00                                    29.08                            42.14%602‐495‐9450‐41330 STD/LTD 440.00                                  191.99                          43.63%602‐495‐9450‐41600 Safety Clothing Allowance 140.00                                   ‐                                0.00%602‐495‐9450‐41510 Workers Compensation 4,617.00                               2,715.84                      58.82%Total Personnel137,580.00                          62,124.56                    45.16%Within expectationMaterials and Supplies602‐495‐9450‐42210 Repair/Maint. Supplies 3,500.00                               19.45                            0.56%602‐495‐9450‐42000 Office Supplies 600.00                                  80.83                            13.47%602‐495‐9450‐42030 Printed Forms 600.00                                  294.00                          49.00%602‐495‐9450‐42120 Fuel, Oil and Fluids 8,200.00                               3,401.97                      41.49%602‐495‐9450‐42150 Operating Suppies 1,500.00                               122.85                          8.19%602‐495‐9450‐44375 Personal Protective Equipment 350.00                                   ‐                                0.00%602‐495‐9450‐42400 Small Tools & Minor Equipment 2,500.00                               1,420.93                      56.84%Total Materials and Supplies17,250.00                             5,340.03                      30.96%Charges and Services602‐494‐9450‐42210 RepairMaint. Supplies‐                                        67.88                            #DIV/0!602‐495‐9450‐43030 Engineering Services 15,000.00                             633.50                          4.22%602‐495‐9450‐43010 Audit Services 8,227.00                               1,464.50                      17.80%602‐495‐9450‐43090 Newsletter1,100.00                               571.02                          51.91%602‐495‐9450‐43150 Contract Services 50,000.00                             13,901.55                    27.80%602‐495‐9450‐43185 IT Support 4,684.00                               2,091.00                      44.64%602‐495‐9450‐42002 IT Hardware 650.00                                   ‐                                0.00%602‐495‐9450‐43190 Software Programs 9,305.00                               4,941.64                      53.11%602‐495‐9450‐43210 Telephone 2,500.00                               1,147.24                      45.89%602‐495‐9450‐44377 Credit Card Fees 7,262.00                               4,761.71                      65.57%602‐495‐9450‐43220 Postage 3,500.00                               704.95                          20.14%602‐495‐9450‐43310 Mileage 100.00                                   ‐                                0.00%602‐495‐9450‐43610 Insurance 4,633.00                               4,233.70                      91.38%Not yet billed Expense in Q2602‐495‐9450‐43810 Electric Utility 15,500.00                             6,811.21                      43.94%602‐495‐9450‐43820 Sewer Utility ‐ Met Council 265,011.00                           154,589.96                  58.33%Within expectation602‐495‐9450‐44010 Repairs/Maint Imp Bldgs 1,000.00                               892.74                          89.27%602‐495‐9450‐44040 Repairs/Maint. Equip. 4,500.00                                ‐                                0.00%602‐495‐9450‐44150 Equipment Rental 8,000.00                                ‐                                0.00%602‐495‐9450‐44170 Uniforms 600.00                                  321.78                          53.63%602‐495‐9450‐44030 Repairs\Maint Imp Not Bldgs 4,000.00                               3,045.40                      76.14%602‐495‐9450‐44370 Conferences & Training 3,500.00                               66.37                            1.90%Total Charges and Services409,072.00                          200,246.15                 48.95%Capital Outlay602‐480‐8081‐43030 Engineering Services‐                                        1,690.35                      #DIV/0!602‐480‐8081‐43150 Contract Services‐                                        (7,010.16)                     #DIV/0!2020 Retainage reversed in CY for FS presentation602‐495‐9450‐45300 Improvements Other Than Bldgs 275,760.00                            ‐                                0.00%13 CITY OF LAKE ELMO2021 YTD ActualsMaster Worksheet 7/20/20212:40 PM2021 Actual YTD % ofAccount NumberDescriptionAdopted6/30/2021BudgetCommentsTotal Capital Outlay275,760.00                          (5,319.81)                    ‐1.93%Miscellaneous and Non‐operating602‐495‐9450‐44300 Miscellaneous Expenses 1,000.00                                ‐                                602‐495‐9450‐46010 Bond Principal 470,000.00                           465,000.00                  98.94%602‐495‐9450‐46110 Bond Interest 169,822.00                           167,160.00                  98.43%Total Misc. and Non‐operating640,822.00                          632,160.00                 98.65%Prior Period AdjustmentTotal Sewer Fund Expenses:1,480,484.00                   894,550.93               60.42%Total Sewer Fund Revs. Over/(Under) Expenses:903,964.00                  822,291.40           90.97%603Storm Water FundStorm Water Fund Revenues:603‐000‐0000‐36210 Interest on Investment 4,574.00                               (11,611.78)                    ‐253.86%603‐000‐0000‐37100 Surface Water Utility Sales 385,155.00                            ‐                                0.00%Billed once a year603‐000‐0000‐37300 Storm Water Utility Sales 2,177.29                      #DIV/0!603‐000‐0000‐34113 SW Review Fee Revenue 35,000.00                             28,462.50                    81.32%Total Storm Water Fund Revenues:424,729.00                          19,028.01                    4.48%Storm Water Fund Expenses:Personnel603‐496‐9500‐41010 Full‐time Salaries 43,133.00                             25,201.52                    58.43%603‐496‐9500‐41030 Part‐time Salaries 8,745.00                                ‐                                0.00%no part time salaries since utility billing clerk made ft position603‐496‐9500‐41020 Overtime 1,000.00                               426.65                          42.67%603‐496‐9500‐41210 PERA Contributions 3,966.00                               1,891.93                      47.70%603‐496‐9500‐41216 MSRS Contributions ‐City Admin 154.00                                  52.99                            34.41%603‐496‐9500‐41220 FICA Contributions 3,278.00                               1,478.28                      45.10%603‐496‐9500‐41230 Medicare Contributions 767.00                                  345.85                          45.09%603‐496‐9500‐41300 Insurance 8,599.00                               5,912.37                      68.76%603‐496‐9500‐41325 Life Insurance 36.00                                    18.99                            52.75%603‐496‐9500‐41330 STD/LTD 230.00                                  127.10                          55.26%603‐496‐9500‐41600 Safety Clothing Allowance 125.00                                   ‐                                0.00%14 CITY OF LAKE ELMO2021 YTD ActualsMaster Worksheet 7/20/20212:40 PM2021 Actual YTD % ofAccount NumberDescriptionAdopted6/30/2021BudgetComments603‐496‐9500‐41510 Workers' Compensation 2,232.00                               1,060.04                      47.49%Total Personnel72,265.00                             36,515.72                    50.53%Within expectationMaterials and Supplies603‐496‐9500‐42000 Office Supplies 450.00                                   ‐                                0.00%603‐496‐9500‐42120 Fuel, Oil and Fluids 3,500.00                               877.10                          25.06%603‐496‐9500‐42030 Printed Forms 600.00                                  294.00                          49.00%603‐496‐9500‐42270 Repair/Maint. Maint Supplies 2,250.00                               125.70                          5.59%603‐496‐9500‐42150 Operating Supplies 1,000.00                                ‐                                0.00%603‐496‐9500‐44375 Personal Protective Equipment 500.00                                  (200.00)                          ‐40.00%603‐496‐9500‐42400 Small Tools & Minor Equipment 2,500.00                               250.46                          10.02%Total Materials and Supplies10,800.00                             1,347.26                      12.47%Charges and Services603‐496‐9500‐43030 Engineering Services 10,000.00                             5,792.50                      57.93%603‐496‐9500‐43010 Audit Services 8,227.00                               1,464.50                      17.80%603‐496‐9500‐43150 Contract Services 6,500.00                               1,742.46                      26.81%603‐496‐9500‐43185 IT Support 4,620.00                               1,912.42                      41.39%603‐496‐9500‐42002 IT Hardware 600.00                                   ‐                                0.00%603‐496‐9500‐43190 Software Programs 8,232.00                               3,966.66                      48.19%603‐496‐9500‐43210 Telephone 1,100.00                               422.45                          38.40%603‐496‐9500‐44377 Credit Card Fees 500.00                                   ‐                                0.00%603‐496‐9500‐43220 Postage 1,650.00                               1,336.94                      81.03%603‐496‐9500‐43510 Legal Publishing 60.00                                     ‐                                0.00%603‐496‐9500‐43610 Insurance 7,277.00                               6,647.41                      91.35%Billed in Q2603‐496‐9500‐44010 Street Sweeping28,000.00                             14,039.75                    50.14%603‐496‐9500‐44040 Repairs/Maint Equip 2,500.00                                ‐                                0.00%603‐496‐9500‐44015 Repairs/Maint Bldg 100.00                                   ‐                                0.00%603‐496‐9500‐44030 Repairs/Maint Not Bldg 25,000.00                              ‐                                0.00%603‐496‐9500‐44150 Equipment Rental 1,000.00                                ‐                                0.00%603‐496‐9500‐44170 Uniforms 250.00                                  90.05                            36.02%603‐496‐9500‐44370 Conferences & Training 2,000.00                               854.00                          42.70%Total Charges and Services107,616.00                          38,269.14                    35.56%Capital Outlay603‐496‐9500‐45300 Improvements Other Than Bldgs‐                                         ‐                                #DIV/0!Total Capital Outlay‐                                         ‐                                #DIV/0!Miscellaneous and Non‐operating603‐496‐9500‐44300 Miscellaneous Expenses 5,000.00                               780.00                          15.60%603‐496‐9500‐46010 Bond Principal 200,000.00                           200,000.00                  100.00%603‐496‐9500‐46110 Bond Interest 54,771.00                             75,251.00                    137.39%Total Misc. and Non‐operating259,771.00                          276,031.00                 106.26%Prior Period AdjustmentTotal Storm Water Fund Expenses:450,452.00                      352,163.12               78.18%Total Storm Water Fund Revs. Over/(Under) Expenses:(25,723.00)                   (333,135.11)          1295.09%221EDA Brookfield Building FundEDA Brookfield Bldg Fund Revenues:221‐000‐0000‐34110 Tenant Rents 88,836.00                             42,705.00                    48.07%Within expectation221‐000‐0000‐39201 Transfer from City Hall Budget 30,000.00                              ‐                                0.00%Will do at YETotal EDA Brookfield Building Fund Revenues:118,836.00                          42,705.00                    35.94%EDA Brookfield Bldg Fund Expenses:Materials and Supplies15 CITY OF LAKE ELMO2021 YTD ActualsMaster Worksheet 7/20/20212:40 PM2021 Actual YTD % ofAccount NumberDescriptionAdopted6/30/2021BudgetComments221‐460‐6301‐42110 Repair/Maint. Maint Supplies 2,000.00                               116.00                          5.80%221‐460‐6301‐42150 Operating Supplies 100.00                                   ‐                                0.00%Total Materials and Supplies2,100.00                               116.00                          5.52%Charges and Services221‐460‐6301‐43150 Contract Services 10,000.00                             4,386.94                      43.87%221‐460‐6301‐44386 Real Estate Taxes 14,410.00                             13,612.00                    94.46%Paid in Q2221‐460‐6301‐43810 Utilities 21,630.00                             6,878.57                      31.80%221‐460‐6301‐43840 Refuse 6,500.00                               2,201.81                      33.87%221‐460‐6301‐44040 Repairs/Maint Equip 7,500.00                                ‐                                0.00%Total Charges and Services60,040.00                             27,079.32                    45.10%Capital Outlay221‐460‐6301‐45200 Buildings‐                                         ‐                                #DIV/0!221‐460‐6301‐45300 Improvements Other Than Bldgs‐                                         ‐                                #DIV/0!Total Capital Outlay‐                                         ‐                                #DIV/0!Miscellaneous and Non‐operating221‐460‐6301‐44300 Miscellaneous Expenses 1,000.00                                ‐                                0.00%221‐460‐6301‐46010 Bond Principal 47,000.00                             47,000.00                    100.00%Paid once a year221‐460‐6301‐46110 Bond Interest 38,588.00                             19,822.50                    51.37%Paid Twice a year221‐460‐6301‐46200 Fiscal Agent Fees 1,700.00                                ‐                                0.00%Total Misc. and Non‐operating88,288.00                             66,822.50                    75.69%Total EDA Brookfield Bldg Fund Expenses:150,428.00                      94,017.82                 62.50%Total EDA Brookfield Bldg Fund Revs. Over/(Under) Expenses:(31,592.00)                   (51,312.82)            162.42%16 26,446.21 19,407.64 14,973.61 34,100.14 19,558.69 29,024.45 143,510.74 ‐20,000.00 40,000.00 60,000.00 80,000.00 100,000.00 120,000.00 140,000.00 160,000.00 January February March April May June July August September October November December Total2021 Interest Earnings from Investments $11,511,889.07 Money Market38%$6,171,554.97 Brokered CD20%$1,000,000.00 Non‐Brokered CD3%$6,748,096.20 Government Securities22%$3,477,737.70 Municipal Securities12%$1,603,746.43 Checking5%Market Value as of 6/30/2021 Category Total Concentration Face / CostYield to MaturityAnnualized Cost Yield AmountMarket ValueMoney Market 38% 11,511,889.07   0.23% 26,959.55       11,511,889.07$        Brokered CD 20% 6,091,000.00     1.73% 105,467.90    6,171,554.97$          Non‐Brokered CD 3% 1,000,000.00     0.50% 5,000.00         1,000,000.00$          Government Securities 22% 6,765,538.80     0.72% 48,882.08       6,748,096.20$          Municipal Securities 11% 3,358,419.86     2.43% 81,495.43       3,477,737.70$          Checking 5% 1,603,746.43     0.00%‐                   1,603,746.43$          100% 30,330,594.16   0.88% 267,804.96$  30,513,024.37$        Category Total Concentration Face / CostYield to MaturityAnnualized Cost Yield AmountMarket ValueMoney Market 49% 15,759,163.04   0.11% 17,178.52       15,759,163.04$        Brokered CD 23% 7,211,001.40     1.74% 125,564.52    7,306,877.88$          Government Securities 9% 2,815,263.83     0.37% 10,281.53       2,806,717.10$          Municipal Securities 11% 3,358,419.86     2.56% 86,099.59       3,461,168.90$          Checking 8% 2,584,847.91     0.00%‐                   2,584,847.91$          100% 31,728,696.04   0.75% 239,124.16$  31,918,774.83$        ChangeFace/Cost (1,398,101.88)       ‐4.41%Yield to Maturity 0.13%Concentration 50%As of June 30, 2021Going forward as CD's and Agency obligations are called there will be an increase in Governmental Securities concentration  since the option to replace have yields around 1% up 2% whereas CD's continue to have lower Yields between .05 to .90 for a one year to a five year. As of March 31, 2021Overall the rates remained constant. The market continues to stay low. Going forward the greatest impact will be when CD's and Agency obligations are called and the options to replace will have yields over 1% to 2% less than the current yields. The number of calls on Munis are minimal so the yield that portion of the portfolio should not diminish significantly. The total Cash & Investments decreased 4.41% or $1,398,101.88 due to large CIP paymenmts in Q2 for OV Phase 5&6, Hamlet on Sunfish Lake, Herittage Farms, and 2021 Mill & Overlay.