Loading...
HomeMy WebLinkAboutReg 2010-09-07 Item 2 - Presentation - Financial Status UpdateCity of Tukwila INFORMATIONAL MEMORANDUM TO: Mayor Haggerton Finance and Safety Committee FROM: Peggy McCarthy, Deputy Finance Director DATE: September 1, 2010 SUBJECT: Financial Status Update as of July 31, 2010 Jim Haggerton, Mayor ISSUE Policy GF -2 prescribes that a financial status report will be provided periodically during the fiscal year. BACKGROUND The financial status report contains the following charts and schedules 1 Chart of fund balances as of the report date; schedule of fund balances at the report date compared with balances at the end of the prior fiscal year. 2. Chart of sales tax revenue by month for the current period and each of the five prior fiscal years; chart of cumulative, year -to -date sales tax revenue by month for the current period and each of the five prior fiscal years. 3. Chart of real estate excise tax (REET) revenue by month for the current period and each of the five prior fiscal years; chart of cumulative, year -to -date REET tax revenue by month for the current period and each of the five prior fiscal years 4. Schedule of general fund revenue and expenses for the current period compared with the annual budget and for each of the three prior fiscal years. 5. Schedule of general fund revenue and expenses for the period compared with the annual budget prorated for the number of months expired in the reporting period. 6. Schedule of general fund expenses by department for the period compared with the annual budget. 7. Schedules of revenue and expenses for the period compared with the annual budget for the funds below. a 101 Hotel /Motel Tax fund b 103 Street fund c. 104 Arterial Street fund d 105 Contingency fund e 107 Fire Equipment Cumulative Reserve f. 109 Drug Seizure fund g 2xx Debt Service funds h. 301 Open Space Park Acquisition fund i. 302 Facility Replacement fund j. 303 General Government Improvements k. 304 Fire Impact Fees I. 401 Water fund m. 402 Sewer fund n. 411 Foster Golf fund o. 412 Surface Water fund p. 501 Equipment Replacement fund q 502 Self- Insurance fund r. 503 LEOFF I Insurance fund 1 2 INFORMATIONAL MEMO Page 2 The financial schedules report operating results for the seven month period ended July 31, 2010, at which point 58.33% of the year has expired. Therefore, to be on track with the budget, 58.33% of revenue should have been realized and no more than 58.33% of expenditures should have been incurred. The sales tax revenue amounts include the sales tax mitigation fees. Also, the 2010 bond issuance is not reflected in these reports even though the issuance was accomplished in mid -July. DISCUSSION ALL FUNDS Fund balances in total increased by $728,000 for the seven months ended July 31, 2010 Governmental funds decreased by $1,768,383, enterprise funds increased by $1,119,075 and internal service funds increased by $1,377,820. The operating activity responsible for these changes is discussed below. GOVERNMENTAL FUNDS The general, special revenue, debt service, and capital improvement funds comprise the governmental funds. The decrease of $1,768,853 in governmental fund balances during the seven month period is due mainly to a $1,697,383 decrease in the general fund. Additionally, the Arterial Street fund decreased $589,962 and the debt service funds increased by $578,780. The debt service funds accumulate balances throughout the year to meet December principal payments totaling $1.44 million for December, 2010. General Fund. The general fund balance, in addition to being $1.7 million lower than the 12/31/09 balance is $2.5 million below budget. Only 51.58% of budgeted revenue has been realized versus the 58.33% that should have been realized at this point in the year based on the annual budget. This translates into a $3 million revenue deficit and is due mainly to the decline in sales tax. Admissions tax, although a small portion of total revenue, exceeded projections with revenue reaching 130% of the annual budget. Admissions tax revenue totaled $364,182 for the period and comprises $28,207 from the Foster Golf Links and $335,974 from external sources. Of the $335,974 from external sources, the AMC theatres located in the Westfield's Southcenter Mall and opened in 2008 in connection with the mall expansion, has generated $262,975. The effect of the general fund revenue decline on budgeted fund balance is offset by a decrease in general fund expenses. Expenses are at 54.66% of the annual budget versus the projected 58.33% yielding a $1.7 million savings for the seven month period. Expenditures for all departments are under budget with the exception of the Finance Department and the Public Works department. The departments generating the largest cost savings for the period as compared to the prorated annual budget are the Police department with a savings of $685,470, the Mayor's office with a savings of $279,707, the Fire department with a savings of $238,097 and the Community Development department with a savings of $227,518. The Finance department shows overages in insurance charges and miscellaneous costs. The insurance overage is due to the timing of the premium payments. Of the total insurance cost for the period of $189,136, $182,970 represents the WCIA annual insurance premium which was paid and recorded in January but covers the entire year. The overage in miscellaneous costs is due to two factors; claims and judgments are $90,000 overbudget and $45,000 of Eden systems upgrade that was not budgeted. W:IFIN Projects\Council Agenda ItemsllnfoMemo Financial Status Report as of 7 -31 -2010 9- 1- 10.docx INFORMATIONAL MEMO Page 3 Public Works is also over budget. Small tools and equipment was budgeted at $68,750 and actual costs total $175,436 for the period, professional services were budgeted at $958,900 and total $884,467 for the period, and machinery and equipment was budgeted at $20,000 and totals $111,186 for the period. These overages are due to the purchase of goods and services for emergency preparedness and the flood response. Communications equipment comprises the majority of the small equipment purchases with depth sounders, chest waders and other personal protection and flotation devices purchased as well. The professional services costs include a $663,923 contract payment to Goodfellow Brothers for services provided in setting the super sack sand bags and other flood prevention efforts. Professional service costs also include payments to KBA construction, Ginger Bonnell, an assistant to the City's Emergency Manager and costs for the AHAB siren installation. The machinery and equipment costs include the purchase of two Wooldrige boats at $40,000 each plus $11,924 in boat upgrades for flood response, and a $17,333 forklift for the emergency logistics center. Through July 31, a total of $1,132,000 was spent by the Public Works department on flood response equipment and services. Arterial Street Fund The fund activity is underbudget in several categories due to a delay or rescheduling of some of the arterial street work. Intergovernmental revenue, primarily grant revenue, is at 7.25% of annual budget or $27,517,980 under the annual budget. Capital outlay and professional service expenditures are at 5.28% and 12.67% representing an annual budget variance of $50,242,944 and $7,675,870 respectively. Amounts spent during the period on arterial street capital improvements total $3.9 million comprising $1.6 million for TIB phase II, $1.5 million for TIB phase 111, and $400,000 each on the Southcenter Parkway Extension and the Klickitat Tukwila Urban Center Access project. Budget for the year included $22 million for the Southcenter Parkway Extension project and $20.6 million for the Klickitat Tukwila Urban Center Access project. ENTERPRISE FUNDS The golf course fund and the three utility funds water, sewer and surface water comprise the enterprise funds. The enterprise fund balances increased $1.12 million from 12/31/09 due primarily to the increase in the surface water fund. Surface water charges are billed twice a year, once in January and once in July. The surface water revenue reported through July 31 includes, and the fund balance reflects, a full year of surface water billings since the July billing of $1.5 million is included in this year -to -date revenue amount. Expenditures for the remaining five months of the year remain to be incurred and will reduce the fund balance by the end of the year. The golf course fund balance increased $92,113 due mostly to expenses coming in below budget at 48.91% versus the projected 58 33 The debt service principal of $184,972 will be paid in December. INTERNAL SERVICE FUNDS The Equipment Replacement Reserve fund and the two self insurance funds for health benefits of active employees, the Self Insurance fund, and for health benefits of LEOFF I retirees, the LEOFF Insurance fund, comprise the internal service funds The internal service fund balances increased by $1,377,820 from the 12/31/09 balances due largely to the $913,471 increase in the self- insurance fund. Premiums are scheduled for reduction in the next budget cycle to stabilize the fund balance. The equipment replacement fund and the LEOFF I retiree insurance fund increased $287,689 and $176,660 respectively from their 12/31/09 balances. Within the equipment replacement fund, the equipment WIFIN Projects1Councff Agenda ItemstInfoMemo Financial Status Report as of 7 -31 -2010 9- 1- 10.docx 3 4 INFORMATIONAL MEMO Page 4 replacement charge revenue was at 13.73% of budget because general fund contributions were discontinued in 2010 (and 2009) due to budgetary constraints. RECOMMENDATION No recommendation; for information only. ATTACHMENTS Financial Status Report as of July 31, 2010 W Projects\Council Agenda ItemsllnfoMemo Financial Status Report as of 7 -31 -2010 9- 1- 10.docx General Fund Hotel /Motel Tax Fund Street Fund Arterial Street Fund Contingency Fund Fire Equip Cum Reserve Drug Seizure Fund Debt Service Funds Parks Acq Fund Facility Replacement Fund General Gov Improvements Fire Impact Fee Fund Water Fund Sewer Fund Foster Golf Fund Surface Water Fund Equipment Replacement. Self- Insurance Fund LEOFF Insurance Fund $487 540 General Fund Hotel /Motel Tax Fund Street Fund Arterial Street Fund Contingency Fund Fire Equip Cum Reserve Drug Seizure Fund Debt Service Funds Parks Acq Fund Facility Replacement Fund General Gov Improvements Fire Impact Fee Fund GOVERNMENT FUNDS Water Fund Sewer Fund Foster Golf Fund Surface Water Fund ENTERPRISE FUNDS Equipment Replacement Fund Self- Insurance Fund LEOFF Insurance Fund INTERNAL SERVICE FUNDS TOTAL Unrestricted unreserved fund balances Fund Balances As of July 31, 2010 0 $5 692,047 $ge 257,84 $2,071,43 $1,80 0'387,293 1,781 3 14,218 _$1,42E_, 020 $3,40 -w ag.4 $4,295,161 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 Actual 12/31/2009 7,389,431 919,722 634,793 5,820,775 885,462 641,542 221,108 135,438 4,668,345 2,073,918 345,649 13,346 23,749,529 6,116,633 1,793,638 3,631 2,128,642 10,042,545 6,462,672 3,381,691 1,251, 360 11, 095,723 44,887,797 Increase (Decrease) Amount (1,697,383) -23.0% (142,441) -15.5% (147,253) -23.2% (589,962) -10.1% 1,831 0.2% 239 0.0% 36,740 16.6% 578,780 427.3% (19,131) -0.4% (2,484) -0.1% 75,226 21 8% 136,984 1026.4% (1,768,853) 4% (257,377) -4.2% 8,285 0.5% 92,113 2536.8% 1,276,053 59.9% 1,119, 075 11 1% 287,689 4 5% 913,471 27.0% 176,660 14.1% 1,377,820 12.4% 728,041 1 6% >u. $4,349;214 0 $5,230,E13 ::5;859,257 tE $E ,750,361 Actual 07/31/2010 5,692,047 777,281 487,540 5,230,813 887,293 641,781 257,848 714,218 4,649,214 2,071,434 420,875 150,330 21, 980,675 5,859,257 1,801,923 95,744 3,404,695 11,161,620 6,750,361 4,295,161 1,428,020 12,473,543 45,615,838 5 $2,500, $2,00 1 $1,500, $1,000, $500, $20,000, $17,500, $15,0 $12,5 $10,000,000 $7,50 $5,0 00,000 $2,500,000 6 Sales Tax by Month DEC June July Aug Sept Oct Nov r o 2010 2009 Apr M .�.�_,.2008 M 007 Jan Feb _2006 2 2005 Total Annual Sales Tax Sept Oct Nov Dec June Ju Aug 2010 Mar Apr May X 2009 2oos Jan Feb 200 —112--- 2006 2005 $1,200,000 $1,000,000 $800,000 $600,000 $400,000 $200,000 $3,500,000 $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 Jan Feb f REET by Month 7 I 1 1 1 Mar Apr May June July Aug Sept Oct Nov Dec 2005 ---2006 2007 -.4- 2008 2009 2010 Total Annual REET 4, x -X X X .......,71 Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec 4 2005 -s-- 2006 2007 2008 --w--2009 ----i'.--- 2010 7 City of Tukwila General Fund 000 Revenue and Expenditures As of July 31, 2010 Revenue General Revenue Property Taxes Sales and Use Taxes Admissions Tax Utility Taxes Interfund Utility Tax Excise Taxes Penalties /Interest Total General Revenue Licenses and Permits Business Licenses and Permits Building Permits and Fees Total Licenses and Permits 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 Investment Earnings Rents and Concessions Insurance Premiums /Recovery Contributions/Donations Other Misc Revenue Total Miscellaneous Revenue Sale of Capital Assets Transfers In Total `Revenue; Expenditures City Council Mayor's Office Administrative Services Finance Legal Parks Rec Community Development Court Police Fire Information Technology Public Works Parks Maintenance PW Street Maintenance Non Departmental (Dept. 20) Transfers Out Total Expenses- Change in Fund Balance Beginning Fund Balance 8 Ending, Fund Balance 2007.; 234,769 2,037,794 475,813 1,602,167 603,378 2,956,021 2,423, 936 999,584 11,764,214 9,457,701 586,036 3,304,857 894,145 2,240,234 356,226 1,810,933 8,706,465 .20097;3 Actual 'r "'i 'Actual 11,042,843 11,115,973 12,190,219 14,670,616 12,903,174 12,903,214 253,272 327,911 582,756 3,666,079 3,934,210 4,359,292 1,813,277 2,024,646 2,173, 767 2,567,119 3,051 1,826 628 31,660,507 30,456,861 34,416,505 454,472 481,154 684,141 1,373,236 1,541,697 599,322 1,827,708 2,022,851 1,283,463 2,562,870 2,587,088 4,344,251 64,558 61,616 72,547 247,709 805,610 333,729 23,975 1,200 125,703 68,793 (24,312) 827,379 934,804 402,188 735,568 697,358 628,418 2,024,892 2,569,381 1,412,571 266,188 259,991 230,273 488,252 328,698 118,713 324,686 351,661 374,680 4,751 1,776 643 25,599 108,013 2,739 431,503 216,071 109,699 1,274,791 1,006,219 606,475 100 53,592 989,608 2,130,752 2,215,982 3,156,300 747;808°x' ".7= -7 1',171;965 N:; °s,,`iI6;43 261,235 2,140, 561 506,660 1,932,285 728,980 3,158, 534 3,066,717 1,136,752 12,699,005 10,152, 352 676,421 3,608,739 965,020 2,573,891 376,896 251,563 2,492,492 506,060 1,963,333 685,691 3,350,801 2,779,459 1,181,132 12,994,938 9,874,049 951,073 5,756,107 979,084 2,280,106 709,444 43, 984,0 48 (2,812,083) (315,885) 10,517,398 7.705,315 10 ;517,3981•.;; 7,705,315 71;389,430 Fund 000 Multi -Year dluated, udiet of year expired 58.33% 2010 �ctUaJ e`ar -Fo Dafej ;'``V ariance Budpet`t 10.39% 12,688,000 6,969,541 (5,718,459) 54.93% 12.05% 15,333,917 6,714,962 (8,618,955) 43.79% 130.09% 279,000 364,182 85,182 130.53% 18.91% 3,906,000 2,616,480 (1,289,521) 66.99% 0.00% 1,358,000 684,042 (673,958) 50.37% 26.79% 2,204,000 1,395,419 (808,581) 63.31% 79.41% 2,000 27 (1,973) 1.35% 8.70% 35,770,917 18,744,651 (17,026,266) 52.40% 50.54% 489,000 395,763 (93,237) 80.93% 56.36% 1,895,000 690,883 (1,204,117) 36.46% -29 78% 2,384,000 1,086,647 (1,297,353) 45.58% 69.51% 2,987,072 1,294,817 (1,692,255) 43.35% 12.38% 68,000 44,748 (23,252) 65.81% 34 73% 304,000 244,642 (59,358) 80.47% 10,000 6,200 (3,800) 62.00% 119.34% 150,000 108,219 (41,781) 72.15% 51.39% 1,083,000 482,489 (600,511) 44 55% 57% 703,000 437,796 (265,204) 62.28% 30.24% 2,318,000 1,324,094 (993,906) 57 12% 13.49% 241,000 115,649 (125,351) 47 99% 75.69% 505,000 38,801 (466,199) 7 68% 15.40% 346,000 279,208 (66,792) 80.70% 86.47% 1,000 11,666 10,666 1166.60% 89.30% 21,000 21,034 34 100.16% 74.58% 122,000 10,034 (111,966) 8.22% 52.43% 995,000 360,741 (634,259) 36.26% 5,000 (5,000) 0 00% 48.13% 2,462,000 1,398.137 (1,063,863) 56.79% 47t' daiiir'ar3'3;''`24 324,739, ;838;253 '.51''.'56a 7 15% 282,970 140,811 (142,159) 49.76% 22.31% 2,595,765 1,234,403 (1,361,362) 47 55% 6.36% 571,640 258,545 (313,095) 45.23% 22.54% 1,921,309 1,300,718 (620,591) 67 70% 13.64% 555,856 257,146 (298,710) 46.26% 13.36% 3,471,420 1,830,288 (1,641,132) 52.72% 14 67% 3,010,027 1,528,231 (1,481,796) 50 77% 18.16% 1,141,680 663,444 (478,236) 58.11% 10.46% 13,946,824 7,449,712 (6,497,112) 53.42% 4 40% 10,205,813 5,714,954 (4,490,859) 56.00% 62.29% 1,086,270 521,452 (564,818) 48.00% 74 17% 4,851,223 3,014,468 (1,836,755) 62,14% 9 50% 1,006,554 533,169 (473,385) 52.97% 1 78% 2,656,916 1,519,778 (1,137,138) 57.20% 99.16% 305,000 55,000 (250,000) 18.03% 0 00% 0.00% 17AT%P „,47,609,267 ".1,. 26,022,120 (21,587 1- (446,278) (1,697,383) (1,251,105) 380.34% 8,709,916 7,389,431 (1,320,485) 84 84% 29.74% 8,263 5,692,047 (2,571,691) City of Tukwila General Fund 000 Revenue and Expenditures As of July 31, 2010 Revenue General Revenue Property Taxes Sales and Use Taxes Admissions Tax Utility Taxes Interfund Utility Tax Excise Taxes Penalties /Interest Total General Revenue Licenses and Permits Business Licenses and Permits Building Permits and Fees Total Licenses and Permits 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 Investment Earnings Rents and Concessions Insurance Premiums /Recovery Contributions /Donations Other Misc Revenue Total Miscellaneous Revenue Sale of Capital Assets Transfers In Totaf Revenue ju nnual: Budget: 12,688,000 15,333,917 279,000 3,906,000 1,358,000 2,204,000 2,000 35, 770, 917 489,000 1,895,000 2,384,000 2,987,072 68,000 304,000 10,000 150,000 1,083,000 703,000 2,318,000 241,000 505,000 346,000 1,000 21,000 122,000 995,000 5,000 2,462,000 47;.162;989 Budget Year -Td'= Date): 7,400,910 8,944,274 162,741 2,278,370 792,121 1,285,593 1,167 20,865,176 285,234 1,105, 354 1,390,587 1,742,359 39,664 177,323 5,833 87,495 631,714 410,060 1,352,089 140,575 294,567 201,822 583 12,249 71,163 580,384 2,917 1,436,085 27;510,171 2010 Actual Year-To Date) 6,969,541 6,714,962 364,182 2,616,480 684,042 1,395,419 27 18,744,651 395,763 690,883 1,086,647 1,294,817 44,748 244,642 6,200 108,219 482,489 437,796 1,324,094 115,649 38,801 279,208 11,666 21,034 10,034 360,741 1,398,137 24;324,736 Variance (431, 370) (2,229,312) 201,441 338,110 (108,080) 109,825 (1,140) (2,120, 525) 110,530 (414,470) (303,941) (447,542) 5,084 67,319 367 20,724 (149,225) 27,736 (27,995) (24,926) (255,766) 77,386 11,083 8,784 (61,129) (219,642) (2,917) (37,948) variance as Of, ::Budget (Year -To Date) 5 83% 24 92% 123 78% 14 84% -13 64% 8.54% 97 68% 10 16% 38.75% -37 50% 21 86% 25 69% 12.82% 37 96% 6.29% 23.69% 23 62% 6 76% 2.07% -17 73% 86 83% 38.34% 1900 00% 71 71% 85 90% -37 84% -100 00% 2.64% (3;185;435). Fund 000 1 9 City of Tukwila General Fund 000 Revenue and Expenditures As of July 31, 2010 Expenditures City Council Mayor's Office Administrative Services Finance Legal Parks Rec Community Development Court Police Fire Information Technology Public Works Parks Maintenance PW Street Maintenance Non Departmental (Dept. 20) Transfers Out Tu>taf- EXpe Change in Fund Balance Beginning Fund Balance 10 ;Endin F'unf;'B.alance:. 282,970 165,056 2,595,765 1,514,110 571,640 333,438 1,921,309 1,120, 700 555,856 324,231 3,471,420 2,024,879 3,010, 027 1,755,749 1,141,680 665,942 13,946,824 8,135,182 10,205,813 5,953,051 1,086,270 633,621 4,851,223 2,829,718 1,006,554 587,123 2,656, 916 1,549,779 (446,278) (260,314) 8,709,916 8,709,916 140,811 1,234,403 258,545 1,300,718 257,146 1,830,288 1,528,231 663,444 7,449,712 5,714,954 521,452 3,014,468 533,169 1,519,778 55,000 305,000 177,907 7 10)1§7. t_ '?3'" 7;770 485 ya! i;- 26,022L I10 (1,697, 383) 7,389,431 (24,246) -14 69% (279,707) 18.47% (74,892) 22.46% 180,019 16.06% (67,084) -20 69% (194,591) -961% (227,518) 12.96% (2,498) -0 38% (685,470) -8.43% (238,097) -4 00% (112,170) 17.70% 184,750 6.53% (53,954) 9.19% (30,001) -1 94% 55,000 0 00% (177,907) 100.00% :'I 748j369); 6 :30% (1,437,069) 552.05% (1,320,485) -15 16% E :Zys3 o' s67,1; jk=w:3. =30:43 Fund 000 2 CITY OF TUKWILA Expenditures through July 31, 2010 TOTALS ENTP. CITY COUNCIL MAYOR ADMINISTRATIVE SERVICES FINANCE CITY ATTORNEY RECREATION COMMUNITY DEVELOPMENT MUNICIPAL COURT POLICE FIRE INFORMATION TECHNOLOGY PUBLIC WORKS PARK MAINTENANCE STREET MAINTENANCE OPERATION DEPT 20' CONTRIBUTIONS FUND BALANCE BY DEPARTMENT BUDGET 00 U REDUCTON 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 00 UNALUOCATEDBUDGET REDUCTION 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 48 REPAIRS MAINTENANCE 49 MISCELLANEOUS 51 INTERGVRNMTL PROFESSIONAL SVCS 64 MACHiNERY&EQU|PK8ENT MAYOR ^xm� Actual Spent 140,811 1,234,403 258,545 1,300,718 257.148 1,830,288 1,528,231 663,444 7,449,712 5,714,954 521,452 3,014,468 533,169 1,519,778 55,000 '56,872,905 26.022A20 Budget 282,970 2,595,765 571,640 1,921,309 555,856 3,471,420 3,010,027 1,141,680 13,946,824 10,205,813 1,086,270 4,851,223 1,006,554 2,656,916 8,568,638 Annua' 4 ,0.!:!, 4,06 (8,951) 172,137 13,168 9,140 2,510 39,066 3,500 3,000 4,400 2,217 30,000 5,468 15.000 1,073 (70,771) 1,081,317 28,500 573 84,936 60,812 3,059 233,643 31,325 685,950 86,000 23,000 21,300 29,568 13,850 238,203 26,500 18,000 2,595,765 Remaining 99,631 7,436 2,558 1,369 20,267 791 4- 562,842 1,340 42,974 29,958 2,123 120,511 6,938 329,336 25,218 5,891 6,261 14,016 1,956 58,683 17,884 1,225,930 of year expired Budget 142,159 1,361,362 313,095 620,591 298,710 1,641,132 1,481,796 478,236 6,497,112 4,490,859 564,818 1,836,755 473,385 1,137,138 8,513,638 (8,951) 72,506 5,732 6,582 1,141 18,799 2,709 3,000 2.183 24.532 13,927 (70,771) 518,475 28,500 41,962 30,854 936 113,132 24,387 356,614 60,782 17,109 15,039 15,552 11,894 179,520 8,616 18,000 1,369,835 58.33% Spent 49 76% 475596 45.23% 67 70% 46.26% 527296 50 77% 581196 534296 56 00% 48.00% 621496 52 97% 57.20% 0.64% O 0DY6 57 88% 56 47% 27 99% 54 56% 518896 226196 0 00% 50 39% 18.23% 7 15% 0 00% 52.0596 0 00% 233 87% 50 60% 49 26% 69.41% 51.58% 22.15% 48.01% 29.32% 25 61% 29 39% 474096 14 12% 24 64% 67 49% 0 00% 4T^33Y6 11 ADMINISTRATIVE SERVICES 00 UNALLOCATED BUDGET REDUCTION 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 WON is T 2ATI 0)4, I tFINAN 00 UNALLOCATED BUDGET REDUCTION 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 46 INSURANCE 48 REPAIRS MAINTENANCE 49 MISCELLANEOUS 64 MACHINERY EQUIPMENT 00 UNALLOCATED BUDGET REDUCTION 12 EXTRA LABOR 21 FICA 24 INDUSTRIAL INSURANCE 31 OFFICE OPERATING SUPPLIES 41 PROFESSIONAL SERVICES 42 COMMUNICATION 45 OPERATING RENTALS LEASES 48 REPAIRS MAINTENANCE 49 MISCELLANEOUS ;CITY`ATTORNE 12 Annual Remainin Budget A ctual Spent- Bud /o Spen (18,153) (18,153) 0.00% 355,006 177,322 177,684 49.95% 3,500 3,500 0.00% 27,426 13,173 14,253 48.03% 19,037 9,416 9,621 49.46% 993 635 358 63.96% 54,711 37,460 17,251 68.47% 8,470 2,100 6,370 24.79% 82,000 8,327 73,673 10.16% 2,000 2,000 0 00% 4,000 13 3,987 0.34% 20,000 5,182 14,818 25 91% 50 20 30 40.08% 4,600 2,581 2,019 56.10% 8,000 2,316 5,684 28.95% "4 6:i (55,100) (55,100) 0.00% 932,682 546,081 386,601 58.55% 10,000 10,000 0.00% 1,147 192 955 16.71% 71,898 41,260 30,638 57.39% 47,680 28,977 18,703 60.77% 3,150 2,081 1,069 66.05% 240,352 146,581 93,771 60.99% 20,000 20,000 0.00% 85,000 27,877 57,123 32.80% 113,000 23,752 89,248 21.02% 1,000 250 750 24.95% 5,000 1,792 3,208 35.83% 277,500 189,136 88,364 68.16% 5,000 1,030 3,970 20 60% 158,000 289,252 131,252 183.07% 5,000 2,459 2,541 49.19% 7;7Q %o anin Bu dge (14,872) (14,872) 2,500 2,500 192 192 36 4 32 5,000 537 4,463 557,000 255,490 301,510 2,500 2,500 500 500 2,000 249 1,751 1,000 866 134 55,856, 257,146 298,710, PAR 0.00% 0 00% 0.00% 11 39% 10.74% 45.87% 0 00% 0 00% 12.45% 86.63% '46.26 07 RECREATION 00 UNALLOCATED BUDGET REDUCTION 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 31 OFFICE OPERATING SUPPLIES 34 ITEMS PURCH. FOR INVENT /RESALE 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS LEASES 47 PUBLIC UTILITY SERVICES 48 REPAIRS MAINTENANCE 49 MISCELLANEOUS 53 EXT TAXES OPERATING ASSMNTS 64 MACHINERY EQUIPMENT RECREATIia.N> MMUNITX ^EL° LL DEVQPME f 00 UNALLO 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 51 INTERGVRNMTL PROFESSIONAL SVCS COMMUNITY` DEVELOPMENT Annual Budget Actual Spent (81,665) 1,486,178 484,201 11,255 149,528 104,272 51,652 415,932 116,550 19,000 223,185 32,607 9,050 15,900 47,635 100,000 30,400 255,740 4 471;420'; nnua uddet. (82,950) 1,825,402 47,900 15,146 144,467 100,451 17,441 363,647 1,805 33,884 600 262,010 4,500 12,000 15,609 1,000 9,050 220,065 18,000 3;010,027 799,796 258,459 3,049 79,542 47,364 28,566 220,346 57,135 24,465 82,619 8,085 1,088 2,721 27,933 65,289 30,104 86,439 197 23097= c Spent 1,046,741 19,834 2,346 80,804 56,684 9,517 191,482 7,468 293 37,878 278 432 10,040 201 41,767 11,372 11,094 1,620,2M Remaining Budget (81,665) 686,382 225,742 8,206 69,986 56,908 23,086 195,586 59,416 (5,465) 140,566 24,522 7,962 13,179 19,702 34,711 296 169,301 (197) Spent 0.00% 53 82% 53.38% 27.09% 53.20% 45.42% 55.30% 52 98% 49 02% 128 76% 37 02% 24.79% 12.02% 17.12% 58 64% 65.29% 99.03% 33.80% 0 00% 0 00% 52.52 %a :;648,223 emainii"ng Budget Spent (82,950) 0.00% 778,661 28,066 12,800 63,663 43,767 7,924 172,165 1,805 26,416 307 224,132 4,222 11,568 5,569 799 32,717 208,693 6,906 1;481,796 57.34% 41.41% 15 49% 55 93% 56 43% 54.57% 52 66% 0 00% 22.04% 48 90% 14 46% 6.17% 3 60% 64 32% 20 09% 461 51% 5 17% 61.63% 50;27% 13 (18,363) 620,582 4,500 5,737 48,257 33,496 2,362 119,394 9,000 274,000 5,550 7,815 5,000 3,000 49 MISCELLANEOUS 1 4 00 -..M :0���B��� �K�0JR�/` O8 UNALLOCATED BUOGET REOU�llON 11 S 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 45 OPERATING RENTALS LEASES 48 REPA|FlS&K4A|NTEN/\NCE 00 UNALLOCATED BUDGET REDUCTION 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 22 LEOFF 23 PERS 24 INDUSTRIAL INSURANCE 25 K8EO|CAL.DENTAL.L/FE.OPT|CAL 31 OFFICE OPERATING SUPPLIES 35 SMALL TOOLS MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS LEASES 46 INSURANCE 48 REPAIRS &MAINTENANCE 49 MISCELLANEOUS 51 INTERGVRNMTL PROFESSIONAL SVCS 64 MACHINERY EQUIPMENT ACtUal et 375,804 28,445 19,964 1,623 76,454 7,384 137,760 5,261 1,502 473 716 7,030,132 5,000 1,003,812 592,274 346,306 60,457 89,033 1,864,526 166,784 13,000 56,175 60,931 23,300 800 449,758 225,080 170,490 67,245 1,709,900 11,821 6 3,810,974 499,897 328,126 193,704 28,325 65,205 1,005,239 40,517 43,477 26,773 7,222 409 427,561 173,340 61,139 12,916 723,859 (18,363) 244,778 4,500 5,737 19,812 13,532 739 42,940 1,616 136,240 289 6,313 4,527 2,284 13,291 3,219,158 5,000 503,915 264,148 152,601 32,132 23,829 859,287 126,267 13,000 12,698 34,158 16,078 391 22,197 51,740 109,351 54,329 986,041 11,821 OOD% 60.56% 0.00% 0.00% 58.94% 59.60% 68.71% 64.04% 82.04% 50.28% 94.79% 19.22% 9.46% 23.85% 37.75% erne' in 0 00% 54 21% 0.00% 49 80% 55 40% 55 93% 46.85% 73.24% 53.91% 24.29% 0.00% 77.40% 43.94% 31.00% 51.14% 95.06% 77.01% 35.86% 1Q.21Y6 42.33% 0.00% 11 -,FIRE 00 UNALLOCATED BUDGET REDUCTION 00 HYDRANT RENTALS 11 SALARIES 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 51 INTERGVRNMTL PROFESSIONAL SVCS 64 MACHINERY EQUIPMENT _FI RE:; �FORIVIATIO,CYTECH.Nt)LOI 00 UNALLOCATED BUDGET REDUCTION 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 64 MACHINERY EQUIPMENT INFORMATION,TECHNOLOGY Annual Budget Actual Spent (30,082) 102,960 6,118,135 3,447,195 530,075 252,647 178,248 105,096 48,534 334,053 172,859 7,574 6,322 85,117 72,352 1,773,109 946,260 1,140 152,150 59,006 17,000 5,785 55,300 26,534 30,000 3,630 9,500 1,888 139,605 251,726 90,000 69,336 60,000 34,419 35,500 16,833 72,583 46,706 326,000 188,856 12,750 0;205,813 niva uleet (34,356) 517,746 2,500 39,798 28,786 1,936 143,960 6,200 2,000 74,700 1,500 7,500 53,000 241,000 1,086;270 52,650;889 Remaining ctual;Spent Budget (34,356) 207,682 2,500 23,558 16,240 16,461 12,325 1,277 659 88,159 55,801 1,101 5,099 13,744 (13,744) 2,000 21,214 53,486 453 1,047 50 (50) 910 6,590 20,332 32,668 24,128 216,872 521;452 564,818 310,064 Remaining Budget. %o Spent (30,082) 0.00% 102,960 0.00% 2,670,940 56.34% 277,428 47.66% 178,248 0.00% 56,562 46 18% 161,194 51 75% 1,252 83 47% 12,765 85.00% 826,849 53 37% 1,140 0 00% 93,144 38.78% 11,215 34.03% 28,766 47.98% 26,370 12.10% 7,612 19 87% 112,121 180.31% 20,664 77 04% 25,581 57 36% 18,667 47.42% 25,877 64 35% 137,144 57.93% 12,750 0 00% 4,554,924 =55:37 %Spent 0.00% 59 89% 0 00% 0.00% 59 19% 57 18% 65 97% 61 24% 17 76% 0 00% 0 00% 28 40% 30.21% 0 00% 12 14% 38 36% 10 01% 48.0D% 15 1PUBLIC'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 64 MACHINERY EQUIPMENT "77W"-"" i`s'''tt 3tiS" PAFFCIMAIITE►`NCE` 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 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS LEASES 47 PUBLIC UTILITY SERVICES 48 REPAIRS MAINTENANCE 49 MISCELLANEOUS 63 OTHER IMPROVEMENTS 64 MACHINERY EQUIPMENT Kip MAINWANGE 16 Annual Budget (68,444) 2,133,282 3,500 4,556 163,811 113,705 18,377 552,210 3,800 122,460 68,750 958,900 39,250 5,800 57,961 379,449 204,521 69,335 20,000 ;ud (31,583) 456,156 35,020 2,295 37,750 26,203 13,300 98,712 1,425 46,000 2,500 22,000 1,000 500 86,776 140,000 52,000 4,000 10,000 2,500 Actual Spent 988,803 1,754 74,837 52,237 11,323 247,904 322 53,130 175,436 884,467 49,337 6,950 96,658 157,822 92,508 7,574 111,186 ctua S'p„ 270,957 3,247 1,205 20,551 14,578 7,374 57,434 180 19,662 1,335 12,775 44 34,026 78,399 10,899 502 Remaining.; Budget, (68,444) 1,144,479 3,500 2,802 88,974 61,468 7,054 304,306 3,478 69,330 (106,686) 74,433 (10,087) (1,150) (38,697) 221,627 112,013 61,761 (91,186) dgen (31,583) 185,199 31,773 1,090 17,199 11,625 5,926 41,278 1,245 26,338 1,165 9,225 956 500 52,750 61,601 41,101 3,498 10,000 2,500 Spent 0.00% 46 35% 0.00% 38.50% 45.68% 45 94% 61.62% 44.89% 8.47% 43.39% 255.18% 92.24% 125.70% 119.82% 166 76% 41.59% 45.23% 10 92% 555.93% pe,i 0 00% 59.40% 9 27% 52.52% 54.44% 55 63% 55.45% 58.18% 12.63% 42.74% 53.39% 58.07% 4.44% 0.00% 39.21% 56.00% 20.96% 12.55% 0.00% 0.00% ;:97°jo 3;169 :;`z, s" °t 473;3 16 STREET. MAINTENANCE OPERATION 00 UNALLOCATED BUDGET REDUCTION 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 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 49 MISCELLANEOUS 53 EXT TAXES OPERATING ASSMNTS 64 MACHINERY EQUIPMENT TREET -;MA!'NTENAN CE& OPER4T10N ..v.e Z NTRIBUTLQ ND 01 ESTIMATED UNSPENT APPROPRIATION 25 MEDICAL,DENTAL,LIFE,OPTICAL 26 UNEMPLOYMENT COMPENSATION 41 PROFESSIONAL SERVICES 47 PUBLIC UTILITY SERVICES 49 MISCELLANEOUS_ CONTRIBUTIONS;=% FU ND,BAL:AN Annual Budget Actual Spent (82,443) 771,888 412,537 43,723 11,184 11,474 2,934 63,345 32,278 43,721 22,013 20,639 11,379 225,190 119,540 2,354 2,375 623 368,800 122,770 10,931 25,116 4,000 4,551 4,300 577 2,700 126 1,500 415,088 156,171 35,455 27,315 661,930 551,587 27,100 15,793 5,200 930 2 20,000 2; 656,916; 1;519,778 nnua: �A ctuaf_Spen 8,568,638 55,000 568:,6.38 55;000 Remaining Budget (82,443) 359,351 32,539 8,540 31,067 21,708 9,260 105,650 (2,354) 1,752 246,030 (14,185) (551) 3,723 2,574 1,500 258,917 8,140 110,343 11,307 4,270 (2) 20,000 1 ,,137;138 Spent 0 00% 53 45% 25 58% 25 57% 50 96% 50.35% 55 14% 53 08% 0 00% 26.21% 33.29% 229 77% 113 78% 13 41% 4 66% 0 00% 37 62% 77.04% 83 33% 58 28% 17.88% 0 00% 0.00% 7:20% Remains Budget Spen 8,568,638 0.00% 0.00% 0 00% 0 00% 0 00% 0 00% ,8;513;638 ;0:64%; (55,000) 17 Grand Totals, 00 MISCELLANEOUS GENERAL GOVERNMT E.R 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 COMPENSATION 28 UNIFORM CLOTHING 31 OFFICE OPERATING SUPPLIES 34 ITEMS PURCH. FOR INVENT /RESALE 35 SMALL TOOLS MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS LEASES 46 INSURANCE 47 PUBLIC UTILITY SERVICES 48 REPAIRS MAINTENANCE 49 MISCELLANEOUS 51 INTERGVRNMTL PROFESSIONAL SVCS 53 EXT TAXES OPERATING ASSMNTS 63 OTHER IMPROVEMENTS 64 MACHINERY EQUIPMENT 3�aidTotats�' 18 Annual Budget 8,073,865 23, 500,643 670,844 1,586,070 178,248 1,541,946 680,359 655,334 309,605 6,124,452 20,000 10,545 1,155,123 19,000 112,781 3,298,520 347,738 134,665 60,000 1,247, 550 628,035 1,342,379 565,011 1,188,721 2,080,400 10,000 331,071 #558T29A5 Actual Spent 56,805 12,848,748 292,724 765,364 821,518 366,563 334,857 214,829 3,277,638 83,424 1,124 406,416 24,465 221,710 1,846,967 142,838 32,869 14,573 1,018,674 459,127 887,717 276,483 547,019 941,693 201 137,773 X26022 1:20.�t= Remaining, Budget: 8,017,060 10, 651, 895 378,120 820,705 178,248 720,428 313,795 320,477 94,776 2,846,814 (63, 424) 9,421 748,707 (5,465) (108,929) 1,451,554 204,900 101,796 45,427 228,876 168,908 454,662 288,528 641,702 1,138, 707 (201) 10,000 193,298 29`s 85 ";4` Spent 0.70% 54 67% 43.64% 48.26% 0 00% 53.28% 53 88% 51.10% 69.39% 53.52% 417 12% 10.66% 35.18% 128 76% 196.58% 55 99% 41.08% 24.41% 24.29% 81.65% 73.11% 66.13% 48.93% 46 02% 45.27% 0 00% 0 00% 41 61% '045':57%0` City of Tukwila Hotel /Motel Tax Fund 101 Revenue and Expenditures As of July 31, 2010 Revenue General Revenue Hotel /Motel Taxes Total General Revenue Intergovernmental Revenue Miscellaneous Revenue Investment Earnings Other Misc Revenue Total Miscellaneous Revenue Total Re v ue Expenditures 11 Salaries 12 Extra Labor 13 Overtime 21 FICA 22 LEOFF 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 Expens'e& Change in Fund Balance Beginning Fund Balance Ending FiindBalance 600,000 249,396 (350,604) 41 57% 600,000 249,396 (350,604) 41.57% Fund 101 of year expired 58 33% 2010 Actual Adjusted (Year -To- of Budget Date) Variance Budget 607,000 309,702 (297,298) 51 02% 20,000 2,111 (17,889) 10 56% 5,000 9,575 4,575 191 51% 25,000 11,687 (13,313) 46.75% 1,232,000 570,785 (661,215) 46.33% 263,469 151,497 (111,972) 57.50% 24,000 8,432 (15,568) 35 13% 10,110 20,714 10,604 204 89% 22,856 13,511 (9,345) 59 11% 716 716 000% 23,808 8,847 (14,961) 37 16% 1,283 1,122 (161) 87.46% 49,834 26,728 (23,106) 53.63% 16,000 19,353 3,353 120.96% 201,000 177,259 (23,741) 88.19% 45,000 35,175 (9,826) 78 17% 23,000 5,427 (17,573) 23 59% 485,000 213,785 (271,215) 44.08% 49,000 17,222 (31, 778) 35 15% 1,500 708 (792) 47.21% 1,000 291 (709) 29 11% 21,000 9,145 (11,855) 43 55% 10,000 3,293 (6,707) 32.93% 1;247,860 713,225 (534,635) 57.16% (15,860) (142,441) (126,581) 89811% 632,964 919,722 286,758 145.30% 617,104 777,281 160,177 126.96% 19 City of Tukwila Street Fund 103 Revenue and Expenditures As of July 31, 2010 of year expired 58.33% 2 0 Revenue Intergovernmental Revenue (MVFT Taxes) Miscellaneous Revenue Investment Earnings ,Total Revenu Total Miscellaneous Revenue Expenditures 41 Professional Services 64 Capital,Outlay Change in Fund Balance Beginning Fund Balance an 300,000 150,334 (149,666) 50.11% 10,000 10.000 2,413 (90,000) 317,000 Fund 103 2,413 400,000 (147,253) 634,793 (7,587) 24.13% (7,587) 24 13% (400,000) 0.00% 300,000 300,000 0.00% (57,253) 163 61% 817.793 208.2596 City of Tukwila Arterial Street Fund 104 Revenue and Expenditures As of July 31, 2010 Revenue General Revenue Sales and Use Taxes Parking Taxes Real Estate Excise Taxes Total General Revenue Intergovernmental Revenue Miscellaneous Revenue Investment Earnings Contributions /Donations Total Miscellaneous Revenue Sale of Capital Assets Debt Proceeds 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 44 Advertising 45 Operating Rentals Leases 47 Public Utility Services 48 Repairs Maintenance 49 Miscellaneous 64 Capital Outlay Total Arterial Streets 104 Transfers Out Ex Change in Fund Balance Beginning Fund Balance Ending Fund Balance 2,900,000 140,000 500,000 3,540,000 29,670,000 300,000 3,138,000 3,438,000 20,158,000 56,806,000 211,037 3,000 16,374 17,380 3,020 27,210 8,790,000 53,043,000 62,111, 021 639,936 62750,957 (5,944,957) 8,636, 736 2,691,779 Fund 104 2010 Actual (Year-To- Date) 1,179, 538 79,360 27,021 1,285,919 2,152,020 24,589 501,022 525,612 27,000 3,990,551 197,053 35 12,410 15,653 11,125 749 33,441 18,649 1,114,130 173 998 1,239 212 1,295 2,800,056 4,207,217 373,296 4,580,513 (589,962) 5,820,775 5,230,813 of year expired 58.33% loot Variance Budget (1,720,462) (60,640) (472, 979) (2,254, 081) (27,517,980) (275,411) (2,636,978) (2,912,388) 27,000 (20,158,000) (52,815,449) (13,984) (2,965) 12,410 (721) (6,255) (2,271) 6,231 18,649 (7,675, 870) 173 998 1,239 212 1,295 (50,242,944) (57,903,804) (266,640) (58,170,444) 5,354,995 (2,815, 961) 2,539,034 40 67% 56 69% 5 40% 36 33% 7.25% 8.20% 15 97% 15.29% 0 00% 0 00% 7.02% 93 37% 1 17% 0 00% 95 60% 64 01% 24.82% 122 90% 0 00% 12.67% 0.00% 0.00% 0.00% 0.00% 0 00% 5.28% 6 77% 58.33% ".7:30 /a 9 92% 67 40% 194.33% 21 22 City of Tukwila Contingency Fund 105 Revenue and Expenditures As of July 31, 2010 Revenue Miscellaneous Revenue Investment Earnings Total Miscellaneous Revenue Change in Fund Balance Beginning Fund Balance 100:raitT4:544 ii; 18,000 1,831 (16,169) 18,000 1,831 (16,169) 18,000 1,831 (16,169) 10 17% 874,187 885,462 11,275 101.29% V:4;','$714RiV119 P Fund 105 of year expired 58 33% 10.17% 10.17% ,tittOliftiMiere4t140149)2:,.:%4E,;74iVIOArY01 City of Tukwila Fire Equipment Cum. Reserve 107 Revenue and Expenditures As of July 31, 2010 Change in Fund Balance Beginning Fund Balance Revenue Miscellaneous Revenue Investment Earnings Total Miscellaneous Revenue Expenditures 31 Office Operating Supplies 64 Capital Outlay Total Expenses 2010 Actual Adjusted '(Year:TO- ii% of Midget 'Dat Viriante Bnildet, HS 10,000 10,000 2,000 8,000 427,000 Fund 107 952 (9,048) 9 52% (2,000) 0.00% 713 713 0 00% _35:04% 239 641,542 of year expired 58.33% 952 (9,048) 9.52% (7,761) 2.99% 214,542 150.24% ;781 20081 :,-,:147.:84W 23 24 City of Tukwila Drug Seizure Fund 109 Revenue and Expenditures As of July 31, 2010 Revenue Miscellaneous Revenue Investment Earnings Seizure Revenue Total Miscellaneous Revenue 'TotaTReve iue Change in Fund Balance Beginning Fund Balance In Balace' Expenditures 31 Office Operating Supplies 41 Professional Services 42 Communication 43 Travel 45 Operating Rentals Leases 48 Repairs Maintenance 49 Miscellaneous 64 Capital Outlay T ot a POW' ;.'..e 200,000 200,000 =2 00;000 20,000 4,500 500 10,000 23,000 2,000 5,000 105,000 17 w 30,000 Fund 109 1,767 36,000 37,767 37;767. 1,027 1;027 36,740 221,108 of year expired (20,000) (3,473) (500) (10,000) (23,000) (2,000) (5,000) (105,000) 41.6819731 6,740 221,108 58 33% 1,767 0.00% (164,000) 18.00% (162,233) 18.88% 0.00% 22.82% 0.00% 0.00% 0.00% 0.00% 0 00% 0.00% 4.0'0%1 122.47% 0.00% 't,9 8 59:'49 %0 City of Tukwila Debt Service Funds 2XX Revenue and Expenditures As of July 31, 2010 Revenue General Revenue Sales and Use Taxes Total General Revenue Miscellaneous Revenue investment Earnings Total Miscellaneous Revenue Expenditures 80 Debt Servce Principal 81 Debt Service Interest Change in Fund Balance Beginning Fund Balance �y« �r~~.°°� of �6o �mtm) of year expired 58.3396 2.062.083 913.685 (1,148,398) 443196 2.062.083 913,685 (1.148.398) 44.3196 44,000 4,284 (39,716) 9 74% 44,000 4,284 (39.718) 9 74% 1,394,028 (1,394,028) 0 0096 748.001 339.189 (408,812) 453596 4142029 330\189 (1,802,840) 15.83%, (35.046) 578.780 614.726 -1610 14% 1.161.631 135,438 (1. 11 76% 1,115,685 714��8 4. Funds 2XX 25 26 City of Tukwila Open Space and Parks Acq. Fund 301 Revenue and Expenditures As of July 31, 2010 Revenue General Revenue Property Taxes Sales and Use Taxes Real Estate Excise Taxes Total General Revenue Charges for Services Park Impact Fees Total Charges for Services Intergovernmental Revenue Miscellaneous Revenue Investment Earnings Rents and Concessions Total Miscellaneous Revenue rY srs�a -us tal 6Wifird Expenditures 11 Salaries 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 31 Office Operating Supplies 41 Professional Services 44 Advertising 47 Public Utility Services 48 Repairs Maintenance 64 Capital Outlay Total Park Acquisition Fund Transfers Out ftolal:L Rk Change in Fund Balance Beginning Fund Balance Et�aliixgi Fund alance 210,000 500,000 710,000 1,615,000 127,000 127,000 53:0,00: Fund 301 27,164 84,915 27,177 139,256 96,961 96,961 18,757 3,115 21,871 258Q$8- =3 5,252 392 279 15 1,014 5,260 404,000 20,243 227 1,000 15,000 1,780 1,724,000 206,498 2,143,000 241,959 60,446 35,260 03;446 277 ;111 of year expired 27,164 (125,085) (472,823) (570, 744) 96,961 96,961 (1,615,000) (108,243) 3,115 (105,129) -(V1 11120 5,252 0.00% 392 0.00% 279 0.00% 15 0.00% 1,014 0.00% 5,260 0 00% (383, 757) 5.01% 227 0 00% 1,000 0.00% (13,220) 11.87% (1,517,502) 11.98% (1,901,041) 11.29% (25,186) 58.33% ,(1;;91 ;22 /t 1 58 %1 248,554 (19,131) (267,685) 3,994,879 4,668,345 673,466 ,244; 43 4 649 ?14; '4 Al 09 ::6061 58.33% 0.00% 40 44% 5 44% 19.61% 0.00% 0 00% 0.00% 14.77% 0.00% 17.22% 53°tp -7.70% 116.86% City of Tukwila Facility Replacemerit Fund 302 Revenue and Expenditures As of July 31, 2010 Expenditures 11 Salaries 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, OptcaI 41 Professional Services 47 PubIic Utility Services 49 Miscellaneous 64 Capital O Change in Fund Balance Beginnirig Fund Balance 2010 Actual (Year-To- Variance 'Budget Date) Budget Revenue Charges for Services Sales and Use Taxes 205 205 0 00% Total Charges for Services 205 205 0 00% Miscellaneous Revenue Investment Earnings 100 3.078 3 08% Forfeitures 2.500 2.500 0.00Y6 Total Miscellaneous Revenue 100.000 5,578 5 58% Transfers In 130.000 (1 0.0096 155 155 0 0096 12 12 0.80% 8 8 O80Y6 1 1 0.00% 49 49 OU096 140.000 1.379 (138,722) 0 81Y6 G.310 G.31O 0.00% 350 350 0.00% 1.000.000 0.0096 00.000 (2,484) (92,484) -2.76Y6 6,289,000 2,073,918 (4,215,082) 32 98% -5,379,000 Fund 302 of year expired 58 33% 27 28 City of Tukwila General Government improvements 303 Revenue and Expenditures As of July 31, 2010 Revenue Charges for Services Sales and Use Taxes Total Charges for Services Intergovernmental Revenue Miscellaneous Revenue Investment Earnings elnuef Expenditures 11 Salaries 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 41 Professional Services 49 Miscellaneous 64 Capital Outlay Change in Fund Balance Beginning Fund Balance aIance 306,000 306,000 20,000 10,304 (9,696) 51.52% 30,000 3$6 ;000 91,703 7,016 7,446 1,385 26,459 60,000 475,000 710,091C- (378,009) 541,425 Fund 303 123,290 123,290 451 (29,549) 1.50% 0 00% 30 4 5 $`...h 221955 1 V :37:85 /a 15,623 66 1,197 833 67 2,992 2,454 29,539 4,058 5$;6 of year expired (182,710) (182,710) (76,080) 17.04% 66 0 00% (5,819) 17.06% (6,613) 11.19% (1,318) 4 84% (23,467) 11.31% (57,546) 4.09% 29,539 0.00% (470,942) 0.85% 58.33% 40.29% 40.29% 75,226 453,235 19.90% 345,649 (195,776) 63 84% City of Tukwila Fire Impact Fees 304 Revenue and Expenditures As of July 31, 2010 Revenue Charges for Services Fire Impact Fees Total Charges for Services Total Retiethle Expenditures 64 Capital Outlay 1 Change in Fund Balance Beginning Fund Balance Fund 304 of year expired 58.33% 136,946 136,946 0.00% 136,946 136,946 0.00°/0 0 00% 1 136,984, 136;984 "0.00%= Bud 0 00% 0.00% 136,984 136,984 0 00% 13,346 13,346 0 00% 150,330 L 150,330 0.00%' 29 30 City of Tukwila Water Fund 401 Revenue and Expenditures As of July 31, 2010 Revenue Charges for Services Water Sales Total Charges for Services Intergovernmental Revenue Miscellaneous Revenue Investment Earnings Contract principal payments Other Misc Revenue Total Miscellaneous Revenue vases 0 Expenditures 11 Salaries 12 Extra Labor 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 26 Unemployment Compensation 28 Uniform Clothing 31 Office Operating Supplies 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 Services 48 Repairs Maintenance 49 Miscellaneous 53 Excise Taxes 54 Interfund utility taxes 64 Capital Outlay 80 Debt Service Principal 81 Debt Service Interest Total Water Fund Transfers Out, m3 t Change in Fund Balance Beginning Fund Balance Ending Fund Ba %aif'ce'S 4,895,000 4,895,000 200,000 75,000 1,000 276,000 1 508,185 6,000 5,738 39,774 42,217 10,886 139,094 1,000 1,330 91,811 1,950,500 4,500 274,300 2,500 1,500 77,811 20,260 23,000 11,000 7,200 184,000 490,000 1,002,400 496,359 156,667 5,548,032 608,400 6 :i56,452'� (889,432) 3,999,209 1:09,7 Fund 401 2,329,945 2,329,945 112,848 30,692 23,979 320 54,991 6 654;589:{ 295,566 2,089 22,705 15,797 6,651 78,345 195 45,237 1,092,989 11,662 56,632 245 836 46,575 15,608 9,774 1,319 13,907 100,627 244,652 42,784 262,042 90,831 2,457,066 354,900 2;81:1.;966 (257, 377) 6,116,633 5;8 "59;257 of year expired (2,565,055) 47.60% (2,565,055) 47 60% 112,848 0.00% (169,308) 15.35% (51,021) 31.97% (680) 32.00% (221,009) 19.92% 1241'Z4f1 480'/i1 (212,619) (6,000) (3,649) (17,069) (26,420) (4,235) (60,749) (1,000) (1,135) (46,574) (857,511) 7,162 (217,668) (2,255) (664) (31,236) (4,652) (13,226) (9,681) 6,707 (83,373) (245,348) (959,616) (234,317) (65,836) (3,090,966) (253,500) (3;344;4661 632,055 2,117,424 58 33% 58.16% 0 00% 36.40% 57 08% 37.42% 61.09% 56.33% 0.00% 14.66% 49.27% 56.04% 259.16% 20 65% 9 78% 55 73% 59 86% 77 04% 42.49% 11 99% 193.15% 54.69% 49 93% 4.27% 52.79% 57.98% 44.29% 58.33% W45:68%i 28.94% 152 95% 08',41% City of Tukwila Sewer Fund 402 Revenue and Expenditures As of July 31, 2010 Revenue Charges for Services Sewer Sales Total Charges for Services Miscellaneous Revenue Investment Earnings Contract principal payments Total Miscellaneous Revenue ,Total FZeve►ile' 4... _.u,._ Expenditures 11 Salaries 12 Extra Labor 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 26 Unemployment Compensation 28 Uniform Clothing 31 Office Operating Supplies 33 Water Purchased for Resale 35 Small Tools Minor Equipment 41 Professional Services 42 Communication 43 Travel 44 Advertising 45 Operating Rentals Leases 46 Insurance 47 Public Utility Services 48 Repairs Maintenance 49 Miscellaneous 53 Excise Taxes 54 Interfund utility tax 64 Capital Outlay 80 Debt Service Principal 81 Debt Service Interest Total Sewer Fund Transfers Out Total Expenses Change in Fund Balance Beginning Fund Balance Ending Fund Balance Adjusted: ,..Budget 5,178,000 5,178,000 50,000 400,000 450,000 5,628,000 261,481 8,000 3,442 20,879 22,161 5,513 60,316 1,000 570 22,100 3,749,000 4,000 271,600 2,500 500 150 100,571 15,195 22,050 43,000 4,000 40,000 550,000 575,000 266,661 92,488 6,142,177 499,335 6,641,512 (1,013,512) 4,613,297 2010 Actual (Year-To- Date) 3,053,670 3,053,670 4,880 (45,120) 9 76% 97,056 (302,944) 24 26% 101,936 (348,064) 22 65% 3,155,606 (2,472,394) 56.07% 152,304 4,332 565 11,948 8,150 3,041 35,194 195 11,349 1,787,774 2,449 4,389 612 508 76,428 11,706 13,188 18,392 8,961 35,977 351,031 18,548 241,261 57,741 2,856,042 291,279 3,147,321 8,285 1,793,638 .3,599,785' 1,801,923 of year expired 58.33% of Variance: Budget (2,124,330) (2,124,330) (109,177) (3,668) (2,878) (8,931) (14,011) (2,472) (25,122) (1,000) (375) (10,751) (1,961,226) (1,551) (267, 211) (1,888) 8 (150) (24,143) (3,489) (8,862) (24,608) 4,961 (4,023) (198,969) (556,452) (25,400) (34,747) (3,286,135) (208,056) (3,494,191) 58 97% 58 97% 58.25% 54 15% 16 40% 57.23% 36 78% 55.16% 58.35% 0 00% 34.21% 51 36% 47.69% 61.23% 1.62% 24 49% 101.69% 0 00% 75 99% 77 04% 59 81% 42.77% 224 01% 89 94% 63.82% 3.23% 90.47% 62.43% 46.50% 58 33% 47.39% 1,021,797 -0 82% (2,819,659) 38 88% 11,797,862) 50.06% Fund 402 31 32 City of Tukwila Foster Golf Course 411- Revenue and Expenditures As of July 31, 2010 Revenue General Revenue Sales and Use Taxes Excise Taxes Total General Revenue Charges for Services Sale of Merchandise Greens Fees, Instruction Total Charges for Services Miscellaneous Revenue Investment Earnings Rents and Concessions Other Misc Revenue Total Miscellaneous Revenue ;,,Total %ReYehue`�; Expenditures 11 Salaries 12 Extra Labor 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 26 Unemployment Compensation 28 Uniform Clothing 31 Office Operating Supplies 34 Items Purchased for Resale 35 Small Tools Minor Equipment 41 Professional Services 42 Communication 43 Travel 44 Advertising 45 Operating Rentals Leases 46 Insurance 47 Public Utility Services 48 Repairs Maintenance 49 Miscellaneous 53 Excise Taxes 54 lnterfund utility tax 64 Capital Outlay 80 Debt Service Principal 81 Debt Service Interest Total Foster Golf Course Fund Transfers Out Total Expenses Change in Fund Balance Beginning Fund Balance ,Ending Fund Balance usted udget`' 450,000 450,000 170,000 1,310,000 1,480,000 10,000 322,000 332,000 2;262,000.. 628,455 133,900 6,885 58,846 62,462 24,992 162,552 11,000 1,164 97,000 130,500 2,500 9,000 9,700 1,250 30,000 137,515 15,195 64,765 36,000 13,250 6,000 50,000 184,972 148,489 2,026,392 13,140 2 039,532 222,468 498,893 721;'361 Fund 411 2010, Actua ear =To Date) 184,527 1,016 185,543 82,937 663,726 746,663 726 158,586 (624) 158,687 090 ;894 364,600 56,191 1,728 31,533 21,151 10,376 83,833 7,798 182 44,289 69,482 5,920 25,102 4,106 31 1,187 79,382 11,706 39,157 28,557 8,933 3,013 28,207 2,892 61,760 991,115 7,665 998,780 92,113 3,631 95,744 of year expired Variance B udget (265,473) 41.01% 1,016 0.00% (264,457) 41.23% (87,063) (646,274) (733, 337) (9,274) (163,414) (624) (173,313) :171106) 58.33% 48.79% 50.67% 50.45% 7.26% 49.25% 0.00% 47.80% (263,855) 58.02% (77,709) 41.96% (5,157) 25.10% (27,314) 53.58% (41,311) 33.86% (14,616) 41.52% (78,719) 51.57% (3,202) 70.89% (982) 15.63% (52,711) 45.66% (61,018) 53.24% 3,420 236.80% 16,102 278.91% (5,594) 42.33% (1,219) 2.46% (28,813) 3 96% (58,133) 57.73% (3,489) 77 04% (25,608) 60 46% (7,444) 79.32% (4,317) 67.42% (2,987) 50.21% 28,207 0.00% (47,108) 5.78% (184,972) 0.00% (86,729) 41.59% (1,035,277) 48.91% (5,475) 58.33% ':(1,040,752) 48.97% (130,355) 41 41% (495,262) 0.73% (625,61 City of Tukwila Surface Water Fund 412 Revenue and Expenditures As of July 31, 2010 Revenue Charges for Services Surface Water Sales Total Charges for Services Miscellaneous Revenue Investment Earnings Other Misc Revenue Total Miscellaneous Revenue Total Rei4enie Expenditures 11 Salaries 12 Extra Labor 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 26 Unemployment Compensation 28 Uniform Clothing 31 Office Operating Supplies 34 Items Purchased for Recharge 35 Small Tools Minor Equipment 41 Professional Services 42 Communication 43 Travel 44 Advertising 45 Operating Rentals Leases 46 Insurance 47 Public Utility Services 48 Repairs Maintenance 49 Miscellaneous 53 Excise Taxes 54 Interfund utility tax 64 Capital Outlay 80 Debt Service Principal 81 Debt Service Interest Total Surface Water Fund Transfers Out Total E Change in Fund Balance Beginning Fund Balance 'Endirig' Rim d Balance Adjusted Budget 3,042,000 3,042,000 130,000 130,000 3,172,000 672,863 23,000 11,653 54,124 57,450 15,293 250,370 1,000 1,425 40,955 3,000 438,570 2,000 2,000 500 81,507 15,195 61,600 13,965 6,500 25,000 318,000 575,000 343,615 35,353 3,049,938 375,815 3,425,753 (253,753) 5,401,203 5,147,450 201 Actual (Year M bate) 3,009,750 3,009,750 11,650 58,539 70,189 3,079,938 412,593 26,163 2,487 33,263 22,706 9,366 122,587 95 10,359 2,608 200,470 913 47,830 11,706 5,805 2,453 15,230 17,733 225,945 80,473 317,617 16,259 1,584,660 219,225 1,803,886 1,276,053 2,128,642 3,404,695 of year expired 58 33% %'of Variance: Budget (32,250) 98.94% (32,250) 98 94% (118,350) 8.96% 58,539 0.00% (59,811) 53 99% (92;062 97:10% (260,270) 61.32% 3,163 113.75% (9,166) 21 34% (20,861) 61 46% (34,744) 39.52% (5,927) 61.24% (127,783) 48 96% (1,000) 0.00% (1,330) 6 67% (30,596) 25.29% 0 00% (392) 86 92% (238,100) 45.71% (2,000) 0.00% (1,087) 45.64% (500) 0.00% (33,677) 58 68% (3,489) 77 04% (55,795) 9.42% (11,512) 17 57% 8,730 234 31% (7,267) 70.93% (92,055) 71 05% (494,527) 14 00% (25,998) 92 43% (19,094) 45.99% (1,465,278) 51 96% (156,590) 58.33% (1,62 1;868) 52.66% 1,529,806 502 87% (3,272,561) 39 41% (1,742,755) 66.14% Fund 412 33 34 City of Tukwila Equipment Rental /Replacement Fund 501 Revenue and Expenditures As of July 31, 2010 Revenue Charges for Services ERR O &M Dept Charges Equipment Replacement Charges Fuel Sales Transportation Total Charges for Services Miscellaneous Revenue Investment Earnings Total Miscellaneous Revenue Sale of Capital Assets 9 eYO. Transfers Out f =7'o fa[E xpeh se Change in Fund Balance Beginning Fund Balance Ending.Fu iial Balance Expenditures 11 Salaries 12 Extra Labor 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 26 Unemployment Compensation 28 Uniform Clothing 31 Office Operating Supplies 34 Items Purchased for Resale 35 Small Tools Minor Equipment 41 Professional Services 42 Communication 45 Operating Rentals Leases 46 Insurance 48 Repairs Maintenance 49 Miscellaneous 64 Capital Outlay Total Equipment Rental Fund 50,000 50,000 26 483 321,747 10,000 1,147 25,467 27,031 7,757 102,215 1,000 950 2,000 689,000 2,500 550 2,000 18,297 10,130 130,781 6,500 391,300 1,750,372 199,734 95©.00 yv 704,724 5,557,012 ,81261:;t36 Fund 501 1,346,469 785,750 784,361 107,668, 474,000 276,500 101 2,604, 830 1,170, 019 8,637 8,637 12,563 188,860 6,465 14,838 10,372 5,141 55,928 271 604 243,163 2,986 513 606 10,673 7,806 20,247 3,515 215,030 787,019 116,512 =903;530 287,689 6,462,672 6;7.80 ,361= of year expired (83,223) 58.33% M 046 57G), (560,719) (676,693) (197,500) 101 (1,434,811) (41, 363) (41,363) 12,563 0.00% (132,887) 58.70% (3,535) 64.65% (1,147) 0.00% (10,629) 58.26% (16,659) 38 37% (2,616) 66.28% (46,287) 54 72% (1,000) 0 00% (679) 28.52% (1,396) 30.22% (445,837) 35.29% 486 119 45% (37) 93 32% (1,394) 30.28% (7,624) 58.33% (2,324) 77.06% (110,534) 15.48% (2,985) 54.07% (176,270) 54.95% (963,353) 44.96% 58.33% 58.36% 13.73% 58.33% 0.00% 44.92% 17.27% 17.27% (417,035) 40.82% 905,660 116.30% 488;68 r8o% City of Tukwila Insurance Fund 502 Revenue and Expenditures As of July 31, 2010 Revenue Charges for Services Employee Benefit Programs Total Charges for Services Miscellaneous Revenue Investment Earnings Employer Trust Contributions Employee Contributions Other Misc Revenue :Total :R'e:vencie Expenditures 25 Medical, Dental, Life, Optical 41 Professional Services 49 Miscellaneous t Total :**7* ses Change in Fund Balance Beginning Fund Balance 900 900 25,000 6,300,731 67,000 6;393,63' 5,719,830 25,000 20,500 "5,765;330 628,301 1,516,241 Z144,$42 Fund 502 .201.0 Actual (Year -To- Date) 11,397 3,192,799 34,129 4,111 3,242,828 2,313,014 11,025 5,318 2,329 913,471 3,381,691 4,295,161 of year expired 58 33% %of" Variance Budget 392 (508) 43 54% 392 (508) 43 54% (13,603) (3,107,932) (32,871) 4,111 (3,150,803) (3,406, 816) (13,975) (15,182) (3,435,973) 285,170 1,865,450 45.59% 50 67% 50 94% 0 00% 50.72% 40 44% 44 10% 25 94% ,40.40% 145.39% 223.03% 2 ;150,619 200.20% 35 3 6 `~~.y of Tukwila LEOFF Insurance Fund 503 Revenue and Expenditures As of July 31, 2010 Revenue Miscellaneous Revenue Investment Earnings Employer Trust Contributions Other Misc Revenue Expenditures 25 Medical, Dental, Lifa, Optical 41 Professional Services 49 Miscellaneous Change in Fund Balance Beginning Fund Balance TeJLIkik 20,000 765,523 659,530 3,000 10,000 Fund 503 of year expired 58.33% 3,885 (16.115) 19.4296 331.610 (433.913) 43.32% 454 454 0.8096 158.063 (501,487) 23.9796 1,225 (1,775) 40.8396 0.000) 8.0096 112.993 176.660 63,667 15G3596 841,069 1.251.360 410.291 14878Y4