Loading...
HomeMy WebLinkAboutSpecial 2012-09-19 Report - 2012 2nd Quarter Financial Report2012 2nd Quarter Financial Report Detail to be used with PowerPoint Slides No. 4-8 Prepared 8y: Peggy Mcleod:4 & Ylcky Carlean June 30, 2032 TUKWILA Lir 0 Summary (Cash Basis) City-wide, unreserved fund balances increased $2.573 million in the first half of 2012 from $45.167 million at December 31, 2011 to $47.740 as of June 30, 2012. The governmental funds increased the city-wide fund balance by $1.353 million, the enterprise funds by $844 thousand, and the internal service funds by $376 thousand. Of the governmental funds, the General Fund has increased by $1.452 million during the first half of the year. Further discus- sion on the governmental funds and the General Fund occurs on the following pages. The enterprise funds had a net increase of $5844 thousand primarily due to revenues exceeding expenses and expenses being well under 50% in all funds. Revenue in both the Water Fund and the Golf Course Fund is under budget for the first half of the year due to its cyclical nature but is expected to increase during the summer months. The financial outlook for the City remains stable. However, economic indicators remain mixed. The Washington economy continues to grow at a moderate pace and housing construc- tion is improving, however, unemployment is slightly higher in July than in the previous month indicating that the recovery remains weak. Global issues including the European sover- eign debt and banking crisis continues to pose a substantial risk to our own economy. Nationally, the federal income tax rates will increase in 2013 unless the federal government takes action to reinstate tax cuts that are set to expire at the end of 2012. Any reduction in dis- cretionary income affects consumer spending and thereby sales tax collections for the City. To protect against these financial uncertainties, the City continues to follow conservative fiscal policy. Genera} Fund Hotel/Morel Tax Fund Street Fund Meatal Street Fund Contingency Fund Fire Equip Curn Reserve Drug Seizure Fund Debt Service Funds Perin Acq Fund Fatuity Replacement Fwd General Gov fmproYemente Fire Impact Fee Fund Water Fund Sewer Fwrd Foster Gorr Fund Surface Water Fund Equipment Replacement Fund Self -Insurance Fund LEOFF tirsurance Fund Unreserved/unrestricted Fund Balances*" As of June 30, 2012 FUND BALANCES CHANGE IN FUND BALANCES _s. E CITY-WIDE — ACTUAL — — ACTUAL --- BUDGET — Variance .. 12/31/2011 06/30/2012 'YTD YTD YTD [al IN [5] - [al = [cl [d] [d] - [c] Governmental funds $ 24,804,983 $ 26,158,378 $ 1,353,395 $ 1,249,704 $ 103,691 Enterprise funds 10,225,551 10,759,068 533,511 (1,304,723) $ 1,838234 Internal service funds 10,136,459 10,523,568 387,109 78,341 $ 306,769 City-wide Total $ 45,166,999 $ 47,441,014 $ 2,274,015 $ 23,321 $ 2,250,694 Genera} Fund Hotel/Morel Tax Fund Street Fund Meatal Street Fund Contingency Fund Fire Equip Curn Reserve Drug Seizure Fund Debt Service Funds Perin Acq Fund Fatuity Replacement Fwd General Gov fmproYemente Fire Impact Fee Fund Water Fund Sewer Fwrd Foster Gorr Fund Surface Water Fund Equipment Replacement Fund Self -Insurance Fund LEOFF tirsurance Fund Unreserved/unrestricted Fund Balances*" As of June 30, 2012 7.854,938 S. 51,009 000 52,000 00053,000 000 34,000.005 55,000 000 55,000 000 57,004 000 38.090 000 Inside this issue: Governmental Funds General Fund Revenues General Fund Expenditures 3 3 Enterprise and Internal Service Funds 4 Page 1 of 32 _s. E '.873 5680,102 .. -. '54.341938 _ a= $1,4':,686 84759 5222,1' - B32.830 — - .861 52, 018, 54 1�_� - - - -57,183 .• eimi ,766,404 »ri t� -a .802.596 _ 55,010.1: i iiiiimpts NM 7.854,938 S. 51,009 000 52,000 00053,000 000 34,000.005 55,000 000 55,000 000 57,004 000 38.090 000 Inside this issue: Governmental Funds General Fund Revenues General Fund Expenditures 3 3 Enterprise and Internal Service Funds 4 Page 1 of 32 Governmental Funds Governmental Funds P JND BAL4NCES CHANGE IN FUND BALANCES Variance YID [el -[d] REVENUES AND RPENS ES — ACTUAL — 121311"2011 93/3112012 (a) Ni 0663072012 [c] — ACTUAL — Q2 in id- [b] [c]- la] =[d — BUDGET --, YTD [el Revenues Expenditures Amt %oreudp! limt %afBhot 000 -General Fund S 5,912,116 $ 6,137790 5 7,864,938 S 1,727,148 Si 1,952,822 5 (1,5E3,205) $ 3,516,027 $ 26,336,518 49.40% 524,383,696 43.20% 101-Hio1el7Motel Tax Fund 787,568 $ 496.220 5 562,873 S 66,653 (224,695) (153,801) (70,895) 555,213 44.20% 779,908 49.88% 103 -Street Fund 903,937 960,886 980,102 19,216 76,165 (104,447) 180,612 125,644 27.74% 49,479 7.48% 104 •Arte4al Street Fund 6,929,396 6,882,475 4,341,038 (2,541,437) (2,588,358) 2,691,446 (5,279,804) 1,999,438 9.15% 4,587,796 27,86% 105 • Contingency Fund 1,457,728 1.457 929 1,458,686 757 958 1,500.908 (1,499,950) 958 0.03% - 0.00% 107- Fire Equip Cum Reserve 890,797 884,410 884.759 349 (6,037) 54,562 (70,599] 635 0.48% 6,673 260.57% 109 - Drug Seizure Fund 229,711 226,462 222.196 (4,266) (7,515) 35,500 (43,015) (0) 0.00% 7,515 30.06% 2xx - Debt Service 3,316,312 3,314,752 5,632,830 2,318,078 2,316.518 (142,044) 2,458,562 2,940,539 83.64% 624,021 16.42% 301 -Parks Acq Fund 1,427,973 1,430,473 1,397.981 (32,492) (29,992) (689,383) 659,391 67,089 9.55% 97,081 4.67% 302 - Facility Replacement Fund 2,027,014 2,019,099 2,018.460 (639) (8,554), (41,100) 32.546 1,352 22.81% 9,906 11,24% 303 - General Gov improvements 608,613 633,110 476,837 (156,273) (131,775) (373,784) 242,008 66,400 3.89% 198,175 8.07% 304 - Fire impact Fee Fund 313,819 316591 317,678 1,087 3.859 25,050 (21.191) 3.859 7.70%p 0.00% Total Governmental $24,804,983 $24,760,197 $26,158,378 $ 1,398,181 5 1,353,395 $ 1,249,704 $ 103,691 $ 32,097,644 $30,744,250 Governmental funds first six months activity increased fund balances by $1,353 million. As of the end of June the general fund added $1,953 million in fund balance. Revenues for the General Fund were $26.337 million or 49.9% of budget com- pared to expenditures of $24.384 million or 46.5°a of budget. Highlights for the first quarter include: General Fund • Sales and Use Taxes are slightly above budget due to higher than expected retail sales from the business dis- trict resulting in increased sales tax revenue of 58.3 million compared to the budgeted 58.1 million. • Revenue Generating Regulatory Licenses generated $1.7 million as licenses were renewed for 2012. • Gambling taxes are at 30.1% of the budget. One casino closed after the current biennial budget was adopted. • Penalties/Interest includes 55450 in late fees collected from a vendor that provides solid waste services. • Charges for Services continues to be below budget as. the use of City facilities and services remain low. • Plan check and review fees are below budget. The num- ber of permits issued the first half of the year is similar to last year, however, the value of the permits is signifi- cantly lower. Hotel/Motel--Tourism • Intergovernmental revenue is at 38.49% for the first half of the year. The full amount, 5410,000, owed by the City of Sea Tac will be billed in December. Fire Equipment Reserve Use of Sound Transit Mitigation Funds for the purchase of seven reciprocating saws for apparatus in the amount of 56,392, This expense will be offset at year-end by deferred revenue received several years ago for Sound Transit Mitigation. 201.2 SECOND QUARTER FINANCIAL REPORT Page 2 of 32 General Fund Revenues Revenue $utnmary Q22012 Q22011 Overf(Under) Prior Year [a] - [c] Actual 2012 Budget [a) [b] %of Budget [a] / [b] Actual [c] Property Taxes $ 7,379,666 $ 13,868,250 53.21% $ 7,039,636 $ 340,030 Safes and Use Taxes 8,301,146 15,048,000 55.16% 8,819,372 (518,226) Revenue Generating Regulatory Lics 1,720,437 1,975,000 87,11% 1,397,257 323,180 Utility Taxes 2,137,961 4,840,000 44.17% 2,161,369 (23,408) Interfund Utility Tax 709,314 1,524,000 46.54% 629,480 79,834 Excise Taxes 786,677 2,641,303 29.78% 999,184 (212,507) Business Licenses and Permits 533,465 807,227 66.09% 348,773 1 84,6 92 Building Permits and Fees 475,881 1,058,589 44.95% 54 3,10 0 (67,219) Intergovernmental Revenue 1,617,367 4,144,147 39.03% 1,845,053 (227,686) Transfers In/Indirect Cost Allocation 1,165,332 2,337,077 49.86% 907,096 258,235 General Fund Other 1,509,271 5,073,448 29.75% 1,508,616 655 Totals $ 26,336,518 $ 53,317,041 49.40% $ 26,198,936 $ 230,321 Governmental fund revenues during the f rst half of 2012 are an pace with 2011 with a slight increase of $62,859. Property Tax- es, Revenue Generating Regulatory Licenses, and Business Li- censes and Permits revenue exceeded 2011 revenues by $871 thousand. Offsetting these gains with revenue of 51.17 million lower than 2011, were Sales and Use Taxes, Excise Taxes and Building Permits and Fees. Although Sales and Use Taxes were lower in comparison to the first half of ?011, revenues of $8.3 million are greater than the prorated budget of $7.5 million or 55.16% of budget. General fund expenditures through the first half of the year are 524.384 million or 43.2°o of budget. Department 20 transfers out were 53.055 million for the first half of the year and will contin- ue to be made on an as needed basis during the year. In addition. Salaries and Benefits are slightly lower than budget by 5942,461. Police and Fire contracts were ratified in 3rd quarter and retro payments were made in July. All departments in the General Fund are below budget for the first half of the year. General Fund Expenditures TOTALS BY CATEGORY TRANSFERS OUT SALARIES AND BENEFITS SUPPLIES PROFESSIONAL SERVICES INTERGOVERNMENTAL CAPITAL EXPENDITURES Grand Totals Annual Budget $ 10,364,752 33,702,558 1.193,673 8,180,993 2,694,475 307,000 Expected Budget Actual Spent 56,443,451, Variance %Spent $ 5,182,376 $ 3,054,815 $ (2,127,561) 29.47% 16,851.279 15,908,818 (942,461) 47.20% 596,837 511,898 (84,938) 42.88% 4,090,497 3,837,551 (252,945) 46.91% 1,347,238 1,045,185 (302,053) 38.79% 153,500 25.428 (128,072) 8.28% $ 28,221,726 $ 24,383,698 $ (3,838,030) 43.20% TOTALS - ALL DEPARTMENTS CITY COUNCIL MAYOR HUMAN RESOURCES FINANCE CITY ATTORNEY RECREATION COMMUNITY DEVELOPMENT MUNICIPAL COURT POLICE FIRE INFORMATION TECHNOLOGY PUBLIC WORKS PARK MAINTENANCE STREET MAINTENANCE & OPERATION DEPT 20 TOTAL Annual Budget $ 269.655 2,543,991 573,396 1,603,133 542,734 2,530,147 2.858.579 993,849 14,197,710 10, 308,193 1,153, 947 3,613.803 935,027 2,676,535 11,642,752 $ 56,443,451 Expected Budget $ 134,828 1,271,996 286,698 801,567 271,367 1,265,074 1,429,290 496,925 7,098.855 5,154, 097 576,974 1,806,902 467,514 1,338,268 5,821,376 Actual Spent Valiance %Spent 123,218 1.035,454 258,958 694,101 224,968 1,081,141 1,295,808 491,912 6,744,709 4,932,976 499,022 1,529,998 463,914 1,314,240 3,693,277 $ (11,610) (236,542) (27,740) (107,465) (46, 399) (183,933) (133,482) (5.012) (354,145) (221,121) (77,951) (276,904) (3.599) (24, 028) (2,128, 099) $ 28,221,726 $ 24,383,696 $ 0,838,030) 45.69% 40.70% 45.16% 43.30% 41.45% 42.73% 45.33% 49.50% 47.51% 47.85% 43.24% 42.34% 49.62% 49.10% 31.72% 43.20% 2012 SECOND QUARTER FINANCIAL REPORT Page 3 of 32 Enterprise Funds Fund 401 -Water. The Water fund realized a year-to-date de- crease in fund balance of 5386,511. Water revenue through the second quarter is at 43.81% of budget, but the cost to purchase water is greater than budget by $25,074 or 51.21°Q of budget. Revenue of $1,234,000 from Highiine Water District will be received upon completion of the Southcenter Parkway Extension project. Fund 402 -Sewer. The Sewer fund realized a year-to-date fund balance increase of 8206,632 on sewer revenue of 83,050,178 or 56.51% of budget. A rate increase effective for 2012 is not re- flected in the current budget. Revenues and expenses through the second quarter are 56.19°o and 43.29% respectively. Fund 411 -Golf Course. The Go f Course realized a year-to- date fund balance increase of $65, 33. Revenues and expenses through the second quarter are 39.15'% and 35.39°0 of budget. Charges for services during the first half of the year were 37.67% of budget. Fund 412 -Surface Water. The Surface Water fund realized a year-to-date fund balance increase of $648,255. Revenues and expenses through the second quarter are 51.09°Q and 27.41°0 respectively. Internal. Service Funds INTERNAL SERVICE FUNDS FUND BALANCES CHANGE IN FUND BALANCES ENTERPRISE — ACTUAL — -- ACTUAL - - - --- BUDGET --- Variance FUNDS 12/31/2011 0313112012 0613012012 Q2 YTD YTD YTD 06/30/2012 [a] [b] [c] [c] -no] [c] - [al= [d] [e] [e] - [d] 401 -Water Fund $ 6,043,694 $ 4251,751 $ 5,657,183 $ 1,405,432 $ (386,511) $ (429,797) 5 43,286 402 - Sewer Fund 1,890,166 2,078,188 2,096,798 18,610 206,632 (548,984) 755,616 411 - Foster Golf Fund 140,550 14,771 205,683 190,912 65,133 96,755 (31,621) 412 - Surface Water Fund 2,151,147 3,292,884 2,799,404 (493,480) 648,257 (422,697) 1,070,954 ENTERPRISE FUNDS $10,225,557 $ 9,637,594 $10,759,068 $ 1,121,474 $ 53 11 $ (1,304,723) $ 1,638,234 Fund 401 -Water. The Water fund realized a year-to-date de- crease in fund balance of 5386,511. Water revenue through the second quarter is at 43.81% of budget, but the cost to purchase water is greater than budget by $25,074 or 51.21°Q of budget. Revenue of $1,234,000 from Highiine Water District will be received upon completion of the Southcenter Parkway Extension project. Fund 402 -Sewer. The Sewer fund realized a year-to-date fund balance increase of 8206,632 on sewer revenue of 83,050,178 or 56.51% of budget. A rate increase effective for 2012 is not re- flected in the current budget. Revenues and expenses through the second quarter are 56.19°o and 43.29% respectively. Fund 411 -Golf Course. The Go f Course realized a year-to- date fund balance increase of $65, 33. Revenues and expenses through the second quarter are 39.15'% and 35.39°0 of budget. Charges for services during the first half of the year were 37.67% of budget. Fund 412 -Surface Water. The Surface Water fund realized a year-to-date fund balance increase of $648,255. Revenues and expenses through the second quarter are 51.09°Q and 27.41°0 respectively. Internal. Service Funds INTERNAL SERVICE FUNDS FUND BALANCES CHANGE IN FUND BALANCES Variance YTD — ACTUAL -- -- ACTUAL — — BUDGET --•- 1213112011 03/31/2012 06/30/2012 02 YTD YTD [a] _ [b] [c] [c] - [b) [c] - [a) _ [d] [e) [e] - [di 501 - Equipment Replacement $ 3,523,993 $ 3,653,947 $ 3,802,598 $ 148,651 $ 278,605 $ 336,027 $ (57,422) 502 -Self -Insurance Fund 4,983,480 5,307,419 5,010,123 (297,296) 26,643 (61,237) 107,880 503 - LEQFF Insurance Fund 1,628,986 1,695,503 1,710,848 15,345 81,862 (98,109) 179,971 INTERNAL SERVICE FUNDS $10,138,459 3 10,656,869 $10,523,568 $ (133,301) $ 357,109 $ 156,681 $ 230,428 Fund 501 -Equipment Replacement. Expenses are at 44.48°0 of the annual budget yielding a positive expense budget variance of 8112,066. Fund 502 -Insurance. While employee healthcare costs had been lower than budgeted during the first quarter, claim activity increased significantly during second quarter resulting in a se- cond quarter reduction in fund balance of 8297,296. It should be noted that even with the increase in claims during second quar- ter, year-to-date fund balance has increased $26,643. The year- to-date increase of $26,643 is $141,123 more than the year-to- date projected deficit of $81,237. Fund 503-LEOFF Insurance. Second quarter activity again increased fund balance. The year-to-date increase in fund bal- ance of 581,862 is 5185,347 more than the year-to-date project- ed deficit of 5103,485. Claim activity through 2012 has re- mained consistent and within employer contributions. 20i2 SECOND QUARTER FINANCIAL REPORT Page 4 of 32 City of Tukwila General Fund DOD • Revenue and Expenditures As of June 30 2012 % of year expired 50,00% 2012 Expected Actual Annual Budget Budget Yip ar; o-0ate Variance" % of Annual Budget Revenue General Revenue Property Taxes $ 13,868,250 $ 6,934,125 $ 7,379,666 $ 445,541 53.21% Sales and Use Taxes 16,248,000 8,124,000 8,301,146 177,146 51.09% Revenue Generating Regulatory Lics 1,975,000 987,500 1,720,437 732,937 87.11% Rental housing license 42,750 21,375 33,200 11,825 77.66% Admissions Tax 654,000 327,000 283,836 (43,164) 43.40% Utility Taxes 4,840,000 2,420,000 2,137,961 (282,039) 44.17% Interfund Utility Tax 1,524,000 762,000 709,314 (52,686) 46.54% Excise Taxes 2,641,303 1,320,652 786,677 (533,974) 29.78% LEASE! IOLDJ EX e: - = r:'..>, 139,161 69,581 34,903 (34,677) 25.08% GAMBLING 1TAXES 2,502,142 1,251,071 751,774 (499,297) 30 05' Penattiesltnterest 67 34 5,479 5,445 8177.04% Tota; General Revenue 41,793,370 20,896,685 21,357,716 461,031 51.10% Licenses and Permits Business Licenses and Permits 807,227 403,614 533,465 129,852 66.09% Building Permits and Fees 1,058,589 529,295 475,881 (53,414) 44.95% Total Licenses and Permits 1,865,816 932,908 1,009,346 76,438 54.10% Intergovernmental Revenue 2,944,147 1,472,074 1,617,367 145,293 54,93% Charges for Services General Government 60,951 30,476 23,239 (7,236) 38,13% Security 511,134 255,567 252,311 (3,256) 49,36% Engineering Sen/ices 9,867 4,934 (4,934) 0.D0% Transportation 158,149 79,075 77,741 (1,333) 49.16% Plan Check and Review Fees 858,500 429,250 248,925 (180,325) 29.00% Culture and Rec Fees 611,500 305,750 197,017 (108,733) 32,22% Total Charges for Services 2,210,101 1,105,051 799,234 (305,816) 36,16% Fines and Penalties 213,270 106,635 112,193 5,558 52.61% Miscellaneous Revenue Investment Earnings 133,757 66,879 36,009 (30,869) 26.92% Rents and Concessions 417,203 208,602 208,296 (305) 49.93% Insurance Premiums/Recovery 1,000 500 - (500) 0,00% Contributions/Donations 1,600 800 3 (797) 0.17% Other Misc Revenue 99,200 49,600 31,021 (18,579) 31.27% Total Miscellaneous Revenue 652,760 326,380 275,329 (51,051) 42.18% Sale of Capital Assets 1,300,500 650,250 (650,250) 0,00% Transfers In l Indirect cast allocation 2,337,077 1,168,539 1,165,332 (3,206) 49.86% 7159 Revenue 53,317,041 26,658,521 26,336,518 (322,003) 49..40% Total Expprrd!tures Change in Fund Balance Beginning Fund Balance ,Ending Fund Balance 56,443,451 28,221,726 24,383 696 (3,838,030) 43.20% (3,126,410) (1,563,205) 1,952,822 3,516,027 -62.46% 5,912,116 5,912,116 5,912,116 100,00% 2,785,706 $ 4,348,911 $ 7,864,938 $ 3,516,027 282.33% Cash and investments Cash and investments -- restricted Cash and investments " Variance = Actual over (under) prorated budget $ 4,887,347 $ 4,887,347 Fund 000 Page 5 of 32 CITY OF TUKWILA General Fund Expenditures - By Department As of June 30 2012 0 : SAI L_;L11 Evil um 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 TOTAL 01 - CITY CO1INCIL 11 SALARIES 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 49 MISCELLANEOUS :CITY COUNCIL Annual Budget $ 269,655 2,543,991 573,396 1,603,133 542,734 2,530,147 2,858,579 993,849 14,197,710 10,308,193 1,153,947 3,613,803 935,027 2,676,535 11,642,752 §x,,441451 Expected Budget $ 134,828 1,271,996 286,698 801,567 271,367 1,265,074 1,429,290 496,925 7,098,855 5,154,097 576,974 1,806,902 467,514 1,338,268 5,821,376 $ 28.221.726 Expected - Annual Budget Budget 177,720 13,274 8,016 2,745 20,630 3,870 1,500 4,400 25,000 12,500 Actual''Spent $ 123,218 1,035,454 258,958 694,101 224,968 1,081,141 1,295,808 491,912 6,744,709 4,932,976 499,022 1529,998 463,914 1,314,240 3,693,277 $ 24,383.698 % of year expired 5000` Variance__ %'Spent (11,610) 45.69% (236,542) 40.70% (27,740) 45.16% (107,465) 43.30% (46,399) 41.45% (183,933) 42.73% (133,482) 45.33% (5,012) 49.50% (354,146) 47,51% (221,121) 47.85% (77,951) 43.24% (276,904) 42.34% (3,599) 49.62% (24,028) 49.10% (2,126,099) 31.72% (3.B38.830) 4 .mi Actual Spent Variance % Spent 88,860 90,330 1,470 50.83% 6,637 6,774 137 51.03% 4,008 3,312 (696) 41,32% 1,373 1,025 (347) 37.35% 10,315 10,996 681 5330% 1,935 1,329 (606) 34.34% 750 (750) 0.00% 2,200 1,953 (247) 44.40% 12,500 6,903 (5,597) 27.61% 6,250 595 (5,655) 4.76% 269,655 1.44,828 123,218- ._411610}:_ .. 45:89% " Variance = Actual over (under) prorated budget Fund 000 By Dept Page 6 of 32 CITY OF TUKWILA General Fund Expenditures - By Department As of June 30 2012 3 - NI{tY 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 35 SMALL TOOLS & MINOREQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS & LEASES 4B REPAIRS & MAINTENANCE 49 MISCELLANEOUS 49-00 Miscellaneous 49-01 Memberships, dues, subscriptons 49-02 Microfilm imaging 49-03 Employee recognition 49-04 Recorded documents 49-05 Registrations 49-08 Credit card fees 49-51 CTR reimbursement 49-53 Hearing examiner fees 49-56 Green initiatives 51 INTERGVRNMTL PROFESSIONAL SVCS 64 MACHINERY & EQUIPMENT MAYOR :04 HUMAN RESOURCES 11 SALARIES 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 41 PROFESSIONAL SERVICES 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS & LEASES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS r tuluuw RESOURCES Anndal.Budget 1,001,516 15,500 573 71,953 89,697 4,167 173,067 33,856 4,935 759,470 85,300 19,800 17,250 28,108 14,500 176,799 34,415 40,900 14,300 15,000 4,300 2,500 431 1,000 5.800 58,153 26,500 21,000 215431 E,ic_pact budget 1 of year expired 50.00% Actual Spelt Varlarice % Spent, 500,758 7,750 287 35,977 44,849 2.084 86,534 16,928 2,468 379,735 42,650 9,900 8,625 14,054 7,250 88,400 17.208 20,450 7,150 7,500 2,150 1,250 216 500 2.900 29,077 13,250 10,500 Annual Budget 347,760 25,201 31,151 1,373 56,803 7,103 79.050 2,500 9,000 50 5,405 8,000 460,984 34,872 32,900 1,339 70,057 11,752 304,096 24,840 8,308 2,706 13,238 1,538 67,652 10.404 31,452 4,671 4,000 520 273 5,700 10,633 1,173 1,271,996 1035T454 Expeifd Budget Actual Spent 173,580 12,601 15,576 687 28,402 3,552 39,525 1,250 4,500 25 2,703 4,000 5T3;39B 179,240 13,191 12,755 487 28,259 1,398 14,378 602 5,119 14 (39,774) (7,750) (287) (1,105) (11,949) (745) (16,477) (5,176) (2,468) (75,639) (17,810) (1,592) (5,919) (816) (5,712) (20,747) (6,804) 11,002 (7.150) (2,829) 1.850 (730) 57 5,200 (2.900) (18.444) (12,077) (10,500) ( Variance 5,360 591 (2,820) (200) (142) (2,153) (25,147) (648) 619 (11) (2,703) 3,515 (485) 46.03% 0.00% 0.00% 48.46% 36.68% 32.13% 40.48% 34.71% 0.00% 40.04% 29.12% 41.96% 15.69% 47.10% 10.61% 38.27% 76 90% 0.001 31 14% 93 02% 20.80° 63 24`::. 570.00% 0 00% 18 28% 4.421 0.00% 40.70% 1 Spent 51.54% 52.341 40.95% 35.45% 49,75% 19.68% 18.1��9% 24.09% 56.87% 27.40% 0.00% 43.94% 2584958:� ; :: i =T+7 . 445.161? " Variance = Actual over (under) prorated budget Fund 000 By Dept Pege 7 of 32 CITY OF TUKWILA General Fund Expenditures - By Department As of June 30 2012 ,1Aritg7 ai Bi, T % of year expired k, 50.04% i]f"�ri��ice 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 46 INSURANCE 48 REPAIRS & MAJNTENANCE 49 MISCELLANEOUS 49-00 Miscellaneous 49-08 Credit card lees 64 EXT TAXES & OPERATING ASSESSMENTS 64 MACHINERY & EQUIPMENT 5,000 2,500 €lNeIiNCE_ 1,603,133 801,567 978,689 10,000 1,147 72,356 87,592 4,118 205,614 24,849 190,000 1,000 5,000 5,000 12,768 11.900 868 489,345 5,000 574 36,178 43,796 2,059 102,807 12,425 95,000 500 2,500 2,500 6,384 5,950 434 429,446 5,371 32,843 31,094 1,336 88,812 5,273 81,476 305 673 6,475 352 10,642 6,702 3,940 2 69481'01 (59,898) (5,000) 4,798 (3,335) (12,702) (723) (13,995) (7,151) (13,524) (195) (1,827) 6,475 (2,148) 4,258 752 3,506 2 (2,500) (119/4171) 43138% 43.88% 0.00% 468.27% 45.39% 35.50% 32A4% 43.19% 21.22% 42.88% 30.54% 13.47% 0.00% 7.03% 83.356 56,32-- 453,92 0.00% 0.00% Expected 06 - CITY ATTORNEY Annual Budget Budget Actual Spent Variance % Spent 12 EXTRA LABOR 2,500 1,250 (1,250) 0,00% 21 FICA 795 398 (398) 0.0O% 24 INDUSTRIAL INSURANCE 439 220 (220) 0.00,6 31 OFFICE & OPERATING SUPPLIES 5,000 2,500 2,322 (178) 46.43% 41 PROFESSIONAL SERVICES 528,000 264,000 222,586 (41,414) 42.16% 41-00 Professional services 2,000 1,000 297 (703) 14.85% 41-01 Contracted Attorney services 324,000 162,000 127,259 (34,741) 39.25 11-02 Contracted prosecution service 102,000 51,000 (51,0001 000% 41.03 Special matters 100,000 50,000 95,030 45,030 95.03°i: 42 COMMUNICATION 2,500 1,250 - (1,250) 0.00% 45 OPERATING RENTALS & LEASES 500 250 - (250) 0,00% 48 REPAIRS & MAINTENANCE 2,000 1.000 - (1,000) 0.00% 49 MISCELLANEOUS 1,000 500 60 (440) 6.02% tr 771 rA7TORI1iEY-^. 'S42,734 271,467 - _- _ _ _ -i2088 _- .- 06091 _ -- 1414516 '" Variance = Actual over (under) prorated budget Fund 000 By Dept Page 8 of 32 CITY OF TUKWILA General Fund Expenditures - By Department As of .lune 30 2012 % or year expired 50.00% - , j -7 REC ATI[7�1 ,, s �'.. . "A�7fl aTBUddiet , '1BU ctual,Spe :.« Variance ': r ' :Spe 00 UNALLOCATED BUDGET REDUCTION - 0.00% 11 SALARIES 1,165,454 582,727 592,462 9,735 50.84% 12 EXTRA LABOR 296,627 148,314 101,098 (47,215) 34,08% 13 OVERTIME 600 300 263 (37) 43.85% 21 FICA 130,960 65,480 52,374 (13,106) 39.99% 23 PERS 120,980 60,490 45,673 (14,817) 37.75% 24 INDUSTRIAL INSURANCE 35,855 17,928 12,159 (5,768) 33.91% 25 MEDICAL,DENTAL,LIIFE,OPTICAL 247,844 123,922 119,534 (4,388) 48.23% 31 OFFICE &OPERATING SUPPLIES 81,188 40,594 28,588 (12,006) 35.21% 34 ITEMS PURCH. FOR INVENT/RESALE 14,200 7,100 21,665 14,565 152.57% 41 PROFESSIONAL SERVICES 200,666 100,333 38,081 (62,252) 18.98% 42 COMMUNICATION 27,380 13,690 4,346 (9,344) 15.87% 43 TRAVEL 8,000 4,000 913 (3,087) 11.42% 44 ADVERTISING 21,000 10,500 3,048 (7,452) 14.51% 45 OPERATING RENTALS & LEASES 55,861 27,931 19,228 (8,702) 34.42% 47 PUBLIC UTILITY SERVICES - 51 51 0.00% 48 REPAIRS & MAINTENANCE 32,550 16,275 15,778 (497) 48.47% 49 MISCELLANEOUS 90,982 45,491 25,859 (19,632) 28.42% 49-01 Prinking and binding 35,000 17,500 8,170 (9,331) 23.34% 49-04 Trip admissions Seniors 10,800 5.400 1,347 (4,053) 12.47% 49-05 Trip admissions Youth 12,461 6,230 581 ° (5,649) 4,66% 49-08 Special Accomodations 12,390 6,195 - (6,195) 0.00% other 20,332 10,166 15.762 5,596 77,52% 53 EXT TAXES & OPERATING ASSMNTS - - 20 20 0.001 WREATIO!I 2,53%147 j.1.52651074 1,081 141 maim 421773% PWIrarl r08 COMMUNITY DEVELOPMENT Annual BudgetBudget. Actual Spent Variance % Spent 11 SALARIES 1,783,293 891,647 916,371 24,724 51.39% 12 EXTRA LABOR 38,650 19,325 31,741 12,416 82.12% 13 OVERTIME 4,672 2,336 1,904 (432) 40.76% 21 FICA 133,308 66,654 71,694 5,040 53.78% 23 PERS 160,852 80,426 67,895 (12,531) 42.21% 24 INDUSTRIAL INSURANCE 11,224 5,612 5,969 357 53.18% 25 MEDICAL,DENTAL,LIFE,OPTICAL 275,436 137,718 135,684 (2,034) 49.26% 28 UNIFORM CLOTHING 1.805 903 - (903) 0.00% 31 OFFICE & OPERATING SUPPLIES 34,181 17,091 6,404 (10,687) 18.74% 35 SMALL TOOLS & MINOR EQUIPMENT 600 300 - (300) 0.00% 41 PROFESSIONAL SERVICES 86,283 43,142 6,743 (36,398) 7.82% 42 COMMUNICATION 4,500 2,250 49 (2,201) 1.09% 43 TRAVEL 12,500 6,250 1,073 (5,177) 8.58% 44 RECYCLING - KC WRR - 2 2 0.00% 45 OPERATING RENTALS & LEASES 33,775 16,888 16,908 20 50.061 47 PUBLIC UTILITY SERVICES 1,000 500 - (500) 0.00% 48 REPAIRS & MAINTENANCE 62,190 31,095 8,321 (22,774) 13.381 49 MISCELLANEOUS 21,310 10,655 14,835 4,180 69.62% 51 INTERGVRNMTL PROFESSIONAL SVCS 18,000 9,000 10,214 1,214 56.75% 53 EXT TAXES & OPERATING ASSMNTS - 0 0 0.00% 64 MACHINERY & EQUIPMENT 175,000 87,500 - (87,500) 0.00% ,COMMUNITY;DE11ELOPIMENT „-S858l5 9 1,42%290 II,29 ,8o8 {133.482) 45:33ti6 "" Variance = Actual over (under) prorated budget Fund 000 By Dept Page 9 of 32 CITY OF TUKWILA General Fund Expenditures - By Department As of June 30 2012 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 35 SMALL TOOLS & MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 49-01 Pro Tem Judge 49-03 Interpreters 49-04 Court Security 42 COMMUNICATION 43 TRAVEL 45 OPERATING RENTALS & LEASES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 53 EXT TAXES & OPERATING ASSMNTS NIUNICiPAi. COURT 1 POLICE 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 35 SMALL TOOLS & MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS & LEASES 46 INSURANCE 48 REPAIRS & MAINTENANCE 48-00 Repair and maintenance 48-01 800 MHZ radio assessment 49 MISCELLANEOUS 49-00 Miscellaneous 49-03 Explorer post 51 INTERGVRNMTL PROFESSIONAL SVCS 64 MACHINERY & EQUIPMENT PUCE_ _. ►u;n ,el Utah* 619,552 2,500 5,016 46,849 59,983 3,432 102,906 10,908 1,200 108,000 13,000 53,000 42,000 5,550 6,215 2,300 19,436 99;849 Annual Bridget 7,209,468 5,000 930,062 544,835 325,645 93,745 137,676 1,642,640 156,428 600 48.175 62,031 23,300 800 908,531 225,080 167,894 109,394 58,500 56,245 54,895 1,350 1,639,555 20,000 14,197 7-.10 % of year expired 50.00% 309,776 327,336 17,560 52.83% 1,250 (1,250) 0.00% 2,508 164 (2,344) 3.27% 23,425 24,672 1,247 52.66% 29,992 24,040 (5,951) 40,08% 1,716 1,110 (606) 32.35% 51,453 50,758 (695) 49.32% 5,454 4,069 (1,385) 37.31% 600 (600) 0.00% 54,000 47,165 (6,835) 43.67% 6,500 2,400 (4,100) 18.46% 26,500 27.800 1,300 52.457 21,000 16.965 (4,035) 40.397. 2,775 2,515 (260) 45,32% 3,108 2,718 (389) 43.74% - 392 392 0.00% 1,150 318 (832) 13.81% 9,719 6,654 (3,065) 34.23% - 1 1 0.00% 496,925 (Expected Budget 3,604,734 2,500 465,031 272,418 162,823 46,873 68,838 821,320 78,214 300 24,088 31,016 11,650 400 454,266 112,540 83,947 54,697 29,250 28,123 27,448 675 819,778 10,000 7;09ST855 491,912 Aga) 4940% Actual Spent Variance %Spent 3,392,174 (212,560) 47.05% (2,500) 0.00% 477,189 12,158 51.31% 293,965 21,547 53.95% 173,983 11,160 53.43% 37,491 (9,382) 39.99% 52,162 (16,676) 37.89% 724,590 (96,730) 44.11% 103,654 25,440 66.26% 389 89 64.81% 28,657 4,570 59.49% 28,284 (2,732) 45.60% 26,422 14,772 113.40% (400) 0.00% 426,106 (28,160) 46.90% 225,000 112,460 99.96% 76,963 (6,984) 45.84% 56,429 1,732 51.58% 20,533 (8,717) 35.10% 21,309 (6,814) 37.89% 21,309 (6,139) 38.82% (675) 0.00°� 656,372 (163,406) 40.03% - (10,000) 0.00% 6;744,709 .' Variance = Actual over (under) prorated budget Fund 000 By Dept Page 10 of 32 CITY OF TUKWILA General Fund Expenditures - By Department As of June 30 2012 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 49-00 MiscelIaneous 49-05 Uniform cleaning 49-08 Credit card fees 51 INTERGVRNMTL PROFESSIONAL SVCS 2 - INFORMATION TECHNOLOGY 11 SALARIES 12 EXTRA LABOR. 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 31 OFFICE & OPERATING SUPPLIES 35 SMALL TOOLS & MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 45 OPERATING RENTALS & LEASES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 49-00 Miscellaneous 49-01 Software upgrades 49-03 Training 64 MACHINERY & EQUIPMENT NFORMATIONNtEL`HROLOGY >4iiiiaf E3_gef 6,139,768 416,552 178,248 89,288 264,752 32,766 167,746 1,599,900 1,140 187,080 28,500 65,300 44,670 14,500 489,962 90,000 60,000 41,000 99,601 73,083 26.000 518 285,420 Variance = Actual over (under) prorated budget 0;30x193 AnnuaI Budget 581,079 2,500 44,335 52,041 3,228 135,998 5,766 122,000 1,000 99,000 1,500 1,500 31,500 40,500 35.000 3,000 2,500 32,000 3,069,884 208,276 89,124 44,644 132,376 16,383 83,873 799,950 570 93,540 14,250 32,650 22,335 7,250 244,981 45,000 30,000 20,500 49,801 36,542 13,000 259 142,710 5(0097 Expected Budget 290,540 1,250 22,168 26,021 1,614 67,999 2,883 61,000 500 49,500 750 750 15,750 20,250 17,500 1500 1,250 16,000 % of year expired 50.00% 3,073,449 175,475 47,247 152,418 11,205 60,268 678,554 79,462 26,474 33,876 10,296 1,763 245,916 90,000 36,546 43,521 14,118 13,512 121 485 152,389 0324976 Actual Spent 293,425 469 22,194 21,052 917 64,480 1,597 11,173 54.379 680 770 5,764 9,448 6.560 2,563 325 12,675 3,565 (32,801) (89,124) 2,603 20,042 (5,178) (23,605) (121,396) (570) (14,078) 12,224 1,226 (12,039) (5,487) 935 45,000 6,546 23,021 (35,682) (23,030) (12,879) 226 50.06% 42.13% 0,00% 52.92% 57.57% 34.20% 35,93% 42.41% 0.001 42.47% 92.89% 51.88% 23.05% 12.16% 50.19% 100.00% 60.911 106.15% 14.18% 18.49°. 0.47% 93.701 9,679 53.39% (211274 --- 1:4085%1 Variance % Spent • 2,885 50.50% (1,250) 0.00% 469 0.001 27 50.06% (4,968) 40.45% (697) 28.41% (3,519) 47.41% (1,286) 27.70% (49,827) 9.16% (500) 0.001 4,879 54.93% (70) 45.32% 20 51.32% (9,986) 18.30% (10,802) 23.33% (10,940) 18 74% 1,063 85.44% (925) 13 00% (3,325) 39.61 % 1947 87.6;974 409;422 x61) Fund 000 By Dept Page 11 of 32 CITY OF TUKWILA General Fund Expenditures - By Department As of June 30 2012 '13 - PUBLIC WORKS 11 SALARIES 12 EXTRA LABOR 13 OVERTIME 21 FICA 23 PERS 24 INDUSTRIAL INSURANCE 25 MEDICAL,DENTAL,LIFE,OPTICAL 28 UNIFORM CLOTHING 31 OFFICE & OPERATING SUPPLIES 35 SMALL TOOLS & MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 45 OPERATING RENTALS & LEASES 47 PUBLIC UTILITY SERVICES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 49-00 Miscellaneous 49-08 Credit card fees 49-50 Neighborhood revitaI zat 64 MACHINERY & EQUIPMENT PUBLIC WORKS uffSloi 15- PARK MAI 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 45 OPERATING RENTALS & LEASES 47 PUBLIC UTILITY SERVICES 48 REPAIRS & MAINTENANCE 49 MISCELLANEOUS 63 OTHER IMPROVEMENTS [PINRi.'-'-"TWINTENANCE Annual Budget 1,912,535 3,500 4,556 140,874 171,274 28,420 387,934 3,800 99,460 3,750 70,400 7,750 800 177,745 379,449 165,521 21,035 14,035 2,000 5,000 35,000 3118803 % of year expired 50.00% Expected Budget Actual Spent Variance % Spent Annual Budget 411,432 35,020 2,295 31,000 36,844 10,973 72,300 1,425 36,968 1,500 25,000 70,270 149,000 40,000 4,000 7,000 935,027 956,268 850,434 (105,834) 44.47% 1,750 (1,750) 0.00% 2,278 3,077 799 67.53% 70,437 63,888 (6,549) 45.35% 65,637 60,852 (24,785) 35.53% 14,210 8,792 (5,418) 30.94% 193,967 152,309 (41,658) 39.26% 1,900 205 (1,695) 5.39% 49,730 47,814 (1,916) 48.07% 1,875 1,863 (12) 49.67% 35,200 10,375 (24,825) 14.74% 3,875 1,875 (2,000) 24.19% 400 518 118 64.74% 88,873 77,716 (11,157) 43.72% 189,725 155,397 (34,328) 40.95% 82,761 76,325 (6,436) 46.11% 10,518 5,807 (4,710) 27.61% 7 i`8 2.217 (4,801) 15.79% 1 !"'0 645 (355) 32.27% 2,500 2,945 445 58.91% 12,754 36.44% 1,7892402 1115291-998 (272315 „34% Expected 1111M - Budget Actual Spent Variance % Spent. 205,716 246,142 40,426 59.83% 17,510 - (17,510) 0.00% 1,148 197 (950) 8.59°/° 15,500 18,353 2,853 59.20% 18,422 17,543 (879) 47.61% 5,487 5,743 256 52.34% 36,150 39,101 2,951 54.08% 713 - (713) 0.00% 18,484 23,904 5,420 64.66% 750 382 (368) 25.45% 12,500 10,852 (1,648) 43.41% 98 98 0.00% 35,135 36,018 883 51.26% 74,500 53,760 (20,740) 36.08% 20,000 9,604 (10,396) 24.01% 2,000 2,219 219 55.49% 3,500 - (3,500) 0.00% 467,514 4631,914 (3,599) 49.62 "' Variance = Actual over (under) prorated budget Fund 000 By Dept Page 12 of 32 CITY OF TUKWILA, General Fund Expenditures - By Department As of June 30 2012 B: sti tEETiM141Ni rt -t AffeE,&1 ,ERATON 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 !STREET MAINTENANCE & OPERATION Armful! Budget 776,843 43,723 11,474 58,961 69„571 22,944 181,879 2,375 318,800 10,931 4,000 4,300 2,700 1,500 381,943 35,455 716,836 27,100 5,200 2p6T535 368,766 23,019 13,958 30,986 29,227 9,928 83,147 586 129,802 2,584 731 596 709 361 186,040 35,455 381,570 16,731 30 14 388,422 21,862 5,737 29,481 34,786 11,472 90,940 1,188 159,400 5,466 2,000 2,150 1,350 750 190,972 17,728 358,418 13,550 2,600 1,338.288 % of year expired 50.00% V!ariaiac®: 6 isetit, 1;314,240 (19,656) 47.47% 1,157 52.65% 8,221 121.65% 1,506 52.55% (5,558) 42.01% (1,544) 43.27% (7,793) 45.72% (601) 24.69% (29,598) 40.72% (2,881) 23.64% (1,269) 18.27% (1,554) 13.85% (641) 26.27% (389) 24.05% (4,931) 48.71% 17,728 100.001 23,152 53.23% 3,181 61.74% (2,570) 0.581 0.00% (24,042) 49.101' 20.T CONTRIBL77 ONS f F!]ND BALANCE Annual Budget Expacka' - Budget Actual Spent Varfa Spent 01 TRANSFERS OUT 26 UNEMPLOYMENT COMPENSATION 46 INSURANCE 49 MISCELLANEOUS 49-00 Miscellaneous 49-01 Repair and demolition (building abatement) 49-03 Claims and judgments 49 MISCELLANEOUS CONTRIBUTIONS !FUND BALANCE 10,364,752 30,000 200,000 323,000 3.000 50.000 270,000 725,000 '" Variance = Actual over (under) prorated budget 11,6.44752 5,182,376 15,000 100.000 161,500 1,500 25,000 135,000 362,500 5;8,,,21;,376. 3,054,815 11,537 222,738 179,187 179,187 225,000 (2,127,561) (3,463) 122,738 17,687 (1,500) (25,000) 44,187 (137,500) 29.47% 38.46% 111.37% 55.48% 4.00% 0.00% 66.37% 31.03% Fund 000 By Dept Page 13 of 32 CITY OF TUKWILA General Fund Expenditures - By Category As of June 30 2012 ° of year expired 50.009 d?AIS BY CATEGORY Expected Annual Budget Budget Actual Spent Variance %Spent TRANSFERS OUT SALARIES AND BENEFITS SUPPLIES PROFESSIONAL SERVICES INTERGOVERNMENTAL CAPITAL EXPENDITURES .Grand Totals $ 10,364,752 33,702,558 1,193,673 8,180,993 2,694,475 307,000 $ 5,182,376 16,851,279 596,837 4,090,497 1,347,238 153,500 $ 56,443,451 $ 28221,726 $ 3,054,815 15,908,818 511,898 3,837,551 1,045,185 25,428 $ (2,127,561) (942,461) (84,938) (252,945) (302,053) (128,072) 24,383,696 $ (3.838,030) 29.47% 47.20% 42.88% 48.91% 38.79% 8.28% 43.20% TOTALS BY CATEGORY -- DETAIL Annual Budget Expected Budget Actual Spent Variance % Spent 00 MISCELLANEOUS GENERAL GOVERNMT 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 52 INTERGVRNMTL PROFESSIONAL SVCS 53 EXT TAXES & OPERATING ASSMNTS 63 OTHER IMPROVEMENTS 64 MACHINERY & EQUIPMENT Grand Totals $ 10,364,752 23,105,109 455,520 1,376,947 178,248 1,403,989 590,397 1,014,512 434,340 5,102,951 30,000 10,545 1,005,457 14,200 174,016 2,166,844 348,381 121,815 49,550 2,148,245 550,535 1,306,285 596,960 892,378 1,969,475 725,000 $ 5,182,376 11,552,555 227,760 688,474 89,124 701,995 295,199 507,256 217,170 2,551,476 15,000 5,273 502,729 7,100 87,008 1,083,422 174,191 60,908 24,775 1,074,123 275,268 653,143 298,480 446,189 984,738 362,500 7,000 3,500 300,000 150,000 58.443.451 4 28,221,726 "' Variance = Actual over (under) prorated budget $ 3,054,815 11,220,557 155,857 678,067 713,053 326,401 395,039 161,235 2,246,280 11,537 791 447,368 21,665 42,865 799,015 129,438 51,380 11,235 1,022,345 579,668 627,324 255,213 361,933 820,148 225,000 37 25,428 $ (2,127,561) (331,998) (71,903) (10,407) (89,124) 11,059 31,202 (112,217) (55,935) (305,195) (3,463) (4,481) (55,361) 14,565 (44,143) (284,407) (44,753) (9,528) (13,540) (51,778) 304,401 (25,818) (43,267) (84,256) (164, 590) (137,500) 37 (3,500) (124,572) 24,383,896 3 838,030 29.47% 48.56% 34.22% 49.24% 0.00% 50.79% 55.28% 38.94% 37.12% 44.02% 38.46% 7.50% 44.49% 152.57% 24.63% 36,87% 37.15% 42.18% 22.67% 47.59% 105.29% 48.02% 42.75% 40.56% 41.64% 31.03% 0.00% 0.000 8.48% 43.20,% Fund 000 By Category Page 14 of 32 City of Tukwila Hotel/Motel Tax Fund 101 - Revenue and Expenditures As of June 30 2012 % of year expired 50.00% 2012 Annual Budget Expected Budget Actual Year -To -Date Valiance** % of Annual Budget Revenue General Revenue Hotel/Motel Taxes Total General Revenue Intergovernmental Revenue Miscellaneous Revenue Investment Eamings Other Misc Revenue Total Miscellaneous Revenue $ 385,401 $ 192,701 385,401 853,000 1,766 15,953 17,719 192,701 426,500 883 7,977 8,860 $ 219,130 219,130 328,331 292 7,459 7,751 $ 26,430 56.86% 26,430 56.86% (98,169) 38.49% (591) 16.55% (518) 46.75% (1,108) 43.74% Total Revenue 1,256,120 628,060 555,213 (72,847) 44.20% Expenditures 11 Salaries 12 Extra Labor 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 31 Office & Operating Supplies 41 Professional Services 42 Communication 43 Travel 44 Advertising 45 Operating Rentals & Leases 47 Public Utility Services 48 Repairs & Maintenance 49 Miscellaneous 64 Capital Outlay Total Hotel/Motel Tax Fund Transfers Out / Indirect cost allocation 'Tota/ F"'"e ditures Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments 283,378 24,000 10,110 21,679 25,380 2,033 38,304 16,000 223,000 60,000 23,000 657,000 49,000 1,500 1,000 21,400 10,000 1,466,784 96,937 1,563,721 (307,601) 787,568 141,689 12,000 5,055 10,840 12,690 1,017 19,152 8,000 111,500 30,000 11,500 328,500 24,500 750 500 10,700 5,000 733,392 48,469 781,861 (153,801) 787,568 141,650 10,338 5,582 11,934 11,096 638 19,645 18,353 74,797 44,090 7,589 336,831 20,986 428 396 27,086 731,439 48,468 779,908 (224,695) 787,568 (40) 49.99% (1,662) 43.08% 527 55.22% 1,095 55.05% (1,594) 43.72% (379) 31.37% 493 51.29% 10,353 114.70% (36,703) 33.54% 14,090 73.48% (3,911) 33.00% 8,331 51.27% (3,514) 42.83% (322) 28.56% (104) 39.56% 16,386 126.57% (5,000) 0.00% (1,953) 49.87% (0) 50.00% (1,953) 49.88%0 (70,895) 73.05% 100.00% 479,967 633,768 $ 562,873 $ (70,895) 117.27% .. Variance = Actual over (under) prorated budget $ 440,145 Fund 101 Page 15 of 32 City of Tukwila Street Fund 103 - Revenue and Expenditures As of June 30 2012 % of year expired 50.00%4 2012 Expected Actual %ofAnnual Annual Budget Budget Year=foliate Variance "TM Budget Revenue Intergovernmental Revenue (MVFT Taxes) $ 232,000 $ 116,000 $ 125,039 9,039 53.90% Miscellaneous Revenue Investment Earnings 1,000 500 605 105 60.47% Total Miscellaneous Revenue 1,000 500 605 105 60.47% Transfers In 220,000 110,000 (110,000) 0.00% TotalRevenue 453,000 226,500 125,644 (100,656) 27.74% Expenditures i 1 Salaries 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 41 Professional Services Total Transfers Out / Indirect cost allocation Total Expenditures Change in Fund Balance Beginning Fund Balance 2,170 2,170 0.00% 159 159 0.00% 156 156 0.00% 6 6 0.00% - - 204 204 0.00% 650,000 325,000 40.838 (284,162) 6.28% 650,000 325,000 43,532 (281,468) 6.70% 11,894 5,947 5,947 0 50.00% 661,894 330,947 49,479 (281,468) 7A8% (208,894) (104,447) 76,165 180,612 -36.46% 903,937 903,937 903,937 - 100.00% 895,04 A_____711_4_,949-0 980 902A80,612 14%0e% Cash and investments $ 938,114 " Variance = Actual over (under) prorated budget Fund 103 Page 16 of 32 City of Tukwila Arterial Street Fund 104 - Revenue and Expenditures As of June 30 2012 % of year expired 50.00% 2012 Expected Actual Annual Budget Budget Year -To -Date Variance" Vo ofHuai Budget Revenue General Revenue Parking Taxes 111,257 55,629 72,646 Real Estate Excise Taxes 100,000 50,000 34,429 (15,571) 34,43% Total General Revenue 211,257 105,629 107,075 1,446 50.68% 17,017 65.30% Intergovernmental Revenue 9,941,581 4,970,791 1,858,583 (3,112,207) 18.70% Miscellaneous Revenue Investment Earnings 3,820 1,910 17,605 15,695 460.85% Contributions/Donations 466,000 233,000 16,175 (216,825) 3.47% Total Miscellaneous Revenue 469,820 234,910 33,780 (201,130) 7.19% Transfer In 2,000,000 1,000,000 (1,000,000) 0,00% Debt Proceeds 9,230,000 4,615,000 (4,615,000) 0,00% :Revenue 21,852,658 10,926,329 1,999,438 (8,926,891) 9.15% Expenditures 11 Salaries 207,768 103,884 217,766 113,882 104,81% 12 Extra Labor 3,000 1,500 (1,500) 0.00% 13 Overtime - 3,548 3,548 0,00% 21 FICA 15,417 7,709 16,621 8,913 107.61% 23 PERS 18,606 9,303 15,834 6,531 65.10% 24 Industrial Insurance 686 343 1,438 1,095 209.62% 25 Medical, Dental, Life, Optical 27,727 13,864 34,357 20,493 123,91% 31 Office & Operating Supplies - - 340 340 0.00% 35 Small Tools & Minor Equipment - - - 0.00% 41 Professional Services 4,589,000 2,294,500 949,540 (1,344,960) 20.69% 43 Travel - - 10 10 0:00% 44 Advertising 2,245 2,245 0.00% 45 Operating Rentals & Leases 1,011 1,011 0,00% 47 Public Utility Services 750 750 0.00% 48 Repairs & Maintenance 92,472 92,472 0.00% 49 Miscellaneous - 722 722 0.00% 64 Capital Outlay 11,221,000 5,610,500 3,057,611 (2,552,659) 27.25% Total Arteria! Streets 104 16,083,204 8,041,602 4,394,514 (3,647,088) 27.32% Transfers Out I Indirect cast allocation 386,563 193,282 193,281 (0) 50.00% Total Expenditures 18,469,767 8,234,8.84 4,587,796 (3,6474088) 27.86% Change in Fund Balance 5,382,891 2,691,446 (2,588,358) (5,279,803) -48.08% Beginning Fund Balance 6,929,396 6,929,396 6,929,396 - 100.00% Ending Fund Balance $ 42;31 287. $ 9,620,842 • $ 4,341,038 $ (5,279,803) - 35.26% Cash and investments **Variance = Actual aver (under) prorated budget 2,055,132 Fund 104 Page 17 of 32 City of Tukwila Contingency Fund 105 - Revenue and Expenditures As of June 34 2012 2012 %e of year expired 50.00% Expected Actual % of Annual _Annual Budget Budget Year -To -Date iVadance `° Budget Revenue Miscellaneous Revenue Investment Earnings $ 1,816 $ 908 $ 958 $ 50 Total Miscellaneous Revenue 1,816 908 958 50 Transfers In 3400,000 1,500,000 (1,500,000) Total Revenue Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments 52.74% 5274% 0.00% 3,001,818 1,500,908 958 (1,499,950) 0.03%1 3,001,816 1,500,908 958 (1,499,950) 1,457,728 1,457,728 1,457,728 $ 4,459,5442,==.$ 2,958,636 $ 1,L58,656 - $ 0,499,950) 1,458,686 0.03% 100.00% -332.71% " Variance =- Actual over (under) prorated budget Fund 105 Page 18 of 32 City of Tukwila Fire Equipment Cum. Reserve 107 - Revenue and Expenditures As of June 30 2012 % of year expired 50.00% 202 Expected Actual % of Annual Annual Budget Budget Year -To -Date Variance" Budget Revenue Miscellaneous Revenue Investment Earnings $ 1,685 $ 843 $ 620 $ (222) Total Miscellaneous Revenue 1,685 843 635 (207) Transfers In 130,000 65,000 (65,000) Total Revenue 131,685 65,843 635 (65,207) Expenditures 31 Office & Operating Supplies 2,000 1,000 6,393 5,393 Transfers Out / Indirect cost allocation 561 281 281 - Top/ ,Expenclftures 2,561 1,281 6,673 5,393 Change in Fund Balance 129,124 64,562 (6,036) (70,600) Beginning Fund Balance 890,797 890,797 890,797 FndYr Funaf.`,Balairce $ 1,019,921 $ 955,359 5 884,758 $ (70,600) Cash and investments $ 943,650 " Variance = Actual over (under) prorated budget 36.61% 37.70% 0.00% 0.48% 319.63% 50.00% 260.57% -4.68% 100.00% 86.75% Fund 107 Page 19 of 32 City of Tukwila Drug Seizure Fund 109 - Revenue and Expenditures As of June 30 2012 % of year expired 50.00% 2012 i4rfiniial'Bs>Itlge _ ' u"dget Year To ?ete Varlance'' Revenue Miscellaneous Revenue Investment Eamings Seizure Revenue Total Miscellaneous Revenue Transfers In Total Revenue Expenditures 31 Office & Operating Supplies 35 Small Tools & Minor Equipment 41 Professional Services 45 Operating Rentals & Leases 49 Miscellaneous 64 Capital Outlay r`fofal 1 irpendkules Change in Fund Balance Beginning Fund Balance �Er ding and E alanice Cash and investments 1,000 20,000 21,000 $ 500 $ (0) $ (500) -0.01% 10,000 - (10,000) 0.00% 10,500 (0) (10,500) 0.00% 75,000 37,500 (37,500) 0.00% 96,000 48,000 ;(0) (48,000) 0.00% 3,000 1,500 719 (781) 23.96% - - 1,639 1,639 0.00% 10,000 5,000 - (5,000) 0.00% 10,000 5,000 - (5,000) 0.00% 2,000 1,000 600 (400) 30.00% - - 4.557 4,557 - 25,000 71,000 229,711 $ , 265211 42,500 -7,515 (4;985) 30.08% 35,500 (7,515) (43,015) -10.58% 229,711 229,711 100.00% 222,196 . 3,0 5)✓ 73.89% $ 222,196 " Variance = Actual over (under) prorated budget Fund 109 Page 20 of 32 City of Tukwila Debt Service Funds 2XX - Revenue and Expenditures As of June 30 2012 % of year expired 50.00% 2012 Expected Actual Annual Budget Budget Year -To -Date Variance" of Annual Budget Revenue Intergovernmental Revenue 66,657 33,329 33,329 (33,328) 50.00% Miscellaneous Revenue Investment Earnings $ 3,000 $ 1,500 $ 14,125 $ 11,125 470.85% Debt proceeds - - - - 0.00% Total Miscellaneous Revenue 3,000 1,500 14,125 11,125 470.85% Transfers In 3,446252 1,723,126 2,693,085 1,169,959 83.95% Total Revenue 3,515,909 1,757,955 2,940,539 1,147,756 83.64% Expenditures 80 Debt Service Principal 81 Debt Service Interest Total Debt Service Funds Transfers tut f Indirect cost allocation Total Expenditures 2,633,458 1,316,729 - (1,316,729) 1,166,538 583,269 624,021 40,752 3,799,996 1,899,998 0.00% 53.49% 624,021 (1,275,977) 16.42% 3,799,996 1,899,998 624,021 (1,275,977) Change in Fund Balance (284,087) (142,044) 2,316,518 Beginning Fund Balance 3,316,312 0.00% 16.42% 2,458,561 -515.43% 3,316,312 0.00% E%#rig Fund Balance (284,087) $ (142,044) $ 5,632,830 $ 5,774,873 -1982.78% Cash and investments $ 5,686,409 " Variance = Actual over (under) prorated budget Fund 2XX Page 21 of 32 City of Tukwila Open Space and Parks Acq. Fund 301 - Revenue and Expenditures As of June 30 2012 ° of year expired 50.00% 2012 Expected Actual Annual Budget Budget Year -To -Date Variance"' % of AnnuaI Budget Revenue General Revenue Property Taxes $ 65,000 $ 32,500 $ 22,733 $ (9,767) 34.97% Real Estate Excise Taxes 100,250 50,125 34,546 (15,579) 34,46% Total GeneralRevenue 165,250 82,625 57,279 (25,346) 34.66% Charges for Services Park Impact Fees 25,000 12,500 4,986 (7,514) 19.95% Total Charges for Services 25,000 12,500 4,986 (7,514) 19,95% Intergovernmental Revenue 500,000 250,000 (250,000) 0.00% Miscellaneous Revenue Investment Earnings 7,000 3,500 1,080 (2,420) 15.43% Rents and Concessions 5,000 2,500 3,743 1,243 74.86% Total Miscellaneous Revenue 12,000 6,000 4,824 (1,176) 40.20% • rt NeRevenue 702,250 0 351,125 0 67,039 0 (284,036) 9.55% Expenditures 11 Salaries 6,781 6,781 C1.00% 21 FICA 503 503 0.00% 23 PERS 485 485 0.00% 24 Industrial insurance 18 18 0.00% 25 Medical, Dental, Life, Optical - 1,041 1,041 0.00% 31 Office & Operating Supplies 2,248 2,248 0.00% 41 Professional Services 239,000 119,500 47,608 (71,892) 19,92% 44 Advertising 865 865 0.00% 46 Repairs & Maintenance 17,782 17,782 0.00% 64 Capital Outlay 1,810,000 905,000 3,742 (901,258) 0.21% Total Park Acquisition Fund 2,049,000 1,024,500 81,073 (943,427) 3.96% Transfers Out / indirect cost allocation 32,016 16,008 16,008 50.00% Total Expenditures 2,081,016 1,040,508. 97,081 (943,4271, 4.67°% Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments (1,378,766) (689,383) (29,992) 659,391 2.18% 1,427,973 1,427,973 1,427,973 100.00% $ 49,207 S 738,590 1397,981 _ 659,391 2841.02% Variance = Actual aver )under) prorated budget 1,633,257 Fund 301 Page 22 of 32 City of Tukwila Facility Replacement Fund 302 - Revenue and Expenditures As of June 30 2012 % of year expired 50.00% 20fl Expected Annual Budget Budget A76117131 V, ar;,Tatate Variance"* % of Annual Budget Revenue Charges for Services Sales and Use Taxes Total Charges for Services Miscellaneous Revenue Investment Earnings Total Miscellaneous Revenue $ 326 $ 163 $ 25 $ (138) 326 163 25 (138) 5,602 2,801 1,326 (1,475) 5,602 2,801 1,326 (1,475) 7.62% 7.82% 23.68% 23.68% Total Revenue 5,928 2,964 1!352 (,1,612) 22.81% Expenditures 11 Salaries 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 41 Professional Services 47 Public Utility Services Total Expenditures Transfers Out / Indirect cost allocation Total Expenditures Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments 14,000 87,000 1,127 88,,127 (82,199) 2,027,014 7,000 43,500 564 44,064 (41,100) 2,027,014 239 18 17 1 10 5,125 3,932 9,342 564 9,906 (8,554) 2,027,014 239 18 17 1 10 (1,875) 3,932 (34,158) 0 (34,158) 32,546 0.00% 0.00% 0.00% 0.00% 0.00% 36.51% 0.00% 10.74% 50.00% 11.24% 10.41% 100.00% 1,944815 $ 1,985;915 $ 2,018,460 32,546 103.79% ." Variance = Actual aver (under) prorated budget $ 2,018,535 Fund 302 Page 23 of 32 City of Tukwila General Government improvements 360 - Revenue and Expenditure_ As of June 30 2012 % of year expired 50.00% 2012 Expected Actual % of Annual Annual Budget Budget Year -To -Date Variance'* Budget Revenue Intergovernmental Revenue $ 58,077 $ 29,039 $ 66,056 $ 37,018 113.74% Miscellaneous Revenue Investment Earnings 842 421 343 (78) 40.77% Total Miscellaneous Revenue 842 421 343 (78) 40.77% Transfers In 1,650,000 825,000 (825,000) 0.00% PTotalRevenue, 1,708,919. ,854,460 _ 66,400 (788,060) 3.89% Expenditures 11 Salaries 97,296 48,648 23,557 (25,091) 24.21% 13 Overtime 343 343 0.00% 21 FICA 7,819 3,910 1,789 (2,121) 22.88% 23 PERS 8,800 4,400 1,698 (2,702) 19.30% 24 Industrial insurance 1,100 550 376 (174) 34.16% 25 Medical, Dental, Life, Optical 14,798 7,399 3,937 (3,462) 26.60% 31 Office & Operating Supplies - 5,692 5,692 0.00% 35 Small Tools & Minor Equipment - - 4,930 4,930 0.00% 41 Professional Services 440,000 220,000 80,412 (139,588) 18.28% 44 Advertising - - 1,145 1,145 0.00% 48 Repairs & Maintenance 37,474 37,474 0.00% 49 Miscellaneous - - 5,057 5,057 0.00% 64 Capital Outlay 1.860,000 930,000 18.430 (911,570) 0.99% Total Fire Impact Fees 2,429,813 1,214,907 184,839 (1,030,068) 7.61% Transfers Out / Indirect cost allocation 26,673 13,337 13,337 50.00% T'otat Expertlttrires _ 2,456,486 1,228,243 1.98175 (1,030,068 8.07% Change in Fund Balance (747,567) (373,784) (131,776) 242,008 17.63% Beginning Fund Balance 608,613 608,613 608,613 - 100.00% E►rdtng Funil Balance '$ (138,954) Cash and investments 476,837 $ 242,008 -343.16% $ 234,830 433,659 " Variance = Actual over (under) prorated budget Fund 303 Page 24 of 32 City of Tukwila Fire Impact Fees 304 - Revenue and Expenditures As of June 30 2012 of year expired 50.00% 2012 Expected AZIMI Annual Budget Budset Year -To -Date Variance** % of Annual Budget Revenue Charges for Services Fire Impact Fees $ 50,000 $ 25,000 $ 3,694 $ (21,306) 7.39% Total Charges for Services 50,000 25,000 3,694 (21,306) 7.39% Investment Earnings Tata! Miscellaneous Revenue 100 50 164 114 100 50 164 114 164.48% 164.48% Total Revenue 50,100 25,050 3,859 (211191) 7.70% Expenditures 64 Capital Outlay To fel Expenditures 0.00% 0.00% Change in Fund Balance 50,100 25,050 3,859 (21,191) 7.70% Beginning Fund Balance 313,819 313,819 313,819 - 100.00% Ending Fund Balance $ 363,919 $ 338,869 $ 317,678 $ (21,191) 87.29% Cash and investments " Variance = Actual over (under) prorated budget $ 317,677 Fund 304 Page 25 of 32 City of Tukwila Water Fund 401. Revenue and Expenses As of June 30 2012 % of year expired 50.00% 2012 Annual Budget Expected Actual Budget Year -To -Date 1Ja a D Revenue Charges for Services Water Sales Security Total Charges for Services Miscellaneous Revenue Investment Earnings Connection fees Other Misc Revenue Total Miscellaneous Revenue Transfers In hydrant rental Tolearlarrinue Expenses 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 / Indirect cost allocation Total Expenses Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments 5,041,000 $ 2,520,500 1,000 500 5,042,000 9,234 25,000 300 34,534 106,000 5,ri182,534 556,692 6,000 5,738 42,472 49,851 14,137 113,690 1,000 1,330 93,181 2,068,000 9,500 314,300 2,500 1,500 60,919 20,260 23,000 3,000 14,811 184,000 517,000 1,287,000 128,881 5,989 5,524,751 517,377 6,042128 (859,594) 6,043,694 2,521,000 4,617 12,500 150 17,267 53,000 2,591,267 276,346 3,000 2,869 21,236 24,926 7,069 56,845 500 665 46,591 1,034,000 4,750 157,150 1,250 750 30,460 10,130 11,500 1,500 7,406 92,000 258,500 643,500 64,441 2,995 2,762,376 258,689 3,021,064 (429,797) 6,043,694 $ 2,208,238 $ (312,262) 43.81% 60 (440) 6.00% 2,208,298 5,376 2,399 80 7,855 49,230 2,265,383 272,001 3,680 20,980 19,711 5,591 60,439 205 57,335 1,059,074 5,848 47,738 302 1,304 30,425 20,260 8,444 2,624 21,636 83,698 220,990 65,012 310,000 75,909 2,393,205 258,689 2,651,894 (386,511) 6,043,694 (312,702) 43.80% 759 58.22% (10,101) 9.59% (70) 26.67% (9,412) 22.75% (3,770) 46.44% (325,884) 43.71& (6,345) 48.86% (3,000) 0.00% 811 64.13% (256) 49.40% (5,214) 39.54°/0 (1,477) 39.55% 3,594 53.16% (500) 0.00% (460) 15.41% 10,744 61.53% 25,074 51.21% 1,098 61.56% (109,412) 15.19% (948) 12.07% 554 86.93% (34) 49.94% 10,130 100.00% (3,056) 36.71% 1,124 87.46% 14,230 146.0894 (8,302) 45.4994 (37,510) 42.74%4 (578,488) 5.054/4 245,560 240.53%4 72,914 1267.47%4 (369,170) 43.32%4 50.00% (369M0) 43.89% 43,286 44.96%4 (0) 100.00% S 5484,100 $ 5,613,897 5,657,183 , $ 43,286 109.13% "" Variance = Actual over (under) prorated budget 3.982,420 Fund 401 Page 26 of 32 City of Tukwila Sewer Fund 402 - Revenue and Expenses As of June 30 2012 % of year expired 50.00% 20Lt2 Evaded Annual Budget Budget .Actual Year -To -Date Variance' of Annual. Budget Revenue Charges for Services Sewer Sales Total Charges for Services Miscellaneous Revenue Investment Earnings Connection fees Total Miscellaneous Revenue r ral Revenue Expenses 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 Sewage Treatment 35 Small Tools & Minor Equipment 41 Professional Services 42 Communication 43 Travel 44 Advertising 45 Operating Rentals & Leases 46 Insurance 47 Public Utility Services 48 Repairs & Maintenance 49 Miscellaneous 53 Excise Taxes 54 Interfund utility tax 64 Capital Outlay 80 Debt Service Principal 81 Debt Service Interest Total Sewer Fund Transfers Out/Indirect cost allocation TotalEnses____. Change in Fund Balance Beginning Fund Balance Ending _tuiHiIBalance Cash and investments $ 5,398,000 5,398,000 4,426 120,000 124,426 $ 2,699,000 $ 3,050,178 $ 351,178 2,699,000 2,213 60,000 62,213 3,050,178 1,224 34,200 35,424 351,178 (989) (25,800) (26,789) 56.51% 56.51% 27.65% 28.50% 28.47% 5,522,426 2,761,213 3,1031 27 341,914 56.19% 267,360 8,000 3,442 20,338 23,943 6,156 50,356 1,000 570 22,491 3,749,000 4,000 161,600 2,500 500 150 124,415 15,195 22,050 43,000 8,799 40,000 543,000 770,000 272,861 12,688 6,173,414 133,680 4,000 1,721 10,169 11,972 3,078 25,178 500 285 11,246 1,874,500 2,000 80,800 1,250 250 75 62,208 7,598 11,025 21,500 4,400 20,000 271,500 385,000 136,431 6,344 3,086,707 157,587 1,050 2,072 12,185 11,412 2,512 29,996 9,271 1,627,763 670 11,069 783 297 61,208 15,195 12,542 21,010 18,890 36,221 305,068 316,152 20,049 2,673,005 23,907 58.94% (2,950) 13.13% 351 60.21% 2,016 59.91% (559) 47.66% (566) 40.80% 4,818 59.57% (500) 0.00% (285) 0.00% (1,975) 41.22% (246,737) 43.42% (1,330) 16.76% (69,731) 6.85% (467) 31.33% 47 59.42% (75) 0.00% (1,000) 49.20% 7,598 100.00% 1,517 56.88% (490) 48.86% 14,491 214.69% 16,221 90.55% 33,568 56.18% (68,848) 41.06% (136,431) 0.00% 13,705 158.02% (413,702) 43.30% 446,980 223,490 223,490 (0) 50.00% 6,620,394 3,310,197 2,896,495 (413,702) 43.75% (1,097,968) (548,984) 206,632 755,616 -18.82% 1,890,166 1,890,166 1,890,166 0 100.00% 792,198 S '111 62. $ 2,098,798 S 755,616 264.68% Variance = Actual over (under) prorated budget $ 1,238,090 Fund 402 Page 27 of 32 City of Tukwila Foster Golf Course 411- Revenue and Expenses As of June 30 2012 % of year expired 50.00% 2012 Expected Annual Budget Budget Actual Year -To -Date Variance " % of Annual Budget Revenue General Revenue 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 Transfers In Total Revenue Expenses 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 1 Indirect cost allocation Total kW/0$ Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments $ 1,617 $ 1,617 151,000 '1,205,500 1,356,500 1,130 331,000 332,130 225,000 1,915,247 809 $ 1,455 809 1,455 75,500 65,585 602,750 445,468 678,250 511,053 565 8,871 165,500 116,040 (94) 166,065 124,817 112,500 112,500 957,624 749,825 $ 647 647 (9,915) (157,282) (167,197) 8,306 (49,460) (94) (41, 248) 89.98% 69.98% 43.43% 36.95% 37.67% 785.04% 35.06% 0.00% 37.56% 50.00% (207,7991. 39.15% 686,142 343,071 304,654 (38,417) 44.40% 133,900 66,950 38,562 (28,388) 28.80% 6,885 3,443 282 (3,160) 4.10% 51,306 25,653 25,869 216 50.42% 61,449 30,725 23,834 (6,890) 38.79% 15,565 7,783 7,416 (367) 47.64% 123,977 61,989 52,482 (9,507) 42.33% 11,000 5,500 - (5,500) 0.00% 1,164 582 - (582) 0.00% 98,906 49,454 25,928 (23,526) 26.21% 130,500 65,250 46,673 (18,577) 35.76% 2,500 1,250 876 (374) 35.04% 10,000 5,000 4,630 (370) 46.30% 9,700 4,850 1,587 (3,263) 16.36% 1,250 625 127 (498) 10.19% 7,000 3,500 1,252 (2,248) 17,89% 101,650 50,825 48,568 (2,257) 47.78% 15,195 7,596 15,195 7,598 100.00% 64,765 32,383 23,534 (8,849) 36.34% 36,000 18,000 11,961 (6,039) 33.23% 39,722 19,861 15,846 (4,015) 39.89% 6,000 3,000 1,798 (1,202) 29.96% 67,000 33,500 26,038 (7,462) 38.86% 25,000 12,500 (12,500) 0.00% - 0.00% 0.00% 1,706,576 853,289 677,112 (176,177) 39.68% 15,160 7,580 7,580 (0) 50.00% 1,721,738 860,869 684,692 (176,177) 39.77% 193,509 96,755 65,133 (31,621) 33.66% 140,550 140,550 140,550 0 100.00% 334,059 $ 237,305 $ 205,683 $ (31,821) 61.57% '" Variance = Actual over (under) prorated budget $ 114,058 Fund 411 Page 28 of 32 City of Tukwila Surface Water Fund 412 - Revenue and Expenses As of June 30 2012 % of year expired 50,00% 2012 Expected Annual Budget Budget Actual Year -To -nate Variance'* % of Annual Budget Revenue Charges for Services Surface Water Sales Total Charges for Services Intergovernmental Revenue Miscellaneous Revenue Investment Earnings Other Misc Revenue Total Miscellaneous Revenue Total Revenue Expenses 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 ii,ital,Expenses Change in Fund Balance Beginning Fund Balance $ 3,660,309 $ 1,830,155 5 1,823,614 $ (6,540) 3,660,309 '1,830,155 1,823,614 (6,540) 44,000 22,000 63,744 41,744 11,091 5,546 10,814 5,268 162 162 11,091 5,546 10,976 5,431 3,715,400 1,857,700 721,168 360,584 23,000 11,500 11,653 5,827 54,463 27,232 64,589 32,295 17,301 8,651 167,666 83,833 1,000 500 1,425 713 42,521 21,261 3,000 1,500 628,570 314,285 2,000 1,000 2,000 1,000 500 250 96,638 48,319 15,195 7,598 61,600 30,800 13,965 6,983 8,685 4,343 25,000 12,500 371,000 185,500 1,510,000 755,000 286,554 143,277 30,514 15,257 4,160,007 2,080,004 400,786 200,393 4,560,793 2,280,397 (845,393) 2,151,147 (422,697) 2,151,147 1,898,334 336,599 7,815 6,958 26,549 24,750 6,138 71,861 103 27,347 279 174,909 361 1,654 963 40,416 15,195 56,970 1,407 21,333 24,998 '183,256 12,951 6,873 1,049,684 200,393 1,250,077 648,257 2,151,147 On flag Fund?B&&8nce 1,305,734 $ 1,726,451 Cash and investments Variance e Actual over (under) prorated budget 40,634 (23,985) (3,685) 1,131 (683) (7,545) (2,512) (11,972) (500) (610) 6,087 (1,221) (139,376) (639) 654 713 (7,903) 7,598 26,170 (5,575) 16,991 12,498 (2,244) (742,049) (143,277) (8,384) (1,030,319) 49.82% 49,82% 144.87% 97.50% 0.00% 98.96% 51,09% 46.67% 33.98% 59.71% 48.75% 38.32% 35.48% 42.86% 0.00% 7.19% 64,31% 9.30% 27.83% 18.04% 62.72% 192.54% 41.82% 100.0014 92.48% 10.08% 245.64%c 99.99% 49.40% 0.86% 0.00°A 22.53% 25.23% (0) 50.00% (1,030,319)1 27.41% 1,070,953 0 76.68% 100.00%a 1,7.99,404- $ 1,070,954 214.39% 5 2,683,138 Fund 412 Page 29 of 32 City of Tukwila Equipment Rental/Replacement Fund 501 - Revenue and Expenses As of June 30 2012 % of year expired 50.00% 2012 Expected Annual Budget Budget Actual Year -To -Date Variance' % of Annual Budget Revenue Charges for Services ERR O&M Dept Charges Equipment Replacement Charges Fuel Sales Transportation Total Charges for Services Miscellaneous Revenue investment Earnings Other Misc Revenue Total Miscellaneous Revenue Sale of Capital Assets �TotaWRevenue $ 1,099,806 777,801 474,000 150 2,351,757 14,269 14,269 549,903 388,901 237,000 75 1,175,879 7,135 7,135 $ 549,903 $ 358,726 237,000 1,145,629 18,060 252 18,312 17,598 (30,174) (75) (30,249) 10,926 252 11,177 17,598 50.00% 46.12% 50.00% 0.00% 48.71% 126.57% 0.00% 128.33% 0.00% 2,366,026 1,183,013 1,181,539 (1,474) 49.94% Expenses 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 45 Operating Rentals & Leases 46 Insurance 48 Repairs & Maintenance 49 Miscellaneous 53 Ext Taxes & Operating Assessments 64 Capital Outlay Total Equipment Rental Fund Transfers Out Total Expenses Change in Fund Balance Beginning Fund Balance Ending Fund Balance 352,844 10,000 1,147 26,814 31,601 9,976 82,161 1,000 950 2,979 689,000 2,500 550 2,000 37,399 10,130 130,781 6,500 322,000 1,720,332 309,667 2,029,999 336,027 3,523,993 176,422 176,690 268 50.08% 5,000 5,952 952 59.52% 574 1,783 1,209 155.43% 13,407 14,056 649 52.42% 15,801 13,214 (2,586) 41.82% 4,988 4,398 (590) 44.08% 41,081 38,947 (2,133) 47.40% 500 (500) 0.00% 475 82 (393) 8.64% 1,490 856 (634) 28.73% 344,500 299,080 (45,420) 43.410 1,250 1,878 628 75.11% 275 696 421 126.54% 1,000 557 (443) 27.64% - 144 144 0.00% 18,700 18,510 (190) 49.49% 5,065 10,130 5,065 100.00% 65,391 69,762 4,372 53.34% 3,250 3,616 366 55,62% - 0.00% 161,000 87,751 (73,249) 27.25% 860,166 748,100 (112,066) 43.49% 154,834 154,833 (0) 50.00% 1,015,000 902,934 (112,066) 44,48%1 168,014 278,605 110,591 82.91% 3,523,993 3,523,993 100.00% $ 3,860,020 $ 3,692,007 $ 3,802,598 $ 110,591 98.51% Cash and investments Variance = Actual over (under) prorated hudget 3,789,754 Fund 501 Page 30 of 32 City of Tukwila Insurance Fund 502 - Revenue and Expenses As of June 30 2012 % of year expired 50.00% 2012 Expected Annual Budget Budget Actual Year -Ta -Date Variance "4 % of Annual Budget Revenue Charges for Services Employee Benefit Programs Total Charges for Services Miscellaneous Revenue Investment Earnings Employer Trust Contributions Employee Contributions Other Misc Revenue Tota! Miscellaneous Revenue Total Revenue Expanses 25 Medical, Dental, Life, Optical 41 Professional Services 49 Miscellaneous Total Transfers Out,/ Indirect cost allocation Total Expenses Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and Investments 621 $ 621 $ 10,032 $ 4,367,715 $ 60,000 $ 6,200 4,443, 947 4,444,568 4,400,000 25,000 20,500 4,445,500 80,305 4,525,805 (81,237) 4,983,480 311 $ 311 5,016 2,183,858 30,000 3,100 2,221,974 2,222,284 2,200,000 12,500 10,250 2,222, 750 40,153 2,262,903 (40,619) 4,983,480 464 $ 464 80,153 2,145,181 36,583 2,261,917 2,262,381 2,194,127 6,748 (5,289) 2,195,586 40,152 2,235,739 26,643 4,983,480 154 154 75,137 (38,676) 6,583 (3,100) 39,944 40,097 (5,873) (5,752) (15,539) (27,164) (0) 74.74% 74,74% 798.98% 49.11% 60.97% 0.00% 50.90% 50.90% 49.87% 26.99% -25.60% 49,39% 50.00% (27,164) 49.40% 67,261 -32.80% 100.00% 4,902,243 4,942,862 $ 5,010,123 $ 67,261 102.20% " Variance = Actual over (under) prorated budget $ 6,174,235 Fund 502 Page 31 of 32 %.. Earl Budget.__ 1 111.76% City of Tukwila LEOFF insurance Fund 503 - Revenue and Expenses As of June 30 2012 % of year expired 50.00% �ra�iiidlget 'HUdhgt` We kiiro- Attu - kk Revenue Misceflaneous Revenue Investment Earnings Employer Trust Contributions Other Misc Revenue Total Revenue Expenses 25 Medical, Dental, Life, Optical 41 Professional Services 49 Miscellaneous Tonal Transfers Out 'Tata! ise. Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments $ 3,340 $ 575,000 700 579,040 659,530 3,000 10,000 1,670 287,500 350 289,520 329,765 1,500 5,000 672,530 336,265 4,619 2,310 677,149 338,575 (98,109) (49,055) 1,628,986 1,628,986 1,240 236,612 237,851 152,330 680 670 153,680 2,310 155 990 81,862 1,628,986 (430) (50,888) (350) (S1669) (177,435) (820) (4,330) (182,585) 0 (18,585) 130,916 37.12% 41.15% 0.00% 41?06% 23.10% 22.67% 670% 22.85% 50.00% 23.04%1 -83.44% 100.00% 1,530,877 $ 1,579,932 1;740,`_848 113;916 Variance = Actual over (under) prorated budget 1,904,047 Fund 503 Page 32 of 32 Estimated 2012 Revenues Detail to be used with PowerPoint Slide No. 9 City of Tukwila Estimated 2012 Revenues General Fund Revenues 2011 Actual 2012 Budget 2012 Estimate 2012 Est 2011 Act 2012 Est 2012 Bdgt REVENUES Property Taxes 13,427,445 13,868,250 13,750,000 24% -0.9% Sales and Use Taxes1 16,113,733 15,048,000 15,066,638 -6.5% 0.1% RGRL Tax3 1,641,239 1,975,000 1,745,000 63% -11.6% Admissions Tax 513,611 654,000 585,083 13.9% -10.5% Utility Taxes 4,052,264 4,840,000 4,106,401 13% -15.2% Interfund Utility Tax 1,372,380 1,524,000 1,478,689 7.7% -3.0% Excise Taxes4 1,524,172 2,641,303 2,279,219 49.5% -13.7% PenaltiesjInterest 616 67 8,218 12342% 12165.6% Tax Total 38,645,460 40,550,620 39,019,248 1.0% -3.8% Business Licenses and Permits 663,598 807,227 692,007 43% -143% Building Permits and Fees 1,169,073 1,101,339 1,066,267 -8.8% -3.2% Licenses & Permits Total 1,832,671 1,908,566 1,758,273 -4.1% a.9% Sales Tax Mitigation 1,217,418 1,200,000 1,165,641 -4.3% -2.9% Seattle City Light franchise fee 2,109,617 2,050,000 2,216,027 5.0% 81% Other State shared revenues 408,639 308,504 372,902 4.7% 209% Other intergovernmental 1,020,359 585,643 1,052,275 311% 79.7% Intergovernmental Total 4,756,033 4,144,147 4,806,845 1.1% 16.0% General Government 52,344 60,951 56,188 73% -7.8% Security 430,307 511,134 499,651 16.1% -2.2% Engineering Services 6,922 59,867 6,000 -133% -90.0% Transportation 180,789 158,149 161,702 -1o.6% 22% Plan Check and Review Fees 552,996 858,500 586,663 6.1% -31.7% Culture and Rec Feess 569,571 611,500 454,217 -203% -25.7% Charges for Services Total 1,792,930 2,260,101 1,764,421 -1.6% -21.9% Fines and Penalties Total 229,907 213270 216,464 -5.8% 1.5% Miscellaneous Total 582,694 602,760 513,093 -11.9% -14.9% Indirect Cost Allocation 2,276,584 2,337,077 2,337,077 2.7% Other Financing 21,975 1,300,500 - O % Other Sources Total 2,298,559 3,637,577 2,337,077 1.7% -35.8% Total Revenues & Transfers $ 50,138,254 $ 53,317,041 $ 50,415,420 0.6% -5.4% year. 1 Sales tax is estimated to be $1M less than 2011 due largely to a reduction is new construction sales tax. 2 Sales tax mitigation is included in this line 3 RGRL tax is higher due to more intense collection activity. 4 Gambling tax in 2012 is estimated to exceed 2011; to -date all casinos have paid the quarterly taxes on time; one casino 5 Culture and Rec fees in 2012 exclude pool revenue; the pool operated as part of the Parks and Recreation department The property that was expected to be sold in 2012 will be sold at a later date. Estimated 2012 Expenditures Detail to be used with PowerPoint Slide No. 10 City of Tukwila Estimated 2012 Expenditures 2010 2011 2012 2012 Program Actual Actual Budget Estimate City Council $ 242,851 $ 244,029 $ 269,655 $ 249,687 Mayor's Office 2,228,656 2,218,089 2,543,991 2,434,468 Human Resources 464,095 487,920 573,396 518,540 Finance 2,183,069 1,446,736 1,603,133 1,446,915 City Attorney 578,908 647,990 542,734 508,397 Parks & Recreation 4,123,074 3,495,780 3,465,174 3,248,826 Community Development 2,635,296 2,560,151 2,858,579 2,650,414 Court 1,208,632 945,174 993,849 992,544 Police 13,165,552 14,296,485 14,197,710 14,090,757 Fire 9,920,730 9,814,177 10,308,193 10,200,971 Information Technology 953,361 1,046,573 1,153,947 1,007,394 Public Works 6,941,319 5,717,823 6,290,338 5,784,011 Department 20 44,645,544 42,920,928 44,800,699 43,132,925 252,671 7,062,750 11,642,752 7,885,984 Total $ 44,898,215 $ 49,983,678 $ 56,443,451 $ 51,018,909