Loading...
HomeMy WebLinkAboutCOW 2020-12-14 Item 4B - COVID-19 - Financial Impact ReportITEM INFORMATION STAFF SPONSOR: VICKY CARLSEN ORIGINAL AGENDA DATE: 12/14/20 AGENDA ITEM TITLE December Financial Update including COVID related data CATEGORY Motion Resolution Ordinance Bid Award Public Hearing Other Discussion Mtg Date 12/14/20 Mtg Date Mtg Date Mtg Date Mtg Date Mtg Date Mtg Date SPONSOR Council Mayor HR DCD Finance Fire TS P&R Police PW Court SPONSOR’S SUMMARY General fund financial update including report out on COVID specific financial impacts as required in Resolution No. 1987 REVIEWED BY Trans&Infrastructure CommunitySvs/Safety Finance Comm. Planning/Economic 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: RECORD OF COUNCIL ACTION MTG. DATE ATTACHMENTS 12/14/20 Informational Memorandum dated 12/14/20 COUNCIL AGENDA SYNOPSIS ----------------------------------Initials --------------------------------- ITEM NO. Meeting Date Prepared by Mayor’s review Council review 12/14/20 Vicky MTG. DATE 12/14/20 4.B. 99 1010 City of Tukwila Allan Ekberg, Mayor INFORMATIONAL MEMORANDUM TO: Finance Committee FROM: Vicky Carlsen, Finance Director BY: Jeff Friend, Fiscal Manager CC: Mayor Ekberg DATE: December 14, 2020 SUBJECT: General Fund Budget-to-Actuals and COVID-19 Impact Report and Update to Budget Impacts due to COVID-19 Summary Resolution 1987 directed financial reporting on COVID-19 impacts twice a month. This report reflects the following: - General fund: o Revenues and Fund Balance as of September 30, 2020 o Expenditures as of October 31, 2020 - Capital projects funds: o Revenues as of October 31, 2020 o Expenditures as of October 31, 2020 The purpose of the general fund budgets to actuals report is to summarize for the City Council the general state of revenues and expenditures and to highlight significant items. The following provides a high-level summary of the general fund financial performance and includes select capital project funds. As year-end 2020 approaches, the focus of this report is shifting from a year-to-date budget-to-actual emphasis to a focus on year-end projections and estimate for ending fund balance. Projected actuals for year-end are included in this report in place of the “Revised Budget (COVID-19)” from past reports. The projected actuals include the most recent projections that were also included in the 2021-2022 proposed biennial budget. The amended budget noted throughout the report includes the original adopted budget and mid-biennium budget amendments approved in 2019. In the report on the next page, General Fund revenues and expenditures are reflected through September 30th, 2020. To provide the most up-to-date information, we have provided expenditure details through October 31st on a separate chart on page 5 of this report. The General Fund Report is based on financial data available as of December 2, 2020. 1111 INFORMATIONAL MEMO Page 2 Revenues, Expenditures, and Fund Balance CITY OF TUKWILA GENERAL FUND As of September 30, 2020 2019 Year-to-Date Actuals Amended Annual Budget Projected Year-End Actuals Year-to-Date Actuals Projected vs. YTD Actual** Percent of Projected Year-End Revenue General Revenue Property Taxes 9,012,233$ 16,416,911$ 16,306,453$ 8,957,640$ 7,348,813$ 54.9% Retail Sales Tax 14,382,791 19,910,676 16,210,000 11,639,027 4,570,973 71.8% Use Tax 536,587 690,000 745,000 613,732 131,268 82.4% Admissions Tax 733,392 870,000 550,000 332,099 217,901 60.4% Utility Taxes 2,766,059 4,374,610 3,444,000 3,130,467 313,534 90.9% Interfund Utility Tax 1,980,909 2,412,000 2,083,000 1,796,069 286,931 86.2% Gambling/Excise Taxes 3,005,411 4,426,000 2,337,021 1,960,199 376,822 83.9% Total General Revenue 32,417,383 49,100,197 41,675,474 28,429,232 13,246,242 68.2% Licenses and Permits Business Licenses & Permits 3,106,257 4,612,400 3,515,000 4,179,626 (664,626) 118.9% Rental Housing License 36,175 45,000 45,000 41,910 3,090 93.1% Building Permits and Fees 1,645,927 2,127,494 2,318,550 1,270,615 1,047,935 54.8% Total Licenses and Permits 4,788,359 6,784,894 5,878,550 5,492,151 386,399 93.4% Intergovernmental Revenue Sales Tax Mitigation 655,127 - - - - - Seattle City Light Agreement 1,851,253 2,470,000 2,300,000 1,796,900 503,100 78.1% State Entitlements 365,432 446,250 471,088 437,770 33,318 92.9% Grants 429,249 1,006,117 1,286,441 279,069 1,007,372 21.7% Total Intergov't Revenue 3,301,061 3,922,367 4,057,529 2,513,739 1,543,790 62.0% Charges for Services General Government 43,364 58,532 24,694 21,365 3,329 86.5% Security 1,083,035 1,622,000 989,405 1,065,679 (76,274) 107.7% Transportation 47,822 79,000 64,000 (37,771) 101,771 -59.0% Plan Check and Review Fees 1,150,752 1,168,675 939,019 583,301 355,718 62.1% Culture and Rec Fees 388,267 601,000 84,221 62,545 21,676 74.3% Total Charges for Services 2,713,239 3,529,207 2,101,339 1,695,119 406,220 80.7% Fines and Penalties 124,742 291,718 114,129 99,134 14,995 86.9% Miscellaneous Revenue 1,016,217 1,214,156 855,493 746,554 108,939 87.3% Indirect cost allocation 1,909,233 2,637,288 2,637,288 1,977,967 659,321 75.0% Ongoing Revenue 46,270,233 67,479,827 57,319,802 40,953,896 16,365,906 71.4% Transfer from Contingency - - 700,000 - 700,000 0.00% Transfer from Urban Renewal - 200,000 400,000 - 400,000 0.00% Total Revenue 46,270,233 67,679,827 58,419,802 40,953,896 17,465,906 70.1% Variance2020 1212 INFORMATIONAL MEMO Page 3 The City’s financial reserve policy states that unreserved general fund ending fund balance shall equal or exceed 18% of the previous year general fund revenue. Projected ending fund balance exceeds the balance of $11,598,531 required by the City’s reserve policy by $32,819. For the 2021-2022 biennial budget, staff is recommending a conservative approach of maintaining an unreserved fund balance 18% required by the reserve policy based on the 2019 requirement. This conservative approach will reduce the amounts to be contributed to the fund balance in future years as the required balance will increase along with higher revenues. Total General Fund revenue through September 30th was $41.0 million. In order to meet year-end revenue projections, the City will need to receive $17.5 million more in revenue over the final three months of the year. 2019 Year-to-Date Actuals Amended Annual Budget Projected Year-End Actuals Year-to-Date Actuals Projected vs. YTD Actual** Percent of Projected Year-End Expenditures City Council 272,796 439,772 342,625 258,067 84,558 75.3% Mayor's Office 1,747,753 2,652,852 2,264,430 1,679,370 585,060 74.2% Administrative Services 1,397,134 2,180,956 2,004,121 1,423,106 581,015 71.0% Finance 1,864,726 2,753,260 2,455,838 1,887,286 568,552 76.8% Legal 428,092 710,730 640,650 400,113 240,537 62.5% Recreation 2,470,133 3,354,374 2,491,792 1,868,302 623,490 75.0% Parks Maintenance 1,273,574 1,656,398 1,551,770 1,137,027 414,743 73.3% Community Development 2,672,359 3,611,354 3,059,742 2,296,490 763,252 75.1% Court 957,885 1,330,951 1,271,031 937,779 333,252 73.8% Police 13,867,589 19,194,006 17,374,568 12,911,271 4,463,297 74.3% Fire 9,516,121 13,118,888 12,572,538 9,196,619 3,375,919 73.1% Information Technology 1,444,167 2,099,687 1,895,154 1,206,699 688,455 63.7% Public Works 2,791,322 4,043,635 3,538,340 2,662,384 875,956 75.2% PW Street Maintenance 3,170,885 3,255,276 2,765,482 2,332,679 432,803 84.3% Total Department Expenditures 43,874,537 60,402,139 54,228,081 40,197,190 14,030,891 74.1% Transfers - Debt Service 2,746,490 3,637,190 3,570,421 2,704,357 866,064 75.7% Transfers - Capital, Other 1,694,600 3,471,950 1,121,950 553,137 568,813 49.3% Transfers - Contingency - 210,000 - - - 0.0% Total Transfers 4,441,090 7,319,140 4,692,371 3,257,494 1,434,878 69.4% Total Expenditures 48,315,627 67,721,279 58,920,452 43,454,684 15,465,769 73.8% Change in Fund Balance (41,452) (500,651) Beginning Fund Balance 13,828,530 12,132,001 Ending Fund Balance 13,787,078$ 11,631,350$ Percent of year completed: 75.0% ** This column reflects amounts needed to be collected/expended to meet year-end projections Variance2020 1313 INFORMATIONAL MEMO Page 4 Sales Tax Sales tax revenue through September is $11.6 million. To meet the year-end projection of $16.2 million the City is expected to collect an additional $4.6 million by year-end. Sales tax revenues continues to be impacted by COVID-19 but has been recovering faster than originally expected. The chart below graphically compares sales tax revenue in 2020 to last year. The table below compares 2019 to 2020 monthly sales tax revenues. While sales tax revenues are exceeding the pandemic budget forecasts, actual sales tax revenues continue to trail prior year with double digit declines. Sales Tax Revenues 2019 2020 $ Change % Change Jan 1,376,700 1,478,671 101,972 7.4% Feb 1,321,327 1,147,961 (173,367) -13.1% Mar 1,700,887 1,325,708 (375,179) -22.1% Apr 1,543,385 991,702 (551,684) -35.7% May 1,541,774 1,156,386 (385,388) -25.0% Jun 1,870,205 1,230,374 (639,831) -34.2% Jul 1,686,655 1,524,692 (161,963) -9.6% Aug 1,659,599 1,408,596 (251,003) -15.1% Sep 1,796,805 1,481,525 (315,280) -17.5% YTD Total 14,497,337 11,745,615 (2,751,722) -19.0% 0 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 1,800,000 2,000,000 Jan Feb Mar Apr May Jun Jul Aug Sep Sales Tax Revenue 2019 vs. 2020 YTD 2019 2020 1414 INFORMATIONAL MEMO Page 5 Expenditures To provide the most up-to-date information possible, general fund expenditures have been updated through October 31st in the following chart. Expenditures totaled $47.9 million through October 31st. Departments project to expend approximately $11.0 million additional before the end of the year. Overtime Police and Fire accounted for $1 million of the $1.04 million of overtime expenditures through October. The public safety departments began the year with overtime at pre-pandemic levels and reduced their overtime when budget constraints were introduced in March 2020. Increased overtime in May, June and July were the results of maintaining minimum staffing levels in the fire department as well as some overtime incurred related to the lootings and protests occurring in the City. It should also be noted that some contractual overtime incurred by both Police and Fire is reimbursable and the City is monitoring and billing as needed. CITY OF TUKWILA GENERAL FUND As of October 31, 2020 2019 Year-to-Date Actuals Amended Annual Budget Projected Year-End Actuals Year-to-Date Actuals Projected vs. YTD Actual** Projected vs. YTD Actual Expenditures City Council 298,863 439,772 342,625 286,416 56,209 83.6% Mayor's Office 1,951,165 2,652,852 2,264,430 1,880,529 383,901 83.0% Administrative Services 1,535,234 2,180,956 2,004,121 1,590,024 414,097 79.3% Finance 2,027,195 2,753,260 2,455,838 2,022,619 433,219 82.4% Legal 494,604 710,730 640,650 455,081 185,569 71.0% Recreation 2,727,027 3,354,374 2,491,792 2,086,264 405,528 83.7% Parks Maintenance 1,387,094 1,656,398 1,551,770 1,295,311 256,459 83.5% Community Development 2,958,205 3,611,354 3,059,742 2,558,735 501,007 83.6% Court 1,074,533 1,330,951 1,271,031 1,038,720 232,311 81.7% Police 15,694,988 19,194,006 17,374,568 14,397,962 2,976,606 82.9% Fire 10,548,552 13,118,888 12,572,538 10,332,182 2,240,356 82.2% Information Technology 1,580,053 2,099,687 1,895,154 1,344,702 550,452 71.0% Public Works 3,091,316 4,043,635 3,538,340 2,922,269 616,071 82.6% PW Street Maintenance 3,370,341 3,255,276 2,765,482 2,437,811 327,671 88.2% Total Department Expenditures 48,739,170 60,402,139 54,228,081 44,648,624 9,579,457 82.3% Transfers - Debt Service 2,746,490 3,637,190 3,570,421 2,704,357 866,064 75.7% Transfers - Capital, Other 1,719,600 3,471,950 1,121,950 553,137 568,813 49.3% Transfers - Contingency - 210,000 - - - 0.00% Total Transfers 4,466,090 7,319,140 4,692,371 3,257,494 1,434,878 69.4% Total Expenditures 53,205,259 67,721,279 58,920,452 47,906,118 11,014,334 81.3% Percent of year completed: 75.0% ** This column reflects amounts needed to be collected/expended to meet year-end projections Variance2020 1515 INFORMATIONAL MEMO Page 6 Lootings Twenty-six businesses were broken into at the end of May and beginning of June. The mass lootings required a strong police presence that resulted in overtime costs. Fire staff were also on standby while Public Works incurred some costs related to closing streets. Transfers The transfers line includes budgeted transfers for debt service and certain capital projects. Transfers through October account for only 44.5% of the amended budget. It should be noted, because of existing funds in the PW Shops fund, no transfers from the general fund for this project have been required to date. The proposed 2021-2022 biennial budget includes a plan to finance the general fund portion of this project rather than utilizing a pays-as-you go approach. COVID Expenditures General Fund expenditures related to the COVID-19 pandemic began to be incurred in March. These expenditures totaled $710,556 through October 31st and are reported by department in the schedule below. COVID related expenditures in salaries and benefits include time dedicated to the emergency operations center (EOC) as well as time spent analyzing the financial impacts of the pandemic. Overtime and supplies are for time outside of normal operations spent in the EOC as well as time responding directly to COVID-19 related activities. Supplies are for additional PPE and disinfectant supplies. Unbudgeted costs can be applied against CARES Act funding or FEMA funding and will not affect ending fund balance. Budgeted salaries and benefits for time that has been redirected to responding to the pandemic could qualify for reimbursement from CARES Act funding. Any reimbursement for budgeted salaries and benefits would reduce the need for contingency funds because the City had not received confirmation that CARES Act funding would be available. BUDGETED UNBUDGETED BUDGETED UNBUDGETED Department Salaries and Benefits Overtime Salaries and Benefits Overtime Total Police -$ 24,994$ -$ 36,573$ 61,567$ Fire - 435 - 1,003 1,438 Street Maintenance - - 2,064 - 2,064 Total -$ 25,429$ 2,064$ 37,576$ 65,069$ MAY JUNE 1616 INFORMATIONAL MEMO Page 7 In addition to COVID spending in the general fund, the Public Safety Plan has incurred approximately $650 thousand to date in costs directly related to the pandemic. Because these costs are associated with COVID-19, the City is able to request reimbursement from CARES Act funding to cover these costs. It should be noted that the change orders specific to COVID-19 were funded with contingency that is built into the project budgets. The change orders are not increasing the total budget allocated to each project. BUDGETED Department Salaries and Benefits Overtime and Benefits Supplies Department Total General Fund Council 1,784$ -$ 393$ 2,177$ Mayor 79,657 - 1,314 80,971 Admin Services 40,756 - 488 41,243 Finance 39,434 386 825 40,644 Recreation 336,900 - 36,111 373,011 DCD 3,712 - 1,778 5,490 Court 114 137 4,566 4,816 Police 26,391 4,379 11,949 42,720 Fire 34,713 8,318 13,960 56,991 TIS 390 - 3,519 3,909 Public Works 6,673 318 13,895 20,886 Park Maintenance 32,296 - 2,421 34,717 Street Maintenance - - 2,980 2,980 Total General Fund 602,819$ 13,538$ 94,199$ 710,556$ UNBUDGETED 1717 INFORMATIONAL MEMO Page 8 COVID-19 Related Grants Available to the City There are several grant opportunities now available to the City to offset some of the costs incurred related to the pandemic. Below is a chart, listing grant opportunities as well as what the funds may be used for. It should be noted that all the grants are reimbursement and cannot be used to offset loss of revenue. The State released information on the 2nd round of CARES Act funding. The City has been notified that we will receive an additional $313,950 for total CARES Act funding of $941,850. Grant Amount Eligible Uses Status CARES Act through Dept. of Commerce $941,850 - Expenditures incurred directly related to responding to COVID-19 (supplies, overtime, regular time that has substantially shifted focus to the pandemic, unemployment, etc.) - Providing economic support to those suffering from unemployment - Providing economic support to business interruptions Billed and received all funds from CARES Act. FEMA No cap, reimburses 75% of expenditures not covered with other resources Unbudgeted expenditures incurred directly related to responding to COVID-19 Contract completed. Can submit for reimbursement at any time FEMA - CARES To be determined Assistance to food pantry In process King County $31,965 Assistance to small businesses On June 19th, the City was notified that we are eligible to receive $31,965. On August 3, 2020, the Planning & Economic Development Committee authorized staff to accept the grant and use the funds for direct grants to very small businesses with a focus on the Tukwila International Blvd. area CESF – Dept. of Justice Assistance $49,000 Expenditures incurred directly related to responding to COVID- 19 Grant has been awarded. Contract is being processed EFSP Emergency City of Tukwila does not qualify for this grant Supplement existing emergency food & shelter program Forwarded to TCS and Tukwila Pantry 1818 INFORMATIONAL MEMO Page 9 Food & Shelter Prog HungerCorps VISTA AmeriCorps Four VISTA AmeriCorps HungerCorps students. Value: 35,500 HungerCorps will assist Recreation staff to distribute food as part of the mobile recreation program Contract awarded Port of Seattle $20,930 total grant application Application included residential component within digital media program to grow tourism, development attraction, etc. Suggestion has been made to revise application to focus more on business recovery and direct $7,000 of the total $20,930 application to business recovery. Additional information can be found in item 1a on the July 6, 2020 Planning & Economic Development Committee meeting Recommended revisions approved by Planning & Economic Development Committee on July 7, 2020 1919 INFORMATIONAL MEMO Page 10 Selected Capital Projects Funds Financial analysis regarding the impacts of the COVID-19 pandemic include ongoing review of certain capital projects funds including residential streets (fund 103), arterial streets (fund 104), and general government improvements (fund 303). The narrative below highlights planned capital projects along with decisions that have already been made and decision points for future meetings. The narrative is followed by financial statements reflecting activity through August 31, 2020. The statements have been reformatted to focus on projected year-end rather than a budget to actual comparison. Residential Streets The most impactful issue in this fund relates to the 42nd Ave S and 53rd Ave S roadway projects. Both projects are completed and are awaiting final closeout and payments to contractors. Project costs for 2020 have been updated to reflect final estimated costs. At this time, a budget amendment will be required in order to provide enough funding to pay for the final costs associated with these two projects. The solution identified will not negatively affect the general fund. The proposed budget amendment includes two transfers into this fund. A transfer of $400 thousand from the urban renewal fund. Prior year land sale revenue is available for one-time projects. Additionally, the amendment will reallocate the solid waste utility tax revenue (funds dedicated to road projects) to these two projects. Funds were originally committed to the 42 nd Ave S Bridge project for 30% design that was expected to be completed earlier this year. It is now expected that these costs will be incurred in 2021, if approved in the proposed 2021-2022 biennial budget. Arterial Streets 42nd Ave S Bridge: The City Council authorized funding of up to $1 million ($320 thousand general fund, $680 thousand solid waste utility tax) for 30% design. If approved, most of the cost associated with this project will be incurred in 2021. With the delay in design, the solid waste utility tax revenue will be reallocated to the residential street fund in 2020. This will be included in the 2020 budget amendments. S 119th St Ped Bridge painting: Not funding this project will only delay the project, not cancel it. There is a limited window of opportunity to paint the bridge due to weather and fish cycles. This project has now been scheduled for 2024 and is included in the proposed Capital Improvement Program. Overlay: At the June 8, 2020 Committee of the Whole meeting, there was Council consensus to move forward with the recommendation from the Transportation & Infrastructure Committee to fund the two highest priority overlay projects. Overlay has been completed for 2020 and is in the closeout process. General Government Improvement Siding repair at TCC: this project is underway and an update on the project will be provided at a later date. Facilities Study: This project is also funded out of the general government improvement. Staff is reworking the scope of this project per comments received from City Council at the June 8, 2020 Committee of the Whole meeting. 2020 INFORMATIONAL MEMO Page 11 2019 Amended Annual Budget REVENUE: General Revenue Solid Waste/Recycling Utility Tax - - 550,000 40,651 509,349 7.4% Total Intergovernmental Revenue - - 550,000 40,651 509,349 0 Intergovernmental Revenue Indirect Federal - SRTS - 3,454,000 - - - 0% State Grant - Macadam 981,968 1,847,000 - - - 0% State Entitlements - MVFT Cities 241,814 290,000 170,000 221,355 (51,355) 130.2% Total Intergovernmental Revenue 1,223,782 5,591,000 170,000 221,355 (51,355) 130.2% Miscellaneous Revenue ** Charges for services 608,227 - - 134,682 (134,682) 0.0% Investment earnings 1,860 20,000 - - - 0.0% Total Miscellaneous Revenue 610,087 20,000 - 134,682 (134,682) 0.0% Transfers In 1,300,000 100,000 400,000 - 400,000 0.0% Total Revenues 3,133,869 5,711,000 1,120,000 396,689 723,312 35.4% EXPENDITURES: 46thAve Safe Routes to School - 1,832,000 - - - 0.0% Macadam Rd S Complete Street - 1,847,000 - - - 0.0% S 152nd St Safe Routes to School - 1,622,000 - - - 0.0% Traffic Calming/Residential Safety 146,323 400,000 50,000 72,620 (22,620) 145.2% 53rd Ave S 2,183,122 - 500,000 311,668 188,332 62.3% 42nd Ave S Ph III Wetland Monitoring - - 3,011 4,663 (1,652) 154.9% 42nd Ave S Phase III (SC Blvd-160)1,137,886 - 593,763 349,973 243,790 58.9% Interfund Loan Repayment - - 0.0% Total Expenditures 3,467,331 5,701,000 1,146,774 738,924 407,850 64.4% Change in fund balances 10,000 (26,774) Beginning Fund Balance 51,544 141,586 Ending Fund Balance - 61,544 114,812 ** This column reflects amounts needed to be collected/expended to meet year-end projections City of Tukwila Residential Street Fund 103 - Revenue and Expenditures Year-to-Date as of Octobrt 31, 2020 Projected vs. YTD Actual** Percent of Projected Year-End Year-to-Date Actuals Projected Year- End 2020 Year-to-Date Actuals 2121 INFORMATIONAL MEMO Page 12 2019 Amended Annual Budget REVENUE: General Revenue Parking Tax 278,043 470,000 200,026 171,154 28,872 85.6% MVFT Cities 122,109 137,000 92,483 112,821 (20,338) 122.0% Real Estate Excise Taxes 356,694 500,000 500,000 172,628 327,372 34.5% Total General Revenue 756,847 1,107,000 792,509 456,603 335,906 57.6% Charges for Services Park impact Fees 1,052,891 300,000 - - - 0.0% Traffic Impact Fees 438,736 213,000 70,564 387,258 (316,694) 548.8% Total Charges for Services 1,491,628 513,000 70,564 387,258 (316,694) 548.8% Intergovernmental Revenue Federal Grants 1,234,250 6,724,000 2,811,834 309,174 2,502,660 11.0% State Grants - 2,253,000 160,000 130,577 29,423 81.6% Total Charges for Services 1,234,250 8,977,000 2,971,834 439,751 2,532,083 14.8% Miscellaneous Revenue Investment earnings 43,003 20,000 20,000 12,680 7,320 63.4% Contributions/Donations 4,900 30,000 17,533 11,300 6,233 64.4% Total Miscellaneous Revenue 47,903 50,000 37,533 23,980 13,553 63.9% Total Revenues 3,530,627 10,647,000 3,872,440 1,307,592 2,564,848 33.8% EXPENDITURES: Overhead (Salaries & Benefits)208,277 485,382 - 218,145 (218,145) 0.0% Wetland Monitoring (various) 619 - 40,000 29,051 10,949 72.6% BAR over Airport Way Seismic Retrofit 322,467 2,614,000 1,441,000 119,271 1,321,729 8.3% TIB Channelization Study 20,832 - 19,920 19,920 0 100.0% Transportation Comp Element Plan - 200,000 1,338 198,662 0.7% TUC Ped/Bicycle Bridge 275,235 - 1,505 1,505 (0) 100.0% Boeing Access Road Bridge Rehab 1,184,772 - 16 16 - 100.0% Strander Boulevard Extension 143,487 877,566 625,000 2,795 622,205 0.4% S 140th St Intersection Improvements 241,316 - - - - 0.0% S 144th ST Phase II 19,894 - 161 95,872 (95,711) 59547.9% S 196th/200th St Bridge 97,118 - 1,304 17,850 (16,546) 1368.9% West Valley Highway 4,804 3,195,000 509,000 328,332 180,668 64.5% 42nd Ave S Bridge Replacement 18,652 1,600,000 200,000 3,146 196,854 1.6% Annual Overlay 1,279,773 1,400,000 517,000 184,207 332,793 35.6% Annual Bridge Inspections 29,720 335,000 335,000 8,089 326,911 2.4% Annual Traffic Signals - 125,000 62,000 3,852 58,148 6.2% Other Misc. Capital Projects 78,147 792,000 2,025 8,122 (6,097) 401.1% Transfer Park Impact Fees to 301 - - 675,106 - 675,106 0.0% Total Expenditures 3,925,113 11,423,948 4,629,037 1,041,512 3,587,525 22.5% Change in fund balances (776,948) (756,597) Beginning Fund Balance 1,187,826 2,083,854 Ending Fund Balance 410,878 1,327,257 ** This column reflects amounts needed to be collected/expended to meet year-end projections Percent of Projected Year-End 2020 Year-to-Date as of October 31, 2020 City of Tukwila Arterial Street Fund 104 - Revenue and Expenditures Projected Year- End Year-to-Date Actuals Projected vs. YTD Actual** Year-to-Date Actuals 2222 INFORMATIONAL MEMO Page 13 2019 Amended Annual Budget REVENUE: Miscellaneous Revenue Investment earnings 9,232 500 4,000 3,999 (1) 100.0% Total Miscellaneous Revenue 9,232 500 4,000 3,999 (1) 100.0% Transfers In 150,000 200,000 - - - 0.0% Total Revenues 159,232 200,500 4,000 3,999 (1) 2.0% EXPENDITURES: City Hall Siding/Roof Repair - 50,000 - - - 0.0% TCC Siding/Roof Repair - 100,000 128,601 58,511 (70,090) 45.5% 2020 Facilities Study - 300,000 - - - 0.0% Misc. Projects (including salaries & benefits)9,616 208,015 31,684 31,684 (0) 100.0% Install No Parking Signs at 6200/6300 Bldg 8,232 2,026 2,026 6300 Bldg. Dry Fire Sprinkler System - 29,658 29,658 City Facilities Mitigation 1,384 - - Total Expenditures 9,616 658,015 160,285 90,195 (70,090) 56.3% Change in fund balances (457,515) (156,285) Beginning Fund Balance 525,166 656,306 Ending Fund Balance 67,651 500,021 ** This column reflects amounts needed to be collected/expended to meet year-end projections City of Tukwila General Government Improvements Fund 303 - Revenue and Expenditures Year-to-Date as of October 31, 2020 Projected Year-End 2020 Projected vs. YTD Actual** Percent of Projected Year-End Year-to-Date Actuals Year-to-Date Actuals 2323