HomeMy WebLinkAbout2013 Annual Financial ReportPrepared By:
Vicky Carlsen
December 31, 2013
J
1—
11.
0
H
0
1
Summary
The City experienced a year of financial restoration. An additional $6M was added to City -wide
funds bringing the balances closer to pre- recession levels. The main drivers for these positive fi-
nancial results were:
• The Local Improvement District #33 assessment process was completed resulting in a net $8.5M
reimbursement to the City for costs incurred in connection with the Klickitat Urban Access
project.
• Construction activity increased generating $1.2M in new construction sales tax, a $200K or 20%
increase over the prior year. Permit and other fees also increased as a result.
• A general improvement in the economy stimulated retail sales producing a $645K or 5% increase
in retail sales tax in addition to the new construction sales tax increase.
General fund ongoing revenues came in at 102% of budget yielding an additional $1.1M; depart-
mental expenditures were 98% of budget producing $764K of savings. The City used this oppor-
tunity to fund postponed transfers to other governmental funds and to restore reserves. The General
Fund added $3.5M to its balance and the Contingency fund added $4.3M. Additionally, the $2.6M
balance of golf course bonds were paid off; $1.4M was invested in two new fire engines and the fire
apparatus was added to the Equipment Rental and Replacement fund to ensure adequate replace-
ment funding. Structural balance continues to be monitored. In 2013, general fund ongoing reve-
nues of $52M less departmental expenses of $47M and debt service funding of $3M left $2M for
capital projects and other initiatives. This margin will be considered in the forthcoming budgeting
and resource allocation decisions.
The utility funds performed well with the Water and Sewer funds increasing by $460K and $1.4M
respectively yielding ending fund balances of $6.5M and $3.5M. The Surface Water fund experi-
enced a slight decline of $96K bringing its fund balance to $2.2M. The Golf Course Fund met reve-
nue projections and expenditures came in at 96% of budget increasing fund balance to $610K.
The Equipment Rental and Replacement fund and the Self- Insured Healthcare Fund for Active Em-
ployees met budget expectations resulting in fund balances of $4.2M and $4.5M respectively. The
Self- Insured Healthcare Fund for Retirees experienced higher claim costs than projected, 61% more
than budget, reducing ending fund balance to 82% of budget. Claims for 2014 will be closely mon-
itored.
2014 Outlook. The economy continues to strengthen; City challenges, however, remain Sales tax
for the first months of the year has softened slightly and construction activity has slowed compared
with 2013. Fire department overtime continues to exceed budget; easing is expected in September
when the firefighter hired into the new pipeline position is trained up and available for active duty.
With the high claim experience in 2013, consideration will be given to the appropriate funding level
of the retiree healthcare plan. 2014 also brings continued emphasis on Tukwila International Boule-
vard with plans to purchase the seized motels and ground breaking for Tukwila Village.
With a strong and sound reserve policy, continued efforts to diversify the City's economy and pru-
dent use of City resources -- all aligned with the City' s strategic goals -- the outlook for the City
remains very positive.
Peggy McCarthy, Finance Director
CITY -WIDE
FUND BALANCES
CHANGE IN FUND BALANCE
ACTUAL
- -- ACTUAL - - --
-- BUDGET - -•
VARIANCE
12/31/2012 12/31/2013
Governmental funds
$ 18,149,420 $ 23,333,905
$ 5,184,485
$ 1,120,969
$ 4,063,516
Enterprise funds
11,011,319 12,969,403
1,958,084
(2,509,507)
4,467,591
Internal service funds
10,638,313 9,586,511
(1,051,802)
(761,388)
(290,414)
City -wide Total
$ 39,799,053 $ 45,889,820
$ 6,090,767
$ (2,149,926)
$ 8,240,693
Inside this issue:
Governmental funds
2 -7
Enterprise funds
8
Internal Service funds
1
Governmental Funds
Overview
GOVERNMENTAL
FUND BALANCES
CHANGE IN FUND BALANCES
FUNDS
ACTUAL
- -- ACTUAL -- - -
- - -- BUDGET - - --
Variance
12/31/2012 12/31/2013
General Fund
$ 6,026,030 $ 9,580,354
$ 3,554,324
$ 1,583,253
$ 1,971,071
Special Revenue
4,753,461 9,064,975
4,311,514
2,826,795
1,484,719
Debt Service
3,012,381 677,110
(2,335,271)
(2,619,686)
284,415
Capital Project
4,357,549 4,011,467
(346,082)
(669,393)
323,311
GOVERNMENTAL FUNDS
$18,149,420 $23,333,905
$ 5,184,485
$ 1,120,969
$ 4,063,516
2
General Fund
General fund fiscal year activity increased fund balance by
$3.6M. Results for the year include operating revenues of
$52.2M or 102.23% of budget. The City sold $1M in bonds to
help finance MPD pool improvement project. Additionally,
$8.5M was transferred in from the Arterial Street fund and other
funds after bonds were sold to reimburse the City for expendi-
tures related to the Klickitat Urban Center project.
The General Fund had year -to -date department expenditures of
$47.3M or 98.41% of annual budget yielding a savings of
$763K .
Departments experiencing very positive budget results include
Mayor's Office at 93.01 %, Information Technology at 94.57 %,
and Public Works at 94.78 %. It should be noted that approxi-
mately $177K of savings on salaries and benefits in the Public
Works department is due to project allocations to the Arterial
Street fund which shows salaries and benefits over budget by
roughly the same amount. Detailed information on departments
can be found in the fund financial statements.
By type, all operating expenditure categories were under budget.
Non departmental expenditures were slightly over budget, pri-
marily due to the loan to the MPD.
• Salaries and benefits (99.6 %): vacancies, reduction in
use of extra labor, and medical costs lower than budget.
• Supplies & professional services (95.3% & 96.3 %): all
departments worked to hold costs down where possi-
ble.
• Intergovernmental category includes City costs of
$20K associated with the LID. The cost is for parcels
owned by the City that reside in the Local Improve-
ment District No. 33 area.
• The loan to the MPD was budgeted at $1M but
$1.25M was loaned in 2013; $1M for capital needs
and $250K for the final operating loan.
• Transfers out were budged at $9.8M but only $9.6M
was necessary for a savings in transfers out of
$200K.
Paget 2013 ANNUAL FINANCIAL REPORT
GENERAL FUND DEPARTMENTAL EXPENDITURES
DEPARTMENTS
1 2010
% of
Budget
2011
244,029
% of
Budget
2012
% of
Budget
2013
% of
Budget
City Council $ 242,851
86%
93%
251,197 93% $ 279,702
99%
Mayor
2,228,656
86%
2,218,089
94%
2,486,158
93%
2,735,592
93%
Human Resources
464,095
81%
487,920
90%
514,637
90%
602,151
98%
Finance
2,183,069
102%
1,446,736
95%
1,405,588
88%
2,254,995
100%
City Attorney
578,908
97%
647,990
92%
595,140
93%
678,993
103%
Recreation
3,130,852
89%
2,513,184
88%
2,273,480
90%
2,465,397
97%
Community Development
2,635,296
86%
2,560,151
97%
2,861,070
100%
3,181,827
97%
Municipal Court
1,208,632
104%
945,174
97%
1,014,372
100%
1,093,017
103%
Police
13,165,552
94%
14,296,485
100%
14,019,692
98%
14,725,183
97%
Fire
9,920,730
96%
9,814,177
99%
10,476,394
99%
10,708,909
102%
Information Technology
953,361
88%
1,046,573
95%
1,106,138
96%
1,245,356
95%
Public Works
4,572,757
93%
3,199,554
95%
3,166,787
88%
3,394,522
95%
Park Maintenance
992,222
99%
982,596
100%
1,072,302
100%
1,142,944
101%
Street Maintenance
2,368,562
92%
2,517,770
95%
2,711,415
98%
2,812,580
99%
Dept 20
5,108,229
83%
7,062,750
87%
6,955,263
70%
10,779,163
99%
TOTAL
$ 49,753,773
103%
$ 49,983,178
95%
$ 50,909,631
92%
$ 58,100,333
99%
GENERAL FUND EXPENDITURES BY TYPE
EXPENDITURE TYPE
2010
%of
Budget
2011
%of
Budget
2012
%of
Budget
2013
%of
Budget
Salary and benefits
$ 32,629,767
92%
$ 31,521,305
97%
$ 33,182,824
97%
$ 34,444,121
100%
Supplies
1,243,721
97%
1,153,105
91%
1,095,524
92%
1,323,872
95%
Professional services
8,255,412
87%
7,694,782
89%
8,156,708
95%
9,135,455
96%
Intergovernmental
2,183,336
105%
3,119,057
108%
2,582,425
67%
2,060,502
94%
Capital expenditures
330,504
87%
212,643
95%
273,560
89%
250,482
67%
Miscellaneous general
5,111,033
-62%
6,282,286
89%
5,618,590
75%
10,885,902
106%
TOTAL
$ 49,753,773
103%
$ 49,983,178
95%
$ 50,909,631
92%
$ 58,100,333
100%
Page 3
2013 ANNUAL FINANCIAL REPORT
3
Sales Tax
Local retail sales and use tax includes natural gas use tax
and criminal justice use tax, and earned $16.5M in 2013
compared with $15.7 million in 2012. This represents an
$847K increase year- over -year and a 8% increase com-
pared with budget.
Over 74% ($12.3 million) of the City's sales tax revenue
was derived from the Retail Trade and Services NAICS
categories with code 452- General Merchandise Stores,
contributing $2.2M, 448 - Clothing and Accessories, con-
tributing $2.1Mand 443- Electronics and Appliances, con-
tributing $997K.
The Construction category represented $1.2M or 7% of
total sales tax earned.
As in previous years, sales tax earned in December was significant-
ly higher than any other months owing to the holiday season.
Sales tax charged in the City of Tukwila is 9.5 %. Of this, the State
receives 6.5 %, King County Transit Benefit Area (Metro) re-
ceives .9 %, King County receives .25 %, RTA (Sound Transit) re-
ceives .9 %, Criminal Justice receives .1% and the City re-
ceives .85 %. The City is charged a 1% admin fee by the State of
Washington for collecting and distributing sales tax.
Property Tax
General fund property taxes earned in 2013 is $57K less than
budget and $73K less than 2012. The City's levy rate for 2013
was $2.98778 per $1,000 of assessed value (AV) based on a
City -wide assessed valuation of $4,649,191,308. AV declined
1/2 of 1% from 2012 but increased to $4,756,373,688 or 2.3%
for 2014 collections.
2010
2011
2012
2013
$13,188,942
$13,427,445
$13,830,166
$13,757,092
RGRL, Business Licenses and Rental Housing License
Collection of Revenue Generating Regulatory license (RGRL) and Rental Housing license fees began in 2011. RGRL fees were
lower than budget by $25K but added $1.7 million to General Fund revenues. RGRL increased in 2013 from 2012 collections by
$31K. Rental housing license fees came in slightly above budget by $3K and added $38K to revenue. Business license fees earned
$791K and was above budget by $19K.
Utility Taxes
4
The City of Tukwila imposes a utility tax on electrical
energy, natural gas, solid waste, cable television ser-
vice and telephone service at a rate of 6 %. Additional-
ly, a tax is levied on City -owned water, sewer and
surface water utilities. The rate was 15% through April
30, 2010 and 10% thereafter.
The customer based utility tax revenue is below budget
by $245K while the interfund utility tax exceeds budg
et by $201K. Actual 2013 customer utility tax collec-
tions are $121K lower than 2012 and interfund utility
taxes are $152K higher than 2012.
Utility Taxes
2010
2011
2012
2013
Electricity
$ 1,504,325
$ 1,550,245
$ 1,554,587
$ 1,519,189
Natural Gas
533,811
617,296
567,841
537,181
Solid Waste
339,654
345,375
347,835
362,046
Cable
229,841
224,985
227,755
231,962
Telephone
1,456,322
1,314,362
1,303,368
1,229,614
CUSTOMER
4,063,953
4,052,263
4,001,385
3,879,992
Interfund - Water
501,592
475,210
518,461
561,931
Interfund - Sewer
618,096
561,831
647,043
736,739
Interfund - Storm
378,094
335,339
369,077
388,189
INTERFUND
1,360,197
1,372,380
1,534,581
1,686,859
TOTAL
$ 5,424,150
$ 5,424,643
$ 5,535,966
$ 5,566,851
Page4 2013 ANNUAL FINANCIAL REPORT
Excise Taxes
In 2013, 97% of the gambling excise tax revenue
was derived from card games with the remainder
generated by punchboards, pull tabs and amuse-
ment games. The excise tax charged on card
games is 10% of gross proceeds; the excise tax
charged on most other forms of gambling is 5% of
gross proceeds. 2013 total excise tax revenue is
$259,553 more than budget but $421,201 less than
collected in 2012. 2012 revenue included $439K
for prior year back taxes.
Real estate excise tax (REET) is levied on all sales
of real estate. The City credits the first quarter
percent of the REET to the 301 Park Acquisition
Fund and the second quarter percent to the 104
Arterial Street Fund. REET revenue earned in
2013 exceeded budget by $127K or 149 %.
Leasehold excise tax is charged in lieu of a proper-
Excise Tax
2010
2011
2012
2013
Leasehold Excise Tax
$ 129,746
$ 52,695
$ 89,564
$ 64,609
Real Estate Excise Tax (REET)
378,052
255,836
748,001
387,401
Gambling Excise Tax
1,980,559
1,471,762
2,329,210
2,293,465
TOTAL
$ 2,488,357
$ 1,780,293
$ 3,166,776
$ 2,745,475
ty tax and is collectible on most leases of publicly -owned real and personal
property in the state. The leasehold tax rate is 12.84% of the rent paid for the
property and payment of the tax is the responsibility of the lessee. The City
remits the tax to the State, then receives back approximately 30.5% of the tax
collected. The majority of the excise tax is earned by the general fund. Gen-
eral Fund leasehold tax revenue for 2013 was $4K more than budget. The larg-
est generator of leasehold excise tax is King County International Airport.
Culture and Rec Fees
Culture and Rec fees are fees collected at the Tukwila
Community Center (TCC) and include fees for fit-
ness, youth and adult classes, before & after school
programs, and programs for senior citizens.
Revenue in 2013 is less than budget by $79K but up
$2K over last year. This is primarily due to lower
than expected registrations for classes and programs
offered as well as holding rates to a level that are
affordable by community members.
The Metropolitan Park District was formed in late
2011, which accounts for the decrease from 2011 to
2012 revenue.
2010
2011
2012
2013
$701,216
$569,571
$437,894
$440,273
Pages 2013 ANNUAL FINANCIAL REPORT
5
Permit Income
The General Fund receives 100% of permit revenue. Permit revenue for 2013 exceeded budget by $100K and was more than 2012
by 39% or $332K. Permit activity increased in 2013 in all categories except plumbing / gas. The highest value for each of the per-
mit types for 2013 and 2012 were as follows:
BUILDING PERMITS
MECHANICAL PERMITS
PLUMBING /GAS PERMITS
ELECTRICAL PERMITS
2013: Sound Transit: $10,951,570, Tukwila Home 2 Suites Hotel: $11,018,510
2012: Westfield Mall: $2,375,000, Boeing #9 -101: $1,680,000
2013: Sabey Corporation: $1,674,530, Boeing #9 -101: $1,600,000
2012: Westfield Mall: $435,495, Boeing #9 -96: $1,499,543
2013: Boeing #9 -53: $651,124, Sabey Corporation: $389,720
2012: Providence Infusion and Pharmacy: $194,860, Fruititude: $130,000
2013: Sabey Corporation: $1,700,000, Boeing #9 -101: $1,253,000
2012: Boeing #9 -101: $1,073,709, Boeing #9 -101: $753,409
Permit Revenue
2010
2011
2012
2013
Permits Issued
2010
2011
2012
2013
Buildings / Structures
$ 619,262
$ 596,081
$ 472,202
$ 713,153
Building
306
389
354
374
Mechanical
111,368
156,884
82,239
88,144
Mechanical
177
180
191
221
Electrical
300,084
347,201
260,689
346,989
Electrical
1,040
1,158
1,175
1,337
Plumbing / gas / other
37,700
35,422
37,754
37,093
Plumbing / gas
172
187
210
167
TOTAL
$ 1,068,414
$1,135,588
$ 852,885
$1,185,379
TOTAL
1,695
1,914
1,930
2,099
Plan Check & Other Fees
Plan check and other fees recorded into the Gen-
eral Fund in 2013 totaled $688,564, an increase
of $88,161 or 15% from 2012 and $70K more
than budget.
The fire impact fees and park impact fees re-
ceived in 2013 were significantly more than
amounts received in 2012 and $135K more than
budget. Park and fire impact fees are budgeted
based on planned projects.
Plan Check
& Other Fees
2010
2011
2012
2013
Plan checking fees
$ 582,422
$ 417,590
$ 479,119
$ 514,164
Zoning and subdivision
95,321
97,025
93,374
133,572
Electrical plan review
35,505
24,971
16,966
20,340
Other
5,612
13,410
10,944
20,488
TOTAL GENERAL FUND
$ 718,860
$ 552,996
$ 600,403
$ 688,564
Fire impact fees
Park impact fees
TOTAL $ 969,420 $ 799,137 $ 655,217 $ 933,457
Intergovernmental Revenue
Intergovernmental revenue comprises grant funds
from federal, state and local governmental entities
and other governmental receipts.
Approximately $829K was received as grant funding
either directly or indirectly from the federal govern-
ment, $1.4M in grant revenue was received from the
state, and the balance from various other governmen-
tal sources including sales tax for criminal justice,
2010
2011
2012
2013
$12,915,585
$22,436,436
$8,591,989
$8,237,842
liquor excise tax, and the City's share of the EMS levy.
The General Fund received $4.8 in intergovernmental revenue with $2.1
million derived from the Seattle City Light agreement and $1.1 from sales
tax mitigation.
Page 6
6
2013 ANNUAL FINANCIAL REPORT
Debt Service Funds
Special Revenue Funds
GOVERNMENTAL
Special Revenue
FUND BALANCES
CHANGE IN FUND BALANCES
ACTUAL
12/31/2012 12/31/2013
- -- ACTUAL -- - -
- - -- BUDGET - - --
Variance
101 - Hotel /Motel Tax Fund
$ 710,707 $ 714,946
$ 4,238
$ (124,416)
$ 128,654
103 - Street Fund
1,046,772 1,415,955
369,183
107,000
262,183
104 - Arterial Street Fund
483,331 1,095,534
612,203
2,331,395
(1,719,192)
105 - Contingency Fund
1,460,454 5,762,931
4,302,477
1,576,816
2,725,661
107 - Fire Equip Cum Reserve
892,072 (0)
(892,072)
(1,030,000)
137,928
109 - Drug Seizure Fund
160,125 75,609
(84,515)
(34,000)
(50,515)
Total Capital Project
$ 4,753,461 $ 9,064,975
$ 4,311,514
$ 2,826,795
$ 1,484,719
Special revenue funds increased $4.3 million for the fiscal year.
Fund 105- Contingency Fund was the largest contributor to the total
increase.
Fund 103 - Street: A transfer of $130K from the general fund that
had been delayed from 2012 was made in 2013.
Fund 104 - Arterial Street: Bond proceeds of $6M were received in
November. The bond proceeds along with excess fund balance was
transferred back to the general fund.
The TUC Transit Center project was approved by Council in No-
vember with construction slated to begin in 2014.
Additionally, Boeing Access Road over BNRR Bridge and the
Tukwila Urban Center- Ped/Bike Bridge were both in design phase
late in 2013.
Fund 105- Contingency: Transfers in of $4.3M occurred in 2013
bringing the ending fund balance more in line with the City' s fund
balance policy.
Fund 107 -Fire Equip Cum Reserve: The balance of $892K was
transferred to fund 501 and allocated to the aerial ladder truck
replacement.
The City had several significant debt related transactions in 2013.
- The 2003 LTGO bonds ($2.7M) for the golf course were retired
early.
- The City issued $1M LTGO bond and loaned the proceeds to the
Tukwila Metropolitan Park District for pool renovation costs. The
bonds will be repaid over 10 years.
-The City also issued $6.7M special assessment (LID) debt for the
Urban Center Access (Klickitat) project. The bonds will be re-
paid with special assessments from property owners within the
LID area over a 15 year repayment period.
Capital Project Funds
GOVERNMENTAL
Capital Project
FUND BALANCES
CHANGE IN FUND BALANCES
ACTUAL
- -- ACTUAL -- - -
- - -- BUDGET - - --
Variance
12/31/2012 12/31/2013
301 - Parks Acq Fund
$ 1,090,188 $ 1,219,889
$ 129,700
$ 27,000
$ 102,700
302 - Facility Replacement Fund
2,005,520 1,902,602
(102,918)
(584,398)
481,480
303 - General Gov Improvements
913,830 451,754
(462,076)
(107,095)
(354,981)
304 - Fire Impact Fee Fund
348,010 437,222
89,213
(4,900)
94,113
Total Capital Project
$ 4,357,549 $ 4,011,467
$ (346,082)
$ (669,393)
$ 323,311
Total capital project fund balances decreased $346K for the fiscal
year.
Fund 301 -Parks Acquisition: Fund balance increased by $130K.
While revenue is at 46% of budget, expenditures are at 35% of budg-
et. Duwamish Gardens project is still in the design phase
Fund 302 - Facilities Replacement: Fund balance decrease of
$103K is less than planned because a demo on TIB did not occur as
scheduled. Expenditures are 18% of budget.
Fund 303 - General Government Improvements: Has the largest
decline in fund balance within the capital projects fund group.
Revenue received is 19% of budget while expenditures are at 52%
of budget. Grant revenue is tied to projects and invoiced to gran-
tors after project funds are expended. Additionally, transfers into
this fund occur on an as- needed basis.
Fund 304 -Fire Impact Fees: Fund balance increased $90K due
to impact fee revenue exceeding budget.
Page 7
2013 ANNUAL FINANCIAL REPORT
7
Enterprise Funds
ENTERPRISE
FUNDS
FUND BALANCES
CHANGES IN FUND BALANCES
ACTUAL
- -- ACTUAL -- - -
- - -- BUDGET - - --
Variance
12/31/2012 12/31/2013
401 - Water Fund
$ 6,077,949 $ 6,538,048
$ 460,099
$ (1,204,809)
$ 1,664,908
402 - Sewer Fund
2,199,823 3,589,175
1,389,352
(508,884)
1,898,236
411 - Foster Golf Fund
404,389 609,990
205,601
123,980
81,621
412 - Surface Water Fund
2,329,158 2,232,190
(96,968)
(919,794)
822,826
ENTERPRISE FUNDS
$ 11,011,319 $ 12,969,403
$ 1,958,084
$ (2,509,507)
$ 4,467,591
All enterprise funds, with the exception of the Surface Water fund,
increased fund balance for the fiscal year. The Surface Water fund
showed a slight decrease.
Fund 401 - Water. The Water fund realized a fund balance increase
of $460 for the fiscal year. Total revenue exceeded budget by 10%
or $558K and expenses were under budget by 17% or $1.1M. This
is primarily due to the Andover West /Strander new water main pro-
ject carried into 2014.
Fund 402 - Sewer. The Sewer fund realized a fund balance in-
crease of $1.4M for the fiscal year. Revenues exceeded budget by
15% or $978K and expenses were under budget by 13% or $920K.
Revenues exceeded budget due to conservative budgeting even
without receiving the Public Works Trust Fund loan that was budg-
eted. Expenses were lower than budget because the CBD Sewer
Rehab project was delayed due to a sewer main break in the project
area. The project will be carried into 2014.
Fund 411 -Golf Course. The Golf Course realized a fund balance
increase of $206K for the fiscal year. Revenues were right on
budget but expenses were lower than budget by 4% or $69K.
Capital outlay was postponed until 2014 and both salaries and
extra labor were below budget.
Fund 412 - Surface Water. The Surface Water fund realized a
fund balance increase of $97K for the fiscal year. Revenues were
lower than budget by 6% or 287K primarily due to not receiving
a grant award for the Lower Duwamish Surface Water Convey-
ance project. Expenses were lower than budget by 22% or $1.1M
due to late starts on both the annual small drainage program and
Storm Lift Station #15.
Internal Service Funds
INTERNAL SERVICE
FUNDS
FUND BALANCES
CHANGES IN FUND BALANCES
ACTUAL
- -- ACTUAL -- - -
- - -- BUDGET - - --
Variance
12/31/2012 12/31/2013
501 - Equipment Replacement
$ 4,132,395 $ 4,229,285
$ 96,889
$ 96,520
$ 369
502 - Self- Insurance Fund
4,794,386 4,460,344
(334,041)
(352,757)
18,716
503 - LEOFF Insurance Fund
1,71 1 ,532 896,882
(814,650)
(505,151)
(309,499)
INTERNAL SERVICE FUNDS
$ 10,638,313 $ 9,586,511
$ (1,051,802)
$ (761,388)
$ (290,414)
Fund 501- Equipment Replacement. Fund balance increased by
$97K for the fiscal year. All budgeted purchases were made with
the exception of the fire command vehicle. Additionally, $71K in
costs for 2 fire pumpers ordered in 2013 will be paid in 2014.
Fund 502- Insurance. Fund balance decreased by $334K for the
fiscal year, however, the decrease is slightly less than budgeted by
$19K. This is primarily due to lower than expected expenditures.
Fund 503 -LEOFF Insurance. Fund balance decreased by $815K
for the fiscal year. Fund balance was budgeted to decrease by
$505K. The additional reduction in fund balance is attributable to
several large claims in 2013.
Page 8
8
21)13 ANNUAL FINANCIAL REPORT
City of Tukwila
General Fund 000 - Revenue and Expenditures
As of December 31 2013
% of year expired 100.00%
2013
Annual Budget
Prorated
Budget
Actual
Year -To -Date
Variance **
% of Annual
Budget
Revenue
General Revenue
Property Taxes
Sales and Use Taxes
Admissions Tax
Utility Taxes
Interfund Utility Tax
Excise Taxes
Total General Revenue
Licenses and Permits
Revenue Generating Regulatory Lics
Business Licenses and Permits
Rental Housing License
Building Permits and Fees
Total Licenses and Permits
Intergovernmental Revenue
Sales Tax Mitigation
Seattle City Light Agreement
Grants
State Entitlements
Other
Total Intergovernmental Revenue
Charges for Services
General Government
Security
Engineering Services
Transportation
Plan Check and Review Fees
Culture and Rec Fees
Total Charges for Services
Fines and Penalties
Miscellaneous Revenue
Indirect cost allocation
Ongoing Revenue
Sale of Bond Proceeds for MPD
Transfers In
Total Revenue
Expenditures
Department Expenditures
Loan to MPD
Transfers to Debt Service Funds
Transfers to Other Funds
Total Expenditures
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
Cash and investments
1
$ 13,814,401
15,298,722
612,000
4,124,920
1,486,000
2,097,341
37,433,384
1,750,000
772,089
35,000
1,085,000
3,642,089
1,165,641
2,206,344
802,997
312,874
453,096
4,940,952
54,363
554,725
9,867
167,000
618,500
519,755
1,924,210
234,829
803,875
2,035,740
51,015,079
1,000,000
8,500,000
60,515,079
48,084,998
1,000,000
2,664,688
7,182,140
58,931,826
$ 13,814,401
15,298,722
612,000
4,124,920
1,486,000
2,097,341
37,433,384
1,750,000
772,089
35,000
1,085,000
3,642,089
1,165,641
2,206,344
802,997
312,874
453,096
4,940,952
54,363
554,725
9,867
167,000
618,500
519,755
1,924,210
234,829
803,875
2,035,740
51,015,079
1,000,000
8,500,000
60,515,079
1,583,253
6,000,000
$ 7,583,253 $
48,084,998
1,000,000
2,664,688
7,182,140
58,931,826
1,583,253
6,000,000
7,583,253
$ 13,757,092
16,520,856
689,640
3,879,992
1,686,859
2,356,894
38,891,333
1,724,557
790,947
37,550
1,185,379
3,738,432
1,122,631
2,084,039
695,635
342,560
598,400
4,843,264
48,178
399,502
42,964
688,564
440,273
1,619,480
242,638
783,822
2,035,687
52,154,656
1,000,000
8,500,000
61,654,656
47,321,170
1,250,000
2,940,244
6,588,919
58,100,333
3,554,324
6,026,030
$ 9,580,354
$ 7,737,222
$ (57,309)
1,222,134
77,640
(244,928)
200,859
259,553
1,457,949
(25,443)
18,858
2,550
100,379
96,343
(43,010)
(122,305)
(107,362)
29,686
145,304
(97,688)
(6,185)
(155,223)
(9,867)
(124,036)
70,064
(79,482)
(304,730)
7,809
(20,053)
(53)
1,139,577
1,139,577
99.59%
107.99%
112.69%
94.06%
113.52%
112.38%
103.89%
98.55%
102.44%
107.29%
109.25%
102.65%
96.31%
94.46%
86.63%
109.49%
132.07% (a)
98.02%
88.62%
72.02% (b)
0.00%
25.73% (c)
111.33%
84.71%
84.16%
103.33%
97.51%
100.00%
102.23%
100.00%
100.00%
101.88%
(763,828) 98.41%
250,000 125.00%
275,556 110.34%
(593,221) 91.74%
(831,493) 98.59%
1,971,071 224.49%
26,030 100.43%
$ 1,997,101 126.34%
(a) Other governmental revenue includes $400K from the EMS levy and other local government agencies.
(b) Protective inspection fees $45K less than budget, law enforcement service contract $61 K less than budget.
(c) Budget is for street repair & maintenance. Less damage to streets occurred in 2013 than budgeted.
** Variance = Actual over (under) prorated budget Fund 000
9
CITY OF TUKWILA
General Fund Expenditures - By Category
As of December 31 2013
TOTALS BY CATEGORY
SALARIES AND BENEFITS
SUPPLIES
PROFESSIONAL SERVICES
INTERGOVERNMENTAL
CAPITAL EXPENDITURES
DEPARTMENTAL EXPENDITURES
LOAN TO MPD
TRANSFERS OUT
TOTAL EXPENDITURES
TOTALS BY CATEGORY — DETAIL
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 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
53 EXT TAXES & OPER ASSMNTS
63 OTHER IMPROVEMENTS
64 MACHINERY & EQUIP, OTHER
OPERATING EXPENDITURES
52 LOAN TO MPD
00 TRANSFERS OUT
Grand Totals
Annual Budget
$ 34,590,101
1,388,678
9,482,101
2,176,118
372,000
48,008,998
Prorated
Budget
$ 34,590,101
1,388,678
9,482,101
2,176,118
372,000
48,008,998
1,000,000 1,000,000
9,922,828 9,922,828
58,931,826 $ 58,931,826
Annual Budget
$ 24,418,896
482,412
1,620,086
194,452
1,463,286
614,477
985,762
431,947
4,338,708
30,000
10,075
1,119,229
14,428
255,021
2,589,802
368,596
120,565
56,050
2,232,887
605,535
1,497,374
766,990
1,244,302
2,176,118
5,000
367,000
48,008,998
1,000,000
$ 9,922,828
$ 58,931,826
Prorated
Budget
$ 24,418,896
482,412
1,620,086
194,452
1,463,286
614,477
985,762
431,947
4,338,708
30,000
10,075
1,119,229
14,428
255,021
2,589,802
368,596
120,565
56,050
2,232,887
605,535
1,497,374
766,990
1,244,302
2,176,118
5,000
367,000
48 008,998
1,000,000
9,922,828
58,931,826
" Variance = Actual over (under) prorated budget Fund 000 By Category
10
Actual Spent
$ 34,444,121
1,323,872
9,135,455
2,060,502
250,482
47,214,431
1,250,000
9,635,902
$ 58,100,333
Actual Spent
$ 24,098,335
472,859
1,815,492
191,359
1,533,223
747,730
975,125
406,790
4,166,773
30,794
5,641
1,060,347
36,101
227,423
2,292,450
303,565
94,692
30,920
2,299,383
586,557
1,538,824
693,218
1,295,845
2,060,434
67
250,482
47,214,431
1,250,000
9,635,902
$ 58,100,333
% of year expired 100.00%
Variance
$ (145,980)
(64,806)
(346,646)
(115,616)
(121,518)
(794,567)
250,000
(286,926)
$ (831,493)
% of Annual
Budget Spent
99.58%
95.33%
96.34%
94.69%
67.33%
98.34%
125.00%
97.11%
98.59%
Variance
$ (320,561)
(9,554)
195,406
(3,093)
69,937
133,253
(10,637)
(25,157)
(171,935)
794
(4,434)
(58,882)
21,673
(27,598)
(297,352)
(65,031)
(25,873)
(25,130)
66,496
(18,978)
41,450
(73,772)
51,543
(115,684)
67
(5,000)
(116,518)
(794,567)
250,000
(286,926)
$ (831,493)
% Spent
98.69%
98.02%
112.06%
98.41%
104.78%
121.69%
98.92%
94.18%
96.04%
102.65%
55.99%
94.74%
250.22%
89.18%
88.52%
82.36%
78.54%
55.17%
102.98%
96.87%
102.77%
90.38%
104.14%
94.68%
0.00%
0.00%
68.25%
98.34%
125.00%
97.11%
98.59%
CITY OF TUKWILA
General Fund Expenditures - By Department
As of December 31 2013
TOTALS - ALL DEPARTMENTS
CITY COUNCIL
MAYOR
HUMAN RESOURCES
FINANCE
CITY ATTORNEY
RECREATION
COMMUNITY DEVELOPMENT
MUNICIPAL COURT
POLICE
FIRE
INFORMATION TECHNOLOGY
PUBLIC WORKS
PARK MAINTENANCE
STREET MAINTENANCE & OPERATION
TOTAL ALL DEPARTMENTS
LOAN TO MPD
TRANSFERS OUT (DEPT 20 ONLY)
GRAND TOTAL ZEM
01 - CITY COUNCIL
11 SALARIES
21 FICA
23 PERS
24 INDUSTRIAL INSURANCE
25 MEDICAL,DENTAL,LIFE,OPTICAL
31 OFFICE & OPERATING SUPPLIES
41 PROFESSIONAL SERVICES
42 COMMUNICATION
43 TRAVEL
49 MISCELLANEOUS
CITY COUNCIL
Annual Budget
$ 282,431
2,941,131
614,578
2,258,494
661,860
2,537,008
3,286,009
1,063,296
15,125,412
10,447,976
1,316,862
3,581,482
1,127,098
2,841,361
48,084,998
1,000,000
9,846,828
58.931.826
$
Annual Budget
164,446
12,580
21,481
2,504
19,150
3,870
16,500
6,000
25,000
10,900
282,431
Prorated
Budget
$ 282,431
2,941,131
614,578
2,258,494
661,860
2,537,008
3,286,009
1,063,296
15,125,412
10,447,976
1,316,862
3,581,482
1,127,098
2,841,361
48,084,998
1,000,000
9,846,828
$ 58.931.826
Prorated
Budget
164,446
12,580
21,481
2,504
19,150
3,870
16,500
6,000
25,000
10,900
282,431
**Variance = Actual over (under) prorated budget Fund 000 By Dept
Actual Spent
$ 279,702
2,735,592
602,151
2,254,995
678,993
2,465,397
3,181,827
1,093,017
14,725,183
10,708,909
1,245,356
3,394,522
1,142,944
2,812,580
47,321,170
1,250,000
9,529,163
$ 58.100.333
% of year expired
Variance
$ (2,729)
(205,539)
(12,427)
(3,499)
17,133
(71,611)
(104,182)
29,721
(400,229)
260,933
(71,506)
(186,960)
15,846
(28,781)
(763,828)
250,000
(317,665)
$ (831.493)
100.00%
% of Annual
Budget Spent
99.03%
93.01 %
97.98%
99.85%
102.59%
97.18%
96.83%
102.80%
97.35%
102.50%
94.57%
94.78%
101.41%
98.99%
98.41%
125.00%
96.77%
Actual Spent Variance
172,664 8,218 105.00% (a)
13,311 731 105.81%
21,758 277 101.29%
2,286 (218) 91.30%
24,809 5,659 129.55% (b)
2,210 (1,660) 57.09%
11,230 (5,270) 68.06%
5,005 (995) 83.42%
16,209 (8,791) 64.84%
10,219 (681) 93.76%
279,702 - 2,729 99.03%
11
CITY OF TUKWILA
General Fund Expenditures - By Department
As of December 31 2013
03 - MAYOR sli"`aax
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 & 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 -53 Hearing examiner fees
49 -56 Green initiatives
51 INTERGVRNMTL PROFESSIONAL SVCS
53 EXT TAXES & OPERATING ASSMNTS
MAYOR
04 - HUMAN RESOURCES
11 SALARIES
12 EXTRA LABOR
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
48 REPAIRS & MAINTENANCE
49 MISCELLANEOUS
HUMAN RESOURCES
" Variance = Actual over (under) prorated budget
12
1 Prorated
Annual Budget Budget Actual Spent
1,131,716 1,131,716 1,093,614
10,500 10,500 1,385
573 573 34
81,188 81,188 79,234
92,560 92,560 89,614
3,991 3,991 3,279
174,880 174,880 168,668
43,024 43,024 33,220
4,935 4,935 990
943,970 943,970 830,198
72,600 72,600 58,590
16,300 16,300 14,959
14,750 14,750 8,127
29,148 29,148 18,451
17,750 17,750 10,184
275,746 275,746 274,608
31,065 31,065 87,658
175,650 175,650 120,713
20,800 20,800 15,953
5,000 5,000 7,848
4,300 4,300 4,300
2,500 2,500 2,484
431 431 422
6,000 6,000 4,425
- - 311
30,000 30,000 30,493
27,500 27,500 50,435
- - 1
2,941,131 2,941,131 2,735,592
Prorated
Annual Budget Budget Actual Spent
380,552 380,552 380,397
- - 1,812
26,966 26,966 27,117
31,222 31,222 31,110
1,252 1,252 1,079
56,956 56,956 58,786
4,842 4,842 6,414
85,625 85,625 81,200
- - 9
1,500 1,500 1,022
7,000 7,000 2,170
3,108 3,108 3,062
5,105 5,105 2,532
10,450 10,450 5,441
614,578 614,578 602,151
Fund 000 By Dept
% of year expired
Variance
(38,102)
(9,115)
(539)
(1,954)
(2,946)
(712)
(6,212)
(9,804)
(3,945)
(113,772)
(14,010)
(1,341)
(6,623)
(10,697)
(7,566)
(1,138)
56,593
(54,937)
(4,847)
2,848
(16)
(9)
(1,575)
311
493
22,935
1
(205,539)
100.00%
% of Annual
Budget Spent
96.63%
13.19%
6.02%
97.59%
96.82%
82.17%
96.45%
77.21 %
20.07%
87.95% (c)
80.70%
91.77%
55.10%
63.30%
57.38%
99.59%
282.18%
68.72%
76.70%
156.96%
100.00%
99.36%
Variance
(155)
1,812
151
(112)
(173)
1,830
1,572
(4,425)
9
(478)
(4,830)
(46)
(2,573)
(5,009)
(12,427)
101.64%
183.40% (d)
0.00%
93.01%
% of Annual
Budget Spent
99.96%
0.00%
100.56%
99.64%
86.18%
103.21%
132.46%
94.83%
0.00%
68.11 %
30.99%
98.53%
49.61%
52.07%
97.98%
CITY OF TUKWILA
General Fund Expenditures - By Department
As of December 31 2013
05 - FINANCE r �%°t 'i`•tt"
a a;`
11 SALARIES
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
53 EXT TAXES & OPERATING ASSMNTS
FINANCE
06 - CITY ATTORNEY
12 EXTRA LABOR
21 FICA
24 INDUSTRIAL INSURANCE
31 OFFICE & OPERATING SUPPLIES
41 PROFESSIONAL SERVICES
41 -00 Professional services
41 -01 Contracted Attorney services
41 -02 Contracted prosecution service
41 -03 Special matters
42 COMMUNICATION
45 OPERATING RENTALS & LEASES
48 REPAIRS & MAINTENANCE
49 MISCELLANEOUS
CITY ATTORNEY
Annual Budget
988,041
30,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 100.00%
Prorated
Budget Actual Spent Variance
988,041 977,124 (10,917)
30,000 (30,000)
10,000 2,350 (7,650)
73,927 73,258 (669)
81,036 80,378 (658)
3,756 3,131 (625)
198,970 182,945 (16,025)
30,000 30,000 -
19,296 11,347 (7,949)
175,000 79,743 (95,257)
1,000 144 (856)
5,000 2,378 (2,622)
2,700 1,275 (1,425)
240,000 218,402 (21,598)
2,500 55,260 52,760
397,268 537,248 139,980
21,900 13,393 (8,507)
370,000 519,959 149,959
5,368 3,896 (1,472)
- 12 12
2 258,494 2,258,494 2,254,995 (3,499)
Prorated
Annual Budget Budget Actual Spent Variance
- 1,902 1,902
145 145
- 150 150
3,100 3,100 5,077 1,977
652,260 652,260 671,344 19,084
2,000 2,000 15,906 13,906
340,200 340,200 320,005 (20,195)
105,060 105,060 119,605 14,545
205,000 205,000 215,829 10,829
2,000 2,000 - (2,000)
2,100 2,100 (2,100)
1,400 1,400 (1,400)
1,000 1,000 375 (625)
%of Annual
Budget Spent
98.90%
0.00%
23.50%
99.10%
99.19%
83.35%
91.95%
100.00%
58.81%
45.57% (e)
14.35%
47.57%
661,860 661,860 678,993 17,133
** Variance = Actual over (under) prorated budget Fund 000 By Dept
91.00%
2210.39% (e)
135.24% (f)
61.15%
140.53% (f)
72.59%
0.00%
99.85%
% of Annual
Budget Spent
0.00%
0.00%
0.00%
163.79%
102.93%
795.29%
94.06%
113.84%
105.28%
0.00%
0.00%
0.00%
37.50%
102.59%
13
CITY OF TUKWILA
General Fund Expenditures - By Department
As of December 31 2013
07 - RECREATION
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 PURCH. FOR INVENT /RESALE
41 PROFESSIONAL SERVICES
42 COMMUNICATION
43 TRAVEL
44 ADVERTISING
45 OPERATING RENTALS & LEASES
48 REPAIRS & MAINTENANCE
49 MISCELLANEOUS
49 -01 Printing and binding
49 -04 Trip admissions Seniors
49 -05 Trip admissions Youth
49 -08 Special Accommodations
other
5' INTERGOV TAXES & ASSMNTS
64 MACHINERY & EQUIPMENT
RECREATION
08 - COMMUNITY DEVELOPMENT
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
COMMUNITY DEVELOPMENT
Variance = Actual over (under) prorated budget
14
Annual Budget
1,234,948
295,851
1,100
114,524
101,325
28,375
241,908
82,428
14,428
184,037
14,380
8,450
28,500
37,406
32,350
90,998
35,000
7,250
8,900
2,000
37,848
26,000
2,537,008
Annual Budget
1,912,511
94,338
5,951
144,253
158,943
15,785
289,989
975
31,350
1,300
233,835
2,925
8,600
3,500
20,804
44,550
101,400
15,000
200,000
3,286,009
Prorated
Budget
1,234,948
295,851
1,100
114,524
101,325
28,375
241,908
82,428
14,428
184,037
14,380
8,450
28,500
37,406
32,350
90,998
35,000
7,250
8,900
2,000
37,848
26,000
2,537,008
Prorated
Budget
1,912,511
94,338
5,951
144,253
158,943
15,785
289,989
975
31,350
1,300
233,835
2,925
8,600
3,500
20,804
44,550
101,400
15,000
200,000
3,286,009
Fund 000 By Dept
Actual Spent
1,228,387
279,621
6,382
112,979
109,436
34,090
239,314
131
116,065
36,101
107,406
8,812
5,425
19,962
50,945
20,433
86,848
26,550
14,713
10,529
35,057
3,059
2,465,397
Actual Spent
1,944,116
82,771
8,402
150,773
162,044
13,678
295,731
186
44,261
227
213,296
4,446
6,103
363
20,708
52,749
57,570
7,176
2
117,224
3,181,827
of year expired
Variance
(6,561)
(16,230)
5,282
(1,545)
8,111
5,715
(2,594)
131
33,637
21,673
(76,631)
(5,568)
(3,025)
(8,538)
13,539
(11,917)
(4,150)
(8,450)
7,463
1,629
(2,000)
(2,791)
3,059
(26,000)
(71,611)
Variance
31,605
(11,567)
2,451
6,520
3,101
(2,107)
5,742
(789)
12,911
(1,073)
(20,539)
1,521
(2,497)
(3,137)
(96)
8,199
(43,830)
(7,824)
2
(82,776)
(104,182)
100.00%
% ofAnnual
Budget Spent
99.47%
94.51%
580.21
98.65%
108.01%
120.14%
98.93%
0.00%
140.81% (h)
250.22% (h)
58.36% (i)
61.28%
64.20%
70.04%
136.20% (h)
63.16%
95.44%
75.86%
202.94%
118.30%
0.00%
92.62%
0.00%
0.00%
97.18%
(g)
0)
% of Annual
Budget Spent
101.65% (k)
87.74%
141.19%
104.52% (k)
101.95% (k)
86.65%
101.98%
19.09%
141.18%
17.43%
91.22%
152.02%
70.97%
10.37%
99.54%
118.41% (m)
56.78% (n)
47.84%
0.00%
58.61% (0)
96.83%
(I)
(m)
CITY OF TUKWILA
General Fund Expenditures - By Department
As of December 31 2013
09 - MUNICIPAL COURT
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
49 -00 Professional Services
49 -01 Pro Tem Judge
49 -03 Interpreters
49 -04 Court Security
42 COMMUNICATION
43 TRAVEL
45 OPERATING RENTALS & LEASES
48 REPAIRS & MAINTENANCE
49 MISCELLANEOUS
53 EXT TAXES & OPERATING ASSMNTS
64 MACHINERY & EQUIPMENT
MUNICIPAL COURT
10 - POLICE
11 SALARIES
12 EXTRA LABOR
13 OVERTIME
21 FICA
22 LEOFF
23 PERS
24 INDUSTRIAL INSURANCE
25 MEDICAL,DENTAL,LIFE,OPTICAL
26 UNEMPLOYMENT COMPENSATION
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
48 -00 Repair and maintenance
48 -01 800 MHZ radio assessment
49 MISCELLANEOUS
49 -00 Miscellaneous
49 -03 Explorer post
51 INTERGVRNMTL PROFESSIONAL SVCS
53 EXT TAXES & OPERATING ASSMNTS
64 MACHINERY & EQUIPMENT
POLICE
Annual Budget
666,631
2,500
5,016
50,704
57,386
2,817
116,431
11,708
4,660
105,300
800
11,000
53,000
40,500
7,300
9,215
3,058
1,300
19,270
1,063,296
Prorated
Budget
666,631
2,500
5,016
50,704
57,386
2,817
116,431
11,708
4,660
105,300
800
11,000
53,000
40,500
7,300
9,215
3,058
1,300
19,270
Actual Spent
672,406
2,214
718
49,750
56,577
2,502
129,319
19,196
26,158
95,926
5,177
11,100
40,722
38,927
6,292
6,422
1,067
3,576
15,173
1
5,721
1,063,296 1,093,017
Prorated
Annual Budget Budget Actual Spent
7,720,506 7,720,506 7,449,295
1,000 1,000 1,986
908,263 908,263 1,020,481
581,135 581,135 632,725
339,406 339,406 392,742
93,011 93,011 90,298
135,522 135,522 132,461
1,394,472 1,394,472 1,291,022
794
225,950 225,950 195,521
600 600 51
77,875 77,875 71,731
89,471 89,471 80,957
24,500 24,500 35,130
800 800 299
1,026,948 1,026,948 986,099
240,080 240,080 236,250
1,525
185,948 185,948 159,023
128,372 128,372 107,949
57,576 57,576 51,074
75,661 75,661 78,710
73,811 73,811 77,605
1,850 1,850 1,105
2,004,264 2,004,264 1,853,448
3
14,630
15,125, 412 15,125, 412 14,725,183
** Variance = Actual over (under) prorated budget Fund 000 By Dept
% of year expired
Variance
5,775
(286)
(4,298)
(954)
(809)
(315)
12,888
7,488
21,498
(9,374)
4,377
100
(12,278)
(1,573)
(1,008)
(2,793)
(1,991)
2,276
(4,098)
1
5,721
29,721
100.00%
% Annual
Budget Spent
100.87%
88.56%
14.31%
98.12%
98.59%
88.82%
111.07%
163.96%
561.32%
91.10%
647.16%
100.91%
76.83%
96.11%
86.19%
69.70%
34.88%
275.11%
78.74%
0.00%
0.00%
102.80%
% of Annual
Variance Budget Spent
96.49%
198.63%
112.36%
108.88%
115.71%
97.08%
97.74%
92.58%
0.00%
86.53%
8.57%
92.11%
90.48%
143.39% (r)
37.38%
96.02%
98.40%
0.00%
85.52%
84.09%
88.71%
104.03%
105.14%
59.73%
92.48%
0.00%
0.00%
(271,211)
986
112,218
51,590
53,336
(2,713)
(3,061)
(103,450)
794
(30,429)
(549)
(6,144)
(8,514)
10,630
(501)
(40,849)
(3,830)
1,525
(26,925)
(20,423)
(6,502)
3,049
3,794
(745)
(150,816)
3
14,630
(400,229)
(q)
(q)
(q)
(q)
97.35%
(s)
15
CITY OF TUKWILA
General Fund Expenditures - By Department
As of December 31 2013
11 - FIRE
00 HYDRANT RENTALS
11 SALARIES
12 EXTRA LABOR
13 OVERTIME
15 HOLIDAY PAY
21 FICA
22 LEOFF
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
45 OPERATING RENTALS & LEASES
46 INSURANCE
47 PUBLIC UTILITY SERVICES
48 REPAIRS & MAINTENANCE
49 MISCELLANEOUS
49 -00 Miscellaneous
49 -03 Explorer Post
49 -05 Uniform cleaning
49 -08 Credit card fees
49 -44 Education training- contract
51 INTERGVRNMTL PROFESSIONAL SVCS
64 MACHINERY & EQUIPMENT
FIRE
12 - INFORMATION TECHNOLOGY
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
49 -00 Miscellaneous
49 -01 Software upgrades
49 -03 Training
64 MACHINERY & EQUIPMENT
INFORMATION TECHNOLOGY
Annual Budget
106,000
6,322,837
670,858
194,452
89,685
275,071
28,040
170,058
1,100,605
1,500
218,277
43,845
54,000
32,170
17,000
451,686
90,000
73,360
152,304
117,874
78,083
20,791
1,000
18,000
129,354
109,000
10,447,976
Annual Budget
613,769
2,500
44,861
50,368
2,504
131,878
5,766
122,000
1,000
128,700
1,500
6,016
56,500
117,500
27,000
88,000
2,500
32,000
1,316,862
of year expired
100.00%
Prorated % of Annual
Budget Actual Spent Variance Budget Spent
106,000 103,680 (2,320) 97.81%
6,322,837 6,478,938 156,101 102.47% (t)
- 564 564 0.00%
670,858 751,655 80,797 112.04% (u)
194,452 191,359 (3,093) 98.41%
89,685 110,321 20,636 123.01% (v)
275,071 354,988 79,917 129.05% (v)
28,040 28,091 51 100.18%
170,058 155,802 (14,256) 91.62%
1,100,605 1,090,610 (9,995) 99.09%
1,500 - (1,500) 0.00%
218,277 271,109 52,832 124.20% (w)
43,845 41,455 (2,390) 94.55%
54,000 61,921 7,921 114.67%
32,170 25,755 (6,415) 80.06%
17,000 5,579 (11,421) 32.82%
451,686 548,116 96,430 121.35% (x)
90,000 94,500 4,500 105.00%
73,360 73,385 25 100.03%
152,304 56,693 (95,611) 37.22% (y)
117,874 75,203 (42,671) 63.80%
78,083 49,611 (28,472) 63.54%
325 325 0.00%
20,791 19,769 (1,022) 95.08%
1,000 887 (113) 88.69%
18,000 4,612 (13,388) 25.62%
129,354 129,354 100.00%
109,000 59,832 (49,168) 54.89% (w)
10,447,976 10,708,909 260,933 102.50%
Prorated % of Annual
Budget Actual Spent Variance Budget Spent
613,769 577,798 (35,971) 94.14% (z)
2,500 52,000 49,500 2080.00% (z)
- 2,201 2,201 0.00%
44,861 46,713 1,852 104.13%
50,368 48,276 (2,092) 95.85%
2,504 2,094 (410) 83.64%
131,878 124,172 (7,707) 94.16%
5,766 3,472 (2,294) 60.22%
122,000 116,681 (5,319) 95.64%
1,000 4,445 3,445 444.48%
128,700 106,723 (21,977) 82.92%
1,500 414 (1,086) 27.57%
6,016 6,901 885 114.72%
56,500 17,719 (38,781) 31.36% (aa)
117,500 135,747 18,247 115.53% (bb)
27,000 35,017 8,017 129.69%
88,000 99,726 11,726 113.32%
2,500 1,004 (1,496) 40.16%
32,000 - (32,000) 0.00% (cc)
1,316,862 1,245,356 (71,506) 94.57%
** Variance = Actual over (under) prorated budget Fund 000 By Dept
16
CITY OF TUKWILA
General Fund Expenditures - By Department
As of December 31 2013
13 - PUBLIC WORKS
00 UNALLOCATED BUDGET REDUCTION
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
45 OPERATING RENTALS & LEASES
47 PUBLIC UTILITY SERVICES
48 REPAIRS & MAINTENANCE
49 MISCELLANEOUS
49 -00 Miscellaneous
49 -08 Credit card fees
49 -50 Neighborhood revitalization
79 Assessment
PUBLIC WORKS
15 - PARK MAINTENANCE
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
45 OPERATING RENTALS & LEASES
47 PUBLIC UTILITY SERVICES
48 REPAIRS & MAINTENANCE
49 MISCELLANEOUS
63 OTHER IMPROVEMENTS
PARK MAINTENANCE
Annual Budget
(30,000)
1,952,152
2,000
4,556
142,157
160,100
26,176
345,324
3,800
99,550
63,750
31,400
7,750
800
172,300
379,449
203,183
17,035
10,035
2,000
5,000
% of year expired
Prorated
Budget Actual Spent Variance
(30,000) - 30,000
1,952,152 1,808,901 (143,251)
2,000 300 (1,700)
4,556 12,091 7,535
142,157 133,133 (9,024)
160,100 149,011 (11,089)
26,176 20,494 (5,682)
345,324 313,316 (32,008)
3,800 1,312 (2,488)
99,550 84,613 (14,937)
63,750 30,796 (32,954)
31,400 29,859 (1,541)
7,750 5,419 (2,331)
800 706 (94)
172,300 169,034 (3,266)
379,449 348,088 (31,361)
203,183 258,964 55,781
17,035 8,466 (8,569)
10,035 7,034 (3,001)
2,000 706 (1,294)
5,000 725 (4,275)
20,021 20,021
3,581,482 3,581,482 3,394,522 (186,960)
Prorated
Annual Budget Budget Actual Spent Variance
517,680 517,680 524,078 6,398
2,179 2,179
2,295 2,295 5,327 3,032
38,847 38,847 40,032 1,185
42,450 42,450 41,755 (695)
15,074 15,074 12,512 (2,562)
78,133 78,133 75,718 (2,415)
1,425 1,425 1,833 408
36,968 36,968 36,567 (401)
1,500 1,500 876 (624)
25,000 25,000 33,385 8,385
220 220
64 64
108,726 108,726 108,625 (101)
213,000 213,000 232,848 19,848
37,000 37,000 24,091 (12,909)
4,000 4,000 2,834 (1,166)
5,000 5,000 - (5,000)
100.00%
1,127,098 1,127,098 1,142,944 15,846
** Variance = Actual over (under) prorated budget Fund 000 By Dept
% of Annual
Budget Spent
0.00%
92.66% (dd)
15.00%
265.38% (ee)
93.65%
93.07%
78.29%
90.73%
34.53%
85.00%
48.31%
95.09%
69.93%
88.28%
98.10%
91.74%
127.45% (ff)
49.70%
70.10%
35.32%
14.50%
0.00%
94.78%
% of Annual
Budget Spent
101.24%
0.00%
232.11%
103.05%
98.36%
83.00%
96.91%
128.61%
98.91%
58.40%
133.54%
0.00%
0.00%
99.91%
109.32%
65.11%
70.85%
0.00%
101.41%
(gg)
17
CITY OF TUKWILA
General Fund Expenditures - By Department
As of December 31 2013
16 - STREET MAINTENANCE & OPERATION
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 EXT TAXES & OPERATING ASSMNTS
64 MACHINERY & EQUIPMENT
STREET MAINTENANCE & OPERATION
Annual Budget
813,107
43,723
11,474
62,459
67,840
24,133
190,012
2,375
333,100
12,431
4,000
4,300
2,700
1,500
368,887
35,455
831,565
27,100
5,200
% of year expired 100.00%
Prorated
Budget Actual Spent Variance
813,107 790,617 (22,490)
43,723 46,124 2,401
11,474 5,852 (5,622)
62,459 63,732 1,273
67,840 66,776 (1,064)
24,133 23,231 (902)
190,012 172,363 (17,649)
2,375 2,179 (196)
333,100 231,275 (101,825)
12,431 10,190 (2,241)
4,000 766 (3,234)
4,300 1,192 (3,108)
2,700 281 (2,419)
1,500 (1,500)
368,887 385,099 16,212
35,455 37,406 1,951
831,565 882,978 51,413
27,100 31,993 4,893
5,200 7,402 2,202
49 49
53,074 53,074
2,841,361 2,841,361 2,812,580 (28,781)
" Variance = Actual over (under) prorated budget Fund 000 By Dept
18
% of Annual
Budget Spent
97.23%
105.49%
51.00%
102.04%
98.43%
96.26%
90.71%
91.74%
69.43% (hh)
81.97%
19.14%
27.73%
10.41%
0.00%
104.39%
105.50%
106.18% (ii)
118.06%
142.35%
0.00%
0.00% (jj)
98.99%
CITY OF TUKWILA
General Fund Expenditures - By Department
As of December 31 2013
20 - CONTRIBUTIONS / FUND BALANCE
02 DEBT SERVICE TRANSFERS
01 TRANSFERS OUT
01 -103 Transfer to Fund 103 Street
01 -104 Transfer to Fund 104 Arterial Street
01 -105 Transfer to Fund 105 Contingency
01 -107 Transfer to Fund 107 Fire Equipmnet
01 -109 Transfer to Fund 109 Drug Seizure
01 -303 Transfer to Fund 303 Gen Gov't Improve
01 -411 Transfer to Fund 411 Golf Course
00 OTHER MISC TRANSFERS /ADJUSTMENTS
52 MPD LOANS
CONTRIBUTIONS / FUND BALANCE
Prorated
Annual Budget Budget
2,664,688 2,664,688
7,182,140 7,182,140
100,000 100,000
4,550,000 4,550,000
1,500,000 1,500,000
75,000
500,000
400,000
57,140
1,000,000
10,846,828
75,000
500,000
400,000
57,140
1,000,000
10,846,828
Actual Spent
2,940,244
6,588,919
230,000
1,650,000
4,225,000
83,919
400,000
1,250,000
10,779,163
% of year expired 100.00%
Variance
275,556
(593,221)
130,000
(2,900,000)
2,725,000
83,919
(75,000)
(500,000)
(57,140)
250,000
- 67,665
% offAnnuai
Budget Spent
110.34%
91.74%
230.00%
36.26%
281.67%
0.00%
0.00%
0.00%
100.00%
0.00%
125.00%
99.38%
(a) Council analyst position was budgeted at step 1 for budget year. Previous analyst remained in position until May 2013.
(b) Council member medical reimbursements exceeded budget.
(c) Berk Contract underspent and Neighborhood Outreach Liaison program meetings were anticipated to occur in the fall of 2013 rather than early
2014.
(d) Voter registration costs exceeded budget.
(e) Annual maintenance for Eden was budgeted in Professional Services category but charged to Repairs & Maintenance.
(f) Claims & judgments higher than anticipated due to unforeseen circumstances.
(g) Use of part- time /extra labor that qualify for PERS, however, PERS is not budgeted for these positions.
(h) Significant events during the summer increased the need for supplies and rental services.
(i) Some classes did not meet minimum number of participants so were canceled. This also canceled the need for instructors. Additionally, no
large volunteer appreciation event was held in 2013.
(j) Partial funds for the volunteer trailer were expended but didn't qualify as capital so were charged to operating GL codes.
(k) Payout for retirement, part-time increase in hours which were grant funded. FICA and PERS increased respectively.
(I) King County recycling grant budgeted for $4K, spent $11K. Revenue received corresponds to funds spent.
(m) Software support charged to Repairs & Maintenance rather than Professional Services category.
(n) Abatement costs under budget by $43K.
(o) TRAKiT expenditures of $50K were budgeted to capital but charged to other operating GL accounts.
(p) Received grant to purchase computer for $4.7K, also purchased furniture and reconfiguration of front office.
(q) Difficulty in hiring staff therefore needed to use overtime until staff could be hired.
(r) Additional costs for recruitment of new officers. Costs were associated with background checks.
(s) Jail costs were over budgeted allowing for $100K of King County services that were not needed and not used.
(t) Primarily acting pay due to backfilling positions due to vacancies. Also had one payout.
(u) Overtime is higher than budget due to backfilling positions during temporary promotions, vacancies, and several staff out on injuries.
(v) Both FICA and LEOFF are over budget due to both salaries and overtime being over budget.
(w) Air packs were rebuilt rather than purchasing new; costs were charged to supplies rather than capital. This extended the life by approximately
5 years.
(x) Suppression O &M adjusted to reflect actual costs by $75K, other O &M adjusted for actuals.
(y) Repairs on saws, MDCs, extrication equipment, etc. was lower than anticipated.
(z) Extra labor was due to vacancy in the IT department. Because the vacancy was not immediately filled, it also caused Salaries to be under
budget.
(aa) Items budgeted to repair but charged to either professional services or misc category.
(bb) Microsoft licenses reclassified to Miscellaneous category from Capital.
(cc) No capital items purchased in 2013.
(dd) Time spent on projects in other funds over what was originally budgeted.
(ee) Overtime is required for private development permits for utility work. Work done at night is reimbursed by developer or utility company.
(ff) Overage is due to repairs needed for aging facilities with heating/AC, roof repairs, etc.
(gg) Utility charges reflect actual usage and is related to Spray Park at TCC.
(hh) Operating supplies are budgeted based on anticipated accidents that could happen that damage City property. Less accidents occurred than
anticipated.
(ii) Additional streetlights along SC Pkwy and rate increases from both Puget Sound Energy and Seattle City Light.
(jj) 2 traffic control devices were purchased some of the excess operating supplies budget. This went to Council on 11/18/13 for approval.
** Variance = Actual over (under) prorated budget Fund 000 By Dept
19
City of Tukwila
Hotel/Motel Tax Fund 101 - Revenue and Expenditures
As of December 31 2013
% of year expired
100.00%
2013
Prorated Actual
Annual Budget Budget Year - To-Date
Variance **
% of Annual
Budget
Revenue
General Revenue
HoteVMotel Taxes
Total General Revenue
Intergovernmental Revenue
Sea Tac Base Costs
Sea Tac Joint Media Costs
Kent Costs
Des Moines Costs
Community Services -Sea Tac 100%
Miscellaneous Revenue
Investment Eamings
Other Misc Revenue
Total Miscellaneous Revenue
Total Revenue
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
Indirect cost allocation
Total Expenditures
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
Cash and investments
$ 538,000 $
538,000
898,000
350,000
165,000
60,000
18,000
305,000
1,766
12,000
13,766
1,449,766
293,878
45,000
4,110
22,243
24,100
1,252
38,867
29,063
161,000
76,100
23,000
657,800
51,741
1,500
1,000
35,400
10,000
1,476,054
98,128
1,574,182
(124,416)
650,000
$ 525,584 $
538,000
538,000
898,000
350,000
165,000
60,000
18,000
305,000
1,766
12,000
13,766
1,449,766
293,878
45,000
4,110
22,243
24,100
1,252
38,867
29,063
161,000
76,100
23,000
657,800
51,741
1,500
1,000
35,400
10,000
1,476,054
98,128
1,574,182
(124,416)
650,000
525,584
$ 526,832
526,832
882,810
655,000
147,988
60,000
19,822
933
21,708
22,641
1,432,282
278,463
27,983
4,542
23,790
24,983
1,484
31,610
28,987
146,764
88,346
13,347
571,616
47,059
900
41,979
1,331,852
96,191
1,428,043
4,239
710,707
$ 714,946
$ 537,454
(a) $9K of the miscellaneous expenditure line item is for membership dues in various organizations.
** Variance = Actual over (under) prorated budget Fund 101
20
(11,168) 97.92%
(11,168) 97.92%
(15,190) 98.31%
305,000 187.14%
(17,012) 89.69%
100.00%
1,822 110.12%
(305,000) 0.00%
(833) 52.81%
9,708 180.90%
8,875 164.47%
(17,484) 98.79%
(15,415) 94.75%
(17,017) 62.18%
432 110.51%
1,547 106.96%
883 103.67%
232 118.51%
(7,257) 81.33%
(76) 99.74%
(14,236) 91.16%
12,246 116.09%
(9,653) 58.03%
(86,184) 86.90%
(4,682) 90.95%
(600) 59.98%
(1,000) 0.00%
6,579 118.58%
(10,000) 0.00%
(144,202) 90.23%
(1,937) 98.03%
(146,139) 90.72%
128,655 -3.41%
60,707 109.34%
$ 189,362 136.03%
City of Tukwila
Street Fund 103 - Revenue and Expenditures
As of December 31 2013
% of year expired 100.00%
2013
Prorated Actual % of Annual
Annual Budget Budget Year -To -Date Variance "' Budget
Revenue
Intergovernmental Revenue $ 443,000 $ 443,000 $ 321,625 $ (121,376) 72.60%
Dept of Transportation - Thomdyke - - 21,875 21,875 0.00%
State Grant - Cascade View 133,000 133,000 30,252 (102,748) 22.75%
State Grant - Thomdyke 48,000 48,000 - (48,000) 0.00%
MVFT Cities 262,000 262,000 269,498 7,498 102.86%
Miscellaneous Revenue
Investment Eamings
Total Miscellaneous Revenue
Transfers In
1,000 1,000 1,763 763 176.28%
1,000 1,000 1,763 763 176.28%
100,000 100,000 230,000 130,000 230.00% (a)
Total Revenue
544,000 544,000 553,387 9,387 101.73%
Expenditures
11 Salaries
21 FICA
23 PERS
24 Industrial Insurance
25 Medical, Dental, Life, Optical
41 Professional Services
64 Capital Outlay
Total Streets Fund
13,539 13,539 0.00%
1,014 1,014 0.00%
1,156 1,156 0.00%
147 147 0.00%
990 990 0.00%
359,000 359,000 167,358 (191,642) 46.62% (b)
78,000 78,000 - (78,000) 0.00% (b)
437,000 437,000 184,203 (252,797) 42.15%
437,000 437,000 184,203 (252,797) 42.15%
Total Expenditures
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
Cash and investments
107,000 107,000 369,184 262,184 345.03%
1,000,000 1,000,000 1,046,771 46,771 104.68%
1,107,000 $ 1,107,000 $ 1,415,955 $ 308,955 127.91%
(a) $130K transfer in was a transfer delayed from 2012.
$ 1,359,905
(b) 42nd Ave S Phase III is still in design with 50% of design funds carried into 2014, Cascade View Safe Routes to School construction will be
carried over into 2014, and Thomdyke Safe Routes to School project is in design phase.
Variance = Actual over (under) prorated budget Fund 103
21
City of Tukwila
Arterial Street Fund 104 - Revenue and Expenditures
As of December 31 2013 % of year expired 100.00%
2019
Prorated Actual %ofAnntml
Amaral Budget Budget Year - To-Date Variance" Budget
Revenue
General Revenue
Parking Taxes $ 151,000 $ 151,000 $ 155,860 $ 4,860 103.22%
Real Estate Excise Taxes 130,000 130,000 193,700 63,700 149.00%
Total General Revenue 281,000 281,000 349,560 68,560 124.40%
Charges for Services
Traffic & Park Impact Fees 270,446 270,446 0.00%
Total Charges for Services - 270,446 270,446 0.00%
Intergovernmental Revenue 2,540,000 2,540,000 1,545,665 (994,335) 60.85% (a)
Dept of Transportation - Tukwila 9,121 9,121 0.00%
Fed Grant -Tuk Urb Ctr -Ped 878,000 878,000 301,647 (576,353) 34.36%
Boeing Access Bridge - - 108,511 108,511 0.00%
Fed Grant - Overlay & Repair EMW 1,000,000 1,000,000 383 (999,617) 0.04%
State Grant- TIB PH III 2,634 2,634 0.00%
WSDOT Reg Mobility Grant -Trans 550,000 550,000 995,373 445,373 180.98%
State Grant -APW - - 1,174 1,174 0.00%
MVFT Cities 112,000 112,000 126,822 14,822 113.23%
Miscellaneous Revenue
Investment Earnings 3,820 3,820 5,650 1,830 147.92%
Contributions /Donations 272,000 272,000 306,593 34,593 112.72%
LID Prepayments - - 2,788,350 2,788,350 0%
Total Miscellaneous Revenue 275,820 275,820 3,100,593 2,824,773 1124.14%
Transfer In 4,550,000 4,550,000 1,650,000 (2,900,000) 36.26%
Prior Period Revenue 413,321 413,321 0.00%
LID Debt Proceeds 8,500,000 8,500,000 6,018,750 (2,481,250) 70.81% (b)
Total Revenue 16,148,820 16,148,820 13,348,335 (2,798,485) 82.67%
Expenditures
11 Salaries 214,104 214,104 349,178 135,074 163.09% (c)
12 Extra Labor 6,360 6,360 0.00%
13 Overtime - 150 150 0.00%
21 FICA 15,951 15,951 26,538 10,587 166.37%
23 PERS 17,556 17,556 29,124 11,568 165.89%
24 Industrial Insurance 626 626 2,417 1,791 386.08% (d)
25 Medical, Dental, Life, Optical 26,188 26,188 44,502 18,314 169.93%
31 Office & Operating Supplies - 394 394 0.00%
41 Professional Services 2,493,000 2,493,000 1,306,525 (1,186,475) 52.41% (e)
42 Communication 35 35 0.00%
43 Travel 345 345 0.00%
44 Advertising - 3,228 3228 0.00%
45 Operating Rentals & Leases - 1,027 1,027 0.00%
47 Public Utility Services - 1,574 1,574 0.00%
48 Repairs & Maintenance 42,594 42,594 0.00%
49 Miscellaneous - - 22,751 22,751 0.00%
64 Capital Outlay 2,548,000 2,548,000 2,194,528 (353,472) 86.13% (e)
80 Debt Service Principal - - 49,140 49,140 0.00%
81 Debt Service Interest and costs 155,719 155,719 0.00%
Total Arterial Streets 104 5,315,425 5,315,425 4,236,131 (1,079,294) 7970%
Transfers Out 8,500,000 8,500,000 8,500,000 - 100.00% (b)
Total Expenditures 13,815,425 13,815,425 12,736,131 (1,079,294) 92.19%
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
2,331,395 2,331,395 612,204 (1,719,191) 26.26%
450,000 450,000 483,330 33,330 107.41%
$ 2,781,395 $ 2,781,395 $ 1,095,534 $ (1,685,8861) 39.39%
Cash and investments $ 1,167,156
(a) 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. Bonds were sold in November 2013.
Once LID proceeds were received, most of the proceeds will be transferred into the general fund.
(c) Salary and benefit costs are related to the Southcenter Parkway project and LID. Project has been closed out.
(d) Budget of $626 is for two administrative personnel. However, personnel working on projects are budgeted in other funds but charged to
fund 104 for specific project work. Their industrial insurance rate is substantially higher than administrative personnel.
(e)
Boeing Access Rd over BNRR Bridge Rehab is under design late in the year, Tukwila Urban Center - Ped/Bike Bridge and Overlay &
Repair - E Marginal Way S is under design. TUC - Transit Center and Andover Pk W (Tukwila Pkwy - Strander Blvd) is under design with
Council approved the bid in November with construction in 2014..
Variance = Actual over (under) prorated budget Fund 104
22
City of Tukwila
Fund 104 Arterial Streets
As of December 31, 2013
PROJECT
PROJECT DESCRIPTION
10901301 Howard Hanson Dam Flood Response
90310402 Interurban Ave S
90510403 TUC Pedestrian /Bicycle Bridge 878,000
90610402 TUC Transit Center 550,000
90810406 Transportation Element Comp Plan
91210401 2012 Overlay & Repair
91210405 ADA Improvements
91210406 Overlay & Repair E Marginal Wy S 1,000,000
91310401 2013 Overlay & Repair
91310402 2013 Bridge Inspections
91310404 Annual Traffic Signals 2013
91310406 Tukwila MIC Smart Street Non - Motorized
91310407 Boeing Access Bridge over Airport Way
91410401 2014 Overlay & Repair
98410419 Tukwila Urban Center Access (Klickitat)
98410437 Southcenter Pkwy Extension
98610403 Strander Blvd Extension
98810404 Andover Park W (Tuk Pk - Strander)
99410408 Boeing Access Rd Bridge Rehabilitation
99510404 Tukwila Int'l Blvd Phase III
99110405 Andover Park E/Industry Dr Intersection
90310405 Andover Park e/Minkler Blvd Intersection
99310410 West Valley Hwy /S 156 St Intersection
99510402 S 144 St Phase II (42nd Ave S -TIB)
99510405 S 133 SUSR599 Southbound Intersection
90610405 Macadam Rd & S 144th St Intersection
91310403 Traffic Counts 2013
11100301 Public Records Request
11000300 Tukwila South Project Annual Bill
Totals $ 2,428,000 1 $ 1,674,289 1 $ (753,711)
- -- PROJECT REVENUE - - -- I -- PROJECT EXPENDITURES
I Actual YTD I Over (under) 1 ACTUAL YTD 12 -31 -13 I Over (under)
fi Budget
12 -31 -13 ! Budget 1 BUDGET • Staff Time Other
I $ - II $ - 1 $ 217 $ -
' 400,000 ' 22,645 555,780
361,258 I (516,742) (a) ! 1,171,000 ! 20,791 316,800
995,3731 445,373 i 6,130,0001 51,614 1,043,461
- 1 - i - � 12,842
' 1,450,000 , 1,899
- I - • 163,0001 1,947 28,757
383 (999,617) ; 1,475,000 ; 9,516 119,573
- - - 1,942 30,863
1 1 275,0001 19,138 56,282
- - 150,000 - 115,876 188
9,121 I 9,121 1 - . 2,668 7,
16,727
- - - 1 1 - 1 261 14,894
21,177 260,646
195,836 , 195,836 (a) 1 - , 106,010 992,186
- 1 - - 1 41 1,574
1,174 � 1,174 1,840,000 � 21,564 80,539
108,511 , 108,511 1,400,000 , 59,348 89,904
2,6341 2,634 - 1 -
- 1 + 100,000 ;
- 1 75,000 .
1 75,0001
1 68,000
20,000 '
1 1 17,000 ! -
1 i - I 450
i ; i 110
- 528
� $14,809,000J $354,709 $ 3,731,050
Other Revenue:
Parking Taxes
Real Estate Excise Taxes
Park Impact Fees
Traffic Impact Fees
MVFT Cities
Investment Eamings
Contributions /Donations
Transfers In
LID Prepayments
LID Debt Proceeds
Total Other Revenue
Total Revenue Fund 104
Budget Actual YTD
$ 151,000 I $ 155,860
130,000 ; 193,700 ;
19,907
- ! 190,9271
112,000 1 126,822
3,820 ' 81,157 '
272,000 , 35,250 �(b)
4,550,000 1 2,300,000 I
- 2,788,350
8,500,000 , 6,018,750 ,
13,718,820 1 11, 910, 724 1
;$16,146.820i$13.585.013j
Total Budget
$ 217 r$ 217 1
578,425 ' 178,425 '
337,591 ! (833,409)!
1,095,075 i (5,034,925)1
12,842 , 12,842
1,899 i (1,448,101),
30,704 , (132,296)1
129,089 (1,345,911)1
32,805. 32,805
75,420 � (199,580)1
115,188 : (34,812)1
10,544 10,544
16,727 ' 16,727 !
15,155 1 15,155 1
281,823 ; 281,823'
1,098,196 1 1,098,196 ,
1,615 ; 1,615 1
102,1031 (1,737,897)1
149,252 ; (1,250,748),
-
(100,000)
- 1 (75,000).
(75,000)1
1
(68,000)1
(20,000)'
I
(17,000)!
450 ' 450 1
110, 110'
528 ' 528 ,
$ 4,085,759 , $(10,723,241)J
(a) Includes $60K of park impact fees
(b) Developer agreement recorded in Contributions/Donations category in fund 104 statement. $195,836 is allocated to the Southcenter Pkwy Extension project.
23
City of Tukwila
Contingency Fund 105 - Revenue and Expenditures
As of December 31 2013
% of year expired 100.00%
2013
Prorated Actual
Annual Budget Budget Year- To-Date
Variance **
°% of Annual
Budget
Revenue
Miscellaneous Revenue
Investment Eamings $ 1,816 $ 1,816 $ 2,477 $ 661 136.40%
Total Miscellaneous Revenue 1,816 1,816 2,477 661 136.40%
Transfers In 1,575,000 1,575,000 4,300,000 2,725,000 273.02% (a)
Total Revenue 1,576,816 1,576,816 4,302,477 2,725,661 272.86%
Change in Fund Balance 1,576,816 1,576,816 4,302,477 2,725,661 272.86%
Beginning Fund Balance 1,500,000 1,500,000 1,460,454 (39,546) 97.36%
Ending Fund Balance $ 3,076,816 $ 3,076,816 $ 5,762,931 $ 2,686,115 187.30%
Cash and investments $ 5,762,932
(a) Transfer from general fund to contingency occurred upon receipt of LID bond proceeds.
" Variance = Actual over (under) prorated budget Fund 105
24
City of Tukwila
Fire Equipment Cum. Reserve 107 - Revenue and Expenditures
As of December 31 2013
% of year expired 100.00%
2013
Prorated Actual %of Annual
Annual Budget Budget Year - To-Date Variance'* Budget
Revenue
Intergovernmental Revenue
Miscellaneous Revenue
Investment Eamings
Total Miscellaneous Revenue
52,698 52,698 0.00%
$ 1,311 $ 1,311 0.00%
1,311 1,311 0.00%
Transfers In 83,919 83,919 0.00%
Total Revenue 137,928 137,928 0.00%
Expenditures
Total 0.00%
Transfer Out 1,030,000 1,030,000 1,030,000 100.00%
Total Expenditures 1,030,000 1,030,000 1,030,000 100.00%
Change in Fund Balance (1,030,000) (1,030,000) (892,072) 137,928 86.61%
Beginning Fund Balance 1,030,000 1,030,000 892,072 (137,928) 86.61%
Ending Fund Balance $ $ $ (0) $ (0) 0.00% (a)
Cash and investments $
(a) The balance of this fund has been moved to Fund 501 - Equipment Rental and Replacement and allocated to the aerial ladder truck
replacement
" Variance = Actual over (under) prorated budget Fund 107
25
96,000 96,000 61,213 (34,787) 63.76%
City of Tukwila
Drug Seizure Fund 109 - Revenue and Expenditures
As of December 31 2013
% of year expired 100.00%
2013
Prorated Actual % of Annual
Annual Budget Budget Year -To -Date Variance " Budget
Revenue
Miscellaneous Revenue
Investment Eamings
Seizure Revenue
Total Miscellaneous Revenue
Transfers In
$ 1,000 $ 1,000 $ - $ (1,000) 0.00%
20,000 20,000 61,213 41,213 306.07%
21,000 21,000 61,213 40,213 291.49%
75,000 75,000 (75,000) 0.00%
Total Revenue
Expenditures
31 Office & Operating Supplies 3,000 3,000 - (3,000) 0.00%
35 Small Tools & Minor Equipment - 1,541 1,541 0.00%
41 Professional Services 10,000 10,000 30,000 20,000 300.00%
43 Travel - 5,268 5,268 0.00%
45 Operating Rentals & Leases 10,000 10,000 (10,000) 0.00%
49 Miscellaneous 2,000 2,000 3,920 1,920 196.00%
51 Intergovernmental Prof Svcs 30,000 30,000 30,000 - 100.00%
Total Drug Seizure Fund 55,000 55,000 70,729 15,729 128.60%
Transfer Out
Total Expenditures
Change in Fund Balance
Beginning Fund Balance
75,000 75,000 75,000 100.00%
130,000 130,000 145729 15,729 112.10%
(34,000) (34,000) (84,516) (50,516) 248.58%
280,000 280,000 160,125 (119,875) 57.19%
Ending Fund Balance
246,000 t $ 246,000 $ 75,609 $ (170,391) 30.74%
Cash and investments
** Variance = Actual over (under) prorated budget Fund 109
26
$ 75,609
City of Tukwila
Debt Service Funds 2XX - Revenue and Expenditures
As of December 31 2013
% of year expired
100.00 %s
2013
Prorated
Annual Budget Budget
Actual
Year - To-Date
Variance "
% of Annual
Budget
Revenue
Build America Bonds Tax Credit
Miscellaneous Revenue
Investment Eamings
Capital Contributions
Total Miscellaneous Revenue
Transfers In
Total Revenue
Expenditures
80 Debt Service Principal
81 Debt Service Interest/Misc Fees
Total Debt Service Funds
Transfers Among Debt Service Funds
Total Expenditures
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
Cash and investments
$ 66,657
680,000
2,664,688
3,411,345
4,926,000
1,105,031
6,031,031
$ 66,657
6,031,031
(2,619,686)
3,308,000
688,314 $
$ 61,358
28,911
36,000
680,000 733,661
2,664,688 3,019,329
3,411,345 3,814,347
4,926,000 5,024,991
1,105,031 1,123,633
6,031,031 6,148,623
995
6,031,031 6,149,618
(2,619,686) (2,335,271)
3,308,000 3,012,381
688,314 $ 677,110
$ 678,665
$ (5,299)
28,911
36,000
53,661
354,641
403,002
98,991
18,602
117,592
995
118,587
284,415
(295,619)
92.05% (a)
0.00%
0.00%
107.89%
113.31%
111.81%
102.01% (b)
101.68%
101.95%
0.00%
101.97%
89.14%
91.06%
98.37%
(11,204)
(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 reduced the tax credit by 8.7% or $5K.
(b) Principal due for most bonds is in December of each year. Includes the early retirement of $2.7M for the LTGO 2003 bonds.
" Variance = Actual over (under) prorated budget Fund 2XX
27
City of Tukwila
Land Acquisition, Rec and Park Development Fund 301 - Revenue and Expenditures
As of December 31 2013
% of year expired 100.00%
2013
Prorated Actual % of Annual
Annual Budget Budget Year - To-Date Variance** Budget
Revenue
General Revenue
Excess Prop Tax Levy -Dwmsh Hill $ 34,000 $ 34,000 $ 33,566 $ (434) 98.72%
Real Estate Excise Taxes 130,000 130,000 194,935 64,935 _ 149.95%
Total Genera/ Revenue 164,000 164,000 228,501 64,501 139.33%
Charges for Services
Park Impact Fees 60,000 60,000 25,661 (34,339) 42.77%
Total Charges for Services 60,000 60,000 25,661 (34,339) 42.77%
Intergovernmental Revenue 915,000 915,000 271,562 (643,438) 29.68% (a)
Miscellaneous Revenue
Investment Earnings 10,000 10,000 1,904 (8,096) 19.04%
Rents and Concessions - - - - 0.00%
Total Miscellaneous Revenue 10,000 10,000 1,904 (8,096) 19.04%
Total Revenue 1,149,000 1,149,000 527,627 (621,373) 45.92%
Expenditures
11 Salaries
21 FICA
23 PERS
24 Industrial Insurance
25 Medical, Dental, Life, Optical
41 Professional Services
43 Travel
44 Advertising
48 Repairs & Maintenance
64 Capital Outlay
Total Park Acquisition Fund
Total Expenditures
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
Cash and investments
15,844 15,844 0.00%
1,190 1,190 0.00%
1,310 1,310 0.00%
44 44 0.00%
2,198 2,198 0.00%
952,000 952,000 299,287 (652,713) 31.44% (b)
12 12 0.00%
400 400 0.00%
5,183 5,183 0.00%
170,000 170,000 72,459 (97,541) 42.62% (b)
1,122,000 1,122,000 397,926 (724,074) 35.47%
1,122,000 1,122,000 397,926 (724,074) 35.47%
27,000 27,000 129,702 102,702 480.38%
1,000,000 1,000,000 1,090,187 90,187 109.02%
$ 1,027,000 $ 1,027,000 $ 1,219,889 $ 192,889 118.78%
$ 1,159,366
(a) Grant revenue is tied to projects and invoiced to grantors after project funds are expended. Grants budgeted include DHP $515K. Duwamish
Gardens $350K, and Duwamish Gardens Acquisition $50K. Grant for DHP went to CAP in 4th quarter.
(b) Duwamish Gardens project and Parks, Recreation and Open Space Plan are both in design phase.
" Variance = Actual over (under) prorated budget Fund 301
28
City of Tukwila
Fund 301 Land Acquisition, Rec and Park Development
As of December 31, 2013
PROJECT
PROJECT DESCRIPTION
81330101 Parks, Recreation & Open Space Plan
90030104 WRIA 9 Watershed Planning
90330109 Duwamish Hill Preserve
90510403 TUC Pedestrian/Bicycle Bridge
90630102 Duwamish Gardens
91030101 TCC Spray Park Sewer Connection
99830106 Codiga Park
90330107 Fort Dent Park
90730101 Black River Trail Connector
- - -- PROJECT REVENUE - - --
i Actual YTD i Over (under) 1
Budget 1 12-31 -13 1
$ $
-
624,000 i
350,000
I
_ I
-
59,226
271,562
- I
_ I
_ I
PROJECT EXPENDITURES
Budget BUDGET
I$
(564,774) (s) I
(78,438) I
Totals I $ 974,000 l $ 330,788 j $ (643,212)
Other Revenue:
Real Estate Excise Taxes
Park Impact Fees
Investment Eamings
Rents and Concessions
Total Other Revenue
Total Revenue Fund 301
(a) Excess property tax levy
Budget Actual YTD
$ 130,000 ! $ 194,935 i
1 35,0001 - 1
i 10,000 i 1,904 i
1 175,000 1 196,839 1
i $ 1,149,000 j $ 527,627 i
1 ACTUAL YTD 12-31 -13
Staff Time Other Total
100,000 , $ 210 $ 80,367 $ 80,577
12,0001 - 11,175 11,175
610,000 i 11,861 11,861
350,0001 20,930 201,478 222,408
72,459 72,459
27,000. -
23,0001 - -
1 122 000 $ 21,140 $ 377,340 $ 398,480
Over (under)
Budget
1 $ (19,423);
(825)1
(598,139)i
(127,592)!
-
72,459
(27,000).
(23, 000)1
723 520
29
City of Tukwila
Facility Replacement Fund 302 - Revenue and Expenditures
As of December 31 2013
% of year expired 100.00%
2013
Prorated Actual % of Annual
Annual Budget Budget Year - To-Date Variance** Budget
Revenue
Miscellaneous Revenue
Investment Eamings $ 5,602 $ 5,602 $ 3,373 $ (2,229)
Total Miscellaneous Revenue 5,602 5,602 3,373 (2,229)
60.22%
60.22%
Total Revenue 5,602 5,602 3,373 (2,229) 60.22%
Expenditures
11 Salaries 1,707 1,707 0.00%
21 FICA 129 129 0.00%
23 PERS - 145 145 0.00%
24 Industrial Insurance 21 21 0.00%
25 Medical, Dental, Life, Optical 70 70 0.00%
31 Office & Operating Supplies - 446 446 0.00%
41 Professional Services 508,000 508,000 94,349 (413,651) 18.57% (a)
44 Advertising - 636 636 0.00%
47 Public Utility Services 8,500 8,500 8,481 (19) 99.78%
48 Repairs & Maintenance 1,500 1,500 224 (1,276) 14.97%
49 Miscellaneous - 82 82 0.00%
64 Capital Outlay 72,000 72,000 (72,000) 0.00% (a)
Total Expenditures 590,000 590,000 106,291 (483,709) 18.02%
Total Expenditures 590,000 590,000 106,291 (483,709) 18.02%
Change in Fund Balance (584,398) (584,398) (102,918) 481,480 17.61%
Beginning Fund Balance 2,000,000 2,000,000 2,005,520 5,520 100.28%
Ending Fund Balance $ 1,415,602 4 1,415,602 $ 1,902,602 $ 487,000 134.40%
Cash and investments $ 2,005,539
(a) City facility needs assessment contract was approved at the June 3, 2013 C.O.W. meeting.
** Variance = Actual over (under) prorated budget Fund 302
30
City of Tukwila
General Government Improvements 303 - Revenue and Expenditures
As of December 31 2013
% of year expired 100.00%
2013
Prorated Actual % of Annual
Annual Budget Budget Year -To -Date Variance " Budget
Revenue
Intergovemmental Revenue $ 722,000 $ 722,000 $ 231,473 $ (490,527) 32.06% (a)
Miscellaneous Revenue
Investment Eamings 842 842 743 (99) 88.23%
Total Miscellaneous Revenue 842 842 743 (99) 88.23%
Transfers In 500,000 500,000 (500,000) 0.00% (b)
Total Revenue 1,222,842 1,222,842 232,216 (990,626) 18.99%
Expenditures
11 Salaries 100,374 100,374 77,799 (22,575) 77.51%
13 Overtime 1,240 1,240 0.00%
21 FICA 7,665 7,665 6,024 (1,641) 78.59%
23 PERS 8,234 8,234 6,494 (1,740) 78.87%
24 Industrial Insurance 313 313 494 181 157.78%
25 Medical, Dental, Life, Optical 13,351 13,351 12,231 (1,120) 91.61%
28 Uniform Clothing - - 139 139 0.00%
31 Office & Operating Supplies 5,215 5,215 0.00%
35 Small Tools & Minor Equipment - - 8,024 8,024 0.00%
41 Professional Services 20,000 20,000 60,414 40,414 302.07% (c)
48 Repairs & Maintenance - - 51,333 51,333 0.00% (d)
49 Miscellaneous - 2,906 2,906 0.00%
64 Capital Outlay 1,180,000 1,180,000 383,890 (796,110) 32.53% (e)
Total Gen Govemment Improve 1,329,937 1,329,937 616,203 (713,734) 46.33%
Transfers Out
Total Expenditures
Change in Fund Balance
Beginning Fund Balance
78,089 78,089 0.00% (f)
1,329,937 1,329,937 694,292 (635,645) 52.20%
(107,095) (107,095) (462,076) (354,981) 431.46%
900,000 900,000 913,830 13,830 101.54%
Ending Fund Balance
$ 792,905 $ 792,905 $ 451,754 $ (341,151) 56.97%
Cash and investments $ 516,311 .
(a) Grant revenue is tied to projects and invoiced to grantors after project funds are expended.
(b) Transfers in are done on an as- needed basis.
(c) Just under $52k in professional services is related to the Hesco removal project.
(d) 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.
(e) Funds spent are continuation of the project to televise Council meetings. Of the total capital budget of $1,180M, $1M is for Tukwila
Levee repairs & maintenance. Additionally, the HHD Removal project came in under budget.
(f) Unused 2010 GO bond proceeds transferred to debt service fund to pay principal and interest.
** Variance = Actual over (under) prorated budget Fund 303
31
City of Tukwila
Fund 303 General Government Improvements
As of December 31, 2013
PROJECT PROJECT DESCRIPTION 1 - - -- PROJECT REVENUE - - -- 1 [ PROJECT EXPENDITURES 1
1 Actual YTD Over (under) I ACTUAL YTD 12 -31 -13 ; Over (under)1
Budget ' 12 -31 -13 Budget BUDGET 'Staff Time Other Total ' Budget
10901301 Howard Hanson Dam Flood Response I $ 722,000 $ 231,281 $ (490,719) I 1,000,000 37,221 320,789 358,010 I (641,990)1
11030301 2010 MINOR HOME REPAIR I 192 I 192. ; I - - I
Facility Improvements I - � I 200,000 14,763 134,560 149,324 I (50,676)
90730302 City Hall Campus Wayfinding • 216 1,227 1,443
90730303 George Long Water /Oil Separator I - I - I M I 616 616 I I
•
91130303 6300 Bldg Fire Alarm System 1 - I ' I - - I
91130304 Fire Station 51 Fence & Rolling Gate - - - 1,625 1,625
91230306 Televising City Council Meetings - 4,752 61,757 66,509
91330301 6300 Bldg Interior Wayfinding Signage - 1 - I I 361 - 361 I
91330309 Heritage Center 2013 Alarm Upgrade I I - 1 ( 1 1,996 11,732 13,728 1 I
91330311 TCC Fire Alarm Repair /Upgrade - ' 2,334 23,862 26,196 I
91330312 Fire Marshall Office 6300 Bldg Ste 115 I - (I 2,574 1,824 4,398 1
91330313 General Facility Improvements 1 I - I - 1,576 1,576 : I
91330304 Mayor's Office Remodel I 1 ! - 1,914 30,957 32,871 1
Totals ! $ 722,000 ! $ 231,473 ' $ 490,527 ! $1,200,000 ! $ 51,984 $455,349 $507,334 ! $ (692 666)!
32
Other Revenue: ! Budget Actual YTD I
Investment Eamings 1 $ 842 i $ 743 1
Transfers In 500,000 � - �
Miscellaneous , - -
Total Other Revenue I 500,842 1 743 1
Total Revenue Fund 303 ; $ 1,222,842 ; $ 232,216 j
City of Tukwila
Fire Impact Fees 304 - Revenue and Expenditures
As of December 31 2013
of year expired 100.00%
2013
Prorated Actual % of Annual
Annual Budget Budget Year - To-Date Variance " Budget
Revenue
Charges for Services
Fire Impact Fees $ 50,000 $ 50,000 $ 139,714 $ 89,714 279.43%
Total Charges for Services 50,000 50,000 139,714 89,714 279.43%
Investment Eamings 100 100 581 481 580.99%
Total Miscellaneous Revenue 100 100 581 481 580.99%
Total Revenue 50,100 50,100 140,295 90,195 280.03%
Expenditures
80 Debt Service Principal 55,000 55,000 51,083 (3,917) 92.88%
Total Expenditures 55,000 55,000 51,083 (3,917) 92.88%
Change in Fund Balance (4,900) (4,900) 89,212 94,112 - 1820.66%
Beginning Fund Balance 300,000 300,000 348,010 48,010 116.00%
Ending Fund Balance $ 295,100 $ 295,100 $ 437,222 $ 142,122 148.16%
Cash and investments $ 437,222
" Variance = Actual over (under) prorated budget Fund 304
33
2013
Prorated Actual % of Annual
Annual Budget Budget Year - To-Date Variance" Budget
City of Tukwila
Water Fund 401 - Revenue and Expenditures
As of December 31 2013
% of year expired 100.00%
Revenue
Charges for Services
Water Sales $ 5,228,000 $ 5,228,000 $ 5,747,418 $ 519,417.90 109.94% (a)
Security 1,000 1,000 315 (685) 31.50%
Total Charges for Services 5,229,000 5,229,000 5,747,733 518,733 109.92%
Miscellaneous Revenue
Investment Earnings 6,700 6,700 15,500 8,800 231.34%
Capital contributions 672 672 0.00%
Connection Fees 50,000 50,000 83,104 33,104 166.21% (b)
Other Misc Revenue 300 300 480 180 160.00%
Total Miscellaneous Revenue 57,000 57,000 99,756 42,756 175.01%
Sale of Capital Assets (1,446) (1,446) 0.00%
Transfers In Hydrant Rental 106,000 106,000 103,680 (2,320) 97.81%
Total Revenue 5,392,000 5,392,000 5,949,723 557,723 110.34%
Expenses
11 Salaries 572,435 572,435 563,676 (8,759) 98.47%
12 Extra Labor 6,000 6,000 - (6,000) 0.00%
13 Overtime 5,738 5,738 6,505 767 113.36%
21 FICA 43,634 43,634 42,982 (652) 98.51%
23 PERS 46,940 46,940 46,234 (706) 98.50%
24 Industrial Insurance 14,235 14,235 12,134 (2,101) 85.24%
25 Medical, Dental, Life, Optical 123,273 123,273 114,000 (9,273) 92.48%
28 Uniform Clothing 1,330 1,330 1,392 62 104.66%
31 Office & Operating Supplies 92,839 92,839 112,711 19,872 121.40%
33 Water Purchased for Resale 2,195,596 2,195,596 2,333,276 137,680 106.27% (a)
35 Small Tools & Minor Equipment 11,000 11,000 7,893 (3,107) 71.75%
41 Professional Services 270,300 270,300 101,917 (168,383) 37.70%
42 Communication 2,500 2,500 218 (2,282) 8.72%
43 Travel 1,500 1,500 86 (1,414) 5.71%
44 Advertising - - 54 54 0.00%
45 Operating Rentals & Leases 116,809 116,809 144,837 28,028 123.99%
46 Insurance 21,000 21,000 21,656 656 103.12%
47 Public Utility Services 23,000 23,000 22,146 (854) 96.29%
48 Repairs & Maintenance 3,000 3,000 10,458 7,458 348.60% (c)
49 Miscellaneous 35,200 35,200 33,339 (1,861) 94.71%
53 Excise Taxes 184,000 184,000 254,633 70,633 138.39% (d)
54 Interfund utility taxes 534,000 534,000 561,931 27,931 10523%
64 Capital Outlay 1,237,000 1,237,000 22,443 (1,214,557) 1.81% (e)
80 Debt Service Principal 460,181 460,181 462,394 2,213 100.48%
81 Debt Service lnterest 83,852 83,852 76,063 (7,789) 90.71%
00 Prior Period Expense - - 25,201 25,201 0.00%
Total Water Fund 6,085,362 6,085,362 4,978,177 (1,107,185) 81.81%
Indirect cost allocation 511,447 511,447 511,447 - 100.00%
Total Expenses 6,596,809 6,596,809 5,489,624 (1,107,185) 83.22%
Change in Fund Balance (1,204,809) (1,204,809) 460,099 1,664,908 - 38.19%
Beginning Fund Balance 6,000,000 6,000,000 6,077,949 77,949 101.30%
Ending Fund Balance $ 4,795,191 $ 4,795,191 $ 6,538,048 $ 1,742,857 136.35%
Cash and investments $ 6,315,350
(a) When water usage is higher both revenue and water sales are higher.
(b) Connection fees are related to permit activity or sale of property.
(c) Annual maintenance for Eden was budgeted in the Miscellaneous category but charged to Repairs & Maintenance.
(d) Excise tax budget has not been adjusted even though revenue has increased over the last several years.
(e) Andover Park W /Strander new water main project construction has been carried over into 2014.
" Variance = Actual over (under) prorated budget Fund 401
34
2013
Prorated Actual % of Annual
Annual Budget Budget Year -To -Date Variance Budget
City of Tukwila
Sewer Fund 402 - Revenue and Expenditures
As of December 31 2013
% of year expired 100.00%
Revenue
Charges for Services
Sewer Sales $ 5,780,000 $ 5,780,000 $ 7,366,555 $ 1,586,555 127.45%
Total Charges for Services 5,780,000 5,780,000 7,366,555 1,586,555 127.45%
Miscellaneous Revenue
Investment Eamings 5,000 5,000 20,493 15,493 409.86%
Connection fees 120,000 120,000 248,946 128,946 207.46% (a)
Total Miscellaneous Revenue 125,000 125,000 269,439 144,439 215.55%
Sale of Capital Assets (3,184) (3,184) 0.00%
Public Trust Fund Loan Proceeds 750,000 750,000 (750,000) 0.00%
Total Revenue 6,655,000 6,655,000 7,632,810 977,810 114.69%
Expenses
11 Salaries 289,014 289,014 340,316 51,302 117.75%
12 Extra Labor 8,000 8,000 8,347 347 104.33%
13 Overtime 3,442 3,442 8,611 5,169 250.19% (b)
21 FICA 21,998 21,998 27,475 5,477 124.90% (b)
23 PERS 23,699 23,699 29,425 5,726 124.16% (b)
24 Industrial Insurance 6,189 6,189 6,804 615 109.94% (b)
25 Medical, Dental, Life, Optical 44,420 44,420 61,397 16,977 138.22% (b)
28 Uniform Clothing 570 570 603 33 105.86%
31 Office & Operating Supplies 22,393 22,393 34,350 11,957 153.40%
33 Metro Sewage Treatment 3,749,000 3,749,000 3,447,428 (301,572) 91.96%
35 Small Tools & Minor Equipment 5,500 5,500 1,662 (3,838) 30.22%
41 Professional Services 241,600 241,600 187,991 (53,609) 77.81%
42 Communication 2,500 2,500 2,174 (326) 86.96%
43 Travel 1,000 1,000 662 (338) 66.24%
44 Advertising 150 150 144 (7) 95.67%
45 Operating Rentals & Leases 90,261 90,261 82,407 (7,854) 91.30%
46 Insurance 15,195 15,195 16,734 1,539 110.13% (c)
47 Public Utility Services 27,050 27,050 31,350 4,300 115.90%
48 Repairs & Maintenance 43,000 43,000 154,800 111,800 360.00% (d)
49 Miscellaneous 30,000 30,000 32,038 2,038 106.79%
53 Excise Taxes 40,000 40,000 104,845 64,845 262.11% (e)
54 Interfund utility tax 579,000 579,000 736,739 157,739 127.24%
64 Capital Outlay 1,180,000 1,180,000 153,167 (1,026,833) 12.98% (f)
80 Debt Service Principal 275,961 275,961 277,359 1,398 100.51%
81 Debt Service Interest 78,801 78,801 76,749 (2,052) 97.40%
00 Prior Period Expense - - 34,737 34,737 0.00%
Total Sewer Fund 6,778,743 6,778,743 5,858,316 (920,427) 86.42%
Indirect cost allocation 385,141 385,141 385,141 - 100.00%
Total Expenses 7,163,884 7,163,884 6,243,457 (920,427) 87.15%
Change in Fund Balance (508,884) (508,884) 1,389,352 1,898,236 - 273.02%
Beginning Fund Balance 2,100,000 2,100,000 2,199,823 99,823 104.75%
Ending Fund Balance $ 1,591,116 $ 1,591,116 $ 3,589,175 $ 1,998,059 225.58%
Cash and investments $ 2,755,073
(a) Connection charges are directly tied to permit activity and property sales.
(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) APW /APE sewer repair in March for $29,884. Additionally, annual maintenance for Eden is budgeted in the Miscellaneous category but
charged to Repairs & Maintenance.
(e) 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.
(f) The CBD sewer rehab project was delayed due to a sewer main break in the project area. This project has been carried over into 2014.
** Variance = Actual over (under) prorated budget Fund 402
35
City of Tukwila
Foster Golf Course 411- Revenue and Expenditures
As of December 31 2013
% of year expired 100.00%
2013
Annual Actual % of Annual
Budget Prorated Budget Year - To-Date Variance " Budget
Revenue
General Revenue
Excise Taxes $ 2,617 $ 2,617 $ 4,470 $ 1,853 170.81%
Total General Revenue 2,617 2,617 4,470 1,853 170.81%
Charges for Services
Sale of Merchandise
Greens Fees, Instruction
Total Charges for Services
Miscellaneous Revenue
Investment Eamings 1,130 1,130 5,249 4,119 464.47%
Rents and Concessions 276,000 276,000 281,482 5,482 101.99%
Other Misc Revenue - - (150) (150) 0.00%
Total Miscellaneous Revenue 277,130 277,130 286,581 9,451 103.41%
Transfers In 400,000 400,000 400,000 100.00%
134,000 134,000 139,902 5,902 104.40%
977,850 977,850 973,311 (4,539) 99.54%
1,111,850 1,111,850 1,113,213 1,362 100.12%
Total Revenue 1,791,597 1,791,597 1,804,264 12,667 100.71%
Expenses
11 Salaries 654,633 654,633 610,993 (43,640) 93.33%
12 Extra Labor 89,000 89,000 78,937 (10,063) 88.69%
13 Overtime 2,000 2,000 1,509 (491) 75.47%
21 FICA 49,577 49,577 52,082 2,505 105.05%
23 PERS 53,692 53,692 54,738 1,046 101.95%
24 Industrial Insurance 14,499 14,499 17,044 2,545 117.55%
25 Medical, Dental, Life, Optical 140,818 140,818 102,516 (38,302) 72.80%
26 Unemployment Compensation 6,000 6,000 (6,000) 0.00%
28 Uniform Clothing 1,164 1,164 1,114 (50) 95.68%
31 Office & Operating Supplies 88,750 88,750 83,551 (5,199) 94.14%
34 Items Purchased for Resale 80,000 80,000 91,896 11,896 114.87%
35 Small Tools & Minor Equipment 2,500 2,500 2,540 40 101.61%
41 Professional Services 9,600 9,600 9,013 (587) 93.89%
42 Communication 5,150 5,150 1,993 (3,157) 38.70%
43 Travel 750 750 23 (727) 3.05%
44 Advertising 4,000 4,000 2,767 (1,233) 69.18%
45 Operating Rentals & Leases 82,445 82,445 105,962 23,517 128.52% (a)
46 Insurance 15,195 15,195 16,734 1,539 110.13% (b)
47 Public Utility Services 44,293 44,293 46,747 2,454 105.54%
48 Repairs & Maintenance 19,400 19,400 31,441 12,041 162.07%
49 Miscellaneous 40,950 40,950 30,652 (10,298) 74.85%
53 Excise Taxes 6,400 6,400 5,468 (932) 85.44%
54 Interfund admissions tax 54,000 54,000 58,141 4,141 107.67%
64 Capital Outlay 10,000 10,000 - (10,000) 0.00% (c)
Total Foster Golf Course Fund 1,474,816 1,474,816 1,405,862 (68,954) 95.32%
Indirect cost allocation 192,801 192,801 192,801 100.00%
Total Expenses hqµ' ; 1,667,617 1,667,817 1,598,663 (68,954) 95.87%
Change in Fund Balance 123,980 123,980 205,601 81,621 165.83%
Beginning Fund Balance 200,000 200,000 404,389 204,389 202.19%
Ending Fund Balance $ 323,980 $ 323,980 $ 609,990 $ 286,010 188.28%
Cash and investments $ 520,926
(a) Monthly ER &R O &M costs adjusted at year -end to reflect actual costs.
(b) Budget for insurance based on 2012 actuals.
(c) $40k of capital outlay did not occur in 2013. The 2013 budget amendment included an entry to carry forward the $40k into 2014.
" Variance = Actual over (under) prorated budget Fund 411
36
2013
Prorated Actual % of Annual
Annual Budget Budget Year - To-Date Variance " Budget
$ 1,080,208 $ 1,080,208 $ 2,232,190 $ 1,151,984 208.84%
City of Tukwila
Surface Water Fund 412 - Revenue and Expenditures
As of December 31 2013 % of year expired 100.00%
Revenue
Charges for Services
Surface Water Sales $ 3,839,309 $ 3,839,309 $ 3,865,438 $ 26,129 100.68%
Total Charges for Services 3,839,309 3,839,309 3,865,438 26,129 100.68%
Intergovernmental Revenue 355,000 355,000 27,387 (327,613) 7.71% (a)
Miscellaneous Revenue
Investment Earnings 12,591 12,591 21,177 8,586 168.19%
Capital contributions 6,221 6,221 0.00
Other Misc Revenue 120 120 0.00%
Total Miscellaneous Revenue 12,591 12,591 27,517 14,926 218.55%
Sale of Capital Assets - - (937) (937) 0.00%
Total Revenue
4,208,800 4,208,900 3,919,405 (287,495) 93.17%
Expenses
11 Salaries 729,589 729,589 744,916 15,327 102.10%
12 Extra Labor 25,000 25,000 30,398 5,398 121.59% (b)
13 Overtime 9,358 9,358 5,773 (3,585) 61.69%
21 FICA 55,149 55,149 58,364 3,215 105.83%
23 PERS 59,837 59,837 63,086 3,249 105.43%
24 Industrial lnsurance 15,709 15,709 15,124 (585) 96.28%
25 Medical, Dental, Life, Optical 151,768 151,768 143,985 (7,783) 94.87%
28 Uniform Clothing 1,425 1,425 781 (644) 54.78%
31 Office & Operating Supplies 92,130 92,130 35,748 (56,382) 38.80%
35 Small Tools & Minor Equipment 4,000 4,000 10,632 6,632 265.79% (c)
41 Professional Services 953,570 953,570 360,531 (593,039) 37.81%
42 Communication 2,000 2,000 432 (1,568) 21.62%
43 Travel 2,000 2,000 149 (1,851) 7.46%
44 Advertising 500 500 1,655 1,155 330.93% (d)
45 Operating Rentals & Leases 135,301 135,301 134,154 (1,147) 99.15%
46 Insurance 15,195 15,195 16,734 1,539 110.13% (e)
47 Public Utility Services 156,600 156,600 34,853 (121,747) 22,26%
48 Repairs & Maintenance 13,965 13,965 19,595 5,630 140.32% (f)
49 Miscellaneous 18,000 18,000 35,275 17,275 195.97% (g)
53 Excise Taxes 25,000 25,000 52,167 27,167 208.67% (h)
54 lnterlund utility tax 385,000 385,000 388,189 3,189 100.83%
64 Capital Outlay 1,485,000 1,485,000 665,690 (819,310) 44.83% (i)
80 Debt Service Principal 287,154 287,154 288,528 1,374 100.48%
81 Debt Service Interest 28,503 28,503 28,075 (428) 98.50%
00 Prior Period Expense - - 406,597 406,597 0.00%
Total Surface Water Fund 4,651,753 4,651,753 3,541,431 (1,110,322) 76.13%
Indirect Cost Allocation
Total Expenses
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
474,941 474,941 474,941 100.00%
5,128,894 5,128,894 4,018,372 (1,110,322) 78.34%
(919,794) (919,794) (96,968) 822,826 - 10.54%
2,000,000 2,000,000 2,329,158 329,158 116.46%
Cash and investments $ 2,612,292
(a) Grant revenue is tied to projects and is billed after project funds expended. The City was not awarded the $310K grant for Lower Duwamish
Surface Water Conveyance project that was budgeted in 2013.
(b) Extra labor was for repairing the break on E Marginal Way. Break occurred 11- 19 -12.
(c) Purchased seals for storm drains for $3K.
(d) Advertising for bids.
(e) Budget for insurance based on 2012 actual.
(f) Annual maintenance for Eden was budgeted in the Miscellaneous category but charged to Repairs & Maintenance.
(g) The majority of miscellaneous costs are comprised of lien fees and credit card fees.
(h) Excise tax budget has not been adjusted even though revenue has increased over the last several years.
(i) Late start on the 2013 annual small drainage program and storm lift station #15 has started construction but will continue into 2014.
Variance = Actual over (under) prorated budget Fund 412
37
City of Tukwila
Equipment Rental/Replacement Fund 501 - Revenue and Expenditures
As of December 31 2013
% of year expired
100.00%
2013
Prorated Actual
Annual Budget Budget Year -To -Date
Variance **
% of Annual
Budget
Revenue
Charges for Services
ERR O &M Dept Charges
Equipment Replacement Charges
Transportation
Total Charges for Services
Miscellaneous Revenue
Investment Eamings
Other Misc Revenue
Total Miscellaneous Revenue
Sale of Capital Assets
Transfers In
Total Revenue
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
44 Advertising
45 Operating Rentals & Leases
46 Insurance
48 Repairs & Maintenance
49 Miscellaneous
64 Capital Outlay
Total Equipment Rental Fund
Indirect Cost Allocation
Total Expenses
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
Cash and investments
$ 1,409,325
972,088
150
2,381,563
14,269
14,269
397,226
1,030,000
3,823,058
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,052,906
3,434,700
291,838
3,726,538
96,520
4,000,000
$ 4,096,520
$ 1,409,325
972,088
150
2,381,563
14,269
14,269
397,226
1,030,000
3,823,058
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,052,906
3,434,700
291,838
3,726,538
$ 1,560,249
1,032,088
2,592,337
12,882
6,918
19,800
65,943
1,030,000
3,708,080
365,459
13,739
28,791
31,129
9,552
79,111
580
1,829
647,715
3,700
1,531
1,318
373
38,381
10,828
34,171
7,132
2,044,013
3,319,352
291,838
96,520
4,000,000
$ 4,096,520 $
$ 150,924
60,000
(150)
210,774
(1,387)
6,918
5,531
(331,283)
(114,978)
844
1,739
(2,000)
1,003
1,227
(499)
1,155
(370)
(1,150)
(31,285)
1,200
531
(682)
373
8,239
698
(86,610)
(868)
(8,893)
(115,348)
3,611,190 (115,348)
96,890 370
4,132,395 132,395
4,229,285 $ 132,765
$ 4,303,989
110.71%
106.17%
0.00%
108.85%
90.28%
0.00%
138.76%
16.60%
100.00%
96.99%
100.23%
114.49%
0.00%
103.61%
104.10%
95.04%
101.48%
61.02%
61.39%
95.39%
148.01 %
153.14%
65.89%
0.00%
127.34%
106.89%
28.29%
89.15%
99.57% (a)
96.64%
100.00%
96.90%
100.38%
103.31%
103.24%
(a) All equipment except the fire command vehicle have been ordered. The purchase of the fire command vehicle has been deferred to 2014 as
well as $71,000 in costs for the fire pumpers. The deferred costs were included in the 2013 budget amendment.
Variance = Actual over (under) prorated budget Fund 501
38
City of Tukwila
Insurance Fund 502 - Revenue and Expenditures
As of December 31 2013
% of year expired
100.00%
2013
Annual Budget
Prorated
Budget
Actual
Year -To -Date
Variance **
% of Annual
Budget
Revenue
Charges for Services
Employee Benefit Programs
Total Charges for Services
Miscellaneous Revenue
Investment Eamings
Employer Trust Contributions
Employee Contributions
Other Misc Revenue
Total Miscellaneous Revenue
Total Revenue F i
Expenses
25 Medical, Dental, Life, Optical
41 Professional Services
49 Miscellaneous
Total
Indirect cost allocation
Total Expenses
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
Cash and investments
$ 1,200 $ 1,200 $
1,200
96,000
4,483,192
78,000
1,000
4,658,192
4,659,392
4,892,940
25,000
20,500
4,938,440
73,709
5,012,149
(352,757)
4,500,000
4,147,243
1,200
711 $ (489)
711
96,000 (34,954)
4,483,192 4,375,649
78,000 70,225
1,000 -
4,658,192 4,410,919
4,659,392 4,411,630
4,892,940 4,628,141
25,000 28,510
20,500 15,312
4,938,440 4,671,963
73,709 73,709
5,012,149 4,745,872
(352,757) (334,042)
4,500,000 4,794,386
4,147,243 $ 4,460,344
(489)
(130,954)
(107,543)
(7,775)
(1,000)
(247,273)
(247,762)
(264,799)
3,510
(5,188)
(266,477)
59.24%
59.24%
-36.41% (a)
97.60%
90.03%
0.00%
94.69%
94.68%
94.59%
114.04%
74.69%
94.60%
100.00%
(266,477)
94.68%
18,715
294,386
94.69%
106.54%
313,101
107.55%
$ 5,868,475
(a) Includes interest eamings of $148K and $183K of unrealized market value adjustment for 2013.
Variance = Actual over (under) prorated budget
Fund 502
39
City of Tukwila
LEOFF Insurance Fund 503 - Revenue and Expenditures
As of December 31 2013
% of year expired
100.00%
2013
Annual
Budget
Prorated
Budget
Actual
Year - To-Date
Variance **
% of Annual
Budget
Revenue
Miscellaneous Revenue
Investment Earnings
Total Miscellaneous Revenue
3,340 $ 3,340 $ 2,707 $
3,340 3,340 2,707
Total Revenue
3.340
3,340
Expenses
25 Medical, Dental, Life, Optical
41 Professional Services
49 Miscellaneous
Total
Indirect Cost Allocation
Total Expenses
Change in Fund Balance
Beginning Fund Balance
Ending Fund Balance
Cash and investments
479,372
19,500
498,872
9,619
479,372
19,500
498,872
9,619
2,707
802,848
4,390
500
807,738
9,619
(633)
(633)
(633)
323,476
(15,110)
500
308,866
508,491 508,491 817,357 308,866
(505,151)
1,600,000
(505,151)
1,600,000
(814,650) (309,499)
1,711,532 111,532
81.05%
81.05%
81.05%
167.48%
22.51 %
0.00%
161.91%
100.00%
160.74%
161.27%
106.97%
$ 1,094,849 $ 1,094,849 $ 896,882 $ (197,967)
81.92%
** Variance = Actual over (under) prorated budget Fund 503
40
$ 1,111,132