Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Reg 2011-05-16 Item 2B - Presentation - 2010 Fourth Quarter Financial Report
December, 2010 Mr I1 TUKWILA tr. 0 1 —+ V ;0 olosi ;m1 Cij F4J w o • ow NI Summary City -wide, unreserved fund balances increased $7.4 million in 2010 from $41.7 million at December 31, 2009 to $49.1 million at December 31, 2010. The gov- ernmental funds contributed $4 9 million to the increase, the internal service funds contributed $1.5 million to the increase and the enterprise funds contributed $1 million to the increase. The change in each of the governmental funds is dis- played in the chart below. Of the governmental funds, the General Fund experi- enced a decline in unreserved fund balance of $1.7 million. The General Fund revenue and expenditures for 2010 are discussed in more detail in the following pages. Offsetting the General Fund decline, the special revenue fund group ex- perienced an increase of $5.3 million and the capital project fund group experi- enced an increase of $1.4 million in unreserved fund balances. These increases are due largely to the $5.9 million 2010 bond issuance whereby $4.3 million was allocated to the 104 Arterial Street fund and $1 5 million was allocated to the 301 General Government Improvement fund. If the governmental fund balances are considered without regard to the 2010 bond issuance, the annual change would be a $960,000 decline. Though the economy continues to be weak, there are signs of improvement. Monthly sales tax revenue has been higher than the corresponding prior year monthly revenue for five consecutive months with an average increase for these five months of 10 %. Other revenues have also shown increases with property tax revenue bringing in $1 million more in 2010 than 2009. The City was also able to control expenditures staying within or below budget partially by not filling posi- tion vacancies during 2010. In 2011, the budgetary strategies that were enacted for the 2011 -2012 biennium will play a role in determining the financial health of the City. $16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 $- Government Funds - Unreserved Fund Balances 9,123,402 `$7,389,431 • • • ,0 14,518,478 • ,613,939 Dec -09 Mar -10 Jun -10 Sep -10 Dec -10 —4— General Fund -III Special Revenue —Air— Capital Project —X— Debt Service 12/31/2009 07/31/2010 09/30/2010 12/31/2010 General Fund $ 7,389,431 $ 5,692,047 $ 3,895,243 $ 5,144,695 Special Revenue 9,123,402 8,282,556 14,588,913 13,479,588 Capital Project 7,087,913 7,291,853 9,281,435 8,461,154 Debt Service 135,438 714,218 1,130,074 3,050 Total Government Funds $ 23,736,183 $ 21,980,675 $ 28,895,666 $ 27,088,487 Increase (Decrease) Annual Quarter $(2,244,736) $ 1,249,451 4,356,186 $ (1,109,325) 1,373,242 $ (820,281) (132,388) $ (1,127,024) $ 3,352,305 $ (1,807,178) Inside this issue: General Fund Status 2 Sales Tax 3 Property Tax 4 Utility Taxes 4 Excise Taxes 4 Permit Income 5 Plan Check & Other Fees 5 Intergovernmental Revenue 5 1 General Fund Status The General Fund experienced a $1.7 million decline in fund balance in 2010 representing a $1,238,010 shortfall compared with budget. Revenues totaled $43,122,724 which was $4,474,265 less than budget due primarily to a decline in sales tax revenue. Expenditures also came in under budget totaling $44,898,215 for the year. The savings from reduced expenses provided an additional $3,236,256 to the budget. The departments responsible for the larg- est savings were Police with a $859,776 savings, Fire with a $377,043 savings and Recreation with a $372,501 sav- ings. Salary and benefits were held near 2009 levels with total 2010 expenditures of $32,629,767 representing a $200,000 cost reduction as compared with 2009 totals of $32,831,104. GENERAL FUND DEPARTMENT BUDGETS DEPARTMENTS 2010 %of Budget 2009 %of Budget 2008 %of Budget City Council $ 242,851 85.8% $ 251,563 91.8% $ 261,235 95.8% Mayor (a) 2,228,656 85.6% 2,492,492 95.6% 1,493,036 93.1% Human Resources (a) 464,095 81.2% 506,060 86.1% 1,830,606 95.4% Finance 2,183,069 102.2% 1,963,333 97.0% 1,932,285 94.1% City Attorney 578,908 97.2% 685,691 113.2% 728,980 95.6% Recreation 3,130,852 89.4% 3,350,801 98.2% 3,158,534 94.5% Community Development 2,635,296 86.4% 2,779,459 101.7% 3,066,717 109.4% Municipal Court 1,208,632 103.6% 1,181,132 104.3% 1,136,752 106.0% Police 13,165,552 93.9% 12,994,938 98.8% 12,699,006 99.9% Fire 9,920,730 96.3% 9,874,049 97.4% 10,152,352 101.8% Information Technology (a) 953,361 87.8% 951,073 90.1% - - Public Works 4,572,757 92.6% 5,756,107 89.9% 3,608,739 91.5% Park Maintenance 992,222 99.3% 979,084 95.5% 965,020 99.4% Street Maintenance 2,368,562 92.1% 2,280,106 89.4% 2,573,891 102.2% Dept 20 252,671 82.8% 709,444 100.0% 376,896 35.6% TOTAL $ 44,898,215 93.3% $ 46,755,331 96.6% l $ 43,984,048 97.7% (a) The Clerk and Information Technology departments reported to Administrative Services /Hunan Resources in 2008; the Clerk department began reporting to the Mayor's department in 2009.. GENERAL FUND EXPENDITURE TYPE BUDGETS EXPENDITURE TYPE 2010 %of Budget 2009 %of Budget 2008 %of Budget Salary and benefits $ 32,629,767 92.5% $ 32,831,104 95.8% $ 30,998,441 96.4% Supplies 1,243,721 96.6% 1,000,788 79.5% 1,323,338 117.0% Professional services 8,255,412 86.7% 9,788,809 89.8% 8,703,371 106.4% Intergovernmental 2,183,336 104.9% 2,201,354 104.2% 2,153,909 125.0% Capital expenditures 330,504 86.7% 126,527 39.4% 242,599 19.0% Miscellaneous general 255,475 -62.1% 806,749 - 178.2% 562,390 101.1% TOTAL $ 44,898,215 93.3% $ 46,755,331 96.6% $ 43,984,048 97.7% Page 2 2 2010 FOURTH QUARTER FINANCIAL REPORT Sales Tax Sales tax received in 2010 totaled $14,580,838 versus $14,423,208 in 2009 representing a $157,630 in- crease year- over -year but a 28 %, or $5,826,794, deficiency compared with budget. When the $1,239,127 2010 sales tax mitigation payments are taken into account, the defi- ciency compared with budget is reduced to 22 %. Sales tax collec- tions improved during the second half of the year. December repre- sented the fifth consecutive year - over -year monthly increase, and seventh monthly increase occurring in 2010. Over half of the City's sales tax revenue was derived from five NAICS categories with code 452 - General Merchandise Stores, con- tributing $2.068,263 or 14.2 %, code 448 - Clothing and Accessories, con- tributing $2,021,704 or 13.8 %, code 722 -Food Services, Drinking Places, contributing $1,341,150 or 9.2 %, code 423, Wholesale Trade, Durable Goods contributing $1,236,905 or 8.5% and code 443- Electronics and Appliances, con- tributing $1,003,415 or 6.9 %. In total, these five NAICS categories comprise 52.6% of 2010 sales tax revenue. Sales tax charged in the City of Tukwila is 9.5 %. Of this, the State receives 6.5 %, King County re- ceives .35 %, the Regional Transit Authority receives .8 %, Metro re- ceives .9 %, Criminal Justice re- ceives .1% and the City re- ceives .84 %. $20.0 $2,000 $1,900 $1,800 - $1,700 $1,600 $1,500 $1,400 $1,300 $1,200 $1,000 $900 $800 $700 $600 $500 Sales Tax by Month - In Thousands (000) (Cumulative Monthly Sales Tax - In Millions (000,000)} - - - - - 1 - i:Iii1i1 - Feb - Apr May June July Aug - Oct Nov Dec ■2006 $1.24 - $3.95 $5.32 - - - - - - 11 - $11.36 - 1 $14.22 $15.69 $17.85 ■2007 Jan Feb Mar Ap May June July Aug Sept Oct Nov Dec $19.42 12008 12008 $1,347,2 $1.357,3 $1,601,3 $1,364,6 $1,635,4 $1,646,2 $1,534,9 $1,555,1 $1,426,4 $1,297,6 $1,263,6 $1,722,6 ■2009 $1,172,0 $1,051,1 $1,145,7 $1,191,4 $1,081,9 $1,217,4 $1,473,2 $1,118,0 $1,109,9 $1,032,2 $1,139,7 $1,689,7 02010 $1,035,6 $1,005,8 $1,157,4 $1,069,5 $1,066,8 $1,247,9 $1,250,6 $1,215,8 $1,356,6 $1,081,7 $1,201,7 $1,890,8 $20.0 $18.0 $16.0 $14.0 $12.0 - $10.0 - (Cumulative Monthly Sales Tax - In Millions (000,000)} - - 1 i:Iii1i1 Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec ■2006 $1.24 $2.53 $3.95 $5.32 $6.72 $8.37 $9.94 $11.36 $12.84 $14.22 $15.69 $17.85 ■2007 $1.32 $2.67 $4.38 $5.86 $7.36 $9.13 $10.74 $12.35 $14.05 $15.65 $17.30 $19.42 12008 $1.35 $2.70 $4.31 $5.67 $7.31 $8.95 $10.49 $12.04 $13.47 $14.77 $16.03 $17.75 ■2009 $1.17 $2.22 $3.37 $4.56 $5.64 $6.86 $8.33 $9.45 $10.56 $11.59 $12.73 $14.42 0 201 $1.04 $2.04 $3.20 $4.27 $5.34 $6.58 $7.83 $9.05 $10.41 $11.49 $12.69 $14.58 Page 3 2010 FOURTH QUARTER FINANCIAL REPORT 3 Property Tax Property taxes earned in 2010 exceeded budget by $107,942 or .83% and totaled al- most $1 million more than 2009. The City has experienced reasonably successful collec tion history with at least 99% of tax assessments being collected in each of the past 10 years. The City's levy rate for 2010 was $2.66 per $1,000 of assessed value based on a City -wide assessed valuation for 2010 was $4,809,486,786. 2010 2009 2008 $13,188,942 1 $12,190,219 1 $11,245,973 Utility Taxes The City of Tukwila imposes a utility tax on electrical energy, natural gas, solid waste, ca- ble television service and telephone service at a rate of 6 %. The solid waste tax went into effect October 1, 2009. Additionally, a tax is levied on City -owned water, sewer and surface water utilities. The rate was 15% through April 30, 201 and 10% thereafter. This tax became effective December 31, 2008. Both the customer based utility tax revenue and the interfund utility tax revenue exceeded budget in 2010 by $157,953 and $2,197 respectively, generating $160,150 of revenue in excess of budget. The increase is due primarily to taxes generated from electricity and solid waste. The variance over budget for the interfund utility tax is due primarily to the taxes gener- ated from the surface water utility. Utility 2010 2009 2008 Electricity 1,504,325 1,639,591 1,424,675 Natural Gas 533,811 748,772 643,037 Solid Waste 339,654 79,932 - Cable 229,841 238,586 221,033 Telephone 1,456,322 1,652,412 1,645,465 Sub -total 4,063,953 4,359,292 3,934,210 Interfund - Water 501,592 676,241 - Interfund - Sewer 480,511 754,017 - Interfund - Storm 378,094 383,019 - Sub -total 1,360,197 1,813,277 _ TOTAL $ 5,424,150 $ 6,172,569 $ 3,934,210 Excise Taxes Leasehold excise tax is charged in lieu of a property tax and is collectible on most leases of publicly -owned real and personal property in the state. The leasehold tax rate is 12.84% of the rent paid for the property and payment of the tax is the responsibility of the lessee. The City remits the tax to the State, then receives back approximately 30.5% of the tax collected. The majority of the excise tax is earned by the general fund. Leasehold tax revenue for 2010 exceeded budget by 25% contributing an additional $25,000 to general fund revenues. Real estate excise tax (REET) is levied on all sales of real estate. The City credits the first quarter percent of the REET to the 301 Park Acquisition Fund and the second quarter percent to the 104 Arterial Street Fund. REET revenue earned in 2010 represents only 37.8% of budget. In 2010, 97% of the gambling excise tax revenue was derived from card games with the remainder generated by punchboards, pull tabs and amusement games. 2010 revenue represents 94% of budget. The excise tax charged on card games is 10% of gross proceeds; the ex- cise tax charged on most other forms of gambling is 5% of gross proceeds. Excise Tax 2010 2009 2008 Leasehold Excise Tax 129,746 112,212 155,203 Real Estate Excise Tax (REET) 378,052 254,986 827,857 Gambling Excise Tax 1,980,559 2,457,208 2,020,378 TOTAL $ 2,488,357 $ 2,824,407 $ 3,003,438 Page4 2010 FOURTH QUARTER FINANCIAL REPORT 4 Permit Income The General Fund receives 100% of permit revenue. For 2010, permit revenue is at 66.38% of budget, but exceeds 2009 revenue by almost $500,000 or 78 %. The largest in- creases occurred with the building/ structures permits which increased by $306,729 or 98% and with the mechanical permits with increased $54,281 or 95 %. The two largest projects requiring building permits were the Bow Lake Transfer Station valued at $9,545,690, Boeing Plant 2 demoli- tion valued at $8,500,000. The two largest projects requiring mechani- cal permits were the Internap Net- work project valued at $3,175,000 and the Sabey Data Center val- ued at $1,590,000. The two largest projects requiring electri- cal permits were the Internap Network valued at $2,775,193 and Intergate East Campus val- ued at $1,200,000. Permits Issued 2010 2009 Building 306 257 Mechanical 177 158 Electrical 1,040 819 Plumbing / gas 172 145 TOTAL 1,695 1,379 Permit Revenue 2010 2009 2008 Buildings / Structures 619,262 312,533 837,319 Electrical 300,084 200,939 492,495 Mechanical 111,368 57,087 155,781 Plumbing / gas / other 37,700 28,764 56,102 TOTAL $ 1,068,414 $ 599,322 $ 1,541,697 Plan Check & Other Fees Plan check and other fees recorded into the General Fund in 2010 to- taled $718,860 an increase of $316,172 over 2009 or a 79% in- crease. However, these fees consti- tuted only 66.38% of the 2010 $1,083,000 budget. The fire impact fees and park im- pact fees became effective in 2009. Plan Check & Other Fees 2010 2009 2008 Plan checking fees 582,422 331,007 725,674 Fire impact fees 142,383 13,342 - Park impact fees 108,177 17,767 - Zoning and subdivision 95,321 42,740 70,290 Electrical plan review 35,505 12,616 73,053 Other 5,612 15,825 65,787 TOTAL $ 969,420 $ 433,298 $ 934,804 Intergovernmental Revenue Intergovernmental revenue com- prises grant funds from federal, state and local governmental enti- ties and other governmental re- ceipts. The majority of the 2010 intergov- ernmental revenue was received by the 104 Arterial Street Fund and totaled $8,703,958 with $3.9 mil- lion received for the for the South - center Parkway project from the State Community Economic Revi- talization Board (CERB) and $3.6 million received from State grants for the Tukwila International Boulevard project phases II and III. The General Fund received $2 mil- lion from the Seattle City Light agreement. 2010 2009 2008 $12,915,585 $15,614,600 $5,066,669 Page 5 2010 FOURTH QUARTER FINANCIAL REPORT 5 6 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.. General Gov.. Fire Impact Fee Fund Water Fund Sewer Fund Foster Golf Fund Surface Water Fund Equipment.. Self- Insurance Fund LEOFF Insurance Fund Fund Balances ** As of December 31, 2010 $850,106 $607,646 1 $5,613,939 $889,470 $744,890 $316,024 $3,050 $2,058,647 $1,553,018 $156,018 $4,773,512 1 $3,321 1 $1,586,749 ,984 $4,553,247 $5,928,552 $11,110,343 $5,000,000 $10,000,000 $15,000,000 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 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 ENTERPRISE FUNDS Equipment Replacement Fund Self- Insurance Fund LEOFF Insurance Fund INTERNAL SERVICE FUNDS TOTAL 23,736,183 6,116,633 1,793,638 3,631 2,128,642 10,042,545 3,316,351 3,381,691 1,251,360 7,949,402 $ 41,728,130 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 3,604,040 4,295,161 1,428,020 9,327,222 42,469,517 Actual 09/30/2010 $ 3,895,243 813,353 535,009 11,327,922 888,170 642,654 381,805 1,130,074 5,012,250 2,065,937 2,047,319 155,929 28,895,666 6,144,940 1,897,479 273,622 2,932,010 11,248,051 3,569,563 4,512,642 1,472,764 9,554,969 $ 49,698,685 Actual 12/31/2010 $ 5,613,939 850,106 607,646 11,110, 343 889,470 744,890 316,024 3,050 4,773,512 2,058,647 1,553,018 156,018 28,676,663 5,928,552 2,658,708 168,463 2,290,807 11,046,529 3,321,984 4,553,247 1,586,749 9,461,981 $ 49,185,173 ** Unrestricted /unreserved fund balances 1 7 City of Tukwila General Fund 000 - Revenue and Expenditures As of December 31, 2010 % of year expired 100.00% 2006 2007 Actual Actual 2008 Actual Actual 2009 Three Year Change 2010 Adjusted Budget Actual (Year -To -Date) % of Variance Budget 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 Human Resources Finance Legal Recreation Community Development Court Police Fire Information Technology Public Works Parks Maintenance PW Street Maintenance Non - Departmental (Dept. 20) Total Expenses Change in Fund Balance Beginning Fund Balance $ 10,886,069 13,292,003 264,040 2,930,332 1,874,746 2,892 29,250,082 443,203 830,025 1,273,228 $ 11,042,843 14,670,616 253,272 3,666,079 2,024,646 3,051 31,660,507 454,472 1,373,236 1,827,708 2,962,522 2,562,870 80,102 364,440 10,000 200,403 931,869 759,117 2,345,931 221,097 445,781 329,752 1,088 5,730 61,987 844,338 64,558 247,709 23,975 125,703 827,379 735,568 2,024,892 266,188 488,252 324,686 4,751 25,599 431,503 1,274,791 $ 11,115,973 12,903,174 327,911 3,934,210 2,173,767 1,826 30,456,861 481,154 1,541,697 2,022,851 $ 12,190,219 12,903,214 582,756 4,359,292 1,813,277 2,567,119 628 34,416,505 684,141 599,322 1,283,463 10.39% - 12.05% 130.09% 18.91% 0.00% 26.79% -79.41% 8.70% 50.54% - 56.36% - 29.78% $ 13,081,000 15,333,917 279,000 3,906,000 1,358,000 2,204,000 2,000 36,163,917 521,000 1,895,000 2,416,000 $ 13,188,942 11,534,066 583,213 4,063,953 1,360,197 2,109,827 81 32,840,278 550,416 1,068,414 1,618,830 2,587,088 4,344,251 69.51% 2,996,072 3,236,742 61,616 805,610 1,200 68,793 934,804 697,358 2,569,381 259,991 328,698 351,661 1,776 108,013 216,071 1,006,219 72,547 12.38% 68,000 333,729 34.73% 304,000 10,000 (24,312) - 119.34% 150,000 402,188 - 51.39% 1,083,000 628,418 - 14.57% 703,000 1,412,571 - 30.24% 2,318,000 230,273 - 13.49% 118,713 374,680 643 2,739 109,699 606,475 - 75.69% 15.40% - 86.47% - 89.30% - 74.58% - 52.43% 241,000 505,000 346,000 1,000 21,000 122,000 995,000 64,447 458,008 6,200 166,950 718,860 701,216 2,115,681 227,552 67,650 385,055 11,666 7,174 149,982 621,526 $ 107,942 100.83% (3,799,851) 75.22% 304,213 209.04% 157,953 104.04% 2,197 100.16% (94,173) 95.73% (1,919) 4.07% (3,323,639) 90.81% 29,416 (826,586) (797,170) 105.65% 56.38% 67.00% 240,670 108.03% (3,553) 154,008 (3,800) 16,950 (364,140) (1,784) (202,319) 94.78% 150.66% 62.00% 111.30% 66.38% 99.75% 91.27% (13,448) 94.42% (437,350) 39,055 10,666 (13,826) 27,982 (373,474) 13.40% 111.29% 1166.60% 34.16% 122.94% 62.46% (530,869) 100 53,592 989,608 5,000 308 (4,692) 6.16% 1,993,581 2,130,752 2,215,982 3,156,300 48.13% 2,462,000 2,461,806 (194) 99.99% 38,359,910 41,747,808 41,171,965 46,439,446 11.24% 47,596,989 43,122,724 (4,474,265) 90.60% 260,080 234,769 261,235 251,563 1,851,301 2,037,794 2,140,561 2,492,492 357,146 475,813 506,660 506,060 1,625,499 1,602,167 1,932,285 1,963,333 757,310 603,378 728,980 685,691 2,799,025 2,956,021 3,158,534 3,350,801 2,325,684 2,423,936 3,066,717 2,779,459 908,696 999,584 1,136,752 1,181,132 11, 230, 938 11, 764, 214 12, 699, 005 12, 994, 938 9,293,758 9,457,701 10,152,352 9,874,049 530,787 586,036 676,421 951,073 3,125,054 3,304,857 3,608,739 5,756,107 903,162 894,145 965,020 979,084 2,121,394 2,240,234 2,573,891 2,280,106 529,405 356,226 376,896 709,444 38,619,239 39,936,875 43,984,048 46,755,331 (259,329) 1,810,933 (2,812,083) (315,885) 8,965,794 8,706,465 10,517,398 7,705,315 7.15% 22.31% 6.36% 22.54% 13.64% 13.36% 14.67% 18.16% 10.46% 4.40% 62.29% 74.17% 9.50% 1.78% 99.16% 17.07% 282,970 242,851 2,604,765 2,228,656 571,640 464,095 2,136,309 2,183,069 595,856 578,908 3,503,353 3,130,852 3,050,767 2,635,296 1,166,680 1,208,632 14,025,328 13,165,552 10,297,773 9,920,730 1,086,270 953,361 4,937,576 4,572,757 999,621 992,222 2,570,563 2,368,562 305,000 252,671 48,134,471 44,898,215 (537,482) (1,775,492) 8,709,916 7,389,431 (40,119) (376,109) (107,545) 46,760 (16,948) (372,501) (415,471) 41,952 (859,776) (377,043) (132,909) (364,819) (7,399) (202,001) (52,329) (3,236,256) (1,238,010) (1,320,485) 85.82% 85.56% 81.19% 102.19% 97.16% 89.37% 86.38% 103.60% 93.87% 96.34% 87.76% 92.61% 99.26% 92.14% 82.84% 93.28% 330.34% 84.84% Ending Fund Balance $ 8,706,465 $ 10,517,398 $ 7,705,315 $ 7,389,430 - 29.74% $ 8,172,434 $ 5,613,939 $ (2,558,495) 68.69% Fund 000 Multi -Year 2 8 City of Tukwila General Fund 000 - Revenue and Expenditures As of December 31, 2010 2010 Adjusted Annual Budget Budget (Year -To -Date) Actual (Year -To -Date) Variance Variance as % of Budget (Year -To- Date) Revenue General Revenue Property Taxes Sales and Use 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 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 $ 13,081,000 15, 333, 917 279,000 3,906,000 1,358,000 2,204,000 2,000 36,163,917 521,000 1,895,000 2,416,000 2,996,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 $ 13,081,000 15,333,917 279,000 3,906,000 1,358,000 2,204,000 2,000 36,163,917 521,000 1,895,000 2,416,000 2,996,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 $ 13,188,942 11, 534, 066 583,213 4,063,953 1,360,197 2,109, 827 81 32,840,278 550,416 1,068,414 1,618,830 3,236,742 64,447 458,008 6,200 166,950 718,860 701,216 2,115, 681 227,552 67,650 385,055 11,666 7,174 149,982 621,526 308 2,461,806 $ 107,942 (3,799,851) 47,596,989 47,596,989 43,122,724 0.83% - 24.78% 0.00% 304,213 109.04% 157,953 4.04% 2,197 0.16% (94,173) - 4.27% (1,919) - 95.93% (3,323,639) - 9.19% 29,416 (826,586) (797,170) 240,670 (3,553) 154,008 (3,800) 16,950 (364,140) ( 1,784) (202,319) (13,448) (437,350) 39,055 10,666 (13,826) 27,982 (373,474) (4,692) (194) (4,474,265) 5.65% 0.00% - 43.62% - 33.00% 8.03% -5.22% 50.66% - 38.00% 11.30% - 33.62% -0.25% -8.73% - 5.58% - 86.60% 11.29% 1066.60% - 65.84% 22.94% - 37.54% - 93.84% -0.01% -9.40% Fund 000 3 9 City of Tukwila General Fund 000 - Revenue and Expenditures As of December 31, 2010 1- 2010 Adjusted Budget Actual Annual Budget (Year -To -Date) (Year -To -Date) Variance Variance as % of Budget (Year -To- Date) 10 Expenditures City Council Mayor's Office Human Resources Finance Legal Parks & Rec Community Development Court Police Fire Information Technology Public Works Parks Maintenance PW Street Maintenance Non - Departmental (Dept. 20) Total Expenses Change in Fund Balance Beginning Fund Balance 282,970 2,604,765 571,640 2,136,309 595,856 3,503,353 3,050,767 1,166, 680 14, 025, 328 10,297,773 1,086,270 4,937,576 999,621 2,570,563 305,000 48,134,471 (537,482) 8,709,916 282,970 242,851 (40,119) - 14.18% 2,604,765 2,228,656 (376,109) - 14.44% 571,640 464,095 (107,545) - 18.81% 2,1 36,309 2,183,069 46,760 2.19% 595,856 578,908 (16,948) -2.84% 3,503,353 3,130,852 (372,501) - 10.63% 3,050,767 2,635,296 (415,471) - 13.62% 1,166,680 1,208,632 41,952 3.60% 14,025,328 13,165,552 (859,776) -6.13% 10,297,773 9,920,730 (377,043) - 3.66% 1,086,270 953,361 (132,909) - 12.24% 4,937,576 4,572,757 (364,819) - 7.39% 999,621 992,222 (7,399) - 0.74% 2,570,563 2,368,562 (202,001) - 7.86% 305,000 252,671 (52,329) - 17.16% 48,134,471 44,898,215 (3,236,256) -6.72% (537,482) (1,775,492) (1,238,010) 230.34% 8,709,916 7,389,431 (1,320,485) - 15.16% Ending Fund Balance $ 8,172,434 $ 8,172,434 $ 5,613,939 $ (2,558,495) - 31.31% Fund 000 4 CITY OF TUKWILA Expenditures through December 31, 2010 % of year expired 100.00% TOTALS - ALL DEPARTMENTS Annual Budget Actual Spent Remaining Budget % Spent CITY COUNCIL MAYOR HUMAN RESOURCES FINANCE CITY ATTORNEY RECREATION COMMUNITY DEVELOPMENT MUNICIPAL COURT POLICE FIRE INFORMATION TECHNOLOGY PUBLIC WORKS PARK MAINTENANCE STREET MAINTENANCE & OPERATION DEPT 20 - CONTRIBUTIONS / FUND BALANCE TOTAL BY DEPARTMENT $ 282,970 2,604,765 571,640 2,136, 309 595,856 3,503,353 3,050,767 1,166,680 14, 025, 328 10,297,773 1,086,270 4,937,576 999,621 2,570,563 305,000 $ 48,134,471 $ 242,851 2,228,656 464,095 2,183,069 578,908 3,130,852 2,635,296 1,208,632 13,165,552 9,920,730 953,361 4,572,757 992,222 2,368,562 252,671 $ 44,898,215 $ 40,119 376,109 107,545 (46,760) 16,948 372,501 415,471 (41,952) 859,776 377,043 132,909 364,819 7,399 202,001 52,329 $ 3,236,256 85.82% 85.56% 81.19% 102.19% 97.16% 89.37% 86.38% 103.60% 93.87% 96.34% 87.76% 92.61% 99.26% 92.14% 82.84% 93.28% 01 - CITY COUNCIL Annual Budget Actual Spent Remaining Budget % Spent 00 UNALLOCATED BUDGET REDUCTION 11 SALARIES 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 49 MISCELLANEOUS CITY COUNCIL (8,951) 172,137 13,168 9,140 2,510 39,066 3,500 3,000 4,400 30,000 15,000 282,970 171,396 12,796 4,418 2,225 36,041 1,546 3,263 4,032 6,060 1,073 242,851 (8,951) 741 372 4,722 285 3,025 1,954 -263 368 23,940 13,927 40,119 0.00% 99.57% 97.18% 48.33% 88.66% 92.26% 44.18% 108.78% 91.64% 20.20% 7.15% 85.82% 03 - MAYOR Annual Budget Actual Spent Remaining Budget % Spent 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 44 ADVERTISING 45 OPERATING RENTALS & LEASES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 51 INTERGVRNMTL PROFESSIONAL SVCS 53 EXT TAXES & OPERATING ASSMNTS 64 MACHINERY & EQUIPMENT (71,810) 1,081,317 28,500 573 84,936 60,812 3,059 233,643 31,325 685,950 86,000 23,000 21,300 30,607 22,850 238,203 26,500 18,000 2,604,765 956,516 1,340 70,169 50,862 3,286 205,235 9,075 17,500 640,120 65,733 6,895 11,882 26,939 7,983 134,995 20,125 4 2,228,656 (71,810) 124,801 28,500 (767) 14,767 9,950 (227) 28,408 (9,075) 13,825 45,830 20,267 16,105 9,418 3,668 14,867 103,208 6,375 (4) 18,000 376,109 0.00% 88.46% 0.00% 233.87% 82.61% 83.64% 107.41% 87.84% 0.00% 55.87% 93.32% 76.43% 29.98% 55.78% 88.02% 34.93% 56.67% 75.94% 0.00% 0.00% 85.56% 11 04 - HUMAN RESOURCES Annual Budget Remaining Actual Spent Budget % Spent 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 HUMAN RESOURCES (18,153) 355,006 3,500 27,426 19,037 993 54,711 8,470 82,000 2,000 4,000 20,000 50 4,600 8,000 571,640 309,847 23,012 16,454 1,034 65,498 3,342 29,004 2,000 284 6,886 39 2,855 3,840 464,095 (18,153) 45,159 3,500 4,414 2,583 -41 - 10,787 5,128 52,996 0 3,716 13,114 11 1,745 4,160 107,545 0.00% 87.28% 0.00% 83.91% 86.43% 104.13% 119.72% 39.46% 35.37% 100.00% 7.09% 34.43% 78.44% 62.06% 48.00% 81.19% 05 - FINANCE Annual Budget Remaining Actual Spent Budget Spent 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 FINANCE (55,100) 932,682 10,000 1,147 71,898 47,680 3,150 240,352 20,000 85,000 113,000 1,000 5,000 277,500 5,000 333,000 45,000 2,136, 309 944,607 6,402 70,673 50,368 3,448 252,850 48,387 91,253 735 2,957 189,136 2,421 496,646 23,186 2,183,069 (55,100) (11,925) 10,000 (5,255) 1,225 (2,688) (298) (12,498) 20,000 36,613 21,747 265 2,043 88,364 2,579 (163,646) 21,814 (46,760) 0.00% 101.28% 0.00% 558.15% 98.30% 105.64% 109.47% 105.20% 0.00% 56.93% 80.75% 73.49% 59.13% 68.16% 48.42% 149.14% 51.53% 102.19% 06 - CITY ATTORNEY Annual Budget Remaining Actual Spent Budget % Spent 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 ATTORNEY 12 (14,872) 2,500 192 36 5,000 597,000 2,500 500 2,000 1,000 595,856 5 1,265 573,337 2,033 516 1,752 578,908 (14,872) 2,500 192 31 3,735 23,663 467 500 1,484 (752) 16,948 0.00% 0.00% 0.00% 13.92% 25.30% 96.04% 81.32% 0.00% 25.80% 175.19% 97.16% 07 - RECREATION Annual Budget Remaining Actual Spent Budget % Spent 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 34 ITEMS PURCH. FOR INVENT /RESALE 35 SMALL TOOLS & MINOR EQUIPMENT 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 RECREATION (63,112) 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 61,015 100,000 30,400 255,740 1,352,826 407,730 3,049 132,300 80,246 40,777 372,352 9,433 96,481 32,838 263 156,966 25,883 1,972 9,401 37,841 119,972 43,861 206,411 251 (63,112) 133,352 76,471 8,206 17,228 24,027 10,875 43,580 (9,433) 20,069 (13,838) (263) 66,219 6,724 7,078 6,499 23,174 (19,972) (13,461) 49,329 (251) 0.00% 91.03% 84.21% 27.09% 88.48% 76.96% 78.95% 89.52% 0.00% 82.78% 172.83% 0.00% 70.33% 79.38% 21.79% 59.12% 62.02% 119.97% 144.28% 80.71% 0.00% 0.00% 89.37% 3,503,353 3,130,852 372,501 08 - COMMUNITY DEVELOPMENT Annual Budget Remaining Actual Spent Budget % Spent 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 44 RECYCLING - KC WRR 45 OPERATING RENTALS & LEASES 47 PUBLIC UTILITY SERVICES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 51 INTERGVRNMTL PROFESSIONAL SVCS COMMUNITY DEVELOPMENT (77,210) 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 255,065 18,000 3,050,767 1,808,172 34,010 3,813 138,240 96,819 8,232 324,058 82 20,107 636 77,836 2,994 1,505 536 10,755 492 43,025 40,685 23,298 2,635,296 (77,210) 17,230 13,890 11,333 6,227 3,632 9,209 39,589 1,723 13,777 -36 184,174 1,506 10,495 -536 4,854 508 - 33,975 214,380 -5,298 415,471 0.00% 99.06% 71.00% 25.17% 95.69% 96.38% 47.20% 89.11% 4.55% 59.34% 105.95% 29.71% 66.52% 12.54% 0.00% 68.91% 49.21% 475.42% 15.95% 129.43% 86.38% 13 09 - MUNICIPAL COURT Annual Budget Actual Spent Remaining Budget % Spent 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 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 45 OPERATING RENTALS & LEASES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 53 EXT TAXES & OPERATING ASSMNTS MUNICIPAL COURT (18,363) 620,582 4,500 5,737 48,257 33,496 2,362 119,394 9,000 299,000 5,550 7,815 5,000 3,000 21,350 1,166,680 649,410 48,182 34,269 2,601 131,147 10,750 304,896 7,761 2,102 948 2,232 14,334 1 1,208,632 (18,363) (28,828) 4,500 5,737 75 (773) (239) (11,753) (1,750) (5,896) (2,211) 5,713 4,052 768 7,016 (1) - 41,952 0.00% 104.65% 0.00% 0.00% 99.84% 102.31% 110.11% 109.84% 119.44% 101.97% 139.83% 26.90% 18.96% 74.40% 67.14% 0.00% 103.60% 10 - POLICE Annual Budget Actual Spent Remaining Budget % Spent 00 UNALLOCATED BUDGET REDUCTION 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 22 LEOFF 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 26 UNEMPLOYMENT COMPENSATION 31 OFFICE & OPERATING SUPPLIES 35 SMALL TOOLS & MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS & LEASES 46 INSURANCE 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 51 INTERGVRNMTL PROFESSIONAL SVCS 64 MACHINERY & EQUIPMENT POLICE 14 (147,915) 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 676,177 225,080 170,490 67,245 1,709,900 11,821 14,025,328 6,579,954 861,995 555,846 333,553 49,027 103,623 1,721,143 6,722 98,698 1 86,203 60,447 10,750 409 483,140 173,340 147,437 36,573 1,856,690 13,165, 552 (147,915) 450,178 5,000 141,817 36,428 12,753 11,430 (14,589) 143,383 (6,722) 68,086 12,999 (30,028) 484 12,550 391 193,037 51,740 23,053 30,672 (146,790) 11,821 859,776 0.00% 93.60% 0.00% 85.87% 93.85% 96.32% 81.09% 116.39% 92.31% 0.00% 59.18% 0.01% 153.45% 99.21% 46.14% 51.14% 71.45% 77.01% 86.48% 54.39% 108.58% 0.00% 93.87% 11 - FIRE Annual Budget Remaining Actual Spent Budget % Spent 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 26 UNEMPLOYMENT COMPENSATION 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 FIRE (270,824) 102,960 6,118,135 530,075 178,248 105,096 334,053 7,574 85,117 1,773,109 1,140 152,150 17,000 55,300 30,000 9,500 472,307 90,000 60,000 35,500 72,583 326,000 12,750 10,297,773 97,380 5,944,210 406,471 180,104 86,124 306,938 11,124 117,876 1,671,173 7,766 153,705 9,304 30,530 25,264 3,062 356,005 69,336 60,977 37,466 63,037 282,879 9,920,730 (270,824) 5,580 173,925 123,604 -1,856 18,972 27,115 -3,550 - 32,759 101,936 (7,766) 1,140 -1,555 7,696 24,770 4,736 6,438 116,302 20,664 -977 -1,966 9,546 43,121 12,750 377,043 0.00% 94.58% 97.16% 76.68% 101.04% 81.95% 91.88% 146.87% 138.49% 94.25% 0.00% 0.00% 101.02% 54.73% 55.21% 84.21 % 32.23% 75.38% 77.04% 101.63% 105.54% 86.85% 86.77% 0.00% 96.34% 12 - INFORMATION TECHNOLOGY Annual Budget Remaining Actual Spent Budget % Spent 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 (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 518,912 39,312 27,550 1,988 149,210 937 83,531 52,635 886 1,739 6,183 30,982 39,496 953,361 (34,356) (1,166) 2,500 486 1,236 (52) (5,250) 5,263 (83,531) 2,000 22,065 614 (1,739) 1,317 22,018 201,504 132,909 0.00% 100.23% 0.00% 0.00% 98.78% 95.71% 102.67% 103.65% 15.11% 0.00% 0.00% 70.46% 59.04% 0.00% 82.44% 58.46% 16.39% 87.76% 15 13 - PUBLIC WORKS Annual Budget Remaining Actual Spent Budget % Spent 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 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 53 EXT TAXES & OPERATING ASSMNTS 64 MACHINERY & EQUIPMENT PUBLIC WORKS (7,255) 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 83,125 379,449 204,521 69,335 20,000 4,937,576 1,666,858 6,541 124,657 88,496 18,345 409,237 6,433 1,303 88,653 189,878 1,135,350 48,578 7,352 116,315 303,142 225,573 24,779 80 111,186 4,572,757 (7,255) 466,424 3,500 (1,985) 39,154 25,209 32 142,973 (6,433) 2,497 33,807 (121,128) (176,450) (9,328) (1,552) (33,190) 76,307 (21,052) 44,556 (80) (91,186) 364,819 0.00% 78.14% 0.00% 143.57% 76.10% 77.83% 99.83% 74.11% 0.00% 34.29% 72.39% 276.19% 118.40% 123.77% 126.76% 139.93% 79.89% 110.29% 35.74% 0.00% 555.93% 92.61% 15 - PARK MAINTENANCE Remaining Annual Budget Actual Spent Budget % Spent 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 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 PARK MAINTENANCE 16 (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 54,843 165,000 52,000 4,000 10,000 2,500 999,621 484,487 7,169 1,205 36,865 25,804 11,844 98,532 3,770 1,332 37,245 2,621 25,543 44 69,358 143,113 40,947 2,341 992,222 (31,583) (28,331) 27,851 1,090 885 399 1,456 180 (3,770) 93 8,755 (121) (3,543) 956 500 (14,515) 21,887 11,053 1,659 10,000 2,500 7,399 0.00% 106.21% 20.47% 52.52% 97.66% 98.48% 89.05% 99.82% 0.00% 93.48% 80.97% 104.83% 116.11% 4.44% 0.00% 126.47% 86.73% 78.74% 58.54% 0.00% 0.00% 99.26% 16 - STREET MAINTENANCE & OPERATION Annual Budget Remaining Actual Spent Budget % Spent 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 28 UNIFORM CLOTHING 31 OFFICE & OPERATING SUPPLIES 35 SMALL TOOLS & MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS & LEASES 46 INSURANCE 47 PUBLIC UTILITY SERVICES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 53 EXT TAXES & OPERATING ASSMNTS 64 MACHINERY & EQUIPMENT STREET MAINTENANCE & OPERATION 771,888 43,723 11,474 63,345 43,721 20,639 225,190 2,375 368,800 10,931 4,000 4,300 2,700 1,500 246,292 35,455 661,930 27,100 5,200 20,000 2,570,563 665,796 24,706 9,575 53,098 36,220 17,610 199,434 2,693 1,829 309,083 36,950 29,627 4,189 581 698 189,327 27,315 675,538 20,144 2,082 9 62,060 2,368,562 106,092 19,018 1,899 10,247 7,501 3,029 25,756 (2,693) 546 59,717 (26,019) (25,627) 111 2,119 802 56,965 8,140 (13,608) 6,956 3,118 (9) (42,060) 202,001 0.00% 86.26% 56.50% 83.45% 83.82% 82.84% 85.32% 88.56% 0.00% 77.01% 83.81% 338.03% 740.67% 97.42% 21.50% 46.56% 76.87% 77.04% 102.06% 74.33% 40.04% 0.00% 310.30% 92.14% 20 - CONTRIBUTIONS / FUND BALANCE Annual Budget Remaining Actual Spent Budget % Spent 01 ESTIMATED UNSPENT APPROPRIATION 25 MEDICAL,DENTAL,LIFE,OPTICAL 26 UNEMPLOYMENT COMPENSATION 41 PROFESSIONAL SERVICES 47 PUBLIC UTILITY SERVICES 49 MISCELLANEOUS 66 CAPITAL LEASES CONTRIBUTIONS / FUND BALANCE 8,477,434 158,095 8,477,434 94,576 252,671 8,319,339 (94,576) 8,224,763 1.86% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2.98% 17 Grand Totals Annual Budget Actual Spent Remaining Budget % Spent 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 66 CAPITAL LEASES Grand Totals 18 7,760,890 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,363,520 347,738 134,665 60,000 1,645,525 628,035 1,367,379 574,011 1,398,721 2,080,400 10,000 371,071 56,306,905 255,475 22,052,991 473,615 1,300,392 180,104 1,391,276 640,492 571,656 332,893 5,635,910 45,893 4,546 887,700 32,838 323,184 3,183,928 302,284 44,449 29,812 1,292,407 459,127 1,303,233 580,642 1,059,530 2,182,991 345 235,928 94,576 44,898,215 7,505,415 1,447,652 197,229 285,678 (1,856) 150,671 39,867 83,678 (23,287) 488,542 (25,893) 5,999 267,423 (13,838) (210,403) 179,592 45,454 90,216 30,188 353,118 168,908 64,146 (6,631) 339,191 (102,591) (345) 10,000 135,143 (94,576) 11,408,690 3.29% 93.84% 70.60% 81.99% 101.04% 90.23% 94.14% 87.23% 107.52% 92.02% 229.46% 43.11% 76.85% 172.83% 286.56% 94.66% 86.93% 33.01% 49.69% 78.54% 73.11% 95.31% 101.16% 75.75% 104.93% 0.00% 0.00% 63.58% 0.00% 79.74% City of Tukwila Hotel /Motel Tax Fund 101 - Revenue and Expenditures As of December 31, 2010 % of year expired 100.00% 2010 Adjusted Budget Actual (Year -To- Date) % of Variance Budget Revenue General Revenue Hotel /Motel Taxes Total General Revenue $ 600,000 600,000 Intergovernmental Revenue 662,000 Miscellaneous Revenue Investment Earnings Other Misc Revenue Total Miscellaneous Revenue Total Revenue 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 66 Capital Leases Total Expenses Change in Fund Balance Beginning Fund Balance 20,000 5,000 25,000 1,287,000 $ 458,092 $ (141,908) 76.35% 458,092 (141,908) 765,016 4,436 24,719 29,155 1,252,263 263,469 259,202 24,000 15,229 10,110 21,708 22,856 22,338 - 716 23,808 14,980 1,283 1,575 49,834 45,694 16,000 29,307 201,000 233,197 45,000 61,508 23,000 6,528 630,000 544,877 49,000 30,913 1,500 708 1,000 360 21,000 13,976 10,000 10,661 - 8,403 1,392,860 1,321,879 (105,860) 632,964 76.35% 103,016 115.56% (15,564) 22.18% 19,719 494.38% 4,155 116.62% (34,737) 97.30% (4,267) 98.38% (8,771) 63.45% 11,598 214.72% (518) 97.73% 716 0.00% (8,828) 62.92% 292 122.76% (4,140) 91.69% 13,307 183.17% 32,197 116.02% 16,508 136.68% (16,472) 28.38% (85,123) 86.49% (18,087) 63.09% (792) 47.21% (640) 36.05% (7,024) 66.55% 661 106.61% 8,403 0.00% (70,981) 94.90% (69,616) 36,244 919,722 286,758 65.76% 145.30% Ending Fund Balance $ 527,104 $ 850,106 $ 323,002 161.28% Fund 101 19 City of Tukwila Street Fund 103 - Revenue and Expenditures As of December 31, 2010 % of year expired 100.00% 2010 Adjusted Actual % of Budget (Year -To -Date) Variance Budget Revenue Intergovernmental Revenue (MVFT Taxes) $ 300,000 $ 267,704 $ (32,296) 89.23% Miscellaneous Revenue Investment Earnings 10,000 5,148 (4,852) 51.48% Total Miscellaneous Revenue 10,000 5,148 (4,852) 51.48% Total Revenue 310,000 272,853 (37,147) 88.02% Expenditures 41 Professional Services 400,000 - (400,000) 0.00% 64 Capital Outlay - 300,000 300,000 0.00% Total Expenses 400,000 300,000 (100,000) 75.00% Change in Fund Balance (90,000) (27,147) 62,853 30.16% Beginning Fund Balance 317,000 634,793 317,793 200.25% Ending Fund Balance $ 227,000 $ 607,646 $ 380,646 267.69% Fund 103 20 City of Tukwila Arterial Street Fund 104 - Revenue and Expenditures As of December 31, 2010 % of year expired 100.00% 2010 Adjusted Budget Actual (Year -To -Date) Variance % of Budget 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 Total Revenue $ 2,900,000 140,000 500,000 3,540,000 29,670,000 300,000 3,138,000 3,438,000 24,513,930 $ 2,106,056 $ (793,944) 72.62% 143,939 3,939 102.81% 189,026 (310,974) 37.81% 2,439,021 (1,100,979) 68.90% 8,703,959 (20,966,041) 29.34% 10,357 (289,643) 3.45% 404,160 (2,733,840) 12.88% 422,047 (3,015,953) 12.28% 27,000 27,000 0.00% 4,387,967 (20,125,963) 17.90% 61,161,930 15,979,993 (45,181,937) 26.13% Expenditures 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 44 Advertising 45 Operating Rentals & Leases 47 Public Utility Services 48 Repairs & Maintenance 49 Miscellaneous 64 Capital Outlay 81 Debt Service Interest and costs Total Arterial Streets 104 Transfers Out Total Expenses Change in Fund Balance Beginning Fund Balance 211,037 3,000 16,374 17,380 3,020 27,210 8,790,000 57,398,930 66,466,951 639,936 67,106,887 (5,944,957) 8,636,736 344,445 133,408 35 (2,965) 15,230 15,230 26,785 10,411 19,101 1,721 1,478 (1,542) 62,476 35,266 19,223 19,223 20,844 20,844 3,005,403 (5,784,597) 2,804 2,804 1,830 1,830 1,239 1,239 425 425 1,426 1,426 6,527,743 (50,871,187) 56,933 56,933 10,107,423 (56,359,528) 639,936 - 10,747,359 (56,359,528) 5,232,635 11,177,592 5,820,775 (2,815,961) 163.22% 1.17% 0.00% 163.58% 109.90% 48.94% 229.61% 0.00% 0% 34.19% 0.00% 0.00% 0.00% 0.00% 0.00% 11.37% 0.00% 15.21% 100.00% 16.02% - 88.02% 67.40% Ending Fund Balance $ 2,691,779 $ 11,053,410 $ 8,361,631 410.64% Fund 104 21 Adjusted Actual Budget (Year -To -Date) Variance % of Budget 2010 City of Tukwila Contingency Fund 105 - Revenue and Expenditures As of December 31, 2010 % of year expired 100.00% Revenue Miscellaneous Revenue Investment Earnings $ 18,000 $ 4,007 $ (13,993) 22.26% Total Miscellaneous Revenue 18,000 4,007 (13,993) 22.26% Total Revenue 18,000 4,007 (13,993) 22.26% Change in Fund Balance 18,000 4,007 (13,993) 22.26% Beginning Fund Balance 874,187 885,462 11,275 101.29% Ending Fund Balance $ 892,187 $ 889,470 $ (2,717) 99.70% Fund 105 22 City of Tukwila Fire Equipment Cum. Reserve 107 - Revenue and Expenditures As of December 31, 2010 % of year expired 100.00% 2010 Adjusted Actual % of Budget (Year -To -Date) Variance Budget Revenue Miscellaneous Revenue Investment Earnings $ 10,000 $ 2,282 $ (7,718) 22.82% Total Miscellaneous Revenue 10,000 2,416 (7,584) 24.16% Total Revenue 10,000 104,061 94,061 1040.61% Expenditures 31 Office & Operating Supplies 2,000 (2,000) 0.00% 64 Capital Outlay - 713 713 0.00% Total Expenses 2,000 713 (1,287) 35.64% Change in Fund Balance 8,000 Beginning Fund Balance 427,000 103,349 95,349 641,542 214,542 1291.86% 150.24% Ending Fund Balance $ 435,000 $ 744,890 $ 309,890 171.24% Fund 107 23 City of Tukwila Drug Seizure Fund 109 - Revenue and Expenditures As of December 31, 2010 % of year expired 100.00% 2010 Adjusted Actual % of Budget (Year -To -Date) Variance Budget Revenue Miscellaneous Revenue Investment Earnings $ - $ 2,373 $ 2,373 0.00% Seizure Revenue 200,000 160,027 (39,973) 80.01% Total Miscellaneous Revenue 200,000 162,400 (37,600) 81.20% Total Revenue 200,000 162,400 (37,600) 81.20% Expenditures 31 Office & Operating Supplies 20,000 41 Professional Services 4,500 42 Communication 500 43 Travel 10,000 45 Operating Rentals & Leases 23,000 48 Repairs & Maintenance 2,000 49 Miscellaneous 5,000 64 Capital Outlay 105,000 Total Expenses 170,000 Change in Fund Balance 30,000 Beginning Fund Balance 5,806 2,108 59,570 67,484 (14,194) 29.03% (2,392) 46.84% (500) 0.00% (10,000) 0.00% (23,000) 0.00% (2,000) 0.00% (5,000) 0.00% (45,430) 56.73% (102,516) 39.70% 94,916 64,916 221,108 221,108 316.39% 0.00% Ending Fund Balance $ 30,000 $ 316,024 $ 286,024 1053.41% Fund 109 24 City of Tukwila Debt Service Funds 2XX - Revenue and Expenditures As of December 31, 2010 % of year expired 100.00% 2010 Adjusted Actual % of Budget (Year -To -Date) Variance Budget Revenue General Revenue Sales and Use Taxes Total General Revenue $ 2,238,715 $ 2,174,141 $ (64,574) 97.12% 2,238,715 2,174,141 (64,574) 97.12% Miscellaneous Revenue Investment Earnings 44,000 1,441 (42,559) 3.28% Debt proceeds - 1,065,000 1,065,000 0.00% Total Miscellaneous Revenue 44,000 1,066,441 1,022,441 2423.73% Total Revenue 2,305,305 3,263,172 957,867 141.55% Expenditures 80 Debt Service Principal 1,509,028 2,620,028 1,111,000 173.62% 81 Debt Service Interest 832,223 775,531 (56,692) 93.19% Total Expenses 2,341,251 3,395,559 1,054,308 145.03% Change in Fund Balance (35,946) (132,388) (96,442) 368.30% Beginning Fund Balance 1,151,631 135,438 (1,016,193) 11.76% Ending Fund Balance $ 1,115,685 $ 3,050 $ (1,112,635) 0.27% Funds 2XX 25 City of Tukwila Open Space and Parks Acq. Fund 301 - Revenue and Expenditures As of December 31, 2010 % of year expired 100.00% 2010 Adjusted Budget Actual (Year -To -Date) Variance % of Budget 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 Total Revenue Expenditures 11 Salaries 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 31 Office & Operating Supplies 31 Office & Operating Supplies 41 Professional Services 42 Communication 44 Advertising 47 Public Utility Services 48 Repairs & Maintenance 64 Capital Outlay Total Park Acquisition Fund Transfers Out Total Expenses Change in Fund Balance Beginning Fund Balance $ - $ 210,000 500,000 710,000 1,615,000 127,000 127,000 2,452,000 ■ 404,000 ■ 15,000 1,724,000 2,143,000 60,446 2,203,446 248,554 3,994,879 151,641 189,300 340,941 108,177 108,177 37,828 5,422 43,250 492,368 8,959 665 476 25 1,668 1,193 14,652 64,396 13 735 4,108 4,217 225,648 326,755 60,446 387,201 105,167 4,668,345 $ (58,359) (310,700) (369,059) 108,177 108,177 (1,615,000) 0.00% 72.21% 37.86% 48.02% 0.00% 0.00% 0.00% (89,172) 29.79% 5,422 0.00% (83,750) 34.06% (1,959,632) 20.08% 8,959 665 476 25 1,668 1,193 14,652 (339,604) 13 735 4,108 (10,783) (1,498,352) (1,816,245) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 15.94% 0.00% 0.00% 0.00% 28.11% 13.09% 15.25% 0 100.00% (1,816,245) 17.57% (143,387) 673,466 42.31% 116.86% Ending Fund Balance $ 4,243,433 $ 4,773,512 $ 530,079 112.49% Fund 301 26 City of Tukwila Facility Replacement Fund 302 - Revenue and Expenditures As of December 31, 2010 of year expired 100.00% 2010 Adjusted Actual % of Budget (Year -To -Date) Variance Budget Revenue Charges for Services Sales and Use Taxes Total Charges for Services $ Intergovernmental Revenue 1,000,000 Miscellaneous Revenue Investment Earnings Facilities leases (long -term) Forfeitures Total Miscellaneous Revenue 100,000 100,000 Transfers In 130,000 $ 205 $ 205 0.00% 205 205 0.00% (1,000,000) 0.00% 6,505 (93,495) 6.50% 457 457 0.00% 2,500 2,500 0.00% 9,462 (90,538) 9.46% (130,000) 0.00% Total Revenue 1,230,000 9,667 (1,220,333) 0.79% Expenditures 11 Salaries - 6,352 6,352 0.00% 12 Extra Labor - 839 839 0.00% 21 FICA - 535 535 0.00% 23 PERS - 337 337 0.00% 24 Industrial Insurance - 204 204 0.00% 25 Medical, Dental, Life, Optical - 571 571 0.00% 31 Office & Operating Supplies - 103 103 0.00% 41 Professional Services 140,000 5,179 (134,822) 3.70% 47 Public Utility Services 8,535 8,535 0.00% 49 Miscellaneous 350 350 0.00% 64 Capital Outlay 1,000,000 (1,000,000) 0.00% Total Expenses 1,140,000 24,938 (1,115,062) 2.19% Change in Fund Balance Beginning Fund Balance 90,000 6,289,000 (15,271) 2,073,918 (105,271) (4,215,082) - 16.97% 32.98% Ending Fund Balance $ 6,379,000 $ 2,058,647 $ (4,320,353) 32.27% Fund 302 27 City of Tukwila General Government Improvements 303 - Revenue and Expenditures As of December 31, 2010 % of year expired 100.00% 2010 Adjusted Actual % of Budget (Year -To -Date) Variance Budget Revenue Charges for Services Sales and Use Taxes Total Charges for Services Intergovernmental Revenue Miscellaneous Revenue Investment Earnings Bond proceeds Total Miscellaneous Revenue $ 306,000 $ 220,171 $ (85,829) 71.95% 306,000 220,171 (85,829) 71.95% 20,000 85,633 65,633 428.16% Total Revenue 30,000 1,940 (28,060) 6.47% 1,582,545 1,594,184 11,639 100.74% 1,612,545 1,596,124 (16,421) 98.98% 0.00% 1,938,545 1,901,927 (36,618) 98.11% Expenditures 11 Salaries 91,703 44,729 (46,974) 48.78% 13 Overtime - 66 66 0.00% 21 FICA 7,016 3,409 (3,607) 48.58% 23 PERS 7,446 2,379 (5,067) 31.94% 24 Industrial Insurance 1,385 176 (1,209) 12.74% 25 Medical, Dental, Life, Optical 26,459 11,315 (15,144) 42.76% 41 Professional Services 60,000 15,869 (44,131) 26.45% 48 Repairs & Maintenance - 17,862 17,862 0.00% 49 Miscellaneous - 85,633 85,633 0.00% 64 Capital Outlay 1,905,316 409,444 (1,495,872) 21.49% 81 Debt Service Interest - 20,684 20,684 0.00% Total Fire Impact Fees 2,251,554 629,558 (1,621,996) 27.96% Transfers Out 65,000 65,000 - 100.00% Total Expenses 2,316,554 694,558 (1,621,996) 29.98% Change in Fund Balance (378,009) 1,207,369 1,585,378 - 319.40% Beginning Fund Balance 541,425 345,649 (195,776) 63.84% Ending Fund Balance $ 163,416 $ 1,553,018 $ 1,389,602 950.35% Fund 303 28 City of Tukwila Fire Impact Fees 304 - Revenue and Expenditures As of December 31, 2010 % of year expired 100.00% 2010 Adjusted Actual % of Budget (Year -To -Date) Variance Budget Revenue Charges for Services Fire Impact Fees Total Charges for Services Investment Earnings Total Miscellaneous Revenue $ $ 142,383 $ 142,383 0.00% 142,383 142,383 0.00% Total Revenue Expenditures 64 Capital Outlay Total Expenses 289 289 0.00% 289 289 0.00% 0.00% 142,672 142,672 0.00% 0.00% 0.00% Change in Fund Balance - 142,672 142,672 0.00% Beginning Fund Balance 13,346 13,346 0.00% Ending Fund Balance $ $ 156,018 $ 156,018 0.00% Fund 304 29 30 City of Tukwila Water Fund 401 - Revenue and Expenditures As of December 31, 2010 % of year expired 100.00% 2010 Adjusted Actual Budget (Year -To -Date) Variance % of Budget Revenue Charges for Services Water Sales Total Charges for Services Intergovernmental Revenue Miscellaneous Revenue Investment Earnings Capital contributions Contract principal payments Other Misc Revenue Total Miscellaneous Revenue Sale of Capital Assets Transfers In $ 4,895,000 4,895,000 200,000 75,000 1,000 276,000 96,000 $ 4,413,918 4,413,918 142,177 61,035 171,200 30,376 770 263,382 (102,407) 364,093 $ (481,082) (481,082) 142,177 (138,965) 171,200 (44,624) (230) (12,618) (102,407) 268,093 (185,838) 96.47% 90.17% 90.17% 0.00% 30.52% 0.00% 40.50% 77.00% 95.43% 0.00% 379.26% Total Revenue 5,267,000 5,081,162 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 Total Expenses 508,185 512,995 6,000 - 5,738 2,401 39,774 38,393 42,217 26,701 10,886 10,571 139,094 132,417 1,000 1,330 1,227 91,811 102,019 1,950,500 1,865,894 4,500 11,859 274,300 88,336 2,500 2,409 1,500 836 77,811 68,230 20,260 15,608 23,000 19,257 11,000 3,500 7,200 17,817 184,000 201,173 490,000 501,592 1,002,400 48,962 306,200 401,280 156,667 144,752 5,357,873 4,218,229 608,400 3,100,106 5,966,273 7,318,335 Change in Fund Balance Adjustment for restricted net assets & other Beginning Fund Balance (699,273) 3,999,209 Ending Fund Balance $ (2,237,173) 2,049,091 6,116,633 3,299,936 $ 5,928,552 Fund 401 4,810 (6,000) (3,337) (1,381) (15,516) (315) (6,677) (1,000) (103) 10,208 (84,606) 7,359 (185,964) (91) (664) (9,581) (4,652) (3,743) (7,500) 10,617 17,173 11,592 (953,438) 95,080 (11,915) (1,139,644) 2,491,706 509.55% 1,352, 062 122.66% 100.95% 0.00% 41.85% 96.53% 63.25% 97.10% 95.20% 0.00% 92.27% 111.12% 95.66% 263.54% 32.20% 96.36% 55.73% 87.69% 77.04% 83.73% 31.81% 247.46% 109.33% 102.37% 4.88% 131.05% 92.39% 78.73% (1,537,900) 2,117,424 $ 2,628,616 319.93% 152.95% 179.66% City of Tukwila Sewer Fund 402 - Revenue and Expenditures As of December 31, 2010 % of year expired 100.00% 2010 Adjusted Actual % of Budget (Year -To -Date) Variance Budget Revenue Charges for Services Sewer Sales Total Charges for Services Miscellaneous Revenue Investment Earnings Contract principal payments Total Miscellaneous Revenue $ 5,178,000 $ 5,230,879 $ 52,879 101.02% 5,178,000 5,230,879 52,879 101.02% 50,000 29,876 (20,124) 59.75% 400,000 107,389 (292,611) 26.85% 450,000 137,265 (312,735) 30.50% Total Revenue 5,628,000 6,376,668 748,668 113.30% Expenditures 11 Salaries 261,481 251,279 (10,202) 96.10% 12 Extra Labor 8,000 7,660 (340) 95.75% 13 Overtime 3,442 1,503 (1,939) 43.67% 21 FICA 20,879 19,037 (1,842) 91.18% 23 PERS 22,161 13,030 (9,131) 58.80% 24 Industrial Insurance 5,513 4,840 (673) 87.79% 25 Medical, Dental, Life, Optical 60,316 54,873 (5,443) 90.98% 26 Unemployment Compensation 1,000 - (1,000) 0.00% 28 Uniform Clothing 570 562 (8) 98.64% 31 Office & Operating Supplies 22,100 19,573 (2,527) 88.56% 33 Water Purchased for Resale 3,749,000 3,088,320 (660,680) 82.38% 35 Small Tools & Minor Equipment 4,000 2,500 (1,500) 62.49% 41 Professional Services 271,600 37,528 (234,072) 13.82% 42 Communication 2,500 2,404 (96) 96.18% 43 Travel 500 564 64 112.81% 44 Advertising 150 (150) 0.00% 45 Operating Rentals & Leases 100,571 122,714 22,143 122.02% 46 Insurance 15,195 11,706 (3,489) 77.04% 47 Public Utility Services 22,050 25,903 3,853 117.47% 48 Repairs & Maintenance 43,000 40,478 (2,522) 94.14% 49 Miscellaneous 4,000 13,173 9,173 329.34% 53 Excise Taxes 40,000 64,131 24,131 160.33% 54 Interfund utility tax 550,000 618,096 68,096 112.38% 64 Capital Outlay 575,000 4,245 (570,755) 0.74% 80 Debt Service Principal 74,400 266,661 192,261 358.42% 81 Debt Service Interest 92,488 91,085 (1,404) 98.48% Total Sewer Fund 5,949,916 4,761,866 (1,188,050) 80.03% Transfers Out 499,335 2,305,321 1,805,986 461.68% Total Expenses 6,449,251 7,067,187 617,936 109.58% Change in Fund Balance (821,251) (690,520) 130,731 84.08% Adjustment for restricted net assets & other 1,555,589 Beginning Fund Balance 4,613,297 1,793,638 (2,819,659) 38.88% Ending Fund Balance $ 3,792,046 $ 2,658,708 $ (1,133,338) 70.11% Fund 402 31 32 City of Tukwila Foster Golf Course 411- Revenue and Expenditures As of December 31, 2010 % of year expired 100.00% 2010 Adjusted Budget Actual (Year -To -Date) Variance % of Budget 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 Revenue 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 Interfund admissions tax 64 Capital Outlay 80 Debt Service Principal 81 Debt Service Interest Total Foster Golf Course Fund Transfers Out Total Expenses $ 450,000 450,000 170,000 1,310,000 1,480,000 10,000 322,000 332,000 2,262,000 Change in Fund Balance Adjustment for restricted net assets & other Beginning Fund Balance 498,893 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 415,343 310,495 2,418,769 13,140 2,431,909 (169,909) Ending Fund Balance $ 328,984 Fund 411 $ 329,527 2,867 332,394 132,220 1,023,689 1,155,909 1,213 267,192 (640) 267,765 1,756,067 656,188 94,584 2,405 54,490 36,915 18,651 144,454 8,325 1,181 50,819 94,351 6,305 7,242 8,595 31 1,672 104,608 11,706 45,743 43,141 12,822 6,369 60,562 184,972 150,824 1,806,953 13,140 1,820,093 (64,026) 228,858 3,631 $ 168,463 $ (160,521) 51.21% $ (120,473) 73.23% 2,867 0.00% (117,606) 73.87% (37,780) 77.78% (286,311) 78.14% (324,091) 78.10% (8,787) 12.13% (54,808) 82.98% (640) 0.00% (64,235) 80.65% (505,933) 77.63% 27,733 104.41% (39,316) 70.64% (4,480) 34.93% (4,356) 92.60% (25,547) 59.10% (6,341) 74.63% (18,098) 88.87% (2,675) 75.68% 17 101.43% (46,181) 52.39% (36,149) 72.30% 3,805 252.20% (1,759) 80.46% (1,105) 88.61% (1,219) 2.46% (28,328) 5.57% (32,907) 76.07% (3,489) 77.04% (19,022) 70.63% 7,141 119.84% (428) 96.77% 369 106.15% 60,562 0.00% (50,000) 0.00% (230,371) 44.53% (159,671) 48.58% (611,816) 74.71% 100.00% (611,816) 74.84% 105,883 37.68% (495,262) 0.73% City of Tukwila Surface Water Fund 412 - Revenue and Expenditures As of December 31, 2010 % of year expired 100.00% 2010 Adjusted Budget Actual (Year -To -Date) Variance % of Budget Revenue Charges for Services Surface Water Sales Total Charges for Services Intergovernmental Revenue Miscellaneous Revenue Investment Earnings Capital contributions Insurance Premiums /Recovery Employee Contributions Other Misc Revenue Total Miscellaneous Revenue Sale of Capital Assets Total Revenue 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 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 Expenses $ 3,042,000 3,042,000 130,000 130,000 $ 3,020,714 3,020,714 97,541 22,823 6,053,221 75 6,076,119 $ (21,286) 99.30% (21,286) 99.30% 97,541 (107,177) 6,053,221 75 5,946,119 0.00% 17.56% 0.00% 0.00% 0.00% 0.00% 4673.94% (110,640) (110,640) 0.00% 3,172,000 9,083,734 5,911,734 286.37% Change in Fund Balance Transfer to capital assets net of related debt Beginning Fund Balance Ending Fund Balance 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 14,400 35,353 2,720,723 375,815 3,096,538 75,462 606,251 (66,612) 90.10% 36,403 13,403 158.27% 7,258 (4,395) 62.29% 49,500 (4,624) 91.46% 34,031 (23,419) 59.24% 10,914 (4,379) 71.37% 182,705 (67,665) 72.97% 451 (549) 45.12% 1,016 (409) 71.33% 15,812 (25,143) 38.61% 4,201 1,201 140.03% 212,377 (226,193) 48.42% 1,917 (83) 95.83% 1,039 (961) 51.95% (500) 0.00% 87,512 6,005 107.37% 11,706 (3,489) 77.04% 12,093 (49,507) 19.63% 4,710 (9,255) 33.73% 17,277 10,777 265.80% 39,017 14,017 156.07% 378,094 60,094 118.90% 8,321 (566,679) 1.45% 343,614 329,214 2386.21% 35,350 (3) 99.99% 2,101,568 (619,155) 77.24% 375,815 0 100.00% 2,477,383 (619,155) 80.00% 5,401,203 $ 5,476,665 Fund 412 6,606,351 6,530,889 - 8754.54% (6,444,186) 2,128,642 (3,272,561) 39.41% $ 2,290,807 $ (3,185,858) 41.83% 33 34 City of Tukwila Equipment Rental /Replacement Fund 501 - Revenue and Expenditures As of December 31, 2010 % of year expired 100.00% 2010 Adjusted Actual % of Budget (Year -To -Date) Variance Budget Revenue Charges for Services ERR O &M Dept Charges $ 1,346,469 $ 959,751 $ (386,718) 71.28% Equipment Replacement Charges 784,361 206,656 (577,705) 26.35% Fuel Sales 474,000 335,399 (138,601) 70.76% Transportation - 1,071 1,071 0.00% Total Charges for Services 2,604,830 1,502,877 (1,101,953) 57.70% Miscellaneous Revenue Investment Earnings Total Miscellaneous Revenue Sale of Capital Assets Transfers In Total Revenue 50,000 50,000 2,654,830 23,352 (26,648) 46.70% 23,352 (26,648) 46.70% 22,891 22,891 0.00% 158,095 158,095 0.00% 1,707,215 (947,615) 64.31% Expenditures 11 Salaries 321,747 324,740 2,993 100.93% 12 Extra Labor 10,000 11,118 1,118 111.18% 13 Overtime 1,147 1,826 679 159.18% 21 FICA 25,467 25,654 187 100.74% 23 PERS 27,031 17,931 (9,100) 66.34% 24 Industrial Insurance 7,757 8,485 728 109.39% 25 Medical, Dental, Life, Optical 102,215 95,924 (6,291) 93.84% 26 Unemployment Compensation 1,000 - (1,000) 0.00% 28 Uniform Clothing 950 640 (310) 67.37% 31 Office & Operating Supplies 2,000 1,041 (959) 52.03% 34 Items Purchased for Resale 689,000 525,145 (163,855) 76.22% 35 Small Tools & Minor Equipment 2,500 3,612 1,112 144.47% 41 Professional Services 550 750 200 136.35% 42 Communication 2,000 1,934 (66) 96.68% 43 Travel - 757 757 0.00% 45 Operating Rentals & Leases 18,297 41,790 23,493 228.40% 46 Insurance 10,130 7,806 (2,324) 77.06% 48 Repairs & Maintenance 130,781 46,755 (84,026) 35.75% 49 Miscellaneous 6,500 7,938 1,438 122.12% 64 Capital Outlay 391,300 - (391,300) 0.00% Total Equipment Rental Fund 1,750,372 1,123,845 (626,527) 64.21 % Transfers Out 199,734 199,734 100.00% Total Expenses 1,950,106 1,323,579 (626,527) 67.87% Change in Fund Balance 704,724 383,636 (321,088) 54.44% Transfer to capital assets net of related debt (378,003) Beginning Fund Balance 5,557,012 3,316,351 (2,240,661) 59.68% Ending Fund Balance $ 6,261,736 $ 3,321,984 $ (2,939,752) 53.05% Fund 501 City of Tukwila Insurance Fund 502 - Revenue and Expenditures As of December 31, 2010 % of year expired 100.00% 2010 Actual Adjusted (Year -To- % of Budget Date) Variance Budget Revenue Charges for Services Employee Benefit Programs $ 900 $ 612 $ (288) 68.02% Total Charges for Services 900 612 (288) 68.02% Miscellaneous Revenue Investment Earnings 25,000 (45,599) (70,599) - 182.40% Employer Trust Contributions 6,300,731 5,456,708 (844,023) 86.60% Employee Contributions 67,000 59,956 (7,044) 89.49% Other Misc Revenue - 4,111 4,111 0.00% Total Revenue 6,393,631 5,475,787 (917,844) 85.64% Expenditures 25 Medical, Dental, Life, Optical 5,719,830 4,265,904 (1,453,926) 74.58% 41 Professional Services 25,000 18,900 (6,100) 75.60% 49 Miscellaneous 20,500 19,426 (1,074) 94.76% Total Expenses 5,765,330 4,304,231 (1,461,099) 74.66% Change in Fund Balance Beginning Fund Balance 628,301 1,516,241 1,171,557 3,381,691 543,256 1,865,450 186.46% 223.03% Ending Fund Balance $ 2,144,542 $ 4,553,247 $ 2,408,705 212.32% Fund 502 35 City of Tukwila LEOFF Insurance Fund 503 - Revenue and Expenditures As of December 31, 2010 % of year expired 100.00% 2010 Actual Adjusted (Year -To- Budget Date) Variance % of Budget Revenue Miscellaneous Revenue Investment Earnings $ 20,000 $ 8,344 $ (11,656) 41.72% Employer Trust Contributions 765,523 577,001 (188,522) 75.37% Other Misc Revenue - 454 454 0.00% Total Revenue 785,523 585,799 (199,724) 74.57% Expenditures 25 Medical, Dental, Life, Optical 659,530 248,310 (411,220) 37.65% 41 Professional Services 3,000 2,100 (900) 70.00% 49 Miscellaneous 10,000 - (10,000) 0.00% Total Expenses 672,530 250,410 (422,120) 37.23% Change in Fund Balance Beginning Fund Balance 112,993 841,069 335,389 1,251,360 222,396 296.82% 410,291 148.78% Ending Fund Balance $ 954,062 $ 1,586,749 $ 632,687 166.32% Fund 503 36