Loading...
HomeMy WebLinkAbout05(C) - Approval of the 2nd Quarter Financial Reports Report City of Prior Lake General Fund Summary - Comparison to Prior Year As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive (Negative) USED6/30/2021Positive (Negative)RevenuesTaxes 10,227,232         10,227,232         5,364,606            (4,862,626)                            52% 5,001,951            362,655                                 Licenses and Permits897,323               897,323               440,547               (456,776)                                49% 559,261               (118,714)                                Intergovernmental 2,585,932            2,585,932            1,069,436            (1,516,496)                            41% 855,599               213,837                                 Charges for Services2,022,200            2,022,200            995,031               (1,027,169)                            49% 1,085,425            (90,394)                                  Fines and Forfeitures‐                         ‐                        1,018                   1,018                                      n/a 37                         981                                         Interest (losses) on investments68,200                 68,200                 (325,890)              (394,090)                                 ‐478% (45,009)                (280,881)                                Other189,000               189,000               88,290                 (100,710)                                47% 95,506                 (7,216)                                    Transfers in 546,000               546,000               273,000               (273,000)                                50% 261,500               11,500                                   Total Revenues16,535,887         16,535,887         7,906,038            (8,629,849)                            48% 7,814,270            91,768                                   ExpendituresGeneral Government3,578,328            3,588,328            1,719,090            1,869,238                              48% 1,640,321            (78,769)                                  Public Safety8,117,433            8,245,433            3,442,078            4,803,355                              42% 2,968,047            (474,031)                                Public Works 2,322,714            2,445,904            986,116               1,459,788                              40% 1,073,818            87,702                                   Culture and Recreation2,343,574            2,361,184            937,295               1,423,889                              40% 754,163               (183,132)                                Transfer to other funds223,838               223,838               29,419                 194,419                                 13% 47,753                 18,334                                   Total Expenditures16,585,887         16,864,687         7,113,998            9,750,689                              42% 6,484,102            (629,896)                                Net Change(50,000)                (328,800)              792,040               1,120,840                              1,330,168            COMPARATIVE City of Prior Lake General Fund Revenues As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)Taxes101 31010.00 Current Property Taxes  ‐ General Purpos 9,136,642            9,136,642            4,742,463            (4,394,179)                             52% 4,346,868            395,595                                  101 31020.00 Delinquent Property Taxes ‐ General Purp‐                              ‐                             23,171                 23,171                                    n/a 51,295                 (28,124)                                   101 31040.00 Fiscal Disparities 1,090,590            1,090,590            598,972               (491,618)                                55% 603,788               (4,816)                                     Taxes10,227,232         10,227,232         5,364,606            (4,862,626)                             52% 5,001,951            362,655                                  Licenses and Permits101 32100.00 Business Licenses 735                       735                       1,260                    525                                          171% 735                       525                                          101 32110.00 Liquor Licenses 75,790                 75,790                 71,640                 (4,150)                                     95% 71,490                 150                                          101 32160.00 Refuse Haulers 4,500                    4,500                    5,135                    635                                          114% 5,335                    (200)                                        101 32175.00 Public Private Gathering Permit 720                       720                       210                       (510)                                        29% 480                       (270)                                        101 32180.00 Cigarette Licenses 1,785                    1,785                    2,040                    255                                          114% 1,785                    255                                          101 32190.00 Community Event Application 1,750                    1,750                    2,391                    641                                          137% 3,300                    (909)                                        101 32210.00 Building Permits 636,818               636,818               301,556               (335,262)                                47% 410,199               (108,643)                                101 32211.00 Retainage Forfeiture‐                              ‐                             (3,000)                  (3,000)                                     n/a‐                             (3,000)                                     101 32215.00 Mechanical Permits 92,400                 92,400                 26,605                 (65,795)                                   29% 29,251                 (2,646)                                     101 32230.00 Plumbing Permits 66,435                 66,435                 26,073                 (40,362)                                   39% 26,544                 (471)                                        101 32231.00 Sewer/Water Inspection 8,475                    8,475                    3,597                    (4,878)                                     42% 6,182                    (2,585)                                     101 32232.00 Plumbing Registrations 1,250                    1,250                     ‐                             (1,250)                                     0% 1,440                    (1,440)                                     101 32260.00 Burning Permits 4,000                    4,000                    3,040                    3,000                                      76% 2,520                    520                                          101 32270.00 Short‐term Rental Fee 2,665                    2,665                     ‐                             (2,665)                                     0%‐                              ‐                                               Licenses and Permits 897,323               897,323               440,547               (456,776)                                49% 559,261               (118,714)                                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% 14,490                 (14,490)                                   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‐                              ‐                             22,660                 22,660                                    n/a 23,244                 (584)                                        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 500                       (500)                                        101 33610.11 County Aids/Grants ‐ Operating Police‐                              ‐                             470                       470                                          n/a 1,509                    (1,039)                                     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            500,000               (500,000)                                50% 400,000               100,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            1,069,436            (1,516,496)                             41% 855,599               213,837                                  COMPARATIVE City of Prior Lake General Fund Revenues As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)COMPARATIVECharges for Services101 31810.00 Franchise Taxes 637,000               637,000               155,014               (481,986)                                24% 175,283               (20,269)                                   101 34103.00 Zoning & Subdivision Fees 30,000                 30,000                 18,841                 (11,159)                                   63% 21,008                 (2,167)                                     101 34104.00 Plan Check Fees 413,931               413,931               157,149               (256,782)                                38% 200,678               (43,529)                                   101 34105.00 Sale of Maps/Publications ‐ Reports 500                       500                       56                          (444)                                        11% 191                       (135)                                        101 34107.00 Assessment Searches ‐ Reports 700                       700                       100                       (600)                                        14% 300                       (200)                                        101 34108.00 Street Chip Seal Fee‐New Development‐                              ‐                              ‐                              ‐                                               n/a‐                              ‐                                               101 34109.00 Project Admin/Eng Fees 200,000               200,000               108,915               (91,085)                                   54% 71,944                 36,971                                    101 34203.00 Accident/Warrant Reports ‐ Reports 200                       200                       684                       484                                          342% 40                          644                                          101 34731.00 Adult League Fees 4,800                    4,800                    5,942                    1,142                                      124% 4,927                    1,015                                      101 34735.00 Recreation Program Fees 55,000                 55,000                 74,807                 19,807                                    136% 72,276                 2,531                                      101 34735.01 Recreation Program Fees Regular 9,000                    9,000                    6,001                    (2,999)                                     67% 3,425                    2,576                                      101 34760.01 Facility Rental ‐ Regular 58,865                 58,865                 32,666                 (26,199)                                   55% 16,832                 15,834                                    101 34761.00 Studio/Pavilion Rental 24,000                 24,000                 20,357                 (3,643)                                     85% 19,549                 808                                          101 34762.00 Park Shelter Rental 83,200                 83,200                 79,403                 (3,797)                                     95% 84,080                 (4,677)                                     101 34765.01 Tower Leases 282,139               282,139               274,953               (7,186)                                     97% 362,306               (87,353)                                   101 34780.00 Parking Meter Fees 35,000                 35,000                 7,830                    (27,170)                                   22% 25                          7,805                                      101 34783.00 City Contract Services 187,865               187,865               52,313                 (135,552)                                28% 52,561                 (248)                                        101 36220.16 Prof Services Fee Deposit Bldg Inspectio‐                              ‐                              ‐                              ‐                                               n/a‐                              ‐                                               Charges for Services 2,022,200            2,022,200            995,031               (1,027,169)                             49% 1,085,425            (90,394)                                   Fines and Forfeitures101 35101.00 County Court Fines‐                              ‐                             200                       200                                          n/a‐                             200                                          101 35104.00 Prosecution Restitution‐                              ‐                             818                       818                                          n/a 37                          781                                          Fines and Forfeitures‐                              ‐                             1,018                    1,018                                      n/a 37                          981                                          Interest (losses) on investments101 36210.00 Interest Earnings 112,200               112,200               72,299                 (39,901)                                   64% 71,941                 358                                          101 36215.00 Amortization ‐ Premium/Discount (44,000)                (44,000)                (52,365)                (8,365)                                     119% (42,964)                (9,401)                                     101 36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (345,824)              (345,824)                                n/a (73,986)                (271,838)                                Interest (losses) on investments 68,200                 68,200                 (325,890)              (394,090)                                 ‐478% (45,009)                (280,881)                                Other Miscellaneous Revenues101 36101.00 City Assess. Collection‐                              ‐                             492                       492                                          n/a‐                             492                                          101 36102.00 County Assess. Collection 5,000                    5,000                    2,971                    (2,029)                                     59% 6,750                    (3,779)                                     101 36211.00 Developer Agreements 130,000               130,000               5,000                    (125,000)                                4% 18,500                 (13,500)                                   101 36212.00 Miscellaneous Revenue 54,000                 54,000                 51,844                 (2,156)                                     96% 26,682                 25,162                                    101 36230.00 Contributions & Donations‐                              ‐                             25,878                 25,878                                    n/a 17,975                 7,903                                      101 39102.00 Sale of Property‐                              ‐                             2,105                    2,105                                      n/a 25,599                 (23,494)                                   Other Miscellaneous Revenues 189,000               189,000               88,290                 (100,710)                                47% 95,506                 (7,216)                                     Other financing sources101 39203.00 Transfer from Other Funds 546,000               546,000               273,000               (273,000)                                50% 261,500               11,500                                    Other financing sources 546,000               546,000               273,000               (273,000)                                50% 261,500               11,500                                     City of Prior Lake General Fund Revenues As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)COMPARATIVETotal Revenues16,535,887         16,535,887         7,906,038            (8,629,849)                             48% 7,814,270            91,768                                     City of Prior Lake General Fund Expenditures As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGTActual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)Function: General Government41110.00 MAYOR & COUNCIL75,528                 75,528                 33,173                 42,355                                    44% 34,800                 1,627                                      41130.00 ORDINANCE 6,000                    6,000                    1,988                    4,012                                      33% 2,435                    447                                         41320.00 ADMINISTRATION 390,765               390,765               204,752               186,013                                  52% 128,749               (76,003)                                   41330.00 BOARDS & COMMISSIONS11,365                 11,365                 1,615                    9,750                                      14% 3,306                    1,691                                      41400.00 CITY CLERK 129,697               129,697               46,344                 83,353                                    36% 52,025                 5,681                                      41410.00 ELECTIONS 62,200                 62,200                 9,460                    52,740                                    15% 157                       (9,303)                                     41520.00 FINANCE 596,290               596,290               234,947               361,343                                  39% 242,908               7,961                                      41540.00 INTERNAL AUDITING 42,200                 42,200                 35,470                 6,730                                      84% 36,933                 1,463                                      41550.00 ASSESSING 231,135               231,135               227,200               3,935                                      98% 220,600               (6,600)                                     41610.00 LEGAL 190,000               190,000               78,754                 111,246                                  41% 82,370                 3,616                                      41820.00 HUMAN RESOURCES 332,139               332,139               137,733               194,406                                  41% 147,214               9,481                                      41830.00 COMMUNICATIONS 174,261               178,261               77,695                 100,566                                  44% 71,033                 (6,662)                                     41910.00 COMMUNITY DEVELOPMENT385,472               385,472               118,502               266,970                                  31% 138,201               19,699                                    41920.00 INFORMATION TECHNOLOGY 398,081               404,081               208,078               196,003                                  51% 211,664               3,586                                      41940.00 FACILITIES ‐ CITY HALL 553,195               553,195               303,379               249,816                                  55% 267,926               (35,453)                                   Total ‐ Function General Government 3,578,328            3,588,328            1,719,090            1,869,238                              48% 1,640,321            (78,769)                                   Function: Public Safety42100.00 POLICE 6,013,802            6,141,802            2,652,708            3,489,094                              43% 2,284,971            (367,737)                                42200.00 FIRE 1,242,376            1,242,376            442,879               799,497                                  36% 368,423               (74,456)                                   42400.00 BUILDING INSPECTION 816,265               816,265               318,756               497,509                                  39% 300,261               (18,495)                                   42500.00 EMERGENCY MANAGEMENT16,190                 16,190                 15,735                 455                                         97% 2,392                    (13,343)                                   42700.00 ANIMAL CONTROL28,800                 28,800                 12,000                 16,800                                    42% 12,000                  ‐                                              Total ‐ Function Public Safety 8,117,433            8,245,433            3,442,078            4,803,355                              42% 2,968,047            (474,031)                                Function: Public Works43050.00 ENGINEERING 419,812               419,812               192,829               226,983                                  46% 194,669               1,840                                      43100.00 STREET 1,384,871            1,464,261            532,294               931,967                                  36% 672,768               140,474                                  43400.00 CENTRAL GARAGE 518,031               561,831               255,732               306,099                                  46% 206,381               (49,351)                                   43600.00 DEVELOPMENT PROJECTS‐                              ‐                             5,261                    (5,261)                                     n/a‐                             (5,261)                                     Total ‐ Function Public Works 2,322,714            2,445,904            986,116               1,459,788                              40% 1,073,818            87,702                                    Function: Culture and Recreation45100.00 RECREATION 512,825               512,825               192,196               320,629                                  37% 167,200               (24,996)                                   45200.00 PARKS 1,760,303            1,777,913            701,817               1,076,096                              39% 558,095               (143,722)                                45500.00 LIBRARIES 70,446                 70,446                 43,282                 27,164                                    61% 28,868                 (14,414)                                   Total ‐ Function Culture and Recreation 2,343,574            2,361,184            937,295               1,423,889                              40% 754,163               (183,132)                                00000.00 Transfer to Other Funds 223,838               223,838               29,419                 194,419                                  13% 47,753                 18,334                                    Total Expenditures16,585,887         16,864,687         7,113,998            9,750,689                              42% 6,484,102            (629,896)                                COMPARATIVE City of Prior LakeExpenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 6/30/2022(Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)GENERAL FUNDFunction: General Government41110.00 MAYOR & COUNCIL 68,728                 68,728                    29,810                 38,918                              43% 31,054                     1,244                                     41320.00 ADMINISTRATION 276,235               276,235                 122,485               153,750                            44% 93,798                     (28,688)                                 41330.00 BOARDS & COMMISSIONS 10,765                 10,765                    1,615                   9,150                                15% 3,307                       1,692                                     41400.00 CITY CLERK FUNCTIONS 128,447               128,447                 45,585                 82,862                              35% 51,825                     6,240                                     41410.00 ELECTIONS 57,690                 57,690                    154                      57,536                              0% 137                          (17)                                         41520.00 FINANCE 570,810               570,810                 227,269               343,541                            40% 233,730                   6,461                                     41820.00 HUMAN RESOURCES 287,689               287,689                 123,635               164,054                            43% 117,208                   (6,427)                                   41830.00 COMMUNICATIONS 142,261               142,261                 49,715                 92,546                              35% 49,718                     3                                             41910.00 COMMUNITY DEVELOPMENT 335,822               335,822                 115,219               220,603                            34% 134,448                   19,229                                   41920.00 INFORMATION TECHNOLOGY 239,241               239,241                 87,347                 151,894                            37% 96,167                     8,820                                     41940.00 FACILITIES ‐ CITY HALL 88,220                 88,220                    39,103                 49,117                              44% 25,956                     (13,147)                                 Total ‐ Function General Government 2,205,908           2,205,908              841,937               1,363,971                         38% 837,348                   (4,588)                                   Function: Public Safety42100.00 POLICE 5,445,654           5,445,654              2,307,431           3,138,223                         42% 2,002,551               (304,880)                               42200.00 FIRE 900,773               900,773                 271,479               629,294                            30% 230,298                   (41,182)                                 42400.00 BUILDING INSPECTION 784,947               784,947                 311,521               473,426                            40% 287,973                   (23,547)                                 Total ‐ Function Public Safety 7,131,374           7,131,374              2,890,431           4,240,943                         41% 2,520,822               (369,609)                               Function: Public Works43050.00 ENGINEERING 359,793               359,793                 152,145               207,648                            42% 145,142                   (7,003)                                   43100.00 STREET 537,643               537,643                 197,486               340,157                            37% 215,323                   17,838                                   43400.00 CENTRAL GARAGE 262,456               262,456                 105,051               157,405                            40% 100,699                   (4,353)                                   Total ‐ Function Public Works 1,159,892           1,159,892              454,682               705,210                            39% 461,164                   6,482                                     Function: Culture and Recreation45100.00 RECREATION 377,023               377,023                 131,932               245,091                            35% 113,027                   (18,905)                                 45200.00 PARKS 1,162,215           1,162,215              469,799               692,416                            40% 390,140                   (79,658)                                 Total ‐ Function Culture and Recreation 1,539,238           1,539,238              601,731               937,507                            39% 503,168                   (98,563)                                 General Fund Payroll Only Expenditures Total 12,036,412         12,036,412            4,788,781           7,247,631                         40% 4,322,502               (466,279)                               EDA FUNDFunction:  Economic Development   46500.00 ECONOMIC DEVELOPMENT 143,239               143,239                 57,426                 85,813                              40% 62,789                     5,363                                     EDA Fund Payroll Only Expenditures Total 143,239               143,239                 57,426                 85,813                              40% 62,789                     5,363                                     COMPARATIVE City of Prior LakeExpenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 6/30/2022(Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)COMPARATIVEWATER FUNDFunction: Water41520.00 Finance 84,371                 84,371                    34,436                 49,935                              41% 32,978                     (1,459)                                   49400.00 Water 794,320               794,320                 370,902               423,418                            47% 319,934                   (50,968)                                 Water Fund Payroll Only Expenditures Total 878,691               878,691                 405,338               473,353                            46% 352,912                   (52,427)                                 SEWER FUNDFunction: Sewer41520.00 Finance 84,371                 84,371                    34,431                 49,940                              41% 32,973                     (1,458)                                   49450.00 Sewer 786,039               786,039                 288,417               497,622                            37% 320,468                   32,051                                   Sewer Fund Payroll Only Expenditures Total 870,410               870,410                 322,848               547,562                            37% 353,442                   30,594                                   STORM WATER FUNDFunction: Storm Water49420.00 Water Quality 356,875               356,875                 152,627               204,248                            43% 145,814                   (6,813)                                   Storm Water Fund Payroll Only Expenditures Total 356,875               356,875                 152,627               204,248                            43% 145,814                   (6,813)                                   City‐Wide Total Payroll Expenditures 14,285,627         14,285,627            5,727,020           8,558,607                        40% 5,237,458               (489,562)                                City of Prior Lake Debt Service Funds As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)RevenuesProperty TaxesCurrent Property Taxes 3,455,529           3,455,529           1,802,601           (1,652,928)                            52% 1,647,105           155,496                                Special AssessmentsCity Assess. Collections‐                             ‐                            27,275                 27,275                                   n/a 65,862                 (38,587)                                 County Assess. Collection 457,042               457,042               206,615               (250,427)                               45% 221,181               (14,566)                                 Interest (losses) on investmentsInterest Earnings 38,162                 38,162                 21,350                 (16,812)                                 56% 23,194                 (1,844)                                   Unrealized Inv.Gain(Loss)‐                             ‐                            (96,483)               (96,483)                                 n/a (23,481)               (73,002)                                 Other Financing SourcesTransfer from Other Funds 1,342,764           1,342,764           109,617               (1,233,147)                            8% 136,678               (27,061)                                 Total Revenues5,293,497           5,293,497           2,070,975           (3,222,522)                            39% 2,070,539           436                                        ExpendituresDebt ServicePrincipal 4,325,713           4,325,713           139,617               4,186,096                             3% 136,705               (2,912)                                   Interest and Other 1,035,199           1,035,199           518,821               516,378                                50% 484,654               (34,167)                                 Transfers to Other Funds 233,000               233,000                ‐                            233,000                                0%‐                             ‐                                             Total Expenditures5,593,912           5,593,912           658,438               4,935,474                             12% 621,359               (37,079)                                 Net Change(300,415)             (300,415)             1,412,537           1,449,180           COMPARATIVE City of Prior Lake Cable Fund As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)RevenuesCharges for Services210‐41340.00‐34304.00PEG Access Fees 23,800                 23,800                 5,369                   (18,431)                                 23% 6,206                   (837)                                       Interest (losses) on investments210‐41340.00‐36210.00Interest Earnings‐                             ‐                            904                      904                                        n/a 747                      157                                        210‐41340.00‐36225.00Unrealized Inv. Gain (Loss)‐                             ‐                            (4,136)                  (4,136)                                   n/a (722)                     (3,414)                                   Total Revenues23,800                 23,800                 2,137                   (21,663)                                 9% 6,231                   (4,094)                                   ExpendituresCurrent Expenditures210‐41340.00‐52400.20Small  Equipment ‐ Technology‐                             ‐                            55                         (55)                                         n/a 1,407                   1,352                                     Capital Outlay210‐41340.00‐55570.00Machinery and Equipment‐                            39,780                 7,699                   32,081                                   19% 3,641                   (4,058)                                   Total Expenditures‐                            39,780                 7,754                   32,026                                   19% 5,048                   (2,706)                                   Net Change23,800                 (15,980)               (5,617)                  1,183                   COMPARATIVE City of Prior Lake Capital Park Fund As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGTActual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)RevenuesCharges for Services225‐45200.00‐34760.01 Facility Rental ‐ Regular 24,000                 24,000                 10,200                 (13,800)                                 43% 12,000                 (1,800)                                   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               10,200                 (576,300)                               2% 34,752                 (24,552)                                 Interest (losses) on investments225‐00000.00‐36210.00 Interest Earnings 22,000                 22,000                 12,449                 (9,551)                                   57% 12,347                 102                                        225‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                             ‐                            (57,174)               (57,174)                                 n/a (12,007)               (45,167)                                 Interest (losses) on investments 22,000                 22,000                 (44,725)               (66,725)                                  ‐203% 340                      (45,065)                                 Contributions and donations225‐00000.00‐36230.00 Contributions & Donations‐                             ‐                            11,675                 11,675                                   n/a 25,031                 (13,356)                                 Contributions and donations‐                             ‐                            11,675                 11,675                                   n/a 25,031                 (13,356)                                 Total Revenues608,500               608,500               (22,850)               (631,350)                                ‐4% 60,123                 (82,973)                                 Expenditures54320.00 Miscellaneous‐                             ‐                             ‐                             ‐                                             n/a 130                      130                                        53100.80 Professional Services‐General 3,200                   3,200                   3,402                   (202)                                       106% 5,987                   2,585                                     55010.00 Projects ‐ Contract Vouchers‐                             ‐                            13,429                 (13,429)                                 n/a 164,490               151,061                                55020.00 Projects ‐ Engineering‐                             ‐                            6,817                   (6,817)                                   n/a 82,459                 75,642                                   55050.00 Projects ‐ Professional Services‐                             ‐                            1,184                   (1,184)                                   n/a‐                            (1,184)                                   55530.00 Infrastructure‐                             ‐                            10,349                 (10,349)                                 n/a 1,584                   (8,765)                                   Total Expenditures3,200                   3,200                   35,181                 (31,981)                                 1099% 254,650               219,469                                Net Change605,300               605,300               (58,031)               (194,527)             COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)RevenuesTaxes410‐00000.00‐31010.00 Current Property Taxes 700,000               700,000               364,984               (335,016)                                52% 440,631               (75,647)                                   Taxes700,000               700,000               364,984               (335,016)                                52% 440,631               (75,647)                                   Interest (losses) on investments410‐00000.00‐36210.00 Interest Earnings 6,800                    6,800                    6,526                    (274)                                        96% 4,331                    2,195                                      410‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (30,506)                (30,506)                                   n/a (4,441)                  (26,065)                                   Interest (losses) on investments 6,800                    6,800                    (23,980)                (30,780)                                    ‐353% (110)                      (23,870)                                   Sale of assets410‐00000.00‐39102.00 Sale of Property‐                              ‐                             66,003                 66,003                                    n/a 70,925                 (4,922)                                     Sale of assets‐                              ‐                             66,003                 66,003                                    n/a 70,925                 (4,922)                                     Transfers in410‐00000.00‐39203.00 Transfer from Other Funds 217,500               217,500               108,750               (108,750)                                50% 155,000               (46,250)                                   Transfers in217,500               217,500               108,750               (108,750)                                50% 155,000               (46,250)                                   Total Revenues924,300               924,300               515,757               (408,543)                                56% 666,446               (150,689)                                COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)COMPARATIVEExpendituresGeneral GovernmentPublic SafetyPolice410‐42100.00‐55550.00 Vehicles 260,000               260,000               8,858                    251,142                                  3% 51,243                 42,385                                    410‐42100.00‐55570.00 Machinery & Equipment 38,900                 38,900                 27,750                 11,150                                    71% 25,965                 (1,785)                                     Fire410‐42200.00‐55550.00 Vehicles 135,000               565,000               426,979               138,021                                  76% 24,615                 (402,364)                                410‐42200.00‐55570.00 Machinery & Equipment 53,000                 53,000                 52,998                 2                                              100%‐                             (52,998)                                   Total Public Safety 486,900               916,900               516,585               400,315                                  56% 101,823               (414,762)                                Public WorksStreet410‐43100.00‐55550.00 Vehicles‐                              ‐                              ‐                              ‐                                               n/a 207,140               207,140                                  410‐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                 12,541                 7,459                                      63% 19,937                 7,396                                      Total Public Works 85,000                 85,000                 12,541                 72,459                                    15% 231,477               218,936                                  Culture and Recreation/Parks410‐45200.00‐55550.00 Vehicles 270,000               270,000                ‐                             270,000                                  0% 221,521               221,521                                  410‐45200.00‐55570.00 Machinery and Equipment 79,500                 79,500                 69,144                 10,356                                    87% 63,970                 (5,174)                                     Total Culture & Recreation 349,500               349,500               69,144                 280,356                                  20% 285,491               216,347                                  Sewer410‐49450.00‐55550.00 Vehicles‐                              ‐                              ‐                              ‐                                               n/a 75,556                 75,556                                    Total Utility‐                              ‐                              ‐                              ‐                                               n/a 75,556                 75,556                                    Total Expenditures921,400               1,351,400            598,270               753,130                                  44% 694,347               96,077                                    Net Change2,900                    (427,100)              (82,513)                (27,901)                 City of Prior Lake Revolving Park Equipment Fund As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGTActual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)RevenuesTaxes430‐00000.00‐31010.00 Current Property Taxes 405,000               405,000               210,927               (194,073)                                52% 198,250               12,677                                    Taxes405,000               405,000               210,927               (194,073)                                52% 198,250               12,677                                    Interest (losses) on investments430‐00000.00‐36210.00 Interest Earnings 13,800                 13,800                 8,959                    (4,841)                                     65% 9,573                    (614)                                        430‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (40,737)                (40,737)                                   n/a (9,411)                  (31,326)                                   Interest (losses) on investments 13,800                 13,800                 (31,778)                (45,578)                                    ‐230% 162                       (31,940)                                   Transfers in410‐00000.00‐39203.00 Transfer from Other Funds‐                              ‐                             49,358                 49,358                                    n/a‐                             49,358                                    Transfers in‐                              ‐                             49,358                 49,358                                    n/a‐                             49,358                                    Total Revenues418,800               418,800               228,507               (190,293)                                55% 198,412               30,095                                    ExpendituresCulture and RecreationDept 45200.00 ‐ PARKS430‐45200.00‐55020.00 Projects ‐ Engineering‐                              ‐                             5,753                    (5,753)                                     n/a 10,359                 4,606                                      430‐45200.00‐55050.00‐PRK22‐000001 Projects ‐ Professional Services‐                              ‐                             28,607                 (28,607)                                   n/a‐                             (28,607)                                   430‐45200.00‐55530.00 Infrastructure 158,000               158,000               8,332                    149,668                                  5% 1,800                    (6,532)                                     Dept 45500.00 ‐ LIBRARY430‐45500.00‐55050.00 Projects ‐ Professional Services‐                             38,000                  ‐                             38,000                                    0%‐                              ‐                                              Transfers to other funds430‐80000.00‐59203.00 Transfers to other funds‐                              ‐                              ‐                              ‐                                              n/a 414,000               414,000                                  Total Culture & Recreation 158,000               196,000               42,692                 153,308                                  22% 426,159               383,467                                  Total Expenditures158,000               196,000               42,692                 153,308                                  22% 426,159               383,467                                  Net Change260,800               222,800               185,815               (227,747)              COMPARATIVE City of Prior Lake Facilities Management Fund As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)RevenuesTaxes440‐00000.00‐31010.00 Current Property Taxes105,000               105,000               54,712                  (50,288)                                  52% 42,094                  12,618                                   Taxes105,000               105,000               54,712                  (50,288)                                  52% 42,094                  12,618                                   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                    10,183                  3,883                                      162% 4,019                    6,164                                      440‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (46,876)                (46,876)                                  n/a (3,904)                   (42,972)                                  Interest (losses) on investments6,300                    6,300                    (36,693)                (42,993)                                   ‐582% 115                        (36,808)                                  Transfers in440‐00000.00‐39203.00 Transfer from Other Funds 24,600                  24,600                  12,300                  (12,300)                                  50% 65,000                  (52,700)                                  Transfers in24,600                  24,600                  12,300                  (12,300)                                  50% 65,000                  (52,700)                                  Total Revenues670,900               670,900               97,819                  (573,081)                                15% 107,209               (9,390)                                    ExpendituresFunction: General Government41940‐55050.00 Projects Professional Svcs‐ FACILITIES ‐ CITY HALL‐                              ‐                             11,309                  (11,309)                                  n/a 10,979                  (330)                                        41940‐55520.00 Building & Building Improvements‐FACILITIES ‐ CITY HAL‐                              ‐                              ‐                              ‐                                               n/a 15,050                  15,050                                   Total ‐ Function General Government‐                              ‐                             11,309                  (11,309)                                  n/a 26,029                  14,720                                   Function: Public Safety42100‐55520.00 Building & Building Improvements‐POLICE 167,000               167,000                ‐                             167,000                                 0%‐                              ‐                                               42200‐55050.00 Projects‐Professional Services‐FIRE‐                              ‐                             49,183                  (49,183)                                  n/a‐                             (49,183)                                  42200‐55520.00 Building & Building Improvements‐FIRE 700,000               700,000                ‐                             700,000                                 0% 15,985                  15,985                                   Total ‐ Function Public Safety867,000               867,000               49,183                  817,817                                 6% 15,985                  (33,198)                                  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            60,492                  952,508                                 6% 42,014                  (18,478)                                  Net Change(342,100)              (342,100)              37,327                  65,195                  COMPARATIVE City of Prior Lake Permanent Improvement Revolving Fund As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGTActual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)RevenuesTaxes450‐00000.00‐31010.00 Property Taxes  ‐ General Purpose‐                              ‐                              ‐                              ‐                                         n/a 63,141                 (63,141)                                   450‐00000.00‐31810.00 Franchise Taxes 1,050,000            1,050,000            241,805               (808,195)                           23%‐                             241,805                                  Taxes1,050,000            1,050,000            241,805               (808,195)                           23% 63,141                 178,664                                  Special Assessments450‐00000.00‐36101.00 City Assess. Collections‐                              ‐                             2,965                    2,965                                 n/a 10,580                 (7,615)                                     450‐00000.00‐36102.00 County Assess. Collection 150,731               150,731               57,700                 (93,031)                             38% 67,155                 (9,455)                                     150,731               150,731               60,665                 (90,066)                             40% 77,735                 (17,070)                                   Interest (losses) on investments450‐00000.00‐36210.00 Interest Earnings 5,700                    5,700                    3,406                    (2,294)                               60% 2,839                    567                                         450‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (13,621)                (13,621)                             n/a (2,832)                  (10,789)                                   Interest (losses) on investments 5,700                    5,700                    (10,215)                (15,915)                              ‐179% 7                            (10,222)                                   Transfers in450‐00000.00‐39203.00 Transfer from Other Funds‐                              ‐                              ‐                              ‐                                         n/a‐                              ‐                                              Transfers in‐                              ‐                              ‐                              ‐                                         n/a‐                              ‐                                              Total Revenues1,206,431            1,206,431            292,255               (914,176)                           24% 140,883               151,372                                  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               11,360                 271,391                            4% 16,075                 4,715                                      Total Expenditures282,751               282,751               11,360                 271,391                            4% 16,075                 4,715                                      Net Change923,680               923,680               280,895               124,808               COMPARATIVE City of Prior Lake Water Fund As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)RevenuesOperating RevenueWater Charges601‐49400.00‐37100.00 Utility Receipts ‐ Water 3,361,372            3,361,372            849,010               (2,512,362)                             25% 909,308               (60,298)                                   601‐49400.00‐37160.00 Penalties 20,000                 20,000                 2,989                    (17,011)                                   15% 7,773                    (4,784)                                     3,381,372            3,381,372            851,999               (2,529,373)                             25% 917,081               (65,082)                                   Utility Base Fee601‐49400.00‐37110.00 Utility Base Fee Revenue 1,300,902            1,300,902            495,334               (805,568)                                38% 478,315               17,019                                    1,300,902            1,300,902            495,334               (805,568)                                38% 478,315               17,019                                    Meter Sales601‐49400.00‐37170.00 Water Meter Sales 79,825                 79,825                 35,988                 (43,837)                                   45% 50,543                 (14,555)                                   601‐49400.00‐37175.00 Pressure Reducers 25,000                 25,000                 8,757                    (16,243)                                   35% 12,003                 (3,246)                                     104,825               104,825               44,745                 (60,080)                                   43% 62,546                 (17,801)                                   Total Operating Revenue4,787,099            4,787,099            1,392,078            (3,395,021)                             29% 1,457,942            (65,864)                                   Non‐Operating RevenueIntergovernmental601‐00000.00‐33422.15 State Aids/Grants ‐ Operating Public Wor‐                              ‐                             1,570                    1,570                                      n/a 133                       1,437                                      ‐                              ‐                             1,570                    1,570                                      n/a 133                       1,437                                      Interest (losses) on investments601‐00000.00‐36210.00 Interest Earnings 67,400                 67,400                 46,309                 (21,091)                                   69% 43,716                 2,593                                      601‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (211,587)              (211,587)                                n/a (42,312)                (169,275)                                67,400                 67,400                 (165,278)              (232,678)                                 ‐245% 1,404                    (166,682)                                Miscellaneous Revenues601‐00000.00‐36212.00 Miscellaneous Revenue‐                              ‐                             500                       500                                          n/a 826                       (326)                                        601‐00000.00‐36102.00 County Assess Collection‐                              ‐                             36,102                 36,102                                    n/a 37,305                 (1,203)                                     601‐49400.00‐37190.00 Miscellaneous Revenue Adj‐                              ‐                             (3)                          (3)                                             n/a (42)                        39                                            ‐                              ‐                             36,599                 36,599                                     ‐                             38,089                 (1,490)                                     Total Non‐Operating Revenue67,400                 67,400                 (127,109)              (194,509)                                 ‐189% 39,626                 (166,735)                                Total Revenues4,854,499            4,854,499            1,264,969            (3,589,530)                             26% 1,497,568            (232,599)                                COMPARATIVE City of Prior Lake Water Fund As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)COMPARATIVETotal ExpendituresPersonnel and current expenditures (excluding depreciation)41520.00 Finance 112,766               112,766               53,623                 59,143                                    48% 42,446                 (11,177)                                   49400.00 Water 2,178,096            2,178,096            1,144,024            1,034,072                              53% 910,191               (233,833)                                2,290,862            2,290,862            1,197,647            1,093,215                              52% 952,637               (245,010)                                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                 22,425                 22,425                                    50% 24,825                 2,400                                      44,850                 44,850                 22,425                 22,425                                    50% 24,825                 2,400                                      Capital improvements55530.00 Infrastructure 665,000               665,000               23,740                 641,260                                  4% 86,906                 63,166                                    55570.00 Machinery and equipment 182,000               182,000                ‐                             182,000                                  0%‐                              ‐                                               55580.00 Software 9,000                    9,000                    16,053                 (7,053)                                     178%‐                             (16,053)                                   856,000               856,000               39,793                 816,207                                  5% 86,906                 47,113                                    Total Expenditures3,316,712            3,316,712            1,259,865            2,056,847                              1,064,368            (195,497)                                0.0%Other Financing Uses59203.00 Transfers to other funds 912,425               912,425               236,212               676,213                                  1,073,606            837,394                                  Total Other Financing Uses912,425               912,425               236,212               676,213                                  1,073,606            837,394                                  Total Revenues/ Other Financing Sources4,854,499            4,854,499            1,264,969            (3,589,530)                             26% 1,497,568            (232,599)                                Total Expenditures/Other Financing Uses4,229,137            4,229,137            1,496,077            2,733,060                              35% 2,137,974            641,897                                  Net Change 625,362               625,362               (231,108)              (856,470)                                (640,406)              (874,496)                                 City of Prior Lake Sewer Fund As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)RevenuesSewer Charges604‐49450.00‐37102.00 Utility Receipts ‐ Sewer 2,152,952            2,152,952            415,773               (1,737,179)                             19% 462,404               (46,631)                                   604‐49450.00‐37104.00 Utility Recpt‐Sewer MCES 1,891,627            1,891,627            843,914               (1,047,713)                             45% 845,616               (1,702)                                     604‐49450.00‐37160.00 Penalties 20,000                 20,000                 2,698                    (17,302)                                   13% 11,697                 (8,999)                                     4,064,579            4,064,579            1,262,385            (2,802,194)                             31% 1,319,717            (57,332)                                   Capital Facility charges604‐49450.00‐37110.00 Utility Base Fee Revenue 1,112,042            1,112,042            430,054               (681,988)                                39% 419,823               10,231                                    1,112,042            1,112,042            430,054               (681,988)                                39% 419,823               10,231                                    Total Operating Revenue5,176,621            5,176,621            1,692,439            (3,484,182)                             33% 1,739,540            (47,101)                                   Non‐Operating RevenueInterest (losses) on investments604‐00000.00‐36210.00 Interest Earnings 31,200                 31,200                 27,091                 (4,109)                                     87% 21,438                 5,653                                      604‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (122,595)              (122,595)                                n/a (21,013)                (101,582)                                31,200                 31,200                 (95,504)                (126,704)                                 ‐306% 425                       (95,929)                                   Miscellaneous Revenues604‐00000.00‐36212.00 Miscellaneous Revenue‐                              ‐                             (2)                          (2)                                             n/a‐                             (2)                                             604‐00000.00‐39102.00 Sale of Property‐                              ‐                             139,046               139,046                                  n/a‐                             139,046                                  ‐                              ‐                             139,044               139,044                                  n/a‐                             139,044                                  Total Non‐Operating Revenue31,200                 31,200                 43,540                 12,340                                    140% 425                       43,115                                    Total Revenue5,207,821            5,207,821            1,735,979            (3,471,842)                             33% 1,739,965            (3,986)                                     COMPARATIVE City of Prior Lake Sewer Fund As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)COMPARATIVETotal ExpendituresPersonnel and current expenditures (excluding depreciation)41520.00 Finance 112,296               112,296               53,617                 58,679                                    48% 42,442                 (11,175)                                   49450.00 Sewer 2,966,777            2,966,777            1,345,548            1,621,229                              45% 1,266,907            (78,641)                                   3,079,073            3,079,073            1,399,165            1,679,908                              45% 1,309,349            (89,816)                                   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                 22,425                 22,425                                    50% 24,825                 2,400                                      44,850                 44,850                 22,425                 22,425                                    50% 24,825                 2,400                                      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                    16,052                 (7,352)                                     185%‐                             (16,052)                                   1,019,200            1,019,200            16,673                 1,002,527                              2%‐                             (16,673)                                   Total  Expenditures4,268,123            4,268,123            1,438,263            2,829,860                              1,334,174            (104,089)                                Other Financing Uses59203.00 Transfers to other funds 334,750               334,750               167,375               167,375                                  50% 848,690               681,315                                  Total Other Financing Uses334,750               334,750               167,375               167,375                                  50% 848,690               681,315                                  Total Revenues/ Other Financing Sources5,207,821            5,207,821            1,735,979            (3,471,842)                             33% 1,739,965            (3,986)                                     Total Expenditures/Other Financing Uses4,602,873            4,602,873            1,605,638            2,997,235                              35% 2,182,864            577,226                                  Net Change604,948               604,948               130,341               (474,607)                                (442,899)              (581,212)                                 City of Prior Lake Water Quality Fund As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)RevenuesStorm Water Charges602‐49420.00‐37120.00 Storm Water Revenue 1,193,920            1,193,920            479,051               (714,869)                                40% 464,190               14,861                                    602‐49420.00‐32250.00 Wetland Application Fee‐                              ‐                             150                       150                                          n/a 450                       (300)                                        1,193,920            1,193,920            479,201               (714,719)                                40% 464,640               14,561                                    Water Charges602‐49420.00‐37160.00 Penalties 4,000                    4,000                    710                       (3,290)                                     18% 1,858                    (1,148)                                     4,000                    4,000                    710                       (3,290)                                     18% 1,858                    (1,148)                                     Total Operating Revenue1,197,920            1,197,920            479,911               (718,009)                                40% 466,498               13,413                                    Non‐Operating RevenueIntergovernmental602‐00000.00‐33422.10 State Aids/Grants‐                              ‐                              ‐                              ‐                                               n/a 27,000                 (27,000)                                   602‐49420.00‐33610.20 County‐City Aids/Grants‐                              ‐                              ‐                              ‐                                               n/a 6,300                    (6,300)                                     ‐                              ‐                              ‐                              ‐                                               n/a 33,300                 (33,300)                                   Interest (losses) on investments602‐00000.00‐36210.00 Interest Earnings 22,800                 22,800                 16,123                 (6,677)                                     71% 15,649                 474                                          602‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                              ‐                             (73,338)                (73,338)                                   n/a (15,171)                (58,167)                                   22,800                 22,800                 (57,215)                (80,015)                                    ‐251% 478                       (57,693)                                   Miscellaneous Revenues602‐00000.00‐36212.00 Miscellaneous Revenue‐                              ‐                              ‐                              ‐                                               n/a 5,339                    (5,339)                                     ‐                              ‐                              ‐                              ‐                                               n/a 5,339                    (5,339)                                     Total Non‐Operating Revenue22,800                 22,800                 (57,215)                (80,015)                                    ‐251% 39,117                 (96,332)                                   Total Revenues1,220,720            1,220,720            422,696               (798,024)                                35% 505,615               (82,919)                                   COMPARATIVE City of Prior Lake Water Quality Fund As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGT Actual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)COMPARATIVETotal ExpendituresPersonnel and current expenditures (excluding depreciation)49420.00 Water Quality 552,425               552,425               228,583               323,842                                  41% 333,927               105,344                                  552,425               552,425               228,583               323,842                                  41% 333,927               105,344                                  Capital improvements55530.00 Infrastructure 497,000               497,000               171,528               325,472                                  35% 5,013                    (166,515)                                497,000               497,000               171,528               325,472                                  35% 5,013                    (166,515)                                Total Expenditures1,049,425            1,049,425            400,111               649,314                                  38% 338,940               (61,171)                                   Other Financing Uses59203.00 Transfers to other funds 118,600               118,600               59,300                 59,300                                    50% 388,295               328,995                                  Total Other Financing Uses118,600               118,600               59,300                 59,300                                    50% 388,295               328,995                                  Total Revenues/ Other Financing Sources1,220,720            1,220,720            422,696               (798,024)                                35% 505,615               (82,919)                                   Total Expenditures/Other Financing Uses1,168,025            1,168,025            459,411               708,614                                  39% 727,235               267,824                                  Net Change52,695                 52,695                 (36,715)                (89,410)                                   (221,620)              184,905                                   City of Prior Lake Economic Development Authority Special Revenue Fund As of 6/30/2022 (Preliminary & Unaudited)Variance from Variance2022 2022 2022 Amended Budget ‐ % BDGTActual from 2021Budget Amended Actual Positive ( Negative) USED6/30/2021Positive (Negative)RevenuesTaxes240‐00000.00‐31010.00 Current Property Taxes 360,000               360,000               187,591               (172,409)                               52% 185,108               2,483                                     240‐00000.00‐31040.00 Fiscal Disparities‐                             ‐                            818                      818                                        n/a‐                            818                                        Taxes360,000               360,000               188,409               (171,591)                               52% 185,108               3,301                                     Charges for Services240‐46500.00‐34760.02 Facility Rental ‐ EDA 24,360                 24,360                 14,343                 (10,017)                                 59%‐                            14,343                                   240‐46503.00‐34760.02 Facility Rental ‐ EDA‐                             ‐                             ‐                             ‐                                             n/a 2,435                   (2,435)                                   Charges for Services 24,360                 24,360                 14,343                 (10,017)                                 59% 2,435                   11,908                                   Interest (losses) on investments240‐00000.00‐36210.00 Interest Earnings 5,400                   5,400                   448                      (4,952)                                   8% 3,356                   (2,908)                                   240‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐                             ‐                            (2,044)                  (2,044)                                   n/a (3,396)                  1,352                                     Interest (losses) on investments 5,400                   5,400                   (1,596)                  (6,996)                                    ‐30% (40)                       1,556                                     Contributions and Donations240‐00000.00‐36230.00 Contributions and Donations‐                             ‐                            15,000                 15,000                                   n/a‐                            15,000                                   Contributions and Donations‐                             ‐                            15,000                 15,000                                   n/a‐                            15,000                                   Total Revenues389,760               389,760               216,156               (173,604)                               55% 187,503               28,653                                   ExpendituresFunction: Economic Development46500.00 ECONOMIC DEVELOPMENT 620,557               623,857               73,527                 550,330                                12% 155,846               82,319                                   46503.00 TECH VILLAGE INCUBATOR‐                             ‐                             ‐                             ‐                                             n/a 1,150                   1,150                                     Total Expenditures620,557               623,857               73,527                 550,330                                12% 156,996               83,469                                   Net Change(230,797)             (234,097)             142,629               30,507                 COMPARATIVE