Loading...
HomeMy WebLinkAbout_09 08 2020 City Council Agenda Packet City of Prior Lake9/8 Council Workshop 2021 BudgetAttachment 1 Budgeted FundsCapital Revolving Revolving Park Permanent Facilities Total TotalGeneral Debt Cable Park Equipment Equipment Improvement Management EDA Governmental Water Sewer Water Quality Enterprise BudgetedFund Service Fund Fund Fund Fund Revolving Fund Fund Funds Fund Fund Fund Funds FundsRevenues / SourcesProperty TaxesLevy - Tax Capacity Operating 9,237,218$ -$ -$ 650,000$ 375,000$ 120,000$ 80,000$ 349,750$ 10,811,968$ -$ -$ -$ -$ 10,811,968$ Levy - Tax Capacity Debt Service 3,121,498$ 185,000 3,306,498$ 3,306,498$ Levy - Market Value 253,575 - - - - - - - 253,575 - - - - 253,575 Levy - - - - - - - - - - - - - - - Special Assessments - 446,370 - - - - 173,000 - - 619,370 - - - - 619,370 Licenses & Permits 795,552 - - - - - - - - 795,552 - - - - 795,552 Fines & Forfeits - - - - - - - - - - - - - - - Intergovernmental 2,030,735 - - - - - - - - 2,030,735 - - - - 2,030,735 Charges for Services 1,800,171 - 28,000 455,000 - - - - 8,450 2,291,621 4,600,174 4,505,442 1,214,092 10,319,708 12,611,329 Other Revenues 240,800 46,406 - 22,700 9,600 10,500 7,800 5,800 5,300 348,906 54,600 19,800 14,500 88,900 437,806 Bond Proceeds - - - - 555,000 - 163,200 - - 718,200 - - - - 718,200 Lease Proceeds - - - - - - - - - - - - - - - Transfers From Other FundsGeneral Fund - 253,575 - - - - - - - 253,575 - - - - 253,575 Debt Service Funds - 75,000 - - - - - - - 75,000 - - - - 75,000 Water Fund 523,000 565,700 - - 145,000 - - 117,000 - 1,350,700 - - - - 1,350,700 Sewer Fund - - - - 145,000 - - 13,000 - 158,000 - - - - 158,000 Water Quality Fund - - - - 20,000 - - - - 20,000 - - - - 20,000 Trunk Reserve Fund - - - - - - - - - - - - - - - TIF Fund - 25,500 - - - - - - - 25,500 - - - - 25,500 PIR Fund - 287,150 - - - - - - - 287,150 - - - - 287,150 Facilities Management Fund - - - - - - - - - - - - - - - Capital Park Fund - - - - - - - - - - - - - - - Police Forfeiture Fund - - - - - - - - - - - - - - - Total Revenues / Sources 14,881,051$ 4,821,199$ 28,000$ 477,700$ 1,709,600$ 385,500$ 464,000$ 215,800$ 363,500$ 23,346,350$ 4,654,774$ 4,525,242$ 1,228,592$ 10,408,608$ 33,754,958$ Expenditures / UsesEmployee Services 10,646,340$ -$ -$ -$ -$ -$ -$ -$ 135,422$ 10,781,762$ 825,245$ 807,538$ 366,593$ 1,999,376$ 12,781,138$ Current Expenditures 4,106,636 - - - - - - - 388,750 4,495,386 1,312,800 1,970,307 255,800 3,538,907 8,034,293 Capital Outlay 9,500 - - 1,781,000 595,000 - - 500 2,386,000 150,750 90,250 - 241,000 2,627,000 Capital Improvements - - - 400,000$ - - - 447,600 - 847,600 1,918,000 609,500 370,000 2,897,500 3,745,100 Subtotal 14,762,476$ -$ -$ 400,000$ 1,781,000$ 595,000$ -$ 447,600$ 524,672$ 18,510,748$ 4,206,795$ 3,477,595$ 992,393$ 8,676,783$ 27,187,531$ Transfers To Other FundsGeneral Fund -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 208,000$ 208,000$ 107,000$ 523,000$ 523,000$ Treatment Plant (Debt) - - - - - - - - - - 565,700 - - 565,700 565,700 Equipment Fund - - - - - - - - - - 145,000 145,000 20,000 310,000 310,000 Park Equipment Fund - - - - - - - - - - - - - - - Debt Service Funds 253,575 75,000 - - - - 287,150 - - 615,725 - - - - 615,725 PIR Fund - - - - - - - - - - - - - - - Facilities Management Fund - - - - - - - - - - 117,000 13,000 - 130,000 130,000 EDA Fund - - - - - - - - - - - - - - - Severance Compensation Fund - - - - - - - - - - - - - - - Contingency - - - - - - - - - - - - - - - Debt Service - 5,243,627 - - - - - - - 5,243,627 169,650 169,650 - 339,300 5,582,927 Subtotal 253,575$ 5,318,627$ -$ -$ -$ -$ 287,150$ -$ -$ 5,859,352$ 1,205,350$ 535,650$ 127,000$ 1,868,000$ 7,727,352$ Total Expenditures / Uses 15,016,051$ 5,318,627$ -$ 400,000$ 1,781,000$ 595,000$ 287,150$ 447,600$ 524,672$ 24,370,100$ 5,412,145$ 4,013,245$ 1,119,393$ 10,544,783$ 34,914,883$ Change in Fund Balance (135,000)$ (497,428)$ 28,000$ 77,700$ (71,400)$ (209,500)$ 176,850$ (231,800)$ (161,172)$ (1,023,750)$ (757,371)$ 511,997$ 109,199$ (136,175)$ (1,159,925)$ 2021 Property Tax Levy Comparison9/8 Council WorkshopAttachment 1Change 20 - 21Property Taxes 2020 2021 Amount PercentLevy - Tax Capacity General Fund - Operating 8,711,099$ 9,237,218$ 526,119$ 6.04% Debt Service 3,319,231 3,306,498 (12,733) -0.38% Revolving Equipment Fund 625,000 650,000 25,000 4.00% Revolving Park Equipment Fund 319,000 375,000 56,000 17.55%Permanent Improvement Revolving Fund 80,000 120,000 40,000 50.00% Facilities Management Fund 30,000 80,000 50,000 166.67%Levy - Economic Dev Authority 274,750 349,750 75,000 27.30%13,359,080 14,118,466 759,386 5.68%Levy - Market Value - General Fund 242,057 253,575 11,518 4.76%Total Levy 13,601,137$ 14,372,041$ 770,904$ 5.67%2021 Budget Expenditure Comparisons (2020 Original Budgets)Capital Revolving Revolving Park Permanent Facilities Total TotalGeneral Debt Service Cable Park EquipmentEquipmentImprovement Management EDAGovernmental Water Sewer Water Quality Enterprise BudgetedFund Funds Fund Fund Fund Fund Revolving Fund Fund Funds Fund Fund Fund Funds Funds2021 Total Expenditures / Uses 15,016,051$ 5,318,627$ -$ 400,000$ 1,781,000$ 595,000$ 287,150$ 447,600$ 524,672$ 24,370,100$ 5,412,145$ 4,013,245$ 1,119,393$ 10,544,783$ 34,914,883$ 2020 Total Expenditures / Uses 14,656,748$ 5,432,317$ 9,200$ -$ 1,200,000$ 346,000$ 979,933$ 114,000$ 453,135$ 23,191,333$ 3,401,315$ 3,465,196$ 819,692$ 7,686,203$ 30,877,536$ Change 2020 to 2021 ($) 359,303$ (113,690)$ (9,200)$ 400,000$ 581,000$ 249,000$ (692,783)$ 333,600$ 71,537$ 1,178,767$ 2,010,830$ 548,049$ 299,701$ 2,858,580$ 4,037,347$ Change 2020 to 2021 (%) 2.45% -2.09% -100.00% n/a 48.42% 71.97% n/a 292.63% 15.79% 5.08% 59.12% 15.82% 36.56% 37.19% 13.08%2021 Budget Expenditure Comparisons (2020 Amended Budgets)Capital Revolving Revolving Park Permanent Facilities Total TotalGeneral Debt Service Cable Park EquipmentEquipmentImprovement Management EDAGovernmental Water Sewer Water Quality Enterprise BudgetedFund Funds Fund Fund Fund Fund Revolving Fund Fund Funds Fund Fund Fund Funds Funds2021 Total Expenditures / Uses 15,016,051$ 5,318,627$ -$ 400,000$ 1,781,000$ 595,000$ 287,150$ 447,600$ 524,672$ 24,370,100$ 5,412,145$ 4,013,245$ 1,119,393$ 10,544,783$ 34,914,883$ 2020 Total Expenditures / Uses 14,780,210$ 5,432,317$ 9,200$ -$ 1,460,183$ 542,000$ 979,933$ 234,000$ 453,135$ 23,890,978$ 3,427,595$ 3,491,476$ 819,692$ 7,738,763$ 31,629,741$ Change 2020 to 2021 ($) 235,841$ (113,690)$ (9,200)$ 400,000$ 320,817$ 53,000$ (692,783)$ 213,600$ 71,537$ 479,122$ 1,984,550$ 521,769$ 299,701$ 2,806,020$ 3,285,142$ Change 2020 to 2021 (%) 1.60% -2.09% -100.00% n/a 21.97% 9.78% -70.70% 91.28% 15.79% 2.01% 57.90% 14.94% 36.56% 36.26% 10.39% CHECK REGISTER FOR CITY OF PRIOR LAKE 1/9Page: 08/28/2020 10:17 AM User: Janet DB: Prior Lake CHECK DATE FROM 08/08/2020 - 08/28/2020 AmountDescriptionVendor NameVendorCheckBankCheck Date Bank 1 General Bank 1,023.02 2020 Dental ClaimsDELTA DENTAL000272136245(E)108/10/2020 71,471.04 Aug 2020 Health Insurance PremiumsMEDICA000133256246(E)108/10/2020 5,562.48 2020 HRA Claims 77,033.52 651.90 Jul 2020 Merchant Card FeesTRANSFIRST000206936247(E)108/10/2020 179.35 Wash bay power washer couplers BLUE TARP FINANCIAL INC000025426248(A)108/14/2020 215.50 Recharge Fire ExtinguishersCENTRAL FIRE PROTECTION000033006249(A)108/14/2020 35.00 Recharge Fire Extinguisher 250.50 240.00 Dell Docking StationCOMPUTER INTEGRATION TECH000037606250(A)108/14/2020 240.00 Dell Docking Station 34.00 Microsoft Surface Cover 3,842.00 IT Support 4,356.00 7,890.00 Aug 2020 Facility CleaningCOVERALL000275716251(A)108/14/2020 1,104.00 Wear RingsELECTRIC PUMP000231206252(A)108/14/2020 757.82 Intrinsic Safety Barrier 1,861.82 48.26 New squad numbers GRAFIX SHOPPE000076156253(A)108/14/2020 950.00 7102 and 7103 squad decals and install 126.26 Staff car numbers 1,124.52 15,343.32 Water Treatment ChemicalsHAWKINS INC000083126254(A)108/14/2020 16.38 CalendarINNOVATIVE OFFICE SOLUTIONS LLC000271496255(A)108/14/2020 248.61 Hand Sanitizer Stand 150.34 Misc Office Supplies 415.33 132.39 503 Hydraulic oilKATH FUEL OIL SERVICE000024106256(A)108/14/2020 528.15 Repair PartsMTI DISTRIBUTING INC000139516257(A)108/14/2020 566.49 537 Folding Windshield 1,094.64 203.83 Jul 2020 Repair PartsO'REILLY AUTO PARTS000150886258(A)108/14/2020 59.01 RockPENTAGON MATERIALS INC000274266259(A)108/14/2020 223.13 Rock 282.14 591.06 756 Front tires ROYAL TIRE INC000187326260(A)108/14/2020 1,805.00 CO/NO2 Stand Alone MonitorTOXALERT INC000206686261(A)108/14/2020 1,442.04 SandWM MUELLER & SONS INC000236456262(A)108/14/2020 CHECK REGISTER FOR CITY OF PRIOR LAKE 2/9Page: 08/28/2020 10:17 AM User: Janet DB: Prior Lake CHECK DATE FROM 08/08/2020 - 08/28/2020 AmountDescriptionVendor NameVendorCheckBankCheck Date 578.16 Sand 403.68 Sand 2,423.88 83.63 399 Front floor mats WOLF MOTOR CO INC000236756263(A)108/14/2020 292.96 540 New grille 376.59 360.00 Jul 2020 HRA Admin FeeMEDICA000133256264(E)108/13/2020 25.00 2020 Special Fuel Dealer LicenseMN DEPT OF REVENUE000136126265(E)108/13/2020 275.00 2020 Dental ClaimsDELTA DENTAL000272136266(E)108/18/2020 668.05 2020 Dental Claims 943.05 2.50 Jul 2020 Transaction FeesPOINT & PAY000276216267(E)108/18/2020 880.00 Tow 2011 GMC Sierra #150245ALLEN'S SERVICE INC000013606268(A)108/20/2020 239.49 519 Tie RodBOYER FORD TRUCKS INC000027106269(A)108/20/2020 125.00 Safety Boots 2020CHRISTOPHER ZWEBER000269706270(A)108/20/2020 1,125.00 Sep 2020 CIT Managed BackupCOMPUTER INTEGRATION TECH000037606271(A)108/20/2020 1,762.50 Sep 2020 Managed Services 1,660.00 Aug 2020 Office 365 4,547.50 3.43 HRA Returned Check ERIC WHITMER000235596272(A)108/20/2020 18.14 Cable TiesFASTENAL COMPANY000061406273(A)108/20/2020 121.03 Duggan - Misc Uniform GALLS LLC000070756274(A)108/20/2020 792.47 Duggan - Misc Uniform 913.50 94.29 Misc Office SuppliesINNOVATIVE OFFICE SOLUTIONS LLC000271496275(A)108/20/2020 116.45 Toner 44.00 Webcam 254.74 11.47 Latex GlovesNETWORK SERVICES COMPANY000143816276(A)108/20/2020 3,272.00 CO/NO2 Stand Alone MonitorTOXALERT INC000206686277(A)108/20/2020 5,313.00 Remote Nitrogen Dioxide Sensor 8,585.00 401.07 SandWM MUELLER & SONS INC000236456278(A)108/20/2020 217.50 Sand 618.57 328.00 Jul 2020 HSA Admin FeesALERUS000013756279(E)108/26/2020 118.78 Fuel FilterBOYER FORD TRUCKS INC000027106280(A)108/28/2020 152.91 Watson - Adobe Acrobat Pro RenewalCOMPUTER INTEGRATION TECH000037606281(A)108/28/2020 1,632.00 IT Support 1,784.91 CHECK REGISTER FOR CITY OF PRIOR LAKE 3/9Page: 08/28/2020 10:17 AM User: Janet DB: Prior Lake CHECK DATE FROM 08/08/2020 - 08/28/2020 AmountDescriptionVendor NameVendorCheckBankCheck Date 46.88 Misc Office SuppliesINNOVATIVE OFFICE SOLUTIONS LLC000271496282(A)108/28/2020 348.11 Toner 394.99 120.00 Adderley - SCBA Exam, Fit TestMED-COMPASS INC000133066283(A)108/28/2020 625.19 Embroidered Clothing Com Dev, Eng, RecNORTH AMERICAN SAFETY000145746284(A)108/28/2020 390.63 SandWM MUELLER & SONS INC000236456285(A)108/28/2020 6,684.00 Development Plan ReviewWSB & ASSOCIATES INC000237806286(A)108/28/2020 14,568.00 TRN20-000001 Fish Pt Road Eng Svcs 972.00 Carriage Hills Roundabout Lighting 2,377.50 14756 Cove Ave SE EAW 366.00 Comprehensive Parks Master Plan 2,852.00 TH 13/Five Hawks Emergency Watermain Rep 27,819.50 2,959.07 2020 HRA ClaimsMEDICA000133256287(E)108/17/2020 19,112.67 Aug 2020 Electric BillsMN VALLEY ELECTRIC000137386288(E)108/17/2020 1,037.90 Aug 2020 Electric BillsSHAKOPEE PUBLIC UTILITIES000193886289(E)108/17/2020 66.00 Jul 2020 COBRA Admin FeeALERUS000013756290(E)108/20/2020 375.92 Jul 2020 Fuel TaxMN DEPT OF REVENUE000136126291(E)108/20/2020 1,163.00 Jul 2020 Sales Tax 1,538.92 2,249.46 Aug 2020 Phone BillsNUVERA000193046292(E)108/20/2020 1,479.79 2020 Dental ClaimsDELTA DENTAL000272136293(E)108/24/2020 68.90 Aug 2020 Admin FeesFURTHER000135046294(E)108/24/2020 4,447.46 2020 HRA ClaimsMEDICA000133256295(E)108/24/2020 70.26 Jul 2020 COBRA Admin FeesDELTA DENTAL000272136296(E)108/21/2020 1,018.77 Jul 2020 Admin Fees 1,089.03 128.75 756 Front end alignment ACCELERATED AUTO00026868106574108/14/2020 572.50 Mtce Center Generator RepairADVANCED POWER SERVICE INC00027572106575108/14/2020 464.50 Minitor V BatteryANCOM COMMUNICATIONS INC00001654106576108/14/2020 4,310.00 BMP MaintenanceAPPLIED ECOLOGICAL SERVICES00001759106577108/14/2020 4,800.00 Hydrant PaintingB&B COMMERCIAL COATING LLC00027672106578108/14/2020 V547.95 Jul 2020 Mtce Center RefuseBUCKINGHAM COMPANIES00002919106579108/14/2020 V133.31 Aug 2020 Ponds Park Refuse V100.18 Aug 2020 Ryan Park Refuse V57.00 Aug 2020 Sand Point Beach Refuse V312.21 Jul 2020 Mtce Center Refuse V(113.50)Aug 2020 City Hall Refuse V(40.64)Aug 2020 FS #1 Refuse V(20.69)Aug 2020 FS #2 Refuse V(34.25)Aug 2020 Library Refuse V(16.40)Aug 2020 Mtce Center Refuse 925.17 1,500.00 Meter #70355166CLEAN & CLEAR INCREF WA MTR106580108/14/2020 1,200.00 Tree Removal - 3361 Glynwater Trail COLLINS TREE CARE00003670106581108/14/2020 703.50 Jul 2020 Carpet CleaningCOMMERCIAL STEAM TEAM00003725106582108/14/2020 3,749.90 Jul 2020 UB BillingCSG SYSTEMS INC00027506106583108/14/2020 16.58 503 Engine parts CUMMINS NPOWER 00026958106584108/14/2020 5,303.20 Tire MachineDELEGARD TOOL CO00004333106585108/14/2020 CHECK REGISTER FOR CITY OF PRIOR LAKE 4/9Page: 08/28/2020 10:17 AM User: Janet DB: Prior Lake CHECK DATE FROM 08/08/2020 - 08/28/2020 AmountDescriptionVendor NameVendorCheckBankCheck Date 8,134.00 Wheel Balancer 2,075.16 Repair Parts 15,512.36 250.67 DisposalDEM-CON LANDFILL LLC00004360106586108/14/2020 33.25 Tax Exempt Plates - 2016 Ford #42195DRIVER & VEHICLE SERVICES00004610106587108/14/2020 1,755.50 Street Sign BlanksEARL F ANDERSEN INC00005175106588108/14/2020 8,645.84 Ladder 9280 MaintenanceEMERGENCY APPARATUS MAINT00005475106589108/14/2020 397.62 Sailboat AwardsEXECUTIVE OCEAN00005947106590108/14/2020 189.78 Memorial Plaque - Maatta 587.40 4,593.60 Meter PartsFERGUSON WATERWORKS #251600006231106591108/14/2020 2,823.48 Water Meter Parts 4,919.20 Water Meters, MIU's 12,336.28 1,752.00 Squad tires GOODYEAR COMMERCIAL TIRE00007510106592108/14/2020 3,445.83 Club Prior Carpet ReplacementHINZE FLOOR COVERING00027543106593108/14/2020 890.00 Summit Ridge Park Concept & Stakeholder HOISINGTON KOEGLER GROUP INC00008730106594108/14/2020 3,560.00 Summit Ridge Park Concept & Stakeholder 1,780.00 Summit Ridge Park Concept & Stakeholder 9,500.00 Pickleball Study 13,300.00 Pickleball Court Design & Const Admin 29,030.00 100.00 Water Efficiency RebateJEFF KOHOUTREFUND-MSC106595108/14/2020 1,134.00 SlimeTastic ClassKIDCREATE STUDIO00027412106596108/14/2020 730.00 Unit Heater MotorsKLAMM MECHANICAL CONTRACTORS INC00026904106597108/14/2020 385.00 FS #1 Combuster Replacement 6,270.00 Cooling Start-Up Preventative Mtce 7,385.00 2,400.00 Cable Franchise Fee Compliance 2016 - 20LEWIS & ASSOCIATES00012619106598108/14/2020 456.15 Spare snow plow repair LITTLE FALLS MACHINE INC00012705106599108/14/2020 532.28 Spare snow plow repair (135.00)Return Parts 853.43 28.45 SuppliesMENARDS LUMBER CO00013318106600108/14/2020 207.15 Misc Supplies 235.60 46,742.85 Jul 2020 SAC ChargesMETROPOLITAN COUNCIL-SAC00013406106601108/14/2020 260.00 7132 Front windshield replacement MILESTONE AUTO INC00013510106602108/14/2020 600.00 Foaming Hand SoapMINNCOR INDUSTRIES00013543106603108/14/2020 24.51 526 Mower deck bladeMN EQUIPMENT00026912106604108/14/2020 594.40 Plywood, NailsMONNENS SUPPLY INC00013909106605108/14/2020 692.19 Jul 2020 Rrepair PartsNAPA AUTO PARTS00014060106606108/14/2020 1,365.00 Utility StudyNORTHLAND SECURITIES INC00014775106607108/14/2020 175.72 Painting SuppliesPAINTERS GEAR INC00027108106608108/14/2020 CHECK REGISTER FOR CITY OF PRIOR LAKE 5/9Page: 08/28/2020 10:17 AM User: Janet DB: Prior Lake CHECK DATE FROM 08/08/2020 - 08/28/2020 AmountDescriptionVendor NameVendorCheckBankCheck Date 463.13 277 Line striper parts 102.50 277 Line sprayer parts 741.35 2,500.00 20-0098 5004 Trillium Cove NEPULTE HOMES OF MINNESOTAMISC-CD106609108/14/2020 2,500.00 20-0276 14286 Meadowlawn Trail NE 2,500.00 20-0122 14370 Ferndale Avenue NE 2,500.00 19-2475 14236 Meadowlawn Trail NE 2,500.00 20-0217 4961 Trillium Cove NE 12,500.00 5.87 UB REFUND #3-08987-00PULTE HOMES OF MINNESOTAREFUND-UB106610108/14/2020 2,500.00 19-0516 14190 Fisher Avenue NEQUEBLO CONSTRUCTIONMISC-CD106611108/14/2020 845.50 Turf Care SuppliesRAMY TURF PRODUCTS00018173106612108/14/2020 84.00 MulchROCK HARD LANDSCAPE SUPPLY00018571106613108/14/2020 149.98 CanopySAM'S CLUB00019036106614108/14/2020 405.60 Defibrillator BatteriesSOS TECHNOLOGIES00027273106615108/14/2020 332.75 Jul 2020 Legal NoticesSOUTHWEST NEWSPAPERS00019676106616108/14/2020 29.57 Chain saw repair TIM'S SMALL ENGINE REPAIR INC00020510106617108/14/2020 34.61 Chain saw repair 64.18 185.00 E Coli TestingUC LABORATORY00021235106618108/14/2020 2,493.75 Tower St WT survey - Split T-Mo+SprintULTEIG00027856106619108/14/2020 279.35 Motor Oil, Fuel FiltersUNITED RENTALS INC00023195106620108/14/2020 304.36 Fuel Filter Motor Oil 583.71 691.30 Electrical SuppliesVIKING ELECTRIC SUPPLY00022630106621108/14/2020 26.32 Electrical Supplies 717.62 9.15 CR 21 Street LightsXCEL ENERGY00014720106622108/14/2020 9.38 CR 21 Street Lighting 12.42 Park Street Lighting 31.17 CR 21 Street Lighting 62.12 147.97 Shovels, TowelsZACKS INCORPORATED00026100106623108/14/2020 2,399.60 Sneeze GuardsUS BANK00002105106624108/20/2020 (25.77)Credit - Jul 2020 Go To Meeting License (25.77)Go To Meeting License (375.00)Refund - Ritter - DMT-G Basic (850.35)Cancelled - Hotel - B Johnson Training (300.00)Cancelled - Evidence Software Training (100.00)Refund Deposit - 9/4/2020 Field Trip (71.99)Return Camo Cargo Pants 650.72 50.00 Bean Bag 1st PlaceANDERS SCHMIDTREFUND-REC106625108/20/2020 111.73 CoffeeARAMARK REFRESHMENT SERVICES00001772106626108/20/2020 760.00 Squad CameraAXON ENTERPRISE INC00027347106627108/20/2020 CHECK REGISTER FOR CITY OF PRIOR LAKE 6/9Page: 08/28/2020 10:17 AM User: Janet DB: Prior Lake CHECK DATE FROM 08/08/2020 - 08/28/2020 AmountDescriptionVendor NameVendorCheckBankCheck Date 547.95 Jul 2020 Mtce Center RefuseBUCKINGHAM COMPANIES00002919106628108/20/2020 133.31 Aug 2020 Ponds Park Refuse 100.18 Aug 2020 Ryan Park Refuse 57.00 Aug 2020 Sand Point Beach Refuse 312.21 Jul 2020 Mtce Center Refuse 600.20 Aug 2020 Mtce Center Refuse 1,750.85 312.55 Aug 2020 Phone BillsCENTURY LINK00021220106629108/20/2020 1,400.00 Tree Removal - 3324 Sycamore TrailCOLLINS TREE CARE00003670106630108/20/2020 3,786.48 452 Refurbishment COMMERCIAL TRUCK COLLISION00003727106631108/20/2020 50.72 Heat Gun KitDELEGARD TOOL CO00004333106632108/20/2020 28,635.88 Library Carpet ReplacementHINZE FLOOR COVERING00027543106633108/20/2020 25.00 Bean Bag 2nd PlaceJUDITH KLAUSENREFUND-REC106634108/20/2020 304.00 Big & Messy Week ProgramKIDCREATE STUDIO00027412106635108/20/2020 59,430.00 3rd Qtr 2020 Property & CasualtyLEAGUE MN CITIES INS TRUS00012435106636108/20/2020 48.00 Staple RefillMETRO SALES INCORPORATED00013386106637108/20/2020 251.50 Dangerous Dog Signs, TagsMN DEPT OF PUBLIC SAFETY00013813106638108/20/2020 2,500.00 17-0337 5308 Candy Cove Trail SEPEBBLE CREEK CUSTOM HOMESMISC-CD106639108/20/2020 6,125.00 5562 Candy Cove - Ref S&W Connection FeePEBBLE CREEK CUSTOM HOMESREFUND-BLG106640108/20/2020 90.00 192 Ford F150 #42778SCOTT COUNTY ATTORNEY00019232106641108/20/2020 100.00 2011 Buick LaCrosse #295353 545.00 2007 Nissan Murano #652082 964.65 2011 GMC Sierra #150245 57.00 Cash ICR #19015137 1,756.65 50.00 2011 Buick LaCrosse #295353STATE TREASURER00019796106642108/20/2020 272.50 2007 Nissan Murano #652082 482.32 2011 GMC Sierra #150245 28.50 Cash ICR #19015137 833.32 382.50 ID Patches, Ballistic PlateSTREICHERS00019900106643108/20/2020 98.32 DegreaserULINE00021250106644108/20/2020 59.00 5536 Candy Cove - Oak Disease AnalisysUNIVERSITY OF MINNESOTA00021770106645108/20/2020 59.00 5611 Fis Pt Rd - Oak Disease Analisys 118.00 250.00 Armorer CourseUS BANK00002105106646108/20/2020 250.00 Armorer Course - Cassman 10.00 Car Wash 43.58 Food - Training 125.00 Membership Dues 149.96 Instructor BDU Pants 74.98 Instructor Pants 74.98 Instructor Pants 48.00 Training Summit 120.51 Pants Alterations 49.99 Lynda Allen Retirement Cake 13.98 Scanner USB Cable 49.98 Wacipi Conference Room Webcam 170.91 Latex Gloves 37.95 Face Shields CHECK REGISTER FOR CITY OF PRIOR LAKE 7/9Page: 08/28/2020 10:17 AM User: Janet DB: Prior Lake CHECK DATE FROM 08/08/2020 - 08/28/2020 AmountDescriptionVendor NameVendorCheckBankCheck Date 199.00 Alcohol Wipes 308.50 Face Shields 311.92 Hand Sanitizer 336.00 Flair Pens, Social Distance Decals 231.16 Facemasks 162.84 Face Mask Window Decals 193.15 Front Desk - Adobe Professional 264.00 New Employee Background Screening 167.92 Logo Facemasks 37.20 Cookies 152.00 Wedel - Dues 65.00 Coy - CrPR Renewal 14.61 Hand Soap 224.82 Day to Unite Supplies 148.02 Art Camp Chalk 100.00 Bus Tokens 91.96 Coffee 43.31 Misc Supplies 39.98 Canopy Wall 149.98 Event Canopy 4,711.19 923.96 Face MasksUS BANK00002105106647108/20/2020 59.97 Canopy Weights 93.64 Name Plat, Wall Signs 395.00 Drug Test Kits 11.96 Training - Ice & Water 68.00 Scheduling Software 68.00 Scheduling Software 41.04 Logo Table Runners 295.89 Club Prior - Hand Sanitzer 15.44 Face Masks - Club Prior 20.00 Summer Registration Boost 112.98 Boots 1,065.33 Mn Building Code Books 149.25 Mn Accessibility Code Book 61.03 Face Masks 452.50 New Employee Background Screening 30.98 Tableclothes 299.00 Snyder - Virtual Conference 380.83 Dinner - Retirement Gathering 362.93 Nitrile Gloves 992.10 Face Masks 16.67 Fire Boat Gas 0.99 50GB iCloud Storage 47.27 Dept Logo Envelopes 20.00 Mayer - Boiler License 239.76 Sanitizer Spray 228.80 Newspaper Subscription 28.40 Hand Sanitizer Dispensing Pump 469.58 Irrigational Controller 76.77 Bird Tape, Rope, Cleaning Solutions 276.43 Face Masks 181.37 Face Masks 19.99 Vacuum Filters 119.94 Neck Gators 214.54 City Council Workshop 7,840.34 CHECK REGISTER FOR CITY OF PRIOR LAKE 8/9Page: 08/28/2020 10:17 AM User: Janet DB: Prior Lake CHECK DATE FROM 08/08/2020 - 08/28/2020 AmountDescriptionVendor NameVendorCheckBankCheck Date 214.54 Council WorkshopUS BANK00002105106648108/20/2020 25.77 Election Supplies 60.13 COVID-19 Supply Bins 493.88 Dock Bumpers 794.32 110.76 Brass Needle ValveWW GOETSCH ASSOCIATES INC00023795106649108/20/2020 40.00 Refund Tempoary Gambling Permit FeeAGC OF MNREFUND-MSC106650108/28/2020 42,219.38 2020 Crack Sealing (JPA)ASTECH00001925106651108/28/2020 631.30 Repair Well #9 AlarmAUTOMATIC SYSTEMS CO00001975106652108/28/2020 30.00 Peerboom - body Camera User LicenseAXON ENTERPRISE INC00027347106653108/28/2020 290.54 Aug 2020 Mtce Center RefuseBUCKINGHAM COMPANIES00002919106654108/28/2020 1,500.00 Bulk Meter #70318474CEMENT RAISINGREF WA MTR106655108/28/2020 14.25 Tabs - 2008 Dodge #312689 Unit 7112DRIVER & VEHICLE SERVICES00004610106656108/28/2020 3,686.15 450 post pounder and post dies EARL F ANDERSEN INC00005175106657108/28/2020 1,258.71 Wiring for Main St & Kopp PkwyHAYES ELECTRIC INC00008315106658108/28/2020 965.00 Portrait, Landscape PhotographyHEIDI EHALT PHOTOGRAPHY00027862106659108/28/2020 1,103.60 Sports CampsHOPKINS SPORTS CAMPS LLC00027861106660108/28/2020 2,500.00 Custom Challenge CoinITL PATCH COMPANY00009920106661108/28/2020 2,500.00 18-2121 13683 Kensington Avenue NEMI HOMES OF MINNEAPOLIS LLCMISC-CD106662108/28/2020 21,081.00 3rd Qtr 2020 State SurchargeMN DEPT OF HEALTH00013618106663108/28/2020 2,500.00 20-0241 3689 Pershing Street SWONE TEN TEN HOMESMISC-CD106664108/28/2020 18,876.00 Library IrrigationPETERSON COMPANIES INC00027860106665108/28/2020 2,500.00 19-0112 5027 Trillium CovePULTE HOMES OF MINNESOTAMISC-CD106666108/28/2020 2,500.00 19-0206 5051 Trillium Cove 2,500.00 18-1845 5059 Trillium Cove 2,500.00 19-0202 5061 Trillium Cove 2,500.00 19-0163 5063 Trillium Cove 2,500.00 18-0789 5152 Hampton Street 2,500.00 18-0788 5154 Hampton Street 2,500.00 19-0221 Meadowlawn Trail 2,500.00 19-0408 5014 Trilliumn Cove 22,500.00 46.00 Filing Fee - Res 19-18PCSCOTT COUNTY00019212106667108/28/2020 46.00 Filing Fee - Res 20-05PC 46.00 Filing Fee - Res 20-086 46.00 Filing Fee - Res 20-04PC 30.00 NSF Fee - Filing Fees 214.00 52.55 Cash ICR #18016861SCOTT COUNTY ATTORNEY00019232106668108/28/2020 159,740.24 TIF 1st Half 2020SHEPHERD'S PATH00019450106669108/28/2020 3,144.00 Sep 2020 Portable ToiletsSPECIALIZED SANITATION00019703106670108/28/2020 26.27 Cash ICR #18016861STATE TREASURER00019796106671108/28/2020 49.20 Aug 2020 Phone BillT-MOBILE00026962106672108/28/2020 2,430.00 8" PumpUNITED RENTALS INC00023195106673108/28/2020 55.00 Aug 2020 Shredding ServiceVETERAN SHREDDING LLC00027643106674108/28/2020 1.97 CR 21 Street LightsXCEL ENERGY00014720106675108/28/2020 6.67 Park Street Lighting 13.80 CR 21 Street Lighting 2.20 CR 21 Street Lighting 24.64 CHECK REGISTER FOR CITY OF PRIOR LAKE 9/9Page: 08/28/2020 10:17 AM User: Janet DB: Prior Lake CHECK DATE FROM 08/08/2020 - 08/28/2020 AmountDescriptionVendor NameVendorCheckBankCheck Date 1 TOTALS: 785,468.30 Total of 153 Disbursements: 925.17 Less 1 Void Checks: 786,393.47 Total of 154 Checks: City of Prior Lake Treasurers Report July 2020 Fund 7/1/2020 7/31/2020 Fund Type & Name No. Balance Receipts Disbursements Balance Business-Type Funds Water Fund 601 4,819,504.52$ 143,632.86$ 267,869.14$ 4,695,268.24$ Sewer Fund 604 2,295,836.92 81,480.32 269,807.72 2,107,509.52 Water Quality Fund 602 1,674,657.08 17,770.20 68,075.46 1,624,351.82 Total Business-Type Funds 8,789,998.52$ 242,883.38$ 605,752.32$ 8,427,129.58$ Governmental-Type Funds General Fund 101 8,953,992.60$ 2,596,178.11$ 1,420,528.34$ 10,129,642.37$ Special Revenue Funds Cable Franchise Fund 210 72,817.67$ 6,760.28$ 75.11$ 79,502.84$ Capital Park Fund 225 1,792,492.17 4,021.23 4,619.00 1,791,894.40 Police Forfeiture Fund 235 148,843.17 167.89 168.00 148,843.06 EDA Special Revenue 240 483,078.58 1,259.36 15,417.45 468,920.49 Econ Dev Federal Revolving Loan Fund 250 130,471.50 147.34 - 130,618.84 Econ Dev MN Revolving Loan Fund 255 172.56 0.19 - 172.75 Developer Agreement Fund 260 895,556.79 - 11,964.56 883,592.23 Total Special Revenue Funds 3,523,432.44$ 12,356.29$ 32,244.12$ 3,503,544.61$ Capital Project Funds Tax Increment 402 94,958.82$ 106.12$ 75,103.88$ 19,961.06$ TIF #1-3 413 105,478.02 74,169.10 56,575.41 123,071.71 TIF #3-1 414 213,745.93 240.26 990.00 212,996.19 TIF #5-1 416 17,875.97 10.90 8,220.45 9,666.42 TIF #6-1 417 565,942.01 637.98 990.00 565,589.99 TIF #1-4 418 6,532.93 0.93 5,707.13 826.73 TIF #1-5 419 113,252.89 23.94 92,049.74 21,227.09 Revolving Equipment Fund 410 785,704.54 498.06 344,652.97 441,549.63 Revolving Park Equipment Fund 430 1,057,991.61 1,186.32 7,459.67 1,051,718.26 Facilities Management Fund 440 535,783.31 602.67 2,095.67 534,290.31 Permanent Impr Revolving Fund 450 924,719.31 2,592.97 590,277.00 337,035.28 Construction Fund 501 342,280.13 278.66 95,517.40 247,041.39 Trunk Reserve Fund 502 3,555,944.97 46,913.25 405.50 3,602,452.72 Street Oversize Fund 503 1,284,692.98 1,450.75 - 1,286,143.73 Water Storage Fund 505 433,099.79 31,890.97 - 464,990.76 Total Capital Project Funds 10,038,003.21$ 160,602.88$ 1,280,044.82$ 8,918,561.27$ Debt Service Funds 314-351 & 549-573 $ 4,394,616.06 19,797.70$ 1,000.00$ 4,413,413.76$ Agency Fund 801 998,372.50$ 50,000.00$ 37,500.00$ 1,010,872.50$ Total Governmental Type Funds 27,908,416.81$ 2,838,934.98$ 2,771,317.28$ 27,976,034.51$ Internal Service Funds 7xx 483,819.58$ 4,163.63$ -$ 487,983.21$ Total All Funds 37,182,234.91$ 3,085,981.99$ 3,377,069.60$ 36,891,147.30$ Investment Pool & Ratio as of 7/31/2020 99.00% 36,521,177.83$ This report does not reflect financial obligations from contracts, agreements, purchases, services received, etc. TREASURER’S REPORT FUND DESCRIPTIONS General Fund - Represents the resources to support general operating budget expenditures of the City. The year- end fund balance represents dollars that have accumulated over a period of time. The City Council has designated a minimum of 45% of the current operating budget, for working capital to finance city operations. Water Fund - For the collection of water billing utility revenue. This enterprise fund balance is allocated for the operational costs of the Water departments and normally reserved for large capital municipal system expenses. Sewer Fund - For the collection of sewer billing utility revenue. This enterprise fund balance is allocated for the operational costs of the Sewer department and normally reserved for large capital municipal system expenses. Water Quality Fund - An enterprise account funded by the storm water charge that is generated on the bi-monthly water and sewer utility bills. The funds in the account are dedicated to finance water quality improvements including departmental administration, storm water maintenance operations and improvement projects related to water quality. Cable Franchise Fund - Acts as a clearing house for funds received from the cable franchise company as specified by ordinance. Capital Park Fund - Dedicated funds received from developers in accordance with the City’s Park Dedication requirement when land is platted. Funds are collected for the purpose of developing the City’s neighborhood park and trail system. These dollars are programmed throughout the course of the City’s Capital Improvement Program. Police Forfeiture Fund – Special revenue fund created to track criminal and DWI forfeiture revenues and expenditures. ED Special Revenue – Reserved and expended at the direction of the Prior Lake Economic Development Authority for specific economic development activity as allowed by MN Statute. The purpose is to provide economic incentives for new business expansion within the community. ED Fed/MN Loan Funds - Accounts for the proceeds of economic development grants received either from the federal government or the State of Minnesota to provide seed money for a revolving loan account. This provides economic incentive for new business expansion within the community. DAG Special Revenue Fund - Special revenue fund related to costs the City incurs in connection with a subdivision. Fees are paid to the City by the developer when the Development Contract and Final Plat are approved by City Council. Revenues are used to pay for legal expenses incurred with review and approval of the plat and inspection services on developer installed-utilities for newly approved subdivisions within Prior Lake. Water Revenue Bond Fund – PW Bldg - Debt service fund to pay bonds issued to construct the public works maintenance building. The capital facility charge generated on the utility bill provides the funding for the bond payments which occur semi-annually. Funds are transferred from Sewer and Water Fund. Water Revenue Bond Fund – WT Plant - Debt service fund to pay bonds issued to construct the water treatment plant. Revenue from the utility bills provides the funding for the bond payments which occur semi-annually. Funds are transferred from Sewer and Water Fund. Tax Increment Funds - Represents an accumulation of funds such as bond proceeds and project administration fees charged to companies requesting project write-downs in the form of tax increment financing for new and/or redevelopment. The TIF district property taxes are then deposited in a number of tax increment funds established to track their respective revenue. Revolving Equipment Fund - A regular replacement schedule for equipment needs of the City in excess of $5,000 has been adopted. Periodic fund transfers are appropriated to provide a funding source for the acquisition and purchase of new and replacement vehicles and equipment. Revolving Park Equipment Fund – Consists of funds reserved for the replacement of park equipment. Facilities Management Fund – Established in conjunction with the Facilities Management Plan (FMP). The FMP provides a schedule of major repairs, replacements and upgrades to all of the City facilities. Permanent Improvement Revolving Fund – Consists of funds available for annual street mill and overlay projects with any remaining funds to be used to provide upfront funding for future improvements. Construction Fund - Represent unexpended bond proceeds that are reserved to pay for improvement projects approved by the City Council on an annual basis. These dollars are necessary to complete outstanding construction contracts and related engineering and professional services. Street Oversize Fund - Consists of dedicated revenue generated by fees associated with new development and new construction building permits for the funding of pedestrian related improvements i.e., bikeways, sidewalks, trails plus right of way acquisition along collector streets and occasional collector street links. Trunk Reserve Fund - Consists of dedicated revenue generated from utility connection permits and acreage fees assessed at time of sewer and water installation for the recovering of trunk oversizing costs and central municipal system improvements i.e., wells lift stations, force mains, etc. These dollars are programmed throughout the course of the City’s capital improvement plan. Water Storage Fund - Accounts for the water tower fee that is charged and collected on building permits. This fund balance is 100% reserved for the construction of elevated and ground water storage facilities. Debt Service Funds - Represents prepayments of special assessments, property tax collections and special levies needed to pay the outstanding bonded indebtedness of the City. This fund balance is 100% reserved for the payment of bond principal and interest. Agency Fund - Accounts for the residential building permit deposit that is refunded to the building contractor upon final inspection. This provides financial assurance that the property site will be adequately cleaned up and debris free before an occupancy permit is granted. Severance Compensation Fund – Internal Service Fund established to partially fund the City’s compensated absence liability associated with the accrued vacation and sick leave for employees upon termination as recommended by the State Auditor’s Office. Insurance Fund – Internal Service Fund established to track revenues and expenditures related to insurance funds. City of Prior Lake Treasurers Report July 2020 Fund Type & Name Fund Balance Classification Constraints Business-Type Funds Water Fund Unrestricted Identified on utility bill for this purpose Sewer Fund Unrestricted Identified on utility bill for this purpose Water Quality Fund Unrestricted Identified on utility bill for this purpose Governmental-Type Funds General Fund Unassigned Cash flow, emergencies, one-time opportunities Special Revenue Funds Cable Franchise Fund Assigned for communications Statutory obligation to use for PEG access Capital Park Fund Assigned for capital improvements Contractually obligated; park dedication fees EDA Special Revenue Assigned for development Economic Development Econ Dev Federal Revolving Loan Fund Restricted for economic development Economic Development Econ Dev MN Revolving Loan Fund Restricted for economic development Economic Development Developer Agreement Fund Assigned for development Contractually obligated; Capital Project Funds Tax Increment Restricted for tax increment Contractually obligated by tax increment agreements TIF #1-3 Restricted for tax increment Contractually obligated by tax increment agreements TIF #1-4 Restricted for tax increment Contractually obligated by tax increment agreements TIF #3-1 Restricted for tax increment Contractually obligated by tax increment agreements TIF #4-1 Restricted for tax increment Contractually obligated by tax increment agreements TIF #5-1 Restricted for tax increment Contractually obligated by tax increment agreements TIF #6-1 Restricted for tax increment Contractually obligated by tax increment agreements Revolving Equipment Fund Assigned for capital improvements Identified for equipment replacement Revolving Park Equipment Fund Assigned for capital improvements Identified for park equipment replacement Facilities Management Fund Assigned for capital improvements Identified for funding Facilities Management Plan Permanent Improvement Revolving Fund Assigned for capital improvements Identified for funding street improvement projects Construction Fund Restricted for capital improvements Construction projects in progress Trunk Reserve Fund Assigned for capital improvements Contractually obligated by developer agreements Street Oversize Fund Assigned for capital improvements Contractually obligated by developer agreements Water Storage Fund Assigned for capital improvements Contractually obligated by developer agreements Debt Service Funds Restricted for Debt Service Reserved for contractually obligated debt service Agency Fund N/A Escrows to be reimbursed to depositors Internal Service Funds Unrestricted Identified as payment for severance compensation and insurance 15451 15811 15485 15851 15851 2100 2495 15730 15730 15840 15840 Scott County GIS Ü Proposed Street Name Change Location Map UPPER PRIOR LAKE GD(904) SPRING LAKE GD(912.8) LOWER PRIOR LAKE GD(904) PIKE LAKENE (820.5) MYSTIC LAKENE HAAS LAKENE (907.3) BLIND LAKERD (948.7) ARTIC LAKENE (906.7) MARKLEY LAKERD ( ) HOWARD LAKE NE(957.3) CRYSTAL LAKE NE(943.3) RICE LAKE NE(945) CLEARY LAKE NE CAMPBELL LAKENE (Not Estab.) Scott County GIS SUBJECTPROPERTY PROPOSEDSKUYA DRIVE NW 0 50100150200Feet COUNT Y RO AD 82 H O WA R D L A K E R D N WSKUYA D R IV E STEMMERRIDGERDNWSTEMMERRIDGERDNW