Loading...
2022-01-14 City Council - Full FIN Agenda-30601 Op E D o Agenda Edmonds City Council s71. ,HvFINANCE COMMITTEE - SPECIAL ZOOM VIRTUAL ONLINE MEETING EDMONDS CITY COUNCIL MEETINGS WEB PAGE, HTTP://EDMONDSWA.IQM2.COM/CITIZENS/DEFAULT.ASPX, EDMONDS, WA 98020 JANUARY 14, 2022, 2:00 PM THIS MEETING IS HELD VIRTUALLY USING THE ZOOM MEETING PLATFORM. TO VIEW OR LISTEN TO THE COMMITTEE MEETING IN ITS ENTIRETY, PASTE THE FOLLOWING 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 COUNCIL COMMITTEE MEETINGS ARE WORK SESSIONS FOR THE COUNCIL AND CITY STAFF. COMMITTEE MEETING AGENDAS DO NOT INCLUDE AUDIENCE COMMENTS OR PUBLIC HEARINGS. CALL TO ORDER COMMITTEE BUSINESS 1. November 2021 Monthly Financial Report (10 min) 2. Eden Replacement (Continued) (50 min) ADJOURN Edmonds City Council Agenda January 14, 2022 Page 1 2.1 City Council Agenda Item Meeting Date: 01/14/2022 November 2021 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 on consent Narrative November 2021 Monthly Financial Report Attachments: November 2021 Monthly Financial Report Packet Pg. 2 I 2.1.a I OF EDP � d lac. 1SOV CITY OF EDMONDS MONTHLY BUDGETARY FINANCIAL REPORT NOVEMBER 2021 Packet Pg. 3 1 GENERAL FUND SUMMARY I 2.1.a I General Fund Revenues and Expenses (Rolling 24 months) General Fund Revenue General Fund Expense 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 F O a m �a .v c M c ii 2, t c O 2 T N O N L d General Fund Tax Revenue (2015 through 2020) E a� - - Sales Tax Property Tax EMS Tax Other Taxes O Z 12,000,000 r- O 10,000, 000 M O 8,000,000 - - -- - - - ---- - wI - � 6,000,000 U c 4,000,000 ii c 2,000,000 � - � z 2015 2016 2017 2018 2019 2020 0 r N 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 Sales Tax June September December March General Fund Tax Revenue (2021 YTD) $10,469,805 IN Property Tax EMS Tax Other Taxes Q 1 Packet Pg. 4 I 2.1.a I City of Edmonds, WA Monthly Revenue Summary -General Fund 2021 General Fund Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance January $ 2,289,445 $ 2,289,445 $ 2,740,276 19.69% February 4,618,128 2,328,683 5,089,278 10.20% March 7,113,927 2,495,798 7,050,949 -0.89% April 10,184,627 3,070,700 11,029,475 8.30% May 18,392,023 8,207,396 20,122,774 9.41% June 20,805,873 2,413,850 22,872,014 9.93% July 23,101,736 2,295,863 25,583,320 10.74% August 25,640,292 2,538,556 28,113,466 9.65% September 27,907,833 2,267,540 30,286,676 8.52% October 31,778,772 3,870,940 33,150,940 4.32% November 40,146,024 8,367,252 41,509,313 3.40% December 42,490,777 2,344,753 City of Edmonds, WA Monthly Revenue Summary -Real Estate Excise Tax 2021 Real Estate Excise Tax 1 & 2 Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance January $ 195,748 $ 195,748 $ 625,840 219.72% February 341,557 145,810 922,678 170.14% March 525,343 183,786 1,222,093 132.63% April 697,989 172,646 1,478,072 111.76 May 895,413 197,424 1,949,651 117.74% June 1,120,061 224,648 2,330,065 108.03% July 1,335,075 215,015 2,879,064 115.65% August 1,581,214 246,138 3,453,870 118.43% September 1,849,736 268,522 3,818,929 106.46% October 2,083,774 234,038 4,224,981 102.76% November 2,308,787 225,013 4,659,366 101.81% December 2,500,000 191,213 *The monthly budget forecast columns are based on a five-year average. 2 Packet Pg. 5 1 SALES TAX SUMMARY 2.1.a Sales Tax Analysis By Category Current Period: November 2021 Year -to -Date Health & Total $9,428,122 Personal Care, $242,033 Amusement & Business Services, Recreation, $50,951 $966,474 Automotive Construction Trade, Repair, $1,443,037 Gasoline, $37,062 $200,059 Accommodation, $33,805 Clothing and Accessories, $303,646 Communications, $219,663 Wholesale Trade, $338,926 Misc Retail, $1,679,311 12,000,000 10,000, 000 8,000,000 6,905,1 $6,741,838 6,000,000 4,000,000 2,000,000 0 2015 2016 Retail Automotive, $2,309,837 A Others, $227,360 Eating & Drinking, $941,773 Retail Food Stores, $315,898 .-»-».--- -b� $118,287 Annual Sales Tax Revenue - $9,428,122 57.395.114 $8,406,296 $8,452,715 $8,317,046 2018 201 2020 YTD 2021 3 I Packet Pg. 6 I 2.1.a I City of Edmonds, WA Monthly Revenue Summary -Sales and Use Tax 2021 Sales and Use Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 661,963 $ 661,963 $ 774,198 16.95% February 1,491,081 829,118 1,647,058 10.46% March 2,110,825 619,744 2,350,659 11.36% April 2,677,870 567,045 3,041,781 13.59% May 3,379,279 701,409 3,922,140 16.06% June 4,038,220 658,941 4,797,214 18.80% July 4,756,025 717,805 5,699,002 19.83% August 5,547,915 791,890 6,634,250 19.58% September 6,288,480 740,565 7,479,695 18.94% October 7,063,515 775,035 8,493,819 20.25% November 7,866,501 802,986 9,428,122 19.85% December 8,600,000 733,499 City of Edmonds, WA Monthly Revenue Summary -Gas Utility Tax 2021 Gas Utility Tax Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 82,557 $ 82,557 $ 84,132 1.91% February 170,654 88,097 172,999 1.37% March 250,947 80,292 269,171 7.26% April 317,447 66,501 350,366 10.37% May 368,586 51,139 413,190 12.10% June 403,108 34,522 453,419 12.48% July 430,884 27,777 489,128 13.52% August 454,299 23,415 512,233 12.75% September 475,121 20,822 535,887 12.79% October 498,594 23,472 565,388 13.40% November 537,295 38,702 612,631 14.02% December 595,000 57,705 *The monthly budget forecast columns are based on a five-year average. w Packet Pg. 7 1 I 2.1.a I City of Edmonds, WA Monthly Revenue Summary -Telephone Utility Tax 2021 Telephone Utility Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 69,351 $ 69,351 $ 56,592 -18.40% February 138,426 69,074 85,370 -38.33% March 199,085 60,660 140,907 -29.22% April 265,909 66,823 190,824 -28.24% May 325,636 59,728 218,932 -32.77% June 385,177 59,540 274,873 -28.64% July 443,946 58,770 322,813 -27.29% August 501,501 57,554 365,431 -27.13% September 557,882 56,382 391,086 -29.90% October 615,320 57,437 452,939 -26.39% November 665,999 50,679 494,628 -25.73% December 723,000 57,001 Electric Utility Tax 800,000 Telephone Utility Tax 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 Revenue Summary -Electric Utility Tax 2021 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January $ 179,984 $ 179,984 $ 192,356 6.87% February 379,889 199,905 367,328 -3.31% March 546,637 166,748 537,433 -1.68% April 730,293 183,656 721,208 -1.24% May 873,813 143,520 872,875 -0.11% June 997,568 123,755 987,183 -1.04% July 1,114,337 116,769 1,105,355 -0.81% August 1,230,154 115,816 1,217,532 -1.03% September 1,342,671 112,517 1,330,863 -0.88% October 1,453,976 111,305 1,439,342 -1.01% November 1,576,729 122,753 1,557,394 -1.23% December 1,710,000 133,271 Electric Utility Tax 1,zsuu,uuu 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. 5 Packet Pg. 8 I 2.1.a I City of Edmonds, WA Monthly Revenue Summary -Meter Water Sales 2021 Meter Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 779,311 $ 779,311 $ 785,708 0.82% February 1,323,513 544,201 1,376,327 3.99% March 2,123,378 799,865 2,200,360 3.63% April 2,634,733 511,355 2,730,111 3.62% May 3,397,533 762,799 3,527,366 3.82% June 3,993,888 596,356 4,181,353 4.69% July 4,928,107 934,219 5,161,097 4.73% August 5,728,520 800,414 6,057,803 5.75% September 6,831,863 1,103,343 7,158,105 4.78% October 7,628,547 796,684 7,904,214 3.61% November 8,538,589 910,042 8,773,134 2.75% December 9,090,825 552,236 City of Edmonds, WA Monthly Revenue Summary -Storm Water Sales 2021 Storm Water Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 384,276 $ 384,276 $ 377,845 6.87% February 1,216,009 831,732 1,205,144 -3.31% March 1,599,504 383,495 1,586,561 -1.68% April 1,939,303 339,799 1,926,094 -1.24% May 2,323,204 383,901 2,307,849 -0.11% June 2,663,931 340,727 2,647,822 -1.04% July 3,048,086 384,154 2,994,340 -1.76% August 3,880,066 831,980 3,819,514 -1.56% September 4,263,771 383,706 4,201,629 -1.46% October 4,604,458 340,687 4,540,958 -1.38% November 4,988,465 384,006 4,923,087 -1.31% December 5,316,477 328,012 *The monthly budget forecast columns are based on a five-year average. 0 Packet Pg. 9 1 I 2.1.a I City of Edmonds, WA Monthly Revenue Summary-Unmeter Sewer Sales 2021 Unmeter Sewer Sales Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 846,742 $ 846,742 $ 806,699 -4.73% February 1,539,036 692,295 1,482,613 -3.67% March 2,387,119 848,083 2,293,552 -3.92% April 3,078,705 691,586 2,976,527 -3.32% May 3,923,269 844,563 3,802,264 -3.08% June 4,616,005 692,736 4,493,851 -2.65% July 5,485,907 869,902 5,279,791 -3.76% August 6,180,993 695,086 5,974,891 -3.33% September 7,065,967 884,974 6,845,543 -3.12% October 7,769,759 703,792 7,541,945 -2.93% November 8,630,384 860,626 8,386,649 -2.82% December 9,319,928 689,544 Unmeter Sewer Sales 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC � Current Year Budget � Prior Year *The monthly budget forecast columns are based on a five-year average. 7 Packet Pg. 10 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -General Fund 2021 General Fund Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 4,867,007 $ 4,867,007 $ 4,488,492 -7.78% February 8,277,437 3,410,430 7,637,016 -7.74% March 11,799,150 3,521,713 11,022,804 -6.58% April 15,300,200 3,501,051 14,232,961 -6.98% May 18,566,769 3,266,569 17,443,966 -6.05% June 22,786,523 4,219,754 21,115,256 -7.33% July 26,669,445 3,882,922 24,346,357 -8.71% August 30,361,055 3,691,610 27,848,489 -8.28% September 33,809,067 3,448,012 31,332,012 -7.33% October 37,611,595 3,802,528 34,558,991 -8.12% November 41,715,269 4,103,674 38,282,347 -8.23% December 46,185,977 4,470,708 City of Edmonds, WA Monthly Expenditure Report -Non -Departmental 2021 Non -Departmental Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 2,130,566 $ 2,130,566 $ 2,013,112 -5.51% February 2,963,078 832,512 2,845,113 -3.98% March 3,917,369 954,291 3,679,050 -6.08% April 4,745,926 828,556 4,484,023 -5.52% May 5,426,477 680,552 5,278,401 -2.73% June 6,887,081 1,460,603 6,412,264 -6.89% July 7,925,195 1,038,115 7,203,386 -9.11% August 8,791,207 866,012 8,115,624 -7.68% September 9,531,703 740,496 8,838,355 -7.27% October 10,445,987 914,284 9,614,308 -7.96% November 11,570,251 1,124,264 10,495,603 -9.29% December 12,906,593 1,336,342 *The monthly budget forecast columns are based on a five-year average. Q Packet Pg. 11 1 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -City Council 2021 City Council Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 27,295 $ 27,295 $ 26,808 -1.79% February 57,824 30,529 53,681 -7.17% March 91,440 33,616 83,267 -8.94% April 122,323 30,882 110,738 -9.47% May 163,149 40,826 137,169 -15.92% June 212,026 48,877 164,613 -22.36% July 246,267 34,241 192,621 -21.78% August 293,761 47,494 219,652 -25.23% September 333,076 39,315 247,315 -25.75% October 357,472 24,396 273,284 -23.55% November 393,733 36,262 302,438 -23.19% December 432,478 38,745 City of Edmonds, WA Monthly Expenditure Report -Office of Mayor 2021 Office of Mayor Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 28,543 $ 28,543 $ 27,531 -3.55% February 58,378 29,835 55,740 -4.52% March 86,855 28,477 83,532 -3.83% April 115,847 28,992 111,352 -3.88% May 144,377 28,530 138,910 -3.79% June 172,357 27,980 166,677 -3.30% July 200,988 28,631 194,309 -3.32% August 230,481 29,494 221,858 -3.74% September 259,088 28,607 249,093 -3.86% October 287,175 28,087 276,714 -3.64% November 315,280 28,104 311,403 -1.23% December 345,501 30,221 Office of Mayor 350,000.00 300,000.00 250,000.00 l 200,000.00 150,000.00 100,000.00 50,000.00 0.00 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --"-CunentYeaz Budget •PriorYeaz *The monthly budget forecast columns are based on a five-year average. 9 Packet Pg. 12 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -Human Resources 2021 Human Resources Cumulative Budget Forecast Monthly Budget Forecast YTD Actuals Variance % January $ 73,271 $ 73,271 $ 75,120 2.52% February 138,790 65,519 132,066 -4.84% March 202,112 63,322 187,141 -7.41% April 262,791 60,679 252,612 -3.87% May 326,332 63,541 319,298 -2.16% June 403,462 77,130 368,323 -8.71% July 464,647 61,185 419,004 -9.82% August 528,490 63,843 462,324 -12.52% September 598,547 70,057 506,717 -15.34% October 664,032 65,485 554,503 -16.49% November 731,681 67,649 622,562 -14.91% December 837,176 105,495 City of Edmonds, WA Monthly Expenditure Report -Municipal Court 2021 Municipal Court Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 94,968 $ 94,968 $ 93,953 -1.07% February 198,805 103,837 183,450 -7.72% March 299,941 101,136 275,717 -8.08% April 402,735 102,794 359,370 -10.77% May 513,290 110,555 445,221 -13.26% June 611,079 97,789 535,746 -12.33% July 712,118 101,040 622,191 -12.63% August 816,971 104,853 749,313 -8.28% September 918,568 101,597 857,840 -6.61% October 1,025,192 106,624 955,506 -6.80% November 1,125,425 100,233 1,083,397 -3.73% December 1,252,513 127,088 *The monthly budget forecast columns are based on a five-year average. 10 Packet Pg. 13 1 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -Community Services/Economic Development 2021 Community Services/Economic Development Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 41,233 $ 41,233 $ 43,221 4.82% February 88,221 46,989 85,831 -2.71% March 135,256 47,034 130,319 -3.65% April 184,259 49,003 157,909 -14.30% May 233,650 49,391 198,730 -14.95% June 281,295 47,646 263,632 -6.28% July 332,496 51,200 308,903 -7.10% August 387,551 55,056 366,310 -5.48% September 434,722 47,170 427,478 -1.67% October 487,409 52,687 473,861 -2.78% November 550,406 62,997 533,780 -3.02% December 624,198 73,792 City Clerk Community Services/Economic Development 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 -0-- Prior Year City of Edmonds, WA Monthly Expenditure Report -City Clerk 2021 Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance January $ 73,276 $ 73,276 $ 78,859 7.62% February 133,953 60,677 139,396 4.06% March 196,194 62,241 209,183 6.62% April 261,901 65,707 272,337 3.98% May 322,071 60,170 328,247 1.92% June 380,379 58,308 351,029 -7.72% July 444,659 64,280 363,075 -18.35% August 511,894 67,234 408,783 -20.14% September 567,756 55,862 444,121 -21.78% October 625,324 57,568 475,376 -23.98% November 692,090 66,766 514,141 -25.71% December 757,055 64,965 City Clerk 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 *The monthly budget forecast columns are based on a five-year average. 11 Packet Pg. 14 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -Technology Rental Fund 2021 Technology Rental Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 136,722 $ 136,722 $ 117,002 -14.42% February 290,515 153,792 168,294 -42.07% March 386,224 95,709 350,229 -9.32% April 453,827 67,604 404,389 -10.89% May 542,997 89,170 460,963 -15.11% June 634,330 91,333 519,736 -18.07% July 713,918 79,588 572,585 -19.80% August 806,613 92,695 642,362 -20.36% September 902,103 95,490 711,971 -21.08% October 985,360 83,257 944,850 -4.11% November 1,067,005 81,645 994,096 -6.83% December 1,257,909 190,904 Finance City of Edmonds, WA Monthly Expenditure Report -Administrative Services 2021 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 123,076 $ 123,076 $ 137,736 11.91% February 213,593 90,517 226,074 5.84% March 305,354 91,762 314,260 2.92% April 398,335 92,980 402,835 1.13% May 491,716 93,382 490,038 -0.34% June 607,431 115,714 625,371 2.95% July 706,168 98,737 766,314 8.52% August 796,996 90,828 875,083 9.80% September 899,375 102,379 990,749 10.16% October 994,272 94,897 1,115,329 12.18% November 1,085,877 91,605 1,229,187 13.20% December 1,178,545 92,668 Administrative Services 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 1 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -0-- Current Yeaz Budget - Prior Year *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 -City Attorney 2021 City Attorney Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 78,040 $ 78,040 $ 69,941 -10.38% February 156,080 78,040 142,526 -8.68% March 234,120 78,040 212,467 -9.25% April 312,160 78,040 282,407 -9.53% May 390,200 78,040 352,348 -9.70% June 468,240 78,040 404,226 -13.67% July 546,280 78,040 492,368 -9.87% August 624,320 78,040 562,309 -9.93% September 702,360 78,040 632,249 -9.98% October 780,400 78,040 702,190 -10.02% November 858,440 78,040 772,130 -10.05% December 936,480 78,040 Police City Attorney 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 Yeaz Budget Prior Yeaz City of Edmonds, WA Monthly Expenditure Report -Police 2021 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 948,663 $ 948,663 $ 992,942 4.67% February 1,933,831 985,168 1,856,572 -4.00% March 2,901,114 967,283 2,871,535 -1.02% April 3,878,067 976,953 3,802,023 -1.96% May 4,844,411 966,345 4,751,092 -1.93% June 5,873,421 1,029,009 5,731,600 -2.41% July 6,905,785 1,032,364 6,626,850 -4.04% August 7,852,686 946,901 7,550,794 -3.84% September 8,847,063 994,377 8,445,438 -4.54% October 9,934,749 1,087,687 9,394,444 -5.44% November 11,184,244 1,249,495 10,536,637 -5.79% December 12,217,071 1,032,827 Police 8,000,000 6,000,000 4,000,000 2,000,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC --"- Current Yeaz Budget �Prior Year *The monthly budget forecast columns are based on a five-year average. 13 Packet Pg. 16 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -Development Services 2021 Development Services Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 258,603 $ 258,603 $ 219,157 -15.25% February 543,028 284,425 448,394 -17.43% March 826,331 283,303 690,769 -16.41% April 1,128,019 301,688 934,573 -17.15% May 1,433,846 305,827 1,185,423 -17.33% June 1,715,744 281,899 1,471,283 -14.25% July 2,020,389 304,645 1,730,845 -14.33% August 2,331,583 311,194 1,960,572 -15.91% September 2,632,785 301,202 2,183,294 -17.07% October 2,927,354 294,569 2,430,629 -16.97% November 3,269,474 342,120 2,677,707 -18.10% December 3,621,500 352,026 Parks & Recreation Development Services 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 Yeaz Budget -d­ Prior Year City of Edmonds, WA Monthly Expenditure Report -Parks & Recreation 2021 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 319,744 $ 319,744 $ 308,283 -3.58% February 651,727 331,983 655,977 0.65% March 1,004,599 352,872 971,861 -3.26% April 1,371,174 366,574 1,273,239 -7.14% May 1,749,534 378,360 1,604,251 -8.30% June 2,129,825 380,291 2,002,869 -5.96% July 2,608,624 478,799 2,366,948 -9.26% August 3,159,845 551,221 2,760,446 -12.64% September 3,607,041 447,196 3,252,343 -9.83% October 3,989,956 382,916 3,577,972 -10.33% November 4,323,317 333,361 3,939,689 -8.87% December 4,729,281 405,964 Parks & Recreation 4,000,000 3,500,000 11500,000 1,000,000 500,000 I row'- JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -*-- Current Yeaz Budget -0-- Prior Year *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 -Public Works Administration 2021 Public Works Administration Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 42,089 $ 42,089 $ 40,605 -3.53% February 84,997 42,908 81,720 -3.86% March 127,527 42,530 123,465 -3.19% April 170,261 42,734 170,658 0.23% May 213,078 42,817 212,461 -0.29% June 256,751 43,673 254,025 -1.06% July 300,611 43,860 297,102 -1.17% August 343,101 42,490 337,783 -1.55% September 385,406 42,305 378,963 -1.67% October 426,793 41,387 419,569 -1.69% November 468,729 41,936 521,987 11.36% December 512,253 43,524 Facilities Maintenance Public Works Administration 600,000 Ole 500,000 400,000 300,000 200,000 100,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Current Year Budget � Prior Year City of Edmonds, WA Monthly Expenditure Report -Facilities Maintenance 2021 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals January $ 167,724 $ 167,724 $ 142,909 -14.80% February 348,879 181,155 294,332 -15.63% March 533,264 184,385 528,741 -0.85% April 706,629 173,365 711,450 0.68% May 894,239 187,611 856,587 -4.21% June 1,043,804 149,565 989,625 -5.19% July 1,223,905 180,101 1,170,492 -4.36% August 1,414,941 191,036 1,445,505 2.16% September 1,622,246 207,305 1,840,452 13.45% October 1,898,737 276,491 2,031,188 6.98% November 2,125,911 227,174 2,237,161 5.23% December 2,442,899 316,988 Facilities Maintenance 11,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -0-- Current Yeaz Budget -0-- Prior Year *The monthly budget forecast columns are based on a five-year average. 15 Packet Pg. 18 I 2.1.a I City of Edmonds, WA Monthly Expenditure Report -Engineering 2021 Engineering Cumulative Monthly Budget Forecast Budget Forecast YTD Actuals Variance % January $ 212,668 $ 212,668 $ 218,316 2.66% February 423,271 210,602 436,144 3.04% March 652,974 229,703 661,498 1.31% April 890,809 237,835 888,001 -0.32% May 1,130,883 240,074 1,122,224 -0.77% June 1,371,946 241,063 1,346,241 -1.87% July 1,617,159 245,213 1,560,038 -3.53% August 1,869,308 252,149 1,770,434 -5.29% September 2,101,156 231,848 1,985,684 -5.50% October 2,337,410 236,254 2,197,742 -5.98% November 2,559,700 222,290 2,422,908 -5.34% December 2,793,032 233,332 Engine a ring 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC � Current Year Budget Prior Year *The monthly budget forecast columns are based on a five-year average. 16 Packet Pg. 19 I 2.1.a I INVESTMENT PORTFOLIO SUMMARY City of Edmonds Investment Portfolio Detail As of November 30. 2021 Years Agency/ Investment Purchase to Par Market Maturity Coupon Issuer Type Price Maturity Value Value Date Rate Grant Cnty WA FFCB Energy Northw est Energy Northw est Mason & Kitsap Cnty WA Grant Cnty WA Grant Cnty WA Seattle WA Muni FHLB First Financial - ECA Kent WA Spokane County WA First Financial - Waterfront Center Bonds Bonds Bonds Bonds Bonds Bonds Bonds Bonds Bonds CD Bonds Bonds CD TOTAL SECURITIES Washington State Local Gov't Investment Pool Snohomish County Local Gov't Investment Pool Kent WA, 2% Mason & Kitsap Cnty WA, 5% Grant Cnty P WA, 15% FFCB, FHLB, Energy 12% 12% Northwest, 10% TOTAL PORTFOLIO 410,553 0.09 405,000 405,502 01/01/22 1.79% 1,998,548 0.54 2,000,000 2,019,094 06/14/22 1.88% 1,466,077 0.58 1,345,000 1,382,942 07/01/22 5.00% 260,748 0.58 250,000 253,923 07/01/22 2.95% 948,084 1.00 855,000 895,407 12/01/22 5.00% 1,517,955 1.09 1,500,000 1,517,745 01/01/23 1.54% 576,332 1.09 520,000 546,686 01/01/23 5.00% 2,224,500 1.17 2,000,000 2,111,280 02/01/23 5.00% 1,996,590 1.85 2,000,000 1,995,190 10/05/23 0.22% 2,803,516 1.96 2,803,516 2,803,516 11/15/23 2.08% 286,648 2.00 250,000 273,233 12/01/23 5.00% 259,075 3.01 250,000 258,938 12/01/24 2.10% 2,000,000 5.92 2,000,000 2,000,000 11/01/27 0.25% 16,748,624 1.61 16,178,516 16,463,456 19,924,085 19,924,085 Demand 0.09% 42,408,731 42,408,731 Demand 1.09% Issuer Diversification Seattle WA Muni, 12% First Financial - CD, 30% Spokane County WA, 2% $ 78,511,332 $ 78,796,272 Checking, Cash and Investment Balances $5.7 , 7%� (in $ Millions) CD's, $4.8, 1 Bonds, 6% \ $11.4, 13% State LGIP, $19.9, 24% County LGIP, $42.4 , 50% 17 Packet Pg. 20 I 2.1.a I INVESTMENT PORTFOLIO SUMMARY Annual Interest Income $1,400, 000 77M $1,200,000 $1,236,875 $1,000, 000 $947,931 863,620 $800,000 $635,781 $600,000 423,799 $400,000 $200,000 2016 7 2018 2019 2020 YTD 2021 18 Packet Pg. 21 I 2.1.a I Page 1 of 1 C ITY O F EDMO NDS REVENUES BY FUND - SUMMARY Fund 2021 Amended 11/30/2020 11/30/2021 Amount No. Title Budget Revenues Revenues Remaining %Receive 001 GENERAL FUND $ 42,490,777 $ 39,391,635 $ 41,509,313 $ 981,464 98 009 LEOFF-MEDICAL INS. RESERVE 300,000 425,000 - 300,000 0 011 RISK MANAGEMENT RESERVE FUND 25,000 - - 25,000 0 012 CONTINGENCY RESERVE FUND 2,620 - - 2,620 0 014 HISTORIC PRESERVATION GIFT FUND 5,010 5,000 2,500 2,510 50 i O 016 BUILDING MAINTENANCE FUND - - 4,417,907 (4,417,907) 0 = d 017 MARSH RESTORATION & PRESERVATION FUND - 100 150 (150) 0 104 DRUG ENFORCEMENT FUND 165,370 64,489 2,023 163,347 1 'V C 111 STREET FUND 1,722,360 1,785,348 1,548,375 173,985 90 O C 112 COMBINED STREET CONST/IMPROVE 3,068,385 1,764,428 2,106,256 962,129 69 LL 21 117 MUNICIPAL ARTS ACQUIS. FUND 165,060 77,685 52,763 112,297 32 t 118 MEMORIAL STREET TREE 270 474 406 (136) r� C 150 O 120 HOTEL/MOTEL TAX REVENUE FUND 71,460 59,639 74,659 (3,199) 104 121 EMPLOYEE PARKING PERMIT FUND 25,240 12,345 12,703 12,537 50 Np N 122 YOUTH SCHOLARSHIP FUND 1,390 619 696 694 50 123 TOURISM PROMOTIONAL FUND/ARTS 24,000 20,508 26,597 (2,597) ill 125 REAL ESTATE EXCISE TAX 2 t 1,282,050 1,556,231 2,414,469 (1,132,419) 188 > 126 REAL ESTATE EXCISE TAX 1 1 1,285,240 1,550,006 2,402,469 (1,117,229) O 187 Z 127 GIFT S CAT ALOG FUND 103,930 54,658 59,206 44,724 57 r O 130 CEMETERY MAINTENANCE/IMPROVEMT 179,800 115,851 225,695 (45,895) 126 C 136 PARKS TRUST FUND 2,200 3,906 4,533 (2,333) 206 137 CEMETERY MAINTENANCE TRUST FD 29,220 37,560 51,676 (22,456) 177 'v 138 SISTER CITY COMMISSION 10,120 270 2,803 7,317 C 28 C 140 BUSINESS IMPROVEMENT DISTRICT 79,239 73,211 75,988 3,251 96 IL 141 AFFORDABLE AND SUPPORTIVE HOUSING FUND 65,000 64,783 72,736 (7,736) 112 z 142 EDMONDS RESCUE PLAN FUND 5,946,550 814,793 5,991,438 (44,888) r 101 O 143 TREE FUND 20,487 - 20,605 (118) 101 231 2012 LT GO DEBT SERVICE FUND 759,710 452,588 2,754,766 (1,995,056) r 363 No 332 PARKS CAPITAL CONSTRUCTION FUND 1,392,520 1,405,339 2,086,329 (693,809) N 150 d 411 COMBINED UTILITY OPERATION - 32,085 6,340 (6,340) 0 Q 421 WATER UTILITY FUND 2 10,299,357 9,392,901 14,860,563 (4,561,206) 144 d 422 STORM UTILITY FUND 6,265,225 5,311,534 8,610,482 (2,345,257) 137 Z 423 SEWER/WWTP UTILITY FUND s 31,130,450 29,789,152 24,711,827 6,418,623 79 O 424 BOND RESERVE FUND 1,985,870 616,553 600,427 1,385,443 30 E 511 EQUIPMENT RENTAL FUND 1,331,100 1,676,467 1,363,479 (32,379) t 102 0 2 512 TECHNOLOGY RENTAL FUND 1,204,880 1,166,903 1,119,821 85,059 93 Q 617 FIREMEN'S PENSION FUND 67,270 55,001 - 67,270 0 $ 111,507,160 $ 97,777,063 $ 117,189,999 $ (5,682,839) 105 1 2021 BEET revenues are $1,666,307 higher than 2020 revenues. 2 Difference primarily due to Debt Refunding in November of 2021. 3 Differences primarily due to WWTP partner billings in January 2021, and Proceeds of Long-term debt in November 2020. 19 Packet Pg. 22 I 2.1.a I Page 1 of 1 C ITY O F IDMO NDS EXPENDITURES BY FUND - SUMMARY Fund 2021 Amended 11/30/2020 11/30/2021 Amount No. Title Budget Expenditures Expenditures Remaining %Spent 001 GENERAL FUND $ 46,185,977 $ 38,995,588 $ 38,282,347 $ 7,903,630 839 009 LEOFF-MEDICAL INS. RESERVE 467,140 231,889 251,067 216,073 549 014 HISTORIC PRESERVATION GIFT FUND 5,900 - 5,900 09 016 BUILDING MAINTENANCE FUND 210,222 17,907 192,315 99 017 MARSH RESTORATION & PRESERVATION FUND 20,000 16,149 3,851 819 018 EDMONDS HOMELESSNESS RESPONSE FUND 123,581 - 123,581 - 1009 Q. 019 EDMONDSOPIOID RESPONSE FUND 28,445 21,555 28,445 - d 1009 104 DRUG ENFORCEMENT FUND 45,800 30,332 - 45,800 09 t� III STREET FUND 2,187,430 1,859,996 1,843,491 343,939 849 C 112 COMBINED STREET CONST/IMPROVE 2,862,297 1,064,847 1,845,746 1,016,551 649 j,L 117 MUNICIPAL ARTS ACQUIS. FUND 236,880 30,367 62,770 174,110 269 118 MEMORIAL STREET TREE 20,487 - 20,487 - 1009 C 120 HOTEL/MOTEL TAX REVENUE FUND 87,150 50,215 48,668 38,482 569 2 121 EMPLOYEE PARKING PERMIT FUND 26,880 632 1,266 25,614 T 59 C 122 YOUTH SCHOLARSHIP FUND 3,000 450 75 2,925 39 cm N 123 TOURISM PROMOTIONAL FUND/ARTS 29,900 10,399 2,500 27,400 89 125 REAL ESTATE EXCISE TAX 2 1,601,298 1,485,522 594,219 1,007,079 379 > 126 REAL ESTATE EXCISE TAX 1 2,053,911 1,456,999 952,952 1,100,959 469 Z 127 GIFTS CATALOG FUND 100,900 87,751 35,353 65,547 359 r- 130 CEMETERY MAINTENANCE/IMPROVEMT 200,998 165,679 180,417 20,581 O 909 CL 136 PARKS TRUST FUND 50,000 - - 50,000 09 !Y 137 CEMETERY MAINTENANCE TRUST FUND 25,000 19,211 5,789 779 •V 138 SISTER CITY COMMISSION 11,900 11 - 11,900 09 C 140 BUSINESS IMPROVEMENT DISTRICT 76,340 50,200 51,070 25,271 679 j,L 142 EDMONDS RESCUE PLAN FUND 5,946,550 1,698,013 732,656 5,213,894 129 s 231 2012 LT GO DEBT SERVICE FUND 759,700 47,291 2,754,766 (1,995,066) r 3639 C 332 PARKS CAPITAL CONSTRUCTION FUND 5,552,490 1,335,262 1,202,227 4,350,263 229 Z 421 WATER UTFLIT YFUND 10,760,050 9,551,953 12,713,366 (1,953,316) r 1189 c 422 STORM UTILITY FUND 7,293,890 7,007,409 6,513,806 780,084 899 i d 423 SEWER/WWTP UTILITY FUND 40,492,284 16,676,611 25,891,548 14,600,736 649 424 BOND RESERVE FUND 1,985,870 616,542 600,417 1,385,453 309 > 511 EQUIPMENT RENTAL FUND 1,429,954 2,814,377 1,118,132 311,822 789 Z 512 TECHNOLOGY RENTAL FUND 1,257,909 912,391 994,096 263,813 799 617 FIREMEN'S PENSION FUND 136,167 75,665 89,826 46,341 669 E $ 132,276,300 $ 86,277,947 $ 96,988,561 $ 35,287,738 73° V M 20 Packet Pg. 23 2.1.a Page 1 of 3 C ITY O F EDMO NDS REVENUES - GENERAL FUND 2021 Amended 11/30/2020 11/30/2021 Amount Title Budget Revenues Revenues Remaining %Received TAXES: 1 REAL PERSONAL / PROPERTY TAX 4 $ 10,936,400 $ 10,393,947 $ 10,469,805 $ 466,595 960/ 2 EMSPROPERTYTAX4 4,137,031 4,058,718 4,127,578 9,453 1000/ 3 VOTED PROPERTY TAX 500 26 4 496 10/ 4 LOCAL RETAIL SALES(USE TAX 5 8,600,000 7,523,231 9,428,122 (828,122) 1100/ 5 NATURAL GAS USE TAX 7,600 6,895 10,509 (2,909) 1380r 6 1/10 SALES TAX LOCAL CRIM JUST 828,500 738,431 871,694 (43,194) 10501 7 ELECTRIC UTILITY TAX 1,710,000 1,540,846 1,557,394 152,606 910/ 8 GAS UTILITY TAX 595,000 571,050 612,631 (17,631) 1030r 9 SOLID WASTE UTILITY TAX 364,000 316,060 330,886 33,114 910/ 10 WATERUTILITYTAX 1,153,000 1,022,313 875,287 277,713 760/ 11 SEWER UTILITYTAX 894,600 718,876 838,827 55,773 940/ 12 STORMWATERUTFLIT YTAX 471,900 452,696 492,843 (20,943) 1040/ 13 T.V. CABLE UTILITY TAX 722,000 736,282 745,251 (23,251) 1030/ 14 TELEPHONE UTILITY TAX 723,000 606,633 494,628 228,372 680/ 15 PULLTABSTAX 55,200 56,617 80,658 (25,458) 1460/ 16 AMUSEMENT GAMES 350 449 279 71 800r 17 LEASEHOLD EXCISE TAX 295,900 228,029 289,821 6,079 980/ 31,494,981 28,971,100 31,226,217 268,764 99°r LICENSES AND PERMITS: 18 FIRE PERMITS -SPECIAL USE 19 POLICE - FINGERPRINTING 20 VENDING MACHINE/CONCESSION 21 FRANCHISE AGREEMENT-COMCAST 22 FRANCHISE FEE-EDUCATION/GOVERNMENT 23 FRANCHISE AGREEMENT-ZIPLY FIBER 24 OLYMPIC VIEW WATER DISTRICT FRANCHISE 25 GENERAL BUSINESS LICENSE 26 DEV SERV PERMIT SURCHARGE 27 RIGHT OF WAY FRANCHISE FEE 28 BUILDING STRUCTURE PERMITS 29 ANIMAL LICENSES 30 STREET AND CURB PERMIT 31 OT R NON -BUS LIC/PERMIT S INTERGOVERNMENTAL: 32 DOCKSIDE DRILLS GRANT REIMBURSE 33 DOJ 15-0404-0-1-754 - BULLET PROOF VEST 34 TARGET ZERO TEAMS GRANT 35 HIGH VISIBILITY ENFORCEMENT 36 CORONAVIRUS RELIEF FUND 37 CORONAVIRUS RELIEF FUND 2 38 WA STATE TRAFFIC COMM GRANT 39 DOC FAC ROOFING 40 WA STATE ART COMMISSION 2021-003-CD 41 STATE GRANTS- BUDGET ONLY 42 PUD PRIVILEDGE TAX 43 2022-2023 BIENNIUM ONE-TIME ALLOCATION 44 ARCHIVES AND RECORDS MANAGEMENT 45 STATE GRANT FROM OTHER JUDICIAL AGENCIES 46 SCHOOL ZONE 47 CJ - POPULATION 48 TRIAL COURT IMPROVEMENT 49 CRIMINAL JUSTICE -SPECIAL PROGRAMS 50 MARIJUANA EXCISE TAX DISTRIBUTION 51 DUI - CITIES 52 FIRE INS PREMIUM TAX 53 LIQUOR EXCISE TAX 54 LIQUOR BOARD PROFITS 55 POLICE TRAINING CLASSES 56 FIRST RESPONDERS FLEX FUND 57 DISCOVERY PROGRAMS TECHNOLOGY ACQ. 58 INTERLOCAL GRANTS 59 VERDANT INTERLOCAL GRANTS 250 365 600 (350) 2400/ 700 80 - 700 00/ 50,000 12,881 62,097 (12,097) 1240/ 702,700 678,877 676,727 25,973 960/ 41,000 36,612 34,648 6,352 850/ 100,600 73,239 60,110 40,490 600/ 434,000 377,553 403,280 30,720 930/ 201,000 203,899 210,966 (9,966) 10501 58,700 68,800 84,025 (25,325) 1430/ 30,000 29,782 21,529 8,471 720/ 650,600 589,029 654,806 (4,206) 1010/ 22,000 17,056 10,329 11,671 470/ 50,000 53,405 70,770 (20,770) 1420r 20,000 15,592 17,234 2,766 860/ 2,361,550 2,157,170 2,307,121 54,429 980, - 559 - - 00/ 6,000 2,052 6,464 (464) 1080/ 4,000 - - 4,000 00/ 7,100 1,623 916 6,184 130/ - 165,164 - - 00/ - - 3,947 (3,947) 00/ - - 9,777 (9,777) 00/ - - 379,270 (379,270) 00/ - - 6,000 (6,000) 00/ 198,000 - - 198,000 00/ 210,500 207,989 208,112 2,388 990r - - 168,950 (168,950) 00/ - 9,399 - - 00/ 140 - - 00/ - 825 - - 00/ 13,070 13,211 13,962 (892) 1070/ 16,740 16,152 16,140 600 960/ 45,600 47,280 49,717 (4,117) 1090/ 60,000 50,966 60,515 (515) 1010/ 4,500 6,129 6,950 (2,450) 1540/ - - 53,334 (53,334) 00/ 261,500 265,801 297,159 (35,659) 1140/ 343,200 253,877 251,697 91,503 730/ - 1,194 - - 00/ 2,000 4,001 442 1,558 220/ 550 - - 550 00/ - - 27,216 (27,216) 00/ - - 66,000 (66,000) 00/ 1,172,760 1,046,361 1,626,568 (453,808) 1390/ 4 2021 Real Personal/Property Taxis $75,857 higher than 2020, and EMS Property Taxis$68,860 higher for a total of $144,717. 5 2021 Local Retail Sa/eslUse Tax revenues are $1,904,891 higher than 2020 revenues Please also see pages pages 3 & 4. 21 O a d C to C U. t C O N 0 N L d M E d O Z Packet Pg. 24 1 2.1.a Page 2 of 3 C ITY O F IDMO NDS REVENUES - GENERAL FUND 2021 Amended 11/30/2020 11/30/2021 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 DRE REIMBURSEABLE 7 WARRANT PREPARATION FEE 8 IT TIME PAY FEE 9 MUNIC.-DIST. COURT CURR EXPEN 10 SALE MAPS & BOOKS 11 CLERKS TIME FOR SALE OF PARKING PERMITS 12 BID SUPPLIES REIMBURSEMENT 13 PHOTOCOPIES 14 POLICE DISCLOSURE REQUESTS 15 ENGINEERING FEES AND CHARGES 16 ELECTION CANDIDATE FILINGFEES 17 CUSTODIAL SERVICES (SNO-ISLE) 18 PASSPORTS AND NATURALIZATION FEES 19 POLICE SERVICES SPECIAL EVENTS 20 CAMPUS SAFETY-EDM. SCH. DIST. 21 WOODWAY-LAW PROTECTION 22 MISCELLANEOUS POLICE SERVICES 23 FIRE DISTRICT #1 STATION BILLINGS 24 LEGAL SERVICES 25 ADULT PROBATION SERVICE CHARGE 26 BOOKING FEES 27 FIRE CONSTRUCTION INSPECTION FEES 28 EMERGENCY SERVICE FEES 29 EMS TRANSPORT USER FEE 30 FLEX FUEL PAYMENTS FROM STATIONS 31 ANIMAL CONTROL SHELTER 32 ZONING/SUBDIVISION FEE 33 PLAN CHECKING FEES 34 FIRE PLAN CHECK FEES 35 PLANNING 1% INSPECTION FEE 36 S.E.P.A. REVIEW 37 CRITICAL AREA STUDY 38 GYM AND WEIGHTROOM FEES 39 PROGRAM FEES 6 40 TAXABLE RECREATION ACTIVITIES 41 WINTERMARKET REGISTRATION FEES 42 UPTOWN EVENING MARKET FEES 43 BIRD FEST REGISTRATION FEES 44 INTERFUND REIMBURSEMENT -CONTRACT SVCS $ 3,000 $ 4,988 $ 4,418 $ (1,418) 1470/ 600 120 242 358 400/ 11,000 5,951 4,301 6,699 390/ 150 7 2 148 10/ 300 97 - 300 00/ - 235 168 (168) 00/ 4,000 2,358 98 3,902 20/ 1,000 766 472 528 470/ 50 66 203 (153) 4060/ O 100 9 - 100 00/ d 25,100 - - 25,100 00/ 600 - - 600 00/ io 1,000 450 179 821 180/ 500 - - 500 00/ to 200,000 236,177 203,235 (3,235) 1020/ 1,400 - - 1,400 00/ L 85,000 71,759 70,862 14,138 830/ 10,000 5,795 - 10,000 00/ 1 30,000 - 18,118 11,882 600/ O 76,800 36,753 2,505 74,295 30/ 2 195,000 198,859 204,825 (9,825) 10501 N - 58 52 (52) 00/ N 57,000 59,291 57,132 (132) 1000/ i 1,050 1,755 559 491 530/ C' 38,000 37,329 26,036 11,964 690/ £ 3,000 2,083 685 2,315 230/ 10,000 20,099 29,731 (19,731) 2970/ O 3,500 3,876 1,974 1,526 560/ Z 1,007,500 992,345 886,447 121,053 88°/ 2,500 1,880 3,678 (1,178) 1470/ O 50 100 - 50 00/ C 65,600 75,019 91,203 (25,603) 1390/ 350,900 252,860 420,610 (69,710) 1200/ to 4,000 15,658 14,084 (10,084) 3520/ 'C1 500 - 158 342 32°/ 3,000 2,960 4,440 (1,440) 1480/ 14,000 15,262 16,060 (2,060) 11501 LL 15,500 3,083 91 15,409 10/ s 900,662 94,929 417,317 483,345 460/ 1,300 - - 1,300 00/ O z 5,000 9,938 16,090 (11,090) 3220/ - - 2,660 (2,660) 00/ j 800 - 680 120 850/ CD 2,892,106 2,763,401 2,846,978 45,128 980/ 6,021,568 4,916,313 5,346,291 675,277 89F, 6 2021 Parks & Recreation Program Revenues are $322,388 higher than 2020 revenues. 22 Packet Pg. 25 1 2.1.a Page 3 of 3 CITY OF EDMO NDS REVENUES - GENERAL FUND 2021 Amended 11/30/2020 11/30/2021 Amount Title Budget Revenues Revenues Remaining %Received FINES AND PENALTIES: 1 PROOF OF VEHICLE INS PENALTY 2 TRAFFIC INFRACTION PENALTIES 3 NC TRAFFIC INFRACTION 4 CRT COST FEE CODE LEG ASSESSMENT (LGA) 5 NON -TRAFFIC INFRACTION PENALTIES 6 OTHER INFRACTIONS'04 7 PARKING INFRACTION PENALTIES 8 PARK/INDDISZONE 9 DWI PENALTIES 10 DUI - DP ACCT 11 CRIM CNV FEE DUI 12 DUI - DP FEE 13 CRIMINAL TRAFFIC MISDEMEANOR 8/03 14 CRIMINAL CONVICTION FEE CT 15 CRIM CONV FEE CT 16 OTHER NON-T RAF MISDEMEANOR PEN 17 OTHER NON TRAFFIC MISD. 8/03 18 COURT DV PENALTY ASSESSMENT 19 CRIMINAL CONVICTION FEE CN 20 CRIM CONV FEE CN 21 PUBLIC DEFENSE RECOUPMENT 22 BANK CHARGE FOR CONV. DEFENDANT 23 COURT COST RECOUPMENT 24 BUS. LICENSE PERMIT PENALTY 25 MISC FINES AND PENALTIES MISCELLANEOUS: 26 INVESTMENT INTEREST 27 INTEREST ON COUNTY TAXES 28 INTEREST - COURT COLLECTIONS 29 SPACE/FACILITIES RENTALS 30 BRACKET ROOM RENTAL 31 LEASES LONG TERM 32 DONATION/CONTRIBUTION 33 PARKS DONATIONS 34 BIRD FEST CONTRIBUTIONS 35 POLICE CONTRIBUTIONS FROM PRIV SOURCES 36 SALE OF JUNK/SALVAGE 37 SALES OF UNCLAIM PROPERTY 38 CONFISCATED AND FORFEITED PROPERTY 39 OTHERJUDGEMENT/SETTLEMENT 40 POLICE JUDGMENTSIRESTITUTION 41 CASHIERS OVERAGES✓SHORTAGES 42 OTHER MISCREVENUES 43 SMALL OVERPAYMENT 44 NSF FEES - PARKS & REC 45 NSF FEES - POLICE 46 NSF FEES - MUNICIPAL COURT 47 NSF FEES - DEVEL SERV DEPT 48 L&I STAY AT WORK PROGRAM 49 US BANK REBAT E TRANSFERS -IN: 50 OPERATING TRANSFER -IN 51 INTERFUND TRANSFER FROM FUND 018 52 INTERFUND TRANSFER FROM 511 53 TRANSFER FROM FUND 127 TOTAL GENERAL FUND REVENUE $ 2,000 $ 1,178 $ 2,292 $ (292) 11501 230,000 107,079 147,173 82,827 640/ 18,000 12,638 9,376 8,624 520/ 10,000 9,570 10,898 (898) 1090/ 1,000 1,980 7,903 (6,903) 7900/ 1,500 1,263 1,637 (137) 1090/ 100,000 65,852 43,932 56,068 440/ 2,000 1,066 447 1,553 220/ 7,000 9,180 6,342 658 910/ 300 198 73 227 240/ 100 36 67 33 670/ 1,500 2,167 1,516 (16) 1010/ 25,000 19,927 12,929 12,071 520/ 2,000 2,136 1,700 300 8501 700 503 96 604 140/ 100 37 12 88 120/ 10,000 6,580 2,062 7,938 210/ 800 967 330 470 410/ 1,000 678 241 759 240/ 200 86 89 ill 440/ 8,000 7,635 4,294 3,706 540/ 14,000 7,886 6,667 7,333 480/ 3,000 3,945 1,265 1,735 420/ 10,100 - - 10,100 00/ 150 1,441 187 (37) 1250/ 448,450 264,028 261,528 186,922 580, 155,090 271,547 261,347 (106,257) 1690/ 9,980 13,413 6,562 3,418 660/ 3,400 7,390 7,063 (3,663) 2080/ 153,000 24,010 85,353 67,647 560/ 2,100 380 - 2,100 00/ 205,000 154,822 175,213 29,787 850/ 2,500 910 225 2,275 90/ 3,500 920 750 2,750 210/ 2,000 635 2,010 (10) 1010/ 5,000 100 3,503 1,497 700/ 300 487 859 (559) 2860/ 3,000 3,586 6,592 (3,592) 2200/ 2,000 - - 2,000 00/ 2,000 1,344 3,444 (1,444) 1720/ 200 248 763 (563) 3810/ - 16 31 (31) 00/ 5,000 13,542 5,484 (484) 1100/ 100 60 79 21 790/ 100 30 60 40 600/ - - 30 (30) 00/ 150 142 - 150 00/ - 30 - - 00/ - - 7,893 (7,893) 00/ 8,500 7,251 9,153 (653) 1080/ 562,920 500,862 576,413 (13,493) 1020/ 278,667 - 28,445 250,222 100/ 123,581 - 123,581 - 1000/ - 1,500,000 - 1 00/ 26,300 35,800 13,150 13,150 5001 428,548 1,535,800 165,176 263,373 390, $ 42,490,777 $ 39,391,635 $ 41,509,313 $ 981,464 980i O Q. d C to C LL 21 t C O 2 T N 0 N L d E CD Z 23 Packet Pg. 26 I 2.1.a I Page 1 of 6 C ITY OF EDMONDS EXPENDITURES BY FUND - DETAIL 2021 Amended 11/30/2020 11/30/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent GENERAL FUND EXPENDITURES (001) 1 SALARIES AND WAGES $ 17,706,029 $ 15,148,871 $ 15,394,183 $ 2,311,846 8T 2 OVERTIME 491,580 564,915 641,339 (149,759) 130° 3 HOLIDAY BUY BACK 281,329 233,372 209,640 71,689 759 4 BENEFITS 6,801,704 5,830,538 5,688,212 1,113,492 849 5 UNIFORMS 89,151 76,959 67,465 21,686 76° 6 SUPPLIES 401,115 390,552 403,799 (2,684) 101° 7 FUEL CONSUMED - - 215 (215) 09 8 SMALL EQUIPMENT 108,603 156,325 208,563 (99,960) 192° 9 PROFESSIONAL SERVICES 15,037,824 12,025,030 11,607,620 3,430,204 7T 10 COMMUNICATIONS 160,995 129,517 170,899 (9,904) 1069 11 TRAVEL 68,760 9,644 33,521 35,239 499 12 EXCISE TAXES 6,500 14,622 23,244 (16,744) 35K 13 RENTAL/LEASE 1,574,465 1,655,006 1,394,875 179,590 899 14INSURANCE 403,973 393,746 405,121 (1,148) 1009 15 UTILITIES 536,762 448,729 515,781 20,981 96° 16 REPAIRS & MAINTENANCE 917,742 630,019 767,126 150,616 84° 17 MISCELLANEOUS 507,715 300,161 382,590 125,125 759 18 INTERGOVERNMENTAL PAYMENTS 50,000 75,000 50,000 - 1001, 19 INTERFUND SUBSIDIES 957,880 834,033 234,945 722,935 25° 20 MACHINERY/EQUIPMENT 23,120 9,053 23,120 - 1009 21 GENERAL OBLIGATION BOND PRINCIPAL 54,530 - - 54,530 0° 22 OTHER INTEREST & DEBT SERVICE COSTS 500 212 - 500 0° 23 INTEREST ON LONG-TERM EXTERNAL DEBT 5,700 69,285 60,087 (54,387) 10549 46,185,977 38,995,588 38,282,347 7,903,631 839 LEO FF-MEDIC AL INS. RESERVE(009) 24 BENEFITS $ 206,650 $ 134,758 $ 134,029 $ 72,621 659 25 PENSION AND DISABILITY PAYMENTS 252,990 91,339 100,038 152,952 409 26 PROFESSIONAL SERVICES 7,000 5,793 17,000 (10,000) 243° 27 MISCELLANEOUS 500 - - 500 0� 467,140 231,889 251,067 216,073 54° HISTORIC PRESERVATION GIFI'FUND (014) 28 SUPPLIES $ 100 $ - $ - $ 100 0� 29 PROFESSIONAL SERVICES 200 - 200 09 30 MISCELLANEOUS 5,600 - 5,600 09 $ 5,900 $ - $ $ 5,900 0° BUILDING MAINTENANCEFUND (016) 31 INTERFUND SUBSIDIES $ 210,222 $ - $ - $ 210,222 09 32 DEBT ISSUE COSTS - - 17,907 (17,907) 0` MARSH RESTORATION & PRESERVATION FUND (017) 33 PROFESSIONAL SERVICES $ 20,000 $ - $ 16,149 $ 3,851 8V 20,000 - 16,149 3,851 8V EDMONDS HOMELESSNESS RESPONSEFUND (018) 34 INTERFUND SUBSIDIES $ 123,581 $ - $ 123,581 $ - 100° 123,581 - 123,581 100° EDMONDS OPIOID RESPONSE FUND (019) 35 PROFESSIONAL SERVICES $ - $ 21,555 $ - $ 09 36 INTERFUND SUBSIDIES 28,445 - 28,445 100° 28,445 21,555 28,445 - 100° DRUG ENFORCEMEVTFUND (104) 37 PROFESSIONAL SERVICES $ 45,000 $ - $ - $ 45,000 0` 38 REPAIR/MAINT 800 - 800 0� 39 MISCELLANEOUS - 30,332 - 0� 45,800 30,332 45,800 0` 24 Packet Pg. 27 I 2.1.a I Page 2 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DEr'AIL 2021 Amended 11/30/2020 11/30/2021 Amount Title Budget Expenditures Expenditures Remaining % Spent S TREET FUND (111) 1 SALARIES AND WAGES $ 728,690 $ 603,371 $ 652,347 $ 76,343 909 2 OVERTIME 18,400 40,436 38,748 (20,348) 21 V 3 BENEFITS 381,336 298,334 318,964 62,373 84° 4 UNIFORMS 6,000 3,781 5,432 568 9V 5 SUPPLIES 263,000 159,814 139,989 123,011 53° 6 SMALL EQUIPMENT 20,000 684 3,565 16,435 1K 7 PROFESSIONAL SERVICES 23,210 2,456 9,170 14,040 40° 8 COMMUNICATIONS 4,500 6,754 5,835 (1,335) 130° 9 TRAVEL 1,000 - - 1,000 0° 10 RENTAL/LEASE 247,270 211,943 227,358 19,912 929 11 INSURANCE 148,436 156,937 148,533 (97) 100° 12 UTILITIES 280,918 235,918 226,246 54,672 8V 13 REPAIRS & MAINTENANCE 52,000 55,353 55,218 (3,218) 1069 14 MISCELLANEOUS 8,000 8,300 11,866 (3,866) 14K 15 MACHINERY/EQUIPMENT - 75,658 - - 09 16 GENERAL OBLIGATION BOND PRINCIPAL 4,220 - - 4,220 0° 17INTEREST 450 255 220 230 49° COMBINED STREErCONST/EMPROVE(112) 18 SALARIES AND WAGES 19 BENEFIT S 20 PROFESSIONAL SERVICES 21 REPAIR & MAINTENANCE 22 MISCELLANEOUS 23 INTERFUND SUBSIDIES 24 LAND 25 CONSTRUCTION PROJECTS 26 INTERGOVERNMENTAL LOANS 27 INTEREST MUNIC IPAL ARTS AC Q UIS. FUND (117) 28 SUPPLIES 29 SMALL EQUIPMENT 30 PROFESSIONAL SERVICES 31 TRAVEL 32 RENTAL/LEASE 33 REPAIRS & MAINTENANCE 34 MISCELLANEOUS MEMO RIAL S TREET TREE (118) 35 INTERFUND SUBSIDIES HO TEL/MO TEL TAX REVENUE FUND (120) 36 PROFESSIONAL SERVICES 37 MISCELLANEOUS 38 INTERFUND SUBSIDIES EMPLO YEE PARIONG PERMIT FUND (121) 39 SUPPLIES 40 PROFESSIONAL SERVICES YOUTH SCHOLARSHIP FUND (122) 41 MISCELLANEOUS TO URIS M PRO MO TIO NAL FUND/ARTS (123 ) 42 PROFESSIONAL SERVICES $ 2,187,430 $ 1,859,996 $ 1,843,491 $ 343,939 849 $ - $ 10,567 $ $ 0° - 6,613 - 09 1,581,847 307,373 980,233 601,614 62° 103,670 320,582 67,863 35,807 65° - 8 0° 114,950 40,121 39,925 75,025 359 33,000 - (842) 33,842 -3° 955,000 305,428 684,775 270,225 729 72,220 72,201 72,201 19 1009 1,610 1,952 1,591 19 99� $ 2,862,297 $ 1,064,847 $ 1,845,746 $ 1,016,551 64� $ 4,700 $ 302 $ 300 $ 4,400 6� 1,700 116 - 1,700 09 221,500 28,482 58,697 162,803 26° 80 - - 80 0° 2,000 - 2,000 09 300 - - 300 0° 6,600 1,466 3,774 2,826 57° $ 236,880 $ 30,367 $ 62,770 $ 174,110 269 $ 20,487 $ $ 20,487 $ 100` $ 20,487 $ - $ 20,487 $ 1001, $ 83,150 $ 45,603 $ 46,668 $ 36,482 56° - 612 - - 0° 4,000 4,000 2,000 2,000 509 $ 87,150 $ 50,215 $ 48,668 $ 38,482 56° $ 1,790 $ 632 $ 1,266 $ 524 7V 25,090 - - 25,090 0� $ 26,880 $ 632 $ 1,266 $ 25,614 5� $ 3,000 $ 450 $ 75 $ 2,925 3� $ 3,000 $ 450 $ 75 $ 2,925 3� $ 29,900 $ 10,399 $ 2,500 $ 27,400 K $ 29,900 $ 10,399 $ 2,500 $ 27,400 K Q 2$ Packet Pg. 28 I 2.1.a I Page 3 of 6 CITY OFEDMONDS EXPENDITURES BY FUND - DETAIL 2021 Amended 11/30/2020 11/30/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent REAL ESTATE EXCISE TAX (125) 1 SUPPLIES $ 121,000 $ 18,697 $ 63,483 $ 57,517 529 2 PROFESSIONAL SERVICES 195,626 328,398 206,481 (10,855) 1W 3 REPAIRS& MAINTENANCE 105,000 357,539 263,865 (158,865) 25V 4 INTERFUND SUBSIDIES 190 - - 190 W 5 CONSTRUCTION PROJECTS 1,179,482 780,889 60,390 1,119,092 5° $ 1,601,298 $ 1,485,522 $ 594,219 $ 1,007,079 37° REAL ESTATE EXCISE TAX 1 (126) 6 PROFESSIONAL SERVICES 7 REPAIRS& MAINTENANCE 8 INTERFUND SUBSIDIES 9 LAND 10 CONSTRUCTION PROJECTS 11 GENERAL OBLIGATION BONDS 12 INTEREST 13 OTHER INTEREST & DEBT SERVICE COSTS GIFTS CATALOG FUND (127) 14 SUPPLIES 15 PROFESSIONAL SERVICES 16 REPAIRS & MAINTENANCE 17 MISCELLANEOUS 18 INTERFUND SUBSIDIES CEVIEIERY MAINTEVANCETOPROVEMEVT(130) 19 SALARIES AND WAGES 20 OVERTIME 21 BENEFIT S 22 UNIFORMS 23 SUPPLIES 24 SUPPLIES PURCHASED FOR INVENTORY/RESALE 25 SMALL EQUIPMENT 26 PROFESSIONAL SERVICES 27 COMMUNICATIONS 28 TRAVEL 29 RENTAL/LEASE 30 UTILITIES 31 REPAIRS& MAINTENANCE 32 MISCELLANEOUS PARKS TRUST FUND (136) 33 PROFESSIONAL SERVICES CEVIEI'ERY MAINTENANCE TRUST FUND (137) 34 SMALL EQUIPMENT 35 MACHINERY/EQUIPMENT SISTER CITY COMMISSION (138) 36 SUPPLIES 37 TRAVEL 38 MISCELLANEOUS BUSINESS E\1PROVEMEVTDISTRICTFUND (140) 39 SUPPLIES 40 PROFESSIONAL SERVICES 41 MISCELLANEOUS EDMONDS RESCUEPLAN FUND (142) 42 PROFESSIONAL SERVICES 2012 LTGO DEBT SERVIC FUND (231) 43 GENERAL OBLIGATION BOND 44 INTEREST 45 DEBT ISSUE COSTS $ 573,234 $ 630,538 $ 339,712 $ 233,522 59° .r 97,050 258,039 194,829 (97,779) 20V O 138,910 12,963 11,863 127,048 99 y - - 47,063 (47,063) W 983,137 553,402 358,204 624,933 W 144,530 - - 144,530 W 117,050 1,484 1,282 115,768 v - 575 - - W C $ 2,053,911 $ 1,456,999 $ 952,952 $ 1,100,959 469 M 21 $ 67,500 $ 39,033 $ 22,203 $ 45,297 3Y -15 6,500 5,400 - 6,500 w C - 7,183 - w 600 335 - 600 W 26,300 35,800 13,150 13,150 50° G $ 100,900 $ 87,751 $ 35,353 $ 65,547 359 N L N $ 95,824 $ 86,562 $ 90,456 $ 5,368 949 0 3,500 729 482 3,018 14° d 40,472 37,084 35,829 4,643 891 C 1,000 - 490 510 499 Z 7,000 2,802 2,732 4,268 W 20,000 18,196 24,855 (4,855) 124° - 1,184 - - W 0 CL 4,200 795 1,445 2,755 34' 1,700 1,541 1,543 157 9 1 °0 500 - - 500 w 2 16,650 7,544 15,263 1,388 929 5,652 4,118 4,606 1,046 W 500 - - 500 W E 4,000 5,124 2,717 1,283 W L $ 200,998 $ 165,679 $ 180,417 $ 20,581 9w s $ 50,000 $ - $ $ 50,000 W $ 50,000 $ - $ $ 50,000 W $ 25,000 $ - $ - $ 25,000 0C - 19,211 (19,211) 0C $ 25,000 $ - $ 19,211 $ 5,789 77� $ 1,500 $ 11 $ $ 1,500 W 4,500 - 4,500 W 5,900 - 5,900 W $ 11,900 $ 11 $ $ 11,900 W $ 2,050 $ 9,585 $ 397 $ 1,653 199 70,035 38,175 47,372 22,663 6K 4,255 2,440 3,300 955 78° 76,340 50,200 51,070 25,271 679 $ 5,946,550 $ 1,698,013 $ 732,656 $ 5,213,894 12° 5,946,550 1,698,013 732,656 5,213,894 129 $ 677,990 $ - $ 2,653,457 $ (1,975,467) 39V 81,710 47,291 40,853 40,857 5W - - 60,455 (60,455) W $ 759,700 $ 47,291 $ 2,754,766 $ (1,995,066) 363° 26 Packet Pg. 29 I 2.1.a I Page 4 of 6 C ITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2021 Amended 11/30/2020 11/30/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent PARKS CONSTRUCTION FUND (332) 1 PROFESSIONAL SERVICES $ 113,453 $ 402,104 $ 1,027,610 $ (914,157) 906° 2 INTERFUND SUBSIDIES 44,000 20,316 - 44,000 0° 3 CONSTRUCTION PROJECTS 5,395,037 912,842 167,965 5,227,072 3° 4 DEBT ISSUE COSTS - - 6,652 (6,652) 0° $ 5,552,490 $ 1,335,262 $ 1,202,227 $ 4,350,263 22° WATER FUND (421) 5 SALARIES AND WAGES 6 OVERTIME 7 BENEFIT S 8 UNIFORMS 9 SUPPLIES 10 WATER PURCHASED FOR RESALE 11 SUPPLIES PURCHASED FOR INVENTORY/RESALE 12 SMALL EQUIPMENT 13 PROFESSIONAL SERVICES 14 COMMUNICATIONS 15 TRAVEL 16 EXCISE TAXES 17 RENTAL/LEASE 18 INSURANCE 19 UTILITIES 20 REPAIRS & MAINTENANCE 21 MISCELLANEOUS 22 INTERFUND SUBSIDIES 23 CONSTRUCTION PROJECTS 24 GENERAL OBLIGATION BONDS 25 REVENUE BONDS 26 INTERGOVERNMENTAL LOANS 27 INTEREST 28 DEBT ISSUE COSTS 29 OTHER INT EREST & DEBT SERVICE COSTS STORM FUND (422) 30 SALARIES AND WAGES 31 OVERTIME 32 BENEFIT S 33 UNIFORMS 34 SUPPLIES 35 SMALL EQUIPMENT 36 PROFESSIONAL SERVICES 37 COMMUNICATIONS 38 TRAVEL 39 EXCISE TAXES 40 RENTAL/LEASE 41 INSURANCE 42 UTILITES 43 REPAIR & MAINTENANCE 44 MISCELLANEOUS 45 INTERFUND SUBSIDIES 46 CONSTRUCTION PROJECTS 47 GENERAL OBLIGATION BONDS 48 REVENUE BONDS 49 INTERGOVERNMENTAL LOANS 50 INTEREST 51 DEBT ISSUE COSTS 52 OTHER INTEREST & DEBT SERVICE COSTS $ 793,475 $ 742,779 $ 593,498 $ 199,977 75° 24,000 18,958 20,700 3,300 86° 328,865 285,899 255,216 73,649 7K O 4,000 3,473 3,437 563 86° Q. 150,000 103,754 111,090 38,910 749 2,170,000 1,786,606 1,811,673 358,327 83° 170,000 143,823 173,841 (3,841) 102° 11,000 5,804 4,437 6,563 40° r- 1,558,701 1,186,381 1,138,791 419,910 7Y 30,000 25,763 26,822 3,178 899 IL 200 - - 200 0° >% 1,649,700 1,452,789 1,338,467 311,233 819 124,630 119,441 114,733 9,897 921 C 97,844 52,541 98,196 (352) 100° 2 35,775 24,571 25,735 10,040 729 r 258,130 20,613 158,521 99,609 61° C 123,600 120,680 158,376 (34,776) 12K cV 644,130 204,067 198,136 445,994 3V 1,976,050 3,121,887 1,321,534 654,516 679 .0 2,840 - 4,878,484 (4,875,644) 171778° d 385,100 - 385,100 01 > 25,840 25,839 25,839 1 100° z 196,170 105,907 194,975 1,195 99° - - 60,864 (60,864) 09 -t - 378 - w O $ 10,760,050 $ 9,551,953 $ 12,713,366 $ (1,953,316) 1189 $ 723,700 $ 584,113 $ 612,846 $ 110,854 85° 6,000 12,741 24,896 (18,896) 415° 318,735 267,341 261,498 57,237 82° 6,500 6,437 6,229 271 969 46,000 20,886 32,705 13,295 7V 4,000 2,026 304 3,696 K 2,728,016 1,673,878 1,423,907 1,304,109 52° 3,200 5,213 5,227 (2,027) 16Y 4,300 - 510 3,790 129 470,100 525,221 572,871 (102,771) 122° 267,778 247,669 241,501 26,277 90° 66,216 116,576 66,228 (12) 100° 11,025 11,024 12,031 (1,006) 109° 64,130 15,835 81,240 (17,110) 127° 255,300 158,483 237,214 18,086 9Y 281,810 78,897 76,327 205,483 279 1,581,000 3,166,559 336,293 1,244,707 2V 103,340 - 2,334,367 (2,231,027) 22599 188,240 - - 188,240 09 53,590 53,576 53,576 14 1009 110,910 60,769 104,914 5,996 959 - - 29,124 (29,124) 0° - 165 - - 09 $ 7,293,890 $ 7,007,409 $ 6,513,806 $ 780,084 89° 27 Packet Pg. 30 I 2.1.a I Page 5 of 6 CITY OF EDMO NDS EXPENDPTURES BY FUND - DETAIL 2021 Amended 11/30/2020 11/30/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent SEWER FUND (423) 1 SALARIES AND WAGES $ 2,027,508 $ 1,714,559 $ 1,617,061 $ 410,447 8W 2 OVERTIME 95,000 95,567 123,646 (28,646) 13W 3 BENEFITS 871,564 739,058 696,553 175,011 8W 4 UNIFORMS 8,500 7,693 8,518 (18) 10W 5 SUPPLIES 404,000 321,524 340,741 63,259 84° 6 FUEL CONSUMED 30,000 17,701 55,215 (25,215) 1849 7 SUPPLIES PURCHASED FOR INV OR RESALE 4,000 - - 4,000 W 8 SMALL EQUIPMENT 35,000 42,890 199,023 (164,023) 5699 9 PROFESSIONAL SERVICES 2,141,848 3,143,528 4,252,926 (2,111,078) 1999 10 COMMUNICATIONS 43,000 36,534 39,314 3,686 9V 11 TRAVEL 5,000 - 4,390 610 889 12 EXCISE TAXES 968,000 894,700 1,028,104 (60,104) 1069 13 RENTAL/LEASE 329,898 294,791 384,110 (54,212) 116° 14 INSURANCE 160,967 175,867 162,851 (1,884) 1019 15 UTILITIES 1,979,985 806,379 1,400,247 579,738 7V 16 REPAIR & MAINTENANCE 520,630 197,348 460,525 60,105 8K 17 MISCELLANEOUS 129,350 82,272 108,164 21,186 849 18 INTERFUND SUBSIDIES 10,180,936 83,575 5,277,735 4,903,201 529 19 MACHINERY/EQUIPMENT - 2,584,681 63,773 (63,773) W 20 CONSTRUCTION PROJECTS 19,756,808 5,023,028 8,434,910 11,321,898 43° 21 GENERAL OBLIGATION BONDS 157,060 - 825,114 (668,054) 525° 22 REVENUE BONDS 86,670 162,108 - 86,670 W 23 INTERGOVERNMENTAL LOANS 173,900 173,200 173,888 12 10W 24 INTEREST 382,660 36,505 218,498 164,162 579 25 DEBT ISSUE COSTS - 38,018 11,812 (11,812) W 26 OTHER INTEREST & DEBT SERVICE COSTS - 5,085 4,430 (4,430) W $ 40,492,284 $ 16,676,611 $ 25,891,548 $ 14,600,736 649 BOND RESERVE FUND (424) 27 REVENUE BONDS $ 785,020 $ - $ - $ 785,020 W 28 INTEREST 1,200,850 616,542 600,417 600,433 5W $ 1,985,870 $ 616,542 $ 600,417 $ 1,385,453 309 a 28 Packet Pg. 31 I 2.1.a I Page 6 of 6 CITY OF EDMO NDS EXPENDITURES BY FUND - DETAIL 2021 Amended 11/30/2020 11/30/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent EQ UIPMENT RENTAL FUND (511) 1 SALARIES AND WAGES $ 272,384 $ 246,472 $ 250,950 $ 21,434 929 2 OVERTIME 2,000 824 2,267 (267) 11Y 3 BENEFITS 116,481 102,469 102,328 14,153 8K 4 UNIFORMS 1,000 1,144 1,236 (236) 124° 5 SUPPLIES 120,000 69,800 68,360 51,641 57° 6 FUEL CONSUMED 1,000 - - 1,000 0° 7 SUPPLIES PURCHASED FOR INVENTORY/RESALE 258,000 103,592 142,095 115,905 559 8 SMALL EQUIPMENT 58,000 3,314 6,022 51,978 109 9 PROFESSIONAL SERVICES 46,750 4,387 1,262 45,488 39 10 COMMUNICATIONS 3,000 2,022 2,024 976 67° 11 TRAVEL 1,000 - - 1,000 09 12 RENTAL/LEASE 12,790 11,301 11,227 1,563 889 13 INSURANCE 40,910 43,001 39,334 1,576 969 14 UTILITIES 14,500 13,529 14,654 (154) 1019 15 REPAIRS & MAINTENANCE 60,000 39,369 41,400 18,600 69° 16 MISCELLANEOUS 12,000 9,408 12,529 (529) 1049 17 INTERFUND SUBSIDIES - 1,500,000 - - 0° 18 MACHINERY/EQUIPMENT 410,139 663,744 422,445 (12,306) 10Y $ 1,429,954 $ 2,814,377 $ 1,118,132 $ 311,822 78° TECHNOLOGY RENTAL FUND (512) 19 SALARIES AND WAGES $ 379,162 $ 265,409 $ 307,701 $ 71,461 8V 20 OVERTIME 2,000 165 2,781 (781) 139° 21 BENEFITS 127,657 89,101 95,613 32,044 759 22 SUPPLIES 5,000 8,726 4,393 607 88° 23 SMALL EQUIPMENT 141,300 112,405 40,483 100,817 299 24 PROFESSIONAL SERVICES 171,460 70,185 33,513 137,947 209 25 COMMUNICATIONS 58,770 56,619 61,268 (2,498) 104° 26 TRAVEL 1,500 - - 1,500 0° 27 RENTAL/LEASE 7,400 6,897 6,814 586 92° 28 REPAIRS& MAINTENANCE 302,660 291,331 437,442 (134,782) 145° 29 MISCELLANEOUS 5,000 11,552 4,087 913 82° 30 MACHINERY/EQUIPMENT 56,000 - - 56,000 0° $ 1,257,909 $ 912,391 $ 994,096 $ 263,813 799 FH IUMEN'S PENSION FUND (617) 31 BENEFITS $ 24,560 $ 18,045 $ 18,528 $ 6,032 75° 32 PENSION AND DISABILITY PAYMENTS 70,407 56,613 59,799 10,608 859 33 PROFESSIONAL SERVICES 1,200 1,007 11,500 (10,300) 9589 34 INTERFUND SUBSIDIES 40,000 - - 40,000 0° $ 136,167 $ 75,665 $ 89,826 $ 46,341 669 TOTAL EXPENDITURE ALL FUNDS $ 132,276,300 $ 86,277,947 $ 96,988,561 $ 35,287,738 7Y 29 Packet Pg. 32 2.1.a Page 1 of 1 C ITY O F IDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN SUMMARY 2021 Amended 11/30/2020 11/30/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent CITY COUNCIL OFFICE OF MAYOR HUMAN RESOURCES MUNICIPAL COURT CITY CLERK ADMINISTRATIVE SERVICES CITY ATTORNEY NON -DEPARTMENTAL POLICE SERVICES COMMUNITY SERVICES✓ECONOMIC DEV DEVELOPMENT SERVICES HUMAN SERVICES PROGRAM PARKS & RECREATION PUBLIC WORKS FACILITIES MAINTENANCE $ 432,478 $ 291,826 $ 302,438 $ 130,040 70% 345,501 303,765 311,403 34,098 90% 837,176 589,830 622,562 214,614 74% 1,252,513 958,702 1,083,397 169,116 86% O 757,055 667,373 514,141 242,914 68% d 1,178,545 1,219,675 1,229,187 (50,642) 104% O 936,480 789,302 772,130 164,350 82% 12,906,593 11,046,084 10,495,603 2,410,990 81% C IL 12,217,071 10,862,724 10,536,637 1,680,434 86% 624,198 532,055 533,780 90,418 86% z O 3,621,500 2,519,329 2,677,707 943,793 74% 2 599,402 - 81,615 517,787 14% T C 4,729,281 3,343,289 3,939,689 789,592 83% N i 3,305,285 2,870,124 2,944,895 360,390 89% N E 2,442,899 3,001,512 2,237,161 205,738 92% O C $ 46,185,977 $ 38,995,588 $ 38,282,347 $ 7,903,631 83% Z CITY OF EDMO NDS EXPENDITURES - UTILITY- BY FUND IN SUMMARY Title 2021 Amended Budget 11/30/2020 Expenditures 11/30/2021 Expenditures Amount Remaining %Spent WATER UTILITYFUND $ 10,760,050 $ 9,551,953 $ 12,713,366 $ (1,953,316) 118% STORM UTILITY FUND 7,293,890 7,007,409 6,513,806 780,084 89% SEWER/WWTP UTILITY FUND 40,492,284 16,676,611 25,891,548 14,600,736 64% BOND RESERVE FUND 1,985,870 616,542 600,417 1,385,453 30% $ 60,532,094 $ 33,852,515 $ 45,719,137 $ 14,812,957 76% 30 Packet Pg. 33 I 2.1.a I Page 1 of 2 C ITY OF EDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL Title 2021 Amended Budget 11/30/2020 Expenditures 11/30/2021 Expenditures Amount Remaining %Spent CITY COUNCIL SALARIES AND WAGES $ 200,052 $ 174,575 $ 185,001 $ 15,051 92% BENEFITS 118,713 90,616 95,221 23,492 80% SUPPLIES 2,000 2,205 1,919 81 96% SERVICES 111,713 24,431 20,296 91,417 18% $ 432,478 $ 291,826 $ 302,438 $ 130,040 70% O FFIC E O F MAYO R SALARIES AND WAGES $ 229,512 $ 204,891 $ 210,673 $ 18,839 92% BENEFITS 85,243 77,069 74,879 10,364 88% SUPPLIES 1,500 5,048 412 1,088 27% SERVICES 29,246 16,756 25,438 3,808 87% $ 345,501 $ 303,765 $ 311,403 $ 34,098 90% HUMAN RESOURCES SALARIES AND WAGES $ 387,048 $ 330,524 $ 334,072 $ 52,976 86% BENEFITS 154,430 130,836 124,832 29,598 81% SUPPLIES 13,600 4,817 1,271 12,329 9% SERVICES 282,098 123,652 162,388 119,710 58% $ 837,176 $ 589,830 $ 622,562 $ 214,614 74% MUNICIPAL C O URT SALARIES AND WAGES $ 738,297 $ 587,229 $ 636,182 $ 102,115 86% BENEFITS 243,859 211,537 205,550 38,309 84% SUPPLIES 11,600 13,007 7,838 3,762 68% SERVICES 235,637 146,929 210,707 24,930 89% MACHINERY/EQUIPMENT 23,120 23,120 100% $ 1,252,513 $ 958,702 $ 1,083,397 $ 169,116 86% C ITY CLERK SALARIES AND WAGES $ 397,226 $ 367,212 $ 235,682 $ 161,544 59% BENEFITS 169,669 149,762 94,748 74,921 56% SUPPLIES 7,000 6,180 3,392 3,608 48% SERVICES 183,160 144,219 180,319 2,841 98% $ 757,055 $ 667,373 $ 514,141 $ 242,914 68% ADMINISTRATIVE SERVICES SALARIES AND WAGES $ 795,289 $ 869,021 $ 847,262 $ (51,973) 107% BENEFITS 253,850 240,697 266,082 (12,232) 105% SUPPLIES 10,000 5,177 5,162 4,838 52% SERVICES 119,406 104,780 110,680 8,726 93% $ 1,178,545 $ 1,219,675 $ 1,229,187 $ (50,642) 104% CITY ATPO RNEY SERVICES $ 936,480 $ 789,302 $ 772,130 $ 164,350 82% $ 936,480 $ 789,302 $ 772,130 $ 164,350 92% NON -DEPARTMENTAL SALARIES AND WAGES $ 101,750 $ - $ - $ 101,750 0% BENEFITS 50,000 1,254 26,878 23,122 54% SUPPLIES 5,000 3,981 4,447 553 89% SERVICES 11,681,233 10,062,319 10,119,247 1,561,986 87% INTERFUND SUBSIDIES 1,007,880 909,033 284,945 722,935 28% DEBT SERVICE - PRINCIPAL 54,530 - - 54,530 0% DEBT SERVICE - INTEREST 6,200 69,497 60,087 (53,887) 969% $ 12,906,593 $ 11,046,084 $ 10,495,603 $ 2,410,990 81% PO LIC E SERVIC ES SALARIES AND WAGES $ 8,149,422 $ 7,083,301 $ 7,041,232 $ 1,108,190 86% BENEFITS 2,979,421 2,605,032 2,437,171 542,250 82% SUPPLIES 169,453 187,615 213,841 (44,388) 126% SERVICES 918,775 986,774 844,393 74,382 92% $ 12,217,071 $ 10,862,724 $ 10,536,637 $ 1,680,434 86% COMMUNITY SERVICES/ECON DEV. SALARIES AND WAGES $ 312,977 $ 321,647 $ 274,736 $ 38,241 88% BENEFITS 91,455 87,040 81,828 9,627 89% SUPPLIES 3,075 10,282 999 2,076 32% SERVICES 216,691 113,086 176,218 40,473 81% $ 624,198 $ 532,055 $ 533,780 $ 90,418 86% O Q. d C O C IL 21 t c O 2 N O N L d E O O Z 31 Packet Pg. 34 1 Page 2 of 2 C ITY O F IDMO NDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2021 Amended 11/30/2020 11/30/2021 Amount Title Budget Expenditures Expenditures Remaining %Spent DEVELOPMENT SERVICES/PLANNING SALARIES AND WAGES $ 1,875,514 $ 1,578,298 $ 1,669,634 $ 205,880 89% BENEFITS 693,217 568,092 576,316 116,901 83% SUPPLIES 19,400 8,725 12,002 7,398 62% SERVICES 1,033,369 364,214 419,755 613,614 41% MACHINERY/EQUIPMENT 0% $ 3,621,500 $ 2,519,329 $ 2,677,707 $ 943,793 74% HUMAN SERVICES PROGRAM SALARIES AND WAGES $ 79,510 $ $ 39,160 $ 40,350 49% BENEFITS 18,392 - 8,468 9,924 46% SUPPLIES 1,500 - 15,176 (13,676) 1012% SERVICES 500,000 - 18,811 481,189 4% 599,402 81,615 517,787 14% PARKS & REC RE.ATIO N SALARIES AND WAGES $ 2,329,689 $ 1,837,802 $ 2,092,016 $ 237,673 90% BENEFITS 828,746 685,595 734,815 93,931 89% SUPPLIES 138,790 145,656 169,367 (30,577) 122% SERVICES 1,432,056 665,183 943,491 488,565 66% MACHINERY/EQUIPMENT - 9,053 - - 0% $ 4,729,281 $ 3,343,289 $ 3,939,689 $ 789,592 83% PUBLIC WORKS ADMINIS TRATIO N SALARIES AND WAGES $ 300,162 $ 272,451 $ 338,754 $ (38,592) 113% BENEFITS 106,903 95,779 93,569 13,334 88% SUPPLIES 9,600 3,966 8,250 1,350 86% SERVICES 95,588 93,187 81,415 14,173 85% $ 512,253 $ 465,382 $ 521,987 $ (9,734) 102% FACILITIES MAINTENANCE SALARIES AND WAGES 791,470 727,305 732,837 58,633 93% BENEFITS 360,720 323,420 307,874 52,846 85% SUPPLIES 115,000 149,350 166,564 (51,564) 145% SERVICES 1,175,709 1,801,437 1,029,885 145,824 88% $ 2,442,899 $ 3,001,512 $ 2,237,161 $ 205,738 92% ENGINEERING SALARIES AND WAGES $ 1,791,020 $ 1,592,901 $ 1,607,920 $ 183,100 90% BENEFITS 736,237 640,767 627,447 108,790 85% SUPPLIES 2,200 868 1,937 263 88% SERVICES 263,575 170,206 185,604 77,971 70% $ 2,793,032 $ 2,404,742 $ 2,422,908 $ 370,124 87% TOTAL GENERAL FUND EXPENDITURES $ 46,185,977 $ 38,995,588 $ 38,282,347 $ 7,903,631 83% 32 Packet Pg. 35 2.1.a GENERAL FUND OVERVIEW CHANGE IN FUND BALANCES BALANCES GENERAL FUND ---- ACTUAL ---- ---- ACTUAL ---- & SUBFUNDS 1 1 /30/2021 11 /30/2021 Q3 YTD Fund Balance Cash Balance r_ 001-General Fund $ 17,095,713 $ 11,053,476 $ (2,802,094) $ 3,226,967 a 009-Leoff-Medical Ins. Reserve 286,109 286,110 (59,447.79) (251,067 012-Contingency Reserve Fund 1,782,149 1,782,150 0.21 - .v 014-Historic Preservation Gift Fund 19,688 19,689 0.14 2,500 016-Building Maintenance 4,610,221 4,610,221 - 4,400,000 LL 017 - Marsh Restoration & Preservation 848,617 848,616 (0.01) (15,999 >+ t Total General Fund & Subfunds $ 24,642,497 $ 18,600,261 $ (2,861,541) $ 7,362,400 *$2,000,000 of the General Fund Balance has been assigned by management for the development of Civic Field. g T_ N *$7,267,031of the fund balance in Fund 001 added to the $1,768,863 balance in Fund 012, represent the required 20% N operating reserve. There are no interfund loans outstanding at this time. 0 GOVERNMENTAL FUNDS OVERVIEW Z 1= 0 2 U CHANGE IN FUND FUND BALANCES BALANCES ii GOVERNMENTAL ---- ACTUAL ---- ---- ACTUAL ---- >' FUNDS 11 /30/2021 11 /30/2021 t Q3 YTD — 0 Fund Balance Cash Balance r N General Fund & Subfunds $ 24,642,497 $ 18,600,261 $ (2,861,541) $ 7,362,400 N Special Revenue 19,745,416 18,483,794 1,116,276 8,755,215 Capital Projects 7,037,612 6,845,887 (39,733) 884,102 E Total Governmental Funds $ 51,425,525 $ 43,929,943 $ (1,784,999) $ 17,001,717 0 c a� E t c� 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 FUND BALANCES CHANGE IN FUND BALANCES ---- ACTUAL ---- ---- ACTUAL ---- GOVERNMENTAL SPECIAL REVENUE 11/30/2021 11/30/2021 Q3 YTD Fund Balance Cash Balance 104 - Drug Enforcement Fund $ 76,326 $ 75,938 $ 472 $ 2,023 .-. 111 - Street Fund 843,295 697,971 (68,293) (295,115 o 112- Combined Street Const/Improve 2,342,174 1,828,505 289,417 260,510 m 117 - Municipal Arts Acquis. Fund 672,719 673,115 (9,230) (10,008 118 - Memorial Street Tree 137 - 128 (20,081 120 - Hotel/Motel Tax Revenue Fund 92,913 87,226 12,129 25,991 121 - Employee Parking Permit Fund 93,435 92,713 739 11,437 122 - Youth Scholarship Fund 14,448 14,356 202 621 >, 123 -Tourism Promotional Fund/Arts 104,435 101,595 9,880 24,097 125 - Real Estate Tax 4,392,232 4,079,872 436,295 1,820,250 0 126 - Real Estate Excise Tax 1 3,759,685 3,446,002 471,515 1,449,518 127 - Gifts Catalog Fund 321,916 319,907 9,501 23,852 c 130 - Cemetery Maintenance/Improvement 250,405 248,979 40,087 45,277 ci 136 - Parks Trust Fund 171,171 170,046 1,057 4,533 137 - Cemetery Maintenance Trust Fund 1,122,326 1,114,977 (4,382) 32,465 E 138 - Sister City Commission 13,166 13,096 81 2,803 > 0 140 -Business Improvement Disrict 44,070 44,071 (10,665) 24,919 ? 141 -Affordable and Supportive Housing I'd 151,176 144,480 23,198 72,736 142 - Edmonds Rescue Plan Fund 5,258,782 5,310,339 (85,857) 5,258,782 Q. 143 - Tree Fund 20,605 20,605 - 20,605 Total Special Revenue $ 19,745,416 $ 18,483,794 $ 1,116,276 $ 8,755,215 *$200,000 of the fund balance in Fund 126 has been reserved for Marsh Restoration Funding, as well as $500,000 for the purchase of Open Space. c ii ENTERPRISE FUNDS OVERVIEW '' 0 2 r N O N L FUND BALANCES CHANGE IN FUND ---- ACTUAL ---- ---- ACTUAL ---- aEi ENTERPRISE FUNDS 11/30/2021 11/30/2021 Q3 YTD o Fund Balance Cash Balance Z c 421 -Water Utility Fund $ 27,846,849 $ 7,115,086 $ 417,816 $ 2,147,197 422 -Storm Utility Fund * 15,687,365 6,372,118 733,175 2,096,676 423-Sewer/WWTPUtility Fund 51,218,706 16,476,010 564,437 (1,179,722 Q 424 - Bond Reserve Fund 843,971 843,971 3 10 411 -Combined Utility Operation 6,340 44,500 560 6,340 Total Enterprise Funds $ 95,603,231 $ 30,851,686 $ 1,715,991 $ 3,070,501 *$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 CHANGE IN FUND FUND BALANCES BALANCES CITY-WIDE ---- ACTUAL ---- ---- ACTUAL ---- 11 /30/2021 11 /30/2021 Q3 YTD Fund Balance Cash Balance Governmental Funds $ 51,425,525 $ 43,929,943 $ (1,784,999) $ 17,001,717 o Enterprise Funds 95,603,231 30,851,686 1,715,991 3,070,501 4' Internal Services Fund 10,325,490 5,802,159 146,413 371,071 Ta Agency Funds 45,289 45,289 (31,951) .v (89,826 Total City-wide Total $ 157,399,535 $ 80,629,077 $ 45,455 $ 20,353,463 LL 21 c 0 2 INTERNAL SERVICE FUNDS OVERVIEW o N L �c E i 0 yZ FUND BALANCES CHANGE IN FUND L Q. BALANCES ---- ACTUAL ---- ---- ACTUAL ---- — 0 INTERNAL SERVICE FUNDS 11 /30/2021 11 /30/2021 Q3 YTD Fund Balance Cash Balance c ii 511 - Equipment Rental Fund $ 9,349,143 $ 4,932,271 $ 33,545 $ 245,347 t 512 -Technology Rental Fund 976,348 869,888 112,868 c 125,724 0 Total Internal Service Funds $ 10,325,490 $ 5,802,159 $ 146,413 $ 371,071 N 0 N L d E 0 Z E ci 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 2.2 City Council Agenda Item Meeting Date: 01/14/2022 Eden Replacement (Continued) Staff Lead: Megan Menkveld Department: Administrative Services Preparer: Megan Menkveld Background/History Continuation of discussion from January 11, 2022 Finance Committee Meeting. Staff Recommendation Bring to full council at next opportunity for discussion and approval ideally before January 31, 2022. Narrative Packet Pg. 39