HomeMy WebLinkAboutFIN 2022-11-28 Item 1 - Report - 2022 2nd Quarter Revenue and Expense ReportTO:
CC:
City of Tukwila
Allan Ekberg, Mayor
INFORMATIONAL MEMORANDUM
Finance & Governance Committee
Mayor Ekberg
FROM: Vicky Carlsen, Finance Director
BY: Tony Cullerton, Deputy Finance Director
DATE: November 28, 2022
SUBJECT: 2022 2"d Quarter Financial Summary
ISSUE
The quarterly financial report summarizes the citywide financial results and highlights significant
items or trends. The second quarter financial report is based on data available as of August 5,
2022, for the reporting period ending June 30, 2022.
Allocated budgets are calculated based on the patterns of revenue received and expenditures
made in the previous year with the current year budget allocated using the same patterns.
Additional details can be found in the attached financial reports.
DISCUSSION
The first half of 2022 appears to be emerging from the COVID pandemic. 2022 ongoing
revenues are higher than the same period last year and are exceeding allocated budget. One-
time revenues are below allocated budget due to timing differences of when revenues are
recorded.
Overall prices and costs have risen, with June CPI reporting a 9.1% increase over the prior year.
The City of Tukwila is not immune to rising costs and continues to be challenged with finding way
to maintaining current levels of service.
Staff continues to aggressively monitor and manage their departments budgets closely. Ongoing
revenues for the general fund are at 49% of total budget. Staff has responded and held ongoing
expenditures to 47% of budget.
Highlights for 2022 are as follows:
General Fund revenues totaled $35.6 million, and expenditures totaled $33.4 million. Total
revenues increased by 4.75% compared to the 2nd quarter last year. The City is cautiously
optimistic and continues to monitor expenses closely.
• Sales Tax, Utility Tax, Gambling Tax, and Admission Tax all grew by more than 5% over
the same period last year.
• Property Tax, Interfund Utility Tax and Building Permits reported consistent steady growth
of less than 5% change compared to last year.
1
INFORMATIONAL MEMO
Page 2
• Business Licenses reported a decline in revenue of slightly over 5% compared to the first
six months of the prior year.
• Four General Fund departments are above the allocate budget with Fire being the only
department that is expected to need a budget amendment at the end of the year due to
an increase in overtime costs.
• Total salaries and benefits are below allocated budget by $133,736.
• Total supplies are below allocated budget by $26,636.
• Total services is slightly than the allocated budget, reporting at 51.6% of budget.
ATTACHMENTS
2nd Quarter 2022 Financial Report
• Highlights of 2021 -2nd Quarter
• General Fund financial reports
• Other Funds Charts
2
CITY OF TUKWILA
2022 Q2 FINANCIAL REPORT
Highlights
General Fund
Revenue and Expenditures, Ending Fund Balance
At the end of second quarter, general fund total revenue was $35.7 million. General Fund total
expenses were $33.4 million. The variance between budget to actual is primarily a function of
pending interfund transfers for both revenues and expenditures compared to the same period
in the prior year. We have acknowledged the pending transfers over the past few months
during the General Fund monthly expenditure report presentations.
39,000,000
38,000,000
37,000,000
36,000,000
35,000,000
34,000,000
33,000,000
32,000,000
31,000,000
30,000,000
4
General Fund
2022 Revenues & Expenditures
Budget vs Actual
38,415,325
35,669,968
37,291,250
33,363,597
Revenues Expenditures
■ 2022 YTD Budget ■ 2022 YTD Actual
General Fund Revenue - Year -to -Date as of Jun 30, 2022
SUMMARY BY REVENUE TYPE
BUDGET
ACTUAL
COMPARISON OF RESULTS
2022
Annual
2022
Allocated
2020
2021
2022
Allocated Budget
vs Actuals
OVER/(UNDER)
%
Received
2021/2022
Property Tax
17,300,000
9,446,179
8,565,413
9,227,770
9,290,345
(155,834)
53.70%
0.68%
Sates Taxes -Retail
19,550,000
9,522,389
8,787,686
9,084,018
9,796,739
274,351
50.11%
7.85%
Use Taxes
750,000
415,524
336,428
368,431
435,195
19,671
58.03%
18.12%
Admission Taxes
750,000
135,886
327,340
108,709
429,666
293,780
57.29%
295.25%
Utility Taxes
3,620,000
1,992,988
2,164,885
1,937,933
2,353,223
360,235
65.01%
21.43%
Interfund Utility Taxes
2,447,700
1,472,913
1,364,085
1,424,471
1,484,378
11,465
60.64%
4.21%
Gambling & Excise Taxes
3,791,000
1,943,530
1,707,565
1,710,265
2,355,729
412,199
62.14%
37.74%
Total Tax Revenue
48,208,700
24,929,407
23,253,402
23,861,597
26,145,274
1,215,867
54.23%
9.57%
Business Licenses
3,320,000
1,542,351
2,712,868
1,542,351
1,459,553
(82,798)
43.96%
(5.37%)
Rental Housing permits
52,000
46,714
40,775
45,816
41,392
(5,322)
79.60%
(9.66%)
Building Permits
2,388,100
923,682
836,390
918,654
937,358
13,675
39.25%
2.04%
Franchise fees
350,000
195,130
187,424
181,192
221,720
26,590
63.35%
22.37%
Total Licenses and Permits
6,110,100
2,707,878
3,777,457
2,688,013
2,660,023
(47,855)
43.53%
(1.04%)
Sales Tax Mitigation payments
792,000
528,357
0
882,597
441,298
(87,059)
55.72%
(50.00%)
SCLAgreement
2,350,000
1,185,737
1,211,100
1,160,509
1,269,114
83,377
54.00%
9.36%
Grant Revenues
3,163,497
689,859
116,979
307,203
1,087,172
397,313
34.37%
253.89%
State Entitlements
483,500
289,507
338,675
273,340
287,398
(2,109)
59.44%
5.14%
Intergovernmental Revenue
585,607
518,931
505,836
502,645
576,471
57,540
98.44%
14.69%
Total Intergovernmental Revenue
7,374,604
3,212,391
2,172,591
3,126,295
3,661,453
449,062
49.65%
17.12%
General Government Revenue
27,900
18,380
16,302
17,260
14,018
(4,362)
50.24%
(18.78%)
Security revenue
598,425
340,187
290,902
459,096
485,958
145,771
81.21%
5.85%
Transportation Revenue
44,000
0
980
0
33
33
0.08%
Plan Check and Review fees
991,100
310,857
462,062
357,653
343,923
33,066
34.70%
(3.84%)
Culture and Recreation fees
398,500
44,374
59,229
44,263
77,861
33,487
19.54%
75.91%
Total Charges for Services
2,059,925
713,798
829,475
878,272
921,793
207,995
44.75%
4.96%
Fines and Penalties
576,925
136,302
72,764
64,823
347,765
211,462
60.28%
436.48%
Other Income
356,466
221,849
390,407
219,977
206,519
(15,330)
57.94%
(6.12%)
Indirect Cost Allocation
2,687,997
1,343,997
1,318,645
1,330,690
1,343,991
(6)
50.00%
1.00%
Investment earnings
100,000
14,626
61,987
14,626
51,745
37,119
51.75%
253.78%
Rent & Concessions
372,500
37,007
125,931
37,007
102,953
65,946
27.64%
178.20%
Total Other Income
4,093,888
1,753,782
1,969,735
1,667,123
2,052,972
299,191
50.15%
23.14%
Transfers In
5,357,467
5,098,070
0
1,768,817
228,452
(4,869,618)
4.26%
(87.08%)
Total Non Operating Revenue
5,357,467
5,098,070
0
1,768,817
228,452
(4,869,618)
4.26%
(87.08%)
TOTAL REVENUE
73,204,684
38,415,325
32,002,660
33,990,117
35,669,968
(2,745,357)
48.73%
4.94%
3
5
General Revenues — Taxes
Sales and Use Tax
Combined sales and use taxes through the second quarter totaled $9.8 million which is $274,351 above
the allocated budget and 7.8% higher than the same period last year.
10,000,000
9,800,000
9,600,000
9,400,000
9,200,000
9,000,000
8,800,000
8,600,000
8,400,000
8,200,000
8,787,686
Sales Tax- Retail
Jan - June
2020 - 2022
9,084,018
9,796,739
2020 2021 2022
The graph below shows that in the first half of 2022, retail sales tax has been trending higher than the
previous year.
2,500,000
2,000,000
1,500,000
1,000,000
500,000
0
6
Sales Tax - Retail
IliliLili III 11
Jan Feb Mar Apr May Jun
■ 2020 ■ 2021 ■ 2022
Property Tax
Property tax revenue through the second quarter is $9.2 million which is $155,834 less than the allocated
budget. While property tax is trailing budget expectations slightly, 2022 is 0.7% higher than the same
period last year.
9,400,000
9,200,000
9,000,000
8,800,000
8,600,000
8,400,000
8,200,000
8,565,413
Property Tax
Jan - June
2020 - 2022
9,227,770
9,290,345
2020 2021 2022
Property tax remittances appears to be normalizing for the past two years. In 2020, King County
announced that taxpayers would be able to delay payment of the first half of property taxes until June 1,
2020. 2nd quarter amounts are skewed due to the County offering an extended due date for remittance
due to the pandemic.
10,000,000
9,000,000
8,000,000
7,000,000
6,000,000
5,000,000
4,000,000
3,000,000
2,000,000
1,000,000
0
Property Tax
Jan
Feb
Mar
Apr
2020 2021 •2022
May
Jun
5
7
Utility Tax
Utility tax revenue through the second quarter is $2.4 million which is $360,235 greater than the allocated
budget. Utility tax is 21% higher than the same period last year.
2,500,000
2,000,000
1,500,000
1,000,000
500,000
0
2,500,000
2,000,000
1,500,000
1,000,000
500,000
0
8
2,164, 885
UtilityTax
Jan -June
2020 2022
1,937,933
2,353,223
2020 2021 2022
Utility Tax
Jan
Feb
Mar
Apr
2020 2021 2022
May
Jun
Interfund Utility Tax
Interfund Utility Tax revenue through the second quarter is $1.5 million which is $11,465 greater than the
allocated budget and a 4.2% increase over the same period last year.
1,500,000
1,480,000
1,460,000
1,440,000
1,420,000
1,400,000
1,380,000
1,360,000
1,340,000
1,320,000
1,300,000
Interfund Utility Tax
Jan -June 2020 - 2022
1,364,085
1,424,471
1,484,378
2020 2021 2022
Over the course of the past three years, Interfund Utility tax has consistently trended up by approximately
4% annually.
1,600,000
1,400,000
1,200,000
1,000,000
800,000
600,000
400,000
200,000
0
Interfund Utility Tax
Jan
Feb
Mar
Apr May
2020 2021 •2022
Jun
7
9
Gambling Tax
Gambling Tax revenue through the second quarter is $2.4 million which is $412,200 greater than the
allocated budget and an increase of $37.7% compared to the same period last year.
2,500,000
2,000,000
1,500,000
1,000,000
500,000
0
Gambling Tax
Jan - June
2020 - 2022
1,707,565 1,710,265
2,355,729
2020 2021 2022
Because of the significant increase over the same period last year, we have presented the 12 -month
actuals for years 2020 and 2021. The graph below shows an increase in gambling tax taking off in the last
6 months in 2021.
5,000,000
4,500,000
4,000,000
3,500,000
3,000,000
2,500,000
2,000,000
1,500,000
1,000,000
500,000
0
10
Gambling Tax
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2020 2021 2022
8
Admissions Tax
Admission Tax revenue through the second quarter is $429,666 which is $293,780 more than the allocated
budget. Additionally, Admissions Tax revenue is significantly higher than the same period last year,
reporting an increase of 295%. This large increase reported increase is primarily due to the timing of
recognizing the 2021 Admission Tax.
500,000
400,000
300,000
200,000
100,000
0
327,340
Admission Tax
Jan -June
2020 - 2022
108,709
429,666
2020 2021 2022
The Admission tax line graph displays monthly revenues and is extended out to December for both 2020
and 2021. The purpose of this display to realize after posting all revenues through year-end, 2021
outperforms 2020, as would be expected.
600,000
500,000
400,000
300,000
200,000
100,000
0
Admission Tax
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2020 2021 2022
9
11
Business Licenses
Business License revenue through the second quarter totaled $1.5 million, which is $82,798 thousand
below the allocated budget. With the State taking over the issuing of business licenses in 2019,
revenues are more evenly spread throughout the year as opposed to primarily at the start of the year.
This occurred as a result of the State setting the expirations of city licenses to align with their state
license. Looking at monthly trends, the City averages over $200 thousand in business license revenue.
Additionally, a couple of large employers renew in September.
3,000,000
2,500,000
2,000,000
1,500,000
1,000,000
500,000
0
2,712,868
Business Licenses
Jan -June
2020 - 2022
1,542,351
1,459,553
1
2020 2021 2022
The City is currently trailing last year's business licenses revenues by approximately 5.4%. It appears
that business license revenue will finish the year below reported revenue for 2021.
5,000,000
4,500,000
4,000,000
3,500,000
3,000,000
2,500,000
2,000,000
1,500,000
1,000,000
500,000
0
12
Business License
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2020 2021 2022
The table below displays business license revenue by month for the past 2.5 years. Q3 is expected to
report larger declines compared to 2021 Q3.
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2020 1,169,535 790,651 239,674 103,379 135,536 274,094 1,389,468 984,181 1,016,131 289,314 346,422 330,702
2021 529,801 208,459 214,862 224,250 116,368 248,611 773,019 403,624 878,528 487,241 350,926 311,577
2022 491,928 157,819 278,680 155,410 172,234 203,483 721,345 379,924 499,564
Building Permits
Building Permits revenue through the second quarter is $937,358, which is $13,675 more than the
allocated budget. Building Permits revenue is trending similar to last year, with a slight increase of 2%
over last year.
960,000
940,000
920,000
900,000
880,000
860,000
840,000
820,000
800,000
780,000
1,000,000
900,000
800,000
700,000
600,000
500,000
400,000
300,000
200,000
100,000
0
836,390
2020
Building Permits
Jan - June
2020 - 2022
918,654
2021
Building Permits
937,358
2022
Jan
Feb
Mar
Apr
2020 2021 2022
May
Jun
11
13
Ongoing Expenditures
General Fund Departmental
General Fund departmental expenditures totaled $30.75 million through June, which is $19,775 more
than the allocated budget of $30.73 million. Department 20, which is transfers to other funds, totaled
$2.62 million, which is $2.20 million less than the allocated budget. The allocated budget is calculated to
reflect year-to-date spending patterns of the previous year. Transfers to capital project funds are not done
on a monthly basis. Rather, funds are transferred to capital project funds only as needed for cash flow
purposes. Debt service transfers are done quarterly.
In total, the General Fund reported expenditures of $33.36 million, which is equivalent to 44.73% of the
annual budget at the completion of 50% of the year. While the General Fund as a whole is currently
tracking expenditures below the YTD annual budget, four departments are trending slightly higher than
50% of the annual budget at the completion of June.
Finance reported expenditures totaling 52.44% of the annual budget. The additional 2.44% above the
annual budget is primarily due to a Finance Enterprise ERP milestone payment. The milestone payments
have been factored into the annual budget and will normalize throughout the year. Fire reported
expenditures totaling 51.63% of annual budget at the completion of 50% of the year. The slight overage
of 1.63% is attributed to YTD overtime. Parks Maintenance reported expenditures of 51.04% of Jan -
June annual budget. The 1.04% is primarily a result of an increase in the Professional Services category,
specifically Security & Safety billings. As of the end of June, Street Maintenance reported department
expenditures of 60.93% of annual budget. However, this percentage represents only a $197 increase
over their allocated budget. Staff will continue to monitor budgets closely and communicate if any
department is in danger of exceeding annual budget.
Department Variances
Year to Date Department Expenditures Compared to Allocated Budget Through June 2022:
EXPENDITURES BY DEPARTMENT
BUDGET
ACTUAL
2022
2022
2020
2021
2022
%
Expended
Annual
Allocated
City Council
385,826
175,485
171,186
165,384
171,690
44.50%
Mayor's Office
2,565,927
1,125,383
1,078,512
955,299
945,654
36.85%
Administrative Services
5,869,141
2,575,584
2,106,663
2,263,791
2,332,018
39.73%
Finance Department
3,347,587
1,605,708
1,386,084
1,434,962
1,755,424
52.44%
Recreation Department
3,233,011
1,274,973
1,331,237
1,181,978
1,321,741
40.88%
Community Development (DCD)
4,662,212
2,049,007
1,595,958
1,923,169
2,000,125
42.90%
Municipal Court
1,597,482
722,703
647,626
610,043
770,679
48.24%
Police Department
19,844,123
9,314,472
8,900,343
8,689,475
9,175,970
46.24%
Fire Department
14,297,033
7,059,580
6,276,341
6,782,979
7,381,006
51.63%
Public Works Dept
3,982,685
1,870,169
1,865,700
1,704,884
1,909,074
47.93%
Park Maintenance Dept
1,726,097
851,779
812,516
777,811
881,043
51.04%
Street Maintenance Dept
3,452,085
2,103,071
1,851,730
1,941,381
2,103,267
60.93%
Subtotal
64,963,209
30,727,914
28,023,897
28,431,157
30,747,691
47.33%
Non Departmental
9,619,291
4,835,506
2,068,215
2,731,380
2,615,906
27.19%
Total
74,582,500
35,563,420
30,092,112
31,162,537
33,363,597
44.73%
12
14
General Fund by Category as of June 30th, 2022.
Salaries and benefits for the first half of the year was $22.8 million. This is $133,736 less than the
allocated budget and represents 47% expended at 50% of the year. This is primarily due to the to frozen
positions and unfilled authorized positions. Total Services was slightly higher, expending 51% of the
annual budget at 50% of the year. Looking ahead to future anticipated spending, expenditures are
expected to come in line with budget expectations by the end of 3rd quarter.
13
15
BUDGET
ACTUAL
COMPARISON OF RESULTS
2022
Annual
2022
Allocated
2020
2021
2022
Allocated Budget
vs Actuals
OVER/(UNDER)
%
% Change
Expended
2020/2021
2021/2022
Salaries
32,802,451
15,514,153
14,376,560
13,869,570
14,981,786
(532,367)
45.67%
(3.53%)
8.02%
Extra Labor
584,220
31,210
118,475
27,684
163,404
132,194
27.97%
(76.63%)
490.24%
Overtime
2,000,115
976,978
520,728
1,064,168
1,355,822
378,845
67.79%
104.36%
27.41%
Holiday Pay
515,500
72,268
63,624
72,268
79,193
6,925
15.36%
13.59%
9.58%
FICA
2,151,955
976,939
899,048
872,949
968,801
(8,138)
45.02%
(2.90%)
10.98%
Pension-LEOFF
920,517
445,550
587,334
435,536
541,531
95,981
58.83%
(25.85%)
24.34%
Pension-PERS/PSERS
1,494,905
755,684
863,764
824,671
731,941
(23,743)
48.96%
(4.53%)
(11.24%)
Industrial Insurance
876,892
468,354
469,408
467,781
363,132
(105,222)
41.41%
(0.35%)
(22.37%)
Medical & Dental
7,551,216
3,775,501
3,156,066
3,451,962
3,682,978
(92,523)
48.77%
9.38%
6.69%
Unemployment
0
0
27,319
20,710
15,108
15,108
(24.19%)
(27.05%)
Uniform/Clothing
8,525
1,634
1,094
1,634
840
(795)
9.85%
49.44%
(48.62%)
Total Salaries & Benefits
48,906,296
23,018,271
21,083,421
21,108,934
22,884,535
(133,736)
46.79%
0.12%
8.41%
Supplies
890,636
239,272
216,186
235,269
147,546
(91,726)
16.57%
8.83%
(37.29%)
Repairs & Maint Supplies
299,025
122,623
132,698
107,245
176,996
54,374
59.19%
(19.18%)
65.04%
Resale Supplies
10,000
0
235
0
93
93
0.93%
(100.00%)
Small Tools
41,250
14,183
45,702
14,871
19,392
5,209
47.01%
(67.46%)
30.41%
Technology Supplies
13,000
13,000
14,579
16,236
16,484
3,484
126.80%
11.36%
1.53%
Fleet Supplies
3,000
1,288
10,772
1,288
3,217
1,929
107.23%
(88.04%)
149.74%
Total Supplies
1,256,911
390,365
420,173
374,908
363,729
(26,636)
28.94%
(10.77%)
(2.98%)
Professional Services
7,391,918
3,484,337
3,236,221
3,373,749
3,475,605
(8,732)
47.02%
4.25%
3.02%
Communications
458,739
214,258
215,927
214,258
203,393
(10,865)
44.34%
(0.77%)
(5.07%)
Professional Development
252,921
252,921
166,123
228,382
179,506
(73,415)
70.97%
37.48%
(21.40%)
Advertising
40,250
3,765
9,126
3,998
3,946
182
9.80%
(56.18%)
(1.30%)
Rentals
478,484
182,699
209,940
198,825
94,546
(88,152)
19.76%
(5.29%)
(52.45%)
Technology Services
348,291
233,754
465,474
242,801
318,540
84,786
91.46%
(47.84%)
31.19%
Utilities
2,034,285
1,626,584
1,400,506
1,592,330
1,627,047
463
79.98%
13.70%
2.18%
Repairs & Maint Services
2,185,367
1,024,844
623,657
979,598
1,112,154
87,310
50.89%
57.07%
13.53%
Miscellaneous
879,747
45,711
187,836
37,190
247,835
202,124
28.17%
(80.20%)
566.40%
Total Services
14,070,002
7,068,872
6,514,809
6,871,132
7,262,574
193,701
51.62%
5.47%
5.70%
Machinery & Equipment
730,000
103,629
5,495
76,184
236,853
133,224
32.45%
1,286.54%
210.90%
Total Capital Outaly
730,000
103,629
5,495
76,184
236,853
133,224
32.45%
1,286.54%
210.90%
Transfers Out
9,619,291
4,982,283
2,068,215
2,731,380
2,615,906
(2,366,377)
27.2%
(56.18%)
31.19%
TOTAL EXPENDITURES
74,582,500
35,563,421 30,092,112
31,162,537
33,363,597 166,552
47.33%
1.45%
8.15%
13
15
Other Funds
Capital Projects:
• Land sale revenue was received in the Urban renewal fund. These funds are budgeted to be
used to repay the line of credit that is due December 1, 2022.
• Initial Allentown Speed and Safety Study was presented to the Tukwila community.
• In second quarter there was successful finalization of the Type Size and Location report for 42"
Ave Bridge.
• Substantially completed Phase 1 of PW shops and staff moved into new Fleet & Facilities
building.
Enterprise Funds:
• Macadam Road Water Main Upgrade — substantially completed construction.
• Sewer Lift Stations 2 and Force Main Repairs/Upgrades: Most work items under this project
have been completed except for work electrical components including installing control panel
internals and a generator. The delay has been due to supply chain issues.
• Riverton Creek Flapgate Removal Project The City has received feedback from WSDOT and
adjacent property owner's irrigation testing (project impacted the irrigation system). WSDOT
has requested additional information on localized rust occurring on the WSDOT tie -back wall.
Otak provided an evaluation of the rust and is recommending sealing and painting the joints
along the lower anchors. The City also provided prime contractor RL Alia with irrigation test
deficiencies to be corrected. A change order notice to proceed was issued for the Phase 2
portion of the project, the restoration component for 2 additional years of maintenance from At
Work! Enterprises.
• Completed East Marginal Way Stormwater Outfalls Project
16
14
CITY OF TUKWILA
2022 2ND QUARTER FINANCIAL REPORT
OTHER FUNDS
FINANCIAL REPORTS
City of Tukwila
Contingency Fund 105 - Revenue and Expenditures
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
361 Interest and Other Earnings 20,000 27,435 7,435 137.2%
Total Revenues 20,000 27,435 7,435 137.2%
730
Transfers In 0 0
Beginning Fund Balance
Change in Fund Balance
Ending Fund Balance
0 0 0 -
6,468,169 6,754,065 4.4%
20,000 27,435 37.2%
6,488,169 6,781,501 4.5%
15
17
City of Tukwila
Drug Seizure Fund 109 - Revenue and Expenditures
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
331 Federal Direct Grants 0 13,368 13,368
361 Interest and Other Earnings 500 0 (500)
369 Other Miscellaneous Revenues 70,000 0 (70,000)
Total Revenues 70,500 13,368 (57,132)
EXPENDITURES:
531 Supplies 40,000 5,979 34,021
535 Small Tools 0 7,864 (7,864)
536 Technology Supplies 0 0
541 Professional Services 0 85,000 (85,000)
543 Professional Development 0 0
546 Technology Services 0 25,283 (25,283)
Total Expenditures 40,000 124,126 (84,126)
19.0%
14.9%
310.3%
Beginning Fund Balance
Change in Fund Balance
Ending Fund Balance
166,034
30,500
196,534
567,273
(110,758)
456,515
241.7%
(463.1)%
132.3%
16
18
City of Tukwila
Hotel/Motel Tax Special Rev Fd 101- Revenue and Expen1
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
313 Retail Sales and Use Taxes 450,000 306,724 (143,276) 68.2%
361 Interest and Other Earnings 6,000 3,238 (2,762) 54.0%
369 Other Miscellaneous Revenues 0 0
Total Revenues 456,000 309,962 (146,038) 68.0%
EXPENDITURES:
511 Salaries 63,732 32,356 31,376 50.8%
521 FICA 4,872 2,369 2,503 48.6%
523 Pension-PERS/PSERS 6,238 3,243 2,995 52.0%
524 Industrial Insurance 259 122 137 47.2%
525 Medical & Dental 7,966 2,534 5,432 31.8%
531 Supplies 5,000 27 4,973 0.5%
541 Professional Services 425,000 60,750 364,250 14.3%
543 Professional Development 10,000 2,143 7,857 21.4%
544 Advertising 250,000 47,304 202,696 18.9%
546 Technology Services 0 144 (144)
549 Miscellaneous 218,000 (14) 218,014 (0.0%)
Total Expenditures 991,067 150,979 840,088 15.2%
750 Transfers Out 25,231 12,613 12,618 50.0%
25,231 12,613
12,618 50.0%
Beginning Fund Balance
Change in Fund Balance
Ending Fund Balance
1,016,608
(560,298)
456,310
1,742,366
146,370
1,888,736
71.4%
126.1%
313.9%
17
19
City of Tukwila
Debt Service 200 - Revenue and Expenditures
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
361 Interest and Other Earnings 2,000 0 (2,000)
Total Revenues 2,000 0 (2,000)
EXPENDITURES:
571 Bond Principal 2,536,000 0 2,536,000 -
583 Bond Interest 203,684 97,002 106,683 47.6%
Total Expenditures 2,739,684 97,002 2,642,683 3.5%
730 Transfers In 2,739,684 229,278 (2,510,407) 8.4%
2,739,684 229,278 (2,510,407) 8.4%
Beginning Fund Balance 36,541 0 (100.0)%
Change in Fund Balance 2,000 132,276 6,514.1%
Ending Fund Balance 38,541 132,276 243.2%
City of Tukwila
DS Fund -LID #33 233 - Revenue and Expenditures
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
361 Interest and Other Earnings 136,000 148 (135,852)
368 Special Assessments 445,000 0 (445,000)
369 Other Miscellaneous Revenues 0 0
Total Revenues 581,000 148 (580,852)
0.1%
0.0%
EXPENDITURES:
571 Bond Principal 445,000 375,000 70,000 84.3%
583 Bond Interest 183,563 161,063 22,501 87.7%
Total Expenditures 628,563 536,063 92,501 85.3%
Beginning Fund Balance
Change in Fund Balance
Ending Fund Balance
574,984
(47,563)
527,421
601,809
(535,914)
65,895
4.7%
(1,026.7)%
(87.5)%
20
City of Tukwila
Residential Streets Fund 103 - Revenue and Expenditures
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
288 Unassigned Fund Balance 0 0
333 Federal Indirect Grants 2,736,000 0 (2,736,000)
334 State Grants 450,000 0 (450,000)
336 State Shared Rev 250,000 141,155 (108,845)
337 Local Grants & Other Payments 0 0
361 Interest and Other Earnings 20,000 1,493 (18,507)
Total Revenues 3,456,000 142,648 (3,313,352)
EXPENDITURES:
511 Salaries 0 24,854 (24,854)
521 FICA 0 1,889 (1,889)
523 Pension-PERS/PSERS 0 2,548 (2,548)
524 Industrial Insurance 0 489 (489)
525 Medical & Dental 0 4,924 (4,924)
531 Supplies 0 89 (89)
532 Repairs & Maint Supplies 0 4,046 (4,046)
535 Small Tools 400,000 (180) 400,180
541 Professional Services 0 81,459 (81,459)
549 Miscellaneous 0 105 (105)
565 Construction Projects 3,610,000 0 3,610,000
Total Expenditures 4,010,000 120,223 3,889,777
730 Transfers In 400,000 61,509 (338,491)
400,000 61,509 (338,491)
56.5%
7.5%
4.1%
(0.0%)
3.0%
15.4%
15.4%
Beginning Fund Balance
Change in Fund Balance
Ending Fund Balance
724,912
(154,000)
570,912
707,806
83,934
791,741
(2.4)%
154.5%
38.7%
19
21
City of Tukwila
Arterial Street Fund 104 - Revenue and Expenditures
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
288 Unassigned Fund Balance 0 0 -
316 Business and Utility Taxes 800,000 650,690 (149,310) 81.3%
318 Other Taxes 900,000 1,141,736 241,736 126.9%
321 Business Licenses and Permits 0 0 -
322 Non -Business Licenses and Prmt 0 4,482 4,482 -
333 Federal Indirect Grants 1,400,000 89,166 (1,310,834) 6.4%
334 State Grants 5,000,000 430,858 (4,569,142) 8.6%
336 State Shared Rev 140,000 72,286 (67,714) 51.6%
337 Local Grants & Other Payments 0 0 -
345 Natural and Economic Environme 161,000 224,096 63,096 139.2%
361 Interest and Other Earnings 30,000 6,073 (23,927) 20.2%
367 Contributions & Donations NonG 80,000 88,933 8,933 111.2%
Total Revenues 8,511,000 2,708,319 (5,802,681) 31.8%
EXPENDITURES:
511 Salaries 258,434 200,768 57,666 77.7%
513 Overtime 0 0 -
521 FICA 19,757 15,251 4,506 77.2%
523 Pension-PERS/PSERS 25,362 20,579 4,783 81.1%
524 Industrial Insurance 1,043 2,010 (967) 192.7%
525 Medical & Dental 38,503 31,185 7,318 81.0%
531 Supplies 0 46 (46) -
532 Repairs & Maint Supplies 0 0 -
535 Small Tools 0 18,876 (18,876) -
541 Professional Services 360,000 140,531 219,469 39.0%
544 Advertising 0 4 (4) -
547 Utilities 0 0 -
548 Repairs & Maint Services 1,425,000 1,392 1,423,608 0.1%
563 Other Improvements 0 0 -
564 Machinery & Equipment 35,000 0 35,000 -
565 Construction Projects 7,144,000 2,096,290 5,047,710 29.3%
Total Expenditures 9,307,099 2,526,932 6,780,167 27.2%
730 Transfers In 1,700,000 0 (1,700,000)
1,700,000 0 (1,700,000)
Beginning Fund Balance
Change in Fund Balance
Ending Fund Balance
2,516,741
903,901
3,420,642
3,682,187
181,387
3,863,574
46.3%
(79.9)%
12.9%
22
City of Tukwila
Land Acq., Rec. & Park Devlpmn 301- Revenue and Expenditures
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
311 Property Tax 304,000 121,151 (182,849)
318 Other Taxes 0 0
345 Natural and Economic Environme 101,000 302,355 201,355
361 Interest and Other Earnings 5,000 5,112 112
39.9%
299.4%
102.2%
Total Revenues 410,000 428,618 18,618 104.5%
EXPENDITURES:
541 Professional Services 79,000 37,154 41,846 47.0%
547 Utilities 0 1,500 (1,500)
548 Repairs & Maint Services 0 2,766 (2,766)
563 Other Improvements 0 76,339 (76,339)
564 Machinery & Equipment 0 0
565 Construction Projects 426,000 17,561 408,439 4.1%
Total Expenditures 505,000 135,319 369,681 26.8%
730 Transfers In 72,290 0 (72,290)
72,290 0 (72,290)
Beginning Fund Balance 1,541,330 2,895,845 87.9%
Change in Fund Balance (22,710) 293,299 1,391.5%
Ending Fund Balance 1,518,620 3,189,144 110.0%
21
23
City of Tukwila
Urban Renewal 302 - Revenue and Expenditures
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
361
395
Total Revenues
Interest and Other Earnings
Disposition of Capital Assets
10,000
1,850,000
1,860,000
5,174 (4,826)
1,500,000 (350,000)
1,505,174 (354,826)
51.7%
81.1%
80.9%
EXPENDITURES:
541 Professional Services 10,000 6,760 3,240 67.6%
547 Utilities 0 4,485 (4,485) -
563 Other Improvements 0 0
Total Expenditures 10,000 11,245 (1,245) 112.4%
750
Transfers Out 3,186,000 228,452 2,957,548
3,186,000 228,452 2,957,548
7.2%
7.2%
Beginning Fund Balance
Change in Fund Balance
Ending Fund Balance
1,452,144
(1,336,000)
116,144
4,469,671
1,265,477
5,735,147
207.8%
194.7%
4,838.0%
City of Tukwila
General Governmnt Improvements 303 - Revenue and Expenditures
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
288 Unassigned Fund Balance 0 0 -
334 State Grants 0 0
361 Interest and Other Earnings 500 1,069 569 213.8%
Total Revenues 500 1,069 569 213.8%
EXPENDITURES:
541 Professional Services 50,000 24,980 25,020 50.0%
542 Communications 0 0
548 Repairs & Maint Services 0 0 -
562 Capital Outlay -Buildings & Str 0 0 -
564 Machinery & Equipment 0 0 -
565 Construction Projects 150,000 0 150,000
Total Expenditures 200,000 24,980 175,020 12.5%
Beginning Fund Balance
Change in Fund Balance
Ending Fund Balance
573,148
(199,500)
373,648
678,033
(23,911)
654,122
18.3%
88.0%
75.1%
24
City of Tukwila
Fire Improvements 304 - Revenue and Expenditures
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
345
361
Total Revenues
Natural and Economic Environme
Interest and Other Earnings
300,000 87,250 (212,750)
500 0 (500)
300,500 87,250 (213,250)
750 Transfers Out 300,000
300,000
0 300,000
0 300,000
29.1%
29.0%
Beginning Fund Balance 500 0 (100.0)%
Change in Fund Balance 500 87,250 17,350.0%
Ending Fund Balance 1,000 87,250 8,625.0%
23
25
City of Tukwila
Public Safety Plan 305 - Revenue and Expenditures
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
318 Other Taxes 500,000 792,412 292,412
345 Natural and Economic Environme 300,000 0 (300,000)
361 Interest and Other Earnings 0 426 426
381 Other Increases in Fund Resour 0 0
390 Other Financing Sources 5,000,000 0 (5,000,000)
Total Revenues 5,800,000 792,839 (5,007,161)
158.5%
13.7%
EXPENDITURES:
531 Supplies 167,000 36,922 130,078 22.1%
535 Small Tools 0 0
547 Utilities 0 0
562 Capital Outlay -Buildings & Str 0 (1,302) 1,302
564 Machinery & Equipment 0 0
Total Expenditures 167,000 35,620 131,380 21.3%
730
750
Transfers In 300,000 0 (300,000)
300,000 0 (300,000)
Transfers Out 2,223,467 0 2,223,467
2,223,467 0 2,223,467
Beginning Fund Balance
Change in Fund Balance
Ending Fund Balance
6,976,196
3,709,533
10,685,729
77,672
757,219
834,891
(98.9)%
(79.6)%
(92.2)%
26
City of Tukwila
City Facilities 306 - Revenue and Expenditures
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
361
390
Total Revenues
Interest and Other Earnings
Other Financing Sources
0 5,443 5,443
0 0
0 5,443 5,443
EXPENDITURES:
531 Supplies 0 532 (532)
535 Small Tools 0 2,670 (2,670)
541 Professional Services 0 22,490 (22,490)
544 Advertising 0 0
547 Utilities 0 10,044 (10,044)
548 Repairs & Maint Services 0 23,320 (23,320)
549 Miscellaneous 0 0
562 Capital Outlay -Buildings & Str 1,425,000 994,945 430,055
563 Other Improvements 0 23,861 (23,861)
564 Machinery & Equipment 0 9,030 (9,030)
Total Expenditures 1,425,000 1,086,892 338,108
730 Transfers In 0 0
69.8%
76.3%
0
0 0
Beginning Fund Balance
Change in Fund Balance
Ending Fund Balance
3,138,454
(1,425,000)
1,713,454
3,500,044
(1,081,449)
2,418,595
11.5%
24.1%
41.2%
25
27
City of Tukwila
Water Utility Fund 401 - Revenue and Expenditures
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
333 Federal Indirect Grants 0 0 -
342 Public Safety 0 9,484 9,484 -
343 Utilities 6,866,000 2,994,873 (3,871,127) 43.6%
361 Interest and Other Earnings 61,000 13,960 (47,040) 22.9%
369 Other Miscellaneous Revenues 0 1,210 1,210 -
379 Capital Contributions 20,000 18,359 (1,641) 91.8%
391 Debt Issued 0 0 -
Total Revenues 6,947,000 3,037,885 (3,909,115) 43.7%
EXPENDITURES:
511 Salaries 715,163 263,532 451,631 36.8%
512 Extra Labor 4,000 1,536 2,464 38.4%
513 Overtime 10,000 6,563 3,437 65.6%
521 FICA 55,746 20,688 35,058 37.1%
523 Pension-PERS/PSERS 71,837 27,680 44,157 38.5%
524 Industrial Insurance 20,308 6,067 14,241 29.9%
525 Medical & Dental 198,893 67,735 131,158 34.1%
528 Uniform/Clothing 1,700 203 1,497 12.0%
531 Supplies 29,200 514 28,686 1.8%
532 Repairs & Maint Supplies 115,500 57,575 57,925 49.8%
534 Resale Supplies 0 0 -
535 Small Tools 2,500 1,526 974 61.0%
536 Technology Supplies 12,500 0 12,500 -
539 Water/Sewer Supplies 3,552,000 1,702,449 1,849,551 47.9%
541 Professional Services 673,376 206,051 467,325 30.6%
542 Communications 8,000 5,650 2,350 70.6%
543 Professional Development 7,500 7,935 (435) 105.8%
544 Advertising 0 58 (58) -
545 Rentals 41,377 21,518 19,859 52.0%
546 Technology Services 0 13,405 (13,405) -
547 Utilities 33,200 14,465 18,735 43.6%
548 Repairs & Maint Services 101,194 55,551 45,643 54.9%
549 Miscellaneous 1,048,450 509,579 538,871 48.6%
561 Capital Outlay -Land 10,000 0 10,000
563 Other Improvements 0 1,084 (1,084)
564 Machinery & Equipment 0 2,998 (2,998)
565 Construction Projects 1,800,000 1,037,693 762,307 57.6%
572 Revenue Bond 42,258 0 42,258 -
578 Intergov. Loan Principle 80,625 80,625 (0) 100.0%
583 Bond Interest 6,321 3,765 2,556 59.6%
Total Expenditures 8,641,648 4,116,445 4,525,203 47.6%
750 Transfers Out 1,078,123
1,078,123
531,560
531,560
546,564 49.3%
546,564 49.3%
Beginning Fund Balance
Change in Fund Balance
Ending Fund Balance
4,386,963
(2,772,771)
1,614,193
6,987,634
(1,610,120)
5,377,514
59.3%
41.9 %
233.1%
26
28
City of Tukwila
Sewer Utility Fund 402 - Revenue and Expenditure.
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
343 Utilities 10,205,000 4,475,459 (5,729,541) 43.9%
361 Interest and Other Earnings 55,000 33,435 (21,565) 60.8%
379 Capital Contributions 25,000 69,810 44,810 279.2%
Total Revenues 10,285,000 4,578,704 (5,706,296) 44.5%
EXPENDITURES:
511 Salaries 714,402 436,801 277,601 61.1%
512 Extra Labor 0 1,632 (1,632)
513 Overtime 7,000 2,666 4,334 38.1%
521 FICA 55,152 33,403 21,749 60.6%
523 Pension-PERS/PSERS 70,977 44,829 26,148 63.2%
524 Industrial Insurance 13,798 8,094 5,704 58.7%
525 Medical & Dental 176,776 108,376 68,400 61.3%
528 Uniform/Clothing 625 0 625
531 Supplies 14,600 2,939 11,661 20.1%
532 Repairs & Maint Supplies 8,000 6,461 1,539 80.8%
535 Small Tools 5,000 193 4,807 3.9%
536 Technology Supplies 0 0
537 Fleet Supplies 0 160 (160)
539 Water/Sewer Supplies 5,225,000 2,719,223 2,505,777 52.0%
541 Professional Services 827,339 114,572 712,767 13.8%
542 Communications 6,300 4,999 1,301 79.3%
543 Professional Development 0 811 (811)
545 Rentals 33,817 15,915 17,902 47.1%
546 Technology Services 2,000 14,030 (12,030) 701.5%
547 Utilities 47,500 19,333 28,167 40.7%
548 Repairs & Maint Services 91,802 25,784 66,018 28.1%
549 Miscellaneous 1,316,700 592,482 724,218 45.0%
564 Machinery & Equipment 0 25,101 (25,101)
565 Construction Projects 2,050,000 854,202 1,195,798 41.7%
572 Revenue Bond 100,769 0 100,769
578 Intergov. Loan Principle 233,436 233,436 0 100.0%
583 Bond Interest 17,349 11,244 6,105 64.8%
598 Misc Non -Operating 0 0
Total Expenditures 11,018,342 5,276,687 5,741,654 47.9%
750 Transfers Out 814,607 397,051 417,556 48.7%
814,607 397,051
417,556 48.7%
Beginning Fund Balance
Change in Fund Balance
Ending Fund Balance
11,022,180
(1,547,949)
9,474,232
13,158,275
(1,095,034)
12,063,241
19.4%
29.3%
27.3%
27
29
City of Tukwila
Foster Golf Course 411 - Revenue and Expenditures
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
317 Excise Taxes 3,000 0 (3,000) -
341 Genera! Government 130,000 78,435 (51,565) 60.3%
347 Culture and Recreational Fees 1,053,000 682,055 (370,945) 64.8%
361 Interest and Other Earnings 1,000 1,603 603 160.3%
362 Rents and Leases 343,000 166,465 (176,535) 48.5%
369 Other Miscellaneous Revenues 20,000 2,074 (17,926) 10.4%
Total Revenues 1,550,000 930,632 (619,368) 60.0%
EXPENDITURES:
511 Salaries 703,515 363,881 339,634 51.7%
512 Extra Labor 85,000 25,738 59,262 30.3%
513 Overtime 1,010 1,302 (292) 128.9%
521 FICA 60,346 29,430 30,916 48.8%
523 Pension-PERS/PSERS 76,445 38,001 38,444 49.7%
524 Industrial Insurance 25,830 9,561 16,269 37.0%
525 Medical & Dental 182,891 98,322 84,569 53.8%
526 Unemployment 5,600 0 5,600 -
528 Uniform/Clothing 1,100 488 612 44.3%
531 Supplies 21,500 2,834 18,666 13.2%
532 Repairs & Maint Supplies 56,000 66,398 (10,398) 118.6%
534 Resale Supplies 73,000 45,547 27,453 62.4%
535 Small Tools 42,500 565 41,935 1.3%
537 Fleet Supplies 32,000 20,050 11,950 62.7%
541 Professional Services 23,876 25,415 (1,539) 106.4%
542 Communications 5,600 3,137 2,463 56.0%
543 Professional Development 500 1,564 (1,064) 312.9%
544 Advertising 5,000 282 4,718 5.6%
545 Rentals 37,500 15,933 21,567 42.5%
546 Technology Services 0 1,913 (1,913) -
547 Utilities 71,700 68,066 3,634 94.9%
548 Repairs & Maint Services 81,800 36,238 45,562 44.3%
549 Miscellaneous 38,500 22,465 16,035 58.4%
563 Other Improvements 50,000 0 50,000 -
564 Machinery & Equipment 0 0 -
Total Expenditures 1,681,213 877,131 804,082 52.2%
730 Transfers In 300,000
300,000
150,000 (150,000) 50.0%
150,000 (150,000) 50.0%
750 Transfers Out 209,366 104,430 104,936
209,366 104,430 104,936
49.9%
49.9%
Beginning Fund Balance
Change in Fund Balance
Ending Fund Balance
1,056,224
(40, 579)
1,015,645
1,044,149
99,071
1,143,220
28
30
City of Tukwila
Surface Water Utility Fund 412 - Revenue and Expenditu
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
334 State Grants 64,000 0 (64,000)
337 Local Grants & Other Payments 317,000 0 (317,000)
343 Utilities 7,350,000 7,389,873 39,873 100.5%
361 Interest and Other Earnings 50,000 17,663 (32,337) 35.3%
374 Capital Contrib-State/Local/Di 2,728,000 (173,190) (2,901,190) (6.3%)
375 Capital Contributions -Indirect 0 (31,285) (31,285) -
Total Revenues 10,509,000 7,203,060 (3,305,940) 68.5%
EXPENDITURES:
511 Salaries 1,220,759 606,130 614,629 49.7%
512 Extra Labor 8,000 1,632 6,368 20.4%
513 Overtime 13,000 2,880 10,120 22.2%
521 FICA 94,934 46,285 48,649 48.8%
523 Pension-PERS/PSERS 122,236 62,424 59,812 51.1%
524 Industrial Insurance 26,559 12,867 13,692 48.4%
525 Medical & Dental 323,938 155,337 168,601 48.0%
528 Uniform/Clothing 1,500 543 957 36.2%
531 Supplies 86,000 7,801 78,199 9.1%
532 Repairs & Maint Supplies 1,500 671 829 44.8%
535 Small Tools 6,500 2,911 3,589 44.8%
536 Technology Supplies 0 470 (470)
537 Fleet Supplies 0 160 (160)
541 Professional Services 2,680,014 269,956 2,410,058 10.1%
542 Communications 7,000 3,076 3,924 43.9%
543 Professional Development 0 7,802 (7,802)
544 Advertising 0 1,113 (1,113) -
545 Rentals 130,343 63,191 67,152 48.5%
546 Technology Services 0 6,677 (6,677) -
547 Utilities 87,020 48,884 38,136 56.2%
548 Repairs & Maint Services 145,927 51,051 94,876 35.0%
549 Miscellaneous 835,725 788,597 47,128 94.4%
563 Other Improvements 0 1,888 (1,888)
564 Machinery & Equipment 0 2,998 (2,998)
565 Construction Projects 4,613,000 408,283 4,204,717 8.9%
572 Revenue Bond 19,504 0 19,504
578 Intergov. Loan Principle 259,856 259,356 500 99.8%
583 Bond Interest 6,249 5,070 1,179 81.1%
588 Amortization Costs 0 0
Total Expenditures 10,689,564 2,818,051 7,871,513 26.4%
750 Transfers Out 1,153,287 561,676 591,611 48.7%
1,153,287 561,676 591,611 48.7%
Beginning Fund Balance
Change in Fund Balance
Ending Fund Balance
4,634,122
(1,333,851)
3,300,271
5,903,817
3,823,333
9,727,150
27.4%
386.6%
194.7%
29
31
City of Tukwila
Equipment Rental 501 - Revenue and Expenditures
as of Jun 30, 2022
Annual Budget
Actual Year to Date Variance % of Annual Budget
REVENUE:
348 Internal Service Fund Sales an 2,268,831 1,134,415 (1,134,416) 50.0%
361 Interest and Other Earnings 20,000 9,009 (10,991) 45.0%
369 Other Miscellaneous Revenues 0 617 617
395 Disposition of Capital Assets 25,000 51,528 26,528 206.1%
Total Revenues 2,313,831 1,195,569 (1,118,262) 51.7%
EXPENDITURES:
511 Salaries 405,335 194,538 210,797 48.0%
512 Extra Labor 32,000 0 32,000
513 Overtime 1,875 2,555 (680) 136.3%
521 FICA 33,580 15,395 18,185 45.8%
523 Pension-PERS/PSERS 43,375 20,202 23,173 46.6%
524 Industrial Insurance 16,666 5,057 11,609 30.3%
525 Medical & Dental 138,939 73,572 65,367 53.0%
528 Uniform/Clothing 1,100 420 680 38.2%
531 Supplies 3,000 625 2,375 20.8%
532 Repairs & Maint Supplies 0 30 (30)
535 Small Tools 0 1,978 (1,978) -
536 Technology Supplies 0 18 (18)
537 Fleet Supplies 655,000 295,013 359,987 45.0%
541 Professional Services 114,400 95,240 19,160 83.3%
542 Communications 5,500 2,187 3,313 39.8%
543 Professional Development 1,500 2,849 (1,349) 190.0%
545 Rentals 40,806 12,521 28,285 30.7%
546 Technology Services 7,500 1,894 5,606 25.2%
547 Utilities 0 1,039 (1,039)
548 Repairs & Maint Services 146,126 178,186 (32,060) 121.9%
549 Miscellaneous 20,000 7 19,993 0.0%
564 Machinery & Equipment 269,000 785,314 (516,314) 291.9%
Total Expenditures 1,935,702 1,688,639 247,063 87.2%
730 Transfers In 52,000 0 (52,000)
52,000 0 (52,000)
750 Transfers Out 333,707
333,707
166,853 166,854
166,853 166,854
50.0%
50.0%
Beginning Fund Balance
Change in Fund Balance
Ending Fund Balance
3,600,733
96,422
3,697,155
4,735,285
(659,923)
4,075,363
31.5%
(784.4)%
10.2%
30
32
City of Tukwila
Insurance - Active Employees 502 - Revenue and Expenditur
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
341 General Government 1,000 113 (887) 11.3%
361 Interest and Other Earnings 30,000 4,854 (25,146) 16.2%
369 Other Miscellaneous Revenues 8,694,122 3,912,291 (4,781,831) 45.0%
Total Revenues 8,725,122 3,917,259 (4,807,863) 44.9%
EXPENDITURES:
525 Medical & Dental 8,408,793 2,646,867 5,761,926
531 Supplies 0 0
541 Professional Services 100,000 22,848 77,152
549 Miscellaneous 21,000 542 20,458
Total Expenditures 8,529,793 2,670,257 5,859,536
31.5%
22.8%
2.6%
31.3%
750 Transfers Out 180,609 90,303 90,306 50.0%
180,609 90,303 90,306 50.0%
Beginning Fund Balance
Change in Fund Balance
Ending Fund Balance
70,012
14,720
84,732
597,792
1,156,699
1,754,491
753.8%
7,758.0%
1,970.6%
31
33
City of Tukwila
Insurance - LEOFF I Retirees 503 - Revenue and Expenditures
as of Jun 30, 2022
Annual Budget Actual Year to Date Variance % of Annual Budget
REVENUE:
361
369
Total Revenues
Interest and Other Earnings
Other Miscellaneous Revenues
1,000
435,000
436,000
726 (274)
160,802 (274,198)
161,528 (274,472)
EXPENDITURES:
525 Medical & Dental 479,500 209,644 269,856
541 Professional Services 5,000 1,750 3,250
549 Miscellaneous 500 0 500
Total Expenditures 485,000 211,394 273,606
72.6%
37.0%
37.0%
43.7%
35.0%
43.6%
750 Transfers Out 12,040 6,022 6,018 50.0%
12,040 6,022
6,018 50.0%
Beginning Fund Balance
Change in Fund Balance
Ending Fund Balance
165,675
(61,040)
104,635
264,258
(55,888)
208,370
59.5%
8.4%
99.1%
34