Loading...
HomeMy WebLinkAbout09-27-2021 Regular Meeting MEDINA CITY COUNCIL Monday, September 27, 2021 4:00 PM – REGULAR MEETING AGENDA VISION STATEMENT Medina is a family-friendly, diverse and inclusive community on the shores of Lake Washington. With parks and open spaces, Medina is a quiet and safe small city, with active and highly-engaged residents. Medina honors its heritage while preserving its natural environment and resources for current and future generations. MISSION STATEMENT Ensure efficient delivery of quality public services, act as responsible stewards of Medina's financial and natural resources, celebrate diversity, leverage local talent, and promote the safety, health, and quality of life of those who live, work, and play in Medina. 1 MEDINA, WASHINGTON MEDINA CITY COUNCIL CITY COUNCIL REGULAR MEETING Virtual/Online Monday, September 27, 2021 – 4:00 PM AGENDA MAYOR | Jessica Rossman DEPUTY MAYOR | Cythnia F. Adkins COUNCIL MEMBERS | Roger Frey, Jennifer Garone, Harini Gokul, Alex Morcos, Bob Zook CITY MANAGER | Michael Sauerwein CITY ATTORNEY | Scott Missall CITY CLERK | Aimee Kellerman Virtual Meeting Participation With the passage of the City’s Proclamation of Local Emergency, City Hall is closed to the public. Council participation in this meeting will be by teleconference/online only. Members of the public may also participate by phone/online. Individuals wishing to speak live during the Virtual City Council meeting will need to register their request with the City Clerk at 425.233.6411 or email akellerman@medina-wa.gov and leave a message before 2PM on the day of the September 27 Council meeting. Please reference Public Comments for September 27 Council Meeting on your correspondence. The City Clerk will call on you by name or telephone number when it is your turn to speak. You will be allotted 3 minutes for your comment and will be asked to stop when you reach the 3 minute limit. Join Microsoft Teams Meeting +1 360-302-2562 United States, Seattle (Toll) Conference ID: 647 612 757# 1. REGULAR MEETING - CALL TO ORDER / ROLL CALL Council Members Adkins, Frey, Garone, Gokul, Morcos, Rossman and Zook 2. APPROVAL OF MEETING AGENDA 3. PUBLIC COMMENT PERIOD Individuals wishing to speak live during the Virtual City Council meeting will need to register their request with the City Clerk at 425.233.6411 or email akellerman@medina- wa.gov and leave a message before 2PM on the day of the September 27 Council meeting. Please reference Public Comments for September 27 Council Meeting on your correspondence. The City Clerk will call on you by name or telephone number when it is your turn to speak. You will be allotted 3 minutes for your comment and will be asked to stop when you reach the 3 minute limit. 4. PRESENTATIONS 2 None. 5. CONSENT AGENDA None. 6. LEGISLATIVE HEARING None. 7. PUBLIC HEARING None. 8. CITY BUSINESS 8.1 Detailed review of 2022 Preliminary Budget Recommendation: NA Staff Contact: Julie Ketter, Finance & HR Director Time Estimate: 60 minutes 9. CITY MANAGER'S REPORT None. 10. REQUESTS FOR FUTURE AGENDA ITEMS AND COUNCIL ROUND TABLE 11. PUBLIC COMMENT Comment period is limited to 10 minutes. Speaker comments limited to one minute per person. 12. EXECUTIVE SESSION RCW 42.30.110(1)(i) To discuss with legal counsel representing the agency matters relating to agency enforcement actions, or to discuss with legal counsel representing the agency litigation or potential litigation to which the agency, the governing body, or a member acting in an official capacity is, or is likely to become, a party, when public knowledge regarding the discussion is likely to result in an adverse legal or financial consequence to the agency. 13. ADJOURNMENT Next regular City Council Meeting: October 11, 2021 at 4 PM. 3 ADDITIONAL INFORMATION Public documents related to items on the open session portion of this agenda, which are distributed to the City Council less than 72 hours prior to the meeting, shall be available for public inspection at the time the documents are distributed to the Council. Documents are available for inspection at the City Clerk's office located in Medina City Hall. The agenda items are accessible on the City’s website at www.medina-wa.gov on Thursdays or Fridays prior to the Regular City Council Meeting. In compliance with the Americans with Disabilities Act, if you need a disability-related modification or accommodation, including auxiliary aids or services, to participate in this meeting, please contact the City Clerk’s Office at (425) 233-6410 at least 48 hours prior to the meeting. UPCOMING MEETINGS Monday, October 11, 2021 - City Council Meeting (4:00 PM) Monday, October 25, 2021 - City Council Meeting (4:00 PM) Monday, November 8, 2021 - City Council Meeting (4:00 PM) Monday, November 22, 2021 - City Council Meeting (4:00 PM) Thursday, November 25, 2021 - Thanksgiving Holiday - City Hall Closed Friday, November 26, 2021 - Day After Thanksgiving Holiday - City Hall Closed Monday, December 13, 2021 - City Council Meeting (4:00 PM) Monday, December 27, 2021 - City Council Meeting (4:00 PM) CERTIFICATION OF POSTING AGENDA The agenda for September 27, 2021 Regular Meeting of the Medina City Council was posted and available for review on September 23, 2021 at City Hall of the City of Medina, 501 Evergreen Point Road, Medina, WA 98039. The agenda is also available on the city website at www.medina- wa.gov. 4 MEDINA, WASHINGTON AGENDA BILL Monday, September 27, 2021 Subject: Detailed review of 2022 Preliminary Budget Category: City Council Business Staff Contact: Julie Ketter, Finance & HR Director Summary This is the time of the year that Council and Staff review next year’s preliminary budget at the line-item detail level, AKA The Deep Dive. The goal is to familiarize Council with the staff- prepared 2022 preliminary budget using a study session style, to allow questions and discussion to flow more organically than can be accomplished in a more formal presentation form. As presented, the 2022 preliminary budget achieves the criteria outlined in the City’s long-term financial plan created as part of the Levy Lid Lift measure of 2019:  General Fund must have a minimum carryover balance of 25% at the end of the year.  Expense increases must be controlled in such a way to maintain fiscal sustainability of the City through at least 2029.  A minimum of $2M must be in the Levy Stabilization Fund by 2025; we are projected to have half of that amount saved by the end of 2022. This year, in addition to working through the traditional Big Spreadsheet, there will be special emphasis placed on notable changes over prior year:  CPI-W of 6/30/2021 (6.3%)--labor contract negotiated COLA “ceilings” vs. unrepresented employees  Pros & cons of carving Development Services out of General Fund into its own enterprise fund.  Resuming passport application acceptance services, likely as an early agency to reopen for this service. Due to extreme pent-up demand, it is anticipated that this action would make it impossible for existing staff to manage without severely reducing other community services. Recent research indicated the potential volume to be close to 23 times that of our busiest year, 2019. Staff has a plan that they would like to discuss with Council.  One-time revenues and one-time expenses: American Rescue Plan Act (ARPA), passport fees, PD cameras, etc. Attachment(s) -Budget Variances at a Glance, 2022 vs 2021 -2022 Consolidated Preliminary Budget, v1 5 AGENDA ITEM 8.1 Budget/Fiscal Impact: NA Recommendation: NA City Manager Approval: Proposed Council Motion: NA Time Estimate: 60 minutes 6 AGENDA ITEM 8.1 Budget Variances At A Glance, 2022 vs 2021 (+/- 5% & >20K) Amount Fund Account Less(-)/More(+) than prior year budget Notes General Sales tax $ 435,696 28.6%2% to 2021.07 ytd rolling 12 mos (+ passthru ARCH cont. from SHB1406, COM ord 985, $13,633 est) General Utility tax/Franchise fees $ 50,019 5.61%Based on 2021.07 ytd rolling 12 mos, +2% General Coronavirus Local Fis. Rec. (ARPA)$ 84,000 NA Allocate $28K x 3 yrs to COB CARES program, see PD expense. Remaining ARPA in Capital. General Passport & Naturalization Fees $ 396,117 5592%2022 one-time CS expense ($107,520) of temps for reopening passport services/offset with one-time revenue ($403,200), will discuss 9/27 General Contributions/Donations $ 100,000 NA Usually don't budget for this line item but staff has committed to collecting 25% community donations towards lic.plate reader camera system New DS Fund Development fees $ 445,433 48.9%Per Steve Wilcox, budget 12-mos rollback thru 7/2021. Adding 4% inflation. Prior year line items in General. Capital REET (Real Estate Excise Tax)$ 831,763 107%2021- Assume rolling 12 mos (July 2020-Aug 2021) with 15% reduction for potential market softening Capital Coronavirus Local Fis. Rec. (ARPA)458,919 NA 2nd half collection, one-time funding Capital Property II Levy (Parks)($ 50,000)-100%Deferring 2022 amt to 2023 for next segment of playground updating project Capital Roads Street CIP Improvements ($ 266,000)-100%2021 grant, not on-going source of revenue. Amount Fund Department Account Less(-)/More(+) than prior year budget Notes General Executive Professional Services $ 32,000 89%Consultants include $20K Prothman fee for recruiting to replace retiring Finance & HR Director. General Finance Total Compensation $ 61,479 22%+ 3 mos of new finance director training by current FD, currently assuming new hire at top of range + full family benefits but unlikely we will need to offer this General Finance Insurance (WCIA)-$ 9,393 -5%Liability rate increase (18.4%) per 7/30 WCIA notice. Property 4%; B&M 5-10%, Crime 5-10% & Auto 3% pending Oct BOD vote notice; less 15.56% alloc to DS, based on employee head-count. General Legal City Attorney ($ 56,000)-18.7%General fund expense decrease reflects DS fund allocation based on historical attny use. Total actual attny budget projected to remain flat. General Central Services Professional Services $ 112,020 640%+2022 one-time expense ($107,520) of temps for reopening passport services/offset with revenue ($403,200). General Central Services Building Maintenance $ 65,752 110%Per RO & MS, 9/9, increase =$45K for lights, paint & railing replacement General Central Services IT (multiple line items)($ 31,901)-8%Due to allocation of DS-related items to new fund. General Police Combined Wages & Benefits $ 125,178 6.4%2021 not yet reflecting seasonal OT budget amendment. 2022 increasing OT add'l $25K d/t more training requirements & "backlog" officer vacations. Newer officers now all eligible for merit pay (add'l $20K)---fully loading these items adds another $28K. General Police Repairs & Maint-Equipment $ 20,000 250%Additional for 2022 - $10K for 2 City Hall antennas & $10K for updated EM Repeater. General Police Capital Exp, Cameras $ 390,000 1300%$400K License plate camera replacement @ entry intersections; partially offset by donations as noted above. General Fire Fire Services $ 51,117 -6.6%2nd year in a row of decrease! Bellevue Fire is currently receiving other sources of revenue, decreasing the expense total passed along to contract cities. General Misc.Public Housing Services - ARCH $ 13,633 74%See sales tax revenue above General NA Transfers out $ 22,339 6%To Street Fund, add'l amount needed to possibly cover potential reduction of DOE grant fund. General NA Transfers out $ 1,000,000 NA To new DS Fund, starting fund balance. Represents refundable customer deposits of $600K (thru 8/31, will true up for actual transfer at 1/1/2022) + 1/3 of DS operating exps as carryover. New DS Fund Development Combined Wages & Benefits $ 30,858 5.4%3 of 4 FTEs eligible for step increases in addition to COLA New DS Fund Development Line items transferred from GF $ 171,817 NA DS portion of IT, Legal, Insurance, (recoverable) bank fees for customer credit card usage. New DS Fund Development Planning Consultant $ 20,000 40%Additional Planning Manager support needed due to comp plan update New DS Fund Development Vehicle $ 40,000 NA 2 oldest hand-me-down Tahoes disposed d/t increasing maintenance cost, purchase mini SUV (Ford Escape?), keep newest Tahoe as backup vehicle. Capital Projects Capital Projects Park Improvements ($ 50,000)-33%Deferring 2022 amt to 2023 for next segment of playground updating project, no projects planned for 2022 other than installation of delayed 2021 playground equip. Capital Projects Capital Projects Street Improvement - Overlays $ 340,000 -100%No overlays planned for 2022 Capital Projects Capital Projects Storm Drainage Improvements $ 950,000 1900%Shift of capital projects focus to aging/failing storm drain system. Approx 89% paid using ARPA funding. Capital Projects Capital Projects Sidewalk Improvements $ 110,000 39%NE 12th ST ADA & Sidewalk Repairs carry over from 2021 + undergrounding; *PSE partially funds UG - amount TBD REVENUES EXPENSES 7 AGENDA ITEM 8.1 Comparative Summary by Fund 2019 2020 2021 2021 2022 Minimum DESCRIPTION Actuals Actual Budget 2021 as of 6/30/21 Proposed Budget Fund Year End Carryover Balances GENERAL FUND 2022 BEGINNING FUND BALANCE 837,822$ 1,181,753$ 2,194,185$ 2,194,185$ 2,334,584$ Fund Balance REVENUES 6,816,529 7,983,720 7,909,764 4,816,187 8,255,623 Projected, Excess/(Shortfall) OPERATING TRANSFERS-IN - - - - $26 EXPENDITURES 6,432,598 6,601,288 6,892,234 3,238,229 6,772,674 OPERATING TRANSFERS-OUT 40,000 370,000 877,132 438,566 1,899,471 25% Policy Minimum (see note**) Year end carryover balance 1,181,753$ 2,194,185$ 2,334,584$ 3,333,577$ 1,918,062$ $1,918,036 STREET FUND 25.0% BEGINNING FUND BALANCE 17,469$ 16,031$ 13,778$ 13,778$ 14,890$ REVENUES 88,024 65,875 139,092 43,127 118,801 OPERATING TRANSFERS-IN 387,000 370,000 377,132 188,566 399,471 EXPENDITURES 476,461 438,128 515,112 212,690 518,272 OPERATING TRANSFERS-OUT Year end carryover balance 16,031$ 13,778$ 14,890$ 32,781$ 14,890$ DEV. SERVICES FUND BEGINNING FUND BALANCE -$ -$ -$ -$ -$ REVENUES - - - - 1,356,895 OPERATING TRANSFERS-IN - - - 1,000,000 EXPENDITURES - - - - 1,179,917 OPERATING TRANSFERS-OUT - - - - Year end carryover balance -$ -$ -$ -$ 1,176,978$ TREE FUND BEGINNING FUND BALANCE 139,689$ 113,572$ 110,072$ 110,072$ 75,147$ REVENUES 3,950 - 3,075 - 3,075 OPERATING TRANSFERS-IN - - - - EXPENDITURES 30,067 3,500 38,000 13,551 40,000 OPERATING TRANSFERS-OUT - - - - Year end carryover balance 113,572$ 110,072$ 75,147$ 96,521$ 38,222$ LEVY STABILIZATION FUND BEGINNING FUND BALANCE -$ -$ -$ -$ 500,000$ OPERATING TRANSFERS-IN -$ -$ 500,000$ 250,000$ 500,000$ OPERATING TRANSFERS-OUT -$ -$ -$ -$ -$ Year end carryover balance -$ -$ 500,000$ 250,000$ 1,000,000$ Must have min. of $2M by 12/31/2025 CAPITAL PROJECTS FUND BEGINNING FUND BALANCE 1,930,333$ 2,049,772$ 3,281,736$ 3,281,736$ 3,554,752$ REVENUES 1,420,455 1,841,084 1,113,016 - 2,086,618 OPERATING TRANSFERS-IN - - - - - EXPENDITURES 954,015 609,120 840,000 63,985 1,510,000 OPERATING TRANSFERS-OUT 347,000 - - - - Year end carryover balance 2,049,772$ 3,281,736$ 3,554,752$ 3,217,751$ 4,131,371$ CONTINGENCY FUND BEGINNING FUND BALANCE -$ -$ -$ -$ -$ REVENUES -$ -$ -$ -$ -$ OPERATING TRANSFERS-IN -$ -$ -$ -$ -$ OPERATING TRANSFERS-OUT -$ Year end carryover balance -$ -$ -$ -$ -$ TOTAL ALL FUNDS BUDGET BEGINNING FUND BALANCE 2,925,313$ 3,361,128$ 5,599,771$ 5,599,771$ 6,479,373$ REVENUES 8,328,957 9,890,679 9,164,947 4,859,314 10,464,117 OPERATING TRANSFERS-IN 387,000 370,000 877,132 188,566 899,471 EXPENDITURES 7,893,142 7,652,036 8,285,345 3,528,454 8,840,946 OPERATING TRANSFERS-OUT 387,000 370,000 877,132 438,566 1,899,471 Year end carryover balance 3,361,128$ 5,599,771$ 6,479,373$ 6,680,631$ 7,102,545$ Note: 2022 only, removed DS starting fund transfer from calc. Note: CPF balances do not include contractor retainage activity amounts Note: GF balances do not include SAO 2019 directive "fiduciary" amounts. 8.1 2022 Consolidated Prelim Budget, v1, attch 2 8 AGENDA ITEM 8.1 2021 2021 2022 2022 2019 2020 Adopted Actual Adopted Prelimiary Green = DS cost recovery amounts ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Comments from prior year, please update as needed: GENERAL FUND - REVENUES PROPERTY & SALES TAX 001 000 000 311 10 00 00 General Property Taxes 2,833,287 3,779,430 3,986,413 2,285,791 4,153,325 Includes 1% all'd increase + new constrct/improvmnts +levy lid lift portion at +5% 001 000 000 313 11 00 00 Local Retail Sales & Use Tax 1,374,390 1,587,383 1,522,354 953,026 1,958,050 2% to 2021.07 ytd rolling 12 mos (+ passthru ARCH cont. from SHB1406, COM ord 985, $13,633 est) 001 000 000 313 71 00 00 Criminal Justice Funding 101,857 93,472 90,080 50,376 100,283 Flat to 2021.07 ytd rolling 12 mos TOTAL PROPERTY & SALES TAX 4,309,534 5,460,285 5,598,847 3,289,193 - 6,211,658 10.95% BUSINESS & OCCUPATION-UTILITY TAX Util Tax 6% and Franchise Fees 4% 001 000 000 316 41 00 00 Electric - Puget Sound Energy 219,411 229,958 227,336 121,301 242,731 001 000 000 316 42 00 00 Gas - Puget Sound Energy 99,667 113,383 112,257 77,350 121,352 001 000 000 316 43 00 00 Water & Sewer 171,163 192,893 197,360 96,054 211,854 001 000 000 316 45 00 00 Garbage, Solid Waste 72,272 41,986 42,158 21,183 43,151 001 000 000 316 46 00 00 Cable - Comcast 109,071 80,749 82,115 38,982 80,177 001 000 000 316 47 00 00 Telephone - Mobile & landline 54,286 42,519 42,888 17,739 40,425 001 000 000 317 20 00 00 Leasehold Excise Tax 860 885 800 2,982 3,042 BUSINESS LICENSE/PERMITS-FRANCHISE FEES 001 000 000 321 91 00 00 Franchise Fees - Water/Sewer COB, Cable Comca 164,591 200,316 186,410 90,024 198,612 Assumes 4% Franchise Fee per Ord 895 of 11/30/2012 , applied as above TOTAL UTILITY TAX & FRANCHISE FEES 891,321 902,688 891,325 465,615 - 941,345 5.61% LICENSES & PERMITS 4XX 000 000 322 10 00 00 Building Permits 800,891 703,523 $577,164 562,553 XX Per Steve Wilcox, budget 12-mos rollback thru 7/2021. Adding 4% inflation 4XX 000 000 322 11 00 00 Building Permit - Technology Fee 10,131 9,324 $8,473 6,064 XX Per Steve Wilcox, budget 12-mos rollback thru 7/2021. Adding 4% inflation 001 000 000 322 30 00 00 Animal Licenses 470 515 699 320 640 Based on 2021.07 ytd annualized 001 000 000 322 90 00 00 Other Non Bus. Licenses & Permits (Gun Permits)651 407 353 600 652 Based on 2021.07 ytd annualized 001 000 000 322 91 00 00 Special Permits-Events, Other 150 207 355 - - Based on 2021.07 ytd annualized TOTAL LICENSES & PERMITS 812,293 713,975 $587,045 569,537 - 1,292 -99.78% INTERGOVERNMENTAL 001 000 000 332 92 10 00 COVID-19 Non-Grant Assistane (CARE)146,025 2020 one-time, unbudgeted revenue 001 000 000 332 92 10 01 Coronavirus Local Fis. Rec. (ARPA)84,000 Allocate $28K x 3 yrs to COB CARES program, see PD expense. Remaining ARPA in Capital. 001 000 000 333 16 00 00 Dept of Justice- Federal Grant Bullet Proof Vest 557 492 500 Based on one budgeted vest replacement, see PD exp 001 000 000 334 03 10 00 DOE Grant. Shoreline Master Program 7,973 XX E15-161 Grant , offset by Shoreline consultant costs S/B in street Multimodal Transportation - Cities 4,492 4,424 4,422 XX 2021: MRSC estimated distribution of State Shared Revenue, available late July 001 000 000 336 06 21 00 MVET-Criminal Justice-Pop.1,000 1,025 1,089 525 1,167 2021: MRSC estimated distribution of State Shared Revenue, available late July 001 000 000 336 06 26 00 Criminal Justice-Special 3,500 3,638 3,861 1,874 4,135 2021: MRSC estimated distribution of State Shared Revenue, available late July 001 000 000 336 06 51 00 DUI/Other Criminal Justice 452 472 259 001 000 000 336 06 94 00 Liquor Excise Tax 17,742 14,743 18,678 11,359 21,511 2021: MRSC estimated distribution of State Shared Revenue, available late July 001 000 000 336 06 95 00 Liquor Control Board Profits 21,162 25,406 26,070 10,432 25,980 2021: MRSC estimated distribution of State Shared Revenue, available late July 001 000 000 336 06 95 01 Liquor Control Board Profits-Public Safety Portion 5,290 6,352 2,608 2021: MRSC estimated distribution of State Shared Revenue, available late July 001 000 000 342 11 00 00 Hunts Point Police Contract- Add'l Police Serv 283,222 294,073 304,113 135,059 322,090 Based on 13.1% avg previous years of expense subtotal line TOTAL INTERGOVERNMENTAL 345,390 496,649 358,233 162,116 - 459,383 28.24% CHGS FOR GOODS AND SERVICES 001 000 000 341 99 00 00 Passport & Naturalization Fees 17,641 4,132 7,083 - 403,200 2022 one-time CS expense ($107,520) of temps for reopening passport services/offset with one-time revenue ($403,200) 4XX 000 000 345 81 00 00 Zoning & Subdivision Fees 75,184 45,010 $101,818 57,447 XX Per Steve Wilcox, budget 12-mos rollback thru 7/2021. Adding 4% inflation 4XX 000 000 345 89 00 00 Other Planning & Development Fees 183,150 136,998 $203,156 131,607 XX Per Steve Wilcox, budget 12-mos rollback thru 7/2021. Adding 4% inflation TOTAL CHGS FOR GOODS/SERVICES 275,975 186,140 312,057 189,054 - 403,200 29.21% FINES & FORFEITURES 001 000 000 353 10 00 00 Municipal Court-Traffic Infrac 9,649 15,231 11,250 6,237 15,000 Hx ratio of court costs (75%) to revenue 4XX 000 000 359 90 00 00 Misc. Fine, Penalties, Code 20,965 58,788 20,000 - XX Based on 2021.07 ytd rolling 12 mos, +2% 8.1 2022 Consolidated Prelim Budget, v1, attch 2 9 AGENDA ITEM 8.1 2021 2021 2022 2022 2019 2020 Adopted Actual Adopted Prelimiary Green = DS cost recovery amounts ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Comments from prior year, please update as needed: TOTAL FINES & FORFEITURES 30,614 74,019 31,250 6,237 - 15,000 -52.00% MISCELLANEOUS REVENUE 001 000 000 361 11 00 00 Investment Interest 15,416 7,562 10,274 3,412 6,000 Assumes LGIP and Bond Investments Interest, allocated between General Fund (25%) & Capital (75%)--- 2021.07 ytd annualized 001 000 000 361 40 00 00 Sales Interest 2,496 1,997 2,496 743 1,997 Based on 2020 actual 001 000 000 362 00 00 10 Wireless Commun. Facility Leases 21,890 22,546 22,546 23,223 23,223 2022 American Towers Corp. flat to 2021 001 000 000 362 00 00 20 Post Office Facility Lease 91,520 80,374 88,508 51,630 88,508 Lease of $7375.67/mo 001 000 000 367 11 00 00 Contributions/Donations 14,050 8,850 - 100,000 25% community donations towards lic.plate reader camera sx 001 000 000 369 30 00 10 Confiscated Property-Auction 1,371 - 200 - 001 000 000 369 91 00 00 Other 30 - 30 152 30 Based on 2019 actual 001 000 000 369 91 00 05 Other-CC Convience fees 3,043 3,224 3,000 16,521 XX Based on 2019 actual 001 000 000 369 91 00 10 Other-Copies 235 102 200 127 235 Based on 2019 actual 001 000 000 369 91 00 15 Other-Fingerprinting 590 72 590 50 590 Based on 2019 actual 001 000 000 369 91 00 35 Other-Notary 110 - 110 - 110 Based on 2019 actual 001 000 000 369 91 00 45 Other-Reports 53 44 53 27 53 Based on 2019 actual TOTAL MISCELLANEOUS REVENUES 150,803 124,771 128,007 95,884 - 220,745 72.45% DEBT PROCEEDS GENERAL OBLIGATION 001 000 000 391 10 00 00 Debt Proceeds General Obligation TOTAL DEBT PROCEEDS GENERAL OBLIGAT - - - - REFUNDABLE DEPOSITS (NOT REFLECTED IN BUDGET) 001 000 000 382 10 00 01 Refundable Deposits - DS (CMP, PGB)34,865 001 000 000 382 10 00 02 Refundable DS Adv Deposit 5,454 001 000 000 382 20 00 00 Refundable Retainage 40,319 - DISPOSITION OF CAPITAL ASSETS 001 000 000 395 10 00 00 Proceeds From Sales of Capital Assets 60 12,776 3,000 25 3,000 001 000 000 395 10 00 20 PD Equipment Sale/Repl. Funds 38,525 001 000 000 398 10 00 00 Insurance Recoveries 539 12,416 - TOTAL DISPOSITION OF CAPITAL ASSETS 599 25,192 3,000 38,550 - 3,000 OPERATING TRANSFERS 001 000 000 397 00 05 00 From Custodial (reclass in 2019 only)267,365 001 000 000 397 00 10 00 From Capital Projects Fund 001 000 000 397 00 40 00 From Reserves Fund TOTAL OPERATING TRANSFERS 267,365 - - - - TOTAL GENERAL FUND REVENUE 7,124,213 7,983,720 7,909,764$ 4,816,187 - 8,255,623$ 4.37% 8.1 2022 Consolidated Prelim Budget, v1, attch 2 10 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: GENERAL FUND - EXPENDITURES LEGISLATIVE SERVICES 001 000 000 511 60 41 00 Professional Services 001 000 000 511 60 41 01 Legislative Activities-Regional Intergovt 5,521 4,337 5,600 4,731 5,600 AWC ($1900), PSRC ($700), Eastside Transp.(?), Sound Cities ($2,001) 001 000 000 511 60 43 00 Travel & Training 225 6,615 6,000 1,957 6,000 AWC training, conferences, meals, and travel + CC retreat 001 000 000 511 60 49 00 Miscellaneous 3,993 1,079 2,000 (64) 2,000 Park Board, Planning Comm, Council misc meeting expenses 001 000 000 511 60 49 10 Medina Days 12,070 - 26,000 - 26,000 $10,000 Fireworks+ $5,000 barge, $1,000 sani-cans, $10,000 Medina's 67th Birthday(?) TOTAL LEGISLATIVE SERVICES 21,809 12,031 39,600 6,624 - 39,600 8.1 2022 Consolidated Prelim Budget, v1, attch 2 11 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: MUNICIPAL COURT 001 000 000 512 50 41 10 Prosecuting Attorney 52,000 44,000 48,000 24,000 48,000 $4K per month x 12 months 001 000 000 512 50 40 10 Municipal Court-Traffic/NonTrf 5,508 2,575 9,000 2,264 11,250 Required Service/Expenditure - Offset by Court Revenue TOTAL MUNICIPAL COURT 57,508 46,575 57,000 26,264 - 59,250 8.1 2022 Consolidated Prelim Budget, v1, attch 2 12 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: EXECUTIVE FTE's: 1 SALARIES & WAGES 001 000 000 513 10 11 00 Salaries & Wages 165,086 171,163 172,675 88,808 184,908 CPI-W=4% COLA-- See Salary Model for addl details 001 000 000 513 10 11 16 ICMA 457 Plan 7,179 7,157 7,200 3,571 7,200 TOTAL SALARIES & WAGES 172,265 178,320 179,875 92,378 - 192,108 7% PERSONNEL BENEFITS 001 000 000 513 10 21 00 Personnel Benefits 51,785 53,097 54,594 28,771 52,859 AWC Medical, Vision, DRS, Empl Security and L&I, Payroll Taxes TOTAL PERSONNEL BENEFITS 51,785 53,097 54,594 28,771 - 52,859 -3% OTHER SERVICES AND CHARGES 001 000 000 513 10 41 00 Professional Services 72,093 36,000 36,000 15,000 68,000 SR520 Consultant, cancelling eff. 1/1/2022 per MS (restored 9/7/21), + $22K Prothman f 001 000 000 513 10 43 00 Travel & Training - 121 4,000 632 4,000 WCIA and other training 001 000 000 513 10 49 01 Dues, Subscr.383 315 350 315 350 TOTAL OTHER SERVICES & CHARG 72,476 36,436 40,350 15,947 - 72,350 79% TOTAL EXECUTIVE DEPARTMENT 296,527 267,853 274,819 137,095.87 - 317,317 8.1 2022 Consolidated Prelim Budget, v1, attch 2 13 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: FINANCE DEPARTMENT FTE's: 1.7 + 3 mos of new finance director training by current FD SALARIES & WAGES 001 000 000 514 20 11 00 Salaries & Wages 168,418 191,234 199,948 99,871 242,004 CPI-W=4% COLA---see salary model notes 001 000 000 514 20 11 16 ICMA 457 Plan 8,973 9,835 10,200 5,056 11,700 Assumes full participation TOTAL SALARIES & WAGES 177,391 201,069 210,148 104,926 - 253,704 21% PERSONNEL BENEFITS 001 000 000 514 20 21 00 Personnel Benefits 40,383 47,039 50,279 25,179 76,307 AWC Medical, Vision, DRS, Empl Security and L&I, Payroll Taxes 001 000 000 514 20 21 17 Opt-Out Of Medical 13,289 14,579 16,022 7,943 7,917 TOTAL PERSONNEL BENEFITS 53,672 61,617 66,301 33,122 - 84,224 27% OTHER SERVICES & CHARGES 001 000 000 514 20 41 01 Professional Services 7,000 7,350 10,300 7,570 10,300 Vision PS, Finance/Financial System Support + HR updates,, etc 001 000 000 514 20 42 00 Intergvtml Prof Serv-Auditors 14,543 19,554 23,000 - 25,663 Added 5K for overruns based on 2020 activity + 2.65% per 8/31/2021 SAO notice 001 000 000 514 20 43 00 Travel & Training 233 311 2,000 140 2,000 PSFOA, Budgeting Workshop for DFD 001 000 000 514 20 46 00 Insurance (WCIA)181,234 176,720 185,734 186,167 176,342 Liability rate increase per 7/31 WCIA notice. Property 4%; B&M 5-10%, Crime 5-10% & Auto 3% pending Oct BOD vote notice less 15.56% alloc to DS 001 000 000 514 20 49 00 Misc-Dues,Subscriptions 75 35 500 600 250 WFOA, PSFOA, GFOA (Dues, Memberships), 001 000 000 514 20 49 10 Miscellaneous 11,246 10,044 15,000 18,245 11,000 Non DS Merchant credit card fees (offset by Revenue), Flex Spend Admin, Microflex, Tax/AP Forms, L&I, 001 000 000 514 40 40 00 Elections Serv-Voter Reg Costs 8,633 7,959 12,000 - 12,000 Election year costs (every other year is higher), 2022 keep to prior yr budget d/t potential for less KC cost share TOTAL OTHER SERVICES & CHARG 222,963 221,973 248,534 212,722 - 237,554 -4% TOTAL FINANCE DEPARTMENT 454,026 484,659 524,983 350,770 - 575,482 8.1 2022 Consolidated Prelim Budget, v1, attch 2 14 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: LEGAL DEPARTMENT FTE's: NA, contracted 4XX 000 000 515 41 40 00 City Attorney, Dev. Serv.New Fund allocation ($56K) 001 000 000 515 41 40 00 City Attorney 256,837 456,288 300,000 113,098 244,000 Per SM, hx avg of "routine legal service", "excluding itigation or highly contentious events"= $250K. JDK added $50K for "contentious", less $56K to DS budget 001 000 000 515 45 40 00 Special Counsel 16,173 7,956 60,000 12,440 60,000 HR and Labor Contract (3) Negotiation might spill into 2022 001 000 000 515 91 40 00 Public Defender 6,600 5,750 7,200 2,200 7,200 Required Service/Expenditure TOTAL LEGAL DEPARTMENT 279,610 469,994 367,200 127,738 - 311,200 8.1 2022 Consolidated Prelim Budget, v1, attch 2 15 AGENDA ITEM 8.1 2021 2022 2021 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: CENTRAL SERVICES FTE's: 3 SALARIES & WAGES 001 000 000 518 10 11 00 Salaries & Wages 242,335 252,693 257,765 128,256 277,857 CPI-W=4% COLA 1 non-rep employee + step increase; --see salary model notes for remaing staff 001 000 000 518 10 11 11 Longevity 4,365 4,452 4,544 2,223 4,953 001 000 000 518 10 11 14 Education 1,200 1,199 1,200 599 1,200 001 000 000 518 10 11 16 ICMA 457 Plan 5,997 5,992 12,000 2,993 12,000 Assumes participation full participation 001 000 000 518 10 11 17 Opt-Out of Medical 10,155 8,778 12,418 4,892 9,215 1 Employee participating in Opt-Out, same as 2021 001 000 000 518 10 12 00 Overtime - TOTAL SALARIES & WAGES 264,051 273,113 287,927 138,963 - 305,225 6% PERSONNEL BENEFITS 001 000 000 518 10 21 00 Personnel Benefits 103,020 105,586 108,461 53,279 108,181 AWC Medical, Vision, DRS, Empl Security and L&I, Payroll Taxes TOTAL PERSONNEL BENEFITS 103,020 105,586 108,461 53,279 - 108,181 0% 001 000 000 518 10 31 00 Office and Operating Supplies 10,768 21,817 22,000 5,925 27,000 City Hall Office and Operating Expenses, Konica Copier $7,200, Pitney Bowes $3,000 001 000 000 518 10 41 00 Professional Services 15,654 14,833 17,500 3,509 129,520 Proshred, Municode, Scanning services $10K, Avidex Chambers Support +2022 one-time expense ($107,520) of temps for reopening passport services/offset with revenue ($403,200). 001 000 000 518 10 42 00 Postage/Telephone 11,978 10,651 11,000 3,362 9,000 Postage (City Hall printing/mailing services); fax & credit card lines 001 000 000 518 10 43 00 Travel & Training 813 1,481 11,000 60 11,000 Training for clerk, Deputy Clerk/Admin Asst, ISC 001 000 000 518 10 44 00 Advertising 8,757 10,411 5,000 3,290 5,000 DS, CS legal advertisements 001 000 000 518 10 47 00 Utility Serv-Elec,Water,Waste 21,453 20,830 21,000 8,734 30,000 Calculated using 8/16/20 - 8/16/21 rolling 12 mos + 4% increase 001 000 000 518 10 48 00 Repairs & Maint-Equipment - - 500 800 500 office equipment repairs 001 000 000 518 10 49 10 Miscellaneous 7,145 790 2,800 1,193 1,500 Printer Svcs-Budget 001 000 000 518 10 49 20 Dues, Subscriptions 730 674 600 215 600 City Clerk and Deputy Clerk 001 000 000 518 10 49 30 Postcard, public information 13,505 6,048 4,000 1,473 4,000 Community mailings placeholder, monthly postcard discontinued 001 000 000 518 10 49 40 Photocopies 338 26 1,000 50 500 Most expenditures reflect pass through costs related to public records TOTAL OTHER SERVICES & CHARGES 91,140 87,561 96,400 28,610 - 218,620 127% BUILDING MAINTENANCE 001 000 000 518 30 45 00 Facility Rental 7,734 9,129 8,748 2,916 10,500 1 Public Storage Units (increased from v1 d/t rent notice) 001 000 000 518 30 48 00 Repairs/Maint-City Hall Bldg 49,331 64,980 51,000 31,823 115,000 $40k City Hall & PO cleaning Maint. $15k Beach/Park Bathroom cleaning (increased due to COVID), $10k HVAC Maint., Alarm/Fire Monitoring $2500, fire inspt, misc cleaning, bug service etc. ---# provided by Ryan Per RO & MS, 9/9, increase =$45K for lights, paint & railing replacement TOTAL BUILDING MAINTENANCE 57,065 74,109 59,748 34,739 - 125,500 110% 001 000 000 518 61 40 00 Judgements, settlements & jobbing - 116,420 001 000 000 518 80 31 00 IT HW, SW, Operating Supplies 5,343 41,991 1,500 19,387 1,500 Replacement mouse, keyboards, Data Center replacement battery, etc 001 000 000 518 80 41 50 Technical Services, Software Services 178,226 169,911 149,020 63,609 237,772 IT Placeholder $130,000 (less 15.56%= $20,228 for TIG DS allocation) for Maint, monitoring, helpdesk, incident support; $71K EmailSocial Media archive, GovDelivery, Municode Website hosting and Agenda Management, King County INET, DUO Access, Azure Storage, O365 Licenses, MS Teams Audio, GovQA PRR/Redactions/Invoicing Software, 8X8 Phone System, Dude Solutions Asset Management 001 000 000 518 80 48 00 Repairs & Maint: Annual Software Maint.12,187 11,201 40,991 4,800 14,500 VEEAM, NetApp, Cisco SmartNet, Avidex, Domain Name Renewal, Vision Application Suite, Cisco FirePower, Cisco Umbrella TOTAL INFORMATION TECHNOLOGY 195,756 223,102 191,511 87,796 - 253,772 33% SUBTOTAL CENTRAL SERVICES 711,033 996,313 744,047 343,387 - 1,011,298 DEBT SERVICE 001 000 000 591 18 71 00 LTGO Bond Loan Repayment - Principal 49,330 Post Office Year 3 Principal payment due 12/1/2019, per 1/2017 revised amtz schedule 001 000 000 592 18 83 00 LTGO Bond Loan Repayment - Interest 153 Post Office Year 3 Interest payment due 12/1/2019, per 1/2017 revised amtz schedule TOTAL DEBT SERVICE 49,482 - - - - - CAPITAL EXPENDITURES 001 000 000 594 14 64 00 City Hall - IT HW/SW >$5K Capital Outlay 70,713 63,048 197,592 72,232 103,430 HW Computer Replacements (10) $28,430, SW Records Management Placeholder $65,000, Bang the Table Community Engagement Placeholder $10,000 TOTAL CAPITAL EXPENDITURES 70,713 63,048 197,592 72,232 - 103,430 -48% TOTAL CENTRAL SERVICES 831,228 1,059,361 941,639 415,619 - 1,114,728 8.1 2022 Consolidated Prelim Budget, v1, attch 2 16 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: POLICE DEPARTMENT FTE: 11 SALARIES & WAGES 001 000 000 521 20 11 00 Salaries & Wages 1,103,178 1,129,182 1,185,251 571,257 1,195,655 CPI-W=4% COLA 2 non-rep employee; 3.5% CBA est COLA 2 employee; 4% CBA est ceiling COLA 7 employees 001 000 000 521 20 11 11 Longevity 12,345 16,000 23,025 9,285 22,481 001 000 000 521 20 11 14 Education 600 600 600 299 600 001 000 000 521 20 11 16 ICMA 457 Plan 52,240 48,120 55,506 23,560 56,285 Incl contr. at DRS rate 2 DRS ineligible (DRS ER rate reduced from previous yr) 001-000-000-521-20-11-17 Opt Out Medical 20,322 37,294 40,977 18,590 43,449 001 000 000 521 20 11 18 Night Shift Differential 10,118 10,735 14,868 5,545 15,204 Based on "average" week of coverage provided by Sergeant 001 000 000 521 20 12 00 Overtime 64,777 98,680 70,000 43,610 120,000 Training, vacation leave, non-funded special events (Medina Days/SeaFair/Shredder Day, etc.)+ summer emphasis patrols 001 000 000 521 20 12 01 Merit Pay 52,710 61,732 54,140 56,031 74,632 Paid Q1 of 2022 on 2021 earnings (reg + OT). 7/7 eligible 001 000 000 521 20 13 00 Holiday Pay 36,187 37,498 50,200 - 51,522 TOTAL SALARIES & WAGES 1,352,478 1,439,840 1,494,567 728,176 - 1,579,828 6% PERSONNEL BENEFITS 001 000 000 521 20 21 00 Personnel Benefits 433,003 386,595 404,813 193,488 432,764 Payroll taxes, Medical, Dental benefits,etc, less DRS/ICMA replacement above. 001 000 000 521 20 21 10 Personnel Benefits-Retirees 50,024 39,023 43,852 23,593 51,118 LEOFF 1 Medical plus Unum (+4%) + 12 mos rolling reimb(+10%) 001 000 000 521 20 22 00 Uniforms 4,433 14,023 7,000 4,580 7,000 Uniform replacement 001 000 000 521 20 22 01 DOJ Bullet Proof Vest Program 1,307 - 900 813 1,600 One vest replacement - external vest and covers 001 000 000 521 20 23 00 Tuition - 451 3,000 - 7,000 One officer collecting on tuition reimbursement TOTAL PERSONNEL BENEFITS 488,767 440,092 459,565 222,474 - 499,482 9% SUPPLIES 001 000 000 521 20 31 00 Office Supplies 4,900 16,033 9,000 5,301 11,000 Includes $3,000 for Emergency Preparedness 001 000 000 521 20 31 01 Off Equip, IT HW, SW <$5K 754 324 10,000 2,958 7,000 HW upgrades, normal operating costs 001 000 000 521 20 31 40 Police Operating Supplies 4,528 21,117 6,500 2,244 6,500 Taser cartridges, evidence processing equip, radio batteries, etc.; NARCAN replacement 001 000 000 521 20 31 60 Ammo/Range (Targets, etc.)6,839 12,743 8,500 - 9,000 Per ofc. contract and for training/firearms qualifications - ammo costs continue to increase 001 000 000 521 20 32 00 Vehicle Expenses-gas, car wash 23,134 17,063 26,000 9,432 26,000 Includes bridge tolls,vehicle tab renewals; fuel costs 001 000 000 521 20 35 20 Firearms (purchase & repair)1,937 1,360 1,500 (210) 1,500 TOTAL SUPPLIES 42,092 68,641 61,500 19,725 - 61,000 -1% OTHER SERVICES & CHARGES 001 000 000 521 20 41 00 Professional Services 3,190 3,672 5,000 711 4,000 001 000 000 521 20 41 50 Recruitment-Background 790 3,382 2,000 4,166 2,500 PST fees 001 000 000 521 20 42 00 Communications (Phone,Pagers)13,163 12,902 17,500 5,140 15,000 Cell phones and service, computer modems in patrol car, KC INET service. 001 000 000 521 20 43 00 Travel & Training 8,901 3,896 10,000 2,370 10,000 Ongoing training requirements, evidence officer certification, updated firearms instructor course, mandatory CJTC training req. 001 000 000 521 20 45 00 Equipment-Lease & Rentals 3,030 1,521 2,500 613 2,500 Copy machine 001 000 000 521 20 48 00 Repairs & Maint-Equipment 3,790 1,580 8,000 3,386 28,000 Additional for 2022 - $10K for 2 City Hall antennas & $10K for updated EM Repeater. $8,000 for maintain serviceable fire extinguishers, radar, property room software yearly maintenance fee of $2500, copier quarterly maintenance fee. 001 000 000 521 20 48 10 Repairs & Maint-Automobiles 13,149 6,446 8,500 3,515 8,500 001 000 000 521 20 48 20 Repairs & Maint- SW, HW Maint 26,418 20,185 30,000 6,713 30,000 Server Maintenance License, camera monthly fees, camera maintenance, IT maintenance cameras, electrical to each intersection 001 000 000 521 20 49 30 Animal Control - - 500 - 001 000 000 521 20 49 40 Dues,Subcriptions,Memberships 3,174 5,124 4,500 2,338 5,000 WSPC, IACP Professional Memberships 001 000 000 521 20 49 41 Lexipol Manuals 7,374 - 4,200 3,955 6,000 Yearly maintenance agreement per contract to Lexipol. Add'l for 2022 - PowerDMS needed for WASPC Accredidation Requirements 001 000 000 521 20 49 60 Crime Prevention/Public Educ 2,725 990 5,000 - 5,500 Increased Shredder Day costs, victim resource & crime prevention brochures, school resource materials. 001 000 000 521 20 49 90 Misc-Investigative Fund - TOTAL OTHER SERVICES & CHARG 85,704 59,698 97,700 32,908 - 117,000 20% INTERGOVERNMENTAL SERVICES 001 000 000 521 20 41 15 Dispatch Services-Norcom Trans 60,295 66,960 61,225 44,176 65,395 NORCOM - anticiapted amount 001 000 000 521 20 41 20 Dispatch-EPSCA 5,066 5,252 6,500 2,915 6,500 Per contract - cost to maintain 800 Mhz police radio connectivity 001 000 000 521 20 41 40 Marine Patrol Services 66,000 70,000 70,000 - 85,000 KC Sheriff or other jurisdiction anticiapted # TBD Bellevue CARE program 28,000 2022-2024 program offset by ARPA, $28K/yr 001 000 000 521 20 41 55 Jail Service-Prisoner Board 19,435 4,430 17,500 127 15,000 King County Jail/SCORE/Kirkland Jail 001 000 000 521 20 41 60 Prisoner Transport - - 500 500 Cost to shuttle prisoners from jail to court and back to jail 001 000 000 521 20 41 80 Domestic Violence-Kirkland 215 - 1,000 1,000 Mandated by court as resource to DV victims TOTAL INTERGOVERNMENTAL SER 151,011 146,642 156,725 47,218 - 201,395 29% 8.1 2022 Consolidated Prelim Budget, v1, attch 2 17 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: SUBTOTAL POLICE 2,120,051 2,154,913 2,270,057 1,050,500 - 2,458,705 8% CAPITAL OUTLAY 001 000 000 594 21 64 10 Surveillance Cameras - 30,000 420,000 2022 - $400K budgeted for camera upgrade/replacement - goal to get 25% of cost to be covered through community donations. 001 000 000 594 21 64 10 Police HW/SW, Equip >$5K Capital 4,040 53,767 3,500 2,809 4,500 Mandated mobile platform requirements 001 000 000 594 21 70 00 Police Vehicle Leasing, Princ. Cost 30,024 34,532 77,000 30,995 89,556 Vehicle leasing costs - increased leasing cost for three replacement pool police cars in 2022 (four year lease) and three leases expire in 2024 001 000 000 594 21 80 00 Police Vehicle Leasing, Int. Cost 7,322 7,718 8,775 TOTAL CAPITAL OUTLAY 41,386 96,017 110,500 42,580 - 514,056 365% TOTAL POLICE DEPARTMENT 2,161,438 2,250,929 2,380,557 1,093,079 - 2,972,761 8.1 2022 Consolidated Prelim Budget, v1, attch 2 18 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: FIRE & MEDICAL AID DEPARTMENT INTERGOVERNMENTAL SERVICES 001 000 000 522 20 41 00 Fire Control Services 811,588 817,367 777,954 388,977 726,837 001 000 000 522 20 41 00 Fire Control Services (LEOFF1 Liab.)31,654 30,000 30,000 TOTAL INTERGOVERNMENTAL 843,242 817,367 807,954 388,977 - 756,837 TOTAL FIRE & MEDICAL DEPT 843,242 817,367 807,954 388,977 - 756,837 -6.3% Updated 7/30/21 with COB notice received. LEOFF1 contract obligation 8.1 2022 Consolidated Prelim Budget, v1, attch 2 19 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: SOCIAL & ENVIRONMENTAL SERVICES SOCIAL SERVICES 001 000 000 551 10 40 00 Public Housing Services - ARCH 16,561 18,376 18,476 6,523 32,109 Same as prior year + pass-thru of "Affordable & Supp Housing" sales tax ($13,633 est) TOTAL SOCIAL SERVICES 16,561 18,376 18,476 6,523 - 32,109 ENVIRONMENTAL SERVICES 001 000 000 553 10 40 00 Land & Water Conservation Resources-King County - 1,925 4,000 001 000 000 553 70 40 00 Pollution Prevention-Puget Sound Clean Air Agency 9,835 9,964 9,953 9,953 9,582 Per notice rec'd 6.24.2021 TOTAL ENVIRONMENTAL SERVICES 9,835 9,964 11,878 9,953 - 13,582 MENTAL HEALTH SERVICES 001 000 000 564 60 40 00 Mental Health Services-KC Substance Abuse Fees 884 932 884 472 1,000 TOTAL SOCIAL & ENVIRONMENTAL SVCS 27,280 29,272 31,238 16,948 - 46,691 49% 8.1 2022 Consolidated Prelim Budget, v1, attch 2 20 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: RECREATION SERVICES (LIFEGUARDS AND BOYS & GIRLS CLUB) SALARIES & WAGES 001 000 000 571 00 10 00 Salaries & Wages 22,511 20,545 30,000 35,000 Anticipated hourly increase to stay competitive 001 000 000 571 00 11 00 Overtime - - 500 - TOTAL SALARIES & WAGES 22,511 20,545 30,500 - - 35,000 15% PERSONNEL BENEFITS 001 000 000 571 00 20 00 Personnel Benefits 2,955 2,562 4,720 4,200 001 000 000 571 00 30 00 Uniforms 1,555 1,339 2,000 1,238 2,000 TOTAL PERSONNEL BENEFITS 4,510 3,901 6,720 1,238 - 6,200 -8% SUPPLIES 001 000 000 571 00 31 00 Operating Supplies 1,207 4,303 001 000 000 571 00 32 00 Miscellaneous Lifeguard Expense 677 2,586 7,300 137 7,300 Increase to reimburse for lifeguard certifications after hire TOTAL SUPPLIES 1,884 6,888 7,300 137 - 7,300 0% OTHER SERVICES & CHARGES 001 000 000 571 00 40 00 Travel & Training 168 300 - 001 000 000 571 00 41 00 Recreation - Boys & Girls Club - TOTAL OTHER SERVICES & CHARG 168 - 300 - - - TOTAL RECREATION-LIFEGUARDS 29,073 31,335 44,820 1,375 - 48,500 8.1 2022 Consolidated Prelim Budget, v1, attch 2 21 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: FTE: 3 of 5 total allocated PARKS DEPARTMENT Public Works are split 60% Parks and 40% Streets SALARIES & WAGES 001 000 000 576 80 11 00 Salaries & Wages 249,689 254,246 265,275 131,975 398,218 271,732 CPI-W=4% COLA 1 non-rep employee; ---see salary model notes for remaining staff 001 000 000 576 80 11 11 Longevity 10,776 9,282 8,798 3,451 6,269 001 000 000 576 80 11 14 Education 3,238 3,835 4,680 1,877 3,840 001 000 000 576 80 11 16 ICMA 457 Plan 10,789 10,182 10,800 5,084 10,800 Assumes full participation 001 000 000 576 80 11 17 Opt-Out of Medical 13,240 9,935 11,034 5,304 16,323 001 000 000 576 80 11 00 Salaries & Wages, SEASONAL WORKERS 19,658 20,453 20,453 Unlikely to exceed 2021 budget d/t turnover 001 000 000 576 80 12 00 Overtime 4,679 2,998 3,236 4,331 3,236 Special Events:Medina Days, Seafair, Parkboard--# provided by Ryan + gross up TOTAL SALARIES & WAGES 312,069 290,478 324,276 152,022 398,218 332,653 3% PERSONNEL BENEFITS 001 000 000 576 80 21 00 Personnel Benefits 99,480 106,385 103,805 48,861 89,254 AWC Medical, Vision, DRS, Empl Security and L&I, Payroll Taxes 001 000 000 576 80 22 00 Uniforms 1,956 1,854 2,000 139 2,000 TOTAL PERSONNEL BENEFITS 101,436 108,239 105,805 49,000 - 91,254 -14% SUPPLIES 001 000 000 576 80 31 00 Operating Supplies 20,836 30,592 19,000 3,939 37,000 Garbage bags, toilet paper, fertilizer, bark, topsoil, Mutt Mitts, bathroom supplies, Purell sanitizer, light bulbs, paint, mower blades, irrigation parts, tennis court nets, gloves, ear plugs, eye protection. Add'l $16K 9/22 d/t WCIA audit compliance & $7500 for small tool additions for new in-house work. 001 000 000 576 80 32 00 Vehicle Fuel & Lube 4,689 3,093 5,000 1,820 5,000 Public Works equipment & vehicles TOTAL SUPPLIES 25,525 33,685 24,000 5,760 - 42,000 75% OTHER SERVICES & CHARGES 001 000 000 576 80 41 00 Professional Services 7,362 9,117 5,000 8,353 15,000 Arborist, irrigation repairs, engineeringBack-flow device testing, hazardous material disposal, fertilizing and spraying, $5K added 9/22 d/t WCIA audit compliance (electrician) 001 000 000 576 80 41 04 Professional Services-Misc 349 514 4,000 - 3,000 Debris disposal 001 000 000 576 80 42 00 Telephone/Postage 5,313 6,737 6,500 2,814 6,500 mobile phones, alarm/fire monitoring line, internet 001 000 000 576 80 43 00 Travel & Training 1,322 284 5,000 256 3,000 Pesticide training, flagger training, certifications, licenses, conferences, qtrly safety meetings, AE Training 001 000 000 576 80 47 00 Utilities 20,283 16,446 22,000 5,791 22,000 Utilities for public works shop and park restrooms, irrigation water, pond power 001 000 000 576 80 48 00 Repair & Maint Equipment 5,625 4,313 7,000 7,233 7,000 Backhoe, mowers,workman 001 000 000 576 80 49 00 Miscellaneous, annual lease 511 500 1,000 - 600 yearly lease for Shop Yard 001 000 000 576 80 49 01 Misc-Property Tax 192 324 200 265 300 KC Real Estate Tax (Noxious Weeds) TOTAL OTHER SERVICES & CHARGES 40,957 38,237 50,700 24,713 - 57,400 13% CAPITAL OUTLAY 001 000 000 594 76 30 00 Park Improvements 10,516 - *** see capital projects 001 000 000 594 76 00 00 Furniture and Equipment: Replacement - 7,000 7,000 Park Benches, Tables, Tennis Court Nets, Flags 001 000 000 594 76 64 00 Parks Capital Outlay >$5K - 8,268 231 TOTAL CAPITAL OUTLAY 10,516 8,268 7,000 231 - 7,000 0% TOTAL PARKS DEPARTMENT 490,504 478,907 511,781 231,726 398,218 530,307 8.1 2022 Consolidated Prelim Budget, v1, attch 2 22 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: OPERATING TRANSFERS From General Fund to: 001 000 000 597 00 30 00 Levy Stabilization Fund 500,000$ 250,000 500,000$ 001 000 000 597 00 30 00 Street Fund 40,000 370,000 377,132$ 188,566 399,471$ 4XX 000 000 597 00 30 00 Dev. Services 1,000,000 Starting Fund Balance, inlcuding $600K of cust deposits TOTAL TRANSFERS FROM GENERAL FUND 40,000 370,000 877,132 438,566 - 1,899,471 From Contingency Fund to: 302 000 000 597 00 01 02 Street Fund TOTAL TRANSFERS FROM CAP RESERVE FUND - - - - - From Capital Projects Fund to: 307 000 000 597 00 00 10 General Fund 307 000 000 597 00 00 30 Street Fund 347,000 - - TOTAL TRANSFERS FROM CAPITAL FUND 347,000 - - - - - TOTAL OPERATING TRANSFERS 387,000 370,000 877,132 438,566 - 1,899,471 8.1 2022 Consolidated Prelim Budget, v1, attch 2 23 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: DEVELOPMENT SERV. ENT. FUND, EST 2022 Transfer from Gen. Rev tab: 4XX 000 000 322 10 00 00 Building Permits $ 577,164 967,444$ Per Steve Wilcox, budget 12-mos rollback thru 7/2021. Adding 4% inflation 4XX 000 000 322 11 00 00 Building Permit - Technology Fee $ 9,324 11,112$ Per Steve Wilcox, budget 12-mos rollback thru 7/2021. Adding 4% inflation 4XX 000 000 334 03 10 00 DOE Grant. Shoreline Master Program $ - 25,000$ DOE SMP Grant , offset by Shoreline consultant costs 2021-2023 4XX 000 000 332 92 10 01 Zoning & Subdivision Fees $ 101,818 81,060$ Per Steve Wilcox, budget 12-mos rollback thru 7/2021. Adding 4% inflation 4XX 000 000 333 16 00 00 Other Planning & Development Fees $ 203,156 214,237$ Per Steve Wilcox, budget 12-mos rollback thru 7/2021. Adding 4% inflation 4XX 000 000 336 06 51 00 Misc. Fine, Penalties, Code $ 20,000 20,000$ 001 000 000 369 91 00 05 Other-CC Convience fees 33,042 Based on 2021 Jan -June annualized 4XX 000 000 395 10 00 00 Proceeds From Sales of Capital Assets 5,000$ Sale of 2 oldest Tahoes REVENUES $ 911,462 1,356,895$ OPERATING TRANSFERS 4XX 000 000 397 00 30 00 From General Fund (001)1,000,000 New Fund. Identified 2021 DS associated ending fund balance ini GF. TOTAL TRANSFER REVENUE - - - - - 1,000,000 Adv dep & other deposits thru 8/31 = $600K TOTAL DEV. SERV. ENT. FUND - - - - - 2,356,895 8.1 2022 Consolidated Prelim Budget, v1, attch 2 24 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: DEVELOPMENT SERVICES DEPT FTE's: 4 SALARIES & WAGES 4XX 000 000 558 60 11 00 Salaries & Wages 342,525 347,165 403,613 188,912 429,256 CPI-W=4% COLA 2 non-rep employees; 3.5% CBA est COLA 2 employees-----see salary model notes for step increase info 4XX 000 000 558 60 11 11 Longevity 1,459 361 - 4XX 000 000 558 60 11 14 Education - 766 1,200 599 2,700 4XX 000 000 558 60 11 16 ICMA 457 Plan 11,964 14,283 18,000 7,585 18,000 Assumes full participation 4XX 000 000 558 60 11 17 Opt-Out of Medical 12,194 2,183 - 4,482 5,061 TOTAL SALARIES & WAGES 368,142 364,758 422,813 201,578 - 455,017 8% PERSONNEL BENEFITS 4XX 000 000 558 60 21 00 Personnel Benefits 128,802 129,014 145,629 66,704 144,283 AWC Medical, Vision, DRS, Empl Security and L&I, Payroll Taxes 4XX 000 000 558 60 23 00 Tuition Reimbursement - - Possible for 2022? TOTAL PERSONNEL BENEFITS 128,802 129,014 145,629 66,704 - 144,283 -1% SUPPLIES 4XX 000 000 558 60 31 00 Operating Supplies 1,902 2 3,000 (37) 4,000 Estimate 4XX 000 000 558 60 32 00 Vehicle Expenses - Gas, Oil, Maint. 327 420 2,000 156 3,000 Vehicle is getting older and may require increasing repairs in addition to regular maintenance. TOTAL SUPPLIES 2,229 422 5,000 119 - 7,000 40% OTHER SERVICES & CHARGES 4XX 000 000 514 20 46 00 Insurance (WCIA)32,495 Liability rate increase per 7/31 WCIA notice. Property 4%; B&M 5-10%, Crime 5-10% & Auto 3% pending Oct BOD vote notice, allocated 15.56% from Finance 4XX 000 000 515 41 40 00 City Attorney, Dev. Serv.55,718 New Fund allocation 4XX 000 000 518 80 41 50 Technical Services, Software Services 20,228 IT Placeholder 15.56%= $20,228 for TIG DS allocation from CS for Maint, monitoring, helpdesk, incident support 4XX 000 000 558 60 41 00 Professional Services 79,192 48,062 80,000 51,325 90,000 Building plan review consultant with activity similar to 2021, and new public portal implementation. Fee study in 2023's budget? 4XX 000 000 558 60 41 01 Planning Consultant 52,377 - 50,000 12,698 70,000 Planning Manager support. Increasing use of consultant. New contract due 8/22 with 5% increase anticipated. 4XX 000 000 558 60 41 02 Hearing Examiner 26,803 16,243 20,000 1,530 3,500 Activity similar to 2021 4XX 000 000 558 60 41 06 Building Inspector Contract 34,625 26,513 7,000 - 7,000 Deputy Building Official performs inspections. $7,000 is contingency, vacations, etc. to cover 2-months 4XX 000 000 558 60 41 07 Engineering Consultant 93,971 80,077 98,000 69,305 100,000 Grading and drainage permit reviews, inspections, and other. Much of this expense is recovered through deposit reimbursement 4XX 000 000 558 60 41 08 Sound Testing Consultant $10,973 7,965 4,000 6,052 11,000 Most of this expense is recovered through fees. New contract due in 2022 with 5% increase anticipated. 4XX 000 000 558 60 41 50 Landscape Consultant 78,666 86,621 60,000 30,382 60,000 Tree Code and Landscape consultant. Much of this expense is recovered through deposit account reimbursement 4XX 000 000 558 60 41 55 Shoreline Consultant 3,975 - 5,000 - 5,000 Review by consulting shorelines specialist is needed on occasion 4XX 000 000 558 60 42 00 Communications 3,034 3,000 Expense added in 2022 due to DS having its own fund 4XX 000 000 558 60 43 00 Travel & Training 4,478 1,393 12,000 1,419 11,000 Four DS staff. $3500 each for Director and Planning Manager. $2000 each for Deputy Bldg. Off. and Dev. SVCS Coordinator 4XX 000 000 558 60 49 00 Dues, Subscriptions, Memberships 900 1,200 902 1,300 APA, AICP, WABO, ICC, WSPT, AWC Director. Estimate cost increase 4XX 000 000 558 60 49 10 Miscellaneous 33,042 Bank fees (offset with customer fees) 4XX 000 000 582 10 00 01 Refund of PGB/CMP Deposits (DS)41,865 Non-budget item 4XX 000 000 582 10 00 02 Refund of DS Adv Deposits 13,355 Non-budget item TOTAL OTHER SERVICES & CHARG 441,180 269,907 337,200 173,613 - 503,283 49% CAPITAL OUTLAY 4XX 000 000 594 58 64 00 Furniture & Equipment 4,950 4XX 000 000 594 XX XX XX Vehicle 40,000 4XX 000 000 594 60 64 00 DS- IT HW/SW >$5K Capital Outlay $30,334 Dude solutions (E-permitting $14K, portal $3500); BlueBeam (License $3500, Maintenance $984) Computer replacement for DSC, DBO & PM ($8550)---#'s from AK TOTAL CAPITAL OUTLAY - 4,950 - - - 70,334 TOTAL DEVELOPMENT SERVICES 940,353 769,051 910,642 442,013 - 1,179,917 8.1 2022 Consolidated Prelim Budget, v1, attch 2 25 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: CITY STREET FUND REVENUE INTERGOVERNMENTAL REVENUE DOE Sweeping Grant 19,000 80% reimbursement (thru 7/2021) 101 000 000 334 03 60 00 Nat'l Pollution Discharge Elim 19,610 12,368 50,000 12,198 50,000 NPDES DOE Grant ? 001 000 000 336 00 71 00 Multimodal Transportation - Cities 2,215 4,402 101 000 000 336 00 87 00 Motor Fuel Tax and MVA Transpo 68,413 59,775 70,092 28,715 64,399 2022: MRSC estimated distribution of State Shared Revenue, available late July TOTAL INTERGOVERNMENTAL 88,024 72,143 139,092 43,127 - 118,801 -15% OPERATING TRANSFERS 101 000 000 397 00 20 00 From Capital Reserves (302) 101 000 000 397 00 10 00 From General Fund (001)- 370,000 377,132 188,566 399,471 101 000 000 397 00 30 00 From Capital Projects Fund (307)347,000 - - Transfer from Capital Fund to Street Fund or REET1 eligible or unrestricted Capital TOTAL OPERATING TRANSFERS 347,000 370,000 377,132 188,566 - 399,471 6% TOTAL CITY STREET FUND 435,024 442,143 516,224 231,693 - 518,272 0% 8.1 2022 Consolidated Prelim Budget, v1, attch 2 26 AGENDA ITEM 8.1 2021 2021 2022 2022 2019 2020 Adopted Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: FTE: 2 of 5 total allocated CITY STREET FUND Public Works are split 60% Parks and 40% Streets SALARIES & WAGES 101 000 000 542 30 11 00 Salaries & Wages 166,459 169,496 176,850 87,984 181,155 CPI-W=4% COLA 1 non-rep employee; ---see salary model notes for remaining staff 101 000 000 542 30 11 11 Longevity 7,184 6,188 5,865 2,301 4,179 101 000 000 542 30 11 14 Education 2,159 2,557 3,120 1,251 2,560 101 000 000 542 30 11 16 ICMA 457 Plan 7,192 6,789 7,200 3,390 7,200 Assumes full participation 101 000 000 542 30 11 17 Opt-Out of Medical 8,826 6,163 7,080 3,536 10,882 101 000 000 542 30 11 00 Salaries & Wages (Seasonal Workers)13,106 1,999 13,636 13,636 Unlikely to exceed 2021 budget d/t turnover 101 000 000 542 30 12 00 Overtime 3,119 2,157 2,887 2,157 Special Events:Medina Days, Seafair, Parkboard--# provided by Ryan + gross up TOTAL SALARIES & WAGES 208,045 193,191 215,908 101,349 - 221,769 3% PERSONNEL BENEFITS 101 000 000 542 30 21 00 Personnel Benefits 66,342 70,809 69,204 32,468 59,503 AWC Medical, Vision, DRS, Empl Security and L&I, Payroll Taxes 101 000 000 542 30 22 00 Uniforms 1,563 1,562 2,000 - 2,000 TOTAL PERSONNEL BENEFITS 67,905 72,371 71,204 32,468 - 61,503 -14% ROAD & STREET MAINTENANCE 101 000 000 542 30 31 00 Operating & Maintenance Supplies 6,258 4,275 5,000 1,493 5,000 Storm drain pipe, catch basin grates, marking paint, gravel, cement, bark, roadside plantings REET1 eligible 101 000 000 542 30 35 00 Small Tools/Minor Equipment 4,686 4,377 4,000 817 4,000 power tools, mower parts, Pole Saw, Weedeater 101 000 000 542 30 41 00 Professional Services 49,441 51,430 54,000 25,626 54,000 84th Median & 24th Roadside Maint, 24th traffic Signal (shared Clydehill # netted), WRIA $2941 (7/27 notice) REET1 eligible 101 000 000 542 30 41 03 Prof Svcs- NPDES Grant 33,993 49,875 50,000 8,725 50,000 NPDES Requirements Grant $50k 101 000 000 542 30 41 10 Road & Street Maintenance 124 8,161 10,000 - 10,000 Pavement patching, pavement markings, sidewalk maintenance, curb repairs REET1 eligible 101 000 000 542 30 45 00 Machine Rental 603 90 1,000 611 2,000 ditch witch, compactor, compressor, manlift 101 000 000 542 30 47 00 Utility Services 857 622 1,000 454 1,000 Utility locates 101 000 000 542 30 48 00 Equipment Maintenance 7,285 6,579 7,000 3,071 7,000 PW vehicle and power equip repairs 101 000 000 542 40 41 00 Storm Drain Maintenance 37,326 5,256 15,000 5,985 15,000 Catch Basin Vactoring, Storm Line jetting, root cutting, camera 101 000 000 542 63 41 00 Street Light Utilities 21,755 21,471 22,000 9,571 22,000 PSE street light Power, REET1 eligible 101 000 000 542 64 41 00 Traffic Control Devices 3,849 10,916 10,000 5,702 10,000 Posts, reflective signs(Fed Req), barricades, cones 101 000 000 542 66 41 00 Snow & Ice Removal 160 680 1,000 - 1,000 Sand, ice melt 101 000 000 542 67 41 00 Street Cleaning 15,320 14,517 25,000 16,229 25,000 Street sweeping contracted service (DOE Grant til July 2021) 101 000 000 542 70 40 00 Street Irrigation Utilities 18,854 7,235 23,000 590 23,000 TOTAL ROAD & ST MAINTENANCE 200,511 185,484 228,000 78,873 - 229,000 0% CAPITAL OUTLAY 101 000 000 594 42 64 00 >$5,000 Equipment, HW & SW - 6,000 6,000 Asset Essentials Licensing (2021 didn't make it into rollup) TOTAL CITY STREET FUND 476,461 451,045 515,112 212,690 - 518,272 1% 8.1 2022 Consolidated Prelim Budget, v1, attch 2 27 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: TREE FUND REVENUE MISCELLANEOUS REVENUE 103 000 000 345 89 00 00 Other -Tree Replacement 3,075 3,075 - 3,075 Expecting only minimum fines 103 000 000 382 20 00 00 Refundable Retainage Deposits 875 TOTAL MISCELLANEOUS REVENUE 3,950 - 3,075 - - 3,075 TOTAL TREE FUND 3,950 - 3,075 - - 3,075 8.1 2022 Consolidated Prelim Budget, v1, attch 2 28 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: TREE FUND OTHER SERVICES & CHARGES 103 000 000 558 60 41 50 Professional Services 6,496 8,000 13,391 10,000 Consultant Arborist 103 000 000 558 60 49 10 Miscellaneous-Tree Replacement 23,572 4,332 30,000 160 30,000 Tree Plantings, Hazardous Tree Program TOTAL OTHER SERVICES & CHARG 30,067 4,332 38,000 13,551 - 40,000 TOTAL TREE FUND 30,067 4,332 38,000 13,551 - 40,000 8.1 2022 Consolidated Prelim Budget, v1, attch 2 29 AGENDA ITEM 8.1 Comparative Summary by Fund 2018 Budget 2021 2021 2022 2019 2020 Adopted Actual Prelimiary ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget CONTINGENCY FUND 302 000 000 397 00 01 00 From General Fund 302 000 000 361 11 00 00 Investment Interest Earnings - Total Capital Reserve Revenue - - - - - TOTAL RESERVE FUND - - - - - 30 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget YTD 6-30-21 Budget Budget Notes: LEVY STABLIZATION FUND OPERATING TRANSFERS 303 000 000 397 00 30 00 From General Fund (001)- - 500,000 250,000 500,000 New Fund, must have min. fund balance of $2M by 12/31/2025 TOTAL TRANSFER REVENUE - - 500,000 250,000 - 500,000 TOTAL LEVY STABILZATION FUND - - 500,000 250,000 - 500,000 8.1 2022 Consolidated Prelim Budget, v1, attch 2 31 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actual Budget YTD 6-30-21 Budget Budget Notes: CAPITAL PROJECTS FUND REVENUE TAXES 307 000 000 318 34 00 00 Real Estate Excise Tax 1 559,082 768,854 388,968 429,595 804,850 2021- Assume rolling 12 mos (July 2020-Aug 2021) with 15% reduction for potential market softening 307 000 000 318 35 00 00 Real Estate Excise Tax 2 559,082 768,854 388,968 429,595 804,850 TOTAL TAXES 1,118,165 1,537,708 777,936 859,190 - 1,609,699 87% 307 000 000 332 92 10 01 Coronavirus Local Fis. Rec. (ARPA)458,919 458,919 307 000 000 334 03 80 00 State Transp Improv Board Grant - Sidewalks 203,932 241,000 307 000 000 334 06 91 02 Property II Levy 26,964 49,965 50,000 KC Parks Levy, Nov 2019 went to ballot for renewal, passed, updated to reflect notice rec'd from KC of COM annual portion, deferring 2022 amt to 2023 for next segment of playground updating project 307 000 000 334 06 91 05 TIB-LED Streetlight Conversion Grants 31,337 TOTAL INTERGOVERNMENTAL 230,896 290,965 50,000 490,256 - 458,919 -6% 307 000 000 344 10 02 00 Roads Street CIP Improvements 20,000 - 266,000 - TOTAL TRANSPORTATION 20,000 - 266,000 - - 307 000 000 361 11 00 00 Investment Interest Earnings 46,249 14,044 19,080 5,118 18,000 Assumes LGIP and Bond Investments Interest, allocated between General Fund (25%) & Capital (75%)--- 2021.07 ytd annualized 307 000 000 367 00 00 00 Capital Project Donations - Non-Gov 5,145 564 307 000 000 382 20 00 00 Refundable Retainage Deposits 18,258 OPERATING TRANSFERS - IN 307 000 000 397 00 10 00 From General Fund to Capital - 307 000 000 397 00 04 00 From Custodial (relcass 2019 only)14,231 - 307 000 000 397 00 40 00 From Capital Reserve Fund to Capital - - - - - TOTAL TRANSFERS - - - - - - TOTAL CAPITAL PROJECTS FUND 1,452,943 1,842,717 1,113,016 1,355,128 - 2,086,618 8.1 2022 Consolidated Prelim Budget, v1, attch 2 32 AGENDA ITEM 8.1 2021 2022 2022 2019 2020 2021 Actual Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actual Budget YTD 6-30-21 Budget Budget Notes: CAPITAL PROJECTS FUND IMPROVEMENTS 307 000 000 594 18 60 00 Building Improvements 79,484 17,132 20,000 - 20,000 City Hall Painting, Rail replacement, Siding etc. 307 000 000 594 76 63 20 Park Improvements 79,489 81,823 150,000 10,107 100,000 Reappropriate 2021 amount for installation of playground d/t delivery delays. KC Grant = $NA, carry-over 2022's $50K allocation to 2023 Turf 307 000 000 595 30 63 01 Street Improvement - Overlays 515,098 152,160 340,000 539 * 307.000 000 595 30 63 02 Storm Drainage Improvements 45 36,493 50,000 31,748 **1,000,000 77th Ave NE to OGCC Drainage Imp, other flood risk projects, funds offset by ARPA ($890,735--net remaining after GF portion, see GF rev cell #36) 307 000 000 595 30 63 10 Sidewalk Improvements 279,899 380,898 280,000 21,590 ***390,000 NE 12th ST ADA & Sidewalk Repairs *carry over from 2021 + UG *PSE partially funds UG - amount TBD Retired account codes: 307 000 000 595 30 05 00 Overlake Drive East 307 000 000 595 30 60 00 Poplar Tree Removal/Replacement 307 000 000 595 30 63 12 Walkable Medina Project 307 000 000 595 30 63 18 Medina Park Ponds 307 000 000 595 90 11 00 Allocation of PW Director salary for project oversight TOTAL IMPROVEMENTS 954,015 668,505 840,000 63,985 - 1,510,000 TOTAL CAPITAL PROJECTS 954,015 668,505 840,000 63,985 - 1,510,000 Active Accounts, use category code for project # 8.1 2022 Consolidated Prelim Budget, v1, attch 2 33 AGENDA ITEM 8.1