Loading...
HomeMy WebLinkAbout7.a. 2023 FINAL Budget and Levy Auth EXECUTIVE SUMMARY City Council Regular Meeting: December 6, 2022 AGENDA SECTION: AGENDA ITEM: Establish 2023 Budget and Levy Public Hearings PREPARED BY: Logan Martin, City Administrator AGENDA NO. 7.a. Teah Malecha, Finance Director ATTACHMENTS: 2023 Budget APPROVED BY: LJM RECOMMENDED ACTION: Adopt a Resolution Setting the 2023 General Fund Operating Budget, the 2023 C.I.P. Budgets, the 2023 Insurance Budget, the 2023 Port Authority Operating Levy and the 2022 Levy required by the City of Rosemount. BACKGROUND Staff is pleased to present the 2023 Budget and accompanying documents to the City Council for final approval. This task is one of our largest projects of the year, with effort to craft the Budget beginning in March and continuing through the summer with numerous work sessions and revisions. The budget presented herein is a reflection of that work and a display of the City’s goals and priorities in the coming year. The 2023 Budget shows an increase of 7.62% ($1,177,599) to the Operating Budget, which results in a 5.29% increase ($741,658) in the property tax levy. The impact of this levy increase on a median valued home is projected to be $69 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 by almost 12%, to a rate of 32.32% as compared to 36.95% in 2022. 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 2023, the median value home is estimated to be $384,800, which reflects a 18.88% value growth over last year’s median valued home. These are historically high increases to both data points, and they reflect the lag in which the County’s assessors review properties. The City’s 2023 Tax Capacity Value is increasing by 19.63%, and our median valued home is increasing by rd 18.88%. Rosemount’s Tax Capacity increase is the 3 highest in the County for 2023. Nearly $100 million ($98,261,500) in value was added via new construction, which is a number we expect to continue based on the City’s growth patterns. Historically, from 2014-2023, the City’s tax capacity value has grown by 103.08% ($23,386,505). A summary of key characteristics of the proposed 2023 Budget is shown in the following table: Budget Facts at a Glance Growth of Property Tax Base from ‘22 + 19.63 Avg. value increase on Median-Valued Home + 18.88% Change in General Fund Budgets + $1,177,599 or 7.62% City Tax Increase on Median Valued Home + $69 % Tax Change on Median Valued Home + 5.9% Change in Estimated City Tax Rate - 12.5% (from 36.95% to 32.32%) The budget shows some increased personnel costs reflecting new full-time employees, increased costs for necessary equipment and projects, and anticipated wage and benefit numbers. BUDGET PROCESS The drafting of the 2023 Budget ultimately began with and was inspired by the City Council’s goal setting retreat in February. The goals and five-year strategic initiatives discussed during that process were instrumental in the creating of each department’s budget request. After each department submitted their 2023 request, staff met individually with each Department Head to discuss all requests and receive further explanation as to their necessity. A number of items were removed via those discussions and two drafts were completed internally prior to Council review, along with multiple drafts after Council input. Staff also compiled long-range growth projections in housing, population, and service requirements to generate future budget & levy projections that the Council reviewed during the preparation of this Budget. Finally, as has been the direction in year’s past, staff looked at the overall budget strategically for its overall balance and consistency, effect on taxpayers, and long-term impacts on finances for 2023 and beyond. Our intent was to develop the most conservative budget possible that: (1) is consistent with Council goals (2) is consistent with previous Council direction on levels of service (3) does not weaken the City’s long-range financial outlook (4) is balanced not only between revenues and expenditures, but also is well balanced internally between personnel, equipment, technology, operating needs and capital expenditures th According to state law, the preliminary budget and levy must be adopted by September 30 and the final th budget must be adopted by December 28 after a public hearing. GENERAL FACTORS AFFECTING THE BUDGET Tax Base For the tenth consecutive year, the overall tax base in the community has increased. The overall tax capacity value within the City is estimated to be 19.63% higher in 2023 than it was in 2022. The increase in market value of the median home in Rosemount is 18.88%. State Budget and Legislative Impacts There were no significant changes in State legislation in 2022 impacting the Budget, and there are no levy limits in place for 2023. REVENUES Property taxes fund approximately 72.8% of the General Fund budget. However, there are several other categories of General Fund revenues that are also important to the City. The chart below compares budgeted revenue for several key categories. 2022 Budget 2023 Proposed Change Licenses & Permits $987,100 $1,168,000 + $180,900 Intergovernmental $1,195,500 $1,301,500 + $106,000 Chargers for Services (no SKB) $782,300 $1,062,800 + $280,500 SKB Revenue $375,000 $375,000 + $0 2 Fines & Forfeits $95,000 $96,000 + $1,000 Recreational Revenues $296,400 $313,800 + $17,400 Miscellaneous Revenue $232,500 $201,500 - ($31,000) Non-tax levy revenues generated by the City are projected to increase by 14.06% ($1,484,805) in 2023, which is a direct reflection of the growth in the City that is underway and anticipated in 2023. Licenses and Permits (fees generated by growth and construction activities) are the most direct reflection of that trend, and they are projected to increase by 18.33%. As discussed in previous years, staff aims to take an accurate yet conservative approach when anticipating this revenue, due to the volatility that occurs in the development market. With the expected submittal of residential and commercial projects in 2023, revenues received could likely outpace these estimates. This revenue forecast is based on a target goal of 250 new units of housing in 2023. Staff projects revenues from rental of facilities and participation in recreation activities to continue to rebound to pre-pandemic averages. EXPENDITURES Salaries Rosemount currently has 96 full-time employees (FTE), which compares with 81 FTE at the beginning of 2008. New FTEs are reflected in the Community Development Department and the Police Department. This Budget shows a police officer added on January 1, and a Building Inspector added on June 1. The contracts for all four labor bargaining units expire at the end of 2023, so contract negotiations will affect the 2024 Budget. Health Insurance Staff has received final quotes from our Health Insurance broker for 2023. After receiving an initial renewal rate of a 12.43% increase, the team negotiated a final renewal amount of an 8.87% increase. This increase amount was within our anticipated budgetary amount for 2023, so no changes to the budget were required. Capital Budgets The City currently has three capital improvement program (CIP) funds: Equipment, Streets, and Buildings. The Council will review the CIP Budgets at a work session this fall. The levy for the Equipment CIP is proposed to be $900,000, an increase of $56,800 due to projected equipment needs. The Street CIP is proposed to have a levy of $959,302, an increase of $27,941to account for upcoming the growth of the City’s roadway network. Enterprise Fund Budgets Proposed water, sewer and storm water utility rates and budgets have been reviewed by the Utility Commission and are reflected within the Enterprise Fund Budgets, as presented. Water utility rates are proposed to increase by 5%, or about $0.09 per usage tier for a residential user. Sewer rates are significantly driven by the fees charged to the City by Met Council. Sewer utility rates are proposed to increase 6% or about $0.50 per 1000 gallons. Storm Sewer rates are also proposed to increase by 5%. These changes are reflected in the 2023 Budget but will be discussed in greater detail during the Fee Schedule review on December 20. 3 Departmental Review A summary of each Department’s budgetary changes for next year is shown below. City Council Initiative Increase/(Decrease) over ‘22 Budget Adjustments to items allocated to CC budget N/A ($147,000 reallocated to other funds) Administration This category includes Elections, Administration, and the General Government budgets. Initiative Increase over ‘22 Budget New website features (CitiBot, Civic Plus features) $7,000 Finance Initiative Increase over ‘22 Budget Increased software and hardware costs $11,000 Community Development Initiative Increase over ‘22 Budget 1 new FTE Building Inspector (hired June 1) $60,000 Outsource certain minor building inspection duties to a $14,200 third-party contractor Police Initiative Increase/(Decrease) over ‘22 Budget Increased criminal Prosecution fees with new firm $36,000  Agreed to a rate cap of $120K for year, based on st our 1 year experience with firm Implement Data Analytics software for investigations $7,000 Reduction in DCLEA Membership fee ($23,000) Membership in Criminal Justice Information Integration $14,000 Network (CJIIN) 1 new FTE Police Officer (hired Jan. 1) $105,000 Fire Initiative Increase over ‘22 Budget Creation of Battalion Chief model to prepare for $3,000 succession planning Add’l Bunker Gear for employee safety $27,400  Reduces carcinogen exposure by ensuring clean gear after fire event 4 Public Works This category includes Gov’t Buildings, Fleet Maintenance, Street Maintenance, and Parks Maintenance budgets. Initiative Increase over ‘22 Budget Add’l costs for janitorial services with outside vendor $9,600 due to price increases Add’l funds for ice pre-treatment (brine) due to new $10,000 system implementation Add’l funds for sealcoat / crack sealing of City streets $30,000 Emerald Ash Borer response program cost increases $5,000 Add’l fertilizer and weed control with new parks $10,000 Field dry and chalk for new fields (UMore / Flint) $5,000 Parks and Recreation Initiative Increase/(Decrease) over ‘22 Budget Reduced costs for snow removal at Steeple Center ($11,000) Port Authority Initiative Increase over ‘22 Budget Increased expenditures for Home Expo (offset by $4,000 revenue) RECOMMENDATION Staff recommends the City Council adopt a resolution setting the 2023 General Fund Operating Budget, the 2023 C.I.P. Budgets, the 2023 Insurance Budget, the 2023 Port Authority Operating Levy and the 2022 Levy. 5 CITY BUDGET REPORT 2023 City of Rosemount  2023 Adopted Budget  Table of Contents  Elected and Appointed Officials .............................................................................................................................. 2  Final Budget Submission ......................................................................................................................................... 3  Preliminary Budget Submission .............................................................................................................................. 6  Tax Rate Comparison ............................................................................................................................................ 11  General Fund Budget Overview ............................................................................................................................ 14   Estimated Tax Impacts .......................................................................................................................................... 19   General Fund Revenues ........................................................................................................................................ 21  General Fund Expenditures .......................................................................................................................................  City Council ............................................................................................................................................... 24   Administration .......................................................................................................................................... 26   Elections .................................................................................................................................................... 32  Finance ...................................................................................................................................................... 34  General Government ................................................................................................................................ 40   Community Development ......................................................................................................................... 43  Police ......................................................................................................................................................... 48  Fire ............................................................................................................................................................ 58   Public Works ......................................................................................................................................................... 65   Parks & Recreation ................................................................................................................................................ 76   Transfers ............................................................................................................................................................... 83   Capital Improvement Plan (CIP) ............................................................................................................................ 85   Building CIP ............................................................................................................................................... 86   Street CIP................................................................................................................................................... 87   Equipment CIP ........................................................................................................................................... 88    Insurance ............................................................................................................................................................... 90   Port Authority ....................................................................................................................................................... 92   Debt Service Funds ............................................................................................................................................... 96   Utility Funds ...............................................................................................................................................................  Water .......................................................................................................................................................106   Sewer ...................................................................................................................................................... 111  Storm Water ............................................................................................................................................ 115   Street Lights ............................................................................................................................................ 119   Ice Arena ............................................................................................................................................................. 121   1 City of Rosemount, Minnesota  2023 Annual Budget  Elected Officials  Mayor William Droste  Council Member Paul Essler  Council Member Heidi Freske  Council Member Jeff Weisensel  Council Member Vacant  Appointed Officials  City Administrator Logan Martin  Finance Director Teah Malecha  Assistant City Administrator Emmy Foster  Police Chief Mikael Dahlstrom  Public Works Director Nick Egger  City Engineer Brian Erickson  Community Development Director Adam Kienberger  Fire Chief Richard Schroeder  Parks & Recreation Director Dan Schultz  Boards & Commissions  Parks & Recreation Commission Planning Commission  James Bonkoski Kevin Herbert   John DeBettignies Melissa Kenninger  Michael Eliason Brent Marlow  Emily Grossman Michael Reed  Scott McDonald Brenda Rivera  Andrea Schaap John Powell  David Speich Mythili Thiagarajan  James Young  Sharry Angell  Port Authority Environment & Sustainability  William Droste Kristen Andrews  Paul Essler Tina Angerer  Heidi Freske Renee Burman  Cory Ober Eric Johnson  Jeff Weisensel Erin Delaney  Dan Wolf Neil Shoe  Vacant Victoria Schlautman  Utility Commission  Vanessa Demuth  Greg Johnson  Laura Miller  2 CITY OF ROSEMOUNT DAKOTA COUNTY, MINNESOTA RESOLUTION 2022 - 156 A RESOLUTION APPROVING THE 2023 GENERAL FUND OPERATING BUDGET, THE 2023 CAPITAL IMPROVEMENT PROGRAM (CIP) BUDGETS, THE 2023 INSURANCE BUDGET, THE 2023 PORT AUTHORITY OPERATING LEVY AND THE 2023 LEVY REQUIRED BY THE CITY OF ROSEMOUNT WHEREAS, the City Council of the City of Rosemount has determined that budgets and special needs for the year 2023 will be in the amount of $26,815,039 for the General Operating Fund, the three CIP Funds, the Insurance Fund, the Port Authority Fund and the Enterprise Funds; and WHEREAS, the City Council has determined that special levies for Bonded Indebtedness total $183,803 for 1 City issue (G.O. Capital Improvement Plan Refunding Bonds 2015B) and no levy is necessary for any other City issues (utilizing other revenue sources); and WHEREAS, the City Council has determined that actual incomes, fund transfers and anticipated aids will total $12,047,035; and WHEREAS, the City Council has determined the budget for the Arena Fund to be $546,150; and WHEREAS, the City Council has received the Port Authority and the Utility Fund budgets approved by the Rosemount Port Authority and the Utility Commission. NOW, THEREFORE BE IT RESOLVED, that the total levy certified to the Dakota County Auditor shall be $14,768,004; and BE IT FURTHER RESOLVED, that the City Council approves the 2023 General Fund operating budget as presented to them at the Public Hearing held this evening; and BE IT FURTHER RESOLVED, that the City Council approves the three 2023 CIP Fund budgets, the 2023 Insurance Fund budget, the 2023 Port Authority operating levy and the 2023 Arena Fund budget as presented to them at the Public Hearing held this evening. ADOPTED this 6th day of December, 2022. _____________________________ William H. Droste, Mayor ATTEST: __________________________ Erin Fasbender, City Clerk 3 Finance Director 651‐322‐2031 teah.malecha@rosemountmn.gov Title Phone Number Email Authorization I, the authorized representative of the above mentioned Governmental Agency, certify that the foregoing information is  accurate to the best of my knowledge. 12/7/2022 Signature of Authorized Representitive Date FUND NUMBER: The fund number identifies your district levy category ‐ the fund number will auto populate after you select  the expenditure from the levy category list. LEVY CATEGORY:  The levy category lists all the common levies throughout the taxing districts. Any levy that is not specifically  identified should be included in the miscellaneous levy category. BUDGET: Enter the approved expenditure levy amount that is stated on your budget resolution.  LGA: Enter "Local Government Aid" as a negative amount; LGA is a property tax relief that can be used to reduce any lawful  expenditure. OTHER RESOURCES: Enter other resources as negative amount to reduce your approved levy. Examples of other resources  include other aids, interest income, prior year reserves, grants, etc.  FINAL CERTIFIED LEVY: The final certified levy is the estimated figures that will be entered into Dakota County tax rolls.  Dakota County Property Taxation will deduct Fiscal Disparities from all certified levies. TOTAL CERTIFIED FINAL LEVY 26,815,039 0 (12,047,035)$   14,768,004 100.00% TOTAL MKT VALUE REFERENDUM LEVY 000 ‐$ 0.00% Total Certified Final Levy TOTAL TAX CAPACITY LEVY 26,815,039 0 (12,047,035)$   14,768,004 100.00% 0.00% Market Value Referendum Based Levy blank ‐ Select Levy Account ‐0 ‐$ 0.00% blank ‐ Select Levy Account ‐0 ‐$  0.00% blank ‐ Select Levy Account ‐0 ‐$ 0.00% blank ‐ Select Levy Account ‐0 ‐$  3000 REVENUE 26,631,236 (12,047,035)$   14,584,201 98.76% 1.24% blank ‐ Select Levy Account ‐0 ‐$ 0.00% 3001 DEBT SERVICE 183,803 183,803$         Fund Number Levy Category Budget LGA Other  Resources Final Certified Levy % of Levy Tax Capacity Based Levy FORM C ‐ FINAL LEVY CERTIFICATION Submit District Resolution with Levy Form ‐ Final Levy Cannot Exceed the Proposed Levy fgdf Deadline:December 28, 2022 Payable Year:2023 Taxing Dist Name:ROSEMOUNT Entity Number:011000 4 2022 GENERAL PROPERTY TAX LEVY PAYABLE 2023 GENERAL LEVY GENERAL FUND BUILDING CIP FUND $12,103,999 $0 STREET CIP FUND $959,302 EQUIPMENT CIP FUND $900,000 INSURANCE FUND $450,000 PORT AUTHORITY OPERATING LEVY $170,900 ------------------------- TOTAL GENERAL LEVY $14,584,201 BONDED INDEBTEDNESS G.O. IMPROVEMENT BONDS 2014A G.O. CAPITAL IMPROVEMENT PLAN (CIP) REFUNDING BONDS 2015B G.O. IMPROVEMENT BONDS 2017A - 2023 Final Pay Year G.O. IMPROVEMENT BONDS 2018A G.O. PORT AUTHORITY 2022A TOTAL BONDED INDEBTEDNESS GRAND TOTAL 2022 PROPERTY TAX LEVY $0 $183,803 $0 $0 $0 ------------------------- $183,803 ------------------------- $14,768,004 ============== 5 DEADLINE:PAYABLE YEAR: 55068 ZIP Code 55068 ZIP Code Rosemountmn.govEmail or Website Address: 9/6/2022 Authorization 2875 145th Street Rosemount Signature of Authorized Representitive Date 011000 Public Meeting Information September 30, 2022 Phone Number:651‐322‐2031 Teah Malecha Address: Truth in Taxation Contact Information (this information will appear on the proposed tax statement) Address: Street City Name: 2875 145th Street Rosemount 2023 Title:Finance Director FORM A ‐ PUBLIC MEETINGS & TRUTH IN TAXATION CONTACT INFORMATION ROSEMOUNT Street City Taxing District Name: Entity Number: Public Meeting Date: Time of Meeting: Place of Meeting:City of Rosemount 7:00 PM Tuesday, December 6, 2022 6 LEVY CATEGORY:  The levy category lists all the common levies throughout the taxing districts. Any levy that is not specifically  identified should be included in the miscellaneous levy category. ‐$  0.00% 0 Finance Director 651‐322‐2031 teah.malecha@rosemountmn.gov Title Phone Number Email Authorization I, the authorized representative of the above mentioned Governmental Agency, certify that the foregoing information is  accurate to the best of my knowledge. 9/6/2022 Signature of Authorized Representitive Date BUDGET: Enter the approved expenditure levy amount that is stated on your budget resolution.  LGA: Enter "Local Government Aid" as a negative amount; LGA is a property tax relief that can be used to reduce any lawful  expenditure. OTHER RESOURCES: Enter other resources as negative amount to reduce your approved levy. Examples of other resources  include other aids, interest income, prior year reserves, grants, etc.  PROPOSED CERTIFIED LEVY: The proposed certified levy is the estimated figures that will be entered into Dakota County tax  rolls. Dakota County Property Taxation will deduct Fiscal Disparities from all certified levies. Total Certified Proposed Levy TOTAL CERTIFIED PROPOSED LEVY 26,484,169 0 TOTAL TAX CAPACITY LEVY 26,484,169 0 (11,621,165)14,863,004$   100.00% TOTAL MKT VALUE REFERENDUM LEVY 000 ‐$ 0.00% FUND NUMBER: The fund number identifies your district levy category ‐ the fund number will auto populate after you select  the expenditure from the levy category list. ‐$ 0.00% 0 ‐$  ‐ Select Levy Account ‐blank Market Value Referendum Based Levy 0 ‐$ 0.00% 0.00%0 (11,621,165)14,863,004$   100.00% 26,300,366 (11,621,165)14,679,201$   98.76% 1.24% 0 ‐$ 0.00% 183,803 183,803$         Budget LGA Other  Resources Proposed  Certified Levy % of Levy Tax Capacity Based Levy Fund Number Levy Category FORM B ‐ PROPOSED LEVY CERTIFICATION Submit District Resolution with Levy Form fgdf Deadline:September 30, 2022 Payable Year:2023 Taxing Dist Name:ROSEMOUNT Entity Number:011000 ‐ Select Levy Account ‐ ‐ Select Levy Account ‐ ‐ Select Levy Account ‐ ‐ Select Levy Account ‐ 3000 3001 blank blank blank blank REVENUE DEBT SERVICE 7 AUTHORITY:PAY YEAR: 2023 2023 Certified Debt  Levy Certified Debt  Levy TAX INCREMENT ACTIVE 2008A DEBT SERVICE IF NEEDED 2,765,000$ ‐$‐$‐$‐$‐$‐$‐$‐$ GENERAL OBLIGATION ACTIVE 2014A DEBT SERVICE 2,400,000$ ‐$‐$‐$(13,199)$           13,199$            0$ (13,199)$            GENERAL OBLIGATION ACTIVE 2015A DEBT SERVICE IF NEEDED 3,335,000$ ‐$‐$‐$‐$‐$‐$‐$‐$ TAX INCREMENT ACTIVE 2015A DEBT SERVICE IF NEEDED 1,525,000$ ‐$‐$‐$‐$‐$‐$‐$‐$ REFUNDING ACTIVE 2015B DEBT SERVICE 1,345,000$ ‐$‐$‐$183,803$          ‐$183,803$          ‐$183,803$           GENERAL OBLIGATION ACTIVE 2018A DEBT SERVICE 835,000$ ‐$‐$‐$(3,747)$             3,747$              (0)$ (3,747)$              ‐ Click to add Pending Bond ‐ACTIVE ‐ Select Pay Method ‐ ‐$‐$‐$‐$‐$‐$‐$‐$ ALL OTHER DEBT ^DEBT SERVICE ‐$‐$‐$‐$ ‐$‐$‐$ 166,857$          16,946$            183,803$           166,857$          ‐$166,857$           FOOTNOTE: Signature Date 9/6/2022 TOTAL TAX ABATEMENT* TOTAL CERTIFIED DEBT SERVICE (Proposed)**  ^ ONLY USE FOR ANY ADDITIONAL DEBT SERVICE NOT CERTIFIED THROUGH A BOND REGISTERED WITH THE COUNTY ** TOTAL AMOUNTS MUST MATCH THE DEBT SERVICE FUND LISTED ON FORM B OF THE PROPOSED LEVY CERTIFICATION *TOTAL AMOUNTS MUST MATCH THE TAX ABATEMENT FUND LISTED ON FORM B AND FORM C OF LEVY CERTIFICATION TOTAL CERTIFIED DEBT SERVICE (Final)*** *** TOTAL AMOUNTS MUST MATCH THE DEBT SERVICE FUND  LISTED ON FORM C OF THE FINAL LEVY CERTIFICATION I hereby certify that the above schedule of bond levies to be spread on the payable 2022 tax rolls agrees with the tax district records and is true and correct. Minnesota Statute 475.63 and 475.64: If a reduction to  the debt levy payment is elected, I certify irrevocable funds on hand for the debt service account or that there exist excess funds in the debt service account for payment of the debt levy. General Obligation Status Series Collection Method Original Principal Tax  Abatement Increase(+) or Decrease(‐) Net  Abatement 105% of P&I  Debt Levy Increase(+) or Decrease(‐) September 30, 2022 Increase(+) or Decrease(‐) DEBT LEVY CERTIFICATION Proposed ‐ Form BFinal ‐ Form C Rosemount 2023 December 28, 2022 PROPOSED DUE DATE: FINAL DUE DATE: 8 $12 * ONLY COMPLETE YELLOW HIGHLIGHTED FIELDS 2022 2023 Percent Current Year Proposed Change Dakota County City $14,026,345 $14,863,004 6.0% School COUNTY SUMMARY BUDGET INFO CITY SUMMARY BUDGET INFO 2022 2023 Percent 2022 2023 Percent Current Year Proposed Change Current Year Proposed Change Revenues Property Taxes $13,843,145 $14,679,201 6.04% Special Assessments $150,000 $150,000 0.00% State General Purpose Aid $0 $0 0.00% State Categorical Aid $652,200 $692,500 6.18% All Other Revenues $7,371,148 $7,374,500 0.05% Expenditures General Government $3,606,200 $3,788,620 5.06% Public Safety $5,924,600 $6,485,104 9.46% Streets & Highways $3,915,000 $4,235,875 8.20% Sanitation $0 $0 0.00% Human Services $0 $0 0.00% Health $0 $0 0.00% Culture & Recreation $1,872,700 $1,986,500 6.08% Conservation of Natural Resources $0 $0 0.00% Economic Development & Housing $203,800 $226,700 11.24% All Other Expenditures $5,258,560 $7,660,412 45.68% AUTHORIZATION Name Date Title Phone Number Email SUPPLEMENTAL BUDGET INFORMATION - PROPOSED 2023 TAXES LEVY INFORMATION RosemountTaxing Authority Category I, the authorized representative of the above mentioned Governmental Agency, certify that the foregoing information is accurate to the best of my knowledge. Finance Director 651­322­2031 teah.malecha@rosemountmn.gov September 6 2022 9 10 0.41832 0.40961 0.39355 0.38580 0.36954 0.36949 0.32320 0.28004 0.26580 0.25386 0.24133 0.22716 0.21630 0.18802 0.23336 0.21352 0.20613 0.19860 0.20046 0.19971 0.17889 0.04907 0.04307 0.04227 0.04030 0.03802 0.03729 0.03197 2017 2018 2019 2020 2021 2022 2023 Est. Tax  Rate Comparison City of Rosemount Dakota County ISD #196 Special Districts 11 42.7%43.9%43.9%44.5%44.2%44.9%44.8% 28.6%28.5%28.3%27.9%27.2%26.3%26.0% 23.8%22.9%23.0%22.9%24.0%24.3%24.8% 5.0%4.6%4.7%4.7%4.6% 4.5%4.4% 2017 2018 2019 2020 2021 2022 Historical Tax  Comparisons City of Rosemount Dakota County ISD #196 Special Districts 12 44.8% 26.0% 24.8% 4.4% 2023 Estimated Taxes   City of Rosemount Dakota County ISD #196 Special Districts 13 FUNDING REQUIREMENTS - USES 2022 2023 Adopted Proposed +/- Departments Budget Budget Difference Percentage ------------------------------------------------------------ ------------------- ------------------- ------------------ ----------------- Council Budget 200,000 200,045 45 0.02% Administration Budget 945,100 1,059,000 113,900 12.05% Elections Budget 45,000 2,000 (43,000) -95.56% Finance Budget 749,400 798,705 49,305 6.58% General Government Budget 420,300 422,370 2,070 0.49% Community Development Budget 1,235,900 1,306,500 70,600 5.71% Police Budget 5,393,300 5,859,904 466,604 8.65% Fire Budget 531,300 625,200 93,900 17.67% Public Works Operating Budgets: Government Buildings Budget 619,400 665,280 45,880 7.41% Fleet Maintenance Budget 778,200 816,400 38,200 4.91% Street Maintenance Budget 1,534,500 1,696,240 161,740 10.54% Parks Maintenance Budget 983,400 1,057,955 74,555 7.58% Park & Rec Budget - General Operating 1,638,900 1,755,100 116,200 7.09% Park & Rec Budget - Steeple Ctr. Operations 158,200 147,400 (10,800) -6.83% Park & Rec Budget - Special Programs 85,600 84,000 (1,600) -1.87% Transfers - Arena Assistance 130,000 130,000 0 0.00% ------------------- ------------------- ------------------ ----------------- Total Operating Budgets - General Fund $15,448,500 $16,626,099 $1,177,599 7.62% Building CIP Requirements 0 0 0 0.00% Street CIP Requirements 931,361 959,302 27,941 3.00% Equipment CIP Requirements 809,712 900,000 90,288 11.15% Insurance Budget Requirements 450,000 450,000 0 0.00% Port Authority Operating Levy 170,900 170,900 0 0.00% Bonded Indebtedness 183,172 183,803 631 0.34% Water Enterprise Fund 1,702,400 1,864,460 162,060 9.52% Sewer Enterprise Fund 2,666,665 3,166,075 499,410 18.73% Storm Water Enterprise Fund 1,474,265 1,719,450 245,185 16.63% Street Light Utility Fund 220,000 228,800 8,800 4.00% Arena Enterprise Fund 531,600 546,150 14,550 2.74% ------------------- ------------------- ------------------ ----------------- Total Funding Requirements $24,588,575 $26,815,039 $2,226,463 9.05% ========== ========== ========== ========= 14 General  Government 23.6% Public Safety  39.0% Public Works 25.5% Park &  Recreation 11.9% General Fund General  Government 15% Debt ‐General 1% Public Safety 24% Port Authority  Operating Levy 1% Public Works 16% Park & Rec 7% Street Light Fund 1% Street CIP 3% Equipment CIP 3% Insurance  Fund 2% Storm Water Fund 6% Sewer Fund 12% Water Fund 7% Arena Fund 2% 2023 Expenditures 15 FUNDING REQUIREMENTS - SOURCES 2022 2023 Adopted Proposed +/- Types Budget Budget Difference Percentage ---------------------------------------------------------- ------------------ ------------------ ------------------ ------------------ Internal Revenue Generated: Licenses and Permits 987,100 1,168,000 180,900 18.33% Intergovernmental 1,195,500 1,301,500 106,000 8.87% Charges for Services 1,157,300 1,437,800 280,500 24.24% Fines & Forfeits 95,000 96,000 1,000 1.05% Recreational Fees 296,400 313,800 17,400 5.87% Miscellaneous Revenues 232,500 201,500 (31,000) -13.33% Transfers In 3,500 3,500 0 0.00% Enterprise Revenues 6,594,930 7,524,935 930,005 14.10% ------------------ ------------------ ------------------ ------------------ Total Internal Revenues 10,562,230 12,047,035 1,484,805 14.06% Levy Sources: Special Levies 183,172 183,803 631 0.34% General Levy 13,843,173 14,584,201 741,028 5.35% ------------------ ------------------ ------------------ ------------------ Total Levy $14,026,345 $14,768,004 $741,658 5.29% ------------------ ------------------ ------------------ ------------------ Total Revenue Sources $24,588,575 $26,815,039 $2,226,463 9.05% ========== ========== ========== ========== 16 SPREAD LEVY COMPUTATIONAL WORKSHEET (INCLUDING FIRE STATION LEVY) (Proposed) 2020 2021 2022 2023 ----------------- ----------------- ----------------- ----------------- Total Funding Requirements 23,047,538 23,658,638 24,588,575 26,815,039 Less: Internal Revenues 10,080,000 10,233,800 10,562,230 12,047,035 ----------------- ----------------- ----------------- ----------------- Equals: Revenues Needed 12,967,538 13,424,838 14,026,345 14,768,004 County Auditor Adjustments (All Subtractions): Fiscal Disparities Distribution Levy (Metro Area)1,361,991 1,461,128 1,494,616 1,516,882 ----------------- ----------------- ----------------- ----------------- Spread Levy Used to Compute Local Tax Rate 11,605,547 (1)11,963,710 (1)12,531,729 (1)13,251,122 (1) Increase/(Decrease) from Previous Year in Spread Levy 3.09%4.75%5.74% (1) Actual Spread Levy Based on Numbers from Dakota County 17 2017 2018 2019 2020 2021 2022 2023 Internal Revenues $8,795,600 $9,900,300 $10,339,200 $10,080,000 $10,233,800 $10,562,230 $12,047,035 General Levies 11,081,400 11,530,100 12,037,927 12,786,597 13,247,834 13,843,173 14,584,201 Special Levies $346,056 $344,681 $282,507 $180,941 $177,004 $183,172 $183,803 $0 $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 Revenue  Breakdown 18 CITY OF ROSEMOUNT WORKSHEET FOR ESTIMATING RESIDENTIAL PROPERTY TAXES (ISD #196 FIGURES) (Rates Based on Proposed Preliminary Levy Numbers) 302,840 (Value After M/V Exclusion)315,593 (Value After M/V Exclusion)382,192 (Value After M/V Exclusion)344,260 (Value After M/V Exclusion) Market Value 312,000 (Payable 2021 Median)323,700 (Payable 2022 Median)384,800 (Est. Payable 2023 Median)(+18.88% 350,000 ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ Year 2021 2022 2023 Est.2021 2022 2023 Est.2021 2022 2023 Est.2021 2022 2023 Est. ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ Tax Capacity 3,028 3,028 3,028 3,156 3,156 3,156 3,822 3,822 3,822 3,443 3,443 3,443 Tax Capacity Rates: City 0.36954 0.36949 0.32323 0.36954 0.36949 0.32323 0.36954 0.36949 0.32323 0.36954 0.36949 0.32323 County 0.22716 0.21630 0.18802 0.22716 0.21630 0.18802 0.22716 0.21630 0.18802 0.22716 0.21630 0.18802 School District 0.20046 0.19971 0.17889 0.20046 0.19971 0.17889 0.20046 0.19971 0.17889 0.20046 0.19971 0.17889 Miscellaneous 0.03802 0.03729 0.03197 0.03802 0.03729 0.03197 0.03802 0.03729 0.03197 0.03802 0.03729 0.03197 ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ Totals 0.83518 0.82279 0.72211 0.83518 0.82279 0.72211 0.83518 0.82279 0.72211 0.83518 0.82279 0.72211 ========== ========== ========== ========== ========== ========== ========== ========== ========== ========== ========== ========== City Market Referendum 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 ISD #196 Market Ref 0.0032712 0.0031336 0.0029756 0.0032712 0.0031336 0.0029756 0.0032712 0.0031336 0.0029756 0.0032712 0.0031336 0.0029756 Dakota County Ref 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 2022 2023 Property Taxes: City 1,119 1,119 979 1,166 1,166 1,020 1,412 1,412 1,235 1,272 1,272 1,113 City Taxes $1,166 $1,235 County 688 655 569 717 683 593 868 827 719 782 745 647 City Market Ref.$0 $0 School District 607 605 542 633 630 565 766 763 684 690 688 616 -------------- -------------- Miscellaneous 115 113 97 120 118 101 145 143 122 131 128 110 Total Taxes - Median $1,166 $1,235 ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ Total Property Taxes 2,529 2,492 2,187 2,636 2,597 2,279 3,192 3,145 2,760 2,875 2,833 2,486 Increase / (Decrease)$69 City Market Referendum 0 0 0 0 0 0 0 0 0 0 0 0 ISD #196 Market Ref 1,021 978 928 1,059 1,014 963 1,259 1,206 1,145 1,145 1,097 1,041 Dakota County Ref 0 0 0 0 0 0 0 0 0 0 0 0 ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ Grand Total All Taxes $3,550 $3,469 $3,115 $3,695 $3,611 $3,242 $4,451 $4,350 $3,905 $4,020 $3,929 $3,527 ========== ========== ========== ========== ========== ========== ========== ========== ========== ========== ========== ========== 371,510 (Value After M/V Exclusion)414,000 (Value After M/V Exclusion) Market Value 375,000 414,000 History of Actual Tax Capacity Rates (Using ISD #196 Rates) ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ Year 2021 2022 2023 Est.2021 2022 2023 Est.2018 2019 2020 2021 2022 2023 Est. ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ Tax Capacity 3,715 3,715 3,715 4,140 4,140 4,140 Tax Capacity Rates: City 0.36954 0.36949 0.32323 0.36954 0.36949 0.32323 0.40961 0.39355 0.38580 0.36954 0.36949 0.32323 (1), (2) County 0.22716 0.21630 0.18802 0.22716 0.21630 0.18802 0.26580 0.25386 0.24133 0.22716 0.21630 0.18802 (2) School District 0.20046 0.19971 0.17889 0.20046 0.19971 0.17889 0.21352 0.20613 0.19860 0.20046 0.19971 0.17889 (2) Miscellaneous 0.03802 0.03729 0.03197 0.03802 0.03729 0.03197 0.04307 0.04227 0.04030 0.03802 0.03729 0.03197 (2) ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ ------------------ Totals 0.83518 0.82279 0.72211 0.83518 0.82279 0.72211 0.93200 0.89581 0.86603 0.83518 0.82279 0.72211 ========== ========== ========== ========== ========== ========== ========== ========== ========== ========== ========== ========== City Market Referendum 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 (2) ISD #196 Market Ref 0.0032712 0.0031336 0.0029756 0.0032712 0.0031336 0.0029756 0.0026715 0.0026162 0.0034367 0.0032712 0.0031336 0.0029756 (2) Dakota County Ref 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 (2) Property Taxes: City 1,373 1,373 1,201 1,530 1,530 1,338 Net Tax Capacity Percentages County 844 804 699 940 895 778 For Residential Homesteads: School District 745 742 665 830 827 741 Miscellaneous 141 139 119 157 154 132 Equal to or Less Than $500,000 1.00% 1.00% 1.00% ------------------ ------------------ ------------------ ------------------ ------------------ ------------------Over $500,000 1.25% 1.25% 1.25% Total Property Taxes 3,103 3,057 2,683 3,458 3,406 2,990 City Market Referendum 0 0 0 0 0 0 ISD #196 Market Ref 1,227 1,175 1,116 1,354 1,297 1,232 (For 2002 Through 2011 Credit Applied to All Organizations Proportionately) Dakota County Ref 0 0 0 0 0 0 (For 2012 and On Credit Eliminated-Replaced with Market Value Adjustment) ------------------ ------------------ ------------------ ========== ========== ========== Grand Total All Taxes $4,329 $4,232 $3,799 $4,812 $4,704 $4,221 ========== ========== ========== ========== ========== ========== (1) This Figure Derived Using Figures Provided by Dakota County: (a) 2022 Projected Levy Less Fiscal Disparities as of 11/2/22 13,251,122 / 40,995,657 =32.32% (b) Preliminary Net Tax Capacity Figure as of 10/20/22 (With M/V Exclusion)46,042,711 19.63% Increase (Decrease) from Final Pay 2022 (c) Captured Tax Increment Tax Capacity as of 11/2/22 (1,874,808) 34.66% Increase (Decrease) from Final Pay 2022 (d) Contribution to Fiscal Disparities as of 11/2/22 (3,172,246) -0.25% Increase (Decrease) from Final Pay 2022 ------------------ Last Updated - 11/16/2022 (2) These Figures Provided by Dakota County as of 11/2/2022 40,995,657 (For 2013 and on the City of Rosemount does not have a Referendum Levy) 19 Residential Property Taxes 2022 Taxes 2023 Taxes No Value Change Impact No Value Change 2023 Taxes Average Value Increase Impact Average Home Value 323,700 323,700 384,800 City Share of Taxes 1,166 1,020 (146) 1,235 69 County Share of Taxes 683 593 (90)719 36 ISD #196 Share of Taxes 630 565 (65)684 54 Special Taxing Districts Share of Taxes 118 101 (17)122 4 School District's Referendum Levy 1,014 963 (51)1,145 131 Total 3,611 3,242 (369) 3,905 294 $294,000  $312,000 $323,700  $384,800  $0 $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 $450,000 2020 2021 2022 2023 Average Home Value 20 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Notes ------------------- - ------------------------------------------------- --------------------- ------------------------------------------ --------------------- --------------------- ----------------------------------------------------------------- 101 31010.00 Current Ad Valorem Taxes 8,718,622 9,310,150 9,410,828 9,986,584 10,587,117 From County 101 31040.00 Fiscal Disparities 1,305,333 1,361,991 1,443,778 1,494,616 1,516,882 Total Taxes (Tax)10,023,955 10,672,141 10,854,606 11,481,200 12,103,999 Total Property Tax Levy for Fund 101 101 32110.00 Alcoholic Beverage Licenses (L)38,870 19,425 25,608 38,000 38,000 101 32160.00 Licenses to do Business (L)10,325 8,963 12,844 10,500 10,500 Garbage Haulers, Ped Licenses, etc. 101 32162.00 Lic to do Business-Rental Housing (L) 10,080 12,390 1,230 12,000 12,000 101 32180.00 Tobacco Licenses (L)4,650 481 7,394 500 7,400 Every other year 101 32210.00 Building Permit Revenue (L)688,673 825,419 1,095,215 725,000 875,000 101 32212.00 Mineral Extraction Permit (L)- 2,230 370 2,000 2,000 101 32220.00 Electrical Permit Revenue (L)11,505 29,690 26,567 30,000 30,000 101 32221.00 Admin Fee - Electrical Permits (L)9,611 11,010 15,351 11,000 12,000 101 32230.00 Plumbing Permit Revenue (L)65,224 82,456 78,038 65,000 78,000 101 32240.00 Animal Licenses (L)1,605 1,949 1,214 2,000 2,000 101 32250.00 Sewer Permit Revenue (L)14,345 20,242 44,615 15,000 25,000 101 32255.00 County Recording Fee-City's (L)80 110 100 100 100 101 32260.00 HVAC Permit Revenue (L)70,111 83,767 65,524 75,000 75,000 101 32290.00 Other Non-Bus Lic & Permits (L)860 500 260 1,000 1,000 Alarm Permits & Fireworks Permits Total Licenses & Permits (L)925,939 1,098,631 1,374,329 987,100 1,168,000 101 31020.00 Delinquent Ad Valorem Taxes (I)13,669 77,517 139,282 - - 101 31030.00 Mobile Home Taxes (I)10,597 12,251 13,169 12,000 12,000 101 31705.00 Solar Energy Production Tax 1,961 4,879 3,869 5,000 5,000 101 31710.00 Gravel Taxes (I)142,873 145,697 194,529 200,000 200,000 101 31810.00 Franchise Taxes - Regular Fees (I) 235,154 220,545 209,963 220,000 220,000 Charter 101 31811.00 Franchise Taxes - PEG Fees (I)- - - - - Moved to 220 101 31920.00 Forfeited Tax Sale Apportionment (I)- - - - - 101 33100.00 Federal Grants & Aids (I)3,273 1,833,933 33,736 - - 101 33416.00 Police Training Reimbursement (I)256,896 243,106 259,404 250,000 250,000 101 33418.00 MSA for Streets - Maintenance (I)300,431 330,711 313,415 320,000 360,000 101 33423.00 Ag Preserves Credit (I)410 2,710 2,072 2,500 2,500 101 33425.00 Other State Grants & Aids (I)88,925 69,823 58,204 80,000 80,000 101 33620.00 Other County Grants & Aids (I)30,263 38,339 46,109 32,000 92,000 Dakota County Recycling Funds 101 33630.00 Police Services Levy-ISD #196 (I)69,044 70,425 46,892 74,000 80,000 101 33720.00 Other Organization Grants - - - - - Total Intergovernmental (I)1,153,495 3,049,935 1,320,645 1,195,500 1,301,500 101 34103.00 Zoning & Subdivision Fees (C)62,930 66,720 86,460 75,000 80,000 101 34104.00 Plan Checking Fees (C)227,839 265,934 377,872 250,000 275,000 101 34105.00 Sales of Maps & Publications (C)- - - 100 100 Maps & Spec Books 101 34107.00 Assessment Fees 7,155 3,625 9,055 - - 101 34108.00 Admin Fees - Other Funds (C)450,000 $25k admin fees, $425k construction funds 101 34108.01 Applicable Funds Except Const.25,000 25,000 25,000 25,000 101 34108.02 Construction Funds 158,562 199,797 202,123 200,000 85% of 5% Fee for Const. Projects 101 34109.00 Other Charges for Service (C)9,783 999 2,744 2,000 2,000 101 34110.00 Service Chg on Returned Chks (C)30 - 30 100 100 101 34113.00 Application Fees (C)- - - - - 101 34150.00 User Fees - SKB (C)184,529 100,561 57,534 130,000 130,000 SKB Fees - C & D Cell Fees 101 34151.00 User Fees/Host Agreements - SKB(C)- - - - - Landscaping Agreement 101 34152.00 User Fees - SKB (C)41,250 19,849 21,081 25,000 25,000 SKB Fees - MSW Ash Charges 101 34153.00 User Fees - SKB (C)449,221 254,590 296,386 220,000 220,000 SKB Fees - Base Service Charges 101 34160.00 National Guard Maint Fees (C)50,472 51,047 45,600 54,500 54,500 101 34201.00 Special Police Services (C)21,884 14,731 48,817 25,000 30,000 Contractual O/T for Officers 101 34202.00 Fire Services - Fireworks Permits (C)800 300 600 1,000 1,000 No Longer Charge for Burning Permits 101 34203.00 Accident Reports (C)- - - - - 101 34204.00 Day Care Inspection Fees (C)100 300 150 100 100 101 34205.00 Impound Fees (C)907 408 257 1,000 1,000 101 34206.00 Other Police Services (C)504 1,088 1,397 1,000 1,000 101 34207.00 Other Fire Protection Services (C)16,714 17,232 17,438 18,000 18,000 101 34303.00 Mow Weeds (C)310 944 435 1,000 1,000 101 34304.00 Sweep/Plow Streets (C)954 846 337 1,000 1,000 101 34306.00 Other Highway & Street Rev (C)32,227 84,982 75,155 80,000 100,000 Sealcoat - Developers 101 34310.00 Right-of-Way Permits (C)34,332 38,032 36,116 40,000 40,000 101 34407.00 City Share of Metro SAC Chgs (C)8,499 8,598 8,151 7,500 8,000 Total Charges for Services (C) 1,334,001 1,155,582 1,312,737 1,157,300 1,437,800 101 35101.00 Court Fines (F)109,083 75,452 86,802 95,000 96,000 Total Fines & Forfeits (F)109,083 75,452 86,802 95,000 96,000 101 34718.00 Tournament Fees (R)19,982 4,833 21,845 20,000 21,000 101 34720.00 Park Reservations (R)3,032 3,079 4,015 4,000 4,000 101 34721.00 Softball Revenues (R)- - - - - 101 34724.00 Tennis Revenues (R)1,817 - 1,908 2,200 2,200 101 34726.00 Rosettes Revenues (R)1,913 - -- - 2023 BUDGET WORKSHEETS GENERAL FUND REVENUES 21 Page 2 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Notes ------------------- - ------------------------------------------------- --------------------- ------------------------------------------ --------------------- --------------------- ----------------------------------------------------------------- 2023 BUDGET WORKSHEETS GENERAL FUND REVENUES 101 34727.00 Field Trip Revenues (R)14,000 101 34727.02 Adult/Senior Trips 10,159 15 12,056 14,000 101 34728.00 Adult Exercise Class Revenues (R)6,366 4,686 4,558 500 2,000 101 34730.00 Run for the Gold Revenues (R)2,941 - 3,270 4,800 4,800 101 34731.00 Youth Soccer Lessons (R)2,520 - 2,385 2,800 2,800 101 34732.00 Adult Basketball Revenues (R)1,774 653 976 2,000 2,000 101 34733.00 Other Programs Revenues (R)13,153 6,731 9,681 16,000 16,000 101 34735.00 Camps Revenues (R)48,285 5,250 52,258 40,000 52,000 101 34736.00 T-Ball Lessons (R)3,780 - 2,340 4,000 2,800 101 38080.00 Banquet Room Fees (R)75,268 9,262 68,168 75,000 75,000 101 38081.00 Auditorium Fees (R)9,118 918 6,325 8,000 8,000 101 38082.00 Gymnasium Fees (R)42,668 7,110 28,702 40,000 35,000 101 38086.00 Classroom Fees (R)13,633 21,363 75,913 11,000 14,000 101 38096.00 Liquor Provider Fees (R)900 - 900 1,000 1,000 101 38097.00 A/V Rental Fees (R)3,960 320 1,432 1,500 1,500 101 38154.00 Adult Enrichment Revenues (R)4,028 2,941 5,359 6,400 6,400 101 38201.00 Rental Revenues (R)48,806 13,408 42,060 40,000 45,000 Steeple Center 101 38205.00 A/V Rental Revenues (R)400 - 565 1,000 1,000 Steeple Center 101 38207.00 Liquor Provider Fees (R)330 60 150 200 200 Steeple Center 101 38209.00 Miscellaneous Revenues (R)- - - - - Steeple Center 101 38211.00 Security Services (R)5,275 (1,008) 3,035 2,000 3,100 Steeple Center 101 38215.00 Other Revenues (R)- - - - - Steeple Center Total Recreation Fees (R)320,105 79,620 347,900 296,400 313,800 101 36101.00 Principal - Special Assessments (M)62 49 (55) - - From County - 101 Funded Projects 101 36101.01 Cnty Pymts Cert Prior Year - - 647 - - 101 36102.00 Penalties & Interest - S/A (M)109 93 80 - - 101 36210.00 Interest Earnings - Investments (M) 226,701 185,896 37,813 180,000 180,000 101 36214.00 Net Change in FV-Investments (M)92,247 86,846 (86,846) - - Annual Market Value Adjustment - YE 101 36215.00 Interest Earnings (M)3,621 5,506 836 4,000 4,000 101 36220.00 Rents & Royalties (M)2,600 2,510 2,880 2,500 2,500 101 36230.00 Contribution/Donations (M)18,016 11,628 39,873 - - 101 36260.00 Other Revenue (M)4,234 12,893 9,798 12,000 12,000 101 36262.00 Special Settlements (M)- - - - - 101 36263.00 Wellness Program Revenues 1,000 - - 1,000 - 101 36265.00 Use of Reserve Funds (M)- - - 30,000 - 101 38090.00 City Concessions (M)2,571 2,203 2,026 3,000 3,000 Total Misc Revenues (M)351,160 307,625 7,052 232,500 201,500 101 39202.00 Contribution from Enterprises (T)3,500 3,500 3,500 3,500 3,500 Arena - Building & Grounds Maint. 101 39203.00 Transfer From____________ (T)3,880 3,214 - - - Total Transfers In (T)7,380 6,714 3,500 3,500 3,500 FUND TOTALS 14,225,117 16,445,699 15,307,571 15,448,500 16,626,099 INTERNAL REVENUES 4,201,162 5,773,558 4,452,965 3,967,300 4,522,100 Grand Total Less: Ad Valorem & Fiscal Disparities 22 73% 7% 8% 9% 0% 2%1% 2023 General Fund Revenues     General Property Taxes   Licenses and Permits     Intergovernmental  Charges for Services     Fines and Forfeits   Recreational Fees     Misc. & Transfers 23 City Council  The City Council is responsible for establishing the mission and vision for the City of Rosemount.   The Council also establishes community goals and supervises the activities of the City  Administrator.  Policy Development  Provides for the legislative and police‐making activities for all municipal government. Provides for the planning and control of all City expenditures through the adoption of the City’s annual budget. Provides for the definition of the City’s tax structure through the levying of taxes and approval of user fees and rate structures. Provides for citizen input to the policy‐making process by establishing, appointing, and managing advisory commission, ad hoc committees, and community group. 24 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------- ---------- --------------------------------------------------- ----------------- ----------------------------------- ----------------- ----------------- ----------------------------------------------------- 101 41110 103.00 Part-Time Salaries & Benefits 39,674 43,257 44,145 43,800 44,845 All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 101 41110 01 225.00 Landscaping Materials 25,000 26,201 31,226 25,000 25,000 Funding From SKB Revenues 101 41110 01 226.00 Tree/Landscaping Settlement - - 18,632 -- _ 101 41110 01 307.00 City Promotional Fees -Moved to Admin, Gen Govn't, & P&R 101 41110 01 307.01 Newsletter 19,854 20,374 20,134 -4 Newsletters 101 41110 01 307.02 Chamber of Commerce Directory 2,545 1,295 1,295 -_ 101 41110 01 307.03 Community Survey -16,000 16,950 -_ 101 41110 01 307.04 Community Events 10,000 102 10,000 -Leprechaun Days Fireworks 101 41110 01 315.00 Special Programs 5,339 749 3,984 7,000 7,000 Promotions, Marketing, etc. 101 41110 01 319.00 Other Professional Services -Moved to Admin, Gen Govn't, & Streets 101 41110 01 319.01 Education Reimbursement - - - - _ 101 41110 01 319.02 Intergovernmental Initiatives 12,023 13,497 13,454 -_ 101 41110 01 319.03 Open Government / Transparency 7,500 15,850 16,200 -Open Gov / POLCO / etc. 101 41110 01 319.04 County Broadband System 10,800 12,446 21,792 -Operating Costs 101 41110 01 321.00 Telephone Costs 800 _ 101 41110 01 321.02 Mayor's Cell Phone 637 676 726 800 _ 101 41110 01 329.00 Other Communication Costs -119 - - - Moved to Gen Govn't 101 41110 01 331.00 Travel Expense 8,000 _ 101 41110 01 331.01 NLC Conference 3,489 701 -6,000 _ 101 41110 01 331.02 Miscellaneous Travel 1,750 512 100 2,000 _ 101 41110 01 433.00 Dues & Subscriptions -Moved to Admin 101 41110 01 433.01 LMC Dues 19,394 19,785 20,590 -_ 101 41110 01 433.02 Metro Cities Dues 7,919 7,943 7,950 -_ 101 41110 01 433.03 Dak Cty Regional Chamber - - - - _ 101 41110 01 433.04 NLC Dues 1,953 -1,953 -_ 101 41110 01 433.05 Miscellaneous Dues - - 6,301 -MLC Dues 101 41110 01 435.00 Books & Pamphlets - - - - -_ 101 41110 01 437.00 Conferences & Seminars 13,000 _ 101 41110 01 437.01 Registration & Hotel-LMC Conf 3,586 1,100 1,407 2,000 _ 101 41110 01 437.02 Registration & Hotel-NLC Conf 8,806 3,201 2,568 9,000 _ 101 41110 01 437.03 Miscellaneous Conferences 280 760 120 3,000 _ 101 41110 01 439.00 Other Miscellaneous Charges 308 - - 400 400 _ 101 41110 01 598.00 Council Designated 148,437 220,000 25,239 60,000 101,000 $41k for IGH Ice Time Agreement 101 41110 01 598.01 Assignment for Health Ins. Increases - - - _ 101 41110 01 598.02 IGH Ice Time Agreement 41,000 41,000 41,000 41,000 _ 101 41110 01 598.03 Salary & Benefit Contingency - - - - 101 41110 01 599.00 Employee Recognition Costs -Moved to Admin & Gen Govn't 101 41110 01 599.01 Employee Recognition Costs 4,236 4,266 4,481 _ 101 41110 01 599.02 Vending Machine Costs 2,093 1,810 1,831 -Offset by Revenues 101 41110 01 599.03 Commemorations 1,502 1,130 1,002 _ 101 41110 01 599.04 Commission/Volunteer Recognition 2,838 3 1,326 _ DEPARTMENT TOTALS 380,962 452,776 314,407 200,000 200,045 2023 BUDGET WORKSHEETS COUNCIL 25 Administration Department  The Administration Department is responsible for the overall management of all departments within  the City and for assuring that departmental activities are consistent with the goals established by the  City Council.  General Administration  Provides overall management, administration and coordination of activities in all City departments including: Community Development, Finance, Fire, Police, Public Works and Parks & Recreation. Provides for preparation and overall management of the City's budgets. Provides project management for projects that are unique and therefore not assignable to any other department. Provides overall coordination of City consultants. Provides for the execution of all policies as adopted by the City Council. Provides administrative and clerical support to the City Council including the preparation, distribution and maintenance of City Council meeting documents. Provides support for Youth Commission, Cable Commission, Safety Committee and Volunteer Program Records Management  Provides for the preparation and maintenance of official records for the City including Council, Port Authority and Commission minutes. Prepares and assures publication and posting of official notices. Provides public information on ordinances, contracts and policies. Administers the collection, storage and dissemination of data. Provides for the maintenance, training and supervision of the digital document management system. 26 Licensing  Provides for the issuance and renewal of the following licenses: o Liquor o Peddlers, solicitors and transient merchants o Lawful purpose gambling premise permits o Block party street closures o Massage therapy o Tobacco o Arcade parlor, billiard hall and dance club Personnel Administration  Administers overall human resources programs and services.  Provides services to improve employee recruitment, retention, safety, training, orientation and relations. Administers the City’s personnel policies and procedures, assures compliance with union contract language, as well as state and federal labor regulations. Administers employee compensation, insurance, and benefit plans, assuring compliance with state and federal regulations. Public Information and Marketing  Prepares communications to residents about City government activities. Creates and coordinates marketing publications directed to business sectors outside of the community for economic development. Assists in preparing messages and collateral material for internal communications. Staffing  For 2023, the department will consist of six positions: o City Administrator o Assistant City Administrator o Communications Coordinator o City Clerk o Human Resources Coordinator o Deputy City Clerk/Management Analyst 27 Performance Measures  0.5 0.6 0.7 0.8 0.9 1 1.1 1.2 2015 2016 2017 2018 2019 2020 2021 Worker's  Compensation Modification Factor 0.0% 1.0% 2.0% 3.0% 4.0% 5.0% 6.0% 7.0% 8.0% 2015 2016 2017 2018 2019 2020 2021 Turnover  Rate of City Personnel 28 14 , 9 6 0   17 , 2 1 0   15 , 8 6 7   16 , 9 5 2   17 , 9 9 2   18 , 9 2 5   19 , 9 4 5    ‐  5,000  10,000  15,000  20,000  25,000 2015 2016 2017 2018 2019 2020 2021 Unique Views on City Website  ‐  1,000  2,000  3,000  4,000  5,000  6,000  7,000  8,000  9,000  10,000 2015 2016 2017 2018 2019 2020 2021 LinkedIn 250 Instagram 996 1,135 Twitter 1,140 1,305 Facebook 5,741 6,689 New Metric 2020 Social Media Followers 29 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments ------------------- --------- ------------------------------------------------- ---------------- ---------------------------------- ---------------- ---------------- -------------------------------------------------- 101 41320 101.00 Salaries & Benefits 542,437 579,365 605,633 704,000 809,400 All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 101 41320 01 103.00 Part-Time Salaries & Benefits 1,859 1,424 1,690 2,000 2,000 Full year Deputy City Clerk 101 41320 01 209.00 Other Office Supplies 340 - - 500 500 Miscellaneous Purchases 101 41320 01 313.00 Temporary Service Fees - - - - - 101 41320 01 319.00 Other Professional Services - - - - - 101 41320 01 321.00 Telephone Costs 1,909 2,750 3,555 2,900 3,500 Administration Cell Phones 101 41320 01 331.00 Travel Expense 1,300 101 41320 01 331.01 NLC Conference - - - - 101 41320 01 331.02 Conference Travel 530 - - 800 101 41320 01 331.03 Miscellaneous Travel 271 24 205 500 101 41320 01 392.00 P.C. Accessories & Supplies - - 382 - - 101 41320 01 433.00 Dues & Subscriptions 36,600 41,600 LMC, NLC, Chamber, Metro Cities 101 41320 01 433.01 MCMA Dues 298 314 331 400 101 41320 01 433.02 MAMA Dues 90 115 - 200 101 41320 01 433.03 MCFOA Dues 91 92 91 100 101 41320 01 433.04 Munici-Pals - 40 - 100 101 41320 01 433.05 IIMC Dues - -- 200 City Clerk Association 101 41320 01 433.06 ICMA Dues 2,139 2,123 2,208 2,200 101 41320 01 433.07 APMP Dues - - - 100 101 41320 01 433.08 Rotary Membership 507 338 - 600 101 41320 01 435.00 Books & Pamphlets - - - 200 200 101 41320 01 437.00 Conferences & Seminars 10,200 101 41320 01 437.01 Registration & Hotel - Conference 2,582 120 1,703 2,500 101 41320 01 437.02 Registration & Hotel - MCMA - 60 - - 101 41320 01 437.04 Staff (1) Each - -- - 101 41320 01 437.05 Miscellaneous Seminars 1,480 600 630 1,500 101 41320 01 437.06 Registration & Hotel - ICMA 3,961 - 1,686 3,500 101 41320 01 437.07 City Clerk Training 2,303 - 928 2,400 101 41320 01 437.08 Registration & Hotel - NLC - - - - 101 41320 01 437.09 Miscellaneous Meetings 110 - 67 300 101 41320 01 439.00 Other Miscellaneous Charges 107 - 144 200 200 101 41320 01 580.00 Other Equipment Purchases - - 97 1,000 1,000 101 41320 31 305.00 Medical & Dental Fees 4,500 Employee Drug Testing 101 41320 31 305.01 Pre-Employment Physicals 506 618 788 1,500 _ 101 41320 31 305.02 Employee Drug Testing 1,238 2,941 1,950 3,000 _ 101 41320 31 305.03 PCORI Fees 490 462 497 - _ 101 41320 31 305.04 Reinsurance Costs - - - - _ 101 41320 31 306.00 Personnel Testing & Recruitment 6,001 - 519 6,000 2,000 _ 101 41320 31 315.00 Special Programs 9,300 19,000 EE Recognition, Wellness 101 41320 31 315.01 Employee Training 6,265 5,209 2,057 7,700 101 41320 31 315.02 Health & Wellness 1,498 1,364 1,825 2,000 Wellness & Health Mgmt. 101 41320 31 315.04 SW/WC Co-op Wellness Grant - - - - Costs Reimbursed by Grants 101 41320 31 319.00 Other Professional Services 6,800 _ 101 41320 31 319.01 Labor Consultant - - - 1,000 _ 101 41320 31 319.02 Labor Legal Issues 945 - 229 1,000 _ 101 41320 31 319.04 COBRA Consultant 473 417 464 800 _ 101 41320 31 319.05 Flex/VEBA Administrative Fees 3,662 3,708 3,640 3,800 _ 101 41320 31 319.06 SWWC Co-Operative Dues - - - - _ 101 41320 31 331.00 Travel Expense 433 40 933 1,000 1,000 _ 101 41320 31 341.00 Employment Advertising - 175 462 1,000 500 Vacancies 101 41320 31 391.00 P.C. Maintenance 4,305 4,649 4,928 5,000 5,200 Neo Gov - Annual Maintenance 101 41320 31 394.00 P.C. Software Purchases - - - - - 101 41320 31 433.00 Dues & Subscriptions 1,200 101 41320 31 433.02 IPMA Dues 298 312 75 400 _ 101 41320 31 433.03 MPELRA Dues 430 685 215 800 _ 101 41320 31 435.00 Books & Pamphlets - - - 100 100 Books & Training Materials 101 41320 31 437.00 Conferences & Seminars 1,700 _ 101 41320 31 437.01 MPELRA State Conference 1,253 200 1,272 1,300 _ 101 41320 31 437.02 Personnel Seminars - - 139 400 _ 101 41320 31 437.03 Safety, Supervisor, Policy - - - - _ 2023 BUDGET WORKSHEETS ADMINISTRATION 30 Page 2 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments ------------------- --------- ------------------------------------------------- ---------------- ---------------------------------- ---------------- ---------------- -------------------------------------------------- 2023 BUDGET WORKSHEETS ADMINISTRATION 101 41320 31 438.00 Tuition Reimbursement - - - 12,000 12,000 _ 101 41320 41 315.00 Special Programs 2,000 101 41320 41 315.01 General Marketing - 119 13,210 2,000 _ 101 41320 41 315.02 Historical Monuments - -- - _ 101 41320 41 319.00 Other Professional Services 16,100 _ 101 41320 41 319.01 Website 5,996 6,296 7,949 9,000 Citibot 101 41320 41 319.02 Website Improvements - 158 61 - _ 101 41320 41 322.00 Postage Costs - -- 6,681 8,300 Newsletter postage 101 41320 41 328.00 Cable Supply Costs 66 - - 1,000 400 _ 101 41320 41 329.00 Other Communication Costs 93,000 Cable Supplies, Software 101 41320 41 329.01 Cable JPA Payment-General City 74,001 81,084 88,791 90,000 _ 101 41320 41 329.02 Video Streaming Council Mtgs60 - - 100 _ 101 41320 41 329.03 City Cable HD Boxes - - - - _ 101 41320 41 331.00 Travel Expenses 6 6 - 300 300 _ 101 41320 41 359.00 Other Printing & Binding Costs - - - 12,819 12,700 Newsletter printing _ 101 41320 41 433.00 Dues & Subscriptions 85 85 85 200 200 101 41320 41 437.00 Conferences & Seminars - - 15 600 600 MAGC 101 41320 41 580.00 Other Equipment Purchases 171 757 526 1,500 1,500 _ DEPARTMENT TOTALS 669,197 696,650 749,981 945,100 1,059,000 31 Elections  The responsible execution of elections is a crucial function of local government.  Federal, state and  local elections assure the popular representation of citizens and that the community’s mission, vision  and goals are consistent with the wishes of the electorate.  General / Administrative  Provides for conducting all local, state and federal elections. Voter Registration  Provides for the maintenance and execution of procedures for voter registration. Supplies & Equipment  Provides for the necessary supplies and minor equipment necessary to conduct the elections. Contracted Services  Provides for the maintenance agreements for service and repair of the voter assist terminals and the ballot counters. Provides for continued use of polling locations. Staffing  Provides for the recruitment, appointment, training and supervision of election judges to carry out Election Day activities at the City's seven precinct polling locations. Provides for training of absentee ballot board. Performance Measures  2014 2016 2018 2020 Voters 14,236 15,828 15,756 17,843 ‐ 2,000  4,000  6,000  8,000  10,000  12,000  14,000  16,000  18,000  20,000  Registered Voters 32 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments ------------------- --------- ------------------------------------------------- ---------------- ---------------------------------- ---------------- ---------------- -------------------------------------------------- 101 41410 103.00 Part-Time Salaries & Benefits - 46,294 - 38,000 - Election Judges & Front Desk 101 41410 01 203.00 Printed Forms & Paper - 117 - - - Ballots & Programming 101 41410 01 208.00 Miscellaneous Supplies - 1,156 - 400 - _ 101 41410 01 219.00 Other Operating Supplies - 1,125 - 400 - Food for Election Judges 101 41410 01 242.00 Minor Equipment - 444 - 700 - Signs & Miscellaneous 101 41410 01 304.00 Legal Fees - - - - - _ 101 41410 01 319.00 Other Professional Services - - - - - _ 101 41410 01 321.00 Telephone Costs - - - - - _ 101 41410 01 351.00 Legal Notices Publishing - 223 - 500 - Election Publications 101 41410 01 391.00 P.C. Maintenance - -- -- S/W Maintenance Costs (Utiliizing Laserfiche) 101 41410 01 409.00 Other Contracted Repair & Maint - _ 101 41410 01 409.01 Maintenance for Voting Machines - 4,660 - 5,000 Annual Maint. Fee to Dakota Cty 101 41410 01 409.02 Poll Pad Maintenance - -- _ 101 41410 01 412.00 Building Rental - -- -- Possible Rent for Locations 101 41410 01 439.00 Other Miscellaneous Charges - 65 - -- _ 101 41410 01 580.00 Other Equipment Purchases 2,753 923 1,907 - 2,000 Additional Voting Booths DEPARTMENT TOTALS 2,753 55,006 1,907 45,000 2,000 2023 BUDGET WORKSHEETS ELECTIONS 33 Finance Department  The Finance Department is responsible to work with all departments of the City, especially the  Administration Department, to ensure that all activities of the City are conducted in a fiscally  responsible manner.  General / Administrative  Provides for the fiscal management, processing and maintenance of all accounting transactions  for all funds of the City, including budgetary controls, preparation of interim accounting reports  and the Annual Comprehensive Financial Report (ACFR).  Also responsible for all other reporting  requirements of the Federal, State, County and other government agencies for budgets, taxes,  financial statements, TIF Districts and other items.  Beginning in 2012 also responsible for main  line phone administration.  Data Processing  Provides for evaluation of appropriate computer hardware and software on a continuing basis.  Coordinates efforts between departments to assure an integrated information system. Acts as  an in‐house consultant providing technical assistance when possible, and if not possible,  coordinating the procurement of outside technical assistance when needed. Provides for  network and system security, and network backup administration.  Treasury  Collects and deposits revenues and manages the investment of idle funds for fund  management. Historical and current expenditure and revenue data is collected and compiled to  facilitate in budget preparation. Assist in the issuance, sale, and record maintenance of  indebtedness. Maintains records for property and worker’s comp insurance requirements.  Handles all property and liability claims and prepares documents for all yearly policy renewal.   Payroll  Receives employee time sheets, coordinates insurance, pay rates and other applicable payroll  information with Human Resources, prepares payroll direct deposits and checks, prepares all Federal  and State required reports, prepares all employee withheld and employer promised obligation funds  for disbursement to applicable organizations, and prepares all reports as needed, both internally and  externally.  Utility Billing  Coordinates the automated reading of all City water meters, and the processing, mailing, uploading  and collection of all utility bills.  Preparation of final bills, setup of new accounts, and file maintenance  of existing accounts.  Fields and responds to utility billing questions and concerns.  Coordinates and  tracks the distribution of new and replacement water meters.  Compiles operating statistical  information which is available to other departments as needed.  34 Accounts Payable  Processes purchase orders prepared by all departments, checking for accuracy and matching with  invoices and all other supporting documentation so payments can be made in a timely manner.  Also,  prepares all checks and supporting reports that accompany each check run.  Coordinates the review  of bills by Council by providing applicable reports and supporting documentation.  Accounts Receivable  Prepares invoices for all departments for items/services that must be billed to outside sources.   Maintains records that allow for the timely collection of invoiced items/services.  Receipts monies  daily and deposits those monies daily in designated banking institutions.  Maintains a system that  allows for the appropriate reporting of all monies collected within the accounting system.  Fixed Assets  Responsible for the maintenance of the fixed asset system.  This includes all additions, deletions and  changes in fixed assets for the City.  It also includes the periodic physical inventory of all current fixed  assets.  Also responsible for the corresponding reporting requirements that go along with the system,  including year‐end information, insurance renewal information and individual department  information.  Special Assessments  Responsible for the maintenance of special assessments records to confirm that Dakota County’s  assessment balances are correct and in agreement with ours.  Works with the Engineering  Department for additions to the special assessment system.  Responsible for coordinating all  deletions and changes to the system as well as all collections of special assessment payments not  collected through property taxes.  Certificate of Achievement  The Government Finance Officer Association’s Certificate of Achievement for Excellence in Finance  Reporting is considered the highest form of recognition in governmental accounting and financial  reporting. As part of the requirements of the award, the government entity needs to publish an easily  readable and efficiently organized annual comprehensive financial report and satisfy both generally  accepting accounting principles and applicable legal requirements. The 2020 award is the 25th  consecutive year that the award has been received. The 2021 audit has been submitted for  consideration.  Staffing  In 2023, the department will consist of nine positions: o Finance Director o Accounting Supervisor o Accountant (2) o IT Coordinator o IT Specialist o Accounts Payable Specialist o Accounting Specialist – Utility Billing (2) 35 Performance Measures  Moody's  S&P  Prime Aaa AAA  High Grade  Aa1 AA+  Aa2 AA  Aa3 AA‐  Upper Medium Grade  A1 A+  A2 A  A3 A‐  Lower Medium Grade  Baa1 BBB+  Baa2 BBB  Baa3 BBB‐    City Bond Rating – Switched from Moody’s to Standard & Poor’s Global Ratings in 2017.  2015 2016 2017 2018 2019 2020 2021 City Bond Rating Lower Medium Grade Upper Medium Grade High Grade Prime Bond Rating 36  ‐  5,000  10,000  15,000  20,000  25,000  30,000  35,000  40,000 2015 2016 2017 2018 2019 2020 2021 Bills 31,524 31,950 32,442 33,270 34,081 34,923 36,195 Paperless 2,111 2,674 3,843 4,833 5,604 6,352 7,144 Utility Billing Invoices 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% 2015 2016 2017 2018 2019 2020 2021 Utility Billing Payments Cash Payments ACH Payments Credit Cards Direct Pay PSN Credit Cards PSN eCheck Check Payments 37 2,903 3,026 2,894 2,988 3,090 3,178 3,048  245 247 262 283 320 313 308  2015 2016 2017 2018 2019 2020 2021 Payments Processed Checks ACH Payments 38 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------- ---------- --------------------------------------------------- ----------------- ----------------------------------- ----------------- ----------------- ------------------------------------------------------ 101 41520 103.00 Salaries & Benefits 515,373 540,451 583,085 593,000 624,400 All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 101 41520 102.00 Full-Time Overtime 542 3,278 3,969 3,000 3,000 101 41520 01 225.00 Landscaping Materials - - - - - 101 41520 01 226.00 Tree/Landscaping Settlement - - - - - 101 41520 01 242.00 Minor Equipment - - 370 - - 101 41520 01 319.00 Other Professional Services - - 3,495 - - 101 41520 01 321.00 Telephone Costs 2,012 1,901 2,106 2,200 2,200 Phone allowance (2) + 1 city 101 41520 01 331.00 Travel Expense 800 _ 101 41520 01 331.01 Finance Director 378 160 -1,200 101 41520 01 331.02 Staff 135 -12 200 _ 101 41520 01 391.00 P.C. Maintenance 99,760 _ 101 41520 01 391.02 Remote Desktop Services 1,150 - - 1,500 _ 101 41520 01 391.03 Incode Software Maintenance 12,626 13,290 13,750 14,000 Incode Maint Fees - added signature 101 41520 01 391.04 General Network Support 30,000 30,000 30,000 30,000 CIT Support Hours 101 41520 01 391.06 Fixed Asset Maint Contract 1,500 1,500 1,500 1,600 _ 101 41520 01 391.07 Miscellaneous Repairs & Maint.2,968 3,725 2,360 4,000 _ 101 41520 01 391.08 Anti-Virus Software Renewal 1,188 1,188 3,688 2,000 _ 101 41520 01 391.09 File Server Software Maint.11,382 12,904 6,045 13,000 _ 101 41520 01 391.10 Managed Backup Services 18,840 18,840 31,860 20,000 101 41520 01 392.00 P.C. Accessories & Supplies 3,431 4,686 3,718 5,000 4,700 City-wide IT parts & supplies 101 41520 01 393.00 P.C. Hardware Purchases 9,762 2,941 3,220 3,000 3,500 City-wide IT hardware 101 41520 01 394.00 P.C. Software Purchases 55,225 _ 101 41520 01 394.01 Annual Microsoft Payments 6,440 6,440 6,440 6,800 Windows 10 Annual Payment 101 41520 01 394.02 Miscellaneous S/W Purchases 1,124 4,158 6,288 3,000 _ 101 41520 01 394.03 Office 365 -28,113 36,863 40,000 Office 365 Annual Payment Added Teams and Add'l Users 101 41520 01 409.00 Other Contracted R & M 225 225 225 300 250 Safe Deposit Boxes (3) 101 41520 01 433.00 Dues & Subscriptions 1,120 _ 101 41520 01 433.02 MnGFOA - Finance Director 50 70 -100 _ 101 41520 01 433.03 MnGFOA - Staff 300 420 490 500 _ 101 41520 01 433.04 GFOA - Finance Director & Asst.340 375 375 700 101 41520 01 435.00 Books & Pamphlets 100 _ 101 41520 01 435.01 Accounting Related Books - - - 50 _ 101 41520 01 435.02 Finance Related Books - - - 50 _ 101 41520 01 437.00 Conferences & Seminars 2,500 _ 101 41520 01 437.02 MnGFOA Annual Conf (F/D)618 - - 700 _ 101 41520 01 437.03 GFOA National Conf (F/D)- - 420 1,500 _ 101 41520 01 437.04 Staff Development 290 513 600 500 101 41520 01 437.05 Miscellaneous Seminars 542 -40 300 101 41520 01 439.00 Other Miscellaneous Charges 294 92 51 200 150 101 41520 01 570.00 Office Equipment & Furnishings 1,429 489 579 1,000 1,000 DEPARTMENT TOTALS 622,940 675,757 741,548 749,400 798,705 2023 BUDGET WORKSHEETS FINANCE 39 General Government  Duplicating & Copying  Provides for maintenance agreements and expenses to operate copy machines at all City facilities.  Also provides for digital document management costs. Printer Forms & Paper  Provides for copy paper utilized by all departments and provides for forms utilized by the Finance Department. Envelopes & Letterhead  Provides for letterhead utilized by all departments and for various types and sizes of envelopes. Other Office Supplies  Provides for general office supplies utilized by all City departments. Equipment Parts  Provides for the maintenance and repair of general office equipment. Auditing & Accounting Services  Provides for the annual audit of the City's accounting transactions for all funds of the City and for the preparation of the Comprehensive Annual Financial Report.  Also provides for other services as required of the City's financial and accounting consultants. Legal Fees  Provides for general legal and special legal services provided by the City Attorney or other law firms utilized by the City for such services. Other Professional Services  Provides for the administration costs of the City's code updates, code web fees, annual updates to the user fee study, preparation of the State building report and continuing disclosure fees. Telephone Costs  Provides for the costs of the City's telephone system, monthly service fees, long distance calls and miscellaneous installation costs.  Also, provides for fees associated with the City’s e‐mail and web services. Postage Costs  Provides for postage costs for all departments and maintenance agreements for the postage machine and postage allocator. 40 Other Transportation Expenses  Provides for two‐year renewals of City vehicle license plates, emission fees and duplicate plates, titles or tags, if needed. Legal & General Notices Publishing  Provides for the publication of legal documents from all departments except when publication costs are charged to specific projects. Lease Agreements  Provides for leasing of copy machines and other office machines at City Hall, Community Center and the Police Department. 41 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------- ---------- --------------------------------------------------- ----------------- ----------------------------------- ----------------- ----------------- ------------------------------------------------------ 101 41810 101.00 Salaries & Benefits - - - - - 101 41810 01 102.00 Full-Time Overtime - - - - - 101 41810 01 202.00 Duplicating & Copying 17,000 _ 101 41810 01 202.02 Copying Costs 16,465 16,052 17,923 17,000 _ 101 41810 01 203.00 Printed Forms & Paper 6,100 _ 101 41810 01 203.01 Copy Paper 4,296 2,985 2,785 3,500 _ 101 41810 01 203.02 General Receipt Books 503 -507 800 _ 101 41810 01 203.03 Purchase Orders -1,398 -1,400 Electronic PO's 101 41810 01 203.04 Payroll & A/P Checks 646 - 1,326 400 Checks, W2's, 1099's, 1095's 101 41810 01 203.06 Miscellaneous Forms 3,827 992 2,043 -Business Cards, etc. 101 41810 01 204.00 Envelopes & Letterheads 3,400 _ 101 41810 01 204.01 Letterhead 758 959 960 1,000 _ 101 41810 01 204.02 Plain Envelopes 1,632 514 297 600 _ 101 41810 01 204.03 A/P & Payroll Envelopes 738 1,577 -1,000 _ 101 41810 01 204.04 10 x 13 Envelopes - - 831 800 _ 101 41810 01 209.00 Other Office Supplies 14,314 10,289 11,307 15,000 15,000 General Office Supplies 101 41810 01 221.00 Equipment Parts 417 - - City Hall Equipment Repairs 101 41810 01 242.00 Minor Equipment _ 101 41810 01 242.02 Credit Card Equipment - - 550 500 - 101 41810 01 260.00 Food for Resale - - - 4,000 3,000 Vending machine-offset by revenue 101 41810 01 301.00 Auditing & Accounting Services 101 41810 01 301.01 Audit & General Consulting Fees 66,700 64,990 72,700 77,000 77,000 Single Audit 101 41810 01 301.02 Dakota County Assessment Fees 6,835 6,420 6,989 7,000 8,100 Dakota County + SA number increase 101 41810 01 301.03 Dak Cty Truth In Taxation Costs 1,613 1,708 1,698 1,800 1,800 _ 101 41810 01 303.00 Engineering Fees - - - _ 101 41810 01 304.00 Legal Fees 51,271 62,912 77,616 58,000 62,000 K&G 101 41810 01 319.00 Other Professional Services 36,500 48,400 Volunteer Coordinator, MMKR, BT, DBB 101 41810 01 319.01 City Code Update 223 702 4,907 2,000 _ 101 41810 01 319.02 City Code Web Fees 500 500 1,000 500 _ 101 41810 01 319.03 State Building Report 4,160 -9,445 5,000 Baker Tilly Fees 101 41810 01 319.04 Continuing Disclosure Fees 3,290 -6,200 3,000 Moved to debt service funds 101 41810 01 319.05 Annual User Fee Study Update -3,655 -4,000 Baker Tilly Fees 101 41810 01 319.06 Arbitrage/Rebate Calculations 3,850 12,400 -10,000 Moved to debt service funds 101 41810 01 319.10 UMore Professional Services - - --In-House Engineer or Bill Out 101 41810 01 320.00 Credit Card Activity Fees 15,000 _ 101 41810 01 320.01 Utilities' Fees - - - 500 Add Add't Terminal for C/C Pym 101 41810 01 320.02 Parks & Recreation Fees 8,732 6,140 10,757 3,000 Increase with new progam & terminals 101 41810 01 320.03 Building Fees 49,075 67,337 3,330 3,000 Decrease in fee costs 101 41810 01 320.04 General Fees 1,486 1,194 237 500 Decrease in fee costs 101 41810 01 320.05 Parks & Recreation On-Line Fees - - - - _ 101 41810 01 321.00 Telephone Costs 62,520 _ 101 41810 01 321.01 General Phone Costs (& Internet) 37,549 42,694 49,119 43,000 101 41810 01 321.02 Domain Housing 60 760 520 500 101 41810 01 321.03 Software Maintenance Costs 15,468 15,762 1,278 18,000 101 41810 01 321.04 Phone System Hardware 1,114 892 17,408 2,000 Phone Upgrades, Headsets, etc 101 41810 01 322.00 Postage Costs 14,372 24,046 12,812 16,000 16,000 101 41810 01 329.00 City Cable Boxes - - - 1,200 1,200 _ 101 41810 01 339.00 Other Transportation Expenses 69 1,001 43 1,000 1,050 Vehicle Licensing 101 41810 01 351.00 Legal Notices Publishing 32 5,200 _ 101 41810 01 351.01 Costs for Public Notices 3,190 2,636 3,697 3,900 City-wide 101 41810 01 351.03 Budget & Audit Publications 1,246 1,055 574 1,300 State Mandated Publications 101 41810 01 359.00 Other Printing & Binding Costs - - - 500 300 101 41810 01 391.00 P.C. Maintenance 19,732 19,732 21,154 22,000 26,000 Laserfiche Maintenance 101 41810 01 392.00 P.C. Accessories and Supplies 9,740 8,599 6,465 10,000 9,000 Consultant Fees 101 41810 01 393.00 P.C. Hardware Purchases 3,699 4,000 3,496 4,000 4,000 Scanner Purchase 101 41810 01 394.00 P.C. Software Purchases - - - 17,000 17,000 Open Gov, POLCO, etc. 101 41810 01 433.00 Dues & Subscriptions 916 1,994 1,789 1,800 3,300 Newspapers, Amazon business acct 101 41810 01 439.00 Other Miscellaneous Charges 240 240 499 300 2,000 Bank Service Charges 101 41810 01 440.00 COVID-19 Expenses -230,274 36,960 - 101 41810 01 441.00 COVID-19 Grants -483,344 - - _ 101 41810 01 445.00 Special Settlements -111,328 - - _ 101 41810 01 580.00 Other Equipment Purchases 13,943 8,830 13,992 20,000 18,000 Office Machines-All Buildings DEPARTMENT TOTALS 362,670 1,219,910 403,244 420,300 422,370 2023 BUDGET WORKSHEETS GENERAL GOVERNMENT 42 Community Development  Overview: Mission, Vision and Goals  The Community Development Department is comprised of planning and zoning, economic  development, building inspections, and code enforcement functions. The department works in  unity to support safe and sustainable development throughout the community.  The Building Inspection and Planning Divisions play a key role in making Rosemount a safe and  pleasant community.  These divisions are also involved in reaching the City Council’s goals in  affordable housing, provision of life‐cycle housing and property maintenance.  The Economic Development Division addresses the City’s vision statement by fostering  opportunities to live, work and shop.  The division, along with the Rosemount Port Authority,  plays a vital role in meeting goals of the City Council such as attraction of commercial  amenities, business growth and expansion of local employment base.  Building Inspections  Responsible for providing the services of building permit review, building inspection, code administration, consultation and review on new and existing buildings and structures within the City. Responsible for the maintenance and enforcement of city ordinances and codes relating to building, health, life safety, fire and environmental conditions and to assure local compliance with county, state and federal regulations relating to the same activities. Responsible for the successful implementation of all structural development and assuring regulated and controlled standards within Rosemount. Responsible for monitoring and permitting all individual sewage treatment systems within the City. Responsible for reports submitted to all appropriate jurisdictions concerning building activities. Serves as Fire Marshal for the City activities. Code Enforcement  Responsible for enforcement of city ordinances and codes relating to health, life safety, environmental, and nuisance conditions and assure local compliance with county, state and federal regulations relating to the same activities. Responsible for rental housing inspection and permitting. 43 Responsible for sequential code enforcement program, which is a city‐initiated program for resident education and neighborhood code compliance. Planning  Responsible for reviewing proposed developments for compliance with the zoning and subdivision ordinance and coordinating interdepartmental staff review of all residential, commercial, institutional and industrial developments. Responsible for providing recommendations to Planning Commission and City Council on all deliberations concerning land use, zoning, variances, site plan reviews, platting and special permits (interim use permits, mining permits, etc.). Responsible for maintaining zoning and subdivision ordinances and the City’s Comprehensive plan in compliance with county, regional, state and federal requirements. Responsible for long‐range planning and special studies that guide the physical development of the community. Involved with state and regional activities affecting the City, including, but not limited to, land use, transportation, mining, housing and environmental services.  Includes active participation by departmental staff in various committees and organizations. Involved with issuance of development related permits such as grading and building permits. Economic Development  Responsible for marketing development opportunities within the City and creating an interest in Rosemount, with emphasis in commercial development. Responsible for creating and coordinating the establishment of tax increment districts and other economic incentives. Responsible for coordinating the state, county and local approval processes to insure the proponent's requests are met in a timely fashion. Responsible for staffing most functions of the Rosemount Port Authority. Involved with state and regional economic development organizations and functions. Responsible for communicating Federal, State and Local programs to assist businesses with operations; whether financial, employment, or regulatory. 44 Performance Measures  174 136 135 256 274 389 340 0 50 100 150 200 250 300 350 400 450 2015 2016 2017 2018 2019 2020 2021 Housing Units Developed 68 , 3 0 0 , 0 0 0 82 , 2 0 0 , 0 0 0 74 , 7 0 0 , 0 0 0 87 , 2 0 0 , 0 0 0 90 , 2 0 0 , 0 0 0 10 5 , 5 0 0 , 0 0 0 14 6 , 1 0 0 , 0 0 0 30,000,000 50,000,000 70,000,000 90,000,000 110,000,000 130,000,000 150,000,000 2015 2016 2017 2018 2019 2020 2021 Building Permit Valuation 45 5,467 5,927 5,425 6,317 8,001 8,198 9,531 0 1,000 2,000 3,000 4,000 5,000 6,000 7,000 8,000 9,000 10,000 2015 2016 2017 2018 2019 2020 2021 Building Inspections Conducted 0 200 400 600 800 1000 1200 2018 2019 2020 2021 Program Suspended During COVID. Restarted in 2022. Rental License Inspections Conducted 46 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------- ---------- --------------------------------------------------- ----------------- ----------------------------------- ----------------- ----------------- ------------------------------------------------------ 101 41910 101.00 Salaries & Benefits 1,042,175 1,167,431 1,150,643 1,152,000 1,219,900 All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 101 41910 01 102.00 Full-Time Overtime 33 - - 1,000 1,000 101 41910 99 103.00 Part-Time Salaries & Benefits 21,462 11,190 13,527 27,500 14,500 101 41910 01 201.00 Office Accessories - - - - - 101 41910 01 202.00 Duplicating & Copying 5,000 5,000 5,657 2,000 2,000 Includes Comp Plan Printing 101 41910 01 203.00 Printed Forms & Paper 723 -671 500 500 Forms, Stickers, Tags, etc. 101 41910 01 205.00 Drafting Supplies - - -- - 101 41910 01 208.00 Miscellaneous Supplies 45 - - - - 101 41910 01 209.00 Other Office Supplies 971 1,487 2,541 1,500 1,500 101 41910 01 219.00 Other Operating Supplies 567 47 2,754 2,000 2,000 101 41910 01 241.00 Small Tools 266 153 -800 800 Inspectors' Tools 101 41910 01 302.00 Architects' Fees - - - - - 101 41910 01 312.00 Contract Fees - - - - -Moved $45,000 to P/A Fund 101 41910 01 319.00 Other Professional Services 182 2,560 8,067 17,000 31,200 Consultant, Building Ins Services 101 41910 01 329.00 Other Communication Costs 3,949 4,607 4,683 4,500 4,500 Cell Phones 101 41910 01 331.00 Travel Expense 447 8 22 800 800 101 41910 01 391.00 P.C. Maintenance 4,374 4,085 4,241 5,100 5,700 Permitworks + Bluebeam Supp. 101 41910 01 392.00 P.C. Accessories & Supplies 37 866 222 1,000 1,000 101 41910 01 393.00 P.C. Hardware Purchases - - 1,044 - - 101 41910 01 394.00 P.C. Software Purchases - - 975 - - 101 41910 01 409.00 Other Contracted Repair & Maint.988 575 2,925 2,000 2,000 Mow Weeds-From Street Maint. 101 41910 01 433.00 Dues & Subscriptions 520 3,700 101 41910 01 433.01 APA/AICP 1,379 1,698 1,069 1,700 101 41910 01 433.02 ICC 225 280 -400 101 41910 01 433.03 AMBO - - - 500 101 41910 01 433.04 10,000 Lakes 125 160 -150 101 41910 01 433.06 Trade Magazines - - -- 101 41910 01 433.07 Planner's Journal - - -- 101 41910 01 433.08 Sensible Land Use Coalition - - 450 400 101 41910 01 433.09 AACEO/MAHCO - - - 100 101 41910 01 433.10 Other Dues & Subscriptions 383 543 80 450 101 41910 01 435.00 Books & Pamphlets -2,321 -800 800 Manuals, References, IBC Books 101 41910 01 437.00 Conferences & Seminars 14,200 101 41910 01 437.01 State Bldg Official School 890 133 -500 101 41910 01 437.02 Spring & Fall Code Updates -50 -500 101 41910 01 437.03 Building Inspector Training 990 737 2,507 1,500 101 41910 01 437.04 Computer Training --- 200 101 41910 01 437.05 Clerical Seminars --- 300 101 41910 01 437.06 Planning Seminars 2,198 468 168 2,500 101 41910 01 437.07 ISTS Training 520 390 2,513 1,000 101 41910 01 437.08 State Planning Conference (2)1,374 - - 2,000 101 41910 01 437.09 Planning Commissioner Training - - - 500 101 41910 01 437.10 Gen'l Seminars 511 165 1,123 1,200 101 41910 01 437.11 Code Enforcement Training - - - 100 101 41910 01 437.12 National Planning Conference - - - 3,000 101 41910 01 439.00 Other Miscellaneous Charges 69 7 39 400 400 101 41910 01 586.00 Computer Equipment Purchases - - - - -Tablets for Employees DEPARTMENT TOTALS 1,089,882 1,204,962 1,206,441 1,235,900 1,306,500 2023 BUDGET WORKSHEETS COMMUNITY DEVELOPMENT 47 Police Department  The Police Department is responsible for policing services to the community to ensure safety and  response to services calls.  A mission statement guides the actions of the Department; In  partnership with the community, the Rosemount Police Department assists and educates the  public, resolves problems, prevents crimes, and enforces laws.  We pursue our mission and serve  with honor, integrity, and courage.” Staffing levels are continually evaluated to meet the needs of  our growing community.  The specific service functions within the Police Department are  described below.  Police Administration  This budget provides for the overall leadership, planning, coordination and management of  personnel and administration of activities within the Police Department.  This includes the  collection, preparation and filing of crime data and miscellaneous reports with the State of  Minnesota; preparation and oversight of the operating and capital improvements budgets; and  strategic planning for the future needs of the Department and the community.  Police Department  leadership is also involved in many consolidated services governance boards that contribute to  policing services for the city.  The Dakota Communications Center (DCC), Criminal Justice Network  (CJN), Dakota County Electronic Crimes Unit (ECU), Dakota County Drug Task Force (DTF) and  South Metro SWAT Team are examples of some consolidated service organizations that contribute  to Rosemount’s policing initiatives.  Records Unit  The Police Department’s Records Unit is responsible for the processing of over 3,300 case reports  each year.  Reports require transcription and compilation for transmittal to the city or county  prosecutor’s office or any other agency (e.g., social services, county crises, corrections) requiring  information for service to the community.  Records staff ensure the Department is compliant with  all Minnesota Bureau of Criminal Apprehension data management laws, regulations and reporting  requirements.   Administrative support is provided to the entire Department for gun permit  applications, criminal background checks, and city licensing requirements.   Patrol Operations  Uniformed patrol is the core function of the Police Department and the most visible in the  community. Through 24‐hour daily patrols in marked police vehicles, patrol officers respond to  calls for service, investigate traffic accidents, conduct preliminary criminal investigations, enforce  traffic laws and enforce criminal laws.  Patrol Officers respond to medical calls as trained first aid  providers.  Through patrol operations the Police Department meets its goal of the protection of  life and property and creating a sense of safety and security in the community.  Patrol Officers  spend a significant amount of time developing relationships within the community and contacting  members of community organizations.  Patrol Officers perform additional specialty assignments  including, but not limited to, Crime Scene Technician, Use‐of‐Force Instructor, South Metro SWAT,  Special Operations Team, Drug Recognition Expert, Coordinated Community Response, and Field  Training Officer.   48 Criminal Investigation  Patrol officers and investigators are responsible for the investigation of criminal incidents through  evidence gathering and analysis, witness and suspect interviews, and court preparation and  testimony. Complex investigations, or those requiring a multi‐jurisdictional/agency involvement,  are coordinated by the investigator.  This is accomplished by working cooperatively with other  police agencies, the County Attorney’s Office, Child Protection, victim services and other local,  state and federal law enforcement agencies.  One investigator is assigned to the Dakota County Drug Task Force, a multi‐jurisdictional joint  powers entity, whose mission is to investigate drug crimes in the City of Rosemount and  throughout Dakota County.    Crime Prevention and Community Education Programs  A significant effort is made by the police department to inform residents of crime within the  community, methods that citizens can take to help prevent crimes and building relationships with  community members.  While these objectives are part of each officer’s daily responsibilities, there are specific programs  that are frequently associated with community policing and that emphasize the need for the police  and citizens to work together to prevent criminal activity and reduce the opportunities for  criminals to commit crimes.  School Liaison ‐ Officers serve as a liaison to the Rosemount Middle and High Schools. One officer is assigned full‐time to the High School and a second officer spends one‐quarter time at the Middle School.  The liaison officers investigate criminal incidents that occur at the schools or that involve students at the schools.  In addition, the liaisons work with the school staff to enhance the safety and security for both staff and students, specifically providing school safety planning, and armed intruder prevention and response planning. Presentations on a variety of topics are made by the liaison to classes at all grade levels. The Middle School officer also spends time at each of the elementary schools, working with staff on any issues and making presentations in classes. Community Education ‐ In order to work together with the community, police must share information concerning criminal activity and crime prevention with the community. Officers are available to make presentations to community groups and organizations on a variety of topics.  In addition, officers provide prevention tips to persons on a daily basis who report criminal activity.  Several events are also held throughout the year to build relationships with the residents and business persons. A few of these events include Night‐ to‐Unite, Public Safety in the Park, Shop with a Cop, Cops with Kicks for Kids and the Pink Patch Project amongst several others. Reserve Officer Program – Reserve officers are volunteers who supplement the staff of sworn officers of the Department.  The reserve officers are utilized to handle traffic and crowd control duties during city festivals and celebrations or emergencies, such as hazardous materials spills or leaks, damage resulting from tornadoes or other severe weather and major criminal incidents.  Reserve officers patrol on some evenings and handle service calls; for example, assisting stalled motorists and animal complaints.  They 49 are also utilized regularly to provide crime prevention information to citizens at community  events or through other programs.  Chaplain Program – The Police Chaplains assist in a variety of situations in which individuals or families are having difficulties. Chaplains are able to provide support to persons that are experiencing stress as a result of the death of a loved one, marital or family problems, financial struggles or any other event.  By utilizing the chaplains to console and counsel persons in crisis, police officers are able to focus on their primary duties, while the chaplains are able to remain with the persons involved in the crisis. Explorer Program – Exploring is a community based, co‐educational program supervised by the local police department. The Explorer program is designed for young adults ages 14 – 21 that want to learn more about law enforcement. The program is part of the Boy Scouts of America and is open to both young men and young women. Membership in the Rosemount Police Department Explorer Post is restricted to those young people that live in Rosemount or attend school in Rosemount. Residents of other communities that do not attend school in Rosemount are turned away. The Rosemount Police Explorer Post was formed in 2014. Explorers meet twice a month under the direction of the two officers that serve as Post advisors. During these meetings they conduct post business and train in law enforcement skills.  The Explorers also take part in the statewide Explorer Conference where they compete against other Explorer Posts in law enforcement scenarios including crime scene processing, domestic disturbance calls, building searches, etc. The Explorer Post is an opportunity for youth of our community to become exposed to law enforcement. Some just want to learn more about the police department. Others are truly “exploring” law enforcement as a potential future career. In either case it brings teenagers closer to the police department in a service capacity. As such it fits with the department’s mission of improving quality of life in our community. Adult Citizen Academy Program –The Adult Citizen Academy has been a project of the Rosemount Police Department for the past 7 years. It is a way to offer those who live or work in Rosemount an inside look at the operation of their police department. It also allows them an opportunity to meet the officers who serve them. The academy covers topics such as recruiting, ethics, criminal investigations, the charging process, drug task force, use of force, traffic enforcement, forensics, and includes a citizen ride‐along with a patrol officer. As such it helps fulfill the department’s educational mission. Teen Academy Program – The Rosemount Police Department partnered with the Apple Valley Police Department to host a Teen Academy.  The academy gives high school students an inside look at police work.  The students learned about the Dakota Communications Center (dispatch), Dakota County Drug Task Force, K9 unit, crime scene investigation, DWI enforcement and had the opportunity to participate in shoot/don’t shoot scenarios using Simunition® weapons.  Rosemount and Apple Valley officers present the sessions, offering a good experience for youth who have an interest in how their police department works for them or may be considering a career in law enforcement. 50 Animal Control  The Police Department is responsible for the enforcement of ordinances related to the control and  care of domestic animals.  These tasks are mainly handled by Community Service Officers.  Their  duties include the licensing of dogs and ferrets, assisting in the handling of stray, lost or injured  animals and other complaints of animals causing a nuisance by barking, howling or being allowed  to roam off the owner’s property.  Code Enforcement  The Police Department assists the Community Development Department with code enforcement  of city ordinances related to property maintenance and outside storage. The Department’s  Community Service Officers primarily handle this effort.  Property owners that are observed to be  in violation of an ordinance are notified of the violation and given an explanation of how to  remedy the violation.  The enforcement of city ordinances is important to maintain community  standards, which help the City attain its mission of providing a safe, healthy and pleasant  community.  Emergency Management  The City has an all‐hazards emergency plan and the Chief of Police serves as the City’s emergency  manager.  The emergency manager is responsible for the development of emergency plans in the  event of a chemical, technical or natural disaster in the community (e.g. tornado, flooding, school  shooting, or hazardous materials release).  The Chief of Police represents the City of Rosemount  on the Dakota County Domestic Preparedness Committee (DCDPC).  The DCDPC is comprised of  police, fire, dispatch, EMS, public health, and medical facility representatives to aid all Dakota  County cities and Dakota County with all‐hazards emergency planning and leadership.  51 Performance Measures  0 5 10 15 20 25 30 35 0.9 0.95 1 1.05 1.1 1.15 1.2 2015 2016 2017 2018 2019 2020 2021 Officers 23 24 25 25 27 27 30 Per 1,000 Residents 1.01 1.02 1.03 1.02 1.07 1.06 1.15 Licensed Police Department Employees 0 1 2 3 4 5 6 0 0.05 0.1 0.15 0.2 0.25 2015 2016 2017 2018 2019 2020 2021 Employees 5555554 Per 1,000 Residents 0.21 0.21 0.2 0.2 0.20 0.20 0.15 Non‐Licensed Police Department Employees 52 52 58 66 67 46 20 39 0 10 20 30 40 50 60 70 80 2015 2016 2017 2018 2019 2020 2021 Car Crashes with Personal Injury 0% 10% 20% 30% 40% 50% 60% 70% 80% 2015 2016 2017 2018 2019 2020 2021 Case Clearance Rate of Reported Crimes 0 102030405060708090 0.00 0.50 1.00 1.50 2.00 2.50 3.00 3.50 4.00 2015 2016 2017 2018 2019 2020 2021 DWI Arrests DWI Arrests Per 1,000 Residents 53 0 50 100 150 200 250 300 350 0.00 2.00 4.00 6.00 8.00 10.00 12.00 14.00 16.00 2015 2016 2017 2018 2019 2020 2021 Part I Crimes 317 219 224 202 167 196 203 Per 1,000 Residents 13.76 9.30 9.35 8.30 6.62 7.64 7.77 Part I Crimes 0 100 200 300 400 500 600 700 800 900 1,000 0.00 5.00 10.00 15.00 20.00 25.00 30.00 35.00 40.00 2015 2016 2017 2018 2019 2020 2021 Part II Crimes 867 658 778 724 664 591 682 Per 1,000 Residents 37.63 27.93 32.46 29.74 26.35 23.04 26.10 Part  II Crimes 54 66 70 45 50 49 0 36 0 10 20 30 40 50 60 70 80 2015 2016 2017 2018 2019 2020 2021 National Night Out Events 06:55 05:59 04:32 04:20 04:59 05:59 05:24 00:00 01:26 02:53 04:19 05:46 07:12 08:38 2015 2016 2017 2018 2019 2020 2021 Response Time to Priority 1 Calls 55 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------- ---------- --------------------------------------------------- ----------------- ----------------------------------- ----------------- ----------------- ------------------------------------------------------ 101 42110 101.00 Salaries & Benefits 3,338,237 3,607,765 4,061,763 4,437,000 4,841,900 All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 101 42110 01 102.00 Full-Time Overtime 121,391 67,137 113,230 122,500 118,125 101 42110 99 103.00 Part-Time Salaries & Benefits 39,758 26,134 34,599 40,000 52,000 101 42110 01 202.00 Duplicating & Copying - - - - - 101 42110 01 203.00 Printed Forms & Paper 1,950 1,742 1,773 2,300 2,300 Shred-It, Gun Pmts, Newspaper 101 42110 01 204.00 Envelopes & Letterheads 320 33 - - - 101 42110 01 207.00 Training & Instructional Supplies 11,800 101 42110 01 207.01 Practice Ammunition 4,804 5,330 228 5,000 101 42110 01 207.02 Service Ammunition 1,013 1,938 -1,300 101 42110 01 207.03 Other Supplies -103 -500 101 42110 01 207.04 SWAT Ammunition 1,170 3,140 -5,000 101 42110 01 208.00 Miscellaneous Supplies -Donated & Forfeited Funds 101 42110 01 208.02 Equipment Donations/Forfeitures 17,412 12,139 29,987 - 101 42110 01 208.03 Other Grants Expenditures - - - 101 42110 01 209.00 Other Office Supplies 239 175 12 1,100 1,100 101 42110 01 211.00 Cleaning Supplies 3,500 101 42110 01 211.02 Squad Cleaning 1,118 2,837 3,494 3,000 Increase in Fees / # of Squads 101 42110 01 217.00 Uniform/Equipment Expenses 7,700 101 42110 01 217.01 CSO's 2,141 194 1,621 2,000 101 42110 01 217.02 Reserves 2,252 133 864 2,500 101 42110 01 217.03 Other Supplies 3,072 2,109 456 3,200 101 42110 01 219.00 Other Operating Supplies 15 14,000 101 42110 01 219.01 Evidence Bags, Drug Kits, Misc.651 1,937 2,057 2,000 101 42110 01 219.02 Investigation Software 2,551 3,037 4,645 5,000 Adding Lexis Nexis Data Analytics 101 42110 01 221.00 Equipment Parts 4,504 6,424 2,928 4,500 4,500 101 42110 01 241.00 Small Tools 2,800 101 42110 01 241.01 Evidence Processing Equipment 1,997 870 431 800 101 42110 01 241.02 Camera and Video Supplies 1,094 778 56 2,000 101 42110 01 241.03 Winscribe 241 1,305 - - Now Covered by Axion 101 42110 01 242.00 Minor Equipment 5,100 101 42110 01 242.01 Less Lethal Tactical Equipment 1,466 6,765 5,968 2,500 Training Supplies, Taser Batteries 101 42110 01 242.02 MAAG Equipment 467 1,551 457 1,600 101 42110 01 242.03 Drug Task Force Equipment 2,600 - - 1,000 101 42110 01 304.00 Legal Fees 68,972 71,022 131,283 84,000 120,000 New legal prosecution 101 42110 01 305.00 Medical & Dental Fees 3,000 101 42110 01 305.01 Physicals 2,000 2,331 1,728 1,800 101 42110 01 305.02 Seized Narcotic Testing 647 276 205 1,200 Blood Draws 101 42110 01 306.00 Personnel Testing & Recruitment 2,703 2,812 1,396 1,800 1,800 Psychological 101 42110 01 313.00 Temporary Service Fees 74 1,342 179 800 800 Interpreter Services 101 42110 01 316.00 Animal Care Services 3,000 101 42110 01 316.01 Impound & Care Fees 2,536 843 1,042 3,000 101 42110 01 319.00 Other Professional Services 450,779 101 42110 01 319.01 Dispatch Services - Operations 440,448 430,560 400,116 408,300 101 42110 01 319.02 Policy Development & Training - - 13,894 12,000 Lexipol 101 42110 01 319.03 Mediation Services - - - 1,000 101 42110 01 319.04 Electronic Crimes Unit Fees 18,000 18,000 18,000 21,000 Increase in Membership 101 42110 01 319.05 Emergency Mgmt Plan Update - - - 101 42110 01 321.00 Telephone Costs 16,000 101 42110 01 321.01 Cell Phones 14,023 14,426 14,738 15,200 101 42110 01 323.00 Radio Units 15,600 101 42110 01 323.01 Radios 13,671 11,665 13,457 15,000 800 MHz Subscriber Fees-Increase 101 42110 01 323.02 Radars 450 474 524 500 Radar & LIDAR Repairs 101 42110 01 323.03 Radio Warranty - - - - 101 42110 01 331.00 Travel Expense 9,600 101 42110 01 331.01 MN Chief's Spring Conference 950 -1,320 1,000 101 42110 01 331.02 IACP or FBINAA Conference - - -4,000 101 42110 01 331.03 Outstate Investigations & Conf.1,034 760 807 1,000 101 42110 01 331.04 SWAT Conference 940 -975 1,200 101 42110 01 331.05 CAN-AM Narcotic Conference 460 -474 500 101 42110 01 331.06 Juvenile Officers Conference - - 275 600 101 42110 01 331.07 Meeting Reimbursements 441 474 752 800 101 42110 01 333.00 Freight & Express Expenses 113 81 87 200 200 101 42110 01 392.00 P.C. Accessories & Supplies 33 101 42110 01 394.00 P.C. Software Purchases 165 67,100 101 42110 01 394.01 Automated Pawn System - - - 2023 BUDGET WORKSHEETS POLICE 56 Page 2 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------- ---------- --------------------------------------------------- ----------------- ----------------------------------- ----------------- ----------------- ------------------------------------------------------ 2023 BUDGET WORKSHEETS POLICE 101 42110 01 394.02 Pictometry - - - 101 42110 01 394.03 CJN/EFORMS 4,974 5,118 12,725 20,000 Full CJN Membership 101 42110 01 394.04 DCLEA Phoenix Pro 78,236 78,384 66,651 52,000 DCLEA Membership 101 42110 01 394.05 Guardian Tracking Software 1,344 1,344 1,612 1,600 101 42110 01 394.06 Vitals 2,167 2,167 3,000 2,000 Assisting with Vulnerable Individuals 101 42110 01 394.07 Emergency Management Services - 5,720 -JPA for EOP Revision & EOC Trng 101 42110 01 396.00 Computer Maintenance 43,200 101 42110 01 396.02 CJDN Connection Charges 2,520 2,520 2,520 3,000 State of MN CJDN Connection 101 42110 01 396.03 MCD Connection Charges 3,274 1,800 1,350 2,200 LOGIS MDC Connection Charges 101 42110 01 396.04 MCD Maintenance & Cellular 29,448 31,514 32,016 33,000 Increase Due to More Squads 101 42110 01 396.05 LOGIS Fees/Development 3,752 3,900 3,744 4,000 Development Fund 101 42110 01 396.06 Evidence.com Data Storage -3,793 - - 101 42110 01 396.07 Schedule Anywhere 538 595 672 700 Scheduling Software 101 42110 01 433.00 Dues & Subscriptions 18,000 101 42110 01 433.01 South Metro SWAT Dues 8,300 8,300 10,000 10,300 Increase in Dues 101 42110 01 433.02 IACP Chiefs 190 -190 400 101 42110 01 433.03 MN Chiefs of Police 314 351 886 700 101 42110 01 433.04 Dakota Cty Chiefs of Police 400 400 400 400 101 42110 01 433.07 MN Sex Crimes Investigators - - - 20 101 42110 01 433.08 Tri-County Investigators 75 -75 75 101 42110 01 433.09 MN Crime Prevention Association - - -65 101 42110 01 433.10 P.O.S.T. Licenses 900 632 1,172 800 101 42110 01 433.12 Miscellaneous 20 20 -340 101 42110 01 433.13 ATOM - - -- 101 42110 01 433.14 Rotary Membership - - - 600 101 42110 01 435.00 Community Engagement Supplies 2,796 1,952 4,608 2,800 2,800 Crime Prevention Materials 101 42110 01 436.00 Towing Charges -241 85 200 200 Disabled Squads/Search Warrants 101 42110 01 437.00 Conferences & Seminars 37,550 101 42110 01 437.01 Firearms - Range 3,173 3,775 2,395 4,500 Range Rental 101 42110 01 437.02 Chiefs Spring Conference 825 -- 1,000 Conference Cost Increases 101 42110 01 437.03 Investigations 1,722 2,014 2,203 2,000 101 42110 01 437.04 IACP Conference - - - 550 101 42110 01 437.05 Supervision/Leadership Training 9,559 6,371 5,514 6,500 Personnel Developmnt Northwestern 101 42110 01 437.06 Use of Force 1,975 1,288 896 2,000 101 42110 01 437.07 Emergency Driving 825 1,525 4,300 3,000 Driving School Cost Increase 101 42110 01 437.08 First Aid 2,171 2,379 10,281 1,500 101 42110 01 437.09 Narcotic Enforcement - - - 200 101 42110 01 437.10 Tactical 1,176 1,095 1,471 2,000 101 42110 01 437.11 Support Services 200 665 763 800 101 42110 01 437.12 Patrol Operations/Training 10,045 3,664 9,332 7,500 Increase-Mandates & More Officers 101 42110 01 437.13 Emergency Management - - - - 101 42110 01 437.14 SRO / CRO - - 750 1,300 Added for Specialized Training 101 42110 01 437.15 Explorer Conference - - - - No Program in 2022 101 42110 01 437.16 360 Communities Annual Banquet 240 - - 350 101 42110 01 439.00 Other Miscellaneous Charges 1,202 741 1,130 1,200 1,200 Hosting Meetings & Training 101 42110 01 580.00 Other Equipment Purchases 1,164 1,368 853 2,000 2,000 101 42110 01 599.00 Employee Recognition Costs 2,116 2,297 2,395 2,000 2,250 Recognition Banquet/Plaques/Awards DEPARTMENT TOTALS 4,293,550 4,484,573 5,050,024 5,393,300 5,859,904 57 Fire Department  Mission / Vision / Goals  The Rosemount Fire Department’s mission is an intricate component of the overall mission of  the City of Rosemount in that the Fire Department is dedicated to the saving of life and  property.  This component which the Fire Department provides compliments and provides a  necessary service so that the City may reach its broader mission of providing a safe, healthy and  pleasant community in which to live and work.  This service is provided by a paid‐on‐call  department, which is the most fiscally sound method of delivery at this point in the City of  Rosemount’s development.  The Rosemount Fire Department enhances the overall vision that is set for the City of  Rosemount in that it provides the opportunity for individuals to demonstrate their pride in the  community by serving on a “volunteer” fire department and assisting their neighbors.  The  “volunteer” Fire Department has historically been associated with the kind of small town  character that Rosemount is striving to maintain.  As the City continues to grow, so will the  needs of the Fire Department and at some point, full‐time staff will need to be added.  Administrative / Management  Provides for the overall administration and management of the Fire Department.  Included is  the collection, preparation and dissemination of information; the preparation of operating  budgets, Capital Improvement Projects (CIP) budgets and state reports; and planning for the  long and short term needs with respect to training, fire protection, emergency medical  response, facilities, staffing and the acquisition and maintenance of equipment, along with the  coordination of efforts between other emergency response agencies and those of the City of  Rosemount.  Fire Suppression / Investigation  Provides for the controlling and extinguishing of all types of fires in order to minimize injury, loss of life and loss of property within the City of Rosemount, both to its citizens and visitors. Provides for the controlling and extinguishing of all types of fires in order to minimize injury, loss of life and loss of property within the contracted areas of Coates and the University of Minnesota, along with the railroad right‐of‐ways. Provides for the provision of all of these fire services to all the cities of Dakota County and many of the cities of Washington County via a mutual aid agreement by which these services can be reciprocated on an as needed basis. Provides for the investigation of fires by the Rosemount Fire Marshal.  Also provides for the coordination of joint investigations by the local Fire Marshal and the State Fire Marshal. 58 Rescue Squad  Provides for emergency operations pertaining to bodily injury or serious illness requiring emergency services within the City of Rosemount, both to its citizens and visitors. Provides for emergency operations pertaining to bodily injury or serious illness requiring emergency services within the contracted areas of Coates and the University of Minnesota. Provides for the provision of all these emergency operations to all the cities of Dakota County and many of the cities of Washington County via a mutual aid agreement by which these services can be reciprocated on an as needed basis. Hazardous Material Response / Confined Space Response  Provides a team of Operations Level, Technician Level and Specialists, trained to respond to hazardous material accidents, identify, secure and coordinate the efforts of outside agencies that are trained to contain, mitigate and clean up the spill. Trains all Firefighters to respond to confined space incidents, evaluate the situation and mitigate or coordinate the rescue effort. Incorporates members of the department with the Dakota County Special Operations Team (S.O.T.). Water / Ice Rescue  Provide technical water rescue during emergency situations to include the use of throwing devices, water rescue suits and row boats. Annual training is conducted to ensure that staff is able to respond to all types of water rescue and conditions and work collaboratively with other County agencies to provide an emergency response. Training / Education  Provides for the necessary monthly and annual training requirements required by the State to meet qualification and certification to maintain proper licensure. Allows for training in areas above those that are required, in order that fire and rescue personnel may sharpen existing skills and acquire new skills. Provides the necessary training to ensure staff has the needed skillset to properly identify the hazards associated with the job as well as to properly protect themselves from those hazards. 59 Allows for training of firefighters to prepare themselves for the acceptance of a position of leadership within the Fire Department. Health Testing  Provides for the screening and medical certification of potential new firefighters. Allows for the continuous health monitoring of existing personnel. Provides for the protection of personnel from blood‐borne pathogens and communicable disease. Equipment / Maintenance  Allows for the replacement or addition of equipment necessary for fire and medical response, including both consumable and nonconsumable items. Provides for the emergency contracting with outside providers for repairs of fire vehicles and specialized equipment. Staffing  In 2021, the Fire Department added six new members to the department however, one of the  new hires left in early January of 2022.  At the end of 2021, we lost a valuable member of the  department when one of our Captains retired after 26 years on the department.  The  department is working on a succession plan for future officers of the department.  The  pandemic continued to be on the forefront of the firefighter’s minds and the department  struggled with COVID in the fire stations and dealing with isolations/quarantines of firefighters.   60 Performance Measures  2015 2016 2017 2018 2019 2020 2021 Calls 272 274 302 310 331 280 299 Per 1,000 11.80 11.63 12.60 12.74 13.13 10.92 11.44 0.00 2.00 4.00 6.00 8.00 10.00 12.00 14.00 0 50 100 150 200 250 300 350 Total  Paged Fire Calls Calls Per 1,000 2015 2016 2017 2018 2019 2020 2021 Calls 438 446 442 510 563 568 673 Per 1,000 19.01 18.93 18.44 20.95 22.34 22.14 25.75 0.00 5.00 10.00 15.00 20.00 25.00 30.00 0 100 200 300 400 500 600 700 800 Total  Paged Medical Calls Calls Per 1,000 61 Insurance Industry Rating of Fire Services (ISO Rating)  2015 2016 2017 2018 2019 2020 2021  City 4/5 4/5 4/6 4/6 4/6 4/6 4/6  Rural 10 10 10 10 10 10 10  06:14 06:36 06:11 06:25 06:24 06:10 06:03 05:46 05:54 06:03 06:12 06:20 06:29 06:37 06:46 2015 2016 2017 2018 2019 2020 2021 Average Response Time for High Priority Calls 0 10 20 30 40 50 60 2015 2016 2017 2018 2019 2020 2021 Number of Firefighters 62 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------- ---------- --------------------------------------------------- ----------------- ----------------------------------- ----------------- ----------------- ------------------------------------------------------ 101 42210 101.00 Salaries & Benefits - - - - - All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 101 42210 01 102.00 Full-Time Overtime - - - - - 101 42210 02 103.00 Part-Time Salaries & Benefits 279,004 334,251 414,644 340,000 390,000 101 42210 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 500 101 42210 01 204.01 Envelopes - - - 200 101 42210 01 204.02 Letterhead - - - 200 101 42210 01 204.03 Forms - - - 100 101 42210 01 211.00 Cleaning Supplies 800 101 42210 01 211.01 Soaps -68 150 550 101 42210 01 211.02 Chamois, Towels, etc.--- 100 101 42210 01 211.03 Sponges, etc.--- - 101 42210 01 211.04 SCBA Cleaner 66 - - 150 101 42210 01 218.00 Fire Department Clothing 9,200 101 42210 01 218.01 Uniforms 790 48 1,627 1,700 Uniforms for New Hires 101 42210 01 218.02 Station Wear (2015)599 3,312 2,771 5,000 $150 per Year Stipend for FF's 101 42210 01 219.00 Other Operating Supplies 13,300 Medical Supplies 101 42210 01 219.01 Gloves - - 1,088 2,500 101 42210 01 219.02 Bandages - - - - 101 42210 01 219.03 Equipment 5,369 1,190 625 1,500 101 42210 01 219.04 Tyvek Suits - - - 100 101 42210 01 219.05 Consummable Medical 3,312 4,504 5,298 6,000 Medical Dollar Increases 101 42210 01 219.06 Oxygen - - - 1,200 Added O2 Cascade @ FS #2 101 42210 01 229.00 Other Maintenance Supplies 7,100 101 42210 01 229.01 Vehicle Repairs -54 131 600 101 42210 01 229.04 Vehicle Modifications -2,443 3,778 6,500 Replace Aging Light Bars 101 42210 01 230.00 Equipment Repair Materials 1,600 101 42210 01 230.01 Light Bars - - - - 101 42210 01 230.02 Smoke Machines - - - 300 101 42210 01 230.03 Lanterns & Miscellaneous 1,706 45 114 300 101 42210 01 230.04 Small Tool Repairs 948 544 689 600 Aging nequipment 101 42210 01 230.05 Opticom - - - - 101 42210 01 230.06 Station 200 -359 - 101 42210 01 241.00 Small Tools 6,400 101 42210 01 241.01 Axes, Bars & Other 425 -62 150 101 42210 01 241.02 Grass Fire - - -250 101 42210 01 241.03 Hand Tools 656 528 11,817 500 Replace Aging Tools 101 42210 01 305.00 Medical & Dental Fees 5,513 5,360 6,394 6,500 6,500 101 42210 01 306.00 Personnel Testing & Recruitment 7,800 101 42210 01 306.01 New Physicals (4)5,251 4,170 3,906 5,000 New Hires 101 42210 01 306.02 Hepatitis Shots (4)- - 1,300 500 Medical cost increases 101 42210 01 306.03 Background Checks (4)477 367 366 600 101 42210 01 306.04 Drug Testing (4)- - - 200 101 42210 01 306.05 Firefighter Recruitment Costs 901 40 -1,000 To Add Additional Firefighters 101 42210 01 308.00 Instructors' Fees 21,400 101 42210 01 308.01 Fire Fighter 1 (4)460 3,130 2,550 1,900 101 42210 01 308.02 Fire Fighter 1 Certificates (4)600 - - - 101 42210 01 308.03 Fire Fighter Re-Certificates (14)-550 125 500 101 42210 01 308.04 First Responder (4)--- 1,000 101 42210 01 308.05 First Responder Refresher (1/2)--6,050 1,400 Changed to outside training 101 42210 01 308.06 Outside Schools 14,495 12,530 14,477 10,000 Adding Leadership Traning 101 42210 01 308.07 Haz-Mat Training (4) 330 1,020 1,150 1,000 ^^^ For Officers ^^^ 101 42210 01 308.08 Other Re-Certificates (2)- - - - 101 42210 01 310.00 Testing Services 8,300 101 42210 01 310.01 Aerial 775 2,333 2,023 2,500 101 42210 01 310.02 Ladders 445 536 598 800 Increase in Fees 101 42210 01 310.03 Pumpers (3) 1,060 1,460 2,018 2,800 Added New Engine to Fleet 101 42210 01 310.04 SCBA Mask Testing - - 2,385 2,500 New Mask Requirement 101 42210 01 313.00 Temporary Service Fees 15,300 101 42210 01 313.01 SCBA Maintenance 2,845 5,349 3,777 4,500 Added SCBA Compressor-FS #2 101 42210 01 313.02 SCBA Flow Test 2,364 2,688 1,958 2,500 Added SCBA Compressor-FS #2 101 42210 01 313.04 Security Contract - - - 800 101 42210 01 313.05 SOT Joint Powers 7,044 7,049 7,107 7,500 Increase in Fees 2023 BUDGET WORKSHEETS FIRE 63 Page 2 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------- ---------- --------------------------------------------------- ----------------- ----------------------------------- ----------------- ----------------- ------------------------------------------------------ 2023 BUDGET WORKSHEETS FIRE 101 42210 01 314.00 Annual Fire Relief Contribution 30,000 30,000 30,000 30,000 30,000 101 42210 01 319.00 Other Professional Services 1,900 Fire Prevention Education 101 42210 01 319.01 School Literature 345 - - 600 101 42210 01 319.02 Door Prizes - - - - 101 42210 01 319.03 Fire Prevention Week Promos 809 - 590 700 101 42210 01 319.04 Food at Open House - - -- 101 42210 01 319.06 National Night Out - - 455 600 101 42210 01 321.00 Telephone Costs 330 5,300 101 42210 01 321.01 Cell Phones 2,548 2,936 4,337 3,200 Active 911 Subscriptions 101 42210 01 321.02 Computer Cards - - - 1,800 101 42210 01 322.00 Postage Costs 2 - - 100 100 UPS Costs 101 42210 01 329.00 Other Communication Costs 23,000 101 42210 01 329.01 Base Repairs 56 - - 300 101 42210 01 329.02 Pager Repairs - 300 782 1,000 101 42210 01 329.03 Hand Held Repairs - - - 2,500 Warranty Plan to be Added 101 42210 01 329.04 Mobile Repairs - - - 2,000 Aging Equipment 101 42210 01 329.05 800 MHZ User Fee 13,905 12,132 13,345 14,000 101 42210 01 329.06 Mobile Computers 2,472 2,664 3,504 3,200 Monthly Air Time Fees (1 Add'n) 101 42210 01 331.00 Travel Expense 8,600 101 42210 01 331.01 Minnesota Chief's Conference - - 2,451 2,000 101 42210 01 331.02 Fire Department Association - - 450 1,600 101 42210 01 331.03 Outside Schools 240 - 875 5,000 FDYC Training Added 101 42210 01 433.00 Dues & Subscriptions 7,100 101 42210 01 433.01 Capital City 50 50 50 50 101 42210 01 433.02 VFBA Insurance 295 -950 750 101 42210 01 433.03 State Fire 801 910 340 800 101 42210 01 433.04 State Chiefs - - - 300 101 42210 01 433.05 DCFC 100 100 100 100 Increase in Dues 101 42210 01 433.06 WAKOTA Mutual Aid 50 -50 100 101 42210 01 433.07 On-Line Training/Tracking Tool -4,044 4,703 5,000 Annual Subscription-50 FF's 101 42210 01 433.08 NFPA --- - 101 42210 01 437.00 Conferences & Seminars 1,900 101 42210 01 437.01 State Fire Conference 587 -460 400 101 42210 01 437.02 State Chief's Conference 3,129 -870 1,500 Move to 331.01 101 42210 01 439.00 Other Miscellaneous Charges 4,100 101 42210 01 439.01 Food & Coffee 468 273 421 1,000 101 42210 01 439.02 Extinguisher -208 -600 101 42210 01 439.03 Plaques 547 226 226 600 101 42210 01 439.04 Paint - - - 100 101 42210 01 439.05 Station Needs 1,525 1,220 2,616 1,800 Added "202.01/202.02/230.06" 101 42210 01 580.00 Other Equipment Purchases 55,000 101 42210 01 580.01 Bunker Gear (8) 12,654 20,114 18,901 22,600 Add 2nd sets of gear to FF's/10 per yr 101 42210 01 580.02 Pagers 559 -3,170 1,000 Replacements (5 Per Year) 101 42210 01 580.03 Hose & Fittings -648 1,371 2,000 Aging Equipment 101 42210 01 580.04 Replace Damaged Items 2,176 739 1,766 2,000 DEPARTMENT TOTALS 408,952 470,132 592,449 531,300 625,200 64 Public Works The Public Works Department has a mission to enhance the quality of life through responsive,  efficient, and cost‐effective delivery of services consistent with community values.  With sound  management, fiscal responsibility and professional care, the Department will preserve and  protect the infrastructure resources and many of the physical assets of the City, creating a safe,  clean and enjoyable environment for residents and businesses.  The Public Works Department consists of the Engineering and Operations Divisions. The  operations and maintenance personnel maintain the streets, storm drainage, sanitary sewer  and potable water systems, along with all government buildings, parks and all City grounds.  The Department manages its expenditures and revenues through the following four (4)  maintenance funds and three (4) enterprise funds:  Government Buildings Fleet Maintenance Street Maintenance Parks Maintenance Water Fund* Sewer Fund* Street Light Utility Fund* Storm Water Fund* *Separate Enterprise Fund Budgets from those included here under the advisement of the Utility Commission of the City of Rosemount. The Public Works Department currently has a combined permanent work force of 27 positions  for the areas of engineering, buildings, fleet maintenance, streets, parks and the enterprise‐ funded utilities.  The City also utilizes seasonal employees to help during periods that require  higher levels of maintenance.     65 Government Buildings This budget provides for the management, operation, maintenance and repair of the City's  buildings. This includes City Hall, the MN DOT garage, the three Public Works buildings and pole  barn, Parks trailer, and two Fire Stations.  It also includes three (3) park shelters and the Family  Resource Center.  Maintenance and operation of the Community Center / Steeple Center / Ice  Arena is not included in this budget.    Fleet Maintenance  This budget provides for the maintenance of all City‐owned vehicles and roughly 300 units of  large and small equipment.  It provides funding for all fuels, oils, parts, tires, shop supplies, and  contracted vehicle maintenance. The City‐owned/leased vehicles include:  Police Department (1 minivan, 1 pickup truck, 16 SUVs, 3 shared SWAT units) Fire Department (17 units) Parks and Recreation (2 pickup trucks, 2 vans, 1 ice resurfacer) Administration / Community Development / Engineering (2 pickup trucks, 3 SUVs, 1 minivan) Utility Department (1 Jetter, 1 Vactor, 1 pump trailer, 6 pickup trucks) Streets and Parks Maintenance (2 sweepers, 3 tractors, 1 loader, 1 motor grader, 2 skidsters, 7 dump trucks, 1 water truck, 7 mowers, 24 pickup trucks, 1 pavement roller, 5 large trailers, 1 J‐D Gator, 1 sidewalk machine Holder, 2 field liner/groomer/sweeper Kubota) Street Maintenance  This budget provides for the maintenance and preservation of 119 miles of City roads, 111  miles of sidewalks and bike trails, and 25 parking lots.  Standard maintenance includes grading,  graveling, dust control, patching, sealing, overlays, pavement markings, sweeping, and snow  and ice control.  This budget also provides for street signs, signal light maintenance and power,  and all the hanging flower baskets, planters, park signs, entrance monuments and gardens at  City facilities and throughout the downtown area.  Parks Maintenance  This budget provides for the maintenance of over 767 acres of park space in 31 locations,  including 19 parks with turf athletic fields, 16 parks with shelters or pavilions, and numerous  athletic fields at DCTC, UMore, and the Flint Hills Athletic Complex.  It includes the maintenance  of all park trails and 12 other municipal areas, including City Hall, two Fire Stations and the  Community Center.  It also includes the installation and maintenance of 21 irrigation systems,  24 playgrounds, 5 outdoor ice rinks, and other miscellaneous construction activities. The  horticulturist coordinates and maintains 4 community gardens, 22 park signs, 4 entrance  monuments, 64 hanging baskets, and 25 RCC & downtown planters and all other landscaping  projects.   66 Performance Measures  0 10 20 30 40 50 60 70 80 90 2015 2016 2017 2018 2019 2020 2021 Average City Street Pavement Condition Rating Overall Rating Goal for Local Streets Goal for Collector Streets $124,057 $262,028 $244,620 $140,450 $351,505 $229,365 $88,084 $0 $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 2015 2016 2017 2018 2019 2020 2021 Road  Rehabilitation Cost Per  Paved Lane Mile 67 0.00% 2.00% 4.00% 6.00% 8.00% 10.00% 12.00% 14.00% 2015 2016 2017 2018 2019 2020 2021 Percentage of All Lane Miles Rehabilitated 6.5 7 7.5 8 8.5 9 2015 2016 2017 2018 2019 2020 2021 Average Hours for Full Snow Clearing Event 68 $0 $20,000 $40,000 $60,000 $80,000 $100,000 $120,000 $140,000 $160,000 $180,000 $200,000 0 100 200 300 400 500 600 700 2015 2016 2017 2018 2019 2020 2021 New Metric in 2017 Equipment Repair Hours Cost 0 50 100 150 200 250 2015 2016 2017 2018 2019 2020 2021 Park  Acres Maintained 69 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments ----------------------- --------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 101 41940 77 101.00 Salaries & Benefits 8,207 8,606 8,500 7,800 8,700 All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 101 41940 77 102.00 Full-Time Overtime - - - - - 101 41940 79 101.00 Salaries & Benefits 114,936 116,467 121,355 127,000 148,280 101 41940 79 102.00 Full-Time Overtime 5,366 3,298 4,178 3,000 3,000 101 41940 99 103.00 Part-Time Salaries & Benefits - 1,846 2,562 - - 101 41940 01 208.00 Miscellaneous Supplies 17,544 14,930 18,926 21,000 23,000 Cleaning, Paper Prod., Coffee 101 41940 01 209.00 Other Office Supplies - - 106 - - 101 41940 01 219.00 Flags & Flagpole Maintenance 4,847 1,544 1,479 3,000 3,000 Flags & Flag pole maintenance/repairs 101 41940 01 223.00 Building Repair Supplies 9,378 9,838 6,662 12,000 12,000 Light Bulbs, Locks, etc. 101 41940 01 225.00 Landscaping Materials 1,500 754 2,167 3,000 2,000 CH Landscape, Trees & Shrubs 101 41940 01 241.00 Small Tools 411 620 549 700 700 Carpentry, Bits, Blades, etc. 101 41940 01 242.00 Minor Equipment 385 948 1,141 1,200 1,200 101 41940 01 302.00 Architects' Fees - - - 101 41940 01 318.00 Contract Engineer - - - 101 41940 01 319.00 Other Professional Services 110,800 101 41940 01 319.01 Elevator Maintenance 3,657 2,005 2,081 2,500 City Hall elevator only 101 41940 01 319.02 Heating/Cooling Maint Contract 4,321 10,339 4,459 10,500 All City Facilities 101 41940 01 319.03 Annual Boiler Inspections / Maint.50 50 1,955 300 State of MN Required Inspection 101 41940 01 319.04 Pest Control 3,085 3,164 3,215 5,500 Boxelder Treatmt & Other Pest Controls 101 41940 01 319.05 Fire Extinguishers 1,562 1,060 1,858 1,800 Building Fire Exting & PD Portables 101 41940 01 319.06 Fire Suppression System Check 4,021 3,230 4,105 5,000 Prices have been increasing 101 41940 01 319.07 Janitorial Service-Fire Stations 11,000 11,000 12,514 12,000 101 41940 01 319.08 Janitorial Service-P.W. Building 12,000 12,000 13,292 12,000 101 41940 01 319.09 Janitorial Service-City Hall 28,000 28,000 31,494 28,000 101 41940 01 319.10 Floor Mats - Monthly Charges 5,540 5,836 5,631 6,000 Price Increase 101 41940 01 319.11 Other Janitorial Services 10,136 8,193 13,516 14,000 Grout CH, PD, FSs 101 41940 01 319.12 Bronze Monument Maintenance 1,075 1,075 1,075 1,500 Library Ornamental Feature 101 41940 01 321.00 Telephone Costs 892 992 899 1,000 1,000 Air Card for iPad-Monthly Chgs 101 41940 01 381.00 Electric Utilities 58,319 62,251 66,476 70,000 70,000 101 41940 01 383.00 Gas Utilities 48,711 39,198 47,257 50,000 50,000 101 41940 01 384.00 Refuse Disposal 75,000 101 41940 01 384.01 General Buildings & Parks 31,960 37,080 39,917 30,000 Flint Hills Trailhead Facility 101 41940 01 384.02 Recycling/Cleanup 28,086 33,036 34,394 30,000 Clean Up Day, Add'l Recycle Bins 101 41940 01 389.00 Other Utility Services - - - 5,000 - 101 41940 01 393.00 P.C. Hardware Purchases 107 - - 100 100 101 41940 01 394.00 P.C. Software Purchases 4,114 3,968 4,098 9,000 9,000 Cartegraph & ESRI GIS Software/Suppt 101 41940 01 401.00 Contracted Building Repairs 3,571 64,500 101 41940 01 401.01 Electrical Repairs 13,952 9,044 3,314 10,000 101 41940 01 401.02 Siren Operations & Maintenance 2,982 15,686 3,196 7,000 101 41940 01 401.03 Miscellaneous Repairs 29,357 26,808 40,059 30,000 101 41940 01 401.04 HVAC Repairs 14,471 13,178 7,099 17,500 101 41940 01 402.00 Security Card System Maintenance 2,631 5,042 2,140 5,000 6,000 Updates, Preventative Maint, Tech Sup 101 41940 01 416.00 Machinery Rental 806 650 614 1,500 1,500 Lift Rental 101 41940 01 437.00 Conferences & Seminars 321 147 647 500 500 License Continuing Ed 101 41940 01 439.00 Other Miscellaneous Charges 5,950 2,790 18,805 25,000 25,000 Park Shltrs, Irrigtn Sheds, LED swap 101 41940 01 530.00 Improvements Other Than Bldgs 159,964 575,000 58,500 50,000 50,000 From Long-Term Plan DEPARTMENT TOTALS 649,644 1,069,673 593,806 619,400 665,280 2023 BUDGET WORKSHEETS GOVERNMENT BUILDINGS 70 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments ----------------------- --------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 101 43100 77 101.00 Salaries & Benefits 28,929 30,510 57,167 57,500 61,295 All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 101 43100 77 102.00 Full-Time Overtime - - - - - 101 43100 78 101.00 Salaries & Benefits 11,625 8,263 - - - 101 43100 78 102.00 Full-Time Overtime - - - - - 101 43100 79 101.00 Salaries & Benefits 193,488 198,793 207,994 322,000 339,305 101 43100 79 102.00 Full-Time Overtime 10,720 7,623 7,437 7,000 7,000 101 43100 99 103.00 Part-Time Salaries & Benefits - - - - - 101 43100 01 211.00 Cleaning Supplies 3,462 1,722 2,901 4,000 4,000 Shop & Vehicles 101 43100 01 212.00 Motor Fuels 136,181 126,529 132,687 144,000 144,000 92.5% of Fuel Covered by Fleet 101 43100 01 213.00 Lubricants & Additives 8,173 9,583 9,057 12,000 12,000 101 43100 01 215.00 Shop Materials 15,784 17,867 19,363 20,000 22,000 101 43100 01 221.00 Equipment Parts 128,114 149,397 105,611 110,000 115,000 101 43100 01 222.00 Tires 26,401 29,180 32,645 30,000 35,000 More police squads in fleet. 101 43100 01 241.00 Small Tools 6,018 4,263 4,892 6,000 6,000 Replace Old Tools 101 43100 01 242.00 Minor Equipment 14,733 14,477 12,011 10,000 10,000 101 43100 01 318.00 Contract Engineer - - - - - 101 43100 01 321.00 Telephone Costs - 277 1,083 - - 101 43100 01 323.00 Radio Units (Warranty & Batteries)536 - - 2,000 1,000 New Chargers in 2019 101 43100 01 384.00 Refuse Disposal - - - 400 - Oil and Filter Disposal 101 43100 01 394.00 P.C. Software Purchases 11,000 101 43100 01 394.01 Licensing & Maintenance 4,114 3,968 4,813 4,500 CarteGraph OMS 101 43100 01 394.02 Online Subscriptions 3,110 5,645 2,597 5,000 ALLDATA/Cummings/CAT/Detroit 101 43100 01 394.03 New Software Purchases 4,001 - 1,289 2,000 101 43100 01 404.00 Contracted Mach & Equip Services 47,000 101 43100 01 404.01 Contracted Services 31,667 53,126 43,734 35,000 Repairs by vendor shops/specialty svcs 101 43100 01 404.02 Contracted Preventative Maint.10,000 4,999 12,700 5,000 Grout CH, PD, FSs 101 43100 01 416.00 Machinery Rental - - - 500 500 101 43100 01 433.00 Dues/Subscriptions/Certifications 294 371 - 400 400 Air Card for iPad-Monthly Chgs 101 43100 01 435.00 Books & Pamphlets 80 80 85 100 100 101 43100 01 437.00 Conferences & Seminars 623 - 727 800 800 DEPARTMENT TOTALS 638,053 666,673 658,794 778,200 816,400 2023 BUDGET WORKSHEETS FLEET MAINTENANCE 71 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments ----------------------- ---------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ------------------------------------------------------- 101 43121 77 101.00 Salaries & Benefits 89,473 92,136 100,260 114,000 122,635 All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 101 43121 77 102.00 Full-Time Overtime - - - - - 101 43121 78 101.00 Salaries & Benefits 56,890 54,574 72,723 98,000 165,800 101 43121 78 102.00 Full-Time Overtime 179 - - - - 101 43121 79 101.00 Salaries & Benefits 464,628 487,134 520,236 542,000 566,005 101 43121 79 102.00 Full-Time Overtime 21,018 11,443 7,512 14,000 14,000 101 43121 99 103.00 Part-Time Salaries & Benefits 23,085 26,277 34,585 33,000 33,000 101 43121 01 201.00 Office Accessories - - - 100 100 101 43121 01 203.00 Printed Forms & Paper - - - 101 43121 01 203.03 City Specification Books - - - 101 43121 01 205.00 Drafting Supplies - - 400 101 43121 01 205.01 Plotter Ink and Paper - - - 400 101 43121 01 209.00 Other Office Supplies 411 408 244 700 700 101 43121 01 216.00 Chemical & Chemical Products 72,382 89,862 81,821 100,000 100,000 Salt and Pretreatment Brine 101 43121 01 224.00 Street Maintenance Materials - 18,800 101 43121 01 224.01 Paint - 7 231 500 101 43121 01 224.02 Mail Boxes 5,596 2,447 1,061 4,000 101 43121 01 224.03 Light Bulbs/Lenses 696 - - 800 Replace with LED Bulbs 101 43121 01 224.04 Holiday Decorations 14,791 9,294 11,250 11,000 Tree Lghtg, Banners, Contracted Décor 101 43121 01 224.05 Miscellaneous 2,148 1,915 4,506 2,500 Fencing, Miscellaneous Supplies 101 43121 01 225.00 Landscaping Materials - 22,000 101 43121 01 225.01 Turf Restoration Material 2,098 644 2,879 3,000 Boulevard plow damage repairs 101 43121 01 225.03 Flowers - 16,267 15,902 18,000 Baskets, Planters, Parks, Bldgs 101 43121 01 225.04 Trees 1,625 1,233 1,528 500 101 43121 01 225.05 Hanging Baskets 2,944 - 41 101 43121 01 225.06 Entrance Monuments 1,349 - - 101 43121 01 225.07 Downtown Planters 1,642 - - 101 43121 01 225.08 Park Signs, Central Park 5,381 - - 101 43121 01 225.09 City Facilities 3,211 - - 101 43121 01 225.10 Banners/Flag Components - 159 - 500 For replanting/replacements 101 43121 01 226.00 Sign Repair Materials - 20,500 101 43121 01 226.01 Signs and Posts 9,436 13,762 12,287 18,000 Damed street sign/retroreflectivity replace 101 43121 01 226.02 Solar Batteries 697 65 - 500 101 43121 01 231.00 Bituminous Patching Materials 54,573 18,064 9,832 20,000 23,000 Street & Trail Patching 101 43121 01 232.00 Crushed Rock 27,867 29,504 21,925 23,000 23,000 Biscayne Base/Sfce Rprs near Hwy 3 '23 101 43121 01 233.00 Dust Control Materials 27,943 26,128 31,734 26,000 31,000 Chloride Treatments - State Bid 101 43121 01 234.00 De-Icing Sand / Rock 1,052 1,531 563 3,500 3,500 Gravel Road Ice Control (Chip Rock) 101 43121 01 240.00 Safety Equipment & PPE - 295 497 500 1,000 Vests, Glasses, Gloves, Hardhats, etc. 101 43121 01 241.00 Small Tools 1,151 1,161 2,525 1,200 1,200 Shovels, Brooms, etc. 101 43121 01 242.00 Minor Equipment 3,034 14,985 23,684 12,000 - Crash Attenuator Replacement in '23 101 43121 01 303.00 Engineering Fees 4,178 9,000 101 43121 01 303.01 General Non-Project Related 5,514 23,168 48,837 8,000 101 43121 01 303.02 Pavement Management - - - 1,000 101 43121 01 304.00 Legal Fees 7,660 1,341 1,954 3,000 3,000 101 43121 01 318.00 Contract Engineer - - - 101 43121 01 319.00 Other Professional Services 500 1,500 1/5 GIS Consulting, Fiber Locates 101 43121 01 319.02 GIS Consulting Services - - - 1,000 101 43121 01 321.00 Telephone Costs 2,264 3,203 2,480 5,000 5,000 Includes Wireless Technology 101 43121 01 323.00 Radio Units 6,282 5,538 1,409 1,000 1,000 101 43121 01 331.00 Travel Expense 92 57 17 200 200 101 43121 01 381.00 Electric Utilities 3,100 101 43121 01 381.01 Street Lights 174,628 - - - Moved to Separate Utility 101 43121 01 381.02 Signal Lights & Sirens 2,534 2,399 2,578 3,100 101 43121 01 384.00 Refuse Disposal 3,000 101 43121 01 384.01 Hazardous Waste Disposal - 230 - 500 101 43121 01 384.02 Roadside Garbage 1,044 1,901 1,817 2,000 Increasing demand/costs from dispos vndr 101 43121 01 391.00 P.C. Maintenance 800 101 43121 01 391.04 R-O-W Permit On-Line Service 710 593 659 800 Dakota CoOnline ROW Permit System 101 43121 01 392.00 P.C. Accessories & Supplies - 16 - - 101 43121 01 393.00 P.C. Hardware Purchases - 299 775 1,000 - 101 43121 01 394.00 P.C. Software Purchases 11,000 101 43121 01 394.01 Licensing & Maintenance 9,714 9,216 9,198 10,500 CarteGraph, ESRI, DataLink 101 43121 01 394.02 Online Subscriptions - - - 300 Pictometry 101 43121 01 394.03 New Software Purchases - - - 200 101 43121 01 402.00 Parking Lot Maintenance 89,785 370,048 20,817 50,000 75,000 From Long-Term Plan 101 43121 01 403.00 Contracted Repair & Maintenance 16,500 101 43121 01 403.01 Street Lights 6,691 - 741 - Moved to Separate Utility 101 43121 01 403.02 Signal Lights 507 544 2,425 1,500 2023 BUDGET WORKSHEETS STREET MAINTENANCE 72 Page 2 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments ----------------------- ---------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ------------------------------------------------------- 2023 BUDGET WORKSHEETS STREET MAINTENANCE 101 43121 01 403.03 Light Replacements - - - 10,000 Conversion to LED 101 43121 01 403.04 Miscellaneous Repairs - 11,464 7,670 5,000 Curb Painting, etc. 101 43121 01 404.00 Railroad Administration/Mgmt.- 1,025 - 10,000 10,000 Bonaire Path RR Crossing Maint Fee 101 43121 01 405.00 Street Striping 25,523 - 8,558 - -Moved to "408.00" 101 43121 01 407.00 Bituminous Overlays - - 11,367 - - 101 43121 01 408.00 Crackseal, Sealcoat, Patch, Stripe 214,417 238,329 284,153 270,000 300,000 Needs increasing in 2023 101 43121 01 409.00 Tree Trimming 19,677 24,311 46,253 30,000 35,000 101 43121 01 410.00 Concrete Sidewalk/Curb Repairs 20,000 101 43121 01 410.01 General Repairs 13,605 11,086 14,990 20,000 101 43121 01 411.00 Contracted Snow Removal 18,000 101 43121 01 411.04 Dakota County Library 22,092 6,044 5,741 18,000 101 43121 01 415.00 Equipment Rental 12,268 24,543 21,141 25,000 25,000 Umore, Track-Hoe, Lift, Skid Steer, etc. 101 43121 01 433.00 Dues & Subscriptions 1,800 101 43121 01 433.01 American Public Works Ass'n 955 900 1,250 1,100 Annual Agency APWA Membership 101 43121 01 433.03 City Engineers' Association - 400 375 400 Add Assistant City Engineer 101 43121 01 433.07 MN Street Superintendent Ass'n 150 200 - 200 101 43121 01 433.09 MN Transportation Alliance - - 219 - 101 43121 01 437.00 Conferences & Seminars 335 9,900 101 43121 01 437.01 APWA 510 - 335 500 Spring Conf, Fall Conf, & PWX (National) 101 43121 01 437.03 Clerical - - - - 101 43121 01 437.05 Maintenance Expo - - 180 400 101 43121 01 437.06 Cartegraph, ESRI, GIS - 326 934 500 User Group, Conference, Training 101 43121 01 437.07 Snow Conference - -- 300 101 43121 01 437.08 MN Dot 369 - - - 101 43121 01 437.09 Miscellaneous Training 1,165 2,151 944 5,000 Smart Salt Trng, DCTC Def. Driver 101 43121 01 439.00 Other Miscellaneous Charges 832 314 281 800 800 CONDAC Lunch, CDL Licenses 101 43121 01 570.00 Office Equipment & Furnishings - - - - - _ DEPARTMENT TOTALS 1,514,286 1,638,944 1,460,437 1,534,500 1,696,240 73 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments ----------------------- --------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ------------------------------------------------------ 101 45202 77 101.00 Salaries & Benefits 38,507 39,916 48,700 50,000 52,600 All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 101 45202 77 102.00 Full-Time Overtime - - - - - 101 45202 78 101.00 Salaries & Benefits 23,249 16,526 - - - 101 45202 78 102.00 Full-Time Overtime - - - - - 101 45202 79 101.00 Salaries & Benefits 406,776 478,693 517,413 448,000 463,455 101 45202 79 102.00 Full-Time Overtime 15,749 12,667 14,307 8,000 8,000 101 45202 99 103.00 Part-Time Salaries & Benefits 68,789 61,757 77,784 76,000 76,000 101 45202 01 205.00 Plotter Ink and Paper - - - 400 400 101 45202 01 216.00 Chemical & Chemical Products 43,427 42,265 49,815 50,000 60,000 Fertilizer & POA Control 101 45202 01 216.02 Fertilizer - - 165 - 101 45202 01 219.00 Other Operating Supplies 300 55,000 101 45202 01 219.01 Seed, Sod, etc.1,948 4,123 8,291 10,000 For Topdressing and Natural Settings 101 45202 01 219.02 Red Rock, Sand, Gravel, etc.21,219 17,122 12,223 20,000 101 45202 01 219.05 Wood Chips 18,000 20,000 20,000 22,000 101 45202 01 220.00 Splash Pad Maintenance 3,488 13,196 1,470 4,000 - 101 45202 01 221.00 Equipment Parts 38,000 101 45202 01 221.01 Playground Equipment Repair 15,338 25,170 13,370 20,000 Repairs on Aging Equipment 101 45202 01 221.02 Irrigation Repair(In-House)5,920 8,142 9,468 8,000 101 45202 01 221.03 Miscellaneous 3,107 1,678 3,762 3,000 101 45202 01 221.04 Park Sign Replacements 474 - - - 101 45202 01 223.00 Shelter Repair Supplies 2,100 101 45202 01 223.01 Paint, Stain, etc.12 132 441 500 101 45202 01 223.02 Shingles, Boards, etc.597 147 1,391 800 101 45202 01 223.03 Miscellaneous 510 1,353 460 800 101 45202 01 225.00 Landscaping Materials 3,500 101 45202 01 225.01 Trees, Shrubs, etc.2,085 2,000 717 2,000 101 45202 01 225.02 Timbers, Fence, etc.- 243 1,362 1,000 101 45202 01 226.00 Sign Repair Materials - -36 500 500 101 45202 01 229.00 Other Maintenance Supplies 10,711 19,308 18,636 15,000 20,000 Paint, Chalk, Field Dry, Etc. 101 45202 01 240.00 Safety Equipment & PPE - 491 407 500 1,000 Vests, Glasses, Gloves, Hardhats, etc. 101 45202 01 241.00 Small Tools 1,950 2,418 2,370 2,500 2,500 Hand Tools, Blades, Bits, etc. 101 45202 01 242.00 Minor Equipment 4,725 4,276 3,425 7,500 7,500 Battery Backpack, Blower, etc. 101 45202 01 303.00 Engineering Fees (GIS)- - 4,605 1,000 1,000 $5,000 Split 5 Ways 101 45202 01 318.00 Contract Engineer - - - - 101 45202 01 319.00 Other Professional Services 26,000 101 45202 01 319.01 Maintenance of Open Spaces 8,930 14,774 14,650 15,000 Controlled Burns, etc. 101 45202 01 319.02 Landscaping & Flower Beds 5,985 6,000 11,776 8,000 Contracted assistance with small projects 101 45202 01 321.00 Telephone Costs 3,955 4,625 4,781 6,500 6,500 All Wireless, iPads, Irrig. Controls 101 45202 01 323.00 Radio Units 6,282 7,492 1,409 1,000 1,000 101 45202 01 381.00 Electric Utilities 26 25,000 Anticipated Rate Increase 101 45202 01 381.01 Skating Rinks 6,832 6,193 6,199 7,000 Svc Conn/Disconn-Portable Warm House 101 45202 01 381.02 Softball Fields 6,292 6,223 6,905 8,500 Flint Hills & UMore Fields 101 45202 01 381.03 Irrigation 7,524 9,670 12,734 9,500 101 45202 01 383.00 Gas Utilities 1,787 1,669 1,746 - - 101 45202 01 393.00 P.C. Hardware Purchases - - - 2,500 2,500 101 45202 01 394.00 P.C. Software Purchases 1,000 20,500 101 45202 01 394.01 Licensing & Maintenance 9,214 11,716 17,759 17,500 Cartegraph, ESRI, DataLink, GPS 101 45202 01 394.02 Online Subscriptions - - - 300 Pictometry 101 45202 01 394.03 New Software Purchases - - - 200 101 45202 01 403.00 Contracted Repair & Maintenance 22,500 101 45202 01 403.01 Irrigation Repairs 7,160 7,033 7,737 7,500 Required RPZ Inspections & Repairs 101 45202 01 403.02 Electrical Repairs 6,331 4,854 736 5,000 101 45202 01 403.03 Miscellaneous Repairs 6,003 2,181 5,380 4,000 Hard Court Fencing 101 45202 01 403.04 Playground Repairs - 5,590 - 4,000 Contracted Repairs 101 45202 01 409.00 Other Contracted Repair & Maint 17,800 101 45202 01 409.01 Spring Clean Up 500 500 250 500 Dethatching, Flower Beds, etc. 101 45202 01 409.02 Library / Steeple Center / RCC 8,487 8,547 8,541 9,000 Mowing/Chemicals - VonBank 101 45202 01 409.03 Fire Station #1 - - - - 101 45202 01 409.04 Fire Station #2 - - - - 101 45202 01 409.05 City Hall 2,829 2,849 2,847 2,800 Mowing/Chemicals - VonBank 101 45202 01 409.06 UMore Baseball Fields 2,400 - 2,500 2,500 101 45202 01 409.07 FHR Soccer Fields 94 - 2,500 3,000 101 45202 01 416.00 Machinery Rental 592 38,000 101 45202 01 416.01 Mower Leases 21,200 21,352 21,200 23,000 101 45202 01 416.02 Miscellaneous Rentals 3,161 5,000 12,157 13,000 Umore, Compr, Mower, Truck Ren, Parks 101 45202 01 433.00 Dues & Subscriptions 2,325 400 2023 BUDGET WORKSHEETS PARKS & GROUNDS MAINTENANCE 74 Page 2 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments ----------------------- --------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ------------------------------------------------------ 2023 BUDGET WORKSHEETS PARKS & GROUNDS MAINTENANCE 101 45202 01 433.01 MN Park Supervisors Ass'n 288 - 138 100 101 45202 01 433.02 Miscellaneous Dues 80 185 20 300 101 45202 01 435.00 Books & Pamphlets - 53 - 101 45202 01 437.00 Conferences & Seminars 6,000 101 45202 01 437.01 Seminars & Workshops 1,045 1,443 1,307 2,500 Green Expo, MPSA, Playgrounds 101 45202 01 437.02 School & Tuition 1,988 665 1,332 2,000 Turf School, Power Limited Tech. 101 45202 01 437.03 CarteGraph, ESRI, GIS - 326 934 500 User Group, Conference,Training 101 45202 01 439.00 Other Miscellaneous Charges 38 66 - 200 200 101 45202 01 530.00 Improvements Other Than Bldgs 299,441 670,144 288,771 75,000 100,000 From Long-Term Plan DEPARTMENT TOTALS 1,104,428 1,570,775 1,248,169 983,400 1,057,955 75 Parks and Recreation Department  The Parks and Recreation Department works together with citizens to provide a safe, healthy  and pleasant community.  Parks and recreation are essential services that can impact health,  crime prevention, the environment, the economy and the quality of life for Rosemount  residents.  Administration  Provides for overall planning, coordination, management of personnel and administration of  activities within the department of Parks and Recreation.  This department provides a  diversified range of activities and facilities for the residents of Rosemount.  The long‐range  planning, budget preparation and development of parks and coordination with other service  agencies are ongoing activities.  Administrative services also provide the residents of  Rosemount an opportunity to reserve facilities and register for programs.  Recreation  Provides the Rosemount resident a variety of recreational activities serving all ages.  Program  offerings are based on the needs of residents as determined and evaluated by the Parks and  Recreation Commission and staff.  Coordination with other service agencies encourages a  comprehensive, quality and efficient base of programs.    Community Center  Provides for operation of a multi‐purpose Community Center, which offers facilities for  recreational programs, banquets, meetings, events, theatrical productions, seminars and  exercise.  The Community Center provides services in the form of meeting space, gym space for  community groups and sponsorship of community events.  The Parks and Recreation  Department provides ongoing, preventive maintenance and janitorial services of the  Community Center and portions of the National Guard facilities.  Steeple Center  Provides the operations of the Steeple Center which opened in 2010 in the former St. Joseph’s  church building at the north end of Downtown Rosemount.  The Center is available for  weddings, banquets, meetings, parties, performances and special events.  Staff coordinates the  rentals, maintenance and capital improvement projects of the facility.  In 2015, a 10,000 square  foot addition which features a lobby area with a beautiful fireplace, gorgeous floor to ceiling  windows and café‐style seating, which is open to the general public.  It is a great place to stop  in for a cup of coffee, play a card or board game with a friend.  The Steeple Center is home to  the Rosemount Area Seniors and all senior programming as well as many classes and events  hosted by the Rosemount Area Arts Council. 76 Performance Measures  20,015  16,068  14,577 15,361 16,022  4,325  22,332  11,769 12,564  10,870 10,851 11,144  1,100  12,261  ‐ 5,000  10,000  15,000  20,000  25,000  2015 2016 2017 2018 2019 2020 2021 Community Center Use Total Hours No Charge Hours $0 $20,000 $40,000 $60,000 $80,000 $100,000 $120,000 $140,000 $160,000 2015 2016 2017 2018 2019 2020 2021 Community Center Rental Income 77 ($5,000) $15,000 $35,000 $55,000 $75,000 $95,000 $115,000 2015 2016 2017 2018 2019 2020 2021 Revenues $89,022 $107,314 $104,927 $98,274 $96,736 $20,276 $89,432 Expenses $87,272 $87,098 $98,017 $97,826 $82,492 $21,587 $83,459 Net $1,750 $20,216 $6,921 $421 $14,244 ($1,311) $5,973 All Recreation Programs 537.65 540.84 540.84 540.84 540.84 540.84 541.43 535 536 537 538 539 540 541 542 2015 2016 2017 2018 2019 2020 2021 Dunmore, Caramore, and Bester added in 2021 Acres in Park System 78 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments ----------------------- -------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 101 45100 101.00 Salaries & Benefits 882,233 863,674 939,123 1,007,500 1,106,700 All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 101 45100 102.00 Full-Time Overtime 1,980 1,633 3,481 5,000 5,000 101 45100 103.00 Part-Time Salaries & Benefits 255,209 220,218 247,409 287,800 299,000 101 45100 01 205.00 Drafting Supplies 500 300 435 500 500 101 45100 01 208.00 Miscellaneous Supplies 500 192 - - - 101 45100 01 209.00 Other Office Supplies 235 375 23 500 500 101 45100 01 211.00 Cleaning Supplies 4,417 4,468 4,356 4,500 4,500 101 45100 01 216.00 Chemicals & Chemical Products - - - - - 101 45100 01 219.00 Other Operating Supplies 10,500 12,310 8,723 10,000 10,000 Rec Programs, 1st Aid Sup, etc. 101 45100 01 221.00 Equipment Parts 11,138 6,012 8,096 8,000 8,000 101 45100 01 223.00 Building Repair Supplies 1,182 1,034 1,587 1,500 1,500 101 45100 01 225.00 Landscaping Materials - - - - - 101 45100 01 229.00 Other Maintenance Supplies 2,622 2,913 2,919 3,000 3,000 Tournament Supplies 101 45100 01 312.00 Custodial Services 8,960 700 6,160 6,000 6,000 Custodial Services-Banquet Rm 101 45100 01 315.00 Special Programs 10,000 52,600 Includes community events 101 45100 01 315.01 Movies/Concerts 5,884 7,419 11,057 6,000 Performances 101 45100 01 315.02 Leprechaun Days 562 - 755 500 101 45100 01 315.03 Umore Maint. Agreement 2,156 2,156 2,339 2,000 101 45100 01 315.04 Ground Pounders(Running)- - 200 200 Ribbons & Mailings 101 45100 01 315.06 Puppet Programs - - - 100 101 45100 01 315.07 Special Events 12,568 3,926 11,038 16,000 Food Truck Fest / Arts Festival 101 45100 01 315.08 Adopt-A-Park Program - 164 48 500 Flyers, Signs 101 45100 01 315.09 Miscellaneous Programs 9,644 5,335 8,535 8,000 Community Gardens & Other Prog. 101 45100 01 315.10 ADA Programs - - - 400 ADA Program Supplies 101 45100 01 315.11 Senior Programs 705 1,634 141 3,000 101 45100 01 319.00 Other Professional Services 5,770 13,110 5,147 6,000 6,000 ADA Services/Eng.LA Serv Test 101 45100 01 321.00 Telephone Costs 4,620 4,112 3,918 4,500 4,500 Cellular Phones 101 45100 01 331.00 Travel Expense 355 10 - 1,000 1,000 101 45100 01 349.00 Other Advertising 900 42,000 101 45100 01 349.01 Brochures 34,284 33,235 35,099 35,000 City Newsletter (3 Per Year) 101 45100 01 349.03 Special Marketing 5,879 1,110 5,600 7,000 101 45100 01 381.00 Electric Utilities 28,067 27,913 32,119 30,000 30,000 101 45100 01 383.00 Gas Utilities 21,051 15,315 20,090 20,000 20,000 101 45100 01 384.00 Refuse Disposal 2,844 2,774 2,774 3,200 3,200 101 45100 01 401.00 Contracted Building Repairs 9,041 7,031 13,808 8,000 8,000 101 45100 01 404.00 Contracted Mach & Equip Repairs 29,919 27,756 23,114 18,000 18,000 101 45100 01 409.00 Other Contracted Repair & Maint 23,364 26,919 19,250 24,000 24,000 Air Handler Maintenance Contract 101 45100 01 411.00 Contracted Snow Removal 32,524 19,230 14,296 22,000 22,000 Community Center 101 45100 01 412.00 Building Rental 16,800 36,960 20,160 22,000 22,000 Monthly Rent Payments to Guard 101 45100 01 415.00 Other Equipment Rental 27,254 24,421 40,732 28,000 28,000 Portable Toilets & Other(New Pks) 101 45100 01 433.00 Dues & Subscriptions 606 22,100 101 45100 01 433.01 MRPA Dues 1,619 2,124 1,619 2,100 Minn Recreation & Parks Ass'n 101 45100 01 433.02 Miscellaneous 2,762 7,353 8,754 6,500 Paper, Magazines, Cartegraph,etc. 101 45100 01 433.03 On-Line Registrat'n Subscription 869 2,565 - 13,500 101 45100 01 435.00 Books & Pamphlets - - - 100 - 101 45100 01 437.00 Conferences & Seminars 372 7,000 101 45100 01 437.01 MRPA State Conference 1,192 450 475 3,000 101 45100 01 437.03 Workshops, Schools, & Tuition 1,966 109 772 4,000 101 45100 01 439.00 Other Miscellaneous Charges 5,278 3,999 8,107 - - 101 45100 01 530.00 Improvements Other Than Bldgs 15,092 - - - - DEPARTMENT TOTALS 1,481,544 1,390,961 1,514,139 1,638,900 1,755,100 2023 BUDGET WORKSHEETS PARKS & RECREATION 79 Page 2 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments ----------------------- -------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 2023 BUDGET WORKSHEETS PARKS & RECREATION 101 45100 30 103.00 Building Attendants 86,975 37,143 61,564 65,000 65,000 Salary, Taxes, PERA & Benefits 101 45100 30 211.00 Cleaning Supplies 3,413 464 1,597 4,000 3,500 101 45100 30 219.00 Other Operating Supplies 6,344 2,410 3,332 6,000 6,000 Events Supplies 101 45100 30 221.00 Equipment Parts 2,682 1,045 2,476 3,000 3,000 101 45100 30 223.00 Building Repair Supplies 3,125 1,595 702 4,000 4,000 101 45100 30 241.00 Small Tools - 45 - 500 - 101 45100 30 242.00 Minor Equipment 1,489 - - 1,000 1,000 101 45100 30 312.00 Custodial Services 1,400 - 1,120 1,000 1,000 101 45100 30 321.00 Telephone Costs 601 570 476 500 500 101 45100 30 349.00 Other Advertising 900 900 900 1,500 1,500 101 45100 30 381.00 Electric Utilities 16,147 14,907 18,706 16,000 17,000 101 45100 30 383.00 Gas Utilities 8,540 3,357 3,087 7,500 7,500 101 45100 30 384.00 Refuse Disposal 899 775 901 700 900 101 45100 30 401.00 Contracted Building Repairs 8,162 2,514 12,199 4,000 4,000 101 45100 30 404.00 Contracted Mach & Equip Repairs 15,941 29,454 33,197 20,000 20,000 101 45100 30 409.00 Other Contracted Repairs & Main 2,500 701 - 2,500 2,500 101 45100 30 411.00 Contracted Snow Removal 27,962 6,794 5,171 21,000 10,000 Steeple Center 101 45100 30 415.00 Other Equipment Rental - - - - - 101 45100 30 439.00 Other Miscellaneous Charges - - - - - TOTAL STEEPLE CENTER EXPENDITURES: 187,079 102,675 145,427 158,200 147,400 PARKS & RECREATION - STEEPLE CENTER 80 Page 3 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments ----------------------- -------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 2023 BUDGET WORKSHEETS PARKS & RECREATION 101 45100 81 Softball - - 480 - - 101 45100 81 103.00 Part-Time Salaries ----- 101 45100 81 219.00 Operating Supplies --480 -- 101 45100 81 311.00 Officiating Fees ----- 101 45100 81 319.00 Other Professional Services ----- 101 45100 84 Tennis 1,521 - 1,191 2,200 2,200 101 45100 84 103.00 Part-Time Salaries 1,475 -1,191 1,700 1,700 101 45100 84 219.00 Operating Supplies 46 --500 500 101 45100 84 311.00 Officiating Fees ----- 101 45100 84 319.00 Other Professional Services ----- 101 45100 86 Rosettes 1,344 - - - - 101 45100 86 103.00 Part-Time Salaries 490 ---- 101 45100 86 219.00 Operating Supplies 855 ---- 101 45100 86 311.00 Officiating Fees ----- 101 45100 86 319.00 Other Professional Services ----- 101 45100 87 Senior Programs 12,752 3,713 10,614 14,000 14,000 101 45100 87 103.00 Part-Time Salaries ----- 101 45100 87 219.00 Operating Supplies - 101 45100 87 219.01 Youth/Teen Trips Supplies ----- 101 45100 87 219.02 Adult/Senior Supplies 12,752 3,713 10,614 14,000 14,000 101 45100 87 311.00 Officiating Fees ----- 101 45100 87 319.00 Other Professional Services ----- 101 45100 90 Run for the Gold 3,559 - 3,300 6,000 6,000 101 45100 90 103.00 Part-Time Salaries ----- 101 45100 90 219.00 Operating Supplies 3,559 -3,300 6,000 6,000 101 45100 90 311.00 Officiating Fees ----- 101 45100 90 319.00 Other Professional Services ----- 101 45100 91 Camps 37,382 9,765 46,957 40,000 40,000 101 45100 91 103.00 Part-Time Salaries 9,390 7,116 21,807 18,000 18,000 101 45100 91 219.00 Operating Supplies 27,992 2,649 25,150 22,000 22,000 101 45100 91 311.00 Officiating Fees ----- 101 45100 91 319.00 Other Professional Services ----- 101 45100 92 Adult Basketball - - - 600 - 101 45100 92 103.00 Part-Time Salaries ----- 101 45100 92 219.00 Operating Supplies ---600 600 101 45100 92 311.00 Officiating Fees ----- 101 45100 92 319.00 Other Professional Services ----- 101 45100 93 Other Programs 18,910 8,109 15,921 14,000 14,000 101 45100 93 103.00 Part-Time Salaries 2,370 -2,839 3,000 3,000 101 45100 93 219.00 Operating Supplies 16,540 8,109 13,082 11,000 11,000 101 45100 93 311.00 Officiating Fees ----- 101 45100 93 319.00 Other Professional Services ----- 101 45100 95 T-Ball 4,012 - 2,177 5,000 5,000 101 45100 95 103.00 Part-Time Salaries 2,762 -1,303 3,500 3,500 101 45100 95 219.00 Operating Supplies 1,250 -874 1,500 1,500 101 45100 95 311.00 Officiating Fees ----- 101 45100 95 319.00 Other Professional Services ----- 101 45100 96 Adult Enrichment - - - 500 - 101 45100 96 103.00 Part-Time Salaries ----- 101 45100 96 219.00 Operating Supplies ---500 500 101 45100 96 311.00 Officiating Fees ----- 101 45100 96 319.00 Other Professional Services ----- 101 45100 97 Adult Exercise Classes - - 620 500 - 101 45100 97 103.00 Part-Time Salaries ----- 101 45100 97 219.00 Operating Supplies --620 500 500 101 45100 97 311.00 Officiating Fees ----- 101 45100 97 319.00 Other Professional Services ----- 101 45100 98 Youth Soccer Lessons 3,012 - 2,198 2,800 2,800 101 45100 98 103.00 Part-Time Salaries 2,193 -1,356 1,800 1,800 101 45100 98 219.00 Operating Supplies 819 -841 1,000 1,000 PARKS & RECREATION - SPECIAL PROGRAMS 81 Page 4 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments ----------------------- -------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 2023 BUDGET WORKSHEETS PARKS & RECREATION 101 45100 98 311.00 Officiating Fees ----- 101 45100 98 319.00 Other Professional Services ----- TOTAL SPECIAL PROGRAMS EXPENDITURES: 82,492 21,587 83,459 85,600 84,000 GRAND TOTAL PARKS & RECREACTION: 1,751,115 1,515,223 1,743,025 1,882,700 1,986,500 82 Other Financing Uses – Transfers  This is a transfer set up beginning in 2007 for the assistance from the General Fund to the  Arena Fund for the operations of the arena.  83 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------- ---------- --------------------------------------------------- ----------------- ----------------------------------- ----------------- ----------------- ------------------------------------------------------ 101 49300 01 710.00 Transfers 130,000 130,000 130,000 -130,000 101 49300 01 710.01 Arena Operations Assistance - - - 130,000 - 101 49300 01 710.02 Debt Service Levies - - - - - 101 49300 01 720.00 Transfers 169,000 135,000 - - - Excess F/B Transfers (2018/19/20) DEPARTMENT TOTALS 299,000 265,000 130,000 130,000 130,000 2023 BUDGET WORKSHEETS OTHER FINANCING USES 84 10‐Year Capital Improvement Plan (CIP)  Background  Historically, the City of Rosemount has usually had a 5‐year CIP in place to utilize for its capital  improvements. There have been times where just a single year’s capital improvements have been  addressed and funded. As the City continues to grow, we believe that the careful development and  continuous utilization of a realistic Capital Improvement Plan is essential to the proper management  of the City. As we looked at developing a new 5‐year CIP, it became apparent that the dilemma that  the City of Rosemount faces is one of continued growth combined with restoration/reconstruction  of the older portions of our city. This being the case, it was almost impossible to develop a plan for a  5‐year period that was very realistic. As work continued on the plan, we decided to explore the  possibility of looking out farther and developing a longer plan that would more realistically allow us  to plan for the City’s future. This evolved into a 10‐year Capital Improvement Plan.  We believe that  great strides have been made to more accurately plan for the future of the City of Rosemount.  This  document is only a working guide that is utilized by the City Council and its staff to prepare for the  future. The first year of the plan will be included as part of the formal budget that is prepared yearly  as part of our Truth‐in‐Taxation process with the following years developed as a working tool for  future years’ discussions.  General / Administrative  The CIP provides for specific funding of items, the nature of which is not considered “current” in  their use or life expectancy. These items are generally of a higher estimated cost than $5,000 and  will have a life expectancy of three years or greater. The source of funding for these expenditures is  typically the general tax levy. In some instances, other funding is utilized. For example, beginning in  1996, revenues received from user fees are being designated in various CIP funds for capital  improvement and equipment purchases. If these revenues are realized, the equipment or project  will be completed and if the revenue is not realized the equipment will not be purchased. Individual  departments are designated for each item proposed for purchase in this plan.  Types of Capital Improvement Funds  Another area of change for the CIP is the implementation of three separate funds to isolate and  better track the types of capital improvements being planned for. The following briefly describes  each of the three:  Building & Facilities CIP Fund ‐ This fund is used to account for the on‐going capital improvements and possible additions to government buildings and other facilities. Street CIP Fund ‐ This fund is used to account for the on‐going street construction and reconstruction projects within the City and all other major maintenance items related to both paved and unpaved streets including, but not limited to, street lights, signal lights, sidewalks and gravel road resurfacing. Equipment CIP Fund ‐ This fund is used to account for the on‐going replacement of and additions to City equipment. 85 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 202 31010.00 Current Ad Valorem Taxes - - - - - 202 33100.00 Federal Grants & Aids - - - - - _ 202 33425.00 Other State Grants & Aids 423,123 26,877 - - - First $375,000 to Gen'l Fund 202 34150.00 SKB User Fees - C & D Cells 427,621 529,125 513,253 1,300,000 - (Next $125,000 to Street CIP) 202 34151.00 SKB User Fees - Excess Trust - - - - - $1.3m moved to 2023A/B Bonds 202 34152.00 SKB User Fees - MSW Ash 68,778 96,830 98,712 - - 202 34153.00 SKB User Fees - Base Charges 1,135,321 1,230,097 1,365,420 - - 202 36101.00 Principal - Special Assessments - - - - - 202 36102.00 Penalties & Interest - S/A - - - - - 202 36210.00 Interest Earnings - Investments 69,977 48,596 (53,680) 24,500 27,500 202 36214.00 Net Change in FV-Investments (702) (1,538) - - - 202 36215.00 Interest Earnings 6,745 3,954 1,444 500 - 202 36230.00 Contributions/Donations - - - - - 202 36260.00 Other Revenue - - - - - 202 36265.00 Use of Reserve Funds - - - - - 202 39201.00 Transfer From General Fund 169,000 - - - - DEPARTMENT REVENUES 2,299,864 1,933,939 1,925,148 1,325,000 27,500 202 49002 01 317.00 General Fund Administrative Fees 2,500 2,500 2,500 2,500 2,500 Yearly Fee Per Policy F-3 202 49002 01 319.00 Other Professional Services - - - - - 202 49002 01 510.00 Land Purchases 171,249 20,102 - - - 202 49002 01 521.00 Building & Structure Purchases 6,868 - 13,316 - - 202 49002 01 522.00 Building & Structure Purchases - - - 500,000 - 202 49002 01 523.00 Building & Structure Purchases - - - - 18,000 Steeple Center Assembly Hall Chairs 202 49002 01 524.00 Building & Structure Purchases - - - - 30,000 Banquet Hall Sound System and AV 202 49002 01 525.00 Building & Structure Purchases - - - - - 202 49002 01 526.00 Building & Structure Purchases - - - - - 202 49002 01 527.00 Building & Structure Purchases - - - - - 202 49002 01 528.00 Building & Structure Purchases - - - - - 202 49002 01 529.00 Building & Structure Purchases - - - - - 202 49002 01 530.00 Improvements Other Than Bldgs 3,698 15,000 8,019 - 300,000 FS1 Windows & Exterior 202 49002 01 531.00 Improvements Other Than Bldgs 30,000 24,997 28,355 - - 202 49002 01 532.00 Improvements Other Than Bldgs 1,074,174 150,000 - - - 202 49002 01 533.00 Improvements Other Than Bldgs - 68,687 2,632,008 - - 202 49002 01 534.00 Improvements Other Than Bldgs 40,852 861 - - - 202 49002 01 535.00 Improvements Other Than Bldgs - 42,848 - - - 202 49002 01 536.00 Improvements Other Than Bldgs - -- - - 202 49002 01 537.00 Improvements Other Than Bldgs - - 16,321 - - 202 49002 01 538.00 Improvements Other Than Bldgs 9,957 9,966 3,080 - - 202 49002 01 539.00 Improvements Other Than Bldgs 24,705 24,995 24,960 25,000 25,000 Picnic Table Replacement Program 202 49002 01 540.00 Improvements Other Than Bldgs - - - - - 202 49002 01 542.00 Improvements Other Than Bldgs - 242,225 - - - 2020 - Aerial Truck Down Pymt 202 49002 01 560.00 Furniture & Fixture Purchases - -- - - 202 49002 01 570.00 Office Equipment & Furnishings - -- - - 202 49002 01 580.00 Other Equipment Purchases - 27,190 - - - 202 49002 01 598.00 Council Designated - -- - - 202 49002 01 611.00 Interest on Lease Payments - - - - - 202 49002 01 710.00 Transfers - - - - - DEPARTMENT EXPENDITURES 1,364,002 629,370 2,728,560 527,500 375,500 NOTE: 2023's Proposed Budget Includes $2,500 for General Fund Admin Fees Not Included in Levy Amount (Covered by Interest Earnings) 2023 BUDGET WORKSHEETS BUILDING CIP 86 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 203 31010.00 Current Ad Valorem Taxes 852,327 877,897 904,234 931,361 959,302 203 33419.00 MSA for Streets - Construction - - - - - 203 33620.00 Other County Grants & Aids - - - - - 203 34150.00 SKB User Fees - C & D Cells - 979 47,019 125,000 125,000 First $375,000 to Gen'l Fund 203 34152.00 SKB User Fees - MSW Ash - 5,339 11,555 - - 203 34153.00 SKB User Fees - Base Charges 125,000 118,682 66,427 - - 203 36101.00 Principal - Special Assessments 328,613 1,493,467 18,369 150,000 150,000 203 36101.01 Principal - Special Assessments - - 213,377 - - 203 36101.02 Principal - Special Assessments - - 66,566 - - 203 36101.04 Principal - Special Assessments - - 92,654 - - 203 36101.05 Principal - Special Assessments - - 8,245 - - 203 36101.06 Principal - Special Assessments - - 156,397 - - 203 36101.08 Principal - Special Assessments - - 11,419 - - 203 36101.11 Principal - Special Assessments - - 1,903 - - 203 36102.00 Penalties & Interest - S/A 579 356 297 - - 203 36210.00 Interest Earnings - Investments 93,310 38,437 28,491 25,000 25,000 203 36214.00 Net Change in FV-Investments 30,224 19,100 (19,100) - - 203 36215.00 Interest Earnings 6,649 4,928 1,177 1,000 - 203 36260.00 Other Revenue - 337,256 - - - 203 36265.00 Use of Reserve Funds - - - - - 203 39203.00 Transfer From_________________ 68,182 - 209,746 - - DEPARTMENT REVENUES 1,504,884 2,896,441 1,818,777 1,232,361 1,259,302 203 49003 01 303.00 Engineering Fees - - - - - 203 49003 01 317.00 General Fund Administrative Fees 2,500 2,500 2,500 2,500 2,500 Yearly Fee Per Policy F-3 203 49003 01 319.00 Other Professional Services - - - - - 203 49003 01 530.00 Improvements Other Than Bldgs - - - - 950,000 Akron Ave Extension (Amber Fields) 203 49003 01 531.00 Improvements Other Than Bldgs - - - 1,100,000 - 203 49003 01 531.00 Pavement Management Program 203 49003 01 532.00 Improvements Other Than Bldgs 123,812 125,000 40,677 125,000 125,000 Pedestrian Improvements Program 203 49003 01 533.00 Improvements Other Than Bldgs - - - - 1,500,000 Blaine Ave Upgrades (Project Bigfoot) 203 49003 01 534.00 Improvements Other Than Bldgs - - - - - 203 49003 01 535.00 Improvements Other Than Bldgs - - 116,351 - - 203 49003 01 536.00 Improvements Other Than Bldgs - - - - - 203 49003 01 537.00 Improvements Other Than Bldgs - - - - - 203 49003 01 538.00 Improvements Other Than Bldgs - - - - - 203 49003 01 539.00 Improvements Other Than Bldgs - - - - - 203 49003 01 540.00 Improvements Other Than Bldgs - - - - - 203 49003 01 598.00 Council Designated - - - - - 203 49003 01 710.00 Transfers - 441,206 - - - 203 49003 01 720.00 Transfers 1,226,004 2,165,065 3,593,812 - - DEPARTMENT EXPENDITURES 1,352,316 2,733,771 3,753,340 1,227,500 2,577,500 NOTE: 2023's Proposed Budget Includes $2,500 for General Fund Admin Fees Not Included in Levy Amount (Covered by Interest Earnings) 2023 BUDGET WORKSHEETS STREETS CIP 87 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 207 31010.00 Current Ad Valorem Taxes 620,000 640,000 813,200 809,712 900,000 207 31010.01 General Levy for Items 207 33100.00 Federal Grants & Aids - - - - - 207 33425.00 Other State Grants & Aids - - - - - 207 33620.00 Other County Grants and Aids - - - - - 207 33720.00 Other Organization Grants - - - - - 207 36210.00 Interest Earnings - Investments 25,724 2,999 - 10,000 10,000 207 36214.00 Net Change in FV-Investments 3,619 - - - - 207 36215.00 Interest Earnings 687 1,299 258 500 - 207 36260.00 Other Revenue 1,589 1,479 3,636 - - 207 36262.00 Special Settlements - - - - - 207 36265.00 Use of Reserve Funds - - - 199,260 - 207 38000.00 Proceeds for Capital Leases - - 300,222 - - 207 39101.00 Sale of General Fixed Assets 1,789 129,594 92,443 160,000 80,000 Sell Back Vehicles 207 39201.00 Transfer From General Fund - 135,000 - 33,488 - 207 39203.00 Transfer From_________________- - - - - 207 39310.00 Bond Proceeds - - - - - DEPARTMENT REVENUES 653,408 910,371 1,209,758 1,212,960 990,000 207 49007 01 317.00 General Fund Administrative Fees 2,500 2,500 2,500 2,500 2,500 Yearly Fee Per Policy F-3 207 49007 01 319.00 Other Professional Services - - - - - 207 49007 01 540.00 Heavy Machinery Purchases 54,150 - 47,298 100,000 - 207 49007 01 541.00 Heavy Machinery Purchases 82,990 169,033 239,693 - - 207 49007 01 542.00 Heavy Machinery Purchases - - 238,809 - 100,000 Groundmaster Mower 207 49007 01 543.00 Heavy Machinery Purchases - 925,671 - 190,000 - 207 49007 01 544.00 Heavy Machinery Purchases - - - -125,000 Tractor/Backhoe 207 49007 01 545.00 Heavy Machinery Purchases - - - -- 207 49007 01 548.00 Lease Program - PW Vehicles 118,669 62,425 106,933 193,021 175,000 Year 6 of Program 207 49007 01 549.00 Lease Program - Police Vehicles 55,795 57,293 193,385 134,839 100,000 Year 6 of Program 207 49007 01 550.00 Motor Vehicle Purchases - - - - - 207 49007 01 551.00 Motor Vehicle Purchases - - - - - 207 49007 01 552.00 Motor Vehicle Purchases - - - - - 207 49007 01 553.00 Motor Vehicle Purchases - - - - - 207 49007 01 554.00 Motor Vehicle Purchases - - - - - 207 49007 01 555.00 Motor Vehicle Purchases - - - - - 207 49007 01 559.00 Motor Vehicle Purchases - - - - - 207 49007 01 572.00 Other Equipment Purchases 67,618 - - - - 207 49007 01 573.00 Other Equipment Purchases 79,695 - - 5,000 - 207 49007 01 574.00 Other Equipment Purchases 55,240 - - 10,000 - 207 49007 01 575.00 Other Equipment Purchases 8,180 10,000 32,303 21,000 21,000 Year 4 of 5 - Body Cameras & Storage 207 49007 01 576.00 Other Equipment Purchases 29,647 29,992 64,051 55,000 30,000 Squad Set Up & Equipment Installation 207 49007 01 577.00 Other Equipment Purchases 7,189 7,949 23,648 18,000 18,000 Year 3 of 6 - Squad Camera Video Stora 207 49007 01 578.00 Other Equipment Purchases 8,046 15,000 - 19,200 19,200 Squad Radar Unit Replacements (6) 207 49007 01 579.00 Other Equipment Purchases 24,300 39,379 16,400 - 9,000 Replace half of AED's (6) 207 49007 01 580.00 Other Equipment Purchases 169,188 11,995 51,037 - - 207 49007 01 581.00 Other Equipment Purchases 5,385 38,552 12,000 - - 207 49007 01 582.00 Other Equipment Purchases - - - - 25,000 Truck-Mounted Crash Attenuator 207 49007 01 583.00 Other Equipment Purchases - - 9,887 - 9,000 Radio Units-2 skid loaders, 1 tractor 207 49007 01 584.00 Other Equipment Purchases - - - - - 207 49007 01 585.00 Other Equipment Purchases - 11,156 - - - 207 49007 01 586.00 Computer Equipment Purchases - 10,497 7,865 10,000 10,000 City-Wide Storage 207 49007 01 587.00 Computer Equipment Purchases 34,484 20,317 26,781 - - 207 49007 01 588.00 Computer Equipment Purchases 24,893 24,381 51,541 25,000 25,000 City-Wide Software 207 49007 01 589.00 Computer Equipment Purchases 93,413 27,528 89,901 55,000 90,000 Computer Replacements - CH, P&R 207 49007 01 590.00 Computer Equipment Purchases - 35,000 - 38,000 207 49007 01 591.00 Computer Equipment Purchases - -- -- 207 49007 01 601.00 Principal on Lease Payments - -101,190 101,200 130,900 Year 3 of 7 - Aerial Fire Truck 207 49007 01 602.00 Principal Payments on Leases - -191,135 - - Year 3 of 7 - Aerial Fire Truck 207 49007 01 611.00 Interest on Lease Payments - - 74,419 52,000 22,300 Year 3 of 7 - Aerial Fire Truck DEPARTMENT EXPENDITURES 921,381 1,498,668 1,580,776 1,029,760 911,900 NOTE: 2023's Proposed Budget Includes $2,500 for General Fund Admin Fees Not Included in Levy Amount (Covered by Interest Earnings) 2023 BUDGET WORKSHEETS EQUIPMENT CIP 88 MSA 11/28/22 Building Funds & Facilities Street Equipment Park Imp From Water Sewer Storm Water Sewer Storm Debt Serv Total Year Item - Description Department CIP CIP CIP Assess Fund State Core Core Core Utility Utility Utility Levy Other Cost 2023 1 Replace Bleacher Seating Arena 90,000 1 90,000 2023 2 Arena Bleacher Bar Rail Arena 10,000 1 10,000 2023 3 Replace Locker Room Doors Arena 5,000 1 5,000 2023 4 Press Box ADA Seating Area Arena 5,000 1 5,000 2023 5 Doors 3 & 4 Entrance Flooring Arena 10,000 1 10,000 2023 6 Front Row Bleacher Railing Arena 30,000 1 30,000 2023 7 Public Works / Police Building Council 58,000,000 2 58,000,000 2023 8 City-Wide Storage Finance 10,000 10,000 2023 9 PC Workstation Upgrades (From 2019) (City Hall and Park & Rec) Finance 90,000 90,000 2023 10 Aerial Platform Truck Replacement Payment (Year 3 of 7)Fire 153,200 153,200 2023 11 City-Wide Software Gen'l. Govt.25,000 25,000 2023 12 Replace Chairs at Assembly Hall - Steeple Center Park & Rec 18,000 18,000 2023 13 Replace Sound System and AV in Banquet Hall Park & Rec 30,000 30,000 2023 14 New Neighborhood Park in Dunmore Park & Rec 500,000 500,000 2023 15 Bonaire Path Trail Park & Rec 700,000 700,000 2023 16 Amber Fields Dog Park and Pickle Ball Courts Park & Rec 800,000 70,000 870,000 2023 17 Redesign Concepts for Erickson Park Park & Rec 20,000 20,000 2023 18 Aieslbury Park Improvements Park & Rec 80,000 80,000 2023 19 UMore Park Building Conceptual Design Park & Rec 12,000 12,000 2023 20 Replace Half of AED's (6)Police 9,000 9,000 2023 21 Squad Camera Video Storage (Year 3 of 6)Police 18,000 18,000 2023 22 Squad Radar Unit Replacements (6) (Half of Fleet)Police 19,200 19,200 2023 23 Body Worn Cameras and Storage (Year 4 of 5)Police 21,000 21,000 2023 24 Squad Set Up and Equipment Installation Police 30,000 30,000 2023 25 Lease Program - Year 6 Police 100,000 3 100,000 2023 26 Pedestrian Improvements Program Pub Works 125,000 125,000 2023 27 PMP (Jay Simons Add'n, Biscayne A&B, 145th St A)Pub Works 250,000 950,000 60,000 175,000 70,000 1,505,000 2023 28 CSAH 42 / Akron Avenue Traffic Signal / Water Main Extension Pub Works 225,000 4 225,000 2023 29 Stormwater Improvement Program Pub Works 200,000 200,000 2023 30 Picnic Table Replacement Program Pub Works 25,000 25,000 2023 31 Lease Program - Year 6 Pub Works 175,000 15,000 7,000 7,000 3 204,000 2023 32 Groundmaster Mower (Replace #8073) (Purchased 2015)Pub Works 100,000 10,000 5 110,000 2023 33 Tractor/Backhoe (Replace #8407) (Purchased 2008)Pub Works 125,000 25,000 5 150,000 2023 34 Generator (Replace #8057) (Purchased 1996)Pub Works 50,000 50,000 50,000 5,000 5 155,000 2023 35 Generator (Replace #8059) (Purchased 2003)Pub Works 50,000 50,000 50,000 5,000 5 155,000 2023 36 Akron Avenue Extension (Amber Fields)Pub Works 950,000 700,000 854,000 395,000 6 2,899,000 2023 37 County Road 42 & Blaine Ave Trunk Watermain & PRV Relocation Pub Works 2,500,000 2,500,000 2023 38 Blaine Avenue Upgrades (Project Bigfoot)Pub Works 1,500,000 650,000 1,250,000 500,000 7 3,900,000 2023 39 Jay Simon Addition New WM Pub Works 300,000 300,000 2023 40 Sidewalk Restoration & Bumpout Reconfiguration - 145th Street Pub Works 350,000 8 350,000 2023 41 Pedestrian Signals - Highway 3 @ 147th Street and Steeple Center Pub Works 50,000 50,000 2023 42 Truck-Mounted Crash Attenuator Pub Works 25,000 25,000 2023 43 Radio Units for 3 Pieces of Equipment (2 Skid Loaders & 1 Tractor-BackhoPub Works 9,000 9,000 2023 44 Sanitary Sewer Lining Program (Year 1 of 2)Pub Works 225,000 225,000 2023 45 Large Diameter Sanitary Sewer Cleaning Pub Works 80,000 80,000 2023 46 Site Lighting Installations - Lift Stations Pub Works 45,000 45,000 2023 47 LED Lighting Retrofits - Well Houses & Water Towers Pub Works 60,000 60,000 2023 48 Culvert Replacement & Neighborhood Drainage Modfication - 124th StreetPub Works 75,000 75,000 2023 49 Evermoor Parkway to Danube Trail Culvert Pub Works 5,000 5,000 2023 50 Fire Station No. 1 Windows & Exterior Pub Works 300,000 8 300,000 373,000 2,575,000 909,400 250,000 1,400,000 1,175,000 4,150,000 2,104,000 975,000 235,000 632,000 377,000 0 59,377,000 74,532,400 Total CIP Funding Requirements - Year 2023 $3,857,400 $0 (#) These items will be funded with the issuance of Equipment Certificates.$0 1 Funding comes from Arena Fund operations/reserves. 2 Funding for the Public Works / Police building will come from a general bond issue. 3 Highlighted items are part of a lease program. This is a summary of the total for the year. Detail is provided in an accompanying document. 4 County advance funding requested. Rosemount will pay back in 2022 - 2024. 5 Other funding for Public Works equipment comes from trade-in value of old vehicles. 6 Extension required by City per Subdivision Agreement with Maplewood Development for Amber Fields. U of M Deferred cost share of $700,000 minimum, up to $900,000. 7 Upgrades of Blaine Avenue to facilitate development of Envis/Opus sites. Very rough ballpark estimate. 8 These items will be funded using assigned funds. Total Building CIP levy for 2023 is $0. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Street CIP levy for 2023 is $959,302. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Equipment CIP levy for 2023 is $900,000. $153,200 is for year 3 of the Aerial Fire Truck lease-purchase. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives. 89 Insurance  General / Administrative  Provides for the funding of the City's Worker's Compensation Insurance and General Liability  Insurance.  Currently, both insurances are provided through the League of Minnesota Cities  Insurance Trust. This agency allows the City to have thorough, yet affordable insurance.  In 1995, we set up a separate Internal Service Fund for insurance purposes.  The amount levied  was, and will be, the same as it would have been if the Insurance budget had been in the  General Fund, as it has been in the past.  This allows us to build a special fund for insurance  purposes that will allow the City to move towards self‐insurance, and ultimately, lower rates.   We do not anticipate ever being totally self‐insured, but by raising our deductibles we approach  that point and allow ourselves to save substantially on our annual insurance premiums.  Doing  so will allow the City to operate more efficiently and save the taxpayers money without taking  undue risks.  90 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments ------------------- ------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 206 31010.00 Current Ad Valorem Taxes 380,000 425,000 450,000 450,000 450,000 206 33100.00 Federal Grants & Aids - - - - - 206 36210.00 Interest Earnings-Investments - - - - 500 206 36214.00 Net Change in FV-Investments - - - - - Annual Market Value Changes 206 36215.00 Interest Earnings 1,074 230 58 500 - 206 36260.00 Other Revenue 16,775 29,565 57,689 19,000 19,000 Insurance Refunds/Dividends 206 36265.00 Use of Reserve Funds - - - - - 206 39201.00 Transfer from General Fund - - - - - DEPARTMENT REVENUES 397,849 454,795 507,746 469,500 469,500 206 49006 01 221.00 Equipment Parts 155 - 2,118 1,000 1,000 Liability & Auto Deductible Pymts 206 49006 01 304.00 Legal Fees 1,000 - - 1,000 1,000 Unreimbursable Legal Fees 206 49006 01 305.00 Medical & Dental Fees 14,992 6,244 10,781 10,000 10,000 Work Comp Deductible Pymts 206 49006 01 317.00 General Fund Administrative Fees 2,500 2,500 2,500 2,500 2,500 Yearly Fee Per Policy F-3 206 49006 01 319.00 Other Professional Services 30,000 206 49006 01 319.01 Risk Management Consultant 8,213 4,500 - 10,000 206 49006 01 319.02 Safe Assure Consultant 18,122 9,333 9,520 20,000 206 49006 01 365.00 Worker's Compensation Insurance 234,163 240,843 264,939 245,000 245,000 Annual Premium 206 49006 01 369.00 Other Insurance 133,195 135,574 154,176 140,000 140,000 Annual Premium-General Liability 206 49006 01 403.00 Contracted R & M-Other Impr.- - - - - 206 49006 01 409.00 Other Contracted Repair & Maint 51,196 37,429 22,505 40,000 40,000 Liability & Auto Deductible Pymts 206 49006 01 439.00 Other Miscellaneous Charges - - - - - _ 206 49006 01 550.00 Motor Vehicle Purchases - - - - - DEPARTMENT EXPENDITURES 463,535 436,424 466,538 469,500 469,500 2023 BUDGET WORKSHEETS INSURANCE 91 Port Authority  General / Administrative  The Rosemount Port Authority is responsible for both economic development and redevelopment activities in the City. The Port Authority concentrates much of its activity on business attraction, retention, and expansion, focusing on industrial businesses to bring head of household jobs to Rosemount, and on redevelopment opportunities in Downtown Rosemount. The Port Authority will continue to work on other development and redevelopment projects related to commercial and industrial development, including but not limited to, targeted redevelopment and additional retailing opportunities on lands designated for commercial use. The Port Authority also focuses on marketing of the community to current and future residents and businesses using various means include social media and the City’s website. 92 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments ------------------- ------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 201 31010.00 Current Ad Valorem Taxes 105,000 112,000 168,000 170,900 170,900 Operating Levy 201 31050.00 Tax Increments - - - - - Admin Fees Portion Only 201 32280.00 Fiber License Fees 1,200 1,200 1,200 1,200 1,200 201 33130.00 Federal Grants-CDBG - - - - - 201 33425.00 Other State Grants & Aids - - - - - LCA Grant-Land/Bldg Acquisition 201 33620.00 Other County Grants & Aids - - - - - 201 34109.00 Other Charges for Services 7,225 (2,675) 14,900 8,000 12,000 Business Expo 201 36210.00 Interest Earnings - Investments 457 3,405 452 400 1,700 201 36215.00 Interest Earnings 2,231 502 129 1,300 201 36230.00 Contributions/Donations - - - - - 201 36260.00 Other Revenue - - - - - 201 36265.00 Use of Reserve Funds - - - - - 201 39101.00 Sales of General Fixed Assets 268,114 15,000 - - - DEPARTMENT REVENUES 384,228 129,432 184,681 181,800 185,800 201 46300 02 101.00 Salaries & Benefits - 1,072 78,954 84,900 89,600 All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 201 46300 99 103.00 Salaries & Benefits 2,575 3,287 2,950 4,000 4,000 201 46300 01 209.00 Other Office Supplies - - 1,342 - - 201 46300 01 219.00 Other Operating Supplies 6,923 5,254 10,969 8,000 12,000 Business Expo 201 46300 01 303.00 Engineering Fees 332 - - 3,000 - 201 46300 01 304.00 Legal Fees 3,468 - - 4,000 4,000 201 46300 01 317.00 General Fund Administrative Fees 6,000 6,000 6,000 6,000 6,000 Yearly Fee Per Policy F-3 201 46300 01 319.00 Other Professional Services 45,200 201 46300 01 319.01 Project Management Consultant - - - 2,000 201 46300 01 319.02 Marketing - REDE - City Share 11,068 12,500 11,637 10,000 Greater MSP 201 46300 01 319.04 P/A Property Tax Payments - - - - 201 46300 01 319.05 Other Consultants 1,750 2,856 - 2,000 Downtown Update 201 46300 01 319.06 Grant Reimbursement Expenses - - 5,000 25,000 Downtown Loan/Grant Program 201 46300 01 319.07 Retail Strategies 45,000 33,920 26,580 - 201 46300 01 319.08 Open to Business (OTB)- - - 5,000 2022-2023 JPA 201 46300 01 322.00 Postage Costs - - - - - 201 46300 01 331.00 Travel Expense 293 - 74 500 500 201 46300 01 349.00 Other Advertising 9,077 10,006 15,001 15,000 15,000 Additional Marketing Opportunities 201 46300 01 359.00 Other Printing & Binding Costs 2 - - 200 200 201 46300 01 365.00 Workers Comp Insurance 140 139 340 200 200 Commissioners 201 46300 01 369.00 Other Insurance 555 560 643 600 600 Property Insurance 201 46300 01 381.00 Electric Utilities 171 186 226 400 400 Business Park & Other Properties 201 46300 01 383.00 Gas Utilities - - - - - Other Properties 201 46300 01 389.00 Other Utility Services - - - 1,000 1,000 Utility Fees / Fiber Maintenance 201 46300 01 403.00 Contracted Repairs & Maintenance - - - 2,000 2,000 Contracts for Fiber 201 46300 01 433.00 Dues & Subscriptions 2,500 Prof Organizations/Journals 201 46300 01 433.01 Professional Organizations/Journals 2,217 1,063 91 2,500 201 46300 01 433.02 Foreign Trade Zone Commission - - - 201 46300 01 437.00 Conferences & Seminars 3,300 2,681 2,650 5,000 5,000 Development/TIF/Miscellaneous 201 46300 01 439.00 Other Miscellaneous Charges 3,689 30 - 500 500 201 46300 01 521.00 Building & 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 - - - - - DEPARTMENT EXPENDITURES 96,560 79,554 162,457 181,800 188,700 2023 BUDGET WORKSHEETS PORT AUTHORITY 93 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 241 31010.00 Current Ad Valorem Taxes - - - - - _ 241 31050.00 Tax Increments - - - - - 241 33400.00 State Grants & Aids - - - - - 241 33425.00 Other State Grants & Aids - - - - - 241 33620.00 Other County Grants & Aids - - - - - 241 36210.00 Interest Earnings - Investments - - - - - 241 36215.00 Interest Earnings - - - - - 241 36220.00 Rents & Royalties - - - - - 241 36230.00 Other Revenue - - - - - 241 36260.00 Contribution/Donation-Private - - - - - 241 39101.00 Sale of General Fixed Assets - - - - - 241 39310.00 Bond Proceeds - - - - - DEPARTMENT REVENUES - - - - - 241 49041 01 303.00 Engineering Fees - - - - - 241 49041 01 304.00 Legal Fees - - 1,850 - - 241 49041 01 319.00 Other Professional Services - - - - 18,000 County TIF Charges 241 49041 01 510.00 Land Purchases - - - - - 241 49041 01 522.00 Building & Structure Purchases - - - - - 241 49041 01 530.00 Improvements Other Than Buildings - - - - - 241 49041 01 533.00 Improvements Other Than Buildings - - - - - 241 49041 01 536.00 Improvements Other Than Buildings - - - - - 241 49041 01 538.00 Improvements Other Than Buildings - - - - - 241 49041 01 601.00 Principal on The Morrison PAYG - - - - 150,000 The Morrison Pay-As-You-Go 241 49041 01 611.00 Interest on The Morrison PAYG - - - - 150,000 The Morrison Pay-As-You-Go 241 49041 01 710.00 Transfers - - - - - P & I for 2008A & 2015A Issues DEPARTMENT EXPENDITURES - - 1,850 - 318,000 2023 BUDGET WORKSHEETS KEN ROSE DISTRICT (0136) 94 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments ------------------ ------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 242 31010.00 Current Ad Valorem Taxes - - - - - _ 242 31050.00 Tax Increments 865,476 959,586 1,076,647 1,000,000 1,100,000 242 33400.00 State Grants & Aids - - - - - 242 33425.00 Other State Grants & Aids - - - - - 242 33620.00 Other County Grants & Aids - - - - - 242 36210.00 Interest Earnings - Investments 15,491 18,598 3,693 10,000 10,000 242 36215.00 Interest Earnings 2,149 902 354 1,000 - Consolidated Interest Earnings 242 36220.00 Rents & Royalties - - - - - 242 36230.00 Other Revenue - - - - - 242 36260.00 Contribution/Donation-Private - - - - - 242 39101.00 Sale of General Fixed Assets - - - - - 242 39310.00 Bond Proceeds - - - - - DEPARTMENT REVENUES 883,115 979,087 1,080,694 1,011,000 1,110,000 242 49042 01 303.00 Engineering Fees - - - - - 242 49042 01 304.00 Legal Fees - - - - - 242 49042 01 319.00 Other Professional Services 19,983 14,734 16,504 22,000 20,000 County TIF Charges 242 49042 01 510.00 Land Purchases - 600,000 - - - 242 49042 01 522.00 Building & Structure Purchases - -- - - 242 49042 01 530.00 Improvements Other Than Buildings - -- - - 242 49042 01 533.00 Improvements Other Than Buildings - -- - - 242 49042 01 536.00 Improvements Other Than Buildings - -- - - 242 49042 01 538.00 Improvements Other Than Buildings - -- - - 242 49042 01 601.00 Principal on Waterford PAYG 81,460 70,480 63,425 90,000 76,328 Waterford Pay-As-You-Go 242 49042 01 611.00 Interest on Waterford PAYG 63,673 59,557 56,418 60,000 49,437 Waterford Pay-As-You-Go 242 49042 01 710.00 Transfers 600,000 600,000 600,000 600,000 600,000 P & I for 2008A & 2015A Issues DEPARTMENT EXPENDITURES 765,116 1,344,771 736,347 772,000 745,765 2023 BUDGET WORKSHEETS DOWNTOWN/BROCKWAY DISTRICT (0108) 95 Debt Service Funds  General ‐ Administrative  Debt Service Funds are Governmental Funds set up to provide for the repayment of debt of the  City.  This debt is normally accomplished through the issuance of bonds secured by the full faith  and credit of the City.  Repayment of the debt is usually accomplished through the collection of  special assessments; general levies of the City collected through property taxes; tax increment  funds; core funds; transfers from Enterprise Funds (Revenue Debt Issues) and transfers from  other areas.  96 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 381 31010.00 Current Ad Valorem Taxes - - - - - _ 381 31050.00 Tax Increments - - - - - 381 36101.00 Principal - Special Assessments - - - - - 381 36102.00 Penalties & Interest - S/A - - - - - 381 36210.00 Interest Earnings - Investments 2,135 5,636 447 - - 381 36215.00 Interest Earnings 904 166 78 - - 381 36265.00 Use of Reserve Funds - - - - - 381 37145.00 Surcharge on Water Revenues - - - - - 381 37160.00 Penalties - Surcharge Revenues - - - - - 381 39201.00 Transfer From General Fund - - - - - 381 39202.00 Contribution From Enterprises - - - - - 381 39203.00 Transfer From________________- - - - - 381 39204.00 Transfer From Water Core - - - - - 381 39205.00 Transfer From Sewer Core - - - - - 381 39206.00 Transfer From Storm Core - - - - - 381 39207.00 Transfer From Port Authority 400,000 400,000 400,000 400,000 400,000 381 39310.00 Bond Proceeds - - - - - DEPARTMENT REVENUES 403,039 405,802 400,524 400,000 400,000 381 47000 01 317.00 General Fund Admin Fees - - - - - 381 47000 01 319.00 Other Professional Services - - - - - 381 47000 01 601.00 Bond Principal 260,000 270,000 285,000 300,000 315,000 381 47000 01 611.00 Bond Interest 86,063 72,644 57,888 41,800 24,888 381 47000 01 621.00 Bond Paying Agent Fees 500 500 500 500 1,250 Fiscal agent, arbitrage, & CD services 381 47000 01 710.00 Transfers - - - - - DEPARTMENT EXPENDITURES 346,563 343,144 343,388 342,300 341,138 2023 BUDGET WORKSHEETS DEBT SERVICE FUND 381 - G.O. TAXABLE TIF 2008A 97 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 330 31010.00 Current Ad Valorem Taxes - - - - - Remainder Paid via Fund Balance 330 36101.00 Principal - Special Assessments 28,201 8,528 - - - 330 36101.01 Principal - Special Assessments - - 8,272 - - 330 36102.00 Penalties & Interest - S/A - - - - - 330 36210.00 Interest Earnings - Investments 8,501 14,949 7,439 - - 330 36215.00 Interest Earnings 114 60 10 - - 330 36265.00 Use of Reserve Funds - - - 19,100 - 330 37145.00 Surcharge on Water Revenues - - - - - 330 37160.00 Penalties - Surcharge Revenues - - - - - 330 39201.00 Transfer From General Fund - - - - - 330 39202.00 Contribution From Enterprises - - - - - 330 39203.00 Transfer From________________- - - - - 330 39204.00 Transfer From Water Core 72,000 71,000 70,000 68,000 68,000 330 39205.00 Transfer From Sewer Core - - - - - 330 39206.00 Transfer From Storm Core - - - - - 330 39208.00 Transfer From Street CIP - - - - - 330 39310.00 Bond Proceeds - - - - - DEPARTMENT REVENUES 108,816 94,537 85,722 87,100 68,000 330 47000 01 317.00 General Fund Admin Fees - - - - - 330 47000 01 319.00 Other Professional Services - - - - - 330 47000 01 601.00 Bond Principal 400,000 410,000 80,000 80,000 85,000 330 47000 01 611.00 Bond Interest 16,385 11,520 8,095 6,600 5,008 330 47000 01 621.00 Bond Paying Agent Fees 500 500 500 500 4,000 Fiscal agent, arbitrage, & CD services 330 47000 01 710.00 Transfers - - - - - DEPARTMENT EXPENDITURES 416,885 422,020 88,595 87,100 94,008 2023 BUDGET WORKSHEETS DEBT SERVICE FUND 330 - G.O. IMPROVEMENT BONDS, 2014A 98 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 612 31010.00 Current Ad Valorem Taxes - - - - - _ 612 36101.00 Principal - Special Assessments - - - - - 612 36102.00 Penalties & Interest - S/A - - - - - 612 36210.00 Interest Earnings - Investments - - - - - 612 36215.00 Interest Earnings 123 61 9 - - 612 36265.00 Use of Reserve Funds - - - - - 612 37145.00 Surcharge on Water Revenues - - - - - 612 37160.00 Penalties - Surcharge Revenues - - - - - 612 39201.00 Transfer From General Fund - - - - - 612 39202.00 Contribution From Enterprises - - - - - 612 39203.00 Transfer From________________- - - - - 612 39204.00 Transfer From Water Core 178,000 180,000 176,000 178,000 180,000 612 39205.00 Transfer From Sewer Core - - - - - 612 39206.00 Transfer From Storm Core - - - - - 612 39207.00 Transfer From Port Authority - - - - - 612 39310.00 Bond Proceeds - - - - - DEPARTMENT REVENUES 178,123 180,061 176,009 178,000 180,000 612 47000 01 317.00 General Fund Admin Fees - - - - - 612 47000 01 319.00 Other Professional Services - - - - - 612 47000 01 601.00 Bond Principal 145,000 145,000 - 155,000 160,000 612 47000 01 611.00 Bond Interest 22,554 19,292 14,865 21,100 16,705 612 47000 01 614.00 Amortization of Bond Discount - - - - - 612 47000 01 621.00 Bond Paying Agent Fees 500 500 500 500 1,250 Fiscal agent, arbitrage, & CD services 612 47000 01 710.00 Transfers - - - - - DEPARTMENT EXPENDITURES 168,054 164,792 15,365 176,600 177,955 2023 BUDGET WORKSHEETS DEBT SERVICE FUND 612 - G.O. UTILITY REVENUE BONDS, 2015A 99 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 384 31010.00 Current Ad Valorem Taxes - - - - - _ 384 36101.00 Principal - Special Assessments - - - - - 384 36210.00 Interest Earnings - Investments 1,294 4,190 670 - - 384 36214.00 Net Change in FV-Investments - - - - - 384 36215.00 Interest Earnings 631 110 44 - - 384 36260.00 Other Revenue - - - - - 384 36265.00 Use of Reserve Funds - - - - - 384 37145.00 Surcharge on Water Revenues - - - - - 384 39101.00 Sale of General Fixed Assets - - - - - 384 39201.00 Transfer From General Fund - - - - - 384 39202.00 Contribution From Enterprises - - - - - 384 39203.00 Transfer From________________- - - - - 384 39204.00 Transfer From Water Core - - - - - 384 39205.00 Transfer From Sewer Core - - - - - 384 39206.00 Transfer From Storm Core - - - - - 384 39207.00 Transfer From Port Authority 200,000 200,000 200,000 200,000 200,000 384 39310.00 Bond Proceeds - - - - - DEPARTMENT REVENUES 201,925 204,300 200,714 200,000 200,000 384 47000 01 317.00 General Fund Admin Fees - - - - - 384 47000 01 319.00 Other Professional Services - - - - - 384 47000 01 601.00 Bond Principal 10,000 15,000 15,000 15,000 15,000 384 47000 01 611.00 Bond Interest 89,900 89,525 89,075 88,700 88,175 384 47000 01 621.00 Bond Paying Agent Fees 450 450 450 500 1,250 Fiscal agent, arbitrage, & CD services 384 47000 01 710.00 Transfers - - - - - DEPARTMENT EXPENDITURES 100,350 104,975 104,525 104,200 104,425 2023 BUDGET WORKSHEETS DEBT SERVICE FUND 384 - G.O. PORT AUTHORITY TAX INCREMENT REFUNDING BONDS, 2015A (2008B) 100 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 302 31010.00 Current Ad Valorem Taxes 174,116 180,941 177,004 183,172 183,803 _ 302 36101.00 Principal - Special Assessments - - - - - 302 36102.00 Penalties & Interest - S/A - - - - - 302 36210.00 Interest Earnings - Investments 949 997 - - - 302 36215.00 Interest Earnings 412 103 71 - - 302 36265.00 Use of Reserve Funds - - - - - 302 37145.00 Surcharge on Water Revenues - - - - - 302 37160.00 Penalties - Surcharge Revenues - - - - - 302 39201.00 Transfer From General Fund - - - - - 302 39202.00 Contribution From Enterprises - - - - - 302 39203.00 Transfer From________________- 79,851 - - - 302 39204.00 Transfer From Water Core - - - - - 302 39205.00 Transfer From Sewer Core - - - - - 302 39206.00 Transfer From Storm Core - - - - - 302 39207.00 Transfer From Port Authority - - - - - 302 39310.00 Bond Proceeds - - - - - DEPARTMENT REVENUES 175,477 261,892 177,075 183,172 183,803 302 47000 01 317.00 General Fund Admin Fees - - - - - 302 47000 01 319.00 Other Professional Services - - - - - 302 47000 01 601.00 Bond Principal 140,000 140,000 150,000 150,000 160,000 302 47000 01 611.00 Bond Interest 27,225 24,075 20,450 16,600 12,250 302 47000 01 621.00 Bond Paying Agent Fees 500 500 500 500 1,250 Fiscal agent, arbitrage, & CD services 302 47000 01 710.00 Transfers - - - - - DEPARTMENT EXPENDITURES 167,725 164,575 170,950 167,100 173,500 2023 BUDGET WORKSHEETS DEBT SERVICE FUND 302 - G.O. CAPITAL IMPROVEMENT PLAN (CIP) REFUNDING BONDS, 2015B (OLD 2005A) 101 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 331 31010.00 Current Ad Valorem Taxes - - - - - Paid via Fund Balance 331 36101.00 Principal - Special Assessments 127,026 - - - - 331 36102.00 Penalties & Interest - S/A 334 - - - - 331 36210.00 Interest Earnings - Investments - - 10,297 - - 331 36215.00 Interest Earnings 10,192 15,458 6 - - 331 36265.00 Use of Reserve Funds 891 236 - 230,600 - 331 37145.00 Surcharge on Water Revenues - - - -- 331 37160.00 Penalties - Surcharge Revenues - - - -- 331 39201.00 Transfer From General Fund - - - -- 331 39202.00 Contribution From Enterprises - - - -- 331 39203.00 Transfer From________________ 117,762 - - - - 331 39204.00 Transfer From Water Core - - - - - 331 39205.00 Transfer From Sewer Core - - - - - 331 39206.00 Transfer From Storm Core - - - - - 331 39208.00 Transfer From Street CIP - - - - - 331 39310.00 Bond Proceeds - - - - - DEPARTMENT REVENUES 256,205 15,694 10,302 230,600 - 331 47000 01 317.00 General Fund Admin Fees - - - - - 331 47000 01 319.00 Other Professional Services - - - - - 331 47000 01 601.00 Bond Principal 185,000 210,000 215,000 220,000 225,000 2023 Final Pay Year 331 47000 01 611.00 Bond Interest 28,875 22,950 16,575 10,100 3,375 331 47000 01 621.00 Bond Paying Agent Fees 450 450 450 500 1,250 Fiscal agent, arbitrage, & CD services 331 47000 01 710.00 Transfers - - - - - DEPARTMENT EXPENDITURES 214,325 233,400 232,025 230,600 229,625 2023 BUDGET WORKSHEETS DEBT SERVICE FUND 331 - G.O. IMPROVEMENT BONDS, 2017A 102 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 332 31010.00 Current Ad Valorem Taxes - - - - - Paid via Fund Balance 332 36101.00 Principal - Special Assessments 5,202 990,466 - - - 332 36101.01 Principal - Special Assessments - - 4,705 - - 332 36101.04 Principal - Special Assessments - - 8,358 - - 332 36102.00 Penalties & Interest - S/A 416 - - - - 332 36210.00 Interest Earnings - Investments 1,496 11,967 4,341 - - 332 36215.00 Interest Earnings 1,467 55 11 - - 332 36265.00 Use of Reserve Funds - - - 193,000 - 332 37145.00 Surcharge on Water Revenues - - - - - 332 37160.00 Penalties - Surcharge Revenues - - - - - 332 39201.00 Transfer From General Fund - - - - - 332 39202.00 Contribution From Enterprises - - - - - 332 39203.00 Transfer From________________- - - - - 332 39204.00 Transfer From Water Core - - - - - 332 39205.00 Transfer From Sewer Core - - - - - 332 39206.00 Transfer From Storm Core - - - - - 332 39208.00 Transfer From Street CIP - - - - - 332 39310.00 Bond Proceeds - - - - - DEPARTMENT REVENUES 8,581 1,002,488 17,415 193,000 - 332 47000 01 317.00 General Fund Admin Fees - - - - - 332 47000 01 319.00 Other Professional Services - - - - - 332 47000 01 601.00 Bond Principal - 140,000 160,000 170,000 180,000 2024 Final Pay Year 332 47000 01 611.00 Bond Interest 37,691 38,250 30,750 22,500 13,750 332 47000 01 621.00 Bond Paying Agent Fees 500 500 500 500 5,250 Fiscal agent, arbitrage, & CD services 332 47000 01 710.00 Transfers - - - - - DEPARTMENT EXPENDITURES 38,191 178,750 191,250 193,000 199,000 2023 BUDGET WORKSHEETS DEBT SERVICE FUND 332 - G.O. IMPROVEMENT BONDS, 2018A 103 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 382 31010.00 Current Ad Valorem Taxes - - - - - 382 34150.00 SKB User Fees - C & D Cells - - - - 1,300,000 Moved from Building CIP 382 36101.00 Principal - Special Assessments - - - - - 382 36101.01 Principal - Special Assessments - - - - - 382 36101.04 Principal - Special Assessments - - - - - 382 36102.00 Penalties & Interest - S/A - - - - - 382 36210.00 Interest Earnings - Investments - - - - - 382 36215.00 Interest Earnings - - - - - 382 36265.00 Use of Reserve Funds - - - - - 382 37145.00 Surcharge on Water Revenues - - - - - 382 37160.00 Penalties - Surcharge Revenues - - - - - 382 39201.00 Transfer From General Fund - - - - - 382 39202.00 Contribution From Enterprises - - - - - 382 39203.00 Transfer From________________- - - - - 382 39204.00 Transfer From Water Core - - - - - 382 39205.00 Transfer From Sewer Core - - - - - 382 39206.00 Transfer From Storm Core - - - - - 382 39208.00 Transfer From Street CIP - - - - - 382 39310.00 Bond Proceeds - - - - - DEPARTMENT REVENUES - - - - 1,300,000 382 47000 01 317.00 General Fund Admin Fees - - - - - 382 47000 01 319.00 Other Professional Services - - - - - 382 47000 01 601.00 Bond Principal - - - - - Issue Year-PD/PW Facility 382 47000 01 611.00 Bond Interest - - - - - 382 47000 01 621.00 Bond Paying Agent Fees - - - - - Fiscal agent, arbitrage, & CD services 382 47000 01 710.00 Transfers - - - - - DEPARTMENT EXPENDITURES - - - - - 2023 BUDGET WORKSHEETS DEBT SERVICE FUND 382 - G.O. IMPROVEMENT BONDS, 2023A 104 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 301 31010.00 Current Ad Valorem Taxes - - - - - 301 34150.00 SKB User Fees - C & D Cells - - - - - Beginning in 2024 301 36101.00 Principal - Special Assessments - - - - - 301 36101.01 Principal - Special Assessments - - - - - 301 36101.04 Principal - Special Assessments - - - - - 301 36102.00 Penalties & Interest - S/A - - - - - 301 36210.00 Interest Earnings - Investments - - - - - 301 36215.00 Interest Earnings - - - - - 301 36265.00 Use of Reserve Funds - - - - - 301 37145.00 Surcharge on Water Revenues - - - - - 301 37160.00 Penalties - Surcharge Revenues - - - - - 301 39201.00 Transfer From General Fund - - - - - 301 39202.00 Contribution From Enterprises - - - - - 301 39203.00 Transfer From________________- - - - - 301 39204.00 Transfer From Water Core - - - - - 301 39205.00 Transfer From Sewer Core - - - - - 301 39206.00 Transfer From Storm Core - - - - - 301 39208.00 Transfer From Street CIP - - - - - 301 39310.00 Bond Proceeds - - - - - DEPARTMENT REVENUES - - - - - 301 47000 01 317.00 General Fund Admin Fees - - - - - 301 47000 01 319.00 Other Professional Services - - - - - 301 47000 01 601.00 Bond Principal - - - - - Issue Year 301 47000 01 611.00 Bond Interest - - - - - 301 47000 01 621.00 Bond Paying Agent Fees - - - - - Fiscal agent, arbitrage, & CD services 301 47000 01 710.00 Transfers - - - - - DEPARTMENT EXPENDITURES - - - - - 2023 BUDGET WORKSHEETS DEBT SERVICE FUND 301 - G.O. IMPROVEMENT BONDS, 2023B 105 Water Fund  This is an Enterprise Fund consisting of revenues from water sales that provides for the  operation and maintenance of the City's wells, towers and distribution system.  The City  currently has four water towers and nine wells.  This fund covers the operation of 1,645 fire  hydrants, 3,493 water valves, more than 9,154 meter connections, and 148 miles of water  main.  Performance Measures  2015 2016 2017 2018 2019 2020 2021 Cost $1,635 $1,588 $1,451 $1,606 $2,547 $1,598 $2,334  $‐  $500  $1,000  $1,500  $2,000  $2,500  $3,000 2019 includes Chippendale tower recoat for $763/million gallons 2021 moderate drought conditions required additional pumping Operating Cost per 1,000,000  Gallons  Pumped/Produced 106 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 601 33130.00 Federal Grants - CDBG - - - - - MCES Water Efficiency Grant 601 33425.00 Other State Grants & Aids 720 6,302 3,348 1,000 1,000 _ 601 33620.00 Other County Grants & Aids - - - - - _ 601 34107.00 Assessment Fees 21,497 22,519 21,356 20,000 20,000 _ 601 34108.00 Administrative Fees-Other Funds 9,327 11,753 11,890 6,300 6,300 5% of 5% Fees-Const Projects 601 34109.00 Other Gen'l Govt Chgs for Services 17,261 21,709 30,900 - - _ 601 36101.00 Principal - Special Assessments 53,808 49,369 6,561 55,000 50,000 _ 601 36101.01 Principal - Special Assessments - - 47,671 - - _ 601 36101.03 Principal - Special Assessments - - 2,129 - - _ 601 36101.05 Principal - Special Assessments - - 180 - - _ 601 36101.11 Principal - Special Assessments - - 470 - - _ 601 36102.00 Penalties & Interest - S/A 719 1,222 (566) - - _ 601 36210.00 Interest Earnings - Investments 177,969 146,937 68,993 90,000 100,000 _ 601 36214.00 Net Change in FV-Investments 39,042 94,366 (94,203) - - Annual Market Value Changes 601 36215.00 Interest Earnings 3,358 2,623 1,038 1,000 - _ 601 36220.00 Rents & Royalties 161,211 163,151 167,373 170,000 178,000 Wireless Carrier Leases - Annual Escala 601 36260.00 Other Revenues - - 1,368 - - _ 601 36265.00 Use of Reserve Funds - - - - - _ 601 36270.00 Capital Contributions - - 1,462,407 - - _ 601 37110.00 Residential Water Revenues 1,274,288 1,686,424 2,076,131 1,600,000 1,700,000 _ 601 37120.00 Apartment Water Revenues 121,359 128,711 139,761 130,000 132,000 _ 601 37125.00 Institutional Water Revenues 83,160 75,527 113,535 75,000 80,000 _ 601 37130.00 Commercial Water Revenues 95,413 103,899 125,238 100,000 105,000 _ 601 37140.00 Industrial Water Revenues 135,704 143,753 181,836 150,000 150,000 _ 601 37160.00 Penalties - Water Revenues 12,012 8,235 16,715 12,000 12,000 _ 601 37165.00 Meter Maint Water Revenues - - - - - _ 601 37170.00 Other Water Revenues (29,682) (350) - - - 2nd Meter Refunds 601 37180.00 Water Meter Sales Revenue 96,658 117,612 140,157 90,000 90,000 _ 601 39103.00 Gain or Loss from F/A Disposal - (378) - - - _ 601 39203.00 Transfer From______________- -203,688 - - _ DEPARTMENT REVENUES 2,273,824 2,783,383 4,727,975 2,500,300 2,624,300 601 49400 77 101.00 Salaries & Benefits - Administrative 162,237 162,556 139,627 196,400 198,935 All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 601 49400 77 102.00 Full-Time Overtime - Administrative - - - - - 601 49400 78 101.00 Salaries & Benefits - Technical/Clerica 169,268 179,462 177,341 200,400 205,250 601 49400 78 102.00 Full-Time Overtime - Technical/Clerica 486 670 659 - - 601 49400 79 101.00 Salaries & Benefits - Maintenance 183,174 151,204 163,210 176,400 192,675 601 49400 79 102.00 Full-Time Overtime - Maintenance 15,957 10,096 8,801 8,000 9,500 601 49400 99 103.00 Part-Time Salaries & Benefits 7,975 10,305 10,018 8,700 10,700 601 49400 01 203.00 Printed Forms & Paper 70 - 155 100 100 Outsource Bill Printing (313.00) 601 49400 01 205.00 Plotter Ink & Paper - - - 400 400 601 49400 01 209.00 Other Office Supplies 134 592 151 200 200 601 49400 01 212.00 Motor Fuels 3,912 3,900 5,100 3,900 3,900 2.5% Covered by Water Utility 601 49400 01 216.00 Chemicals & Chemical Products 60,654 62,672 71,561 75,000 80,000 Chlorine/Flouride/Poly 601 49400 01 219.00 Other Operating Supplies 1,174 487 434 500 500 Maintenance Supplies 601 49400 01 220.00 Water Meter Purchases Meters, MIU's & CU Horns 601 49400 01 220.01 For Replacements 78,315 67,073 56,774 77,300 100,000 Match Rate Model (Incl. Recycling) 601 49400 01 220.02 For New Homes 52,209 44,716 31,915 78,000 100,000 Match Rate Model, Newland Dev. 601 49400 01 224.00 Street Maintenance Materials 4,769 1,414 879 2,500 2,500 Patching for Breaks 601 49400 01 225.00 Landscaping Materials 108 707 242 1,000 1,000 Topsoil, Seed & Sod 601 49400 01 228.00 Meter Repair Materials 105 79 - 601 49400 01 229.00 Other Maintenance Supplies 601 49400 01 229.01 Supplies for Hydrants 6,939 2,946 9,999 10,000 10,000 Hydrant and hydrant parts for repairs and 601 49400 01 229.02 Curb Shutoffs - 196 - 1,000 1,000 601 49400 01 229.03 GV Repair/Replacement 13,526 767 7,696 6,000 6,000 Valve Maintenance 601 49400 01 229.04 Miscellaneous Supplies 685 2,810 3,703 4,000 4,000 601 49400 01 240.00 Safety Equipment & PPE - 509 808 500 1,000 Vests, Glasses, Gloves, Hardhats, etc. 601 49400 01 241.00 Small Tools 1,782 2,254 2,259 2,500 2,500 Wrenches, Shovels, etc. 601 49400 01 242.00 Minor Equipment 6,052 13,400 10,750 16,000 7,500 601 49400 01 303.00 Engineering Fees 183,952 601 49400 01 303.01 WHPP 21,302 - - 5,000 5,000 Groundwater Plan Implementation 601 49400 01 303.02 GIS - - - 1,000 1,000 $5,000 Split 5 Ways 601 49400 01 303.03 Rate Study 19,172 - - 5,000 5,000 601 49400 01 303.04 Miscellaneous Fees 2,745 30,635 9,403 15,000 15,000 601 49400 01 304.00 Legal Fees 1,226 242 511 1,000 1,000 601 49400 01 310.00 Testing Services 601 49400 01 310.01 Bacteria & Water Quality 3,572 2,776 3,170 5,000 6,000 MN, Radon, Tri-Chl., Pesticides, Etc. 601 49400 01 310.03 MDH Service Connection Fee 49,186 77,030 80,043 80,000 80,000 MDH Community Water Supply Services 2023 BUDGET WORKSHEETS WATER UTILITY 107 Page 2 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 2023 BUDGET WORKSHEETS WATER UTILITY 601 49400 01 312.00 Gopher State One-Call 1,794 1,824 3,490 2,500 3,500 $10,500 Annually Split 1/3 Each Utility 601 49400 01 313.00 Outsource Bill Printing/Mailing 6,618 6,221 6,438 8,300 8,300 601 49400 01 318.00 Contract Engineer - - - - - 601 49400 01 319.00 Other Professional Services 601 49400 01 319.01 Thaw Pipes, Check Leaks, etc.- 615 938 1,500 10,000 Implement Citywide Annual Leak Detecti 601 49400 01 319.02 Supervisory Controls 2,053 2,705 1,885 5,000 5,000 601 49400 01 319.03 Hazardous Chemical Permits 800 800 825 1,000 1,000 MN Department of Public Safety 601 49400 01 319.06 Contracted Hydrant Painting 9,212 - 7,260 11,000 11,000 601 49400 01 319.07 Antenna Expenses 3,842 49,645 17,846 20,000 20,000 Offset by Revenue 601-36220.00 601 49400 01 319.09 HVAC Maintenance Contract 1,702 1,788 2,968 4,000 5,000 Annual Insp/Maint, All Wells 601 49400 01 319.10 Landscape Maintenance 2,655 - 1,716 4,000 4,000 Landscaping upkeep around well houses 601 49400 01 319.11 Pest Control 539 574 69 1,000 1,000 601 49400 01 320.00 Credit Card Activity Fees 9,409 11,248 2,152 9,500 9,500 1/3 Cost of C/C Pymt Processing 601 49400 01 321.00 Telephone Costs 4,134 4,163 4,402 5,000 7,000 Cell Phones, Modesm, GPS 601 49400 01 322.00 Postage Costs 369 270 252 400 400 Outsource Mailing (313.00) 601 49400 01 323.00 Radio Units 6,282 5,255 1,409 1,000 1,000 601 49400 01 352.00 General Notices & Public Info 36 79 311 - - 601 49400 01 365.00 Workers Comp Insurance 13,863 15,088 15,572 12,000 12,000 Water's Share of Premiums 601 49400 01 369.00 Other Insurance 7,249 7,741 9,006 7,000 7,000 Water's Share of Premiums 601 49400 01 391.00 P.C. Maintenance 601 49400 01 391.01 U/B Software Maintenance 2,372 2,203 2,227 2,200 2,200 Added to Utility Budgets in 2012 601 49400 01 391.02 Auto Read Software Support 650 808 800 700 700 Added to Utility Budgets in 2012 601 49400 01 392.00 P.C. Accessories & Supplies 33 251 149 200 200 601 49400 01 393.00 P.C. Hardware Purchases 361 383 134 3,000 3,000 601 49400 01 394.00 P.C. Software Purchases 601 49400 01 394.01 Licensing & Maintenance 9,715 10,633 13,354 10,500 10,500 ESRI, Cartegraph, DataLink 601 49400 01 394.02 Online Subscriptions - - - 300 300 601 49400 01 394.03 New Software Purchases 983 - - 200 200 601 49400 01 403.00 Contracted R & M - Other Impr 52,829 44,985 30,176 85,000 50,000 Main Breaks, Gate Valves, Etc. 601 49400 01 421.00 Depreciation Expense - - 886,317 - - 601 49400 01 433.00 Dues & Subscriptions 250 300 2,695 500 500 Suburban Utility Supt Assn, MRWA 601 49400 01 435.00 Books & Pamphlets - 217 109 200 200 Reference Materials 601 49400 01 437.00 Conferences & Seminars 601 49400 01 437.01 MDH Training (Water School)2,066 624 3,488 3,000 4,000 Operator Licensing Training/Continuing 601 49400 01 437.02 AWWA Conference - 58 1,158 2,000 2,000 Duluth, Send 2 Staff 601 49400 01 437.03 CarteGraph, ESRI, GIS - 491 1,167 500 1,500 User Group, Conference, Training 601 49400 01 437.04 Miscellaneous Training 458 135 1,416 1,000 2,000 601 49400 01 439.00 Other Miscellaneous Charges 11,878 16,087 21,100 20,000 20,000 DNR Annual Water Appropriation Permit 601 49400 01 450.00 Sales Tax on Purchases - - - - - 601 49400 01 521.00 Building & Structure Purchases - - - - - 601 49400 01 530.00 Improvements Other Than Bldgs - - 601 49400 01 530.01 Well Inspections - 800 - 1,000 1,500 601 49400 01 530.02 Miscellaneous Improvements 13,156 4,046 13,996 50,000 20,000 601 49400 01 530.03 CRP of Watermain - - - 50,000 50,000 St Improv Prgm Water Replacements 601 49400 01 530.04 Inspection & Maintenance 601,050 141,920 4,243 100,000 75,000 Water Tower Upkeep & Reconditioning 601 49400 01 540.00 Heavy Machinery Purchases - - - - 160,000 Equipment Purchases - Match CIP 601 49400 01 548.00 Lease Program-P.W. Vehicles 6,740 8,145 242 16,800 15,000 Vehicle Leases 601 49400 01 550.00 Motor Vehicle Purchases 43,080 - - - - 601 49400 01 570.00 Office Equipment Purchases - - - 500 500 601 49400 01 580.00 Other Equipment Purchases - - - - - 601 49400 01 611.00 Interest on Lease Payments 824 1,211 1,531 - - P.W. Building Expansion 601 49400 01 710.00 Transfers 57,500 39,338 202,168 - - Transfers for Other Improvements OPERATING EXPENDITURES 1,741,237 1,210,149 2,242,168 1,421,600 1,575,660 601 49406 01 221.00 Equipment Parts 379 278 1,007 200 200 601 49406 01 223.00 Building Repair Supplies - - - 200 200 601 49406 01 319.00 Other Professional Services - 560 2,396 1,000 1,000 601 49406 01 381.00 Electric Utilities 1,846 2,442 398 1,300 1,300 Pumping & Lighting TOTAL PRV EXPENDITURES 2,225 3,279 3,801 2,700 2,700 601 49407 01 221.00 Equipment Parts 196 - 3,761 1,500 1,500 601 49407 01 223.00 Building Repair Supplies - - - 200 200 601 49407 01 319.00 Other Professional Services - - 14,197 - - 601 49407 01 321.00 Telephone Costs 211 211 211 300 300 601 49407 01 381.00 Electric Utilities 16,267 1,906 13,434 33,000 33,000 Pumping, Lighting, Tower Mixer 601 49407 01 409.00 Other Contracted Repairs & Maint 4,715 19,042 26,856 2,000 2,000 601 49407 01 439.00 Other Miscellaneous Charges - - - 100 100 108 Page 3 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 2023 BUDGET WORKSHEETS WATER UTILITY 601 49407 01 530.00 Improvements Other Than Bldgs 1,853 - 2,570 2,000 2,000 Standby Generator in 2019 TOTAL WELL #7 EXPENDITURES 23,241 21,158 61,029 39,100 39,100 601 49408 01 221.00 Equipment Parts - 3,995 15,795 1,500 1,500 601 49408 01 223.00 Building Repair Supplies - -- 200 200 601 49408 01 319.00 Other Professional Services - -- - - 601 49408 01 381.00 Electric Utilities 19,796 20,340 23,979 25,000 25,000 Pumping & Lighting 601 49408 01 383.00 Gas Utilities 365 383 556 600 600 Heat Only 601 49408 01 409.00 Other Contracted Repairs & Maint 2,005 350 5,049 2,000 2,000 601 49408 01 439.00 Other Miscellaneous Charges - - - 100 100 TOTAL WELL #8 EXPENDITURES 22,166 25,068 45,379 29,400 29,400 601 49409 01 221.00 Equipment Parts 196 - 2,449 1,500 1,500 601 49409 01 223.00 Building Repair Supplies - - - 200 200 601 49409 01 319.00 Other Professional Services - - - - - 601 49409 01 381.00 Electric Utilities 28,305 28,820 26,994 32,000 32,000 Pumping & Lighting 601 49409 01 383.00 Gas Utilities 664 561 726 1,500 1,500 Heat Only 601 49409 01 409.00 Other Contracted Repairs & Maint 1,719 1,664 6,018 4,000 4,000 Paint Generator in 2020 601 49409 01 439.00 Other Miscellaneous Charges - 34 - 100 100 601 49409 01 530.00 Improvements Other Than Bldgs - -- -- TOTAL WELL #9 EXPENDITURES 30,884 31,079 36,187 39,300 39,300 601 49410 01 219.00 Other Operating Supplies - - - 500 500 601 49410 01 221.00 Equipment Parts 6,557 75 - 1,000 4,500 Meter for pumping measurement (2023 o 601 49410 01 223.00 Building Repair Supplies - - - 200 200 601 49410 01 321.00 Telephone Costs 765 765 765 - - 601 49410 01 381.00 Electric Utilities 14,345 15,886 16,861 17,000 17,000 Pumping & Lighting 601 49410 01 409.00 Other Contracted Repairs & Maint 403 5,827 268 2,000 2,000 601 49410 01 439.00 Other Miscellaneous Charges - - - 100 100 601 49410 01 530.00 Improvements Other Than Bldgs - - - - - TOTAL WELL #10 EXPENDITURES 22,069 22,552 17,894 20,800 24,300 601 49411 01 221.00 Equipment Parts - - - - 4,500 Meter for pumping measurement (2023 o 601 49411 01 439.00 Other Miscellaneous Charges - - - - - TOTAL WELL #11 EXPENDITURES - - - - 4,500 Rural Water System (#2) 601 49412 01 221.00 Equipment Parts 434 7,157 7,641 1,500 1,500 601 49412 01 223.00 Building Repair Supplies - 723 - 200 200 601 49412 01 319.00 Other Professional Services - -- -- 601 49412 01 381.00 Electric Utilities 24,403 34,825 30,339 28,000 28,000 Pumping & Lighting 601 49412 01 409.00 Other Contracted Repairs & Maint 8,680 874 23,489 2,000 2,000 601 49412 01 439.00 Other Miscellaneous Charges - - - 100 100 TOTAL WELL #12 EXPENDITURES 33,516 43,579 61,469 31,800 31,800 601 49414 01 221.00 Equipment Parts - 9,832 - 1,500 1,500 601 49414 01 223.00 Building Repair Supplies - 225 - 200 200 601 49414 01 319.00 Other Professional Services - -- 1,000 1,000 601 49414 01 381.00 Electric Utilities 19,012 36,253 34,163 28,000 28,000 Pumping & Lighting 601 49414 01 409.00 Other Contracted Repairs & Maint 27,476 2,216 3,218 2,000 2,000 601 49414 01 439.00 Other Miscellaneous Charges - - - 100 100 TOTAL WELL #14 EXPENDITURES 46,488 48,526 37,381 32,800 32,800 601 49425 01 221.00 Equipment Parts 559 361 - 1,500 1,500 601 49425 01 223.00 Building Repair Supplies 28 723 - 200 200 601 49425 01 319.00 Other Professional Services - - 964 500 500 601 49425 01 381.00 Electric Utilities 17,999 30,971 37,744 30,000 30,000 Pumping & Lighting 601 49425 01 409.00 Other Contracted Repairs & Maint 1,742 14,898 6,035 2,000 2,000 601 49425 01 439.00 Other Miscellaneous Charges - - 339 100 100 TOTAL WELL #15 EXPENDITURES 20,327 46,952 45,082 34,300 34,300 601 49426 01 221.00 Equipment Parts 260 409 - 1,500 1,500 601 49426 01 223.00 Building Repair Supplies - 22 - 200 200 601 49426 01 319.00 Other Professional Services - -- 500 500 601 49426 01 381.00 Electric Utilities 22,821 27,748 33,845 28,000 28,000 Pumping & Lighting 109 Page 4 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 2023 BUDGET WORKSHEETS WATER UTILITY 601 49426 01 383.00 Gas Utilities - - - - - 601 49426 01 409.00 Other Contracted Repairs & Maint 978 - 3,186 1,000 1,000 601 49426 01 439.00 Other Miscellaneous Charges - - - 100 100 TOTAL WELL #16 EXPENDITURES 24,059 28,179 37,031 31,300 31,300 601 49415 01 221.00 Equipment Parts - 60 500 500 500 601 49415 01 319.00 Other Professional Services - -- - - 601 49415 01 409.00 Other Contracted Repairs & Maint 7,390 - 500 500 500 601 49415 01 439.00 Other Miscellaneous Charges - - 200 200 200 TOTAL WATER TOWER #1 EXPENDITURES 7,390 60 1,200 1,200 1,200 601 49416 01 221.00 Equipment Parts 10 - 500 500 500 601 49416 01 319.00 Other Professional Services - - - - - 601 49416 01 381.00 Electric Utilities 2,675 2,898 4,500 4,500 4,500 601 49416 01 409.00 Other Contracted Repairs & Maint 4,884 16,890 500 500 500 601 49416 01 439.00 Other Miscellaneous Charges - - 200 200 200 TOTAL WATER TOWER #2 EXPENDITURES 7,569 19,788 5,700 5,700 5,700 601 49417 01 221.00 Equipment Parts 10 1,920 500 500 500 601 49417 01 319.00 Other Professional Services - - - - - 601 49417 01 381.00 Electric Utilities 1,881 1,560 6,000 6,000 6,000 601 49417 01 409.00 Other Contracted Repairs & Maint 1,052 746 500 500 500 601 49417 01 439.00 Other Miscellaneous Charges - - 200 200 200 TOTAL WATER TOWER #4 EXPENDITURES 2,943 4,225 7,200 7,200 7,200 601 49418 01 221.00 Equipment Parts - - 500 500 500 601 49418 01 319.00 Other Professional Services - - - - - 601 49418 01 381.00 Electric Utilities 1,867 1,566 4,000 4,000 4,000 601 49418 01 409.00 Other Contracted Repairs & Maint - 1,927 500 500 500 601 49418 01 439.00 Other Miscellaneous Charges - -200 200 200 TOTAL WATER TOWER #3 EXPENDITURES 1,867 3,493 5,200 5,200 5,200 WATER UTILITY DEPARTMENT TOTALS 1,985,979 1,508,088 2,606,721 1,702,400 1,864,460 110 Sewer Fund  This is an Enterprise Fund consisting of revenues from sewer charges which provides for the  operation and maintenance of 11 lift stations, 113 miles of sanitary sewer lines and 7,780  service connections for the collection and treatment of sewage.  $1,546,945 covers one‐line  item of the 2022 Sewer Fund budget for the charges paid to the Metropolitan Council for the  City's share of the operations and debt for wastewater treatment plants within the  metropolitan area.  These charges, which make up 58 percent of the Sewer Fund budget, are  based on sewage flows into the Metropolitan Council treatment plant.  Performance Measures  23.7% 31.3%30.1% 0.8%0.25%0.06%0.03% 0.0% 5.0% 10.0% 15.0% 20.0% 25.0% 30.0% 35.0% 2015 2016 2017 2018 2019 2020 2021 In 2018, we began a program to televise 1/3 of the city every year and only clean the lines  that need it (less than one mile needed cleaning in 2018).  We anticipate this will save  approximately 500‐600 staff hours per year and will extend the life of the Sanitary Sewer System Cleaned 0 0.02 0.04 0.06 0.08 0.1 2015 2016 2017 2018 2019 2020 2021 2015 2016 2017 2018 2019 2020 2021 Sewer Blockages 0.1 0 0 0 0 0 0.01 City System Sewer Blockages per 100 Connections 111 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 602 33425.00 Other State Grants & Aids 712 926 593 - - _ 602 34108.00 Administrative Fees-Other Funds 9,327 11,753 11,890 6,300 6,300 5% of 5% Fees-Const Projects 602 36101.00 Principal - Special Assessments 74,262 78,437 1,055 75,000 75,000 602 36101.01 Principal - Special Assessments 73,987 602 36101.03 Principal - Special Assessments 2,801 602 36101.05 Principal - Special Assessments 239 602 36101.11 Principal - Special Assessments 656 602 36102.00 Penalties & Interest - S/A 976 1,241 (602) - - 602 36210.00 Interest Earnings - Investments 35,973 17,929 12 20,000 22,000 602 36214.00 Net Change in FV-Investments 9,532 - - - - Annual Market Value Changes 602 36215.00 Interest Earnings 2,454 1,182 576 1,000 602 36260.00 Other Revenues - - - - - 602 36265.00 Use of Reserve Funds - - - 417,700 - 602 36270.00 Capital Contributions - - 1,396,128 - - 602 37210.00 Residential Sewer Revenues 1,462,480 1,708,988 1,750,809 1,600,000 1,700,000 602 37220.00 Apartment Sewer Revenues 185,515 322,401 346,454 190,000 210,000 602 37225.00 Institutional Sewer Revenues 30,960 36,465 46,594 35,000 35,000 602 37230.00 Commercial Sewer Revenues 104,954 153,611 171,922 110,000 140,000 602 37240.00 Industrial Sewer Revenues 153,486 217,021 246,277 160,000 160,000 602 37260.00 Penalties - Sewer Revenues 15,648 7,703 19,506 15,000 15,000 602 39103.00 Gain or Loss from F/A Disposal - - - - - 602 39203.00 Transfer From_______________- - (43,488) - - DEPARTMENT REVENUES 2,086,280 2,557,656 4,025,410 2,630,000 2,363,300 602 49450 77 101.00 Salaries & Benefits - Administrative 154,976 156,249 142,872 196,400 198,985 All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 602 49450 77 102.00 Full-Time Overtime - Administrative - - - - - 602 49450 78 101.00 Salaries & Benefits - Technical/Clerica 169,268 179,462 177,341 200,400 205,200 602 49450 78 102.00 Full-Time Overtime - Technical/Clerica 486 670 659 - - 602 49450 79 101.00 Salaries & Benefits - Maintenance 183,174 151,204 163,211 176,400 192,690 602 49450 79 102.00 Full-Time Overtime - Maintenance 15,957 10,096 8,801 7,500 9,500 602 49450 99 103.00 Part-Time Salaries & Benefits 8,479 4,011 10,160 8,700 9,200 602 49450 01 203.00 Printed Forms & Paper - - - 100 100 Outsource Bill Printing (313.00) 602 49450 01 205.00 Plotter Ink & Paper - - - 400 400 602 49450 01 209.00 Other Office Supplies 25 386 149 200 200 602 49450 01 212.00 Motor Fuels 3,100 3,100 4,400 3,100 3,100 2% Covered by Sewer Utility 602 49450 01 216.00 Chemicals & Chemical Products - - - 500 500 Root Killer, Degreaser 602 49450 01 219.00 Other Operating Supplies 549 - 441 200 200 602 49450 01 224.00 Street Maintenance Materials 2,113 3,486 624 2,500 2,500 Patching 602 49450 01 225.00 Landscaping Materials - - 42 400 400 Topsoil, Seed & Sod 602 49450 01 227.00 Utility System Maintenance Supplies 1,894 682 1,791 5,000 5,000 MH Castings Stock 602 49450 01 240.00 Safety Equipment & PPE - 539 629 500 500 Vests, Glasses, Gloves, Hardhats, etc. 602 49450 01 241.00 Small Tools 635 653 477 1,000 1,000 Wrenches, Shovels, etc. 602 49450 01 242.00 Minor Equipment 2,741 1,588 1,753 4,000 2,500 602 49450 01 303.00 Engineering Fees 602 49450 01 303.01 GIS - - 1,087 1,000 1,000 $5,000 Split 5 Ways 602 49450 01 303.02 Rate Study 34,043 300 - - - 602 49450 01 303.04 Miscellaneous 13,569 508 26,088 5,000 5,000 602 49450 01 312.00 Gopher State One-Call 1,794 1,824 3,490 2,500 3,500 $10,500 Annually Split 1/3 Each Utility 602 49450 01 313.00 Outsource Bill Printing/Mailing 6,618 6,221 6,438 8,300 8,300 602 49450 01 318.00 Contract Engineer - - - - - 602 49450 01 319.00 Other Professional Services 602 49450 01 319.01 Televising 56,634 58,697 66,594 53,000 60,000 3-Year Citywide Televising Program 602 49450 01 319.02 Root Control - - - 2,000 2,000 602 49450 01 319.03 Supervisory Controls(Maint Cont)818 1,265 162 5,000 5,000 SCADA System 602 49450 01 319.04 Lift Station Inspection - - 3,330 3,500 3,500 Pump Inspection at All Lift Stations 602 49450 01 319.05 Landscape Maintenance - - - 1,500 1,500 At Lift Stations 602 49450 01 320.00 Credit Card Activity Fees 9,409 11,248 2,152 9,500 9,500 1/3 Cost of C/C Pymt Processing 602 49450 01 321.00 Telephone Costs 3,819 3,826 4,157 5,000 7,000 Cell Phones, Modesm, GPS 602 49450 01 322.00 Postage Costs 310 265 252 400 400 Outsource Mailing (313.00) 602 49450 01 323.00 Radio Units 6,282 5,255 1,409 1,000 1,000 602 49450 01 365.00 Workers Comp Insurance 13,717 14,931 15,409 12,000 12,000 Sewer's Share of Premiums 602 49450 01 369.00 Other Insurance 11,006 10,056 11,585 17,000 17,000 Sewer's Share of Premiums 602 49450 01 391.00 P.C. Maintenance 602 49450 01 391.01 U/B Software Maintenance 2,372 2,203 2,227 2,200 2,200 602 49450 01 391.02 Auto Read Software Support 650 808 800 700 700 602 49450 01 392.00 P.C. Accessories & Supplies - - 13 200 200 602 49450 01 393.00 P.C. Hardware Purchases 361 696 134 3,000 3,000 602 49450 01 394.00 P.C. Software Purchases 2023 BUDGET WORKSHEETS SEWER UTILITY 112 Page 2 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 2023 BUDGET WORKSHEETS SEWER UTILITY 602 49450 01 394.01 Licensing & Maintenance 9,715 10,420 9,372 10,500 10,500 ESRI, Cartegraph, DataLink 602 49450 01 394.02 Online Subscriptions - - - 300 300 Pictometry 602 49450 01 394.03 New Software Purchases 983 1,650 - 200 200 602 49450 01 395.00 P.C. Repairs - - - - - 602 49450 01 403.00 Contracted R & M - Other Impr 11,769 (71) 10,478 70,000 25,000 MH Castings Replacement Program 602 49450 01 415.00 Other Equipment Rental - 1,078 - 200 200 602 49450 01 416.00 Machinery Rental 518 - 592 2,000 2,000 602 49450 01 421.00 Depreciation Expense - -960,190 - - 602 49450 01 433.00 Dues & Subscriptions 127 - - 300 300 SUSA Split w/603 602 49450 01 435.00 Books & Pamphlets - -- 300 300 Reference Materials 602 49450 01 437.00 Conferences & Seminars 602 49450 01 437.01 MPCA Training (Sewer School)803 23 203 2,500 2,500 Operator Licensure $400 each (M) 602 49450 01 437.03 CarteGraph, ESRI, GIS - 491 1,167 500 1,500 User Group, Conference, Training 602 49450 01 437.04 Miscellaneous Training 496 215 667 1,000 1,000 602 49450 01 439.00 Other Miscellaneous Charges 126 317 3,371 300 300 Contingencies 602 49450 01 521.00 Building & Structure Purchases - - - - - Final Payment in 2018 602 49450 01 530.00 Improvements Other Than Bldgs 602 49450 01 530.01 Miscellaneous Improvements 7,695 3,484 175,817 300,000 300,000 LS No. 7 & LS No. Cabinet Replacments 602 49450 01 530.03 CRP of Sewermain - 30,600 - 150,000 175,000 St Improv Prgm Sewer Replacements 602 49450 01 540.00 Heavy Machinery Purchases 4,538 1,366 - - 45,000 Matches CIP 602 49450 01 548.00 Lease Program-P.W. Vehicles - - 242 10,065 7,000 Vehicle Leases 602 49450 01 550.00 Motor Vehicle Purchases 43,090 - - - - 602 49450 01 560.00 Furniture & Fixture Purchases - - 218 500 500 602 49450 01 570.00 Office Equipment Purchases - - - 500 500 602 49450 01 580.00 Other Equipment Purchases - - - - 100,000 Portable Generator (Split 3 Ways) 602 49450 01 602.00 Sewer Service Charges 1,303,112 1,386,562 1,311,672 1,311,700 1,653,500 MWCC Chgs (Matches Rate Model) 602 49450 01 611.00 Interest on Lease Payments - 117 437 - - P.W. Building Expansion(See 521) 602 49450 01 710.00 Transfers - 38,025 75,561 - - Transfers for Other Improvements OPERATING EXPENDITURES 2,087,775 2,104,507 3,208,665 2,600,965 3,100,375 602 49451 01 219.00 Other Operating Supplies - 3,310 - 3,200 3,200 602 49451 01 221.00 Equipment Parts 760 - - 800 800 602 49451 01 229.00 Other Maintenance Supplies - -- 200 200 602 49451 01 303.00 Engineering Fees - -- - - 602 49451 01 381.00 Electric Utilities 2,750 2,925 2,825 3,000 3,000 602 49451 01 403.00 Contracted R & M - Other Impr - 347 26,478 2,000 2,000 602 49451 01 439.00 Other Miscellaneous Charges - -- 100 100 TOTAL LIFT STATION #1 EXPENDITURES 3,510 6,582 29,303 9,300 9,300 602 49452 01 219.00 Other Operating Supplies - - - 100 100 602 49452 01 221.00 Equipment Parts 3,361 - - 800 800 602 49452 01 229.00 Other Maintenance Supplies - 31 - 200 200 602 49452 01 381.00 Electric Utilities 417 518 485 700 700 602 49452 01 403.00 Contracted R & M - Other Impr 471 1,323 4,368 2,000 2,000 602 49452 01 439.00 Other Miscellaneous Charges - - - 100 100 TOTAL LIFT STATION #7 EXPENDITURES 4,249 1,872 4,853 3,900 3,900 602 49453 01 219.00 Other Operating Supplies - 3,310 - 100 100 602 49453 01 221.00 Equipment Parts 3,694 - - 800 800 602 49453 01 229.00 Other Maintenance Supplies - - - 200 200 602 49453 01 381.00 Electric Utilities 3,572 4,330 2,799 4,000 4,000 602 49453 01 403.00 Contracted R & M - Other Impr 27,983 118,426 4,035 2,000 2,000 602 49453 01 439.00 Other Miscellaneous Charges 568 - - 100 100 TOTAL LIFT STATION #3 EXPENDITURES 35,817 126,066 6,834 7,200 7,200 602 49454 01 219.00 Other Operating Supplies - - - 100 100 602 49454 01 221.00 Equipment Parts - - - 800 800 602 49454 01 229.00 Other Maintenance Supplies - - - 200 200 602 49454 01 381.00 Electric Utilities 5,612 4,610 2,898 6,000 6,000 602 49454 01 403.00 Contracted R & M - Other Impr 142 41,931 275 2,000 2,000 602 49454 01 439.00 Other Miscellaneous Charges - - - 100 100 TOTAL LIFT STATION #4 EXPENDITURES 5,754 46,541 3,173 9,200 9,200 602 49455 01 219.00 Other Operating Supplies - - - 100 100 113 Page 3 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 2023 BUDGET WORKSHEETS SEWER UTILITY 602 49455 01 221.00 Equipment Parts - - - 800 800 602 49455 01 229.00 Other Maintenance Supplies - - - 200 200 602 49455 01 303.00 Engineering Fees - - - - - 602 49455 01 310.00 Testing Services - - - - - 602 49455 01 381.00 Electric Utilities 5,062 5,822 4,034 6,000 6,000 602 49455 01 403.00 Contracted R & M - Other Impr 2,658 74,926 3,135 2,000 2,000 602 49455 01 439.00 Other Miscellaneous Charges - - - 100 100 TOTAL LIFT STATION #5 EXPENDITURES 7,720 80,747 7,169 9,200 9,200 602 49456 01 219.00 Other Operating Supplies - - - 100 100 602 49456 01 221.00 Equipment Parts - - - 800 800 602 49456 01 229.00 Other Maintenance Supplies - - - 200 200 602 49456 01 381.00 Electric Utilities 6,360 3,557 1,738 6,000 6,000 602 49456 01 403.00 Contracted R & M - Other Impr 415 347 3,859 2,000 2,000 602 49456 01 439.00 Other Miscellaneous Charges - - - 100 100 _ TOTAL LIFT STATION #6 EXPENDITURES 6,775 3,904 5,597 9,200 9,200 602 49457 01 219.00 Other Operating Supplies - - - 100 100 602 49457 01 221.00 Equipment Parts 12 - - 500 500 602 49457 01 229.00 Other Maintenance Supplies - - - 200 200 602 49457 01 381.00 Electric Utilities 1,371 1,539 1,578 1,200 1,200 602 49457 01 403.00 Contracted R & M - Other Impr 5,410 1,053 - 2,000 2,000 602 49457 01 439.00 Other Miscellaneous Charges - - - 100 100 TOTAL LIFT STATION #9 EXPENDITURES 6,793 2,593 1,578 4,100 4,100 602 49458 01 219.00 Other Operating Supplies - - - 100 100 602 49458 01 221.00 Equipment Parts - - - 500 500 602 49458 01 229.00 Other Maintenance Supplies - - - 200 200 602 49458 01 381.00 Electric Utilities 421 448 472 800 800 602 49458 01 403.00 Contracted R & M - Other Impr - 347 135 2,000 2,000 602 49458 01 439.00 Other Miscellaneous Charges - -- 100 100 TOTAL LIFT STATION #8 EXPENDITURES 421 796 607 3,700 3,700 602 49460 01 219.00 Other Operating Supplies - - - 100 100 602 49460 01 221.00 Equipment Parts - 500 - 500 500 602 49460 01 229.00 Other Maintenance Supplies - -- 200 200 602 49460 01 381.00 Electric Utilities 339 304 346 400 400 602 49460 01 403.00 Contracted R & M - Other Impr - 22,583 - 2,000 2,000 602 49460 01 439.00 Other Miscellaneous Charges - -- 100 100 TOTAL LIFT STATION #10 EXPENDITURES 339 23,387 346 3,300 3,300 602 49461 01 219.00 Other Operating Supplies - - - 100 100 602 49461 01 221.00 Equipment Parts - - - 500 500 602 49461 01 229.00 Other Maintenance Supplies - - - 200 200 602 49461 01 381.00 Electric Utilities - - - 400 400 602 49461 01 403.00 Contracted R & M - Other Impr - 2,102 - 2,000 2,000 602 49461 01 439.00 Other Miscellaneous Charges - -- 100 100 TOTAL LIFT STATION #11 EXPENDITURES - 2,102 - 3,300 3,300 602 49462 01 219.00 Other Operating Supplies - - - 100 100 602 49462 01 221.00 Equipment Parts - - - 500 500 602 49462 01 229.00 Other Maintenance Supplies - - - 200 200 602 49462 01 381.00 Electric Utilities - 363 485 400 400 602 49462 01 403.00 Contracted R & M - Other Impr - 347 681 2,000 2,000 602 49462 01 439.00 Other Miscellaneous Charges - -- 100 100 TOTAL LIFT STATION #12 EXPENDITURES - 711 1,166 3,300 3,300 SEWER UTILITY DEPARTMENT TOTALS 2,159,153 2,399,809 3,269,291 2,666,665 3,166,075 114 Storm Water Fund  This is an Enterprise Fund consisting of revenues from storm water utility charges that provides  for the operation and maintenance of the City’s storm water facilities, which includes:  10 lift stations 5,195 catch basins 135 miles of storm sewer More than 65 storm water treatment ponds This fund pays for cleaning storm drain sumps in manholes and catch basins, and for ditching in  rural areas.  It funds wetland investigations and the assimilation of a wetland inventory for the  City.  Most of the remaining operating budget is used to pay for large projects in which debt is  issued.  Repayment of this debt is accomplished through fund transfers to the appropriate debt  service funds.  Performance Measures  Prior to 2018, all sumps were inspected every year.  Sumps that were more than half‐full were  also cleaned.  In 2015, many sumps that had rated just below the cleaning threshold for several  years were finally cleaned, causing the large spike in numbers that year. Starting in 2018, it was  determined that sumps that have been less than half‐full for each of the previous two years do  not need to be inspected; however, all sumps will be inspected at least once every three years  and cleaned as needed when more than half‐full.  0 100 200 300 400 500 600 2015 2016 2017 2018 2019 2020 2021 562 134 68 183 52 178 102 Number of Sumps Cleaned 115 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 603 33400.00 State Grants & Aids 596 839 - - - 603 33425.00 Other State Grants & Aids - - 574 - - 603 33620.00 Other County Grants & Aids 125 - - - - 603 34108.00 Administrative Fees-Other Funds 9,327 11,753 11,890 6,300 6,300 5% of 5% Fees-Const Projects 603 34115.00 Buffer Monumentation 1,800 2,450 - 2,000 2,000 603 36101.00 Principal - Special Assessments 23,418 24,414 1,805 25,000 25,000 603 36101.01 Principal - Special Assessments 23,038 603 36101.03 Principal - Special Assessments 947 603 36101.05 Principal - Special Assessments 81 603 36101.11 Principal - Special Assessments 217 603 36102.00 Penalties & Interest - S/A 366 417 (223) - - 603 36210.00 Interest Earnings - Investments 126,227 83,834 89,058 40,000 70,000 603 36214.00 Net Change in FV-Investments (2,944) 78,746 (78,746) - - Annual Market Value Changes 603 36215.00 Interest Earnings 3,826 2,076 746 1,000 - 603 36260.00 Other Revenues - - 3,938 - - 603 36262.00 Special Settlements - - - - - 603 36265.00 Use of Reserve Funds - - - - - 603 36270.00 Capital Contributions - - 2,563,806 - - 603 37300.00 Storm Water Utility Revenues 1,295,790 1,422,689 1,462,178 1,740,000 1,740,000 Based on rate model 603 37360.00 Penalties - Storm Water Utility 6,272 3,118 9,639 7,000 7,000 603 39103.00 Gain or Loss from F/A Disposal - - - - - 603 39203.00 Transfer From______________ 492,427 81,291 33,263 - - DEPARTMENT REVENUES 1,957,229 1,711,626 4,122,210 1,821,300 1,850,300 603 49500 77 101.00 Salaries & Benefits - Administrative 153,628 230,897 193,161 176,900 177,340 All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 603 49500 77 102.00 Full-Time Overtime - Administrative - - - - - 603 49500 78 101.00 Salaries & Benefits - Technical/Clerica 196,703 230,385 239,213 263,200 260,360 603 49500 78 102.00 Full-Time Overtime - Technical/Clerica 390 634 638 - - 603 49500 79 101.00 Salaries & Benefits - Maintenance 110,285 96,455 104,955 113,700 125,250 603 49500 79 102.00 Full-Time Overtime - Maintenance 9,183 6,501 5,591 6,000 6,600 603 49500 99 103.00 Part-Time Salaries & Benefits 7,596 3,713 9,999 8,700 9,200 603 49500 01 203.00 Printed Forms & Paper - 75 - 100 100 Outsource Bill Printint (313.00) 603 49500 01 205.00 Plotter Ink & Paper - -- 400 400 603 49500 01 208.00 Miscellaneous Supplies - 704 157 500 500 Stakes, Ribbons, Level, etc. 603 49500 01 209.00 Other Office Supplies - -48 - - 603 49500 01 212.00 Motor Fuels 4,700 4,700 1,180 4,700 4,700 3% Covered by Storm Utility 603 49500 01 224.00 Street Maintenance Materials 1,775 3,046 311 3,000 3,000 Patching Material for Washouts 603 49500 01 225.00 Landscaping Materials 603 49500 01 225.01 Rip-Rap, Matting, Rock, etc.765 703 - 3,000 3,000 603 49500 01 225.02 Black Dirt, Seed, Sod, etc.240 1,217 1,457 1,000 1,000 603 49500 01 226.00 Sign Repair Materials 4,443 - - 3,000 3,000 Wetland Buffer Signs 603 49500 01 230.00 Repair Materials & Supplies 1,368 2,598 2,140 3,000 3,000 Culverts, Catch Basins, Structures 603 49500 01 240.00 Safety Equipment & PPE - 509 453 500 1,000 Vests, Glasses, Gloves, Hardhats, etc. 603 49500 01 241.00 Small Tools 923 309 1,536 1,500 1,500 603 49500 01 242.00 Minor Equipment 2,972 7,508 1,290 3,500 3,500 603 49500 01 303.00 Engineering Fees 603 49500 01 303.01 Problem Area Investigations - - - 5,000 5,000 603 49500 01 303.02 NPDES Phase II 14,197 5,866 4,674 5,000 5,000 603 49500 01 303.03 CSMP Update 12,965 - - 2,000 2,000 603 49500 01 303.04 Miscellaneous 45,435 99,045 88,690 10,000 10,000 603 49500 01 303.05 GIS - - - 1,000 1,000 $5,000 Split 5 Ways 603 49500 01 304.00 Legal Fees 34 425 722 2,000 2,000 603 49500 01 310.00 Testing Services - - - Water Quality Tests (M) 603 49500 01 312.00 Gopher State One-Call 1,794 1,824 3,490 2,500 3,500 $10,500 Annually Split 1/3 Each Utility 603 49500 01 313.00 Outsource Bill Printing/Mailing 6,618 6,221 6,438 8,300 8,300 603 49500 01 315.00 Special Programs 4,500 2,700 4,500 5,000 10,000 WHEP, CAMP, MCSC, Adopt A Drain, N 603 49500 01 318.00 Contract Engineer - - - 603 49500 01 319.00 Other Professional Services 603 49500 01 319.01 SCADA 4,223 1,265 819 5,000 5,000 603 49500 01 319.02 Lift Station Inspection - - 3,330 3,500 3,500 Pump Inspection at All Lift Stations 603 49500 01 319.03 Landscape Maintenance - - - 1,500 1,500 At Lift Stations 603 49500 01 320.00 Credit Card Activity Fees 9,409 11,248 2,152 9,500 9,500 1/3 Cost of C/C Pymt Processing 603 49500 01 321.00 Telephone Costs 4,266 4,857 5,418 5,000 7,000 Cell Phones, Modesm, GPS 603 49500 01 322.00 Postage Costs 310 265 252 400 400 Outsource Mailing (313.00) 603 49500 01 323.00 Radio Units 6,282 5,255 1,409 1,000 1,000 603 49500 01 351.00 Legal Notices Publishing - - 216 - - 603 49500 01 352.00 General Notices & Public Info - 1,234 980 1,000 1,000 603 49500 01 365.00 Workers Comp Insurance 10,255 11,658 14,520 6,000 6,000 Storm Water's Share of Premiums 2023 BUDGET WORKSHEETS STORM WATER UTILITY 116 Page 2 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 2023 BUDGET WORKSHEETS STORM WATER UTILITY 603 49500 01 369.00 Other Insurance 1,814 1,935 2,194 2,500 2,500 Storm Water's Share of Premiums 603 49500 01 391.00 P.C. Maintenance 603 49500 01 391.01 U/B Software Maintenance 2,372 2,203 2,227 2,200 2,200 603 49500 01 391.02 Auto Read Software Support 650 808 800 700 700 603 49500 01 393.00 P.C. Hardware Purchases 361 1,487 134 3,000 3,000 603 49500 01 394.00 P.C. Software Purchases 603 49500 01 394.01 Licensing & Maintenance 9,714 10,420 9,372 10,500 10,500 ESRI, Cartegraph, DataLink 603 49500 01 394.02 Online Subscriptions - - - 300 300 Pictometry 603 49500 01 394.03 New Software Purchases 983 - - 200 200 603 49500 01 403.00 Contracted R & M - Other Impr 603 49500 01 403.01 Ditching - 1,325 - 10,000 10,000 603 49500 01 403.02 Catch Basins, Manholes, Etc.93,304 33,076 176,636 150,000 165,000 Various Storm Structure Repairs 603 49500 01 403.03 Pond Inspection & Maintenance - 57,384 3,000 - 225,000 Pond Cleanout, Raingarden Maint 603 49500 01 405.00 MS4 Permit Compliance 603 49500 01 405.01 Engineering Fees 43,408 30,282 68,582 45,000 45,000 Inspection, GIS, Guidance, Etc. 603 49500 01 405.02 Equipment Rental 72,789 18,514 332 20,000 20,000 Bulldozer, Large Equipment 603 49500 01 405.03 Dirt, Seed, Rip Rap, Etc.607 - 1,800 5,000 5,000 For Restoration 603 49500 01 405.04 Contracted Maintenance 59,671 45,200 10,717 70,000 70,000 Brush Clearing, Dredging 603 49500 01 416.00 Machinery Rental - 373 593 2,500 2,500 Pumps 603 49500 01 421.00 Depreciation Expense - -813,384 - - 603 49500 01 433.00 Dues & Subscriptions 994 2,600 2,600 3,200 3,200 SUSA w/602, MN SW Coal, WS Part 603 49500 01 435.00 Books & Pamphlets 81 - - 500 500 Utility Information 603 49500 01 437.00 Conferences & Seminars 603 49500 01 437.01 Storm Water Management 737 360 - 1,200 1,200 Stormwater Collab, Flygt Training 603 49500 01 437.04 Cartegraph, ESRI, GIS - 491 662 500 1,500 User Group, Conference, Training 603 49500 01 437.05 Miscellaneous Training 583 250 1,472 2,000 2,500 MECA, Salt Symposium, MN Water Reso 603 49500 01 439.00 Other Miscellaneous Charges 421 392 351 300 300 603 49500 01 530.00 Improvements Other Than Bldgs 603 49500 01 530.01 CRP of Storm Sewer - - - 60,000 60,000 Capital Replacement Plan - Storm Syste 603 49500 01 530.02 Stormwater System Improvements - 197,227 109,999 200,000 200,000 St Improv Prgm Relate Storm Sys Improv 603 49500 01 540.00 Heavy Machinery Purchases 4,538 26,327 - 170,500 170,500 603 49500 01 548.00 Lease Program-P.W. Vehicles - 1,366 242 10,065 7,000 Vehicle Leases 603 49500 01 550.00 Motor Vehicle Purchases 43,070 - - - - 603 49500 01 560.00 Furniture & Fixture Purchases - - 218 500 500 603 49500 01 580.00 Other Equipment Purchases - 2,886 - 12,000 - No equipment attributable to account pla 603 49500 01 586.00 Computer Equipment Purchases - -- 500 500 603 49500 01 603 49500 01 611.00 Interest on Lease Payment - 117 437 - - 603 49500 01 603 49500 01 710.00 Transfers - - 603 49500 01 710.06 1/2 of 2018 P & I Payments(2010A) - - - 603 49500 01 710.10 Projects 296,254 243,765 127,073 OPERATING EXPENDITURES 1,247,610 1,420,608 2,032,561 1,449,565 1,694,750 603 49511 01 221.00 Equipment Parts - - - 500 500 603 49511 01 381.00 Electric Utilities 312 289 211 500 500 603 49511 01 403.00 Contracted Repair & Maintenance 1,197 347 - 1,000 1,000 TOTAL LIFT STATION #1 EXPENDITURES 1,508 637 211 2,000 2,000 603 49512 01 221.00 Equipment Parts - - - 500 500 603 49512 01 381.00 Electric Utilities - - - 500 500 603 49512 01 403.00 Contracted Repair & Maintenance 140 80,211 2,971 1,000 1,000 TOTAL LIFT STATION #2 EXPENDITURES 140 80,211 2,971 2,000 2,000 603 49513 01 221.00 Equipment Parts 9 - - 500 500 603 49513 01 381.00 Electric Utilities 8,784 8,342 2,696 7,200 7,200 603 49513 01 403.00 Contracted Repair & Maintenance 1,477 347 4,723 1,000 1,000 TOTAL LIFT STATION #3 EXPENDITURES 10,269 8,689 7,418 8,700 8,700 603 49514 01 221.00 Equipment Parts - - 236 500 500 603 49514 01 381.00 Electric Utilities 2,008 889 434 2,500 2,500 603 49514 01 403.00 Contracted Repair & Maintenance 817 747 - 1,000 1,000 TOTAL LIFT STATION #4 EXPENDITURES 2,824 1,637 670 4,000 4,000 603 49515 01 221.00 Equipment Parts - - - 500 500 603 49515 01 381.00 Electric Utilities - - - 500 500 117 Page 3 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 2023 BUDGET WORKSHEETS STORM WATER UTILITY 603 49515 01 403.00 Contracted Repair & Maintenance - 347 - 1,000 1,000 TOTAL LIFT STATION #5 EXPENDITURES - 347 - 2,000 2,000 603 49516 01 221.00 Equipment Parts 144 - - 500 500 603 49516 01 381.00 Electric Utilities 468 465 488 500 500 603 49516 01 403.00 Contracted Repair & Maintenance 507 1,467 - 1,000 1,000 TOTAL LIFT STATION #6 EXPENDITURES 1,119 1,932 488 2,000 2,000 603 49517 01 221.00 Equipment Parts - - - 500 500 603 49517 01 381.00 Electric Utilities 992 720 429 500 500 603 49517 01 403.00 Contracted Repair & Maintenance 160 1,251 - 1,000 1,000 TOTAL LIFT STATION #7 EXPENDITURES 1,152 1,971 429 2,000 2,000 603 49518 01 221.00 Equipment Parts - - - 500 500 603 49518 01 381.00 Electric Utilities - 224 207 500 500 603 49518 01 403.00 Contracted Repair & Maintenance - 2,102 - 1,000 1,000 TOTAL LIFT STATION #8 EXPENDITURES - 2,326 207 2,000 2,000 STORM WATER UTILITY DEPARTMENT TOTALS 1,264,623 1,518,357 2,044,955 1,474,265 1,719,450 118 Street Light Utility Fund  This is an Enterprise Fund consisting of revenues from street light utility charges which provides  for the electricity, operation and maintenance of 1,705 street lights.  The City is responsible for  repair and maintenance of 156 of the street lights, while Dakota Electric and Xcel Energy  perform the repair and maintenance on the remaining 1,549 lights.  The City pays for the  electrical costs for all lights.  Approximately 20 – 25 new street lights are added each year  through new development.  119 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 608 31010.00 Current Ad Valorem Taxes - - - - - 608 31020.00 Tax Increments - - - - - 608 34306.00 Other Highway & Street Revenue - 19,008 24,912 - - 608 36101.00 Principal - Special Assessments - 3,620 2,913 - - 608 36101.01 Principal - Special Assessments - - 3,306 - - 608 36101.03 Principal - Special Assessments - -229 - - 608 36101.05 Principal - Special Assessments - -20 - - 608 36102.00 Penalties & Interest - S/A - -5 - - 608 36210.00 Interest Earnings - Investments - -- - - 608 36215.00 Interest Earnings - 9 20 - - 608 36220.00 Rents & Royalties - - - - - 608 36260.00 Other Revenue - - - - - 608 36265.00 Use of Reserve Funds - - - - - 608 36270.00 Capital Contributions - - - - - 608 37400.00 Street Light Revenues - 226,771 208,925 220,000 220,000 608 37460.00 Penalties - Street Light Revenues - 775 1,804 - - 608 37470.00 Other Street Light Revenues - -- - - 608 39201.00 Transfer from General Fund - -- - - 608 39202.00 Contribution from Enterprises - -- - - 608 39203.00 Transfer from________________- -- - - DEPARTMENT REVENUES - 250,183 242,134 220,000 220,000 608 49508 77 101.00 Salaries & Benefits - Administrative - - - - - All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 608 49508 77 102.00 Full-Time Overtime - Administrative - - - - - 608 49508 78 101.00 Salaries & Benefits - Technical/Clerica - - - - - 608 49508 78 102.00 Full-Time Overtime - Technical/Clerica - - - - - 608 49508 79 101.00 Salaries & Benefits - Maintenance - - - - - 608 49508 79 102.00 Full-Time Overtime - Maintenance - - - - - 608 49508 99 103.00 Part-Time Salaries & Benefits - - - - - 608 49508 01 219.00 Other Operating Supplies - - 674 - - 608 49508 01 221.00 Equipment Parts - 1,602 - - - 608 49508 01 304.00 Legal Fees - - - - - 608 49508 01 313.00 Outsource Bill Print/Mail - 1,715 2,146 - - 608 49508 01 317.00 General Fund Admin Fees - - - - - 608 49508 01 319.00 Other Professional Services - - - - - 608 49508 01 322.00 Postage Costs - 39 84 - - 608 49508 01 352.00 General Notices & Public Info - - - - - 608 49508 01 381.00 Electric Utilities - 183,624 192,098 185,000 192,400 608 49508 01 394.00 P.C. Software Purchases - 750 - - - 608 49508 01 409.00 Other Contracted Repair & Maint.- 5,384 6,400 15,000 15,600 LED Conversions, Intersection Lights on 608 49508 01 421.00 Depreciation Expense - -- - - 608 49508 01 439.00 Other Miscellaneous Charges - -- - - 608 49508 01 530.00 Improvements Other Than Buildings - - 4,714 20,000 20,800 608 49508 01 710.00 Transfers - - - - - 608 49508 01 720.00 Transfers - - - - - OPERATING EXPENDITURES - 193,113 206,116 220,000 228,800 2023 BUDGET WORKSHEETS STREET LIGHT UTILITY 120 Ice Arena  Administration  The Parks and Recreation Department administer the Ice Arena.  Scheduling and invoicing of ice  are the main administrative duties of ice arena operations.  The scheduling of prime‐time ice is  coordinated with Independent School District #196 and Rosemount Area Hockey Association for  practices, games and tournament play.  The Parks and Recreation Department provides overall  planning, coordination, management of personnel and administration of ice arena activities.  Community Use  Provides recreational open skating for the residents of Rosemount as well as learning to skate  and figure skating programs.   Maintenance  Provides ongoing and preventative maintenance of the ice arena building structure and its  mechanical components.  Ensures ice is maintained at optimal efficiency.  Performance Measures  2,670 2,680 2,806 2,704 2,999 1,992 2,738 1,000 1,500 2,000 2,500 3,000 3,500 2015 2016 2017 2018 2019 2020 2021 Ice Arena Hours 121 Page 1 2022 2023 2019 2020 2021 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments --------------------- ---------------- ------------------------------------------------- ----------------- ---------------------------------- ----------------- ----------------- ---------------------------------------------------- 650 33425.00 Other State Grants & Aids 314 343 254 - - _ 650 36210.00 Interest Earnings - Investments 7,378 1,929 2,468 100 100 _ 650 36215.00 Interest Earnings 2,261 913 218 100 100 _ 650 36230.00 Contributions/Donations - - - - - _ 650 36260.00 Other Revenue - Learn to Skate 38,284 7,362 29,945 40,000 32,000 Learn to Skate Program (LTS) 650 36262.00 Special Settlements 1,500 - - - - _ 650 36265.00 Use of Reserve Funds - - - - - _ 650 38060.00 Prime Time Ice Fees 262,934 186,192 254,959 270,000 260,000 _ 650 38061.00 Non-Prime Time Ice Fees 98,480 90,409 131,394 100,000 131,000 _ 650 38063.00 Open Skating Ice Fees 9,322 2,132 4,465 10,000 5,000 _ 650 38065.00 Other Events - Arena - - - - - Dry Floor Events 650 38066.00 Advertising Revenue - Arena 17,625 22,393 17,000 20,000 21,000 _ 650 38067.00 Skate Sharpening Revenue-Arena 2,490 962 545 3,500 3,000 _ 650 38090.00 Concessions 1,500 - 1,500 1,500 1,500 _ 650 38091.00 Vending Machine Revenues 4,719 2,929 3,072 5,000 5,000 _ 650 38095.00 Pro Shop Revenues 988 364 473 1,500 1,500 Tape, Laces, Mouthguards, etc. 650 39103.00 Gain or Loss from F/A Disposal - - - - - _ 650 39201.00 Transfer From General Fund 130,000 130,000 130,000 130,000 130,000 Subsidy for Operations DEPARTMENT REVENUES 577,794 445,927 576,292 581,700 590,200 650 45130 77 101.00 Salaries & Benefits - Administrative 38,830 29,399 25,470 40,300 44,275 All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 650 45130 77 102.00 Full-Time Overtime - Administrative - - - - - 650 45130 78 101.00 Salaries & Benefits - Technical/Clerica 56,049 57,375 60,148 66,600 67,425 650 45130 78 102.00 Full-Time Overtime - Technical/Clerica 62 559 736 - - 650 45130 79 101.00 Salaries & Benefits - Maintenance 94,123 65,011 92,139 114,200 119,250 650 45130 79 102.00 Full-Time Overtime - Maintenance - - 126 2,000 2,000 650 45130 103.00 Part-Time Salaries & Benefits 55,421 42,507 51,572 53,000 56,000 650 45130 01 207.00 Training & Instructional Supplies - - - 100 100 _ 650 45130 01 208.00 Miscellaneous Supplies 700 _ 650 45130 01 208.01 Skate Magnets - - - 100 - 650 45130 01 208.02 Other Supplies - - - 600 - 650 45130 01 209.00 Other Office Supplies 34 - 234 500 500 Learn to Skate Program Supplies 650 45130 01 211.00 Cleaning Supplies 3,993 4,422 4,336 4,000 4,000 _ 650 45130 01 216.00 Chemicals & Chemical Products 2,485 1,237 3,778 6,000 6,000 Cooling Tower 650 45130 01 219.00 Other Operating Supplies 2,284 140 160 500 500 Events Supplies 650 45130 01 221.00 Equipment Parts 12,030 5,286 9,663 9,000 9,000 _ 650 45130 01 223.00 Building Repair Supplies 583 2,414 1,252 3,500 3,500 _ 650 45130 01 265.00 Other Items for Resale 1,067 - 992 1,000 1,000 Pro Shop Supplies 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 - - - 100 - 650 45130 01 349.00 Other Advertising 1,725 1,000 2,928 1,000 2,800 _ 650 45130 01 365.00 Workers Comp Insurance 6,611 6,779 7,442 3,500 3,500 _ 650 45130 01 369.00 Other Insurance 3,782 4,102 5,084 4,500 4,500 _ 650 45130 01 381.00 Electric Utilities 119,940 112,115 121,350 115,000 115,000 _ 650 45130 01 383.00 Gas Utilities 21,051 15,315 20,088 20,000 20,000 _ 650 45130 01 384.00 Refuse Disposal 2,615 2,743 2,615 3,000 3,000 _ 650 45130 01 401.00 Contracted Building Repairs 6,588 6,610 11,703 10,000 10,000 _ 650 45130 01 404.00 Contracted Mach & Equip Repairs 20,026 35,118 26,232 23,000 23,000 _ 650 45130 01 415.00 Other Equipment Rental - - - 300 300 _ 650 45130 01 421.00 Depreciation Expense - - 63,360 - - 650 45130 01 433.00 Dues & Subscriptions 475 675 475 1,000 1,000 MIAMA & MRPA Dues 650 45130 01 437.00 Conferences & Seminars 2,770 595 575 3,000 3,000 MIAMA & MRPA Seminars 650 45130 01 439.00 Other Miscellaneous Charges - - - - - REMOVE 650 45130 01 521.00 Building & Structure Purchases 30,269 32,749 18,202 15,000 15,000 Zamboni Batteries 650 45130 01 522.00 Building & Structure Purchases - 29,200 2,710 20,000 20,000 Restroom Rehab - Upper 650 45130 01 580.00 Other Equipment Purchases - -- - - _ 650 45130 01 581.00 Other Equipment Purchases - -- - - _ 650 45130 01 710.00 Transfers _ 650 45130 01 710.01 Yearly Maintenance 3,500 3,500 3,500 3,500 3,500 650 45130 01 710.02 _- - - _ DEPARTMENT EXPENDITURES 493,314 465,850 543,869 531,600 546,150 2023 BUDGET WORKSHEETS ARENA 122