Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Special 2012-09-19 COMPLETE AGENDA PACKET - BUDGET WORK SESSION #1
City of Tukwila Council Budget Work Session #1 AGENDA AGENDA Wednesday, September 19, 2012 1 uRwila City FlaII — cuancil CFiam6ers b:uu p.m. — rs:uu p.m. I. Financial Status and Overview A. Economic Briefing B. 2U11 Actuals, 2U12 Actuals dna Year End I•'rojections II. Preparing the 2013-2014 Biennial Budget A. Budget Theme — Financial Stability B. Staff Direction in Budget Formulation 111. Reserve Policy Iv. UUestivn and Answer V. Adjourn UPCOMING DATES: • Monday, October 1 — Receive copy of Mayor's Preliminary Proposed Budges • Tuesday, October 9 — Budget Work Session No. 2 — 6:00 p.m. to 8:00 p.m. • Wednesday, October 10 — Budget Work Session No. 3 — 6:00 p.m. to 8:00 p.m. • Thursday, October 11 — Budget Work Session No. 4 — 6:00 p.m. — 8:00 p.m. • Monday, October 22 — Mayor delivers budgetary message and presents Proposed Budget ■ co co -C "tS) w E o cn c w i w "- -L cry _ 0 w ct, O 2 O › O U••c� 1-6 • • • 2013-2014 EVV nn ial Budget We MIs horl Q w T ■ _ 0 v '— E 0 an O 0 a) 0 = y.r c w co c7) W w > an O 16 cmcn E.— V v V 0 V ■ _ ■— E V > O _ O a, w T NN T N con omic Indicator T 00 Q 00 N 0) Unemployment 7 N N N N 0 U 00 LO N Change in personal income 7 M 0) M Change in disposable personal income T 0 co (0. T Q Change in Mar ulaclluring N T N Change in Construction lldaita from WA State 8cononic Reireicaist Council; Nlationail & Global issues: a) w 0 a) Cl) 0 X E 0 CO c U 0a) 178 'a U) 0= . . . . National liscal issues Impacts irorr European and Asian markets 2C 13-2C 14 BlienrEludgel Workshcp 3 — co qv C am 00 CO N C CO COO LC) CO 00 r C37 O M N N d' co 00 LO CO CO a) cn W CO N N 4 c0 O O r r , f� N M CO N Ln M 4 N O) N- M CO M Ln N LO LO w w Total Revue n ue LL c) '_ co U vn(1) MSc a) co m L▪ ca c CO 15 U LL c C1) X 0 cL m ▪ CD . L C13 .UJ �C.) 45 I— O ED LLI • • • 2C 1 3-2C 14 B6iennii iI 6ludge 1 Workshcp 4 2C 7 3-2C1 4 6Gisnruial E udge t Workshc p 5 "0 n ■ N CO Q Q CA w f� •q -- In CO'd' CO CD r CO "Cr [�) N • C'7 cO CO t CO OJ CI CO Ic C• S; e CY) V) O CD D Ic N [�) N • CV m L N N C) w v V CL) r CD 0 `Cr Ln V) w CO co N CD N CV te- co (NI co N T) T CT) av u7 (TSC10 C� CO L) 0) v N c N N CO N S easor al lluctuatior s, bull are or target for budget at end of Auc us1 Rind balarce up it all iuncs except Maier • N r N a) O () 0 (0 0 0 UJ (1) 0 V U i CCi a cnO O i a)= w U V 0d O cl o a) • c0 2016-2014 Biennial Budget We dilshlop N Q C w v ALL CD Co W CT7 a� N d' L() T 00 N O co0O f� Lri Q' W O 0) � 0) O COSLC) • N N � co LC) LO co co Co O co T N N N M O CO O d N N 00 N LC) O) CO M nllerral Service Fund Highlichls: infernal service fur ds Revenues exceec experses in al 2C 1 3-201 4 Eli6nnial Eludge t Workshop 7 C. N t .cr i as 0 1 Purchased 2nd half of Cuwamish Hill Rreserve Contract signed to remove sandbags along Green River Southcenler Rarkway project expected completion 3iid quarter • Budget is $100K V) CC V7 N.G T O V O co W • s o_ -FD E Q O o 0 te�) Q cm c To '5 (r] , _N a) co L0 d) �- 5 E L.L. .5 •- w I— O m W ■ Cn ii 00 2013-2C14 aierini i Budget Wonksticp i coco 1 :7•1• Percerli Cl- ange Revenu es v a▪ ) o0 CO 0..1 ✓ N - LC) O N N U Ww Q LO N r LC) O O N N _N 2 N o E o• N LO N N r 0) M N m1-0 • ti O N < C en eral Fur d Total Rever ues 81 Transfers Rrojections based on actuals trough August and projections kr Iasi 4 months • RG RL, ullility ilaxes, excise tax — down by $1.3M from adoplled • 011hier financing/surplus property — one-time $1.3M, moved to luture years • Bluildir g permits and plan check fees down $300K • Ai 3-2014 Biennial Eludge t Workshop 9 4-• n N T N ■ Percienll Change Expenditures 2011 Act 2012 Bd qt CS CD i.+ G G T Q) N E CMS (- N tr W r N Cid O N Q N: cis O N G email Fur d Department 20 :114 2 v r al Expenditures estimate is based on budget used through September 14 N ▪ 0 CD . 0 tti 4) Q. 0) a) c Ix La (i ^� 0 W c Q Co 0 O 0 -a- a) 0 0 -o 0 0 vw a) sa CC - o ct 0 0 i v (U Cti 0 W LL LL 0) N 0 C- D Q) '0 N Z N > (7, w � w a) N 0 cti a) a) RS CZ V 0 Q w c N v U Q cc V O IP IP IP IP 2C 13-2014 Biennial Budget We rkls hop 10 ■ E . c H 0 a) cI (1) c ca 0 fn 0 0 O .O -o u)) r 0 O O 0 c c 0 O co co (oma' ._ 0 U 0) V) Cil E2C C1) 0 N O -5 u) czOE o)0_ c co 07 cri LE cn En EL a • • • Co ns ideratiio ns CC crs w E O cn U a) C6 07 c. 0co • • • • • • 2C 13-2014 Biennial Budget We rkls hop 11 co 0. (1) al) III nim illmg II Em .mm 0 ca lJ- -o d -awZ co c d E LL R I 0_ 0 (1) 6 c w E a) U L c 0 CO 0 0 0) Cl) 0 0 0) 0 E yr i 0) E 0) u co 0. cc (±) 0 0 w 0 c CCs c 4) C6 E ...., -o c w C13 E R Q • ■ tics > W 0 b- co ▪ a) V o co N N u_ 0 . _ 5 CC 2 0 i Li E • c . 0 "14 c w a C co CL olmr . - co LL an October 2 w a) ■ E E 0 0 cz Cn 06 a) 0 Cs LL • 201,5- 014 Eliennial Budget We n/ L hop 12 a� co E a '5cr n 7.3 a� E wu co cca� ■ ■ -1--' To' szu E m▪ lomo TT) 0) a) co O • c 0 — cts — Ea) N _Q 12 E ca ozu (7) o • � co 0) w szu l'i; a_ a) O E ( Q ca — _c •— CD CD co t:)- Q) N c_ O 0 -0 RS 0 a) co Q c 2C 13-2C 14 Bl iennii d 6 udge 1 Workshcp 113 ■ nstructions/Message: Financial Sustainability E • Sfai l in g budget = 2012 budget unfunded FITE's approved as "non- O i O73, E O O Q O -C E N E -- O O O O r.,,‘ 40 a - o u)O co _o Co co N Tr) CD O N w V "4--,,,, 1453 -cep C/) V -0 V O v) = co 0 ED .a • c6 O Z • • 0 V 1 1:47. ca E u_ 0 m cr co 0 • Revenue considerations Reduction in state shared revenues cm co 0 c C26 Q V cu OF 0 ,V E 0 _V EL co c 2IO i i • • Ci) ■ ■ ■ ■ 2C13 -2C 14 B6ienrizit 6ludgel Worksticp15 4.4 w 2013-14 % change 0 00 \0 Cr; 0 O C\ d+ 0 O O O %WI 0 O O O 0 O O O 0 `p C1 c i 2012-13 % change ,71 w 1--1 r-1 v; OG r 131 -go g L3'3 cv 01 C1 Cl 0 O O O 0 O O O O 4 e41 op M rW 'II ti V N 9 CG O to o Lf) Er, C� Lf) 0mc, 0coN. ' ' N et Lf) N H1-+ ci) r Pi ,_, ,., . B N Pa Cl. 00 O N 00 III ur., cm D 00V , •• CN EN N 00 e,.. .., N N C N c*) C1 00 1 en .-1 ' o 71 O 1D o (T] 2011 ACTUAL $ 941,358 321,938 9,497 l 1-1 1 cv Cr).. 1-1 M VID ell 1-1 2010 ACTUAL O \-1 L) Ef'3 377,339 48,387 o cn co E9 a1 O 00 N EXPENDITURES 10 Salaries & Wages 20 Personnel Benefits 30 Supplies 40 Other Services & Charges 50 Intergovt. Services & Taxes 160 Capital Outlays EXPENDITURE TOTAL REMENUI -o a\ N (NI d+ 3E .44% Ip Cr) IM M (N cV IT5 Ili. 00 00 N N EA - L\ L` co 00 ON s n t1 N N CN EN �>> ET] CO en .-1 1 CT) CT) CT ) (T] VO , l 1-1 1 p1 01 N.v VP L.?, rr3 o cn W c.i. N ta "d REMENUI TOTAL A ca a� c4 r.5 2C 1 3-2014 Biennial Eludge t Workshop 16 c 1d 0 0 a ■ 1) 4.1 Cet 2014 Budgeted Salaries Benefits 12 $1,045,103 $ 355,160 I ;5_11 �-1 O N W 2013 Budgeted Salaries Benefits 33,,0571 34,9621 -370) 1,081 12 $1,008,041 $ 338,582 N w N 1-C\-11 w V2.1c.)--- r-+ r-+ c --i M Lf) N Position Descripton • a� Ct 4 6 +� O 8 v U H a, U cn cn 1 E E rs uN ) X Nw cw w w w 0 1--i 2613-2C 1 4 66iennii it 6ludge l Workshc p 17 n 1 V sect 1 ienr iG A Eludge 1I Workshc p 18 2013-2G1' B 8,EI53 I $ r \ !' L 1;-1gq,1j091 00 `'J 1-4 (1, ft O 8 d•I EA I EA- 1 EA u N EA - 2012 Budget $ 989,836 369,680 24,849 00 qD o . �i N $ 1,603,133 v cr) 113 CO C "a a. 4- •a. a. o (/) m vi U 88 8 8 8 ,-1 N m d' l0 co p I— ienr iG A Eludge 1I Workshc p 18 2013-2G1' B 201; -2C 14 aierinia l Budget IMonks/ cp 19 N 8 Ln 00 (1, kin1 .-rte kin 1 tn d4 V) En- 2013 Budget 8 © 00CA� coon Cr) N ON '7P.,„ Cf) 00N 00�O c2 CA vVI l-, > _ N 0 .L i •N Q v1 t).04.-,-, c8 c Q e .Q N L = c fD co m v) d U O 8 0 8 ® 8 r -I N M Tt Lei l0 ca p I— 201; -2C 14 aierinia l Budget IMonks/ cp 19 V) w E t U (C >, Q V) CD 0 -o O O L U O v) E i tip" cr) V0_ CO 5 8 O 0 2 O 4) c� c" (w a •as E a) c E . r od • � w CT Q) CD CD a) `V = fi la ` 0 O7 0. a o o ® U v) Q) c� � .O O o) a) Ow c a) 0 = as CC a O -LI O O O 06 L c • U (1) O 4) � 4) E L N v • E. .0 p N u p r c) -d 0 v2 m i Z O • • .- i co O w N a 0 z D et additions Revenue backed bud •Grani furded expenditures, cc Els associated with annexations, fee for services artments and funds (1) w Tti -0 cn Lr) O z c"7 u- O V ON. E+ O 0 L L- LL O O E CD C " E � v 4) •O L- Transfers amon 2015-2014 Eliiennial Budget We nkL flop 20 v •o d Et ;IP General Flu r d 2 L() Reserve Fund w 0 N •V N L N -o Q o nr1.1. Li. .0 o 0) O II— Tn3 (0 in 0 U . E .� _ a) i O .Ca w . .� 415 V) c c 0) 1.1 cu cics W 2 O0 c CU 8 • • • 1,- 3c V 2C13 -2C14 Biennial EludgE t Workshcp2 1 ■ L 1 cn cn Financial S uista in abilily 0 D N cn Cti 2013-14 Budgel • • i 0 . i 43. c 0 as icn _ w cz L.- ,5 O - •V 0) (II a) T o 'c Id_ as (75 a) = c o >< o � c • a$ as ti -0 Cn d) U c Ca • cu N 0 N E as 0 31 -0 0 Q C6 cri 8 c ® .E (.0 . c u) w u) En c== c w ri) 0 ._ O 0 �> > 0 0 2 c Q U 0_ • • • 2013-2014 Elk nnial Budget WcirkL hoj 22 c1) d 0 ca 0 E r aw .0 O 0 iminary Proposed Budget 0 0 0) -fa-5 -o 0 U) 0 0 0 E. EL Q Q. Q CD CD 0 O O O 00 � .. co 0 0 E E. E Q Q Q o o 0 0 0 c 6 6 CO i CV CY) a' 0 z O . u) (1) 0 (i) 50 0 r G) O 0 z 0 . co (1) 0 50 0 m r r i 33 0 V 0 0 z 0 w a) 5O 0 m October 22 4a' 0 i) 0 0 as Cu)! 0 E 0 0) 0 (1) L 0 0 0 2C i3 -2C 14 Biennial Eludg6tWorkshcp23 c 0 .y v 0 0 ■ Discussion Q aJ 0 • ■ Adjournment 2013-2014 Eic nn,ial Budget We nkL /lop 24 2012 2nd Quarter Financial Report Detail to be used with PowerPoint Slides No_ 4-8 Prepared ay repo mend* & vichiva reen June Su, 21)12 ;• o as o 'I � COc'd C\I 1,0 1-1 rTJ C\I Summary (Cash Basis) City-wide, unreserved fund balances incteasea $2.J /3 1t1i11iDtt u1 the tii3t naII of 2012 Lour $45.167 million at Decembei 31, 2011 to $4/./40 as DI June 317/, 2012. Inc gDvCcuuu'cutal hlud3 incteasea the city-wiacc Mud Da1ancu 07 $1.333 llullioll, the cuter n13c funds by $844 tnousatta_ arta the i,itCittal 3elvicc fu11d3 by $3 /6 thousand. Of the governmental funds, the General Fund ha3 inetca3ed by $1.952 million during the first half of the year. Further discus- 3io11 vu the go vc1.111 ci,ta1 funds and the General Fund occurs on the following pages. The enterprise funds had a net increase of $5844 thousand primarily due to revenues exceeding expenses and expenses being well under 50°,0 in all funds. Revenue in both the water 1. Lula and the Golf Course Funa is unset budget IDI the test nail DI the yea' duct to it3 Cyclical nature but is expected to inciease autiitg the sultt,uet 1tiDntn3. the tutancial outlook IDI the City iccuiaiva stable. i-nwccvccl, ccouDuiiC lndicatur3 .e...ai11 inire3. Inc w713hi11gto11 =ninny Coutulu%3 to grow at a 11.oderate pace and housing construc- tion i3 init. vins, howcvcr, 61..e111ployment is slightly higher in July than in the previous wont indicating that the recovery remains weak. Global issues including the European sover- eign debt and banking crisis continues to pose a substantial risk to our own economy. Nationally, the federal income tax rates will inciease itt 2013 unless the teaelal gDvccuuu'cuT takes action to reinstate tax Cuts that ate set to eANiue at the end or 2012. Any ieduetiott ill dis- CletiDitaty inCDltic aIICCt3 CD1muu1ccl a1.c1iaiiig dna Incc1ccby 3a1cc3 tan Collcetion3 fin. the City. To Ntutect agaiii t tncac financial ul,Cenaiutiea, the City Continne3 to follow conservative fiscal t,D1iCy. General rung Hotel/Motel Tax Fund Street rand F rtenal street Fund conungen y Funu Fire Equip Cum Reserve 0,.g sebum Fend uedt ser0lce Puna! Par Ao Fund Fealit, Re,.leeement Fend 1;enerei Ge-I-pmements Fire Impact Pee Punu Water Fond Serer Fond Foster 50i Fund suRdce ..ater Fun0 Equipment Replacement Fend s t, -Ir .ranee Fund 08,11.1. Insurance Fund -= unreservedi unrestntTed Fund Balances— A1/4 DT smug 30, iu1Z FUND BALANCES CHANGE IN FUND BALANCES CITY-WIDE — ACTUAL — — ACTUAL — BUDtEI — Variance Seso,l0e 12/31/2011 06/30/2012 YTD YTD YTD ,832,830 :97,19) [a] lb] II)] - [a] _ [c] Id] [d] - [c] Govemmentai tuudb $ 24,804983 $ 26,158,378 $ 1,353,395 $ 1,249704 $ 103,691 Ente.T.H;se Lunda 10,225,55/ 10,/59,068 533,511 (1,304,723) $ 1,838,234 Internal sanoice tunas 10,136,459 iu,5z3,565 387,109 78,341 $ 308,769 City-wide Total $ 45,166,999 $ 47 441,014 $ 2,274,015 $ 23,321 $ 2,250,694 General rung Hotel/Motel Tax Fund Street rand F rtenal street Fund conungen y Funu Fire Equip Cum Reserve 0,.g sebum Fend uedt ser0lce Puna! Par Ao Fund Fealit, Re,.leeement Fend 1;enerei Ge-I-pmements Fire Impact Pee Punu Water Fond Serer Fond Foster 50i Fund suRdce ..ater Fun0 Equipment Replacement Fend s t, -Ir .ranee Fund 08,11.1. Insurance Fund -= unreservedi unrestntTed Fund Balances— A1/4 DT smug 30, iu1Z r.86ti,63e S- $1,0013,001353,000 000 53,000 000 $4.000,000 53,000 000 56,000 000 et .000 000 58.000 000 Illa17n tills Iarau6: Governmental Funds 2 uenerai rune rxpen'aitures General Fund Revenues 3 3 Enterprise arra internal Service Funds 4 Page 1 or 32 Seso,l0e 038 ,832,830 :97,19) $4.341 ' .881 szo18, ��i MEIIIM 53 ,/0,461 r.,ddZ,388 i�geommif IM® - _ ..710848. Ss,.7.1-, r.86ti,63e S- $1,0013,001353,000 000 53,000 000 $4.000,000 53,000 000 56,000 000 et .000 000 58.000 000 Illa17n tills Iarau6: Governmental Funds 2 uenerai rune rxpen'aitures General Fund Revenues 3 3 Enterprise arra internal Service Funds 4 Page 1 or 32 Governmental Funds uovemmetlt'SI Funds FDNu 81uMMCra t.1179U IA FM eALANCES Variance YTD [e) -[al REVENUES AND EXPENSES — ACTUAL — 12t31/2611 0313112012 [a) Pl 0613012012 [e1 — ACTUAL — 02 YID [el -[61 [el - [al =[al — BUDGET — YTD [el Revenues Expenditures Amt %or Budget Amt %of Budget 000 - General Fund $ 5,912,116 $ 6,137,790 $ 7,864,938 $ 1,727,148 $ 1 952 822 $ (1,563;z05) $ 3,516,02/ $z6,33b,518 49.40% $z4.383,b96 43.20/o 101 - HoteVMotei iaaFang /8068 $ 49b.zz0 $ 564813 $ 66653 224 695 (153,801) (70,895) 555,213 44.20% 779,908 49.88% 103 -Street Fund 903,937 960,886 980,102 192 6 76165 (104,44/) 180,61z 125,044 z/.14/0 49,419 7.48% 104 -Mariai 5tr I Fang 6,9z9,396 6,882,475 4,341,038 (2,541437 2 588 358 2,691,446 (5,279,804) 1,999,438 9.15% 4,587,796 27.86% 105 -Contingency Fund 1,457,728 1,457,929 1456686 /5/ 958 1,500.908 (1499,95u) 958 0.03% - 0.00% 10/ -F6 Equip Cam rcesene 890,797 884,410 884.759 349 6 037 64,562 (70,599) 635 0.48% 6,673 260.$1% 109 - Drug Seizure Fund 229,711 226,462 122,196 4 z66 (/ 5 5 35,500 (43,015) (0) 0.00% 7,515 30.06% zxA - Debt 5artice 3,316,312 3,314,752 5,632,830 2 3 8 078 2 3 6 5 8 (142,044) 2,458,562 2,940,539 83.b4% 6z4,0z1 16.41% 301- Parks Acq Fund 1,427,913 1,430,4/3 1,39/,981 31492 z9 9yz (689,383) 659,391 67,089 9.55% 97,081 4.67% 30z - Facility Replacement Fund 2,027,014 2,019,099 2,016460 639 8 554 (41,100) 32,546 1,352 11819 9;906 11.z470 303 -General Govlmpmements 608,613 b33,110 416,83/ (156 113 3 775 (373,784) 242,008 66,400 3.89% 198,175 8.07% 304 -Fire Impact Fee Fund 313,819 316,591 317,678 1,087 3 859 25,050 (z1,191) 3.859 /./070 - 0,00% Total Governmental $24,804,983 $24,760,19/ 116,158,378 $ 1,398,181 $ 1,353,395 $ 1,149,704 $ 103,691 $ 32,097,644 $30,744,250 Governmental tunas Ill St iA 1..o11tns activity increased fund DalauCCs Dy $1,353 ...illioll. A3 of the end of June the general fund added $1,953 million in fund balance. Revenues for the General Fund were $26.337 minion of 49.9% DI Duaget cCul- pa1Ca to enpellaitures or $24.384 l..illi;,11 :,i 46.50/o of budget. Highlights for the first quaner include: General Fund ▪ Sales and Use Taxes are slightly above budget due to higher than expected retail sales from the business ai-- trict resulting i11 iliCleasea sales tan 1'cveuue 01 $8.3 mlllloll Cou111a1Ca To thee DuagetCa $8.1 uulllou. • Revenue Generating Regulatory—y Licenses g'cileiatcca $1.7 million as licenses were ienewea ID1 2012. • Gambling taxes are at 30.1% of the budget. One casino closed after the Current biennial budget was AUDI/tea. • Penalties/Interest includes $5450 in late tees collected from a vendor that provides solid waste ser vices. • Chaises fru SCl v ices eoutinues to be below budges as the use of City facilities and services remain low. • Ylall cneck and review fees arC below budget. The num- be. of pc t3 i33ued the first half of the year is similar to last year, however, the value of the permits is signifi- cantly lower. Hotel/Motel—Tourism • Intergovernmental revenue is at 38.49% for the first half of the year. The full amount, $410,000, owes by the City of Sea Tac will be billed i111)ecelllbel. Fire Equipment Reserve • Use of Sound Transit Mitigation riniM Tot the purchase of seven leCiploCatillg saws Io1 apparatus ir1 MC aluDunt oI $6;392. lnis enpense will be offset at year -Cud by defe..ed 1cve11ue received several years ago for Sound 11a1131t Mitigation. 2012 SECOND VUAKILK Y11VAN1,aAL K15Y01(1 Page 2 of 32 General Fund Revenues Revenue Summary Q2 2012 u4 4011 Actual zuiz Buaget raj [5] %of Budget [a] 1 [p] Actual [A Over/(Lime,) P1i.i1 Yea, [a] - [c] Properly Takes $ /,3/9,666 $ 13,658,z50 53.21% $ 7,039,636 $ 340,030 Salus aria Usv IaAes 5,301,146 15,048,000 55.16% 5,519,3/2 (518,226) Revenue Generating Regulatory Lias 1:720.43/ 1.9/5.000 5/.11% -1,39I,z57 323,180 Utility IaA0s 2,13/,96-1 4,o4u,u00 44.17% 2,161,369 (23,408) intern „a utility lax 709,314 1,524,000 46.54% 629,480 t9,5..4 EACise !axes /556,6// 2,641,303 29.78% 999,184 (212,5U/) Business Licenses and Permits 533;465 80/.22/ 66.09°%o 348,/t3 -154,692 Buildiny Permits dna Fees 4/5,551 1,058,5139 44.95% 543,100 (67.219) InteNcv.mmantal Revenue 1,617,367 4,144,147 39.03% 1,545,053 (zz/,656) Transfers In/Indirect Cost Allocation 1:165,332 2,33/,0// 49.86,6 90,,096 258,236 (Jenard! Fana otner 1,509,z/1 5,Ui3,448 29.75% 1.505,616 655 1 Staid $ 26,336,518 $ 53,317,041 49.40°/ $ zb,i b,u3e $ z3u,sz1 Governmental fund revenues during the f rst halt or 2012 a e 611 pace with 2011 with a slight i11ciease oI $62,839. rloyccrty laA- es, Revenue Gellelat111g Kegulat0ly LiCen3C3, and 1303;11,33 Li- cenSes x113 retinas 1eveu. eAeeeded 2011 reveln.es by $871 tnou3a11d. uffscttiug the3�. gains with revenue of $1.17 million lower tha11 2011, were Sales and Use Taxes, Excise Taxes and B,.ilding Permits and Fees. Although Sales and Use Taxes were towel in con1paiiso11 to the first half of 2011, ieveuues oI $S.s 1lullivll ale g1ccatcc1 than the, prorated bu3get or $ minion 01 33.15% vI budget. Ge11eIat tu11H eA11e113ituies tn,ougn the f113t half 5f the year are $24.384 minion o1 4J.2/0 of budget. Department 20 transfers out were $s.uD5 ...inion for the first half of the year and will contin- ue to be made on an as needed basis during the yea1. In a33ition, Salaries and Benefits are slightly rowel than buffget by $942,4b1. Police and Fire contracts were 1atit1'c3 i11 s13 yuanei 6113 retro payments were maffe i11 J uly. All 3epartments i11 me Uenelal ru11d ale below budget for the tu.,t Hatt or the yCa1. General Fund Expenditures TUTALS BY cATEGokY Annual Budget Expected Budget Actual Spent Varian %Spent TRANSFERS OUT SALARIES AND BENEFITS SUPPLIES PROFESSIONAL SERVICES INTERGOVERNMENTAL CAPITAL EXPENDITURES arena 1 eta's $ 10,364,/52 33,/02,558 1,193,673 8,180,993 2,694,475 307,000 $ 5,182,376 16,851.279 596,83/ 4,090,497 1,347,238 153,500 $ 56,443,451 $ 25,221,72e $ 3,05,515 15,908,818 511,898 3,837,551 1,uv5,185 25,428 $ z4,3t13,Wi6 $ (2,127,561) (942.461) (84, 938) (252,945) (302,053) (X8,072) 29.47% 47.20% 42.88% 46.91% 38.79% 8.28% $ (3,5 .Os0) 43.20W 1 u i ALs - ALE Derbes 1 mENTS 1:11 Y COuNcIL MAYOR HUMAN RESOURCES FINANCE CITY ATTuRNEY RECREATION COMMUNITY DEVELOPMENT murvlcIPAL COURT POCIcE FIRE INFORMATION TECHNOCOC;Y PUBLIC WORKS PARR IGIAINTENAICcE 5 I KEET MAIN 1 ENANLE & uPER7Z 1ION DEPT 20 1v1AL Annual BLOW $ 269,655 z,543,991 5(3,396 1,603133 542,734 2,530,14, 2,858,579 993,849 14,197,710 10,308,193 1,153,94, 3.613,803 935,027 z,676,535 11,642,752 $ 5e443451 Expected Budget $ 134,828 1,271,996 286,698 801,56/ 271,367 1,265,074 1,429,290 496,925 7.098,855 5,154,097 576,9'4 1,806,902 467.514 1,338:268 5,821,376 actuaI Spent $ 123,218 1,035,454 258,958 694,101 224,968 1,081.141 1,295,608 491,912 9,744,709 4,932.976 499,022 1,529,998 463,914 1,314,240 3,693,277 vanance (11,610) (236,542) (27,740) (1u t ,465) (4b,399) (183,933) (133,482) (5,012) (354,146) (221,121) (77,951) (276,904) (3,599) (24, 028) (2,128.099) 7• Spent 45.6u% 40. /U% 45.16% 43.30% 41.45% 42./3% 45.33% 49.50% 47.51% 47.85% 43.24% 42.34% 49.6z% 49.107 31.72°/ $ za,zz1,7ze $z4,aiw,elaes $ (3,tWhuau) 43.20% 2012 3niv1NU QUARTER FINANCIAL REPORT Pays 3 or 32 Enterprise Funds N uua 401 -water. l ne W ate, tu11a 1caliLen a year -tel -nate ae- C1'ca3'c 111 'Linn balance DI $.i8b,)11. Wee' ievc11uc through thc 3ccD11d aluaiTC1 i3 at 43.819'o of budget, but the cost to purchase water is greater than budget by $25,074 or 51.21% of budget. Revenue of $1,234,000 from Highline Water District will be received upon completion of the Southcenter Parkway Extension project. t uua 462-Sevveeo . 1 ne S'cwel muff 1'ca1iL'cn d year -tel -nate Iutta ba1a11Cc mcica3cc DI $LUb,b.iL D11 3cwct le vclluc of $S,u50,178 Dt 56.D 1°0 Of budget. A tate increase effective for 2012 is not re- flected in the current budget. Revenues and expenses through the second quartet ate 56.19% and 43.29% respectively. Li min 411-IioII CVu13e. Ince Gait upuibe t-caliLen a year-TD- naTec fund balm= increase of $6D,1SS. KCvcttuc3 a11d cnpcitac3 through the second quartet are 39.15°o and 35.39°0 of budget. Charges for services during the first half of the year were 37.6790 of budget. Fund 412 -Surface Water. The Surtace water miff tealiLea a year -to -ante tuna balance uiCteaae DI $648,233. KevCuue0 ERZ eApeuaca thiDugn tncc aCCCDua yuarLcct arc 51.0y% and 21.41°0 1ea1eetivEly . Internal Service Funds INTERNAL SERVICE FOND BALANCES CHANGE IN FUND BALANCES valiance ERTticrla5E — ACTUAL -- — ACTUAL — ---- BUDGET — Variance FOND 12/31/2011 03!31/ 012 06/30/z01 Z T.(2 Y ID Y ID YTD [a] IN [c] [c] - [b] [c] - [a] = [d] [e] lej - [d] 401 - Water Fund $ 6,043,694 $ 4251,751 $ 5,657,183 $ 1,405,432 $ (386,511) $ (425,797) $ 43,286 402 - Sewer Fund 1,890,166 2,078,188 2,096,798 18,610 206,632 (548,984) 755,616 411- Foster Golf Fund 140,550 14,771 205,683 190,912 65,133 96,755 (31,621) 412 - Surface Water Fund 2,151,147 3,292,884 2,799,404 (493,480) 648,257 (422,697) 1,070,954 ENTERPRISE FUNDS $10,225,557 $ 9,637,594 $10,759,068 $ 1,121,474 $ 533,511 $ (1,304,723) $ 1,838,234 N uua 401 -water. l ne W ate, tu11a 1caliLen a year -tel -nate ae- C1'ca3'c 111 'Linn balance DI $.i8b,)11. Wee' ievc11uc through thc 3ccD11d aluaiTC1 i3 at 43.819'o of budget, but the cost to purchase water is greater than budget by $25,074 or 51.21% of budget. Revenue of $1,234,000 from Highline Water District will be received upon completion of the Southcenter Parkway Extension project. t uua 462-Sevveeo . 1 ne S'cwel muff 1'ca1iL'cn d year -tel -nate Iutta ba1a11Cc mcica3cc DI $LUb,b.iL D11 3cwct le vclluc of $S,u50,178 Dt 56.D 1°0 Of budget. A tate increase effective for 2012 is not re- flected in the current budget. Revenues and expenses through the second quartet ate 56.19% and 43.29% respectively. Li min 411-IioII CVu13e. Ince Gait upuibe t-caliLen a year-TD- naTec fund balm= increase of $6D,1SS. KCvcttuc3 a11d cnpcitac3 through the second quartet are 39.15°o and 35.39°0 of budget. Charges for services during the first half of the year were 37.6790 of budget. Fund 412 -Surface Water. The Surtace water miff tealiLea a year -to -ante tuna balance uiCteaae DI $648,233. KevCuue0 ERZ eApeuaca thiDugn tncc aCCCDua yuarLcct arc 51.0y% and 21.41°0 1ea1eetivEly . Internal Service Funds INTERNAL SERVICE rune BALANlitS UHANt. IN ruND BALANCES valiance FUNDS — ACTUAL — ACT UAL — — BuuGEi — r 1 D 1zt3itzU11 03/31/2U1z U6/3U/zU12 Q2 YTD YTD lar [DJ [cl lcl - PI [cl - lar = [ J lel [e] - [d] 501 - Equipment Replacement $ 3,523,993 $ 3,653,947 $ 3,802,598 $ 148,651 $ 278,605 $ 336,027 $ (57,422) 502-5elt-In3GranceFuii8 4,983,480 5,30/,419 5,010,123 (z9/,z96) z5,643 (81,z3t) 10/,880 503 - EtuFF hwarance Fa, id 1,628.986 1,695.503 1./10.848 15.345 81.85z (98,109) 1 /9,9n Ilq 1 tRriAL 5ERviut Fui iD5 $10,135,459 $10,655,869 $1 0,5z3,568 $ (133,301) $ 38/,109 $ 156,681 $ 230,428 Fund 501 -Equipment Replacement. Expenses are at 44.48% of the annual budget yielding a positive expense budget variance of $112,066. N uua 311L-In3ua auee. While e111p1DyCC healthcare CO3t3 had beet. lo wet that, budgeted da.titrg the first quarter, claim activity increased significantly during second quarter resulting in a se- cond quarter reduction in fund balance of $297,296. It shbula be nDtea that ever, wall the u1Ct'ca2e in C1ait113 nuting oeCDnn guat- te1, yea, -tel -nate fund Man= h213 i11C1ea3Cd $26,643. The year- to-date increase of $26,643 is $141,123 more than the year-to- date projected deficit of $81,237. Funs 503 -LEON F Insurance. Second' qua—tr ci activity again iticteaa'cn Muff balcuiCe. lh'c year -to -nate uiCiCa3C itt IUu M- an= of $81,862 13 $18D,341 tunic that. the year-tu-datac, ineject- ed deficit of $103,485. Claim activity through 2012 has re- mained consistent and within employer contributions. 2012 3L,,Drlu wurttclr.tc r11Ntt1NC1n1. 1cnrDlcT Page 4 of 32 City of 1 LiRWha General Fund 000 - Revenue and Expenditures As of June 30 2012 of year eApiraad 50.00% 2012 Annual tludget Ecpgcted Budget Actual Ye ark,u,4]ata ve. fence ” °lo ofAnnaal Budget Revenue i.7ene,al Kevenoe Property Taxes Sales and 05U Takes Revenoe Generating Regulatory Eics Rental housing license Admissions Tax Utility Taxes InteRund utility lax Excise l ages LEASEHOLD EXCISE TAX GAMBEING TAXES Penalties/intaISst /Egad Cie, al RCvenuc Liee,. es and Permits BE3ine3Eicenses and Permits Building Permits and Foos Total Licenses a„a Pc,n.its Intergovernmental Revenue Ana ryes ror Services Cie, acral Government Security Enyinee„ny Services 1 ransNortatiGF,, Plan Check arid Review, Fees Culture and Rec Fees / Eta/ Cnai ea m, se, vices Fines and Penalties Mi3C'oI1eneouS Revenue Investment Earnings Rants and concessions Insurance Premiums&Rucovery Cuntri6uti0, ,3/Donatiuns Lune, IDlisr, Ka venue Iota/ MisCCllaneuD Rcv!nv! Sale vt Capital Assets Transfers In / Indirect cost allocation Total Revenue r otar Expi ndituros Change in Fund Balance Beginniny Fund Balance Ending Fund Balance Cash and investments Cash and investments — restricted Cash and investments $ 13,868,250 16,248,000 1,9 /5,000 42: /50 654,000 4,840,000 1.524.000 2,641,303 139,161 2,502,142 67 41, (93,370 507,227 1,055,559 1,865,816 2;944:147 60,951 511,134 9,567 155,149 858,5uu 611,500 2,210,101 21:3,2/0 $ 6,934,125 5,124,000 98 /,500 21,375 32 /_000 2,420,000 762.000 1,320:652 69.581 1,251,071 34 $ /,3/9,666 8,301,146 1,(2U,43( 33,200 Z83,836 2,13/,961 /09,314 /86:677 34;903 751,774 5,479 20,596.685 21,357,716 403,614 533,465 529,295 475,881 932,908 1.009.346 1A72,074 1,617,36/ $ 445,541 53.21% -1/7,146 51.09% 132,931 87.11% I l ,525 1 1.66 /0 (43,164) 43.40% (252,039) 44.11% (52,656) 46.54% (533,974) 29./5% (34,677) 2E..08% (499.297) 3.;.05° 5,445 81//.04/° 461,031 51.10% 129,852 66.09% (53;414) 44.95% 76.438 54.10°fe 145,293 54.93% 30,476 23:239 (/:2366) 38.13% 255,567 252,311 (3.2566) 49.36% 4,934 - (4:934) 0.00% 79,075 77,741 (1.333) 49.166% 429,250 248,925 (150:325) 29.00° 305,75u 197,017 (108,733) 32.22% 1,105,051 799,234 (305:816) 36.16% 106,635 112,193 5,558 52.61% 133,757 66,879 36,009 (30.869) 26.92% 417,203 208,602 208,296 (305) 49.93% 1,000 500 - (500) 0.00% 1,600 800 3 (/97) U.17% 99,200 49,600 31,021 (18:579) 31.2/°/ 652,160 1,300,500 2,337,077 533,317041 _-56,443,457 (3,1266,410) 5,912,116 3Z6,380 275,329 (51,051) 42.18% 650,Z5u (650,250) 0.00% 1,168,539 1,165,33Z (3,206) 49.86% 26,658,521 26,338,5118 (322,003) 45l7W717 28,221,726 24,38331696 (3,1338,030) 43ZU7b (1,563,205) 5,912,116 1,952,8Zz 3,516,0z1 -62.46% 5,912,116 - 100.00% i,,aa, run $ 4,343,101 $ 7,864,838 $ 3 510.027 282.33712 Variance = Actual over (under) prorated budyet $ 4,887,347 $ 4,857,347 Fund 000 Page 5 of 3z Cil1f Or uRITID General Fund txpeAitureb - by uepanment As of June 30 2012 TO'ALS -ALLDEt imENTS CITY COUNCIL MAYOR HUMAN REaOURCES FINANCE CITY ATTORNEY RECREATION COMMUNITY DEVELOPMENT MUIQICIPAL COURT POLiCE FIRE INFORMATION TECHNOLOGY PUBLIC WORKS PARK MAINTENANCE STREET MAINTENANCE & OPERATION DEPT 20 TOTAL 01 - CITY COUNCIL 11 SALARIES 21 FICA 23 PERS z4 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 49 MISCELLANEOUS CITY COURIUL Annual 6uaget $ 269.655 2,543,991 573:396 1,603,133 542,734 2,530,147 2,858,579 993,849 14,197,710 10,3178,193 1,153.947 3:613,803 935,027 2,676,535 11,642,752 Expected Budget $ 134,828 1,271,996 286:698 801,567 271,367 1,265,074 1,429,290 496,925 ,1756,855 5,154,097 576,974 1,806,902 467,514 1,338,268 5,821,376 $ 56.443.451 2p,t2-1.726 Acted] Spent $ 123.218 1.035,454 258,958 694,101 224,968 1,081,141 1,295,808 491,912 6,744,709 4,932,976 499:022 1,529,998 463,914 1,314,240 3,693,277 a 24.ans.bab % cf your zApired Variance $ (11:610) (236542) (27,740) (107,465) (46,399) (183,933) (133,482 (5,012) (354,146) (221;121) (77,951) (276,904) (3,599) (24,028) 12,128,099) 50.007o %'Spent 45.69% 40.70% 45.16% 43.30% 41.45% 42.73% 40.33% 49.50% 47.51% 47.85% 43.24% 42.34% 49.62% 49.10% 31.72% 14.8su,030 , 43.2u7° Expected Ann al BUdgEt Budget Actual Spent Variance % Spent 177,720 86,660 917,330 1,470 50.83% 13,2i4 6637 6,774 137 51.03% 8.016 4,008 3,312 (696) 41.32% 2:745 1,373 1,025 (347) 37.35% 20,630 10,315 10,996 681 53.30% 3,870 1,935 1,329 (606) 34.34% 1,500 750 - (750) 0.00% 4,400 2,200 1,953 (247) 44.40% 25,000 12,500 6,903 (5597) 27.61% 12,500 6,250 595 (5,655) 4.76% 269.655 134,828 123,218 _(17,610) 45.69% " Variance = Actual Iver (under) pirated budget Fund 000 By Dept PayE b vT 32 CII 1' cir IUKWID3/4 General Funa tApeaitureo - by Ue„artment As of Jane 30 2012 f03 MO* 11 SALARIES 12 EATRA LABOR 13 OVERTIME c1 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAE,DENIAL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 35 SMALL TOOLS & MINOREuUIPMEIGT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS & LEASES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 49-00 Miacellaneoc. 49-01 Mamburhipa, dues, subscriptons 49-02 Microfilm imaging 49-03 Employee recognition 4a-04 Recorded docomenb 49-05 Registrafiun5 49-08 Credit card tees 49-51 CTR rei buraement 49-53 Hearing a.aminer fasa 49-56 Gruen initiativua 51 INTERGVRNMTL PROFEaSICINAL SVCS 64 MACHINERY & EuUIPMENT (MAYOR 04 - HUMAN RESOURCES 11 SALARIES 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 41 PROFESSIONAL SERvICES 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS & LEASES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS ;HUMAN RESOURCES iArir►rta1 Bttdgei 1:001:516 15:500 573 71,953 89,697 4,167 173,067 33,556 4.9.35 759,470 85:300 19 800 17,250 28,108 14,500 176,799 .34,415 40,900 14,300 15,000 4,300 2,500 431 1,000 5,800 58,153 26,500 21,000 2;543,991 of year expired Ex1i -ted 13udget Actual Spent Varlaiice 500:758 7:750 287 35,977 44,849 2,084 86,534 16,526 2,468 379,735 42:650 9,900 8,625 14,054 7,250 88,400 17,208 20,450 7,150 7,500 2,150 1,250 216 500 L,900 29,077 13,250 10,500 Annual Budget 347,760 25,201 31,151 1,373 56,803 7,103 79,050 2,500 9,000 50 5,405 8,000 460,984 34,872 32,900 1,339 70,057 11,752 304,096 24,840 8,308 2,706 13,238 1,538 61:652 10,404 31,452 4,671 4,000 520 u3 5,, 0'v 10,633 1,173 (39,774) (7,750) (287) (1,105) (11,949) (745) (16,477) (5176) (2,468) (75,639) (17,810) (1,592) (5,919) (815) (5,712) (20,747) (6,804) 11,002 (7,150) (2,829) 1,850 (1.30) 57 5,200 (2,900) (18,444) (12,077) (10,500) 50.00% % Speit._._ 46.03% 0.007° 0.00% 48.46% 36.68% 32.13% 40.48% 34.71% 0.00% 40.04% 29.12% 41.96% 15.6"/0 47.10% 10.61% 38.27% 30.23% 76 90% 0.00A, 31 14% 93 Oct 20.80°;. 63 24% 570.00% 0 00% 18 28% 4.42% 0.00% 1,2714996 if035,+454t (T3g'542) Expected Budget actual Spent Vaila..ce , _ , % agent 573,396 173,880 179,240 5,360 51.54% 12,601 13,191 5a 1 52.34% 15,576 12,755 (2,820) 40.95% 68r 487 (200) 35.45° 28:402 28,259 (142) 49.75% 3,552 1,398 (2,153) 19.68% 39,525 14,378 (25,147) 16.1x% 1,250 60z (648) 24.09% 4,500 5:119 619 56.87% 25 14 (11) 27.40% 2,703 - (2,703) 0.00% 4,000 3,515 (485) 43.94% 286,698 258,958 t2rau) 45.76% Variance = Actual over (under) prorated budget Fund 000 By Dept Payee 7 of 3Z ut I y UF i OnvvID3/4 General Fund Expenditureb - by Departrrreirt Ab of June 30 2012 05 tFuoktiO 11 SAC/CRIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 II4DUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 46 INSURANCE 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 49-00 11iscellkneoes 4a-015 lreah cart] Fees 64 EXT TAXES & OPERATING ASSESSMENTS 64 MACHINERY s EQUIPMENT (FINANCE ;op - CITY ATTOrtREY 12 EA I RA LABOR 21 FICA 24 INDUSTRIAL INSOrcARICE 31 OFFICE & OPERATING SUPPLIES 41 PROFESSIONAL SERVICES 41-00 Professional services 41-01 Contracted Attorn;r ;rvices 41-02 Contracted pr,securion se. ..ce 4 F -us especial mauers 42 COMMUNICATION 4o OPE F IRIG RENTAL, & LEA,E, 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS CITY ATTORNEY Expected finuel B gat Buaget 978,689 489.345 10.000 5.000 1,147 574 72,356 36,178 87,592 43,796 4,118 2,059 205,614 102,807 24,849 12,425 190,000 x5,000 1,000 500 5,000 2,500 5,000 2,500 12,768 6,384 11,900 5,950 868 434 5,000 2,500 1,603 133 Annual Budaat 2,500 795 439 5,000 528.000 2,000 324,000 102,000 100,000 c,DOO 500 2,000 1,000 542,734 X801 567 `Expecte Budaat Act�,al Spent 7o of year expired al Spent Variance_ 429,446 5,371 32,843 31,094 1,336 88,812 5,273 81,476 305 673 6,475 352 10,642 6,702 x,940 6948101 1,250 3x8 220 2,500 264,000 1,000 162,000 51,000 50,000 1.250 250 1,000 500 2,322 222,586 297 127,259 95,030 60 271,,367 224,968 50.00% % Spent (59,898) (5000) 4,798 (3,335) (12,702) (723) (13,995) (7,151) (13,524) (195) (1 827) 6,475 (2,148) 4,258 L (2,500) (1O7M) va. nCe (1,250) (3x8) (220) (178) (41,414) (703) (34,741) (51,000 45,030 (1,250) (250) (1,000) (440) (4#6,399) 43.88% 0.00% 468.27% 45.3970 35.50% 32.44% 43.1970 21.2270 42.88% 30.54% 13.47% 0.00% 7.03% 83.35% 56.32's 403.9[:, 0.06% 0.00% 43130% 7o S,,unt 0.00% 0.00% 46.43% 42.16% 14.85% 39.28% 0.00% 95.03 0.00% 0.00% 0.00° 6.02% VaF lance = Actual over (ander) prorated badgat Fund 000 By Dept Page 8 ut 32 41.457° CITY OF TUKWILA General t-u5E1tApenaitureo - by Departu.te5t AS a Jane 30 2012 k07 - RECk2FJ4T10N 00 UNALLOCATED BUDGET REDUCTION 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 IEDICAL,DEN I AL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 34 ITEMS PURCH. FOR INVENT/RESALE 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 44 ADVERTISING 45 OPERATING REIN I ALS & LEASES 47 PUBLIC UTILITY SERVICES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOia 49-01 Printing ano Dinning 49-04 Trip admissions Seniors 49-05 Trip admissions Youth 49-08 Special Accomudatiol15 other 53 EXT TAXES & OPERATING ASSMNTS RECREATION !08 COMMUNITY DEVELOPMENT 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDiSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE.OPTICAL 28 UNIFORM CLOTHING 31 OFFICE & OPERATING SUPPLIES 35 SMALL TOOLS & MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 I RAVEL 44 RECYCLING - KC WRR 45 OPERATING RENTALS & LEASES 47 PUBLIC UTILITY SERVICES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 51 INTERGVRNMTL PROFESSIONAL SVCS 53 EXT TAXES & OPERATING ASSMNTS 64 MACHINERY & EuUIPMENT COMMUNITY DEVELOPMENT 7o of year u„ pirsd 50.007o Expected Annual Budget Budget Actual Spent Variance % Spent 0.00% 1,165,454 582,727 592,462 9,735 50.84% 296:627 148,314 101,098 (47,215) 34.08% 600 300 263 (37) 43.85% 130,960 65,480 52,374 (13,106) 39.99% 120,980 60,490 45,673 (14,817) 37.75% 35,855 17,923 12,15e (5,768) 33.91% 247,844 123,922 119,534 (4,388) 48.23% 81,188 40,594 28,588 (12,006) 35.21% 14,200 7,100 21,665 14,565 1oz.5f /0 200,666 100,333 38,081 (62,252) 18.98% 27,380 13:690 4.346 (9,344) 15.87% 8.000 4,000 913 (3,087) 11.42% 21,000 10,500 3,048 (7,452) 14.51% 55,861 27,931 1x,228 (8,702) 34.42% - 51 51 0.00% 32,550 16,275 15,778 (497) 48.47% 90,982 45,491 z5,855 t15,13az) 28.427° 3o,00 17,500 8,170 (9,331) 23.34% 10,800 5,400 1,347 (4,053) 12.47% 12,46. 6,230 581 (5,649) 4.66% 12,390 6,195 - (6,195) 0.00% 20,332 10,166 15,762 5,596 77.52% - - 20 20 0.00% 2,530,147 1,2074 1,081,1x1 183(933 42173% Expected Annual Budget Budget Actual Spent Varianw: % Spent 1,783,293 891647 916,371 24,724 51.39% 38,650 19,325 31,741 12,416 82.12% 4,672 2,336 1,904 (432) 40.76% 133,308 66,654 71,694 5,040 53.78% 160,852 80,426 67,895 (12,531) 42.217o 11.224 3,61z 5,RI9 JO 53.187° 275,436 137,718 135,684 (2,034) 49.26% 1,805 903 - (903) 0.00% 34,181 17,091 6,404 (10,687) 18.74% 600 300 - (300) 0.00% 86,283 43,142 6,743 (36,398) 7.82% 4,500 2,250 49 (2,201) 1.097° 12,500 8,c50 1,0f., (5,11,) 8.58% - - 2 2 0.00% 33,775 16,888 16,908 20 50.06% 1,000 500 - (500) 0.00% 62,190 31,095 8,321 (22,774) 13.38% 21,310 10,655 14,835 4,180 69.627° 18,000 9,000 10,214 1,214 56.75% - - 0 0 0.00% 17o000 87,500 (87,500) 0.00% Z858,579 1,429,290 1,795.808 (133,482) 45.33% Variance = Actual over (ander) prorated budget Funa 660 By Dept Page 9 of s2 uITY OF TUKWILA General tans tnpeiiait'ulrs - rsy uapartment A5 of Jane 30 2012 A9 IOIUNICIPAL COURT 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,CIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 35 SMALL TOOLS & MINOR EQUIPMENT 41 PROFESaIONAL SERVICES 4-0 I Pro Tem Judge 49-03 Interpreters 49-04 Court Security 42 COMMUNICATION 43 TRAVEL 45 OPERATING RENTALS & LEASEa 48 REPAIRS & MAINTENt{NCE 49 MISCELLANEOUS 53 EXT TAXES & OPERATING ASSMNTS MUNICIPAL COURT 111111.1111. 10 - POLICE 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 22 CEOFF 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 31 OFFICE & OPERATING aUPPLIES 35 SMALL IDOLS & MINOR EQUIPMENT I PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS & LEASES 46 INSURANCE 48 REPHIRS & M, INTENANCE 4a-00 Repair and m,ainterarl7e 48-01 800 MHZ radsesn1 rt 49 MISCELLANEOUS 49-00 Misuelia7u 49-03 &piore( ppcst 51 INTERGVRNMTE PROFESSIONAL SVCS 64 MACHINERY & EQUIPMENT POLICE Arintaladdgct 619,552 2,500 5,016 46,849 59,953 3,43c 102,906 10,908 1,200 108,000 13,000 53,000 42,000 5,550 6,215 2,300 19,438 Expected Budget Actual Spent 309,776 327,336 1,250 2,508 104 23.4z5 24,672 29,992 24.040 1,716 1,110 51.453 50,758 5,454 4,069 600 - 54,000 47,165 6,500 2,400 26,500 27,800 21,000 16,965 2,775 2,515 3,108 2,718 392 1,150 318 9,719 6,654 Va,;eme = Actual u.ur pldur) prorated budget 993;849 Annual Budget 7.209,468 5,000 930,062 544,835 325,645 93,745 137,676 1,642,640 156,428 600 48,175 62,031 23,300 800 908.531 225,080 167,894 109,394 58,500 56,z45 54,895 1,350 1,639,555 20,000 • 21,197,710 496,925 491;912 Expected Budget Actual Spout 3,604,734 3,392,174 2,500 465,031 477,189 272,418 293,965 16c,823 173,983 46,873 37,491 68,838 52,162 821,320 724,590 78,214 103,654 300 389 24,088 c8,5oi 31,016 28,284 11,650 26422 400 454,266 426,106 112,540 225,000 83,947 76,963 54,69! 56,429 z5,250 20,533 28.123 21.309 27,448 21,309 675 - 819,778 656,372 10,000 - . 7;098.5 % of year e,.pired 50.00% V_anance % Spent. 17,560 52.83% (1:250) 0.00° (2.344) 3.27% 1,247 52.66% (5,951) 40.08% (606) 32.35% (695) 49.32% (1,385) 37.31% 1600) 0.00% (0,835) 43.67% (4,100) 18.46°/ 1,300 52.45°/ (4,035) 40.39 (260) 45.32% (389) 43.74% 392 0.00% 0832) 13.81% (3,065) 34.23% 1 0.00% Mira) 49.50% Variance % Spent 6;744709 (212,560) 47.05% (2,500) 0.00% 12.158 51.31% 21547 53.95% 11,160 53.43% (9,382) 39.99% (16,676) 37.89% (96,730) 44.11% 25,440 66.26% 89 64.81% 4,570 59.49° (2,732) 45.60% 14,772 113.40% (400) 0.00% (28,160) 46.90% 112,460 9x.96% (6,984) 45.84% 1,732 51.58° (8,717) 35.10° (6,814) 37.89% (6,139) 38.82' (675) 0.00° (103,400) 40.03% (10,000) 0.00% (354,146] 47.51% Forel uuu By Dept Page 10 of 3z CITY uF TUKWILA General Fans Expenditures - l3y Uepertluent As of June 30 2012 11 -FIRE _ 11 SALARIES 13 OVERTIME lo HOLIDAY PAY 21 FICA 22 LEOFF 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 28 UNIFORM CLOTFIING 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 Misce aneous 49-05 Uniform cleaning 49-08 Credit card fear 51 INTERGVRNMTL PROFESSIONAL SVCS FIRE 42 - InrORMATION TECHNOLOGY 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES ao 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 & EuUIPMENT INFORMATIONatURNOWGY Annual Budget 6,139,765 416,552 178,248 89,288 264,752 32,766 167,746 1,599,900 1,140 187,080 28,500 65,300 44,670 14,500 489,962 90,000 60,000 41,000 99,601 73,083 26,000 518 285,420 l0308,193 Bud t 3,069.884 208,276 89,124 44,644 132,376 16,383 83,873 199,900 570 93,540 14,250 32,650 22,335 7,250 244,981 45;000 30:000 20,500 49:801 36,542 13,000 259 142,710 5,,1_4es�97 Expected Annual Budg t Budget 581,079 2,500 44,335 52,041 3,2z8 135,998 5,766 122.000 1,000 99,000 1,500 1,500 31,500 40,500 35 00 3,000 2,50- 32,000 1053,,a47 5761974 290,540 1,250 22,168 26,021 1,614 67.999 2,883 61,000 500 49,500 750 750 15,750 20,250 17,500 1,500 1,250 16,000 Actual Spent of year expired Variance 50.00% % Spent __ 3-073,449 175,475 47,247 152,418 11,205 60:268 678,554 79,462 26,474 33,876 10,296 1,763 245,916 90:000 36,546 43,521 14,118 13,512 121 485 152,389 4;932;976 Actual Spent 293,425 469 22,194 21,052 917 64 480 1,597 11,173 x+,379 '060 770 5,764 9,448 6,560 2,563 325 12,67o 499;Occ 3,565 (32,801) (89,124) 2,603 20,042 (5.1i 8) (23 605) (121,396) (570) (14,078) 12,224 1,226 (12,039) (o,461) 935 45,000 6,546 23,021 (35,682) (23,030) (12,879) zz6 9,679 50.06% 42.13% 0.00% 52.92% 57.57% 34.20% 35.93% 42.41% 0.000/0 42.47% 92.89% 51.88% 23.05% 12.16% 50.19% 100.00% 60.91% 106.15% 14.18% 18.49° 0.u7 53.39% (21'5(1 1;) 471,85%j 7° Spent Vadana.o 2,885 (1,250) 469 27 (4,968) (697) (3,519) (1,286) (49,827) (500) (70) 20 (9,986) (10,802) (10,940) 1,063 j9c5) (3,325) (77.:10-51) 50.50% 0.00% 0.00°/ 50.06% 40.45° 28.41 % 47.41% 27.70% 9.16% 0.00% 54.93% 45.32% 51.32% 18.30% 23.33% 1874 85.44 130 39.61% Variance = Actual over (under) prorated budget Fund 000 By Dept Paye 11 or 32 4,344% CITY OF TURVGIE General Fund Expenditures - By Department As of June 30 2012 013 -PUBLIC WORKS 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 40 OPERATING RENTALS & LEASES 47 PUBLIC UTILITY SERVICES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 49-00 Miacellaneo.s 49-08 Crodit card fcca 49-50 Neighborhood revitalizan 64 MACRINERY & EQUIPMENT PUBLIC WORKS RK.MAJRTENANCE 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 PRLIFt IONAL SERVICES 43 TRAVEL 45 OPERATING RENTALS & LEASES 47 PUBLIC UTILITY SERVICES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 63 OTHER IMPROVEMENT PARK MAJNTENANCE' of year c cpircd 50.00% Expected Ari uai Bridgat Buiaget Actual Spent Variance % Spent 1,912,535 956:268 8o0,434 3,500 1:750 4,556 2,278 3,077 140,874 70,437 63:888 171,274 85,637 60,852 28,420 14,210 8,792 387,934 193,967 152,309 3,800 1,900 205 99,460 49,730 47,814 3,750 1,815 1,863 10,400 35,200 10_375 7,750 3,875 1,875 800 400 518 177.745 88,873 77,716 379,449 189,725 155,397 165,521 52,761 76,325 21,035 10,518 5,x01 14,035 1,®15 2,217 L,000 1,000 645 5,000 2,500 2,945 35,000 12,754 31613,1803 1,789 402 1x529,998 Annual Buaget 411,43L 35,020 2295 31_000 36,844 10,973 72,300 1,425 36:968 1,500 25,000 70,270 149,000 40,000 4:000 7,000 935,027 Expected Budget AemaISp"snt 205:716 17510 1_148 15,500 18,422 5,487 36,150 113 18:484 750 12,500 35,135 74,500 20,000 2,000 3,500 467,514 246:142 197 18,353 17,543 5,743 39,101 23,904 382 10,852 98 36,018 o.3.760 9,604 2.219 463,914 (105,834) 44.47% (1:750) 0.00% 799 67.53% (6,549) 45.35% (24,785) 35.53% (5,418) 30.94% (41,658) 39.26% (1,095) 0.39% (1.916) 48.07% (12) 49.67% (24,825) 14.74% (2,000) 24.19% 118 64.74% (11,157) 43.727o (34,328) 40.95% (8,4.38) 46.11% (4,710) 27.61% (4,801) 15.79% (355) 32.27% '445 58.91% 36.44% (272,15 421349 Variance Y.. 40,426 59.83% (17,510) 0.00% (950) 8.59% 2,853 59.20% (879) 47.61% L7E oz.34% 2,951 54.08% (713) 0.00° 5,420 64.66% (368) 25.45% (1,648) 43.41% 98 0.00% 883 oi.LE% (20,740) 36.08% (10,396) 24.01°/ 219 55.49% (3,500) 0.00% (3,5991 49.62% " Variance = Actual over (under) prorated budget Fund 000 By Dept Payer 1 Z of 32 CITY OF TUKWILA General Funa txpeui iiurs - Icy Department A5 r.f Jine 30 2012 N6::MEER AINTEIVANCE?$'OPERATION 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL, DENTAL,LIFE,OPTICAL 28 UNIFORM C,LOTNING 31 OFFICE & OrERATING SUPPLIES 3o SMALL TOOLS & MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS & LEASES 46 INSURANCE 47 PUBLIC UTILITY SERVICES 4a REPAIRS & MAINTENANCE 49 MISCELLANEOUS 53 EXT TAXES & OPERATING ASSMNTS STREET MAINTENANCE & OPERATION_ Annual Budget 776,843 43,723 11,474 58,961 09,571 22,944 X81,8,9 2,375 318:800 10,931 4,000 4,300 2,700 1,500 381,943 35,455 716,836 27,100 5,200 2,67+6;535 Expected Budget Actual Spent 388,422 368,766 21,862 23,019 5,737 13,958 29,481 30,956 34,786 29,2L7 11,472 5,928 90,940 83.147 1188 586 159400 129,802 5,466 2,584 2,000 731 2,150 596 1,350 709 750 361 190,5/L 186,040 17,728 35,455 358,418 381-570 13,550 16,731 2,600 30 14 % of year eApired V-alienua 1,338.2681E314;240 50.00% 77° bvent (19,656) 47.47% 1,157 52.65% 8.221 1z 1.03% 1,506 52.55% (5,558) 42.01% (1.544) 43.27% (7,793) 45.72% (601) 24.69% (29,598) 40.72% (2,881) 23.64% (1,269) 18.27% 0,554) 1.3255% (641) 26.27% (389) 24.05% (4:931) 48.71% 17,728 100.00% 23,152 53.23% 3,181 61.74% (2,570) 0.58% 0.00% (24,052) ;0- CONTRIBUTIONS i FUND BALANCE Annual Budget Expected Budget Actual Spent Variance % Spunt 01 TRANSFERS OUT 26 UNEMPLOYMENT COMPENSATION 46 INSUrv1Nt,E 45 MISCELLANEOUS 49-00 Misaellaneoa� 49-01 Repair and demolition (building abatement) 49-03 Claims mid judgments 49 MISCELLANEOUS (C ONTRIBUTIONS,7,3FUND BALANCE 10,364,752 30,000 200,000 323,000 3,000 50,000 270,000 725,000 5,182,376 15,000 100,000 161,500 1,500 25,000 135,000 362,500 fi,ls44752 5;82,,376 x,054,815 11,537 222,738 179,187 179,187 LL5,000 4693;277 (2,127.561) (3,463) 122,738 17,687 (1,500) (25,000) 44,18,' (137:500) (21128,099) 29.47% 38.46% 111.37% 55.48% 0 66 31.03% 31.72% '• Variance = Actual aver (under) probated budget Fund 000 By Dept ,'aye 13 or 32 Ci i y OF i wswII7I General Fund Expenditures - By Category AS of Jane 30 2012 uuf year enpired 50.00% 'TOTALS BY i ATEGuRY Annual Budget 1Ezpected Budget Actual Spent Variance %Spent TRANSFERS OUT SAIDCRIES AND BENEFITS SUPPLIES PROFESSIuNAL SERVICES INTERGOVERNMENTAL CAPITAL EXPENDITURES Oran d Totals $ 10,364,752 33,702,558 1,193,673 8,180,993 L.694,475 307,000 $ 5,182,376 16,851,279 596,837 4,090,49( 1,347,238 153,500 $ 56,44,4-31 $ 28,2213726 _ $ 3,0+,815 $ (2,127,561) 15,908,818 (942,46i) 511,898 (84.938) 3,837,551 (252,945) 1:045;185 (302,053) 25,428 (128,072) $ 24,383,696 $ (3,838,030 29.47% 47.20% 42.88% 46.91% 38.79% 8.28% 43.20% TOTALS BY t.ATEGvRY — DETAIL Annual Budget Expected Budget Actual Spent Variance % Spent 00 MISCELLANEOUS GENERAL GOVERNM 1 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 15 HOLIDAY PAY L I FICA 22 LEOFF 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL_DENTAL,LIFI_,OPTICAL 26 UNEMPLOYMENT COMPENSATION 28 UNIFORM uLOTFIING 31 OFFICE & OPERATING SUPPLIES 34 ITEMS PURCH. FOR INVENT/RESALE 35 SMALL TOOLS & MINOR EQUIPMENT 41 PRuFESSIONAL SERVICES 42 COMMUNICATIOIQ 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS & LEASES 46 INSURANCE 47 PUBLIC UTILITY SERVICES 48 REPAIRS & MAIN 1 ENANCE 49 MISCELLANEOUS 51 INTERI.;VRNMTL PROFESSIONAL SVCS 52 INTERGVRNMTL PROFESSIONAL SVCS 53 EXT TAXES & OPERATING ASSMNTS 63 OTHER IMPROVEMENTS 64 MACHINERY & EQUIPMENT Grand Totals $ 10,364,752 23,105,109 455,5L0 1,376,947 178,248 1,403989 590,397 1.014,512 434_340 5,102,951 30,000 10,545 1,005,457 14,200 174,016 2,166,844 348,3e1 121,815 49;550 2,148,245 550,535 1,306,285 596,960 892,378 1,969,475 725,000 (,000 300.000 $ 5,182,376 1 052,555 227:760 688 474 89,124 701,995 295,199 507,256 217,170 2,551,476 15,000 5,z73 502,729 7,100 87,008 1,0E5.3,422 174,191 60,908 24,775 1;074,123 275,z68 653,143 298,480 446,189 984,738 362,500 $ 56�+4i3:451 " Va, ianca = Actual aver (andEr) p,:,rateed b6dget 3:500 150,000 28,22,1,726 $ 3.054,815 11,220,557 155,857 678,067 713.053 326,401 395,039 161,235 2,246,280 11,537 791 447,368 21.665 42,865 799,015 129,438 51,380 11,235 1,022,345 579,668 627,324 255,213 361,933 820,148 225,000 37 25,428 $ 24,383,696 $ (L, IL(,OB1) (331,998) (71,903) (10,407) (89,124) 11,059 31,202 (112,217) (55,935) (305,195) (3,463) (4,481) 55,361) 14,565 (44.143) (284,407) (44,753) (9,528) (13,540) (51,778) 304,401 (25,818) (43,267) (84,256) (164,590) (la(,500) 37 (3,500) (124,572) $ (3,838,030) 29.47% 48.56% 34.22% 49.24% 0.00° 50.79% 55.28% 38.94% 37.12% 44.02% 38.46% 7.50% 44.49% 152.57% 24.63% 36.87% 37.15% 42.18% 22.67% 47.59% 105.29% 48.02% 42.75% 40.56% 41.64% a I.O.s% 0.00% 0.00% 8.48% 43 20.% Fund 000 By Category Page 14 or 3z City of Tukwila Hotel/Motel Tax Fond 101 - Revenue and Expenditures As of Jane 30 2012 % of year expired 50.00% 2012 Expected Annual Budget Budget ActUal Year -1.7, -Date variance *' l nnual wedge( Revenue Gene/d/ Reveler Rotel/Motel Tadices Tota! Genera/ Reva„ae $ 385,401 $ 192,701 4) 219,130 $ 26,430 56.8670 385,401 192,701 219,130 26,430 56.86% Intargovornmental Revence 853,000 426,500 328,331 (98,169) 38.49% Misee//aneoes Revenue Invustmant Eaminga 1,766 883 z9c (591) 16.55% Other Misc Revenue 15,903 7.977 7,459 (518) 46.75% iofa,Miscellaneous Revenue 17.719 8,860 7,751 (1,108) 43.74% Total Revenue 1,256,120 628,060 555,213 (72,8411 44.20% Expandit„res 11 Salaries 283,378 141,689 141,650 (40) 49.99% 12 Extra Labor 24,000 12,000 10;338 (1,662) 43.08% 13 Ovartimo 10,110 5,055 0,082 527 55.22% 21 FICA 21,679 10,840 11,934 1,095 55.05% 23 PERS 25,380 12,690 11,096 (1,594) 43.72% zit Industrial Insurance 2,033 1,017 638 (379) 31.37% 25 Medical, Dental, Life, Optical 38,304 19,152 19,645 493 51.29% 31 Office & Operating Supplies 16,000 8,000 18,353 10,353 114.70% 41 Professional Services 223,000 111,500 74,797 (36,703) 33.54% 42 Communication 60,000 30,000 44,090 14,090 /a.4% 43 T.evel 23,000 11,500 1089 (3,911) 33.00% 44 Advertising 001,000 328,500 336,831 8,331 51.27° 45 Operating Rentals s Leases 49,000 24,500 20,986 (3,514) 42.83% 4/ Public Utility Services 1,500 750 428 (322) 28.56% 48 Repairs & Maintenance 1,000 500 396 (104) 39.56% 49 Miscellaneous 21,400 10,700 27,086 16,386 126.57% 64 Capital Outlay 10,000 5,000 - (5,000) 0.00% Thiel HatahMutu! Taw Fund 1,466,784 733,392 131,4a9 (1,953) 49.87% Transfers Out / Ineirect cost allocation Total ,>ditures Change 1.1 Fund Balance Beginning Fund Balance 96,937 48,469 48,468 (0) 50.00% 1,563,721 781,861 779,908 (1,953) 49.88%1 (307,601) (153,801) (224,695) (70,895) 73.05% 781,568 787,568 787,568 - 100.00% Ending Fund Balu tm 479,967 5 633,768 $ 562,873 $ (70,895) 117.2770 Cash and investments $ 440,145 " = Actual over (undo') prorated budget Fond 10'l !Dago 15 or 32 City of 1 URwila Street Fund 103 - Revenue and Expenditures As of Juno 30 2012 %. of year expired 50.00% 201z Expected Actual % atAnnal Annual Budget Bulger rear -To -Date Variance'` .Budget Revenue Intergovernmental Revenue (MVFT Taxes) $ 232,000 $ 116,O0u $ 125,039 9,039 53.90% Miscettanems Revenue Investment Earnings 1,000 500 605 105 60.47% Tota/ Misce//aneovs Revenue 1,000 500 50o 105 60.47°/ Transfe,a In 220,000 110,000 (110:000) 0.00% Tura/ Revenue 453,000 226,500 125,644 (100,856) 27.74% Expandltures 11 Salaries 21 FICA 23 PERS Industrial Insurance 25 Medical, Dental, Life, Optical 41 Professional Services Tota/ 650,000 650,000 2,170 2,170 0.00% 159 159 0.00% 156 156 0.00% 6 6 0.00% - 204 204 0.00% 325,000 40,838 (z84,152) 6.28% 325,000 43,532 (281,468) 6.70% Transfers Out/ Indireut cost allocation 11,594 5,947 5,547 0 50.00% Total Expend/turc 661,894 300,947 49,479 (281,468) 7.48°/. Chang in Fund Balance Beginning Fund Balance (206,594) (104,447) 76,165 180,612 -36.46% 903,937 903,937 903,937 - 100.00% Ending Fund Balance $ 695,043 5 799,4y0 $ 980,102 y 180,612 141.01% Casn and investments $ 938,114 " Variance = Actual uvur (,:,,der) p,urated budget Fano 103 Page 16 of 32 City of Tukwila Arterial Street Funa 104 - Revenue and Expenditures As of June 30 201z % of year expired 50.00% 2012 Expend Aline& Budget 13ua$at Actual Y ar-To-bale Variance" % of Amiga' Budget Revenue General Revenue ranting Taxes Meal (state tACise 1 awes Total General Revenue Intergovernmental Revenue Miscellaneous Revenue Investment Eamings L,ontrioutions/Donations total MMlisceneneous Revenue !weer In Dept Proceeds 111.257 10u,uuu 211.25/ 9,941,581 3,820 466,000 469,820 z,000,00U 9,z3u,u0u 55,629 50,000 1 US,ti29 4,9 /0,791 1,910 233,000 234;910 1,000,000 4,615,uuu 72.646 34,4zy 107,075 1,858,583 17:605 16,175 33,780 17,01( (15,571) 1,440 (3,112,z07) 15,695 (216,825) (201:130) (1,000:000) (4,615,000) 65.30% 34.43% 50.68% 18.70% 460.85% 3.47% /.19% 0.00° 0.00% /War KevE..ue Expenditures 11 Salaries 12 EAt, a Labor 13 Overtime 21 FICA z3 rERS z4 Industrial Insurance z5 Medical, uental, [ire, Optical 31 umce & operating Supplies 35 Small 1.7.7,6 E. minor Equipment 41 i'Mreaaional .1 c, vIC'cs 43 1 ravel 44 Adverti6irlg 45 Uperatiny Rentals F. Leases 47 i-'oblic Utility Services 48 Repub. & Maintenance 49 Miscellaneoas 64 Capital Outlay fatal Arta, ial Streets 104 i ransfers Out f Indirect cost allocation / otaT enaurures Chanye i„ Fand Balance Beyinniny Fond Balance )=n Ing run? Sarance 9.15% z1,a5Z,o58 10,226_$29 1,999,438 (8,926,891) Casn and inveatmcnts 207, / 68 3,000 15,417 18._606 686 27,727 4,559,000 11,221,00u 16,u83,z04 386,563 16,469,767 5,38z,891 ti,9z9,39ti $ 12,312,287 " Variance = Accual over (under) prorated budget 103:884 1,500 7,709 9._303 343 13:864 2,294,500 5,610,500 8,041,602 193,282 8,234,884 z,ti91,446 6,9z9,396 9,620,842 217,766 3,548 16,621 15 834 1.438 34,357 340 949:540 10 2:245 1.011 750 9z,4 / 2 /ZZ 3,057,611 4,394,514 193.281 4,587,796 (z,588,358) 6,929,396 113,88z (1,500) 3,548 8,913 6,531 1,095 20.493 340 (1:344,960) 10 2,245 1:011 750 92,472 722 (z,55z,889) (3,647,088) (0) (3,5414088) (5,z79,8u3) 4,341,038 $ (5,279,503 $ 2:055,132 104.81% 0.00% 0.00% 107.81% 85.10% z09.62% 1 z3.91% U.UU% U.00% 20.69° 0.00% 0.00° 0.00% 0.00% 0.00% 0.00% 27.25% 27.32% 50.00% 27.56% -48.08% 10U.00% 3536% Fund 104 Paye 17 of 32 1,5U0,908 958 (1,499,950) 0.03%1 City of Tukwila Contingency Fun 105 - Revenue and Expenditures As or June 30 2012 % of year eApird 50.00% Expected a at % a Annum Aiwaal Baayet budget `Year-uata - variance** Budget Revenge miscellaneous Revenue Investment Earnings $ 1:816 $ 908 $ 958 $ 50 Total Miscellaneous Revenue 1,816 908 958 50 transfers In 3,000,000 1,500,000 (1,500,000) 52.74% 52.74% 0.0U% Total R@veno@ 3,001,816 GRange in Fond Balance 3,001,816 1,500,908 958 1,4a9,950) 0.03% Beginning Fund Balance 1,457,728 1,457,728 1,457,(28 100.00% (miry FvnO (Sahni.@ $ 4,459,D44 $ 2,953,555 $ ,458 686 $ (1,499,950) 32.71% Gash and investments $ 1,458,686 Variance = Actual over (ander) prorated 5udgget Fund 105 Paye 18 of 32 City of TuRwila Flre Equipment Gum. deserve 107 - Revenue and Expenditures As or June 30 2012 % of year expired 50.00% 20.12 Expected Ai tuai % yr Ann. Dal ignnual Budget Budget Year -To -Date _ Variance" Bedgef Revenue Miscellar'emos Revenue Investment Eamings $ 1,685 $ 843 $ 6z0 $ (222) 30.81% Tufa/Mi cellaneou. Revenue 1:685 843 635 (z07) 3i.ru°ro I,an31Zra In i30,u0u o5,500 (65,000) 0.00°/ Total Revenue 131,685 65,843 935 to5,2ui1 U.497o EApendltoree 31 urnce & uperating Supplies 2,000 1,000 6.393 5.393 319.63% Transrers uut 7 indirect cost allocation 561 28 281 - 50.00° iatm Expena1tures zao1 1,281 6,673 5,393 260.57% l;nanyF.,.d BelanCi: 12,,124 64,5oz (6,038) (70.600) -4.68% Ba ins piny Fund Balance 890,7,7 8,0,797 a,0, r,7 - 100.00% Eil71ny hvnd idalani.c —S — ,U79,9L7iris 955,35s $ e8 ,759 $ (7u,ou0) 86.75% l;aan and invaat„ant3 variance = Actual over (under) prorated budget $ 943,850 Nina 1U( Page 19 of 32 laity of Tukwila Drug Sechar Funa 109 - Revanrand Expenditures A5 UT JURE 30 2012 % of year expires 50.00% zulz Egpectea�►ctu'aI % of Anneal Animal Budget: B.,aget yza -T mate Variance" Budget Revenue Miami/eh-mum Revenue L,mstment Earnings $ 1,000 $ 500 $ (0) $ (500) -0.01% SGILul ROtlGnYG 20.000 10,000 - (10,000) 0.00% leo/ Miseellanenaa Revenue 21,000 10,500 (0) (10,500) 0.00% TranaTcr In 75,000 37:500 (37,500) 0.00% Total Revenue 96,000 48,u0u tui (48,000) 0.00% Expenditures 31 vmce &Operating Supplies 3,000 1,500 719 (701) 23.96% 35 Small Tools & Minor Equipment - - 1,09 1,639 0.00% 41 Professional Services 10,000 5,000 - (5,000) 0.00% 45 Operating Rentals & Leases 10,000 5,000 - (5,00U) 0.00% 49 IGliscellaneous 2,000 1,000 600 (400) 30.00% 64 L.apital Outlay - - 4,557 4,551 - TATExpenditures 25,000 1z,a00 7,515 ` (4,a55) 30.06% Change in Fond Balance Beginning Fund Balance Ending Fund. Balance Cash and investments 71,000 35,500 (7,515) (43,015) -10.58% 229,711 z29,711 229,711 100.00% $ Nut/11 $ 26$,z11 $ zzz,1a6 $ 43015• 73.89% $ 222,196 Variance = Actual over (under) prorated budget Fund 109 Page 20 zf 32 City of Tukwila Debt service Funds 2XX - Revenue and Expenditures As of June 30 2012 % of year expired 50.00% 201-2 Expedia Actual % of Annual Anneal budget o dgat YaarTu-Date variance** budget Revenue Intergovernmental Revenue 66,657 33,329 33,329 (33:328) 50.00° Miscellaneous Revenue Investment Earnings $ 3,000 $ 1,500 $ 14,125 $ 11,125 470.85% Debt proceeds - - - - U.uu°/ Total Miscellaneous Revenue 3,000 1.500 14,125 11,125 470.85% Transfers In 3,446.252 1.723:126 2,893,085 1,169.959 83.95% Total Revenue 3,515,999 1,/57,955 2,940,539 1,147,756 83.o47° E,.po ,ditares 80 Debt Service Principal 2,633:458 1,316,729 (1,316,729) 0.0070 81 Debt Service Interest 1,166538 583,269 624,021 40,752 53.49% Total Debt Se, vice Funds 3.799,996 1,899,998 624,021 (1,275,977) 16.427° Transfers Out / Indheut cost allucatioil 0.9070 TOtall=itpeudltures 3,799,996 1,899,998 624,021 (1,2/5,977) 10.427° Change in Fond Balance (284,087) (142,044) 2,316,518 2,458,561 -815.43% Beginning Fond Balance 3,316,312 3,316,312 0.00% Ending Fund:Salance (-284,937) S (14-2,944) $ 5,632,839 5 rtri 8r3-1ai'sz.73% Lash and investments $ 5,688,409 variancm = Actual over (ander) prorated budget FDA LAA Page 21 of 32 City of Tukwila Open Space and Parks Acq. Fund 301 - Revenue and Expenditures Aa of June 30 2012 ° year uxpirod 50.00% 2012 Expocted Annual Budget Bud, t Actual Year -To -Date $ Varlarice* 5/..- of Annual Budget Revenue Genera/ Re.enuc Pror.,ft9 Tax`s Rua! Estate Excise Taxes Teta/ General Revenue Charges for Services Park Impact Fees Total Charges (of Set vices Intergovernmental Ruvenoe Miscellaneous Revenue Investment Earnings Rents and Concessions Total Misce/laneova Revenec BUM $ 32,500 $ 100450 50.125 165,250 S4525 25,000 12,500 25,000 12,500 500,000 250,000 7,000 3,500 5,000 2,500 12,000 8,000 Total Revenue Expenditures 11 Salaries 21 FICA La PERS 24 Indostrial Insurance 25 Medical, Dental, Life, Optical 31 Offiee & Opuratiny Supplies 41 Professional Services cc /Advertising 48 Repairs & Maintenance 64 Capital Outlay Tufa/ Park Acquisition Fund Transfers Out / Indirect cost allocation Tota Expe..d turew Change in Fund Bala race Beginning Fund Balance Ending Fund Balance Cash and investments 702,250 0 351,125 0 239,000 1,810,000 2,049,000 32,016 2,081,016 (1,378,766) 1,427,973 22:733 $ (9,767) 34.97% 34.546 (15,579) 34.46% 57,279 (25.346) 34.66% 4,986 (7,514) 19.95% 4,986 (7,514) 19.95% (250.000) 0.00% 1,080 (2,420) 15.ca% 3,743 1443 74.86% 4,824 (1,176) 40.20% 67,989 0 064,036) 9.55% 6,781 6,781 0.00% 503 503 0.00% 485 485 0.00% 18 18 0.00% 1.041 1.041 0.00% 2,248 2,248 0.00% 119,500 47,608 (71,892) 19.92% 865 865 0.00% 17,782 1,,,82 0.00% 905,000 3,742 (901,258) 0.21% 1.024,500 81,073 (943,427) 3.96% 16,008 16,008 50.00% 1,040,508 (689,383) 1,427,973 97,081 (943,42,) 4.67% 49,207 $ 738,590 (29,992) 659,..391 L. r 6% 1,4z, ,, 0 100.00% 5 1,397;981_ $ 659,391 2841,02% 5 1,633,257 Variance = Acura' over (under) prorated budget Fund 301 Paye 22 of 32 (Ay uT 1 URCwjIa Facility Replauument Fai,a 302 - Revenue aria EApenaitares As vT Jane 30 2012 aT yea, cnpirsa Su.Uu% 2uir Expected Annual Budget baaget At -Ea' % OrAfi 6a1 'Yo7aW:ezDate vaRemee*' Budget_ Revenue Cnarges ror Services Sales and use !axes t uta& Charges mr Savviecs Miscenaneous Revenue Investment Eamings otai IDlrs =naneous Revenue 3z6 $ 163 $ 25 $ (138) 7.82% 326 163 25 (138) 7.82% 5,602 2,801 1,326 (1,475) 23.68% 5,602 2,801 1,326 (1,475) 23.68% 5,9L8 late Kevenue 4e64 11352 (0,61Z) ZZ.317o EApenaitores 11 Salaries 239 239 0.00% 21 FICA 18 18 0.00% 23 PERS 11 17 0.00% 24 industrial inserance 1 1 0.00% 25 Medical, Dental, Lire, Optical - I u 10 0.00% 41 F'rmtessiaral Services 14,0Uu 7,u00 5,125 (1,8(5) 36.61°/0 47uolic utility Services - - 3,x32 J,`JJZ U.55% TataIEApendtmes 87,000 43,500 9,342 (34,158) 10.74% I ransters Oat I ledi,Cot cest alID�atian Total Expenalrrgs Chanye in Fund Balance Beginning Fund Balance 1,127 564 564 u 50.00% 88,127 441964 8,995 (34,158) 11747o (82,199) (41.100) (8:554) 32,546 10.410/0 2,027:014 2.027,014 2:02/_014 - 100.00% Ending Fund„Balance $ 1,944,815 $ 1.985.915 2,018,460 $ 32,546 10319% uasn a„d in„astrnents $ 2,u18,535 -- Variance = Actual ever (a,dlei) pruiatad budget Fund 302 Pagu 23 at 32 City ot Tukwila general ucvem...ent ImprovEments 3033 - Revenue ana Expenditures As or Junc 30 "-U1"z % of year expired 50.00° 2012 i=xpeczed Aival Annual Budget Budget Yeas-i=uar vafian:.a'*` % ut An enl Budget Revenue intergovernmental Revenue miscellaneous Revenue inva5tmunt Earnings 1 e a/ m/;5ca11aneuds Revenue 1 ransTers In $ 58,077 $ 29:039 $ 66,056 $ 31,018 842 421 343 (18) 64z 421 343 (78) 1,650,000 825,000 (825,000) 113./4% 40.//% 0.00% Total Revenue Expenditures 11 Salaries 13 Overtime z1 FICA z3 PERS 24 Industrial insure, 25 Medical, Dental, Lite. Optical 31 Office & Operating Supplies 35 Smad 1 cols & minor Equipment 41 Prcressional Services 44 Aavertisi 48 Repairs & Maintenance 49 Miscellaneous 64 Capital Outlay i otat Fire Impact Fees 1,708,919 854,40U oo,4UU (1 88,uou) 3.89% 7,819 6,600 1,100 14, /96 440,000 1,860.000 46,048 3,910 4,400 550 /,399 220,000 930,000 2,429,813 1,214,907 I ransters out 7 Indirect cost allocation z6,6 / 3 Tata/ Exprn alLQias z,45b,415b Unenya In Fund Balance (/4/,56/) Beginning Fond Balance 608,613 Ending Fund Balance Cash and investments 13,337 1;zz`az44 (373,784) 006,01 J 23,557 343 1,769 1,698 376 3,931 5, 092 4,930 80,412 1.145 3/,474 5,05/ 18,43U (25,091) 343 (2,121) (2:702) (174) (3,462) 5,69z 4,93U (139,588) 1,145 37,474 5,057 (911,5(0) 184.839 13,337 (1,030,068) 1.985175 (1,030,068) (131,776) 608,613 242.008 $ (138,854) $ zs4,33u $ 4i,is3, o $ z4z,u08 $ 433,659 Vallance = Actual uvar (ufacr) NrGiatza ouMyct 24.21% u.oO% 22.8810 19.30° 34.16% 26.60% 0.00% 0.00% 18.28% 0.000/5 0.00% 0.00% 0.99% /.b17o 50.00% 8.07% 1(.63% 100.00°/ 343.16% Fane 3113 Page z4 of 32 City of Tukwila Fire Impact ree304 - Revenue ana Expenditures As or June 30 2012 % of year expired 50.00% 2012 txpecra Annual Budget Budget 7car-Tv-ba VBrIanC@ % of Annual auaget Revenue Charges ror Services Fire Impact Fees $ 50,000 $ 25,000 $ 3,694 $ (21:306) 7.39% ,otal Charges ror Services 50,000 25,000 3,694 (21,306) 7.39° In„u3tmnt Earnings iu0 50 164 114 164.48° ,otal Miscellaneous Revenue 100 50 164 114 164.48% Total Revenue 56,166 25,050 3,859 (21,191) 7.70% Expenditures 64 capital Outlay Total Upe..a:toras 0.00% 0.00% unanga in Fend Balance 50,100 25,050 3,859 (21.191) 7.70% Beginning Fund Balance 313,519 313,519 313,819 100.00% t..ding FvnO Ha7ance $ 363,w i , $ 338,869 $ 317,678 $ (21.191) 87.29% cash and investments $ 317,677 " Va Sanaa = Actual oval (cind�) piortud Budget lona 3U4 Page 25 of 32 °%6 Annui j Budget 44436 1.09.1370 laity of I uKCWiLa Water Fund 401 - Revenue and Expunsus A� cf June 30 2012 % of year expired 50.00% e 2012. F.xpctea Annual Budget Budget Actual Year -Tu -Date Variance*' w Ruvunue Charges Se, vies Wate, Sales Security t utel Charges for Services Miscellaneous Reve„ve Invest tent Earni cgs cvnncCtian f0E3 Other Misc Ruvenuu Total Miscollanzous Revenue Transters In hydrant r ntal Total Revenue Expenses 11 Salaries 12 Extra Labor 13 Overtime 21 FICA 23 PERS 24 Industrial Insmanee 25 Medical, Dental, Lift, Optical 26 Unampluymunt Compensation 28 Unirorm Clothing 31 iffice & Operating Supplies 33 Water Purchased for Resale 35 Small Tools & Minor Equipment 41 Professional Services 42 Communication 43 Travel 45 Operating Rentals & Leases 46 Insurance 47 Public Utility Surrices 48 Repairs & Maintenance 4a Miscellaneous 53 Exciaoo Tars 54 Interfund utility taxes 64 Capital Outlay 50 Debt Service Principal 81 Debt Service Interest Total Wate, Fond Transfer Out / Indirect cost allacati.n Tota/ Expense -a Change in Fund Balance Beginning Fund Balance ;Ending Fund Balance Cash and investmcids $ 5,041,000 1,000 5,0ez,000 9,234 25,000 300 34,5.,4 106,000 5 �i 82,5s4 556,692 6,000 5,738 42,472 49,851 14,137 113,690 1,000 1,330 93,181 2,068,000 9,500 314,300 2,500 1,500 60,919 20,260 23,000 3,000 14,811 184,000 517,000 1,287,000 128,881 5,989 5,524,751 517,377 6,u42;:i28 (859,594) 6,043,694 $ 2.5z0,500 500 2,521:000 4,617 12,500 150 17,267 53,000 2,591,267 278,346 3,000 2,869 21,236 24,926 7,069 56,845 500 665 46,591 1,034,000 4,750 157,150 1,250 750 30,460 10,130 11,500 1,500 7,406 92,000 z58,500 643,500 64,441 2,995 2,762,376 258,689 3,u21,0o4 (429,797) 6,043,694 $ 2:208,238 60 2,208,298 5,.,76 2,399 80 7,855 49,2.,0 2,2b5,383 272,001 3,680 20,980 19,711 5,591 60,439 205 57,335 1,059,074 5,848 47,738 302 1,304 30,425 20,260 5,444 2,624 21,636 83,698 220.990 65,012 310,000 75,909 2,393,205 258,689 z. 51,894 (386,511) 6,04.,,694 $ (312.262) (440) (312,702) 759 (10,101) (70) (9,412) (3,770) (325,884) (6,345) (3.000) 811 (256) (5,214) (1,477) 3,594 (500) (460) 10,744 25,074 1,098 (109,412) 1948) 554 (34) 10.130 (3,056) 1,124 14,230 (8,302) (37-510) (578,488) 245,560 72,914 (.,n,170) .(3691170) 43,286 (0) 43.81% 6.00% 43.80% 58.22% 9.590/0 26.67% 22.75% 46.44% 43.71% 48.86% 0.00% 64.13% 49.40% 39.54% 39.55% 53.16% 0.00% 15.41% 61.53% 51.21-/a 61.56% 15.19% 12.0/% oti.a.,% 49.94% 100.00% 36.71% 87.46% 146.08% 45.49% 42.74% 5.05% 240.53% 1267.47% 43.32% 50.00° 43.89% 44.96% 100.00% 50100 _5,613897 5 i506,7189 $ 3,982,420 _= Variance = Actual over (untler) prorated budget Fund 401 Page 26 ut 32 City Cot I uRwila Sewer Fand 402 - Revenue and Expenses As of June 30 2012 % of yea; expir8 50.00% zuu Annuli esecl0et Expected budget Aival Maar-s o- iat vanan;.e *'' '% of Annual Budget Ravenna Charges for Services Sewer Sales Toral Charges for Services Miscellaneous Revenue Investment Earnings Connection fees Tata/ Miscellaneous Revenue luta, xevenue Expenses i 1 Salaries 12 Extra Labor 13 Overtime 21 FICA 23 rErcS 24 Industrial Insurance 25 Medical, Dental, Lite, Optical 26 Unemployment Compensation 28 Unitonn clothing 31 Office & Operating Supplies 33 Metro Sewage Treatment 35 Small Tools & Minor Equipment 41 Rofessional Services 42 communication 43 Travel 44 Advertising 45 Operating Rentals & Leases 46 Insurance 47 Public. Utility Services 48 Repair & Maintenance 49 Miscullanucus 53 Excise Taxes 54 Interffund utility ta,. 64 capital Oauay 80 Mot ServiCe Principai 81 Dubt Sc vice Interest tote' Sor.'cr Fand Transfers Out/Indirect cost allocation Total Expenses Change in Fund Balance Beginning Fund Balance Fior„g Fund Balance Casty and investments $ 5,398,000 5,398,000 4,426 120,000 124,426 5,5ZZ,4Lb 26 r ,360 8,000 3,442 20,338 23,943 6,156 50,356 1,000 570 22,4e1 3,74e,000 4,000 161,600 2,500 5uu 150 124,415 15,1e5 22.050 43,000 8,799 40.000 543,000 770,000 272,861 12,688 6,173,414 446,980 6,620,394 (1,097,968) 1,890,166 ‘/1177,1193 $ 2,699,000 $ 3:050,178 $ 351:178 56.51% 2,699:000 3,050,178 351.178 56.51% 2,213 60,000 62213 2,761,213 133,680 4,u0u 1,721 10,1ti 1 11,U/2 3,078 25,178 500 285 11,246 1,874,500 2,000 80,800 1,250 250 75 62,208 7,598 11,025 21,5uu 4-400 20,000 271,50u 385,uuu 136,431 6,344 3,086,707 223,490 3,310,197 (548,984) 1,890,166 1,s41�15z 1,224 34,200 35,424 3,103;,127 157,587 1,050 2,072 12,185 11,41'2 2,512 29,e96 9,271 1,627,763 670 11,06e 783 297 61,208 15,195 12,542 21,010 18.890 36,221 305,068 316,152 20,049 2,673,005 223,490 2 896 495 206,632 1:890,166 (989) 27.65% (25,800) 28.50% (26,789) 28.47% 3411914 56.1'9% 23,907 58.94% (2,950) 13.13% 351 60.21% 2,016 59.91% (559) 47.66% (566) 40.80% 4,818 59.57% (500) 0.00% (285) 0.00% (1,975) 41.227o (246,737) 43.42% (1,330) 16.76% (69,731) 6.85% (467) 31.33% 47 59.42% (75) 0.00% (1,000) 49.20% 7,598 100.00% 1:517 56.88% (4e0) 48.86% 14.491 214.69% 16,221 90.55% 33,568 56.18% (68,848) 41.06% (136,431) u.u070 13,705 158.02% (413,702) 43.3070 (0) 50.00% (4131702) 43.75% 755,616 -18.82% 0 100.00% „$ 2096,798 $ 7x5,616 1,238,0e0 A04.wsry° ** Variance = Actual over (under) prorated budget Fund 4uz Page 27 of 32 L Ity uT 1 uRwila Foster Galt Course 411- Revenue aria E..penses As or June 30 2012 % of year expired 50.00% 201,z Expactaa Annual Budget fluaget Actual Year -7c -Deter Variance " % of Annual tsuaget Revenue General Revenue Excise Tawas Total Gene, al Revenue Charge, for Surv,ce5 Sale of Merchandise Greens Fees, Inst, action Total Charges fu, Se, vRC3 Miucellaneou5 Revenue Investment Ea, ,ings Rents and Concessions Othei Misc Revena� Total Miscellaneous Revenue Transfers In Total Revenue Expenses 11 Salaries 12 Extra Labor 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical cg Unemployment Compensation 28 Uniform Clothing 31 Office & Operating Supplies 34 Items Purchased for Resale 35 Small ToeIs & Minor Equipment 41 Professional Services 42 Communication 43 Travel 44 Advertising 45 Operating Rentals & Leases 46 Insurance 47 Public Utility Services 48 Repahs & Maintenance 49 Miscellaneous 53 Excise Tanes 54 InteFlund admissions te.. 64 capital Outlay 80 Debt Service Principal 81 Debt Service Interest Total Foster Gulf Coor,e Fund Transfer Out 7 Indirect must allocation Waft* Change in Fund Balance Beginning Fund Balance Enoing Funa Balance Cash and investments $ 1,617 $ 809 1,617 809 151,000 1,205,500 1,356,500 1,130 331,000 332,130 225.000 1,915,247 686,142 133,900 6,885 51,306 61,449 15:565 123,977 11:000 1,164 98,908 100;500 2,500 10,000 9,700 1,250 7.000 101,650 15:195 64,765 36,000 39,722 6,000 67,000 25,000 1,706.578 15,160 1421448 193,509 14,550 £;4,059 75,500 602,750 678,250 565 165,500 166,065 112,500 957,624 343,071 66,950 3,443 25,653 30,725 7,783 61,989 5,500 582 49,454 65,250 1,250 5,000 4,850 625 3,500 50.825 7,598 32,383 18,000 19,861 3,000 33,500 12,500 853,289 7,580 86u,1309 96,755 140,550 237,305 $ 1,455 1,455 $ 047 647 65,585 (9,915) 445,468 -1-57-,282) 511,053 (167,19,) 8,871 116,040 (94) 124,817 112,500 /49,825 304,654 38,562 282 25.869 23,834 7.416 52,482 25,928 46,673 876 4.630 1,587 127 1,252 48,568 15,195 23,534 11,961 15,846 1,798 26,038 677,112 7,580 oa4,6y2 65,133 140,550 3 205,683 1111.1.3151 $ 114,058 8,306 (49,460) l94) (if ,ca8) (207,799) 89.98% 89.98% 43.43% ae.5% 37.67% 785.04% 35.06% 0.00% 37.58% 50.00% 39.15% (38,417) 44.40% (28,388) 28.80% (3,160) 4.10% 216 50.42° (6,890) 38.79% (367) 47.647o (9,507) 42.33% (5,500) 0.00% (582) 0.00% (23,526) 26.21% (18:577) 35.76°h (374) 35.04% (370) 46.30° (3,263) 16.36% (498) 10.19% (2,248) 17.89% (2,257) 47./8% 7,598 100.00% (8,849) 36.34% (6,039) 33.23'° (4,015) 39.89% (1,c0c) 29.96% (7,462) 38.86% (12,500) 0.00% 0.00% 0.00% (176,177) 39.68% (0) 50.00% (175,177) 39.77% (31,621) 33.66% 0 100.00% (31,621) 61.57% _- Variance = Actual over (under) prorated budget Fona 411 Page 28 of 32 City Ot TuRwila Surface Water Fund 412 - Revenue and EApenses As of Jane 30 2012 of yea, eApired 50.00% '2072 'Expected Annual Budget Budget A� aI 4'_ :,f Annual Yeac��,nate' Varian Budget Revenue Charges for Services Surface Water Sales Total Charges for Services Intergovernmental Revenue Miscellaneous Revenue Investment Eamings Other Misc Revenge Total Miscellaneous Revenue Total Revenue EApenses 11 Salaries 12 Extra Labor 13 Uvertirne 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 26 Unemployment Compensation 28 Uniform Clothing 31 Office & Operating Supplies 35 Small Tools & Minor Equipment 41 Professional Services 42 Connnanication 43 Travel 44 Advertising 45 Operating Re,dals & Leasers 46 I, su, anee 47 Public Utility Services 48 Repairs & Maintenance 49 Miscellaneous 53 Excise Taxes 54 Inturf,.nd motility tax 64 Capital Outlay 80 Debt Service Principal 81 Debt Service Interest Total Sr?rram Wafer Fend i ransfers Out Tobe! Expenses Change in Fuld Balance Beginning Fu„d Balance $ 3,660,309 $ 1,830,155 $ 1,823,614 $ (6,540) a,8B0,o0a 44.000 11,091 11,091 3,715,400 721,168 23,000 11,653 54,463 64,589 17,301 167,666 1,000 1.425 42.521 3000 628:570 2,000 2,000 500 96,638 15,195 61,600 13,965 8,685 25,000 371,000 1,510,000 286,554 30,514 4,160,007 1,830,155 22,000 5,546 5,546 1,857,700 360,584 11,500 5,827 21,232 32,295 8,651 83,833 500 713 21,261 1,500 314,285 1,000 1,000 250 48,319 7,598 30,800 6,983 4,343 12,500 103,500 755,000 143,277 15,257 2,080,004 400,786 200,393 4,560,793 2 280 397 (845,393) 2,151,147 (422,697) 2,151,147 1,823:614 63,744 10814 162 10:976 1,898,334 336;599 7.815 6,958 26,549 24,750 8.138 71;861 103 27,347 279 174,909 361 1,654 963 40,416 15,195 56,i70 1,407 21,333 24.998 183,256 12,951 6,873 1,049,684 200,393 1,250,077 648,257 2,151,147 (6,540) 41:744 5,268 162 5 431 40,634 (23.985) (3,685) 1,131 (683) (7,545) (2,512) (11:972) (500) (610) 6:087 (1,221) (139,376) (639) 654 713 (7,903) 7,598 26,170 (5,575) 16,9a i 12,498 (2,244) (742,049) (143,277) (8,384) (1,030,319) (0) 49.82% 49.82% 144.87% 97.50% 0.00% 98.96% 51.09% 46.67% 33.98% 5S.71% 48.75% 38.32% 35.48% 42.86% 0.00% 7.19% 64.31 % 9.30% 27.83% 18.04% 82.72% 192.54% 41.82% 100.00% 92.48% 10.08% 245.54% 99.99% 49.40% 0.86% 0.00% 22.53% 25.23% 50.00% (1,030,319)410a,=.__ 27.4v 1,070,953 0 76.68% 100.00% Ending Puna Baferi e 1,3057154 : 7,f26.,rol $ 2,759 14 1,010,954 214.397o Cash and investmeits $ 2,683,138 Variance = Actual over (under) prorated budget Fang 41-/ Page 29 of 32 city c,f Tukwila Eqdprnent Rental/Ruplac rnunt Fund 501 - Revenue and Expenses As of June 30 2012 % of year eApired 50.00% 2012 .Expected ATI Annual Budget Budget Year -To -Date V aria, tic at. % of Annual rsaaget Revenue Charges for Ser vices ERR O&M Dept Charges $ 1,099,806 $ 549,900 $ 549,903 $ 50.00% Equipment Replat,munt Charges 777,801 388:901 358,726 (30,174) 46.12% Fuel Sales 474,000 237,000 237,000 50.00% Transportation 150 75 - (75) 0.00% Total Cnarges for Services 2,351757 1,175,879 1,145,629 (30,249) aa.r 1 % Miscellaneous Reve,,,.e Investment Earnings Other Misc Reverhz Tote/ Miscellaneous Revenue Sale of Capital Assets 14,269 7 105 18,060 10,926 126.57% 252 252 0.00% 1z,Ltsg 7,135 18,312 11,177 128.33% 17,598 17,598 0.00% Total Rer'arraa 2366026 1,183,013 1,181.539 (1,474) 49.94% E..punss 11 Salaries 12 EAt,a Labor 13 Overtime 21 FICA 23 PERS 24 IndostraIInsurance 25 Medical, Dental, Life, Optical 26 Unemployment Compensation 28 Uniform Clothing 31 Office & Operating Supplies 34 Items Po,chased fo, Resale 35 Small Tools & Minor Equipment 41 Prsffssianel Serriaas 42 Communication 43 i ravel 45 Operating Rentals & Leases 46 Insurance 48 Repairs & Maintenance 49 Miscellaneous 53 Ext Ta..ea & Operating Assessments 64 Capital Outlay Total Equipment Rental Fond Transfers Oat Total Expane. Change in Fund Balance Beginning Fund Balance Ending Fond Balance 052,844 176,422 176,690 268 50.08% 10,000 5,000 5,952 952 59.527a 1,147 574 1.783 1,209 155.43% 26,814 13,407 14.056 649 52.42% 31,001 15,801 13,214 (2,586) 41.82% 9,976 4,988 4,398 (590) 44.08% 82,161 41,081 38,947 (2,133) ifr.40% 1,000 500 - (500) 0.00% 950 475 82 (393) 8.64% 2,979 1,490 856 (634) 28.73% 689,000 344,500 299,080 (45,420) 43.41% 2,500 1,250 1:878 628 75.11% 550 275 696 421 126.54% 2,000 1,000 557 (443) z,.84°/ - - 144 144 0.00% 37,399 18,700 18,510 (190) 49.49% 10,130 5,065 10,130 5.065 100.000/. 130,781 65,01 69,762 4,372 53.34% 0,000 3,250 3,616 366 55.62% - - 0.00% 322,000 161,000 87,751 (73,249) LI.L5% 1,720,332 860,166 748,100 (112,056) 43.49% 309,667 154,834 154,833 (0) 50.00% 2,929,999 1,015,000 902,934 (112,066) 44.4i, 336,027 168,014 278,605 110,591 82.91% 3,523,993 3,523,993 3,523,993 - 100.00% $ 3,860,020 i 3,692 007 _ ._ 3,802598 $ 110 591 98.51% Cash and investments 3,789,754 -" Varia„ce = Actual aver (under) prorated budget Fund 501 Pave 30 of 32 City of TuRwila Insurance Fun 502 - Revenue and Expenses As or 3une 30 2012 % of year expired 50.00% 20{2- Annual Budget Expec6t d Budget Actual Year -To -Date Variance *} % of mikado) Buag t Rovenou Gha,—ges for Ser vices Employee Benefit Programs Total Charges for Services Miscellaneous Revenue Investment Earnings Employer 1 rust Gontri6utions Employee Contributions iitffer Misc Rovenue iota/ M;uC011u,zorru Rcvcn� Total Revenue E..penses 25 Medical Dental, Eife, Optical 41 Professional Services 49 Miscellaneous Total transfers tut / Indirect cost allocation Total Expenses flange in Fund Balance Beginning Fund Balance $ 621 $ 621 $ 10,032 $ 4,30/,/-15 $ OV,UVU $ 6,2uu 4,443,94 4,444,5e6 4.400;000 25.000 20,500 4,445:500 60,305 4,525,805 (81,237) 4,x83,480 311 $ 311 5:016 2,183,858 30,000 3,luu 2,2z1,a74 z,222,zoF 2,200,000 12,500 10,250 2,222:750 40,153 2,262,903 (40,619) 4,aas,4au 454 $ 464 80,153 2,145;181 36:583 z,261,917 2,zoz,3ai 2,194,12/ 6, /48 (5,289) 2,195:586 40,152 2.235,739 26:643 4,983,480 154 154 15,131 (38,676) 6:583 (3,100) 39,944 4u,uai (5,873) (5, (52) (15,539) (27164) /4./4% /4./4°/ 798.98% 49.11 % 60.97% 0.00% 50.90% 50.90% 49.5/% 26.99% -25.8U% 49.39% 50.00% 49.40% 67,261 -32.80% 100.00% enB/ny Frin1 ba/enr.o $ 4,`JUZ,z433 $ 4,94z,dez $ 5,010,123 67 261 1 02.20% Gab)) and investments variance = Actual over (under) prorated 6uaget $ 6,1/4,235 F-un8 5UZ Page 31 or 32 City of Tukwila LEOFF insurance Fund 503 - Revenue and Expenses As of June 30 2012 % of year expired 50.00% 2_01Z Expected Actual % et Annual Annual Budget Budget Year -To -Date Variance"` Budget Rz.un,.e Miscella„eons Reve„ae Investment Earnings $ 3,340 $ 1,670 a 1,240 $ (430) 37.1c% Employer Trust Contributions 575,000 287,500 236,612 (50,888) 4 1.15% Other Misc Rwe„ce 700 35u - (.350) 0.00% Total Revenue ar9,040 289,520 237,851 (51,669) 431!08% Expenses 25 Medi, al, Dental, Liff, Optical 659,530 329,765 152,330 (177,435) 23.10% 41 PR,r�ssi.nal Services 3,000 1,500 680 (820) 22.67% 49 Miscellaneous 10,000 5,000 670 (4.330) 6.70% Total 672,530 336,265 153,680 (182,585) 22.85% Transfers Oat 4,619 2,310 2,310 0 50.00°%o Towi Expenses 677,149 338,575 155,990 (182,585) 23.04%i Change in Fond Balance (98,109) (49,055) 81,862 130,916 -83.44% Beginning Fund Balm ice 1,628,986 1,628,986 1,628,986 100.00% E.,ding Fund Ba/m,oe 3 1,530,87/ 1,579,932 $ 1 7i0,i la $ 130,916 111.76% Cash and investments $ 1,904,047 Variance = Actual over (ander) prroi ated budget Fund 503 Pays 32 of 32 Estimated 2012 Revenues Detail to be used with PowerPoint Slide No_ 9 City of 'Tukwila hstimated '1012 Kevenues General Fund Reven,.es All Actual 2012 B,.dget 4112 Esti..,ate ''2U12 tat :all Act 2012 tst zulz 13agt KtVLNUti5 l'1UFE1ty 1 axes sales a11a Use 1exes' 13423.445 16,113,133 13,868_25U 15,048,000 13.750.000 15,066,638 c.47a -6.5% -0.77, 0.1% RGRL Ter2 1.641239 239 1 975 000 1745.00U 00U 6s7., -11.67. Aallussiol,s 1 an 513,611 654,000 585 083 1i.97o -10.37o Utility 131,.E3 4,052,264 4,840,000 4,106,401 la% -ls.c% I.,teifundUtility Tu. 1,372,380 1,524,000 1,4/8,b89 7.,% -3.17% tAcise 1ares4 1,524,172 2,641,303 2,279,219 49.5% -13.7% 1'e1lalnes/111terest 616 67 8,218 1234.1% 12165.6% Tax 1 Mal 38 F45,450 40,550,520 39,019,248 1.07o -3.37o busil,ess Licel,ses 3.1a 1'Enauts 663,598 807,227 692,003 4.3% -14.37 Bu: I.1.G Pc. mita al Ai. reea 1,169,033 1,101,339 1,066,261 -8.8% -i.c% Licenses & Permits Total 1,832,671 1,908,566 1,7555,213 -4.1% -7.9% Sales Tax Mirigatioi,2 1,217.418 1.200.000 1.165,641 .i.a% -437o Seattle Lity Lignt tral,Ulise tee 2,109,611 2,050,000 2,216,021 3.07o 3.17o Othe. State sha.Ed leve.,uea 408,639 308,504 312,902 -8./% c0.7% Other intergovernmental 1,020,359 585,643 1,052,2/5 3.1% 79.7% Intergovernmental Total 4,756,033 4,144,147 4,806,845 1.1% 16.0% Ge.,eral Guve..,..,e.,t 52,344 60,951 56,188 7.3% -7.8% Security 430,307 511,134 499,651 16.1% -2.2% Engineering Services 6,zz 5,86/ 6,000 -13.3% -90.0% Transportation 180,789 158,149 161,70z -1o.6% 2.2% Flan Check a11a Keview Fees 552,996 858.500 586,663 6.1% -31.7% Culture a11a Rec Fees' 569,5/1 611,500 454,21/ -20.3% -25.7% Charges for Services Total 1,792,930 2,260,101 1,764,421 -1.6% -21.9% Fines ana Penalties Total 229,907 213,270 216,464 -5.8% 1.5% Miscellaneous 1 otal 582,694 602;/60 513,093 -11.77, -14.97 1.,di.ect Cyst Allocatioi, 2,236,584 2,331,0/3 2,333,033 c.7% Other Financi.,g 21,9/5 1,300,500 - o.o% Other Sources Total 2,298,559 3,637,577 2,337,077 1.7% -35.8% Total Kevenues & 1ransters $ 50,138,254 $ 53,317,041 $ 50,415,420 0.6% -5.4% yea1. ` Sales tax is eati111atea to be $1M less tha11 2011 aue largely to a leauction is new construction sales tax. 2 5ales tan l.utlgat1OLL :s il,Lluaea u, tnls 1111E '1'& KL tax is tiighel aue to hole intense collection activity. 4 Gambling tax in 2012 is estimated to exceed 2011; to -date all casinos have paid the quarterly taxes on time; one casino 5 Culture a.,d Rec fees i.. 2012 e,.clude Fool ie.,e.,ue; the Fool oFe.atad us Fait of the Pinks a.,d Keneatiu., deFa.tment lne F.oFE.ty that vvas enFected to be a01aa il, Luiz vv ill be 3,1d ata late. date. Estimated 2012 Expenditures Detail To be used with PowerPoint Slide No_ 10 P.:,graz.. Lity Of l uKwila Estimatect'LUIZ t xpertctitures 2010 1011 2012 2012 Actual Actual Budget Estimate City Council $ 242,851 $ 244,029 $ 269,655 $ 249,687 Mayor's Office 2,228,656 2,218,089 2,543,991 2,434,468 Human KCSourceS 464,095 48'/ 91U 5/3,396 518,540 ruiaiLce 2 133,069 1 446 /36 1 603 133 1 446 915 City Attniiiey 5/8,908 647,990 542,734 508,397 Parks & Recreation 4,123,074 3,495,780 3,465,174 3,248,826 Community Development 2,635,296 2,560,151 2,858,579 2,650,414 Court 1208632 945 1/4 995,349 992,544 Police 13,165,552 14,296,435 14,19/,/10 14,090,/5/ Fire 9,920,730 9,814,177 10,308,193 10,200,971 Information Technology 953,361 1,046,573 1,153,947 1,007,394 Public Warks 6,941,519 5 /1/,32.3 6290 338 5134,011 Department 20 44,645,544 42,920,928 44,800,699 43,132,925 252,671 7,062,750 11,642,752 7,885,984 lutal $ 44,893,215 $ 49,983,6/8 $ 56,443,451 $ 51,013,909