The URL can be used to link to this page

Home My WebLink About05(C) - Approval of the Preliminary 2nd Quarter 2021 Financial Reports Report City of Prior Lake General Fund Summary - Comparison to Prior Year As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive (Negative) USED6/30/2020Positive (Negative)RevenuesTaxes 9,433,959 9,433,959 5,001,951 (4,432,008) 53% 4,589,426 412,525 Licenses and Permits795,551 795,551 559,261 (236,290) 70% 387,459 171,802 Intergovernmental 2,160,235 2,160,235 855,599 (1,304,636) 40% 610,765 244,834 Charges for Services1,800,172 1,800,172 1,053,250 (746,922) 59% 746,495 306,755 Fines and Forfeitures‐ ‐ 38 38 n/a 20 18 Interest (losses) on investments86,800 86,800 (45,009) (131,809) ‐52% 151,872 (196,881) Other154,000 154,000 95,506 (58,494) 62% 65,105 30,401 Transfers in 523,000 523,000 261,500 (261,500) 50% 235,000 26,500 Total Revenues14,953,717 14,953,717 7,782,096 (7,171,621) 52% 6,786,142 995,954 ExpendituresGeneral Government3,269,647 3,287,247 1,638,925 1,648,322 50% 1,608,454 (30,471) Public Safety7,154,410 7,273,514 2,968,703 4,304,811 41% 2,725,160 (243,543) Public Works 2,245,916 2,245,916 1,073,706 1,172,210 48% 854,120 (219,586) Culture and Recreation2,154,169 2,154,169 753,507 1,400,662 35% 683,088 (70,419) Transfer to other funds253,575 253,575 47,753 205,822 19% 201,958 154,205 Total Expenditures15,077,717 15,214,421 6,482,594 8,731,827 43% 6,072,780 (409,814) Net Change(124,000) (260,704) 1,299,502 713,362 COMPARATIVE City of Prior Lake General Fund Revenues As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)Taxes101 31010.00 Current Property Taxes ‐ General Purpos 8,331,582 8,331,582 4,346,868 (3,984,714) 52% 4,035,321 311,547 101 31020.00 Delinquent Property Taxes ‐ General Purp‐ ‐ 51,295 51,295 n/a 19,499 31,796 101 31040.00 Fiscal Disparities 1,102,377 1,102,377 603,788 (498,589) 55% 534,606 69,182 Taxes9,433,959 9,433,959 5,001,951 (4,432,008) 53% 4,589,426 412,525 Licenses and Permits101 32100.00 Business Licenses 735 735 735 ‐ 100% 840 (105) 101 32110.00 Liquor Licenses 75,790 75,790 71,490 (4,300) 94% 3,690 67,800 101 32160.00 Refuse Haulers 4,500 4,500 5,335 835 119% 4,585 750 101 32175.00 Public Private Gathering Permit 720 720 480 (240) 67% 170 310 101 32180.00 Cigarette Licenses 2,040 2,040 1,785 (255) 88% 2,040 (255) 101 32190.00 Community Event Application‐ ‐ 3,300 3,300 n/a 100 3,200 101 32210.00 Building Permits 546,300 546,300 410,199 (136,101) 75% 309,207 100,992 101 32215.00 Mechanical Permits 87,300 87,300 29,251 (58,049) 34% 37,496 (8,245) 101 32230.00 Plumbing Permits 62,573 62,573 26,544 (36,029) 42% 22,474 4,070 101 32231.00 Sewer/Water Inspection 7,063 7,063 6,182 (881) 88% 3,817 2,365 101 32232.00 Plumbing Registrations 1,250 1,250 1,440 190 115% 420 1,020 101 32260.00 Burning Permits 4,000 4,000 2,520 3,000 63% 1,800 720 101 32270.00 Short‐term Rental Fee 3,280 3,280 ‐ (3,280) 0% 820 (820) Licenses and Permits 795,551 795,551 559,261 (236,290) 70% 387,459 171,802 Intergovernmental101 33160.11 Fed Aids/Grants ‐ Operating Police 10,500 10,500 ‐ (10,500) 0%‐ ‐ 101 33401.00 Local Government Aid 11,905 11,905 ‐ (11,905) 0%‐ ‐ 101 33416.01 State Aid ‐ Police Train 24,000 24,000 ‐ (24,000) 0%‐ ‐ 101 33416.02 State Police Aid‐Ins Prem 229,000 229,000 ‐ (229,000) 0%‐ ‐ 101 33417.00 State Aid ‐ Fire Training 15,000 15,000 14,490 (510) 97%‐ 14,490 101 33418.00 State Road & Bridge Aid 377,000 377,000 201,018 (175,982) 53% 209,398 (8,380) 101 33420.00 State Fire Aid‐Ins. Prem. 237,000 237,000 ‐ (237,000) 0% 1,000 (1,000) 101 33422.10 State Aids/Grants ‐ Operating Grants 65,000 65,000 23,244 (41,756) 36% 11,485 11,759 102 33422.11 State Aids/Grants ‐ Operating Police 4,200 4,200 ‐ (4,200) 0%‐ ‐ 101 33610.11 County Aids/Grants ‐ Operating Grants‐ ‐ 500 500 n/a‐ 500 101 33610.11 County Aids/Grants ‐ Operating Police‐ ‐ 1,509 1,509 n/a‐ 1,509 101 33620.00 Township Fire & Resc Aid 430,540 430,540 214,838 (215,702) 50% 182,882 31,956 101 33621.00 Liaison Aid 56,090 56,090 ‐ (56,090) 0%‐ ‐ 101 33631.00 Payment in Lieu of Taxes 700,000 700,000 400,000 (300,000) 57% 200,000 200,000 101 33700.11 Miscellaneous Grants ‐ Operating Police‐ ‐ ‐ ‐ n/a 6,000 (6,000) Intergovernmental 2,160,235 2,160,235 855,599 (1,304,636) 40% 610,765 244,834 COMPARATIVE City of Prior Lake General Fund Revenues As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)COMPARATIVECharges for Services101 31810.00 Franchise Taxes 637,000 637,000 175,283 (461,717) 28% 161,603 13,680 101 34103.00 Zoning & Subdivision Fees 30,000 30,000 21,008 (8,992) 70% 12,054 8,954 101 34104.00 Plan Check Fees 300,424 300,424 200,678 (99,746) 67% 156,816 43,862 101 34105.00 Sale of Maps/Publications ‐ Reports 500 500 190 (310) 38% 285 (95) 101 34107.00 Assessment Searches ‐ Reports 500 500 300 (200) 60% 600 (300) 101 34109.00 Project Admin/Eng Fees 122,000 122,000 71,944 (50,056) 59% 35,802 36,142 101 34203.00 Accident/Warrant Reports ‐ Reports 300 300 40 (260) 13% 5 35 101 34731.00 Adult League Fees 10,000 10,000 4,927 (5,073) 49% 210 4,717 101 34735.00 Recreation Program Fees 43,000 43,000 72,276 29,276 168% 270 72,006 101 34735.01 Recreation Program Fees Regular 9,000 9,000 3,425 (5,575) 38% 5,229 (1,804) 101 34760.01 Facility Rental ‐ Regular 37,349 37,349 16,832 (20,517) 45% 15,925 907 101 34761.00 Studio/Pavilion Rental 24,000 24,000 19,549 (4,451) 81% 8,758 10,791 101 34762.00 Park Shelter Rental 83,200 83,200 84,080 880 101% 74,600 9,480 101 34765.01 Tower Leases 306,324 306,324 330,132 23,808 108% 246,266 83,866 101 34780.00 Park Admission Fees 30,000 30,000 25 (29,975) 0% (15) 40 101 34783.00 City Contract Services 166,575 166,575 52,561 (114,014) 32% 29,426 23,135 101 36220.16 Prof Services Fee Deposit Bldg Inspectio‐ ‐ ‐ ‐ n/a (1,339) 1,339 Charges for Services 1,800,172 1,800,172 1,053,250 (746,922) 59% 746,495 306,755 Fines and Forfeitures101 35104.00 Prosecution Restitution‐ ‐ 38 38 n/a 20 18 Fines and Forfeitures‐ ‐ 38 38 n/a 20 18 Interest (losses) on investments101 36210.00 Interest Earnings 86,800 86,800 71,941 (14,859) 83% 73,060 (1,119) 101 36215.00 Amortization ‐ Premium/Discount‐ ‐ (42,964) (42,964) n/a (28,689) (14,275) 101 36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (73,986) (73,986) n/a 107,501 (181,487) Interest (losses) on investments 86,800 86,800 (45,009) (131,809) ‐52% 151,872 (196,881) Other Miscellaneous Revenues101 36102.00 County Assess. Collection‐ ‐ 6,750 6,750 n/a 1,132 5,618 101 36211.00 Developer Agreements 130,000 130,000 18,500 (111,500) 14% 11,015 7,485 101 36212.00 Miscellaneous Revenue 24,000 24,000 26,682 2,682 111% 42,707 (16,025) 101 36230.00 Contributions & Donations‐ ‐ 17,975 17,975 n/a 9,315 8,660 101 39102.00 Sale of Property‐ ‐ 25,599 25,599 n/a 936 24,663 Other Miscellaneous Revenues 154,000 154,000 95,506 (58,494) 62% 65,105 30,401 Other financing sources101 39203.00 Transfer from Other Funds 523,000 523,000 261,500 (261,500) 50% 235,000 26,500 Other financing sources 523,000 523,000 261,500 (261,500) 50% 235,000 26,500 Total Revenues14,953,717 14,953,717 7,782,096 (7,171,621) 52% 6,786,142 995,954 City of Prior Lake General Fund Expenditures As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)Function: General Government41110.00 MAYOR & COUNCIL74,934 74,934 34,800 40,134 46% 32,877 (1,923) 41130.00 ORDINANCE 6,000 6,000 2,435 3,565 41% 2,693 258 41320.00 ADMINISTRATION 270,152 270,152 128,749 141,403 48% 203,362 74,613 41330.00 BOARDS & COMMISSIONS11,365 11,365 3,306 8,059 29% 1,988 (1,318) 41400.00 CITY CLERK 122,272 122,272 52,025 70,247 43% 51,439 (586) 41410.00 ELECTIONS 7,000 7,000 157 6,843 2% 11,633 11,476 41520.00 FINANCE 565,250 565,250 241,927 323,323 43% 195,131 (46,796) 41540.00 INTERNAL AUDITING 41,200 41,200 36,933 4,267 90% 31,184 (5,749) 41550.00 ASSESSING 224,260 224,260 220,600 3,660 98% 214,200 (6,400) 41610.00 LEGAL 180,000 180,000 82,370 97,630 46% 102,660 20,290 41820.00 HUMAN RESOURCES 316,074 333,674 146,829 186,845 44% 82,779 (64,050) 41830.00 COMMUNICATIONS 162,070 162,070 71,033 91,037 44% 66,051 (4,982) 41910.00 COMMUNITY DEVELOPMENT379,924 379,924 138,201 241,723 36% 129,684 (8,517) 41920.00 INFORMATION TECHNOLOGY 385,116 385,116 211,664 173,452 55% 258,100 46,436 41940.00 FACILITIES ‐ CITY HALL 524,030 524,030 267,896 256,134 51% 224,673 (43,223) Total ‐ Function General Government 3,269,647 3,287,247 1,638,925 1,648,322 50% 1,608,454 (30,471) Function: Public Safety42100.00 POLICE 5,303,369 5,422,473 2,285,633 3,136,840 42% 2,120,136 (165,497) 42200.00 FIRE 1,076,350 1,076,350 368,417 707,933 34% 310,182 (58,235) 42400.00 BUILDING INSPECTION 730,801 730,801 300,261 430,540 41% 272,458 (27,803) 42500.00 EMERGENCY MANAGEMENT15,090 15,090 2,392 12,698 16% 9,989 7,597 42700.00 ANIMAL CONTROL28,800 28,800 12,000 16,800 42% 12,395 395 Total ‐ Function Public Safety 7,154,410 7,273,514 2,968,703 4,304,811 41% 2,725,160 (243,543) Function: Public Works43050.00 ENGINEERING 389,105 389,105 194,669 194,436 50% 156,173 (38,496) 43100.00 STREET 1,365,438 1,365,438 672,663 692,775 49% 475,980 (196,683) 43400.00 CENTRAL GARAGE 491,373 491,373 206,374 284,999 42% 221,967 15,593 Total ‐ Function Public Works 2,245,916 2,245,916 1,073,706 1,172,210 48% 854,120 (219,586) Function: Culture and Recreation45100.00 RECREATION 481,813 481,813 167,083 314,730 35% 142,834 (24,249) 45200.00 PARKS 1,604,132 1,604,132 557,576 1,046,556 35% 512,942 (44,634) 45500.00 LIBRARIES 68,224 68,224 28,848 39,376 42% 27,312 (1,536) Total ‐ Function Culture and Recreation 2,154,169 2,154,169 753,507 1,400,662 35% 683,088 (70,419) 00000.00 Transfer to Other Funds 253,575 253,575 47,753 205,822 19% 201,958 154,205 Total Expenditures15,077,717 15,214,421 6,482,594 8,731,827 43% 6,072,780 (409,814) COMPARATIVE City of Prior LakeExpenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 6/30/2021(Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)GENERAL FUNDFunction: General Government41110.00 MAYOR & COUNCIL 66,234 66,234 31,054 35,180 47% 29,820 (1,234) 41320.00 ADMINISTRATION 197,222 197,222 93,798 103,424 48% 170,361 76,563 41330.00 BOARDS & COMMISSIONS 10,765 10,765 3,307 7,458 31% 1,938 (1,369) 41400.00 CITY CLERK FUNCTIONS 120,422 120,422 51,825 68,597 43% 50,109 (1,716) 41410.00 ELECTIONS 3,500 3,500 137 3,363 4% 7,677 7,540 41520.00 FINANCE 537,955 537,955 233,730 304,225 43% 184,470 (49,260) 41820.00 HUMAN RESOURCES 271,624 271,624 117,208 154,416 43% 70,711 (46,497) 41830.00 COMMUNICATIONS 128,054 128,054 49,718 78,336 39% 48,162 (1,556) 41910.00 COMMUNITY DEVELOPMENT 317,724 317,724 134,448 183,276 42% 126,068 (8,380) 41920.00 INFORMATION TECHNOLOGY 225,935 225,935 96,167 129,768 43% 68,488 (27,679) 41940.00 FACILITIES ‐ CITY HALL 91,018 91,018 25,956 65,062 29% 34,408 8,452 Total ‐ Function General Government 1,970,453 1,970,453 837,348 1,133,105 42% 792,212 (45,136) Function: Public Safety42100.00 POLICE 4,736,215 4,822,965 2,002,551 2,820,414 42% 1,888,453 (114,098) 42200.00 FIRE 760,123 760,123 230,297 529,826 30% 218,177 (12,120) 42400.00 BUILDING INSPECTION 679,565 679,565 287,973 391,592 42% 266,959 (21,014) Total ‐ Function Public Safety 6,175,903 6,262,653 2,520,821 3,741,832 40% 2,373,589 (147,232) Function: Public Works43050.00 ENGINEERING 350,041 350,041 145,142 204,899 41% 139,375 (5,767) 43100.00 STREET 503,876 503,876 215,323 288,553 43% 201,362 (13,961) 43400.00 CENTRAL GARAGE 247,198 247,198 100,699 146,499 41% 101,706 1,007 Total ‐ Function Public Works 1,101,115 1,101,115 461,164 639,951 42% 442,443 (18,721) Function: Culture and Recreation45100.00 RECREATION 360,011 360,011 113,027 246,984 31% 113,190 163 45200.00 PARKS 1,081,258 1,081,258 390,140 691,118 36% 394,650 4,510 Total ‐ Function Culture and Recreation 1,441,269 1,441,269 503,167 938,102 35% 507,840 4,673 General Fund Payroll Only Expenditures Total 10,688,740 10,775,490 4,322,500 6,452,990 40% 4,116,084 (206,416) EDA FUNDFunction: Economic Development 46500.00 ECONOMIC DEVELOPMENT 135,544 135,544 62,789 72,755 46% 65,480 2,691 EDA Fund Payroll Only Expenditures Total 135,544 135,544 62,789 72,755 46% 65,480 2,691 COMPARATIVE City of Prior LakeExpenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 6/30/2021(Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)COMPARATIVEWATER FUNDFunction: Water41520.00 Finance 76,881 76,881 32,978 43,903 43% 32,521 (457) 49400.00 Water 749,281 749,281 319,934 429,347 43% 313,757 (6,177) Water Fund Payroll Only Expenditures Total 826,162 826,162 352,912 473,250 43% 346,278 (6,634) SEWER FUNDFunction: Sewer41520.00 Finance 76,881 76,881 32,973 43,908 43% 32,582 (391) 49450.00 Sewer 731,502 731,502 320,468 411,034 44% 338,026 17,558 Sewer Fund Payroll Only Expenditures Total 808,383 808,383 353,441 454,942 44% 370,608 17,167 STORM WATER FUNDFunction: Storm Water49420.00 Water Quality 366,879 366,879 145,814 221,065 40% 147,320 1,506 Storm Water Fund Payroll Only Expenditures Total 366,879 366,879 145,814 221,065 40% 147,320 1,506 City‐Wide Total Payroll Expenditures 12,825,708 12,912,458 5,237,456 7,675,002 41% 5,045,770 (191,686) City of Prior Lake Debt Service Funds As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)RevenuesProperty TaxesCurrent Property Taxes 3,121,498 3,121,498 1,647,105 (1,474,393) 53% 1,695,378 (48,273) Special AssessmentsCity Assess. Collections‐ ‐ 65,862 65,862 n/a 45,717 20,145 County Assess. Collection 446,370 446,370 221,181 (225,189) 50% 231,045 (9,864) Interest (losses) on investmentsInterest Earnings 46,406 46,406 23,194 (23,212) 50% 34,110 (10,916) Unrealized Inv.Gain(Loss)‐ ‐ (23,481) (23,481) n/a 52,519 (76,000) Other Financing SourcesTransfer from Other Funds 1,206,925 1,206,925 136,678 (1,070,247) 11% 147,004 (10,326) Total Revenues4,821,199 4,821,199 2,070,539 (2,750,660) 43% 2,205,773 (135,234) ExpendituresDebt ServicePrincipal 4,274,858 4,274,858 136,705 4,138,153 3% 133,854 (2,851) Interest and Other 965,899 965,899 483,664 482,235 50% 583,853 100,189 Bond Issuance Costs 2,870 2,870 990 1,880 34% 1,990 1,000 Transfers to Other Funds 75,000 75,000 ‐ 75,000 0%‐ ‐ Total Expenditures5,318,627 5,318,627 621,359 4,697,268 12% 719,697 98,338 Net Change(497,428) (497,428) 1,449,180 1,486,076 COMPARATIVE City of Prior Lake Cable Fund As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)RevenuesCharges for Services210‐41340.00‐34304.00PEG Access Fees 28,000 28,000 6,206 (21,794) 22% 6,758 (552) Interest (losses) on investments210‐41340.00‐36210.00Interest Earnings‐ ‐ 747 747 n/a 766 (19) 210‐41340.00‐36225.00Unrealized Inv. Gain (Loss)‐ ‐ (722) (722) n/a 1,254 (1,976) Total Revenues28,000 28,000 6,231 (21,769) 22% 8,778 (2,547) ExpendituresCurrent Expenditures210‐41340.00‐52400.20Small Equipment ‐ Technology‐ ‐ 1,407 (1,407) n/a 296 (1,111) 210‐41340.00‐53210.00Telecommunications‐ ‐ ‐ ‐ n/a 4,427 4,427 Capital Outlay210‐41340.00‐55570.00Machinery and Equipment‐ ‐ 3,641 (3,641) n/a 5,643 2,002 Total Expenditures‐ ‐ 5,048 (5,048) n/a 10,366 5,318 Net Change28,000 28,000 1,183 (1,588) COMPARATIVE City of Prior Lake Capital Park Fund As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)RevenuesCharges for Services225‐45200.00‐34760.01 Facility Rental ‐ Regular 24,000 24,000 12,000 (12,000) 50% 12,000 ‐ 225‐45200.00‐34791.00 Dedication Fees 431,000 431,000 22,752 (408,248) 5% 8,320 14,432 Charges for Services 455,000 455,000 34,752 (420,248) 8% 20,320 14,432 Interest (losses) on investments225‐00000.00‐36210.00 Interest Earnings 22,700 22,700 12,347 (10,353) 54% 18,761 (6,414) 225‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (12,007) (12,007) n/a 31,269 (43,276) Interest (losses) on investments 22,700 22,700 340 (22,360) 1% 50,030 (49,690) Contributions and donations225‐00000.00‐36230.00 Contributions & Donations 18,597 18,597 25,031 6,434 135% 1,725 23,306 Contributions and donations 18,597 18,597 25,031 6,434 135% 1,725 23,306 Total Revenues496,297 496,297 60,123 (436,174) 12% 72,075 (11,952) Expenditures54320.00 Miscellaneous‐ ‐ 130 (130) n/a‐ (130) 53100.80 Professional Services‐General‐ ‐ 5,986 (5,986) n/a 10,786 4,800 55010.00 Projects ‐ Contract Vouchers‐ ‐ 164,490 (164,490) n/a‐ (164,490) 55020.00 Projects ‐ Engineering‐ ‐ 82,459 (82,459) n/a 5,509 (76,950) 55530.00 Infrastructure 956,000 956,000 1,584 954,416 0% 1,361 (223) Total Expenditures956,000 956,000 254,649 701,351 27% 17,656 (236,993) Net Change(459,703) (459,703) (194,526) 54,419 COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)RevenuesTaxes410‐00000.00‐31010.00 Current Property Taxes 650,000 650,000 440,631 (209,369) 68% 319,455 121,176 410‐00000.00‐31015.00 Current Property Taxes ‐ Debt Service 185,000 185,000 ‐ (185,000) 0%‐ ‐ Taxes835,000 835,000 440,631 (394,369) 53% 319,455 121,176 Interest (losses) on investments410‐00000.00‐36210.00 Interest Earnings 9,600 9,600 4,331 (5,269) 45% 7,281 (2,950) 410‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (4,441) (4,441) n/a 10,392 (14,833) Interest (losses) on investments 9,600 9,600 (110) (9,710) ‐1% 17,673 (17,783) Sale of assets410‐00000.00‐39102.00 Sale of Property‐ ‐ 70,925 70,925 n/a 49,088 21,837 Sale of assets‐ ‐ 70,925 70,925 n/a 49,088 21,837 Transfers in410‐00000.00‐39203.00 Transfer from Other Funds 310,000 310,000 155,000 (155,000) 50% 90,000 65,000 Transfers in310,000 310,000 155,000 (155,000) 50% 90,000 65,000 OTHER FINANCING SOURCESDebt Issued410‐00000.00‐39310.00 G.O. Bond Proceeds 555,000 555,000 ‐ (555,000) 0%‐ ‐ 555,000 555,000 ‐ (555,000) 0%‐ ‐ Total Revenues1,709,600 1,709,600 666,446 (1,043,154) 39% 476,216 190,230 COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)COMPARATIVEExpendituresPublic SafetyPolice410‐42100.00‐55550.00 Vehicles 212,000 251,933 51,243 200,690 20% 88,136 36,893 410‐42100.00‐55570.00 Machinery & Equipment 38,900 38,900 25,965 12,935 67% 25,580 (385) Fire410‐42200.00‐55550.00 Vehicles 740,000 740,000 24,615 715,385 3%‐ (24,615) 410‐42200.00‐55570.00 Machinery & Equipment 52,000 52,000 ‐ 52,000 0% 48,715 48,715 Building Inspection410‐42400.00‐55550.00 Vehicles 35,000 35,000 ‐ ‐ 0%‐ ‐ Total Public Safety 1,077,900 1,117,833 101,823 981,010 9% 162,431 60,608 Public WorksStreet410‐43100.00‐55550.00 Vehicles 251,600 251,600 207,140 44,460 82% 234,603 27,463 410‐43100.00‐55570.00 Machinery & Equipment 38,000 38,000 4,400 33,600 12%‐ (4,400) Central Garage410‐43400.00‐55550.00 Vehicles 20,000 20,000 19,937 63 100%‐ (19,937) Total Public Works 309,600 309,600 231,477 78,123 75% 234,603 3,126 Culture and Recreation/Parks410‐45200.00‐55550.00 Vehicles‐ ‐ 221,521 (221,521) n/a‐ (221,521) 410‐45200.00‐55570.00 Machinery and Equipment 262,500 262,500 63,970 198,530 24% 63,384 (586) Total Culture & Recreation 262,500 262,500 285,491 (22,991) 109% 63,384 (222,107) Water410‐49400.00‐55550.00 Vehicles 83,000 83,000 37,778 45,222 46%‐ (37,778) Sewer410‐49450.00‐55550.00 Vehicles 83,000 83,000 37,778 45,222 46%‐ (37,778) Total Utility 166,000 166,000 75,556 90,444 46%‐ (75,556) Total Expenditures1,816,000 1,855,933 694,347 1,126,586 37% 460,418 (233,929) Net Change(106,400) (146,333) (27,901) 15,798 City of Prior Lake Revolving Park Equipment Fund As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)RevenuesTaxes430‐00000.00‐31010.00 Current Property Taxes 375,000 375,000 198,250 (176,750) 53% 162,872 35,378 Taxes375,000 375,000 198,250 (176,750) 53% 162,872 35,378 Interest (losses) on investments430‐00000.00‐36210.00 Interest Earnings 10,500 10,500 9,573 (927) 91% 9,718 (145) 430‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (9,411) (9,411) n/a 15,659 (25,070) Interest (losses) on investments 10,500 10,500 162 (10,338) 2% 25,377 (25,215) Total Revenues385,500 385,500 198,412 (187,088) 51% 188,249 10,163 ExpendituresCulture and Recreation/Parks430‐45200.00‐55020.00 Projects ‐ Engineering‐ ‐ 10,359 (10,359) n/a‐ (10,359) 430‐45200.00‐55530.00 Infrastructure 525,000 525,000 1,800 523,200 0% 17,900 16,100 Total Culture & Recreation 525,000 525,000 12,159 512,841 2% 17,900 5,741 Total Expenditures525,000 525,000 12,159 512,841 2% 17,900 5,741 Net Change(139,500) (139,500) 186,253 170,349 COMPARATIVE City of Prior Lake Facilities Management Fund As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)RevenuesTaxes440‐00000.00‐31010.00 Current Property Taxes80,000 80,000 42,094 (37,906) 53% 15,092 27,002 Taxes80,000 80,000 42,094 (37,906) 53% 15,092 27,002 Interest (losses) on investments440‐00000.00‐36210.00 Interest Earnings 5,800 5,800 4,019 (1,781) 69% 5,129 (1,110) 440‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (3,904) (3,904) n/a 8,363 (12,267) Interest (losses) on investments5,800 5,800 115 (5,685) 2% 13,492 (13,377) Transfers in440‐00000.00‐39203.00 Transfer from Other Funds 130,000 130,000 65,000 (65,000) 50% 49,500 15,500 Transfers in130,000 130,000 65,000 (65,000) 50% 49,500 15,500 Total Revenues215,800 215,800 107,209 (108,591) 50% 78,084 29,125 ExpendituresFunction: General Government41940‐55050.00 Projects Professional Svcs‐ FACILITIES ‐ CITY HALL‐ ‐ 10,979 (10,979) n/a 10,660 (319) 41940‐55520.00 Building & Building Improvements‐FACILITIES ‐ CITY HAL240,000 240,000 15,050 224,950 6%‐ (15,050) Total ‐ Function General Government240,000 240,000 26,029 213,971 11% 10,660 (15,369) Function: Public Safety42100‐55520.00 Building & Building Improvements‐POLICE 22,500 22,500 ‐ 22,500 0%‐ ‐ 42200‐55520.00 Building & Building Improvements‐FIRE 120,000 120,000 15,985 104,015 13%‐ (15,985) Total ‐ Function Public Safety142,500 142,500 15,985 126,515 11%‐ (15,985) Function: Public Works43400.00 CENTRAL GARAGE 50,100 50,100 ‐ 50,100 0%‐ ‐ Total ‐ Function Public Works50,100 50,100 ‐ 50,100 0%‐ ‐ Function: Culture and Recreation45500.00 LIBRARIES 15,000 15,000 ‐ 15,000 0%‐ ‐ Total ‐ Function Culture and Recreation15,000 15,000 ‐ 15,000 0%‐ ‐ Total Expenditures447,600 447,600 42,014 405,586 9% 10,660 (31,354) Net Change(231,800) (231,800) 65,195 67,424 COMPARATIVE City of Prior Lake Permanent Improvement Revolving Fund As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)RevenuesTaxes450‐00000.00‐31010.00 Property Taxes ‐ General Purpose 120,000 120,000 63,141 (56,859) 53% 40,875 22,266 Taxes120,000 120,000 63,141 (56,859) 53% 40,875 22,266 Special Assessments450‐00000.00‐36101.00 City Assess. Collections 173,000 173,000 10,580 (162,420) 6% 14,626 (4,046) 450‐00000.00‐36102.00 County Assess. Collection‐ ‐ 67,155 67,155 n/a 73,582 (6,427) 173,000 173,000 77,735 (95,265) 45% 88,208 (10,473) Interest (losses) on investments450‐00000.00‐36210.00 Interest Earnings 7,800 7,800 2,839 (4,961) 36% 8,194 (5,355) 450‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (2,832) (2,832) n/a 13,221 (16,053) Interest (losses) on investments 7,800 7,800 7 (7,793) 0% 21,415 (21,408) Transfers in450‐00000.00‐39203.00 Transfer from Other Funds‐ ‐ ‐ ‐ n/a 257,935 (257,935) Transfers in‐ ‐ ‐ ‐ n/a 257,935 (257,935) Total Revenues300,800 300,800 140,883 (159,917) 47% 408,433 (267,550) ExpendituresFunction: Public Works450‐43100.00‐55530.00 Infrastructure‐ ‐ ‐ ‐ n/a 590,277 590,277 Total ‐ Function Public Works‐ ‐ ‐ ‐ n/a 590,277 590,277 OTHER FINANCING USESTransfers out450‐80000.00‐59203.00 Transfers to Other Funds 287,150 287,150 16,075 271,075 6% 29,633 13,558 Total Expenditures287,150 287,150 16,075 271,075 6% 619,910 603,835 Net Change13,650 13,650 124,808 (211,477) COMPARATIVE City of Prior Lake Water Fund As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)RevenuesOperating RevenueWater Charges601‐49400.00‐37100.00 Utility Receipts ‐ Water 3,146,749 3,146,749 909,308 (2,237,441) 29% 1,175,824 (266,516) 601‐49400.00‐37160.00 Penalties 20,000 20,000 7,773 (12,227) 39% 2,957 4,816 3,166,749 3,166,749 917,081 (2,249,668) 29% 1,178,781 (261,700) Capital Facility charges601‐49400.00‐37110.00 Utility Base Fee Revenue 1,140,200 1,140,200 478,315 (661,885) 42% 106,440 371,875 1,140,200 1,140,200 478,315 (661,885) 42% 106,440 371,875 Meter Sales601‐49400.00‐37170.00 Water Meter Sales 79,825 79,825 50,543 (29,282) 63% 41,466 9,077 601‐49400.00‐37175.00 Pressure Reducers 25,000 25,000 12,003 (12,997) 48% 8,429 3,574 104,825 104,825 62,546 (42,279) 60% 49,895 12,651 Total Operating Revenue4,411,774 4,411,774 1,457,942 (2,953,832) 33% 1,335,116 122,826 Non‐Operating RevenueIntergovernmental601‐00000.00‐33422.15 State Aids/Grants ‐ Operating Public Wor‐ ‐ 133 133 n/a‐ 133 ‐ ‐ 133 133 n/a‐ 133 Interest (losses) on investments601‐00000.00‐36210.00 Interest Earnings 54,775 54,775 43,716 (11,059) 80% 50,227 (6,511) 601‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (42,312) (42,312) n/a 84,348 (126,660) 54,775 54,775 1,404 (53,371) 3% 134,575 (133,171) Miscellaneous Revenues601‐00000.00‐36212.00 Miscellaneous Revenue‐ ‐ 826 826 n/a 330 496 601‐00000.00‐36102.00 County Assess Collection‐ ‐ 37,305 37,305 n/a 47,338 (10,033) 601‐49400.00‐37190.00 Miscellaneous Revenue Adj‐ ‐ (42) (42) n/a 1 (43) ‐ ‐ 38,089 38,089 ‐ 47,669 (9,580) Total Non‐Operating Revenue54,775 54,775 39,626 (15,149) 72% 182,244 (142,618) Total Revenues4,466,549 4,466,549 1,497,568 (2,968,981) 34% 1,517,360 (19,792) COMPARATIVE City of Prior Lake Water Fund As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)COMPARATIVETotal ExpendituresPersonnel and current expenditures (excluding depreciation)41520.00 Finance 108,246 108,246 42,219 66,027 39% 44,868 2,649 49400.00 Water 2,041,449 2,041,449 910,022 1,131,427 45% 785,792 (124,230) 2,149,695 2,149,695 952,241 1,197,454 44% 830,660 (121,581) Principal49400.00 Water 120,000 120,000 ‐ 120,000 0%‐ ‐ 120,000 120,000 ‐ 120,000 0%‐ ‐ Interest & other49400.00 Water 49,650 49,650 24,825 24,825 50% 27,225 2,400 49,650 49,650 24,825 24,825 50% 27,225 2,400 Capital improvements55530.00 Infrastructure 1,917,500 1,917,500 86,906 1,830,594 5%‐ (86,906) 55570.00 Machinery and equipment 150,750 150,750 ‐ 150,750 0%‐ ‐ 55580.00 Software 28,500 28,500 ‐ 28,500 0% 13,510 13,510 2,096,750 2,096,750 86,906 2,009,844 4% 13,510 (73,396) Total Expenditures4,416,095 4,416,095 1,063,972 3,352,123 871,395 (192,577) 0.0%Other Financing Uses59203.00 Transfers to other funds 1,035,700 1,035,700 307,850 727,850 261,217 (46,633) Total Other Financing Uses1,035,700 1,035,700 307,850 727,850 261,217 (46,633) Total Revenues/ Other Financing Sources4,466,549 4,466,549 1,497,568 (2,968,981) 34% 1,517,360 (19,792) Total Expenditures/Other Financing Uses5,451,795 5,451,795 1,371,822 4,079,973 25% 1,132,612 (239,210) Net Change (985,246) (985,246) 125,746 1,110,992 384,748 219,418 City of Prior Lake Sewer Fund As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)RevenuesSewer Charges604‐49450.00‐37102.00 Utility Receipts ‐ Sewer 1,717,840 1,717,840 462,404 (1,255,436) 27% 682,425 (220,021) 604‐49450.00‐37104.00 Utility Recpt‐Sewer MCES 1,625,587 1,625,587 845,616 (779,971) 52% 838,449 7,167 604‐49450.00‐37160.00 Penalties 20,000 20,000 11,697 (8,303) 58% 3,970 7,727 3,363,427 3,363,427 1,319,717 (2,043,710) 39% 1,524,844 (205,127) Capital Facility charges604‐49450.00‐37110.00 Utility Base Fee Revenue 953,615 953,615 419,823 (533,792) 44% 106,444 313,379 953,615 953,615 419,823 (533,792) 44% 106,444 313,379 Total Operating Revenue4,317,042 4,317,042 1,739,540 (2,577,502) 40% 1,631,288 108,252 Non‐Operating RevenueInterest (losses) on investments604‐00000.00‐36210.00 Interest Earnings 19,800 19,800 21,438 1,638 108% 20,127 1,311 604‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (21,013) (21,013) n/a 33,325 (54,338) 19,800 19,800 425 (19,375) 2% 53,452 (53,027) Total Non‐Operating Revenue19,800 19,800 425 (19,375) 2% 53,452 (53,027) Total Revenue4,336,842 4,336,842 1,739,965 (2,596,877) 40% 1,684,740 55,225 COMPARATIVE City of Prior Lake Sewer Fund As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)COMPARATIVETotal ExpendituresPersonnel and current expenditures (excluding depreciation)41520.00 Finance 107,721 107,721 42,214 65,507 39% 44,918 2,704 49450.00 Sewer 2,681,274 2,681,274 1,266,789 1,414,485 47% 1,281,956 15,167 2,788,995 2,788,995 1,309,003 1,479,992 47% 1,326,874 17,871 Principal49450.00 Sewer 120,000 120,000 ‐ 120,000 0%‐ ‐ 120,000 120,000 ‐ 120,000 0%‐ ‐ Interest & other49450.00 Sewer 49,650 49,650 24,825 24,825 50% 27,225 2,400 49,650 49,650 24,825 24,825 50% 27,225 2,400 Capital improvements55530.00 Infrastructure 736,500 736,500 ‐ 736,500 0%‐ ‐ 55570.00 Machinery and equipment 90,250 90,250 ‐ 90,250 0%‐ ‐ 55580.00 Software 28,500 28,500 ‐ 28,500 0% 12,118 12,118 855,250 855,250 ‐ 855,250 0% 12,118 12,118 Total Expenditures3,813,895 3,813,895 1,333,828 2,480,067 1,366,217 32,389 Other Financing Uses59203.00 Transfers to other funds 366,000 366,000 183,000 183,000 50% 147,055 (35,945) Total Other Financing Uses366,000 366,000 183,000 183,000 50% 147,055 (35,945) Total Revenues/ Other Financing Sources4,336,842 4,336,842 1,739,965 (2,596,877) 40% 1,684,740 55,225 Total Expenditures/Other Financing Uses4,179,895 4,179,895 1,516,828 2,663,067 36% 1,513,272 (3,556) Net Change156,947 156,947 223,137 66,190 171,468 58,781 City of Prior Lake Water Quality Fund As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)RevenuesStorm Water Charges602‐49420.00‐37120.00 Storm Water Revenue 1,186,699 1,186,699 464,190 (722,509) 39% 452,200 11,990 602‐49420.00‐32250.00 Wetland Application Fee‐ ‐ 450 450 n/a 450 ‐ 1,186,699 1,186,699 464,640 (722,059) 39% 452,650 11,990 Water Charges602‐49420.00‐37160.00 Penalties 4,000 4,000 1,858 (2,142) 46% 676 1,182 4,000 4,000 1,858 (2,142) 46% 676 1,182 Total Operating Revenue1,190,699 1,190,699 466,498 (724,201) 39% 453,326 13,172 Non‐Operating RevenueIntergovernmental602‐00000.00‐33422.10 State Aids/Grants‐ ‐ 27,000 27,000 n/a‐ 27,000 602‐49420.00‐33610.20 County‐City Aids/Grants‐ ‐ 6,300 6,300 n/a‐ 6,300 ‐ ‐ 33,300 33,300 n/a‐ 33,300 Interest (losses) on investments602‐00000.00‐36210.00 Interest Earnings 14,500 14,500 15,649 1,149 108% 15,947 (298) 602‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (15,171) (15,171) n/a 26,578 (41,749) 14,500 14,500 478 (14,022) 3% 42,525 (42,047) Miscellaneous Revenues602‐00000.00‐36212.00 Miscellaneous Revenue‐ ‐ 5,339 5,339 n/a‐ 5,339 ‐ ‐ 5,339 5,339 n/a‐ 5,339 Total Non‐Operating Revenue14,500 14,500 39,117 24,617 270% 42,525 (3,408) Total Revenues1,205,199 1,205,199 505,615 (699,584) 42% 495,851 9,764 COMPARATIVE City of Prior Lake Water Quality Fund As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)COMPARATIVETotal ExpendituresPersonnel and current expenditures (excluding depreciation)49420.00 Water Quality 622,893 698,264 333,860 364,404 48% 187,560 (146,300) 622,893 698,264 333,860 364,404 48% 187,560 (146,300) Capital improvements55530.00 Infrastructure 359,500 359,500 5,013 354,487 1% 31,069 26,056 359,500 359,500 5,013 354,487 1% 31,069 26,056 Total Expenditures982,393 1,057,764 338,873 718,891 32% 218,629 (120,244) Other Financing Uses59203.00 Transfers to other funds 127,000 127,000 63,500 63,500 50% 42,890 (20,610) Total Other Financing Uses127,000 127,000 63,500 63,500 50% 42,890 (20,610) Total Revenues/ Other Financing Sources1,205,199 1,205,199 505,615 (699,584) 42% 495,851 9,764 Total Expenditures/Other Financing Uses1,109,393 1,184,764 402,373 782,391 34% 261,519 (140,854) Net Change95,806 20,435 103,242 82,807 234,332 (131,090) City of Prior Lake Economic Development Authority Special Revenue Fund As of 6/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED6/30/2020Positive (Negative)RevenuesTaxes240‐00000.00‐31010.00 Current Property Taxes 349,750 349,750 185,108 (164,642) 53% 140,293 44,815 Taxes349,750 349,750 185,108 (164,642) 53% 140,293 44,815 Charges for Services240‐46503.00‐34760.02 Facility Rental ‐ EDA 8,450 8,450 2,435 (6,015) 29% 3,415 (980) Charges for Services 8,450 8,450 2,435 (6,015) 29% 3,415 (980) Interest (losses) on investments240‐00000.00‐36210.00 Interest Earnings 5,300 5,300 3,356 (1,944) 63% 3,612 (256) 240‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (3,396) (3,396) n/a 5,468 (8,864) Interest (losses) on investments 5,300 5,300 (40) (5,340) ‐1% 9,080 9,120 Contributions and Donations240‐00000.00‐36230.00 Contributions and Donations‐ ‐ ‐ ‐ n/a 4,900 (4,900) Contributions and Donations‐ ‐ ‐ ‐ n/a 4,900 (4,900) Transfers In 240‐00000.00‐39203.00 Transfer from Other Funds‐ ‐ ‐ ‐ n/a 161,250 (161,250) Transfers In ‐ ‐ ‐ ‐ n/a 161,250 (161,250) Total Revenues363,500 363,500 187,503 (175,997) 52% 318,938 (131,435) ExpendituresFunction: Economic Development46500.00 ECONOMIC DEVELOPMENT 519,294 519,294 65,846 453,448 13% 167,529 101,683 46503.00 TECH VILLAGE INCUBATOR 5,500 5,500 1,150 4,350 21% 1,062 (88) Total Expenditures524,794 524,794 66,996 457,798 13% 168,591 101,595 Net Change(161,294) (161,294) 120,507 150,347 COMPARATIVE