Loading...
HomeMy WebLinkAbout05(D) - Approval of Preliminary 2nd Quarter 2024 Financial Reports Report City of Prior Lake General Fund Summary - Comparison to Prior Year As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive (Negative)USED 6/30/2023 Positive (Negative) Revenues Taxes 14,047,266 14,047,266 7,098,201 (6,949,065) 51%6,358,058 740,143 Licenses and Permits 617,238 617,238 568,901 (48,337) 92%373,307 195,593 Intergovernmental 3,348,632 3,348,632 1,371,384 (1,977,248) 41%1,166,216 205,168 Charges for Services 1,887,267 1,887,267 1,030,532 (856,735) 55%923,128 107,404 Fines and Forfeitures - - 51,824 51,824 n/a 1,917 49,908 Interest (losses) on investments 160,000 160,000 162,335 2,335 101%137,293 25,042 Other 133,800 133,800 67,156 (66,644) 50%52,781 14,375 Transfers in 852,400 852,400 583,750 (268,650) 68%277,500 306,250 Total Revenues 21,046,603 21,046,603 10,934,083 (10,112,520) 52%9,290,200 1,643,883 Expenditures General Government 4,495,927 4,513,350 2,056,301 2,457,049 46%1,827,075 (229,225) Public Safety 10,828,082 10,935,999 4,559,763 6,376,236 42%3,761,100 (798,664) Public Works 2,847,321 2,937,321 1,289,550 1,647,771 44%1,135,523 (154,028) Culture and Recreation 2,626,785 2,666,785 1,048,479 1,618,306 39%972,072 (76,407) Transfer to other funds 248,488 248,488 24,244 224,244 10%459,258 435,014 Total Expenditures 21,046,603 21,301,943 8,978,337 12,323,606 42%8,155,027 (823,310) Net Change - (255,340) 1,955,746 2,211,086 1,135,173 COMPARATIVE City of Prior Lake General Fund Revenues As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) Taxes 101 31010.00 Current Property Taxes - General Purpos 13,029,707 13,029,707 6,614,385 (6,415,322) 51%5,732,194 882,191 101 31020.00 Delinquent Property Taxes - General Purp - - 24,732 24,732 n/a 43,128 (18,395) 101 31040.00 Fiscal Disparities 1,017,559 1,017,559 459,083 (558,476) 45%582,736 (123,653) Taxes 14,047,266 14,047,266 7,098,201 (6,949,065) 51%6,358,058 740,143 Licenses and Permits 101 32100.00 Business Licenses 1,050 1,050 1,800 750 171%1,050 750 101 32110.00 Liquor Licenses 80,470 80,470 73,645 (6,825) 92%81,879 (8,234) 101 32120.00 Cannabis Fee - - 4,200 4,200 n/a - 4,200 101 32160.00 Refuse Haulers 5,000 5,000 - (5,000) 0%5,035 (5,035) 101 32175.00 Public Private Gathering Permit - - 60 60 n/a 150 (90) 101 32180.00 Cigarette Licenses 2,295 2,295 2,295 - 100%2,295 - 101 32190.00 Community Event Application 5,000 5,000 1,930 (3,070) 39%2,130 (200) 101 32210.00 Building Permits 376,822 376,822 392,930 16,108 104%230,817 162,113 101 32211.00 Retainage Forfeiture - - - - n/a 2,688 (2,688) 101 32215.00 Mechanical Permits 79,548 79,548 42,772 (36,776) 54%22,763 20,009 101 32230.00 Plumbing Permits 56,702 56,702 43,848 (12,855) 77%19,208 24,640 101 32231.00 Sewer/Water Inspection 4,916 4,916 2,017 (2,900) 41%2,289 (273) 101 32260.00 Burning Permits 4,000 4,000 2,950 3,000 74%2,800 150 101 32270.00 Short-term Rental Fee 1,435 1,435 455 (980) 32%205 250 Licenses and Permits 617,238 617,238 568,901 (48,337) 92%373,307 195,593 Intergovernmental 101 33160.11 Fed Aids/Grants - Operating Police - - 3,813 3,813 n/a - 3,813 101 33416.01 State Aid - Police Train 30,000 30,000 - (30,000) 0%- - 101 33416.02 State Police Aid-Ins Prem 299,000 299,000 - (299,000) 0%- - 101 33417.00 State Aid - Fire Training 20,000 20,000 - (20,000) 0%11,100 (11,100) 101 33418.00 State Road & Bridge Aid 467,000 467,000 246,635 (220,365) 53%227,207 19,429 101 33420.00 State Fire Aid-Ins. Prem.299,835 299,835 - (299,835) 0%- - 101 33422.11 State Aids/Grants - Operating Police 3,500 3,500 - (3,500) 0%- - 101 33610.10 County Aids/Grants - Operating Grants - - - - n/a 2,820 (2,820) 101 33620.00 Township Fire & Resc Aid 959,522 959,522 480,125 (479,397) 50%375,090 105,036 101 33621.00 Liaison Aid 69,775 69,775 14,967 (54,808) 21%- 14,967 101 33631.00 Payment in Lieu of Taxes 1,200,000 1,200,000 600,000 (600,000) 50%550,000 50,000 101 33700.10 Miscellaneous Grants - Operating Grants - - 23,010 23,010 n/a - 23,010 101 33700.23 Miscellaneous Grants - Capital Parks - - 2,834 2,834 n/a - 2,834 Intergovernmental 3,348,632 3,348,632 1,371,384 (1,977,248) 41%1,166,216 205,168 COMPARATIVE City of Prior Lake General Fund Revenues As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) COMPARATIVE Charges for Services 101 31810.00 Franchise Taxes 559,000 559,000 138,835 (420,165) 25%140,626 (1,791) 101 34103.00 Zoning & Subdivision Fees 40,000 40,000 15,061 (24,940) 38%19,826 (4,766) 101 34104.00 Plan Check Fees 244,941 244,941 214,315 (30,626) 87%113,739 100,575 101 34105.00 Sale of Maps/Publications - Reports 500 500 35 (465) 7%270 (235) 101 34107.00 Assessment Searches - Reports 500 500 275 (225) 55%225 50 101 34108.00 Street Chip Seal Fee-New Development - - - - n/a 4,750 (4,750) 101 34109.00 Project Admin/Eng Fees 246,000 246,000 120,112 (125,888) 49%108,141 11,970 101 34203.00 Accident/Warrant Reports - Reports 200 200 165 (35) 83%562 (397) 101 34731.00 Adult League Fees 5,000 5,000 4,628 (372) 93%8,228 (3,600) 101 34732.00 Recreation Program Fees - Contracted 35,000 35,000 47,608 12,608 136%4,360 43,248 101 34735.00 Recreation Program Fees - Staff Run 65,000 65,000 68,050 3,050 105%79,270 (11,220) 101 34735.01 Recreation Program Fees - Club Prior 12,000 12,000 6,583 (5,417) 55%2,352 4,231 101 34760.01 Facility Rental - Regular 48,028 48,028 32,156 (15,872) 67%33,907 (1,751) 101 34760.87 Facility Rental - Lease 15,600 15,600 - (15,600) 0%- - 101 34761.00 Studio/Pavilion Rental 25,000 25,000 23,318 (1,682) 93%25,107 (1,788) 101 34762.00 Park Shelter Rental 20,000 20,000 15,452 (4,548) 77%84,010 (68,558) 101 34762.01 Boat Slip Rental 71,200 71,200 65,875 (5,325) 93%- 65,875 101 34765.01 Tower Leases - - 97,018 97,018 n/a 246,600 (149,582) 101 34765.87 Tower Leases - Lease 260,082 260,082 135,155 (124,927) 52%- 135,155 101 34780.00 Park Admission Fees 30,000 30,000 1,836 (28,164) 6% - 1,836 101 34783.00 City Contract Services 209,216 209,216 44,056 (165,160) 21%51,156 (7,100) Charges for Services 1,887,267 1,887,267 1,030,532 (856,735) 55%923,128 107,404 Fines and Forfeitures 101 35101.00 County Court Fines - - 50,336 50,336 n/a - 50,336 101 35104.00 Prosecution Restitution - - 1,489 1,489 n/a 1,917 (428) Fines and Forfeitures - - 51,824 51,824 n/a 1,917 49,908 Interest (losses) on investments 101 36210.00 Interest Earnings 180,000 180,000 169,180 (10,820) 94%141,389 27,790 101 36215.00 Amortization - Premium/Discount (20,000) (20,000) (26,483) (6,483) 132%(11,250) (15,233) 101 36225.00 Unrealized Inv.Gain(Loss)- - 19,639 19,639 n/a 7,154 12,485 Interest (losses) on investments 160,000 160,000 162,335 2,335 101%137,293 25,042 Other Miscellaneous Revenues 101 36102.00 County Assess. Collection 4,000 4,000 (243) (4,243) -6%2,589 (2,832) 101 36211.00 Developer Agreements 60,000 60,000 5,000 (55,000) 8%636 4,364 101 36212.00 Miscellaneous Revenue 69,800 69,800 46,064 (23,736) 66%38,234 7,830 101 36230.00 Contributions & Donations - - 1,080 1,080 n/a - 1,080 101 36230.11 Contributions - Shop with a Cop - - 250 250 n/a - 250 101 36230.13 Contributions and Donations - - 9,645 9,645 n/a 9,353 292 101 36230.33 Contributions - Charitable Gambling - - 2,000 2,000 n/a - 2,000 101 39102.00 Sale of Property - - 3,360 3,360 n/a 1,969 1,391 Other Miscellaneous Revenues 133,800 133,800 67,156 (66,644) 50%52,781 14,375 City of Prior Lake General Fund Revenues As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) COMPARATIVE Other financing sources 101 39203.00 Transfer from Other Funds 852,400 852,400 583,750 (268,650) 68%277,500 306,250 Other financing sources 852,400 852,400 583,750 (268,650) 68%277,500 306,250 Total Revenues 21,046,603 21,046,603 10,934,083 (10,112,520) 52%9,290,200 1,643,883 City of Prior Lake General Fund Expenditures As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) Function: General Government 41110.00 MAYOR & COUNCIL 83,227 83,227 40,718 42,509 49% 39,150 (1,568) 41130.00 ORDINANCE 5,000 5,000 1,863 3,137 37% 1,390 (473) 41320.00 ADMINISTRATION 393,124 393,124 190,570 202,554 48% 183,485 (7,085) 41330.00 BOARDS & COMMISSIONS 10,950 10,950 1,121 9,829 10% 2,261 1,140 41400.00 CITY CLERK 133,989 137,989 62,791 75,198 46% 58,909 (3,882) 41410.00 ELECTIONS 126,332 126,332 30,559 95,773 24% 578 (29,981) 41520.00 FINANCE 737,612 743,612 335,306 408,306 45% 276,425 (58,881) 41540.00 INTERNAL AUDITING 44,700 44,700 33,500 11,200 75% 32,500 (1,000) 41550.00 ASSESSING 258,575 258,575 250,055 8,520 97% 235,200 (14,855) 41610.00 LEGAL 267,214 267,214 115,926 151,288 43% 81,356 (34,570) 41820.00 HUMAN RESOURCES 364,352 364,352 160,456 203,896 44% 180,511 20,054 41830.00 COMMUNICATIONS 165,172 165,172 74,649 90,523 45% 73,770 (879) 41910.00 COMMUNITY DEVELOPMENT 397,650 397,650 114,041 283,609 29% 129,842 15,801 41920.00 INFORMATION TECHNOLOGY 605,413 612,836 299,571 313,265 49% 250,748 (48,823) 41940.00 FACILITIES - CITY HALL 902,617 902,617 345,174 557,443 38% 280,952 (64,222) Total - Function General Government 4,495,927 4,513,350 2,056,301 2,457,049 46% 1,827,075 (229,225) Function: Public Safety 42100.00 POLICE 7,165,532 7,253,432 3,082,653 4,170,779 42% 2,861,457 (221,196) 42200.00 FIRE 2,749,058 2,769,075 1,062,097 1,706,978 38% 506,611 (555,485) 42400.00 BUILDING INSPECTION 862,152 862,152 387,073 475,079 45% 379,946 (7,127) 42500.00 EMERGENCY MANAGEMENT 15,340 15,340 13,541 1,799 88% 1,085 (12,456) 42700.00 ANIMAL CONTROL 36,000 36,000 14,400 21,600 40% 12,000 (2,400) Total - Function Public Safety 10,828,082 10,935,999 4,559,763 6,376,236 42% 3,761,100 (798,664) Function: Public Works 43050.00 ENGINEERING 471,965 471,965 242,579 229,386 51% 198,587 (43,992) 43100.00 STREET 1,776,306 1,866,306 759,795 1,106,511 41% 668,490 (91,304) 43400.00 CENTRAL GARAGE 599,050 599,050 283,438 315,613 47% 268,072 (15,366) 43600.00 DEVELOPMENT PROJECTS - - 3,739 (3,739) n/a 374 (3,366) Total - Function Public Works 2,847,321 2,937,321 1,289,550 1,647,771 44% 1,135,523 (154,028) Function: Culture and Recreation 45100.00 RECREATION 627,505 627,505 243,552 383,953 39% 196,802 (46,750) 45200.00 PARKS 1,966,606 2,006,606 792,837 1,213,769 40% 741,821 (51,016) 45500.00 LIBRARIES 32,674 32,674 12,090 20,584 37% 33,449 21,359 Total - Function Culture and Recreation 2,626,785 2,666,785 1,048,479 1,618,306 39% 972,072 (76,407) 80000.00 Transfer to Other Funds 248,488 248,488 24,244 224,244 10% 459,258 435,014 Total Expenditures 21,046,603 21,301,943 8,978,337 12,323,606 42%8,155,027 (823,310) COMPARATIVE City of Prior Lake Expenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) GENERAL FUND Function: General Government 41110.00 MAYOR & COUNCIL 76,427 76,427 37,939 38,488 50% 32,136 (5,803) 41320.00 ADMINISTRATION 313,089 313,089 142,151 170,938 45% 137,372 (4,779) 41330.00 BOARDS & COMMISSIONS 10,550 10,550 1,615 8,935 15% 2,261 646 41400.00 CITY CLERK FUNCTIONS 130,660 130,660 59,990 70,670 46% 56,241 (3,749) 41410.00 ELECTIONS 112,832 112,832 25,922 86,910 23% 121 (25,801) 41520.00 FINANCE 704,542 704,542 318,455 386,087 45% 255,459 (62,995) 41820.00 HUMAN RESOURCES 316,502 316,502 143,161 173,341 45% 140,766 (2,396) 41830.00 COMMUNICATIONS 143,422 143,422 65,105 78,317 45% 61,128 (3,977) 41910.00 COMMUNITY DEVELOPMENT 348,850 348,850 110,932 237,918 32% 128,099 17,168 41920.00 INFORMATION TECHNOLOGY 256,283 256,283 118,422 137,861 46% 111,169 (7,253) 41940.00 FACILITIES - CITY HALL 101,693 101,693 44,535 57,158 44% 43,579 (956) Total - Function General Government 2,514,850 2,514,850 1,068,226 1,446,624 42% 968,331 (99,896) Function: Public Safety 42100.00 POLICE 6,238,856 6,238,856 2,754,640 3,484,216 44% 2,561,425 (193,215) 42200.00 FIRE 2,354,931 2,354,931 887,633 1,467,298 38% 286,798 (600,834) 42400.00 BUILDING INSPECTION 830,502 830,502 375,081 455,421 45% 372,873 (2,208) Total - Function Public Safety 9,424,289 9,424,289 4,017,354 5,406,935 43% 3,221,096 (796,258) Function: Public Works 43050.00 ENGINEERING 403,645 403,645 191,026 212,619 47% 176,447 (14,579) 43100.00 STREET 582,011 582,011 255,214 326,797 44% 260,704 5,490 43400.00 CENTRAL GARAGE 293,500 293,500 134,264 159,236 46% 130,182 (4,081) Total - Function Public Works 1,279,156 1,279,156 580,504 698,652 45% 567,333 (13,171) Function: Culture and Recreation 45100.00 RECREATION 444,525 444,525 149,230 295,295 34% 120,465 (28,765) 45200.00 PARKS 1,253,181 1,253,181 537,569 715,612 43% 540,145 2,576 Total - Function Culture and Recreation 1,697,706 1,697,706 686,799 1,010,907 40% 660,610 (26,189) General Fund Payroll Only Expenditures Total 14,916,001 14,916,001 6,352,883 8,563,118 43%5,417,370 (935,513) EDA FUND Function: Economic Development 46500.00 ECONOMIC DEVELOPMENT 163,834 163,834 57,033 106,801 35% 61,586 4,553 EDA Fund Payroll Only Expenditures Total 163,834 163,834 57,033 106,801 35%61,586 4,553 COMPARATIVE City of Prior Lake Expenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) COMPARATIVE WATER FUND Function: Water 41520.00 FINANCE 89,344 89,344 40,453 48,891 45% 38,661 (1,792) 49400.00 WATER 826,958 1,009,063 455,778 553,285 45% 446,709 (9,070) Water Fund Payroll Only Expenditures Total 916,302 1,098,407 496,231 602,176 45%485,370 (10,861) SEWER FUND Function: Sewer 41520.00 FINANCE 89,344 89,344 40,447 48,897 45% 38,654 (1,793) 49450.00 SEWER 869,044 686,939 314,394 372,545 46% 319,035 4,641 Sewer Fund Payroll Only Expenditures Total 958,388 776,283 354,840 421,443 46%357,688 2,848 STORM WATER FUND Function: Storm Water 49420.00 WATER QUALITY 370,250 370,250 109,059 261,191 29% 147,657 38,598 Storm Water Fund Payroll Only Expenditures Total 370,250 370,250 109,059 261,191 29%147,657 38,598 City-Wide Total Payroll Expenditures 17,324,775 17,324,775 7,370,047 9,954,728 43% 6,469,671 (900,376) City of Prior Lake Debt Service Funds As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) Revenues Property Taxes Current Property Taxes 3,203,024 3,203,024 1,631,151 (1,571,873) 51% 1,750,696 (119,545) Special Assessments City Assess. Collections - - 19,608 19,608 n/a 22,946 (3,338) County Assess. Collection 640,649 640,649 207,839 (432,810) 32% 224,357 (16,518) Interest (losses) on investments Interest Earnings 52,900 52,900 42,757 (10,143) 81% 37,130 5,627 Unrealized Inv.Gain(Loss) - - 5,604 5,604 n/a (1,341) 6,944 Other Financing Sources Transfer from Other Funds 1,010,990 965,990 86,769 (879,221) 9% 131,258 (44,489) Total Revenues 4,907,563 4,862,563 1,993,728 (2,868,835) 41%2,165,046 (171,318) Expenditures Debt Service Principal 4,202,801 4,202,801 145,629 4,057,172 3% 142,591 (3,038) Interest and Other 971,142 971,142 502,614 468,528 52% 525,764 23,150 Transfers to Other Funds 45,000 - - - n/a - - Total Expenditures 5,218,943 5,173,943 648,243 4,525,700 13%668,356 20,113 Net Change (311,380) (311,380) 1,345,484 1,496,690 COMPARATIVE City of Prior Lake Cable Fund As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) Revenues Charges for Services 210-41340.00-34304.00 PEG Access Fees 17,100 17,100 3,641 (13,459) 21% 4,399 (758) Interest (losses) on investments 210-41340.00-36210.00 Interest Earnings - - 1,728 1,728 n/a 1,279 449 210-41340.00-36225.00 Unrealized Inv. Gain (Loss) - - 58 58 n/a 52 6 Total Revenues 17,100 17,100 5,427 (11,673) 32%5,730 (304) Expenditures Current Expenditures 210-41340.00-52400.20 Small Equipment - Technology 6,000 6,000 - 6,000 0% - - 210-41340.00-54020.00 Software Service Contract - - 3,576 (3,576) n/a 3,576 - Total Expenditures 6,000 6,000 3,576 2,424 60%3,576 - Net Change 11,100 11,100 1,851 2,154 COMPARATIVE City of Prior Lake Capital Park Fund As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) Revenues Charges for Services 225-45200.00-34760.01 Facility Rental - Regular - - 12,200 12,200 n/a 12,000 200 225-45200.00-34760.87 Facility Rental - Lease 24,000 24,000 - (24,000) 0% - - 225-45200.00-34791.00 Dedication Fees 300,000 300,000 16,830 (283,170) 6% 98,937 (82,107) Charges for Services 324,000 324,000 29,030 (294,970) 9% 110,937 (81,907) Intergovernmental 225-00000.00-33700.20 Miscellaneous - Capital Grants - - 6,445 6,445 n/a - 6,445 Intergovernmental - - 6,445 6,445 n/a - 6,445 Interest (losses) on investments 225-00000.00-36210.00 Interest Earnings 30,600 30,600 27,689 (2,911) 90% 24,575 3,115 225-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 890 890 n/a 1,156 (266) Interest (losses) on investments 30,600 30,600 28,580 (2,020) 93% 25,731 2,849 Contributions and donations 225-00000.00-36230.00 Contributions & Donations - - 4,600 4,600 n/a 2,250 2,350 Contributions and donations - - 4,600 4,600 n/a 2,250 2,350 Total Revenues 354,600 354,600 68,655 (285,945) 19%138,918 (70,263) Expenditures 225-45200.00-53100.80 Professional Services-General 5,000 5,000 6,480 (1,480) 130% 4,872 (1,608) 225-45200.00-55040.00-PRK23-000001 Projects - Property & ROW Acquisit'n - - 2,800 (2,800) n/a - (2,800) 225-45200.00-55050.00-PRK23-000001 Projects - Professional Services - - 36,843 (36,843) n/a - (36,843) 225-45200.00-55050.00-TRN19-000004 Projects - Professional Services - - 5,343 (5,343) n/a 10,836 5,493 225-45200.00-55530.00 Infrastructure 300,000 300,000 - 300,000 0% 22,687 22,687 Total Expenditures 305,000 305,000 51,466 253,534 17%38,395 (13,070) Net Change 49,600 49,600 17,189 100,523 COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) Revenues Taxes 410-00000.00-31010.00 Current Property Taxes 800,000 800,000 407,562 (392,438) 51%390,780 16,782 Taxes 800,000 800,000 407,562 (392,438) 51%390,780 16,782 Interest (losses) on investments 410-00000.00-36210.00 Interest Earnings 14,500 14,500 10,168 (4,332) 70%11,105 (938) 410-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 1,953 1,953 n/a 805 1,148 Interest (losses) on investments 14,500 14,500 12,121 (2,379) 84%11,910 211 Sale of assets 410-00000.00-39102.00 Sale of Property - - 128,863 128,863 n/a 18,073 110,790 Sale of assets - - 128,863 128,863 n/a 18,073 110,790 Transfers in 410-00000.00-39203.00 Transfer from Other Funds - 400,000 400,000 - 100%108,750 291,250 Transfers in - 400,000 400,000 - 100%108,750 291,250 Total Revenues 814,500 1,214,500 948,546 (265,954) 78%529,514 419,032 COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) COMPARATIVE Expenditures Public Safety Police 410-42100.00-55550.00 Vehicles 330,000 543,000 34,766 508,234 6%176,049 141,283 410-42100.00-55570.00 Machinery & Equipment - - 30,760 (30,760) n/a 29,755 (1,005) Fire 410-42200.00-55550.00 Vehicles - 400,000 613,024 (213,024) 153%74,085 (538,939) 410-42200.00-55570.00 Machinery & Equipment - - - - n/a 96,453 96,453 Building Inspection 410-42400.00-55550.00 Vehicles - 44,000 - - 0%- - Emergency Management 410-42500.00-55570.00 Machinery & Equipment 93,200 93,200 - - 0%- - Total Public Safety 423,200 1,080,200 678,550 264,450 63%376,342 (302,208) Public Works Street 410-43100.00-55550.00 Vehicles - - 71,576 (71,576) n/a - (71,576) 410-43100.00-55570.00 Machinery & Equipment 38,000 38,000 30,625 7,375 81%36,178 5,554 Engineering 410-43050.00-55550.00 Vehicles 50,000 50,000 49,542 - 99%- (49,542) Central Garage 410-43400.00-55550.00 Vehicles 25,000 25,000 - 25,000 0%- - Total Public Works 113,000 113,000 151,743 (39,201) 134%36,178 (115,565) Culture and Recreation/Parks 410-45200.00-55550.00 Vehicles - 347,500 207,927 139,573 60%797 (207,130) 410-45200.00-55570.00 Machinery and Equipment 328,000 328,000 281,188 46,812 86%235,759 (45,429) Total Culture & Recreation 328,000 675,500 489,116 186,384 72%236,556 (252,559) Total Expenditures 864,200 1,868,700 1,319,409 411,634 71%649,076 (670,333) Net Change (49,700) (654,200) (370,863) (119,563) City of Prior Lake Revolving Park Equipment Fund As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) Revenues Taxes 430-00000.00-31010.00 Current Property Taxes 460,000 460,000 234,438 (225,562) 51%229,532 4,906 Taxes 460,000 460,000 234,438 (225,562) 51%229,532 4,906 Intergovernmental 430-45200.00-33422.23-PRK21-000001 State Aids/Grants - Capital Parks - - 269,537 269,537 n/a - 269,537 Intergovernmental - - 269,537 269,537 n/a - 269,537 Interest (losses) on investments 430-00000.00-36210.00 Interest Earnings 25,100 25,100 12,193 (12,907) 49%22,051 (9,858) 430-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 807 807 n/a (54) 861 Interest (losses) on investments 25,100 25,100 13,000 (12,100) 52%21,997 (8,997) Other 430-45200.00-36230.00 Contributions & Donations - - - - n/a 185,000 (185,000) Other - - - - n/a 185,000 (185,000) Total Revenues 485,100 485,100 516,975 31,875 107%436,529 80,446 Expenditures Culture and Recreation Dept 45200.00 - PARKS 430-45200.00-55020.00 Projects - Engineering - - 559 (559) n/a 55,182 54,623 430-45200.00-55050.00-PRK25-000001 Projects - Professional Services - - 11,280 11,280 n/a - (11,280) 430-45200.00-55530.00 Infrastructure 65,000 65,000 5,264 59,736 8%63,875 58,611 Total Culture & Recreation 65,000 65,000 17,104 70,456 26%119,057 101,954 Total Expenditures 65,000 65,000 17,104 70,456 26%119,057 101,954 Net Change 420,100 420,100 499,871 317,471 COMPARATIVE City of Prior Lake Facilities Management Fund As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) Revenues Taxes 440-00000.00-31010.00 Current Property Taxes 205,000 205,000 104,596 (100,404) 51% 80,624 23,971 Taxes 205,000 205,000 104,596 (100,404) 51% 80,624 23,971 Interest (losses) on investments 440-00000.00-36210.00 Interest Earnings 25,200 25,200 22,317 (2,883) 89% 20,071 2,246 440-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 1,129 1,129 n/a 826 303 Interest (losses) on investments 25,200 25,200 23,447 (1,753) 93% 20,897 2,549 Transfers in 440-00000.00-39203.00 Transfer from Other Funds 24,000 24,000 12,000 (12,000) 50% - 12,000 Transfers in 24,000 24,000 12,000 (12,000) 50% - 12,000 Debt Issued 440-00000.00-39310.00 G.O. Bond Proceeds 1,100,000 1,100,000 - (1,100,000) 0% - - Debt Issued 1,100,000 1,100,000 - (1,100,000) 0% - - Total Revenues 1,354,200 1,354,200 140,042 (1,214,158) 10%101,521 38,521 Expenditures Function: General Government 41940-55050.00 Projects Professional Svcs- FACILITIES - CITY HALL - - 35,454 (35,454) n/a 11,648 (23,806) 41940-55520.00 Building & Building Improvements-FACILITIES - CITY HALL 439,600 86,100 7,298 78,802 8% - (7,298) Total - Function General Government 439,600 86,100 42,752 43,348 50% 11,648 (31,104) Function: Public Safety 42100-55520.00 Building & Building Improvements-POLICE 81,000 188,000 17,964 170,036 10% - (17,964) 42200-55520.00 Building & Building Improvements-FIRE 178,600 170,500 6,090 164,410 4% 74,996 68,906 Total - Function Public Safety 259,600 358,500 24,054 334,446 7% 74,996 50,942 Function: Public Works 43400.00 CENTRAL GARAGE 128,000 128,000 9,962 118,038 8% - (9,962) Total - Function Public Works 128,000 128,000 9,962 118,038 8% - (9,962) Function: Culture and Recreation 45200.00 PARKS 16,000 141,000 15,080 125,920 11% - (15,080) 45500.00 LIBRARIES 23,500 148,500 20,719 127,781 14% - (20,719) Total - Function Culture and Recreation 39,500 289,500 35,799 253,701 12% - (35,799) Total Expenditures 866,700 862,100 112,568 749,533 13%86,644 (25,924) Net Change 487,500 492,100 27,475 14,878 COMPARATIVE City of Prior Lake Permanent Improvement Revolving Fund As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) Revenues Taxes 450-00000.00-31810.00 Franchise Taxes 1,080,000 1,080,000 267,831 (812,169) 25%269,383 (1,552) Taxes 1,080,000 1,080,000 267,831 (812,169) 25%269,383 (1,552) Special Assessments 450-00000.00-36101.00 City Assess. Collections - - 91,668 91,668 n/a 1,013 90,655 450-00000.00-36102.00 County Assess. Collection 580,666 580,666 21,196 (559,470) 4%42,369 (21,173) Special Assessments 580,666 580,666 112,864 (467,802) 19%43,381 69,482 Interest (losses) on investments 450-00000.00-36210.00 Interest Earnings 18,300 18,300 34,435 16,135 188%18,831 15,605 450-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - (3,731) (3,731) n/a (327) (3,404) Interest (losses) on investments 18,300 18,300 30,704 12,404 168%18,504 12,200 Transfers in 450-00000.00-39203.00 Transfer from Other Funds 1,850,000 - 615,441 615,441 n/a - 615,441 Transfers in 1,850,000 - 615,441 615,441 n/a - 615,441 Debt Issued 450-00000.00-39310.00 G.O. Bond Proceeds 1,696,200 1,696,200 - (1,696,200) 0%- - Debt Issued 1,696,200 1,696,200 - (1,696,200) 0%- - Total Revenues 5,225,166 3,375,166 1,026,840 (2,348,326) 30%331,268 695,572 Expenditures Function: Public Works 450-43100.00-55010.00-PIR24-000001 Projects - Contract Vouchers - - 1,732,261 (1,732,261) n/a - (1,732,261) 450-43100.00-55020.00-PIR24-000001 Projects - Engineering - - 155,167 (155,167) n/a 42,104 (113,064) 450-43100.00-55050.00-PIR24-000001 Projects - Professional Services - - 262 (262) n/a - (262) 450-43100.00-55530.00 Infrastructure 6,570,000 6,570,000 - (6,570,000) 0%- - Total - Function Public Works 6,570,000 6,570,000 1,887,690 (8,457,690) 29%42,104 (1,845,586) OTHER FINANCING USES Transfers out 450-80000.00-59203.00 Transfers to Other Funds 94,590 94,590 2,250 92,340 2%6,475 4,225 Transfers out 94,590 94,590 2,250 92,340 2%6,475 (4,225) Total Expenditures 6,664,590 6,664,590 1,889,940 4,774,650 28%48,579 (1,849,811) Net Change (1,439,424) (3,289,424) (863,100) 282,689 COMPARATIVE City of Prior Lake Water Fund As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) Revenues Operating Revenue Water Charges 601-49400.00-37100.00 Utility Receipts - Water 4,042,024 4,042,024 909,696 (3,132,328) 23%794,697 114,999 601-49400.00-37160.00 Penalties 20,000 20,000 4,228 (15,772) 21%3,412 816 4,062,024 4,062,024 913,924 (3,148,100) 22%798,109 115,815 Utility Base Fee 601-49400.00-37110.00 Utility Base Fee Revenue 1,374,903 1,374,903 536,428 (838,475) 39%508,232 28,196 1,374,903 1,374,903 536,428 (838,475) 39%508,232 28,196 Meter Sales 601-49400.00-37170.00 Water Meter Sales 79,825 79,825 30,524 (49,301) 38%30,753 (228) 601-49400.00-37175.00 Pressure Reducers 25,000 25,000 5,960 (19,040) 24%8,170 (2,210) 104,825 104,825 36,484 (68,341) 35%38,922 (2,438) Total Operating Revenue 5,541,752 5,541,752 1,486,836 (4,054,916) 27%1,345,263 141,573 Non-Operating Revenue Intergovernmental 601-49400.00-33422.15 State Aids/Grants - Operating Public Wor - - 3,868 3,868 n/a - 3,868 - - 3,868 3,868 n/a - 3,868 Interest (losses) on investments 601-00000.00-36210.00 Interest Earnings 117,300 117,300 135,612 18,312 116%97,160 38,452 601-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 2,144 2,144 n/a 3,101 (957) 117,300 117,300 137,756 20,456 117%100,261 37,495 Miscellaneous Revenues 601-00000.00-36212.00 Miscellaneous Revenue - - 440 440 n/a 11,929 (11,489) 601-00000.00-36102.00 County Assess Collection - - 18,165 18,165 n/a 34,547 (16,382) - - 18,605 18,605 - 46,476 (27,871) Total Non-Operating Revenue 117,300 117,300 160,229 42,929 137%146,737 13,492 Total Revenues 5,659,052 5,659,052 1,647,065 (4,011,987) 29%1,492,000 155,065 COMPARATIVE City of Prior Lake Water Fund As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) COMPARATIVE Total Expenditures Personnel and current expenditures (excluding depreciation) 41520.00 Finance 124,805 124,805 57,471 67,334 46%48,973 (8,498) 49400.00 Water 2,911,360 3,393,465 1,233,755 (2,159,710) 36%1,201,531 (32,224) 3,036,165 3,518,270 1,291,226 2,227,044 37%1,250,504 (40,722) Principal 601-49400.00-56010.00 Water 135,000 135,000 - 135,000 0%- - 135,000 135,000 - 135,000 0%- - Interest & other 601-49400.00-56110.00 Water 34,650 34,650 15,785 18,865 46%18,265 2,480 34,650 34,650 15,785 18,865 46%18,265 2,480 Capital improvements 601-49400.00-55530.00 Infrastructure 75,000 75,000 688 74,313 1%21,613 20,925 601-49400.00-55550.00 Vehicles - - 65,891 (65,891) n/a - (65,891) 601-49400.00-55570.00 Machinery and equipment 110,500 110,500 - 110,500 0%- - 185,500 185,500 66,579 118,921 36%21,613 (44,966) 601-49400.00-55700.00 Contra Capital Outlay - - - - n/a (12,986) 12,986 Total Expenditures 3,391,315 3,873,420 1,373,590 2,499,830 1,277,395 (70,222) Other Financing Sources 601-00000.00-39203.00 Transfer from Other Funds - - 14,750 14,750 n/a - 14,750 - - 14,750 14,750 n/a - 14,750 Debt Issued 601-00000.00-39315.00 Projects - Bond Premium - - - - n/a 4,327 4,327 - - - - n/a 4,327 4,327 Total Other Financing Sources - - 14,750 14,750 n/a 4,327 19,077 Other Financing Uses Transfers out 601-80000.00-59203.00 Transfers to other funds 2,713,650 863,650 351,262 512,388 41%951,127 599,865 2,713,650 863,650 351,262 512,388 41%951,127 599,865 Total Other Financing Uses 2,713,650 863,650 351,262 512,388 41%951,127 599,865 Total Revenues/Other Financing Sources 5,659,052 5,659,052 1,661,815 (3,997,237) 29%1,496,327 174,142 Total Expenditures/Other Financing Uses 6,104,965 4,737,070 1,724,852 3,012,218 36%2,228,522 529,643 Net Change (445,913) 921,982 (63,037) (985,019) (732,195) (355,500) City of Prior Lake Sewer Fund As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) Revenues Sewer Charges 604-49450.00-37102.00 Utility Receipts - Sewer 2,023,789 2,023,789 474,612 (1,549,177) 23%387,415 87,197 604-49450.00-37104.00 Utility Recpt-Sewer MCES 2,106,431 2,106,431 898,114 (1,208,317) 43%819,749 78,365 604-49450.00-37160.00 Penalties - - 2,919 2,919 n/a 2,413 506 4,130,220 4,130,220 1,375,646 (2,754,574) 33%1,209,578 166,068 Capital Facility charges 604-49450.00-37110.00 Utility Base Fee Revenue 1,195,743 1,195,743 464,847 (730,896) 39%441,105 23,742 1,195,743 1,195,743 464,847 (730,896) 39%441,105 23,742 Total Operating Revenue 5,325,963 5,325,963 1,840,493 (3,485,470) 35%1,650,683 189,810 Non-Operating Revenue Interest (losses) on investments 604-00000.00-36210.00 Interest Earnings 70,000 70,000 67,080 (2,920) 96%57,750 9,330 604-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - (216) (216) n/a 426 (642) 70,000 70,000 66,865 (3,135) 96%58,177 8,688 Miscellaneous Revenues 604-00000.00-36102.00 County Assess. Collections - - 18,165 18,165 n/a - 18,165 - - 18,165 18,165 n/a - 18,165 Total Non-Operating Revenue 70,000 70,000 85,029 15,029 121%58,177 26,852 Total Revenue 5,395,963 5,395,963 1,925,522 (3,470,441) 36%1,708,859 216,663 COMPARATIVE City of Prior Lake Sewer Fund As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) COMPARATIVE Total Expenditures Personnel and current expenditures (excluding depreciation) 41520.00 Finance 124,440 124,440 57,434 67,006 46%48,936 (8,498) 49450.00 Sewer 3,439,711 3,351,606 1,499,137 1,852,469 45%1,414,398 (84,739) 3,564,151 3,476,046 1,556,571 1,919,475 45%1,463,334 (93,236) Principal 604-49450.00-56010.00 Sewer 135,000 135,000 - 135,000 0%- - 135,000 135,000 - 135,000 0%- - Interest & other 604-49450.00-56110.00 Sewer 34,650 34,650 15,785 18,865 46%18,265 2,480 34,650 34,650 15,785 18,865 46%18,265 2,480 Capital improvements 604-49450.00-55530.00 Infrastructure 1,500,000 1,500,000 50,071 1,449,929 3%- (50,071) 604-49450.00-55570.00 Machinery and equipment 440,000 440,000 19,991 420,009 5%151,843 131,852 1,940,000 1,940,000 70,062 1,869,938 4%151,843 81,781 Total Expenditures 5,673,801 5,585,696 1,642,418 3,943,278 1,633,442 (8,975) Other Financing Sources Debt Issued 604-00000.00-39315.00 Projects - Bond Premium - - - - n/a 4,327 4,327 - - - - n/a 4,327 4,327 Transfers in 604-00000.00-39203.00 Transfer from Other Funds - - 51,408 51,408 n/a - 51,408 - - 51,408 51,408 n/a - 51,408 Total Other Financing Sources - - 51,408 51,408 n/a 4,327 55,735 Other Financing Uses 604-80000.00-59203.00 Transfers to other funds 247,000 247,000 585,403 (338,403) 237%579,453 (5,950) Total Other Financing Uses 247,000 247,000 585,403 (338,403) 237%579,453 (5,950) Total Revenues/ Other Financing Sources 5,395,963 5,395,963 1,976,930 (3,419,033) 37%1,713,187 272,398 Total Expenditures/Other Financing Uses 5,920,801 5,832,696 2,227,821 3,604,875 38%2,212,895 (14,925) Net Change (524,838) (436,733) (250,890) 185,843 (499,708) 287,324 City of Prior Lake Water Quality Fund As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) Revenues Storm Water Charges 602-49420.00-37120.00 Storm Water Revenue 1,510,793 1,510,793 614,203 (896,590) 41%540,953 73,250 602-49420.00-32250.00 Wetland Application Fee - - - - n/a 150 (150) 1,510,793 1,510,793 614,203 (896,590) 41%541,103 73,100 Water Charges 602-49420.00-37160.00 Penalties 4,000 4,000 860 (3,140) 21%724 136 4,000 4,000 860 (3,140) 21%724 136 Total Operating Revenue 1,514,793 1,514,793 615,063 (899,730) 41%541,827 73,236 Non-Operating Revenue Interest (losses) on investments 602-00000.00-36210.00 Interest Earnings 41,100 41,100 45,494 4,394 111%33,131 12,363 602-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 1,096 1,096 n/a (70) 1,166 41,100 41,100 46,590 5,490 113%33,061 13,528 Miscellaneous Revenues 602-00000.00-36212.00 Miscellaneous Revenue - - - - n/a 17,414 (17,414) 602-49420.00-33422.10 State Aids/Grants - Operating Grants - - 4,354 (4,354) n/a - (4,354) - - 4,354 (4,354) n/a 17,414 (21,768) Total Non-Operating Revenue 41,100 41,100 50,943 1,136 124%50,475 (8,239) Total Revenues 1,555,893 1,555,893 666,006 (898,594) 43%592,303 64,997 COMPARATIVE City of Prior Lake Water Quality Fund As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) COMPARATIVE Total Expenditures Personnel and current expenditures (excluding depreciation) 49420.00 Water Quality 674,800 674,800 194,248 480,552 29%229,757 35,509 674,800 674,800 194,248 480,552 29%229,757 35,509 Capital improvements 602-49420.00-55050.00 Projects - Professional Services - - 36,778 (36,778) n/a - 602-49420.00-55530.00 Infrastructure 1,708,000 1,708,000 213,788 1,494,212 13%102,108 (111,680) 1,708,000 1,708,000 250,565 1,457,435 15%102,108 (111,680) Total Expenditures 2,382,800 2,382,800 444,813 1,937,987 19%331,865 (76,171) Other Financing Uses 602-80000.00-59203.00 Transfers to other funds 113,300 113,300 381,156 (267,856) 336%55,000 (326,156) Total Other Financing Uses 113,300 113,300 381,156 (267,856) 336%55,000 (326,156) Total Revenues/ Other Financing Sources 1,555,893 1,555,893 666,006 (898,594) 43%592,303 64,997 Total Expenditures/Other Financing Uses 2,496,100 2,496,100 825,969 1,670,131 33%386,865 (402,326) Net Change (940,207) (940,207) (159,962) 771,538 205,438 (337,330) City of Prior Lake Economic Development Authority Special Revenue Fund As of 6/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 6/30/2023 Positive (Negative) Revenues Taxes 240-00000.00-31010.00 Current Property Taxes 364,000 364,000 187,269 (176,731) 51% 179,199 8,069 240-00000.00-31040.00 Fiscal Disparities 26,000 26,000 10,181 (15,819) 39% 14,128 (3,947) Taxes 390,000 390,000 197,450 (192,550) 51% 193,327 4,123 Charges for Services 240-46500.00-34760.02 Facility Rental - EDA 24,588 24,588 15,173 (9,415) 62% 14,343 830 Charges for Services 24,588 24,588 15,173 (9,415) 62% 14,343 830 Interest (losses) on investments 240-00000.00-36210.00 Interest Earnings 3,700 3,700 5,821 2,121 157% 4,109 1,712 240-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 1,063 1,063 n/a (92) 1,154 Interest (losses) on investments 3,700 3,700 6,883 3,183 186% 4,017 (2,866) Total Revenues 418,288 418,288 219,506 (198,782) 52%211,688 7,819 Expenditures Function: Economic Development 46500.00 ECONOMIC DEVELOPMENT 649,834 649,834 327,806 322,028 50% 90,925 (236,881) Total Expenditures 649,834 649,834 327,806 322,028 50%90,925 (236,881) Net Change (231,546) (231,546) (108,299) 120,763 COMPARATIVE