Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
05(C) - Approval of the Preliminary 1st Quarter 2021 Financial Reports Report
City of Prior Lake General Fund Summary - Comparison to Prior Year As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive (Negative) USED3/31/2020Positive (Negative)RevenuesTaxes 9,433,959 9,433,959 ‐ (9,433,959) 0%‐ ‐ Licenses and Permits795,551 795,551 211,290 (584,261) 27% 171,632 39,658 Intergovernmental 2,160,235 2,160,235 625,416 (1,534,819) 29% 593,280 32,136 Charges for Services1,800,172 1,800,172 516,367 (1,283,805) 29% 395,945 120,422 Fines and Forfeitures‐ ‐ ‐ ‐ n/a 20 (20) Interest (losses) on investments86,800 86,800 (30,846) (117,646) ‐36% 74,760 (105,606) Other154,000 154,000 36,629 (117,371) 24% 26,221 10,408 Transfers in 523,000 523,000 130,750 (392,250) 25% 117,500 13,250 Total Revenues14,953,717 14,953,717 1,489,606 (13,464,111) 10% 1,379,358 110,248 ExpendituresGeneral Government3,269,647 3,287,247 690,207 2,597,040 21% 665,644 (24,563) Public Safety7,154,410 7,273,514 1,443,630 5,829,884 20% 1,353,824 (89,806) Public Works 2,245,916 2,245,916 489,080 1,756,836 22% 455,537 (33,543) Culture and Recreation2,154,169 2,154,169 278,105 1,876,064 13% 337,924 59,819 Transfer to other funds253,575 253,575 ‐ 253,575 0% 161,250 161,250 Total Expenditures15,077,717 15,214,421 2,901,022 12,313,399 19% 2,974,179 73,157 Net Change(124,000) (260,704) (1,411,416) (1,594,821) COMPARATIVE City of Prior Lake General Fund Revenues As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)Taxes101 31010.00 Current Property Taxes ‐ General Purpos 8,331,582 8,331,582 0.00 (8,331,582) 0%‐ ‐ 101 31040.00 Fiscal Disparities 1,102,377 1,102,377 0.00 (1,102,377) 0%‐ ‐ Taxes9,433,959 9,433,959 ‐ (9,433,959) 0%‐ ‐ Licenses and Permits101 32100.00 Business Licenses 735 735 735 ‐ 100% 840 (105) 101 32110.00 Liquor Licenses 75,790 75,790 21,100 (54,690) 28% 150 20,950 101 32160.00 Refuse Haulers 4,500 4,500 ‐ (4,500) 0%‐ ‐ 101 32175.00 Public Private Gathering Permit 720 720 150 (570) 21% 150 ‐ 101 32180.00 Cigarette Licenses 2,040 2,040 1,785 (255) 88% 2,040 (255) 101 32190.00 Community Event Application‐ ‐ 150 150 n/a 50 100 101 32210.00 Building Permits 546,300 546,300 158,734 (387,566) 29% 136,626 22,108 101 32215.00 Mechanical Permits 87,300 87,300 12,611 (74,689) 14% 17,241 (4,630) 101 32230.00 Plumbing Permits 62,573 62,573 12,007 (50,566) 19% 10,967 1,040 101 32231.00 Sewer/Water Inspection 7,063 7,063 1,948 (5,115) 28% 1,638 310 101 32232.00 Plumbing Registrations 1,250 1,250 990 (260) 79% 390 600 101 32260.00 Burning Permits 4,000 4,000 1,080 3,000 27% 720 360 101 32270.00 Short‐term Rental Fee 3,280 3,280 ‐ (3,280) 0% 820 (820) Licenses and Permits 795,551 795,551 211,290 (584,261) 27% 171,632 39,658 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 8,050 (6,950) 54%‐ 8,050 101 33418.00 State Road & Bridge Aid 377,000 377,000 201,019 (175,981) 53% 209,398 (8,379) 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 ‐ (65,000) 0%‐ ‐ 102 33422.11 State Aids/Grants ‐ Operating Police 4,200 4,200 ‐ (4,200) 0%‐ ‐ 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 200,000 (500,000) 29% 200,000 ‐ Intergovernmental 2,160,235 2,160,235 625,416 (1,534,819) 29% 593,280 32,136 COMPARATIVE City of Prior Lake General Fund Revenues As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)COMPARATIVECharges for Services101 31810.00 Franchise Taxes 637,000 637,000 ‐ (637,000) 0%‐ ‐ 101 34103.00 Zoning & Subdivision Fees 30,000 30,000 8,022 (21,978) 27% 6,095 1,927 101 34104.00 Plan Check Fees 300,424 300,424 86,550 (213,874) 29% 73,431 13,119 101 34105.00 Sale of Maps/Publications ‐ Reports 500 500 90 (410) 18% 185 (95) 101 34107.00 Assessment Searches ‐ Reports 500 500 175 (325) 35% 125 50 101 34109.00 Project Admin/Eng Fees 122,000 122,000 35,972 (86,028) 29% 30,505 5,467 101 34203.00 Accident/Warrant Reports ‐ Reports 300 300 ‐ (300) 0%‐ ‐ 101 34731.00 Adult League Fees 10,000 10,000 5,878 (4,122) 59% 7,815 (1,937) 101 34735.00 Recreation Program Fees 43,000 43,000 49,345 6,345 115% 32,430 16,915 101 34735.01 Recreation Program Fees Regular 9,000 9,000 941 (8,059) 10% 5,550 (4,609) 101 34760.01 Facility Rental ‐ Regular 37,349 37,349 10,006 (27,343) 27% 9,337 669 101 34761.00 Studio/Pavilion Rental 24,000 24,000 13,171 (10,829) 55% 12,510 661 101 34762.00 Park Shelter Rental 83,200 83,200 68,804 (14,396) 83% 29,479 39,325 101 34765.01 Tower Leases 306,324 306,324 225,023 (81,301) 73% 166,932 58,091 101 34780.00 Park Admission Fees 30,000 30,000 ‐ (30,000) 0%‐ ‐ 101 34783.00 City Contract Services 166,575 166,575 12,390 (154,185) 7% 21,551 (9,161) Charges for Services 1,800,172 1,800,172 516,367 (1,283,805) 29% 395,945 120,422 Fines and Forfeitures101 35104.00 Prosecution Restitution‐ ‐ ‐ ‐ n/a 20 (20) Fines and Forfeitures‐ ‐ ‐ ‐ n/a 20 (20) City of Prior Lake General Fund Revenues As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)COMPARATIVEInterest (losses) on investments101 36210.00 Interest Earnings 86,800 86,800 37,102 (49,698) 43% 38,544 (1,442) 101 36215.00 Amortization ‐ Premium/Discount‐ ‐ (20,637) (20,637) n/a (11,706) (8,931) 101 36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (47,311) (47,311) n/a 47,922 (95,233) Interest (losses) on investments 86,800 86,800 (30,846) (117,646) ‐36% 74,760 (105,606) Other Miscellaneous Revenues101 36211.00 Developer Agreements 130,000 130,000 12,500 (117,500) 10% 3,000 9,500 101 36212.00 Miscellaneous Revenue 24,000 24,000 15,186 (8,814) 63% 13,066 2,120 101 36230.00 Contributions & Donations‐ ‐ 3,800 3,800 n/a 10,085 (6,285) 101 39102.00 Sale of Property‐ ‐ 5,143 5,143 n/a 70 5,073 Other Miscellaneous Revenues 154,000 154,000 36,629 (117,371) 24% 26,221 10,408 Other financing sources101 39203.00 Transfer from Other Funds 523,000 523,000 130,750 (392,250) 25% 117,500 13,250 Other financing sources 523,000 523,000 130,750 (392,250) 25% 117,500 13,250 Total Revenues14,953,717 14,953,717 1,489,606 (13,464,111) 10% 1,379,358 110,248 City of Prior Lake General Fund Expenditures As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)Function: General Government41110.00 MAYOR & COUNCIL74,934 74,934 17,959 56,975 24% 17,959 ‐ 41130.00 ORDINANCE 6,000 6,000 892 5,108 15% 642 (250) 41320.00 ADMINISTRATION 270,152 270,152 71,888 198,264 27% 106,838 34,950 41330.00 BOARDS & COMMISSIONS11,365 11,365 1,153 10,212 10% 1,019 (134) 41400.00 CITY CLERK 122,272 122,272 23,937 98,335 20% 24,574 637 41410.00 ELECTIONS 7,000 7,000 ‐ 7,000 0% 11,478 11,478 41520.00 FINANCE 565,250 565,250 113,365 451,885 20% 91,530 (21,835) 41540.00 INTERNAL AUDITING 41,200 41,200 9,190 32,010 22% 6,690 (2,500) 41550.00 ASSESSING 224,260 224,260 ‐ 224,260 0%‐ ‐ 41610.00 LEGAL 180,000 180,000 37,638 142,362 21% 40,456 2,818 41820.00 HUMAN RESOURCES 316,074 333,674 66,986 266,688 20% 38,424 (28,562) 41830.00 COMMUNICATIONS 162,070 162,070 39,901 122,169 25% 39,009 (892) 41910.00 COMMUNITY DEVELOPMENT379,924 379,924 62,773 317,151 17% 58,638 (4,135) 41920.00 INFORMATION TECHNOLOGY 385,116 385,116 122,203 262,913 32% 115,051 (7,152) 41940.00 FACILITIES ‐ CITY HALL 524,030 524,030 122,322 401,708 23% 113,336 (8,986) Total ‐ Function General Government 3,269,647 3,287,247 690,207 2,597,040 21% 665,644 (24,563) Function: Public Safety42100.00 POLICE 5,303,369 5,422,473 1,124,542 4,297,931 21% 1,076,590 (47,952) 42200.00 FIRE 1,076,350 1,076,350 173,549 902,801 16% 146,761 (26,788) 42400.00 BUILDING INSPECTION 730,801 730,801 140,045 590,756 19% 125,102 (14,943) 42500.00 EMERGENCY MANAGEMENT15,090 15,090 694 14,396 5% 176 (518) 42700.00 ANIMAL CONTROL28,800 28,800 4,800 24,000 17% 5,195 395 Total ‐ Function Public Safety 7,154,410 7,273,514 1,443,630 5,829,884 20% 1,353,824 (89,806) Function: Public Works43050.00 ENGINEERING 389,105 389,105 77,582 311,523 20% 72,192 (5,390) 43100.00 STREET 1,365,438 1,365,438 303,290 1,062,148 22% 276,208 (27,082) 43400.00 CENTRAL GARAGE 491,373 491,373 108,208 383,165 22% 107,137 (1,071) Total ‐ Function Public Works 2,245,916 2,245,916 489,080 1,756,836 22% 455,537 (33,543) Function: Culture and Recreation45100.00 RECREATION 481,813 481,813 67,443 414,370 14% 85,310 17,867 45200.00 PARKS 1,604,132 1,604,132 197,913 1,406,219 12% 237,057 39,144 45500.00 LIBRARIES 68,224 68,224 12,749 55,475 19% 15,557 2,808 Total ‐ Function Culture and Recreation 2,154,169 2,154,169 278,105 1,876,064 13% 337,924 59,819 00000.00 Transfer to Other Funds 253,575 253,575 ‐ 253,575 0% 161,250 161,250 Total Expenditures15,077,717 15,214,421 2,901,022 12,313,399 19% 2,974,179 73,157 COMPARATIVE City of Prior LakeExpenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 3/31/2021(Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)GENERAL FUNDFunction: General Government41110.00 MAYOR & COUNCIL 66,234 66,234 15,534 50,700 23% 15,458 (75) 41320.00 ADMINISTRATION 197,222 197,222 40,782 156,440 21% 79,230 38,448 41330.00 BOARDS & COMMISSIONS 10,765 10,765 1,154 9,612 11% 969 (185) 41400.00 CITY CLERK FUNCTIONS 120,422 120,422 23,752 96,670 20% 23,244 (508) 41410.00 ELECTIONS 3,500 3,500 ‐ 3,500 0% 7,628 7,628 41520.00 FINANCE 537,955 537,955 108,692 429,263 20% 86,784 (21,908) 41820.00 HUMAN RESOURCES 271,624 271,624 54,501 217,123 20% 33,065 (21,436) 41830.00 COMMUNICATIONS 128,054 128,054 22,999 105,055 18% 23,384 385 41910.00 COMMUNITY DEVELOPMENT 317,724 317,724 60,141 257,583 19% 55,751 (4,390) 41920.00 INFORMATION TECHNOLOGY 225,935 225,935 44,627 181,308 20% 38,603 (6,024) 41940.00 FACILITIES ‐ CITY HALL 91,018 91,018 6,983 84,035 8% 22,228 15,245 Total ‐ Function General Government 1,970,453 1,970,453 379,164 1,591,289 19% 386,345 7,181 Function: Public Safety42100.00 POLICE 4,736,215 4,822,965 930,936 3,892,029 19% 896,061 (34,875) 42200.00 FIRE 760,123 760,123 101,117 659,006 13% 93,930 (7,187) 42400.00 BUILDING INSPECTION 679,565 679,565 132,602 546,963 20% 122,059 (10,543) Total ‐ Function Public Safety 6,175,903 6,262,653 1,164,655 5,097,998 19% 1,112,050 (52,605) Function: Public Works43050.00 ENGINEERING 350,041 350,041 63,459 286,582 18% 62,992 (466) 43100.00 STREET 503,876 503,876 101,574 402,302 20% 89,214 (12,360) 43400.00 CENTRAL GARAGE 247,198 247,198 47,903 199,295 19% 48,783 880 Total ‐ Function Public Works 1,101,115 1,101,115 212,936 888,179 19% 200,989 (11,947) Function: Culture and Recreation45100.00 RECREATION 360,011 360,011 52,384 307,627 15% 59,272 6,887 45200.00 PARKS 1,081,258 1,081,258 173,951 907,307 16% 186,725 12,774 Total ‐ Function Culture and Recreation 1,441,269 1,441,269 226,335 1,214,934 16% 245,996 19,661 General Fund Payroll Only Expenditures Total 10,688,740 10,775,490 1,983,090 8,792,400 18% 1,945,380 (37,710) EDA FUNDFunction: Economic Development 46500.00 ECONOMIC DEVELOPMENT 135,544 135,544 31,184 104,360 23% 35,399 4,216 EDA Fund Payroll Only Expenditures Total 135,544 135,544 31,184 104,360 23% 35,399 4,216 COMPARATIVE City of Prior LakeExpenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 3/31/2021(Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)COMPARATIVEWATER FUNDFunction: Water41520.00 Finance 76,881 76,881 15,317 61,564 20% 15,273 (44) 49400.00 Water 749,281 749,281 146,790 602,491 20% 150,810 4,020 Water Fund Payroll Only Expenditures Total 826,162 826,162 162,107 664,055 20% 166,083 3,976 SEWER FUNDFunction: Sewer41520.00 Finance 76,881 76,881 15,315 61,566 20% 15,271 (44) 49450.00 Sewer 731,502 731,502 159,475 572,027 22% 178,627 19,152 Sewer Fund Payroll Only Expenditures Total 808,383 808,383 174,790 633,593 22% 193,898 19,108 STORM WATER FUNDFunction: Storm Water49420.00 Water Quality 366,879 366,879 69,192 297,687 19% 73,215 4,023 Storm Water Fund Payroll Only Expenditures Total 366,879 366,879 69,192 297,687 19% 73,215 4,023 City‐Wide Total Payroll Expenditures 12,825,708 12,912,458 2,420,362 10,492,096 19% 2,413,975 (6,387) City of Prior Lake Debt Service Funds As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)RevenuesProperty TaxesCurrent Property Taxes 3,121,498 3,121,498 ‐ (3,121,498) 0%‐ ‐ Special AssessmentsCity Assess. Collections‐ ‐ 15,923 15,923 n/a 25,461 (9,538) County Assess. Collection 446,370 446,370 ‐ (446,370) 0%‐ ‐ Interest (losses) on investmentsInterest Earnings 46,406 46,406 10,821 (35,585) 23% 16,113 (5,292) Unrealized Inv.Gain(Loss)‐ ‐ (14,009) (14,009) n/a 19,322 (33,331) Other Financing SourcesTransfer from Other Funds 1,206,925 1,206,925 ‐ (1,206,925) 0%‐ ‐ Total Revenues4,821,199 4,821,199 12,735 (4,808,464) 0% 60,896 (48,161) ExpendituresDebt ServicePrincipal 4,274,858 4,274,858 ‐ 4,274,858 0%‐ ‐ Interest and Other 965,899 965,899 ‐ 965,899 0%‐ ‐ Bond Issuance Costs 2,870 2,870 ‐ 2,870 0%‐ ‐ Transfers to Other Funds 75,000 75,000 ‐ 75,000 0%‐ ‐ Total Expenditures5,318,627 5,318,627 ‐ 5,318,627 0%‐ ‐ Net Change(497,428) (497,428) 12,735 60,896 COMPARATIVE City of Prior Lake Cable Fund As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)RevenuesCharges for Services210‐41340.00‐34304.00PEG Access Fees 28,000 32,000 ‐ (32,000) 0%‐ ‐ Interest (losses) on investments210‐41340.00‐36210.00Interest Earnings‐ ‐ 372 372 n/a 408 (36) 210‐41340.00‐36225.00Unrealized Inv. Gain (Loss)‐ ‐ (486) (486) n/a 489 (975) Total Revenues28,000 32,000 (114) (32,114) 0% 897 (1,011) ExpendituresCurrent Expenditures210‐41340.00‐52400.20Small Equipment ‐ Technology‐ ‐ 1,258 (1,258) n/a 46 (1,212) 210‐41340.00‐53210.00Telecommunications‐ ‐ ‐ ‐ n/a 3,576 3,576 Capital Outlay210‐41340.00‐55570.00Machinery and Equipment‐ ‐ 3,576 (3,576) n/a 5,495 1,919 Total Expenditures‐ ‐ 4,834 (4,834) n/a 9,117 4,283 Net Change28,000 32,000 (4,948) (8,220) COMPARATIVE City of Prior Lake Capital Park Fund As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)RevenuesCharges for Services225‐45200.00‐34760.01 Facility Rental ‐ Regular 24,000 24,000 6,000 (18,000) 25% 6,000 ‐ 225‐45200.00‐34791.00 Dedication Fees 431,000 431,000 22,752 (408,248) 5%‐ 22,752 Charges for Services 455,000 455,000 28,752 (426,248) 6% 6,000 22,752 Interest (losses) on investments225‐00000.00‐36210.00 Interest Earnings 22,700 22,700 6,527 (16,173) 29% 9,835 (3,308) 225‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (8,438) (8,438) n/a 12,122 (20,560) Interest (losses) on investments 22,700 22,700 (1,911) (24,611) ‐8% 21,957 (23,868) Contributions and donations225‐00000.00‐36230.00 Contributions & Donations 18,597 18,597 9,650 (8,947) 52% 1,725 7,925 Contributions and donations 18,597 18,597 9,650 (8,947) 52% 1,725 7,925 Total Revenues496,297 496,297 36,491 (459,806) 7% 29,682 6,809 Expenditures53100.80 Professional Services‐General‐ ‐ 3,104 (3,104) n/a 7,014 3,910 55020.00 Projects ‐ Engineering‐ ‐ 33,959 (33,959) n/a‐ (33,959) 55530.00 Infrastructure 956,000 956,000 3,117 952,883 0%‐ (3,117) Total Expenditures956,000 956,000 40,180 915,820 4% 7,014 (33,166) Net Change(459,703) (459,703) (3,689) 22,668 COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)RevenuesTaxes410‐00000.00‐31010.00 Current Property Taxes 650,000 650,000 ‐ (650,000) 0%‐ ‐ 410‐00000.00‐31015.00 Current Property Taxes ‐ Debt Service 185,000 185,000 Taxes835,000 835,000 ‐ (650,000) 0%‐ ‐ Interest (losses) on investments410‐00000.00‐36210.00 Interest Earnings 9,600 9,600 2,426 (7,174) 25% 4,162 (1,736) 410‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (3,101) (3,101) n/a 4,876 (7,977) Interest (losses) on investments 9,600 9,600 (675) (10,275) ‐7% 9,038 (9,713) Sale of assets410‐00000.00‐39102.00 Sale of Property‐ ‐ 18,325 18,325 n/a 34,850 (16,525) Sale of assets‐ ‐ 18,325 18,325 n/a 34,850 (16,525) Transfers in410‐00000.00‐39203.00 Transfer from Other Funds 310,000 310,000 77,500 (232,500) 25% 45,000 32,500 Transfers in310,000 310,000 77,500 (232,500) 25% 45,000 32,500 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 95,150 (1,429,450) 6% 88,888 6,262 COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)COMPARATIVEExpendituresPublic SafetyPolice410‐42100.00‐55550.00 Vehicles 212,000 251,933 13,269 238,664 5% 6,494 (6,775) 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 ‐ 740,000 0%‐ ‐ 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 39,234 1,043,599 4% 80,789 41,555 Public WorksStreet410‐43100.00‐55550.00 Vehicles 251,600 251,600 ‐ 251,600 0%‐ ‐ 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 ‐ 20,000 0%‐ ‐ Total Public Works 309,600 309,600 4,400 305,200 1%‐ (4,400) Culture and Recreation/Parks410‐45200.00‐55570.00 Machinery and Equipment 262,500 262,500 48,183 214,317 18% 13,425 (34,758) Total Culture & Recreation 262,500 262,500 48,183 214,317 18% 13,425 (34,758) Water410‐49400.00‐55550.00 Vehicles 83,000 83,000 ‐ 83,000 0%‐ ‐ Sewer410‐49450.00‐55550.00 Vehicles 83,000 83,000 ‐ 83,000 0%‐ ‐ Total Utility 166,000 166,000 ‐ 166,000 0%‐ ‐ Total Expenditures1,816,000 1,855,933 91,817 1,729,116 5% 94,214 2,397 Net Change(106,400) (146,333) 3,333 (5,326) City of Prior Lake Revolving Park Equipment Fund As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)RevenuesTaxes430‐00000.00‐31010.00 Current Property Taxes 375,000 375,000 ‐ (375,000) 0%‐ ‐ Taxes375,000 375,000 ‐ (375,000) 0%‐ ‐ Interest (losses) on investments430‐00000.00‐36210.00 Interest Earnings 10,500 10,500 4,746 (5,754) 45% 4,865 (119) 430‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (6,142) (6,142) n/a 5,829 (11,971) Interest (losses) on investments 10,500 10,500 (1,396) (11,896) ‐13% 10,694 (12,090) Total Revenues385,500 385,500 (1,396) (386,896) 0% 10,694 (12,090) ExpendituresCulture and Recreation/Parks430‐45200.00‐55530.00 Infrastructure 525,000 525,000 ‐ 525,000 0% 4,475 4,475 Total Culture & Recreation 525,000 525,000 ‐ 525,000 0% 4,475 4,475 Total Expenditures525,000 525,000 ‐ 525,000 0% 4,475 4,475 Net Change(139,500) (139,500) (1,396) 6,219 COMPARATIVE City of Prior Lake Facilities Management Fund As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)RevenuesTaxes440‐00000.00‐31010.00 Current Property Taxes80,000 80,000 ‐ (80,000) 0%‐ ‐ Taxes80,000 80,000 ‐ (80,000) 0%‐ ‐ Interest (losses) on investments440‐00000.00‐36210.00 Interest Earnings 5,800 5,800 1,975 (3,825) 34% 2,568 (593) 440‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (2,564) (2,564) n/a 3,019 (5,583) Interest (losses) on investments5,800 5,800 (589) (6,389) ‐10% 5,587 (6,176) Transfers in440‐00000.00‐39203.00 Transfer from Other Funds 130,000 130,000 32,500 (97,500) 25% 24,750 7,750 Transfers in130,000 130,000 32,500 (97,500) 25% 24,750 7,750 Total Revenues215,800 215,800 31,911 (183,889) 15% 30,337 1,574 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 ‐ 240,000 0%‐ ‐ Total ‐ Function General Government240,000 240,000 10,979 229,021 5% 10,660 (319) 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 ‐ 120,000 0%‐ ‐ Total ‐ Function Public Safety142,500 142,500 ‐ 142,500 0%‐ ‐ 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 10,979 436,621 2% 10,660 (319) Net Change(231,800) (231,800) 20,932 19,677 COMPARATIVE City of Prior Lake Permanent Improvement Revolving Fund As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)RevenuesTaxes450‐00000.00‐31010.00 Property Taxes ‐ General Purpose 120,000 120,000 ‐ (120,000) 0%‐ ‐ Taxes120,000 120,000 ‐ (120,000) 0%‐ ‐ Special Assessments450‐00000.00‐36101.00 City Assess. Collections 173,000 173,000 6,037 (166,963) 3% 5,774 263 450‐00000.00‐36102.00 County Assess. Collection‐ ‐ ‐ ‐ n/a‐ ‐ 173,000 173,000 6,037 (166,963) 3% 5,774 263 Interest (losses) on investments450‐00000.00‐36210.00 Interest Earnings 7,800 7,800 1,356 (6,444) 17% 3,739 (2,383) 450‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (1,759) (1,759) n/a 3,871 (5,630) Interest (losses) on investments 7,800 7,800 (403) (8,203) ‐5% 7,610 (8,013) 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 5,634 (295,166) 2% 271,319 (265,685) ExpendituresOTHER FINANCING USESTransfers out450‐80000.00‐59203.00 Transfers to Other Funds 287,150 287,150 ‐ 287,150 0%‐ ‐ Total Expenditures287,150 287,150 ‐ 287,150 0%‐ ‐ Net Change13,650 13,650 5,634 271,319 COMPARATIVE City of Prior Lake Water Fund As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)RevenuesOperating RevenueWater Charges601‐49400.00‐37100.00 Utility Receipts ‐ Water 3,146,749 3,146,749 119,471 (3,027,278) 4% 143,738 (24,267) 601‐49400.00‐37160.00 Penalties 20,000 20,000 3,490 (16,510) 17% 2,629 861 3,166,749 3,166,749 122,961 (3,043,788) 4% 146,367 (23,406) Capital Facility charges601‐49400.00‐37110.00 Utility Base Fee Revenue 1,140,200 1,140,200 63,227 (1,076,973) 6% 14,994 48,233 1,140,200 1,140,200 63,227 (1,076,973) 6% 14,994 48,233 Meter Sales601‐49400.00‐37170.00 Water Meter Sales 79,825 79,825 23,106 (56,719) 29% 17,309 5,797 601‐49400.00‐37175.00 Pressure Reducers 25,000 25,000 5,074 (19,926) 20% 3,977 1,097 104,825 104,825 28,180 (76,645) 27% 21,286 6,894 Total Operating Revenue4,411,774 4,411,774 214,368 (4,197,406) 5% 182,647 31,721 Non‐Operating RevenueIntergovernmental601‐00000.00‐33422.15 State Aids/Grants ‐ Operating Public Wor‐ ‐ 58 58 n/a‐ 58 ‐ ‐ 58 58 n/a‐ 58 Interest (losses) on investments601‐00000.00‐36210.00 Interest Earnings 54,775 54,775 21,561 (33,214) 39% 26,858 (5,297) 601‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (28,183) (28,183) n/a 35,162 (63,345) 54,775 54,775 (6,622) (61,397) ‐12% 62,020 (68,642) Miscellaneous Revenues601‐00000.00‐36212.00 Miscellaneous Revenue‐ ‐ 100 100 n/a 115 (15) 601‐49400.00‐37190.00 Miscellaneous Revenue Adj‐ ‐ 2 2 n/a 6 (4) ‐ ‐ 102 102 ‐ 121 (19) Total Non‐Operating Revenue54,775 54,775 (6,462) (61,237) ‐12% 62,141 (68,603) Total Revenues4,466,549 4,466,549 207,906 (4,258,643) 5% 244,788 (36,882) COMPARATIVE City of Prior Lake Water Fund As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)COMPARATIVETotal ExpendituresPersonnel and current expenditures (excluding depreciation)41520.00 Finance 108,246 108,246 22,308 85,938 21% 23,920 1,612 49400.00 Water 2,041,449 2,041,449 376,977 1,664,472 18% 371,958 (5,019) 2,149,695 2,149,695 399,285 1,750,410 19% 395,878 (3,407) 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 ‐ 49,650 0%‐ ‐ 49,650 49,650 ‐ 49,650 0%‐ ‐ Capital improvements55530.00 Infrastructure 1,917,500 1,917,500 16,951 1,900,549 1%‐ (16,951) 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 16,951 2,079,799 1% 13,510 (3,441) Total Expenditures4,416,095 4,416,095 416,236 3,999,859 409,388 (6,848) 0.0%Other Financing Uses59203.00 Transfers to other funds 1,035,700 1,035,700 117,500 918,200 92,278 (25,222) Total Other Financing Uses1,035,700 1,035,700 117,500 918,200 92,278 (25,222) Total Revenues/ Other Financing Sources4,466,549 4,466,549 207,906 (4,258,643) 5% 244,788 (36,882) Total Expenditures/Other Financing Uses5,451,795 5,451,795 533,736 4,918,059 10% 501,666 (32,070) Net Change (985,246) (985,246) (325,830) 659,416 (256,878) (4,812) City of Prior Lake Sewer Fund As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)RevenuesSewer Charges604‐49450.00‐37102.00 Utility Receipts ‐ Sewer 1,717,840 1,717,840 (97,643) (1,815,483) ‐6% (64,581) (33,062) 604‐49450.00‐37104.00 Utility Recpt‐Sewer MCES 1,625,587 1,625,587 272,294 (1,353,293) 17% 261,619 10,675 604‐49450.00‐37160.00 Penalties 20,000 20,000 5,416 (14,584) 27% 3,971 1,445 3,363,427 3,363,427 180,067 (3,183,360) 5% 201,009 (20,942) Capital Facility charges604‐49450.00‐37110.00 Utility Base Fee Revenue 953,615 953,615 59,123 (894,492) 6% 14,995 44,128 953,615 953,615 59,123 (894,492) 6% 14,995 44,128 Total Operating Revenue4,317,042 4,317,042 239,190 (4,077,852) 6% 216,004 23,186 Non‐Operating RevenueInterest (losses) on investments604‐00000.00‐36210.00 Interest Earnings 19,800 19,800 10,045 (9,755) 51% 9,544 501 604‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (13,407) (13,407) n/a 11,924 (25,331) 19,800 19,800 (3,362) (23,162) ‐17% 21,468 (24,830) Total Non‐Operating Revenue19,800 19,800 (3,362) (23,162) ‐17% 21,468 (24,830) Total Revenue4,336,842 4,336,842 235,828 (4,101,014) 5% 237,472 (1,644) COMPARATIVE City of Prior Lake Sewer Fund As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)COMPARATIVETotal ExpendituresPersonnel and current expenditures (excluding depreciation)41520.00 Finance 107,721 107,721 22,305 85,416 21% 23,908 1,603 49450.00 Sewer 2,681,274 2,681,274 643,350 2,037,924 24% 641,860 (1,490) 2,788,995 2,788,995 665,655 2,123,340 24% 665,768 113 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 ‐ 49,650 0%‐ ‐ 49,650 49,650 ‐ 49,650 0%‐ ‐ 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 665,655 3,148,240 677,886 12,231 Other Financing Uses59203.00 Transfers to other funds 366,000 366,000 91,500 274,500 25% 73,527 (17,973) Total Other Financing Uses366,000 366,000 91,500 274,500 25% 73,527 (17,973) Total Revenues/ Other Financing Sources4,336,842 4,336,842 235,828 (4,101,014) 5% 237,472 (1,644) Total Expenditures/Other Financing Uses4,179,895 4,179,895 757,155 3,422,740 18% 751,413 (5,742) Net Change156,947 156,947 (521,327) (678,274) (513,941) 4,098 City of Prior Lake Water Quality Fund As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)RevenuesStorm Water Charges602‐49420.00‐37120.00 Storm Water Revenue 1,186,699 1,186,699 65,186 (1,121,513) 5% 63,671 1,515 1,186,699 1,186,699 65,186 (1,121,513) 5% 63,671 1,515 Water Charges602‐49420.00‐37160.00 Penalties 4,000 4,000 773 (3,227) 19% 676 97 4,000 4,000 773 (3,227) 19% 676 97 Total Operating Revenue1,190,699 1,190,699 65,959 (1,124,740) 6% 64,347 1,612 Non‐Operating RevenueIntergovernmental602‐49420.00‐33610.20 County‐City Aids/Grants‐ ‐ 6,300 6,300 n/a‐ 6,300 ‐ ‐ 6,300 6,300 n/a‐ 6,300 Interest (losses) on investments602‐00000.00‐36210.00 Interest Earnings 14,500 14,500 7,661 (6,839) 53% 7,832 (171) 602‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (10,064) (10,064) n/a 9,534 (19,598) 14,500 14,500 (2,403) (16,903) ‐17% 17,366 (19,769) Total Non‐Operating Revenue14,500 14,500 3,897 (10,603) 27% 17,366 (13,469) Total Revenues1,205,199 1,205,199 69,856 (1,135,343) 6% 81,713 (11,857) COMPARATIVE City of Prior Lake Water Quality Fund As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)COMPARATIVETotal ExpendituresPersonnel and current expenditures (excluding depreciation)49420.00 Water Quality 622,893 698,264 113,396 584,868 16% 99,441 (13,955) 622,893 698,264 113,396 584,868 16% 99,441 (13,955) Capital improvements55530.00 Infrastructure 359,500 359,500 5,013 354,487 1% 29,535 24,522 359,500 359,500 5,013 354,487 1% 29,535 24,522 Total Expenditures982,393 1,057,764 118,409 939,355 11% 128,976 10,567 Other Financing Uses59203.00 Transfers to other funds 127,000 127,000 31,750 95,250 25% 21,445 (10,305) Total Other Financing Uses127,000 127,000 31,750 95,250 25% 21,445 (10,305) Total Revenues/ Other Financing Sources1,205,199 1,205,199 69,856 (1,135,343) 6% 81,713 (11,857) Total Expenditures/Other Financing Uses1,109,393 1,184,764 150,159 1,034,605 13% 150,421 262 Net Change95,806 20,435 (80,303) (100,738) (68,708) (11,595) City of Prior Lake Economic Development Authority Special Revenue Fund As of 3/31/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED3/31/2020Positive (Negative)RevenuesTaxes240‐00000.00‐31010.00 Current Property Taxes 349,750 349,750 ‐ (349,750) 0%‐ ‐ Taxes349,750 349,750 ‐ (349,750) 0%‐ ‐ Charges for Services240‐46503.00‐34760.02 Facility Rental ‐ EDA 8,450 8,450 1,848 (6,602) 22% 2,945 (1,097) Charges for Services 8,450 8,450 1,848 (6,602) 22% 2,945 (1,097) Interest (losses) on investments240‐00000.00‐36210.00 Interest Earnings 5,300 5,300 1,647 (3,653) 31% 1,538 109 240‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (2,117) (2,117) n/a 1,493 (3,610) Interest (losses) on investments 5,300 5,300 (470) (5,770) ‐9% 3,031 3,501 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 1,378 (362,122) 0% 172,126 (170,748) ExpendituresFunction: Economic Development46500.00 ECONOMIC DEVELOPMENT 519,294 519,294 31,239 488,055 6% 125,204 93,965 46503.00 TECH VILLAGE INCUBATOR 5,500 5,500 1,072 4,428 19% 1,022 (50) Total Expenditures524,794 524,794 32,311 492,483 6% 126,226 93,915 Net Change(161,294) (161,294) (30,933) 45,900 COMPARATIVE