The URL can be used to link to this page

Home My WebLink About_09 24 2024 City Council Agenda PacketCHECK REGISTER FOR CITY OF PRIOR LAKE 1/4Page: 09/13/2024 01:12 PM User: mfonder DB: Prior Lake CHECK DATE FROM 08/31/2024 - 09/13/2024 AmountDescriptionVendor NameVendorCheckCheck Date Bank 1 General Bank 7,362.59 Water Treatment ChemicalsHAWKINS INC0000831211617(A)09/06/2024 44.89 MileageLUKE SCHWARZ0002859211618(A)09/06/2024 171,279.78 Sept 2024 Waste Water ServiceMETROPOLITAN COUNCIL0001340011619(A)09/06/2024 413.60 AsphaltWM MUELLER & SONS INC0002364511620(A)09/06/2024 3,581.40 Generator & Transfer Switch Service ContZIEGLER INC0002650011621(A)09/06/2024 18.45 Aug 2024 Merchant FeesAUTHORIZE.NET0002682111622(E)09/03/2024 6,354.40 Sep 2024 Dental Insurance PremiumsMETLIFE0002853311623(E)09/03/2024 367.47 Sep 2024 Vision PremiumsEYEMED0002791711624(E)09/05/2024 9.22 Sep 2024 COBRA Vision PremiumsEYEMED0002791711625(E)09/06/2024 923.35 Planned Maintenance - MCBARNUM GATE SERVICES INC0000209711626(A)09/13/2024 225.00 Planned Maintenance - WTF 1,148.35 622.60 508 Garbage truck tires BAUER BUILT INC0000214511627(A)09/13/2024 699.05 9221 Transmisson reprogramming BOYER FORD TRUCKS INC0000271011628(A)09/13/2024 3,634.36 Aug 2024 General MattersCAMPBELL KNUTSON PA0002804311629(A)09/13/2024 266.00 Aug 2024 15370 Fish Pt Road 57.00 Aug 2024 CH Water Damage 68.00 Aug 2024 Litigation 4,025.36 458.72 Aug 2024 Misc SuppliesCARLSON HARDWARE COMPANY0000312511630(A)09/13/2024 6,940.00 Sep 2024 CleaningCOVERALL0002757111631(A)09/13/2024 631.32 Jul 2024 UB Billing Postage IncreaseCSG SYSTEMS INC0002750611632(A)09/13/2024 610.00 Unit 7141 Squad supplies EMERGENCY AUTOMOTIVE TECH INC0000548011633(A)09/13/2024 809.68 7102 & 7103 Squad supplies 48.60 Unit 7141 Squad supplies 1,468.28 142.70 Cable TiesFASTENAL COMPANY0000614011634(A)09/13/2024 989.20 Aug 2024 UniformsHUEBSCH0002753611635(A)09/13/2024 150.00 Safety Boots 2024JEREMY COY0000391711636(A)09/13/2024 386.07 Toilet Drop-in KitsKULLY SUPPLY INC0001194011637(A)09/13/2024 65.50 Toilet Drop-in Kits 451.57 107.48 8472 Sweeper bushings MACQUEEN EQUIPMENT INC0001305411638(A)09/13/2024 7,227.00 Rolling Carts 7,334.48 420.00 2024 Security System Monitoring - LibMETRO ALARM CONTRACTORS INC0001335411639(A)09/13/2024 420.00 2024 Fire System Monitoring - WTF 420.00 2024 Security System Monitoring - PD 420.00 2024 Security System Monitoring - MC 375.00 2024 Security System Monitoring - CH 420.00 2024 Security System Monitoring - FS1 420.00 2024 Security System Monitoring - FS1 2,895.00 630.94 Jul 2024 Random Drug TestingMN OCCUPATIONAL HEALTH0002709911640(A)09/13/2024 CHECK REGISTER FOR CITY OF PRIOR LAKE 2/4Page: 09/13/2024 01:12 PM User: mfonder DB: Prior Lake CHECK DATE FROM 08/31/2024 - 09/13/2024 AmountDescriptionVendor NameVendorCheckCheck Date 25.33 8536 Spring MTI DISTRIBUTING INC0001395111641(A)09/13/2024 20.57 8536 Spring 406.92 8504 Blade kit 914.07 8504 Fuel Tank 60.52 8504 Parts Button Head 454.17 Parts 1,881.58 71.44 Paper SuppliesNETWORK SERVICES COMPANY0001438111642(A)09/13/2024 272.53 Paper Supplies 74.48 Paper Supplies 390.70 Paper Supplies 155.76 Paper Supplies 964.91 221.60 Aug 2024 Repair PartsO'REILLY AUTO PARTS0001508811643(A)09/13/2024 400.00 Sep 2024 ROWay AppPERRILL0000650211644(A)09/13/2024 150.00 Safety Boots 2024PHILIP RYAN0002730911645(A)09/13/2024 646.00 Jul 2024 Data & SoftwarePRECISE MOBILE RESOURCE MGMT0001654811646(A)09/13/2024 393.51 Aug 2024 Misc SuppliesPRIOR LAKE HARDWARE0001665811647(A)09/13/2024 2,835.05 Aug 2024 Merchant FeesINVOICE CLOUD0002809111648(E)09/10/2024 447.88 Aug 2024 Merchant Card FeesTRANSFIRST0002069311649(E)09/10/2024 116,151.41 Sep 2024 Health Insurance PremiumsMEDICA0001332511650(E)09/11/2024 450.00 Chalkfest PerformanceANTHONY SAMMIS0002862711477309/06/2024 531.07 Boots - TheisenASPEN MILLS0000189111477409/06/2024 987.89 Medical SuppliesBOUND TREE MEDICAL LLC0000269511477509/06/2024 2,950.00 3665 Jeffers ParkwayCR CUSTOM PAINTING LLC0002745911477609/06/2024 2,300.00 15122 Jeffers Pass 5,250.00 2,500.00 23-2114 3128 Sunflower Way NWDR HORTON INC MINNESOTA DBA: EmeraMISC-CD11477709/06/2024 5,000.00 Hosting of 6 DashboardsEMERGENCY SERVICE PERSPECTIVES0002862911477809/06/2024 646.50 BootsFES, INC0000645511477909/06/2024 2,770.13 Security Awareness Training/PhishER PlusKNOWBE4 INC0002845411478009/06/2024 455.44 Awards - W.Kallberg/W.LarsonLAKER PROMOTIONS0002786811478109/06/2024 450.00 Chalkfest PerformerMELISSA SCHULZ0002862811478209/06/2024 104.16 Sign PartsMENARDS LUMBER CO0001331811478309/06/2024 1,996.46 Graphic T-shirtsNORTHBOUND CREATIVE0001465011478409/06/2024 5,000.00 24-0343 5267 Shore Trl NERAMSEY JASON AMISC-CD11478509/06/2024 185.00 Fire Panel RepairSILENT KNIGHT SECURITY SYSTEMS0002863011478609/06/2024 4,097.87 Irrigation SuppliesSITEONE LANDSCAPE SUPPLY0002771611478709/06/2024 530.88 Aug 2024 Legal NoticesSTAR TRIBUNE0001974411478809/06/2024 4,575.87 Sep 2024 Refuse & RecyclingSUBURBAN WASTE SERVICES0002852411478909/06/2024 88.54 Aug 2024 Misc SuppliesTRACTOR SUPPLY CREDIT PLAN0002066311479009/06/2024 65.00 Sep 2024 Shredding ServiceVETERAN SHREDDING LLC0002764311479109/06/2024 898.40 Blinds - CH OfficeVIKING BLINDS0002725011479209/06/2024 11.52 Electric - 4528 Colorado StXCEL ENERGY0001472011479309/06/2024 4.68 Electric - 4528 Colorado 16.20 91.82 CoffeeARAMARK REFRESHMENT SERVICES0000177211479409/13/2024 328.50 Basemanager Plus ServiceBASELINE INC0002783311479509/13/2024 2,500.00 PD Workload StudyBERRY DUNN0000231311479609/13/2024 11,000.00 PD Workload Study CHECK REGISTER FOR CITY OF PRIOR LAKE 3/4Page: 09/13/2024 01:12 PM User: mfonder DB: Prior Lake CHECK DATE FROM 08/31/2024 - 09/13/2024 AmountDescriptionVendor NameVendorCheckCheck Date 13,500.00 508.57 Medical SuppliesBOUND TREE MEDICAL LLC0000269511479709/13/2024 2,500.00 P22-2221 17620 Jett Circle SEBRANDL ANDERSON HOMESMISC-CD11479809/13/2024 4,587.85 PD ShieldsBROADWAY AWARDS0002854811479909/13/2024 283.20 Community Services Badges 4,871.05 115.59 Aug 2024 Parking Meter HostingCALE AMERICA INC0002763711480009/13/2024 269.00 VFD Reprogramming - Lib ACDAIKIN APPLIED0002863211480109/13/2024 4,744.88 Street SweepingsDEM-CON LANDFILL LLC0000436011480209/13/2024 73.20 Kleen Break BoltsEARL F ANDERSEN INC0000517511480309/13/2024 3,920.00 Outdoor Survival/Adaptation Adventure CaECOELSA LLC0002830511480409/13/2024 134.69 8558 Forklift tune up parts FORKLIFTS OF MN INC0002760911480509/13/2024 21.88 Portfolios/ClipboardsINNOVATIVE OFFICE SOLUTIONS LLC0002714911480609/13/2024 13.44 White Board Cleaner 11.16 Clipboards 6.54 Name Badges 32.52 Binders 75.40 Index Tabs 148.26 Misc Office Supplies - PD 309.20 205.95 Dehumidifier - PDMENARDS LUMBER CO0001331811480709/13/2024 282.64 Rooting Materials 85.97 Elevator Shaft Sheetrock - CH 61.89 Paint Materials - FS1 636.45 35.76 Mower lift arm bushings MIDWEST MACHINERY CO0002811311480809/13/2024 140.00 503 Mower Bearing Assembly 175.76 23,031.00 3rd Qtr 2024 State SurchargeMN DEPT OF HEALTH0001361811480909/13/2024 11,975.04 Portable RadiosMOTOROLA0001393711481009/13/2024 368.22 Kinney ServiceO'CONNELL OIL CO0001505411481109/13/2024 192.00 Tank Rental 560.22 480.00 Chalkfest T-shirtsPAAR SPORTS LLC0001602411481209/13/2024 35.00 PropanePRIOR LAKE RENTAL CENTER0001670011481309/13/2024 144.42 UB refund for account: 10379500SIMBERG PATRICIAREFUND-UB11481409/13/2024 17.97 Cedar - FSSIWEK LUMBER & MILLWORK INC0001953811481509/13/2024 2,416.00 Sep 2024 Portable Toilets - LakefrontSPECIALIZED SANITATION0001970311481609/13/2024 1,729.99 Uniform - ZapataSTREICHERS0001990011481709/13/2024 4,227.99 Uniform - TJ Baker 464.00 Ammo 6,421.98 864.00 Sprinkler Repairs - LibrarySUMMIT FIRE PROTECTION CO0001994911481809/13/2024 48,988.04 Unit #7141TENVOORDE FORD0002775911481909/13/2024 3,900.00 Field Striping Equipment UpgradeTRAQNOLOGY NORTH AMERICA0002844211482009/13/2024 CHECK REGISTER FOR CITY OF PRIOR LAKE 4/4Page: 09/13/2024 01:12 PM User: mfonder DB: Prior Lake CHECK DATE FROM 08/31/2024 - 09/13/2024 AmountDescriptionVendor NameVendorCheckCheck Date 1,900.00 Field Striping Annual Service Plan 5,800.00 341.25 Aug 2024 Clear Law Enforcement PlusWEST PAYMENT CENTER0002342011482109/13/2024 140.00 Fall Invaders - Maint CtrXTREME PEST SOLUTIONS INC0002711611482209/13/2024 140.00 Fall Invaders - WTP 90.00 Fall Invaders - Water Tower #1 65.00 Pest Control - FS2 435.00 1 TOTALS: 512,399.35 Total of 84 Disbursements: 0.00 Less 0 Void Checks: 512,399.35 Total of 84 Checks: ACTIVITY FOR ACTIVITY FOR 2024 2024 MONTH MONTH ORIGINAL AMENDED YTD BALANCE AVAILABLE % BDGT YTD BALANCE VARIANCE GL NUMBER 7/31/2024 8/31/2024 BUDGET BUDGET 8/31/2024 BALANCE USED 8/31/2023 FROM 2023 Fund 101 - GENERAL FUND 41110.00 - MAYOR & COUNCIL 5,688.30 5,532.85 76,427.00 76,427.00 49,160.52 27,266.48 64% 45,045.86 4,114.66 41320.00 - ADMINISTRATION 23,761.70 23,899.87 313,089.00 313,089.00 189,812.29 123,276.71 61% 184,108.21 5,704.08 41330.00 - BOARDS & COMMISSIONS 753.55 753.55 10,550.00 10,550.00 3,121.85 7,428.15 30% 3,444.80 (322.95) 41400.00 - CITY CLERK FUNCTIONS 10,220.56 10,124.35 130,660.00 130,660.00 80,334.60 50,325.40 61% 75,326.93 5,007.67 41410.00 - ELECTIONS 2,185.76 5,492.11 112,832.00 112,832.00 33,600.19 79,231.81 30% 121.00 33,479.19 41520.00 - FINANCE 53,468.62 52,938.58 704,542.00 704,542.00 424,861.73 279,680.27 60% 341,398.22 83,463.51 41820.00 - HUMAN RESOURCES 24,044.34 24,008.00 316,502.00 316,502.00 191,213.81 125,288.19 60% 209,710.08 (18,496.27) 41830.00 - COMMUNICATIONS 10,880.66 10,735.99 143,422.00 143,422.00 86,721.58 56,700.42 60% 81,523.34 5,198.24 41910.00 - COMMUNITY DEVELOPMENT 18,870.25 18,642.35 348,850.00 348,850.00 148,444.17 200,405.83 43% 170,038.37 (21,594.20) 41920.00 - INFORMATION TECHNOLOGY 20,063.08 19,899.50 256,283.00 256,283.00 158,384.65 97,898.35 62% 148,883.19 9,501.46 41940.00 - FACILITIES - CITY HALL 7,926.80 7,242.09 101,693.00 101,693.00 59,703.83 41,989.17 59% 58,373.64 1,330.19 General Government 177,863.62 179,269.24 2,514,850.00 2,514,850.00 1,425,359.22 1,089,490.78 57% 1,317,973.64 107,385.58 42100.00 - POLICE 524,012.49 434,454.34 6,238,856.00 6,238,856.00 3,713,107.17 2,525,748.83 60% 3,448,534.72 264,572.45 42200.00 - FIRE 164,002.37 151,128.08 2,354,931.00 2,354,931.00 1,202,762.97 1,152,168.03 51% 523,269.18 679,493.79 42400.00 - BUILDING INSPECTION 63,008.35 66,735.86 830,502.00 830,502.00 504,825.46 325,676.54 61% 497,470.09 7,355.37 Public Safety 751,023.21 652,318.28 9,424,289.00 9,424,289.00 5,420,695.60 4,003,593.40 58% 4,469,273.99 951,421.61 43050.00 - ENGINEERING 34,309.20 28,720.86 403,645.00 403,645.00 254,056.44 149,588.56 63% 236,987.87 17,068.57 43100.00 - STREET 45,621.80 40,294.61 582,011.00 582,011.00 341,130.07 240,880.93 59% 341,818.40 (688.33) 43400.00 - CENTRAL GARAGE 22,829.98 21,097.59 293,500.00 293,500.00 178,191.34 115,308.66 61% 170,013.40 8,177.94 Public Works 102,760.98 90,113.06 1,279,156.00 1,279,156.00 773,377.85 505,778.15 60% 748,819.67 24,558.18 45100.00 - RECREATION 51,173.77 60,389.65 444,525.00 444,525.00 260,793.07 183,731.93 59% 208,200.00 52,593.07 45200.00 - PARKS 135,016.37 134,181.95 1,253,181.00 1,253,181.00 806,767.67 446,413.33 64% 777,476.80 29,290.87 Culture and Recreation 186,190.14 194,571.60 1,697,706.00 1,697,706.00 1,067,560.74 630,145.26 63% 985,676.80 81,883.94 Fund 101 - GENERAL FUND: TOTAL EXPENDITURES 1,217,837.95 1,116,272.18 14,916,001.00 14,916,001.00 8,686,993.41 6,229,007.59 58%7,521,744.10 1,165,249.31 CITY OF PRIOR LAKE EXPENDITURES - PAYROLL AND BENEFITS AS OF 8/31/2024 (PRELIMINARY & UNAUDITED) ACTIVITY FOR ACTIVITY FOR 2024 2024 MONTH MONTH ORIGINAL AMENDED YTD BALANCE AVAILABLE % BDGT YTD BALANCE VARIANCE GL NUMBER 7/31/2024 8/31/2024 BUDGET BUDGET 8/31/2024 BALANCE USED 8/31/2023 FROM 2023 CITY OF PRIOR LAKE EXPENDITURES - PAYROLL AND BENEFITS AS OF 8/31/2024 (PRELIMINARY & UNAUDITED) Fund 240 - EDA SPECIAL REVENUE FUND TOTAL EXPENDITURES 9,852.75 9,564.08 163,834.00 163,834.00 76,449.96 87,384.04 47%81,784.03 (5,334.07) Fund 601 - WATER FUND 41520.00 - FINANCE 6,784.53 6,717.14 89,344.00 89,344.00 53,954.44 35,389.56 60% 51,262.84 2,691.60 49400.00 - WATER 84,633.15 77,010.97 826,958.00 1,009,063.09 617,422.43 391,640.66 61% 565,587.49 51,834.94 TOTAL EXPENDITURES 91,417.68 83,728.11 916,302.00 1,098,407.09 671,376.87 427,030.22 61%616,850.33 54,526.54 Fund 602 - STORM WATER UTILITY 49420.00 - WATER QUALITY 22,481.93 20,172.06 370,250.00 370,250.00 151,713.44 218,536.56 41% 181,205.12 (29,491.68) TOTAL EXPENDITURES 22,481.93 20,172.06 370,250.00 370,250.00 151,713.44 218,536.56 41%181,205.12 (29,491.68) Fund 604 - SEWER FUND 41520.00 - FINANCE 6,782.86 6,716.27 89,344.00 89,344.00 53,945.92 35,398.08 60% 50,976.13 2,969.79 49450.00 - SEWER 56,268.94 56,867.20 869,044.00 686,938.91 427,529.73 259,409.18 62% 441,810.13 (14,280.40) TOTAL EXPENDITURES 63,051.80 63,583.47 958,388.00 776,282.91 481,475.65 294,807.26 62%492,786.26 (11,310.61) TOTAL EXPENDITURES - ALL FUNDS 1,404,642.11 1,293,319.90 17,324,775.00 17,324,775.00 10,068,009.33 7,256,765.67 58%8,894,369.84 1,173,639.49 Submitted To City of Prior Lake From Swan Companies. Inc. Kelly Cavanaugh 7217 W 128th Street Savage. MN 55378 Application is made for Payment. as shown below. in connection with the Contract. Continuation Sheet is attached. Period Start/End Invoice Amount Total Before Retainage 1. Original Contract Sum 2. Net Changes by Change Orders 3. Contract Sum To Date (Line 1 +/-2) 4. Total Completed 5. Total Retainage a. 2.5% of Completed Work Total Retainage This Invoice 6. Total Earned Less Retainage 7. Less Previous Invoices for Pa ment . Current Pa ment Due 9. Balance to Finish. Including Retainage Change Order Summary Previous Invoices This Invoice Totals Net Changes by Change Order Additions $48.693.27 $0.00 $0.00 $1.048.879.17 $-9.670.93 $1.039.208.24 $1.039.208.24 $0.00 $-25.980.21 $1.039.208.24 $1.013.228.03 25 980.21 $0.00 Deductions $-58.364.20 $0.00 $48.693.27 $-58.364.20 $-9.670.93 Invoice #3, Application for Payment: 3 Project 23046 Prior Lake Ponds Park Project #23046 Invoice Date: 08/05/2024 Payment Due: Distribute To[ ] Owner [ l Architect [ l [ ] Contractor The undersigned Contractor certifies that to the best of the Contractor's knowledge. information and belief the Work covered by this Application for Payment has been completed in accordance with the Contract Documents, that all amounts have been paid by the Contractor for Work for which previous Certificates for Payment were issued and payments received from the Owner. and that current payment shown herein is now due. ............. ,.,,Kelly R Cavanaugh ·i Notary Public . ,, Minnesota •-·-tj.;....�: . ./ u.. Cmssion E..,... Janua111 31, 20 ,.,, .. 1•• "'1 ....... - ., Certificate For Payment In accordance with the Contract Documents. based on on-site observations and the data comprising this application. the Architect certifies to the Owner that to the best of the Architect·s knowledge. information and belief the Work has progressed as indicated. the quality of the Work is in accordance with the Contract Documents. and the Contractor is entitled to payment of the AMOUNT CERTIFIED. Amount Certified: $ 25,980.21 _ Owners Rep By _8.13.24__ A____,�_,_ 8&-w,flA,, Date � This Certificate is not negotiable. Contractor certifies that all insurances and related coverage per contract is current as of this invoice date. w - w - w - - w - w - - w - - w - w - w - w - w w - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - V f - t / t - v > - - t / t - w - t f l - t f t - - t f l - - t f l - - t f t - - y t - ^ f t - v ^ v i - t f ^ w i - t f t - w i - Ij}sS | I !-I l l Is-i t II1 * s 3I*I 0 0 § 1 t f V W o o i n i n o • " u 3 c o r ^ 5 % s s § I & S ? ; 2 W - - t f t - 0 0 0 S S 5 w ^ s ^ ^ % o r ^ < d - o ^ r o c o o o o o m o c n o L n o o o o ' d - u - i r s i i n r s l o o o o o i n i c k o o < T r ~ ; o P > J i n c n r ^ o c n r - ^ r - i o i r i o u - i i n i n i n ' i < I D i r i L n m ' i - . ' o o f M i - i m i n O L n o r s i u s o o m c n r s l O f ^ u o r ^ l L n ^ / t - i n 5 ^ % s ^ 5 S S 3 ^ S S S ^ s a & ^ s s & ^ a f M1- 1 t f s C 3 0 0 0 0 0 0 0 0 0 0 0 O O O O O O O C T O 0 0 ° ° ° 0 V t - W - - t f t - - t f l - • W - - t f l - W - - ( f l - - t f l - W - - t f l - - W - - l f l - - t f r V ^ - U T - l f t - - t f l - - t f l - - W - - k f t - ^ 3 S l r > r i N H I § § § § § § § g g g ! . § s ' g a s s s 5 S ^ - S § w * ^ w - ! § § ! § ! s s s s s s § I I g § § § § § § § § g l l i ^ i ^ i l § § l ^ l ^ l i ^ i § § § Is I I gsm K % K g . g . g g g . s s g 0 0 0 1 0 ^ 1 - ^ t I D 5 g S S S S S § s a s s a s ' s % 3 i B § i § 5 S S 2 ^ 5 S 5 § S 3 ^ " 5 ^ ^ " 3 5 S S S § g g S 3 S S g S • t f t - - t f t - V t - % 0 0 U 3 3 S S s s g s s s a S S $ S § g g % 3 S 5 g g 3 S £ K R S 3 S S S 3 K K S S B ? ; S W S % 5 S g • w - - t f t - w - - w - w - - w ^ - m - v t - ^ » - w . - t f t . - t r t - • w - - W - - W - • w - s s 0 0 0 ° . • t f t 4 f t - 0 0 0 0 a . 0• W - - t f t - - t f l - - t r t - § . § s i s I l g g g ! § I I I I S S S R S S || | S 3 § £ § < r > |5 s ^ . S ^ w - - w - w - 8 § g g § 5 S S S S ; 5 S s ^ % K 1 1 1 1 1 1 1 1 5 g 5 s s S B I s s s s s s ' s s • W ¥ - W ¥ - W - - W - • W - s§3 § . si i % ' s . §Is § § § § § 0 0 0 0 0 0 I D 3 g S S 5 S B § s s s s s s s s g g g g g g s g s § g g g s s s s ? s ? S g S g g S R S 3 . S S % | g g S 5 s J § S K ^ £ K s s 5 £ S S £ K S £ £ 3 ^ S W S S 1 ^ . 0 0 0 0 0 0 0 0 < T O 5 5 . 1 s s s § . K s ^ . S . I B I . g l s i s l l l . a ^ ^ a ^ ^ S a S K 3 % » 3 S 3 ^ S < * S % 0 0 U 3 • - 1? 3 • t A - - t r t - w - 3 S S ^ s i n W - - W - W - ^s i iII . I l l | i | I l l t 3 u i !1 I I ? - z £I I 1 1 1 % I 1 1 a : g g I ^ s l l 0 h^ 5 5 ' " l l l j i K ' < s ^ I I s I I l l ^ I I M f c s § t f s I l l I . i l l I ! ! | ! g l ! : l t E l : * E u : E E E £ ^ S x . i . i . 1 . i . i . i . i l . i l . i ^ • 3 - 5 - 5 - 5 - ^ 5 5 2 : - ^ z - 5 S I ! S 0 i i s? ^ i t o r ~ . 1 ^ ^ 5 : ^ i n m r - 1 F M m t t t T > I t * * * * * * s s s s s s s \ i 1 S S i ^ 1 3 1 s! ^ ^I ( £ S g ^ * 3 * i i § . l l l i 1 1 ! u : uI U 31 1 K1 / 1 .1 1 ^ § u I ? s g i n p I l l I Q § § g ^ I I 0I j I ! 1 ! | 5 U J? i 3 S 3 S 5 3 S I 8£ ^ , t § | s i i n a - i _ 1 0 * * f t * * s s s s s • 5 5 5 - 5 5 *E * * £ s s s ^ 11 1 1 1 ;1 S F 3 * # I I S £ i l l i l l s j l i l l 111 1 1 t t i n u ; C M f M f M * 4 t 4 t 4 t * s s s s s s l i i i l g 5 g ^ I j l ^ 11 1 1 1 0 0 1 0 0 0 I 1 1 J i 1 p §,1 I 5 5 ^ z C D £ t ^ - ^ m S S S s L u 3 s ? : m F Z S ^ i y s I I I ! ! g i l ^ i l s l l l i l £ £ ^ K K 3 § i c o ( T i O r ^ r M m ' a - i n r ^ . o o c n o i - i r ^ i r ' J m m m m m m m m m ^ t ' t * < t 4 t * * * * * * * U 4 ( : » * E E E E E E E E E E E E E E s s s s s s s s s s s s s s IU JI§ • ^ 3 • - ] 3 3 3 3 • - ] • - ] - . 3 - . 3 • - ] 3 3 • - 3 • r ] • ^ • ^ n • ^ I I wii i I - § s I P ^ r f 't & i . i i t E g s i 5 S S i ^ i ^ i m ^ i n m r . o o a . 3 ^ 3 3 S H S 5 3 s s s s s s s s s s a s s s s s s s s s s s s s s s s s s s s s s s s s & £ E s s & 2 2 2 S S S & Q & S S & s s ? i a s s S ! s K s a s s i s R S B S R S s § 5 s s s s s s s s s s a s s s s s s s s s s s a s s S S S S S S S S S S S S S S S S S S S S S S B S 2 2 2 2 2 2 2 2 2 2 2 2 i 5 f f l i 5 i 2 2 2 2 i 2 2 2 2 2 g g § § s s s s s s s s s 0 0 V t - V ^ g g g 0 0 0 V I - t f t V t - g g . g g w - o o o i n O I T I M u 3 t n o o c o c o o o o o i i n i n S S ^ S ? ! S S P 1 & ? i S K ? i 3 S 3 K ? ; - t f r W ^ W - W - W - W - W - W - W - t f l - » » » ~ ~ ^ s s s w 0w - I I § § § . 0 0 0 0 0 0 0 ° . = ' . = ! 0 . 0 0 0 0 0 ^ ^ - W ^ - W - W - W - - W - W - - W - W - W ' - W - W - ^ . § § § § s § § § . § 0 0 0 g § s I g g § § § § § § § § § . g ^ . s s § § s P S S S g g g g g g ' S g ' S ? ^ ' S S g o c o i - i o m c n '° ? ~ : N ? - ? n ; N ' i n - ( N - m ' m - N r ? o u ^ • . i n c o r - i w - w - w - w - w - w - i n G O f - 1 • I • m ' - t f ^ 2 S $ g s g g g g g g g g g g g g • w - § g g ^ Is 3 g g g ^ g g g g g g g g g ? g g § S R S S S g g g g g g K § S 9 g ^ | S i - t 0 ( 0 _ * S i i g s s R g ? ! S S S g g g g g i K • " i - i r ^ i p M i n C M - W - r - 1 I D 0 0 i - 1 - W - - W - • W - • W - . W W ^ • w - w - § § m 1 0 K !s- t f l - § § § § § § § § § . S S g g g g g i S m - ^ m i n i n i n o o ^ g s & s ^ s s s s r - 1 r - i m § 3 S s ? . . I s s% % 2 H | IU J I ^ S £ IIts*II . Ii I ! ! s*I- ^ r . ^ ^ f c r J ^ ^ S u S P l ^ j y l f c l § l g < z < £ < E s IIs*II s ! $ 2ii m Q I ! I&? i l - - i J § 1 s 1>• c iti ~ § - a ^ ' § £ 1 i s ^ I I P l l l l t f t l I ! I I > s ^ • 5 3 m ^ - i i i i l l I IJ I I I I I 1 1 s i i s I I ? t i l l E ' S a I s 5 - 1 f r I I i i ^ i i i t i i i i i i l l ^ l l l l l l l l l * s I I l s i 1 1 i l l t t l i l j l l l j j l 5 S S S 5 s s s s s I s s s s s s s s s s s s s s s s s s s i 2 2 2 , 5 2 8 8 8 8 8 8 8 8 8 8 8 8 8 8 ^ City of Prior Lake Treasurers Report August 2024 Fund 8/1/2024 8/31/2024 Fund Type & Name No.Balance Receipts Disbursements Balance Business-Type Funds Water Fund 601 8,439,683.88$ 851,626.28$ 247,477.55$ 9,043,832.61$ Sewer Fund 604 4,114,029.38 780,906.56 133,571.51 4,761,364.43 Water Quality Fund 602 2,863,493.55 1,468,018.36 66,303.45 4,265,208.46 Total Business-Type Funds 15,417,206.81$ 3,100,551.20$ 447,352.51$ 18,070,405.50$ Governmental-Type Funds General Fund 101 13,106,325.17$ 658,510.34$ 1,854,053.10$ 11,910,782.41$ Special Revenue Funds Cable Franchise Fund 210 108,508.26$ 3,722.83$ -$ 112,231.09$ Capital Park Fund 225 1,725,045.89 6,553.63 5,224.23 1,726,375.29 Police Forfeiture Fund 235 116,902.19 290.59 4,551.48 112,641.30 EDA Special Revenue 240 408,407.98 5,138.53 10,200.60 403,345.91 Econ Dev Federal Revolving Loan Fund 250 142,773.57 369.27 - 143,142.84 Developer Agreement Fund 260 1,066,726.19 10,000.00 14,043.88 1,062,682.31 MN Public Safety 270 546,389.25 1,413.20 - 547,802.45 Affordable Housing Aid 275 54,912.34 - - 54,912.34 Total Special Revenue Funds 4,169,665.67$ 27,488.05$ 34,020.19$ 4,163,133.53$ Capital Project Funds TIF #1-3 413 150,775.53$ 389.97$ -$ 151,165.50$ TIF #5-1 416 12,543.98 32.44 - 12,576.42 TIF #6-1 417 587,513.56 165,446.20 - 752,959.76 TIF #1-5 419 58,805.11 152.10 - 58,957.21 Revolving Equipment Fund 410 654,805.63 121,880.30 47,817.67 728,868.26 Revolving Park Equipment Fund 430 1,102,902.88 32,433.17 55,904.83 1,079,431.22 Facilities Management Fund 440 1,425,475.58 3,536.73 58,058.44 1,370,953.87 Permanent Impr Revolving Fund 450 (586,588.62) 1,629,276.57 18,638.25 1,024,049.70 1 Construction Fund 501 3,966,667.48 9,182.76 416,301.46 3,559,548.78 Trunk Reserve Fund 502 6,705,377.58 27,719.74 - 6,733,097.32 Street Oversize Fund 503 383,875.55 992.87 - 384,868.42 Total Capital Project Funds 14,462,154.26$ 1,991,042.85$ 596,720.65$ 15,856,476.46$ Debt Service Funds 351 & 549- 577 3,765,281.38$ 15,895.55$ -$ 3,781,176.93$ Agency Fund 801 619,125.00$ 32,500.00$ 44,572.00$ 607,053.00$ Total Governmental Type Funds 36,122,551.48$ 2,725,436.79$ 2,529,365.94$ 36,318,622.33$ Internal Service Funds 7xx 813,231.16$ 6,481.26$ -$ 819,712.42$ Total All Funds 52,352,989.45$ 5,832,469.25$ 2,976,718.45$ 55,208,740.25$ Investment Pool & Ratio as of 8/31/2024 102 98.47%54,363,444.84$ This report does not reflect financial obligations from contracts, agreements, purchases, services received, etc. TREASURER’S REPORT FUND DESCRIPTIONS 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. 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. 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. EDA 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. Econ Dev 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. Developer Agreement 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. MN Public Safety Special Revenue Fund - Special revenue fund created for 2023 public safety aid revenue received from the State of MN and eligible expenditures. Affordable Housing Aid Special Revenue Fund - Special revenue fund created for local affordable housing aid received from the State of MN and eligible expenditures. 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. 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. This fund also includes funds transfered in from the Water Storage Fund 505 at the end of 2021 and dedicated to future water storage infrastructure. 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. 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 August 2024 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 MN Public Safety Restricted for eligible Public Safety purchases Contractually obligated Affordable Housing Aid Restricted for affordable housing expenditures Contractually obligated Capital Project Funds TIF #1-3 Restricted for tax increment Contractually obligated by tax increment agreements TIF #1-5 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 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 The M e a dows a t M y s ti c Lak e Spring Lake or e l i n e B l v d 1 4 0 t h S t N W 1 4 0 t h S t N W 1 4 0 t h S t N E Haas Lake Mystic Lake Jeffers Pond O r i o n R d N W L o r d s S t N E W i l d s R d g N W 1 5 4 t h S t N W Mys t ic L a k e D r N W 1 4 0 t h S t N W E a g l e C r e e k A v e N E 1 4 0 t h S t N E The Wi l ds Golf Club Crystal Lake Rice Lake SpringLak e R d S W S u n r a y B TurnerDr S W Duluth Ave SE 1 7 0 t h S t S W a n a m a A v e M u s h t o w n R d H i g h w a y 1 3 S Wo o dv ie w P ark S pring L ak e R egional P a r k 1 4 0 t h S t N E Lakefront Park Ponds Cates Lake Prior Lake 1 5 0 t h S t S E B l u e b i r d T r l N E 1 5 4 t h S t W 1 6 0 t h S t E H i g h w a y 1 3 S H i g h w a y 1 3 S 1 40 t h S t N E 1 4 0 t h S t N E 1 6 0 t h S t S E L ak e fr o nt P a r k We s twood E lem en tar y Markley Lake 13 1 7 0 t h S t E F r a n k l i n T r l S E ereW ay EagleCreekAve E a gle CreekAve The P o nds Ath le tic Com plex Deerfield P ar k Th o m as Ryan M emor ia l P ar k P r i o r L a k e 1 5 0 t h S t W Highway 13 S T e x a s A v e 169th St E 1 6 7 t h St E C a s e y P k w y Sheet 16 Sheet 15 Sheet 14 Sheet 12 Sheet 10 Sheet 8 Sheet 7 Sheet 6 Sheet 9 Sheet 11 Sheet 13 Sy m b o l De s c r i p t i o n Da t e Ap p r . 2 58 0 9 6 Am y E . P r o k , P E I h e r e b y c e r t i f y t h a t t h i s p l a n w a s p r e p a r e d b y m e o r u n d e r m y di r e c t s u p e r v i s i o n a n d t h a t I a m a d u l y L i c e n s e d P r o f e s s i o n a l En g i n e e r u n d e r t h e l a w s o f t h e S t a t e o f M i n n e s o t a . Pr i n t e d N a m e : Ce r t i f i e d b y : Li c e n s e d P r o f e s s i o n a l E n g i n e e r Li c . N o . Da t e : DE S I G N E D : DA T E : SC A L E CH E C K E D : DR A W N : SE H F I L E N O . FI L E N A M E : AE P RJ K RJ K PR I O R 1 7 3 1 7 0 03 / 1 2 / 2 0 2 4 20 2 4 S A N I T A R Y S E W E R LI N I N G P R O J E C T PR I O R L A K E , M N Pa t h : X : \ P T \ P \ P R I O R \ 1 7 0 8 9 5 \ 5 - f i n a l - d s g n \ 5 1 - d r a w i n g s \ 9 0 - G I S \ P r i o r L a k e _ 1 7 0 8 9 5 _ P r o p o s a l \ P r i o r L a k e _ 1 7 0 8 9 5 _ P r o p o s a l . a p r x Da t e S a v e d : 3 / 1 8 / 2 0 2 4 6 : 5 7 P M U s e r N a m e : r k i b l e r Legend Proposed Sanitary Lining Project Area 0 3,0001,500 US Feet¯ DRAWING NUMBER: Text 90 % D E S I G N D O C U M E N T S Engineers | Architects | Planners | Scientists Short Elliott Hendrickson Inc., 3535 Vadnais Center Drive, St. Paul, MN 55110 -3507 651.490.2000 | 800.325.2055 | 888.908.8166 fax | sehinc.com SEH is 100% employee-owned | Affirmative Action –Equal Opportunity Employer September 4, 2024 RE: Prior Lake, MN 2024 Sanitary Sewer Lining Project SEH No. PRIOR 173170 Nick Monserud, Assistant Public Works Director City of Prior Lake 4646 Dakota St. SE Prior Lake, MN 55372 On 2:00 p.m., Wednesday, August 28, 2024, two bids were received for the above-referenced project. The base bids ranged from a high of $3,451,143.58 to a low of $803,721.00. The low bid received was submitted by J.C. Dillon, Inc., of Peoria, IL in the amount of $803,721.00. JC Dillon’s base bid plus all the alternate bid items (1-3) totaled $1,195,629.00. Contractor Total Bid (Base +Alternates 1, 2, 3) Base Bid Alternate 1 Alternate 2 Alternate 3 J.C. Dillon, Inc. $1,195,629.00 $803,721.00 $86,960.00 $162,745.00 $142,203.00 Michels Trenchless, Inc. $5,031,208.64 $3,451,143.58 $352,124.70 $623,151.30 $604,789.06 Engineer's Estimate ($1,789,024.00) $1,224,088.00 $143,775.00 $222,813.00 $198,348.00 We have investigated the qualifications of J.C. Dillon, Inc. and find that they have a sufficient understanding of the project and equipment to perform the construction for which it bid. Accordingly, we recommend the Base bid and all alternates be awarded to J.C. Dillon, Inc. in the amount of $1,195,629.00, which compares favorably with the engineer’s estimate shown above. Sincerely, Dianne Mathews, PE (MN) Project Manager dmk Attachment \\sehinc.com\panzura\pzprojects\pt\p\prior\173170\6-bid-const\bid documents\re-bid\recommendation of award letter.docx Number of Permits Declared Value Number of Permits Declared Value Single Family Dwellings 5 $2,700,033.00 7 $3,585,129.00 Townhouses (# units)0 $0.00 0 $0.00 Multiple Units 0 $0.00 0 $0.00 New Commercial Industrial & Commercial 0 $0.00 1 $650,000.00 Residential 86 $2,523,191.56 140 $2,184,582.67 Industrial & Commercial 6 $1,270,168.00 2 $16,000.00 Mechanical 111 $0.00 59 $0.00 Mechanical (SF & TH)20 $0.00 28 $0.00 TOTALS 228 $6,493,392.56 237 $6,435,711.67 Number of Permits Declared Value Number of Permits Declared Value Single Family Dwellings 43 $21,008,118.00 55 $24,209,130.00 Townhouses (# units)4 $672,000.00 0 $0.00 Multiple Units 1 $28,733,056.00 0 $0.00 New Commercial Industrial & Commercial 2 $3,950,000.00 3 $5,844,460.00 Residential 676 $18,455,002.44 746 $12,478,088.26 Industrial & Commercial 16 $4,417,396.00 16 $1,091,739.00 Mechanical 674 $0.00 398 $0.00 Mechanical (SF & TH)188 $0.00 220 $0.00 TOTALS 1604 $77,235,572.44 1438 $43,623,417.26 Summary of Fees Collected August 2024 August 2023 YTD 2024 YTD 2023 General Fund $80,508.64 $95,420.88 $856,562.38 $515,705.06 Trunk Reserve Fund $10,350.00 $10,350.00 $542,340.00 $136,305.00 Water Storage Fund - $0.00 $0.00 $0.00 Water and Sewer Fund $4,620.00 $8,182.50 $49,284.51 $48,580.00 Metro Council SAC $12,425.00 $12,425.00 $656,040.00 $164,010.00 State Surcharge $2,534.49 $2,624.91 $21,386.02 $15,127.86 Builders Fees and Deposits $32,500.00 $17,500.00 $222,300.00 $137,137.50 TOTAL $142,938.13 $146,503.29 $2,347,912.91 $1,016,865.42 Beverly Alexander Beverly Alexander, Development Services Assistant 2024 Year to Date 2023 Year to Date New Residential Additions and Alterations Additions and Alterations  Mechanical permits include but are not limited to furnaces, water heaters, softeners, and fireplaces. They are flat-rate permit fees.  Mechanical (SF & TH) permits include required plumbing, heating, sewer and water and fireplace permits for new single family residences. They are flat-rate permit fees. CITY OF PRIOR LAKE BUILDING PERMIT SUMMARY AUGUST 1, 2024 - AUGUST 31, 2024 New Residential August 2024 August 2023 City Project:A1123-000001 AT&T Site ID:10081745 THIRD AMENDMENT TO COMMUNICATION FACILITIES LEASE AGREEMENT This Third Amendment to Communication Facilities Lease Agreement (“Third Amendment”)is made and entered into this ________ day of ________________, 2024 (“Effective Date”),by and between the City of Prior Lake,a Minnesota municipal corporation (hereinafter referred to as the “City”)and New Cingular Wireless PCS,LLC,a Delaware limited liability company (hereinafter referred to as “Communications Company”). RECITALS WHEREAS,the City and Communications Company entered into that certain Communication Facilities Lease Agreement dated May 1,2022 (“Original Agreement”)for space on the City’s Cedarwood Street Water Tower (“Water Tower”)and space adjacent to the Water Tower on City’s Property located at 5560 Cedarwood Street NE,Prior Lake,MN 55372 (“Property”)for the purpose of constructing, installing,removing,replacing,maintaining,and operating Antennae and Equipment,as defined in the Original Agreement;and WHEREAS,Communications Company modified and/or upgraded Communications Company’s Antennae and or Equipment pursuant to First Amendment to Communication Facilities Lease Agreement dated August 21,2023 (“Amendment 1”)and Second Amendment to Communication Facilities Lease Agreement dated October 2,2023 (“Amendment 2”).(The Original Agreement, Amendment land Amendment 2 are hereinafter jointly referred to as the “Agreement”);and WHEREAS,the City and Communications Company hereby seek to amend the terms of the Agreement to temporarily allow the use of unpermitted equipment. NOW,THEREFORE,in consideration of the foregoing recitals and for other good,valuable and fair consideration,the receipt and sufficiency of which is hereby acknowledged the parties agree as follows: 1.Consent of City.The City hereby consents to the Communications Company’s proposed temporary modification of the Communications Company’s Antennae and Equipment on the Water Tower pursuant the terms of the Third Amendment. 2.Definitions.All terms defined in the Agreement shall have the same definitions when used in this Third Amendment. 3.Permitted Equipment.The City hereby grants Communications Company the right and consents to Communications Company temporarily mounting the equipment depicted on Exhibit B-2 herein.Communications Company must provide a letter signed by a licensed Professional Engineer stating that the additional temporary equipment will not impact the structural integrity of the Water Tower or the Communications Company’s mountings. 4.Term Length.The City hereby grants Communications Company the right and consents to Communications Company temporarily mounting the equipment depicted on Exhibit B-2 for a period not to exceed one (1)year from the Effective Date of the Third Amendment. 1 232628v1 City Project:A1123-000001 AT&T Site ID:10081745 5,Fees and Expenses.Communications Company shall pay all of the City’s costs and expenses relating to Communications Company’s installation of the temporary equipment,as shown in Exhibit B-2,or revised plans,if applicable,including all fees of City’s structural engineer and/or City’s Attorney. 6.Rent Increase.As additional consideration for the additional temporary equipment and other rights set forth in this Third Amendment,from the Effective Date to the removal and inspection of the temporary equipment,for each month the temporary equipment is mounted on the Water Tower,there will be a fee of four hundred ($400)dollars.Partial months not to be prorated.Payment shall be due and payable within ninety (90)days after the notice of final inspection completion. 7.Terms and Conditions of Lease.All other terms,covenants,and conditions of the Agreement remain in full force and effect except as modified by this Third Amendment.The recitals set forth above are incorporated herein and made a part hereof as if they were set forth in the body hereof. IN WITNESS HEREOF,the parties have executed this Third Amendment as of the date first written above. CITY OF PRIOR LAKE Kirt Briggs,Mayor Jason Wedel,City Manager COMMUNICATIONS COMPANY: New Cingular Wireless PCS,LLC, a Delaware limited liability company By:AT&T Mobility Corporation,its Manager By:Jere,tc Its:1),’ 2 232628v I City Project:A1123-000001 AT&T Site ID:10081745 EXHIBIT B-2 Communications Company’s Temporary Equipment (attached hereto) 3 232628v I Cambium Networks __________ microwave installation to be mounted to existing antenna frame/pipe. SE alpha sector on this tank (135 deg)with a 1cabled connection to AT&T’s shelter DESIGNED FOR LONG-RANGE,HIGH-CAPACITY AND HIGH-DENSITY DEPLOYMENTS Cambium Networks’60 6Hz cnWave solution provides easy. test anG cost-effective wireless gigabit connectivity for edge access and/or high-capacity backhaul for edge access solutions at a significantly iower TCO ti-an fiber rf’astructure. Seivice providers and enterprises now have access to gigabit for business and residential connectivity,backhaul for Wi-Fi access or LTE/5G small cell.Certified for Facebook Terragraph,cnWave solutions are highly effcient at handling high-density deployments in cities and suburban areas. V3000 is featured with a 44,5 dBi or 40.5 dBi highgain antenna wdh beamtorniing.The Client Node (CN)can be tsed as either a client in PMP configurations or an end-point in PTP configurations CLOUD AND ON-PREMISES MANAGEMENT 60GHz cnWave operates wtih Cambium Networks’ cnMaestro management system cnMaestro’is a cloud-based or on-premises software platform for secure,end-to-end network controL cnMaeslio wireless network manager sImplifies device management by offering full network vsibility and zero-touch provisioning.View and perform a full suite of wireless network management functions in rea time. Optim ze system availability,maximize throughput and meet emerging needs of business arid residential customers. p. 60 GHz cnWave V3000 High-Gain Client Node QUICK LOOK •Supports 57 to 66 GHz •Up to 3.6 Gbps (1.8 Gbps DL and t8 Gbps UI).Channel bonding typically doubles capacity •Easy installation with auto beamforming •Low latency <1 ms •802.llay technology with Terragraph certification — terragraph certified ‘-xx —RCDv’ C20)canibium Networks mr camblumnetworks.com (icambium Networks DATA SHEET Specifications 60 GHz cnWave V3000 Client Node Spectrum Frequency 57 to 66 GHz in a single SKU dulflon&MCS-0 (BPSK)to MCS-12 (16-QAM) Channel Width 216 0Hz,432 GH Latency <Irns Carrier Bonding Up to2 adjacent channels 60.5 dBrn (with 44.5 dBi Antenna)Maximum EIRP 54.5 dsm (with 40.5 dBi Antenna)Mode of PMP Ctient or PTPOperation _______________________________________________________________ Into face Channel Access TDMAJTDD Ethernet I x 100/bOO/lOG BeseT with PoE In, Interface 1 i 100/1000 BaseT with 802.3at PoE Out 1 x SFP+10 and lOG Networking Protocols lPv4,tPv6.Layer2 Budge,Layer3 tPv6 Supported Routing.Open/R mesh Networic cnMaeslro.HTTR HTTPS.SNMP v2c &v3Management MW 4,000 bytes VLAN 802 lad (GinO),80210 with 802.ip priority QoS’4 Level OôS.DSCP and VLAN Tag Security Encryption 128-bit AES Firmware security Signed Firmware Images 2n2iCombium Neiworks IC. Antenno Gain 44.5 dRi or 40 5 dBi Type Integrated Beamforming +/.2°azimuth,t/10 elevationScanRange Beam Width Powering Passive PoE (42-57 without AUX PoE Outtype in use Power 60 W with AUX PoE Out in use, Consumption 30 W without AUX PoE Out in use EnvIronmental Temperature -40°C to 60°C (-40°F to 140°F) Mean Time Between Failure >40 years Weight V3000 with 44.5 dBl dish 4.7kg (10.3 lbs.)without clamp V3000 with 40.5 dBi dish 3.9kg (8.6 lbs.)without clamp Dimensions V3000 with 44.5dBi dish H x W x 0 421 x 347 x 349 mm (16.57 K 13.66)<13]in V3000 with 40.5dBi dish 343 K 198 x 251 mm (13 Sx 7.8 x 9.9 in) Wind Survival 200 km/h (124 miTh) Avail able Ill future release 2 cambpumnetworks.com Cambium Networks DATA SHEET 60 GHz cnWave V3000 Client Node V3000 with 44.5 dBi Antenna V3000 with 40.5 dPi Antenna D2I Carnhurn Networks.Inc 3 combi urn networks.corn Cambium Networks DATA SHEET 60 GHz cnWave V3000 Client Node C69ør?4.4 C600SOOCO2SA 60 GHz cnWave V3000 Client Node Radio Only -Israel Only C600SOODOO2A 60 GHz cnWave V3000 Client Node Antenna Assembly 405 dO 4 Pack — C600500D003A 60 Gl-Iz cnWave V3000 Client Node Antenna Assembly.44.5 dsi,4 Pack-i:’ N00004SLOO2A Tilt Bracket Assembly -r --..:i : C0000001125A cnWave Precision Mounting Sracket NOTE:Power Supply Unit must be ordered separately. ABOUT CAMBIUM NETWORKS Cambiurn Networks empowers millions of people with wireless connectivity worldwide Us wireless ponifolo is used by conlmerc-a and government network operators as well as broadband service provide’s to connect people,places and things W4h a singe network archilecture soanning t:xe,i wire*ss and WiFi.Cambii.nt Networks e9aoies operators to achieve isaximum performance with mel soecirun’End-to-end cloud nanagemenl tiansforms networks into dynarric envWomenIs nat evolve to iieel clang ng needs w;lh niin’maf phys -.01 human infeiventor’.CanoiL-m Networxs empowe’s a growing ecosystem of partners who design and de’ive:gigabit wreless soutons that JUST wOrn camblumnetworks.com L 330.1 02021 Contium NeI.eoiks Inc.4 38 Golf Rotd Suiie 360.Roiling Meadows.Ainois 60006 USA 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments Fund 101 - GENERAL FUND TAXES 31010.00 Current Property Taxes - General Purpos 11,013,517 13,029,707 13,029,707 13,999,121 969,414 7.44 31020.00 Delinquent Property Taxes - General Purp 36,842 31040.00 Fiscal Disparities 1,068,524 1,017,559 1,017,559 1,278,316 260,757 25.63 33423.00 Market Value Credit Aid 456 TAXES 12,119,339 14,047,266 14,047,266 15,277,437 1,230,171 8.76 FRANCHISE TAXES 31810.00 Franchise Taxes 557,579 559,000 559,000 555,000 (4,000) (0.72)Mediacom reduction based on 2023 actual FRANCHISE TAXES 557,579 559,000 559,000 555,000 (4,000) (0.72) INTERGOVERNMENTAL 33160.10 Fed Aids/Grants - Operating Grants 33160.11 Fed Aids/Grants - Operating Police 3,425 33401.00 Local Government Aid 33416.01 State Aid - Police Train 30,306 30,000 30,000 30,000 33416.02 State Police Aid-Ins Prem 317,608 299,000 299,000 318,000 19,000 6.35 33417.00 State Aid - Fire Training 32,008 20,000 20,000 (20,000) (100.00) 33418.00 State Road & Bridge Aid 417,468 467,000 467,000 476,340 9,340 2.00 33420.00 State Fire Aid-Ins. Prem.334,993 299,835 299,835 348,527 48,692 16.24 Increase in State aid for Fire Relief Association - passthrough 33422.10 State Aids/Grants - Operating Grants 33422.11 State Aids/Grants - Operating Police 13,047 3,500 3,500 (3,500) (100.00) 33610.10 County-City Aids/Grants - Operating Gran 2,989 33610.11 County-City Aids/Grants - Operating Poli 5,557 33620.00 Township Fire & Resc Aid 750,179 959,522 959,522 961,430 1,908 0.20 33621.00 Liaison Aid 69,775 69,775 72,287 2,512 3.60 33630.00 Metro Council Grants 33631.00 Payment in Lieu of Taxes 1,100,000 1,200,000 1,200,000 1,200,000 33700.10 Miscellaneous Grants - Operating Grants 33700.11 Miscellaneous Grants - Operating Police 33700.23 Miscellaneous Grants - Capital Parks INTERGOVERNMENTAL 3,007,580 3,348,632 3,348,632 3,406,584 57,952 1.73 BUDGET REPORT CITY OF PRIOR LAKE REVENUES - DETAIL From Amended Budget 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE REVENUES - DETAIL From Amended Budget CHARGES FOR SERVICES 34103.00 Zoning & Subdivision Fees 30,950 40,000 40,000 40,000 34104.00 Plan Check Fees 234,816 244,941 244,941 203,430 (41,511) (16.95)Change in mix of single family and townhomes 34105.00 Sale of Maps/Publications - Reports 330 500 500 500 34107.00 Assessment Searches - Reports 400 500 500 500 34108.00 Street Chip Seal Fee-New Development 4,750 34109.00 Project Admin/Eng Fees 216,283 246,000 246,000 150,000 (96,000) (39.02)Adjusted to reflect proposed street projects 34203.00 Accident/Warrant Reports - Reports 955 200 200 200 34304.00 PEG Access Fees 34731.00 Adult League Fees 3,931 5,000 5,000 5,000 34732.00 Recreation Program Fees - Contracted 43,024 35,000 35,000 40,000 5,000 14.29 34735.00 Recreation Program Fees - Staff Run 53,907 65,000 65,000 70,000 5,000 7.69 34735.01 Recreation Program Fees - Club Prior 9,300 12,000 12,000 12,000 34740.00 Concessions - Park Fees 34760.01 Facility Rental - Regular 50,243 48,028 48,028 66,449 18,421 38.35 34760.87 Facility Rental - Lease 15,281 15,600 15,600 (15,600) (100.00) 34761.00 Studio/Pavilion Rental 33,998 25,000 25,000 27,500 2,500 10.00 34762.00 Park Shelter Rental 93,092 20,000 20,000 20,000 34762.01 Boat Slip Rental 71,200 71,200 72,000 800 1.12 34763.13 Facility Usage Fee (not taxable) 34765.01 Tower Leases 49,776 273,183 273,183 34765.87 Tower Leases - Lease 245,895 260,082 260,082 (260,082) (100.00) 34780.00 Parking Meter Fees 27,324 30,000 30,000 30,000 34782.00 Sign Lease Fees 250 34783.00 City Contract Services 229,960 209,216 209,216 229,960 20,744 9.92 36220.16 Prof Services Fee Deposit Bldg Inspectio CHARGES FOR SERVICES 1,344,465 1,328,267 1,328,267 1,240,722 (87,545) (6.59) SPECIAL ASSESSMENTS 36101.00 City Assess. Collections 36102.00 County Assess. Collection 5,499 4,000 4,000 4,000 SPECIAL ASSESSMENTS 5,499 4,000 4,000 4,000 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE REVENUES - DETAIL From Amended Budget INTEREST (LOSSES) ON INVESTMENTS 36210.00 Interest Earnings 325,907 180,000 180,000 277,500 97,500 54.17 Adjusted to reflect estimated interest earnings 36210.87 Interest Earnings 65,485 36215.00 Amortization - Premium/Discount (12,966) (20,000) (20,000) (20,000) 36225.00 Unrealized Inv.Gain(Loss)166,340 36226.00 Realized Inv Gain/(Loss) INTEREST (LOSSES) ON INVESTMENTS 544,766 160,000 160,000 257,500 97,500 60.94 MISCELLANEOUS REVENUES 36211.00 Developer Agreements 13,136 60,000 60,000 50,000 (10,000) (16.67) 36212.00 Miscellaneous Revenue 78,882 69,800 69,800 69,800 36230.00 Contributions & Donations 4,120 36230.11 Contributions - Shop with a Cop 2,000 36230.12 Contributions and Donations 2,000 36230.13 Contributions and Donations 17,105 36230.33 Contributions - Charitable Gambling MISCELLANEOUS REVENUES 117,243 129,800 129,800 119,800 (10,000) (7.70) SALE OF ASSETS 39102.00 Sale of Property 5,672 SALE OF ASSETS 5,672 TRANSFERS IN 39203.00 Transfer from Other Funds 555,000 852,400 852,400 615,000 (237,400) (27.85)F601 $251k, F602 $115k, F604 $249k TRANSFERS IN 555,000 852,400 852,400 615,000 (237,400) (27.85) DEBT ISSUED 39310.00 G.O. Bond Proceeds DEBT ISSUED 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE REVENUES - DETAIL From Amended Budget LICENSES AND PERMITS 32100.00 Business Licenses 1,050 1,050 1,050 2,000 950 90.48 32110.00 Liquor Licenses 82,179 80,470 80,470 80,470 32120.00 Cannabis Fee 4,200 32160.00 Refuse Haulers 5,035 5,000 5,000 5,900 900 18.00 32170.00 Outdoor Concert Permits 32175.00 Public Private Gathering Permit 240 32180.00 Cigarette Licenses 2,295 2,295 2,295 2,250 (45) (1.96) 32190.00 Community Event Application 2,230 5,000 5,000 2,500 (2,500) (50.00) 32210.00 Building Permits 490,557 376,822 376,822 312,962 (63,860) (16.95)Change in mix of single family and townhomes 32211.00 Retainage Forfeiture 2,688 32215.00 Mechanical Permits 51,846 79,548 79,548 78,120 (1,428) (1.80) 32230.00 Plumbing Permits 41,756 56,702 56,702 55,620 (1,082) (1.91) 32231.00 Sewer/Water Inspection 3,652 4,916 4,916 4,520 (396) (8.06) 32232.00 Plumbing Registrations 32240.00 Animal Licenses 32260.00 Burning Permits 4,960 4,000 4,000 5,000 1,000 25.00 32270.00 Short-term Rental Fee 2,255 1,435 1,435 1,500 65 4.53 LICENSES AND PERMITS 694,943 617,238 617,238 550,842 (66,396) (10.76) FINES AND FORFEITURES 35101.00 County Court Fines 35104.00 Prosecution Restitution 2,895 FINES AND FORFEITURES 2,895 ESTIMATED REVENUES - FUND 101 18,954,981 21,046,603 21,046,603 22,026,885 (980,282) (4.66) 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE REVENUES - DETAIL From Amended Budget DEBT SERVICE FUNDS TAXES 31015.00 Current Property Taxes - Debt Service 3,113,618 3,203,024 3,203,024 2,929,190 (273,834) (8.55) TAXES 3,113,618 3,203,024 3,203,024 2,929,190 (273,834) (8.55) INTEREST (LOSSES) ON INVESTMENTS 36210.00 Interest Earnings 95,729 52,900 52,900 77,100 24,200 45.75 36225.00 Unrealized Inv.Gain(Loss)41,114 INTEREST (LOSSES) ON INVESTMENTS 136,843 52,900 52,900 77,100 24,200 45.75 DEBT ISSUED 39310.00 G.O. Bond Proceeds DEBT ISSUED OTHER FINANCING SOURCES 39315.00 Projects - Bond Premium OTHER FINANCING SOURCES TRANSFERS IN 39203.00 Transfer from Other Funds 1,134,163 1,010,990 965,990 1,256,974 290,984 30.12 F601 $625k, F101 $262 mv, F450 $404k overlay project TRANSFERS IN 1,134,163 1,010,990 965,990 1,256,974 290,984 30.12 SPECIAL ASSESSMENTS 36101.00 City Assess. Collections 325,203 36102.00 County Assess. Collection 405,269 621,742 621,742 569,714 (52,028) (8.37) SPECIAL ASSESSMENTS 730,472 621,742 621,742 569,714 (52,028) (8.37) MISCELLANEOUS REVENUES 36212.00 Miscellaneous Revenue MISCELLANEOUS REVENUES ESTIMATED REVENUES - DEBT SERVICE FUNDS 5,115,096 4,907,563 4,862,563 4,832,978 (29,585) (0.61) 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE REVENUES - DETAIL From Amended Budget Fund 210 - CABLE FRANCHISE FUND FRANCHISE TAXES 31810.00 Franchise Taxes FRANCHISE TAXES CHARGES FOR SERVICES 34304.00 PEG Access Fees 16,448 17,100 17,100 17,000 (100) (0.58) CHARGES FOR SERVICES 16,448 17,100 17,100 17,000 (100) (0.58) INTEREST (LOSSES) ON INVESTMENTS 36210.00 Interest Earnings 2,999 36225.00 Unrealized Inv.Gain(Loss)1,544 INTEREST (LOSSES) ON INVESTMENTS 4,543 ESTIMATED REVENUES - FUND 210 20,991 17,100 17,100 17,000 100 0.58 Fund 225 - CAPITAL PARK FUND INTERGOVERNMENTAL 33160.20 Fed Aids/Grants - Capital Grants 1,000,000 1,000,000 TH 13 project 33700.20 Miscellaneous Grants - Capital Grants INTERGOVERNMENTAL 1,000,000 1,000,000 CHARGES FOR SERVICES 34760.01 Facility Rental - Regular 32,000 32,000 34760.87 Facility Rental - Lease 23,967 24,000 24,000 (24,000) (100.00) 34791.00 Dedication Fees 98,937 300,000 300,000 300,000 CHARGES FOR SERVICES 122,904 324,000 324,000 332,000 8,000 2.47 INTEREST (LOSSES) ON INVESTMENTS 36210.00 Interest Earnings 54,821 30,600 30,600 43,800 13,200 43.14 36210.87 Interest Earnings (711) 36225.00 Unrealized Inv.Gain(Loss)26,577 INTEREST (LOSSES) ON INVESTMENTS 80,687 30,600 30,600 43,800 13,200 43.14 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE REVENUES - DETAIL From Amended Budget MISCELLANEOUS REVENUES 36230.00 Contributions & Donations 14,300 MISCELLANEOUS REVENUES 14,300 ESTIMATED REVENUES - FUND 225 217,891 354,600 354,600 1,375,800 (1,021,200) (287.99) Fund 240 - EDA SPECIAL REVENUE FUND TAXES 31010.00 Current Property Taxes - General Purpos 342,910 364,000 364,000 382,506 18,506 5.08 31040.00 Fiscal Disparities 26,122 26,000 26,000 22,494 (3,506) (13.48) 33423.00 Market Value Credit Aid TAXES 369,032 390,000 390,000 405,000 15,000 3.85 INTERGOVERNMENTAL 33610.14 County-City Aids/Grants - Operating EDA INTERGOVERNMENTAL CHARGES FOR SERVICES 34111.00 Administrative Charges 34760.02 Facility Rental - EDA 24,588 24,588 24,588 24,588 CHARGES FOR SERVICES 24,588 24,588 24,588 24,588 INTEREST (LOSSES) ON INVESTMENTS 36210.00 Interest Earnings 11,221 3,700 3,700 9,800 6,100 164.86 36225.00 Unrealized Inv.Gain(Loss)6,846 36226.00 Realized Inv Gain/(Loss) INTEREST (LOSSES) ON INVESTMENTS 18,067 3,700 3,700 9,800 6,100 164.86 MISCELLANEOUS REVENUES 36230.00 Contributions & Donations MISCELLANEOUS REVENUES 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE REVENUES - DETAIL From Amended Budget TRANSFERS IN 39203.00 Transfer from Other Funds TRANSFERS IN CAPITAL CONTRIBUTIONS FROM OTHER FUNDS 37901.00 Contribution (Other Fund) CAPITAL CONTRIBUTIONS FROM OTHER FUNDS ESTIMATED REVENUES - FUND 240 411,687 418,288 418,288 439,388 (21,100) (5.04) Fund 410 - REVOLVING EQUIPMENT FUND TAXES 31010.00 Current Property Taxes - General Purpos 747,710 800,000 800,000 875,000 75,000 9.38 31015.00 Current Property Taxes - Debt Service 150,000 150,000 TAXES 747,710 800,000 800,000 1,025,000 225,000 28.13 INTERGOVERNMENTAL 33422.10 State Aids/Grants - Operating Grants 33633.20 Watershed Dist Grants/Aid-Capital Grants INTERGOVERNMENTAL INTEREST (LOSSES) ON INVESTMENTS 36210.00 Interest Earnings 26,450 14,500 14,500 20,400 5,900 40.69 36225.00 Unrealized Inv.Gain(Loss)15,132 INTEREST (LOSSES) ON INVESTMENTS 41,582 14,500 14,500 20,400 5,900 40.69 MISCELLANEOUS REVENUES 39104.00 Forfeiture Property Sales MISCELLANEOUS REVENUES SALE OF ASSETS 39102.00 Sale of Property 122,667 SALE OF ASSETS 122,667 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE REVENUES - DETAIL From Amended Budget TRANSFERS IN 39203.00 Transfer from Other Funds 217,500 400,000 342,166 (57,834) (14.46)F601 $92k, F602 $158k, F604 $92k TRANSFERS IN 217,500 400,000 342,166 (57,834) (14.46) DEBT ISSUED 39310.00 G.O. Bond Proceeds DEBT ISSUED ESTIMATED REVENUES - FUND 410 1,129,459 814,500 1,214,500 1,387,566 (173,066) (14.25) Fund 430 - REVOLVING PARK EQUIP FUND TAXES 31010.00 Current Property Taxes - General Purpos 439,181 460,000 460,000 535,000 75,000 16.30 TAXES 439,181 460,000 460,000 535,000 75,000 16.30 INTERGOVERNMENTAL 33700.20 Miscellaneous Grants - Capital Grants INTERGOVERNMENTAL INTEREST (LOSSES) ON INVESTMENTS 36210.00 Interest Earnings 48,942 25,100 25,100 32,500 7,400 29.48 36225.00 Unrealized Inv.Gain(Loss)14,833 INTEREST (LOSSES) ON INVESTMENTS 63,775 25,100 25,100 32,500 7,400 29.48 MISCELLANEOUS REVENUES 36212.00 Miscellaneous Revenue 36230.00 Contributions & Donations 185,000 MISCELLANEOUS REVENUES 185,000 TRANSFERS IN 39203.00 Transfer from Other Funds TRANSFERS IN 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE REVENUES - DETAIL From Amended Budget DEBT ISSUED 39310.00 G.O. Bond Proceeds 1,030,000 1,030,000 DEBT ISSUED 1,030,000 1,030,000 ESTIMATED REVENUES - FUND 430 687,956 485,100 485,100 1,597,500 (1,112,400) (229.31) Fund 440 - FACILITIES MANAGEMENT FUND TAXES 31010.00 Current Property Taxes - General Purpos 154,264 205,000 205,000 255,000 50,000 24.39 TAXES 154,264 205,000 205,000 255,000 50,000 24.39 INTERGOVERNMENTAL 33160.00 Fed Aids/Grants 33620.00 Township Fire & Resc Aid 33700.10 Miscellaneous Grants - Operating Grants 47,000 47,000 mvta INTERGOVERNMENTAL 47,000 47,000 INTEREST (LOSSES) ON INVESTMENTS 36210.00 Interest Earnings 44,860 25,200 25,200 35,800 10,600 42.06 36225.00 Unrealized Inv.Gain(Loss)21,648 INTEREST (LOSSES) ON INVESTMENTS 66,508 25,200 25,200 35,800 10,600 42.06 TRANSFERS IN 39203.00 Transfer from Other Funds 24,000 24,000 (24,000) (100.00) TRANSFERS IN 24,000 24,000 (24,000) (100.00) DEBT ISSUED 39310.00 G.O. Bond Proceeds 1,100,000 1,100,000 515,000 (585,000) (53.18) DEBT ISSUED 1,100,000 1,100,000 515,000 (585,000) (53.18) ESTIMATED REVENUES - FUND 440 220,772 1,354,200 1,354,200 852,800 501,400 37.03 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE REVENUES - DETAIL From Amended Budget Fund 450 - PERMANENT IMPROVEMENT REVOLVING FUND TAXES 31010.00 Current Property Taxes - General Purpos TAXES FRANCHISE TAXES 31810.00 Franchise Taxes 1,079,097 1,080,000 1,080,000 (1,080,000) (100.00) FRANCHISE TAXES 1,079,097 1,080,000 1,080,000 (1,080,000) (100.00) SPECIAL ASSESSMENTS 36101.00 City Assess. Collections 5,064 36102.00 County Assess. Collection 81,809 580,666 580,666 298,642 (282,024) (48.57) SPECIAL ASSESSMENTS 86,873 580,666 580,666 298,642 (282,024) (48.57) INTEREST (LOSSES) ON INVESTMENTS 36210.00 Interest Earnings 50,250 18,300 18,300 48,300 30,000 163.93 36225.00 Unrealized Inv.Gain(Loss)26,308 INTEREST (LOSSES) ON INVESTMENTS 76,558 18,300 18,300 48,300 30,000 163.93 TRANSFERS IN 39203.00 Transfer from Other Funds 1,850,000 300,000 300,000 F501 franchise fees TRANSFERS IN 1,850,000 300,000 300,000 DEBT ISSUED 39310.00 G.O. Bond Proceeds 1,696,200 1,696,200 (1,696,200) (100.00) DEBT ISSUED 1,696,200 1,696,200 (1,696,200) (100.00) ESTIMATED REVENUES - FUND 450 1,242,528 5,225,166 3,375,166 646,942 2,728,224 80.83 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE REVENUES - DETAIL From Amended Budget Fund 601 - WATER FUND INTERGOVERNMENTAL 33160.10 Fed Aids/Grants - Operating Grants 33422.15 State Aids/Grants - Operating Public Wor 17 33422.25 State Aids/Grants - Capital Public Works 33610.10 County-City Aids/Grants - Operating Gran INTERGOVERNMENTAL 17 SPECIAL ASSESSMENTS 36102.00 County Assess. Collection 3,714 SPECIAL ASSESSMENTS 3,714 INTEREST (LOSSES) ON INVESTMENTS 36210.00 Interest Earnings 232,414 117,300 117,300 196,500 79,200 67.52 36225.00 Unrealized Inv.Gain(Loss)125,962 INTEREST (LOSSES) ON INVESTMENTS 358,376 117,300 117,300 196,500 79,200 67.52 MISCELLANEOUS REVENUES 36212.00 Miscellaneous Revenue 18,374 37185.00 AMRS Brass Recycling 37190.00 Miscellaneous Revenue Adj MISCELLANEOUS REVENUES 18,374 SALE OF ASSETS 39102.00 Sale of Property SALE OF ASSETS TRANSFERS IN 39203.00 Transfer from Other Funds 163,937 TRANSFERS IN 163,937 DEBT ISSUED 39310.00 G.O. Bond Proceeds DEBT ISSUED 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE REVENUES - DETAIL From Amended Budget CAPITAL CONTRIBUTIONS FROM OTHER FUNDS 37901.00 Contribution (Other Fund)768,036 57901.00 Capital Contributions (Other Fund) CAPITAL CONTRIBUTIONS FROM OTHER FUNDS 768,036 CAPITAL CONTRIBUTIONS FROM DEVELOPERS 37902.00 Contribution (Developers) CAPITAL CONTRIBUTIONS FROM DEVELOPERS OTHER FINANCING SOURCES 39315.00 Projects - Bond Premium 20,488 OTHER FINANCING SOURCES 20,488 CONTRIBUTIONS AND DONATIONS 36231.00 PERA Pension Contributions 69 CONTRIBUTIONS AND DONATIONS 69 WATER CHARGES 37100.00 Utility Receipts - Water 4,672,307 4,042,024 4,042,024 4,439,648 397,624 9.84 37160.00 Penalties 10,428 20,000 20,000 10,000 (10,000) (50.00) WATER CHARGES 4,682,735 4,062,024 4,062,024 4,449,648 387,624 9.54 CAPITAL FACILITY CHARGES 37110.00 Utility Base Fee Revenue 1,314,590 1,374,903 1,374,903 1,412,862 37,959 2.76 CAPITAL FACILITY CHARGES 1,314,590 1,374,903 1,374,903 1,412,862 37,959 2.76 METER SALES 37170.00 Water Meter Sales 52,924 79,825 79,825 56,625 (23,200) (29.06) 37175.00 Pressure Reducers 13,338 25,000 25,000 15,900 (9,100) (36.40) 37180.00 Frost Plates METER SALES 66,262 104,825 104,825 72,525 (32,300) (30.81) ESTIMATED REVENUES - FUND 601 7,396,598 5,659,052 5,659,052 6,131,535 (472,483) (8.35) 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE REVENUES - DETAIL From Amended Budget Fund 602 - STORM WATER UTILITY INTERGOVERNMENTAL 33160.10 Fed Aids/Grants - Operating Grants 33422.10 State Aids/Grants - Operating Grants 27,000 33610.20 County-City Aids/Grants - Capital Grants 33633.00 Watershed Dist Grants/Aid INTERGOVERNMENTAL 27,000 SPECIAL ASSESSMENTS 36102.00 County Assess. Collection (3,994) SPECIAL ASSESSMENTS (3,994) INTEREST (LOSSES) ON INVESTMENTS 36210.00 Interest Earnings 81,454 41,100 41,100 69,300 28,200 68.61 36225.00 Unrealized Inv.Gain(Loss)42,864 INTEREST (LOSSES) ON INVESTMENTS 124,318 41,100 41,100 69,300 28,200 68.61 MISCELLANEOUS REVENUES 36212.00 Miscellaneous Revenue 17,414 MISCELLANEOUS REVENUES 17,414 TRANSFERS IN 39203.00 Transfer from Other Funds TRANSFERS IN CAPITAL CONTRIBUTIONS FROM OTHER FUNDS 37901.00 Contribution (Other Fund)420,111 CAPITAL CONTRIBUTIONS FROM OTHER FUNDS 420,111 CAPITAL CONTRIBUTIONS FROM DEVELOPERS 37902.00 Contribution (Developers) CAPITAL CONTRIBUTIONS FROM DEVELOPERS 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE REVENUES - DETAIL From Amended Budget CONTRIBUTIONS AND DONATIONS 36231.00 PERA Pension Contributions 17 CONTRIBUTIONS AND DONATIONS 17 WATER CHARGES 37160.00 Penalties 1,521 4,000 4,000 1,500 (2,500) (62.50) WATER CHARGES 1,521 4,000 4,000 1,500 (2,500) (62.50) STORM WATER CHARGES 32250.00 Wetland Application Fee 450 37120.00 Storm Water Revenue 1,411,227 1,510,793 1,510,793 2,000,772 489,979 32.43 STORM WATER CHARGES 1,411,677 1,510,793 1,510,793 2,000,772 489,979 32.43 ESTIMATED REVENUES - FUND 602 1,998,064 1,555,893 1,555,893 2,071,572 (515,679) (33.14) 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE REVENUES - DETAIL From Amended Budget Fund 604 - SEWER FUND INTERGOVERNMENTAL 33160.10 Fed Aids/Grants 33422.25 State Aids/Grants - Capital Public Works 33630.20 Metro Council Grants - Capital 61,715 INTERGOVERNMENTAL 61,715 SPECIAL ASSESSMENTS 36102.00 County Assess. Collection 2,890 SPECIAL ASSESSMENTS 2,890 INTEREST (LOSSES) ON INVESTMENTS 36210.00 Interest Earnings 131,201 70,000 70,000 106,400 36,400 52.00 36225.00 Unrealized Inv.Gain(Loss)64,375 INTEREST (LOSSES) ON INVESTMENTS 195,576 70,000 70,000 106,400 36,400 52.00 MISCELLANEOUS REVENUES 36212.00 Miscellaneous Revenue 5,100 37190.00 Miscellaneous Revenue Adj MISCELLANEOUS REVENUES 5,100 SALE OF ASSETS 39102.00 Sale of Property SALE OF ASSETS TRANSFERS IN 39203.00 Transfer from Other Funds 78,197 TRANSFERS IN 78,197 DEBT ISSUED 39310.00 G.O. Bond Proceeds DEBT ISSUED 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE REVENUES - DETAIL From Amended Budget CAPITAL CONTRIBUTIONS FROM OTHER FUNDS 37901.00 Contribution (Other Fund)541,136 CAPITAL CONTRIBUTIONS FROM OTHER FUNDS 541,136 CAPITAL CONTRIBUTIONS FROM DEVELOPERS 37902.00 Contribution (Developers) CAPITAL CONTRIBUTIONS FROM DEVELOPERS OTHER FINANCING SOURCES 39315.00 Projects - Bond Premium 20,488 OTHER FINANCING SOURCES 20,488 CONTRIBUTIONS AND DONATIONS 36231.00 PERA Pension Contributions 47 CONTRIBUTIONS AND DONATIONS 47 WATER CHARGES 37160.00 Penalties 5,583 5,000 5,000 WATER CHARGES 5,583 5,000 5,000 CAPITAL FACILITY CHARGES 37110.00 Utility Base Fee Revenue 1,140,769 1,195,743 1,195,743 1,311,476 115,733 9.68 CAPITAL FACILITY CHARGES 1,140,769 1,195,743 1,195,743 1,311,476 115,733 9.68 SEWER CHARGES 37102.00 Utility Receipts - Sewer 1,715,511 2,023,789 2,023,789 2,172,946 149,157 7.37 37104.00 Utility Recpt-Sewer MCES 1,827,595 2,106,431 2,106,431 2,092,022 (14,409) (0.68) SEWER CHARGES 3,543,106 4,130,220 4,130,220 4,264,968 134,748 3.26 ESTIMATED REVENUES - FUND 604 5,594,607 5,395,963 5,395,963 5,687,844 (291,881) (5.41) TOTAL - ALL FUNDS 42,990,630 47,234,028 45,739,028 47,067,810 1,328,782 2.91 (166,218) (0.35) From Original Budget 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments FUND 101 - General Fund Dept 41110.00 - MAYOR & COUNCIL PERSONAL SERVICES 51100.04 Wages - Council 56,509 58,450 58,450 59,610 1,160 1.98 51220.03 Allowances - Council 8,100 13,000 13,000 13,000 51450.00 Social Security Contributions 543 806 806 806 51451.00 Medicare Contributions 937 1,036 1,036 1,053 17 1.64 51460.00 PERA Contributions 2,289 2,923 2,923 2,981 58 1.98 51477.00 Workers Compensation Insurance 52 212 212 183 (29) (13.68)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 68,430 76,427 76,427 77,633 1,206 1.58 CURRENT EXPENDITURES 52010.00 Office Supplies 158 300 300 300 52400.20 Small Equipment - Technology 3,770 53310.10 Training and Employee Development 6,168 6,200 6,200 6,250 50 0.81 54310.00 Memberships and Subscriptions 54320.00 Miscellaneous Expense 43 300 300 300 CURRENT EXPENDITURES 10,139 6,800 6,800 6,850 50 0.74 Totals for dept 41110.00 - MAYOR & COUNCIL 78,569 83,227 83,227 84,483 1,256 1.51 Dept 41130.00 - ORDINANCE CURRENT EXPENDITURES 53510.00 Required Notice Publication 3,719 5,000 5,000 6,000 1,000 20.00 CURRENT EXPENDITURES 3,719 5,000 5,000 6,000 1,000 20.00 Totals for dept 41130.00 - ORDINANCE 3,719 5,000 5,000 6,000 1,000 20.00 BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget Dept 41320.00 - ADMINISTRATION PERSONAL SERVICES 51100.01 Wages - Full Time 226,363 237,863 237,863 256,907 19,044 8.01 COLA and step increase 51100.02 Wages - Part Time 3,025 51100.08 Wages - Longevity 51110.01 Overtime - Full Time 3,164 3,164 3,456 292 9.23 51208.01 Sick Leave - Buy Down 51220.01 Allowances - Auto Allowance 6,000 6,000 6,000 6,000 51220.05 Allowances Cell Phone 51220.06 Allowances Moving Exp 51301.00 Accrued Comp Time 51400.00 Compensated Absences 1,301 1,546 1,546 1,927 381 24.64 Increased compensated leave % 51450.00 Social Security Contributions 12,572 10,824 10,824 11,190 366 3.38 51451.00 Medicare Contributions 3,122 3,582 3,582 3,862 280 7.82 51460.00 PERA Contributions 16,289 17,840 17,840 19,268 1,428 8.00 51470.00 Health Insurance 25,202 27,199 27,199 25,231 (1,968) (7.24)Based on current employee selections 51472.00 Retiree HCSP Contributions 545 600 600 720 120 20.00 51473.00 Dental Insurance 628 1,080 1,080 1,013 (67) (6.20)Based on current employee selections 51474.00 Life Insurance 128 1,868 1,868 1,854 (14) (0.75) 51476.00 MN Unemployment Insurance 51477.00 Workers Compensation Insurance 1,764 1,523 1,523 1,402 (121) (7.94)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 296,939 313,089 313,089 332,830 19,741 6.31 CURRENT EXPENDITURES 52010.00 Office Supplies 11,067 9,500 9,500 10,000 500 5.26 52400.10 Small Equipment - General 53100.80 Professional Services - General 5,000 5,000 5,000 53210.00 Telecommunications 1,269 660 660 660 53310.10 Training and Employee Development 4,944 4,500 4,500 5,000 500 11.11 54310.00 Memberships and Subscriptions 62,761 56,875 56,875 58,303 1,428 2.51 54320.00 Miscellaneous Expense 2,846 3,500 3,500 3,000 (500) (14.29) CURRENT EXPENDITURES 82,887 80,035 80,035 81,963 1,928 2.41 Totals for dept 41320.00 - ADMINISTRATION 379,826 393,124 393,124 414,793 21,669 5.51 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget Dept 41330.00 - BOARDS & COMMISSIONS PERSONAL SERVICES 51100.05 Wages - Commissioners 5,100 9,800 9,800 7,200 (2,600) (26.53) 51450.00 Social Security Contributions 316 608 608 446 (162) (26.64) 51451.00 Medicare Contributions 74 142 142 104 (38) (26.76) PERSONAL SERVICES 5,490 10,550 10,550 7,750 (2,800) (26.54)Planned for 12 meetings for 2025 CURRENT EXPENDITURES 53310.10 Training and Employee Development 100 200 200 200 54310.00 Memberships and Subscriptions 200 200 200 CURRENT EXPENDITURES 100 400 400 400 Totals for dept 41330.00 - BOARDS & COMMISSIONS 5,590 10,950 10,950 8,150 (2,800) (25.57) Dept 41400.00 - CITY CLERK FUNCTIONS PERSONAL SERVICES 51100.01 Wages - Full Time 91,841 97,301 97,301 104,467 7,166 7.36 COLA and step increase 51400.00 Compensated Absences 551 632 632 784 152 24.05 Increased compensated leave % 51450.00 Social Security Contributions 5,033 6,033 6,033 6,477 444 7.36 51451.00 Medicare Contributions 1,177 1,411 1,411 1,515 104 7.37 51460.00 PERA Contributions 6,888 7,298 7,298 7,835 537 7.36 51470.00 Health Insurance 15,086 16,500 16,500 18,288 1,788 10.84 51472.00 Retiree HCSP Contributions 280 360 360 420 60 16.67 51473.00 Dental Insurance 780 540 540 540 51474.00 Life Insurance 68 68 68 68 51477.00 Workers Compensation Insurance 517 517 474 (43) (8.32)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 121,704 130,660 130,660 140,868 10,208 7.81 CURRENT EXPENDITURES 52010.00 Office Supplies 24 500 500 500 53310.10 Training and Employee Development 3,175 2,500 2,500 5,000 2,500 100.00 54310.00 Memberships and Subscriptions 276 329 4,329 3,229 (1,100) (25.41) CURRENT EXPENDITURES 3,475 3,329 7,329 8,729 1,400 19.10 Totals for dept 41400.00 - CITY CLERK FUNCTIONS 125,179 133,989 137,989 149,597 11,608 8.41 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget Dept 41410.00 - ELECTIONS PERSONAL SERVICES 51100.07 Wages - Election Judge 121 104,172 104,172 13,920 (90,252) (86.64)Presidential election in 2024 51450.00 Social Security Contributions 6,459 6,459 863 (5,596) (86.64) 51451.00 Medicare Contributions 1,510 1,510 202 (1,308) (86.62) 51477.00 Workers Compensation Insurance 691 691 79 (612) (88.57) PERSONAL SERVICES 121 112,832 112,832 15,064 (97,768) (86.65) CURRENT EXPENDITURES 52050.00 Operating Supplies 62 1,500 1,500 7,500 6,000 400.00 special election for referendum 52400.10 Small Equipment - General 24,938 4,500 4,500 1,000 (3,500) (77.78)misc equipment, absentee laptops in 2024 53310.10 Training and Employee Development 395 7,500 7,500 (7,500) (100.00)meals moved to misc exp 54320.00 Miscellaneous Expense 4,000 4,000 moved meals out of Training CURRENT EXPENDITURES 25,395 13,500 13,500 12,500 (1,000) (7.41) Totals for dept 41410.00 - ELECTIONS 25,516 126,332 126,332 27,564 (98,768) (78.18) Dept 41520.00 - FINANCE PERSONAL SERVICES 51100.01 Wages - Full Time 477,010 540,563 540,563 592,585 52,022 9.62 COLA and step increase; Assistant Finance Director to full time in 2025 51208.01 Sick Leave - Buy Down 16,233 51400.00 Compensated Absences 2,793 3,514 3,514 4,444 930 26.47 Increased compensated leave % 51450.00 Social Security Contributions 28,155 33,515 33,515 36,740 3,225 9.62 51451.00 Medicare Contributions 6,585 7,838 7,838 8,592 754 9.62 51460.00 PERA Contributions 34,916 40,542 40,542 44,444 3,902 9.62 51470.00 Health Insurance 45,919 70,470 70,470 59,097 (11,373) (16.14)Based on current employee selections 51472.00 Retiree HCSP Contributions 1,505 1,800 1,800 2,100 300 16.67 51473.00 Dental Insurance 1,012 2,479 2,479 2,430 (49) (1.98) 51474.00 Life Insurance 296 342 342 342 51477.00 Workers Compensation Insurance 3,891 3,479 3,479 3,255 (224) (6.44)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 618,315 704,542 704,542 754,029 49,487 7.02 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget CURRENT EXPENDITURES 52010.00 Office Supplies 2,409 1,585 1,585 1,650 65 4.10 52400.10 Small Equipment - General 6,355 3,000 3,000 4,800 1,800 60.00 53100.80 Professional Services - General 19,125 4,500 4,500 4,500 53120.10 Bank Service Fees 4,158 9,000 9,000 6,000 (3,000) (33.33) 53210.00 Telecommunications 570 570 (570) (100.00) 53310.10 Training and Employee Development 2,642 4,585 10,585 4,500 (6,085) (57.49) 54020.00 Software Service Contract 6,500 7,150 7,150 11,000 3,850 53.85 Debtbook 54310.00 Memberships and Subscriptions 489 2,380 2,380 2,206 (174) (7.31) 54320.00 Miscellaneous Expense (335) 300 300 300 CURRENT EXPENDITURES 41,343 33,070 39,070 34,956 (4,114) (10.53) Totals for dept 41520.00 - FINANCE 659,658 737,612 743,612 788,985 45,373 6.10 Dept 41540.00 - INTERNAL AUDITING CURRENT EXPENDITURES 53010.00 Audit Services 47,345 44,700 44,700 50,100 5,400 12.08 Plan for single audit in 2025 for 2024 federal grants CURRENT EXPENDITURES 47,345 44,700 44,700 50,100 5,400 12.08 Totals for dept 41540.00 - INTERNAL AUDITING 47,345 44,700 44,700 50,100 5,400 12.08 Dept 41550.00 - ASSESSING CURRENT EXPENDITURES 53100.50 Professional Services - Property Assessm 235,200 249,300 249,300 267,000 17,700 7.10 53100.80 Professional Services - General 3,429 9,275 9,275 4,705 (4,570) (49.27) CURRENT EXPENDITURES 238,629 258,575 258,575 271,705 13,130 5.08 Totals for dept 41550.00 - ASSESSING 238,629 258,575 258,575 271,705 13,130 5.08 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget Dept 41610.00 - LEGAL CURRENT EXPENDITURES 53020.00 Legal Services 130,244 140,000 140,000 155,000 15,000 10.71 53020.10 Legal Services - Lobbying 49,000 49,000 49,000 49,000 53030.00 Prosecution Services 50,805 78,214 78,214 89,945 11,731 15.00 54020.00 Software Service Contract CURRENT EXPENDITURES 230,049 267,214 267,214 293,945 26,731 10.00 Totals for dept 41610.00 - LEGAL 230,049 267,214 267,214 293,945 26,731 10.00 Dept 41820.00 - HUMAN RESOURCES PERSONAL SERVICES 51100.01 Wages - Full Time 251,247 247,131 247,131 259,847 12,716 5.15 COLA and step increase 51100.03 Wages - Seasonal/Temporary 51110.01 Overtime - Full Time 51208.01 Sick Leave - Buy Down 8,563 51220.01 Allowances - Auto Allowance 51400.00 Compensated Absences 1,452 1,606 1,606 1,949 343 21.36 Increased compensated leave % 51450.00 Social Security Contributions 15,129 15,322 15,322 16,111 789 5.15 51451.00 Medicare Contributions 3,538 3,583 3,583 3,768 185 5.16 51460.00 PERA Contributions 18,149 18,535 18,535 19,489 954 5.15 51470.00 Health Insurance 18,918 26,985 26,985 23,576 (3,409) (12.63)Based on current employee selections 51472.00 Retiree HCSP Contributions 665 720 720 840 120 16.67 51473.00 Dental Insurance 931 970 970 945 (25) (2.58) 51474.00 Life Insurance 122 122 122 122 51477.00 Workers Compensation Insurance 1,749 1,528 1,528 1,369 (159) (10.41)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 320,463 316,502 316,502 328,016 11,514 3.64 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget CURRENT EXPENDITURES 52010.00 Office Supplies 289 250 250 250 53100.80 Professional Services - General 42,865 17,000 17,000 42,000 25,000 147.06 comp study 53110.00 Benefits Administration Fees 5,382 8,000 8,000 8,000 53210.00 Telecommunications 1,070 1,100 1,100 480 (620) (56.36) 53310.10 Training and Employee Development 12,187 10,000 10,000 8,000 (2,000) (20.00) 53520.00 Public Educational Information 54310.00 Memberships and Subscriptions 1,700 500 500 250 (250) (50.00) 54320.00 Miscellaneous Expense 11,815 11,000 11,000 12,000 1,000 9.09 CURRENT EXPENDITURES 75,308 47,850 47,850 70,980 23,130 48.34 Totals for dept 41820.00 - HUMAN RESOURCES 395,771 364,352 364,352 398,996 34,644 9.51 Dept 41830.00 - COMMUNICATIONS PERSONAL SERVICES 51100.01 Wages - Full Time 102,666 110,541 110,541 118,680 8,139 7.36 COLA and step increase 51100.02 Wages - Part Time 2,350 3,276 3,276 51100.03 Wages - Seasonal/Temporary 3,120 3,120 (3,120) (100.00) 51208.01 Sick Leave - Buy Down 51400.00 Compensated Absences 616 719 719 890 171 23.78 Increased compensated leave % 51450.00 Social Security Contributions 6,485 7,047 7,047 7,561 514 7.29 51451.00 Medicare Contributions 1,517 1,648 1,648 1,768 120 7.28 51460.00 PERA Contributions 7,700 8,291 8,291 8,901 610 7.36 51470.00 Health Insurance 9,459 10,485 10,485 11,788 1,303 12.43 51472.00 Retiree HCSP Contributions 280 360 360 420 60 16.67 51473.00 Dental Insurance 588 540 540 473 (67) (12.41) 51474.00 Life Insurance 68 68 68 68 51476.00 MN Unemployment Insurance 51477.00 Workers Compensation Insurance 538 603 603 553 (50) (8.29)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 132,267 143,422 143,422 154,378 10,956 7.64 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget CURRENT EXPENDITURES 52010.00 Office Supplies 352 52050.00 Operating Supplies 52200.01 Repair & Maint Supplies - General 1,000 1,000 500 (500) (50.00) 52400.20 Small Equipment - Technology 53100.80 Professional Services - General 2,230 3,000 3,000 2,500 (500) (16.67) 53210.00 Telecommunications 1,346 600 600 53310.10 Training and Employee Development 53520.00 Public Educational Information 2,979 7,000 7,000 4,000 (3,000) (42.86) 54010.04 Maint Agreements - Equipment 400 6,000 6,000 (6,000) (100.00) 54020.00 Software Service Contract 8,399 2,000 2,000 9,400 7,400 370.00 54310.00 Memberships and Subscriptions 461 750 750 500 (250) (33.33) 54320.00 Miscellaneous Expense 386 2,000 2,000 1,000 (1,000) (50.00) CURRENT EXPENDITURES 16,553 21,750 21,750 18,500 (3,250) (14.94) CAPITAL OUTLAY 55570.00 Machinery and Equipment CAPITAL OUTLAY Totals for dept 41830.00 - COMMUNICATIONS 148,820 165,172 165,172 172,878 7,706 4.67 Dept 41910.00 - COMMUNITY DEVELOPMENT PERSONAL SERVICES 51100.01 Wages - Full Time 220,753 261,744 261,744 271,605 9,861 3.77 51110.01 Overtime - Full Time 2,000 2,000 2,000 51208.01 Sick Leave - Buy Down 18,247 1,371 1,371 1,065 (306) (22.32) 51301.00 Accrued Comp Time 51400.00 Compensated Absences 1,311 1,701 1,701 2,037 336 19.75 Increased compensated leave % 51450.00 Social Security Contributions 13,014 16,437 16,437 17,029 592 3.60 51451.00 Medicare Contributions 3,044 3,844 3,844 3,983 139 3.62 51460.00 PERA Contributions 16,404 19,781 19,781 20,520 739 3.74 51470.00 Health Insurance 27,750 38,127 38,127 36,438 (1,689) (4.43)Based on current employee selections 51472.00 Retiree HCSP Contributions 624 744 744 918 174 23.39 51473.00 Dental Insurance 1,261 1,411 1,411 1,421 10 0.71 51474.00 Life Insurance 168 198 198 184 (14) (7.07) 51477.00 Workers Compensation Insurance 1,444 1,492 1,492 1,321 (171) (11.46)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 304,020 348,850 348,850 358,521 9,671 2.77 CURRENT EXPENDITURES 52010.00 Office Supplies 2,469 2,000 2,000 2,000 52050.00 Operating Supplies 134 150 150 150 52400.10 Small Equipment - General 48 150 150 150 52400.20 Small Equipment - Technology 216 1,500 1,500 1,000 (500) (33.33) 53100.80 Professional Services - General 1,010 10,000 10,000 (10,000) (100.00)moved to EDA 53210.00 Telecommunications 250 250 150 (100) (40.00) 53310.10 Training and Employee Development 116 1,000 1,000 750 (250) (25.00) 54010.04 Maint Agreements - Equipment 54010.53 Maint Agreements Landscape 54020.00 Software Service Contract 198 750 750 750 54060.00 Rentals - Office Equip. 54310.00 Memberships and Subscriptions 1,500 1,500 750 (750) (50.00) 54320.00 Miscellaneous Expense 2,054 1,500 1,500 2,000 500 33.33 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget 54325.00 Tax Abatement 22,086 30,000 30,000 30,000 CURRENT EXPENDITURES 28,331 48,800 48,800 37,700 (11,100) (22.75) CAPITAL OUTLAY 55570.00 Machinery and Equipment CAPITAL OUTLAY Totals for dept 41910.00 - COMMUNITY DEVELOPMENT 332,351 397,650 397,650 396,221 (1,429) (0.36) Dept 41920.00 - INFORMATION TECHNOLOGY PERSONAL SERVICES 51100.01 Wages - Full Time 189,437 200,721 200,721 211,510 10,789 5.38 51208.01 Sick Leave - Buy Down 51400.00 Compensated Absences 1,137 1,305 1,305 1,586 281 21.53 Increased compensated leave % 51450.00 Social Security Contributions 11,584 12,445 12,445 13,114 669 5.38 51451.00 Medicare Contributions 2,709 2,910 2,910 3,067 157 5.40 51460.00 PERA Contributions 14,208 15,054 15,054 15,863 809 5.37 51470.00 Health Insurance 18,918 20,970 20,970 23,576 2,606 12.43 51472.00 Retiree HCSP Contributions 630 720 720 840 120 16.67 51473.00 Dental Insurance 1,176 970 970 1,013 43 4.43 51474.00 Life Insurance 122 122 122 122 51477.00 Workers Compensation Insurance 960 1,066 1,066 960 (106) (9.94)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 240,881 256,283 256,283 271,651 15,368 6.00 CURRENT EXPENDITURES 52010.00 Office Supplies 456 52050.00 Operating Supplies 52200.01 Repair & Maint Supplies - General 5,287 14,000 14,000 14,000 52400.20 Small Equipment - Technology 35,895 45,950 53,373 67,300 13,927 26.09 laptop replacements - these were laptops purchased during COVID 53100.60 Professional Services - Software Design 53100.80 Professional Services - General 7,856 17,500 17,500 45,000 27,500 157.14 MS server $22k, card reader City Hall $4k 53210.00 Telecommunications 2,405 3,610 3,610 3,200 (410) (11.36) 53310.10 Training and Employee Development 4,592 4,000 4,000 4,000 54020.00 Software Service Contract 124,940 171,570 171,570 156,410 (15,160) (8.84)PY had VM license for PD server of $15k 54030.00 Hardware Service Contract 2,406 5,000 5,000 5,000 CURRENT EXPENDITURES 183,837 261,630 269,053 294,910 25,857 9.61 CAPITAL OUTLAY 55570.00 Machinery and Equipment 31,662 87,500 87,500 20,000 (67,500) (77.14)PY - City Hall network switch $50k, PD VM server $30k, CY - 2 copiers $10k each 55580.00 Software 1,640 CAPITAL OUTLAY 33,302 87,500 87,500 20,000 (67,500) (77.14) Totals for dept 41920.00 - INFORMATION TECHNOLOGY 458,020 605,413 612,836 586,561 (26,275) (4.29) Dept 41940.00 - FACILITIES - CITY HALL PERSONAL SERVICES 51100.01 Wages - Full Time 67,174 69,850 69,850 75,773 5,923 8.48 COLA and step increase 51100.02 Wages - Part Time 51110.01 Overtime - Full Time 739 5,241 5,241 2,000 (3,241) (61.84)Based on historical 51400.00 Compensated Absences 403 454 454 568 114 25.11 Increased compensated leave % 51450.00 Social Security Contributions 4,177 4,656 4,656 4,822 166 3.57 51451.00 Medicare Contributions 977 1,089 1,089 1,128 39 3.58 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget 51460.00 PERA Contributions 5,094 5,239 5,239 5,683 444 8.47 51470.00 Health Insurance 9,459 10,485 10,485 11,788 1,303 12.43 51472.00 Retiree HCSP Contributions 300 240 240 300 60 25.00 51473.00 Dental Insurance 540 430 430 473 43 10.00 51474.00 Life Insurance 54 54 54 54 51477.00 Workers Compensation Insurance 2,820 3,955 3,955 3,482 (473) (11.96)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 91,737 101,693 101,693 106,071 4,378 4.31 CURRENT EXPENDITURES 52010.00 Office Supplies 8,000 8,000 12,000 4,000 50.00 52055.00 Uniforms/Personal Protective Equipment 650 650 52200.01 Repair & Maint Supplies - General 52200.02 Repair & Maint Supplies - Building 11,938 52,000 52,000 53,200 1,200 2.31 53100.80 Professional Services - General 9,000 9,000 9,000 9,000 53210.00 Telecommunications 15,986 17,160 17,160 16,800 (360) (2.10) 53220.00 Postage/Shipping 6,189 8,840 8,840 7,000 (1,840) (20.81) 53310.10 Training and Employee Development 1,525 1,525 1,525 53610.00 Insurance - Gen Liability 136,554 121,350 121,350 131,040 9,690 7.99 increase in rates 53620.00 Insurance - Property 121,779 128,330 128,330 152,190 23,860 18.59 increase in rates 53810.00 Utilities - Electric 57,603 76,900 76,900 51,390 (25,510) (33.17) lower estimates in CY based on 2024 actual and estimates 53820.00 Utilities - Gas 22,024 39,794 39,794 28,300 (11,494) (28.88) lower estimates in CY based on 2024 actual and estimates 53830.00 Utilities - Refuse Disposal 1,855 9,600 9,600 17,500 7,900 82.29 refuse disposal increased $7.9k from 2024 to 2025 54010.02 Maint Agreements - Buildings 40,701 205,025 205,025 176,125 (28,900) (14.10) PY - card reader updates $15k, window repair FS1 $15k 54010.04 Maint Agreements - Equipment 864 900 900 900 54010.05 Maint Agreements - Cleaning 53,720 113,000 113,000 120,000 7,000 6.19 54020.00 Software Service Contract 5,686 6,000 6,000 6,500 500 8.33 54060.00 Rentals - Office Equip. 54320.00 Miscellaneous Expense CURRENT EXPENDITURES 483,899 797,424 797,424 784,120 (13,304) (1.67) CAPITAL OUTLAY 55560.00 Furniture and Office Equipment 2,835 3,500 3,500 3,500 55570.00 Machinery and Equipment CAPITAL OUTLAY 2,835 3,500 3,500 3,500 Totals for dept 41940.00 - FACILITIES - CITY HALL 578,471 902,617 902,617 893,691 (8,926) (0.99) Dept 42100.00 - POLICE PERSONAL SERVICES 51100.01 Wages - Full Time 3,521,867 3,927,875 3,927,875 4,135,065 207,190 5.27 51100.02 Wages - Part Time 63,803 85,657 85,657 91,428 5,771 6.74 51100.03 Wages - Seasonal/Temporary 27,270 28,350 28,350 51110.01 Overtime - Full Time 483,954 514,160 514,160 568,312 54,152 10.53 Based on historical 51110.03 Overtime - Seasonal/Temporary 51110.04 Overtime - Training 64,572 51208.01 Sick Leave - Buy Down 63,239 7,644 7,644 4,093 (3,551) (46.45)Based on current employees 51220.02 Allowance - Clothing 28,341 34,982 34,982 37,522 2,540 7.26 51301.00 Accrued Comp Time 51302.00 Accrued Holiday Pay 51400.00 Compensated Absences 22,438 26,088 26,088 31,699 5,611 21.51 Increased compensated leave % 51450.00 Social Security Contributions 25,116 28,028 28,028 30,861 2,833 10.11 51451.00 Medicare Contributions 58,552 66,270 66,270 69,995 3,725 5.62 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget 51460.00 PERA Contributions 680,642 755,290 755,290 800,801 45,511 6.03 51470.00 Health Insurance 383,277 472,573 472,573 526,427 53,854 11.40 51472.00 Retiree HCSP Contributions 13,043 9,960 9,960 16,080 6,120 61.45 51473.00 Dental Insurance 19,203 18,300 18,300 18,969 669 3.66 51474.00 Life Insurance 2,467 2,480 2,480 2,606 126 5.08 51476.00 MN Unemployment Insurance 51477.00 Workers Compensation Insurance 202,386 289,549 289,549 265,350 (24,199) (8.36)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 5,660,170 6,238,856 6,238,856 6,627,558 388,702 6.23 CURRENT EXPENDITURES 52010.00 Office Supplies 9,706 11,475 11,475 11,750 275 2.40 52050.00 Operating Supplies 13,265 26,500 26,500 19,750 (6,750) (25.47) 52050.11 Operating Supplies - Shop w/ Cop 1,994 1,000 1,000 2,000 1,000 100.00 52051.00 Fuel 59,597 100,400 100,400 87,885 (12,515) (12.47) 52055.00 Uniforms/Personal Protective Equipment 48,146 52,900 52,900 49,300 (3,600) (6.81) 52200.01 Repair & Maint Supplies - General 2,516 10,500 10,500 10,500 52200.02 Repair & Maint Supplies - Building 4,858 52400.10 Small Equipment - General 39,714 71,875 89,875 81,550 (8,325) (9.26) 52400.20 Small Equipment - Technology 10,939 28,950 53,450 5,000 (48,450) (90.65)PY - computer compliance upgrades, CY - new sergeant equipment 53025.00 County Court Fines (pass-through to Co.) 53040.00 Personnel Testing and Recruitment 1,860 25,000 25,000 25,000 53100.80 Professional Services - General 48,842 99,600 99,600 61,600 (38,000) (38.15)PY - scheduling study of $42k 53210.00 Telecommunications 28,862 33,520 33,520 36,120 2,600 7.76 53230.00 Telecommunications Equipment 1,620 1,500 1,500 1,500 53310.10 Training and Employee Development 73,938 93,544 96,044 104,050 8,006 8.34 53630.00 Insurance - Auto 3,481 7,065 7,065 5,141 (1,924) (27.23) 53810.00 Utilities - Electric 35,949 34,850 34,850 31,350 (3,500) (10.04) 53820.00 Utilities - Gas 15,323 17,938 17,938 17,400 (538) (3.00) 53830.00 Utilities - Refuse Disposal 1,143 54010.02 Maint Agreements - Buildings 24,378 54010.04 Maint Agreements - Equipment 1,383 5,389 5,389 7,389 2,000 37.11 54010.05 Maint Agreements - Cleaning 17,811 54020.00 Software Service Contract 164,402 201,445 201,445 224,965 23,520 11.68 axon contract increased $20k 54035.00 Technology - New 54080.00 Rentals - Facility 22,175 22,000 22,000 22,000 54300.00 Special Response Team SRT 21,177 30,600 30,600 31,100 500 1.63 54310.00 Memberships and Subscriptions 3,941 4,985 4,985 6,855 1,870 37.51 54320.00 Miscellaneous Expense 2,278 CURRENT EXPENDITURES 659,298 881,036 926,036 842,205 (83,831) (9.05) CAPITAL OUTLAY 55520.00 Building & Building Improvements 3,000 3,000 3,000 55550.00 Vehicles 55560.00 Furniture and Office Equipment 4,638 42,640 42,640 11,000 (31,640) (74.20)PY - lockers, fridge $32k 55570.00 Machinery and Equipment 15,036 42,900 50,000 7,100 16.55 CAPITAL OUTLAY 19,674 45,640 88,540 64,000 (24,540) (27.72) Totals for dept 42100.00 - POLICE 6,339,142 7,165,532 7,253,432 7,533,763 280,331 3.86 Dept 42200.00 - FIRE PERSONAL SERVICES 51100.01 Wages - Full Time 666,029 1,164,351 1,164,351 1,380,469 216,118 18.56 COLA and step increases; new Fire Marshal position 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget 51100.09 Wages - Paid On Call (firefighters)162,346 152,355 152,355 115,710 (36,645) (24.05)Based on 2024 actuals 51110.01 Overtime - Full Time 49,792 87,745 87,745 96,306 8,561 9.76 51208.01 Sick Leave - Buy Down 1,858 2,233 2,233 1,932 (301) (13.48)Based on current employees 51400.00 Compensated Absences 4,159 7,568 7,568 10,354 2,786 36.81 51450.00 Social Security Contributions 10,065 8,578 8,578 7,174 (1,404) (16.37)Based on POC wages 51451.00 Medicare Contributions 12,280 20,194 20,194 23,119 2,925 14.48 51460.00 PERA Contributions 126,700 222,016 222,016 261,389 39,373 17.73 51461.01 Fire Relief Pension Contribution 20,000 51461.02 Fire Relief Pension Contributions State 334,993 299,835 299,835 348,527 48,692 16.24 51470.00 Health Insurance 77,633 221,431 221,431 208,212 (13,219) (5.97)Based on current employee selections 51472.00 Retiree HCSP Contributions 927 4,950 4,950 3,675 (1,275) (25.76) 51473.00 Dental Insurance 3,300 7,425 7,425 7,375 (50) (0.67) 51474.00 Life Insurance 447 941 941 951 10 1.06 51476.00 MN Unemployment Insurance 51477.00 Workers Compensation Insurance 89,025 155,309 155,309 132,749 (22,560) (14.53)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 1,559,554 2,354,931 2,354,931 2,597,942 243,011 10.32 CURRENT EXPENDITURES 52010.00 Office Supplies 14,654 15,000 15,000 17,000 2,000 13.33 52050.00 Operating Supplies 24,949 25,000 25,000 32,000 7,000 28.00 52051.00 Fuel 16,475 22,000 22,000 22,225 225 1.02 52055.00 Uniforms/Personal Protective Equipment 54,510 57,000 57,000 64,000 7,000 12.28 52200.01 Repair & Maint Supplies - General 2,071 12,000 12,000 14,000 2,000 16.67 52200.02 Repair & Maint Supplies - Building 11,867 52400.10 Small Equipment - General 36,019 47,000 47,000 52,000 5,000 10.64 53210.00 Telecommunications 7,771 6,120 6,120 6,120 53310.10 Training and Employee Development 39,844 45,000 45,000 52,000 7,000 15.56 53520.00 Public Educational Information 5,231 8,000 8,000 8,000 53630.00 Insurance - Auto 11,487 12,635 12,635 15,050 2,415 19.11 53810.00 Utilities - Electric 24,430 27,270 27,270 23,990 (3,280) (12.03) 53820.00 Utilities - Gas 18,806 20,602 20,602 13,700 (6,902) (33.50) 53830.00 Utilities - Refuse Disposal 2,609 54010.02 Maint Agreements - Buildings 40,414 54010.04 Maint Agreements - Equipment 52,692 60,000 60,000 64,000 4,000 6.67 54010.05 Maint Agreements - Cleaning 5,630 54020.00 Software Service Contract 12,794 54035.00 Technology - New 54080.00 Rentals - Facility 22,175 22,000 22,000 22,000 54310.00 Memberships and Subscriptions 5,713 8,000 8,000 23,000 15,000 187.50 fees up due to increased staff 54320.00 Miscellaneous Expense 3,573 6,500 6,500 6,900 400 6.15 CURRENT EXPENDITURES 413,714 394,127 394,127 435,985 41,858 10.62 CAPITAL OUTLAY 55520.00 Building & Building Improvements 8,684 55570.00 Machinery and Equipment 20,017 (20,017) (100.00) CAPITAL OUTLAY 8,684 20,017 (20,017) (100.00) Totals for dept 42200.00 - FIRE 1,981,952 2,749,058 2,769,075 3,033,927 264,852 9.56 Dept 42400.00 - BUILDING INSPECTION PERSONAL SERVICES 51100.01 Wages - Full Time 564,913 579,982 579,982 627,602 47,620 8.21 COLA and step increases 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget 51100.02 Wages - Part Time 35,116 45,127 45,127 48,941 3,814 8.45 COLA and step increases 51100.03 Wages - Seasonal/Temporary 1,947 51110.01 Overtime - Full Time 103 2,000 2,000 500 (1,500) (75.00)Based on historical 51208.01 Sick Leave - Buy Down 217 263 263 266 3 1.14 51400.00 Compensated Absences 2,902 4,063 4,063 5,074 1,011 24.88 Increased compensated leave % 51450.00 Social Security Contributions 33,553 38,897 38,897 41,993 3,096 7.96 51451.00 Medicare Contributions 8,234 9,097 9,097 9,821 724 7.96 51460.00 PERA Contributions 47,633 50,034 50,034 54,061 4,027 8.05 51470.00 Health Insurance 76,327 89,216 89,216 89,116 (100) (0.11) 51472.00 Retiree HCSP Contributions 2,117 1,926 1,926 2,367 441 22.90 51473.00 Dental Insurance 3,786 3,516 3,516 3,203 (313) (8.90)Based on current employee selections 51474.00 Life Insurance 484 503 503 488 (15) (2.98) 51476.00 MN Unemployment Insurance 5,769 51477.00 Workers Compensation Insurance 6,313 5,878 5,878 5,425 (453) (7.71)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 789,414 830,502 830,502 888,857 58,355 7.03 CURRENT EXPENDITURES 52010.00 Office Supplies 778 1,500 1,500 1,500 52050.00 Operating Supplies 200 200 200 52051.00 Fuel 4,324 8,000 8,000 7,000 (1,000) (12.50) 52055.00 Uniforms/Personal Protective Equipment 289 1,250 1,250 1,250 52400.10 Small Equipment - General 1,500 1,500 1,500 53100.80 Professional Services - General 10,000 10,000 10,000 53210.00 Telecommunications 1,932 2,120 2,120 2,220 100 4.72 53310.10 Training and Employee Development 2,711 4,500 4,500 6,000 1,500 33.33 53630.00 Insurance - Auto 330 330 330 451 121 36.67 54010.04 Maint Agreements - Equipment 250 250 250 54310.00 Memberships and Subscriptions 213 500 500 250 (250) (50.00) 54320.00 Miscellaneous Expense 1,199 1,500 1,500 1,500 CURRENT EXPENDITURES 11,776 31,650 31,650 32,121 471 1.49 CAPITAL OUTLAY 55550.00 Vehicles CAPITAL OUTLAY Totals for dept 42400.00 - BUILDING INSPECTION 801,190 862,152 862,152 920,978 58,826 6.82 Dept 42500.00 - EMERGENCY MANAGEMENT CURRENT EXPENDITURES 53310.10 Training and Employee Development 7,370 5,000 5,000 7,500 2,500 50.00 53810.00 Utilities - Electric 768 840 840 680 (160) (19.05) 54010.04 Maint Agreements - Equipment 9,525 9,500 9,500 9,500 CURRENT EXPENDITURES 17,663 15,340 15,340 17,680 2,340 15.25 Totals for dept 42500.00 - EMERGENCY MANAGEMENT 17,663 15,340 15,340 17,680 2,340 15.25 Dept 42700.00 - ANIMAL CONTROL CURRENT EXPENDITURES 53100.10 Professional Services - Animal Control 28,800 36,000 36,000 36,000 CURRENT EXPENDITURES 28,800 36,000 36,000 36,000 Totals for dept 42700.00 - ANIMAL CONTROL 28,800 36,000 36,000 36,000 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget Dept 43050.00 - ENGINEERING PERSONAL SERVICES 51100.01 Wages - Full Time 285,443 303,607 303,607 302,876 (731) (0.24)Recently filled position lower than budgeted in 2024 51100.02 Wages - Part Time 51100.03 Wages - Seasonal/Temporary 51110.01 Overtime - Full Time 14,759 9,000 9,000 9,000 51208.01 Sick Leave - Buy Down 1,508 1,970 1,970 1,568 (402) (20.41)Based on current employees 51301.00 Accrued Comp Time 51400.00 Compensated Absences 1,713 1,973 1,973 2,272 299 15.15 Increased compensated leave % 51450.00 Social Security Contributions 18,008 19,504 19,504 19,434 (70) (0.36) 51451.00 Medicare Contributions 4,212 4,561 4,561 4,545 (16) (0.35) 51460.00 PERA Contributions 22,515 23,446 23,446 23,391 (55) (0.23) 51470.00 Health Insurance 28,592 35,434 35,434 40,225 4,791 13.52 51472.00 Retiree HCSP Contributions 957 630 630 775 145 23.02 51473.00 Dental Insurance 1,436 1,280 1,280 1,424 144 11.25 51474.00 Life Insurance 195 195 195 195 51477.00 Workers Compensation Insurance 155 2,045 2,045 1,734 (311) (15.21)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 379,493 403,645 403,645 407,439 3,794 0.94 CURRENT EXPENDITURES 52010.00 Office Supplies 2,680 3,750 3,750 3,750 52050.00 Operating Supplies 68 900 900 1,000 100 11.11 52051.00 Fuel 1,653 8,000 8,000 5,250 (2,750) (34.38) 52055.00 Uniforms/Personal Protective Equipment 1,153 750 750 1,500 750 100.00 52400.10 Small Equipment - General 7,570 4,100 4,100 2,500 (1,600) (39.02) 53100.20 Professional Services - Engineering 56,566 33,000 33,000 40,000 7,000 21.21 53100.80 Professional Services - General 53210.00 Telecommunications 1,975 3,000 3,000 3,000 53310.10 Training and Employee Development 2,794 4,500 4,500 5,600 1,100 24.44 53630.00 Insurance - Auto 323 320 320 442 122 38.13 54010.04 Maint Agreements - Equipment 1,000 1,000 1,000 54020.00 Software Service Contract 7,386 8,100 8,100 8,600 500 6.17 54310.00 Memberships and Subscriptions 279 500 500 500 54320.00 Miscellaneous Expense 628 400 400 400 CURRENT EXPENDITURES 83,075 68,320 68,320 73,542 5,222 7.64 Totals for dept 43050.00 - ENGINEERING 462,568 471,965 471,965 480,981 9,016 1.91 Dept 43100.00 - STREET PERSONAL SERVICES 51100.01 Wages - Full Time 373,886 403,605 403,605 430,595 26,990 6.69 51100.03 Wages - Seasonal/Temporary 51110.01 Overtime - Full Time 16,539 20,800 20,800 17,500 (3,300) (15.87)Based on historical 51205.01 Other Pay - Awards 51208.01 Sick Leave - Buy Down 1,190 1,223 1,223 619 (604) (49.39)Based on current employees 51301.00 Accrued Comp Time 51400.00 Compensated Absences 2,227 2,623 2,623 3,229 606 23.10 Increased compensated leave % 51450.00 Social Security Contributions 22,386 26,389 26,389 27,820 1,431 5.42 51451.00 Medicare Contributions 5,236 6,172 6,172 6,506 334 5.41 51460.00 PERA Contributions 29,282 31,830 31,830 33,607 1,777 5.58 51470.00 Health Insurance 53,011 58,787 58,787 63,653 4,866 8.28 51472.00 Retiree HCSP Contributions 1,246 1,044 1,044 1,278 234 22.41 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget 51473.00 Dental Insurance 2,370 2,207 2,207 2,309 102 4.62 51474.00 Life Insurance 302 311 311 311 51477.00 Workers Compensation Insurance 17,788 27,020 27,020 22,341 (4,679) (17.32)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 525,463 582,011 582,011 609,768 27,757 4.77 CURRENT EXPENDITURES 52010.00 Office Supplies 891 2,500 2,500 2,000 (500) (20.00) 52050.00 Operating Supplies 1,441 4,000 4,000 3,000 (1,000) (25.00) 52051.00 Fuel 48,748 120,000 120,000 97,300 (22,700) (18.92) 52052.00 Shop Material 462 7,500 7,500 6,500 (1,000) (13.33) 52054.00 Snow and Ice Management 171,050 175,700 175,700 175,875 175 0.10 52055.00 Uniforms/Personal Protective Equipment 5,391 6,325 6,325 5,900 (425) (6.72) 52200.01 Repair & Maint Supplies - General 130,734 184,500 184,500 167,500 (17,000) (9.21)'class 5' down $15k from PY 52200.02 Repair & Maint Supplies - Building 8,785 5,000 5,000 5,000 52400.10 Small Equipment - General 1,016 5,000 5,000 5,000 52400.20 Small Equipment - Technology 300 52400.30 Small Equipment - Safety 881 7,000 7,000 7,000 53100.20 Professional Services - Engineering 11,500 11,500 42,000 30,500 265.22 CH21 corridor study $30k 53100.80 Professional Services - General 4,000 4,000 53210.00 Telecommunications 2,536 3,000 3,000 3,000 53310.10 Training and Employee Development 11,878 13,600 13,600 13,600 53630.00 Insurance - Auto 8,565 15,800 15,800 12,337 (3,463) (21.92) 53810.00 Utilities - Electric 8,369 53830.00 Utilities - Refuse Disposal 53840.00 Utilities - Street Lighting 239,408 241,670 241,670 242,270 600 0.25 54010.01 Maint Agreements - General 305,037 334,500 424,500 334,500 (90,000) (21.20)PY - amended for $90k for pvmt mgmt project 54020.00 Software Service Contract 18,047 29,100 29,100 29,600 500 1.72 54040.00 Dust Control 13,322 18,000 18,000 18,000 54070.00 Rentals - Heavy Equipment 5,245 7,500 7,500 7,500 54310.00 Memberships and Subscriptions 829 2,100 2,100 2,100 54320.00 Miscellaneous Expense CURRENT EXPENDITURES 982,935 1,194,295 1,284,295 1,183,982 (100,313) (7.81) CAPITAL OUTLAY 55570.00 Machinery and Equipment CAPITAL OUTLAY Totals for dept 43100.00 - STREET 1,508,398 1,776,306 1,866,306 1,793,750 (72,556) (3.89) Dept 43400.00 - CENTRAL GARAGE PERSONAL SERVICES 51100.01 Wages - Full Time 199,535 209,575 209,575 225,782 16,207 7.73 COLA and step increases 51100.02 Wages - Part Time 51100.03 Wages - Seasonal/Temporary 51110.01 Overtime - Full Time 76 3,000 3,000 3,000 51208.01 Sick Leave - Buy Down 984 1,011 1,011 1,024 13 1.29 51301.00 Accrued Comp Time 51400.00 Compensated Absences 953 1,362 1,362 1,693 331 24.30 Increased compensated leave % 51450.00 Social Security Contributions 10,656 13,242 13,242 14,248 1,006 7.60 51451.00 Medicare Contributions 2,492 3,097 3,097 3,332 235 7.59 51460.00 PERA Contributions 14,971 15,943 15,943 17,159 1,216 7.63 51470.00 Health Insurance 34,681 37,391 37,391 38,176 785 2.10 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget 51472.00 Retiree HCSP Contributions 772 613 613 767 154 25.12 51473.00 Dental Insurance 1,080 1,318 1,318 1,342 24 1.82 51474.00 Life Insurance 176 175 175 175 51477.00 Workers Compensation Insurance 5,112 6,773 6,773 6,196 (577) (8.52)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 271,488 293,500 293,500 312,894 19,394 6.61 CURRENT EXPENDITURES 52010.00 Office Supplies 6 250 250 250 52050.00 Operating Supplies 6,700 8,000 8,000 8,000 52051.00 Fuel (13,582) 52052.00 Shop Material 1,133 3,500 3,500 3,500 52055.00 Uniforms/Personal Protective Equipment 3,455 5,350 5,350 4,350 (1,000) (18.69) 52200.01 Repair & Maint Supplies - General 194,196 189,250 189,250 199,750 10,500 5.55 slight increase in parts, equipment and tires 52400.10 Small Equipment - General 9,168 12,000 12,000 12,000 53210.00 Telecommunications 53310.10 Training and Employee Development 1,092 1,200 1,200 1,200 53830.00 Utilities - Refuse Disposal 2,207 3,000 3,000 3,000 54010.01 Maint Agreements - General 15,150 20,200 20,200 20,200 54020.00 Software Service Contract 4,729 4,900 4,900 5,300 400 8.16 54310.00 Memberships and Subscriptions 2,850 4,750 4,750 4,750 54320.00 Miscellaneous Expense 212 150 150 300 150 100.00 54810.00 Minor Service-Contract 5,866 8,000 8,000 8,000 54910.00 Major Service -Contract 37,558 45,000 45,000 50,000 5,000 11.11 avg cost of one full engine repair 59999.00 Contingency CURRENT EXPENDITURES 270,740 305,550 305,550 320,600 15,050 4.93 Totals for dept 43400.00 - CENTRAL GARAGE 542,228 599,050 599,050 633,494 34,444 5.75 Dept 43600.00 - DEVELOPMENT PROJECTS CAPITAL OUTLAY 55050.00 Projects - Professional Services 72,528 55060.00 Projects - Legal 55090.00 Projects - Reimburse City Charges CAPITAL OUTLAY 72,528 Totals for dept 43600.00 - DEVELOPMENT PROJECTS 72,528 Dept 45100.00 - RECREATION PERSONAL SERVICES 51100.01 Wages - Full Time 124,609 196,279 196,279 205,055 8,776 4.47 51100.02 Wages - Part Time 39,253 47,552 47,552 49,950 2,398 5.04 51100.03 Wages - Seasonal/Temporary 70,528 100,000 100,000 100,000 51110.01 Overtime - Full Time 51110.03 Overtime - Seasonal/Temporary 362 51208.01 Sick Leave - Buy Down 51301.00 Accrued Comp Time 51400.00 Compensated Absences 1,024 1,585 1,585 1,913 328 20.69 Increased compensated leave % 51450.00 Social Security Contributions 14,221 21,317 21,317 22,010 693 3.25 51451.00 Medicare Contributions 3,326 4,986 4,986 5,148 162 3.25 51460.00 PERA Contributions 12,290 18,287 18,287 19,125 838 4.58 51470.00 Health Insurance 15,555 33,218 33,218 30,376 (2,842) (8.56)Based on current employee selections 51472.00 Retiree HCSP Contributions 939 900 900 1,050 150 16.67 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget 51473.00 Dental Insurance 846 1,240 1,240 1,249 9 0.73 Based on current employee selections 51474.00 Life Insurance 173 164 164 157 (7) (4.27) 51476.00 MN Unemployment Insurance 51477.00 Workers Compensation Insurance 13,412 18,997 18,997 16,664 (2,333) (12.28)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 296,538 444,525 444,525 452,697 8,172 1.84 CURRENT EXPENDITURES 52010.00 Office Supplies 2,459 1,500 1,500 2,000 500 33.33 52010.01 Office Supplies - Club Prior 1,837 2,000 2,000 2,000 52050.00 Operating Supplies 23,490 22,000 22,000 25,000 3,000 13.64 52050.01 Operating - Club Prior Non-Rev Prog 5,506 12,000 12,000 7,000 (5,000) (41.67) 52050.02 Operating - Club Prior Rev Prog 23,050 10,000 10,000 20,000 10,000 100.00 vendor-related program expenses 52050.33 Operating - Charitable Gambling Exps 52055.00 Uniforms/Personal Protective Equipment 2,000 2,000 2,000 52056.00 Community Events 51,948 45,000 45,000 50,000 5,000 11.11 52400.20 Small Equipment - Technology 2,059 3,500 3,500 3,000 (500) (14.29) 52500.10 Concessions 53100.40 Professional Services - Instructors 28,003 30,000 30,000 35,000 5,000 16.67 53120.10 Bank Service Fees 647 53120.20 Merchant Card Fees 10,173 10,000 10,000 12,000 2,000 20.00 53210.00 Telecommunications 2,721 4,380 4,380 3,120 (1,260) (28.77) 53310.10 Training and Employee Development 6,535 8,000 8,000 8,000 53520.00 Public Educational Information 16,141 20,000 20,000 22,000 2,000 10.00 53630.00 Insurance - Auto 135 135 54010.02 Maint Agreements - Buildings 54010.05 Maint Agreements - Cleaning 6,194 54020.00 Software Service Contract 1,500 6,000 6,000 6,500 500 8.33 54070.00 Rentals - Heavy Equipment 3,150 4,600 4,600 4,600 54310.00 Memberships and Subscriptions 1,587 2,000 2,000 2,000 54310.10 Membershipts and Subscriptions 220 54320.00 Miscellaneous Expense 54 CURRENT EXPENDITURES 187,274 182,980 182,980 204,355 21,375 11.68 Totals for dept 45100.00 - RECREATION 483,812 627,505 627,505 657,052 29,547 4.71 Dept 45200.00 - PARKS PERSONAL SERVICES 51100.01 Wages - Full Time 663,657 704,558 704,558 746,197 41,639 5.91 51100.03 Wages - Seasonal/Temporary 165,853 195,000 195,000 195,000 51110.01 Overtime - Full Time 59,236 56,465 56,465 65,000 8,535 15.12 Based on historical 51110.03 Overtime - Seasonal/Temporary 2,541 3,000 3,000 (3,000) (100.00) 51208.01 Sick Leave - Buy Down 1,190 1,223 1,223 619 (604) (49.39)Based on current employees 51301.00 Accrued Comp Time 51400.00 Compensated Absences 4,132 4,580 4,580 5,596 1,016 22.18 Increased compensated leave % 51450.00 Social Security Contributions 53,153 59,535 59,535 62,423 2,888 4.85 51451.00 Medicare Contributions 12,431 13,924 13,924 14,599 675 4.85 51460.00 PERA Contributions 54,202 57,302 57,302 60,840 3,538 6.17 51470.00 Health Insurance 89,393 98,217 98,217 110,849 12,632 12.86 51472.00 Retiree HCSP Contributions 2,640 2,184 2,184 2,688 504 23.08 51473.00 Dental Insurance 4,393 4,094 4,094 4,347 253 6.18 51474.00 Life Insurance 567 567 567 575 8 1.41 51476.00 MN Unemployment Insurance 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget 51477.00 Workers Compensation Insurance 39,540 52,532 52,532 44,915 (7,617) (14.50)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 1,152,928 1,253,181 1,253,181 1,313,648 60,467 4.83 CURRENT EXPENDITURES 52010.00 Office Supplies 376 800 800 800 52050.00 Operating Supplies 52051.00 Fuel 62,931 60,400 60,400 64,750 4,350 7.20 52052.00 Shop Material 120 3,000 3,000 3,000 52055.00 Uniforms/Personal Protective Equipment 9,489 9,850 9,850 10,150 300 3.05 52200.01 Repair & Maint Supplies - General 2,340 52200.02 Repair & Maint Supplies - Building 52200.50 Repair & Maint Supplies - Parks 52200.51 Repair & Maint Supplies Misc Bldg&Struc 64,904 85,500 85,500 89,500 4,000 4.68 52200.52 Repair & Maint Supplies Irrigation 8,415 12,000 12,000 12,000 52200.53 Repair & Maint Supplies Landscape 47,435 60,500 60,500 61,500 1,000 1.65 52200.56 Repair & Maint Supplies Trees/Vegetation 3,348 15,000 15,000 15,000 52400.10 Small Equipment - General 4,906 7,000 7,000 7,000 52400.20 Small Equipment - Technology 362 52400.30 Small Equipment - Safety 2,204 13,100 13,100 42,300 29,200 222.90 AED equipment $35k 53100.80 Professional Services - General 13,440 30,000 30,000 60,000 30,000 100.00 park referendum consulting costs $30k 53210.00 Telecommunications 2,714 3,000 3,000 3,420 420 14.00 53310.10 Training and Employee Development 4,684 6,100 6,100 6,100 53630.00 Insurance - Auto 1,980 1,975 1,975 2,510 535 27.09 53810.00 Utilities - Electric 16,133 15,680 15,680 12,010 (3,670) (23.41) 53820.00 Utilities - Gas 7,310 7,000 7,000 2,525 (4,475) (63.93) 53830.00 Utilities - Refuse Disposal 32,808 32,000 32,000 32,000 53850.00 Utilities - Park Lighting 59,886 64,670 64,670 58,050 (6,620) (10.24) 54010.02 Maint Agreements - Buildings 12,114 23,400 23,400 17,000 (6,400) (27.35) 54010.50 Maint Agreements - Parks Only 54010.51 Maint Agreements Misc Bldg & Structures 8,568 18,000 18,000 22,000 4,000 22.22 54010.52 Maint Agreements Irrigation 597 3,500 3,500 3,500 54010.53 Maint Agreements Landscape 18,996 60,000 60,000 65,000 5,000 8.33 54010.54 Maint Agreements Electric/Lighting 4,963 10,000 10,000 10,000 54010.55 Maint AgreementsTrails/Sidewalks 67,969 40,000 80,000 40,000 (40,000) (50.00)amended 2024 for pvmt mgmt plan 54010.56 Maint Agreements Trees & Native Vegi 69,984 80,000 80,000 85,000 5,000 6.25 54020.00 Software Service Contract 8,286 6,800 6,800 7,300 500 7.35 54070.00 Rentals - Heavy Equipment 45,107 42,500 42,500 42,500 54310.00 Memberships and Subscriptions 279 1,650 1,650 1,400 (250) (15.15) 54320.00 Miscellaneous Expense CURRENT EXPENDITURES 582,648 713,425 753,425 776,315 22,890 3.04 CAPITAL OUTLAY 55520.00 Building & Building Improvements 55530.00 Infrastructure 55570.00 Machinery and Equipment 31,258 CAPITAL OUTLAY 31,258 Totals for dept 45200.00 - PARKS 1,766,834 1,966,606 2,006,606 2,089,963 83,357 4.15 Dept 45500.00 - LIBRARIES CURRENT EXPENDITURES 52200.02 Repair & Maint Supplies - Building 3,315 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget 53210.00 Telecommunications 53810.00 Utilities - Electric 20,373 22,180 22,180 16,740 (5,440) (24.53) 53820.00 Utilities - Gas 9,327 10,494 10,494 6,400 (4,094) (39.01) 53830.00 Utilities - Refuse Disposal 2,721 54010.02 Maint Agreements - Buildings 8,867 54010.05 Maint Agreements - Cleaning 17,015 CURRENT EXPENDITURES 61,618 32,674 32,674 23,140 (9,534) (29.18) Totals for dept 45500.00 - LIBRARIES 61,618 32,674 32,674 23,140 (9,534) (29.18) Dept 80000.00 - Transfers to other Funds TRANSFERS OUT 59203.00 Transfers to Other Funds 633,888 248,488 248,488 262,488 14,000 5.63 TRANSFERS OUT 633,888 248,488 248,488 262,488 14,000 5.63 Totals for dept 80000.00 - Transfers to other Funds 633,888 248,488 248,488 262,488 14,000 5.63 APPROPRIATIONS - FUND 101 18,408,134 21,046,603 21,301,943 22,026,885 (724,942) 3.40 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget DEBT SERVICE FUNDS INTEREST AND OTHER 55070.00 Projects - Bond Issuance Costs 56110.00 Bond Interest 1,000,666 967,859 967,859 902,317 (65,542) (6.77) 56300.00 Other Debt Service Expenses 9,963 3,283 3,283 4,200 917 27.93 INTEREST AND OTHER 1,010,629 971,142 971,142 906,517 (64,625) (6.65) PRINCIPAL 56010.00 Bond Principal 3,776,693 4,202,801 4,202,801 4,278,731 75,930 1.81 PRINCIPAL 3,776,693 4,202,801 4,202,801 4,278,731 75,930 1.81 TRANSFERS OUT 59203.00 Transfers to Other Funds 47,404 45,000 TRANSFERS OUT 47,404 45,000 APPROPRIATIONS - DEBT SERVICE FUNDS 4,834,726 5,218,943 5,173,943 5,185,248 11,305 0.22 Fund 210 - CABLE FRANCHISE FUND Dept 41340.00 - PUBLIC CABLE ACCESS CURRENT EXPENDITURES 52400.20 Small Equipment - Technology 6,000 6,000 (6,000) (100.00) 53210.00 Telecommunications 54020.00 Software Service Contract 3,576 3,700 3,700 software wasn't budgeted in the past CURRENT EXPENDITURES 3,576 6,000 6,000 3,700 (2,300) (38.33) CAPITAL OUTLAY 55530.00 Infrastructure 55570.00 Machinery and Equipment CAPITAL OUTLAY Totals for dept 41340.00 - PUBLIC CABLE ACCESS 3,576 6,000 6,000 3,700 (2,300) (38.33) APPROPRIATIONS - FUND 210 3,576 6,000 6,000 3,700 2,300 (38.33) 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget Fund 225 - CAPITAL PARK FUND Dept 45200.00 - PARKS CURRENT EXPENDITURES 53100.80 Professional Services - General 65,817 5,000 5,000 5,600 600 12.00 53810.00 Utilities - Electric CURRENT EXPENDITURES 65,817 5,000 5,000 5,600 600 12.00 CAPITAL OUTLAY 55010.00 Projects - Contract Vouchers 55020.00 Projects - Engineering 70,255 55530.00 Infrastructure 23,699 300,000 300,000 2,500,000 2,200,000 733.33 TH13 trail segment 1 55570.00 Machinery and Equipment CAPITAL OUTLAY 93,954 300,000 300,000 2,500,000 2,200,000 733.33 Totals for dept 45200.00 - PARKS 159,771 305,000 305,000 2,505,600 2,200,600 721.51 Dept 80000.00 - Transfers to other Funds TRANSFERS OUT 59203.00 Transfers to Other Funds TRANSFERS OUT Totals for dept 80000.00 - Transfers to other Funds APPROPRIATIONS - FUND 225 159,771 305,000 305,000 2,505,600 (2,200,600) 721.51 Fund 240 - EDA SPECIAL REVENUE FUND Dept 46500.00 - ECONOMIC DEVELOPMENT PERSONAL SERVICES 51100.01 Wages - Full Time 107,738 124,287 124,287 128,154 3,867 3.11 51100.05 Wages - Commissioners 1,750 3,000 3,000 3,000 51110.01 Overtime - Full Time 51208.01 Sick Leave - Buy Down 1,421 1,421 1,331 (90) (6.33)Based on current employees 51400.00 Compensated Absences 643 808 808 961 153 18.94 Increased compensated leave % 51450.00 Social Security Contributions 6,437 7,980 7,980 8,214 234 2.93 51451.00 Medicare Contributions 1,506 1,866 1,866 1,921 55 2.95 51460.00 PERA Contributions 8,039 9,381 9,381 9,672 291 3.10 51470.00 Health Insurance 9,710 13,493 13,493 13,038 (455) (3.37)Based on current employee selections 51472.00 Retiree HCSP Contributions 280 300 300 360 60 20.00 51473.00 Dental Insurance 577 457 457 489 32 7.00 51474.00 Life Insurance 62 68 68 68 51477.00 Workers Compensation Insurance 98 773 773 680 (93) (12.03)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 136,840 163,834 163,834 167,888 4,054 2.47 CURRENT EXPENDITURES 52010.00 Office Supplies 53020.00 Legal Services 1,000 1,000 1,000 53100.80 Professional Services - General 24,065 75,000 75,000 150,000 75,000 100.00 added $75k for utility study 53210.00 Telecommunications 53310.10 Training and Employee Development 500 500 500 53510.00 Required Notice Publication 54010.51 Maint Agreements Misc Bldg & Structures 1,747 5,000 5,000 1,500 (3,500) (70.00) 54310.00 Memberships and Subscriptions 250 500 500 250 (250) (50.00) 54320.00 Miscellaneous Expense 17,785 19,000 19,000 18,700 (300) (1.58) CURRENT EXPENDITURES 43,847 101,000 101,000 171,950 70,950 70.25 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget CAPITAL OUTLAY 55040.00 Projects - Property & ROW Acquisit'n 385,000 385,000 385,000 55050.00 Projects - Professional Services CAPITAL OUTLAY 385,000 385,000 385,000 Totals for dept 46500.00 - ECONOMIC DEVELOPMENT 180,687 649,834 649,834 724,838 75,004 11.54 APPROPRIATIONS - FUND 240 180,687 649,834 649,834 724,838 (75,004) 11.54 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget Fund 410 - REVOLVING EQUIPMENT FUND Dept 41830.00 - COMMUNICATIONS CAPITAL OUTLAY 55570.00 Machinery and Equipment CAPITAL OUTLAY Totals for dept 41830.00 - COMMUNICATIONS Dept 42100.00 - POLICE CAPITAL OUTLAY 55550.00 Vehicles 179,992 330,000 543,000 260,000 (283,000) (52.12)squad cars 55570.00 Machinery and Equipment 44,315 CAPITAL OUTLAY 224,307 330,000 543,000 260,000 (283,000) (52.12) Totals for dept 42100.00 - POLICE 224,307 330,000 543,000 260,000 (283,000) (52.12) Dept 42100.06 - POLICE FORFEITURES CURRENT EXPENDITURES 54350.00 Agency Forfeit Proceeds CURRENT EXPENDITURES Totals for dept 42100.06 - POLICE FORFEITURES Dept 42200.00 - FIRE CAPITAL OUTLAY 55550.00 Vehicles 83,403 400,000 (400,000) (100.00) 55570.00 Machinery and Equipment 96,453 CAPITAL OUTLAY 179,856 400,000 (400,000) (100.00) Totals for dept 42200.00 - FIRE 179,856 400,000 (400,000) (100.00) Dept 42400.00 - BUILDING INSPECTION CAPITAL OUTLAY 55550.00 Vehicles 44,000 (44,000) (100.00) CAPITAL OUTLAY 44,000 (44,000) (100.00) Totals for dept 42400.00 - BUILDING INSPECTION 44,000 (44,000) (100.00) Dept 42500.00 - EMERGENCY MANAGEMENT CAPITAL OUTLAY 55570.00 Machinery and Equipment 93,200 93,200 46,600 (46,600) (50.00)emergency siren replacement CAPITAL OUTLAY 93,200 93,200 46,600 (46,600) (50.00) Totals for dept 42500.00 - EMERGENCY MANAGEMENT 93,200 93,200 46,600 (46,600) (50.00) Dept 43050.00 - ENGINEERING CAPITAL OUTLAY 55550.00 Vehicles 50,000 50,000 (50,000) (100.00) CAPITAL OUTLAY 50,000 50,000 (50,000) (100.00) Totals for dept 43050.00 - ENGINEERING 50,000 50,000 (50,000) (100.00) Dept 43100.00 - STREET CAPITAL OUTLAY 55550.00 Vehicles 55570.00 Machinery and Equipment 37,492 38,000 38,000 712,000 674,000 1,773.68 $120k dump truck, $177k backhoe, $100k skid steer, $315k street sweeper 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget CAPITAL OUTLAY 37,492 38,000 38,000 712,000 674,000 1,773.68 INTEREST AND OTHER 55070.00 Projects - Bond Issuance Costs INTEREST AND OTHER PREMIUM ON DEBT ISSUED 55110.00 Projects - Bond Discount/Premium PREMIUM ON DEBT ISSUED Totals for dept 43100.00 - STREET 37,492 38,000 38,000 712,000 674,000 1,773.68 Dept 43400.00 - CENTRAL GARAGE CAPITAL OUTLAY 55550.00 Vehicles 20,418 25,000 25,000 20,000 (5,000) (20.00)refurbishing CAPITAL OUTLAY 20,418 25,000 25,000 20,000 (5,000) (20.00) Totals for dept 43400.00 - CENTRAL GARAGE 20,418 25,000 25,000 20,000 (5,000) (20.00) Dept 45200.00 - PARKS CAPITAL OUTLAY 55550.00 Vehicles 123,611 347,500 (347,500) (100.00) 55570.00 Machinery and Equipment 582,530 328,000 328,000 35,600 (292,400) (89.15)field groomer CAPITAL OUTLAY 706,141 328,000 675,500 35,600 (639,900) (94.73) Totals for dept 45200.00 - PARKS 706,141 328,000 675,500 35,600 (639,900) (94.73) Dept 80000.00 - Transfers to other Funds TRANSFERS OUT 59203.00 Transfers to Other Funds TRANSFERS OUT Totals for dept 80000.00 - Transfers to other Funds APPROPRIATIONS - FUND 410 1,168,214 864,200 1,868,700 1,074,200 794,500 (42.52) Fund 430 - REVOLVING PARK EQUIP FUND Dept 45200.00 - PARKS CAPITAL OUTLAY 55010.00 Projects - Contract Vouchers 1,007,709 55020.00 Projects - Engineering 88,069 55530.00 Infrastructure 504,040 65,000 65,000 1,030,000 965,000 1,484.62 $1 M ponds park ph II, $30k ryan BB maint CAPITAL OUTLAY 1,599,818 65,000 65,000 1,030,000 965,000 1,484.62 Totals for dept 45200.00 - PARKS 1,599,818 65,000 65,000 1,030,000 965,000 1,484.62 Dept 45500.00 - LIBRARIES CAPITAL OUTLAY 55050.00 Projects - Professional Services CAPITAL OUTLAY Totals for dept 45500.00 - LIBRARIES Dept 80000.00 - Transfers to other Funds TRANSFERS OUT 59203.00 Transfers to Other Funds 920,000 920,000 transfer to F501 wilds parkway reclamation 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget TRANSFERS OUT 920,000 920,000 Totals for dept 80000.00 - Transfers to other Funds 920,000 920,000 APPROPRIATIONS - FUND 430 1,599,818 65,000 65,000 1,950,000 (1,885,000) 2,900.00 Fund 440 - FACILITIES MANAGEMENT FUND Dept 41910.00 - COMMUNITY DEVELOPMENT CAPITAL OUTLAY 55520.00 Building & Building Improvements CAPITAL OUTLAY Totals for dept 41910.00 - COMMUNITY DEVELOPMENT Dept 41940.00 - FACILITIES - CITY HALL CAPITAL OUTLAY 55050.00 Projects - Professional Services 11,648 55520.00 Building & Building Improvements 439,600 86,100 (86,100) (100.00) 55570.00 Machinery and Equipment CAPITAL OUTLAY 11,648 439,600 86,100 (86,100) (100.00) Totals for dept 41940.00 - FACILITIES - CITY HALL 11,648 439,600 86,100 (86,100) (100.00) Dept 42100.00 - POLICE CAPITAL OUTLAY 55520.00 Building & Building Improvements 24,934 81,000 188,000 300,000 112,000 59.57 parking lots 55570.00 Machinery and Equipment CAPITAL OUTLAY 24,934 81,000 188,000 300,000 112,000 59.57 Totals for dept 42100.00 - POLICE 24,934 81,000 188,000 300,000 112,000 59.57 Dept 42200.00 - FIRE CAPITAL OUTLAY 55050.00 Projects - Professional Services 5,105 55520.00 Building & Building Improvements 129,337 178,600 170,500 147,500 (23,000) (13.49)FS#1 rooftop unit 55570.00 Machinery and Equipment CAPITAL OUTLAY 134,442 178,600 170,500 147,500 (23,000) (13.49) Totals for dept 42200.00 - FIRE 134,442 178,600 170,500 147,500 (23,000) (13.49) Dept 43100.00 - STREET INTEREST AND OTHER 55070.00 Projects - Bond Issuance Costs 15,000 15,000 INTEREST AND OTHER 15,000 15,000 PREMIUM ON DEBT ISSUED 55110.00 Projects - Bond Discount/Premium PREMIUM ON DEBT ISSUED Totals for dept 43100.00 - STREET 15,000 15,000 Dept 43400.00 - CENTRAL GARAGE CAPITAL OUTLAY 55520.00 Building & Building Improvements 49,550 128,000 128,000 (128,000) (100.00) CAPITAL OUTLAY 49,550 128,000 128,000 (128,000) (100.00) 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget Totals for dept 43400.00 - CENTRAL GARAGE 49,550 128,000 128,000 (128,000) (100.00) Dept 45100.00 - RECREATION CAPITAL OUTLAY 55520.00 Building & Building Improvements CAPITAL OUTLAY Totals for dept 45100.00 - RECREATION Dept 45200.00 - PARKS CAPITAL OUTLAY 55530.00 Infrastructure 16,000 141,000 (141,000) (100.00) CAPITAL OUTLAY 16,000 141,000 (141,000) (100.00) Totals for dept 45200.00 - PARKS 16,000 141,000 (141,000) (100.00) Dept 45500.00 - LIBRARIES CAPITAL OUTLAY 55050.00 Projects - Professional Services 55520.00 Building & Building Improvements 23,500 148,500 300,000 151,500 102.02 parking lots CAPITAL OUTLAY 23,500 148,500 300,000 151,500 102.02 Totals for dept 45500.00 - LIBRARIES 23,500 148,500 300,000 151,500 102.02 Dept 80000.00 - Transfers to other Funds TRANSFERS OUT 59203.00 Transfers to Other Funds TRANSFERS OUT Totals for dept 80000.00 - Transfers to other Funds APPROPRIATIONS - FUND 440 220,574 866,700 862,100 762,500 99,600 (11.55) Fund 450 - PERMANENT IMPROVEMENT REVOLVING FUND Dept 43100.00 - STREET CAPITAL OUTLAY 55530.00 Infrastructure 6,570,000 6,570,000 (6,570,000) (100.00) CAPITAL OUTLAY 6,570,000 6,570,000 (6,570,000) (100.00) INTEREST AND OTHER 55070.00 Projects - Bond Issuance Costs INTEREST AND OTHER PREMIUM ON DEBT ISSUED 55110.00 Projects - Bond Discount/Premium PREMIUM ON DEBT ISSUED Totals for dept 43100.00 - STREET 6,570,000 6,570,000 (6,570,000) (100.00) Dept 80000.00 - Transfers to other Funds TRANSFERS OUT 59203.00 Transfers to Other Funds 203,100 94,590 94,590 369,736 275,146 290.88 transfer to F579 2024A bond payment TRANSFERS OUT 203,100 94,590 94,590 369,736 275,146 290.88 Totals for dept 80000.00 - Transfers to other Funds 203,100 94,590 94,590 369,736 275,146 290.88 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget APPROPRIATIONS - FUND 450 203,100 6,664,590 6,664,590 369,736 6,294,854 (94.45) Fund 601 - WATER FUND Dept 41520.00 - FINANCE PERSONAL SERVICES 51100.01 Wages - Full Time 62,537 65,759 65,759 70,171 4,412 6.71 51100.02 Wages - Part Time 257 51110.01 Overtime - Full Time 2,000 2,000 1,000 (1,000) (50.00)Based on historical 51208.01 Sick Leave - Buy Down 51400.00 Compensated Absences 453 427 427 526 99 23.19 Increased compensated leave % 51450.00 Social Security Contributions 3,786 4,201 4,201 4,413 212 5.05 51451.00 Medicare Contributions 886 983 983 1,032 49 4.98 51460.00 PERA Contributions 4,690 4,932 4,932 5,263 331 6.71 51470.00 Health Insurance 8,886 9,834 9,834 11,039 1,205 12.25 51472.00 Retiree HCSP Contributions 300 240 240 300 60 25.00 51473.00 Dental Insurance 685 540 540 506 (34) (6.30) 51474.00 Life Insurance 68 68 68 68 51476.00 MN Unemployment Insurance 51477.00 Workers Compensation Insurance 432 360 360 323 (37) (10.28)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 82,980 89,344 89,344 94,641 5,297 5.93 CURRENT EXPENDITURES 52010.00 Office Supplies 108 580 580 500 (80) (13.79) 52400.10 Small Equipment - General 500 500 500 52400.20 Small Equipment - Technology 53100.80 Professional Services - General 3,000 3,000 3,000 53120.10 Bank Service Fees 14,178 12,720 12,720 14,400 1,680 13.21 53220.00 Postage/Shipping 10,648 10,200 10,200 11,500 1,300 12.75 53310.10 Training and Employee Development 293 200 200 200 53430.00 Printing Services 2,162 5,000 5,000 2,500 (2,500) (50.00) 54010.04 Maint Agreements - Equipment 54020.00 Software Service Contract 3,291 3,236 3,236 3,555 319 9.86 54310.00 Memberships and Subscriptions 25 25 (25) (100.00) CURRENT EXPENDITURES 30,680 35,461 35,461 36,155 694 1.96 Totals for dept 41520.00 - FINANCE 113,660 124,805 124,805 130,796 5,991 4.80 Dept 49400.00 - WATER PERSONAL SERVICES 51100.01 Wages - Full Time 689,218 602,727 737,318 878,589 141,271 19.16 COLA and step increases; new PW Supervisor position 51100.03 Wages - Seasonal/Temporary 51110.01 Overtime - Full Time 14,923 23,392 23,392 16,000 (7,392) (31.60)Based on historical 51208.01 Sick Leave - Buy Down 1,722 2,440 2,440 1,791 (649) (26.60)Based on current employees 51301.00 Accrued Comp Time 51400.00 Compensated Absences 13,966 3,918 4,793 6,589 1,796 37.47 Increased compensated leave % 51450.00 Social Security Contributions 44,012 38,971 47,316 55,576 8,260 17.46 51451.00 Medicare Contributions 10,293 9,114 11,066 12,998 1,932 17.46 51460.00 PERA Contributions 54,711 46,959 57,053 67,094 10,041 17.60 51470.00 Health Insurance 88,575 75,892 96,862 119,331 22,469 23.20 Based on current employee selections; new positions were budgeted at Family rates 51472.00 Retiree HCSP Contributions 1,874 1,806 2,286 2,925 639 27.95 51473.00 Dental Insurance 4,212 3,037 3,896 4,439 543 13.94 Based on current employee selections; new positions were budgeted at Family rates 51474.00 Life Insurance 579 454 576 633 57 9.90 51476.00 MN Unemployment Insurance 51477.00 Workers Compensation Insurance 18,146 18,248 22,065 20,466 (1,599) (7.25)Based on 2024 actual and assumed 5% increase 51478.00 OPEB Expense 5,832 51479.00 PERA Pension Expense 118,198 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget PERSONAL SERVICES 1,066,261 826,958 1,009,063 1,186,431 177,368 17.58 CURRENT EXPENDITURES 52010.00 Office Supplies 3,839 4,000 4,000 4,000 52050.00 Operating Supplies 101 2,000 2,000 2,000 52051.00 Fuel 13,961 18,000 18,000 18,550 550 3.06 52053.00 Chemicals 164,933 200,000 200,000 200,000 52055.00 Uniforms/Personal Protective Equipment 6,015 8,100 8,100 4,950 (3,150) (38.89) 52200.02 Repair & Maint Supplies - Building 8,518 13,000 13,000 18,000 5,000 38.46 52200.60 Repair & Maint Supplies Water Fund 52200.61 Repair & Maint Supplies Wells 18,388 10,000 10,000 15,000 5,000 50.00 52200.62 Repair & Maint Supplies Water Treatment 26,033 44,500 44,500 50,000 5,500 12.36 52200.63 Repair & Maint Supplies Water Distrib 28,540 105,000 105,000 101,500 (3,500) (3.33) 52400.10 Small Equipment - General 8,833 17,000 17,000 12,500 (4,500) (26.47) 52400.20 Small Equipment - Technology 677 52400.30 Small Equipment - Safety 5,278 7,700 7,700 7,700 52500.20 Water Meters 87,705 140,000 140,000 140,000 53100.20 Professional Services - Engineering 26,827 40,000 40,000 40,000 53100.70 Professional Services - Water Testing 41,677 31,500 31,500 31,500 53100.80 Professional Services - General 795 5,000 5,000 7,000 2,000 40.00 53210.00 Telecommunications 11,325 19,090 19,090 16,450 (2,640) (13.83) 53220.00 Postage/Shipping 53230.00 Telecommunications Equipment 11,643 28,000 28,000 20,000 (8,000) (28.57) 53310.10 Training and Employee Development 17,139 24,300 24,300 23,550 (750) (3.09) 53610.00 Insurance - Gen Liability 6,097 6,463 6,463 6,675 212 3.28 53630.00 Insurance - Auto 620 2,684 2,684 848 (1,836) (68.41) 53810.00 Utilities - Electric 240,101 253,600 253,600 208,990 (44,610) (17.59) 53820.00 Utilities - Gas 45,946 51,175 51,175 46,575 (4,600) (8.99) 53830.00 Utilities - Refuse Disposal 500 500 1,000 500 100.00 53860.00 Utilities - Water 709,772 500,000 800,000 800,000 54010.01 Maint Agreements - General 54010.02 Maint Agreements - Buildings 12,564 37,600 37,600 55,100 17,500 46.54 54010.04 Maint Agreements - Equipment 54010.05 Maint Agreements - Cleaning 13,935 26,000 26,000 26,000 54010.61 Maint Agreements Wells 432 50,000 50,000 50,000 54010.62 Maint Agreements Water Treatment 117,566 115,500 115,500 97,250 (18,250) (15.80) 54010.63 Maint Agreements Water Distrib 385,180 276,250 276,250 279,500 3,250 1.18 54020.00 Software Service Contract 36,396 37,190 37,190 41,020 3,830 10.30 54070.00 Rentals - Heavy Equipment 5,000 5,000 5,000 54200.00 Depreciation 1,059,317 54310.00 Memberships and Subscriptions 3,217 5,250 5,250 4,250 (1,000) (19.05) 54320.00 Miscellaneous Expense 4,592 10,000 10,000 54700.00 Contra Maint Charges-Assets Capitalized CURRENT EXPENDITURES 3,117,962 2,084,402 2,384,402 2,344,908 (39,494) (1.66) CAPITAL OUTLAY 55520.00 Building & Building Improvements 150,000 150,000 55530.00 Infrastructure 63,818 75,000 75,000 57,500 (17,500) (23.33) 55550.00 Vehicles 60,000 60,000 55570.00 Machinery and Equipment 49,573 110,500 110,500 35,000 (75,500) (68.33) 55580.00 Software 500,000 500,000 55700.00 Contra Capital Outlay-Assets Capitalized (49,573) CAPITAL OUTLAY 63,818 185,500 185,500 802,500 617,000 332.61 INTEREST AND OTHER 56110.00 Bond Interest 39,730 34,650 34,650 29,250 (5,400) (15.58) 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget INTEREST AND OTHER 39,730 34,650 34,650 29,250 (5,400) (15.58) PRINCIPAL 56010.00 Bond Principal 130,000 135,000 135,000 135,000 PRINCIPAL 130,000 135,000 135,000 135,000 DEBT SERVICE 56500.00 Contra Debt Service - Enterprise Prin (130,000) DEBT SERVICE (130,000) OTHER FINANCING USES 57000.00 Loss on Disposal of Assets OTHER FINANCING USES Totals for dept 49400.00 - WATER 4,287,771 3,266,510 3,748,615 4,498,089 749,474 19.99 Dept 80000.00 - Transfers to other Funds TRANSFERS OUT 59203.00 Transfers to Other Funds 1,659,590 2,713,650 863,650 993,883 130,233 15.08 F101 $251k, F351 $625k, F410 $92k, F501 $26k wilds TRANSFERS OUT 1,659,590 2,713,650 863,650 993,883 130,233 15.08 Totals for dept 80000.00 - Transfers to other Funds 1,659,590 2,713,650 863,650 993,883 130,233 15.08 APPROPRIATIONS - FUND 601 6,061,021 6,104,965 4,737,070 5,622,768 (885,698) 18.70 Fund 602 - STORM WATER UTILITY Dept 49420.00 - WATER QUALITY PERSONAL SERVICES 51100.01 Wages - Full Time 196,035 268,004 268,004 296,888 28,884 10.78 COLA and step increases; new PW Supervisor position 51100.02 Wages - Part Time 991 51100.03 Wages - Seasonal/Temporary 4,802 8,000 8,000 8,000 51110.01 Overtime - Full Time 2,599 4,476 4,476 3,500 (976) (21.81)Based on historical 51205.01 Other Pay - Awards 51208.01 Sick Leave - Buy Down 1,298 51301.00 Accrued Comp Time 51400.00 Compensated Absences (10,808) 1,742 1,742 2,227 485 27.84 Increased compensated leave % 51450.00 Social Security Contributions 11,844 17,390 17,390 19,120 1,730 9.95 51451.00 Medicare Contributions 2,770 4,067 4,067 4,472 405 9.96 51460.00 PERA Contributions 14,603 20,436 20,436 22,529 2,093 10.24 51470.00 Health Insurance 23,299 40,312 40,312 48,476 8,164 20.25 Based on current employee selections; new positions were budgeted at Family rates 51472.00 Retiree HCSP Contributions 467 657 657 892 235 35.77 51473.00 Dental Insurance 1,384 1,413 1,413 1,575 162 11.46 Based on current employee selections; new positions were budgeted at Family rates 51474.00 Life Insurance 143 189 189 203 14 7.41 51477.00 Workers Compensation Insurance 2,155 3,564 3,564 4,307 743 20.85 Based on 2024 actuals and assumed 5% increase 51478.00 OPEB Expense (10,300) 51479.00 PERA Pension Expense (47,540) PERSONAL SERVICES 193,742 370,250 370,250 412,189 41,939 11.33 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget CURRENT EXPENDITURES 52010.00 Office Supplies 167 750 750 750 52050.00 Operating Supplies 170 1,000 1,000 1,000 52051.00 Fuel 6,170 14,000 14,000 13,300 (700) (5.00) 52055.00 Uniforms/Personal Protective Equipment 950 950 52200.70 Repair & Maint Supplies Storm Water Fund 10 52200.71 Repair & Maint Supplies Storm Sewer Sys 11,353 35,000 35,000 35,000 52200.72 Repair & Maint Supplies Water Quality 10,823 52200.73 Repair & Maint Supplies Regulatory 300 52400.20 Small Equipment - Technology 300 52400.30 Small Equipment - Safety 1,588 7,000 7,000 7,000 52700.00 Contra Repairs&Maint-Assets Capitalized 53100.80 Professional Services - General 44,400 63,000 63,000 143,000 80,000 126.98 erosion control inspections $80k 53210.00 Telecommunications 1,032 1,200 1,200 1,200 53310.10 Training and Employee Development 164 2,750 2,750 2,750 53630.00 Insurance - Auto 92 135 135 53700.00 Contra Other Charges-Assets Capitalized 54010.01 Maint Agreements - General 54010.71 Maint Agreements Storm sewer system 112,930 160,000 160,000 162,000 2,000 1.25 54010.72 Maint Agreements Water Quality 8,437 54010.73 Maint Agreements Regulatory 54020.00 Software Service Contract 6,186 6,600 6,600 7,100 500 7.58 54070.00 Rentals - Heavy Equipment 6,276 10,000 10,000 10,000 54200.00 Depreciation 107,388 54310.00 Memberships and Subscriptions 1,329 2,250 2,250 2,500 250 11.11 54320.00 Miscellaneous Expense 146 1,000 1,000 1,000 54700.00 Contra Maint Charges-Assets Capitalized CURRENT EXPENDITURES 319,261 304,550 304,550 387,685 83,135 27.30 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget CAPITAL OUTLAY 55020.00 Projects - Engineering 55040.00 Projects - Property & ROW Acquisit'n 55050.00 Projects - Professional Services 185,258 55530.00 Infrastructure 121,190 1,708,000 1,708,000 545,000 (1,163,000) (68.09) 55700.00 Contra Capital Outlay-Assets Capitalized CAPITAL OUTLAY 306,448 1,708,000 1,708,000 545,000 (1,163,000) (68.09) INTEREST AND OTHER 56110.00 Bond Interest 66,830 66,830 INTEREST AND OTHER 66,830 66,860 PRINCIPAL 56010.00 Bond Principal 20,000 20,000 PRINCIPAL 20,000 20,000 Totals for dept 49420.00 - WATER QUALITY 819,451 2,382,800 2,382,800 1,431,704 (951,096) (39.92) Dept 80000.00 - Transfers to other Funds TRANSFERS OUT 59203.00 Transfers to Other Funds 110,000 113,300 113,300 902,300 789,000 696.38 F410 $157k, F101 $115k, F501 $480k wilds, F501 $150k Martindale TRANSFERS OUT 110,000 113,300 113,300 902,300 789,000 696.38 Totals for dept 80000.00 - Transfers to other Funds 110,000 113,300 113,300 902,300 789,000 696.38 APPROPRIATIONS - FUND 602 929,451 2,496,100 2,496,100 2,334,004 162,096 (6.49) Fund 604 - SEWER FUND Dept 41520.00 - FINANCE PERSONAL SERVICES 51100.01 Wages - Full Time 62,531 65,759 65,759 70,171 4,412 6.71 51100.02 Wages - Part Time 51110.01 Overtime - Full Time 2,000 2,000 1,000 (1,000) (50.00)Based on historical 51301.00 Accrued Comp Time 51400.00 Compensated Absences 453 427 427 526 99 23.19 Increased compensated leave % 51450.00 Social Security Contributions 3,770 4,201 4,201 4,413 212 5.05 51451.00 Medicare Contributions 881 983 983 1,032 49 4.98 51460.00 PERA Contributions 4,690 4,932 4,932 5,263 331 6.71 51470.00 Health Insurance 8,883 9,834 9,834 11,039 1,205 12.25 51472.00 Retiree HCSP Contributions 300 240 240 300 60 25.00 51473.00 Dental Insurance 684 540 540 506 (34) (6.30)Based on current employee selections 51474.00 Life Insurance 67 68 68 68 51476.00 MN Unemployment Insurance 51477.00 Workers Compensation Insurance 432 360 360 323 (37) (10.28)Based on 2024 actuals and assumed 5% increase PERSONAL SERVICES 82,691 89,344 89,344 94,641 5,297 5.93 CURRENT EXPENDITURES 52010.00 Office Supplies 78 500 500 500 52400.10 Small Equipment - General 210 210 210 52400.20 Small Equipment - Technology 53100.80 Professional Services - General 3,000 3,000 3,000 53120.10 Bank Service Fees 14,178 12,720 12,720 14,400 1,680 13.21 53220.00 Postage/Shipping 10,648 10,200 10,200 11,500 1,300 12.75 53310.10 Training and Employee Development 257 230 230 200 (30) (13.04) 53430.00 Printing Services 2,161 5,000 5,000 2,500 (2,500) (50.00) 54020.00 Software Service Contract 3,291 3,236 3,236 3,555 319 9.86 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget 54310.00 Memberships and Subscriptions CURRENT EXPENDITURES 30,613 35,096 35,096 35,865 769 2.19 Totals for dept 41520.00 - FINANCE 113,304 124,440 124,440 130,506 6,066 4.87 Dept 49450.00 - SEWER PERSONAL SERVICES 51100.01 Wages - Full Time 463,614 616,859 482,268 550,340 68,072 14.11 COLA and step increases; new PW Supervisor position 51100.02 Wages - Part Time 2,973 51100.03 Wages - Seasonal/Temporary 51110.01 Overtime - Full Time 28,939 27,303 27,303 30,000 2,697 9.88 Based on historical 51110.03 Overtime - Seasonal/Temporary 51208.01 Sick Leave - Buy Down 51301.00 Accrued Comp Time 51400.00 Compensated Absences 12,262 4,010 3,135 4,128 993 31.67 Increased compensated leave % 51450.00 Social Security Contributions 26,834 39,938 31,593 35,981 4,388 13.89 51451.00 Medicare Contributions 6,275 9,340 7,388 8,415 1,027 13.90 51460.00 PERA Contributions 35,264 48,312 38,218 43,525 5,307 13.89 51470.00 Health Insurance 60,967 90,407 69,437 88,036 18,599 26.79 Based on current employee selections; new positions were budgeted at Family rates 51472.00 Retiree HCSP Contributions 1,802 1,825 1,345 1,824 479 35.61 51473.00 Dental Insurance 2,734 3,507 2,648 2,957 309 11.67 Based on current employee selections; new positions were budgeted at Family rates 51474.00 Life Insurance 340 487 365 392 27 7.40 51476.00 MN Unemployment Insurance 51477.00 Workers Compensation Insurance 17,604 27,056 23,239 24,007 768 3.30 Based on 2024 actuals and assumed 5% increase 51478.00 OPEB Expense (13,812) 51479.00 PERA Pension Expense (57,961) PERSONAL SERVICES 587,835 869,044 686,939 789,605 102,666 14.95 CURRENT EXPENDITURES 52010.00 Office Supplies 519 1,500 1,500 1,500 52050.00 Operating Supplies 52051.00 Fuel 13,961 18,400 18,400 19,250 850 4.62 52055.00 Uniforms/Personal Protective Equipment 3,264 7,450 7,450 3,800 (3,650) (48.99) 52200.80 Repair & Maint Supplies Sewer fund 52200.81 Repair & Maint Supplies Sewer Collection 3,926 33,500 33,500 34,500 1,000 2.99 52200.82 Repair & Maint Supplies Lift Stations 29,620 40,000 40,000 50,000 10,000 25.00 52400.10 Small Equipment - General 3,619 8,000 8,000 8,000 52400.20 Small Equipment - Technology 836 52400.30 Small Equipment - Safety 5,728 7,750 7,750 7,750 53100.20 Professional Services - Engineering 24,650 9,200 9,200 9,200 53100.80 Professional Services - General 5,000 5,000 7,000 2,000 40.00 53210.00 Telecommunications 22,891 62,000 89,000 57,000 (32,000) (35.96) 53310.10 Training and Employee Development 15,845 17,000 17,000 17,000 53610.00 Insurance - Gen Liability 6,097 6,463 6,463 6,675 212 3.28 53630.00 Insurance - Auto 1,442 2,684 2,684 1,974 (710) (26.45) 53810.00 Utilities - Electric 79,813 86,700 86,700 75,080 (11,620) (13.40) 53900.00 MCES Installment 1,931,514 2,047,405 2,047,405 2,090,201 42,796 2.09 54010.81 Maint Agreements Sewer Collection 67,000 134,000 67,000 (67,000) (50.00) 54010.82 Maint Agreements Lift Stations 80,988 106,925 106,925 102,000 (4,925) (4.61) 54020.00 Software Service Contract 37,571 38,690 38,690 44,020 5,330 13.78 54070.00 Rentals - Heavy Equipment 5,000 5,000 5,000 54200.00 Depreciation 730,684 54310.00 Memberships and Subscriptions 279 54320.00 Miscellaneous Expense CURRENT EXPENDITURES 2,993,247 2,570,667 2,664,667 2,606,950 (57,717) (2.17) 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget CAPITAL OUTLAY 55530.00 Infrastructure 150,451 1,500,000 1,500,000 454,500 (1,045,500) (69.70) 55570.00 Machinery and Equipment 305,485 440,000 440,000 884,000 444,000 100.91 55580.00 Software 55700.00 Contra Capital Outlay-Assets Capitalized (752,678) CAPITAL OUTLAY (296,742) 1,940,000 1,940,000 1,338,500 (601,500) (31.01) INTEREST AND OTHER 56110.00 Bond Interest 39,730 34,650 34,650 29,250 (5,400) (15.58) INTEREST AND OTHER 39,730 34,650 34,650 29,250 (5,400) (15.58) PRINCIPAL 56010.00 Bond Principal 130,000 135,000 135,000 135,000 PRINCIPAL 130,000 135,000 135,000 135,000 DEBT SERVICE 56500.00 Contra Debt Service - Enterprise Prin (130,000) DEBT SERVICE (130,000) OTHER FINANCING USES 57000.00 Loss on Disposal of Assets 94,246 OTHER FINANCING USES 94,246 Totals for dept 49450.00 - SEWER 3,418,316 5,549,361 5,461,256 2,809,104 (2,652,152) (48.56) 9/24/24 - Council Meeting 2023 2024 2024 2025 2025 2025 BUDGET ACTIVITY ORIGINAL AMENDED PROPOSED PROPOSED PROPOSED CLASSIFICATION BUDGET BUDGET BUDGET AMT CHANGE % CHANGE Comments BUDGET REPORT CITY OF PRIOR LAKE EXPENDITURES- DETAIL From Amended Budget Dept 80000.00 - Transfers to other Funds TRANSFERS OUT 59203.00 Transfers to Other Funds 744,828 247,000 247,000 407,133 160,133 64.83 F101 $249k, F410 $92k, F501 $66k wilds TRANSFERS OUT 744,828 247,000 247,000 407,133 160,133 64.83 Totals for dept 80000.00 - Transfers to other Funds 744,828 247,000 247,000 407,133 160,133 64.83 APPROPRIATIONS - FUND 604 4,276,448 5,920,801 5,832,696 5,436,944 395,752 (6.79) APPROPRIATIONS - ALL FUNDS 38,045,520 50,208,736 49,962,976 47,996,423 (1,966,553) (3.94) (2,212,313) (4.41) From Original Budget City of Prior Lake Council Meeting 9/24/2024 2025 Budget Attachment 1 Budgeted Funds Preliminary Debt Capital Revolving Revolving Park Permanent Facilities Total Total General Service Cable Park Equipment Equipment Improvement Management EDA Governmental Water Sewer Water Quality Enterprise Budgeted Fund Funds Fund Fund Fund Fund Revolving Fund Fund Funds Fund Fund Fund Funds Funds Revenues / Sources Property Taxes Levy - Tax Capacity 15,014,949$ -$ -$ -$ 875,000$ 535,000$ -$ 255,000$ 405,000$ 17,084,949$ -$ -$ -$ -$ 17,084,949 Levy - Tax Capacity for Debt Service 2,929,190$ 150,000$ 3,079,190$ 3,079,190 Levy - Market Value 262,488 - - - - - - 262,488$ - - - - 262,488 MVHC Aid - - - - - - - -$ - - - - - Special Assessments 4,000 569,714 - - - 298,642 - - 872,356$ - - - - 872,356 Licenses & Permits 550,842 - - - - - - 550,842$ - - - - 550,842 Fines & Forfeits - - - - - - - -$ - - - - - Intergovernmental 3,406,584 - - 1,000,000 - - 47,000 - 4,453,584$ - - - - 4,453,584 Charges for Services 1,795,722 - 17,000 332,000 - - - 24,588 2,169,310$ 5,935,035 5,581,444 2,002,272 13,518,751 15,688,061 Other Revenues 377,300 77,100 - 43,800 20,400 32,500 48,300 35,800 9,800 645,000$ 196,500 106,400 69,300 372,200 1,017,200 Bond Proceeds - - - - 1,030,000 - 515,000 - 1,545,000$ - . - 1,545,000 Lease Proceeds - - - - - - - - - -$ - - - - - Transfers From Other Funds - -$ General Fund - 262,488 - - - - - - - 262,488$ - - - - 262,488 Debt Service Funds - - - - - - - - -$ - - - - - Water Fund 251,000 624,750 - - 92,333 - - - - 968,083$ - - - - 968,083 Sewer Fund 249,000 - - - 92,333 - - - - 341,333$ - - - - 341,333 Water Quality Fund 115,000 - - - 157,500 - - - - 272,500$ - - - - 272,500 Trunk Reserve Fund - - - - - - - - - -$ - - - - - TIF Fund - - - - - - - - - -$ - - - - - PIR Fund - 369,736 - - - - - - - 369,736$ - - - - 369,736 Facilities Management Fund - - - - - - - - - -$ - - - - - Capital Park Fund - - - - - - - - - -$ - - - - - Construction Fund 300,000 300,000$ - - - - 300,000 Police Forfeiture Fund -$ - - - - - Public Safety Special Revenue Fund - - - - - - - - -$ -$ -$ -$ - Total Revenues / Sources 22,026,885$ 4,832,978$ 17,000$ 1,375,800$ 1,387,566$ 1,597,500$ 646,942$ 852,800$ 439,388$ 33,176,859$ 6,131,535$ 5,687,844$ 2,071,572$ 13,890,951$ 47,067,810$ Expenditures / Uses Employee Services 15,757,614$ -$ -$ -$ -$ -$ -$ -$ 167,888$ 15,925,502$ 1,281,072$ 884,246$ 412,189$ 2,577,507$ 18,503,009$ Current Expenditures 5,919,283 - 3,700 5,600 - - - - 171,950 6,100,533 2,381,063 2,642,815 387,685 5,411,563 11,512,096 Capital Outlay 87,500 - - - - - - - 385,000 472,500 595,000 884,000 - 1,479,000 1,951,500 Capital Improvements - - - 2,500,000 1,074,200 1,030,000 - 762,500 - 5,366,700 207,500 454,500 545,000 1,207,000 6,573,700 Subtotal 21,764,397$ -$ 3,700$ 2,505,600$ 1,074,200$ 1,030,000$ -$ 762,500$ 724,838$ 27,865,235$ 4,464,635$ 4,865,561$ 1,344,874$ 10,675,070$ 38,540,305$ Transfers To Other Funds General Fund -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 251,000$ 249,000$ 115,000$ 615,000$ 615,000$ Construction Fund - - - - - 920,000 - - - 920,000 25,800 65,800 629,800 721,400 1,641,400 Equipment Fund - - - - - - - - - - 92,333 92,333 157,500 342,166 342,166 Park Equipment Fund - - - - - - - - - - - - - - - Debt Service Funds 262,488 - - - - 369,736 - - 632,224 624,750 - - 624,750 1,256,974 PIR Fund - - - - - - - - - - - - - - - Facilities Management Fund - - - - - - - - - - - - - - - EDA Fund - - - - - - - - - - - - - - - Severance Compensation Fund - - - - - - - - - - - - - - - Contingency - - - - - - - - - - - - - - - Debt Service - 5,185,248 - - - - - - - 5,185,248 164,250 164,250 86,830 415,330 5,600,578 Subtotal 262,488$ 5,185,248$ -$ -$ -$ 920,000$ 369,736$ -$ -$ 6,737,472$ 1,158,133$ 571,383$ 989,130$ 2,718,646$ 9,456,118$ Total Expenditures / Uses 22,026,885$ 5,185,248$ 3,700$ 2,505,600$ 1,074,200$ 1,950,000$ 369,736$ 762,500$ 724,838$ 34,602,707$ 5,622,768$ 5,436,944$ 2,334,004$ 13,393,716$ 47,996,423$ Change in Fund Balance -$ (352,270)$ 13,300$ (1,129,800)$ 313,366$ (352,500)$ 277,206$ 90,300$ (285,450)$ (1,425,848)$ 508,767$ 250,900$ (262,432)$ 497,235$ (928,613)$ 2025 City Property Tax Levy Comparison Council Meeting 9/24/2024Attachment 1 Change 24 - 25 Property Taxes 2024 2025 Amount Percent Levy - Tax Capacity General Fund - Operating 13,798,778$ 15,014,949$ 1,216,171$ 8.8% Debt Service Funds 3,203,024 3,079,190 (123,834) -3.9% Revolving Equipment Fund 800,000 875,000 75,000 9.4% Revolving Park Equipment Fund 460,000 535,000 75,000 16.3% Permanent Improvement Revolving F- - - n/a Facilities Management Fund 205,000 255,000 50,000 24.4% 18,466,802 19,759,139 1,292,337 7.0% Levy - Market Value - General Fund 248,488 262,488 14,000 5.6% Total City Levy 18,715,290$ 20,021,627$ 1,306,337$ 6.98% 2025 EDA Property Tax Levy Comparison Change 24 - 25 Property Taxes 2024 2025 Amount Percent Total Economic Dev Authority Levy 390,000 405,000 15,000 3.8% 2025 Budget Expenditure Comparisons (2024 Original Budgets) Capital Revolving Revolving Park Permanent Facilities Total Total General Debt Service Cable Park Equipment Equipment Improvement Management EDA Governmental Water Sewer Water Quality Enterprise Budgeted Fund Funds Fund Fund Fund Fund Revolving Fund Fund Funds Fund Fund Fund Funds Funds 2025 Total Expenditures / Uses 22,026,885$ 5,185,248$ 3,700$ 2,505,600$ 1,074,200$ 1,950,000$ 369,736$ 762,500$ 724,838$ 34,602,707$ 5,622,768$ 5,436,944$ 2,334,004$ 13,393,716$ 47,996,423$ 2024 Total Expenditures / Uses 21,046,603$ 5,218,943$ 6,000$ 305,000$ 864,200$ 65,000$ 6,664,590$ 866,700$ 649,834$ 35,686,870$ 6,104,965$ 5,920,801$ 2,496,100$ 14,521,866$ 50,208,736$ Change 2024 to 2025 ($) 980,282$ (33,695)$ (2,300)$ 2,200,600$ 210,000$ 1,885,000$ (6,294,854)$ (104,200)$ 75,004$ (1,084,163)$ (482,197)$ (483,857)$ (162,096)$ (1,128,150)$ (2,212,313)$ Change 2024 to 2025 (%) 4.66% -0.65% -38.33% 721.51% 24.30% 2900.00% -94.45% -12.02% 11.54% -3.04% -7.90% -8.17% -6.49% -7.77% -4.41% 2025 Budget Expenditure Comparisons (2024 Amended Budgets) Capital Revolving Revolving Park Permanent Facilities Total Total General Debt Service Cable Park Equipment Equipment Improvement Management EDA Governmental Water Sewer Water Quality Enterprise Budgeted Fund Funds Fund Fund Fund Fund Revolving Fund Fund Funds Fund Fund Fund Funds Funds 2025 Total Expenditures / Uses 22,026,885$ 5,185,248$ 3,700$ 2,505,600$ 1,074,200$ 1,950,000$ 369,736$ 762,500$ 724,838$ 34,602,707$ 5,622,768$ 5,436,944$ 2,334,004$ 13,393,716$ 47,996,423$ 2024 Total Expenditures / Uses 21,301,943$ 5,173,943$ 6,000$ 305,000$ 1,868,700$ 65,000$ 6,664,590$ 862,100$ 649,834$ 36,897,110$ 4,737,070$ 5,832,696$ 2,496,100$ 13,065,866$ 49,962,976$ Change 2024 to 2025 ($) 724,942$ 11,305$ (2,300)$ 2,200,600$ (794,500)$ 1,885,000$ (6,294,854)$ (99,600)$ 75,004$ (2,294,403)$ 885,698$ (395,752)$ (162,096)$ 327,850$ (1,966,553)$ Change 2024 to 2025 (%) 3.40% 0.22% -38.33% 721.51% -42.52% 2900.00% -94.45% -11.55% 11.54% -6.22% 18.70% -6.79% -6.49% 2.51% -3.94%