Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
_11 01 2021 City Council Agenda Packet
2022 Budget / Tax Levy Discussion ‐ Nov 1 Council Workshop1.65%‐0.10%0.82%4.12%0.07%‐1.00%0.00%1.00%2.00%3.00%4.00%5.00%6.00%7.00%EDAPersonnel Adds ‐ Public SafetyPersonnel Adds ‐ All OtherCIP ‐Tax Levy ComponentsMandatoryTotal: 6.55% $938,000$(15,000)$590,000$236,000CAPITAL IMPROVEMENT PROGRAM: ‐.10%50k Equipment Replacement30k Park Equipment Replacment25k Facilities Mgmt(120k) Street Overlay/PIR PERSONNEL ADDS‐PUBLIC SAFETY: 4.12%251k Police‐2022 Impact of 2021 Mid‐Year Wage Adjustment142k Assist Fire Chief 100k Police officer97k Public Safety Workers Comp Rate Increase590k Subtotal Public Safety (Police/Fire) Personnel Adds/New FundingPERSONNEL ADDS ‐ALL OTHER ‐.82%67k Receptionist50k Community Development AssistMANDATORY: 1.65%Staffing: 296k Wage/Taxes/Benefits ‐Labor Agreements 71k Health Insurance16k Workers Compensation/Other Benefits54k Election JudgesCurrent Expenditures:43k Maintenance (General, Bldg, Equipment)22k Property/General Liability Insurance Rates58k Professional Services (Legal, Engineering, Assess, etc.)15k Software Service Contracts 52k Police Body Cam and Taser Contract119k Debt Service Other:(788k) Net Revenue increase (building fees and SMSC police aid)278k Levy Impact of Change in Use of Reserves from 2021 to 2022EDA: .07%10k EDA Levy$10,000$117,000 City of Prior Lake2022 Council Workshop 11/1/2021 2022 BudgetAttachment 1 Budgeted FundsPreliminaryDebt Capital Revolving Revolving Park Permanent Facilities TotalTotalGeneral Service Cable Park Equipment Equipment Improvement Management EDA Governmental Water Sewer Water Quality Enterprise BudgetedFund Funds Fund Fund Fund Fund Revolving Fund Fund Funds Fund Fund Fund Funds FundsRevenues / SourcesProperty TaxesLevy - Tax Capacity 10,003,394$ 3,455,529$ -$ -$ 700,000$ 405,000$ -$ 105,000$ 360,000$ 15,028,923$ -$ -$ -$ -$ 15,028,923$ Levy - Market Value 223,838 - - - - - - 223,838 - - - - 223,838 MVHC Aid - - - - - - - - - - - - - Special Assessments - 457,042 - - - 150,731 - - 607,773 - - - - 607,773 Licenses & Permits 897,323 - - - - - - 897,323 - - - - 897,323 Fines & Forfeits - - - - - - - - - - - - - Intergovernmental 2,585,932 - - - - 535,000 - 3,120,932 - - - - 3,120,932 Charges for Services 2,022,200 - 23,800 562,500 - 1,050,000 - 24,360 3,682,860 4,787,099 5,176,621 1,197,920 11,161,640 14,844,500 Other Revenues 257,200 38,162 - 46,000 6,800 13,800 5,700 6,300 5,400 379,362 67,400 31,200 22,800 121,400 500,762 Bond Proceeds - - - - - - - - - - . - - Lease Proceeds - - - - - - - - - - - - - - - Transfers From Other FundsGeneral Fund - 223,838 - - - - - - - 223,838 - - - - 223,838 Debt Service Funds - 233,000 - - - - - - - 233,000 - - - - 233,000 Water Fund 218,000 577,675 - - 108,750 - - 8,000 - 912,425 - - - - 912,425 Sewer Fund 218,000 - - - 108,750 - - 8,000 - 334,750 - - - - 334,750 Water Quality Fund 110,000 - - - - - - 8,600 - 118,600 - - - - 118,600 Trunk Reserve Fund - - - - - - - - - - - - - - - TIF Fund - 25,500 - - - - - - - 25,500 - - - - 25,500 PIR Fund - 282,751 - - - - - - - 282,751 - - - - 282,751 Facilities Management Fund - - - - - - - - - - - - - - - Capital Park Fund - - - - - - - - - - - - - - - Police Forfeiture Fund - - - - - - - - - - -$ -$ -$ - Total Revenues / Sources 16,535,887$ 5,293,497$ 23,800$ 608,500$ 924,300$ 418,800$ 1,206,431$ 670,900$ 389,760$ 26,071,875$ 4,854,499$ 5,207,821$ 1,220,720$ 11,283,040$ 37,354,915$ Expenditures / UsesEmployee Services 12,036,412$ -$ -$ -$ -$ -$ -$ -$ 143,239$ 12,179,651$ 878,691$ 870,410$ 356,875$ 2,105,976$ 14,285,627$ Current Expenditures 4,320,637 - - 3,200 - - - - 92,318 4,416,155 1,412,171 2,208,663 195,550 3,816,384 8,232,539 Capital Outlay 5,000 - - - 921,400 158,000 - - 385,000 1,469,400 191,000 290,200 - 481,200 1,950,600 Capital Improvements - - - - - - - 953,000 - 953,000 665,000 729,000 497,000 1,891,000 2,844,000 Subtotal 16,362,049$ -$ -$ 3,200$ 921,400$ 158,000$ -$ 953,000$ 620,557$ 19,018,206$ 3,146,862$ 4,098,273$ 1,049,425$ 8,294,560$ 27,312,766$ Transfers To Other FundsGeneral Fund -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 218,000$ 218,000$ 110,000$ 546,000$ 546,000$ Treatment Plant (Debt) - - - - - - - - - - - - - - - Equipment Fund - - - - - - - - - - 108,750 108,750 - 217,500 217,500 Park Equipment Fund - - - - - - - - - - - - - - - Debt Service Funds 223,838 233,000 - - - - 282,751 - - 739,589 577,675 - - 577,675 1,317,264 PIR Fund - - - - - - - - - - - - - - - Facilities Management Fund - - - - - - - - - - 8,000 8,000 8,600 24,600 24,600 EDA Fund - - - - - - - - - - - - - - - Severance Compensation Fund - - - - - - - - - - - - - - - Contingency - - - - - - - - - - - - - - - Debt Service - 5,360,912 - - - - - - - 5,360,912 169,850 169,850 - 339,700 5,700,612 Subtotal 223,838$ 5,593,912$ -$ -$ -$ -$ 282,751$ -$ -$ 6,100,501$ 1,082,275$ 504,600$ 118,600$ 1,705,475$ 7,805,976$ Total Expenditures / Uses 16,585,887$ 5,593,912$ -$ 3,200$ 921,400$ 158,000$ 282,751$ 953,000$ 620,557$ 25,118,707$ 4,229,137$ 4,602,873$ 1,168,025$ 10,000,035$ 35,118,742$ Change in Fund Balance (50,000)$ (300,415)$ 23,800$ 605,300$ 2,900$ 260,800$ 923,680$ (282,100)$ (230,797)$ 953,168$ 625,362$ 604,948$ 52,695$ 1,283,005$ 2,236,173$ 2022 Property Tax Levy Comparison2022 Council Workshop 11/1/2021Attachment 1Change 21 - 22Property Taxes 2021 2022 Amount PercentLevy - Tax Capacity General Fund - Operating 9,180,384$ 10,003,394$ 823,010$ 8.96% Debt Service Funds 3,306,498 3,455,529 149,031 4.51% Revolving Equipment Fund 650,000 700,000 50,000 7.69% Revolving Park Equipment Fund 375,000 405,000 30,000 8.00% Permanent Improvement Revolving120,000 - (120,000) -100.00% Facilities Management Fund 80,000 105,000 25,000 31.25%Levy - Economic Dev Authority 349,750 360,000 10,250 2.93%14,061,632 15,028,923 967,291 6.88%Levy - Market Value - General Fund 253,575 223,838 (29,737) -11.73%Total Levy 14,315,207$ 15,252,761$ 937,554$ 6.55%2022 Budget Expenditure Comparisons (2021 Original Budgets)Capital Revolving Revolving Park Permanent Facilities TotalTotalGeneral Debt Service Cable Park Equipment Equipment ImprovementManagementEDAGovernmental Water Sewer Water Quality Enterprise BudgetedFundFundsFundFundFundFund Revolving FundFundFundsFundFundFundFundsFunds2022 Total Expenditures / Uses 16,585,887$ 5,593,912$ -$ 3,200$ 921,400$ 158,000$ 282,751$ 953,000$ 620,557$ 25,118,707$ 4,229,137$ 4,602,873$ 1,168,025$ 10,000,035$ 35,118,742$ 2021 Total Expenditures / Uses 15,077,717$ 5,318,627$ -$ 956,000$ 1,816,000$ 525,000$ 287,150$ 447,600$ 524,794$ 24,952,888$ 5,451,795$ 4,179,895$ 1,109,393$ 10,741,083$ 35,693,971$ Change 2021 to 2022 ($) 1,508,170$ 275,285$ -$ (952,800)$ (894,600)$ (367,000)$ (4,399)$ 505,400$ 95,763$ 165,819$ (1,222,658)$ 422,978$ 58,632$ (741,048)$ (575,229)$ Change 2021 to 2022 (%) 10.00% 5.18% n/a n/a -49.26% -69.90% n/a 112.91% 18.25% 0.66% -22.43% 10.12% 5.29% -6.90% -1.61%2022 Budget Expenditure Comparisons (2021 Amended Budgets)Capital Revolving Revolving Park Permanent Facilities TotalTotalGeneral Debt Service Cable Park Equipment Equipment ImprovementManagementEDAGovernmental Water Sewer Water Quality Enterprise BudgetedFundFundsFundFundFundFund Revolving FundFund FundsFundFundFundFundsFunds2022 Total Expenditures / Uses 16,585,887$ 5,593,912$ -$ 3,200$ 921,400$ 158,000$ 282,751$ 953,000$ 620,557$ 25,118,707$ 4,229,137$ 4,602,873$ 1,168,025$ 10,000,035$ 35,118,742$ 2021 Total Expenditures / Uses 16,131,421$ 5,318,627$ -$ 956,000$ 1,888,378$ 525,000$ 287,150$ 447,600$ 524,794$ 26,078,970$ 5,451,795$ 4,179,895$ 1,184,764$ 10,816,454$ 36,895,424$ Change 2021 to 2022 ($) 454,466$ 275,285$ -$ (952,800)$ (966,978)$ (367,000)$ (4,399)$ 505,400$ 95,763$ (960,263)$ (1,222,658)$ 422,978$ (16,739)$ (816,419)$ (1,776,682)$ Change 2021 to 2022 (%) 2.82% 5.18% n/a -99.67% -51.21% -69.90% -1.53% 112.91% 18.25% -3.68% -22.43% 10.12% -1.41% -7.55% -4.82% 11/1/2021 ‐ Council Workshop2020 2021 2021 2022 2022 2022BUDGET ACTIVITY ORIGINALAMENDED PROPOSED PROPOSED PROPOSEDCLASSIFICATIONBUDGET BUDGET BUDGET AMT CHANGE % CHANGEFund 101 ‐ GENERAL FUNDTaxes 8,923,782 9,433,959 9,433,959 10,227,232 793,273 8.41 Charges for Services1,731,517 1,800,172 1,800,172 2,022,200 222,028 12.33 Intergovernmental 4,092,040 2,160,235 2,160,235 2,585,932 425,697 19.71 Miscellaneous Revenues372,421 240,800 240,800 257,200 16,400 6.81 Sale of assets2,603 ‐ ‐ ‐ ‐ ‐ Transfers in 470,000 523,000 523,000 546,000 23,000 4.40 Licenses and Permits900,601 795,551 795,551 897,323 101,772 12.79 Fines and Forfeitures1,652 ‐ ‐ ‐ ‐ ‐ TOTALS ‐ FUND 101 16,494,616 14,953,717 14,953,717 16,535,887 1,582,170 10.58 DEBT SERVICE FUNDSTaxes 3,316,380 3,121,498 3,121,498 3,455,529 334,031 10.70Miscellaneous Revenues734,149 492,776 492,776 495,204 2,428 0.49Transfers in 1,260,291 1,206,925 1,206,925 1,342,764 135,839 11.25TOTALS ‐ DEBT SERVICE FUNDS 5,310,820 4,821,199 4,821,199 5,293,497 472,298 9.80 Fund 210 ‐ CABLE FRANCHISE FUNDCharges for Services31,276 28,000 28,000 23,800 (4,200) (15.00) Miscellaneous Revenues2,667 ‐ ‐ ‐ ‐ ‐ TOTALS ‐ FUND 210 33,943 28,000 28,000 23,800 (4,200) (15.00) Fund 225 ‐ CAPITAL PARK FUNDCharges for Services174,820 455,000 455,000 586,500 131,500 28.90 Miscellaneous Revenues66,806 41,297 41,297 22,000 (19,297) (46.73) TOTALS ‐ FUND 225 241,626 496,297 496,297 608,500 112,203 22.61 BUDGET REPORTCity of Prior LakeRevenuesFrom Amended Budget 11/1/2021 ‐ Council Workshop2020 2021 2021 2022 2022 2022BUDGET ACTIVITY ORIGINALAMENDED PROPOSED PROPOSED PROPOSEDCLASSIFICATIONBUDGET BUDGET BUDGET AMT CHANGE % CHANGEBUDGET REPORTCity of Prior LakeRevenuesFrom Amended BudgetFund 240 ‐ EDA SPECIAL REVENUE FUNDTaxes 273,460 349,750 349,750 360,000 10,250 2.93 Charges for Services188,485 8,450 8,450 24,360 15,910 188.28 Miscellaneous Revenues17,266 5,300 5,300 5,400 100 1.89 Transfers in 161,250 ‐ ‐ ‐ ‐ ‐ TOTALS ‐ FUND 240 640,461 363,500 363,500 389,760 26,260 7.22 Fund 410 ‐ REVOLVING EQUIPMENT FUNDTaxes 624,897 835,000 835,000 700,000 (135,000) (16.17) Miscellaneous Revenues21,107 9,600 9,600 6,800 (2,800) (29.17) Sale of assets63,717 ‐ ‐ ‐ ‐ ‐ Transfers in 215,000 310,000 310,000 217,500 (92,500) (29.84) Debt Issued‐ 555,000 555,000 ‐ (555,000) (100.00) TOTALS ‐ FUND 410 924,721 1,709,600 1,709,600 924,300 (785,300) (45.93) Fund 430 ‐ REVOLVING PARK EQUIP FUNDTaxes 318,599 375,000 375,000 405,000 30,000 8.00 Miscellaneous Revenues61,167 10,500 10,500 13,800 3,300 31.43 TOTALS ‐ FUND 430 379,766 385,500 385,500 418,800 33,300 8.64 Fund 440 ‐ FACILITIES MANAGEMENT FUNDTaxes 29,523 80,000 80,000 105,000 25,000 31.25 Intergovernmental‐ ‐ ‐ 535,000 535,000 ‐ Miscellaneous Revenues17,468 5,800 5,800 6,300 500 8.62 Transfers in 99,000 130,000 930,000 24,600 (905,400) (97.35) TOTALS ‐ FUND 440 145,991 215,800 1,015,800 670,900 (344,900) (33.95) 11/1/2021 ‐ Council Workshop2020 2021 2021 2022 2022 2022BUDGET ACTIVITY ORIGINALAMENDED PROPOSED PROPOSED PROPOSEDCLASSIFICATIONBUDGET BUDGET BUDGET AMT CHANGE % CHANGEBUDGET REPORTCity of Prior LakeRevenuesFrom Amended BudgetFund 450 ‐ PERMANENT IMPROVEMENT REVOLVING FUNDTaxes 79,957 120,000 120,000 ‐ (120,000) (100.00) Charges for Services‐ ‐ ‐ 1,050,000 1,050,000 ‐ Miscellaneous Revenues327,499 180,800 180,800 156,431 (24,369) (13.48) Transfers in 257,935 ‐ ‐ ‐ ‐ ‐ TOTALS ‐ FUND 450 665,391 300,800 300,800 1,206,431 905,631 301.07 Fund 601 ‐ WATER FUNDCharges for Services5,670,214 4,411,774 4,411,774 4,787,099 375,325 8.51 Intergovernmental 17,656 ‐ ‐ ‐ ‐ ‐ Miscellaneous Revenues190,292 54,775 54,775 67,400 12,625 23.05 Other Financing Sources16,762 ‐ ‐ ‐ ‐ ‐ TOTALS ‐ FUND 601 5,896,203 4,466,549 4,466,549 4,854,499 387,950 8.69 Fund 602 ‐ STORM WATER UTILITYCharges for Services1,206,327 1,190,699 1,190,699 1,197,920 7,221 0.61 Intergovernmental 3,825 ‐ ‐ ‐ ‐ ‐ Miscellaneous Revenues77,101 14,500 14,500 22,800 8,300 57.24 Storm Water Charges 1,500 ‐ ‐ ‐ ‐ ‐ TOTALS ‐ FUND 602 1,288,753 1,205,199 1,205,199 1,220,720 15,521 1.29 Fund 604 ‐ SEWER FUNDCharges for Services5,286,923 4,317,042 4,317,042 5,176,621 859,579 19.91 Intergovernmental 11,322 ‐ ‐ ‐ ‐ ‐ Miscellaneous Revenues74,561 19,800 19,800 31,200 11,400 57.58 Other Financing Sources16,762 ‐ ‐ ‐ ‐ ‐ TOTALS ‐ FUND 604 5,389,568 4,336,842 4,336,842 5,207,821 870,979 20.08 TOTALS ‐ ALL FUNDS 37,411,859 33,283,003 34,083,003 37,354,915 3,271,912 9.60 4,071,912 12.23 From Original Budget 11/1/2021 ‐ Council Workshop2020 2021 2021 2022 2022 2022ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSEDDEPT DESCRIPTION BUDGET BUDGET BUDGET AMT CHANGE % CHANGEFund 101 ‐ GENERAL FUND41110.00 MAYOR & COUNCIL 65,689 74,934 74,934 75,528 594 0.79 41130.00 ORDINANCE 5,440 6,000 6,000 6,00041320.00 ADMINISTRATION 317,739 270,152 270,152 390,765 120,613 44.65 41330.00 BOARDS & COMMISSIONS 5,507 11,365 11,365 11,36541400.00 CITY CLERK FUNCTIONS 117,161 122,272 122,272 129,697 7,425 6.07 41410.00 ELECTIONS 58,393 7,000 7,000 62,200 55,200 788.57 41520.00 FINANCE 499,898 565,250 565,250 596,290 31,040 5.49 41540.00 INTERNAL AUDITING 31,184 41,200 41,200 42,200 1,000 2.43 41550.00 ASSESSING 216,236 224,260 224,260 231,135 6,875 3.07 41610.00 LEGAL 193,279 180,000 180,000 190,000 10,000 5.56 41820.00 HUMAN RESOURCES 303,206 316,074 333,674 332,139 (1,535) (0.46) 41830.00 COMMUNICATIONS 150,044 162,070 162,070 174,261 12,191 7.52 41910.00 COMMUNITY DEVELOPMENT 450,154 379,924 379,924 385,472 5,548 1.46 41920.00 INFORMATION TECHNOLOGY 470,646 385,116 385,116 398,081 12,965 3.37 41940.00 FACILITIES ‐ CITY HALL 492,870 524,030 524,030 553,195 29,165 5.57 42100.00 POLICE 5,026,592 5,303,369 5,539,473 6,013,802 474,329 8.56 42200.00 FIRE 995,854 1,076,350 1,076,350 1,242,376 166,026 15.42 42400.00 BUILDING INSPECTION 678,073 730,801 730,801 816,265 85,464 11.69 42500.00 EMERGENCY MANAGEMENT 10,335 15,090 15,090 16,190 1,100 7.29 42700.00 ANIMAL CONTROL 29,195 28,800 28,800 28,80043050.00 ENGINEERING 356,121 389,105 389,105 419,812 30,707 7.89 43100.00 STREET 1,173,055 1,365,438 1,365,438 1,384,871 19,433 1.42 43400.00 CENTRAL GARAGE 470,236 491,373 491,373 518,031 26,658 5.43 45100.00 RECREATION 338,774 481,813 481,813 512,825 31,012 6.44 45200.00 PARKS 1,227,649 1,604,132 1,604,132 1,760,303 156,171 9.74 45500.00 LIBRARIES 62,349 68,224 68,224 70,446 2,222 3.26 80000.00 Transfers to other Funds 538,018 253,575 1,053,575 223,838 (829,737) (78.75) TOTALS ‐ FUND 101 14,283,697 15,077,717 16,131,421 16,585,887 454,466 2.82 BUDGET REPORTCity of Prior LakeExpendituresFrom Amended Budget 11/1/2021 ‐ Council Workshop2020 2021 2021 2022 2022 2022ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSEDDEPT DESCRIPTION BUDGET BUDGET BUDGET AMT CHANGE % CHANGEBUDGET REPORTCity of Prior LakeExpendituresFrom Amended BudgetDEBT SERVICE FUNDS47000.00 DEBT SERVICE 5,324,463 5,243,627 5,243,627 5,360,912 117,285 2.2480000.00 Transfers to other Funds 155,645 75,000 75,000 233,000 158,000 210.67TOTALS ‐ DEBT SERVICE FUNDS 5,480,108 5,318,627 5,318,627 5,593,912 275,285 5.18 Fund 210 ‐ CABLE FRANCHISE FUND41340.00 PUBLIC CABLE ACCESS 11,122 ‐ ‐ ‐ ‐ ‐ TOTALS ‐ FUND 210 11,122 ‐ ‐ ‐ ‐ ‐ Fund 225 ‐ CAPITAL PARK FUND45200.00 PARKS 368,906 956,000 956,000 3,200 (952,800) (99.67) TOTALS ‐ FUND 225 368,906 956,000 956,000 3,200 (952,800) (99.67) Fund 240 ‐ EDA SPECIAL REVENUE FUND46500.00 ECONOMIC DEVELOPMENT 254,757 519,294 519,294 620,557 101,263 19.50 46503.00 TECH VILLAGE INCUBATOR 2,900 5,500 5,500 ‐ (5,500) (100.00) TOTALS ‐ FUND 240 257,657 524,794 524,794 620,557 95,763 18.25 11/1/2021 ‐ Council Workshop2020 2021 2021 2022 2022 2022ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSEDDEPT DESCRIPTION BUDGET BUDGET BUDGET AMT CHANGE % CHANGEBUDGET REPORTCity of Prior LakeExpendituresFrom Amended BudgetFund 410 ‐ REVOLVING EQUIPMENT FUND41830.00 COMMUNICATIONS‐ ‐ 32,445 ‐ (32,445) (100.00) 42100.00 POLICE 381,336 250,900 290,833 298,900 8,067 2.77 42200.00 FIRE 134,879 792,000 792,000 188,000 (604,000) (76.26) 42400.00 BUILDING INSPECTION‐ 35,000 35,000 ‐ (35,000) (100.00) 43100.00 STREET 519,854 289,600 289,600 65,000 (224,600) (77.56) 43400.00 CENTRAL GARAGE 16,307 20,000 20,000 20,000 ‐ ‐ 45200.00 PARKS 63,384 262,500 262,500 349,500 87,000 33.14 49400.00 WATER‐ 83,000 83,000 ‐ (83,000) (100.00) 49450.00 SEWER‐ 83,000 83,000 ‐ (83,000) (100.00) TOTALS ‐ FUND 410 1,115,760 1,816,000 1,888,378 921,400 (966,978) (51.21) Fund 430 ‐ REVOLVING PARK EQUIP FUND45200.00 PARKS 62,120 525,000 525,000 158,000 (367,000) (69.90) TOTALS ‐ FUND 430 62,120 525,000 525,000 158,000 (367,000) (69.90) Fund 440 ‐ FACILITIES MANAGEMENT FUND41940.00 FACILITIES ‐ CITY HALL 10,660 240,000 240,000 ‐ (240,000) (100.00) 42100.00 POLICE‐ 22,500 22,500 167,000 144,500 642.22 42200.00 FIRE 10,357 120,000 120,000 700,000 580,000 483.33 43400.00 CENTRAL GARAGE‐ 50,100 50,100 86,000 35,900 71.66 45500.00 LIBRARIES 86,529 15,000 15,000 ‐ (15,000) (100.00) 49400.00 WATER 6,943 ‐ ‐ ‐ ‐ ‐ TOTALS ‐ FUND 440 114,489 447,600 447,600 953,000 505,400 112.91 11/1/2021 ‐ Council Workshop2020 2021 2021 2022 2022 2022ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSEDDEPT DESCRIPTION BUDGET BUDGET BUDGET AMT CHANGE % CHANGEBUDGET REPORTCity of Prior LakeExpendituresFrom Amended BudgetFund 450 ‐ PERMANENT IMPROVEMENT REVOLVING FUND43100.00 STREET 590,277 ‐ ‐ ‐ ‐ ‐ 80000.00 Transfers to other Funds 279,933 287,150 287,150 282,751 (4,399) (1.53) TOTALS ‐ FUND 450 870,210 287,150 287,150 282,751 (4,399) (1.53) Fund 601 ‐ WATER FUND41520.00 FINANCE 99,393 108,246 108,246 112,766 4,520 4.18 47000.00 DEBT SERVICE 54,450 ‐ ‐ ‐ ‐ ‐ 49400.00 WATER 3,144,090 4,307,849 4,307,849 3,203,946 (1,103,903) (25.63) 80000.00 Transfers to other Funds 1,215,160 1,035,700 1,035,700 912,425 (123,275) (11.90) TOTALS ‐ FUND 601 4,513,093 5,451,795 5,451,795 4,229,137 (1,222,658) (22.43) Fund 602 ‐ STORM WATER UTILITY49420.00 WATER QUALITY 607,022 982,393 1,057,764 1,049,425 (8,339) (0.79) 80000.00 Transfers to other Funds 85,780 127,000 127,000 118,600 (8,400) (6.61) TOTALS ‐ FUND 602 692,802 1,109,393 1,184,764 1,168,025 (16,739) (1.41) Fund 604 ‐ SEWER FUND41520.00 FINANCE 100,604 107,721 107,721 112,296 4,575 4.25 47000.00 DEBT SERVICE 54,450 ‐ ‐ ‐ ‐ ‐ 49450.00 SEWER 3,259,483 3,706,174 3,706,174 4,155,827 449,653 12.13 80000.00 Transfers to other Funds 632,110 366,000 366,000 334,750 (31,250) (8.54) TOTALS ‐ FUND 604 4,046,647 4,179,895 4,179,895 4,602,873 422,978 10.12 TOTALS ‐ ALL FUNDS 31,816,611 35,693,971 36,895,424 35,118,742 (1,776,682) (4.82) (575,229) (1.61) From Original Budget CHECK REGISTER FOR CITY OF PRIOR LAKE 1/6Page: 10/25/2021 09:30 AM User: Janet DB: Prior Lake CHECK DATE FROM 10/09/2021 - 10/21/2021 AmountDescriptionVendor NameVendorCheckBankCheck Date Bank 1 General Bank 42,080.00 2021 Downtown ReconstructionBOLTON & MENK INC000026377748(A)110/15/2021 567.00 Cardinal Overlook Addition 1,053.00 DEV20-000010 Haven Ridge 4th Addition 43,700.00 4,160.92 Sep 2021 Legal ServicesCAMPBELL KNUTSON PA000280437749(A)110/15/2021 558.25 Sep 2021 Misc SuppliesCARLSON HARDWARE COMPANY000031257750(A)110/15/2021 7,700.00 Tree Removal - 6346 Conroy St NECOLLINS TREE 000036707751(A)110/15/2021 17,623.11 Replacement Pump - Franklin TrlELECTRIC PUMP000231207752(A)110/15/2021 8,756.38 Fertilizer applicationFARMERS MILL & ELEVATOR INC000276327753(A)110/15/2021 125.56 PartsFASTENAL COMPANY000061407754(A)110/15/2021 1,309.50 Cairns HelmetsFIRE EQUIPMENT SPECIALTIES INC000064557755(A)110/15/2021 690.00 7130 CSO Truck graphics GRAFIX SHOPPE000076157756(A)110/15/2021 16,787.41 Water Treatment ChemicalsHAWKINS INC000083127757(A)110/15/2021 5,936.72 Water Treatment Chemicals 22,724.13 405.00 Emergency Call - Network DownHUMERATECH000271847758(A)110/15/2021 198.25 Fire Dept Business CardsINNOVATIVE OFFICE SOLUTIONS LLC000271497759(A)110/15/2021 18.33 Prchal Name Plate 47.74 Shipping Tags 383.92 Misc Office Supplies 648.24 41.00 Mileage, D White Retirement SuppliesJENNIFER BISEK000271477760(A)110/15/2021 10,381.60 Sep 2021 UnleadedKELLEY FUELS INC000112197761(A)110/15/2021 5,280.20 Sep 2021 Diesel 15,661.80 400.00 Aug 2021 PD Counseling ServicesLEAST SERVICES/COUNSELING LLC000276137762(A)110/15/2021 3,035.00 Sep 2021 PD Counseling Services 3,435.00 142.66 538 Parking brake caliper MTI DISTRIBUTING INC000139517763(A)110/15/2021 305.59 Sep 2021 Misc SuppliesPRIOR LAKE HARDWARE000166587764(A)110/15/2021 1,101.42 Watzl Beach ProjectSCOTT COUNTY000192127765(A)110/15/2021 416.78 Labels, RibbonULINE000212507766(A)110/15/2021 6.36 SealVIKING ELECTRIC SUPPLY000226307767(A)110/15/2021 417.43 GFI 277.99 Cable 701.78 119.97 4th Qtr 2021 Bottled WaterWATERLOGIC AMERICAS LLC000275837768(A)110/15/2021 2,940.50 Lil Explorers Childcare Ctr Traffic StudWSB & ASSOCIATES INC000237807769(A)110/15/2021 90.00 Pest Control - City HallXTREME PEST SOLUTIONS INC000271167770(A)110/15/2021 90.00 Pest Control - FS #2 90.00 Pest Control - PD 270.00 CHECK REGISTER FOR CITY OF PRIOR LAKE 2/6Page: 10/25/2021 09:30 AM User: Janet DB: Prior Lake CHECK DATE FROM 10/09/2021 - 10/21/2021 AmountDescriptionVendor NameVendorCheckBankCheck Date 86.90 Mtce Center - First Aid SuppliesZEE MEDICAL SERVICE000263507771(A)110/15/2021 6,017.00 3rd Qtr 2021 State SurchargeMN DEPT OF LABOR & INDUSTRY000138017772(E)110/13/2021 939.50 2021 Delta ClaimsDELTA DENTAL000272137773(E)110/12/2021 167.45 Aug 2021 Merchant Card FeesTRANSFIRST000206937774(E)110/12/2021 459.43 221 Dental ClaimsDELTA DENTAL000272137775(E)110/18/2021 78.22 12V BatteriesBATTERIES PLUS000021307776(A)110/21/2021 6,222.00 Pike Lake Landing Const ObservationBOLTON & MENK INC000026377777(A)110/21/2021 12,126.35 Towering Woods 3,082.00 Villas at Crest Woods 21,430.35 1,400.00 Tree Removal - 16701 Willow LaneCOLLINS TREE 000036707778(A)110/21/2021 1,840.00 Oct 2021 Office 365COMPUTER INTEGRATION TECH000037607779(A)110/21/2021 1,125.00 Nov 2021 CIT Managed Backup 1,762.50 Nov 2021 Managed Services 4,727.50 1,810.00 Manhole Protection RingsESS BROTHERS & SONS INC000057857780(A)110/21/2021 730.35 Jul 2021 LocatesGOPHER STATE ONE-CALL INC000075257781(A)110/21/2021 39.30 BindersINNOVATIVE OFFICE SOLUTIONS LLC000271497782(A)110/21/2021 20.53 Bengtson - Name Plate 43.00 Bengtson - Business Cards 102.83 113.16 RockKRAEMER MINING & MATERIALS INC000053657783(A)110/21/2021 552,491.24 #6 Fish Pt Road Phase I TRN20-0000001MCNAMARA CONTRACTING INC000132867784(A)110/21/2021 200.00 Zone Restoration - LibraryMETRO ALARM CONTRACTORS INC000133547785(A)110/21/2021 171.98 Rain coats and pantsNORTH AMERICAN SAFETY000145747786(A)110/21/2021 360.96 Apparel 532.94 1,994.46 PartsNOVAK COMPANIES000149007787(A)110/21/2021 247.50 7133 Aluminum for light mounts 2,241.96 5,112.00 Roofing Repairs - CHSCHWICKERT'S TECTA AMERICA LLC000279117788(A)110/21/2021 267.09 AsphaltWM MUELLER & SONS INC000236457789(A)110/21/2021 135.72 Asphalt 402.81 249.00 ReservoirZAHL-PETROLEUM MAINTENANCE CO000261257790(A)110/21/2021 1,149.87 Oct 2021 Electric BillsSHAKOPEE PUBLIC UTILITIES000193887791(E)110/15/2021 62.00 Sep 2021 COBRA Admin FeeALERUS000013757792(E)110/20/2021 187.25 Sep 2021 Fuel TaxMN DEPT OF REVENUE000136127793(E)110/20/2021 1,492.00 Sep 2021 Sales Tax 1,679.25 1,100.74 Sep 2021 Admin FeesDELTA DENTAL000272137794(E)110/21/2021 1,805.56 Oct 2021 Phone BillsNUVERA000193047795(E)110/21/2021 43.11 UB REFUND # 1-01075-03ALENA GLUSHKOREFUND-UB108968110/15/2021 70.00 Oct 2021 Technology Time ClassAMANDA FAY00027666108969110/15/2021 CHECK REGISTER FOR CITY OF PRIOR LAKE 3/6Page: 10/25/2021 09:30 AM User: Janet DB: Prior Lake CHECK DATE FROM 10/09/2021 - 10/21/2021 AmountDescriptionVendor NameVendorCheckBankCheck Date 70.69 UB REFUND # 4-07565-02ANDRA ZIEBOL & JOE DETLAFF REFUND-UB108970110/15/2021 270.00 3rd Qtr 2021BCA/STATE OF MINNESOTA00002933108971110/15/2021 58.02 UB REFUND # 3-09232-01BRADLEY & JACALYN GUNSTAD REFUND-UB108972110/15/2021 46.65 UB REFUND # 1-03767-01BRIAN & CHRISTA RESTAD REFUND-UB108973110/15/2021 116.97 UB REFUND #1-07360-02BRIAN & KIM DORNBURG REFUND-UB108974110/15/2021 1,404.75 UB REFUND # 1-05398-02BRIAN & MICHELLE BUSS REFUND-UB108975110/15/2021 115.58 UB REFUND # 1-07328-00CHARLES & JOEY IHLE REFUND-UB108976110/15/2021 175.00 Sep 2021 Tai Chi InstructorCHRISTINE T MORGAN00027316108977110/15/2021 7.14 UB REFUND #1-04678-00CHUCK WILLSONREFUND-UB108978110/15/2021 250.00 O'Donnell - Less Lethal ArmorerCITY OF ST PAUL00003521108979110/15/2021 250.00 Schaefer - Less Lethal Armorer 500.00 8,400.93 Oct 2021 UB Billing CSG SYSTEMS INC00027506108980110/15/2021 2,500.00 21-0305 14339 McKenna Road NWCUDDIGAN CUSTOM BUILDERS LLCMISC-CD108981110/15/2021 60.21 UB REFUND #3-03572-00DAVI & LORI RUBENZER REFUND-UB108982110/15/2021 85.79 UB REFUND #3-02080-05DAVID & MERIDITH KOLSRUD REFUND-UB108983110/15/2021 130.43 UB REFUND #10-2914-00DAVID THOMPSON REFUND-UB108984110/15/2021 106.35 REFUND # 3-03327-01DENNIS MCGILL REFUND-UB108985110/15/2021 26.00 #8314 Tax Exempt PlatesDEPUTY REGISTRAR #16000004400108986110/15/2021 48.02 UB REFUND #4-00526-01DEREK & ANNA DARCYREFUND-UB108987110/15/2021 67.90 UB REFUND #1-06311-00DONNA & TIM BLASCHKE REFUND-UB108988110/15/2021 45.00 Sep 2021 Yoga InstructorELEANOR ALLEN00028060108989110/15/2021 3,000.00 Street Sweeper RentalENVIRONMENTAL EQUIPMENT00005584108990110/15/2021 195.55 UB REFUND #1-06849-00EUGENE & JACKIE LA TOUR REFUND-UB108991110/15/2021 35.92 Mark WandFERGUSON WATERWORKS #251600006231108992110/15/2021 1,358.50 Water Meters 216.34 Water Meters 306.80 Water Meters 1,917.56 295.00 Beehler - FTO BasicFIELD TRAINING SOLUTIONS 00027778108993110/15/2021 273.21 UB REFUND #4-05390-98GREG & JULIE CLEARY REFUND-UB108994110/15/2021 270.00 Sep 2021 Yoga InstructorGWENDOLYN SCHMID00027984108995110/15/2021 497.51 Service Pump #2HAYES ELECTRIC INC00008315108996110/15/2021 420.00 Sep 2021 Foot Care SessionsHEALING HANDS FOR FEET00027618108997110/15/2021 64.87 UB REFUND #4-05354-04JOSHUA ZARRAS REFUND-UB108998110/15/2021 40.84 UB REFUND #4-07130-02JOZEF KAUTZKY & LUCINDA STINE REFUND-UB108999110/15/2021 900.00 Pre-Paid Car WashesKWIK TRIP00027279109000110/15/2021 222.63 UB REFUND #1-00935-01LAURENCE & JULUE NACE REFUND-UB109001110/15/2021 148.27 UB REFUND # 4-07916-03MARC & JERI SMITH REFUND-UB109002110/15/2021 58.02 UB REFUND #4-06411-01MARC SUAREZREFUND-UB109003110/15/2021 46.05 UB REFUND #4-04052-00MARIE PEITTE REFUND-UB109004110/15/2021 300.00 Club Prior SpeakerMARY HALL00028061109005110/15/2021 170.78 UB REFUND #1-02321-02MATHEW & AMANDA JACKSONREFUND-UB109006110/15/2021 180.71 UB REFUND #2-02966-01MATT & JENNY CHRISTIANSEN REFUND-UB109007110/15/2021 223.54 Door SweepMENARDS LUMBER CO00013318109008110/15/2021 27,061.65 Sep 2021 SAC FeesMETROPOLITAN COUNCIL-SAC00013406109009110/15/2021 67.68 UB REFUND #2-00133-01MICHAEL & TORI SLATER REFUND-UB109010110/15/2021 75.97 UB REFUND # 1-02584-01MIKE KIRK REFUND-UB109011110/15/2021 570.16 2021 Unclaimed PropertyMN DEPT OF COMMERCE00013598109012110/15/2021 23.00 Meger - Waterworks Operator CertMN DEPT OF HEALTH00013618109013110/15/2021 839.88 Yearly Service - City HallMN ELEVATOR INC00013623109014110/15/2021 839.88 Yearly Service - PD 1,679.76 CHECK REGISTER FOR CITY OF PRIOR LAKE 4/6Page: 10/25/2021 09:30 AM User: Janet DB: Prior Lake CHECK DATE FROM 10/09/2021 - 10/21/2021 AmountDescriptionVendor NameVendorCheckBankCheck Date 77,994.28 Summit Ridge ParkMN/WI PLAYGROUND00026849109015110/15/2021 33,103.00 Summit Ridge Park 5,562.00 Summit Ridge Park 116,659.28 60.00 Credit Checks - Police Officer CandidateMULTIHOUSING CREDIT CONTROL00013968109016110/15/2021 1,416.29 UB Temp w/e 10/8/2021OFFICE TEAM00028044109017110/15/2021 264.00 UB REFUND # 4-07948-01PAMELA DUNCAN REFUND-UB109018110/15/2021 641.00 UB REFUND #1-05349-00PATRICK & KERRY MUNGER REFUND-UB109019110/15/2021 108.21 UB REFUND #4-07551-02PATRICK BAKER & ASHLEY CORBINREFUND-UB109020110/15/2021 33.00 PropanePRIOR LAKE RENTAL CENTER00016700109021110/15/2021 113.26 HolsterRAY O'HERRON CO INC00027212109022110/15/2021 324.29 UB REFUND #4-05394-01RAYMOND & MARLYS STOTKA REFUND-UB109023110/15/2021 63.65 UB REFUND #1-03822-00RICHARD & SARA SWANSON REFUND-UB109024110/15/2021 210.79 UB REFUND #4-05693-00RYAN & ALEIDA ZOLLMAN REFUND-UB109025110/15/2021 108.00 Straw Bales, Corn BundlesSAILERS GREENHOUSE00019037109026110/15/2021 90.09 Misc SuppliesSAM'S CLUB00019036109027110/15/2021 34,230.55 3rd Qtr 2021 Court FinesSCOTT COUNTY ATTORNEY00019232109028110/15/2021 621.32 Engineering - Sewer Lining ProgramSEH INC00019339109029110/15/2021 340.88 UB REFUND #1-01098-00SHARON & STEVEN VESPESTEDREFUND-UB109030110/15/2021 47,931.30 Sep 2021 Water PurchasesSMSC00019384109031110/15/2021 336.00 Defibrillator PadsSOS TECHNOLOGIES00027273109032110/15/2021 98.98 Sep 2021 Legal AdsSOUTHWEST NEWS MEDIA00019676109033110/15/2021 48.00 Pistol PouchSTREICHERS00019900109034110/15/2021 58.82 UB REFUND #3-00681-00THEODORE & JENNIFER STEWARTREFUND-UB109035110/15/2021 182.39 UB REFUND #1-00851-00TOM FISCHER REFUND-UB109036110/15/2021 110.98 UB REFUND # 1-03022-00TOM LANNON & JOANN SMITH REFUND-UB109037110/15/2021 71.98 Boots, Tarp StrapTRACTOR SUPPLY CREDIT PLAN00020663109038110/15/2021 53.38 UB REFUND # 1-07119-02WALTER & GLENNA OSTMANN REFUND-UB109039110/15/2021 163.01 UB REFUND #1-05746-00WALTER HOWSON REFUND-UB109040110/15/2021 210.06 Sep 2021 Clear Law Enforcement PlusWEST PAYMENT CENTER00023420109041110/15/2021 48.41 UB REFUND # 1-04852-04WILLIAM STEIGAUF REFUND-UB109042110/15/2021 64.70 Ruzicka - PantsASPEN MILLS00001891109043110/21/2021 335.37 Lawrence - Uniform 400.07 60.94 SodBRAUN TURF FARMS00027452109044110/21/2021 229.99 762 Vise CAPITAL ONE TRADE CREDIT00027963109045110/21/2021 1,495.00 Fire Incidents CAD IntegrationESO SOLUTIONS INC00027644109046110/21/2021 14.16 PaintFERGUSON WATERWORKS #251600006231109047110/21/2021 1,544.40 GFCI Outlets - Sandpt BeachHAYES ELECTRIC INC00008315109048110/21/2021 959.44 Light Repair - PD, MC, CH 2,503.84 180.00 Sep 2021 Foot Care SessionsHEALING HANDS FOR FEET00027618109049110/21/2021 2,500.00 20-2616 17827 Mission Trail SEKEYLAND HOMESMISC-CD109050110/21/2021 2,500.00 21-0310 17842 Meadows Way SE 2,500.00 20-2614 17859 Mission Trail SE 7,500.00 594.05 784 Suction hose MACQUEEN EMERGENCY 00027901109051110/21/2021 41.28 Concrete Crack SealerMENARDS LUMBER CO00013318109052110/21/2021 799.60 Parts 840.88 CHECK REGISTER FOR CITY OF PRIOR LAKE 5/6Page: 10/25/2021 09:30 AM User: Janet DB: Prior Lake CHECK DATE FROM 10/09/2021 - 10/21/2021 AmountDescriptionVendor NameVendorCheckBankCheck Date 511.76 Sep 2021 Repair PartsNAPA AUTO PARTS00014060109053110/21/2021 70,643.23 #3 170th Street - Towering Woods - DevelNORTHWEST ASPHALT INC00014785109054110/21/2021 75,559.01 170th Street - Towering Woods - City 146,202.24 25.20 Interpreter ServicesOFFICE OF MN IT SERVICES00004396109055110/21/2021 1,403.32 UB Temp w/e 10/15/2021OFFICE TEAM00028044109056110/21/2021 3,830.96 Sports ClassesREVOLUTIONARY SPORTS LLC00027855109057110/21/2021 351.40 Sep 2021 Organics RecyclingSMSC00019384109058110/21/2021 49.20 Oct 2021 Phone BillT-MOBILE00026962109059110/21/2021 82.00 60" WreathTROOP 933300028063109060110/21/2021 196.47 24" TV - CommunicationsUS BANK00002105109061110/21/2021 35.25 Cookies - Employee Luncheon 40.00 Jenn Bisek Annual Membership 41.08 Employee File Shipment 143.81 White Noise Machine - Wellness Room 289.40 Ergonomic Office Chair 881.10 Fire Dept - Aruba Access Point 122.50 Background Checks 247.00 Background Checks 307.08 End Table, Ottoman - Employee Wellness R 1,173.39 Employee Luncheon 718.76 Sofa - Employee Wellness Room 21.46 Mat - Employee Wellness Room 21.41 Basket - Employee Wellness Room 16.08 Mayor/City Mgr Meeting 98.89 Admin Lunch 409.48 Wedel - Lodging 49.35 Spray Paint 13.00 Trail Camera Subscription 16.09 Sep 2021 Video Conferencing 16.09 Sep 2021 Video Conferencing 75.00 Duggan - DMT Refresher 75.00 Kelm - DMT Refresher 19.43 Lunch for CSO's 15.09 Refreshemnts for CSO's 301.60 SWAT Gas Mask Pouch 16.45 Training Refreshments 34.30 Training - Grip Rite Nails 86.43 Training Targets 358.63 SWAT Ballistic Glasses 363.25 SWAT Ballistic Glasses 499.29 SAWT - Safety Glasses 50.00 SVA Yard Signs 80.00 PBT Tubes 67.10 NIK Test Kits 67.92 SWAT Shooting Glasses Cases 395.91 Duty Boots - Steinhaus, Ruzicka 150.00 5 Firefighter Recertifications 50.00 Ruzicka FF License 84.79 Pizza - Officer Meeting 0.99 50GB iCloud Storage 849.75 Watson, Theisen - Fall Conference 51.49 Fallling Wedges 3.85 Sympathy Card 905.00 M Mayer - Course Registration 1,275.00 Exam Refresher Course 47.14 Pap, Blakeborough Wastewater Certificati CHECK REGISTER FOR CITY OF PRIOR LAKE 6/6Page: 10/25/2021 09:30 AM User: Janet DB: Prior Lake CHECK DATE FROM 10/09/2021 - 10/21/2021 AmountDescriptionVendor NameVendorCheckBankCheck Date 95.00 Young - Conference 100.00 Tree Inspection Re-Cert Workshop 65.00 Brotzler - Eithics Training 75.00 Ryan - Writing Skills Course 90.00 Zurbey - 2 Workshops 190.00 M Mayer Pesticide Recertification 39.53 6396 Flashlight Battery 139.00 Handicap Door Push 20.74 7113 Relay Switch 72.33 7133 Sprinter van lights 99.00 Lock - Spring Cages 52.98 Nat'l Domestic Awareness Lights 499.00 Adv Mgmt & Supervisory Training 296.36 Defibrillator Battery 10.47 Water, Ice - Pickleball Court Ribbon Cut 1,195.00 Hartman - Electrical Training 443.00 Reflective Labels 452.49 Solenoid 67.75 Axle Spindle Sockets 55.47 Pizza - Chalkfest Staff 64.43 Chalkfest Chalk 69.17 Candy Crawl Signs 5.09 Ice - Chalkfest 5.09 Ice - Chalkfest 19.62 Club Prior Supplies 288.79 MASS Conference Luncheon 22.69 MASS Conference Luncheon 55.00 Annual Newspaper Subscription 97.93 Fall Decorations 479.80 Club Prior - 4 Card Tables 248.34 Club Prior Supplies 73.55 Club Prior Supplies 90.83 Chalkfest Donuts 103.65 Prior Treasures Supplies 206.67 Club Prior Supplies 18.86 Club Prior Supplies 1.00 Digital Marketing 323.62 Haul Prior Treasures Sale Left Overs 101.26 Water - Council Chambers 227.49 Council Work Session 77.48 Bathroom Cupboard 32.09 Wood Pellets (278.80)Refund Airfare - Watson PW Conference (394.00)Return - SWAT Winter Shirts (394.00)Return SWAT Winter Shirt (129.99)SWAT Return (4.00)Price Adj Mager - Sgt Uniform (722.61)Cancel Order - Sofa - Wellness Room (1,020.00)Anastasia - Club Prior Trip Cancelled (55.00)Credit - Fall Fest 2021 14,453.27 1 TOTALS: 1,177,005.15 Total of 142 Disbursements: 0.00 Less 0 Void Checks: 1,177,005.15 Total of 142 Checks: YTM @ Cost Cost Value Days to Maturity % of Portfolio 0‐1 Month 0.051 14,657,610 1 33.59% 1‐3 Months 1.500 1,818,454 66 4.12% 3‐6 Months 3.000 245,000 110 0.56% 6‐9 Months 1.955 1,401,699 212 3.18% 9‐12 Months 1.906 2,444,129 325 5.45% 1‐2 Years 2.263 6,506,439 576 14.87% 2‐3 Years 2.055 4,977,052 950 11.27% 3‐4 Years 1.193 4,692,336 1,251 10.59% 4‐5 Years 0.984 4,600,037 1,636 10.28% 5‐10 Years 1.033 2,647,352 1,902 6.09% Total / Average 1.120 43,990,108 638 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio ‐ Diversification, by Maturity Range September 30, 2021 Description City of Prior Lake ‐ Quarterly Investment Report YTM @ Cost Cost Value Days to Maturity % of Portfolio Cash ‐ 1,238,319 1 2.84% Certificate of Deposit 2.019 12,944,059 786 29.66% FFCB Bond 0.892 2,070,383 1,640 4.70% FHLB Bond 0.843 2,194,510 1,425 4.97% FHLMC Bond 0.500 200,000 1,166 0.46% LGIP 0.025 13,174,291 1 30.19% Municipal Bond 1.594 11,873,538 907 26.50% Treasury Note 0.780 295,008 1,522 0.68% Total / Average 1.12 43,990,108 638 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio ‐ Diversification, by Security Type September 30, 2021 Description City of Prior Lake ‐ Quarterly Investment Report Description CUSIP/Ticker Transaction ID Settlement Date YTM @ Cost Face Amount/Shares Cost Value Book Value Market Value Maturity Date Days To Maturity Accrued Interest % of PortfolioCash - Northland Securities Cash CASH5845 2/3/2002 0.000 701,131.36 701,131.36 701,131.36 701,131.36 N/A 1 1.61Morgan Stanley Cash CASH5089 12/31/2010 0.000 518,044.90 518,044.90 518,044.90 518,044.90 N/A 1 1.19Oppenheimer Cash MM9905 12/27/2011 0.000 19,142.93 19,142.93 19,142.93 19,142.93 N/A 1 0.04Sub Total / Average Cash0.000 1,238,319.19 1,238,319.19 1,238,319.19 1,238,319.19 1 0.00 2.84Allegiance Bank TX 2.2 11/3/2022 01748DAY2 58,629 11/3/2017 2.200 245,000.00 245,000.00 245,000.00 250,529.65 11/3/2022 399 398.71 0.56Alma Bank 1.8 9/11/2023 020080BM8 58,424 9/11/2019 1.800 245,000.00 245,000.00 245,000.00 251,889.40 9/11/2023 711 229.56 0.56Bank Baroda New York 3.55 11/30/2023 06062R-7R-7 33,681 11/30/2018 3.550 245,000.00 245,000.00 245,000.00 261,588.95 11/30/2023 791 2,899.17 0.56Bank Hapoalim 0.95 7/23/2026 06251A2Y5 33,686 7/23/2021 0.950 245,000.00 245,000.00 245,000.00 245,004.90 7/23/2026 1,757 439.99 0.56Bank of New England 3.25 7/31/2023 06426KAN8 24,540 7/31/2018 3.250 245,000.00 245,000.00 245,000.00 258,134.45 7/31/2023 669 0.00 0.56Bankers Bank West Denver CO 1.8 9/30/2024 06610T-EE-1 23,210 9/30/2019 1.800 245,000.00 245,000.00 245,000.00 253,369.20 9/30/2024 1,096 0.00 0.56BankUnited Savings Miami 0.95 3/31/2026 066519QT9 33,134 3/31/2021 0.950 245,000.00 245,000.00 245,000.00 245,169.05 3/31/2026 1,643 0.00 0.56Barclays Bk Delaware 2.3 10/18/2022 06740KLD7 57,203 10/18/2017 2.300 245,000.00 245,000.00 245,000.00 250,603.15 10/18/2022 383 2,547.33 0.56BMW Bank of NA 1.8 4/11/2022 05580ASR6 35,141 10/11/2019 1.800 247,000.00 247,000.00 247,000.00 249,232.88 4/11/2022 193 2,095.10 0.57Capital BK3.15 10/28/2022 139797HC1 34,562 10/29/2018 3.150 245,000.00 245,000.00 245,000.00 252,977.20 10/28/2022 393 21.14 0.56Capital One Nat'l Assn McLean 2.1 8/14/2024 14042RMW8 4,297 8/14/2019 2.100 247,000.00 247,000.00 247,000.00 257,467.86 8/14/2024 1,049 667.92 0.57Celtic Bank 1.8 8/30/2023 15118RRF6 57,056 8/30/2019 1.800 245,000.00 245,000.00 245,000.00 251,833.05 8/30/2023 699 0.00 0.56CF Bank 3.15 9/18/2023 15721UCQ0 28,263 9/18/2018 3.150 245,000.00 245,000.00 245,000.00 258,416.20 9/18/2023 718 253.73 0.56Citibank Sioux Falls 3.15 7/25/2022 17312QP86 7,213 7/24/2018 3.150 245,000.00 245,000.00 245,000.00 251,200.95 7/25/2022 298 1,437.78 0.56City National Bank 3.05 8/8/2022 17801GBU2 3,814 8/6/2018 3.050 245,000.00 245,000.00 245,000.00 251,210.75 8/8/2022 312 491.34 0.56COMENITY BK SALT LAKE CITY UT 2.6 11/24/2021 20033AJN7 57,570 11/26/2014 2.600 245,000.00 245,000.00 245,000.00 245,972.65 11/24/2021 55 69.81 0.56Discover Bank 1.9 5/11/2023 254672YR3 5,649 9/17/2019 2.001 245,000.00 244,135.15 244,618.22 251,460.65 5/11/2023 588 1,810.99 0.56Enerbank USA 0.55 9/25/2025 29278TRL6 57,293 9/25/2020 0.550 245,000.00 245,000.00 245,000.00 243,089.00 9/25/2025 1,456 18.46 0.56Enterprise Bank & Trust 1.8 11/8/2024 29367SJQ8 27,237 11/8/2019 1.800 245,000.00 245,000.00 245,000.00 253,577.45 11/8/2024 1,135 265.81 0.56Enterprise Bank Allison Park PA 1.8 9/27/2024 29367R-LA-2 34,786 9/27/2019 1.800 245,000.00 245,000.00 245,000.00 253,359.40 9/27/2024 1,093 36.25 0.56First Natl Bank of Albany 1.6 2/28/2025 76T155845 3,067 2/28/2020 1.600 245,000.00 245,000.00 245,000.00 252,504.35 2/28/2025 1,247 21.48 0.56First Source Bank 1.7 10/29/2021 33646CLT9 9,087 12/31/2019 1.700 245,000.00 245,000.00 245,000.00 245,316.05 10/29/2021 29 1,049.81 0.56Firstbank Puerto Rico 1.8 9/6/2022 33767GAE8 30,387 9/6/2019 1.800 245,000.00 245,000.00 245,000.00 248,890.60 9/6/2022 341 289.97 0.56Flagstar Bank FSB 0.2 6/30/2023 33847E4Q7 32,541 6/30/2021 0.200 245,000.00 245,000.00 245,000.00 244,576.15 6/30/2023 638 123.51 0.56Goldman Sachs 2.4 9/6/2022 38148PPC5 33,124 9/6/2017 2.400 245,000.00 245,000.00 245,000.00 250,277.30 9/6/2022 341 386.63 0.56Goldman Sachs Bk 1 7/28/2026 38149MXK4 33,124 7/28/2021 1.000 245,000.00 245,000.00 245,000.00 244,701.10 7/28/2026 1,762 429.59 0.56Harden County 3.1 9/28/2023 412022CJ2 5,817 9/28/2018 3.100 245,000.00 245,000.00 245,000.00 258,325.55 9/28/2023 728 41.62 0.56Industrial & Coml NY 2.65 2/14/2023 45581EAR2 24,387 2/14/2018 2.650 245,000.00 245,000.00 245,000.00 253,212.40 2/14/2023 502 284.60 0.56Iowa State Clarksville 3.15 9/28/2023 46256YAY5 15,947 9/28/2018 3.150 245,000.00 245,000.00 245,000.00 258,577.90 9/28/2023 728 42.29 0.56JP Morgan Chase 1.1 12/31/2026-21 48128US67 628 4/20/2021 1.100 245,000.00 245,000.00 245,000.00 245,137.20 12/31/2026 1,918 1,203.52 0.56KS State Bank Manhattan 2.1 5/17/2022 50116CBE8 19,899 11/17/2017 2.100 245,000.00 245,000.00 245,000.00 248,113.95 5/17/2022 229 183.25 0.56Marine Bank 3 1/18/2022 56817TAH4 20,250 7/18/2018 3.000 245,000.00 245,000.00 245,000.00 247,131.50 1/18/2022 110 241.64 0.56Merrick Bank2.2 11/8/2022 59013JD71 34,519 11/8/2017 2.200 245,000.00 245,000.00 245,000.00 250,590.90 11/8/2022 404 324.88 0.56Morgan Stanley Bank Step 11/28/2027 61765QP52 32,992 9/2/2021 1.004 249,000.00 249,000.00 249,000.00 248,636.46 11/28/2027 2,250 225.12 0.57MS Private Bank 3.55 11/8/2023 61760ARS0 34,221 11/8/2018 3.550 245,000.00 245,000.00 245,000.00 260,841.70 11/8/2023 769 3,455.17 0.56National Cooperative Bank3.4 12/21/2023 635573AL2 323,612 12/24/2018 3.400 245,000.00 245,000.00 245,000.00 261,123.45 12/21/2023 812 2,305.01 0.56New York Community Bank 0.2 7/3/2023 649447VA4 16,022 6/30/2021 0.200 245,000.00 245,000.00 245,000.00 244,563.90 7/3/2023 641 123.51 0.56Northwest Bank 2 4/29/2022 66736ABJ7 58,752 11/10/2017 2.000 245,000.00 245,000.00 245,000.00 247,729.30 4/29/2022 211 0.00 0.56Preferred Bank LA Calif 1.95 8/30/2024 740367HR1 33,539 8/30/2019 1.950 249,000.00 249,000.00 249,000.00 258,536.70 8/30/2024 1,065 0.00 0.57Sallie Mae Bank Utah 1.9 9/18/2024 7954504D4 58,177 9/18/2019 1.900 245,000.00 245,000.00 245,000.00 254,060.10 9/18/2024 1,084 153.04 0.56Spring Bank3.25 10/24/2023 849430AY9 58,668 10/24/2018 3.250 245,000.00 245,000.00 245,000.00 259,457.45 10/24/2023 754 130.89 0.56STATE BK INDIA NEW YORK NY 2.6 12/6/2021 8562843H5 33,682 12/5/2014 2.600 245,000.00 245,000.00 245,000.00 246,124.55 12/6/2021 67 2,041.89 0.56Sterling Bank Poplar Bluff MO 3.1 1/11/2023 85916V-CY-9 57,813 1/11/2019 3.100 245,000.00 245,000.00 245,000.00 254,187.50 1/11/2023 468 1,685.47 0.56Synchrony Bank 0.9 8/6/2026 87165GD58 27,314 8/6/2021 0.900 248,000.00 248,000.00 248,000.00 249,014.32 8/6/2026 1,771 336.33 0.57Texas Exchange Bk 0.45 8/21/2024 88241TJE1 20,099 8/21/2020 0.450 245,000.00 245,000.00 245,000.00 243,816.65 8/21/2024 1,056 27.18 0.56TIAA FSB Jacksonville FLA 1.95 8/26/2022 87270LCR2 34,775 8/28/2019 1.950 247,000.00 247,000.00 247,000.00 251,196.53 8/26/2022 330 435.460.57Toyota Finl Svgs Bk 0.95 7/15/2026 89235MLC3 57,542 7/15/2021 0.950 245,000.00 245,000.00 245,000.00 245,066.15 7/15/2026 1,749 491.01 0.56UBS Bank USA 3.25 10/17/2022 90348JEG1 57,565 10/17/2018 3.250 245,000.00 245,000.00 245,000.00 253,028.65 10/17/2022 382 283.60 0.56Veritex Cmnty Bk 0.2 9/15/2023 923450CP3 57,665 9/15/2021 0.200 245,000.00 245,000.00 245,000.00 244,267.45 9/15/2023 715 20.14 0.56Washington Federal 1.95 8/28/2024 938828BN9 28,088 8/28/2019 1.950 245,000.00 245,000.00 245,000.00 254,368.80 8/28/2024 1,063 26.18 0.56Wells Fargo BK NA Sioux Falls 2.75 5/17/2024 949763-B6-2 3,511 6/11/2019 2.650 200,000.00 200,924.00 200,492.25 211,522.00 5/17/2024 960 195.89 0.46Wells Fargo Natl Bk West 1.8 12/13/2022 949495AA3 27,389 12/13/2019 1.800 245,000.00 245,000.00 245,000.00 249,831.40 12/13/2022 439 205.40 0.56Wex Bk Midvale 0.25 6/30/2023 92937CKM9 34,697 6/30/2021 0.250 232,000.00 232,000.00 232,000.00 231,800.48 6/30/2023 638 146.19 0.53Sub Total / Average Certificate Of Deposit2.019 12,944,000.00 12,944,059.15 12,944,110.47 13,252,615.28 786 30,593.36 29.66FFCB 0.69 7/22/2025-21 3133ELX33 4/15/2021 0.750 600,000.00 598,488.00 598,650.94 597,264.00 7/22/2025 1,391 782.00 1.37FFCB 0.72 10/27/2026-21 3133EMES7 6/18/2021 1.000 500,000.00 492,715.00 493,102.14 493,310.00 10/27/2026 1,853 1,530.00 1.15FFCB 0.74 11/24/2026-21 3133EMHC9 4/14/2021 1.053 450,000.00 442,350.00 442,980.66 443,785.50 11/24/2026 1,881 1,165.50 1.03FFCB 2.62 11/17/2025 3133EHJR5 9/24/2021 0.810 500,000.00 536,830.00 536,684.14 535,895.00 11/17/2025 1,509 4,839.72 1.15Sub Total / Average FFCB Bond0.892 2,050,000.00 2,070,383.00 2,071,417.88 2,070,254.50 1,640 8,317.22 4.70FHLB 5.375 9/30/2022 3133XMFY2 6/18/2021 0.115 450,000.00 480,343.50 473,614.88 473,710.50 9/30/2022 365 0.00 1.03FHLB Step 12/15/2025-21 3130AKJ72 4/13/2021 0.894 500,000.00 497,500.00 497,748.97 496,970.00 12/15/2025 1,537 364.58 1.15FHLN 5159508 1.25 10/16/2026-21 3130ALW83 4/16/2021 1.250 216,666.67 216,666.67 216,666.67 216,499.84 10/16/2026 1,842 1,233.80 0.50FHLN 5214149 Step 7/22/2026-21 3130AN4W7 7/22/2021 1.057 1,000,000.00 1,000,000.00 1,000,000.00 998,510.00 7/22/2026 1,756 944.44 2.29Sub Total / Average FHLB Bond0.843 2,166,666.67 2,194,510.17 2,188,030.52 2,185,690.34 1,425 2,542.82 4.97FHLMC 0.5 12/9/2024 3134GWA71 9/9/2020 0.500 200,000.00 200,000.00 200,000.00 199,096.00 12/9/2024 1,166 308.33 0.46Sub Total / Average FHLMC Bond0.500 200,000.00 200,000.00 200,000.00 199,096.00 1,166 308.33 0.464M ARPA Funds LGIP LGIP5401ARPA 8/2/2021 0.010 11.70 11.70 11.70 11.70 N/A 1 0.004MP ARPA Funds LMC LGIP LGIP5401MPARPA 9/1/2021 0.030 1,441,316.18 1,441,316.18 1,441,316.18 1,441,316.18 N/A 1 3.30League of Minnesota Cities - 4M Fund LGIP LGIP5101M 11/30/2010 0.010 933,797.46 933,797.46 933,797.46 933,797.46 N/A 1 2.14League of Minnesota Cities - 4M LGIP LGIP5204M2017A 6/13/2017 0.000 0.00 0.00 0.00 0.00 N/A 1 0.00League of Minnesota Cities - 4M Plus Fund LGIP LGIP5101MP 11/30/2010 0.030 8,484,418.93 8,484,418.93 8,484,418.93 8,484,418.93 N/A 1 19.44LMC 2021A LGIP LGIP52074M 6/23/2021 0.010 2,311,223.44 2,311,223.44 2,311,223.44 2,311,223.44 N/A 1 5.30LMC 2021B LGIP LGIP52084M 7/26/2021 0.010 3,523.03 3,523.03 3,523.03 3,523.03 N/A 1 0.01Sub Total / Average Local Government Investment Pool0.025 13,174,290.74 13,174,290.74 13,174,290.74 13,174,290.74 1 0.00 30.19Allen Park MI Public Sch Dist 2 11/2/2024 018033HR4 7/30/2020 0.751 290,000.00 305,140.90 300,985.91 301,147.60 11/2/2024 1,129 2,400.56 0.66Armada Mich Area Schools Ref Bond 2.712 5/1/2022 042105MG8 8/29/2019 1.750 400,000.00 409,996.00 402,181.50 405,632.00 5/1/2022 213 4,489.87 0.92Canadian Cnty Okla Indpt Sch Dist 2 11/1/2024 135537-GT-9 11/7/2019 2.000 285,000.00 285,000.00 285,000.00 295,513.65 11/1/2024 1,128 2,359.17 0.65Local Government Investment PoolMunicipal BondCity of Prior LakePortfolio HoldingsInvestment Portfolio - by Security TypeAs of 9/30/2021CashCertificate Of DepositFFCB BondFHLB BondFHLMC Bond Cecil Cnty MD 1.05 11/1/2026 1498433N2 9/23/2021 0.970 500,000.00 501,985.00 501,977.55 496,610.00 11/1/2026 1,858 102.08 1.15Central Cmnty Sch 2 3/1/2026 153135FJ2 3/4/2021 0.700 300,000.00 319,098.00 316,898.01 310,452.00 3/1/2026 1,613 483.33 0.69Columbus Ohio2.333 12/1/2022 199492-CT-4 8/26/2019 1.750 100,000.00 101,840.00 100,658.58 102,515.00 12/1/2022 427 771.19 0.23Columbus Ohio City Sch Dist 2.036 12/1/2022 199507-6K-5 10/17/2019 1.901 135,000.00 135,552.15 135,206.63 137,613.60 12/1/2022 427 908.560.31Edgewood Ohio City 5 12/1/2023 280455ET9 12/19/2019 2.101 215,000.00 238,512.40 227,904.93 234,741.30 12/1/2023 792 3,553.47 0.49El Paso TX ISD 0 8/15/2024 283770NS0 10/30/2020 0.700 500,000.00 486,925.00 490,087.55 487,845.00 8/15/2024 1,050 0.00 1.15Federal Way Wash2.2 12/1/2024 314031-HH-1 12/11/2019 2.150 475,000.00 476,111.50 475,708.37 495,942.75 12/1/2024 1,158 3,454.31 1.09Hempstead NY1.125 12/1/2021 424092HH0 12/1/2020 0.350 600,000.00 604,632.00 600,786.81 600,858.00 12/1/2021 62 5,606.25 1.37Hennepin Cnty 5 12/1/2025 425507BS8 12/4/2020 2.976 115,000.00 125,723.75 123,959.01 121,362.95 12/1/2025 1,523 1,900.69 0.26Indiana Bond Bank 3.326 7/15/2025 45462TER9 3/26/2021 0.900 240,000.00 264,516.00 261,584.06 260,532.00 7/15/2025 1,384 1,663.00 0.55Iowa Westn Comm2.8 6/1/2023 462612SE3 2/12/2018 2.800 195,000.00 195,000.00 195,000.00 200,510.70 6/1/2023 609 1,804.83 0.45Liberty Center Ohio 0 11/1/2025 530336DV5 8/18/2020 1.051 215,000.00 203,589.95 206,038.82 203,921.05 11/1/2025 1,493 0.00 0.49Mankato Minn ISD 0.7 2/1/2025 563690RP3 10/22/2020 0.700 300,000.00 300,000.00 300,000.00 298,671.00 2/1/2025 1,220 344.17 0.69Maricopa Cnty Ariz 5 7/1/2022 567389UY5 3/19/2020 1.700 500,000.00 536,785.00 512,085.24 518,060.00 7/1/2022 274 6,180.56 1.15Massachusetts St 0.986 11/1/2026 57582RK96 6/30/2021 1.000 500,000.00 499,635.00 499,652.22 496,020.00 11/1/2026 1,858 2,040.47 1.15Massachusetts St Dev 2.785 5/1/2024 57584FEM8 12/20/2019 1.920 240,000.00 248,647.20 245,121.05 252,000.00 5/1/2024 944 2,766.43 0.55Medallion Bk Salt Lake City 3.4 12/7/2022 58404D-CX-7 57,449 12/7/2018 3.400 245,000.00 245,000.00 245,000.00 254,420.25 12/7/2022 433 532.19 0.56Monmouth OR Bds 2.9 4/1/2023 609694FZ2 1/30/2018 2.900 255,000.00 255,000.00 255,000.00 264,164.70 4/1/2023 548 3,676.96 0.58Monona Wis Ref 3 10/1/2022 610100XT1 9/18/2018 3.000 200,000.00 200,000.00 200,000.00 205,308.00 10/1/2022 366 2,983.33 0.46Nebraska State 3 12/15/2021 63968HE55 3/18/2020 1.651 370,000.00 378,532.20 371,017.97 372,016.50 12/15/2021 76 3,237.50 0.85Northwest Local Sch District Hamilton & Butler 667712CF8 11/15/2019 2.069 360,000.00 376,408.80 368,798.76 379,663.20 12/1/2023 792 3,867.50 0.82Northwest Local Sch District Hamilton & Butler 667712CG6 11/15/2019 2.169 370,000.00 389,010.60 381,944.80 396,011.00 12/1/2024 1,158 3,974.93 0.85Oak Creek WIS 4 10/1/2023 671137-YP-6 11/27/2018 3.402 280,000.00 287,434.00 283,071.94 299,544.00 10/1/2023 731 5,568.89 0.64Oklahoma Cnty Okla Metro 2.65 6/1/2024 67869T-AD-7 7/15/2019 2.286 500,000.00 508,255.00 504,514.09 525,640.00 6/1/2024 975 4,379.86 1.15Orono ME Taxable 5 11/1/2025 687085DR8 10/29/2020 1.000 330,000.00 394,287.30 382,477.28 383,262.00 11/1/2025 1,493 6,829.17 0.76Papio-Missouri Riv 4 12/15/2021 698874DQ4 3/18/2020 1.750 140,000.00 145,376.00 140,641.41 141,066.80 12/15/2021 76 1,633.33 0.32Pelican Rapids Minn 0.8 2/1/2025 705863HR2 12/17/2020 0.700 525,000.00 527,126.25 526,721.32 522,338.25 2/1/2025 1,220 688.33 1.20Rhode IS Infrastructure Bk 2.18 10/1/2023 7622FDD7 6/27/2019 2.151 435,000.00 435,522.00 435,245.08 450,834.00 10/1/2023 731 4,715.16 1.00Richfield Minn ISD 3 2/1/2024 763342SZ6 9/4/2020 0.570 200,000.00 216,380.00 211,235.76 209,182.00 2/1/2024 854 983.33 0.46Roanoke VA Taxable 2 2/1/2025 770078BD4 5/14/2020 1.250 300,000.00 310,266.00 307,264.80 312,036.00 2/1/2025 1,220 983.33 0.69South Lyon MI 2.69 5/1/2022 838736VU7 10/23/2017 2.250 250,000.00 254,702.50 250,606.68 253,357.50 5/1/2022 213 2,783.40 0.57St. Charles County MO Francis Howell School Distri 787642-4F-1 8/7/2019 2.531 200,000.00 209,956.00 203,953.34 202,990.00 3/1/2023 517 644.44 0.46Trussville AL 0.822 10/1/2025 898242ND0 8/25/2020 0.710 300,000.00 301,677.00 301,316.04 297,183.00 10/1/2025 1,462 1,226.15 0.69Univ of North Carolina NC 1.778 12/1/2021 914713N24 12/20/2019 1.800 200,000.00 199,914.00 199,992.51 200,554.00 12/1/2021 62 1,175.46 0.46Sub Total / Average Municipal Bond1.594 11,565,000.00 11,873,537.50 11,749,638.02 11,889,519.80 907 90,712.20 26.50T-Note 0.375 11/30/2025 91282CAZ4 9/24/2021 0.780 300,000.00 295,008.00 295,027.60 294,177.00 11/30/2025 1,522 375.00 0.69Sub Total / Average Treasury Note0.780 300,000.00 295,008.00 295,027.60 294,177.00 1,522 375.00 0.69Total / Average1.120 43,638,276.60 43,990,107.75 43,860,834.42 44,303,962.85 638 132,848.93 100Treasury Note Change from one 9/30/2020 12/31/2020 3/31/2021 6/30/2021 9/30/2021 year prior Market Value 12,793,321 13,942,057 12,919,565 14,932,703 14,412,610 1,619,289 111110 0.04% 0.03% 0.03% 0.01% 0.02%‐0.01% Fixed Income Assets 23,846,516 24,346,211 23,632,077 26,700,008 29,577,498 5,730,982 24,644,014 25,059,382 24,184,431 27,166,384 29,891,353 5,247,339 830 847 843 951 951 121 827 844 840 765 800 (27) 2.18% 2.06% 2.00% 1.75% 1.66%‐0.52% Total Portfolio Value 36,639,837 38,288,268 36,551,642 41,632,711 43,990,108 7,350,271 37,437,335 39,001,439 37,103,996 42,099,087 44,303,963 6,866,628 129,719 99,282 132,453 98,504 132,849 3,130 797,498 713,171 552,353 466,376 313,855 (483,643) 538 537 543 607 638 100 536 535 541 489 536 0 1.43% 1.32% 1.31% 1.13% 1.12%‐0.31% BENCHMARK 90 Day T‐Bill 0.10% 0.09% 0.03% 0.05% 0.04%‐0.06% 0.11% 0.09% 0.05% 0.06% 0.05%‐0.06% 0.13% 0.10% 0.07% 0.07% 0.09%‐0.04% Weighted Average Yield to Maturity @ Cost 6 Month Treasury 1 Year Treasury Cost Value Market Value Accrued Interest Unrealized Gain / Loss WAM (1) in Days WAM / Callable (1) in Days Weighted Average Yield to Maturity @ Cost CITY OF PRIOR LAKE, MINNESOTA Quarterly Investment Report September 30, 2021 Local Government Investment Pools / Money Market Quarterly WAM (1) in Days Weighted Average Yield to Maturity Cost Value Market Value WAM (1) in Days WAM / Callable (1) in Days City of Prior Lake ‐ Quarterly Investment Report City of Prior Lake General Fund Summary - Comparison to Prior Year As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive (Negative) USED9/30/2020Positive (Negative)RevenuesTaxes 9,433,959 9,433,959 5,001,951 (4,432,008) 53% 4,791,308 210,643 Licenses and Permits795,551 795,551 723,863 (71,688) 91% 727,083 (3,220) Intergovernmental 2,160,235 2,160,235 1,754,653 (405,582) 81% 3,472,977 (1,718,324) Charges for Services1,800,172 1,800,172 1,635,248 (164,924) 91% 1,256,012 379,236 Fines and Forfeitures‐ ‐ 38 38 n/a 320 (282) Interest (losses) on investments86,800 86,800 (72,792) (159,592) ‐84% 182,186 (254,978) Other154,000 154,000 441,449 287,449 287% 122,269 319,180 Transfers in 523,000 523,000 392,250 (130,750) 75% 352,500 39,750 Total Revenues14,953,717 14,953,717 9,876,660 (5,077,057) 66% 10,904,655 (1,027,995) ExpendituresGeneral Government3,269,647 3,287,247 2,420,142 867,105 74% 2,344,156 (75,986) Public Safety7,154,410 7,390,514 4,781,501 2,609,013 65% 4,433,742 (347,759) Public Works 2,245,916 2,245,916 1,536,401 709,515 68% 1,320,805 (215,596) Culture and Recreation2,154,169 2,154,169 1,392,378 761,791 65% 1,146,647 (245,731) Transfer to other funds253,575 1,053,575 847,753 205,822 80% 201,958 (645,795) Total Expenditures15,077,717 16,131,421 10,978,175 5,153,246 68% 9,447,308 (1,530,867) Net Change(124,000) (1,177,704) (1,101,515) 1,457,347 COMPARATIVE City of Prior Lake General Fund Revenues As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)Taxes101 31010.00 Current Property Taxes ‐ General Purpos 8,331,582 8,331,582 4,346,868 (3,984,714) 52% 4,216,640 130,228 101 31020.00 Delinquent Property Taxes ‐ General Purp‐ ‐ 51,295 51,295 n/a 21,907 29,388 101 31040.00 Fiscal Disparities 1,102,377 1,102,377 603,788 (498,589) 55% 552,761 51,027 Taxes9,433,959 9,433,959 5,001,951 (4,432,008) 53% 4,791,308 210,643 Licenses and Permits101 32100.00 Business Licenses 735 735 735 ‐ 100% 840 (105) 101 32110.00 Liquor Licenses 75,790 75,790 71,565 (4,225) 94% 38,290 33,275 101 32160.00 Refuse Haulers 4,500 4,500 5,335 835 119% 4,585 750 101 32175.00 Public Private Gathering Permit 720 720 660 (60) 92% 170 490 101 32180.00 Cigarette Licenses 2,040 2,040 1,785 (255) 88% 2,040 (255) 101 32190.00 Community Event Application‐ ‐ 4,235 4,235 n/a 450 3,785 101 32210.00 Building Permits 546,300 546,300 538,496 (7,804) 99% 569,913 (31,417) 101 32211.00 Retainage Forfeiture‐ ‐ 5,000 5,000 n/a‐ 5,000 101 32215.00 Mechanical Permits 87,300 87,300 43,031 (44,269) 49% 58,394 (15,363) 101 32230.00 Plumbing Permits 62,573 62,573 40,053 (22,520) 64% 40,577 (524) 101 32231.00 Sewer/Water Inspection 7,063 7,063 7,618 555 108% 7,424 194 101 32232.00 Plumbing Registrations 1,250 1,250 1,950 700 156% 660 1,290 101 32260.00 Burning Permits 4,000 4,000 3,400 3,000 85% 2,920 480 101 32270.00 Short‐term Rental Fee 3,280 3,280 ‐ (3,280) 0% 820 (820) Licenses and Permits 795,551 795,551 723,863 (71,688) 91% 727,083 (3,220) Intergovernmental101 33160.10 Fed Aids/Grants ‐ Operating Grants‐ ‐ ‐ ‐ n/a 1,982,322 (1,982,322) 101 33160.11 Fed Aids/Grants ‐ Operating Police 10,500 10,500 2,085 (8,415) 20% 3,754 (1,669) 101 33401.00 Local Government Aid 11,905 11,905 ‐ (11,905) 0%‐ ‐ 101 33416.01 State Aid ‐ Police Train 24,000 24,000 30,911 6,911 129% 25,405 5,506 101 33416.02 State Police Aid‐Ins Prem 229,000 229,000 ‐ (229,000) 0%‐ ‐ 101 33417.00 State Aid ‐ Fire Training 15,000 15,000 41,919 26,919 279%‐ 41,919 101 33418.00 State Road & Bridge Aid 377,000 377,000 403,545 26,545 107% 376,246 27,299 101 33420.00 State Fire Aid‐Ins. Prem. 237,000 237,000 ‐ (237,000) 0% 1,000 (1,000) 101 33422.10 State Aids/Grants ‐ Operating Grants 65,000 65,000 45,518 (19,482) 70% 11,485 34,033 102 33422.11 State Aids/Grants ‐ Operating Police 4,200 4,200 ‐ (4,200) 0%‐ ‐ 101 33610.11 County Aids/Grants ‐ Operating Grants‐ ‐ 1,000 1,000 n/a 1,000 ‐ 101 33610.11 County Aids/Grants ‐ Operating Police‐ ‐ ‐ ‐ n/a‐ ‐ 101 33620.00 Township Fire & Resc Aid 430,540 430,540 429,675 (865) 100% 365,765 63,910 101 33621.00 Liaison Aid 56,090 56,090 ‐ (56,090) 0%‐ ‐ 101 33631.00 Payment in Lieu of Taxes 700,000 700,000 800,000 100,000 114% 700,000 100,000 101 33700.11 Miscellaneous Grants ‐ Operating Police‐ ‐ ‐ ‐ n/a 6,000 (6,000) Intergovernmental 2,160,235 2,160,235 1,754,653 (405,582) 81% 3,472,977 (1,718,324) COMPARATIVE City of Prior Lake General Fund Revenues As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)COMPARATIVECharges for Services101 31810.00 Franchise Taxes 637,000 637,000 340,231 (296,769) 53% 326,001 14,230 101 34103.00 Zoning & Subdivision Fees 30,000 30,000 38,264 8,264 128% 27,786 10,478 101 34104.00 Plan Check Fees 300,424 300,424 268,360 (32,064) 89% 298,722 (30,362) 101 34105.00 Sale of Maps/Publications ‐ Reports 500 500 1,055 555 211% 375 680 101 34107.00 Assessment Searches ‐ Reports 500 500 575 75 115% 1,100 (525) 101 34108.00 Street Chip Seal Fee‐New Development‐ ‐ 62,590 62,590 n/a‐ 62,590 101 34109.00 Project Admin/Eng Fees 122,000 122,000 107,916 (14,084) 88% 41,100 66,816 101 34203.00 Accident/Warrant Reports ‐ Reports 300 300 40 (260) 13% 35 5 101 34731.00 Adult League Fees 10,000 10,000 4,480 (5,520) 45% 270 4,210 101 34735.00 Recreation Program Fees 43,000 43,000 87,064 44,064 202% 26,081 60,983 101 34735.01 Recreation Program Fees Regular 9,000 9,000 6,310 (2,690) 70% 5,637 673 101 34760.01 Facility Rental ‐ Regular 37,349 37,349 31,549 (5,800) 84% 25,762 5,787 101 34761.00 Studio/Pavilion Rental 24,000 24,000 23,453 (547) 98% 9,410 14,043 101 34762.00 Park Shelter Rental 83,200 83,200 82,840 (360) 100% 84,912 (2,072) 101 34765.01 Tower Leases 306,324 306,324 407,915 101,591 133% 299,338 108,577 101 34780.00 Park Admission Fees 30,000 30,000 36,932 6,932 123% 30,687 6,245 101 34783.00 City Contract Services 166,575 166,575 135,674 (30,901) 81% 57,992 77,682 101 36220.16 Prof Services Fee Deposit Bldg Inspectio‐ ‐ ‐ ‐ n/a 20,804 (20,804) Charges for Services 1,800,172 1,800,172 1,635,248 (164,924) 91% 1,256,012 379,236 Fines and Forfeitures101 35101.00 County Court Fines‐ ‐ ‐ ‐ n/a 300 (300) 101 35104.00 Prosecution Restitution‐ ‐ 38 38 n/a 20 18 Fines and Forfeitures‐ ‐ 38 38 n/a 320 (282) Interest (losses) on investments101 36210.00 Interest Earnings 86,800 86,800 106,889 20,089 123% 115,526 (8,637) 101 36215.00 Amortization ‐ Premium/Discount‐ ‐ (70,073) (70,073) n/a (46,166) (23,907) 101 36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (109,608) (109,608) n/a 112,826 (222,434) Interest (losses) on investments 86,800 86,800 (72,792) (159,592) ‐84% 182,186 (254,978) Other Miscellaneous Revenues101 36102.00 County Assess. Collection‐ ‐ 6,750 6,750 n/a 1,132 5,618 101 36211.00 Developer Agreements 130,000 130,000 332,450 202,450 256% 52,062 280,388 101 36212.00 Miscellaneous Revenue 24,000 24,000 49,486 25,486 206% 56,893 (7,407) 101 36230.00 Contributions & Donations‐ ‐ 24,205 24,205 n/a 11,246 12,959 101 39102.00 Sale of Property‐ ‐ 28,558 28,558 n/a 936 27,622 Other Miscellaneous Revenues 154,000 154,000 441,449 287,449 287% 122,269 319,180 Other financing sources101 39203.00 Transfer from Other Funds 523,000 523,000 392,250 (130,750) 75% 352,500 39,750 Other financing sources 523,000 523,000 392,250 (130,750) 75% 352,500 39,750 City of Prior Lake General Fund Revenues As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)COMPARATIVETotal Revenues14,953,717 14,953,717 9,876,660 (5,077,057) 66% 10,904,655 (1,027,995) City of Prior Lake General Fund Expenditures As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)Function: General Government41110.00 MAYOR & COUNCIL74,934 74,934 52,108 22,826 70% 47,408 (4,700) 41130.00 ORDINANCE 6,000 6,000 5,328 672 89% 4,126 (1,202) 41320.00 ADMINISTRATION 270,152 270,152 230,311 39,841 85% 247,264 16,953 41330.00 BOARDS & COMMISSIONS11,365 11,365 5,352 6,013 47% 3,818 (1,534) 41400.00 CITY CLERK 122,272 122,272 84,691 37,581 69% 82,407 (2,284) 41410.00 ELECTIONS 7,000 7,000 157 6,843 2% 29,042 28,885 41520.00 FINANCE 565,250 565,250 391,727 173,523 69% 337,596 (54,131) 41540.00 INTERNAL AUDITING 41,200 41,200 40,333 867 98% 31,184 (9,149) 41550.00 ASSESSING 224,260 224,260 220,600 3,660 98% 214,200 (6,400) 41610.00 LEGAL 180,000 180,000 122,197 57,803 68% 137,494 15,297 41820.00 HUMAN RESOURCES 316,074 333,674 228,092 105,582 68% 208,523 (19,569) 41830.00 COMMUNICATIONS 162,070 162,070 114,134 47,936 70% 107,281 (6,853) 41910.00 COMMUNITY DEVELOPMENT379,924 379,924 241,053 138,871 63% 232,734 (8,319) 41920.00 INFORMATION TECHNOLOGY 385,116 385,116 290,281 94,835 75% 326,345 36,064 41940.00 FACILITIES ‐ CITY HALL 524,030 524,030 393,778 130,252 75% 334,734 (59,044) Total ‐ Function General Government 3,269,647 3,287,247 2,420,142 867,105 74% 2,344,156 (75,986) Function: Public Safety42100.00 POLICE 5,303,369 5,539,473 3,688,950 1,850,523 67% 3,467,366 (221,584) 42200.00 FIRE 1,076,350 1,076,350 584,650 491,700 54% 486,591 (98,059) 42400.00 BUILDING INSPECTION 730,801 730,801 482,158 248,643 66% 450,027 (32,131) 42500.00 EMERGENCY MANAGEMENT15,090 15,090 4,143 10,947 27% 10,163 6,020 42700.00 ANIMAL CONTROL28,800 28,800 21,600 7,200 75% 19,595 (2,005) Total ‐ Function Public Safety 7,154,410 7,390,514 4,781,501 2,609,013 65% 4,433,742 (347,759) Function: Public Works43050.00 ENGINEERING 389,105 389,105 305,497 83,608 79% 248,875 (56,622) 43100.00 STREET 1,365,438 1,365,438 923,380 442,058 68% 721,650 (201,730) 43400.00 CENTRAL GARAGE 491,373 491,373 307,524 183,849 63% 350,280 42,756 Total ‐ Function Public Works 2,245,916 2,245,916 1,536,401 709,515 68% 1,320,805 (215,596) Function: Culture and Recreation45100.00 RECREATION 481,813 481,813 370,346 111,467 77% 238,529 (131,817) 45200.00 PARKS 1,604,132 1,604,132 982,390 621,742 61% 867,960 (114,430) 45500.00 LIBRARIES 68,224 68,224 39,642 28,582 58% 40,158 516 Total ‐ Function Culture and Recreation 2,154,169 2,154,169 1,392,378 761,791 65% 1,146,647 (245,731) 00000.00 Transfer to Other Funds 253,575 1,053,575 847,753 205,822 80% 201,958 (645,795) Total Expenditures15,077,717 16,131,421 10,978,175 5,153,246 68% 9,447,308 (1,530,867) COMPARATIVE City of Prior LakeExpenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 9/30/2021(Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)GENERAL FUNDFunction: General Government41110.00 MAYOR & COUNCIL 66,234 66,234 47,597 18,637 72% 43,722 (3,875) 41320.00 ADMINISTRATION 197,222 197,222 165,320 31,902 84% 174,014 8,694 41330.00 BOARDS & COMMISSIONS 10,765 10,765 5,352 5,413 50% 3,768 (1,584) 41400.00 CITY CLERK FUNCTIONS 120,422 120,422 84,276 36,146 70% 81,078 (3,198) 41410.00 ELECTIONS 3,500 3,500 137 3,363 4% 18,366 18,229 41520.00 FINANCE 537,955 537,955 378,711 159,244 70% 323,758 (54,953) 41820.00 HUMAN RESOURCES 271,624 271,624 189,736 81,888 70% 190,778 1,042 41830.00 COMMUNICATIONS 128,054 128,054 90,768 37,286 71% 78,047 (12,721) 41910.00 COMMUNITY DEVELOPMENT 317,724 317,724 219,442 98,282 69% 207,513 (11,929) 41920.00 INFORMATION TECHNOLOGY 225,935 225,935 155,124 70,811 69% 102,244 (52,880) 41940.00 FACILITIES ‐ CITY HALL 91,018 91,018 47,046 43,972 52% 49,472 2,426 Total ‐ Function General Government 1,970,453 1,970,453 1,383,509 586,944 70% 1,272,760 (110,749) Function: Public Safety42100.00 POLICE 4,736,215 4,939,965 3,327,397 1,612,568 67% 3,165,054 (162,343) 42200.00 FIRE 760,123 760,123 368,718 391,405 49% 342,360 (26,358) 42400.00 BUILDING INSPECTION 679,565 679,565 466,677 212,888 69% 432,839 (33,838) Total ‐ Function Public Safety 6,175,903 6,379,653 4,162,792 2,216,861 65% 3,940,253 (222,539) Function: Public Works43050.00 ENGINEERING 350,041 350,041 233,016 117,025 67% 219,975 (13,041) 43100.00 STREET 503,876 503,876 344,005 159,871 68% 325,384 (18,621) 43400.00 CENTRAL GARAGE 247,198 247,198 161,850 85,348 65% 162,374 524 Total ‐ Function Public Works 1,101,115 1,101,115 738,871 362,244 67% 707,733 (31,138) Function: Culture and Recreation45100.00 RECREATION 360,011 360,011 255,974 104,037 71% 174,832 (81,142) 45200.00 PARKS 1,081,258 1,081,258 696,441 384,817 64% 633,348 (63,093) Total ‐ Function Culture and Recreation 1,441,269 1,441,269 952,415 488,854 66% 808,180 (144,235) General Fund Payroll Only Expenditures Total 10,688,740 10,892,490 7,237,587 3,654,903 66% 6,728,926 (508,661) EDA FUNDFunction: Economic Development 46500.00 ECONOMIC DEVELOPMENT 135,544 135,544 99,413 36,131 73% 100,946 1,533 EDA Fund Payroll Only Expenditures Total 135,544 135,544 99,413 36,131 73% 100,946 1,533 COMPARATIVE City of Prior LakeExpenditures- Personal Services Category Only (Payroll/Taxes/Benefits) As of 9/30/2021(Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)COMPARATIVEWATER FUNDFunction: Water41520.00 Finance 76,881 76,881 52,815 24,066 69% 52,208 (607) 49400.00 Water 749,281 749,281 513,491 235,790 69% 496,586 (16,905) Water Fund Payroll Only Expenditures Total 826,162 826,162 566,306 259,856 69% 548,794 (17,512) SEWER FUNDFunction: Sewer41520.00 Finance 76,881 76,881 52,808 24,073 69% 52,266 (542) 49450.00 Sewer 731,502 731,502 510,438 221,064 70% 519,425 8,987 Sewer Fund Payroll Only Expenditures Total 808,383 808,383 563,246 245,137 70% 571,691 8,445 STORM WATER FUNDFunction: Storm Water49420.00 Water Quality 366,879 366,879 238,652 128,227 65% 230,583 (8,069) Storm Water Fund Payroll Only Expenditures Total 366,879 366,879 238,652 128,227 65% 230,583 (8,069) City‐Wide Total Payroll Expenditures 12,825,708 13,029,458 8,705,204 4,324,254 67% 8,180,940 (524,264) City of Prior Lake Debt Service Funds As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesProperty TaxesCurrent Property Taxes 3,121,498 3,121,498 1,647,105 (1,474,393) 53% 1,772,196 (125,091) Special AssessmentsCity Assess. Collections‐ ‐ 126,260 126,260 n/a 69,408 56,852 County Assess. Collection 446,370 446,370 221,181 (225,189) 50% 243,900 (22,719) Interest (losses) on investmentsInterest Earnings 46,406 46,406 38,105 (8,301) 82% 53,133 (15,028) Unrealized Inv.Gain(Loss)‐ ‐ (39,208) (39,208) n/a 54,880 (94,088) Other Financing SourcesTransfer from Other Funds 1,206,925 1,206,925 136,678 (1,070,247) 11% 147,004 (10,326) Bond Proceeds‐ ‐ 8,876,530 8,876,530 n/a‐ 8,876,530 Bond Discount/Premium‐ ‐ 1,326,442 1,326,442 n/a‐ 1,326,442 Total Revenues4,821,199 4,821,199 12,333,093 7,511,894 256% 2,340,521 9,992,572 ExpendituresDebt ServicePrincipal 4,274,858 4,274,858 136,705 4,138,153 3% 133,854 (2,851) Interest and Other 965,899 965,899 483,664 482,235 50% 583,853 100,189 Refunded Bond Escrow Pmts‐ ‐ 10,048,295 (10,048,295) n/a‐ (10,048,295) Bond Issuance Costs 2,870 2,870 126,041 (123,171) 4392% 1,990 (124,051) Transfers to Other Funds 75,000 75,000 ‐ 75,000 0%‐ ‐ Total Expenditures5,318,627 5,318,627 10,794,705 (5,476,078) 203% 719,697 (10,075,008) Net Change(497,428) (497,428) 1,538,388 1,620,824 COMPARATIVE City of Prior Lake Cable Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesCharges for Services210‐41340.00‐34304.00PEG Access Fees 28,000 28,000 12,036 (15,964) 43% 13,428 (1,392) Interest (losses) on investments210‐41340.00‐36210.00Interest Earnings‐ ‐ 1,113 1,113 n/a 1,102 11 210‐41340.00‐36225.00Unrealized Inv. Gain (Loss)‐ ‐ (1,107) (1,107) n/a 1,297 (2,404) Total Revenues28,000 28,000 12,042 (15,958) 43% 15,827 (3,785) ExpendituresCurrent Expenditures210‐41340.00‐52400.20Small Equipment ‐ Technology‐ ‐ 1,407 (1,407) n/a 296 (1,111) 210‐41340.00‐53210.00Telecommunications‐ ‐ ‐ ‐ n/a 4,427 4,427 Capital Outlay210‐41340.00‐55570.00Machinery and Equipment‐ ‐ 3,641 (3,641) n/a 6,398 2,757 Total Expenditures‐ ‐ 5,048 (5,048) n/a 11,121 6,073 Net Change28,000 28,000 6,994 4,706 COMPARATIVE City of Prior Lake Capital Park Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesCharges for Services225‐45200.00‐34760.01 Facility Rental ‐ Regular 24,000 24,000 18,000 (6,000) 75% 18,000 ‐ 225‐45200.00‐34791.00 Dedication Fees 431,000 431,000 431,502 502 100% 150,820 280,682 Charges for Services 455,000 455,000 449,502 (5,498) 99% 168,820 280,682 Interest (losses) on investments225‐00000.00‐36210.00 Interest Earnings 22,700 22,700 17,714 (4,986) 78% 26,504 (8,790) 225‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (17,741) (17,741) n/a 32,306 (50,047) Interest (losses) on investments 22,700 22,700 (27) (22,727) 0% 58,810 (58,837) Contributions and donations225‐00000.00‐36230.00 Contributions & Donations 18,597 18,597 31,981 13,384 172% 3,225 28,756 Contributions and donations 18,597 18,597 31,981 13,384 172% 3,225 28,756 Total Revenues496,297 496,297 481,456 (14,841) 97% 230,855 250,601 Expenditures54320.00 Miscellaneous‐ ‐ 1,197 (1,197) n/a‐ (1,197) 53100.80 Professional Services‐General‐ ‐ 12,436 (12,436) n/a 11,152 (1,284) 55010.00 Projects ‐ Contract Vouchers‐ ‐ 196,982 (196,982) n/a‐ (196,982) 55020.00 Projects ‐ Engineering‐ ‐ 106,042 (106,042) n/a 66,899 (39,143) 55530.00 Infrastructure 956,000 956,000 267,472 688,528 28% 1,551 (265,921) Total Expenditures956,000 956,000 584,129 371,871 61% 79,602 (504,527) Net Change(459,703) (459,703) (102,673) 151,253 COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesTaxes410‐00000.00‐31010.00 Current Property Taxes 650,000 650,000 440,631 (209,369) 68% 333,930 106,701 410‐00000.00‐31015.00 Current Property Taxes ‐ Debt Service 185,000 185,000 ‐ (185,000) 0%‐ ‐ Taxes835,000 835,000 440,631 (394,369) 53% 333,930 106,701 Interest (losses) on investments410‐00000.00‐36210.00 Interest Earnings 9,600 9,600 7,366 (2,234) 77% 9,059 (1,693) 410‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (7,578) (7,578) n/a 10,590 (18,168) Interest (losses) on investments 9,600 9,600 (212) (9,812) ‐2% 19,649 (19,861) Sale of assets410‐00000.00‐39102.00 Sale of Property‐ ‐ 75,175 75,175 n/a 51,813 23,362 Sale of assets‐ ‐ 75,175 75,175 n/a 51,813 23,362 Transfers in410‐00000.00‐39203.00 Transfer from Other Funds 310,000 310,000 232,500 (77,500) 75% 135,000 97,500 Transfers in310,000 310,000 232,500 (77,500) 75% 135,000 97,500 OTHER FINANCING SOURCESDebt Issued410‐00000.00‐39310.00 G.O. Bond Proceeds 555,000 555,000 494,292 (60,708) 89%‐ 494,292 Premium on debt issued410‐43100.00‐55110.00 Projects ‐ Bond Discount/Premium‐ ‐ 50,490 50,490 n/a‐ 50,490 555,000 555,000 544,782 (10,218) 98%‐ 544,782 Total Revenues1,709,600 1,709,600 1,292,876 (416,724) 76% 540,392 752,484 COMPARATIVE City of Prior Lake Revolving Equipment Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)COMPARATIVEExpendituresGeneral GovernmentCommunications410‐42100.00‐55570.00 Machinery & Equipment‐ 32,445 32,455 (10) 100%‐ (32,455) Total General Government‐ 32,445 32,455 (10) 100%‐ (32,455) Public SafetyPolice410‐42100.00‐55550.00 Vehicles 212,000 251,933 279,136 (27,203) 111% 164,252 (114,884) 410‐42100.00‐55570.00 Machinery & Equipment 38,900 38,900 38,965 (65) 100% 221,611 182,646 Fire410‐42200.00‐55070.00 Projects ‐ Bond Issuance Costs‐ ‐ 7,888 (7,888) n/a‐ (7,888) 410‐42200.00‐55550.00 Vehicles 740,000 740,000 24,615 715,385 3% 46,009 21,394 410‐42200.00‐55570.00 Machinery & Equipment 52,000 52,000 ‐ 52,000 0% 48,715 48,715 Building Inspection410‐42400.00‐55550.00 Vehicles 35,000 35,000 33,276 ‐ 95% 31,907 (1,369) Total Public Safety 1,077,900 1,117,833 383,880 732,229 34% 512,494 128,614 Public WorksStreet410‐43100.00‐55550.00 Vehicles 251,600 251,600 207,140 44,460 82% 308,465 101,325 410‐43100.00‐55570.00 Machinery & Equipment 38,000 38,000 31,745 6,255 84% 41,550 9,805 Central Garage410‐43400.00‐55550.00 Vehicles 20,000 20,000 19,937 63 100% 15,333 (4,604) Total Public Works 309,600 309,600 258,822 50,778 84% 365,348 106,526 Culture and Recreation/Parks410‐45200.00‐55550.00 Vehicles‐ ‐ 221,521 (221,521) n/a‐ (221,521) 410‐45200.00‐55570.00 Machinery and Equipment 262,500 262,500 78,429 184,071 30% 63,384 (15,045) Total Culture & Recreation 262,500 262,500 299,950 (37,450) 114% 63,384 (236,566) Water410‐49400.00‐55550.00 Vehicles 83,000 83,000 21,412 61,588 26%‐ (21,412) Sewer410‐49450.00‐55550.00 Vehicles 83,000 83,000 96,968 (13,968) 117%‐ (96,968) Total Utility 166,000 166,000 118,380 47,620 71%‐ (118,380) City of Prior Lake Revolving Equipment Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)COMPARATIVETotal Expenditures1,816,000 1,888,378 1,093,487 793,167 58% 941,226 (152,261) Net Change(106,400) (178,778) 199,389 (400,834) City of Prior Lake Revolving Park Equipment Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesTaxes430‐00000.00‐31010.00 Current Property Taxes 375,000 375,000 198,250 (176,750) 53% 170,252 27,998 Taxes375,000 375,000 198,250 (176,750) 53% 170,252 27,998 Interest (losses) on investments430‐00000.00‐36210.00 Interest Earnings 10,500 10,500 13,939 3,439 133% 14,204 (265) 430‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (13,722) (13,722) n/a 16,220 (29,942) Interest (losses) on investments 10,500 10,500 217 (10,283) 2% 30,424 (30,207) Total Revenues385,500 385,500 198,467 (187,033) 51% 200,676 (2,209) ExpendituresCulture and Recreation/Parks430‐45200.00‐55020.00 Projects ‐ Engineering‐ ‐ 14,236 (14,236) n/a‐ (14,236) 430‐45200.00‐55530.00 Infrastructure 525,000 525,000 18,811 506,189 4% 30,350 11,539 Transfers to other funds430‐80000.00‐59203.00 Transfers to other funds‐ ‐ 414,000 (414,000) n/a‐ (414,000) Total Culture & Recreation 525,000 525,000 447,047 77,953 85% 30,350 (416,697) Total Expenditures525,000 525,000 447,047 77,953 85% 30,350 (416,697) Net Change(139,500) (139,500) (248,580) 170,326 COMPARATIVE City of Prior Lake Facilities Management Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesTaxes440‐00000.00‐31010.00 Current Property Taxes80,000 80,000 42,094 (37,906) 53% 15,776 26,318 Taxes80,000 80,000 42,094 (37,906) 53% 15,776 26,318 Interest (losses) on investments440‐00000.00‐36210.00 Interest Earnings 5,800 5,800 7,866 2,066 136% 7,280 586 440‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (8,583) (8,583) n/a 8,668 (17,251) Interest (losses) on investments5,800 5,800 (717) (6,517) ‐12% 15,948 (16,665) Transfers in440‐00000.00‐39203.00 Transfer from Other Funds 130,000 930,000 897,500 (32,500) 97% 74,250 823,250 Transfers in130,000 930,000 897,500 (32,500) 97% 74,250 823,250 Total Revenues215,800 1,015,800 938,877 (76,923) 92% 105,974 832,903 ExpendituresFunction: General Government41940‐55050.00 Projects Professional Svcs‐ FACILITIES ‐ CITY HALL‐ ‐ 10,979 (10,979) n/a 10,660 (319) 41940‐55520.00 Building & Building Improvements‐FACILITIES ‐ CITY HAL240,000 240,000 15,236 224,764 6%‐ (15,236) Total ‐ Function General Government240,000 240,000 26,215 213,785 11% 10,660 (15,555) Function: Public Safety42100‐55520.00 Building & Building Improvements‐POLICE 22,500 22,500 ‐ 22,500 0%‐ ‐ 42200‐55520.00 Building & Building Improvements‐FIRE 120,000 120,000 15,985 104,015 13% 10,357 (5,628) Total ‐ Function Public Safety142,500 142,500 15,985 126,515 11% 10,357 (5,628) Function: Public Works43400.00 CENTRAL GARAGE 50,100 50,100 14,412 35,688 29%‐ (14,412) Total ‐ Function Public Works50,100 50,100 14,412 35,688 29%‐ (14,412) Function: Culture and Recreation45500.00 LIBRARIES 15,000 15,000 ‐ 15,000 0% 50,958 50,958 Total ‐ Function Culture and Recreation15,000 15,000 ‐ 15,000 0% 50,958 50,958 Function: Water49400.00 Building & Building Improvements‐ ‐ ‐ ‐ n/a 6,885 6,885 Total ‐ Function Culture and Recreation‐ ‐ ‐ ‐ n/a 6,885 6,885 Total Expenditures447,600 447,600 56,612 390,988 13% 78,860 22,248 Net Change(231,800) 568,200 882,265 27,114 COMPARATIVE City of Prior Lake Permanent Improvement Revolving Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesTaxes450‐00000.00‐31010.00 Property Taxes ‐ General Purpose 120,000 120,000 63,141 (56,859) 53% 42,727 20,414 Taxes120,000 120,000 63,141 (56,859) 53% 42,727 20,414 Special Assessments450‐00000.00‐36101.00 City Assess. Collections 173,000 173,000 15,307 (157,693) 9% 78,811 (63,504) 450‐00000.00‐36102.00 County Assess. Collection‐ ‐ 67,155 67,155 n/a 76,167 (9,012) 173,000 173,000 82,462 (90,538) 48% 154,978 (72,516) Interest (losses) on investments450‐00000.00‐36210.00 Interest Earnings 7,800 7,800 4,487 (3,313) 58% 9,759 (5,272) 450‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (4,570) (4,570) n/a 13,416 (17,986) Interest (losses) on investments 7,800 7,800 (83) (7,883) ‐1% 23,175 (23,258) Transfers in450‐00000.00‐39203.00 Transfer from Other Funds‐ ‐ ‐ ‐ n/a 257,935 (257,935) Transfers in‐ ‐ ‐ ‐ n/a 257,935 (257,935) Total Revenues300,800 300,800 145,520 (155,280) 48% 478,815 (333,295) ExpendituresFunction: Public Works450‐43100.00‐55530.00 Infrastructure‐ ‐ ‐ ‐ n/a 590,277 590,277 Total ‐ Function Public Works‐ ‐ ‐ ‐ n/a 590,277 590,277 OTHER FINANCING USESTransfers out450‐80000.00‐59203.00 Transfers to Other Funds 287,150 287,150 16,075 271,075 6% 29,633 13,558 Total Expenditures287,150 287,150 16,075 271,075 6% 619,910 603,835 Net Change13,650 13,650 129,445 (141,095) COMPARATIVE City of Prior Lake Water Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesOperating RevenueWater Charges601‐49400.00‐37100.00 Utility Receipts ‐ Water 3,146,749 3,146,749 2,316,679 (830,070) 74% 2,291,243 25,436 601‐49400.00‐37160.00 Penalties 20,000 20,000 13,271 (6,729) 66% 7,088 6,183 3,166,749 3,166,749 2,329,950 (836,799) 74% 2,298,331 31,619 Capital Facility charges601‐49400.00‐37110.00 Utility Base Fee Revenue 1,140,200 1,140,200 686,027 (454,173) 60% 152,381 533,646 1,140,200 1,140,200 686,027 (454,173) 60% 152,381 533,646 Meter Sales601‐49400.00‐37170.00 Water Meter Sales 79,825 79,825 65,185 (14,640) 82% 76,706 (11,521) 601‐49400.00‐37175.00 Pressure Reducers 25,000 25,000 15,342 (9,658) 61% 16,300 (958) 104,825 104,825 80,527 (24,298) 77% 93,006 (12,479) Total Operating Revenue4,411,774 4,411,774 3,096,504 (1,315,270) 70% 2,543,718 552,786 Non‐Operating RevenueIntergovernmental601‐00000.00‐33422.15 State Aids/Grants ‐ Operating Public Wor‐ ‐ 403 403 n/a 1,464 (1,061) ‐ ‐ 403 403 n/a 1,464 (1,061) Interest (losses) on investments601‐00000.00‐36210.00 Interest Earnings 54,775 54,775 62,947 8,172 115% 72,307 (9,360) 601‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (62,867) (62,867) n/a 86,653 (149,520) 54,775 54,775 80 (54,695) 0% 158,960 (158,880) Miscellaneous Revenues601‐00000.00‐36212.00 Miscellaneous Revenue‐ ‐ 11,496 11,496 n/a 11,520 (24) 601‐00000.00‐36102.00 County Assess Collection‐ ‐ 37,305 37,305 n/a 51,255 (13,950) 601‐49400.00‐37190.00 Miscellaneous Revenue Adj‐ ‐ (72) (72) n/a‐ (72) ‐ ‐ 48,729 48,729 ‐ 62,775 (14,046) Total Non‐Operating Revenue54,775 54,775 49,212 (5,563) 90% 223,199 (173,987) Total Revenues4,466,549 4,466,549 3,145,716 (1,320,833) 70% 2,766,917 378,799 COMPARATIVE City of Prior Lake Water Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)COMPARATIVETotal ExpendituresPersonnel and current expenditures (excluding depreciation)41520.00 Finance 108,246 108,246 70,917 37,329 66% 69,591 (1,326) 49400.00 Water 2,041,449 2,041,449 1,582,589 458,860 78% 1,377,733 (204,856) 2,149,695 2,149,695 1,653,506 496,189 77% 1,447,324 (206,182) Principal49400.00 Water 120,000 120,000 ‐ 120,000 0%‐ ‐ 120,000 120,000 ‐ 120,000 0%‐ ‐ Interest & other49400.00 Water 49,650 49,650 24,825 24,825 50% 27,225 2,400 49,650 49,650 24,825 24,825 50% 27,225 2,400 Capital improvements55530.00 Infrastructure 1,917,500 1,917,500 840,049 1,077,451 44%‐ (840,049) 55570.00 Machinery and equipment 150,750 150,750 ‐ 150,750 0%‐ ‐ 55580.00 Software 28,500 28,500 ‐ 28,500 0% 13,510 13,510 2,096,750 2,096,750 840,049 1,256,701 40% 13,510 (826,539) Total Expenditures4,416,095 4,416,095 2,518,380 1,897,715 1,488,059 (1,030,321) 0.0%Other Financing Uses59203.00 Transfers to other funds 1,035,700 1,035,700 1,191,106 (155,406) 353,495 (837,611) Total Other Financing Uses1,035,700 1,035,700 1,191,106 (155,406) 353,495 (837,611) Total Revenues/ Other Financing Sources4,466,549 4,466,549 3,145,716 (1,320,833) 70% 2,766,917 378,799 Total Expenditures/Other Financing Uses5,451,795 5,451,795 3,709,486 1,742,309 68% 1,841,554 (1,867,932) Net Change (985,246) (985,246) (563,770) 421,476 925,363 2,246,731 City of Prior Lake Sewer Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesSewer Charges604‐49450.00‐37102.00 Utility Receipts ‐ Sewer 1,717,840 1,717,840 783,462 (934,378) 46% 1,085,227 (301,765) 604‐49450.00‐37104.00 Utility Recpt‐Sewer MCES 1,625,587 1,625,587 1,176,865 (448,722) 72% 1,149,767 27,098 604‐49450.00‐37160.00 Penalties 20,000 20,000 17,444 (2,556) 87% 8,543 8,901 3,363,427 3,363,427 1,977,771 (1,385,656) 59% 2,243,537 (265,766) Capital Facility charges604‐49450.00‐37110.00 Utility Base Fee Revenue 953,615 953,615 600,226 (353,389) 63% 152,386 447,840 953,615 953,615 600,226 (353,389) 63% 152,386 447,840 Total Operating Revenue4,317,042 4,317,042 2,577,997 (1,739,045) 60% 2,395,923 182,074 Non‐Operating RevenueInterest (losses) on investments604‐00000.00‐36210.00 Interest Earnings 19,800 19,800 32,311 12,511 163% 30,128 2,183 604‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (32,274) (32,274) n/a 34,290 (66,564) 19,800 19,800 37 (19,763) 0% 64,418 (64,381) Total Non‐Operating Revenue19,800 19,800 37 (19,763) 0% 64,418 (64,381) Total Revenue4,336,842 4,336,842 2,578,034 (1,758,808) 59% 2,460,341 117,693 COMPARATIVE City of Prior Lake Sewer Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)COMPARATIVETotal ExpendituresPersonnel and current expenditures (excluding depreciation)41520.00 Finance 107,721 107,721 70,910 36,811 66% 70,805 (105) 49450.00 Sewer 2,681,274 2,681,274 1,912,678 768,596 71% 1,944,673 31,995 2,788,995 2,788,995 1,983,588 805,407 71% 2,015,478 31,890 Principal49450.00 Sewer 120,000 120,000 ‐ 120,000 0%‐ ‐ 120,000 120,000 ‐ 120,000 0%‐ ‐ Interest & other49450.00 Sewer 49,650 49,650 24,825 24,825 50% 27,225 2,400 49,650 49,650 24,825 24,825 50% 27,225 2,400 Capital improvements55530.00 Infrastructure 736,500 736,500 ‐ 736,500 0%‐ ‐ 55570.00 Machinery and equipment 90,250 90,250 ‐ 90,250 0%‐ ‐ 55580.00 Software 28,500 28,500 ‐ 28,500 0% 12,118 12,118 855,250 855,250 ‐ 855,250 0% 12,118 12,118 Total Expenditures3,813,895 3,813,895 2,008,413 1,805,482 2,054,821 46,408 Other Financing Uses59203.00 Transfers to other funds 366,000 366,000 940,190 (574,190) 257% 220,583 (719,607) Total Other Financing Uses366,000 366,000 940,190 (574,190) 257% 220,583 (719,607) Total Revenues/ Other Financing Sources4,336,842 4,336,842 2,578,034 (1,758,808) 59% 2,460,341 117,693 Total Expenditures/Other Financing Uses4,179,895 4,179,895 2,948,603 1,231,292 71% 2,275,404 (673,199) Net Change156,947 156,947 (370,569) (527,516) 184,937 790,892 City of Prior Lake Water Quality Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesStorm Water Charges602‐49420.00‐37120.00 Storm Water Revenue 1,186,699 1,186,699 664,344 (522,355) 56% 647,161 17,183 602‐49420.00‐32250.00 Wetland Application Fee‐ ‐ 600 600 n/a 600 ‐ 1,186,699 1,186,699 664,944 (521,755) 56% 647,761 17,183 Water Charges602‐49420.00‐37160.00 Penalties 4,000 4,000 2,770 (1,230) 69% 1,408 1,362 4,000 4,000 2,770 (1,230) 69% 1,408 1,362 Total Operating Revenue1,190,699 1,190,699 667,714 (522,985) 56% 649,169 18,545 Non‐Operating RevenueIntergovernmental602‐00000.00‐33422.10 State Aids/Grants‐ ‐ 27,000 27,000 n/a‐ 27,000 602‐49420.00‐33610.20 County‐City Aids/Grants‐ ‐ 6,300 6,300 n/a‐ 6,300 ‐ ‐ 33,300 33,300 n/a‐ 33,300 Interest (losses) on investments602‐00000.00‐36210.00 Interest Earnings 14,500 14,500 22,758 8,258 157% 23,186 (428) 602‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (22,509) (22,509) n/a 27,404 (49,913) 14,500 14,500 249 (14,251) 2% 50,590 (50,341) Miscellaneous Revenues602‐00000.00‐36212.00 Miscellaneous Revenue‐ ‐ 5,580 5,580 n/a 240 5,340 ‐ ‐ 5,580 5,580 n/a 240 5,340 Total Non‐Operating Revenue14,500 14,500 39,129 24,629 270% 50,830 (11,701) Total Revenues1,205,199 1,205,199 706,843 (498,356) 59% 699,999 6,844 COMPARATIVE City of Prior Lake Water Quality Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGT Actual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)COMPARATIVETotal ExpendituresPersonnel and current expenditures (excluding depreciation)49420.00 Water Quality 622,893 698,264 451,765 246,499 65% 336,882 (114,883) 622,893 698,264 451,765 246,499 65% 336,882 (114,883) Capital improvements55530.00 Infrastructure 359,500 359,500 14,988 344,512 4% 36,501 21,513 359,500 359,500 14,988 344,512 4% 36,501 21,513 55700.00 Contra Capital Outlay‐ ‐ ‐ ‐ n/a (35,529) (35,529) Total Expenditures982,393 1,057,764 466,753 591,011 44% 337,854 (128,899) Other Financing Uses59203.00 Transfers to other funds 127,000 127,000 420,045 (293,045) 331% 64,335 (355,710) Total Other Financing Uses127,000 127,000 420,045 (293,045) 331% 64,335 (355,710) Total Revenues/ Other Financing Sources1,205,199 1,205,199 706,843 (498,356) 59% 699,999 6,844 Total Expenditures/Other Financing Uses1,109,393 1,184,764 886,798 297,966 75% 402,189 (484,609) Net Change95,806 20,435 (179,955) (200,390) 297,810 (477,765) City of Prior Lake Economic Development Authority Special Revenue Fund As of 9/30/2021 (Preliminary & Unaudited)Variance from Variance2021 2021 2021 Amended Budget ‐ % BDGTActual from 2020Budget Amended Actual Positive ( Negative) USED9/30/2020Positive (Negative)RevenuesTaxes240‐00000.00‐31010.00 Current Property Taxes 349,750 349,750 185,108 (164,642) 53% 146,510 38,598 Taxes349,750 349,750 185,108 (164,642) 53% 146,510 38,598 Charges for Services240‐46503.00‐34760.02 Facility Rental ‐ EDA 8,450 8,450 2,435 (6,015) 29% 5,609 (3,174) Charges for Services 8,450 8,450 2,435 (6,015) 29% 5,609 (3,174) Interest (losses) on investments240‐00000.00‐36210.00 Interest Earnings 5,300 5,300 4,792 (508) 90% 5,568 (776) 240‐00000.00‐36225.00 Unrealized Inv.Gain(Loss)‐ ‐ (4,636) (4,636) n/a 5,717 (10,353) Interest (losses) on investments 5,300 5,300 156 (5,144) 3% 11,285 11,129 Contributions and Donations240‐00000.00‐36230.00 Contributions and Donations‐ ‐ ‐ ‐ n/a 4,900 (4,900) Contributions and Donations‐ ‐ ‐ ‐ n/a 4,900 (4,900) Transfers In 240‐00000.00‐39203.00 Transfer from Other Funds‐ ‐ ‐ ‐ n/a 161,250 (161,250) Transfers In ‐ ‐ ‐ ‐ n/a 161,250 (161,250) Total Revenues363,500 363,500 187,699 (175,801) 52% 329,554 (141,855) ExpendituresFunction: Economic Development46500.00 ECONOMIC DEVELOPMENT 519,294 519,294 572,391 (53,097) 110% 204,903 (367,488) 46503.00 TECH VILLAGE INCUBATOR 5,500 5,500 1,150 4,350 21% 1,662 512 Total Expenditures524,794 524,794 573,541 (48,747) 109% 206,565 (366,976) Net Change(161,294) (161,294) (385,842) 122,989 COMPARATIVE 1 | Page 1976 Wooddale Drive, Suite 4 | Woodbury, MN 55125 Phone (651) 773-5111 | Fax (651) 773-5222 September 30, 2021 Mr. Andy Stephes By Email Water Department Foreman City of Prior Lake Maintenance Center 17073 Adelmann Street Southeast Prior Lake, MN 55372 RE: Pay Request No. 3 (Final) for the Rehabilitation of the 750,000 Gallon Elevated Water Tower (South Tower) Located in Prior Lake, Minnesota. KLM Project No. 1493-20 Dear Mr. Stephes, Viking Industrial Painting has submitted Pay Request No. 3 (Final) in the amount of $93,920.00. KLM recommends that the City of Prior Lake approve this Pay Request. Also enclosed is the following close out documentation: Contractor’s Affidavit Consent of Surety IC-134 KLM recommends that the City of Prior Lake approve this project as complete. We also recommend a two (2) year warranty inspection (warranty date started on July 8, 2021). We will contact you prior to that time to schedule an inspection. If you have any questions, please contact me at 651-755-8664. Sincerely, KLM Engineering, Inc. Scott J. Kriese Project Supervisor SK/TK P:2021\2021 Prior Lake, MN 1493-20 Pay Request No.3 (Final) Contractor's Application for Payment No. Application Period:Application Date: To (Owner):From (Contractor):Via (Engineer): Project:Contract: Owner's Contract No.:Contractor's Project No.:Engineer's Project No.:MN1493 1. ORIGINAL CONTRACT PRICE...........................................................................$ 2. Net change by Change Orders......................................................................................$ 3. Current Contract Price (Line 1 ± 2)................................................................................................$ 4. TOTAL COMPLETED AND STORED TO DATE (Column F on Progress Estimate).............................................................................................................$ 5. RETAINAGE: a.X $789,300.00 Work Completed..............................................$ b.5%X Stored Material..............................................$ c.Total Retainage (Line 5a + Line 5b).........................................................................................................................................$ 6. AMOUNT ELIGIBLE TO DATE (Line 4 - Line 5c)....................................................................................................................$ 7. LESS PREVIOUS PAYMENTS (Line 6 from prior Application).........................................................................................................$ 8. AMOUNT DUE THIS APPLICATION....................................................................................................................................$ 9. BALANCE TO FINISH, PLUS RETAINAGE (Column G on Progress Estimate + Line 5 above).....................................................................................................$ Contractor's Certification Payment of:$ is recommended by: Payment of:$ is approved by: By:Date: Approved by: Change Order Summary Additions Approved Change Orders Number Deductions $789,300.00 (Engineer) $789,300.00 (Date) $695,380.00 $93,920.00 Endorsed by the Construction Specifications Institute. (Line 8 or other - attach explanation of the other amount) (Date) Funding Agency (if applicable)(Date) The undersigned Contractor certifies that to the best of its knowledge: (1) all previous progress payments received from Owner on account of Work done under the Contract have been applied on account to discharge Contractor's legitimate obligations incurred in connection with Work covered by prior Applications for Payment; (2) title of all Work, materials and equipment incorporated in said Work or otherwise listed in or covered by this Application for Payment will pass to Owner at time of payment free and clear of all Liens, security interests and encumbrances (except such as are covered by a Bond acceptable to Owner indemnifying Owner against any such Liens, security interest or encumbrances); and (3) all Work covered by this Application for Payment is in accordance with the Contract Documents and is not defective. $93,920.00 (Line 8 or other - attach explanation of the other amount) (Owner) 9/22/2021 CHANGE ORDERS TOTALS $789,300.00 NET CHANGE BY 2020-25 Viking Industrial Painting 15112 KLM Engineer $789,300.00 Application For Payment 7/1/21-8/31/21 9/22/2021 3 Final R 750MG ELC South Tower Prior Lake, MN Prior Lake 750KG South Tower 00620-1 Scott Kriese 9/27/21 Progress Estimate For (contract):Application Number: Application Period:Application Date: Item C D Materials Presently Total Completed Balance to Finish This Period Stored (not in C or D) and Stored to Date (B - F) (C + D + E) Prior Lake, MN Mobilization $7,500.00 $7,500.00 $7,500.00 100.0% Structural Modifications Extend 36'' diameter drywell tube $28,800.00 $28,800.00 $28,800.00 100.0% Urethane caulk $9,000.00 $9,000.00 $9,000.00 100.0% Seal Weld Roof Rafters $9,400.00 $9,400.00 $9,400.00 100.0% Seal weld both sides of the intermittently welded horizontal stiffener ring. $38,600.00 $38,600.00 $38,600.00 100.0% Install 1/4'' bars on horizontal and verticaal stiffners ring $19,500.00 $19,500.00 $19,500.00 100.0% Remove unused penetration in drywell tube, electrical box, conduit and wiring $2,800.00 $2,800.00 $2,800.00 100.0% Replace the gasket on the 24-inch diameter bowl manway $600.00 $600.00 $600.00 100.0% Install GS12 Mixier $22,500.00 $22,500.00 $22,500.00 100.0% Install 24'' pressure manway $5,300.00 $5,300.00 $5,300.00 100.0% Replace bowl drain coupling and plug $5,000.00 $5,000.00 $5,000.00 100.0% Seal Weld upper platform floor to the wall $6,900.00 $6,900.00 $6,900.00 100.0% Replace 5 light fixture $9,600.00 $9,600.00 $9,600.00 100.0% Remove and Replace Insulation and Jacket $14,000.00 $14,000.00 $14,000.00 100.0% Remove Ladder Cage from Interior Ladder $9,800.00 $9,800.00 $9,800.00 100.0% Install new safety climb on interior ladder $2,800.00 $2,800.00 $2,800.00 100.0% Install anchor point on exteior drywell tube $400.00 $400.00 $400.00 100.0% Install 24'' Vent $7,300.00 $7,300.00 $7,300.00 100.0% Install 20ft handrail $23,400.00 $23,400.00 $23,400.00 100.0% Replace Obstruction Light $5,600.00 $5,600.00 $5,600.00 100.0% Replace two 2'' rigging coupling $900.00 $900.00 $900.00 100.0% Remove existing containment tab $1,400.00 $1,400.00 $1,400.00 100.0% Replace the existing overflow pipe screen with a corrosion-resistant, heavy-gauge #4 mesh screen. $600.00 $600.00 $600.00 100.0% All weld spatter removed by griding $6,700.00 $6,700.00 $6,700.00 100.0% Surface Repairs $6,700.00 $6,700.00 $6,700.00 100.0% Interior Wet Coating Surface Prep and Prime $69,000.00 $69,000.00 $69,000.00 100.0% 2nd Coat $30,000.00 $30,000.00 $30,000.00 100.0% 3rd Coat $30,000.00 $30,000.00 $30,000.00 100.0% Interior Dry Coating Surface Prep and Prime $7,000.00 $7,000.00 $7,000.00 100.0% 2nd Coat $5,000.00 $5,000.00 $5,000.00 100.0% 3rd Coat $5,000.00 $5,000.00 $5,000.00 100.0% Exterior Coating Containment $150,000.00 $150,000.00 $150,000.00 100.0% Surface Prep and Prime $100,000.00 $100,000.00 $100,000.00 100.0% 2nd Coat $30,000.00 $30,000.00 $30,000.00 100.0% 3rd Coat $40,000.00 $40,000.00 $40,000.00 100.0% 4th Coat $60,700.00 $50,000.00 $10,700.00 $60,700.00 100.0% Logo $10,000.00 $10,000.00 $10,000.00 100.0% Demobilization $7,500.00 $7,500.00 $7,500.00 100.0% Totals $789,300.00 $706,400.00 $82,900.00 $789,300.00 100.0% Contractor's Application % (F) B Prior Lake, MN 7/1/21-8/31/21 3 Final 9/22/2021 A GE Specification Section No.Description Scheduled Value Work CompletedB F From Previous Application (C+D) 00620-2 Page 1 of 2 Public Works Consultant Pool Work Order CSAH 21/Revere Way Intersection Improvements KIMLEY HORN & ASSOCIATES, INCORPORATED This work order (“Work Order”) is issued on this 1st day of November 2021 by the City of Prior Lake (“City”) pursuant to the Public Works Consultant Pool – Master Agreement dated April 6, 2020 (“Contract”) between the City and Kimley Horn & Associates, Incorporated (“Consultant”). Based on the mutual promises and covenants set forth herein, the sufficiency of which are hereby acknowledged, the City and Consultant agree as follows: 1. Scope of Work Order. Consultant agrees to provide, perform and complete all the services requested by the City in this Work Order and attached Exhibit 1 (“Work”), which Work shall be subject to the terms and conditions of this Work Order and the Contract. 2. Term of Work Order. All Work requested by this Work Order shall be completed by December 31, 2022. 3. Compensation for Work Order. City agrees to pay the Consultant an hourly sum not to exceed $28,250 as full and complete payment for the Work requested by this Work Order. 4. Consultant Representative. Consultant has designated Chadd Larson, PE to manage the Work Order subject to the supervision of Consultant’s representative. ISSUED BY CITY OF PRIOR LAKE ___________________________________ Mayor ___________________________________ City Manager RECEIVED AND ACCEPTED BY CONSULTANT _____________________________________ Signature: _____________________________________ Title: Page 2 of 2 Exhibit 1 – Scope of Work Order 1 kimley-horn.com OFFICE ADDRESS PHONE October 20, 2021 Mr. Andy Brotzler, P.E. Public Works Director/City Engineer City of Prior Lake 4646 Dakota Street SE Prior Lake, MN 55372 Re: Amendment Number 1 to Professional Services Agreement CSAH 21 and Revere Way Intersection Improvements Dear Mr. Brotzler: Kimley-Horn and Associates, Inc. (“Kimley-Horn” or “Consultant”) and the City of Prior Lake (“Client”) entered in a Professional Services Agreement dated May 3, 2021 (“Agreement”) concerning the CSAH 21 and Revere Way Intersection Improvements. (“Project”). The parties now desire to amend the Agreement to include services to be performed by Kimley-Horn for compensation as set forth below in accordance with the terms of the Agreement, which are incorporated by reference. Kimley-Horn will provide the services specifically set forth below. Title Commitments Title commitments will be provided for three (3) parcels on the project. This work will be performed by a Kimley-Horn subconsultant, Pioneer Engineering. Right of Way Appraisal and Acquisition Services Right of way appraisal and acquisition services will be provided for three (3) parcels on the project. The scope of work included with these services is as follows: Prepare owner notifications and field title reports Prepare appraisals and review appraisals for acquisitions Prepare offer packages to property owners Participate in negotiation activities This work will be performed by a Kimley-Horn subconsultant, SRF Consulting Group. We will provide our services as expeditiously as practicable with the goal of acquiring all right of way for an early 2022 project bidding. EXHIBIT 1 2 kimley-horn.com OFFICE ADDRESS PHONE Kimley-Horn will provide the scope of services identified in this amendment on an hourly labor fee plus expense basis. The following is a summary of the estimated fees and expenses for the tasks identified in this amendment. Work Task Estimate Amount Title Commitments $ 1,500 Right of Way Appraisal and Acquisition Services $26,750 Total $28,250 We appreciate the opportunity to provide these services to you. Please contact me if you have any questions. Sincerely, KIMLEY-HORN AND ASSOCIATES, INC. Chadd B. Larson, P.E. Vice President Attachments: SRF Proposal October 6, 2021 SRF# 15118.PP Chadd Larson, P.E. Kimley- Horn 767 Eustis Street, Suite 100 St. Paul, MN 55114 Subject: Proposal for Right of Way Appraisal and Acquisition Services CSAH 21- City of Prior Lake Dear Chadd Larson, We appreciate your interest in utilizing SRF’s professional right of way services on the above referenced project. All acquisition activities will comply with the Uniform Relocation and Real Property Acquisition Policies Act of 1970, as amended, as well as all State and Federal guidelines. SRF has been recognized for its accurate and efficient record keeping by the MNDOT State Aid personnel on several federally funded projects. The SRF team includes right of way professionals who have a wide variety of experience in highway, municipal, utility, relocation, and community redevelopment projects. The project will be led by Cindy Wiste, SRF Senior Associate, who has over 14 years of experience in the right of way profession. Acquisition Activities Project Management SRF’s Project Manager will maintain contact with the City of Prior Lake and Kimley Horn (City) throughout the project and provide weekly status reports. Title Analysis Provided by Kimley Horn Owner Notifications and Field Title Reports SRF will provide owners of the three tax parcels with notification of the project; prepare full field title reports, including tenant information. Assumptions: 3 Owners (3 Tax Parcels) Appraisals and Review Appraisals Appraisals will be provided by Kelly Lindstrom. Review Appraisals will be provided by Patty Nolan with Evergreen Land Services Assumptions: 3 Appraisals and 3 Appraisal Reviews Mr. Chadd Larson, P.E. October 8, 2021 Page 2 Offer Packages and Document Preparation SRF will prepare the offer letter, statement of compensation, appraisal notification and receipt, and any other documents and forms required by the city. The city will provide sample conveyance documents to be used for this project. Assumptions: 3 Owners (3 Tax Parcels) Negotiation Activities The offers will be presented to the owners, in person, if possible, at the earliest possible time the affected owner is willing to meet with SRF personnel. In the case of an out-of-town owner, or when required by time constraints, the offer will be presented by certified mail, but continuing attempts will be made to contact the owner and meet at the earliest possible time after mailing the offer. The owner will receive a copy of the appraisal report, unless we are directed otherwise. All concerns and issues raised by an owner will be communicated to the City. Communications will be by means of periodic status reports, telephone, or written correspondence, depending upon the nature of the issue. We will make recommendations and prepare an administrative settlement form for the parcel if a settlement more than the certified offer seems appropriate. Assumptions: 3 Owners (3 Tax Parcels). Also, there is no minimum compensation, or loss of Going Concern Analysis included in this scope. Mortgage Consents SRF will assist with obtaining any required lender consents or subordinations. This task is assumed to be needed on one parcel. Any fees required by the lender are NOT included in this proposal. Submittal of Parcel Files The acquisition files will include a contact diary in which every contact or attempted contact with the property owner are noted, whether by the agent responsible for the parcel or by other SRF staff. This diary will include relevant detail about the substance of each contact. SRF will complete an internal review of all parcel files and submit a complete acquisition file to the city for payment and recordation. Schedule SRF will complete this work within a mutually agreed-upon time schedule. The estimated cost for our services relating to this project is $26,750, which includes time and expenses, except the mortgage consent fees noted above. This fee breaks down as Follows for 3 Tax Parcels • Appraisals (3) $ 11,000 • Review Appraisal (assumes 3 reviews)- will be invoiced as an expense $ 2,500 • Document Preparation, Negotiations, File Submittal $12,900 • Expenses (mileage, postage, etc.) $ 350 TOTAL $26,750 Mr. Chadd Larson, P.E. October 8, 2021 Page 3 Basis of Payment/Budget We propose to be reimbursed for our services on an hourly basis for the actual time expended. Direct project expenses, such as printing, supplies, reproduction, etc., will be billed at cost, and mileage will be billed at the current allowable IRS rate for business miles. Invoices are submitted monthly for work performed during the previous month. Payment is due within 30 days. It is understood that if the scope or extent of work changes or additional services are requested, the cost will be adjusted accordingly. Before any out-of-scope or additional service work is initiated; however, we will submit a budget for the new work and will not begin work until we receive authorization from you. Acceptance/Notice to Proceed A signed copy of this proposal or a separate letter of authorization either mailed or emailed to our office, will serve as our notice to proceed. We sincerely appreciate your consideration of this proposal and look forward to working with you on this project. Please feel free to contact us if you have any questions or need additional information. Sincerely, SRF CONSULTING GROUP, INC. Ken Helvey Principal KH/cjw APPROVED: (Signature) Name Title Date This cost proposal is valid for a period of 90 days. SRF reserves the right to adjust its cost estimate after 90 days from the date of this proposal. Third Quarter Department Updates A Report to the Prior Lake City Council Nov. 1, 2021 Police Department CHIEF STEVE FRAZER 30 SWORN OFFICERS 7 CIVILLIAN STAFF PRIORLAKEMN.GOV/POLICE Retirement Officer Darcy White retired Nov. 1, 2021, after 28 years of service in law enforcement, and 21 years with the Prior Lake Police Department. Staffing STAFFING PART ONE CRIMES THEFT Down 17% YTD versus 3-year average AGGRAVATED ASSAULT Up 10% YTD versus 3-year average CRIMINAL SEXUAL CONDUCT Down 12% YTD versus 3-year averageYEAR TO DATE | OCT. 22, 2021 STATISTICS 22 TOP THREE 119 22 508 Criminal Sexual Conduct +400% in 3rd quarter vs. 3rd quarter 2019 STATISTICS Total Calls for Service +22% vs. YTD 2020 Trending throughout the pandemic YEAR TO DATE | OCT. 22, 2021 OVERDOSE INCIDENTS TRENDS UP 55% SINCE 2019 Winter Parking Ban Citations YTD 2021 = 278 2020 Total = 319 2019 Total = 418 AHEAD Fire Department CHIEF RICK STEINHAUS 1 ASSISTANT CHIEF 37 PAID ON-CALL FIREFIGHTERS PRIORLAKEMN.GOV/FIRE Assistant Fire Chief On Oct. 4, Jim Ruzicka was sworn in as Prior Lake’s first-ever full-time assistant fire chief. Ruzicka is a 24-year veteran of the Prior Lake Fire Department. STAFFING CALLS FOR SERVICE MEDICAL Up 34% versus 2020 YTD MOTOR VEHICLE ACCIDENT Up 22% versus 2020 YTD FIRE Up 55% versus 2020 YTDYEAR TO DATE | SEPTEMBER 2021 STATISTICS 22 TOP THREE 82 62 117 TOTAL CALLS FOR SERVICE TRENDS YEAR TO DATE | SEPTEMBER 2021 Carbon Monoxide Alarms YTD 2021 = 11 2020 Total = 27 2019 Total = 5 AHEAD Thank You