Loading...
HomeMy WebLinkAbout05(C) - Approval of Preliminary 1st Quarter 2024 Financial Reports Report City of Prior Lake General Fund Summary - Comparison to Prior Year As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive (Negative)USED 3/31/2023 Positive (Negative) Revenues Taxes 14,047,266 14,047,266 - (14,047,266) 0%- - Licenses and Permits 617,238 617,238 313,463 (303,775) 51%100,892 212,571 Intergovernmental 3,348,632 3,348,632 1,029,594 (2,319,038) 31%902,296 127,298 Charges for Services 1,887,267 1,887,267 540,381 (1,346,886) 29%439,088 101,292 Fines and Forfeitures - - 20,505 20,505 n/a 557 19,948 Interest (losses) on investments 160,000 160,000 97,059 (62,941) 61%110,471 (13,412) Other 133,800 133,800 39,002 (94,798) 29%23,755 15,246 Transfers in 852,400 852,400 166,325 (686,075) 20%138,750 27,575 Total Revenues 21,046,603 21,046,603 2,206,328 (18,840,275) 10%1,715,809 490,519 Expenditures General Government 4,495,927 4,513,350 819,137 3,694,213 18%754,368 (64,769) Public Safety 10,828,082 10,911,499 1,955,269 8,956,230 18%1,661,536 (293,732) Public Works 2,847,321 2,937,321 478,090 2,459,231 16%515,438 37,348 Culture and Recreation 2,626,785 2,666,785 436,598 2,230,187 16%372,606 (63,992) Transfer to other funds 248,488 248,488 - 248,488 0%400,000 400,000 Total Expenditures 21,046,603 21,277,443 3,689,095 17,588,348 17%3,703,949 14,854 Net Change - (230,840) (1,482,767) (1,251,927) (1,988,140) COMPARATIVE City of Prior Lake General Fund Revenues As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Taxes 101 31010.00 Current Property Taxes - General Purpos 13,029,707 13,029,707 - (13,029,707) 0%- - 101 31020.00 Delinquent Property Taxes - General Purp - - - - n/a - - 101 31040.00 Fiscal Disparities 1,017,559 1,017,559 - (1,017,559) 0%- - Taxes 14,047,266 14,047,266 - (14,047,266) 0%- - 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 75 (80,395) 0%2,014 (1,939) 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%- - 101 32175.00 Public Private Gathering Permit - - 60 60 n/a 90 (30) 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%1,980 (50) 101 32210.00 Building Permits 376,822 376,822 237,403 (139,419) 63%72,893 164,509 101 32215.00 Mechanical Permits 79,548 79,548 31,604 (47,945) 40%9,786 21,818 101 32230.00 Plumbing Permits 56,702 56,702 31,425 (25,278) 55%8,976 22,449 101 32231.00 Sewer/Water Inspection 4,916 4,916 818 (4,099) 17%763 55 101 32260.00 Burning Permits 4,000 4,000 1,400 3,000 35%840 560 101 32270.00 Short-term Rental Fee 1,435 1,435 455 (980) 32%205 250 Licenses and Permits 617,238 617,238 313,463 (303,775) 51%100,892 212,571 Intergovernmental 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%- - 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 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 - (69,775) 0%- - 101 33631.00 Payment in Lieu of Taxes 1,200,000 1,200,000 300,000 (900,000) 25%300,000 - 101 33700.23 Miscellaneous Grants - Capital Parks - - 2,834 2,834 n/a - 2,834 Intergovernmental 3,348,632 3,348,632 1,029,594 (2,319,038) 31%902,296 127,298 COMPARATIVE City of Prior Lake General Fund Revenues As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) COMPARATIVE Charges for Services 101 31810.00 Franchise Taxes 559,000 559,000 - (559,000) 0%- - 101 34103.00 Zoning & Subdivision Fees 40,000 40,000 2,400 (37,600) 6%2,955 (555) 101 34104.00 Plan Check Fees 244,941 244,941 140,714 (104,227) 57%37,780 102,933 101 34105.00 Sale of Maps/Publications - Reports 500 500 10 (490) 2%20 (10) 101 34107.00 Assessment Searches - Reports 500 500 150 (350) 30%100 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 60,056 (185,944) 24%54,071 5,985 101 34203.00 Accident/Warrant Reports - Reports 200 200 50 (150) 25%317 (267) 101 34731.00 Adult League Fees 5,000 5,000 4,624 (376) 92%8,165 (3,541) 101 34732.00 Recreation Program Fees - Contracted 35,000 35,000 29,799 (5,201) 85%- 29,799 101 34735.00 Recreation Program Fees - Staff Run 65,000 65,000 64,406 (594) 99%70,076 (5,670) 101 34735.01 Recreation Program Fees - Club Prior 12,000 12,000 4,063 (7,937) 34%1,216 2,847 101 34760.01 Facility Rental - Regular 48,028 48,028 15,968 (32,060) 33%18,377 (2,409) 101 34760.87 Facility Rental - Lease 15,600 15,600 - (15,600) 0%- - 101 34761.00 Studio/Pavilion Rental 25,000 25,000 17,839 (7,161) 71%22,370 (4,531) 101 34762.00 Park Shelter Rental 20,000 20,000 4,182 (15,818) 21%66,669 (62,488) 101 34762.01 Boat Slip Rental 71,200 71,200 73,600 2,400 103%- 73,600 101 34765.01 Tower Leases - - 97,018 97,018 n/a 127,986 (30,967) 101 34765.87 Tower Leases - Lease 260,082 260,082 - (260,082) 0%- - 101 34780.00 Park Admission Fees 30,000 30,000 - (30,000) 0% - - 101 34783.00 City Contract Services 209,216 209,216 25,501 (183,715) 12%24,236 1,265 Charges for Services 1,887,267 1,887,267 540,381 (1,346,886) 29%439,088 101,292 Fines and Forfeitures 101 35101.00 County Court Fines - - 19,311 19,311 n/a - 19,311 101 35104.00 Prosecution Restitution - - 1,194 1,194 n/a 557 637 Fines and Forfeitures - - 20,505 20,505 n/a 557 19,948 Interest (losses) on investments 101 36210.00 Interest Earnings 180,000 180,000 94,008 (85,992) 52%72,756 21,252 101 36215.00 Amortization - Premium/Discount (20,000) (20,000) (12,219) 7,781 61%(6,156) (6,063) 101 36225.00 Unrealized Inv.Gain(Loss)- - 15,269 15,269 n/a 43,870 (28,601) Interest (losses) on investments 160,000 160,000 97,059 (62,941) 61%110,471 (13,412) Other Miscellaneous Revenues 101 36102.00 County Assess. Collection 4,000 4,000 - (4,000) 0%- - 101 36211.00 Developer Agreements 60,000 60,000 5,000 (55,000) 8%- 5,000 101 36212.00 Miscellaneous Revenue 69,800 69,800 22,037 (47,763) 32%20,789 1,248 101 36230.00 Contributions & Donations - - 70 70 n/a - 70 101 36230.11 Contributions - Shop with a Cop - - 250 250 n/a - 250 101 36230.13 Contributions and Donations - - 8,296 8,296 n/a 2,443 5,853 101 36230.33 Contributions - Charitable Gambling - - 2,000 2,000 n/a - 2,000 101 39102.00 Sale of Property - - 1,349 1,349 n/a 523 825 Other Miscellaneous Revenues 133,800 133,800 39,002 (94,798) 29%23,755 15,246 City of Prior Lake General Fund Revenues As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) COMPARATIVE Other financing sources 101 39203.00 Transfer from Other Funds 852,400 852,400 166,325 (686,075) 20%138,750 27,575 Other financing sources 852,400 852,400 166,325 (686,075) 20%138,750 27,575 Total Revenues 21,046,603 21,046,603 2,206,328 (18,840,275) 10%1,715,809 490,519 City of Prior Lake General Fund Expenditures As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Function: General Government 41110.00 MAYOR & COUNCIL 83,227 83,227 19,629 63,598 24% 17,719 (1,910) 41130.00 ORDINANCE 5,000 5,000 463 4,537 9% 718 254 41320.00 ADMINISTRATION 393,124 393,124 98,891 294,233 25% 100,700 1,810 41330.00 BOARDS & COMMISSIONS 10,950 10,950 646 10,304 6% 1,184 538 41400.00 CITY CLERK 133,989 137,989 26,023 111,966 19% 25,161 (862) 41410.00 ELECTIONS 126,332 126,332 27,877 98,455 22% 457 (27,420) 41520.00 FINANCE 737,612 743,612 150,557 593,055 20% 119,514 (31,044) 41540.00 INTERNAL AUDITING 44,700 44,700 3,500 41,200 8% 4,500 1,000 41550.00 ASSESSING 258,575 258,575 755 257,820 0% - (755) 41610.00 LEGAL 267,214 267,214 39,957 227,257 15% 40,335 377 41820.00 HUMAN RESOURCES 364,352 364,352 68,686 295,666 19% 69,436 750 41830.00 COMMUNICATIONS 165,172 165,172 33,600 131,572 20% 32,875 (725) 41910.00 COMMUNITY DEVELOPMENT 397,650 397,650 48,276 349,374 12% 63,918 15,642 41920.00 INFORMATION TECHNOLOGY 605,413 612,836 146,313 466,523 24% 138,433 (7,880) 41940.00 FACILITIES - CITY HALL 902,617 902,617 153,963 748,654 17% 139,419 (14,545) Total - Function General Government 4,495,927 4,513,350 819,137 3,694,213 18% 754,368 (64,769) Function: Public Safety 42100.00 POLICE 7,165,532 7,228,932 1,317,087 5,911,845 18% 1,250,575 (66,512) 42200.00 FIRE 2,749,058 2,769,075 471,217 2,297,858 17% 242,262 (228,954) 42400.00 BUILDING INSPECTION 862,152 862,152 161,995 700,157 19% 162,967 971 42500.00 EMERGENCY MANAGEMENT 15,340 15,340 169 15,171 1% 932 763 42700.00 ANIMAL CONTROL 36,000 36,000 4,800 31,200 13% 4,800 - Total - Function Public Safety 10,828,082 10,911,499 1,955,269 8,956,230 18% 1,661,536 (293,732) Function: Public Works 43050.00 ENGINEERING 471,965 471,965 91,352 380,613 19% 74,675 (16,677) 43100.00 STREET 1,776,306 1,866,306 257,153 1,609,153 14% 321,155 64,002 43400.00 CENTRAL GARAGE 599,050 599,050 127,907 471,143 21% 119,234 (8,672) 43600.00 DEVELOPMENT PROJECTS - - 1,678 (1,678) n/a 374 (1,304) Total - Function Public Works 2,847,321 2,937,321 478,090 2,459,231 16% 515,438 37,348 Function: Culture and Recreation 45100.00 RECREATION 627,505 627,505 104,098 523,407 17% 79,718 (24,380) 45200.00 PARKS 1,966,606 2,006,606 326,226 1,680,380 16% 275,675 (50,551) 45500.00 LIBRARIES 32,674 32,674 6,274 26,400 19% 17,213 10,939 Total - Function Culture and Recreation 2,626,785 2,666,785 436,598 2,230,187 16% 372,606 (63,992) 80000.00 Transfer to Other Funds 248,488 248,488 - 248,488 0% 400,000 400,000 Total Expenditures 21,046,603 21,277,443 3,689,095 17,588,348 17%3,703,949 14,854 COMPARATIVE City of Prior Lake Expenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) GENERAL FUND Function: General Government 41110.00 MAYOR & COUNCIL 76,427 76,427 18,337 58,090 24% 15,766 (2,571) 41320.00 ADMINISTRATION 313,089 313,089 60,949 252,140 19% 58,466 (2,483) 41330.00 BOARDS & COMMISSIONS 10,550 10,550 646 9,904 6% 1,184 538 41400.00 CITY CLERK FUNCTIONS 130,660 130,660 25,456 105,204 19% 23,792 (1,664) 41410.00 ELECTIONS 112,832 112,832 23,658 89,174 21% - (23,658) 41520.00 FINANCE 704,542 704,542 135,205 569,337 19% 108,007 (27,197) 41820.00 HUMAN RESOURCES 316,502 316,502 60,629 255,873 19% 59,533 (1,096) 41830.00 COMMUNICATIONS 143,422 143,422 27,546 115,876 19% 25,849 (1,697) 41910.00 COMMUNITY DEVELOPMENT 348,850 348,850 46,766 302,084 13% 63,019 16,253 41920.00 INFORMATION TECHNOLOGY 256,283 256,283 50,332 205,951 20% 47,220 (3,112) 41940.00 FACILITIES - CITY HALL 101,693 101,693 20,311 81,382 20% 21,290 979 Total - Function General Government 2,514,850 2,514,850 469,836 2,045,014 19% 424,125 (45,710) Function: Public Safety 42100.00 POLICE 6,238,856 6,238,856 1,156,776 5,082,080 19% 1,069,893 (86,883) 42200.00 FIRE 2,354,931 2,354,931 381,621 1,973,310 16% 118,233 (263,388) 42400.00 BUILDING INSPECTION 830,502 830,502 156,224 674,278 19% 157,964 1,739 Total - Function Public Safety 9,424,289 9,424,289 1,694,622 7,729,667 18% 1,346,090 (348,532) Function: Public Works 43050.00 ENGINEERING 403,645 403,645 75,589 328,056 19% 70,853 (4,736) 43100.00 STREET 582,011 582,011 109,632 472,379 19% 117,968 8,337 43400.00 CENTRAL GARAGE 293,500 293,500 57,796 235,704 20% 57,618 (177) Total - Function Public Works 1,279,156 1,279,156 243,016 1,036,140 19% 246,440 3,424 Function: Culture and Recreation 45100.00 RECREATION 444,525 444,525 52,473 392,052 12% 47,477 (4,996) 45200.00 PARKS 1,253,181 1,253,181 208,572 1,044,609 17% 216,441 7,869 Total - Function Culture and Recreation 1,697,706 1,697,706 261,045 1,436,661 15% 263,918 2,873 General Fund Payroll Only Expenditures Total 14,916,001 14,916,001 2,668,519 12,247,482 18%2,280,573 (387,945) EDA FUND Function: Economic Development 46500.00 ECONOMIC DEVELOPMENT 163,834 163,834 24,067 139,767 15% 28,843 4,775 EDA Fund Payroll Only Expenditures Total 163,834 163,834 24,067 139,767 15%28,843 4,775 COMPARATIVE City of Prior Lake Expenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) COMPARATIVE WATER FUND Function: Water 41520.00 FINANCE 89,344 89,344 17,311 72,033 19% 16,536 (774) 49400.00 WATER 826,958 826,958 189,120 637,838 23% 202,356 13,236 Water Fund Payroll Only Expenditures Total 916,302 916,302 206,431 709,871 23%218,892 12,462 SEWER FUND Function: Sewer 41520.00 FINANCE 89,344 89,344 17,308 72,036 19% 16,533 (775) 49450.00 SEWER 869,044 869,044 139,550 729,494 16% 144,150 4,600 Sewer Fund Payroll Only Expenditures Total 958,388 958,388 156,857 801,531 16%160,682 3,825 STORM WATER FUND Function: Storm Water 49420.00 WATER QUALITY 370,250 370,250 47,125 323,125 13% 70,164 23,039 Storm Water Fund Payroll Only Expenditures Total 370,250 370,250 47,125 323,125 13%70,164 23,039 City-Wide Total Payroll Expenditures 17,324,775 17,324,775 3,102,999 14,221,776 18% 2,759,154 (343,844) City of Prior Lake Debt Service Funds As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Property Taxes Current Property Taxes 3,203,024 3,203,024 - (3,203,024) 0% - - Special Assessments City Assess. Collections - - 8,683 8,683 n/a 3,202 5,481 County Assess. Collection 640,649 640,649 - (640,649) 0% - - Interest (losses) on investments Interest Earnings 52,900 52,900 20,561 (32,339) 39% 16,743 3,818 Unrealized Inv.Gain(Loss) - - 2,214 2,214 n/a 10,343 (8,130) Other Financing Sources Transfer from Other Funds 1,010,990 1,010,990 - (1,010,990) 0% - - Total Revenues 4,907,563 4,907,563 31,457 (4,876,106) 1%30,288 1,169 Expenditures Debt Service Principal 4,202,801 4,202,801 - 4,202,801 0% - - Interest and Other 971,142 971,142 - 971,142 0% 4,500 4,500 Transfers to Other Funds 45,000 45,000 - 45,000 0% - - Total Expenditures 5,218,943 5,218,943 - 5,218,943 0%4,500 4,500 Net Change (311,380) (311,380) 31,457 25,788 COMPARATIVE City of Prior Lake Cable Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Charges for Services 210-41340.00-34304.00 PEG Access Fees 17,100 17,100 - (17,100) 0% - - Interest (losses) on investments 210-41340.00-36210.00 Interest Earnings - - 906 906 n/a 632 274 210-41340.00-36225.00 Unrealized Inv. Gain (Loss) - - 99 99 n/a 391 (291) Total Revenues 17,100 17,100 1,005 (16,095) 6%1,022 (18) 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 (2,571) (2,554) COMPARATIVE City of Prior Lake Capital Park Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Charges for Services 225-45200.00-34760.01 Facility Rental - Regular - - 6,000 6,000 n/a 6,000 - 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 - (300,000) 0% 90,540 (90,540) Charges for Services 324,000 324,000 6,000 (318,000) 2% 96,540 (90,540) Interest (losses) on investments 225-00000.00-36210.00 Interest Earnings 30,600 30,600 14,519 (16,081) 47% 12,180 2,339 225-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 1,580 1,580 n/a 7,531 (5,950) Interest (losses) on investments 30,600 30,600 16,099 (14,501) 53% 19,711 (3,611) Contributions and donations 225-00000.00-36230.00 Contributions & Donations - - 2,300 2,300 n/a - 2,300 Contributions and donations - - 2,300 2,300 n/a - 2,300 Total Revenues 354,600 354,600 24,399 (330,201) 7%116,251 (91,851) Expenditures 225-45200.00-53100.80 Professional Services-General 5,000 5,000 5,000 - 100% 4,872 (128) 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-TRN19-000004 Projects - Professional Services - - 9,255 (9,255) n/a 992 (8,263) 225-45200.00-55530.00 Infrastructure 300,000 300,000 - 300,000 0% 4,642 4,642 Total Expenditures 305,000 305,000 17,055 287,945 6%10,507 (6,548) Net Change 49,600 49,600 7,344 105,744 COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Taxes 410-00000.00-31010.00 Current Property Taxes 800,000 800,000 - (800,000) 0%- - Taxes 800,000 800,000 - (800,000) 0%- - Interest (losses) on investments 410-00000.00-36210.00 Interest Earnings 14,500 14,500 6,859 (7,641) 47%6,142 717 410-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 1,662 1,662 n/a 3,655 (1,994) Interest (losses) on investments 14,500 14,500 8,521 (5,979) 59%9,798 (1,277) Sale of assets 410-00000.00-39102.00 Sale of Property - - 36,290 36,290 n/a - 36,290 Sale of assets - - 36,290 36,290 n/a - 36,290 Transfers in 410-00000.00-39203.00 Transfer from Other Funds - - 400,000 400,000 n/a 54,375 345,625 Transfers in - - 400,000 400,000 n/a 54,375 345,625 Total Revenues 814,500 814,500 444,811 (369,689) 55%64,173 380,638 COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) COMPARATIVE Public Safety Police 410-42100.00-55550.00 Vehicles 330,000 543,000 19,990 523,010 4%175,499 155,509 Fire 410-42200.00-55550.00 Vehicles - - 547,464 (547,464) n/a 20,373 (527,092) 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 680,200 567,454 (24,454) 83%195,872 (371,583) Public Works Street 410-43100.00-55550.00 Vehicles - - 66,544 (66,544) n/a - (66,544) 410-43100.00-55570.00 Machinery & Equipment 38,000 38,000 30,625 7,375 81%17,721 (12,904) Engineering 410-43050.00-55550.00 Vehicles 50,000 50,000 - - 0%- - Central Garage 410-43400.00-55550.00 Vehicles 25,000 25,000 - 25,000 0%- - Total Public Works 113,000 113,000 97,169 (34,169) 86%17,721 (79,448) Culture and Recreation/Parks 410-45200.00-55550.00 Vehicles - 347,500 140,574 206,926 40%797 (139,777) 410-45200.00-55570.00 Machinery and Equipment 328,000 328,000 96,603 231,397 29%235,759 139,156 Total Culture & Recreation 328,000 675,500 237,177 438,323 35%236,556 (621) Sewer 410-49450.00-55570.00 Machinery and Equipment - - - - n/a 1,615 1,615 Total Utility - - - - n/a 1,615 1,615 Total Expenditures 864,200 1,468,700 901,801 379,699 61%451,764 (450,037) Net Change (49,700) (654,200) (456,990) (387,591) City of Prior Lake Revolving Park Equipment Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Taxes 430-00000.00-31010.00 Current Property Taxes 460,000 460,000 - (460,000) 0%- - Taxes 460,000 460,000 - (460,000) 0%- - Interest (losses) on investments 430-00000.00-36210.00 Interest Earnings 25,100 25,100 5,096 (20,004) 20%10,146 (5,050) 430-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 563 563 n/a 6,218 (5,655) Interest (losses) on investments 25,100 25,100 5,659 (19,441) 23%16,365 (10,705) Total Revenues 485,100 485,100 5,659 (479,441) 1%16,365 (10,705) Expenditures Culture and Recreation Dept 45200.00 - PARKS 430-45200.00-55020.00 Projects - Engineering - - - - n/a 42,750 42,750 430-45200.00-55530.00 Infrastructure 65,000 65,000 5,000 60,000 8%- (5,000) Total Culture & Recreation 65,000 65,000 5,000 60,000 8%42,750 37,750 Total Expenditures 65,000 65,000 5,000 60,000 8%42,750 37,750 Net Change 420,100 420,100 659 (26,385) COMPARATIVE City of Prior Lake Facilities Management Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Taxes 440-00000.00-31010.00 Current Property Taxes 205,000 205,000 - (205,000) 0% - - Taxes 205,000 205,000 - (205,000) 0% - - Interest (losses) on investments 440-00000.00-36210.00 Interest Earnings 25,200 25,200 11,762 (13,438) 47% 9,874 1,887 440-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 1,539 1,539 n/a 6,147 (4,608) Interest (losses) on investments 25,200 25,200 13,301 (11,899) 53% 16,022 (2,721) Transfers in 440-00000.00-39203.00 Transfer from Other Funds 24,000 24,000 6,000 (18,000) 25% - 6,000 Transfers in 24,000 24,000 6,000 (18,000) 25% - 6,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 19,301 (1,334,899) 1%16,022 3,279 Expenditures Function: General Government 41940-55050.00 Projects Professional Svcs- FACILITIES - CITY HALL - - 15,176 (15,176) n/a 11,648 (3,528) 41940-55520.00 Building & Building Improvements-FACILITIES - CITY HALL 439,600 439,600 7,298 432,302 2% - (7,298) Total - Function General Government 439,600 439,600 22,474 417,126 5% 11,648 (10,826) Function: Public Safety 42100-55520.00 Building & Building Improvements-POLICE 81,000 181,000 17,964 163,036 10% - (17,964) 42200-55520.00 Building & Building Improvements-FIRE 178,600 178,600 6,090 172,510 3% 20,244 14,154 Total - Function Public Safety 259,600 359,600 24,054 335,546 7% 20,244 (3,810) Function: Public Works 43400.00 CENTRAL GARAGE 128,000 128,000 5,804 122,196 5% - (5,804) Total - Function Public Works 128,000 128,000 5,804 122,196 5% - (5,804) Function: Culture and Recreation 45200.00 PARKS 16,000 141,000 15,080 125,920 11% - (15,080) 45500.00 LIBRARIES 23,500 23,500 6,403 17,097 27% - (6,403) Total - Function Culture and Recreation 39,500 164,500 21,483 143,017 13% - (21,483) Total Expenditures 866,700 1,091,700 73,814 1,017,886 7%31,892 (41,923) Net Change 487,500 262,500 (54,514) (15,870) COMPARATIVE City of Prior Lake Permanent Improvement Revolving Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Taxes 450-00000.00-31810.00 Franchise Taxes 1,080,000 1,080,000 - (1,080,000) 0%- - Taxes 1,080,000 1,080,000 - (1,080,000) 0%- - Special Assessments 450-00000.00-36101.00 City Assess. Collections - - 258 258 n/a 253 5 450-00000.00-36102.00 County Assess. Collection 580,666 580,666 - (580,666) 0%- - 580,666 580,666 258 (580,408) 0%253 5 Interest (losses) on investments 450-00000.00-36210.00 Interest Earnings 18,300 18,300 16,301 (1,999) 89%8,518 7,783 450-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 1,326 1,326 n/a 5,266 (3,940) Interest (losses) on investments 18,300 18,300 17,627 (673) 96%13,784 3,843 Transfers in 450-00000.00-39203.00 Transfer from Other Funds 1,850,000 1,850,000 - (1,850,000) 0%- - Transfers in 1,850,000 1,850,000 - (1,850,000) 0%- - 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 5,225,166 17,885 (5,207,281) 0%14,037 3,848 Expenditures Function: Public Works 450-43100.00-55020.00-PIR24-000001 Projects - Engineering - - 61,733 (61,733) n/a 1,147 (60,586) 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 61,995 (6,631,995) 1%1,147 (60,848) OTHER FINANCING USES Transfers out 450-80000.00-59203.00 Transfers to Other Funds 94,590 94,590 - 94,590 0%- - Total Expenditures 6,664,590 6,664,590 61,995 6,602,595 1%1,147 (60,848) Net Change (1,439,424) (1,439,424) (44,109) 12,890 COMPARATIVE City of Prior Lake Water Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Operating Revenue Water Charges 601-49400.00-37100.00 Utility Receipts - Water 4,042,024 4,042,024 125,410 (3,916,614) 3%111,468 13,942 601-49400.00-37160.00 Penalties 20,000 20,000 1,908 (18,092) 10%1,136 772 4,062,024 4,062,024 127,318 (3,934,706) 3%112,604 14,714 Utility Base Fee 601-49400.00-37110.00 Utility Base Fee Revenue 1,374,903 1,374,903 78,806 (1,296,097) 6%71,483 7,323 1,374,903 1,374,903 78,806 (1,296,097) 6%71,483 7,323 Meter Sales 601-49400.00-37170.00 Water Meter Sales 79,825 79,825 15,506 (64,319) 19%10,034 5,473 601-49400.00-37175.00 Pressure Reducers 25,000 25,000 2,656 (22,344) 11%2,673 (17) 104,825 104,825 18,162 (86,663) 17%12,707 5,456 Total Operating Revenue 5,541,752 5,541,752 224,286 (5,317,466) 4%196,794 27,493 Non-Operating Revenue Interest (losses) on investments 601-00000.00-36210.00 Interest Earnings 117,300 117,300 70,507 (46,793) 60%48,073 22,435 601-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 6,033 6,033 n/a 27,674 (21,641) 117,300 117,300 76,540 (40,760) 65%75,746 794 Miscellaneous Revenues 601-00000.00-36212.00 Miscellaneous Revenue - - 15 15 n/a 10 5 - - 15 15 - 10 5 Total Non-Operating Revenue 117,300 117,300 76,555 (40,745) 65%75,756 799 Total Revenues 5,659,052 5,659,052 300,841 (5,358,211) 5%272,550 28,292 COMPARATIVE City of Prior Lake Water Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) COMPARATIVE Total Expenditures Personnel and current expenditures (excluding depreciation) 41520.00 Finance 124,805 124,805 25,795 99,010 21%20,975 (4,820) 49400.00 Water 2,911,360 2,911,360 469,324 (2,442,036) 16%526,033 56,709 3,036,165 3,036,165 495,118 2,541,047 16%547,008 51,890 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 (1,540) 36,190 -4%(1,660) (120) 34,650 34,650 (1,540) 36,190 -4%(1,660) (120) Capital improvements 601-49400.00-55530.00 Infrastructure 75,000 75,000 190 74,811 0%465 276 601-49400.00-55570.00 Machinery and equipment 110,500 110,500 - 110,500 0%- - 185,500 185,500 190 185,311 0%465 276 Total Expenditures 3,391,315 3,391,315 493,768 2,897,547 545,813 52,045 Other Financing Sources 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 - - - - n/a 4,327 4,327 Other Financing Uses Transfers out 601-80000.00-59203.00 Transfers to other funds 2,713,650 2,713,650 134,750 2,578,900 5%82,938 (51,813) 2,713,650 2,713,650 134,750 2,578,900 5%82,938 (51,813) Total Other Financing Uses 2,713,650 2,713,650 134,750 2,578,900 5%82,938 (51,813) Total Revenues/ Other Financing Sources 5,659,052 5,659,052 300,841 (5,358,211) 5%276,877 32,619 Total Expenditures/Other Financing Uses 6,104,965 6,104,965 628,518 5,476,447 10%628,751 233 Net Change (445,913) (445,913) (327,676) 118,237 (351,873) 32,386 City of Prior Lake Sewer Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Sewer Charges 604-49450.00-37102.00 Utility Receipts - Sewer 2,023,789 2,023,789 (97,882) (2,121,671) -5%(106,612) 8,729 604-49450.00-37104.00 Utility Recpt-Sewer MCES 2,106,431 2,106,431 288,109 (1,818,322) 14%292,036 (3,926) 604-49450.00-37160.00 Penalties - - 873 873 n/a 881 (8) 4,130,220 4,130,220 191,100 (3,939,120) 5%186,305 4,795 Capital Facility charges 604-49450.00-37110.00 Utility Base Fee Revenue 1,195,743 1,195,743 68,244 (1,127,499) 6%62,063 6,181 1,195,743 1,195,743 68,244 (1,127,499) 6%62,063 6,181 Total Operating Revenue 5,325,963 5,325,963 259,343 (5,066,620) 5%248,368 10,976 Non-Operating Revenue Interest (losses) on investments 604-00000.00-36210.00 Interest Earnings 70,000 70,000 35,246 (34,754) 50%28,367 6,879 604-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 1,626 1,626 n/a 14,987 (13,362) 70,000 70,000 36,872 (33,128) 53%43,355 (6,483) Total Non-Operating Revenue 70,000 70,000 36,872 (33,128) 53%43,355 (6,483) Total Revenue 5,395,963 5,395,963 296,215 (5,099,748) 5%291,722 4,493 COMPARATIVE City of Prior Lake Sewer Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) COMPARATIVE Total Expenditures Personnel and current expenditures (excluding depreciation) 41520.00 Finance 124,440 124,440 25,814 98,626 21%20,971 (4,843) 49450.00 Sewer 3,439,711 3,533,711 711,387 2,822,324 20%704,043 (7,343) 3,564,151 3,658,151 737,201 2,920,950 20%725,015 (12,186) 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 (1,540) 36,190 -4%(1,660) (120) 34,650 34,650 (1,540) 36,190 -4%(1,660) (120) Capital improvements 604-49450.00-55530.00 Infrastructure 1,500,000 1,500,000 10,996 1,489,004 1%- (10,996) 604-49450.00-55570.00 Machinery and equipment 440,000 440,000 6,402 433,598 1%28,261 21,859 1,940,000 1,940,000 17,398 1,922,602 1%28,261 10,863 Total Expenditures 5,673,801 5,767,801 753,059 5,014,742 751,615 (1,444) 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 Total Other Financing Sources - - - - n/a 4,327 4,327 Other Financing Uses 604-80000.00-59203.00 Transfers to other funds 247,000 247,000 134,250 112,750 54%82,688 (51,563) Total Other Financing Uses 247,000 247,000 134,250 112,750 54%82,688 (51,563) Total Revenues/ Other Financing Sources 5,395,963 5,395,963 296,215 (5,099,748) 5%296,050 8,820 Total Expenditures/Other Financing Uses 5,920,801 6,014,801 887,309 5,127,492 15%834,303 (53,006) Net Change (524,838) (618,838) (591,094) 27,744 (538,253) 61,827 City of Prior Lake Water Quality Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Storm Water Charges 602-49420.00-37120.00 Storm Water Revenue 1,510,793 1,510,793 90,179 (1,420,614) 6%76,062 14,117 1,510,793 1,510,793 90,179 (1,420,614) 6%76,062 14,117 Water Charges 602-49420.00-37160.00 Penalties 4,000 4,000 256 (3,744) 6%253 3 4,000 4,000 256 (3,744) 6%253 3 Total Operating Revenue 1,514,793 1,514,793 90,436 (1,424,357) 6%76,315 14,121 Non-Operating Revenue Interest (losses) on investments 602-00000.00-36210.00 Interest Earnings 41,100 41,100 24,470 (16,630) 60%15,675 8,794 602-00000.00-36225.00 Unrealized Inv.Gain(Loss)- - 2,060 2,060 n/a 9,031 (6,971) 41,100 41,100 26,529 (14,571) 65%24,706 1,824 Miscellaneous Revenues 602-49420.00-33422.10 State Aids/Grants - Operating Grants - - 4,354 (4,354) n/a - (4,354) - - 4,354 (4,354) n/a - (4,354) Total Non-Operating Revenue 41,100 41,100 30,883 (18,924) 75%24,706 (2,530) Total Revenues 1,555,893 1,555,893 121,319 (1,443,281) 8%101,021 11,591 COMPARATIVE City of Prior Lake Water Quality Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) COMPARATIVE Total Expenditures Personnel and current expenditures (excluding depreciation) 49420.00 Water Quality 674,800 674,800 61,353 613,447 9%128,097 66,744 674,800 674,800 61,353 613,447 9%128,097 66,744 Capital improvements 602-49420.00-55050.00 Projects - Professional Services - - 8,912 (8,912) n/a - 602-49420.00-55530.00 Infrastructure 1,708,000 1,708,000 213,279 1,494,721 12%94,532 (118,747) 1,708,000 1,708,000 222,191 1,485,809 13%94,532 (118,747) Total Expenditures 2,382,800 2,382,800 283,544 2,099,256 12%222,629 (52,004) Other Financing Uses 602-80000.00-59203.00 Transfers to other funds 113,300 113,300 136,325 (23,025) 120%27,500 (108,825) Total Other Financing Uses 113,300 113,300 136,325 (23,025) 120%27,500 (108,825) Total Revenues/ Other Financing Sources 1,555,893 1,555,893 121,319 (1,443,281) 8%101,021 11,591 Total Expenditures/Other Financing Uses 2,496,100 2,496,100 419,869 2,076,231 17%250,129 (160,829) Net Change (940,207) (940,207) (298,551) 632,949 (149,108) (149,238) City of Prior Lake Economic Development Authority Special Revenue Fund As of 3/31/2024 (Preliminary & Unaudited) Variance from Variance 2024 2024 2024 Amended Budget - % BDGT Actual from 2023 Budget Amended Actual Positive ( Negative)USED 3/31/2023 Positive (Negative) Revenues Taxes 240-00000.00-31010.00 Current Property Taxes 364,000 364,000 - (364,000) 0% - - 240-00000.00-31040.00 Fiscal Disparities 26,000 26,000 - (26,000) 0% - - Taxes 390,000 390,000 - (390,000) 0% - - Charges for Services 240-46500.00-34760.02 Facility Rental - EDA 24,588 24,588 9,375 (15,213) 38% 8,196 1,179 Charges for Services 24,588 24,588 9,375 (15,213) 38% 8,196 1,179 Interest (losses) on investments 240-00000.00-36210.00 Interest Earnings 3,700 3,700 3,649 (51) 99% 1,972 1,678 240-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 716 716 n/a 1,132 (416) Interest (losses) on investments 3,700 3,700 4,365 665 118% 3,104 (1,262) Total Revenues 418,288 418,288 13,740 (404,548) 3%11,300 2,441 Expenditures Function: Economic Development 46500.00 ECONOMIC DEVELOPMENT 649,834 649,834 293,831 356,003 45% 50,259 (243,572) Total Expenditures 649,834 649,834 293,831 356,003 45%50,259 (243,572) Net Change (231,546) (231,546) (280,090) (38,959) COMPARATIVE