The URL can be used to link to this page

2023-03-14 City Council FIN Packet1. Op E D o Agenda Edmonds City Council tnl. }nyo FINANCE COMMITTEE CITY COUNCIL CONFERENCE ROOM 121 - 5TH AVENUE N, EDMONDS, WA 98020 MARCH 14, 2023, 5:30 PM COUNCIL COMMITTEE MEETINGS ARE WORK SESSIONS FOR THE COUNCIL AND CITY STAFF. COMMITTEE MEETING AGENDAS DO NOT INCLUDE AUDIENCE COMMENTS OR PUBLIC HEARINGS. STAFF AND COUNCILMEMBERS ATTEND COMMITTEE MEETINGS VIRTUALLY, AND MEMBERS OF THE PUBLIC ARE ENCOURAGED TO ATTEND THE SAME WAY. PERSONS WISHING TO ATTEND THIS MEETING VIRTUALLY IN LIEU OF IN -PERSON ATTENDANCE CAN CLICK ON OR PASTE THE FOLLOWING ZOOM MEETING LINK INTO A WEB BROWSER USING A COMPUTER OR SMART PHONE: HTTPS://ZOOM. US/J/95798484261 OR JOIN BY DIAL -UP PHONE: US: +1 253 215 8782 WEBINAR ID: 957 9848 4261 IF MEMBERS OF THE PUBLIC CANNOT ACCESS THE VIRTUAL COMMITTEE MEETINGS WITH THEIR PERSONAL DEVICES, A MONITOR IS PROVIDED ON CITY COUNCIL COMMITTEE NIGHTS FROM 430- 930 PM AT THE CITY COUNCIL CONFERENCE ROOM AT 121 5TH AVE N, EDMONDS WA. COMMITTEE MEMBERS: WILL CHEN (CHAIR), SUSAN PAINE, COUNCIL PRESIDENT (EX-OFFICIO MEMBER) CALL TO ORDER COMMITTEE BUSINESS 1. Committee Updates (10 min) 2. January 2023 Monthly Financial Report (10 min) 3. 2020 Audit Update (10 min) 4. Disposed Assets - 2022 (5 min) ADJOURNMENT: 7:30 PM Edmonds City Council Agenda March 14, 2023 Page 1 2.1 City Council Agenda Item Meeting Date: 03/14/2023 Committee Updates Staff Lead: Committee Chair CM Chen Department: City Council Preparer: Beckie Peterson Background/History The purpose of this standing agenda item is to allow a mechanism for staff to provide committees with brief, verbal updates on an activity or project overseen by a department and so that the Council can be more aware of what is happening around the city. Updates will facilitate a better set of expectations for councilmembers, the public, and the staff. Recommendation N/A Narrative Requested Committee Updates for March 14, 2023: 1. City Cash Management 2. OpenGov Update 3. 2021 SAO audit issues Management Response Packet Pg. 2 2.2 City Council Agenda Item Meeting Date: 03/14/2023 January 2023 Monthly Financial Report Staff Lead: Dave Turley Department: Administrative Services Preparer: Sarah Mager Background/History N/A Staff Recommendation Move to full council to be received for filing Narrative January 2023 Monthly Financial Report Attachments: January 2023 Monthly Financial Report Finance Committee Mtg 03_14 Packet Pg. 3 I 2.2.a I OF EDP � d lac. 1 $9v CITY OF EDMONDS MONTHLY BUDGETARY FINANCIAL REPORT JAN UARY 2023 Packet Pg. 4 1 I 2.2.a I INVESTMENT PORTFOLIO SUMMARY City of Edmonds Investment Portfolio Detail As of January 31, 2023 Years Agency/ Investment Purchase to Par Market Maturity Coupon Issuer Type Rice Maturity Value Value Date Rate Seattle WA Muni FHLMC FHLB Kent WA First Financial - ECA First Financial - Waterfront Center FHLB FHLB FM FNMA FHLB Spokane County WA FHLMC FHLB US Treasury Note Bonds 2,224,500 0.00 2,000,000 2,000,000 02/01/23 5.00% O Bonds 988,678 0.22 1,000,000 990,371 04/20/23 0.38% 0' d Bonds 1,996,590 0.68 2,000,000 1,935,896 10/05/23 0.22% Bonds 286,648 0.83 250,000 255,428 12/01/23 5.00% ca .O CD 2,803,516 0.91 2,803,516 2,803,516 12/28/23 2.08% CD 245,000 0.91 245,000 245,000 12/28/23 1.49% LL Bonds 2,004,464 0.96 2,000,000 1,998,622 01/16/24 4.81% >, Bonds 954,866 1.19 1,000,000 947,519 04/10/24 0.35% C Bonds 996,082 1.38 1,000,000 974,868 06/17/24 2.80% O Bonds 992,693 1.42 1,000,000 960,143 07/02/24 1.75% ce) Bonds 950,774 1.80 1,000,000 935,448 11/18/24 0.90% p Bonds 207,260 1.84 200,000 191,802 12/01/24 2.10% N Bonds 974,798 2.12 1,000,000 985,104 03/13/25 3.75% R 7 Bonds 969,524 2.49 1,000,000 978,916 07/28/25 3.60% C t9 Note 964,597 2.54 1,000,000 976,953 08/15/25 3.13% TOTAL SECURITIES 17,559,990 1.28 17,498,516 17,179,586 r- Washington State Local Gov't Investment Pool Snohomish County Local Gov't Investment Pool TOTAL PORTFOLIO Issuer Diversification Seattle WA - Muni, 11% First Financial Kent WA, Spokane 1% CD, 17% County FHLMC, 11% WA, 1% FHLB, 40% 11,989,948 11,989,948 Demand 4.39% 43,195,125 43,195,125 Demand 2.07% $ 72,683,589 $ 72,364,658 Checki ng, Cash and Investment Balances $2.0 , 3% (in $ Millions) Note, 1.0 , Bonds, State LGI P, 1% 13.5,18% 12.0,1 ° CD's, 3.0 , 4% County LGIP, 43.2 58% 1 Packet Pg. 5 1 I 2.2.a I INVESTMENT PORTFOLIO SUMMARY $1,400, 000 $1,200, 000 $1,000, 000 $800,000 $600,000 $400,000 $200,000 Annual Interest Income 2 Packet Pg. 6 GENERAL FUND SUMMARY I 2.2.a I 10,000,000 9,000,000 8,000, 000 7,000, 000 6,000, 000 5,000, 000 4,000,000 3,000,000 2,000,000 J# 1,000, 000 February General Fund Revenues and Expenses (Rolling 24 months) General Fund Revenues General Fund Expenses May August November February May August November General Fund Tax Revenue (2017 through 2022 Sales Tax Property Tax EMS Tax Other Taxes 12,000,000 10,000,000 8,000,000 - — 6,000, 000 4,000, 000 2,000, 000 2017 2018 2019 2020 2021 2022 2,000,000 1,500,000 1,000,000 $879,231 500,000 Sales Tax General Fund Tax Revenue (2023 YTD) $26,466 Property Tax $744,367 $10,534 EMS Tax Other Taxes O d C c ii t c O CM N O N M 0 C M a 3 Packet Pg. 7 I 2.2.a I City of Edmonds, WA Monthly Revenue Summary -General Fund 2023 General Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 2,705,668 $ 2,705,668 $ 2,320,252-14.24% February 5,364,114 2,658,446 March 8,078,207 2,714,094 April 11,430,400 3,352,193 May 21,367,690 9,937,290 June 24,267,140 2,899,450 July 27,088,437 2,821,297 August 30,319,369 3,230,932 September 32,979,295 2,659,927 October 37,350,954 4,371,659 November 47,051,259 9,700,305 December 49,991,791 2,940,532 City of Edmonds, WA Monthly Revenue Summary -Real Estate Excise Tax 2023 Real Estate Excise Tax 1 & 2 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 343,196 $ 343,196 $ 151,084-55.98% February 564,002 220,806 March 914,189 350,187 April 1,199,839 285,649 May 1,552,936 353,097 June 1,933,322 380,387 July 2,318,897 385,574 August 2,728,590 409,693 September 3,157,962 429,373 October 3,549,820 391,858 November 3,941,307 391,487 December 4,400,000 458,693 *The monthly budget forecast columns are based on a five-year average. 4 Packet Pg. 8 SALES TAX SUMMARY I 2.2.a I Sales Tax Analysis By Category Current Period: January 2023 Year -to -Date Total $879,231 Amusement Automotive Repair, R reation, Business Services, Construction Trade, $17,699 $6,112 $100,576 $126,349 Health & Personal Accommodation, $3,538 Care, $7,015 Gasoline, $0 Clothing and Retail Food Stores, $30,347 Accessories, Retail Automotive, ConiMr7iM ions, $203,099 $19,415 Misc Retail, $186,662 Wholesale Trade, $25,855 Manufacturing, $11,855 Others, $10,468 Eating & Drinking, $98,463 12,000,000 10,000, 000 $7,395,114 $8,406,296 8,000,000 6,000,000 4,000,000 2,000,000 0 Annual Sales Tax Revenue $10,302,518 715 $8,317,046 2017 2018 2019 $879,231 2020 2021 2022 YTD 2023 5 I Packet Pg. 9 I 2.2.a I City of Edmonds, WA Monthly Revenue Summary -Sales and Use Tax 2023 Sales and Use Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 911,577 $ 911,577 $ 879,231 -3.55% February 1,999,408 1,087,831 March 2,854,859 855,451 April 3,643,225 788,366 May 4,624,484 981,259 June 5,567,972 943,488 July 6,580,085 1,012,114 August 7,669,335 1,089,249 September 8,683,583 1,014,248 October 9,768,647 1,085,064 November 10,864,900 1,096,253 December 11,900,000 1,035,100 City of Edmonds, WA Monthly Revenue Summary -Real Personal/Property Tax 2023 Real Personal/Property Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 49,915 $ 49,915 $ 26,466 0.00% February 78,108 28,192 March 375,054 296,947 April 912,236 537,182 May 5,909,096 4,996,860 June 6,029,957 120,861 July 6,148,773 118,816 August 6,198,768 49,995 September 6,260,415 61,647 October 6,466,132 205,717 November 11,227,156 4,761,024 December 11,327,000 99,844 Real PersonaWroperty Tax 12,000,000 11,000, 000 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 0� JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget Prior Year *The monthly budget forecast columns are based on a five-year average. 6 Packet Pg. 10 I 2.2.a I City of Edmonds, WA Monthly Revenue Summary -Water Utility Tax 2023 Water Utility Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 86,205 $ 86,205 86,092 -0.13% February 146,468 60,263 March 232,107 85,639 April 288,835 56,728 May 373,578 84,744 June 439,121 65,542 July 541,031 101,910 August 629,368 88,337 September 748,356 118,987 October 835,253 86,898 November 933,046 97,793 December 993,712 60,666 Sewer Utility Tax Water Utility Tax 1,000,000 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --6--- Current Yeaz Budget � Prior Year City of Edmonds, WA Monthly Revenue Summary -Sewer Utility Tax 2023 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 95,852 $ 95,852 $ 89,935 -6.17% February 174,661 78,808 March 269,654 94,993 April 348,626 78,972 May 444,771 96,145 June 523,850 79,080 July 620,193 96,343 August 699,682 79,489 September 799,189 99,507 October 879,620 80,432 November 976,901 97,281 December 1,055,821 78,920 Sewer Utility Tax 1,zuu,uuV 1,100,000 1,000,000 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -*-- Current Yeaz Budget -d-- Prior Year *The monthly budget forecast columns are based on a five-year average. Packet Pg. 11 I 2.2.a I City of Edmonds, WA Monthly Revenue Summary -Meter Water Sales 2023 Meter Water Sales Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 898,592 $ 898,592 $ 860,924 -4.19% February 1,526,893 628,301 March 2,419,579 892,685 April 3,010,919 591,341 May 3,894,276 883,356 June 4,577,455 683,180 July 5,644,291 1,066,835 August 6,565,058 920,767 September 7,805,695 1,240,637 October 8,711,524 905,829 November 9,730,927 1,019,403 December 10,363,937 633,010 City of Edmonds, WA Monthly Revenue Summary -Storm Water Sales 2023 Storm Water Sales Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 484,003 $ 484,003 $ 417,703-13.70% February 1,535,452 1,051,449 March 2,020,122 484,671 April 2,451,545 431,422 May 2,936,868 485,323 June 3,368,111 431,243 July 3,844,019 475,908 August 4,895,662 1,051,643 September 5,380,996 485,335 October 5,812,621 431,625 November 6,298,011 485,390 December 6,714,303 416,292 Storm Water Sales 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget ter- Prior Year *The monthly budget forecast columns are based on a five-year average. Packet Pg. 12 I 2.2.a I City of Edmonds, WA Monthly Revenue Summary-Unmeter Sewer Sales 2023 Unmeter Sewer Sales Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 958,430 $ 958,430 $ 900,021 -6.09% February 1,745,646 787,217 March 2,695,497 949,850 April 3,484,346 788,849 May 4,445,696 961,351 June 5,235,623 789,927 July 6,198,081 962,458 August 6,992,099 794,018 September 7,987,044 994,945 October 8,790,485 803,441 November 9,763,192 972,707 December 10,551,011 787,819 Unmeter Sewer Sales 11,000,000 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 0 T. JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC � Current Year Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. 9 Packet Pg. 13 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -General Fund 2023 General Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 5,345,621 $ 5,345,621 $ 4,868,760 -8.92% February 9,636,483 4,290,862 March 13,866,623 4,230,140 April 17,927,184 4,060,561 May 22,306,575 4,379,392 June 27,357,557 5,050,981 July 31,669,662 4,312,105 August 35,821,651 4,151,989 September 40,439,497 4,617,846 October 45,021,003 4,581,507 November 50,136,092 5,115,089 December 55,716,788 5,580,696 Non -Departmental General Fund 60,000,000 55,000,000 50,000,000 45,000,000 40,000,000 35,000,000 30,000,000 25,000,000 20,000,000 15,000,000 10,000,000 5,000,000 OI JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Yeaz Budget Prior Year City of Edmonds, WA Monthly Expenditure Report -Non -Departmental 2023 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 2,219,693 $ 2,219,693 $ 1,642,894-25.99% February 3,383,447 1,163,755 March 4,450,950 1,067,502 April 5,373,248 922,298 May 6,528,731 1,155,483 June 8,240,442 1,711,711 July 9,257,316 1,016,874 August 10,128,621 871,305 September 11,305,253 1,176,632 October 12,392,700 1,087,447 November 13,735,570 1,342,870 December 15,180,425 1,444,855 *The monthly budget forecast columns are based on a five-year average. 10 Packet Pg. 14 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -City Council 2023 City Council Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 31,168 $ 31,168 $ 33,649 7.96% February 64,726 33,558 March 102,768 38,042 April 139,148 36,380 May 185,610 46,462 June 234,717 49,107 July 271,512 36,795 August 321,665 50,154 September 360,348 38,683 October 393,400 33,052 November 434,929 41,529 December 480,256 45,327 Office of Mayor City Council 500,000 45 0, 000 400,000 350,000 300,000 25 0, 000 200,000 - 150,000 100,000 50,000 0 1 1 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC �Cuirent Year Budget Pdor Yea City of Edmonds, WA Monthly Expenditure Report -Office of Mayor 2023 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 40,530 $ 40,530 $ 33,343-17.73% February 82,920 42,390 March 123,864 40,944 April 165,624 41,760 May 206,480 40,855 June 246,845 40,365 July 288,014 41,169 August 328,829 40,815 September 369,857 41,028 October 410,050 40,193 November 452,572 42,522 December 495,273 42,701 *The monthly budget forecast columns are based on a five-year average. 11 Packet Pg. 15 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -Human Resources 2023 Human Resources Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 111,879 $ 111,879 $ 93,116-16.77% February 212,590 100,710 March 304,874 92,285 April 402,099 97,225 May 499,035 96,936 June 630,337 131,302 July 716,800 86,464 August 811,438 94,638 September 913,015 101,577 October 1,008,222 95,207 November 1,118,413 110,191 December 1,254,947 136,534 Municipal Court Human Resources 1,300,000 11200,000 1,100,000 1,000,000 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 - 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget Prior Year City of Edmonds, WA Monthly Expenditure Report -Municipal Court 2023 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 107,783 $ 107,783 $ 114,975 6.67% February 217,016 109,233 March 329,502 112,486 April 443,331 113,829 May 565,420 122,088 June 677,638 112,218 July 792,551 114,913 August 920,812 128,261 September 1,038,313 117,501 October 1,160,412 122,099 November 1,306,850 146,438 December 1,451,763 144,913 *The monthly budget forecast columns are based on a five-year average. 12 Packet Pg. 16 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -Community Services/Economic Development 2023 Community Services/Economic Development Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 69,708 $ 69,708 $ 84,200 20.79% February 146,333 76,625 March 225,121 78,788 April 300,489 75,367 May 378,449 77,960 June 457,768 79,319 July 540,740 82,972 August 639,556 98,816 September 731,932 92,376 October 828,147 96,215 November 951,613 123,466 December 1,105,451 153,838 Community Services/Economic Development 1,200,000 1,100,000 1,000,000 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -*-- Current Yeaz Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. 13 Packet Pg. 17 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report - Fund 512 - Technology Rental Fund 2023 FYtnd 512 - Technology Rental Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 200,229 $ 200,229 $ 355,645 77.62% February 331,818 131,590 March 511,956 180,138 April 583,801 71,845 May 686,199 102,398 June 802,985 116,786 July 889,949 86,965 August 1,019,658 129,709 September 1,149,670 130,012 October 1,295,610 145,939 November 1,391,406 95,796 December 1,617,205 225,799 Administrative Services Fund 512 - Technology Rental Fund 1,800,000 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget � Prior Year City of Edmonds, WA Monthly Expenditure Report -Administrative Services 2023 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 234,130 $ 234,130 $ 253,437 8.25% February 398,050 163,920 March 562,597 164,548 April 731,035 168,438 May 898,492 167,457 June 1,126,724 228,231 July 1,316,328 189,604 August 1,484,904 168,576 September 1,654,403 169,499 October 1,831,412 177,009 November 2,030,169 198,756 December 2,203,636 173,467 Administrative Services 1,800,000 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -*-Current Year Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. 14 Packet Pg. 18 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -City Attorney 2023 City Attorney Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 96,815 $ 96,815 $ 24,570-74.62% February 193,630 96,815 March 290,445 96,815 April 387,260 96,815 May 484,075 96,815 June 580,890 96,815 July 677,705 96,815 August 774,520 96,815 September 871,335 96,815 October 968,150 96,815 November 1,064,965 96,815 December 1,161,780 96,815 Police City of Edmonds, WA Monthly Expenditure Report -Police 2023 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 1,163,207 $ 1,163,207 $ 1,041,369-10.47% February 2,325,164 1,161,957 March 3,539,820 1,214,656 April 4,711,460 1,171, 639 May 5,925,620 1,214,160 June 7,207,679 1,282,059 July 8,426,096 1,218,417 August 9,573,799 1,147,703 September 10,782,176 1,208,377 October 12,034,062 1,251,887 November 13,502,037 1,467,974 December 14,981,027 1,478,990 Police 15,000,000 14,000,000 13,000,000 12,000,000 11,000,000 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC � Current Year Budget �Prior Year *The monthly budget forecast columns are based on a five-year average. 15 Packet Pg. 19 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -Development Services 2023 Planning & Development Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 347,462 $ 347,462 $ 286,492-17.55% February 713,406 365,944 March 1,064,835 351,429 April 1,435,462 370,628 May 1,799,819 364,357 June 2,162,115 362,296 July 2,557,600 395,486 August 2,928,740 371,139 September 3,315,666 386,926 October 3,700,453 384,787 November 4,115,049 414,597 December 4,594,584 479,535 Parks & Recreation Planning & Development 5,000,000 4,500,000 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC —*-- Current Year Budget � Prior Year City of Edmonds, WA Monthly Expenditure Report -Parks & Recreation 2023 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 419,238 $ 419,238 $ 589,720 40.66% February 877,712 458,474 March 1,336,230 458,519 April 1,795,549 459,318 May 2,265,114 469,566 June 2,763,462 498,348 July 3,308,655 545,192 August 3,873,351 564,696 September 4,481,385 608,035 October 4,980,826 499,441 November 5,490,595 509,769 December 6,022,817 532,222 *The monthly budget forecast columns are based on a five-year average. 16 Packet Pg. 20 I 2.2.a I City ofEdmonds, WA Monthly Expenditure Report - Fund 016 - Building Maintenance Fund 2023 Fund 016 - Building Maintenance Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ $ $ 81,158 0.00% February $ March 587,859 $ 587,859 April 607,500 $ 19,641 May 607,500 $ - June 607,500 $ July 607,500 $ August 607,500 $ September 607,500 $ October 607,500 $ - November 705,451 $ 97,951 December 1,215,000 $ 509,549 Facilities Maintenance Fund 016 - Building Maintenance Fund 1,200,000 1,100,000 1,000,000 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget - Prior Year City of Edmonds, WA Monthly Expenditure Report -Facilities Maintenance 2023 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 141,704 $ 141,704 $ 335,018 136.42% February 323,896 182,192 March 512,975 189,079 April 693,250 180,275 May 857,198 163,948 June 992,135 134,936 July 1,156,000 163,866 August 1,368,753 212,753 September 1,614,811 246,058 October 1,888,628 273,817 November 2,114,407 225,779 December 2,472,445 358,038 *The monthly budget forecast columns are based on a five-year average. 17 Packet Pg. 21 I 2.2.a I City of Edmonds, WA Monthly Expenditure Report -Engineering 2023 Engineering Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 252,507 $ 252,507 $ 261,418 3.53% February 506,039 253,532 March 764,005 257,966 April 1,025,281 261,275 May 1,311,065 285,784 June 1,574,953 263,888 July 1,849,982 275,029 August 2,119,149 269,167 September 2,379,906 260,757 October 2,645,006 265,100 November 2,934,322 289,316 December 3,224,439 290,117 Engine a ring 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC —*-- Current Yeaz Budget Prior Yew *The monthly budget forecast columns are based on a five-year average. 18 Packet Pg. 22 I 2.2.a I Page 1 of 1 C r1Y OF EDMONDS REVENUES BY FUND - SUMMARY Fund 2023 Adopted 1/31/2022 1/31/2023 Amount No. Title Budget Revenues Revenues Remaining %Received 001 GENERAL FUND $ 49,991,791 $ 2,186,816 $ 2,320,252 $ 47,671,539 50/c 009 LEOFF-MEDICAL INS. RESERVE 225,000 - - 225,000 00/c Ol l RISK MANAGEMENT RESERVE FUND - - 00/c 014 HISTORIC PRESERVATION GIFT FUND - - - - 00/c 016 BUILDING MAINTENANCE FUND 17,480 2,154 7,854 9,626 450/( 017 MARSH RESTORATION & PRESERVATION FUND 00/, r- O 018 EDMONDS HOMELESSNESS RESPONSE FUND - - - - 00/, d 104 DRUG ENFORCEMENT FUND 167,650 350 127 167,523 00/( O Ill STREET FUND 1,815,410 109,840 120,069 1,695,341 70/c 'v C 112 COMBINED STREET CONST/IMPROVE 8,308,065 17,272 14,713 8,293,352 00/( 117 MUNICIPAL ARTS ACQUIS. FUND 98,098 66,051 1,283 96,815 10/c LL 118 MEMORIAL STREET TREE - - - - 00/c 120 HOTEL/MOTEL TAX REVENUE FUND 84,400 7,443 7,918 76,482 r� 9°% C 121 EMPLOYEE PARKING PERMIT FUND 38,960 6,544 9,050 29,910 230/c M 122 YOUTH SCHOLARSHIP FUND 1,660 66 29 1,631 2°% C 123 TOURISM PROMOTIONAL FUND/ARTS 30,440 2,803 2,799 27,641 N 90/( 125 REAL ESTATE EXCISE TAX 2 2,320,090 86,739 81,737 2,238,353 40/, 126 REAL ESTATE EXCISE TAX 1 2,302,980 83,970 82,970 2,220,010 40/c _ to 127 GIFT S CATALOG FUND 135,340 30,682 9,751 125,589 70/( v 130 CEMETERY MAINTENANCE/IMPROVEMT 150,960 21,909 23,518 127,442 160/c O Q. 136 PARKSTRUST FUND 5,460 785 303 5,157 60/, 137 CEMETERY MAINTENANCE TRUST FD 51,500 7,454 4,628 46,872 90/, �p 138 SISTER CITY COMMISSION 10,430 72 37 10,393 .O 00/c C O 140 BUSINESS IMPROVEMENT DISTRICT 88,645 26,615 29,798 58,847 340/c r- IL 141 AFFORDABLE AND SUPPORTIVE HOUSINGFUND 65,000 7,392 7,639 57,361 120/c 142 EDMONDS RESCUE PLAN FUND 1,249,000 - 350 1,248,650 00/c r C 143 TREE FUND 215,100 95 425 214,675 00/, 231 2012 LT GO DEBT SERVICE FUND 309,800 - - 309,800 00/( rM N 332 PARKS CAPITAL CONSTRUCTION FUND 927,205 8,968 341 926,864 00/, N 411 COMBINED UTILITY OPERATION - 15,140 11,010 (11,010) 0% M 421 WATER UTILITYFUND 11,950,114 945,211 986,743 10,963,371 80/c 422 STORM UTILITY FUND 8,903,407 463,073 471,107 8,432,300 50/c -Oj 423 SEWER/WWTP UTILITY FUND 15,898,844 2,368,069 1,225,668 14,673,176 80/c O 424 BOND RESERVE FUND 1,991,860 1 - 1,991,860 00/1 E 511 EQUIPMENT RENTAL FUND 4,188,740 164,644 192,708 3,996,032 501, V O 512 TECHNOLOGY RENTAL FUND 1,413,372 99,804 117,106 1,296,266 8% Q $ 112,956,801 $ 6,729,964 $ 5,729,932 $ 107,226,869 50/t 19 Packet Pg. 23 I 2.2.a I Page 1 of 1 CITY OF EDMONDS EXPENDITURES BY FUND - SUMMARY Fund 2023 Adopted 1/31/2022 1/31/2023 Amount No. Title Budget Expenditures Expenditures Remaining %Spent 001 GENERAL FUND $ 55,716,788 $ 4,585,579 $ 4,868,760 $ 50,848,028 90/( 009 LEOFF-MEDICAL INS. RESERVE 367,140 24,608 27,422 339,718 70/c O11 RISK MANANGEMENT RESERVE FUND 25,000 - - 25,000 0% 014 HISTORIC PRESERVATION GIFT FUND 5,900 - - 5,900 0% 016 BUILDING MAINTENANCE FUND 1,215,000 - 81,158 1,133,842 70/c 017 MARSH RESTORATION & PRESERVATION FUND - - - 0% r- O 018 EDMONDS HOMELESSNESS RESPONSE FUND - - - 00/, 019 EDMONDS OPIOID RESPONSE FUND - - - - 0% 104 DRUG ENFORCEMENT FUND 45,800 - - 45,800 C 111 STREET FUND 2,350,969 305,309 450,818 1,900,151 190/c 112 COMBINED STREET CONST/IMPROVE 7,214,960 592 - 7,214,960 0% LL 117 MUNICIPAL ARTS ACQUIS. FUND 182,880 1,025 475 182,405 0% 118 MEMORIAL STREET TREE - - - - r� 0% O 120 HOTEL/MOTEL TAX REVENUE FUND 95,400 2,852 3,222 92,179 30/c 121 EMPLOYEE PARKING PERMIT FUND 26,880 - - 26,880 00/c p N 122 YOUTH SCHOLARSHIP FUND 3,000 (150) - 3,000 0% 123 TOURISM PROMOTIONAL FUND/ARTS 28,500 - 780 27,720 3% 125 REAL ESTATE EXCISE TAX 2 2,473,362 113,698 7,348 2,466,014 C 00/c cC 126 REAL ESTATE EXCISE TAX 1 1,631,812 - - 1,631,812 0% 127 GIFTSCATALOGFUND 497,598 2,114 3,731 493,867 1% 0 CL 130 CEMETERY MAINTENANCE/IMPROVEMT 249,413 12,170 32,414 216,999 130/c 136 PARKS TRUST FUND - - - - 00/, iC 137 CEMETERY MAINTENANCE TRUST FUND 25,000 - - 25,000 00/c C O 138 SISTER CITY COMMISSION 11,900 - - 11,900 00/c LL 140 BUSINESS IMPROVEMENT DISTRICT 88,575 66 17 88,558 00/c >% 142 EDMONDS RESCUE PLAN FUND 1,249,000 8,697 241,583 1,007,417 190/c 143 TREE FUND 239,800 - - 239,800 0% 231 2012 LT GO DEBT SERVICE FUND 309,800 - - 309,800 0% N 332 PARKS CAPITAL CONSTRUCTION FUND 468,950 776,108 141,463 327,487 30% N 421 WATER UTILITY FUND 11,335,050 395,325 688,320 10,646,730 60/c 422 STORM UTILITY FUND 7,603,123 297,134 409,316 7,193,807 5% C O 423 SEWER/WWTP UTILITY FUND 15,381,246 813,268 1,340,398 14,040,848 90/( 424 BOND RESERVE FUND 1,989,820 - - 1,989,820 r-� 0% 511 EQUIPMENT RENTAL FUND 3,695,807 134,328 423,902 3,271,905 11% 512 TECHNOLOGY RENTAL FUND 1,617,205 216,858 355,645 1,261,560 220/c r 617 FIREMEN'S PENSION FUND - - - - 00/c Q $ 116,145,678 $ 7,689,581 $ 9,076,775 $ 107,068,903 80/c 20 Packet Pg. 24 2.2.a Page 1 of 3 C PIY OF EDMO NDS REVENUES - GENERAL FUND 2023 Adopted 1/31/2022 1/31/2023 Amount Title Budget Revenues Revenues Remaining %Received TAXES: 1 REAL PERSONAL / PROPERTY TAX 2 EMSPROPERTY TAX 3 VOTED PROPERTY TAX 4 LOCAL RETAIL SALESIUSE TAX 1 5 NATURAL GAS USE TAX 6 1/10 SALES TAX LOCAL CRIM JUST 7 ELECTRIC UTILITY TAX 8 GAS UTILITY TAX 9 SOLID WASTE UTILITY TAX 10 WATERUTILITY TAX 11 SEWERUTILITYTAX 12 SI'ORMWATERUTILITY TAX 13 T.V. CABLE UTILITY TAX 14 TELEPHONE UTILITY TAX 15 PULLTABSTAX 16 AMUSEMENT GAMES 17 LEASEHOLD EXCISE TAX LIC INS ES AND PERMITS: 18 FIRE PERMITS -SPECIAL USE 19 POLICE -FINGERPRINTING 20 VENDING MACHINE/CONCESSION 21 FRANCHISE AGREEMENT-COMCASf 22 FRANCHISE FEE-EDUCATION/GOVERNMENT 23 FRANCHISE AGREEMENT-ZIPLY FIBER 24 OLYMPIC VIEW WATER DISTRICT FRANCHISE 25 GENERAL BUSINESS LICENSE 26 DEV SERV PERMIT SURCHARGE 27 RIGHT OF WAY FRANCHISE FEE 28 BUILDING STRUCTURE PERMITS 29 ANIMAL LICENSES 30 STREET AND CURB PERMIT 31 OTR NON -BUS LIC/PERMITS 32 SPECIAL EVENT REVIEW INTERGOVERNMENTAL: 33 DOJ 15-0404-0-1-754 - BULLET PROOF VEST 34 HIGH VISIBILITY ENFORCEMENT 35 CORONAVIRUS RELIEF FUND 36 Sr ATE GRANTS - BUDGET ONLY 37 PUD PRIVILEDGE TAX 38 TRIAL COURT IMPROVEMENT 39 CJ - POPULATION 40 CRIMINAL JUSTICE -SPECIAL PROGRAMS 41 MARIJUANA EXCISE TAX DISTRIBUTION 42 DUI - CITIES 43 LIQUOR EXCISE TAX 44 LIQUOR BOARD PROFITS 45 MISCELLANEOUS INTERLOCAL REVENUE 46 FIRST RESPONDERS FLEX FUND 47 DISCOVERY PROGRAMS TECHNOLOGY ACQ. $ 11,327,000 $ - $ 26,466 $ 11,300,534 00/c 4,578,000 - 10,534 4,567,466 00/( 500 - - 500 00/( 11,900,000 857,872 879,231 11,020,769 70/( 7,600 1,711 - 7,600 00/( 1,150,000 83,949 85,227 1,064,773 70/( 1,900,000 183,023 185,846 1,714,154 100/( 845,000 96,596 125,375 719,626 1501( 384,000 19,424 30,272 353,728 80/( 1,000,234 82,771 86,092 914,142 90/( 942,960 87,637 89,935 853,025 100/( 621,458 41,773 41,771 579,687 70/c 850,000 69,365 66,442 783,558 80/( 773,000 43,844 14,206 758,794 20/( 80,200 11,095 19,201 60,999 240/( 350 - - 350 0°/ 326,000 0.1 0.2 326,000 00/( 36,686,302 1,579,061 1,660,598 35,025,704 501, 250 - - 250 00/c 700 - 75 625 110/( 94,500 3,650 12,476 82,024 130/( 702,700 179,444 - 702,700 00/c 41,000 3,060 2,796 38,204 70/( 100,600 - - 100,600 00/( 450,000 - 101,463 348,537 230/c 250,000 23,825 24,287 225,713 100/( 80,000 8,220 6,360 73,640 80/( 30,000 30,173 13,962 16,038 470/( 750,600 31,790 32,405 718,196 4°/ 24,000 5,249 7,060 16,940 290/( 75,000 (13,958) 5,830 69,170 80/c 20,000 - 1,664 18,336 80/( - 1,250 - - 00/( 2,619,350 272,703 208,378 2,410,972 80% 9,000 5,237 - 9,000 00/( 11,100 718 - 11,100 00/c 1,419,875 - - 1,419,875 00/( 125,000 - - 125,000 00/( 210,500 - - 210,500 00/( 16,740 - - 16,740 00/( 13,070 3,571 3,758 9,312 290/( 50,600 12,693 13,294 37,306 260/( 125,000 - - 125,000 00/( 4,500 1,793 53 4,448 10/( 325,000 72,230 71,223 253,777 220/( 343,200 - - 343,200 00/( - - 500 (500) 00/( 1,000 - - 1,000 00/( 550 - - 550 00/( 2,655,135 96,243 88,828 2,566,307 30% 2022 Local Retail Sales/Use Tax revenues are $21,359 higher than 2021 revenues. Please also see pages pages 5 & 6. 21 1 Packet Pg. 25 1 2.2.a Page 2 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2023 Adopted 1/31/2022 1/31/2023 Amount Title Budget Revenues Revenues Remaining %Received CHARGES FOR GOODS AND SERVICES: 1 RECORD/LEGAL INSTRUMENTS 2 ATM SURCHARGE FEES 3 CREDIT CARD FEES 4 COURT RECORD SERVICES 5 D/M COURT REC SER 6 WARRANT PREPARATION FEE 7 IT TIME PAY FEE 8 MUNIC.-DIST. COURT CURR EXPEN 9 CLERKS TIME FOR SALE OF PARKING PERMITS 10 PHOTOCOPIES 11 POLICE DISCLOSURE REQUESTS 12 ENGINEERING FEES AND CHARGES 13 ELECTION CANDIDATE FILINGFEES 14 CUSTODIAL SERVICES(SNO-ISLE) 15 PASSPORTS AND NATURALIZATION FEES 16 POLICE SERVICES SPECIAL EVENTS 17 CAMPUS SAFETY-EDM. SCH. DIST. 18 WOODWAY-LAW PROTECTION 19 MISCELLANEOUS POLICE SERVICES 20 FIRE DISTRICT #1 STATION BILLINGS 21 LEGAL SERVICES 22 ADULT PROBATION SERVICE CHARGE 23 BOOKING FEES 24 FIRE CONSTRUCTION INSPECTION FEES 25 EMERGENCY SERVICE FEES 26 EMS TRANSPORT USER FEE 27 FLEX FUEL PAYMENTS FROM STATIONS 28 ZONING/SUBDIVISION FEE 29 BUILDING PLAN REVIEW AND INSPECTION 30 FIRE PLAN REVIEW 31 PLANNING REVIEW AND INSPECTION 32 S.E.P.A. REVIEW 33 CRITICAL AREA STUDY 34 GYM AND WEIGHTROOM FEES 35 PROGRAM FEES 36 HOLIDAY MARKET REGISTRATION FEES 37 UP TOWN EVENING MARKET FEES 38 WINTER MARKET FEES 39 BIRD FEST REGISTRATION FEES 40 INTERFUND REIMBURSEMENT -CONTRACT SVCS $ 3,000 $ 317 $ - $ 3,000 00/c 600 22 16 584 30/( 6,000 183 - 6,000 00/c 150 - - 150 00/( 300 - - 300 00/( 4,000 - - 4,000 00/c 1,000 31 6 994 10/( 50 5 32 18 650/( 25,000 - - 25,000 00/( 100 - - 100 0°/ 1,000 - - 1,000 00/c 190,000 15,852 9,238 180,762 501( 1,400 - - 1,400 00/( 100,000 600 11,605 88,395 120/( 5,000 490 2,380 2,620 480/( 30,000 - - 30,000 0"/ 14,000 - - 14,000 00/( 210,970 - 56,856 154,114 270/( - 13 - - 00/c 67,000 15,373 19,794 47,206 300/( 1,050 26 - 1,050 0"/ 38,000 1,797 643 37,357 20/( 3,000 39 21 2,979 1°/ 10,000 2,625 1,300 8,700 130/( 3,500 64 59 3,441 2°/ 1,077,500 - - 1,077,500 0"/ 5,000 318 303 4,697 60/c 65,600 8,525 12,960 52,640 200/( 425,000 18,436 40,074 384,926 9"/ 4,000 1,728 1,422 2,578 360/( 500 - - 500 00/( 3,000 - 740 2,260 250/( 14,000 2,345 1,705 12,295 120/( 13,000 16 1,138 11,862 90/( 990,959 (8,999) 29,730 961,229 30/c 5,000 - 455 4,545 90/( 5,000 - - 5,000 00/( 5,000 3,290 4,680 320 940/( 1,000 - - 1,000 0°/ 3,427,765 98,208 106,755 3,321,010 30/( 6,757,444 161,302 301,913 6,455,531 40% 22 Packet Pg. 26 2.2.a Page 3 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2023 Adopted 1/31/2022 1/31/2023 Amount Title Budget Revenues Revenues Remaining %Received FINES AND PENALTIES: 1 PROOF OF VEHICLE INS PENALTY 2 TRAFFIC INFRACTION PENALTIES 3 NC TRAFFIC INFRACTION 4 CRT COST FEE CODE LEG ASSESSMENT (LGA) 5 NON -TRAFFIC INFRACTION PENALTIES 6 OTHERINFRACTIONS'04 7 PARKING INFRACTION PENALTIES 8 PARK/INDDISZONE 9 DWI PENALTIES 10 DUI - DP ACCT 11 CRIM CNV FEE DUI 12 DUI - DP FEE 13 CRIMINAL TRAFFIC MISDEMEANOR 8/03 14 CRIMINAL CONVICTION FEE CT 15 CRIM CONV FEE CT 16 OTHER NON-T RAF MISDEMEANOR PEN 17 OTHER NON TRAFFIC MISD. 8/03 18 COURT DV PENALTY ASSESSMENT 19 CRIMINAL CONVICTION FEE CN 20 CRIM CONV FEE CN 21 PUBLIC DEFENSE RECOUPMENT 22 BANK CHARGE FOR CONY. DEFENDANT 23 COURT COST RECOUPMENT 24 BUS. LICENSE PERMIT PENALTY 25 MISC FINES AND PENALTIES MISCELLANEOUS: 26 INVESTMENT INTEREST 27 INTEREST ON COUNTY TAXES 28 INTEREST - COURT COLLECTIONS 29 LOAN INTEREST 30 SPACE/FACILITIESRENTALS 31 BRACKET ROOM RENTAL 32 LEASESLONG-TERM 33 DONATION/CONTRIBUTION 34 PARKSDONATIONS 35 BIRD FEST CONTRIBUTIONS 36 POLICE CONTRIBUTIONS FROM PRIV SOURCES 37 SALE OF JUNK/SALVAGE 38 SALES OF UNCLAIM PROPERTY 39 CONFISCATED AND FORFEITED PROPERTY 40 OTHER JUDGEMENT/SETTLEMENT 41 POLICE JUDGMENTS/RESTITUTION 43 OTHER MISC REVENUES 44 SMALL OVERPAYMENT 45 NSF FEES - PARKS & REC 46 NSF FEES - MUNICIPAL COURT 50 US BANK REBATE TOTAL GENERAL FUND REVENUE $ 2,000 $ 147 $ 151 $ 1,849 80/( 130,000 6,182 12,824 117,176 100/( 18,000 562 208 17,792 10/( 10,000 341 317 9,683 30/( 1,000 - - 1,000 00/( 1,500 145 108 1,392 70/c 125,000 1,760 1,370 123,630 1 °/ 2,000 17 - 2,000 0°/ 7,000 240 297 6,703 40/( 300 - - 300 00/( 100 4 - 100 00/( 1,500 132 87 1,413 6°/ 25,000 590 469 24,531 20/( 2,000 95 84 1,916 40/( 700 - - 700 0°/ 100 - - 100 00/( 12,000 252 75 11,925 10/( 800 - - 800 00/( 1,000 47 13 987 10/( 200 - - 200 0°/ 6,000 155 480 5,520 80/( 4,000 295 477 3,523 120/( 1,000 - 172 828 170/( 1,000 - - 1,000 0°/ 150 - - 150 00/( 352,350 10,964 17,133 335,217 50% 321,240 44,969 19,518 301,722 6°/ 10,960 323 2,560 8,400 230/( 12,180 607 169 12,011 10/( 12,080 - - 12,080 0°/ 175,000 1,773 1,535 173,465 1 % 2,100 - - 2,100 00/( 210,000 17,594 18,869 191,131 9°/ 1,500 - - 1,500 00/( 3,500 300 500 3,000 140/( 1,500 - - 1,500 00/c 5,000 - - 5,000 00/( 300 - - 300 00/( 3,800 220 34 3,766 10/( 2,000 - - 2,000 00/( 146,000 - - 146,000 0°/ 200 - - 200 0°/ 5,000 758 216 4,784 40/( 100 - 1 99 10/( 100 - - 100 00/( 150 - 150 00/( 8,500 - - 8,500 00/( 921,210 66,543 43,402 877,808 50/( $ 49,991,791 $ 2,186,816 $ 2,320,252 $ 47,671,539 50% 23 Packet Pg. 27 I 2.2.a I Page 1 of 6 C ITY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Adopted 1/31/2022 1/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent GENERAL FUND EXPENDITURES (001) 1 SALARIES AND WAGES $ 21,585,702 $ 1,446,469 $ 1,976,003 $ 19,609,699 90/ 2 OVERTIME 649,080 95,583 75,728 573,352 120/ 3 HOLIDAY BUY BACK 294,001 - - 294,001 00/ 4 BENEFITS 7,619,904 558,402 662,382 6,957,522 90/ 5 UNIFORMS 130,851 2,922 14,473 116,378 110/ 6 PENSION AND DISABILITY PAYMENTS 165,023 5,912 7,431 157,592 501 7 SUPPLIES 759,025 12,614 10,870 748,155 to/ 8 SMALL EQUIPMENT 302,791 3,159 5,535 297,256 20/ 9 PROFESSIONAL SERVICES 17,677,872 1,552,942 1,040,754 16,637,118 60/ 10 COMMUNICATIONS 181,295 874 1,967 179,328 to/ 11 TRAVEL 74,795 557 4,360 70,435 60/ 12 EXCISE TAXES 16,500 1,241 1,365 15,135 80/ 13 RENTAL/LEASE 2,780,344 172,908 218,020 2,562,324 80/ 14INSURANCE 597,722 503,160 625,650 (27,928) 10501 15 UTILITIES 663,800 12,464 55,926 607,874 80/ 16 REPAIRS& MAINTENANCE 388,900 67,115 73,337 315,563 190/ 17 MISCELLANEOUS 502,593 99,256 94,959 407,634 190/ 18 INTERGOVERNMENTAL PAYMENTS 50,000 50,000 - 50,000 00/ 19 INTERFUND SUBSIDIES 863,000 - - 863,000 00/ 20 MACHINERY/EQUIPMENT 90,000 - 90,000 00/ 21 GENERAL OBLIGATION BOND PRINCIPAL 191,620 - 191,620 00/ 22 INTEREST ON LONG-TERM EXTERNAL DEBT 131,470 - 131,470 00/ 23 OTHER INTEREST & DEBT SERVICE COSTS 500 - - 500 00/ 55,716,788 4,585,579 4,868,760 50,848,028 9°/ LEOFF-MEDICAL INS. RESERVE(009) 24 BENEFITS $ 206,650 $ 10,187 $ 24,129 $ 182,521 120/ 25 PENSION AND DISABILITY PAYMENTS 152,990 14,421 3,293 149,697 20/ 26 PROFESSIONAL SERVICES 7,000 - - 7,000 00/ 27 MISCELLANEOUS 500 - - 500 00/ 367,140 24,608 27,422 339,718 70/ RISK MANAGEMENT RESERVEFUND (011) 28 MISCELLANEOUS $ 25,000 $ - $ - $ 25,000 00/ 25,000 - 25,000 01/ HISTORIC PRESERVATION GIFT FUND (014) 29 SUPPLIES $ 100 $ $ - $ 100 00/ 30 PROFESSIONAL SERVICES 200 - 200 00/ 31 MISCELLANEOUS 5,600 5,600 00/ 5,900 5,900 00/ BUILDING MAINTENANCEFUND (016) 32 PROFESSIONAL SERVICES $ 121,500 $ $ $ 121,500 00/ 33 REPAIR&MAINTENANCE 1,093,500 81,158 1,012,342 70/ $ 1,215,000 $ $ 81,158 $ 1,133,842 7°/ DRUG INFO RC EMENT FUND (104) 34 PROFESSIONAL SERVICES $ 45,000 $ $ - $ 45,000 00/ 35 REPAIR/MAINT 800 800 00/ 45,800 45,800 00/ 24 Packet Pg. 28 I 2.2.a I Page 2 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Adopted 1/31/2022 1/31/2023 Amount Title Budget Expenditures Expenditures Remaining % Spent STREETFUND (111) 1 SALARIES AND WAGES $ 828,313 $ 57,414 $ 224,815 $ 603,498 274 2 OVERTIME 38,400 3,914 4,014 34,386 10° 3 BENEFITS 377,585 30,443 61,857 315,728 160 4 UNIFORMS 6,000 - - 6,000 M 5 SUPPLIES 263,000 - 1,407 261,593 14 6 SMALL EQUIPMENT 20,000 - - 20,000 0° 7 PROFESSIONAL SERVICES 23,210 4,337 4,184 19,026 180 8 COMMUNICATIONS 4,500 - 128 4,372 M 9 TRAVEL 1,000 - - 1,000 04 10 RENTAL/LEASE 304,730 24,042 25,244 279,486 M 11 INSURANCE 120,821 184,111 126,467 (5,646) 105° 12 UTILITIES 273,730 - 2,703 271,027 10 13 REPAIRS & MAINTENANCE 52,000 - - 52,000 04 14 MISCELLANEOUS 8,000 1,049 - 8,000 04 15 BUILDINGS 25,000 - - 25,000 04 16 GENERAL OBLIGATION BOND PRINCIPAL 4,380 - - 4,380 04 17 INTEREST 300 - - 300 M $ 2,350,969 $ 305,309 $ 450,818 $ 1,900,151 194 COMBINED STREET CONST/IMPROVE(112) 18 PROFESSIONAL SERVICES $ 3,344,780 $ 592 $ - $ 3,344,780 04 19 INTERFUND SUBSIDIES 172,650 - - 172,650 09 20 LAND 270,000 - - 270,000 00 21 CONSTRUCTION PROJECTS 3,372,580 - - 3,372,580 M 22 INTERGOVERNMENTAL LOANS 54,070 - - 54,070 04 23 INTEREST 880 - - 880 0° $ 7,214,960 $ 592 $ - $ 7,214,960 M MUNIC IPAL ARTS ACQUIS. FUND (117) 24 SUPPLIES $ 4,700 $ - $ 475 $ 4,225 104 25 SMALL EQUIPMENT 1,700 - 1,700 04 26 PROFESSIONAL SERVICES 166,500 - 166,500 09 27 TRAVEL 80 - 80 09 28 RENTAL/LEASE 3,000 - 3,000 M 29 REPAIRS & MAINTENANCE 300 - - 300 M 30 MISCELLANEOUS 6,600 1,025 - 6,600 09 $ 182,880 $ 1,025 $ 475 $ 182,405 00 HO TEL/MO TEL TAX REVENUE FUND (120) 31 PROFESSIONAL SERVICES $ 90,400 $ 2,852 $ 3,222 $ 87,179 44 32 MISCELLANEOUS 1,000 - - 1,000 0° 33 INTERFUND SUBSIDIES 4,000 - - 4,000 04 $ 95,400 $ 2,852 $ 3,222 $ 92,179 M EMPLO YEE PARIONG PERMIT FUND (121) 34 SUPPLIES $ 1,790 $ - $ - $ 1,790 M 35 PROFESSIONAL SERVICES 25,090 - 25,090 04 $ 26,880 $ - $ - $ 26,880 0° YOUTH SCHOLARSHIP FUND (122) 36 MISCELLANEOUS $ 3,000 $ (150) $ - $ 3,000 M $ 3,000 $ (150) $ - $ 3,000 0° TOURISM PROMOTIONAL FUND/ARTS (123) 37 PROFESSIONAL SERVICES $ 28,500 $ - $ 780 $ 27,720 39 $ 28,500 $ - $ 780 $ 27,720 M 25 Packet Pg. 29 I 2.2.a I Page 3 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Adopted 1/31/2022 1/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent REAL ESTATE EXC ISE TAX 2 (125) 1 SUPPLIES $ - $ 253 $ - $ - 09 2 PROFESSIONAL SERVICES 586,957 - - 586,957 M 3 REPAIRS & MAINTENANCE 851,800 43,686 7,348 844,452 19 4 INTERFUND SUBSIDIES 5,684 - - 5,684 09 5 LAND 200,000 - 200,000 09 6 CONSTRUCTION PROJECTS 828,921 69,759 - 828,921 M $ 2,473,362 $ 113,698 $ 7,348 $ 2,466,014 09 REAL ESTATE EXCISE TAXI (126) 7 PROFESSIONAL SERVICES 8 REPAIRS & MAINTENANCE 9 INTERFUND SUBSIDIES 10 CONSTRUCTION PROJECTS 11 GENERAL OBLIGATION BONDS 12 INTEREST GIFTS CATALOG FUND (127) 13 SALARIES AND WAGES 14 BENEFIT S 15 SUPPLIES 16 SMALL EQUIPMENT 17 PROFESSIONAL SERVICES 18 RENTAL/LEASE 19 MISCELLANEOUS CEMEIERY MAINTENANCEIMPRO VEMENT (130) 20 SALARIES AND WAGES 21 OVERTIME 22 BENEFIT S 23 UNIFORMS 24 SUPPLIES 25 SUPPLIES PURCHASED FOR INVENTORY/RESALE 26 PROFESSIONAL SERVICES 27 COMMUNICATIONS 28 TRAVEL 29 RENTAL/LEASE 30 UTILITIES 31 REPAIRS & MAINTENANCE 32 MISCELLANEOUS CEMEIERY MAINTENANCE TRUST FUND (137) 33 SMALL EQUIPMENT SISTER CITY COMMISSION (138) 34 SUPPLIES 35 TRAVEL 36 MISCELLANEOUS BUSINESS IMPROVEMENT DISTRICT FUND (140) 37 SUPPLIES 38 PROFESSIONAL SERVICES 39 MISCELLANEOUS EDMONDS RESCUEPLAN FUND (142) 40 PROFESSIONAL SERVICES TREE FUND (143) 41 SUPPLIES 42 PROFESSIONAL SERVICES 43 LAND 2012 LTGO DEBT SERVIC FUND (231) 44 GENERAL OBLIGATION BOND 45 INTEREST $ 231,260 $ - $ - $ 231,260 09 457,800 - - 457,800 M 147,557 - - 147,557 09 535,755 - - 535,755 09 155,470 - - 155,470 M 103,970 - - 103,970 09 $ 1,631,812 $ - $ - $ 1,631,812 M $ 196,455 $ - $ - $ 196,455 M 80,033 - - 80,033 09 146,000 2,114 2,272 143,728 29 500 - - 500 09 56,500 - - 56,500 M 17,510 - 1,459 16,051 M 600 - - 600 09 $ 497,598 $ 2,114 $ 3,731 $ 493,867 19 $ 137,541 $ 7,143 $ 23,988 $ 113,553 179 3,500 30 - 3,500 09 54,487 3,083 6,277 48,210 129 1,000 - - 1,000 09 7,000 - 164 6,836 29 20,000 - - 20,000 09 4,200 800 793 3,407 199 1,700 140 144 1,556 89 500 - - 500 09 9,420 974 795 8,625 89 5,565 - 253 5,312 59 500 - - 500 09 4,000 - - 4,000 09 $ 249,413 $ 12,170 $ 32,414 $ 216,999 139 $ 25,000 $ - $ - $ 25,000 09 $ 25,000 $ - $ - $ 25,000 09 $ 1,500 $ - $ - $ 1,500 09 4,500 - 4,500 M 5,900 - - 5,900 M $ 11,900 $ - $ - $ 11,900 09 $ 4,091 $ - $ - $ 4,091 09 78,327 50 - 78,327 M 6,157 17 17 6,140 09 88,575 66 17 88,558 09 $ 1,249,000 $ 8,697 $ 241,583 $ 1,007,417 199 1,249,000 8,697 241,583 1,007,417 199 $ 1,000 $ $ $ 1,000 09 39,800 39,800 09 199,000 199,000 M 239,800 $ - 239,800 M $ 235,000 $ $ - $ 235,000 09 74,800 - 74,800 09 $ 309,800 $ $ $ 309,800 09 26 Packet Pg. 30 I 2.2.a I Page 4 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Adopted 1/31/2022 1/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent PARKS CONSTRUCTION FUND (332) 1 INTERFUND SUBSIDIES $ - $ 62,656 $ - $ 04 2 PROFESSIONAL SERVICES - - 2,938 (2,938) 04 3 CONSTRUCTION PROJECTS 371,300 713,452 138,526 232,774 370 4 GENERAL OBLIGATION BONDS 50,000 - - 50,000 M 5INTEREST 47,650 - - 47,650 09 $ 468,950 $ 776,108 $ 141,463 $ 327,487 30° WATER FUND (421) 6 SALARIES AND WAGES 7 OVERTIME 8 BENEFIT S 9 UNIFORMS 10 SUPPLIES 11 WATER PURCHASED FOR RESALE 12 SUPPLIES PURCHASED FOR INVENTORY/RESALE 13 SMALL EQUIPMENT 14 PROFESSIONAL SERVICES 15 COMMUNICATIONS 16 TRAVEL 17 EXCISE TAXES 18 RENTAL/LEASE 19INSURANCE 20 UTILITIES 21 REPAIRS & MAINTENANCE 22 MISCELLANEOUS 23 INTERFUND SUBSIDIES 24 BUILDINGS 25 MACHINERY/EQUIPMENT 26 CONSTRUCTION PROJECTS 27 GENERAL OBLIGATION BONDS 28 REVENUE BONDS 29 INTERGOVERNMENTAL LOANS 30 INTEREST STORM FUND (422) 31 SALARIES AND WAGES 32 OVERTIME 33 BENEFIT S 34 UNIFORMS 35 SUPPLIES 36 SMALL EQUIPMENT 37 PROFESSIONAL SERVICES 38 COMMUNICATIONS 39 TRAVEL 40 EXCISE TAXES 41 RENTAL/LEASE 42 INSURANCE 43 UTILITES 44 REPAIR & MAINTENANCE 45 MISCELLANEOUS 46 INTERFUND SUBSIDIES 47 LAND 48 BUILDINGS 49 CONSTRUCTION PROJECTS 50 GENERAL OBLIGATION BONDS 51 REVENUE BONDS 52 INTERGOVERNMENTAL LOANS 53 INTEREST $ 963,268 $ 57,765 $ 167,623 $ 795,645 17° 24,000 3,006 253 23,747 1° 393,439 25,329 43,274 350,165 110 4,000 - 551 3,449 14° 150,000 9,123 227 149,773 M 2,398,000 - - 2,398,000 04 180,000 - 11,871 168,129 74 13,500 - - 13,500 04 2,226,928 26,235 28,111 2,198,817 I4 35,000 427 1,095 33,905 34 200 - - 200 M 1,696,934 112,579 118,468 1,578,466 79 187,952 12,398 15,339 172,613 84 215,319 122,359 225,379 (10,060) 1050 35,000 - 2,993 32,007 94 71,130 10,508 11,338 59,792 164 123,600 15,596 14,514 109,086 120 646,370 - - 646,370 04 12,500 - - 12,500 00 10,000 - - 10,000 0° 1,400,000 - 47,283 1,352,717 M 2,940 - - 2,940 04 333,830 - - 333,830 04 25,840 - - 25,840 04 185,300 - - 185,300 0° $ 11,335,050 $ 395,325 $ 688,320 $ 10,646,730 69 $ 821,952 $ 62,938 $ 198,434 $ 623,518 240 26,000 3,536 1,415 24,585 54 342,317 26,681 51,177 291,140 15° 6,500 - - 6,500 04 46,000 - 1,000 45,000 24 4,000 - - 4,000 00 3,013,124 24,395 27,176 2,985,948 I4 3,200 - 24 3,176 1° 4,300 - - 4,300 04 499,658 47,280 47,866 451,792 100 293,210 21,817 23,976 269,234 M 30,265 82,335 31,680 (1,415) 105° 10,500 - 1,603 8,897 150 189,130 10,508 10,796 178,334 64 232,300 17,643 14,169 218,131 64 283,237 - - 283,237 0° 680,000 - - 680,000 04 25,000 - - 25,000 04 659,600 - - 659,600 04 107,290 - - 107,290 04 160,870 - - 160,870 0° 61,600 - - 61,600 0° 103,070 - - 103,070 0° $ 7,603,123 $ 297,134 S 409,316 $ 7,193,807 54 27 Packet Pg. 31 I 2.2.a I Page 5 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Adopted 1/31/2022 1/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent SEWER FUND (423) 1 SALARIES AND WAGES $ 2,468,518 $ 171,709 $ 440,524 $ 2,027,994 1M 2 OVERTIME 130,000 19,268 23,412 106,588 180 3 BENEFITS 867,257 60,712 122,066 745,191 140 4 UNIFORMS 11,500 2,193 888 10,612 M 5 SUPPLIES 453,000 14,143 46,146 406,854 100 6 FUEL CONSUMED 20,000 - - 20,000 M 7 SUPPLIES PURCHASED FOR INV OR RESALE 5,000 - - 5,000 M 8 SMALL EQUIPMENT 83,900 41,516 642 83,258 19 9 PROFESSIONAL SERVICES 2,517,949 92,109 93,468 2,424,481 4° 10 COMMUNICATIONS 48,000 2,740 1,476 46,524 30 11 TRAVEL 5,000 - - 5,000 09 12 EXCISE TAXES 1,026,360 103,324 105,265 921,095 1W 13 RENTAL/LEASE 312,006 25,987 25,451 286,555 M 14 INSURANCE 344,564 202,407 360,663 (16,099) 1054 15 UTILITIES 1,582,060 26,261 74,201 1,507,859 54 16 REPAIR & MAINTENANCE 728,630 39,099 19,061 709,569 M 17 MISCELLANEOUS 138,350 11,801 27,134 111,216 204 18 INTERFUND SUBSIDIES 1,588,089 - - 1,588,089 W 19 BUILDINGS 12,500 - - 12,500 04 20 CONSTRUCTION PROJECTS 2,396,163 - - 2,396,163 04 21 GENERAL OBLIGATION BONDS 129,820 - - 129,820 04 22 REVENUE BONDS 55,310 - - 55,310 W 23 INTERGOVERNMENTAL LOANS 104,000 - - 104,000 W 24INTEREST 353,270 - - 353,270 W $ 15,381,246 $ 813,268 $ 1,340,398 $ 14,040,848 94 BOND RESERVE FUND (424) 25 REVENUE BONDS $ 840,010 $ - $ - $ 840,010 W 26 INTEREST 1,149,810 - - 1,149,810 M $ 1,989,820 $ - $ - $ 1,989,820 v 28 Packet Pg. 32 I 2.2.a I Page 6 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Adopted 1/31/2022 1/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent EQ UIPMENT RENTAL FUND (511) 1 SALARIES AND WAGES $ 279,652 $ 23,511 $ 75,618 $ 204,034 274 2 OVERTIME 2,000 222 - 2,000 04 3 BENEFITS 105,497 9,848 18,292 87,205 17° 4 UNIFORMS 1,500 21 80 1,420 5° 5 SUPPLIES 149,120 5,842 2,146 146,974 14 6 FUEL CONSUMED 1,000 - - 1,000 04 7 SUPPLIES PURCHASED FOR INVENTORY/RESALE 458,880 41,653 50,024 408,856 110 8 SMALL EQUIPMENT 58,000 - - 58,000 04 9 PROFESSIONAL SERVICES 46,750 56 192 46,558 04 10 COMMUNICATIONS 3,000 - 138 2,862 5° 11 TRAVEL 1,000 - - 1,000 09 12 RENTAL/LEASE 17,470 879 1,399 16,071 89 13 INSURANCE 47,938 51,903 50,178 (2,240) 1050 14 UTILITIES 14,000 - 2,681 11,319 19° 15 REPAIRS&MAINTENANCE 60,000 - 3,851 56,149 60 16 MISCELLANEOUS 12,000 393 623 11,377 54 17 MACHINERY/EQUIPMENT 2,438,000 - 218,681 2,219,319 94 $ 3,695,807 $ 134,328 $ 423,902 $ 3,271,905 114 TECHNOLOGY RENTAL FUND (512) 18 SALARIES AND WAGES $ 600,771 $ 21,273 $ 40,955 $ 559,816 74 19 OVERTIME 2,000 - - 2,000 04 20 BENEFITS 180,554 10,460 12,215 168,339 74 21 SUPPLIES 5,000 - 78 4,922 24 22 SMALL EQUIPMENT 181,800 3,084 (1,447) 183,247 -I4 23 PROFESSIONAL SERVICES 61,860 968 - 61,860 04 24 COMMUNICATIONS 58,770 4,116 4,213 54,558 74 25 TRAVEL 1,500 - - 1,500 04 26 RENTAL/LEASE 4,640 372 137 4,503 3° 27 REPAIRS & MAINTENANCE 408,710 176,586 299,495 109,215 734 28 MISCELLANEOUS 55,600 - - 55,600 04 29 MACHINERY/EQUIPMENT 56,000 - - 56,000 04 $ 1,617,205 $ 216,858 $ 355,645 $ 1,261,560 220 TOTAL EXPENDITURE ALL FUNDS $ 116,145,678 $ 7,689,581 S 9,076,775 $ 107,068,903 84 29 Packet Pg. 33 2.2.a Page 1 of 1 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN SUMMARY Title CITY COUNCIL OFFICE OF MAYOR HUMAN RESOURCES MUNICIPAL COURT ADMINISTRATIVE SERVICES CITY ATTORNEY NON -DEPARTMENTAL POLICE SERVICES SATELLITE OFFICE COMMUNITY SERVICES/ECONOMIC DEV. DEVELOPMENT SERVICES HUMAN SERVICES PROGRAM PARKS & RECREATION PUBLIC WORKS FACILITIES MAINTENANCE 2023 Adopted 1/31/2022 1/31/2023 Amount Budget Expenditures Expenditures Remaining %Spent $ 480,256 $ 23,687 $ 33,649 $ 446,607 7% 495,273 28,255 32,343 462,930 7% 1,254,947 59,932 93,116 1,161,831 7% 1,451,763 91,643 114,975 1,336,788 8% 2,203,636 217,022 253,437 1,950,199 12% r_ O sZ 1,161,780 77,656 24,570 1,137,210 2% 15,180,425 2,083,892 1,642,894 13,537,531 11% io 14,981,027 973,358 1,041,369 13,939,658 6.95% C 145,681 3,488 8,786 136,895 6% j,L 1,105,451 33,127 84,200 1,021,251 8% t 4,594,584 309,139 286,492 4,308,092 6% O O 324,650 6,409 11,995 312,655 4% M 6,022,817 319,222 589,720 5,433,097 10% N N 3,842,053 249,545 316,193 3,525,860 8% cc 2,472,445 109,202 335,018 2,137,427 14% r- $ 55,716,788 $ 4,585,579 $ 4,868,760 $ 50,848,028 9% v CITY OF EDMO NDS EXPENDITURES - UTILITY- BY FUND IN SUMMARY Title 2023 Adopted Budget 1/31/2022 Expenditures 1/31/2023 Expenditures Amount Remaining %Spent WATER UTILITY FUND $ 11,335,050 $ 395,325 $ 688,320 $ 10,646,730 6% STORM UTILITY FUND 7,603,123 297,134 409,316 7,193,807 5% SEWER/WWTP UTILITY FUND 15,381,246 813,268 1,340,398 14,040,848 9% BOND RESERVE FUND 1,989,820 - - 1,989,820 0% $ 36,309,239 $ 1,505,728 $ 2,438,035 $ 33,871,204 7% 30 Packet Pg. 34 Page 1 of 2 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL Title 2023 Adopted Budget 1/31/2022 Expenditures 1/31/2023 Expenditures Amount Remaining %Spent CITY COUNCIL SALARIES AND WAGES $ 214,276 $ 14,460 $ 18,593 $ 195,683 9% BENEFITS 102,845 7,836 8,644 94,201 8% SUPPLIES 11,000 - 69 10,931 1 % SERVICES 152,135 1,392 6,342 145,793 4% $ 480,256 $ 23,687 $ 33,649 $ 446,607 7% OFFICEOFMAYOR SALARIES AND WAGES $ 274,988 $ 19,358 $ 21,423 $ 253,565 8% BENEFITS 88,487 7,397 7,476 81,011 8% SUPPLIES 1,500 20 265 1,235 18% Q. SERVICES 130,298 1,481 3,179 127,119 2% d $ 495,273 $ 28,255 $ 32,343 $ 462,930 7% w HUMAN RESOURCES 2 SALARIES AND WAGES $ 747,258 $ 35,351 $ 43,217 $ 704,041 6% r- BENEFITS 236,609 15,053 15,560 221,049 7% C SUPPLIES 13,600 - - 13,600 0% LL SERVICES 257,480 9,527 34,340 223,140 13% >' $ 1,254,947 $ 59,932 $ 93,116 $ 1,161,831 7% +�+ MUNICIPAL C O URT 0 O SALARIES AND WAGES $ 937,770 $ 67,478 $ 80,791 $ 856,979 9% BENEFITS 302,672 17,025 25,506 277,166 8% N SUPPLIES 11,600 - - 11,600 0% N SERVICES 199,721 7,140 8,677 191,044 4% $ 1,451,763 $ 91,643 $ 114,975 $ 1,336,788 8% ADMINIS TRATIVE S ERVIC ES C SALARIES AND WAGES $ 1,418,894 $ 109,250 $ 134,674 $ 1,284,220 9% BENEFITS 429,103 38,720 39,141 389,962 9% SUPPLIES 13,000 325 105 12,895 1% C SERVICES 342,639 68,727 79,518 263,121 23% Q. $ 2,203,636 $ 217,022 $ 253,437 $ 1,950,199 12% CITY ATPO RNEY cC SERVICES $ 1,161,780 $ 77,656 $ 24,570 $ 1,137,210 2% 'U $ 1,161,780 $ 77,656 $ 24,570 $ 1,137,210 2% NON -DEPARTMENTAL SALARIES AND WAGES $ 101,750 $ $ - $ 101,750 0% LL BENEFITS 239,583 7,172 16,905 222,678 7% s SUPPLIES 5,000 - - 5,000 0% SERVICES 13,597,502 2,026,720 1,625,989 11,971,513 12% O INTERFUND SUBSIDIES 913,000 50,000 - 913,000 0% z DEBT SERVICE - PRINCIPAL 191,620 - - 191,620 0% CO) DEBT SERVICE - INTEREST 131,970 - - 131,970 0% N $ 15,180,425 $ 2,083,892 $ 1,642,894 $ 13,537,531 11% PO LIC E SERVIC ES SALARIES AND WAGES $ 9,556,760 $ 648,581 $ 667,834 $ 8,888,926 7% BENEFITS 3,303,628 229,670 245,766 3,057,862 7% cc " SUPPLIES 342,941 2,240 1,852 341,089 1% ++ SERVICES 1,777,698 92,867 125,917 1,651,781 7% 4) O $ 14,981,027 $ 973,358 $ 1,041,369 $ 13,939,658 7% E S ATELLITE O FFIC E t SALARIES AND WAGES $ 38,537 $ $ 3,640 $ 34,897 9% a BENEFITS 7,298 692 6,606 9% SUPPLIES 12,000 3,159 - 12,000 0% SERVICES 87,846 329 4,454 83,392 5% $ 145,681 $ 3,488 $ 8,786 $ 136,895 6% 31 Packet Pg. 35 1 I 2.2.a I Page 2 of 2 C ITY OF EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2023 Adopted 1/31/2022 1/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent COMMUNITY SERVICES/ECON DEV. SALARIES AND WAGES $ 550,413 $ 17,317 $ 52,358 $ 498,055 10% BENEFITS 153,183 5,592 13,447 139,736 9% SUPPLIES 4,075 184 - 4,075 0% SERVICES 397,780 10,035 18,396 379,384 5% $ 1,105,451 $ 33,127 $ 84,200 $ 1,021,251 8% DEVELO PMEVT S ERVIC ES /PLANNING SALARIES AND WAGES $ 2,176,581 $ 216,256 $ 182,385 $ 1,994,196 8% BENEFITS 736,473 70,753 64,899 671,574 9% SUPPLIES 23,400 - 171 23,229 1 % SERVICES 1,658,130 22,130 39,038 1,619,092 2% $ 4,594,584 $ 309,139 $ 286,492 $ 4,308,092 6% HUMAN SERVICES PROGRAM SALARIES AND WAGES $ 101,849 $ 5,307 $ 9,290 $ 92,559 9% BENEFITS 29,301 1,102 2,670 26,631 9% SUPPLIES 15,000 - - 15,000 0% SERVICES 178,500 - 35 178,465 0% 324,650 6,409 11,995 312,655 4% PARKS & REC REATIO N SALARIES AND WAGES $ 2,859,976 $ 180,459 $ 403,588 $ 2,456,388 14% BENEFITS 968,480 69,475 109,575 858,905 11% SUPPLIES 468,900 8,563 3,630 465,270 1% SERVICES 1,635,461 60,725 72,926 1,562,535 4% MACHINERY/EQUIPMENT 90,000 - - 90,000 0% $ 6,022,817 $ 319,222 $ 589,720 $ 5,433,097 10% PUBLIC WORKS ADMINIS TRATIO N SALARIES AND WAGES $ 372,900 $ 10,480 $ 34,412 $ 338,488 9% BENEFITS 142,675 5,588 10,535 132,140 7% SUPPLIES 9,600 111 2,684 6,916 28% SERVICES 92,439 6,537 7,144 85,295 8% $ 617,614 $ 22,716 $ 54,775 $ 562,839 9% FACILITIES MAINTENANCE SALARIES AND WAGES 981,868 69,854 217,058 764,810 22% BENEFITS 402,717 28,655 59,632 343,085 15% SUPPLIES 128,000 1,173 7,629 120,371 6% SERVICES 959,860 9,521 50,699 909,161 5% $ 2,472,445 $ 109,202 $ 335,018 $ 2,137,427 14% ENGINEERING SALARIES AND WAGES $ 2,194,963 $ 147,900 $ 182,468 $ 2,012,495 8% BENEFITS 772,724 63,199 63,838 708,886 8% SUPPLIES 2,200 - - 2,200 0% SERVICES 254,552 15,729 15,113 239,440 6% $ 3,224,439 $ 226,829 $ 261,418 $ 2,963,021 8% TOTAL GENERAL FUND EXPENDITURES $ 55,716,788 $ 4,585,579 $ 4,868,760 $ 50,848,028 9% 32 Packet Pg. 36 2.2.a GENERAL FUND OVERVIEW BALANCES CHANGE IN FUND BALANCES GENERAL FUND ---- ACTUAL ---- ---- ACTUAL ---- & SUBFUNDS 1 /31 /2023 1 /31 /2023 Q1 YTD Fund Balance Cash Balance 0 m 001-General Fund $ 6,024,429 $ 3,532,016 $ (2,548,508, 009-Leoff-Medical Ins. Reserve 205,394 221,346 (27,422; 2 011-Risk Management Reserve Fund 25,000 25,000 - 012-ContingencyReserve Fund 1,782,150 1,782,150 - ii 014-Historic Preservation Gift Fund 11,701 11,701 t 016-Building Maintenance 4,222,297 4,365,572 (73,305; o 017 - Marsh Restoration & Preservation 849,766 849,766 - 018 - Edmonds Homelessness Response Fd 200,000 200,000 M - c Total General Fund & Subfunds $ 13,320,736 $ 10,987,552 $ - $ (2,649,235, 0 c R *$9,361,208 of the fund balance in Fund 001 added to the $1,782,150 balance in Fund 012, represent the required 20% operating reserve. o Q. m There are no interfund loans outstanding at this time. U c LL GOVERNMENTAL FUNDS OVERVIEW 0 Z CO) N O BALANCES CHANGE IN FUND BALANCES N ---- ACTUAL ---- ---- ACTUAL ---- 3 GOVERNMENTAL FUNDS 1 /31 /2023 1 /31 /2023 c Q1 YTD Fund Balance Cash Balance c d General Fund & Subfunds $ 13,320,736 $ 10,987,552 $ (2,649,235 t Special Revenue 13,627,328 23,387,113 (343,245, M Q Capital Projects - Fund 332 (113,618) (96,318) (141,122 Total Governmental Funds $ 26,834,445 $ 34,278,347 $ - $ (3,133,602 *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 33 Packet Pg. 37 2.2.a SPECIAL REVENUE FUNDS OVERVIEW BALANCES CHANGE IN FUND BALANCES GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- SPECIAL REVENUE 1/31/2023 1/31/2023 Q1 YTD Fund Balance Cash Balance 104 - Drug Enforcement Fund $ 67,697 $ 70,950 $ 127 111 - Street Fund 90,910 130,510 (330,749 c 112- Combined Street Const/Improve 657,018 (194,055) 14,713 m 117 - Municipal Arts Acquis. Fund 635,245 665,449 807 120 - Hotel/Motel Tax Revenue Fund 66,671 71,535 4,697 2 121 - Employee Parking Permit Fund 84,081 87,561 9,050 122 - Youth Scholarship Fund 15,237 15,942 29 123 -Tourism Promotional Fund/Arts 112,060 117,943 2,019 125 -Real Estate Tax 2 3,299,168 3,454,876 74,389 126 - Real Estate Excise Tax 1 * 4,032,949 4,216,696 82,970 p 127 - Gifts Catalog Fund 3,069,813 3,212,039 6,020 2 130 - Cemetery Maintenance/Improvement 259,273 272,553 (8,897 c 136 - Parks Trust Fund 161,741 169,238 303 N 137 - Cemetery Maintenance Trust Fund 1,107,928 1,159,101 4,628 138 - Sister City Commission 19,932 20,854 37 140 -Business Improvement Disrict 69,565 69,565 29,781 141 -Affordable and Supportive Housing Fd 234,566 234,566 7,639 V_ 142 - Edmonds Rescue Plan Fund (583,251) 9,374,570 (241,233; 0 143 - Tree Fund 226,724 237,220 425 Total Special Revenue $ 13,627,328 $ 23,387,113 $ - $ (343,245; *$200,000 of the fund balance in Fund 126 has been reserved for Marsh Restoration Funding, as well as $1,000,000 U for the purchase of Open Space. ii ENTERPRISE FUNDS OVERVIEW '' O 2 CO) N O N BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- ENTERPRISE FUNDS 1/31/2023 1/31/2023 Q1 YTD Fund Balance Cash Balance c m E 421 -Water Utility Fund $ 30,799,562 $ 9,278,185 $ 298,423 u 422-Storm Utility Fund* 14,197,395 5,264,428 61,790 Q 423 - Sewer/WWTP Utility Fund 55,126,181 14,175,203 (114,731. 424 - Bond Reserve Fund 843,961 843,961 - 411 -Combined Utility Operation 11,010 68,026 11,010 Total Enterprise Funds 1 $ 100,978,109 $ 29,629,803 1 $ - $ 256,493 *$250,000 of the Storm Utility Fund Balance has been reserved for Marsh Restoration Funding. *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 34 Packet Pg. 38 2.2.a SUMMARY OVERVIEW BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- CITY-WIDE 1 /31 /2023 1 /31 /2023 Q1 YTD Fund Balance Cash Balance Governmental Funds $ 26,834,445 $ 34,278,347 $ (3,133,602 ... Enterprise Funds 100,978,109 29,629,803 256,493 o 0. Internal Services Fund 9,774,692 5,554,592 (469,733 ' Total City-wide Total $ 137,587,246 $ 69,462,742 $ - $ (3,346,843 .v c c ii t INTERNAL SERVICE FUNDS OVERVIEW .r o M N O N R 7 C R BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- o Q- INTERNAL SERVICE FUNDS 1 /31 /2023 1 /31 /2023 Q1 YTD W Fund Balance Cash Balance @ U c 511 - Equipment Rental Fund $ 9,150,819 $ 5,137,643 $ (231,195, ii 512 -Technology Rental Fund 623,873 416,948 (238,539 21 t Total Internal Service Funds $ 9,774,692 $ 5,554,592 $ - $ (469,733 c 0 Z CO) N O N fC 3 C fC 7 C d E L V r Q *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 35 Packet Pg. 39 January 2023 Monthly Financial Report March 14, 2023 Packet Pg. 40 YTD Sales Tax Revenues for the 12 months ended December 31, 2022 of $11,257,927 were $955,409 (9.3%) higher than at December 31, 2021 Change in Sales Tax Revenue: December 2022 compared to December 2021 Total S955 409 Eating Lvz Drinlcinz $229 26 Retail Ati-tonlotive 193,72 Business Services $176,473 Construction Trade $171 10 Misc Retail $ 2,350 Others $ 1,574 Automotive Repmr $ 3,662 Anlusenient & Recreation $19,330 Retail Food Stores 1$18..113 A c conllnochiti on $16, 4 01 Clothing mid Accessories 1$1,5.367 Health S Personal Care 12.012 Conuilutlicatlons 5,278 Nlwi.ufacr ring (S68) Gasoline ($135) NN'liolesale Trade (S11,946) ($150.000) SO S-1S0.000 $500.000 $750.000 $1.000.000 OF Ebb +1p� 0 �0 Q Packet Pg. 41 YTD Sales Tax Revenues for January 2023 of $879,231 are $21,359 (2.5%) higher than for January 2022 Change hi Sales Tax Revenue: JanuaiT 2023 compared to January 2022 Total S21,35. RetailAutomoti-VeS24, G4 Eating & Drinking 58.404 Business Services $6,97 Retail Food Stores $3,41 Health & Personal Care S .081 Manufacturing $ , 45 5 Amusement fir Recreation $563 Accommodation $2 88 Gasoline so Canstraction Trade ($330) Automotive Repair (S998) Conummications ($1,771) Clothing and Accessories (S2,467 WhGlesale Trade (S2,567 Misc Retail ($7,207) Others (S11,24'S) ($250.000) $0 $250.000 r. a Packet Pg. 42 Total Sales Tax Revenues for the 12 months ended January 31, 2023 by Category Sales Tat Analysis By Group CuiTent Pedod: January 2023 Last 12 Months Total $11,279,286 Retail Food Stones Retail Automotive $364,050 Automotive Repair r$2,743.482 $241.343 1 Business Services $1,194,831 A ccomno dation $54.342 Connrnurications $241,199 Wholesale Trade $350,588 Misc Retail Construction T $2,078,78 7 01 754 41 7 Manufacturing _ S129.987 Gasoline $45 Eating & Drinking $1,278,153 Health & Personal Care I $70.861 Annisement & - Others $318.302 Recreation $75,936 Clothura and Accessories $382,953 OF Ebnj Packet Pg. 43 Thank you. r E. O Q W w LL s CO L M N O N w 3 C I M O r+ E E O U- d E s v �a w Q Packet Pg. 44 2.3 City Council Agenda Item Meeting Date: 03/14/2023 2020 Audit Update Staff Lead: Dave Turley Department: Administrative Services Preparer: Dave Turley Background/History During the audit of the 2020 CARES grant funds, the State Auditor's Office determined that several of the businesses who received grant funds from the city did not meet the city's own eligibility criteria, or that their eligibility could not be determined because the business had not provided adequate documentation before the end of the audit. Staff Recommendation For discussion. Narrative City staff have been asked to investigate the businesses whose eligibility was questioned by the auditor's office and gather more information so that we can determine what actions, if any, should be taken. Of the remaining 33 businesses that we attempted to contact, we have the following results. Two businesses paid back the grant, and two more agreed to a payment plan. Fifteen businesses either provided adequate documentation showing eligibility, or enough cause that we do not feel that it would be appropriate to make further attempts to recover the grant money given to them. Two businesses have closed. Twelve businesses have not responded to our attempts to contact them. We would like advice from the Finance Committee on how to proceed. Packet Pg. 45 2.4 City Council Agenda Item Meeting Date: 03/14/2023 Disposed Assets - 2022 Staff Lead: Dave Turley Department: Administrative Services Preparer: Dave Turley Background/History The city periodically disposes of assets as part of its normal course of business. Council notification is required; attached is a list of assets that were disposed of during 2022. Staff Recommendation Staff recommends that this be placed on "Received for Filing" at the March 21 Council Meeting. Notification only. Attachments: 2022 List of Deleted Assets Packet Pg. 46 2.4.a 2022 Deletes Fund Fund Type FA Number FA Description Type Dept# Amount Depreciation 2022 Depr. Book Value 900 Governmental 8263 EPS 5300 SVGA PROJECTOR SYS E 410 6,044.00 6,044.00 900 Governmental 8956 NETGEAR RN 4220 12-BAY 24TB NAS 10GE E 330 15,522.14 15,522.14 900 Governmental 9071 BARRACUDA MESSAGE ARCHIVE E 330 14,777.03 14,777.03 900 Governmental 9072 PALO ALTO NETWORKS E 330 17,618.55 17,618.55 423 Proprietary 8886 ODR700 - ODOR CONTROL IMPROVEMENT i 656 1,952,360.64 787,452.14 45,555.08 1,119,353.42 423 Proprietary 9262 DSH600 - DEWATERED CAKE STORAGE HOPPER i 656 337,512.83 337,512.83 511 Proprietary 8794 2008 CHEVROLET IMPALA 790-POL e 657 22,271.58 22,271.58 511 Proprietary 8923 049-WTR 2012 FORD TRANSIT e 657 32,639.47 32,639.47 GASB34 900 Governmental Spreadsheet Signal at 208th & 76th (SE Corner) i 653 97,007.37 97,007.37 Totals 2,495,753.61 1,330,845.11 45,555.08 1,119,353.42 N N 0 N N d N N Q m O Q 0 m N Q m r m CD O J N N O N C d E t V O Q Packet Pg. 47