Loading...
HomeMy WebLinkAbout05(E) - Approval of 1st Quarter Financial Report Report ITEM: 5E CITY COUNCIL AGENDA REPORT MEETING DATE: May 16, 2022 PREPARED BY: Jason Etter, Senior Accountant PRESENTED BY: Cathy Erickson, Finance Director st AGENDA ITEM: Approval of the Preliminary 1 Quarter 2022 Financial Reports GOAL AREA High-Value City Services OBJECTIVE: 1. Establish financial stability for all funds. RECOMMENDED ACTION: Approve the March 31, 2022, Financial Report as submitted. BACKGROUND: Staff has prepared preliminary summary financial reports (attached) as of March 31, 2022, for the following funds: • General Fund • Debt Service Funds • Cable Fund • Capital Park Fund • Revolving Equipment Fund • Facilities Management Fund • Permanent Improvement Revolving Fund • Water Fund • Sewer Fund • Water Quality Fund • Economic Development Authority Special Revenue Fund FINANCIAL IMPACT: The reports reflect revenue and expenditure activity during first quarter 2022. The reports are preliminary, unaudited and may change. The attached memorandum provides a summary of the significant issues. As requested by the City Council, comparative information has been included for the same period of the prior year. ALTERNATIVES: 1. Motion and second as part of the consent agenda to approve the March 31, 2022, Financial Report as submitted. 2. Motion and second to remove the Financial Report from the consent agenda for additional discussion. City of Prior Lake | 4646 Dakota Street SE | Prior Lake MN 55372 Item 5E Page | 2 ATTACHMENTS: 1. 1st Q 2022 Memorandum - Attachment 1 2. 1st Q 2022 Financial Report - Attachment 2 MEMORANDUM DATE: May 16, 2022 TO: Prior Lake City Council FROM: Cathy Erickson, Finance Director RE: Financial Report dated 03/31/2022 The financial reports presented as part of this agenda item reflect activity during the first quarter of 2022. The significant issues identified at this time are summarized below. General Fund Summary Key points for 2022:  Preliminary financial information reflects expenditures exceeding revenues by st $1,730,405; This is expected since the primary funding source 1 half property tax revenue will be received in June.  Intergovernmental revenues are higher than this same period in 2021 by $170,000 mainly due to state road & bridge aid ahead of the prior year by $71k, township fire and rescue is up $59k and the first quarter payment from the SMSC is $50k more than 2021.  Charges for services are lower than in this same period in 2021 by about $73,000. Most of this decrease is due to the decrease in tower lease revenue collection of $132k in Q1 2022 as compared to $225k in Q1 2021. This is due to one less tower lease than the previous year.  Interest on investments is significantly lower than this same period in 2021 due to the increase in unrealized losses. Unrealized losses in Q1 2021 were $47k compared to Q1 2022 of $242k. This is a paper loss for the Q1 2022; no actual gain is realized because the City holds the securities until maturity. Actual interest earned is even compared to this period last year at $37k.  Expenditures are slightly higher than the same period in 2021 primarily due to an increase in personal services and supplies in the police and parks departments. General Fund Revenues Property taxes are received in June, December, and January. Revenue from taxes is recognized on a cash basis for the General Fund. Therefore, tax revenue will not be reflected in the financial report until June. Building permits (single family and townhomes) were budgeted at 150 for 2022. Revenues associated with building permits and plan check fees are approximately $2,700 higher than in st the 1 quarter 2021. The following table provides a breakdown of the first quarter activity by year. Year Single Townhomes Commercial / Other Total Change Family Industrial Permits from PY 2022 39 0 0 551 590 2% 2021 34 0 1 541 576 18% 2020 27 4 0 457 488 33% 2019 25 0 1 342 368 3% 2018 20 12 0 229 357 14% 2017 10 0 0 302 312 (10%) 2016 17 4 3 325 349 (16%) 2015 32 0 3 380 418 65% The first half payments were received for Municipal State Aid and the township fire agreements. SMSC Police Aid of $250k was received in the first quarter which equal to 25% of the $1,000,000 budget for this line item. First quarter franchise fees collected in April are not included in this report. Project engineering fees are currently at 27% of its annual budget. The 2022 project administration/engineering fee is the cost for internal work done on city construction projections. City staff time on the projects is charged over the life of the project, which is typically three years and included planning, construction, and project closeout. st Recreation revenues (including Park admission fees and facility rental) are higher than the 1 quarter of 2021 primarily due to the increase in facility rentals and Recreation program fees. Interest earnings are at 33% of its budget. The report also reflects a $242k decrease in the fair value of the securities. This is a paper loss; no actual loss is realized because the City holds the securities until maturity. The miscellaneous revenue category includes planned developer agreement fee revenue which is collected to cover the city’s internal cost to administer the development projects. Staff anticipates a revenue pick up in the second half of the year as developer agreements are finalized. General Fund Expenditures/Transfers General Fund expenditures for 2022 represents 19% of the $16,864,687 amended budget. The level of expenditures (as a percent of budget) is consistent with 2021. Some key points related st to expenditures for the 1 quarter of 2022 are:  Fire personal services now include the addition of the assistant fire chief as compared to this same period last year.  Streets snow and ice management is favorable by almost $50k compared to this same time last year.  Engineering includes $13.6k for professional service costs for outside engineering consultants.  Communications and Community Development personnel costs were favorable to budget due to the open positions in each department for part of the first quarter. At this point in the year, there are no other significant variances to report. Debt Service Funds Property taxes and special assessments are received in June, December, and January (final tax settlement). Prepayments have been received for special assessments. Interest earnings are at 24% of the budget. Scheduled bond payments (interest) will be made in June. Other bond payments (principal and interest) will be due mid-December. Cable Fund First quarter franchise fees collected in April have not been included in this report. Capital Park Fund Park Dedication Fees are less than compared to the same time in 2021 by $23k. Engineering expenditures of $1k have been incurred in 2022 compared to $33k in 2021. Interest earnings are at 28% of the budget. Page 2 Revolving Equipment Fund Property taxes, the primary funding source, are received in June, December, and January (final tax settlement). Interest earnings are at 48% of the budget. The change in the fair value of the securities is adjusted against interest earnings and is allocated to each fund based on cash balances. The approved skid steer loader for Parks was purchased in the first quarter of 2022. Vehicle and equipment purchases were approved at council meetings earlier in the year, but most of the ndrd equipment will be purchased and received in the 2 and 3 quarter. Revolving Park Equipment Fund The planned infrastructure improvements and the Lakefront renovation study will be completed ndrd in the 2 and 3 quarter. Facilities Management Fund The planned Police, Fire, Central Garage and Club Prior facility work will be completed in the ndrd 2 and 3 quarter. Permanent Improvement Revolving Fund There are no approved street overlay projects scheduled for 2022. Water Fund The financial report for the Water Fund reflects one billing cycle. Consumption increased slightly from 2021, and operating revenues are ahead of the prior year by $16,900. Water revenues are about 5% of the 2022 budget which is consistent with first quarter 2021. Operating expenditures and transfers are lower than 2021 and are at 13% of budget. Sewer Fund The financial report for the Sewer Fund reflects one billing cycle. Consumption increased slightly from 2021 and operating revenues are ahead of the prior year by $12,000. Overall sewer revenues are at 3% of the budget and slightly lower compared to first quarter 2021. Operating expenditures and transfers for 2022 are at 17% of the approved budget. They are lower than in the first quarter of 2021 due to an increase in transfers out in the prior year. Water Quality Fund The financial report for the Water Quality Fund reflects one billing cycle. Water Quality revenues are based on flat rates per billing cycle. Revenues are slightly higher than 2021 and are at 6% of the budget. Operational expenditures and transfers are lower compared to the first quarter 2021 at 26% of budget. Economic Development Authority Special Revenue Fund Property taxes are received in June, December, and January (final tax settlement). Facility rental payments have been received from Sebastian Automotive. Personnel, commissioner per diems, and professional services expenditures comprise most of the expenditures and are at 6% of budget as of the end of the first quarter. Page 3 City of Prior Lake General Fund Summary - Comparison to Prior Year As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive (Negative) USED3/31/2021Positive (Negative)RevenuesTaxes 10,227,232         10,227,232          ‐                        (10,227,232)                          0%‐                         ‐                                          Licenses and Permits897,323               897,323               198,838               (698,485)                                22% 211,289               (12,451)                                  Intergovernmental 2,585,932            2,585,932            796,306               (1,789,626)                            31% 625,415               170,891                                 Charges for Services2,022,200            2,022,200            471,011               (1,551,189)                            23% 543,774               (72,763)                                  Fines and Forfeitures‐                         ‐                        200                       200                                         n/a‐                        200                                         Interest (losses) on investments68,200                 68,200                 (233,220)              (301,420)                                 ‐342% (30,845)                (202,375)                                Other189,000               189,000               22,277                 (166,723)                                12% 41,631                 (19,354)                                  Transfers in 546,000               546,000               136,500               (409,500)                                25% 130,750               5,750                                      Total Revenues16,535,887         16,535,887         1,391,912            (15,143,975)                          8% 1,522,014            (130,102)                                ExpendituresGeneral Government3,578,328            3,588,328            696,027               2,892,301                              19% 690,208               (5,819)                                    Public Safety8,117,433            8,245,433            1,585,441            6,659,992                              19% 1,443,630            (141,811)                                Public Works 2,322,714            2,445,904            458,159               1,987,745                              19% 489,080               30,921                                   Culture and Recreation2,343,574            2,361,184            382,690               1,978,494                              16% 278,105               (104,585)                                Transfer to other funds223,838               223,838                ‐                        223,838                                 0%‐                         ‐                                          Total Expenditures16,585,887         16,864,687         3,122,317            13,742,370                           19% 2,901,023            (221,294)                                Net Change(50,000)                (328,800)              (1,730,405)          (1,401,605)                            (1,379,009)          COMPARATIVE City of Prior Lake General Fund Revenues As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)Taxes101 31010.00 Current Property Taxes  ‐ General Purpos 9,136,642            9,136,642             ‐                             (9,136,642)                             0%‐                              ‐                                               101 31020.00 Delinquent Property Taxes ‐ General Purp‐                              ‐                              ‐                              ‐                                               n/a‐                              ‐                                               101 31040.00 Fiscal Disparities 1,090,590            1,090,590             ‐                             (1,090,590)                             0%‐                              ‐                                               Taxes10,227,232         10,227,232          ‐                             (10,227,232)                          0%‐                              ‐                                               Licenses and Permits101 32100.00 Business Licenses 735                       735                        ‐                             (735)                                        0% 735                       (735)                                        101 32110.00 Liquor Licenses 75,790                 75,790                 120                       (75,670)                                   0% 21,100                 (20,980)                                   101 32160.00 Refuse Haulers 4,500                    4,500                     ‐                             (4,500)                                     0%‐                              ‐                                               101 32175.00 Public Private Gathering Permit 720                       720                       90                          (630)                                        13% 150                       (60)                                           101 32180.00 Cigarette Licenses 1,785                    1,785                     ‐                             (1,785)                                     0% 1,785                    (1,785)                                     101 32190.00 Community Event Application 1,750                    1,750                    1,905                    155                                          109% 150                       1,755                                      101 32210.00 Building Permits 636,818               636,818               161,430               (475,388)                                25% 158,734               2,696                                      101 32211.00 Retainage Forfeiture‐                              ‐                              ‐                              ‐                                               n/a‐                              ‐                                               101 32215.00 Mechanical Permits 92,400                 92,400                 13,409                 (78,991)                                   15% 12,610                 799                                          101 32230.00 Plumbing Permits 66,435                 66,435                 14,408                 (52,027)                                   22% 12,007                 2,401                                      101 32231.00 Sewer/Water Inspection 8,475                    8,475                    6,076                    (2,399)                                     72% 1,948                    4,128                                      101 32232.00 Plumbing Registrations 1,250                    1,250                     ‐                             (1,250)                                     0% 990                       (990)                                        101 32260.00 Burning Permits 4,000                    4,000                    1,400                    3,000                                      35% 1,080                    320                                          101 32270.00 Short‐term Rental Fee 2,665                    2,665                     ‐                             (2,665)                                     0%‐                              ‐                                               Licenses and Permits 897,323               897,323               198,838               (698,485)                                22% 211,289               (12,451)                                   Intergovernmental101 33160.10 Fed Aids/Grants ‐ Operating Grants 27,000                 27,000                  ‐                             (27,000)                                   0%‐                              ‐                                               101 33160.11 Fed Aids/Grants ‐ Operating Police 3,500                    3,500                     ‐                             (3,500)                                     0%‐                              ‐                                               101 33401.00 Local Government Aid‐                              ‐                              ‐                              ‐                                               n/a‐                              ‐                                               101 33416.01 State Aid ‐ Police Train 24,000                 24,000                  ‐                             (24,000)                                   0%‐                              ‐                                               101 33416.02 State Police Aid‐Ins Prem 267,000               267,000                ‐                             (267,000)                                0%‐                              ‐                                               101 33417.00 State Aid ‐ Fire Training 15,000                 15,000                  ‐                             (15,000)                                   0% 8,050                    (8,050)                                     101 33418.00 State Road & Bridge Aid 377,000               377,000               272,134               (104,866)                                72% 201,019               71,115                                    101 33420.00 State Fire Aid‐Ins. Prem. 255,000               255,000                ‐                             (255,000)                                0%‐                              ‐                                               101 33422.10 State Aids/Grants ‐ Operating Grants‐                              ‐                              ‐                              ‐                                               n/a‐                              ‐                                               101 33422.11 State Aids/Grants ‐ Operating Police 3,500                    3,500                     ‐                             (3,500)                                     0%‐                              ‐                                               101 33423.00 Market Value Credit Aid‐                              ‐                              ‐                              ‐                                               n/a‐                              ‐                                               101 33610.11 County Aids/Grants ‐ Operating Grants‐                              ‐                              ‐                              ‐                                               n/a‐                              ‐                                               101 33610.11 County Aids/Grants ‐ Operating Police‐                              ‐                              ‐                              ‐                                               n/a 1,509                    (1,509)                                     101 33620.00 Township Fire & Resc Aid 549,460               549,460               274,172               (275,288)                                50% 214,837               59,335                                    101 33621.00 Liaison Aid 64,472                 64,472                  ‐                             (64,472)                                   0%‐                              ‐                                               100 33630.00 Metro Council Grants‐                              ‐                              ‐                              ‐                                               n/a‐                              ‐                                               101 33631.00 Payment in Lieu of Taxes 1,000,000            1,000,000            250,000               (750,000)                                25% 200,000               50,000                                    101 33700.10 Miscellaneous Grants ‐ Operating Grants‐                              ‐                              ‐                              ‐                                               n/a‐                              ‐                                               101 33700.11 Miscellaneous Grants ‐ Operating Police‐                              ‐                              ‐                              ‐                                               n/a‐                              ‐                                               Intergovernmental 2,585,932            2,585,932            796,306               (1,789,626)                             31% 625,415               170,891                                  COMPARATIVE City of Prior Lake General Fund Revenues As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)COMPARATIVECharges for Services101 31810.00 Franchise Taxes 637,000               637,000                ‐                             (637,000)                                0% 14,808                 (14,808)                                   101 34103.00 Zoning & Subdivision Fees 30,000                 30,000                 4,050                    (25,950)                                   14% 8,021                    (3,971)                                     101 34104.00 Plan Check Fees 413,931               413,931               94,806                 (319,125)                                23% 86,550                 8,256                                      101 34105.00 Sale of Maps/Publications ‐ Reports 500                       500                       14                          (486)                                        3% 90                          (76)                                           101 34107.00 Assessment Searches ‐ Reports 700                       700                       50                          (650)                                        7% 175                       (125)                                        101 34108.00 Street Chip Seal Fee‐New Development‐                              ‐                              ‐                              ‐                                               n/a‐                              ‐                                               101 34109.00 Project Admin/Eng Fees 200,000               200,000               54,458                 (145,542)                                27% 35,972                 18,486                                    101 34203.00 Accident/Warrant Reports ‐ Reports 200                       200                       184                       (16)                                           92%‐                             184                                          101 34731.00 Adult League Fees 4,800                    4,800                    5,111                    311                                          106% 5,878                    (767)                                        101 34735.00 Recreation Program Fees 55,000                 55,000                 53,280                 (1,720)                                     97% 49,345                 3,935                                      101 34735.01 Recreation Program Fees Regular 9,000                    9,000                    1,847                    (7,153)                                     21% 941                       906                                          101 34760.01 Facility Rental ‐ Regular 58,865                 58,865                 15,834                 (43,031)                                   27% 10,006                 5,828                                      101 34761.00 Studio/Pavilion Rental 24,000                 24,000                 16,661                 (7,339)                                     69% 13,171                 3,490                                      101 34762.00 Park Shelter Rental 83,200                 83,200                 69,646                 (13,554)                                   84% 68,804                 842                                          101 34765.01 Tower Leases 282,139               282,139               131,984               (150,155)                                47% 225,023               (93,039)                                   101 34780.00 Park Admission Fees 35,000                 35,000                  ‐                             (35,000)                                   0%‐                              ‐                                               101 34783.00 City Contract Services 187,865               187,865               23,086                 (164,779)                                12% 24,990                 (1,904)                                     101 36220.16 Prof Services Fee Deposit Bldg Inspectio‐                              ‐                              ‐                              ‐                                               n/a‐                              ‐                                               Charges for Services 2,022,200            2,022,200            471,011               (1,551,189)                             23% 543,774               (72,763)                                   Fines and Forfeitures101 35101.00 County Court Fines‐                              ‐                             200                       200                                          n/a‐                             200                                          101 35104.00 Prosecution Restitution‐                              ‐                              ‐                              ‐                                               n/a‐                              ‐                                               Fines and Forfeitures‐                              ‐                             200                       200                                          n/a‐                             200                                          Interest (losses) on investments101 36210.00 Interest Earnings 112,200               112,200               37,430                 (74,770)                                   33% 37,102                 328                                          101 36215.00 Amortization ‐ Premium/Discount (44,000)                (44,000)                (28,470)                15,530                                    65% (20,637)                (7,833)                                     101 36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (242,180)              (242,180)                                n/a (47,310)                (194,870)                                101 36226.00 Realized Inv.Gain(Loss)‐                              ‐                              ‐                              ‐                                               n/a‐                              ‐                                               Interest (losses) on investments 68,200                 68,200                 (233,220)              (301,420)                                 ‐342% (30,845)                (202,375)                                Other Miscellaneous Revenues101 36101.00 City Assess. Collection‐                              ‐                             492                       492                                          n/a‐                             492                                          101 36102.00 County Assess. Collection 5,000                    5,000                     ‐                             (5,000)                                     0%‐                              ‐                                               101 36211.00 Developer Agreements 130,000               130,000                ‐                             (130,000)                                0% 12,500                 (12,500)                                   101 36212.00 Miscellaneous Revenue 54,000                 54,000                 15,772                 (38,228)                                   29% 20,187                 (4,415)                                     101 36230.00 Contributions & Donations‐                              ‐                             4,703                    4,703                                      n/a 3,800                    903                                          101 39102.00 Sale of Property‐                              ‐                             1,310                    1,310                                      n/a 5,144                    (3,834)                                     Other Miscellaneous Revenues 189,000               189,000               22,277                 (166,723)                                12% 41,631                 (19,354)                                   Other financing sources101 39203.00 Transfer from Other Funds 546,000               546,000               136,500               (409,500)                                25% 130,750               5,750                                       City of Prior Lake General Fund Revenues As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)COMPARATIVEOther financing sources 546,000               546,000               136,500               (409,500)                                25% 130,750               5,750                                      Total Revenues16,535,887         16,535,887         1,391,912            (15,143,975)                          8% 1,522,014            (130,102)                                 City of Prior Lake General Fund Expenditures As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGTActual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)Function: General Government41110.00 MAYOR & COUNCIL75,528                 75,528                 15,850                 59,678                                    21% 17,959                 2,109                                      41130.00 ORDINANCE 6,000                    6,000                    882                       5,118                                      15% 892                       10                                           41320.00 ADMINISTRATION 390,765               390,765               93,099                 297,666                                  24% 71,888                 (21,211)                                   41330.00 BOARDS & COMMISSIONS11,365                 11,365                 538                       10,827                                    5% 1,154                    616                                         41400.00 CITY CLERK 129,697               129,697               27,527                 102,170                                  21% 23,937                 (3,590)                                     41410.00 ELECTIONS 62,200                 62,200                 77                          62,123                                    0%‐                             (77)                                          41520.00 FINANCE 596,290               596,290               99,760                 496,530                                  17% 113,365               13,605                                    41540.00 INTERNAL AUDITING 42,200                 42,200                 4,990                    37,210                                    12% 9,190                    4,200                                      41550.00 ASSESSING 231,135               231,135                ‐                             231,135                                  0%‐                              ‐                                              41610.00 LEGAL 190,000               190,000               26,133                 163,867                                  14% 37,638                 11,505                                    41820.00 HUMAN RESOURCES 332,139               332,139               62,364                 269,775                                  19% 66,986                 4,622                                      41830.00 COMMUNICATIONS 174,261               178,261               35,934                 142,327                                  20% 39,901                 3,967                                      41910.00 COMMUNITY DEVELOPMENT385,472               385,472               45,460                 340,012                                  12% 62,773                 17,313                                    41920.00 INFORMATION TECHNOLOGY 398,081               404,081               128,564               275,517                                  32% 122,203               (6,361)                                     41940.00 FACILITIES ‐ CITY HALL 553,195               553,195               154,849               398,346                                  28% 122,322               (32,527)                                   Total ‐ Function General Government 3,578,328            3,588,328            696,027               2,892,301                              19% 690,208               (5,819)                                     Function: Public Safety42100.00 POLICE 6,013,802            6,141,802            1,248,319            4,893,483                              20% 1,124,542            (123,777)                                42200.00 FIRE 1,242,376            1,242,376            189,982               1,052,394                              15% 173,549               (16,433)                                   42400.00 BUILDING INSPECTION 816,265               816,265               142,102               674,163                                  17% 140,045               (2,057)                                     42500.00 EMERGENCY MANAGEMENT16,190                 16,190                 238                       15,952                                    1% 694                       456                                         42700.00 ANIMAL CONTROL28,800                 28,800                 4,800                    24,000                                    17% 4,800                     ‐                                              Total ‐ Function Public Safety 8,117,433            8,245,433            1,585,441            6,659,992                              19% 1,443,630            (141,811)                                Function: Public Works43050.00 ENGINEERING 419,812               419,812               91,168                 328,644                                  22% 77,582                 (13,586)                                   43100.00 STREET 1,384,871            1,464,261            254,746               1,209,515                              17% 303,290               48,544                                    43400.00 CENTRAL GARAGE 518,031               561,831               111,944               449,887                                  20% 108,208               (3,736)                                     43600.00 DEVELOPMENT PROJECTS‐                              ‐                             301                       (301)                                        n/a‐                             (301)                                        Total ‐ Function Public Works 2,322,714            2,445,904            458,159               1,987,745                              19% 489,080               30,921                                    Function: Culture and Recreation45100.00 RECREATION 512,825               512,825               79,450                 433,375                                  15% 67,443                 (12,007)                                   45200.00 PARKS 1,760,303            1,777,913            283,546               1,494,367                              16% 197,913               (85,633)                                   45500.00 LIBRARIES 70,446                 70,446                 19,694                 50,752                                    28% 12,749                 (6,945)                                     Total ‐ Function Culture and Recreation 2,343,574            2,361,184            382,690               1,978,494                              16% 278,105               (104,585)                                00000.00 Transfer to Other Funds 223,838               223,838                ‐                             223,838                                  0%‐                              ‐                                              Total Expenditures16,585,887         16,864,687         3,122,317            13,742,370                            19% 2,901,023            (221,294)                                COMPARATIVE City of Prior LakeExpenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 3/31/2022(Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)GENERAL FUNDFunction: General Government41110.00 MAYOR & COUNCIL 68,728                 68,728                    14,352                 54,376                              21% 15,533                     1,181                                     41320.00 ADMINISTRATION 276,235               276,235                 50,425                 225,810                            18% 40,782                     (9,643)                                   41330.00 BOARDS & COMMISSIONS 10,765                 10,765                    538                      10,227                              5% 1,154                       616                                        41400.00 CITY CLERK FUNCTIONS 128,447               128,447                 27,527                 100,920                            21% 23,752                     (3,775)                                   41410.00 ELECTIONS 57,690                 57,690                    77                         57,613                              0%‐                                (77)                                         41520.00 FINANCE 570,810               570,810                 94,945                 475,865                            17% 108,692                   13,747                                   41820.00 HUMAN RESOURCES 287,689               287,689                 56,419                 231,270                            20% 54,501                     (1,918)                                   41830.00 COMMUNICATIONS 142,261               142,261                 13,346                 128,915                            9% 22,999                     9,653                                     41910.00 COMMUNITY DEVELOPMENT 335,822               335,822                 44,716                 291,106                            13% 60,141                     15,425                                   41920.00 INFORMATION TECHNOLOGY 239,241               239,241                 46,284                 192,957                            19% 44,627                     (1,657)                                   41940.00 FACILITIES ‐ CITY HALL 88,220                 88,220                    18,855                 69,365                              21% 6,983                       (11,872)                                 Total ‐ Function General Government 2,205,908           2,205,908              367,484               1,838,424                         17% 379,164                   11,680                                   Function: Public Safety42100.00 POLICE 5,445,654           5,445,654              1,032,944           4,412,710                         19% 930,836                   (102,108)                               42200.00 FIRE 900,773               900,773                 118,318               782,455                            13% 101,117                   (17,201)                                 42400.00 BUILDING INSPECTION 784,947               784,947                 137,338               647,609                            17% 132,602                   (4,736)                                   Total ‐ Function Public Safety 7,131,374           7,131,374              1,288,600           5,842,774                         18% 1,164,555               (124,045)                               Function: Public Works43050.00 ENGINEERING 359,793               359,793                 65,010                 294,783                            18% 63,459                     (1,551)                                   43100.00 STREET 537,643               537,643                 97,804                 439,839                            18% 101,574                   3,770                                     43400.00 CENTRAL GARAGE 262,456               262,456                 50,428                 212,028                            19% 47,903                     (2,525)                                   Total ‐ Function Public Works 1,159,892           1,159,892              213,242               946,650                            18% 212,936                   (306)                                       Function: Culture and Recreation45100.00 RECREATION 377,023               377,023                 52,927                 324,096                            14% 52,384                     (543)                                       45200.00 PARKS 1,162,215           1,162,215              206,330               955,885                            18% 173,951                   (32,379)                                 Total ‐ Function Culture and Recreation 1,539,238           1,539,238              259,257               1,279,981                         17% 226,335                   (32,922)                                 General Fund Payroll Only Expenditures Total 12,036,412         12,036,412            2,128,583           9,907,829                         18% 1,982,990               (145,593)                               EDA FUNDFunction:  Economic Development   46500.00 ECONOMIC DEVELOPMENT 143,239               143,239                 24,837                 118,402                            17% 31,184                     6,347                                     EDA Fund Payroll Only Expenditures Total 143,239               143,239                 24,837                 118,402                            17% 31,184                     6,347                                     COMPARATIVE City of Prior LakeExpenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 3/31/2022(Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)COMPARATIVEWATER FUNDFunction: Water41520.00 Finance 84,371                 84,371                    15,875                 68,496                              19% 15,317                     (558)                                       49400.00 Water 794,320               794,320                 169,212               625,108                            21% 146,790                   (22,422)                                 Water Fund Payroll Only Expenditures Total 878,691               878,691                 185,087               693,604                            21% 162,107                   (22,980)                                 SEWER FUNDFunction: Sewer41520.00 Finance 84,371                 84,371                    15,872                 68,499                              19% 15,315                     (557)                                       49450.00 Sewer 786,039               786,039                 151,408               634,631                            19% 159,475                   8,067                                     Sewer Fund Payroll Only Expenditures Total 870,410               870,410                 167,280               703,130                            19% 174,790                   7,510                                     STORM WATER FUNDFunction: Storm Water49420.00 Water Quality 356,875               356,875                 72,801                 284,074                            20% 69,192                     (3,609)                                   Storm Water Fund Payroll Only Expenditures Total 356,875               356,875                 72,801                 284,074                            20% 69,192                     (3,609)                                   City‐Wide Total Payroll Expenditures 14,285,627         14,285,627            2,578,588           11,707,039                      18% 2,420,263               (158,325)                                City of Prior Lake Debt Service Funds As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)RevenuesProperty TaxesCurrent Property Taxes 2,541,816           2,541,816            ‐                            (2,541,816)                            0%‐                             ‐                                             Special AssessmentsCity Assess. Collections‐                             ‐                            3,547                   3,547                                     n/a 15,923                 (12,376)                                 County Assess. Collection 448,425               448,425                ‐                            (448,425)                               0%‐                             ‐                                             Interest (losses) on investmentsInterest Earnings 35,425                 35,425                 8,609                   (26,816)                                 24% 10,821                 (2,212)                                   Unrealized Inv.Gain(Loss)‐                             ‐                            (56,559)               (56,559)                                 n/a (14,009)               (42,550)                                 Other Financing SourcesTransfer from Other Funds 1,342,764           1,342,764            ‐                            (1,342,764)                            0%‐                             ‐                                             Total Revenues4,368,430           4,368,430           (44,403)               (4,412,833)                             ‐1% 12,735                 (57,138)                                 ExpendituresDebt ServicePrincipal 3,695,713           3,695,713            ‐                            3,695,713                             0%‐                             ‐                                             Interest and Other 775,949               775,949               750                      775,199                                0%‐                            (750)                                       Transfers to Other Funds 233,000               233,000                ‐                            233,000                                0%‐                             ‐                                             Total Expenditures4,704,662           4,704,662           750                      4,703,912                             0%‐                            (750)                                       Net Change(336,232)             (336,232)             (45,153)               12,735                 COMPARATIVE City of Prior Lake Cable Fund As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)RevenuesCharges for Services210‐41340.00‐34304.00PEG Access Fees 23,800                 23,800                  ‐                            (23,800)                                 0% 234                      (234)                                       Interest (losses) on investments210‐41340.00‐36210.00Interest Earnings‐                             ‐                            439                      439                                        n/a 372                      67                                          210‐41340.00‐36225.00Unrealized Inv. Gain (Loss)‐                             ‐                            (2,880)                  (2,880)                                   n/a (486)                     (2,394)                                   Total Revenues23,800                 23,800                 (2,441)                  (26,241)                                  ‐10% 120                      (2,561)                                   ExpendituresCurrent Expenditures210‐41340.00‐52400.20Small  Equipment ‐ Technology‐                             ‐                             ‐                             ‐                                             n/a 1,258                   1,258                                     Capital Outlay210‐41340.00‐55570.00Machinery and Equipment‐                            39,780                  ‐                            39,780                                   0% 3,576                   3,576                                     Total Expenditures‐                            39,780                  ‐                            39,780                                   0% 4,834                   4,834                                     Net Change23,800                 (15,980)               (2,441)                  (4,714)                  COMPARATIVE City of Prior Lake Capital Park Fund As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGTActual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)RevenuesCharges for Services225‐45200.00‐34760.01 Facility Rental ‐ Regular 24,000                 24,000                 5,100                   (18,900)                                 21% 6,000                   (900)                                       225‐45200.00‐34791.00 Dedication Fees 562,500               562,500                ‐                            (562,500)                               0% 22,752                 (22,752)                                 Charges for Services 586,500               586,500               5,100                   (581,400)                               1% 28,752                 (23,652)                                 Interest (losses) on investments225‐00000.00‐36210.00 Interest Earnings 22,000                 22,000                 6,088                   (15,912)                                 28% 6,527                   (439)                                       225‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                             ‐                            (40,027)               (40,027)                                 n/a (8,438)                  (31,589)                                 Interest (losses) on investments 22,000                 22,000                 (33,939)               (55,939)                                  ‐154% (1,911)                  (32,028)                                 Contributions and donations225‐00000.00‐36230.00 Contributions & Donations‐                             ‐                            11,675                 11,675                                   n/a 9,650                   2,025                                     Contributions and donations‐                             ‐                            11,675                 11,675                                   n/a 9,650                   2,025                                     Total Revenues608,500               608,500               (17,164)               (625,664)                                ‐3% 36,491                 (53,655)                                 Expenditures53100.80 Professional Services‐General 3,200                   3,200                   3,402                   (202)                                       106% 3,104                   (298)                                       55020.00 Projects ‐ Engineering‐                             ‐                            1,468                   (1,468)                                   n/a 33,959                 32,491                                   55530.00 Infrastructure‐                             ‐                             ‐                             ‐                                             n/a 3,117                   3,117                                     Total Expenditures3,200                   3,200                   4,870                   (1,670)                                   152% 40,180                 35,310                                   Net Change605,300               605,300               (22,034)               (3,689)                  COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)RevenuesTaxes410‐00000.00‐31010.00 Current Property Taxes 700,000               700,000                ‐                             (700,000)                                0%‐                              ‐                                               Taxes700,000               700,000                ‐                             (700,000)                                0%‐                              ‐                                               Interest (losses) on investments410‐00000.00‐36210.00 Interest Earnings 6,800                    6,800                    3,291                    (3,509)                                     48% 2,426                    865                                          410‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (21,895)                (21,895)                                   n/a (3,101)                  (18,794)                                   Interest (losses) on investments 6,800                    6,800                    (18,604)                (25,404)                                    ‐274% (675)                      (17,929)                                   Sale of assets410‐00000.00‐39102.00 Sale of Property‐                              ‐                             27,000                 27,000                                    n/a 18,325                 8,675                                      Sale of assets‐                              ‐                             27,000                 27,000                                    n/a 18,325                 8,675                                      Transfers in410‐00000.00‐39203.00 Transfer from Other Funds 217,500               217,500               54,375                 (163,125)                                25% 77,500                 (23,125)                                   Transfers in217,500               217,500               54,375                 (163,125)                                25% 77,500                 (23,125)                                   Total Revenues924,300               924,300               62,771                 (861,529)                                7% 95,150                 (32,379)                                   COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)COMPARATIVEExpendituresGeneral GovernmentPublic SafetyPolice410‐42100.00‐55550.00 Vehicles 260,000               260,000               8,770                    251,230                                  3% 13,269                 4,499                                      410‐42100.00‐55570.00 Machinery & Equipment 38,900                 38,900                  ‐                             38,900                                    0% 25,965                 25,965                                    Fire410‐42200.00‐55550.00 Vehicles 135,000               135,000               3,265                    131,735                                  2%‐                             (3,265)                                     410‐42200.00‐55570.00 Machinery & Equipment 53,000                 53,000                  ‐                             53,000                                    0%‐                              ‐                                               Total Public Safety 486,900               486,900               12,035                 474,865                                  2% 39,234                 27,199                                    Public WorksStreet410‐43100.00‐55570.00 Machinery & Equipment 65,000                 65,000                  ‐                             65,000                                    0% 4,400                    4,400                                      Central Garage410‐43400.00‐55550.00 Vehicles 20,000                 20,000                  ‐                             20,000                                    0%‐                              ‐                                               Total Public Works 85,000                 85,000                  ‐                             85,000                                    0% 4,400                    4,400                                      Culture and Recreation/Parks410‐45200.00‐55550.00 Vehicles 270,000               270,000                ‐                             270,000                                  0%‐                              ‐                                               410‐45200.00‐55570.00 Machinery and Equipment 79,500                 79,500                 69,144                 10,356                                    87% 48,183                 (20,961)                                   Total Culture & Recreation 349,500               349,500               69,144                 280,356                                  20% 48,183                 (20,961)                                   Total Expenditures921,400               921,400               81,179                 840,221                                  9% 91,817                 10,638                                    Net Change2,900                    2,900                    (18,408)                3,333                     City of Prior Lake Revolving Park Equipment Fund As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGTActual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)RevenuesTaxes430‐00000.00‐31010.00 Current Property Taxes 405,000               405,000                ‐                             (405,000)                                0%‐                              ‐                                              Taxes405,000               405,000                ‐                             (405,000)                                0%‐                              ‐                                              Interest (losses) on investments430‐00000.00‐36210.00 Interest Earnings 13,800                 13,800                 4,202                    (9,598)                                     30% 4,746                    (544)                                        430‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (27,586)                (27,586)                                   n/a (6,142)                  (21,444)                                   Interest (losses) on investments 13,800                 13,800                 (23,384)                (37,184)                                    ‐169% (1,396)                  (21,988)                                   Total Revenues418,800               418,800               (23,384)                (442,184)                                 ‐6% (1,396)                  (21,988)                                   ExpendituresCulture and RecreationDept 45200.00 ‐ PARKS430‐45200.00‐55020.00 Projects ‐ Engineering‐                              ‐                             1,107                    (1,107)                                     n/a‐                             (1,107)                                     430‐45200.00‐55050.00‐PRK22‐000001 Projects ‐ Professional Services‐                              ‐                             10,299                 (10,299)                                   n/a‐                             (10,299)                                   430‐45200.00‐55530.00 Infrastructure 158,000               158,000                ‐                             158,000                                  0%‐                              ‐                                              Dept 45500.00 ‐ LIBRARY430‐45500.00‐55050.00 Projects ‐ Professional Services‐                             38,000                  ‐                             38,000                                    0%‐                              ‐                                              Total Culture & Recreation 158,000               196,000               11,406                 184,594                                  6%‐                             (11,406)                                   Total Expenditures158,000               196,000               11,406                 184,594                                  6%‐                             (11,406)                                   Net Change260,800               222,800               (34,790)                (1,396)                  COMPARATIVE City of Prior Lake Facilities Management Fund As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)RevenuesTaxes440‐00000.00‐31010.00 Current Property Taxes105,000               105,000                ‐                             (105,000)                                0%‐                              ‐                                               Taxes105,000               105,000                ‐                             (105,000)                                0%‐                              ‐                                               Intergovernmental440‐00000.00‐33160.00 Fed Aids/Grants 400,000               400,000                ‐                             (400,000)                                0%‐                              ‐                                               440‐42200.00‐33620.00 Township Fire & Resc Aid 135,000               135,000               67,500                  (67,500)                                  50%‐                             67,500                                   535,000               535,000               67,500                  (467,500)                                13%‐                             67,500                                   Interest (losses) on investments440‐00000.00‐36210.00 Interest Earnings 6,300                    6,300                    4,996                    (1,304)                                    79% 1,975                    3,021                                      440‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (32,805)                (32,805)                                  n/a (2,564)                   (30,241)                                  Interest (losses) on investments6,300                    6,300                    (27,809)                (34,109)                                   ‐441% (589)                      (27,220)                                  Transfers in440‐00000.00‐39203.00 Transfer from Other Funds 24,600                  24,600                  6,150                    (18,450)                                  25% 32,500                  (26,350)                                  Transfers in24,600                  24,600                  6,150                    (18,450)                                  25% 32,500                  (26,350)                                  Total Revenues670,900               670,900               45,841                  (625,059)                                7% 31,911                  13,930                                   ExpendituresFunction: General Government41940‐55050.00 Projects Professional Svcs‐ FACILITIES ‐ CITY HALL‐                              ‐                             11,309                  (11,309)                                  n/a 10,979                  (330)                                        Total ‐ Function General Government‐                              ‐                             11,309                  (11,309)                                  n/a 10,979                  (330)                                        Function: Public Safety42100‐55520.00 Building & Building Improvements‐POLICE 167,000               167,000                ‐                             167,000                                 0%‐                              ‐                                               42200‐55050.00 Projects‐Professional Services‐FIRE‐                              ‐                             16,821                  (16,821)                                  n/a‐                             (16,821)                                  42200‐55520.00 Building & Building Improvements‐FIRE 700,000               700,000                ‐                             700,000                                 0%‐                              ‐                                               Total ‐ Function Public Safety867,000               867,000               16,821                  850,179                                 2%‐                             (16,821)                                  Function: Public Works43400.00 CENTRAL GARAGE 86,000                  86,000                   ‐                             86,000                                    0%‐                              ‐                                                Total ‐ Function Public Works86,000                  86,000                   ‐                             86,000                                    0%‐                              ‐                                                Function: Culture and Recreation45100.00 RECREATION 60,000                  60,000                   ‐                             60,000                                   0%‐                              ‐                                               Total ‐ Function Culture and Recreation60,000                  60,000                   ‐                             60,000                                   0%‐                              ‐                                               Total Expenditures1,013,000            1,013,000            28,130                  984,870                                 3% 10,979                  (17,151)                                  Net Change(342,100)              (342,100)              17,711                  20,932                  COMPARATIVE City of Prior Lake Permanent Improvement Revolving Fund As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGTActual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)RevenuesTaxes450‐00000.00‐31010.00 Property Taxes  ‐ General Purpose‐                              ‐                              ‐                              ‐                                         n/a‐                              ‐                                              450‐00000.00‐31810.00 Franchise Taxes 1,050,000            1,050,000             ‐                             (1,050,000)                       0%‐                              ‐                                              Taxes1,050,000            1,050,000             ‐                             (1,050,000)                       0%‐                              ‐                                              Special Assessments450‐00000.00‐36101.00 City Assess. Collections‐                              ‐                             698                       698                                    n/a 6,037                    (5,339)                                     450‐00000.00‐36102.00 County Assess. Collection 150,731               150,731                ‐                             (150,731)                           0%‐                              ‐                                              150,731               150,731               698                       (150,033)                           0% 6,037                    (5,339)                                     Interest (losses) on investments450‐00000.00‐36210.00 Interest Earnings 5,700                    5,700                    1,239                    (4,461)                               22% 1,356                    (117)                                        450‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (8,138)                  (8,138)                               n/a (1,759)                  (6,379)                                     Interest (losses) on investments 5,700                    5,700                    (6,899)                  (12,599)                              ‐121% (403)                      (6,496)                                     Transfers in450‐00000.00‐39203.00 Transfer from Other Funds‐                              ‐                              ‐                              ‐                                         n/a‐                              ‐                                              Transfers in‐                              ‐                              ‐                              ‐                                         n/a‐                              ‐                                              Total Revenues1,206,431            1,206,431            (6,201)                  (1,212,632)                        ‐1% 5,634                    (11,835)                                   ExpendituresFunction: Public Works450‐43100.00‐55530.00 Infrastructure‐                              ‐                              ‐                              ‐                                         n/a‐                              ‐                                              Total ‐ Function Public Works‐                              ‐                              ‐                              ‐                                         n/a‐                              ‐                                              OTHER FINANCING USESTransfers out450‐80000.00‐59203.00 Transfers to Other Funds 282,751               282,751                ‐                             282,751                            0%‐                              ‐                                              Total Expenditures282,751               282,751                ‐                             282,751                            0%‐                              ‐                                              Net Change923,680               923,680               (6,201)                  5,634                    COMPARATIVE City of Prior Lake Water Fund As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)RevenuesOperating RevenueWater Charges601‐49400.00‐37100.00 Utility Receipts ‐ Water 3,361,372            3,361,372            131,069               (3,230,303)                             4% 119,471               11,598                                    601‐49400.00‐37160.00 Penalties 20,000                 20,000                 969                       (19,031)                                   5% 3,490                    (2,521)                                     3,381,372            3,381,372            132,038               (3,249,334)                             4% 122,961               9,077                                      Utility Base Fee601‐49400.00‐37110.00 Utility Base Fee Revenue 1,300,902            1,300,902            69,770                 (1,231,132)                             5% 63,227                 6,543                                      1,300,902            1,300,902            69,770                 (1,231,132)                             5% 63,227                 6,543                                      Meter Sales601‐49400.00‐37170.00 Water Meter Sales 79,825                 79,825                 23,815                 (56,010)                                   30% 23,106                 709                                          601‐49400.00‐37175.00 Pressure Reducers 25,000                 25,000                 5,634                    (19,366)                                   23% 5,074                    560                                          104,825               104,825               29,449                 (75,376)                                   28% 28,180                 1,269                                      Total Operating Revenue4,787,099            4,787,099            231,257               (4,555,842)                             5% 214,368               16,889                                    Non‐Operating RevenueIntergovernmental601‐00000.00‐33422.15 State Aids/Grants ‐ Operating Public Wor‐                              ‐                             142                       142                                          n/a 58                          84                                            ‐                              ‐                             142                       142                                          n/a 58                          84                                            Interest (losses) on investments601‐00000.00‐36210.00 Interest Earnings 67,400                 67,400                 22,155                 (45,245)                                   33% 21,561                 594                                          601‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (145,629)              (145,629)                                n/a (28,183)                (117,446)                                67,400                 67,400                 (123,474)              (190,874)                                 ‐183% (6,622)                  (116,852)                                Miscellaneous Revenues601‐00000.00‐36212.00 Miscellaneous Revenue‐                              ‐                             130                       130                                          n/a 100                       30                                            601‐49400.00‐37190.00 Miscellaneous Revenue Adj‐                              ‐                             (3)                          (3)                                             n/a 2                            (5)                                             ‐                              ‐                             127                       127                                           ‐                             102                       25                                            Total Non‐Operating Revenue67,400                 67,400                 (123,205)              (190,605)                                 ‐183% (6,462)                  (116,743)                                Total Revenues4,854,499            4,854,499            108,052               (4,746,447)                             2% 207,906               (99,854)                                   COMPARATIVE City of Prior Lake Water Fund As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)COMPARATIVETotal ExpendituresPersonnel and current expenditures (excluding depreciation)41520.00 Finance 112,766               112,766               28,249                 84,517                                    25% 22,308                 (5,941)                                     49400.00 Water 2,178,096            2,178,096            447,915               1,730,181                              21% 376,977               (70,938)                                   2,290,862            2,290,862            476,164               1,814,698                              21% 399,285               (76,879)                                   Principal49400.00 Water 125,000               125,000                ‐                             125,000                                  0%‐                              ‐                                               125,000               125,000                ‐                             125,000                                  0%‐                              ‐                                               Interest & other49400.00 Water 44,850                 44,850                  ‐                             44,850                                    0%‐                              ‐                                               44,850                 44,850                  ‐                             44,850                                    0%‐                              ‐                                               Capital improvements55530.00 Infrastructure 665,000               665,000                ‐                             665,000                                  0% 16,951                 16,951                                    55570.00 Machinery and equipment 182,000               182,000                ‐                             182,000                                  0%‐                              ‐                                               55580.00 Software 9,000                    9,000                     ‐                             9,000                                      0%‐                              ‐                                               856,000               856,000                ‐                             856,000                                  0% 16,951                 16,951                                    Total Expenditures3,316,712            3,316,712            476,164               2,840,548                              416,236               (59,928)                                   0.0%Other Financing Uses59203.00 Transfers to other funds 912,425               912,425               83,687                 828,738                                  883,256               799,569                                  Total Other Financing Uses912,425               912,425               83,687                 828,738                                  883,256               799,569                                  Total Revenues/ Other Financing Sources4,854,499            4,854,499            108,052               (4,746,447)                             2% 207,906               (99,854)                                   Total Expenditures/Other Financing Uses4,229,137            4,229,137            559,851               3,669,286                              13% 1,299,492            739,641                                  Net Change 625,362               625,362               (451,799)              (1,077,161)                             (1,091,586)          (839,495)                                 City of Prior Lake Sewer Fund As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)RevenuesSewer Charges604‐49450.00‐37102.00 Utility Receipts ‐ Sewer 2,152,952            2,152,952            (107,898)              (2,260,850)                              ‐5% (97,643)                (10,255)                                   604‐49450.00‐37104.00 Utility Recpt‐Sewer MCES 1,891,627            1,891,627            297,459               (1,594,168)                             16% 272,295               25,164                                    604‐49450.00‐37160.00 Penalties 20,000                 20,000                 1,129                    (18,871)                                   6% 5,416                    (4,287)                                     4,064,579            4,064,579            190,690               (3,873,889)                             5% 180,068               10,622                                    Capital Facility charges604‐49450.00‐37110.00 Utility Base Fee Revenue 1,112,042            1,112,042            60,575                 (1,051,467)                             5% 59,123                 1,452                                      1,112,042            1,112,042            60,575                 (1,051,467)                             5% 59,123                 1,452                                      Total Operating Revenue5,176,621            5,176,621            251,265               (4,925,356)                             5% 239,191               12,074                                    Non‐Operating RevenueInterest (losses) on investments604‐00000.00‐36210.00 Interest Earnings 31,200                 31,200                 12,482                 (18,718)                                   40% 10,045                 2,437                                      604‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (81,768)                (81,768)                                   n/a (13,407)                (68,361)                                   31,200                 31,200                 (69,286)                (100,486)                                 ‐222% (3,362)                  (65,924)                                   Miscellaneous Revenues604‐00000.00‐36212.00 Miscellaneous Revenue‐                              ‐                             (2)                          (2)                                             n/a‐                             (2)                                             ‐                              ‐                             (2)                          (2)                                             n/a‐                             (2)                                             Total Non‐Operating Revenue31,200                 31,200                 (69,288)                (100,488)                                 ‐222% (3,362)                  (65,926)                                   Total Revenue5,207,821            5,207,821            181,977               (5,025,844)                             3% 235,829               (53,852)                                   COMPARATIVE City of Prior Lake Sewer Fund As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)COMPARATIVETotal ExpendituresPersonnel and current expenditures (excluding depreciation)41520.00 Finance 112,296               112,296               28,247                 84,049                                    25% 22,305                 (5,942)                                     49450.00 Sewer 2,966,777            2,966,777            674,287               2,292,490                              23% 643,350               (30,937)                                   3,079,073            3,079,073            702,534               2,376,539                              23% 665,655               (36,879)                                   Principal49450.00 Sewer 125,000               125,000                ‐                             125,000                                  0%‐                              ‐                                               125,000               125,000                ‐                             125,000                                  0%‐                              ‐                                               Interest & other49450.00 Sewer 44,850                 44,850                  ‐                             44,850                                    0%‐                              ‐                                               44,850                 44,850                  ‐                             44,850                                    0%‐                              ‐                                               Capital improvements55530.00 Infrastructure 729,000               729,000               621                       728,379                                  0%‐                             (621)                                        55570.00 Machinery and equipment 281,500               281,500                ‐                             281,500                                  0%‐                              ‐                                               55580.00 Software 8,700                    8,700                     ‐                             8,700                                      0%‐                              ‐                                               1,019,200            1,019,200            621                       1,018,579                              0%‐                             (621)                                        Total  Expenditures4,268,123            4,268,123            703,155               3,564,968                              665,655               (37,500)                                   Other Financing Uses59203.00 Transfers to other funds 334,750               334,750               83,688                 251,062                                  25% 757,190               673,502                                  Total Other Financing Uses334,750               334,750               83,688                 251,062                                  25% 757,190               673,502                                  Total Revenues/ Other Financing Sources5,207,821            5,207,821            181,977               (5,025,844)                             3% 235,829               (53,852)                                   Total Expenditures/Other Financing Uses4,602,873            4,602,873            786,843               3,816,030                              17% 1,422,845            636,002                                  Net Change604,948               604,948               (604,866)              (1,209,814)                             (1,187,016)          (689,854)                                 City of Prior Lake Water Quality Fund As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)RevenuesStorm Water Charges602‐49420.00‐37120.00 Storm Water Revenue 1,193,920            1,193,920            67,404                 (1,126,516)                             6% 65,186                 2,218                                      1,193,920            1,193,920            67,404                 (1,126,516)                             6% 65,186                 2,218                                      Water Charges602‐49420.00‐37160.00 Penalties 4,000                    4,000                    261                       (3,739)                                     7% 773                       (512)                                        4,000                    4,000                    261                       (3,739)                                     7% 773                       (512)                                        Total Operating Revenue1,197,920            1,197,920            67,665                 (1,130,255)                             6% 65,959                 1,706                                      Non‐Operating RevenueIntergovernmental602‐49420.00‐33610.20 County‐City Aids/Grants‐                              ‐                              ‐                              ‐                                               n/a 6,300                    (6,300)                                     ‐                              ‐                              ‐                              ‐                                               n/a 6,300                    (6,300)                                     Interest (losses) on investments602‐00000.00‐36210.00 Interest Earnings 22,800                 22,800                 7,745                    (15,055)                                   34% 7,661                    84                                            602‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (50,381)                (50,381)                                   n/a (10,064)                (40,317)                                   22,800                 22,800                 (42,636)                (65,436)                                    ‐187% (2,403)                  (40,233)                                   Total Non‐Operating Revenue22,800                 22,800                 (42,636)                (65,436)                                    ‐187% 3,897                    (46,533)                                   Total Revenues1,220,720            1,220,720            25,029                 (1,195,691)                             2% 69,856                 (44,827)                                   COMPARATIVE City of Prior Lake Water Quality Fund As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)COMPARATIVETotal ExpendituresPersonnel and current expenditures (excluding depreciation)49420.00 Water Quality 552,425               552,425               103,316               449,109                                  19% 113,396               10,080                                    552,425               552,425               103,316               449,109                                  19% 113,396               10,080                                    Capital improvements55530.00 Infrastructure 497,000               497,000               169,601               327,399                                  34% 5,013                    (164,588)                                497,000               497,000               169,601               327,399                                  34% 5,013                    (164,588)                                Total Expenditures1,049,425            1,049,425            272,917               776,508                                  26% 118,409               (154,508)                                Other Financing Uses59203.00 Transfers to other funds 118,600               118,600               29,650                 88,950                                    25% 356,545               326,895                                  Total Other Financing Uses118,600               118,600               29,650                 88,950                                    25% 356,545               326,895                                  Total Revenues/ Other Financing Sources1,220,720            1,220,720            25,029                 (1,195,691)                             2% 69,856                 (44,827)                                   Total Expenditures/Other Financing Uses1,168,025            1,168,025            302,567               865,458                                  26% 474,954               172,387                                  Net Change52,695                 52,695                 (277,538)              (330,233)                                (405,098)              127,560                                   City of Prior Lake Economic Development Authority Special Revenue Fund As of 3/31/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGTActual from 2021Budget Amended Actual Positive ( Negative) USED3/31/2021Positive (Negative)RevenuesTaxes240‐00000.00‐31010.00 Current Property Taxes 360,000               360,000                ‐                            (360,000)                               0%‐                             ‐                                             Taxes360,000               360,000                ‐                            (360,000)                               0%‐                             ‐                                             Charges for Services240‐46500.00‐34760.02 Facility Rental ‐ EDA 24,360                 24,360                 6,147                   (18,213)                                 25%‐                            6,147                                     240‐46503.00‐34760.02 Facility Rental ‐ EDA‐                             ‐                             ‐                             ‐                                             n/a 1,848                   (1,848)                                   Charges for Services 24,360                 24,360                 6,147                   (18,213)                                 25% 1,848                   4,299                                     Interest (losses) on investments240‐00000.00‐36210.00 Interest Earnings 5,400                   5,400                   166                      (5,234)                                   3% 1,647                   (1,481)                                   240‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                             ‐                            (993)                     (993)                                       n/a (2,117)                  1,124                                     Interest (losses) on investments 5,400                   5,400                   (827)                     (6,227)                                    ‐15% (470)                     357                                        Total Revenues389,760               389,760               5,320                   (384,440)                               1% 1,378                   3,942                                     ExpendituresFunction: Economic Development46500.00 ECONOMIC DEVELOPMENT 620,557               623,857               37,671                 586,186                                6% 31,239                 (6,432)                                   46503.00 TECH VILLAGE INCUBATOR‐                             ‐                             ‐                             ‐                                             n/a 1,072                   1,072                                     Total Expenditures620,557               623,857               37,671                 586,186                                6% 32,311                 (5,360)                                   Net Change(230,797)             (234,097)             (32,351)               (30,933)               COMPARATIVE