Loading...
HomeMy WebLinkAboutFS 2009-08-18 Item 2A - Budget - 2009 Second Quarter Budget UpdateTO: All Funds City of Tukwila INFORMATIONAL MEMORANDUM Mayor Haggerton Rhonda Berry Finance and Safety Committee FROM: Shawn Hunstock, Finance Director DATE: August 12, 2009 SUBJECT: Second Quarter 2009 Budget Update Jim Haggerton, Mayor The following pages summarize the status of various funds throughout the City, as of June 30, 2009. As you will see from many of the pages, revenue is down in several areas for multiple funds. However, expenditures are generally down as well, meaning there is no immediate concern in terms of cash flow or solvency for the various funds. During the discussion of Codiga Park and the Parks Open Space Acquisition Fund, there was some discussion about the fund balance available for use within that fund. wanted to give Council information about fund balance available in all funds. Many of these funds have restrictions on the use of the fund balance, but I thought it worthwhile for Council to know the balances in each fund, as of June 30 LEOFF Insurance Fund Self- Insurance Fund Equipment Replacement Fund Surface Water Fund Foster Golf Fund Sewer Fund Water Fund General Gov Improvements Facility Replacement Fund Parks Acq Fund Debt Service Funds Drug Seizure Fund Fire Equip Cum Reserve Contingency Fund Arterial Street Fund Street Fund HoteVMotel Tax Fund General Fund Fund Balances As of June 30, 2009 $2,000,000 $4,000,000 $6,000,000 $6,000,000 $10,000,000 $12,000,000 Page 1 INFORMATIONAL MEMO Page 2 As you can see from the graph above, there are significant balances available in various funds. Specifically, the largest fund balances are in the Arterial Street Fund ($10,655,688), the General Fund ($7,514,775), the Water Fund ($5,257,226), the Parks Acquisition Fund ($4,591,389), and the Sewer Fund ($4,277,739). The Internal Service Funds have significant balances as well, which includes the Equipment Replacement Fund ($3,314,625), the Self- Insurance Fund ($2,459,939), and the LEOFF Insurance Fund ($1,096,929). General Fund As of June 30, 2009, the General Fund has collected 49.11% of budgeted revenue for the year, which is close to budget as of the middle of the year. Expenditures are at 46.66% of budget as of June 30 For the year to date, fund balance in the General Fund decreased by only $204,079. Significant negative variances in revenue exist for Sales and Use Taxes ($943,883), Building Permits and Fees ($565,086), and Plan Check and Review Fees ($339,231). Positive variances exist for Property Taxes ($118,497), Utility Taxes ($296,392), and Sale of Capital Assets ($498,500). In terms of expenditures, all departments are within budget for the year to date, with the exception of Finance and Legal. Unanticipated overtime and extra labor, as well as unbudgeted software purchases (Project Accounting) and underfunded software licensing and support expenses all contributed to the deficit in Finance. Also, annual insurance costs, as compared to a six month budget, appear to contribute to a deficit when in fact it represents a twelve month cost of premiums for WCIA. The small negative variance in Legal is due to higher than expected expenses for Special Matters resulting from litigation and defense of the City on labor issues. For all departments, one of the areas the Mayor has focused attention on is the use of overtime and extra labor. During 2008, the City as a whole was significantly over budget in both areas in the General Fund. As of June 30, 2009, the City is slightly under budget for both line items (45.46% for extra labor and 46.01% for overtime, as compared to 50% of the budget for the year to date). Other Funds The Arterial Street Fund (104) is at 7.33% of budgeted revenue as of June 30 however expenses are only at 5.34% for the same time period. The significant variances are primarily due to delayed starts, or projects that were not scheduled to start yet, such as TIB Phase II and III, Klickitat and the Southcenter Parkway extension and realignment. The Water Fund (401) is at 41.27% of revenue collected for the year and 46.12% of expenditures. A contributing factor in the disparity between revenue and expenses is an increase in the cost of purchased water. H:12009 Second Quarter Budget Review.doc Page 2 INFORMATIONAL MEMO Page 3 The Equipment Rental /Replacement Fund (501) is at 41.46% of budgeted revenue, and 58.17% of budgeted expenditures. A major cause of the revenue variance is the decision by Administration and Council to not fund equipment replacement contributions for 2009 as a cost savings measure. The expenditure variance is due to the purchase of a Vactor for $354,000 which was budgeted for, and anticipated to be received in, 2008 but actually was not received until 2009. ATTACHMENTS Revenue and Expenditure Reports, by Fund H:12009 Second Quarter Budget Review.doc Page 3 City of Tukwila General Fund 000 Revenue and Expenditures As of June 30, 2009 Revenue General Revenue Property Taxes Sales and Use Taxes Admissions Tax Utility Taxes 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 }7`ot J 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 i fai 1014eise# Change in Fund Balance Beginning Fund Balance Ending Frtr+'d Balance ctua 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 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 ctual 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 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 260,080 234,769 1,851,301 2,037,794 357,146 475,813 1,625,499 1,602,167 757,310 603,378 2,799,025 2,956,021 2,325,684 2,423,936 908,696 999,584 11,230, 938 11, 764,214 9,293,758 9,457,701 530,787 586,036 3,125,054 3,304,857 903,162 894,145 2,121,394 2,240,234 310,405 356,226 219,000 '36,fi18 239';,'(;<_z ;30936;875;, 8,965,794 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 2,587,088 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 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 t 2008 Actual (259,329) 1,810,933 (2,812,083) 8,706,465 10,517,398 Adjusted nge-- Budget Actual r (Year-To-: Date)' 2.11% $12,200,000 6,218,497 -2.93% 14,731,118 6,421,676 24.19% 270,000 214,955 34.26% 3,756,000 2,174,392 15.95% 2,200,000 1,189,565 36.86% 2,000 43 4.13% 33,159,118 16,219,128 8.56% 85.74% 58.88% 12.67% -23.08% 121.05% 88.00% 65.67% 0.31% -8.14% 9.53% 17.59% (530,869) 100 53,592 110.10% 1,993,581 2,130,752 2,215,982 11. 16% 6,59;910 `Si:,_ .4047,80a 4.1;171,965, 7.33 43,647,118'_ 0.44% 282,470 15.62% 2,686,526 41.86% 605,882 18.87% 1,786,591 -3.74% 495,726 12.84% 3,529,662 31.86% 2,953,604 25.10% 1,149,884 13.07% 13,293,901 9.24% 10,273,966 27.44% 1,108,886 15.48% 4,042,278 6.85% 989,515 21.33% 2,563,550 21.42% -100.00% 613,444 984,048:: ':,33.89 479,000 335,351 1,723,000 296,414 2,202,000 631,765 2,703,000 1,282,520 68,000 26,371 304,000 219,162 10,000 150,000 37,233 979,000 150,269 703,000 304,052 2,214,000 737,087 229,000 99,413 2,370,000 1,653,400 (2,728,767) 10,149,000 133,440 1,099,304 267,858 1,096,037 286,717 1,606,944 1,345,697 573,829 6,276,536 4,916,922 496,353 1,792,447 435,487 1,141,365 13,539 154,647 21,637,122 Variance of Budget (5,981,503) (8,309,442) (55,045) (1,581,608) (1,010,435) (1,957) (16,939,990) (143,649) (1,426,586) (1,570,235) (1,420,480) (41,629) (84,838) (10,000) (112,767) (828,731) (398,948) (1,476,913) (129,587) (149,030) (1,587,222) (338,024) (690,554) (209,009) (1,922,718) (1,607,907) (576,055) (7,017,365) (5,357,044) (612, 533) (2,249,831) (554,028) (1,422,185) 13,539 (458,797) (24,738,763) (204,079) 2,524,688 7,705,315 (2,443,685) EiNt4'65,1,r $10;517598_;- 1 705; 315`.7 7,420,233 7,501;23671 81,003= Page 4 50 97% 43.59% 7961% 57.89% 54.07% 2.15% 48.91% 70.01% 17.20% 28.69% 47 45% 38.78% 72.09% 0.00% 24.82% 15.35% 43.25% 33.29% 43.41% 26.26% 402,000 69,659 (332,341) 17.33% 6.64% 341,000 166,679 (174,321) 48.88% 63.24% 1,000 643 (357) 64 30% 1785.04% 21,000 10,000 (11,000) 47.62% 248.57% 61,749 61,749 #DIV /01 19.17% 765,000 308,730 (456,270) 40 36% 5,000 501,000 496,000 10020.00% (716,600) 69.76% '23,433,043 iZ2,214,075j 49.11% 47.24% 40.92% 44.21% 61.35% 57.84% 45.53% 45.56% 49.90% 47.21% 47.86% 44.76% 44.34% 44.01% 44.52% 25.21% 46.66% 7.48% 75.92% City of Tukwila General Fund 000 Revenue and Expenditures As of June 30, 2009 Revenue General Revenue Property Taxes Sales and Use Taxes Admissions Tax Utility Taxes Excise Taxes Penalties /Interest Total General Revenue us t!ed Budget,_ Actual,.; Variance as nrival (Y ear To {Year To- of Budget (Year udaeit datet Date) Variance "To- Date), 12,200,000 6,100,000 6,218,497 118,497 1.94% 14,731,118 7,365,559 6,421,676 (943,883) 12.81% 270,000 135,000 214,955 79,955 59.23% 3,756,000 1,878,000 2,174,392 296,392 15.78% 2,200,000 1,100, 000 1,189,565 89,565 8.14% 2,000 1,000 43 (957) 95.70% 33,159,118 16,579,559 16,219,128 (360,431) -2.17% Licenses and Permits Business Licenses and Permits 479,000 239,500 335,351 95,851 40.02% Building Permits and Fees 1,723,000 861,500 296,414 (565,086) 65.59% Total Licenses and Permits 2,202,000 1,101,000 631,765 (469,235) 42.62% Intergovernmental Revenue 2,703,000 1,351,500 1,282,520 (68,980) 5.10% Charges for Services General Government 68,000 34,000 26,371 (7,629) 22.44% Security 304,000 152,000 219,162 67,162 44.19% Engineering Services 10,000 5,000 (5,000) 100.00% Transportation 150,000 75,000 37,233 (37,767) 50.36% Plan Check and Review Fees 979,000 489,500 150,269 (339,231) 69.30% Culture and Rec Fees 703,000 351,500 304,052 (47,448) 13.50% Total Charges for Services 2,214,000 1,107,000 737,087 (369,913) 33.42% Fines and Penalties 229,000 114,500 99,413 (15,087) 13.18% Miscellaneous Revenue Investment Earnings 402,000 201,000 69,659 (131,341) 65.34% Rents and Concessions 341,000 170,500 166,679 (3,821) 2.24% Insurance Premiums /Recovery 1,000 500 643 143 28.60% Contributions /Donations 21,000 10,500 10,000 (500) 4.76% Other Misc Revenue 61,749 61,749 #DIV /0! Total Miscellaneous Revenue 765,000 382,500 308,730 (73,770) 19.29% Sale of Capital Assets 5,000 2,500 501,000 498,500 19940.00% Transfers In 2,370,000 1,185,000 1,653,400 468,400 39.53% Tots /_Reveriue�;��;, az,:: ..i��s!: 3 54711 ":'s:` 21;$23 559 21,433;843 (390,516) -1.79% Page 5 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 T tat Expenses''p` w Change in Fund Balance Beginning Fund Balance _Ending Fgnal Baiance ijusted nnial fudge 282,470 2,686,526 605,882 1,786,591 495,726 3,529,662 2,953,604 1,149, 884 13,293,901 10,273,966 1,108,886 4,042,278 989,515 2,563,550 613,444 6,375,885; (2,728,767) 10,149, 000 tudget_ ate]` 141,235 1,343,263 302,941 893,296 247,863 1,764,831 1,476,802 574,942 6,646,951 5,136, 983 554,443 2,021,139 494,758 1,281,775 306,722 3;1 87,843 (1,364,384) 10,149, 000 200 Actual: ear -To Date) 133,440 1,099,304 267,858 1,096,037 286,717 1,606,944 1,345,697 573,829 6,276,536 4,916,922 496,353 1,792,447 435,487 1,141,365 13,539 154,647 Va riance_ as of Bud9et (Year Variance To -Date) (7,795) (243,959) (35,083) 202,742 38,854 (157,887) (131,105) (1,113) (370,415) (220, 061) (58,090) (228,692) (59,271) (140,410) 13,539 (152,075) _21,637,122`_;= ;(1 (204,079) 2,524,688 7,705,315 (2,443,685) 84,617- 7,501 ,236 :T 81,003 5.52% 18.16% 11.58% 22.70% 15.68% 8.95% 8.88% 0.19% 5.57% -4.28% 10.48% 11.32% 11.98% 10.95% #DIV /0! 49.58% 6.69% 185.04% 24.08% Page 6 CITY OF TUKWILA Expenditures through June 30, 2009 BY DEPARTMENT 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 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 I FUND BALANCE 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 EQUIPMENT 282,470 2,686,526 605,882 1,786,591 495,726 3,529,662 2,953,604 1,149,884 13,293,901 10,273,966 1,108,886 4,042,278 989,515 2,563,550 8,033,677 165,516 12,662 13,440 1,886 33,066 3,500 3,000 4,400 30,000 15,000 1,040,208 28,500 551 81,789 86,010 3,671 232,073 31,325 737,950 86,000 23,000 21,300 28,096 13,850 227,703 26,500 18,000 ACtum|Spmmm� 133,440 1,099,304 267,858 1,096,037 286,717 1,606,944 1,345,697 573,829 6,276,536 4,916,922 496,353 1,792,447 435,487 1,141,365 168,186 '+$21L637'122\� "anal Spent 82,290 6,232 3,174 953 14.744 468,204 13,387 298 36,656 38,608 1,431 97,004 19,771 270,155 28,428 5,559 5,566 15,871 2,078 77,179 19,109 0 through the year 50.00% Rentaining 7 q�SPmnt 1 149.030 47.24% 1,587,222 40.9296 338,024 44.21% 690.554 61.35% 209.009 57.84% 1.922.718 45.53% 1.607.907 45.56% 576.055 49.9096 7.017.365 47.21% 5.357.044 47.86% 612.533 44.76Y6 2.249.831 44.34% 554.028 44.01% 1.422.185 44.52% 7.885.491 2.0996 32A58.996 T 40.22% Midget 83.220 49.72% 6.430 49.22% 10.268 23.62% 933 50.53% 18,322 44.5996 892 2.508 28.34% 3,984 -984 132.80Y6 2.116 2.284 48.09% 13.793 18.207 45.98% 5,162 9,838 34.41% 572,004 15,113 253 45,133 47,402 2,240 135,069 11,554 467,795 57,572 17,441 15,734 12,225 11,772 150,524 7,391 45.01% 46.97% 54.08% 44.82% 44.89% 38.98% 41.80% 63.12% 36.61% 33.06% 24.17% 26.13% 56.49% 15.00% 33.89% 72.11% 18,000 0.00% Page 7 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 ',00:04 IMO 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 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 341,352 170.011 3,500 26,381 28,002 993 55,513 8,470 103,021 2,000 4,000 20,000 50 4,600 8,000 605 882 �1��'��`��� Spent- �Y6 170.741 49.98% 0 3.500 0.00% 12.630 13,751 47.8896 14,178 13,824 50.6396 416 577 41.8996 27,572 27.941 49.8796 863 7.007 10.1996 30.439 72,582 29.55% 3 1.997 01596 1131 2.860 28.28% 8.285 13,715 31.43% 16 34 32.0096 508 4.002 11.0494 3.200 4.794 40.0896 -_-e ��o��` Sp en 896.328 457,404 10.000 10.030 1,103 4.791 69.418 35.699 73,683 36,798 3,207 1481 241,352 144.907 20.000 11,602 85.000 39.721 80.000 98.192 1,000 1 5,000 851 277.500 182.304 5.000 2,672 13.000 69,575 5,000 0 438,924 -39 -3,688 33,719 36,885 1,726 96,445 8,398 45,279 -18,192 999 4,149 95,196 2,328 -56,575 5,000 0 2,500 0 191 2 33 1.065 3.935 284.943 197.057 0 2,500 16 484 367 1,633 324 676 0.00% 0.00% 5,71% 21.30% 59.12% 0.00% 3.20% 18.35% 32.40% 51.03% 100.39% 434.36% 51.43% 49.94% 46.18% 60.04% 58.01% 46.73% 122.74% 0.10% 17.02% 65.70% 53.44% 535.19% 0.00% Page 8 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 MACH|NERY&B]U\PMENT 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 Budge[ 1,42Q.53O 468,890 10,821 146,058 133,384 49,821 416,232 116,550 19,000 223,185 32,607 9,050 15,900 52,488 100,000 30,400 275,740 0 0 "4' udget 1,755,256 47,900 14,564 139,056 147,599 17,441 357,427 1,805 33,098 600 262,010 4,500 12,000 12,233 1,000 9,050 120,065 18,000 �x^ Actual Spent BUdget 710.742 718.794 223,272 245.618 450 10,371 70.361 75.697 65.073 68,311 21.294 28,527 207.812 208.420 46.605 69.945 12,808 8.192 53,247 169.938 3,853 28,754 3.303 5,747 2,145 13,755 23.558 28.930 71.206 28.794 24.400 5.901 63.810 211.030 46 -46 2.05O '2.950 1;505,844 ,1,922,718": :Actual Spent Spent 49.72% 47.62% 4.16% 48.17% 48.79% 42.74% 49.93% 39.99% 07.4196 23.86% 11.82% 36.50% 13.49% 44.88% 71.21% 80.29% 23]496 #DIV/0! #DIV/0! emaining Budget Spent 880.885 894.391 49.04Y6 16,232 31.668 33.8996 6.931 7.633 47.5996 86.840 72.216 48.0796 73,107 74.492 49.53Y6 6.716 10.725 38.51Y6 108.011 189.416 47.01% 0 1.805 0.00% 11.320 21,778 34.20% 324 276 54.00% 53,827 208.183 20.54% 0 4.500 0.0096 623 11,377 5.19Y4 8.270 3.903 07.809S 395 805 39.50% 38.804 '29.754 428.77% 14,835 105.230 12.36Y6 18,597 -597 103.32% 45.56%. Page 9 ����U 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 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 46 INSURANCE 48 REPAIRS MAINTENANCE 49 MISCELLANEOUS 51 INTERGVRNMTL PROFESSIONAL SVCS 64 MACHINERY EQUIPMENT 596,714 4,500 5,517 46,415 49,266 2,363 119,394 9,000 274,000 5,550 7,815 5,000 3,000 21,350 Udge 6,583,818 5,000 865,039 570,834 336,957 90,697 87,531 1,794,106 138,284 32,175 60,031 23,300 800 534,593 225,080 170,490 66,245 1,697,100 11,821 309,070 287,644 3,707 5,485 22,989 23,579 1,215 53,792 7,009 143,124 2,968 4,970 4,178 2.2O3 793 13,132 32 c 23,426 25,687 1,148 65,602 1,991 130,876 2,582 2.845 822 737 8 218 3,422,012 -2,870 -2,870 438.Q42 297,116 169,030 54,305 39,859 938,538 74,327 -9,924 -9,924 36,127 12,557 800 173,470 78,298 110,426 42,387 1,130,144 11,821 3,161,806 7,870 426,097 273,718 167,927 36,392 47,672 855,568 63,957 42,099 23,904 10,743 0 361,123 146,782 60,064 23,858 566,956 0 Remaining 76Spent 51.80% 17.62% 0.58% 50.47% 52.14% 48.58% 54.95% 22.12% 47.76% 46.52% 36.40% 16.44% 24.57% 38.49% Page 10 48.0296 157.40% 49.26% 47.95% 49.84% 40.12% 54.46% 47.69% 40.2596 130.84% 39.82% 46.11% 0.00% 67.55% 65.21% 35.23% 36.01% 33.41% 0.00% `�7-21W 11"; FIRE a�,~~��' HYDRANT 00 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 �m@ 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 Reniaining budget! S' t: Budme�^�'�` Actma| pmmt 102,960 2,922,403 205,863 1,014 41,971 148,648 9,988 51,808 831,990 0 53,976 948 27,161 6,652 1,408 200,865 58,713 33,710 15,102 44,202 149,730 7,810 06.000 6,042,761 509,687 171,392 106,914 328.411 36,362 85,244 1,729,435 1,140 152,150 17,000 55,300 30,000 9,500 304,837 90,000 60,000 35,500 72,583 326,000 12 750 497,802 2,500 0 38,273 40,625 1,921 141,865 6,200 0 2,000 74,700 1,500 /�'~x exmm ��mz 241.143 2,086 200 18,497 20,056 852 70,642 5,572 64,828 281 19,004 70 0 16 7.500 1.629 53.000 18,344 241.000 33,133 1 496 256,659 414 -200 19,776 20,569 1,069 71,223 628 'G4.828 1,719 55,696 1,430 -16 5,871 34,656 207,867 '6 107.25% 3.120.358 48.3696 303,824 40.39Y6 170.378 0.5996 64.043 3926Y6 180.703 45.13% 26,374 27.47% 33,436 607896 897.445 48.11% 1,140 0.00% 98.174 35.48% 18.052 5.58% 28.139 49.12% 23,348 22.17% 8.092 14.8296 103.972 65.8996 31.287 65.24Y6 26.290 56.18% 20.308 42.54% 28,381 60.00% 176.270 45.93% 4.940 61.25% .4 7 A 6 $06111 48.44% 83.44% #DIV/O| 48.33% 49.37% 44.35% 49.80% 89.87% #DIV/0! 14.05% 25.44% 4.67% #DIV/0! 21.7296 34.61% 13.7596 Page 11 13:;.I Nom, C 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 _PUBLIC.WOR Budget 2,066,232 3,500 4,381 159,023 167,200 18,378 508,073 3,800 135,960 3,750 120,900 39,250 5,800 67,726 379,449 204,521 69,335 85,000 Actual Spent 949,302 497 1,696 72,161 79,029 9,869 248,459 243 53,911 667 44,146 40,997 929 46,223 152,804 90,114 1,400 0 1,792,447 5 ARK MAINT`ENANC 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 `.PARK MAINTENANC udge 438,612 35,020 2,207 36,402 38,638 13,301 98,712 1,425 46,000 2,500 22,000 1,000 500 44,698 140,000 52,000 4,000 10,000 2,500 8%51, ctual Spent 222,946 3,632 291 17,107 18,787 5,322 49,198 0 27,204 1,111 8,160 239 0 27,643 37,970 14,501 1,376 0 0 435,487 Remaining Budget Spent 1,116,930 45.94% 3,003 14.20% 2,685 38.71% 86,862 45.38% 88,171 47.27% 8,509 53.70% 259,614 48.90% 3,557 6.39% 82,049 39.65% 3,083 17.79% 76,754 36.51% -1,747 104.45% 4,871 16.02% 21,503 68.25% 226,645 40.27% 114,407 44.06% 67,935 2.02% 85,000 0.00% 2;249;8$1,;_ 44.a4°l0 ema n ng Budget`:_ °l° Spent 215,666 50.83% 31,388 10.37% 1,916 13.19% 19,295 46.99% 19,851 48.62% 7,979 40.01% 49,514 49.84% 1,425 0.00% 18,796 59.14% 1,389 44.44% 13,840 37.09% 761 23.90% 500 0.00% 17,055 61.84% 102,030 27.12% 37,499 27.89% 2,624 34.40% 10,000 0.00% 2,500 0.00% _5 54,028 44.014, Page 12 1 STREET MAIN 6 TENANCE :OPERAT ION' 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 28 UNIFORM CLOTHING 31 OFFICE OPERATING SUPPLIES 35 SMALL TOOLS MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS LEASES 46 INSURANCE 47 PUBLIC UTILITY SERVICES 48 REPAIRS MAINTENANCE 49 MISCELLANEOUS 53 EXT TAXES OPERATING ASSMNTS 64 MACHINERY EQUIPMENT STREtiti INTENJ NGE &_OPER ..IR CONTRIBUTIONS: ND A 01 ESTIMATED UNSPENT APPROPRIATION 25 MEDICAL,DENTAL,LIFE,OPTICAL 41 PROFESSIONAL SERVICES 47 PUBLIC UTILITY SERVICES 49 MISCELLANEOUS ;CONTRIBIITIONP 0101464* Budget 742,200 43,577 11,033 61,025 64,411 20,639 225,190 2,375 368,800 10,931 4,000 4,300 2,700 1,500 193,684 35,455 661,930 27,100 5,200 0 77,500 2;563,558 udge 8,033,677 0 0 0 0 8,033,677 Actual Spent 375,942 20,111 8,960 29,707 32,350 9,142 110,870 741 59,845 213 1,625 480 372 0 128,825 34,249 295,911 8,608 100 1 23,313 1 ;141,365 Actual_Spent 154,647 250 10,087 502 2,700 168,186 Re Budget Spent 366,258 50.65% 23,466 46.15% 2,073 81.21% 31,318 48.68% 32,061 50.22% 11,497 44.29% 114,320 49.23% 1,634 31.20% 308,955 16.23% 10,718 1.95% 2,375 40.63% 3,820 11.16% 2,328 13.78% 1,500 0.00% 64,859 66.51% 1,206 96.60% 366,019 44.70% 18,492 31.76% 5,100 1.92% -1 #DIV /0! 54,187 30.08% 1;42 eniaini"ng: Budget Spent 7,879,030 1.92% -250 #DIV /0! 10,087 #DIV /0i -502 #DIV /0! -2,700 #DIV /0! ;.7,865,491 2;09% Page 13 `Grand :TotaEs r 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 Grand Totats Budget 8,129,677 22,596,335 655,387 1,424,903 171,392 1,494,441 666,368 969,317 306,431 5,952,438 20,000 10,545 1,139,337 19,000 34,781 2,401, 541 346,838 134,665 60,000 1,243, 905 628,035 1,342,379 565,011 952,221 2,067,600 0 10,000 453,571 53:796.115 Actual Spent 257,607 10,932,728 297,919 655,609 1,014 705,005 316,575 453,227 158,106 2,892,629 11,602 984 386,793 12,808 68,091 1,059,222 128,020 41,866 13,996 813,248 422,048 592,498 259,593 334,289 754,392 47 0 67,206 21,637,122 Remaining Budget Spent 7,872,070 3.17% 11,663,607 48.38% 357,468 45.46% 769,294 46.01% 170,378 0.59% 789,436 47.18% 349,793 47.51% 516,090 46.76% 148,325 51.60% 3,059,809 48.60% 8,398 58.01% 9,561 9.33% 752,544 33.95% 6,192 67.41% 33,310 195.77% 1,342,319 44.11% 218,818 36.91% 92,799 31.09% 46,004 23.33% 430,657 65.38% 205,987 67.20% 749,881 44.14% 305,418 45.94% 617,932 35.11% 1,313,208 36.49% -47 #DIV /0! 10,000 0.00% 386,365 14.82% 32,158,996 40.22% Page 14 0 67) 0 0 o o Q 0 0 0 o o o o 6 6 6 6 o o o o o in o In 6 N I() si CNJ r r r eir) EA- o o o o o 0 o o o 6 6 6 o o o Lc) o Lo N- L.6 csis 69. 6=i- trr 64 $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 Jan Feb Mar Apr REET by Month May June July Aug Sept Oct 2005 2006 2007 v-- 2008 2009 Total Annual REET Nov Dec Mar Apr May June July Aug Sept Oct 1-11— +2006 +2007 2008 —2009 Nov Dec Page 16 City of Tukwila Hotel /Motel Tax Fund 101 Revenue and Expenditures As of June 30, 2009 Revenue General Revenue Hotel /Motel Taxes Intergovernmental Revenue Miscellaneous Revenue Investment Earnings Other Misc Revenue Total Miscellaneous Revenue Total Reenww Expenditures 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 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 Eirpehs Change in Fund Balance Beginning Fund Balance _Errtl rig Fund'Oilence 600,000 907,000 20,000 5,000 25,000 ;532,0Q0`; 253,336 24,000 9,890 22,063 22,968 1,283 46,144 16,000 601,000 45,000 23,000 585,000 49,000 1,500 1,000 21,000 10,000 ,732;184 (200,184) 833,148 2009 Actual Year-To- Date) Variance of Budget 227,950 (372,050) 425,815 (481,185) 4,963 (15,037) 2,130 (2,870) 7,093 (17,907) 660, 858 '0871 ;142) 111,689 2,294 24,548 9,967 805 9,949 817 22,746 2,210 11,796 49,813 12,646 5,122 171,609 23,603 308 326 9,070 "469;31 "8. 191,540 870,356 (141,647) (21,706) 14,658 (12,096) 805 (13,019) (466) (23,398) 2,210 (4,204) (551,187) (32,354) (17,878) (413,391) (25, 397) (1,192) (674) (11,930) (10,000) (1,262,866i' 391,724 37,208 1,06'1;896; 428;932 37.99% 46.95% 24.82% 42.60% 28.37% 43.14% 44.09% 9.56% 248.21% 45.18% #DIV /0! 43.32% 63.68% 49.29% #DIV /0! 73.73% 8.29% 28.10% 22.27% 29.33% 48.17% 20.53% 32.60% 43.19% 0.00% 27.09% 95.68% 104.47% Page 17 City of Tukwila Street Fund 103 Revenue and Expenditures As of June 30, 2009 Revenue Intergovernmental Revenue (MVFT Taxes) 300,000 Miscellaneous Revenue Investment Earnings Expenditures 41 Professional Services Change in Fund Balance Beginning Fund Balance 10.008 1,342 40.66% (250.000) 0.00% 0.00% 250,000 OO 250.00O 80.000 126.039 257,000 363,109 124.697 (175.303) 41.57% �172,148 (8,658) 13.42% 68.039 210.0796 108.109 1412996 Page 18 City of Tukwila Arterial Street Fund 104 Revenue and Expenditures As of June 30, 2009 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 Total Revenue' Expenditures Bridges 104/01 41 Professional Services 64 Capital Outlay Total Bridges 104/01 Transfers Out zT ote! Eip Change in Fund Balance Beginning Fund Balance Ending,Fund °Ba%anc� Arterial Streets 104/02 11 Salaries 12 Extra Labor 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 41 Professional Services 45 Operating Rentals Leases 47 Public Utility Services 48 Repairs Maintenance 49 Miscellaneous 64 Capital Outlay Total Arterial Streets 104/02 d uste r Budget 2,650,000 140,000 500,000 3,290,000 14,907,000 300,000 3,903,000 4,203,000 22,46O,OOO 45,000 165,000 210,000 202,920 3,000 15,753 16,721 3,019 23,527 4,819,000 20,201,000 25,284,940 615,324 6 :41.0.4q (3,710,264) 11,546,000 7;835,7.36 1,042,728 69,032 113,534 1,225,294 (1,607,272) (70,968) (386,466) (2,064,706) 305,196 (14,601,804) 9,831 (290,169) 76,901 (3,826,099) 86,732 (4,1 16,268) 25,000 25,000 ,642,222 (20 ;757,776 Variance of Budget 39.35% 49.31% 22.71% 37.24% 2.05% 3.28% 1.97% 2.06% #DIV /0! 7.33% 12,347 (32,653) 27.44% 5,809 (159,191) 3.52% 18,156 (191,844) 8.65% 144,316 (58,604) 71.12% (3,000) 0.00% 4,755 4,755 #DIV /0! 11,065 (4,688) 70.24% 12,388 (4,333) 74.09% 388 (2,631) 12.85% 24,061 534 102.27% 532,065 (4,286,935) 11.04% 830 830 #DIV /0! 539 539 #DIV /0! 312 312 #DIV /0! 1,165 1,165 #DIV /0! 335,365 (19,865,635) 1.66% 1,067,249 (24,217,691) 4.22% 307,675 (307,649) 50.00% ;3 {24,71.7,1$4} 5.34% 249,142 3,959,406 -6.71% 10,406,546 (1,139,454) 90.13% 10;655,688_ 2;819;952 Page 19 City of Tukwila Contingency Fund 105 Revenue and Expenditures As of June 30, 2009 Revenue Miscellaneous Revenue Investment Earnings Total Revenue' Change in Fund Balance Beginning Fund Balance `Ending Fund.Bala»ce: ,uste adg et 17,000 17,000 857,187 Actual; ear -To -;Date) Variance- of Budget 1,144 (15,856) 6.73% 'T (15,856y 6.73% 1,144 (15,856) 878,418 21,231 8141$7'' 8:5;:: :$79,562' 8 075 6.73% 102.48% Page 20 Tukwila Fire Equipment Cum. Reserve 107 As of June 30, 2009 Revenue Miscellaneous Revenue Investment Earnings Contributions/Donations Total Miscellaneous Revenue Transfers In Expenditures 31 Office Operating Supplies 64 Capital Outlay Change in Fund Balance Beginning Fund Balance Revenue and Expenditures 9.000 1,313 685 9,000 1.998 328.797 47.858 328,797 7,000 420,000 (45,860) 425,058 (7,687) 685 (7,002) (328,797) (335,799) (2,000) (280,939) (52,860) 5,058 f-' (47,802Y 14.59% #DIV/0! 22.20% 0.00% 0.59% 0.00% 14.56% 14.47% 'G551496 Page 21 City of Tukwila Drug Seizure Fund 109 Revenue and Expenditures As of June 30, 2009 Revenue Miscellaneous Revenue Investment Earnings Seizure Revenue Total Miscellaneous Revenue Transfers In .Total Revenue' Expenditures 31 Office Operating Supplies 41 Professional Services 42 Communication 43 Travel 45 Operating Rentals Leases 48 Repairs Maintenance 49 Miscellaneous 64 Capital Outlay i Ex er se .w.. Change in Fund Balance Beginning Fund Balance £Ending FtTi (Bafanc� udge 200,000 200,000 154,647 354,64 20,000 4,500 500 10,000 23,000 2,000 5,000 105,000 170;000 184,647 '1 100 100 154,647 154,747 153,921 53,92 ariance of Budget 100 (200,000) (199,900) #DIV /0! 0.00% 0.05% 100.00% (199,900); 43.63% 226 (19,774) 1.13% (4,500) 0.00% (500) 0.00% (10,000) 0.00% (23,000) 0.00% (2,000) 0.00% 600 (4,400) 12.00% (105,000) 0.00% 826._ (169,174)_. 0.49% (30,726) 83.36% #DIV /01 30,72S) Page 22 City of Tukwila Debt Service Funds 2XX Revenue and Expenditures As of June 30, 2009 Revenue General Revenue Sales and Use Taxes Tota/ General Revenue Change in Fund Balance Beginning Fund Balance Miscellaneous Revenue Investment Earnings Total Miscellaneous Revenue Expenditures 80 Debt Service Principal 81 DebtSamice|nhaneat .Ending FuridSalance 2,083,882 2,083,882 760,618 760,618 (1,323,264) (1.323.264) 36.50% 36.50% 41.000 3,001 (37.999) 7.32% 7.32% 41.000 3.001 (37.909) 35.94% 1,281,297 806,304 37.281 763.610 726.338 20482896 833,148 1.248.001 415,753 149.90Y6 (1.281.297) 0.00% (806.304) 0.00% (2,087,601) 0.00% Page 23 City of Tukwila Open Space and Parks Acq. Fund 301 Revenue and Expenditures As of June 30, 2009 Revenue General Revenue Property Taxes Sales and Use Taxes Real Estate Excise Taxes Total General Revenue Intergovernmental Revenue Charges for Services Park Impact Fees Total Charges for Services Miscellaneous Revenue Investment Earnings Rents and Concessions Total Miscellaneous Revenue Total Expenditures 31 Office Operating Supplies 41 Professional Services 48 Repairs Maintenance 64 Capital Outlay Total Expenditures Transfers Out__ s Change in Fund Balance Beginning Fund Balance End ,Fund aian ce. 202,000 500,000 702,000 2,728,000 26,609 26,609 78,793 (123,207) 93,660 (406,340) 199,062 (502,938) 123,000 5,319 5,732 123,000 11,051 3, 553,000 917,539' (2,635,461); 1,717 718,000 86,132 40,000 4,009,000 155,808 4,767,000 243,657 58,121 29,075 ::4,825,121: us::272,732 (1,272,121) 644,807 5,267,000 3,946,582 2009 ctuaF ear To= ate) Variance" of Budget 702,095 (2,025,905) 5,331 5,331 5,331 5,331 (117,681) 5,732 (111, 949) 1,717 (631,868) (40,000) (3,853,192) (4,523,343) (29,046) (4,552,389) 1,916,928 (1,320,418) S9948Z_ 4;591;389`:;, 596;510 #DIV /0! 39.01% 18.73% 28.36% 25.74% #DIV /0! #DIV /0! 4.32% #DIV /0! 8.98% 25.82% #DIV /0! 12.00% 0.00% 3.89% 5.11% 50.02% 5.65% 50.69% 74.93% Page 24 City of Tukwila Facility Replacement Fund 302 Revenue and Expenditures As of June 30, 2009 Revenue General Revenue Excise Taxes Total General Revenue Miscellaneous Revenue Investment Earnings Rents and Concessions Total Miscellaneous Revenue Sale of Capital Asse Transfers In Expenditures 11 Salaries 21 FICA 23 PERS 24 Industrial Insurance 25 W1edica|, Dento|, Life, Optical 41 Professional Services 47 Public Utility Services 49 Miscellaneous 64 Capital O tl Change in Fund Balance Beginning Fund Balance r ����r� ��mw, �ef��'���`�'� ��Y6 mf8Udget 100,000 100,000 4,355,000 130,000 25,106 397 397 22 22 31 31 1 1 173 173 280.000 154,840 (105.160) 20.000 3.168 (16,832) 365 365 140.000 24.209 (115,791) 4,165,000 2,124,000 651 651 651 4,086 20,369 24,455 651 (95,914) 20,369 (75,545) (4,355,000) (130,000) (158. (4.323.100) 2.088.875 (35,125) #DK/X}| #DIV/0! 4.09% #DIV/0! 24.46% 0.00% 0.00% 0.55% #DIV/0! #DIV/U| #DIV/0! #DIV/0! #DIV/0! 59.55% 15.84% #DK8O| 17.29% 43.62% -3.80% Page 25 City of Tukwila General Government Improvements 303 Revenue and Expenditures As of June 30, 2009 Revenue General Revenue Sales and Use Taxes Total General Revenue Intergovernmental Revenue Miscellaneous Revenue Investment Earnings Total Miscellaneous Revenue Expenditures 11 Salaries 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Modiuo|, Denta|, Life, Optical 41 Professional Services 49 Miscellaneous 64 CCapital Otl Change in Fund Balance Beginning Fund Balance 294,000 294,000 20,000 30,000 30,000 344,000 .1 189,826 (154,174Y 88.178 48.934 (41,242) 446 446 6.745 3,625 (3. 7.160 3.937 (3,223) 1,385 183 (1.202) 24.109 8.920 (15. 75.000 22.203 (52.797) 24.516 24.516 1.111.000 232,743 8257) (969,575) 1,576,000 162.952 (131.0 162.952 (131.0 23,947 2,927 2,927 (153,681) 796,177 3,947 (27,073) (27,073) 815,894 (779,823) 55.43% 55.43% 119.74% 9.76% 9.76% 55.18% 53.23% #DIV/0! 53.74% 54.99% 13.21% 37.00% 29.60% #DIV/0! 20.95% 26.15% 15.85% 50.52% Page 26 City of Tukwila Fire Impact Fees 304 Revenue and Expenditures As of June 30, 2009 Revenue Charges for Services Fire Impact Fees Total Charges for Services otal Revenue Expenditures 64 Capital Outlay Total Expenses Change in Fund Balance Beginning Fund Balance 3,277 3,277 3,277 3;277. 3,277 3,277 3,277 3,277 3,277$3 #DIV/0 #DIV/0! #DIV/0 #DIV/0! #DIV/0! Page 27 City of Tukwila Water Fund 401 Revenue and Expenditures As of June 30, 2009 Revenue Charges for Services Water Sales Total Charges for Services Intergovernmental Revenue Miscellaneous Revenue Investment Earnings Contributions /Donations Total Miscellaneous Revenue Transfers In a Total Revenu 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 64 Capital Outlay 80 Debt Service Principal 81 Debt Service Interest Total Water Fund 488,640 222,646 (265,994) 45.56% 6,000 41 (5,959) 0.68% 5,517 2,536 (2,981) 45.97% 38,262 17,150 (21,112) 44.82% 40,613 18,716 (21,897) 46.08% 10,885 4,223 (6,662) 38.80% 125,862 64,060 (61,802) 50.90% 1,000 (1,000) 0.00% 1,330 338 (992) 25.41% 91,811 37,035 (54,776) 40.34% 2,185,500 1,245,122 (940,378) 56.97% 4,500 394 (4,106) 8.76% 216,300 70,932 (145,368) 32.79% 2,500 111 (2,389) 4.44% 1,500 1,283 (217) 85.53% 67,145 31,775 (35,370) 47.32% 20,260 19,571 (689) 96.60% 23,000 9,551 (13,449) 41.53% 11,000 4,046 (6,954) 36.78% 7,200 7,489 289 104.01% 184,000 81,706 (102,294) 44.41% 1,114,900 293,528 (821,372) 26.33% 480,059 225,776 (254,283) 47.03% 172,308 86,154 (86,154) 50.00% 5,300,092 2,444,183 (2,855,909) 46.12% Transfers 585,000 292,500 (292,500) 50.00% (3;'148409 46.50% Total e►is g 5,886,09Z:1 2;736:,683 (977,092) (710,918) 266,174 72.76% 4,976,301 5,968,144 991,843 119.93% 99;204; :a ``r 5;257;226 1,25$ Change in Fund Balance Beginning Fund Balance Fli ng Funal Balanc c usted- (Y ear t udget Date) Variance of Budget 4,452,000 1,888,156 (2,563,844) 42.41% 4,452,000 1,888,156 (2,563,844) 42.41% 110,000 (110,000) 0.00% 200,000 17,864 (182,136) 8.93% 50,000 16,785 (33,215) 33.57% 250,000 34,649 (215,351) 13.86% 96,000 102,960 6,960 107.25% 08;0.00 '.2 ,025;765: (2,882;235)': 41.27% 2 Page 28 City of Tukwila Sewer Fund 402 Revenue and Expenditures As of June 30, 2009 Revenue Charges for Services Sewer Sales Total Charges for Services Miscellaneous Revenue Investment Earnings Contributions /Donations 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 33 Metro Treatment Charges 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 64 Capital Outlay 80 Debt Service Principal 81 Debt Service Interest Total Sewer Fund Transfers Out 1To at k ""ens r,^ Change in Fund Balance Beginning Fund Balance Eiidng;Fund Balance 4,830,000 4,830,000 2,378,609 (2,451,391) 2,378,609 (2,451,391) 50,000 1,981 (48,019) 350,000 47,052 (302,948) 400,000 49,033 (350,967) 5,230,000_ 2,427,642 (2,802,358)' 251,424 135,413 8,000 9,276 3,310 1,339 20,099 11,075 21,334 12,086 5,512 2,660 75,756 35,198 1,000 570 77 22,100 9,139 3,572,000 1,817,982 4,000 72 126,600 18,359 2,500 221 500 430 150 90,526 29,890 15,195 14,678 21,000 11,359 43,000 8,195 4,000 1,265 40,000 33,663 452,500 77,562 263,561 227,911 96,302 55,170 5,140,939 2,513,020 (116,011) 1,276 (1,971) (9,024) (9,248) (2,852) (40, 558) (1,000) (493) (12,961) (1,754,018) (3,928) (108,241) (2,279) (70) (150) (60,636) (517) (9,641) (34,805) (2,735) (6,337) (374,938) (35,650) (41,132) (2,627,919) 480,129 240,075 (240,054) 5,621,06$:.' r 2,753;095: (2,867 ,973): (391,068) (325,453) 5,004,365 4,603,192 65,615 (401,173) 4,613,297? .4,277;739 s ;'(335,558); 49.25% 49.25% 3.96% 13.44% 12.26% 46.42% 53.86% 115.95% 40.45% 55.10% 56.65% 48.26% 46.46% 0.00% 13.51% 41.35% 50.90% 1.80% 14.50% 8.84% 86.00% 0.00% 33.02% 96.60% 54.09% 19.06% 31.63% 84.16% 17.14% 86.47% 57.29% 48.88% 50.00% 48.98% 83.22% 91.98% Page 29 City of Tukwila Foster Golf Course 411 Revenue and Expenditures As of June 30, 2009 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 Sale of Capital Assets 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 64 Capital Outlay 80 Debt Service Principal 81 Debt Service Interest Tofaf Expenses ,s ..y... Change in Fund Balance Beginning Fund Balance Fndirig Fund Actual uste `(Yeai -To- udget Date] Variance of Budget 450,000 181,476 (268,524) 40.33% 261 261 #DIV /0! 450,000 181,737 (268,263) 40.39% 170,000 84,058 (85,942) 49.45% 1,310,000 489,152 (820,848) 37.34% 1,480,000 573,210 (906,790) 38.73% 10,000 938 (9,062) 9.38% 316,000 86,028 (229,972) 27.22% 161 161 #DIV /0! 326,000 87,127 (238,873) 26.73% 400 400 #DIV /0! ;251,000'': :s' `.:842;474 (1 :,413,526) 37.34% 604,284 333,392 (270,892) 55.17% 133,900 47,203 (86,697) 35.25% 6,620 1,254 (5,366) 18.94% 56,978 28,500 (28,478) 50.02% 60,478 29,265 (31,213) 48.39% 24,992 7,489 (17,503) 29.97% 148,321 86,475 (61,846) 58.30% 11,000 2,140 (8,860) 19.45% 1,164 110 (1,054) 9.45% 97,000 45,085 (51,915) 46.48% 130,500 66,803 (63,697) 51.19% 2,500 3,139 639 125.56% 9,000 8,228 (772) 91.42% 9,700 5,075 (4,625) 52.32% 1,250 10 (1,240) 0.80% 30,000 15,932 (14,068) 53.11% 125,271 41,948 (83,323) 33.49% 15,195 14,678 (517) 96.60% 64,765 38,381 (26,384) 59.26% 36,000 24,383 (11,617) 67.73% 13,250 6,059 (7,191) 45.73% 6,000 2,846 (3,154) 47.43% 50,000 4,960 (45,040) 9.92% 415,343 11,596 (403,747) 2.79% 310,495 116 (310,379) 0.04% x;;2; 364, 001i,.;.;'',,;::: 125 ;067-: (1,538,939)_! 34.90% (108,006) 17,407 125,413 16.12% 619,534 709,646 90,112 114.55% °.51; 727;053 z 215;5257; 009 Page 30 City of Tukwila Surface Water 412 Revenue and Expenditures As of June 30, 2009 Revenue Charges for Services Surface Water Sales Total Charges for Services Intergovernmental Revenue Miscellaneous Revenue Investment Earnings Total Miscellaneous Revenue `Total�Revenu�' 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 64 Capital Outlay 80 Debt Service Principal 81 Debt Service Interest Total Surface Water Fund Transfers Out {SFr Total Expens es Change in Fund Balance Beginning Fund Balance Ending :.Fund Balance uste udge 2,535,000 1,278,074 2,535,000 1,278,074 75,000 125,000 20,821 125,000 20,821 2, 66.0; 000 642,888 278,886 23,000 10,604 11,205 9,712 51,798 22,595 54,981 24,074 12,522 5,701 201,589 88,071 1,000 1,425 164 40,955 21,198 3,000 282 573,570 288,141 2,000 2,000 1,174 500 548 66,223 27,453 15,195 14,678 61,600 3,134 13,965 80 6,500 4,966 25,000 16,561 857,500 147,186 343,015 317,617 38,139 23,013 3,049,570 1,305,838 361,361 180,700 ';'3; 410;931': `::;1- ;480,538; (750,931) (112,643) 6,152,134 3,407,653 2009, 5 401, 203:;:; 3,295;010 arlance of Budget (1,256,926) (1,256,926) 75,000 (104,179) (104,179) (1,286,105) (364,002) (12,396) (1,493) (29,203) (30,907) (6,821) (113,518) (1,000) (1,261) (19,757) (2,718) (285,429) (2,000) (826) 48 (38,770) (517) (58,466) (13,885) (1,534) (8,439) (710,314) (25,398) (15,126) (1,743,732) (180,661) :(1',924,393Y 638,288 (2,744,481) (2,106,1931 50.42% 50.42% #DIV /0! 16.66% 16.66% 51.65% 43.38% 46.10% 86.68% 43.62% 43.79% 45.53% 43.69% 0.00% 11.51% 51.76% 9.40% 50.24% 0.00% 58.70% 109.60% 41.46% 96.60% 5.09% 0.57% 76.40% 66.24% 17.16% 92.60% 60.34% 42.82% 50.01% 43.58% 15.00% 55.39% Page 31 City of Tukwila Equipment Rental /Replacement Fund 501 As of June 30, 2009 Revenue Charges for Services ERR O &M Dept Charges Equipment Replacement Charges Fuel Sales Total Charges for Services Miscellaneous Revenue Investment Earnings Total Miscellaneous Revenue Sale of Capital Assets ;Total Bever i 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 45 Operating Rentals Leases 46 Insurance 48 Repairs Maintenance 49 Miscellaneous 64 Capital Outlay Total Equipment Rental Fund Transfers Out Tota Ezpens.E Change in Fund Balance Beginning Fund Balance Ending Fuhd Balanc+ Revenue and Expenditures ste udget 1,302,532 583,367 451,000 2,336,899 2 ;Actu ear-To Date 651,000 225,500 876,500 50,000 10,477 50,000 10,477 102,651 2;380899 309,372 152,116 10,000 5,301 1,103 134 24,516 11,786 26,023 13,093 7,756 3,764 93,197 47,958 1,000 950 2,000 929 666,000 202,139 2,500 717 550 81 2,000 584 18,297 10,130 9,785 130,781 21,682 6,500 3,005 608,400 644,356 1,921, 075 1,117,430 192,052 96,050 '213;481:1!! 273,772 (223,852) 5,283,240 3,538,477 Off,0't'2 T' .3,3''14;62 Variance of Budget (651,532) (583, 367) (225, 500) (1,460,399) (39,523) (39, 523) 102,651 (1,397,27'1). (157,256) (4,699) (969) (12,730) (12, 930) (3,992) (45,239) (1,000) (950) (1,071) (463,861) (1,783) (469) (1,416) (18,297) (345) (109,099) (3,495) 35,956 (803,645) (96, 002) (899 ;647.), (497,624) (1,744,763) `$'(2;242;3871 49.98% 0.00% 50.00% 37.51% 20.95% 20.95% #DIV /0! 41.46% 49.17% 53.01% 12.15% 48.07% 50.31% 48.53% 51.46% 0.00% 0.00% 46.45% 30.35% 28.68% 14.73% 29.20% 0.00% 96.59% 16.58% 46.23% 105.91% 58.17% 50.01% 57.43% 81.77% 66.98% Page 32 City of Tukwila Self- Insurance Fund 502 Revenue and Expenditures As of June 30, 2009 Revenue Charges for Services Employee Benefit Programs Total Charges for Services Total Revenue Expenditures 25 Medical, Dental, Life, Optical 41 Professional Services 49 Miscellaneous Change in Fund Balance Beginning Fund Balance 2009 dual usteci.: Y< ,(Y -To- udget: .Date) Variance of Budget 900 265 (635) 29.44% 900 265 (635) 29.44% Miscellaneous Revenue Investment Earnings 25,000 9,963 (15,037) 39.85% Employer Trust Contributions 5,670,686 2,768,037 (2,902,649) 48.81% Employee Contributions 65,000 33,670 (31,330) 51.80% Total Miscellaneous Revenue 5,760,686 2,811,670 (2,949,016) 48.81% (2,949,651): 48.80% 5,199,845 1,967,747 (3,232,098) 37.84% 25,000 8,100 (16,900) 32.40% 20,500 4,772 (15,728) 23.28% .5;245;345 .4,980,619`= (3,264,726): 37.76% 516,241 831,316 315,075 161.03% 1,000,000 1,628,623 628,623 162.86% Endrug; a lance .1,516,241: •2.459,939; 943,698 Page 33 City of Tukwila LEOFF Insurance Fund 503 Revenue and Expenditures As of June 30, 2009 Revenue Miscellaneous Revenue Investment Earnings Employer Trust Contributions Other Misc Revenue [Tatar »ue Change in Fund Balance Beginning Fund Balance Ending und:balance ti Expenditures 25 Medical, Dental, Life, Optical 41 Professional Services 49 Miscellaneous t ro Expe i ...w 3,575 305,081 769 675,119" 309,425 20,000 655,119 652,470 3,000 500 655,970 (16,425) 17.88% (350,038) 46.57% 769 #DIV /0! (365,694):; 45.83% 156,244 (496,226) 23.95% 900 (2,100) 30.00% 501 1 100.20% 157,645 (498,325). 24.03% 19,149 151,780 132,631 792.63% 821,920 945,149 123,229 114.99% 841,069 1`,096;929 25060 Page 34