Loading...
HomeMy WebLinkAbout05(B) - Approval of Preliminary 3rd Quarter 2024 Financial Reports ReportAttachment 1 City of Prior Lake General Fund Summary - 2024 Projection As of 96/30/2024 (Preliminary & Unaudited) Variance from 2024 2024 2024 Amended Budget - % BDGT Budget Amended Projection Positive (Negative) USED Revenues Taxes 14,047,266 14,047,266 14,051,999 4,733 100% Licenses and Permits 617,238 617,238 759,519 142,281 123% Intergovernmental 3,348,632 3,348,632 3,551,820 203,188 106% Charges for Services 1,887,267 1,887,267 1,937,953 50,686 103% Fines and Forfeitures - - 105,978 105,978 n/a Interest (losses) on investments 160,000 160,000 526,358 366,358 329% Other 133,800 133,800 137,308 3,508 103% Transfers in 852,400 852,400 876,400 24,000 103% Total Revenues 21,046,603 21,046,603 21,947,336 900,733 104% Expenditures General Government 4,495,927 4,513,350 4,221,832 291,518 94% Public Safety 10,828,082 10,935,999 10,675,592 260,407 98% Public Works 2,847,321 2,937,321 2,841,992 95,329 97% Culture and Recreation 2,626,785 2,666,785 2,632,608 34,177 99% Transfer to other funds 248,488 248,488 248,488 - 100% Total Expenditures 21,046,603 21,301,943 20,620,511 681,432 97% Net Change - (255,340) 1,326,824 1,582,164 (255,340) 1,326,824 City of Prior Lake General Fund Summary - Comparison to Prior Year As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive (Negative) USED 9/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 740,669 123,431 120% 591,883 148,787 Intergovernmental 3,348,632 3,348,632 2,501,245 (847,387) 75% 2,623,032 (121,787) Charges for Services 1,887,267 1,887,267 1,557,898 (329,369) 83% 1,435,157 122,742 Fines and Forfeitures - - 78,978 78,978 n/a 2,677 76,300 Interest (losses) on investments 160,000 160,000 451,358 291,358 282% 232,326 219,032 Other 133,800 133,800 138,252 4,452 103% 79,694 58,559 Transfers in 852,400 852,400 730,075 (122,325) 86% 416,250 313,825 Total Revenues 21,046,603 21,046,603 13,296,677 (7,749,926) 63% 11,739,076 1,557,601 Expenditures General Government 4,495,927 4,513,350 2,904,688 1,608,662 64% 2,624,491 (280,197) Public Safety 10,828,082 10,935,999 7,029,547 3,906,452 64% 5,945,307 (1,084,240) Public Works 2,847,321 2,937,321 2,084,058 853,263 71% 1,826,489 (257,569) Culture and Recreation 2,626,785 2,666,785 1,919,330 747,455 72% 1,678,419 (240,911) 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 13,961,866 7,340,077 66% 12,533,962 (1,427,904) Net Change - (255,340) (665,190) (409,850) (794,887) COMPARATIVE City of Prior Lake General Fund Revenues As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/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) Total - 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 2,200 1,150 210% 1,050 1,150 101 32110.00 Liquor Licenses 80,470 80,470 73,795 (6,675) 92% 81,954 (8,159) 101 32120.00 Cannabis Fee - - 4,200 4,200 n/a 3,500 700 101 32160.00 Refuse Haulers 5,000 5,000 5,935 935 119% 5,035 900 101 32175.00 Public Private Gathering Permit - - 90 90 n/a 240 (150) 101 32180.00 Cigarette Licenses 2,295 2,295 2,795 500 122% 2,295 500 101 32190.00 Community Event Application 5,000 5,000 1,980 (3,020) 40% 2,230 (250) 101 32210.00 Building Permits 376,822 376,822 531,884 155,062 141% 410,841 121,044 101 32211.00 Retainage Forfeiture - - - - n/a 2,688 (2,688) 101 32215.00 Mechanical Permits 79,548 79,548 55,196 (24,352) 69% 40,652 14,544 101 32230.00 Plumbing Permits 56,702 56,702 55,424 (1,278) 98% 33,968 21,456 101 32231.00 Sewer/Water Inspection 4,916 4,916 2,725 (2,191) 55% 3,216 (491) 101 32260.00 Burning Permits 4,000 4,000 3,990 3,000 100% 3,600 390 101 32270.00 Short-term Rental Fee 1,435 1,435 455 (980) 32% 615 (160) Total - Licenses and Permits 617,238 617,238 740,669 123,431 120% 591,883 148,787 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 31,423 1,423 105% 30,306 1,117 101 33416.02 State Police Aid-Ins Prem 299,000 299,000 - (299,000) 0% 317,608 (317,608) 101 33417.00 State Aid - Fire Training 20,000 20,000 41,839 21,839 209% 11,100 30,739 101 33418.00 State Road & Bridge Aid 467,000 467,000 443,943 (23,057) 95% 408,972 34,971 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 - - 170 170 n/a 2,850 (2,680) 101 33610.11 County Aids/Grants - Operating Police - - 6,721 6,721 n/a 2,017 4,704 101 33620.00 Township Fire & Resc Aid 959,522 959,522 960,250 728 100% 750,179 210,071 101 33621.00 Liaison Aid 69,775 69,775 84,742 14,967 121% - 84,742 101 33631.00 Payment in Lieu of Taxes 1,200,000 1,200,000 900,000 (300,000) 75% 1,100,000 (200,000) 101 33700.10 Miscellaneous Grants - Operating Grants - - 25,510 25,510 n/a - 25,510 101 33700.23 Miscellaneous Grants - Capital Parks - - 2,834 2,834 n/a - 2,834 Total - Intergovernmental 3,348,632 3,348,632 2,501,245 (847,387) 75% 2,623,032 (121,787) COMPARATIVE City of Prior Lake General Fund Revenues As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/30/2023 Positive (Negative) COMPARATIVE Charges for Services 101 31810.00 Franchise Taxes 559,000 559,000 275,822 (283,178) 49% 281,410 (5,588) 101 34103.00 Zoning & Subdivision Fees 40,000 40,000 28,947 (11,053) 72% 27,740 1,207 101 34104.00 Plan Check Fees 244,941 244,941 279,842 34,901 114% 200,824 79,019 101 34105.00 Sale of Maps/Publications - Reports 500 500 35 (465) 7% 310 (275) 101 34107.00 Assessment Searches - Reports 500 500 425 (75) 85% 325 100 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 180,168 (65,832) 73% 162,212 17,955 101 34203.00 Accident/Warrant Reports - Reports 200 200 280 80 140% 687 (407) 101 34731.00 Adult League Fees 5,000 5,000 4,274 (726) 85% 3,931 344 101 34732.00 Recreation Program Fees - Contracted 35,000 35,000 50,967 15,967 146% 42,735 8,233 101 34735.00 Recreation Program Fees - Staff Run 65,000 65,000 68,039 3,039 105% 51,893 16,146 101 34735.01 Recreation Program Fees - Club Prior 12,000 12,000 8,431 (3,569) 70% 3,956 4,475 101 34760.01 Facility Rental - Regular 48,028 48,028 48,516 488 101% 50,175 (1,659) 101 34760.87 Facility Rental - Lease 15,600 15,600 - (15,600) 0% - - 101 34761.00 Studio/Pavilion Rental 25,000 25,000 32,161 7,161 129% 29,688 2,473 101 34762.00 Park Shelter Rental 20,000 20,000 20,545 545 103% 90,526 (69,981) 101 34762.01 Boat Slip Rental 71,200 71,200 65,875 (5,325) 93% - 65,875 101 34765.01 Tower Leases - - - - n/a 299,348 (299,348) 101 34765.87 Tower Leases - Lease 260,082 260,082 282,465 22,383 109% - 282,465 101 34780.00 Park Admission Fees 30,000 30,000 33,250 3,250 111% 27,894 5,357 101 34783.00 City Contract Services 209,216 209,216 177,856 (31,360) 85% 156,755 21,101 Total - Charges for Services 1,887,267 1,887,267 1,557,898 (329,369) 83% 1,435,157 122,742 Fines and Forfeitures 101 35101.00 County Court Fines - - 76,429 76,429 n/a - 76,429 101 35104.00 Prosecution Restitution - - 2,549 2,549 n/a 2,677 (129) Total - Fines and Forfeitures - - 78,978 78,978 n/a 2,677 76,300 Interest (losses) on investments 101 36210.00 Interest Earnings 180,000 180,000 278,352 98,352 155% 236,597 41,755 101 36215.00 Amortization - Premium/Discount (20,000) (20,000) (45,146) (25,146) 226% (15,095) (30,051) 101 36225.00 Unrealized Inv.Gain(Loss) - - 218,151 218,151 n/a 10,823 207,328 Total - Interest (losses) on investments 160,000 160,000 451,358 291,358 282% 232,326 219,032 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 25,000 (35,000) 42% 636 24,364 101 36212.00 Miscellaneous Revenue 69,800 69,800 68,146 (1,654) 98% 58,263 9,883 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 - - 11,743 11,743 n/a 15,676 (3,933) 101 36230.33 Contributions - Charitable Gambling - - 28,500 28,500 n/a - 28,500 101 39102.00 Sale of Property - - 3,777 3,777 n/a 2,531 1,246 Total - Other Miscellaneous Revenues 133,800 133,800 138,252 4,452 103% 79,694 58,559 City of Prior Lake General Fund Revenues As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/30/2023 Positive (Negative) COMPARATIVE Other financing sources 101 39203.00 Transfer from Other Funds 852,400 852,400 730,075 (122,325) 86% 416,250 313,825 Total - Other financing sources 852,400 852,400 730,075 (122,325) 86% 416,250 313,825 Total Revenues 21,046,603 21,046,603 13,296,677 (7,749,926) 63% 11,739,076 1,557,601 City of Prior Lake General Fund Expenditures As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/30/2023 Positive (Negative) Function: General Government 41110.00 MAYOR & COUNCIL 83,227 83,227 58,335 24,892 70% 58,780 445 41130.00 ORDINANCE 5,000 5,000 6,461 (1,461) 129% 3,045 (3,416) 41320.00 ADMINISTRATION 393,124 393,124 277,049 116,075 70% 276,722 (326) 41330.00 BOARDS & COMMISSIONS 10,950 10,950 3,983 6,967 36% 4,521 538 41400.00 CITY CLERK 133,989 137,989 93,819 44,170 68% 87,662 (6,157) 41410.00 ELECTIONS 126,332 126,332 53,639 72,693 42% 578 (53,061) 41520.00 FINANCE 737,612 743,612 501,478 242,134 67% 421,827 (79,650) 41540.00 INTERNAL AUDITING 44,700 44,700 42,019 2,681 94% 47,345 5,326 41550.00 ASSESSING 258,575 258,575 250,055 8,520 97% 235,200 (14,855) 41610.00 LEGAL 267,214 267,214 153,500 113,714 57% 121,731 (31,770) 41820.00 HUMAN RESOURCES 364,352 364,352 243,042 121,310 67% 287,380 44,338 41830.00 COMMUNICATIONS 165,172 165,172 111,271 53,901 67% 106,372 (4,899) 41910.00 COMMUNITY DEVELOPMENT 397,650 397,650 188,560 209,090 47% 211,648 23,089 41920.00 INFORMATION TECHNOLOGY 605,413 612,836 382,603 230,233 62% 330,047 (52,555) 41940.00 FACILITIES - CITY HALL 902,617 902,617 538,874 363,743 60% 431,632 (107,242) Total - Function General Government 4,495,927 4,513,350 2,904,688 1,608,662 64% 2,624,491 (280,197) Function: Public Safety 42100.00 POLICE 7,165,532 7,253,432 4,759,094 2,494,338 66% 4,363,123 (395,971) 42200.00 FIRE 2,749,058 2,769,075 1,654,784 1,114,291 60% 981,997 (672,786) 42400.00 BUILDING INSPECTION 862,152 862,152 582,719 279,433 68% 567,715 (15,004) 42500.00 EMERGENCY MANAGEMENT 15,340 15,340 13,750 1,590 90% 10,871 (2,878) 42700.00 ANIMAL CONTROL 36,000 36,000 19,200 16,800 53% 21,600 2,400 Total - Function Public Safety 10,828,082 10,935,999 7,029,547 3,906,452 64% 5,945,307 (1,084,240) Function: Public Works 43050.00 ENGINEERING 471,965 471,965 363,573 108,392 77% 299,442 (64,132) 43100.00 STREET 1,776,306 1,866,306 1,305,392 560,915 70% 1,134,069 (171,323) 43400.00 CENTRAL GARAGE 599,050 599,050 409,395 189,655 68% 392,605 (16,790) 43600.00 DEVELOPMENT PROJECTS - - 5,698 (5,698) n/a 374 (5,325) Total - Function Public Works 2,847,321 2,937,321 2,084,058 853,263 71% 1,826,489 (257,569) Function: Culture and Recreation 45100.00 RECREATION 627,505 627,505 453,905 173,600 72% 378,822 (75,083) 45200.00 PARKS 1,966,606 2,006,606 1,447,309 559,297 72% 1,248,595 (198,714) 45500.00 LIBRARIES 32,674 32,674 18,116 14,558 55% 51,001 32,886 Total - Function Culture and Recreation 2,626,785 2,666,785 1,919,330 747,455 72% 1,678,419 (240,911) 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 13,961,866 7,340,077 66% 12,533,962 (1,427,904) COMPARATIVE City of Prior Lake Expenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/30/2023 Positive (Negative) GENERAL FUND Function: General Government 41110.00 MAYOR & COUNCIL 76,427 76,427 54,855 21,572 72% 50,445 (4,410) 41320.00 ADMINISTRATION 313,089 313,089 213,106 99,983 68% 203,352 (9,753) 41330.00 BOARDS & COMMISSIONS 10,550 10,550 3,983 6,567 38% 4,521 538 41400.00 CITY CLERK FUNCTIONS 130,660 130,660 90,459 40,201 69% 84,870 (5,589) 41410.00 ELECTIONS 112,832 112,832 44,840 67,992 40% 121 (44,719) 41520.00 FINANCE 704,542 704,542 477,678 226,864 68% 388,422 (89,255) 41820.00 HUMAN RESOURCES 316,502 316,502 215,246 101,256 68% 231,540 16,295 41830.00 COMMUNICATIONS 143,422 143,422 97,554 45,868 68% 91,634 (5,921) 41910.00 COMMUNITY DEVELOPMENT 348,850 348,850 167,565 181,285 48% 195,309 27,744 41920.00 INFORMATION TECHNOLOGY 256,283 256,283 178,284 77,999 70% 167,590 (10,695) 41940.00 FACILITIES - CITY HALL 101,693 101,693 66,874 34,819 66% 65,236 (1,638) Total - Function General Government 2,514,850 2,514,850 1,610,443 904,407 64% 1,483,040 (127,404) Function: Public Safety 42100.00 POLICE 6,238,856 6,238,856 4,158,295 2,080,561 67% 3,847,923 (310,372) 42200.00 FIRE 2,354,931 2,354,931 1,347,117 1,007,814 57% 653,618 (693,499) 42400.00 BUILDING INSPECTION 830,502 830,502 568,454 262,048 68% 557,752 (10,702) Total - Function Public Safety 9,424,289 9,424,289 6,073,866 3,350,423 64% 5,059,293 (1,014,572) Function: Public Works 43050.00 ENGINEERING 403,645 403,645 288,682 114,963 72% 266,824 (21,858) 43100.00 STREET 582,011 582,011 383,035 198,976 66% 378,809 (4,226) 43400.00 CENTRAL GARAGE 293,500 293,500 197,969 95,531 67% 190,695 (7,274) Total - Function Public Works 1,279,156 1,279,156 869,686 409,470 68% 836,327 (33,359) Function: Culture and Recreation 45100.00 RECREATION 444,525 444,525 292,948 151,577 66% 230,897 (62,051) 45200.00 PARKS 1,253,181 1,253,181 914,666 338,515 73% 863,269 (51,397) Total - Function Culture and Recreation 1,697,706 1,697,706 1,207,614 490,092 71% 1,094,166 (113,448) General Fund Payroll Only Expenditures Total 14,916,001 14,916,001 9,761,609 5,154,392 65% 8,472,826 (1,288,782) EDA FUND Function: Economic Development 46500.00 ECONOMIC DEVELOPMENT 163,834 163,834 86,092 77,742 53% 93,463 7,371 EDA Fund Payroll Only Expenditures Total 163,834 163,834 86,092 77,742 53% 93,463 7,371 COMPARATIVE City of Prior Lake Expenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/30/2023 Positive (Negative) COMPARATIVE WATER FUND Function: Water 41520.00 FINANCE 89,344 89,344 60,672 28,672 68% 57,680 (2,991) 49400.00 WATER 826,958 1,009,063 697,881 311,182 69% 656,569 (41,312) Water Fund Payroll Only Expenditures Total 916,302 1,098,407 758,553 339,855 69% 714,249 (44,303) SEWER FUND Function: Sewer 41520.00 FINANCE 89,344 89,344 60,662 28,682 68% 57,392 (3,270) 49450.00 SEWER 869,044 686,939 478,493 208,446 70% 465,242 (13,251) Sewer Fund Payroll Only Expenditures Total 958,388 776,283 539,155 237,128 69% 522,634 (16,521) STORM WATER FUND Function: Storm Water 49420.00 WATER QUALITY 370,250 370,250 176,889 193,361 48% 198,386 21,497 Storm Water Fund Payroll Only Expenditures Total 370,250 370,250 176,889 193,361 48% 198,386 21,497 City-Wide Total Payroll Expenditures 17,324,775 17,324,775 11,322,297 6,002,478 65% 10,001,559 (1,320,739) City of Prior Lake Debt Service Funds As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/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 - - 36,158 36,158 n/a 280,492 (244,334) 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 77,262 24,362 146% 71,884 5,377 Unrealized Inv.Gain(Loss) - - 67,289 67,289 n/a (752) 68,042 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 2,106,468 (2,756,095) 43% 2,457,934 (351,466) 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% 526,764 24,150 Transfers to Other Funds 45,000 - - - n/a - - Total Expenditures 5,218,943 5,173,943 648,243 4,525,700 13% 669,356 21,113 Net Change (311,380) (311,380) 1,458,225 1,788,579 COMPARATIVE City of Prior Lake Cable Fund As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/30/2023 Positive (Negative) Revenues Charges for Services 210-41340.00-34304.00 PEG Access Fees 17,100 17,100 7,074 (10,026) 41% 8,606 (1,532) Interest (losses) on investments 210-41340.00-36210.00 Interest Earnings - - 2,741 2,741 n/a 2,092 649 210-41340.00-36225.00 Unrealized Inv. Gain (Loss) - - 1,867 1,867 n/a 67 1,800 Total - Interest (losses) on investments - - 4,607 4,607 n/a 2,158 2,449 Total Revenues 17,100 17,100 11,681 (5,419) 68% 10,764 917 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 - Current Expenditures 6,000 6,000 3,576 2,424 60% 3,576 - Total Expenditures 6,000 6,000 3,576 2,424 60% 3,576 - Net Change 11,100 11,100 8,105 7,188 COMPARATIVE City of Prior Lake Capital Park Fund As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/30/2023 Positive (Negative) Revenues Charges for Services 225-45200.00-34760.01 Facility Rental - Regular - - 18,500 18,500 n/a 18,000 500 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) Total - Charges for Services 324,000 324,000 35,330 (288,670) 11% 116,937 (81,607) Intergovernmental 225-00000.00-33700.20 Miscellaneous - Capital Grants - - 6,445 6,445 n/a - 6,445 Total - Intergovernmental - - 6,445 6,445 n/a - 6,445 Interest (losses) on investments 225-00000.00-36210.00 Interest Earnings 30,600 30,600 43,401 12,801 142% 39,299 4,102 225-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 29,026 29,026 n/a 1,406 27,620 Total - Interest (losses) on investments 30,600 30,600 72,427 41,827 237% 40,705 31,722 Contributions and donations 225-00000.00-36230.00 Contributions & Donations - - 7,450 7,450 n/a 12,050 (4,600) Total - Contributions and donations - - 7,450 7,450 n/a 12,050 (4,600) Total Revenues 354,600 354,600 121,652 (232,948) 34% 169,692 (48,040) 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' - - 2,800 (2,800) n/a - (2,800) 225-45200.00-55050.00-PRK23-000001 Projects - Professional Services - - 53,226 (53,226) n/a - (53,226) 225-45200.00-55050.00-PRK24-000001 Projects - Professional Services - - 39,411 (39,411) n/a - (39,411) 225-45200.00-55050.00-TRN19-000004 Projects - Professional Services - - - - n/a 14,720 14,720 225-45200.00-55530.00 Infrastructure 300,000 300,000 265 299,735 0% 23,445 23,181 Total Expenditures 305,000 305,000 102,182 202,818 34% 43,037 (59,144) Net Change 49,600 49,600 19,470 126,655 COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/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 Total - 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 16,252 1,752 112% 18,733 (2,481) 410-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 12,998 12,998 n/a 1,100 11,898 Total - Interest (losses) on investments 14,500 14,500 29,250 14,750 202% 19,833 9,416 Sale of assets 410-00000.00-39102.00 Sale of Property - - 251,470 251,470 n/a 66,117 185,353 Total - Sale of assets - - 251,470 251,470 n/a 66,117 185,353 Transfers in 410-00000.00-39203.00 Transfer from Other Funds - 400,000 400,000 - 100% 163,125 236,875 Total - Transfers in - 400,000 400,000 - 100% 163,125 236,875 Total Revenues 814,500 1,214,500 1,088,282 (126,218) 90% 639,856 448,426 COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/30/2023 Positive (Negative) COMPARATIVE Expenditures Public Safety Police 410-42100.00-55550.00 Vehicles 330,000 370,000 94,087 275,913 25% 176,699 82,612 410-42100.00-55570.00 Machinery & Equipment - - - - n/a 44,315 44,315 Fire 410-42200.00-55550.00 Vehicles - 573,000 615,420 (42,420) 107% 74,085 (541,335) 410-42200.00-55570.00 Machinery & Equipment - - - - n/a 96,453 96,453 Building Inspection 410-42400.00-55550.00 Vehicles - 44,000 48,717 - 111% - (48,717) Emergency Management 410-42500.00-55570.00 Machinery & Equipment 93,200 93,200 46,120 - 49% - (46,120) Total Public Safety 423,200 1,080,200 804,343 233,494 74% 391,551 (412,792) 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% 37,492 6,868 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,846 (846) 103% - (25,846) Total Public Works 113,000 113,000 177,589 (65,047) 157% 37,492 (140,097) Culture and Recreation/Parks 410-45200.00-55550.00 Vehicles - 347,500 253,656 93,844 73% 100,051 (153,605) 410-45200.00-55570.00 Machinery and Equipment 328,000 328,000 283,402 44,598 86% 384,763 101,361 Total Culture & Recreation 328,000 675,500 537,058 138,442 80% 484,814 (52,244) Total Expenditures 864,200 1,868,700 1,518,991 306,889 81% 913,858 (605,133) Net Change (49,700) (654,200) (430,708) (274,002) City of Prior Lake Revolving Park Equipment Fund As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/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 Total - 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 430-45200.00-33700.20 Miscellaneous Grants - Capital Grants - - 29,949 29,949 n/a - 29,949 Total - Intergovernmental - - 299,485 299,485 n/a - 299,485 Interest (losses) on investments 430-00000.00-36210.00 Interest Earnings 25,100 25,100 22,001 (3,099) 88% 36,757 (14,756) 430-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 18,458 18,458 n/a 235 18,223 Total - Interest (losses) on investments 25,100 25,100 40,460 15,360 161% 36,993 3,467 Other 430-45200.00-36230.00 Contributions & Donations - - - - n/a 185,000 (185,000) Total - Other - - - - n/a 185,000 (185,000) Total Revenues 485,100 485,100 574,383 89,283 118% 451,525 122,859 Expenditures Culture and Recreation Dept 45200.00 - PARKS 430-45200.00-55020.00 Projects - Engineering - - 32,059 (32,059) n/a 64,424 32,365 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 18,464 46,536 28% 110,551 92,087 Total Culture & Recreation 65,000 65,000 61,803 25,757 95% 174,975 113,172 Total Expenditures 65,000 65,000 61,803 25,757 95% 174,975 113,172 Net Change 420,100 420,100 512,580 276,549 COMPARATIVE City of Prior Lake Facilities Management Fund As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/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 Total - 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 35,229 10,029 140% 32,221 3,009 440-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 24,125 24,125 n/a 1,057 23,069 Total - Interest (losses) on investments 25,200 25,200 59,355 34,155 236% 33,278 26,077 Miscellaneous Revenues 440-41940.00-36212.00 Miscellaneous Revenue - - 89,800 89,800 n/a - 89,800 Total - Miscellaneous Revenues - - 89,800 89,800 n/a - 89,800 Transfers in 440-00000.00-39203.00 Transfer from Other Funds 24,000 24,000 18,000 (6,000) 75% - 18,000 Total - Transfers in 24,000 24,000 18,000 (6,000) 75% - 18,000 Debt Issued 440-00000.00-39310.00 G.O. Bond Proceeds 1,100,000 1,100,000 - (1,100,000) 0% - - Total - Debt Issued 1,100,000 1,100,000 - (1,100,000) 0% - - Total Revenues 1,354,200 1,354,200 271,751 (1,082,449) 20% 113,902 157,849 Expenditures Function: General Government 41920.00-52200.02 Repair & Maint Supplies - Building-FACILITIES - CITY HAL - - 1,545 (1,545) n/a - (1,545) 41920.00-53100.80 Professional Services - General-FACILITIES - CITY HALL - - 8,294 (8,294) n/a - (8,294) 41920.00-54010.02 Maint Agreements - Buildings-FACILITIES - CITY HALL - - 41,400 (41,400) n/a - (41,400) 41940.00-55050.00 Projects Professional Svcs-FACILITIES - CITY HALL - - 48,285 (48,285) n/a 11,648 (36,637) 41940.00-55520.00 Building & Building Improvements-FACILITIES - CITY HAL 439,600 86,100 7,298 78,802 8% - (7,298) 41920.00-55570.00 Machinery and Equipment-INFORMATION TECHNOLOG - - 1,055 (1,055) n/a - (1,055) Total - Function General Government 439,600 86,100 107,876 (21,776) 125% 11,648 (96,228) Function: Public Safety 42100.00-55520.00 Building & Building Improvements-POLICE 81,000 188,000 17,964 170,036 10% - (17,964) 42200.00-55050.00 Projects-Professional Services-FIRE - - - - n/a 5,105 5,105 42200.00-55520.00 Building & Building Improvements-FIRE 178,600 170,500 42,534 127,966 25% 84,841 42,307 Total - Function Public Safety 259,600 358,500 60,498 298,002 17% 89,946 29,448 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 16,000 15,080 920 94% - (15,080) 45500.00 LIBRARIES 23,500 273,500 150,733 122,767 55% - (150,733) Total - Function Culture and Recreation 39,500 289,500 165,813 123,687 57% - (165,813) Total Expenditures 866,700 862,100 344,149 517,951 40% 101,594 (242,555) COMPARATIVE Net Change 487,500 492,100 (72,398) 12,308 City of Prior Lake Permanent Improvement Revolving Fund As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/30/2023 Positive (Negative) Revenues Taxes 450-00000.00-31810.00 Franchise Taxes 1,080,000 1,080,000 541,880 (538,120) 50% 541,241 639 Total - Taxes 1,080,000 1,080,000 541,880 (538,120) 50% 541,241 639 Special Assessments 450-00000.00-36101.00 City Assess. Collections - - 226,913 226,913 n/a 4,558 222,355 450-00000.00-36102.00 County Assess. Collection 580,666 580,666 21,196 (559,470) 4% 42,369 (21,173) Total - Special Assessments 580,666 580,666 248,109 (332,557) 43% 46,927 201,182 Interest (losses) on investments 450-00000.00-36210.00 Interest Earnings 18,300 18,300 40,460 22,160 221% 33,686 6,773 450-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 6,120 6,120 n/a (60) 6,179 Total - Interest (losses) on investments 18,300 18,300 46,579 28,279 255% 33,627 12,953 Transfers in 450-00000.00-39203.00 Transfer from Other Funds 1,850,000 - 615,441 615,441 n/a - 615,441 Total - 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,580,000 (116,200) 93% - 1,580,000 Total - Debt Issued 1,696,200 1,696,200 1,580,000 (116,200) 93% - 1,580,000 Other Financing Sources 450-43100.00-39315.00-PIR24-000001 Projects - Bond Premium - - 106,507 106,507 n/a - 106,507 Total - Other Financing Sources - - 106,507 106,507 n/a - 106,507 Total Revenues 5,225,166 3,375,166 3,138,515 (236,651) 93% 621,794 2,516,721 Expenditures Function: Public Works 450-43100.00-55010.00-PIR24-000001 Projects - Contract Vouchers - - 4,963,702 (4,963,702) n/a - (4,963,702) 450-43100.00-55020.00-PIR24-000001 Projects - Engineering - - 254,326 (254,326) n/a 50,901 (203,425) 450-43100.00-55050.00-PIR24-000001 Projects - Professional Services - - 262 (262) n/a - (262) 450-43100.00-55070.00 Projects - Bond Issuance Costs - - 46,531 (46,531) n/a - (46,531) 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 5,264,820 (11,834,820) 80% 50,901 (5,213,919) 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 Total - Transfers out 94,590 94,590 2,250 92,340 2% 6,475 (4,225) Total Expenditures 6,664,590 6,664,590 5,267,070 1,397,520 79% 57,376 (5,218,144) Net Change (1,439,424) (3,289,424) (2,128,555) 564,418 COMPARATIVE City of Prior Lake Water Fund As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/30/2023 Positive (Negative) Revenues Operating Revenue Water Charges 601-49400.00-37100.00 Utility Receipts - Water 4,042,024 4,042,024 1,535,418 (2,506,606) 38% 2,433,001 (897,582) 601-49400.00-37160.00 Penalties 20,000 20,000 5,804 (14,196) 29% 5,958 (154) Total - Water Charges 4,062,024 4,062,024 1,541,222 (2,520,802) 38% 2,438,958 (897,736) Utility Base Fee 601-49400.00-37110.00 Utility Base Fee Revenue 1,374,903 1,374,903 765,591 (609,312) 56% 726,635 38,956 Total - Utility Base Fee 1,374,903 1,374,903 765,591 (609,312) 56% 726,635 38,956 Meter Sales 601-49400.00-37170.00 Water Meter Sales 79,825 79,825 42,853 (36,972) 54% 44,884 (2,031) 601-49400.00-37175.00 Pressure Reducers 25,000 25,000 9,879 (15,121) 40% 11,522 (1,642) Total - Meter Sales 104,825 104,825 52,732 (52,093) 50% 56,406 (3,673) Total Operating Revenue 5,541,752 5,541,752 2,359,546 (3,182,206) 43% 3,221,999 (862,454) Non-Operating Revenue Intergovernmental 601-49400.00-33422.15 State Aids/Grants - Operating Public Wor - - 5,293 5,293 n/a 17 5,277 Total - Intergovernmental - - 5,293 5,293 n/a 17 5,277 Interest (losses) on investments 601-00000.00-36210.00 Interest Earnings 117,300 117,300 215,498 98,198 184% 155,681 59,817 601-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 145,001 145,001 n/a 3,123 141,877 Total - Interest (losses) on investments 117,300 117,300 360,499 243,199 307% 158,804 201,695 Miscellaneous Revenues 601-00000.00-36212.00 Miscellaneous Revenue - - 8,650 8,650 n/a 13,264 (4,614) 601-00000.00-36102.00 County Assess Collection - - 18,165 18,165 n/a 34,547 (16,382) Total - Miscellaneous Revenues - - 26,815 26,815 - 47,811 (20,996) Total Non-Operating Revenue 117,300 117,300 392,607 275,307 335% 206,632 185,975 Total Revenues 5,659,052 5,659,052 2,752,153 (2,906,899) 49% 3,428,631 (676,478) COMPARATIVE City of Prior Lake Water Fund As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/30/2023 Positive (Negative) COMPARATIVE Total Expenditures Personnel and current expenditures (excluding depreciation) 41520.00 Finance 124,805 124,805 84,941 39,864 68% 76,210 (8,732) 49400.00 Water 2,911,360 3,393,465 1,819,061 (1,574,404) 54% 2,199,387 380,327 Total - Personnel and current expenditures (excluding depreciation) 3,036,165 3,518,270 1,904,002 1,614,268 54% 2,275,597 371,595 Principal 601-49400.00-56010.00 Water 135,000 135,000 - 135,000 0% - - Total - Principal 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 Total - Interest & other 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 14,135 60,866 19% 59,118 44,983 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% - - Total - Capital improvements 185,500 185,500 80,026 105,474 43% 59,118 (20,908) 601-49400.00-55700.00 Contra Capital Outlay - - - - n/a (12,986) 12,986 Total Expenditures 3,391,315 3,873,420 1,999,812 1,873,608 2,339,993 366,153 Other Financing Sources Transfers in 601-00000.00-39203.00 Transfer from Other Funds - - 14,750 14,750 n/a - 14,750 Total - Transfers in - - 14,750 14,750 n/a - 14,750 Debt Issued 601-00000.00-39315.00 Projects - Bond Premium - - - - n/a 4,327 4,327 Total - Debt Issued - - - - 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 422,927 440,723 49% 1,034,065 611,138 Total - Transfers out 2,713,650 863,650 422,927 440,723 49% 1,034,065 611,138 Total Other Financing Uses 2,713,650 863,650 422,927 440,723 49% 1,034,065 611,138 Total Revenues/Other Financing Sources 5,659,052 5,659,052 2,766,903 (2,892,149) 49% 3,432,958 (657,401) Total Expenditures/Other Financing Uses 6,104,965 4,737,070 2,422,739 2,314,331 51% 3,374,058 977,290 Net Change (445,913) 921,982 344,163 (577,818) 58,901 (1,634,691) City of Prior Lake Sewer Fund As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/30/2023 Positive (Negative) Revenues Operating Revenue Sewer Charges 604-49450.00-37102.00 Utility Receipts - Sewer 2,023,789 2,023,789 767,653 (1,256,136) 38% 719,667 47,986 604-49450.00-37104.00 Utility Recpt-Sewer MCES 2,106,431 2,106,431 1,214,289 (892,142) 58% 1,167,463 46,825 604-49450.00-37160.00 Penalties - - 3,794 3,794 n/a 3,509 285 Total - Sewer Charges 4,130,220 4,130,220 1,985,735 (2,144,485) 48% 1,890,639 95,096 Capital Facility charges 604-49450.00-37110.00 Utility Base Fee Revenue 1,195,743 1,195,743 663,434 (532,309) 55% 630,650 32,783 Total - Capital Facility charges 1,195,743 1,195,743 663,434 (532,309) 55% 630,650 32,783 Total Operating Revenue 5,325,963 5,325,963 2,649,169 (2,676,794) 50% 2,521,289 127,879 Non-Operating Revenue Intergovernmental 604-49450.00-33630.20 Metro Council Grants - Capital - - - - n/a 61,715 (61,715) Total - Intergovernmental - - - - n/a 61,715 (61,715) Interest (losses) on investments 604-00000.00-36210.00 Interest Earnings 70,000 70,000 107,639 37,639 154% 92,074 15,564 604-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 72,311 72,311 n/a 916 71,395 Total - Interest (losses) on investments 70,000 70,000 179,950 109,950 257% 92,991 86,959 Miscellaneous Revenues 604-00000.00-36102.00 County Assess. Collections - - 18,165 18,165 n/a - 18,165 Total - Miscellaneous Revenues - - 18,165 18,165 n/a - 18,165 Total Non-Operating Revenue 70,000 70,000 198,115 128,115 283% 154,706 43,409 Total Revenue 5,395,963 5,395,963 2,847,283 (2,548,680) 53% 2,675,995 171,288 COMPARATIVE City of Prior Lake Sewer Fund As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/30/2023 Positive (Negative) COMPARATIVE Expenditures Personnel and current expenditures (excluding depreciation) 41520.00 Finance 124,440 124,440 84,901 39,539 68% 75,892 (9,008) 49450.00 Sewer 3,439,711 3,351,606 2,359,321 992,285 70% 2,100,205 (259,115) Total - Personnel and current expenditures (excluding depreciation) 3,564,151 3,476,046 2,444,221 1,031,825 70% 2,176,097 (268,124) Principal 604-49450.00-56010.00 Sewer 135,000 135,000 - 135,000 0% - - Total - Principal 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 Total - Interest & other 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 55,009 1,444,991 4% 12,978 (42,031) 604-49450.00-55570.00 Machinery and equipment 440,000 440,000 31,765 408,235 7% 175,042 143,277 Total - Capital improvements 1,940,000 1,940,000 86,774 1,853,226 4% 188,020 101,246 Total Expenditures 5,673,801 5,585,696 2,546,780 3,038,916 2,382,382 (164,398) Other Financing Sources Debt Issued 604-00000.00-39315.00 Projects - Bond Premium - - - - n/a 4,327 4,327 Total - Debt Issued - - - - 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 Total - Transfers in - - 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 656,568 (409,568) 266% 662,141 5,573 Total Other Financing Uses 247,000 247,000 656,568 (409,568) 266% 662,141 5,573 Total Revenues/Other Financing Sources 5,395,963 5,395,963 2,898,691 (2,497,272) 54% 2,680,322 227,024 Total Expenditures/Other Financing Uses 5,920,801 5,832,696 3,203,348 2,629,348 55% 3,044,523 (158,826) Net Change (524,838) (436,733) (304,657) 132,076 (364,200) 385,849 City of Prior Lake Water Quality Fund As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/30/2023 Positive (Negative) Revenues Operating Revenue Storm Water Charges 602-49420.00-37120.00 Storm Water Revenue 1,510,793 1,510,793 876,602 (634,191) 58% 773,413 103,188 602-49420.00-32250.00 Wetland Application Fee - - - - n/a 150 (150) Total - Storm Water Charges 1,510,793 1,510,793 876,602 (634,191) 58% 773,563 103,038 Water Charges 602-49420.00-37160.00 Penalties 4,000 4,000 1,115 (2,885) 28% 984 131 Total - Water Charges 4,000 4,000 1,115 (2,885) 28% 984 131 Total Operating Revenue 1,514,793 1,514,793 877,717 (637,076) 58% 774,548 103,169 Non-Operating Revenue Interest (losses) on investments 602-00000.00-36210.00 Interest Earnings 41,100 41,100 79,681 38,581 194% 55,522 24,159 602-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 61,124 61,124 n/a 224 60,900 Total - Interest (losses) on investments 41,100 41,100 140,806 99,706 343% 55,746 85,059 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 - - 38,000 (38,000) n/a - (38,000) Total - Miscellaneous Revenues - - 38,000 (38,000) n/a 17,414 (55,414) Total Non-Operating Revenue 41,100 41,100 178,806 61,706 435% 73,160 29,645 Total Revenues 1,555,893 1,555,893 1,056,523 (575,370) 68% 847,708 132,815 COMPARATIVE City of Prior Lake Water Quality Fund As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/30/2023 Positive (Negative) COMPARATIVE Expenditures Personnel and current expenditures (excluding depreciation) 49420.00 Water Quality 674,800 674,800 330,159 344,641 49% 315,391 (14,768) Total - Personnel and current expenditures (excluding depreciation) 674,800 674,800 330,159 344,641 49% 315,391 (14,768) Depreciation 49400.00 Water Quality - - - - n/a 594 594 Total - Depreciation - - - - n/a 594 594 Capital improvements 602-49420.00-55050.00 Projects - Professional Services - - 46,212 (46,212) n/a 13,439 602-49420.00-55530.00 Infrastructure 1,708,000 1,708,000 219,891 1,488,109 13% 109,808 (110,083) Total - Capital improvements 1,708,000 1,708,000 266,103 1,441,897 16% 123,247 (110,083) Total Expenditures 2,382,800 2,382,800 596,262 1,786,538 25% 439,232 (124,257) Other Financing Sources Debt Issued 602-49420.00-39310.00-STM23-000001 G.O. Bond Proceeds - - 507,400 507,400 n/a - 507,400 602-49420.00-39310.00-STM24-000001 G.O. Bond Proceeds - - 672,600 672,600 n/a - 672,600 Total - Debt Issued - - 1,180,000 1,180,000 n/a - 1,180,000 Other Financing Sources 602-49420.00-39315.00-STM23-000001 Projects - Bond Premium - - 26,231 26,231 n/a - 26,231 602-49420.00-39315.00-STM24-000001 Projects - Bond Premium - - 34,771 34,771 n/a - 34,771 Total - Other Financing Sources - - 61,001 61,001 n/a - 61,001 Transfers in 602-00000.00-39203.00 Transfer from Other Funds - - 2,395 2,395 n/a - 2,395 Total - Transfers in - - 2,395 2,395 n/a - 2,395 Total Other Financing Sources - - 1,243,396 1,243,396 n/a - 1,243,396 Other Financing Uses 602-49420.00-56300.00 Other Debt Service Expenses - - 34,751 34,751 n/a - 34,751 602-80000.00-59203.00 Transfers to other funds 113,300 113,300 409,481 (296,181) 361% 82,500 (326,981) Total Other Financing Uses 113,300 113,300 444,232 (261,430) 392% 82,500 (292,230) Total Revenues/Other Financing Sources 1,555,893 1,555,893 2,299,919 668,026 148% 847,708 1,376,211 Total Expenditures/Other Financing Uses 2,496,100 2,496,100 1,040,494 1,525,108 42% 521,732 (416,487) Net Change (940,207) (940,207) 1,259,425 2,193,134 325,976 959,724 City of Prior Lake Economic Development Authority Special Revenue Fund As of 9/30/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative) USED 9/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) Total - 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 23,369 (1,219) 95% 18,441 4,928 Total - Charges for Services 24,588 24,588 23,369 (1,219) 95% 18,441 4,928 Interest (losses) on investments 240-00000.00-36210.00 Interest Earnings 3,700 3,700 9,495 5,795 257% 7,442 2,053 240-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 7,657 7,657 n/a (6) 7,663 Total - Interest (losses) on investments 3,700 3,700 17,152 13,452 464% 7,436 (9,717) Total Revenues 418,288 418,288 237,971 (180,317) 57% 219,204 18,767 Expenditures Function: Economic Development 46500.00 ECONOMIC DEVELOPMENT 649,834 649,834 359,994 289,840 55% 132,224 (227,770) Total Expenditures 649,834 649,834 359,994 289,840 55% 132,224 (227,770) Net Change (231,546) (231,546) (122,022) 86,980 COMPARATIVE