HomeMy WebLinkAboutCOW 2020-09-28 Item 4B - COVID-19 - Financial Impact ReportITEM INFORMATION
STAFF SPONSOR: VICKY CARLSEN ORIGINAL AGENDA DATE: 09/28/20
AGENDA ITEM TITLE September Financial Update including COVID related data
CATEGORY Motion Resolution Ordinance Bid Award Public Hearing Other Discussion
Mtg Date 09/14/20 Mtg Date Mtg Date Mtg Date Mtg Date Mtg Date Mtg Date
SPONSOR Council Mayor HR DCD Finance Fire TS P&R Police PW Court
SPONSOR’S
SUMMARY
General fund financial update including report out on COVID specific financial impacts as
required in Resolution No. 1987
REVIEWED BY Trans&Infrastructure CommunitySvs/Safety Finance Comm. Planning/Economic Dev.
LTAC Arts Comm. Parks Comm. Planning Comm.
DATE: COMMITTEE CHAIR:
RECOMMENDATIONS:
SPONSOR/ADMIN. Finance
COMMITTEE
COST IMPACT / FUND SOURCE
EXPENDITURE REQUIRED AMOUNT BUDGETED APPROPRIATION REQUIRED
$ $ $
Fund Source:
Comments:
RECORD OF COUNCIL ACTION
MTG. DATE ATTACHMENTS
09/28/20 Informational Memorandum dated 09/28/20
COUNCIL AGENDA SYNOPSIS
----------------------------------Initials --------------------------------- ITEM NO.
Meeting Date Prepared by Mayor’s review Council review
09/28/20 Vicky
MTG. DATE
09/28/20
4.B.
21
22
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: September 28, 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 as of June 30, 2020
o Expenditures as of July 31, 2020
- Capital projects funds:
o Revenues as of August 31, 2020
o Expenditures as of August 31, 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 September 1, 2020, for the
period ending June 30, 2020 for revenues and July 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.
The Revised Budget (COVID-19) has been changed to reflect the updated financial
forecast.
23
INFORMATIONAL MEMO
Page 2
Revenues
The chart below 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 June 30th and expenditures through July 31st.
July revenue will be updated after July sales tax revenue is received at the end of September and
will be included in first financial report in October.
GENERAL FUND REVENUE
CITY OF TUKWILA YTD AS OF JUNE 30, 2020
2020
ANNUAL
2020
ALLOCATED
2020
ANNUAL
2020
ALLOCATED 2018 2019 2020
2020 BDGT
VARIANCE - REVISED
BDGT (COVID) % REC'D
PROPERTY TAX 16,416,911 8,804,052 16,306,453 8,604,052 8,160,990 8,336,935 8,565,413 (38,639) 52%
SALES TAX 20,510,676 9,547,501 16,210,342 7,747,501 9,496,282 9,562,424 7,613,874 (133,627) 37%
ADMISSIONS TAX 870,000 445,650 378,829 318,714 500,310 490,130 327,340 8,626 38%
UTILITY TAX 4,464,610 2,355,320 3,707,629 1,942,846 2,138,850 1,969,749 1,980,500 37,654 44%
INTERFUND UTILITY TAX 2,412,000 1,482,015 2,412,000 1,482,025 1,104,427 1,452,011 1,575,789 93,764 65%
GAMBLING & EXCISE TAX 4,426,000 2,210,957 2,086,361 1,700,000 2,003,226 2,024,270 1,707,565 7,565 39%
TOTAL GENERAL REVENUE 49,100,197 24,845,496 41,101,614 21,795,138 23,404,085 23,835,519 21,770,481 (24,657) 44%
LICENSES AND PERMITS 6,784,894 3,936,009 6,443,127 3,836,009 3,592,661 3,935,811 3,797,897 (38,112) 56%
INTERGOVERNMENTAL REVENUE 4,403,506 2,312,586 4,153,033 2,312,586 2,743,109 2,596,790 2,184,591 (127,995) 50%
CHARGES FOR SERVICES 2,588,707 1,219,322 1,485,478 719,322 983,721 1,506,387 681,026 (38,296) 26%
OTHER INCOME 4,398,189 2,037,079 3,806,470 2,037,079 1,827,921 2,062,176 2,107,247 70,168 48%
TOTAL OPERATING REVENUE 67,275,493 34,350,492 56,989,722 30,700,134 32,551,497 33,936,683 30,541,242 (158,892) 45%
TRANSFERS IN 200,000 - 200,000 - - - - - 0%
TOTAL REVENUE 67,475,493 34,350,492 57,189,722 30,700,134 32,551,497 33,936,683 30,541,242 (158,892) 45%
Percent of year 50%
SUMMARY BY REVENUE TYPE
ADOPTED BUDGET REVISED BUDGET
(COVID-19)ACTUAL
24
INFORMATIONAL MEMO
Page 3
Total General Fund revenue through June 30th was $30.5 million and is slightly below the revised
allocated budget by $159 thousand.
Sales tax revenue through June is $7.6 million which is $133.6 thousand less than the revised
allocated budget of $7.7 million. The projections for sales tax revenue were revised prior to
receiving June sales tax figures.
The sales tax chart and table below present the YTD dollar change comparing 2019 to 2020, by
major industry. Construction was stronger YTD 2020, compared to the same period last year,
reporting an increase in revenues of approximately $416 thousand. The increase in new
construction offsets some of the losses realized in the retail trade and services sectors. To date,
the retail trade and services sectors are below 2019 levels by $1.9 million, the two sectors hit the
hardest by COVID-19.
Industry Jan ‐ Jun 2019 Jan ‐ Jun 2020 $ Variance % Variance
Construction 773,884 1,190,202 416,318 53.8%
Manufacturing 115,326 126,688 11,362 9.9%
Transport / Warehousing 29,988 97,063 67,075 223.7%
Wholesale Trade 558,198 472,765 (85,433) ‐15.3%
Automotive 729,938 247,887 (482,051) ‐66.0%
Retail Trade 3,943,346 2,897,143 (1,046,203) ‐26.5%
Services 3,053,990 2,127,131 (926,859) ‐30.3%
Miscellaneous 61,014 103,698 42,684 70.0%
0
500,000
1,000,000
1,500,000
2,000,000
2,500,000
3,000,000
3,500,000
4,000,000
4,500,000
Jan ‐ Jun 2019 vs 2020
By Major Industry
Jan ‐ Jun 2019 Jan ‐ Jun 2020
25
INFORMATIONAL MEMO
Page 4
Sales tax by jursidiction has declined for the second straight quarter as expected. The gap in the
loss of revenues from Mall retailers is narrowing each month. April’s revenue loss for the current
year compaired to the prior year was 81%. May reported a decline of 73.8% compaired to May of
last year. June had a loss of 59.8% over the same month last year.
Lost revenue from retailers in the Southcenter District is more stable, reporting a reduction of 45%
in the April, and a 30% decline for both the month of May and June.
0
50,000
100,000
150,000
200,000
250,000
300,000
Apr May Jun
Mall Sales Tax Revenue 2nd Qtr.
Current Yr/Current Yr.
PY CY
0
200,000
400,000
600,000
800,000
Apr May Jun
Southcenter Dist. Sales Tax Revenue
2nd Qtr.
Current Yr. vs. Prior Yr.
PY CY
26
INFORMATIONAL MEMO
Page 5
Expenditures
General Fund expenditures totaled $34.0 million through July, which is $184.8 thousand less than
the revised allocated budget of $34.1 million adjusted for the impacts of the COVID-19 pandemic.
Expenditure Type Variances
The chart on the next page 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.
The chart has been updated to reflect the revised financial projections as of August 2020.
27
INFORMATIONAL MEMO
Page 6
Overtime
Overtime expenditures were $629 thousand which was $27.7 thousand over the revised allocated
budget of $615 thousand. The overtime budget has been revised to reflect required overtime for
both Police and Fire.
Police and Fire accounted for $598 thousand of the total overtime through July. 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.
GENERAL FUND
CITY OF TUKWILA
ACTUAL
OVER/(UNDER)
2020 ANNUAL
2020
ALLOCATED
2020
ANNUAL
2020
ALLOCATED 2018 2019 2020
ALLOCATED
BDGT % EXPENDED
11 Salaries 30,064,147 17,537,419 27,990,289 16,621,366 15,797,512 16,501,687 16,633,051 11,685 59%
12 Extra Labor 764,697 446,847 91,386 91,386 402,517 479,403 119,135 27,749 130%
13 Overtime 1,354,099 786,818 829,536 615,098 822,352 1,067,992 629,536 14,438 76%
15 Holiday Pay 555,369 65,000 529,155 65,900 94,903 76,376 65,888 (12) 12%
21 FICA 2,100,726 1,225,424 1,814,319 1,038,000 1,045,196 1,082,335 1,038,550 550 57%
22 Pension-LEOFF 2 913,369 532,799 870,169 645,987 481,906 513,617 655,392 9,405 75%
23 Pension-PERS/PSERS 1,805,556 1,053,241 1,525,232 938,918 981,801 1,026,153 990,803 51,886 65%
24 Industrial Insurance 934,878 545,346 890,754 545,346 351,629 477,242 531,871 (13,475) 60%
25 Medical & Dental 6,457,336 3,766,779 6,202,336 3,639,279 3,207,246 3,349,666 3,663,712 24,433 59%
26 Unemployment - - 100,000 50,000 18,354 10,400 27,319 (22,681) 27%
28 Uniform/Clothing 8,525 2,498 8,525 2,498 2,553 1,783 1,334 (1,164) 16%
Total Salaries and Benefits 44,958,702 25,962,170 40,851,701 24,253,778 23,205,970 24,586,654 24,356,592 102,814 60%
ACTUAL
OVER/(UNDER)
2020 ANNUAL
2020
ALLOCATED
2020
ANNUAL
2020
ALLOCATED 2018 2019 2020
ALLOCATED
BDGT % EXPENDED
0 Transfers 7,319,140 2,085,815 7,119,140 1,985,815 3,932,572 3,425,593 2,068,215 82,400 29%
31 Supplies 1,066,112 653,408 777,148 435,203 551,037 932,596 393,875 (41,328) 51%
34 Items Purchased for resale 22,000 22,000 3,000 3,000 16,954 18,029 2,817 (183) 94%
35 Small Tools 133,569 72,408 86,569 48,908 50,521 63,941 46,731 (2,177) 54%
41 Professional Services 5,908,964 3,381,817 5,196,905 2,858,298 3,665,033 3,480,234 2,584,148 (274,150) 50%
42 Communication 434,600 253,517 429,600 251,017 239,075 215,105 252,867 1,851 59%
43 Travel 159,630 95,858 18,496 18,496 89,527 124,216 30,082 11,586 163%
4 4 Advertising 47,550 28,685 31,550 20,685 21,989 11,651 5,720 (14,965) 18%
45 Rentals and Leases 2,422,514 1,413,133 1,400,579 812,336 1,373,660 1,776,771 755,729 (56,607) 54%
46 Insurance 1,047,762 1,047,762 1,007,762 1,007,762 974,066 889,957 987,671 (20,091) 98%
47 Public Utilities 2,069,101 1,598,453 2,053,101 1,590,453 1,523,466 1,535,863 1,456,632 (133,821) 71%
48 Repairs and Maintenance 587,912 344,147 512,912 306,647 246,640 394,623 419,153 112,506 82%
49 Miscellaneous 1,273,723 729,703 975,994 541,163 821,780 643,462 599,242 58,079 61%
64 Machinery & Equipment 270,000 134,167 40,000 16,167 48,806 45,228 5,495 (10,672) 14%
Total Supplies, Services, and Capital 22,762,577 11,860,872 19,652,756 9,895,949 13,555,126 13,557,270 9,608,375 (287,574) 49%
Total Expenditures 67,721,279 37,823,043 60,504,457 34,149,727 36,761,096 38,143,924 33,964,966 (184,761) 56%
Percent of year completed 58%
SUPPLIES, SERVICES, AND
CAPITAL
BUDGET REVISED BUDGET
(COVID-19) ACTUAL COMPARISON OF
RESULTS
REVISED BUDGET
Year-to-Date as of July 31, 2020
SALARIES AND BENEFITS
BUDGET REVISED BUDGET
(COVID-19) ACTUAL COMPARISON OF
RESULTS
REVISED BUDGET
28
INFORMATIONAL MEMO
Page 7
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 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 28% 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. However, the planned transfer from the general fund to
the PW Shops fund is included in the updated financial projections.
COVID Expenditures
General Fund expenditures related to the COVID-19 pandemic began to be incurred in March.
These expenditures totaled $549,632 through July 31st and are reported by department in the
schedule below. COVID related expenditures in salaries and benefits include time dedicated to
the emergency operations center (EOC) as well as time spent analyzing the financial impacts of
the pandemic. Overtime and supplies are for time outside of normal operations spent in the EOC
as well as time responding directly to COVID-19 related activities. Supplies are for additional
PPE and disinfectant supplies.
Unbudgeted costs can be applied against CARES Act funding or FEMA funding and will not affect
ending fund balance. Budgeted salaries and benefits for time that has been redirected to
responding to the pandemic could qualify for reimbursement from CARES Act funding. Any
reimbursement for budgeted salaries and benefits would reduce the need for contingency funds
because the City had not received confirmation that CARES Act funding would be available.
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
29
INFORMATIONAL MEMO
Page 8
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$ -$ 293$ 2,077$
Mayor 76,059 - 284 76,344
Admin Services 38,146 - 399 38,544
Finance 39,434 386 372 40,192
Recreation 252,125 - 16,306 268,430
DCD 3,712 - 1,322 5,033
Court 114 137 3,414 3,664
Police 18,600 4,379 11,556 34,536
Fire 16,572 8,318 12,784 37,675
TIS 390 - 45 435
Public Works 6,673 318 13,805 20,796
Park Maintenance 21,906 - - 21,906
Total General Fund 475,514$ 13,538$ 60,580$ 549,632$
UNBUDGETED
30
INFORMATIONAL MEMO
Page 9
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 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
31
INFORMATIONAL MEMO
Page 10
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
32
INFORMATIONAL MEMO
Page 11
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. Staff is
working on updating projections for the two roadway projects and plans to provide a full update
to Council no later than early October. 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.
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 III 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.
33
INFORMATIONAL MEMO
Page 12
Variance
Annual Revised (COVID) Actual Expected Total Over/(Under) % of COVID
Budget Budget Year-To-Date +Through YE =Projected YE COVID Budget Budget
REVENUE:
General Revenue
Solid Waste/Recycling Utility Tax - - 40,651 - 40,651 40,651 -
Total Intergovernmental Revenue - - 40,651 - 40,651 40,651 -
Intergovernmental Revenue
Indirect Federal - SRTS 3,454,000 3,454,000 - - - (3,454,000) 0.0%
State Grant - Macadam 1,847,000 1,847,000 - - - (1,847,000) 0.0%
State Entitlements - MVFT Cities 290,000 200,000 169,585 30,415 200,000 - 100.0%
Total Intergovernmental Revenue 5,591,000 5,501,000 169,585 30,415 200,000 (5,301,000) 3.0%
Miscellaneous Revenue
** Charges for services - 134,682 134,682 - 134,682 - 100.0%
Investment earnings 20,000 - - - - - -
Total Miscellaneous Revenue 20,000 134,682 134,682 - 134,682 - 673.4%
Transfers In 100,000 100,000 - 100,000 100,000 - 100.0%
Total Revenues 5,711,000 5,735,682 344,919 130,415 475,334 (5,260,349) 6.0%
EXPENDITURES:
46thAve Safe Routes to School 1,832,000 1,832,000 - - - (1,832,000) 0.0%
Macadam Rd S Complete Street 1,847,000 1,847,000 - - - (1,847,000) 0.0%
S 152nd St Safe Routes to School 1,622,000 1,622,000 - - - (1,622,000) 0.0%
Traffic Calming/Residential Safety 400,000 50,000 34,895 15,105 50,000 - 100.0%
53rd Ave S - 399,000 228,532 170,468 399,000 - 100.0%
42nd Ave S Phase III - 378,000 349,693 28,307 378,000 - 100.0%
Interfund Loan Repayment - 336,932 252,500 84,433 336,932 - 100.0%
Total Expenditures 5,701,000 6,464,932 865,619 298,313 1,163,932 (5,301,000) 15.2%
Change in fund balances 10,000 (729,250) (688,599) 40,651 94.4%
Beginning Fund Balance 141,586 141,586 141,586 0 100.0%
Ending Fund Balance 151,586 (587,665) (547,013) 40,652 93.1%
City of Tukwila
Residential Street Fund 103 - Revenue and Expenditures
2020
Year-to-Date as of August 31, 2020
34
INFORMATIONAL MEMO
Page 13
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 156,052 143,948 300,000 0 64%
MVFT Cities 137,000 100,000 85,574 14,426 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 172,628 327,372 500,000 0 100%
Total General Revenue 1,787,000 1,580,000 414,254 1,165,746 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 75,379 324,621 400,000 187,000 187.8%
Total Charges for Services 513,000 513,000 75,379 624,621 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 Wa 2,614,000 2,614,000 78,208 2,535,792 2,614,000 - 100.0%
State Grant - West Valley Highway 2,694,000 2,694,000 88,662 2,605,338 2,694,000 - 100.0%
Total Charges for Services 44,977,000 5,308,000 166,869 5,141,131 5,308,000 - 11.8%
Miscellaneous Revenue
Investment earnings 20,000 15,000 11,753 2,000 13,753 (1,247) 68.8%
Contributions/Donations 30,000 30,000 11,000 - 11,000 (19,000) 36.7%
Total Miscellaneous Revenue 50,000 45,000 22,753 24,753 (20,247) 49.5%
Transfers In 1,000,000 328,137 - - 328,137 - 32.8%
Total Revenues 48,327,000 7,774,137 679,255 6,931,498 7,940,890 166,753 16.4%
EXPENDITURES:
Overhead (Salaries & Benefits)485,382 485,382 178,806 193,057 371,864 (113,518) 76.6%
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 89,308 2,524,692 2,614,000 - 100.0%
West Valley Highway 3,195,000 2,694,000 270,164 2,423,836 2,694,000 (501,000) 84.3%
42nd Ave S Bridge Replacement 1,600,000 1,000,000 1,912 998,088 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 21,767 18,233 40,000 - 100.0%
Transportation Comp Element Plan 400,000 200,000 1,338 198,662 200,000 (200,000) 50.0%
Walk & Roll 75,000 - - - - (75,000) 0.0%
Annual Overlay 1,400,000 510,000 173,364 336,636 510,000 (890,000) 36.4%
Annual Bridge Inspections 135,000 269,000 5,250 263,750 269,000 134,000 199.3%
Annual Traffic Signals 125,000 62,500 3,852 58,648 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 - - 120,914 5,080 125,994
TIB Channelization Study - - 19,920 5,080 25,000 25,000 -
2019 Traffic Calming/Res Safety - - 2,059 - 2,059 2,059 -
TUC Pedestrian/Bicycle Bridge - - 1,505 - 1,505 1,505 -
Riverton Creek Flap Gate Removal - - 254 - 254 254 -
S 196th/200th St Bridge - - 1,304 - 1,304 1,304 -
S 144th St Phase II (42nd Ave S - TIB)- 95,872 - 95,872 95,872 -
Total Expenditures 48,935,382 9,933,244 869,472 8,852,044 9,721,515 (39,213,867) 19.9%
Change in fund balances (608,382) (2,159,107) (190,216) (1,920,546) (1,780,625) 378,482 292.7%
Beginning Fund Balance 1,187,826 1,187,826 2,083,854 896,028 175.4%
Ending Fund Balance 579,444 (971,281) 303,229 1,274,510 52.3%
City of Tukwila
Arterial Street Fund 104 - Revenue and Expenditures
2020
Year-to-Date as of August 31, 2020
35
INFORMATIONAL MEMO
Page 14
Variance
Annual Revised (COVID) Actual Expected Total Over/(Under) % of COVID
Budget Budget Year-To-Date +Through YE =Projected YE COVID Budget Budget
REVENUE:
Miscellaneous Revenue
Investment earnings 500 500 3,716 1,000 4,716 3,216 743.1%
Total Miscellaneous Revenue 500 500 3,716 3,216 743.1%
Transfers In 200,000 - - - - - 0.0%
Total Revenues 200,500 500 3,716 3,716 3,216 1.9%
EXPENDITURES:
City Hall Siding/Roof Repair 50,000 50,000 - - - (50,000) 0.0%
TCC Siding/Roof Repair 100,000 120,000 - 120,000 120,000 - 100.0%
2020 Facilities Study 300,000 190,000 - 190,000 190,000 - 100.0%
Misc. Projects (including salaries & benefits)208,015 - 31,684 - 31,684 31,684 -
Install No Parking Signs at 6200/6300 Bldg 2,026 2,026
6300 Bldg. Dry Fire Sprinkler System 29,658 29,658
Total Expenditures 658,015 360,000 31,684 310,000 341,684 (18,316) 4.8%
Change in fund balances (457,515) (359,500) (337,968) 21,532 94.0%
Beginning Fund Balance 525,166 525,166 656,306 131,140 125.0%
Ending Fund Balance 67,651 165,666 318,338 152,672 192.2%
City of Tukwila
General Government Improvements Fund 303 - Revenue and Expenditures
Year-to-Date as of August 31, 2020
2020
36