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