Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
FIN 2017-06-06 Item 2C - Report - 2017 1st Quarter Financial Report
City of Tukwila INFORMATIONAL MEMORANDUM TO: Councilmembers CC: Mayor Ekberg FROM: Peggy McCarthy, Finance Director BY: Craig Zellerhoff, Fiscal Coordinator DATE: May 30, 2017 SUBJECT: 2017 1st Quarter Financial Report Summary Allan Ekberg, Mayor The purpose of the quarterly financial report is to summarize for the City Council the general state of City- wide financial affairs and to highlight significant items or trends. The following provides a high -level summary of the City's financial performance on cash basis reporting. Additional details can be found later in the attached financial report. The first quarter status report is based on financial data available as of May 25th, 2017 for the reporting period ending March 31, 2017. Revenues are below allocated budget by $541 thousand and expenditures are below budget by $1.01 million. Revenues Expenditures General Fund 2017 Revenues vs Expenditures (Through March 2017) Actual $13.54 $14.08 Actual $14.62 $15.63 $12 $13 $14 $15 $16 Millions Allocated budgets through the reporting period are calculated by analyzing spend patterns in the previous year and allocating the current year budget using the same spend pattern. If a line item had no expenditures in the prior year but a budget in the current year, the allocated budget for the current year would be zero. 43 INFORMATIONAL MEMO Page 2 General Fund The general fund is the City's largest fund and accounts for the majority of City resources and services, other than those required by statute to be accounted for in another fund. Services include governance, public safety, and administration. General Fund Rolling 14 month Revenue and Expense Summary $9 N c O_ E $8 2 $7 D Feb -16 Mar -16 Apr -16 May -16 Jun -16 Jul -16 Aug -16 Sep-16 Oct -16 Nov -16 Dec -16 Jan -17 Feb -17 Mar -17 Operating Revenues Expenses 2 per. Mov. Avg. (Operating Revenues) 2 per. Mov. Avg. (Expenses) The above chart provides a lookback at revenues and expenses over the last 14 months. The trend lines are calculated using a 2 -month average for both revenues and expenses. The revenue peaks in April /May and October /November are the result of Property Tax revenue. 44 INFORMATIONAL MEMO Page 3 Revenues Through March 2017, general fund revenues totaled $13.54 million compared to an allocated budget of $14.08 million and were $375 thousand higher than revenues collected for the same period in 2016. Notable variances to budget for the first quarter include: Property Taxes Sales & Use Taxes Admissions Tax Utility Tax Interfund Utility Tax Gambling & Excise Tax Licenses and Permits Intergovernmental Charges for Services Fines & Penalites Misc Indirect Cost Allocation Year -to -Date General Fund Revenues Compared to Budget (Through March 2017) $551 $524 El $202 $218 $1,179 $1,196 $680 $638 $957 $790 $2,483 $2,726 $1,3 $1,06 404 S$392 $427 I$37 $43 I$263 $233 $570 $570 Tukwila Village S� $0 $2,000 r Year to Date • Budget $4,000 4 905 $5,329 $6,000 Thousands • Sales and use taxes, which includes local retail sales and use tax, natural gas tax, and criminal justice sales tax, totaled $4.9 million, which is below budget by $424 thousand and is lower in collections for the same period last year by $119 thousand. • Gambling and excise taxes through the end of March totaled $957 thousand and exceed allocated budget by $167 thousand. • RGRL fees which are reported on the Licenses and Permits line is $156 thousand below budget. Fees collected are primarily lower due to a shift in production at a few of the Boeing facilities in the amount of $71 thousand. • Seattle City Light agreement reported under Intergovernmental revenue is $117 thousand below budget due to a timing issue as March revenue was recorded in April rather than March. March revenue will be reflected in the 2nd quarter report. • Property tax collection is on target to meet budget. The majority of property tax revenues are collected during the months of April /May and October /November, coinciding with the due dates for the county property tax billings. 45 INFORMATIONAL MEMO Page 4 Expenditures General fund expenditures through the end of March 2017 totaled $14.6 million as compared to an allocated budget of $15.6 million, which is $1.0 million below budget. Notable variances are as follows: Year to Date Department Expenditures Compared to Allocated Budget (Through March 2017) City Council Mayor Human Resources Finance Attorney Recreation Community Dev. Municipal Court Police Fire Tech. & Innovation Public Works Park Maintenance Street Maint & Ops Dept 20 $91 $112 $829 $908 I$162 $189 $863 $972 �$93 $127 MI $703 $683 $776 $830 $292 $321 $4,471 .1344 $491 $950 $966 III $355 $310 $896 $908 747 $928 $0 $1,000 $2,000 $3,052 $3,001 $3,000 $4,000 • Year to Date • •Allocated Budget $4,888 $5,000 $6,000 Thousands • Recreation is currently exceeding budget by $20 thousand. Administration salaries and benefits are greater than 2016 due to being fully staffed in 2017. Supplies are higher than normal due to costs associated with the 20 -year Gala celebration. The department also incurred expenses related to the Teen visit to Olympia, these costs were funded through a grant/donation from World Vision. • Fire department has exceeded budget by $51 thousand. This is attributed to the staffing of the unbudgeted pipeline positions (5 vs 3 in 2016) to maintain minimum staffing levels. Overtime is now in line with budget with an overspend of two thousand year -to -date. • Park department has exceeded budget by $45 thousand. This is a result of the department being fully staffed in 2017 compared to 2016. They also incurred a higher level of spending on supplies as they are being more proactive and intentional in the planning and preparation for busier summer months. 46 INFORMATIONAL MEMO Page 5 Fund Summary The chart below is a summary of ending balances for each of the fund types as of March 31,2017. Fund Summary General) Contingency Special Revenue Capital Projects Enterprise Internal Service Debt Beginning Fund Balance 17,890,260 1,466,097 45,948,009 17,240,620 6,770,635 1,292,357 Revenues 13,545,408 155,496 2,012,671 7,227,921 2,230,409 677,049 Expenditures (14,622,536) (66,815) (991,423) (4,782,697) (2,071,510) (877,117) Ending Fund Balance 16,813,131 1,554,778 46,969,257 19,685,844 6,929,534 1,092,290 General /Continaenc General Fund General Contingency Beginning Fund Balance 11,839,636 6,050,624 Revenues 13,541,456 3,951 Expenditures (14,622,536) - Ending Fund Balance 10,758,556 6,054,575 Special Revenue Funds: Special revenue funds account for revenue sources and expenditures that are legally restricted to a specific purpose. The City has two special revenue funds: Lodging tax and Seizure. The Lodging tax fund receives a special excise tax on lodging charges and is used to promote tourism. The seizure fund accounts for the yearly accumulation of drug seizure funds and is used for seizure related expenditures. Through the end of March 2017, revenues exceeded expenditures in the Lodging tax fund. Expenditures for the Seizure fund are greater than revenue by $9 thousand. In 2017 expenditures in the Seizure fund will exceed revenues due to amounts received in 2016 from the Motel raid in 2013. Special Revenue Funds Lodging Tax Seizure Beginning Fund Balance 912,558 553,539 Revenues 126,667 28,829 Expenditures (28,925) (37,890) Ending Fund Balance 1,010,300 544,478 47 INFORMATIONAL MEMO Page 6 Capital Projects Funds The City has six capital projects funds. Revenue and expenditure details for the funds are as follows: Capital Project Funds Residential Streets Arterial Streets Land Acq, Rec. & Park Dev. Facility Replacement Gen Gov't Improvements Fire Impact Fees Public Safety Plan City Facilities Beginning Fund Balance 659,932 3,999,376 3,352,113 295,040 391,903 736,518 36,513,127 - Revenues 86,956 1,356,448 522,331 1,281 541 17,165 27,950 - Ependitures (115,600) (668,120) (56,276) (5,613) (32,645) - (73,615) (39,555) Ending Fund Balance 631,288 4,687,704 3,818,168 290,709 359,798 753,683 36,467,462 (39,555) Through March 2017, the major project in the arterial street fund is the TUC Pedestrian /Bicycle Bridge project, which had expenditures of $431 thousand. Several other projects had activity as well during the first quarter. Arterial Streets received $521 thousand in REET and $621 thousand from WSDOT for the regional mobility grant. Land Acq, Recreation & Parks Development received $521 thousand in REET during the quarter. Enterprise Funds The City's four enterprise funds account for operations with revenues primarily provided from user fees, charges, or contracts for services. The City has three utilities and one golf course. The following chart summaries activity for the first quarter: Enterprise Funds Water Sewer Foster Golf Surface Water Beginning Fund Balance 6,692,750 7,826,985 117,982 2,602,903 Revenues 1,435,579 2,554,388 155,477 3,082,477 Expenditures (1,347,392) (2,086,048) (407,036) (942,221) Ending Fund Balance 6,780,938 8,295,325 (133,578) 4,743,159 Revenue for the golf course is weather dependent and is typically lower during the winter months while expenditures remain consistent throughout the year. Surface water revenues are high due to billing twice a year in January and June while expenses remain consistent throughout the year. Internal Service Funds Internal service funds provide services to other City departments and include functions such as employee and LEOFF 1 retiree medical insurance as well as equipment rental and replacement. Through the end of March, all internal service funds have sufficient funds to meet expenses. 48 Self Insured Self Insured Internal Service Funds Fleet Healthcare - Healthcare - Actives Retirees Beginning Fund Balance 4,393,334 1,494,823 882,478 Revenues 671,647 1,493,892 64,870 Expenditures (515,817) (1,456,291) (99,402) Ending Fund Balance 4,549,163 1,532,425 847,945 48 GENERAL FUND CITY OF TUKWILA GENERAL FUND REVENUES YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY REVENUE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 OVER /(UNDER) %REC'D % CHANGE ALLOCATED BDGT 2015/2016 2016/2017 PROPERTY TAX 14,906,636 524,344 423,048 509,856 551,381 27,036 4% 21% 8% SALES TAX 20,026,555 5,328,605 4,881,098 5,024,022 4,905,073 (423,531) 24% 3% (2)% ADMISSIONS TAX 760,000 201,667 141,652 182,799 218,042 16,375 29% 29% 19% UTILITY TAX 4,118,053 1,196,074 1,076,941 1,166,296 1,178,645 (17,429) 29% 8% 1% INTERFUND UTILITY TAX 2,161,000 638,036 582,842 628,802 679,700 41,664 31% 8% 8% GAMBLING & EXCISE TAX 3,931,400 790,104 701,054 764,327 957,379 167,274 24% 9% 25% TOTAL GENERAL REVENUE 45,903,644 8,678,830 7,806,636 8,276,101 8,490,219 (188,611) 18% 6% 3% RGRL 1,900,000 1,819,498 1,755,630 1,732,899 1,663,048 (156,449) 88% (1)% (4)% BUSINESS LICENSES 873,640 537,186 522,411 507,250 482,467 (54,719) 55% (3)% (5)% RENTAL HOUSING 45,000 29,326 34,950 29,710 37,750 8,424 84% (15)% 27% BUILDING PERMITS 1,389,600 339,723 333,283 320,629 300,046 (39,677) 22% (4)% (6)% TOTAL LICENSES AND PERMITS 4,208,240 2,725,732 2,646,274 2,590,489 2,483,312 (242,421) 59% (2) % (4) % SALES TAX MITIGATION 1,140,000 287,483 284,506 282,954 273,006 (14,477) 24% (1)% (4)% FRANCHISE FEE 2,199,500 555,051 612,652 528,425 438,370 (116,681) 20% (14)% (17)% GRANT 553,591 56,421 33,027 74,420 86,352 29,931 16% 125% 16% STATE ENTITLEMENTS 416,533 73,561 91,731 74,220 75,534 1,973 18% (19)% 2% INTERGOVERNMENTAL 553,626 431,364 6,182 6,530 432,284 920 78% 6% 6520% TOTAL INTERGOVERNMENTAL REVENUE 4,863,250 1,403,880 1,028,098 966,549 1,305,546 (98,334) 27% (6)% 35% GENERAL GOVERNMENT 35,265 9,029 10,762 9,693 8,636 (393) 24% (10)% (11)% SECURITY 685,726 131,188 105,388 135,682 124,597 (6,591) 18% 29% (8)% TRANSPORTATION 109,000 8,046 3,045 7,763 - (8,046) 0% 155% (100)% PLAN CHECK AND REVIEW FEES 905,090 159,292 243,611 210,894 166,641 7,349 18% (13)% (21)% CULTURE AND REC FEES 636,840 119,787 85,567 112,455 92,309 (27,478) 14% 31% (18)% TOTAL CHARGES FOR SERVICES 2,371,921 427,342 448,373 476,488 392,184 (35,158) 17% 6% (18)% FINES & PENALTIES 266,829 43,439 28,428 44,552 37,059 (6,380) 14% 57% (17)% MISC 972,749 233,497 189,147 253,838 263,373 29,876 27% 34% 4% INDIRECT COST ALLOCATION 2,279,058 569,765 563,830 558,369 569,765 0 25% (1) % 2% TOTAL OTHER INCOME 3,518,636 846,701 781,406 856,759 870,196 23,496 66% 90% -11% TOTAL OPERATING REVENUE 60,865,691 14,082,486 12,710,786 13,166,386 13,541,456 (541,030) 22% 4% 3% TRANSFERS IN (TUKWILA VILLAGE) 1,800,000 - - - - - 0% 0% 0% TOTAL REVENUE 62,665,691 14,082,486 12,710,786 13,166,386 13,541,456 (541,030) 22% 4% 3% 49 GENERAL FUND CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY OF EXPENDITURES BY DEPARTMENT BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPENT 2015/2016 2016/2017 01 City Council 366,016 111,751 87,030 91,489 90,859 (20,891) 25% 5% (1)% 03 Mayor 4,079,582 907,862 762,754 928,959 829,311 (78,551) 20% 22% (11)% 04 Human Resources 706,208 188,676 154,273 162,413 161,696 (26,981) 23% 5% (0)% 05 Finance 2,638,813 971,525 810,325 830,197 863,462 (108,063) 33% 2% 4% 06 Attorney 716,955 126,908 94,332 93,698 92,849 (34,059) 13% (1)% (1)% 07 Recreation 3,384,688 682,743 646,429 662,613 702,517 19,774 21% 3% 6% 08 Community Development 3,693,338 830,165 688,099 712,875 776,030 (54,135) 21% 4% 9% 09 Municipal Court 1,307,808 320,810 277,147 282,096 291,716 (29,094) 22% 2% 3% 10 Police 18,288,092 4,888,466 4,442,286 4,817,812 4,471,044 (417,422) 24% 8% (7)% 11 Fire 11,862,568 3,000,814 3,037,816 2,853,633 3,051,847 51,033 26% (6)% 7% 12 Technology & Innovation Svcs 2,026,820 490,931 242,602 337,848 343,540 (147,391) 17% 39% 2% 13 Public Works 3,802,639 966,095 939,073 946,963 950,251 (15,844) 25% 1% 0% 15 Park Maintenance 1,418,760 310,072 321,829 287,581 355,149 45,077 25% (11)% 23% 16 Street Maintenance & Operations 3,109,592 907,633 770,811 863,251 895,764 (11,869) 29% 12% 4% 20 Dept20 5,237,691 928,473 764,962 843,708 746,501 (181,972) 14% 10% (12)% Total Expenditures 62,639,570 15,632,925 14,039,767 14,715,134 14,622,536 (1,010,389) 23% 5% (1)% Percent of year completed 50 25.00% GENERAL FUND CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY OF SALARIES AND BENEFITS BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPENT 2015/2016 2016/2017 11 Salaries 27,560,991 6,944,717 6,388,727 6,626,030 6,707,363 (237,353) 24% 4% 1% 12 Extra Labor 777,897 132,606 96,894 129,594 120,422 (12,185) 15% 34% (7)% 13 Overtime 1,632,035 349,142 429,213 319,509 405,308 56,165 25% (26)% 27% 15 Holiday Pay 525,583 3,177 1,124 3,286 1,394 (1,783) 0% 192% (58)% 21 FICA 1,809,260 450,753 411,143 424,605 433,168 (17,585) 24% 3% 2% 22 Pension -LEOFF 2 849,253 200,017 189,887 196,349 199,023 (994) 23% 3% 1% 23 Pension - PERS /PSERS 1,580,986 386,455 278,828 337,406 359,165 (27,290) 23% 21% 6% 24 Industrial Insurance 864,098 194,938 134,955 156,232 148,586 (46,353) 17% 16% (5)% 25 Medical & Dental 5,903,094 1,482,894 1,317,996 1,406,860 1,405,462 (77,432) 24% 7% (0)% 26 Unemployment 13,000 - 1,285 10,624 471 471 4% 727% (96)% 28 Uniform /Clothing 10,460 1,503 1,459 777 642 (861) 6% (47)% (17)% Total Salaries and Benefits 41,526,657 10,146,203 9,251,511 9,611,271 9,781,003 (365,200) 24% 4% 2% Percent of year completed 25.00 SUMMARY OF SUPPLIES, SERVICES, AND CAPITAL BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER (UNDER) % CHANGE ALLOCATED BDGT % SPENT 2015/2016 2016/2017 Transfers 5,237,691 928,473 764,962 843,708 746,501 (181,972) 14% 10% (12)% 31 Supplies 1,164,823 239,414 301,897 244,428 264,089 24,675 23% (19)% 8% 34 Items Purchased for resale 22,000 69 428 (1,115) 69 - 0% (360)% (106)% 35 Small Tools 99,818 20,583 178,557 9,018 22,445 1,862 22% (95)% 149% 41 Professional Services 3,266,711 453,523 368,131 421,757 381,588 (71,935) 12% 15% (10)% 42 Communication 449,970 82,161 77,605 74,082 74,357 (7,804) 17% (5)% 0% 43 Travel 192,380 64,459 33,593 48,346 49,857 (14,602) 26% 44% 3% 44 Advertising 51,500 9,822 3,304 7,844 5,593 (4,228) 11% 137% (29)% 45 Rentals and Leases 2,314,372 754,132 655,523 654,468 538,074 (216,058) 23% (0)% (18)% 46 Insurance 886,895 879,866 779,175 804,035 880,875 1,009 99% 3% 10% 47 Public Utilities 1,893,570 631,369 509,917 608,221 649,379 18,010 34% 19% 7% 48 Repairs and Maintenance 732,613 138,515 193,453 127,070 148,698 10,183 20% (34)% 17% 49 Miscellaneous 1,562,773 455,170 261,706 290,028 262,419 (192,751) 17% 11% (10)% 51 Inter - Governmental 3,003,792 819,172 660,000 731,296 800,674 (18,498) 27% 11% 9% 53 Ext Taxes, Oper. Assess 5 - 5 6 31 31 611% 17% 391% 64 Machinery & Equipment 234,000 9,995 - 240,671 16,885 6,890 7% - (93)% Total Supplies, Services, and Capital 21,112,913 5,486,722 4,788,256 5,103,863 4,841,534 (645,188) 23% 7% (5)% Percent of year completed 25.00% 51 CITY COUNCIL CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 199,767 48,611 45,204 47,169 49,344 733 25% 4% 5% 21 FICA 15,680 3,819 3,549 3,708 3,884 65 25% 4% 5% 23 Pension - PERS /PSERS 11,386 2,748 1,911 2,416 2,582 (166) 23% 26% 7% 24 Industrial Insurance 2,823 657 567 581 548 (109) 19% 2% (6)% 25 Medical & Dental 59,090 14,279 13,601 13,090 14,757 479 25% (4)% 13% Total Salaries & Benefits 288,746 70,112 _ 64,833 66,963 71,116 1,003 25% 3% 6% 31 Supplies 4,370 2,128 1,927 1,911 330 (1,798) 8% (1)% (83)% 41 Professional Services 16,500 12,961 5,159 1,465 - (12,961) - (72)% - 42 Communication 6,000 2,176 1,080 1,637 296 (1,880) 5% 52% (82)% 43 Travel 40,000 21,573 13,977 16,713 16,880 (4,693) 42% 20% 1% 49 Miscellaneous 10,400 2,801 54 2,800 2,239 (562) 22% 5110% -20% Total Operating Expenses 77,270 41,638 22,197 24,526 19,744 (21,894) 26% 10% (19)% _ Total Expenses 366,016 111,751 87,030 91,489 90,859 (20,891) 25% 5% (1)% Percent of year completed 52 25.00% MAYOR CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT %SPEND 2015/2016 2016/2017 11 Salaries 1,508,785 376,739 359,132 364,453 365,156 (11,583) 24% 1% 0% 12 Extra Labor 53,500 7,552 - 520 7,088 (464) 13% - 1263% 13 Overtime 532 - - - - - - - - 21 FICA 112,437 29,053 26,982 27,723 28,306 (747) 25% 3% 2% 23 Pension - PERS /PSERS 180,721 44,277 32,822 39,000 40,507 (3,770) 22% 19% 4% 24 Industrial Insurance 5,647 1,395 1,077 1,132 1,477 83 26% 5% 31% 25 Medical & Dental 295,280 74,825 61,587 68,588 73,829 (996) 25% 11% 8% Total Salaries & Benefits 2,156,902 533,841 481,600 501,417 516,363 (17,477) 24% 4% 3% 31 Supplies 59,544 11,266 9,242 9,907 7,572 (3,694) 13% 7% (24)% 35 Small Tools 5,500 - 1,852 - - - - - - 41 Professional Services 1,169,970 188,531 159,593 182,688 171,013 (17,518) 15% 14% (6)% 42 Communication 112,600 11,296 10,929 10,441 9,050 (2,246) 8% (4)% (13)% 43 Travel 41,550 19,084 7,118 15,692 6,153 (12,932) 15% 120% (61)% 44 Advertising 19,750 2,695 1,981 999 1,452 (1,244) 7% (50)% 45% 45 Rentals and Leases 39,580 5,561 6,877 5,105 9,920 4,359 25% (26)% 94% 48 Repairs and Maintenance 32,460 8,574 565 16,842 581 (7,993) 2% 2880% (97)% 49 Miscellaneous 404,726 125,446 81,955 127,554 105,591 (19,855) 26% 56% (17)% 51 Inter - Governmental 37,000 1,568 1,041 1,614 1,616 48 4% 55% 0% Total Operating Expenses 1,922,680 374,021 281,153 427,542 312,948 (61,073) 16% 52% (27)% Total Expenses 4,079,582 907,862 762,754 928,959 829,311 (78,551) 20% 22% (11)% Percent of year completed MAYOR DIVISION SUMMARY 25.00°% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY DIVISION BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 ADMINISTRATION 937,912 230,242 303,544 226,104 235,727 5,485 25% (26)% 4% ECONOMIC DEVELOPMENT 374,142 118,775 19,383 136,289 100,283 (18,492) 27% 603% (26)% CITY CLERK 762,873 182,999 145,251 232,091 143,952 (39,046) 19% 60% (38)% COMMUNICATIONS 629,027 131,316 91,597 92,229 130,913 (404) 21% 1% 42% HUMAN SERVICES 813,515 146,541 121,787 147,717 135,855 (10,686) 17% 21% (8)% COURT DEFENDER 477,000 83,080 74,329 80,491 79,189 (3,891) 17% 8% (2)% SISTER CITIES COMM. 6,475 5,550 - 8,154 - (5,550) - - - PLANNING COMMISSION 3,750 - 4,172 - - - - - - EQUITY & DIVERSITY COMMISSION 3,200 2,044 - 30 44 (2,000) 1% - 46% ARTS COMMISSION 5,000 1,217 1,041 1,250 1,269 52 25% 20% 2% PARKS COMMISSION 3,688 2,634 1,054 1,826 650 (1,984) 18% 73% (64)% LIBRARY ADVISORY BOARD 5,000 1,197 526 839 250 (947) 5% 60% (70)% COMMUNITY PROMOTION 26,000 1,915 70 1,575 832 (1,083) 3% 2150% (47)% VOTER REGISTRATION COSTS 32,000 351 - 364 347 (4) 1% - (5)% Total Expenses 4,079,582 907,862 762,754 928,959 829,311 (78,551) 20% 22% (11)% Percent of year completed 25.00% 53 MAYOR ADMINISTRATION YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 356,437 86,565 166,781 84,609 89,059 2,495 25% (49)% 5% 12 Extra Labor 5,000 1,102 - 520 638 (464) 13% - 23% 21 FICA 23,751 6,445 12,621 6,930 7,335 891 31% (45)% 6% 23 Pension - PERS /PSERS 42,361 8,712 15,278 7,942 9,856 1,144 23% (48)% 24% 24 Industrial Insurance 1,059 257 417 230 199 (57) 19% (45)% (13)% 25 Medical & Dental 75,374 18,732 22,374 17,654 19,169 437 25% (21)% 9% Total Salaries & Benefits 503,982 121,811 217,471 117,884 126,257 4,445 25% (46)% 7% 31 Supplies 17,200 3,928 3,990 4,075 2,928 (1,000) 17% 2% (28)% 41 Professional Services 190,000 17,404 6,790 15,309 15,912 (1,492) 8% 125% 4% 42 Communication - - 168 - 58 58 - - - 43 Travel 20,000 6,786 5,469 4,699 3,272 (3,514) 16% (14)% (30)% 45 Rentals and Leases 25,480 4,543 3,986 4,117 7,011 2,468 28% 3% 70% 48 Repairs and Maintenance 3,250 - - - - - - - (45)% 49 Miscellaneous 178,000 75,768 65,671 80,019 80,288 4,520 45% 22% 0% Total Operating Expenses 433,930 108,430 86,074 108,220 109,470 1,039 25% 26% 1% Total Expenses 937,912 230,242 303,544 226,104 235,727 5,485 25% (26)% 4% Percent of year completed MAYOR ECONOMIC DEVELOPMENT 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT %SPEND 2015/2016 2016/2017 11 Salaries 247,021 67,936 - 85,166 61,732 (6,203) 25% - (28)% 12 Extra Labor 8,000 6,450 - - 6,450 - 81% - - 21 FICA 17,741 5,247 - 6,382 5,111 (136) 29% - (20)% 23 Pension - PERS /PSERS 29,655 8,594 - 9,522 6,890 (1,704) 23% - (28)% 24 Industrial Insurance 706 204 - 213 590 386 84% - 177% 25 Medical & Dental 21,269 6,812 - 8,820 5,208 (1,604) 24% - (41)% Total Salaries & Benefits 324,392 95,244 - 110,102 85,983 (9,261) 27% - (22)% 31 Supplies 1,000 441 59 526 103 (338) 10% 789% (80)% 41 Professional Services 16,000 5,466 10,500 5,500 7,974 2,509 50% (48)% 45% 43 Travel 6,000 520 956 77 275 (245) 5% (92)% 257% 44 Advertising 2,000 - 346 - - - - - - 49 Miscellaneous 24,750 17,105 7,522 20,084 5,949 (11,156) 24% 167% (70)% Total Operating Expenses 49,750 23,531 19,383 26,187 14,301 (9,231) 29% 35% (45)% Total Expenses 374,142 118,775 19,383 136,289 100,283 (18,492) 27% 603% (26)% Percent of year completed 54 25.00% MAYOR CITY CLERK YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 371,475 93,279 90,597 91,290 86,477 (6,802) 23% 1% (5)% 12 Extra Labor 35,000 - - - - - - - - 21 FICA 30,511 7,690 6,742 6,779 6,373 (1,317) 21% 1% (6)% 23 Pension - PERS /PSERS 44,598 11,626 8,277 10,123 9,592 (2,034) 22% 22% (5)% 24 Industrial Insurance 1,764 435 335 341 307 (128) 17% 2% (10)% 25 Medical & Dental 92,996 23,230 20,038 21,555 25,285 2,054 27% 8% 17% Total Salaries & Benefits 576,344 136,260 125,989 130,088 128,034 (8,226) 22% 3% (2)% 31 Supplies 12,308 3,641 2,471 3,006 2,886 (755) 23% 22% (4)% 41 Professional Services 6,000 1,500 811 524 570 (930) 10% (35)% 9% 42 Communication 72,600 10,366 9,856 9,810 6,810 (3,556) 9% (0)% (31)% 43 Travel 5,500 4,578 140 1,691 1,055 (3,523) 19% 1108% (38)% 44 Advertising 12,300 2,695 1,635 999 1,452 (1,244) 12% (39)% 45% 45 Rentals and Leases 10,100 17 1,913 10 1,913 1,895 19% (99)% 19280% 48 Repairs and Maintenance 24,710 8,574 565 16,842 581 (7,993) 2% 2880% (97)% 49 Miscellaneous 43,011 15,367 1,872 12,421 651 (14,716) 2% 564% (95)% 64 Machinery & Equipment - - - 56,700 - - - - - Total Operating Expenses 186,529 46,739 19,262 102,003 15,918 (30,820) 9% 430% (84)% Total Expenses 762,873 182,999 145,251 232,091 143,952 (39,046) 19% 60% (38)% Percent of year completed MAYOR COMMUNICATIONS 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT %SPEND 2015/2016 2016/2017 11 Salaries 359,745 84,909 58,197 59,650 83,976 (932) 23% 2% 41% 12 Extra Labor 5,000 - - - - - - - - 21 FICA 27,176 6,358 4,357 4,376 6,188 (171) 23% 0% 41% 23 Pension - PERS /PSERS 43,205 10,120 5,299 6,603 9,327 (794) 22% 25% 41% 24 Industrial Insurance 1,412 344 200 220 258 (87) 18% 10% 17% 25 Medical & Dental 72,989 17,895 12,067 12,987 17,089 (805) 23% 8% 32% Total Salaries & Benefits 509,527 119,626 80,120 83,836 116,838 (2,789) 23% 5% 39% 31 Supplies 9,000 627 1,642 1,046 638 11 7% (36)% (39)% 35 Small Tools 5,500 - 1,852 - - - - - - 41 Professional Services 35,000 4,160 - - 4,160 - 12% - - 42 Communication 40,000 930 905 631 2,182 1,252 5% (30)% 245% 43 Travel 4,000 2,150 538 1,570 1,551 (599) 39% 192% (1)% 44 Advertising 5,000 - - - - - - - - 45 Rentals and Leases 4,000 1,000 979 979 996 (4) 25% 0% 2% 48 Repairs and Maintenance 2,000 - - - - - - - - 49 Miscellaneous 15,000 2,823 5,561 4,167 4,549 1,725 30% (25)% 9% Total Operating Expenses 119,500 11,690 11,478 8,393 14,075 2,385 12% (27)% 68% Total Expenses 629,027 131,316 91,597 92,229 130,913 (404) 21% 1% 42% Percent of year completed 25.00% 55 MAYOR HUMAN SERVICES YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) ACTUAL % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 174,107 44,052 43,558 43,738 43,911 (140) 25% 0% 0% 12 Extra Labor 500 - - - - - 17% - - 13 Overtime 532 - - - - - - - - 21 FICA 13,258 3,313 3,261 3,257 3,298 (14) 25% (0)% 1% 23 Pension - PERS /PSERS 20,902 5,224 3,968 4,810 4,841 (383) 23% 21% 1% 24 Industrial Insurance 706 154 125 127 123 (31) 17% 1% (3)% 25 Medical & Dental 32,652 8,156 7,108 7,573 7,078 (1,078) 22% 7% (7)% Total Salaries & Benefits 242,657 60,899 58,021 59,506 59,252 (1,647) 24% 3% (0)% 31 Supplies 1,688 258 153 164 97 (161) 6% 7% (41)% 41 Professional Services 433,470 76,921 67,164 80,864 63,683 (13,238) 15% 20% (21)% 43 Travel 500 - 15 - - - - - - 49 Miscellaneous 135,200 8,463 (3,566) 7,183 12,824 4,360 9% (301)% 79% Total Operating Expenses 570,858 85,642 63,766 88,211 76,603 (9,039) 13% 38% (13)% Total Expenses 813,515 146,541 121,787 147,717 135,855 (10,686) 17% 21% (8)% Percent of year completed MAYOR COURT DEFENDER 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) ACTUAL % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 31 Supplies 41 Professional Services - 477,000 - 83,080 - 74,329 - 80,491 475 78,714 475 (4,366) - 17% - 8% - (2)% Total Operating Expenses 477,000 83,080 74,329 80,491 79,189 (3,891) 17% 8% (2)% 2017 BDGT %SPEND 2015/2016 2016/2017 31 Supplies 425 - - - - Total Expenses 477,000 83,080 74,329 80,491 79,189 (3,891) 17% 8% (2)% Percent of year completed MAYOR SISTER CITIES COMM. 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 Percent of year completed 56 25.00% BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY BY EXPENDITURE ACTUAL TYPE OVER /(UNDER) % CHANGE ALLOCATED 2017 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT %SPEND 2015/2016 2016/2017 31 Supplies 425 - - - - - - - 41 Professional Services 500 - - - - - - - 43 Travel 5,050 5,050 - 7,654 - (5,050) - - - 49 Miscellaneous 500 500 - 500 - (500) - - - Total Operating Expenses 6,475 5,550 - 8,154 - (5,550) . Total Expenses 6,475 5,550 - 8,154 - (5,550) - - - Percent of year completed 56 25.00% MAYOR PLANNING COMMISSION YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) 2017 % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 31 Supplies 43 Travel 49 Miscellaneous 1,000 500 2,250 - - - 347 - 3,825 - - - - - - - - - - - - - - - - - - Total Operating Expenses 3,750 - 4,172 - - - _ _ _ 25% 30 2% 44 (2,000) 1% - 46% Total Expenses 3,750 - 4,172 - - - - - - Percent of year completed MAYOR EQUITY & DIVERSITY COMMISSION 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 ACTUAL OVER /(UNDER) 2017 % CHANGE ACTUAL OVER /(UNDER) % SPEND % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 31 Supplies 49 Miscellaneous 1,200 2,000 44 2,000 - - 52 - 30 20% 44 - - (2,000) 4% - - - - - Total Operating Expenses 3,200 2,044 - 25% 30 2% 44 (2,000) 1% - 46% Total Expenses 5,000 1,217 1,041 1,250 Total Expenses 3,200 2,044 - 2% 30 44 (2,000) 1% - 46% Percent of year completed MAYOR ARTS COMMISSION 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 51 Inter - Governmental 5,000 1,217 1,041 1,250 1,269 52 25% 20% 2% Total Operating Expenses 5,000 1,217 1,041 1,250 1,269 52 25% 20% 2% Total Expenses 5,000 1,217 1,041 1,250 1,269 52 25% 20% 2% Percent of year completed 25.00% 57 MAYOR PARKS COMMISSION YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) 2016 % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 31 Supplies 49 Miscellaneous 1,688 2,000 979 1,655 54 1,000 251 1,575 - 650 (979) (1,005) - 33% 368% - 58% (59)% Total Operating Expenses 3,688 2,634 1,054 1,826 650 (1,984) 18% 73% (64)% 5,000 1,197 526 ALLOCATED 839 - (5)% 250 (947) Total Expenses 3,688 2,634 1,054 1,826 650 (1,984) 18% 73% (64)% Percent of year completed MAYOR LIBRARY ADVISORY BOARD 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL ACTUAL COMPARISON OF RESULTS COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) TYPE % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 31 Supplies 5,000 1,197 364 526 ALLOCATED 839 1% 250 (947) 5% 60% (70)% Total Operating Expenses 5,000 1,197 526 ALLOCATED 839 - (5)% 250 (947) 5% 60% (70)% 2015/2016 2016/2017 31 Supplies 9,035 152 - - 152 - 2% - - 41 Professional Services Total Expenses 5,000 1,197 - 526 - 839 - 250 (947) 5% 60% (70)% Percent of year completed MAYOR COMMUNITY PROMOTION 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 Percent of year completed MAYOR VOTER REGISTRATION COSTS 25.00°% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL ACTUAL COMPARISON OF RESULTS SUMMARY BY EXPENDITURE 2017 ALLOCATED 2015 2016 2017 ACTUAL % CHANGE TYPE % SPEND 2015/2016 2016/2017 51 Inter - Governmental 32,000 351 - OVER /(UNDER) 364 % CHANGE ALLOCATED (4) 1% - (5)% Total Operating Expenses 2017 351 - 364 2017 ANNUAL ALLOCATED 2015 - (5)% 2016 2017 BDGT % SPEND 2015/2016 2016/2017 31 Supplies 9,035 152 - - 152 - 2% - - 41 Professional Services 12,000 - 347 - - - - - - - 44 Advertising 450 - - - - - - - 48 Repairs and Maintenance 2,500 - - - - - - - - 49 Miscellaneous 2,015 1,763 70 1,575 680 (1,083) 34% 2150% (57)% Total Operating Expenses 26,000 1,915 70 1,575 832 (1,083) 3% 2150% (47)% Total Expenses 26,000 1,915 70 1,575 832 (1,083) 3% 2150% (47)% Percent of year completed MAYOR VOTER REGISTRATION COSTS 25.00°% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 51 Inter - Governmental 32,000 351 - 364 347 (4) 1% - (5)% Total Operating Expenses 32,000 351 - 364 347 (4) 1% - (5)% Total Expenses 32,000 351 - 364 347 (4) 1% - (5)% Percent of year completed 58 25.00% HUMAN RESOURCES CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 405,299 104,695 101,817 102,578 102,556 (2,139) 25% 1% (0)% 12 Extra Labor 6,000 - - - - - - - 21 FICA 28,947 7,729 7,444 7,473 7,465 (263) 26% 0% (0)% 23 Pension - PERS /PSERS 48,653 12,787 9,252 11,287 11,289 (1,498) 23% 22% 0% 24 Industrial Insurance 1,417 354 268 275 257 (97) 18% 3% (7)% 25 Medical & Dental 77,642 21,072 16,009 17,202 15,610 (5,462) 20% 7% (9)% Total Salaries & Benefits 567,958 146,637 134,790 138,815 137,177 (9,460) 24% 3% (1)% 31 Supplies 14,817 2,555 2,092 1,610 5,334 2,779 36% (23)% 231% 41 Professional Services 90,575 15,021 1,687 13,815 7,546 (7,475) 8% 719% (45)% 42 Communication 50 - - - - - - - - 43 Travel 3,000 1,837 683 577 - (1,837) - (16)% - 44 Advertising 6,250 3,464 850 3,625 1,083 (2,381) 17% 326% (70)% 45 Rentals and Leases 5,108 713 522 522 351 (363) 7% 0% (33)% 48 Repairs and Maintenance 14,000 14,000 12,062 2,790 - (14,000) - (77)% - 49 Miscellaneous 4,450 4,450 1,587 659 10,205 5,755 229% (58)% 1448% Total Operating Expenses 138,250 42,039 19,483 23,598 24,518 (17,521) 18% 21% 4% Total Expenses 706,208 188,676 154,273 162,413 161,696 (26,981) 23% 5% (0)% Percent of year completed 25.00% 59 FINANCE CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 1,053,485 277,013 259,317 259,304 259,442 (17,571) 25% (0)% 0% 12 Extra Labor 60,000 - 2,076 - - - - - - 13 Overtime 9,289 428 1,057 344 2,854 2,427 31% (67)% 730% 21 FICA 79,621 21,260 19,604 19,626 19,851 (1,409) 25% 0% 1% 23 Pension - PERS /PSERS 127,773 33,357 23,054 28,971 29,190 (4,167) 23% 26% 1% 24 Industrial Insurance 4,235 1,076 795 830 740 (337) 17% 4% (11)% 25 Medical & Dental 223,559 57,534 46,719 48,500 53,047 (4,486) 24% 4% 9% 26 Unemployment 13,000 - - - - - - - - Total Salaries & Benefits 1,570,962 390,668 352,622 357,574 365,124 (25,545) 23% 1% 2% 31 Supplies 19,000 2,838 4,264 3,929 1,493 (1,345) 8% (8)% (62)% 35 Small Tools 5,000 - - - - - - - - 41 Professional Services 170,000 12,540 10,596 10,354 19,646 7,106 12% (2)% 90% 42 Communication 1,000 - (2) - - - - - - 43 Travel 10,000 1,659 132 762 2,924 1,264 29% 476% 284% 45 Rentals and Leases 3,500 875 821 821 274 (601) 8% 0% (67)% 46 Insurance 351,826 344,797 340,296 331,775 345,340 543 98% (3)% 4% 48 Repairs and Maintenance 65,625 65,625 57,278 59,781 66,785 1,160 102% 4% 12% 49 Miscellaneous 441,900 152,523 44,316 65,200 61,875 (90,647) 14% 47% (5)% 53 Ext Taxes, Oper. Assess - - 1 - 2 2 - - - Total Operating Expenses 1,067,851 580,857 457,703 472,622 498,339 (82,518) 47% 3% 5% Total Expenses 2,638,813 971,525 810,325 830,197 863,462 (108,063) 33% 2% 4% Percent of year completed 60 25.00% ATTORNEY CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT °A SPEND 2015/2016 2016/2017 12 Extra Labor 5,000 1,244 624 624 648 (596) 13% 0% 4% 21 FICA 355 88 48 48 50 (39) 14% 0% 4% 24 Industrial Insurance 100 25 8 8 8 (17) 8% 4% (4)% Total Salaries & Benefits 5,455 1,357 , 679 680 705 (652) 13% 0% 4% 31 Supplies 6,000 2,026 1,501 1,631 289 (1,737) 5% 9% (82)% 41 Professional Services 701,000 122,452 92,152 91,387 90,782 (31,670) 13% (1)% (1)% 45 Rentals and Leases 2,100 1,073 - - 1,073 - 51% - - 48 Repairs and Maintenance 1,400 - - - - - - - - 49 Miscellaneous 1,000 - - - - - - - - Total Operating Expenses 711,500 125,551 93,653 93,018 92,144 (33,407) 13% (1)% (1)% Total Expenses 716,955 126,908 94,332 93,698 92,849 (34,059) 13% (1)% (1)% Percent of year completed 25.00% 61 RECREATION DEPARTMENT CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 1,400,656 335,580 326,964 319,734 343,299 7,719 25% (2)% 7% 12 Extra Labor 530,643 102,439 77,892 104,225 94,828 (7,611) 18% 34% (9)% 13 Overtime 4,179 438 1,385 423 11 (427) 0% (69)% (97)% 21 FICA 145,838 32,992 30,586 32,066 32,804 (187) 22% 5% 2% 23 Pension - PERS /PSERS 168,165 42,475 32,428 40,099 43,583 1,108 26% 24% 9% 24 Industrial Insurance 84,822 14,503 13,611 16,230 12,994 (1,508) 15% 19% (20)% 25 Medical & Dental 320,924 79,105 70,901 74,062 81,838 2,733 26% 4% 10% 26 Unemployment - - 138 7 404 404 - (95)% 5834% 28 Uniform /Clothing 230 225 197 - 225 - 98% - - Total Salaries & Benefits 2,655,457 607,756 554,103 586,846 609,987 2,230 23% 6% 4% 31 Supplies 125,986 28,250 25,954 23,464 34,602 6,351 27% (10)% 47% 34 Items Purchased for resale 22,000 69 428 (1,115) 69 - 0% (360)% (106)% 35 Small Tools 11,000 - - - - - - 41 Professional Services 208,480 7,268 18,124 15,981 13,730 6,462 7% (12)% (14)% 42 Communication 12,150 1,555 2,293 3,183 1,013 (542) 8% 39% (68)% 43 Travel 8,725 979 497 691 5,783 4,804 66% 39% 737% 44 Advertising 22,500 3,609 473 2,757 3,005 (604) 13% 483% 9% 45 Rentals and Leases 48,590 10,021 11,778 12,153 9,063 (958) 19% 3% (25)% 48 Repairs and Maintenance 30,400 1,595 10,889 8,052 986 (609) 3% (26)% (88)% 49 Miscellaneous 109,400 11,646 21,888 10,600 14,286 2,640 13% (52)% 35% 64 Machinery & Equipment 130,000 9,995 - - 9,995 - 8% - - Total Operating Expenses 729,231 74,987 92,326 75,766 92,531 17,544 13% (18)% 22% Total Expenses 3,384,688 682,743 646,429 662,613 702,517 19,774 21% 2% 6% Percent of year completed RECREATION DIVISION SUMMARY 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY DIVISION BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 ADMINISTRATION 481,514 83,849 84,791 61,181 102,819 18,970 21% (28)% 68% RECREATION 462,343 101,251 338,788 382,989 104,015 2,764 22% 13% (73)% PRESCHOOL PROGRAM 79,776 24,523 - - 24,523 - 31% - - YOUTH PROGRAMS 564,781 93,715 - - 93,715 - 17% - - TEEN PROGRAMS 201,780 36,370 - - 41,416 5,046 21% - - YOUTH WELLNESS AND ENRICHMEP 148,978 44,867 - - 47,470 2,604 32% - - ADULT WELLNESS AND ENRICHMEN 215,044 38,059 - - 38,059 - 18% - - SENIOR ADULT PROGRAMS 176,287 39,060 - - 39,060 - 22% - - COMMUNITY EVENTS AND VOLUNTE 281,660 52,685 67,860 51,210 42,570 (10,115) 15% (25)% (17)% PLANNING AND BUSINESS OPS 460,559 95,397 - - 95,397 - 21% - - RENTAL OPERATIONS 311,966 72,967 154,990 167,232 73,473 506 24% 8% (56)% Total Expenses 3,384,688 682,743 646,429 662,613 702,517 19,774 21% 3% 6% Percent of year completed 62 25.00% RECREATION ADMINISTRATION YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 248,194 51,539 58,170 42,834 63,223 - 11,683 25% (26)% 48% 12 Extra Labor 5,000 1,254 - 250 1,011 (243) 20% - 304% 13 Overtime 464 - - - - - - - - 21 FICA 16,870 3,833 4,316 3,087 4,596 764 27% (28)% 49% 23 Pension - PERS /PSERS 29,797 6,076 5,357 4,680 6,882 806 23% (13)% 47% 24 Industrial Insurance 1,189 237 123 119 213 (24) 18% (3)% 79% 25 Medical & Dental 32,833 8,884 8,882 7,959 11,285 2,401 34% (10)% 42% Total Salaries & Benefits 334,347 71,823 76,849 58,929 87,209 15,386 26% (23)% 48% 31 Supplies 5,917 651 1,188 772 3,619 2,968 61% (35)% 369% 41 Professional Services 2,500 345 3,030 - 345 - 14% - - 42 Communication - - 492 305 40 40 - (38)% (87)% 43 Travel 2,500 - 16 - - - - - - 45 Rentals and Leases - - 637 637 - - - 0% - 48 Repairs and Maintenance 2,000 - - - - - - - - 49 Miscellaneous 4,250 1,036 2,578 538 1,611 575 38% (79)% 199% 64 Machinery & Equipment 130,000 9,995 - - 9,995 - 8% - - Total Operating Expenses 147,167 12,026 7,942 2,252 15,610 3,583 11% (72)% 593% 19,680 5,946 19% (29)% (43)% Total Expenses 481,514 83,849 84,791 61,181 102,819 18,970 21% (28)% 68% Percent of year completed RECREATION RECREATION 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 193,608 48,262 137,723 165,324 47,460 1 (802) 25% 20% (71)% 12 Extra Labor 70,220 16,156 77,892 88,925 13,988 (2,168) 20% 14% (84)% 13 Overtime - - - - 11 11 - - - 21 FICA 20,093 4,851 16,303 19,329 4,679 (172) 23% 19% (76)% 23 Pension - PERS /PSERS 23,243 5,694 14,866 21,811 6,035 341 26% 47% (72)% 24 Industrial Insurance 12,256 2,681 11,324 13,107 1,885 (796) 15% 16% (86)% 25 Medical & Dental 39,424 9,874 31,862 39,847 9,874 (0) 25% 25% (75)% 26 Unemployment - - 138 7 404 404 - (95)% 5834% Total Salaries & Benefits 358,844 87,517 290,108 348,350 84,334 - (3,183) 24% 20% (76)% 31 Supplies 27,919 6,791 16,119 15,899 5,165 (1,626) 19% (1)% (68)% 34 Items Purchased for resale - - - (1,115) - - - - - 41 Professional Services 22,930 3,103 11,874 13,479 11,466 8,362 50% 14% (15)% 42 Communication 2,850 698 870 805 58 (640) 2% (8)% (93)% 43 Travel 1,800 246 447 691 4 (242) 0% 55% (99)% 44 Advertising 4,800 173 50 45 260 87 5% (10)% 478% 45 Rentals and Leases - - 914 46 - - - (95)% - 48 Repairs and Maintenance - - 422 - - - - - - 49 Miscellaneous 32,200 2,722 17,984 4,791 2,727 _ 5 8% (73)% (43)% Total Operating Expenses 103,499 13,734 48,680 34,640 19,680 5,946 19% (29)% (43)% Total Expenses 462,343 101,251 338,788 382,989 104,015 2,764 22% 13% (73)% Percent of year completed 25.00% 63 RECREATION PRESCHOOL PROGRAM YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 2017 ANNUAL ALLOCATED 2015 2016 2017 OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 37,245 8,908 - - 8,908 - 24% - - 12 Extra Labor 20,900 7,094 - - 7,094 - 34% - - 21 FICA 4,397 1,223 - - 1,223 - 28% - 23 Pension - PERS /PSERS 4,479 1,393 - - 1,393 - 31% - - 24 Industrial Insurance 2,285 569 - - 569 - 25% - - 25 Medical & Dental 370 99 - - 99 - 27% - - Total Salaries & Benefits 69,676 19,285 - - 19,285 - 28% - - 31 Supplies 8,600 4,884 - - 4,884 - 57% - - 41 Professional Services 1,000 - - - - - - - - 49 Miscellaneous 500 354 - - 354 - 71% - - Total Operating Expenses 10,100 5,238 - - 5,238 - 52% - - Total Expenses 79,776 24,523 - - 24,523 - 31% - - Percent of year completed RECREATION YOUTH PROGRAMS 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 2017 ANNUAL ALLOCATED 2015 2016 2017 OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 148,265 37,242 - - 37,242 - 25% - - 12 Extra Labor 230,203 27,843 - - 27,843 - 12% - - 21 FICA 30,327 4,909 - - 4,909 - 16% - - 23 Pension - PERS /PSERS 17,799 5,773 - - 5,773 - 32% - - 24 Industrial Insurance 29,562 3,317 - - 3,317 - 11% - - 25 Medical & Dental 47,525 11,864 - - 11,864 - 25% - - Total Salaries & Benefits 503,681 90,948 - - 90,948 - 18% - - 31 Supplies 20,600 2,758 - - 2,758 - 13% - - 41 Professional Services 24,500 9 - - 9 - 0% - - 49 Miscellaneous 16,000 - - - - - - - - Total Operating Expenses 61,100 2,767 - - 2,767 - 5% - - Total Expenses 564,781 93,715 - - 93,715 - 17% - - Percent of year completed 64 25.00% RECREATION TEEN PROGRAMS YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 66,466 16,260 - - 16,260 - 24% - - 12 Extra Labor 63,850 7,705 - - 7,705 - 12% - - 21 FICA 9,969 1,833 - - 1,833 - 18% - 23 Pension - PERS /PSERS 7,980 2,173 - - 2,173 - 27% - - 24 Industrial Insurance 8,906 1,098 - - 1,098 - 12% - - 25 Medical & Dental 23,729 5,924 - - 5,924 - 25% - - Total Salaries & Benefits 180,900 34,993 - - 34,993 - 19% - - 31 Supplies 7,650 690 - - 690 - 9% - - 41 Professional Services 5,050 9 - - 9 - 0% - - 43 Travel - - - - 5,046 5,046 - - - 45 Rentals and Leases 180 9 - - 9 - 5% - - 49 Miscellaneous 8,000 669 - - 669 - 8% - - Total Operating Expenses 20,880 1,377 - - 6,423 5,046 31% - - Total Expenses 148,978 44,867 - - 47,470 2,604 32% - - Total Expenses 201,780 36,370 - - 41,416 5,046 21% - - Percent of year completed RECREATION YOUTH WELLNESS AND ENRICHMENT 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 66,598 16,323 - - 16,323 1 - 25% - - 12 Extra Labor 12,700 12,700 - - 15,304 2,604 121% - - 21 FICA 6,067 2,419 - - 2,419 - 40% - - 23 Pension - PERS /PSERS 7,995 2,739 - - 2,739 - 34% - - 24 Industrial Insurance 3,962 1,544 - - 1,544 - 39% - - 25 Medical & Dental 16,456 4,106 - - 4,106 - 25% - - Total Salaries & Benefits 113,778 39,831 - - 42,435 2,604 37% _ - ' 31 Supplies 5,600 5,036 - - 5,036 - 90% - - 41 Professional Services 28,900 - - - - - - - - 49 Miscellaneous 700 - - - - - - - - Total Operating Expenses 35,200 5,036 - - 5,036 - 14% - - Total Expenses 148,978 44,867 - - 47,470 2,604 32% - - Percent of year completed 25.00% 65 RECREATION ADULT WELLNESS AND ENRICHMENT YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 2017 ANNUAL ALLOCATED 2015 2016 2017 OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 81,942 20,097 - - 20,097 - 25% - - 12 Extra Labor 24,000 5,610 - - 5,610 - 23% - - 21 FICA 7,914 1,921 - - 1,921 - 24% - 23 Pension - PERS /PSERS 9,837 2,485 - - 2,485 - 25% - - 24 Industrial Insurance 5,054 841 - - 841 - 17% - - 25 Medical & Dental 23,797 5,939 - - 5,939 - 25% - - Total Salaries & Benefits 152,544 36,894 - - 36,894 - 24% - - 31 Supplies 4,200 618 - - 618 - 15% - - 41 Professional Services 50,900 - - - - - - - - 48 Repairs and Maintenance 7,200 548 - - 548 - 8% - - 49 Miscellaneous 200 - - - - - - - - Total Operating Expenses 62,500 1,165 1,165 2% - Total Expenses 215,044 38,059 - - 38,059 - 18% - - Percent of year completed 66 25.00% RECREATION SENIOR ADULT PROGRAMS YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 2017 ANNUAL ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 82,253 20,172 - - 20,172 - 25% - - 12 Extra Labor 27,000 4,474 - - 4,474 - 17% - - 21 FICA 8,298 1,868 - - 1,868 - 23% - - 23 Pension - PERS /PSERS 9,875 2,533 - - 2,533 - 26% - - 24 Industrial Insurance 5,344 844 - - 844 - 16% - - 25 Medical & Dental 20,517 5,119 - - 5,119 - 25% - - Total Salaries & Benefits 153,287 35,011 - - 35,011 - 23% - - 31 Supplies 3,000 1,617 - - 1,617 - 54% - - 41 Professional Services 5,900 - - - - - - - - 43 Travel 2,100 383 - - 383 - 18% - - 49 Miscellaneous 12,000 2,049 - - 2,049 - 17% - - Total Operating Expenses 23,000 4,050 - - 4,050 - 18% - - (20)% (30)% 23 Pension - PERS /PSERS 13,377 Total Expenses 176,287 39,060 - - 39,060 - 22% - - Percent of year completed RECREATION COMMUNITY EVENTS AND VOLUNTEERS 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 111,432 30,312 43,705 31,891 25,405 (4,907) 23% (27)% (20)% 12 Extra Labor 15,150 3,949 - 2,094 485 (3,464) 3% - (77)% 13 Overtime 2,322 386 187 188 - (386) - 1% - 21 FICA 9,467 2,468 3,283 2,614 1,829 (639) 19% (20)% (30)% 23 Pension - PERS /PSERS 13,377 3,731 4,042 3,599 2,880 (851) 22% (11)% (20)% 24 Industrial Insurance 3,780 826 903 748 779 (47) 21% (17)% 4% 25 Medical & Dental 21,382 5,452 9,712 6,169 5,365 (87) 25% (36)% (13)% Total Salaries & Benefits 176,910 47,124 61,832 47,302 36,743 (10,380) 21% (23)% (22) %, ' 31 Supplies 25,400 2,078 1,760 1,831 3,600 1,522 14% 4% 97% 41 Professional Services 58,400 2,341 3,221 1,600 1,850 (491) 3% (50)% 16% 42 Communication 500 - 163 - - - - - - 43 Travel 600 - 25 - - - - - - 44 Advertising 10,500 909 423 377 377 (532) 4% (11)% 0% 45 Rentals and Leases 6,800 - - - - - - - - 49 Miscellaneous 2,550 233 436 100 - (233) - (77)% - Total Operating Expenses 104,750 5,561 6,029 3,908 5,827 265 6% (35)% 49% Total Expenses 281,660 52,685 67,860 51,210 42,570 (10,115) 15% (25)% (17)% Percent of year completed 25.00% 67 RECREATION PLANNING AND BUSINESS OPERATIONS YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 237,624 56,448 - - 56,448 - 24% - - 13 Overtime 464 - - - - - - - - 21 FICA 18,119 4,279 - - 4,279 - 24% - 23 Pension - PERS /PSERS 28,529 6,293 - - 6,293 - 22% - - 24 Industrial Insurance 3,440 527 - - 527 - 15% - - 25 Medical & Dental 63,043 14,291 - - 14,291 - 23% - - 28 Uniform /Clothing 230 225 - - 225 - 98% - - Total Salaries & Benefits 351,449 82,062 - - 82,062 - 23% - - 14,317 3,387 6,684 7,036 ' 31 Supplies 6,800 1,702 - - 1,702 - 25% - - 41 Professional Services 3,000 52 - - 52 - 2% - - 42 Communication 8,800 857 - - 857 - 10% - - 43 Travel 1,400 350 - - 350 - 25% - - 44 Advertising 500 - - - - - - - - 45 Rentals and Leases 39,610 9,054 - - 9,054 - 23% - - 48 Repairs and Maintenance 19,700 438 - - 438 - 2% - - 49 Miscellaneous 29,300 882 - - 882 - 3% - - Total Operating Expenses 109,110 13,335 - - 13,335 - 12% - - 260,041 62,268 125,314 132,266 - Total Expenses 460,559 95,397 - - 95,397 - 21% - - Percent of year completed RECREATION RENTAL OPERATIONS 25.00°/ YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 127,029 30,018 87,366 79,686 31,762 1 1,744 25% (9)% (60)% 12 Extra Labor 61,620 15,654 - 12,957 11,314 (4,340) 18% - (13)% 13 Overtime 929 52 1,198 234 - (52) - (80)% - 21 FICA 14,317 3,387 6,684 7,036 3,248 (140) 23% 5% (54)% 23 Pension - PERS /PSERS 15,254 3,587 8,162 10,009 4,398 811 29% 23% (56)% 24 Industrial Insurance 9,044 2,018 1,261 2,256 1,377 (641) 15% 79% (39)% 25 Medical & Dental 31,848 7,553 20,445 20,088 7,973 419 25% (2)% (60)% 28 Uniform /Clothing - - 197 - - - - - - Total Salaries & Benefits 260,041 62,268 125,314 132,266 60,072 (2,197) 23% 6% (55)% 31 Supplies 10,300 1,427 6,886 4,961 4,913 3,486 48% (28)% (1)% 34 Items Purchased for resale 22,000 69 428 - 69 - 0% - - 41 Professional Services 5,400 1,409 - 903 - (1,409) - - - 42 Communication - - 768 2,074 58 58 - 170% (97)% 43 Travel 325 - 10 - - - - - - 44 Advertising 6,700 2,526 - 2,335 2,368 (159) 35% - 1% 45 Rentals and Leases 2,000 958 10,226 11,470 - (958) - 12% - 48 Repairs and Maintenance 1,500 609 10,468 8,052 - (609) - (23)% - 49 Miscellaneous 3,700 3,700 890 5,172 5,994 2,294 162% 481% 16% Total Operating Expenses 51,925 10,699 29,676 34,967 13,401 2,703 26% 18% (62)% Total Expenses 311,966 72,967 154,990 167,232 73,473 _ 506 24% 8% (56)% Percent of year completed 68 25.00% COMMUNITY DEVELOPMENT CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) ACTUAL % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 2,183,057 530,027 447,629 475,297 522,267 (7,760) 24% 6% 10% 12 Extra Labor 51,074 15,485 13,274 15,098 12,401 (3,083) 24% 14% (18)% 13 Overtime 11,094 2,042 1,253 769 704 (1,338) 6% (39)% (8)% 21 FICA 171,664 42,439 34,958 37,144 40,499 (1,940) 24% 6% 9% 23 Pension - PERS /PSERS 263,447 64,937 41,421 54,333 59,255 (5,682) 22% 31% 9% 24 Industrial Insurance 23,960 5,197 2,809 3,465 4,031 (1,167) 17% 23% 16% 25 Medical & Dental 447,425 108,632 72,206 85,380 96,292 (12,341) 22% 18% 13% 28 Uniform /Clothing 2,975 172 - 142 - (172) - - - Total Salaries & Benefits 3,154,696 768,932 613,551 671,628 735,449 (33,484) 23% 9% 10% 31 Supplies 37,180 6,950 13,424 4,659 8,906 1,957 24% (65)% 91% 35 Small Tools 500 - - - - - - - - 41 Professional Services 253,400 41,050 27,382 53,537 17,768 (23,282) 7% 96% (67)% 42 Communication 6,500 790 775 1,161 300 (490) 5% 50% (74)% 43 Travel 13,800 401 20 97 276 (125) 2% 392% 185% 45 Rentals and Leases 12,800 3,671 6,339 4,976 3,268 (402) 26% (22)% (34)% 47 Public Utilities 2,500 396 - - 396 - 16% - - 48 Repairs and Maintenance 51,185 (35,452) 232 (42,613) 283 35,735 1% (18500)% (101)% 49 Miscellaneous 152,777 43,427 26,377 19,431 9,356 (34,071) 6% (26)% (52)% 51 Inter - Governmental 8,000 - - - - - - - - 53 Ext Taxes, Oper Assess - - - - 28 28 - - - Total Operating Expenses 538,642 61,233 74,548 41,247 40,581 (20,651 8% (45)% (2)% Total Expenses 3,693,338 830,165 688,099 712,875 776,030 (54,135) 21% 4% 9% Percent of year completed COMMUNITY DEVELOPMENT DIVISION SUMMARY 25.00°/ YTD AS OF MARCH 31, 2017 5/30/2017 10:47 Percent of year completed 25.00°% 69 BUDGET ACTUAL COMPARISON OF RESULTS ACTUAL SUMMARY BY DIVISION OVER /(UNDER) % CHANGE 2017 ALLOCATED 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 ADMINISTRATION 363,988 85,784 94,301 83,895 84,301 (1,484) 23% (11)% 0% CODE ENFORCEMENT 519,030 133,178 90,484 100,936 99,211 (33,966) 19% 12% (2)% PERMIT CENTER 399,556 69,555 83,680 98,604 78,490 8,935 20% 18% (20)% BUILDING, PERMIT AND PLAN REVIE\A 849,025 167,564 112,975 126,095 188,592 21,027 22% 12% 50% PLANNING 1,269,970 350,337 287,841 276,853 269,420 (80,918) 21% (4)% (3)% RECYCLING PROGRAM 46,000 4,738 10,479 4,741 6,526 1,788 14% (55)% 38% TDM PROGRAM 245,769 19,008 8,338 21,752 49,491 30,482 20% 161% 128% Total Expenses 3,693,338 830,165 688,099 712,875 776,030 (54,135) 21% 4% 9% Percent of year completed 25.00°% 69 COMMUNITY DEVELOPMENT ADMINISTRATION YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 230,470 57,688 56,623 56,795 58,407 718 25% 0% 3% 13 Overtime 1,114 - - - - - - - (69)% 21 FICA 15,422 4,247 4,179 4,184 4,316 70 28% 0% 3% 23 Pension - PERS /PSERS 27,668 6,830 5,122 6,233 6,430 (400) 23% 22% 3% 24 Industrial Insurance 706 171 130 141 129 (42) 18% 8% (9)% 25 Medical & Dental 48,628 14,049 12,024 12,609 10,365 (3,684) 21% 5% (18)% Total Salaries & Benefits 324,008 82,985 78,079 79,962 79,646 (3,338) 25% 2% (0)% 31 Supplies 9,680 824 7,839 1,370 2,864 2,040 30% (83)% 109% 41 Professional Services 13,000 - 5,513 - - - - - - 43 Travel 500 12 - 48 26 14 5% - (46)% 45 Rentals and Leases 4,800 1,200 1,344 1,897 1,268 68 26% 41% (33)% 48 Repairs and Maintenance 500 195 232 502 283 88 57% 117% (44)% 49 Miscellaneous 11,500 569 1,295 115 186 (383) 2% (91)% 61% 53 Ext Taxes, Assessments - - - - 28 28 - - - Total Operating Expenses 39,980 2,799 16,222 3,933 4,654 1,855 12% (76)% 18% 49 Miscellaneous 53,427 14,435 68 297 - (14,435) - 337% - Total Expenses 363,988 85,784 94,301 83,895 84,301 (1,484) 23% (11)% 0% Percent of year completed COMMUNITY DEVELOPMENT CODE ENFORCEMENT 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 302,047 79,033 57,839 63,357 64,751 (14,282) 21% 10% 2% 12 Extra Labor 5,574 998 - 3,140 980 (18) 18% - (69)% 13 Overtime 2,786 - - - - - - - - 21 FICA 23,746 6,081 4,425 5,087 5,027 (1,053) 21% 15% (1)% 23 Pension - PERS /PSERS 36,266 9,570 5,246 7,434 7,349 (2,221) 20% 42% (1)% 24 Industrial lnsurance 8,732 2,263 1,105 1,647 1,472 (791) 17% 49% (11)% 25 Medical & Dental 75,628 17,475 9,529 12,976 17,978 503 24% 36% 39% 28 Uniform /Clothing 475 172 - 142 - (172) - - - Total Salaries & Benefits 455,254 115,592 78,144 93,784 97,557 (18,035) 21% 20% 4% 31 Supplies 500 102 (3,295) 402 80 (22) 16% (112)% (80)% 41 Professional Services - - 12,722 3,578 - - - (72)% - 42 Communication 3,000 706 720 720 240 (466) 8% 0% (67)% 43 Travel 600 231 - 15 - (231) - - - 45 Rentals and Leases 3,749 1,715 2,126 2,139 937 (778) 25% 1% (56)% 47 Public Utilities 2,500 396 - - 396 - 16% - - 49 Miscellaneous 53,427 14,435 68 297 - (14,435) - 337% - Total Operating Expenses 63,776 17,586 12,341 7,152 1,654 (15,931) 3% (42)% (77)% Total Expenses 519,030 133,178 90,484 100,936 99,211 (33,966) 19% 12% (2)% Percent of year completed 70 25.00% COMMUNITY DEVELOPMENT PERMIT CENTER YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 205,279 53,059 56,969 63,865 50,439 (2,620) 25% 12% (21)% 13 Overtime 1,847 - - - - - - - 19% 21 FICA 15,857 4,097 4,358 4,886 3,859 (238) 24% 12% (21)% 23 Pension - PERS /PSERS 24,651 6,449 4,970 7,140 5,639 (810) 23% 44% (21)% 24 Industrial Insurance 1,059 283 219 270 182 (101) 17% 23% (32)% 25 Medical & Dental 60,663 15,585 11,168 16,872 15,106 (479) 25% 51% (10)% Total Salaries & Benefits 309,356 79,474 77,684 93,032 75,226 (4,248) 24% 20% (19)% 31 Supplies 3,000 1,628 90 1,208 87 (1,540) 3% 1246% (93)% 41 Professional Services 10,000 10,000 281 36,328 - (10,000) - 12823% - 42 Communication - - - 274 - - - - - 43 Travel 3,700 - 20 - - - - - - 48 Repairs and Maintenance 42,000 (35,647) - (43,116) - 35,647 - - - 49 Miscellaneous 31,500 14,101 5,605 10,878 3,177 (10,924) 10% 94% (71)% Total Operating Expenses 90,200 (9,919) 5,996 5,572 3,264 13,183 4% (7)% (41)% - 50% 45 Rentals and Leases 4,251 755 2,869 939 1,063 308 Total Expenses 399,556 69,555 83,680 98,604 78,490 8,935 20% 18% (20)% Percent of year completed COMMUNITY DEVELOPMENT BUILDING, PERMIT AND PLAN REVIEW 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 514,054 111,852 82,896 84,842 121,973 10,120 24% 2% 44% 13 Overtime 3,500 345 841 245 658 312 19% (71)% 168% 21 FICA 39,527 8,552 6,317 6,419 9,306 754 24% 2% 45% 23 Pension - PERS /PSERS 63,053 13,848 7,559 9,513 13,431 (417) 21% 26% 41% 24 Industrial Insurance 9,261 1,544 762 734 1,495 (48) 16% (4)% 104% 25 Medical & Dental 114,579 26,295 14,683 16,086 23,129 (3,166) 20% 10% 44% 28 Uniform /Clothing 2,500 - - - - - - - - Total Salaries & Benefits 746,474 162,436 113,059 117,839 169,992 7,556 23% 4% 44% 31 Supplies 3,000 601 476 - 601 - 20% - - 35 Small Tools 500 - - - - - - - 41 Professional Services 83,400 3,028 (15,608) 5,266 13,921 10,893 17% (134)% 164% 42 Communication 500 84 55 167 60 (24) 12% 204% (64)% 43 Travel 1,500 24 - 13 20 (4) 1% - 50% 45 Rentals and Leases 4,251 755 2,869 939 1,063 308 25% (67)% 13% 48 Repairs and Maintenance 550 - - - - - - - - 49 Miscellaneous 8,850 635 12,125 1,871 2,935 2,300 33% (85)% 57% Total Operating Expenses 102,551 5,128 (83) 8,256 18,600 13,472 18% (10012)% 125% Total Expenses 849,025 167,564 112,975 126,095 188,592 21,027 22% 12% 50% Percent of year completed 25.00% 71 COMMUNITY DEVELOPMENT PLANNING YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 814,661 214,621 190,139 194,736 196,381 (18,240) 24% 2% 1% 12 Extra Labor 45,500 14,487 6,641 4,137 1,371 (13,115) 3% (38)% (67)% 13 Overtime 1,847 1,697 412 524 46 (1,651) 3% 27% (91)% 21 FICA 68,197 18,121 14,949 15,096 14,936 (3,185) 22% 1% (1)% 23 Pension - PERS /PSERS 97,819 26,147 17,621 21,830 21,894 (4,253) 22% 24% 0% 24 Industrial Insurance 3,000 779 570 583 564 (215) 19% 2% (3)% 25 Medical & Dental 129,811 34,015 24,534 25,998 26,929 (7,085) 21% 6% 4% Total Salaries & Benefits 1,160,835 309,866 254,867 262,904 262,122 (47,744) 23% 3% (0)% 31 Supplies 8,000 91 1,866 56 1,335 1,244 17% (97)% 2279% 41 Professional Services 64,000 26,927 24,473 8,364 2,752 (24,175) 4% (66)% (67)% 42 Communication 3,000 - - - - - - - - 43 Travel 2,000 56 - 21 152 96 8% - 623% 48 Repairs and Maintenance 8,135 - - - - - - - - 49 Miscellaneous 24,000 13,397 6,634 5,508 3,058 (10,339) 13% (17)% (44)% Total Operating Expenses 109,135 40,471 32,974 13,949 7,297 (33,174) 7% (58)% (48)% Total Expenses 1,269,970 350,337 287,841 276,853 269,420 (80,918) 21% (4)% (3)% Percent of year completed COMMUNITY DEVELOPMENT RECYCLING PROGRAM 25.00 % YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries I - - 3,162 2,384 1,296 1,296 - (25)% (46)% 21 FICA - - 223 160 96 96 - (28)% (40)% 23 Pension - PERS /PSERS - - 291 267 145 145 - (8)% (46)% 24 Industrial Insurance - - 10 8 4 4 - (22)% (50)% 25 Medical & Dental - - 268 299 13 13 - 12% (96)% Total Salaries & Benefits - - 3,955 3,118 1,554 1,554 - (21)% (50)% 31 Supplies 9,000 3,643 6,449 1,623 3,877 234 43% (75)% 139% 41 Professional Services 30,000 1,095 - - 1,095 - 4% - - 49 Miscellaneous 7,000 - 75 - - - - - - Total Operating Expenses 46,000 4,738 6,524 1,623 4,972 234 11% (75)% 206% Total Expenses 46,000 4,738 10,479 4,741 6,526 1,788 14% (55)% 38% Percent of year completed 72 25.00% COMMUNITY DEVELOPMENT TDM PROGRAM YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 116,546 13,773 - 9,319 29,020 15,247 25% - 211% 12 Extra Labor - - 6,633 7,821 10,050 10,050 - 18% 29% 21 FICA 8,915 1,342 507 1,311 2,959 1,616 33% 158% 126% 23 Pension - PERS /PSERS 13,990 2,093 611 1,916 4,368 2,275 31% 214% 128% 24 Industrial Insurance 1,202 158 12 83 184 27 15% 595% 123% 25 Medical & Dental 18,116 1,214 - 539 2,771 1,557 15% - 414% Total Salaries & Benefits 158,769 18,580 7,763 20,990 49,352 30,772 31% 170% 135% 31 Supplies 4,000 60 - - 60 - 2% - - 41 Professional Services 53,000 - - - - - - - - 43 Travel 5,500 79 - - 79 - 1% - - 49 Miscellaneous 16,500 290 575 762 - (290) - 33% - 51 Inter - Governmental 8,000 - - - - - - - - Total Operating Expenses 87,000 429 575 762 139 (290) 0% 33% (82)% Total Expenses 245,769 19,008 8,338 21,752 49,491 30,482 20% 161% 128% Percent of year completed 25.00% 73 MUNICIPAL COURT CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 756,312 189,791 172,993 175,769 181,400 (8,391) 24% 2% 3% 12 Extra Labor 4,180 558 - - 558 - 13% - - 13 Overtime 4,661 312 - 169 - (312) - - - 21 FICA 57,112 14,072 12,912 13,269 13,714 (358) 24% 3% 3% 23 Pension - PERS /PSERS 90,616 22,076 16,233 19,753 20,425 (1,650) 23% 22% 3% 24 Industrial Insurance 3,477 759 610 602 662 (97) 19% (1)% 10% 25 Medical & Dental 185,542 47,439 35,318 38,932 39,550 (7,889) 21% 10% 2% 26 Unemployment - - - 1,103 - - - - - Total Salaries & Benefits 1,101,900 275,006 238,066 249,596 256,310 (18,696) 23% 5% 3% 31 Supplies 14,283 3,543 3,224 3,087 1,727 (1,816) 12% (4)% (44)% 35 Small Tools - - 2,932 - - - - - - 41 Professional Services 105,000 20,630 16,727 19,240 20,199 (431) 19% 15% 5% 42 Communication 24,150 4,755 3,220 1,021 1,073 (3,682) 4% (68)% 5% 43 Travel 10,000 4,087 1,022 1,397 3,962 (125) 40% 37% 184% 45 Rentals and Leases 2,000 2,000 523 523 2,399 399 120% 0% 358% 48 Repairs and Maintenance 2,300 1,898 294 430 278 (1,620) 12% 46% (35)% 49 Miscellaneous 23,170 8,892 11,137 6,802 5,768 (3,124) 25% (39)% (15)% 53 Ext Taxes, Assessments 5 - 1 - - - - - - 64 Miscellaneous 25,000 - - - - - - - - Total Operating Expenses 205,908 45,805 39,081 32,501 35,407 (10,398) 17% (17)% 9% Total Expenses 1,307,808 320,810 277,147 282,096 291,716 (29,094) 22% 2% 3% Percent of year completed 74 25.00% POLICE CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 9,003,291 2,311,489 2,068,816 2,166,135 2,139,460 (172,029) 24% 5% (1)% 13 Overtime 928,495 208,065 257,641 204,939 234,487 26,421 25% (20)% 14% 15 Holiday /Kelly Payoff 201,063 3,177 - 3,286 1,394 (1,783) 1% - (58)% 21 FICA 756,032 189,791 176,316 179,318 180,309 (9,482) 24% 2% 1% 22 Pension -LEOFF 2 472,077 113,973 102,701 104,864 105,904 (8,070) 22% 2% 1% 23 Pension - PERS /PSERS 146,051 36,137 27,891 32,283 33,628 (2,509) 23% 16% 4% 24 Industrial Insurance 273,809 65,688 43,987 50,959 45,248 (20,439) 17% 16% (11)% 25 Medical & Dental 1,933,791 492,685 436,928 469,445 444,979 (47,706) 23% 7% (5)% 26 Unemployment - - 143 3,313 68 68 - 2215% (98)% Total Salaries & Benefits 13,714,609 3,421,005 3,114,423 3,214,540 3,185,477 (235,528) 23% 3% (1)% 31 Supplies 180,850 79,045 46,237 93,155 37,587 (41,458) 21% 101% (60)% 35 Small Tools 15,600 3,258 7,800 358 2,658 (600) 17% (95)% 643% 41 Professional Services 70,000 17,633 18,227 16,780 11,514 (6,119) 16% (8)% (31)% 42 Communication 121,000 32,033 19,541 23,776 12,632 (19,401) 10% 22% (47)% 43 Travel 41,880 10,874 7,321 11,012 9,289 (1,585) 22% 50% (16)% 44 Advertising 1,500 54 - - 54 - 4% - - 45 Rentals and Leases 896,843 287,999 313,879 324,343 218,789 (69,210) 24% 3% (33)% 46 Insurance 230,223 230,223 240,000 240,000 230,223 - 100% 0% (4)% 47 Public Utilities - - 670 615 525 525 - (8)% (15)% 48 Repairs and Maintenance 188,922 38,568 33,038 25,402 10,611 (27,957) 6% (23)% (58)% 49 Miscellaneous 79,641 20,759 33,744 17,842 19,300 (1,460) 24% (47)% 8% 51 Inter - Governmental 2,747,024 747,015 607,408 666,019 732,384 (14,630) 27% 10% 10% 64 Machinery & Equipment - - - 183,971 - - - - - Total Operating Expenses 4,573,483 1,467,461 1,327,864 1,603,272 1,285,566 (181,895) 28% 21% (20)% Total Expenses -. 18,288,092 4,888,466 4,442,286 4,817,812 4,471,044 (417,422) 24% 8% (7)% Percent of year completed POLICE DIVISION SUMMARY 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY DIVISION BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 ADMINISTRATION 1,794,634 647,844 593,853 612,365 614,521 I (33,323) 34% 3% 0% INVESTIGATION 2,147,558 566,002 540,003 594,495 566,627 625 26% 10% (5)% PATROL 6,506,261 1,614,758 1,553,969 1,595,214 1,519,411 (95,347) 23% 3% (5)% RECORDS /EVIDENCE 1,217,212 292,382 275,314 269,728 264,830 (27,552) 22% (2)% (2)% ANTI -CRIME 846,734 240,992 246,329 182,331 179,113 (61,879) 21% (26)% (2)% PROFESSIONAL STANDARDS 2,021,287 488,875 384,150 429,371 387,531 (101,344) 19% 12% (10)% TRAINING 287,102 94,077 93,690 91,528 64,944 (29,133) 23% (2)% (29)% TRAFFIC 591,180 188,199 139,825 181,115 136,261 (51,938) 23% 30% (25)% FACILITIES 120,000 2,472 - - 2,472 - 2% - - PRISONER CARE & CUSTODY 1,509,914 379,551 315,852 339,359 369,690 (9,860) 24% 7% 9% ANIMAL SERVICES 118,852 - - - - - - - - COMMUNICATION, DISPATCH 1,127,358 375,786 299,301 338,335 365,644 (10,142) 32% 13% 8% SPECIAL SERVICES UNIT - - - 6,619 - - - - - Total Expenses 18,288,092 4,890,938 4,442,286 4,640,461 4,471,044 (419,894) 24% 4% (4)% Percent of year completed 25.00% 75 POLICE ADMINISTRATION YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 929,989 254,243 232,217 247,327 265,0421 10,799 28% 7% 7% 13 Overtime 2,923 - 1,849 - - - - - - 21 FICA 62,064 18,271 17,329 17,413 18,760 489 30% 0% 8% 22 Pension -LEOFF 46,693 11,002 10,840 9,713 11,039 37 24% (10)% 14% 23 Pension - PERS /PSERS 8,855 2,187 1,808 1,993 3,894 1,707 44% 10% 95% 24 Industrial Insurance 18,294 4,345 2,965 3,099 2,731 (1,614) 15% 5% (12)% 25 Medical & Dental 155,097 38,120 32,669 31,586 39,241 1,121 25% (3)% 24% Total Salaries & Benefits 1,223,915 328,168 299,677 311,131 340,706 12,538 28% 4% 10% 31 Supplies 24,000 9,817 8,441 8,763 5,240 (4,577) 22% 4% (40)% 41 Professional Services 15,000 3,602 637 2,617 3,309 (293) 22% 311% 26% 42 Communication 121,000 32,033 5,549 10,201 4,046 (27,987) 3% 84% (60)% 43 Travel 10,000 3,655 3,446 2,000 2,581 (1,074) 26% (42)% 29% 44 Advertising 1,100 - - - - - - - - 45 Rentals and Leases 61,478 25,107 20,393 22,683 17,769 (7,338) 29% 11% (22)% 46 Insurance 230,223 230,223 240,000 240,000 230,223 - 100% 0% (4)% 48 Repairs and Maintenance 86,518 13,039 14,999 13,000 9,173 (3,865) 11% (13)% (29)% 49 Miscellaneous 5,500 2,200 712 1,970 1,473 (727) 27% 177% (25)% 51 Inter - Governmental 15,900 - - - - - - - - Total Operating Expenses 570,719 319,676 294,176 301,235 273,814 (45,861) 48% 2% (9)% Total Expenses 1,794,634 647,844 593,853 612,365 614,521 - (33,323) 34% 3% 0% Percent of year completed POLICE INVESTIGATION 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 1,319,637 343,176 318,769 365,048 365,712 22,536 28% 15% 0% 13 Overtime 173,542 33,805 43,446 41,631 37,393 3,588 22% (4)% (10)% 21 FICA 113,950 29,085 27,423 30,932 31,510 2,425 28% 13% 2% 22 Pension -LEOFF 72,920 18,260 17,089 19,376 19,226 966 26% 13% (1)% 23 Pension - PERS /PSERS 15,918 3,973 2,954 3,640 3,640 (333) 23% 23% (0)% 24 Industrial Insurance 41,629 10,156 6,682 8,846 7,585 (2,571) 18% 32% (14)% 25 Medical & Dental 264,160 72,196 58,053 68,257 66,348 (5,848) 25% 18% (3)% Total Salaries & Benefits 2,001,756 510,651 474,415 537,730 531,415 20,764 27% 13% (11%, 31 Supplies 12,000 5,789 4,168 3,421 1,535 (4,254) 13% (18)% (55)% 41 Professional Services 4,000 4,000 101 1,420 4,196 196 105% 1307% 195% 42 Communication - - 492 333 420 420 - (32)% 26% 43 Travel 5,000 3,024 1,458 3,842 392 (2,632) 8% 163% (90)% 45 Rentals and Leases 112,302 37,610 58,178 44,038 28,266 (9,344) 25% (24)% (36)% 47 Public Utilities - - 303 325 402 402 - 7% 24% 48 Repairs and Maintenance 9,000 1,663 849 2,546 - (1,663) - 200% - 49 Miscellaneous 3,500 3,265 40 840 - (3,265) - 2000% - Total Operating Expenses 145,802 55,351 65,588 56,765 35,212 (20,139) 24% (13)% (38)% Total Expenses 2,147,558 566,002 540,003 594,495 566,627 625 26% 10% (5)% Percent of year completed 76 25.00% POLICE PATROL YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 3,599,974 914,359 863,057 877,941 863,667 1 (50,692) 24% 2% (2)% 13 Overtime 553,184 122,617 106,181 90,612 131,410 8,793 24% (15)% 45% 15 Holiday Pay 201,063 3,177 - 3,286 1,394 (1,783) 1% - (58)% 21 FICA 325,928 77,923 73,809 74,147 76,020 (1,903) 23% 0% 3% 22 Pension -LEOFF 224,945 52,661 48,608 49,008 50,504 (2,157) 22% 1% 3% 23 Pension - PERS /PSERS 6,110 1,457 1,360 1,288 1,390 (67) 23% (5)% 8% 24 Industrial Insurance 131,570 31,120 22,764 25,345 23,006 (8,114) 17% 11% (9)% 25 Medical & Dental 843,096 214,981 221,407 234,604 207,603 (7,378) 25% 6% (12)% Total Salaries & Benefits 5,885,870 1,418,294 1,337,186 1,356,230 1,354,992 (63,302) 23% 1% (0)% 31 Supplies 59,450 15,097 13,412 26,735 17,350 2,253 29% 99% (35)% 35 Small Tools 600 600 7,800 358 - (600) - (95)% - 41 Professional Services 8,000 1,629 1,033 1,012 1,003 (626) 13% (2)% (1)% 42 Communication - - 10,894 12,888 4,479 4,479 - 18% (65)% 43 Travel 500 356 76 248 157 (199) 31% 227% (37)% 45 Rentals and Leases 482,337 163,899 164,819 187,082 141,175 (22,724) 29% 14% (25)% 48 Repairs and Maintenance 65,404 13,010 16,913 7,806 (6) (13,017) (0)% (54)% (100)% 49 Miscellaneous 4,100 1,872 1,834 2,855 261 (1,611) 6% 56% (91)% Total Operating Expenses 620,391 196,463 216,782 238,984 164,418 , (32,045) 27% 10% (31)% Total Expenses 1,217,212 292,382 275,314 269,728 264,830 (27,552) 22% (2)% (2)% Total Expenses 6,506,261 1,614,758 1,553,969 1,595,214 1,519,411 - (95,347) 23% 3% (5)% Percent of year completed POLICE RECORDS /EVIDENCE 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 785,175 194,449 174,390 175,899 174,041 (20,408) 22% 1% (1)% 13 Overtime 32,248 7,551 26,350 10,585 13,273 5,722 41% (60)% 25% 21 FICA 60,929 14,970 15,074 14,026 14,142 (828) 23% (7)% 1% 23 Pension - PERS /PSERS 97,109 23,537 16,534 20,355 20,434 (3,103) 21% 23% 0% 24 Industrial Insurance 4,975 1,135 643 773 741 (394) 15% 20% (4)% 25 Medical & Dental 167,376 41,167 34,250 35,773 35,879 (5,288) 21% 4% 0% 26 Unemployment - - 143 3,313 68 68 - 2215% (98)% Total Salaries & Benefits 1,147,812 282,809 267,385 260,724 258,578 (24,231) 23% (2)% (1)% 31 Supplies 29,400 6,387 3,563 7,053 2,068 (4,319) 7% 98% (71)% 35 Small Tools 15,000 2,658 - - 2,658 - 18% - - 41 Professional Services 9,000 80 2,333 55 57 (23) 1% (98)% 4% 42 Communication - - 1,211 7 465 465 - (99)% 6738% 43 Travel - - - - 238 238 - - - 45 Rentals and Leases - - 821 1,889 318 318 - 130% (83)% 48 Repairs and Maintenance 13,500 352 - - 352 - 3% - - 49 Miscellaneous 2,500 96 - - 96 - 4% - - Total Operating Expenses 69,400 9,573 7,929 9,004 6,252 (3,321) 9% 14% (31)% Total Expenses 1,217,212 292,382 275,314 269,728 264,830 (27,552) 22% (2)% (2)% Percent of year completed 25.00% 77 POLICE ANTI -CRIME YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 495,212 134,421 135,251 97,268 98,618 (35,803) 20% (28)% 1% 13 Overtime 58,459 15,261 29,738 13,092 20,430 5,169 35% (56)% 56% 21 FICA 42,311 11,427 12,599 8,431 9,107 (2,320) 22% (33)% 8% 22 Pension -LEOFF 29,563 7,955 8,564 5,720 6,174 (1,781) 21% (33)% 8% 24 Industrial Insurance 16,666 4,450 3,395 2,642 2,566 (1,884) 15% (22)% (3)% 25 Medical & Dental 105,001 28,052 27,158 20,875 20,158 (7,894) 19% (23)% (3)% Total Salaries & Benefits 747,212 201,566 216,704 148,027 157,053 (44,514) 21% (32)% 6% 31 Supplies 2,000 456 510 - 456 - 23% - - 42 Communication - - 51 312 478 478 - 511% 53% 45 Rentals and Leases 86,522 38,418 28,250 33,292 20,798 (17,619) 24% 18% (38)% 48 Repairs and Maintenance 1,000 - - - - - - - - 49 Miscellaneous 10,000 552 814 699 328 (224) 3% (14)% (53)% Total Operating Expenses 99,522 39,426 29,625 34,303 22,060 (17,365) 22% 16% (36)% 47 Public Utilities - - 367 289 123 123 - (21)% (58)% Total Expenses 846,734 240,992 246,329 182,331 179,113 (61,879) 21% (26)% (2)% Percent of year completed POLICE PROFESSIONAL STANDARDS 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 1,396,260 327,470 230,909 261,842 253,9991 (73,470) 18% 13% (3)% 13 Overtime 45,303 9,484 31,967 30,797 23,699 14,215 52% (4)% (23)% 21 FICA 110,001 25,693 20,035 22,315 21,196 (4,497) 19% 11% (5)% 22 Pension -LEOFF 72,707 16,337 11,616 13,722 13,284 (3,053) 18% 18% (3)% 23 Pension - PERS /PSERS 10,201 3,016 3,484 2,999 2,332 (684) 23% (14)% (22)% 24 Industrial Insurance 44,361 9,877 4,657 6,495 5,881 (3,996) 13% 39% (9)% 25 Medical & Dental 308,300 73,568 43,852 55,489 53,701 (19,867) 17% 27% (3)% Total Salaries & Benefits 1,987,133 465,445 346,520 393,659 374,091 - (91,353) 19% 14% (5)% 31 Supplies 8,300 2,703 3,599 6,586 6,774 4,071 82% 83% 3% 42 Communication - - 1,343 - 1,519 1,519 - - - 43 Travel - - 1,132 - (35) (35) - - - 44 Advertising 400 54 - - 54 - 13% - - 45 Rentals and Leases 19,854 19,854 31,139 28,388 4,964 (14,891) 25% (9)% (83)% 47 Public Utilities - - 367 289 123 123 - (21)% (58)% 48 Repairs and Maintenance 1,000 820 - 449 42 (778) 4% - (91)% 49 Miscellaneous 4,600 - 50 - - - - - - Total Operating Expenses 34,154 23,431 37,630 35,711 13,440 - (9,991) 39% (5)% (62)% Total Expenses 2,021,287 488,875 384,150 429,371 387,531 - (101,344) 19% 12% (10)% Percent of year completed 78 25.00% POLICE TRAINING YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 100,189 25,148 24,305 24,848 24,848 1 (300) 25% 2% 0% 13 Overtime 15,500 4,242 7,768 6,035 2,619 (1,623) 17% (22)% (57)% 21 FICA 8,667 2,223 2,446 2,317 2,056 (166) 24% (5)% (11)% 22 Pension -LEOFF 6,174 1,570 1,664 1,602 1,423 (147) 23% (4)% (11)% 24 Industrial Insurance 3,413 794 565 636 576 (218) 17% 12% (9)% 25 Medical & Dental 20,038 5,006 3,457 4,649 4,767 (239) 24% 35% 3% Total Salaries & Benefits 153,981 38,983 40,206 40,087 36,289 (2,694) 24% (0)% (9)% ' 31 Supplies 41,100 35,242 11,908 34,735 3,593 (31,649) 9% 192% (90)% 41 Professional Services 9,000 - 6,377 - - - - - - 42 Communication - - - - 1,225 1,225 - - - 43 Travel 26,380 3,839 1,209 4,922 5,956 2,117 23% 307% 21% 45 Rentals and Leases 5,200 739 3,418 - 739 - 14% - - 48 Repairs and Maintenance 2,500 2,500 276 306 - (2,500) - 11% - 49 Miscellaneous 48,941 12,774 30,295 11,478 17,141 4,367 35% (62)% 49% Total Operating Expenses 133,121 55,094 53,484 51,441 28,655' (26,439) 22% (4)% (44)% Total Expenses 287,102 94,077 93,690 91,528 64,944 ' (29,133) 23% (2)% (29)% Percent of year completed POLICE FACILITIES 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 45 Rentals and Leases 120,000 2,472 - - 2,472 - 2% - - Total Operating Expenses 120,000 2,472 - - 2,472 - 2% - - Total Expenses 120,000 2,472 - - 2,472 - 2% - - Percent of year completed 25.00% 79 POLICE TRAFFIC YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 376,855 118,222 89,917 115,962 93,532 (24,689) 25% 29% (19)% 13 Overtime 47,336 15,105 10,341 12,186 5,663 (9,441) 12% 18% (54)% 21 FICA 32,182 10,199 7,600 9,736 7,518 (2,681) 23% 28% (23)% 22 Pension -LEOFF 19,075 6,189 4,320 5,724 4,254 (1,935) 22% 33% (26)% 23 Pension - PERS /PSERS 7,858 1,968 1,751 2,008 1,939 (29) 25% 15% (3)% 24 Industrial Insurance 12,901 3,811 2,317 3,124 2,164 (1,647) 17% 35% (31)% 25 Medical & Dental 70,723 19,595 16,083 18,211 17,282 (2,313) 24% 13% (5)% Total Salaries & Benefits 566,930 175,089 132,329 166,951 132,352 - (42,736) 23% 26% (21)% 31 Supplies 4,600 3,554 634 5,862 570 (2,984) 12% 824% (90)% 42 Communication - - - 35 - - - - - 45 Rentals and Leases 9,150 2,372 6,861 6,971 2,288 (84) 25% 2% (67)% 48 Repairs and Maintenance 10,000 7,185 - 1,296 1,051 (6,134) 11% - (19)% 49 Miscellaneous 500 - - - - - - - - Total Operating Expenses 24,250 13,111 7,495 14,164 3,909 (9,202) 16% 89% (72)% Total Expenses 591,180 188,199 139,825 181,115 136,261 (51,938) 23% 30% (25)% Percent of year completed 80 25.00% POLICE PRISONER CARE & CUSTODY YTD THROUGH PERIOD 3 5/30/2017 10:47 Percent of year completed POLICE ANIMAL SERVICES 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY BY EXPENDITURE 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) ACTUAL % CHANGE ALLOCATED BDGT TYPE 2015/2016 2016/2017 2017 118,852 - - OVER /(UNDER) - % CHANGE ALLOCATED - - Total Operating Expenses 118,852 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 41 Monitoring of Prisoners 25,000 8,322 7,745 11,675 2,950 ' (5,373) 12% 51% (75)% 51 Score Jail 1,484,914 371,229 308,107 327,684 366,741 _ (4,488) 25% 6% 12% Total Operating Expenses 1,509,914 379,551 315,852 339,359 369,690 (9,860) 24% 7% 9 % Percent of year completed POLICE ANIMAL SERVICES 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 51 King County Animal Control 118,852 - - - - - - - - Total Operating Expenses 118,852 - - - - - - - - Percent of year completed POLICE COMMUNICATION, DISPATCH 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE % CHANGE % SPEND ALLOCATED BDGT % SPEND 2015/2016 2016/2017 51 Valley Communications 1,127,358 375,786 299,301 338,335 365,644 (10,142) 32% 13% - 8% Total Operating Expenses 1,127,358 375,786 299,301 338,335 365,644 (10,142) 32% 13% 8% Percent of year completed POLICE SPECIAL SERVICES UNIT 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 64 Machinery & Equipment - - - 6,619 - - - - - Total Operating Expenses - - - 6,619 - - - - - Percent of year completed 25.00% 81 FIRE CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) °A CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 6,888,744 1,695,454 1,687,580 1,736,795 1,805,866 110,412 26% 3% 4% 12 Extra Labor - - - 5,267 911 911 - - (83)% 13 Overtime 650,648 130,943 160,191 97,857 133,165 2,222 20% (39)% 36% 15 Holiday Pay 324,520 - 1,124 - - - - - - 21 FICA 125,292 29,220 28,028 29,298 32,473 3,253 26% 5% 11% 22 Pension -LEOFF 2 377,176 86,044 87,186 89,593 93,119 7,075 25% 3% 4% 23 Pension - PERS /PSERS 44,621 10,865 8,172 10,091 10,286 (580) 23% 23% 2% 24 Industrial Insurance 368,655 85,614 56,421 66,283 66,700 (18,914) 18% 17% 1% 25 Medical & Dental 1,454,547 365,597 392,142 407,137 376,747 11,150 26% 4% (7)% Total Salaries & Benefits 10,234,203 2,403,737 2,420,844 2,442,321 2,519,267 115,530 25% 1% 3% 31 Supplies 234,477 36,014 106,472 40,353 65,782 29,768 28% (62)% 63% 35 Small Tools 37,268 4,228 156,106 - 4,228 - 11% - - 41 Professional Services 81,000 5,985 7,639 4,953 6,920 935 9% (35)% 40% 42 Communication 32,170 7,712 8,674 9,666 3,847 (3,865) 12% 11% (60)% 43 Travel 7,000 2,654 2,676 1,299 3,816 1,162 55% (51)% 194% 45 Rentals and Leases 587,241 210,777 135,113 134,104 146,898 (63,879) 25% (1)% 10% 46 Insurance 173,286 173,286 90,000 90,000 173,286 - 100% 0% 93% 47 Public Utilities 73,360 18,980 18,589 19,644 20,185 1,204 28% 6% 3% 48 Repairs and Maintenance 41,921 11,954 11,717 19,173 19,460 7,506 46% 64% 1% 49 Miscellaneous 148,874 54,898 28,437 28,457 21,485 (33,413) 14% 0% (24)% 51 Inter - Governmental 211,768 70,589 51,550 63,663 66,673 (3,916) 31% 23% 5% Total Operating Expenses 1,628,365 597,077 616,972 411,312 532,580. (64,497) 33% (33)% 29% , Total Expenses 11,862,568 3,000,814 3,037,816 2,853,633 3,051,847 _ 51,033 26% (6)% 7% Percent of year completed FIRE DIVISION SUMMARY 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY DIVISION BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 ADMINISTRATION 867,812 338,705 263,528 265,580 334,745 I (3,960) 39% 1% 26% SUPPRESSION 8,944,102 2,141,195 2,196,038 2,117,178 2,191,731 50,536 25% (4)% 4% PREVENTION 833,040 196,418 192,406 195,370 200,250 3,832 24% 2% 2% TRAINING 448,048 135,683 104,591 102,479 124,810 (10,873) 28% (2)% 22% EMERGENCY PREPAREDNESS 351,305 78,778 195,907 75,141 87,904 9,126 25% (62)% 17% FIRE FACILITIES 110,860 25,432 23,107 22,321 24,922 (509) 22% (3)% 12% HAZARDOUS MATERIALS UNIT 39,883 7,570 4,522 4,275 4,471 (3,099) 11% (5)% 5% RESCUE TEAM 13,250 146 - - 146 - 1% - - RESCUE AND EMERGENCY AID 42,500 6,298 6,166 7,626 16,193 9,896 38% 24% 112% COMMUNICATION - DISPATCH 211,768 70,589 51,550 63,663 66,673 (3,916) 31% 23% 5% Total Expenses 11,862,568 3,000,814 3,037,816 2,853,633 3,051,847 51,033 26% (6)% 7% Percent of year completed 82 25.00% FIRE ADMINISTRATION YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 442,193 110,822 109,204 111,085 106,191 (4,631) 24% 2% (4)% 12 Extra Labor - - - 3,465 - - - - - 13 Overtime 464 - 25 - - - - - - 21 FICA 14,064 3,066 3,458 3,643 5,550 2,484 39% 5% 52% 22 Pension -LEOFF 15,763 771 3,867 3,961 3,688 2,917 23% 2% (7)% 23 Pension - PERS /PSERS 15,956 3,953 2,960 3,657 3,679 (274) 23% 24% 1% 24 Industrial Insurance 9,186 2,044 1,393 1,652 1,693 (351) 18% 19% 2% 25 Medical & Dental 76,702 19,414 18,617 17,433 20,582 1,168 27% (6)% 18% Total Salaries & Benefits 574,328 140,070 139,524 144,896 141,382 1,313 25% 4% (2)% 31 Supplies 10,877 2,105 16,240 2,111 2,947 842 27% (87)% 40% 41 Professional Services 25,000 - - - - - - - - 42 Communication 23,170 5,925 5,900 6,755 2,302 (3,623) 10% 14% (66)% 43 Travel 2,250 56 - - 56 - 3% - - 45 Rentals and Leases 25,897 10,494 5,561 5,385 5,949 (4,545) 23% (3)% 10% 46 Insurance 173,286 173,286 90,000 90,000 173,286 - 100% 0% 93% 48 Repairs and Maintenance 20,421 3,404 4,507 3,391 5,610 2,206 27% (25)% 65% 49 Miscellaneous 12,583 3,366 1,795 1,464 3,213 (153) 26% (18)% 120% 64 Machinery & Equipment - - - 11,578 - - - - - Total Operating Expenses 293,484 198,636 124,004 120,685 193,363 (5,272) 66% (3)% 60% Total Expenses 867,812 338,705 263,528 265,580 334,745 (3,960) 39% 1% 26% Percent of year completed FIRE SUPPRESSION 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 5,434,650 1,338,102 1,331,511 1,375,093 1,405,243 67,141 26% 3% 2% 13 Overtime 560,822 115,077 141,231 84,249 119,278 4,202 21% (40)% 42% 15 Holiday Pay 324,520 - 1,124 - - - - - - 21 FICA 84,525 19,778 18,196 19,107 19,885 108 24% 5% 4% 22 Pension -LEOFF 318,206 75,096 73,080 75,398 78,813 3,716 25% 3% 5% 24 Industrial Insurance 328,667 76,836 49,883 59,000 59,142 (17,694) 18% 18% 0% 25 Medical & Dental 1,210,861 304,779 336,698 351,262 317,806 13,026 26% 4% (10)% Total Salaries & Benefits 8,262,251 1,929,668 1,951,723 1,964,110 2,000,168 70,499 24% 1% 2% 31 Supplies 129,100 16,374 80,289 15,546 39,553 23,178 31% (81)% 154% 35 Small Tools 12,000 4,228 30,924 - 4,228 - 35% - - 41 Professional Services 26,500 3,735 4,884 3,553 6,800 3,065 26% (27)% 91% 42 Communication - - 14 - - - - - - 43 Travel - - 1,880 - - - - - - 45 Rentals and Leases 471,460 174,236 113,609 112,089 118,015 (56,221) 25% (1)% 5% 48 Repairs and Maintenance 20,000 8,551 7,210 15,782 13,850 5,300 69% 119% (12)% 49 Miscellaneous 22,791 4,402 5,505 6,098 9,118 4,715 40% 11% 50% Total Operating Expenses 681,851 211,527 244,315 153,068 191,564 (19,963) 28% (37)% 25% Total Expenses 8,944,102 2,141,195 2,196,038 2,117,178 2,191,731 50,536 25% (4)% 4% Percent of year completed 25.00% 83 FIRE PREVENTION /INVESTIGATION YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 558,405 137,673 138,039 138,427 138,577 1 904 25% 0% 0% 13 Overtime 61,143 8,796 11,874 9,011 7,966 (830) 13% (24)% (12)% 21 FICA 18,205 4,327 4,514 4,475 4,489 163 25% (1)% 0% 22 Pension -LEOFF 23,426 5,416 5,229 5,235 5,026 (390) 21% 0% (4)% 23 Pension - PERS /PSERS 18,383 4,392 3,501 4,231 4,293 (98) 23% 21% 1% 24 Industrial Insurance 17,123 3,526 2,794 2,808 3,033 (493) 18% 1% 8% 25 Medical & Dental 87,040 20,732 18,101 19,065 21,081 349 24% 5% 11% Total Salaries & Benefits 783,725 184,861 184,052 183,252 184,466 (396) 24% (0)% 1% 31 Supplies 12,000 4,137 533 4,910 3,063 (1,074) 26% 820% (38)% 41 Professional Services 5,000 - 1,355 - - - - - - 42 Communication - - 336 382 63 63 - 14% (83)% 43 Travel 1,500 597 27 - 597 - 40% - - 45 Rentals and Leases 23,815 4,783 5,460 5,710 6,417 1,633 27% 5% 12% 49 Miscellaneous 7,000 2,039 643 1,115 5,644 3,605 81% 74% 406% Total Operating Expenses 49,315 11,557 8,353 12,117 15,784 4,227 32% 45% 30% Total Expenses 448,048 135,683 f 104,591 102,479 124,810 (10,873) 28% (2)% 22% Total Expenses 833,040 196,418 192,406 195,370 200,250 3,832 24% 2% 2% Percent of year completed FIRE TRAINING 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 234,680 57,113 57,545 58,728 92,986 1 35,873 40% 2% 58% 13 Overtime 18,813 6,005 5,926 2,022 5,465 (540) 29% (66)% 170% 21 FICA 1,818 420 430 421 896 476 49% (2)% 113% 22 Pension -LEOFF 12,678 3,131 3,267 3,125 3,808 677 30% (4)% 22% 24 Industrial Insurance 8,884 2,255 1,589 1,886 2,006 (250) 23% 19% 6% 25 Medical & Dental 43,357 10,949 10,034 10,058 8,212 (2,738) 19% 0% (18)% Total Salaries & Benefits 320,230 79,874 78,791 76,240 113,372 33,498 35% (3)% 49% 31 Supplies 8,500 2,430 509 1,107 577 (1,853) 7% 118% (48)% 41 Professional Services 4,500 2,250 1,400 1,400 - (2,250) - 0% - 42 Communication - - 240 240 80 80 - 0% (67)% 43 Travel 2,000 2,000 722 1,237 3,162 1,162 158% 71% 156% 45 Rentals and Leases 16,818 4,362 2,911 2,969 4,205 (158) 25% 2% 42% 49 Miscellaneous 96,000 44,767 20,019 19,286 3,415 (41,352) 4% (4)% (82)% Total Operating Expenses 127,818 55,809 25,801 26,239 11,439 (44,371) 9% 2% (56)% Total Expenses 448,048 135,683 f 104,591 102,479 124,810 (10,873) 28% (2)% 22% Percent of year completed 84 25.00% FIRE EMERGENCY PREPAREDNESS YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET BUDGET ACTUAL ACTUAL COMPARISON OF RESULTS COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 218,816 51,744 51,280 53,462 62,869 11,125 29% 4% 18% 12 Extra Labor - - - 1,802 911 911 - - (49)% 13 Overtime 9,406 1,065 1,134 2,575 456 (609) 5% 127% (82)% 21 FICA 6,680 1,630 1,431 1,651 1,653 23 25% 15% 0% 22 Pension -LEOFF 7,103 1,629 1,743 1,874 1,784 155 25% 7% (5)% 23 Pension - PERS /PSERS 10,282 2,520 1,711 2,203 2,314 (207) 23% 29% 5% 24 Industrial Insurance 4,795 953 762 938 826 (127) 17% 23% (12)% 25 Medical & Dental 36,587 9,722 8,692 9,319 9,066 (656) 25% 7% (3)% Total Salaries & Benefits 293,669 69,264 66,754 73,823 79,880 10,616 27% 11% 8% 31 Supplies 12,000 2,808 485 8,603 3,089 282 26% 1674% (64)% 35 Small Tools 24,268 - 125,001 - - - - - - 42 Communication - - 1,352 1,853 748 748 - 37% (60)% 43 Travel - - 47 62 - - - 32% - 45 Rentals and Leases 16,368 6,383 1,793 1,883 4,092 (2,291) 25% 5% 117% 49 Miscellaneous 5,000 324 475 495 96 (228) 2% 4% (81)% 64 Machinery & Equipment - - - (11,578) - - - - - Total Operating Expenses 57,636 9,515 129,153 1,318 8,025 (1,490) 14% (99)% 509% Total Expenses 351,305 78,778 195,907 75,141 87,904 9,126 25% (62)% 17% Percent of year completed FIRE FACILITIES 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 Percent of year completed 25.00% 85 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 31 42 47 Supplies Communication Public Utilities 28,500 9,000 73,360 4,665 1,787 18,980 3,686 832 18,589 2,242 435 19,644 4,084 654 20,185 (581) (1,133) 1,204 14% 7% 28% (39)% (48)% 6% 82% 50% 3% Total Operating Expenses 110,860 25,432 23,107 22,321 24,922 (509) 22% (3)% 12% Total Expenses 110,860 25,432 23,107 22,321 24,922 (509) 22% (3)% 12% Percent of year completed 25.00% 85 FIRE HAZARDOUS MATERIALS UNIT YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY BY 2017 ANNUAL 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE % CHANGE % SPEND ALLOCATED BDGT % SPEND 2015/2016 2016/2017 31 Supplies 41 Professional Services 45 Rentals and Leases 2,000 20,000 17,883 - - 7,570 270 - 4,072 - - 4,275 - - 4,471 - - (3,099) - - 25% - - 5% 42,500 - - 5% Total Operating Expenses 39,883 7,570 4,522 4,275 4,471 (3,099) 11% (5)% 2015/2016 2016/2017 5% 5,000 146 - - 146 - 3% - - 35 Small Tools 1,000 - Total Expenses 39,883 7,570 4,522 4,275 4,471 (3,099) 11% (5)% - 5% Percent of year completed FIRE RESCUE TEAM 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 Percent of year completed FIRE RESCUE AND EMERGENCY AID 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY BY 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL % CHANGE EXPENDITURE TYPE % SPEND 2015/2016 2016/2017 31 Supplies 41 Professional Services 45 Rentals and Leases 48 Repairs and Maintenance 26,500 - 15,000 1,000 OVER /(UNDER) 4,460 - 1,706 - % CHANGE ALLOCATED 8,975 120 801 - 47% - 25% - 31% - 5% - 111% - 109% - 2017 42,500 6,298 6,166 7,626 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 31 Supplies 5,000 146 - - 146 - 3% - - 35 Small Tools 1,000 - - - - - - - - 43 Travel 1,250 - - - - - - - - 48 Repairs and Maintenance 500 - - - - - - - - 49 Miscellaneous 5,500 - - - - - - - - Total Operating Expenses 13,250 146 - - 146 - 1% - - Total Expenses 13,250 146 - - 146 - 1% - - Percent of year completed FIRE RESCUE AND EMERGENCY AID 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 31 Supplies 41 Professional Services 45 Rentals and Leases 48 Repairs and Maintenance 26,500 - 15,000 1,000 3,349 - 2,949 - 4,460 - 1,706 - 5,835 - 1,792 - 12,324 120 3,750 - 8,975 120 801 - 47% - 25% - 31% - 5% - 111% - 109% - Total Operating Expenses 42,500 6,298 6,166 7,626 16,193 9,896 38% 24% 112% Total Expenses 42,500 6,298 6,166 7,626 16,193 9,896 38% 24% 112% Percent of year completed 86 25.00% FIRE COMMUNICATIONS, ALARMS AND DISPATCH YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 51 Inter - Governmental 211,768 70,589 51,550 63,663 66,673 (3,916) 31% 23% 5% Total Operating Expenses 211,768 70,589 51,550 63,663 66,673 (3,916) 31% 23% 5% Total Expenses 211,768 70,589 51,550 63,663 66,673 (3,916) 31% 23% 5% Percent of year completed 25.00% 87 TECHNOLOGY & INNOVATION SERVICES CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 869,292 300,458 130,402 224,618 164,242 (136,217) 19% 72% (27)% 12 Extra Labor 2,500 2,500 3,027 1,057 - (2,500) - (65)% - 13 Overtime - - 5,033 6,590 21,391 21,391 - 31% 225% 21 FICA 63,632 21,058 10,418 17,347 14,004 (7,054) 22% 67% (19)% 22 Pension -LEOFF 2 - - - 1,891 - - - - - 23 Pension - PERS /PSERS 104,269 25,235 12,515 15,591 20,754 (4,482) 20% 25% 33% 24 Industrial Insurance 3,176 1,046 605 998 491 (555) 15% 65% (51)% 25 Medical & Dental 194,560 54,731 28,631 36,497 34,887 (19,844) 18% 27% (4)% Total Salaries & Benefits 1,237,429 405,028 190,630 304,589 255,768 (149,260) 21% 60% (16)% 31 Supplies 6,266 6,266 1,282 1,824 21,880 15,614 349% 42% 1100% 35 Small Tools - - 8,237 658 4,963 4,963 - (92)% 654% 41 Professional Services 304,686 3,178 - - 3,178 - 1% - - 42 Communication 120,900 19,978 29,351 21,410 43,916 23,939 36% (27)% 105% 43 Travel 11,500 5 - - 5 - 0% - - 45 Rentals and Leases 153,839 28,464 1,566 1,621 2,148 (26,316) 1% 4% 32% 48 Repairs and Maintenance 2,000 2,000 8,154 908 5,193 3,193 260% (89)% 472% 49 Miscellaneous 147,200 26,013 3,383 6,837 6,490 (19,523) 4% 102% (5)% 64 Machinery & Equipment 43,000 - - - - - - - - Total Operating Expenses 789,391 85,903 51,972 33,259 87,772 1,869 11% (36)% 164% Total Expenses 2,026,820 490,931 242,602 337,848 343,540 (147,391) 17% 39% 2% Percent of year completed 88 25.00% PUBLIC WORKS CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT %SPEND 2015/2016 2016/2017 11 Salaries 1,912,661 467,502 466,096 462,181 440,398 (27,105) 23% (1)% (5)% 13 Overtime 10,000 4,419 1,345 6,190 6,161 1,741 62% 360% (0)% 21 FICA 141,515 35,558 34,905 35,054 33,416 (2,142) 24% 0% (5)% 23 Pension - PERS /PSERS 229,639 56,531 42,450 51,737 49,327 (7,204) 21% 22% (5)% 24 Industrial Insurance 36,725 8,534 5,657 6,436 5,800 (2,734) 16% 14% (10)% 25 Medical & Dental 377,031 92,605 80,401 84,492 88,203 (4,402) 23% 5% 4% 26 Unemployment - - - 6,202 - - - - - 28 Uniform /Clothing 3,200 727 421 378 180 (547) 6% (10)% (52)% Total Salaries & Benefits 2,710,771 665,876 631,274 652,669 623,484 (42,392) 23% 3% (4)% 31 Supplies 110,950 27,484 19,375 26,772 19,150 (8,335) 17% 38% (28)% 35 Small Tools 4,250 664 - 301 66 (598) 2% - (78)% 41 Professional Services 30,900 373 2,184 1,346 3,915 3,542 13% (38)% 191% 42 Communication 9,150 1,418 1,386 1,172 1,935 516 21% (15)% 65% 43 Travel 2,000 462 83 15 422 (41) 21% (82)% 2712% 44 Advertising - - - 463 - - - - - 45 Rentals and Leases 162,978 40,575 40,192 39,492 39,857 (718) 24% (2)% 1% 46 Insurance 106,805 106,805 108,879 106,805 107,271 466 100% (2)% 0% 47 Public Utilities 375,000 91,672 77,078 89,132 103,591 11,919 28% 16% 16% 48 Repairs and Maintenance 252,300 28,196 57,552 26,803 42,625 14,429 17% (53)% 59% 49 Miscellaneous 30,035 2,567 1,071 1,993 1,045 (1,522) 3% 86% (48)% 64 Machinery & Equipment 7,500 - - - 6,890 6,890 92% - - Total Operating Expenses 1,091,868 300,219 307,799 294,294 326,767 26,549 30% (4)% 11% Total Expenses 3,802,639 966,095 939,073 946,963 950,251 (15,844) 25% 1% 0% Percent of year expired PUBLIC WORKS DIVISION SUMMARY 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 Percent of year expired 25.00% 89 BUDGET ACTUAL COMPARISON OF RESULTS ACTUAL SUMMARY BY DIVISION OVER /(UNDER) % CHANGE 2017 ALLOCATED 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 ADMINISTRATION 451,700 113,487 138,526 143,273 107,540 (5,947) 24% 3% (25)% MAINTENANCE ADMINISTRATION 393,700 97,607 91,287 93,712 95,644 (1,963) 24% 3% 2% PUBLIC WORKS DEVELOPMENT 486,910 123,669 113,270 117,634 124,234 566 26% 4% 6% ENGINEERING PLANS AND SERVICES 643,476 144,442 121,298 118,652 105,453 (38,989) 16% (2)% (11)% FACILITY MAINTENANCE 1,819,353 486,889 474,692 473,691 510,488 23,599 28% (0)% 8% Total Expenses 3,795,139 966,095 939,073 946,963 943,361 (22,734) 25% 1% (0)% Percent of year expired 25.00% 89 PUBLIC WORKS ADMINISTRATION YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 316,783 83,389 105,413 106,780 78,654 (4,735) 25% 1% (26)% 21 FICA 21,520 6,169 7,704 7,856 5,799 (371) 27% 2% (26)% 23 Pension - PERS /PSERS 38,030 10,275 9,432 11,688 8,628 (1,648) 23% 24% (26)% 24 Industrial Insurance 1,059 292 243 269 170 (122) 16% 11% (37)% 25 Medical & Dental 37,880 9,678 11,855 12,278 11,429 1,751 30% 4% (7)% Total Salaries & Benefits 415,272 109,804 + 134,648 138,871 104,679 (5,124) 25% 3% (25)% 31 Supplies 9,000 1,776 1,944 2,343 1,632 (143) 18% 21% (30)% 41 Professional Services - - - 753 - - - - - 42 Communication 1,500 380 627 297 40 (340) 3% (53)% (87)% 43 Travel 200 - 40 - - - - - - 45 Rentals and Leases 3,428 848 830 830 619 (229) 18% (0)% (25)% 48 Repairs and Maintenance 1,300 200 437 180 90 (110) 7% (59)% (50)% 49 Miscellaneous 21,000 479 - - 479 - 2% - - Total Operating Expenses 36,428 3,683 3,878 4,402 2,861 (822) 8% 14% (35)% Total Operating Expenses 20,408 4,244 3,000 3,376 2,482 (1,761) 12% 13% (26)% Total Expenses 451,700 113,487 138,526 143,273 107,540 (5,947) 24% 3% (25)% Percent of year expired PUBLIC WORKS MAINTENANCE ADMINISTRATION 25.00°/ YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 259,225 64,822 63,936 63,711 65,152 330 25% (0)% 2% 21 FICA 18,422 4,744 4,754 4,696 4,812 68 26% (1)% 2% 23 Pension - PERS /PSERS 31,120 7,731 5,776 7,061 7,171 (560) 23% 22% 2% 24 Industrial Insurance 1,059 248 151 205 185 (62) 18% 35% (10)% 25 Medical & Dental 63,466 15,819 13,670 14,663 15,842 23 25% 7% 8% Total Salaries & Benefits 373,292 93,363 88,286 90,337 93,162 (201) 25% 2% 3% - 31 Supplies 4,250 612 214 318 161 (451) 4% 49% (49)% 35 Small Tools 750 - - - - - - - - 41 Professional Services 500 - - - - - - - - 42 Communication 750 230 164 222 58 (172) 8% 35% (74)% 43 Travel 300 300 - - 376 76 125% - - 45 Rentals and Leases 11,823 2,216 1,948 1,995 1,538 (678) 13% 2% (23)% 49 Miscellaneous 2,035 886 675 840 350 (536) 17% 24% (58)% Total Operating Expenses 20,408 4,244 3,000 3,376 2,482 (1,761) 12% 13% (26)% Total Expenses 393,700 97,607 91,287 93,712 95,644 (1,963) 24% 3% 2% Percent of year expired 90 25.00 % PUBLIC WORKS PUBLIC WORKS DEVELOPMENT YTD AS OF MARCH 31, 2017 5/30/2017 10:47 Percent of year expired PUBLIC WORKS ENGINEERING PLANS AND SERVICES 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY BY EXPENDITURE 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) ACTUAL % CHANGE ALLOCATED BDGT TYPE 2015/2016 2016/2017 11 Salaries 419,575 OVER /(UNDER) 86,350 % CHANGE ALLOCATED (29,197) 17% (3)% (14)% 2017 FICA 30,825 7,546 6,473 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 11 Salaries 334,218 83,819 81,458 82,272 82,276 (1,544) 25% 1% 0% 13 Overtime 9,000 3,642 1,269 1,677 6,161 2,519 68% 32% 267% 21 FICA 26,120 6,581 6,233 6,363 6,696 115 26% 2% 5% 23 Pension - PERS /PSERS 40,123 10,108 7,576 9,349 9,850 (258) 25% 23% 5% 24 Industrial Insurance 3,793 931 732 771 743 (188) 20% 5% (4)% 25 Medical & Dental 73,406 18,337 15,822 17,022 18,330 (8) 25% 8% 8% 28 Uniform /Clothing 250 250 180 180 180 (70) 72% 0% 0% Total Salaries & Benefits 486,910 123,669 113,270 117,634 124,234 566 26% 4% 6% Total Expenses 486,910 123,669 113,270 117,634 124,234 ' 566 26% 4% 6% Percent of year expired PUBLIC WORKS ENGINEERING PLANS AND SERVICES 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 419,575 100,602 86,350 83,499 71,405 (29,197) 17% (3)% (14)% 21 FICA 30,825 7,546 6,473 6,251 5,314 (2,232) 17% (3)% (15)% 23 Pension - PERS /PSERS 50,370 11,922 7,842 9,178 7,825 (4,097) 16% 17% (15)% 24 Industrial lnsurance 6,174 1,443 578 594 472 (971) 8% 3% (20)% 25 Medical & Dental 73,401 17,817 12,938 12,589 10,919 (6,899) 15% (3)% (13)% 28 Uniform /Clothing 950 - - - - - - - - Total Salaries & Benefits 581,295 139,330 114,181 112,111 95,934 (43,396) 17% (2)% (14)% 31 Supplies 7,000 1,025 874 976 1,214 189 17% 12% 24% 35 Small Tools 1,000 - - - - - - - - 41 Professional Services 28,400 252 2,184 500 3,915 3,663 14% (77)% 683% 42 Communication 2,300 640 484 471 100 (540) 4% (3)% (79)% 43 Travel 1,500 162 42 15 46 (116) 3% (64)% 208% 44 Advertising - - - 463 - - - - - 45 Rentals and Leases 14,981 2,317 3,076 3,204 3,745 1,428 25% 4% 17% 48 Repairs and Maintenance 1,000 193 232 256 283 89 28% 11% 10% 49 Miscellaneous 6,000 522 224 655 216 (306) 4% 192% (67)% Total Operating Expenses 62,181 5,112 7,117 6,541 9,519 4,407 15% (8)% 46% Total Expenses 643,476 144,442 121,298 118,652 105,453 (38,989) 16% (2)% (11)% Percent of year expired 25.00% 91 PUBLIC WORKS FACILITY MAINTENANCE YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 582,860 134,870 128,939 125,919 142,911 8,041 25% (2)% 13% 13 Overtime 1,000 777 76 4,513 - (777) - 5853% - 21 FICA 44,628 10,518 9,740 9,887 10,796 278 24% 2% 9% 23 Pension - PERS /PSERS 69,996 16,494 11,823 14,462 15,854 (640) 23% 22% 10% 24 Industrial Insurance 24,640 5,620 3,953 4,597 4,230 (1,391) 17% 16% (8)% 25 Medical & Dental 128,878 30,953 26,116 27,939 31,683 730 25% 7% 13% 26 Unemployment - - - 6,202 - - - - - 28 Uniform /Clothing 2,000 477 241 198 - (477) - (18)% - Total Salaries & Benefits 854,002 199,710 180,888 193,717 205,473 5,763 24% 7% 6% 31 Supplies 90,700 24,072 16,343 23,135 16,143 (7,929) 18% 42% (30)% 35 Small Tools 2,500 664 - 301 66 (598) 3% - (78)% 41 Professional Services 2,000 121 - 93 - (121) - - - 42 Communication 4,600 168 110 181 1,737 1,568 38% 65% 858% 45 Rentals and Leases 132,746 35,194 34,339 33,463 33,955 (1,239) 26% (3)% 1% 46 Insurance 106,805 106,805 108,879 106,805 107,271 466 100% (2)% 0% 47 Public Utilities 375,000 91,672 77,078 89,132 103,591 11,919 28% 16% 16% 48 Repairs and Maintenance 250,000 27,803 56,883 26,367 42,252 14,449 17% (54)% 60% 49 Miscellaneous 1,000 680 172 498 - (680) - 190% - Total Operating Expenses 965,351 287,180 293,804 279,975 305,015 17,836 32% (5)% 9% Total Expenses 1,819,353 486,889 474,692 473,691 510,488 23,599 28% (0)% 8% Percent of year expired 92 25.00% PARK MAINTENANCE CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 578,408 129,420 147,801 116,837 138,390 8,970 24% (21)% 18% 12 Extra Labor 20,000 247 - 276 537 290 3% - 95% 13 Overtime 2,137 267 118 356 - (267) - 201% - 21 FICA 45,954 9,786 11,195 8,899 10,552 766 23% (21)% 19% 23 Pension - PERS /PSERS 69,438 15,373 13,533 12,974 15,361 (11) 22% (4)% 18% 24 Industrial lnsurance 23,807 4,288 3,969 3,463 3,854 (434) 16% (13)% 11% 25 Medical & Dental 135,009 28,200 29,351 23,878 33,306 5,105 25% (19)% 39% 28 Uniform /Clothing 1,680 246 160 144 12 (234) 1% (10)% (92)% Total Salaries & Benefits 876,433 187,827 206,127 166,826 202,012 14,185 23% (19)% 21% 31 Supplies 53,800 4,801 10,795 12,469 25,223 20,422 47% 16% 102% 35 Small Tools 7,500 4,733 1,046 - 4,733 - 63% - - 41 Professional Services 61,200 5,139 7,628 9,275 14,615 9,475 24% 22% 58% 42 Communication - - - 256 176 176 - - (31)% 43 Travel 225 225 64 - 229 4 102% - - 45 Rentals and Leases 101,992 30,289 29,311 31,801 30,433 144 30% 8% (4)% 47 Public Utilities 290,610 76,212 59,490 65,195 73,051 (3,161) 25% 10% 12% 48 Repairs and Maintenance 23,000 374 1,673 725 715 341 3% (57)% (1)% 49 Miscellaneous 4,000 471 5,697 1,035 3,964 3,492 99% (82)% 283% Total Operating Expenses 542,327 122,245 115,702 120,755 153,137 30,893 28% 4% 27% Total Expenses 1,418,760 310,072 321,829 287,581 355,149 45,077 25% (11)% 23% Percent of year expired 25.00% 93 STREET MAINTENANCE & OPERATIONS CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT %SPEND 2015/2016 2016/2017 11 Salaries 801,234 177,937 174,976 175,160 195,544 17,607 24% 0% 12% 12 Extra Labor 45,000 2,582 - 2,528 3,450 868 8% - 36% 13 Overtime 11,000 2,227 1,189 1,873 6,535 4,308 59% 57% 249% 21 FICA 65,181 13,889 14,198 13,635 15,840 1,950 24% (4)% 16% 23 Pension - PERS /PSERS 96,207 19,657 17,146 18,870 22,978 3,322 24% 10% 22% 24 Industrial lnsurance 31,445 5,804 4,572 4,972 5,777 (28) 18% 9% 16% 25 Medical & Dental 198,694 46,190 34,203 39,658 52,417 6,227 26% 16% 32% 26 Unemployment - - 1,004 - - - - - - 28 Uniform /Clothing 2,375 133 681 112 225 92 9% (83)% 100% Total Salaries & Benefits 1,251,136 268,420 247,970 256,808 302,766 34,346 24% 4% 18% 31 Supplies 297,300 26,249 56,108 19,657 34,216 7,967 12% (65)% 74% 35 Small Tools 13,200 7,700 586 7,702 5,798 (1,902) 44% 1215% (25)% 41 Professional Services 4,000 762 1,034 937 762 0 19% (9)% (19)% 42 Communication 4,300 450 358 360 120 (330) 3% 1% (67)% 43 Travel 2,700 617 - 91 118 (499) 4% - 30% 44 Advertising 1,500 - - - - - - - - 45 Rentals and Leases 297,801 132,114 108,601 99,007 73,600 (58,514) 25% (9)% (26)% 46 Insurance 24,755 24,755 - 35,455 24,755 - 100% - (30)% 47 Public Utilities 1,152,100 444,107 354,090 433,635 451,631 7,524 39% 22% 4% 48 Repairs and Maintenance 27,100 1,183 - 8,777 1,183 - 4% - (87)% 49 Miscellaneous 5,200 1,277 2,062 817 815 (462) 16% (60)% (0)% 53 Ext Taxes, Oper Assess - - 3 6 1 1 - 105% (87)% 64 Machinery & Equipment 28,500 - - - - - - - - Total Operating Expenses 1,858,456 639,214 522,841 606,443 592,999 (46,215) 32% 16% (2)% Total Expenses 3,109,592 907,633 770,811 863,251 895,764 (11,869) 29% 12% 4% Percent of year expired STREET MAINTENANCE & OPERATIONS DIVISION SUMMARY 25.00°% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY DIVISION BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT %SPEND 2015/2016 2016/2017 ADMINISTRATION 1 1,252,136 268,420 248,360 257,198 303,208 34,788 24% 4% 18% GENERAL SERVICES I 339,956 159,795 111,555 137,131 99,748 (60,047) 29% 23% (27)% ROADWAY 810,800 385,067 301,399 370,816 379,509 (5,558) 47% 23% 2% STRUCTURES 2,500 1,183 - - 1,183 - 47% - - LIGHTING 296,100 52,987 32,460 56,735 56,348 3,361 19% 75% (1)% TRAFFIC CONTROL 271,500 27,475 69,180 22,922 42,222 14,748 16% (67)% 84% SNOW & ICE CONTROL 10,300 1,110 440 871 5,886 4,777 57% 98% 576% STREET CLEANING 62,000 10,127 7,417 8,801 6,190 (3,937) 10% 19% (30)% VIDEO & FIBER 33,500 - - - - - - - - SIDEWALKS 2,300 1,470 - 8,777 1,470 - 64% - (83)% Total Expenses 3,081,092 907,633 770,811 863,251 895,764 (11,869) 29% 12% 4% Percent of year expired 94 25.00% STREET MAINTENANCE & OPERATIONS ADMINISTRATION YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 801,234 177,937 174,976 175,160 195,544 17,607 24% 0% 12% 12 Extra Labor 45,000 2,582 - 2,528 3,450 868 8% - 36% 13 Overtime 11,000 2,227 1,189 1,873 6,535 4,308 59% 57% 249% 21 FICA 65,181 13,889 14,198 13,635 15,840 1,950 24% (4)% 16% 23 Pension - PERS /PSERS 96,207 19,657 17,146 18,870 22,978 3,322 24% 10% 22% 24 Industrial Insurance 31,445 5,804 4,572 4,972 5,777 (28) 18% 9% 16% 25 Medical & Dental 198,694 46,190 34,203 39,658 52,417 6,227 26% 16% 32% 26 Unemployment - - 1,004 - - - - - - 28 Uniform /Clothing 2,375 133 681 112 225 92 9% (83)% 100% Total Salaries & Benefits 1,251,136 268,420 247,970 256,808 302,766 34,346 24% 4% 18% 31 Supplies 1,000 - - - - - - - - 41 Professional Services - - 390 390 442 442 - 0% 13% Total Operating Expenses 1,000 - 390 390 442 442 44% 0% 13% Total Expenses 339,956 159,795 111,555 137,131 99,748 (60,047) 29% 23% (27)% Total Expenses 1,252,136 268,420 248,360 257,198 303,208 34,788 24% 4% 18% Percent of year expired STREET MAINTENANCE & OPERATIONS GENERAL SERVICES 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT %SPEND 2015/2016 2016/2017 31 Supplies 5,000 1,994 793 1,805 361 (1,634) 7% 128% (80)% 35 Small Tools 3,000 - - - - - - - - 41 Professional Services 1,100 576 99 456 99 (477) 9% 361% (78)% 42 Communication 2,500 - - - - - - - - 43 Travel 2,000 617 - 91 118 (499) 6% - 30% 44 Advertising 1,500 - - - - - - - - 45 Rentals and Leases 294,401 130,576 108,601 98,507 73,600 (56,975) 25% (9)% (25)% 46 Insurance 24,755 24,755 - 35,455 24,755 - 100% - (30)% 48 Repairs and Maintenance 500 - - - - - - - - 49 Miscellaneous 5,200 1,277 2,062 817 815 (462) 16% (60)% (0)% Total Operating Expenses 339,956 159,795 111,555 137,131 99,748 (60,047) 29% 23% (27)% Total Expenses 339,956 159,795 111,555 137,131 99,748 (60,047) 29% 23% (27)% Percent of year expired 25.00% 95 STREET MAINTENANCE & OPERATIONS ROADWAY YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 2015 2016 2017 ACTUAL OVER /(UNDER) ACTUAL % CHANGE ALLOCATED % SPEND 2015/2016 2016/2017 31 Supplies 48 Repairs and Maintenance 1,000 1,500 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 31 Supplies 39,000 6,219 1,182 3,359 2,543 (3,677) 7% 184% (24)% 35 Small Tools 4,000 4,000 - 6,296 28 (3,972) 1% - (100)% 41 Professional Services 100 - - - - - - - - 43 Travel 100 - - - - - 41 Professional Services - - 45 Rentals and Leases 3,400 1,539 - 500 - (1,539) - - - 47 Public Utilities 764,100 373,309 300,217 360,660 376,938 3,629 49% 20% 5% 48 Repairs and Maintenance 100 - - - - - - - - Total Operating Expenses 810,800 385,067 301,399 370,816 379,509 (5,558) 47% 23% 2% Total Expenses 296,100 52,987 Total Expenses 810,800 385,067 301,399 370,816 379,509 (5,558) 47% 23% 2% Percent of year expired STREET MAINTENANCE & OPERATIONS STRUCTURES 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) ACTUAL % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 31 Supplies 48 Repairs and Maintenance 1,000 1,500 - 1,183 - - - - - 1,183 - - - 79% - - - - Total Operating Expenses 2,500 1,183 - - 1,183 - 47% - - 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT %SPEND 2015/2016 Total Expenses 2,500 1,183 - - 1,183 - 47% - - Percent of year expired STREET MAINTENANCE & OPERATIONS LIGHTING 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 Percent of year expired 96 25.00° BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY BY EXPENDITURE ACTUAL TYPE OVER /(UNDER) % CHANGE ALLOCATED 2017 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT %SPEND 2015/2016 2016/2017 31 Supplies 25,000 2,031 - 1,001 2,906 875 12% - 190% 35 Small Tools 500 - - - - - - - - 41 Professional Services 500 86 - 91 35 (51) 7% - (61)% 43 Travel 100 - - - - - - - - 47 Public Utilities 270,000 50,870 32,460 55,644 53,408 2,538 20% 71% (4)% Total Operating Expenses 296,100 52,987 32,460 56,735 56,348 3,361 19% 75% (1)% Total Expenses 296,100 52,987 32,460 56,735 56,348 3,361 19% 75% (1)% Percent of year expired 96 25.00° STREET MAINTENANCE & OPERATIONS TRAFFIC CONTROL YTD AS OF MARCH 31, 2017 5/30/2017 10:47 Percent of year expired STREET MAINTENANCE & OPERATIONS SNOW & ICE CONTROL 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL SUMMARY BY EXPENDITURE 2015 2016 2017 ACTUAL OVER /(UNDER) ACTUAL ALLOCATED BDGT % SPEND 2015/2016 2016/2017 TYPE 10,000 300 1,110 - 440 - 871 - 5,886 - OVER /(UNDER) 59% - % CHANGE ALLOCATED 10,300 1,110 440 871 5,886 2017 57% 98% 576% 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 31 Supplies 166,000 6,822 50,041 5,823 17,557 10,735 11% (88)% 202% 35 Small Tools 2,500 2,500 586 1,361 4,310 1,810 172% 132% 217% 41 Professional Services 100 100 230 - 186 86 186% - - 42 Communication 1,800 450 358 360 120 (330) 7% 1% (67)% 43 Travel 100 - - - - - - - - 47 Public Utilities 81,000 17,603 17,966 15,378 20,049 2,446 25% (14)% 30% 48 Repairs and Maintenance 20,000 - - - - - - - - Total Operating Expenses 271,500 27,475 69,180 22,922 42,222 14,748 16% (67)% 84% Total Expenses 271,500 27,475 69,180 22,922 42,222 14,748 16% (67)% 84% Percent of year expired STREET MAINTENANCE & OPERATIONS SNOW & ICE CONTROL 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 31 Supplies 43 Travel 10,000 300 1,110 - 440 - 871 - 5,886 - 4,777 - 59% - 98% 576% - Total Operating Expenses 10,300 1,110 440 871 5,886 4,777 57% 98% 576% 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT %SPEND Total Expenses 10,300 1,110 440 871 5,886 4,777 57% 98% 576% Percent of year expired STREET MAINTENANCE & OPERATIONS STREET CLEANING 25.00°% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 Percent of year expired 25.00% 97 BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY BY EXPENDITURE ACTUAL TYPE OVER /(UNDER) % CHANGE ALLOCATED 2017 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT %SPEND 2015/2016 2016/2017 31 Supplies 18,000 6,602 3,653 6,797 3,493 (3,109) 19% 86% (49)% 35 Small Tools 1,200 1,200 - 45 1,459 259 122% - 3161% 41 Professional Services 2,200 - 315 - - - - - - 43 Travel 100 - - - - - - - - 47 Public Utilities 37,000 2,325 3,447 1,953 1,237 (1,088) 3% (43)% (37)% 48 Repairs and Maintenance 3,500 - - - - - - - - 53 Ext Taxes, Assessments - - 3 6 1 1 - 105% (87)% Total Operating Expenses 62,000 10,127 7,417 8,801 6,190 (3,937) 10% 19% (30)% Total Expenses 62,000 10,127 7,417 8,801 6,190 (3,937) 10% 19% (30)% Percent of year expired 25.00% 97 STREET MAINTENANCE & OPERATIONS VIDEO & FIBER YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 31 Supplies 35 Small Tools 48 Repairs and Maintenance 30,000 2,000 1,500 - - - - - - - - - - - - - - - - - - - - - - - - Total Operating Expenses 33,500 - - 8,777 - - - - - Total Expenses 33,500 - - - - - - - - Percent of year expired STREET MAINTENANCE & OPERATIONS SIDEWALKS 25.00% YTD AS OF MARCH 31, 2017 5/30/2017 10:47 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER /(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 31 Supplies 48 Repairs and Maintenance 2,300 - 1,470 - - - - 8,777 1,470 - - - 64% - - - - - Total Operating Expenses 2,300 1,470 - 8,777 1,470 - 64% - (83)% Total Expenses 2,300 1,470 - 8,777 1,470 - 64% - (83)% Percent of year expired 98 25.00%