The URL can be used to link to this page

Home My WebLink About2.c. Preliminary Review of Draft 2021 Budget EXECUTIVE SUMMARY City Council Work Session: August 4, 2020 AGENDA ITEM: Preliminary Review of Draft 2021 Budget AGENDA SECTION: Discussion PREPARED BY: Logan Martin, City Administrator Jeff May, Finance Director AGENDA NO. 2.c. ATTACHMENTS: Draft 2021 Budget APPROVED BY: LJM RECOMMENDED ACTION: Discuss draft 2021 Budget and provide staff direction on needed modifications BACKGROUND City Staff has been working to prepare the Draft 2021 Budget over the last few months. All departments have submitted initial proposals, and staff has reviewed each department’s proposal with relevant departmental leadership. The draft attached here is the 3rd draft internally, with approximately $600,000 of requests eliminated or delayed through the course of the review process. The preliminary 2021 Budget shows an increase of 1.3% ($186,700) to the Operating Budget, which results in a 4.15% increase ($538,000) in the property tax levy. The impact of this levy increase on a median valued home is projected to be $44 per year (City share of taxes). The City’s tax rate (the percentage used to calculate the City’s portion of the property tax) is projected to be reduced to 37.1%, as compared to 38.6% in 2020. This rate continues to be lower than it was in 2016 (43%), which is a reflection of the growth of the City in recent years and the effect of added taxable value. In 2021, the median value home is estimated to be $314,600, which reflects a 7.01% value growth over last year’s median valued home. This is the 3rd highest value per median-valued home in Dakota County. Revenues The City’s tax base (tax capacity value) is preliminarily increasing by 7.15% for 2021, or a total increase of $4,011,875 to the City’s taxable value. In 2020, the City’s tax base increased by 7.91%. Historically, from 2008-2021, the City’s tax capacity value has grown by 27.48% ($7,582,306), which is the 2nd largest value growth in Dakota County. Non-tax levy revenues generated by the City are projected to decrease by 0.64% ($64,300) in 2021, largely due to staff’s decision to conservatively anticipate revenues in 2021 due to the pandemic. Licenses and Permits, the fees generated by growth and construction activities, were kept flat for 2021 (up 0.34%) again acknowledging a potential slowdown in the residential housing market. As discussed in previous years, staff takes a conservative approach to projecting these revenues so as to not rely too heavily on uncontrollable factors. However, as large residential or commercial projects are completed, revenues received would outpace these estimates. This revenue forecast is based on a target goal of 250 new units of housing in 2021. Staff projects flat revenues from rental of facilities next year too, considering the impacts of the pandemic. 2 Expenditures Below is a description of notable changes to each department’s budget. Some discussion is provided below, however a detailed presentation and discussion surrounding these initiatives will occur during the work session. City Council Administration This category includes Elections, Administration, and the General Government budgets. Finance Community Development Police Fire Public Works This category includes Gov’t Buildings, Fleet Maintenance, Street Maintenance, and Parks Maintenance budgets. Initiative Increase over ’20 Budget Remove Citywide Resident survey (will be completed in 2021 with assigned funds from 2020) ($16,000) Initiative Increase over ’20 Budget Increase in fees for Cable JPA $6,000 Processing fees for Credit Card transactions $30,000 Initiative Increase over ’20 Budget Annual subscriptions to Microsoft 365 included • Added the “Teams” feature and add’l users $7,000 Initiative Increase over ’20 Budget Add’l hours for PT GIS Technician $7,000 Initiative Increase over ’20 Budget Add’l Sergeant position to ensure 24/7 supervision $10,000 Hire 1 FTE Patrol Officer to backfill vacated position due to Sgt. promotion $102,000 Initiative Increase over ’20 Budget Annual lease payment for Ladder Truck (*Equipment CIP item) $153,000 Increase stipend for Fire Chief & Assistant Chief $10,000 Add’l hours and increased hourly rate $30,000 Initiative Increase over ’20 Budget Decreased funding for long-term Building Maintenance program (due to internal fund transfers) ($75,000) Decreased funds for HVAC maintenance due to new systems ($3,500) 3 Parks and Recreation Port Authority RECOMMENDATION Staff requests the City Council provide direction on any needed modifications to the draft 2021 Budget. Decreased funding for gas & electric utilities due to new systems ($9,000) Decreased funding for preventative maintenance needs ($5,000) Add’l funds for Equipment / Parts due to internal repairs on equipment and vehicles (non-warrantied fleet) $10,000 Decreased funding for Parking Lot Maintenance long-term plan (due to internal fund transfers) ($145,000) Add’l funds for sealcoat / crack sealing of City streets $20,000 Needed repairs & safety imp. on aging playground equipment $8,000 Decreased funds for chalk / paint / field supplies due to efficiencies of GPS Painter (“Speedy McStripes”) ($5,000) Decreased funding for Park Maintenance long-term plan (due to internal fund transfers and project delays) ($145,000) Initiative Increase over ’20 Budget Increased costs and new initiatives for Special Events programming (Food Truck Fest, Arts Festival, etc.) $9,000 Annual rent payment to National Guard $5,200 Snow removal contract at facilities $23,000 Initiative Increase over ’20 Budget Transfer ED Coord. Salary / Benefits to Port Budget $78,600 Elimination of contract with 3rd party retail-recruiter ($40,000) Add’l funds for marketing / recruitment initiatives $15,000 FUNDING REQUIREMENTS -USES August 4 , 2020 2020 2021 Adopted Proposed +/- Departments Budget Budget Difference Percentage ----------------------------------------------------------------------------------------------------------------------------------- Council Budget $341 ,600 $333 ,700 ($7 ,900) -2 .31 % Administration Budget 719 ,900 754 ,400 34 ,500 4 .79 % E lections Budget 62 ,300 20 ,000 (42 ,300 ) -67 .90% Finance Budget 665 ,600 697 ,900 32 ,300 4 .85% General Government Budget 37 3 ,900 40 7,800 33 ,900 9 .07 % Community Development Budget 1,247 ,000 1,214 ,500 (32 ,500 ) -2.61 % Police Budget 4 ,640,000 4 ,902 ,300 262,300 5 .65% Fire Budget 484 ,500 525 ,700 41 ,200 8 .50 % Public Works Operating Budgets : Gov ernment Buildings Budget 653 ,300 585 ,800 (67 ,500) -10 .33% Fleet Maintenance Budget 633 , 100 674 ,700 41 ,600 6 .57 % Street Maintenance Budget 1,479 ,900 1,397 ,600 (82 ,300 ) -5 .56 % Parks Maintenance Budget 1,177 ,600 1,057,400 (120 ,200) -10.21 % Park & Rec Budget -General Operating 1,462 ,000 1,544 ,600 82 ,600 5 .65% Park & Rec Budget -Steeple Ctr. Operations 149 ,200 162,200 13 ,000 8 .71 % Park & Rec Budget -Special Programs 87 ,600 85 ,600 (2,000) -2 .28 % Transfers -Arena Assistance 130 ,000 130,000 0 0 .00 % ----------------------------------------------------------------------- Total Operating Budgets -General Fund $14,307,500 $14,494,200 $186,700 1.30% Building CIP Requirements 0 0 0 0 .00% Street CIP Requ irements 877 ,897 904 ,234 26 ,337 3 .00% Equipment CIP Requ irements 640 ,000 813 ,200 173,200 27 .06% Insurance Budget Requirements 425 ,000 450 ,000 25 ,000 5 .88 % Port Authority Operating Le vy 112 ,000 168 ,000 56 ,000 50 .00 % Bonded Indebtedness 180 ,941 177 ,004 (3,937) -2 .18% Water Enterprise Fu nd 1,679 ,800 1,662 ,800 (17 ,000 ) -1.01 % Sewer Enterprise Fund 2,627 ,300 2,629,600 2,300 0 .09 % Storm Water Enterprise Fund 1,322 ,700 1,426 ,200 103 ,500 7 .82 % Street Light Utility F und 220 ,000 220 ,000 0 0 .00 % Arena Enterprise Fund 654 ,400 576 ,000 (78 ,400) -11 .98% ----------------------------------------------------------------------- Total Funding Requirements $23,047 ,538 $23,521 ,238 $473 ,700 2.06% ========== ========== ========== ========= August 4, 2020 Types Internal Revenue Generated : Licenses and Perm its Intergovernmental Charges for Services Fines & Forfeits Recreational Fees Miscellaneous Revenue s Transfers In Ente rprise Revenues Total Interna l Revenues Le vy So u rces: Special Levies Genera l Levy Total Levy Total Revenue Sources FUNDING REQUIREMENTS · SOURCES 2020 2021 Adopted Budget 800 ,300 1,104 ,800 1,058 ,800 95 ,000 298 ,400 215 ,000 3 ,500 6 ,504 ,200 Proposed Budget 803 ,000 1,135 ,400 1,027 ,300 95 ,000 296 ,400 140,500 3,500 6 ,514 ,600 +/- Difference Percentage 2 ,700 0 .34 % 30 ,600 2 .77 % (31 ,500) -2 .98 % 0 0 .00 % (2 ,000) -0 .67 % (74 ,500 ) -34 .65 % 0 0 .00 % 10 ,400 0 .16% -------------------------------------·----------------------------------- 10,080 ,000 10 ,015 ,700 (6 4 ,300 ) -0 .64 % 180 ,941 177,004 (3 ,937 ) -2 .18% 12 ,786 ,597 13 ,328 ,534 541 ,937 4 .24 % $12 ,967 ,538 $13,505 ,538 $538 ,000 4.15% $23 ,047 ,538 $23 ,521 ,238 $473,700 2.06% ========== ========== ========== ======== 2020 GENERAL PROPERTY TAX LEVY PAYABLE 2021 GENERAL FUND BUILDING GIP FUND STREET GIP FUND EQUIPMENT GIP FUND INSURANCE FUND PORT AUTHORITY OPERATING LEVY TOTAL GENERAL LEVY GENERAL LEVY BONDED INDEBTEDNESS G .O . IMPROVEMENT BONDS 2014A (Authorized -$0) G.O . CAPITAL IMPROVEMENT PLAN (GIP) REFUNDING BONDS 2015B (Authorized -$177 ,004) G.O . IMPROVEMENT BONDS 2017A (Authorized -$5,947) G .O. IMPROVEMENT BONDS 2018A (Authorized -$0) TOTAL BONDED INDEBTEDNESS GRAND TOTAL 2019 PROPERTY TAX LEVY Last Updated 7/29/20 $10 ,993,100 $0 $904 ,234 $813 ,200 $450,000 $168 ,000 $13,328,534 $0 $177 ,004 $0 $0 $177,004 $13,505,538 ============== Total Funding Requirements Less: Internal Revenues Equals: Revenues Needed SPREAD LEVY COMPUTATIONAL WORKSHEET (INCLUDING FIRE STATION LEVY) 2018 -------·-·-·---·- 21 ,775,081 9,900,300 ----------------· 11,874,781 County Auditor Adjustments (All Subtractions): Fiscal Disparities Distribution Levy (Metro Area) 1,236,215 (Proposed) 2019 2020 2021 _____________ ......... -----------------............................................. 22,659,634 23,047,538 23,521,238 10,339 ,200 10 ,080 ,000 10,015,700 ------------------·-------------------------------- 12,320,434 12,967,538 13,505,538 1,305,333 1,361,991 1,416 ,000 (2) Spread Levy Used to Compute Local Tax Rate lncrease/(Decrease) from Previous Year in Spread Levy 10,638,566 (1) 11,015,101 (1) 11,605,547 (1) 12,089,538 3.54% 5.36% 4.17% (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2021 Number Provided by Dakota County as of 8/12/19 (4% Increase Estimated by City Staff for 2021) Last Updated -7/29/20 Market Value Year Tax Capacity Tax Capacity Rates : City County School Dis tri ct Miscellaneous Totals City Market Referendum ISO #196 Market Ref Dakota County Ref Property Taxes : City County School District Miscellaneous Total Property Taxes City Market Referendum ISO #196 Market Ref Dakota County Ref Grand Total All Taxes Market Value Year Tax Capacity Tax Capacity Rates : City County School District Miscellaneous Totals Ci ty Market Referendum ISO #196 Market Ref Dakota County Ref Property Taxes: City County School District Miscellaneous Total Property Taxes City Market Referendum IS O #196 Market Ref Dakota County Ref Grand Total All Taxes Last Updated -7/29/20 CITY OF ROSEMOUNT WORKSHEET FOR ESTIMATING RESIDENTIAL PROPERTY TAXES (ISO #196 FIGURES ) {Rates Based on Proposed Preliminary Levy Numbers} 265,017 (Value After MN Exclusion) 277,300 (Payable 2019 Median) 283,220 (Value After MN Exclusion) 294.000 (Payable 2020 Median) 305,674 (Value After MN Exclusion) 314 ,600 (Est. Payable 2021 Median)(+7.01 %) 344 ,260 (Value After MN Exclusion) 350,000 --------------------------------- 2019 2,650 0 .39355 0 .25386 0.20613 0 .04227 0 .89581 2020 2,650 0 .38580 0 .24 133 0.19860 0 .04030 0.86603 0 .0000000 0 .0000000 0 .0026162 0 .0034367 0 .0000000 0.0000000 1,043 673 546 112 2,374 0 725 0 $3,100 1,022 640 526 107 2,295 0 953 0 $3,248 202 1 Est. 2,650 0 .37177 0 .24133 0.19860 0.04030 0.85200 0 .0000000 0 .0034367 0 .0000000 985 640 526 107 2,258 0 953 0 $3,2 1 1 2019 2 ,832 0.39355 0.25386 0.20613 0 .04227 0.89581 0 .0000000 0 .0026162 0.0000000 1,115 719 584 120 2 ,537 0 769 0 $3,306 2020 2,832 0.38580 0 .24 133 0 .19860 0.04030 0 .86603 0.0000000 0 .0034367 0 .0000000 1 ,093 683 562 114 2,453 0 1,010 0 $3,463 2021 Est. 2,832 0 .37177 0.24 133 0 .19860 0.04030 0.85200 0.0000000 0 .0034367 0 .0000000 1,053 683 562 114 2,41 3 0 1,0 10 0 $3,423 2019 3,057 0.39355 0.25386 0.20613 0.04227 2020 3,057 0.38580 0 .24133 0.19860 0.04030 2021 Est. 3,057 0 .37177 0 .241 33 0.19860 0.04030 --------------- 0.89581 0 .0000000 0 .0026162 0 .0000000 1,203 776 630 129 2,738 0 823 0 0.86603 0 .0000000 0 .0034367 0 .0000000 1,179 738 607 123 2 ,647 0 1,081 0 0.85200 0 .0000000 0 .0034367 0 .0000000 1,136 738 607 123 2,604 0 1,081 0 ----------------- $3,561 $3,728 $3,686 2019 3,443 0 .39355 0 .25386 0 .20613 0 .04227 0 .89581 0 .0000000 0 .0026162 0 .0000000 1,355 874 710 146 3,084 0 916 0 $4 ,000 2020 3,443 0 .38580 0.241 33 0.19860 0.04030 0.86603 0.0000000 0 .0034367 0.0000000 1,328 83 1 684 139 2,98 1 0 1,203 0 $4, 184 2021 Est. 3,443 0.37177 0.24133 0.19860 0.04030 0.85200 0.0000000 0.0034367 0.0000000 1,280 831 684 139 2,933 0 1,203 0 $4 , 136 City Taxes City Market Ref. Total Taxes -Median Increase I (Decrease) 371,510 (Value After MN Exclusion) 375,000 414 ,000 (Val ue After MN Exclusion) 414,000 History of Actual Tax Ca pacity Rates {Using ISO #196 Rate s) --------------- 2019 3,715 0 .39355 0 .25386 0 .206 13 0 .04227 0.89581 2020 3,715 0 .38580 0 .24133 0.19860 0 .04030 0.86603 202 1 Est. 3,715 0.37177 0.24133 0.19860 0.04030 0 .85200 0.0000000 0 .0000000 0 .0000000 0 .0034367 0 .0000000 0.0026162 0 .0034367 0.0000000 0.0000000 1,462 943 766 157 1,433 1,381 897 897 738 738 150 150 -------~ ----- 3,328 0 981 0 $4,309 3,217 0 1,289 0 $4,506 3,165 0 1,289 0 $4,454 ----------------- 2019 4 ,140 0.39355 0.25386 0.20613 0 .04227 0.89581 0 .0000000 0.0026162 0.0000000 1,629 1,051 853 175 2020 4 ,140 0.38580 0.24133 0.19860 0.04030 0 .86603 0.0000000 0.0034367 0.0000000 1,597 999 822 167 2021 Est. 4,140 0.37177 0.24133 0.19860 0 .04030 0 .85200 0.0000000 0.0034367 0 .0000000 1,539 999 822 167 ------------- 2016 0.43149 0 .28570 0 .24317 0 .05063 1.01099 0 .0000000 0 .0026999 0 .0000000 2017 0.41832 0.28004 0.23336 0 .04907 0 .98079 0 .0000000 0 .0027380 0 .0000000 2018 0.40961 0 .26580 0 .2 1352 0.04307 0 .93200 0 .0000000 0.00267 15 0 .0000000 Net Tax Ca pa city Percentages For Residential Homesteads: Equal to or Less Than $500,000 Over $500,000 2019 0 .39355 0 .25386 0 .20613 0 .04227 0 .89581 0 .0000000 0 .0026162 0.0000000 1.00% 1.25% 2020 0 .38580 0 .24133 0 .19860 0 .04030 0 .86603 0.0000000 0 .0034367 0 .0000000 1.00% 1.25% 2021 Est. (3.64% Decrease) 0.37177 (1), (2) 0.241 33 (2) 0.19860 (2) 0.04030 (2) 0.85200 0 .0000000 (2) 0.0034367 (2) 0.0000000 (2) 1.00% 1.25% 3,709 0 1,083 0 3,585 0 1,423 0 3,527 0 1,423 0 (For 2002 Through 20 11 Credit Applied to All O rganizations Proportionately} (For 20 12 and On C redit Eliminated-Replaced with Market Value Adjustment} $4,792 $5,008 $4,950 (1) This Figure Derived Us ing Figures Provided by Dakota County: (a) 2020 Projected Levy Less Fiscal Disparities as of 7129120 12 ,069,536 (b) Preliminary Net Tax Capacity Figure as of 2127120 (With M/V Exclusion) (c} Capt ured Tax In crement Tax Capacity as of 1014119 (d) Contribution to Fis cal Disparities as of6/10/19 (2) These Figures Pro vided by Dakota County as of 10/16/19 {For 2013 and on the Ci ty of Rosemount does not ha ve a Referendum Levy) 32,518,916 36,530,791 (1 ,111 ,173) (2 ,900,702) 32 ,518,916 0 .37177 (7 .15% Increase from Final Pay 2020) (13 .65% Increase from Final Pay 2019) (5 .09% Increase from Final Pay 2019) $1,093 so $1,093 $1,136 $0 $1 ,136 $44 Page One August 4 , 2020 Account# 101 31010 .00 101 31040 .00 101 32110.00 101 32160.00 101 32162.00 101 32180.00 101 32210 .00 101 32212 .00 101 32220 .00 101 32221 .00 101 32230.00 101 32240.00 101 32250 .00 101 32255 .00 101 32260 .00 101 32290 .00 101 31020 .00 101 31030 .00 101 31705 .00 101 31710 .00 101 31810 .00 10131811 .00 101 31920 .00 101 33 100.00 101 33416 .00 101 33416.xx 101 33416.xx 101 33418 .00 101 33423 .00 101 33425 .00 101 33425 .xx 101 33425 .xx 101 33620 .00 101 33630.00 101 33630 .00 101 33720.00 2021 BUDG ET WO RKSHEETS GENERAL FUND RE V ENUES Description Current Ad Valorem Taxes Fiscal Disparities Total Taxes (Tax) Alcoholic Beverage Licenses (L) Licenses to do Business (L) Lie to do Business-Rental Housing (L) Tobacco Licenses (L) Building Permit Revenue (L) Mineral Extraction Permit (L) Electrical Permit Revenue (L) Admin Fee -Electrical Permits (L ) Plumbing Permit Revenue (L) Animal Licenses (L) Sewer Permit Revenue (L) County Recording Fee-City's (L ) HVAC Permit Revenue (L) Other Non-Bus Lie & Permits (L) Total Licenses & Permits (L) Delinquent Ad Valorem Taxes (I) Mobile Home Taxes (I) Solar Energy Production Tax Gravel Taxes (I) Franchise Taxes -Regular Fees (I) Franchise Taxes -PEG Fees {I) Forfeited Ta x Sale Apportionment (I) Federal Grants & Aids (I) Police Training Reimbursement (I) Post Board Training Reimb State Aid (Tied to PERA) MSA for Streets -Maintenance (I) Ag Preserves Credit (I) Other State Grants & Aids (I ) PERA Aid All Other Grants & Aids Other County Grants & Aids (I) Police Services Levy-ISO #196 (I) Liaison Funding Other Organization Grants Total Intergovernmental (I) PAGE TOTALS 2017 Actual $8 , 145,752 1,175,131 2018 Actual $8,489 ,737 1,236,215 2019 Actual $8,718 ,622 1,305,333 2020 Adopted Budget $9 ,369,709 1,361,991 2021 Object Detail Amount 2021 Proposed Budget $9,577 ,100 1,416,000 ---------------------------------------------------------------------------------------------- 9 ,320 ,883 9 ,725 ,952 10,023 ,955 10 ,731 ,700 10,993,100 40 ,915 40,970 38,870 38 ,000 38 ,000 6,830 6,710 10,325 7,500 8,500 7,275 13,200 10 ,080 14 ,000 10,000 4,400 275 4 ,650 0 4 ,700 506 ,654 633,368 688 ,673 570,000 570 ,000 2,230 370 0 2,000 2,000 29 ,792 29,592 11,505 25,000 25 ,000 8,180 8,670 9,611 7,000 8,000 41 ,135 64,922 65,224 52 ,000 52,000 2,061 2,450 1,605 2,200 2,200 9,295 13 ,1 73 14 ,345 10 ,000 10 ,000 80 100 80 100 100 79,866 67,616 70 ,111 70 ,000 70,000 2,530 2,7 50 860 2,500 2,500 ---------------------------------------------------------------------------------------------------------- 741 ,243 884 , 164 925 ,939 800,300 803 ,000 75 ,127 36 ,112 13 ,669 0 0 9,626 11 ,028 10 ,597 11,000 11 ,000 0 2,434 1,961 0 0 108,451 133,246 142 ,873 150,000 150,000 236 ,550 239 ,794 235 ,154 240 ,000 240 ,000 0 0 0 0 0 0 0 0 0 0 5,881 4,484 3,273 0 0 186,837 216 ,545 256 ,896 250,000 25 ,000 25,000 195,000 225 ,000 42,495 42,960 300,431 300,000 300,000 1,337 3,326 410 3,000 3,000 89,415 95,785 88 ,925 80 ,000 80 ,0 00 12 ,900 67,100 25 ,000 30 ,263 30,263 31,000 30,200 66 ,071 67 ,393 69,044 69 ,800 71,200 71 ,200 0 0 0 0 0 --------------------------------------------------------------------------------------------------------------- 846 ,789 883,370 1, 153.495 1,104,800 1, 135,400 ---------------------------------------------------------------------------------------------------------------- 10 ,908,915 11,493,486 12 ,103,388 12 ,636 ,800 12 ,931,500 From County From County (Estimated 4 % Increase) Total Property Tax Levy for Fund 101 Garbage Haulers, Ped Licenses , etc. Every Other Year 2019-Prior Year Adjustment Alarm Permits & Fireworks Permits From County From County From County From County From Cable Company Moved to Separate Fund From County From State From State From State From State and State Agencies Dakota County Recycling Funds From ISO #1 96 Page Two 2021 BUDGET WORKSHEETS GENERAL FUND REVENUES August4 ,2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 101 34103.00 Zoning & Subdivision Fees (C) 33 ,7 55 67,175 62,930 50 ,000 50,000 101 34104 .00 Plan Checking Fees (C) 165 ,956 234 ,972 227,839 200 ,000 200 ,000 101 34105.00 Sales of Maps & Publications (C) 0 0 0 100 100 Maps & Spec Books 101 34107 .00 Assessmen t Fees 0 670 7 ,155 0 0 101 34108 .00 Admin Fees -Other Funds (C) 225 ,000 101 34108 .01 Applicable Funds Exc ept Const. 25 ,000 25 ,000 25,000 25 ,0 00 25 ,000 101 34108 .02 Construction Funds 86 ,178 200 ,537 158 ,562 200,000 200 ,000 85 % of 5% Fee for Const. Projects 10 1 34109 .00 Other Charges for Service (C) 4 ,791 3,589 9 ,783 4 ,000 4 ,000 10134110.00 Service Chg on Returned Chks (C) 30 60 30 100 100 101 34113.00 App lication Fees (C) 0 0 0 0 0 101 34150 .00 User Fees -SKB (C) 215 ,779 156 ,621 184,529 130,000 130,000 SKB Fees -C & D Cell Fees 101 34151 .00 User Fees/Host Agreements -SKB(C ) 0 68 ,100 0 0 0 Landscaping Agreement 101 34152.00 User Fees -SKB (C) 44 ,897 34 ,865 41 ,250 25 ,000 25,000 SKB Fees -MSW Ash Charges 101 34153 .00 User Fees -SKB (C) 364 ,324 483 ,515 449 ,221 220 ,000 220 ,000 SKB Fees -Base Service Charges 101 34160 .00 National Guard Maint Fees (C) 50 ,560 50,560 50.472 54,500 54 ,500 101 34160 .00 Shared Space Maint. Agreement 16,000 Snow Removal I Mowing 101 34160 .00 Building Maintenance Contract 38,500 101 3420 1.00 Special Police Services (C) 20.484 22 ,163 21 ,884 20 ,000 20 ,000 Contractual O/T for Officers 101 34202.00 Fire Services -Fireworks Permits (C) 900 1,240 800 1,000 1,000 No Longer Charge for Burning Permits 101 34203.00 Accident Reports (C) 0 0 0 0 0 101 34204.00 Day Care Inspection Fees (C) 200 0 100 100 100 101 34205 .00 Impound Fees (C) 0 464 907 2,000 1,000 101 34206.00 Other Police Services (C) 1,0 86 1,141 504 1,500 1,000 101 34207 .00 Other Fire Protection Services (C) 10,896 16 ,788 16 ,714 18,000 101 34207.01 U of M Fire Contract 5 ,500 5,500 101 34207 .02 Coates Fire Contract 11 ,500 11,500 101 34207.03 Other Billed Fire Calls 1,000 1,000 101 34303 .00 Mow Weeds (C) 1,681 867 310 1,500 1,000 101 34304.00 Sweep/Plow Streets (C) 465 948 954 500 1,000 101 34306 .00 Other Highway & Street Rev (C) 74,565 73,146 32 ,227 75 ,000 40,000 Sealcoat -De velo pers 101 34310.00 Right-of-Way Permits (C) 19.401 25 ,287 34 ,332 25 ,000 30 ,000 101 34407 .00 City Share of Metro SAC Chgs (C) 3,926 6 ,809 8.499 5 ,500 5,500 --------------------------------------------------------------------------------------------------- Tota l Charges for Services (C) 1,124 ,874 1.474 ,516 1,334 ,001 1,058 ,800 1,027,300 101 35101 .00 Court Fines (F) 101 ,327 94,281 109 ,083 95,000 95 ,000 From County ------------------------------------------------------------------------------------------------------------ Total Fines & Forfeits (F) 101 ,327 94 ,281 109 ,083 95 ,000 95 ,000 10 1 34718 .00 Tournament Fees (R) 18.463 18,455 19 ,9 82 20 ,000 20 ,000 101 34720 .00 Park Reservations (R) 3,330 2,441 3,032 4 ,000 4 ,000 101 34721.00 Softball Revenues (R) 12 ,924 6 ,671 0 0 0 101 34724 .00 Tennis Revenues (R) 2,661 2,118 1,817 2,200 2,200 101 34726.00 Rosettes Revenues (R) 1,693 1,923 1,913 2,000 0 101 34727 .00 Field Trip Revenues (R) 14 ,000 101 34727 .02 Adult/Senior Trips 20 ,123 12,722 10 ,159 14 ,000 14 ,000 101 34728 .00 Adu lt Exercise Class Revenues (R) 44 4 ,313 6 ,36 6 500 500 101 34730 .00 Run for the Gold Revenues (R) 3,660 4 ,357 2 ,941 4 ,800 4 ,800 101 34731 .00 Youth Soccer Lessons (R) 2,335 2,723 2 ,520 2,800 2,800 101 34732 .00 Adult Basketball Revenues (R) 1,954 2,147 1,774 2 ,000 2 ,000 101 34733 .00 Ot her Programs Revenues (R) 18.413 13 ,389 13,153 16 ,000 16 ,000 101 34735 .00 Camps Revenues (R) 44 ,73 5 41 ,059 48 ,285 40 ,000 40 ,000 101 34736 .00 T-Ball Lessons (R) 4 ,385 3,825 3,780 4 ,000 4 ,000 101 38080 .00 Banquet Room Fees (R) 54,577 72 ,288 75 ,268 75,000 75 ,000 10 1 38081 .00 Auditorium Fees (R) 7.423 8.475 9 ,118 8 ,000 8 ,000 10 1 38082 .00 Gymnasium Fees (R) 33 ,720 40 ,859 42 ,668 40 ,000 40,000 101 38086 .00 Classroom Fees (R) 9,560 11 ,601 13 ,633 11 ,000 11 ,000 101 38096 .00 Liq uor Provider Fees (R) 570 1,016 900 1,0 00 1,000 101 38097 .00 AN Rental Fees (R) 1.439 4 ,158 3,960 1,500 1,500 101 38154 .00 Adult Enrichment Revenues (R) 0 6 ,539 4 ,028 6,400 6.400 101 38201 .00 Rental Revenues (R) 31.490 37.490 48,806 40 ,000 40 ,000 Steeple Center Operations 101 38205 .00 AN Rental Revenues (R) 750 550 400 1,000 1,000 Steeple Center Operations 101 38207 .00 Liquor Provider Fees (R) 120 120 330 200 200 Steeple Center Operat ions 101 38209 .00 Miscellaneous Revenues (R) 0 0 0 0 0 Steeple Center Operations 101 38211 .00 Security Services (R) 2 ,072 1,862 5,275 2,000 2,000 Steeple Center Operations 101 38215 .00 Other Revenues (R) 0 0 0 0 0 Steeple Center Operations ----------------------------------------------------------------------------------------------------------- Total Recreatio n Fees (R) 276.441 301,100 320 ,105 298.400 296.400 ---------------------------------------------------------------------------------------------------------------- PAGE TOTALS 1,502,643 1,869,897 1,763,189 1.452 ,200 1.418.700 Page Three August4 ,2020 Account # 101 36101.00 101 36102 .00 101 36210 .00 101 36214 .00 101 36215 .00 101 36220.00 101 36220.01 101 36220 .02 101 36230 .00 101 36260 .00 101 36262 .00 101 36263 .00 101 36265 .00 10 1 36265 .01 101 36265 .02 101 38090.00 101 39202.00 101 39203 .00 2021 BUDGET WORKSHEETS GENERAL FUND REVENUES Description Principal -Special Assessments (M) Penalties & Interest -SIA (M) Interest Earn ings -Investments (M) Net Change in FV-lnvestments (M) Interest Earnings (M ) Rents & Royalties (M) Garden Plot Rentals Athletic Complex Land Rental Contribution/Donations (M) Other Revenue (M) Special Settlements (M) Wellness Program Revenues Use of Reserve Funds (M) Elections Balancing Health Insurance Adjustment City Concessions (M) Total Misc Revenues (M) Contribution from Enterprises (T) Transfer From (T) Total Transfers In (T ) PAGE TOTALS FUND TOTALS INTERNAL REVENUES 2017 Actual 0 345 162,918 (10,444) 919 4,230 11 ,399 30 ,991 25,500 1,000 0 0 0 2,883 2018 Actual 13 124 190,389 (26,946) 1,000 2,500 30,861 14,778 0 0 0 0 0 2 ,979 2019 Actua l 62 109 226 ,701 92 ,247 3,621 2,600 18,016 4,234 0 1,000 0 0 0 2 ,571 2020 Adopted Budget 0 0 150,000 0 1,000 2,500 0 15,000 0 1,200 0 42 ,300 0 3,000 2021 Object Detail Amount 2,500 0 0 0 2021 Proposed Budget 0 0 120,000 0 2,000 2,500 0 12 ,000 0 1,000 0 0 3,000 ------------------------------------------------------------------------------------------------------------- 229 ,742 215 ,698 351 ,160 215 ,000 140,500 3,500 3,500 3,500 3,500 3,500 221 1,925 3,880 0 0 ------------------------------------------------------------------------------------------------ 3,721 5,425 7 ,380 3,500 3,500 --------------------------------------------------------------------------------------------------- $233,462 $221,123 $358 ,540 $218 ,500 $144 ,000 $12 ,645 ,020 $13,584,506 $14 ,225 ,117 $14 ,307 ,500 $14,494 ,200 $3 ,324 , 137 $3,858 ,554 $4 ,201 ,162 $3 ,575 ,800 $3,501,100 ========== ========== ========== ========== ========= ========== Comments From Cou nty -101 Funded Projects From County Annual Market Value Changes From Checking Account Antenna to Water Utility Fund in 2016 Switched Health Ins. Providers Health Insurance Adj/Assignment Arena -Building & Grounds Main!. Funds Returned from Projects Grand Total Less : Ad Valorem & Fiscal Disparities Page Four August4 ,2020 Account# 101 34108 .00 101 34108 .01 101 34108 .02 101 34108 .03 101 34108 .04 101 34108 .05 101 34108 .06 1013410807 101 34108 .08 101 34108 .09 2021 BUDGET WORKSHEETS GENERAL FUND REVENUES Description General Fund Admin Fees Fund 201 Fund 202 Fund 203 Fund 206 Fund 207 Fund 605 Fund 606 Fund 607 Fund 650 Admin Fe es Breakdown Totals 2017 Actual $25 ,000 $25 ,000 2018 Actual $25,000 $25,000 2019 Actual $25 ,000 $25 ,000 2020 Adopted Budget $25 ,000 $25 ,000 2021 Object Detail Amount 6 ,000 2,500 2,500 2,500 2,500 1,000 1,000 1,000 6,000 $25 ,000 2021 Proposed Budget $25 ,000 $25,000 Comments Page One 2021 BUDGET WORKSHEETS COUNCIL August 4 , 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------··---------------------------------------·-------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 101 41110 103.00 Salaries & Benefits $40,323 $40 ,720 $39 ,674 $43 ,000 $43,800 Salary , Taxes, PERA & Benefits 101 41110 01 225 .00 Landscaping Materials 25,009 25 ,000 25,000 25,000 25,000 Funding From SKB Revenues 101 41110 01 226 .00 Tree/Landscaping Settlement 25,450 68,100 0 0 0 101 41110 01 307 .00 City Promotional Fees 32,300 101 41110 01 307 .01 Newsletter 14 ,704 16,586 19 ,854 21,200 21,200 4 Newsletters 101 41110 01 307.02 Chamber of Commerce Directory 1,000 0 2 ,545 1,100 1,100 101 41110 01 307.03 Community Survey 0 18,315 0 16 ,000 0 101 41110 01 307 .04 Community Events 7,000 10,000 10,000 10,000 10,000 Leprechaun Days Fireworks 1014111001 315.00 Special Programs 3 ,040 2 , 120 5 ,339 4 ,500 5 ,500 Promotions , Marketing , etc. 10141110 01 319 .00 Other Professional Services 54 ,000 1014111001 319 .01 Education Reimbursement 1,393 0 0 12,000 12,000 101 41110 01 319 .02 Intergovernmental Initiatives 12,908 11 ,398 12,023 15 ,000 15,000 10141110 01 319 .03 Open Government I Transparency 7,500 7 ,500 7,500 17 ,000 17,000 Open Gov I POLCO I etc. 101 41110 01 319.04 County Broadband System 0 7 ,507 10,800 10 ,000 10,000 Operating Costs 1014111001 321 .00 Telephone Costs 700 1014111001 321 .02 Mayor's Cell Phone 386 386 637 400 700 101 41110 01 329 .00 Other Communication Costs 456 0 0 500 500 Newspaper Ads I Open Houses 10141110 01 331 .00 Travel Expense 8,000 10141 11 00 1 331 .01 NLC Conference 4 ,207 2 ,748 3 ,489 6 ,000 6,000 1014111001 331.02 Miscellaneous Travel 854 1,524 1,750 2,000 2,000 101 41110 01 433.00 Dues & Subscriptions 35 ,100 101 41110 01 433 .01 LMC Dues 18,482 18,662 19 ,394 19 ,000 20,000 101 41110 01 433 .02 Metro Cities Dues 7,733 7,868 7 ,919 8 ,000 8,000 101 41110 01 433 .03 Oak Cty Regional Chamber 0 85 0 100 100 1014111001 433 .04 NLC Dues 1,861 1,917 1,953 2 ,000 2 ,000 101 41110 01 433 .05 Miscellaneous Dues 0 0 0 0 5,000 MLC Dues 101 41110 01 435 .00 Books & Pamphlets 0 0 0 100 100 1014111001437.00 Conferences & Seminars 14,000 101 41110 01 437.01 Registration & Hotel-LMC Conf 2,350 1,500 3,586 2,000 2,000 101 41110 01 437 .02 Reg istration & Hotel-NLC Conf 7 ,764 4 ,270 8 ,806 9 ,000 9 ,000 101 41110 01 437 .03 Miscellaneous Conferences 769 300 280 3 ,000 3,000 101 41110 01 439 .00 Other Miscellaneous Charges 394 95 308 400 400 101 41110 01 598 .00 Council Designated 16 ,667 79,177 148,437 60 ,000 60 ,000 101 41110 01 598 .01 Assignment for Health Ins . Increases 0 0 0 0 0 101 41110 01 598 .02 IGH Ice Time Agreement 0 41 ,000 41,000 41 ,000 41 ,000 10141110 01598 .03 Salary & Benefit Contingency 0 0 0 0 0 101 41110 01 599 .00 Employee Recognition Costs 13 ,300 101 41110 01 599 .01 Employee Recognition Costs 3,395 3 ,900 4 ,236 6 ,000 6,000 101 41110 01 599 .02 Vending Machine Costs 2 ,506 2,739 2 ,093 4 ,000 4,000 Offset by Revenue from Machines 101 41110 01 599 .03 Commemorations 1,309 1,449 1,502 1,500 1,500 1014111001 599 .04 CommissionNolunteer Recognition 0 1,431 2 ,838 1,800 1,800 ------------------------------------------------------------------------------------------ PAGE TOTALS $207,460 $376 ,297 $380,962 $341 ,600 $333 ,700 DEPARTMENT TOTALS $207 ,460 $376 ,297 $380,962 $341 ,600 $333 ,700 ======== ======== ======== ======== ======== ======== Page One 2021 BUDGET WORKSHEETS ADM INISTRATION August 4 , 20202 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- A ll Salary Costs Inclusive of 101 41320 101 .00 Salaries & Benefits $524,232 $522 , 162 $542 ,437 $571,300 $600,600 Sa lary, Taxes, PERA & Benefits 101 41320 102 .00 Full-Time Overtime 0 0 0 0 0 101 41320 103.00 Part-Time Salaries & Benefits 0 0 1,859 6,000 2 ,000 1014132001 209 .00 Ot her Office Su pplies 55 70 340 500 500 Miscellaneous Purchases 1014132001 313 .00 Temporary Service Fees 0 0 0 0 0 101 41320 01 319 .00 Other Professional Services 0 0 0 0 0 1014132001 321 .00 Telephone Costs 2,002 1,975 1,909 2,000 2,800 Administration Cell Phones 1014132001 331 .00 Travel Expense 1,300 1014132001 331 .01 NLC Conference 0 0 0 0 0 1014132001 331 .02 Conference Travel 809 602 530 800 800 1014132001 331 .03 Miscellaneous Travel 413 106 27 1 500 500 1014132001 433 .00 Dues & Subscriptions 3,700 101 41320 01 433 .01 MCMADues 269 283 298 300 300 101 41320 01 433 .02 MAMA Dues 0 0 90 0 100 101 41320 01 433 .03 MCFOA Dues 45 0 91 100 100 101 41320 01 433 .04 Munici-Pals 25 25 0 100 100 101 41320 01 433 .05 ll MC Dues 200 200 0 200 200 City Clerk Association 101 41320 01 433 .06 ICMA Dues 2,711 1,887 2 ,139 2,000 2 ,200 101 41320 01 433 .07 A PM P Dues 60 0 0 100 100 101 41320 01 433 .08 Ro tary Membership 0 0 507 600 600 101 41320 01 435 .00 Books & Pamph lets 34 60 0 100 100 101 41320 01 437 .00 Conferences & Seminars 10,200 101 41320 01 437 .01 Registration & Hotel -Co nfere nce 0 550 2,582 2,500 2,500 1014132001 437 .02 Registratio n & Hotel -MCMA 1,420 1,397 0 0 0 Com bined with "437 .01" 101 41320 01 437 .04 Staff ( 1) Each 0 0 0 0 0 1014132001 437 .05 Miscellaneous Sem inars 705 945 1,480 1,400 1,500 1014132001 437 .06 Registration & Hotel -ICMA 3,338 3,013 3,961 3,500 3,500 101 41320 01 437 .07 City Clerk Training 1,841 2,146 2 ,303 2,400 2,400 101 41320 01 437 .08 Reg istration & Hotel -NLC 0 0 0 0 0 101 41320 01 437 .09 Miscellaneous Meetings 175 203 110 300 300 1014132001 439 .00 Other Miscellaneous Charges 259 75 107 200 200 101 41320 01 580 .00 Other Equipment Purchases 226 423 0 1,000 1,000 -------------------·--------------------------------------------------------------------··-- PAG E TO TALS 538 ,819 536 , 122 561,014 595 ,900 622 ,400 Page Two 2021 BUDGET WORKSHEETS ADMINISTRATION August 4 , 20202 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 10 1 41 320 31 305 .00 Medical & Dental Fees 2 ,800 Employee Drug Testing 101 41320 31 305 .01 Pre-Employment Physicals 1,320 1,037 506 1,300 1,300 10 1 41320 31 305 02 Employee Drug Testing 1,090 1,294 1,238 1,300 1,500 1014132031 305 .03 PCORI Fees 407 466 490 0 0 101 41320 31 305 .04 Reinsurance Costs 3 ,024 0 0 0 0 101 41320 31 306 .00 Personnel Testing & Recruitment 382 6 ,000 6,001 6 ,000 6 ,000 101 41320 31 315 .00 Special Programs 9 ,700 10 1 41320 31 315 .01 Employee Training 1,000 4 ,890 6 ,265 7,700 7 ,700 Add Alliance for Innovation 101 41320 31 315 .02 Health & Wellness 984 1,854 1,498 2 ,000 2 ,000 Wellness & Health Management 10 1 41320 31 315.04 SWIWC Co-op Wellness Grant 0 0 0 0 0 Costs Reimbursed by Grants 10 1 41320 31 319.00 Other Professional Services 6 ,600 1014132031 319 .01 Labor Consultant 0 845 0 1,000 1,000 101 41320 31 319 .02 Labor Legal Issues 0 45 945 1,000 1,000 101 41320 31 319 04 COBRA Consultant 625 662 473 800 800 101 41320 31 319 05 FlexNEBA Administrative Fees 3 ,828 3 ,626 3 ,662 3,800 3 ,800 101 41320 31 319 .06 SWWC Co-Operative Dues 0 0 0 0 0 1014132031 331 .00 Travel Expense 626 315 433 1,000 1,000 1014132031 341 .00 Employment Advertising 516 325 0 1,000 1,000 Vacancies 101 41320 31 391 .00 P.C . Maintenance 3 ,500 4 , 100 4 ,305 4 ,200 4 ,400 Neo Gov -Annual Maintenance 101 41320 31 394 .00 P .C . Software Purchases 0 0 0 0 0 Neo Gov -Initial Purchase 10 14132031 433 .00 Dues & Subscriptions 1,200 101 41320 31 433 02 IPMA Dues 348 298 298 400 400 101 41320 31 433 .03 MPELRA Dues 760 643 430 800 800 101 41320 31 435 .00 Books & Pamphlets 0 0 0 100 100 Books & Training Materials 1014132031 437 .00 Conferences & Seminars 1,700 101 41320 31 437 .01 MPELRA State Conference 860 848 1,253 1,000 1,300 101 41320 31 437 .02 Personnel Seminars 295 275 0 400 400 101 41320 31 437 .03 Safety , Supervisor, Policy 0 0 0 0 0 10 14132041 315 .00 Special Programs 500 10 14132041 315 .01 General Marketing 300 0 0 300 500 1014132041 315 .02 Historical Monuments 0 0 0 0 0 101 41320 41 319 .00 Other Professional Services 6 ,300 1014132041 319 .01 Website 4 ,859 5 ,861 5 ,996 6 ,300 6,300 1014132041 319 .02 Website Improvements 0 0 0 0 0 1014132041 328 .00 Cable Supply Costs 61 1,808 66 1,000 1,000 Cable Supplies, Software 1014132041 329 .00 Other Communication Costs 87 ,100 1014132041 329 .01 Cable JPA Payment-General C ity 59 ,256 65,670 74 ,001 81 ,100 87,000 10 14132041 329 .02 V ideo Streaming Council Mtgs 60 60 60 100 100 1014132041 329 .03 City Cable HD Boxes 0 75 0 0 0 101 41320 41 331 .00 Travel Expenses 43 5 6 100 300 101 41320 41 433 .00 Dues & Subscriptions 162 0 85 100 200 MAGC 101 41320 41 437 .00 Conferences & Seminars 0 0 0 200 600 Technical Courses 101 41320 41 580 .00 Other Equipment Purchases 495 244 171 1,000 1,500 ------------------------------------------------------------------------------------------ PAGE TOTALS $84 ,801 $101 ,246 $108, 183 $124,000 $132 ,000 DEPARTMENT TOTALS $623,620 $637 ,369 $669 , 197 $719,900 $754 ,400 ======== ======== ======== ======== ======== ======== Page One August4 , 2020 Account# 2021 BUDGET WORKSHEETS ELECTIONS Description 2017 Actual 2018 Actual 2019 A ctual 2020 Adopted Budget 2021 Object 2021 Detail Proposed Amount Budget Comments ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 101 41410 01 103.00 Part-Time Salaries $0 $34 ,680 $0 $50 ,000 $0 Election Judges & Front Desk 101 41410 01 203 .00 Printed Forms & Paper 0 0 0 200 0 Ballots & Programming 101 41410 01 208 .00 Miscellaneous Supplies 0 471 0 500 0 101 41410 01 219 .00 Other Operating Supplies 0 437 0 500 0 Food for Election Judges 101 41410 01 242 .00 Minor Equipment 0 633 0 200 0 Signs & Miscellaneous 101 41410 01 304 .00 Legal Fees 0 0 0 0 0 101 41410 01 319 .00 Other Professional Services 0 0 0 0 0 101 41410 01 321 .00 Telephone Costs 0 0 0 0 0 101 41410 01 351.00 Legal Notices Publishing 0 349 0 400 0 Election Publications 101 41410 01 391 .00 P .C . Maintenance 0 0 0 1,000 0 Elections SIW Maintenance Costs (Utiliizing Laserfiche) 1014141001 409 .00 Other Contracted Repair & Main! 5 ,000 101 41410 01 409.01 Maintenance for Voting Mach ines 4 ,316 4 ,316 0 5,000 5 ,000 Annual Main!. Fee to Dakota Cty. 101 41410 01 409.02 Poll Pad Maintenance 0 0 0 3 ,500 0 101 41410 01 412 .00 Building Rental 0 0 0 0 0 Possible Rent for Locations 101 41410 01 439 .00 Other Miscellaneous Charges 0 23 0 0 0 101 41410 01 580 .00 Other Equipment Purchases 15 ,000 0 2 ,753 1,000 15 ,000 Additional Voting Booths ---------------------------------------------------------------------------------------- PAGE TOTALS $19 ,316 $40 ,909 $2 ,753 $62,300 $20 ,000 DEPARTMENT TOTALS $19 ,316 $40 ,909 $2 ,753 $62 ,300 $20 ,000 ======== ======== ======== ======== ======== Page One 2021 BUDGET WORKSHEETS FINANCE August 4 , 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 101 41520 101 .00 Salaries & Benefits $416 ,765 $435 ,957 $515 ,373 $536 ,800 $558 ,600 Salary, Taxes , PERA & Benefits 101 41520 102 .00 Full-Time Overtime 2 ,983 5 ,251 542 4 ,000 4 ,000 101 41520 103.00 Part-Time Salaries & Benefits 15 ,781 32 ,202 0 0 0 101 41520 01 321 .00 Telephone Costs 1,317 1,433 2 ,012 2 ,200 2,200 Allowances (2) & Willie (City) 101 41520 01 331 .00 Travel Expense 1,400 101 41520 01 331 .01 Finance Director 336 378 378 1,200 1,200 National Conference Included 101 41520 01 331 .02 Staff 0 0 135 200 200 101 41520 01 391 .00 P .C . Maintenance 82 ,100 101 41520 01 391 .02 Remote Desktop Services 1,400 1,400 1, 150 1,500 1,500 101 41520 01 391 .03 lncode Software Maintenance 10 ,690 11, 193 12,626 12,500 13 ,000 101 41520 01 391 .04 General Network Support 40,000 25 ,000 30 ,000 30,000 30 ,000 Block Hours of Support Time 1014152001 391 .06 Fixed Asset Main! Contract 1,500 1,500 1,500 1,600 1,600 " Increased Cost and Need " 101 41520 01 391 .07 Miscellaneous Repairs & Maint. 2 ,384 1,289 2 ,968 2 ,500 3 ,000 101 41520 01 391 .08 Anti-Virus Software Renewal 1,943 1,745 1,188 2 ,500 2 ,000 101 41520 01 391 .09 File Server Software Maint. 5 ,334 13,339 11 ,382 9 ,000 12 ,000 1014152001 391 .10 Managed Backup Services 18 ,725 18,840 18,840 19,000 19 ,000 101 41520 01 392 .00 P .C . Accessories & Supplies 1,239 2,488 3,431 5 ,000 5,000 City System Supplies 1014152001 393 .00 P .C . Hardware Purchases 669 2 ,009 9,762 3 ,000 3,000 101 41520 01 394 .00 P .C . Software Purchases 36 ,500 101 41520 01 394 .01 Annual Microsoft Payments 0 0 6,440 6,500 6 ,500 Windows 10 Annual Payment 101 41520 01 394 .02 Miscellaneous S/W Purchases 581 3 ,205 1,124 2 ,000 2 ,000 101 41520 01 394 .03 Office 365 0 0 0 21 ,000 28 ,000 Office 365 Annual Payment *Added Teams and Add'I Users* 101 41520 01 409 .00 Other Contracted R & M 374 225 225 300 300 Non-Computer Equ ipment 101 41520 01 433 .00 Dues & Subscriptions 700 101 41520 01 433 .02 MnGFOA -Finance Director 60 50 50 50 50 101 41520 01 433 .03 MnGFOA -Staff 360 300 300 300 300 101 41520 01 433 .04 GFOA -Finance Director & Asst. 340 340 340 350 350 101 41520 01 435 .00 Books & Pamphlets 100 1014152001 435 .01 Accounting Related Books 0 0 0 50 50 101 41520 01 435 .02 Finance Related Books 0 0 0 50 50 101 41520 01 437 .00 Conferences & Seminars 2,800 101 41520 01 437 .02 MnGFOA Annual Cont (F/D) 596 581 618 700 700 101 41520 01 437 .03 GFOA National Cont (F/D) 0 0 0 1,500 1,500 101 41520 01 437 .04 Staff Development 0 2 ,950 290 200 200 101 41520 01 437 .05 Miscellaneous Seminars 262 100 542 400 400 Misc. Meetings, Lunches, etc. 101 41520 01 439 .00 Other Miscellaneous Charges 39 141 294 200 200 Contingencies 101 41520 01 570 .00 Office Equipment & Furnishings 673 715 1,429 1,000 1,000 ------------------------------------------------------------------------------------------ PAGE TOTALS $524 ,351 $562 ,630 $622 ,941 $665,600 $697 ,900 DEPARTMENT TOTALS $524 ,351 $562,630 $622 ,941 $665 ,600 $697 ,900 ======== ======== ======== ======== ======== ======== Page One August 4 , 2020 Account# 2021 BUDGET WORKSHEETS GENERAL GOVERNMENT Description 101 41810 01 202 .00 Duplicat ing & Copying 1014181001 202 .02 Copying Costs 101 41810 01 203 .00 Printed Forms & Paper 101 41810 01 203 .01 Copy Paper 1014181001 203 .02 General Receipt Books 101 41810 01 203 .03 Purchase Orders 101 41810 01 203 .04 Payroll & AJP Checks 101 41810 01 203 .06 Miscellaneous Forms 101 41810 01 204 .00 Envelopes & Letterheads 101 41810 01 204 .01 Letterhead 101 41810 01 204 .02 Plain Envelopes 101 41810 01 204 .03 AJP & Payroll Envelopes 101 41810 01 204 .04 10 x 13 Envelopes 101 41810 01 209 .00 Other Office Supplies 101 41810 01 221 .00 Equipment Parts 101 41810 01 242 .00 Minor Equipment 101 41810 01 242 .02 Credit Card Equipment 101 41810 01 301 .00 Auditing & Accounting Services 1014181001 301 .01 Audit & General Consulting Fees 101 41810 01 301 .02 Dakota County Assessment Fees 1014181001 301 .03 Oak Cty Truth In Taxation Costs 101 41810 01 303 .00 Engineering Fees 101 41810 01 304 .00 Legal Fees 101 41810 01 319 .00 Other Professional Services 101 41810 01 319 .01 City Code Update 101 41810 01 319 .02 City Code Web Fees 101 41810 01 319 .03 State Building Report 101 41810 01 319 .04 Continuing Disclosure Fees 101 41810 01 319 .05 Annual User Fee Study Update 101 41810 01 319 .06 Arbitrage/Rebate Calculations 101 41810 01 319 .10 UMore Professional Services 101 41810 01 320 .00 Credit Card Activity Fees 101 41810 01 320 .01 Utilities' Fees 101 41810 01 320 .02 101 41810 01 320 .03 101 41810 01 320 .04 101 41810 01 320 .05 1014181001 321 .00 1014181001 321 .01 1014181001 321 .02 1014181001 321 .03 1014181001 321 .04 101 41810 01 322 .00 101 41810 01 329 .00 101 41810 01 339 .00 1014181001 351 .00 1014181001 351 .01 1014181001 351 .03 1014181001 391 .00 101 41810 01 392 .00 101 41810 01 393 .00 Parks & Recreation Fees Building Fees General Fees Parks & Recreation On-Line Fees Telephone Costs General Phone Costs (& Internet) Domain Housing Software Maintenance Costs Phone System Hardware Postage Costs City Cab le Boxes Other Transportation Expenses Legal Notices Publishing Costs for Public Notices Budget & Audit Publ icat ions P.C. Maintenance P.C. Software Purchases P.C. Hardware Purchases 101 41810 01 433 .00 Dues & Subscriptions 101 41810 01 439 .00 Other Miscellaneous Charges 101 41810 01 450 .00 Sales Tax on Purchases 101 41810 01 580 .00 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS 2017 Actual 13 ,622 5,696 0 1,349 1,725 488 526 852 489 0 15 ,887 0 0 58 ,400 5,940 1,550 0 77 ,750 805 500 3,590 0 3,670 10 ,050 7,817 0 5,950 15 ,208 766 0 28 ,478 60 11 ,295 615 12 ,642 0 65 3,371 803 18 ,415 6 ,315 3,913 1,272 240 0 13 ,088 2018 Actual 17 ,347 2,670 0 1,362 453 1,532 1,290 0 489 736 15 ,484 0 0 57,786 6 ,146 1,532 0 52,110 847 500 4 ,470 3,600 2 ,630 6 ,500 1,576 0 6,611 18 ,851 1,228 0 30 ,106 60 15 ,274 2 ,480 14 ,722 0 977 3,828 1,240 19 ,971 6,911 3 ,832 585 240 0 13 ,966 2019 Actual 16 ,465 4 ,296 503 0 646 3,827 758 1,632 738 0 14,314 417 0 66 ,700 6,835 1,613 0 51,271 223 500 4 ,160 3,290 0 3,850 0 0 8,732 49 ,075 1,486 0 37 ,549 60 15 ,468 1,114 14 ,372 0 69 3, 190 1,246 19,732 9,740 3,699 916 240 0 13 ,943 2020 Adopted Budget 17 ,000 3,500 800 1,400 400 1,500 700 600 500 800 16 ,000 0 500 70 ,000 6,500 1,700 0 70 ,000 2,000 500 4 ,500 3,000 3,000 10 ,000 0 0 7,000 20 ,000 1,500 0 36 ,000 100 18 ,000 3,000 17 ,000 1,200 1,000 3,900 1,300 20 ,000 10 ,000 4,000 700 300 0 14 ,000 $333 ,203 $319,942 $362,670 $373 ,900 $333 ,203 $319 ,942 $362 ,670 $373 ,900 2021 Object Detail Amount 17 ,000 3,500 800 1,400 400 0 700 600 500 800 500 77 ,000 7,000 1,700 2,000 500 5,000 3,000 4,000 10 ,000 0 0 10 ,000 50 ,000 1,500 0 39 ,000 500 18 ,000 3,000 3,900 1,300 2021 Proposed Budget $17,000 6 ,100 2 ,600 Comments Business Cards , etc. 16,000 General Office Supplies 0 City Hall Equipment Repairs 500 85 ,700 0 55 ,000 24 ,500 61 ,500 60 ,500 15 ,000 1,200 $500-$700 for One Terminal Single Audit in 2021 for CARES Fees Paid to Baker Tilly Fees Paid to Baker Tilly (Bonds) Fees Paid to Baker Tilly Fees Paid to Baker Tilly (Bonds) In-House Engineer or Bill Out O/L Added -Moved to Utilities Added Additional Licenses Phone Upgrades, Headsets, etc. 1,000 Vehicle Licensing 5,200 All Departments State Mandated Publications 21 ,000 Laserfiche Ma intenance 10,000 Consultant Fees 4 ,000 Scanner Purchase 700 Newspapers 300 Direct Deposit Filing Fees/Flex 0 20 ,000 Office Machines-All Buildings $407 ,800 $407 ,800 ======== ======== ======== ======== ======== ======== Page One 2021 BUDGET WORKSHEETS COMMUNITY DEVELOPMENT August4 ,2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 101 41910 101 .00 Salaries & Benefits $990 ,675 $967 ,881 $1,042 ,175 $1 ,172 ,100 $1 , 137,400 Salary, Ta xes, PERA & Benefits 101 41910 102 .00 Full-Time Overtime 1,097 380 33 1,000 1,000 101 41910 103 .00 Part-Time Salaries & Benefits 15 ,929 26 ,285 21,462 28 ,500 34 ,300 1014191011 103 .00 PfT GIS Technician 16 ,800 101 41910 99 103.01 Planning Commission Members 2,500 101 41910 99 103.02 Part-Time Code Enforcement 15 ,000 101 41910 01 201.00 Office Accessories 0 0 0 0 0 Calendars , Planners , etc . 101 41910 01 202 .00 Duplicating & Copying 10,517 1,463 5 ,000 5,000 2,000 Includes Comp Plan Printing 101 41910 01 203.00 Printed Forms & Paper 774 315 723 4 ,000 3 ,000 Forms , Stickers , Tags , etc. 101 41910 01 205 .00 Drafting Supplies 0 0 0 0 0 101 41910 01 208 .00 Miscellaneous Supplies 0 23 45 0 0 101 41910 01 209 .00 Other Office Supplies 285 2,197 971 1,500 1,500 Dictation Devi ces & Tapes 101 41910 01 219 .00 Other Operating Supplies 2,606 962 567 2,000 2,000 101 41910 01 241 .00 Small Tools 248 302 266 300 300 Inspectors' Tools 101 41910 01 302 .00 Architects' Fees 0 0 0 0 0 101 41910 01 312 .00 Contract Fees 0 45 ,000 0 0 0 Moved $45 ,000 to PI A Fund 101 41910 01 319 .00 Other Profess ional Services 1,500 27 ,251 182 2,000 2,000 Consultant 101 41910 01 329 .00 Other Communication Costs 2,655 4 ,383 3 ,949 4 ,000 4 ,500 Cell Phones 101 41910 01 331.00 Travel Expense 618 1,006 447 800 800 1014191001 391.00 P .C . Maintenance 4,085 4,085 4 ,374 4 ,200 4 ,500 Permitworks Support 101 41910 01 392 .00 P .C. Accessories & Supplies 813 0 37 2,000 1,000 101 41910 01 393 .00 P .C . Hardware Purchases 0 0 0 0 0 101 41910 01 409 .00 Other Contracted Repair & Main!. 1,360 501 988 2,000 2,000 Mow Weeds-From Street Main!. 101 41910 01 433 .00 Dues & Subscriptions 3,700 101 41910 01 433 .01 APA/AICP 1,152 768 1,379 1,700 1,700 101 41910 01 433 .02 ICC 135 465 225 400 400 101 41910 01 433 .03 AMBO 200 0 0 500 500 101 41910 01 433 .04 10 ,000 Lakes 125 250 125 150 150 101 41910 01 433 .06 Trade Magazines 0 0 0 0 0 101 41910 01 433 .07 Planner's Journal 0 0 0 0 0 101 41910 01 433 .08 Sensible Land Use Coalition 544 0 0 400 400 101 41910 01 433 .09 AACEO/MAHCO 0 0 0 100 100 101 41910 01 433 .10 Other Dues & Subscriptions 60 535 383 350 450 101 41910 01 435 .00 Books & Pamphlets 1,075 133 0 800 800 Manuals, References , IBC Books 101 41910 01 437 .00 Conferences & Sem inars 10 ,300 101 41910 01 437 .01 State Bldg Official School 285 0 890 500 500 101 41910 01 437 .02 Spring & Fall Code Updates 220 255 0 500 500 101 41910 01 437 .03 Building Inspector Training 1,382 1,961 990 1,000 1,500 101 41910 01 437 .04 Computer Training 0 0 0 200 200 101 41910 01 437 .05 Clerical Seminars 172 60 0 300 300 101 41910 01 437 .06 Planning Seminars 854 2,475 2,198 2,500 2,500 1014191001 437 .07 ISTS Training 2,053 1,146 520 1,000 1,000 101 41910 01 437 .08 State Planning Conference (2) 615 0 1,374 2,000 2,000 101 41910 01 437 .09 Planning Commissioner Training 0 91 0 500 500 101 41910 01 437 .10 Gen'I Seminars 144 205 511 1,000 1,200 101 41910 01 437 .11 Code Enforcement Training 0 0 0 300 100 101 41910 01 439 .00 Other Miscellaneous Charges 290 21 1 69 400 400 Contingencies 101 41 9 10 01 586 .00 Computer Equipment Purchases 0 0 0 3,000 3 ,000 Tablets for Employees --------------------------------------------------------·---------------------------------·----------- PAGE TOTALS $1 ,042,468 $1 ,090 ,590 $1 ,089 ,882 $1 ,247 ,000 $1 ,214 ,500 DEPARTMENT TOTALS $1 ,042,468 $1 ,090 ,590 $1,089 ,882 $1 ,247 ,000 $1,214 ,500 ========= ========= ========= ========= ======== ========= Page One August4,2020 Account# 2021 BUDGET WORKSHEETS POLICE Description 101 42110 101 42110 101 42110 101 42110 101 42110 101 42110 101 .00 Salaries & Benefits 101 .00 Salaries & Benefits 101 .00 102.00 102 .01 102 .02 Salaries & Benefits Full-Time Overtime Regular Overtime Hours Contracted O/T 101 42110 103.00 Part-Ti me Sa laries & Benefits 1014211099 103 .00 Part-Time CSO's 101 42110 01 202 .00 101 42110 01 203 .00 101 42110 01 204 .00 101 42110 01 207 .00 101 42110 01 207 .01 101 42110 01 207 .02 101 42110 01 207 .03 101 42110 01 207 .04 101 42110 01 208 .00 101 42110 01 208 .01 101 42110 01 208 .02 101 42110 01 208 .03 101 42110 01 209 .00 1014211001 211 .00 1014211001 211 .01 1014211001 211 .02 101 42110 01 217 .00 101 42110 01 217 .01 101 42110 01 217 .02 101 421 10 01 217 .03 101 42110 01 219 .00 101 42110 01 219 .01 101 42110 01 219 .02 1014211001 221 .00 1014211001 241 .00 1014211001 241 .01 1014211001 241 .02 101421 1001 241 .03 101 42110 01 242 .00 101 42110 01 242 .01 101 42110 01 242 .02 101 42110 01 242 .03 101 42110 01 304 .00 101 42110 01 305 .00 101 42110 0 1 305 .01 101 42110 01 305 .02 101 42110 01 306 .00 101 42110 01 313 .00 101 42110 01 315 .00 101 42110 01 316 .00 101 42110 01 316 .01 101 42110 01 316 .02 Duplicating & Copying Printed Forms & Paper Envelopes & Letterheads Training & Instructional Supplies Practice Ammu nition Service Ammun ition Other Supplies SWAT Ammunition Miscellaneous Supplies DARE Donations Equipment Donations /Forfeitures Other Grants Expenditures Other Office Supplies Cleaning Supplies Blanket Cleaning Squad Cleaning Clothing Allowance CSO's Reserves Other Supplies Other Operating Supplies Evidence Bags , Drug Kits, Misc . Investigation Software Equipment Parts Small Tools Evidence Processi ng Equipment Camera and Video Supplies Winsc ribe Minor Equipment Less Lethal Tactical Equipment MAAG Equipment Drug Task Force Equipment Legal Fees Medical & Dental Fees Physicals Seized Narcotic Testing Personnel Testing & Recruitment Temporary Service Fees Specia l Programs Animal Care Services Impound & Care Fees "Future Use" 1014211001 319 .00 Other Professiona l Services 1014211001 319 .01 Dispatch Services -Operations 1014211001 319 .02 Policy Development & Training 101 42110 01 319 .03 Mediation Services 101 42110 01 319 .04 Electronic Crimes Unit Fees 101 42110 01 319 .05 Emergency Mgmt Plan Update 101 42110 01 321 .00 Telephone Costs 101 42110 01 321 .01 Cell Phones 101 42110 01 323 .00 Radio Units 101 42110 01 323 .01 Radios 101 42110 01 323 .02 Radars 101 42110 01 323 .03 Radio Warranty 1014211001 331 .00 Travel Expense 1014211001 331 .01 MN Chiefs Spring Conference 1014211001 331 .02 IACP or FBINAA Conference 101 42110 01 331 .03 Outstate Investigations & Conf. 1014211001 331 .04 SWATConference 101 4211 o 01 331 .05 CAN-AM Narcotic Confe rence 1014211001 331 .06 Juvenile Officers Conference 101 42110 01 331 .07 Meeting Reimbursements PAGE TOTALS 2017 Actual 2018 Actual 2019 Actual 2020 Adopted Budget $3 ,024 ,978 $3 ,297,438 $3 ,338,237 $3,677 ,3 00 0 0 0 0 0 156,457 31 ,712 0 1,22 5 129 5,177 1,499 405 5,358 0 14 ,560 0 329 0 524 2 ,739 1,867 1,559 1,682 2 ,225 3,329 379 708 1,376 1,212 497 0 64 ,716 1,908 838 2 ,306 715 0 1,793 0 417,852 0 0 15 ,000 0 12,912 10 ,265 411 1,793 319 1,920 0 0 443 590 0 0 139,472 41 ,878 0 2,227 0 4,376 902 136 4 ,645 0 13,710 0 763 0 1,662 598 1,590 1,861 1,060 2,306 3,399 800 2,000 1,396 1,500 999 1,152 67 ,032 2,203 1,217 1,254 418 0 1,731 0 440.484 0 0 18,000 0 13,967 11 ,688 455 0 410 1,879 969 851 443 550 347 0 121 ,391 39 ,758 0 1,950 320 4,804 1,013 0 1,170 0 17.412 0 239 0 1,118 2,141 2,252 3,072 651 2,551 4 ,504 1,997 1,094 241 1,466 467 2,600 68 ,972 2,000 647 2 ,703 74 0 2,536 0 440,448 0 0 18,000 0 14,023 13,671 450 0 950 0 1,034 940 460 0 441 0 112 ,500 48 ,600 0 1,700 300 5,500 1,300 500 5,500 0 0 0 1,100 0 1.400 2,000 2,500 3,200 2,000 2,400 4 ,500 800 2,000 1,500 2,500 1,600 1,000 72 ,000 1,800 1,200 1,800 800 0 3,000 0 430,000 1,000 1,0 00 18 ,000 0 15 ,200 13,500 500 2,000 1,000 4,000 1,000 1,200 500 600 800 3,793 ,710 4 ,089,770 4 , 117 ,797 4,452 ,600 2021 Object Detail Amount 92,500 20,000 50 ,100 5,500 1,300 500 5,500 0 0 0 0 2,200 2,000 2,500 3,200 2,000 5,000 800 2,000 1,500 2,500 1,600 1,000 1,800 1,200 3,000 0 412 ,000 1,000 1,000 18 ,000 0 15,200 13,500 500 2,000 1,000 4,000 1,000 1,200 500 600 800 2021 Proposed Budget $3 ,850 ,500 10,000 102,000 112,500 50,100 0 2 ,000 300 12 ,800 0 1.100 2,200 7,7 00 7 ,000 4,500 4,300 5,100 74 ,000 3,000 1,800 800 0 3,000 432 ,000 15 ,200 16 ,000 9,100 4 ,727 ,0 00 Comments All Salary Costs Inclusive of Salary , Taxes , PERA & Benefits Sergeant Promotion Add it io nal Patrol Offi cer (11 1/21 ) CSO's -Up To 50 Hours/Wk Shred-It Increase Business Cards Increase Due to Increase in Costs Donated & Forfeited Funds Increase in Fees I# of Squads Thomson Reuter Increase Training Supplies , Taser Batteries Prosecution -3.0% Increase Blood Draws Psychological Interpreter Services To Receive Rebate in 2021 800 MHz Subscriber Fees Radar & LIDAR Repairs Page Two 2021 BUDGET WORKSHEETS POLICE August4 ,2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account# Desc ription Actual Actual Actual Budget Amount Budget Comments ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 101 42110 01 333 .00 Freight & Express Expenses 0 21 113 200 200 Repairs 1014211001 394 .00 P .C. Software Purchases 82 ,600 1014211001 394 .01 Automated Pawn System 204 204 0 300 0 No Longer Supported 1014211001 394 .02 Pictometry 0 0 0 0 0 In Public Works Budget 1014211001 394 .03 CJN/EFORMS I Pro Phoenix RMS 0 6,808 4 ,974 6,800 13,000 CJN/Eforms 1014211001 394 .04 LOGIS TriTech RMS 65 ,683 75 ,010 78 ,236 78 ,000 66 ,000 Switching to Full CJN Membership 101 42110 01 394 .05 Guardian Tracking Software 0 0 1,344 1,600 1,600 101 42110 01 394 .06 Vitals 0 0 2,167 2,000 2,000 Assisti ng with Vulnerable Individuals 101 42110 01 394 .07 Emergency Management Services 0 0 0 6,000 0 JPA for EOP Revision & EOC Trng 1014211001 396 .00 Computer Maintenance 40,800 1014211001 396.01 LOGIS Apps Support 0 0 0 0 0 LOGIS APS-Moved to LOGIS RMS 1014211001 396 .02 CJDN Connection Charges 3.443 2,981 2,520 3,000 3,000 State of MN CJDN Connection 1014211001 396 .03 MCD Connection Charges 923 1,384 3,274 2,200 2,200 LOGIS MDC Connection Charges 1014211001 396 .04 MCD Maintenance & Cellular 26 ,0 78 27,518 29.448 30 ,200 30,200 Increase Due to CAD Change 101 42110 01 396 .05 LOGIS Fees /Development 1,548 3,608 3,752 4,000 4 ,000 Development Fund 101 42110 01 396 .06 Evidence.com Data Storage 0 0 0 700 700 Squad Video 101 42110 01 396 .07 Schedule Anywhere 557 576 538 700 700 Scheduling Software 101 42110 01 433 .00 Dues & Subscriptions 12 ,000 10 1 42110 01 433 .01 Multi-Agency Assistance Group-MAAG 8,300 8,300 8,300 8,300 8 ,300 MAAG Equ ipment CIP Increase 101 42110 01 433 .02 IACP Chiefs 150 150 190 400 400 101 42110 01 433 .03 MN Chiefs of Police 290 351 314 700 700 101 42110 01 433 .04 Dakota Cty Chiefs of Police 400 400 400 400 400 Chief and a Sergeant 101 42110 01 433.07 MN Sex Crimes Investigators 0 0 0 20 20 101 42110 01 433 .08 T ri-Co unty Investigators 75 75 75 75 75 101 42110 01 433 .09 MN Crime Prevention Association 60 0 0 65 65 101421100 1 433 .10 P .O.S .T . Licenses 450 1,260 900 800 800 1014211001 433 .12 Miscellaneous 25 140 20 390 390 10 1421 1001 433 .13 ATOM 250 250 0 250 250 Ass'n Training Officers of MN 1014211001 433.14 Rotary Membership 0 0 0 600 600 1014211001 435 .00 Community Engagement Supplies 2,530 2 ,560 2,796 2,800 2,800 Crime Prevention Materials 1014211001 436 .00 Towing Charges 183 0 0 200 200 Disabled Squads 101 42110 01 437 .00 Conferences & Seminars 31,500 1014211001 437 .01 Firearms -Range 4 ,112 3,757 3,173 4 ,500 4 ,500 Range Rental 1014211001 437 .02 Chiefs Spring Conference 114 281 825 900 900 Conference Cost Increases 10 14211 00 1 437 .03 Investigations 1,986 2 ,107 1,722 2,000 2 ,000 101 42110 01 437 .04 IACP Conference 350 425 0 400 400 101 42110 01 437 .05 Supervision 5,863 11 ,686 9,559 6,500 6 ,500 Personnel Developmnt Northwestern 101 42110 01 437 .06 Use of Force 1,872 2,037 1,975 2 ,000 2 ,000 Increase due to Instructor Retiring 101 42110 01 437 .07 Emergency Driving 1,855 0 825 3,000 3 ,000 Driving School Cost Increase 101 42110 01 437 .08 First Aid 736 2,230 2 ,171 800 800 Cost Increase due to State Reg . Inc. 101 42110 01 437 .09 Narcotic Enforcement 0 0 0 200 200 101 42110 01 437 .10 Tactical 552 1,318 1.176 2,000 2 ,000 101 42110 01 437 .11 Support Services 706 465 200 800 800 101 42110 01 437 .12 Patrol Operations 4 ,175 5,285 10 ,045 6 ,000 6 ,000 Increase due to C .l.T. for Patrol 101 42110 01 437 .13 Emergency Management 0 0 0 0 0 1014211001 437.1 4 SRO /CRO 1,569 750 0 1.300 1.300 Added for Specialized Training 101 4211 0 01 437 .15 Explorer Conference 495 0 0 750 750 Two Advisors to State Conference 101 42110 01 4 37 .16 360 Communities Annual Banquet 180 180 240 350 350 101 42110 01 439 .00 Other Miscellaneous Charges 1,7 08 1,149 1,202 1,200 1,200 Refreshments fo r Meetings & Compliance Checks 101 42110 01 580 .00 Other Equ ipme nt Purchases 11.737 1,685 1,164 2,000 2,000 101 42110 01 599 .00 Employee Recogn ition Costs 2,143 2,140 2,116 2,000 2,000 Recognition BanqueUPlaques /Award ---------------------------------------------------------------------------------------------------- PAGE TOTALS $151 ,298 $167,092 $175,753 $187.400 $175 ,300 DEPARTMENT TOTALS $3 ,945 ,009 $4 ,256,863 $4 ,293,550 $4 ,640 ,000 $4 ,9 02 ,300 ========= ========= ========= ========= ========= ========= Page One August4 , 2020 A cc ount# 2021 BUDGET WORKSHEETS FIRE Description 101 42210 101 42210 101 42210 101 42210 101 422 10 103 .00 Salaries & Benefits 103 .01 Salaries 103 .02 Training Pay 103 03 Call Pay/Stipends 103 .04 Class Pay/Stipends 101 4221 O 01 202 .00 Duplicating & Copying 101 42210 01 202 .01 Copy Toner 101 42210 01 202 .02 Computer Printers 101 42210 01 204 .00 Envelopes & Letterhead 1014221001 204 .01 Envelopes 1O1 4221 O O 1 204 . 02 Letterhead 101 42210 01 204 .03 Forms 1014221001 211 .00 Cleaning Supplies 101 4221 O 01 211 .01 Soaps 101 42210 01 211 .02 Chamois, Towels , etc. 101 42210 01 211 .03 Sponges , etc. 1014221001 211 .04 SCBACleaner 101 42210 01 218 .00 101 42210 01 218 .01 101 42210 01 218 .02 101 42210 01 219 .00 101 42210 01 219 .01 101 42210 01 219 .02 101 42210 01 219 .03 101 42210 01 219 .04 101 42210 01 219 .05 101 42210 01 219 .06 101 42210 01 229 .00 101 42210 01 229 .01 10 1 42210 01 229 .04 Fire Department Clothing Un iforms Station Wear (2015) Other Operating Supplies Gloves Bandages Equipment Tyvek Suits Consummable Medical Oxygen Other Maintenance Supplies Vehicle Repairs Vehicle Modifications 10 1 42210 01 230 .00 Equipment Repair Materials 101 42210 01 230 .01 Light Bars 101 42210 01 230 .02 Smoke Machines 101 42210 01 230 .03 Lanterns & Miscellaneous 1014221001 230 .04 Small Tool Repairs 101 42210 01 230 .05 Opticom 1014221001 230 .06 Station 101 42210 01 241 .00 Small Tools 101 42210 01 241 .01 Axes , Bars & Other 1014221001 241 .02 Grass Fire 101 42210 01 241 .03 Hand Tools 101 42210 01 305 .00 Medical & Dental Fees 101 42210 01 306 .00 101 42210 01 306 .01 101 42210 01 306 .02 101 42210 01 306 .03 101 42210 01 306 .04 101 42210 01 306 .05 101 42210 01 308 .00 101 42210 01 308 .01 10 1 42210 01 308 .02 10 1 42210 01 308 .03 101 42210 01 308 .04 10 1 42210 01 308 .05 10 1 42210 01 308 .06 101 42210 01 308.07 101 42210 01 308 08 Personnel Testing & Recruitment New Physicals (4 ) Hepatitis Shots (4) Background Checks ( 4) Drug Testing (4) Firefigh ter Recruitment Costs Instructors' Fees Fire Fighter 1 (4) Fire Fighter 1 Certificates (4) Fire Fighter Re-Certificates (14 ) First Responder (4) First Responder Refresher (1/2) Outs ide Schools Haz-Mat Training (4 ) Other Re-Certificates (2) PAGE TOTALS 2017 Actual 2018 Actual 2019 Actual 2020 Adopted Budget $239 ,651 $258 ,084 $279 ,004 $300 ,000 0 0 0 0 0 496 7 0 116 235 4 , 154 0 0 1,214 0 2,806 0 0 7,600 0 0 415 531 0 16 41 0 279 7, 154 0 0 0 0 0 345 0 375 0 1,200 6 ,946 1,320 0 274 ,900 0 0 151 205 0 30 0 0 0 1,725 2,409 0 0 2 ,015 0 5,191 0 0 3,71 3 0 260 131 550 0 70 0 0 10,614 5,986 0 0 402 0 0 0 0 150 0 1,200 3,50 3 0 0 296 ,39 1 0 0 0 0 0 0 0 0 66 790 599 0 0 5,369 0 3,312 0 0 0 0 0 1,706 948 0 200 425 0 656 5,513 5,251 0 477 0 901 460 600 0 0 0 14 ,495 330 0 321 ,103 100 100 200 200 100 550 50 50 150 1,700 3,300 2,500 100 1,500 100 4 ,000 1,200 400 6,500 100 300 300 600 100 100 150 250 500 6 ,500 4 ,000 500 600 200 1,000 1,600 300 400 1,000 1,400 8,000 1,000 100 351 ,800 2021 Object 2021 Detail Proposed Am ount Budget Comments All Salary Costs Inclusive of $340 ,000 Salary , Ta xes , PERA & Benefits 70 ,000 55 ,000 2 15,000 0 100 100 200 200 100 550 50 50 150 1,700 3,300 2,500 0 1,500 100 4,100 1,200 500 6,500 0 300 300 600 100 100 150 250 500 5,000 500 600 200 1,000 1,600 300 500 1,000 1,400 8,000 1,000 0 200 500 800 5,000 9,400 7,000 1,400 900 Uniforms for New Hires Yearly Allowance for Fire Fighters Medical Supplies Moved to "219 .05" Increase in Medical Calls Added 02 Cascade @ FS #2 Replace Ag ing Light Bars Moved to "229 .01" Replace Ag ing Too ls 6 ,500 Switching Testing Company-2017 7,300 13 ,800 392 ,800 New Hires To Add Add itional Firefighters Adding Leadership Traning AM For Officers MA Moved to "308 .03" Page Tw o Aug ust 4 , 2020 Account# 2021 BUDGET WORKSHEETS FIRE Description 101 42210 01 310 .00 Testing Services 101 42210 01 310 .01 Aerial 101 42210 01 310 .02 Ladders 101 42210 01 310 .03 Pumpers (3 ) (Next xxxx) 101 42210 01 310 .04 SCBA Mask Testing 101 42210 01 313 .00 Temporary Service Fees 101 42210 01 313 .01 SCBA Maintenance 101 42210 01 313 .02 SCBA Flow Test 101 42210 01 313 .04 Security Contract 101 42210 01 313 .05 SOT Joint Powers 101 42210 01 314 .00 Annual Fire Relief Contribution 101 42210 01 319 .00 Other Professional Services 101 42210 01 319 .01 School Literature 101 42210 01 319 .02 Door Prizes 101 42210 01 319 .03 Fire Prev ention Week Promos 101 42210 01 319 .04 Food at Open House 101 42210 01 319 .06 National Night Out 101 42210 01 321 .00 Telephone Costs 1014221001 321 .01 Cell Phones 1014221001 321 .02 ComputerCards 101 42210 01 322 .00 Postage Costs 101 42210 01 329 .00 Other Communication Costs 101 42210 01 329 .01 Base Repairs 101 42210 01 329 .02 Pager Repairs 101 42210 01 329 .03 Hand Held Repairs 101 42210 01 329 .04 Mobile Repairs 101 42 2 10 01 329 .05 800 MHZ User Fee 101 422 10 01 329 .06 Mobile Computers 101 42210 01 331 .00 Travel Expense 1014221001 331 .01 Minnesota Chiefs Conference 1014221001 331 .02 Fire Department Association 101 42210 01 331 .03 Outside Schools 101 42210 01 433 .00 Dues & Subscriptions 101 42210 01 433 .01 Capital City 1014221001 433 .02 VFBA Insurance 101 42210 01 433.03 State Fire 101 42210 01 433 .04 State Ch iefs 101 42210 01 433 .05 DCFC 101 42210 01 433 .06 WAKOTA Mutual Aid 101 4221 O 01 433 .07 On-Line Training/Tracking Tool 101 42210 01 433 .08 NFPA 101 42210 01 437 .00 Conferences & Seminars 101 42210 01 437 .01 State Fire Conference 101 42210 01 437 .02 State Chiefs Conference 101 42210 01 439 .00 Other Miscellaneous Charges 101 42210 01 439.01 Food & Coffee 101 42210 01 439 .02 Extinguisher 101 42210 01 439 .03 Plaques 101 42210 01 439 .04 Paint 101 4221 O 01 439 .05 Station Needs 101 42210 01 580 .00 10 1 42210 01 580 .01 101 42210 01 580 .02 101 42210 01 580 .03 101 42210 01 580 .04 Other Equipment Purchases Bunker Gear (8 ) Pagers Hose & Fittings Replace Damaged Items PAGE TOTALS DEPARTMENT TOTALS 2017 Actual 1,515 0 500 0 761 1,763 575 6 ,838 30 ,000 0 0 943 0 0 3 ,083 0 0 0 162 755 0 12,318 3 ,116 0 423 733 0 322 808 0 75 0 0 0 0 1,458 360 109 458 0 2,456 17 ,286 0 0 1,082 2018 Actual 0 0 1,265 0 7 ,676 260 245 6 ,956 30 ,000 0 0 629 88 0 3 ,084 0 12 0 0 0 0 13 ,438 2,460 0 0 1,355 0 309 0 378 100 50 0 0 0 0 843 162 375 0 11 ,074 12 ,648 0 487 3 ,769 2019 Actual 775 445 1,060 0 2,845 2,364 0 7 ,044 30 ,000 345 0 809 0 0 2,548 0 2 56 0 0 0 13 ,905 2,472 0 0 240 50 295 801 0 100 50 0 0 587 3 , 129 468 0 547 0 1,525 12 ,654 559 0 2 ,176 2020 Adopted Budget 2,500 800 2,800 2,500 4 ,500 2,500 800 7 ,500 30 ,000 400 200 700 300 600 3 ,200 1,800 100 300 1,000 2,500 2,000 14 ,000 3,200 2,000 1,600 5 ,000 50 750 800 300 100 100 5,000 0 400 1,500 700 600 400 100 1,500 18 ,600 5 ,000 2,000 2 ,000 $87 ,900 $97 ,664 $87 ,850 $132,700 $362 ,800 $394 ,056 $408 ,952 $484 ,500 2021 Object 2021 Detail Proposed Amount Budget 2,500 800 2,800 2,500 4,500 2,500 800 7,500 8 ,600 15,300 30,000 Comments Increase in Fees Added New Engine to Fleet New Mask Requirement Added SCBA Compressor-FS #2 Added SCBA Compressor-FS #2 Increase in Fees 2,200 Fire Prevention Education 600 0 700 300 600 3,200 1,800 300 1,000 2,500 2,000 14 ,000 3,200 2,000 1,600 5,000 50 750 800 300 100 100 5 ,000 0 400 1,500 700 600 600 100 1,500 18 ,600 5 ,000 2,000 2,000 Moved to "319 .01" 5 ,000 Active 911 Subscriptions 100 UPS Costs 23 ,000 8 ,600 7,100 1,900 3 ,500 Warranty Plan to be Added Aging Equipment Monthly Air Ti me Fees (1 Add'n) FDYC Training Added Increase in Dues Annual Subscription-SO FF's Sending Additional Personnel 27 ,600 ----------- $132,900 $525 ,700 Replacements (5 Per Year) Aging Equipment ======== ======== ======== ======== ======== ======== Page One 2021 BUDGET WORKSHEETS GOVERNMENT BUILDINGS August 4 , 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detai l Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 101 41940 101 .00 Sala ries & Benefits $127 ,400 Salary , Taxes , PERA & Benefits 10 1 41940 77 101 .01 Administrative 3,334 7,670 8,207 8 ,700 9 ,000 P.W . Director I City Engineer 10 1 41940 79 101.01 Main tenance 107 ,257 111 ,064 114,936 115 ,000 118,400 101 41940 102 .00 Full-Time Overtime 4,568 6,167 5 ,3 66 0 0 101 41940 01 208 .00 Miscellaneous Supplies 15 ,266 18 ,046 17 ,544 21 ,000 21 ,000 Cleaning , Paper Prod ., Coffee 101 41940 01 219.00 Flags & Flagpole Maintenance 2,537 2,6 49 4 ,847 3,000 3,000 101 41940 01 223.00 Building Repair Supplies 9,183 11 ,049 9,378 12,000 12,000 Light Bulbs , Locks , etc . 101 41940 01 225 .00 Landscaping Materials 725 368 1,500 1,500 1,500 Trees & Sh rubs 101 41940 01 241 .00 Small Tools 448 666 411 700 700 Carpentry, Bits , Blades , etc . 101 41940 01 242 .00 Minor Equipment 859 1,212 385 1,200 1,200 Equipment Replacement 101 41940 01 302.00 Architects' Fees 0 0 0 0 0 Estimates 101 41940 01 318.00 Contract Engineer 6,342 0 0 0 0 1014194001 319.00 Other Profess ional Services 94 ,600 101 41940 01 319.01 Elevator Ma intenance 1,956 1,964 3 ,657 2,500 2,500 101 41940 01 319 .02 Heating/Coo ling Maint Contract 8,155 2,230 4,321 10,000 6,500 Includes all City Fa cilities 101 41940 01 319 .03 Annua l Boiler Inspections I Main!. 50 50 50 500 300 101 41940 01 319 .04 Pest Control 4 ,074 3 ,135 3,085 5 ,500 5,500 Price Iner., Boxelder Treatment 101 41940 01 319 .05 Fire Extinguishers 1,262 1,247 1,562 1,800 1,800 101 41940 01 319.06 Fire Supp ression Sys tem Check 3,706 4,406 4,02 1 5,000 5 ,000 Price Increase 101 41940 01 319 .07 Janitorial Service-Fire Stations 11 ,996 11,202 11 ,000 12,000 12,000 Possible lncrease/COVI D Cleaning 101 41940 01 319.08 Janitorial Service-P .W Building 10 ,946 11 ,853 12 ,000 12,000 12 ,000 Possible lncrease/COV ID Cleaning 101 41940 01 319 .09 Janitorial Service-City Hall 26,652 27 ,750 28 ,000 28 ,000 28 ,000 Possible lncrease/COVID Cleaning 101 41940 01 319 .10 Floo r Mats -Monthly Cha rges 5,094 5 ,006 5 ,540 5 ,500 5,500 Price Increase 101 41940 01 319 .11 Other Janitorial Services 9,040 21,122 10,136 11 ,000 14,000 Grout CH , PD , FH 's-1 Every Year 101 41940 01 319 .12 Bronze Monument Maintenance 1,075 1,524 1,075 1,500 1,500 101 41940 01 321.00 Telephone Costs 560 729 892 800 800 Air Card for iPad-Month ly Chgs 101 41940 01 381 .00 Electric Utilities 67 ,652 71 ,981 58 ,319 74 ,000 70 ,000 101 41940 01 383.00 Gas Utilities 38 ,219 48 ,900 48 ,7 11 55 ,000 50 ,000 101 41940 01 384 .00 Refuse Disposal 49,000 101 41940 01 384 .01 General Buildings & Parks 21 ,206 22 ,972 31 ,960 24,000 24,000 Flint Hills Expansion , Horseshoe 101 41940 01 384.02 Recycli ng/Cleanup 18 ,629 29,240 28,086 25,000 25 ,000 101 41940 01 389 .00 Other Utility Services 0 0 0 5,000 5,000 Buying Solar Energy 101 41940 01 393 .00 P.C . Hardware Purchases 0 0 107 100 100 10 1 41 940 01 394.00 P.C . Software Purchases 0 4 ,185 4 ,114 9 ,000 9 ,000 Cartegraph , ESRI 101 41940 01 401 .00 Contracted Building Repairs 64 ,500 101 4194001 401.01 Electrica l Repairs 3,216 10 ,372 13,952 8 ,000 10 ,000 101 41940 01 401.02 Siren Operations & Maintenance 0 270 2,9 82 7 ,000 7 ,000 10 1 4194001 401 .03 Miscellaneous Repairs 16 ,143 25 ,472 29 ,357 25 ,000 30 ,000 101 41940 01 401 .04 HVAC Repairs 24 ,072 28 ,793 14,471 25 ,000 17 ,500 101 41940 01 402.00 Security Card System Maintenance 3,906 673 2,631 4,000 4 ,000 Updates, Prev . Main!., Tech Supt. 101 4194001 416.00 Machinery Rental 961 1,216 806 1,500 1,500 Lift Rental 101 41940 01 437 .00 Conferences & Seminars 100 93 321 500 500 Special Engineer Licenses 101 41940 01 439.00 Other Miscellaneous Charges 21 17 5,950 6 ,000 20,000 Fire #1 Energy Efficiency lmpr. 101 41940 01 530 .00 Improvements Other Than Bldgs 92 ,000 109 ,971 159 ,964 125,000 50 ,000 From Long-Term Plan ------------------------------------------------------------------------------------------------ PAGE TOTALS $521,209 $605 ,264 $649 ,644 $653 ,300 $585 ,800 DEPARTMENT TOTA LS $521 ,209 $605,264 $649,644 $653,300 $585,800 ========== ========== ========== ======== ======== Page One 2021 BUDGET WORKSHEETS FLEET MAINTENANCE August 4 , 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 101 43100 101 .00 Salaries & Benefits $275,000 Salary , Taxes , PERA & Benefits 1014310077 101 .00 Administrative 18,464 27,476 28 ,929 30 ,300 57 ,900 1014310078 101 .00 Technica l/Clerical 10,920 11,294 11 ,625 12 ,000 12,200 101 43100 79 101 .00 Maintenance 186 ,847 187 ,762 193,488 198 ,300 204 ,900 101 43100 102 .00 Full-Time Overtime 2,694 8,964 10 ,720 3,000 3,000 101 43100 01 211 .00 Cleaning Suppl ies 2,790 3,21 6 3,462 4 ,000 4 ,000 Shop & Vehicles 101 43100 01 212 .00 Motor Fuels 117 ,645 144 ,831 136 ,181 144 ,000 144 ,000 92 .5% of Fuel Covered by Fleet 101 43100 01 213 .00 Lubricants & Additives 16,349 12 ,137 8,173 15 ,000 12 ,000 101 43100 01 215 .00 Shop Materials 17 ,904 15 ,878 15 ,784 20 ,000 20 ,000 101 43100 01 221 .00 Equipment Parts 94 ,549 91,691 128,114 100 ,000 110 ,000 101 43100 01 222 .00 Tires 22 ,689 24 ,709 26,401 30 ,000 30 ,000 101 43100 01 241 .00 Small Tools 5,789 5,972 6 ,018 6 ,000 6,000 Replace Old Tools 101 43100 01 242 .00 Minor Equ ipment 2,660 9,347 14,733 15 ,000 15 ,000 Tool Cabinets in 2019 , 20 & 21 101 43100 01 318 .00 Contract Engineer 11 ,301 0 0 0 0 101 43100 01 321 .00 Telephone Costs 0 0 0 0 0 101 43100 01 323 .00 Radio Units (Warranty & Batteries) 953 1,072 536 2,000 2,000 New Chargers in 2019 101 43100 01 384 .00 Refuse Disposal 0 0 0 400 400 Oil and Filter Disposal 101 43100 01 394 .00 P.C. Software Purchases 11 ,500 101 43100 01 394 .01 Licensing & Maintenance 291 4 ,185 4 ,114 4 ,500 4,500 CarteGraph OMS 101 43100 01 394 .02 Online Subscriptions 3,120 1,500 3,110 5,000 5,000 ALLDA TA/Cumm ings/CAT/Detroit 101 43100 01 394 .03 New Software Purchases 53 0 4 ,001 2,000 2,000 Diagnostic Scanner in 2019 101 43100 01 404.00 Contracted Mach & Equip Services 40 ,000 101 43100 01 404 .01 Contracted Services 19 ,587 23 ,153 31,667 35 ,000 35 ,000 Aging Equipment , FD Units , Towing 101 43100 01 404 .02 Contracted Preventative Main t. 9,948 0 10 ,000 5,000 5,000 Power Wash All , Paint One Unit 101 43100 01 416.00 Machinery Rental 0 0 0 500 500 101 43100 01 433 .00 Dues/Subscriptions/Certifications 292 200 294 200 400 DOT Cert . ASE Cert ., EVT Cert. 101 43100 01 435 .00 Books & Pamphlets 215 60 80 100 100 DOT Decals and Inspection Pads 101 43100 01 437 .00 Conferences & Seminars 0 700 623 800 800 Cartegraph Starting in 2018 ------------------------------------------------------------------------------------------ PAGE TOTALS $545 ,058 $574 ,147 $638 ,053 $633 , 100 $674 ,700 DEPARTMENT TOTALS $545 ,058 $574 , 147 $638 ,053 $633 , 100 $674 ,700 ====================================================== Page One August4 .2020 Account# 2021 BUDGET WORKSHEETS STREET MAINTENANCE Description 101 43121 101 .00 Salaries & Benefits 101 43121 77 101 .00 Administrative 101 43121 78 101 .00 Technical/Clerical 101 43121 79 101 .00 Maintenance 101 43121 102.00 Full-Time Overtime 101 43121 99 103 .00 Part-Time Salaries & Benefits 101 43121 01 201 .00 Office Accessories 101 43121 01 203 .00 Printed Forms & Paper 101 43121 01 203 .03 City Specification Books 101 43121 01 205 .00 Drafting Supplies 101 43 121 01 205 .01 Plotter Ink and Paper 101 43121 01 209 .00 Other Office Supplies 101 43121 01 216 .00 Chemical & Chemical Products 101 43121 01 224 .00 Street Maintenance Materials 101 43121 01 224 .01 Paint 101 43121 01 224 .02 101 43121 01 224 .03 101 43121 01 224 .04 101 43121 01 224 .05 101 43121 01 225 .00 101 43121 01 225 .01 101 43121 01 225 .03 101 43121 01 225 .04 101 43121 01 225 .05 101 43121 01 225 .06 101 43121 01 225 .07 101 43121 01 225.08 101 43121 01 225 .09 101 43121 01 225 .10 101 43121 01 226 .00 101 43121 01 226 .01 101 43121 01 226 .02 Mail Boxes Light Bulbs/Lenses Holiday Decorations Miscellaneous Landscaping Materials Turf Restoration Material Flowers Trees Hanging Baskets Entrance Monuments Downtown Planters Park Signs, Central Park City Facilities Banners /Flag Components Sign Repair Materials Signs and Posts Solar Batteries 101 43121 01 231 .00 Bituminous Patching Materials 101 43121 01 232 .00 Crushed Rock 101 43121 01 233 .00 Dust Control Materials 101 43121 01 234 .00 De-Icing Sand I Rock 101 43121 01 240 .00 Safety Eq uipment & PPE 101 43121 01 241 .00 Small Tools 101 43121 01 242 .00 Minor Equipment 101 43121 01 303 .00 101 43121 01 303 .01 101 43121 01 303 .02 101 43121 01 304 .00 101 43121 01 318 .00 101 43121 01 319 .00 101 43121 01 319.02 1014312101 321 .00 101 43121 01 323 .00 1014312101 331 .00 101 43121 01 381 .00 101 43121 01 381 .01 101 43121 01 381 .02 101 43121 01 384 .00 101 43121 01 384 .01 101 43121 01 384 .02 101 43121 01 391 .00 101 43121 01 391 .03 101 43121 01 391 .04 392 .00 393 .00 Engineering Fees General Non-Project Related Pavement Management Lega l Fees Contract Engineer Other Professional Services GIS Consulting Services Telephone Costs Radio Units Travel Expense Electric Utilities Street Lights Signal Lights & Sirens Refuse Disposal Hazardous Waste Disposal Roadside Garbage P.C. Maintenance Pavement Management Syst Sup R-0-W Permit On-Line Service P.C. Accessories & Supplies P.C. Hard ware Purchases 101 43121 01 101 43121 01 101 43121 01 101 43121 01 101 43121 01 394 .00 P.C. Software Purchases 394 .01 394 .02 101 43121 01 394 .03 Licensing & Maintenance On line Subscriptions New Software Purchases PAGE TOTALS 2017 Actual 36 ,927 54 ,355 450,444 8 ,280 23 ,736 499 0 267 665 77 ,076 0 1,576 0 8 ,569 2,074 2 ,191 0 0 3 ,359 579 1,068 3,024 3 ,641 0 11,242 0 27 ,959 29 ,826 29 ,040 1,860 0 1,479 2 ,872 59 ,701 6 ,210 0 22 ,602 1,651 3,718 5,777 45 171 ,956 2 ,785 10 1,201 120 638 0 270 6 ,173 234 0 2018 Actual 71 ,951 52 ,554 451 ,120 15 ,910 21 ,354 136 0 0 966 89 ,997 94 6 ,104 432 9,420 1,794 2 ,874 0 0 3,365 1,211 1,190 5 ,340 3,201 1,450 9,948 0 33 ,455 27 ,657 33 ,191 1,167 0 1,095 7 ,232 48 ,702 0 942 0 52 2,788 6 ,082 29 176,400 2 ,821 0 443 0 577 0 873 8 ,954 234 0 2019 Actual 89,473 56 ,890 464,628 21,196 23 ,085 0 0 0 411 72 ,382 0 5,596 696 14 ,791 2,148 2,098 0 1,625 2,944 1,349 1,642 5,381 3,211 0 9 ,436 697 54 ,573 27 ,867 27 ,943 1,052 0 1,151 3 ,034 5,514 0 7 ,660 0 0 2 ,264 6 ,282 92 174,628 2 ,534 0 1,044 0 710 0 0 9 ,714 0 0 1,065 ,700 1,103 ,104 1,105 ,741 2020 Adopted Budget 94 ,600 59,300 472 ,100 14 ,000 29 ,000 100 0 400 700 90 ,000 500 4,000 800 10,000 2,500 3,000 16 ,000 500 0 0 0 0 0 500 13,000 500 20,000 25 ,000 28,000 3,500 500 1,200 15 ,000 8,000 5 ,000 3,000 0 1,000 5,000 7,100 200 0 3,100 500 1,000 0 800 0 1,000 10 ,500 300 200 951,400 2021 Object Detail Amount 117,800 65 ,200 494,800 0 400 500 4 ,000 800 10 ,000 2,500 3,000 16 ,000 500 0 0 0 0 0 500 13,000 500 8,000 5,000 1,000 0 3,100 500 1,000 0 800 10 ,500 300 200 2021 Proposed Budget Comments All Salary Costs Inclusive of $677 ,800 Salary , Taxes , PERA & Benefits 14,000 Maintenance 29 ,000 100 0 400 700 90 ,000 17 ,800 20 ,000 13 ,500 20 ,000 23 ,000 26 ,000 3,500 500 1,200 12,000 13 ,000 3 ,000 0 1,000 5,000 1,000 200 3,100 1,500 800 0 1,000 11 ,000 990 , 100 Replace with LED Bulbs Tree Lighting , Banners in 2019 Fencing, Miscellaneous Supplies Baskets, Planters, Parks, Bldgs Moved to 101-43121-01-225.03 Moved to 101-43121-01-225.03 Moved to 101-43121-01-225.03 Moved to 101-43121-01-225.03 Moved to 101-43121-01-225.03 Replace More Faded /Aging Signs Pave Biscayne in 2020 Pave Biscayne in 2020 Gravel Road Ice Control Vests , Glasses , Hardhats, etc. Shovels , Brooms , etc. Pretreatment Equ ip, Skidder Broom $5 ,000 Split 5 Ways Includes Wireless Technology Moved to Separate Utility Moved to 101-43121-01-303.02 2 Surface Pros in 2019 CarteGraph , ESRI , Datalink Pictometry Page Two 2021 BUDGET WORKSHEETS STREET MAINTENANCE August4 , 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Am ount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 101 43121 01 402 .00 Parking Lot Maintenance 176 ,796 90 ,094 89,785 195 ,000 50 ,000 From Long-Term Plan 101 43121 01 403 .00 Contracted Repair & Maintenance 16 ,500 101 43121 01 403 .01 Street Lights 4,577 2,410 6 ,691 0 0 Moved to Separate Utility 101 43121 01 403 .02 Signal Lights 0 0 507 1,500 1,500 101 43121 01 403 .03 Light Replacements 0 7 ,850 0 10 ,000 10,000 Conversion to LED 101 43121 01 403 .04 Miscellaneous Repa irs 0 390 0 5 ,000 5,000 Curb Painting , etc. 101 43121 01 404 .00 Railroad Admin istration /Mgmt. 4 ,239 0 0 1,500 500 QZ Updates , Misc Issues 101 43121 01 405.00 Street Striping 50 ,499 43 ,230 25 ,523 0 0 Moved to "408 .00" 101 43121 01 408 .00 Crackseal, Sealcoat, Patch , Stripe 64 ,866 150 ,915 214 ,417 230 ,000 250 ,000 $20,000 Iner. for Add 'I Seal Coat 101 43121 01 409 .00 Tree Trimming 9 ,605 11 ,789 19 ,677 20 ,000 25 ,000 More is Needed if No SKB $ 10 1 43121 01 410 .00 Concrete Sidewal k/Curb Repa irs 20,000 101 43121 01 410 .01 General Repa irs 4 ,231 17 ,553 13 ,605 20 ,000 20 ,000 101 43121 01 410 .02 Pedestrian Improvements 68 ,105 454 0 0 0 Moved $125 ,000 to Street GIP 101 43121 01 411 .00 Contracted Snow Removal 18 ,000 101 43121 01 411 .01 Community Center 5,758 21 ,700 0 0 0 Moved to P & R Budget 10 1 43121 01 411 .02 Steeple Center 6 ,970 16 ,690 0 0 0 Moved to P & R Budget 101 43121 01 4 11.04 Dakota County Library 7,955 18,898 22 ,092 18 ,000 18 ,000 10 1 43121 01 415 .00 Equipment Rental 20 ,054 15 ,245 12 ,268 20 ,000 20 ,000 Track-Hoe , Bucket Lift , etc. 101 43121 01 433 .00 Dues & Subscriptions 1,700 101 43121 01 433 .01 American Public Works Ass'n 1,020 850 955 1,100 1,100 Annual Membership 101 43121 01 433 .03 City Engineers' Association 120 352 0 400 400 Add Assistant City Engineer 101 43121 01 433 .07 MN Street Superintendent Ass'n 150 150 150 200 200 101 43 121 01 433 .09 MN Transportation All iance 0 0 0 0 0 101 43121 01 437 .00 Conferences & Seminars 5,000 101 43121 01 437 .01 APWA 324 1,455 510 500 500 State/Nat'I Conference in 2016 101 43121 01 437 .03 Clerical 0 0 0 0 0 101 43121 01 437 .05 Maintenance Expo 100 90 0 400 400 10 1 43121 01 437 .06 Cartegraph , ESRI , GIS 13 1 607 0 500 500 User Group, Conference , Training 101 43121 01 437 .07 Snow Conference 214 160 0 300 300 101 43121 01 437 .08 MN Dot 0 172 369 300 300 Simulator 101 43121 01 437 .09 Miscellaneous Training 1,810 1,636 1,165 3,000 3,000 DCTC Defensive Dri vi ng Tra ining 101 43121 01 439 .00 Other Miscellaneous Charges 582 611 832 800 800 CONDAC , COL Li censes 10 1 43121 01 570 .00 Office Equipment & Furn ish ings 0 0 0 0 0 ---------------------------------------------------------------------------------------------------- PAGE TOTALS $428 , 106 $403,298 $408 ,545 $528 ,500 $407 ,500 DEPARTMENT TOTALS $1 ,493 ,806 $1 ,506 ,402 $1,514 ,286 $1 ,479 ,900 $1 ,397,600 ========= ========= ========= ========= ======== ========= Page One 2021 BUDGET WORKSHEETS PARKS & GROUNDS MAINTENANCE August 4 , 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detai l Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------·------------------------------------------- All Salary Costs Inclusive of 10 1 45202 101 .00 Salaries & Benefits $588 ,500 Salary, Taxes , PERA & Benefits 101 45202 77 101 .00 Administrative 26 ,924 34 ,776 38,507 40 ,300 55 ,100 101 45202 78 101 .00 Technical /Clerical 21 ,840 22 ,588 23 ,249 24 ,000 24 ,300 101 45202 79 101 .00 Maintenance 365 ,457 395 , 199 406,776 509,200 509 , 100 101 45202 102.00 Full-Time Overtime 5,248 15 ,112 15 ,749 8,000 8,000 101 45202 99 103 .00 Part-Time Salaries & Benefits 53,358 49 ,684 68,789 71 ,000 71,000 101 45202 01 205 .00 Plotter In k and Paper 267 42 0 400 400 101 45202 01 216.00 Chemical & Chemical Products 39,476 44,124 43,427 55,000 55 ,000 Flint Hills Fertilizer , Poa 101 45202 01 219 .00 Other Operating Supplies 50 ,000 101 45202 01 219 .01 Seed , Sod , etc . 3,313 9,780 1,948 10,000 10 ,000 Topdressing and Natural Settings 101 45202 01 219 .02 Red Rock , Sand , Gravel , etc . 9,563 12 ,788 21 ,219 20 ,000 20,000 Topdressing Program 101 45202 01 219 .05 Wood Chips 14 ,999 20 ,339 18 ,000 20,000 20 ,000 Routine Playground Maintenance 101 45202 01 220 .00 Splash Pad Maintenance 3,380 2,244 3,488 3,500 3,500 Supplies 101 45202 01 221 .00 Equipment Parts 29,000 101 45202 01 221 .01 Playground Equipment Repair 9 ,637 14 ,802 15 ,338 10 ,000 18 ,000 Repairs on Aging Equipment 101 45202 01 221 .02 Irrigation Repair(ln-House) 7,372 7,342 5,920 8,000 8,000 101 45202 01 221 .03 Miscellaneous 2,478 1,599 3,107 2,500 3,000 101 45202 01 221 .04 Park Sign Replacements 0 0 474 0 0 101 45202 01 223 .00 Shelter Repair Supplies 2,100 101 45202 01 223 .01 Paint , Stain, etc . 336 207 12 800 500 101 45202 01 223 .02 Shingles , Boards , etc. 886 766 597 1,000 800 101 45202 01 223 .03 Miscellaneous 312 365 510 1,000 800 101 45202 01 223 .04 Shelter/Shed Repairs 0 0 0 0 0 Paid from Bu ilding Main!. Budget 101 45202 01 225 .00 Landscaping Materials 3,000 101 45202 01 225 .01 Trees , Shrubs, etc . 1,486 1,134 2,085 2,000 2,000 101 45202 01 225 .02 Timbers , Fence , etc . 157 5,589 0 1,000 1,000 101 45202 01 226 .00 Sign Repair Materials 242 72 0 500 500 101 45202 01 229 .00 Other Maintenance Supplies 13 ,890 16,816 10 ,7 11 20 ,000 15 ,000 Paint , Chalk , Field Dry , Etc . 101 45202 01 240 .00 Safety Equipment & PPE 0 0 0 500 500 Vests , Glasses , Hardhats , etc . 101 45202 01 241 .00 Small Tools 1,881 2,021 1,950 2,500 2 ,500 Hand Tools , Blades , Bits, etc . 101 45202 01 242 .00 Minor Eq uipment 4 ,828 4,851 4 ,725 5,000 7,000 Weed Whips , Chain Saws , etc . 101 45202 01 303 .00 Engineering Fees (GIS) 0 0 0 1,000 1,000 $5,000 Split 5 Ways 101 45202 01 318 .00 Contract Engineer 5,650 0 0 0 0 101 45202 01 319 .00 Other Professional Services 23,000 101 45202 01 319 .01 Maintenance of Open Spaces 6 ,953 8,650 8,930 15 ,000 15 ,000 Burns , etc. Add FH & Horseshoe 101 45202 01 319 .02 Landscaping & Flower Beds 3,289 5,984 5 ,985 6 ,000 8,000 101 45202 01 321 .00 Telephone Costs 4 ,342 7,165 3,955 9,000 9,000 All Wireless, iPads , lrrig . Controls 101 45202 01 323 .00 Radio Un its 5 ,777 6,082 6 ,282 7 ,100 1,000 101 45202 01 381 .00 Electric Utilities 22 ,500 Anticipated Rate Increase 101 45202 01 381 .01 Skating Rinks 5,704 6,343 6 ,832 7,000 7,000 Service Connect I Disconnect 101 45202 01 381 .02 Softball Fields 8 ,366 6,426 6 ,292 8,500 8,500 101 45202 01 381 .03 Irrigation 6 ,761 8,402 7,524 7 ,000 7,000 101 45202 01 383 .00 Gas Utilities 1,666 2,017 1,787 2,500 2,500 101 45202 01 393 .00 P.C. Hardware Purchases 88 0 0 1,000 1,000 101 45202 01 394 .00 P.C. Software Purchases 18,000 101 45202 01 394 .01 Licensing & Maintenance 5 ,673 8,454 9,214 10,500 17 ,500 Cartegraph , ESRI , Datalink , GPS 101 45202 01 394 .02 Online Subscriptions 234 234 0 300 300 Pictometry 101 45202 01 394 .03 New Software Purchases 0 0 0 200 200 ------------------------------------------------------------------------------------------- PAGE TOTALS 641 ,832 721 ,998 743 ,382 891 ,300 914 ,000 Page Two 2021 BUDGET WORKSHEETS PARKS & GROUNDS MAINTENANCE August4 , 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comme nts ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 101 45202 01 403 .00 Co ntra cted Repair & Maintenance 17 ,500 101 45202 01 403 .01 Irrigation Repairs 5 ,168 8,280 7,160 7 ,000 7,500 RPZ-l nspections and Repairs 10 1 45202 01 403 .02 Electrical Repairs 781 4,295 6,331 3,000 4,000 101 45202 01 403 .03 Miscellaneous Repairs 5 ,919 2,482 6 ,003 2 ,500 3,000 Hard Court Fen cing 101 45202 01 403 .04 Playgrou nd Repairs 0 0 0 3,000 3,000 101 45202 01 409 .00 Other Contracted Repa ir & Ma in! 17 ,800 101 45202 0 1 409 .01 Sprin g Clean Up 955 455 500 500 500 Dethatching , Flower Beds , etc . 101 45202 01 409 .02 Library I Steeple Center I RCC 8 ,600 8,337 8,487 9 ,000 9,000 Mowing I Chemica ls -Von Ban k 101 45202 01 409 .03 Fire Station #1 0 0 0 0 0 101 45202 01 409 .04 Fire Station #2 0 0 0 0 0 101 45202 0 1 409.05 City Hall 0 2,779 2 ,829 2,800 2,800 Mowing I Chemicals -VonBank 101 45202 01 409 .06 UM o re Baseball Fi elds 1,100 2,500 2,400 2 ,500 2,500 101 45202 01 409 .07 FHR Socce r Fields 1,824 2,500 94 3,000 3,000 101 45202 01 416 .00 Machinery Rental 27 ,500 101 45202 01 416 .01 Mower Leases 21 ,000 21 ,000 21,200 22,500 22 ,500 3 Mowers 101 45202 01 416 .02 Miscel laneous Rentals 4 ,092 1,100 3,161 5,000 5,000 Compressors , Lawn Mowers , etc . 101 45202 01 433 .00 Dues & Subscription s 400 101 45202 01 433 .01 MN Park Supervisors Ass'n 0 0 288 50 100 101 45202 01 433 .02 Miscellaneous Due s 248 274 80 250 300 101 45202 01 435 .00 Books & Pamphlets 0 0 0 0 0 101 45202 01 437 .00 Conferences & Seminars 5,000 101 45202 01 437 .01 Seminars & Workshops 2,425 2,247 1,045 2 ,500 2,500 Green Expo , MPSA, Playgro unds 101 45202 01 437 .02 School & Tu itio n 1,766 300 1,988 2,000 2,000 Turf Schoo l, Po wer Limited Te ch . 101 45202 01 437 .03 CarteGraph , ESRI , GIS 131 607 0 500 500 User Group, Conference , Train ing 101 45202 01 439 .00 Other Miscellaneous Charges 11 155 38 200 200 Contingencies 101 45202 01 530 .00 Improvements Other Than Bldgs 174,327 199,843 299,441 220 ,000 75 ,000 From Long -Term Plan ------------------------------------------------------------------------------------------- PAGE TOTALS $228 ,347 $257 , 154 $361 ,045 $286,300 $143 ,400 DEPARTMENT TOTALS $870 , 179 $979 ,152 $1 , 104 ,427 $1 ,177 ,600 $1 ,057,400 ========= ========= ========= ========= ======== ========= Page One 2021 BUDGET WORKSHEETS PARKS & RECREATION August 4 , 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account# Descript io n Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 101 45100 101 .00 Sala ries & Benefits $830 ,132 $884 ,881 $882 ,233 $913 ,100 $944,700 Sa la ry , Ta xes , PERA & Benefits 101 45100 102.00 Full-Time Overtime 2,756 2,366 1,980 5,000 5,000 101 45100 103.00 Part-Time Salaries & Benefits 268,100 1014510010 103 .00 PrT Receptionist 38,946 42 ,630 45,141 47 ,800 55 ,500 1014510012 103 .00 Building Attendants 58,037 67,347 76,448 60,000 70 ,000 1014510015 103 .00 PrT Recreation Coordinato r 50,347 69,679 84,469 90,200 93,300 1014510083 103 .00 Playground Recreation Leaders 29,575 23 ,781 30 ,611 25 ,000 30 ,000 101 45100 94 103 .00 Warming House Attendants 11 ,371 15,483 15 ,832 15,000 16 ,000 101 45100 99 103 .00 Park & Rec Committee 3,040 3,528 2,708 3,300 3,300 101 45100 01 203 .00 Printed Forms & Paper 0 0 0 0 0 101 45100 01 205 .00 Drafting Supplies 0 97 500 500 500 Laminating 101 45100 01 207 .00 Trai ning & In stru ctional Supplies 0 0 0 0 0 101 45100 01 208 .00 Miscellaneous Supplies 1,699 0 500 0 0 101 45100 01 209 .00 Other Office Supplies 114 97 235 500 500 Envelopes , Forms, Ru lers , etc . 101 45100 01 211 .00 Cleaning Supplies 4,693 5,019 4,417 4,500 4 ,500 101 45100 01 216 .00 Chemicals & Chemical Products 289 140 0 0 0 Moved to "211 .00 " 101 45100 01 219 .00 Other Operating Supplies 8,552 8,160 10 ,500 8,000 8 ,000 Rec Programs, 1st Aid Sup, etc. 101 45100 01 221.00 Equipment Parts 6,807 6,045 11,138 8,000 8,000 101 45100 01 223 .00 Building Repair Supplies 843 717 1,182 1,500 1,50 0 1014510001 225 .00 Landscaping Materials 8,117 0 0 0 0 Fall Ash Tree Remova l 101 45100 01 229 .00 Other Maintenance Supplies 3,858 894 2,622 4,000 4 ,000 Tournament Supplies 1014510001 312 .00 Custodial Services 5,910 8,260 8,960 6 ,000 6 ,000 Custodial Services-Banquet Rm 101 45100 01 315.00 Special Programs 36 ,700 101 45100 01 315.01 Movies/Co ncerts 5,784 5,589 5,884 6,000 6 ,000 Performances 101 45100 01 315 .02 Leprechaun Days 509 426 562 500 500 101 45100 01 315 03 Umore Maint. Agreement 2,038 2,156 2,156 2 ,000 2 ,000 101 45100 01 315 .04 Ground Pounders(Running ) 225 0 0 200 200 Ribbons & Mailings 101 45100 01 315 .05 Nature Programs (Arbor Day) 0 0 0 0 0 Move to 101-41110-01-225.00 10 1 45100 01 315 .06 Puppet Programs 75 30 0 100 100 Tapes, Fuses, Puppets , etc . 101 45100 01 315 .07 Special Events 2,444 2,260 12 ,568 10 ,000 16 ,000 Food Truck Fest I Arts Festival 101 45100 01 315 .08 Adopt-A-Park Program 90 31 0 500 500 Flye rs , Signs 1014510001 31509 Miscellaneous Programs 10,407 7,517 9,644 5,000 8,000 Community Ga rdens & Other Prog. 101 45100 01 315 .10 ADA Programs 0 400 0 400 400 ADA Program Supplies 101 45100 01 315 .11 Senior Programs 0 364 705 3,000 3,000 101 45100 01 319 .00 Othe r Professional Services 5,265 7,277 5,770 6,000 6 ,000 ADA Services/Eng .LA Serv Test 101 45100 01 321 .00 Telephone Cost s 4,366 4,394 4 ,620 4 ,500 4 ,500 Pag ers & Cellular Phones 101 45100 01 331 .00 Travel Expense 21 122 355 1,000 1,000 101 45100 01 341 .00 Em ployment Advertising 0 0 0 0 0 10 1 45100 01 349 .00 Other Advertising 42 ,000 101 45100 01 349 .01 Brochures 35 ,576 35 ,812 34 ,284 35 ,000 35,000 City Newsletter (3 Per Year) 101 45100 01 349.02 Yellow Pages 0 0 0 0 0 101 45100 01 349 .03 Special Marketing 6 ,306 6,368 5,879 7,000 7 ,000 Garage Sale Ad 101 45100 01 381 .00 Electric Utilities 29 ,899 28 ,784 28,067 30 ,000 30 ,000 101 45100 01 383 .00 Gas Utilities 17 ,9 44 22,769 21,051 20 ,000 20 ,000 101 45100 01 384 .00 Refuse Disposal 3,062 2,982 2,844 3,200 3,200 101 45100 01 392.00 P.C . Accessories & Supplies 0 0 0 0 0 101 45100 01 393 .00 P.C . Hardware Purchases 0 0 0 0 0 101 45100 01 394 .00 P.C . Software Purchases 0 0 0 0 0 See "433 .03" Below 101 45100 01 401 .00 Contracted Building Repairs 10 ,239 14 ,579 9,041 13,000 13 ,000 101 45100 01 404 .00 Contracted Mach & Equ ip Repairs 11,593 38,769 29 ,919 15 ,000 15,000 101 45100 01 409 .00 Other Contracted Repair & Maint 25,815 26,957 23,364 24 ,000 24 ,000 Air Handler Maintenance Cont ra ct 101 45100 01 411 .00 Contracted Snow Removal 0 0 32,524 20 ,000 30 ,000 Community Center 101 45100 01 412 .00 Building Rental 16 ,800 11 ,697 16 ,800 16 ,800 22 ,000 Monthly Rent Payments to Guard 101 45100 01 415 .00 Other Equipment Rental 27 ,625 27 ,552 27,254 28 ,000 28 ,000 Portable Toilets & Other(New Pks) 101 45100 01 433 .00 Dues & Subscriptions 11 ,300 101 45100 01 433 .01 MRPA Dues 1,724 1,430 1,619 2,100 2,100 Minn Recreation & Parks Ass'n 101 45100 01 433 .02 Miscellaneous 1,533 2,386 2,762 6,500 6,500 Paper, Magazines , Cartegraph ,etc. 101 45100 01 433 .03 On-Line Registrat'n Subscription 2,1 50 972 869 2,700 2,700 101 45100 01 435 .00 Books & Pamphlets 0 0 0 100 100 101 45100 01 437 .00 Conferences & Seminars 7,000 1014510001 437 .01 MRPA State Conference 2 ,671 2,618 1,192 3,000 3 ,000 101 45100 01 437 .03 Workshops, Schools, & Tu ition 3,360 2,321 1,966 4,000 4 ,000 Additional Training 101 45100 01 439 .00 Other Miscellaneous Charges 5,767 6 ,654 5,278 0 0 Donation Account 101 45100 01 530 .00 Improvements Other Than Bldgs 0 0 15,092 0 0 ---------------------------------------------------------------------------------------------------- PAGE TOTALS $1 ,298 ,378 $1,402,339 $1,481,544 $1,462,000 $1 ,544 ,600 General Operating DEPARTMENT TOTALS $1 ,298 ,378 $1,402 ,339 $1,481,544 $1 ,462 ,000 $1 ,544 ,600 ========= ========= ========= ========= ======:::== Page Two 20 21 BUDGET WORKS H EE TS PARKS & RECREATIO N •• STEEPLE C EN TER •• Aug ust4 ,2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 101 38201 .00 Rental Revenues $31 ,490 $31 ,490 $48,806 $40,000 $40 ,000 101 38205.00 AN Rental Revenues 750 750 400 1,000 1,000 101 38207 .00 Liquor Provider Revenues 120 120 330 200 200 101 38209 .00 Miscellaneous Revenues 0 0 0 0 0 10138211 .00 Security Services 2,072 2,072 5,275 2,000 4,000 101 38215 .00 Other Revenues 0 0 0 0 0 --------------------------------------------------------------------------------------------------- TOTAL REVENUES $34,432 $34,432 $54 ,810 $43,200 $45 ,200 101 45100 30 103 .00 Salaries & Benefits $65 ,000 Salary , Taxes , PERA & Benefits 101 45100 30 103 .00 Building Attendants 71 ,240 77 ,633 86 ,975 65 ,000 65,000 Staff " 101 45100 30 211 .00 Cleaning Supplies 4 ,251 4 ,047 3,413 4,000 4,000 101 45100 30 219 .00 Other Operating Supplies 7 ,927 7 ,733 6 ,344 6 ,000 6 ,000 Events Supplies 101 45100 30 221 .00 Equipment Parts 1,303 3,676 2,682 3,000 3,000 101 45100 30 223 .00 Building Repair Supplies 5,483 2 ,294 3,125 4 ,000 4 ,000 101 45100 30 241 .00 Small Tools 500 0 0 500 500 101 45100 30 242 .00 Minor Equipment 476 96 1,489 1,000 1,000 101 45100 30 312 .00 Custodial Services 1,061 840 1,400 1,000 1,000 101 45100 30 321 .00 Telephone Costs 375 377 601 500 500 101 45100 30 349 .00 Other Advertising 1,500 1,500 900 1,500 1,500 101 45100 30 381 .00 Electric Utilities 17 ,321 16 ,893 16 ,147 16,000 16,000 101 45100 30 383 .00 Gas Utilities 7,502 9,338 8,540 7 ,500 7,500 101 45100 30 384 .00 Refuse Disposal 583 631 899 700 700 101 45100 30 401 .00 Contracted Building Repairs 12 ,660 8 ,847 8,162 10,000 10 ,000 101 45100 30 404 .00 Contracted Mach & Equip Repa irs 15 ,653 29 ,548 15,941 14 ,000 14 ,000 101 45100 30 409 .00 Other Contracted Repairs & Main 2,493 0 2,500 2,500 2,500 1014510030 411 .00 Contracted Snow Removal 0 0 27 ,962 12 ,000 25 ,000 Steeple Center 101 45100 30 415 .00 Other Equipment Rental 0 0 0 0 0 101 45100 30 439 .00 Other Miscellaneous Charges 0 0 0 0 0 101 45100 30 521 .00 Bu ilding & Structure Purchases 0 0 0 0 0 ----------------------------------------------------------------------------------------------- PAGE /EXPENDITURE TOTALS $150 ,32 9 $163,453 $187 ,079 $149 ,200 $162 ,200 Page Three 2021 BUDGET WORKSHEETS PARKS & RECREATION August 4 , 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- $85 ,600 1014510080 Art Classes $0 $0 $0 $0 $0 101 45100 81 Softball 10 ,072 4 ,479 0 0 0 101 45100 84 Tennis 2,063 2,212 1,521 2 ,200 2,200 1014510086 Rosettes 1,4 19 1,633 1,344 2 ,000 0 101 45100 87 Se nio r Programs 17 ,564 13 ,3 83 12 ,752 14,000 14 ,000 1014510090 Run for the Gold 4 ,751 6 ,071 3 ,559 6 ,000 6 ,000 101 45100 91 Camps 38 ,298 43,299 37 ,382 40 ,000 40,000 10 1 45100 92 Adult Basketball 0 475 0 600 600 101 45100 93 Other Programs 16 ,534 15,7 30 18 ,910 14,000 14 ,00 0 101 45100 95 T-Ball 4 ,740 4 ,682 4 ,012 5,000 5,00 0 101 45100 96 Adult Enrichment 0 2,769 0 500 500 101 45100 97 Adult Exercise Classes 0 0 0 500 500 101 45100 98 Youth Soccer Lessons 2,576 3,093 3,012 2 ,800 2 ,800 ---------------------------------------------------------------------------------------------------- 98 ,0 17 97,826 82 ,493 87 ,600 85 ,600 101 451 0080 21 9.00 Operat ing Supplies 0 0 0 0 0 101 4510081 10 3.00 Part-Time Salaries 1,25 7 969 0 0 0 10 1 4510081 21 9.00 Operating Supplies 2 ,360 609 0 0 0 1014510081 311 .00 Officiating Fees 6 ,102 2,703 0 0 0 101 45100 81 319 .00 Other Professional Services 352 198 0 0 0 101 45100 84 103 .00 Part-Time Sa laries 2,063 2,018 1,475 1,700 1,700 101 45100 84 219 .00 Operating Supplies 0 194 46 500 500 101 45100 86 103 .00 Part-Time Salaries 623 846 490 1,000 0 101 45100 86 219 .00 Operating Supplies 796 787 855 1,000 0 1014510087 103 .00 Pa rt-Time Salaries 0 0 0 0 0 101 45100 87 219 .00 Operating Supplies 14 ,000 101 45100 87 219 .01 YouthfTeen Trips Supplies 0 0 0 0 0 101 45100 87 219 .02 AdulVSen ior Supplies 17 ,564 13,383 12,752 14 ,000 14 ,000 101 45100 90 219 .00 Operating Supplies 4,751 6,071 3,559 6 ,000 6 ,000 101 45100 91 103 .00 Part-Time Salaries 13,774 20 ,033 9,390 18 ,000 18,000 101 45100 91 219 .00 Operating Suppl ies 24 ,524 23 ,266 27 ,992 22 ,000 22 ,000 101 45100 92 219 .00 Operating Supplies 0 475 0 600 600 101 45100 93 103 .00 Part-Time Salaries 2,475 3,434 2,370 3 ,000 3,000 101 45100 93 219 .00 Operating Supplies 11 ,106 12,08 1 16 ,540 11 ,000 11 ,000 10 1 45100 93 319 .00 Other Professional Services 2,954 215 0 0 0 101 45100 95 103 .00 Part-Time Salaries 3,549 3,484 2,762 3,500 3,500 101 45100 95 219 .00 Operating Supplies 1,190 1,198 1,250 1,500 1,500 101 45100 96 103 .00 Part-Time Salaries 0 0 0 0 0 101 45100 96 219 .00 Operating Supplies 0 2,769 0 500 500 101 45100 97 103 .00 Part-Time Sa laries 0 0 0 0 0 1014510097 219.00 Operating Supplies 0 0 0 500 500 101 45100 97 311 .00 Officiating Fees 0 0 0 0 0 1014510098 103 .00 Part-Time Salaries 1,832 2,136 2,193 1,800 1,800 10 14510098 219 .00 Operating Supplies 744 957 819 1,000 1,000 ------------------------------------------------------------------------------------------- SPECIAL PROGRAM TOTALS 98 ,0 17 97,826 82 ,493 87 ,600 85 ,600 GRAND TOTAL -PAR K & RE C $1 ,546 ,723 $1 ,663 ,618 $1 ,751,115 $1 ,698 ,800 $1 ,792,400 ========= ========= ========= ========= ========= Page One August 4 , 2020 Account# 2021 BUDGET WORKSHEETS OTHER FINANCING USES Description 101-49300-01 710 .00 Transfers 101-49300-01 710 .01 Arena Operations Assistance 101-49300-01 710.02 Debt Service Levies 101-49300-01 720 .00 Transfers FUND TOTALS 2017 Actual 2018 Actual 2019 Actual 2020 Adopted Budget $130 ,000 $130 ,000 $130 ,000 $130,000 0 0 0 0 0 0 0 0 17 ,914 203 ,000 169,000 0 $147 ,914 $333 ,000 $299 ,000 $130 ,000 2021 Object Detail Amount 130 ,000 0 2021 Proposed Budget $130 ,000 Comments 0 Excess F/B Transfers (2018/19) $130 ,000 Page One August4 , 2020 Account# 206 31010.00 206 33100 .00 206 36210.00 206 36214 .00 206 36215 .00 206 36260 . 00 206 36265 .00 206 39201 .00 Account# 206 49006 01 206 49006 01 206 49006 01 206 49006 01 206 49006 01 206 49006 01 206 49006 01 206 49006 01 206 49006 01 206 49006 01 206 49006 01 206 49006 01 206 49006 01 221 .00 304 .0 0 305.00 317 .00 319.00 319.01 319 .02 365 .00 369 .00 403 .00 409 .00 439 .00 550 .00 2021 BUDGET WORKS HEETS IN SURANCE -REVE NU ES Description Current Ad Valorem Taxes Federal Grants & Aids Interest Earnings-Investments Net Change in FV-lnvestments Interest Earnings Other Re venue Use of Reserve Funds Transfer from General Fund FUND TOTALS INS U RANCE -EXPENDITURES Description Equ ipment Parts Legal Fees Med ical & Dental Fees General Fund Administrative Fees Other Professional Services Risk Management Consultant Safe Assure Consultant Worker's Compensation Insurance Other Insurance Contracted R & M-Other lmpr. Other Contracted Repair & Main! Other Miscellaneous Charges Motor Vehicle Purchases FUND TOTALS 2017 Actual $260,000 0 3 , 180 0 160 29,357 0 0 2018 Actual $280,000 0 2 , 131 0 424 16 ,674 0 203 ,000 2019 Actual $380,000 0 0 0 1,074 16 ,775 0 0 2020 Adopted Budget $425 ,000 0 1,300 0 200 20,000 0 0 2021 Object Deta il Amount 2021 Proposed Budget $450 ,000 0 0 0 500 16,000 0 0 ------------------------------------------------------------------------------------------ 292 ,697 ======== 2017 Actual $2,446 63,015 16 ,972 2 ,500 6 ,000 13 ,320 185,739 127,264 0 37 ,230 6 ,500 12 ,332 502,228 ======== 2018 Actual $11 ,782 0 17 ,915 2 ,500 11 ,830 8 ,626 209,605 125,881 0 48 ,917 0 0 397,849 ======== 2019 Actual $155 1,000 14 ,992 2 ,500 8 ,213 18 ,122 234, 163 133,195 0 51 ,196 0 0 446 ,500 ======== 2020 Adopted Budget $7 ,000 15,000 12 ,000 2 ,500 10 ,000 10 ,000 220,000 130,000 0 40 ,000 0 0 466 ,500 ======== ======== 2021 Object 2021 Detail Proposed Amount Budget $2,000 2 ,000 15,000 2 ,500 30 ,000 10 ,000 20,000 240 ,000 135,000 0 40,000 0 0 ------------------------------------------------------------------------------------------ 473,318 437 ,055 463 ,535 446 ,500 466 ,500 ======== ======== ======== ======== ======== ======== Comments Annual Market Value Changes Insurance Refunds/Dividends Comments Liability & Auto Deductible Pymts Unreimbursable Legal Fees Work Comp Deductible Pymts Yearly Fee Per Pol icy F -3 Annual Prem ium Annual Premium-General Liability (Changed to High Deductible) Liability & Auto Deductible Pymts (Changed to H igh Deductible) NOTE : Levy of $450,000 covers costs for all insurance premiums and some of the general liability payments (changed to high deductible plan for 2011 ). A ll other ex penditures covered through a combination of ta x levies , interest earnings , insurance refunds/dividends and reserve funds . Page One July 21 , 2020 Account# 201 31010.00 201 31050.00 201 32280. 00 201 33130 .00 201 33425.00 201 33620 .00 201 34109 .00 201 36210.00 201 36215 .00 201 36230 .00 201 36260.00 201 36265.00 201 39101.00 Account# 2021 BUDGET WORKSHEETS PORT AUTHORITY -REVENUES Description Current Ad Valorem Taxes Tax Increments Fiber License Fees Federal Grants-CDBG Other State Grants & Aids Other County Grants & Aids Other Charges for Services Interest Earnings -Investments Interest Earnings Contributions/Donations Other Revenue Use of Reserve Funds Sales of General Fixed Assets FUND TOTALS EXPENDITURES Description 2014630002 101 .00 Full-Time Salaries & Benefits 201 46300 99 103 .00 Part-Time Salaries & Benefits 201 46300 01 219.00 Other Operating Suppl ies 201 46300 01 303.00 Engineering Fees 201 46300 01 304.00 Legal Fees 201 46300 01 317 .00 General Fund Administrative Fees 201 46300 01 319 .00 Other Professional Services 201 46300 01 319 .01 Project Management Consultant 201 46300 01 319 .02 Marketing -REDE -City Share 201 46300 01 319 .04 P/A Property Tax Payments 201 46300 01 319.05 Other Consultants 201 46300 01 319.06 Grant Reimbursement Expenses 201 46300 01 319 .07 Retail Strategies 201 46300 01 319.08 Open to Business (OTB ) 201 46300 01 322.00 Postage Costs 201 46300 01 331.00 Travel Expense 201 46300 01 349.00 Other Advertising 201 46300 01 359 .00 Other Printing & Binding Costs 201 46300 01 365 .00 Workers Comp Insurance 201 46300 01 369 .00 Other Insurance 201 46300 01 381 .00 Electric Utilities 201 46300 01 383 .00 Gas Uti lities 201 46300 01 389 .00 Other Utility Services 201 46300 01 403 .00 201 46300 01 433 .00 201 46300 01 433 .01 201 46300 01 433 .02 201 46300 01 437 .00 201 46300 01 439 .00 Contracted Repairs & Maintenance Dues & Subscriptions Professional Organizations/Jourm Foreign Trade Zone Commission Conferences & Seminars Other Miscellaneous Charges 201 46300 01 521 .00 Bu ilding & Structure Purchases 201 46300 01 525 .00 Building & Structure Purchases 201 46300 01 530 .00 Improvements Other Than Bldgs 201 46300 01 710 .00 Transfers FUND TOTALS 201 7 Actual $58 ,0 00 0 1, 150 0 32,479 0 2 ,560 8 224 0 0 0 0 $94,421 2017 Actual $0 2 ,217 0 5,842 0 6 ,000 0 10 ,0 00 0 165 14 ,655 0 0 0 13 13 ,967 0 124 758 283 0 0 270 920 0 2 ,384 165 0 0 0 0 $57 ,763 2018 Actual $60,000 0 600 0 0 0 10 ,175 442 376 0 0 0 0 2019 Actual $105 ,000 0 1,200 0 0 0 7,225 457 2,231 0 0 0 268,114 2020 Adopted Budget $112 ,000 0 1,200 0 0 0 8 ,000 100 100 0 0 0 0 $71 ,594 $384,228 $121,400 2018 Actual $0 2 ,367 6 ,361 23 ,896 5 ,651 6 ,000 0 10,000 0 9,083 0 0 0 0 0 9 ,650 0 137 584 172 0 0 3,940 495 0 2,631 0 0 0 16,313 0 $97,279 2019 Actual $0 2 ,575 6 ,923 332 3,468 6 ,000 0 11,068 0 1,750 0 45,000 0 0 293 9 ,077 2 140 555 171 0 0 0 2 ,217 0 3,300 3,689 0 0 0 0 2020 Adopted Budget $0 4,000 8 ,000 3 ,000 4 ,000 6 ,000 2 ,000 10,000 0 2 ,000 0 40 ,000 5,500 0 0 25 ,000 200 200 600 400 0 1,000 2 ,000 2 ,000 0 5,000 500 0 0 0 0 $96 ,560 $121 ,400 2021 Object Detail Amount 2021 Object Detail Amount 2 ,000 12,000 0 2 ,000 0 0 5 ,500 2 ,500 0 2021 Proposed Budget $168 ,000 0 1,200 0 0 0 8 ,000 400 400 0 0 0 0 $178 ,000 2021 Proposed Budget $78,600 4 ,000 8,000 3,000 4 ,000 6,000 21 ,500 0 500 40,000 200 200 600 400 0 1,000 2 ,000 2,500 5 ,000 500 0 0 0 0 $178 ,000 ========= ========= ========= ========= ========= ========= Comments Operating Levy Admin Fees Po rt ion Only LCA Grant-Land/Bldg Acquisition Business Expo Interest Earned on CD's Checking Interest & M isc Comments All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 70% of Economic Dev Coordinator Port Authority Members Business Expo Yearly Fee Per Policy F-3 Greater MSP Downtown Upd ate Additional Marketing Opportunities Commissioners Property Insurance Business Park & Other Properties Other Properties Utility Fees I Fiber Maintenance Contracts for Fiber Prof Organizations/Journals Development/TIF/Misce llaneous Contingencies Page One July 21 , 2020 Accou nt# 242 31010 .00 242 31050 .00 242 33400 .00 242 33425 .00 242 33620 .00 242 36210.00 242 36215 .00 242 36220 .00 242 36230 .00 242 36260 .00 242 39101 .00 242 39310 .00 Account# 242 49042 01 242 49042 01 242 49042 01 242 49042 01 242 49042 01 242 490 42 01 242 49042 01 242 49042 01 242 49042 01 242 49042 01 242 49042 01 2021 BUDGET WORKSHEETS DOWNTOWN/BROCKWAY DISTRICT(0108) -REVENUES Description Current Ad Valorem Taxes Tax Inc rements State Grants & Aids Other State Grants & Aids Other County Grants & Aids Interest Earnings -Investments Interest Ea rnings Rents & Royalties Other Revenue Con tribution/Donation-Private Sale of General Fixed Assets Bond Proceeds 2017 Actual $0 832 ,533 0 0 0 3,413 287 0 0 0 0 0 2018 Actual $0 863 ,105 0 0 0 11,759 656 0 0 0 0 0 2019 Actual $0 865,476 0 0 0 15,491 2 ,149 0 0 0 0 0 2020 Adopted Budget $0 870 ,000 0 0 0 1,000 0 0 0 0 0 0 2021 Object Detail Amount 2021 Proposed Budget $0 900,000 0 0 0 1,000 0 0 0 0 0 0 ------------------------------------------------------------------------------------------------ FU ND TOTALS $836,233 $875,520 $883,115 $87 1,0 00 $901 ,0 00 ::;::;:::::::::::::::::::::::::: ======:::::== ========= ------------------------ EXPENDITURES 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Description Actual Actual Actual Budget Amount Budget 303 .00 Eng ineeri ng Fees $0 $0 $0 $0 $0 304 .00 Legal Fees 0 116 0 0 0 319 .00 Other Professional Services 12,998 15 ,7 25 19 ,983 17,000 22,000 522 .00 Building & Structure Purchases 0 0 0 0 0 530 .00 Improve ments Other Than B uildings 63,169 0 0 0 0 533 .00 Improvements Other Than Buildings 0 0 0 0 0 536 .00 Improvements Other Than Bu ildings 0 0 0 0 0 538 .00 Improvements Other Than Build ings 0 0 0 0 0 601 .00 Principal on Waterford PAYG 73,422 78 ,217 81,460 85 ,000 90 ,000 611 .00 Interest on Waterford PA YG 71,313 67 ,560 63,673 65 ,000 60 ,000 7 10 .00 Transfers 550 ,000 600 ,000 600 ,000 600,000 600 ,000 ------------------------------------------------------------------------------------------------ FUND T OTALS $770,902 $761 ,617 $765, 116 $767,000 $772 ,000 ========= ========= ========= ---------------- Comments MVHC Payments Comments County TI F Ch arges CDA-Dahn Property Purchase Fib er in Bu siness Park TH 3 Turn La ne Improvements Wate rford Pay-As-You-Go Wate rford Pay-As-You-Go P & I for 2008A & 2015A Issues Page One August 4 , 2020 Account# 601 33130.00 601 33425.00 601 33620.00 601 34107 .00 601 34108.00 601 34109.00 601 36101.00 601 36102.00 601 36210 .00 601 36214 .00 601 36215.00 601 36220.00 601 36260 .00 601 36265 .00 601 37110 .00 601 37120 .00 601 37125 .00 601 37130.00 601 37140.00 601 37160 .00 601 37165 .00 601 37170 .00 601 37180 .00 601 39103.00 601 39203.00 2021 BUDGET WORKSHEETS WATER UTILITY ·REVENUES· Description Federal Grants -CDBG Other State Grants & Aids Other County Grants & Aids Assessment Fees Administrative Fees-Other Funds Other Gen' I Govt Chgs for Services Principal -Special Assessments Penalties & Interest -S/A Interest Earnings -Investments Net Change in FV-lnvestments Interest Earnings Rents & Royalties Other Revenues Use of Reserve Funds Residential Water Revenues Apartment Water Revenues Institutional Water Revenues Commercial Water Revenues Industrial Water Revenues Penalties -Water Revenues Meter Maint Water Revenues Other Water Revenues Water Meter Sales Revenue Gain or Loss from FIA Disposal Transfer From FUND TOTALS 2017 Actual $75,280 6,762 2,000 0 5,069 18,050 55,401 627 92 ,126 (3,227) 787 148,434 0 0 1,363 ,923 108 ,265 84 ,046 90 ,872 139,554 12 ,286 0 0 58 ,045 (9 ,885 ) 0 2018 Actual $24,956 33,455 0 1,280 11,796 15 ,984 77,288 655 149,982 (12,063) 1,244 154,610 117 0 1,426,360 113,851 66,183 94,093 122,071 12,848 0 0 87,294 (426) 0 2019 Actual $0 720 0 21,497 9,327 17 ,261 53,808 719 177,969 39 ,042 3,358 161 ,211 0 0 1,274,288 121 ,359 83 ,160 95,413 135 ,704 12 ,012 0 (29 ,682) 96,658 0 0 2020 Adopted Budget $0 4 ,500 0 0 6 ,300 0 55,000 0 90 ,000 0 500 168,500 0 0 1,500,000 120,000 70,000 100,000 130,000 10 ,000 0 0 80,000 0 0 2021 Object Detail Amount 2021 Proposed Budget $0 1,000 0 20 ,000 6,300 0 55,000 0 90 ,000 0 1,000 170,000 0 0 1,400 ,000 120 ,000 75,000 100,000 140 ,000 12,000 0 0 90,000 0 0 --------------------------------------------------------------------------------------------------------- $2 ,248,416 $2 ,381 ,577 $2,273 ,824 $2,334 ,800 $2,280,300 ========= ========= ========= ========= ========== ========== Comments MCES Water Efficiency Grant 5% of 5% Fees-Const Projects Annual Market Value Changes Antenna Leases 2nd Meter Refunds Page One 2021 BUDGET WORKSHEETS WATER UTILI TY -EXPENDITURES - August4 , 2020 2021 2020 Object 2021 2017 2018 2019 Adopted De tai l Proposed Account# Desc riptio n Actual Act ual Actual Budget Amou nt Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 601 49400 101 .00 Salaries & Benefits $547 ,600 Salary , Taxes , PERA & Benefits 601 4 9400 77 101 .00 Administrative 129,584 205 ,824 162,236 155 ,500 181 ,500 601 49400 78 101 .00 Technica l/Clerical 146,843 155,870 169 ,268 177 ,900 198 ,800 Added PfT GIS Techn ician 601 4 9400 79 101 .00 Maintenance 171 ,054 180 ,248 183 ,174 230 ,600 167 ,300 601 49400 xx 101 .00 Salary & Benefit Contingency 0 0 0 0 0 60 1 49400 102 .00 Full-Time Overtime 10,140 13,549 16,444 8,000 8 ,000 601 49400 103 .00 Part-Time Salaries & Benefits 5,779 6 ,916 7,975 8,700 8,700 601 49400 99 103 .xx Utility Commission Wages (1/3) 700 601 49400 99 103.xx Maintenance Labor 8,000 Seasona l Employees and Inte rn s 601 49400 01 203 .00 Printed Forms & Pape r 504 1,092 70 100 100 Outsource Bil l Printing (313 .00 ) 601 49400 01 205 .00 Pl otter Ink & Paper 0 0 0 400 400 601 49400 01 209 .00 Othe r Office Supplies 114 362 134 200 200 601 49400 01 212 .00 Moto r Fuels 5,600 5,100 3,9 12 3,900 3,900 2 .5% Covered by Water Utility 601 49400 01 216 .00 Chemicals & Chemical Products 55 ,588 43 ,035 60,654 75 ,000 75 ,000 Chlorine/Flouride/Poly 601 49400 01 219 .00 Other Operating Supplies 415 2 ,053 1,174 500 500 Ma intenance Supplies 601 49400 01 220 .00 Water Meter Purchases 150 ,000 Meters , MIU's & CU Horns 601 4940 0 01 220 .01 For Replacements 57,467 71 ,822 78 ,315 75 ,000 75 ,000 Match Rate Model (Incl. Recycling ) 601 4940 0 01 220 .02 For New Homes 42 ,572 47 ,296 52 ,209 75 ,000 75,000 Match Rate Model , Newland Dev . 60 1 49400 01 224 .00 Street Maintenance Materials 329 1,261 4 ,769 2,500 2 ,500 Patching for Breaks 601 49400 01 225 .00 Landscaping Materials 323 360 108 1,000 1,000 Topsoil , Seed & Sod 601 49400 01 228 .00 Meter Repair Materials 0 222 105 0 0 601 49400 01 229 .00 Other Maintenance Supp lies 21 ,000 601 49400 01 229 .01 Suppl ies fo r Hydrants 8,968 8,476 6 ,939 10,000 10 ,000 601 49400 01 229 .02 Curb Shutoffs 0 855 0 1,000 1,000 601 49400 01 229 .03 GV Repair/Replacement 934 0 13,526 2,000 6 ,000 Valve Maintenance 601 49400 01 229 .04 Miscellaneous Supplies 3 ,247 3,350 685 4 ,000 4,000 601 49400 01 240 .00 Safety Equipment & PPE 0 0 0 500 500 Vests , Glasses , Hardhats, etc . 601 49400 0 1 241 .00 Small Tools 1,099 2 ,140 1,782 2,500 2 ,500 Wrenches , Shovels, etc . 601 49400 01 242 .00 Minor Equipment 11 ,622 8 ,371 6 ,052 17,000 16,000 Hyd . Buddy & Locator in 2021 601 494 00 01 303 .00 Engineering Fees 26 ,000 60 1 49400 01 303 .01 WHPP 0 0 21 ,302 5,000 5,000 Groundwater Plan Imp lementation 60 1 49400 01 303 .02 GIS 2,476 78 0 1,000 1,000 $5,000 Split 5 Ways 60 1 4940 0 01 303 .03 Rate Study 0 14,459 19,172 5,000 5,000 601 4 9400 01 303 .04 Miscellaneous Fees 17 ,602 2,574 2 ,745 15 ,000 15 ,000 F uture Water Facility Study 601 49400 01 304 .00 Legal Fees 105 0 1,226 1,000 1,000 601 49400 01 310 .00 Testing Services 85 ,000 601 49400 01 310 .01 Bacteria & Wate r Quality 2 ,269 2 ,625 3,572 3,500 5,000 MN , Radon , Tri -Ch i., Pesticides , Etc . 601 49400 01 310 .03 MOH Se rvi ce Connection Fee 45 ,928 47 ,381 49 ,186 80 ,000 80 ,000 601 49400 01 312 .00 Gopher Sta te One-Call 1,68 3 1,436 1,794 2,500 2 ,500 $7,500 Split 3 Ways 601 49400 01 313 .00 Outsource Bill Printing /Mailing 0 2 ,201 6 ,618 8,300 8,300 601 49400 01 318 .00 Co ntract Eng ineer 22 ,602 0 0 0 0 601 49400 01 319 .00 Other Profess ional Services 47 ,500 601 49400 01 319 .01 Thaw Pipes , Check Lea ks, etc . 0 0 0 1,500 1,500 601 494 00 01 319 .02 Supervisory Controls 3,435 0 2,053 5,000 5 ,000 601 49400 01 319 .03 Hazardous Chem ical Permits 725 700 800 1,000 1,000 MN Department of Publi c Safety 601 49400 01 319 .06 Contracted Hydrant Pa inting 8,265 11 ,172 9,212 11 ,000 11 ,000 601 49400 01 319 .07 Antenna Expenses 3,577 9 ,209 3,842 20 ,000 20 ,000 Offset by Reven ue 601-36220 .00 601 49400 01 3 19 .08 Buxton Project 0 9 0 0 0 601 49400 01 319 .09 HVA C Ma intenance Contract 3,304 0 1,702 4 ,000 4,000 Annual lnsp/Ma int , All Wells 601 49400 0 1 319 .10 Landscape Maintenan ce 0 0 2,655 4 ,000 4 ,000 601 49400 01 319 .11 Pest Control 0 0 539 1,000 1,000 60 1 49400 01 320 .00 Cred it Card Activity Fees 6 ,299 7 ,767 9,409 8,500 9 ,500 1 /3 Cost of CIC Pymt Processing 601 4940 0 01 321 .00 Telephone Costs 3,23 0 4 ,7 34 4 ,134 5,000 5,000 Cell Phones , Modesm , GPS 60 1 49400 01 322 .00 Postage Costs 3,767 2,920 369 400 400 Outsource Mail ing (313 00) 60 1 4940 0 01 323 .00 Radio Un it s 5,777 6 ,082 6 ,282 7 ,100 1,000 601 49400 01 352 .00 Genera l Notices & Public Info 0 0 36 0 0 601 49400 01 365 .00 Workers Comp Insurance 12 ,311 13 ,635 13 ,863 12 ,000 12 ,000 Wat e~s Share of Premiums 601 49400 01 369 .00 Other Insurance 6 ,507 6,793 7 ,249 7 ,000 7 ,000 Water's Share of Premiums 60 1 494 00 01 391 .00 P.C . Maintenance 2 ,900 601 49400 01 391 .01 U/B Software Maintenance 2,177 2,159 2,372 2 ,200 2,200 Added to Utility Budgets in 2012 601 49400 01 39 1.02 Auto Read Software Support 631 650 650 700 700 Added to Utility Budgets in 2012 601 49400 01 392 .00 P.C . Accessories & Supplies 108 0 33 200 200 601 4940 0 01 39 3.00 P.C . Hardware Purchases 589 1,967 361 3,000 3,000 $1,100 Intern GPS ($3 ,300 Shared ) 601 4940 0 01 39 4 .00 P.C . Software Purchases 11 ,000 601 494 00 01 39 4 .01 Licens ing & Ma intenan ce 10,129 8 ,954 9,715 10 ,500 10 ,500 ESRI , Cartegraph , Datalink 601 49400 0 1 39 4 .02 On li ne Subscriptions 234 234 0 300 300 Pictometry 601 49400 0 1 394 .03 New Softw are Purchases 46 0 98 3 20 0 200 --------------------------------------------------------------------------------------- PAGE TOTA LS 815 ,958 905 ,941 951,406 1,077 ,200 1,060 ,20 0 Page Two 2021 BUDGET WORKS HEETS WAT ER UTILITY -EXPENDITURES - August4,2020 2021 2020 Object 2021 2017 2018 2019 Adopted De tail Proposed Account# Description Actual Actua l Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 601 49400 01 403 .00 Contracted R & M -Ot her lmpr 24,873 82,681 52,829 80,000 80 ,000 Main Breaks, Gate Valves, Etc. 601 49400 01 433 .00 Dues & Subscriptions 0 327 250 500 500 Suburban Utility Supt Assn , MRWA 601 49400 01 435 .00 Books & Pamphlets 0 0 0 200 200 Reference Materials 601 49400 01 437 .00 Conferences & Seminars 6 ,500 601 49400 01 437 .01 MOH Training (Water School) 2,173 1,026 2,066 3,000 3,000 Operator Lice nsure 601 49400 01 437 .02 AWWA Conference 0 1,899 0 2,000 2,000 Dulu th, Send 2 Staff 601 49400 01 437.03 Ca rt eGraph , ESRI , GIS 139 607 0 500 500 User Group, Conference , Training 601 49400 01 437.04 Miscellaneous Traini ng 62 20 458 1,000 1,000 601 49400 01 439 .00 Othe r Miscellaneous Charges 15 ,328 12 ,674 11,878 20,000 20 ,000 DNR Annual Water Use 601 49400 01 450 .00 Sales Tax on Purchases 0 0 0 0 0 601 49400 01 521 .00 Building & Structure Pu rchases 0 0 0 0 601 49400 01 530 .00 Improvements Other Than Bldgs 201,000 601 49400 01 530 01 Well Inspections 0 800 0 1,000 1,000 601 49400 01 530.02 Miscellaneous Improvements 75,280 81,548 13,156 50,000 50,000 Seal Wells 1 & 2 (2018) 601 49400 01 530.03 CRP of Watermain 0 0 0 50,000 50,000 PMP Water Imp. When Needed 601 49400 01 530.04 Inspection & Maintenance 85,845 12,835 601 ,050 100,000 100 ,000 From Long-Term Plan(Chip in 2019) 601 49400 01 540 .00 Heavy Machinery Purchases 0 0 0 0 0 Equipment Purchases -Match GIP 601 49400 01 548 .00 Lease Prog ram-P.W . Vehicles 0 16 ,984 6,740 0 0 601 49400 01 550 .00 Motor Vehicle Purchases 11 ,436 0 43 ,080 13 ,100 13 ,100 Vehicle Leases 601 49400 01 570 .00 Office Equipment Purchases 0 0 0 500 500 601 49400 01 580 .00 Other Equipment Purchases 0 24,754 0 0 0 601 49400 01 611 .00 Interest on Lease Payments 930 476 824 0 0 P.W. Building Expansion(See 521) 601 49400 01 710 .00 Transfers 0 0 57,500 0 0 Transfers for Other Improvements ---------------------------------------------------------------------------------------------------------- 601-49400-01 TOTA LS 1,032,023 1,142,571 1,741,235 1,399,000 1,382,000 601 49406 01 221 .00 Equipment Parts 0 0 379 200 200 SCADA Upgrades 601 49406 01 223 .00 Building Repair Supplies 0 0 0 200 200 601 49406 01 319 .00 Other Professional Services 5,585 0 0 1,000 1,000 601 49406 01 381 .00 Electric Utilities 1,573 409 1,846 1,300 1,300 Pumping & Lighting ------------------------------------------------------------------------------------------------------- TOTAL-PRV 7 ,158 409 2,225 2,700 2,700 601 49407 01 221 .00 Equipment Parts 2,120 3,664 196 1,500 1,500 601 49407 01 223 .00 Building Repair Supplies 32 0 0 200 200 601 49407 01 319.00 Other Professional Services 0 0 0 0 0 601 49407 01 321.00 Telephone Costs 211 211 211 300 300 601 49407 01 381 .00 Electric Utilities 25,303 25,629 16 ,267 33 ,000 33,000 Pumping, Lighting, Tower Mixer 601 49407 01 409.00 Other Contracted Repairs & Maint 3,665 2,044 4,715 2,000 2,000 601 49407 01 439.00 Other Miscellaneous Cha rges 0 0 0 100 100 Contingencies 601 49407 01 530 .00 Improvements Other T han Bldgs 3,323 9,184 1,853 2,000 2,000 Standby Generator in 2019 ---------------------------------------------------------------------------------------------------------- TOTAL -WELL #7 34,654 40,733 23 ,241 39 ,100 39 ,100 601 49408 01 221 .00 Equipment Parts 1,662 1,139 0 1,500 1,500 601 49408 01 223 .00 Build ing Repair Supplies 5 0 0 200 200 601 49408 01 319 .00 Other P rofessional Services 0 0 0 0 0 601 49408 01 38 1.00 Electric Utilities 19 ,484 21 ,238 19 ,796 25 ,000 25 ,000 Pumping & Lighting 601 49408 01 383 .00 Gas Utilities 397 469 365 600 600 Heat On ly 601 49408 01 409 .00 Other Contracted Repairs & Maint 324 6 ,959 2,005 2,000 2,000 601 49408 01 439 .00 Other Miscellaneous Cha rges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL -WELL #8 21 ,872 29 ,804 22 ,166 29 ,400 29,400 601 49409 01 221.00 Equipment Parts 10 29 196 1,500 1,500 601 49409 01 223 .00 Building Repair Supplies 0 0 0 200 200 601 49409 01 319 .00 Other Professional Services 0 0 0 0 0 601 49409 01 38 1.00 Electric Utilities 31 ,776 29 ,288 28 ,305 32 ,000 32,000 Pumping & Lighting 601 49409 01 383 .00 Gas Utilities 616 766 664 1,500 1,500 Heat Only 601 49409 01 409 .00 Other Contracted Repairs & Maint 3,341 2 ,347 1,719 4,000 4 ,000 Paint Generator in 2020 601 49409 01 439 .00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49409 01 530 .00 Improvements Other Than Bldgs 0 0 0 0 0 ------------------------------------------------------------------------------------------------ TOTAL -WELL #9 35,742 32,430 30 ,884 39 ,300 39 ,300 Page Three August4 ,2020 Account# 6014941001 219 .00 601 49410 01 221 .00 601 49410 01 223 .00 601 49410 01 321 .00 601 49410 01 381 .00 601 49410 01 409.00 6014941001 439.00 601 49410 01 530 .00 6014941101 221 .00 601 49411 01 439 .00 6014941201 221 .00 6014941201 223 .00 6014941201 319 .00 601494120 1 381 .00 601 49412 01 409.00 6014941201 439 .00 601 49414 01 221 .00 601 49414 01 223 .00 601 49414 01 319 .00 601 49414 01 381 .00 601 49414 01 409 .00 601 49414 01 439 .00 601 49425 01 221 .00 601 49425 01 223 .00 601 49425 01 319 .00 601 49425 01 381 .00 601 49425 01 409 .00 601 49425 01 439 .00 601 49426 01 221 .00 601 49426 01 223 .00 601 49426 01 319 .00 601 49426 01 381 .00 601 49426 01 383 .00 601 49426 01 409 .00 601 49426 01 439 .00 2021 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES - Description Other Operating Supplies Eq uipment Parts Building Repair Supplies Tel ephone Costs Electric Utilities Other Contracted Repairs & Maint Other Miscellaneous Charges Improvements Other Than Bldgs TOTAL -WELL #10 Equipment Parts Other Miscellaneous Cha rges TOTAL -WELL #11 Equipment Parts Building Repair Supplies Other Professional Services Electric Utilities Other Contracted Repairs & Maint Other Miscellaneous Charges TOTAL -W ELL #12 Equipment Parts Bu ilding Repair Supplies Other Professional Services Electric Utilities Other Contracted Repairs & Maint Other Miscellaneous Charges TOTAL -WELL #14 Equipment Parts Building Repair Supplies Other Professional Services El ectric Utilities Other Contracted Repairs & Maint Other Miscellaneous Charges TOTAL -W ELL #15 Equipment Parts Building Repair Supplies Other Professional Services Electric Utilities Gas Utilities Other Contracted Repairs & Maint Other Miscellaneous Charges TOTAL -WELL #16 2017 Actual 0 1,926 0 765 19 ,551 67 ,275 0 0 2018 Actual 0 1,576 18 765 15,985 24 ,817 0 0 2019 Actual 0 6,557 0 765 14 ,345 403 0 0 2020 Adopted Budget 500 1,000 200 0 17 ,000 2,000 100 0 2021 Object Detail Amount 2021 Proposed Budget 500 1,000 200 0 17 ,000 2 ,000 100 0 ---------------------------------------------------------------------------------------------------------- 89 ,517 43 ,162 22,069 20,800 20 ,800 0 0 0 0 0 0 0 0 0 0 ---------------------------------------------------------------------------------------------------------- 0 0 0 0 0 27 0 434 1,500 1,500 0 0 0 200 200 0 0 0 0 0 26 ,0 35 28 ,566 24.403 28 ,000 28,000 18 ,163 478 8 ,680 2,000 2,000 0 0 0 100 100 ---------------------------------------------------------------------------------------------------------- 44,225 29 ,044 33 ,516 31 ,800 31,800 1,348 466 0 1,500 1,500 0 200 0 200 200 0 0 0 1,000 1,000 25 ,7 08 29 ,869 19 ,012 28 ,000 28 ,000 666 622 27.476 2,000 2,000 0 0 0 100 100 ----------------------------------------------------------------------------------------------------- 27 ,722 31 ,157 46,488 32 ,800 32 ,800 0 564 559 1,500 1,500 0 200 28 200 200 0 0 0 500 500 35.410 28 ,224 17,999 30,000 30,000 0 7 ,333 1,742 2,000 2,000 0 0 0 100 100 ---------------------------------------------------------------------------------------------------------- 35,410 36 ,321 20 ,327 34 ,300 34,300 0 726 260 1,500 1,500 0 0 0 200 200 0 0 0 500 500 0 5,36 8 22 ,821 28 ,000 28,000 0 0 0 0 0 0 0 978 1,000 1,000 0 0 0 100 100 --------------------------------------------------------------------------------------------------------- 0 6,094 24 ,059 31 ,300 31 ,300 Comments Pumping & Lighting Contingencies Rural Water System Rural Water System (#2) Pumping & Lighting Contingencies Pumping & Lighting Contingencies Pumping & Lighting Contingencies Pumping & Lighting Contingencies Page Four August4 ,2020 Account# 601 49415 01 221.00 601 49415 01 319.00 601 49415 01 409 .00 601 49415 01 439 .00 601 49416 01 221 .00 601 49416 01 319 .00 601 49416 01 381 .00 601 49416 01 409 .00 6014941601 439 .00 6014941701 221 .00 601 49417 01 319.00 601 49417 01 381 .00 601 49417 01 409 .00 601 49417 01 439 .00 601 49418 01 221 .00 601 49418 01 319 .00 601 49418 01 381 .00 601 49418 01 409.00 601 49418 01 439.00 2021 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES - Description Equipment Parts Other Professional Services Other Contracted Repairs & Maint Other Miscellaneous Charges TOTAL -WATER TOWER #1 (Chippendale Water Tower) Equipment Parts Other Professional Services Electric Utilities Other Contracted Repairs & Maint Other Miscellaneous Charges TOTAL -WATER TOWER #2 (Connemara Water Tower) Equipment Parts Other Professional Services Electric Utilities Other Contracted Repairs & Maint Othe r Miscellaneous Charges TOTAL -WATER TOWER #4 (Bacardi Water Tower) Equipment Parts Other Professional Services Electric Utilities Other Contracted Repairs & Main! Other Miscellaneous Charges TOTAL -WATER TOWER #3 (East Side Water Tower) GR A ND TOTAL -ALL DEPTS . 2017 Actual 0 0 149 0 2018 Actual 0 0 130 0 2019 Actual 0 0 7,390 0 2020 Adopted Budget 500 0 500 200 2021 Object Detail Amount 2021 Proposed Budget 500 0 500 200 ---------------------------------------------------------------------------------------------------------- 149 130 7,390 1,200 1,200 0 114 10 500 500 0 0 0 0 0 2,274 1,770 2,675 4,500 4 ,500 303 0 4 ,884 500 500 0 0 0 200 200 ------------------------------------------------------------------------------------------------------- 2 ,577 1,884 7 ,569 5,700 5,700 0 0 10 500 500 0 0 0 0 0 2 ,999 2,822 1,881 6 ,000 6,000 0 285 1,052 500 500 0 0 0 200 200 ---------------------------------------------------------------------------------------------------------- 2,999 3,107 2 ,943 7 ,200 7,200 103 164 0 500 500 2,800 0 0 0 0 2,496 1,989 1,867 4 ,000 4,000 553 0 0 500 500 0 0 0 200 200 ------------------------------------------------------------------------------------------------------- 5,952 2,153 1,867 5,200 5,200 $1,340,000 $1 ,398 ,998 $1 ,985 ,978 $1,679 ,800 $1 ,662 ,800 ========= ========= ========= ========= ========== ========== Comments Conti ngencies Contingencies Contingencies Contingencies Page One August 4, 2020 Account# 602 33425 .00 602 34108 .00 602 36101 .00 602 36102 .00 602 36210 .00 602 36214 .00 602 36215 .00 602 36260 .00 602 36265 .00 602 37210 .00 602 37220 .00 602 37225 .00 602 37230 .00 602 37240 .00 602 37260 .00 602 39103 .00 602 39203 .00 2021 BUDGET WORKSHEETS SEWER UTILITY -REVENUES - Description Other State Grants & Aids Administrative Fees-Other Funds Principal -Special Assessments Penalties & Interest -SIA Interest Earnings -Investments Net Change in FV-lnvestments Interest Earnings Other Revenues Use of Reserve Funds Residential Sewer Revenues Apartment Sewer Revenues Institutional Sewer Revenues Commercial Sewer Revenues Industrial Sewer Revenues Penalties -Sewer Revenues Gain or Loss from F/A Disposal Transfer From FUND TOTALS 2017 Actual $0 5,069 75,330 723 21 ,939 (8 ,755 ) 411 0 0 1,520,830 134 ,668 27 ,594 76,385 88,461 13,768 (4 ,159) 0 2018 Actual $0 11 ,796 75 ,927 133 21 ,667 (2 ,081) 1,074 58 0 1,527 ,302 145 ,502 27 ,319 86 ,942 100,300 15 ,175 0 0 2019 Actual $712 9,327 74,262 976 35 ,973 9,532 2,454 0 0 1,462,480 185,515 30 ,960 104 ,954 153,486 15 ,648 0 0 2020 Adopted Budget $0 6,300 80 ,000 0 18 ,000 0 200 0 528,800 1,600 ,000 150 ,000 30 ,000 90,000 110 ,000 14 ,000 0 0 2021 Object Detail Amount 2021 Proposed Budget $0 6,300 75,000 0 20 ,000 0 1,000 0 417 ,300 1,600 ,000 190 ,000 35 ,000 110,000 160,000 15,000 0 0 ---------------------------------------------------------------------------------------------------- $1 ,952,265 $2,011 ,115 $2 ,086 ,280 $2 ,627 ,300 $2 ,629,600 ===::::===== ========= ========= ========= --------========= Comments 5% of 5% Fees-Const Projects Annual Market Value Changes Page One August4,2020 Accou nt# 2021 BUDGET WORKSHEETS SEWER UTILITY -EXPENDITURES - Description 602 49450 101 .00 Salaries & Benefits 602 49450 77 101 .00 Administrative 602 49450 78 101 .00 Technical /C lerical 602 49450 79 101 .00 Maintenance 602 49450 xx 101 .00 Salary & Benefit Contingency 602 49450 102 .00 Full-Time Overtime 602 49450 103 .00 Part-Time Salaries & Benefits 602 49450 99 10 3.xx Utility Commission Wages (1/3) 602 49450 99 103.xx Maintenance Labor 602 49450 01 203 .00 Printed Forms & Paper 602 49450 01 205 .00 Plotter Ink & Paper 602 49450 01 209 .00 Other Office Supplies 602 49450 01 212 .00 Motor Fuels 602 49450 01 216 .00 Chemicals & Chemical Products 602 49450 01 219 .00 Other Operating Supplies 602 49450 01 224 .00 Street Maintenance Materials 602 49450 01 225 .00 Landscaping Materials 602 49450 01 227 .00 Utility System Maintenance Suppliei 602 49450 01 240 .00 Safety Equipment & PPE 602 49450 01 241 .00 Small Tools 602 49450 01 242 .00 Minor Equipment 602 49450 01 303 .00 Engineering Fees 602 49450 01 303 .01 GIS 602 49450 01 303.02 Rate Study 602 49450 01 303 .04 Miscellaneous 602 49450 01 312 .00 Gopher State One-Call 602 49450 01 313 .00 Outsource Bill Printing/Mailing 602 49450 01 318 .00 Contract Engineer 602 49450 01 319 .00 Other Professional Services 602 49450 01 319 .01 Televising 602 49450 01 319 .02 Root Control 602 49450 01 319 .03 Supervisory Controls(Maint Cont ) 602 49450 01 319 .04 Lift Station Inspection 602 49450 01 319 .05 Landscape Maintenance 602 49450 01 320 .00 Credit Card Activity Fees 602 49450 01 321 .00 Telephone Costs 602 49450 01 322 .00 Postage Costs 602 49450 01 323 .00 Radio Units 602 49450 01 365 .00 Workers Comp Insurance 602 49450 01 369 .00 Other Insurance 602 49450 01 39 1.00 P .C. Maintenance 602 49450 01 391 .01 U/B Software Maintenance 602 49450 01 391 .02 Auto Read Software Support 602 49450 01 392 .00 P .C . Accessories & Supplies 602 49450 01 393 .00 P .C . Hardware Purchases 602 49450 01 394.00 P .C . Software Purchases 602 49450 01 394 .01 Licensing & Maintenance 602 49450 01 394 .02 Online Subscriptions 602 49450 01 394 .03 New Software Purchases 602 49450 01 395 .00 P.C . Repairs 602 49450 01 403 .00 602 49450 01 415 .00 602 49450 01 416 .00 602 49450 01 433 .00 602 49450 01 435 .00 602 49450 01 437 .00 602 49450 01 437 .01 602 49450 01 437 .03 602 49450 01 437 .04 602 49450 01 439 .00 Contracted R & M -Other lmpr Other Equ ipment Rental Machinery Rental Dues & Subscriptions Books & Pamphlets Conferences & Seminars MPCA Training (Sewe r School) CarteGraph, ESRI , GIS Miscellaneous Training Other Miscellaneous Cha rges 602 49450 01 521 .00 Building & Structure Purchases 602 49450 01 530 .00 Improvements Other Than Bldgs 602 49450 01 530 .01 Miscellaneous Improvements 602 49450 01 530 .03 CRP of Sewermain 602 49450 01 540 .00 Heavy Machinery Purchases 602 49450 01 550 .00 Motor Vehicle Purchases 602 49450 01 560 .00 Furn iture & Fixture Purchases 602 49450 01 570 .00 Office Equ ipment Purchases 602 49450 01 580 .00 Other Equipment Purchases PAGE TOTALS 2017 Actual 129 ,578 146 ,843 171 ,054 0 10 ,140 7 ,346 504 0 114 5,200 0 418 1,743 0 2 ,132 0 701 2,551 2,476 0 143 1,683 0 22 ,602 0 0 0 0 0 6 ,064 3,085 4 ,002 5,777 12 ,175 13 ,858 2,177 631 0 0 10,129 234 0 0 28,476 0 1,428 0 0 920 131 160 106 0 0 0 0 11,436 0 0 0 606 ,017 2018 Actual 202,742 155 ,870 180 ,248 0 13 ,549 7,803 1,092 0 198 5,100 98 147 2,010 0 1,443 0 486 3,758 78 7 ,074 13 ,5 23 1,436 2,201 0 51,859 0 0 0 0 7 ,767 3,540 2,881 6 ,082 13,482 12,322 2,159 650 0 1,967 8,954 234 0 0 32 ,014 0 400 49 0 1,193 607 400 85 0 0 0 0 0 0 0 24,754 770 ,255 2019 Actual 154,976 169,268 183 , 175 0 16,444 8,479 0 0 25 3,100 0 549 2,113 0 1,894 0 635 2,741 0 34,043 13,569 1,794 6 ,618 0 56,634 0 818 0 0 9,409 3,819 310 6 ,282 13 ,717 11 ,006 2,372 650 0 361 9,715 0 983 0 11 ,769 0 518 127 0 803 0 496 126 0 7,695 0 4 ,538 43,090 0 0 0 2020 Adopted Budget 149 ,900 177 ,900 230 ,600 0 7 ,500 8 ,700 100 400 200 3,100 500 200 2,500 400 5,000 500 1,000 3,000 1,000 5,000 5,000 2,500 8,300 0 53 ,000 2 ,000 5,000 0 1,500 8,500 5,000 400 7,100 12 ,000 17 ,000 2,200 700 200 3,000 10 ,500 300 200 0 70 ,000 200 2,000 300 300 2,500 500 1,000 300 0 200 ,000 150 ,000 0 4,700 500 500 0 784 ,663 1,174 ,700 2021 Object Detail Amount 175,400 2021 Proposed Budget Comments All Salary Costs Inclusive of $541,500 Salary , Taxes , PERA & Benefits 198 ,800 Added PfT GIS Technician 167 ,300 700 0 7,500 8,700 8,000 Seasonal Employees and Interns 1,000 0 5,000 53 ,000 2 ,000 5 ,000 3,500 1,500 2,200 700 10 ,500 300 200 2,500 500 1,000 300 ,000 150 ,000 100 400 200 3,100 500 200 2,500 400 5,000 500 1,000 4,000 6,000 2,500 8,300 0 65 ,000 9,500 5,000 400 1,000 12,000 17 ,000 2,900 200 3,000 11 ,000 0 70,000 200 2,000 300 300 4 ,000 300 0 450 ,000 0 4,700 500 500 0 1.252 ,200 Outsource Bill Printing (313 .00) 2% Covered by Sewer Util ity Root Killer, Degreaser Patching Topsoil , Seed & Sod MH Castings Stock Vests, Glasses, Hardhats , etc . Wrenches, Shovels , etc . Locator in 2021 $5,000 Split 5 Ways $7,500 Split 3 Ways 3-Year Citywide Televising Program SCADA System Pump Inspection at All Lift Stations At Lift Stations 1/3 Cost of CIC Pymt Processing Cell Phones, Modems, GPS Outsource Mailing (313 .00 ) Sewer's Share of Premiums Sewer's Share of Premiums Added to Utility Budgets in 2012 Added to Utility Budgets in 2012 $1 ,100 Intern GPS ($3,300 shared) ESRI , Cartegraph , Datalink Pictom etry MH Castings Replacement Program SUSA Split w/603 Reference Materials Operator Licensure $400 each (M) User Group, Conference, Training Contingencies Final Payment in 2018 SCADA, PCL's , 2 US Ca binets.Birge PMP Sewe r Imp. When Needed Jetter (Split with 603) Vehicle Leases Portable Generator (Split 3 Ways) Page Two 202 1 BUDG ET WORKSHEETS SEWER UTILITY -EXPEND ITURES - August 4 , 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 602 49450 01 602 .00 Sewer Service Charges 1,284 ,544 1,300 ,125 1,303 ,112 1,390,000 1,311,700 MWCC Chgs (Matches Rate Model) 602 49450 01 611 .00 Interest on Lease Payments 930 476 0 0 0 P.W. Building Expansion(See 521) 602 49450 01 710 .00 Transfers 0 65 ,000 0 0 0 Transfers for Other Improvements --------------------------------------------------------------------------------------------------- 602-49450-01 TOTALS 1,891,491 2, 135 ,856 2,087,775 2 ,564 ,700 2,563 ,900 602 49451 01 219 .00 Other Operating Supplies 0 0 0 100 3,200 Second Bubbler 602 49451 01 221 .00 Equipment Parts 0 0 760 800 800 602 49451 01 229 .00 Other Maintenance Supplies 0 0 0 200 200 602 49451 01 303 .00 Engineering Fees 0 0 0 0 0 602 49451 01 381 .00 Electric Utilities (0) 1,500 2,750 3,000 3,000 602 49451 01 403 .00 Contracted R & M -Other lmpr 53 ,524 0 0 2,000 2,000 602 49451 01 439 .00 Other Miscellaneous C harges 0 0 0 100 100 ---------------------------------------------------------------------------------------------------- (City Hall) TOTAL -LI FT STATION #1 53,524 1,500 3,510 6,200 9,300 602 49452 01 219 .00 Other Ope rating Supplies 0 0 0 100 100 602 49452 01 221 .00 Equipment Parts 2,024 0 3,361 800 800 602 49452 01 229 .00 Othe r Maintenance Supplies 0 0 0 200 200 602 49452 01 381 .00 Electric Utilities 508 540 417 700 700 602 49452 01 403 .00 Contracted R & M -Oth er lmpr 0 412 471 2,000 2,000 602 49452 01 439 .00 Other Miscellaneous Charges 0 0 0 100 100 Con tingencies ---------------------------------------------------------------------------------------------------- (Bloomfield 5th ) TOTAL -LIFT STATION #7 2,531 952 4 ,249 3,900 3,900 602 49453 01 219 .00 Other Operating Supplies 0 0 0 100 100 602 49453 01 221 .00 Equipment Parts 2,439 0 3,694 800 800 602 49453 01 229 .00 Othe r Maintenance Supplies 0 0 0 200 200 602 49453 01 381 .00 Electric Utilities 3,464 3,393 3,572 4,000 4,000 602 49453 01 403 .00 Contracted R & M -Other lmpr 0 13,482 27,983 2,000 2,000 Safety Improvements in 2018 602 49453 01 439 .00 Other Miscellaneous Charges 0 0 568 100 100 Contingencies --------------------------------------------------------------------------------------------------- (Shannon Pond) TOTAL -LIFT STATION #3 5,903 16 ,874 35 ,817 7,200 7 ,200 602 49454 01 219 .00 Other Operating Supplies 0 0 0 100 100 602 49454 01 221 .00 Equipment Parts 0 0 0 800 800 602 49454 01 229 .00 Other Maintenance Supplies 0 0 0 200 200 602 49454 01 381 .00 Electric Utilities 5,632 5,583 5,612 6,000 6,000 602 49454 01 403 .00 Contracted R & M -Other lmpr 0 0 142 2,000 2 ,000 602 49454 01 439 .00 Other Miscellaneous Charges 0 0 0 100 100 Conti ngencies ---------------------------------------------------------------------------------------------------- (Hawkins) TOTAL -LIFT STATION #4 5,632 5,583 5,754 9,200 9,200 602 49455 01 219 .00 Other Operating Supplies 0 0 0 100 100 602 49455 01 221 .00 Equipment Parts 376 2,611 0 800 800 602 49455 01 229 .00 Ot her Maintenance Supplies 0 0 0 200 200 602 49455 01 303 .00 Engineering Fees 0 0 0 0 0 602 49455 01 310 .00 Testing Services 0 0 0 0 0 602 49455 01 381 .00 Electric Utilities 5,225 5,418 5,062 6 ,000 6 ,000 602 49455 01 403 .00 Contracted R & M -Other lmpr 398 3,109 2 ,658 2,000 2 ,000 602 49455 01 439 .00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (LeForet Add'n) TOTAL -LI FT STATION #5 5,998 11,139 7 ,720 9,200 9 ,200 602 49456 01 219 .00 Other Operating Supplies 0 0 0 100 100 602 49456 01 221 .00 Equipment Parts 0 0 0 800 800 602 49456 01 229 .00 Other Maintenance Supplies 0 0 0 200 200 602 49456 01 381 .00 El ectric Uti lities 6 ,170 4 ,710 6 ,360 6 ,000 6,000 602 49456 01 403 .00 Contracted R & M -Other lmpr 0 0 415 2,000 2 ,000 602 49456 01 439 .00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ------------------------------------------------------------------------------------------------- (Orumcliffe ) TOTAL -LIFT STATION #6 6 ,170 4,710 6,775 9,200 9 ,200 Page Three August 4 , 2020 Account# 602 49457 01 219 .00 602 49457 01 221 .00 602 49457 01 229 .00 602 49457 01 381 .00 602 49457 01 403 .00 602 49457 01 439 .00 (G lendalough 5th) 602 49458 01 219 .00 602 49458 01 221 .00 602 49458 01 229 .00 602 49458 01 381 .00 602 49458 01 403 .00 602 49458 01 439 .00 {Meadows of ) (Bloomfield ) 602 49460 01 219 .00 602 49460 01 221 .00 602 49460 01 229 .00 602 49460 01 381 .00 602 49460 01 40 3.00 602 49460 01 439 .00 {Glen Rose ) 602 49461 01 219 .00 602 49461 01 221 .00 602 49461 01 229 .00 602 49461 01 381.00 602 49461 01 403 .00 602 49461 01 439 .00 (Meadow Ridge-Temp) 602 49462 01 219 .00 602 49462 01 221 .00 602 49462 01 229 .00 602 49462 01 381 .00 602 49462 01 403 .00 602 49462 01 439 .00 {Bella Vi sta 6th-Temp) 2021 BUDGET WORKSHEETS SEWER UTILITY -EXPENDITURES - Description Other Operating Supplies Equipment Parts Othe r Maintenance Supplies Electric Utilities Contracted R & M -Other lmpr Other Miscellaneous Charges TOTAL -LIFT STATION #9 Other Operating Supplies Equipment Parts Other Maintenance Supplies Electric Utilities Contracted R & M -Other lmpr Other Miscellaneous Charges TOTAL -LIFT STATION #8 Other Operating Supplies Equ ipment Parts Other Maintenance Supplies Electric Utilities Contracted R & M -Other lmpr Other Miscellaneous Charges TOTAL -LIFT STATION #10 Other Operating Supplies Equipment Parts Other Maintenance Supplies Electric Utilities Contracted R & M -Other lmpr Other Miscellaneous Charges TOTAL -LIFT STATION #11 Other Operating Supplies Equipment Parts Other Maintenance Supplies Electric Utilities Contracted R & M -Other lmpr Other Miscellaneous Charges TOTAL -LIFT STATION #12 GRAND TOTAL -ALL DEPTS . 2017 Actual 0 628 0 1,350 0 0 2018 Actual 3,170 2,707 0 1,427 1,605 0 2019 Actual 0 12 0 1,371 5,410 0 2020 Adopted Budget 100 500 200 1,200 2,000 100 2021 Object Detail Amount 2021 Proposed Budget 100 500 200 1,20 0 2,000 100 ---------------------------------------------------------------------------------------------------- 1,979 8,909 6 ,793 4 ,100 4 ,100 0 0 0 100 100 1,395 0 0 500 500 0 0 0 200 200 460 461 421 800 800 1,414 0 0 2,000 2 ,000 0 0 0 100 100 ------------------------------------------------------------------------------------- 3,270 461 421 3,700 3,700 0 0 0 100 100 0 0 0 500 500 0 0 0 200 200 266 325 339 400 400 0 0 0 2,000 2,000 0 0 0 100 100 ------------------------------------------------------------------------------------------------- 266 325 339 3,300 3,300 0 0 0 100 100 0 0 0 500 500 0 0 0 200 200 0 0 0 400 400 0 0 0 2 ,000 2 ,000 0 0 0 100 100 -------------------------------------------------------------------------------------------------- 0 0 0 3,300 3,300 0 0 0 100 100 0 0 0 500 500 0 0 0 200 200 0 0 0 400 400 0 0 0 2,000 2,000 0 0 0 100 100 --------------------------------------------------------------------------------------------------- 0 0 0 3,300 3,300 $1 ,976 ,766 $2 ,1 86 ,309 $2 , 159 , 154 $2,627 ,300 $2 ,629 ,600 ========= ========= ========= ========= ========= Comments Bubbler in 2018 Contingencies Contingencies Contingencies Contingencies Contingencies Page One August 4 , 2020 Account# 603 33400.00 603 33425 .00 603 33620 .00 603 34108 .00 603-34115 .00 603 36101 .00 603 36102 .00 603 36210 .00 603 36214 .00 603 36215 .00 603 36260 .00 603 36262 .00 603 36265 .00 603 37300 .00 603 37360.00 603 39103 .00 603 39203 .00 2021 BUDGET WORKSHEETS STORM WATER UTILITY -REVENUES - Description State Grants & A ids Other State Grants & Aids Other County Grants & Aids Adm inistrative Fees-Other Funds Buffer Monumentation Principal -Special Assessments Penalties & Interest -SI A Interest Earnings -Investments Net Change in FV-lnvestments Interest Earnings Other Revenues Special Settlements Use of Reserve Funds Storm Water Utility Revenues Penalties -Storm Water Utility Gain or Loss from F/A Disposal Transfer From FUND TOTALS 2017 Actual $0 0 0 5,069 0 28 ,871 155 46 ,134 (3 ,777 ) 309 0 0 0 1,289,374 10,471 0 0 2018 Actual $0 0 0 11 ,796 0 25 ,339 157 77,293 (2,708) 857 29 0 0 1,267,924 11,627 0 0 2019 Actual $596 0 125 9,327 1,800 23,418 366 126,227 (2 ,944) 3,826 0 0 0 1,295 ,790 6 ,272 0 492,427 2020 Adopted Budget $0 0 0 6 ,300 3,000 25 ,000 0 35 ,000 0 300 0 0 0 1,500 ,000 7 ,000 0 0 2021 Object Detail Amount 2021 Proposed Budget $0 0 0 6 ,300 2,000 25 ,000 0 40 ,000 0 1,000 0 0 0 1,740,000 7,000 0 0 ----------------------------------------------------------------------------------------------------- $1 ,376,605 $1 ,392 ,314 $1,957 ,229 $1 ,576 ,600 $1,821 ,300 ========= ========= ========= ========= ========= ======::::== Comments 5% of 5% Fees-Const Projects Annual Market Value Changes 4% Ann ual Rate Iner. (Rate Model) Page One 2021 BUDGET WORKSHEETS STORM WATER UTILITY -EXPENDITURES - August4 ,2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusiv e of 603 49500 101 .00 Salaries & Benefits $511 ,100 Salary , Taxes, PERA & Benefits 603 49500 77 101 .00 Administrative 21 ,9 66 77 ,299 153,628 136,400 174 ,900 603 49500 78 101 .00 Technical/Clerical 84,524 89 ,040 196,702 229 ,800 228,200 Added PIT GIS Tec hnician 603 49500 79 101 .00 Maintenance 98 ,552 107 ,093 110,285 157,500 108,000 603 49500 xx 101 .00 Salary & Benefit Contingency 0 0 0 0 0 603 49500 102 .00 Full-Time Overtime 5,114 7,705 9,574 6 ,000 6 ,000 603 49500 99 103 .00 Part-Time Salaries & Benefits 7 ,207 8,345 7,596 8 ,700 8 ,700 603 49500 99 103 .xx Utility Commission Wages (1/3) 700 603 49500 99 103 .xx Maintenance Labor 8 ,000 Seasonal Employees and Interns 603 49500 01 203 .00 Printed Forms & Paper 504 1,092 0 100 100 Outsource Bill Printint (313 .00) 603 49500 01 205 .00 Plotter Ink & Paper 0 0 0 400 400 603 49500 01 208 .00 Miscellaneous Supplies 350 86 0 500 500 Stakes, Ribbons , Level , etc. 603 49500 01 212 .00 Motor Fuels 6 ,200 6 ,000 4 ,700 4 ,700 4 ,700 3% Covered by Storm Utility 603 49500 01 224 .00 Street Maintenance Materials 2,140 5,241 1,775 3 ,000 3,000 Patching Material for W ashouts 603 49500 01 225 .00 Landscaping Materials 4,000 603 49500 01 225 .01 Rip-Rap , Matting , Rock, etc . 1,553 973 765 3,000 3,000 603 49500 01 225 .02 Black Dirt, Seed, Sod , etc . 900 945 240 1,000 1,000 603 49500 01 226 .00 Sign Repair Materials 257 160 4,443 3 ,000 3,000 Wetland Buffer Signs 603 49500 01 230 .00 Repair Materials & Supplies 1,359 1,418 1,368 3 ,000 3,000 Culverts , Catch Basins , Structures 603 49500 01 240 .00 Safety Equipment & PPE 0 0 0 500 500 Vests, Glasses, Hardhats, etc . 603 49500 01 241 .00 Small Tools 176 1,211 923 1,500 1,500 603 49500 01 242 .00 Minor Equipment 2 ,238 1,286 2,972 7,500 3,500 Locator in 2021 603 49500 01 303 .00 Engineering Fees 23 ,000 603 49500 01 303 .01 Problem Area Investigations 0 0 0 5,000 5,000 603 49500 01 303 .02 NPDES Phase II 7 ,377 8,202 14 ,197 5,000 5,000 603 49500 01 30303 CSMP Update 0 69 ,832 12 ,965 2,000 2,000 603 49500 01 303 .04 Miscellaneous 10 ,921 34 ,730 45,435 10,000 10 ,000 603 49500 01 303 .05 GIS 1,651 52 0 1,000 1,000 $5 ,000 Split 5 Ways 603 49500 01 304 .00 Legal Fees 0 1,886 34 2 ,000 2 ,000 603 49500 01 310 .00 Testing Services 0 0 0 0 0 Water Quality Tests (M) 603 49500 01 312 .00 Gopher State One-Call 1,684 1,436 1,794 2 ,500 2,500 $7 ,500 Split 3 Ways 603 49500 01 313 .00 Outsource Bill Printing /Mailing 0 2,201 6,618 8,300 8,300 603 49500 01 315 .00 Special Programs 5,86 7 6,437 4 ,500 5 ,000 5,000 WHEP 603 49500 01 318 .00 Contract Engineer 26 ,927 0 0 0 0 603 49500 01 319 .00 Other Professional Services 10,000 603 49500 01 319 .01 SCADA 0 0 4,223 5 ,000 5,000 603 49500 01 319 .02 Lift Station Inspection 0 0 0 0 3,500 Pump Inspection at All Lift Stations 603 49500 01 319 .03 Landscape Maintenance 0 0 0 1,500 1,500 At Lift Stations 603 49500 01 320 .00 Credit Card Activity Fees 6 ,064 7 ,767 9,409 8 ,500 9 ,500 1/3 Cost of CI C Pym! Processing 603 49500 01 321 .00 Telephone Costs 3,086 3,541 4,266 5 ,000 5 ,000 Cell Phones , Modems, GPS 603 49500 01 322 .00 Postage Costs 4 ,002 2,853 310 400 400 Outsource Ma iling (31 3.00) 603 49500 01 323 .00 Radio Units 5,777 6 ,082 6,282 7 ,100 1,000 603 49500 01 352 .00 General Notices & Public Info 35 0 0 1,000 1,000 603 49500 01 365 .00 Workers Comp Insurance 6 ,287 7 ,647 10,255 6 ,000 6 ,000 Storm Water's Share of Premiums 603 49500 01 369 .00 Other Insurance 1,734 1,746 1,814 2 ,500 2,500 Storm Water's Share of Premiums 603 49500 01 391 .00 P .C . Maintenance 2 ,900 603 49500 01 391 .01 U/B Software Maintenance 2,177 2,159 2,372 2,200 2,200 603 49500 01 391 .02 Auto Read Software Support 631 650 650 700 700 603 49500 01 393 .00 P .C . Hardware Purchases 0 1,967 361 3,000 3,000 $1 ,100 Intern GPS ($3 ,300 shared ) 603 49500 01 394 .00 P .C . Software Purchases 11 ,000 603 49500 01 394 .01 Licensing & Maintenance 10 ,119 8,954 9,714 10 ,500 10 ,500 ESRI , Cartegraph , Datalink 603 49500 01 394 .02 On line Subscriptions 234 234 0 300 300 Pictometry 603 49500 01 394 .03 New Software Purchases 0 0 983 200 200 603 49500 01 403 .00 Contracted R & M -Other lmpr 160,000 603 49500 01 403 .01 Ditching 12,609 1,008 0 10,000 10 ,000 603 49500 01 403 .02 Catch Basins, Manholes , Etc . 111 ,199 43 ,322 93 ,304 120,000 150,000 Conley Avenue MH 603 49500 01 403 .03 Pond Inspection & Maintenance 0 0 0 0 0 603 49500 01 405 .00 MS4 Permit Compliance 140 ,000 603 49500 01 405 .0 1 Engineering Fees 38 ,365 31 ,594 43,408 45 ,000 45 ,000 Inspection , GIS , Guidance, Etc . 603 49500 01 405 .02 Equipment Rental 7 ,149 0 72 ,789 20,000 20,000 Bulldozer , Large Equipment 603 49500 01 405 .03 Dirt , Seed , Rip Rap , Etc. 786 0 607 5,000 5,000 For Restoration 603 49500 01 405 .04 Contracted Maintenance 3,97 3 3,030 59 ,671 40 ,000 70 ,000 Brush Clearing , Dredging 603 49500 01 416 .00 Machinery Rental 2,416 0 0 2,500 2 ,500 Pumps 603 49500 01 433 .00 Dues & Subscriptions 280 49 994 1,500 3,200 SUSA w/602 , MN SW Coal , WS Part 603 49500 01 435 .00 Books & Pamphlets 0 0 81 500 500 Utility Information 603 49500 01 437 .00 Conferences & Seminars 3,7 00 603 49500 01 437 .0 1 Storm Water Management 0 0 737 1,200 1,200 Stormwater Collab, Flygt Training 603 49500 01 437 .04 Cartegraph , ESRI , GIS 131 607 0 500 500 User Group, Conference , Training 603 49500 01 437 .05 Miscellaneous Training 0 430 583 2 ,000 2,000 603 49500 01 439 .00 Other Miscellaneous Charges 106 360 421 300 300 ----------------------------------------------------------------------------------------------------- P AGE TOTALS 504 ,625 556 ,668 903 ,747 909 ,800 953 ,300 Page Two August 4 , 2020 Account# 2021 BUDGET WORKSHEETS STORM WATER UTILITY -EXPENDITURES - Description 603 49500 01 530 .00 Improvements Other Than Bldgs 603 49500 01 530 .01 CRP of Storm Sewer 603 49500 01 530 .02 Stormwater System Improvements 603 49500 01 540 .00 Heavy Machinery Purchases 603 49500 01 550 .00 Motor Vehicle Purchases 603 49500 01 560 .00 Furniture & Fixture Purchases 603 49500 01 580 .00 Other Equipment Purchases 603 49500 01 586 .00 Computer Equipment Purchases 603 49500 01 710 .00 Transfers 603 49500 01 710 .06 112 of 2018 P & I Payments(2010 A) 603 49500 01 710 .10 Projects 603-49500-01 TOTALS 603 49511 01 221 .00 Equipment Parts 603 49511 01 381 .00 Electric Utilities 603 4951 1 01 403 .00 Contracted Repair & Maintenance (Copper Pond ) TOTAL -LIFT STATION #1 603 49512 01 221 .00 Equipment Parts 603 49512 01 381 .00 Electric Utilities 603 49512 01 403.00 Contracted Repair & Maintenance (Schwarz Pond) TOTAL -LIFT STATION #2 603 49513 01 221 .00 Equipment Parts 603 49513 01 381 .00 Electric Utilities 603 49513 01 403.00 Contracted Repair & Maintenance (Birger Pond) TOTAL-LIFT STATION #3 603 49514 01 221 .00 Equipment Parts 603 49514 01 381 .00 Electric Utilities 603 49514 01 403 .00 Contracted Repair & Ma intenance (Marcotte Pond ) TOTAL -LIFT STATION #4 603 49515 01 221 .00 Equipment Parts 603 49515 01 381 .00 Electric Utilities 603 49515 01 403 .00 Contracted Repair & Maintenance (Hawkins Pond ) TOTAL -LIFT STATION #5 603 49516 01 221 .0 0 Equipment Parts 603 49516 01 381 .00 Electric Util ities 603 49516 01 403.00 Contracted Repair & Maintenance (Glendalough 7th ) TOTAL -LIFT STATION #6 603 49517 01 221 .00 Equipment Parts 603 49517 01 381 .00 Electric Utilities 603 49517 01 403 .00 Contracted Repair & Maintenance (Horseshoe Lake) TOTAL -LIFT STATION #7 603 49518 0 1 221 .00 Equipment Parts 603 49518 01 381 .00 Electric Utilit ies 603 49518 01 403.00 Contracted Repair & Maintenance (Dunmore ) TOT AL -LIFT STATION #8 GR A ND TOT A L -A LL DEPTS . 2017 Actual 3,704 0 99,350 20 ,226 0 0 0 32,000 381 ,317 1,041 ,222 477 252 202 931 0 0 0 0 0 5,786 0 5,786 0 1,542 0 1,542 0 0 0 0 0 511 0 511 0 753 0 753 0 0 0 0 2018 Actual 0 0 31,714 0 0 24 ,754 81 0 43,887 2019 Actual 0 0 4,538 43 ,070 0 0 0 0 296,254 2020 Adopted Budget 60 ,000 140,000 170 ,500 4,700 500 12 ,000 500 0 0 657 ,105 1,247,609 1,298 ,000 0 0 500 270 312 500 0 1,197 1,000 270 0 0 1,868 1,868 49 6 ,577 0 6 ,626 65 1,178 488 1,731 0 0 0 0 0 416 0 416 0 551 0 551 0 0 0 0 1,508 0 0 140 140 9 8,784 1,477 10 ,269 0 2,008 817 2 ,824 0 0 0 0 144 468 507 1,119 0 992 160 1,152 0 0 0 0 2 ,000 500 500 1,000 2,000 500 7 ,200 1,000 8,700 500 2 ,500 1,000 4 ,000 500 500 1,000 2 ,000 500 500 1,000 2 ,000 500 500 1,000 2 ,000 500 500 1,000 2 ,000 $1 ,050 ,746 $668 ,566 $1 ,264 ,622 $1 ,322,700 2021 Object Detail Amount 60 ,000 200 ,000 0 0 2021 Proposed Budget 260 ,000 170,500 4 ,700 500 12,000 500 0 1,401 ,500 500 Comment s Side Flail Mower , Sw eeper Vehicle Leases Hose Trailer in 2020 Final Payment 211118 500 ------------ 1 ,000 ------------ 2 ,000 500 ------------ 500 ------------ 1, 000 ------------ 2 ,000 500 ------------- 7 ,200 ------------- 1,000 ------------ 8,700 500 ------------- 2 ,500 ------------ 1,000 ------------ 4,000 500 500 1,000 2,000 500 500 1,000 2,000 500 500 1,000 2,000 500 500 1,000 2 ,000 $1,426 ,200 Page One August 4, 2020 Account# 608-310 10.00 608-31020 .00 608-34306 .00 608-36101 .00 608-36102.00 608-362 10.00 608-36215.00 608-36220.00 608-36260.00 608-36265.00 608-36270 .00 608-37400.00 608-37460 .00 608-37470 .00 608-39201 .00 608-39202 .00 608-39203.00 Accou nt# 608 49508 01 219.00 608 49508 01 221.00 608 49508 01 304 .00 608 49508 01 317 .00 608 49508 01 319 .00 608 49508 01 352 .00 608 49508 01 381.00 608 49508 01 409 .00 608 49508 01 421 .00 608 49508 01 439 .00 608 49508 01 530 .00 608 49508 01 710 .00 608 49508 01 720 .00 2021 BUDGET WORKSHEETS STREET LIGHT UTILITY ·REVENUES· Description Current Ad Valore m Taxes Tax Increments Other Highway & Street Revenue State Grants & Aids Other State Grants & Aids Interest Earnings • Investments Interest Earnings Rents & Royalties Other Revenue Use of Reserve Funds Capital Con tributio ns Street Light Revenues Penalties • Street Light Revenues Other Street Light Revenues Transfer from Genera l Fund Contribution from Enterprises Transfer from FUND TOTALS · EXPENDITURES · Description Other Operating Supplies Equipment Parts Legal Fees General Fund Admi n Fees Oth er Professional Services General Notices & Public In fo Electric Utilities Other Contracted Repair & Main!. Depreciation Expense Other Miscellaneous Charges Improvements Other Than Build ings Transfers Transfers FUND TOTALS 2017 Actual $0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2018 Actual $0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20 19 Actual $0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2020 Adopted Budget $0 0 0 0 0 0 0 0 0 0 0 220,000 0 0 0 0 0 2021 Object Detail Amount 2021 Proposed Budget $0 0 0 0 0 0 0 0 0 0 0 220,000 0 0 0 0 0 ---------------------------------------------------------------------------------------------- $0 $0 $0 $220 ,000 $220,000 =:::======= ========= ========= ------------------------ 2021 2020 Object 2021 2017 2018 2019 Adopted Deta il Proposed Actual Actual Actual Budget Amount Budget $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 185 ,000 185,000 0 0 0 15 ,000 15 ,000 0 0 0 0 0 0 0 0 0 0 0 0 0 20 ,000 20,000 0 0 0 0 0 0 0 0 0 0 ------------------------------------------------------------------------------------------------ $0 $0 $0 $220 ,000 $220,000 ========= ;;;:::;::;:;::;:::::::::::::: ========= ------------------------ Comments Comments Page One August 4 , 2020 Account# 650 33425 .00 650 36210 .00 650 36215 .00 650 36230 .00 650 36260 .00 650 36262 .00 650 36265 .00 650 38060 .00 650 38061 . 00 650 38063 .00 650 38065 .00 650 38066 .00 650 38067 .00 650 38090 .00 650 38091 . 00 650 38095 .00 650 39103 .00 650 39201 .00 2021 BUDGET WORKSHEETS ARENA -REVENUES Description Other State Grants & Aids Interest Earnings -Investments Interest Earnings Contributions/Donations Other Revenue -Learn to Skate Special Settlements Use of Reserve Funds Prime Time Ice Fees Non-Prime Time Ice Fees Open Skating Ice Fees Other Events -Arena Advertising Revenue -Arena Skate Sharpening Revenue-Arena Concessions Vending Machine Revenues Pro Shop Revenues Gain or Loss from F/A Disposal Transfer From General Fund FUND TOTALS 2017 Actual $0 571 562 0 35 ,986 0 0 259 ,235 104,404 9,553 0 23,710 2,074 1,500 3,458 1, 138 0 130 ,000 2018 Actual $0 3,393 571 0 38,438 0 0 285 ,718 84 ,953 9,725 0 16 ,707 2,579 1,500 7,880 944 0 130,000 2019 Actual $314 7,378 2,261 0 38 ,284 1,500 0 262 ,934 98 ,480 9,322 0 17 ,625 2,490 1,500 4,719 988 0 130,000 2020 Adopted Budget $0 100 100 0 40 ,000 0 62 ,800 280 ,000 100 ,000 10 ,000 0 20,000 3,500 1,500 5,000 1,500 0 130,000 2021 Object 2021 Detail Proposed Amount Budget $0 100 100 0 40 ,000 0 0 270 ,000 100 ,000 10 ,000 0 20 ,000 3,500 1,500 5,000 1,500 0 130 ,000 ------------------------------------------------------------------------------------------ 572 , 192 582,409 577 ,794 654 ,500 581,700 ======== ======== ======== ======== ======== ======== Co mments Learn to Skate Program (L TS ) Dry Floor Events Tape , Laces , Mouthguards , etc . Subsidy for Operations Page One 2021 BUDGET WORKSHEETS ARENA -EXPENDITURES August 4 , 2020 2021 2020 Object 2021 2017 2018 2019 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs In cl usiv e of 650 45130 101 .00 Salaries & Benefits $210 ,500 Salary , Taxes , PERA & Benefits 650 45130 77 101.00 Admin istrative 42 ,437 56 ,424 38 ,830 37 ,200 38 ,500 650 45130 78 101 .00 Technical/Clerical 44 ,787 45 ,516 56 ,049 58 ,200 60 ,700 650 45130 79 101 .00 Maintenance 85 ,943 95 ,445 94, 123 106,500 111 ,300 650 45130 79 102.00 Full-Time Overtime 832 1,622 62 2 ,000 2,000 650 45130 103.00 Part-Time Salaries & Benefits 53,000 650 45130 89 103.00 Learn-To-Skate Program 23 ,277 21 ,275 22 ,819 23,000 23 ,000 650 45130 99 103.00 Building Attendants 25 ,210 28 ,246 32 ,601 25 ,000 30,000 And Other P/T Positions 650 45130 01 207 .00 Training & Instructional Supplies 0 0 0 100 100 650 45130 01 208 .00 Miscellaneous Supplies 700 650 45130 01 208 .01 Skate Magnets 0 0 0 100 100 650 45130 01 208 .02 Other Supplies 0 0 0 600 600 650 45130 01 209 .00 Other Office Supplies 511 268 34 500 500 Learn to Skate Program Supplies 650 45130 01 211 .00 Cleaning Supplies 4 ,278 3 ,562 3 ,993 4,000 4 ,000 650 45130 01 212.00 Motor Fuels 0 0 0 0 0 Zamboni Maintenance 650 45130 01 216 .00 Chemicals & Chemical Products 11 ,349 6 ,003 2 ,485 10,000 6 ,000 Cooling Tower 650 45130 01 219 .00 Other Operating Supplies 551 394 2 ,284 500 500 Events Supplies 650 45130 01 221 .00 Equipment Parts 7,669 8 ,909 12,030 8 ,000 9 ,000 650 45130 01 223 .00 Building Repair Supplies 2 ,894 3 ,918 583 3 ,500 3 ,500 650 45130 01 265 .00 Other Items for Resale 882 660 1,067 1,000 1,000 Pro Shop Supplies 650 45130 01 305 .00 Medical & Dental Fees 0 0 0 0 0 650 45130 01 311 .00 Officiating Fees 0 0 0 0 0 650 45130 01 317 .00 General Fund Admin Fees 6 ,000 6 ,000 6 ,000 6 ,000 6 ,000 Yearly Fee Per Admin Fee Policy 650 45130 01 321 .00 Telephone Costs 1,000 1,000 1,000 1,300 1,300 650 45130 01 331 .00 Travel Expense 0 0 0 100 100 650 45130 01 341.00 Employment Advertising 0 0 0 0 0 650 45130 01 349 .00 Other Advertising 1,683 1, 123 1,725 1,000 1,000 650 45130 01 365 .00 Workers Comp Insurance 5 ,614 6 ,057 6 ,611 3 ,500 3 ,500 650 45130 01 369 .00 Other Insurance 3 ,752 3 ,745 3 ,782 4 ,500 4 ,500 650 45130 01 381.00 Electric Utilities 129,159 138,462 119,940 130,000 115,000 650 45130 01 383 .00 Gas Utilities 17 ,944 22 ,769 21 ,051 20 ,000 20,000 650 45130 01 384 .00 Refuse Disposal 2,833 2 ,817 2 ,615 3 ,000 3 ,000 650 45130 01 401 .00 Contracted Building Repai rs 8,471 13 ,902 6 ,588 10 ,000 10 ,000 650 45130 01 404 .00 Contracted Mach & Equip Repairs 20,991 26 ,991 20 ,026 23 ,000 23,000 650 45130 01 415 .00 Other Equipment Rental 0 0 0 300 300 650 45130 01 433 .00 Dues & Subscriptions 790 475 475 1,000 1,000 MIAMA & MRPA Dues 650 45130 01 437 .00 Conferences & Seminars 2,051 925 2 ,770 3 ,000 3 ,000 MIAMA & MRPA Seminars 650 45130 01 439 .00 Other Miscel laneous Charges 0 0 0 0 0 Contingencies 650 45130 01 521 .00 Building & Structure Purchases 0 77 ,650 30 ,269 135,000 25 ,000 Lower Level Restrooms 650 45130 01 522 .00 Building & Structure Purchases 0 0 0 29 ,000 65 ,000 Low-E Ceiling 650 45130 01 580 .00 Other Equipment Purchases 83 ,657 25 ,000 0 0 0 650 45130 01 581 .00 Other Equipment Purchases 5 ,595 0 0 0 0 650 45130 01 710 .00 Transfers 3,500 650 45130 01 710 01 Yearly Maintenance 3 ,500 3 ,500 3 ,500 3 ,500 3 ,500 650 45130 01 710 .02 0 0 0 0 0 650 45130 01 710 03 0 0 0 0 0 ------------------------------------------------------------------------------------------ FUND TOTALS 543 ,659 602 ,658 493,314 654 ,400 576 ,000 ======== ======== ======== ======== ======== ========