Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Information 06-17-2024
6-11-2024 08:07 AM CITY OF ELK RIVER PAGE: 1 REVENUE &. EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2024 101-GENERAL FUND FINANCIAL SUMMARY 41.67% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE REVENUE SUMMARY General Fund 21,570,600.00 270,835.34 1,452,532.31 6.73 20,118,067.69 1,755,401.60 TOTAL REVENUES 21,570,600.00 270,835.34 1,452,532.31 6.73 20,118,067.69 1,755,401.60 EXPENDITURE SUMMARY General Government City Council 213,550.00 7,786.03 69,922.62 32.74 143,6.27.38 65,596.35 Communications 485,300.00 34,702.08 174,705.10 36.00 310,594.90 162,055.51 Administrative Services 721,850.00 55,164.83 271,897.07 37.67 449,952.93 260,385.97 Human Resources 426,550.00 26,586.62 148,727.15 34.87 277,822.85 142,279.45 Elections 75,500.00 0.00 25,588.59 33.89 49,911.41 6,213.68 Finance 800,750.00 62,365.48 366,935.50 45.82 433,814.50 314,126.16 Information Technology 731,500.00 54,927.87 231,277.25 31.62 500,222.75 211,349.60 Legal 275,000.00 55,948.38 138,028.70 50.19 136,971.30 84,441.38 Community Development 0.00 17.04 34,265.46 0.00 ( 34,265.46) 104,722.16 Planning 485,100.00 36,215.57 175,506.52 36.18 309,593.48 95,172.74 Building Maintenance 1,085,250.00 76,286.36 397,314.15 36.61 687,935.85 391,806.00 TOTAL General Government 5,300,350.00 410,000.26 2, 034, 168. 11 38.38 3,266,181.89 1,838,149.00 Public Safety Police Administration 1,175,550.00 57,687.86 560,192.58 47.65 615,357.42 516,847.33 Patrol 3,780,150.00 253,974.27 1,359,031.27 35.95 2,421,118.73 1,351,084.55 Investigations I,430,850.00 91,121.18 424,269.77 29.65 1,006,580.23 489,893.26 Police Support Services 945,800.00 64,509.10 305,159.26 32.26 640,640.74 252,263.70 Police Reserves 16,550.00 0.00 678.84 4.10 15,871.16 1,578.04 Public safety building 229,500.00 6,177.38 60,288.58 26.27 169,211.42 78,865.59 Fire Administration 1,332,800.00 76,864.99 415,703.18 31.19 917,096.82 413,093.33 Fire Operations 630,450.00 28,082.22 212,231.12 33.66 418,218.88 255,023.11 Emergency Management 34,750.00 1,423.64 7,700.41 22.16 27,049.59 9,925.83 Building Safety 625,500.00 47,736.18 236,427.79 37.80 389,072.21 222,289.77 Code Enforcement 126,000.00 9,335.62 47,237.10 37.49 78,762.90 43,770.92 Environmental 101,700.00 10,255.92 46,830.83 46.05 54,869.17 36,318.83 TOTAL Public Safety 10,429,600.00 647,168.36 3,675,750.73 35.24 6,753,849.27 3,670,954.26 Public Works Street Maintenance 1,742,150.00 108,188.40 560,704.24 32.18 1,181,445.76 536,350.44 Snow Removal 411,150.00 475.00 201,793.13 49.08 209,356.87 234,662.21 Equipment Services 397,300.00 31,141.80 154,040.60 38.77 243,259.40 142,124.98 Engineering 489,150.00 37,669.09 192,722.61 39.40 296,427.39 182,434.62 TOTAL Public Works 3,039,750.00 177,474.29 1,109,260.58 36.49 1,930,489.42 1,095,572.25 Page 366 of 372 6-11-2024 08:07 AM CITY OF ELK RIVER PAGE: 2 REVENUE &. EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2024 101-GENERAL FUND FINANCIAL SUMMARY Culture & Recreation Parks Department Parks & Rec Admin Recreation Programs Farmers Market Sr Citizen Programs TOTAL Culture & Recreation Economic Development Economic Development Energy City TOTAL Economic Development General TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 41.67% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE 1,743,700.00 136,130.91 567,265.07 32.53 1,176,434.93 454,881.67 621,100.00 30,967.58 246,324.13 39.66 374,775.87 216,611.94 181,550.00 10,583.60 32,283.96 17.78 149,266.04 47,119.96 9,500.00 1,214.19 1,704.15 17.94 7,795.85 1,303.44 196,000.00 14,424.34 76,039.19 38.80 119,960.81 68,250.10 2,751,850.00 193,320.62 923,616.50 33.56 1,828,233.50 788,167.11 0.00 ( 12,623.68) 23,183.81 0.00 ( 23,183.81) 32,390.44 49,050.00 2,102.72 11,018.88 22.46 38,031.12 25,124.32 49,050.00 ( 10,520.96) 34,202.69 69.73 14,847.31 57,514.76 21,570,600.00 1,417,442.57 7,776,998.61 36.05 13,793,601.39 7,450,357.38 0.00 ( 1,146,607.23)( 6,324,466.30) 6,324,466.30 ( 5,694,955.78) Page 367 of 372 6-11-2024 08:07 AM CITY OF ELK RIVER PAGE: 3 REVENUE &. EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2024 101-GENERAL FUND REVENUES General Fund 41.67% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE faxes 101-3-0000-3111 Current Ad Valorem Taxes 14,917,700.00 0.00 ( 3,325.92) 0.02- 14,921,025.92 0.00 101-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 2,573.46 0.00 ( 2,573.46) 0.00 101-3-0000-3121 Gravel Tax 225,000.00 13,155.99 13,155.99 5.85 211,844.01 8,943.23 101-3-0000-3131 Penalties/Interest 0.00 0.00 75.2.46 0.00 ( 752.46) 0.00 TOTAL Taxes 15,142,700.00 13,155.99 13,155.99 0.09 15, 129, 544 .01 8,943.23 Licenses & Permits 101-3-0000-3211 Liquor License 82,000.00 40,010.00 66,245.00 80.79 15,755.00 71,845.00 101-3-0000-3212 THC License 4,000.00 0.00 400.00 10.00 3,600.00 2,400.00 101-3-0000-3213 Cigarette License 4,000.00 0.00 450.00 11.25 3,550.00 300.00 101-3-0000-3214 Rental License 65,000.00 5,980.00 26,190.00 40.29 38,810.00 35,750.00 101-3-0000-3216 Mining License 26,000.00 0.00 0.00 0.00 26,000.00 7,406.75 101-3-0000-3217 Garbage Hauler License 2,500.00 0.00 2,505.00 100.20 ( 5.00) 765.00 101-3-0000-3218 Other Business License/Permit 16,000.00 1,160.00 5,750.00 35.94 10,250.00 7,390.00 101-3-0000-3229 NPDES Permit 23,000.00 1,225.00 3,325.00 14.46 19,675.00 2,275.00 101-3-0000-3.231 Building Permit 600,000.00 36,205.35 125,064.10 20.84 474,935.90 227,577.75 101-3-0000-3232 Plumbing/Heating Permit 160,000.00 10,025.18 35,939.99 22.46 124,060.01 143,991.17 101-3-0000-3233 Permit Surcharge 700.00 408.59 1,940.95 277.28 ( 1,240.95) 8,899.24 101-3-0000-3235 Animal License 0.00 50.00 100.00 0.00 ( 100.00) 560.00 101-3-0000-3237 Other Non-Business.Lic/Permit 25,000.00 805.00 4,591.19 18.36 20,408.81 9,070.00 TOTAL Licenses & Permits 1,008,200.00 95,869.12 272,501.23 27.03 735,698.77 518,229.91 Intergovernmental Rev 101-3-0000-3311 Federal Grant 0.00 0.00 0.00 0.00 0.00 308.70 101-3-0000-3322 MV Credit 6,000.00 0.00 0.00 0.00 6,000.00 0.00 101-3-0000-3323 Fire State Aid 230,000.00 0.00 3,000.00 1.30 227,000.00 4,000.00 101-3-0000-3325 Police 20 Aid 340,000.00 0.00 0.00 0.00 340,000.00 0.00 101-3-0000-3326 Police Training Reimb 35,000.00 0.00 0.00 0.00 35,000.00 0.00 101-3-0000-3329 State Crime Prevention Grant 48,000.00 0.00 0.00 0.00 48,000.00 2,069.79 TOTAL Intergovernmental Rev 659,000.00 0.00 3,000.00 0.46 656,000.00 6,378.49 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 25,000.00 2,770.00 11,270.00 45.08 13,730.00 10,366.50 101-3-0000-3413 Plan Check Fee 250,000.00 11,785.20 54,267.55 21.71 195,732.45 125,858.48 101-3-0000-3415 Special Assessment Search 500.00 0.00 60.00 12.00 440.00 30.00 101-3-0000-3417 Copies 1,500.00 136.78 590.40 39.36 909.60 457.13 101-3-0000-3430 Lockout Fees 3,500.00 68.00 788.00 22.51 2,712.00 1,440.00 101-3-0000-3431 Police Services 45,000.00 30.00 11,256.82 25.02 33,743.18 11,600.00 101-3-0000-3432 School Liaison 183,000.00 0.00 93,556.76 51.12 89,443.24 89,805.56 101-3-0000-3434 Animal Impound Fee 500.00 100.00 350.00 70.00 150.00 300.00 101-3-0000-3436 Fire Contracts 400,000.00 0.00 259,592.96 64.90 140,407.04 238,139.39 101-3-0000-3437 Fire Services 3,000.00 0.00 1,009.34 33.64 1,990.66 ( 300.00 101-3-0000-3451 Street Services 35,000.00 2,690.00 11,817.50 33.76 23,182.50 7,175.00 101-3-0000-3452 Engineering Services Reimb 20,000.00 0.00 0.00 0.00 20,000.00 5,986.60 Page 368 of 372 6-11-2024 08:07 AM CITY OF ELK RIVER PAGE: 4 REVENUE &. EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2024 101-GENERAL FUND 41.67% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YID BALANCE 101-3-0000-3461 Recreation Fees 50,000.00 2,708.00 31,147.04 62.29 18,852.96 31,841.00 101-3-0000-3462 Sr Center Activities 43,000.00 2,350.26 19,182.57 44.61 23,817.43 22,336.86 101-3-0000-3463 Farmer's Market 12,000.00 360.00 19,325.00 161.04 ( 7,325.00) 12,420.00 101-3-0000-3469 Elk RiverFest 20,000.00 832.00 11,842.00 59.21 8,158.00 4,833.72 101-3-0000-3472 Park Use Fee 40,000.00 9,877.98 30,740.29 76.85 9,259.71 21,581.04 101-3-0000-3483 Sewer Inspection Fee 15,000.00 1,780.00 5,025.00 33.50 9,975.00 4,150.00 101-3-0000-3484 Contractor License Check 1,200.00 125.00 355.00 29.58 845.00 205.00 TOTAL Charges for Services 1,148,200.00 35,613.22 562,176.23 48.96 586,023.77 588,226.28 Fines & Forfeits 101-3-0000-3510 Court Fines 150,000.00 12,401.09 53,759.54 35.84 96,240.46 50,626.97 101-3-0000-3512 Ordinance Violations 0.00 0.00 0.00 0.00 0.00 1,600.00 TOTAL Fines & Forfeits 150,000.00 12,401.09 53,759.54 35.84 96,240.46 52,226.97 Special Assessments Other Revenue 101-3-0000-3621 Interest Income 150,000.00 0.00 81,807.96 54.54 68,192.04 63,446.62 101-3-0000-3625 Refunds & Reimbursements 145,000.00 6,200.00 ( 26,995.20) 18.62- 171,995.20 ( 1,497.94) 101-3-0000-3626 Contributions 25,000.00 0.00 25,750.00 103.00 ( '750.00) 39,760.00 101-3-0000-3629 Miscellaneous Revenue 10,000.00 455.58 3,538.51 35.39 6,461.49 4,670.81 TOTAL Other Revenue 330,000.00 6,655.58 84,101.27 25.49 245,898.73 106,379.49 Other Financing Sources Transfers In 101-3-0000-3921 Transfers 0.00 0.00 224.52 0.00 ( 224.52) 748.79 101-3-0000-3926 Transfer -Capital Outlay Resery 89,000.00 0.00 8,500.00 9.55 80,500.00 0.00 101-3-0000-3942 Transfer-WWTS 175,000.00 0.00 0.00 0.00 175,000.00 0.00 101-3-0000-3943 Transfer -Liquor 1,000,000.00 0.00 0.00 0.00 1,000,000.00 0.00 101-3-0000-3944 Transfer -Garbage 250,000.00 0.00 0.00 0.00 250,000.00 0.00 101-3-0000-3945 Transfer -Utilities 1,400,000.00 107,140.34 455,113.53 32.51 944,886.47 474,268.44 101-3-0000-3946 Transfer-Stormwater 135,000.00 0.00 0.00 0.00 135,000.00 0.00 101-3-0000-3948 Transfer-EDA 46,000.00 0.00 0.00 0.00 46,000.00 0.00 101-3-0000-3949 Transfer-HRA 37,500.00 0.00 0.00 0.00 37,500.00 0.00 TOTAL Transfers In 3,132,500.00 107,140.34 463,838.05 14.81 2,668,661.95 475,017.23 TOTAL General Fund 21,570,600.00 270,835.34 1,452,532.31 6.73 20,118,067.69 1,755,401.60 TOTAL REVENUE 21,570,600.00 270,835.34 1,452,532.31 6.73 20,118,067.69 1,755,401.60 Page 369 of 372 CITY OF ELK RIVER MULTIPURPOSE FACILITY - BUDGET TO ACTUAL MONTH ENDED MAY 31, 2024 Current Year to Date % of Budget Actual Budget Revenues: Ice Rental $893,500 $372,745 41.72% Admissions 45,000 23,687 52.64% Dry Floor Events/Craft Shows 7,000 465 6.64% Facility Rental 244,400 95,342 39.01% Advertising/Naming Rights/Sponsorships 178,000 63,821 35.85% Recreation fees (Skating/Hockey) 290,000 92,863 32.02% Concessions/vending 229,000 109,405 47.77% Other Revenues (interest, etc.) 9,100 6,651 73.09% Total Revenues $1,896,000 $764,979 40.35% Operating expenses: Personal services $900,650 $383,355 42.56% Supplies 159,800 96,482 60.38% Other service charges 661,300 173,207 26.19% Capital Outlay 120,400 0 0.00% Total Expenditures $1,842,150 $653,044 35.45% Revenues over/(under) expenditures $53,850 $111,935 FTCenter May 2024 $2,000,000 Budget, $1,896,000 Budget, $1,842,150 $1, 800,000 $1, 600,000 $1,400,000 $1, 200,000 $1,000,000 Actual $764,979 Actual $800,000 $653,044 $600,000 $400,000 $200,000 $0 Total Revenues Total Expenditures Page 370 of 372 Sales and cost of sales: Sales Cost of sales Gross profit Operating revenues: User charges Delinquency collections Other Total operating revenues Operating expenses: Personal services Supplies Other service charges Depreciation ' Total operating expenses Operating income (loss Nonoperating revenues (expenses): Interest income Interest expense/agent fees Total nonoperating revenues (expenses) Income (loss) before contributions & transfers Contributions - connection fees Transfers in (ARPA funds) Sale of assets Transfers out NET INCOME (LOSS) Items reclassified to balance sheet at year end: Bond Proceeds Capital Outlay Bond Payment (Payoff 2014B Refunded Debt) Revenues overl(under) expenditures Recorded at year-end CITY OF ELK RIVER ENTERPRISE FUNDS - BUDGET TO ACTUAL MONTH ENDED MAY 30, 2024 Liquor Sewer Garbage Stormwater Current Year to Date % of Current Year to Date % of Current Year to Date % of Current Year to Date % of Budget Actual Budget Budget Actual Budget Budget Actual Budget Budget Actual Budget $ 8,161,000 $ 3,214,076 39.38% 6,028,000 2,001,109 33.20% $ 2,630,000 $ 912,688 34.70% $ 2,009,800 $ 646,329 32A6% $ 630,000 $ 222,670 35.34% 2,133,000 1,212,966 56.87% - - - - - - 1,000 - 0.00% - 117 - - 19 - 9,000 1,535 17.060% 180,000 62,742 34.86% 9000 1535 17.06% 2,811,000 975,430 34.70% 2,009,800 646,446 32.16% 630000 222688 35.35% 1,070,500 458,856 42.86% 863,500 315,132 36.49% 45,550 18,365 40.32% - - - 28,100 18,397 65.47% 324,600 82,786 25.50% 23,400 763 3.26% 1,000 315 31.54% 355,950 104,683 29.41% 972,410 595,915 61.28% 1,773,250 551,661 31.11% 453,600 52,238 11.52% 100,000 0.00% 1,705,000 0.00% 495,000 0.00% 1,554,550 581,936 37.43% 3,865,510 993,833 25.71% 1,842,200 570,789 30.98% 949,600 52,554 5.53% 587,450 632,565 107.68% (1,054,510) (16,403) 1.75% 167,600 75,657 45.14% (319,600) 170,134 -53.23% 125,000 42,026 33.62% 125,000 104,625 83.70% 8,000 10,055 125.69% 25,000 23,459 93.84% (82,800) (42,918) 51.83% 125,000 42,026 33.62% 42,200 61,708 146023% 8,000 10,055 125069% 25,000 23,459 93.847/. 712,450 674,591 94.69% (1,012,310) 43,305 -4.26% 175,600 85,713 48.61% (294,600) 193,594 -65.71% - - - 1,000,000 95,942 9.59% - - - - - - - 350,000 0.00% - - 0.00% - 1,700 0.00% - - 0.00% - - 0.00% 1,250,000 0.00% (175,000) 0.00% (58,000) 0.00% 175,000 0.00% (537,550) 674,591 -125149% (187,310) 490,947 -262110% 117,600 85,713 72.89% (469,600) 193,594 -41.23% (91,000) - - (173,000) (398,384) - - - - - - - - - - (520,000) (520,000) - - - - - - - (628,550) 674,591 (880,310) (427,437) 117,600 85,713 469,600 193,594 Page 371 of 372 6-11-2024 08:46 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: MAY 31ST, 2024 FUND ACCOUNT# ACCOUNT NAME CLAIM ON CASH BEGINNING BALANCE CURRENT CURRENT ACTIVITY BALANCE 002-1010 Cash - Section 125 9,297.31 2,137.22 11,434.53 101-1010 Cash - General Fund 3,288,734.92 ( 1,117,659.13) 2,171,075.79 211-1010 Cash - Library 185,680.06 ( 10,304.12) 175,375.94 219-1010 Cash. - Federal COVID Fund 1,427,939.20 ( 344,387.36) 1,083,551.84 221-1010 Cash - Multipurpose Facility 37,210.61 ( 63,244.61)( 26,034.00) 225-1010 Cash - Park Dedication 1,453,061.71 ( 8,104.50) 1,444,957.21 228-1010 Cash - Landfill 195,832.75 ( 6,405.59) 189,427.16 231-1010 Cash.- Landfill Const Debris 852,220.05 0.00 852,2.20.05 240-1010 Cash - Micro Loan Fund 1,147,488.54 554.60 1,148,043.14 242-1010 Cash - State DEED 460,312.95 3,138.13 463,451.08 245-1010 Cash - Development Fund 1,260,915.69 437,062.70 1,697,978.39 290-1010 Cash.- Capital Outlay :Reserve 2,630,071.84 32,938.54 2,663,010.38 291-1010 Cash - Insurance Reserve ( 106,966.25)( 2,034.28)( 109,000.53) 292-1010 Cash - Govt Bldgs Reserve 5,149,839.98 1,580.55 5,151,420.53 294-1010 Cash - Drug Forfeiture 6,572.84 686.42 7,259.26 296-1010 Cash. - GRE :Reserve 830,061.22 373.00 830,434.22 301-1010 Cash - 2020A GO CIP Bonds 33,644.05 0.00 33,644.05 302-1010 Cash - 2021A GO CIP BONDS 20,042.94 0.00 20,042.94 333-1010 Cash - 2020B (2010/2012) Bonds ( 173,296.30) 0.00 ( 173,296.30) 343-1010 Cash.- 2019A Sales Tax Bonds 7,894,971.59 0.00 7,894,971.59 401-1010 Cash - Pavement Mgmt 4,813,764.81 1,221,.257.30 6,035,022.11 403-1010 Cash - Street Improvement 547,289.33 ( 6,417.00) 540,872.33 406-1010 Cash - City Wide Trunk Util 1,656,259.73 ( 1,345, 363. 67) 310,896.06 410-1010 Cash. - Equipment :Replacement 1,943,408.01 ( 123,315.00) 1,820,093.01 411-1010 Cash - Technology Replacement 50,236.01 911.32 51,147.33 420-1010 Cash - Active ER 1,500,862.17 0.00 1,500,862.17 421-1010 Cash - PS Building/Fire Sta 3 917,421.20 3,718.21 921,139.41 440-1010 Cash. - Park Improvement 290,701.61 ( 314,490.56)( 23,788.95) 462-1010 Cash - TIF 422 Downtown Redev 1,342.75 0.00 1,342.75 463-1010 Cash - TIF 423 Prof Powder 5,399.29 0.00 5,399.29 465-1010 Cash - TIF 25 Jackson Hills 18,300.30 0.00 18,300.30 466-1010 Cash.- TIF 426 Shoot Steel 2,381.20 0.00 2,381.20 467-1010 Cash - TIF 427 Delta Apartment 1,398.28 0.00 1,398.28 602-1010 Cash - Wastewater Treatment 9,619,849.29 ( 172,237.03) 9,447,612.26 603-1010 Cash - Liquor 3,985,340.81 142,000.18 4,127,340.99 605-1010 Cash. - Garbage 975,804.18 19,940.01 995,744.19 607-1010 Cash - Storm Water 2,272,224.17 55,614.42 2,327,838.59 801-1010 Cash - Interest. 0.00 123,237.17 123,237.17 821-1010 Cash - Developer Escrow 1,162,764.24 9,000.00 1,171,764.24 TOTAL CLAIM ON CASH 56,368,383.08 ( 1,459,813.08) 54,908,570.00 CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 214,265,637.46 ( 73,559.95) 214,192,077.51 999-1001 PY BANK ACCOUNT (186,279,443.94)( 1,386,253.13)(187,665,697.07) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 56,368,383.08 ( 1,459,813.08) 54,908,570.00 Page 372 of 372