Loading...
HomeMy WebLinkAbout05(E) - Approval of 2nd Quarter Financial Report Report City of Prior Lake General Fund Summary - Comparison to Prior Year As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive (Negative) USED 6/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 373,307 (521,063) 42% 440,547 (67,240) Intergovernmental 2,833,610 2,833,610 1,166,216 (1,667,394) 41% 1,069,436 96,780 Charges for Services 2,041,444 2,041,444 918,378 (1,123,066) 45% 708,104 210,274 Fines and Forfeitures - - 1,917 1,917 n/a 1,017 900 Interest (losses) on investments 104,500 104,500 137,293 32,793 131% (324,662) 461,955 Other 188,000 188,000 52,781 (135,219) 28% 88,290 (35,509) Transfers in 555,000 555,000 277,500 (277,500) 50% 539,067 (261,567) Total Revenues 18,778,399 18,778,399 9,285,450 (9,492,949) 49% 7,886,405 1,399,045 Expenditures General Government 3,706,429 3,801,987 1,826,691 1,975,296 48% 1,719,877 (106,814) Public Safety 9,454,620 9,501,418 3,758,597 5,742,821 40% 3,442,078 (316,519) Public Works 2,491,244 2,609,592 1,135,811 1,473,781 44% 987,476 (148,335) Culture and Recreation 2,524,218 2,567,813 972,072 1,595,741 38% 941,832 (30,240) Transfer to other funds 633,888 633,888 59,257 574,631 9% 69,082 9,825 Total Expenditures 18,810,399 19,114,698 7,752,428 11,362,270 41% 7,160,345 (592,083) Net Change (32,000) (336,299) 1,533,022 1,869,321 726,060 COMPARATIVE City of Prior Lake General Fund Revenues As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/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,731 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,879 8,089 111% 71,640 10,239 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 150 (450) 25% 210 (60) 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,130 380 122% 2,391 (261) 101 32210.00 Building Permits 636,900 636,900 230,817 (406,083) 36% 301,556 (70,739) 101 32211.00 Retainage Forfeiture - - 2,687 2,687 n/a (3,000) 5,687 101 32215.00 Mechanical Permits 92,400 92,400 22,762 (69,638) 25% 26,605 (3,843) 101 32230.00 Plumbing Permits 66,435 66,435 19,208 (47,227) 29% 26,073 (6,865) 101 32231.00 Sewer/Water Inspection 8,475 8,475 2,289 (6,186) 27% 3,597 (1,308) 101 32232.00 Plumbing Registrations 1,250 1,250 - (1,250) 0% - - 101 32260.00 Burning Permits 4,000 4,000 2,800 3,000 70% 3,040 (240) 101 32270.00 Short-term Rental Fee 1,435 1,435 205 (1,230) 14% - 205 Licenses and Permits 894,370 894,370 373,307 (521,063) 42% 440,547 (67,240) Intergovernmental 101 33416.01 State Aid - Police Train 30,000 30,000 - (30,000) 0% - - 101 33416.02 State Police Aid-Ins Prem 267,000 267,000 - (267,000) 0% - - 101 33417.00 State Aid - Fire Training 20,000 20,000 11,100 (8,900) 56% - 11,100 101 33418.00 State Road & Bridge Aid 463,000 463,000 227,206 (235,794) 49% 272,134 (44,928) 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 22,660 (22,660) 101 33422.11 State Aids/Grants - Operating Police 3,500 3,500 - (3,500) 0% - - 101 33610.11 County Aids/Grants - Operating Grants - - 2,820 2,820 n/a - 2,820 101 33610.11 County Aids/Grants - Operating Police - - - - n/a 470 (470) 101 33620.00 Township Fire & Resc Aid 722,760 722,760 375,090 (347,670) 52% 274,172 100,918 101 33621.00 Liaison Aid 67,350 67,350 - (67,350) 0% - - 101 33631.00 Payment in Lieu of Taxes 1,000,000 1,000,000 550,000 (450,000) 55% 500,000 50,000 Intergovernmental 2,833,610 2,833,610 1,166,216 (1,667,394) 41% 1,069,436 96,780 COMPARATIVE City of Prior Lake General Fund Revenues As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/30/2022 Positive (Negative) COMPARATIVE Charges for Services 101 31810.00 Franchise Taxes 599,000 599,000 140,626 (458,374) 23% 155,014 (14,388) 101 34103.00 Zoning & Subdivision Fees 34,100 34,100 19,826 (14,274) 58% 18,841 985 101 34104.00 Plan Check Fees 413,942 413,942 113,739 (300,203) 27% 157,149 (43,410) 101 34105.00 Sale of Maps/Publications - Reports 500 500 270 (230) 54% 56 214 101 34107.00 Assessment Searches - Reports 600 600 225 (375) 38% 100 125 101 34109.00 Project Admin/Eng Fees 280,000 280,000 108,141 (171,859) 39% 108,915 (774) 101 34203.00 Accident/Warrant Reports - Reports 200 200 562 362 281% 684 (122) 101 34731.00 Adult League Fees 4,800 4,800 8,228 3,428 171% 5,942 2,286 100 34732.00 Recreation Program Fees - Contracted - - 4,360 4,360 n/a - 4,360 101 34735.00 Recreation Program Fees - Staff Run 60,000 60,000 79,270 19,270 132% 74,807 4,463 101 34735.01 Recreation Program Fees - Club Prior 9,000 9,000 2,352 (6,648) 26% 6,001 (3,649) 101 34760.01 Facility Rental - Regular 59,675 59,675 33,907 (25,768) 57% 26,166 7,741 101 34761.00 Studio/Pavilion Rental 24,000 24,000 25,107 1,107 105% 20,357 4,750 101 34762.00 Park Shelter Rental 79,200 79,200 84,010 4,810 106% 79,403 4,607 101 34765.01 Tower Leases 252,775 252,775 246,600 (6,175) 98% (5,474) 252,074 101 34780.00 Park Admission Fees 35,000 35,000 - (35,000) 0% 7,830 (7,830) 101 34783.00 City Contract Services 188,652 188,652 51,155 (137,497) 27% 52,313 (1,158) Charges for Services 2,041,444 2,041,444 918,378 (1,123,066) 45% 708,104 210,274 Fines and Forfeitures 101 35101.00 County Court Fines - - - - n/a 200 (200) 101 35104.00 Prosecution Restitution - - 1,917 1,917 n/a 817 1,100 Fines and Forfeitures - - 1,917 1,917 n/a 1,017 900 Interest (losses) on investments 101 36210.00 Interest Earnings 124,500 124,500 141,389 16,889 114% 73,527 67,862 101 36215.00 Amortization - Premium/Discount (20,000) (20,000) (11,250) 8,750 56% (52,365) 41,115 101 36225.00 Unrealized Inv.Gain(Loss) - - 7,154 7,154 n/a (345,824) 352,978 Interest (losses) on investments 104,500 104,500 137,293 32,793 131% (324,662) 461,955 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% 5,000 (4,364) 101 36212.00 Miscellaneous Revenue 54,000 54,000 38,234 (15,766) 71% 51,844 (13,610) 101 36230.00 Contributions & Donations - - 9,353 9,353 n/a 25,878 (16,525) 101 39102.00 Sale of Property - - 1,969 1,969 n/a 2,105 (136) Other Miscellaneous Revenues 188,000 188,000 52,781 (135,219) 28% 88,290 (35,509) Other financing sources 101 39335.87 Lease Proceeds - - - - n/a 266,067 (266,067) 101 39203.00 Transfer from Other Funds 555,000 555,000 277,500 (277,500) 50% 273,000 4,500 Other financing sources 555,000 555,000 277,500 (277,500) 50% 539,067 (261,567) City of Prior Lake General Fund Revenues As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/30/2022 Positive (Negative) COMPARATIVE Total Revenues 18,778,399 18,778,399 9,285,450 (9,492,949) 49% 7,886,405 1,399,045 City of Prior Lake General Fund Expenditures As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/30/2022 Positive (Negative) Function: General Government 41110.00 MAYOR & COUNCIL 81,421 81,421 39,150 42,271 48% 33,173 (5,977) 41130.00 ORDINANCE 6,000 6,000 1,390 4,610 23% 1,988 598 41320.00 ADMINISTRATION 366,822 366,822 183,398 183,424 50% 204,752 21,354 41330.00 BOARDS & COMMISSIONS 15,471 15,471 2,261 13,210 15% 1,615 (646) 41400.00 CITY CLERK 128,217 128,217 58,909 69,308 46% 46,344 (12,565) 41410.00 ELECTIONS 43,240 43,240 578 42,662 1% 9,460 8,882 41520.00 FINANCE 688,150 709,700 276,317 433,383 39% 235,724 (40,593) 41540.00 INTERNAL AUDITING 43,700 43,700 32,500 11,200 74% 35,480 2,980 41550.00 ASSESSING 239,135 239,135 235,200 3,935 98% 227,200 (8,000) 41610.00 LEGAL 210,000 210,000 81,355 128,645 39% 78,754 (2,601) 41820.00 HUMAN RESOURCES 346,102 381,223 180,510 200,713 47% 137,733 (42,777) 41830.00 COMMUNICATIONS 170,008 170,008 73,770 96,238 43% 77,695 3,925 41910.00 COMMUNITY DEVELOPMENT 369,784 369,784 129,637 240,147 35% 118,502 (11,135) 41920.00 INFORMATION TECHNOLOGY 447,224 477,111 250,748 226,363 53% 208,078 (42,670) 41940.00 FACILITIES - CITY HALL 551,155 560,155 280,968 279,187 50% 303,379 22,411 Total - Function General Government 3,706,429 3,801,987 1,826,691 1,975,296 48% 1,719,877 (106,814) Function: Public Safety 42100.00 POLICE 6,548,159 6,582,064 2,857,541 3,724,523 43% 2,652,708 (204,833) 42200.00 FIRE 1,972,848 1,980,883 508,025 1,472,858 26% 426,898 (81,127) 42400.00 BUILDING INSPECTION 885,893 885,751 379,946 505,805 43% 334,737 (45,209) 42500.00 EMERGENCY MANAGEMENT 18,920 23,920 1,085 22,835 5% 15,735 14,650 42700.00 ANIMAL CONTROL 28,800 28,800 12,000 16,800 42% 12,000 - Total - Function Public Safety 9,454,620 9,501,418 3,758,597 5,742,821 40% 3,442,078 (316,519) Function: Public Works 43050.00 ENGINEERING 447,188 447,171 196,980 250,191 44% 192,970 (4,010) 43100.00 STREET 1,490,433 1,608,798 668,226 940,572 42% 531,121 (137,105) 43400.00 CENTRAL GARAGE 553,623 553,623 270,231 283,392 49% 258,124 (12,107) 43600.00 DEVELOPMENT PROJECTS - - 374 (374) n/a 5,261 4,887 Total - Function Public Works 2,491,244 2,609,592 1,135,811 1,473,781 44% 987,476 (148,335) Function: Culture and Recreation 45100.00 RECREATION 545,771 545,771 196,802 348,969 36% 194,676 (2,126) 45200.00 PARKS 1,893,220 1,936,815 741,821 1,194,994 38% 703,874 (37,947) 45500.00 LIBRARIES 85,227 85,227 33,449 51,778 39% 43,282 9,833 Total - Function Culture and Recreation 2,524,218 2,567,813 972,072 1,595,741 38% 941,832 (30,240) 00000.00 Transfer to Other Funds 633,888 633,888 59,257 574,631 9% 69,082 9,825 Total Expenditures 18,810,399 19,114,698 7,752,428 11,362,270 41% 7,160,345 (592,083) COMPARATIVE City of Prior Lake Expenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/30/2022 Positive (Negative) GENERAL FUND Function: General Government 41110.00 MAYOR & COUNCIL 74,621 74,621 32,136 42,485 43% 29,810 (2,326) 41320.00 ADMINISTRATION 295,857 295,857 137,285 158,572 46% 122,547 (14,738) 41330.00 BOARDS & COMMISSIONS 15,071 15,071 2,261 12,810 15% 1,615 (646) 41400.00 CITY CLERK FUNCTIONS 122,467 122,467 56,241 66,226 46% 45,585 (10,656) 41410.00 ELECTIONS - - 121 (121) n/a 154 33 41520.00 FINANCE 659,335 659,335 255,459 403,876 39% 227,269 (28,190) 41820.00 HUMAN RESOURCES 299,852 299,852 140,766 159,086 47% 123,635 (17,131) 41830.00 COMMUNICATIONS 134,228 134,228 61,128 73,100 46% 49,715 (11,413) 41910.00 COMMUNITY DEVELOPMENT 322,084 322,084 127,894 194,190 40% 115,223 (12,671) 41920.00 INFORMATION TECHNOLOGY 247,744 247,744 111,169 136,575 45% 87,347 (23,822) 41940.00 FACILITIES - CITY HALL 91,849 91,849 43,595 48,254 47% 37,831 (5,764) Total - Function General Government 2,263,108 2,263,108 968,055 1,295,053 43% 840,731 (127,324) Function: Public Safety 42100.00 POLICE 5,716,961 5,716,961 2,557,508 3,159,453 45% 2,319,114 (238,394) 42200.00 FIRE 1,557,399 1,557,399 286,798 1,270,601 18% 255,498 (31,300) 42400.00 BUILDING INSPECTION 847,991 847,991 372,873 475,118 44% 327,502 (45,371) Total - Function Public Safety 8,122,351 8,122,351 3,217,179 4,905,172 40% 2,902,114 (315,065) Function: Public Works 43050.00 ENGINEERING 370,818 370,818 174,840 195,978 47% 151,319 (23,521) 43100.00 STREET 483,276 483,276 260,439 222,837 54% 196,596 (63,843) 43400.00 CENTRAL GARAGE 276,848 276,848 130,220 146,628 47% 104,878 (25,342) Total - Function Public Works 1,130,942 1,130,942 565,499 565,443 50% 452,793 (112,706) Function: Culture and Recreation 45100.00 RECREATION 381,021 381,021 120,465 260,556 32% 131,932 11,467 45200.00 PARKS 1,184,708 1,184,708 540,145 644,563 46% 468,091 (72,054) Total - Function Culture and Recreation 1,565,729 1,565,729 660,610 905,119 42% 600,023 (60,587) General Fund Payroll Only Expenditures Total 13,082,130 13,082,130 5,411,343 7,670,787 41% 4,795,661 (615,682) EDA FUND Function: Economic Development 46500.00 ECONOMIC DEVELOPMENT 148,115 148,115 61,586 86,529 42% 57,426 (4,160) EDA Fund Payroll Only Expenditures Total 148,115 148,115 61,586 86,529 42% 57,426 (4,160) COMPARATIVE City of Prior Lake Expenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/30/2022 Positive (Negative) COMPARATIVE WATER FUND Function: Water 41520.00 Finance 85,574 85,574 38,661 46,913 45% 34,436 (4,225) 49400.00 Water 990,379 990,379 372,666 617,713 38% 372,405 (261) Water Fund Payroll Only Expenditures Total 1,075,953 1,075,953 411,327 664,626 38% 406,841 (4,486) SEWER FUND Function: Sewer 41520.00 Finance 85,574 85,574 38,654 46,920 45% 34,431 (4,223) 49450.00 Sewer 649,388 649,388 394,246 255,142 61% 285,517 (108,729) Sewer Fund Payroll Only Expenditures Total 734,962 734,962 432,900 302,062 59% 319,948 (112,952) STORM WATER FUND Function: Storm Water 49420.00 Water Quality 366,805 366,805 146,910 219,895 40% 151,223 4,313 Storm Water Fund Payroll Only Expenditures Total 366,805 366,805 146,910 219,895 40% 151,223 4,313 City-Wide Total Payroll Expenditures 15,407,965 15,407,965 6,464,066 8,943,899 42% 5,731,099 (732,967) City of Prior Lake Debt Service Funds As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/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 - - 22,946 22,946 n/a 27,275 (4,329) 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 37,129 6,429 121% 21,350 15,779 Unrealized Inv.Gain(Loss) - - (1,341) (1,341) n/a (96,483) 95,142 Other Financing Sources Transfer from Other Funds 1,094,701 1,094,701 131,258 (963,443) 12% 149,280 (18,022) Total Revenues 4,959,680 4,959,680 2,165,045 (2,794,635) 44% 2,110,638 54,407 Expenditures Debt Service Principal 4,261,693 4,261,693 142,591 4,119,102 3% 139,617 (2,974) Interest and Other 1,016,813 1,016,813 525,764 491,049 52% 518,821 (6,943) Transfers to Other Funds 25,000 25,000 - 25,000 0% - - Total Expenditures 5,303,506 5,303,506 668,355 4,635,151 13% 658,438 (9,917) Net Change (343,826) (343,826) 1,496,690 1,452,200 COMPARATIVE City of Prior Lake Cable Fund As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/30/2022 Positive (Negative) Revenues Charges for Services 210-41340.00-34304.00 PEG Access Fees 22,000 22,000 4,399 (17,601) 20% 5,369 (970) Interest (losses) on investments 210-41340.00-36210.00 Interest Earnings - - 1,279 1,279 n/a 904 375 210-41340.00-36225.00 Unrealized Inv. Gain (Loss) - - 52 52 n/a (4,136) 4,188 Total Revenues 22,000 22,000 5,730 (16,270) 26% 2,137 3,593 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 7,699 7,699 Total Expenditures 11,000 11,000 3,576 7,424 33% 7,754 4,178 Net Change 11,000 11,000 2,154 (5,617) COMPARATIVE City of Prior Lake Capital Park Fund As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/30/2022 Positive (Negative) Revenues Charges for Services 225-45200.00-34760.01 Facility Rental - Regular 24,000 24,000 12,000 (12,000) 50% (10,800) 22,800 225-45200.00-34791.00 Dedication Fees 562,500 562,500 98,937 (463,563) 18% - 98,937 Charges for Services 586,500 586,500 110,937 (475,563) 19% (10,800) 121,737 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 24,575 4,175 120% 12,490 12,085 225-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 1,156 1,156 n/a (57,174) 58,330 Interest (losses) on investments 20,400 20,400 25,731 5,331 126% (44,684) 70,415 Contributions and donations 225-00000.00-36230.00 Contributions & Donations - - 2,250 2,250 n/a 11,675 (9,425) Contributions and donations - - 2,250 2,250 n/a 11,675 (9,425) 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 138,918 (717,982) 16% (22,093) 161,011 Expenditures 53100.80 Professional Services-General 3,400 3,400 4,872 (1,472) 143% 3,402 (1,470) 55010.00 Projects - Contract Vouchers - - - - n/a 13,429 13,429 55020.00 Projects - Engineering - - - - n/a 6,817 6,817 55050.00 Projects - Professional Services - - 10,836 (10,836) n/a 1,184 (9,652) 55530.00 Infrastructure 650,000 650,000 22,687 627,313 3% 10,349 (12,338) Total Expenditures 653,400 653,400 38,395 615,005 6% 35,181 (3,214) Net Change 203,500 203,500 100,523 (57,274) COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/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 11,105 1,105 111% 6,526 4,579 410-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 805 805 n/a (30,506) 31,311 Interest (losses) on investments 10,000 10,000 11,910 1,910 119% (23,980) 35,890 Sale of assets 410-00000.00-39102.00 Sale of Property - - 18,073 18,073 n/a 66,003 (47,930) Sale of assets - - 18,073 18,073 n/a 66,003 (47,930) Transfers in 410-00000.00-39203.00 Transfer from Other Funds 217,500 217,500 108,750 (108,750) 50% 108,750 - Transfers in 217,500 217,500 108,750 (108,750) 50% 108,750 - Total Revenues 977,500 977,500 529,513 (447,987) 54% 515,757 13,756 COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/30/2022 Positive (Negative) COMPARATIVE Expenditures General Government Public Safety Police 410-42100.00-55550.00 Vehicles 267,500 267,500 176,049 91,451 66% 8,858 (167,191) 410-42100.00-55570.00 Machinery & Equipment 46,600 46,600 29,755 16,845 64% 27,750 (2,005) Fire 410-42200.00-55550.00 Vehicles 246,000 344,738 74,085 270,653 21% 426,979 352,894 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 376,342 380,796 47% 516,585 140,243 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 36,178 3,822 90% - (36,178) Central Garage 410-43400.00-55550.00 Vehicles 20,000 20,000 - 20,000 0% 12,541 12,541 Total Public Works 117,000 117,000 36,178 80,822 31% 12,541 (23,637) Culture and Recreation/Parks 410-45200.00-55550.00 Vehicles 146,500 416,500 797 415,703 0% - (797) 410-45200.00-55570.00 Machinery and Equipment 458,000 458,000 235,759 222,241 51% 69,144 (166,615) Total Culture & Recreation 604,500 874,500 236,556 637,944 27% 69,144 (167,412) Sewer 410-49450.00-55570.00 Machinery and Equipment - - 1,375 (1,375) n/a - (1,375) Total Utility - - 1,375 (1,375) n/a - (1,375) Total Expenditures 1,372,600 1,786,638 650,451 1,098,187 36% 598,270 (52,181) Net Change (395,100) (809,138) (120,938) (82,513) City of Prior Lake Revolving Park Equipment Fund As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/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 185,000 (114,000) 62% - 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 22,051 8,351 161% 8,959 13,092 430-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - (54) (54) n/a (40,737) 40,683 Interest (losses) on investments 13,700 13,700 21,997 8,297 161% (31,778) 53,775 Transfers in 410-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 436,529 (316,171) 58% 228,507 208,022 Expenditures Culture and Recreation Dept 45200.00 - PARKS 430-45200.00-55020.00 Projects - Engineering - - 55,182 (55,182) n/a 5,753 (49,429) 430-45200.00-55050.00-PRK22-000001 Projects - Professional Services - - - - n/a 28,607 28,607 430-45200.00-55530.00 Infrastructure 1,155,000 1,155,000 63,875 1,091,125 6% 8,332 (55,543) Total Culture & Recreation 1,155,000 1,155,000 119,057 1,035,943 10% 42,692 (76,365) Total Expenditures 1,155,000 1,155,000 119,057 1,035,943 10% 42,692 (76,365) Net Change (402,300) (402,300) 317,472 185,815 COMPARATIVE City of Prior Lake Facilities Management Fund As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/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 67,500 (67,500) - - - - n/a 67,500 (67,500) Interest (losses) on investments 440-00000.00-36210.00 Interest Earnings 14,600 14,600 20,071 5,471 137% 10,183 9,888 440-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 826 826 n/a (46,876) 47,702 Interest (losses) on investments 14,600 14,600 20,897 6,297 143% (36,693) 57,590 Transfers in 440-00000.00-39203.00 Transfer from Other Funds - - - - n/a 12,300 (12,300) Transfers in - - - - n/a 12,300 (12,300) Total Revenues 169,600 169,600 101,521 (68,079) 60% 97,819 3,702 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 49,183 44,078 42200-55520.00 Building & Building Improvements-FIRE 185,500 185,500 69,891 115,609 38% - (69,891) Total - Function Public Safety 418,500 418,500 74,996 343,504 18% 49,183 (25,813) Function: Culture and Recreation 45100.00 RECREATION - 86,000 - 86,000 0% - - 45500.00 LIBRARIES 125,000 125,000 - 125,000 0% - - Total - Function Culture and Recreation 125,000 211,000 - 211,000 0% - - Total Expenditures 613,500 699,500 86,644 612,856 12% 60,492 (26,152) Net Change (443,900) (529,900) 14,877 37,327 COMPARATIVE City of Prior Lake Permanent Improvement Revolving Fund As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/30/2022 Positive (Negative) Revenues Taxes 450-00000.00-31810.00 Franchise Taxes 1,068,000 1,068,000 269,383 (798,617) 25% 241,805 27,578 Taxes 1,068,000 1,068,000 269,383 (798,617) 25% 241,805 27,578 Special Assessments 450-00000.00-36101.00 City Assess. Collections 110,535 110,535 1,013 (109,522) 1% 2,965 (1,952) 450-00000.00-36102.00 County Assess. Collection - - 42,368 42,368 n/a 57,700 (15,332) 110,535 110,535 43,381 (67,154) 39% 60,665 (17,284) Interest (losses) on investments 450-00000.00-36210.00 Interest Earnings 5,700 5,700 18,831 13,131 330% 3,406 15,425 450-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - (327) (327) n/a (13,621) 13,294 Interest (losses) on investments 5,700 5,700 18,504 12,804 325% (10,215) 28,719 Total Revenues 1,184,235 1,184,235 331,268 (852,967) 28% 292,255 39,013 Expenditures Function: Public Works 450-43100.00-55020.00-PIR24-000001 Projects - Engineering - - 42,104 (42,104) n/a - (42,104) Total - Function Public Works - - 42,104 (42,104) n/a - (42,104) OTHER FINANCING USES Transfers out 450-80000.00-59203.00 Transfers to Other Funds 203,100 203,100 6,475 196,625 3% 11,360 4,885 Total Expenditures 203,100 203,100 48,579 154,521 24% 11,360 (37,219) Net Change 981,135 981,135 282,689 280,895 COMPARATIVE City of Prior Lake Water Fund As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/30/2022 Positive (Negative) Revenues Operating Revenue Water Charges 601-49400.00-37100.00 Utility Receipts - Water 3,971,228 3,971,228 794,697 (3,176,531) 20% 849,023 (54,326) 601-49400.00-37160.00 Penalties 20,000 20,000 3,412 (16,588) 17% 2,989 423 3,991,228 3,991,228 798,109 (3,193,119) 20% 852,012 (53,903) Utility Base Fee 601-49400.00-37110.00 Utility Base Fee Revenue 1,312,991 1,312,991 508,232 (804,759) 39% 495,341 12,891 1,312,991 1,312,991 508,232 (804,759) 39% 495,341 12,891 Meter Sales 601-49400.00-37170.00 Water Meter Sales 79,825 79,825 30,753 (49,072) 39% 35,988 (5,235) 601-49400.00-37175.00 Pressure Reducers 25,000 25,000 8,170 (16,830) 33% 8,757 (587) 104,825 104,825 38,923 (65,902) 37% 44,745 (5,822) Total Operating Revenue 5,409,044 5,409,044 1,345,264 (4,063,780) 25% 1,392,098 (46,834) Non-Operating Revenue Intergovernmental 601-00000.00-33422.15 State Aids/Grants - Operating Public Wor - - - - n/a 1,570 (1,570) - - - - n/a 1,570 (1,570) Interest (losses) on investments 601-00000.00-36210.00 Interest Earnings 72,900 72,900 97,160 24,260 133% 46,309 50,851 601-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 3,101 3,101 n/a (211,587) 214,688 72,900 72,900 100,261 27,361 138% (165,278) 265,539 Miscellaneous Revenues 601-00000.00-36212.00 Miscellaneous Revenue - - 11,929 11,929 n/a 500 11,429 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 - - 46,476 46,476 - 36,599 9,877 Total Non-Operating Revenue 72,900 72,900 146,737 73,837 201% (127,109) 273,846 Total Revenues 5,481,944 5,481,944 1,492,001 (3,989,943) 27% 1,264,989 227,012 COMPARATIVE City of Prior Lake Water Fund As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/30/2022 Positive (Negative) COMPARATIVE Total Expenditures Personnel and current expenditures (excluding depreciation) 41520.00 Finance 121,121 121,121 48,973 72,148 40% 53,623 4,650 49400.00 Water 2,834,696 2,840,793 1,128,728 1,712,065 40% 1,148,439 19,711 2,955,817 2,961,914 1,177,701 1,784,213 40% 1,202,062 24,361 Principal 49400.00 Water 130,000 130,000 - 130,000 0% - - 130,000 130,000 - 130,000 0% - - Interest & other 49400.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 55530.00 Infrastructure 797,700 797,700 21,613 776,087 3% 23,740 2,127 55570.00 Machinery and equipment 135,500 209,312 - 209,312 0% - - 55580.00 Software - - - - n/a 16,052 16,052 933,200 1,007,012 21,613 985,399 2% 39,792 18,179 57000.00 Loss on Disposal of Assets - - - - n/a - - Total - Function Water - - - - n/a - - 55700.00 Contra Capital Outlay - - - - n/a (23,740) (23,740) Total Expenditures 4,058,867 4,138,776 1,219,239 2,919,537 1,240,539 21,300 0.0% 0.0% Other Financing Uses 59203.00 Transfers to other funds 938,963 938,963 951,127 (12,164) 1,068,502 117,375 Total Other Financing Uses 938,963 938,963 951,127 (12,164) 1,068,502 117,375 Total Revenues/ Other Financing Sources 5,481,944 5,481,944 1,492,001 (3,989,943) 27% 1,264,989 227,012 Total Expenditures/Other Financing Uses 4,997,830 5,077,739 2,170,366 2,907,373 43% 2,309,041 138,675 Net Change 484,114 404,205 (678,365) (1,082,570) (1,044,052) 88,337 City of Prior Lake Sewer Fund As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/30/2022 Positive (Negative) Revenues Sewer Charges 604-49450.00-37102.00 Utility Receipts - Sewer 2,287,093 2,287,093 387,415 (1,899,678) 17% 415,783 (28,368) 604-49450.00-37104.00 Utility Recpt-Sewer MCES 2,002,180 2,002,180 819,749 (1,182,431) 41% 843,926 (24,177) 604-49450.00-37160.00 Penalties 20,000 20,000 2,413 (17,587) 12% 2,698 (285) 4,309,273 4,309,273 1,209,577 (3,099,696) 28% 1,262,407 (52,830) Capital Facility charges 604-49450.00-37110.00 Utility Base Fee Revenue 1,131,684 1,131,684 441,105 (690,579) 39% 430,060 11,045 1,131,684 1,131,684 441,105 (690,579) 39% 430,060 11,045 Total Operating Revenue 5,440,957 5,440,957 1,650,682 (3,790,275) 30% 1,692,467 (41,785) Non-Operating Revenue Interest (losses) on investments 604-00000.00-36210.00 Interest Earnings 38,400 38,400 57,750 19,350 150% 27,091 30,659 604-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - 426 426 n/a (122,595) 123,021 38,400 38,400 58,176 19,776 152% (95,504) 153,680 Miscellaneous Revenues 604-00000.00-36212.00 Miscellaneous Revenue - - - - 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 58,176 19,776 152% 43,540 14,636 Total Revenue 5,479,357 5,479,357 1,708,858 (3,770,499) 31% 1,736,007 (27,149) COMPARATIVE City of Prior Lake Sewer Fund As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/30/2022 Positive (Negative) COMPARATIVE Total Expenditures Personnel and current expenditures (excluding depreciation) 41520.00 Finance 120,598 120,598 48,936 71,662 41% 53,617 4,681 49450.00 Sewer 3,021,564 3,027,660 1,525,041 1,502,619 50% 1,346,161 (178,880) 3,142,162 3,148,258 1,573,977 1,574,281 50% 1,399,778 (174,199) Principal 49450.00 Sewer 130,000 130,000 - 130,000 0% - - 130,000 130,000 - 130,000 0% - - Interest & other 49450.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 55530.00 Infrastructure 724,000 724,000 - 724,000 0% 621 621 55570.00 Machinery and equipment 247,000 320,813 116,277 204,536 36% - (116,277) 55580.00 Software - - - - n/a 16,052 16,052 971,000 1,044,813 116,277 928,536 11% 16,673 (99,604) Total Expenditures 4,283,012 4,362,921 1,710,179 2,652,742 1,438,876 (271,303) Other Financing Uses 59203.00 Transfers to other funds 330,750 330,750 579,453 (248,703) 175% 680,528 101,075 Total Other Financing Uses 330,750 330,750 579,453 (248,703) 175% 680,528 101,075 Total Revenues/ Other Financing Sources 5,479,357 5,479,357 1,708,858 (3,770,499) 31% 1,736,007 (27,149) Total Expenditures/Other Financing Uses 4,613,762 4,693,671 2,289,632 2,404,039 49% 2,119,404 (170,228) Net Change 865,595 785,686 (580,774) (1,366,460) (383,397) 143,079 City of Prior Lake Water Quality Fund As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/30/2022 Positive (Negative) Revenues Storm Water Charges 602-49420.00-37120.00 Storm Water Revenue 1,356,333 1,356,333 540,953 (815,380) 40% 479,057 61,896 602-49420.00-32250.00 Wetland Application Fee - - 150 150 n/a 150 - 1,356,333 1,356,333 541,103 (815,230) 40% 479,207 61,896 Water Charges 602-49420.00-37160.00 Penalties 4,000 4,000 724 (3,276) 18% 710 14 4,000 4,000 724 (3,276) 18% 710 14 Total Operating Revenue 1,360,333 1,360,333 541,827 (818,506) 40% 479,917 61,910 Non-Operating Revenue Interest (losses) on investments 602-00000.00-36210.00 Interest Earnings 25,100 25,100 33,131 8,031 132% 16,123 17,008 602-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - (70) (70) n/a (73,338) 73,268 25,100 25,100 33,061 7,961 132% (57,215) 90,276 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 50,475 25,375 201% (57,215) 107,690 Total Revenues 1,385,433 1,385,433 592,302 (793,131) 43% 422,702 169,600 COMPARATIVE City of Prior Lake Water Quality Fund As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/30/2022 Positive (Negative) COMPARATIVE Total Expenditures Personnel and current expenditures (excluding depreciation) 49420.00 Water Quality 665,655 665,655 228,000 437,655 34% 228,583 583 665,655 665,655 228,000 437,655 34% 228,583 583 Capital improvements 55530.00 Infrastructure 711,000 711,000 102,108 608,892 14% 171,528 69,420 711,000 711,000 102,108 608,892 14% 171,528 69,420 Total Expenditures 1,376,655 1,376,655 330,108 1,046,547 24% 400,111 70,003 Other Financing Uses 59203.00 Transfers to other funds 110,000 110,000 55,000 55,000 50% 63,009 8,009 Total Other Financing Uses 110,000 110,000 55,000 55,000 50% 63,009 8,009 Total Revenues/ Other Financing Sources 1,385,433 1,385,433 592,302 (793,131) 43% 422,702 169,600 Total Expenditures/Other Financing Uses 1,486,655 1,486,655 385,108 1,101,547 26% 463,120 78,012 Net Change (101,222) (101,222) 207,194 308,416 (40,418) 247,612 City of Prior Lake Economic Development Authority Special Revenue Fund As of 6/30/2023 (Preliminary & Unaudited) Variance from Variance 2023 2023 2023 Amended Budget - % BDGT Actual from 2022 Budget Amended Actual Positive ( Negative) USED 6/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 14,343 (10,245) 58% 14,343 - Charges for Services 24,588 24,588 14,343 (10,245) 58% 14,343 - Interest (losses) on investments 240-00000.00-36210.00 Interest Earnings 2,600 2,600 4,109 1,509 158% 448 3,661 240-00000.00-36225.00 Unrealized Inv.Gain(Loss) - - (92) (92) n/a (2,044) 1,952 Interest (losses) on investments 2,600 2,600 4,017 1,417 155% (1,596) (5,613) 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 211,687 (185,501) 53% 216,156 (4,469) Expenditures Function: Economic Development 46500.00 ECONOMIC DEVELOPMENT 627,615 627,615 90,924 536,691 14% 73,527 (17,397) Total Expenditures 627,615 627,615 90,924 536,691 14% 73,527 (17,397) Net Change (230,427) (230,427) 120,763 142,629 COMPARATIVE