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-4-2021)
City of OtsegoGeneral Fund Budget ‐ 2022Requested BudgetRevenue & Expenditure SummaryRequestedActual Actual Year‐to‐Date Budget Budget2019 2020 2021 2021 2022 $ Change % ChangeRevenuesTaxes 4,192,198$ 4,497,724$ 2,543,576$ 4,646,632$ 4,973,035$ 326,403$ 7.02%Cable Franchise Fees 137,510 132,137 64,957 135,000 129,000 (6,000) ‐4.44%Licenses & Permits 1,699,879 2,532,789 1,714,195 1,200,810 1,510,639 309,829 25.80%Intergovernmental 88,328 1,396,214 960,832 87,500 87,500 ‐ 0.00%Charges for Services 308,290 255,598 241,832 198,915 238,871 39,956 20.09%Special Assessments 5,703 5,434 3,728 3,500 3,400 (100) ‐2.86%Fines & Forfeitures 26,488 19,959 15,115 24,000 24,000 ‐ 0.00%Investment Interest 147,940 170,477 (52,130) 72,000 78,000 6,000 8.33%Miscellaneous 49,309 23,984 10,782 ‐ ‐ ‐ Interfund Transfers 171,900 201,796 ‐ 243,100 286,800 43,700 17.98%Subtotal6,827,546 9,236,110 5,502,887 6,611,457 7,331,245 719,788 10.89%ExpendituresGeneral Government 1,215,969 1,419,636 848,373 1,540,869 1,765,033 224,164 14.55%Public Safety 2,379,438 2,667,435 1,676,111 2,714,553 2,993,027 278,474 10.26%Public Works 1,250,720 1,204,666 761,722 1,429,909 1,556,316 126,407 8.84%Culture & Recreation707,699 697,455 439,106 796,416 892,909 96,493 12.12%Economic Development114,142 665,798 53,192 129,710 123,960 (5,750) ‐4.43%Interfund Transfers971,726 932,244 ‐ ‐ ‐ ‐ Subtotal6,639,694 7,587,233 3,778,504 6,611,457 7,331,245 719,788 10.89%Net Change in Fund Balance187,852$ 1,648,877$ 1,724,383$ ‐$ (0)$ Description1 City of OtsegoGeneral Fund Budget ‐ 2022Requested BudgetRevenues6.62% Tax Levy IncreaseRequestedActual Actual Year‐to‐Date Budget BudgetFund Source Account Description 2019 2020 2021 2021 2022 Comments101 31010 CURRENT AD VALOREM TAXES 4,173,764$ 4,461,923$ 2,525,678$ 4,671,000$ 4,980,000$ 101 31011 UNCOLLECTED PROPERTY TAXES ‐ ‐ ‐ (46,368) (48,965) Recent collection rates have been 99%101 31020 DELINQUENT AD VALOREM TAXES 16,292 34,083 19,634 20,000 40,000 ~ 50% of 12/31/2020 Delinquent Taxes ($81,431)101 31900 PENALTIES AND INTEREST 2,142 1,717 (1,736) 2,000 2,000 TOTAL ‐ TAXES 4,192,198 4,497,724 2,543,576 4,646,632 4,973,035 101 38050 CABLE TV FRANCHISE FEES 137,510 132,137 64,957 135,000 129,000 Annualized ‐ Based on Most Recent 4 QuartersTOTAL ‐ CABLE FRANCHISE FEES 137,510 132,137 64,957 135,000 129,000 101 32100 BUSINESS LICENSES/PERMITS 585 7,432 1,580 1,000 1,000 Includes: Garbage Haulers ($100 Each), Peddlers ($100 Each)101 32140 RENTAL INSPECTION FEES39,515 33,202 31,157 41,200 40,200 Based on 2019 / 2020 Actuals & 2021 YTD Monthly Average101 32150 PUBLIC UTILITIES ROW PERMITS64,900 79,505 44,940 50,000 60,000 Based on 300 Permits at $200 Each101 32180 OTHER LICENSES/PERMITS6,323 1,730 1,430 2,000 2,000 Includes: Fowl Keeping, Gambling, Etc.101 32190 FENCING PERMITS4,350 9,200 6,550 7,000 7,700 Based on 2019 / 2020 Actuals & 2021 YTD Monthly Average101 32210 LIQUOR LICENSES34,180 23,591 34,200 33,900 34,200 Based on 2021 Licensed Operations (Audra Provided 6‐30‐2021)101 32250 SIGN PERMIT350 750 400 300 400 Estimate Based on Prior Year Actuals101 32260 BUILDING PERMITS1,319,471 2,063,952 1,373,831 913,400 1,169,112 261 Permits at $4,192 (Avg Permit + Plan Review) + $75,000 Commercial101 32261 PLUMBING PERMITS99,935 136,112 97,995 63,938 81,838 Based on 3 Year Average as Compared to Building Permits (7%)101 32262 MECHANICAL PERMITS109,095 150,365 102,762 73,072 93,529 Based on 3 Year Average as Compared to Building Permits (8%)101 32270 SEPTIC SYSTEM PERMITS5,950 5,450 4,000 5,000 5,000 Estimate Based on Prior Year Actuals101 32999 ASSESSORS FEE15,225 21,500 15,350 10,000 15,660 261 Permits at $60TOTAL ‐ LICENSES & PERMITS1,699,879 2,532,789 1,714,195 1,200,810 1,510,639 101 33100 FEDERAL GRANTS AND AIDS‐ 1,302,963 958,332 ‐ ‐ 101 33402 HOMESTEAD CREDIT9,786 9,557 ‐ 9,500 9,500 Agricultural MV Credits ‐ Based on Prior Year Actuals101 33405 POLICE AID75,425 78,124 ‐ 78,000 78,000 Estimate Based on Prior Year Actuals101 33422 OTHER STATE AID GRANTS845 5,570 ‐ ‐ ‐ 101 33423 PERA AID1,872 ‐ ‐ ‐ ‐ 101 33424 OTHER GRANTS400 ‐ 2,500 ‐ ‐ TOTAL ‐ INTERGOVERNMENTAL88,328 1,396,214 960,832 87,500 87,500 101 34050 ADMINISTRATIVE FEES72,313 60,495 57,648 30,000 35,000 Conservative ‐ Only Receive if Developments Occur101 34103 ZONING AND SUBDIVISION FEES20,720 16,600 13,840 17,800 19,800 Based on 2019 / 2020 Actuals & 2021 YTD Monthly Average10134105SALE OF MAPS AND PUBLICATIONS20 ‐ ‐ ‐ ‐ 101 34107 ASSESSMENT SEARCH FEES23,270 38,580 15,590 10,000 28,500 Based on 2019 / 2020 Actuals & 2021 YTD Monthly Average (95%)101 34201 MINING FEES10,391 12,617 22,921 ‐ ‐ Mining expected to cease operations in 2021.101 34302 STREET & TRAFFIC CONTROL SIGNS53,750 33,750 23,250 31,250 31,250 Accounts for 125 Signs Installed by City Staff in New Developments101 34305 CLEAN UP DAY EVENT‐ ‐ 7,152 ‐ 7,000 Estimate Based on Prior Year Actuals101 34320 STREET LIGHT OP16,500 10,500 9,000 12,000 12,000 Conservative ‐ Only Receive if Developments Occur101 34330 GRADING REVIEWS42,354 61,804 43,661 30,000 30,000 200 Permits at $150 (Offsets Grading Review Costs in Building Department)101 34700 RECREATION FEES42,143 16,650 36,090 40,000 45,000 Provided by Ross (7‐07‐2021)101 34701 VETERAN'S MEMORIAL PAVERS870 130 225 300 500 Provided by Ross (7‐07‐2021)101 34710 SHELTER RENTAL FEES4,090 1,865 2,635 3,500 3,500 Provided by Ross (7‐07‐2021)101 34733 TOURNAMENTS‐ ‐ ‐ 1,900 ‐ 101 34740 SPORT FIELD USE3,010 ‐ ‐ 2,800 2,500 Provided by Ross (7‐07‐2021)101 34750 PRAIRIE CENTER3,740 2,567 350 4,500 2,500 Provided by Ross (7‐07‐2021)101 34760 OTSEGO FESTIVAL VENDORS15,120 40 9,470 14,865 21,321 Budgeted Expenditures (101‐45250‐490), less City Contribution ($5,000).TOTAL ‐ CHARGES FOR SERVICES308,290 255,598 241,832 198,915 238,871 Account Number2 Actual Actual Year‐to‐Date Budget BudgetFund Source Account Description 2019 2020 2021 2021 2022 CommentsAccount Number101 36100 SPECIAL ASSESSMENTS5,703 5,434 3,728 3,500 3,400 Estimated at 50% Collection of 2021 Certified Code EnforcementTOTAL ‐ SPECIAL ASSESSMENTS5,703 5,434 3,728 3,500 3,400 101 35101 FINES & FORFEITS26,488 19,959 15,115 24,000 24,000 Court Fines (12 Months @ $2,000) ‐ Offsets Remittance to Wright CountyTOTAL ‐ FINES & FORFEITURES26,488 19,959 15,115 24,000 24,000 101 36210 INTEREST EARNINGS98,736 93,995 314,235 72,000 78,000 2021 YTD into PY Allocation Formula; Then Annualized & Rounded101 36213 NET CHANGE IN INVESTMENT FMV49,203 76,483 (366,365) ‐ ‐ Accounting Only ‐ No Cash TransactionsTOTAL ‐ INVESTMENT INTEREST147,940 170,477 (52,130) 72,000 78,000 101 36200 MISCELLANEOUS REVENUES22,397 4,907 1,665 ‐ ‐ 101 38010 HPC BOOK SALES‐ 160 ‐ ‐ ‐ 101 38020 DONATIONS/CONTRIBUTIONS6,829 1,000 500 ‐ ‐ 101 38991 REFUNDS & REIMBURSEMENTS20,083 17,917 8,617 ‐ ‐ TOTAL ‐ MISCELLANEOUS49,309 23,984 10,782 ‐ ‐ 101 39200 INTERFUND OPERATING TRANSFERS171,900 201,796 ‐ 243,100 286,800 Water & Sanitary Sewer Administrative Services ChargeTOTAL ‐ INTERFUND TRANSFERS171,900 201,796 ‐ 243,100 286,800 Grand Total6,827,546$ 9,236,110$ 5,502,887$ 6,611,457$ 7,331,245$ Change ($)719,788 Change (%)10.89%3 City of OtsegoGeneral Fund Budget ‐ 2022Expenditures by Function SummaryRequested AmountsRequestedActual Actual Year‐to‐Date Budget Budget2019 2020 2021 2021 2022 $ Change % ChangeGeneral Government41100 City Council 77,002$ 86,113$ 65,209$ 157,739$ 149,967$ 41320 City Administrator 161,597 171,207 101,729 185,333 202,438 41400 Administration 310,385 274,719 175,554 306,079 326,018 41410 Elections 2,547 34,185 ‐ 1,600 69,776 41550 Assessing 112,976 125,118 139,898 137,374 150,002 41600 Finance213,731 248,740 163,521 275,188 320,943 41650 Information Technology76,089 150,916 53,680 102,840 127,630 41700 Legal 95,478 83,558 23,316 99,000 93,150 41800 Human Resources 292 89,169 30,364 75,063 126,110 41940 Prairie Center 43,452 39,525 21,815 48,506 54,070 41945 City Hall & Public Works Building 119,505 113,397 71,191 148,847 141,529 41950 Old Township Site2,916 2,990 2,097 3,300 3,400 Subtotal1,215,969 1,419,636 848,373 1,540,869 1,765,033 224,164 14.55%Public Safety42100 Police Services1,326,668 1,391,755 849,600 1,456,260 1,499,184 42150 Public Safety Commission 670 390 ‐ 2,960 2,960 42200 Fire Protection 633,384 723,016 552,146 769,299 919,949 42410 Building Safety399,931 535,092 263,961 467,734 545,334 42500 Emergency Management 2,549 2,391 1,193 2,600 8,900 42710 Animal Control 16,237 14,790 9,210 15,700 16,700 Subtotal2,379,438 2,667,435 1,676,111 2,714,553 2,993,027 278,474 10.26%Public Works43100 Streets781,889 778,343 533,145 928,278 1,025,341 43150 Engineering 90,784 52,253 25,848 92,400 87,500 43160 Street Lights 144,594 153,058 77,048 158,920 167,080 43240 Fleet Management 233,453 221,012 125,681 250,311 276,395 Subtotal1,250,720 1,204,666 761,722 1,429,909 1,556,316 126,407 8.84%Culture & Recreation45200 Park Maintenance478,537 502,867 313,500 550,097 619,109 45250 Recreation228,882 194,288 125,606 243,839 268,500 45300 Heritage Preservation Commission 280 300 ‐ 2,480 2,840 45350 Parks & Recreation Commission ‐ ‐ ‐ ‐ 2,460 Subtotal707,699 697,455 439,106 796,416 892,909 96,493 12.12%Economic Development46530 Planning Commission1,500 1,550 ‐ 4,000 3,500 46570 Planning 107,637 102,460 42,172 110,250 105,000 46580 Economic Development 5,004 561,788 11,021 15,460 15,460 Subtotal114,142 665,798 53,192 129,710 123,960 (5,750) ‐4.43%Interfund Transfers49300 Interfund Transfers971,726 932,244 ‐ ‐ ‐ Subtotal971,726 932,244 ‐ ‐ ‐ ‐ Grand Total6,639,694$ 7,587,233$ 3,778,504$ 6,611,457$ 7,331,245$ 719,788$ 10.89%Function & Department4 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 41100 104 PART‐TIME EMPLOYEES REGULAR 29,430$ 29,070$ 19,650$ 34,000$ 34,000$ 101 41100 122 FICA AND MEDICARE 2,251 2,220 1,494 2,601 2,601 101 41100 150 WORKERS COMPENSATION 68 78 121 87 81 Based on Actual 2021‐2022 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES31,749 31,368 21,265 36,688 36,682 101 41100 210 OPERATING SUPPLIES 80 305 ‐ ‐ ‐ 101 41100 225 UNIFORMS/CLOTHING ALLOWANCE ‐ 66 ‐ 375 375 City Council Logo Wear (5 @ $75 Annually)TOTAL ‐ SUPPLIES80 371 ‐ 375 375 101 41100 320 TELEPHONE 1,721 1,027 347 1,500 1,200 Tablet Data Plan (5 @ $20 Monthly)101 41100 321 MILEAGE/TRAVEL 204 71 142 200 200 101 41100 355 DUES & MEMBERSHIPS 23,290 24,623 19,796 26,200 27,700 See Detailed Attachment101 41100 360 EDUCATION/TRAINING/CONFERENCES 3,980 1,795 6,283 4,325 2,200 See Detailed Attachment101 41100 361 LIABILITY AND PROPERTY INSURAN 12,521 12,142 9,683 13,451 14,110 Based on Actual 2020‐2021 Premiums + 7% Inflation101 41100 390 CONTRACTED SERVICES ‐ 4,667 7,415 15,000 7,500 See Detailed Attachment101 41100 801 CONTINGENCY 3,456 10,048 278 60,000 60,000 Approximately 1% of Total Fund BudgetTOTAL ‐ SERVICES & OTHER CHARGES 45,172 54,374 43,943 120,676 112,910 DEPARTMENT TOTAL77,002$ 86,113$ 65,209$ 157,739$ 149,967$ Change ($)(7,772) Change (%)‐4.93%41100 ‐ City CouncilAccount Number5 City of OtsegoGeneral Fund Budget ‐ 2022Detail of Line Item RequestsCity CouncilRequestedBudget Budget2021 2022 Item Detail / Description Comment200$ 200$ Wright County Mayor's Association Dues17,000 18,000 League of Minnesota Cities Annual Membership Dues9,000 9,500 I‐94 Chamber of Commerce Corridor Coalition26,200 27,700 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 ‐ Events1,000 ‐ Commissioner Appreciation1,125 ‐ Employee Recognition Events4,325 2,200 15,000$ ‐$ Community Survey‐ 7,500 Strategic Planning ‐ Facilitated by Outside Entity‐ ‐ 15,000 7,500 101‐41100‐390Community Survey and Strategic Planning rotate every other year.CONTRACTED SERVICESAccount No. & Description101‐41100‐355DUES & MEMBERSHIPS101‐41100‐360Employee Recognition Policy events now accounted for in the Human Resources department budget.EDUCATION / TRAINING / CONFERENCE6 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 41320 101 FULL‐TIME EMPLOYEES REGULAR 127,922$ 137,029$ 79,140$ 143,040$ 151,384$ 101 41320 104 PART‐TIME ‐ EMPLOYEES REGULAR ‐ ‐ ‐ ‐ 8,160 Internship ‐ MCMA Grant Application Will Cover $3,500101 41320 119 PAYROLL ALLOCATION (972) (1,706) ‐ ‐ ‐ 101 41320 121 PERA 9,594 10,277 5,936 10,728 11,354 101 41320 122 FICA AND MEDICARE 9,081 9,826 5,680 10,943 12,205 101 41320 130 OTHER EMPLOYER PAID INS 12,233 13,385 8,526 12,966 14,015 101 41320 150 WORKERS COMPENSATION 794 869 1,436 980 989 Based on Actual 2021‐2022 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES158,652 169,680 100,717 178,657 198,107 101 41320 225 UNIFORMS/CLOTHING ALLOWANCE 47 63 82 50 50 City Logo Wear (1 @ $50 Annually)TOTAL ‐ SUPPLIES47 63 82 50 50 101 41320 320 TELEPHONE 975 352 149 760 360 Cell Phones ($30 x 1) + Replacement Phone (Last 2021 / Next 2023)101 41320 321 MILEAGE/TRAVEL 496 191 32 800 600 101 41320 355 DUES & MEMBERSHIPS 151 162 170 175 175 Minnesota City/County Management Association (MCMA)101 41320 360 EDUCATION/TRAINING/CONFERENCES 522 92 67 4,180 2,400 See Detailed Attachment101 41320 361 LIABILITY AND PROPERTY INSURAN753 666 512 711 746 Based on Actual 2020‐2021 Premiums + 7% InflationTOTAL ‐ SERVICES & OTHER CHARGES2,898 1,463 930 6,626 4,281 DEPARTMENT TOTAL161,597$ 171,207$ 101,729$ 185,333$ 202,438$ Change ($)17,105 Change (%)9.23%41320 ‐ City AdministratorAccount Number7 City of OtsegoGeneral Fund Budget ‐ 2022Detail of Line Item RequestsCity AdministratorRequestedBudget Budget2021 2022 Item Detail / Description Comment600$ 600$ MCMA Annual Conference Registration & Lodging‐ ‐ ICMA Annual Conference Registration, Lodging, Travel & Per Diems93 118 Citywide Safety Training Program800 ‐ League of Minnesota Cities Annual Conference & Lodging180 180 Wright County City Administrator Monthly Networking Group2,500 1,500 Leadership & Supervisory Training7 2 Rounding4,180 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. LMC conference is budgeted for every other year.EDUCATION / TRAINING / CONFERENCEAccount No. & Description8 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 41400 101 FULL‐TIME EMPLOYEES REGULAR 194,504$ 169,648$ 100,807$ 180,918$ 191,672$ 101 41400 102 FULL‐TIME ‐ OVERTIME 40 5,221 ‐ ‐ 1,000 101 41400 104 PART‐TIME ‐ EMPLOYEES REGULAR 1,247 ‐ ‐ ‐ ‐ 101 41400 121 PERA 14,684 13,086 7,561 13,569 14,450 101 41400 122 FICA AND MEDICARE 14,030 12,801 7,379 13,840 14,739 101 41400 130 OTHER EMPLOYER PAID INS 15,571 12,418 11,632 22,270 21,470 101 41400 150 WORKERS COMPENSATION 1,209 1,184 1,854 1,313 1,252 Based on Actual 2021‐2022 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES241,285 214,357 129,232 231,910 244,583 101 41400 201 OFFICE SUPPLIES AND EXPENSES 9,916 8,062 3,743 8,500 9,000 101 41400 210 OPERATING SUPPLIES 123 149 ‐ ‐ ‐ 101 41400 225 UNIFORMS/CLOTHING ALLOWANCE ‐ ‐ ‐ 150 150 City Logo Wear (3 @ $50 Annually)TOTAL ‐ SUPPLIES10,039 8,211 3,743 8,650 9,150 101 41400 309 SOFTWARE & SUPPORT 21,435 14,144 19,580 21,400 23,500 See Detailed Attachment101 41400 320 TELEPHONE 1,078 425 149 760 760 Cell Phones ($30 x 1) + Replacement Phone (Last 2019 / Next 2022)101 41400 321 MILEAGE/TRAVEL 485 51 134 600 800 101 41400 340 RECORDING FEES3,638 3,703 1,588 3,500 3,500 Easements, Notice of Completion, Agreements, Findings and Decision101 41400 347 NEWSLETTER20,183 23,693 11,892 24,220 25,400 Quarterly Editions at $6,100 + $1,000 for Inflation/New Mailings101 41400 350 PRINT & PUBLISHING8,720 6,523 5,052 7,000 7,500 Ordinances, Legal Notices101 41400 355 DUES & MEMBERSHIPS450 255 417 300 465 See Detailed Attachment101 41400 360 EDUCATION/TRAINING/CONFERENCES1,316 128 881 4,300 5,850 See Detailed Attachment101 41400 361 LIABILITY AND PROPERTY INSURAN1,757 1,454 1,036 1,439 1,510 Based on Actual 2020‐2021 Premiums + 7% Inflation101 41400 390 CONTRACTED SERVICES‐ 1,775 1,850 2,000 3,000 Photographer ‐ Website and Newsletter / Background Checks (Liquor)TOTAL ‐ SERVICES & OTHER CHARGES59,062 52,150 42,579 65,519 72,285 DEPARTMENT TOTAL310,385$ 274,719$ 175,554$ 306,079$ 326,018$ Change ($)19,939 Change (%)6.51%41400 ‐ AdministrationAccount Number9 City of OtsegoGeneral Fund Budget ‐ 2022Detail of Line Item RequestsAdministrationRequestedBudget Budget2021 2022 Item Detail / Description Comment8,600$ 9,800$ 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))5,850 6,800 MyCity Civic App ‐ Annual Support & Maintenance Fee80 30 Contingency / Rounding21,400 23,500 200$ 330$ International Institute of Municipal Clerks (2 Memberships)90 135 Minnesota Clerk & Finance Officer Association (3 Memberships)10 ‐ Contingency / Rounding300 465 125$ 149$ Citywide Safety Training Program700 1,000 Minnesota Clerk & Finance Officer Association Conference (2 Attendees)‐ 445 MCFOA MMCI Institute Year Two Registration (1 Attendee)‐ 2,000 IIMC Conference Registration, Lodging, Travel & Per Diems (1 Attendee)375 215 MCFOA Advanced City Clerk Training Registration (1 Attendee)600 500 LMC / MCFOA / GTS ‐ Training Events & Seminars2,500 1,500 Leadership & Supervisory Training‐ 41 Contingency / Rounding4,300 5,850 101‐41400‐360EDUCATION / TRAINING / CONFERENCEAccount No. & Description101‐41400‐355DUES & MEMBERSHIPS101‐41400‐309Laserfiche licence/support increased due to Workflow products (Permitting & Accounts Payable); which were upgraded in 2020 with CARES Act funding.SOFTWARE & SUPPORT10 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 41410 104 PART‐TIME EMPLOYEES REGULAR ‐$ 22,597$ ‐$ ‐$ 37,856$ Election Judges ‐ Absentee, Direct Balloting & Election Day(s)TOTAL ‐ PERSONAL SERVICES‐ 22,597 ‐ ‐ 37,856 101 41410 206 POSTAGE ‐ ‐ ‐ ‐ 7,730 Mailing of Absentee Ballots for Primary & General (Estimated 5,750)101 41410 210 OPERATING SUPPLIES 921 7,237 ‐ ‐ 6,000 TOTAL ‐ SUPPLIES921 7,237 ‐ ‐ 13,730 101 41410 321 MILEAGE/TRAVEL 26 1,329 ‐ ‐ 4,590 Mileage & Courier Services101 41410 350 PRINT & PUBLISHING ‐ 496 ‐ ‐ 1,000 Legal Newspaper Publishing & Postal Verification Cards (New Precincts)101 41410 410 RENTALS 1,600 1,538 ‐ 1,600 2,600 Annual Maintenance & Support ‐ Lease With Wright County (DS200 & Omni)TOTAL ‐ SERVICES & OTHER CHARGES 1,626 3,363 ‐ 1,600 8,190 101 41410 501 EQUIPMENT ‐ 989 ‐ ‐ 10,000 Additional Voting Booths / Signs / Precinct KitsTOTAL ‐ CAPITAL OUTLAY‐ 989 ‐ ‐ 10,000 DEPARTMENT TOTAL2,547$ 34,185$ ‐$ 1,600$ 69,776$ Change ($) 68,176 Change (%) 4261.00%41410 ‐ ElectionsAccount Number11 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 41550 390 CONTRACTED SERVICES 112,976$ 125,118$ 139,898$ 137,374$ 150,002$ $14.00 Per Parcel (8,893) + 2021 New Construction (425 @ $60 Each)TOTAL ‐ SERVICES & OTHER CHARGES 112,976 125,118 139,898 137,374 150,002 DEPARTMENT TOTAL112,976$ 125,118$ 139,898$ 137,374$ 150,002$ Change ($) 12,628 Change (%) 9.19%41550 ‐ AssessingAccount Number12 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 41600 101 FULL‐TIME EMPLOYEES REGULAR 113,530$ 130,168$ 76,556$ 136,971$ 143,201$ 101 41600 102 FINANCE OVERTIME 86 3,569 382 ‐ ‐ 101 41600 104 WAGES ‐ PT EMPLOYEES ‐ ‐ 10,148 25,074 51,646 Includes two PT Positions ‐ Utility Billing & Finance Assistant101 41600 119 PAYROLL ALLOCATION (161) (169) ‐ ‐ ‐ 101 41600 121 PERA 8,521 10,030 5,770 12,153 14,614 101 41600 122 FICA AND MEDICARE 8,532 9,353 6,242 12,397 14,906 101 41600 130 OTHER EMPLOYER PAID INS 14,046 15,449 9,901 14,968 16,169 101 41600 150 WORKERS COMPENSATION 754 827 1,611 927 1,196 Based on Actual 2021‐2022 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES145,309 169,227 110,610 202,490 241,732 101 41600 201 OFFICE SUPPLIES AND EXPENSES 1,741 648 409 2,000 1,750 101 41600 225 UNIFORMS/CLOTHING ALLOWANCE 50 16 ‐ 100 100 City Logo Wear (2 @ $50 Annually)TOTAL ‐ SUPPLIES1,791 664 409 2,100 1,850 101 41600 304 ACCOUNTING & AUDITING 28,300 29,000 32,725 29,725 33,450 Based on 2019‐2021 Engagement Letter With BerganKDV + Single Audit101 41600 309 SOFTWARE & SUPPORT 14,934 27,805 6,618 12,200 13,100 See Detailed Attachment101 41600 321 MILEAGE/TRAVEL526 258 ‐ 500 500 101 41600 350 PRINT & PUBLISHING3,143 3,738 1,064 3,460 3,310 See Detailed Attachment101 41600 355 DUES & MEMBERSHIPS290 330 330 310 610 See Detailed Attachment101 41600 360 EDUCATION/TRAINING/CONFERENCES2,980 738 708 5,170 7,200 See Detailed Attachment101 41600 361 LIABILITY AND PROPERTY INSURAN1,236 1,050 844 1,173 1,231 Based on Actual 2020‐2021 Premiums + 7% Inflation101 41600 390 CONTRACTED SERVICES13,547 12,033 7,814 14,060 13,960 See Detailed Attachment101 41600 437 BANK SERVICE CHARGES1,675 3,897 2,397 4,000 4,000 Based on 2020 Actuals & 2021 YTD Monthly AverageTOTAL ‐ SERVICES & OTHER CHARGES66,632 78,848 52,501 70,598 77,361 DEPARTMENT TOTAL213,731$ 248,740$ 163,521$ 275,188$ 320,943$ Change ($)45,755 Change (%)16.63%41600 ‐ FinanceAccount Number13 City of OtsegoGeneral Fund Budget ‐ 2022Detail of Line Item RequestsFinanceRequestedBudget Budget2021 2022 Item Detail / Description Comment11,000$ 11,900$ Caselle Financial Software ‐ Annual Maintenance & Support1,200 1,200 Plan‐It ‐ Capital Improvement Plan Sofware ‐ Annual Maintenance & Support‐ ‐ 12,200 13,100 1,300$ 1,450$ Wright County ‐ Truth In Taxation Notices1,000 1,000 Newspaper Publishing (Budget, Summary Financial Reports)700 400 Printing ‐ Comprehensive Annual Financial Reports460 460 Application Fee ‐ Comprehensive Annual Financial Report Award Program3,460 3,310 190$ 190$ (1) National Government Finance Officer's Association Dues ‐ City120 120 (2) State Government Finance Officer's Association Dues ‐ Adam & Julie‐ 125 (1) CPA License Renewal ‐ Adam‐ 175 (1) Certified Public Finance Officer's Program Dues ‐ Julie310 610 950$ 950$ (2) MN GFOA Annual Conference Registration & Lodging‐ 2,500 (1) GFOA Annual Conference Registration, Lodging, Travel & Per Diems125 ‐ (1) CPA License Renewal550 550 (2) Various Government Finance Seminars (CLA, KDV, AEM, MN GFOA, MNCPA, Etc.)150 150 (1) Unlimited Continuing Education Software Package88 143 Citywide Safety Training Program800 800 (2) Civic Systems Annual Sumposium Registration & Lodging (Julie & Mary)‐ 600 Certified Public Finance Officer's Program ‐ Registration & Test Fees (Julie)2,500 1,500 Leadership & Supervisory Training7 7 Contingency / Rounding5,170 7,200 9,300$ 10,200$ Paychex Payroll (Approximately $850 Per Month)960 960 Wageworks Benefits Administration ($80 Monthly)300 300 Wright County ‐ Audit Verification Report + Annual Auditor Certificate3,500 2,500 Wright County ‐ Special Assessment Administration Fees14,060 13,960 101‐41600‐360Employment Agreement outlines that the Finance Director can attend the GFOA conference once every three years (most recently in 2019, planning 2022 for next attendance) and the MNGFOA conference annually.EDUCATION / TRAINING / CONFERENCE101‐41600‐390CONTRACTED SERVICESAccount No. & Description101‐41600‐350PRINT & PUBLISHING101‐41600‐355DUES & MEMBERSHIPS101‐41600‐309Annual support will increase $900 each year (2020‐2022) with Software for Life program.SOFTWARE & SUPPORT14 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 41650 210 OPERATING SUPPLIES 1,586$ 4,534$ 3,364$ 3,500$ 5,500$ TOTAL ‐ SUPPLIES1,586 4,534 3,364 3,500 5,500 101 41650 309 SOFTWARE & SUPPORT 4,612 8,948 12,231 9,980 14,330 See Detailed Attachment101 41650 315 GIS SERVICES 20,593 21,880 8,395 26,300 27,740 See Detailed Attachment101 41650 322 UTILITIES 1,493 1,483 898 1,560 1,560 Charter Communications (TV & Internet Service ~ $130 Monthly)101 41650 390 CONTRACTED SERVICES 42,675 55,827 22,175 54,000 69,000 Softronics at 90 Hours Per Month + Information Security AnalysisTOTAL ‐ SERVICES & OTHER CHARGES 69,372 88,139 43,699 91,840 112,630 101 41650 501 EQUIPMENT 5,131 58,243 6,616 7,500 9,500 See Detailed AttachmentTOTAL ‐ CAPITAL OUTLAY5,131 58,243 6,616 7,500 9,500 DEPARTMENT TOTAL76,089$ 150,916$ 53,680$ 102,840$ 127,630$ Change ($) 24,790 Change (%) 24.11%41650 ‐ Information TechnologyAccount Number15 City of OtsegoGeneral Fund Budget ‐ 2022Detail of Line Item RequestsInformation TechnologyRequestedBudget Budget2021 2022 Item Detail / Description Comment420$ 420$ US Internet ‐ Email Spam Filter300 600 TR Computer Sales ‐ Annual Firewall Protection Upgrade for Router4,500 5,500 Microsoft ‐ Email Server (55 Accounts @ $100 Each)900 900 GOV Office (Avenet) ‐ City Website Hosting875 1,275 AVG ‐ Antivirus Software (51 Computers at $25 Each)2,580 4,128 ZOOM ‐ Virtual Meetings Software ($344 Monthly)405 1,500 Software Licenses ‐ Microsoft Windows, Microsoft Office, Adobe PDF‐ 7 Rounding9,980 14,330 13,740$ 13,740$ Base GIS Services & Licenses ‐ Hakanson Anderson14,000 12,000 GIS Projects ‐ Hakanson Anderson & Midwest CAD Solutions‐ 2,000 Wright County ‐ Aerial Photography (2011 / 2015 / 2019…Next in 2022)27,740 27,740 ‐$ 1,500$ Computer Replacement‐ 1,500 Computer Replacement‐ 1,500 Computer Replacement‐ 1,500 Computer Replacement‐ 1,500 Computer Addition‐ 2,000 City Council Tablet Replacements (4)7,500 ‐ 2021 Replacements7,500 9,500 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 ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 41700 301 LEGAL SERVICES 95,478$ 83,558$ 23,316$ 99,000$ 93,150$ Based on 2019 / 2020 Actuals & 2021 YTD Monthly AverageTOTAL ‐ SERVICES & OTHER CHARGES 95,478 83,558 23,316 99,000 93,150 DEPARTMENT TOTAL95,478$ 83,558$ 23,316$ 99,000$ 93,150$ Change ($) (5,850) Change (%) ‐5.91%41700 ‐ LegalAccount Number17 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2018 2019 2020 2020 2021 Comments101 41800 101 FULL‐TIME EMPLOYEES REGULAR ‐$ 51,960$ 15,370$ 53,144$ 83,649$ 101 41800 121 PERA ‐ 3,793 1,153 3,986 6,274 101 41800 122 FICA AND MEDICARE ‐ 3,628 235 4,066 6,399 101 41800 130 OTHER EMPLOYER PAID INS ‐ 11,797 1,327 12,735 11,624 101 41800 150 WORKERS COMPENSATION 173 395 748 437 552 Based on Actual 2021‐2022 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES173 71,574 18,833 74,368 108,498 101 41800 225 UNIFORMS/CLOTHING ALLOWANCE ‐ ‐ ‐ 50 50 City Logo Wear (1 @ $50 Annually)TOTAL ‐ SUPPLIES‐ ‐ ‐ 50 50 101 41800 320 TELEPHONE ‐ ‐ ‐ ‐ 360 Cell Phones ($30 x 1) + Replacement Phone (Last 2021 / Next 2023)101 41800 321 MILEAGE/TRAVEL ‐ 79 ‐ 100 400 101 41800 355 DUES & MEMBERSHIPS ‐ ‐ 675 45 1,040 See Detailed Attachment101 41800 360 EDUCATION/TRAINING/CONFERENCES ‐ 44 190 59 4,800 See Detailed Attachment101 41800 361 LIABILITY AND PROPERTY INSURAN 119 442 317 441 462 Based on Actual 2020‐2021 Premiums + 7% Inflation101 41800 390 CONTRACTED SERVICES ‐ 17,029 10,349 ‐ 10,500 See Detailed AttachmentTOTAL ‐ SERVICES & OTHER CHARGES 119 17,595 11,531 645 17,562 DEPARTMENT TOTAL292$ 89,169$ 30,364$ 75,063$ 126,110$ Change ($)51,047 Change (%)68.01%41800 ‐ Human ResourcesAccount Number18 City of OtsegoGeneral Fund Budget ‐ 2022Detail of Line Item RequestsHuman ResourcesRequestedBudget Budget2021 2022 Item Detail / Description Comment45$ ‐$ Minnesota Clerks & Finance Officer Association‐ 175 (1) Minnesota City/County Management Association (MCMA) + Assistant Membership‐ 219 (1) SHRM Membership (Society of Human Resources Managers)‐ 640 (1) ICMA Membership‐ 6 Rounding45 1,040 59$ 66$ Citywide Safety Training Program‐ 700 MCMA Annual Conference Registration & Lodging‐ 125 MCMA Winter Workshop‐ 725 SHRM Learning System (Pre‐certification)‐ 1,500 Leadership & Supervisory Training‐ 1,500 Employee Recognition Events (50 Staff @ $25) + Years of Service Recognition ($250)‐ 180 Wright County City Administrator Monthly Networking Group‐ 4 Rounding59 4,800 ‐$ 4,000$ Insights Discovery Profiles Certification Course‐ 1,500 Insights Discovery Profiles (New Hires)‐ 5,000 Sunshine Committee Breakout Groups (Quarterly Training Sessions)‐ ‐ ‐ 10,500 101‐41800‐390CONTRACTED SERVICESAccount No. & Description101‐41800‐355DUES & MEMBERSHIPS101‐41800‐360EDUCATION / TRAINING / CONFERENCE19 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 41940 201 OFFICE SUPPLIES AND EXPENSES ‐$ 537$ ‐$ ‐$ ‐$ 101 41940 210 OPERATING SUPPLIES 6,919 10,537 2,393 9,500 6,600 See Detailed Attachment101 41940 220 REPAIR/MAINT SUPPLY 694 23 ‐ ‐ ‐ TOTAL ‐ SUPPLIES7,613 11,097 2,393 9,500 6,600 101 41940 320 TELEPHONE 1,586 1,624 852 1,680 1,740 Centurylink (Elections Line + Alarm Monitoring) ‐ $145 Monthly101 41940 322 UTILITIES 10,569 10,158 5,006 11,000 11,000 Natural Gas (Centerpoint) & Electric (Wright Hennepin)101 41940 325 GARBAGE SERVICE 1,644 1,709 924 1,740 1,920 Randy's Environmental Services (12 Months at $160)101 41940 361 LIABILITY AND PROPERTY INSURAN 1,487 1,579 1,242 1,726 1,810 Based on Actual 2020‐2021 Premiums + 7% Inflation101 41940 389 CLEANING SERVICES ‐ ‐ 3,326 4,700 5,000 Contracted Cleaning Service (2x Weekly)101 41940 390 CONTRACTED SERVICES 2,471 6,082 761 3,310 3,500 See Detailed Attachment101 41940 402 REPAIRS/MAINT BUILDINGS 11,766 3,023 2,274 8,050 11,000 See Detailed Attachment101 41940 410 RENTALS 3,535 2,772 1,478 3,700 3,400 Lease ‐ Color Copier/Printer #3004 (Quarterly Lease + $100 Monthly)TOTAL ‐ SERVICES & OTHER CHARGES 33,058 26,948 15,863 35,906 39,370 101 41940 501 EQUIPMENT 2,780 1,480 3,559 3,100 3,100 Replacement and Additonal Furniture for Meeting and Office Space101 41940 525 BUILDING IMPROVEMENTS ‐ ‐ ‐ ‐ 5,000 ADA Transition Plan ItemsTOTAL ‐ CAPITAL OUTLAY2,780 1,480 3,559 3,100 8,100 DEPARTMENT TOTAL43,452$ 39,525$ 21,815$ 48,506$ 54,070$ Change ($)5,564 Change (%)11.47%41940 ‐ Prairie CenterAccount Number20 City of OtsegoGeneral Fund Budget ‐ 2022Detail of Line Item RequestsPrairie CenterRequestedBudget Budget2021 2022 Item Detail / Description Comment550$ 550$ Office Supplies (Paper, Printer Cartridges, Etc.)1,700 1,700 Coffee for Meetings / Drinking Water / Water Softener Salt1,750 1,900 Cleaning & Restroom Products2,000 2,000 Building Supplies (Batteries, Air Filters, Office Equipment, Etc.)3,000 ‐ Repair & Maintenance Supplies Conducted by City Staff500 450 Contingency ‐ Unidentified items or emergency purchases.9,500 6,600 460$ 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 & Inspections300 500 Window Cleaning500 500 Well and Septic System Services600 550 Contingency ‐ Unidentified services at Prairie Center3,310 3,500 1,500$ 1,500$ HVAC3,800 3,800 Electrical, Plumbing & Equipment Failures750 750 Generator Inspection & Maintenance‐ 3,000 Repair & Maintenance Supplies Conducted by City Staff2,000 1,950 Contingency ‐ Unidentified or emergency repairs.8,050 11,000 101‐41940‐402Supplies for R/M conducted by City staff moved from object code #210 (see above).REPAIRS/MAINT BUILDINGSAccount No. & Description101‐41940‐390CONTRACTED SERVICES101‐41940‐210Supplies for R/M conducted by City staff moved to object code #402 (see below).OPERATING SUPPLIES21 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 41945 201 OFFICE SUPPLIES AND EXPENSES 339$ 351$ ‐$ 200$ ‐$ 101 41945 206 POSTAGE 4,902 11,222 1,300 4,500 4,500 Based on 2019 Actuals & 2021 YTD Monthly Average101 41945 210 OPERATING SUPPLIES 4,127 2,896 1,401 4,800 4,800 Coffee & Water / Cleaning & Restroom Products / Building Supplies101 41945 220 REPAIR/MAINT SUPPLY 472 3,062 52 3,000 ‐ Supplies for repairs & maintenance conducted by City StaffTOTAL ‐ SUPPLIES9,840 17,531 2,753 12,500 9,300 101 41945 320 TELEPHONE 8,818 8,216 4,638 8,400 8,400 CenturyLink (Alarms / Fax) & Nova (Phones) ‐ $700 Monthly101 41945 322 UTILITIES 31,618 28,888 15,777 31,900 31,600 Natural Gas (Centerpoint) & Electric (Wright Hennepin)101 41945 325 GARBAGE SERVICE 11,032 10,060 7,076 10,500 11,300 Randy's Environmental Services101 41945 361 LIABILITY AND PROPERTY INS 11,132 11,830 9,284 12,897 13,529 Based on Actual 2020‐2021 Premiums + 7% Inflation101 41945 389 CLEANING SERVICES 11,404 10,384 6,631 12,450 12,450 See Detailed Attachment101 41945 390 CONTRACTED SERVICES 7,342 8,204 5,869 10,200 11,700 See Detailed Attachment101 41945 402 REPAIRS/MAINT BUILDINGS 14,697 4,516 4,854 10,500 14,000 See Detailed Attachment101 41945 410 RENTALS 13,623 13,770 8,667 14,500 14,250 See Detailed AttachmentTOTAL ‐ SERVICES & OTHER CHARGES 109,665 95,866 62,795 111,347 117,229 101 41945 501 EQUIPMENT ‐ ‐ ‐ ‐ 10,000 Office Equipment & Furniture101 41945 525 BUILDING IMPROVEMENTS‐ ‐ 5,643 25,000 5,000 ADA Transition Plan ItemsTOTAL ‐ CAPITAL OUTLAY‐ ‐ 5,643 25,000 15,000 DEPARTMENT TOTAL119,505$ 113,397$ 71,191$ 148,847$ 141,529$ Change ($)(7,318) Change (%)‐4.92%41945 ‐ City Hall & Public Works BuildingAccount Number22 City of OtsegoGeneral Fund Budget ‐ 2022Detail of Line Item RequestsCity Hall & PW BuildingRequestedBudget Budget2021 2022 Item Detail / Description Comment11,000$ 11,000$ Cleaning Service ($850 Monthly + 3% Inflation) ‐ Rounded800 800 Inside & Outside Window Cleaning650 650 Floor Cleaning12,450 12,450 800$ 800$ Wright Hennepin ‐ Burglary & Fire Alarm Monitoring ($69.15 Monthly) ‐ Rounded900 1,000 Elevator Service Contract & Annual MN Department of Labor Permit40 40 Boiler Inspections ‐ MN Department of Labor500 520 Pest Control (Approximately $130 Per Quarter)400 400 Septic Tank Pumping1,000 1,600 Fire Alarms & Sprinkler Inspection Services750 750 Generator Inspection & Maintenance600 ‐ Fire Alarm System Testing & Inspections600 600 Overhead Crane Inspection1,450 1,450 Fuel Island Inspection & Service Calls (if necessary)650 650 Salt Shed Annual Inspection‐ 600 Fire Extinguishers Annual Inspections & Maintenance‐ 800 RPZ Annual Testing & Inspection2,510 2,490 Contingency ‐ Unidentified services at City Hall10,200 11,700 2,500$ 3,000$ HVAC7,500 7,500 Electrical, Plumbing, Equipment Failures500 500 Garage Doors Service & Maintenance‐ 3,000 Repair & Maintenance Supplies Conducted by City Staff10,500 14,000 3,756$ 3,756$ Lease ‐ Wide Format Printer #6700 (Building Department)2,592 2,592 Lease ‐ Color Copier/Printer #4504 (Administration)2,168 1,684 Lease ‐ Color Copier/Printer #3004 (Reception)2,040 2,416 Lease ‐ Postage Machine + R/M + Supplies3,600 3,600 Cost of Print/Copy Overages344 202 Rounding14,500 14,250 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 ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 41950 322 UTILITIES 2,916$ 2,990$ 2,097$ 3,300$ 3,400$ Gas & Electric Utilities for Old Town Site (Hall Building + Shop Building)TOTAL ‐ SERVICES & OTHER CHARGES 2,916 2,990 2,097 3,300 3,400 DEPARTMENT TOTAL2,916$ 2,990$ 2,097$ 3,300$ 3,400$ Change ($) 100 Change (%) 3.03%41950 ‐ Old Township SiteAccount Number24 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 42100 310 MISCELLANEOUS 21,428$ 17,059$ 14,115$ 24,000$ 24,000$ Court Fines (12 Months @ $2,000) ‐ Offsets Revenue Amount101 42100 390 CONTRACTED SERVICES 1,305,240 1,374,696 835,485 1,432,260 1,475,184 Calculated at $84.20 at 48 Hours Daily (Increase of $2.45/3% over 2021)TOTAL ‐ SERVICES & OTHER CHARGES 1,326,668 1,391,755 849,600 1,456,260 1,499,184 DEPARTMENT TOTAL1,326,668$ 1,391,755$ 849,600$ 1,456,260$ 1,499,184$ Change ($) 42,924 Change (%) 2.95%42100 ‐ Police ServicesAccount Number25 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 42150 104 PART‐TIME EMPLOYEES REGULAR 670$ 390$ ‐$ 960$ 960$ 7 Members + Alternate ‐ 12 Meetings at $10 Per MeetingTOTAL ‐ PERSONAL SERVICES670 390 ‐ 960 960 101 42150 210 OPERATING SUPPLIES ‐ ‐ ‐ 500 500 TOTAL ‐ SUPPLIES‐ ‐ ‐ 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 TOTAL670$ 390$ ‐$ 2,960$ 2,960$ Change ($) ‐ Change (%) 0.00%42150 ‐ Public Safety CommissionAccount Number26 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 42200 208 MEETING SUPPLIES ‐$ ‐$ ‐$ 500$ 500$ Fire Department Recognition Events101 42200 210 OPERATING SUPPLIES ‐ 450 ‐ ‐ ‐ TOTAL ‐ SUPPLIES‐ 450 ‐ 500 500 101 42200 390 CONTRACTED SERVICES 633,002 722,566 552,146 768,799 919,449 Calculation Details Below101 42200 441 LICENSES, TAXES & FEES 382 ‐ ‐ ‐ ‐ TOTAL ‐ SERVICES & OTHER CHARGES 633,384 722,566 552,146 768,799 919,449 DEPARTMENT TOTAL633,384$ 723,016$ 552,146$ 769,299$ 919,949$ Change ($) 150,650 Change (%) 19.58%Albertville 334,684$ 407,252$ 216,987$ 433,658$ 463,439$ Albertville's Budget ($909,980; +4% from 2021); Otsego Portion is 50.9%Elk River 241,094 248,480 256,233 256,215 263,920 $70.22 Per Parcel (2021 = 3,649 / 2022 Estimated at 3,649) + 3% InflationRogers 57,224 66,834 78,926 78,926 95,635 2021 Market Value Multiplied by 0.00044Other 382 ‐ ‐ ‐ 96,455 Contingency for Pending Contract Renewals (Elk River)Total633,384 722,566 552,146 768,799 919,449 Difference0 (0) (0) 0 0 42200 ‐ Fire ProtectionAccount Number 27 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 42410 101 FULL‐TIME EMPLOYEES REGULAR 85,982$ 107,658$ 63,193$ 113,246$ 118,090$ 101 42410 102 OVERTIME ‐ 1,932 ‐ ‐ ‐ 101 42410 104 PART‐TIME ‐ EMPLOYEES REGULAR 11,997 ‐ ‐ ‐ ‐ 101 42410 121 PERA 7,348 8,219 4,739 8,493 8,857 101 42410 122 FICA AND MEDICARE 7,021 7,831 4,552 8,663 9,034 101 42410 130 OTHER EMPLOYER PAID INS 18,282 20,066 13,060 19,876 21,484 101 42410 150 WORKERS COMPENSATION 558 659 1,120 764 771 Based on Actual 2021‐2022 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES131,188 146,365 86,663 151,042 158,236 101 42410 201 OFFICE SUPPLIES AND EXPENSES 601 1,123 790 2,000 1,500 101 42410 202 FUEL 2,315 2,015 ‐ 2,500 2,500 Allocated at Year‐End Based on Percentage of Gallons Used101 42410 225 UNIFORMS/CLOTHING ALLOWANCE ‐ ‐ ‐ 100 100 City Logo Wear (2 @ $50 Annually)TOTAL ‐ SUPPLIES2,915 3,139 790 4,600 4,100 101 42410 302 ENGINEERING FEES 15,774 22,142 10,508 17,900 20,600 Based on 2019 / 2020 Actuals & 2021 YTD Monthly Average101 42410 303 PLANNING FEES ‐ ‐ 3,492 ‐ 7,000 Based on 2021 YTD Monthly Average101 42410 309 SOFTWARE & SUPPORT 3,585 42,706 3,585 6,000 6,000 Permit Works Package (Permitting, Licensing & Code Enforcement)101 42410 311 GRADING REVIEWS36,300 35,275 5,893 28,125 35,750 261 New Permits at $125 Each + 25 Second Inspections101 42410 321 MILEAGE/TRAVEL‐ 198 ‐ 400 400 101 42410 338 REIMBURSABLE COSTS‐ 3,747 ‐ 15,000 10,000 Contracted Abatements101 42410 350 PRINT & PUBLISHING270 862 368 750 750 Code Books / Septic System Owners Guide101 42410 355 DUES & MEMBERSHIPS135 145 95 350 350 See Detailed Attachment101 42410 360 EDUCATION/TRAINING/CONFERENCES264 228 152 1,600 1,600 See Detailed Attachment101 42410 361 LIABILITY & PROPERTY INSURANCE1,569 1,513 1,200 1,667 1,748 Based on Actual 2020‐2021 Premiums + 7% Inflation101 42410 390 CONTRACTED SERVICES207,931 278,773 151,215 240,300 298,800 Average of 332 Hours (2020‐2021 YTD) ‐ $75.00 HourlyTOTAL ‐ SERVICES & OTHER CHARGES265,828 385,589 176,507 312,092 382,998 DEPARTMENT TOTAL399,931$ 535,092$ 263,961$ 467,734$ 545,334$ Change ($)77,600 Change (%)16.59%42410 ‐ Building SafetyAccount Number28 City of OtsegoGeneral Fund Budget ‐ 2022Detail of Line Item RequestsBuilding SafetyRequestedBudget Budget2021 2022 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 73$ 92$ Citywide 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)27 8 Contingency / Rounding‐ ‐ 1,600 1,600 Account No. & Description101‐42410‐355DUES & MEMBERSHIPS101‐42410‐360EDUCATION / TRAINING / CONFERENCE29 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 42500 210 OPERATING SUPPLIES 1,944$ 1,785$ 540$ 500$ 2,000$ Siren Batteries / 800mhz Radio Batteries & SuppliesTOTAL ‐ SUPPLIES1,944 1,785 540 500 2,000 101 42500 322 UTILITIES 605 607 449 600 700 Electricity for Emergency Sirens101 42500 360 EDUCATION/TRAINING/CONFERENCES ‐ ‐ ‐ 1,500 1,500 NIMS / Other Emergency Related Training101 42500 390 CONTRACTED SERVICES ‐ ‐ 204 ‐ 1,700 Wright County IT: 800 MHz radio service (17) @ $100TOTAL ‐ SERVICES & OTHER CHARGES 605 607 653 2,100 3,900 101 42500 500 CAPITAL OUTLAY (GENERAL) ‐ ‐ ‐ ‐ 3,000 Additional 800mhz Radio + ProgrammingTOTAL ‐ CAPITAL OUTLAY‐ ‐ ‐ ‐ 3,000 DEPARTMENT TOTAL2,549$ 2,391$ 1,193$ 2,600$ 8,900$ Change ($) 6,300 Change (%) 242.31%42500 ‐ Emergency ManagementAccount Number30 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 42710 390 CONTRACTED SERVICES 16,237$ 14,790$ 9,210$ 15,700$ 16,700$ Based on 2019 / 2020 Actuals & 2021 YTD Monthly AverageTOTAL ‐ SERVICES & OTHER CHARGES 16,237 14,790 9,210 15,700 16,700 DEPARTMENT TOTAL16,237$ 14,790$ 9,210$ 15,700$ 16,700$ Change ($) 1,000 Change (%) 6.37%42710 ‐ Animal ControlAccount Number31 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 43100 101 FULL‐TIME EMPLOYEES REGULAR 381,551$ 420,735$ 242,519$ 444,433$ 496,833$ Includes FT Hire (Based on May 2022 Hiring Timeline)101 43100 102 FULL‐TIME ‐ OVERTIME 18,447 7,747 4,659 9,000 9,000 101 43100 104 PART‐TIME ‐ EMPLOYEES REGULAR 29,663 6,163 11,715 31,440 31,440 Includes 4 Seasonal Staff (12 Week Positions @ 40 Hours)101 43100 119 PAYROLL ALLOCATION (25,748) (12,945) ‐ ‐ ‐ 101 43100 121 PERA 30,015 32,136 18,414 34,007 37,937 101 43100 122 FICA AND MEDICARE 31,165 31,353 19,005 37,093 41,101 101 43100 130 OTHER EMPLOYER PAID INS 45,868 52,711 33,215 53,218 59,309 101 43100 140 UNEMPLOYMENT COMP 1,856 714 ‐ ‐ ‐ 101 43100 150 WORKERS COMPENSATION 33,086 36,995 64,994 41,669 46,109 Based on Actual 2021‐2022 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES545,903 575,609 394,521 650,860 721,729 101 43100 201 OFFICE SUPPLIES AND EXPENSES 1,523 1,159 994 1,220 1,245 See Detailed Attachment101 43100 210 OPERATING SUPPLIES 7,362 5,947 5,742 5,810 6,040 See Detailed Attachment101 43100 220 REPAIR/MAINT SUPPLY 3,895 7,571 4,390 8,506 9,059 See Detailed Attachment101 43100 225 UNIFORMS/CLOTHING ALLOWANCE 4,694 2,363 1,299 5,550 6,100 See Detailed Attachment101 43100 227 SAFETY SUPPLIES 4,151 2,988 1,447 3,825 3,975 See Detailed Attachment101 43100 234 BLACKTOP SUPPLIES 23,567 21,365 8,033 34,725 35,825 See Detailed Attachment101 43100 240 SMALL TOOLS/EQUIPMENT8,657 9,639 4,985 7,690 8,580 See Detailed Attachment101 43100 270 SAND AND GRAVEL21,017 18,949 16,479 25,200 25,900 See Detailed Attachment101 43100 272 SALT AND SAND70,504 59,107 31,917 65,600 67,425 See Detailed Attachment101 43100 293 SIGN/SIGNAL MATERIAL PURCHASED15,459 17,783 7,801 17,485 21,785 See Detailed AttachmentTOTAL ‐ SUPPLIES160,830 146,873 83,088 175,611 185,934 101 43100 302 ENGINEERING FEES1,040 ‐ ‐ ‐ ‐ 101 43100 309 SOFTWARE & SUPPORT‐ ‐ 600 ‐ 600 Sign Cad Annual Maintenance‐ Sign Design101 43100 315 GIS SERVICES‐ ‐ ‐ 1,000 1,000 Special Projects ‐ Midwest CAD101 43100 320 TELEPHONE6,799 3,418 2,063 4,320 4,680 Cell Phones ($30 x 8) + IPAD ($25) + Replacement Phones ($1,500)101 43100 322 UTILITIES‐ 265 40 ‐ ‐ 101 43100 325 GARBAGE SERVICE1,704 1,718 25 2,025 2,400 See Detailed Attachment101 43100 350 PRINT & PUBLISHING260 ‐ ‐ 275 275 See Detailed Attachment101 43100 355 DUES & MEMBERSHIPS100 100 ‐ 150 150 See Detailed Attachment101 43100 360 EDUCATION/TRAINING/CONFERENCES4,287 6,193 3,388 9,280 9,500 See Detailed Attachment101 43100 361 LIABILITY AND PROPERTY INSURAN12,651 12,494 8,953 12,438 13,048 Based on Actual 2020‐2021 Premiums + 7% Inflation101 43100 390 CONTRACTED SERVICES15,108 11,727 4,724 24,600 22,200 See Detailed Attachment101 43100 402 REPAIRS/MAINT BUILDINGS89 ‐ ‐ ‐ ‐ 101 43100 410 RENTALS6,291 ‐ 3,848 11,400 15,400 See Detailed Attachment101 43100 436 DUSTCOATING16,335 19,945 17,807 27,319 27,850 See Detailed Attachment101 43100 445 COMMUNITY EVENTS‐ ‐ 5,269 ‐ 8,500 Clean Up Day (Offset by Revenues in 101‐34305)TOTAL ‐ SERVICES & OTHER CHARGES64,664 55,861 46,716 92,807 105,603 101 43100 501 EQUIPMENT10,491 ‐ 8,820 9,000 12,075 4.5 Cubic Yard Compost BucketTOTAL ‐ CAPITAL OUTLAY10,491 ‐ 8,820 9,000 12,075 DEPARTMENT TOTAL781,889$ 778,343$ 533,145$ 928,278$ 1,025,341$ Change ($)97,063 Change (%)10.46%43100 ‐ StreetsAccount Number32 City of OtsegoGeneral Fund Budget ‐ 2022Detail of Line Item RequestsStreetsRequestedBudget Budget2021 2022 Item Detail / Description Comment820$ 845$ Background checks and drug testing (Seasonals)400 400 Office Supplies1,220 1,245 1,200$ 1,260$ Herbicide600 750 Lath/Fiberglass Markers400 420 Acetylene/Torch Supplies2,560 2,560 Pressure Washer Detergent300 300 Road Clean‐up Supplies750 750 Miscellaneous5,810 6,040 575$ 708$ Grass Seed375 375 Erosion Control Blanket and Stakes1,000 1,000 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 repairs700 800 Propane for patching500 520 Rock / Gravel repairs500 800 Brine Tanks ‐ Valves/Fittings/Etc.8,506 9,059 2,800$ 3,200$ Clothing (8 Fulltime Employees @ $400)1,650 1,800 Boots (8 Fulltime & 4 Part‐Time @ $150)600 600 Summer seasonal uniform allowance500 500 Hats5,550 6,100 1,000$ 1,000$ Cones/Barricades450 525 Safety Vests200 200 Hearing protection + Sound Deadening200 200 Gloves150 150 Eye protection500 500 Hard hats/face shields500 500 Hands‐Free Radio/Cell‐Phone Mounts825 900 Reflective jackets3,825 3,975 Account No. & Description101‐43100‐201OFFICE SUPPLIES101‐43100‐210101‐43100‐220101‐43100‐225SAFETY SUPPLIESMisc. 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‐227Used for the purchase of required safety gear.33 City of OtsegoGeneral Fund Budget ‐ 2022Detail of Line Item RequestsStreetsRequestedBudget Budget2021 2022 Item Detail / Description CommentAccount No. & Description300$ 300$ Cold mix4,425 4,425 Tack oil30,000 31,100 Asphalt Mix‐ ‐ ‐ ‐ 34,725 35,825 500$ 600$ Blacktopping Tools1,100 1,100 Chainsaw1,440 1,480 Chop saw blades400 500 Chains/Binders500 500 Jackhammer bits750 900 Cordless Power Tools1,500 2,000 Brine Tanks/Supplies‐ 500 Backpack Blower1,500 1,000 Misc. tools7,690 8,580 9,000$ 9,250$ Misc. Repairs and Shouldering 1,000 Ton16,200 ‐ Prior Year Total‐ 6,475 60th Street‐ 4,625 65th Street‐ 5,550 Ochoa/Frontage Road25,200 25,900 65,600$ ‐$ Prior Year Total‐ 62,400 Regular Road Salt ‐ 800 Tons @ $78 per ton.‐ 1,000 Sand ‐ 100 Tons @ $10 per ton‐ 4,025 Anti‐Icing Chemicals ‐ 7 Totes @ $575 per tote.‐ ‐ 65,600 67,425 905$ ‐$ Sign Cad Annual Maintenance‐ Sign Design1,100 1,100 Sign Trak Annual Maintenance‐ Sign Inventory390 455 Traffic signal bulbs3,150 3,150 175 posts ( round/U‐channel) avg. $18/post1,000 1,000 Hardware: brackets, fineals, bolts, etc.1,840 1,880 Film (4) @ $470/roll3,200 4,000 Sign blanks (250) @ $16/avg.3,200 ‐ Flashing Stop Signs/Speed Warning capable signs1,700 1,700 Breakaways for center medians‐ 3,500 Solar ‐ Flashing Crosswalk Signs (1 Set)‐ 4,000 Post mounted speed monitor (1 sign)1,000 1,000 Concrete 250 bags @ $417,485 21,785 101‐43100‐293SIGN/SIGNAL MATERIALSSnow 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. Staff has reserved the same amount used in the 2020/21 season of 800 ton of regular road salt.101‐43100‐272SALT AND SAND101‐43100‐234BLACKTOP SUPPLIES101‐43100‐240SMALL TOOLS & EQUIPMENT101‐43100‐270Anticipate the additional need to patch rural sections of streets and more full‐depth patching. 2018 tonnage was 283 ton in 2019, 325 of fine and 1/2" mix was put down. 2021 estimates include plans to put down 350 ton of fine and 1/2" mix. Estimate includes 100 ton of 1/2" mix at $75/ton and 250 ton of fine mix at $90/ton. Fine mix is more expensive because it requires additional screening.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. Staff anticipates purchasing 2,800 ton for those roads in 2021 listed which includes 1,000 ton for misc. repairs and shouldering. 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.34 City of OtsegoGeneral Fund Budget ‐ 2022Detail of Line Item RequestsStreetsRequestedBudget Budget2021 2022 Item Detail / Description CommentAccount No. & Description175$ 200$ Fluorescent Lights750 800 Appliance Recycling750 1,000 Roadside Debris/Waste Management350 400 Tires2,025 2,400 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 200 St. Cloud Fall Maintenance Expo4,200 5,499 Citywide Safety Training Program100 100 Learn Safety Program (LMC)1,600 1,600 LTAP Courses: Pavement Mngt., Stormwater, Salting50 50 MN Loss Control Workshop2,500 1,500 Leadership & Supervisory Training410 331 Unidentified safety courses; contingency; rounding9,280 9,500 700$ 700$ Fire Extinguisher Maintenance‐ Dehmers1,500 ‐ Wright County IT: 800 MHz radio service (17) @ $100750 750 Pressure Washer Service‐ Hotsy2,000 2,000 Off‐site light service, Kirsch Electric15,000 15,000 Concrete Repairs, cross gutters, cross walks, curbing850 ‐ Two‐way radio service1,000 1,000 Albertville Compost Site Cost Sharing750 750 Wright County Signal Light Maintenance Per Contract2,050 2,000 Contingency ‐ Unidentified or emergency services.24,600 22,200 2,600$ ‐$ Asphalt Mill 10 days @ $260/day8,800 8,800 Loader Rental ‐ Winter Snow Removal (2 Months)‐ 6,600 Compost Screen Rental11,400 15,400 17,319$ 17,850$ Dust contol ‐ both public and private10,000 10,000 Secondary dust control application.‐ ‐ 27,319 27,850 GARBAGE SERVICERentals 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.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. 35 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 43150 302 ENGINEERING FEES 90,784$ 52,253$ 25,848$ 92,400$ 87,500$ Based on 2019 / 2020 Actuals & 2021 YTD Monthly AverageTOTAL ‐ SERVICES & OTHER CHARGES 90,784 52,253 25,848 92,400 87,500 DEPARTMENT TOTAL90,784$ 52,253$ 25,848$ 92,400$ 87,500$ Change ($) (4,900) Change (%) ‐5.30%43150 ‐ EngineeringAccount Number36 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 43160 322 UTILITIES 144,594$ 150,350$ 77,048$ 148,920$ 157,080$ Based on 2021 YTD Monthly Average + 2% Inflation101 43160 390 CONTRACTED SERVICES ‐ 2,708 ‐ 10,000 10,000 Additions to Street Light System in Accordance With Street Light PolicyTOTAL ‐ SERVICES & OTHER CHARGES 144,594 153,058 77,048 158,920 167,080 DEPARTMENT TOTAL144,594$ 153,058$ 77,048$ 158,920$ 167,080$ Change ($) 8,160 Change (%) 5.13%43160 ‐ Street LightsAccount Number37 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 43240 101 FULL‐TIME EMPLOYEES REGULAR 58,547$ 62,427$ 28,920$ 63,658$ 58,299$ 101 43240 102 OVERTIME 2,527 1,427 295 2,000 2,000 101 43240 121 PERA 4,558 4,789 1,723 4,924 4,522 101 43240 122 FICA AND MEDICARE 4,660 4,755 2,204 5,023 4,613 101 43240 130 OTHER EMPLOYER PAID INS 6,715 7,110 3,136 7,273 13,773 101 43240 150 WORKERS COMPENSATION 2,175 2,438 4,047 2,776 2,780 Based on Actual 2021‐2022 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES79,182 82,946 40,325 85,654 85,987 101 43240 202 FUEL 60,692 39,171 33,662 57,946 64,529 See Detailed Attachment101 43240 210 OPERATING SUPPLIES 36,027 37,209 10,839 41,751 46,864 See Detailed Attachment101 43240 220 REPAIR/MAINT SUPPLY 38,588 42,976 24,001 51,924 57,829 See Detailed Attachment101 43240 225 UNIFORMS/CLOTHING ALLOWANCE 3,595 3,097 1,993 3,006 3,426 See Detailed Attachment101 43240 240 SMALL TOOLS/EQUIPMENT 5,777 6,965 910 7,670 8,000 Mechanics Tools101 43240 293 SIGN/SIGNAL MATERIAL PURCHASED 174 42 ‐ ‐ ‐ 101 43240 298 W/S FLEET EXPENSES (9,786) (18,311) ‐ (8,000) (8,000) Allocation of Utility Fund Fleet Repairs & MaintenanceTOTAL ‐ SUPPLIES135,067 111,149 71,404 154,297 172,648 101 43240 309 SOFTWARE & SUPPORT‐ 284 113 ‐ 3,900 See Detailed Attachment101 43240 320 TELEPHONE623 420 149 760 760 Cell Phones ($30 x 1) + Replacement Phone ($400)101 43240 360 EDUCATION/TRAINING/CONFERENCES256 356 190 600 600 See Detailed Attachment101 43240 390 CONTRACTED SERVICES18,325 25,858 13,500 9,000 12,500 See Detailed AttachmentTOTAL ‐ SERVICES & OTHER CHARGES19,204 26,918 13,952 10,360 17,760 DEPARTMENT TOTAL233,453$ 221,012$ 125,681$ 250,311$ 276,395$ Change ($)26,084 Change (%)10.42%43240 ‐ Fleet ManagementAccount Number38 City of OtsegoGeneral Fund Budget ‐ 2022Detail of Line Item RequestsFleet ManagementRequestedBudget Budget2021 2022 Item Detail / Description Comment72,000$ 81,000$ Diesel/Gasoline283 285 DEF Fluid150 150 Diesel Treatment/Anti‐gel(14,487) (16,906) Allocated to: Building Department & Public Utilities57,946 64,529 ‐$ 520$ License Tabs: 25 vehicles @ $17.50/ea. ‐ Every Other Year10,500 11,655 Oil: Hydraulic, 10‐30, 15‐40, Grease3,800 4,218 Brooms: Main/Gutter brooms for sweeper1,750 1,943 Filters15,701 17,428 Cutting Edges, 8 V‐plows, Road Grader, etc.10,000 11,100 Tires: Based on historical average of fleet.41,751 46,864 51,924$ 57,829$ Repair Supplies‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 51,924 57,829 101‐43240‐2252,856$ 3,276$ Uniform/Rag Contract with G&K Services/Cintas150 150 Boot Allowance.‐ ‐ 3,006 3,426 ‐$ 300$ Tatems Sofware (Every Other Year)‐ 3,600 GPS Monitoring (20 Vehicles)‐ ‐ ‐ 3,900 400$ 400$ Citywide Safety Training Program & LMC Learn100 100 DOT inspection certification100 100 Tatems training600 600 1,500$ 1,500$ Two‐way radio service/scanning for fleet radios.1,000 1,000 Diagnostics1,500 2,500 Hydraulic/Cylinder repairs5,000 7,500 Major repairs 9,000 12,500 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. For 2022, staff is recommending budgeting for 27,000 gallons at $3.00/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.Staff has reviewed historical data, and based on the past history, we have seen the amount of repairs steadily increasing. 2014 total repairs of $17,789, 2015 repairs of $22,405, 2016 repairs of $25,325 and $30,720 for 2017 and $34,579 for 2018 and $38,588 for 2019 and $42,976 for 2020. The 2021 budget was also increased to keep up with this trend and so we have included the same increases for the 2022 budget. We have seen a steady increase of an average of 16.4 % for these expenses101‐43240‐220REPAIR/MAINT SUPPLIESUNIFORMS/CLOTHING ALLOWANCEFleet portion of the MMUA safety program, specialty training for other employees to operate Tatems fleet software.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 SERVICES39 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 45200 101 FULL‐TIME EMPLOYEES REGULAR 183,116$ 199,611$ 118,834$ 213,159$ 260,341$ Includes FT Hire (Based on April 2022 Hiring Timeline)101 45200 102 OVERTIME 9,924 6,746 2,312 5,000 6,000 101 45200 104 PART‐TIME ‐ EMPLOYEES REGULAR 29,971 8,058 19,338 33,760 25,200 Includes 3 Seasonal Staff (14 Week Positions @ 40 Hours)101 45200 121 PERA 14,300 15,471 9,226 16,362 19,976 101 45200 122 FICA AND MEDICARE 17,061 16,252 10,658 19,272 22,303 101 45200 130 OTHER EMPLOYER PAID INS 16,643 18,472 12,453 18,988 30,446 101 45200 150 WORKERS COMPENSATION 9,993 11,544 19,053 13,012 13,118 Based on Actual 2021‐2022 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES281,007 276,155 191,872 319,553 377,384 101 45200 201 OFFICE SUPPLIES AND EXPENSES 1,057 1,218 1,073 2,000 2,000 Drug Testing / Background Checks / Job Openings101 45200 210 OPERATING SUPPLIES 39,096 68,352 22,555 55,000 58,500 See Detailed Attachment101 45200 220 REPAIR/MAINT SUPPLY 22,692 10,863 8,223 21,000 25,000 See Detailed Attachment101 45200 225 UNIFORMS/CLOTHING ALLOWANCE 3,532 2,072 1,870 2,580 3,560 See Detailed Attachment101 45200 227 SAFETY SUPPLIES 424 1,490 378 1,300 1,500 101 45200 240 SMALL TOOLS/EQUIPMENT 3,461 1,700 814 3,000 3,000 Hand Tools/Weed Whips/Backpack Blowers/Power Tools/Etc.TOTAL ‐ SUPPLIES70,262 85,696 34,914 84,880 93,560 101 45200 315 GIS SERVICES‐ ‐ ‐ 1,000 1,000 Special Projects ‐ Midwest CAD101 45200 320 TELEPHONE4,337 2,386 1,211 2,540 3,100 Cell Phones ($30 x 5) + Tablet ($25) + Replacement Phones ($1,000)101 45200 322 UTILITIES37,575 41,102 23,724 37,000 41,000 Natural Gas / Electricity / Irrigation101 45200 355 DUES & MEMBERSHIPS1,539 673 1,723 1,430 1,580 See Detailed Attachment101 45200 360 EDUCATION/TRAINING/CONFERENCES3,267 8,658 1,382 8,200 8,600 See Detailed Attachment101 45200 361 LIABILITY AND PROPERTY INSURAN46,716 50,465 39,516 54,894 57,585 Based on Actual 2020‐2021 Premiums + 7% Inflation101 45200 390 CONTRACTED SERVICES21,711 21,886 12,137 24,300 26,300 See Detailed Attachment101 45200 410 RENTALS4,061 11,801 2,696 11,000 4,000 Decreased due to purchase of Toolcat in 2021101 45200 441 LICENSES, TAXES & FEES3,442 ‐ ‐ ‐ ‐ TOTAL ‐ SERVICES & OTHER CHARGES122,648 136,971 82,390 140,364 143,165 101 45200 501 EQUIPMENT4,620 4,046 4,325 5,300 5,000 Allowance for used Small Equipment and AttachmentsTOTAL ‐ CAPITAL OUTLAY4,620 4,046 4,325 5,300 5,000 DEPARTMENT TOTAL478,537$ 502,867$ 313,500$ 550,097$ 619,109$ Change ($)69,012 Change (%)12.55%45200 ‐ Park MaintenanceAccount Number40 City of OtsegoGeneral Fund Budget ‐ 2022Detail of Line Item RequestsRequestedBudget Budget2021 2022 Item Detail / Description Comment8,000$ 8,500$ Fertilizer & Herbicide6,000 9,000 Mulch3,000 3,000 Ballfield Paint5,000 5,000 Field Maintenance Supplies (Chalk, Aglime, Bases)10,000 10,000 Playground Woodchips15,000 15,000 Court Repair and Maintenance1,000 1,000 Dust Control Soccer Field7,000 7,000 Miscellaneous Supplies55,000 58,500 6,000$ 6,000$ Irrigation Maintenance 8,000 10,000 Playground Maintenance2,000 2,000 Splash Pad Maintenance5,000 7,000 Misc. Repairs (Shelters. Planters, Fencing)21,000 25,000 1,410$ 2,210$ Clothing (5 Fulltime Employees@ $400/ 3 Seasonal @ 70 )1,050 1,200 Boots (5 Fulltime + 3 Seasonal @ $150)120 150 Hats2,580 3,560 660$ 500$ MRPA ‐ Agency Membership600 700 MRPA ‐ (4) Professional Memberships170 180 National Recreation and Park Association Membership‐ 200 Greater Minnesota Parks & Trails1,430 1,580 1,300$ 1,700$ Citywide Safety Training Program & LMC Learn3,000 4,000 Parks Maintenance Trainings & Conferences1,400 1,400 Certification Classes2,500 1,500 Leadership & Supervisory Training8,200 8,600 14,000$ 14,000$ Portable Bathrooms9,000 11,000 Irrigation System Repairs & Maintenance1,300 1,300 Contingency ‐ Unidentified Services24,300 26,300 Increase of $3,000 in mulch due to the an increase in roundabouts and continued planter bed maintenance. Playground maintenance increasing due to aging of equipment.Account No. & Description101‐45200‐210OPERATING SUPPLIES101‐45200‐220REPAIR/MAINT SUPPLIES101‐45200‐225UNIFORMS/CLOTHING ALLOWANCE101‐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‐36041 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 45250 101 FULL‐TIME EMPLOYEES REGULAR 99,055$ 104,421$ 62,117$ 108,326$ 114,641$ 101 45250 102 FULL‐TIME ‐ OVERTIME 375 2,758 25 ‐ ‐ 101 45250 104 PART‐TIME EMPLOYEES REGULAR 25,683 9,123 11,069 20,000 25,000 101 45250 121 PERA 7,709 8,038 4,502 8,124 8,598 101 45250 122 FICA AND MEDICARE 9,194 8,435 5,427 9,817 10,683 101 45250 130 OTHER EMPLOYER PAID INS 14,759 16,167 10,809 16,428 18,381 101 45250 150 WORKERS COMPENSATION 3,357 4,009 6,722 4,656 4,596 Based on Actual 2021‐2022 Premiums + 3% InflationTOTAL ‐ PERSONAL SERVICES160,133 152,952 100,671 167,351 181,899 101 45250 201 OFFICE SUPPLIES AND EXPENSES 1,574 634 843 1,500 1,500 101 45250 210 OPERATING SUPPLIES 5,988 4,645 7,976 13,000 13,000 Program Implementation Supplies & Equipment101 45250 225 UNIFORMS 256 ‐ 832 650 650 See Detailed AttachmentTOTAL ‐ SUPPLIES7,819 5,279 9,651 15,150 15,150 101 45250 309 SOFTWARE & SUPPORT 3,430 1,202 985 4,350 5,100 See Detailed Attachment101 45250 320 TELEPHONE 623 821 655 360 360 Cell Phones ($30 x 1) + Replacement Phone (Last 2021 / Next 2023)101 45250 350 PRINT & PUBLISHING 5,104 8,617 2,118 5,500 5,500 See Detailed Attachment101 45250 355 DUES & MEMBERSHIPS1,230 1,176 805 1,200 950 See Detailed Attachment101 45250 360 EDUCATION/TRAINING/CONFERENCES682 732 356 3,400 3,500 See Detailed Attachment101 45250 361 LIABILITY AND PROPERTY INSURAN1,154 1,097 837 1,163 1,220 Based on Actual 2020‐2021 Premiums + 7% Inflation101 45250 390 CONTRACTED SERVICES6,908 4,059 3,868 5,500 5,500 Program Instructors & Facilities101 45250 445 COMMUNITY EVENTS20,408 11,828 4,435 20,000 23,000 See Detailed Attachment101 45250 490 PRAIRIE FESTIVAL21,392 6,525 1,225 19,865 26,321 See Detailed AttachmentTOTAL ‐ SERVICES & OTHER CHARGES60,931 36,058 15,284 61,338 71,451 DEPARTMENT TOTAL228,882$ 194,288$ 125,606$ 243,839$ 268,500$ Change ($)24,661 Change (%)10.11%45250 ‐ RecreationAccount Number42 City of OtsegoGeneral Fund Budget ‐ 2022Detail of Line Item RequestsRequestedBudget Budget2021 2022 Item Detail / Description Comment400$ 400$ 1 Fulltime Employee at $400250 250 Recreation & Building Staff Uniforms‐ ‐ 650 650 3,200$ 3,400$ RecDesk ‐ Online Registration Software700 700 Adobe Software450 1,000 Miscellanous Software4,350 5,100 500$ 500$ Printing of P&R Brochures2,200 5,000 Website & Flyer Design2,800 ‐ Brochure Mailings5,500 5,500 150 150$ MRPA ‐ (1) Professional Memberships725 725 Music Licensing250 ‐ Survey Monkey75 75 Minnesota Farmer's Market Association1,200 950 425$ 600$ Citywide Safety Training Program & LMC Learn2,500 2,500 MRPA Conference & Lodging / Meetings475 400 Other/Unidentified Training3,400 3,500 2,000$ 2,000$ Easter Egg Hunt2,000 2,000 Santa Day3,000 3,000 Pumpkin Patch5,000 5,000 Tuesday Entertainment3,000 5,000 Movies / Farmers Market / Touch‐A‐Truck5,000 6,000 Senior Programming20,000 23,000 2,500$ 2,500$ Bands750 600 Stage750 ‐ Sound4,500 6,000 Fireworks1,900 7,600 Petting Zoo & Jump Inflatables320 320 Potties1,650 1,800 T‐Shirts475 525 Website615 615 Insurance160 ‐ Prizes241 420 Plaques393 ‐ Mailings790 790 Generators2,300 2,800 Tent1,680 1,920 Advertising600 ‐ Staffing131 131 Volunteers110 300 Security19,865 26,321 Account No. & Description101‐45250‐225UNIFORMS/CLOTHING ALLOWANCE101‐45250‐350PRINT & PUBLISHING101‐45250‐360EDUCATION / TRAINING / CONFERENCE101‐45250‐309SOFTWARE & SUPPORT101‐45250‐355DUES & MEMBERSHIPSMiscellaneous 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.Survey Monkey accounted for in the Software & Support budget account.No longer mail brochures; therefore budget has been revised to better reflect increased design costs for electronic media.101‐45250‐490PRAIRIE FESTIVAL101‐45250‐445COMMUNITY EVENTS43 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 45300 104 PART‐TIME EMPLOYEES REGULAR 280$ 300$ ‐$ 480$ 840$ 5 Members + 2 Alternates ‐ 12 Meetings at $10 Per MeetingTOTAL ‐ PERSONAL SERVICES280 300 ‐ 480 840 101 45300 201 OFFICE SUPPLIES AND EXPENSES ‐ ‐ ‐ 500 500 TOTAL ‐ SUPPLIES‐ ‐ ‐ 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 TOTAL280$ 300$ ‐$ 2,480$ 2,840$ Change ($) 360 Change (%) 14.52%45300 ‐ Heritage Preservation CommissionAccount Number44 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 45350 104 PART‐TIME EMPLOYEES REGULAR ‐$ ‐$ ‐$ ‐$ 960$ 7 Members + Alternate ‐ 12 Meetings at $10 Per MeetingTOTAL ‐ PERSONAL SERVICES‐ ‐ ‐ ‐ 960 101 45350 360 EDUCATION/TRAINING/CONFERENCES ‐ ‐ ‐ ‐ 1,500 Event Registration for 2 CommissionersTOTAL ‐ SERVICES & OTHER CHARGES ‐ ‐ ‐ ‐ 1,500 DEPARTMENT TOTAL‐$ ‐$ ‐$ ‐$ 2,460$ Change ($) 2,460 Change (%) #DIV/0!45350 ‐ Parks and Recreation CommissionAccount Number45 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 46530 104 PART‐TIME EMPLOYEES REGULAR 1,500$ 1,550$ ‐$ 2,500$ 2,000$ 7 Members + Alternate ‐ 24 Meetings at $20 Per MeetingTOTAL ‐ PERSONAL SERVICES1,500 1,550 ‐ 2,500 2,000 101 46530 360 EDUCATION/TRAINING/CONFERENCES ‐ ‐ ‐ 1,500 1,500 Event Registration for 2 CommissionersTOTAL ‐ SERVICES & OTHER CHARGES ‐ ‐ ‐ 1,500 1,500 DEPARTMENT TOTAL1,500$ 1,550$ ‐$ 4,000$ 3,500$ Change ($) (500) Change (%) ‐12.50%46530 ‐ Planning CommissionAccount Number46 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 46570 303 PLANNING FEES 107,637$ 102,460$ 42,172$ 110,250$ 105,000$ Based on 2019 / 2020 Actuals & 2021 YTD Monthly AverageTOTAL ‐ SERVICES & OTHER CHARGES 107,637 102,460 42,172 110,250 105,000 DEPARTMENT TOTAL107,637$ 102,460$ 42,172$ 110,250$ 105,000$ Change ($) (5,250) Change (%) ‐4.76%46570 ‐ PlanningAccount Number47 City of OtsegoGeneral Fund Budget ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 46580 208 MEETING SUPPLIES 66$ ‐$ ‐$ 100$ 100$ TOTAL ‐ SUPPLIES66 ‐ ‐ 100 100 101 46580 309 SOFTWARE & SUPPORT 1,200 1,200 1,200 1,200 1,200 Website Link ‐ GreaterMSP Search Tool101 46580 339 DEVELOPMENT INCENTIVES ‐ 549,208 ‐ ‐ ‐ 101 46580 355 DUES & MEMBERSHIPS 3,398 3,048 3,448 3,560 3,560 See Detailed Attachment101 46580 360 EDUCATION/TRAINING/CONFERENCES 340 340 ‐ 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 4,938 561,788 11,021 15,360 15,360 DEPARTMENT TOTAL5,004$ 561,788$ 11,021$ 15,460$ 15,460$ Change ($) ‐ Change (%) 0.00%46580 ‐ Economic DevelopmentAccount Number48 City of OtsegoGeneral Fund Budget ‐ 2022Detail of Line Item RequestsEconomic DevelopmentRequestedBudget Budget2021 2022 Item Detail / Description Comment3,000$ 3,000$ Wright County Economic Development Partnership300 300 I‐94 West Chamber of Commerce260 260 Initiative Foundation3,560 3,560 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 ‐ 2022Department RequestsRequestedActual Actual Year‐to‐Date Budget BudgetFund Department Object Account Description 2019 2020 2021 2021 2022 Comments101 49300 720 OPERATING TRANSFERS 971,726$ 932,244$ ‐$ ‐$ ‐$ TOTAL ‐ INTERFUND TRANSFERS 971,726 932,244 ‐ ‐ ‐ DEPARTMENT TOTAL971,726$ 932,244$ ‐$ ‐$ ‐$ Change ($) ‐ Change (%) #DIV/0!49300 ‐ Interfund TransfersAccount Number50 ABCDEFGHIGrade1234567890 ‐ 93 1 38,595.52 39,656.89 40,747.46 41,868.01 43,019.38 44,202.41 45,417.98 46,666.98 47,950.32 94 ‐ 112 2 40,911.25 42,036.31 43,192.30 44,380.09 45,600.54 46,854.56 48,143.06 49,466.99 50,827.34 113 ‐ 131 3 43,365.92 44,558.48 45,783.84 47,042.90 48,336.58 49,665.83 51,031.64 52,435.01 53,876.98 132 ‐ 151 4 45,967.88 47,231.99 48,530.87 49,865.47 51,236.77 52,645.78 54,093.54 55,581.11 57,109.60 152 ‐ 173 5 48,725.95 50,065.91 51,442.72 52,857.40 54,310.98 55,804.53 57,339.15 58,915.98 60,536.17 174 ‐ 197 6 51,649.51 53,069.87 54,529.29 56,028.84 57,569.64 59,152.80 60,779.50 62,450.94 64,168.34 198 ‐ 223 7 54,748.48 56,254.06 57,801.05 59,390.57 61,023.82 62,701.97 64,426.27 66,198.00 68,018.44 224 ‐ 251 8 58,033.38 59,629.30 61,269.11 62,954.01 64,685.24 66,464.09 68,291.85 70,169.88 72,099.55 252 ‐ 281 9 61,515.39 63,207.06 64,945.25 66,731.25 68,566.36 70,451.93 72,389.36 74,380.07 76,425.52 282 ‐ 314 10 65,206.31 66,999.48 68,841.97 70,735.12 72,680.34 74,679.05 76,732.72 78,842.87 81,011.05 315‐ 350 11 69,118.69 71,019.45 72,972.49 74,979.23 77,041.16 79,159.79 81,336.69 83,573.45 85,871.72 351 ‐ 389 12 73,265.81 75,280.62 77,350.84 79,477.99 81,663.63 83,909.38 86,216.89 88,587.85 91,024.02 390 ‐ 431 13 77,661.76 79,797.46 81,991.89 84,246.66 86,563.45 88,943.94 91,389.90 93,903.12 96,485.46 432 ‐ 476 14 82,321.46 84,585.31 86,911.40 89,301.46 91,757.25 94,280.58 96,873.30 99,537.31 102,274.59 477 ‐ 521 15 87,260.75 89,660.42 92,126.09 94,659.55 97,262.69 99,937.41 102,685.69 105,509.55 108,411.06 522 ‐ 566 16 92,496.40 95,040.05 97,653.65 100,339.13 103,098.45 105,933.66 108,846.83 111,840.12 114,915.73 567 ‐ 614 17 98,046.18 100,742.45 103,512.87 106,359.47 109,284.36 112,289.68 115,377.64 118,550.53 121,810.67 615 ‐ 662 18 103,928.95 106,787.00 109,723.64 112,741.04 115,841.42 119,027.06 122,300.30 125,663.56 129,119.31 663 ‐ 710 19 110,164.69 113,194.22 116,307.06 119,505.50 122,791.91 126,168.68 129,638.32 133,203.38 136,866.47 711 ‐ 761 20 116,774.57 119,985.87 123,285.48 126,675.83 130,159.42 133,738.80 137,416.62 141,195.58 145,078.46 762‐ 812 21 123,781.05 127,185.02 130,682.61 134,276.38 137,968.99 141,763.13 145,661.62 149,667.31 153,783.16 813 ‐ 842 22 131,207.91 134,816.13 138,523.57 142,332.97 146,247.12 150,268.92 154,401.32 158,647.35 163,010.15 843 ‐ 886 23 139,080.38 142,905.09 146,834.98 150,872.95 155,021.95 159,285.06 163,665.39 168,166.19 172,790.76 DRAFT FOR BUDGET ‐ 2022 Pay Plan (3.00% COLA)Position PointsX:\Budget\2022\Wages and Benefits\Approved Pay Plan2022‐FT51 City of OtsegoPersonal Services Calculations2022 Budget20222022Calculated 7.50%7.65%TotalPositionRate 1Rate 2Hours WagesPERAFICABenefits CostsCity CouncilMayor and Council34,000 ‐ 2,601 ‐ 36,601 34,000 ‐ 2,601 ‐ 36,601 City AdministratorCity Administrator / Finance Director71.96 73.93 2,080 151,384 11,354 11,581 14,015 188,334 Intership17.00 480 8,160 ‐ 624 ‐ 8,784 159,544 11,354 12,205 14,015 197,118 AdministrationCity Clerk34.14 35.08 2,080 72,966 5,472 5,582 11,342 95,363 Deputy Clerk25.51 26.22 2,080 54,538 4,090 4,172 7,822 70,622 Administrative Assistant30.85 2,080 64,168 4,813 4,909 2,306 76,195 Overtime1,000 75 77 ‐ 1,152 192,672 14,450 14,739 21,470 243,332 FinanceAccountant37.91 38.95 2,080 79,033 5,927 6,046 13,863 104,869 Utility Billing30.85 2,080 64,168 4,813 4,909 2,306 76,195 Finance Assistant ‐ PT24.83 1,040 25,823 1,937 1,975 ‐ 29,735 Utility Billing ‐ PT24.83 1,040 25,823 1,937 1,975 ‐ 29,735 194,847 14,614 14,906 16,169 240,536 Human ResourcesHR / Assistant Administrator39.58 40.67 2,080 83,649 6,274 6,399 11,624 107,946 83,649 6,274 6,399 11,624 107,946 Building SafetyBuilding Permit Technician30.85 2,080 64,168 4,813 4,909 13,774 87,664 Administrative Assistant25.51 26.22 2,080 53,922 4,044 4,125 7,710 69,801 118,090 8,857 9,034 21,484 157,465 StreetsStreet Operations Manager49.37 2,080 102,690 7,702 7,856 13,997 132,244 Street Operations Foreperson36.74 2,080 76,419 5,731 5,846 13,718 101,715 Maintenance II32.70 2,080 68,016 5,101 5,203 8,052 86,372 Maintenance II30.15 30.97 2,080 62,996 4,725 4,819 7,055 79,595 Maintenance I28.32 1,872 53,015 3,976 4,056 718 61,765 Maintenance I26.32 27.05 2,080 55,758 4,182 4,265 7,086 71,291 Maintenance I23.43 24.07 2,080 49,511 3,713 3,788 649 57,661 Maintenance I23.43 1,213 28,428 2,132 2,175 8,034 40,769 Seasonal (12 Weeks @ 40 Hours)17.50 480 8,400 ‐ 643 ‐ 9,043 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 537,273 37,937 41,101 59,309 675,621 N/A for 2022 (new hire)N/A ‐ Already done for 2022.N/A for 2022 (new hire)N/A for 2022 (new hire)N/A ‐ At Max.N/A ‐ Already done for 2022.N/A ‐ At Max.N/A ‐ At Max.N/A ‐ At Max.N/A ‐ At Max.52 Fleet MaintenanceMechanic 27.90 28.67 2,080 58,299 4,372 4,460 13,773 80,904 Overtime2,000 150 153 ‐ 2,303 60,299 4,522 4,613 13,773 83,207 Parks MaintenanceParks & Recreation Director47.85 832 39,811 2,986 3,046 5,003 50,845 Lead Park Maintenance34.66 2,080 72,093 5,407 5,515 2,368 85,383 Park & Recreation Operations Coordinator28.55 29.34 2,080 60,616 4,546 4,637 7,172 76,972 Park & Recreation Operations Coordinator26.32 1,387 36,497 2,737 2,792 9,182 51,208 Park Maintenance I24.07 24.73 2,080 51,324 3,849 3,926 6,722 65,821 Seasonal (14 Weeks @ 40 Hours)15.00 560 8,400 ‐ 643 ‐ 9,043 Seasonal (14 Weeks @ 40 Hours)15.00 560 8,400 ‐ 643 ‐ 9,043 Seasonal (14 Weeks @ 40 Hours)15.00 560 8,400 ‐ 643 ‐ 9,043 Overtime6,000 450 459 ‐ 6,909 291,541 19,976 22,303 30,446 364,266 RecreationParks & Recreation Director47.85 1,248 59,717 4,479 4,568 6,754 75,518 Recreation Coordinator29.34 1,872 54,924 4,119 4,202 11,627 74,873 Part‐Time Recreation25,000 ‐ 1,913 ‐ 26,913 139,641 8,598 10,683 18,381 177,303 N/A for 2022 (new hire)N/A ‐ Already done for 2022.N/A ‐ Already done for 2022.N/A ‐ At Max.N/A ‐ Already done for 2022.53 City of OtsegoUtility Fund TransfersReimburse for Administrative Services2022 BudgetUtility Budgeted20222022Allocation Personal AllocationWater SewerDutiesPercentage ServicesAmountTransfer TransferGoverning BoardMayor & City CouncilDecision Making20.00% 36,601 7,320 City Administrator188,334 City Administrator Administrative Oversight & Review 15.00% 28,250 Finance Director Budgeting / Financial Reporting / Long‐Term Planning / Rates20.00%37,667 AdministrationCity ClerkCity Communications, Website, Records Retention15.00% 95,363 14,304 Deputy Clerk Council & Subcommittee Packets / Supplies Ordering 5.00% 70,622 3,531 FinanceAccountantAccounts Payable / Insurance20.00% 104,869 20,974 Utility Billing Billing / Customer Support / Meter Administration / Etc.100.00% 76,195 76,195 Utility Billing ‐ PTBilling / Customer Support / Meter Administration / Etc.100.00% 29,735 29,735 Human Resources107,946 HR Human Resources & Training (8 of 31 FT Employees) 25.81% 27,857 Assistant City Administrator Administrative Oversight & Review 5.00%5,397 ParksSeasonal ParksMowing at Water Towers, Pumphouses & Treatment Plants20.00% 27,128 5,426 DepartmentalFinanceAudit20.00% 30,450 6,090 Information TechnologyIT Services, Licenses & Supplies (8 of 31 FT Employees)25.81% 86,570 22,341 Human ResourcesSunshine Committee Events (8 of 31 FT Employees)25.81% 6,500 1,677 Rounding36 Totals286,800 71,700 215,100 Prior Year60,775 182,325 Change17.98% 17.98%Department & Position54