The URL can be used to link to this page

Home My WebLink AboutCOW 2020-08-10 Item 3B - COVID-19 - Financial Impact ReportCOUNCIL AGENDA SYNOPSIS ---------------------------------- Initials Meeting Date Prepared b Ma ors review Council review 08/ 10120 Vick ITEM INFORMATION ITEM NO. 33. STAFF SPONSOR: VICKY CARLSEN ORIGINAL AGENDA DATE: 08/10/20 AGENDA ITEM TITLE June Financial Update including COVID related data CATEGORY ® Discussion g Date 08/10/20 Aft ❑ Motion Mtg Date ❑ Resolution All Date ❑ Ordinance All Date ❑ Bid Azvard All Date ❑ Public Hearing g Date Aft ❑Other Aft g Date SPONSOR ❑Council ❑Mayor ❑HR ❑DCD ®Finance ❑Fire ❑TS ❑P&R ❑Police ❑Ply ❑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. Finance COMMITTEE COST IMPACT / FUND SOURCE EXPENDITURE REQUIRED AMOUNT BUDGETED APPROPRIATION REQUIRED Fund Source: Comments: MTG. DATE RECORD OF COUNCIL ACTION 08/10/20 MTG. DATE ATTACHMENTS 08/10/20 Informational Memorandum dated 08/10/20 17 in 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: August 10, 2020 SUBJECT: General Fund Budget-to-Actuals and COVID-19 Impact Report Summary Resolution 1987 directed financial reporting on COVID-19 impacts twice a month. The City received May sales tax data allowing for general fund revenues to be updated through the end of May. This report reflects the following: - General fund: o Revenues as of May 31, 2020 o Expenditures as of June 30, 2020 - Capital projects funds: o Revenues as of June 30, 2020 o Expenditures as of June 30, 2020 The revised budget (COVID-19) noted throughout the report is for financial analysis purposes only. Any actual adjustments to the budget will require formal action from Council in the 4t" quarter of 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. The General Fund Report is based on financial data available as of July 29, 2020, for the period ending May 31, 2020 for revenues and June 30, 2020 for expenditures. The allocated budget is calculated to reflect monthly revenue patterns based on prior year activity with adjustments specific to COVID-19. Additional details can be found within the attached financial report. To summarize the general fund information below, revenues exceed the revised allocated budget by $1.8 million and expenditures are below allocated budget by $125 thousand. Revenues The chart on page 2, reflects general fund revenue on a monthly basis. The green bar reflects the adopted budget as amended on December 2, 2019, the blue bar indicates the revised budget reflecting projected reductions due to COVID-19, and the orange bar indicates actuals each month. In this report, revenues are reflected through May 31st and expenditures through June 30t". The chart has not yet been revised to reflect updated sales tax and property tax projections. Staff is working on an updated financial forecast that will be presented on August 241". June revenue will be updated after June sales tax revenue is received at the end of August and will be included in first financial report in September. 19 INFORMATIONAL MEMO Page 2 $8 $6 $4 $2 $0 JAN FEB MAR GENERAL FUND REVENUE CITY OF TUKW ILA GENERAL FUND REVENUES ■ Adopted Budget ■ Revised Budget(Covid-19) Actual APR MAY JUN I -M M JUL AUG SEP OCT NOV DEC YTD AS OF MAY 31.2020 REVISED BUDGET ADOPTED BUDGET (COV I D-19) ACTUAL SUMMARY BY REVENUE TYPE 2020 BDGT 2020 2020 2020 2020 VARIANCE- REVISED ANNUAL ALLOCATED ANNUAL ALLOCATED 2018 2019 2020 BDGT(COVID) % RECT PROPERTYTAX 16,416,911 8,679,615 16,416,911 4,179,615 8,094,130 8,219,100 5,067,350 887,735 31 % SALES TAX 20,510,676 7,651,154 12,898,546 5,210,937 7,620,164 7,653,899 6,333,111 1,122,175 31% ADMISSIONS TAX 870,000 377,149 470,246 234,748 421,938 414,792 318,714 83,966 37% UTILITYTAX 4,464,610 2,039,367 3,816,260 1,718,604 1,840,458 1,703,529 1,580,502 (138,102) 35% INTERFUND UTILITYTAX 2,412,000 1,326,448 2,412,000 1,326,448 946,854 1,300,992 1,425,766 99,318 59% GAMBLING & EXCISE TAX 4,426,000 2,181,636 2,064,567 1,977,876 1,969,600 1,964,337 1,654,144 (323,732) 37% TOTAL GENERAL REVENUE 49,100,197 22,255,368 38,078,530 14,648,227 20,893,145 21,256,648 16,379,587 1,731,360 33% LICENSES AND PERMITS 6,784,894 2,793,221 6,784,894 2,793,221 3,467,022 3,728,917 3,320,459 527,238 49% INTERGOVERNMENTAL REVENUE 4,403,506 2,073,926 4,403,506 2,073,926 1,490,828 2,118,913 1,932,528 (141,399) 44% CHARGES FOR SERVICES 2,588,707 741,595 2,107,235 936,953 787,854 1,319,996 382,368 (554,585) 15% OTHER INCOME 4,398,189 1,625,096 3,806,470 1,486,212 1,414,740 1,486,606 1,139,993 253,780 40% TOTAL OPERATING REVENUE 67,275,493 29,489,206 55,180,635 21,938,540 28,053,588 29,911,080 23,754,934 1 1,816,395 35% TRANSFERS IN 200,000 - 200,000 - - - - I - 0% TOTAL REVENUE 67,475,493 29,489,206 55,380,635 21,938,540 28,053,588 29,911,080 23,754,934 1 1,816,395 351 Percent of year 42% Total General Fund revenue through May 31 st was $23.8 million and is above the revised allocated budget by $1.8 million. The higher than expected actuals in January is mainly due to business license renewal activity. Business license revenue was higher than projected in January and February due to a timing difference resulting in transitioning to the State. Business license revenue that was anticipated in December 2019 was received in the first two months of this year. March is the first month that the City experienced revenue loss due to the pandemic. Revenue through May is also higher than projected due to property tax and sales tax revenue. King County allowed certain property owners to pay the 1 st installment 30 days later than normal. Less property owners than expected took advantage of this opportunity, which resulted in a timing difference that will be offset in June. By year-end, the City does anticipate property tax revenue to be close to budget. The timing adjustment for property tax was a $2 million reduction in May with an offsetting increase of $2 million in June. The sales tax table on the next page presents the dollar change over the last three reported 20 months, comparing 2020 industry year to the same period last year. Construction was stronger in INFORMATIONAL MEMO Page 3 Mar — May 2020 compared to the same period last year. This added to the increase over projected revenues. However, the Retail Trade is down more than 55% over the same period last year. Accommodation and Food Service is also down significantly, over 47%, compared to the same period of Mar — May 2019. The reduction in the retail and accommodation/food service sectors was expected. Mar - May 2019 vs 2020 By Major Industry 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 ■ Accommodation and Food Construction Retail Trade Services ■ Mar - May 2019 ■ Mar - May 2020 Industry Mar- May 2019 Mar- May 2020 $ Variance %Variance Accommodation and Food Services 702,923 304,084 (398,839) -56.7% Construction 376,141 712,019 335,878 89.3% Retail Trade 2,521,519 1,313,109 (1,208,410) -47.9% 21 INFORMATIONAL MEMO Page 4 Expenditures General Fund expenditures totaled $30 million through June, which is $125 thousand less than the revised allocated budget of $30.1 million adjusted for the impacts of the COVID-19 pandemic. C $14 c 0 $12 $10 $8 $6 $4 $2 $0 GENERAL FUND EXPENDITURES Adopted Budget Revised Budget (Covid-19) Actual JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV Expenditure Type Variances 11 DEC The chart below reflects both adopted budget, as amended on December 2, 2019 along with the allocated budget as well as a revised budget that captures the reductions from phase I (reduce overtime, travel and training, capital transfers, and extra labor), phase II (departmental budget scrubs), and phase III (labor reductions). It does not currently reflect any use of contingency funds as that will require Council action at a later date. 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. This chart is now updated with related supplies expenditures for June. MAYI JUNE UNBUDGETED I BUDGETED I UNBUDGETED Salaries and Department Overtime Benefits Overtime Supplies Total Police $ 24,357 $ - $ 33,617 $ 4,408 $62,382 Fire 435 - 1,003 - 1,438 Street Maintenance I - 1 2,064 2,064 Total 1 $ 24,792 1 $ 2,0641 $ 34,620 1 $ 4,4081 $ 65, 884 22 INFORMATIONAL MEMO Page 5 GENERALFUND CITY OF TUKWILA Year -to -Date as of June 30, 2020 REVISED BUDGET COMPARISON OF BUDGET ACTUAL (COVID-19) RESULTS REVISED BUDGET SALARIES AND BENEFITS AL; I UAL OVER/(UNDER) 2020 ALL ATED 2020ANNUAL 2020 ALLOCATED 2020 ANNUAL ALLOCATED 2018 2019 2020 BOOT % EXPENDED 11 Salaries 30,064,147 15,032,074 28,423,730 14,624,354 13,466,391 14,177,655 14,376,560 (247,795) 51% 12 Extra Labor 764,697 383,278 91,386 157,410 291,306 339,944 118,475 (38,935) 130% 13 Overtime 1,354,099 677,616 354,099 277,616 689,733 923,383 520,728 243,112 147% 15 Holiday Pay 555,369 65,000 555,369 65,000 94,903 75,442 63,624 (1,376) 11% 21 FICA 2,100,726 1,050,363 1,928,893 1,000,636 885,839 924,878 899,048 (101,588) 47% 22 Pension-LEOFF 2 913,369 456,685 870,169 439,405 415,357 442,896 587,334 147,930 67% 23 Pension-PERS/PSERS 1,805,556 902,778 1,525,232 821,655 824,456 878,175 863,764 42,109 57% 24 Industrial Insurance 934,878 467,439 934,878 467,439 299,866 412,785 468,241 802 50% 25 Medical & Dental 6,457,336 3,228,668 6,202,336 3,126,668 2,754,779 2,869,798 3,156,066 29,398 51% 26 Unemployment - - 200,000 15,000 18,354 10,400 27,319 12,319 14% 28 Uniform/Clothing 8,525 1,923 8,525 1,923 1,738 1,313 1,094 (829) 13% Total Salaries and Benefits 44,958,702 22,265,822 41,094,618 20,997,105 19,742,723 21,056,668 21,082,254 85,148 51% BUDGET REVISED (COVID-19) BUDGET ACTUAL COMPARISON RESULTS OF SUPPLIES, SERVICES, AND REVISED BUDGET CAPITAL ACTUAL OVER/(UNDER) 2020 ALL ATED 2020 ANNUAL 2020 ALLOCATED 2020 ANNUAL ALLOCATED 2018 2019 2020 BOOT % EXPENDED 0 Transfers 7,319,140 2,160,815 6,119,140 1,560,815 3,907,572 3,400,593 1,968,595 407,780 32% 31 Supplies 1,066,112 576,434 936,890 524,745 479,787 784,127 350,217 (174,528) 37% 34 Items Purchased for resale 22,000 22,000 22,000 22,000 16,954 18,029 1,253 (20,747) 6% 35 Small Tools 133,569 62,549 86,569 43,749 38,837 59,677 44,048 299 51% 41 Professional Services 5,908,964 2,837,572 5,546,983 2,692,779 2,826,139 2,833,659 2,326,290 (366,489) 42% 42 Communication 434,600 217,300 429,600 215,300 179,975 184,439 204,989 (10,311) 48% 43 Travel 159,630 81,638 18,496 13,771 77,146 106,861 29,925 16,154 162% 44 Advertising 47,550 25,007 31,550 18,607 19,946 10,377 5,545 (13,063) 18% 45 Rentals and Leases 2,422,514 1,211,257 1,400,579 700,290 1,199,867 1,548,697 652,698 (47,592) 47% 46 Insurance 1,047,762 1,047,762 1,007,762 1,031,762 974,066 889,957 987,671 (44,091) 98% 47 Public Utilities 2,069,101 1,508,529 2,053,101 1,502,129 957,053 1,444,442 1,405,645 (96,484) 68% 48 Repairs and Maintenance 587,912 311,222 512,912 281,222 199,954 356,616 407,564 126,342 79% 49 Miscellaneous 1,273,723 623,962 1,040,875 530,822 718,363 580,644 537,874 7,051 52% 64 Machinery & Equipment 270,000 115,000 240,000 - 46,590 45,228 5,495 5,495 2% Total Supplies, Services, and Capital 22,762,577 10,801,047 19,446,457 9,137,991 11,642,248 12,263,345 8,927,807 (210,184) 46% Total Expenditures 67,721,279 33,066,869 60,541,075 30,135,097 31,384,971 33,320,014 30,010,061 (125,036) 50% Percent of year completed 50 % Transfers The transfers line includes budgeted transfers for debt service and certain capital projects. Transfers show above allocated budget due to timing differences of when funds were transferred in 2020 vs last year but total transfers to date are only 32% of the adopted 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. COVID Expenditures General Fund expenditures related to the COVID-19 pandemic began to be incurred in March. These expenditures totaled $488,852 through June 30t" 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 23 INFORMATIONAL MEMO Page 6 24 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 $12 million revenue gap. BUDGETED I UNBUDGETED Department Salaries and Benefits Overtime Supplies and Benefits Department Total Council $ 1,784 $ - $ 287 $ 2,071 Mayor 72,703 - 284 72,987 Admin Services 36,354 - 399 36,753 Finance 39,434 386 372 40,192 Recreation 204,560 - 16,306 220,865 DCD 3,712 - 1,322 5,033 Court 114 137 3,401 3,652 Police 18,600 4,379 11,543 34,522 Fire 16,269 8,015 12,784 37,069 TIS 390 - 45 435 Public Works 6,673 318 13,805 20,796 Park Maintenance 14,476 - - 14,476 Total $ 415,0691 $ 13,236 $ 60,548 $ 488,852 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 of the grants are reimbursement and cannot be used to offset loss of revenue. The chart will be updated as new information becomes available. Staff will return in the near future with a plan to maximize the use of all known, available funding. Grant Amount Eligible Uses Status CARES Act $627,900 - Expenditures incurred Contract has been through Dept. of directly related to signed and returned to Commerce responding to COVID-19 Department of (supplies, overtime, Commerce for full regular time that has execution substantially shifted focus to the pandemic, unemployment, etc.) - Providing economic support to those suffering from unemployment - Providing economic support to business interruptions FEMA No cap, reimburses Unbudgeted expenditures incurred Contract completed. 75% of expenditures directly related to responding to Can submit for not covered with COVID-19 reimbursement at any other resources time FEMA - To be determined Assistance to food pantry In process CARES King County $31,965 Assistance to small businesses On June 191h, the City was notified that we INFORMATIONAL MEMO Page 7 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. $49,000 Expenditures incurred directly Grant has been of Justice related to responding to COVID- awarded. Contract is Assistance 19 being processed EFSP City of Tukwila does Supplement existing emergency Forwarded to TCS Emergency not qualify for this food & shelter program and Tukwila Pantry Food & Shelter grant Prog HungerCorps Four VISTA HungerCorps will assist Contract awarded VISTA AmeriCorps Recreation staff to distribute food AmeriCorps HungerCorps as part of the mobile recreation students. Value: program 35,500 Port of Seattle $20,930 total grant Application included residential Recommended application component within digital media revisions approved by program to grow tourism, Planning & Economic development attraction, etc. Development Suggestion has been made to Committee on July 7, revise application to focus more 2020 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 25 INFORMATIONAL MEMO Page 8 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 April 30, 2020 as well as projected activity through the end of the year. 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. The project budgets reflected in the financial statements are estimates at this time. Staff is working to determine full final costs and will update budgets when revised information is received. Until the City has updated information on these two projects, the fund will continue to show a negative fund balance. It should also be noted that the negative fund balance is only an estimate and will only end the year in a negative position if all identified expenditures are paid this year. The fund currently has a aositive cash balance and a aositive fund balance. 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. There is a possibility that a federal infrastructure bill could include funding for "shovel ready" projects. In order for this project to have the best chance of receiving funding, the project would need to be at least 30% designed. The City expects to select a design consultant later this summer to get to 30% design. Since funding for the highest priority areas for overlay have been identified, staff is recommending that a decision on whether to fund this project or redirect funds elsewhere, be delayed until the true cost of design is understood. 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. Removing funding for this project will delay the project until at least 2021. 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. The budget has been adjusted to reflect the increase in budget. General Government Improvement Siding repair at TCC: Siding repair for TCC has been listed as a project as early as 2018. When the 2019-2020 budget was drafted, the expectation was that $200 thousand in siding and roofing repairs at TCC would occur. Last year, the city received bids for Phase I I I of the project; the lowest proposal being $116,589. At the July 13th Council of the Whole meeting, consensus existed to forward this item to the consent agenda at the following Regular meeting. Budget for this project is $120 thousand and funding currently exists in the general government improvement fund. 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. 26 INFORMATIONAL MEMO Page 9 City of Tukwila Residential Street Fund 103 - Revenue and Expenditures Year -to -Date as of June 30, 2020 2020 Variance Annual Revised (COVID) Actual Expected Total Over/(Under) % of COVID Budget Budget Year -To -Date + Through YE = Projected YE COV ID Budget Budget REVENUE: General Revenue Solid Waste/Recycling Utility Tax - - 40,651 - 40,651 40,651 - 40,651 - 40,651 40,651 - Total Intergovernmental Revenue - - Intergovernmental Revenue Indirect Federal - SRTS 3,454,000 3,454,000 - - (3,454,000) 0.0% StateGrant- Macadam 1,847,000 1,847,000 - - - (1,847,000) 0.0% State Entitlements - MVFT Cities 290.000 200.000 108.210 91.790 200.000 100.0% Total Intergovernmental Revenue Miscellaneous Revenue Charges for services Investment earnings Total Miscellaneous Revenue Transfers In Total Revenues EXPENDITURES: 46thAve Safe Routes to School Macadam Rd S Complete Street S 152nd St Safe Routes to School Traffic Calming/Residential Safety 53rd Ave S 42nd Ave S Phase III Interfund Loan Repayment Total Expenditures Change in fund balances Beginning Fund Balance Ending Fund Balance - 134,682 134,682 134,682 100.0% 20,000 - - - - - - 20,000 134,682 134,682 - 134,682 673.4% 100,000 100,000 - 100,000 100,000 100.0% 5,711,000 5,735,682 283,544 191,790 475,334 (5,260,349) 5 % 1,832,000 1,832,000 - - - (1,832,000) 0.0% 1,847,000 1,847,000 (1,847,000) 0.0% 1,622,000 1,622,000 - - - (1,622,000) 0.0% 400,000 50,000 22,929 27,071 50,000 100.0% - 399,000 147,106 251,894 399,000 100.0% 378,000 32,644 345,356 378,000 100.0% 336,932 1 252,500 84,433 336,932 1 100.0% 10,000 (729,250) (688,599) 40,651 94.4% 141,586 141,586 141,586 0 100.0% 27 INFORMATIONAL MEMO Page 10 City of Tukwila Arterial Street Fund 104 - Revenue and Expenditures Year -to -Date as of June 30, 2020 2020 Variance Annual Revised (COVID) Actual Expected Total Over/(Under) % of Annual Budget Budget Year -To -Date + Through YE = Projected YE Allocated Budget Budget REVENUE: General Revenue Parking Tax 470,000 300,000 143,728 156,272 300,000 0 64% WFTCities 137,000 100,000 67,065 32,935 100,000 0 73% Solid Waste Utility Tax 680,000 680,000 - 680,000 680,000 0 100% Real Estate Excise Taxes 500,000 500,000 139,859 360,141 500,000 0 100 % Total General Revenue 1,787,000 1,580,000 350,653 1,229,347 1,580,000 - 88.4% Charges for Sevices Park impact Fees 300,000 300,000 - 300,000 300,000 - 100.0% Traffic Impact Fees 213,000 213,000 242,202 157,798 400,000 187,000 187.8% Total Charges for Services 513,000 513,000 242,202 457,798 700,000 187,000 136.5% Intergovernmental Revenue Strander Grants 38,389,000 - - - 0 - 0.0% Federal-42nd Ave 1,280,000 - - - 0 - 0.0% Boeing Access Bridge Over Airport We 2,614,000 2,614,000 - 2,614,000 2,614,000 - 100.0% State Grant - West Valley Highw ay 2,694,000 2,694,000 63,955 2,630,045 2,694,000 - 100.0% Total Charges for Services 44,977,000 5,308,000 63,955 5,244,045 5,308,000 - 11.8% Miscellaneous Revenue Investment earnings 20,000 15,000 11,127 2,000 13,127 (1,873) 65.6% Contributions/Donations 30,000 30,000 2,700 - 2,700 (27,300) 9.0% Total Miscellaneous Revenue 50,000 45,000 13,827 15,827 (29,173) 31.7% Transfers In 1,000,000 - - - - - 0.0% Total Revenues 48,327,000 7,446,000 670,638 6,931,190 7,603,827 157,827 15.7% EXPENDITURES: Overhead (Salaries & Benefits) 485,382 485,382 136,593 267,653 404,245 (81,137) 83.3% Strander Blvd. Extension 38,389,000 622,362 2,795 622,362 625,157 (37,763,843) 1.6% BAR over Airport Way Seismic Retrofit 2,614,000 2,614,000 48,826 2,565,174 2,614,000 - 100.0% West Valley Highway 3,195,000 2,694,000 142,375 2,551,625 2,694,000 (501,000) 84.3% 42nd Ave S Bridge Replacement 1,600,000 1,000,000 1,363 998,637 1,000,000 (600,000) 62.5% S 144th St Bridge - Sidewalks 227,000 227,000 - - - (227,000) 0.0% S 119th St Ped Bridge 200,000 200,000 - 200,000 200,000 - 100.0% ADA Improvements 50,000 - - - - (50,000) 0.0% Wetland & Environmental Mitigation 40,000 40,000 15,677 24,323 40,000 - 100.0% Transportation Comp Bement Plan 400,000 200,000 - 200,000 200,000 (200,000) 50.0% Walk & Roll 75,000 - - - - (75,000) 0.0% Annual Overlay 1,400,000 510,000 149,441 360,559 510,000 (890,000) 36.4% Annual Bridge Inspections 135,000 269,000 2,412 266,588 269,000 134,000 199.3% Annual Traffic Signals 125,000 62,500 - 62,500 62,500 (62,500) 50.0% Transfer Park Impact Fees to Fund 301 - 1,009,000 - 1,009,000 1,009,000 1,009,000 - Other Misc. Capital Projects - - 15,865 13,795 29,660 TIB Channelization Study - - 11,205 13,795 25,000 25,000 - 2019 Traffic Calming/Res Safety - - 1,689 - 1,689 1,689 - TUC Pedestnar✓Bicycle Bridge - - 1,505 - 1,505 1,505 - S 196th/200th St Bridge - - 1,304 - 1,304 1,304 - S 144th St Phase II (42nd Ave S - TIB) - 161 - 161 161 - TotalExpenditures� 48,935,382 9,933,244 515,346 9,142,216 9,657,562 (39,277,820) 19.7% Change in fund balances (608,382) (2,487,244) 155,292 (2,211,026) (2,053,734) 433,510 337.6% Beginning Fund Balance 1,187,826 1,187,826 2,083,854 896,028 175.4% Ending Fund Balance 579,444 (1,299,418) 30,120 1,329,538 5.2% a INFORMATIONAL MEMO Page 11 City of Tukwila General Government Improvements Fund 303 - Revenue and Expenditures Year -to -Date as of June 30, 2020 2020 Variance Annual Revised(COVID) I Actual Expected Total Over/(Under) %ofCOVID Budget Budget Year -To -Date + Through YE = Projected YE COVID Budget Budget REVENUE: Miscellaneous Revenue Investment earnings 500 500 3,308 1,000 4,308 2,808 661.5% Total Miscellaneous Revenue 500 500 3,308 2,808 661.5% Transfers In 200,000 - - - - - 0.0% Total Revenues 200,500 500 3,308 EXPENDITURES: City Hall Siding/Roof Repair 50,000 50,000 - TCCSiding/Roof Repair 100,000 120,000 - 2020 Facilities Study 300,000 190,000 - Ivisc. Projects (including salaries & benefits) 208,015 - 31,684 Install No Parking Signs at 620016300 Bldg 2,026 6300 Bldg. Dry Fire Sprinkler System 29, 658 Total Expenditures 658,015 360,000 31,684 Change in fund balances (457,515) (359,500) Beginning Fund Balance 525,166 525,166 Ending Fund Balance 1 165,666 - - (50,000) 0.0% 120,000 120,000 - 100.0% 190,000 190,000 - 100.0% - 31,684 31,684 - Z026 29,658 310,000 341,684 (18,316) 4.8% (338,376) 21,124 94.1% 656.306 131.140 125.0% 29