Loading...
HomeMy WebLinkAboutCOW 2020-11-09 Item 4D - COVID-19 - Financial Impact ReportITEM INFORMATION STAFF SPONSOR: VICKY CARLSEN ORIGINAL AGENDA DATE: 11/09/20 AGENDA ITEM TITLE November Financial Update including COVID related data CATEGORY Motion Resolution Ordinance Bid Award Public Hearing Other Discussion Mtg Date 11/9/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 11/09/20 Informational Memorandum dated 11/09/20 COUNCIL AGENDA SYNOPSIS ----------------------------------Initials --------------------------------- ITEM NO. Meeting Date Prepared by Mayor’s review Council review 11/09/20 Vicky MTG. DATE 11/09/20 4.D. 53 54 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: November 9, 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 August 31, 2020 o Expenditures as of September 30, 2020 - Capital projects funds: o Revenues as of September 30, 2020 o Expenditures as of September 30, 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 August 31st. To provide the most up-to-date information, we have provided expenditure details through September 30th on a separate chart on page 5 of this report. The General Fund Report is based on financial data available as of October 27, 2020. 55 INFORMATIONAL MEMO Page 2 Revenues, Expenditures, and Fund Balance CITY OF TUKWILA GENERAL FUND As of August 31, 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 8,393,715$ 16,416,911$ 16,306,453$ 8,759,404$ 7,547,049$ 53.7% Retail Sales Tax 12,599,490 19,910,676 16,210,000 10,171,629 6,038,371 62.7% Use Tax 475,214 690,000 745,000 544,254 200,746 73.1% Admissions Tax 658,461 870,000 550,000 331,462 218,538 60.3% Utility Taxes 2,476,001 4,374,610 3,444,000 2,787,565 656,435 80.9% Interfund Utility Tax 1,806,247 2,412,000 2,083,000 1,364,085 718,915 65.5% Gambling/Excise Taxes 3,005,411 4,426,000 2,337,021 1,960,199 376,822 83.9% Total General Revenue 29,414,539 49,100,197 41,675,474 25,918,598 15,756,876 62.2% Licenses and Permits Business Licenses & Permits 3,057,800 4,612,400 3,515,000 3,390,576 124,424 96.5% Rental Housing License 36,245 45,000 45,000 41,685 3,315 92.6% Building Permits and Fees 1,324,164 2,127,494 2,318,550 1,087,091 1,231,459 46.9% Total Licenses and Permits 4,418,209 6,784,894 5,878,550 4,519,352 1,359,198 76.9% Intergovernmental Revenue Sales Tax Mitigation 433,822 - - - - - Seattle City Light Agreement 1,600,730 2,470,000 2,300,000 1,571,868 728,132 68.3% State Entitlements 319,337 446,250 471,088 389,782 81,306 82.7% Grants 349,642 1,006,117 1,286,441 215,018 1,071,423 16.7% Total Intergov't Revenue 2,703,531 3,922,367 4,057,529 2,176,667 1,880,862 53.6% Charges for Services General Government 37,482 58,532 24,694 19,002 5,692 77.0% Security 1,039,103 1,622,000 989,405 864,083 125,322 87.3% Transportation 42,363 79,000 64,000 2,774 61,227 4.3% Plan Check and Review Fees 1,033,553 1,168,675 939,019 508,809 430,210 54.2% Culture and Rec Fees 355,981 601,000 84,221 59,535 24,686 70.7% Total Charges for Services 2,508,482 3,529,207 2,101,339 1,454,203 647,136 69.2% Fines and Penalties 108,823 291,718 114,129 74,122 40,007 64.9% Miscellaneous Revenue 901,695 1,214,156 855,493 670,867 184,626 78.4% Indirect cost allocation 1,697,096 2,637,288 2,637,288 1,758,193 879,095 66.7% Ongoing Revenue 41,752,376 67,479,827 57,319,802 36,572,002 20,747,800 63.8% Transfer from Contingency - - 700,000 - 700,000 0.00% Transfer from Urban Renewal - 200,000 400,000 - 400,000 0.00% Total Revenue 41,752,376 67,679,827 58,419,802 36,572,002 21,847,800 62.6% Variance2020 56 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 August 31st was $36.6 million. In order to meet year-end revenue projections, the City will need to receive $21.9 million more in revenue over the final four months of the year. Expenditures City Council 243,464 439,772 342,625 229,838 112,787 67.1% Mayor's Office 1,545,425 2,652,852 2,264,430 1,495,344 769,086 66.0% Administrative Services 1,261,675 2,180,956 2,004,121 1,279,096 725,025 63.8% Finance 1,704,043 2,753,260 2,455,838 1,711,563 744,275 69.7% Legal 376,890 710,730 640,650 349,016 291,634 54.5% Recreation 2,224,214 3,354,374 2,491,792 1,691,877 799,915 67.9% Parks Maintenance 1,121,637 1,656,398 1,551,770 1,022,702 529,068 65.9% Community Development 2,388,966 3,611,354 3,059,742 2,057,895 1,001,847 67.3% Court 848,921 1,330,951 1,271,031 838,344 432,687 66.0% Police 12,213,480 19,194,006 17,374,568 11,646,550 5,728,018 67.0% Fire 8,500,448 13,118,888 12,572,538 8,192,493 4,380,045 65.2% Information Technology 1,314,216 2,099,687 1,895,154 1,087,972 807,182 57.4% Public Works 2,492,543 4,043,635 3,538,340 2,376,205 1,162,135 67.2% PW Street Maintenance 2,856,464 3,255,276 2,765,482 2,178,043 587,439 78.8% Total Department Expenditures 39,092,386 60,402,139 54,228,081 36,156,937 18,071,144 66.7% Transfers - Debt Service 1,830,993 3,637,190 3,570,421 1,918,215 1,652,206 53.7% Transfers - Capital, Other 1,619,600 3,471,950 1,121,950 478,137 643,813 42.6% Transfers - Contingency - 210,000 - - - 0.0% Total Transfers 3,450,593 7,319,140 4,692,371 2,396,352 2,296,020 51.1% Total Expenditures 42,542,979 67,721,279 58,920,452 38,553,289 20,367,164 65.4% 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: 66.7% ** This column reflects amounts needed to be collected/expended to meet year-end projections 57 INFORMATIONAL MEMO Page 4 Sales Tax Sales tax revenue through August is $10.2 million. To meet the year-end projection of $16.2 million the City is expected to collect an additional $6.0 million by year-end. It should be noted that some August sales tax revenue was included in the previous report. Sales tax revenue is now reflected in full through August 31st. 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. 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 Sales Tax Revenue 2019 vs. 2020 YTD 2019 2020 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% 58 INFORMATIONAL MEMO Page 5 Expenditures To provide the most up-to-date information possible, general fund expenditures have been updated through September 30th in the following chart. Expenditures totaled $43.5 million through September 30th. Departments project to expend approximately $15.5 million additional before the end of the year. Overtime Police and Fire accounted for $838 thousand of the $870 thousand of overtime expenditures through September. 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 the Police department is reimbursable and the City is currently working those calculations. 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** Projected vs. YTD Actual 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,133 568,705 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,663,021 875,319 75.3% 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,674 14,030,407 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.00% 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,455,168 15,465,285 73.8% Percent of year completed: 75.0% ** This column reflects amounts needed to be collected/expended to meet year-end projections Variance2020 59 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 September 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 $661,285 through September 30th 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. Reimbursement of these costs were not included in the proposal to close the $10.2 million revenue gap. 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 60 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,081 - 314 79,395 Admin Services 40,302 - 488 40,790 Finance 39,434 386 825 40,644 Recreation 321,161 - 18,460 339,621 DCD 3,712 - 1,483 5,195 Court 114 137 4,566 4,816 Police 25,239 4,379 11,949 41,568 Fire 32,606 8,318 13,458 54,382 TIS 390 - 45 435 Public Works 6,673 318 13,895 20,886 Park Maintenance 31,376 - - 31,376 Street Maintenance - - - - Total General Fund 581,870$ 13,538$ 65,877$ 661,285$ UNBUDGETED 61 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 Contract has been signed and returned to Department of Commerce for full execution 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 62 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 63 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. 64 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 216,434 290,000 170,000 192,580 (22,580) 113.3% Total Intergovernmental Revenue 1,198,402 5,591,000 170,000 192,580 (22,580) 113.3% 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,108,489 5,711,000 1,120,000 367,913 752,087 32.8% 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 112,524 400,000 50,000 52,399 (2,399) 104.8% 53rd Ave S 2,178,409 - 500,000 235,717 264,283 47.1% 42nd Ave S Ph III Wetland Monitoring - - 3,011 3,518 (507) 116.8% 42nd Ave S Phase III (SC Blvd-160)1,119,307 - 593,763 347,480 246,283 58.5% Interfund Loan Repayment - - 0.0% Total Expenditures 3,410,241 5,701,000 1,146,774 639,114 507,660 55.7% 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 September 30, 2020 Projected vs. YTD Actual** Percent of Projected Year-End Actual Year-to- Date Actual Projected Year- End 2020 Actuals through September 30 65 INFORMATIONAL MEMO Page 12 2019 Amended Annual Budget REVENUE: General Revenue Parking Tax 258,630 470,000 200,026 167,833 32,193 83.9% MVFT Cities 110,165 137,000 92,483 99,280 (6,797) 107.3% Real Estate Excise Taxes 299,579 500,000 500,000 172,628 327,372 34.5% Total General Revenue 668,374 1,107,000 792,509 439,740 352,769 55.5% Charges for Services Park impact Fees 711,069 300,000 - - - 0.0% Traffic Impact Fees 409,848 213,000 70,564 80,724 (10,160) 114.4% Total Charges for Services 1,120,917 513,000 70,564 80,724 (10,160) 114.4% Intergovernmental Revenue Federal Grants 1,190,664 6,724,000 2,811,834 142,506 2,669,328 5.1% State Grants - 2,253,000 160,000 130,577 29,423 81.6% Total Charges for Services 1,190,664 8,977,000 2,971,834 273,083 2,698,751 9.2% Miscellaneous Revenue Investment earnings 39,652 20,000 20,000 12,680 7,320 63.4% Contributions/Donations 4,900 30,000 17,533 11,000 6,533 62.7% Total Miscellaneous Revenue 44,552 50,000 37,533 23,680 13,853 63.1% Total Revenues 3,024,506 10,647,000 3,872,440 817,228 3,055,212 21.1% EXPENDITURES: Overhead (Salaries & Benefits)190,344 485,382 - 195,900 (195,900) 0.0% Wetland Monitoring (various) 127 - 40,000 25,952 14,048 64.9% BAR over Airport Way Seismic Retrofit 307,719 2,614,000 1,441,000 103,150 1,337,850 7.2% TIB Channelization Study 12,082 - 19,920 19,920 0 100.0% Transportation Comp Element Plan - 200,000 1,338 198,662 0.7% TUC Ped/Bicycle Bridge 272,447 - 1,505 1,505 (0) 100.0% Boeing Access Road Bridge Rehab 1,178,456 - 16 16 - 100.0% Strander Boulevard Extension 140,735 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,753 - 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,191 3,195,000 509,000 276,861 232,139 54.4% 42nd Ave S Bridge Replacement 18,652 1,600,000 200,000 3,146 196,854 1.6% Annual Overlay 1,157,713 1,400,000 517,000 181,028 335,972 35.0% Annual Bridge Inspections 28,990 335,000 335,000 5,250 329,750 1.6% Annual Traffic Signals - 125,000 62,000 3,852 58,148 6.2% Other Misc. Capital Projects 59,287 792,000 2,025 7,015 (4,990) 346.4% Transfer Park Impact Fees to 301 - - 675,106 - 675,106 0.0% Total Expenditures 3,728,930 11,423,948 4,629,037 941,451 3,687,586 20.3% 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 September 30, 2020 City of Tukwila Arterial Street Fund 104 - Revenue and Expenditures Projected Year- End Actual Year-to- Date Actual Projected vs. YTD Actual** Actuals through September 30 66 INFORMATIONAL MEMO Page 13 2019 Amended Annual Budget REVENUE: Miscellaneous Revenue Investment earnings 8,409 500 4,000 3,999 (1) 100.0% Total Miscellaneous Revenue 8,409 500 4,000 3,999 (1) 100.0% Transfers In 150,000 200,000 - - - 0.0% Total Revenues 158,409 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 - (128,601) 0.0% 2020 Facilities Study - 300,000 - - - 0.0% Misc. Projects (including salaries & benefits)7,902 208,015 31,684 31,684 (0) 100.0% Install No Parking Signs at 6200/6300 Bldg 6,518 2,026 2,026 6300 Bldg. Dry Fire Sprinkler System - 29,658 29,658 City Facilities Mitigation 1,384 - - Total Expenditures 7,902 658,015 160,285 31,684 (128,601) 19.8% 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 September 30, 2020 Projected Year-End 2020 Projected vs. YTD Actual** Percent of Projected Year-End Actual Year-to- Date Actual Actuals through September 30 67