Loading...
HomeMy WebLinkAbout05(D) - Approval of the Preliminary 3rd Quarter 2021 Financial Reports Report City of Prior Lake General Fund Summary - Comparison to Prior Year As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive (Negative) USED9/30/2020Positive (Negative)RevenuesTaxes 9,433,959            9,433,959            5,001,951            (4,432,008)                            53% 4,791,308            210,643                                 Licenses and Permits795,551               795,551               723,863               (71,688)                                  91% 727,083               (3,220)                                    Intergovernmental 2,160,235            2,160,235            1,754,653            (405,582)                                81% 3,472,977            (1,718,324)                            Charges for Services1,800,172            1,800,172            1,635,248            (164,924)                                91% 1,256,012            379,236                                 Fines and Forfeitures‐                         ‐                        38                         38                                           n/a 320                       (282)                                        Interest (losses) on investments86,800                 86,800                 (72,792)                (159,592)                                 ‐84% 182,186               (254,978)                                Other154,000               154,000               441,449               287,449                                 287% 122,269               319,180                                 Transfers in 523,000               523,000               392,250               (130,750)                                75% 352,500               39,750                                   Total Revenues14,953,717         14,953,717         9,876,660            (5,077,057)                            66% 10,904,655         (1,027,995)                            ExpendituresGeneral Government3,269,647            3,287,247            2,420,142            867,105                                 74% 2,344,156            (75,986)                                  Public Safety7,154,410            7,390,514            4,781,501            2,609,013                              65% 4,433,742            (347,759)                                Public Works 2,245,916            2,245,916            1,536,401            709,515                                 68% 1,320,805            (215,596)                                Culture and Recreation2,154,169            2,154,169            1,392,378            761,791                                 65% 1,146,647            (245,731)                                Transfer to other funds253,575               1,053,575            847,753               205,822                                 80% 201,958               (645,795)                                Total Expenditures15,077,717         16,131,421         10,978,175         5,153,246                              68% 9,447,308            (1,530,867)                            Net Change(124,000)              (1,177,704)          (1,101,515)          1,457,347            COMPARATIVE City of Prior Lake General Fund Revenues As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/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,216,640            130,228                                  101 31020.00 Delinquent Property Taxes ‐ General Purp‐                              ‐                             51,295                 51,295                                    n/a 21,907                 29,388                                    101 31040.00 Fiscal Disparities 1,102,377            1,102,377            603,788               (498,589)                                55% 552,761               51,027                                    Taxes9,433,959            9,433,959            5,001,951            (4,432,008)                             53% 4,791,308            210,643                                  Licenses and Permits101 32100.00 Business Licenses 735                       735                       735                        ‐                                               100% 840                       (105)                                        101 32110.00 Liquor Licenses 75,790                 75,790                 71,565                 (4,225)                                     94% 38,290                 33,275                                    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                       660                       (60)                                           92% 170                       490                                          101 32180.00 Cigarette Licenses 2,040                    2,040                    1,785                    (255)                                        88% 2,040                    (255)                                        101 32190.00 Community Event Application‐                              ‐                             4,235                    4,235                                      n/a 450                       3,785                                      101 32210.00 Building Permits 546,300               546,300               538,496               (7,804)                                     99% 569,913               (31,417)                                   101 32211.00 Retainage Forfeiture‐                              ‐                             5,000                    5,000                                      n/a‐                             5,000                                      101 32215.00 Mechanical Permits 87,300                 87,300                 43,031                 (44,269)                                   49% 58,394                 (15,363)                                   101 32230.00 Plumbing Permits 62,573                 62,573                 40,053                 (22,520)                                   64% 40,577                 (524)                                        101 32231.00 Sewer/Water Inspection 7,063                    7,063                    7,618                    555                                          108% 7,424                    194                                          101 32232.00 Plumbing Registrations 1,250                    1,250                    1,950                    700                                          156% 660                       1,290                                      101 32260.00 Burning Permits 4,000                    4,000                    3,400                    3,000                                      85% 2,920                    480                                          101 32270.00 Short‐term Rental Fee 3,280                    3,280                     ‐                             (3,280)                                     0% 820                       (820)                                        Licenses and Permits 795,551               795,551               723,863               (71,688)                                   91% 727,083               (3,220)                                     Intergovernmental101 33160.10 Fed Aids/Grants ‐ Operating Grants‐                              ‐                              ‐                              ‐                                               n/a 1,982,322            (1,982,322)                             101 33160.11 Fed Aids/Grants ‐ Operating Police 10,500                 10,500                 2,085                    (8,415)                                     20% 3,754                    (1,669)                                     101 33401.00 Local Government Aid 11,905                 11,905                  ‐                             (11,905)                                   0%‐                              ‐                                               101 33416.01 State Aid ‐ Police Train 24,000                 24,000                 30,911                 6,911                                      129% 25,405                 5,506                                      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                 41,919                 26,919                                    279%‐                             41,919                                    101 33418.00 State Road & Bridge Aid 377,000               377,000               403,545               26,545                                    107% 376,246               27,299                                    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                 45,518                 (19,482)                                   70% 11,485                 34,033                                    102 33422.11 State Aids/Grants ‐ Operating Police 4,200                    4,200                     ‐                             (4,200)                                     0%‐                              ‐                                               101 33610.11 County Aids/Grants ‐ Operating Grants‐                              ‐                             1,000                    1,000                                      n/a 1,000                     ‐                                               101 33610.11 County Aids/Grants ‐ Operating Police‐                              ‐                              ‐                              ‐                                               n/a‐                              ‐                                               101 33620.00 Township Fire & Resc Aid 430,540               430,540               429,675               (865)                                        100% 365,765               63,910                                    101 33621.00 Liaison Aid 56,090                 56,090                  ‐                             (56,090)                                   0%‐                              ‐                                               101 33631.00 Payment in Lieu of Taxes 700,000               700,000               800,000               100,000                                  114% 700,000               100,000                                  101 33700.11 Miscellaneous Grants ‐ Operating Police‐                              ‐                              ‐                              ‐                                               n/a 6,000                    (6,000)                                     Intergovernmental 2,160,235            2,160,235            1,754,653            (405,582)                                81% 3,472,977            (1,718,324)                             COMPARATIVE City of Prior Lake General Fund Revenues As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)COMPARATIVECharges for Services101 31810.00 Franchise Taxes 637,000               637,000               340,231               (296,769)                                53% 326,001               14,230                                    101 34103.00 Zoning & Subdivision Fees 30,000                 30,000                 38,264                 8,264                                      128% 27,786                 10,478                                    101 34104.00 Plan Check Fees 300,424               300,424               268,360               (32,064)                                   89% 298,722               (30,362)                                   101 34105.00 Sale of Maps/Publications ‐ Reports 500                       500                       1,055                    555                                          211% 375                       680                                          101 34107.00 Assessment Searches ‐ Reports 500                       500                       575                       75                                            115% 1,100                    (525)                                        101 34108.00 Street Chip Seal Fee‐New Development‐                              ‐                             62,590                 62,590                                    n/a‐                             62,590                                    101 34109.00 Project Admin/Eng Fees 122,000               122,000               107,916               (14,084)                                   88% 41,100                 66,816                                    101 34203.00 Accident/Warrant Reports ‐ Reports 300                       300                       40                          (260)                                        13% 35                          5                                              101 34731.00 Adult League Fees 10,000                 10,000                 4,480                    (5,520)                                     45% 270                       4,210                                      101 34735.00 Recreation Program Fees 43,000                 43,000                 87,064                 44,064                                    202% 26,081                 60,983                                    101 34735.01 Recreation Program Fees Regular 9,000                    9,000                    6,310                    (2,690)                                     70% 5,637                    673                                          101 34760.01 Facility Rental ‐ Regular 37,349                 37,349                 31,549                 (5,800)                                     84% 25,762                 5,787                                      101 34761.00 Studio/Pavilion Rental 24,000                 24,000                 23,453                 (547)                                        98% 9,410                    14,043                                    101 34762.00 Park Shelter Rental 83,200                 83,200                 82,840                 (360)                                        100% 84,912                 (2,072)                                     101 34765.01 Tower Leases 306,324               306,324               407,915               101,591                                  133% 299,338               108,577                                  101 34780.00 Park Admission Fees 30,000                 30,000                 36,932                 6,932                                      123% 30,687                 6,245                                      101 34783.00 City Contract Services 166,575               166,575               135,674               (30,901)                                   81% 57,992                 77,682                                    101 36220.16 Prof Services Fee Deposit Bldg Inspectio‐                              ‐                              ‐                              ‐                                               n/a 20,804                 (20,804)                                   Charges for Services 1,800,172            1,800,172            1,635,248            (164,924)                                91% 1,256,012            379,236                                  Fines and Forfeitures101 35101.00 County Court Fines‐                              ‐                              ‐                              ‐                                               n/a 300                       (300)                                        101 35104.00 Prosecution Restitution‐                              ‐                             38                          38                                            n/a 20                          18                                            Fines and Forfeitures‐                              ‐                             38                          38                                            n/a 320                       (282)                                        Interest (losses) on investments101 36210.00 Interest Earnings 86,800                 86,800                 106,889               20,089                                    123% 115,526               (8,637)                                     101 36215.00 Amortization ‐ Premium/Discount‐                              ‐                             (70,073)                (70,073)                                   n/a (46,166)                (23,907)                                   101 36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (109,608)              (109,608)                                n/a 112,826               (222,434)                                Interest (losses) on investments 86,800                 86,800                 (72,792)                (159,592)                                 ‐84% 182,186               (254,978)                                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               332,450               202,450                                  256% 52,062                 280,388                                  101 36212.00 Miscellaneous Revenue 24,000                 24,000                 49,486                 25,486                                    206% 56,893                 (7,407)                                     101 36230.00 Contributions & Donations‐                              ‐                             24,205                 24,205                                    n/a 11,246                 12,959                                    101 39102.00 Sale of Property‐                              ‐                             28,558                 28,558                                    n/a 936                       27,622                                    Other Miscellaneous Revenues 154,000               154,000               441,449               287,449                                  287% 122,269               319,180                                  Other financing sources101 39203.00 Transfer from Other Funds 523,000               523,000               392,250               (130,750)                                75% 352,500               39,750                                    Other financing sources 523,000               523,000               392,250               (130,750)                                75% 352,500               39,750                                     City of Prior Lake General Fund Revenues As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)COMPARATIVETotal Revenues14,953,717         14,953,717         9,876,660            (5,077,057)                             66% 10,904,655         (1,027,995)                              City of Prior Lake General Fund Expenditures As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)Function: General Government41110.00 MAYOR & COUNCIL74,934                 74,934                 52,108                 22,826                                    70% 47,408                 (4,700)                                     41130.00 ORDINANCE 6,000                    6,000                    5,328                    672                                         89% 4,126                    (1,202)                                     41320.00 ADMINISTRATION 270,152               270,152               230,311               39,841                                    85% 247,264               16,953                                    41330.00 BOARDS & COMMISSIONS11,365                 11,365                 5,352                    6,013                                      47% 3,818                    (1,534)                                     41400.00 CITY CLERK 122,272               122,272               84,691                 37,581                                    69% 82,407                 (2,284)                                     41410.00 ELECTIONS 7,000                    7,000                    157                       6,843                                      2% 29,042                 28,885                                    41520.00 FINANCE 565,250               565,250               391,727               173,523                                  69% 337,596               (54,131)                                   41540.00 INTERNAL AUDITING 41,200                 41,200                 40,333                 867                                         98% 31,184                 (9,149)                                     41550.00 ASSESSING 224,260               224,260               220,600               3,660                                      98% 214,200               (6,400)                                     41610.00 LEGAL 180,000               180,000               122,197               57,803                                    68% 137,494               15,297                                    41820.00 HUMAN RESOURCES 316,074               333,674               228,092               105,582                                  68% 208,523               (19,569)                                   41830.00 COMMUNICATIONS 162,070               162,070               114,134               47,936                                    70% 107,281               (6,853)                                     41910.00 COMMUNITY DEVELOPMENT379,924               379,924               241,053               138,871                                  63% 232,734               (8,319)                                     41920.00 INFORMATION TECHNOLOGY 385,116               385,116               290,281               94,835                                    75% 326,345               36,064                                    41940.00 FACILITIES ‐ CITY HALL 524,030               524,030               393,778               130,252                                  75% 334,734               (59,044)                                   Total ‐ Function General Government 3,269,647            3,287,247            2,420,142            867,105                                  74% 2,344,156            (75,986)                                   Function: Public Safety42100.00 POLICE 5,303,369            5,539,473            3,688,950            1,850,523                              67% 3,467,366            (221,584)                                42200.00 FIRE 1,076,350            1,076,350            584,650               491,700                                  54% 486,591               (98,059)                                   42400.00 BUILDING INSPECTION 730,801               730,801               482,158               248,643                                  66% 450,027               (32,131)                                   42500.00 EMERGENCY MANAGEMENT15,090                 15,090                 4,143                    10,947                                    27% 10,163                 6,020                                      42700.00 ANIMAL CONTROL28,800                 28,800                 21,600                 7,200                                      75% 19,595                 (2,005)                                     Total ‐ Function Public Safety 7,154,410            7,390,514            4,781,501            2,609,013                              65% 4,433,742            (347,759)                                Function: Public Works43050.00 ENGINEERING 389,105               389,105               305,497               83,608                                    79% 248,875               (56,622)                                   43100.00 STREET 1,365,438            1,365,438            923,380               442,058                                  68% 721,650               (201,730)                                43400.00 CENTRAL GARAGE 491,373               491,373               307,524               183,849                                  63% 350,280               42,756                                    Total ‐ Function Public Works 2,245,916            2,245,916            1,536,401            709,515                                  68% 1,320,805            (215,596)                                Function: Culture and Recreation45100.00 RECREATION 481,813               481,813               370,346               111,467                                  77% 238,529               (131,817)                                45200.00 PARKS 1,604,132            1,604,132            982,390               621,742                                  61% 867,960               (114,430)                                45500.00 LIBRARIES 68,224                 68,224                 39,642                 28,582                                    58% 40,158                 516                                         Total ‐ Function Culture and Recreation 2,154,169            2,154,169            1,392,378            761,791                                  65% 1,146,647            (245,731)                                00000.00 Transfer to Other Funds 253,575               1,053,575            847,753               205,822                                  80% 201,958               (645,795)                                Total Expenditures15,077,717         16,131,421         10,978,175         5,153,246                              68% 9,447,308            (1,530,867)                             COMPARATIVE City of Prior LakeExpenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 9/30/2021(Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)GENERAL FUNDFunction: General Government41110.00 MAYOR & COUNCIL 66,234                 66,234                    47,597                 18,637                              72% 43,722                     (3,875)                                   41320.00 ADMINISTRATION 197,222               197,222                 165,320               31,902                              84% 174,014                   8,694                                     41330.00 BOARDS & COMMISSIONS 10,765                 10,765                    5,352                   5,413                                50% 3,768                       (1,584)                                   41400.00 CITY CLERK FUNCTIONS 120,422               120,422                 84,276                 36,146                              70% 81,078                     (3,198)                                   41410.00 ELECTIONS 3,500                   3,500                      137                      3,363                                4% 18,366                     18,229                                   41520.00 FINANCE 537,955               537,955                 378,711               159,244                            70% 323,758                   (54,953)                                 41820.00 HUMAN RESOURCES 271,624               271,624                 189,736               81,888                              70% 190,778                   1,042                                     41830.00 COMMUNICATIONS 128,054               128,054                 90,768                 37,286                              71% 78,047                     (12,721)                                 41910.00 COMMUNITY DEVELOPMENT 317,724               317,724                 219,442               98,282                              69% 207,513                   (11,929)                                 41920.00 INFORMATION TECHNOLOGY 225,935               225,935                 155,124               70,811                              69% 102,244                   (52,880)                                 41940.00 FACILITIES ‐ CITY HALL 91,018                 91,018                    47,046                 43,972                              52% 49,472                     2,426                                     Total ‐ Function General Government 1,970,453           1,970,453              1,383,509           586,944                            70% 1,272,760               (110,749)                               Function: Public Safety42100.00 POLICE 4,736,215           4,939,965              3,327,397           1,612,568                         67% 3,165,054               (162,343)                               42200.00 FIRE 760,123               760,123                 368,718               391,405                            49% 342,360                   (26,358)                                 42400.00 BUILDING INSPECTION 679,565               679,565                 466,677               212,888                            69% 432,839                   (33,838)                                 Total ‐ Function Public Safety 6,175,903           6,379,653              4,162,792           2,216,861                         65% 3,940,253               (222,539)                               Function: Public Works43050.00 ENGINEERING 350,041               350,041                 233,016               117,025                            67% 219,975                   (13,041)                                 43100.00 STREET 503,876               503,876                 344,005               159,871                            68% 325,384                   (18,621)                                 43400.00 CENTRAL GARAGE 247,198               247,198                 161,850               85,348                              65% 162,374                   524                                        Total ‐ Function Public Works 1,101,115           1,101,115              738,871               362,244                            67% 707,733                   (31,138)                                 Function: Culture and Recreation45100.00 RECREATION 360,011               360,011                 255,974               104,037                            71% 174,832                   (81,142)                                 45200.00 PARKS 1,081,258           1,081,258              696,441               384,817                            64% 633,348                   (63,093)                                 Total ‐ Function Culture and Recreation 1,441,269           1,441,269              952,415               488,854                            66% 808,180                   (144,235)                               General Fund Payroll Only Expenditures Total 10,688,740         10,892,490            7,237,587           3,654,903                         66% 6,728,926               (508,661)                               EDA FUNDFunction:  Economic Development   46500.00 ECONOMIC DEVELOPMENT 135,544               135,544                 99,413                 36,131                              73% 100,946                   1,533                                     EDA Fund Payroll Only Expenditures Total 135,544               135,544                 99,413                 36,131                              73% 100,946                   1,533                                     COMPARATIVE City of Prior LakeExpenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 9/30/2021(Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)COMPARATIVEWATER FUNDFunction: Water41520.00 Finance 76,881                 76,881                    52,815                 24,066                              69% 52,208                     (607)                                       49400.00 Water 749,281               749,281                 513,491               235,790                            69% 496,586                   (16,905)                                 Water Fund Payroll Only Expenditures Total 826,162               826,162                 566,306               259,856                            69% 548,794                   (17,512)                                 SEWER FUNDFunction: Sewer41520.00 Finance 76,881                 76,881                    52,808                 24,073                              69% 52,266                     (542)                                       49450.00 Sewer 731,502               731,502                 510,438               221,064                            70% 519,425                   8,987                                     Sewer Fund Payroll Only Expenditures Total 808,383               808,383                 563,246               245,137                            70% 571,691                   8,445                                     STORM WATER FUNDFunction: Storm Water49420.00 Water Quality 366,879               366,879                 238,652               128,227                            65% 230,583                   (8,069)                                   Storm Water Fund Payroll Only Expenditures Total 366,879               366,879                 238,652               128,227                            65% 230,583                   (8,069)                                   City‐Wide Total Payroll Expenditures 12,825,708         13,029,458            8,705,204           4,324,254                        67% 8,180,940               (524,264)                                City of Prior Lake Debt Service Funds As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesProperty TaxesCurrent Property Taxes 3,121,498           3,121,498           1,647,105           (1,474,393)                            53% 1,772,196           (125,091)                               Special AssessmentsCity Assess. Collections‐                             ‐                            126,260               126,260                                n/a 69,408                 56,852                                   County Assess. Collection 446,370               446,370               221,181               (225,189)                               50% 243,900               (22,719)                                 Interest (losses) on investmentsInterest Earnings 46,406                 46,406                 38,105                 (8,301)                                   82% 53,133                 (15,028)                                 Unrealized Inv.Gain(Loss)‐                             ‐                            (39,208)               (39,208)                                 n/a 54,880                 (94,088)                                 Other Financing SourcesTransfer from Other Funds 1,206,925           1,206,925           136,678               (1,070,247)                            11% 147,004               (10,326)                                 Bond Proceeds‐                             ‐                            8,876,530           8,876,530                             n/a‐                            8,876,530                             Bond Discount/Premium‐                             ‐                            1,326,442           1,326,442                             n/a‐                            1,326,442                             Total Revenues4,821,199           4,821,199           12,333,093         7,511,894                             256% 2,340,521           9,992,572                             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                                Refunded Bond Escrow Pmts‐                             ‐                            10,048,295         (10,048,295)                         n/a‐                            (10,048,295)                         Bond Issuance Costs 2,870                   2,870                   126,041               (123,171)                               4392% 1,990                   (124,051)                               Transfers to Other Funds 75,000                 75,000                  ‐                            75,000                                   0%‐                             ‐                                             Total Expenditures5,318,627           5,318,627           10,794,705         (5,476,078)                            203% 719,697               (10,075,008)                         Net Change(497,428)             (497,428)             1,538,388           1,620,824           COMPARATIVE City of Prior Lake Cable Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesCharges for Services210‐41340.00‐34304.00PEG Access Fees 28,000                 28,000                 12,036                 (15,964)                                 43% 13,428                 (1,392)                                   Interest (losses) on investments210‐41340.00‐36210.00Interest Earnings‐                             ‐                            1,113                   1,113                                     n/a 1,102                   11                                          210‐41340.00‐36225.00Unrealized Inv. Gain (Loss)‐                             ‐                            (1,107)                  (1,107)                                   n/a 1,297                   (2,404)                                   Total Revenues28,000                 28,000                 12,042                 (15,958)                                 43% 15,827                 (3,785)                                   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 6,398                   2,757                                     Total Expenditures‐                             ‐                            5,048                   (5,048)                                   n/a 11,121                 6,073                                     Net Change28,000                 28,000                 6,994                   4,706                   COMPARATIVE City of Prior Lake Capital Park Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesCharges for Services225‐45200.00‐34760.01 Facility Rental ‐ Regular 24,000                 24,000                 18,000                 (6,000)                                   75% 18,000                  ‐                                             225‐45200.00‐34791.00 Dedication Fees 431,000               431,000               431,502               502                                        100% 150,820               280,682                                Charges for Services 455,000               455,000               449,502               (5,498)                                   99% 168,820               280,682                                Interest (losses) on investments225‐00000.00‐36210.00 Interest Earnings 22,700                 22,700                 17,714                 (4,986)                                   78% 26,504                 (8,790)                                   225‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                             ‐                            (17,741)               (17,741)                                 n/a 32,306                 (50,047)                                 Interest (losses) on investments 22,700                 22,700                 (27)                       (22,727)                                 0% 58,810                 (58,837)                                 Contributions and donations225‐00000.00‐36230.00 Contributions & Donations 18,597                 18,597                 31,981                 13,384                                   172% 3,225                   28,756                                   Contributions and donations 18,597                 18,597                 31,981                 13,384                                   172% 3,225                   28,756                                   Total Revenues496,297               496,297               481,456               (14,841)                                 97% 230,855               250,601                                Expenditures54320.00 Miscellaneous‐                             ‐                            1,197                   (1,197)                                   n/a‐                            (1,197)                                   53100.80 Professional Services‐General‐                             ‐                            12,436                 (12,436)                                 n/a 11,152                 (1,284)                                   55010.00 Projects ‐ Contract Vouchers‐                             ‐                            196,982               (196,982)                               n/a‐                            (196,982)                               55020.00 Projects ‐ Engineering‐                             ‐                            106,042               (106,042)                               n/a 66,899                 (39,143)                                 55530.00 Infrastructure 956,000               956,000               267,472               688,528                                28% 1,551                   (265,921)                               Total Expenditures956,000               956,000               584,129               371,871                                61% 79,602                 (504,527)                               Net Change(459,703)             (459,703)             (102,673)             151,253               COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesTaxes410‐00000.00‐31010.00 Current Property Taxes 650,000               650,000               440,631               (209,369)                                68% 333,930               106,701                                  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% 333,930               106,701                                  Interest (losses) on investments410‐00000.00‐36210.00 Interest Earnings 9,600                    9,600                    7,366                    (2,234)                                     77% 9,059                    (1,693)                                     410‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (7,578)                  (7,578)                                     n/a 10,590                 (18,168)                                   Interest (losses) on investments 9,600                    9,600                    (212)                      (9,812)                                      ‐2% 19,649                 (19,861)                                   Sale of assets410‐00000.00‐39102.00 Sale of Property‐                              ‐                             75,175                 75,175                                    n/a 51,813                 23,362                                    Sale of assets‐                              ‐                             75,175                 75,175                                    n/a 51,813                 23,362                                    Transfers in410‐00000.00‐39203.00 Transfer from Other Funds 310,000               310,000               232,500               (77,500)                                   75% 135,000               97,500                                    Transfers in310,000               310,000               232,500               (77,500)                                   75% 135,000               97,500                                    OTHER FINANCING SOURCESDebt Issued410‐00000.00‐39310.00 G.O. Bond Proceeds 555,000               555,000               494,292               (60,708)                                   89%‐                             494,292                                  Premium on debt issued410‐43100.00‐55110.00 Projects ‐ Bond Discount/Premium‐                              ‐                             50,490                 50,490                                    n/a‐                             50,490                                    555,000               555,000               544,782               (10,218)                                   98%‐                             544,782                                  Total Revenues1,709,600            1,709,600            1,292,876            (416,724)                                76% 540,392               752,484                                  COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)COMPARATIVEExpendituresGeneral GovernmentCommunications410‐42100.00‐55570.00 Machinery & Equipment‐                             32,445                 32,455                 (10)                                           100%‐                             (32,455)                                   Total General Government‐                             32,445                 32,455                 (10)                                           100%‐                             (32,455)                                   Public SafetyPolice410‐42100.00‐55550.00 Vehicles 212,000               251,933               279,136               (27,203)                                   111% 164,252               (114,884)                                410‐42100.00‐55570.00 Machinery & Equipment 38,900                 38,900                 38,965                 (65)                                           100% 221,611               182,646                                  Fire410‐42200.00‐55070.00 Projects ‐ Bond Issuance Costs‐                              ‐                             7,888                    (7,888)                                     n/a‐                             (7,888)                                     410‐42200.00‐55550.00 Vehicles 740,000               740,000               24,615                 715,385                                  3% 46,009                 21,394                                    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                 33,276                  ‐                                               95% 31,907                 (1,369)                                     Total Public Safety 1,077,900            1,117,833            383,880               732,229                                  34% 512,494               128,614                                  Public WorksStreet410‐43100.00‐55550.00 Vehicles 251,600               251,600               207,140               44,460                                    82% 308,465               101,325                                  410‐43100.00‐55570.00 Machinery & Equipment 38,000                 38,000                 31,745                 6,255                                      84% 41,550                 9,805                                      Central Garage410‐43400.00‐55550.00 Vehicles 20,000                 20,000                 19,937                 63                                            100% 15,333                 (4,604)                                     Total Public Works 309,600               309,600               258,822               50,778                                    84% 365,348               106,526                                  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               78,429                 184,071                                  30% 63,384                 (15,045)                                   Total Culture & Recreation 262,500               262,500               299,950               (37,450)                                   114% 63,384                 (236,566)                                Water410‐49400.00‐55550.00 Vehicles 83,000                 83,000                 21,412                 61,588                                    26%‐                             (21,412)                                   Sewer410‐49450.00‐55550.00 Vehicles 83,000                 83,000                 96,968                 (13,968)                                   117%‐                             (96,968)                                   Total Utility 166,000               166,000               118,380               47,620                                    71%‐                             (118,380)                                 City of Prior Lake Revolving Equipment Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)COMPARATIVETotal Expenditures1,816,000            1,888,378            1,093,487            793,167                                  58% 941,226               (152,261)                                Net Change(106,400)              (178,778)              199,389               (400,834)               City of Prior Lake Revolving Park Equipment Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesTaxes430‐00000.00‐31010.00 Current Property Taxes 375,000               375,000               198,250               (176,750)                                53% 170,252               27,998                                    Taxes375,000               375,000               198,250               (176,750)                                53% 170,252               27,998                                    Interest (losses) on investments430‐00000.00‐36210.00 Interest Earnings 10,500                 10,500                 13,939                 3,439                                      133% 14,204                 (265)                                        430‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (13,722)                (13,722)                                   n/a 16,220                 (29,942)                                   Interest (losses) on investments 10,500                 10,500                 217                       (10,283)                                   2% 30,424                 (30,207)                                   Total Revenues385,500               385,500               198,467               (187,033)                                51% 200,676               (2,209)                                     ExpendituresCulture and Recreation/Parks430‐45200.00‐55020.00 Projects ‐ Engineering‐                              ‐                             14,236                 (14,236)                                   n/a‐                             (14,236)                                   430‐45200.00‐55530.00 Infrastructure 525,000               525,000               18,811                 506,189                                  4% 30,350                 11,539                                    Transfers to other funds430‐80000.00‐59203.00 Transfers to other funds‐                              ‐                             414,000               (414,000)                                n/a‐                             (414,000)                                Total Culture & Recreation 525,000               525,000               447,047               77,953                                    85% 30,350                 (416,697)                                Total Expenditures525,000               525,000               447,047               77,953                                    85% 30,350                 (416,697)                                Net Change(139,500)              (139,500)              (248,580)              170,326               COMPARATIVE City of Prior Lake Facilities Management Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesTaxes440‐00000.00‐31010.00 Current Property Taxes80,000                  80,000                  42,094                  (37,906)                                  53% 15,776                  26,318                                   Taxes80,000                  80,000                  42,094                  (37,906)                                  53% 15,776                  26,318                                   Interest (losses) on investments440‐00000.00‐36210.00 Interest Earnings 5,800                    5,800                    7,866                    2,066                                      136% 7,280                    586                                         440‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (8,583)                   (8,583)                                    n/a 8,668                    (17,251)                                  Interest (losses) on investments5,800                    5,800                    (717)                      (6,517)                                     ‐12% 15,948                  (16,665)                                  Transfers in440‐00000.00‐39203.00 Transfer from Other Funds 130,000               930,000               897,500               (32,500)                                  97% 74,250                  823,250                                 Transfers in130,000               930,000               897,500               (32,500)                                  97% 74,250                  823,250                                 Total Revenues215,800               1,015,800            938,877               (76,923)                                  92% 105,974               832,903                                 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,236                  224,764                                 6%‐                             (15,236)                                  Total ‐ Function General Government240,000               240,000               26,215                  213,785                                 11% 10,660                  (15,555)                                  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% 10,357                  (5,628)                                    Total ‐ Function Public Safety142,500               142,500               15,985                  126,515                                 11% 10,357                  (5,628)                                    Function: Public Works43400.00 CENTRAL GARAGE 50,100                  50,100                  14,412                  35,688                                    29%‐                             (14,412)                                   Total ‐ Function Public Works50,100                  50,100                  14,412                  35,688                                    29%‐                             (14,412)                                   Function: Culture and Recreation45500.00 LIBRARIES 15,000                  15,000                   ‐                             15,000                                   0% 50,958                  50,958                                   Total ‐ Function Culture and Recreation15,000                  15,000                   ‐                             15,000                                   0% 50,958                  50,958                                   Function: Water49400.00 Building & Building Improvements‐                              ‐                              ‐                              ‐                                               n/a 6,885                    6,885                                      Total ‐ Function Culture and Recreation‐                              ‐                              ‐                              ‐                                               n/a 6,885                    6,885                                      Total Expenditures447,600               447,600               56,612                  390,988                                 13% 78,860                  22,248                                   Net Change(231,800)              568,200               882,265               27,114                  COMPARATIVE City of Prior Lake Permanent Improvement Revolving Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesTaxes450‐00000.00‐31010.00 Property Taxes  ‐ General Purpose 120,000               120,000               63,141                 (56,859)                             53% 42,727                 20,414                                    Taxes120,000               120,000               63,141                 (56,859)                             53% 42,727                 20,414                                    Special Assessments450‐00000.00‐36101.00 City Assess. Collections 173,000               173,000               15,307                 (157,693)                           9% 78,811                 (63,504)                                   450‐00000.00‐36102.00 County Assess. Collection‐                              ‐                             67,155                 67,155                               n/a 76,167                 (9,012)                                     173,000               173,000               82,462                 (90,538)                             48% 154,978               (72,516)                                   Interest (losses) on investments450‐00000.00‐36210.00 Interest Earnings 7,800                    7,800                    4,487                    (3,313)                               58% 9,759                    (5,272)                                     450‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (4,570)                  (4,570)                               n/a 13,416                 (17,986)                                   Interest (losses) on investments 7,800                    7,800                    (83)                        (7,883)                                ‐1% 23,175                 (23,258)                                   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               145,520               (155,280)                           48% 478,815               (333,295)                                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                 129,445               (141,095)              COMPARATIVE City of Prior Lake Water Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesOperating RevenueWater Charges601‐49400.00‐37100.00 Utility Receipts ‐ Water 3,146,749            3,146,749            2,316,679            (830,070)                                74% 2,291,243            25,436                                    601‐49400.00‐37160.00 Penalties 20,000                 20,000                 13,271                 (6,729)                                     66% 7,088                    6,183                                      3,166,749            3,166,749            2,329,950            (836,799)                                74% 2,298,331            31,619                                    Capital Facility charges601‐49400.00‐37110.00 Utility Base Fee Revenue 1,140,200            1,140,200            686,027               (454,173)                                60% 152,381               533,646                                  1,140,200            1,140,200            686,027               (454,173)                                60% 152,381               533,646                                  Meter Sales601‐49400.00‐37170.00 Water Meter Sales 79,825                 79,825                 65,185                 (14,640)                                   82% 76,706                 (11,521)                                   601‐49400.00‐37175.00 Pressure Reducers 25,000                 25,000                 15,342                 (9,658)                                     61% 16,300                 (958)                                        104,825               104,825               80,527                 (24,298)                                   77% 93,006                 (12,479)                                   Total Operating Revenue4,411,774            4,411,774            3,096,504            (1,315,270)                             70% 2,543,718            552,786                                  Non‐Operating RevenueIntergovernmental601‐00000.00‐33422.15 State Aids/Grants ‐ Operating Public Wor‐                              ‐                             403                       403                                          n/a 1,464                    (1,061)                                     ‐                              ‐                             403                       403                                          n/a 1,464                    (1,061)                                     Interest (losses) on investments601‐00000.00‐36210.00 Interest Earnings 54,775                 54,775                 62,947                 8,172                                      115% 72,307                 (9,360)                                     601‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (62,867)                (62,867)                                   n/a 86,653                 (149,520)                                54,775                 54,775                 80                          (54,695)                                   0% 158,960               (158,880)                                Miscellaneous Revenues601‐00000.00‐36212.00 Miscellaneous Revenue‐                              ‐                             11,496                 11,496                                    n/a 11,520                 (24)                                           601‐00000.00‐36102.00 County Assess Collection‐                              ‐                             37,305                 37,305                                    n/a 51,255                 (13,950)                                   601‐49400.00‐37190.00 Miscellaneous Revenue Adj‐                              ‐                             (72)                        (72)                                           n/a‐                             (72)                                           ‐                              ‐                             48,729                 48,729                                     ‐                             62,775                 (14,046)                                   Total Non‐Operating Revenue54,775                 54,775                 49,212                 (5,563)                                     90% 223,199               (173,987)                                Total Revenues4,466,549            4,466,549            3,145,716            (1,320,833)                             70% 2,766,917            378,799                                  COMPARATIVE City of Prior Lake Water Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)COMPARATIVETotal ExpendituresPersonnel and current expenditures (excluding depreciation)41520.00 Finance 108,246               108,246               70,917                 37,329                                    66% 69,591                 (1,326)                                     49400.00 Water 2,041,449            2,041,449            1,582,589            458,860                                  78% 1,377,733            (204,856)                                2,149,695            2,149,695            1,653,506            496,189                                  77% 1,447,324            (206,182)                                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            840,049               1,077,451                              44%‐                             (840,049)                                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            840,049               1,256,701                              40% 13,510                 (826,539)                                Total Expenditures4,416,095            4,416,095            2,518,380            1,897,715                              1,488,059            (1,030,321)                             0.0%Other Financing Uses59203.00 Transfers to other funds 1,035,700            1,035,700            1,191,106            (155,406)                                353,495               (837,611)                                Total Other Financing Uses1,035,700            1,035,700            1,191,106            (155,406)                                353,495               (837,611)                                Total Revenues/ Other Financing Sources4,466,549            4,466,549            3,145,716            (1,320,833)                             70% 2,766,917            378,799                                  Total Expenditures/Other Financing Uses5,451,795            5,451,795            3,709,486            1,742,309                              68% 1,841,554            (1,867,932)                             Net Change (985,246)              (985,246)              (563,770)              421,476                                  925,363               2,246,731                               City of Prior Lake Sewer Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesSewer Charges604‐49450.00‐37102.00 Utility Receipts ‐ Sewer 1,717,840            1,717,840            783,462               (934,378)                                46% 1,085,227            (301,765)                                604‐49450.00‐37104.00 Utility Recpt‐Sewer MCES 1,625,587            1,625,587            1,176,865            (448,722)                                72% 1,149,767            27,098                                    604‐49450.00‐37160.00 Penalties 20,000                 20,000                 17,444                 (2,556)                                     87% 8,543                    8,901                                      3,363,427            3,363,427            1,977,771            (1,385,656)                             59% 2,243,537            (265,766)                                Capital Facility charges604‐49450.00‐37110.00 Utility Base Fee Revenue 953,615               953,615               600,226               (353,389)                                63% 152,386               447,840                                  953,615               953,615               600,226               (353,389)                                63% 152,386               447,840                                  Total Operating Revenue4,317,042            4,317,042            2,577,997            (1,739,045)                             60% 2,395,923            182,074                                  Non‐Operating RevenueInterest (losses) on investments604‐00000.00‐36210.00 Interest Earnings 19,800                 19,800                 32,311                 12,511                                    163% 30,128                 2,183                                      604‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (32,274)                (32,274)                                   n/a 34,290                 (66,564)                                   19,800                 19,800                 37                          (19,763)                                   0% 64,418                 (64,381)                                   Total Non‐Operating Revenue19,800                 19,800                 37                          (19,763)                                   0% 64,418                 (64,381)                                   Total Revenue4,336,842            4,336,842            2,578,034            (1,758,808)                             59% 2,460,341            117,693                                  COMPARATIVE City of Prior Lake Sewer Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)COMPARATIVETotal ExpendituresPersonnel and current expenditures (excluding depreciation)41520.00 Finance 107,721               107,721               70,910                 36,811                                    66% 70,805                 (105)                                        49450.00 Sewer 2,681,274            2,681,274            1,912,678            768,596                                  71% 1,944,673            31,995                                    2,788,995            2,788,995            1,983,588            805,407                                  71% 2,015,478            31,890                                    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            2,008,413            1,805,482                              2,054,821            46,408                                    Other Financing Uses59203.00 Transfers to other funds 366,000               366,000               940,190               (574,190)                                257% 220,583               (719,607)                                Total Other Financing Uses366,000               366,000               940,190               (574,190)                                257% 220,583               (719,607)                                Total Revenues/ Other Financing Sources4,336,842            4,336,842            2,578,034            (1,758,808)                             59% 2,460,341            117,693                                  Total Expenditures/Other Financing Uses4,179,895            4,179,895            2,948,603            1,231,292                              71% 2,275,404            (673,199)                                Net Change156,947               156,947               (370,569)              (527,516)                                184,937               790,892                                   City of Prior Lake Water Quality Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesStorm Water Charges602‐49420.00‐37120.00 Storm Water Revenue 1,186,699            1,186,699            664,344               (522,355)                                56% 647,161               17,183                                    602‐49420.00‐32250.00 Wetland Application Fee‐                              ‐                             600                       600                                          n/a 600                        ‐                                               1,186,699            1,186,699            664,944               (521,755)                                56% 647,761               17,183                                    Water Charges602‐49420.00‐37160.00 Penalties 4,000                    4,000                    2,770                    (1,230)                                     69% 1,408                    1,362                                      4,000                    4,000                    2,770                    (1,230)                                     69% 1,408                    1,362                                      Total Operating Revenue1,190,699            1,190,699            667,714               (522,985)                                56% 649,169               18,545                                    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                 22,758                 8,258                                      157% 23,186                 (428)                                        602‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (22,509)                (22,509)                                   n/a 27,404                 (49,913)                                   14,500                 14,500                 249                       (14,251)                                   2% 50,590                 (50,341)                                   Miscellaneous Revenues602‐00000.00‐36212.00 Miscellaneous Revenue‐                              ‐                             5,580                    5,580                                      n/a 240                       5,340                                      ‐                              ‐                             5,580                    5,580                                      n/a 240                       5,340                                      Total Non‐Operating Revenue14,500                 14,500                 39,129                 24,629                                    270% 50,830                 (11,701)                                   Total Revenues1,205,199            1,205,199            706,843               (498,356)                                59% 699,999               6,844                                      COMPARATIVE City of Prior Lake Water Quality Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)COMPARATIVETotal ExpendituresPersonnel and current expenditures (excluding depreciation)49420.00 Water Quality 622,893               698,264               451,765               246,499                                  65% 336,882               (114,883)                                622,893               698,264               451,765               246,499                                  65% 336,882               (114,883)                                Capital improvements55530.00 Infrastructure 359,500               359,500               14,988                 344,512                                  4% 36,501                 21,513                                    359,500               359,500               14,988                 344,512                                  4% 36,501                 21,513                                    55700.00 Contra Capital Outlay‐                              ‐                              ‐                              ‐                                               n/a (35,529)                (35,529)                                   Total Expenditures982,393               1,057,764            466,753               591,011                                  44% 337,854               (128,899)                                Other Financing Uses59203.00 Transfers to other funds 127,000               127,000               420,045               (293,045)                                331% 64,335                 (355,710)                                Total Other Financing Uses127,000               127,000               420,045               (293,045)                                331% 64,335                 (355,710)                                Total Revenues/ Other Financing Sources1,205,199            1,205,199            706,843               (498,356)                                59% 699,999               6,844                                      Total Expenditures/Other Financing Uses1,109,393            1,184,764            886,798               297,966                                  75% 402,189               (484,609)                                Net Change95,806                 20,435                 (179,955)              (200,390)                                297,810               (477,765)                                 City of Prior Lake Economic Development Authority Special Revenue Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesTaxes240‐00000.00‐31010.00 Current Property Taxes 349,750               349,750               185,108               (164,642)                               53% 146,510               38,598                                   Taxes349,750               349,750               185,108               (164,642)                               53% 146,510               38,598                                   Charges for Services240‐46503.00‐34760.02 Facility Rental ‐ EDA 8,450                   8,450                   2,435                   (6,015)                                   29% 5,609                   (3,174)                                   Charges for Services 8,450                   8,450                   2,435                   (6,015)                                   29% 5,609                   (3,174)                                   Interest (losses) on investments240‐00000.00‐36210.00 Interest Earnings 5,300                   5,300                   4,792                   (508)                                       90% 5,568                   (776)                                       240‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                             ‐                            (4,636)                  (4,636)                                   n/a 5,717                   (10,353)                                 Interest (losses) on investments 5,300                   5,300                   156                      (5,144)                                   3% 11,285                 11,129                                   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,699               (175,801)                               52% 329,554               (141,855)                               ExpendituresFunction: Economic Development46500.00 ECONOMIC DEVELOPMENT 519,294               519,294               572,391               (53,097)                                 110% 204,903               (367,488)                               46503.00 TECH VILLAGE INCUBATOR 5,500                   5,500                   1,150                   4,350                                     21% 1,662                   512                                        Total Expenditures524,794               524,794               573,541               (48,747)                                 109% 206,565               (366,976)                               Net Change(161,294)             (161,294)             (385,842)             122,989               COMPARATIVE