Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2023 Final Budget
ORDINANCE NO.1014 CITY OF MEDINA, WASHINGTON AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF MEDINA WASHINTON ADOPTING A BUDGET FOR THE YEAR 2023, AND SETTING FORTH IN SUMMARY FORM THE TOTALS OF ESTIMATED REVENUES AND EXPENDITURES FOR EACH SEPARATE FUND AND THE AGGREGATE TOTALS FOR ALL SUCH FUNDS COMBINED AND ADOPTING THE 2023 SALARY SCHEDULE WHEREAS, State law requires the City to adopt a budget and provides procedures for the filing of a budget, deliberations, public hearings, and final fixing of the budget, and WHEREAS, a preliminary proposed budget for 2023 has been prepared and filed with the City Clerk, and WHEREAS, the City of Medina City Council held a public hearing on September 12 and October 10, 2022 to gather input as part of the 2023 budget process, and another public hearing on November 14, 2022 for the 2023 Property Tax Levy and the 2023 proposed budget, and deliberated and considered the preliminary proposed budget, and WHEREAS, the preliminary proposed final budget does not exceed the lawful limit of taxation allowed by law to be levied on the property within the City of Medina for the purposes and estimated expenditures set forth necessary to carry on the services and needs of the City of Medina for the calendar year 2023. NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF MEDINA, WASHINGTON, DO ORDAIN AS FOLLOWS: SECTION 1. In accordance with the provisions of R.C.W. 35A.33.075, the budget of the City of Medina, WA, for the year 2023, is approved on the 14th day of November after the notice of hearings and after the preliminary budget having been filed with the City Clerk as required by law. SECTION 2. Estimated resources for each separate fund of the City of Medina, and aggregate expenditures for all such funds for the year 2023 are set forth in a summary form below, and are hereby appropriated for expenditure at the fund level during the year 2023 as set forth in the 2023 Budget. Ordinance No. 1014 Page 1 of 3 General street Tree oev Serv, coutNgency capital Levy StabilimUon Total Fund Fund Fund Fund Fund Projects Fund AIIFunds Beginning Fund Balance S 3,147,161.53 S 91,871.08 $60,341.98 $ 936,927.95 S250,G00.00 S 6.102.796.97 $ 1,000,000.00 $11,589,099.51 Revenues S 7,818,758.58 $135,166.00 S 3,075.00 $1,007,53B.00 S - $ 1,253,264.54 $ - $10,217,812.12 Transfersln $ - $515,000.00 $ -U- $ - S - $ -0- $ 500,000.00 $ 1,015,000.00 Total Resources S 7,818,768.58 $650.166.00 S 3,075.00 S 1,007,538.00 $ - $ 1,253,264.54 $ 500.000.00 $11,232,812.12 Expenditures S 6,764,826.94 $642,802.84 $40,000.00 $1,013.296.76 S - $ 1.090.000.00 $ - $ 9,550,926.54 Transfers Out S 940,000.00 S -0- S -0- $ - $ - S 75,000.00 $ - $ 1,015,000.00 Total Uses $ 7,704,826.94 $642,80284 $ 40.000.00 $1,013,296.76 S - $ 1,165,000.00 $ - S 10,565,926.54 Entling Fund Balance S 3,261,103.17 S 99,234.24 $23,416.98 S 931,169.12 $250,000.00 S 6,191,061.51 S 1,500,000.00 S 12,255,985.09 SECTION 3. The 2023 Salary Schedule for authorized positions is attached as Attachment A and hereby adopted. SECTION 4. The City Clerk is directed to transmit a certified copy of the budget hereby adopted by reference to the Office of the Auditor of the State of Washington, Division of Municipal Corporation, and the Association of Washington Cities. Section 5. Corrections. The City Clerk and codifiers of the ordinance are authorized to make necessary corrections to this Ordinance including, but not limited to, the correction of scrivener/clerical errors, references, ordinance numbering, section/subsection numbers and any references thereto. Section 6. Severability. If any section, subsection, paragraph, sentence, clause or phrase of this Ordinance is declared unconstitutional or invalid for any reason, such invalidity shall not affect the validity or effectiveness of the remaining portions of this Ordinance. THIS ORDINANCE SHALL TAKE EFFECT AND BE IN FORCE ON AND AFTER THE 1 ST DAY OF JANUARY 2023. PASSED BY THE CITY COUNCIL OF THE CITY OF MEDINA ON THE 14 DAY OF NOVEMBER 2022 BY A VOTE OF X FOR, _ AGAINST, AND _ ABSTAINING, AND IS SIGNED IN AUTHENTICATION OF ITS PASSAGE THE 14TH DAY OF NOVEMBER, 2022. ssica Rossman, Mayor Approved as to form: Attest: n:rmgg. ilr-Olumarn Scott Missal, City Attorney Aimee Kellerman, City Clerk Ogden Murphy, LLC PUBLISHED: EFFECTIVE DATE: ORDINANCE NO.: Ordinance No. 1014 Page 2 of 3 City of Medina Ordinance Number 1014 Attachment A 2023 Salary Schedule The 2023 salary ranges for full time city employees shall be as follows (see notes in blue): Exempt Unrepresented Employees: COLA increase = CPI-W, capped at 4% FTE Minimum Midpoint Maximum Building Official 0 $8,225 $9,256 $10,284 Planning Manager 1 $8,225 $9,256 $10,284 Public Works Director 1 $9,479 $10,662 $13,032 Development Services Director 1 $9,479 $10,662 $13,032 Finance/HR Director 1 $9,479 $10,662 $11,848 City Clerk 1 $9,479 $10,662 $11,848 Police Chief 1 $11,676 $13,135 $14,592 City Manager 1 $11,963 $13,458 $16,025 Non Exempt Unrepresented Employees: COLA increase = CPI-W, capped at 4% FTE Minimum Midpoint Maximum Assistant Finance Director * 1 $6,291 $7,549 $8,806 Police Captain 1 $9,880 $11,113 $12,348 1,onecuve baraalnlna Aareement oetween t,1TV OT meama ana WTV OT meama vairoi UTTIcers: Police Guild Contract 5% COLA Increase FTE Step A Step B Step C Step D Patrol Officer A $7,432 $7,869 $8,305 $8,745 Patrol Officer B $7,522 $7,959 $8,393 $8,834 Patrol Officer C 2 $7,695 $8,133 $8,570 $9,006 Patrol Officer D 4 $7,869 $8,305 $8,746 $9,182 Police Sergeant A 1 $8,757 $9,233 $9,722 $10,220 Police Sergeant B $8,931 $9,407 $9,896 $10,395 Public, Professional and Office -Clerical Employees Union, Local 763 (Representing Public Works Employees): Teamsters Guild Contract 4% COLA Increase FTE Step A Step B Step C Step D Maintenance Worker 3 $5,818 $6,064 $6,406 $6,759 Maintenance Supervisor 1 $7,078 $7,471 $7,872 $8,292 Public, Professional and Office -Clerical Employees Union, Local 763 (Representing Office -Clerical Employees): Teamsters Guild Contract 4% COLA Increase FTE Step A Step B Step C Step D Admin. Assistant -Deputy Clerk 1 $5,818 $6,064 $6,406 $6,759 Information Systems Coordinator 1 $5,818 $6,064 $6,406 $6,759 Police Administrative Specialist 1 $5,818 $6,064 $6,406 $6,759 Development Svcs Coordinator 1 $5,936 $6,115 $6,439 $6,778 Dpty Blding Official 1 $6,310 $7,151 $7,992 $8,832 Police Office Manager 1 $7,078 $7,471 $7,872 $8,292 = position currently filled with part-time employee with salary pro -rated at 0.7 FTE :OUNT NUMBER DESCRIPTION GENERAL FUND - REVENUES PROPERTY & SALES TAX 000 000 311 10 00 00 General Property Taxes 000 000 313 11 00 00 Local Retail Sales & Use Tax 000 000 313 71 00 00 Criminal Justice Funding TOTAL PROPERTY & SALES TAX BUSINESS & OCCUPATION -UTILITY TAX 000 000 316 41 00 00 Electric - Puget Sound Energy 000 000 316 42 00 00 Gas - Puget Sound Energy 000 000 316 43 00 00 Water & Sewer 000 000 316 45 00 00 Garbage, Solid Waste 000 000 316 46 00 00 Cable - Comcast 000 000 316 47 00 00 Telephone - Mobile & landline 000 000 317 20 00 00 Leasehold Excise Tax BUSINESS LICENSE/PERMITS-FRANCHISE FEES 000 000 321 91 00 00 Franchise Fees - Water/Sewer COB, Cable Comcast TOTAL UTILITY TAX & FRANCHISE FEES LICENSES & PERMITS 000 000 322 30 00 00 Animal Licenses 000 000 322 90 00 00 Other Non Bus. Licenses & Permits (Gun Permits) 000 000 322 91 00 00 Special Permits -Events, Other TOTAL LICENSES & PERMITS INTERGOVERNMENTAL 000 000 332 92 10 00 COVID-19 Non -Grant Assistane (CARE) 000 000 332 92 10 01 Coronavirus Local Fis. Rec. (ARPA) 000 000 333 16 00 00 Dept of Justice- Federal Grant in street Multimodal Transportation - Cities 000 000 336 06 21 00 MVET-Criminal Justice -Pop. 000 000 336 06 26 00 Criminal Justice -Special 000 000 336 06 51 00 DUI/Other Criminal Justice 000 000 336 06 94 00 Liquor Excise Tax 000 000 336 06 95 00 Liquor Control Board Profits 000 000 336 06 95 01 Liquor Control Board Profits -Public Safety Portion 000 000 342 11 00 00 Hunts Point Police Contract- Add'I Police Sery CHGS FOR GOODS AND SERVICES 000 000 341 99 00 00 Passport & Naturalization Fees TOTAL CHGS FOR GOODS/SERVICES FINES & FORFEITURES 000 000 353 10 00 00 Municipal Court -Traffic Infrac TOTAL FINES & FORFEITURES MISCELLANEOUS REVENUE 000 000 361 11 00 00 Investment Interest 000 000 361 40 00 00 Sales Interest 2021 2021 2022 2023 2019 2020 Adopted Year-end Adopted Preliminary Actuals Actuals Budget Final Budget Budget 4,318,656 Comments from prior year, please update as needed: 2,833,287 3,779,430 3,986,413 3,991,758 4,167,873 ♦3.62 % Includes 1 % all'd increase + new constrct/improvmnts +levy lid lift portion at +5%, Waiting on KC worksheet 1,374,390 1,587,383 1,522,354 1,999,429 1,958,050 1,870,785 ♦4.46% 2% to 2022.07 ytd rolling 12 mos (+ passthru ARCH cont. from SHB1406, COM ord 985, $13,633 est) 101,857 93,472 90,080 103,943 100,283 98,782 6,288,223 ♦ 1.50% Flat to 2022.07 ytd rolling 12 mos 4,309,534 5,460,285 5,598,847 6,095,130 6,226,206 ♦1.00% Util Tax 6% and Franchise Fees 4% 219,411 229,958 227,336 219,596 242,731 232,783 ♦4.10% 99,667 113,383 112,257 142,197 121,352 125,000 ♦3.01% 171,163 192,893 197,360 310,018 211,854 200,000 ♦5.60% Based on 2022.07 ytd rolling 12 mos, +2% 72,272 41,986 42,158 43,156 43,151 40,000 ♦7.30% 109,071 80,749 82,115 90,778 80,177 82,000 ♦2.27% 54,286 42,519 42,888 33,333 40,425 37,854 ♦6.36% 860 885 800 911 3,042 6,589 ♦116.61% 164,591 200,316 186,410 106,384 198,612 180,000 904,226 ♦9.37% Assumes 4% Franchise Fee per Ord 895 of 11/30/2012 , applied as above 891,321 902,688 891,325 946,373 941,345 ♦3.94% 470 515 699 790 640 400 ♦37.50% Based on 2022.07 ytd annualized 651 407 353 682 652 650 ♦0.31% Based on 2022.07 ytd annualized 150 207 355 - - 1,050 Based on 2022.07 ytd annualized 1,271 1,129 $1,407 1,472 1,292 ♦18.73% 146,025 84,000 56,000 ♦33.33% Allocate $28K x 3 yrs to COB CARES program, see PD expense. Remaining ARPA in Capital. 557 492 407 500 ♦ 100.00% Based on one budgeted vest replacement, see PD exp 4,492 4,424 4,422 - XX 2022: MRSC estimated distribution of State Shared Revenue, available late July 1,000 1,025 1,089 1,055 1,167 1,049 ♦10.11% 2022: MRSC estimated distribution of State Shared Revenue, available late July 3,500 3,638 3,861 3,739 4,135 3,702 ♦ 10.47% 2022: MRSC estimated distribution of State Shared Revenue, available late July 452 472 523 17,742 14,743 18,678 22,311 21,511 19,997 ♦7.04% 2022: MRSC estimated distribution of State Shared Revenue, available late July 21,162 25,406 26,070 20,858 25,980 22,300 ♦ 14.16% 2022: MRSC estimated distribution of State Shared Revenue, available late July 5,290 6,352 5,215 2022: MRSC estimated distribution of State Shared Revenue, available late July 283,222 1 294,0731 304,113 1 287,063 1 319,874 1 1 338,353 1 441,401 1 ♦5.78% Based on 13.1% avg previous years of expense subtotal line 337,4171 496,6491 358,233 1 341,170 1 457,16 1 ♦3.45% 17,641 4,132 7,083 403,200 5,000 V98 76 % Passport Revenue From 2022 was overstated, plan was to have full time temp team to handle overflow 17,641 4,132 312,057 - 403,200 5,000 ♦98.76% 9,649 15,231 11,250 12,661 15,000 18,000 ♦20.00% Hx ratio of court costs (75%) to revenue 9,649 15,231 31,250 12,661 15,000 18,000 ♦20.00% 15,416 7,562 10,274 5,853 6,000 46,800 ♦680.00% Assumes LGIP and Bond Investments Interest, allocated between General Fund (40%) & Capital (60%)--- 2022.( 2,496 1,997 2,496 1,200 1,997 1,200 ♦39.90% Based on 2021 actual 2023 Final Budget Detail 2019 :OUNT NUMBER DESCRIPTION Actuals 2020 Actuals 2021 Adopted Budget 2021 Year-end Final 2022 Adopted Budget 2023 Preliminary Budget 23,223 Comments from prior year, please update as needed: 000 000 362 00 00 10 Wireless Commun. Facility Leases 21,890 22,546 22,546 23,223 23,223 2023 American Towers Corp. flat to 2022 000 000 362 00 00 20 Post Office Facility Lease 91,520 80,374 88,508 88,508 88,508 88,508 ♦ 0.00 % Lease of $7375.67/mo 000 000 367 11 00 00 Contributions/Donations 14,050 8,850 - 100,000 ♦ 100.00% In 2023 we are not planning on asking for Community Donations 000 000 369 30 00 10 Confiscated Property -Auction 1,371 - 200 - 000 000 369 91 00 00 Other 30 - 30 152 30 150 ♦403.02% Based on 2022 Budget 000 000 369 91 00 10 Other -Copies 235 102 200 253 235 235 ♦O.00% Based on 2022 Budget 000 000 369 91 00 15 Other -Fingerprinting 590 72 590 430 590 590 ♦O.00% Based on 2022 Budget 000 000 369 91 00 35 Other -Notary 110 - 110 - 110 110 AO 00% Based on 2022 Budget 000 000 369 91 00 45 Other -Reports 53 1 441 53 1 51 1 53 1 160,869 Based on 2022 Budget TOTAL MISCELLANEOUS REVENUES 147,761 1 121,5471 128,007 1 119,669 1 220,745 ♦27.12 DEBT PROCEEDS GENERAL OBLIGATION 001 000 000 391 10 00 00 Debt Proceeds General Obligation TOTAL DEBT PROCEEDS GENERAL OBLIGATION REFUNDABLE DEPOSITS (NOT REFLECTED IN BUDGET) 001 000 000 382 20 00 00 Refundable Retainage DISPOSITION OF CAPITAL ASSETS 001 000 000 395 10 00 00 Proceeds From Sales of Capital Assets 60 12,776 3,000 13,650 3,000 ♦ 100.00% TOTAL DISPOSITION OF CAPITAL ASSETS 599 25,192 3,000 54,871 3,000 ♦ 100.00% OPERATING TRANSFERS 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 5,982,558 7,026,854 $ 7,909,764 7,571,346 $ 8,267,955 $ 7,818,769 ♦5.43% 2023 Final Budget Detail 2021 2022 2023 2019 2020 2021 Year-end Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget Final Budget Budget Notes: GENERALFUND- EXPENDITURES LEGISLATIVE SERVICES 001 000 000 511 6041 00 Professional Services 001 000 000 511 6041 01 Legislative Activities -Regional Intergovt 5,521 4,337 5,600 4,831 5,600 6,500 ♦ 16.07% AWC ($1900), PSRC ($700), Eastside Transp.(?), Sound Cities ($2,001) 001 000 000 511 60 43 00 Travel & Training 225 6,615 6,000 6,991 6,000 10,000 ♦66.67% AWC training, conferences, meals, and travel + CC retreat 001 000 000 511 60 49 00 Miscellaneous 3,993 1,079 2,000 255 2,000 2,000 ♦0.00% Park Board, Planning Comm, Council misc meeting expenses 001 000 000 511 60 49 10 Medina Days 12,070 - 26,000 343 26,000 52,000 ♦ 100.00 %1 $40,000 Fireworks+ $10,000 barge, $2,000 sani-cans (Finance Committee reccomendation, promissed with Levy Lift) TOTAL LEGISLATIVE SERVICES 21,809 12,031 39,600 1 12,4211 39,600 70,500 ♦78.03% 2023 Final Budget Detail 2021 2022 2023 2019 2020 2021 Year-end Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget Final Budget Budget Notes: MUNICIPAL COURT 001 000 000 512 50 41 10 Prosecuting Attorney 52,000 44,000 48,000 52,000 48,000 48,000 ♦0.00% $4K per month x 12 months 001 000 000 512 50 40 10 Municipal Court-Traffic/NonTrf 5,508 2,575 9,000 6,889 11,250 14,000 ♦24.44% Required Service/Expenditure - Offset by Court Revenue TOTAL MUNICIPAL COURT 57,508 46,575 57,000 58,889 59,250 1 62,000 ♦4.64% 2023 Final Budget Detail 2021 2022 2023 2019 2020 2021 Year-end Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget Final Budget Budget Notes: EXECUTIVE FTE's: 1 SALARIES & WAGES 001 000 000 513 10 11 00 Salaries & Wages 165,086 171,163 172,675 214,438 184,908 187,200 ♦ 1.24 % CPI-W=4% COLA-- See Salary Model for addl details 001 000 000 513 10 21 50 Auto Allowance 6,000 001 000 000 513 10 Medical Opt Out 13,731 001 000 000 513 10 11 16 ICMA 457 Plan 7,179 7,157 7,200 7,153 7,200 13,269 ♦84.30 % TOTAL SALARIES & WAGES 172,265 178,320 179,875 221,591 192,108 220,200 ♦14.62% PERSONNEL BENEFITS 001 000 000 513 10 21 00 Personnel Benefits 51,785 53,097 54,594 53,394 52,799 20,635 AWC Medical, Vision, DRS, Empl Security and L&I, Payroll Taxes TOTAL PERSONNEL BENEFITS 51,785 53,097 54,594 53,394 52,799 20,635 ♦60.92% OTHER SERVICES AND CHARGES 001 000 000 513 10 41 00 Professional Services 72,093 36,000 36,000 56,161 68,000 36,000 ♦47.06 % SR520 Consultant 001 000 000 513 10 43 00 Travel & Training - 121 4,000 743 4,000 4,000 ♦0.00% WCIA and other training 001 000 000 513 10 49 01 Dues, Subscr. 383 315 350 315 350 350 ♦0.00% TOTAL OTHER SERVICES & CHARG 72,476 36,436 1 40,350 1 57,2191 72,350 1 1 40,350 TOTAL EXECUTIVE DEPARTMENT 296,5271 267,853 1 274,819 1 332,2041 317,257 1 1 281,185 2023 Final Budget Detail 2021 2022 2023 2019 2020 2021 Year-end Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget Final Budget Budget Notes: FINANCE DEPARTMENT FTE's: 1.7 SALARIES & WAGES 001 000 000 514 20 11 00 Salaries & Wages 168,418 191,234 199,948 199,977 242,004 192,000 ♦20.66 % CPI-W=4% COLA ---see salary model notes 001 000 000 514 20 11 16 ICMA 457 Plan 8,973 9,835 10,200 10,123 11,700 9,000 ♦23.08 % Assumes full participation TOTAL SALARIES & WAGES 177,391 201,069 210,148 210,100 253,704 201,000 ♦20.77 % PERSONNELBENEFITS 001 000 000 514 20 21 00 Personnel Benefits 40,383 47,039 50,279 54,508 76,171 51,196 ♦32.79 % 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 12,409 7,917 11,797 ♦49.00% TOTAL PERSONNEL BENEFITS 53,672 61,617 66,301 66,918 84,088 62,993 ♦25.09 % OTHER SERVICES & CHARGES 001 000 000 514 20 41 01 Professional Services 7,000 7,350 10,300 7,570 10,300 30,000 ♦ 191.26 % Vision PS, Finance/Financial System Support + HR updates and new software, etc 001 000 000 514 20 42 00 Intergvtml Prof Serv-Auditors 14,543 19,554 23,000 8,234 25,663 25,000 ♦2.58 % Hybrid model utilized, $128 per hour but will save on travel expenses 001 000 000 514 20 43 00 Travel & Training 233 311 2,000 348 2,000 3,000 ♦50.00 % PSFOA, Budgeting Workshop for DFD 001 000 000 514 20 46 00 Insurance (WCIA) 181,234 176,720 185,734 186,167 176,342 218,886 Liability rate increase per 7/25 WCIA notice. Property 13%; B&M 5-10%, Crime 5-10% & Auto 9% pending Oct BOD vote notice less ♦24.13 % 15.56°% alloc to IDS 001 000 000 514 20 49 00 Misc-Dues, Subscriptions 75 35 500 849 250 1,000 ♦300.00 % WFOA, PSFOA, GFOA (Dues, Memberships), 001 000 000 514 20 49 10 Miscellaneous 11,246 10,044 15,000 40,753 11,000 15,000 ♦36.36% 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 9,855 12,000 1 12,000 ♦0.00% Election year costs (every other year is higher), 2023 keep to prior yr budget d/t potential for less KC cost share TOTAL OTHER SERVICES & CHARGI 222,963 221,973 248,534 253,776 237,554 304,886 ♦28.34 % TOTAL FINANCE DEPARTMENT 454,026 484,659 524,983 530,793 575,346 568,879 7' 12 % 2023 Final Budget Detail ACCOUNT NUMBER DESCRIPTION LEGAL DEPARTMENT 4XX 000 000 515 41 40 00 City Attorney, Dev. Serv. 001 000 000 515 41 40 00 City Attorney 001 000 000 515 45 40 00 Special Counsel 001 000 000 515 91 40 00 Public Defender TOTAL LEGAL DEPARTMENT 2022 Actualt s I Actuals BudgeI Final lI Budget I 2023 2019 2020 2021 Year-end Adopted Preliminary Comments from Budget Notes: as needed: FTE's: NA, contracted _ New Fund allocation ($56K) 256,837 456,288 300,000 304,723 244,000 300,000 ♦22.95 % Per SK hx avg of "routine legal service", "excluding itigation or highly contentious events"= $250K. SB added $75K for "contentious", less $25K to DS budget 16,173 7,956 60,000 19,542 60,000 20,000 ♦ 66.67 % Reduction as all three labor contracts signed in 2022 6,600 5,750 7,200 4,025 7,200 7,200 ♦0.00% Required Service/Expenditure 279.610 469.994 367.200 328.290 311.200 327.200 ♦ 5.14 2023 Final Budget Detail 2021 2022 2023 2019 2020 2021 Year-end Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget Final 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 257,629 279,408 302,965 ♦8.43 % CPI-W=4 % COLA 1 non -rep employee; 4 % CBA est COLA 3 employees -see salary model notes for details 001 000 000 518 10 11 11 Longevity 4,365 4,452 4,544 4,451 4,953 6,489 ♦31.01 % 001000000518101114 Education 1,200 1,199 1,200 3,148 1,200 1,800 ♦50.00% 001 000 000 518 10 11 16 ICMA 457 Plan 5,997 5,992 12,000 4,494 12,000 12,000 ♦0.00 % Assumes participation full participation 001 000 000 518 10 11 17 Opt -Out of Medical 10,155 8,778 12,418 9,275 9,215 9,458 ♦2.63 % 1 Employee participating in Opt -Out, same as 2022 001 000 000 518 10 12 00 Overtime TOTAL SALARIES & WAGES 264,051 273,113 287,927 278,996 306,776 332,712 ♦8.45% PERSONNEL BENEFITS 001 000 000 518 10 21 00 Personnel Benefits 103,020 105,586 108,461 103,887 107,947 1 115,106 ♦6.63 % AWC Medical, Vision, DRS, Empl Security and L&I, Payroll Taxes TOTAL PERSONNEL BENEFITS 103,020 105,586 108,461 103,887 107,947 115,106 ♦6.63% 001 000 000 518 10 31 00 Office and Operating Supplies 10,768 21,817 22,000 14,492 27,000 30,000 ♦ 11.11 % City Hall Office and Operating Expenses, Konica Copier, Pitney Bowes 001 000 000 518 10 41 00 Professional Services 15,654 14,833 17,500 10,680 129,520 145,500 ♦ 12.34 % Proshred, Municode, Scanning services, Avidex Chambers Support, $70,000 Comp Plan, $58,000 LaserFiche Consulting 001 000 000 518 10 42 00 Postage/Telephone 11,978 10,651 11,000 6,060 9,000 13,000 ♦44.44 % Postage (City Hall printing/mailing services); fax & credit card lines 001 000 000 518 10 43 00 Travel & Training 813 1,481 11,000 1,942 11,000 11,000 ♦0.00 % Training for clerk, Deputy Clerk/Admin Asst, ISC 001 000 000 518 10 44 00 Advertising 8,757 10,411 5,000 12,134 5,000 7,500 ♦50.00 % DS, CS legal advertisements 001 000 000 518 10 47 00 Utility Serv-Elec,Water,Waste 21,453 20,830 21,000 21,643 30,000 32,000 ♦6.67 % Calculated using 8/16/21 - 8/16/22 rolling 12 mos + 4% increase 001 000 000 518 10 48 00 Repairs & Maint-Equipment - - 500 800 500 500 ♦0.00 % office equipment repairs - Printer Svcs -Budget 001 000 000 518 10 49 10 Miscellaneous 7,145 790 2,800 4,936 1,500 3,200 ♦ 113.33 % City Staff and Volunteers Polo Shirts $2,200 001 000 000 518 10 49 20 Dues, Subscriptions 730 674 600 585 600 600 ♦0.00 % City Clerk and Deputy Clerk 001 000 000 518 10 49 30 Postcard, public information 13,505 6,048 4,000 5,667 4,000 10,500 ♦ 162.50 % Community mailings placeholder, monthly postcard discontinued 001 000 000 518 10 49 40 Photocopies 338 26 1,000 50 500 1 500 ♦0.00 % Most expenditures reflect pass through costs related to public records TOTAL OTHER SERVICES & CHARGES 91,140 87,561 96,400 78,987 218,620 254,300 ♦ 16.32% BUILDING MAINTENANCE 001 000 000 518 30 45 00 Facility Rental 7,734 9,129 9,408 7,262 10,500 12,000 ♦ 14.29 % 1 Public Storage Unit - Going away completely in first quarter 001 000 000 518 30 48 00 Repairs/Maint-City Hall Bldg 49,331 64,980 65,225 100,713 115000 , 97,500 ♦ 15.22 % $40k City Hall & PO cleaning Maint. $5k Beach/Park Bathroom cleaning, $10k HVAC Maint., Alarm/Fire Monitoring $2,500, fire inspt, misc cleaning, bug service etc. $40k CH interior painting TOTAL BUILDING MAINTENANCE 57,065 74,109 74,633 107,975 125,500 109,500 ♦12.75% 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 29,900 1,500 2,500 ♦66.67 % Replacement mouse, keyboards, Data Center replacement battery, etc IT Placeholder $185,100 (less 15.56%= $25,207 for TIG DS allocation) for Maint, monitoring, helpdesk, incident support; $90K EmailSocial Media 001 000 000 518 80 41 50 Technical Services, Software Services 178,226 169,911 149,020 151,851 237,772 275,100 archive, GoGov CRM/Communications, GovDelivery, Municode Website hosting and Agenda Management, King County INET, DUO Access, Azure Storage, 0365 Licenses, MS Teams Audio, Zoom Meetings, GovQA PRR/Redactions/Invoicing Software, 8X8 Phone System, Blue Beam ♦ 15.70 % Electronic Plan Review, Dude Solutions Asset Management, Laserfiche, Bang the Table Engagement Platform 001 000 000 518 80 48 00 Repairs & Maint: Annual Software Maint. 12,187 11,201 40,991 6,993 14,500 15,000 ♦3.45 % VEEAM, NetApp, Cisco SmartNet, Avidex, Domain Name Renewal, Vision Application Suite, Cisco FirePower, Cisco Umbrella TOTAL INFORMATION TECHNOLOGY 195,756 223.102 191,511 188,743 253,772 292,600 ♦15.30% SUBTOTAL CENTRAL SERVICES 711,033 996,313 758,932 758,589 1,012,615 1,104,218 ♦9.05% 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 HW Computer Replacements MPD Patrol Car Computers (13) $80,000, CH/PW Computer Replacements (8) $32,000, Dell R450 Server (1) 001 000 000 594 14 64 00 City Hall - IT HW/SW >$5K Capital Outlay 70.713 63,048 197,592 161,384 103,430 157,000 ♦51.79 % $10,000, SW Electronic Signature Software $20,000, Windows Servers 2022 Upgrade 16 CORE (3) $15,000 TOTAL CAPITAL EXPENDITURES 70,713 63,048 1 197,592 161,384 103,430 1 157,000 ♦51.79% TOTAL CENTRAL SERVICES 831,228 1,059,361 1 956,524 919,9741 1,116,045 1 1 1,261,218 ♦13.01 7% 2023 Final Budget Detail 2021 2022 2023 2019 2020 2021 Year-end Adopted Preliminary Comments from prior year, please update as needed ,-OUNT NUMBER DESCRIPTION Actuals Actuals Budget Final Budget Budget Notes: POLICE DEPARTMENT I FTE: 11 SALARIES & WAGES 000 000 521 20 11 00 Salaries & Wages 1,103,178 1,129,182 1,185,251 1,158,403 1,195,655 1,242,191 ♦3.89% CPI-W=4% COLA 2 non -rep employee; 4% CBA Clerical; 5% CBA PD est ceiling COLA 7 employees 000000521201111 Longevity 12,345 16,000 23,025 20,031 22,481 25,026 ♦11.32% 000000521201114 Education 600 600 600 600 600 1,800 ♦200.00% 000 000 521 20 11 16 ICMA 457 Plan 52,240 48,120 55,506 48,415 56,285 50,000 ♦ 11.17% -000-000-521-20-11-17 Opt Out Medical 20,322 37,294 40,977 38,686 43,449 35,166 ♦19.06% 000 000 52120 11 18 Night Shift Differential 10,118 10,735 14,868 11,119 15,204 16,378 ♦7.72% Based on "average" week of coverage provided by Sergeant 000 000 521 2011 19 Physical Fitness Incentive 15,800 All officers utilizing 000 000 521 20 12 00 Overtime 64,777 98,680 70,000 98,836 120,000 120,000 ♦0.00 % 1 Training, vacation leave, non -funded special events (Medina Days/SeaFair/Shredder Day, etc.)+ summer emphasis patrols 000 000 521 20 12 01 Merit Pay 52,710 61,732 54,140 56,031 74,632 75,000 ♦0.49% Paid Q1 of 2023 on 2022 earnings (reg + OT). Captain Gidlof will receive for 6 months 000000521201300 Holiday Pay 36,187 37,498 50,200 38,497 51,522 52,000 ♦0.93% TOTAL SALARIES & WAGES 1,352,478 1,439,840 1,494,567 1,470,617 1,579,828 1,633,361 ♦3.39% PERSONNEL BENEFITS 000 000 521 2021 00 Personnel Benefits 433,003 386,595 404,813 394,478 430,469 437,211 ♦ 1.57% Payroll taxes, Medical, Dental benefts,etc, less DRS/ICMA replacement above. 000 000 521 2021 10 Personnel Benefits -Retirees 50,024 39,023 43,852 54,501 51,118 24,750 ♦51.58 % LEOFF 1 Medical plus Unum (+4%) + 12 mos rolling reimb(+10%) 000 000 521 20 22 00 Uniforms 4,433 14,023 7,000 7,458 7,000 8,500 ♦21.43% Uniform replacement 000 000 52120 22 01 DOJ Bullet Proof Vest Program 1,307 - 900 813 1,600 4,000 ♦ 150.00% Three vest replacements - external vest and covers during 2023 000 000 521 20 23 00 Tuition - 451 3,000 565 7,000 9,000 ♦28.57 % One officer collecting on tuition reimbursement SUPPLIES 000 000 521 2031 00 Office Supplies 4,900 16,033 9,000 9,688 11,000 15,000 ♦36.36% Includes $3,000 for Emergency Preparedness 000 000 52120 31 01 Off Equip, IT HW, SW <$5K 754 324 10,000 5,641 7,000 7,000 ♦0.00% Upgrades, normal operating costs 000 000 521 2031 40 Police Operating Supplies 4,528 21,117 6,500 3,819 6,500 15,000 ♦ 130.77% Taser cartridges, evidence processing equip, radio batteries, etc.; NARCAN replacement (deployment of new radio system) 000 000 521 20 31 60 Ammo/Range (Targets, etc.) 6,839 12,743 8,500 4,039 9,000 12,000 ♦33.33% Per ofc. contract and for training/firearms qualifications - ammo costs continue to increase 000 000 521 20 32 00 Vehicle Expenses -gas, car wash 23,134 17,063 26,000 22,810 26,000 30,000 ♦ 15.38% Includes bridge tolls,significant fuel cost increase 000 000 521 20 35 20 Firearms (purchase & repair) 1.937 1.360 1.500 15.514 1.500 2.000 ♦ 33.33% OTHER SERVICES & CHARGES 000000521204100 Professional Services 3,190 3,672 5,000 1,661 4,000 4,000 ♦0.00% 000 000 521 2041 50 Recruitment -Background 790 3,382 2,000 4,710 2,500 5,000 ♦ 100.00% PST fees 000 000 521 20 42 00 Communications (Phone,Pagers) 13,163 12,902 17,500 14,931 15,000 16,000 ♦6.67% Cell phones and service, computer modems in patrol car, KC INET service. 000 000 52120 43 00 Travel & Training 8,901 3,896 10,000 5,849 10,000 14,000 ♦40.00% Ongoing training requirements, large mandatory CJTC training requirements increase, 2 new officers/new sergeant/new captain 000 000 521 20 45 00 Equipment -Lease & Rentals 3,030 1,521 2,500 380 2,500 2,000 ♦20.00% Copy machine $8,000 for maintain serviceable fire extinguishers, radar, property room software yearly maintenance fee of $2500, copier quarterly maintenance, 10k 000 000 521 20 48 00 Repairs & Maint-Equipment 3,790 1,580 8,000 4,626 28,000 18,000 ♦35.71 % for cooling system 000 000 521 20 48 10 Repairs & Maint-Automobiles 13,149 6,446 8,500 5,120 8,500 8,500 ♦0.00% 000 000 52120 48 20 Repairs & Maint- SW, HW Maint 26,418 20,185 30,000 25,041 30,000 30,000 ♦0.00% Server Maintenance License, camera monthly fees, camera maintenance, IT maintenance cameras, electrical to each intersection 000 000 521 20 49 30 Animal Control - - 500 - 000000521204940 Dues,Subcriptions,Memberships 3,174 5,124 4,500 5,326 5,000 7,000 ♦40.00% WSPC, IACP Professional Memberships 000 000 521 20 49 41 Lexipol Manuals 7,374 - 4,200 8,163 6,000 8,000 ♦33.33% Yearly maintenance agreement per contract to Lexipol. PowerDMS needed for WASPC Accredidation Requirements 000 000 521 20 49 60 Crime Prevention/Public Educ 2,725 990 5,000 3,523 5,500 6,500 ♦ 18.18% Increased Shredder Day costs, victim resource & crime prevention brochures, school resource materials. INTERGOVERNMENTAL SERVICES 000 000 521 2041 15 Dispatch Services-Norcom Trans 60,295 66,960 61,225 58,902 65,533 81,567 ♦24.47% NORCOM - Projected cost for 2023 000 000 521 2041 20 Dispatch-EPSCA 5,066 5,252 6,500 5,887 6,500 6,500 ♦0.00% Per contract - cost to maintain 800 Mhz police radio connectivity 000 000 521 2041 40 Marine Patrol Services 66,000 70,000 70,000 4,975 90,000 97,000 ♦7.78% Anticipated contract with Mercer Island 000 000 521 2041 41 Bellevue CARE program 4,710 28,000 28,000 ♦0.00% 2022-2024 program offset by ARPA, $28K/yr 000 000 521 2041 55 Jail Service -Prisoner Board 19,435 4,430 17,500 127 15,000 14,000 ♦6.67% King County Jail/SCORE/Kirkland Jail 000 000 521 2041 60 Prisoner Transport - - 500 - 500 500 ♦0.00% Cost to shuttle prisoners from jail to court and back to jail 000 000 521 2041 80 Domestic Violence -Kirkland 215 1,000 1,000 1,000 ♦0.00% Mandated by court as resource to DV victims TOTAL INTERGOVERNMENTAL SER 151.011 146,642 156.725 74.600 206.533 228.567 ♦10.67% 2023 Final Budget Detail 2021 2022 2023 2019 2020 2021 Year-end Adopted Preliminary Comments from prior year, please update as needed: Notes: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget Final Budget Budget SUBTOTAL POLICE 2,120,051 2,154,913 2,270,057 2,143,872 2,461,548 2,545,389 ♦3.41% APITAL OUTLAY 001 000 000 594 21 64 10 irveillance Cameras 30,000 420,000 30,000 ♦92.86% $30K allocated for additional Maintenance of New Cameras System 001 000 000 594 2164 10 lice HWlW, Equip >$5K Capital 4,040 53,767 3,500 2,809 4,500 4,500 ♦0.00% Mandated mobile platform requirements 001 000 000 594 21 70 00 lice Vehicle Leasing, Princ. Cost 30,024 34,532 77,000 61,006 89,556 90,000 ♦0.50% Vehicle leasing costs - 6 vehicles 001 000 000 594 21 80 00 Police Vehicle Leasing, Int. Cost 7,322 7,718 15,521 TOTAL CAPITAL OUTLAY 41,386 96,017 110,505 79,337 514,056 124,500 ♦75.78% 2023 Final Budget Detail 2021 2022 2023 2019 2020 2021 Year-end Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget Final 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 807,954 726,837 797,788 ♦9.76% Updated 7/29/22 with COB notice received. LEOFF1 contract obligation 001 000 000 522 20 41 00 Fire Control Services (LEOFF1 Liab.) 31,654 30,000 30,000 30,000 ♦0.00% TOTAL INTERGOVERNMENTAL 843,242 817,367 807,954 807,954 756,837 827,788 ♦9.37% TOTAL FIRE & MEDICAL DEPT 843,242 1 817,367 807,954 1 807,954 756,837 8279788 ♦9.37% 2023 Final Budget Detail 2021 2022 2023 2019 2020 2021 Year-end Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget Final Budget Budget Notes: SOCIAL & ENVIRONMENTAL SERVICES SOCIAL SERVICES 001 000 000 551 10 40 OC Public Housing Services - ARCH 16,561 18,376 18,476 18,476 32,109 1 27,476 ♦ 14.43 % Same as prior year + pass-thru of "Affordable & Supp Housing" sales tax ($9,000 est TOTAL SOCIAL SERVICES 16,561 18,376 18,476 18,476 32,109 27,476 ♦ 14.43 % ENVIRONMENTAL SERVICES 001 000 000 553 10 40 00 Land & Water Conservation Resources -King County - 1,925 - 4,000 4,000 ♦O.00% 001 000 000 553 70 40 00 Pollution Prevention -Puget Sound Clean Air Agenc} 9,835 9,964 9,953 9,953 9,582 9,582 ♦O.00% TOTAL ENVIRONMENTAL SERVICES 9,835 9,964 11,878 9,953 13,582 13,582 ♦O.00% MENTAL HEALTH SERVICES 001 000 000 564 60 40 00 Mental Health Services -KC Substance Abuse Fees 884 932 884 952 1,000 1,000 ♦O.00% TOTAL SOCIAL & ENVIRONMENTAL SVCS 27,2801 29,2721 31,238 1 29,381 1 46,691 1 1 42,058 1 ♦9.92 % 2023 Final Budget Detail 2021 2022 2023 2019 2020 2021 Year-end Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget Final Budget Budget Notes: Kept Same Budget as we are under in 2022 RECREATION SERVICES (LIFEGUARDS AND BOYS & GIRLS CLUB) SALARIES & WAGES 001 000 000 571 00 10 00 Salaries & Wages 22,511 20,545 30,000 19,503 35,000 35,000 ♦0.00% 001 000 000 571 00 11 00 Overtime - - 500 - TOTAL SALARIES & WAGES 22,511 20,545 30,500 19,503 35,000 35,000 ♦0.00% PERSONNEL BENEFITS 001 000 000 571 00 20 00 Personnel Benefits 2,955 2,562 4,720 2,383 4,200 4,200 ♦0.00% 001 000 000 571 00 30 00 Uniforms 1,555 1,339 2,000 1,238 2,000 2,000 ♦0.00% TOTAL PERSONNEL BENEFITS 4,510 3,901 6,720 3,621 6,200 6,200 ♦0.00% 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 1,726 7,300 7,300 ♦0.00% TOTAL SUPPLIES 1,884 6,888 7,300 1,726 7,300 7,300 ♦0.00% OTHER SERVICES & CHARGES 001 000 000 571 00 40 00 Travel & Training 168 300 2,544 001 000 000 571 00 41 00 Recreation - Boys & Girls Club TOTAL OTHER SERVICES & CHARGI 168 - 300 1 2,544 1 - - TOTAL RECREATION -LIFEGUARDS 29,073 1 31,335 44,820 1 27,393 1 48,500 48,500 ♦0.00% 2023 Final Budget Detail ACCOUNT NUMBER DESCRIPTION PARKS DEPARTMENT SALARIES & WAGES 001 000 000 576 80 11 00 Salaries & Wages 001 000 000 576 80 11 11 Longevity 001 000 000 576 80 11 14 Education 001 000 000 576 80 11 16 ICMA 457 Plan 001 000 000 576 80 11 17 Opt -Out of Medical 001 000 000 576 80 11 00 Salaries & Wages, SEASONAL WORKERS 001 000 000 576 80 12 00 Overtime TOTAL SALARIES & WAGES PERSONNEL BENEFITS 001 000 000 576 80 21 00 Personnel Benefits 001 000 000 576 80 22 00 Uniforms TOTAL PERSONNEL BENEFITS SUPPLIES 001 000 000 576 80 31 00 Operating Supplies 001 000 000 576 80 32 00 Vehicle Fuel & Lube TOTAL SUPPLIES OTHER SERVICES & CHARGES 001 000 000 576 80 41 00 Professional Services 001 000 000 576 80 41 04 Professional Services-Misc 001 000 000 576 80 42 00 Telephone/Postage 001 000 000 576 80 43 00 Travel & Training 001 000 000 576 80 47 00 Utilities 001 000 000 576 80 48 00 Repair & Maint Equipment 001 000 000 576 80 49 00 Miscellaneous, annual lease 001 000 000 576 80 49 01 Misc-Property Tax TOTAL OTHER SERVICES & CHARGES CAPITAL OUTLAY 001 000 000 594 76 30 00 Park Improvements 001 000 000 594 76 00 00 Furniture and Equipment: Replacement 001 000 000 594 76 64 00 Parks Capital Outlav >$5K 2019 Actuals 2020 Actuals 2021 Budget 2021 Year-end Final 2022 Adopted Budget 1 2023 Preliminary Budget Comments from prior year, please update as needed: Notes: FTE: 3 of 5 total allocated Public Works are split 60% Parks and 40% Streets 249,689 254,246 265,275 265,197 271,732 296,997 ♦ 9.30% CPI-W=4% COLA 1 non -rep employee; 4% CBA est COLA 4 employees ---see salary model notes for details 10,776 9,282 8,798 6,427 6,269 6,502 ♦3.72% 3,238 3,835 4,680 3,497 3,840 3,240 ♦15.63% 10,789 10,182 10,800 10,481 10,800 10,800 ♦0.00% Assumes full participation 13,240 9,935 11,034 12,819 16,323 10,612 ♦34.99% 19,658 20,453 20,453 20,453 ♦0.00% Unlikely to exceed 2022 budget 4,679 2,998 3,236 6,080 6,472 8,000 ♦23.61 % Special Events:Medina Days, Seafair, Parkboard-4 provided by Ryan 99,480 I 106,385 I 103,805I 95,0451 89,10311 111,806I ♦25.48%IAWC Medical, Vision, DRS, Empl Security and L&I, Payroll Taxes 1.956 1.854 2.000 1.953 2.000 2.300 ♦ 15.00 20,836 4,689 30,592 3,093 19,000 5,000 18,960 6,907 37,000 5,000 37,000 5,000 ♦0.00% ♦0.00% 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. Public Works equipment & vehicles 0% 25,525 33,685 24,000 25,867 42,000 42,000 ♦0.00% 7,362 9,117 5,000 17,699 15,000 15,000 ♦0.00% Arborist, irrigation repairs, engineeringBack-flow device testing, hazardous material disposal, fertilizing and spraying, $5K added 9/22 d/t WCIA audit compliance (electrician) 349 514 4,000 - 3,000 5,000 ♦66.67% Debris disposal 5,313 6,737 6,500 6,046 6,500 7,000 ♦7.69% mobile phones, alarm/fire monitoring line, internet 1,322 284 5,000 308 3,000 3,000 ♦0.00% Pesticide training, flagger training, certifications, licenses, conferences, qtdy safety meetings, AE Training 20,283 16,446 22,000 31,248 22,000 22,000 ♦0.00% Utilities for public works shop and park restrooms, irrigation water, pond power 5,625 4,313 7,000 8,462 7,000 7,000 ♦0.00% Backhoe, mowers,workman 511 500 1,000 500 600 600 ♦0.00% yearly lease for Shop Yard 192 1 324 1 200 1 265 300 1 1 300 1 ♦0.00% KC Real Estate Tax (Noxious Weeds) 10,516 7,000 - - 8.268 5,654 10.516 8, 268 7,000 5,654 - 490,504 478,907 511,781 497, 548 1 526,392 see capital projects; Park Benches, Tables, Tennis Court Nets, Flags 4 2023 Final Budget Detail 2021 2022 2023 2019 2020 2021 Year-end Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget Final Budget Budget Notes: OPERATING TRANSFERS From General Fund to: 001 000 000 597 00 30 00 Levy Stabilization Fund $ 500,000 500,000 $ 500,000 $ 500,000 ♦0.00% 001 000 000 597 00 00 03 Street Fund 40,000 370,000 $ 377,132 377,132 $ 401,527 $ 440,000 ♦9.58% 001 000 000 597 00 01 00 Contingency Fund 250,000 001 000 000 597 00 30 04 Dev. Services 1,000,000 - ♦ 100.00% Starting Fund Balance, inlcuding $600K of cust deposits TOTAL TRANSFERS FROM GENERAL FUND 40,000 370,000 877,132 1,127,132 1,901,527 940,000 '50.57% 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 75,000 TOTAL TRANSFERS FROM CAPITAL FUND 347,000 75,000 TOTAL OPERATING TRANSFERS 387,000 370,000 877,132 1,127,132 1,901,527 1,015,000 2023 Final Budget Detail 2021 2022 2019 2020 2021 Year-end Adopted ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget Final Budget DEVELOPMENT SERV. ENT. FUND, EST 2022 Transfer from Gen. Rev tab: 401 000 000 322 10 00 00 Building Permits 800,891 703,523 $577,164 958,296 $ 967,444 401 000 000 322 11 00 00 Building Permit - Technology Fee 10,131 9,324 $8,473 10,626 $ 11,112 401 000 000 334 03 10 00 DOE Grant. Shoreline Master Program 7,973 13,171 $ 25,000 401 000 000 332 92 10 01 Zoning & Subdivision Fees 75,184 45,010 $101,818 96,227 $ 81,060 401 000 000 333 16 00 00 Other Planning & Development Fees 183,150 136,998 $203,156 261,084 $ 214,237 401 000 000 336 06 51 00 Misc. Fine, Penalties, Code 20,965 58,788 20,000 400 20,000 401 000 000 369 91 00 05 Other -CC Convenience Fees 3,043 3,224 3,000 27,880 33,042 401 000 000 395 10 00 00 Proceeds From Sales of Capital Assets 60 12,776 3,000 13,650 $ 5,000 REVENUES $ 1,356,895 OPERATING TRANSFERS 401 000 000 397 00 30 00 From General Fund (001) 1,000,000 TOTAL TRANSFER REVENUE 1,000,000 TOTAL DEV. SERV. ENT. FUND 2,356,895 REFUNDABLE DEPOSITS (NOT REFLECTED IN BUDGET) 401 000 000 382 10 00 01 Refundable Deposits - DS (CMP, PGB) 401 000 000 382 10 00 02 Refundable DS Adv Deposit 2023 Preliminary Comments from prior year, please update as needed: $ 621,128 ♦35.80% Similar activity to 2022 anticipated $ 11,065 ♦0.42% Similar activity to 2022 anticipated $ 135,550 Comp. Plan update, Housing Action Plan, SMP User Guide, SMP Monitoring $ 38,243 ♦52.82% Similar activity to 2022 anticipated $ 180,921 ♦ 15.55% Similar activity to 2022 anticipated $ 5,000 ♦75.00% Estimate 15,631 ♦52.69% Similar activity to 2022 anticipated ♦ 100.00% $ 1,007,538 ♦25.75% ♦ 100.00% Adv dep & other deposits thru 8/31 = $600K - ♦ 100.00% 2023 Final Budget Detail :OUNT NUMBER DESCRIPTION DEVELOPMENT SERVICES DEPT SALARIES & WAGES 000 000 558 60 11 00 Salaries & Wages 000 000 558 60 12 00 Overtime 000 000 558 60 11 11 Longevity 000 000 558 60 11 14 Education 000 000 558 60 11 16 ICMA 457 Plan PERSONNEL BENEFITS 000 000 558 60 21 00 Personnel Benefits SUPPLIES 000 000 558 60 31 00 Operating Supplies OTHER SERVICES & CHARGES gaol 000 000 514 20 46 00 Insurance (WCIA) 401 000 000 515 4140 00 City Attorney, Dev. Serv. 401 000 000 518 80 41 50 Technical Services, Software Services 401 000 000 558 60 41 00 Professional Services 401 000 000 558 60 41 01 Planning Consultant 401 000 000 558 60 41 02 Hearing Examiner 401 000 000 558 60 41 06 Building Inspector Contract 401 000 000 558 60 41 07 Engineering Consultant 401 000 000 558 60 41 08 Sound Testing Consultant 401 000 000 558 60 41 50 Landscape Consultant 401 000 000 558 60 41 55 Shoreline Consultant 401 000 000 558 60 42 00 Communications 401 000 000 558 60 43 00 Travel & Training 401 000 000 558 60 49 00 Dues, Subscriptions, Memberships 401 000 000 558 60 49 10 Miscellaneous 401 000 000 582 10 00 01 Refund of PGB/CMP Deposits (DS) 1401 000 000 582 10 00 02 Refund of DS Adv Deposits CAPITAL OUTLAY 000 000 594 XX 64 00 Furniture & Equipment 000 000 594 60 64 05 Vehicle 000 000 594 60 64 00 DS- IT HW/SW >$5K Capit TOTAL CAPITAL OUTLAY TOTAL DEVELOPMENT 2021 2022 2023 2019 2020 2021 Year-end Adopted Preliminary Comments from prior year, please update as needed: Actuals Actuals Budget Final Budget Budget Notes: FTE's: 3.5 Rob Salary and Benefits will be allocated 50/50 to DS and Street Fund (PW) Rob does Right of Way Permitting and Department of Ecology work for Ryan Osada 342,525 347,165 403,613 383,540 429,065 414,095 V 3.49 % CPI-W=4 % COLA 2 non -rep employees; 4 % CBA est COLA 2 employees ----- see salary model notes for step increase info 1,300 1,459 361 - - 2,468 - 766 1,200 2,011 2,700 3,000 ♦11.11 % 11,964 14,283 18,000 15,501 18,000 16,500 ♦8.: Assumes full participation 12,194 2,183 6,906 5,061 1 5,276 ♦4.25% 368,142 364,758 422,813 407,958 454,826 442,639 ♦2.68% 128,802 129,014 145,629 132,721 144,283 138,530 ♦3.99 % ♦3.99% AWC Medical, Vision, DRS, Empl Security and L&I, Payroll Taxes 128,802 129,014 145,629 132,721 144,283 138,530 1,902 2 3,000 205 4,000 2,500 Tree removal site signs, development site signs, business cards 327 420 2,000 1,978 3,000 1 3,500 1 ♦ 16.67 % Two aging vehicles. May require increasing repairs in addition to regular maintenance. 2,229 422 5,000 2,183 7,000 6,000 32,495 40,335 Liability rate increase per 7/31 WCIA notice. Property 4%; B&M 5-10%, Crime 5-10% & Auto 3% pending Oct BOD vote notice, ♦24.13 % allocated 15.56% from Finance 55,718 25,000 ♦55.13 % Estimate based upon 2022 activity. Considers hourly rate increase. 20,228 25,207 ♦24.61 % IT - TIG DS allocation of 15.56% of total from CS for Maint, monitoring, helpdesk, incident support 79,192 48,062 80,000 102,935 90,000 40,000 ♦55.5 Building plan review consultant with activity similar to 2022 52,377 - 50,000 19,176 70,000 50,000 ♦28.5 Planning Manager support. New services contract possible which will have an effect on the budget 26,803 16,243 20,000 12,928 3,500 25,000 ♦614.29 % Activity similar to 2022. New services contract will have an effect on the budget. Approx. 90% of budget recovered through fees 34,625 26,513 7,000 1,200 7,000 6,000 ♦ 14.2 Deputy Building Official performs inspections. $6,000 is contingency, vacations, medical leave, etc. 93,971 80,077 98,000 120,730 100,000 75,000 ♦25.0 Grading & drainage permit reviews, and inspections. Approx. 60% of the budgeted amount is recovered through Advance Deposit $10,973 7,965 4,000 19,611 11,000 18,000 ♦63.64 % Most of this expense is recovered through fees. New contract and potential revised fees effect budget 78,666 86,621 60,000 55,665 60,000 60,000 ♦0.00% Tree Code consultant, and Arborist. Approx. 50% of the budgeted amount is recovered through Advance Deposit 3,975 - 5,000 - 5,000 3,000 ♦40.00 o Consulting shorelines specialist. Budget based upon 2022 activity 3,034 184 3,000 3,000 ♦0.00% Estimate based upon 2022 4,478 1,393 12,000 1,607 11,000 5,000 ♦54.55 % Four DS staff. Budget considers minimum staff training requirements, updated state building code adoption 900 1,200 1,488 1,300 7,000 ♦438.46% APA, AICP, WABO, ICC, WSPT, AWC Director. Estimated cost increase included. 2021 Bldg Code costs 33,042 15,631 ♦52.69 % Bank fees (offset with customer fees) 41,865 Non -budget item 13,355 Non -budget item 4,950 40,000 ♦ 100.00 $30,334 $27,955 ♦7.84 % Dude solutions (E-permitting, public portal); BlueBeam (License, Maintenance) Computer replacement for DSC $4023 4,950 70,334 27,955 25% 9.051 910.642 878.386 1.179.726 1.013.297 .4.11 2023 Final Budget Detail ACCOUNT NUMBER DESCRIPTION CITY STREET FUND REVENUE INTERGOVERNMENTAL REVENUE DOE Sweeping Grant 101 000 000 334 03 60 00 Nat'l Pollution Discharge Elim 101 000 000 336 00 71 00 Multimodal Transportation - Cities 101 000 000 336 00 87 00 Motor Fuel Tax and MVA Transpo TOTAL INTERGOVERNMENTAL OPERATING TRANSFERS 101 000 000 397 00 20 00 From Capital Reserves (302) 101 000 000 397 00 10 00 From General Fund (001) 101 000 000 397 00 30 00 From Capital Proiects Fund (307) I I 2021 I 2022 I 2023 2019 2020 2021 Year-end Adopted Preliminary Comments from prior year, please update as needed: Actual. Actual. Budget Final Budaet Budget I Notes: 19,000 19,610 12,368 50,000 63,919 50,000 4,290 4,402 68,413 59,775 70,092 60,722 64,399 88,024 72,143 139,092 128,931 118,801 347,OOO1 370,OOO1 377,132 1 377,1321 507,637 347,0001 370,0001 377,132 1 377,132 1 507,637 75,000 ♦50.00% NPDES DOE Grant 3,790 ♦ 13.90% 56,376 ♦ 12.46% 2022: MRSC estimated distribution of State Shared Revenue, available late July 35,166 ♦ 13.78% 440,000 ♦ 13.32% 75,000 Transfer from Capital Fund to Street Fund or REET1 eligible or unrestricted Capital I TOTAL CITY STREET FUND 435.0241 442.1431 516.224 1 506.063 1 626,438 1 1 650.166 1 1 2023 Final Budget Detail NUMBER CITY STREET FUND SALARIES & WAGES 101 000 000 542 30 11 00 Salaries & Wages 101 000 000 542 30 11 11 Longevity 101 000 000 542 30 11 14 Education 101 000 000 542 30 11 16 ICMA 457 Plan 101 000 000 542 30 11 17 Opt -Out of Medical 101 000 000 542 30 11 00 Salaries & Wages (Seasonal Workers) 101 000 000 542 30 12 00 Overtime PERSONNEL BENEFITS 101 000 000 542 30 21 00 Personnel Benefits ROAD & STREET MAINTENANCE 101 000 000 542 30 31 00 Operating & Maintenance Supplies 101 000 000 542 30 35 00 Small Tools/Minor Equipment 101 000 000 542 30 41 00 Professional Services 101 000 000 542 30 41 03 Prof Svcs- NPDES Grant 101 000 000 542 30 41 10 Road & Street Maintenance 101 000 000 542 30 45 00 Machine Rental 101 000 000 542 30 47 00 Utility Services 101 000 000 542 30 48 00 Equipment Maintenance 101 000 000 542 40 41 00 Storm Drain Maintenance 101 000 000 542 63 41 00 Street Light Utilities 101 000 000 542 64 41 00 Traffic Control Devices 101 000 000 542 66 41 00 Snow & Ice Removal 101 000 000 542 67 41 00 Street Cleaning 101 000 000 542 70 40 00 Street Irrigation Utilities TOTAL ROAD & ST MAINTENANCE CAPITAL OUTLAY 101 000 000 594 42 64 00 >$5.000 Equipment, HW & SW 2021 2021 2022 2023 2019 2020 Adopted Year-end Adopted Preliminary Actuals Actuals Budget I Final Budget Budget 166,459 169,496 176,850 176,799 181,155 250,96' 7,184 6,188 5,865 4,285 4,179 4,33° 2,159 2,557 3,120 2,331 2,560 2,76( 7,192 6,789 7,200 6,987 7,200 8,70( 8,826 6,163 7,080 8,547 10,882 7,07: 13,106 1,999 13,636 13,636 13,63( 3.119 2.157 4,053 4.314 5.000 66,3421 70,8091 69, 2041 63,258 6,258 4,275 5,000 6,332 5,000 5,000 4,686 4,377 4,000 5,000 4,000 6,000 49,441 51,430 54,000 49,036 54,000 54,000 33,993 49,875 50,000 25,319 50,000 50,000 124 8,161 10,000 5,832 10,000 11,000 603 90 1,000 840 2,000 4,000 857 622 1,000 1,044 1,000 7,285 6,579 7,000 5,497 7,000 7,000 37,326 5,256 15,000 5,985 15,000 15,000 21,755 21,471 22,000 21,460 22,000 22,000 3,849 10,916 10,000 8,736 10,000 10,000 160 680 1,000 584 1,000 1,000 15,320 14,517 25,000 23,937 25,000 25,000 18,854 7,235 23,000 10,466 23,000 23,000 200,511 185,484 228,000 170,069 229,000 233,000 Comments from prior year, please update as needed: Notes: FTE: 2 of 5 total allocated, .5 From DS Public Works are split 60% Parks and 40% Streets Rob Salary and Benefits will be allocated 50/50 to DS and Street Fund (PW) Rob does Right of Way Permitting and Department of Ecology work for Ryan Osada ♦38.54 % CPI-W=4 % COLA 1 non -rep employee; 3.5 % CBA est COLA employees ---see salary model notes for remaining staff ♦ 3.72% ♦7.81 % ♦20.83% Assumes full participation ♦ 35.00 % ♦0.00 % Unlikely to exceed 2022 ♦ 15.90% Special Events:Medina Days, Seafair, Parkboard--# provided by Ryan ♦ 30.61 % ♦51.57%IAWC Medical, Vision, DRS, Empl Security and L&I, Payroll Taxes ♦0.00% Storm drain pipe, catch basin grates, marking paint, gravel, cement, bark, roadside plantings REET1 eligible ♦50.00% power tools, mower parts, Pole Saw, Weedeater ♦0.00% 84th Median & 24th Roadside Maint, 24th traffic Signal (shared Clydehill # netted), WRIA $2941 (7/27 notice) REET1 eligible ♦0.00% NPDES Requirements Grant $50k ♦ 10.00% Pavement patching, pavement markings, sidewalk maintenance, curb repairs REET1 eligible ♦100.00% ditch witch, compactor, compressor, manlift ♦ 100.00 % Utility locates ♦0.00 % PW vehicle and power equip repairs ♦0.00% Catch Basin Vactoring, Storm Line jetting, root cutting, camera ♦0.00% PSE street light Power, REET1 eligible ♦0.00% Posts, reflective signs(Fed Req), barricades, cones ♦0.00% Sand, ice melt ♦0.00% Street sweeping ♦0.00% ♦ 1.75% ♦316.67% Asset Essentials Licensing (2021 didn't make it into rollup) 2023 Final Budget Detail ACCOUNT NUMBER DESCRIPTION TREE FUND REVENUE MISCELLANEOUS REVENUE 103 000 000 345 89 00 00 Other -Tree Replacement 103 000 000 382 20 00 00 Refundable Retainage Deposits TOTAL MISCELLANEOUS REVENUE 2021 2022 1 2023 2019 2020 2021 Year-end Adopted Preliminary Actual, I Actual, Budget Final Budget Budget 3,075 3,075 3,075 3,075 875 3,950 3,075 3,075 3,075 3.95n - 3_n75 - 3_n75 1 3_n75 Comments from Expecting only minimum fines update as needed: 2023 Final Budget Detail 2021 2022 2023 2019 2020 2021 Year-end Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget Final Budget Budget Notes: TREE FUND OTHER SERVICES & CHARGES 103 000 000 558 60 41 50 Professional Services 6,496 8,000 18,816 10,000 10,000 ♦ 0.00% Consultant Arborist 103 000 000 86049 1C Miscellaneous -Tree Replacement 23,572 4,332 30,000 5,224 30,000 30,000 ♦0.00% Tree Plantings, Hazardous Tree Program TOTAL OTHER SERVICES & CHARG 30,067 4,332 38,000 24,040 40,000 40,000 ♦0.007 TOTAL TREE FUND 30,067 4,332 38,000 24,040 40,000 40,000 ♦0.00% 2023 Final Budget Detail Comparative Summary by Fund 2018 Budget 2021 2021 2022 2023 2019 2020 Adopted Year-end Prelimiary Preliminary ACCOUNT NUMBER DESCRIPTION Actuals Actuals Budget Final Budget Budget CONTINGENCY FUND 302 000 000 397 00 01 00 From General Fund 302 000 000 361 11 00 00 Investment Interest Earnings 250,000 - 250,000 Total Capital Reserve Revenue - - 250,000 250,000 - - TOTAL RESERVE FUND - - 250,000 250,000 - - 2019 ACCOUNT NUMBER DESCRIPTION Actuals 2020 Actuals 2021 Budget 2021 Year-end Final 2022 Adopted Budget 2023 Preliminary Budget Comments from prior year, please update as needed: Notes: LEVY STABLIZATION FUND OPERATING TRANSFERS 303 000 000 397 00 30 00 From General Fund (001) - 500,000 500,000 500,000 500,000 ♦0.00% New Fund, must have min. fund balance of $2M by 12/31/2025 TOTAL TRANSFER REVENUE 500,000 500,000 500,000 500,000 ♦0.00% TOTAL LEVY STABILZATION FUND - - 500.000 1 500.000 1 500.000 1 1 500.000 ♦0.00% 2023 Final Budget Detail 2021 2022 2023 2019 2020 2021 Year-end Adopted Preliminary Comments from prior year, please update as needed: ACCOUNT NUMBER DESCRIPTION Actuals Actual Budget Final 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 962,071 804,850 566,532 ♦29.61 % 2022- YTD Annualized Through AUG22, minus 25% per predicted market coal down 307 000 000 318 35 00 OC Real Estate Excise Tax 2 559,082 768,854 388,968 962,071 804,850 566,532 ♦ 29.61 % TOTALTAXES 1,118,165 1,537,708 777,936 1,924,142 1,609,699 1,133,065 ♦29.61% 307 000 000 332 92 10 01 Coronavirus Local Fis. Rec. (ARPA) 459,368 458,919 ♦ 100.00% 307 000 000 334 03 80 00 State Transp Improv Board Grant - Sidewalks 203,932 241,000 KC Parks Levy, Nov 2019 went to ballot for renewal, passed, updated to reflect notice rec'd from KC of COM annual portion deferredg 2022 amt to 307 000 000 334 06 91 02 Property II Levy 26,964 49,965 50,000 50,291 50,000 2023 for next segment of playground updating project 307 000 000 334 06 91 OE TIB-LED Streetlight Conversion Grants TOTAL INTERGOVERNMENTAL 230,896 290,965 50,000 509,659 458,919 50,000 ♦89.10% 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 8,780 18,000 70,200 ♦290.00 % Assumes LGIP and Bond Investments Interest, allocated between General Fund (40%) & Capital (60%)-- 2022.07 ytd annualized 307 000 000 367 00 00 00 Capital Project Donations - Nan -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 OC From Capital Reserve Fund to Capital TOTAL TRANSFERS TOTAL CAPITAL PROJECTS FUND 1,452,9431 1,842,7171 1,113,0161 2,443,1451 2,086,618 1 1 1,253,2651 ♦39.94% 2023 Final Budget Detail ;OUNT NUMBER DESCRIPTION CAPITAL PROJECTS FUND IMPROVEMENTS 000 000 594 18 60 00 Building Improvements 000 000 594 76 63 20 Park Improvements 000 000 595 30 63 01 Street Improvement - Overlays .000 000 595 30 63 02 Storm Drainage Improvements 000 000 595 30 63 10 Sidewalk Improvements red account codes: 000 000 595 30 05 00 Overlake Drive East 000 000 595 30 60 00 Poplar Tree Removal/Replacement 000 000 595 30 63 12 Walkable Medina Project 000 000 595 30 63 18 Medina Park Ponds 000 000 595 90 1100 Allocation of PW Director salary for TOTAL IMPROVEMENTS TOTAL CAPITAL PROJECTS Active Accounts, use category code for project # I 2021 I 2022 I 2023 2019 2020 2021 Year-end Adopted Preliminary Actuals Actual Budget Final Budoet Budqet 79,484 17,132 20,000 18,402 20,000 200,000 ♦900.00 % Rail and balcony replacement, Siding etc. 79,489 81,823 150,000 118,699 100,.00 50,000 ♦50.00% 515,098 152,160 340,000 258,979 120,000 45 36,4931 50,000 209,746 1,000,000 200,000 ♦80.00 % —$200k is carry over from 2022 ARPA Funds 279,899 380,8981 280,000 45,841 390,000 520,000 ♦33.33% NE 12th ST ADA & Sidewalk Repairs *$390K carry over from 2022 + UG *PSE partially funds UG - amount TBD 954,0151 668,5051 840,000 651.6671 1,510,000 1,090,000 ♦27.81 954,015 668,505 840.000 651,667 1,510,000 1,090,000 ♦27.81 2023 Final Budget Detail