HomeMy WebLinkAboutReg 2013-07-01 Item 2E - Special Presentation - 2013 1st Quarter Financial ReportPrepared By:
Vicky Carlsen
March 31, 2013
immary (Cash Bas: s
City -wide, unreserved fund balances increased $475K in the first quarter of 2013 from
$39.8M at December 31, 2012 to $40.3M as of March 31, 2013. The governmental funds re-
flected the largest change with a total decrease of $1.5M, enterprise funds increased by $1.6M,
and the internal service funds increased by $349K. Of the governmental funds, the General
Fund has decreased by $1.9M during the first quarter; however, general fund operating ex-
penditures only exceeded operating revenues by $71K. Further discussion on the governmen-
tal funds and the General Fund occurs on the following pages.
Through first quarter, excluding future changes to the budget, the City is on track to stay with-
in the current adopted budget.
The national and Washington economies continue to move forward at a modest pace. Accord-
ing to the Washington State Economic and Revenue Forecast Council, the Washington econo-
my is expected to outperform the U.S. economy but only slightly. Aerospace, software, and
construction sectors continue to show signs of improvement. King County is improving faster
than the rest of the state.
Federal fiscal policy remains at the forefront of economic uncertainty. Automatic spending
cuts, which took effect March 1, 2013, and higher payroll taxes have reduced personal income
which could effect spending. The continuing sovereign debt crisis in Europe could impact the
U.S. economy.
To protect against continuing financial uncertainties, the City continues to follow conservative
fiscal policy.
CITY -WIDE
FUND BALANCES
ACTUAL
12/31 /2012 3/31 /2013
CHANGE IN FUND BALANCE
- -- ACTUAL - --
YTD
- -- BUDGET - --
YTD
YTD
VARIANCE
Governmental funds
Enterprise funds
Internal service funds
$ 18,149,418 $ 16,639,109
11,011,318 12,648,262
10,638,314 10,987,116
$ (1,510,309)
1,636,944
348,802
$ (496,533)
(637,377)
(229,597)
$ (1,013,776)
2,274,321
578,399
City -wide Total
$ 39,799,050 $ 40,274,487
$ 475,437
$ (1,363,507)
$ 1,838,943
General Fund
Hotel /Motel Tax Fund
Street Fund
Arterial Street Fund
Contingency Fund
Fire Equip Cum Reserve
Drug Seizure Fund
Debt Service Funds
Parks Acq Fund
Facility Replacement Fund
General Gov Improvements
Fire Impact Fee Fund
Water Fund
Sewer Fund
Foster Golf Fund
Surface Water Fund
Equipment Replacement Fund
Self- Insurance Fund
LEOFF Insurance Fund
Fund Balances **
As of March 31, 2013
$1,087,323
r i
r $1,159,614
Fr, —_ __~ "i $1,461
. _ .__._ 892.613
-u,0a4
266
$1,122,631
$188,692 uM
$359,809
5309,68
** Unreserved /unrestricted $
$2,003,024
$3.017,595
f $4,105,193
Q2,878,819
/ $3.611,029
9,849
03,000,000
54,000,000
$4,393,5p3
I1$4,963,784
55,000,000 $6,000 000
848,734
Inside this issue:
Governmental Funds
General Fund Revenues
2 General Fund Expenditures
3
3
Enterprise and Internal Service Funds
4
1
2
FUND BALANCES
REVENUES AND EXPENDITURES
000 - General Fund
101 - Hotel /Motel Tax Fund
103 - Street Fund
104 - Arterial Street Fund
105 - Contingency Fund
107 - Fire Equip Cum Reserve
109 - Drug Seizure Fund
2xx - Debt Seance
301 - Parks Acq Fund
302 - Facility Replacement Fund
303 - General Gov Improvements
304 - Fire Impact Fee Fund
/2012.. - 3/31'/2013
$ 6,026,030
710,707
1,046,771
483,330
1,460,454
892,072
160,125
3,012,381
1,090,188
2,005,520
913,830
348,010
$ 4,105,193
494,264
1,087,323
1,159,614
1,461,266
892,613
147,084
3,017,595
1,122,631
2,003,024
788,692
359,809
$12,585,190
107,532
63,322
1,627,669
812
541
(9,101)
7,067
66,133
1,083
327
11,799
21.15%
7.05%
7.55%
4.34%
0.05%
0.00%
-9.48%
0.20%
5.76%
19.33%
0.02%
23.55%
$14,506,027
323,975
22,770
951,385
3,941
1,853
33,689
3,579
125,465
25.04%
19.68%
2.22%
4.03%
0.00%
0.00%
15.76%
0.03%
3.00%
0.61%
8.62%
0.00%
Total Governmental
$18,149,418 $16,639,109
$(1,510 309)'
$14,462,375
" /o,
$15,972,683
Governmental funds first quarter activity decreased fund balanc-
es by $1.5M. As of the end of March the general fund balance
decreased $1.9M. Total revenues for the General Fund were
$12.5M or 21.15% of budget compared to total expenditures of
$14.5M or 25.04% of budget. Operating expenditures exceed
operating revenues by $71K. Highlights for the first quarter
include:
General Fund
• Almost all property tax revenue is received two times a
year; April -May and October - November. Revenue for
1st quarter is 3.65% of budget, slightly ahead of 2012
of 3.21%
• Quarterly financial data is reported on a cash basis;
when revenues are received and expenditures paid.
First quarter sales tax revenue includes collections for
November through January. November and December
constitutes the highest collection months. Additionally,
sales tax has exceeded expectations all 3 months and
are 5.62% higher than collections for the same period
last year. Sales and Use Taxes are 28.50% of budget.
• Revenue Generating Regulatory Licenses generated
$1.6M as licenses were renewed for 2013. Through
first quarter, 92.15% of budget has been collected.
• Gambling excise taxes are at 24.96% of budget. In
2012, a casino was paying back taxes and penalties on
the amount owed. The casino is now current and only
current year activity is reflected for 2013.
• Charges for Services increased for 1st quarter over last
year, which was at only 15.39% of budget. Revenue is
at 22.94% of budget.
• Plan check and review fees are at 29.77% of budget.
Both the number of permits issued as well as the value
of the permits exceed last year's 1st quarter.
Hotel/Motel— Tourism
• Hotel/Motel taxes are at 19.42% of budget. It is antici-
pated that revenue will increase during the summer
months when occupancy rates are typically higher.
Street Fund (Residential)
• The 3 major projects in this fund; 42nd Ave S Phase III,
Cascade View Safe Routes to School, and Thorndyke
Safe Routes to School. All projects are currently in the
design phase.
Arterial Streets
• It is anticipated that bond proceeds for the Tukwila Ur-
ban Center Access Project — Local Improvement District
No. 33 will be received in the 4th quarter. Once funds
have been received, $8.5M is budgeted to be transferred
to the general fund.
Contingency
• Transfer from the general fund should occur upon re-
ceipt of the LID bond proceeds.
Debt Service
• Subsidy payments from the federal government for the
City's BABs bonds have been reduced by 8.7% due to
sequestration.
Paget 2013 FIRST QUARTER FINANCIAL REPORT
Property Taxes
Sales and Use Taxes
Revenue Generating Regulatory License
Utility Taxes
Interfund Utility Tax
Excise Taxes
Bus Licenses, Franchise Fees, Permits
Building Permits and Fees
Intergovernmental Revenue
General Fund Misc
Indirect Cost Allocation
Total 00:00093600000 1"
Sale of Bond Proceeds for MPD
Transfers In
$ 445,399
4,128, 094
1,640,354
1,132,756
437,949
218,804
441,350
1 95, 968
1,037,284
669,106
582,666
3.21%
27.43%
83.06%
23.40%
28.74%
8.28%
54.67%
18.51%
25.03%
13.19%
24.93%
$ 504,320
4,360,063
1,612,646
1,088,918
478,662
523,582
467,049
308,144
930,534
802,351
508,922
3.65%
28.50%
92.15%
25.39%
32.21%
24.96%
60.49%
28.40%
19.34%
22.95%
25.00%
$ 58,921
231,969
(27, 708)
(43, 838)
40,713
304,778
25,699
112,176
(106, 750)
133,245
(73, 744)
10,929,730
0'.50°
0.00%
0.00%
585 „'190';
1,000,000
22.71%
0.00%
0.00%
655,460
1 , 000, 000
Total'Rev'enu+e
$ 10,929,730,
;20.50%
.15%
655,460
General fund revenues collected during the is quarter of 2013
exceed 2012 1st quarter by $1.7M. Property taxes, sales and use
taxes, excise taxes, business licenses & permits, and building
permits & fees revenue exceeded 2012 revenues by $734K.
Included in revenues is $IM bond proceeds for the MPD. This
was budgeted in 2012.
Sales tax mitigation revenue is included in the intergovernmental
revenue category. The State of Washington reduced payments
by 3.4% for the current fiscal year, which ends June 30, 2013. It
is anticipated that sales tax mitigation revenue will return to near
previous levels in the next fiscal year.
General fund expenditures through 1st quarter of the year are
$14.5M or 25.04% of budget. Transfers out were $1.6M for the
first quarter and will continue to be made on an as needed basis
during the year.
TOTALS BY CATEGOR'
11 SALARIES
12 EXTRA LABOR
13 OVERTIME
15 HOLIDAY PAY
21 FICA
22 LEOFF
23 PERS
24 INDUSTRIAL INSURANCE
25 MEDICAL, DENTAL,LIFE,OPTICAL
26 UNEMPLOYMENT COMP
28 UNIFORM CLOTHING
31 OFFICE & OPERATING SUPPLIES
34 HEMS EMS FOR INVENT /RESALE
35 SMALL TOOLS & MINOR EQUIp
41 PROFESSIONAL SERVICES
42 COMMUNICATION
43 TRAVEL
44 ADVERTISING
45 OPERATING RENTALS & LEASES
46 INSURANCE
47 PUBLIC UTILITY SERVICES
48 REPAIRS & MAIN I ENANCE
49 MISCELLANEOUS
51 IN IERGVRNMTL PROF SVCS
64 MACHINERY & EQUIP, OTHER
OPERATING EXPENDITURES
52 LOAN TO MPD
00 TRANSFERS OUT, HYDRANT RENT
Grand Totals
Page 3
chi
5,570,600
74,551
324,647
353,653
160,042
197,969
79,362
1,125,875
4,076
279
203,693
5,043
5,994
292,779
58,055
20,608
5,915
34,393
573,822
427,133
101,404
198,557
374,081
12,754
1,205,285'
8,205
0,213,491)
3uclget , Actual , %of Budget
24.11% $ 6,054,135 24.82%
16.37% 74,408 16.09%
23.58% 467,884 32.95%
0.00% 806 0.41%
25.19% 385,434 26.40%
27.11% 190,759 31.04%
19.51% 224,645 23.23%
18.27% 95,960 22.22%
22.06% 1,048,637 24.17%
13.59% 30,794 102.65%
2.64% 814 8.08%
20.26% 169,168 15.11%
35.51% 5,385 37.32%
3.44% 9,463 4.29%
13.51% 308,901 11.86%
16.66% 68,485 18.58%
16.92% 18,279 15.16%
11.94% 4,529 8.08%
1.60% 540,070 24.19%
104.23% 579,619 95.72%
32.70% 441,941 30.32%
16.99% 132,703 17.30%
22.25% 285,234 18.77%
18.99% 484,767 22.28%
4.25% 7,289 1.61%
22:50 %, 11,630,107 , -; 24:21 %`,,',
Under)
rYear
483,535
(143)
143,237
806
31,781
30,717
26,676
16,598
(77,238)
26,718
535
(34, 525)
342
3,469
16,122
10,430
(2,329)
(1,386)
505,677
5,797
14,808
31,299
86,677
1 10, 686
(5,466)
0.00% 1,250,000 0.00%
0.08% 1,625,920 16.43%
18.33, ° /a” $ 14,506,027 , , 25.044% ,;$
1,424,$22-
1,250,000
1,617,715
4,292, 537
2013 FIRST QUARTER FINANCIAL REPORT
3
ENTERPRISE
FUNDS
FUND BALANCES
REVENUES AND EXPENSES
ACTUAL
12/31 /2012 3/31 /2013
01 Change
Revenues
Expenses
Amount
of Budget
Amount
% of Budget
401- Water Fund
402 - Sewer Fund
411 - Foster Golf Fund
412 - Surface Water Fund
$ 6,077,949 $ 5,848,734
2,199,821 2,878,819
404,390 309,680
2,329,158 3,611,029
$ (229,215)
678,998
(94,710)
1,281,871
$ 1,133,300
1,844,551
246,869
1,939,157
21.02%
27.72%
13.78%
46.09%
$ 1,362,545
1,165,553
341,578
657,286
20.65%
16.27%
20.00%
12.82%
ENTERPRISE FUNDS
$11,011,318 $12,648,262
$ 1,636,944
$ 5,163,877
28.62%
$ 3,526,962
17.13%
Fund 401 - Water: Revenues for first quarter are at 21.02% of
budget and expenses are at 20.65% of budget. Fund balance
decreased $229K. Andover Park W /Strander new water main
project is under design. This project is connected to the Tukwila
Urban Center — Transit Center project.
Fund 402 - Sewer: Revenues are at 27.72% of budget and ex-
penses are at 16.27% of budget resulting in an increase to fund
balance of $679K. Major projects in this fund include CBD San-
itary Sewer Rehabilitation and Sewer Lift Station No. 2 up-
grades.
Fund 411 -Golf Course: Revenues for first quarter 2013 ex-
ceeded revenue during the same quarter in 2012. This is largely
due to a substantial increase in number of rounds of golf; 5,022
in 2013 versus 3,742 in 2012. Expenses for first quarter are at
20.00% of budget.
Fund 412 - Surface Water: The Surface Water fund realized a
first quarter fund balance increase of $1.3M. Revenues and ex-
penses for the first quarter are 46.09% and 12.82% respectively.
Several projects are planned for 2013 including Surface Water
Lift Station No. 15, Soils reclamation Facility, and Lower Du-
wamish Surface Water Conveyance.
Additional information on the enterprise funds can be found in
the fund level statements provided in this packet.
INTERNAL SERVICE
FUNDS
FUND BALANCES
REVENUE AND EXPENSES
ACTUAL
12/31/2012 3/31/2013
01 Change
Revenues
Amount
of Budget
Expenses
Amount
% of Budget
501 - Equipment Replacement
502 - Self- Insurance Fund
503 - LEOFF Insurance Fund
$ 4,132,396 $ 4,393,503
4,794,386 4,963,764
1,711,532 1,629,849
$ 261,107
169,378
(81,683)
$ 614,855
1,165,510
947
16.08%
25.01%
28.37%
353,746
996,132
82,630
9.11%
19.87%
16.25%
INTERNAL SERVICE FUNDS
$ 10,638,314 $ 10,987,116
$ 348,802
$ 1,781,312
20.99%
$ 1,432,509
15.23%
Fund 501 - Equipment Replacement: At the end of the first
quarter, fund balance increased $261K. Revenue is at 16.08%
of budget and expenses are at 9.11% of budget. All equipment
scheduled to be purchased in 2013 except 2 pumpers and the fire
command vehicle have been ordered. Items will be paid for
when they are received.
Fund 502- Insurance: At the end of the first quarter, fund bal-
ance increased $169K. Employee healthcare costs were lower
than budget during the first quarter.
Fund 503 -LEOFF Insurance: An actuarial evaluation done in
Page 4
4
July of 2012 indicated that the city had excess reserves in this
fund. Based on the evaluation, the City decided to not fund con-
tributions for the 2013 -2014 biennium. First quarter activity
decreased fund balance by $82K but is below the expected re-
duction of $126K. Expenses for the quarter are at 16.25% of
budget.
2013 FIRST QUARTER FINANCIAL REPORT
City of Tukwila
General Fund 000 - Revenue and Expenditures
As of March 31 2013
°A) of year expired 25.00%
'MRS li i h ( iY s5
��V45r74.
Revenue
General Revenue
Property Taxes $ 13,814,401 $ 3,453,600
Sales and Use Taxes 15,298,722 3,824,681
Revenue Generating Regulatory Lics 1,750,000 437,500
Rental Housing License 35,000 8,750
Admissions Tax 612,000 153,000
Utility Taxes 4,288,080 1,072,020
Interfund Utility Tax 1,486,000 371,500
Excise Taxes 2,097,341 524,335
Total General Revenue 39,381,544 9,845,386
Licenses and Permits
504,320 $ (2,949,281)
4,360,063 535,382
1,612,646 1,175,146
28,000 19,250
127,342 (25,658)
1,088,918 16,898
478,662 107,162
523,582 (753)
8,723,533 (1,121,853)
3.65% (a)
28.50%
92.15% (b)
80.00% (c)
20.81%
25.39%
32.21%
24.96%
22.15%
Business Licenses and Permits 772,089 193,022 467,049 274,027 60.49%
Building Permits and Fees 1,085,000 271,250 308,144 36,894 28.40%
Total Licenses and Permits 1,857,089 464,272 775,193 310,921 41.74%
Intergovernmental Revenue
Sales tax mitigation 1,165,641 291,410 275,856 (15,554) 23.67% (d)
Seattle City Light Agreement 2,206,344 551,586 539,782 (11,804) 24.46%
Grants 619,430 154,858 2,012 (152,846) 0.32% (e)
State entitlements, in -lieu taxes 312,874 78,219 79,595 1,377 25.44%
Other 507,003 126,751 33,289 (93,462) 6.57%
Total Intergovernmental Revenue 4,811,292 1,202,823 930,534 (272,289) 19.34%
Charges for Services
General Government 54,363 13,591 10,856 (2,735) 19.97%
Security 554,725 138,681 162,084 23,403 29.22%
Engineering Services 9,867 2,467 - (2,467) 0.00%
Transportation 167,000 41,750 531 (41,219) 0.32%
Plan Check and Review Fees 618,500 154,625 184,122 29,497 29.77% (f)
Culture and Rec Fees 519,755 129,939 71,918 (58,021) 13.84%
Total Charges for Services 1,924,210 481,053 429,511 (51,541) 22,32%
Fines and Penalties 234,829 58,707 59,328 620 25.26%
Miscellaneous Revenue 689,375 172,344 158,169 (14,175) 22.94%
MPD Payback of Loan 81,000 20,250 (20,250) 0.00%
Indirect cost allocation 2,035,740 508,935 508,922 13) 25.00%
) �, !
Operating, Revenue l ,,,,.., ,. ;5 ,01 X07 ,, ,16 770 5r,,, 115 5,'t;SQ 3 5,f5,i,r.(1,168�58 i ¢ ,5. / 27.11 :f
X
110
Sale of Bond Proceeds for MPD
Total feueru(e,7 r' n/
Expenditures
Opera n xpet)
Loan to MPD
Transfers Out
T al E 114#1h e?
Change in Fund Balance
Beginning Fund Balance
En0ng0:04,, g0n
Cash and investments
WAN
��r�i11� �,n�
1,000,000 1,000,000
8,500,000 2,125,000 - (2,125,000) 0.00% (h)
g,5,itiff i'i ;f/';fl l`j4 7B; lied 15,1Z585,i NNW ,,.(2, 'OW ''lb Iliffitt
0.00% (g)
OMR
"r 4`21
1,250,000 1,250,000 0.00%
9,789,688 2,447;422 1,600,000 (847 422) 16.34%
ABM )" %3 r48'95i (l((t('�, r O o2y s, ¢ ;. y ''�; dl re ' 1' (i)
�.,r�Z����!�l � rr7 ���sa 5 �( r,,./ , /` � � ttn r �,.�,, , , �o� '�� �r� 5s
1,583,253
3,800,000
395,813 (1,920,837)
3,800,000
6,026,030
(2,316,650)
2,226,030
- 121.32%
158.58%
1 �2$ /dIU. ' ?( ryry /r/ lai NSA ;,i, , ' 6, %N
$ 944,197
(a) Property taxes are paid April 30 and October 31. First quarter collections is typically very low and is comparable with previous years
collections.
(b) Most RGRL license fees are collected in the first quarter because the fee is due by January 31. Remaining fees collected will be on late
filers and new businesses.
(c) Most rental housing license fees are collected in first quarter because the fee is due by January 31.
(d) Reflects the 3.4% reduction that took effect in 2012.
(e) Grant revenue is related to services and is typically invoiced to grantors after funds have been expended.
(f) Number of permits issued during 1st quarter 2013 is higher than 1st quarter 2012 (502 vs. 481) and the value of the permits is also
higher.
(g) Sale of bond proceeds for MPD was budgeted for 2012.
(h) Proceeds from LID bonds. It is anticipated that these bonds will be issued in 4th quarter.
(i) For expenditure detail, please refer to Expenditure by Department report.
** Variance = Actual over (under) prorated budget Fund 000
5
CITY OF TUKWILA
General Fund Expenditures - By Category
As of March 31 2013
SALARIES AND BENEFITS
SUPPLIES
PROFESSIONAL SERVICES
INTERGOVERNMENTAL
CAPITAL EXPENDITURES
CAPER GX U
yry p rr
rx .rYU @s rvird �.ma. .mmt`Y,��n � �
LOAN TO MPD
TRANSFERS OUT (DEPT 20)
3T L,El P 1�tS
OOP
to r
1 SALARIES
12 EXTRA LABOR
13 OVERTIME
15 HOLIDAY PAY
21 FICA
22 LEOFF
23 PERS
24 INDUSTRIAL INSURANCE
25 MEDICAL,DENTAL,LIFE,OPTICAL
26 UNEMPLOYMENT COMP
28 UNIFORM CLOTHING
31 OFFICE & OPERATING SUPPLIES
34 ITEMS FOR INVENT /RESALE
35 SMALL TOOLS & MINOR EQUIP
41 PROFESSIONAL SERVICES
42 COMMUNICATION
43 TRAVEL
44 ADVERTISING
45 OPERATING RENTALS & LEASES
46 INSURANCE
47 PUBLIC UTILITY SERVICES
48 REPAIRS & MAINTENANCE
49 MISCELLANEOUS
51 INTERGVRNMTL PROF SVCS
64 MACHINERY & EQUIP, OTHER
� r
/ it
r y,� f }; a s �7
52 LOAN TO MPD
00 TRANSFERS OUT
rand Td ti I R i L fry Jt ri
34,319,901
1,354,018
9,732,101
2,176,118
454,000
9,895,688
574931:86 sx,
% of year expired 25.00%
8,579,975
338,505
2,433,025
544,030
113,500
,ps
2,473,922
4.08.0511
24,390,595
462,412
1,420,086
194,452
1,460,147
614,477
967,002
431,947
4,338,708
30,000
10,075
1,119,229
14,428
220,361
2,604,802
368,596
120,565
56,050
2,232,887
605,535
1,457,374
766,990
1,519,302
2,176,118
449,000
9,895,688
6,097,649
115,603
355,022
48,613
365,037
153,619
241,751
107,987
1,084,677
7,500
2,519
279,807
3,607
55,090
651,201
92,149
30,141
14,013
558,222
151,384
364,344
191,748
379,826
544,030
113,500
8,574,274
184,017
2,379,760
484,767
7,289
f
1,250,000
1,625,920
6,054,135
74,408
467,884
806
385,434
190,759
224,645
95,960
1,048,637
30,794
814
169,168
5,385
9,463
308,901
68,485
18,279
4,529
540,070
579,619
441,941
132,703
285,234
484,767
7,289
if
5,701) 24.98%
(154,488) 13.59%
(53,265) 24.45%
(59,263) 22.28% (a)
(106,212) j 1.61%
f +�° .r�i,w,rl �vtarfY' 1 14411
1,250,000 0.00% (b)
848,002) 16.43% (c)
j l f"j 1204 %s
1,250,000
2,473,922 1 625 920
1448 `4$01111340041*
(43,513)
(41,195)
112,863
(47,807)
20,397
37,139
(17,106)
(12,027)
(36,040)
23,294
(1,705)
(110,639)
1,778
(45,627)
(342,300)
(23,664)
(11,862)
(9,483)
(18,152)
428,235
77,598
(59,044)
(94,592)
(59,263)
(106,212
24.82%
16.09%
32.95% (d)
0.41%
26.40%
31.04% (e)
23.23%
22.22%
24.17%
102.65% (f)
8.08%
15.11%
37.32%
4.29%
11.86%
18.58%
15.16%
8.08%
24.19%
95.72%
30.32%
17.30%
18.77%
22.28% (a)
0
162 /0
1,250,000 0.00% (b)
(848,002) 16.43% (c)
;rrf /rE untrnr ,j 4
f irk luYt�£ ,!dl!,rr�
(a) Includes 4 months for Valley Corn charges. Valley Corn invoices for two months at a time.
(b) Loan to MPD includes both operating loan of $250,000 and capital loan of $1,000,000. Capital loan was budgeted to occur in 2012. Will do
budget amendment for 2013. Also includes 4 months for Valley Corn charges. Valley Corn bills semi - monthly.
(c) Transfer out to fund 104 Arterial Street of $1.5 million. Transfers to other funds are done on an as needed basis. Transfers out also
includes $25,920 transferred from Department 11 -Fire for hydrant fees.
(d) Police: Overtime is higher than expected budget due to front loading training in 1st quarter so crews will be available in anticipation of
summer vacations and the holiday season.
Fire: Overtime is high due to backfilling positions due to staffing shortages, temporary promotions, and several staff out due to injuries.
(e) LEOFF costs for overtime are budgeted in the overtime account but charged to the LEOFF GL account when paid out.
(f) Unemployment payment is for the 2011 correction for the employees reinstated after work force reduction.
** Variance = Actual over (under) prorated budget Fund 000 By Category
6
CITY OF TUKWILA
General Fund Expenditures - By Department
As of March 31 2013
0,011
04,
yeatoorro AWAPPFRAMPWRowommog
ome Aka, Ampo,okto•bookmoodwoomompoq
: aidittlitaine '''.60tetit6001105
252,431
2,816,131
644,578
2,238,494
661,860
2,532,208
3,286,009
1,029,336
15,607,412
10,247,976
1,315,762
3,581,482
1,087,098
CITY COUNCIL
MAYOR
HUMAN RESOURCES
FINANCE
CITY ATTORNEY
RECREATION
COMMUNITY DEVELOPMENT
MUNICIPAL COURT
POLICE
FIRE
INFORMATION TECHNOLOGY
PUBLIC WORKS
PARK MAINTENANCE
iMPOPT
ut
110,00k4
63,108 $
704,033
161,145
559,624
165,465
633,052
821,502
257,334
3,901,853
2,561,994
328,941
895,371
271,775
% of year expired
25.00%
-4,,tlfigumplappgriniototo
orogihik Af
tootoo,ea6',A0
8,0,6:80d,Orar 9#11
17,560
553,688 (150,345)
129,296 (31,849)
687,716 128,092
127,218 (38,247)
548,520 (84,532)
723,777 (97,725)
256,174 (1,160)
3,878,271 (23,582)
2,632,822 70,828
259,737 (69,203)
795,812 (99,558)
255,677 (16,097) 23.52%
31.96%
19.66%
20.06%
30.72%
19.22%
21.66%
22.03%
24.89%
24.85%
25.69%
19.74%
22.22%
STREET mioqN1-p■iNc, & oppwipN, . .,„ 2,841,361 710,340 726,651 16,310 25.57%
IOIIIVCIOIOAKIAMICZIEIZIEIIESEIZZELILVACISESVLOIEOAEEIIAIIOIMVIIIGIIIIXOAIOSKIIIMIMIN
LOAN TO MPD 1,250,000 1,250,000 0.00%
TRANSFERS OUT (DEPT 20) 9,789,688 2,447,422 1600,000 (847,422 16.34%
101411#04011111111111111111111,M5t93Ii8idattlet14g82967 elitint14,5647 nitellint23tionens25o4%
/:V*0 iiSisi014000$00000000,kiMoVAPat, 0,704froralsof0000;000040100"1040001,01
"wow Nmmmgwwoffrzwmwomwfmmmrr,rrprroTpsrttVidrsffWFIFPOWYPMrfrfrgraPrNiorrn 'Y'grOcSfo
'.,4jletlfaaldtaiSOWVOOPN:AMbBdOglaNNI*t***eaei*
SALARIES
21 FICA
23 PERS
24 INDUSTRIAL INSURANCE
25 MEDICAL,DENTAL,LIFE,OPTICAL
31 OFFICE & OPERATING SUPPLIES
164,446 41,112 45,762 4,651
12,580 3,145 3,437 292
6,481 1,620 16,597 14,977
2,504 626 546 (80)
19,150 4,788 4,291 (497)
3,870 968 386 (581)
tiWA1 ten
27.83%
27.32%
256.09% (a)
21.82%
22.41%
9.99%
41 PROFESSIONAL SERVICES 1,500 375 (375) 0.00%
42 COMMUNICATION 6,000 1,500 1,185 (315) 19.75%
43 TRAVEL 25,000 6,250 8,081 1,831 32.32%
49 MISCELLANEOUS 10,900 2,725 381 (2,344) 3.50%
titt10010011111111111111111061021111111111A102611114010011110211110011111010*
(a) An individual filed for past pension credit and the City's share of the contribution to Dept. of Retirement Systems was $14,888.
Variance = Actual over (under) prorated budget Fund 000 By Dept
7
8
CITY OF TUKWILA
General Fund Expenditures - By Department
As of March 31 2013
% of year expired 25.00%
UOIMIIFPTSSIIIPIITIPFFVFNFRIIPTOWCFOIRIKNSRPPRIIPIINWOV,
,,.,rowgflvso,o:twtop0000frohfKtoofh,Rwosp:oocvltovf0d4AWOtr.4'VJet 14,"/A:#00, fAVP,*'''',..,,,fr'`,4 P,A4 fr,.' ',' i',
,,r,00 • .,,,,,,prvq,117 ,**41, log ,4691, M.", e.t01,0,,,A+ 4,,,,,,,,,,,A ,, r549,04410,40**,..k.0(04,10,
. ' ,, ,MrergaliftWe'rgirkliilabbledaNdeltraiMPPumA,AR,:,:ofroredd tlii* - 4$40mitssioVairtaL„„jolig
1,131,716 282,929 256,444 (26,485) 22.66%
10,500 2,625 1,385 (1,240) 13.19%
573 143 34 (109) 6.02%
81,188 20,297 19,499 (798) 24.02%
92,560 23,140 18,285 (4,855) 19.75%
3,991 998 736 (262) 18.43%
174,880 43,720 40,080 (3,640) 22.92%
43,024 10,756 5,611 (5,145) 13.04%
4,935 1,234 - (1,234) 0.00%
943,970 235,993 119,561 (116,432) 12.67%
(10,456)
72,600 18,150 10.60%
16,300 7,694
18.22%
4,075 2,971 (1,104)
14,750 3,688 1,142 (2,545) 7.74%
29,148 7,287 5,054 (2,233) 17.34%
17,750 4,438 1,832 (2,605) 10.32%
150,746 37,687 72,498 34,812 48.09% (a
31,065 7,766 11,659
12,663 37.53%
47384 3 3,892
93.55%
50,650 ,4,721
20,800 5,200 (5,200)
1,250 4,768 0.00%
5,000 6,018 120.35%
4,300 1,075 (1,075) 0.000O (b
2,500 625 (625) 0,000/0
431 108 27 (81) 6.16%
6,000 1,500 750 (750) 12.50°/0
30,000 6,662 (838)
7,500 22.21%
SALARIES
12 EXTRA LABOR
13 OVERTIME
21 FICA
23 PERS
24 INDUSTRIAL INSURANCE
25 MEDICAL,DENTAL,LIFE,OPTICAL
31 OFFICE & OPERATING SUPPLIES
35 SMALL TOOLS & MINOREQUIPMENT
41 PROFESSIONAL SERVICES
42 COMMUNICATION
43 TRAVEL
44 ADVERTISING
45 OPERATING RENTALS & LEASES
48 REPAIRS & MAINTENANCE
49 MISCELLANEOUS
49-00 Miscellaneous
49-01 Memberships, dues, subscriptions
49-02 Microfilm imaging
49-03 Employee recognition
49-04 Recorded documents
49-05 Registrations
49-08 Credit card fees
49-51 CTR reimbursement
49-56 Green initiatives
51 INTERGVRNMTL PROFESSIONAL SVCS
27,500 6,875 862
(6,013) 3.14%
MAYOR
smog,,,,a.iu4,m„E4g. otit, 4 re,, i0wro4ws4,in,pu0o0mm Ao, inaWJmIMoaoo‘Nr Mt,t ,MStl,t,, 5_ 3M8 :S;:: 4;I,1O,V, -:4M7a,,,g ,
: ,,,s 4 - :i
„r,sp nF 0iv viA ii_ iitu w: A ; w fate 0;::4'41
1 SALARIES 380,552 95,138 95,642 504 25.13%
21 FICA 26,966 6,742 6,951 210 25.78%
23 PERS 31,222 7,806
6,789 (1,017) 21.74%
24 INDUSTRIAL INSURANCE 1,252 313 262 (51) 20.93%
25 MEDICAL,DENTAL,LIFE,OPTICAL 56,956 14,239 14,182 (57) 24.90%
31 OFFICE & OPERATING SUPPLIES
4,842 1,211 776 (435) 16.02%
41 PROFESSIONAL SERVICES
115,625 28,906 3,079 (25,827) 2.66%
43 TRAVEL 1,500 375 - (375) 0.00%
44 ADVERTISING 7,000 1,750 825 (925) 11.79%
45 OPERATING RENTALS & LEASES
3,108 777 351 (426) 11.28%
48 REPAIRS & MAINTENANCE 5,105 1,276 (1,276) 0.00%
49 MISCELLANEOUS 10,450 2,613 439 (2,173 4.20%
KiiiiiM4 ROMM1111111116111111111110010111111114110011111111299 OSSIN41849) ssimomet
(a) Clean Air Assessment was paid quarterly in 2012. In 2013, the amount for the entire year was paid in January and other membership fees paid
earlier in the year than expected.
(b) Provides detail on miscellaneous expenditures.
- Variance = Actual over (under) prorated budget Fund 000 By Dept
CITY OF TUKWILA
General Fund Expenditures - By Department
As of March 31 2013
11 SALARIES 988,041
12 EXTRA LABOR
13 OVERTIME
21 FICA
23 PERS
24 INDUSTRIAL INSURANCE
25 MEDICAL,DENTAL,LIFE,OPTICAL
26 UNEMPLOYMENT COMPENSATION
31 OFFICE & OPERATING SUPPLIES
41 PROFESSIONAL SERVICES
42 COMMUNICATION
43 TRAVEL
45 OPERATING RENTALS & LEASES
46 INSURANCE
48 REPAIRS & MAINTENANCE
49 MISCELLANEOUS
49-00 Miscellaneous
49-03 Claims and judgments
49-08 Credit card fees
64 MACHINERY & EQUIPMENT
ti$10411111111111111.111112110101228494 IMISM*04011111401141/11111110001111111101**
10,000
10,000
73,927
81,036
3,756
198,970
30,000
19,296
175,000
1,000
5,000
2,700
240,000
2,500
397,268
21,900
370,000
5,368
% of year expired
25.00%
J.,„yeeicanrealafiJeff44,644,46100414, iffi`
NJonfeW6MFAMP,J
1arlane
247,010 240,147
2,500
2,500 1,124
18,482 18,204
20,259 17,330
939 736
49,743 45,951
7,500 30,794
4,824 795
43,750 384
250 94
1,250 97
675 902
60,000 211,463
625
99,317
5,475
92,500
1,342
119,694
2.320
115,581
1.814
(6,863)
(2,500)
(1,376)
(277)
(2,929)
(203)
(3,791)
23,294
(4,029)
(43,366)
(156)
(1,153)
227
151,463
(625)
20,377
(3,155)
23,061
472
"afar..
24.31%
0.00%
11.24%
24.62%
21.39%
19.60%
23.09%
102.65% (a)
4.12%
0.22%
9.41%
1.93%
33.42%
88.11% (b)
0.00%
30.13%
33.78%
31.23% (c)
10.59%
0.00%
OISMA*10000
nr,RIPSIN. arMfffer 06,1,41226WARP4-42704514WIff,
ol /;:p1,*.4*PiVfqfV,M,*SPNN04isMQPP41goA"t40001#i'"*" RfrI'*ivro'oolos'Otsa k0 fAVP"' frruwai
Anna Budget Budget , Aotua(Spn Virr e Btidget SpeltA
715 (60) 23.07%
126,128 (36,937) 19.34%
(500) 0.00%
(525) 0.00%
(350) 0.00%
49 MISCELLANEOUS 1,000 250 375 125 37.50%
CITY ATrQNE1 661 60 165465 f27,2j8 t38,247) 19122%
OFFICE & OPERATING SUPPLIES 3,100
41 PROFESSIONAL SERVICES 652,260
42 COMMUNICATION 2,000
45 OPERATING RENTALS & LEASES 2,100
48 REPAIRS & MAINTENANCE 1,400
775
163,065
500
525
350
(a) Unemployment payment is for the 2011 correction for the employees reinstated after work force reduction.
(b) Annual insurance premium is paid in first quarter.
(c) Provides detail on miscellaneous expenditures.
** Variance = Actual over (under) prorated budget Fund 000 By Dept
9
CITY OF TUKWILA
General Fund Expenditures - By Department
As of March 31 2013
% of year expired
25.00%
,
11 SALARIES
12
13
21
23
24
25
31
34
41
42
43
44
45
47
1,231,238 307,810 316,709 8,899
EXTRA LABOR 295,851 73,963 51,871 (22,091)
OVERTIME 1,100 275 (275)
FICA 113,764 28,441 27,804 (637)
PERS 100,995 25,249 24,664 (584)
INDUSTRIAL INSURANCE 28,375 7,094 6,645 (448)
MEDICAL,DENTAL,LIFE,OPTICAL 241,908 60,477 62,944 2,467
OFFICE & OPERATING SUPPLIES 82,428 20,607 11,723 (8,884)
ITEMS PURCH. FOR INVENT/RESALE 14,428 3,607 5,385 1,778
PROFESSIONAL SERVICES 184,037 46,009 10,039 (35,970)
COMMUNICATION 14,380 3,595 1,091 (2,504)
TRAVEL 8,450 2,113 799 (1,313)
ADVERTISING 28,500 7,125 2,562 (4,563)
OPERATING RENTALS & LEASES 37,406 9,352 4,978 (4,373)
PUBLIC UTILITY SERVICES
48 REPAIRS & MAINTENANCE 32,350 8,088 9,651 1,564
49 MISCELLANEOUS 90,998 22,750 11,652 (11,097)
64 MACHINERY & EQUIPMENT 26,000 6,500 - (6,500) 0.00%
ffigkr47-11111111111111111111111111111111i253 VOINEEMAMISIBIBI48" 411111111M4532) IES300%!
25.72%
17.53%
0.00%
24.44%
24.42%
23.42%
26.02%
14.22%
37.32%
5.46%
7.59%
9.46%
8.99%
13.31%
0.00%
29.83%
12.81%
,,,,4;wwwwww , 4 * owwwww4
oix,,logri,o4,,,,,OMMoo- M opmp , t, w0m10iu00,,,o,,,0gmk10N,00gm1404050wh0igp,7is*l`"o,0ml1o0gy1iPRIPt,Ev.8o4o1o61costoo,9m,
6,11A1111,1014441
AtrahBtagetWAUdgeg A C CtP etw, ri00
pent
1,912,511 478,128 486,118 7,990 25.42%
94,338 23,585 19,987
5,951 1,488 1,786 (3,598) 21.19%
298 30.01%
144,253 36,063 38,188 2,124 26.47%
158,943 39,736 36,414 (3,322) 22.91%
15,785 3,946 3,306 (640) 20.95%
289,989 72,497 75,727 3,229 26.11%
975 244 - (244) 0.00%
31,350 7,838 10,616 2,779 33.86%
1,300 325 (325) 0.00%
233,835 58,459 13,777 (44,681) 5.89%
2,925 731 431 (300) 14.73%
8,600 2,150 469 (1,681) 5.45%
3,500 875 (875) 0.00%
44,550 11,138
5,201 4,778 (423) 22.97%
5,708 (5,429) 12.81%
20,804
101,400 25,350 22,978 (2,372) 22.66%
15,000 3,750 3,494 (256) 23.29%
- -
1 1 0.00%
11 SALARIES
12 EXTRA LABOR
13 OVERTIME
21 FICA
23 PERS
24 INDUSTRIAL INSURANCE
25 MEDICAL,DENTAL,LIFE,OPTICAL
28 UNIFORM CLOTHING
31 OFFICE & OPERATING SUPPLIES
35 SMALL TOOLS & MINOR EQUIPMENT
41 PROFESSIONAL SERVICES
42 COMMUNICATION
43 TRAVEL
44 RECYCLING - KC WRR
45 OPERATING RENTALS & LEASES
48 REPAIRS & MAINTENANCE
49 MISCELLANEOUS
51 INTERGVRNMTL PROFESSIONAL SVCS
53 EXT TAXES & OPERATING ASSMNTS
64 MACHINERY & EQUIPMENT 200,000 50,000 (50,000) 0.00%
t,OVflgC,ttVAgYttOtkgljillpttailnllalfOWSIOCIBISESIMIOCNSISISMMISSEEIOKVIIESSltO*
** Variance = Actual over (under) prorated budget Fund 000 By Dept
10
CITY OF TUKWILA
General Fund Expenditures - By Department
As of March 31 2013
% of year expired 25.00%
1 SALARIES 642,940 160,735 166,912 6,177 25.96%
12 EXTRA LABOR 2,500 25.79%
625 645 20
13 OVERTIME 5,016 1,254 236 (1,018)
4.71%
21 FICA 48,425 12,106 12,563 456 25.94%
23 PERS 54,056 13,514 12,419 (1,095) 22.97%
24 INDUSTRIAL INSURANCE 2,817 704 604 (101) 21.42%
25 MEDICAL,DENTAL,LIFE,OPTICAL 116,431 29,108 32,030 2,922 27.51%
31 OFFICE & OPERATING SUPPLIES 11,708 2,927 4,878 1,951 41.67%
105,300 26,325 (8,649) 16.79%
41 PROFESSIONAL SERVICES 17,676
42 COMMUNICATION 7,300 1,825 652 (1,173) 8.93%
43 TRAVEL 9,215 2,304 650 (1,654) 7.06%
45 OPERATING RENTALS & LEASES 3,058 (755)
765 10
0.32%
48 REPAIRS & MAINTENANCE 1,300 325 263 (62) 20.22%
49 MISCELLANEOUS 19,270 4,818 6,637 1,819 34.44%
fii:IVNTOA-'t:9:1)AtrgllftkfenMgginMEA'P.SASVMbiPMflgktO4VgiieM*CtdlgSiSYAIA10IiktcMtgS,ii
409
.64
LL cOL
OPIPPMNINVIIITOMPONi0ONPALWOOlgrOMASO
000,014401,1WMORPOIMOOAtintiail ii40-4,4140
11 SALARIES 7,720,506
12 EXTRA LABOR 1,000 250
13 OVERTIME 908,263 227,066
21 FICA 581,135 145,284
22 LEOFF 339,406 84,852
23 PERS 93,011 23,253
24 INDUSTRIAL INSURANCE 135,522 33,881
25 MEDICAL,DENTAL,LIFE,OPTICAL 1,394,472 348,618
31 OFFICE & OPERATING SUPPLIES 225,950 56,488
35 SMALL TOOLS & MINOR EQUIPMENT 600 150
41 PROFESSIONAL SERVICES 77,875 19,469
42 COMMUNICATION 89,471 22,368
43 TRAVEL 24,500 6,125
44 ADVERTISING 800 200
45 OPERATING RENTALS & LEASES 1,026,948 256,737 253,454
46 INSURANCE 240,080 60,020 236,250
47 PUBLIC UTILITY SERVICES 727
48 REPAIRS & MAINTENANCE 185,948 46,487 46,735
49 MISCELLANEOUS 475,661 118,915 10,425
51 INTERGVRNMTL PROFESSIONAL SVCS 2,004,264 501,066 437,293
74Spl h* p luit"'I'F"r;;;;Ae
111001;74732ITllt
excf **000-!: iL a
pPATIOO MOdoto, „..."er!'6,0,00 Spentd
1,930,127 1,858,089
(72,038) 24.07%
(250) 0.00%
282,594 55,528 31.11% (a)
162,427 17,143 27.95%
106,635 21,783 31.42%
19,449 (3,804) 20.91%
33,523 (358) 24.74%
331,930 (16,688) 23.80%
56,452 (36) 24.98%
(150) 0.00%
9,762 (9,707) 12.54%
19,913 (2,455) 22.26%
3,827 (2,298) 15.62%
(200) 0.00%
(3,283) 24.68%
176,230 98.40% (b)
727 0.00%
248 25.13%
(108,490) 2.19%
(63,773) 21.82% (c)
i.';!d7kZrM!tfENEEEssEasamn*:;!;g11111tZZfillt flUZ11111111111811111aa
(a) Overtime is higher than expected due to front loading training in 1st quarter so crews are available in anticipation of summer vacations and the
holiday season.
(b) Annual insurance premium is paid in first quarter.
(c) A first quarter invoice was paid in April.
** Variance = Actual over (under) prorated budget Fund 000 By Dept
11
CITY OF TUKWILA
General Fund Expenditures - By Department
As of March 31 2013
00 HYDRANT RENTALS 106,000 26,500 25,920 (580
11 SALARIES 6,322.837 1.580J09 1.653e76 72,566
13 OVERTIME 470,858 117715 17e,290 60,576
15 HOLIDAY PAY 194,452 48,613 806 (47,807
21 FICA on.e� �.�1 26,180 3,758
22 LEOFF 275,071 68,768
84,124 15,356
23 PERS eo.o�n 7,010 5,78e (1,221)
25 MEDICAL,DENTAL,LIFE,OPTICAL 1,100,605 275.151 269,850 (6,019) 2* INDUSTRIAL INSURANCE 170,058 42,515 36,496
(5,301) UNIFORM CLOTHING 1.500 375 (375
31 OFFICE & OPERATING SUPPLIES 218.277 54.569 32.120 (22.449)
35 SMALL TOOLS & MINOR EQUIPMENT 43.845 10.e61 - (10.961)
41 PROFESSIONAL SERVICES 54.000 13.500 3.548 (9.952)
12 COMMUNICATION 32.170 8.043 6.435 (1.607)
43 TRAVEL 17'000 4.250 1.e49 (3.001)
45 OPERATING RENTALS & LEASES 451'e86 112.922 112.838 (84)
46 INSURANCE
90.000 22,500 e4.500 72,000
47 PUBLIC UTILITY SERVICES 73,360 18.340 18.e15 575
18 REPAIRS & MAINTENANCE 152.304 38.076 11.530 (26.546)
49 MISCELLANEOUS 117,874 29.469 27,838 <1.e30>
51 |mTEnGvnNMTL PROFESSIONAL 6vC8 129.354 32,339 *3.118 10.780
64 MACHINERY & EQUIPMENT 109,000 27,250 - (27,250) 0.00%
=
24.45%
26.15%
37.86%
0.41%
29.19%
30.58%
20.65%
21.46%
24.52%
0.00%
14.72%
0.00%
6.57%
20.00%
7.35%
24.98%
105.00%
25.78%
7.57%
23.62%
33.33%
NOM
NfORIVIL
11 SALARIES
12 EXTRA LABOR
13 OVERTIME
21 FICA
23 PERS
24 INDUSTRIAL INSURANCE
25 MEDICAL,DENTAL,LIFE,OPTICAL
31 OFFICE & OPERATING SUPPLIES
35 SMALL TOOLS & MINOR EQUIPMENT
41 PROFESSIONAL SERVICES
42 COMMUNICATION
43 TRAVEL
45 OPERATING RENTALS & LEASES
48 REPAIRS & MAINTENANCE
49 MISCELLANEOUS
24.92%
612,869
2,500 153,62_2157
' oS 152,71_9325 404 0.00% 0.00% (625) 192
44,761 11.612960 590 25.90% 50.268 2.504 12,567 o��14�- n eV o 4
1oa�oev o U(651n71uo 1) ) 21.88% 1u�no 131,878 32,295700
30.500 1.442
�000 4 25.45%
8,56666 � m 7.02% 0.00m
6.016 1.500 1'504 30,26968 neo a (1 (,38071709)) 23.54%
56,500 14,125 1.a164
1 17,500
(14,069 0.1 0% (20,539) 7.52%
29,375
(a)
(b)
(c)
49-00 Miscellaneous 27,000 6,750 8,377 1,627 m��
�m1S�w�u��� 88,000 2c.m�
84 �1.m� o/c%��
49-03 Training
2,500 625 375
(250) 15.00% _]
64 MACHINERY & EQUIPMENT 32,000 8,000 (8,000) 0.00%
(a) Overtime is higher than expected due to backfilling positions due to temporary promotions, vacancies, and several staff out on injuries.
(b) Annual insurance premium is paid in first quarter.
(c) Valley Corn charges 2 months at a time. 4 months were paid in 1st quarter.
(d) Provides detail on miscellaneous expenditures.
** Variance = Actual over (under) prorated budget Fund 000 By Dept
CITY OF TUKWILA
General Fund Expenditures - By Department
As of March 31 2013
1
12
1,952,152
2,000
4,556
142,157
160,100
26,176
345,324
3,800
99,550
33,750
31,400
7,750
800
172,300
379,449
203,183
17,035
SALARIES
EXTRA LABOR
OVERTIME
FICA
PERS
INDUSTRIAL INSURANCE
MEDICAL,DENTAL,LIFE,OPTICAL
UNIFORM CLOTHING
OFFICE & OPERATING SUPPLIES
SMALL TOOLS & MINOR EQUIPMENT
PROFESSIONAL SERVICES
COMMUNICATION
TRAVEL
OPERATING RENTALS & LEASES
PUBLIC UTILITY SERVICES
REPAIRS & MAINTENANCE
MISCELLANEOUS
Actal Spent
488,038 449,755
500
1,139 3,029
35,539 33,627
40,025 32,198
6,544 4,917
86,331 77,050
950 189
24,888 23,557
8,438 284
7,850 (174)
1,938 316
200 13
43,075 38,258
94,862 78,051
50,796 54,464
4,259
1,779
% of year expired 25.00%
milmoppliprio
.440,10,0010,,mayko,v; „
flatiottaiatidget,„ et
(38,283) 23.04%
(500) 0.00%
1,890
(1,912)
(7,827)
(1,627)
(9,281)
(761)
(1,330)
(8,153)
(8,024)
(1,622)
(187)
(4,817)
(16,811)
3,668
(2,480)
MACHINERy&EpuTmNr (1,500) (1,500)
66.48% (a)
23.65%
20.11%
18.78%
22.31%
4.98%
23.66%
0.84%
-0.55%
4.07%
1.63%
22.20%
20.57%
26.81%
10.44%
0.00%
;$ookoel
SALARIES
13 OVERTIME
21 FICA
23 PERS
24 INDUSTRIAL INSURANCE
25 MEDICAL,DENTAL,LIFE,OPTICAL
28 UNIFORM CLOTHING
31 OFFICE & OPERATING SUPPLIES
35 SMALL TOOLS & MINOR EQUIPMENT
41 PROFESSIONAL SERVICES
45 OPERATING RENTALS & LEASES
47 PUBLIC UTILITY SERVICES
48 REPAIRS & MAINTENANCE
49 MISCELLANEOUS
cliWo
LVITZYMNAMPAMPARIMP,01
mrjoyryttiPVAPTeiy.*,
„tappowya,04,4*40:emoirObe/00,406*. 6'14'4,001 qta.„,,,51.10,44.0040000nlivie yo,.).,,,,,ovf Folk *wad .141
,,,,,t,"04,140104401,104V,41`41"**1°V#4164VOgrgt e, pent
'051 1
'Y,11,9,.ste,What4ake.5.P'Annua AtAvo(CA ,11 - ,41,9 00A0tuav
63 OTHER IMPROVEMENTS
517,680 129,420 129,570
2,295 574
38,847 9,712 9,636
42,450 10,613 9,203
15,074 3,769 2,750
78,133 19,533 18,503
1,425 356 210
36,968 9,242 4,018
1,500 375 -
25,000 6,250 4,980
108,726 27,182 26,562
173,000 43,250 46,554
37,000 9,250 2,383
4,000 1,000 1,308
5,000 1,250 - (1,250)
NW-, kt0041011111111111111110111111111M001111111111MMISIMISowealtillitt01111111110101
150 25.03%
(574) 0.00%
(75) 24.81%
(1,410) 21.68%
(1,018) 18.24%
(1,030) 23.68%
(146) 14.74%
(5,224) 10.87%
(375) 0.00%
(1,270) 19.92%
(619) 24.43%
3,304 26.91%
(6,867) 6.44%
308 32.69%
0.00%
(a) Overtime is required for private development permits for utility work. The work is usually done at night and costs are reimbursed by developer
or utility company.
** Variance = Actual over (under) prorated budget Fund 000 By Dept
13
CITY OF TUKWILA
General Fund Expenditures - By Department
As of March 31 2013
% of year expired 25.00%
11 SALARIES 813,107 203,277 202,977 (300) 24.96%
12 EXTRA LABOR 43,723 10,931 520 (10,411) 1.19%
13 OVERTIME 11,474 2,869 599 (2,270) 5.22%
21 FICA 62,459 15,615 15,322 (293) 24.53%
23 PERS 67,840 16,960 14,512 (2,448) 21.39%
24 INDUSTRIAL INSURANCE 24,133 6,033 4,944 (1,089) 20.49%
25 MEDICAL,DENTAL,LIFE,OPTICAL 190,012 42,540 (4,963)
47,503 22.39%
28 UNIFORM CLOTHING 2,375 594 415 (179) 17.46%
31 OFFICE & OPERATING SUPPLIES 333,100 83,275 16,692 (66,583)
5.01%
35 SMALL TOOLS & MINOR EQUIPMENT 12,431 3,108 613 (2,494)
4.93%
41 PROFESSIONAL SERVICES 4,000 1,000 140 (860) 3.51%
42 COMMUNICATION 4,300 1,075 376 (699) 8.74%
43 TRAVEL 2,700 675 57 (618) 2.10%
44 ADVERTISING 1,500 375 (375) 0.00%
45 OPERATING RENTALS & LEASES 368,887 92,222 91,372 (850) 24.77%
46 INSURANCE 35,455 8,864 37,406 28,542 105.50% (a)
47 PUBLIC UTILITY SERVICES 831,565 207,891 297,693 89,802 35.80%
48 REPAIRS & MAINTENANCE 27,100 6,775 82 (6,693) 0.30%
49 MISCELLANEOUS 5,200 1,300 368 (933) 7.07%
STRET 41,44 kkkt10,t*LO:ttMtl04N:::::: '010,0401114AVVi72651 arNM16,31 CSIME*07*
epoomo#,,pkqeee e, „„
,,,,,,,megnormglyly
oneozuve,,,* iA,461,5"4-0,„ '&11AP * 49 ' eta lill°1°'") Y lc *4 ''' otnnuat
BAtCE Wfom,a, ,, Ns hum Budget „ ,
ie,,„ ,,,,,,,,,,aramaroorommolypreommig d '4 Pqf 4 44*41.140 '411'"
41, tl, IP , Nirkep,,V,010 40441.001' ce4:14.71 r 4.1461% tvf`wifo
ge vmgoke* a : P u0,40;4;06., r 0eArolio tkget 6
01 TRANSFERS OUT 9,789,688 2,447,422
01-103 Transfer to Fund '103 Street
01-104 Transfer to Fund 104 Arterial Street
01-104 Transfer to Fund 105 Contingency
01-104 Transfer to Fund 109 Drug Seizure
01-104 Transfer to Fund 209 LTGO 2003
01-104 Transfer to Fund 210 LTGO Ref 2003
01-104 Transfer to Fund 211 LTGO Ref 2008
01-104 Transfer to Fund 212 LTGO 2009A
01-104 Transfer to Fund 214 LGTO 2010 A/B
01-104 Transfer to Fund 216 LTGO Ref 2000
01-104 Transfer to Fund 217 LTGO Ref 2011
01-104 Transfer to Fund 303 Gen Gov't Improve
01-411 Transfer to Fund 411 Golf Course
100,000 25,000
4,550,000 1,137,500
1.500,000 375,000
75,000 18,750
76,788 19,197
490,500 122,625
737,000 184,250
432,000 108,000
519,400 129,850
241,000 60,250
168,000 42,000
500,000 125,000
400,000 100,000
1,600,000 (847,422) 16.34%
(25,000) 0.00%
1,500,000 362,500 32.97%
(375,000) 0.00%
(18,750) 0.00%
(19,197) 0.00%
(122,625) 0.00%
(184,250) 0.00% (b
(108,000) 0.00%
(129,850) 0.00%
(60,250) 0.00%
(42,000) 0.00%
(125,000) 0.00%
100,000 25.00%
52 MPD LOANS 1,250,000 1,250,000 0.00%
00101:001101,„a„,,APIM400101111111111•00**011111Z4IE22 SINEEMM0OSSIN4027 EISIMIN
(a) Annual insurance premium is paid in first quarter.
(b) Provides detail on miscellaneous expenditures.
** Variance = Actual over (under) prorated budget Fund 000 By Dept
14
City of Tukwila
Hotel/Motel Tax Fund 101 - Revenue and Expenditures
As of March 31 2013
% of year expired
25.00%
Revenue
General Revenue
Hotel/Motel Taxes
Total General Revenue
Intergovernmental Revenue
Miscellaneous Revenue
Investment Earnings 1,766 442 271 (171) 15.33%
Other Misc Revenue 12,000 3,000 2,765 (235) 23.04%
Total Miscellaneous Revenue 13,766 3,442 3,036 (406) 22.05%
$ 538,000
538,000
134,500 $ 104,496 $ (30,004)
134,500 104,496 (30,004)
973,000 243,250
(243,250)
19.42% (a)
19.42%
0.00% (b)
0,§0,00014411tiftligifteNfentsomotosoi ofigkeitiigoat1O2 dOINIS4M32 oNDINOSMI273,659) NIESEVIMMosV
Expenditures
11 Salaries
12 Extra Labor
13 Overtime
21 FICA
23 PERS
24 Industrial Insurance
25 Medical, Dental, Life, Optical
31 Office & Operating Supplies
41 Professional Services
42 Communication
43 Travel
44 Advertising
45 Operating Rentals & Leases
47 Public Utility Services
48 Repairs & Maintenance
49 Miscellaneous
64 Capital Outlay
Total Hotel/Motel Tax Fund
293,878 73,470 73,428
30,000 7,500 2,289
4,110 1,028 954
22,243 5,561 5,865
24,100 6,025 5,528
1,252 313 297
38,867 9,717 9,722
20,000 5,000 2,356
186,000 46,500 14,720
75,000 18,750 16,324
23,000 5,750 3,534
732,000 183,000 139,752
51,741 12,935 11,289
1,500 375 450
1,000 250 -
35,400 8,850 13,418
10,000 2,500
1,550,091 387,523 299,927
(41) 24.99%
(5,211) 7.63%
(73) 23.22%
305 26.37%
(497) 22.94%
(16) 23.71%
5 25.01%
(2,644) 11.78%
(31,780) 7.91%
(2,426) 21.77%
(2,216) 15.36%
(43,248) 19.09%
(1,646) 21.82%
75 29.99%
(250) 0.00%
4,568 37.90% (c)
(2,500) 0.00%
(87,596) 19.35%
Indirect cost allocation 96,191 24,048 24,048 0 25.00%
101001#002,116kIlletalIMM:' 0:fliggel41OIMOISK423,40101Wmaist,,87,:50,0 omen•sloo*
Change in Fund Balance
Beginning Fund Balance
(121,516) (30,379) (216,443) (186,064) 178.12%
650,000 650,000 710,707 60,707 109.34%
,A*Ati#114001111611111151•110810011/1311010101311/1149424 Rigftipin4127illillnimiano•
Cash and investments
440,090
(a) Taxes based on occupancy. Revenue will increase during summer months when occupancy rates are higher.
(b) 1st quarter intergovernmental billing for services will occur in 2nd quarter.
(c) $9K of the miscellaneous expenditure line item is for membership dues in various organizations.
"" Variance = Actual over (under) prorated budget Fund 101
15
City of Tukwila
Street Fund 103 - Revenue and Expenditures
As of March 31 2013
Revenue
Intergovernmental Revenue
Miscellaneous Revenue
Investment Earnings
Total Miscellaneous Revenue
Transfers In
?',Tota f $er!e
yl
f�F
Expenditures
11 Salaries
21 FICA
23 PERS
24 Industrial Insurance
25 Medical, Dental, Life, Optical
41 Professional Services
64 Capital Outlay
Total Streets Fund
141:101,141014111101,
Change in Fund Balance
Beginning Fund Balance
$ 738,000
1,000
1,000
100,000
184,500 $ 62,781
250
250
25,000
0;00:00
699,000
328,000
1,027,000
174,750
82,000
256,750
541
541
i9a
1,121
84
81
3
68
21,414
22,770
% of year expired
(121,719)
291
291
(25,000)
x x(146 428);,
1,121
84
81
3
68
(153,336)
(82,000)
(233,980)
of
(188,000)
700,000
050,f 14
s, 1,0,770 ;t
(47,000)
700,000
40,552
1,046,771
2 3,980)
25.00%
8.51%
54.14%
54.14%
0.00%
4 zoo*
•
0.00%
0.00%
0.00%
0.00%
0.00%
3.06% (a)
0.00% (a)
2.22%
2.22%
87,552 - 21.57%
346,771 149.54%
n, t , ?l a ri .!:,} r r r/, rr x r i % HF 1 : (, rsTj rt a 111 fl4,. 2'- `'J.�f x
7r�
l� o etl�i[t Ba'/�ic t t� t f� YrL,'* ,;' iJ't„ .�512,00� fr` +' `'''� 653 000 h yl F tot g23 11 S �'l l�`>311 43� ;h} �lMs„ , I.jn +,+ i( v*
E. �.. +a. „ru r 5,n��r,.w. rP., rr s,+, .., ,"„rV, ,, s X11 .�.r 10r. ,i r,Gr�f� a.r.i rs.+ ,!
Cash and investments
$ 1,045,854
(a) 42nd Ave S Phase III, Cascade View Safe Routes to School, and Thorndyke Safe Routes to School projects are all in design phase.
** Variance = Actual over (under) prorated budget Fund 103
16
City of Tukwila
Arterial Street Fund 104 - Revenue and Expenditures
As of March 31 2013
% of year expired
25.00%
Revenue
General Revenue
Parking Taxes
Real Estate Excise Taxes
Total General Revenue
Charges for Services
Contributions/Impact Fees
Total Charges for Services
Intergovernmental Revenue
Miscellaneous Revenue
Investment Earnings
Contributions/Donations
Total Miscellaneous Revenue
Transfer In
Debt Proceeds
151,000
130,000
281,000
$ 37,750
32,500
70,250
28,426
43,884
72,311
(9,324)
11,384
2,061
18,171 18,171
9,408,000 2,352,000
3,820
272,000
275,820
4,550,000
9,180,000
955
68,000
68,955
18,171 18,171
29,544 (2,322,456)
801
6,842
7,643
1,137,500 1,500,000
2,295,000
(154)
(61,158)
(61,312)
362,500
(2,295,000)
18.83%
33.76%
25.73%
0.00%
0.00%
-6.06% (a)
20.98%
2.52%
2.77%
32.97%
0.00% (b)
ratfit*kej)*,gfgVgMdMVMA,e694,82Ca,FDVMMO/1;70sVaV:ft;Uv466W-*eN(4,2t6;oa6),dttMPfj*34%
Expenditures
11 Salaries
21 FICA
23 PERS
24 Industrial Insurance
25 Medical, Dental, Life, Optical
31 Office & Operating Supplies
41 Professional Services
44 Advertising
45 Operating Rentals & Leases
47 Public Utility Services
64 Capital Outlay
Total Arterial Streets 104
214,104 53,526 93,941 40,415
15,951 3,988 7,043 3,055
17,556 4,389 6,770 2,381
626 157 569 412
26,188 6,547 15,009 8,462
- 79 79
4,701,000 1,175,250 85,849 (1,089,401)
150 150
342 342
787 787
43.88% (c)
44.15%
38.56%
90.85%
57.31%
0.00%
1.83% (d)
0.00%
0.00%
0.00%
10,108,000 2,527,000 740,846 (1,786,154) 7.33% (d)
15,083,425 3,770,856 951,385 (2,819,472) 6.31%
Transfers Out 8,500,000 2,125,000 (2,125,000) 0.00% (b)
1ptit*****SIMMASIAMO58342510100$008010•V*5085,04,44044412MAYON3V
Change in Fund Balance 111,395 27,849 676,284 648,435 68.48%
Beginning Fund Balance 200,000 200,000 483,330 283,330 241.67%
:00:0***CRESEM37M1:10'66.15 Wnlq0a4CECnfMtAiVRiVWIWWIMEagriVom
Cash and investments
588,392
(a) Deficit in revenue is due to timing difference. Grant funds for 2012 activity to be received in 2013 was accrued in 2012 and reversed in
January 2013. Grant revenue is tied to construction projects including Boeing Access Bridge and Tukwila Urban Center - Transit
Center.
(b) Bond proceeds are for the Tukwila Urban Center Access Project Local Improvement District No. 33. It is anticipated that bonds will be
sold in the 4th quarter of 2013.
(c) Salary and benefit costs are related to the Southcenter Parkway project. Project is in the process of close-out.
(d) Boeing Access Rd over BNRR Bridge Rehab, Tukwila Urban Center - Ped/Bike Bridge, Overlay & Repair - E Marginal Way S, TUC -
Transit Center, and Andover Pk W (Tukwila Pkwy-Strander Blvd), which are the major projects in this fund are all in design phase.
** Variance = Actual over (under) prorated budget Fund 104
17
City of Tukwila
Contingency Fund 105 - Revenue and Expenditures
As of March 31 2013
Revenue
Miscellaneous Revenue
Investment Earnings
Total Miscellaneous Revenue
Transfers In
Total Reven'u e e fy,„ rr,
Change in Fund Balance
Beginning Fund Balance
Utit n
it Pala*
Cash and investments
$ 1,816
1,816
1,500,000
454 $ 812 $
454
375,000
812
41. 01 } /5;45,4:R ' R7
1,501,816
1,500, 000
3,001.816
375,454 812
1,500,000 1,460,454
X875, 454 6, 1,461, 66 ;F,,,r $
of year expired
358
358
(375,000)
g 3 Z4,l
25.00%
;MV
}k o-ju +liJ ;MV
(374,642)
(39,546)
$ 1,461,267
(a) Transfer from general fund to contingency should occur upon receipt of LID bond proceeds.
** Variance = Actual over (under) prorated budget Fund 105
18
Iff
44.72%
44.72%
0.00% (a)
SFAQM
0.05%
97.36%
0;1
City of Tukwila
Fire Equipment Cum. Reserve 107 - Revenue and Expenditures
As of March 31 2013
Revenue
Miscellaneous Revenue
Investment Earnings
Total Miscellaneous Revenue
% of year expired 25.00%
14,
fi
541 $
541
541
541
Expenditures
Transfers Out Indirect cost allocation 1,030,000 257,500 (257,500) 0.00%
Etlg,Wh,r4"millln,P,MBNIMOSX004V,W11fMfZ$WBBEIOMEISMSOTSSII(2M00)SlaStalaM*
Change in Fund Balance
Beginning Fund Balance
(1,030,000) (257,500) 541 258,041 -0.05%
1,030,000 1,030,000 892,072 (137,928) 86.61%
Ending FundBalance AINERMIMIONM7111,01110401113•41130101111111110W
Cash and investments
** Variance = Actual over (under) prorated budget Fund 107
$ 945,312
19
City of Tukwila
Drug Seizure Fund 109 - Revenue and Expenditures
As of March 31 2013
Revenue
Miscellaneous Revenue
Investment Earnings
Seizure Revenue
Total Miscellaneous Revenue
Transfers In
Tafal ftetren
Expenditures
31 Office & Operating Supplies
35 Small Tools & Minor Equipment
41 Professional Services
43 Travel
45 Operating Rentals & Leases
48 Repairs & Maintenance
49 Miscellaneous
64 Capital Outlay
Total Drug Seizure Fund
Total Expends #tires
Change in Fund Balance
Beginning Fund Balance
Ending Fur
Baartce,, s,
Cash and investments
1,000
20,000
21,000
75,000
250 $
5,000
5,250
18,750
(9,101)
(9,101)
% of year expired
(250)
(14,101)
(14,351)
(18,750)
25.00%
0.00%
- 45.50% (a)
- 43.34%
0.00%
,000 A�,�W ,,,,;,,24,000; ,fits;,,.< = ".LU,( $A 011,.; 6r602448, %1
3,000 750 (750) 0.00%
770 770 0.00%
10,000 2,500 (2,500) 0.00%
- 1,470 1,470 0.00%
10,000 2,500 (2,500) 0.00%
0.00%
2,000 500 1,700 1,200 85.00%
25,000 6,250 3,941 (2,310) 15.76%
�r� rr
:25,000 ���� ? ✓r Fr,, ,,,,$,25ii,`f�,a.�'�'r, �,.u,,.,3,$�1' +i�,.' � r;� , �(2,010) ,.,..���„ f�15: ?f► %j
71,000
280,000
17,750
280,000
(13,041)
160,125
(30,791)
(119,875)
- 18.37%
57.19%
$ 147,083
(a) Remittance of 2012 annual drug forfeiture paid to the State of Washington. 10% of what is collected is remitted to the State.
*` Variance = Actual over (under) prorated budget Fund 109
20
City of Tukwila
Debt Service Funds 2XX - Revenue and Expenditures
As of March 31 2013
Revenue
Intergovernmental Revenue
Miscellaneous Revenue
Investment Earnings
Total Miscellaneous Revenue
Transfers In
✓�a
't1tt
Expenditures
80 Debt Service Principal
81 Debt Service Interest/Misc Fees
Total Debt Service Funds
Transfers Out / Indirect cost allocation
Total a endiiures amt' F ;r ahO N
1?U.� ���� � �x� cz�� � �...
Change in Fund Balance
Beginning Fund Balance
`Ending Fund Balance
Cash and investments
66,657
16,664
259,000 $ 64,750 $
859,000 214,750
2,664,688 666,172
400445 1 „' ;, 3w im logy
7,067
7,067
kJ
of year expired
(16,664)
(251,933)
(207,683)
(666,172)
190,510)
25.00%
5,526,000
1,364,031
6,890,031
1,381,500
341,008
1,722,508
1,853
1,853
A01800 fl<
(3,299,686)
3,308,000
;8,3147[
11 ,722,508 =,i'`'320,`;
(824,922)
5,214
3,308,000 3,012,381
(1,381,500)
(339,155)
(1,720,655)
0,650Y;
830,136
(295,619)
jk,.2,483,079i + fu. 3,01 T #w 5 {Yf ?rtf
M3457� °kwfr s:
$ 3,017,595
0.00% (a)
2.73%
0.82%
0.00%
0,20%
0.00% (b)
0.14% (c)
0.03%
0.00%
r?,:(,� `0.0'
- 0.16%
91.06%
629000':
(a) Tax credit for 2010 BABs bonds. Bonds were issued for the Southcenter Parkway in the Tukwila South Annexation area and for the cost
of emergency preparedness capital and other equipment. Sequestration will reduce the tax credit by 8.7% or $2,900.
(b) Debt service principal is not due until December for all bonds except 2013 GO bond.
(c) Interest due for most bonds is in June and December of each year.
"" Variance = Actual over (under) prorated budget Fund 2XX
21
City of Tukwila
Land Acquisition, Rec and Park Development Fund 301 - Revenue and Expenditures
As of March 31 2013
Revenue
General Revenue
Excess Prop Tax Levy -Dwmsh Hill
Real Estate Excise Taxes
Total General Revenue
9 `b0
% of year expired
25.00%
$ 34,000 $ 8,500 $ 437
130,000 32,500 43,924
164,000 41,000 44,360
(8,063)
11,424
3,360
1.28%
33.79%
27.05%
Charges for Services
Park Impact Fees 60,000 15,000 19,096 4,096 31.83%
Total Charges for Services 60,000 15,000 19,096 4,096 31.83%
915,000 228,750
Intergovernmental Revenue
Miscellaneous Revenue
Investment Earnings
Rents and Concessions
Total Miscellaneous Revenue
0
10,000 2,500
10,000 2,500
677
2,000
2,677
(228,750) 0.00% (a)
(1,823)
2,000
177
Revers%ae, <+ <<, U'f% ftftF f, ,,',',.. "1xf49,A00 ,. i`j ",.,t,2 7,25C
Expenditures
11 Salaries
21 FICA
23 PERS
24 Industrial Insurance
25 Medical, Dental, Life, Optical
41 Professional Services
64 Capital Outlay
Total Park Acquisition Fund
Total Ez
Change in Fund Balance
Beginning Fund Balance
Cash and investments
952,000 238,000
170,000 42,500
1,122,000 280,500
{ MX.
27,000
500,000
uy
3,228
242
233
9
492
29,485
33,689
3,228
242
233
9
492
(208,515)
(42,500)
(246,811)
6.77%
0.00%
26.77%
;x1,76%0(
0.00%
0.00%
0.00%
0.00%
0.00%
3.10% (b)
0.00% (b)
3.00%
%280;500;, `d it , . ' /A33x6 9fr t , . i fi ,' is F (246,01,9*,*
6,750
32,444
500,000 1,090,187
'r.�►t
x'1,r
0;03;
$ 1,088,513
(a) Grant revenue is tied to projects and invoiced to grantors after project funds are expended.
(b) Duwamish Gardens project and Parks, Recreation and Open Space Plan are both in design phase.
" Variance = Actual over (under) prorated budget Fund 301
22
25,694
590,187
r4tOdl,j
120.16%
218.04%
TOM
City of Tukwila
Facility Replacement Fund 302 - Revenue and Expenditures
As of March 31 2013
Revenue
Miscellaneous Revenue
Investment Earnings
Total Miscellaneous Revenue
5,602
5,602
Expect• '
% of year expired
25.00%
udget440
,4144
1,401
1,083
1,401 1,083
(318)
19.33%
(318) 19.33%
Total Reven 5,602 IMINOMM40101.01.1100311008000(10)1001011•1043*
Expenditures
11 Salaries
21 FICA
23 PERS
31 Office & Operating Supplies
41 Professional Services
44 Advertising
47 Public Utility Services
48 Repairs & Maintenance
64 Capital Outlay
Total Expenditures
508,000
8,500
1,500
72,000
590,000
109 109 0.00%
8 8 0.00%
8 8 0.00%
- (11) (11) 0.00%
127,000 360 (126,640) 0.07% (a)
- 239 239 0.00%
2,125 2,866 741 33.72%
375 (375) 0.00%
18,000 (18,000) 0.00% (a)
147,500 3,579 (143,921) 0.61%
Indirect cost allocation 0.00%
Efil041060111111111111auntlowillowaimmoosseammomealommeuMnonisom
Change in Fund Balance
Beginning Fund Balance
(584,398)
2,000,000
(146,100) (2,496) 143,603 0.43%
2,000,000 2,005,520 5,520 100.28%
'..fia:Wie,w'i(14::*WtafggnfqtSSffr4fktanfVVZlfl,tW9dfIVltttaOWNIVNMNI4WACMMNZA'4t#K
Cash and investments $ 2,103,024
(a) City facility needs assessment contract was approved on the June 3, 2013 C.O.W. meeting.
** Variance = Actual over (under) prorated budget Fund 302
23
City of Tukwila
General Government Improvements 303 - Revenue and Expenditures
As of March 31 2013
% of year expired
25.00%
Revenue
Intergovernmental Revenue
Miscellaneous Revenue
Investment Earnings
Total Miscellaneous Revenue
Transfers In
0i
Expenditures
11 Salaries
13 Overtime
21 FICA
23 PERS
24 Industrial Insurance
25 Medical, Dental, Life, Optical
31 Office & Operating Supplies
41 Professional Services
48 Repairs & Maintenance
49 Miscellaneous 125,000
64 Capital Outlay 1,180,000
Total Gen Government Improve 1,454,937
t hr C n�s rri� �" /4A y��t'N i 4 yfxi
xpeofitdres �f ; ",`��:,' <t.,' z "f °,.
$ 847,000 $ 211,750
842
842
500,000
347,8±
100,374
7,665
8,234
313
13,351
20,000
Change in Fund Balance
Beginning Fund Balance
Ending' undB,
Cash and investments
(107,095)
200,000
192 $ (211,558) 0.02% (a)
211 135 (75) 16.07%
211 135 (75) 16.07%
125,000 (125,000) 0.00%
44
336,961 t 6 NOW, 1030a3Yo t09.25*
25,094
21,799
843
1,916 1,725
2,059 1,626
78 96
3,338 3,917
3,401
5,000 869
42,898
31,250 3,068
295,000 45,223
363,734 125,465
,„20004111 r {? f „F 5,4
(26,774) (125,138)
200,000 913,830
$
(3,294)
843
(191)
(433)
18
579
3,401
(4,131)
42,898
(28,182)
(249,777)
(238,269)
a{ 3 8E
(98,364)
713,830
IT `y"
75 '4,C �,� � ?;r�.,`' %d a, +,' + ± �"A,' +.
21.72%
0.00%
22.51%
19.74%
30.69%
29.34%
0.00%
4.35%
0.00% (b)
2.45%
3.83% (c)
8.62%
1 ( 842%
r
116.85%
456.92%
804,988
(a) Grant revenue is tied to projects and invoiced to grantors after project funds are expended.
(b) Repairs & maintenance to fire stations: install security cameras, window replacement, and flooring replacement. Costs to fire
stations budgeted in 2012 but paid for in 2013.
(c) Funds spent are continuation of the project to televise Council meetings, Of the total capital budget of $1,180M, $1 M is for Tukwila
Levee repairs & maintenance.
** Variance = Actual over (under) prorated budget Fund 303
24
City of Tukwila
Fire Impact Fees 304 - Revenue and Expenditures
As of March 31 2013
Revenue
Charges for Services
Fire Impact Fees
Total Charges for Services
Investment Earnings
Total Miscellaneous Revenue
Expenditures
64 Capital Outlay
otal �Expedi#irres
Change in Fund Balance
Beginning Fund Balance
#02, „r:
la
Cash and investments
% of year expired
$ 50,000 $ 12,500 $ 11,664 $ (836)
50,000 12,500 11,664 (836)
100
100
25
135
25
135
110
110
25.00%
23.33%
23.33%
135.35%
135.35%
'ieop
rg
50,100
300,000
1�1
12,525
300,000
11,799
348,010
3`f
1Y
** Variance = Actual over (under) prorated budget Fund 304
$ 359,809
(726)
48,010
)7,2
0.00%
23.55%
116.00%
�;,,a�, ✓t rfr,�,z',
25
City of Tukwila
Water Fund 401 - Revenue and Expenditures
As of March 31 2013
Revenue
Charges for Services
Water Sales
Security
Total Charges for Services
Miscellaneous Revenue
Investment Earnings
Connection Fees
Other Misc Revenue
Total Miscellaneous Revenue
% of year expired
25.00%
016111111111811111111111111a fnsusznrfiannuwswgwsp
$ 5,228,000
1,000
5,229,000
1,307,000
250
1,307,250
6,700 1,675
50,000 12,500
300 75
57,000 14,250
Transfers In Hydrant Rental 106,000
1,081,041 $ (225,958.86)
105 (145)
1,081,146 (226,104)
20.68%
10.50%
20.68%
8,583 6,908 128.11%
17,531 5,031 35.06% (a)
120 45 40.00%
26,234 11,984 46.02%
26,500 25,920 (580) 24.45%
to****OSONMEMilm4091;600SPANitA348;00 AtwOrist133;3004040a(214;700)VPRAW*202%
Expenses
11 Salaries 572,435 143,109 141,139 (1,970) 24.66%
12 Extra Labor 6,000 1,500 (1,500) 0.00%
13 Overtime 5,738 1,435 731 (703) 12.74%
21 FICA 43,634 10,909 10,779 (129) 24.70%
23 PERS 46,940 11,735 10,181 (1,554) 21.69%
24 Industrial Insurance 14,235 3,559 2,952 (606) 20.74%
25 Medical, Dental, Life, Optical 123,273 30,818 30,048 (770) 24.38%
28 Uniform Clothing 1,330 333 (333) 0.00%
31 Office & Operating Supplies 92,839 23,210 35,614 12,404 38.36%
33 Water Purchased for Resale 2,195,596 548,899 708,312 159,413 32.26% (b)
35 Small Tools & Minor Equipment 11,000 2,750 523 (2,227) 4.76%
41 Professional Services 270,300 67,575 9,622 (57,953) 3.56%
42 Communication 2,500 625 130 (495) 5.20%
43 Travel 1,500 375 (375) 0.00%
45 Operating Rentals & Leases 116,809 29,202 28,827 (375) 24.68%
46 Insurance 21,000 5,250 21,656 16,406 103.12% (c)
47 Public Utility Services 23,000 5,750 5,948 198 25.86%
48 Repairs & Maintenance 3,000 750 (750) 0.00%
49 Miscellaneous 35,200 8,800 8,565 (235) 24.33%
53 Excise Taxes 184,000 46,000 54,528 8,528 29.63%
54 Interfund utility taxes 534,000 133,500 108,174 (25,326) 20.26%
64 Capital Outlay 1,237,000 309,250 21,637 (287,613) 1.75% (d)
80 Debt Service Principal 460,181 115,045 (23) (115,068) -0.01%
81 Debt Service Interest 83,852 20,963 35,339 14,376 42.15%
Total Water Fund 6,085,362 1,521,341 1,234,683 (286,657) 20.29%
Indirect cost allocation . _ 511,447 127,862 127,862 (0) 25.00%
ft,owocostamstmaoam;;Aow,"oatttvtgvogqgPePalwiO6,2s45V*gfaoxg*o5ntfpgMZP4*
Change in Fund Balance
Beginning Fund Balance
(1,204,809)
4,000,000
(301,202)
4,000,000
(229,245) 71,957 19.03%
6,077,979 2,077,979 151.95%
r:grd:*rtOggtt#WCRBIEEPttnaitoMWIAIMtSKWtuowsst#4rU4xpsoaxmwfgwmlwow
Cash and investments $ 5,306,169
(a) Connection fees are related to permit activity or sale of property.
(b) Water purchased for resale includes 4 months of charges rather than 3 months.
(c) Budget for insurance based on 2012 actuals.
(d) Andover Park W/Strander new water main project is under design. Project is connected to Transit Center project.
"* Variance = Actual over (under) prorated budget Fund 401
26
City of Tukwila
Sewer Fund 402 - Revenue and Expenditures
As of March 31 2013
Revenue
Charges for Services
Sewer Sales
Total Charges for Services
°A, of year expired
25.00%
onionnigenumanimuow-Tvonsouptiniesonwonnou
5,780,000 $ 1,445,000
5,780,000 1,445,000
1,765,358
1,765,358
320,358
320,358
Miscellaneous Revenue
Investment Earnings 5,000 1,250 2,436 1,186
Connection fees 120,000 30,000 76,757 46,757
Total Miscellaneous Revenue 125,000 31,250 79,193 47,943
Public Trust Fund Loan Proceeds
750,000 187,500 (187,500)
30.54%
30.54%
48.72%
63.96% (a)
63.35%
0.00%
7d4tgdgilgegftafdltaetfMYN%0,A55,00011/MMN1A63j5000SMM1,344A51AMWMMW480,801MMIMM12702%
Expenses
11 Salaries
12 Extra Labor
13 Overtime
21 FICA
23 PERS
24 Industrial Insurance
25 Medical, Dental, Life, Optical
28 Uniform Clothing
31 Office & Operating Supplies
33 Metro Sewage Treatment
35 Small Tools & Minor Equipment
41 Professional Services
42 Communication
43 Travel
44 Advertising
45 Operating Rentals & Leases
46 Insurance
47 Public Utility Services
48 Repairs & Maintenance
49 Miscellaneous
53 Excise Taxes
54 Interfund utility tax
64 Capital Outlay
80 Debt Service Principal
81 Debt Service Interest
Total Sewer Fund
289,014 72,254 94,955 22,701 32.85%
8,000 2,000 298 (1,703) 3.72%
3,442 861 6,999 6,139 203.34% (b)
21,998 5,500 7,722 2,223 35.10% (b)
23,699 5,925 7,324 1,399 30.90% (b)
30.00% (b)
7,098
6,189 1,547 1,857 310
44,420 11,105 18,203 40.98% (b)
570 143 (143) 0.00%
22,393 5,598 3,373 (2,225) 15.06%
(318,388) 16.51%
142
3,749,000 937,250 618,862
5,500 1,375 (1,233) 2.58%
241,600 60,400 2,867 (57,533) 1.19%
2,500 625 606 (19) 24.25%
1,000 250 (250) 0.00%
150 38 144 106 95.67%
90,261 22,565 28,237 5,672 31.28%
15,195 3,799 16,734 12,936 110.13% (c)
27,050 6,763 6,82 932 9 (680) 22.48%
03
43,000 10,750 (9,818) 2.17%
30,000 7,500 5,273 (2,227) 17.58%
40,000 10,000 23,456 13,456 58.64% (d)
579,000 144,750 176,698 31,948
30.52%
1,180,000 295,000 48,129 (246,871)
275,961 68,990 (68,990) 0.00%
78,801 19,700 375 (19,326) 0.48%
6,778,743 1,694,686 1,069,267 (625,418) 15.77%
Indirect cost allocation r
71 385,141 1 4 ,96,28 5., * , 96,285 (,0 25.00%
7:0AWAWEAT6084440 6; 9740 4;160553r Abg0A 10) 0164t%
Change in Fund Balance
Beginning Fund Balance
(508,884)
1,100,000
(127,221)
1,100,000
678,998
2,199,821
806,219 -133.43%
1,099,821 199.98%
if,0740,MRPONNEEKovslogWfit#0130Pt41-WintallttittitaiWiltafit04014606148-01V
Cash and investments $ 1,917,966
(a) Connection charges are directly tied to permit activity.
(b) Emergency sewer repair work on Andover Park West. Employees from other departments were charged here for the emergency repair.
(c) Budget for insurance based on 2012 actuals.
(d) Budget has been $40,000 since 2005 but as revenue increases, so does the excise tax. Need to revise budget to reflect current taxes
owed.
** Variance = Actual over (under) prorated budget Fund 402
27
City of Tukwila
Foster Golf Course 411- Revenue and Expenditures
As of March 31 2013
% of year expired
NIWSIPUIIIEIIIIIIIIIIIIIIISWfieroonmsnngffpnpnnglmopnt
a
ror$ed A, Budge* .
25.00%
Revenue
General Revenue
Excise Taxes
2,617 $
Total General Revenue 2,617
Charges for Services
Sale of Merchandise 134,000 33,500 18,914 (14,586) 14.11%
Greens Fees, Instruction 977,850 244,463 94,367 (150,096) 9.65%
Total Charges for Services 1,111,850 277,963 113,280 (164,682) 10.19% (a)
Miscellaneous Revenue
Investment Earnings 1,130 283 135 (147) 11.98%
Rents and Concessions 276,000 69,000 32,717 (36,283) 11.85%
Other Misc Revenue - (25) (25) 0.00%
Total Miscellaneous Revenue 277,130 69,283 32,827 (36,455) 11.85%
654 762 $ 107
654
762
107
29.10%
29.10%
Transfers In
400,000 100,000
100,000 25.00%
0.0t*iiiigkificiMilikdeoallilat5.97000011M44740990iMiNt24%869480$6420t03 Ktagmegivirk:
Expenses
11 Salaries
12 Extra Labor
13 Overtime
21 FICA
23 PERS
24 Industrial Insurance
25 Medical, Dental, Life, Optical
26 Unemployment Compensation
28 Uniform Clothing
31 Office & Operating Supplies
34 Items Purchased for Resale
35 Small Tools & Minor Equipment
41 Professional Services
42 Communication
43 Travel
44 Advertising
45 Operating Rentals & Leases
46 Insurance
47 Public Utility Services
48 Repairs & Maintenance
49 Miscellaneous
53 Excise Taxes
54 lnterfund admissions tax
64 Capital Outlay
Total Foster Golf Course Fund
654,633 163,658
89,000 22,250
2,000 500
49,577 12,394
53,692 13,423
14,499 3,625
140,818 35,205
6,000 1,500
1,164 291
88,750 22,188
80,000 20,000
2,500 625
9,600 2,400
5,150 1,288
750 188
4,000 1,000
82,445 20,611
15,195 3,799
44,293 11,073
19,400 4,850
40,950 10,238
6,400 1,600
54,000 13,500
50,000 12,500
1,514,816 378,704
144,911 (18,747) 22.14%
6,642 (15,608) 7.46%
(500) 0.00%
11,269 (1,125) 22.73%
10,416 (3,007) 19.40%
2,896 (729) 19.97%
25,590 (9,614) 18.17%
- (1,500) 0.00%
- (291) 0.00%
9,034 (13,153) 10.18%
9,885 (10,115) 12.36%
(625) 0.00%
2,815 415 29.33%
478 (810) 9.28%
- (188) 0.00%
596 (404) 14.90%
20,385 (226) 24.73%
16,734 12,936 110.13% (b)
16,324 5,251 36.85%
7,058 2,208 36.38%
2,412 (7,825) 5.89%
297 (1,303) 4.64%
5,634 (7,866) 10.43%
- (12,500) 0.00%
293,378 (85,326) 19.37%
- 25.00%
Indirect cost allocation 192,801 48,200 48,200
tratg***PaalltakalntitktVZ"tS,iidMikL „..94 IIIIIIIK341,578 Iliesog8010101111101M09*
Change in Fund Balance 83,980
Beginning Fund Balance 200,000
20,995
(94,709)
200,000 404,389
(115,704) -112.78%
204,389 202.19%
tggf,:*N*L*N*CIMIOSP$ AMUOOalfirtllkniaONCIMEEooxoxpouwacfommwdow
Cash and investments $ 203,979
(a) Number of rounds of golf are up 1,280 over first quarter 2012.
(b) Budget for insurance based on 2012 actuals.
** Variance = Actual over (under) prorated budget Fund 411
28
City of Tukwila
Surface Water Fund 412 - Revenue and Expenditures
As of March 31 2013
Revenue
Charges for Services
Surface Water Sales
Total Charges for Services
Miscellaneous Revenue
Investment Earnings
Other Misc Revenue
Total Miscellaneous Revenue
Oil / f even]
Expenses
11 Salaries
12 Extra Labor
13 Overtime
21 FICA
23 PERS
24 Industrial Insurance
25 Medical, Dental, Life, Optical
28 Uniform Clothing
31 Office & Operating Supplies
35 Small Tools & Minor Equipment
41 Professional Services
42 Communication
43 Travel
44 Advertising
45 Operating Rentals & Leases
46 Insurance
47 Public Utility Services
48 Repairs & Maintenance
49 Miscellaneous
53 Excise Taxes
54 Interfund utility tax
64 Capital Outlay
80 Debt Service Principal
81 Debt Service Interest
Total Surface Water Fund
Indirect Cost Allocation
Change in Fund Balance
Beginning Fund Balance
,Eindlrltf,PundBaJa,� o rE,,,,,%
Cash and investments
✓r
% of year expired 25.00%
$ 3,839,309 $ 959,827 $ 1,934,015 $ 974,188
3,839,309 959,827 1,934,015 974,188
12,591
12,591
3,148
3,148
5,102
40
5,142
8,4,206,900 `r' ',F,k, ';,1,05 ;i25,'f .,,, ct %,r fy;('r' „1;$39,157
729,589
25,000
9,358
55,149
59,837
15,709
151,768
1,425
92,130
4,000
953,570
2,000
2,000
500
135,301
15,195
156,600
13,965
18,000
25,000
385,000
1,485,000
287,154
28,503
4,651,753
182,397
6,250
2,340
13,787
14,959
3,927
37,942
356
23,033
1,000
238,393
500
500
125
33,825
3,799
39,150
3,491
4,500
6,250
96,250
371,250
71,789
7,126
1,162,938
474,941 118,735
00900 ii , r i #n ¢x," 28 674 t I . 657 x 286 r.i r r' r r 6`24 X87 j r ,s x{ a s a
(919,794)
2,000,000
1,954
40
1,994
50.37% (a)
50.37%
40.52%
0.00%
40.84%
46.09 %
162,236 (20,161) 22.24%
7,863 1,613 31.45% (b)
1,506 (834) 16.09%
13,001 (786) 23.57%
12,358 (2,602) 20.65%
3,282 (646) 20.89%
31,676 (6,266) 20.87%
(356) 0.00%
4,229 (18,804) 4.59%
4,230 3,230 105.76%
22,366 (216,027) 2.35%
(500) 0.00%
(500) 0.00%
(125) 0.00%
32,606 (1,220) 24.10%
16,734 12,936 110.13% (c)
8,577 (30,573) 5.48%
(3,491) 0.00%
10,837 6,337 60.20% (d)
13,271 7,021 53.09% (a)
193,790 97,540 50.34% (a)
(371,250) 0.00%
(23) (71,812) -0.01%
13 (7,113) 0.05%
538,551 (624,387) 11.58%
118,735
0
25.00%
(229,949)
2,000,000
1160,206, % ;{<<t. r 3., *1 77#,f)52;
1,281,871 1,511,819
2,329,158
329,158
4,0020W J ' ,f» O(b,97 'x
139.37%
116.46%
$ 3,433,716
(a) Billing for surface water management occurs twice a year.
(b) Extra labor was for repairing the break on E Marginal Way. Break occured 11- 19 -12.
(c) Budget for insurance based on 2012 actual.
(d) The majority of miscelllaneous costs are comprised of lien fees and credit card fees.
** Variance = Actual over (under) prorated budget Fund 412
29
City of Tukwila
Equipment Rental/Replacement Fund 501 - Revenue and Expenditures
As of March 31 2013
Revenue
Charges for Services
ERR O &M Dept Charges $ 1,409,325
Equipment Replacement Charges 972,088
Transportation 150
Total Charges for Services 2,381,563
Miscellaneous Revenue
Investment Earnings 14,269
Other Misc Revenue -
Total Miscellaneous Revenue 14,269
Sale of Capital Assets 397,226
Transfers In 1,030,000
( Revenue x'} "s'1 , 11111110m400$ 8.3 fss `r,` 4` 45505511414.3 A •
ltut "�7;
% of year expired
i5ik'r'(rra�,S
25.00%
352,331 $ 352,331
243,022 258,022
38 -
595,391 610,353
0
15,000
(38)
14,963
3,567 1,760 (1,808)
- 866 866
3,567 2,625 (942)
(97,431)
99,307 1,876
257,500
Expenses
11 Salaries
12 Extra Labor
13 Overtime
21 FICA
23 PERS
24 Industrial Insurance
25 Medical, Dental, Life, Optical
28 Uniform Clothing
31 Office & Operating Supplies
34 Items Purchased for Resale
35 Small Tools & Minor Equipment
41 Professional Services
42 Communication
45 Operating Rentals & Leases
46 Insurance
48 Repairs & Maintenance
49 Miscellaneous
64 Capital Outlay
Total Equipment Rental Fund
Indirect Cost Allocation
t� d trKJSv "SAY' 4Qir � I
Change in Fund Balance
Beginning Fund Balance
End `"rt lain
364,615
12,000
2,000
27,788
29,902
10,051
77,956
950
2,979
679,000
2,500
1,000
2,000
30,142
10,130
120,781
8,000
2,209,906
3,591,700
291,838
ft ,,.,3,883,538 .f'.
(60,480)
4,000,000
91,154
3,000
500
6,947
7,476
2,513
19,489
238
745
169,750
625
250
500
7,536
2,533
30,195
2,000
552,477
897,925
(1,030,000)
25.00%
26.54%
0.00%
25.63%
12.33%
0.00%
18.40%
0.47%
0.00%
16:08 %`
90,993
2,853
7,125
6,766
2,093
19,765
471
108,850
1,886
341
7,278
10,828
12,890
1,488
7,159
280,787
72,960 72,959
(161)
(148)
(500)
178
(709)
(419)
276
(238)
(273)
(60,900)
1,261
(250)
(159)
(257)
8,296
(17,306)
(512)
(545,317)
(617,138)
(0)
'70,885 4t i :>rf, !Jrin 53, 46 °, ,r t i iiit e cY 1Z t3C?
(15,120)
4,000,000
261,108
4,132,395
r i r/ , " 1,1"7fb3�,,3 33 IOC a�f4; r ",.'� 1110760007/,
'rif,,� s � ��u.k s
Cash and investments
(a) Budget for insurance based on 2012 actual.
(b) All equipment except 2 fire pumpers and fire command vehicle have been ordered. Invoices will be paid upon delivery of vehicles, most
likely in the fall.
$ 4,374,523
(496,272)
132,395
24.96%
23.77%
0.00%
25.64%
22.63%
20.83%
25.35%
0.00%
15.82%
16.03%
75.43%
0.00%
17.05%
24.15%
106.89% (a)
10.67%
18.60%
0.32% (b)
7.82%
25.00%
;4,1 3%`;
- 431.73%
103.31%
10,t)tt ,1^it5 %;
** Variance = Actual over (under) prorated budget Fund 501
30
City of Tukwila
LEOFF Insurance Fund 503 - Revenue and Expenditures
As of March 31 2013
% of year expired
25.00%
41111111111111111111/112111111- 0i3 /11111110111111111111111111/11111
Revenue
Miscellaneous Revenue
Investment Earnings
Total Miscellaneous Revenue
3,340 $
3,340
835 $
947 $
835
947
112
112
28.37%
28.37%
"It***211/11111110fiabiftelAa, ISMISMOU03510010•01.1,0.444EMINOMUSI12 NIWSSOM240A7%
Expenses
25 Medical, Dental, Life, Optical
41 Professional Services
49 Miscellaneous
Total
479,372
19,500
498,872
119,843 79,178
4,875 548
500
124,718 80,226
(40,665) 16.52%
(4,328) 2.81%
500 0.00%
(44,492) 16.08%
Indirect Cost Allocation 9,619 2,405 2,405 (0) 25.00%
oorgir'"winijn000mnossmtstomnnnvzNsnsn000r 0 mosigsgs1441402)0111111111015%
Change in Fund Balance
Beginning Fund Balance
(505,151)
1,600,000
(126,288) (81,683) 44,605 16.17%
1,600,000 1,711,532
111,532 106.97%
Ending $alance S 1,o94,849 $ 144737t S 129,849 S 4S6,137 148.67%
Cash and investments
** Variance = Actual over (under) prorated budget Fund 503
$ 1,839,349
31
CITY OF TUKWILA
Cash & Investment Balances By Fund and Fund Group
CASH & INVESTMENT REPORT
March 31, 2013
General
General Total
Special Revenue
000 GENERAL
Special Revenue Total
Debt Service
Debt Service Total
Capital Project
Capital Project Total
101 HOTEL/MOTEL TAX
103 STREET
104 ARTERIAL STREET
105 CONTINGENCY
107 FIRE EQUIP. CUM. RESERVE
109 DRUG SEIZURE FUND
207 LIMITED TAX G.O. BONDS 1999
208 LIMITED TAX G.O. BONDS 2000
209 LIMITED TAX G.O. BONDS 2003
210 LIMITED TAX G.O. REFUNDING 2003
211 LIMITED TAX G.O. REFUNDING 2008
212 LTGO SCORE BONDS
213 LTGO SCORE BLD AMER BONDS
214 LTGO 2010 Series A
215 LTGO 2010 Series B
216 VALLEY COM Refunding bonds 2010
217 LIMITED TAX GO BONDS REFUNDING
301 LAND ACQ, REC & PARK DEVLPMNT
302 FACILITY REPLACEMENT
303 GENERAL GOVERNMNT IMPROVEMENTS
304 FIRE IMPACT FEES
Enterprise
Enterprise Total
Internal Service
400 UTILITY ON ACCT (overpayments)
401 WATER
402 SEWER
404 WATER /SEWER REVENUE BONDS
405 BOND RESERVE
411 FOSTER GOLF COURSE
412 SURFACE WATER
Internal Service Total
Grand Total
501 EQUIPMENT RENTAL
502 INSURANCE
503 INSURANCE - LEOFF I
Balance:
03- 31 -11,.
944,197 $ 3,277,604 $ 3,181,257
944,197 3,277,604 3,181,257
440,090 453,083 695,976
1,045,854 919,276 670,123
193,637 1,903,039 5,938,085
1,461,267 1,457,930 1,456,606
945,312 943,501 804,457
147,083 226,462 283,337
4,233,243 5,903,289 9,848,585
13,246
70 70
3,012,901 3,302,738 (1,592)
(55) 853 (1,852)
(84) 5,105 (18,148)
126 707 (146)
995 616 (1,392)
(614) 37 37
4,612 4,611 17
14 14 814
- (299)
3,017,595 3,314,751 (8,947)
1,088,513 1,665,327 4,787,800
2,103,024 2,019,099 2,051,032
699,853 189,463 329,478
359,809 316,591 165,331
4,251,198 4,190,480 7,333,641
22,585 18,449 13,536
5,023,986 3,713,551 4,564,859
1,791,132 1,092,612 1,478, 506
157,484
3,396,819
10,392,006
4,398,645
6,559,638
1,839,349
12,797,632
35,635,872
Note: Restricted cash and investments are not included in the above balances.
Total Restricted Cash Equivalents
Total Restricted Investments
32
615,614
393,547
1,009,161
(197,782)
3,090,068
7,716,898
3,652,343
6,502,805
1,888,703
12,043,850
36,446,873
3,193,475
393,547
3,587,022
(296,192)
3,296,619
9,057,328
3,593,124
5,953,383
1,706,648
11,253,154
40,665,018
5,418,229
393,547
5,811,776
lalances
03 -31 -10
$ 2,817,387
2,817,387
961,314
398,453
5,057,633
885,989
802,232
256,766
8,362,388
38,398
104,536
36,446
41,080
22,980
Balances
03 -31 -09
$ 5,477,292
5,477,292
779,141
422,154
10,225,948
879,828
425,577
146,115
12,878,762
249,529
356,407
459,835
296,284
20,073
243,440 1,382,129
4,232,251 3,055,221
2,074,844 2,099,003
364,677 783,732
16,119 2,355
6,687,891 5,940,311
11,159 25,780
5,597,009 5,360,441
1,802,173 2,015,210
31,866 210,203
9,631 240,926
2,704,474 4,101,108
10,156,312 11, 953, 667
3,567,409 2,822,569
5,128,996 3,592,155
1,452,497 1,144,219
10,148,902 7,558,943
38,416,320 45,191,104
123,497
391,000
514,497
203,802
391,000
594,802
CITY OF TUKWILA
March 31, 2013
SCHEDULE OF EXISTING AND FUTURE BUDGETED LONG -TERM DEBT SERVICE
Section 1
Budgeted in 2013 -2014 Biennial Budget
Section 2
Section 3
Reduction of General Fund Obligation
Section 4
Column 9
Column 10
Column 11
Column 12
Column 13
Column 14
Column 15
Column 16
Column 17
Column 18
Column 19
Column 20 ,
Column 21
Column 22
Total Existing
GO Debt
Capital
Leases
Fund 233
LTGC 2013
50,918 Loan
PWTF Loan
otal
Anticipated
Future Debt
Total Existing
and Future
General
Obligation Debt
SCORE
SC Parkway
Ext /HHD
LID
MPD
Fund Balance
Total Funding
available to eftset
General Fund
Obligations
Net Impact to
General Fund
Subtotal =
Columns 1 -8
Pumpers
D. g33
Boeing
Access Bridge
Interurban
Subtotal =
Columns 10-13
Total =
Columns 9 and
14
Subsidy --
Subsidy "
Ficimburs,3 via
LLD
Reimbursed
by MPG
Fund 209
Subtotal
Columns 16 -20
Net Total
Column 15
less Column
21
Subtotal
Subtotal
Total
Subtotal
Net Total
2013 6,276,707
2014 3335,085
2015 2,843,510
2016 2,616,505
2017 2,613,739
2018 2,603,110
2019 2.593,015
2020 1,766,200
2021 1,758,238
2022 1.753,650
2023 1,620,762
2024 4064,043
2025 531,655
2026 526,139
2027 520,394
2028 514,394
2029 508,115
2030 501,247
2031 494,527
2032 486,986
2033 479,399
2034 471,712
2035 463,485
2036 454,692
2037 445,694
2038 436.437
2039 426.869
58)
301
57)
57)
'57)
867)
5.53)
(113,130)
(113,130)
(113,130)
(113,130)
(113.130)
(113,130)
(i. 1 '1000)
4,272,190)
:1,159,698)
;1,147,410)
;1,135,278)
1,117,555)
,1,096,574)
153.756
153756
153,756
153.756
51.232
783.900
767,150
748,800
729,300
709.200
688.200
660,900
645,500
622,800
152,892
152.892
152,892
152,892
152,892
152,892
152,802
152,892
152,892
152,892
152,802
152,892
152,892
152,892
139,894
152,892
152,892
152.892
152.892
152,892
152,892
152,892
152,892
152,892
152.892
152,892
152,892
152,892
152,892
149,894
1,243,440
1,226.04D
1,208,240
19188,045
1,060,216
993,984
972 684
950.784
928.584
305.784
355,764
305.784
305,784
305,784
299,783
1,51,.''
8 ..
81 I
81 i
.
471,712
463,485
454.692
445.694
436,437
426.869
(125.005)
(121,719)
(120.049)
(118,328)
(114,465)
(110.107)
(105299)
(100,009)
(94,498)
(88,758)
(82,780)
(76,456)
(69,764)
(62,785)
(55,510)
. (47,919)
(40,000)
(31,742)
(23,133)
(14,153)
• (4,784)
(49.807)
. (43,114)
(35.882)
(27,361)
(16556)
(9,468)
(783,900)
(767,100)
(748,800)
(729,300)
.(709,200)
(688,200)
(666,900)
(645,000)
(022,800)
(113,130)
(113,130)
(113,130)
(113,115)
(1,071,843)
(1,045,063)
(1,017,861)
(988,104)
(842,222)
(807,775)
(772,199)
(745,009)
(717,298)
(88,758)
(82,780)
(76,456)
(69,764)
(62,785)
(55,510)
(47,919)
(40,000)
(31,742)
(23,133)
(14,153)
(4,784)
2,764,612
1,947,778
1,948,717
1,954,385
1,844,756
1,250,251
732,139
731,914
731,680
731,420
731,118
730,574
730,546
729,985
723,677
423,792
423,485
422,950
422,561
422,284
422,085
Totals L38,106,308
S 1,537,544
5 11,343,300
$ 3,054,838
$ 3,054,838
S 18,990,520
$ 57,096,828
S (2,390,740)
5 (560,537)
11,343,3001 5 (1,131,285)
$ (3,100,000) $ 18,533,862) S 38,562,965
Subsidy received from the federal government has been reduced by 8.7% due to sequestration.
2013 subsidy amounts reflected in this report have not been reduced by the effects of sequestration.
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
33
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
Totals
34
CITY OF TUKWILA
March 31, 2013
DETAIL OF EXISTING GO DEBT SERVICE
Section 1
Column 1
Column 2
Column 3
Column 4
Column 5
Column 6
Column 7
Column 8
Column 9
Fund 209
LTGO Bonds,
2003
Fund 210
LTGO
Refunding,
2003
Fund 211 LTGO
Refunding,
2008
Fund 212
LTGO Bonds,
2009
Fund 214 LTGO
2010
Fund 216
LTGO
Refunding,
2000
Fund 217
LTGO
Refunding,
2011
Fund 2XX
LTGO, 2013
Total Existing
GO Debt
South Park
Br, Art. St.,
Golf Course
TCC, Fire
Station #53
City Hall Annex,
Tukwila Village
SCORE
SC Parkway
Extension /HHD
Valley Corn
Arterial Street,
KC Bridge
MPD Loan
Subtotal =
Columns 1 -8
Subtotal
3,379,788
490,500
488,250
737,000
812,000
811,300
811,100
809,900
809,100
563,360
561,325
558,806
558,151
557,219
556,478
584,075
583,425
585,650
585,450
581,190
575,152
240,880
229,280
228,800
167,975
547,675
545,825
548,675
552,300
549,250
113,130
113,130
113,130
113,130
113,130
113,130
6,276,707
3,335,085
2,843,510
2,616,505
2,613,739
2.603,110
810,900
552,978
549,588
546,288
545,860
541,844
536,993
531,655
526,139
520,394
514,394
508,115
501,247
494,527
486,986
479,399
471,712
463,485
454,692
445,694
436,437
426,869
567,307
558,182
552,520
543,175
533,018
527,050
548,700
545,300
546,300
551,500
545,900
113,130
113,130
113,130
113,115
2,593,015
1,766,200
1,758,238
1,753,650
1,620,762
1,064,043
531,655
526,139
520,394
514,394
508,115
501,247
494,527
486,986
479,399
471,712
463,485
454,692
445,694
436,437
426,869
$ 3,379,788
$ 978,750
$ 5,601,300
$ 13,890,634
$ 6,776,191
$ 698,960
$ 5,649,400
$ 1,131,285
$ 38,106,308
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
Total
CITY OF TUKWILA
March 31, 2013
SCHEDULE OF EXISTING PROPIETARY DEBT SERVICE
Section 1
Existing General Obligat on Debt
Column 1
Column 2
Column 3
Column 4
Column 5
Public Trust
Fund Loan 2003
Sanitary Sewer
System
Improvements
27,223
27,093
26,963
26,332
26,702
26,572
26,442
26,311
26,160
Public Trust
Fund Loan
2004A
Neighborhood
Revitalization
328,704
327,153
325,603
24,052
22,502
20,951
319,401
317,850
316,300
314,750
313,199
311,649'
Public Trust
Fund Loan
2004C
Cascade View
Drainage
Improvements
235,473
234,362
233,251
232,141
Revenue Bond
2006
East Marginal
Way
389,294
391,603
387,422
228,808
227,698
226,587
225,476
224,366
223,255
243,750
243,350
242,750
241,960
240,950
243,975
241,550
243,900
240,800
242,475
238,700
239,700
240,250
240,350
s
240,298
3,842,115
2,752,366
,168,319
3,384,450
11
,387,547
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
35