Loading...
HomeMy WebLinkAboutSpecial 2011-10-25 Item 1 - 2011 Year to Date Revenues, Sales Tax and ExpendituresAgenda Item I 2011 Year to Date Revenues, Sales Tax and Expenditures General Fund 000 Revenue F &S Committee Informational Memo Misc Revenue Report General Fund 000- Expenditures and Change in Fund Balance General Fund Expenditures By Department General Fund Expenditures By Category 3 of 62 4of62 City of Tukwila General Fund 000 Revenue As of September 30 2011 Revenue General Revenue Property Taxes Sales and Use Taxes Revenue Generating Regulatory Lic Rental housing license Admissions Tax Utility Taxes Interfund Utility Tax Excise Taxes Penalties /Interest Total General Revenue Licenses and Permits Business Licenses and Permits Building Permits and Fees Total Licenses and Permits Intergovernmental Revenue Charges for Services General Government Security Engineering Services Transportation Plan Check and Review Fees Culture and Rec Fees Total Charges for Services Fines and Penalties Miscellaneous Revenue Investment Earnings Rents and Concessions Insurance Premiums /Recovery Contributions /Donations Other Misc Revenue Total Miscellaneous Revenue Sale of Capital Assets Transfers In Indirect cost allocation Total Revenue 5 of 62 of year expired 75.00% 20"1'1 Annual Budget, Actual variance of Budget Year -to -Date Year -To -Date Ac, tual to Annual Budet YTp Budget; 13,530,000 10,147,500 7,214,466 (2,933,034) 53.32% 16,025,000 12,018,750 13,226,849 1,208,099 82.54% 1,900,000 1,425,000 1,416,951 (8,049) 74.58% 42,750 32,063 29,650 (2,413) 69.36% 636,000 477,000 419,799 (57,201) 66.01% 4,723,000 3,542,250 3,086,557 (455,693) 65.35% 1,426,000 1,069,500 1,132,324 62,824 79.41% 2,585,731 1,939,298 1,262,183 (677,116) 48.81% 67 50 27 (23) 40.15% 40,868,548 30,651,411 27,788,805 (2,862,606) 68.00% 784,774 588,581 445,028 (143,552) 56.71% 1,027,368 770,526 951,956 181,430 92.66% 1,812,142 1,359,107 1,396,984 37,877 77.09% 2,805,177 2,103,883 2,532,704 428,821 90.29% 59,015 44,261 38,812 (5,450) 65.77% 493,381 370,036 321,276 (48,759) 65.12% 9,579 7,184 (7,184) 0.00% 153,058 114,794 53,420 (61,373) 34.90% 833,500 625,125 468,750 (156,375) 56.24% 742,000 556,500 476,949 (79,551) 64.28% 2,290,533 1,717,900 1,359,208 (358,692) 59.34% 205,408 154,056 163,407 9,351 79.55% 128,757 96,568 84,083 (12,485) 65.30% 454,391 340,793 318,267 (22,527) 70.04% 1,000 750 (750) 0.00% 1,600 1,200 5,539 4,339 346.18% 97,766 73,325 62,335 (10,990) 63.76% 683,514 512,636 470,223 (42,413) 68.79% 700,500 525,375 6,507 (518,869) 0.93% 1,814,192 1,360,644 1,360,644 0 75.00% 51,180,014 38,385,011 35;078,480 (3,306,530) 68,54% 5 of 62 6 of 62 of Jim Haggertun.Mayor INFORMATIONAL MEMORANDUM TO am im [WayorHaQQerton Finance and Safety Committee Shawn Hunetoch. Interim City Administrator in 1,000 2011 1 no*aseYDoc %|nceeseKOeoease) Actual Month YTD Month YTD 1.039 '3,80Y6 D-DB% 1.043 10 0.97.& -147% 1.453 274 243 23.24% 7.38% 1.252 150 393 13.61% &94`& 1.278 140 538 12.30% 9,83% 1.388 143 878 11.50% 9�96% 1.281 650 -1�39% 815% 1.185 (1.176) (518) '100.00% 1.082 '5�60% Nov (1,185) (1.703) -100.00% 1.101 -16�32% Feb12 (1`038 <2.739 -10\00% Totals -23,88% (1.101) <3.840 '100.00% -3054% (1.628) (5 '100.00% -38,51% 917 9,649 107,32% %of Budget kciMitigatio Sales tax collections for July showed an increase versus the aanm month in the previous year, July represented the twelfth consecutive increase over the last twelve months. For Ju|y, collections were slightly less than budget for the monih, but more than actual collections in the same month the previous year. Actual receipts for July were $18000 |eaa than budget, and $30.000 more than the same period last year. We are down 13S9& for the month compared to budgat, but up by 11.4896 compared to the same month |emt year. Not including one-time money from new construction, we are 7.5y96 ahead of last year's collections todate. Including nALigubun payments' we are currently at 107,32% of budget for the year to date. This includes e mitigation payment of $305.849.90 that will be received on September 38, 2011, Mitigation payments are now annualized and will only be adjusted once per year in the koU effective with the December 31' payment. Staff completed work on the last mitigation detail file and submitted to the Department of Revenue a list offirms that should be removed from the mitigation calculation process. These firms are ones that were offsetting other losses, thereby reducing our mitigation payment. 7 ofG2 Schedule -Sales Tax Sales Receipt 2010 2011 Month Month Actual Estimated Jan Mss 1.034 1.080 Feb Apr 1.006 1.033 Mar May 1,157 1.179 Apr June 1.070 1.102 May July 1.057 1.138 ,,June Aug 1 1.243 July Se 1.251 1.283 Aug Oct 1.218 1.176 Se Nov 1.357 1.185 Oct Dec 1.082 1.036 Nov Jan12 1.2Q2 1.101 Dec Feb12 1.889 1.628 Totals 14.580 14 Mitigation Received INFORMATIONAL MEMO Page 2 Schedule 11 shows the year-to-date sales tax from the top ten industry classifications As this schedule indicates, the trend is flat or down for most of the classifications. Schedule 11 Group Name 448* Clothing and Accessories 452' General Merchandise Stores 443" Electronics and Appliances 722 Food Services, Drinking Places 423' Wholesale Trade, Durable Goods 236 Construction of Buildings 441 Motor Vehicle and Parts Dealer 451` Sporting Goods, Hobby, Books 444 Building Material and Garden 721' Accommodation Utigated NAICS Code YTD YTD Dollar Current Prior Diff. Diff. 1,086,762 1,046,886 39,876 381% 1,073,375 1,090,141 (16.766) -1,54% 806,327 500,894 305,433 60.98% 763,655 772,301 (8,646) -1,12% 632,453 724,319 (91,867) -12,68% 529,036 301,328 227,708 75.57% 352,177 351,354 822 0.23% 339,884 341,932 (2,048) -0.60% 291,525 302,181 (10,656) -3,53% 266,270 240,443 25,827 10,74% As you can see there are large variances from last year for the same firrie period. For instance, sales tax for Construction of Buildings is up by 75.57%, Electronics and Appliances is up by 60.98%, and Wholesale Trade Durable Goods is down by 12.68%. As illustrated above, five of the top ten merchant categories have declined versus prior year, and all but one of the ten industry classification codes are ones for which we receive streamlined sales tax mitigation. Schedule III shows the ten largest declines in sales tax revenue for industries with over $10,000 collected year -to -date. Schedule III Mitigated NAICS Code Attached is a Sales Tax Summary comparing year -to -date 2011 vs. 2010 by major NAICS codes. Also included is a cornparison of total receipts year-to-date for the last six years Below is Schedule IV which shows quarterly gambling tax receipts for last year, and the current year to date. 'Al T!N Proie( T x Hwrrotion I 0;nfri Memo Saif =ax 0922N 11 (Jocx 8 of 62 iN YTD YTD Dollar Group Name Current Prior Diff Diff. 811 Repair and Maintenance 50,537 58,484 (7,947) -13,59% 423' Wholesale Trade, Durable Goods 632,453 724,319 (91,867) '12.68% 512 Motion Picture, Sound Record 16,665 18,860 (2,195) -11,64 531 Real Estate 21,718 24,034 (2,315) -963% 322' Paper Manufacturing 11,401 12,545 {'1,144) -9 12 517 Telecommunications 198,221 216,532 (18,311) -846% 323* Printing and Related Support 25,809 28,073 (2,263) -8,06% 444* Building Material and Garden 291,525 302,181 (10,656) -3.53 452' General Merchandise Stores 1,073,375 1,090,141 (16,766) -1.54% 722* Food Seances, Drinking Places 763,655 772,301 (8,646) -1 12% Mitigated NAICS Code Attached is a Sales Tax Summary comparing year -to -date 2011 vs. 2010 by major NAICS codes. Also included is a cornparison of total receipts year-to-date for the last six years Below is Schedule IV which shows quarterly gambling tax receipts for last year, and the current year to date. 'Al T!N Proie( T x Hwrrotion I 0;nfri Memo Saif =ax 0922N 11 (Jocx 8 of 62 iN INFORMATIONAL MEMO Page 3 Schedule IV Gambling Tax Sales 2010 2011 2011 Quarter Actual Estimated Actual Jon Mar 417.078 464.647 $478.118 Apr 'Jun 532,807 583.292 389.776 Jul 'Sep 439.255 488.248 -17.95% Oct Dec 496 552.813 Totals $1 $2,100.008 $887,894 Aa you can see, we are currently $189.y45 under budget through June 2O11.or17.8696below budget. Actual receipts for 2O11 are 8.G296 below actual receipts tu date in2O10, However, this is largely due to one of the casinos being |aka with their second quarter tax payment. As of today's date, that casino has not yet paid their second quarter taxes. Below is Schedule V which shows monthly admission tax receipts for the prior year and current year bodate. Schedule V' Admissions Tax Actuals increase/(Decrease) Actua|s %Increase/(Decrease) 2010 Month YTD Month YTD 13.571 S 13.571 2.92% 0.0096 (203.510) (189.946) '34�30% -17.95% (489`248) (879.193) -100�00Y6 43.90% (552.913) (1.232.106) -100�009& -58670 Aa you can see, we are currently $189.y45 under budget through June 2O11.or17.8696below budget. Actual receipts for 2O11 are 8.G296 below actual receipts tu date in2O10, However, this is largely due to one of the casinos being |aka with their second quarter tax payment. As of today's date, that casino has not yet paid their second quarter taxes. Below is Schedule V which shows monthly admission tax receipts for the prior year and current year bodate. Schedule V' Admissions Tax Actua|s Sales 2010 2011 2011 Increase/(Decrease) UnoeaseYDecreaaa) Month Actual Estimated Ac Month YTD Month YTD Jan g 52.751 57.532 31.217 $(20.315) (26316) '4574Y4 0,0096 Feb 39.232 42./88 30.403 (12.305) (38701) -2895Y6 -38.58Y& Mar 51.861 56.552 39.606 (16,866) (55.566) '29,82'& -3542% Apr 39.294 42.855 28.705 (14.150) (69`717) '33,0296 -84,90% May 35.365 38.570 38.944 373 (68.343) 097% -29.1096 June 48.428 52.818 57.325 4.508 (64.836) 8.53% -2Z27% July 52.293 87.939 50.835 (17,104) (81.940) '25,1896 -2202% Aug 42.284 46.118 (4O.118) (128.057) -100,0096 -31�60% Se 37.853 41�284 (41.284) (189'341) '100.00% -37�93% Oct 27^038 30.144 (30.144) (199485) '100.00% 41£5% Nov 35.584 38.820 (38.820 (238.305) '10000% 46.23% De c 50.036 54.571 (54.571) (292.876) -10000% -51.38% Totals 522,628 570,000 $277,124 Admission tam receipts are currently 22-8296 below budget for the year. and 15.82% below prior year actual receipts. We are working with one of the largest taxpayers for admissions tax to determine the cause of the decline. It appears that the decline is due to a decline in economic activity for that industry, a movie theaier, but we are working on confirming the tax payments with the Department of Revenue. Also, it is expected that there will be an increase in admission tax payments with the recent opening of the Fly indoor skydiving facility near the mall- Please W*mp'Ojec!msalesrmmm�at.v Tax 09o20//do(�x 9 ofG2 10 of 62 City of Tukwila General Fund 000 Expenditures and Change in Fund Balance As of September 30 2011 Expenditures City Council Mayor's Office Human Resources Finance Legal Parks Rec Community Development Court Police Fire Information Technology Public Works Parks Maintenance PW Street Maintenance Non-Departmental (Dept. 20) Total Expenses (g) Change in Fund Balance Beginning Fund Balance Ending Fund Balance of year expired 75.00% 2011 1,851,327 Annual Budget Actual, Variance of Budget YearAo-Date Year-To-Date AOtual Annual Budget YTD Budget 262,634 196,976 2,468,436 1,851,327 542,979 407,234 1,524,117 1,143,088 542,731 407,048 2,962,377 2,221,783 2,631,309 1,973,482 978,529 733,897 14,267,695 10,700,771 9,948,846 7,461,635 1,104,845 828,634 3,484,525 2,613,394 922,901 692,176 2,603,943 1,952,957 8,592,495 6,444,371 52,838,362 39,628,772 (1,658,348) (1,243,761) 6,100,000 6,100,000 183,672 1,581,090 363,077 1,136,502 485,998 1,987,858 1,905,915 697,690 10,236,867 7,306,631 722,170 2,303,321 708,748 1,904,577 3,902,332 35,426,447 (347,967) 5,757,041 (13,304) 69,93% (270,237) 64.05% (44,157) 66.87% (6,585) 74.57% 78,950 89.55% (233,924) 67.10% (67,566) 72.43% (36,207) 71.30% (463,905) 71.75% (155,004) 73,44% (106,464) 65.36% (310,073) 66.10% 16,572 76.80% (48,380) 73.14% (2,542,040) 45.42% (4,202,325) 67.05% 895,794 20.98% (342,959) 94.38% 4,441,662 4,866,239 5,409,074 552,835 121.78% 11 of 62 12 of 62 CITY OF TUKWILA General Fund Expenditures By Department As of September 30 2011 of year expired 75.00% Annual Prorated TOTALS ALL DEPARTMENTS Budget Budget Actual Spent Variance Spent; CITY COUNCIL 262,634 196,976 183,672 (13,304) 69.93% MAYOR 2,468,436 1,851,327 1,581,090 (270,237) 64.05% HUMAN RESOURCES 542,979 407,234 363,077 (44,157) 66.87% FINANCE 1,524,117 1,143,088 1,136,502 (6,585) 74.57% CITY ATTORNEY 542,731 407,048 485,998 78,950 89.55% RECREATION 2,962,377 2,221,783 1,987,858 (233,924) 67.10% COMMUNITY DEVELOPMENT 2,631,309 1,973,482 1,905,915 (67,566) 72.43% MUNICIPAL COURT 978,529 733,897 697,690 (36,207) 7130% POLICE 14,267,695 10,700,771 10,236,867 (463,905) 71.75% FIRE 9,948,846 7,461,635 7,306,631 (155,004) 73.44% INFORMATION TECHNOLOGY 1,104,845 828,634 722,170 (106,464) 65.36% PUBLIC WORKS 3,484,525 2,613,394 2,303,321 (310,073) 66.10% PARK MAINTENANCE 922,901 692,176 708,748 16,572 76.80% STREET MAINTENANCE OPERATION 2,603,943 1,952,957 1,904,577 (48,380) 73.14% DEPT 20 CONTRIBUTIONS FUND BALANCI 8,592,495 6,444,371 3,902,332 (2,542,040) 45.42% TOTAL, 62,838,362 39,628,772 35,426.447 _1_(4,202,325) 67.05 1 /6 Annual Prorated' 01 CITY COUNCIL Budget Budget Actual Spent Variance Spent 11 SALARIES 174,426 130,820 130,503 (317) 74.82% 21 FICA 13,022 9,767 9,844 78 75.60% 23 PERS 6,013 4,510 3,813 (697) 63.41% 24 INDUSTRIAL INSURANCE 2,486 1,865 1.781 (83) 71.65% 25 MEDICAL, DENTAL, LIFE, OPTICAL 19,417 14,563 20,387 5,825 105.00% 31 OFFICE OPERATING SUPPLIES 3,870 2,903 1,280 (1,623) 33.06% 41 PROFESSIONAL SERVICES 1,500 1,125 103 (1,022) 6.85% 42 COMMUNICATION 4,400 3,300 2,766 (534) 62.87% 43 TRAVEL 25,000 18,750 11,884 (6,866) 47.54% 49 MISCELLANEOUS 12,500 9,375 1,311 (8,064) 10.49% CITY COUNCIL 262,634 196 183,672 (13,304) 69.93 13 of 62 CITY OF TUKWILA General Fund Expenditures By Department As of September 30 2011 of year expired 75.00% Annual. Prorated 03-MAYOR Budget Budget Actual Spent Variance %o Spent 11 SALARIES 963,795 722,846 709,621 (13,225) 73.63% 12 EXTRA LABOR 15,500 11,625 (11,625) 0.00% 13 OVERTIME 573 430 162 (268) 28.30% 21 FICA 69,547 52,160 53,093 932 76.34% 23 PERS 67,134 50,351 39,152 (11,199) 5832% 24 INDUSTRIAL INSURANCE 3,780 2,835 2,410 (425) 63.75% 25 MEDICAL, DENTAL,LI FE, OPTICAL 162,604 121,953 112,857 (9,096) 69.41% 31 OFFICE OPERATING SUPPLIES 33,856 25,392 9,649 (15,743) 28.50% 35 SMALL TOOLS MINOREQUIPMENT 2,435 1,826 (1,826) 0.00% 41 PROFESSIONAL SERVICES 755,570 566,678 468,644 (98,033) 62.03% 42 COMMUNICATION 85,300 63,975 47,330 (16,645) 55.49% 43 TRAVEL 19,600 14,700 5,355 (9,345) 27.32% 44 ADVERTISING 17,250 12,938 7,283 (5,654) 42.22% 45 OPERATING RENTALS LEASES 32,093 24,070 18,033 (6,036) 56.19% 48 REPAIRS MAINTENANCE 17,000 12,750 4,380 (8,370) 25.76% 49 MISCELLANEOUS 174,899 131,174 80,931 (50,243) 46.27% 51 INTERGVRNMTL PROFESSIONAL SVCS 26,500 19,875 22,189 2,314 83.73% 64 MACHINERY EQUIPMENT 21,000 15,750 (15,750) 0.00% MAYOR 2,468,436, 1,851,327 1,581,090' (270,237) 6405% Annual Prorated 04 HUMAN RESOURCES Budget Budget Actual Spent Variance Spent 11 SALARIES 326,100 244,575 243,489 (1,086) 74.67% 21 FICA 24,073 18,055 18,019 (36) 74.85% 23 PERS 22,729 17,047 14,404 (2,642) 63.37% 24 INDUSTRIAL INSURANCE 1,243 932 853 (79) 68.63% 25 MEDICAL,DENTAL,LIFE,OPTICAL 53,340 40,005 39,937 (68) 74.87% 31 OFFICE OPERATING SUPPLIES 7,103 5,327 1,499 (3,828) 21.10% 41 PROFESSIONAL SERVICES 79.050 59,288 31,711 (27,577) 40.11% 43 TRAVEL 2,500 1,875 1,070 (805) 42.82% 44 ADVERTISING 9,000 6,750 4,067 (2,683) 45.19% 45 OPERATING RENTALS LEASES 50 38 22 (16) 43.84% 48 REPAIRS MAINTENANCE 4,791 3,593 4,659 1,066 97.24% 49 MISCELLANEOUS 13,000 9,750 3,349 (6,401) 25.76% HUMAN RESOURCES 542,979 407,234 363,082 (44,153) 66.87% 14 of 62 CITY OF TUKWILA General Fund Expenditures By Department As of September 30 2011 of year expired 75.00% 15 of 62 Annual; Prorated 05 FINANCE Budget Budget Actual Spent: Variance Spent 11 SALARIES 937,888 703,416 720,096 16,680 76.78% 12 EXTRA LABOR 10,000 7,500 (7,500) 0.00% 13 OVERTIME 1,147 860 15,661 14,801 1365.41% 21 FICA 69,527 52,145 54,760 2,615 78.76% 23 PERS 65,267 48,950 42,542 (6,409) 65.18% 24 INDUSTRIAL INSURANCE 3,729 2,797 2,617 (180) 70.17% 25 MEDICAL, DENTAL, LIFE, OPTICAL 192,942 144,707 146,423 1,717 75.89% 31 OFFICE OPERATING SUPPLIES 24,849 18,637 5,475 (13,161) 22.03% 41 PROFESSIONAL SERVICES 190,000 142,500 124,985 (17.515) 65.78% 42 COMMUNICATION 1,000 750 668 (82) 66.85% 43 TRAVEL 5,000 3,750 1,979 (1,771) 39.59% 48 REPAIRS MAINTENANCE 5,000 3,750 1,597 (2,153) 31.94% 49 MISCELLANEOUS 1 12,768 9,576 19,654 10,078 153.94% 64 MACHINERY EQUIPMENT 5,000 3,750 (3,750) 0.00% FINANCE 1,524,117 1,143 1,136,458'; (6,630) 74.57 Annual Prorated 06 CITY ATTORNEY Budget Budget Actual Spent Variance Spent' 12 EXTRA LABOR 2,500 1,875 (1,875) 0.00% 21 FICA 795 596 (596) 0.00% 24 INDUSTRIAL INSURANCE 436 327 2 (325) 0.42% 31 OFFICE OPERATING SUPPLIES 5,000 3750 2,012 (1,738) 40.23% 41 PROFESSIONAL SERVICES 528,000 396,000 483,405 87,405 91.55% 42 COMMUNICATION 2,500 1,875 (1,875) 0.00% 45 OPERATING RENTALS LEASES 500 375 (375) 0.00% 48 REPAIRS MAINTENANCE 2,000 1,500 279 (1,221) 13.95% 49 MISCELLANEOUS 1,000 750 301 (449) 30.15% CITY ATTORNEY` 542,731 407,048, 485,9981 78,950 89,55 %0 15 of 62 CITY OF TUKWILA General Fund Expenditures By Department As of September 30 2011 of year expired 75.00% 16 of 62 Annual Prorated 07 RECREATION Budget Budget Actual Spent Variance Spent 11 SALARIES 1,287,105 965,329 955,750 (9,579) 74.26% 12 EXTRA LABOR 413,115 309,836 260,958 (48,878) 63.17% 13 OVERTIME 5,600 4,200 3,343 (857) 59.69% 21 FICA 149,982 112,487 91,895 (20,592) 61.27% 23 PERS 106,625 79,969 63,173 (16,795) 59.25% 24 INDUSTRIAL INSURANCE 38,378 28,784 33,102 4,319 86.25% 25 MEDICAL, DENTAL,LI FE, OPTICAL 270,346 202,760 207,046 4,287 76.59% 31 OFFICE OPERATING SUPPLIES 95,811 71,858 42,477 (29,381) 44.33% 34 ITEMS PURCH. FOR INVENT /RESALE 14,200 10,650 29,881 19,231 210.43% 41 PROFESSIONAL SERVICES 200,966 150,725 81,640 (69,085) 40.62% 42 COMMUNICATION 31,380 23,535 5,705 (17,830) 18.18% 43 TRAVEL 8,400 6,300 2,611 (3,689) 31.08% 44 ADVERTISING 21,400 16,050 4,161 (11,889) 19.45% 45 OPERATING RENTALS LEASES 56,363 42,272 36,564 (5,708) 64.87% 47 PUBLIC UTILITY SERVICES 110,000 82,500 96,560 14,060 87.78% 48 REPAIRS MAINTENANCE 57,550 43,163 30,359 (12,803) 52.75% 49 MISCELLANEOUS 95,156 71,367 42,476 (28,891) 44.64% 53 EXT TAXES OPERATING ASSMNTS 157 157 0.00% RECREATION 2,962,377`" 2,221,783 1,987,858: (233,924) 67.10% Annual Prorated; 08 COMMUNITY DEVELOPMENT Budget Budget Actual Spent Variance Spent 11 SALARIES 1.723,487 1,292,615 1,301,466 8,851 75.51% 12 EXTRA LABOR 37,650 28,238 40,328 12,090 107.11% 13 OVERTIME 5,672 4,254 2,507 (1,747) 44.19% 21 FICA 129,074 96,806 101,398 4,592 78.56% 23 PERS 120,892 90,669 80,418 (10,251) 66.52% 24 INDUSTRIAL INSURANCE 10,321 7,741 10,196 2,456 98.79% 25 MEDICAL, DENTAL, LIFE, OPTICAL 256,470 192,353 197,174 4,822 76.88% 28 UNIFORM CLOTHING 1,805 1,354 105 (1,249) 5.82% 31 OFFICE OPERATING SUPPLIES 34,182 25,637 13,180 (12,456) 38.56% 35 SMALL TOOLS MINOR EQUIPMENT 600 450 325 (125) 54.20% 41 PROFESSIONAL SERVICES 161,208 120,906 32,193 (88,713) 19.97% 42 COMMUNICATION 4,500 3,375 344 (3,031) 7.65% 43 TRAVEL 13,500 10,125 830 (9,295) 6.15% 45 OPERATING RENTALS LEASES 33,773 25,330 25,416 86 75.26% 47 PUBLIC UTILITY SERVICES 1,000 750 104 (647) 10.35% 48 REPAIRS MAINTENANCE 57,865 43,399 49,951 6,552 86.32% 49 MISCELLANEOUS 21,310 15,983 36,713 20,730 172.28% 51 INTERGVRNMTL PROFESSIONAL SVCS 18.000 13,500 13,265 (235) 73.69% COMMUNITY DEVELOPMENT 2,631,309 1,973,482, 1,905,913 (67,569) 72.43% 16 of 62 CITY OF TUKWILA General Fund Expenditures By Department As of September 30 2011 of year expired 75.00% 17 of 62 Annual Prorated 09 MUNICIPAL COURT Budget Budget Actual Spent Variance, %Q Spent 11 SALARIES 602,387 451,790 465,120 13,330 77.21% 12 EXTRA LABOR 2,500 1,875 (1,875) 0.00% 13 OVERTIME 5,016 3,762 (3,762) 0.00% 21 FICA 45,537 34,153 35,008 855 76.88% 23 PERS 45,436 34,077 28,948 (5,129) 63.71% 24 INDUSTRIAL INSURANCE 3,107 2,330 1,903 (427) 61.26% 25 MEDICAL,DENTAL,LIFE,OPTICAL 96,935 72,701 71,335 (1,367) 73.59% 26 UNEMPLOYMENT COMPENSATION 658 658 0.00% 31 OFFICE OPERATING SUPPLIES 10,908 8,181 5,919 (2,262) 54.26% 35 SMALL TOOLS MINOR EQUIPMENT 1,200 900 (900) 0.00% 41 PROFESSIONAL SERVICES 106,000 79,500 70,254 (9,246) 66.28% 42 COMMUNICATION 5,550 4,163 4,519 356 81.42% 43 TRAVEL 6,215 4,661 4,381 (281) 70.48% 45 OPERATING RENTALS LEASES 552 552 0.00% 48 REPAIRS MAINTENANCE 2,300 1,725 713 (1,012) 30.99% 49 MISCELLANEOUS 20,438 15,329 8,379 (6,949) 41.00% 64 MACHINERY EQUIPMENT 25,000 18,750 (18,750) 0.00% MUNICIPAL COURT 978,529 733,897 697,690 36,207 71.30% Annual Prorated 10 POLICE Budget" Budget' Actua Spent Variance Spent 11 SALARIES 6,706,070 5,029,553 4,823,535 (206,018) 71.93% 12 EXTRA LABOR 5,000 3,750 (3,750) 0.00% 13 OVERTIME 908,812 681,609 635,789 (45,820) 69.96% 21 FICA 507,174 380,381 414,063 33,683 81.64% 22 LEOFF 301,353 226,015 245,594 19,579 81.50% 23 PERS 70,637 52,978 41,323 (11,655) 58.50% 24 INDUSTRIAL INSURANCE 119,710 89,783 81,641 (8,141) 68.20% 25 MEDICAL,DENTAL,LI FE, OPTICAL 1,520,483 1,140,362 1,026,561 (113,802) 67.52% 31 OFFICE OPERATING SUPPLIES 171,753 128,815 70,819 (57,996) 41.23% 35 SMALL TOOLS MINOR EQUIPMENT 7,500 5 (5,625) 0.00% 41 PROFESSIONAL SERVICES 48,175 36,131 61,941 25,810 128.57% 42 COMMUNICATION 61,931 46,448 34,532 (11,916) 55.76% 43 TRAVEL 23,300 17,475 17,625 150 75.64% 44 ADVERTISING 800 600 (600) 0.00% 45 OPERATING RENTALS LEASES 801,628 601,221 576,834 (24,387) 71.96% 46 INSURANCE 225,080 168,810 225,000 56,190 99.96% 48 REPAIRS MAINTENANCE 166,144 124,608 95,720 (28,888) 57.61% 49 MISCELLANEOUS 57,245 42,934 20,023 (22,911) 34.98% 51 INTERGVRNMTL PROFESSIONAL SVCS 2,549,900 1,912,425 1,761,448 (150,977) 69.08% 64 MACHINERY EQUIPMENT 15,000 11,250 104,417 93,167 696.11% POLICE 14,267,695 10,700,7711 10,236,867 (463,905) 71.75% 17 of 62 CITY OF TUKWILA General Fund Expenditures By Department As of September 30 2011 of year expired 75.00% 18 of 62 Annual Prorated 11 -FIRE Budget Budget Actual Spent Variance Spent 11 SALARIES 5,920,352 4,440,264 4,572,118 131,854 77.23% 13 OVERTIME 421,552 316.164 352,787 36,623 83.69% 15 HOLIDAY PAY 178,248 133,686 3,782 (129,904) 2.12% 21 FICA 84,800 63,600 67,710 4,110 79.85% 22 LEOFF 256,199 192,149 232,172 40,023 90.62% 23 PERS 23,438 17,579 11,165 (6,413) 47.64% 24 INDUSTRIAL INSURANCE 151,607 113,705 102,228 (11,478) 67.43% 25 MEDICAL,DENTAL,LIFE,OPTICAL 1,533,418 1,150,064 1,007,219 (142,844) 65.68% 26 UNEMPLOYMENT COMPENSATION (6,399) (6,399) 0.00% 28 UNIFORM CLOTHING 1,140 855 (855) 0.00% 31 OFFICE OPERATING SUPPLIES 185,580 139,185 112,393 (26,792) 60.56% 35 SMALL TOOLS MINOR EQUIPMENT 25,552 19,164 12,771 (6,393) 49.98% 41 PROFESSIONAL SERVICES 55,300 41,475 33,617 (7,858) 60.79% 42 COMMUNICATION 44,670 33,503 14,275 (19,227) 31.96% 43 TRAVEL 14,500 10,875 1,975 (8,900) 13.62% 45 OPERATING RENTALS LEASES 499,389 374,542 381,244 6,702 76.34% 46 INSURANCE 90,000 67,500 90,000 22,500 100.00% 47 PUBLIC UTILITY SERVICES 60.000 45,000 48,758 3,758 81.26% 48 REPAIRS MAINTENANCE 41,000 30,750 25,282 (5,468) 61.66% 49 MISCELLANEOUS 78,101 58,576 54,114 (4,462) 69.29% 51 INTERGVRNMTL PROFESSIONAL SVCS 284,000 213,000 189,418 (23,582) 66.70% FIRE 9,948,846 7,461,635 7,306,631 (155,004) 73.44 Annual Prorated 12 INFORMATION TECHNOLOGY Budget Budget; Actual Spent, Variance Spent 11 SALARIES 555,627 416,720 409,563 (7,157) 73.71 12 EXTRA LABOR 2,500 1,875 (1,875) 0.00% 13 OVERTIME 635 635 0.00% 21 FICA 42,921 32,191 31,039 (1,151) 72.32% 23 PERS 38,706 29,030 24,319 (4,710) 62.83% 24 INDUSTRIAL INSURANCE 2,922 2,192 1,624 (567) 55.59% 25 MEDICAL,DENTAL,LI FE, OPTICAL 127,403 95,552 93,819 (1,734) 73.64% 31 OFFICE OPERATING SUPPLIES 5,766 4,325 2,347 (1,978) 40.70% 35 SMALL TOOLS MINOR EQUIPMENT 122,000 91,500 62,653 (28,847) 51.36% 41 PROFESSIONAL SERVICES 1,000 750 (750) 0.00% 42 COMMUNICATION 99,000 74,250 72,026 (2,224) 72.75% 43 TRAVEL 1,500 1,125 368 (757) 24.51 45 OPERATING RENTALS LEASES 1,500 1,125 1,152 27 76.82% 48 REPAIRS MAINTENANCE 31,500 23,625 2,753 (20,872) 8.74% 49 MISCELLANEOUS 40,500 30,375 19,871 (10,504) 49.07% 1 64 MACHINERY EQUIPMENT 32,000 24,000 (24,000) 0.00% INFORMATION TECHNOLOGY 1,104,845 828,634 722,170 (106,464) 65.36% 18 of 62 CITY OF TUKWILA General Fund Expenditures By Department As of September 30 2011 of year expired 75.00% 19 of 62 Annual Prorated 13 PUBLIC WORKS Budget Budget Actual Spent, Variance Spent, 11 SALARIES 1,846,484 1,384,863 1,269,497 (115,366) 68.75% 12 EXTRA LABOR 3,500 2,625 (2,625) 0.00% 13 OVERTIME 4,556 3,417 7,174 3,757 157.47% 21 FICA 137,065 102,799 96,368 (6,431) 70.31% 23 PERS 128,577 96,433 76,068 (20,365) 5916% 24 INDUSTRIAL INSURANCE 25,742 19,307 16,144 (3,162) 6272% 25 MEDICAL, DENTAL,LI FE, OPTICAL 363,973 272,980 242,647 (30,333) 66.67% 28 UNIFORM CLOTHING 3,800 2,850 468 (2,382) 12.32% 31 OFFICE OPERATING SUPPLIES 99,460 74,595 54,342 (20,253) 54.64% 35 SMALL TOOLS MINOR EQUIPMENT 43,750 32,813 451 (32,361) 1.03% 41 PROFESSIONAL SERVICES 31,400 23,550 30,299 6,749 96.49% 42 COMMUNICATION 7,750 5,813 9,153 3,341 118.10% 43 TRAVEL 800 600 678 78 84.77% 45 OPERATING RENTALS LEASES 182,163 136,622 129,708 (6,914) 71.20% 47 PUBLIC UTILITY SERVICES 379,449 284,587 220,912 (63,675) 58.22% 48 REPAIRS MAINTENANCE 165,521 124,141 140,852 16,712 85.10% 49 MISCELLANEOUS 60,535 45,401 8,558 (36,843) 14.14% ,r,v PUBLIC WORKS 3,484,525: 2,613,394 2,303,321" (310,073) 66,10 %o- Annual. Prorated 15 PARK MAINTENANCE: Budget Budget Actual Spent Variance %p Spent 11 SALARIES 399,264 299,448 352,441 52,993 88.27% 12 EXTRA LABOR 35,020 26,265 160 (26,105) 0.46% 13 OVERTIME 2,295 1,721 677 (1,044) 29.52% 21 FICA 30,070 22,553 26,527 3,974 88.22% 23 PERS 27,793 20,845 20,943 98 75.35% 24 INDUSTRIAL INSURANCE 9,937 7,453 8 945 84.51% 25 MEDICAL, DENTAL, LIFE, OPTICAL 68,099 51,074 53,950 2,875 79.22% 28 UNIFORM CLOTHING 1,425 1,069 (1,069) 0.00% 31 OFFICE OPERATING SUPPLIES 36,968 27,726 18,077 (9,649) 48.90% 35 SMALL TOOLS MINOR EQUIPMENT 1,500 1,125 34 (1,091) 2.26% 41 PROFESSIONAL SERVICES 25,000 18,750 20,397 1,647 81.59% 43 TRAVEL 86 86 0.00% 45 OPERATING RENTALS LEASES 85,530 64,148 66,312 2,165 77.53% 47 PUBLIC UTILITY SERVICES 149,000 111,750 124,215 12,465 83.37% 48 REPAIRS MAINTENANCE 40,000 30,000 15,005 (14,995) 37.51% 49 MISCELLANEOUS 4,000 3,000 1,526 (1,474) 38.15% 63 OTHER IMPROVEMENTS 7,000 5,250 (5,250) 0.00% PARK MAINTENANCE'; 922,901 692,176 708,748" 16,572 76.80% 19 of 62 CITY OF TUKWILA General Fund Expenditures By Department As of September 30 2011 of year expired 75.00% Annual Prorated 16 STREET' MAINTENANCE OPERATION Budget Budget Actual Spent Variance Spent 11 SALARIES 749,184 561,888 518,637 (43,251) 69.23% 12 EXTRA LABOR 43.723 32,792 29,845 (2,948) 68.26% 13 OVERTIME 11,474 8,606 25,014 16,408 218.00% 21 FICA 56,845 42,634 43,568 934 76.64% 23 PERS 52,161 39,121 33,616 (5,505) 64.45% 24 INDUSTRIAL INSURANCE 20,778 15,584 15,710 127 75.61% 25 MEDICAL,DENTAL,LIFE,OPTICAL 171,370 128,528 123,355 (5,173) 71.98% 28 UNIFORM CLOTHING 2,375 1,781 776 (1,005) 32.68% 31 OFFICE OPERATING SUPPLIES 318,800 239,100 112,468 (126,632) 35.28% 35 SMALL TOOLS MINOR EQUIPMENT 10,931 8,198 3,597 (4,602) 32.90% 41 PROFESSIONAL SERVICES 4,000 3,000 3,593 593 89.82% 42 COMMUNICATION 4,300 3,225 883 (2,342) 20.54% 43 TRAVEL 2,700 2,025 643 (1,382) 23.80% 44 ADVERTISING 1,500 1,125 480 (645) 31.97% 45 OPERATING RENTALS LEASES 407,287 305,465 302,915 (2,550) 74.37% 46 INSURANCE 35,455 26,591 35,455 8,864 100.00% 47 PUBLIC UTILITY SERVICES 678,760 509,070 616,381 107,311 90.81% 48 REPAIRS MAINTENANCE 27,100 20,325 734 (19,591) 2.71% 49 MISCELLANEOUS 5,200 3,900 457 (3,443) 8.79% 53 EXT TAXES OPERATING ASSMNTS 18 0.00% 64 MACHINERY EQUIPMENT 36,434 0.00% STREET MAINTENANCE OPERATION. 2,503,943 1,952,957 1,904,577 (84,832) 73.14% Annual Prorated' 20 CONTRIBUTIONS FUND BALANCE! Budget Budget Actual Spent Variance- Spent 01 TRANSFERS OUT 8,039,495 6,029,621 3,409,499 (2,620,122) 42.41% 26 UNEMPLOYMENT COMPENSATION 30,000 22,500 30,000 7,500 100.00% 46 INSURANCE 200,000 150,000 84,286 (65,714) 42.14% 49 MISCELLANEOUS 323,000 242,250 378,547 136,297 117.20% CONTRIBUTIONS t FUND BALANCE 8,592,495 6,444,371 3,902,332 (2,542,040) 45.42% 20 of 62 CITY OFTUKWILA General Fund Expenditures 'ByCategory Aeof September 3O2O11 TOTALS BY CATEGORY SUMMARIZED MISCELLANEOUS GENERAL GOVERNMT SALAR AND BENEFITS SUPPLIES PROFESSIONAL SERVICES INTERGOVERNMENTAL CAPITAL EXPENDITURES Grand Totals of year expired 75.00% Annual Budget Actual Variance of Budget Year-to-Date Spent Actual to Annual Budget YTD Budget 8.039,495 6.029.621 3.409499 (2.620.122) 42.11% 32.273.035 24.204.776 23.498523 (706,253) 72.81Y6 1,263574 847,681 561.849 (388031) 44.45m 8.278.858 6.209.144 *.829381 (379.762 70.41Y4 2.078,400 2.158,800 1.8805+4 (172,258 69.02% 105.000 78,750 140,850 82.100 134.14% $62�8,362 39�28J72 35,426,447 (4,202,325) 67.05%' Annual Budget Budget Year-to-Date TOTALS BY CATEGORY DETAIL OO MISCELLANEOUS GENERAL GOVERNMT$ 11 SALARIES 12 EXTRA LABOR 18 OVERT 15 HOLIDAY PAY 21 FICA uu Lsorp 23 PERo 24 INDUSTRIAL INSURANCE 25 ME0CAL.DENTAL.L|FE.OPTICAL 26 UNEMPLOYMENT COMPENSAT 28 UNIFORM CLOTHING 31 OFFICE OPERAT SUPPLIES 34 |TEMSPURCH FOR|NVEmT/RESALE os SMALL TOOLS MINOR EQUIPMENT 41 PROFESSIONAL SERVICES 42 COMMUNICATION 43 TRAVEL 44 ADVERTISING 45 OPERATING RENTALS LsxeEu 40 INSURANCE 47 PUBLIC UTILITY SERVICES 48 REPAIRS &MAINTENANCE 49 MISCELLANEOUS 51 |mTsnGVRNMTL PROFESSIONAL SVCS r, M"�-r^~r-C'""0C:0"-r1^.f'-^CQ^"^.-rQ 8,039,495 22.192.169 571,008 1.308.6e7 178,248 1,360,432 557,552 775,408 394,176 4,836,800 30,00 1O.5*5 1,033,980 14,200 215,468 2,187,169 352,20 123,015 ^9,850 2,100,276 5 1,378,209 617,771 e19,652 6,029,621 16,644,127 428,256 1,025,023 133,686 1,020,324 418,164 581,556 295,632 3,627,600 22,500 7,909 775,430 10,650 1*1.so1 1,640,377 oo^,211 92 37,463 1,575,207 412,901 1,033,657 403.328 Actual 3,409 16,471,835 331.290 1,043 3,782 1,043,291 477,762 479,885 278,610 3,342,709 24,261 1,349 451,936 29,881 79,832 1,442,781 192,204 49,485 15,991 1,538 434,741 1,106,930 3 676,212 1,986 O3 OTHER IMPROVEMENTS 7,00 5,250 64 MACmNEnv&sQU|PMENT 98,000 73.500 Grand Totals 62,838,362 39,628,772 140,850 35,426,447 Variance Budget YTD (2,620,122) (1ro.281) (96,966) /O.72V (129,904) 22,967 59,598 (101.8r1) (17.O22) (2D4,891) 1,761 (6.559) (323.493) 19,231 (81.769) (1or,5es (72.O07 (4z.77s (z1.4r1) (3o,4so) 21,840 73,273 (n1.u44) (13.527) (17z,4ao 224 (5.250) 67,350 Annual Budget 42.41% 74.22% 58.02% 76.37% 2.12% 76.69% 85.69% 61.89% 70.68% 69.11% 80.87% 12.80% 43.71% 210.43% 37.05% 65.97% 54.56% 40.23% 32.01% 73.26% 78.97% 80.32% 60.26% 73.53% 69.01% 0.00% 0.00% 143,72% 21 of 62 22 of 62