Loading...
HomeMy WebLinkAboutCOW 2021-05-24 Item 4B - COVID-19 - Year-End Financial Impact ReportCOUNCIL AGENDA SYNOPSIS "•+a�' 4iy+ Initials ITEMNO. 4. Meeting Date Prepared by Mayor's review Council review 05/24/21 Vicky 01\\,___ . _}.0 19Q8 ITEM INFORMATION STAFF SPONSOR: VICKY CARLSEN ORIGINAL AGENDA DATE: 5/24/21 AGENDA ITEM TITLE 2020 Year -End Financial Report CATEGORY 0 Mtg Discussion Date 5/24/21 ❑ Motion Mtg Date ❑ Resolution Mtg Date ❑ Ordinance Mtg Date ❑ Bid _Award Mtg Date ❑ Public Hearing Mtg Date ❑ Other Mtg Date SPONSOR ❑ Council ❑ Mayor ❑ Admin Svcs ❑ DCD 11 Finance ❑ Fire ❑ P&R ❑ Police ❑ PW SPONSOR'S COVID-19: 2020 Year -End Financial Results SUMMARY REVIEWED BY ❑ Trans&Infrastructure Svcs ❑ Community Svcs/Safety ❑ Finance & Governance ❑ Planning & Community Dev. ❑ LTAC ❑ Arts Comm. ❑ Parks Comm. ❑ Planning Comm. DATE: COMMITTEE CHAIR: RECOMMENDATIONS: SPONSOR/ADMIN. Finance COMMITTEE COST IMPACT / FUND SOURCE EXPENDITURE REQUIRED AMOUNT BUDGETED APPROPRIATION REQUIRED $ $ Fund Source: Comments: MTG. DATE RECORD OF COUNCIL ACTION 5/24/21 MTG. DATE ATTACHMENTS 5/24/21 Informational Memorandum dated 5/24/21 9 10 TO: CC: City of Tukwila Allan Ekberg, Mayor INFORMATIONAL MEMORANDUM City Council Mayor Ekberg FROM: Vicky Carlsen, Finance Director BY: Aaron Williams, Fiscal Manager DATE: May 24, 2021 SUBJECT: 2020 Year -End Financial Summary ISSUE The year-end financial report summarizes for the City Council the Citywide financial results and highlights significant items or trends through 2020. DISCUSSION 2020 was an unprecedented year due to the COVID-19 health emergency which negatively impacted local, state, and national economies. The pandemic resulted in stay-at-home orders with businesses closing to in-person activity for several weeks. Unemployment soared and many small businesses closed. The City's main revenue sources: sales, gambling, utility, and admission taxes, as well as user fees for recreation all declined. Initial estimates projected revenue losses could be as much as $12 million. In response to the projected revenue losses, the City reduced the operating budget in several ways. Staffing was reduced by freezing vacant positions, layoffs, furloughs, and pay reductions. Extra labor was virtually eliminated, and overtime was reduced. Travel and non-essential training were eliminated, and low priority programs were either reduced or eliminated. Each department performed a line -item budget scrub and reduced everywhere possible. Because the City took immediate steps and made the hard decisions early in the process, we were able to meet, and exceed, fund balance policy for the general fund. Highlights for 2020 are as follows: • General Fund revenues totaled $60.6 million and expenditures totaled $60.4 million. Unreserved fund balance in the General Fund ended the year at $12.6, exceeding reserve policy requirements by $1.1 million. • All General Fund departments finished the year under budget • Enterprise funds exceed reserve balance requirements • As part of the Public Safety Plan: o Justice Center opened in September o Fire Station 51 opened in September 11 INFORMATIONAL MEMO Page 2 • Completed construction of 53rd Ave S, from S 137th St to S 144th St. Project included new street improvements, drainage, curbs, gutters, driveway adjustments, new sidewalks, and undergrounding of utilities • Substantial completion of the Boeing Access Road over Airport Way bridge seismic retrofit. Project utilized federal Bridge Replacement Advisory Committee (BRAC) funding at 86.5% for design and 100% for construction • Began a 3 -year investment in the Southcenter Business District for extensive sewer rehabilitation • Refunded outstanding 2010 LTGO bonds resulting in savings of over $66 thousand in future debt service costs • Reserve policy met or exceeded in general fund, contingency fund, enterprise funds, and employee healthcare fund, sustaining healthy financial position ATTACHMENTS Year -End 2020 Financial Report • Highlights of 2020 • General Fund financial reports • Other Fund financial reports 12 CITY OF TUKWILA 2020 YEAR-END FINANCIAL REPORT Highlights General Fund and Contingency (Reserve) Fund Revenue and Expenditures, Ending Fund Balance General fund revenue was $60.6 million while general fund expenditures were $60.4 million. While revenue was $9.4 million below budget, expenditures were below budget by $9.2 million. Ending fund balance for the general fund is very close to the original adopted ending fund balance of $12.6 million, which exceeds reserve policy by approximately $1.1 million. $80,000 $70,000 $60,000 $50,000 j $40,000 0 t ~ $30,000 $20,000 $10,000 $- 14 General Fund 2020 Revenues & Expenditures Budget vs Actual $69,914 $69,602 $60,555 $60,404 Revenues Expenditures ■ 2020 Budget ■ 2020 Actual General Revenues — Taxes Sales and Use Tax Combined sales and use taxes brought in $17.0 million in 2020 which is $3.5 million under the annual budget but $81 thousand above the COVID projected budget. 2020 revenue represents a decline of 17% when compared to the prior year Sales and Use tax revenues. $22,000 $21,000 $20,493 0 $20,000 $19,000 s ~ $18,000 $17,000 $16,000 Sales Tax $20,579 20,432 20,444 2018 2019 $20,511 $17,036 \- $16,955 2020 --Actual --Budget COVID Projection Property Tax For 2020, property tax revenue totaled $16.2 million; an increase of $706 thousand when compared to the prior year. When compared to the annual budget, property taxes were $165 thousand below budget. The pandemic had minimal effect on property tax revenue in 2020. $17,000 $16,500 tn 16,000 t $15,500 $15,000 $15,279 Property Tax $15,923 $16,417 $15,177 2018 $15,546 2019 --Actual --Budget COVID Projection $16,306 $16,252 2020 15 Utility Tax For 2020, utility taxes were $662 thousand below budget with total revenue of $4.3 million. When compared to the prior year, utility taxes increased by almost $600 thousand. Total revenue for 2020 exceeded the COVID projection by $908 thousand primarily because businesses were able to reopen earlier than projected with higher indoor capacities allowed. $5,500 $5,000 ▪ $4,500 ro z • $4,000 $3,500 $3,000 Utility Tax $5,015 2018 2019 --Actual —8—Budget COVIDProjection 2020 Interfund Utility Tax was $2.15 million; $258 thousand under budget and a decline of $205 thousand compared to the prior year. Surface water interfund utility tax was largely unaffected by the pandemic because these charges are attached to property tax bills. Water and sewer were below budget due to businesses being closed during the early weeks of the pandemic but exceeded COVID expectations by $71 thousand largely because businesses were able to reopen earlier than projected with higher indoor occupancies. $2,500 $2,400 0 $2,300 t $2,200 H $2,100 $2,000 16 Interfund Utility Tax $2,412 $2,373 $2,335 $2,359 $2,205 $2,154 1 $2,083 2018 2019 2020 --Actual --Budget COVIDProjection Gambling Tax Gambling and excise taxes totaled $2.68 million for the year, which is $1.7 million below the annual budget. Gambling taxes exceeded the COVID projected budget by $346 thousand. $5,000 $4,500 $4,000 vi $3,500 t ~ $3,000 $2,500 $2,000 Admissions Tax Gambling and Excise Tax $4,045 $3,909 $4,426 $4,426 $3,999 2018 2019 2020 — —Actual —Budget COVID Projection $2,683 $2,337 Admissions tax totaled $208 thousand for the year, which is $661 thousand below the annual budget. Revenues were down $748 thousand compared to the prior year, which represents a 78% decline. Admissions taxes were significantly impacted by COVID-19 because movie theaters remained closed much longer than most other businesses. $1,200 $1,006 $1,000 • $800 • ra $774 $600 0 $400 $200 $- Admissions Tax $957 • $850 • $870 $550 $208 2018 2019 2020 —S—Actual — —Budget COVID Projection 17 General Revenues — Licenses and Permits Business Licenses Business license revenue totaled $4.7 million for the year, finishing $114 thousand above the annual budget. Revenues were more than $1.3 million above 2019, which represents a 39% increase over the prior year. $5,000 $4,500 $4,000 $3,500 0 t ~ $3,000 $2,500 $2,000 Business License Revenue $2,835 $2,810 $3,547 $3,400 $4,727 $4,612 $3,5/5 2018 2019 2020 --Actua I —e—Budget COVID Projection Building Permits Revenue from Building Permits and Fees was $1.9 million which is $166 thousand below the annual budget. Total revenue was below the COVID projections due to slowdown in permit issuance and delays in developers picking up approved permits due to cash flow and/or construction timing issues for contractors. $2,400 $2,200 $2,000 c $1,800 ro o $1,600 1— $1,400 $1,200 $1,000 18 Building Permits Revenue $2,231 $2,116 $1,975 $1,445 $2,319 — $2,127 $1,961 2018 2019 2020 Actual Budget COVID Projection Ongoing Expenditures Departmental Total Department expenditures for 2020 were $55.5 million, which is a decline of almost $3.3 million compared to the prior year. 520.0 518.0 516.0 $14.0 $8.0 $6.0 $4.0 $2.0 $- $10.0 $9.0 $8.0 $7.0 $6.0 $5.0 $4.0 $3.0 $2.0 $7.6 $6.7 518.0 $6.4 518.9 Departmental Expenditures 517.7 $12.4 $12.6 $12.9 Police Fire ■ 2018 ■ 2019 2020 Departmental Expenditures $5.0 $4.6_ $4.2 1 Public Works/Streets Parks/Recreation $3.5 $3.6 $3.3 DCD ■ 2018 ■ 2019 2020 $2.7 $2.5 $2.4 Mayor $9.5 $8.7 $8.7 Support 19 By Category Salaries and benefits were below budget by $3.7 million and declined by $770 thousand compared to the prior year. All other General Fund expenditures totaled $18.5 million which was $5.4 million below the annual budget and a decline of $4.1 million compared the prior year. $45.0 $40.0 $35.0 $30.0 o $25.0 2 $20.0 $15.0 $10.0 $5.0 $- 20 $40.7 General Fund Expenditures- By Category $42.7 $41.9 $21.8 $22.6 $18.5 Salaries and Benefits Supplies and Services ■ 2018 ■ 2019 2020 Fund Balance General Fund The General Fund ended 2020 with $12.6 million unreserved fund balance and exceeds reserve policy by approximately $1.1 million. The fund balance policy states that fund balance in the general shall equal or exceed 18% of the previous year general fund revenue, exclusive of significant non-operating, non-recurring revenue. The Contingency Fund ended the year with a fund balance of $6.45 million, which meets the fund balance policy requirement. The fund balance policy states that fund balance in the general shall equal or exceed 10% of the previous year general fund revenue, exclusive of significant non-operating, non-recurring revenue. $16.0 $14.0 $12.0 $10.0 0 _ $8.0 $6.0 $4.0 $2.0 $- General Fund, Contingency Fund Balances General Fund ■ 2018 ■ 2019 2020 Contingiency Fund FUND General Contingnecy Ending Fund Balance $ 12,726,364 $ 6,448,169 21 Other Funds Capital Projects Funds The City completed construction of 53rd Avenue South, from South 137th Street to South 144th Street, which included new street improvements, drainage, curbs, gutters, and driveway adjustments. It also included new sidewalks to this residential corridor, as well as undergrounding utility wires. The City issued bonds in a prior year to cover the General Fund portion of the project, the bulk of the financing. Water, Sewer, and Surface Water fees collected by the City paid for the corresponding utility improvements. A state Transportation Improvement Board grant was also instrumental in the funding of this project. The City also substantially completed construction of the Boeing Access Road over Airport Way Bridge Seismic Retrofit Project with funding from the federal Bridge Replacement Advisory Committee (BRAC). BRAC funded 86.5% of design and 100% of construction. Significant progress was made on all projects in the Public Safety Plan. Both the Justice Center and Fire Station 51 opened in September of 2020 and Fire Station 52 opened in early 2021. The Fire Department also purchased 2 vehicles, bunker gear, helmets, body armor, and some mobile data computers; all paid for by Public Safety Plan funds. Enterprise Funds The City's reserve policy states that, at the close of each fiscal year, unrestricted balances in Enterprise funds shall equal or exceed 20% of the prior year's revenue exclusive of the effects of GASB Statement 68 as well as significant non-operating, non-recurring revenues. At the close of the 2020 fiscal year, the unrestricted fund balances of the Enterprise funds comply with the City's reserve policy. Healthcare fund The Active Employees Insurance fund has an IBNR (incurred but not reported) reserve of 2.5 times the actuarily determined IBNR exceeding the reserve policy requirement of 1.5 times the actuarily determined IBNR. 22 CITY OF TUKWILA 2020 YEAR-END FINANCIAL REPORT General Fund Financial Reports GENERAL FUND REVENUE CITY OF TUKWILA Year to Date as of December 31, 2020 Row SUMMARY BY REVENUE TYPE BUDGET ACTUAL 2020 ANNUAL 2018 2019 2020 2020 BDGT VARIANCE to ALLOCATED BDGT % CHANGE % REC'D 2018/2019 2019/2020 1 PROPERTY TAX $ 16,416,911 $ 15,177,011 $ 15,545,878 $ 16,251,567 $ (165,344) 99% 2% 5% 2 SALES TAX -RETAIL 19,910,676 19,894,509 19,916,461 16,310,144 (3,600,532) 82% 0% (18)% 3 SALES TAX -CRIMINAL JUSTICE 600,000 598,300 662,161 725,890 125,890 121% 11% 10% 4 ADMISSIONS TAX 870,000 1,005,862 956,833 208,353 (661,647) 24% (5)% (78)% 5 UTILITY TAX 5,014,610 3,977,668 3,753,595 4,352,386 (662,224) 87% (6)% 16% 6 INTERFUND UTILITY TAX 2,412,000 2,334,522 2,358,608 2,153,573 (258,427) 89% 1% (9)% 7 GAMBLING & EXCISE TAX 4,426,000 3,908,742 3,998,515 2,682,681 (1,743,319) 61% 2% (33)% 8 TOTAL GENERAL REVENUE 49,650,197 46,896,613 47,192,051 42,684,593 (6,965,604) 86% 1% (10)% 9 BUSINESS LICENSES 4,612,400 2,835,458 3,399,729 4,726,731 114,331 102% 20% 39% 10 RENTAL HOUSING 45,000 64,895 39,523 50,483 5,483 112% (39)% 28% 11 BUILDING PERMITS 2,127,494 1,975,101 2,115,648 1,960,999 (166,495) 92% 7% (7)% 12 TOTAL LICENSES AND PERMITS 6,784,894 4,875,454 5,554,899 6,738,212 (46,682) 99% 14% 21% 13 SALES TAX MITIGATION - 1,025,820 655,127 - - 0% (36)% (100)% 14 FRANCHISE FEE 2,469,500 2,319,028 2,311,075 2,299,940 (169,560) 93% (0)% (0)% 15 GRANT REVENUE 1,571,016 1,032,141 770,078 1,080,530 (490,486) 69% (25)% 40% 16 STATE ENTITLEMENTS 446,250 418,029 539,001 505,925 59,675 113% 29% (6)% 17 INTERGOVERNMENTAL 558,639 577,243 561,318 559,209 570 100% (3)% (0)% 18 TOTAL INTERGOVERNMENTAL REVENUE 5,045,405 5,372,261 4,836,600 4,445,603 (599,802) 88% (10)% (8)% 19 GENERAL GOVERNMENT 59,532 29,512 58,494 28,580 (30,952) 48% 98% (51)% 20 SECURITY 840,500 383,826 665,306 1,029,927 189,427 123% 73% 55% 21 TRANSPORTATION 79,000 36,214 (7,884) 3,441 (75,559) 4% (122)% (144)% 22 PLAN CHECK AND REVIEW FEES 1,168,675 1,166,212 1,511,497 760,500 (408,175) 65% 30% (50)% 23 CULTURE AND REC FEES 621,000 526,771 525,919 41,731 (579,269) 7% (0)% (92)% 24 TOTAL CHARGES FOR SERVICES 2,768,707 2,142,534 2,753,332 1,864,178 (904,529) 67% 29% (32)% 25 FINES & PENALTIES 430,718 291,293 244,709 177,019 (253,699) 41% (16)% (28)% 26 MISC 1,297,017 2,120,128 1,309,046 908,503 (388,514) 70% (38)% (31)% 27 INDIRECT COST ALLOCATION 2,637,288 2,325,643 2,545,644 2,637,289 1 100% 9% 4% 28 TOTAL OTHER INCOME 4,365,023 4,737,064 4,099,399 3,722,811 (642,212) 85% (13)% (9)% 29 TOTAL OPERATING REVENUE 68,614,226 64,023,926 64,436,282 59,455,398 (9,158,828) 87% 1% (8)% 30 TRANSFERS IN 1,300,000 - - 1,100,000 (200,000) 85% 0% 0% 31 TOTAL REVENUE $ 69,914,226 $ 64,023,926 $ 64,436,282 $ 60,555,398 $ (9,358,828) 87% 0 (0) Percent of year 24 100% GENERAL FUND CITY OF TUKWILA GENERAL FUND EXPENDITURES Year -to -Date as of December 31, 2020 Percent of year completed 100% 25 EXPENDITURES BY DEPARTMENT BUDGET ACTUAL COMPARISON OF RESULTS 2020 ANNUAL 2018 2019 2020 Budget vs Actual OVER/(UNDER) % CHANGE EXPENDED 2018/ 2019 2019/ 2020 01 City Council $ 445,312 $ 374,120 $ 381,903 $ 351,396 $ (93,916) 79% 2% -8% 03 Mayor's Office 2,710,111 2,745,614 2,466,609 2,422,396 (287,715) 89% -10% -2% 04 Administrative Services 2,252,662 2,080,073 2,014,321 2,098,257 (154,405) 93% -3% 4% 05 Finance 2,802,249 2,713,267 2,392,462 2,402,140 (400,109) 86% -12% 0% 06 Attorney 710,730 982,922 654,866 640,785 (69,945) 90% -33% -2% 07 Recreation 3,464,074 3,093,303 3,355,041 2,604,825 (859,249) 75% 8% -22% 08 Community Development 3,859,081 3,514,858 3,556,063 3,275,874 (583,207) 85% 1% -8% 09 Municipal Court 1,345,060 1,295,591 1,297,382 1,292,626 (52,434) 96% 0% 0% 10 Police 19,390,720 17,967,227 18,907,947 17,682,031 (1,708,689) 91% 5% -6% 11 Fire 13,261,272 12,356,200 12,562,278 12,850,658 (410,614) 97% 2% 2% 12 Technology & Innovation Svcs 2,144,159 2,058,616 1,977,992 1,897,074 (247,085) 88% -4% -4% 13 Public Works 3,995,760 3,566,458 3,780,318 3,577,361 (418,399) 90% 6% -5% 15 Park Maintenance 1,682,579 1,515,219 1,676,131 1,644,001 (38,578) 98% 11% -2% 16 Street Maintenance & Operations 3,269,041 3,098,042 3,791,466 2,801,760 (467,281) 86% 22% -26% Subtotal 61,332,810 57,361,508 58,814,778 55,541,184 (5,791,626) 91% 3% -6% Transfers Out to: 20 Residential Streets 1,050,000 - 1,850,000 1,050,000 - 100% 0% -43% 20 Contingency Fund 210,000 164,877 402,841 - (210,000) 0% 144% -100% 20 Debt Service Transfers 3,637,190 4,434,966 3,661,986 3,490,499 (146,691) 96% -17% -5% 20 Land Acq. & Park Dev. 21,950 88,190 19,600 21,950 - 100% -78% 12% 20 General Gov't Improvements 200,000 200,000 200,000 - (200,000) 0% 0% -100% 20 City Facilities 2,850,000 - - - (2,850,000) 0% 0% 0% 20 Golf Course 300,000 300,000 300,000 300,000 - 100% 0% 0% Total Expenditures $ 69,601,950 $ 62,549,541 $ 65,249,205 $ 60,403,633 $ (9,198,317) 87% 4% -7% Percent of year completed 100% 25 GENERAL FUND CITY OF TUKWILA GENERAL FUND EXPENDITURES Year -to -Date as of December 31, 2020 Percent of year completed 26 100% SALARIES AND BENEFITS BUDGET ACTUAL COMPARISON OF RESULTS 2020 ANNUAL 2018 2019 2020 Budget vs Actual OVER/ UNDER ) % % CHANGE EXPENDED 2018/ 2019 2019/ 2020 11 Salaries $ 30,400,286 $ 27,508,645 $ 28,550,123 $ 28,119,885 $ (2,280,401) 92% 4% -2% 12 Extra Labor 770,709 697,233 819,391 131,789 (638,920) 17% 18% -84% 13 Overtime 1,354,099 1,506,318 1,724,479 1,367,623 13,524 101% 14% -21% 15 Holiday Pay 555,369 448,184 460,543 443,224 (112,145) 80% 3% -4% 21 FICA 2,105,462 1,783,129 1,858,800 1,739,528 (365,934) 83% 4% -6% 22 Pension-LEOFF 913,369 942,174 970,203 1,020,215 106,846 112% 3% 5% 23 Pension-PERS/PSERS 1,813,534 1,683,848 1,770,053 1,662,169 (151,365) 92% 5% -6% 24 Industrial Insurance 935,254 637,663 774,596 859,956 (75,298) 92% 21% 11% 25 Medical & Dental 6,803,608 5,478,650 5,745,036 6,486,004 (317,604) 95% 5% 13% 26 Unemployment 29,296 38,356 18,273 93,070 63,774 318% -52% 409% 28 Uniform/Clothing 8,525 5,675 6,353 4,734 (3,791) 56% 12% -25% Total Salaries & Benefits $ 45,689,511 $ 40,729,874 $ 42,697,850 $ 41,928,197 $ (3,761,314) 92% 5% 3% Percent of year completed 26 100% SUPPLIES, SERVICES AND CAPITAL BUDGET ACTUAL COMPARISON OF RESULTS 2020 ANNUAL 2018 2019 2020 Budget vs Actual OVER (UNDER) % CHANGE EXPENDED 2018/ 2019 2019/ 2020 0 Transfers $ 8,269,140 $ 5,188,033 $ 6,434,427 $ 4,862,449 $ (3,406,691) 59% 24% -24% 31 Supplies 1,162,582 1,119,174 1,506,788 893,023 (269,559) 77% 35% -41% 34 Items Purchased for resale 22,000 22,488 17,794 2,624 (19,376) 12% -21% -85% 35 Small Tools 134,060 86,790 111,793 140,071 6,011 104% 29% 25% 41 Professional Services 5,976,129 6,708,584 6,262,192 5,593,708 (382,421) 94% -7% -11% 42 Communication 450,189 439,626 396,598 482,845 32,656 107% -10% 22% 43 Travel 159,630 169,229 197,517 33,735 (125,895) 21% 17% -83% 44 Advertising 47,550 37,806 22,981 15,666 (31,884) 33% -39% -32% 45 Rentals and Leases 2,422,514 2,548,742 2,685,516 1,780,511 (642,003) 73% 5% -34% 46 Insurance 1,047,762 974,066 889,957 987,671 (60,091) 94% -9% 11% 47 Public Utilities 2,069,101 1,947,025 1,983,981 1,817,328 (251,773) 88% 2% -8% 48 Repairs and Maintenance 587,912 639,545 708,384 910,635 322,723 155% 11% 29% 49 Miscellaneous 1,293,870 1,858,527 1,224,377 949,675 (344,195) 73% -34% -22% 64 Machinery & Equipment 270,000 80,033 109,051 5,495 (264,506) 2% 36% -95% Total Operating Expenses 23,912,439 21,819,667 22,551,356 18,475,436 (5,437,003) 77% 3% -18% Total Expenses $ 69,601,950 $ 62,549,541 $ 65,249,205 $ 60,403,633 $ (9,198,317) 87% 4% -7% Percent of year completed 26 100% CITY OF TUKWILA 2020 YEAR-END FINANCIAL REPORT Other Funds Financial Reports City of Tukwila Contingency Fund 105 - Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: Miscellaneous Revenue Investment earnings $ 90,000 $ 46,191 $ (43,809) 51.3% Total Miscellaneous Revenue 90,000 46,191 (43,809) 51.3% Transfers in 210,000 (210,000) 0.0% Total Revenues 300,000 46,191 (253,809) 15.4% EXPENDITURES: Transfers Out 700,000 700,000 100.0% Total Expenditures 700,000 700,000 100.0% Change in fund balances Beginning Fund Balance (400,000) (653,809) 7,101,978 7,101,978 (253,809) 163.5% Ending Fund Balance $ 6,701,978 $ 6,448,169 $ (253,809) 96.2% 28 City of Tukwila Drug Seizure Fund 109 - Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: Miscellaneous Revenue Investment earnings $ - $ 1,356 $ 1,356 Seizure Revenue 55,000 103,193 48,193 Other - 12,948 12,948 Total Miscellaneous Revenue 187.6% 55,000 117,496 62,496 213.6% Total Revenues 55,000 117,496 62,496 213.6% EXPENDITURES: 31 Office & Operating Supplies 35 Small Tools & Minor Equipment 41 Professional Services 43 Travel 48 Repairs and Maintenance 49 Miscellaneous 25,000 14,789 (10,211) 11,000 2,631 (8,369) 8,000 16,190 8,190 11,000 (11,000) 4,070 4,070 59.2% 23.9% 202.4% 0.0% 5,000 5,000 100.0% Total Expenditures 60,000 42,681 (17,319) 71.1% Change in fund balances Beginning Fund Balance (5,000) 74,815 256,718 256,718 79,815 -1496.3% Ending Fund Balance $ 251,718 $ 331,534 $ 79,815 131.7% 29 City of Tukwila Hotel/Motel Tax Fund 101 Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: General Revenue Hotel/Motel Taxes Total General Revenue $ 800,000 $ 800,000 292,358 $ 292,358 (507,642) 36.5% (507,642) 36.5% Miscellaneous Revenue Investment earnings 3,000 13,036 10,036 434.5% CARES Act funding 30,878 30,878 100.0% Total Miscellaneous Revenue 33,878 43,914 10,036 129.6% Total Revenues 833,878 336,272 (497,606) 40.3% EXPENDITURES: 11 Salaries 87,464 57,622 (29,842) 65.9% 2* Personnel Benefits 18,800 19,017 217 101.2% 31 Office and operating supplies 5,000 350 (4,650) 7.0% 41 Professional Services 452,500 414,026 (38,474) 91.5% 43 Travel 10,000 1,219 (8,781) 12.2% 44 Advertising 113,586 73,538 (40,048) 64.7% 49 Miscellaneous 20,000 3,894 (16,106) 19.5% Indirect Cost Allocation 19,416 19,416 - 100.0% Total Expenditures 726,766 589,081 (137,685) 81.1% Change in fund balances Beginning Fund Balance 107,112 (252,809) 1,965,198 1,965,198 (359,921) -236.0% Ending Fund Balance $ 2,072,310 $ 1,712,389 $ (359,921) 82.6% 30 City of Tukwila Debt Service Funds 2XX - Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: Miscellaneous Revenue Investment earnings $ - $ 2,051 $ 2,051 Other 43,113 20,657 (22,456) 47.9% Total Miscellaneous Revenue 43,113 22,708 (20,405) 52.7% Transfers In Contributions SCORE Proceeds from refunded debt 4,170,540 4,023,849 426,658 1,995,000 (146,691) (426,658) 1,995,000 96.5% 0.0% Total Revenues 4,640,311 6,041,557 1,401,246 130.2% EXPENDITURES: 71 Debt Service Principal 83 Debt Service Interest 84 Debt Issue Costs Indirect Cost Allocation 1,844,647 2,795,246 3,636,461 2,402,093 31,600 1,791,814 (393,153) 31,600 197.1% 85.9% Total Expenditures 4,639,893 6,070,154 1,430,261 130.8% Change in fund balances Beginning Fund Balance 418 (28,598) (29,016) -6841.5% 453,537 449,693 Ending Fund Balance $ 453,955 $ 421,095 $ (29,016) 92.8% 31 City of Tukwila Debt Service UTGO - Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: General Revenue Property Taxes $ 3,713,175 $ 3,433,628 $ (279,547) 92.5% Total General Revenue 3,713,175 3,433,628 (279,547) 92.5% Miscellaneous Revenue Investment earnings - 43 43 Total Miscellaneous Revenue - 43 43 Total Revenues 3,713,175 3,433,671 (279,504) 92.5% EXPENDITURES: 71 Debt Service Principal 83 Debt Service Interest/Misc Fees 1,310,000 700,000 (610,000) 53.4% 2,403,175 2,812,537 409,362 117.0% Total Expenditures 3,713,175 3,512,537 (200,638) 94.6% Change in fund balances Beginning Fund Balance (78,866) (78,866) 88,825 88,825 Ending Fund Balance $ 88,825 $ 9,959 $ (78,866) 11.2% 32 City of Tukwila Debt Service LID, Guaranty Funds - Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: Miscellaneous Revenue LID Assesment Interest $ 223,913 $ 193,765 $ (30,148) 86.5% LID Assesment Principal 445,000 377,132 (67,868) 84.7% Misc Revenue - (5,430) (5,430) Total Miscellaneous Revenue 668,913 565,467 (103,446) 84.5% Total Revenues 668,913 565,467 (103,446) 84.5% EXPENDITURES: 71 Debt Service Principal 83 Debt Service Interest/Misc Fees 445,000 480,000 223,613 199,313 35,000 107.9% (24,301) 89.1% notal Expenditures 668,613 679,313 10,700 101.6% Change in fund balances Beginning Fund Balance 300 (113,845) (114,145) -37948.5% 1,457,230 1,457,230 Ending Fund Balance $ 1,457,530 $ 1,343,385 $ (114,145) 92.2% 33 City of Tukwila Street Fund 103 - Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: Intergovernmental Revenue Indirect Federal - Cascade View State Grant - 53rd Ave State Entitlements - MVFT Cities Total Intergovernmental Revenue Miscellaneous Revenue Charges for services Investment earnings Total Miscellaneous Revenue $ 3,454,000 $ 947,000 290,000 267,504 $ (3,454,000) (947,000) (22,496) 0.0% 0.0% 92.2% 4,691,000 20,000 267,504 (4,423,496) (145,296) (145,296) (20,000) 5.7% 0.0% 20,000 (145,296) Transfers In 1,050,000 (165,296) -726.5% 1,050,000 100.0% Total Revenues 5,761,000 1,172,207 (4,588,793) 20.3% EXPENDITURES: 11 Salaries - 102,362 102,362 13 Overtime - 124 124 2* Benefits - 44,553 44,553 31 Office and Operating Supplies - 1,309 1,309 35 Small Tools and Minor Equipment - 38,927 38,927 41 Professional Services 270,000 20,165 (249,835) 48 Repairs and Maintenance 130,000 (130,000) 6* Capital outlay 5,301,000 601,442 (4,699,558) 7.5% 0.0% 11.3% Total Expenditures 5,701,000 808,881 (4,892,119) 14.2% Change in fund balances Beginning Fund Balance 60,000 363,326 141,586 141,586 303,326 605.5% Ending Fund Balance $ 201,586 $ 504,912 $ 303,326 250.5% 34 City of Tukwila Arterial Street Fund 104 - Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: General Revenue Parking Tax $ 470,000 $ 200,057 $ (269,943) 43% MVFT Cities 137,000 137,423 423 100% Real Estate Excise Taxes 500,000 320,567 (179,433) 64% Total General Revenue 1,107,000 658,047 (448,953) 59.4% Charges for Sevices Park impact Fees Traffic Impact Fees Total Charges for Services Intergovernmental Revenue Federal Grants State Grants Total Charges for Services 300,000 213,000 406,731 (300,000) 0.0% 193,731 191.0% 513,000 406,731 6,724,000 1,113,845 2,253,000 266,854 (106,269) 79.3% (5,610,155) (1,986,146) 16.6% 11.8% 8,977,000 1,380,699 (7,596,301) 15.4% Miscellaneous Revenue Investment earnings 20,000 13,462 Contributions/Donations 30,000 12,200 (6,538) 67.3% (17,800) 40.7% Total Miscellaneous Revenue 50,000 25,662 (24,338) 51.3% Total Revenues 10,647,000 2,471,138 (8,175,862) 23.2% EXPENDITURES: 11 Salaries 356,352 325,893 (30,459) 91.5% 13 Overtime - 41 41 2* Benefits 130,917 123,143 (7,774) 94.1% 31 Office and Operating Supplies - 553 553 41 Professional Services 1,247,000 1,074,277 (172,723) 86.1% 44 Advertising - 274 274 47 Public Utility Services - 2,795 2,795 48 Repairs and Maintenance 1,325,000 303,115 (1,021,885) 22.9% Total Operating Expenses 3,059,269 1,830,091 (1,229,178) 59.8% Capital Expenses 6* Capital Outlay 8,378,000 1,115,605 (7,262,395) 13.3% 8,378,000 1,115,605 Trasnfers Out 675,106 (7,262,395) 13.3% 675,106 - 100.0% Total Expenditures 12,112,375 3,620,802 (8,491,573) 29.9% Change in fund balances Beginning Fund Balance (1,465,375) (1,149,663) 2,083,854 2,083,854 315,712 78.5% Ending Fund Balance $ 618,479 $ 934,190 $ 315,712 151.0% 35 City of Tukwila Land Acquisition, Rec and Park Development Fund 301 - Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: General Revenue Excess Prop Tax Levy - Dwmsh Hill $ 60,000 $ 309,197 $ 249,197 515.3% Real Estate Excise Taxes - 2,250 2,250 Total General Revenue 60,000 311,447 251,447 519.1 % Fees and Penalties Park Impact Fees Total Fees and Penalties 302,750 302,750 302,750 302,750 Intergovernmental Revenue State Grants- Duwamish Hill Preserve - 6,700 6,700 Total Charges for Services 6,700 6,700 Miscellaneous Revenue Investment earnings Total Miscellaneous Revenue 15,000 8,175 (6,825) 54.5% 15,000 8,175 Trasnfers In 716,506 (6,825) 54.5% 716,506 - 100.0% Total Revenues 791,506 1,345,578 554,072 170.0% EXPENDITURES: 11 Salaries 2* Benefits 31 Office and Operating Supplies 35 Small Tools and Minor Equipment 41 Professional Services Total Operating Expenses Capital Expenses 6* Capital Outlay 50,000 2,260 2,260 520 520 38,733 38,733 9,049 9,049 220,910 170,910 441.8% 50,000 271,472 25,000 221,472 542.9% (25,000) 0.0% 25,000 (25,000) 0.0% Total Expenditures 75,000 271,472 196,472 362.0% Change in fund balances Beginning Fund Balance 716,506 1,074,107 1,178,173 1,178,173 357,601 149.9% Ending Fund Balance $ 1,894,679 $ 2,252,280 $ 357,601 118.9% 36 City of Tukwila Facility Replacement Fund 302 Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: Miscellaneous Revenue Investment earnings $ 10,000 $ 35,328 $ 25,328 353.3% Total Miscellaneous Revenue 10,000 35,328 25,328 353.3% Total Revenues 10,000 35,328 25,328 353.3% EXPENDITURES: 2* Benefits - (12) (12) 41 Professional Services - 8,402 8,402 47 Public Utility Services - 11,182 11,182 Total Operating Expenses Capital Expenses 6* Capital Outlay Total Capital Expenses Transfers Out Indirect Cost Allocation 15,000 19,573 19,573 (15,000) 0.0% 15,000 3,353,000 3,153,000 (15,000) 0.0% (200,000) 94.0% Total Expenditures 3,368,000 3,172,573 (195,427) 94.2% Change in fund balances Beginning Fund Balance (3,358,000) (3,137,244) 220,756 93.4% 7,544,298 7,544,298 Ending Fund Balance $ 4,186,298 $ 4,407,054 $ 220,756 105.3% 37 City of Tukwila General Governmnet Improvements Fund 303 - Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: Miscellaneous Revenue Investment earnings $ 500 $ 4,269 $ 3,769 853.7% Total Miscellaneous Revenue 500 4,269 3,769 853.7% Transfers In 200,000 (200,000) 0.0% Total Revenues 200,500 4,269 (196,231) 2.1% EXPENDITURES: 11 Salaries 2* Benefits 31 Office and Operating Supplies 41 Professional Services 48 Repairs and Maintenance Total Operating Expenses Capital Expenses 65 Capital Outlay Total Capital Expenses 114,072 43,104 320,000 500 (113,572) 251 (42,853) 1,399 1,399 (320,000) 145,776 145,776 0.4% 0.6% 0.0% 477,176 147,926 180,838 (329,250) 31.0% (180,838) 0.0% 180,838 (180,838) 0.0% Total Expenditures 658,014 147,926 (510,088) 22.5% Change in fund balances Beginning Fund Balance (457,514) (143,658) 656,306 656,306 313,856 31.4% Ending Fund Balance $ 198,792 $ 512,648 $ 313,856 257.9% 38 City of Tukwila Fire Impact Fees Fund 304- Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: Charges for Sevices Fire Impact Fees $ 500,000 $ 113,843 $ (386,157) 22.8% Total Charges for Services 500,000 113,843 (386,157) 22.8% Miscellaneous Revenue Investment earnings 100 1,773 1,673 1773.1% Total Miscellaneous Revenue 100 1,773 1,673 1773.1 % Total Revenues 500,100 115,616 (384,484) 23.1% EXPENDITURES: Trasnfers Out 500,000 428,775 (71,225) 85.8% Total Expenditures 500,000 428,775 (71,225) 85.8% Change in fund balances Beginning Fund Balance 100 (313,159) (313,259) -313158.6% 313,159 313,159 Ending Fund Balance $ 313,259 $ - $ (313,259) 0.0% 39 City of Tukwila Public Safety Plan Fund 305- Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: General Revenue Mitigation Fees (Tukwila South) $ 300,000 $ 300,000 $ Excise Tax 500,000 318,317 Sales Tax Mitigation 1,000,000 439,636 Total Intergovernmental Revenue Miscellaneous Revenue Investment earnings CARES Act funding Proceeds from sales of Capital Assets Total Miscellaneous Revenue Transfers In (181,683) (560,364) 100.0% 63.7% 44.0% 1,800,000 1,057,953 100,000 497,247 1,000,000 200,354 497,247 (742,047) 58.8% 100,354 200.4% 100.0% (1,000,000) 0.0% 1,597,247 697,601 3,536,709 3,181,775 (899,646) 43.7% (354,934) 90.0% Total Revenues 6,933,956 4,937,329 (1,996,627) 71.2% EXPENDITURES: 31 Office and Operating Supplies 35 Small Tools and Minor Equipment 41 Professional Services 45 Operating Rentals & Leases 47 Public Utility Services 6* Capital Outlay 28,146 50,657,247 77,190 92,946 15,800 10,969 55,272 45,677,933 77,190 64,800 15,800 10,969 55,272 (4,979,314) 330.2% 90.2% 50,685,393 45,930,110 Transfer Out 340,000 (4,755,283) 90.6% 147,693 (192,307) 43.4% Total Expenditures 51,025,393 46,077,803 (4,947,590) 90.3% Change in fund balances Beginning Fund Balance (44,091,437) (41,140,475) 44,304,737 44,304,737 2,950,962 93.3% Ending Fund Balance $ 213,300 $ 3,164,263 $ 2,950,962 1483.5% 40 City of Tukwila City Facilities Fund 306- Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: Miscellaneous Revenue Investment earnings $ - $ 37,423 $ 37,423 Total Miscellaneous Revenue 37,423 37,423 Trasnfers In 4,000,000 0 (4,000,000) 0.0% Total Revenues 4,000,000 37,423 (3,962,577) 0.9% EXPENDITURES: 6* Capital Outlay 5,066,881 997,705 (4,069,176) 19.7% 5,066,881 997,705 Transfer Out 283,709 (4,069,176) 19.7% (283,709) 0.0% Total Expenditures 5,350,590 997,705 (4,352,885) 18.6% Change in fund balances Beginning Fund Balance (1,350,590) (960,282) 5,961,144 5,961,144 390,308 71.1% Ending Fund Balance $ 4,610,554 $ 5,000,862 $ 390,308 108.5% 41 City of Tukwila Water Fund 401 - Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: Charges for Services Water Sales $ 7,388,000 $ 6,165,501 $ (1,222,499) 83.5% Security 330 330 Total Charges for Services 7,388,000 6,165,831 (1,222,169) 83.5% Miscellaneous Revenue Investment earnings Connection Fees CARES Act funding Other Total Miscellaneous Revenue 36,000 88,910 52,910 247.0% 100,000 78,638 (21,362) 78.6% 2,324 2,324 - 100.0% 400 400 138,324 170,272 31,948 123.1% Trasnfers In - 5,947 5,947 Total Revenues 7,526,324 6,342,050 (1,184,274) 84.3% EXPENDITURES: 11 Salaries 623,697 567,158 (56,539) 90.9% 12 Extra Labor 4,000 (4,000) 0.0% 13 Overtime 7,000 7,589 589 108.4% 2* Benefits 308,350 222,649 (85,701) 72.2% 31 Office and Operating Supplies 144,306 105,897 (38,409) 73.4% 33 Water Purchased for Resale 3,152,000 2,760,415 (391,585) 87.6% 35 Small Tools and Minor Equipment 11,000 9,847 (1,153) 89.5% 41 Professional Services 514,500 125,375 (389,125) 24.4% 42 Communication 2,500 7,549 5,049 302.0% 43 Travel 1,500 1,241 (259) 82.7% 44 Advertising 531 531 - 45 Operating Rentals and Leases 180,311 189,605 9,294 105.2% 46 Insurance 21,661 19,131 (2,530) 88.3% 47 Public Utility Services 26,386 22,256 (4,130) 84.3% 48 Repairs and Maintenance 15,000 18,633 3,633 124.2% 49 Miscellaneous 1,089,000 978,613 (110,387) 89.9% Total Operating Expenses 6,101,211 5,036,487 (1,064,724) 82.5% Capital Expenses 6" Capital Outlay 1,720,000 21,385 (1,698,615) 1.2% 7* Debt Service Principal 135,801 135,799 (2) 100.0% 8* Debt Service Interest 192,952 9,799 (183,153) 5.1% Transfer Out Indirect Cost Allocation 2,048,753 166,984 (1,881,769) 8.2% 402,339 197,423 (204,916) 49.1% 684,977 684,977 100.0% Total Expenditures 9,237,280 6,085,870 (3,151,410) 65.9% Change in fund balances (1,710,956) 256,179 1,967,135 -15.0% Beginning Fund Balance 6,170,864 6,170,864 Ending Fund Balance $ 4,459,908 $ 6,427,043 $ 1,967,135 144.1% 42 City of Tukwila Sewer Fund 402 - Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: Charges for Services Sewer Sales $ 9,732,000 $ 8,453,169 $ (1,278,831) 86.9% Road/Street Repair Charges - 51,672 51,672 - Total Charges for Services 9,732,000 8,504,840 (1,227,160) 87.4% Miscellaneous Revenue Investment earnings Connection Fees CARES Act funding Total Miscellaneous Revenue 55,000 97,202 125,000 142,800 181 181 42,202 17,800 176.7% 114.2% 100.0% 180,181 240,183 60,002 133.3% Total Revenues 9,912,181 8,745,023 (1,167,158) 88.2% EXPENDITURES: 11 Salaries 395,516 441,433 45,917 111.6% 13 Overtime 4,442 3,889 (553) 87.5% 2* Benefits 193,295 144,545 (48,750) 74.8% 31 Office and Operating Supplies 21,781 27,437 5,656 126.0% 33 Metro Sewage Treatment 4,762,000 4,658,117 (103,883) 97.8% 35 Small Tools and Minor Equipment 5,000 1,917 (3,083) 38.3% 41 Professional Services 403,000 169,914 (233,086) 42.2% 42 Communication 2,500 8,004 5,504 320.2% 43 Travel 2,000 36 (1,964) 1.8% 44 Advertising 150 1,493 1,343 995.4% 45 Operating Rentals and Leases 113,640 102,765 (10,875) 90.4% 46 Insurance 12,667 11,375 (1,292) 89.8% 47 Public Utility Services 45,000 34,122 (10,878) 75.8% 48 Repairs and Maintenance 49,000 276,240 227,240 563.8% 49 Miscellaneous 1,188,700 1,042,497 (146,203) 87.7% Total Operating Expenses 7,198,691 6,923,784 (274,907) 96.2% Capital Expenses 6* Capital Outlay 1,500,000 - (1,500,000) 0.0% 7* Debt Service Principal 330,537 330,536 (1) 100.0% 8* Debt Service Interest 128,194 25,460 (102,734) 19.9% Transfer Out Indirect Cost Allocation 1,958,731 355,996 (1,602,735) 18.2% 737,837 113,289 (624,548) 15.4% 522,167 522,167 - 100.0% Total Expenditures 10,417,426 7,915,237 (2,502,189) 76.0% Change in fund balances Beginning Fund Balance (505,245) 829,786 12, 529, 586 12, 529, 586 1,335,031 -164.2% Ending Fund Balance $ 12,024,341 $ 13,359,372 $ 1,335,031 111.1% 43 City of Tukwila Golf Course Fund 411 - Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: General Revenue Excise Taxes $ 2,900 $ 1,925 $ (975) 66.4% Total General Revenue 2,900 1,925 (975) 66.4% Charges for Services Sale of Merchandise Green Fees, Instruction Total Charges for Services 126,000 143,192 17,192 1,220,043 1,391,293 171,250 113.6% 114.0% 1,346,043 1,534,485 188,442 114.0% Miscellaneous Revenue Investment earnings 500 3,477 2,977 695.4% Rents and Concessions 309,000 342,557 33,557 110.9% CARES Act funding 5,446 5,446 100.0% Other 22,000 23,911 1,911 108.7% Total Miscellaneous Revenue 336,946 375,391 38,445 111.4% Trasnfersln 511,724 511,724 100.0% Total Revenues 2,197,613 2,423,525 225,912 110.3% EXPENDITURES: 11 Salaries 609,976 547,753 (62,223) 89.8% 12 Extra Labor 44,484 52,380 7,896 117.8% 13 Overtime 3,645 3,841 196 105.4% 2* Benefits 320,900 243,642 (77,258) 75.9% 31 Office and Operating Supplies 116,183 130,044 13,861 111.9% 34 Items purcashed for resale 99,000 121,605 22,605 122.8% 35 Small Tools and Minor Equipment 13,777 16,480 2,703 119.6% 41 Professional Services 6,580 17,911 11,331 272.2% 42 Communication 7,968 8,399 431 105.4% 43 Travel 407 382 (25) 93.8% 44 Advertising 8,500 11,444 2,944 134.6% 45 Operating Rentals and Leases 198,200 31,036 (167,164) 15.7% 46 Insurance 22,621 24,392 1,771 107.8% 47 Public Utility Services 74,935 59,684 (15,251) 79.6% 48 Repairs and Maintenance 40,165 24,390 (15,775) 60.7% 49 Miscellaneous 108,500 71,653 (36,847) 66.0% Total Operating Expenses 1,675,841 1,365,037 (310,804) 81.5% Capital Expenses 6* Capital Outlay 30,758 109,484 78,726 356.0% Transfer Out Indirect Cost Allocation 30,758 109,484 78,726 356.0% 500 500 100.0% 196,512 196,512 100.0% Total Expenditures 1,903,611 1,671,533 (232,078) 87.8% Change in fund balances 294,002 751,992 457,990 255.8% Beginning Fund Balance 197,488 197,488 Ending Fund Balance $ 491,490 $ 949,481 $ 457,990 193.2% 44 City of Tukwila Surface Water Fund 412 - Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: Charges for Services Surface Water Sales Total Charges for Services $ 6,863,000 $ 6,925,263 $ 62,263 100.9% 6,863,000 6,925,263 62,263 100.9% Intergovernmental Revenue 1,077,000 1,069,259 (7,741) 99% Miscellaneous Revenue Investment earnings 50,000 29,458 (20,542) 58.9% Gifts and Bequests 12,500 12,500 CARES Act funding 4,346 4,346 100.0% Other - 1,981 1,981 Total Miscellaneous Revenue 54,346 48,285 (6,061) 88.8% Total Revenues 7,994,346 8,042,808 48,462 78.5% EXPENDITURES: 11 Salaries 1,102,764 1,067,136 (35,628) 96.8% 12 Extra Labor 8,000 - (8,000) 0.0% 13 Overtime 9,000 14,267 5,267 158.5% 2* Benefits 517,587 375,981 (141,606) 72.6% 31 Office and Operating Supplies 87,639 21,522 (66,117) 24.6% 35 Small Tools and Minor Equipment 5,000 1,620 (3,380) 32.4% 41 Professional Services 1,432,862 1,032,942 (399,920) 72.1% 42 Communication 2,084 7,953 5,869 381.6% 43 Travel 2,000 1,011 (989) 50.5% 44 Advertising 500 2,897 2,397 579.5% 45 Operating Rentals and Leases 408,927 432,110 23,183 105.7% 46 Insurance 29,784 32,316 2,532 108.5% 47 Public Utility Services 107,820 61,244 (46,576) 56.8% 48 Repairs and Maintenance 37,000 62,654 25,654 169.3% 49 Miscellaneous 747,300 796,281 48,981 106.6% Total Operating Expenses 4,498,267 3,909,935 (588,332) 86.9% Capital Expenses 6* Capital Outlay 1,337,000 1,273,847 (63,153) 95.3% 7* Debt Service Principal 289,748 289,746 (2) 100.0% 8* Debt Service Interest 261,025 9,095 (251,930) 3.5% Transfer Out Indirect Cost Allocation 1,887,773 1,572,688 (315,085) 83.3% 562,124 247,534 (314,590) 44.0% 684,699 684,699 100.0% Total Expenditures 7,632,863 6,414,856 (1,218,007) 84.0% Change in fund balances 361,483 1,627,952 1,266,469 450.4% Beginning Fund Balance 3,206,726 3,206,726 Ending Fund Balance $ 3,568,209 $ 4,834,677 $ 1,266,469 135.5% 45 City of Tukwila Equipment Rental/Replacement Fund 501 Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: Charges for Services ERR O&M Dept Charges Equipment Replacement Charges Total Charges for Services $ 2,104,488 $ 1,523,440 $ (581,048) 72.4% 732,637 593,580 (139,057) 81.0% 2,837,125 2,117,021 (720,104) 74.6% Miscellaneous Revenue Investment earnings 14,269 32,459 18,190 227.5% Insurance Proceeds 30,000 114,057 84,057 380.2% CARES Act funding 3,894 3,894 - 100.0% Other 150 1,072 922 714.7% Total Miscellaneous Revenue 48,313 151,482 103,169 313.5% Sale of Capital Assets - 50,264 50,264 Transfers In 340,000 147,693 (192,307) 43.4% Total Revenues 3,225,438 2,466,460 (758,978) 76.5% EXPENDITURES: 11 Salaries 417,479 299,748 (117,731) 71.8% 12 Extra Labor 32,000 - (32,000) 0.0% 13 Overtime 1,858 138 (1,720) 7.4% 2* Benefits 221,313 123,486 (97,827) 55.8% 31 Office and Operating Supplies 3,358 2,547 (811) 75.9% 34 Items Purchased for Resale 750,000 399,853 (350,147) 53.3% 35 Small Tools and Minor Equipment 5,000 4,855 (145) 97.1% 41 Professional Services 4,000 5,078 1,078 126.9% 42 Communication 2,000 4,860 2,860 243.0% 43 Travel 1,500 - (1,500) 0.0% 44 Advertising - 599 599 45 Operating Rentals and Leases 75,506 83,162 7,656 110.1% 46 Insurance 72,295 92,063 19,768 127.3% 48 Repairs and Maintenance 120,000 64,922 (55,078) 54.1% 49 Miscellaneous 12,000 14,798 2,798 123.3% 64 Capital Outlay 1,691,800 1,716,058 24,258 101.4% Transfers Out 211,724 211,724 - 100.0% Indirect Cost Allocation 381,412 381,412 - 100.0% Total Expenditures 4,003,245 3,405,304 (597,941) 85.1% Change in fund balances (777,807) (938,844) (161,037) 120.7% Beginning Fund Balance 4,842,041 4,842,041 Ending Fund Balance $ 4,064,234 $ 3,903,196 $ (161,037) 96.0% 46 City of Tukwila Insurance Fund 502 - Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: Charges for Services Employee Benefit Programs $ 1,200 $ 26 $ (1,174) 2.2% Total Charges for Services 1,200 26 (1,174) 2.2% Miscellaneous Revenue Investment earnings 56,274 13,928 (42,346) 24.8% Employee Trust Contibutions 7,042,150 6,630,773 (411,377) 94.2% Employer Trust Contributions 366,399 157,710 (208,689) 43.0% Total Miscellaneous Revenue 7,464,823 6,802,411 (662,412) 91.1% Total Revenues 7,466,023 6,802,438 (663,585) 91.1% EXPENDITURES: 25 Medical, Dental, Life, Optical 41 Professional Services 49 Miscellaneous 7,208,130 35,600 20,268 Indirect Cost Allocation 148,106 6,486,565 90,000 7,440 (721,565) 54,400 (12,828) 90.0% 252.8% 36.7% 148,106 100.0% Total Expenditures 7,412,104 6,732,110 (679,994) 90.8% Change in fund balances Beginning Fund Balance 53,919 70,327 16,408 130.4% 17,215 17,215 Ending Fund Balance $ 71,134 $ 87,542 $ 16,408 123.1% 47 City of Tukwila LEOFF Insurance Fund 503 - Revenue and Expenditures As of December 31, 2020 2020 Variance Annual Actual Over/(Under) % of Annual Budget Year -End Results Budget Budget REVENUE: Miscellaneous Revenue Investment earnings $ 1,541 $ 21,631 $ 20,090 1403.7% Employer Trust Contributions 265,000 254,868 (10,132) 96.2% Total Miscellaneous Revenue 266,541 276,499 9,958 103.7% Total Revenues 266,541 276,499 9,958 103.7% EXPENDITURES: 25 Medical, Dental, Life, Optical 484,079 41 Professional Services 4,734 49 Miscellaneous 500 Indirect Cost Allocation 374,959 (109,120) 77.5% (4,734) 0.0% (500) 0.0% Total Expenditures 489,313 374,959 (114,354) 76.6% Change in fund balances Beginning Fund Balance (222,772) (98,459) 124,313 44.2% 435,054 435,054 Ending Fund Balance $ 212,282 $ 435,054 $ 107,271 204.9% 48