The URL can be used to link to this page

2024-01-09 Council FIN Packet1 2 OF BbMG ti Agenda Edmonds City Council 1,00 FINANCE COMMITTEE CITY COUNCIL CONFERENCE ROOM 121 - 5TH AVENUE N, EDMONDS, WA 98020 JANUARY 9, 2024, 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 3:30- 930 PM AT THE CITY COUNCIL CONFERENCE ROOM AT 121 5TH AVE N, EDMONDS WA. COMMITTEE MEMBERS: WILL CHEN (CHAIR), JENNA NAND, COUNCIL PRESIDENT (EX-OFFICIO MEMBER) CALL TO ORDER COMMITTEE BUSINESS 1. November 2023 Monthly Financial Report (10 min) 2. Finance Committee 2024 Work Plan (40 min) ADJOURNMENT: 7:30 PM Edmonds City Council Agenda January 9, 2024 Page 1 2.1 City Council Agenda Item Meeting Date: 01/9/2024 November 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 November 2023 Monthly Financial Report Attachments: November 2023 Monthly Financial Report October 2023 Monthly Financial Report Packet Pg. 2 I 2.1.a I U~ O-v EDP � d 1)7 c 1 g0v CITY OF EDMONDS MONTHLY BUDGETARY FINANCIAL REPORT NOVEMBER 2023 Packet Pg. 3 1 I 2.1.a I INVESTMENT PORTFOLIO SUMMARY City of Edmonds Investment Portfolio Detail As of November 30, 2023 Years Agency/ Investment Purchase to Par Market Maturity Coupon Issuer Type Price Maturity Value Value Date Rate O Kent WA Bonds 286,648 0.00 250,000 250,000 12/01/23 5.00% d First Financial - Waterfront Center CD 245,000 0.08 245,000 245,000 12/28/23 1.49% FHLB Bonds 2,004,464 0.13 2,000,000 1,997,777 01/16/24 4.81% .O 3 FHLB Bonds 954,866 0.36 1,000,000 981,419 04/10/24 0.35% FM Bonds 996,082 0.55 1,000,000 986,044 06/17/24 2.80% _ LL FNMA Bonds 992,693 0.59 1,000,000 979,661 07/02/24 1.75% FFCB Bonds 1,960,906 0.79 2,000,000 1,973,823 09/13/24 3.50% r FHLB Bonds 950,774 0.97 1,000,000 959,072 11/18/24 0.90% 0 O Spokane County WA Bonds 207,260 1.01 200,000 194,084 12/01/24 2.10% M FHLMC Bonds 974,798 1.28 1,000,000 984,054 03/13/25 3.75% C Farmer Mac Bonds 1,995,088 1.38 2,000,000 1,979,116 04/17/25 4.25% N FHLB Bonds 969,524 1.66 1,000,000 981,276 07/28/25 3.60% L 0) US Treasury Note Note 964,597 1.71 1,000,000 973,008 08/15/25 3.13% O FFCB Bonds 1,982,692 2.02 2,000,000 1,977,107 12/08/25 4.13% > O Farmer Mac Bonds 1,994,172 2.18 2,000,000 1,971,770 02/02/26 3.95% ? FHLMC Bonds 993,661 2.64 1,115,000 1,010,637 07/22/26 0.83% Farmer ac M Bonds 2,057,309 2.97 2,305,000 2,090,879 11/17/26 1.15% O Q O First Financial - ECA CD 2,803,516 3.96 2,803,516 2,803,516 11/15/27 2.96% TOTAL SECURITIES 23,334,050 1.35 23,918,516 23,338,243 Washington State Local Gov't Investment Pool 20,353,886 20,353,886 Demand 5.44% Snohomish County Local Gov't Investment Pool 23,919,663 23,919,663 Demand 2.88% TOTAL PORTFOLIO $ 68,192,064 $ 67,611,791 Kent Issuer Diversification Fi rst WA, Financial- 1% CD, 13% N4 okane Farmer County Mac, 26% WA, 1% FFCB, 17% FHLMC, 9% FHLB, 21% :Cashandnvestment Balances Checking, $ Millions) _$4 74 7% s, 7, State LGIP, $20.35 , 28% Note, qq $1.00, 1%County CD's,LGIP, $3.05,23.92, 4% 33% 1 Packet Pg. 41 INVESTMENT PORTFOLIO SUMMARY I 2.1.a I Annual Interest Income $1,517,098 Packet Pg. 5 1 GENERAL FUND SUMMARY I 2.1.a I General Fund Revenues and Expenses (Rolling 24 months) — — — General Fund Revenues General Fund Expenses 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 December March 12,000,000 10,000, 000 8,000,000 6,000,000 4,000,000 2,000,000 12,000,000 11,000,000 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 51000,000 4,000,000 3,000, 000 2,000,000 1,000, 000 June September December March June September General Fund Tax Revenue (2017 through 2022 — — — Sales Tax Property Tax EMS Tax Other Taxes 2017 2018 Sales Tax 2019 2020 2021 2022 General Fund Tax Revenue (2023 YTD) 1 n,�n�.949 1 ��w Property Tax EMS Tax Other Taxes F 0 a m c R c ii t c 0 M N O N L d E 0 Z 3 Packet Pg. 6 I 2.1.a I City of Edmonds, WA Monthly Revenue Summary -General Fund 2023 General Fund Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 2,843,094 $ 2,843,094 $ 2,320,252 -18.39% February 5,636,382 2,793,288 4,920,100 -12.71% March 8,487,993 2,851,611 8,150,445 -3.98% April 12,010,212 3,522,219 16,689,365 38.96% May 22,451,612 10,441,400 21,615,550 -3.72% June 25,498,180 3,046,568 23,772,230 -6.77% July 28,462,795 2,964,616 27,008,084 -5.11% August 31,857,014 3,394,219 30,494,023 -4.28% September 34,651,707 2,794,693 33,627,848 -2.95% October 39,245,890 4,594,183 41,665,078 6.16% November 49,438,148 10,192,259 46,406,295 -6.13% December 52,558,830 3,120,682 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 $ 343,196 $ 343,196 $ 151,084 -55.98% February 564,002 220,806 270,799 -51.99% March 914,189 350,187 521,829 -42.92% April 1,199,839 285,649 745,931 -37.83% May 1,552,936 353,097 1,053,507 -32.16% June 1,933,322 380,387 1,272,041 -34.20% July 2,318,897 385,574 1,582,268 -31.77% August 2,728,590 409,693 1,854,598 -32.03% September 3,157,962 429,373 2,189,986 -30.65% October 3,549,820 391,858 2,358,575 -33.56% November 3,941,307 391,487 2,552,056 -35.25% December 4,400,000 458,693 Real Estate Excise Tax 1 & 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. O IZ O !C C M C LL 21 L C O 2 CI) N O N L d E O z 4 Packet Pg. 7 SALES TAX SUMMARY I 2.1.a I Sales Tax Analysis By Category Current Period: November 2023 Year -to -Date Total $10,660,200 Automotive Repair, $239,901 Amusement & Recreation, $85,853 Construction Health & Personal Business Services, Accornniodation, Trade, Care. $78.499 _ S1.098.437 $47,358 $1,746,119 Clothing and Accessories, $324,631 Communications, $232,526 Wholesale Trade, $310,114 Misc Retail, $1,942,050 C,acnline M Retail Automotive, Manufacturing, Others, $286,202 Eating & Drinking, $119,520 $1,267,885 Annual Sales Tax Revenue 12,000,000 1 $10,302,518 10,000, 000 $7,395,114 $8,406,296 $8,452,715 $8,317,046 8,000, 000 6,000, 000 4,000, 000 2,000, 000 0 2017 2018 2019 2020 2021 I Food Stores, $357,877 7 $10,660,200 2022 YTD 2023 F 0 20 R _ t _ 0 2 M N 0 N L d E a� 0 z 5 Pt__1_-L Pf_. 8 ra�Ke� ry. o I 2.1.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 3,621,184 -0.60% May 4,624,484 981,259 4,607,308 -0.37% June 5,567,972 943,488 5,538,698 -0.53% July 6,580,085 1,012,114 6,542,037 -0.58% August 7,669,335 1,089,249 7,597,605 -0.94% September 8,683,583 1,014,248 8,581,012 -1.18% October 9,768,647 1,085,064 9,602,316 -1.70% November 10,864,900 1,096,253 10,660,200 -1.88% 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 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 —P— Current Yeaz 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 4,885,632 435.57% May 5,909,096 4,996,860 5,742,964 -2.81% June 6,029,957 120,861 5,794,100 -3.91% July 6,148,773 118,816 5,817,644 -5.39% August 6,198,768 49,995 5,868,802 -5.32% September 6,260,415 61,647 6,034,775 -3.60% October 6,466,132 205,717 9,911,687 53.29% November 11,227,156 4,761,024 10,603,949 -5.55% December 11,327,000 99,844 Real Pe rs onaMope rty 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 --0--CurrentYeaz Budget �PriorYear *The monthly budget forecast columns are based on a five-year average. 6 Packet Pg. 9 I 2.1.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 279,282 -3.31% May 373,578 84,744 363,282 -2.76% June 439,121 65,542 431,287 -1.78% July 541,031 101,910 543,193 0.40% August 629,368 88,337 633,755 0.70% September 748,356 118,987 752,727 0.58% October 835,253 86,898 835,975 0.09% November 933,046 97,793 926,022 -0.75% December 993,712 60,666 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 --P-- Current Year Budget -d-- Prior Year City of Edmonds, WA Monthly Revenue Summary -Sewer Utility Tax 2023 Sewer Utility Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % 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 333,172 -4.43% May 444,771 96,145 424,703 -4.51% June 523,850 79,080 501,909 -4.19% July 620,193 96,343 596,420 -3.83% August 699,682 79,489 673,646 -3.72% September 799,189 99,507 768,545 -3.83% October 879,620 80,432 846,310 -3.79% November 976,901 97,281 939,080 -3.87% December 1,055,821 78,920 Sewer Utility Tax 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. 7 Packet Pg. 10 I 2.1.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 1,439,675 -5.71% March 2,419,579 892,685 2,218,275 -8.32% April 3,010,919 591,341 2,792,540 -7.25% May 3,894,276 883,356 3,632,474 -6.72% June 4,577,455 683,180 4,312,420 -5.79% July 5,644,291 1,066,835 5,431,418 -3.77% August 6,565,058 920,767 6,336,928 -3.47% September 7,805,695 1,240,637 7,526,584 -3.58% October 8,711,524 905,829 8,358,957 -4.05% November 9,730,927 1,019,403 9,259,364 -4.85% 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 1,359,827 -11.44% March 2,020,122 484,671 1,794,224 -11.18% April 2,451,545 431,422 2,181,313 -11.02% May 2,936,868 485,323 2,616,433 -10.91% June 3,368,111 431,243 3,004,165 -10.81% July 3,844,019 475,908 3,441,481 -10.47% August 4,895,662 1,051,643 4,390,758 -10.31% September 5,380,996 485,335 4,827,751 -10.28% October 5,812,621 431,625 5,215,008 -10.28% November 6,298,011 485,390 5,652,608 -10.25% December 6,714,303 416,292 Storm Water Sales 0 I 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. O a 4) !C C M C M 21 L C O 2 CI) N O N L d E O z g Packet Pg. 11 I 2.1.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 3,333,389 -4.33% May 4,445,696 961,351 4,249,590 -4.41% June 5,235,623 789,927 5,021,702 -4.09% July 6,198,081 962,458 5,967,694 -3.72% August 6,992,099 794,018 6,740,009 -3.61% September 7,987,044 994,945 7,689,885 -3.72% October 8,790,485 803,441 8,467,595 -3.67% November 9,763,192 972,707 9,396,183 -3.76% December 10,551,011 787,819 Unmeter Sewer Sales I L,000,UUU 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 9907 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 Q d R C f4 C LL t r C O 2 M N O N L d E O Z 9 Packet Pg. 12 I 2.1.a I City ofEdmonds, WA Monthly Expenditure Report -General Fund 2023 General Fund Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance January $ 6,137,826 $ 6,137,826 $ 4,868,760 -20.68% February 11,064,571 4,926,745 10,063,682 -9.05% March 15,921,618 4,857,047 14,793,075 -7.09% April 20,583,943 4,662,325 18,985,494 -7.77% May 25,612,342 5,028,399 23,497,459 -8.26% June 31,411,865 5,799,523 28,704,022 -8.62% July 36,363,006 4,951,141 33,359,621 -8.26% August 41,130,318 4,767,313 38,672,822 -5.97% September 46,432,507 5,302,189 43,450,297 -6.42% October 51,692,989 5,260,482 47,414,711 -8.28% November 57,566,174 5,873,185 54,482,142 -5.36% December 63,970,754 6,404,580 City of Edmonds, WA Monthly Expenditure Report -Non -Departmental 2023 Non -Departmental Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 2,703,415 $ 2,703,415 $ 1,642,894 -39.23% February 4,120,779 1,417,364 3,380,586 -17.96% March 5,420,914 1,300,136 4,986,307 -8.02% April 6,544,202 1,123,288 6,091,521 -6.92% May 7,951,492 1,407,290 7,245,913 -8.87% June 10,036,224 2,084,733 9,392,113 -6.42% July 11,274,698 1,238,474 10,555,304 -6.38% August 12,335,881 1,061,182 12,600,704 2.15% September 13,768,928 1,433,047 13,727,753 -0.30% October 15,093,355 1,324,427 13,998,873 -7.25% November 16,728,866 1,635,512 17,150,215 2.52% December 18,488,589 1,759,723 Non -Departmental 20,000,000 18,000,000 16,000,000 14,000,000 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 le- 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -0-- Current Year Budget Prior Year *The monthly budget forecast columns are based on a five-year average. 10 Packet Pg. 13 I 2.1.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,587 $ 31,587 $ 33,649 6.53% February 65,597 34,010 71,252 8.62% March 104,151 38,554 108,460 4.14% April 141,020 36,870 142,437 1.00% May 188,108 47,087 180,396 -4.10% June 237,876 49,768 208,152 -12.50% July 275,165 37,290 249,010 -9.51% August 325,994 50,829 283,971 -12.89% September 365,198 39,203 319,066 -12.63% October 398,695 33,497 348,675 -12.55% November 440,782 42,088 390,805 -11.34% December 486,719 45,937 City of Edmonds, WA Monthly Expenditure Report -Office of Mayor 2023 Office of Mayor Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 41,345 $ 41,345 $ 32,343 -21.77% February 84,589 43,243 63,133 -25.37% March 126,357 41,768 101,671 -19.54% April 168,957 42,600 133,210 -21.16% May 210,634 41,677 164,114 -22.09% June 251,812 41,178 195,229 -22.47% July 293,809 41,997 229,429 -21.91% August 335,446 41,636 259,788 -22.55% September 377,299 41,854 290,606 -22.98% October 418,301 41,002 321,038 -23.25% November 461,679 43,378 354,414 -23.23% December 505,239 43,560 *The monthly budget forecast columns are based on a five-year average. O Q !C C M C_ 11 21 L C O 2 t'7 N O N L d E O z 11 Packet Pg. 14 1 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -Human Resources 2023 Human Resources Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 115,695 $ 115,695 $ 93,116 -19.52% February 219,840 104,145 164,590 -25.13% March 315,272 95,432 230,737 -26.81% April 415,812 100,540 296,057 -28.80% May 516,054 100,242 367,942 -28.70% June 651,834 135,780 455,291 -30.15% July 741,246 89,412 531,164 -28.34% August 839,112 97,865 605,627 -27.83% September 944,153 105,041 694,844 -26.41% October 1,042,607 98,454 774,485 -25.72% November 1,156,556 113,949 876,005 -24.26% December 1,297,746 141,190 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 Municipal Court Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 135,694 $ 135,694 $ 114,975 -15.27% February 273,214 137,520 231,321 -15.33% March 414,829 141,615 352,625 -15.00% April 558,136 143,307 476,351 -14.65% May 711,840 153,704 611,186 -14.14% June 853,118 141,278 726,808 -14.81% July 997,788 144,670 855,668 -14.24% August 1,159,264 161,476 980,820 -15.39% September 1,307,192 147,929 1,097,393 -16.05% October 1,460,910 153,718 1,213,326 -16.95% November 1,645,269 184,359 1,343,740 -18.33% December 1,827,709 182,440 *The monthly budget forecast columns are based on a five-year average. 12 Packet Pg. 15 I 2.1.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 $ 82,768 $ 82,768 $ 84,200 1.73% February 173,748 90,980 172,586 -0.67% March 267,297 93,549 263,059 -1.59% April 356,785 89,487 362,832 1.70% May 449,350 92,565 470,437 4.69% June 543,530 94,180 599,614 10.32% July 642,047 98,517 718,488 11.91% August 759,375 117,328 872,904 14.95% September 869,058 109,683 962,363 10.74% October 983,298 114,241 1,079,290 9.76% November 1,129,896 146,598 1,185,309 4.90% December 1,312,555 182,659 *The monthly budget forecast columns are based on a five-year average. 13 Packet Pg. 16 1 I 2.1.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 $ 240,643 $ 240,643 $ 355,645 47.79% February 398,793 158,150 530,347 32.99% March 615,290 216,497 683,467 11.08% April 701,637 86,346 798,011 13.74% May 824,702 123,066 888,529 7.74% June 965,060 140,358 982,174 1.77% July 1,069,578 104,518 1,136,037 6.21% August 1,225,467 155,890 1,265,855 3.30% September 1,381,721 156,254 1,423,867 3.05% October 1,557,117 175,396 1,518,443 -2.48% November 1,672,249 115,132 1,623,461 -2.92% December 1,943,624 271,375 Administrative Services Fund 512 - Technology Rental Fund 2,000,000 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 Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 265,902 $ 265,902 $ 253,437 -4.69% February 452,065 186,163 571,249 26.36% March 638,942 186,877 774,413 21.20% April 830,237 191,295 964,313 16.15% May 1,020,418 190,181 1,156,484 13.33% June 1,279,620 259,202 1,327,293 3.73% July 1,494,954 215,334 1,531,898 2.47% August 1,686,406 191,452 1,715,648 1.73% September 1,878,906 192,501 1,936,486 3.06% October 2,079,936 201,029 2,150,254 3.38% November 2,305,663 225,728 2,347,890 1.83% December 2,502,670 197,007 *The monthly budget forecast columns are based on a five-year average. 14 Packet Pg. 17 I 2.1.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 276,332 -28.64% May 484,075 96,815 347,909 -28.13% June 580,890 96,815 427,830 -26.35% July 677,705 96,815 534,282 -21.16% August 774,520 96,815 559,282 -27.79% September 871,335 96,815 704,483 -19.15% October 968,150 96,815 788,660 -18.54% November 1,064,965 96,815 888,974 -16.53% 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 -Current Year Budget - Prior Year City of Edmonds, WA Monthly Expenditure Report -Police 2023 Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 1,151,199 $ 1,151,199 $ 1,041,369 -9.54% February 2,301,161 1,149,962 2,119,852 -7.88% March 3,503,278 1,202,117 3,173,554 -9.41% April 4,662,822 1,159,544 4,326,784 -7.21% May 5,864,448 1,201,626 5,521,298 -5.85% June 7,133,272 1,268,824 6,661,514 -6.61% July 8,339,111 1,205,839 7,971,401 -4.41% August 9,474,966 1,135,855 9,201,003 -2.89% September 10,670,868 1,195,902 10,558,632 -1.05% October 11,909,831 1,238,963 11,878,556 -0.26% November 13,362,651 1,452,820 13,445,385 0.62% December 14,826,373 1,463,722 *The monthly budget forecast columns are based on a five-year average. F O a O !C C M C M L C O 2 CI) N O tV L d E O z 15 Packet Pg. 18 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -Development Services 2023 Planning & Development Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 396,763 $ 396,763 $ 286,492 -27.79% February 814,630 417,867 595,086 -26.95% March 1,215,923 401,293 913,919 -24.84% April 1,639,139 423,216 1,265,403 -22.80% May 2,055,194 416,055 1,622,646 -21.05% June 2,468,896 413,702 1,934,311 -21.65% July 2,920,497 451,601 2,263,472 -22.50% August 3,344,297 423,800 2,566,672 -23.25% September 3,786,123 441,826 2,913,241 -23.05% October 4,225,508 439,384 3,191,421 -24.47% November 4,698,931 473,423 3,515,544 -25.18% December 5,246,507 547,576 Parks & Recreation Planning & Development 5,500,000 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 Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 457,954 $ 457,954 $ 589,720 28.77% February 958,756 500,802 958,125 -0.07% March 1,459,648 500,892 1,386,849 -4.99% April 1,961,358 501,710 1,788,118 -8.83% May 2,474,286 512,928 2,229,794 -9.88% June 3,018,678 544,393 2,623,359 -13.10% July 3,614,241 595,562 3,206,401 -11.28% August 4,231,093 616,853 3,766,096 -10.99% September 4,895,252 664,159 4,346,603 -11.21% October 5,440,831 545,579 4,977,108 -8.52% November 5,997,773 556,942 5,476,396 -8.69% December 6,575,662 577,889 *The monthly budget forecast columns are based on a five-year average. O Q O !C C M C LL L C O 2 M N O N L d E O z 16 Packet Pg. 19 I 2.1.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 116,404 -72.61% May 531,250 106,250 35,246 -93.37% June 637,500 106,250 102,751 -83.88% July 743,750 106,250 128,411 -82.73% August 850,000 106,250 128,411 -84.89% September 956,250 106,250 229,858 -75.96% October 1,062,500 106,250 406,199 -61.77% November 1,168,750 106,250 625,190 -46.51% December 1,275,000 106,250 City of Edmonds, WA Monthly Expenditure Report -Facilities Maintenance 2023 Facilities Maintenance Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 279,527 $ 279,527 $ 335,018 19.85% February 638,903 359,376 935,298 46.39% March 1,011,874 372,971 1,264,752 24.99% April 1,367,475 355,601 1,451,697 6.16% May 1,690,876 323,401 1,803,967 6.69% June 1,957,047 266,171 2,002,414 2.32% July 2,280,286 323,239 2,209,753 -3.09% August 2,699,956 419,669 2,409,557 -10.76% September 3,185,324 485,369 2,642,907 -17.03% October 3,725,458 540,133 3,067,071 -17.67% November 4,170,818 445,360 3,504,989 -15.96% December 4,877,452 706,634 Facilities Maintenance 11500,000 1,000,000 - 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -CurrentYeaz Budget -dPriorYear *The monthly budget forecast columns are based on a five-year average. 17 Packet Pg. 20 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -Engineering 2023 Engineering Cumulative Monthly YTD Variance Budget Forecast Budget Forecast ActuaIs % January $ February March April May June July August September October November December 283,132 $ 567,413 856,666 1,149,630 1,470,075 1,765,968 2,074,354 2,376,166 2,668,549 2,965,801 3,290,206 3,615,509 283,132 $ 261,418 284,281 531,670 289,253 807,168 292,964 1,076,687 320,445 1,353,969 295,893 1,652,623 308,386 1,918,939 301,813 2,184,156 292,382 2,479,814 297,252 2,749,498 324,405 3,028,489 325,303 -7.67% -6.30 % -5.78 % -6.34% -7.90% -6.42 % -7.49 % -8.08% -7.07 % -7.29 % -7.95% Engine a ring 000 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY RUN JUL AUG SEP OCT NOV DEC -Current Yew Budget . Prior Year *The monthly budget forecast columns are based on a five-year average. O a 4) !4 U C M C LL L a+ C O 2 M N O N L d E O Z 18 Packet Pg. 21 I 2.1.a I Page 1 of 1 CITY OF EDMONDS REVENUES BY FUND - SUMMARY Fund 2023 Amended 11/30/2022 11/30/2023 Amount No. Title Budget Revenues Revenues Remaining %Received 001 GENERAL FUND $ 52,558,830 $ 42,309,045 $ 46,406,295 $ 6,152,535 880 009 LEOFF-MEDICAL INS. RESERVE 225,000 225,000 225,000 - 1000 012 CONTINGENCY RESERVE FUND 447,522 - 446,522 1,000 1000 014 HISTORIC PRESERVATION GIFT FUND - - - - 00 016 BUILDING MAINTENANCE FUND 17,480 48,348 90,369 (72,889) 5170 017 MARSH RESTORATION & PRESERVATION FUND 1,150 3,829 (3,829) 0Q 0 O 018 EDMONDS HOMELESSNESS RESPONSE FUND - 200,000 - - 0% 019 EDMONDS OPIOID RESPONSE FUND - - 74,119 (74,119) 00 v 104 DRUG ENFORCEMENT FUND 167,650 1,403 1,956 165,694 10 _ R C 111 STREET FUND 2,015,410 1,681,763 1,683,253 332,157 840 jL 112 COMBINED STREET CONST/IMPROVE 12,366,800 3,137,190 8,161,481 4,205,319 660 117 MUNICIPAL ARTS ACQUIS. FUND 99,220 134,622 79,357 19,863 800 C O 118 MEMORIAL STREET TREE - - - - 0% 120 HOTEL/MOTEL TAX REVENUE FUND 84,400 110,570 113,529 (29,129) 1350 cq 121 EMPLOYEE PARKING PERMIT FUND 38,960 14,375 15,545 23,415 400 L 122 YOUTH SCHOLARSHIP FUND 1,660 1,336 1,550 110 930 y 123 TOURISM PROMOTIONAL FUND/ARTS 30,440 38,335 40,110 (9,670) 1320 125 REAL ESTATE EXCISE TAX 2 2,320,090 1,721,743 1,354,376 965,714 580 Z 126 REAL ESTATE EXCISE TAX 1 2,302,980 1,716,772 1,400,959 902,021 610 127 GIFT S CATALOG FUND 232,490 3,004,748 210,312 22,178 900 0 CL 130 CEMETERY MAINTENANCE/IMPROVEMT 150,960 219,963 183,143 (32,183) 1210 136 PARKS TRUST FUND 5,460 3,197 (7,497) 12,957 -1370 137 CEMETERY MAINTENANCE TRUST FD 51,500 40,731 51,457 43 1000 C 10 138 SISTER CITY COMMISSION 10,430 5,317 5,606 4,824 540 C LL 140 BUSINESS IMPROVEMENT DISTRICT 88,645 91,361 77,326 11,319 870 >, 141 AFFORDABLE AND SUPPORTIVE HOUSING FUND 65,000 66,666 65,568 (568) 1010 142 EDMONDS RESCUE PLAN FUND 1,879,000 640,170 1,340,182 538,818 710 143 TREE FUND 215,100 216,044 6,542 208,558 30 M 231 2012 LT GO DEBT SERVICE FUND 309,800 181,047 166,915 142,885 540 N 332 PARKS CAPITAL CONSTRUCTION FUND 2,713,902 2,038,843 2,091,369 622,533 L 770 s 411 COMBINED UTILITY OPERATION - 146,055 132,340 (132,340) 0% E d 421 WATER UTILITY FUND 11,950,114 10,049,427 10,593,978 1,356,136 890/ G 422 STORM UTILITY FUND 9,095,452 6,134,906 6,994,145 2,101,307 770/ Z 423 SEWER/WWTP UTILITY FUND 16,895,408 16,385,648 16,104,599 790,809 950 d 424 BOND RESERVE FUND 1,991,860 597,054 591,202 1,400,658 30% 511 EQUIPMENT RENTAL FUND 4,253,740 1,698,215 2,569,384 1,684,356 600 rr 512 TECHNOLOGY RENTAL FUND 1,634,131 1,190,073 1,468,463 165,668 r.+ 90% Q $ 124,219,434 $ 94,051,119 $ 102,743,283 $ 21,476,151 830% 19 Packet Pg. 22 I 2.1.a I Page 1 of 1 CITY OF EDMONDS EXPENDITURES BY FUND - SUMMARY Fund 2023 Amended 11/30/2022 11/30/2023 Amount No. Title Budget Expenditures Expenditures Remaining %Spent 001 GENERAL FUND $ 63,970,754 $ 44,001,969 $ 54,482,142 $ 9,488,612 850 009 LEOFF-MEDICAL INS. RESERVE 367,140 236,296 309,063 58,077 840/c Ol l RISK MANANGEMENT RESERVE FUND 25,000 25,000 - 1000/c 014 HISTORIC PRESERVATION GIFT FUND 5,900 - 2,757 3,143 470/c 016 BUILDING MAINTENANCE FUND 1,275,000 17,074 625,190 649,810 490 017 MARSH RESTORATION & PRESERVATION FUND - - - 00 Q O 018 EDMONDS HOMELESSNESS RESPONSE FUND - - - 0% 019 EDMONDS OPIOID RESPONSE FUND - - - - 00/c v 104 DRUG ENFORCEMENT FUND 45,800 6,291 32,485 13,315 710/, III STREET FUND 2,746,179 1,950,754 2,409,509 336,670 C 880/c LL 112 COMBINED STREET CONST/IMPROVE 11,273,695 3,562,331 7,594,958 3,678,737 670/, 2' t 117 MUNICIPAL ARTS ACQUIS. FUND 207,380 102,099 103,254 104,126 5001( C O 118 MEMORIAL STREET TREE - - - - 00/, 120 HOTEL/MOTEL TAX REVENUE FUND 95,400 68,765 24,973 70,427 260/c N O 121 EMPLOYEE PARKINGPERMIT FUND 26,880 740 825 26,055 30/ N L 122 YOUTH SCHOLARSHIP FUND 3,000 322 (75) 3,075 -30/c 123 TOURISM PROMOTIONAL FUND/ARTS 28,500 10,733 17,650 10,850 620/c O 125 REAL ESTATE EXCISE TAX 2 4,315,418 2,104,200 2,346,396 1,969,022 540/, Z 126 REAL ESTATE EXCISE TAX 1 2,227,383 695,373 827,803 1,399,580 370/c 127 GIFT S CATALOG FUND 551,598 109,795 298,422 253,176 540/c Q 130 CEMETERY MAINTENANCE/IMPROVEMT 291,530 191,337 251,137 40,393 860/c 136 PARKS TRUST FUND 216,062 3,610 161,439 54,623 750/, !4 137 CEMETERY MAINTENANCE TRUST FUND 50,000 - - 50,000 00/, C 10 138 SISTER CITY COMMISSION 11,900 70 7,923 3,977 670/, LL 140 BUSINESS IMPROVEMENT DISTRICT 88,575 65,611 66,208 22,367 750/, >, 142 EDMONDS RESCUE PLAN FUND 1,879,000 689,835 1,329,175 549,825 710/c 143 TREE FUND 239,800 - - 239,800 00/c 231 2012 LT GO DEBT SERVICE FUND 309,800 41,489 37,745 272,055 120/c N 332 PARKS CAPITAL CONSTRUCTION FUND 2,255,647 4,970,001 1,897,313 358,334 84% N 421 WATER UTILITY FUND 11,949,308 6,292,149 8,733,509 3,215,799 L 730/c s 422 STORM UTILITY FUND 8,525,900 5,929,183 4,687,429 3,838,471 55% d 423 SEWER/WWTP UTILITY FUND 18,972,999 15,015,884 14,245,513 4,727,486 750/c > O Z 424 BOND RESERVE FUND 1,989,820 589,342 574,892 1,414,928 290/c 511 EQUIPMENT RENTAL FUND 4,966,825 1,289,048 2,757,544 2,209,281 560/c y t 512 TECHNOLOGY RENTAL FUND 1,943,624 1,319,931 1,623,461 320,163 840/c t� $ 140,855,817 $ 89,264,231 $ 105,473,640 $ 35,382,177 750% r 20 Packet Pg. 23 2.1.a Page 1 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2023 Amended 11/30/2022 11/30/2023 Amount Title Budget Revenues Revenues Remaining %Received TAXES: 1 REAL PERSONAL / PROPERTY TAX 2 EMS PROPERTY TAX 3 VOTED PROPERTY TAX 4 LOCAL RETAIL SALES/USE TAX t 5 NATURAL GAS USE TAX 6 1/10 SALES TAX LOCAL CRIM JUST 7 ELECTRIC UTILITY TAX 8 GASUTILITYTAX 9 SOLID WASTE UTILITY TAX 10 WATERUTILITY TAX 11 SEWERUTILITYTAX 12 STORMWATER UTILITY TAX 13 T.V. CABLE UTILITY TAX 14 TELEPHONE UTILITY TAX 15 PULLTABS TAX 16 AMUSEMENT GAMES 17 LEASEHOLD EXCISE TAX LICENSES AND PERMITS: 18 FIRE PERMITS -SPECIAL USE 19 POLICE -FINGERPRINTING 20 VENDINGMACHINE/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 BUILDINGPERMITS 29 FIRE PERMIT 30 ENGINEERING PERMIT 31 ANIMAL LICENSES 32 STREET AND CURB PERMIT 33 STREET AND CURB PERMIT W/LEASEHOLD TAX 34 OT R NON -BUS LIC/PERMIT S 35 SPECIAL EVENT REVIEW INTERGOVERNMENTAL: 36 FEDERAL GRANTS - BUDGET ONLY 37 DOJ 15-0404-0-1-754 - BULLET PROOF VEST 38 WA SASSOC OF SHERIFFS TRAFFIC GRANT 39 HIGH VISIBILITY ENFORCEMENT 40 CORONAVIRUS RELIEF FUND 41 HOUSING TO INFRASTRUCTURE PROGRAM (CHIP) 42 STATE GRANTS- BUDGET ONLY 43 STATE GRANT FROM OTHER JUDICIAL AGENCIES 44 WA STATE TRAFFIC COMM GRANT 45 SCHOOL ZONE 46 GMA PERIODIC UPDATE GRANT - FY 2023 47 WASHINGTON SPATE ARTS COMMISSION 48 PUD PRIVILEDGE TAX 49 TRIAL COURT IMPROVEMENT 50 CJ - POPULATION 51 CRIMINAL JUSTICE -SPECIAL PROGRAMS 52 MARIJUANA EXCISE TAX DISTRIBUTION 53 DUI - CITIES 54 FIRE INS PREMIUM TAX 55 LIQUOR EXCISE TAX 56 LIQUOR BOARD PROFITS 57 MISCELLANEOUS INTERLOCAL REVENUE 58 FIRST RESPONDERS FLEX FUND 59 DISCOVERY PROGRAMS TECHNOLOGY ACQ. $ 11,327,000 $ 10,462,458 $ 10,603,949 $ 723,051 94% 4,578,000 4,168,355 4,253,242 324,758 93% 500 56 4 496 1% 11,900,000 7,600 1,150,000 1,900,000 845,000 384,000 1,000,234 942,960 621,458 850,000 773,000 80,200 350 326,000 36,686,302 250 700 94,500 702,700 41,000 100,600 450,000 250,000 80,000 30,000 750,600 24,000 75,000 20,000 2,619,355 166,309 9,000 11,100 1,494,875 1,361,011 244,645 161,004 34,000 210,500 16,740 13,070 50,600 125,000 4,500 325,000 343,200 1,000 550 10,301,093 18,166 947,556 1,574,360 673,336 342,543 871,598 808,986 544,081 757,220 420,015 75,083 312,920 32,277,827 400 265 79,431 696,556 32,370 45,854 434,655 216,289 92,970 30,173 726,861 13,475 85,712 75 19,154 2,474,239 10,660,200 12,000 961,970 1,632,506 788,538 371,095 926,022 939,080 565,263 750,088 395,099 57,733 41 319,590 33,236,421 50 755 83,666 691,132 29,521 47,151 486,551 217,207 99,505 16,874 261,050 7,946 92,070 18,080 21,170 6,798 17,745 726 2,097,997 5,237 - 992 31,313 5,022 15,664 71,185 116,544 - 1,004,985 307 2,000 214,277 16,163 14,744 52,278 80,089 4,913 56,744 303,313 249,557 13,780 559 63 757 1,337 62,500 3,000 219,274 16,015 15,545 54,864 80,348 2,974 75,698 301,353 246,463 500 658 1,239,800 (4,400) 188,030 267,494 56,462 12,905 74,212 3,880 56,195 99,912 377,901 22,467 309 6,410 3,449,881 200 (55) 10,834 11,568 11,479 53,449 (36,551) 32,793 (19,505) 13,126 489,550 (7,946) (92,070) 5,920 53,830 (6,798) 2,255 521,353 166,309 9,000 (31,313) (4,564) 1,378,331 356,026 244,645 161,004 (1,337) (62,500) 31,000 (8,774) 725 (2,475) (4,264) 44,652 1,526 (75,698) 23,647 96,737 (500) 342 550 60 AWC -SEEK FUND - - - 4,572,104 1,154,915 2,249,034 2,323,070 2022 Local Retail Sales/Use Tax revenues are $359,107 higher than 2021 revenues Please also see pagespages 5 & 6. 21 90% 158% 84% 86% 93% C 97% Q 93%% 100 91 % . % v 88_ 51% 72% IL 12% �+ 98% 91% C 20% ch 108% O 89% N 98% m 72% 47% y 108% >p 87% Z 124% 56% p 35% C 0% w 0% R 75% 'v 28% 0% 89% LL 0% Z. 80% r 0% 0% 0% 141 % 80/ 74% 0% 0% 0% 0% 0% 9% 104% 96% 119% 108% 64% 66% 0% 93% 720/ 0% 66% 0% 0% 49% Packet Pg. 24 2.1.a Page 2 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2023 Amended 11/30/2022 11/30/2023 Amount Title Budget Revenues Revenues Remaining %Received CHARGES FOR GOODS AND SERVICES: 1 RECORD/LEGAL INSTRUMENTS $ 3,000 $ 5,418 $ 2,214 $ 787 740% 2 ATM SURCHARGE FEES 600 277 259 341 430% 3 CREDIT CARD FEES 6,000 441 120 5,880 20/( 4 COURT RECORD SERVICES 150 1 - 150 00/( 5 D/M COURT REC SER 300 - - 300 00/( 6 WARRANT PREPARATION FEE 4,000 98 - 4,000 00/( 7 IT TIME PAY FEE 1,000 77 76 924 80% 8 MUNIC.-DIST. COURT CURREXPEN 50 168 306 (256) 6110% 9 CLERKS TIME FOR SALE OF PARKINGPERMITS 25,000 - - 25,000 00/( Q 10 PHOTOCOPIES 100 78 47 53 470% y 11 POLICE DISCLOSURE REQUESTS 1,000 - - 1,000 00/( 12 ENGINEERING FEES AND CHARGES 190,000 213,038 34,921 155,079 180/( 13 ELECTION CANDIDATE FILINGFEES 1,400 2,885 - 1,400 00/( _ 14 CUSTODIAL SERVICES(SNO-ISLE) 100,000 79,843 50,396 49,604 500% R 15 PASSPORTS AND NATURALIZATION FEES 5,000 4,133 43,356 (38,356) 867% E 16 POLICE SERVICES SPECIAL EVENTS 30,000 17,188 14,793 15,207 490% LL 17 CAMPUS SAFETY-EDM. SCH. DIST. 14,000 13,938 4,929 9,071 350/( t 18 WOODWAY-LAW PROTECTION 210,970 184,913 227,425 (16,455) 1080/( 19 C.TTC TAC REIMBURSEMENT - - 58,320 (58,320) 00/( O 20 MISCELLANEOUS POLICE SERVICES - 25 20 (20) 00/( 2 21 FIRE DISTRICT #1 STATION BILLINGS 67,000 62,047 71,339 (4,339) 1060/( M 22 LEGAL SERVICES 1,050 702 - 1,050 00/( N 23 ADULT PROBATION SERVICE CHARGE 38,000 17,991 8,712 29,288 230% L 24 BOOKINGFEES 3,000 539 278 2,722 90/( 25 FIRE CONSTRUCTION INSPECTION FEES 10,000 30,912 26,098 (16,098) 2610/( E 26 EMERGENCY SERVICE FEES 3,500 1,093 710 2,790 200/( > 27 EMS TRANSPORT USER FEE 1,077,500 764,912 958,737 118,763 890/( O 28 FLEX FUEL PAYMENTS FROM STATIONS 5,000 4,227 5,619 (619) 112% ? 29 ANIMAL CONTROL SHELTER - 100 400 (400) 00/( 30 ZONING/SUBDIVISION FEE 65,600 94,338 16,819 48,781 260/( O 31 BUILDING PLAN REVIEW AND INSPECTION 425,000 422,436 798,273 (373,273) 1880/( y 32 FIRE PLAN REVIEW 4,000 17,267 19,978 (15,978) 4990/( 33 PLANNINGREVIEW AND INSPECTION 500 110 78,823 (78,323) 157650/( 34 S.E.P.A. REVIEW 3,000 6,195 3,852 (852) 1280/( .� 35 ENGINEERING PLAN REVIEW AND INSPECTION - - 137,218 (137,218) 00/( 36 CRITICAL AREA STUDY 14,000 14,775 15,648 (1,648) 1120/( 37 GYM AND WEIGHTROOM FEES 13,000 3,064 7,602 5,398 580/( LL 38 PROGRAM FEES 990,959 582,292 769,843 221,116 780/( 39 HOLIDAY MARKET REGISTRATION FEES 5,000 15,325 15,665 (10,665) 3130% 40 UPTOWN EVENING MARKET FEES 5,000 4,690 - 5,000 00/( O 41 WINTER MARKET FEES 5,000 7,430 9,005 (4,005) 1800/( 42 EDMONDS COMMUNITY FAIR FEES - - 560 (560) 00/( N 43 BIRD FEST REGISTRATION FEES 1,000 855 - 1,000 00/( o 44 INTERFUND REIMBURSEMENT -CONTRACT SVCS 3,427,765 3,033,572 3,416,150 11,615 1000/( N 6,757,444 5,607,394 6,798,510 (41,066) 101 % 22 Packet Pg. 25 2.1.a Page 3 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2023 Amended 11/30/2022 11/30/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 TRAFFIC CAMERA INFRACTIONS 5 CRT COST FEE CODE LEG ASSESSMENT (LGA) 6 CURRENT TRAFFIC INFRACTIONS 7 NON -TRAFFIC INFRACTION PENALTIES 8 OTHER INFRACTIONS'04 9 PARKING INFRACTION PENALTIES 10 PARK/INDDISZONE 11 DWI PENALTIES 12 DUI - DP ACCT 13 CRIM CNV FEE DUI 14 DUI - DP FEE 15 CRIMINAL TRAFFIC MISDEMEANOR 8/03 16 CRIMINAL CONVICTION FEE CT 17 CRIM CONV FEE CT 18 OTHER NON-TRAF MISDEMEANOR PEN 19 OTHER NON TRAFFIC MISD. 8/03 20 COURT DV PENALTY ASSESSMENT 21 CRIMINAL CONVICTION FEE CN 22 CRIM CONV FEE CN 23 PUBLIC DEFENSE RECOUPMENT 24 BANK CHARGE FOR CONY. DEFENDANT 25 COURT COST RECOUPMENT 26 BUS. LICENSE PERMIT PENALTY 27 MISC FINES AND PENALTIES MISCELLANEOUS: 28 INVESTMENT INTEREST 29 INTEREST ON COUNTY TAXES 30 INTEREST - COURT COLLECTIONS 31 LOAN INTEREST 32 SPACE/FACILITIESRENTALS 33 BRACKET ROOM RENTAL 34 LEASESLONGTERM 35 DONATION/CONTRIBUTION 36 PARKSDONATIONS 37 BIRD FEST CONTRIBUTIONS 38 POLICE CONTRIBUTIONS FROM PRIV SOURCES 39 SALE OF JUNK/SALVAGE 40 SALES OF UNCLAIM PROPERTY 41 CONFISCATED AND FORFEITED PROPERTY 42 OTHERJUDGEMENT/SETTLEMENT 43 POLICE JUDGMENTS✓RESTITUTION 44 CASHIER'S OVERAGES/SHORTAGES 45 OTHER MISC REVENUES 46 SMALL OVERPAYMENT 47 NSF FEES - PARKS & REC 48 NSF FEES - MUNICIPAL COURT 49 NSF FEES - DEVEL SERV DEPT 50 L&I STAY AT WORK PROGRAM 51 US BANK REBATE TRANSFER IN: 52 INSURANCE RECOVERIES 53 INTERFUND TRANSFER FROM FUND 011 53 INTERFUND TRANSFER FROM FUND 136 52 TRANSFER FROM FUND 127 TO TAL GENERAL FUND REVENUE $ 2,000 $ 1,444 $ 1,647 $ 353 820/( 130,000 78,845 59,239 70,761 460% 18,000 3,413 1,287 16,713 70/( 50,000 - - 50,000 00/( 10,000 5,582 1,578 8,423 160/( - - 58,407 (58,407) 00% 1,000 - 5,386 (4,386) 5390/( 1,500 951 1,840 (340) 1230/( 125,000 39,981 12,080 112,920 100% 2,000 795 742 1,258 370% 7,000 3,639 2,843 4,157 410/( 300 142 1 299 00/( 100 26 - 100 00/( 1,500 1,576 1,156 344 770/( 25,000 9,335 5,903 19,097 240/( 2,000 1,519 943 1,057 470/( 700 103 12 688 20% 100 - 100 0 1000/( 12,000 14,712 241 11,759 20/( 800 34 100 700 130/( 1,000 330 91 909 90% 200 - - 200 00/( 6,000 3,063 1,124 4,876 190/( 4,000 4,261 4,423 (423) 1110/( 1,000 568 1,203 (203) 1200% 1,000 188 - 1,000 00/( 150 - - 150 00/( 402,350 170,506 160,345 242,005 40% 321,240 217,689 159,604 161,636 5001( 10,960 17,540 65,282 (54,322) 5960/( 12,180 4,077 2,108 10,072 170% 12,080 - - 12,080 00/( 175,000 136,267 174,791 209 1000/( 2,100 - - 2,100 00/( 210,000 189,029 207,443 2,557 990/( 1,500 1,276 1,128 372 750/( 3,500 5,050 16,500 (13,000) 4710/( 1,500 2,070 2,057 (557) 1370/( 5,000 249 100 4,900 20/( 300 398 7,551 (7,251) 25170/( 3,800 4,269 3,366 434 890/( 2,000 - - 2,000 00/( 146,000 - 2,542 143,458 20/( 200 315 98 102 490/( - 734 28 (28) 00/( 5,000 3,514 289,720 (284,720) 57940/( 100 49 1 99 10/( 100 30 30 70 300/( 150 180 240 (90) 1600/( - 60 34 (34) 00/( - 6,527 8,702 (8,702) 00/( 8,500 8,541 10,597 (2,097) 1250/( 921,210 597,864 951,921 (30,711) 1030/( 500,000 815,000 (315,000) 1630/( 25,000 25,000 - 1000/( 75,070 - 72,066 3,004 960/( - 26,300 - - 00% 600,070 26,300 912,066 (311,996) 1520% $ 52,558,830 $ 42,309,045 $ 46,406,295 $ 6,152,535 880% 23 Packet Pg. 26 I 2.1.a I Page 1 of 6 C PTY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Amended 11/30/2022 11/30/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent GENERAL FUND EXPENDITURES (001) 1 SALARIES AND WAGES $ 23,174,368 $ 16,778,161 $ 19,808,123 $ 3,366,245 850/( 2 OVERTIME 649,080 1,001,672 949,351 (300,271) 1460/( 3 HOLIDAY BUY BACK 294,001 233,490 183,714 110,287 620/( 4 BENEFITS 7,959,238 6,080,117 7,053,388 905,850 890/( 5 UNIFORMS 130,851 96,464 137,174 (6,323) 10501( 6 PENSION AND DISABILITY PAYMENTS 165,023 78,705 67,121 97,902 410/( 7 SUPPLIES 770,473 425,564 523,343 247,130 680/( 8 SMALL EQUIPMENT 307,791 310,043 256,719 51,072 830/( 9 PROFESSIONAL SERVICES 21,173,217 13,681,701 17,855,520 3,317,697 840/( 10 COMMUNICATIONS 241,295 147,105 212,791 28,504 880/( 11 TRAVEL 86,242 49,772 102,813 (16,571) 1190/( 12 EXCISE TAXES 16,500 27,680 26,024 (9,524) 1580/( 13 RENTALILEASE 2,869,548 1,840,076 2,563,182 306,366 890/( 14INSURANCE 625,650 503,160 625,650 (0) 1000/( 15 UTILITIES 663,800 558,606 645,431 18,369 970/( 16 REPAIRS & MAINTENANCE 673,900 491,988 670,281 3,619 990/( 17 MISCELLANEOUS 673,640 475,483 706,618 (32,978) 10501( 18 INTERGOVERNMENTAL PAYMENTS 50,000 50,000 50,000 - 1000/( 19 INTERFUND SUBSIDIES 1,341,982 885,000 1,101,522 240,460 820/( 20 BUILDINGS 500,000 81,116 325,124 174,876 650/( 21 MACHINERY/EQUIPMENT 430,000 133,561 374,169 55,831 870/( 22 CONST RUCT IONS PROJECTS 800,565 - 178,351 622,214 220/( 23 PRINCIPAL PAYMENT LEASES 50,000 - 50,000 00/( 24 GENERAL OBLIGATION BOND PRINCIPAL 191,620 - - 191,620 00/( 25 INTEREST ON LONG-TERM EXTERNAL DEBT 131,470 72,294 65,733 65,737 500% 26 OTHER INTEREST & DEBT SERVICE COSTS 500 212 - 500 00% 33,970,754 44,001,969 54,482,142 9,488,612 850/( LEOFF-MEDICAL INS. RESERVE(009) 27 BENEFITS $ 206,650 $ 133,809 $ 139,961 $ 66,689 680/( 28 PENSION AND DISABILITY PAYMENTS 152,990 88,298 150,102 2,888 980% 29 PROFESSIONAL SERVICES 7,000 13,704 19,000 (12,000) 2710/( 30 MISCELLANEOUS 500 485 - 500 00/( 367,140 236,296 309,063 58,077 84% RISK MANAGEMENT RESERVE FUND (011) 31 INTERFUND SUBSIDIES $ 25,000 $ - $ 25,000 $ - 1000/( 25,000 25,000 - 1000/( HISTORIC PRESERVATION GIFTFUND (014) 32 SUPPLIES $ 100 $ $ - $ 100 00/( 33 PROFESSIONAL SERVICES 200 - 200 00/( 34 MISCELLANEOUS 5,600 2,757 2,843 490% 5,900 2,757 3,143 470% BUILDING MAINTENANCEFUND (016) 35 PROFESSIONAL SERVICES $ 121,500 $ 450 $ 703 $ 120,797 10/( 36 REPAIR&MAINTENANCE 1,153,500 16,072 16,510 1,136,990 10/( 37 BUILDINGS - - 299,668 (299,668) 00/( 38 MACHINERY/EQUIPMENT 552 - 00/( 39 CONS TRUCTIONS PROJECTS - - 308,310 (308,310) 00% 1,275,000 17,074 625,190 649,810 490% DRUG ENFORCEMENTFUND (104) 40 SMALL EQUIPMENT $ - $ - $ 32,485 $ (32,485) 00/( 41 PROFESSIONAL SERVICES 45,000 - 45,000 00/( 42 REPAIR/MAINT 800 - 800 00/( 43 MACHINERY/EQUIPMENT - 6,291 - - 00/( $ 45,800 6,291 32,485 13,315 71% F O O C R C LL t C O 2 Cl) N 0 N L d E Q O Z 24 Packet Pg. 27 I 2.1.a I Page 2 of 6 C TTY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Amended 11/30/2022 11/30/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent SMEET' FUND (111) 1 SALARIES AND WAGES $ 1,154,552 $ 635,369 $ 939,998 $ 214,554 810/( 2 OVERTIME 38,400 37,914 30,514 7,886 790% 3 BENEFITS 440,911 311,175 389,756 51,155 880/( 4 UNIFORMS 6,000 4,341 4,404 1,596 730/( 5 SUPPLIES 263,000 201,187 195,939 67,061 750/( 6 SMALL EQUIPMENT 20,000 1,517 6,250 13,750 310/( 7 PROFESSIONAL SERVICES 23,210 19,784 12,035 11,175 520% 8 COMMUNICATIONS 4,500 6,105 5,671 (1,171) 1260/( 9 TRAVEL 1,000 - - 1,000 00% 10 RENTAL/LEASE 304,730 266,700 280,298 24,432 920/( 11 INSURANCE 126,466 184,111 126,467 (1) 1000% 12 UTILITIES 273,730 219,475 225,749 47,981 820/( 13 REPAIRS & MAINTENANCE 52,000 37,818 20,284 31,716 390/( 14 MISCELLANEOUS 8,000 3,692 6,642 1,358 830/( 15 BUILDINGS 25,000 - - 25,000 00/( 16 OTHERIMPROVEMENTS - - 165,353 (165,353) 00/( 17 MACHINERY/EQUIPMENT - 21,382 - - 00/( 18 GENERAL OBLIGATION BOND PRINCIPAL 4,380 - - 4,380 00/( 19 INTEREST 300 185 149 151 5001( $ 2,746,179 $ 1,950,754 $ 2,409,509 $ 336,670 880% COMBINED STREErCONST/IMPROVE(112) 20 PROFESSIONAL SERVICES $ 3,817,980 $ 1,180,062 $ 2,458,365 $ 1,359,615 640/( 21 REPAIRS& MAINTENANCE 1,139,535 1,433 1,074,099 65,436 940% 22 INTERFUND SUBSIDIES 172,650 39,728 21,388 151,262 120/( 23 LAND 270,000 72,782 - 270,000 00/( 24 CONSTRUCTION PROJECTS 5,818,580 2,194,894 3,986,178 1,832,402 690/( 25 INTERGOVERNMENTAL LOANS 54,070 72,201 54,058 12 1000/( 26 INTEREST 880 1,230 869 11 990/( $ 11,273,695 $ 3,562,331 $ 7,594,958 $ 3,678,737 670% MUNIC IPAL ARTS AC Q UIS. FUND (117) 27 SUPPLIES $ 4,700 $ 966 $ 4,578 $ 122 970/( 28 SMALL EQUIPMENT 1,700 - 400 1,300 240/( 29 PROFESSIONAL SERVICES 191,000 98,402 91,777 99,223 480/( 30 TRAVEL 80 - - 80 00/( 31 RENTAL/LEASE 3,000 32 2,968 10/( 32 REPAIRS & MAINTENANCE 300 - - 300 00/( 33 MISCELLANEOUS 6,600 2,731 6,466 134 980% $ 207,380 $ 102,099 $ 103,254 $ 104,126 50°/ HO TE UMO TEL TAX REVENUE FUND (120) 34 PROFESSIONAL SERVICES $ 90,400 $ 64,765 $ 20,973 $ 69,427 230/( 35 MISCELLANEOUS 1,000 - - 1,000 00/( 36 INTERFUND SUBSIDIES 4,000 4,000 4,000 - 1000/( $ 95,400 $ 68,765 $ 24,973 $ 70,427 260% EMPLOYEEPARKING PERMIT FUND (121) 37 SUPPLIES $ 1,790 $ 740 $ 825 $ 965 460/( 38 PROFESSIONAL SERVICES 25,090 - - 25,090 00/( $ 26,880 $ 740 $ 825 $ 26,055 3°/ YOUTH SCHOLARSHIP FUND (122) 39 SUPPLIES $ - $ 322 $ - $ - 00N 40 MISCELLANEOUS 3,000 - (75) 3,075 -3°/ $ 3,000 $ 322 $ (75) $ 3,075 -3°/ TO URIS M PRO MO TIO NAL FUND/ARTS (123) 41 PROFESSIONAL SERVICES $ 28,500 $ 10,733 $ 17,650 $ 10,850 620% $ 28,500 $ 10,733 $ 17,650 $ 10,850 620/( 25 Packet Pg. 28 I 2.1.a I Page 3 of 6 C TTY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Amended 11/30/2022 11/30/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent REAL ESTATE EXCISETAX 2 (125) 1 SUPPLIES $ - $ 17,312 $ - $ - 00/( 2 PROFESSIONAL SERVICES 616,867 762,208 434,582 182,285 700/( 3 REPAIRS& MAINTENANCE 1,148,910 178,723 611,621 537,289 530/( 4 INTERFUND SUBSIDIES 5,684 - 34 5,650 10/( 5 LAND 200,000 - 77,753 122,247 390N 6 CONSTRUCTION PROJECTS 2,343,957 1,145,956 1,222,407 1,121,550 520/( $ 4,315,418 $ 2,104,200 $ 2,346,396 $ 1,969,022 540/( 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 14 OTHER INTEREST & DEBT SERVICE COSTS GIFTS CATALOG FUND (127) 15 SALARIES AND WAGES 16 OVERTIME 17 BENEFIT S 18 SUPPLIES 19 SMALL EQUIPMENT 20 PROFESSIONAL SERVICES 21 RENTAL/LEASE 22 MISCELLANEOUS 23 INTERFUND SUBSIDIES C EMEYERY MAINTEVANC UIMPRO VEVI ENT (130) 24 SALARIES AND WAGES 25 OVERTIME 26 BENEFIT S 27 UNIFORMS 28 SUPPLIES 29 SUPPLIES PURCHASED FOR INVENTORY/RESALE 30 PROFESSIONAL SERVICES 31 COMMUNICATIONS 32 TRAVEL 33 RENTAL/LEASE 34 UTILITIES 35 REPAIRS & MAINTENANCE 36 MISCELLANEOUS PARKS TRUSTFUND (136) 37 PROFESSIONAL SERVICES 38 INTERFUND SUBSIDIES CEMETERY MAINTENANCE TRUST FUND (137) 39 SMALL EQUIPMENT SISTER CITY COMMISSION (138) 40 SUPPLIES 41 TRAVEL 42 MISCELLANEOUS BUSINESS IMPROVE IENTDISTRICTFUND (140) 43 SUPPLIES 44 PROFESSIONAL SERVICES 45 MISCELLANEOUS EDMONDS RESCUEPLAN FUND (142) 46 PROFESSIONAL SERVICES TREE FUND (143) 47 SUPPLIES 48 PROFESSIONAL SERVICES 49 LAND $ 292,065 $ 512,360 $ 329,134 $ (37,069) 1130% 578,340 16,897 259,725 318,615 450/( 148,575 10,138 - 148,575 00/( 100,000 - 130,000 (30,000) 1300/( 848,963 99,685 56,262 792,701 70/( 155,470 - - 155,470 00X 103,970 55,314 51,982 51,988 5001( - 980 700 (700) 00/( $ 2,227,383 $ 695,373 $ 827,803 $ 1,399,580 377/( $ 241,455 $ $ 164,073 $ 77,382 680/( - 5,791 (5,791) 00/( 89,033 69,477 19,556 780/( 146,000 83,495 42,683 103,317 290/( 500 - - 500 00/( 56,500 - 56,500 00/( 17,510 16,051 1,459 920/( 600 - 348 252 580% - 26,300 - - 00/( $ 551,598 $ 109,795 $ 298,422 $ 253,176 540/( $ 172,817 $ 99,246 $ 130,898 $ 41,919 760% 3,500 1,012 2,717 783 780/( 61,328 36,592 52,862 8,466 860/( 1,000 - - 1,000 00/( 7,000 2,855 6,273 727 900% 20,000 20,245 25,268 (5,268) 1260% 4,200 1,150 3,248 952 770/( 1,700 1,580 1,583 117 930/( 500 - - 500 00/( 9,420 10,815 8,744 676 930/( 5,565 4,634 9,845 (4,280) 1770/( 500 3,536 1,326 (826) 2650/( 4,000 9,673 8,372 (4,372) 2090/( $ 291,530 $ 191,337 $ 251,137 $ 40,393 860% $ 43,842 $ 3,610 $ - $ 43,842 00/( 172,220 - 161,439 10,781 940% $ 216,062 $ 3,610 $ 161,439 $ 54,623 750% $ 50,000 $ $ $ 50,000 00N $ 50,000 $ $ $ 50,000 00/( $ 1,500 $ $ 315 $ 1,185 210% 4,500 2,323 2,177 520% 5,900 70 5,286 614 900% $ 11,900 $ 70 $ 7,923 $ 3,977 670% $ 4,091 $ 13,047 $ 13,205 $ (9,114) 3230% 78,327 50,530 51,143 27,184 650/( 6,157 2,034 1,861 4,296 300% 88,575 65,611 66,208 22,367 750/( $ 1,879,000 $ 689,835 $ 1,329,175 $ 549,825 710% 1,879,000 689,835 1,329,175 549,825 710% 1,000 $ $ $ 1,000 00/( 39,800 39,800 00/( 199,000 199,000 0% F O O C R C LL 21 t C O 2 Cl) N O N L d E O Z Packet Pg. 29 1 I 2.1.a I Page 4 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Amended 11/30/2022 11/30/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent 2012 LTGO DEBTSERVIC FUND (231) 1 GENERAL OBLIGATION BOND $ 235,000 $ - $ - $ 235,000 09 2 INTEREST 74,800 41,009 37,395 37,405 509 3 OTHER INTEREST & DEBT SERVICE COSTS - 481 350 (350) 09 $ 309,800 $ 41,489 $ 37,745 $ 272,055 129 PARKS CONSTRUCTION FUND (332) 4 INTERFUND SUBSIDIES 5 PROFESSIONAL SERVICES 6 CONSTRUCTION PROJECTS 7 GENERAL OBLIGATION BONDS 8 INTEREST WATER FUND (421) 9 SALARIES AND WAGES 10 OVERTIME 11 BENEFIT S 12 UNIFORMS 13 SUPPLIES 14 WATER PURCHASED FOR RESALE 15 SUPPLIES PURCHASED FOR INVENTORY/RESALE 16 SMALL EQUIPMENT 17 PROFESSIONAL SERVICES 18 COMMUNICATIONS 19 TRAVEL 20 EXCISE TAXES 21 RENTAL/LEASE 22 INSURANCE 23 UTILITIES 24 REPAIRS& MAINTENANCE 25 MISCELLANEOUS 26 INTERFUND SUBSIDIES 27 BUILDINGS 28 MACHINERY/EQUIPMENT 29 CONSTRUCTION PROJECTS 30 GENERAL OBLIGATION BONDS 31 REVENUE BONDS 32 INTERGOVERNMENTAL LOANS 33 INTEREST 34 OTHER INTEREST & DEBT SERVICE COSTS S TO RM FUND (422) 35 SALARIES AND WAGES 36 OVERTIME 37 BENEFITS 38 UNIFORMS 39 SUPPLIES 40 SMALL EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATIONS 43 TRAVEL 44 EXCISE TAXES 45 RENTAL/LEASE 46 INSURANCE 47 UTILITES 48 REPAIR & MAINTENANCE 49 MISCELLANEOUS 50 INTERFUND SUBSIDIES 51 LAND 52 BUILDINGS 53 MACHINERY/EQUIPMENT 54 CONSTRUCTION PROJECTS 55 GENERAL OBLIGATION BONDS 56 REVENUE BONDS 57 INTERGOVERNMENTAL LOANS 58 INTEREST 59 OTHER INTEREST & DEBT SERVICE COSTS $ - $ 62,656 $ 675,000 $ (675,000) 09 1,352,620 848,590 141,867 1,210,753 109 805,377 4,032,696 1,056,621 (251,244) 1319 50,000 - - 50,000 01 p 47,650 26,059 23,825 23,825 509 0 $ 2,255,647 $ 4,970,001 $ 1,897,313 $ 358,334 849 wo T $ 1,205,783 $ 676,857 $ 890,501 $ 315,282 749 'v 24,000 16,169 19,260 4,740 809 440,577 290,915 361,498 79,079 829 C 4,000 3,345 3,952 48 999 150,000 121,987 117,579 32,421 789 �+ 2,398,000 1,845,969 1,924,693 473,307 809 180,000 151,916 132,955 47,045 749 C 13,500 3,796 7,363 6,137 559 2 2,256,928 916,237 1,311,703 945,225 589 M 35,000 29,554 32,070 2,930 929 0 200 - 462 (262) 2319 N 1,696,934 1,326,896 1,415,057 281,878 839 d 202,496 137,509 180,911 21,586 890 -0 225,380 122,359 225,379 1 1009 y 35,000 28,216 27,949 7,051 809 C 71,130 24,249 59,398 11,732 849 Z 123,600 172,872 233,954 (110,354) 1899 646,370 194,533 189,888 456,482 299 C 12,500 - - 12,500 09 Q 10,000 10,044 5,943 4,057 599 1,670,000 87,212 1,473,943 196,058 889 2,940 - - 2,940 04 2 333,830 - - 333,830 09 25,840 25,839 25,839 1 1009 = 185,300 104,805 92,769 92,531 509 LL - 868 444 (444) 09 A $ 11,949,308 $ 6,292,149 $ 8,733,509 $ 3,215,799 739 t $ 1,113,757 $ 690,663 $ 943,474 $ 170,283 8M 26,000 12,607 13,095 12,905 509 398,973 288,054 341,511 57,462 869 6,500 6,040 5,716 784 889 46,000 48,663 26,971 19,029 599 4,000 985 1,713 2,287 439 3,143,445 3,186,443 1,403,108 1,740,337 450 3,200 5,454 5,974 (2,774) 1879 4,300 1,982 699 3,601 169 499,658 631,812 657,018 (157,360) 1319 307,168 240,995 276,157 31,011 909 31,679 82,335 31,680 (1) 1009 10,500 13,379 13,563 (3,063) 1299 189,130 13,456 126,158 62,972 679 232,300 223,758 240,857 (8,557) 1049 283,341 75,745 72,689 210,652 269 680,000 - - 680,000 09 25,000 - - 25,000 09 56,474 - 12,536 43,938 229 1,031,645 282,979 397,499 634,146 390 107,290 - - 107,290 09 160,870 - - 160,870 09 61,600 61,590 61,590 10 1009 103,070 61,859 55,231 47,839 549 - 383 193 (193) 09 $ 8,525,900 $ 5,929,183 $ 4,687,429 $ 3,838,471 559 27 Packet Pg. 30 I 2.1.a I Page 5 of 6 C TTY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Amended 11/30/2022 11/30/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent SEWER FUND (423) 1 SALARIES AND WAGES $ 3,159,792 $ 1,676,555 $ 2,680,234 $ 479,558 8M 2 OVERTIME 130,000 119,403 155,225 (25,225) 1199 3 BENEFITS 1,043,665 673,514 970,550 73,115 9M 4 UNIFORMS 11,500 9,867 10,066 1,434 8M 5 SUPPLIES 453,000 260,408 413,423 39,577 919 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 115,074 9,326 74,574 119 9 PROFESSIONAL SERVICES 2,587,949 2,803,220 2,260,197 327,752 879 10 COMMUNICATIONS 48,000 41,254 44,509 3,491 939 11 TRAVEL 5,000 495 (111) 5,111 -29 12 EXCISE TAXES 1,026,360 1,012,945 1,148,080 (121,720) 1129 13 RENTAL/LEASE 344,978 290,180 309,831 35,147 909 14 INSURANCE 360,663 203,936 364,070 (3,407) 1019 15 UTILITIES 3,607,060 2,241,120 3,011,335 595,725 8M 16 REPAIR & MAINTENANCE 728,630 770,730 530,086 198,544 7M 17 MISCELLANEOUS 138,350 230,144 331,700 (193,350) 2409 18 INTERFUND SUBSIDIES 1,588,089 1,175,403 432,735 1,155,354 279 19 BUILDINGS 12,500 - - 12,500 09 20 MACHINERY/EQUIPMENT - 68,126 - - 09 21 CONSTRUCTION PROJECTS 2,976,163 2,960,744 1,287,910 1,688,253 439 22 GENERAL OBLIGATION BONDS 129,820 - - 129,820 09 23 REVENUE BONDS 55,310 - - 55,310 09 24 INTERGOVERNMENTAL LOANS 104,000 174,591 103,986 14 1009 25 INTEREST 353,270 182,515 177,781 175,489 509 26 OTHER INT EREST & DEBT SERVICE COSTS - 5,657 4,582 (4,582) 09 $ 18,972,999 $ 15,015,884 $ 14,245,513 $ 4,727,486 7M BOND RESERVE FUND (424) 27 REVENUE BONDS $ 840,010 $ - $ - $ 840,010 09 28 INTEREST 1,149,810 589,342 574,892 574,918 509 $ 1,989,820 $ 589,342 $ 574,892 $ 1,414,928 299 28 Packet Pg. 31 2.1.a Page 6 of 6 C ITY O F IDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Amended 11/30/2022 11/30/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent EQ UIPMENT RENTAL FUND (511) 1 SALARIES AND WAGES $ 395,171 $ 246,723 $ 353,631 $ 41,540 899 2 OVERTIME 2,000 3,567 3,958 (1,958) 1989 3 BENEFITS 132,345 88,063 117,196 15,149 899 4 UNIFORMS 1,500 1,054 1,938 (438) 1299 5 SUPPLIES 149,120 80,886 120,353 28,767 819 6 FUEL CONSUMED 1,000 - - 1,000 09 7 SUPPLIES PURCHASED FOR INVENTORY/RESALE 458,880 361,929 261,224 197,656 579 8 SMALL EQUIPMENT 58,000 4,060 7,894 50,106 149 9 PROFESSIONAL SERVICES 46,750 1,317 1,411 45,339 39 10 COMMUNICATIONS 3,000 2,073 2,907 93 979 11 TRAVEL 1,000 - 1,870 (870) 1879 12 RENTAL/LEASE 17,470 9,549 15,332 2,138 889 13 INSURANCE 50,178 51,903 52,373 (2,195) 1049 14 UTILITIES 14,000 17,559 17,926 (3,926) 1289 15 REPAIRS& MAINTENANCE 60,000 69,602 49,173 10,827 829 16 MISCELLANEOUS 12,000 7,290 9,337 2,663 789 17 MACHINERY/EQUIPMENT 3,564,411 343,473 1,741,019 1,823,392 499 $ 4,966,825 $ 1,289,048 $ 2,757,544 $ 2,209,281 569 TECHNOLOGY RENTAL FUND (512) 18 SALARIES AND WAGES $ 657,771 $ 347,341 $ 525,510 $ 132,261 809 19 OVERTIME 2,000 1,286 270 1,730 IM 20 BENEFITS 191,954 123,481 188,103 3,851 989 21 SUPPLIES 5,000 6,552 6,954 (1,954) 1399 22 SMALL EQUIPMENT 181,800 60,300 130,892 50,908 729 23 PROFESSIONAL SERVICES 61,860 32,492 43,018 18,842 709 24 COMMUNICATIONS 58,770 59,539 65,627 (6,857) 1129 25 TRAVEL 1,500 296 - 1,500 09 26 RENTAL/LEASE 4,640 4,088 1,504 3,136 329 27 REPAIRS& MAINTENANCE 666,729 429,086 637,490 29,239 969 28 MISCELLANEOUS 55,600 3,583 11,033 44,567 209 29 MACHINERY/EQUIPMENT 56,000 251,887 13,060 42,940 239 $ 1,943,624 $ 1,319,931 $ 1,623,461 $ 320,163 849 TOTAL EXPENDITURE ALL FUNDS $ 140,855,817 $ 89,264,231 $ 105,473,640 $ 35,382,177 759 29 Packet Pg. 32 2.1.a Page 1 of 1 CITY OF EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN SUMMARY 2023 Amended 11/30/2022 11/30/2023 Amount Title Budget Expenditures Expenditures Remaining % Spent CITY COUNCIL OFFICE OF MAYOR HUMAN RESOURCES MUNICIPAL COURT ADMINISTRATIVE SERVICES CITY ATTORNEY NON -DEPART MENTAL POLICE SERVICES SATELLITE OFFICE COMMUNITY SERVICES/ECONOMIC DEV PLANNING& DEVELOPMENT HUMAN SERVICES PROGRAM PARKS & RECREATION PUBLIC WORKS FACILITIES MAINTENANCE $ 486,719 $ 313,168 $ 390,805 $ 95,914 80% 505,239 326,819 354,414 150,825 70% 1,297,746 839,279 876,005 421,741 68% 1,827,709 1,229,098 1,343,740 483,969 74% O 2,502,670 2,098,000 2,347,890 154,780 94% 1,161,780 866,285 888,974 272,806 77% 18,488,589 12,742,350 17,150,215 1,338,374 93% _ R 14,826,373 11,791,103 13,445,385 1,380,988 91% E LL 230,681 86,350 117,457 113,224 51% �+ t 1,312,555 640,700 1,185,309 127,246 90% C O 5,246,507 3,387,809 3,515,544 1,730,963 67% 2 347,982 157,016 234,573 113,409 67% M p N 6,575,662 4,349,263 5,476,396 1,099,266 83% d 4,283,090 2,997,498 3,650,444 632,646 85% E 4,877,452 2,177,230 3,504,989 1,372,463 72% Q p Z $ 63,970,754 $ 44,001,969 $ 54,482,142 $ 9,488,612 85% C ITY O F EDMO NDS EXPENDITURES - UTILITY- BY FUND IN SUMMARY Title 2023 Amended Budget 11/30/2022 Expenditures 11/30/2023 Expenditures Amount Remaining %Spent WATER UTILITYFUND $ 11,949,308 $ 6,292,149 $ 8,733,509 $ 3,215,799 73% STORM UTILITY FUND 8,525,900 5,929,183 4,687,429 3,838,471 55% SEWER/WWTP UTILITY FUND 18,972,999 15,015,884 14,245,513 4,727,486 75% BOND RESERVE FUND 1,989,820 589,342 574,892 1,414,928 29% $ 41,438,027 $ 27,826,557 $ 28,241,343 $ 13,196,684 68% 30 Packet Pg. 33 I 2.1.a I Page 1 of 2 C ITY O F FAMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL Title 2023 Amended Budget 11/30/2022 Expenditures 11/30/2023 Expenditures Amount Remaining %Spent C TIY C O UNC IL SALARIES AND WAGES $ 219,276 $ 175,034 $ 203,453 $ 15,823 93% BENEFITS 103,845 86,304 97,034 6,811 93% SUPPLIES 11,000 2,591 1,766 9,234 16% SERVICES 152,598 49,238 88,552 64,046 58% $ 486,719 $ 313,168 $ 390,805 $ 95,914 80% OFFICEOFMAYOR SALARIES AND WAGES $ 282,988 $ 227,832 $ 237,709 $ 45,279 84% BENEFITS 90,087 78,187 81,450 8,637 90% SUPPLIES 1,500 2,079 1,402 98 93% SERVICES 130,664 18,722 33,853 96,811 26% $ 505,239 $ 326,819 $ 354,414 $ 150,825 70% HUMAN RESOURCES SALARIES AND WAGES $ 782,258 $ 439,278 $ 494,138 $ 288,120 63% BENEFITS 243,609 144,263 185,213 58,396 76% SUPPLIES 13,600 1,368 5,518 8,082 41% SERVICES 258,279 254,370 191,137 67,142 74% $ 1,297,746 $ 839,279 $ 876,005 $ 421,741 68% MUNIC IPAL C O URT SALARIES AND WAGES $ 1,234,740 $ 812,367 $ 889,155 $ 345,585 72% BENEFITS 345,764 241,197 271,249 74,515 78% SUPPLIES 23,048 7,818 13,173 9,875 57% SERVICES 224,157 167,716 170,163 53,994 76% $ 1,827,709 $ 1,229,098 $ 1,343,740 $ 483,969 74% ADMINIS TRATIVE S ERVIC ES SALARIES AND WAGES $ 1,601,894 $ 1,323,811 $ 1,521,368 $ 80,526 95% BENEFITS 465,703 393,908 439,819 25,884 94% SUPPLIES 13,000 10,298 8,354 4,646 64% SERVICES 422,073 369,984 378,349 43,724 90% $ 2,502,670 $ 2,098,000 $ 2,347,890 $ 154,780 94% C 1TY ATTORNEY SERVICES $ 1,161,780 $ 866,285 $ 888,974 $ 272,806 77% $ 1,161,780 $ 866,285 $ 888,974 $ 272,806 77% NON -DEPARTMENTAL SALARIES AND WAGES $ 101,750 $ - $ - $ 101,750 0% BENEFITS 239,583 120,344 98,369 141,214 41% SUPPLIES 5,000 - - 5,000 0% SERVICES 16,426,684 11,614,501 15,834,591 592,093 96% INTERFUND SUBSIDIES 1,391,982 935,000 1,151,522 240,460 83% DEBT SERVICE - PRINCIPAL 191,620 - - 191,620 0% DEBT SERVICE - INTEREST 131,970 72,505 65,733 66,237 50% $ 18,488,589 $ 12,742,350 $ 17,150,215 $ 1,338,374 93% PO LIC E SERVIC ES SALARIES AND WAGES $ 9,366,760 $ 7,540,516 $ 8,399,322 $ 967,438 90% BENEFITS 3,280,628 2,601,960 2,898,080 382,548 88% SUPPLIES 342,941 337,562 241,179 101,762 70% SERVICES 1,786,044 1,183,111 1,833,089 (47,045) 103% DEBT SERVICE - PRINCIPAL 50,000 - - 50,000 0% MACHINERY/EQUIPMENT - 127,953 73,714 (73,714) 0% $ 14,826,373 $ 11,791,103 $ 13,445,385 $ 1,380,988 91% SATELLITE O FFIC E SALARIES AND WAGES $ 38,537 $ 15,348 $ 40,040 $ (1,503) 104% BENEFITS 7,298 2,886 23,207 (15,909) 318% SUPPLIES 17,000 11,057 226 16,774 1% SERVICES 167,846 57,059 53,984 113,862 32% $ 230,681 $ 86,350 $ 117,457 $ 113,224 51% F O 0 C R C LL 21 t C O 2 Cl) N O N d E O Z 31 Packet Pg. 34 1 Page 2 of 2 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2023 Amended 11/30/2022 11/30/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent C O MMUNITY S ERVIC ES/EC O N DEV. SALARIES AND WAGES $ 613,413 $ 310,615 $ 595,964 $ 17,449 97% BENEFITS 165,783 86,269 151,911 13,872 92% SUPPLIES 4,075 661 1,463 2,612 36% SERVICES 529,284 243,155 435,971 93,313 82% $ 1,312,555 $ 640,700 $ 1,185,309 $ 127,246 90% PLANNING & DEVELOPMENT SALARIES AND WAGES $ 2,392,581 $ 1,980,022 $ 2,145,031 $ 247,550 90% BENEFITS 779,673 660,459 757,713 21,960 97% SUPPLIES 23,400 8,631 14,766 8,634 63% SERVICES 2,050,853 738,697 598,034 1,452,819 29% $ 5,246,507 $ 3,387,809 $ 3,515,544 $ 1,730,963 67% HUMAN SERVICES PROGRAM SALARIES AND WAGES $ 121,292 $ 76,320 $ 102,190 $ 19,102 84% BENEFITS 33,190 20,949 31,147 2,043 94% SUPPLIES 15,000 5,358 3,638 11,362 24% SERVICES 178,500 48,781 97,598 80,902 55% MACHINERY/EQUIPMENT - 5,608 - - 0% 347,982 157,016 234,573 113,409 67% PARKS & RECREATION SALARIES AND WAGES $ 3,269,091 $ 2,312,927 $ 2,744,544 $ 524,547 84% BENEFITS 1,074,929 775,072 964,175 110,754 90% SUPPLIES 468,900 228,306 375,376 93,524 80% SERVICES 1,672,742 1,032,958 1,238,416 434,326 74% MACHINERY/EQUIPMENT 90,000 - 153,886 (63,886) 171% $ 6,575,662 $ 4,349,263 $ 5,476,396 $ 1,099,266 83% PUBLIC WORKS ADMINISTRATION SALARIES AND WAGES $ 409,900 $ 178,009 $ 404,072 $ 5,828 99% BENEFITS 150,075 74,521 121,054 29,021 81% SUPPLIES 9,600 4,477 12,072 (2,472) 126% SERVICES 98,006 76,238 84,757 13,249 86% $ 667,581 $ 333,245 $ 621,956 $ 45,625 93% FACILITIES MAINTENANCE SALARIES AND WAGES 1,287,006 808,703 1,145,194 141,812 89% BENEFITS 462,021 325,710 434,530 27,491 94% SUPPLIES 128,000 114,053 97,755.14 30,245 76% SERVICES 1,359,860 847,648 1,177,466 182,394 87% MACHINERY/EQUIPMENT 1,640,565 81,116 650,043 990,522 40% $ 4,877,452 $ 2,177,230 $ 3,504,989 $ 1,372,463 72% ENGINEERING SALARIES AND WAGES $ 2,395,963 $ 1,812,539 $ 2,019,007 $ 376,956 84% BENEFITS 812,924 643,257 702,731 110,193 86% SUPPLIES 2,200 1,349 3,375 (1,175) 153% SERVICES 404,422 207,109 303,376 101,046 75% $ 3,615,509 $ 2,664,254 $ 3,028,489 $ 587,020 84% TOTAL GENERAL FUND EXPENDITURES $ 63,970,754 $ 44,001,969 $ 54,482,142 $ 9,488,612 85% t O Q O 0 C R C LL 21 t C O 2 Cl) N O N L d E O Z 32 Packet Pg. 35 2.1.a GENERAL FUND OVERVIEW BALANCES CHANGE IN FUND BALANCES GENERAL FUND ---- ACTUAL ---- ---- ACTUAL ---- & SUBFUNDS 1 1 /30/2023 1 1 /30/2023 Q3 YTD Fund Balance Cash Balance 001-General Fund $ 3,827,108 $ 968,546 $ (4,890,656) $ (8,075,847 0 009-Leoff-Medical Ins. Reserve 132,801 148,753 (108,590) (84,063 011-Risk Management Reserve Fund - - (25,000) (25,000 012-Contingency Reserve Fund 2,228,672 2,228,672 - 446,522 c 014-Historic Preservation Gift Fund 8,944 8,944 - (2,757 c 016-Building Maintenance 3,761,782 3,905,058 (103,201) (534,821 017 - Marsh Restoration & Preservation 853,595 853,595 3,829 3,829 r 018 - Edmonds Homelessness Response Fd 200,000 200,000 - - c 0 019 - Opioid Response Fund 123,126 74,119 - 74,119 c� N Total General Fund & Subfunds Is 11,136,027 $ 8,387,687 $ (5,123,618) $ (8,198,019, N L d E *$8,914,686 of the fund balance in Fund 001 added to the $2,228,672 balance in Fund 012, represent the required > 20% operating reserve. z0 There are no interfund loans outstanding at this time. 0 a� GOVERNMENTAL FUNDS OVERVIEW LL 21 0 2 M N BALANCES CHANGE IN FUND BALANCES N L GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- s FUNDS 11 /30/2023 11 /30/2023 Q3 YTD Fund Balance Cash Balance 0 z r General Fund & Subfunds $ 11,136,027 $ 8,387,687 $ (5,123,618) $ (8,198,019 . d E Special Revenue 15,512,423 20,362,362 (677,917) (687,327 Capital Projects - Fund 332 401,739 286,759 691,038 194,056 Total Governmental Funds $ 27,050,189 $ 29,036,808 $ (5,110,497) $ (8,691,289. 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. 36 2.1.a SPECIAL REVENUE FUNDS OVERVIEW BALANCES CHANGE IN FUND BALANCES GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- SPECIAL REVENUE 11/30/2023 11/30/2023 Q3 YTD Fund Balance Cash Balance 104 - Drug Enforcement Fund $ 37,040 $ 40,180 (31,900) $ (30,530 C 111 - Street Fund (317,572) (260,367) (140,571) (726,256; m 112 - Combined Street Const/Improve 3,006,028 305,008 (485,000) 566,523 W 117 - Municipal Arts Acquis. Fund 610,991 641,195 16,366 (23,897 120 - Hotel/Motel Tax Revenue Fund 183,420 172,894 30,908 88,556 c 121 - Employee Parking Permit Fund 89,752 93,232 961 14,720 c 122 -Youth Scholarship Fund 16,833 17,538 1,352 1,625 L, 123-Tourism Promotional Fund/Arts 137,630 137,604 9,305 22,460 s 125 - Real Estate Tax 2,224,995 2,421,322 58,739 (992,020; c 126 - Real Estate Excise Tax 1 ' 4,523,135 4,706,881 354,715 573,155 a 127 - Gifts Catalog Fund 2,975,683 3,117,786 19,452 (88,110 N 130 - Cemetery Maintenance/Improvement 200,176 213,030 (22,146) (67,993 N 136 - Parks Trust Fund (7,497) - (161,439) (168,935; m 137- Cemetery Maintenance Trust Fund 1,154,757 1,205,930 19,026 51,457 E 138- Sister CityCommission 17,577 18,500 114 (2,317 > 140 -Business Improvement Disrict 50,902 50,902 (10,144) 11,118 Z 141 -Affordable and Supportive Housing Fd 300,134 292,495 26,296 65,568 142 - Edmonds Rescue Plan Fund 75,595 6,944,895 (366,841) 11,007 oo 143 -Tree Fund 232,842 243,338 2,891 6,542 CL a) Total Special Revenue $ 15,512,423 $ 20,362,362 j $ (677,917) $ (687,327 *$200,000 of the fund balance in Fund 126 has been reserved for Marsh Restoration Funding, as well as $1,000,000 for the purchase of Open Space. ii ENTERPRISE FUNDS OVERVIEW '' 0 2 M N O N BALANCES CHANGE IN FUND BALANCES I.. ENTERPRISE ---- ACTUAL ---- ---- ACTUAL ---- y FUNDS 11/30/2023 11/30/2023 Q3 YTD 0 Fund Balance Cash Balance Z r c 421 -Water Utility Fund $ 33,749,092 $ 10,540,406 $ 194,550 $ 1,860,469 E 422 -Storm Utility Fund * 20,378,448 7,355,725 1,011,232 2,306,716 0 423 - Sewer/WWTP Utility Fund 64,858,420 16,477,620 16,276 1,859,086 Q 424 - Bond Reserve Fund 860,271 860,271 4,680 16,310 411 -Combined Utility Operation 132,340 190,656 41,550 132,340 Total Enterprise Funds $ 119,978,572 $ 35,424,678 $ 1,268,288 $ 6,174,921 *$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. 37 2.1.a SUMMARY OVERVIEW BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- CITY-WIDE 11/30/2023 11/30/2023 Q3 YTD Fund Balance Cash Balance Governmental Funds $ 27,050,189 $ 29,036,808 $ (5,110,497) $ (8,691,289; o Enterprise Funds 119,978,572 35,424,678 1,268,288 6,174,921 Internal Services Fund 10,015,145 5,623,927 (230,970) (343,159, Total City-wide Total $ 157,043,905 $ 70,085,413 $ (4,073,179) $ (2,859,528 ca c ii 21 s r c INTERNAL SERVICE FUNDS OVERVIEW M N O N L d E 4) O BALANCES CHANGE IN FUND BALANCES ? INTERNAL SERVICE ---- ACTUAL ---- ---- ACTUAL ---- o a FUNDS 11/30/2023 11/30/2023 Q3 YTD Fund Balance Cash Balance c 511 -Equipment Rental Fund $ 9,207,641 $ 5,129,238 $ (304,312) $ (188,160, L 512 -Technology Rental Fund 807,504 494,688 73,341.94 (154,999, >+ t Total Internal Service Funds $ 10,015,145 $ 5,623,927 $ (230,970) $ (343,159 _ 0 M N O N L E d > O Z w+ C d E t <.i rt+ y.+ 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. 38 I 2.1.b I O-V lac. 1 ISOv CITY OF EDMONDS MONTHLY BUDGETARY FINANCIAL REPORT OCTO B E R 2023 Packet Pg. 39 1 I 2.1.b I INVESTMENT PORTFOLIO SUMMARY City of Edmonds Investment Portfolio Detail As of October 31, 2023 Years Agency/ Investment Purchase to Par Market Maturity Coupon Issuer Type Price Maturity Value Value Date Rate Kent WA Bonds 286,648 0.08 250,000 250,223 12/01/23 5.00% O IZ First Financial - Waterfront Center CD 245,000 0.16 245,000 245,000 12/28/23 1.49% 4) FHLB Bonds 2,004,464 0.21 2,000,000 1,996,593 01/16/24 4.81% FHLB Bonds 954,866 0.44 1,000,000 977,690 04/10/24 0.35% FM Bonds 996,082 0.63 1,000,000 982,593 06/17/24 2.80% _ FNMA Bonds 992,693 0.67 1,000,000 975,626 07/02/24 1.75% LL FFCB Bonds 1,960,906 0.87 2,000,000 1,965,753 09/13/24 3.50% t FHLB Bonds 950,774 1.05 1,000,000 952,741 11/18/24 0.90% Spokane County WA Bonds 207,260 1.09 200,000 193,098 12/01/24 2.10% FHLMC Bonds 974,798 1.37 1,000,000 978,591 03/13/25 3.75% N Farmer Mac Bonds 1,995,088 1.46 2,000,000 1,968,075 04/17/25 4.25% N FHLB Bonds 969,524 1.74 1,000,000 971,843 07/28/25 3.60% y US Treasury Note Note 964,597 1.79 1,000,000 966,211 08/15/25 3.13% E FFCB Bonds 1,982,692 2.11 2,000,000 1,958,511 12/08/25 4.13% Farmer Mac Bonds 1,994,172 2.26 2,000,000 1,951,490 02/02/26 3.95% C Z FHLMC Bonds 993,661 2.73 1,115,000 993,112 07/22/26 0.83% .. Farmer Mac Bonds 2,057,309 3.05 2,305,000 2,053,590 11/17/26 1.15% p IZ First Financial - ECA CD 2,803,516 4.04 2,803,516 2,803,516 11/15/27 2.96% 41 IV TOTAL SECURITIES 23,334,050 1.43 23,918,516 23,184,258 Washington State Local Gov't Investment Pool 9,233,831 9,233,831 Demand 5.40% Snohomish County Local Gov't Investment Pool 33,843,224.77 33,843,225 Demand 2.58% TOTAL PORTFOLIO $ 66,995,572 $ 66,261,313 Kent Issuer Diversification First WA, Financial- 1% CD, 13% Spokane Farmer County Mac, 26% WA, 1% FFCB, 17% FHLMC, 9% FHLB, 21% Cash and Investment Balances Checki ng, (in $ Millions) _ $9.35 , 12% Mil Note, Bonds, State LGIP, $1.00, 1° $19.87, $9.23, 12% 26% CD's, $3.05 , County 4% LGI P, $33.84 , 45% 1 Packet Pg. 40 1 I 2.1.b I INVESTMENT PORTFOLIO SUMMARY Annual Interest Income $1,600,000 $1,400, 000 $1,3 60,415 $1,200,000 $1 236 875 $947,931 950 684 5TTTE-7-09 $1,000,000 882 556 $800,000 — $600,000 — $400,000 — $200,000 — $- p - 2019 2021 2022 YTD 2023 F 0 CL m c to c U- t c 0 2 Cl) N O N L d E d 0 Z 2 Packet Pg. 41 GENERAL FUND SUMMARY 2.1.b General Fund Revenues and Expenses (Rolling 24 months) General Fund Revenues General Fund Expenses 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 November February May August November February May August 12,000,000 10,000, 000 8,000,000 6,000,000 4,000,000 2,000,000 11,000, 000 10,000,000 9,000,000 8,000,000 7,000, 000 6,000, 000 51000,000 4,000,000 3,000, 000 2,000, 000 1,000,000 0 a am �a .v c lC C ii , t a+ C 0 2 M N O N I. - General Fund Tax Revenue (2017 through 2022 4) • Sales Tax Property Tax EMS Tax Other Taxes p Z _ t Q. m �a 2017 2018 2019 Sales Tax s s u 2020 2021 2022 General Fund Tax Revenue (2023 YTD) s s Property Tax EMS Tax Other Taxes 3 Packet Pg. 42 I 2.1.b I City of Edmonds, WA Monthly Revenue Summary -General Fund 2023 General Fund Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 2,843,094 $ 2,843,094 $ 2,320,252 -18.39% February 5,636,382 2,793,288 4,920,100 -12.71% March 8,487,993 2,851,611 8,150,445 -3.98% April 12,010,212 3,522,219 16,689,365 38.96% May 22,451,612 10,441,400 21,615,550 -3.72% June 25,498,180 3,046,568 23,772,230 -6.77% July 28,462,795 2,964,616 27,008,084 -5.11% August 31,857,014 3,394,219 30,494,023 -4.28% September 34,651,707 2,794,693 33,627,848 -2.95% October 39,245,890 4,594,183 41,665,078 6.16% November 49,438,148 10,192,259 December 52,558,830 3,120,682 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 $ 343,196 $ 343,196 $ 151,084 -55.98% February 564,002 220,806 270,799 -51.99% March 914,189 350,187 521,829 -42.92% April 1,199,839 285,649 745,931 -37.83% May 1,552,936 353,097 1,053,507 -32.16% June 1,933,322 380,387 1,272,041 -34.20% July 2,318,897 385,574 1,582,268 -31.77% August 2,728,590 409,693 1,854,598 -32.03% September 3,157,962 429,373 2,189,986 -30.65% October 3,549,820 391,858 2,358,575 -33.56% November 3,941,307 391,487 December 4,400,000 458,693 Real Estate Excise Tax 1 & 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. F O Q 4) !C C M C LL L a+ C O 2 ch N O N I.- 4) M E d O Z 4 Packet Pg. 43 SALES TAX SUMMARY I 2.1.b I Construction Trade, $1,567,261 Accommmodation, $4Cfo ling and Accessories, $292,232 Communications, $209,714 Wholesale Trade, $280,012 Sales Tax Analysis By Category Current Period: October 2023 Year -to -Date Total $9,602,316 Automotive Repair, $206,387 Health & Personal \ Care, $69,348 Amusement & Recreation, $75,968 Business Services, =996,682 Gasoline, $0 Food Stores, $321,613 Misc Retail, $1,761,953 Manufacturing, Others, $252,607 Eating & Drinking, $107,735 $1,140,297 Annual Sales Tax Revenue 12,000,000 $10,302,518 1 27 10,000,000 $9 602 316 $7,395,114 $8,406,296 $8,452,715 $8,317,046 8,000, 000 6,000, 000 4,000, 000 2,000, 000 0 2017 2018 2019 2020 2021 2022 YTD 2023 F 0 CL w 25 _ R c ii t c 0 2 M N O N L d E d 0 z 5 Packet ry. 44 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 3,621,184 -0.60% May 4,624,484 981,259 4,607,308 -0.37% June 5,567,972 943,488 5,538,698 -0.53% July 6,580,085 1,012,114 6,542,037 -0.58% August 7,669,335 1,089,249 7,597,605 -0.94% September 8,683,583 1,014,248 8,581,012 -1.18% October 9,768,647 1,085,064 9,602,316 -1.70% 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 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 —P— Current Yeaz 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 4,885,632 435.57% May 5,909,096 4,996,860 5,742,964 -2.81% June 6,029,957 120,861 5,794,100 -3.91% July 6,148,773 118,816 5,817,644 -5.39% August 6,198,768 49,995 5,868,802 -5.32% September 6,260,415 61,647 6,034,775 -3.60% October 6,466,132 205,717 9,911,687 53.29% November 11,227,156 4,761,024 December 11,327,000 99,844 Real Pe rs onaMope rty 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 --0--CurrentYeaz Budget �PriorYear *The monthly budget forecast columns are based on a five-year average. 6 Packet Pg. 45 I 2.1.b 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 279,282 -3.31% May 373,578 84,744 363,282 -2.76% June 439,121 65,542 431,287 -1.78% July 541,031 101,910 543,193 0.40% August 629,368 88,337 633,755 0.70% September 748,356 118,987 752,727 0.58% October 835,253 86,898 835,975 0.09% November 933,046 97,793 December 993,712 60,666 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 --P-- Current Year Budget -d-- Prior Year City of Edmonds, WA Monthly Revenue Summary -Sewer Utility Tax 2023 Sewer Utility Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % 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 333,172 -4.43% May 444,771 96,145 424,703 -4.51% June 523,850 79,080 501,909 -4.19% July 620,193 96,343 596,420 -3.83% August 699,682 79,489 673,646 -3.72% September 799,189 99,507 768,545 -3.83% October 879,620 80,432 846,310 -3.79% November 976,901 97,281 December 1,055,821 78,920 Sewer Utility Tax 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. 7 Packet Pg. 46 I 2.1.b 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 1,439,675 -5.71% March 2,419,579 892,685 2,218,275 -8.32% April 3,010,919 591,341 2,792,540 -7.25% May 3,894,276 883,356 3,632,474 -6.72% June 4,577,455 683,180 4,312,420 -5.79% July 5,644,291 1,066,835 5,431,418 -3.77% August 6,565,058 920,767 6,336,928 -3.47% September 7,805,695 1,240,637 7,526,584 -3.58% October 8,711,524 905,829 8,358,957 -4.05% 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 1,359,827 -11.44% March 2,020,122 484,671 1,794,224 -11.18% April 2,451,545 431,422 2,181,313 -11.02% May 2,936,868 485,323 2,616,433 -10.91% June 3,368,111 431,243 3,004,165 -10.81% July 3,844,019 475,908 3,441,481 -10.47% August 4,895,662 1,051,643 4,390,758 -10.31% September 5,380,996 485,335 4,827,751 -10.28% October 5,812,621 431,625 5,215,008 -10.28% November 6,298,011 485,390 December 6,714,303 416,292 Storm Water Sales 0 I 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 IZ 4) !C C M C M L a+ C O 2 ch N O N L d M E d O Z g Packet Pg. 47 I 2.1.b 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 $ February March April May June July August September October November December 958,430 $ 1,745,646 2,695,497 3,484,346 4,445,696 5,235,623 6,198,081 6,992,099 7,987,044 8,790,485 9,763,192 10,551,011 958,430 $ 900,021 787,217 1,665,119 949,850 2,565,291 788,849 3,333,389 961,351 4,249,590 789,927 5,021,702 962,458 5,967,694 794,018 6,740,009 994,945 7,689,885 803,441 8,467,595 972,707 787,819 -6.09 -4.61 -4.83 -4.33 -4.41 -4.09 -3.72 -3.61 -3.72 -3.67 Unmeter Sewer Sales I L,000,UUU 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 9907 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. 9 Packet Pg. 48 I 2.1.b I City ofEdmonds, WA Monthly Expenditure Report -General Fund 2023 General Fund Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance January $ 6,137,826 $ 6,137,826 $ 4,868,760 -20.68% February 11,064,571 4,926,745 10,063,682 -9.05% March 15,921,618 4,857,047 14,793,075 -7.09% April 20,583,943 4,662,325 18,985,494 -7.77% May 25,612,342 5,028,399 23,497,459 -8.26% June 31,411,865 5,799,523 28,704,022 -8.62% July 36,363,006 4,951,141 33,359,621 -8.26% August 41,130,318 4,767,313 38,672,822 -5.97% September 46,432,507 5,302,189 43,450,297 -6.42% October 51,692,989 5,260,482 47,414,711 -8.28% November 57,566,174 5,873,185 December 63,970,754 6,404,580 City of Edmonds, WA Monthly Expenditure Report -Non -Departmental 2023 Non -Departmental Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 2,703,415 $ 2,703,415 $ 1,642,894 -39.23% February 4,120,779 1,417,364 3,380,586 -17.96% March 5,420,914 1,300,136 4,986,307 -8.02% April 6,544,202 1,123,288 6,091,521 -6.92% May 7,951,492 1,407,290 7,245,913 -8.87% June 10,036,224 2,084,733 9,392,113 -6.42% July 11,274,698 1,238,474 10,555,304 -6.38% August 12,335,881 1,061,182 12,600,704 2.15% September 13,768,928 1,433,047 13,727,753 -0.30% October 15,093,355 1,324,427 13,998,873 -7.25% November 16,728,866 1,635,512 December 18,488,589 1,759,723 Non -Departmental 20,000,000 18,000,000 16,000,000 14,000,000 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 le- 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -0-- Current Year Budget Prior Year *The monthly budget forecast columns are based on a five-year average. F O CL d w R C f4 C IL t r C O 2 M N O N L d E d O Z 10 Packet Pg. 49 I 2.1.b I City of Edmonds, WA Monthly Expenditure Report -City Council 2023 City Council Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 31,587 $ 31,587 $ 33,649 6.53% February 65,597 34,010 71,252 8.62% March 104,151 38,554 108,460 4.14% April 141,020 36,870 142,437 1.00% May 188,108 47,087 180,396 -4.10% June 237,876 49,768 208,152 -12.50% July 275,165 37,290 249,010 -9.51% August 325,994 50,829 283,971 -12.89% September 365,198 39,203 319,066 -12.63% October 398,695 33,497 348,675 -12.55% November 440,782 42,088 December 486,719 45,937 City of Edmonds, WA Monthly Expenditure Report -Office of Mayor 2023 Office of Mayor Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 41,345 $ 41,345 $ 32,343 -21.77% February 84,589 43,243 63,133 -25.37% March 126,357 41,768 101,671 -19.54% April 168,957 42,600 133,210 -21.16% May 210,634 41,677 164,114 -22.09% June 251,812 41,178 195,229 -22.47% July 293,809 41,997 229,429 -21.91% August 335,446 41,636 259,788 -22.55% September 377,299 41,854 290,606 -22.98% October 418,301 41,002 321,038 -23.25% November 461,679 43,378 December 505,239 43,560 *The monthly budget forecast columns are based on a five-year average. F O Q 4) !C C M C M L a+ C O 2 th 04 O N L d E tv O Z 11 Packet Pg. 50 1 I 2.1.b I City of Edmonds, WA Monthly Expenditure Report -Human Resources 2023 Human Resources Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 115,695 $ 115,695 $ 93,116 -19.52% February 219,840 104,145 164,590 -25.13% March 315,272 95,432 230,737 -26.81% April 415,812 100,540 296,057 -28.80% May 516,054 100,242 367,942 -28.70% June 651,834 135,780 455,291 -30.15% July 741,246 89,412 531,164 -28.34% August 839,112 97,865 605,627 -27.83% September 944,153 105,041 694,844 -26.41% October 1,042,607 98,454 774,485 -25.72% November 1,156,556 113,949 December 1,297,746 141,190 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 Municipal Court Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 135,694 $ 135,694 $ 114,975 -15.27% February 273,214 137,520 231,321 -15.33% March 414,829 141,615 352,625 -15.00% April 558,136 143,307 476,351 -14.65% May 711,840 153,704 611,186 -14.14% June 853,118 141,278 726,808 -14.81% July 997,788 144,670 855,668 -14.24% August 1,159,264 161,476 980,820 -15.39% September 1,307,192 147,929 1,097,393 -16.05% October 1,460,910 153,718 1,213,326 -16.95% November 1,645,269 184,359 December 1,827,709 182,440 Municipal Court 2,400,000 2,200,000 2,000,000 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. 12 Packet Pg. 51 I 2.1.b 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 $ 82,768 $ 82,768 $ 84,200 1.73% February 173,748 90,980 172,586 -0.67% March 267,297 93,549 263,059 -1.59% April 356,785 89,487 362,832 1.70% May 449,350 92,565 470,437 4.69% June 543,530 94,180 599,614 10.32% July 642,047 98,517 718,488 11.91% August 759,375 117,328 872,904 14.95% September 869,058 109,683 962,363 10.74% October 983,298 114,241 1,079,290 9.76% November 1,129,896 146,598 December 1,312,555 182,659 *The monthly budget forecast columns are based on a five-year average. F O Q d w t4 C IQ C_ LL t r C O M N O N L d E d O Z 13 Packet Pg. 52 1 I 2.1.b 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 $ 240,643 $ 240,643 $ 355,645 47.79% February 398,793 158,150 530,347 32.99% March 615,290 216,497 683,467 11.08% April 701,637 86,346 798,011 13.74% May 824,702 123,066 888,529 7.74% June 965,060 140,358 982,174 1.77% July 1,069,578 104,518 1,136,037 6.21% August 1,225,467 155,890 1,265,855 3.30% September 1,381,721 156,254 1,423,867 3.05% October 1,557,117 175,396 1,518,443 -2.48% November 1,672,249 115,132 December 1,943,624 271,375 Administrative Services Fund 512 - Technology Rental Fund 2,000,000 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 Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 265,902 $ 265,902 $ 253,437 -4.69% February 452,065 186,163 571,249 26.36% March 638,942 186,877 774,413 21.20% April 830,237 191,295 964,313 16.15% May 1,020,418 190,181 1,156,484 13.33% June 1,279,620 259,202 1,327,293 3.73% July 1,494,954 215,334 1,531,898 2.47% August 1,686,406 191,452 1,715,648 1.73% September 1,878,906 192,501 1,936,486 3.06% October 2,079,936 201,029 2,150,254 3.38% November 2,305,663 225,728 December 2,502,670 197,007 *The monthly budget forecast columns are based on a five-year average. 14 Packet Pg. 53 I 2.1.b 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 276,332 -28.64% May 484,075 96,815 347,909 -28.13% June 580,890 96,815 427,830 -26.35% July 677,705 96,815 534,282 -21.16% August 774,520 96,815 559,282 -27.79% September 871,335 96,815 704,483 -19.15% October 968,150 96,815 788,660 -18.54% 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 -Current Year Budget - Prior Year City of Edmonds, WA Monthly Expenditure Report -Police 2023 Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 1,151,199 $ 1,151,199 $ 1,041,369 -9.54% February 2,301,161 1,149,962 2,119,852 -7.88% March 3,503,278 1,202,117 3,173,554 -9.41% April 4,662,822 1,159,544 4,326,784 -7.21% May 5,864,448 1,201,626 5,521,298 -5.85% June 7,133,272 1,268,824 6,661,514 -6.61% July 8,339,111 1,205,839 7,971,401 -4.41% August 9,474,966 1,135,855 9,201,003 -2.89% September 10,670,868 1,195,902 10,558,632 -1.05% October 11,909,831 1,238,963 11,878,556 -0.26% November 13,362,651 1,452,820 December 14,826,373 1,463,722 *The monthly budget forecast columns are based on a five-year average. O Q !C C M C M L a+ C O 2 th N O N L d M E d O Z 15 Packet Pg. 54 I 2.1.b I City of Edmonds, WA Monthly Expenditure Report -Development Services 2023 Planning & Development Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 396,763 $ 396,763 $ 286,492 -27.79% February 814,630 417,867 595,086 -26.95% March 1,215,923 401,293 913,919 -24.84% April 1,639,139 423,216 1,265,403 -22.80% May 2,055,194 416,055 1,622,646 -21.05% June 2,468,896 413,702 1,934,311 -21.65% July 2,920,497 451,601 2,263,472 -22.50% August 3,344,297 423,800 2,566,672 -23.25% September 3,786,123 441,826 2,913,241 -23.05% October 4,225,508 439,384 3,191,421 -24.47% November 4,698,931 473,423 December 5,246,507 547,576 Parks & Recreation Planning & Development 5,500,000 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 Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 457,954 $ 457,954 $ 589,720 28.77% February 958,756 500,802 958,125 -0.07% March 1,459,648 500,892 1,386,849 -4.99% April 1,961,358 501,710 1,788,118 -8.83% May 2,474,286 512,928 2,229,794 -9.88% June 3,018,678 544,393 2,623,359 -13.10% July 3,614,241 595,562 3,206,401 -11.28% August 4,231,093 616,853 3,766,096 -10.99% September 4,895,252 664,159 4,346,603 -11.21% October 5,440,831 545,579 4,977,108 -8.52% November 5,997,773 556,942 December 6,575,662 577,889 *The monthly budget forecast columns are based on a five-year average. F O Q 4) !C C M C M L a+ C O 2 ch N O N L d M E d O Z 16 Packet Pg. 55 I 2.1.b 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 116,404 -72.61% May 531,250 106,250 35,246 -93.37% June 637,500 106,250 102,751 -83.88% July 743,750 106,250 128,411 -82.73% August 850,000 106,250 128,411 -84.89% September 956,250 106,250 229,858 -75.96% October 1,062,500 106,250 406,199 -61.77% November 1,168,750 106,250 December 1,275,000 106,250 City of Edmonds, WA Monthly Expenditure Report -Facilities Maintenance 2023 Facilities Maintenance Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ February March April May June July August September October November December 279,527 $ 638,903 1,011,874 1,367,475 1,690,876 1,957,047 2,280,286 2,699,956 3,185, 324 3,725,458 4,170,818 4,877,452 279,527 $ 359,376 372,971 355,601 323,401 266,171 323,239 419,669 485,369 540,133 445,360 706,634 335,018 935,298 1,264,752 1,451,697 1,803,967 2,002,414 2,209,753 2,409,557 2,642,907 3,067,071 19.85% 46.39% 24.99 % 6.16 % 6.69 % 2.32 % -3.09% -10.76% -17.03% -17.67% Facilities Maintenance 11500,000 1,000,000 - 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -CurrentYeaz Budget -dPriorYear *The monthly budget forecast columns are based on a five-year average. 17 Packet Pg. 56 I 2.1.b I City of Edmonds, WA Monthly Expenditure Report -Engineering 2023 Engineering Cumulative Monthly YTD Variance Budget Forecast Budget Forecast ActuaIs % January $ 283,132 $ 283,132 $ 261,418 -7.67% February 567,413 284,281 531,670 -6.30% March 856,666 289,253 807,168 -5.78% April 1,149,630 292,964 1,076,687 -6.34% May 1,470,075 320,445 1,353,969 -7.90% June 1,765,968 295,893 1,652,623 -6.42% July 2,074,354 308,386 1,918,939 -7.49% August 2,376,166 301,813 2,184,156 -8.08% September 2,668,549 292,382 2,479,814 -7.07% October 2,965,801 297,252 2,749,498 -7.29% November 3,290,206 324,405 December 3,615,509 325,303 Engine a ring 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 RUN JUL AUG SEP OCT NOV DEC -Current Yew Budget . Prior Year *The monthly budget forecast columns are based on a five-year average. F O Q O !C C M C M , L a+ C O 2 Cl) N O N L d M E d O Z 18 Packet Pg. 57 I 2.1.b I Page 1 of 1 CITY OF EDMONDS REVENUES BY FUND - SUMMARY Fund 2023 Amended 10/31/2022 10/31/2023 Amount No. Title Budget Revenues Revenues Remaining %Received 001 GENERAL FUND $ 52,558,830 $ 33,386,077 $ 41,665,078 $ 10,893,752 790/( 009 LEOFF-MEDICAL INS. RESERVE 225,000 112,500 112,500 112,500 500/( 011 RISK MANAGEMENT RESERVE FUND - - - - 00/( 012 CONTINGENCY RESERVE FUND 447,522 - 446,522 1,000 1000% 014 HISTORIC PRESERVATION GIFT FUND - - - - 00/, ,.., 016 BUILDING MAINTENANCE FUND 17,480 41,135 82,530 (65,050) 4720/( OQ 017 MARSH RESTORATION & PRESERVATION FUND - 1,150 3,829 (3,829) 00/, 018 EDMONDS HOMELESSNESS RESPONSE FUND 200,000 - - 00/( 019 EDMONDS OPIOID RESPONSE FUND - - - - 00/( .D C R 104 DRUG ENFORCEMENT FUND 167,650 1,325 1,837 165,813 10/, E 1L 111 STREET FUND 2,015,410 1,361,542 1,575,701 439,709 780/( 112 COMBINED STREET CONST/IMPROVE 12,366,800 3,084,444 7,314,540 5,052,260 590/c 117 MUNICIPAL ARTS ACQUIS. FUND 99,220 124,366 75,520 23,700 760/, 118 MEMORIAL STREET TREE - - - - 00/( ch N 120 HOTEL/MOTEL TAX REVENUE FUND 84,400 98,505 101,053 (16,653) 1200/, N 121 EMPLOYEE PARKING PERMIT FUND 38,960 14,276 15,271 23,689 L 390/( 122 YOUTH SCHOLARSHIP FUND 1,660 1,319 1,478 182 89% E d 123 TOURISM PROMOTIONAL FUND/ARTS 30,440 34,220 35,715 (5,275) 1170/, C 125 REAL ESTATE EXCISE TAX 2 2,320,090 1,577,004 1,250,365 1,069,725 540/( Z 126 REAL ESTATE EXCISE TAX 1 2,302,980 1,571,450 1,290,318 1,012,662 560/, C 127 GIFTSCATALOGFUND 232,490 2,997,671 200,656 31,834 860/( y 0' 130 CEMETERY MAINTENANCE/IMPROVEMT 150,960 187,737 175,353 (24,393) 1160/( is 136 PARKS TRUST FUND 5,460 3,011 (7,497) 12,957 1370/c 0 C 137 CEMETERY MAINTENANCE TRUST FD 51,500 38,145 47,121 4,379 91% C 138 SISTER CITY COMMISSION 10,430 2,794 3,044 7,386 290/, LL A 140 BUSINESS IMPROVEMENT DISTRICT 88,645 85,859 74,469 14,176 840/, t rr 141 AFFORDABLE AND SUPPORTIVE HOUSING FUND 65,000 58,039 56,401 8,599 870/( 0 O 142 EDMONDS RESCUE PLAN FUND 1,879,000 639,820 818,770 1,060,230 440/c eh 143 TREE FUND 215,100 215,784 5,827 209,273 30/( Np N 231 2012 LT GO DEBT SERVICE FUND 309,800 41,009 28,458 281,343 90/( 332 PARKS CAPITAL CONSTRUCTION FUND 2,713,902 1,766,892 2,073,474 640,428 760/( C 411 COMBINED UTILITY OPERATION - 133,095 120,420 (120,420) 0 00/( 0 421 WATER UTILITY FUND 11,950,114 8,994,184 9,552,932 2,397,182 800/( C 422 STORM UTILITY FUND 9,095,452 5,663,253 6,491,563 2,603,889 710/, 423 SEWER/WWTP UTILITY FUND 16,895,408 15,177,315 14,784,639 2,110,769 880/( v 424 BOND RESERVE FUND 1,991,860 595,668 589,501 1,402,359 300/c Q 511 EQUIPMENT RENTAL FUND 4,253,740 1,550,351 2,371,654 1,882,086 560/( 512 TECHNOLOGY RENTAL FUND 1,634,131 1,094,298 1,327,698 306,433 810/( $ 124,2199434 $ 8098549239 $ 9296869741 $ 319532,693 750% 19 Packet Pg. 58 I 2.1.b I Page 1 of 1 CITY OF EDMONDS EXPENDITURES BY FUND - SUMMARY Fund 2023 Amended 10/31/2022 10/31/2023 Amount No. Title Budget Expenditures Expenditures Remaining %Spent 001 GENERAL FUND $ 63,970,754 $ 38,757,457 $ 47,414,711 $ 16,556,043 740 009 LEOFF-MEDICAL INS. RESERVE 367,140 206,131 289,860 77,280 790/c Ol l RISK MANANGEMENT RESERVE FUND 25,000 25,000 - 1000/c 014 HISTORIC PRESERVATION GIFT FUND 5,900 - 5,900 00/c 016 BUILDING MAINTENANCE FUND 1,275,000 17,074 406,199 868,801 32% 017 MARSH RESTORATION & PRESERVATION FUND - - - - 00/c p Q 018 EDMONDS HOMELESSNESS RESPONSE FUND - - - 0% 019 EDMONDS OPIOID RESPONSE FUND - - - - 00/, 104 DRUG ENFORCEMENT FUND 45,800 6,291 32,485 13,315 710/c _ R III STREET FUND 2,746,179 1,788,042 2,211,925 534,254 810/c C LL 112 COMBINED STREET CONST/IMPROVE 11,273,695 2,876,530 6,715,649 4,558,046 600/c 117 MUNICIPAL ARTS ACQUIS. FUND 207,380 85,789 93,323 114,057 450/c w C 118 MEMORIAL STREET TREE - - - - 0% 120 HOTEL/MOTEL TAX REVENUE FUND 95,400 56,846 20,678 74,722 220/c ch N 121 EMPLOYEE PARKINGPERMIT FUND 26,880 740 825 26,055 30/c N 122 YOUTH SCHOLARSHIP FUND 3,000 322 (75) 3,075 -30/, 123 TOURISM PROMOTIONAL FUND/ARTS 28,500 8,233 11,950 16,550 420/c E d 125 REAL ESTATE EXCISE TAX 2 4,315,418 2,051,083 2,149,641 2,165,777 500/c C 126 REAL ESTATE EXCISE TAX 1 2,227,383 683,550 695,873 1,531,510 310/c Z 127 GIFT S CATALOG FUND 551,598 96,645 266,579 285,019 480/, C 130 CEMETERY MAINTENANCE/IMPROVEMT 291,530 169,088 221,642 69,888 760/c Q' d d' 136 PARKS TRUST FUND 216,062 2,687 161,439 54,623 750/c is 137 CEMETERY MAINTENANCE TRUST FUND 50,000 - - 50,000 0% 0 138 SISTER CITY COMMISSION 11,900 70 828 11,072 70/, C 140 BUSINESS IMPROVEMENT DISTRICT 88,575 52,104 59,804 28,771 680/, LL A 142 EDMONDS RESCUE PLAN FUND 1,879,000 689,835 1,302,140 576,860 690/, r 143 TREE FUND 239,800 - - 239,800 00/c 0 O 231 2012 LT GO DEBT SERVICE FUND 309,800 41,489 37,745 272,055 120/c M 332 PARKS CAPITAL CONSTRUCTION FUND 2,255,647 4,925,900 1,897,313 358,334 84% O N 421 WATER UTILITY FUND 11,949,308 5,667,596 8,102,317 3,846,991 680/c 422 STORM UTILITY FUND 8,525,900 5,340,606 4,227,799 4,298,101 500/c p 423 SEWER/WWTP UTILITY FUND 18,972,999 12,618,940 12,706,079 6,266,920 670/c O 424 BOND RESERVE FUND 1,989,820 589,342 574,892 1,414,928 290/, 511 EQUIPMENT RENTAL FUND 4,966,825 1,139,877 2,677,705 2,289,120 540/c E 512 TECHNOLOGY RENTAL FUND 1,943,624 1,217,201 1,518,443 425,181 780/c v R $ 140,855,817 $ 79,089,467 $ 93,822,768 $ 47,033,049 670% Q 20 Packet Pg. 59 2.1.b Page 1 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2023 Amended 10/31/2022 10/31/2023 Amount Title Budget Revenues Revenues Remaining %Received TAXES: 1 REAL PERSONAL / PROPERTY TAX 2 EMS PROPERTY TAX 3 VOTED PROPERTY TAX 4 LOCAL RETAIL SALES/USE TAX t 5 NATURAL GAS USE TAX 6 1/10 SALES TAX LOCAL CRIM JUST 7 ELECTRIC UTILITY TAX 8 GASUTILITYTAX 9 SOLID WASTE UTILITY TAX 10 WATERUTILITY TAX 11 SEWERUTILITYTAX 12 STORMWATER UTILITY TAX 13 T.V. CABLE UTILITY TAX 14 TELEPHONE UTILITY TAX 15 PULLTABS TAX 16 AMUSEMENT GAMES 17 LEASEHOLD EXCISE TAX LICENSES AND PERMITS: 18 FIRE PERMITS -SPECIAL USE 19 POLICE -FINGERPRINTING 20 VENDINGMACHINE/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 BUILDINGPERMITS 29 FIRE PERMIT 30 ENGINEERING PERMIT 31 ANIMAL LICENSES 32 STREET AND CURB PERMIT 33 STREET AND CURB PERMIT W/LEASEHOLD TAX 34 OT R NON -BUS LIC/PERMIT S 35 SPECIAL EVENT REVIEW INTERGOVERNMENTAL: 36 FEDERAL GRANTS - BUDGET ONLY 37 DOJ 15-0404-0-1-754 - BULLET PROOF VEST 38 WA SASSOC OF SHERIFFS TRAFFIC GRANT 39 HIGH VISIBILITY ENFORCEMENT 40 CORONAVIRUS RELIEF FUND 41 HOUSING TO INFRASTRUCTURE PROGRAM (CHIP) 42 STATE GRANTS- BUDGET ONLY 43 STATE GRANT FROM OTHER JUDICIAL AGENCIES 44 WA STATE TRAFFIC COMM GRANT 45 SCHOOL ZONE 46 GMA PERIODIC UPDATE GRANT - FY 2023 47 WASHINGTON SPATE ARTS COMMISSION 48 PUD PRIVILEDGE TAX 49 TRIAL COURT IMPROVEMENT 50 CJ - POPULATION 51 CRIMINAL JUSTICE -SPECIAL PROGRAMS 52 MARIJUANA EXCISE TAX DISTRIBUTION 53 DUI - CITIES 54 FIRE INS PREMIUM TAX 55 LIQUOR EXCISE TAX 56 LIQUOR BOARD PROFITS 57 MISCELLANEOUS INTERLOCAL REVENUE 58 FIRST RESPONDERS FLEX FUND 59 DISCOVERY PROGRAMS TECHNOLOGY ACQ. $ 11,327,000 $ 6,026,481 $ 9,911,687 $ 1,415,313 880N 4,578,000 2,400,332 3,975,579 602,421 870N 500 32 4 496 10N 11,900,000 7,600 1,150,000 1,900,000 845,000 384,000 1,000,234 942,960 621,458 850,000 773,000 80,200 350 326,000 36,686,302 250 700 94,500 702,700 41,000 100,600 450,000 250,000 80,000 30,000 750,600 24,000 75,000 20,000 2,619,355 166,309 9,000 11,100 1,494,875 1,361,011 244,645 161,004 34,000 210,500 16,740 13,070 50,600 125,000 4,500 325,000 343,200 1,000 550 9,300,633 17,012 854,048 1,466,267 641,329 311,692 777,290 720,312 502,253 618,225 374,814 65,493 230,321 24,306,533 300 170 74,631 523,616 26,679 35,890 291,170 196,327 85,335 30,173 658,881 13,085 80,379 25 17,715 2,034,375 9,602,316 11,732 869,563 1,396,068 741,293 337,883 835,975 846,310 521,503 682,707 353,086 57,733 41 236,302 30,379,783 50 680 78,889 691,132 24,399 40,079 331,302 202,632 90,420 13,962 253,029 7,600 81,360 13,962 21,244 6,750 16,267 726 1,874,483 5,237 - 992 31,313 1,190 14,748 71,185 79,960 307 2,000 214,277 16,163 14,744 52,278 80,089 4,913 56,744 303,313 249,557 13,780 279 1,337 62,500 3,000 219,274 16,015 15,545 54,864 80,348 2,974 75,698 301,353 246,463 500 658 2,297,684 (4,132) 280,437 503,932 103,707 46,117 164,259 96,650 99,955 167,293 419,914 22,467 309 89,698 6,306,519 200 20 15,611 11,568 16,601 60,521 118,698 47,368 (10,420) 16,038 497,571 (7,600) (81,360) 10,038 53,756 (6,750) 3,733 744,867 166,309 9,000 (31,313) (3,648) 1,414,915 1,361,011 244,645 161,004 (1,337) (62,500) 31,000 (8,774) 725 (2,475) (4,264) 44,652 1,526 (75,698) 23,647 96,737 (500) 342 550 60 AWC - SEEK FUND - 63,411 - - 4,572,104 1,150,459 1,206,550 3,365,554 2022 Local Retail Sales/Use Tax revenues are $301,683 higher than 2021 revenue& Please also see pagespages 5 & 6. 21 81% 154% 76% 73% 88% 88% O 84% y 90% 84% 80% _ 46% R 72% C 12% LL 72% t 83% O 20% 2 97% N 83 N 98% 60% 40% E 74% j 81% Z 113% 47% t 34% 0 CL 0% m 0% 58% !a 28% 0% _ 81 % li 0% 72 % t 0% 0% 0% 133% 5% 0% 0% 0% 0% 0% 0% 9% 104% 96% 119% 108% 64% 66% 0% 93% 720/ 0% 66% 0% 0% 26% Packet Pg. 60 1 2.1.b Page 2 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2023 Amended 10/31/2022 10/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 CURREXPEN 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 C.TTC TAC REIMBURSEMENT 20 MISCELLANEOUS POLICE SERVICES 21 FIRE DISTRICT #1 STATION BILLINGS 22 LEGAL SERVICES 23 ADULT PROBATION SERVICE CHARGE 24 BOOKING FEES 25 FIRE CONSTRUCTION INSPECTION FEES 26 EMERGENCY SERVICE FEES 27 EMS TRANSPORT USER FEE 28 FLEX FUEL PAYMENTS FROM STATIONS 29 ANIMAL CONTROL SHELTER 30 ZONING/SUBDIVISION FEE 31 BUILDING PLAN REVIEW AND INSPECTION 32 FIRE PLAN REVIEW 33 PLANNINGREVIEW AND INSPECTION 34 S.E.P.A. REVIEW 35 ENGINEERING PLAN REVIEW AND INSPECTION 36 CRITICAL AREA STUDY 37 GYM AND WEIGHTROOM FEES 38 PROGRAM FEES 39 HOLIDAY MARKET REGISTRATION FEES 40 UPTOWN EVENINGMARKET FEES 41 WINTER MARKET FEES 42 EDMONDS COMMUNITY FAIR FEES 43 BIRD FEST REGISTRATION FEES 44 INTERFUND REIMBURSEMENT -CONTRACT SVCS $ 3,000 $ 5,102 $ 1,884 $ 1,116 630/( 600 256 221 379 370% 6,000 441 120 5,880 20/( 150 1 - 150 00/( 300 - - 300 00/( 4,000 98 - 4,000 00/( 1,000 77 76 924 80% 50 163 306 (256) 6110/( 25,000 - - 25,000 00/( 100 81 49 51 490% 1,000 - - 1,000 00/( 190,000 206,883 34,921 155,079 180/( 1,400 2,885 - 1,400 00/( 100,000 68,373 49,796 50,204 5001( 5,000 3,958 43,356 (38,356) 8670% 30,000 17,188 14,793 15,207 490/( 14,000 3,169 1,684 12,316 120/( 210,970 158,227 227,425 (16,455) 1080/( - - 42,916 (42,916) 00/( - 25 20 (20) 00% 67,000 49,842 71,339 (4,339) 1060/( 1,050 702 - 1,050 00/( 38,000 16,736 8,712 29,288 230% 3,000 532 278 2,722 90/( 10,000 27,784 25,587 (15,587) 2560/( 3,500 1,083 710 2,790 200/( 1,077,500 764,912 958,737 118,763 890% 5,000 3,042 5,619 (619) 1120% - 100 400 (400) 00/( 65,600 81,403 16,819 48,781 260/( 425,000 384,068 730,388 (305,388) 1720% 4,000 15,700 19,736 (15,736) 4930/( 500 110 78,736 (78,236) 157470/( 3,000 4,715 3,852 (852) 1280/( - - 122,284 (122,284) 00/( 14,000 14,005 14,577 (577) 1040/( 13,000 2,299 6,572 6,428 5101( 990,959 566,576 720,001 270,958 730/( 5,000 10,875 12,580 (7,580) 2520% 5,000 4,690 - 5,000 00/( 5,000 7,430 9,005 (4,005) 1800/( - - 560 (560) 00/( 1,000 855 - 1,000 00/( 3,427,765 2,746,202 3,125,042 302,723 910/( 6,757,444 5,170,588 6,349,101 408,343 940% 22 Packet Pg. 61 2.1.b Page 3 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2023 Amended 10/31/2022 10/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 TRAFFIC CAMERA INFRACTIONS 5 CRT COST FEE CODE LEG ASSESSMENT (LGA) 6 CURRENT TRAFFIC INFRACTIONS 7 NON -TRAFFIC INFRACTION PENALTIES 8 OTHER INFRACTIONS'04 9 PARKING INFRACTION PENALTIES 10 PARKANDDISZONE 11 DWI PENALTIES 12 DUI - DP ACCT 13 CRIM CNV FEE DUI 14 DUI - DP FEE 15 CRIMINAL TRAFFIC MISDEMEANOR 8/03 16 CRIMINAL CONVICTION FEE CT 17 CRIM CONV FEE CT 18 OTHER NON-TRAF MISDEMEANOR PEN 19 OTHER NON TRAFFIC MISD. 8/03 20 COURT DV PENALTY ASSESSMENT 21 CRIMINAL CONVICTION FEE CN 22 CRIM CONV FEE CN 23 PUBLIC DEFENSE RECOUPMENT 24 BANK CHARGE FOR CONY. DEFENDANT 25 COURT COST RECOUPMENT 26 BUS. LICENSE PERMIT PENALTY 27 MISC FINES AND PENALTIES MISCELLANEOUS: 28 INVESTMENT INTEREST 29 INTEREST ON COUNTY TAXES 30 INTEREST - COURT COLLECTIONS 31 LOAN INTEREST 32 SPACE/FACILITIESRENTALS 33 BRACKET ROOM RENTAL 34 LEASESLONGTERM 35 DONATION/CONTRIBUTION 36 PARKSDONATIONS 37 BIRD FEST CONTRIBUTIONS 38 POLICE CONTRIBUTIONS FROM PRIV SOURCES 39 SALE OF JUNK/SALVAGE 40 SALES OF UNCLAIM PROPERTY 41 CONFISCATED AND FORFEITED PROPERTY 42 OTHERJUDGEMENT/SETTLEMENT 43 POLICE JUDGMENTS✓RESTITUTION 44 CASHIER'S OVERAGES/SHORTAGES 45 OTHER MISC REVENUES 46 SMALL OVERPAYMENT 47 NSF FEES - PARKS & REC 48 NSF FEES - MUNICIPAL COURT 49 NSF FEES - DEVEL SERV DEPT 50 L&I STAY AT WORK PROGRAM 51 US BANK REBATE TRANSFER IN: 52 INSURANCE RECOVERIES 53 INTERFUND TRANSFER FROM FUND 011 53 INTERFUND TRANSFER FROM FUND 136 52 TRANSFER FROM FUND 127 TO TAL GENERAL FUND REVENUE $ 2,000 $ 1,345 $ 1,647 $ 353 820/( 130,000 71,201 59,239 70,761 460% 18,000 3,412 1,287 16,713 70/( 50,000 - - 50,000 00/( 10,000 5,069 1,578 8,423 160/( - - 58,407 (58,407) 00% 1,000 - 5,386 (4,386) 5390% 1,500 842 1,840 (340) 1230/( 125,000 36,087 12,080 112,920 100% 2,000 614 742 1,258 370% 7,000 3,473 2,843 4,157 410/( 300 133 1 299 00/( 100 23 - 100 00/( 1,500 1,423 1,156 344 770/( 25,000 8,532 5,903 19,097 240/( 2,000 1,422 943 1,057 470/( 700 103 12 688 20/( 100 - 100 0 1000/( 12,000 14,699 241 11,759 20/( 800 34 100 700 130/( 1,000 326 91 909 90/( 200 - - 200 00/( 6,000 2,973 1,124 4,876 190/( 4,000 3,890 4,423 (423) 1110/( 1,000 470 1,203 (203) 1200/( 1,000 188 - 1,000 00/( 150 - - 150 00/( 402,350 156,258 160,345 242,005 40% 321,240 202,957 144,473 176,767 450/( 10,960 10,143 58,508 (47,548) 5340/( 12,180 4,017 2,108 10,072 170/( 12,080 - - 12,080 00/( 175,000 134,229 158,876 16,124 910/( 2,100 - - 2,100 00/( 210,000 171,845 188,585 21,415 900/( 1,500 1,276 1,105 395 740/( 3,500 5,050 16,500 (13,000) 4710/( 1,500 2,070 2,057 (557) 1370/( 5,000 249 100 4,900 20/( 300 398 7,551 (7,251) 25170/( 3,800 3,810 3,243 557 850/( 2,000 - - 2,000 00/( 146,000 - 74,119 71,881 5101( 200 315 87 113 440/( - 734 28 (28) 00/( 5,000 2,296 106,995 (101,995) 21400/( 100 47 1 99 10/( 100 30 30 70 300/( 150 120 240 (90) 1600/( - 60 34 (34) 00/( - 6,527 8,702 (8,702) 00/( 8,500 8,541 10,597 (2,097) 1250/( 921,210 554,715 783,938 137,272 850/( 500,000 813,814 (313,814) 1630/( 25,000 25,000 - 1000/( 75,070 - 72,066 3,004 960/( - 13,150 - - 00% 600,070 13,150 910,879 (310,809) 1520% $ 52,558,830 $ 33,386,077 $ 41,665,078 $ 10,893,752 790% 23 Packet Pg. 62 I 2.1.b I Page 1 of 6 C PTY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Amended 10/31/2022 10/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent GENERAL FUND EXPENDITURES (001) 1 SALARIES AND WAGES $ 23,174,368 $ 14,663,067 $ 17,963,743 $ 5,210,625 780/( 2 OVERTIME 649,080 906,200 837,268 (188,188) 1290/( 3 HOLIDAY BUY BACK 294,001 15,727 13,432 280,569 501( 4 BENEFITS 7,959,238 5,398,171 6,376,492 1,582,746 800/( 5 UNIFORMS 130,851 76,776 132,939 (2,088) 1020/( 6 PENSION AND DISABILITY PAYMENTS 165,023 71,274 64,189 100,834 390/( 7 SUPPLIES 770,473 374,559 473,842 296,631 620/( 8 SMALL EQUIPMENT 307,791 181,098 249,693 58,098 810/( 9 PROFESSIONAL SERVICES 21,173,217 12,439,921 14,457,322 6,715,895 680/( 10 COMMUNICATIONS 241,295 133,899 199,561 41,734 830/( 11 TRAVEL 86,242 45,838 90,597 (4,355) 10501( 12 EXCISE TAXES 16,500 25,470 24,191 (7,691) 1470/( 13 RENTALILEASE 2,869,548 1,667,150 2,313,514 556,034 810/( 14INSURANCE 625,650 503,160 625,650 (0) 1000/( 15 UTILITIES 663,800 484,411 581,029 82,771 880/( 16 REPAIRS & MAINTENANCE 673,900 435,305 642,493 31,407 950/( 17 MISCELLANEOUS 673,640 455,749 551,789 121,851 820/( 18 INTERGOVERNMENTAL PAYMENTS 50,000 50,000 50,000 - 1000/( 19 INTERFUND SUBSIDIES 1,341,982 542,500 986,522 355,460 740/( 20 BUILDINGS 500,000 81,116 285,637 214,363 570/( 21 MACHINERY/EQUIPMENT 430,000 133,561 371,440 58,561 860/( 22 CONST RUCT IONS PROJECTS 800,565 - 57,634 742,931 70/( 23 PRINCIPAL PAYMENT LEASES 50,000 - 50,000 00/( 24 GENERAL OBLIGATION BOND PRINCIPAL 191,620 - - 191,620 00/( 25 INTEREST ON LONG-TERM EXTERNAL DEBT 131,470 72,294 65,733 65,737 500% 26 OTHER INTEREST & DEBT SERVICE COSTS 500 212 - 500 00/( 33,970,754 38,757,457 47,414,711 16,556,043 7 LEOFF-MEDICAL INS. RESERVE(009) 27 BENEFITS $ 206,650 $ 122,229 $ 131,051 $ 75,599 630/( 28 PENSION AND DISABILITY PAYMENTS 152,990 69,712 139,809 13,181 910/( 29 PROFESSIONAL SERVICES 7,000 13,704 19,000 (12,000) 2710/( 30 MISCELLANEOUS 500 485 - 500 00/( 367,140 206,131 289,860 77,280 79% RISK MANAGEMENT RESERVE FUND (011) 31 INTERFUND SUBSIDIES $ 25,000 $ - $ 25,000 $ - 1000% 25,000 25,000 - 1000/( HISTORIC PRESERVATION GIFTFUND (014) 32 SUPPLIES $ 100 $ $ - $ 100 00/( 33 PROFESSIONAL SERVICES 200 200 00/( 34 MISCELLANEOUS 5,600 5,600 00% 5,900 5,900 00/( BUILDING MAINTENANCEFUND (016) 35 PROFESSIONAL SERVICES $ 121,500 $ 450 $ 703 $ 120,797 10/( 36 REPAIR&MAINTENANCE 1,153,500 16,072 109,782 1,043,718 100/( 37 BUILDINGS - - 127,182 (127,182) 00/( 38 MACHINERY/EQUIPMENT 552 - 00/( 39 CONS TRUCTIONS PROJECTS - - 168,532 (168,532) 00/( 1,275,000 17,074 406,199 868,801 320% DRUG ENFORCEMENTFUND (104) 40 SMALL EQUIPMENT $ - $ - $ 32,485 $ (32,485) 00/( 41 PROFESSIONAL SERVICES 45,000 - 45,000 00/( 42 REPAIR/MAINT 800 - 800 00/( 43 MACHINERY/EQUIPMENT - 6,291 - - 00/( $ 45,800 6,291 32,485 13,315 71% O CL O w M C R C LL t C O 2 ch N O N E d O Z 24 Packet Pg. 63 I 2.1.b I Page 2 of 6 C TTY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Amended 10/31/2022 10/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent SMEET' FUND (111) 1 SALARIES AND WAGES $ 1,154,552 $ 575,583 $ 863,754 $ 290,798 750/( 2 OVERTIME 38,400 30,960 29,541 8,859 770% 3 BENEFITS 440,911 282,152 357,506 83,405 810/( 4 UNIFORMS 6,000 4,341 4,404 1,596 730/( 5 SUPPLIES 263,000 193,663 162,556 100,444 620/( 6 SMALL EQUIPMENT 20,000 1,517 6,250 13,750 310/( 7 PROFESSIONAL SERVICES 23,210 16,803 11,470 11,740 490% 8 COMMUNICATIONS 4,500 5,549 5,549 (1,049) 1230/( 9 TRAVEL 1,000 - - 1,000 00/( 10 RENTAL/LEASE 304,730 242,671 255,096 49,634 840/( 11 INSURANCE 126,466 184,111 126,467 (1) 1000% 12 UTILITIES 273,730 196,653 203,784 69,946 740/( 13 REPAIRS & MAINTENANCE 52,000 28,783 13,406 38,594 260/( 14 MISCELLANEOUS 8,000 3,692 6,642 1,358 830/( 15 BUILDINGS 25,000 - - 25,000 00/( 16 OTHERIMPROVEMENTS - - 165,353 (165,353) 00% 17 MACHINERY/EQUIPMENT - 21,382 - - 00/( 18 GENERAL OBLIGATION BOND PRINCIPAL 4,380 - - 4,380 00/( 19 INTEREST 300 185 149 151 5001( $ 2,746,179 $ 1,788,042 $ 2,211,925 $ 534,254 817% COMBINED STREErCONST/IMPROVE(112) 20 PROFESSIONAL SERVICES $ 3,817,980 $ 1,038,565 $ 1,579,055 $ 2,238,925 410/( 21 REPAIRS& MAINTENANCE 1,139,535 1,433 1,074,099 65,436 940/( 22 INTERFUND SUBSIDIES 172,650 - 21,388 151,262 120% 23 LAND 270,000 72,782 - 270,000 00/( 24 CONSTRUCTION PROJECTS 5,818,580 1,690,318 3,986,178 1,832,402 690/( 25 INTERGOVERNMENTAL LOANS 54,070 72,201 54,058 12 1000/( 26 INTEREST 880 1,230 869 11 990/( $ 11,273,695 $ 2,876,530 $ 6,715,649 $ 4,558,046 600% MUNIC IPAL ARTS AC Q UIS. FUND (117) 27 SUPPLIES $ 4,700 $ 966 $ 1,497 $ 3,203 320/( 28 SMALL EQUIPMENT 1,700 - - 1,700 00/( 29 PROFESSIONAL SERVICES 191,000 82,204 86,635 104,365 450/( 30 TRAVEL 80 - - 80 00/( 31 RENTAL/LEASE 3,000 32 2,968 10/( 32 REPAIRS & MAINTENANCE 300 - - 300 00/( 33 MISCELLANEOUS 6,600 2,619 5,160 1,440 780/( $ 207,380 $ 85,789 $ 93,323 $ 114,057 450% HO TE UMO TEL TAX REVENUE FUND (120) 34 PROFESSIONAL SERVICES $ 90,400 $ 54,846 $ 18,678 $ 71,722 210/( 35 MISCELLANEOUS 1,000 - - 1,000 00/( 36 INTERFUND SUBSIDIES 4,000 2,000 2,000 2,000 5001( $ 95,400 $ 56,846 $ 20,678 $ 74,722 220/( EMPLOYEEPARKING PERMIT FUND (121) 37 SUPPLIES $ 1,790 $ 740 $ 825 $ 965 460/( 38 PROFESSIONAL SERVICES 25,090 - - 25,090 00/( $ 26,880 $ 740 $ 825 $ 26,055 30/( YOUTH SCHOLARSHIP FUND (122) 39 SUPPLIES $ - $ 322 $ - $ - 00/( 40 MISCELLANEOUS 3,000 - (75) 3,075 -30% $ 3,000 $ 322 $ (75) $ 3,075 -30% TO URIS M PRO MO TIO NAL FUND/ARTS (123) 41 PROFESSIONAL SERVICES $ 28,500 $ 8,233 $ 11,950 $ 16,550 420% $ 28,500 $ 8,233 $ 11,950 $ 16,550 420/( 25 Packet Pg. 64 I 2.1.b I Page 3 of 6 C TTY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Amended 10/31/2022 10/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent REAL ESTATE EXCISETAX 2 (125) 1 SUPPLIES $ - $ 16,925 $ $ - 00/( 2 PROFESSIONAL SERVICES 616,867 730,570 398,035 218,832 650/( 3 REPAIRS& MAINTENANCE 1,148,910 157,632 503,812 645,098 440% 4 INTERFUND SUBSIDIES 5,684 - - 5,684 00/( 5 LAND 200,000 - 77,753 122,247 390N 6 CONSTRUCTION PROJECTS 2,343,957 1,145,956 1,170,041 1,173,916 5001( $ 4,315,418 $ 2,051,083 $ 2,149,641 $ 2,165,777 5001( 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 14 OTHER INTEREST & DEBT SERVICE COSTS GIFTS CATALOG FUND (127) 15 SALARIES AND WAGES 16 OVERTIME 17 BENEFIT S 18 SUPPLIES 19 SMALL EQUIPMENT 20 PROFESSIONAL SERVICES 21 RENTAL/LEASE 22 MISCELLANEOUS 23 INTERFUND SUBSIDIES C EMEYERY MAINTENANC UIMPRO VEVI ENT (130) 24 SALARIES AND WAGES 25 OVERTIME 26 BENEFIT S 27 UNIFORMS 28 SUPPLIES 29 SUPPLIES PURCHASED FOR INVENTORY/RESALE 30 PROFESSIONAL SERVICES 31 COMMUNICATIONS 32 TRAVEL 33 RENTAL/LEASE 34 UTILITIES 35 REPAIRS & MAINTENANCE 36 MISCELLANEOUS PARKS TRUSTFUND (136) 37 PROFESSIONAL SERVICES 38 INTERFUND SUBSIDIES CEMETERY MAINTENANCE TRUST FUND (137) 39 SMALL EQUIPMENT SISTER CITY COMMISSION (138) 40 SUPPLIES 41 TRAVEL 42 MISCELLANEOUS BUSINESS IMPROVEVIEVTDISTRICTFUND (140) 43 SUPPLIES 44 PROFESSIONAL SERVICES 45 MISCELLANEOUS EDMONDS RESCUEPLAN FUND (142) 46 PROFESSIONAL SERVICES TREE FUND (143) 47 SUPPLIES 48 PROFESSIONAL SERVICES 49 LAND $ 292,065 $ 500,537 $ 305,797 $ (13,732) 1050% 578,340 16,897 186,028 392,312 320X 148,575 10,138 - 148,575 00/( 100,000 - 100,000 - 1000/( 848,963 99,685 51,365 797,598 60X 155,470 - - 155,470 00/( 103,970 55,314 51,982 51,988 5001( - 980 700 (700) 00N $ 2,227,383 $ 683,550 $ 695,873 $ 1,531,510 310/( $ 241,455 $ $ 141,907 $ 99,548 590/( - 5,791 (5,791) 00/( 89,033 61,259 27,774 690% 146,000 83,495 42,683 103,317 290% 500 - - 500 00/( 56,500 - 56,500 00/( 17,510 14,592 2,918 830/( 600 - 348 252 580/( - 13,150 - - 00/( $ 551,598 $ 96,645 $ 266,579 $ 285,019 480% $ 172,817 $ 89,063 $ 117,558 $ 55,259 680% 3,500 832 2,233 1,267 640N 61,328 33,159 46,668 14,660 760% 1,000 - - 1,000 00/( 7,000 2,792 4,617 2,383 660/( 20,000 19,401 22,385 (2,385) 1120/( 4,200 1,150 3,248 952 770/( 1,700 1,436 1,440 261 850/( 500 - - 500 00/( 9,420 9,823 7,949 1,471 840/( 5,565 3,915 7,172 (1,607) 1290/( 500 3,536 - 500 00/( 4,000 3,981 8,372 (4,372) 2090/( $ 291,530 $ 169,088 $ 221,642 $ 69,888 760% $ 43,842 $ 2,687 $ - $ 43,842 00/( 172,220 - 161,439 10,781 940/( $ 216,062 $ 2,687 $ 161,439 $ 54,623 750% $ 50,000 $ $ $ 50,000 00N $ 50,000 $ $ $ 50,000 00N $ 1,500 $ $ 173 $ 1,327 120/( 4,500 - 4,500 00/( 5,900 70 655 5,245 11% $ 11,900 $ 70 $ 828 $ 11,072 70N $ 4,091 $ 6,232 $ 13,045 $ (8,954) 3190/( 78,327 44,294 44,916 33,411 570% 6,157 1,578 1,843 4,314 300% 88,575 52,104 59,804 28,771 680/( $ 1,879,000 $ 689,835 $ 1,302,140 $ 576,860 690/( 1,879,000 689,835 1,302,140 576,860 690/( 1,000 $ $ $ 1,000 00/( 39,800 39,800 00/( 199,000 199,000 0% O O 0 U C R C LL t C O 2 ch N O N d E d O Z Packet Pg. 65 1 I 2.1.b I Page 4 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Amended 10/31/2022 10/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent 2012 LTGO DEBTSERVIC FUND (231) 1 GENERAL OBLIGATION BOND $ 235,000 $ - $ - $ 235,000 09 2 INTEREST 74,800 41,009 37,395 37,405 509 3 OTHER INTEREST & DEBT SERVICE COSTS - 481 350 (350) 09 $ 309,800 $ 41,489 $ 37,745 $ 272,055 129 PARKS CONSTRUCTION FUND (332) 4 INTERFUND SUBSIDIES 5 PROFESSIONAL SERVICES 6 CONSTRUCTION PROJECTS 7 GENERAL OBLIGATION BONDS 8 INTEREST WATER FUND (421) 9 SALARIES AND WAGES 10 OVERTIME 11 BENEFIT S 12 UNIFORMS 13 SUPPLIES 14 WATER PURCHASED FOR RESALE 15 SUPPLIES PURCHASED FOR INVENTORY/RESALE 16 SMALL EQUIPMENT 17 PROFESSIONAL SERVICES 18 COMMUNICATIONS 19 TRAVEL 20 EXCISE TAXES 21 RENTAL/LEASE 22 INSURANCE 23 UTILITIES 24 REPAIRS& MAINTENANCE 25 MISCELLANEOUS 26 INTERFUND SUBSIDIES 27 BUILDINGS 28 MACHINERY/EQUIPMENT 29 CONSTRUCTION PROJECTS 30 GENERAL OBLIGATION BONDS 31 REVENUE BONDS 32 INTERGOVERNMENTAL LOANS 33 INTEREST 34 OTHER INTEREST & DEBT SERVICE COSTS S TO RM FUND (422) 35 SALARIES AND WAGES 36 OVERTIME 37 BENEFITS 38 UNIFORMS 39 SUPPLIES 40 SMALL EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATIONS 43 TRAVEL 44 EXCISE TAXES 45 RENTAL/LEASE 46 INSURANCE 47 UTILITES 48 REPAIR & MAINTENANCE 49 MISCELLANEOUS 50 INTERFUND SUBSIDIES 51 LAND 52 BUILDINGS 53 MACHINERY/EQUIPMENT 54 CONSTRUCTION PROJECTS 55 GENERAL OBLIGATION BONDS 56 REVENUE BONDS 57 INTERGOVERNMENTAL LOANS 58 INTEREST 59 OTHER INTEREST & DEBT SERVICE COSTS $ - $ 62,656 $ 675,000 $ (675,000) 09 1,352,620 804,535 141,867 1,210,753 109 805,377 4,032,650 1,056,621 (251,244) 1310 50,000 - - 50,000 09 47,650 26,059 23,825 23,825 509 0 $ 2,255,647 $ 4,925,900 $ 1,897,313 $ 358,334 849 0 $ 1,205,783 $ 619,075 $ 819,050 $ 386,733 689 !a 24,000 13,628 17,184 6,816 729 440,577 265,084 329,392 111,185 759 4,000 3,345 3,952 48 999 LL 150,000 114,924 113,217 36,783 759 2,398,000 1,655,358 1,762,088 635,912 739 t 180,000 136,806 131,943 48,057 739 13,500 3,796 7,363 6,137 559 O 2,256,928 765,711 1,191,786 1,065,142 539 2 35,000 26,602 29,903 5,097 859 N 200 - 462 (262) 2319 C 04 1,696,934 1,184,793 1,278,998 417,936 759 202,496 125,117 162,692 39,804 809 225,380 122,359 225,379 1 1009 E 35,000 25,353 26,213 8,787 759 71,130 24,249 59,144 11,986 8M O 123,600 158,096 212,808 (89,208) 1729 Z 646,370 194,533 189,888 456,482 299 t 12,500 - - 12,500 09 O 10,000 10,044 5,943 4,057 590 d 1,670,000 87,212 1,415,860 254,140 859 2,940 - - 2,940 09 333,830 - - 333,830 09 'v 25,840 25,839 25,839 1 1009 185,300 104,805 92,769 92,531 509 C - 868 444 (444) 09 IL $ 11,949,308 $ 5,667,596 $ 8,102,317 $ 3,846,991 689 A $ 1,113,757 $ 628,363 $ 875,198 $ 238,559 799 26,000 11,044 9,957 16,043 389 398,973 262,722 314,961 84,012 799 6,500 6,040 5,433 1,067 849 46,000 42,227 24,661 21,339 549 4,000 985 1,713 2,287 4M 3,143,445 2,796,760 1,290,810 1,852,635 419 3,200 4,895 5,922 (2,722) 1859 4,300 1,982 - 4,300 09 499,658 584,110 606,877 (107,219) 1219 307,168 218,877 249,431 57,737 819 31,679 82,335 31,680 (1) 1009 10,500 11,579 12,282 (1,782) 1179 189,130 13,456 108,027 81,103 579 232,300 192,675 201,198 31,102 879 283,341 75,745 72,689 210,652 269 680,000 - - 680,000 09 25,000 - - 25,000 09 56,474 - 12,536 43,938 229 1,031,645 282,979 287,412 744,233 289 107,290 - - 107,290 09 160,870 - - 160,870 09 61,600 61,590 61,590 10 1009 103,070 61,859 55,231 47,839 549 - 383 193 (193) 09 $ 8,525,900 $ 5,340,606 $ 4,227,799 $ 4,298,101 509 27 Packet Pg. 66 I 2.1.b I Page 5 of 6 C TTY O F EDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Amended 10/31/2022 10/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent SEWER FUND (423) 1 SALARIES AND WAGES $ 3,159,792 $ 1,510,216 $ 2,467,711 $ 692,081 789 2 OVERTIME 130,000 104,413 132,456 (2,456) 1029 3 BENEFITS 1,043,665 603,878 887,004 156,661 859 4 UNIFORMS 11,500 9,351 9,365 2,135 819 5 SUPPLIES 453,000 237,986 349,277 103,723 779 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 115,019 8,735 75,165 109 9 PROFESSIONAL SERVICES 2,587,949 1,983,724 2,114,456 473,493 829 10 COMMUNICATIONS 48,000 37,377 40,896 7,104 859 11 TRAVEL 5,000 495 (111) 5,111 -29 12 EXCISE TAXES 1,026,360 907,781 1,037,867 (11,507) 1019 13 RENTAL/LEASE 344,978 264,247 277,887 67,091 819 14 INSURANCE 360,663 203,936 364,070 (3,407) 1019 15 UTILITIES 3,607,060 2,100,718 2,766,501 840,559 779 16 REPAIR&MAINTENANCE 728,630 742,190 464,722 263,908 649 17 MISCELLANEOUS 138,350 202,277 302,934 (164,584) 2199 18 INTERFUND SUBSIDIES 1,588,089 1,175,403 432,735 1,155,354 279 19 BUILDINGS 12,500 - - 12,500 09 20 MACHINERY/EQUIPMENT - 68,126 - - 09 21 CONSTRUCTION PROJECTS 2,976,163 1,989,039 763,225 2,212,938 269 22 GENERAL OBLIGATION BONDS 129,820 - - 129,820 09 23 REVENUE BONDS 55,310 - - 55,310 09 24 INTERGOVERNMENTAL LOANS 104,000 174,591 103,986 14 1009 25 INTEREST 353,270 182,515 177,781 175,489 509 26 OTHER INT EREST & DEBT SERVICE COSTS - 5,657 4,582 (4,582) 09 $ 18,972,999 $ 12,618,940 $ 12,706,079 $ 6,266,920 679 BOND RESERVE FUND (424) 27 REVENUE BONDS $ 840,010 $ - $ - $ 840,010 09 28 INTEREST 1,149,810 589,342 574,892 574,918 509 $ 1,989,820 $ 589,342 $ 574,892 $ 1,414,928 299 F O C R C LL t C O 2 Cl) N O N L d E d O Z 28 Packet Pg. 67 2.1.b Page 6 of 6 C ITY O F IDMO NDS EXPENDITURES BY FUND - DETAIL 2023 Amended 10/31/2022 10/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent EQ UIPMENT RENTAL FUND (511) 1 SALARIES AND WAGES $ 395,171 $ 226,611 $ 320,343 $ 74,828 819 2 OVERTIME 2,000 2,598 2,619 (619) 1319 3 BENEFITS 132,345 80,046 105,615 26,730 809 4 UNIFORMS 1,500 1,006 1,871 (371) 1259 5 SUPPLIES 149,120 75,991 101,211 47,909 689 6 FUEL CONSUMED 1,000 - - 1,000 09 7 SUPPLIES PURCHASED FOR INVENTORY/RESALE 458,880 309,121 249,623 209,257 549 8 SMALL EQUIPMENT 58,000 3,264 8,104 49,896 149 9 PROFESSIONAL SERVICES 46,750 1,208 1,214 45,536 39 10 COMMUNICATIONS 3,000 1,771 2,774 226 929 11 TRAVEL 1,000 - 1,870 (870) 1879 12 RENTAL/LEASE 17,470 8,676 13,962 3,508 809 13 INSURANCE 50,178 51,903 52,373 (2,195) 1049 14 UTILITIES 14,000 14,762 16,679 (2,679) 1199 15 REPAIRS& MAINTENANCE 60,000 65,270 49,129 10,871 829 16 MISCELLANEOUS 12,000 7,150 9,297 2,703 779 17 MACHINERY/EQUIPMENT 3,564,411 290,501 1,741,019 1,823,392 499 $ 4,966,825 $ 1,139,877 $ 2,677,705 $ 2,289,120 549 TECHNOLOGY RENTAL FUND (512) 18 SALARIES AND WAGES $ 657,771 $ 280,464 $ 476,454 $ 181,317 729 19 OVERTIME 2,000 1,286 270 1,730 IM 20 BENEFITS 191,954 105,394 171,071 20,883 899 21 SUPPLIES 5,000 6,110 6,164 (1,164) 12M 22 SMALL EQUIPMENT 181,800 59,900 109,970 71,830 609 23 PROFESSIONAL SERVICES 61,860 32,054 38,180 23,680 629 24 COMMUNICATIONS 58,770 55,392 61,408 (2,638) 1049 25 TRAVEL 1,500 296 - 1,500 09 26 RENTAL/LEASE 4,640 3,717 1,367 3,273 299 27 REPAIRS& MAINTENANCE 666,729 417,117 630,201 36,528 959 28 MISCELLANEOUS 55,600 3,583 10,298 45,302 199 29 MACHINERY/EQUIPMENT 56,000 251,887 13,060 42,940 2M $ 1,943,624 $ 1,217,201 $ 1,518,443 $ 425,181 789 TOTAL EXPENDITURE ALL FUNDS $ 140,855,817 $ 79,089,467 $ 93,822,768 $ 47,033,049 679 F O C R C LL t C O 2 ch N O N L d E d O Z 29 Packet Pg. 68 2.1.b Page 1 of 1 CITY OF EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN SUMMARY 2023 Amended 10/31/2022 10/31/2023 Amount Title Budget Expenditures Expenditures Remaining % Spent CITY COUNCIL OFFICE OF MAYOR HUMAN RESOURCES MUNICIPAL COURT ADMINISTRATIVE SERVICES CITY ATTORNEY NON -DEPART MENTAL POLICE SERVICES SATELLITE OFFICE COMMUNITY SERVICES/ECONOMIC DEV PLANNING& DEVELOPMENT HUMAN SERVICES PROGRAM PARKS & RECREATION PUBLIC WORKS FACILITIES MAINTENANCE $ 486,719 $ 278,828 $ 348,675 $ 138,044 72% 505,239 297,281 321,038 184,201 64% 1,297,746 760,678 774,485 523,261 60% 1,827,709 1,009,961 1,213,326 614,384 66% 2,502,670 1,768,741 2,150,254 352,416 86% Q 1,161,780 788,707 788,660 373,120 68% O 18,488,589 11,393,678 13,998,873 4,489,716 7U70 v C 14,826,373 10,432,886 11,878,556 2,947,817 80% 230,681 72,086 106,830 123,851 46% LL 1,312,555 518,930 1,079,290 233,265 82% 5,246,507 3,009,709 3,191,421 2,055,086 61% O 347,982 126,868 213,410 134,572 61% N 6,575,662 3,830,200 4,977,108 1,598,554 76% 0 i 4,283,090 2,558,833 3,305,713 977,377 77% d 0 4,877,452 1,910,071 3,067,071 1,810,381 63% > O $ 63,970,754 $ 38,757,457 $ 47,414,711 $ 16,556,043 74% Z C ITY O F EDMO NDS EXPENDITURES - UTILITY- BY FUND IN SUMMARY Title 2023 Amended Budget 10/31/2022 Expenditures 10/31/2023 Expenditures Amount Remaining %Spent WATER UTILITYFUND $ 11,949,308 $ 5,667,596 $ 8,102,317 $ 3,846,991 68% STORM UTILITY FUND 8,525,900 5,340,606 4,227,799 4,298,101 50% SEWER/WWTP UTILITY FUND 18,972,999 12,618,940 12,706,079 6,266,920 67% BOND RESERVE FUND 1,989,820 589,342 574,892 1,414,928 29% $ 41,438,027 $ 24,216,483 $ 25,611,088 $ 15,826,939 62% 30 Packet Pg. 69 I 2.1.b I Page 1 of 2 C ITY O F FAMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL Title 2023 Amended Budget 10/31/2022 Expenditures 10/31/2023 Expenditures Amount Remaining %Spent C TFY C O UNC IL SALARIES AND WAGES $ 219,276 $ 156,583 $ 182,183 $ 37,093 83% BENEFITS 103,845 77,754 84,276 19,569 81% SUPPLIES 11,000 2,071 1,758 9,242 16% SERVICES 152,598 42,420 80,457 72,141 53% $ 486,719 $ 278,828 $ 348,675 $ 138,044 72% OFFICEOFMAYOR SALARIES AND WAGES $ 282,988 $ 207,124 $ 216,346 $ 66,642 76% BENEFITS 90,087 71,118 74,168 15,919 82% SUPPLIES 1,500 1,765 1,157 343 77% SERVICES 130,664 17,275 29,368 101,296 22% $ 505,239 $ 297,281 $ 321,038 $ 184,201 64% HUMAN RESOURCES SALARIES AND WAGES $ 782,258 $ 399,039 $ 433,930 $ 348,328 55% BENEFITS 243,609 132,135 161,241 82,368 66% SUPPLIES 13,600 1,268 3,526 10,074 26% SERVICES 258,279 228,235 175,788 82,491 68% $ 1,297,746 $ 760,678 $ 774,485 $ 523,261 60% MUNIC IPAL C O URT SALARIES AND WAGES $ 1,234,740 $ 645,909 $ 806,966 $ 427,774 65% BENEFITS 345,764 202,090 248,189 97,575 72% SUPPLIES 23,048 7,763 8,802 14,246 38% SERVICES 224,157 154,200 149,369 74,788 67% $ 1,827,709 $ 1,009,961 $ 1,213,326 $ 614,384 66% ADMINIS TRATIVE S ERVIC ES SALARIES AND WAGES $ 1,601,894 $ 1,080,698 $ 1,386,325 $ 215,569 87% BENEFITS 465,703 337,212 400,831 64,872 86% SUPPLIES 13,000 8,882 8,019 4,981 62% SERVICES 422,073 341,948 355,078 66,995 84% $ 2,502,670 $ 1,768,741 $ 2,150,254 $ 352,416 86% C 1TY ATTORNEY SERVICES $ 1,161,780 $ 788,707 $ 788,660 $ 373,120 68% $ 1,161,780 $ 788,707 $ 788,660 $ 373,120 68% NON -DEPARTMENTAL SALARIES AND WAGES $ 101,750 $ - $ - $ 101,750 0% BENEFITS 239,583 102,592 95,020 144,563 40% SUPPLIES 5,000 - - 5,000 0% SERVICES 16,426,684 10,626,081 12,801,598 3,625,086 78% INTERFUND SUBSIDIES 1,391,982 592,500 1,036,522 355,460 74% DEBT SERVICE - PRINCIPAL 191,620 - - 191,620 0% DEBT SERVICE - INTEREST 131,970 72,505 65,733 66,237 50% $ 18,488,589 $ 11,393,678 $ 13,998,873 $ 4,489,716 76% PO LIC E SE RVIC ES SALARIES AND WAGES $ 9,366,760 $ 6,683,170 $ 7,408,261 $ 1,958,499 79% BENEFITS 3,280,628 2,340,647 2,605,665 674,963 79% SUPPLIES 342,941 228,908 228,904 114,037 67% SERVICES 1,786,044 1,052,207 1,562,185 223,859 87% DEBT SERVICE - PRINCIPAL 50,000 - - 50,000 0% MACHINERY/EQUIPMENT - 127,953 73,540 (73,540) 0% $ 14,826,373 $ 10,432,886 $ 11,878,556 $ 2,947,817 80% SATELLITE O FFIC E SALARIES AND WAGES $ 38,537 $ 7,246 $ 36,400 $ 2,137 94% BENEFITS 7,298 1,375 20,794 (13,496) 285% SUPPLIES 17,000 11,057 226 16,774 1% SERVICES 167,846 52,409 49,410 118,436 29% $ 230,681 $ 72,086 $ 106,830 $ 123,851 46% O Q O M C R C LL t C O 2 ch N O N L d E d O Z 31 Packet Pg. 70 1 Page 2 of 2 C ITY O F EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2023 Amended 10/31/2022 10/31/2023 Amount Title Budget Expenditures Expenditures Remaining %Spent C O MMUNITY S ERVIC ES/EC O N DEV. SALARIES AND WAGES $ 613,413 $ 234,619 $ 544,609 $ 68,804 89% BENEFITS 165,783 68,858 137,322 28,461 83% SUPPLIES 4,075 561 1,144 2,931 28% SERVICES 529,284 214,892 396,216 133,068 75% $ 1,312,555 $ 518,930 $ 1,079,290 $ 233,265 82% PLANNING & DEVELOPMENT SALARIES AND WAGES $ 2,392,581 $ 1,701,066 $ 1,960,635 $ 431,946 82% BENEFITS 779,673 584,157 696,962 82,711 89% SUPPLIES 23,400 8,631 13,716 9,684 59% SERVICES 2,050,853 715,855 520,108 1,530,745 25% $ 5,246,507 $ 3,009,709 $ 3,191,421 $ 2,055,086 61% HUMAN SERVICES PROGRAM SALARIES AND WAGES $ 121,292 $ 61,619 $ 92,900 $ 28,392 77% BENEFITS 33,190 17,406 28,556 4,634 86% SUPPLIES 15,000 2,434 3,638 11,362 24% SERVICES 178,500 39,801 88,315 90,185 49% MACHINERY/EQUIPMENT - 5,608 - - 0% 347,982 126,868 213,410 134,572 61% PARKS & RECREATION SALARIES AND WAGES $ 3,269,091 $ 2,009,685 $ 2,489,560 $ 779,531 76% BENEFITS 1,074,929 687,522 871,983 202,946 81% SUPPLIES 468,900 208,376 343,726 125,174 73% SERVICES 1,672,742 924,616 1,120,508 552,234 67% MACHINERY/EQUIPMENT 90,000 - 151,331 (61,331) 168% $ 6,575,662 $ 3,830,200 $ 4,977,108 $ 1,598,554 76% PUBLIC WORKS ADMINISTRATION SALARIES AND WAGES $ 409,900 $ 123,065 $ 360,424 $ 49,476 88% BENEFITS 150,075 61,199 108,577 41,498 72% SUPPLIES 9,600 3,680 10,541 (941) 110% SERVICES 98,006 69,179 76,673 21,333 78% $ 667,581 $ 257,124 $ 556,215 $ 111,366 83% FACILITIES MAINTENANCE SALARIES AND WAGES 1,287,006 728,982 1,051,404 235,602 82% BENEFITS 462,021 294,604 397,161 64,860 86% SUPPLIES 128,000 69,364 95,002.52 32,997 74% SERVICES 1,359,860 736,005 1,033,665 326,195 76% MACHINERY/EQUIPMENT 1,640,565 81,116 489,839 1,150,726 30% $ 4,877,452 $ 1,910,071 $ 3,067,071 $ 1,810,381 63% ENGINEERING SALARIES AND WAGES $ 2,395,963 $ 1,546,189 $ 1,844,501 $ 551,462 77% BENEFITS 812,924 567,550 642,874 170,050 79% SUPPLIES 2,200 896 3,375 (1,175) 153% SERVICES 404,422 187,075 258,749 145,673 64% $ 3,615,509 $ 2,301,709 $ 2,749,498 $ 866,011 76% TOTAL GENERAL FUND EXPENDITURES $ 63,970,754 $ 38,757,457 $ 47,414,711 $ 16,556,043 74% 32 Packet Pg. 71 2.1.b GENERAL FUND OVERVIEW BALANCES CHANGE IN FUND BALANCES GENERAL FUND ---- ACTUAL ---- ---- ACTUAL ---- & SUBFUNDS 10/31 /2023 10/31 /2023 Q3 YTD Fund Balance Cash Balance 001-General Fund $ 6,153,322 $ 3,439,306 $ (4,890,656) $ (5,749,633, 009-Leoff-Medical Ins. Reserve 39,504 55,456 (108,590) (177,360 m 011-Risk Management Reserve Fund - - (25,000) (25,000 012-Contingency Reserve Fund 2,228,672 2,228,672 - 446,522 014-Historic Preservation Gift Fund 11,701 11,701 - - c 016-Building Maintenance 3,972,935 4,116,210 (103,201) (323,669, M 017 - Marsh Restoration & Preservation 853,595 853,595 3,829 3,829 s 018 - Edmonds Homelessness Response Fd 200,000 200,000 - - 0 019 - Opioid Response Fund 49,007 - - - M Total General Fund & Subfunds $ 13,508,735 $ 10,904,940 $ (5,123,618) $ (5,825,311 c N L d *$8,914,686 of the fund balance in Fund 001 added to the $2,228,672 balance in Fund 012, represent the required Q 20% operating reserve. 0 There are no interfund loans outstanding at this time. o a a� GOVERNMENTAL FUNDS OVERVIEW LL 21 0 2 M BALANCES CHANGE IN FUND BALANCES c N GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- s FUNDS 10/31 /2023 10/31 /2023 Q3 YTD Fund Balance Cash Balance p r c General Fund & Subfunds $ 13,508,735 $ 10,904,940 $ (5,123,618) $ (5,825,311 E Special Revenue 15,290,987 21,526,573 (677,917) (908,762 Capital Projects - Fund 332 383,844 268,865 691,038 176,162 ca Q Total Governmental Funds $ 29,183,566 $ 32,700,378 $ (5,110,497) $ (6,557,912 *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. 72 2.1.b SPECIAL REVENUE FUNDS OVERVIEW BALANCES CHANGE IN FUND BALANCES GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- SPECIAL REVENUE 10/31/2023 10/31/2023 Q3 YTD Fund Balance Cash Balance 104 - Drug Enforcement Fund $ 36,922 $ 40,061 (31,900) $ (30,648 111 - Street Fund (227,540) (168,655) (140,571) (636,225; 0 112 - Combined Street Const/Improve 3,038,397 648,374 (485,000) 598,892 117 - Municipal Arts Acquis. Fund 617,084 647,363 16,366 (17,804 120 - Hotel/Motel Tax Revenue Fund 175,239 165,913 30,908 80,375 Z 121 - Employee Parking Permit Fund 89,478 92,958 961 14,446 c 122 -Youth Scholarship Fund 16,761 17,467 1,352 1,553 ii 123-Tourism Promotional Fund/Arts 138,935 138,909 9,305 23,764 2, 125 - Real Estate Tax 2,317,740 2,684,244 58,739 (899,275, 126 - Real Estate Excise Tax 1 ' 4,544,425 4,872,566 354,715 594,445 0 127 - Gifts Catalog Fund 2,997,869 3,139,972 19,452 (65,923 M 130- Cemetery Mai ntenance/Improvement 221,881 236,983 (22,146) (46,289 0 136 - Parks Trust Fund (7,497) - (161,439) (168,935; 137- Cemetery Maintenance Trust Fund 1,150,421 1,201,594 19,026 47,121 138- Sister City Commission 22,111 23,034 114 2,217 d 140 -Business Improvement Disrict 54,449 54,449 (10,144) 14,665 0 141 -Affordable and Supportive Housing Fd 290,967 283,328 26,296 56,401 ? 142 - Edmonds Rescue Plan Fund (418,782) 7,205,390 (366,841) (483,370; 143 -Tree Fund 1 232,127 242,623 1 2,891 5,827 o C Total Special Revenue $ 15,290,987 $ 21,526,573 1 $ (677,917) $ (908,762 W *$200,000 of the fund balance in Fund 126 has been reserved for Marsh Restoration Funding, as well as $1,000,000 2 for the purchase of Open Space. ENTERPRISE FUNDS OVERVIEW LL 0 M N O BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- o ENTERPRISE FUNDS 10/31/2023 10/31/2023 Q3 YTD 0 O Fund Balance Cash Balance r c d 421 -Water Utility Fund $ 33,339,238 $ 10,286,759 $ 194,550 $ 1,450,615 s 422 -Storm Utility Fund * 20,335,497 7,471,840 1,011,232 2,263,764 423 - Sewer/WWTP Utility Fund 65,077,894 17,105,969 16,276 2,078,560 Q 424 - Bond Reserve Fund 858,570 858,570 4,680 14,609 411 -Combined Utility Operation 120,420 163,335 41,550 120,420 Total Enterprise Funds $ 119,731,619 $ 35,886,474 $ 1,268,288 $ 5,927,968 *$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. 73 2.1.b SUMMARY OVERVIEW BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- CITY-WIDE 10/31/2023 10/31/2023 Q3 YTD Fund Balance Cash Balance Governmental Funds $ 29,183,566 $ 32,700,378 $ (5,110,497) $ (6,557,912 Enterprise Funds 119,731,619 35,886,474 1,268,288 5,927,968 a Internal Services Fund 9,861,507 5,465,779 (230,970) (496,796, m Total City-wide Total $ 158,776,692 $ 74,052,631 $ (4,073,179) $ (1,126,740: c ca c ii 21 s r INTERNAL SERVICE FUNDS OVERVIEW c M N O N L d E d BALANCES CHANGE IN FUND BALANCES Z INTERNAL SERVICE ---- ACTUAL ---- ---- ACTUAL ---- o FUNDS 10/31/2023 10/31/2023 Q3 YTD a Q Fund Balance Cash Balance 511 -Equipment Rental Fund $ 9,089,750 $ 5,005,088 $ (304,312) $ (306,051: c 512-Technology Rental Fund 771,757 460,691 73,341.94 (190,745, L+ Total Internal Service Funds $ 9,861,507 $ 5,465,779 $ (230,970) $ (496,796 0 M N O N L ci O w+ C d E t <.i rt+ y.+ 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. 74 2.2 City Council Agenda Item Meeting Date: 01/9/2024 Finance Committee 2024 Work Plan Staff Lead: Council Department: City Council Preparer: Beckie Peterson Background/History Throughout 2023, several discussions have referenced the interest of both council and staff to review and/or revise several financial or financial -related policies. These include, but are not limited to Fund Balance Reserve Policy, Investment Policy, Purchasing Policy. These current policies are posted to the Administrative Services page of the city website. Recommendation N/A Narrative This discussion will allow committee members, Council President, and Director Turley the opportunity to discuss, strategically plan and prioritize financial committee work for 2024. Packet Pg. 75