Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
DRAFT GENERAL FUND BUDGET BOOK (8-5-2022)
City of OtsegoGeneral Fund Budget ‐ 2023Requested BudgetRevenue & Expenditure SummaryRequestedActual Actual Year‐to‐Date Budget Budget2020 2021 2022 2022 2023 $ Change % ChangeRevenuesTaxes 4,497,724$ 4,592,524$ 2,797,396$ 5,000,506$ 5,261,395$ 260,889$ 5.22%Cable Franchise Fees 132,137 129,467 66,182 129,000 131,000 2,000 1.55%Licenses & Permits 2,532,789 2,529,588 1,675,642 1,510,639 1,695,623 184,984 12.25%Intergovernmental 1,396,214 88,037 998,355 87,500 85,300 (2,200) ‐2.51%Charges for Services 255,598 424,487 340,927 238,871 270,321 31,450 13.17%Special Assessments 5,434 5,732 1,235 3,400 3,400 ‐ 0.00%Fines & Forfeitures 19,959 27,461 16,872 24,000 24,000 ‐ 0.00%Investment Interest 170,477 (46,484) (1,927,378) 60,000 61,000 1,000 1.67%Miscellaneous 23,984 18,651 10,939 ‐ 7,500 7,500 #DIV/0!Interfund Transfers 201,796 243,100 293,500 293,500 332,400 38,900 13.25%Subtotal9,236,110 8,012,563 4,273,669 7,347,416 7,871,939 524,523 7.14%ExpendituresGeneral Government 1,419,636 1,358,501 951,306 1,763,193 1,813,494 50,301 2.85%Public Safety 2,667,435 2,879,409 1,881,778 3,015,037 3,230,910 215,873 7.16%Public Works 1,204,666 1,287,787 961,667 1,551,450 1,747,465 196,015 12.63%Culture & Recreation697,455 778,621 487,069 855,826 965,210 109,384 12.78%Economic Development665,798 91,248 49,818 161,910 114,860 (47,050) ‐29.06%Interfund Transfers932,244 2,434,846 ‐ ‐ ‐ ‐ #DIV/0!Subtotal7,587,233 8,830,410 4,331,638 7,347,416 7,871,939 524,523 7.14%Net Change in Fund Balance1,648,877$ (817,848)$ (57,969)$ ‐$ (0)$ Description1 City of OtsegoGeneral Fund Budget ‐ 2023Requested BudgetRevenues5.23% Tax Levy IncreasePreliminaryActual Actual Year‐to‐Date Budget BudgetFund Source Account Description 2020 2021 2022 2022 2023 Comments101 31010 CURRENT AD VALOREM TAXES 4,461,923$ 4,594,438$ 2,741,777$ 5,009,000$ 5,271,000$ 101 31011 UNCOLLECTED PROPERTY TAXES ‐ ‐ ‐ (50,494) (51,605) Recent collection rates have been 99%101 31020 DELINQUENT AD VALOREM TAXES 34,083 1,579 55,114 40,000 40,000 ~ 50% of 12/31/2021 Delinquent Taxes ($83,616)101 31900 PENALTIES AND INTEREST 1,717 (3,493) 505 2,000 2,000 TOTAL ‐ TAXES 4,497,724 4,592,524 2,797,396 5,000,506 5,261,395 101 38050 CABLE TV FRANCHISE FEES 132,137 129,467 66,182 129,000 131,000 Annualized ‐ Based on Most Recent 4 QuartersTOTAL ‐ CABLE FRANCHISE FEES 132,137 129,467 66,182 129,000 131,000 101 32100 BUSINESS LICENSES/PERMITS 7,432 13,498 6,824 1,000 6,000 Estimate Based on Prior Year Actuals101 32140 RENTAL INSPECTION FEES 33,202 46,923 26,465 40,200 41,300 Based on 2020 ‐ 2021 Actuals & 2022 YTD Monthly Average101 32150 PUBLIC UTILITIES ROW PERMITS 79,505 93,540 46,118 60,000 60,000 Based on 300 Permits at $200 Each101 32180 OTHER LICENSES/PERMITS 1,730 2,030 2,370 2,000 2,000 Includes: Fowl Keeping, Gambling, Etc.101 32190 FENCING PERMITS 9,200 10,302 6,150 7,700 9,900 Based on 2020 ‐ 2021 Actuals & 2022 YTD Monthly Average101 32210 LIQUOR LICENSES23,591 37,050 34,200 34,200 34,200 Based on 2022 Licensed Operations (Provided by City Clerk)101 32250 SIGN PERMIT750 700 200 400 700 Estimate Based on Prior Year Actuals101 32260 BUILDING PERMITS2,063,952 1,991,481 1,358,108 1,169,112 1,332,248 296 Permits at $4,163 (Avg Permit + Plan Review) + $100,000 Commercial101 32261 PLUMBING PERMITS136,112 146,403 87,350 81,838 93,257 Based on 3 Year Average as Compared to Building Permits (7%)101 32262 MECHANICAL PERMITS150,365 155,561 87,377 93,529 93,257 Based on 3 Year Average as Compared to Building Permits (7%)101 32270 SEPTIC SYSTEM PERMITS5,450 7,900 2,750 5,000 5,000 Estimate Based on Prior Year Actuals101 32999 ASSESSORS FEE21,500 24,200 17,730 15,660 17,760 296 Permits at $60TOTAL ‐ LICENSES & PERMITS2,532,789 2,529,588 1,675,642 1,510,639 1,695,623 101 33100 FEDERAL GRANTS AND AIDS1,302,963 ‐ 989,715 ‐ ‐ 101 33402 HOMESTEAD CREDIT9,557 9,357 ‐ 9,500 9,300 Agricultural MV Credits ‐ Based on Prior Year Actuals101 33405 POLICE AID78,124 76,180 ‐ 78,000 76,000 Estimate Based on Prior Year Actuals101 33422 OTHER STATE AID GRANTS5,570 ‐ 8,640 ‐ ‐ 101 33424 OTHER GRANTS‐ 2,500 ‐ ‐ ‐ TOTAL ‐ INTERGOVERNMENTAL1,396,214 88,037 998,355 87,500 85,300 101 34050 ADMINISTRATIVE FEES60,495 124,656 121,869 35,000 45,000 Development Contract Administration ‐ Only Receive if Developments Occur101 34103 ZONING AND SUBDIVISION FEES16,600 25,300 10,460 19,800 20,300 Based on 2020 ‐ 2021 Actuals & 2022 YTD Monthly Average101 34107 ASSESSMENT SEARCH FEES38,580 25,155 11,205 28,500 27,550 Based on 2020 ‐ 2021 Actuals & 2022 YTD Monthly Average (95%)10134201MINING FEES12,617 29,277 ‐ ‐ ‐ 101 34207 REIMBURSABLE EXPENSE MOWING‐ ‐ 600 ‐ ‐ 101 34302 STREET & TRAFFIC CONTROL SIGNS33,750 55,000 50,000 31,250 31,250 Accounts for 125 Signs Installed by City Staff in New Developments101 34305 CLEAN UP DAY EVENT‐ 8,000 4,851 7,000 6,000 Estimate Based on Prior Year Actuals101 34320 STREET LIGHT OP10,500 15,500 19,750 12,000 13,000 New Development Street Lights ‐ Only Receive if Developments Occur101 34330 GRADING REVIEWS61,804 63,311 38,882 30,000 44,400 296 Permits at $150 (Offsets Grading Review Costs in Building Department)101 34700 RECREATION FEES16,650 45,489 57,292 45,000 52,000 Provided by Nick (7‐19‐2022)101 34701 PARK MEMORIALS130 225 3,200 500 1,000 Provided by Nick (7‐19‐2022)101 34710 SHELTER RENTAL FEES1,865 3,890 4,449 3,500 3,500 Provided by Nick (7‐19‐2022)101 34740 SPORT FIELD USE‐ 5,915 ‐ 2,500 2,500 Provided by Nick (7‐19‐2022)101 34750 PRAIRIE CENTER2,567 3,175 2,460 2,500 2,500 Provided by Nick (7‐19‐2022)101 34760 OTSEGO FESTIVAL VENDORS40 19,595 15,910 21,321 21,321 Budgeted Expenditures (101‐45250‐490), less City Contribution ($5,000).TOTAL ‐ CHARGES FOR SERVICES255,598 424,487 340,927 238,871 270,321 Account Number2 Actual Actual Year‐to‐Date Budget BudgetFund Source Account Description 2020 2021 2022 2022 2023 CommentsAccount Number101 36100 SPECIAL ASSESSMENTS5,434 5,732 1,235 3,400 3,400 Estimated at 50% Collection of 2021 Certified Code EnforcementTOTAL ‐ SPECIAL ASSESSMENTS5,434 5,732 1,235 3,400 3,400 101 35101 FINES & FORFEITS19,959 27,461 16,872 24,000 24,000 Court Fines (12 Months @ $2,000) ‐ Offsets Remittance to Wright CountyTOTAL ‐ FINES & FORFEITURES19,959 27,461 16,872 24,000 24,000 101 36210 INTEREST EARNINGS93,995 68,586 357,635 60,000 61,000 2022 WFS Projected Interest Into PY Allocation Formula & Rounded101 36213 NET CHANGE IN INVESTMENT FMV76,483 (115,070) (2,285,013) ‐ ‐ Accounting Only ‐ No Cash TransactionsTOTAL ‐ INVESTMENT INTEREST170,477 (46,484) (1,927,378) 60,000 61,000 101 36200 MISCELLANEOUS REVENUES4,907 3,212 2,528 ‐ 2,500 101 38010 HPC BOOK SALES160 21 ‐ ‐ ‐ 101 38020 DONATIONS/CONTRIBUTIONS1,000 500 ‐ ‐ ‐ 101 38991 REFUNDS & REIMBURSEMENTS17,917 14,917 8,411 ‐ 5,000 TOTAL ‐ MISCELLANEOUS23,984 18,651 10,939 ‐ 7,500 101 39200 INTERFUND OPERATING TRANSFERS201,796 243,100 293,500 293,500 332,400 Water & Sanitary Sewer Administrative Services ChargeTOTAL ‐ INTERFUND TRANSFERS201,796 243,100 293,500 293,500 332,400 Grand Total9,236,110$ 8,012,563$ 4,273,669$ 7,347,416$ 7,871,939$ Change ($)524,523 Change (%)7.14%3 City of OtsegoGeneral Fund Budget ‐ 2023Expenditures by Function SummaryRequested AmountsRequestedActual Actual Year‐to‐Date Budget Budget2020 2021 2022 2022 2023 $ Change % ChangeGeneral Government41100 City Council 86,113$ 101,316$ 58,442$ 152,406$ 166,396$ 13,990$ 41320 City Administrator 171,207 177,952 113,232 202,442 219,683 17,241 41400 Administration274,719 303,530 177,288 325,418 354,411 28,993 41410 Elections34,185 1,955 9,217 69,776 2,700 (67,076) 41550 Assessing125,118 139,898 151,608 150,002 166,875 16,873 41600 Finance248,740 268,090 190,365 320,626 347,024 26,398 41650 Information Technology 150,916 85,845 60,383 130,570 137,960 7,390 41700 Legal 83,558 35,960 14,617 85,100 64,800 (20,300) 41800 Human Resources89,169 75,656 69,894 130,502 150,314 19,812 41940 Prairie Center39,525 44,492 20,593 54,116 55,596 1,480 41945 City Hall & Public Works Building 113,397 120,616 83,278 138,835 144,435 5,600 41950 Old Township Site 2,990 3,192 2,388 3,400 3,300 (100) Subtotal1,419,636 1,358,501 951,306 1,763,193 1,813,494 50,301 2.85%Public Safety42100 Police Services1,391,755 1,457,521 871,097 1,499,184 1,543,860 44,676 42150 Public Safety Commission 390 843 ‐ 2,960 2,960 ‐ 42200 Fire Protection723,016 769,133 706,693 941,573 1,042,679 101,106 42410 Building Safety 535,092 619,898 288,834 545,110 612,186 67,076 42500 Emergency Management 2,391 9,092 4,315 9,510 9,825 315 42710 Animal Control14,790 22,920 10,840 16,700 19,400 2,700 Subtotal2,667,435 2,879,409 1,881,778 3,015,037 3,230,910 215,873 7.16%Public Works43100 Streets778,343 841,718 585,393 1,025,816 1,119,627 93,811 43150 Engineering52,253 63,697 41,042 81,600 75,600 (6,000) 43160 Street Lights153,058 157,353 95,873 167,080 177,280 10,200 43240 Fleet Management 221,012 225,018 239,359 276,954 374,958 98,004 Subtotal1,204,666 1,287,787 961,667 1,551,450 1,747,465 196,015 12.63%Culture & Recreation45200 Park Maintenance502,867 530,130 329,566 581,987 669,137 87,150 45250 Recreation 194,288 247,289 157,421 268,539 290,273 21,734 45300 Heritage Preservation Commission 300 631 ‐ 2,840 2,840 ‐ 45350 Parks & Recreation Commission‐ 570 82 2,460 2,960 500 Subtotal697,455 778,621 487,069 855,826 965,210 109,384 12.78%Economic Development46530 Planning Commission1,550 1,909 23 3,500 4,000 500 46570 Planning 102,460 78,318 46,247 142,950 95,550 (47,400) 46580 Economic Development561,788 11,021 3,548 15,460 15,310 (150) Subtotal665,798 91,248 49,818 161,910 114,860 (47,050) ‐29.06%Interfund Transfers49300 Interfund Transfers932,244 2,434,846 ‐ ‐ ‐ ‐ Subtotal932,244 2,434,846 ‐ ‐ ‐ ‐ #DIV/0!Grand Total7,587,233$ 8,830,410$ 4,331,638$ 7,347,416$ 7,871,939$ 524,523$ 7.14%Function & Department4 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 41100 104 PART‐TIME EMPLOYEES REGULAR 29,070$ 31,015$ 16,498$ 34,000$ 34,000$ 101 41100 122 FICA AND MEDICARE 2,220 2,364 1,266 2,601 2,601 101 41100 150 WORKERS COMPENSATION 78 85 109 81 71 Based on Actual 2022‐2023 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES31,368 33,463 17,873 36,682 36,672 101 41100 210 OPERATING SUPPLIES305 ‐ ‐ ‐ ‐ 101 41100 225 UNIFORMS/CLOTHING ALLOWANCE66 ‐ 50 375 375 City Council Logo Wear (5 @ $75 Annually)TOTAL ‐ SUPPLIES371 ‐ 50 375 375 101 41100 320 TELEPHONE1,027 850 675 2,400 2,400 Tablet Data Plan (5 @ $40 Monthly)101 41100 321 MILEAGE/TRAVEL71 142 ‐ 200 200 101 41100 355 DUES & MEMBERSHIPS24,623 25,907 21,985 27,700 29,200 See Detailed Attachment101 41100 360 EDUCATION/TRAINING/CONFERENCES1,795 7,397 275 2,200 2,200 See Detailed Attachment101 41100 361 LIABILITY AND PROPERTY INSURAN12,142 13,567 10,733 15,349 15,349 Based on Actual 2021‐2022 Premiums + 5% Inflation101 41100 390 CONTRACTED SERVICES4,667 19,515 5,030 7,500 20,000 See Detailed Attachment101 41100 801 CONTINGENCY10,048 473 1,821 60,000 60,000 Represents 0.82% of the Adopted 2022 General Fund BudgetTOTAL ‐ SERVICES & OTHER CHARGES54,374 67,852 40,520 115,349 129,349 DEPARTMENT TOTAL86,113$ 101,316$ 58,442$ 152,406$ 166,396$ Change ($)13,990 Change (%)9.18%41100 ‐ City CouncilAccount Number5 City of OtsegoGeneral Fund Budget ‐ 2023Detail of Line Item RequestsCity CouncilRequestedBudget Budget2022 2023 Item Detail / Description Comment200$ 200$ Wright County Mayor's Association Dues18,000 19,000 League of Minnesota Cities Annual Membership Dues9,500 10,000 I‐94 Chamber of Commerce Corridor Coalition27,700 29,200 2,000$ 2,000$ League of Minnesota Cities (LMC) Events ‐ Annual Conference, Newly Elected, Etc.200 200 I‐94 Chamber / Corridor Coalition / Wright County EDP ‐ Events‐ ‐ 2,200 2,200 ‐$ 20,000$ Community Survey7,500 ‐ Strategic Planning ‐ Facilitated by Outside Entity‐ ‐ 7,500 20,000 101‐41100‐390Community Survey and Strategic Planning rotate every other year.CONTRACTED SERVICESAccount No. & Description101‐41100‐355DUES & MEMBERSHIPS101‐41100‐360EDUCATION / TRAINING / CONFERENCE6 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 41320 101 FULL‐TIME EMPLOYEES REGULAR 137,029$ 143,141$ 83,469$ 151,384$ 159,166$ 101 41320 104 PART‐TIME ‐ EMPLOYEES REGULAR ‐ ‐ 5,593 8,160 9,600 101 41320 119 PAYROLL ALLOCATION (1,706) (2,053) ‐ ‐ ‐ 101 41320 121 PERA 10,277 10,736 6,275 11,354 11,937 101 41320 122 FICA AND MEDICARE 9,826 10,302 6,499 12,205 12,911 101 41320 130 OTHER EMPLOYER PAID INS 13,385 12,915 8,666 13,781 15,352 101 41320 150 WORKERS COMPENSATION 869 986 1,400 989 948 Based on Actual 2022‐2023 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES169,680 176,027 111,901 197,873 209,914 101 41320 225 UNIFORMS/CLOTHING ALLOWANCE63 82 ‐ 50 200 City Logo Wear (1 @ $200 Annually)TOTAL ‐ SUPPLIES63 82 ‐ 50 200 101 41320 320 TELEPHONE352 383 175 540 1,340 Cell Phones ($45 x 1) + Replacement Phone (Last 2019)101 41320 321 MILEAGE/TRAVEL191 165 262 600 4,800 Automobile Allowance ($400 Per Month)101 41320 355 DUES & MEMBERSHIPS162 170 210 175 225 Minnesota City/County Management Association (MCMA)101 41320 360 EDUCATION/TRAINING/CONFERENCES92 410 121 2,400 2,400 See Detailed Attachment10141320 361 LIABILITY AND PROPERTY INSURAN666 715 562 804 804 Based on Actual 2021‐2022 Premiums + 5% InflationTOTAL ‐ SERVICES & OTHER CHARGES1,463 1,843 1,331 4,519 9,569 DEPARTMENT TOTAL171,207$ 177,952$ 113,232$ 202,442$ 219,683$ Change ($)17,241 Change (%)8.52%41320 ‐ City AdministratorAccount Number7 City of OtsegoGeneral Fund Budget ‐ 2023Detail of Line Item RequestsCity AdministratorRequestedBudget Budget2022 2023 Item Detail / Description Comment600$ 600$ MCMA Annual Conference Registration & Lodging‐ ‐ ICMA Annual Conference Registration, Lodging, Travel & Per Diems118 116 Safe Assure ‐ Employee Safety Training Program180 180 Wright County City Administrator Monthly Networking Group1,500 1,500 Leadership & Supervisory Training2 4 Rounding‐ ‐ 2,400 2,400 101‐41320‐360Employment Agreement outlines that the City Administrator can attend the ICMA conference once every three years (have not attended so far) and the MCMA conference annually.EDUCATION / TRAINING / CONFERENCEAccount No. & Description8 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 41400 101 FULL‐TIME EMPLOYEES REGULAR 169,648$ 183,638$ 100,676$ 191,672$ 202,008$ 101 41400 102 FULL‐TIME ‐ OVERTIME 5,221 180 452 1,000 1,000 101 41400 121 PERA 13,086 13,786 7,585 14,450 15,226 101 41400 122 FICA AND MEDICARE 12,801 13,484 7,656 14,739 15,530 101 41400 130 OTHER EMPLOYER PAID INS 12,418 18,152 13,273 21,035 36,314 101 41400 150 WORKERS COMPENSATION 1,184 1,286 1,723 1,252 1,148 Based on Actual 2022‐2023 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES214,357 230,527 131,365 244,148 271,226 101 41400 201 OFFICE SUPPLIES AND EXPENSES8,062 5,512 2,173 9,000 9,000 101 41400 210 OPERATING SUPPLIES149 ‐ ‐ ‐ ‐ 101 41400 225 UNIFORMS/CLOTHING ALLOWANCE‐ 261 78 150 150 City Logo Wear (3 @ $50 Annually)TOTAL ‐ SUPPLIES8,211 5,773 2,251 9,150 9,150 101 41400 309 SOFTWARE & SUPPORT14,144 24,488 20,014 23,500 24,250 See Detailed Attachment101 41400 320 TELEPHONE425 330 175 540 1,340 Cell Phones ($45 x 1) + Replacement Phone (Last 2021)101 41400 321 MILEAGE/TRAVEL51 134 221 800 800 101 41400 340 RECORDING FEES3,703 3,835 1,527 3,500 3,500 Easements, Notice of Completion, Agreements, Findings and Decision101 41400 347 NEWSLETTER23,693 23,998 12,058 25,400 25,900 Quarterly Editions at $6,100 + $1,500 for Inflation/New Mailings101 41400 350 PRINT & PUBLISHING6,523 8,612 3,554 7,500 8,000 Ordinances, Legal Notices101 41400 355 DUES & MEMBERSHIPS255 417 483 465 480 See Detailed Attachment101 41400 360 EDUCATION/TRAINING/CONFERENCES128 1,929 2,921 5,850 5,200 See Detailed Attachment101 41400 361 LIABILITY AND PROPERTY INSURAN1,454 1,432 1,094 1,565 1,565 Based on Actual 2021‐2022 Premiums + 5% Inflation101 41400 390 CONTRACTED SERVICES1,775 2,055 1,625 3,000 3,000 Photographer ‐ Website and Newsletter / Background Checks (Liquor)TOTAL ‐ SERVICES & OTHER CHARGES52,150 67,230 43,672 72,120 74,035 DEPARTMENT TOTAL274,719$ 303,530$ 177,288$ 325,418$ 354,411$ Change ($)28,993 Change (%)8.91%41400 ‐ AdministrationAccount Number9 City of OtsegoGeneral Fund Budget ‐ 2023Detail of Line Item RequestsAdministrationRequestedBudget Budget2022 2023 Item Detail / Description Comment9,800$ 10,575$ Laserfiche Software Licenses (15) & Public Portal Software370 370 OPG3 ‐ Laserfiche Support ($185 Per Hour ‐ 2 Hours)6,500 6,500 City Code ‐ American Legal ($500 Annual Hosting + $6,000 New Ordinances (Est 15))6,800 6,800 MyCity Civic App ‐ Annual Support & Maintenance Fee30 5 Contingency / Rounding23,500 24,250 330$ 330$ International Institute of Municipal Clerks (2 Memberships)135 150 Minnesota Clerk & Finance Officer Association (3 Memberships)‐ ‐ Contingency / Rounding465 480 149$ 140$ Safe Assure ‐ Employee Safety Training Program1,000 1,200 Minnesota Clerk & Finance Officer Association Conference (2 Attendees)445 950 MCFOA MMCI Institute Year Three Registration (1 Attendee)2,000 600 IIMC Conference Registration, Lodging, Travel & Per Diems (1 Attendee)215 290 MCFOA Advanced City Clerk Training Registration (1 Attendee)500 500 LMC / MCFOA / GTS ‐ Training Events & Seminars1,500 1,500 Leadership & Supervisory Training41 20 Contingency / Rounding5,850 5,200 101‐41400‐360EDUCATION / TRAINING / CONFERENCEAccount No. & Description101‐41400‐355DUES & MEMBERSHIPS101‐41400‐3095 Additional Laserfiche LicensesSOFTWARE & SUPPORT10 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 41410 104 PART‐TIME EMPLOYEES REGULAR 22,597$ ‐$ ‐$ 37,856$ ‐$ TOTAL ‐ PERSONAL SERVICES22,597 ‐ ‐ 37,856 ‐ 101 41410 206 POSTAGE ‐ ‐ 400 7,730 ‐ 101 41410 210 OPERATING SUPPLIES 7,237 ‐ 1,138 6,000 500 TOTAL ‐ SUPPLIES7,237 ‐ 1,538 13,730 500 101 41410 321 MILEAGE/TRAVEL 1,329 ‐ ‐ 4,590 ‐ 101 41410 350 PRINT & PUBLISHING 496 ‐ 149 1,000 ‐ 101 41410 410 RENTALS 1,538 1,955 ‐ 2,600 2,200 Annual Maintenance & Support ‐ Lease With Wright County (DS200 & Omni)TOTAL ‐ SERVICES & OTHER CHARGES 3,363 1,955 149 8,190 2,200 101 41410 501 EQUIPMENT989 ‐ 7,530 10,000 ‐ TOTAL ‐ CAPITAL OUTLAY989 ‐ 7,530 10,000 ‐ DEPARTMENT TOTAL34,185$ 1,955$ 9,217$ 69,776$ 2,700$ Change ($)(67,076) Change (%)‐96.13%41410 ‐ ElectionsAccount Number11 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 41550 390 CONTRACTED SERVICES 125,118$ 139,898$ 151,608$ 150,002$ 166,875$ $15.00 Per Parcel (9,425) + 2022 New Construction (425 @ $60 Each)TOTAL ‐ SERVICES & OTHER CHARGES 125,118 139,898 151,608 150,002 166,875 DEPARTMENT TOTAL125,118$ 139,898$ 151,608$ 150,002$ 166,875$ Change ($) 16,873 Change (%) 11.25%41550 ‐ AssessingAccount Number12 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 41600 101 FULL‐TIME EMPLOYEES REGULAR 130,168$ 137,306$ 94,215$ 143,201$ 208,805$ 101 41600 102 FINANCE OVERTIME 3,569 516 104 ‐ ‐ 101 41600 104 WAGES ‐ PT EMPLOYEES ‐ 22,374 9,196 51,646 ‐ 101 41600 119 PAYROLL ALLOCATION (169) (431) ‐ ‐ ‐ 101 41600 121 PERA 10,030 10,337 7,074 14,614 15,660 101 41600 122 FICA AND MEDICARE 9,353 10,488 6,621 14,906 15,974 101 41600 130 OTHER EMPLOYER PAID INS 15,449 15,104 13,849 15,864 34,559 101 41600 150 WORKERS COMPENSATION 827 1,059 1,695 1,196 1,147 Based on Actual 2022‐2023 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES169,227 196,753 132,754 241,427 276,145 101 41600 201 OFFICE SUPPLIES AND EXPENSES648 731 66 1,750 1,500 101 41600 225 UNIFORMS/CLOTHING ALLOWANCE16 124 16 100 150 City Logo Wear (3 @ $50 Annually)TOTAL ‐ SUPPLIES664 855 82 1,850 1,650 101 41600 304 ACCOUNTING & AUDITING29,000 32,725 30,450 33,450 35,900 Based on 2022‐2024 Engagement Letter With BerganKDV + Single Audit101 41600 309 SOFTWARE & SUPPORT27,805 12,361 12,649 13,100 13,100 See Detailed Attachment101 41600 321 MILEAGE/TRAVEL258 456 16 500 500 101 41600 350 PRINT & PUBLISHING3,738 3,243 1,635 3,310 3,630 See Detailed Attachment101 41600 355 DUES & MEMBERSHIPS330 430 480 610 780 See Detailed Attachment101 41600 360 EDUCATION/TRAINING/CONFERENCES738 2,584 1,442 7,200 7,600 See Detailed Attachment101 41600 361 LIABILITY AND PROPERTY INSURAN1,050 1,153 852 1,219 1,219 Based on Actual 2021‐2022 Premiums + 5% Inflation101 41600 390 CONTRACTED SERVICES12,033 13,421 7,199 13,960 2,300 See Detailed Attachment101 41600 437 BANK SERVICE CHARGES3,897 4,109 2,805 4,000 4,200 Based on 2020 ‐ 2021 Actuals & 2022 YTD Monthly Average + 5%TOTAL ‐ SERVICES & OTHER CHARGES78,848 70,482 57,529 77,349 69,229 DEPARTMENT TOTAL248,740$ 268,090$ 190,365$ 320,626$ 347,024$ Change ($)26,398 Change (%)8.23%41600 ‐ FinanceAccount Number13 City of OtsegoGeneral Fund Budget ‐ 2023Detail of Line Item RequestsFinanceRequestedBudget Budget2022 2023 Item Detail / Description Comment11,900$ 11,900$ Caselle Financial Software ‐ Annual Maintenance & Support1,200 1,200 Plan‐It ‐ Capital Improvement Plan Sofware ‐ Annual Maintenance & Support‐ ‐ 13,100 13,100 1,450$ 1,700$ Wright County ‐ Truth In Taxation Notices1,000 1,000 Newspaper Publishing (Budget, Summary Financial Reports)400 400 Printing ‐ Comprehensive Annual Financial Reports460 530 Application Fee ‐ Comprehensive Annual Financial Report Award Program3,310 3,630 190$ 340$ (1) National Government Finance Officer's Association Dues120 140 (2) State Government Finance Officer's Association Dues ‐ Adam & Julie125 125 (1) CPA License Renewal ‐ Adam175 175 (1) Certified Public Finance Officer's Program Dues ‐ Julie610 780 950$ 1,060$ (2) MN GFOA Annual Conference Registration & Lodging2,500 2,500 (1) GFOA Annual Conference Registration, Lodging, Travel & Per Diems550 400 Various Government Finance Seminars (CLA, KDV, AEM, MN GFOA, MNCPA, Etc.)150 600 Continuing Education Software Package143 140 Safe Assure ‐ Employee Safety Training Program800 800 (2) Civic Systems Annual Sumposium Registration & Lodging600 600 Certified Public Finance Officer's Program ‐ Registration & Test Fees1,500 1,500 Leadership & Supervisory Training7 ‐ Contingency / Rounding7,200 7,600 10,200$ ‐$ Paychex Payroll (Approximately $850 Per Month)960 ‐ Wageworks Benefits Administration ($80 Monthly)300 300 Wright County ‐ Audit Verification Report + Annual Auditor Certificate2,500 2,000 Wright County ‐ Special Assessment Administration Fees13,960 2,300 Account No. & Description101‐41600‐350PRINT & PUBLISHING101‐41600‐355DUES & MEMBERSHIPS101‐41600‐309SOFTWARE & SUPPORT101‐41600‐360Employment Agreement outlines that the Finance Director can attend the GFOA conference once every three years (most recently in 2019) and the MNGFOA conference annually.EDUCATION / TRAINING / CONFERENCE101‐41600‐390The Payroll Services and the Benefits Administration Services are now being budgeted to the Human Resources (41800) department.CONTRACTED SERVICES14 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 41650 210 OPERATING SUPPLIES 4,534$ 5,037$ 891$ 5,500$ 5,500$ TOTAL ‐ SUPPLIES4,534 5,037 891 5,500 5,500 101 41650 309 SOFTWARE & SUPPORT 8,948 12,915 11,034 17,270 20,000 See Detailed Attachment101 41650 315 GIS SERVICES 21,880 19,903 15,251 27,740 29,720 See Detailed Attachment101 41650 322 UTILITIES 1,483 1,643 975 1,560 1,740 Charter Communications (TV & Internet Service ~ $145 Monthly)101 41650 390 CONTRACTED SERVICES 55,827 39,731 25,279 69,000 69,000 Softronics / TR ComputerTOTAL ‐ SERVICES & OTHER CHARGES 88,139 74,192 52,538 115,570 120,460 101 41650 501 EQUIPMENT 58,243 6,616 6,954 9,500 12,000 See Detailed AttachmentTOTAL ‐ CAPITAL OUTLAY58,243 6,616 6,954 9,500 12,000 DEPARTMENT TOTAL150,916$ 85,845$ 60,383$ 130,570$ 137,960$ Change ($)7,390 Change (%)5.66%41650 ‐ Information TechnologyAccount Number15 City of OtsegoGeneral Fund Budget ‐ 2023Detail of Line Item RequestsInformation TechnologyRequestedBudget Budget2022 2023 Item Detail / Description Comment420$ 420$ US Internet ‐ Email Spam Filter600 600 TR Computer Sales ‐ Annual Firewall Protection5,500 6,000 TR Computer / Microsoft ‐ Email Server (50 Accounts @ $500 Monthly)3,840 3,840 GOV Office (Avenet) ‐ City Website Hosting1,275 1,375 AVG ‐ Antivirus Software (55 Computers at $25 Each)4,128 2,500 ZOOM ‐ Virtual Meetings Software1,500 2,000 Adobe PDF Software Subscriptions (10 at $200 Annually)‐ 2,400 TR Computer ‐ Microsoft Office 365 Subscriptions ($200 Monthly)7 865 Contingency ‐ Unidentified software.17,270 20,000 13,740$ 14,220$ Base GIS Services & Licenses ‐ Hakanson Anderson12,000 13,500 GIS Projects ‐ Hakanson Anderson & Midwest CAD Solutions2,000 2,000 Wright County ‐ Aerial Photography27,740 29,720 6,000$ 9,000$ Computer Replacements (6)1,500 3,000 Computer Additions (2)2,000 ‐ City Council Tablets‐ ‐ 9,500 12,000 101‐41650‐501City staff and IT provider review the computer replacement schedule on an annual basis. The exepcted useful life of a computer is between 4 and 5 years.EQUIPMENTAccount No. & Description101‐41650‐309SOFTWARE & SUPPORT101‐41650‐315GIS SERVICES16 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 41700 301 LEGAL SERVICES 83,558$ 35,960$ 14,617$ 85,100$ 64,800$ Based on 2020 ‐ 2021 Actuals & 2022 YTD Monthly Average + 20%TOTAL ‐ SERVICES & OTHER CHARGES 83,558 35,960 14,617 85,100 64,800 DEPARTMENT TOTAL83,558$ 35,960$ 14,617$ 85,100$ 64,800$ Change ($) (20,300) Change (%) ‐23.85%41700 ‐ LegalAccount Number17 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 41800 101 FULL‐TIME EMPLOYEES REGULAR 51,960$ 49,184$ 47,882$ 83,649$ 89,151$ 101 41800 119 PAYROLL ALLOCATION ‐ (115) ‐ ‐ ‐ 101 41800 121 PERA 3,793 3,689 3,591 6,274 6,686 101 41800 122 FICA AND MEDICARE 3,628 2,682 3,407 6,399 6,820 101 41800 130 OTHER EMPLOYER PAID INS 11,797 4,806 7,533 11,503 12,873 101 41800 150 WORKERS COMPENSATION 395 493 757 552 504 Based on Actual 2022‐2023 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES71,574 60,738 63,171 108,377 116,034 101 41800 225 UNIFORMS/CLOTHING ALLOWANCE‐ 66 ‐ 50 200 City Logo Wear (1 @ $200 Annually)TOTAL ‐ SUPPLIES‐ 66 ‐ 50 200 101 41800 320 TELEPHONE‐ 66 133 540 1,220 Cell Phones ($35 x 1) + Replacement Phone (Last 2021)101 41800 309 SOFTWARE & SUPPORT‐ ‐ 3,001 4,185 7,625 BambooHR & Canva Software Subscriptions101 41800 321 MILEAGE/TRAVEL79 ‐ ‐ 400 400 101 41800 355 DUES & MEMBERSHIPS‐ 691 1,358 1,040 1,325 See Detailed Attachment101 41800 360 EDUCATION/TRAINING/CONFERENCES44 1,044 1,480 4,800 5,100 See Detailed Attachment101 41800 361 LIABILITY AND PROPERTY INSURAN442 472 427 610 610 Based on Actual 2021‐2022 Premiums + 5% Inflation101 41800 390 CONTRACTED SERVICES17,029 12,579 325 10,500 17,800 See Detailed AttachmentTOTAL ‐ SERVICES & OTHER CHARGES17,595 14,852 6,723 22,075 34,080 DEPARTMENT TOTAL89,169$ 75,656$ 69,894$ 130,502$ 150,314$ Change ($)19,812 Change (%)15.18%41800 ‐ Human ResourcesAccount Number18 City of OtsegoGeneral Fund Budget ‐ 2023Detail of Line Item RequestsHuman ResourcesRequestedBudget Budget2022 2023 Item Detail / Description Comment175$ 175$ (1) Minnesota City/County Management Association (MCMA) + Assistant Membership219 ‐ (1) SHRM Membership (Society of Human Resources Managers)640 700 (1) ICMA Membership‐ 200 MERSC Program Membership for Employee Benefits‐ 250 Drug Screen Membership & Annual Membership ‐ Northland Occupational Health6 ‐ Rounding1,040 1,325 66$ 62$ Safe Assure ‐ Employee Safety Training Program700 950 MCMA Annual Conference Registration & Lodging125 100 MCMA Winter Workshop725 ‐ SHRM Learning System (Pre‐certification)1,500 2,000 Leadership & Supervisory Training1,500 1,700 Employee Recognition Events (50 Staff @ $25) + Years of Service Recognition ($450)180 180 Wright County City Administrator Monthly Networking Group‐ 100 Wright County HR Group Quarterly Networking4 8 Rounding4,800 5,100 4,000$ ‐$ Insights Discovery Profiles Certification Course1,500 1,500 Insights Discovery Profiles (New Hires)5,000 3,000 Sunshine Committee Breakout Groups (Quarterly Training Sessions)‐ 7,500 Compensation & Classification Study (Last in 2020)‐ 600 Alerus Cobra Benefits Administration‐ 4,200 Bamboo Payroll Services‐ 960 Wageworks F.S.A. Benefits Administration ($80 Monthly)‐ 40 Rounding10,500 17,800 101‐41800‐390The Payroll Services and the Benefits Administration Services were previously coded to the Finance (41600) department.CONTRACTED SERVICESAccount No. & Description101‐41800‐355DUES & MEMBERSHIPS101‐41800‐360Added WC HR Group Network, very beneficial and we are looking to expand the group. Allocate Leadership training to ICMA Ledership Course, 2 year program that is a networking learning group focused on newer local government professionals.EDUCATION / TRAINING / CONFERENCETake out SHRM membership, feel unneeded and able to connect with Wright County HR Group instead.19 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 41940 201 OFFICE SUPPLIES AND EXPENSES 537$ 46$ ‐$ ‐$ ‐$ 101 41940 210 OPERATING SUPPLIES 10,537 5,110 1,987 6,600 6,800 See Detailed Attachment101 41940 220 REPAIR/MAINT SUPPLY 23 ‐ ‐ ‐ ‐ TOTAL ‐ SUPPLIES11,097 5,156 1,987 6,600 6,800 101 41940 320 TELEPHONE1,624 1,576 1,012 1,740 1,740 Centurylink (Elections Line + Alarm Monitoring) ‐ $145 Monthly101 41940 322 UTILITIES10,158 10,782 7,893 11,000 11,000 Natural Gas (Centerpoint) & Electric (Wright Hennepin)101 41940 325 GARBAGE SERVICE1,709 1,866 1,054 1,920 2,400 Randy's Environmental Services (12 Months at $200)101 41940 361 LIABILITY AND PROPERTY INSURAN1,579 1,712 1,298 1,856 1,856 Based on Actual 2021‐2022 Premiums + 5% Inflation101 41940 389 CLEANING SERVICES‐ 5,726 1,600 5,000 5,000 Contracted Cleaning Service (12 Months at $400) + 2% Inflation101 41940 390 CONTRACTED SERVICES6,082 2,101 819 3,500 4,300 See Detailed Attachment101 41940 402 REPAIRS/MAINT BUILDINGS3,023 9,071 1,992 11,000 11,000 See Detailed Attachment101 41940 410 RENTALS2,772 2,942 1,554 3,400 3,400 Lease ‐ Color Copier/Printer #3004 (Quarterly Lease + $100 Monthly)TOTAL ‐ SERVICES & OTHER CHARGES26,948 35,777 17,221 39,416 40,696 101 41940 501 EQUIPMENT1,480 3,559 1,385 3,100 3,100 Replacement and Additonal Furniture for Meeting and Office Space101 41940 525 BUILDING IMPROVEMENTS‐ ‐ ‐ 5,000 5,000 Allowance for Minor Building ImprovementsTOTAL ‐ CAPITAL OUTLAY1,480 3,559 1,385 8,100 8,100 DEPARTMENT TOTAL39,525$ 44,492$ 20,593$ 54,116$ 55,596$ Change ($)1,480 Change (%)2.73%41940 ‐ Prairie CenterAccount Number20 City of OtsegoGeneral Fund Budget ‐ 2023Detail of Line Item RequestsPrairie CenterRequestedBudget Budget2022 2023 Item Detail / Description Comment550$ 550$ Office Supplies (Paper, Printer Cartridges, Etc.)1,700 1,700 Coffee for Meetings / Drinking Water / Water Softener Salt1,900 2,000 Cleaning & Restroom Products2,000 2,100 Building Supplies (Batteries, Air Filters, Office Equipment, Etc.)450 450 Contingency ‐ Unidentified items or emergency purchases.6,600 6,800 500$ 500$ Pest Control ($125 Per Quarter)800 800 Wright Hennepin ‐ Burglary & Fire Alarm Monitoring ($69.15 Monthly) ‐ Rounded200 200 Carpet Cleaning450 450 Fire Alarm System Testing & Inspections500 500 Window Cleaning500 500 Well and Septic System Services‐ 800 Generator Inspection & Maintenance550 550 Contingency ‐ Unidentified services at Prairie Center3,500 4,300 1,500$ 1,500$ HVAC3,800 3,800 Electrical, Plumbing & Equipment Failures750 750 Windows, Doors, Locks, Keys, Etc.3,000 3,000 Repair & Maintenance Supplies Conducted by City Staff1,950 1,950 Contingency ‐ Unidentified or emergency repairs.11,000 11,000 101‐41940‐402REPAIRS/MAINT BUILDINGSAccount No. & Description101‐41940‐390CONTRACTED SERVICES101‐41940‐210OPERATING SUPPLIES21 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 41945 201 OFFICE SUPPLIES AND EXPENSES 351$ ‐$ ‐$ ‐$ ‐$ 101 41945 206 POSTAGE 11,222 3,404 2,738 4,500 6,700 Based on 2020 ‐ 2021 Actuals & 2022 YTD Monthly Average101 41945 210 OPERATING SUPPLIES 2,896 3,596 1,616 4,800 4,800 Coffee & Water / Cleaning & Restroom Products / Building Supplies101 41945 220 REPAIR/MAINT SUPPLY 3,062 ‐ ‐ ‐ ‐ TOTAL ‐ SUPPLIES17,531 7,000 4,354 9,300 11,500 101 41945 320 TELEPHONE8,216 8,112 4,803 8,400 8,400 CenturyLink (Alarms / Fax) & Nova (Phones) ‐ $700 Monthly101 41945 322 UTILITIES28,888 28,488 28,403 31,600 33,200 Natural Gas (Centerpoint) & Electric (Wright Hennepin)101 41945 325 GARBAGE SERVICE10,060 12,562 6,624 11,300 12,100 Randy's Environmental Services101 41945 361 LIABILITY AND PROPERTY INS11,830 12,785 9,674 13,835 13,835 Based on Actual 2021‐2022 Premiums + 5% Inflation101 41945 389 CLEANING SERVICES10,384 11,016 5,268 9,450 9,450 See Detailed Attachment101 41945 390 CONTRACTED SERVICES8,204 8,815 6,884 11,700 11,500 See Detailed Attachment101 41945 402 REPAIRS/MAINT BUILDINGS4,516 12,321 7,327 14,000 14,000 See Detailed Attachment101 41945 410 RENTALS13,770 13,874 8,389 14,250 15,450 See Detailed AttachmentTOTAL ‐ SERVICES & OTHER CHARGES95,866 107,973 77,373 114,535 117,935 101 41945 501 EQUIPMENT‐ ‐ 1,551 10,000 10,000 Replacement and Additonal Furniture for Meeting and Office Space101 41945 525 BUILDING IMPROVEMENTS‐ 5,643 ‐ 5,000 5,000 Allowance for Minor Building ImprovementsTOTAL ‐ CAPITAL OUTLAY‐ 5,643 1,551 15,000 15,000 DEPARTMENT TOTAL113,397$ 120,616$ 83,278$ 138,835$ 144,435$ Change ($)5,600 Change (%)4.03%41945 ‐ City Hall & Public Works BuildingAccount Number22 City of OtsegoGeneral Fund Budget ‐ 2023Detail of Line Item RequestsCity Hall & PW BuildingRequestedBudget Budget2022 2023 Item Detail / Description Comment8,000$ 8,000$ Cleaning Service ($612 Monthly + 3% Inflation) ‐ Rounded800 800 Inside & Outside Window Cleaning650 650 Floor Cleaning9,450 9,450 800$ 800$ Wright Hennepin ‐ Burglary & Fire Alarm Monitoring ($69.15 Monthly) ‐ Rounded1,000 1,000 Elevator Service Contract & Annual MN Department of Labor Permit40 40 Boiler Inspections ‐ MN Department of Labor520 560 Pest Control (Approximately $140 Per Quarter)400 400 Septic Tank Pumping1,600 1,600 Fire Alarms & Sprinkler Inspection Services750 750 Generator Inspection & Maintenance600 600 Overhead Crane Inspection1,450 1,450 Fuel Island Inspection & Service Calls650 650 Salt Shed Annual Inspection600 600 Fire Extinguishers Annual Inspections & Maintenance800 500 RPZ Annual Testing & Inspection2,490 2,550 Contingency ‐ Unidentified services at City Hall11,700 11,500 3,000$ 3,000$ HVAC7,500 7,500 Electrical, Plumbing, Equipment Failures500 500 Garage Doors Service & Maintenance3,000 3,000 Repair & Maintenance Supplies Conducted by City Staff14,000 14,000 3,756$ 3,756$ Lease ‐ Wide Format Printer #6700 (Building Department)2,592 2,592 Lease ‐ Color Copier/Printer #4504 (Administration)1,684 1,684 Lease ‐ Color Copier/Printer #3004 (Reception)2,416 2,416 Lease ‐ Postage Machine + R/M + Supplies3,600 4,800 Cost of Print/Copy Overages202 202 Rounding14,250 15,450 101‐41945‐410RENTALSAccount No. & Description101‐41945‐390The contingency could account for services such as: painting, prairie grass maintenance, etc.CONTRACTED SERVICES101‐41945‐389CLEANING SERVICES101‐41945‐402REPAIRS/MAINT BUILDINGS23 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 41950 322 UTILITIES 2,990$ 3,192$ 2,388$ 3,400$ 3,300$ Gas & Electric Utilities for Old Town Site (Hall Building + Shop Building)TOTAL ‐ SERVICES & OTHER CHARGES 2,990 3,192 2,388 3,400 3,300 DEPARTMENT TOTAL2,990$ 3,192$ 2,388$ 3,400$ 3,300$ Change ($) (100) Change (%) ‐2.94%41950 ‐ Old Township SiteAccount Number24 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 42100 310 MISCELLANEOUS 17,059$ 25,261$ 10,573$ 24,000$ 24,000$ Court Fines (12 Months @ $2,000) ‐ Offsets Revenue Amount101 42100 390 CONTRACTED SERVICES 1,374,696 1,432,260 860,524 1,475,184 1,519,860 Calculated at $86.75 at 48 Hours Daily (Increase of $2.55 or 3% over 2022)TOTAL ‐ SERVICES & OTHER CHARGES 1,391,755 1,457,521 871,097 1,499,184 1,543,860 DEPARTMENT TOTAL1,391,755$ 1,457,521$ 871,097$ 1,499,184$ 1,543,860$ Change ($)44,676 Change (%)2.98%42100 ‐ Police ServicesAccount Number25 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 42150 104 PART‐TIME EMPLOYEES REGULAR 390$ 720$ ‐$ 960$ 960$ 7 Members + Alternate ‐ 12 Meetings at $10 Per MeetingTOTAL ‐ PERSONAL SERVICES390 720 ‐ 960 960 101 42150 210 OPERATING SUPPLIES ‐ 123 ‐ 500 500 TOTAL ‐ SUPPLIES‐ 123 ‐ 500 500 101 42150 360 EDUCATION/TRAINING/CONFERENCES ‐ ‐ ‐ 1,500 1,500 Event Registration for 2 CommissionersTOTAL ‐ SERVICES & OTHER CHARGES ‐ ‐ ‐ 1,500 1,500 DEPARTMENT TOTAL390$ 843$ ‐$ 2,960$ 2,960$ Change ($)‐ Change (%)0.00%42150 ‐ Public Safety CommissionAccount Number26 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 42200 208 MEETING SUPPLIES ‐$ ‐$ ‐$ 500$ ‐$ 101 42200 210 OPERATING SUPPLIES 450 ‐ ‐ ‐ ‐ TOTAL ‐ SUPPLIES450 ‐ ‐ 500 ‐ 101 42200 390 CONTRACTED SERVICES722,566 769,133 706,693 941,073 1,042,679 Calculation Details BelowTOTAL ‐ SERVICES & OTHER CHARGES722,566 769,133 706,693 941,073 1,042,679 DEPARTMENT TOTAL723,016$ 769,133$ 706,693$ 941,573$ 1,042,679$ Change ($)101,106 Change (%)10.74%Albertville407,252$ 433,976$ 234,380$ 468,761$ 510,296$ Albertville's Budget ($983,181; +6.8% from 2022); Otsego Portion is 51.9%Elk River248,480 256,231 343,070 343,070 385,140 5 Year Average Call (20%) Multiplied by Elk River's Budget & DepreciationRogers66,834 78,926 129,243 129,243 147,243 2022 Market Value Multiplied by 0.00044Other‐ ‐ ‐ ‐ ‐ Total722,566 769,133 706,693 941,073 1,042,679 Difference(0) (0) (0) 0 0 42200 ‐ Fire ProtectionAccount Number 27 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 42410 101 FULL‐TIME EMPLOYEES REGULAR 107,658$ 113,535$ 65,662$ 118,090$ 123,887$ 101 42410 102 OVERTIME 1,932 ‐ 185 ‐ ‐ 101 42410 121 PERA 8,219 8,515 4,939 8,857 9,292 101 42410 122 FICA AND MEDICARE 7,831 8,200 4,751 9,034 9,477 101 42410 130 OTHER EMPLOYER PAID INS 20,066 20,067 13,749 20,992 23,597 101 42410 150 WORKERS COMPENSATION 659 769 1,047 771 692 Based on Actual 2022‐2023 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES146,365 151,086 90,331 157,744 166,945 101 42410 201 OFFICE SUPPLIES AND EXPENSES1,123 1,517 918 1,500 1,500 101 42410 202 FUEL2,015 3,874 ‐ 2,500 4,000 Allocated at Year‐End Based on Percentage of Gallons Used101 42410 225 UNIFORMS/CLOTHING ALLOWANCE‐ 50 40 100 100 City Logo Wear (2 @ $50 Annually)TOTAL ‐ SUPPLIES3,139 5,441 958 4,100 5,600 101 42410 302 ENGINEERING FEES22,142 24,538 12,408 20,600 23,600 Based on 2020 ‐ 2021 Actuals & 2022 YTD Monthly Average101 42410 303 PLANNING FEES‐ 6,420 6,010 7,000 8,300 Based on 2021 Actuals & 2022 YTD Monthly Average101 42410 309 SOFTWARE & SUPPORT42,706 3,585 3,778 6,000 6,000 Permit Works Package (Permitting, Licensing & Code Enforcement)101 42410 311 GRADING REVIEWS35,275 57,051 16,075 35,750 40,125 296 New Permits at $125 Each + 25 Second Inspections101 42410 321 MILEAGE/TRAVEL198 ‐ 117 400 400 101 42410 338 REIMBURSABLE COSTS3,747 ‐ ‐ 10,000 10,000 Contracted Abatements101 42410 350 PRINT & PUBLISHING862 368 400 750 750 Code Books / Septic System Owners Guide101 42410 355 DUES & MEMBERSHIPS145 240 120 350 350 See Detailed Attachment101 42410 360 EDUCATION/TRAINING/CONFERENCES228 773 252 1,600 1,600 See Detailed Attachment101 42410 361 LIABILITY & PROPERTY INSURANCE1,513 1,710 1,410 2,016 2,016 Based on Actual 2021‐2022 Premiums + 5% Inflation101 42410 390 CONTRACTED SERVICES278,773 368,687 156,976 298,800 346,500 Average of 385 Hours (Last 24 Months) ‐ $75.00 HourlyTOTAL ‐ SERVICES & OTHER CHARGES385,589 463,372 197,545 383,266 439,641 DEPARTMENT TOTAL535,092$ 619,898$ 288,834$ 545,110$ 612,186$ Change ($)67,076 Change (%)12.31%42410 ‐ Building SafetyAccount Number28 City of OtsegoGeneral Fund Budget ‐ 2023Detail of Line Item RequestsBuilding SafetyRequestedBudget Budget2022 2023 Item Detail / Description Comment150$ 150$ International Code Council Membership100 100 International Code Council Licensure (Barb)100 100 Minnesota Building Permit Technician Association Membership‐ ‐ 350 350 92$ 85$ Safe Assure ‐ Employee Safety Training Program300 300 (2) Minnesota Building Permit Technician Association Fall Conference200 200 Minnesota Building Officials Conference (Spring & Fall)1,000 1,000 International Code Council Conference (Barb Attended in 2017 ‐ Next in 2022)8 15 Contingency / Rounding‐ ‐ 1,600 1,600 Account No. & Description101‐42410‐355DUES & MEMBERSHIPS101‐42410‐360EDUCATION / TRAINING / CONFERENCE29 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 42500 210 OPERATING SUPPLIES 1,785$ 986$ 1,308$ 2,000$ 2,000$ Siren Batteries / 800mhz Radio Batteries & SuppliesTOTAL ‐ SUPPLIES1,785 986 1,308 2,000 2,000 101 42500 322 UTILITIES 607 663 487 700 700 Electricity for Emergency Sirens101 42500 360 EDUCATION/TRAINING/CONFERENCES ‐ ‐ ‐ 1,500 1,500 NIMS / Other Emergency Related Training101 42500 390 CONTRACTED SERVICES ‐ 2,514 2,520 2,310 2,625 Wright County IT: 800 MHz radio service (25) @ $105TOTAL ‐ SERVICES & OTHER CHARGES 607 3,177 3,007 4,510 4,825 101 42500 500 CAPITAL OUTLAY (GENERAL) ‐ 4,930 ‐ 3,000 3,000 Additional 800mhz Radio + ProgrammingTOTAL ‐ CAPITAL OUTLAY‐ 4,930 ‐ 3,000 3,000 DEPARTMENT TOTAL2,391$ 9,092$ 4,315$ 9,510$ 9,825$ Change ($)315 Change (%)3.31%42500 ‐ Emergency ManagementAccount Number30 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 42710 390 CONTRACTED SERVICES 14,790$ 22,920$ 10,840$ 16,700$ 19,400$ Based on 2020 ‐ 2021 Actuals & 2022 YTD Monthly AverageTOTAL ‐ SERVICES & OTHER CHARGES 14,790 22,920 10,840 16,700 19,400 DEPARTMENT TOTAL14,790$ 22,920$ 10,840$ 16,700$ 19,400$ Change ($) 2,700 Change (%) 16.17%42710 ‐ Animal ControlAccount Number31 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 43100 101 FULL‐TIME EMPLOYEES REGULAR 420,735$ 440,525$ 261,263$ 496,833$ 545,262$ 101 43100 102 FULL‐TIME ‐ OVERTIME 7,747 8,738 6,139 9,000 9,000 101 43100 104 PART‐TIME ‐ EMPLOYEES REGULAR 6,163 19,016 7,776 31,440 31,680 Includes 4 Seasonal Staff (12 Week Positions @ 40 Hours)101 43100 119 PAYROLL ALLOCATION (12,945) (13,626) ‐ ‐ (12,000) Storm Water Payroll Allocation101 43100 121 PERA 32,136 33,570 20,055 37,937 41,570 101 43100 122 FICA AND MEDICARE 31,353 34,458 20,177 41,101 44,825 101 43100 130 OTHER EMPLOYER PAID INS 52,711 51,476 41,145 58,120 92,799 101 43100 140 UNEMPLOYMENT COMP 714 ‐ ‐ ‐ ‐ 101 43100 150 WORKERS COMPENSATION 36,995 43,877 62,993 46,109 41,828 Based on Actual 2022‐2023 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES575,609 618,033 419,549 720,540 794,964 101 43100 201 OFFICE SUPPLIES AND EXPENSES1,159 1,207 436 1,245 1,263 See Detailed Attachment101 43100 210 OPERATING SUPPLIES5,947 9,951 5,260 6,040 6,240 See Detailed Attachment101 43100 220 REPAIR/MAINT SUPPLY7,571 9,962 2,030 9,059 9,713 See Detailed Attachment101 43100 225 UNIFORMS/CLOTHING ALLOWANCE2,363 2,782 1,313 6,100 6,100 See Detailed Attachment101 43100 227 SAFETY SUPPLIES2,988 3,199 2,270 3,975 4,750 See Detailed Attachment101 43100 234 BLACKTOP SUPPLIES21,365 16,858 4,897 35,825 36,950 See Detailed Attachment101 43100 240 SMALL TOOLS/EQUIPMENT9,639 6,123 1,736 8,580 8,870 See Detailed Attachment101 43100 270 SAND AND GRAVEL18,949 24,077 20,418 25,900 28,000 See Detailed Attachment101 43100 272 SALT AND SAND59,107 58,655 46,155 67,425 70,800 See Detailed Attachment101 43100 293 SIGN/SIGNAL MATERIAL PURCHASED17,783 16,904 24,440 21,785 23,060 See Detailed AttachmentTOTAL ‐ SUPPLIES146,873 149,718 108,956 185,934 195,746 101 43100 309 SOFTWARE & SUPPORT‐ 600 ‐ 600 600 Sign Cad Annual Maintenance ‐ Sign Design101 43100 315 GIS SERVICES‐ ‐ ‐ 1,000 1,000 Special Projects ‐ Midwest CAD101 43100 320 TELEPHONE3,418 3,569 1,352 5,860 11,260 Cell Phones ($45 x 8) + Tablet ($45) + Replacement Phones (Last 2021)101 43100 322 UTILITIES265 ‐ ‐ ‐ ‐ 101 43100 325 GARBAGE SERVICE1,718 128 735 2,400 2,600 See Detailed Attachment101 43100 350 PRINT & PUBLISHING‐ ‐ ‐ 275 275 See Detailed Attachment101 43100 355 DUES & MEMBERSHIPS100 ‐ ‐ 150 150 See Detailed Attachment101 43100 360 EDUCATION/TRAINING/CONFERENCES6,193 6,760 5,696 9,500 9,600 See Detailed Attachment101 43100 361 LIABILITY AND PROPERTY INSURAN12,494 12,378 9,463 13,532 13,532 Based on Actual 2021‐2022 Premiums + 5% Inflation101 43100 390 CONTRACTED SERVICES11,727 8,727 1,174 22,200 22,200 See Detailed Attachment101 43100 410 RENTALS‐ 6,597 13,444 15,400 20,800 See Detailed Attachment101 43100 436 DUSTCOATING19,945 20,257 18,900 27,850 30,900 See Detailed Attachment101 43100 445 COMMUNITY EVENTS‐ 6,132 6,125 8,500 6,000 Clean Up Day (Offset by Revenues in 101‐34305)TOTAL ‐ SERVICES & OTHER CHARGES55,861 65,148 56,888 107,267 118,917 101 43100 501 EQUIPMENT‐ 8,820 ‐ 12,075 10,000 Allowance for Small Equipment and AttachmentsTOTAL ‐ CAPITAL OUTLAY‐ 8,820 ‐ 12,075 10,000 DEPARTMENT TOTAL778,343$ 841,718$ 585,393$ 1,025,816$ 1,119,627$ Change ($)93,811 Change (%)9.15%43100 ‐ StreetsAccount Number32 City of OtsegoGeneral Fund Budget ‐ 2023Detail of Line Item RequestsStreetsRequestedBudget Budget2022 2023 Item Detail / Description Comment845$ 863$ Background checks and drug testing (Seasonals)400 400 Office Supplies1,245 1,263 1,260$ 1,320$ Herbicide750 750 Lath/Fiberglass Markers420 420 Acetylene/Torch Supplies2,560 2,700 Pressure Washer Detergent300 300 Road Clean‐up Supplies750 750 Miscellaneous6,040 6,240 708$ 732$ Grass Seed375 375 Erosion Control Blanket and Stakes1,000 1,500 Lumber for Misc. repairs: Sidewalks, Mailboxes1,000 1,000 Hardware for Mailbox repairs106 106 Straw for turf establishment/erosion control250 250 Irrigation Supplies for facilities and plow damage2,000 2,000 Sidewalk Panel Repairs ‐ Concrete & Delivery1,500 1,500 Manhole/catch basin/lid repairs800 900 Propane for patching520 550 Rock / Gravel repairs800 800 Brine Tanks ‐ Valves/Fittings/Etc.9,059 9,713 3,200$ 3,200$ Clothing (8 Fulltime Employees @ $400)1,800 1,800 Boots (8 Fulltime & 4 Part‐Time @ $150)600 600 Summer seasonal uniform allowance500 500 Hats6,100 6,100 1,000$ 1,200$ Cones/Barricades525 630 Safety Vests200 220 Hearing protection + Sound Deadening200 200 Gloves150 150 Eye protection500 ‐ Hard hats/face shields500 1,000 Hands‐Free Radio/Cell‐Phone Mounts900 1,350 Reflective jackets3,975 4,750 Used for the purchase of required safety gear.Misc. office supplies. This also includes pre‐employment drug and backgound checks for seasonal employees.OPERATING SUPPLIESOperating supplies are needed for Street Department functions including spraying, snow removal operations marking, vehicle cleaning and other department functions. Amounts are based on prior history and department usage and service levels.Repairs would be applicable to Street Department functions for streets and ROW maintenance.REPAIR/MAINT SUPPLIESUNIFORMS/CLOTHING ALLOWANCEClothing allowances for eight full time employees, four summer seasonal employees.101‐43100‐227101‐43100‐225SAFETY SUPPLIESAccount No. & Description101‐43100‐201OFFICE SUPPLIES101‐43100‐210101‐43100‐22033 City of OtsegoGeneral Fund Budget ‐ 2023Detail of Line Item RequestsStreetsRequestedBudget Budget2022 2023 Item Detail / Description CommentAccount No. & Description300$ 300$ Cold mix4,425 4,500 Tack oil31,100 32,150 Asphalt Mix‐ ‐ 35,825 36,950 600$ 600$ Blacktopping Tools1,100 1,200 Chainsaw1,480 1,520 Chop saw blades500 550 Chains/Binders500 500 Jackhammer bits900 1,000 Cordless Power Tools2,000 2,000 Brine Tanks/Supplies500 500 Backpack Blower1,000 1,000 Misc. tools8,580 8,870 9,250$ 10,000$ Misc. Repairs and Shouldering16,650 ‐ Prior Year Total‐ 6,500 83rd Street if needed or others as conditions change‐ 6,000 McAllister Ave.‐ 5,500 Jalger Ave.25,900 28,000 67,425$ ‐$ Prior Year Total‐ 65,600 Regular Road Salt ‐ 800 Tons @ $82 per ton.‐ 1,000 Sand ‐ 100 Tons @ $10 per ton‐ 4,200 Anti‐Icing Chemicals ‐ 7 Totes @ $600 per tote.‐ ‐ 67,425 70,800 ‐$ 600$ Sign Cad Annual Maintenance‐ Sign Design1,100 1,100 Sign Trak Annual Maintenance‐ Sign Inventory455 490 Traffic signal bulbs3,150 4,500 150 posts ( round/U‐channel) avg. $30/post1,000 1,000 Hardware: brackets, fineals, bolts, etc.1,880 1,920 Film (4) @ $480/roll4,000 3,150 Sign blanks (150) @ $21/avg.1,700 1,800 Breakaways for center medians3,500 3,500 Solar ‐ Flashing Crosswalk Signs (1 Set)4,000 4,000 Post mounted speed monitor (1 sign)1,000 1,000 Concrete 250 bags @ $421,785 23,060 We are into more of a maintenance trend with signs. We have continued to see costs for materials and new developments being added which needs to have maintenance costs reflected. Estimates are based off of historic trends with the additions of more Flashing signage crosswalk signage and speed monitoring sensors to be mounted on sign posts in developments. Sign mounted speed limit monitor was not purchased in 2022 due to high costs of materials for blanket replacement. Sign posts and blanks quantities are down while the prices have increased significantly.Tools that are used routinely in department operations that need to be replaced or added to inventory. SAND AND GRAVELStaff has continued to try to keep each section of gravel road up to a 4" minimum.Snow removal operations has consistently used this amount of salt. With new streets being added we must continue to budget for this amount of salt. Staff is continuing to use new methods to make salt application more efficient and environmentally mindful.101‐43100‐272SALT AND SAND101‐43100‐234BLACKTOP SUPPLIES101‐43100‐240SMALL TOOLS & EQUIPMENT101‐43100‐270101‐43100‐293SIGN/SIGNAL MATERIALS34 City of OtsegoGeneral Fund Budget ‐ 2023Detail of Line Item RequestsStreetsRequestedBudget Budget2022 2023 Item Detail / Description CommentAccount No. & Description200$ 200$ Fluorescent Lights800 800 Appliance Recycling1,000 1,000 Roadside Debris/Waste Management400 600 Tires2,400 2,600 200$ 200$ Postings for job openings75 75 Business cards‐ ‐ 275 275 100$ 100$ MSSA (Minnesota Street Supervisors Association)50 50 Miscellaneous‐ ‐ 150 150 220$ 220$ ATSSA for 2 employees200 225 St. Cloud Fall Maintenance Expo5,499 5,105 Safe Assure ‐ Employee Safety Training Program100 1,000 Learn Safety Program (LMC)1,600 1,200 LTAP Courses: Pavement Mngt., Stormwater, Salting50 50 MN Loss Control Workshop1,500 1,500 Leadership & Supervisory Training331 300 Unidentified safety courses; contingency; rounding9,500 9,600 700$ 700$ Fire Extinguisher Maintenance‐ Dehmers750 750 Pressure Washer Service‐ Hotsy2,000 2,000 Off‐site light service, Kirsch Electric15,000 15,000 Concrete Repairs, cross gutters, cross walks, curbing1,000 1,000 Albertville Compost Site Cost Sharing750 750 Wright County Signal Light Maintenance Per Contract2,000 2,000 Contingency ‐ Unidentified or emergency services.‐ ‐ 22,200 22,200 8,800$ 8,800$ Loader Rental ‐ Winter Snow Removal (2 Months)6,600 7,000 Compost Screen Rental (2 Weeks)‐ 5,000 Sweeper Rental (2 Weeks)15,400 20,800 17,850$ 20,900$ Dust contol ‐ both public and private10,000 10,000 Secondary dust control application.‐ ‐ 27,850 30,900 DUSTCOATINGUsed for the disposal of commonplace items that are typically retreived on road side clean‐up or to recycle items such as tires, bulbs, appliances.101‐43100‐325101‐43100‐410RENTALS101‐43100‐436101‐43100‐350PRINT & PUBLISHING101‐43100‐355DUES & MEMBERSHIPS101‐43100‐360101‐43100‐390EDUCATION / TRAINING / CONFERENCECONTRACTED SERVICESPrimary expense is for the safety training provided by MMUA. This also includes sending two employees to be educated for the sign updates. Additional specialty training for employees on an individual basis. Rentals to perform street related functions. Estimating same application as in 2021 but at a slightly higher rate of $1.02/gallon.Based on past history. Primarily used for advertising openings. Also used for business cards.Memberships and dues for related associations that staff participates in.Contracted services for specialty services that are necessary for department functions. The majority of these services are required and need to be performed by trained professionals.GARBAGE SERVICE35 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 43150 302 ENGINEERING FEES 52,253$ 63,697$ 41,042$ 81,600$ 75,600$ Based on 2020 ‐ 2021 Actuals & 2022 YTD Monthly Average + 20%TOTAL ‐ SERVICES & OTHER CHARGES 52,253 63,697 41,042 81,600 75,600 DEPARTMENT TOTAL52,253$ 63,697$ 41,042$ 81,600$ 75,600$ Change ($) (6,000) Change (%) ‐7.35%43150 ‐ EngineeringAccount Number36 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 43160 322 UTILITIES 150,350$ 155,229$ 95,748$ 157,080$ 167,280$ Based on 2022 YTD Monthly Average + 2% Inflation101 43160 390 CONTRACTED SERVICES 2,708 2,124 125 10,000 10,000 Additions to Street Light System in Accordance With Street Light PolicyTOTAL ‐ SERVICES & OTHER CHARGES 153,058 157,353 95,873 167,080 177,280 DEPARTMENT TOTAL153,058$ 157,353$ 95,873$ 167,080$ 177,280$ Change ($)10,200 Change (%)6.10%43160 ‐ Street LightsAccount Number37 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 43240 101 FULL‐TIME EMPLOYEES REGULAR 62,427$ 44,361$ 32,133$ 58,299$ 88,141$ 101 43240 102 OVERTIME 1,427 864 1,040 2,000 2,000 101 43240 121 PERA 4,789 2,924 2,488 4,522 6,761 101 43240 122 FICA AND MEDICARE 4,755 3,137 1,747 4,613 6,896 101 43240 130 OTHER EMPLOYER PAID INS 7,110 6,369 8,851 13,538 18,902 101 43240 150 WORKERS COMPENSATION 2,438 2,781 3,446 2,780 2,159 Based on Actual 2022‐2023 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES82,946 60,435 49,705 85,752 124,859 101 43240 202 FUEL39,171 50,753 67,919 64,529 100,551 See Detailed Attachment101 43240 210 OPERATING SUPPLIES37,209 40,508 40,108 46,864 52,200 See Detailed Attachment101 43240 220 REPAIR/MAINT SUPPLY42,976 38,381 36,985 57,829 64,768 See Detailed Attachment101 43240 225 UNIFORMS/CLOTHING ALLOWANCE3,097 3,040 520 3,426 3,826 See Detailed Attachment101 43240 240 SMALL TOOLS/EQUIPMENT6,965 1,860 1,864 8,000 8,000 Mechanics Tools101 43240 293 SIGN/SIGNAL MATERIAL PURCHASED42 ‐ ‐ ‐ ‐ 101 43240 298 W/S FLEET EXPENSES(18,311) (10,281) ‐ (8,000) (11,000) Allocation of Utility Fund Fleet Repairs & MaintenanceTOTAL ‐ SUPPLIES111,149 124,262 147,395 172,648 218,345 101 43240 309 SOFTWARE & SUPPORT284 340 4,627 3,900 3,900 See Detailed Attachment101 43240 320 TELEPHONE420 330 175 540 1,340 Cell Phones ($45 x 1) + Replacement Phone (Last 2021)101 43240 360 EDUCATION/TRAINING/CONFERENCES356 252 323 600 500 See Detailed Attachment101 43240 361 LIABILITY AND PROPERTY INS‐ 257 709 1,014 1,014 Based on Actual 2021‐2022 Premiums + 5% Inflation101 43240 390 CONTRACTED SERVICES25,858 39,142 36,425 12,500 25,000 See Detailed AttachmentTOTAL ‐ SERVICES & OTHER CHARGES26,918 40,321 42,259 18,554 31,754 DEPARTMENT TOTAL221,012$ 225,018$ 239,359$ 276,954$ 374,958$ Change ($)98,004 Change (%)35.39%43240 ‐ Fleet ManagementAccount Number38 City of OtsegoGeneral Fund Budget ‐ 2023Detail of Line Item RequestsFleet ManagementRequestedBudget Budget2022 2023 Item Detail / Description Comment81,000$ 135,000$ Diesel/Gasoline285 400 DEF Fluid150 150 Diesel Treatment/Anti‐gel(16,906) (34,999) Allocated to: Building Department & Public Utilities (~25%)64,529 100,551 520$ 520$ License Tabs: 25 vehicles @ $17.50/ea. ‐ Every Other Year11,655 12,984 Oil: Hydraulic, 10‐30, 15‐40, Grease4,218 4,699 Brooms: Main/Gutter brooms for sweeper1,943 2,165 Filters17,428 19,415 Cutting Edges, 8 V‐plows, Road Grader, etc.11,100 12,365 Tires: Based on historical average of fleet.‐ 52 Contingency / Rounding46,864 52,200 57,829$ 64,768$ Repair Supplies‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 57,829 64,768 101‐43240‐2253,276$ 3,276$ Uniform/Rag Contract with G&K Services/Cintas‐ 400 Clothing (1 Fulltime Employee @ $400)150 150 Boots (1 Fulltime Employee @ $150)‐ ‐ 3,426 3,826 300$ 300$ Tatems Sofware3,600 3,600 GPS Monitoring (20 Vehicles)‐ ‐ 3,900 3,900 400$ 264$ Safe Assure ‐ Employee Safety Training Program100 100 DOT inspection certification100 100 Tatems training‐ 36 Contingency / Rounding600 500 1,500$ ‐$ Two‐way radio service/scanning for fleet radios.1,000 5,000 Diagnostics2,500 5,000 Hydraulic/Cylinder repairs7,500 10,000 Major repairs ‐ 5,000 Specialty repairs, DOT inspections, misc.12,500 25,000 These are specific services that staff can not perform in house but we routinely use and rely on. Major repairs have not been needed in a couple of years but one transmission, engine or hydraulic failure could eat up this entire budget and then some. 101‐43240‐360EDUCATION / TRAINING / CONFERENCE101‐43240‐390CONTRACTED SERVICESFleet portion of the MMUA safety program, specialty training for other employees to operate Tatems fleet software.Account No. & Description101‐43240‐210OPERATING SUPPLIES101‐43240‐309SOFTWARE & SUPPORT101‐43240‐202FUELBased on historical total gallon usage by all departments: 2018 = 20,816 gallons; 2019 = 24,328 gallons; 2020 = 30,372 gallons, 2021 = 27,899 gallons. 2022 Budget was based on 27,000 gallons. For 2023, staff is recommending budgeting for 30,000 gallons at $4.50/gallon.This includes necessary supplies to keep fleet running and are essential to keep both inventoried and funded. Without these supplies, the equipment is not able to function. Estimates are based on prior usage and estimated services. Based on historical trends, 2023 increase was based on 11.4% increase over previous year. Percentage increase is averaged back to 2016 for increase amount.Staff has reviewed historical data, and based on the past history, we have seen the amount of repairs steadily increasing. 2014 = $17,789, 2015= $22,405, 2016 = $25,325, 2017 = $30,720, 2018 = $34,579, 2019 = $38,588, 2020 = $42,976, and 2021 = $38,381. The 2023 budget was increased 12% over the current year budget based on historical changes from 2014 to 2021.101‐43240‐220REPAIR/MAINT SUPPLIESUNIFORMS/CLOTHING ALLOWANCE39 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 45200 101 FULL‐TIME EMPLOYEES REGULAR 199,611$ 213,828$ 113,258$ 223,844$ 265,115$ 101 45200 102 OVERTIME 6,746 6,655 4,183 6,000 6,000 101 45200 104 PART‐TIME ‐ EMPLOYEES REGULAR 8,058 31,380 21,621 36,680 36,960 Includes 4 Seasonal Staff (14 Week Positions @ 40 Hours)101 45200 121 PERA 15,471 16,676 8,573 17,238 20,334 101 45200 122 FICA AND MEDICARE 16,252 19,152 10,382 20,389 23,568 101 45200 130 OTHER EMPLOYER PAID INS 18,472 19,187 11,681 20,795 38,396 101 45200 150 WORKERS COMPENSATION 11,544 13,080 22,277 13,118 16,386 Based on Actual 2022‐2023 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES276,155 319,956 191,974 338,064 406,759 101 45200 201 OFFICE SUPPLIES AND EXPENSES1,218 1,578 556 2,000 2,000 101 45200 210 OPERATING SUPPLIES68,352 28,370 31,925 58,500 61,500 See Detailed Attachment101 45200 220 REPAIR/MAINT SUPPLY10,863 22,476 16,125 25,000 26,000 See Detailed Attachment101 45200 225 UNIFORMS/CLOTHING ALLOWANCE2,072 2,664 3,198 3,560 4,200 See Detailed Attachment101 45200 227 SAFETY SUPPLIES1,490 1,096 384 1,500 1,500 101 45200 240 SMALL TOOLS/EQUIPMENT1,700 962 1,306 3,000 3,000 TOTAL ‐ SUPPLIES85,696 57,147 53,495 93,560 98,200 101 45200 315 GIS SERVICES‐ ‐ ‐ 1,000 1,000 Special Projects ‐ Midwest CAD101 45200 320 TELEPHONE2,386 2,092 876 3,700 7,240 Cell Phones ($45 x 5) + Tablet ($45) + Replacement Phones (Last 2021)101 45200 322 UTILITIES41,102 50,407 26,038 41,000 46,000 Natural Gas / Electricity / Irrigation101 45200 355 DUES & MEMBERSHIPS673 1,819 1,404 1,580 1,755 See Detailed Attachment101 45200 360 EDUCATION/TRAINING/CONFERENCES8,658 6,799 2,134 8,600 9,000 See Detailed Attachment101 45200 361 LIABILITY AND PROPERTY INSURAN50,465 54,495 41,386 59,183 59,183 Based on Actual 2021‐2022 Premiums + 5% Inflation101 45200 390 CONTRACTED SERVICES21,886 30,229 12,186 26,300 29,000 See Detailed Attachment101 45200 410 RENTALS11,801 2,861 73 4,000 4,000 TOTAL ‐ SERVICES & OTHER CHARGES136,971 148,702 84,097 145,363 157,178 101 45200 501 EQUIPMENT4,046 4,325 ‐ 5,000 7,000 Allowance for used Small Equipment and AttachmentsTOTAL ‐ CAPITAL OUTLAY4,046 4,325 ‐ 5,000 7,000 DEPARTMENT TOTAL502,867$ 530,130$ 329,566$ 581,987$ 669,137$ Change ($)87,150 Change (%)14.97%45200 ‐ Park MaintenanceAccount Number40 City of OtsegoGeneral Fund Budget ‐ 2023Detail of Line Item RequestsRequestedBudget Budget2022 2023 Item Detail / Description Comment8,500$ 8,500$ Fertilizer & Herbicide9,000 9,000 Mulch3,000 3,000 Ballfield Paint5,000 5,000 Field Maintenance Supplies (Chalk, Aglime, Bases)10,000 13,000 Playground Woodchips15,000 15,000 Court Repair and Maintenance1,000 1,000 Dust Control Soccer Field7,000 7,000 Miscellaneous Supplies58,500 61,500 6,000$ 6,000$ Irrigation Maintenance 10,000 10,000 Playground Maintenance2,000 2,000 Splash Pad Maintenance‐ 3,000 Tree and Plant Replacements/Additions7,000 5,000 Misc. Repairs (Shelters. Planters, Fencing)25,000 26,000 2,000$ 2,200$ Clothing (5 Fulltime Employees@ $400 (New Hire = $600)210 400 Clothing ‐ 4 Seasonal Employees @ $1001,200 1,350 Boots (5 Fulltime + 4 Seasonal @ $150)150 250 Hats3,560 4,200 500$ 500$ MRPA ‐ Agency Membership700 850 MRPA ‐ (5) Professional Memberships180 180 National Recreation and Park Association Membership200 225 Greater Minnesota Parks & Trails1,580 1,755 1,700$ 2,001$ Safe Assure ‐ Employee Safety Training Program4,000 4,000 Parks Maintenance Trainings & Conferences1,400 1,400 Certification Classes1,500 1,500 Leadership & Supervisory Training‐ 99 Contingency / Rounding8,600 9,000 14,000$ 15,000$ Portable Bathrooms11,000 12,000 Irrigation System Repairs & Maintenance1,300 2,000 Contingency ‐ General Park Planning Services26,300 29,000 101‐45200‐355DUES & MEMBERSHIPSBeginning to upgrade irrigation systems throughout the city to reduce maintainance and increase water conservation thereby lower our utility costs. Also using contractual services for for irrigation repair. EDUCATION / TRAINING / CONFERENCE101‐45200‐390CONTRACTED SERVICES101‐45200‐360Increase of $3,000 for playground woodchips to ensure safe fall zones.Playground maintenance increasing due to aging of equipment.Account No. & Description101‐45200‐210OPERATING SUPPLIES101‐45200‐220REPAIR/MAINT SUPPLIES101‐45200‐225UNIFORMS/CLOTHING ALLOWANCE41 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 45250 101 FULL‐TIME EMPLOYEES REGULAR 104,421$ 111,793$ 70,572$ 114,641$ 116,370$ 101 45250 102 FULL‐TIME ‐ OVERTIME 2,758 940 198 ‐ ‐ 101 45250 104 PART‐TIME EMPLOYEES REGULAR 9,123 21,990 21,275 25,000 30,000 101 45250 121 PERA 8,038 8,297 4,632 8,598 8,728 101 45250 122 FICA AND MEDICARE 8,435 9,910 6,831 10,683 11,197 101 45250 130 OTHER EMPLOYER PAID INS 16,167 16,584 9,658 18,214 22,974 101 45250 150 WORKERS COMPENSATION 4,009 4,632 4,267 4,596 2,097 Based on Actual 2022‐2023 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES152,952 174,145 117,434 181,732 191,366 101 45250 201 OFFICE SUPPLIES AND EXPENSES634 1,297 472 1,500 1,500 101 45250 210 OPERATING SUPPLIES4,645 10,971 9,869 13,000 13,000 Program Implementation Supplies & Equipment101 45250 225 UNIFORMS‐ 832 550 650 750 See Detailed AttachmentTOTAL ‐ SUPPLIES5,279 13,100 10,891 15,150 15,250 101 45250 309 SOFTWARE & SUPPORT1,202 5,121 774 5,100 5,100 See Detailed Attachment101 45250 320 TELEPHONE821 836 175 540 1,340 Cell Phones ($45 x 1) + Replacement Phone (Last 2021)101 45250 350 PRINT & PUBLISHING8,617 5,915 725 5,500 5,500 See Detailed Attachment101 45250 355 DUES & MEMBERSHIPS1,176 1,347 665 950 950 See Detailed Attachment101 45250 360 EDUCATION/TRAINING/CONFERENCES732 797 497 3,500 3,200 See Detailed Attachment101 45250 361 LIABILITY AND PROPERTY INSURAN1,097 1,152 872 1,246 1,246 Based on Actual 2021‐2022 Premiums + 5% Inflation101 45250 390 CONTRACTED SERVICES4,059 4,300 17,239 5,500 17,000 Program Instructors & Facilities101 45250 440 RECREATION PROGRAMMING‐ ‐ 1,282 ‐ ‐ 101 45250 445 COMMUNITY EVENTS11,828 18,051 5,544 23,000 23,000 See Detailed Attachment101 45250 490 PRAIRIE FESTIVAL6,525 22,526 1,325 26,321 26,321 See Detailed AttachmentTOTAL ‐ SERVICES & OTHER CHARGES36,058 60,044 29,096 71,657 83,657 DEPARTMENT TOTAL194,288$ 247,289$ 157,421$ 268,539$ 290,273$ Change ($)21,734 Change (%)8.09%45250 ‐ RecreationAccount Number42 City of OtsegoGeneral Fund Budget ‐ 2023Detail of Line Item RequestsRequestedBudget Budget2021 2022 Item Detail / Description Comment400$ 400$ 1 Fulltime Employee at $400250 350 Recreation & Building Staff Uniforms‐ ‐ 650 750 3,400$ 3,400$ RecDesk ‐ Online Registration Software700 700 Adobe Software1,000 1,000 Miscellanous Software5,100 5,100 500$ 500$ Printing of P&R Brochures5,000 5,000 Website & Flyer Design‐ ‐ 5,500 5,500 150$ 150$ MRPA ‐ (1) Professional Memberships725 725 Music Licensing75 75 Minnesota Farmer's Market Association‐ ‐ 950 950 600$ 256$ Safe Assure ‐ Employee Safety Training Program2,500 2,500 MRPA Conference & Lodging / Meetings400 444 Other/Unidentified Training3,500 3,200 2,000$ 2,000$ Easter Egg Hunt2,000 2,000 Santa Day3,000 3,000 Pumpkin Patch5,000 5,000 Tuesday Entertainment5,000 5,000 Movies / Farmers Market / Touch‐A‐Truck6,000 6,000 Senior Programming23,000 23,000 2,500$ 2,500$ Bands600 600 Stage6,000 6,000 Fireworks7,600 7,600 Petting Zoo & Jump Inflatables320 320 Potties1,800 1,800 T‐Shirts525 525 Website615 615 Insurance420 420 Plaques790 790 Generators2,800 2,800 Tent1,920 1,920 Advertising131 131 Volunteers300 300 Security26,321 26,321 101‐45250‐490PRAIRIE FESTIVAL101‐45250‐445COMMUNITY EVENTSMiscellaneous software is seasonal and will vary from one year to the next, but will include such software as Flyer Design, Survey Design, and Video Editing.101‐45250‐360EDUCATION / TRAINING / CONFERENCE101‐45250‐309SOFTWARE & SUPPORT101‐45250‐355DUES & MEMBERSHIPSAccount No. & Description101‐45250‐225UNIFORMS/CLOTHING ALLOWANCE101‐45250‐350PRINT & PUBLISHING43 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 45300 104 PART‐TIME EMPLOYEES REGULAR 300$ 590$ ‐$ 840$ 840$ 5 Members + 2 Alternates ‐ 12 Meetings at $10 Per MeetingTOTAL ‐ PERSONAL SERVICES300 590 ‐ 840 840 101 45300 201 OFFICE SUPPLIES AND EXPENSES ‐ 41 ‐ 500 500 TOTAL ‐ SUPPLIES‐ 41 ‐ 500 500 101 45300 360 EDUCATION/TRAINING/CONFERENCES ‐ ‐ ‐ 1,500 1,500 Event Registration for 2 CommissionersTOTAL ‐ SERVICES & OTHER CHARGES ‐ ‐ ‐ 1,500 1,500 DEPARTMENT TOTAL300$ 631$ ‐$ 2,840$ 2,840$ Change ($)‐ Change (%)0.00%45300 ‐ Heritage Preservation CommissionAccount Number44 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 45350 104 PART‐TIME EMPLOYEES REGULAR ‐$ 570$ ‐$ 960$ 960$ 7 Members + Alternate ‐ 12 Meetings at $10 Per MeetingTOTAL ‐ PERSONAL SERVICES‐ 570 ‐ 960 960 101 45350 210 OPERATING SUPPLIES ‐ ‐ 82 ‐ 500 TOTAL ‐ SUPPLIES‐ ‐ 82 ‐ 500 101 45350 360 EDUCATION/TRAINING/CONFERENCES ‐ ‐ ‐ 1,500 1,500 Event Registration for 2 CommissionersTOTAL ‐ SERVICES & OTHER CHARGES ‐ ‐ ‐ 1,500 1,500 DEPARTMENT TOTAL‐$ 570$ 82$ 2,460$ 2,960$ Change ($)500 Change (%)20.33%45350 ‐ Parks and Recreation CommissionAccount Number45 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 46530 104 PART‐TIME EMPLOYEES REGULAR 1,550$ 1,900$ 20$ 2,000$ 2,000$ 7 Members + Alternate ‐ 24 Meetings at $20 Per MeetingTOTAL ‐ PERSONAL SERVICES1,550 1,900 20 2,000 2,000 101 46530 210 OPERATING SUPPLIES ‐ 9 3 ‐ 500 TOTAL ‐ SUPPLIES‐ 9 3 ‐ 500 101 46530 360 EDUCATION/TRAINING/CONFERENCES ‐ ‐ ‐ 1,500 1,500 Event Registration for 2 CommissionersTOTAL ‐ SERVICES & OTHER CHARGES ‐ ‐ ‐ 1,500 1,500 DEPARTMENT TOTAL1,550$ 1,909$ 23$ 3,500$ 4,000$ Change ($)500 Change (%)14.29%46530 ‐ Planning CommissionAccount Number46 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 46570 303 PLANNING FEES 102,460$ 78,318$ 46,247$ 142,950$ 95,550$ Based on 2020 ‐ 2021 Actuals & 2022 YTD Monthly Average + 5%TOTAL ‐ SERVICES & OTHER CHARGES 102,460 78,318 46,247 142,950 95,550 DEPARTMENT TOTAL102,460$ 78,318$ 46,247$ 142,950$ 95,550$ Change ($) (47,400) Change (%) ‐33.16%46570 ‐ PlanningAccount Number47 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 46580 208 MEETING SUPPLIES ‐$ ‐$ ‐$ 100$ 100$ TOTAL ‐ SUPPLIES‐ ‐ ‐ 100 100 101 46580 309 SOFTWARE & SUPPORT 1,200 1,200 ‐ 1,200 ‐ Website Link ‐ GreaterMSP Search Tool101 46580 339 DEVELOPMENT INCENTIVES 549,208 ‐ ‐ ‐ ‐ 101 46580 355 DUES & MEMBERSHIPS 3,048 3,448 3,448 3,560 4,610 See Detailed Attachment101 46580 360 EDUCATION/TRAINING/CONFERENCES 340 ‐ 100 600 600 See Detailed Attachment101 46580 380 MARKETING ‐ ‐ ‐ 5,000 5,000 101 46580 390 CONTRACTED SERVICES 200 ‐ ‐ 5,000 5,000 Development Consultants; Contracted Studies101 46580 410 RENTALS 7,792 6,373 ‐ ‐ ‐ TOTAL ‐ SERVICES & OTHER CHARGES 561,788 11,021 3,548 15,360 15,210 DEPARTMENT TOTAL561,788$ 11,021$ 3,548$ 15,460$ 15,310$ Change ($) (150) Change (%) ‐0.97%46580 ‐ Economic DevelopmentAccount Number48 City of OtsegoGeneral Fund Budget ‐ 2023Detail of Line Item RequestsEconomic DevelopmentRequestedBudget Budget2022 2023 Item Detail / Description Comment3,000$ 4,000$ Wright County Economic Development Partnership300 350 I‐94 West Chamber of Commerce260 260 Initiative Foundation3,560 4,610 400$ 400$ Economic Development Seminars (Ehlers Seminar)200 200 I‐94 Chamber / Elk River Chamber / Wright County EDP ‐ Events‐ ‐ 600 600 Account No. & Description101‐46580‐355DUES & MEMBERSHIPS101‐46580‐360EDUCATION / TRAINING / CONFERENCE49 City of OtsegoGeneral Fund Budget ‐ 2023Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2020 2021 2022 2022 2023 Comments101 49300 720 OPERATING TRANSFERS 932,244$ 2,434,846$ ‐$ ‐$ ‐$ TOTAL ‐ INTERFUND TRANSFERS 932,244 2,434,846 ‐ ‐ ‐ DEPARTMENT TOTAL932,244$ 2,434,846$ ‐$ ‐$ ‐$ Change ($) ‐ Change (%) #DIV/0!49300 ‐ Interfund TransfersAccount Number50 ABCDEFGHIGrade1234567890 ‐ 93 1 39,946.36 41,044.88 42,173.62 43,333.39 44,525.06 45,749.49 47,007.61 48,300.32 49,628.58 94 ‐ 112 2 42,343.14 43,507.58 44,704.03 45,933.39 47,196.56 48,494.47 49,828.07 51,198.33 52,606.30 113 ‐ 131 3 44,883.73 46,118.03 47,386.27 48,689.40 50,028.36 51,404.13 52,817.75 54,270.24 55,762.67 132 ‐ 151 4 47,576.76 48,885.11 50,229.45 51,610.76 53,030.06 54,488.38 55,986.81 57,526.45 59,108.44 152 ‐ 173 5 50,431.36 51,818.22 53,243.22 54,707.41 56,211.86 57,757.69 59,346.02 60,978.04 62,654.94 174 ‐ 197 6 53,457.24 54,927.32 56,437.82 57,989.85 59,584.58 61,223.15 62,906.78 64,636.72 66,414.23 198 ‐ 223 7 56,664.68 58,222.95 59,824.09 61,469.24 63,159.65 64,896.54 66,681.19 68,514.93 70,399.09 224 ‐ 251 8 60,064.55 61,716.33 63,413.53 65,157.40 66,949.22 68,790.33 70,682.06 72,625.83 74,623.03 252 ‐ 281 9 63,668.43 65,419.31 67,218.33 69,066.84 70,966.18 72,917.75 74,922.99 76,983.37 79,100.41 282 ‐ 314 10 67,488.53 69,344.46 71,251.44 73,210.85 75,224.15 77,292.82 79,418.37 81,602.37 83,846.44 315‐350 11 71,537.84 73,505.13 75,526.53 77,603.50 79,737.60 81,930.38 84,183.47 86,498.52 88,877.23 351 ‐ 389 12 75,830.11 77,915.44 80,058.12 82,259.72 84,521.86 86,846.21 89,234.48 91,688.42 94,209.86 390 ‐ 431 13 80,379.92 82,590.37 84,861.61 87,195.29 89,593.17 92,056.98 94,588.55 97,189.73 99,862.45 432 ‐ 476 14 85,202.71 87,545.80 89,953.30 92,427.01 94,968.75 97,580.40 100,263.87 103,021.12 105,854.20 477 ‐ 521 15 90,314.88 92,798.53 95,350.50 97,972.63 100,666.88 103,435.22 106,279.69 109,202.38 112,205.45 522 ‐ 566 16 95,733.77 98,366.45 101,071.53 103,851.00 106,706.90 109,641.34 112,656.47 115,754.52 118,937.78 567 ‐ 614 17 101,477.80 104,268.44 107,135.82 110,082.05 113,109.31 116,219.82 119,415.86 122,699.80 126,074.04 615 ‐ 662 18 107,566.46 110,524.55 113,563.97 116,686.98 119,895.87 123,193.01 126,580.81 130,061.78 133,638.49 663 ‐ 710 19 114,020.45 117,156.02 120,377.81 123,688.19 127,089.63 130,584.58 134,175.66 137,865.50 141,656.80 711 ‐ 761 20 120,861.68 124,185.38 127,600.47 131,109.48 134,715.00 138,419.66 142,226.20 146,137.43 150,156.21 762‐812 21 128,113.39 131,636.50 135,256.50 138,976.05 142,797.90 146,724.84 150,759.78 154,905.67 159,165.57 813 ‐ 842 22 135,800.19 139,534.69 143,371.89 147,314.62 151,365.77 155,528.33 159,805.37 164,200.01 168,715.51 843 ‐ 886 23 143,948.19 147,906.77 151,974.20 156,153.50 160,447.72 164,860.04 169,393.68 174,052.01 178,838.44 DRAFT FOR BUDGET ‐ 2023 Pay Plan (3.50% COLA)Position PointsY:\Budget\2023\Wages and Benefits\Pay Plans ‐ 20232023‐FT51 City of OtsegoSeasonal, Temporary & Part‐Time EmployeesPay PlanDescription Minimum MaximumRecreation Department 11.33$ 16.48$ Seasonal Maintenance 13.39 18.54 Election Judges14.00 16.00 Administrative Intern 15.00 20.00 Notes: Actual hourly rates for employees will be a recommendation from the Supervisor, basedon qualifications, previous experience, market conditions, etc., subject to review andapproval from Human Resources and the City Administrator.Adjustments to this pay plan will be considered annually.All pay is subject to State & Federal Minimum wage laws.Pending Approval by City Council ‐ December 12, 2022RangeY:\Budget\2023\Wages and Benefits\Pay Plans ‐ 20232023‐PT52 City of OtsegoPersonal Services Calculations2023 BudgetPay2023 Pay2023Calculated 7.50%7.65%TotalPositionGrade Step Rate Grade Step Rate Hours WagesPERAFICA Benefits CostsCity CouncilMayor and Council34,000 ‐ 2,601 ‐ 36,601 34,000 ‐ 2,601 ‐ 36,601 City AdministratorCity Administrator / Finance Director21 9 76.52 2,080 159,166 11,937 12,176 15,352 198,631 Intern20.00 480 9,600 ‐ 734 ‐ 10,334 168,766 11,937 12,911 15,352 208,966 AdministrationCity Clerk 11 3 36.31 11 4 37.31 2,080 77,604 5,820 5,937 12,566 101,926 Deputy Clerk 6 3 27.13 6 4 27.88 2,080 57,990 4,349 4,436 8,615 75,390 Administrative Assistant6 9 31.93 2,080 66,414 4,981 5,081 15,133 91,609 Overtime1,000 75 77 ‐ 1,152 203,008 15,226 15,530 36,314 270,077 FinanceAccountant10 9 40.31 2,080 83,846 6,288 6,414 15,226 111,775 Finance Clerk7 9 33.85 2,080 70,399 5,280 5,386 4,348 85,413 Utility Billing6 1 25.70 6 2 26.41 2,080 54,560 4,092 4,174 14,985 77,811 208,805 15,660 15,974 34,559 274,998 Human ResourcesHR / Assistant Administrator14 2 42.09 14 3 43.25 2,080 89,151 6,686 6,820 12,873 115,530 89,151 6,686 6,820 12,873 115,530 Building SafetyBuilding Permit Technician 6 9 31.93 2,080 66,414 4,981 5,081 15,133 91,609 Administrative Assistant6 3 27.13 6 4 27.88 2,080 57,473 4,310 4,397 8,464 74,643 123,887 9,292 9,477 23,597 166,252 StreetsStreet Operations Manager15 8 52.50 2,080 109,202 8,190 8,354 15,352 141,099 Street Operations Foreperson9 9 38.03 2,080 79,100 5,933 6,051 14,894 105,979 Maintenance II7 9 33.85 2,080 70,399 5,280 5,386 8,857 89,921 Maintenance II7 7 32.06 7 8 32.94 2,080 66,987 5,024 5,124 7,913 85,048 Maintenance II7 2 27.99 7 3 28.76 2,080 59,290 4,447 4,536 13,006 81,279 Maintenance I5 9 30.12 1,872 56,389 4,229 4,314 2,707 67,639 Maintenance I5 2 24.91 5 3 25.60 2,080 52,768 3,958 4,037 14,950 75,713 Maintenance I5 1 24.25 5 2 24.91 2,080 51,125 3,834 3,911 15,122 73,992 Seasonal (12 Weeks @ 40 Hours)18.00 480 8,640 ‐ 661 ‐ 9,301 Seasonal (12 Weeks @ 40 Hours)17.00 480 8,160 ‐ 624 ‐ 8,784 Seasonal (12 Weeks @ 40 Hours)16.00 480 7,680 ‐ 588 ‐ 8,268 Seasonal (12 Weeks @ 40 Hours)15.00 480 7,200 ‐ 551 ‐ 7,751 Overtime9,000 675 689 ‐ 10,364 585,942 41,570 44,825 92,801 765,137 N/A ‐ At Max.As of 1‐1‐2023 2023 StepN/A ‐ At Max.N/A ‐ At Max.N/A ‐ At Max.N/A ‐ At Max.N/A ‐ At Max.N/A ‐ Already done for 2023.N/A ‐ At Max.N/A ‐ At Max.53 Fleet MaintenanceMechanic 8 8 34.92 8 9 35.88 2,080 73,125 5,484 5,594 15,122 99,325 Mechanic8 1 28.88 520 15,016 1,126 1,149 3,780 21,072 Overtime2,000 150 153 ‐ 2,303 90,141 6,761 6,896 18,902 122,700 Parks MaintenanceParks & Recreation Director 14 1 40.96 14 2 42.09 832 34,315 2,574 2,625 7,232 46,746 Lead Park Maintenance8 9 35.88 2,080 74,623 5,597 5,709 4,401 90,329 Park & Recreation Operations Coordinator7 5 30.37 7 6 31.20 2,080 64,462 4,835 4,931 8,007 82,236 Park Maintenance II7 1 27.24 7 2 27.99 2,080 58,093 4,357 4,444 7,417 74,311 Park Maintenance I5 1 24.25 1,387 33,621 2,522 2,572 11,341 50,056 Seasonal (14 Weeks @ 40 Hours)18.00 560 10,080 ‐ 771 ‐ 10,851 Seasonal (14 Weeks @ 40 Hours)17.00 560 9,520 ‐ 728 ‐ 10,248 Seasonal (14 Weeks @ 40 Hours)16.00 560 8,960 ‐ 685 ‐ 9,645 Seasonal (14 Weeks @ 40 Hours)15.00 560 8,400 ‐ 643 ‐ 9,043 Overtime6,000 450 459 ‐ 6,909 308,075 20,334 23,568 38,398 390,375 RecreationParks & Recreation Director14 1 40.96 14 2 42.09 1,248 51,473 3,860 3,938 9,873 69,144 Recreation Coordinator 7 6 31.20 2,080 64,897 4,867 4,965 13,102 87,830 Part‐Time Recreation30,000 ‐ 2,295 ‐ 32,295 146,370 8,728 11,197 22,975 189,270 N/A for 2023 (new position)N/A ‐ Already done for 2023.N/A ‐ At Max.N/A for 2023 (new position)54 City of OtsegoUtility Fund TransfersReimburse for Administrative Services2023 BudgetUtility Budgeted20232023Allocation Personal AllocationWater SewerDutiesPercentage ServicesAmountTransfer TransferGoverning BoardMayor & City CouncilDecision Making20.00% 36,601 7,320 City Administrator198,631 City AdministratorAdministrative Oversight & Review15.00%29,795 Finance DirectorBudgeting / Financial Reporting / Long‐Term Planning / Rates20.00%39,726 AdministrationCity ClerkCity Communications, Website, Records Retention15.00% 101,926 15,289 Deputy Clerk Council & Subcommittee Packets / Supplies Ordering 5.00% 75,390 3,770 FinanceAccountantAccounts Payable / Insurance20.00% 111,775 22,355 Finance ClerkAccounts Payable / Billing / Customer Support / Work Orders50.00% 85,413 42,706 Utility Billing ‐ PTBilling / Customer Support / Meter Administration / Etc.100.00% 77,811 77,811 Human Resources115,530 HR Human Resources & Training (9 of 34 FT Employees) 26.47% 30,581 Assistant City Administrator City Communications / Administrative Oversight & Review5.00%5,777 ParksSeasonal ParksMowing at Water Towers, Pumphouses & Treatment Plants20.00% 39,787 7,957 DepartmentalCity CouncilLMC Dues & Community Survey20.00% 39,000 7,800 FinanceAudit20.00% 31,900 6,380 Information TechnologyIT Services, Licenses & Supplies (9 of 34 FT Employees)26.47% 108,720 28,779 Human Resources All Employee Items (9 of 34 FT Employees) 26.47% 23,900 6,326 Rounding28 Totals332,400 83,100 249,300 Prior Year73,375 220,125 Change13.25% 13.25%Department & Position55