The URL can be used to link to this page

2023-05-09 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 MAY 9, 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. March 2023 Monthly Financial Report (10 min) 3. ERP Update (20 min) ADJOURNMENT: 7:30 PM Edmonds City Council Agenda May 9, 2023 Page 1 2.1 City Council Agenda Item Meeting Date: 05/9/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 May 9, 2023: 1. Utility Rate Study prior to 2024 Budget process. Packet Pg. 2 2.2 City Council Agenda Item Meeting Date: 05/9/2023 March 2023 Monthly Financial Report Staff Lead: Dave Turley Department: Administrative Services Preparer: Sarah Mager Background/History N/A Staff Recommendation Review and move to full council to be received for filing. Narrative March 2023 Monthly Financial Report Attachments: March 2023 Monthly Financial Report Jan -Mar 2023 P&L Finance Committee Mtg 05_09 Packet Pg. 3 I 2.2.a I OF EDP � d lac. 1 $9v CITY OF EDMONDS MONTHLY BUDGETARY FINANCIAL REPORT MARCH 2O23 Packet Pg. 4 1 I 2.2.a I INVESTMENT PORTFOLIO SUMMARY City of Edmonds Investment Portfolio Detail As of March 31, 2023 Years Agency/ Investment Purchase to Par Market Maturity Coupon Issuer Type Price Maturity Value Value Date Rate FHLMC Bonds 988,678 0.05 1,000,000 997,364 04/20/23 0.38% FHLB Bonds 1,996,590 0.52 2,000,000 1,951,736 10/05/23 0.22% Kent WA Bonds 286,648 0.67 250,000 253,900 12/01/23 5.00% First Financial - ECA CD 2,803,516 0.75 2,803,516 2,803,516 12/28/23 2.08% First Financial - Waterfront Center CD 245,000 0.75 245,000 245,000 12/28/23 1.49% FHLB Bonds 2,004,464 0.80 2,000,000 2,001,640 01/16/24 4.81% FHLB Bonds 954,866 1.03 1,000,000 955,835 04/10/24 0.35% FM Bonds 996,082 1.22 1,000,000 977,695 06/17/24 2.80% FNMA Bonds 992,693 1.26 1,000,000 963,758 07/02/24 1.75% FHLB Bonds 950,774 1.64 1,000,000 941,687 11/18/24 0.90% Spokane County WA Bonds 207,260 1.67 200,000 191,724 12/01/24 2.10% FHLMC Bonds 974,798 1.95 1,000,000 985,593 03/13/25 3.75% FHLB Bonds 969,524 2.33 1,000,000 980,366 07/28/25 3.60% US Treas u ry Note Note 964,597 2.38 1,000,000 979,531 08/15/25 3.13% TOTAL SECURITIES 15,335,490 1.21 15,498,516 15,229,345 Washington State Local Gov't Investment Pool Snohomish County Local Gov't Investment Pool TOTAL PORTFOLIO Issuer Diversification Kent WA,- 2% FHLMC, First 13% Financial - CD, 20% Spokane County WA, 1% FHLB, 45% 7,862,576 7,862,576 Demand 4.74% 43,340,947 43,340,947 Demand 2.07% $ 66,702,040 $ 66,432,869 Cash and Investment Balances Checki ng, (in $ Millions) $5.1 , 7% Note, 1.0 , 2% Bonds, 11.5 , 16% State LGIP, 7.9 , 11% CD's, 3.0 , 4% County LGIP, 43.3 , 60% E O t2 d fY fC C R C LL 21 t C O 2 M N O N t v L to O rL d R U C C LL t C O Z CO) N O N t V L C� G r C a� E t U to Q 1 Packet Pg. 5 1 I 2.2.a I INVESTMENT PORTFOLIO SUMMARY Annual Interest Income $1,400, 000 $1 236 875 $1,200,000 1 091 709 $947,931 $950,684 $1,000,000 $882 556 $800,000 $600,000 [it $400,000 $ 200,000 $ 206 ��-iv $- 2018 2019 2020 2021 2022 YTD 2023 2 Packet Pg. 6 I 2.2.a I GENERAL FUND SUMMARY L 000000000000000 000000000 000 000 April 12,000,000 10,000,000 8,000, 000 6,000, 000 4,000, 000 2,000, 000 General Fund Revenues and Expenses (Rolling 24 months) General Fund Revenues General Fund Expenses AV I ter• � July October January April July October January General Fund Tax Revenue (2017 through 2022 Sales Tax Property Tax EMS Tax Other Taxes 2017 2018 2019 2020 2021 2022 General Fund Tax Revenue (2023 YTD) 3,500,000 3,000, 000 2,500,000 $2,551,514 2,000,000A2 781 1 IWO 1,500,000 — 1,000, 000 500,000 $59,032 Sales Tax Property Tax EMS Tax Other Taxes 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,716,321 $ 2,716,321 $ 2,320,252-14.58% February 5,384,133 2,667,812 4,920,100 -8.62% March 8,106,922 2,722,789 8,150,445 0.54% April 11,470,906 3,363,983 May 21,443,623 9,972,717 June 24,353,597 2,909,974 July 27,186,115 2,832,518 August 30,424,939 3,238,824 September 33,093,351 2,668,412 October 37,485,039 4,391,688 November 47,219,142 9,734,102 December 50,352,745 3,133,603 City of Edmonds, WA Monthly Revenue Summary -Real Estate Excise Tax 2023 Real Estate Excise Tax 1 & 2 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 342,055 $ 342,055 $ 151,084 -55.83% February 560,818 218,763 270,799 -51.71% March 909,543 348,725 521,829 -42.63% April 1,192,058 282,515 May 1,541,969 349,911 June 1,918,974 377,006 July 2,301,683 382,709 August 2,708,930 407,246 September 3,135,518 426,588 October 3,524,452 388,935 November 3,913,570 389,117 December 4,400,000 486,430 *The monthly budget forecast columns are based on a five-year average. w Packet Pg. 8 1 SALES TAX SUMMARY I 2.2.a I Construction Trade, $416,594 Accommodation, $9,668 _ Clothing and Accessories, CornnVAic Ens, $61,868 Wholesale Trade, — $80,535 12,000,000 10,000, 000 8,000,000 6,000,000 4,000,000 2,000,000 0 Sales Tax Analysis By Category Current Period: March 2023 Year -to -Date Total $2,781,110 Automotive Repair, (Zco iaQ Amusement & Food Stores, $92,443 Manufacturing, $31,661 Others, $60,496 Eating & Drinking, $308,863 Annual Sales Tax Revenue $10,302,518 $7,395,114 $8,406,296 $8,452,715 $8,317,046 27 2,781,110 2017 2018 2019 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 1,908,832 -4.53% March 2,854,859 855,451 2,781,110 -2.58% 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 Sales and Use Tax 12,000,000 11,000, 000 10,000,000 9,000,000 8,000,000 7,000,000 40 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 —0-- Current Year Budget — —Prior Year 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-46.98% February 78,108 28,192 147,332 88.63% March 375,054 296,947 824,405 119.81% 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 PersonaMoperty 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 �Cunrent Yeaz 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 143,978 -1.70% March 232,107 85,639 221,845 -4.42% 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 City of Edmonds, WA Monthly Revenue Summary -Sewer Utility Tax 2023 Sewer Utility Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 95,852 $ 95,852 $ 89,935 -6.17% February 174,661 78,808 166,439 -4.71% March 269,654 94,993 256,368 -4.93% 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 *The monthly budget forecast columns are based on a five-year average. 7 Packet Pg. 11 1 I 2.2.a I City of Edmonds, WA Monthly Revenue Summary -Meter Water Sales 2023 Meter Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 898,592 $ 898,592 $ 860,924 -4.19% February 1,526,893 628,301 1,439,675 -5.71% March 2,419,579 892,685 2,218,275 -8.32% 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 Budget Forecast Budget Forecast YTD Actuals Variance January $ 484,003 $ 484,003 $ 417,703 -13.70% February 1,535,452 1,051,449 1,359,827 -11.44% March 2,020,122 484,671 1,794,224 -11.18% 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 � Prior Year *The monthly budget forecast columns are based on a five-year average. F O C. d R C M C_ LL t C O 2 tM N O N t V L R O CL C M c LL z r C O M N O N t V L r C N t V fC a+ Q 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 1,665,119 -4.61% March 2,695,497 949,850 2,565,291 -4.83% 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 Yeaz Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. 9 Packet Pg. 13 ■ 2.2.a City of Edmonds, WA Monthly Expenditure Report -General Fund 2023 General Fund Cumulative Monthly Budget Forecast Budget Forecast YTD Variance Actuals January $ 5,534,983 $ 5,534,983 $ 4,868,760-12.04% February 9,977,833 4,442,851 10,063,682 0.86% March 14,357,831 4,379,998 14,793,075 3.03% April 18,562,233 4,204,402 May 23,096,754 4,534,521 June 28,326,661 5,229,907 July 32,791,511 4,464,850 August 37,090,589 4,299,078 September 41,872,008 4,781,419 October 46,615,817 4,743,809 November 51,912,151 5,296,334 December 57,687,687 5,775,536 Non -Departmental General Fund 60,000,000 55,000,000 50,000,000 45,000,000 40,000,000 35,000,000 0. 30,000,000 25,000,000 20,000,000 15,000,000 10,000,000 5,000,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 -Non -Departmental 2023 Cumulative Budget Forecast Monthly Budget Forecast YTD Variance Actuals January $ 2,210,919 $ 2,210,919 $ 1,642,894-25.69% February 3,370,075 1,159,155 3,380,586 0.31% March 4,433,358 1,063,283 4,986,307 12.47% April 5,352,010 918,652 May 6,502,926 1,150,916 June 8,207,872 1,704,946 July 9,220,727 1,012,855 August 10,088,588 867,861 September 11,260,570 1,171,982 October 12,343,718 1,083,149 November 13,681,280 1,337,562 December 15,120,425 1,439,145 *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 71,252 10.08% March 102,768 38,042 108,460 5.54% 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 450,000 400,000 350,000 300,000 250,000 200,000 150,000 100,000 50,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --0-- Current Year Budget � Prior Year City of Edmonds, WA Monthly Expenditure Report -Office of Mayor 2023 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 40,530 $ 40,530 $ 32,343 -20.20% February 82,920 42,390 63,133 -23.86% March 123,864 40,944 101,671 -17.92% 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 Office of Mayor 500,000 450,000 400,000 350,000 300,000 250,000 200,000 150,000 100,000 50,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -"-Current Year Budget �PriorYear *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 Budget Forecast Budget Forecast YTD Actuals Variance January $ 111,879 $ 111,879 $ 93,116 -16.77% February 212,590 100,710 164,590 -22.58% March 304,874 92,285 230,737 -24.32% 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,S77 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 odr- 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 Budget Forecast Budget Forecast YTD Actuals Variance January $ 107,783 $ 107,783 $ 114,975 6.67% February 217,016 109,233 231,321 6.59% March 329,502 112,486 352,625 7.02% 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 ActuaIs January $ 75,636 $ 75,636 $ 84,200 11.32% February 158,776 83,140 172,586 8.70% March 244,264 85,488 263,059 7.69% April 326,040 81,776 May 410,629 84,589 June 496,694 86,064 July 586,721 90,027 August 693,939 107,218 September 794,170 100,231 October 898,567 104,397 November 1,032,532 133,965 December 1,199,451 166,919 *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 Fund 512 - Technology Rental Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 208,626 $ 208,626 $ 355,645 70.47% February 345,734 137,108 530,347 53.40% March 533,426 187,692 683,467 28.13% April 608,285 74,858 May 714,977 106,692 June 836,660 121,683 July 927,272 90,612 August 1,062,420 135,149 September 1,197,885 135,465 October 1,349,945 152,060 November 1,449,758 99,813 December 1,685,027 235,269 Fund 512 - Technology Rental land 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 Administrative Services Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 235,621 $ 235,621 $ 253,437 7.56% February 400,584 164,963 571,249 42.60% March 566,179 165,595 774,413 36.78% April 735,689 169,510 May 904,213 168,524 June 1,133,897 229,684 July 1,324,708 190,811 August 1,494,358 169,650 September 1,664,937 170,579 October 1,843,073 178,136 November 2,043,094 200,022 December 2,217,666 174,572 *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 109,813-43.29% March 290,445 96,815 186,270-35.87% 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 Attorney 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 --0-- Current Year Budget � Prior Year 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 2,119,852 -8.83% March 3,539,820 1,214,656 3,173,554-10.35% 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 $ 376,373 $ 376,373 $ 286,492-23.88% February 772,766 396,393 595,086-22.99% March 1,153,437 380,671 913,919-20.77% April 1,554,903 401,467 May 1,949,577 394,674 June 2,342,019 392,442 July 2,770,412 428,393 August 3,172,433 402,021 September 3,591,554 419,121 October 4,008,358 416,804 November 4,457,452 449,094 December 4,976,888 519,436 City of Edmonds, WA Monthly Expenditure Report -Parks & Recreation 2023 Parks & Recreation Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 419,452 $ 419,452 $ 589,720 40.59% February 878,149 458,697 958,125 9.11% March 1,336,929 458,780 1,386,849 3.73% April 1,796,458 459,529 May 2,266,262 469,804 June 2,764,885 498,623 July 3,310,375 545,491 August 3,875,366 564,991 September 4,483,687 608,320 October 4,983,396 499,710 November 5,493,514 510,117 December 6,022,817 529,303 *The monthly budget forecast columns are based on a five-year average. 16 Packet Pg. 20 I 2.2.a I City of Edmonds, 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 $ 106,250 $ 106,250 $ 81,158-23.62% February 212,500 106,250 97,897-53.93% March 318,750 106,250 100,936-68.33% April 425,000 106,250 May 531,250 106,250 June 637,500 106,250 July 743,750 106,250 August 850,000 106,250 September 956,250 106,250 October 1,062,500 106,250 November 1,168,750 106,250 December 1,275,000 106,250 Fund 016 - Building Maintenance Fund 1,300,000 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 ofEdmonds, WA Monthly Expenditure Report -Facilities Maintenance 2023 Facilities Maintenance Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 229,986 $ 229,986 $ 335,018 45.67% February 525,669 295,683 935,298 77.93% March 832,538 306,869 1,264,752 51.92% April 1,125,114 292,577 May 1,391,198 266,084 June 1,610,195 218,997 July 1,876,146 265,951 August 2,221,436 345,290 September 2,620,782 399,346 October 3,065,186 444,404 November 3,431,614 366,428 December 4,013,010 581,396 Facilities Maintenance 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 *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 531,670 5.07% March 764,005 257,966 807,168 5.65% 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 31000,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 6-- Current Yeaz Budget Prior Yew *The monthly budget forecast columns are based on a five-year average. F O i3 d C R C LL t C O M N O N L V L C� G.+ L O Q U C t CO C CO) N O N t V L C� G r L Q 18 Packet Pg. 22 Page 1 of 1 C TIY OF EDMONDS REVENUES BY FUND - SUMMARY Fund 2023 Adopted 3/31/2022 3/31/2023 Amount No. Title Budget Revenues Revenues Remaining %Received 001 GENERAL FUND $ 50,352,745 $ 7,290,787 $ 8,150,445 $ 42,202,300 160/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 15,259 23,820 (6,340) 1360/c 017 MARSH RESTORATION & PRESERVATION FUND - - - - 00/, .. 018 EDMONDS HOMELESSNESS RESPONSE FUND - - - 00/c O Q. 104 DRUG ENFORCEMENT FUND 167,650 578 59 167,591 0% Ill STREET FUND 1,815,410 321,969 328,654 1,486,756 180/, 112 COMBINED STREET CONST/IMPROVE 11,084,065 1,084,583 1,830,889 9,253,176 170/c .O C eo 117 MUNICIPAL ARTS ACQUIS. FUND 98,098 77,198 9,261 88,837 9% U- 118 MEMORIAL STREET TREE - - - - 0% 120 HOTEL/MOTEL TAX REVENUE FUND 84,400 19,965 22,971 61,429 270/c r C 121 EMPLOYEE PARKING PERMIT FUND 38,960 8,246 10,367 28,593 270/, 122 YOUTH SCHOLARSHIP FUND 1,660 110 13 1,647 10/, M N 123 TOURISM PROMOTIONAL FUND/ARTS 30,440 7,199 7,731 22,709 250/, N 125 REAL ESTATE EXCISE TAX 2 2,320,090 307,137 263,513 2,056,577 11% tl 126 REAL ESTATE EXCISE TAX 1 2,302,980 302,186 264,405 2,038,575 L 11% 127 GIFT S CATALOG FUND 135,340 65,930 33,915 101,425 130 CEMETERY MAINTENANCE/IMPROVEMT 150,960 51,737 50,994 99,966 340/c O Q. 136 PARKSTRUST FUND 5,460 1,294 (7,497) 12,957 -1370/, 137 CEMETERY MAINTENANCE TRUST FD 51,500 14,031 6,606 44,894 130/, �p 138 SISTER CITY COMMISSION 10,430 119 17 10,413 .O 00/c C O 140 BUSINESS IMPROVEMENT DISTRICT 88,645 37,412 38,089 50,556 430/c r- IL 141 AFFORDABLE AND SUPPORTIVE HOUSINGFUND 65,000 23,034 21,312 43,688 330/c 142 EDMONDS RESCUE PLAN FUND 1,249,000 - 1,010 1,247,990 00/c r C 143 TREE FUND 215,100 157 198 214,902 00/, 231 2012 LT GO DEBT SERVICE FUND 309,800 - - 309,800 00/( rM N 332 PARKS CAPITAL CONSTRUCTION FUND 2,713,902 808,208 158,915 2,554,987 60/, N 411 COMBINED UTILITY OPERATION - 46,790 37,625 (37,625) 00/, v 421 WATER UTILITYFUND 11,950,114 2,553,715 2,586,131 9,363,983 L 220/c 422 STORM UTILITY FUND 9,020,452 1,984,530 2,278,818 6,741,634 250/c y ; C 423 SEWER/WWTP UTILITY FUND 15,898,844 5,144,772 4,869,903 11,028,941 310/c 0 424 BOND RESERVE FUND 1,991,860 3 3,093 1,988,767 00/c 511 EQUIPMENT RENTAL FUND 4,188,740 463,683 560,274 3,628,466 130/, .0. 512 TECHNOLOGY RENTAL FUND 1,481,194 291,812 352,483 1,128,711 240/( Q $ 118,065,319 $ 20,922,442 $ 21,904,016 $ 96,161,303 190/1 19 Packet Pg. 23 I 2.2.a I Page 1 of 1 CITY OF MMO NDS EXPENDITURES BY FUND - SUMMARY Fund 2023 Adopted 3/31/2022 3/31/2023 Amount No. Title Budget Expenditures Eipenditures Remaining %Spent 001 GENERAL FUND $ 57,687,687 $ 11,949,976 $ 14,793,075 $ 42,894,612 260/c 009 LEOFF-MEDICAL INS. RESERVE 367,140 88,086 102,272 264,868 280/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,275,000 16,522 100,936 1,174,064 80/c 017 MARSH RESTORATION & PRESERVATION FUND - - - 00/, 018 EDMONDS HOMELESSNESS RESPONSE FUND - - - 00/c p s?. 019 EDMONDS OPIOID RESPONSE FUND - - - 00/c CD 104 DRUG ENFORCEMENT FUND 45,800 - - 45,800 0% 111 STREET FUND 2,350,969 612,607 965,565 1,385,404 410/c eo 112 COMBINED STREET CONST/IMPROVE 9,990,960 412,691 1,421,377 8,569,583 140/c li 117 MUNICIPAL ARTS ACQUIS. FUND 207,380 12,908 5,665 201,715 30/, 118 MEMORIAL STREET TREE - - - - 00/c r C 120 HOTEL/MOTEL TAX REVENUE FUND 95,400 8,555 670 94,730 1% 121 EMPLOYEE PARKING PERMIT FUND 26,880 - - 26,880 00/, M N 122 YOUTH SCHOLARSHIP FUND 3,000 - - 3,000 0% N 123 TOURISM PROMOTIONAL FUND/ARTS 28,500 - 780 27,720 30/, tl L 125 REAL ESTATE EXCISE TAX 2 4,062,898 423,951 240,110 3,822,788 60/c 126 REAL ESTATE EXCISE TAX 1 1,768,812 133,238 66,831 1,701,981 4% 127 GIFTS CATALOG FUND 497,598 2,462 27,197 470,401 50/c 0 0. 130 CEMETERY MAINTENANCE/IMPROVEMT 249,413 45,724 73,531 175,882 29% � 136 PARKS TRUST FUND 43,842 - - 43,842 00/, <0 137 CEMETERY MAINTENANCE TRUST FUND 50,000 - - 50,000 00/, C 138 SISTER CITY COMMISSION 11,900 - 219 11,681 2% LL 140 BUSINESS IMPROVEMENT DISTRICT 88,575 11,101 10,176 78,399 110/c >, 142 EDMONDS RESCUE PLAN FUND 1,249,000 232,175 663,059 585,941 530/c 143 TREE FUND 239,800 - - 239,800 00/c 231 2012 LT GO DEBT SERVICE FUND 309,800 - - 309,800 00/c M 04 332 PARKS CAPITAL CONSTRUCTION FUND 2,255,647 1,630,281 568,994 1,686,653 250/c N 421 WATER UTILITY FUND 11,635,050 1,422,285 1,896,223 9,738,827 160/c v L 422 STORM UTILITY FUND 8,086,963 1,143,115 1,127,379 6,959,584 140/c 423 SEWER/WWTP UTILITY FUND 16,031,246 3,720,393 3,369,420 12,661,826 210/c 424 BOND RESERVE FUND 1,989,820 - - 1,989,820 0% 511 EQUIPMENT RENTAL FUND 4,367,218 346,163 829,288 3,537,930 19% v ca 512 TECHNOLOGY RENTAL FUND 1,685,027 502,978 683,467 1,001,560 410/c Q 617 FIREMEN'S PENSION FUND - - - - 00/c $ 126,732,225 $ 22,715,212 $ 26,946,235 $ 99,785,990 210% 20 Packet Pg. 24 2.2.a Page 1 of 3 C ITY O F EDMO NDS REVENUES - GENERAL FUND 2023 Adopted 3/31/2022 3/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 SALES/USE TAX 1 5 NATURAL GAS USE TAX 6 1/10 SALES TAX LOCAL CRIM JUST 7 ELECTRIC UTILITY TAX 8 GASUTILITY 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 PERM TS : 18 FIRE PERMITS -SPECIAL USE 19 POLICE - FINGERPRINTING 20 VENDING MACHINE/CONCESSION 21 FRANCHISE AGREEMENT -COMCAST 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 PERMIT S 29 FIRE PERMIT 30 ENGINEERING PERMIT 31 ANIMAL LICENSES 32 STREET AND CURB PERMIT 33 STREET AND CURB PERMIT W/LEASEHOLD TAX 34 OTRNON-BUSLIC/PERMITS 35 SPECIAL EVENT REVIEW INTERGOVERNMENTAL: 36 FEDERAL GRANTS - BUDGET ONLY 37 DOJ 15-0404-0-1-754 - BULLET PROOF VEST 38 HIGH VISIBILITY ENFORCEMENT 39 CORONAVIRUS RELIEF FUND 40 STATE GRANTS- BUDGET ONLY 41 PUD PRIVILEDGE TAX 42 TRIAL COURT IMPROVEMENT 43 CJ - POPULATION 44 CRIMINAL JUSTICE -SPECIAL PROGRAMS 45 MARIJUANA EXCISE TAX DISTRIBUTION 46 DUI - CITIES 47 LIQUOR EXCISE TAX 48 LIQUOR BOARD PROFITS 49 MISCELLANEOUS INTERLOCAL REVENUE 50 FIRST RESPONDERS FLEX FUND 51 DISCOVERY PROGRAMS TECHNOLOGY ACQ. $ 11,327,000 $ 287,837 $ 824,405 $ 10,502,595 70/( 4,578,000 114,531 330,582 4,247,418 70/( 500 27 4 496 10/( 11,900,000 2,666,259 2,781,110 9,118,890 230/( 7,600 4,804 - 7,600 00/( 1,150,000 249,575 259,807 890,193 230/c 1,900,000 534,798 542,135 1,357,865 290/( 845,000 305,138 352,921 492,079 420/( 384,000 94,158 71,026 312,974 180/c 1,000,234 212,668 221,845 778,389 220/( 942,960 160,357 256,368 686,592 270/( 621,458 174,064 179,423 442,035 290/( 850,000 203,217 204,076 645,924 240/( 773,000 130,244 92,079 680,921 120/( 80,200 18,591 22,264 57,936 280/c 350 - - 350 00/( 326,000 77,158.4 78,017.5 247,982 240/( 36,686,302 5,233,427 6,216,061 30,470,241 170% 250 50 50 200 200/( 700 20 225 475 320/( 94,500 14,725 22,189 72,311 230/( 702,700 179,444 171,516 531,184 240/( 41,000 9,105 8,478 32,522 210/( 100,600 12,550 9,373 91,227 90/( 450,000 84,298 101,463 348,537 230/( 250,000 64,396 66,225 183,775 260/( 80,000 24,775 22,920 57,080 290/( 30,000 30,173 13,962 16,038 470/( 750,600 222,875 143,042 607,558 190/( - - 600 (600) 00/( - - 7,090 (7,090) 00/( 24,000 7,135 9,559 14,441 400/( 75,000 12,958 18,340 56,660 240/( - - 293 (293) 00/( 20,000 - 4,194 15,806 210/( - 3,754 251 (251) 00/( 2,619,350 666,258 599,769 2,019,581 230% 166,309 - - 166,309 00/( 9,000 5,237 - 9,000 00/( 11,100 718 3,845 7,255 350/( 1,494,875 - - 1,494,875 00/( 244,645 - - 244,645 00/( 210,500 - - 210,500 00/( 16,740 5,388 5,338 11,402 320/( 13,070 3,571 3,758 9,312 290/( 50,600 12,693 13,294 37,306 26°/ 125,000 24,665 26,513 98,487 210/( 4,500 1,793 53 4,448 10/( 325,000 72,230 71,223 253,777 22°/ 343,200 83,190 82,149 261,051 240/( - - 500 (500) 00/( 1,000 - - 1,000 0°/ 550 - - 550 00/( 3,016,089 209,486 206,674 2,809,415 70% O Q. d i0 C c0 c M t C O M N O N t v c`o O Q d w 20 C O C IL s C O n CO) N O N t U R 2 r C a) E t U M Q 2022 Local Retail Sa/esiUse Tax revenues are $114,851 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 3/31/2022 3/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 ENGINEERINGPLAN REVIEW AND INSPECTION 34 CRITICAL AREA STUDY 35 GYM AND WEI MTROOM FEES 36 PROGRAM FEES 37 HOLIDAY MARKET REGISTRATION FEES 38 UPTOWN EVENING MARKET FEES 39 WINTERMARKET FEES 40 BIRD FEST REGISTRATION FEES 41 INTERFUND REIMBURSEMENT -CONTRACT SVCS $ 3,000 $ 1,897 $ 924 $ 2,076 310/( 600 44 45 555 80/( 6,000 441 - 6,000 00/( 150 1 - 150 00/( 300 - - 300 00/( 4,000 - - 4,000 00/( 1,000 49 46 954 50 50 37 77 (27) 1540/( 25,000 - - 25,000 00/( 100 51 7 93 70/( 1,000 - - 1,000 00/( 190,000 82,228 26,678 163,322 140/( 1,400 2,885 - 1,400 00/( 100,000 24,410 12,805 87,195 130/( 5,000 1,400 18,025 (13,025) 3610/( 30,000 - - 30,000 00/( 14,000 - - 14,000 00/( 210,970 52,742 113,713 97,258 540/( - 13 20 (20) 0% 67,000 15,373 19,794 47,206 300/( 1,050 126 - 1,050 00/( 38,000 4,560 2,830 35,170 70/( 3,000 103 53 2,947 20/( 10,000 7,963 5,793 4,207 580/( 3,500 177 200 3,300 60/( 1,077,500 238,403 - 1,077,500 00/( 5,000 1,164 754 4,246 1501( 65,600 24,928 17,062 48,539 260/( 425,000 57,962 140,295 284,705 330/( 4,000 4,234 5,574 (1,574) 1390/( 500 110 2,844 (2,344) 5690/( 3,000 2,220 740 2,260 250/( - - 756 (756) 00/( 14,000 5,370 4,686 9,314 330/( 13,000 231 3,172 9,828 240/( 990,959 174,034 218,632 772,327 220/( 5,000 - 455 4,545 90/( 5,000 - - 5,000 00/( 5,000 6,880 8,805 (3,805) 1760/( 1,000 - - 1,000 00/( 3,427,765 294,624 302,153 3,125,612 90/( 6,757,444 1,004,658 906,937 5,850,507 130% Q 22 Packet Pg. 26 2.2.a Page 3 of 3 C ITY O F EDMO NDS REVENUES - GENERAL FUND 2023 Adopted 3/31/2022 3/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 CURRENT TRAFFIC INFRACTIONS 6 NON -TRAFFIC INFRACTION PENALTIES 7 OTHERINFRACTIONS'04 8 PARKING INFRACTION PENALTIES 9 PARK/INDDISZONE 10 DWI PENALTIES 11 DUI - DP ACCT 12 CRIM CNV FEE DUI 13 DUI - DP FEE 14 CRIMINAL TRAFFIC MISDEMEANOR 8/03 15 CRIMINAL CONVICTION FEE CT 16 CRIM CONV FEE CT 17 OTHER NON-T RAF MISDEMEANOR PEN 18 OTHER NON TRAFFIC MISD. 8/03 19 COURT DV PENALTY ASSESSMENT 20 CRIMINAL CONVICTION FEE CN 21 CRIM CONV FEE CN 22 PUBLIC DEFENSE RECOUPMENT 23 BANK CHARGE FOR CONY. DEFENDANT 24 COURT COST RECOUPMENT 25 BUS. LICENSE PERMIT PENALTY 26 MISC FINES AND PENALTIES MISCELLANEOUS: 27 INVESTMENT INTEREST 28 INTEREST ON COUNTY TAXES 29 INTEREST - COURT COLLECTIONS 30 LOAN INTEREST 31 SPACE/FACILITIESRENTALS 32 BRACKET ROOM RENTAL 33 LEASESLONG-TERM 34 DONATION/CONTRIBUTION 35 PARKSDONATIONS 36 BIRD FEST CONTRIBUTIONS 37 POLICE CONTRIBUTIONS FROM PRIV SOURCES 38 SALE OF JUNK/SALVAGE 39 SALES OF UNCLAIM PROPERTY 40 CONFISCATED AND FORFEITED PROPERTY 41 OTHER JUDGEMENT/SETTLEMENT 42 POLICE JUDGMENT SiRESTITUTION 43 CASHIER'S OVERAGESISHORT AGES 44 OTHER MISC REVENUES 45 SMALL OVERPAYMENT 46 NSF FEES - PARKS & REC 47 NSF FEES - MUNICIPAL COURT 48 L&I STAY AT WORK PROGRAM 49 US BANK REBATE TOTAL GENERAL FUND REVENUE $ 2,000 $ 469 $ 710 $ 1,290 350/( 130,000 15,805 27,099 102,901 210/( 18,000 1,180 773 17,227 40/( 10,000 963 1,053 8,947 110/( - - 23,882 (23,882) 00/( 1,000 - 4,300 (3,300) 4300/( 1,500 218 819 681 5501( 125,000 4,135 2,110 122,890 20/( 2,000 72 239 1,761 120/( 7,000 990 1,083 5,917 1501( 300 26 1 299 00/( 100 9 - 100 00/( 1,500 505 484 1,016 320/( 25,000 2,971 2,571 22,429 100/( 2,000 475 442 1,558 220/( 700 34 - 700 00/( 100 - 100 0 1000/( 12,000 636 108 11,892 10/( 800 12 100 700 130/( 1,000 81 48 952 501( 200 - - 200 00/( 6,000 933 894 5,106 1501( 4,000 790 1,709 2,291 430/( 1,000 49 368 632 370/( 1,000 - - 1,000 00/( 150 - - 150 00 352,350 30,353 68,894 283,456 20% 321,240 74,203 6,321 314,919 20/( 10,960 1,116 9,932 1,028 910/( 12,180 1,875 793 11,387 70/( 12,080 - - 12,080 00/( 175,000 11,244 13,919 161,081 80/( 2,100 - - 2,100 00/( 210,000 51,562 56,584 153,416 270/( 1,500 76 83 1,417 60/( 3,500 2,300 500 3,000 140/( 1,500 - - 1,500 00/( 5,000 249 - 5,000 00/( 300 - 565 (265) 1880/( 3,800 996 1,504 2,296 400/( 2,000 - - 2,000 00/( 146,000 - 49,007 96,993 340/( 200 14 47 153 240/( - 20 10 (10) 00/( 5,000 773 1,240 3,760 250/( 100 20 1 99 10/( 100 - - 100 00/( 150 - 4 146 30/( - - 8,702 (8,702) 00/( 8,500 2,158 2,899 5,601 34°/ 921,210 146,605 152,110 769,100 170% $ 50,352,745 $ 7,290,787 $ 8,150,445 $ 42,202,300 160% Q 23 Packet Pg. 27 I 2.2.a I Page 1 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Adopted 3/31/2022 3/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent GENERAL FUND EXPENDITURES (001) 1 SALARIES AND WAGES $ 21,585,702 $ 4,326,088 $ 5,394,677 $ 16,191,025 250/ 2 OVERTIME 649,080 302,420 194,698 454,382 300/ 3 HOLIDAY BUY BACK 294,001 8,212 5,674 288,327 20/ 4 BENEFITS 7,619,904 1,616,010 1,894,915 5,724,989 250/ 5 UNIFORMS 130,851 13,344 36,300 94,551 280/ 6 PENSION AND DISABILITY PAYMENTS 165,023 11,825 22,294 142,729 140/ 7 SUPPLIES 759,025 80,236 95,049 663,976 130/ 8 SMALL EQUIPMENT 302,791 29,359 49,389 253,402 160/ 9 PROFESSIONAL SERVICES 18,093,206 3,942,748 4,707,739 13,385,467 260/ 10 COMMUNICATIONS 241,295 30,315 41,904 199,391 170/ 11 TRAVEL 74,795 4,397 14,869 59,926 200/ 12 EXCISE TAXES 16,500 7,774 7,407 9,093 450/ 13 RENTAL/LEASE 2,780,344 510,493 659,041 2,121,303 240/ 14INSURANCE 597,722 503,160 625,650 (27,928) 1050/ 15 UTILITIES 663,800 157,296 153,036 510,764 230/ 16 REPAIRS& MAINTENANCE 593,900 179,938 336,715 257,185 570/ 17 MISCELLANEOUS 652,593 176,364 214,994 437,599 330/ 18 INTERGOVERNMENTAL PAYMENTS 50,000 50,000 50,000 - 1000/ 19 INTERFUND SUBSIDIES 863,000 - - 863,000 00/ 20 BUILDINGS - 284,460 (284,460) 00/ 21 MACHINERY/EQUIPMENT 430,000 4,264 425,736 10/ 22 CONSTRUCT IONS PROJECTS 800,565 - 800,565 00/ 23 GENERAL OBLIGATION BOND PRINCIPAL 191,620 191,620 00/ 24 INTEREST ON LONG-TERM EXTERNAL DEBT 131,470 131,470 00/ 25 OTHER INTEREST & DEBT SERVICE COSTS 500 - - 500 00/ 77,687,687 11,949,976 14,793,075 42,894,612 260/ LEO FF-MEDIC AL INS. RESERVE(009) 26 BENEFITS $ 206,650 $ 59,723 $ 72,693 $ 133,957 350/ 27 PENSION AND DISABILITY PAYMENTS 152,990 21,363 29,579 123,411 190/ 28 PROFESSIONAL SERVICES 7,000 7,000 - 7,000 00/ 29 MISCELLANEOUS 500 - - 500 00/ 367,140 88,086 S 102,272 264,868 280/ RISK MANAG04ENT RESERVE FUND (011) 30 MISCELLANEOUS $ 25,000 $ - $ $ 25,000 00/ 25,000 25,000 00/ HISTORIC PRESERVATION GIFT FUND (014) 31 SUPPLIES $ 100 $ $ $ 100 00/ 32 PROFESSIONAL SERVICES 200 200 00/ 33 MISCELLANEOUS 5,600 5,600 00/ 5,900 5,900 00/ BUILDING MAINTENANCEFUND (016) 34 PROFESSIONAL SERVICES $ 121,500 $ 450 $ $ 121,500 00/ 35 REPAIR&MAINTENANCE 1,153,500 16,072 81,158 1,072,342 70/ 36 BUILDINGS - - 19,778 (19,778) 00/ 1,275,000 16,522 100,936 1,174,064 8U/ DRUG INFO RCEMFNTFUND (104) 37 PROFESSIONAL SERVICES $ 45,000 $ - $ $ 45,000 00/ 38 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 3/31/2022 3/31/2023 Amount Title Budget Expenditures Expenditures Remaining % Spent STREETFUND (111) 1 SALARIES AND WAGES $ 828,313 $ 175,741 $ 366,360 $ 461,953 449 2 OVERTIME 38,400 8,784 10,514 27,886 279 3 BENEFITS 377,585 86,684 129,613 247,972 340 4 UNIFORMS 6,000 3,107 3,070 2,930 519 5 SUPPLIES 263,000 15,428 22,695 240,305 99 6 SMALL EQUIPMENT 20,000 587 552 19,448 39 7 PROFESSIONAL SERVICES 23,210 4,457 4,874 18,336 219 8 COMMUNICATIONS 4,500 1,284 1,710 2,790 380 9 TRAVEL 1,000 - - 1,000 09 10 RENTAL/LEASE 304,730 72,120 75,724 229,006 259 11 INSURANCE 120,821 184,111 126,467 (5,646) 1059 12 UTILITIES 273,730 45,731 47,742 225,988 179 13 REPAIRS & MAINTENANCE 52,000 4,212 4,580 47,420 99 14 MISCELLANEOUS 8,000 10,360 6,310 1,690 799 15 BUILDINGS 25,000 - - 25,000 09 16 OTHERIMPROVEMENTS - 165,353 (165,353) 09 17 GENERAL OBLIGATION BOND PRINCIPAL 4,380 - 4,380 09 18 INTEREST 300 - 300 09 $ 2,350,969 $ 612,607 $ 965,565 $ 1,385,404 419 COMBINED STREETCONST)TMPROVE(112) 19 PROFESSIONAL SERVICES $ 3,674,780 $ 109,042 $ 178,619 $ 3,496,161 59 20 INTERFUND SUBSIDIES 172,650 - - 172,650 09 21 REPAIRS & MAINTENANCE - 122 - - 09 22 LAND 270,000 32,660 - 270,000 09 23 CONSTRUCTION PROJECTS 5,818,580 270,868 1,242,758 4,575,822 219 24 INTERGOVERNMENTAL LOANS 54,070 - - 54,070 09 25 INTEREST 880 - - 880 09 $ 9,990,960 $ 412,691 $ 1,421,377 $ 8,569,583 149 MUNICIPAL ARTS ACQUIS. FUND (117) 26 SUPPLIES $ 4,700 $ - $ 493 $ 4,207 109 27 SMALL EQUIPMENT 1,700 - - 1,700 09 28 PROFESSIONAL SERVICES 191,000 11,883 3,855 187,145 29 29 TRAVEL 80 - - 80 09 30 RENTAL/LEASE 3,000 - 3,000 09 31 REPAIRS & MAINTENANCE 300 - - 300 09 32 MISCELLANEOUS 6,600 1,025 1,317 5,283 200 $ 207,380 $ 12,908 $ 5,665 $ 201,715 39 HO TEL/MO TEL TAX REVENUE FUND (120) 33 PROFESSIONAL SERVICES $ 90,400 $ 8,555 $ 670 $ 89,730 19 34 MISCELLANEOUS 1,000 - - 1,000 09 35 INTERFUND SUBSIDIES 4,000 - - 4,000 09 $ 95,400 $ 8,555 $ 670 $ 94,730 19 EMPLO YEE PARKING PERMIT FUND (121) 36 SUPPLIES $ 1,790 $ - $ - $ 1,790 09 37 PROFESSIONAL SERVICES 25,090 - 25,090 09 $ 26,880 $ $ - $ 26,880 09 YOUTH SCHOLARSHIP FUND (122) 38 MISCELLANEOUS $ 3,000 $ $ - $ 3,000 09 $ 3,000 $ $ - $ 3,000 09 TOURISM PROMOTIONAL FUND/ARTS (123) 39 PROFESSIONAL SERVICES $ 28,500 $ $ 780 $ 27,720 39 $ 28,500 8 $ 780 $ 27,720 39 25 Packet Pg. 29 I 2.2.a I Page 3 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Adopted 3/31/2022 3/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent REAL ESTATE EXC ISE TAX 2 (125) 1 SUPPLIES $ - $ 7,222 $ - $ - 09 2 PROFESSIONAL SERVICES 586,957 59,372 24,938 562,019 49 3 REPAIRS&MAINTENANCE 926,300 56,168 25,013 901,287 39 4 INTERFUND SUBSIDIES 5,684 - - 5,684 09 5 LAND 200,000 - - 200,000 09 6 CONSTRUCTION PROJECTS 2,343,957 301,189 190,159 2,153,798 89 $ 4,062,898 $ 423,951 $ 240,110 $ 3,822,788 69 REAL ESTATE EXCISE TAXI (126) 7 PROFESSIONAL SERVICES 8 REPAIRS & MAINTENANCE 9 INTERFUND SUBSIDIES 10 LAND 11 CONSTRUCTION PROJECTS 12 GENERAL OBLIGATION BONDS 13 INTEREST GIFTS CATALOG FUND (127) 14 SALARIES AND WAGES 15 OVERTIME 16 BENEFIT S 17 SUPPLIES 18 SMALL EQUIPMENT 19 PROFESSIONAL SERVICES 20 RENTAL/LEASE 21 MISCELLANEOUS CEVIEIERY MAINTENANCBIMPRO VEMENT (130) 22 SALARIES AND WAGES 23 OVERTIME 24 BENEFIT S 25 UNIFORMS 26 SUPPLIES 27 SUPPLIES PURCHASED FOR INVENTORY/RESALE 28 PROFESSIONAL SERVICES 29 COMMUNICATIONS 30 TRAVEL 31 RENTAL/LEASE 32 UTILITIES 33 REPAIRS & MAINTENANCE 34 MISCELLANEOUS PARKS TRUSTFUND (136) 35 PROFESSIONAL SERVICES CUMEIERY MAINTENANCE TRUSTFUND (137) 36 SMALL EQUIPMENT SISTER CITY COMMISSION (138) 37 SUPPLIES 38 TRAVEL 39 MISCELLANEOUS BUSINESS IMPROVEMENT DISTRICT FUND (140) 40 SUPPLIES 41 PROFESSIONAL SERVICES 42 MISCELLANEOUS EDMONDS RESCUEPLAN FUND (142) 43 PROFESSIONAL SERVICES TREE FUND (143) 44 SUPPLIES 45 PROFESSIONAL SERVICES 46 LAND $ 256,260 $ 22,499 $ 16,831 $ 239,429 79 550,800 13,266 - 550,800 09 147,557 - - 147,557 09 - - 50,000 (50,000) 09 554,755 97,473 - 554,755 09 155,470 - - 155,470 09 103,970 - - 103,970 09 $ 1,768,812 $ 133,238 $ 66,831 $ 1,701,981 49 $ 196,455 $ $ 7,431 $ 189,024 49 - 437 (437) 09 80,033 1,620 78,413 29 146,000 2,462 13,158 132,842 99 500 - - 500 09 56,500 - 56,500 09 17,510 4,378 13,132 259 600 - 173 427 299 $ 497,598 $ 2,462 $ 27,197 $ 470,401 59 $ 137,541 $ 21,898 $ 41,189 $ 96,352 309 3,500 210 707 2,793 209 54,487 9,412 13,400 41,087 259 1,000 - - 1,000 09 7,000 45 2,241 4,759 329 20,000 5,253 5,898 14,102 299 4,200 800 1,438 2,762 349 1,700 428 432 1,268 259 500 - - 500 09 9,420 2,923 2,387 7,033 259 5,565 888 1,383 4,182 259 500 - - 500 09 4,000 3,868 4,455 (455) 1119 $ 249,413 $ 45,724 $ 73,531 $ 175,882 299 $ 43,842 $ $ - $ 43,842 09 $ 43,842 $ $ - $ 43,842 09 $ 50,000 $ $ - $ 50,000 09 $ 50,000 $ $ - $ 50,000 09 $ 1,500 $ $ - $ 1,500 09 4,500 - 4,500 09 5,900 219 5,681 49 $ 11,900 $ $ 219 $ 11,681 29 $ 4,091 $ 94 $ 298 $ 3,793 79 78,327 10,835 9,204 69,123 129 6,157 172 674 5,483 119 88,575 11,101 10,176 78,399 119 $ 1,249,000 $ 232,175 $ 663,059 $ 585,941 539 1,249,000 232,175 663,059 585,941 539 $ 1,000 $ $ - $ 1,000 09 39,800 - 39,800 09 199,000 - 199,000 09 239,800 - 239,800 09 O Q. d OC W C to C IL 21 z C O 2 M N 0 N t V L O O Q. d <0 C O C iL s C O M N 0 N t U L cC C N E t Q 26 Packet Pg. 30 I 2.2.a I Page 4 of 6 C ITY OF EDMO NDS EXPENDITURES BY FUND - DErAIL 2023 Adopted 3/31/2022 3/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent 2012 LTGO DEBT SERVIC FUND (231) GENERAL OBLIGATION BOND $ 235,000 $ $ - $ 235,000 09 INTEREST 74,800 - 74,800 09 $ 309,800 $ $ - $ 309,800 09 PARKS CONSTRUCTION FUND (332) 3 INTERFUND SUBSIDIES 4 PROFESSIONAL SERVICES 5 CONSTRUCTION PROJECTS 6 GENERAL OBLIGATION BONDS 7 INTEREST WATER FUND (421) 8 SALARIES AND WAGES 9 OVERTIME 10 BENEFIT S 11 UNIFORMS 12 SUPPLIES 13 WATER PURCHASED FOR RESALE 14 SUPPLIES PURCHASED FOR INVENTORY/RESALE 15 SMALL EQUIPMENT 16 PROFESSIONAL SERVICES 17 COMMUNICATIONS 18 TRAVEL 19 EXCISE TAXES 20 RENTAL/LEASE 21INSURANCE 22 UTILITIES 23 REPAIRS & MAINTENANCE 24 MISCELLANEOUS 25 INTERFUND SUBSIDIES 26 BUILDINGS 27 MACHINERY/EQUIPMENT 28 CONSTRUCTION PROJECTS 29 GENERAL OBLIGATION BONDS 30 REVENUE BONDS 31 INTERGOVERNMENTAL LOANS 32 INTEREST STORM FUND (422) 33 SALARIES AND WAGES 34 OVERTIME 35 BENEFIT S 36 UNIFORMS 37 SUPPLIES 38 SMALL EQUIPMENT 39 PROFESSIONAL SERVICES 40 COMMUNICATIONS 41 TRAVEL 42 EXCISE TAXES 43 RENTAL/LEASE 44INSURANCE 45 UTILITES 46 REPAIR & MAINTENANCE 47 MISCELLANEOUS 48 INTERFUND SUBSIDIES 49 LAND 50 BUILDINGS 51 CONSTRUCTION PROJECTS 52 GENERAL OBLIGATION BONDS 53 REVENUE BONDS 54 INTERGOVERNMENTAL LOANS 55 INTEREST $ - $ 62,656 $ - $ - 09 1,352,620 91,809 21,528 1,331,092 29 805,377 1,475,816 547,466 257,911 689 50,000 - - 50,000 09 47,650 - - 47,650 09 $ 2,255,647 $ 1,630,281 $ 568,994 $ 1,686,653 259 $ 963,268 $ 190,522 $ 301,339 $ 661,929 319 24,000 4,561 3,434 20,566 149 393,439 79,936 98,914 294,525 259 4,000 1,221 2,129 1,871 539 150,000 44,060 37,820 112,180 259 2,398,000 262,019 292,333 2,105,667 129 180,000 57,613 49,808 130,192 289 13,500 670 1,838 11,662 140 2,256,928 127,633 361,364 1,895,564 169 35,000 6,709 7,968 27,032 239 200 - - 200 09 1,696,934 318,512 333,368 1,363,566 209 187,952 37,987 46,612 141,340 259 215,319 122,359 225,379 (10,060) 1050 35,000 8,339 9,625 25,375 289 71,130 11,535 11,705 59,425 160 123,600 61,398 65,304 58,296 539 646,370 - - 646,370 09 12,500 12,500 09 10,000 - - 10,000 09 1,670,000 87,212 47,283 1,622,717 39 2,940 - - 2,940 09 333,830 333,830 09 25,840 25,840 09 185,300 - - 185,300 09 $ 11,635,050 $ 1,422,285 $ 1,896,223 $ 9,738,827 169 $ 821,952 $ 196,131 $ 357,241 $ 464,711 439 26,000 7,110 2,653 23,347 109 342,317 80,379 113,161 229,156 330 6,500 4,640 3,858 2,642 590 46,000 19,986 3,805 42,195 89 4,000 587 - 4,000 09 3,124,919 199,607 190,606 2,934,313 69 3,200 1,091 1,631 1,569 510 4,300 - - 4,300 09 499,658 201,489 207,849 291,809 420 293,210 66,250 72,519 220,691 259 30,265 82,335 31,680 (1,415) 1050 10,500 4,748 4,302 6,198 419 189,130 11,040 11,065 178,065 69 232,300 73,657 51,240 181,060 229 283,237 - - 283,237 09 680,000 - 680,000 09 25,000 - - 25,000 09 1,031,645 194,065 75,768 955,877 79 107,290 - - 107,290 09 160,870 - 160,870 09 61,600 - 61,600 09 103,070 - - 103,070 09 $ 8,086,963 $ 1,143,115 $ 1,127,379 $ 6,959,584 149 O Q. d <0 C t0 C M t C O M N O N t v c`o O Q d <0 C C IL z C O M N O N t U L C d E t U O Q 27 Packet Pg. 31 I 2.2.a I Page 5 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Adopted 3/31/2022 3/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent SEWER FUND (423) 1 SALARIES AND WAGES $ 2,468,518 $ 467,317 $ 866,696 $ 1,601,822 359 2 OVERTIME 130,000 44,128 52,714 77,286 419 3 BENEFITS 867,257 184,029 290,355 576,902 339 4 UNIFORMS 11,500 4,794 5,689 5,811 490 5 SUPPLIES 453,000 67,115 100,721 352,279 229 6 FUEL CONSUMED 20,000 - - 20,000 09 7 SUPPLIES PURCHASED FOR INV OR RESALE 5,000 - - 5,000 09 8 SMALL EQUIPMENT 83,900 89,777 2,146 81,754 M 9 PROFESSIONAL SERVICES 2,587,949 511,460 534,970 2,052,979 219 10 COMMUNICATIONS 48,000 10,851 12,203 35,797 259 11 TRAVEL 5,000 - - 5,000 09 12 EXCISE TAXES 1,026,360 217,029 311,045 715,315 309 13 RENTAL/LEASE 312,006 81,329 77,630 234,376 259 14 INSURANCE 344,564 203,936 362,302 (17,738) 1059 15 UTILITIES 1,582,060 364,051 593,215 988,845 379 16 REPAIR& MAINTENANCE 728,630 317,205 57,197 671,433 89 17 MISCELLANEOUS 138,350 44,414 82,252 56,098 599 18 INTERFUND SUBSIDIES 1,588,089 - - 1,588,089 09 19 BUILDINGS 12,500 - - 12,500 09 20 CONSTRUCTION PROJECTS 2,976,163 1,092,673 - 2,976,163 09 21 GENERAL OBLIGATION BONDS 129,820 - - 129,820 09 22 REVENUE BONDS 55,310 - - 55,310 09 23 INTERGOVERNMENTAL LOANS 104,000 15,397 15,754 88,246 150 24 INTEREST 353,270 2,786 2,582 350,688 19 25 OTHER INT ERESr & DEBT SERVICE COSTS - 2,102 1,948 (1,948) 09 $ 16,031,246 $ 3,720,393 $ 3,369,420 $ 12,661,826 219 BOND RESERVEFUND (424) 26 REVENUE BONDS $ 840,010 $ $ $ 840,010 09 27INTEREST 1,149,810 1,149,810 09 $ 1,989,820 $ $ - $ 1,989,820 09 Q 20 Packet Pg. 32 I 2.2.a I Page 6 of 6 C ITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Adopted 3/31/2022 3/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent EQ UIPMENT RENTAL FUND (511) 1 SALARIES AND WAGES $ 279,652 $ 73,548 $ 130,524 $ 149,128 479 2 OVERTIME 2,000 222 - 2,000 09 3 BENEFITS 105,497 29,018 37,199 68,298 350 4 UNIFORMS 1,500 689 519 981 359 5 SUPPLIES 149,120 45,415 19,687 129,433 130 6 FUEL CONSUMED 1,000 - - 1,000 09 7 SUPPLIES PURCHASED FOR INVENTORY/RESALE 458,880 112,225 100,429 358,451 229 8 SMALL EQUIPMENT 58,000 1,950 362 57,638 19 9 PROFESSIONAL SERVICES 46,750 349 418 46,332 19 10 COMMUNICATIONS 3,000 516 756 2,244 259 11 TRAVEL 1,000 - - 1,000 09 12 RENTAL/LEASE 17,470 2,526 4,191 13,279 249 13 INSURANCE 47,938 51,903 52,373 (4,435) 1099 14 UTILITIES 14,000 5,850 7,458 6,542 530 15 REPAIRS & MAINTENANCE 60,000 9,606 11,621 48,379 199 16 MISCELLANEOUS 12,000 1,441 1,827 10,173 159 17 MACHINERY/EQUIPMENT 3,109,411 10,903 461,925 2,647,486 159 $ 4,367,218 $ 346,163 $ 829,288 $ 3,537,930 199 TEC HNO LO GY RENTAL FUND (512) 18 SALARIES AND WAGES $ 600,771 $ 66,179 $ 131,533 $ 469,238 229 19 OVERTIME 2,000 - - 2,000 09 20 BENEFITS 180,554 26,961 45,402 135,152 259 21 SUPPLIES 5,000 2,075 1,718 3,282 349 22 SMALL EQUIPMENT 181,800 15,261 51,415 130,385 289 23 PROFESSIONAL SERVICES 61,860 3,349 10,026 51,834 169 24 COMMUNICATIONS 58,770 12,087 14,186 44,584 249 25 TRAVEL 1,500 - - 1,500 09 26 RENTAL/LEASE 4,640 1,115 410 4,230 99 27 REPAIRS & MAINTENANCE 476,532 375,901 419,006 57,526 889 28 MISCELLANEOUS 55,600 50 9,770 45,830 189 29 MACHINERY/EQUIPMENT 56,000 - - 56,000 09 $ 1,685,027 $ 502,978 $ 683,467 $ 1,001,560 419 TOTAL EXPENDITURE ALL FUNDS $ 126,732,225 $ 22,715,212 $ 26,946,235 $ 99,785,990 219 O CL d <0 C c0 C IL t C O M N O N t V L O O O. d w <0 C C iL z r C O a M N O N t U L C� G r I_ 0 Q 29 Packet Pg. 33 2.2.a Page 1 of 1 M I VC13aD1311C19AIM 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. PLANNING & DEVELOPMENT HUMAN SERVICES PROGRAM PARKS& RECREATION PUBLIC WORKS FACILITIES MAINTENANCE Title 2023 Adopted 3/31/2022 3/31/2023 Amount Budget Expenditures Expenditures Remaining %Spent $ 480,256 $ 71,408 $ 108,460 $ 371,796 23% 495,273 89,568 101,671 393,602 21% 1,254,947 203,581 230,737 1,024,210 18% 1,451,763 284,025 352,625 1,099,138 24% 2,217,666 547,460 774,413 1,443,253 35% ,E 1,161,780 233,065 186,270 975,510 16% Q. 15,120,425 4,072,745 4,986,307 10,134,118 33% d 14,981,027 3,008,075 3,173,554 11,807,473 21% tj C 145,681 21,922 26,541 119,140 18% 1,199,451 122,479 263,059 936,392 22% 4,976,888 909,669 913,919 4,062,969 18% 324,650 25,870 56,209 268,441 17% O 6,022,817 1,040,803 1,386,849 4,635,968 23% C 3,842,053 757,219 967,711 2,874,342 25% cm t v 4,013,010 562,089 1,264,752 2,748,258 32% $ 57,687,687 $ 11,949,976 $ 14,793,075 $ 42,894,612 26% O 0. O CITY OF EDMO NDS EXPENDITURES - UTILITY- BY FUND IN SUMMARY C 2023 Adopted 3/31/2022 3/31/2023 Amount IL >% Budget Expenditures Expenditures Remaining %Spent z WATER UTILITY FUND $ 11,635,050 $ 1,422,285 $ 1,896,223 $ 9,738,827 16% r_ 0 n STORM UTILITY FUND 8,086,963 1,143,115 1,127,379 6,959,584 14% N SEWER/WWTP UTILITY FUND 16,031,246 3,720,393 3,369,420 12,661,826 0 21% N BOND RESERVE FUND 1,989,820 - - 1,989,820 0% t i $ 37,743,079 $ 6,285,793 $ 6,393,021 $ 31,350,058 17% r c a� E t U to Q 30 Packet Pg. 34 I 2.2.a I Page 1 of 2 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL Title 2023 Adopted Budget 3/31/2022 Expenditures 3/31/2023 Expenditures Amount Remaining %Spent CITY COUNCIL SALARIES AND WAGES $ 214,276 $ 42,890 $ 54,958 $ 159,318 26% BENEFITS 102,845 23,106 25,827 77,018 25% SUPPLIES 11,000 236 433 10,567 4% SERVICES 152,135 5,176 27,243 124,892 18% $ 480,256 $ 71,408 $ 108,460 $ 371,796 23% OFFICEOFMAYOR SALARIES AND WAGES $ 274,988 $ 61,694 $ 64,189 $ 210,799 23% BENEFITS 88,487 21,658 22,420 66,067 25% _ SUPPLIES 1,500 1,440 284 1,216 19%' SERVICES 130,298 4,777 14,779 115,519 11% s?. $ 495,273 $ 89,568 $ 101,671 $ 393,602 21% CD HUMAN RESOURCES SALARIES AND WAGES $ 747,258 $ 116,150 $ 127,367 $ 619,891 1770 t� BENEFITS 236,609 41,649 48,229 188,380 20% SUPPLIES 13,600 246 460 13,140 3% C SERVICES 257,480 45,536 54,682 202,798 21% M $ 1,254,947 $ 203,581 $ 230,737 $ 1,024,210 18% MUNICIPAL C O URT C SALARIES AND WAGES $ 937,770 $ 192,338 $ 235,460 $ 702,310 25% 0 BENEFITS 302,672 54,922 75,145 227,527 25% SUPPLIES 11,600 2,507 4,851 6,749 42% M N SERVICES 199,721 34,258 37,169 162,552 19% N $ 1,451,763 $ 284,025 $ 352,625 $ 1,099,138 24% t ADMINISTRATIVE SERVICES i SALARIES AND WAGES $ 1,418,894 $ 331,842 $ 487,548 $ 931,346 34% BENEFITS 429,103 110,163 129,844 299,259 30% SUPPLIES 13,000 2,729 2,796 10,204 22% SERVICES 356,669 102,725 154,225 202,444 43% 0. $ 2,217,666 $ 547,460 $ 774,413 $ 1,443,253 35% (D CITY ATPO RNEY SERVICES $ 1,161,780 $ 233,065 $ 186,270 $ 975,510 16% '0 $ 1,161,780 $ 233,065 $ 186,270 $ 975,510 16% NON -DEPARTMENTAL C SALARIES AND WAGES $ 101,750 $ - $ - $ 101,750 0% LL BENEFITS 239,583 18,865 37,772 201,811 16% s SUPPLIES 5,000 - - 5,000 0% SERVICES 13,537,502 4,003,880 4,898,535 8,638,967 36% 0 INTERFUND SUBSIDIES 913,000 50,000 50,000 863,000 5% z DEBT SERVICE - PRINCIPAL 191,620 - - 191,620 0% CO) DEBT SERVICE - INTEREST 131,970 - - 131,970 0% N $ 15,120,425 $ 4,072,745 $ 4,986,307 $ 10,134,118 33% t PO LIC E SERVIC ES SALARIES AND WAGES $ 9,556,760 $ 2,001,754 $ 1,975,849 $ 7,580,911 21% BENEFITS 3,303,628 692,447 720,278 2,583,350 22% SUPPLIES 342,941 28,690 33,205 309,736 10% SERVICES 1,777,698 285,184 444,221 1,333,477 25% E $ 14,981,027 $ 3,008,075 $ 3,173,554 $ 11,807,473 21% V S ATELLITE O FFIC E i4 SALARIES AND WAGES $ 38,537 $ - $ 10,920 $ 27,617 28% Q BENEFITS 7,298 - 2,075 5,223 28% SUPPLIES 12,000 10,980 - 12,000 0% SERVICES 87,846 10,941 13,545 74,301 15% $ 145,681 $ 21,922 $ 26,541 $ 119,140 18% 31 Packet Pg. 35 1 I 2.2.a I Page 2 of 2 CITY OF EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2023 Adopted 3/31/2022 3/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent COMMUNITY S ERVIC ES /EC O N DEV. SALARIES AND WAGES $ 550,413 $ 50,441 $ 159,276 $ 391,137 29% BENEFITS 153,183 16,285 40,747 112,436 27% SUPPLIES 4,075 184 391 3,684 10% SERVICES 491,780 55,568 62,645 429,135 13% $ 1,199,451 $ 122,479 $ 263,059 $ 936,392 22% PLANNING & DEVELOPMENT SALARIES AND WAGES $ 2,176,581 $ 542,158 $ 558,228 $ 1,618,353 26% BENEFITS 736,473 183,402 209,013 527,460 28% SUPPLIES 23,400 1,366 3,275 20,125 14% SERVICES 2,040,434 182,744 143,403 1,897,031 7% $ 4,976,888 $ 909,669 $ 913,919 $ 4,062,969 18% HUMAN SERVICES PROGRAM SALARIES AND WAGES $ 101,849 $ 14,413 $ 27,870 $ 73,979 27% BENEFITS 29,301 2,888 8,012 21,289 27% SUPPLIES 15,000 59 661 14,339 4% SERVICES 178,500 8,510 19,666 158,834 11% 324,650 25,870 56,209 268,441 17% PARKS & REC REATIO N SALARIES AND WAGES $ 2,859,976 $ 571,618 $ 824,595 $ 2,035,381 29% BENEFITS 968,480 202,033 266,030 702,450 27% SUPPLIES 468,900 41,287 59,789 409,111 13% SERVICES 1,635,461 225,866 236,436 1,399,025 14% MACHINERY/EQUIPMENT 90,000 - - 90,000 0% $ 6,022,817 $ 1,040,803 $ 1,386,849 $ 4,635,968 23% PUBLIC WORKS ADMINISTRATION SALARIES AND WAGES $ 372,900 $ 33,162 $ 104,156 $ 268,744 28% BENEFITS 142,675 16,076 31,472 111,203 22% SUPPLIES 9,600 1,211 3,618 5,982 38% SERVICES 92,439 20,793 21,297 71,142 23% $ 617,614 $ 71,242 $ 160,542 $ 457,072 26% FACILITIES MAINTENANCE SALARIES AND WAGES 981,868 216,781 408,807 573,061 42% BENEFITS 402,717 84,651 136,778 265,939 34% SUPPLIES 128,000 18,660 33,813.86 94,186 26% SERVICES 1,359,860 241,997 396,629 963,231 29% MACHINERY/EQUIPMENT 1,140,565 288,725 851,840 25% $ 4,013,010 $ 562,089 $ 1,264,752 $ 2,748,258 32% ENGINEERING SALARIES AND WAGES $ 2,194,963 $ 461,480 $ 555,827 $ 1,639,136 25% BENEFITS 772,724 173,033 199,868 572,856 26% SUPPLIES 2,200 - 862 1,338 39% SERVICES 254,552 51,464 50,612 203,940 20% $ 3,224,439 $ 685,977 $ 807,168 $ 2,417,271 25% TOTAL GENERAL FUND EXPENDITURES $ 57,687,687 $ 11,949,976 $ 14,793,075 $ 42,894,612 26% F O Q. d R C eo C M 2+ t C O 2 M N 0 N t 0 L cc O C. d C O C IL 21 s C O z CO) N O N t U L M 2 C d E t U O Q 32 Packet Pg. 36 2.2.a GENERAL FUND OVERVIEW BALANCES CHANGE IN FUND BALANCES GENERAL FUND ---- ACTUAL ---- ---- ACTUAL ---- & SUBFUNDS 3/31 /2023 3/31 /2023 Q1 YTD Fund Balance Cash Balance 001-General Fund $ 5,001,036 $ 2,600,732 $ (6,642,630) $ (6,642,630. 009-Leoff-Medical Ins. Reserve 114,591 130,544 (102,272) (102,272: 011-Risk Management Reserve Fund 25,000 25,000 - - 012-ContingencyReserve Fund 1,782,150 1,782,150 - - 014-Historic Preservation Gift Fund 11,701 11,701 - - �a 016-Building Maintenance 4,219,488 4,362,764 (77,116) (77,116. c 017 - Marsh Restoration & Preservation 849,766 849,766 - - ii 018 - Edmonds Homelessness Response Fd 200,000 200,000 - - 21 Total General Fund & Subfunds $ 12,203,732 $ 9,962,656 $ (6,822,019) $ (6,822,019 C M N *$9,361,208 of the fund balance in Fund 001 added to the $1,782,150 balance in Fund 012, represent the required 0 N 20% operating reserve. 2- There are no interfund loans outstanding at this time. 1` 0 Q. m GOVERNMENTAL FUNDS OVERVIEW U_ BALANCES CHANGE IN FUND BALANCES 0 GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- CO) FUNDS 3/31 /2023 3/31 /2023 Q1 YTD 0 N Fund Balance Cash Balance — t i General Fund & Subfunds $ 12,203,732 $ 9,962,656 $ (6,822,019) $ (6,822,019. Special Revenue 15,758,161 23,077,486 (592,673) (592,673 c E Capital Projects - Fund 332 (202,396) (281,113) (410,079) (410,079 c� Total Governmental Funds $ 27,759,496 $ 32,759,029 $ (7,824,770) $ (7,824,770 Q *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 3/31/2023 3/31/2023 Q1 YTD Fund Balance Cash Balance 104 - Drug Enforcement Fund $ 67,629 $ 70,882 $ 59 $ 59 111 - Street Fund (228,227) (169,267) (636,911) (636,911 112 - Combined Street Const/Im prove 2,849,017 361,011 409,512 409,512 o 117 - Municipal Arts Acquis. Fund 638,484 668,687 3,596 3,596 a) 120 - Hotel/Motel Tax Revenue Fund 117,165 106,639 22,301 22,301 121 - Employee Parking Permit Fund 85,399 88,879 10,367 122 - Youth Scholarship Fund 15,221 15,927 13 13 coo 123 -Tourism Promotional Fund/Arts 122,121 122,095 6,951 6,951 ii 125 -Real Estate Tax 2 3,315,960 3,403,440 23,403 23,403 >+ 126 - Real Estate Excise Tax 1 * 4,223,096 4,331,330 197,574 197,574 127 - Gifts Catalog Fund 3,070,510 3,212,613 6,718 6,718 0 130 - Cemetery Maintenance/Improvement 245,632 258,750 (22,537) (22,537 136 - Parks Trust Fund 153,942 161,439 (7,497) (7,497 c 137- Cemetery Maintenance Trust Fund 1,109,907 1,161,079 6,606 6,606 t 138 - Sister City Commission 19,692 20,615 (202) (202 140 -Business Improvement Disrict 67,697 67,697 27,913 27,913 141 -Affordable and Supportive Housing Fd 255,878 248,240 21,312 21,312 V_ 142 - Edmonds Rescue Plan Fund (597,461) 8,710,438 (662,049) (662,049; 0 143 - Tree Fund 226,497 236,993 198 198 Total Special Revenue $ 15,758,161 $ 23,077,486 $ (592,673) $ (592,673 *$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 '' 0 2 CO) N O N BALANCES CHANGE IN FUND BALANCES 2 L ENTERPRISE M ---- ACTUAL ---- ---- ACTUAL ---- 2 FUNDS 3/31/2023 3/31/2023 Q1 YTD Fund Balance Cash Balance E t 421 -Water Utility Fund $ 32,578,533 $ 9,703,042 $ 689,909 $ 689,909 422-Storm Utility Fund* 19,223,209 6,085,763 1,151,439 1,151,439 Q 423 - Sewer/WWTP Utility Fund 63,944,318 14,975,696 1,500,483 1,500,483 424 - Bond Reserve Fund 847,053 847,053 3,093 3,093 411 -Combined Utility Operation 37,625 88,007 37,625 37,625 Total Enterprise Funds $ 116,630,738 $ 31,699,562 $ 3,382,549 $ 3,382,549 *$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 3/31 /2023 3/31 /2023 Q1 YTD Fund Balance Cash Balance Governmental Funds $ 27,759,496 $ 32,759,029 $ (7,824,770) $ (7,824,770 Enterprise Funds 116,630,738 31,699,562 3,382,549 3,382,549 Internal Services Fund 9,758,332 5,419,001 (599,997) (599,997 0 CL m Total City-wide Total $ 154,148,566 $ 69,877,591 $ (5,042,219) $ (5,042,219 Ta .v c ii 21 INTERNAL SERVICE FUNDS OVERVIEW 0 2 M N O N L V L BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- 0 Q- INTERNAL SERVICE FUNDS 3/31 /2023 3/31 /2023 Q1 YTD W Fund Balance Cash Balance @ U c 511 - Equipment Rental Fund $ 9,126,813 $ 5,091,975 $ (269,014) $ (269,014 ii 512 -Technology Rental Fund 631,519 327,026 (330,983) (330,983 21 t Total Internal Service Funds $ 9,758,332 $ 5,419,001 $ (599,997) $ (599,997 c 0 Z CO) N O N t V L C� G r E L 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 2.2.b GENERAL FUND CHANGES IN FUND BALANCE 2022 2022 2023 2018 2019 2020 2021 Preliminary (Jan -March) (Jan -March) Beginning Fund Balance 10,273,342 11,233,279 15,552,188 13,868,744 15,915,322 15,915,322 11,643,670 Revenue Taxes 30,755,578 30,846,665 30,738,452 32,979,704 34,209,103 5,233,427 6,216,061 Licenses and permits 2,401,855 2,299,972 2,276,861 2,453,186 2,560,170 666,258 599,769 Intergovernmental 1,014,434 1,008,432 1,633,633 1,608,646 1,367,288 209,486 206,674 Charges for services 5,810,961 6,419,836 5,412,044 5,913,557 2,761,337 1,004,658 906,937 Fines and forfeitures 616,783 496,093 287,693 272,302 182,881 30,353 68,894 Interest earnings 273,228 573,806 265,627 122,257 (34,099) 77,194 17,046 Miscellaneous 931,495 587,882 322,816 347,519 368,221 69,412 135,064 Operating Revenues Nonoperating Revenues Transfers in Debt proceeds Sale of capital assets Insurance recoveries Total Revenue Expenditures General government Public safety Transportation Economic environment Mental and physical health Culture and recreation Debt service Capital outlay Operating Expenditures Nonoperating Expenditures Transfers out Debt refunding Total Expenditures Prior Period Adjustments Change in position 41,804,334 42,232,686 40,937,126 43,697,171 41,414,902 7,290,787 8,150,445 75,884 4,793,650 1,535,800 388,547 26,300 - - 5,273 - - - - - - 15,570 - 16,977 - 257,520 - - 41,901,061 47,026,336 42,489,903 44,085,718 41,698,721 7,290,787 8,150,445 10,288,694 11,565,563 12,514,526 11,866,885 9,844,859 3,476,815 4,484,428 22,585,212 23,036,185 23,759,212 22,765,260 26,117,663 6,803,024 7,900,455 4,779 5,012 5,012 2,088 - - - 1,460,763 1,562,702 1,675,334 1,991,624 2,278,849 576,185 596,330 178,859 164,888 147,957 84,642 38,676 3,122 3,605 4,331,806 4,158,397 3,732,644 4,341,658 4,930,157 1,090,831 1,506,388 197,694 197,967 296,624 60,228 321,989 - - 93,105 110,935 835,048 268,885 1,123,119 - 301,869 39,140,912 40,801,649 42,966,358 41,381,270 44,655,313 1,800,212 1,905,778 1,206,990 657,870 1,315,062 11,949,976 14,793,075 40,941,124 42,707,427 44,173,348 42,039,140 45,970,374 11,949,976 14,7931,075 959,937 4,318,909 (1,683,445) 2,046,578 (4,271,653) (4,659,190) (6,642,630) Ending Fund Balance 11,233,279 15,552,188 13,868,744 15,915,322 11,643,670 11,256,133 5,001,039 O 2 c R c U- 21 z c O 2 M N 0 N z tt L ca J a CO) N O N L_ M 2 C O C N s Q R:\Finance Committee\2023\Jan-Mar 2023 P&L 4/28/2023 Packet Pg. 40 March 2023 Monthly Financial Report May 9, 2023 Cz u 1� Packet Pg. 41 Other items to note are: • Page 21— Sales Tax is up $114,851 from this point in time last year. • Page 21— Gas Utility Tax is up $47,783. • Page 21— Telephone Utility Tax is down $(38,165) from this time last year. Most February telephone utility tax payments that are normally recorded in March were recorded on 4/4. • Page 22 —Building Plan Review and Inspection Fees are up $82,333 from this point in time last year, Building Permits are down $(79,833), and Engineering Fees and Charges are down $(55,549). Development Services revenues overall are down a total of $(65,121) from this point in time last year. • Page 22 — Parks & Recreation Program Fees are up $44,598 from this point in time last year. • Page 23 - Total Interest Earnings for all funds are down a total of $(50,731) from this point in time last year; Fund 001 interest earnings are down $(67,881). • Page 23 — We have received $120,467 more in interest with the LGIP from this point in time last year, and $117,193 more in interest with the SCIP from this point in time last year for a total of $237,660. We also took $5 million out of the SCIP in April which we reinvested at higher yields. We will take another $5 million out of the SCIP in May. F. I w r� Q Packet Pg. 42 YTD Sales Tax Revenues for the 3 months ended March 31 $114,851 ahead of last year, and $73,749 under budget Sales and'Use Tax CLJFri ul at vo Monthly YTD bra ria r re Budget forecast Budget forecast ACtL.aIs Ja rr nary February March Apra Ma y fUnE July August September October November December 911,577 1r999,4D$ 2r$54,859 3r643,225 4,624,484 5,567,972 6,580,085 7,669,335 9,683,582, 9,76.9,647 10,864,900 11,500,000 911,577 1r087,831 $5�57,451 788,366 981,259 943,488 1,012,114 1,099, 249 1,014,248 1,085,064 1,096,253 1,035,100 879,231 1,908,832 2,781,110 -3.55% -4.53 % -2.58 Sales and LTse Tax 1, _0 } 011 _A 00.000 9.00 0,W0 s:a00,w0 7. }0-0} j0y,00y{0� 6, l}yl,() jVya�y,��{O �J-l��yl,,0 �Vyya}lJ�y}{,O 4.0-0lJa000 ..,_ DOO, D00 -1, D00, D00 1, DO4, D00 0 JAN FEB MAR APR MAY JU YUL. AUGEP OC-r NOV DEC: Current Year -Budget Prior Dear U�ry w 'O Packet Pg. 43 0 c U- 0 CM N O N U 0 LO 0 +C+ G d d r E E 0 U a� c M c U- c m E t U r r a Breakdown by business category of the change in Sales Tax revenue for March 2023 compared to March 2022 Total Retail Automotive Eating & Dtinking C onstrmtion Trade Business Services Others Retail Food Stores Automotive Repair Anmisement & Recreation Health & Personal Care Accommodation Manufacturing Gasoline Com*T imications Clotiung and Accessories isc Retail Wholesale Trade zs0,000) Change in Sales Tax Revenue: March 2023 compared to March ?022 so $25o.o YTD Sales Tax Revenues by Group Sales Tax Analysis By Group Current Period: March 2023 Last 12 Months Total $11,372,778 Retail Food Stores Retail Autaimtrve S366,196 Automotive Repair $2,758,569 $245,798 r Business Sen-ices $1,20D,177 Accommodation $54,559 Coiummicatians $241,635 Wholesale Trade $340,563 Misc Retail Construction T $2,072,986 Manufacturing $129,633 Gasoline $4 Eating & Drinking $1,307,376 Health & Personal Care I $71,776 $1.789.799 Others $335,988 Ainrsernent & Recreation $78,756 Clothing and Accessories $379,964 ED40 �O Q w Packet Pg. 45 Total Annual Sales Tax Revenues from 2010 through 2022, plus projection for 2023 0 C Sales Tax: 2010-2022 Actual 2023 Projected LL $12,000,000 r 0 M N O N $10,000,000 v L C� C cl $8,000,000 LO 0 G $6,000,000 r E 0 U $4,000,000 U c� c R c ii c $2,000,000 m t v �p ED40 Q r 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 ■ Actual 0 Projected • Packet Pg. 46 $30,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 Combined Property Tax and Sales Tax Revenues from 2010 through 2022, plus projection for 2023 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 ■ Prop Tax ■ Sales Tax I. E 0 LL t r c O M N O N LO V L C� C 0 I 0 a� O d r r E E O U O U c R c ii c d E t v O r Q Packet Pg. 47 Thank you. Packet Pg. 48 2.3 City Council Agenda Item Meeting Date: 05/9/2023 ERP Update Staff Lead: Dave Turley Department: Administrative Services Preparer: Dave Turley Background/History The City currently uses Eden, a product from Tyler Technologies, as their financial accounting system. The City has used Eden for over 20 years, an extremely long time when it comes to financial systems. Tyler Technologies will be "sunsetting" the Eden system in 2027. We have begun the process to replace the Eden system and will be providing periodic updates. Staff Recommendation For discussion. Narrative Replacing the Eden system will be a process that takes a significant amount of time, labor, and money. We will provide a project update tonight. Packet Pg. 49