The URL can be used to link to this page

Home My WebLink AboutCOW 2020-11-23 Item 4C - COVID-19 - Coronavirus Financial Impact ReportCOUNCIL AGENDA SYNOPSIS Initials Meeting Date Prepared lg Mayor's review Council review 11/23/20 Vicky ITEM INFORMATION ITEM No. 4.C. 99 STAFF SPONSOR: VICKY CARLSEN ORIGINAL AGENDA DATE: 11/23/20 AGENDA ITEM TITLE November Financial Update including COVID related data CATEGORY 11 Discussion 11/23/20 ❑ Motion Mtg Date ❑ Resolution Mtg Date ❑ Ordinance Mtg Date ❑ Bid Award Mtg Date ❑ Public Hearing Mtg Date ❑ Other Mtg Date Mtg Date SPONSOR Council ❑Mayor ❑HR ❑DCD 11 Finance Fire ❑TS ❑P&R Police ❑PIF Court SPONSOR'S General fund financial update including report out on COVID specific financial impacts as SUMMARY 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. COMMITTEE Finance COST IMPACT / FUND SOURCE EXPENDITURE REQUIRED AMOUNT BUDGETED APPROPRIATION REQUIRED $ $ Fund Source: Comments: MTG. DATE RECORD OF COUNCIL ACTION 11/23/20 MTG. DATE ATTACHMENTS 11/23/20 Informational Memorandum dated 11/23/20 99 100 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 23, 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 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 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. 101 INFORMATIONAL MEMO Page 2 Revenues, Expenditures, and Fund Balance CITY OF TUKWILA GENERAL FUND As of August 31, 2020 102 2019 2020 Variance 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% TotalIntergovt 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% 102 INFORMATIONAL MEMO Page 3 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 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. 103 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. 2,000,000 1,800,000 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 Sales Tax Revenue 2019 vs. 2020 YTD Jan Feb Mar Apr May Jun Jul Aug -2019 2020 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 Jan 1,376,700 Feb 1,321,327 Mar 1,700,887 Apr 1,543,385 May 1,541,774 Jun 1,870,205 Ju I 1,686,655 Aug 1,659,599 2020 $ Change 1,478,671 101,972 1,147,961 (173,367) 1,325,708 (375,179) 991,702 (551,684) 1,156,386 (385,388) 1,230,374 (639,831) 1,524,692 (161,963) 1,408,596 (251,003) % Change 7.4% - 13.1% - 22.1% - 35.7% - 25.0% - 34.2% -9.6% - 15.1% 104 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. CITY OF TUKWILA GENERAL FUND As of September 30, 2020 Percent of year completed: ** This column reflects amounts needed to be collected/expended to meet year-end projections Overtime 75.0% 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. 105 2019 2020 Variance 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: ** This column reflects amounts needed to be collected/expended to meet year-end projections Overtime 75.0% 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. 105 INFORMATIONAL MEMO Page 6 Lootings Twenty-six businesses were broken into at the end of May and beginning of June. The mass footings 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. MAY 1 JUNE BUDGETED 1 UNBUDGETED 1 BUDGETED 1 UNBUDGETED 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. 106 Salaries and Salaries and Department Benefits Overtime 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 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. 106 INFORMATIONAL MEMO Page 7 BUDGETED UNBUDGETED Department Salaries and Benefits Overtime Supplies and Benefits 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 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. 107 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 108 INFORMATIONAL MEMO Page 9 Food & Shelter Prog HungerCorps Four VISTA HungerCorps will assist Contract awarded VISTA AmeriCorps Recreation staff to distribute food AmeriCorps HungerCorps students. Value: as part of the mobile recreation program 35,500 Port of Seattle $20,930 total grant Application included residential Recommended application component within digital media program to grow tourism, development attraction, etc. revisions approved by Planning & Economic Development Suggestion has been made to revise application to focus more on business recovery and direct Committee on July 7, 2020 $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 109 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 42nd 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. 110 INFORMATIONAL MEMO Page 11 City of Tukwila Residential Street Fund 103 - Revenue and Expenditures Year -to -Date as of Octobrt 31, 2020 ** This column reflects amounts needed to be collected/expended to meet year-end projections 111 2019 2020 Year -to -Date Actuals Amended Projected Year- Year -to -Date Projected vs. Percent of Annual End Actuals YTD Actual** Projected Budget Year -End REVENUE: General Revenue Solid Waste/Recycling Utility Tax- - 550,000 40,651 509,349 7.4% Total Intergovemmental 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 eamings 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 AveS 2,183,122 - 500,000 311,668 188,332 62.3% 42nd Axe S Ph III Wetland Monitoring -- 3,011 4,663 (1,652) 154.9% 42nd Axe S Phase III (SC Bluff -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 111 INFORMATIONAL MEMO Page 12 City of Tukwila Arterial Street Fund 104 - Revenue and Expenditures Year -to -Date as of October 31, 2020 ** This column reflects amounts needed to be collected/expended to meet year-end projections 112 2019 2020 Year -to -Date Actuals Amended Annual Budget Projected Year- Year -to -Date Projected vs. Percent of End Actuals YTD Actual** Projected Year -End REVENUE: General Revenue Parking Tax 278,043 470,000 200,026 171,154 28,872 85.6% MVFTCities 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 Deer 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 112 INFORMATIONAL MEMO Page 13 City of Tukwila General Government Improvements Fund 303 - Revenue and Expenditures Year -to -Date as of October 31, 2020 ** This column reflects amounts needed to be collected/expended to meet year-end projections 113 2019 2020 Year -to -Date Actuals Amended Projected Year -to -Date Projected vs. Percent of Annual Year -End Actuals YTD Actual** Projected Budget Year -End 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- - - - 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 113