The URL can be used to link to this page

Home My WebLink AboutCOW 2020-07-27 Item 4C - COVID-19 - Financial Impact ReportCOUNCIL AGENDA SYNOPSIS ---------------------------------- Initials Meeting Date Prepared b Ma ors review Council review 07/27/20 Vick ITEM INFORMATION ITEM NO. 4.C. STAFF SPONSOR: VICKY CARLSEN ORIGINAL AGENDA DATE: 07/27/20 AGENDA ITEM TITLE May Financial Update including COVID related data CATEGORY ® Discussion g Date 7/27/20 Aft ❑ Motion Mtg Date ❑ Resolution All Date ❑ Ordinance All Date ❑ Bid Azvard Mtg Date ❑ Public Hearing Aft Date ❑ Other Alt 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 07/27/20 MTG. DATE ATTACHMENTS 07/27/20 Informational Memorandum dated 07/27/20 35 36 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: July 27, 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 April sales tax data allowing for general fund revenues to be updated through the end of April. This report reflects the following: - General fund: o Revenues as of April 30, 2020 o Expenditures as of May 31, 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 4th 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 16, 2020, for the period ending April 30, 2020 for revenues and May 31, 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 $870.7 thousand and expenditures are below allocated budget by $476.7 thousand. Capital Projects funds have been updated from the previous report and now include data through the end of June. No updates were available for the general fund. Revenues The chart on page 3, 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 April 30th and expenditures through May 31 It. 37 INFORMATIONAL MEMO Page 2 May revenue will be updated after May sales tax revenue is received at the end of July and will be included in first financial report in August. Total General Fund revenue through April 30t" was $19.1 million and is above the revised allocated budget by $870.8 thousand. 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. Sales tax revenue for the month of April, reflects the first full month of brick & mortar store closures. In addition to an overall YTD decline in Gambling & Excise Tax of 29.4%, sales tax from the City's largest sales tax generating location, (the mall and surrounding businesses) reported a sharp decline in revenue, which was expected. Sales tax revenue from the area shopping district was down $457,953, compared to April 2019. This represents a 55% decline in revenues within this retail location. While revenues exceeded the revised budget expectations for the month of April, there has been a decline in overall sales tax revenues of approximately $581,719, or 37%, compared to April 2019. Sales tax from construction remained strong in April, which helped offset the reduction in the retail sector. The graph below depicts sales tax revenues for the period of Jan — Apr, comparing prior year (2019) to current year (2020). The year started off promising, with January beating the same period last year by $101,972, or 7.4%. However, February sales tax revenue began to trend lower compared to the prior year. February reported a $173,367, reduction (13.1 %) in sales tax revenue. March came in at $375,179 (22.1%) below the same period in 2019. As reported above, April ended the month $581,719 (37.1 %) below April 2019. 2,000,000 1,500,000 1,000,000 500,000 Jan - Apr, Prior Yr/Current Year Jan Feb Mar April PY CY INFORMATIONAL MEMO Page 3 GENERAL FUND REVENUES ■ Adopted Budget ■ Revised Budget(Covid-19) Actual $12 c 0 $10 $8 $6 $4 19 $2 ++ $0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC It should also be noted that the revised budget (COVID-19) is higher in June than the adopted budget in anticipation of property owners taking advantage of the ability to delay property tax payments by one month. GENERAL FUND REVENUE CITY OF TUKW I LA YTD AS OF APRIL 30. 2020 ADOPTED BUDGET REVISED BUDGET ACTUAL (COV I D-19) SUMMARY BY REVENUE TYPE 2020 BDGT 2020 2020 2020 2020 VARIANCE- REVISED ANNUAL ALLOCATED ANNUAL ALLOCATED 2018 2019 2020 BDGT(COVID) % REC'D PROPERTY -FAX 16,416,911 5,569,283 16,416,911 3,069,283 4,068,667 5,273,793 3,386,229 316,946 21 % SALES TAX 20,510,676 6,097,409 12,898,546 4,797,003 5,944,777 6,098,900 5,125,048 328,045 25% ADMISSIONS TAX 870,000 288,247 470,246 228,475 318,726 317,017 295,235 66,760 34% UTILITYTAX 4,464,610 1,671,017 3,816,260 1,447,335 1,497,976 1,393,298 1,411,345 (35,990) 32% INTERFUND UTILITYTAX 2,412,000 1,194,160 2,412,000 1,194,160 833,881 1,170,958 1,272,791 78,631 53% GAMBLING & EXCISE TAX 4,426,000 2,181,474 2,064,567 1,633,225 1,969,600 1,964,258 1,153,327 (479,898) 26% TOTAL GENERAL REVENUE 49,100,197 17,001,590 38,078,530 12,369,482 14,633,628 16,218,224 12,643,975 274,493 26% LICENSES AND PERMITS 6,784,894 2,248,255 6,784,894 2,248,255 3,250,195 3,519,395 3,086,083 837,828 45% INTERGOVERNMENTAL REVENUE 4,403,506 1,684,987 4,403,506 1,684,987 1,374,172 1,673,751 1,586,466 (98,521) 36% CHARGES FOR SERVICES 2,588,707 747,597 2,107,235 672,372 482,588 1,014,896 328,374 (343,998) 13% OTHER INCOME 14,398,189 1,316,789 3,806,470 1,221,847 1,131,410 1,200,007 1,422,806 200,959 32% TOTAL OPERATING REVENUE 67,275,493 22,999,217 55,180,635 18,196,943 20,871,992 23,626,273 19,067,704 870,761 28% TRANSFERS IN 200,000 - 200,000 - - - - - 0% TOTAL REVENUE 67,475,493 22,999,217 55,380,635 18,196,943 20,871,992 23,626,273 19,067,704 870,761 28- Percent of year 33% 39 INFORMATIONAL MEMO Page 4 Expenditures General Fund expenditures totaled $24.6 million through May, which is $476.7 thousand less than the revised allocated budget of $25.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. MAY JUNE BUDGETED UNBUDGETED BUDGETED I UNBUDGETED Salaries and Salaries and Department Benefits Overtime Benefits Overtime Total Police $ - $ 24,357 $ - $ 33,617 $57,974 Fire - 435 - 1,003 1, 438 Street Maintenance I - 1 2,064 1 - 2,064 Tota I 1 $ - $ 24,792 1 $ 2,064 1 $ 34,620 M INFORMATIONAL MEMO Page 5 GENERALFUND CITY OF TUKW ILA Year -to -Date as of May 31, 2020 REVISED BUDGET COMPARISON OF BUDGET (COVID-19) ACTUAL RESULTS REVISED BUDGET SALARIES AND BENEFITS ACTUAL OVER/(UNDLR) 2020 2020 2020 ALLOCATED 2020 ANNUAL ALLOCATED ANNUAL ALLOCATED 2018 2019 2020 BDGT % EXPENDED 11 Salaries 30,064,147 12,526,728 28,423,730 12,324,458 11,262,268 11,674,707 12,047,049 (277,409) 42% 12 Extra Labor 764,697 319,708 91,386 156,602 215,980 272,693 117,378 (39,224) 128% 13 Overtime 1,354,099 569,629 354,099 269,629 550,048 770,092 416,507 146,878 118% 15 Holiday Pay 555,369 - 555,369 - 15,159 5,996 3,900 3,900 1% 21 FICA 2,100,726 875,303 1,928,893 845,927 733,564 761,159 751,080 (94,846) 39% 22 Pension-LEOFF2 913,369 380,570 870,169 367,610 342,283 363,548 516,159 148,549 59% 23 Pens ion-PERS/PSERS 1,805,556 752,315 1,525,232 704,392 687,767 731,502 732,582 28,190 48% 24 Industrial Insurance 934,878 389,533 934,878 389,533 249,896 351,339 397,995 8,463 43% 25 Medical & Dental 6,457,336 2,690,557 6,202,336 2,614,057 2,307,062 2,382,990 2,632,364 18,307 42% 26 Unemployment - - 200,000 15,000 18,354 10,400 27,319 12,319 14% 28 Uniform/Clothing 8,525 1,9021 8,525 1,9021 1,508 1,313 614 (1,288) 71/, Total Salaries and Benefits 1 44,958,702 18,506,243 141,094,618 17,689,1091 16,383,890 17,325,739 17,642,947 (46,162) 43 BUDGET REVISED (COVID-19) BUDGET ACTUAL COMPARISON RESULTS OF SUPPLIES, SERVICES, AND REVISED BUDGET CAPITAL ACTUAL OVER/(UNDER) 2020 2020 2020 ALLOCATED 2020 ANNUAL ALLOCATED ANNUAL ALLOCATED 2018 2019 2020 BDGT %EXPENDED 0 Transfers 7,319,140 1,226,518 6,119,140 726,518 3,003,709 2,460,097 984,298 257,780 16% 31 Supplies 1,066,112 472,690 936,890 433,924 394,874 571,191 299,102 (134,822) 32% 34 Items Purchased for resale 22,000 7,184 22,000 7,184 5,799 5,810 235 (6,948) 1 % 35 Small Tools 133,569 39,617 86,569 25,517 34,683 45,195 41,538 16,021 48% 41 Professional Services 5,908,964 2,298,476 5,546,983 2,189,882 2,510,344 2,243,112 1,781,186 (408,696) 32% 42 Communication 434,600 181,083 429,600 179,583 155,203 149,055 166,627 (12,957) 39% 43 Travel 159,630 73,843 18,496 16,270 67,938 94,124 31,014 14,745 168% 44 Advertising 47,550 19,608 31,550 14,808 9,041 8,259 4,408 (10,400) 14% 45 Rentals and Leases 2,422,514 1,009,381 1,400,579 583,575 890,730 1,174,759 546,056 (37,519) 39% 46 Insurance 1,047,762 1,047,762 1,007,762 1,035,762 974,066 889,957 987,671 (48,091) 98% 47 Public Utilities 2,069,101 1,415,918 2,053,101 1,411,118 902,560 1,345,070 1,367,977 (43,141) 67% 48 Repairs and Maintenance 587,912 284,526 512,912 262,026 173,676 327,261 337,885 75,859 66 % 49 Miscellaneous 1,273,723 518,640 1,040,875 448,786 615,644 497,267 437,779 (11,006) 42% 64 Machinery & Equipment 270,000 95,833 240,000 86,833 46,590 - 5,495 (81,339) 2% Total Supplies, Services, and Capital 22,762,577 8,691,078 19,446,457 7,421,7831 9,784,858 9,811,156 6,991,270 (430,513) 36 % Total Expenditures 1 67,721,279 27,197,321 1 60,541,075 25,110,892 1 26,168,748 27,136,894 24,634,217 (476,675) 41 Percent of year completed 42 COVID Expenditures General Fund expenditures related to the COVID-19 pandemic began to be incurred in March. These expenditures totaled $390,102 through May 31 st 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 $12 million revenue gap. 41 INFORMATIONAL MEMO Page 6 BUDGETED UNBUDGETED Department Salaries and Benefits Overtime Supplies and Benefits Department Total Council $ 1,784 $ - $ 275 $ 2,059 Mayor 61,146 - 245 61,391 Admin Services 31,764 - 393 32,157 Finance 37,285 386 357 38,028 Recreation 138,686 - 16,061 154,748 DCD 3,712 - 1,277 4,988 Court 114 137 3,276 3,526 Police 18,600 4,379 7,741 30,721 Fire 16,269 8,015 9,577 33,861 TIS 390 - 45 435 Public Works 6,673 318 12,779 19,770 Park Maintenance 8,418 - - 8,418 Total $ 324,8421 $ 13,236 $ 52,025 $ 390,102 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 employment - 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 Approximately Assistance to small businesses On June 191h, the City $33,000 was notified that we are eligible to receive $31,965. Additional information to come at a later date 42 INFORMATIONAL MEMO Page 7 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 In process application 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 43 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. 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% 45 INFORMATIONAL MEMO Page 10 City of Tukwila Arterial Street Fund 104 - Revenue and Expenditures Year -to -Date as of June 30, 2020 Annual Budget Revised (COVID) Budget Actual Year -To -Date + 2020 Expected Through YE = Total Projected YE Variance Over/(Under) Allocated Budget % of Annual 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 Intergovernmental Revenue Strander Grants Federal - 42nd Ave Boeing Access Bridge Over Airport We State Grant - West Valley Highw ay Total Charges for Services Miscellaneous Revenue Investment earnings Contributions/Donations Total Miscellaneous Revenue Transfers In Total Revenues EXPENDITURES: Overhead (Salaries & Benefits) Strander Blvd. Extension BAR over Airport Way Seismic Retrofit West Valley Highway 42nd Ave S Bridge Replacement S 144th St Bridge - Sidewalks S 119th St Ped Bridge ADA Improvements Wetland & Environmental Mitigation Transportation Comp Bement Plan Walk & Roll Annual Overlay Annual Bridge Inspections Annual Traffic Signals Transfer Park Impact Fees to Fund 301 Other Misc. Capital Projects TIB Channelization Study 2019 Traffic Calming/Res Safety TUC Pedestnar✓Bicycle Bridge S 196th/200th St Bridge S 144th St Phase 11 (42nd Ave S - TIB) Total Expenditures Change in fund balances Beginning Fund Balance Ending Fund Balance 38,389,000 - 1,280,000 - 2,614,000 2,614,000 0 0.0 2,614,000 2,614,000 - 100.0% 955 2.630.045 2.694.000 - 100.0% 20,000 15,000 10,372 2,000 12,372 (2,628) 61.9% 30,000 30,000 2,700 - 2,700 (27,300) 9.0% 50,000 45,000 13,072 15,072 (29,928) 30.1% 1,000,000 - - - - - 0.0% 48.327.000 7.446.000 669.883 6.931.190 7.603.072 157.072 15.7 % 485,382 485,382 136,593 267,653 404,245 (81,137) 83.3% 38,389,000 622,362 2,795 622,362 625,157 (37,763,843) 1.6% 2,614,000 2,614,000 48,826 2,565,174 2,614,000 - 100.0% 3,195,000 2,694,000 142,375 2,551,625 2,694,000 (501,000) 84.3% 1,600,000 1,000,000 1,363 998,637 1,000,000 (600,000) 62.5% 227,000 227,000 - - - (227,000) 0.0% 200,000 200,000 - 200,000 200,000 - 100.0% 50,000 - - - - (50,000) 0.0% 40,000 40,000 15,677 24,323 40,000 - 100.0% 400,000 200,000 - 200,000 200,000 (200,000) 50.0% 75,000 - - - - (75,000) 0.0% 1,400,000 510,000 149,441 360,559 510,000 (890,000) 36.4% 135,000 269,000 2,412 266,588 269,000 134,000 199.3% 125,000 62,500 - 62,500 62,500 (62,500) 50.0% - 1,009,000 - 1,009,000 1,009,000 1,009,000 - - - 15,865 13,795 29,660 - - 11,205 13,795 25,000 25,000 - - - 1,689 - 1,689 1,689 - - - 1,505 - 1,505 1,505 - - - 1,304 - 1,304 1,304 - - 161 - 161 161 - 48,935,382 9,933,244 515,346 9,142,216 9,657,562 (39,277,820) 19.7% (608,382) (2,487,244) 154,537 (2,211,026) (2,054,489) 432,755 337.7% 1,187,826 1,187,826 2,083,854 896,028 175.4% 579,444 (1,299,418) 29,365 1,328,783 5.1% 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% 47