Loading...
HomeMy WebLinkAboutCOW 2017-11-13 Item 5C - Report - 2017 3rd Quarter Financial ResultsCity of Tukwila INFORMATIONAL MEMORANDUM TO: Finance Committee FROM: Peggy McCarthy, Finance Director BY: Craig Zellerhoff, Fiscal Coordinator CC: Mayor Ekberg DATE: November 1, 2017 SUBJECT: 2017 3rd 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 third quarter status report is based on financial data available as of October 27th, 2017 for the reporting period ending September 30th, 2017. Revenues are below allocated budget by $1.3 million and expenditures are below budget by $4.18 million. Revenues Expenditures General Fund 2017 Revenues vs Expenditures (Through September 2017) $42.28 Budget Actual $42.90 $43.57 Budget $47.08 $39 $40 $41 $42 $43 $44 $45 $46 $47 $48 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. 15 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. $s 0 $7 General Fund Rolling 14 month Revenue and Expense Summary d 1 i iiIlIII1Ih �Iir�i�I Aug -16 Sep -16 Oct -16 Nov -16 Dec -16 Jan -17 Feb -17 Mar -17 Apr -17 May -17 Jun -17 Jul -17 Aug -17 Sep -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. 16 INFORMATIONAL MEMO Page 3 Revenues Through September 2017, general fund revenues totaled $42.28 million compared to an allocated budget of $43.57 million and were $574 thousand higher than revenues collected for the same period in 2016. Notable variances to budget for the third quarter are noted below. 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 September 2017) Mffil$8,136 $8,351 I$558 $617 $3,139 $3,123 $11,,812812 $2,973 $2,732 $3,688 $3,825 $3,709 $3,614 M$1,2 $1,877 $2,077 I$180 $186 I$388 $344 $1,709 $1,709 $14 046 $15,182 Tukwila Village $0 $0 $2,000 $4,000 $6,000 $8,000 $10,000 $12,000 $14,000 $16,000 Thousa nds Year to Date • Budget • Sales and use taxes, which includes local retail sales and use tax, natural gas tax, and criminal justice sales tax, totaled $14.05 million, which is below budget by $1.14 million and is lower in collections for the same period last year by $285 thousand. • Gambling and excise taxes through the end of September totaled $2.97 million and exceed allocated budget by $241 thousand. • RGRL fees, which are reported on the Licenses and Permits line, is $147 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 $63 thousand below budget. • Property tax collections are $215 thousand below budget through September. 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. 17 INFORMATIONAL MEMO Page 4 • Charges for services are below allocated budget by $200 thousand. Several factors are influencing this category. Security revenue is lower than budget because courts now must consider a person's ability to pay before imposing costs and there have been few cases needing intensive supervision. A portion of Transportation revenue is reimbursement from individuals damaging city owned property and the budget is based in historical revenue trends and 2017. Less damage has been done to city -owned property in 2017 than in previous years. Expenditures General fund expenditures through the end of September 2017 totaled $42.9 million as compared to an allocated budget of $47.1 million, which is $4.2 million below budget. Notable variances described below. Year to Date Department Expenditures Compared to Allocated Budget (Through September2017) City Council I $250 $278 Mayor Human Resources Finance $496 $561 Attorney $380 $424 Recreation Community Dev. Municipal Court _ $905 $950 Police Fire $2,591 $2,851 $1,847 $2,102 $2,346 $2,424 $2,411 $2,687 Tech.& Innovation $1,256 $1,193 Public Works $2,645 $2,844 mil Park Maintenance $1,079 $1,068 Street Maint & Ops Dept 20 $2,421 $2,535 $2,390 $8,790 $8,754 $13,092 $13,984 $4,424 $0 $2,000 $4,000 $6,000 $8,000 $10,000 $12,000 $14,000 $16,000 Thousands ■ Year to Date •Allocated Budget • Fire department has exceeded budget by $36 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 underspend of $54 thousand year-to-date. The overtime results include reimbursable costs of $125 thousand for local response to hurricanes. • Park department has exceeded budget by $11 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. Since the end of 2nd quarter, expenditures have been lower each month than in 2016 during the same time period. 18 INFORMATIONAL MEMO Page 5 • Professional Services allocated budget is under budget due to the Technology Services change in budget usage in 2017 compared to 2016. The Technology Services budget increased by $157 thousand in response to the approach to services provided. Through the 3rd quarter 2017 Technology Services has spent $10 thousand of the $305 thousand budgeted. Technology Services plans to spend the $305 thousand in 2017 as most of the expenses will occur in the 4th quarter. • Rentals and Leases allocated budget is affected by the true up of costs at the end of the year. In 2016 each of the departments received reductions in expenses in December from Fleet services, which are not factored into the allocated budget through the 3rd quarter. Based on the projected spend in 2017 Repairs and Maintenance will be very close to utilizing the entire budget amount. Fund Summary The chart below is a summary of ending balances for each of the fund types as of September 30,2017. Fund Summary General/ Contingency Special Revenue Capital Projects Enterprise Internal Service Debt Beginning Fund Balance 17,890,260 1,466,097 45,947,009 17,240,620 6,770,635 1,292,357 Revenues 42,316,147 551,546 15,387,809 20,690,502 6,668,037 2,245,206 Expenditures (42,898,272) (550,049) (7,423,049) (17,758,299) (6,612,854) (1,307,070) Ending Fund Balance 17,308,135 1,467,594 53,911,769 20,172,823 6,825,818 2,230,493 General/Continaenc General Fund General Contingency Beginning Fund Balance 11,839,636 6,050,624 Revenues 42,282,494 33,653 Expenditures (42,898,272) - Ending Fund Balance 11,223,859 6,084,277 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 September 2017, revenues exceeded expenditures in the Lodging tax fund. Expenditures for the Seizure fund are greater than revenue by $316 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 519,551 31,996 Expenditures (201,244) (348,805) Ending Fund Balance 1,230,865 236,729 19 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 658,932 3,999,376 3,352,113 295,040 391,903 736,518 36,513,127 - Revenues 9,341,667 4,631,382 919,272 2,072 151,087 277,877 64,453 - Evenditures (1,182,813) (5,201,495) (239,823) (54,181) (179,595) - (423,116) (142,027) Ending Fund Balance 8,817,786 3,429,264 4,031,562 242,931 363,395 1,014,395 36,154,464 (142,027) Residential Streets: Major projects include 42nd Ave S Phase III and 53rd Ave S street improvement projects. Through September, $421 thousand has been spent on 42nd Ave and 53rd had expenditures of $562 thousand. Bonds of $8.8 million were issued in July. Arterial Streets: Through September 2017, major projects in the arterial street fund include the TUC Pedestrian/Bicycle Bridge project, which had expenditures of $3.3 million and S 144th St Phase II which had expenditures of $1.1 million. Several other projects had activity as well through the end of third quarter. Additionally, the arterial streets fund has received $873 thousand in REET and $2.2 million from WSDOT for the regional mobility grant. Land Acq, Recreation & Parks Development: Through June, $873 thousand in REET revenue has been received. Just under $73 thousand has been spent on the Duwamish Hill Preserve project and $55 thousand on the Duwamish Gardens project. Cascade View Park Playground Equipment project incurred $79 thousand in expenditures. Public Safety Plan: Through September $126 thousand has been spent on the Justice Center and $297 has been spent on the three fire stations. City Facilities: Through September, $142 thousand has been spent on preliminary siting for the Public Works shops facility. Budgeted revenue for this fund is bond proceeds. Bonds will be not sold in 2017 so an operating transfer to cover these costs will need to be included in the 2017 budget amendments. 20 INFORMATIONAL MEMO Page 7 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 5,519,837 7,596,153 1,397,014 6,177,498 Expenditures (6,247,013) (6,834,351) (1,397,210) (3,279,726) Ending Fund Balance 5,965,574 8,588,788 117,786 5,500,674 Water: Revenue through the end of third quarter is at $5.5 million, or 80% of budget while expenses are at $6.2 million, or 71% of budget. Through September, $1.8 million has been spent on the Andover Pk E Water/Sewer Main Replacement project. Sewer: Revenue through the end of third quarter is at $7.6 million, or 88% of budget while expenses are at $6.8 million, or 61% of budget. Through September, $1.4 million has been spent on the Andover Pk E Water/Sewer Main Replacement project. Surface Water: Revenue through September is at $6.2 million, or 83% of budget while expenses are at $3.3 million, or 40% of budget. With the late start of the 42nd Ave S/Gillam Cree project, construction expenditures will be lower in 2017 than budgeted. Revenue for the golf course is weather dependent and is typically lower during the winter months while expenditures remain consistent throughout the year. Revenue is on par with budget at $1.4 million received, or 75% of budget and expenses are at $1.4 million, or 75% of budget. 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 September, all internal service funds have sufficient funds to meet expenses. 21 Self Insured Self Insured Internal Service Funds Fleet Healthcare - Healthcare - Actives Retirees Beginning Fund Balance 4,393,334 1,494,823 882,478 Revenues 2,008,476 4,467,990 191,572 Expenditures (1,640,826) (4,643,796) (328,232) Ending Fund Balance 4,760,984 1,319,017 745,818 21 GENERAL FUND CITY OF TUKWILA GENERAL FUND REVENUES YTD AS OF SEPTEMBER 30, 2017 10/30/2017 16:24 SUMMARY BY REVENUE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 2017 ANNUAL ALLOCATED 2015 2016 2017 OVER/(UNDER) % REVD % CHANGE ALLOCATED BDGT 2015/2016 2016/2017 PROPERTY TAX 14,906,636 8,351,425 7,819,786 8,120,664 8,136,439 (214,985) 55% 4% 0°% SALES TAX 20,026,555 15,182,493 14,350,288 14,330,588 14,046,074 (1,136,420) 70% (0)% (2)% ADMISSIONS TAX 760,000 616,869 529,560 562,579 558,400 (58,469) 73% 6% (1)% UTILITY TAX 4,118,053 3,122,825 2,878,156 3,066,392 3,139,174 16,349 76% 7% 2% INTERFUND UTILITY TAX 2,161,000 1,811,512 1,709,726 1,791,063 1,877,158 65,646 87% 5% 5% GAMBLING & EXCISE TAX 3,931,400 2,732,006 2,140,555 2,635,735 2,973,421 241,415 76% 23% 13% TOTAL GENERAL REVENUE 45,903,644 31,817,130 29,428,072 30,507,021 30,730,666 (1,086,464) 67% 4% 1% RGRL 1,900,000 1,887,308 1,843,121 1,797,480 1,740,367 (146,941) 92% (2)% (3)% BUSINESS LICENSES 873,640 775,591 747,606 731,351 721,360 (54,230) 83% (2)% (1)% RENTAL HOUSING 45,000 37,005 41,100 37,490 41,220 4,215 92% (9)% 10% BUILDING PERMITS 1,389,600 1,124,751 1,029,921 1,056,557 1,185,374 60,623 85% 3% 12% TOTAL LICENSES AND PERMITS 4,208,240 3,824,655 3,661,748 3,622,878 3,688,321 (136,333) 88% (1)% 2% SALES TAX MITIGATION 1,140,000 860,858 851,096 847,295 820,163 (40,694) 72% (0)% (3)% FRANCHISE FEE 2,199,500 1,684,581 1,669,992 1,602,580 1,621,568 (63,012) 74% (4)% 1% GRANT 553,591 278,335 318,892 364,242 512,890 234,556 93% 14% 41% STATE ENTITLEMENTS 416,533 284,680 244,442 227,776 301,153 16,473 72% (7)% 32% INTERGOVERNMENTAL 553,626 506,035 37,688 124,059 453,155 (52,880) 82% 229% 265% TOTAL INTERGOVERNMENTAL REVENUE 4,863,250 3,614,487 3,122,109 3,165,951 3,708,930 94,442 76% 1% 17% GENERAL GOVERNMENT 35,265 31,743 42,499 30,419 38,532 6,789 109% (28)% 27% SECURITY 685,726 485,553 354,810 533,757 433,174 (52,379) 63% 50% (19)% TRANSPORTATION 109,000 79,439 6,878 38,877 21,527 (57,912) 20% 465% (45)% PLAN CHECK AND REVIEW FEES 905,090 700,910 955,138 606,044 603,989 (96,921) 67% (37)% (0)% CULTURE AND REC FEES 1,035,840 779,507 774,942 885,882 779,675 167 75% 14% (12)% TOTAL CHARGES FOR SERVICES 2,770,921 2,077,153 2,134,267 2,094,979 1,876,896 (200,256) 68% (2)% (10)% FINES & PENALTIES 266,829 185,674 135,240 185,826 180,191 (5,483) 68% 37% (3)% MISC 573,749 343,691 336,348 456,684 388,197 44,506 68% 36% (15)% INDIRECT COST ALLOCATION 2,279,058 1,709,294 1,691,490 1,675,107 1,709,294 0 75% (1)0% 2% TOTAL OTHER INCOME 3,119,636 2,238,658 2,163,078 2,317,617 2,277,681 39,023 73% 7% (2)% TOTAL OPERATING REVENUE 60,865,691 43,572,083 40,509,273 41,708,446 42,282,494 (1,289,589) 69% 3% 1% TRANSFERS IN (TUKWILA VILLAGE) 1,800,000 - - - - - 0% 0% 0% TOTAL REVENUE 62,665,691 43,572,083 40,509,273 41,708,446 42,282,494 (1,289,589) 67% 3% 1% 22 GENERAL FUND CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF SEPTEMBER 30, 2017 10/30/2017 16:24 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 277,710 234,254 245,148 249,547 (28,163) 68% 5% 2% 03 Mayor 4,079,582 2,851,102 2,515,592 2,748,552 2,591,379 (259,723) 64% 9% (6)% 04 Human Resources 706,208 561,048 458,263 511,264 496,247 (64,801) 70% 12% (3)% 05 Finance 2,638,813 2,102,356 1,941,928 1,727,012 1,846,892 (255,464) 70% (11)% 7% 06 Attorney 716,955 423,713 367,514 313,782 379,561 (44,152) 53% (15)% 21% 07 Recreation 3,384,688 2,424,365 2,169,604 2,243,254 2,345,991 (78,374) 69% 3% 5% 08 Community Development 3,693,338 2,686,717 2,283,937 2,355,718 2,410,508 (276,209) 65% 3% 2% 09 Municipal Court 1,307,808 949,786 852,547 854,670 905,381 (44,406) 69% 0% 6% 10 Police 18,288,092 13,983,562 12,736,086 13,523,909 13,092,140 (891,422) 72% 6% (3)% 11 Fire 11,862,568 8,753,918 8,778,756 8,470,262 8,789,700 35,781 74% (4)% 4% 12 Technology & Innovation Svcs 2,026,820 1,193,228 768,618 899,101 1,256,059 62,831 62% 17% 40% 13 Public Works 3,802,639 2,844,247 2,512,897 2,736,753 2,645,086 (199,160) 70% 9% (3)% 15 Park Maintenance 1,418,760 1,068,094 1,048,740 1,025,292 1,078,928 10,834 76% (2)% 5% 16 Street Maintenance & Operations 3,109,592 2,534,680 2,059,449 2,419,833 2,421,350 (113,330) 78% 17% 0% 20 Dept20 5,237,691 4,423,721 4,268,885 4,019,855 2,389,503 (2,034,218) 46% (6)% (41)% Total Expenditures 62,639,570 47,078,248 42,997,069 44,094,405 42,898,272 (4,179,976) 68% 3% (3)% Percent of year completed 75.00% 23 GENERAL FUND CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF SEPTEMBER 30, 2017 10/30/2017 16:24 SUMMARY OF SALARIES AND BENEFITS BUDGET BUDGET ACTUAL 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 20,602,504 19,079,225 19,681,228 20,057,149 (545,355) 73% 3% 2% 12 Extra Labor 777,897 564,889 492,001 515,630 537,780 (27,110) 69% 5% 4% 13 Overtime 1,632,035 1,264,356 1,348,155 1,121,729 1,257,252 (7,103) 77% (17)% 12% 15 Holiday Pay 525,583 80,848 4,767 82,934 79,930 (918) 15% 1640% (4)% 21 FICA 1,809,260 1,380,761 1,244,643 1,284,707 1,318,877 (61,884) 73% 3% 3% 22 Pension-LEOFF2 849,253 611,396 588,988 596,727 614,585 3,189 72% 1% 3% 23 Pension-PERS/PSERS 1,580,986 1,184,766 886,435 1,035,903 1,119,321 (65,445) 71% 17% 8% 24 Industrial Insurance 864,098 604,146 429,038 483,182 463,078 (141,068) 54% 13% (4)% 25 Medical & Dental 5,903,094 4,438,538 3,928,259 4,200,060 4,206,933 (231,605) 71% 7% 0% 26 Unemployment 13,000 - 1,285 28,991 3,956 3,956 30% 2155% (86)% 28 Uniform/Clothing 10,460 3,974 3,708 2,494 1,978 (1,996) 19% (33)% (21)% Total Salaries and Benefits 41,526,657 30,736,177 28,006,504 29,033,585 29,660,838 I (1,075,339) 71% 4% 2% Percent of year completed 75.00% Percent of year completed 24 75.00% SUMMARY OF SUPPLIES, SERVICES, AND CAPITAL BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) °A CHANGE ALLOCATED BDGT % SPENT 2015/2016 2016/2017 Transfers 5,237,691 4,423,721 4,268,885 4,019,855 2,389,503 (2,034,218) 46% (6)% (41)% 31 Supplies 1,164,823 891,399 842,918 858,333 827,517 (63,881) 71% 2% (4)% 34 Items Purchased for resale 22,000 16,310 21,915 16,439 15,307 (1,003) 70% (25)% (7)% 35 Small Tools 99,818 58,758 270,791 61,909 74,412 15,654 75% (77)% 20% 41 Professional Services 3,266,711 1,965,768 1,897,403 1,740,630 1,770,594 (195,174) 54% (8)% 2% 42 Communication 449,970 264,562 241,099 235,222 272,565 8,002 61% (2)% 16% 43 Travel 192,380 147,581 102,146 106,564 133,854 (13,727) 70% 4% 26% 44 Advertising 51,500 29,422 23,142 16,415 14,343 (15,079) 28% (29)% (13)% 45 Rentals and Leases 2,314,372 2,097,567 2,020,658 1,966,664 1,754,783 (342,785) 76% (3)% (11)% 46 Insurance 886,895 886,895 785,581 810,799 887,617 722 100% 3% 9% 47 Public Utilities 1,893,570 1,579,517 1,364,057 1,521,197 1,645,921 66,405 87% 12% 8% 48 Repairs and Maintenance 732,613 474,933 445,502 466,278 353,019 (121,914) 48% 5% (24)% 49 Miscellaneous 1,562,773 1,135,119 810,049 746,266 784,543 (350,576) 50% (8)% 5% 51 Inter -Governmental 3,003,792 2,299,851 1,855,976 2,057,846 2,259,800 (40,051) 75% 11% 10% 53 Ext Taxes, Oper. Assess 5 - 48 549 219 219 4378% 1054% (60)% 64 Machinery & Equipment 234,000 70,667 40,395 435,853 53,435 (17,231) 23% 979% (88)% Total Supplies, Services, and Capital 21,112,913 16,342,071 14,990,565 15,060,820 13,237,433 (3,104,637) 63% 0% (12)% Percent of year completed 24 75.00% CITY COUNCIL CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 Percent of year completed 75.00% 25 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 11 Salaries 199,767 149,335 136,809 144,905 149,270 (65) 75% 6% 3% 21 FICA 15,680 11,724 10,740 11,385 11,747 23 75% 6% 3% 23 Pension-PERS/PSERS 11,386 8,501 6,269 7,473 8,248 (253) 72% 19% 10% 24 Industrial Insurance 2,823 1,995 1,708 1,764 1,642 (353) 58% 3% (7)% 25 Medical & Dental 59,090 44,144 40,820 40,470 44,287 142 75% (1)% 9% Total Salaries & Benefits 288,746 215,700 196,346 205,996 215,193 (507) 75% 5% 4% 31 Supplies 4,370 3,624 2,513 3,255 1,212 (2,411) 28% 30% (63)% 41 Professional Services 16,500 16,500 6,959 1,865 - (16,500) - (73)% - 42 Communication 6,000 4,446 2,940 3,345 3,225 (1,221) 54% 14% (4)% 43 Travel 40,000 29,969 21,673 23,217 23,292 (6,676) 58% 7% 0% 49 Miscellaneous 10,400 7,472 3,824 7,470 6,625 (847) 64% 95% -11% Total Operating Expenses 77,270 62,011 37,908 39,152 34,354 (27,656) 44% 3% (12)% Total Expenses 366,016 277,710 234,254 245,148 249,547 (28,163) 68% 5% 2% Percent of year completed 75.00% 25 MAYOR CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 1,136,959 1,076,266 1,098,195 1,082,662 (54,297) 72% 2% (1)% 12 Extra Labor 53,500 13,052 8,473 1,700 12,002 (1,050) 22% (80)% 606% 13 Overtime 532 - -- 58% - - - - - 21 FICA 112,437 86,580 81,188 82,307 83,480 (3,100) 74% 1% 1% 23 Pension-PERS/PSERS 180,721 133,724 105,754 117,334 122,264 (11,460) 68% 11% 4% 24 Industrial Insurance 5,647 4,193 3,342 3,261 3,396 (797) 60% (2)% 4% 25 Medical & Dental 295,280 221,205 185,009 201,632 213,304 (7,901) 72% 9% 6% Total Salaries & Benefits 2,156,902 1,595,712 1,460,031 1,504,430 1,517,108 (78,604) 70% 3% 1% 31 Supplies 59,544 40,827 44,749 32,547 21,706 (19,121) 36% (27)% (33)% 35 Small Tools 5,500 - 1,852 1,239 - - - (33)% - 41 Professional Services 1,169,970 781,393 720,891 744,597 677,490 (103,902) 58% 3% (9)% 42 Communication 112,600 52,251 31,219 43,432 46,209 (6,042) 41% 39% 6% 43 Travel 41,550 31,870 19,292 18,287 15,244 (16,626) 37% (5)% (17)% 44 Advertising 19,750 10,235 6,449 3,670 5,050 (5,185) 26% (43)% 38% 45 Rentals and Leases 39,580 26,148 18,731 20,489 28,876 2,728 73% 9% 41% 48 Repairs and Maintenance 32,460 16,308 7,656 28,230 1,767 (14,541) 5% 269% (94)% 49 Miscellaneous 404,726 292,275 201,580 290,733 273,726 (18,549) 68% 44% (6)% 51 Inter -Governmental 37,000 4,083 3,141 4,197 4,202 119 11% 34% 0% 53 Ext Taxes, Oper Assess -- 2 1 0 0 - (63)% (85)% 64 Machinery & Equipment -- - 56,700 - - - - - Total Operating Expenses 1,922,680 1,255,390 1,055,561 1,244,122 1,074,272 (181,118) 56% 18% (14)% Total Expenses 4,079,582 2,851,102 2,515,592 2,748,552 2,591,379 (259,723) 64% 9% (6)% MAYOR DIVISION SUMMARY Percent of year completed 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 678,896 948,499 655,953 674,503 1 (4,392) 72% (31)% 3% ECONOMIC DEVELOPMENT 374,142 306,080 20,192 351,614 299,659 (6,420) 80% 1641% (15)% CITY CLERK 762,873 517,118 446,213 544,154 439,084 (78,034) 58% 22% (19)% COMMUNICATIONS 629,027 423,860 302,084 294,018 403,464 (20,396) 64% (3)% 37% HUMAN SERVICES 813,515 575,330 469,340 575,501 492,877 (82,453) 61% 23% (14)% COURT DEFENDER 477,000 317,695 298,161 307,795 268,911 (48,784) 56% 3% (13)% SISTER CITIES COMM. 6,475 5,550 - 4,613 - (5,550) - - - PLANNING COMMISSION 3,750 3,250 4,172 604 845 (2,405) 23% (86)% 40% EQUITY & DIVERSITY COMMISSION 3,200 2,785 480 30 785 (2,000) 25% (94)% 2517% ARTS COMMISSION 5,000 3,731 3,201 3,834 3,855 124 77% 20% 1% PARKS COMMISSION 3,688 3,291 4,396 2,126 1,730 (1,561) 47% (52)% (19)% LIBRARY ADVISORY BOARD 5,000 2,286 1,134 1,601 1,086 (1,201) 22% 41% (32)% COMMUNITY PROMOTION 26,000 10,878 17,721 6,346 4,233 (6,645) 16% (64)% (33)% VOTER REGISTRATION COSTS 32,000 351 - 364 347 (4) 1% - (5)% Total Expenses 4,079,582 2,851,102 2,515,592 2,748,552 2,591,379 (259,723) 64% 9% (6)% Percent of year completed 26 75.00% MAYOR ADMINISTRATION YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 266,829 503,309 260,799 267,453 624 75% (48)% 3% 12 Extra Labor 5,000 3,602 2,540 1,700 2,552 (1,050) 51% (33)% 50% 21 FICA 23,751 19,102 37,680 20,540 21,856 2,754 92% (45)% 6% 23 Pension-PERS/PSERS 42,361 30,098 49,397 27,439 29,742 (356) 70% (44)% 8% 24 Industrial Insurance 1,059 762 1,272 683 575 (188) 54% (46)% (16)% 25 Medical & Dental 75,374 56,547 67,263 53,292 57,438 891 76% (21)% 8% Total Salaries & Benefits 503,982 376,939 661,460 364,453 379,616 2,676 75% (45)% 4% 31 Supplies 17,200 14,790 29,879 15,345 6,351 (8,439) 37% (49)% (59)% 41 Professional Services 190,000 108,000 126,012 94,999 103,536 (4,463) 54% (25)% 9% 42 Communication -- 2,000 168 - 276 276 - - - 43 Travel 20,000 12,730 12,115 8,815 9,049 (3,682) 45% (27)% 3% 45 Rentals and Leases 25,480 13,395 11,957 12,137 19,651 6,256 77% 2% 62% 48 Repairs and Maintenance 3,250 2,620 - 1,345 - (2,620) - - - 49 Miscellaneous 178,000 150,420 106,906 158,858 156,024 5,604 88% 49% (2)% 53 Ext Taxes, Oper Assess -- 2 1 0 0 - (63)% (85)% Total Operating Expenses 433,930 301,956 287,038 291,500 294,887 (7,069) 68% 2% 1% Total Expenses 937,912 678,896 948,499 655,953 674,503 (4,392) 72% (31)% 3% MAYOR ECONOMIC DEVELOPMENT Percent of year completed 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 198,717 - 249,117 184,996 I (13,721) 75% - (26)% 12 Extra Labor 8,000 6,450 -- 6,450 - 81% - - 21 FICA 17,741 14,957 - 18,191 14,346 (611) 81% - (21)% 23 Pension-PERS/PSERS 29,655 23,544 - 26,084 21,608 (1,936) 73% - (17)% 24 Industrial Insurance 706 706 - 561 841 135 119% - 50% 25 Medical & Dental 21,269 17,448 - 22,588 15,638 _ (1,810) 74% - (31)% Total Salaries & Benefits 324,392 261,823 - 316,542 243,880 (17,943) 75% - (23)% 31 Supplies 1,000 624 332 745 371 (252) 37% 125% (50)% 41 Professional Services 16,000 16,000 5,500 6,100 44,245 28,245 277% 11% 625% 43 Travel 6,000 4,111 3,169 608 738 (3,372) 12% (81)% 21% 44 Advertising 2,000 - 346 - - - - - - 49 Miscellaneous 24,750 23,523 10,845 27,620 10,424 (13,098) 42% 155% (62)% Total Operating Expenses 49,750 44,257 20,192 35,072 55,779 11,522 112% 74% 59% Total Expenses 374,142 306,080 20,192 351,614 299,659 (6,420) 80% 1641% (15)% Percent of year completed 75.00% 27 MAYOR CITY CLERK YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 284,812 270,456 278,741 253,420 I (31,393) 68% 3% (9)% 12 Extra Labor 35,000 - - - - - - - - 21 FICA 30,511 23,284 20,237 20,525 18,972 (4,311) 62% 1% (8)% 23 Pension-PERS/PSERS 44,598 33,708 26,615 29,350 29,639 (4,069) 66% 10% 1% 24 Industrial Insurance 1,764 1,254 1,007 984 891 (363) 51% (2)% (9)% 25 Medical & Dental 92,996 69,026 60,164 64,047 68,570 (456) 74% 6% 7% Total Salaries & Benefits 576,344 412,084 378,478 393,646 371,493 (40,592) 64% 4% (6)% 31 Supplies 12,308 8,510 5,486 7,026 6,903 (1,607) 56% 28% (2)% 41 Professional Services 6,000 4,500 2,312 1,572 1,610 (2,890) 27% (32)% 2% 42 Communication 72,600 29,729 29,219 28,135 35,080 5,351 48% (4)% 25% 43 Travel 5,500 5,500 1,410 2,032 1,411 (4,089) 26% 44% (31)% 44 Advertising 12,300 9,765 6,103 3,619 5,030 (4,735) 41% (41)% 39% 45 Rentals and Leases 10,100 10,083 3,837 5,738 9,538 (545) 94% 50% 66% 48 Repairs and Maintenance 24,710 13,688 7,656 26,885 1,767 (11,920) 7% 251% (93)% 49 Miscellaneous 43,011 23,259 11,713 18,800 6,252 (17,007) 15% 61% (67)% 64 Machinery & Equipment -- 12,029 - 56,700 - _ - - - - Total Operating Expenses 186,529 105,034 67,735 150,508 67,591 (37,443) 36% 122% (55)% Total Expenses 762,873 517,118 446,213 544,154 439,084 (78,034) 58% 22% (19)% MAYOR COMMUNICATIONS Percent of year completed 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 255,928 174,177 179,796 251,997 (3,932) 70% 3% 40% 12 Extra Labor 5,000 3,000 5,933 3,000 I 60% - 21 FICA 27,176 19,303 13,594 13,284 18,883 (420) 69% (2)% 42% 23 Pension-PERS/PSERS 43,205 30,708 17,133 20,035 29,397 (1,310) 68% 17% 47% 24 Industrial Insurance 1,412 969 660 619 789 (180) 56% (6)% 27% 25 Medical & Dental 72,989 53,711 36,235 38,980 53,377 (334) 73% 8% 37% Total Salaries & Benefits 509,527 363,617- 247,732 252,714 357,443 (6,175) 70% 2% 41% 31 Supplies 9,000 1,891 3,021 3,156 1,982 90 22% 4% (37)% 35 Small Tools 5,500 - 1,852 - - - - - - 41 Professional Services 35,000 17,110 25,987 - 17,110 - 49% - - 42 Communication 40,000 22,522 1,832 15,297 10,853 (11,669) 27% 735% (29)% 43 Travel 4,000 4,000 2,499 2,486 4,046 46 101% (1)% 63% 44 Advertising 5,000 20 -- 20 - 0% - - 45 Rentals and Leases 4,000 2,670 2,937 2,614 (313) (2,983) (8)% (11)% (112)% 48 Repairs and Maintenance 2,000 - - - - - - - - 49 Miscellaneous 15,000 12,029 16,225 17,751 12,323 295 82% 9% (31)% Total Operating Expenses 119,500 60,242 54,353 41,304 46,021 (14,221) 39% (24)% 11% Total Expenses 629,027 423,860 302,084 294,018 403,464 (20,396) 64% (3)% 37% Percent of year completed 28 75.00% MAYOR HUMAN SERVICES YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 130,672 128,325 129,743 124,796 (5,876) 72% 1% (4)% 12 Extra Labor 500 - - - - - 56% - - 13 Overtime 532 - - - - -- 41 Professional Services - - 21 FICA 13,258 9,934 9,677 9,768 9,422 (512) 71% 1% (4)% 23 Pension-PERS/PSERS 20,902 15,666 12,610 14,426 11,877 (3,789) 57% 14% (18)% 24 Industrial Insurance 706 502 403 414 301 (201) 43% 3% (27)% 25 Medical & Dental 32,652 24,473 21,346 22,724 18,280 (6,193) 56% 6% (20)% Total Salaries & Benefits 242,657 181,247 172,362 177,074 164,676 (16,571) 68% 3% (7)% 31 Supplies 1,688 1,134 611 720 496 (638) 29% 18% (31)% 41 Professional Services 433,470 317,838 248,999 334,131 242,377 (75,461) 56% 34% (27)% 43 Travel 500 479 99 233 - (479) - 135% - 49 Miscellaneous 135,200 74,632 47,270 63,345 85,327 10,695 63% 34% 35% Total Operating Expenses 570,858 394,083 296,979 398,428 328,201 (65,883) 57% 34% (18)% Total Expenses 813,515 575,330 469,340 575,501 492,877 (82,453) 61% 23% (14)% MAYOR COURT DEFENDER Percent of year completed 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 - 317,695 - 298,161 - 307,795 549 268,362 549 (49,333) - 56% - 3% - (13)% Total Operating Expenses 477,000 317,695 298,161 307,795 268,911 (48,784) 56% 3% (13)% - - - - - - - - 41 Professional Services 500 - Total Expenses 477,000 317,695 298,161 307,795 268,911 (48,784) 56% 3% (13)% MAYOR SISTER CITIES COMM. Percent of year completed 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 Percent of year completed 75.00% 29 BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY BY EXPENDITURE ACTUAL TYPE 2017 OVER/(UNDER) % CHANGE ALLOCATED 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 - 4,113 - (5,050) - - - 49 Miscellaneous 500 500 - 500 - (500) - - - Total Operating Expenses 6,475 5,550 - 4,613 - (5,550) - - Total Expenses 6,475 5,550 - 4,613 - (5,550) - - - Percent of year completed 75.00% 29 MAYOR PLANNING COMMISSION YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL 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 49 Miscellaneous 1,000 500 2,250 1,000 - 2,250 347 - 3,825 154 - 450 - - 845 (1,000)- - (1,405) - 38% (56)% - - - (88)% 88% Total Operating Expenses 3,750 3,250 4,172 604 845 (2,405) 23% (86)% 40% 480 20% 30 785 (2,000) 25% (94)% 2517% Total Expenses 3,750 3,250 4,172 604 845 (2,405) 23% (86)% 40% MAYOR EQUITY & DIVERSITY COMMISSION Percent of year completed 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL ACTUAL COMPARISON OF RESULTS COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2017 2016 2017 ACTUAL OVER/(UNDER) % SPEND % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 31 Supplies 49 Miscellaneous 1,200 2,000 785 2,000 - 3,855 480 - - 77% - 30 785 - - (2,000) 65% - - - - - Total Operating Expenses 3,200 2,785 124 480 20% 30 785 (2,000) 25% (94)% 2517% Total Expenses 5,000 3,731 3,201 3,834 Total Expenses 3,200 2,785 [ 480 30 785 (2,000) 25% (94)% 2517% MAYOR ARTS COMMISSION Percent of year completed 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 51 Inter -Governmental -- 5,000 3,731 60 3,141 - 3,834 - 3,855 - 124 - 77% - 22% - 1% Total Operating Expenses 5,000 3,731 3,201 3,834 3,855 124 77% 20% 1% Total Expenses 5,000 3,731 3,201 3,834 3,855 124 77% 20% 1% Percent of year completed 30 75.00% MAYOR PARKS COMMISSION YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 49 Miscellaneous 1,688 2,000 1,448 1,843 3,181 1,215 372 1,754 1,080 650 (368) (1,193) 64% 33% (88)% 44% 191% (63)% Total Operating Expenses 3,688 3,291 4,396 2,126 1,730 (1,561) 47% (52)% (19)% 2015/2016 2016/2017 31 Supplies 9,035 8,359 744 3,430 2,103 (6,256) 23% 361% Total Expenses 3,688 3,291 4,396 2,126 1,730 (1,561) 47% (52)% (19)% MAYOR LIBRARY ADVISORY BOARD Percent of year completed 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 5,000 - 2,286 - 609 525 1,601 - 1,086 - (1,201) - 22% - 163% - (32)% - Total Operating Expenses 5,000 2,286 1,134 1,601 1,086 (1,201) 22% 41% (32)% 2015/2016 2016/2017 31 Supplies 9,035 8,359 744 3,430 2,103 (6,256) 23% 361% Total Expenses 5,000 2,286 1,134 1,601 1,086 (1,201) 22% 41% (32)% MAYOR COMMUNITY PROMOTION Percent of year completed 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 MAYOR VOTER REGISTRATION COSTS Percent of year completed 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 32,000 2017 - 364 347 OVER/(UNDER) 1% % CHANGE ALLOCATED 32,000 351 - 364 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 31 Supplies 9,035 8,359 744 3,430 2,103 (6,256) 23% 361% (39)% 35 Small Tools - - - 1,239 - - - - - 41 Professional Services 12,000 250 13,395 - 250 - 2% - - 44 Advertising 450 450 - 51 - (450)- - - 48 Repairs and Maintenance 2,500 - - - - - - - - 49 Miscellaneous 2,015 1,819 3,582 1,625 1,880 61 93% (55)% 16% Total Operating Expenses 26,000 10,878 17,721 6,346 4,233 (6,645) 16% (64)% (33)% Total Expenses 26,000 10,878 17,721 6,346 4,233 (6,645) 16% (64)% (33)% MAYOR VOTER REGISTRATION COSTS Percent of year completed 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 75.00% 31 HUMAN RESOURCES CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) 1 % CHANGE I ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 405,299 310,927 303,371 304,638 304,504 (6,423) 75% 0% (0)% 12 Extra Labor 6,000 6,000 - 6,840 - (6,000) - - - 21 FICA 28,947 23,564 22,381 22,784 22,396 (1,168) 77% 2% (2)% 23 Pension-PERS/PSERS 48,653 36,942 29,801 32,610 35,402 (1,541) 73% 9% 9% 24 Industrial Insurance 1,417 1,033 782 802 756 (277) 53% 3% (6)% 25 Medical & Dental 77,642 60,991 48,071 49,789 46,856 (14,135) 60% 4% (6)% Total Salaries & Benefits 567,958 439,457 404,406 417,464 409,913 (29,544) 72% 3% (2)% 31 Supplies 14,817 10,593 6,357 6,675 9,489 (1,104) 64% 5% 42% 41 Professional Services 90,575 79,758 24,615 73,353 58,049 (21,709) 64% 198% (21)% 42 Communication 50 - - - - - - - - 43 Travel 3,000 3,000 2,542 943 1,050 (1,950) 35% (63)% 11% 44 Advertising 6,250 5,629 2,575 5,891 2,283 (3,346) 37% 129% (61)% 45 Rentals and Leases 5,108 4,161 3,140 3,044 3,807 (354) 75% (3)% 25% 48 Repairs and Maintenance 14,000 14,000 12,062 2,790 - (14,000) - (77)% - 49 Miscellaneous 4,450 4,450 2,566 1,103 11,656 7,206 262% (57)% 956% 51 - - - - - - - - 64 Miscellaneous - - -- - - - - - Total Operating Expenses 138,250 121,591 53,857 93,800 86,334 (35,257) 62% 74% (8)%, Total Expenses 706,208 561,048 458,263 511,264 496,247 (64,801) 70% 12% (3)% Percent of year completed 32 75.00% FINANCE CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 795,751 732,498 744,879 775,634 (20,117) 74% 2% 4% 12 Extra Labor 60,000 11,870 5,181 - 11,870 - 20% - - 13 Overtime 9,289 7,122 1,322 5,727 3,978 (3,144) 43% 333% (31)% 21 FICA 79,621 61,474 55,593 56,749 60,011 (1,463) 75% 2% 6% 23 Pension-PERS/PSERS 127,773 96,493 71,428 83,805 89,737 (6,756) 70% 17% 7% 24 Industrial Insurance 4,235 3,015 2,287 2,324 2,261 (754) 53% 2% (3)% 25 Medical & Dental 223,559 169,242 134,021 142,667 159,192 (10,049) 71% 6% 12% 26 Unemployment 13,000 - - - -- - - - Total Salaries & Benefits 1,570,962 1,144,966 1,002,330 1,036,152 1,102,684 (42,282) 70% 3% 6% i 31 Supplies 19,000 9,951 10,228 13,778 7,714 (2,237) 41% 35% (44)% 35 Small Tools 5,000 3,372 265 4,048 254 (3,118) 5% 1425% (94)% 41 Professional Services 170,000 120,524 118,045 99,514 135,630 15,106 80% (16)% 36% 42 Communication 1,000 1,000 199 56 322 (678) 32% (72)% 477% 43 Travel 10,000 7,742 2,149 3,554 7,748 6 77% 65% 118% 45 Rentals and Leases 3,500 2,333 2,462 2,189 1,648 (685) 47% (11)% (25)% 46 Insurance 351,826 351,826 455,581 338,539 352,082 256 100% (26)% 4% 48 Repairs and Maintenance 65,625 65,625 57,278 59,781 85,645 20,020 131% 4% 43% 49 Miscellaneous 441,900 395,017 293,390 168,861 153,146 (241,870) 35% (42)% (9)% 53 Ext Taxes, Oper. Assess _ -- 1 540 18 18 - 89905% (97)% Total Operating Expenses X667,851 957,390 939,598 690,860 744,208 (213,182) 70% (26)% 8% 1 Total Expenses 2,638,813 2,102,356 1,941,928 1,727,012 1,846,892 (255,464) 70% (11)% 7% Percent of year completed 75.00% 33 ATTORNEY CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 12 Extra Labor 21 FICA 24 Industrial Insurance 5,000 355 100 3,935 279 79 1,836 140 23 1,974 151 25 2,070 158 25 (1,865) (121) (54) 41% 45% 25% 8% 8% 11% 5% 5% (3)% Total Salaries & Benefits 5,455 4,294 1,999 2,150 2,253 41% 8% 5% 31 Supplies 41 Professional Services 45 Rentals and Leases 48 Repairs and Maintenance 49 Miscellaneous 6,000 701,000 2,100 1,400 1,000 3,100 414,219 2,100 -- - 3,436 362,021 - 57 2,496 309,136 - - - 1,696 373,275 2,337 - - . _12,041) (1,404) (40,945) 237 - - 28% 53% 111% - -- (27)% (15)% - - (32)% 21% - - - Total Operating Expenses 711,500 419,420 365,515 311,632 377,308 (42,112) 53% (15)% 21% Total Expenses 716,955 423,713 367,514 313,782 379,561 (44,152) 53% (15)% 21% Percent of year completed 34 75.00% RECREATION DEPARTMENT CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL 1 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 1,027,966 967,560 987,487 1,025,212 (2,755) 73% 2% 4% 12 Extra Labor 530,643 418,091 346,939 376,875 391,087 (27,004) 74% 9% 4% 13 Overtime 4,179 3,693 9,018 7,533 5,851 2,158 140% (16)% (22)% 21 FICA 145,838 109,644 99,844 103,800 107,111 (2,533) 73% 4% 3% 23 Pension-PERS/PSERS 168,165 129,405 104,774 125,317 134,981 5,576 80% 20% 8% 24 Industrial Insurance 84,822 53,604 52,177 56,343 48,351 (5,253) 57% 8% (14)% 25 Medical & Dental 320,924 237,722 206,439 221,655 240,666 2,944 75% 7% 9% 26 Unemployment- - - 138 (2,182) 2,033 2,033 - (1683)% (193)% 28 Uniform/Clothing 230 225 197 - 225 - 98% - - Total Salaries & Benefits 2,655,457 1,980,350 1,787,086 1,876,827 1,955,516 (24,835) 74% 5% 4% 31 Supplies 125,986 100,507 83,428 92,058 97,017 (3,490) 77% 10% 5% 34 Items Purchased for resale 22,000 16,310 21,915 16,439 15,307 (1,003) 70% (25)% (7)% 35 Small Tools 11,000 1,631 - - 1,631 - 15% - - 41 Professional Services 208,480 136,953 110,996 120,447 120,976 (15,977) 58% 9% 0% 42 Communication 12,150 5,294 5,906 6,846 6,209 915 51% 16% (9)% 43 Travel 8,725 7,771 3,870 5,917 14,441 6,670 166% 53% 144% 44 Advertising 22,500 13,158 13,270 6,390 6,255 (6,903) 28% (52)% (2)% 45 Rentals and Leases 48,590 35,589 39,490 41,430 36,910 1,321 76% 5% (11)% 48 Repairs and Maintenance 30,400 2,875 14,252 10,511 2,080 (795) 7% (26)% (80)% 49 Miscellaneous 109,400 59,259 78,613 61,071 68,666 9,407 63% (22)% 12% 64 Machinery & Equipment 130,000 64,667 10,779 5,316 20,983 (43,683) 16% (51)% 295% Total Operating Expenses 729,231 444,014 382,518 366,426 390,475 (53,539) 54% (4)% 7% Total Expenses 3,384,688 2,424,365 2,169,604 2,243,254 2,345,991 (78,374) 69% 3% 4% Percent of year completed RECREATION DIVISION SUMMARY 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 r 481,514 335,0521 252,596 219,005 293,746 (41,307) 61% (13)% 34% RECREATION 462,343 352,378 1,191,698 1,291,869 329,236 (23,141) 71% 8% (75)% PRESCHOOL PROGRAM 79,776 61,848 - - 64,260 2,412 81% - - YOUTH PROGRAMS 564,781 421,366 - - 422,863 1,497 75% - - TEEN PROGRAMS 201,780 154,995 - - 162,399 7,404 80% - - YOUTH WELLNESS AND ENRICHMEh 148,978 100,285 - - 103,608 3,323 70% - - ADULT WELLNESS AND ENRICHMEN 215,044 136,229 - - 143,133 6,904 67% - - SENIOR ADULT PROGRAMS 176,287 128,617 - - 128,705 88 73% - - COMMUNITY EVENTS AND VOLUNTE 281,660 223,683 231,329 198,951 185,450 (38,233) 66% (14)% (7)% PLANNING AND BUSINESS OPS 460,559 272,599 - - 273,277 678 59% - - RENTAL OPERATIONS 311,966 237,311 483,202 533,428 239,313 2,001 77% 10% (55)% Total Expenses 3,384,688 2,424,365 2,158,825 2,243,254 2,345,991 (78,374) 69% 4% 5% Percent of year completed 75.00% 35 RECREATION ADMINISTRATION YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 182,919 174,623 152,022 183,876 957 74% (13)% 21% 12 Extra Labor 5,000 3,119 - 622 2,015 (1,105) 40% - 224% 13 Overtime 464 - - - - - - - - 21 FICA 16,870 13,822 12,957 11,131 13,546 (276) 80% (14)% 22% 23 Pension-PERS/PSERS 29,797 21,924 17,230 16,890 21,267 (657) 71% (2)% 26% 24 Industrial Insurance 1,189 814 391 407 534 (280) 45% 4% 31% 25 Medical & Dental 32,833 32,833 26,667 22,250 33,277 444 101% (17)% 50% Total Salaries & Benefits 334,347 255,432 231,868 203,323 254,514 (917) 76% (12)% 25% 31 Supplies 5,917 5,917 10,349 5,374 6,034 117 102% (48)% 12% 41 Professional Services 2,500 2,500 3,160 508 8,733 6,233 349% (84)% 1621% 42 Communication- 34 - 1,486 305 462 462 - (80)% 52% 43 Travel 2,500 2,441 614 353 723 (1,718) 29% (42)% 105% 45 Rentals and Leases- 41 - 1,912 1,700 363 363 - (11)% (79)% 48 Repairs and Maintenance 2,000 - - - - - - - - 49 Miscellaneous 4,250 4,096 3,207 2,128 1,933 (2,164) 45% (34)% (9)% 64 Machinery & Equipment 130,000 64,667 - 5,316 20,983 (43,683) 16% - 295% Total Operating Expenses 147,167 79,621 20,728 15,683 39,231 (40,389) 27% (24)% 150% - (75)% - 49 Miscellaneous 32,200 22,501 54,183 39,598 20,832 Total Expenses 481,514 335,052 252,596 219,005 293,746 (41,307) 61% (13)% 34% Percent of year completed RECREATION RECREATION 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 145,1931 416,446 497,364 142,560 (2,633) 74% 19% (71)% 12 Extra Labor 70,220 59,831 346,939 329,326 45,418 (14,414) 65% (5)% (86)% 13 Overtime - - 2,632 2,508 845 845 - (5)% (66)% 21 FICA 20,093 15,837 58,040 63,108 14,376 (1,461) 72% 9% (77)% 23 Pension-PERS/PSERS 23,243 17,484 49,887 66,972 19,244 1,760 83% 34% (71)% 24 Industrial Insurance 12,256 9,500 45,850 46,446 6,073 (3,426) 50% 1% (87)% 25 Medical & Dental 39,424 29,525 95,684 119,154 29,569 44 75% 25% (75)% 26 Unemployment -- 138 (2,182) 2,033 2,033 - (1683)% (193)% Total Salaries & Benefits 358,844 277,371 1,015,615 1,122,696 260,118 (17,252) 72% 11% (77)% 31 Supplies 27,919 21,001 44,752 49,170 15,015 (5,986) 54% 10% (69)% 34 Items Purchased for resale - - 6,219 (934) - - - (115)% - 35 Small Tools 11,000 1,631 - - 1,631 - 15% - - 41 Professional Services 22,930 22,930 65,502 73,255 24,318 1,388 106% 12% (67)% 42 Communication 2,850 1,719 1,803 1,981 1,591 (128) 56% 10% (20)% 43 Travel 1,800 1,800 2,260 5,100 5,162 3,362 287% 126% 1% 44 Advertising 4,800 3,425 925 891 569 (2,857) 12% (4)% (36)% 45 Rentals and Leases -- 438 112 - - - (75)% - 49 Miscellaneous 32,200 22,501 54,183 39,598 20,832 (1,669) 65% (27)% (47)% Total Operating Expenses 103,499 75,007 176,083 169,173 69,118 (5,889) 67% (4)% (59)% Total Expenses 462,343 352,378 1,191,698 1,291,869 329,236 (23,141) 71% 8% (75)% Percent of year completed 36 75.00% RECREATION PRESCHOOL PROGRAM YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 37,245 27,204 - - 27,204 - 73% - - 12 Extra Labor 20,900 16,105 - - 16,105- 77% - - 13 Overtime - - - - 137 137 - - - 21 FICA 4,397 3,321 - - 3,321 - 76% - - 23 Pension-PERS/PSERS 4,479 4,479 - - 4,631 152 103% - - 24 Industrial Insurance 2,285 1,328 - - 1,328 - 58% - - 25 Medical & Dental 370 310 - - 310 - 84% - - Total Salaries & Benefits 69,676 52,747 - - 53,035 289 76% - - 31 Supplies 8,600 8,600 - - 10,477 1,877 122% - - 41 Professional Services 1,000 2 - - 2 - 0% - - 49 Miscellaneous 500 500 - - 746 246 149% - - Total Operating Expenses 10,100 9,102 - - 11,225 2,123 111% - - Total Expenses 79,776 61,848 - - 64,260 2,412 81% - - Percent of year completed RECREATION YOUTH PROGRAMS 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 148,265 109,956 - - 109,956 - 74% - - 12 Extra Labor 230,203 175,836 - - 175,836- 76% - - 13 Overtime - - - - 5 5 - - - 21 FICA 30,327 21,752 - - 21,752 - 72% - - 23 Pension-PERS/PSERS 17,799 17,799 - - 19,290 1,491 108% - - 24 Industrial Insurance 29,562 17,746 - - 17,746 - 60% - - 25 Medical & Dental 47,525 35,622 - - 35,622 - 75% - - Total Salaries & Benefits 503,681 378,712 - - 380,209 1,497 75% - - 31 Supplies 20,600 15,270 - - 15,270 - 74% - - 41 Professional Services 24,500 19,128 - - 19,128 - 78% - - 49 Miscellaneous 16,000 8,256 - - 8,256 - 52% - - Total Operating Expenses 61,100 42,654 - - 42,654 - 70% - - Total Expenses 564,781 421,366 - - 422,863 1,497 75% - - Percent of year completed 75.00% 37 RECREATION TEEN PROGRAMS YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 48,956 - - 48,956 - 74% - - 12 Extra Labor 63,850 51,654 - - 51,654 - 81% - - 21 FICA 9,969 7,697 - - 7,697 - 77% - - 23 Pension-PERS/PSERS 7,980 6,741 - - 6,741 - 84% - - 24 Industrial Insurance 8,906 5,894 - - 5,894 - 66% - - 25 Medical & Dental 23,729 17,788 - - 17,788 - 75% - - Total Salaries & Benefits 180,900 138,730 - - 138,730 - 77% - - 31 Supplies 7,650 4,869 - - 4,869 - 64% - - 41 Professional Services 5,050 5,050 - - 6,030 980 119% - - 43 Travel- 700 - - - 5,180 5,180 - - - 45 Rentals and Leases 180 180 - - 1,424 1,244 791% - - 49 Miscellaneous 8,000 6,166 - - 6,166 - 77% - - Total Operating Expenses 20,880 16,265 - - 23,669 7,404 113% - - Total Expenses 201,780 154,995 - - 162,399 7,404 80% - - Percent of year completed RECREATION YOUTH WELLNESS AND ENRICHMENT 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 48,993 - - 48,993 - 74% - - 12 Extra Labor 12,700 12,700 - - 15,806 3,106 124% - - 21 FICA 6,067 4,957 - - 4,957 - 82% - - 23 Pension-PERS/PSERS 7,995 6,667 - - 6,667 - 83% - - 24 Industrial Insurance 3,962 2,389 - - 2,389 - 60% - - 25 Medical & Dental 16,456 12,334 - - 12,334 - 75% - - Total Salaries & Benefits 113,778 88,039 - - 91,146 3,106 80% - - 31 Supplies 5,600 5,600 - - 5,817 217 104% - - 41 Professional Services 28,900 6,596 - - 6,596 - 23% - - 49 Miscellaneous 700 50 - - 50 - 7% - - Total Operating Expenses 35,200 12,246 - - 12,463 217 35% - - Total Expenses 148,978 100,285 - - 103,608 3,323 70% - - Percent of year completed 38 75.00% RECREATION ADULT WELLNESS AND ENRICHMENT YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 81,942 60,291 1 - - 60,291 - 74% - - 12 Extra Labor 24,000 18,373 - - 18,373 - 77% - - 13 Overtime - - - - 696 696 - - - 21 FICA 7,914 5,933 - - 5,933 - 75% - - 23 Pension-PERS/PSERS 9,837 8,019 - - 8,019 - 82% - - 24 Industrial Insurance 5,054 2,603 - - 2,603 - 51% - - 25 Medical & Dental 23,797 17,834 - - 17,834 - 75% - - Total Salaries & Benefits 152,544 113,053 - - 113,748 696 75% - - 31 Supplies 4,200 4,200 - - 9,694 5,494 231% - - 41 Professional Services 50,900 17,134 - - 17,134 - 34% - - 48 Repairs and Maintenance 7,200 1,642 - - 1,642 - 23% - - 49 Miscellaneous 200 200 - - 915 715 457% - - Total Operating Expenses 62,500 23,176 1 - - 29,385 6,208 47% - - 1 Total Expenses 215,044 136,229 - - 143,133 6,904 67% - - Percent of year completed 75.00% 39 RECREATION SENIOR ADULT PROGRAMS YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL 1 COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 82,253 60,5161 60,516 % SPEND 74% - 12 Extra Labor 27,000 19,100 19,100 82,537 71%- - 21 FICA 8,298 6,039 - - 6,039 - 73% - - 23 Pension-PERS/PSERS 9,875 8,766 - - 8,766 - 89% - - 24 Industrial Insurance 5,344 2,831 - - 2,831 - 53% - - 25 Medical & Dental 20,517 15,374 - - 15,374 - 75% - - Total Salaries & Benefits 153,287 112,625 - - 112,625 - 73% - - 31 Supplies 3,000 3,000 - - 3,088 88 103% - - 41 Professional Services 5,900 560 - - 560 - 9% - - 43 Travel 2,100 1,697 - - 1,697 - 81% - - 49 Miscellaneous 12,000 10,735 - - 10,735 - 89% - - Total Operating Expenses 23,000 15,992 - - 16,079 88 70% - - 23% 25 Medical & Dental 21,382 14,630 22,698 Total Expenses 176,287 128,617 . - - 128,705 88 73% - - Percent of year completed RECREATION COMMUNITY EVENTS AND VOLUNTEERS 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 82,537 . 111,980 86,836 80,551 (1,986) 72% (22)% (7)% 12 Extra Labor 15,150 13,010 - 6,898 5,268 (7,742) 35% - (24)% 13 Overtime 2,322 2,300 1,845 1,122 1,943 (357) 84% (39)% 73% 21 FICA 9,467 6,787 8,546 7,188 6,335 (452) 67% (16)% (12)% 23 Pension-PERS/PSERS 13,377 9,785 11,056 9,438 9,965 180 74% (15)% 6% 24 Industrial Insurance 3,780 2,467 2,072 2,235 2,755 288 73% 8% 23% 25 Medical & Dental 21,382 14,630 22,698 16,555 17,131 2,501 80% (27)% 3% Total Salaries & Benefits 176,910 131,516 158,197 130,271 123,948 (7,568) 70% (18)% (5)% 31 Supplies 25,400 18,055 16,066 15,909 12,539 (5,516) 49% (1)% (21)% 41 Professional Services 58,400 58,400 42,334 43,800 38,324 (20,076) 66% 3% (13)% 42 Communication 500 - 495 - - - - - 43 Travel 600 600 250 278 389 (211) 65% 11% 40% 44 Advertising 10,500 6,863 9,291 2,847 3,233 (3,629) 31% (69)% 14% 45 Rentals and Leases 6,800 6,800 3,584 5,224 5,706 (1,094) 84% 46% 9% 49 Miscellaneous 2,550 1,449 1,112 621 1,311 (138) 51% (44)% 111% Total Operating Expenses 104,750 92,167 73,132 68,680 61,503 (30,665) 59% (6)% (10)% Total Expenses 281,660 223,683 231,329 198,951 185,450 (38,233) 66% (14)% (7)% Percent of year completed 40 75.00% RECREATION PLANNING AND BUSINESS OPERATIONS YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 166,7501 - - 166,750 - 70% - - 13 Overtime 464 464 - - 1,142 678 246% - - 21 FICA 18,119 12,728 - - 12,728 - 70% - - 23 Pension-PERS/PSERS 28,529 16,268 - - 16,268 - 57% - - 24 Industrial Insurance 3,440 1,543 - - 1,543 - 45% - - 25 Medical & Dental 63,043 37,522 - - 37,522 - 60% - - 28 Uniform/Clothing 230 225 - - 225 - 98% - - Total Salaries & Benefits 351,449 235,500 - - 236,178 678 67% - - 31 Supplies 6,800 3,695 - - 3,695 - 54% - - 41 Professional Services 3,000 151 - - 151 - 5% - - 42 Communication 8,800 3,575 - - 3,575 - 41% - - 43 Travel 1,400 1,026 - - 1,026- 51% 73% - - 44 Advertising 500 - - - - - - - - 45 Rentals and Leases 39,610 26,609 - - 26,609 - 67% - - 48 Repairs and Maintenance 19,700 438 - - 438 - 2% - - 49 Miscellaneous 29,300 1,606 - - 1,606 - 5% - - Total Operating Expenses 109,110 37,100 I - - 37,100 - 34% - - 74% 10% (55)% 31 Supplies 10,300 Total Expenses 460,559 272,599 - - 273,277 678 59% - - Percent of year completed RECREATION RENTAL OPERATIONS 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 I 127,029 94,651 I 264,512 251,264 95,560 908 75% (5)% (62)% 12 Extra Labor 61,620 48,362 - 40,030 41,512 (6,850) 67% - 4% 13 Overtime 929 929 4,541 3,903 1,082 153 116% (14)% (72)% 21 FICA 14,317 10,771 20,300 22,372 10,426 (345) 73% 10% (53)% 23 Pension-PERS/PSERS 15,254 11,472 26,601 32,016 14,123 2,650 93% 20% (56)% 24 Industrial Insurance 9,044 6,491 3,865 7,256 4,656 (1,835) 51% 88% (36)% 25 Medical & Dental 31,848 23,951 61,391 63,696 23,906 (45) 75% 4% (62)% 28 Uniform/Clothing -- 197 - - - - - - Total Salaries & Benefits 260,041 196,626 381,406 420,537 191,264 (5,363) 74% 10% (55)% 31 Supplies 10,300 10,300 12,261 21,605 10,520 220 102% 76% (51)% 34 Items Purchased for resale 22,000 16,310 15,696 17,373 15,307 (1,003) 70% 11% (12)% 41 Professional Services 5,400 4,503- 2,885 - (4,503) - - - 42 Communication - - 2,122 4,560 581 581 - 115% (87)% 43 Travel 325 207 746 186 264 57 81% (75)% 42% 44 Advertising 6,700 2,870 3,053 2,652 2,453 (417) 37% (13)% (8)% 45 Rentals and Leases 2,000 2,000 33,556 34,395 2,808 808 140% 3% (92)% 48 Repairs and Maintenance 1,500 795 14,252 10,511 - (795) - (26)% - 49 Miscellaneous 3,700 3,700 20,110 18,723 16,117 12,417 436% (7)% (14)% Total Operating Expenses 51,925 40,685 101,796 112,891 48,049 7,364 93% 11% (57)% Total Expenses 311,966 237,311 1 483,202 533,428 239,313 2,001 77% 10% (55)% Percent of year completed 75.00% 41 COMMUNITY DEVELOPMENT CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 2,183,057 1,628,151 1,311,722 1,447,511 1,541,024 (87,127) 71% 10% 6% 12 Extra Labor 51,074 41,705 76,173 48,654 39,885 (1,820) 78% (36)% (18)% 13 Overtime 11,094 7,295 5,008 2,675 3,594 (3,701) 32% (47)% 34% 21 FICA 171,664 129,586 105,658 113,439 120,277 (9,308) 70% 7% 6% 23 Pension-PERS/PSERS 263,447 196,029 133,041 163,747 181,006 (15,022) 69% 23% 11% 24 Industrial Insurance 23,960 16,595 9,250 10,666 11,775 (4,821) 49% 15% 10% 25 Medical & Dental 447,425 333,936 216,488 258,132 282,661 (51,274) 63% 19% 10% 28 Uniform/Clothing 2,975 172 99 142 203 31 7% 44% 43% Total Salaries & Benefits 3,154,696 2,353,468 - 1,857,438 2,044,966 2,180,425 (173,043) 69% 10% 7% 31 Supplies 37,180 31,428 31,430 23,317 44,390 12,962 119% (26)% 90% 35 Small Tools 500 181 429 - 181 - 36% - - 41 Professional Services 253,400 161,067 305,644 173,830 120,171 (40,896) 47% (43)% (31)% 42 Communication 6,500 2,794 2,687 3,441 7,328 4,533 113% 28% 113% 43 Travel 13,800 7,966 2,656 3,665 3,099 (4,867) 22% 38% (15)% 44 Advertising -- 411 - 303 303 - - - 45 Rentals and Leases 12,800 11,202 19,130 19,825 10,448 (754) 82% 4% (47)% 47 Public Utilities 2,500 1,993 694 1,359 2,344 351 94% 96% 72% 48 Repairs and Maintenance 51,185 8,869 8,827 9,401 9,322 453 18% 7% (1)% 49 Miscellaneous 152,777 103,716 47,149 68,145 24,666 (79,051) 16% 45% (64)% 51 Inter -Governmental 8,000 4,033 7,444 7,767 7,642 3,609 96% 4% (2)% 53 Ext Taxes, Oper Assess -- 1 1 192 192 - 100% 15900% Total Operating Expenses 538,642 333,249 426,499 310,751 230,083 (103,166) 43% (27)% (26)% Total Expenses 3,693,338 2,686,717 2,283,937 2,355,718 2,410,508 (276,209) 65% 3% 2% Percent of year completed COMMUNITY DEVELOPMENT DIVISION SUMMARY 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 363,988 266,874 269,964 253,173 259,998 (6,876) 71% (6)% 3% CODE ENFORCEMENT 519,030 384,604 270,618 296,047 285,786 (98,819) 55% 9% (3)% PERMIT CENTER 399,556 278,029 273,061 301,634 254,610 (23,419) 64% 10% (16)% BUILDING, PERMIT AND PLAN REVIEW 849,025 632,173 336,621 563,817 557,600 (74,573) 66% 67% (1)% PLANNING 1,269,970 965,043 1,056,414 787,108 824,119 (140,924) 65% (25)% 5% RECYCLING PROGRAM 46,000 32,218 42,013 30,575 33,773 1,555 73% (27)% 10% TDM PROGRAM 245,769 127,776 35,246 123,365 194,622 66,847 79% 250% 58% Total Expenses 3,693,338 2,686,717 2,283,937 2,355,718 2,410,508 (276,209) 65% 3% 2% Percent of year completed 42 75.00% COMMUNITY DEVELOPMENT ADMINISTRATION YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 173,070 167,857 170,388 173,827 757 75% 2% 2% 13 Overtime 1,114 661 725 - 661 - 59% - - 21 FICA 15,422 12,904 12,591 12,715 13,039 135 85% 1% 3% 23 Pension-PERS/PSERS 27,668 20,745 16,530 18,933 20,285 (460) 73% 15% 7% 24 Industrial Insurance 706 511 399 422 370 (141) 52% 6% (12)% 25 Medical & Dental 48,628 37,602 36,093 33,747 31,210 (6,392) 64% (6)% (8)% Total Salaries & Benefits 324,008 245,493 234,195 236,205 239,392 (6,101) 74% 1% 1% 31 Supplies 9,680 9,680 17,639 7,770 11,240 1,560 116% (56)% 45% 41 Professional Services 13,000 - 11,258 - - - - - - 43 Travel 500 500 534 1,604 672 172 134% 200% (58)% 45 Rentals and Leases 4,800 3,202 4,033 5,063 4,448 1,246 93% 26% (12)% 48 Repairs and Maintenance 500 500 695 1,015 849 349 170% 46% (16)% 49 Miscellaneous 11,500 7,499 1,610 1,515 3,205 (4,294) 28% (6)% 112% 53 Ext Taxes, Assessments -- 3,749 1 1 192 192 - 100% 15900% Total Operating Expenses 39,980 21,381 35,769 16,968 20,606 (775) 52% (53)% 21% 49 Miscellaneous 53,427 38,992 1,098 802 775 (38,217) 1% (27)% (3)% Total Expenses 363,988 266,874 269,964 253,173 259,998 (6,876) 71% (6)% 3% Percent of year completed COMMUNITY DEVELOPMENT CODE ENFORCEMENT 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 226,950 176,106 181,936 187,531 (39,418) 62% 3% 3% 12 Extra Labor 5,574 3,756 - 11,820 980 (2,776) 18% - (92)% 13 Overtime 2,786 131 2,169 - 131 - 5% - - 21 FICA 23,746 17,718 13,638 14,822 14,653 (3,064) 62% 9% (1)% 23 Pension-PERS/PSERS 36,266 26,779 17,644 20,802 20,429 (6,349) 56% 18% (2)% 24 Industrial Insurance 8,732 6,193 4,201 4,507 3,838 (2,355) 44% 7% (15)% 25 Medical & Dental 75,628 54,777 27,015 40,676 48,319 (6,458) 64% 51% 19% 28 Uniform/Clothing 475 172 - 142 203 31 43% - 43% Total Salaries & Benefits 455,254 336,475 240,773 274,706 276,085 (60,391) 61% 14% 1% 31 Supplies 500 500 (2,678) 1,478 735 235 147% (155)% (50)% 41 Professional Services - - 21,210 8,905 - - - (58)% - 42 Communication 3,000 2,294 2,161 2,342 2,401 106 80% 8% 3% 43 Travel 600 600 984 39 635 35 106% (96)% 1528% 45 Rentals and Leases 3,749 3,749 6,377 6,417 2,812 (937) 75% 1% (56)% 47 Public Utilities 2,500 1,993 694 1,359 2,344 351 94% 96% 72% 49 Miscellaneous 53,427 38,992 1,098 802 775 (38,217) 1% (27)% (3)% Total Operating Expenses 63,776 48,129 29,845 21,341 9,701 (38,428) 15% (28)% (55)% Total Expenses 519,030 384,604 270,618 296,047 285,786 (98,819) 55% 9% (3)% Percent of year completed 75.00% 43 COMMUNITY DEVELOPMENT PERMIT CENTER YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 159,764 180,161 192,299 151,837 (7,927) 74% 7% (21)% 13 Overtime 1,847 1,847 - 110 1,946 (1,847) - - - 21 FICA 15,857 12,342 13,782 14,719 11,616 (726) 73% 7% (21)% 23 Pension-PERS/PSERS 24,651 19,139 17,219 21,189 17,752 (1,387) 72% 23% (16)% 24 Industrial Insurance 1,059 812 696 772 545 (267) 51% 11% (29)% 25 Medical & Dental 60,663 46,768 41,445 50,628 45,436 (1,332) 75% 22% (10)% Total Salaries & Benefits 309,356 240,671 253,304 279,717 227,185 (13,486) 73% 10% (19)% 31 Supplies 3,000 2,295 767 1,703 2,181 (114) 73% 122% 28% 41 Professional Services 10,000 10,000 562 301 11,764 1,764 118% (46)% 3810% 42 Communication -- 181 429 493 55 55 - - (89)% 43 Travel 3,700 24 472 - 24 - 1% - - 48 Repairs and Maintenance 42,000 234 - 283 4,237 4,003 10% - 1397% 49 Miscellaneous 31,500 24,805 17,957 19,136 9,165 (15,640) 29% 7% (52)% Total Operating Expenses 90,200 37,358 19,758 21,916 27,425 (9,933) 30% 11% 25% 48 Repairs and Maintenance 550 - - - - - - - - Total Expenses 399,556 278,029 273,061 301,634 254,610 (23,419) 64% 10% (16)% Percent of year completed COMMUNITY DEVELOPMENT BUILDING, PERMIT AND PLAN REVIEW 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 371,369 210,889 281,689 348,675 (22,694) 68% 34% 24% 13 Overtime 3,500 2,809 1,564 1,995 1,946 (863) 56% 28% (2)% 21 FICA 39,527 28,557 15,991 21,433 26,568 (1,989) 67% 34% 24% 23 Pension-PERS/PSERS 63,053 45,766 20,690 31,439 39,716 (6,050) 63% 52% 26% 24 Industrial Insurance 9,261 6,144 1,998 2,922 4,763 (1,380) 51% 46% 63% 25 Medical & Dental 114,579 83,547 37,498 51,111 66,647 (16,899) 58% 36% 30% 28 Uniform/Clothing 2,500 - 99 - - - - - - Total Salaries & Benefits 746,474 538,191 288,728 390,587 488,315 (49,876) 65% 35% 25% 31 Supplies 3,000 2,866 1,151 5,244 1,953 (913) 65% 356% (63)% 35 Small Tools 500 181 429 - 181 - 36% - - 41 Professional Services 83,400 76,123 23,053 132,368 55,012 (21,111) 66% 474% (58)% 42 Communication 500 500 55 606 4,872 4,372 974% 1008% 704% 43 Travel 1,500 1,244 62 677 135 (1,109) 9% 996% (80)% 45 Rentals and Leases 4,251 4,251 8,720 8,344 3,188 (1,063) 75% (4)% (62)% 48 Repairs and Maintenance 550 - - - - - - - - 49 Miscellaneous 8,850 8,818 14,424 25,990 3,944 (4,874) 45% 80% (85)% Total Operating Expenses 102,551 93,982 47,893 173,230 69,285 (24,697) 68% 262% (60)% Total Expenses 849,025 632,173 336,621 563,817 557,600 (74,573) 66% 67% (1)% Percent of year completed 44 75.00% COMMUNITY DEVELOPMENT PLANNING YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 617,358 568,321 560,157 591,393 (25,965) 73% (1)% 6% 12 Extra Labor 45,500 37,949 54,220 10,837 8,803 (29,146) 19% (80)% (19)% 13 Overtime 1,847 1,847 550 570 856 (991) 46% 4% 50% 21 FICA 68,197 51,837 47,384 43,186 45,485 (6,352) 67% (9)% 5% 23 Pension-PERS/PSERS 97,819 73,846 57,971 61,653 69,172 (4,674) 71% 6% 12% 24 Industrial Insurance 3,000 2,144 1,834 1,606 1,706 (439) 57% (12)% 6% 25 Medical & Dental 129,811 98,900 73,555 75,591 82,806 (16,093) 64% 3% 10% Total Salaries & Benefits 1,160,835 883,881 803,835 753,600 800,222 (83,660) 69% (6)% 6% 31 Supplies 8,000 3,360 2,972 2,071 3,795 435 47% (30)% 83% 41 Professional Services 64,000 52,772 232,785 16,392 8,867 (43,905) 14% (93)% (46)% 42 Communication 3,000 - - - - - - - - 43 Travel 2,000 123 188 46 1,505 1,382 75% (75)% 3168% 48 Repairs and Maintenance 8,135 8,135 8,132 8,104 4,237 (3,898) 52% (0)% (48)% 49 Miscellaneous 24,000 16,771 8,503 6,895 5,494 (11,278) 23% (19)% (20)% Total Operating Expenses 109,135 81,162 252,580 33,508 23,898 (57,264) 22% (87)% (29)% Total Expenses 1,269,970 965,043 1,056,414 787,108 824,119 (140,924) 65% (25)% 5% Percent of year completed COMMUNITY DEVELOPMENT RECYCLING PROGRAM 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 - - 8,387 7,152 3,912 3,912 - (15)% (45)% 21 FICA - - 592 481 289 289 - (19)% (40)% 23 Pension-PERS/PSERS - - 813 800 455 455- (2)% (43)% 24 Industrial Insurance - - 27 23 12 12 - (14)% (49)% 25 Medical & Dental - - 883 895 33 33 - 1% (96)% Total Salaries & Benefits - - 10,701 9,350 4,700 4,700 - (13)% (50)% 31 Supplies 9,000 8,726 11,579 3,887 6,100 (2,627) 68% (66)% 57% 41 Professional Services 30,000 21,221 16,777 15,515 21,064 (157) 70% (8)% 36% 42 Communication - - 471 - - - - - - 44 Advertising - - 411 - 303 303 - - - 49 Miscellaneous 7,000 2,271 2,072 1,823 1,607 (663) 23% (12)% (12)% Total Operating Expenses 46,000 32,218 31,311 21,225 29,074 (3,145) 63% (32)% 37% Total Expenses 46,000 32,218 42,013 30,575 33,773 1,555 73% (27)% 10% Percent of year completed 75.00% 45 COMMUNITY DEVELOPMENT TDM PROGRAM YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 79,642 - 53,890 83,850 4,208 72% - 56% 12 Extra Labor - - 21,953 25,997 30,102 30,102 - 18% 16% 21 FICA 8,915 6,227 1,679 6,083 8,627 2,400 97% 262% 42% 23 Pension-PERS/PSERS 13,990 9,754 2,174 8,931 13,198 3,444 94% 311% 48% 24 Industrial Insurance 1,202 791 95 415 541 (251) 45% 336% 30% 25 Medical & Dental 18,116 12,342 - 5,484 8,210 (4,133) 45% - 50% Total Salaries & Benefits 158,769 108,757 25,902 100,801 144,527 35,771 91% 289% 43% 31 Supplies 4,000 4,000 - 1,165 18,386 14,386 460% - 1479% 41 Professional Services 53,000 951 - 350 23,464 22,513 44% - 6600% 43 Travel 5,500 5,476 416 1,299 128 (5,348) 2% 212% (90)% 49 Miscellaneous 16,500 4,560 1,484 11,983 476 (4,084) 3% 707% (96)% 51 Inter -Governmental 8,000 4,033 7,444 7,767 7,642 3,609 96% 4% (2)% Total Operating Expenses 87,000 19,019 9,344 22,564 50,095 31,076 58% 141% 122% Total Expenses 245,769 127,776 35,246 123,365 194,622 66,847 79% 250% 58% Percent of year completed 46 75.00% MUNICIPAL COURT CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 567,678 r 522,116 525,738 560,952 (6,725) 74% 1% 7% 12 Extra Labor I 4,180 2,736 4,056 13,450 558 (2,178) 13% 232% (96)% 13 Overtime 4,661 3,489 600 1,885 - (3,489) - 214% - 21 FICA 57,112 43,292 39,334 40,821 42,342 (950) 74% 4% 4% 23 Pension-PERS/PSERS 90,616 67,730 52,732 60,602 65,713 (2,017) 73% 15% 8% 24 Industrial Insurance 3,477 2,414 1,848 1,915 1,971 (444) 57% 4% 3% 25 Medical & Dental 185,542 141,260 106,048 115,929 121,448 (19,813) 65% 9% 5% 26 Unemployment - -- 1,930 - - - - - Total Salaries & Benefits 1,101,900 828,599 726,734 762,271 792,984 (35,616) 72% 5% 4% 31 Supplies 14,283 10,308 8,768 8,983 11,599 1,290 81% 2% 29% 35 Small Tools - - 2,932 - 953 953 - - - 41 Professional Services 105,000 68,467 61,786 63,856 66,577 (1,890) 63% 3% 4% 42 Communication 24,150 13,746 5,839 2,952 5,635 (8,111) 23% (49)% 91% 43 Travel 10,000 9,333 5,519 3,191 8,722 (612) 87% (42)% 173% 45 Rentals and Leases 2,000 2,000 1,564 1,399 5,058 3,058 253% (11)% 262% 48 Repairs and Maintenance 2,300 2,300 294 521 348 (1,952) 15% 77% (33)% 49 Miscellaneous 23,170 15,032 18,835 11,498 13,506 (1,526) 58% (39)% 17% 53 Ext Taxes, Assessments 5 - 2 - - - - - - 64 Miscellaneous 25,000 - _ 20,275 - - - - - - Total Operating Expenses 205,908 121,187 125,813 92,399 112,397 (8,790) 55% (27)% 22% - , Total Expenses 1,307,808 949,786 852,547 854,670 905,381 (44,406) 69% 0% 6% Percent of year completed 75.00% 47 POLICE CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) ALLOCATED BDGT % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 9,003,291 6,753,877 6,230,200 6,312,923 6,404,166 (349,711) 71% 1% 1% 12 Extra Labor -- 1,721,521 - - 858 858 - - - 13 Overtime 928,495 699,915 742,455 666,206 683,032 (16,883) 74% (10)% 3% 15 Holiday/Kelly Payoff 201,063 78,772 - 81,469 79,930 1,157 40% - (2)% 21 FICA 756,032 578,403 529,311 536,415 545,305 (33,098) 72% 1% 2% 22 Pension-LEOFF 2 472,077 348,251 317,074 319,992 324,918 (23,333) 69% 1% 2% 23 Pension-PERS/PSERS 146,051 110,749 82,025 96,781 105,637 (5,112) 72% 18% 9% 24 Industrial Insurance 273,809 195,023 134,124 151,089 135,996 (59,027) 50% 13% (10)% 25 Medical & Dental 1,933,791 1,461,948 1,314,615 1,388,564 1,343,595 (118,352) 69% 6% (3)% 26 Unemployment -- 1,013,691 143 9,599 953 953 - 6609% (90)% Total Salaries & Benefits 13,714,609 10,226,939 9,349,948 9,563,038 9,624,389 (602,549) 70% 2% 1% 31 Supplies 180,850 169,913 141,516 175,532 217,872 47,959 120% 24% 24% 35 Small Tools 15,600 8,958 7,592 599 8,603 (355) 55% (92)% 1337% 41 Professional Services 70,000 48,825 44,465 48,816 35,928 (12,897) 51% 10% (26)% 42 Communication 121,000 88,734 65,640 71,745 86,238 (2,496) 71% 9% 20% 43 Travel 41,880 38,843 29,265 36,999 35,961 (2,882) 86% 26% (3)% 44 Advertising 1,500 400 -- 453 53 30% - - 45 Rentals and Leases 896,843 855,979 948,992 965,221 657,025 (198,955) 73% 2% (32)% 46 Insurance 230,223 230,223 240,000 240,000 230,223 - 100% 0% (4)% 47 Public Utilities - - 1,659 2,007 2,774 2,774 - 21% 38% 48 Repairs and Maintenance 188,922 142,959 123,248 112,065 42,950 (100,009) 23% (9)% (62)% 49 Miscellaneous 79,641 56,526 67,244 47,327 56,823 297 71% (30)% 20% 51 Inter -Governmental 2,747,024 2,115,263 1,716,516 1,886,725 2,081,274 (33,989) 76% 10% 10% 64 Machinery & Equipment -- - 373,837 11,628 11,628 - - (97)% Total Operating Expenses 4,573,483 3,756,623 3,386,138 3,960,871 3,467,751 (288,872) 76% 17% (12)% Total Expenses 18,288,092 13,983,562 12,736,086 13,523,909 13,092,140 (891,422) 72% 6% (3)% Percent of year completed POLICE DIVISION SUMMARY 75.00° YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 1,407,216 1,306,114 1,658,507 1,524,368 117,152 85% 27% (8)% INVESTIGATION 2,147,558 1,621,798 1,614,320 1,721,521 1,624,431 2,633 76% 7% (6)% PATROL 6,506,261 4,846,764 4,787,764 4,752,258 4,614,245 (232,519) 71% (1)% (3)% RECORDS/EVIDENCE 1,217,212 909,558 728,112 836,065 833,591 (75,967) 68% 15% (0)% ANTI-CRIME 846,734 699,360 667,837 538,350 615,131 (84,229) 73% (19)% 14% PROFESSIONAL STANDARDS 2,021,287 1,509,634 1,254,216 1,351,371 1,114,279 (395,355) 55% 8% (18)% TRAINING 287,102 228,095 227,743 216,984 217,258 (10,837) 76% (5)% 0% TRAFFIC 591,180 546,738 422,977 529,771 390,319 (156,419) 66% 25% (26)% FACILITIES 120,000 81,229 -- 82,987 1,758 69% - - PRISONERCARE&CUSTODY 1,509,914 1,135,525 944,889 1,013,691 1,109,112 (26,413) 73% 7% 9% ANIMAL SERVICES 118,852 58,180 33,860 52,935 52,310 (5,870) 44% 56% (1)% COMMUNICATION, DISPATCH 1,127,358 939,465 748,253 845,838 914,109 (25,356) 81% 13% 8% SPECIAL SERVICES UNIT -- - 6,619 - - - - - Total Expenses I 18,288,092 13,983,562 12,736,086 13,523,909 13,092,140 (891,422) 72% 6% (3)% Percent of year completed 48 75.00% POLICE ADMINISTRATION YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) ALLOCATED BDGT % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 929,989 695,279 683,404 676,365 839,064 143,784 90% (1)% 24% 12 Extra Labor -- 153,522 - - 858 858 - - - 13 Overtime 2,923 903 2,102 - 903 - 31% - - 21 FICA 62,064 62,064 51,190 49,441 62,098 34 100% (3)% 26% 22 Pension-LEOFF 46,693 34,246 32,558 30,233 34,691 445 74% (7)% 15% 23 Pension-PERS/PSERS 8,855 8,855 5,463 6,053 13,003 4,148 147% 11% 115% 24 Industrial Insurance 18,294 13,323 8,531 9,502 9,208 (4,116) 50% 11% (3)% 25 Medical & Dental 155,097 114,035 98,076 94,488 124,130 10,095 80% (4)% 31% Total Salaries & Benefits 1,223,915 928,706 881,325 866,082 1,083,955 155,249 89% (2)% 25% 31 Supplies 24,000 17,496 20,860 15,617 18,940 1,444 79% (25)% 21% 35 Small Tools -- 474 - 241 - - - - - 41 Professional Services 15,000 7,760 7,007 5,639 14,179 6,419 95% (20)% 151% 42 Communication 121,000 88,734 20,055 28,258 66,327 (22,406) 55% 41% 135% 43 Travel 10,000 8,227 4,439 4,502 2,890 (5,337) 29% 1% (36)% 44 Advertising 1,100 - - - - - - - - 45 Rentals and Leases 61,478 61,478 61,878 65,832 42,471 (19,007) 69% 6% (35)% 46 Insurance 230,223 230,223 240,000 240,000 230,223 - 100% 0% (4)% 48 Repairs and Maintenance 86,518 58,076 57,135 57,904 35,476 (22,600) 41% 1% (39)% 49 Miscellaneous 5,500 2,585 3,331 2,315 3,647 1,062 66% (31)% 58% 51 Inter -Governmental 15,900 3,932 10,084 4,900 14,632 10,700 92% (51)% 199% 64 Machinery & Equipment - - - 367,217 11,628 11,628 - - (97)% Total Operating Expenses 570,719 478,510 424,789 792,425 440,413 (38,097) 77% 87% (44)% Total Expenses 1,794,634 1,407,216 1,306,114 1,658,507 1,524,368 117,152 85% 27% (8)% Percent of year completed POLICE INVESTIGATION 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 974,437 965,281 1,036,543 1,023,115 48,678 78% 7% (1)% 13 Overtime 173,542 124,661 108,767 153,522 120,135 (4,526) 69% 41% (22)% 21 FICA 113,950 85,100 81,213 90,504 87,823 2,723 77% 11% (3)% 22 Pension-LEOFF 72,920 53,662 50,964 56,941 54,043 381 74% 12% (5)% 23 Pension-PERS/PSERS 15,918 11,918 9,494 10,921 11,430 (489) 72% 15% 5% 24 Industrial Insurance 41,629 29,484 20,510 25,680 21,363 (8,120) 51% 25% (17)% 25 Medical & Dental 264,160 199,918 176,497 189,011 184,978 (14,941) 70% 7% (2)% Total Salaries & Benefits 2,001,756 1,479,181 1,412,726 1,563,120 1,502,887 23,706 75% 11% (4)% 31 Supplies 12,000 12,000 11,358 5,984 19,149 7,149 160% (47)% 220% 41 Professional Services 4,000 4,000 3,582 2,811 8,951 4,951 224% (22)% 218% 42 Communication -- 984 474 3,078 3,078 - (52)% 550% 43 Travel 5,000 3,735 5,990 4,745 3,135 (600) 63% (21)% (34)% 45 Rentals and Leases 112,302 112,302 174,756 131,763 85,362 (26,940) 76% (25)% (35)% 47 Public Utilities -- 849 885 927 927 - 4% 5% 48 Repairs and Maintenance 9,000 7,080 3,394 10,839 330 (6,750) 4% 219% (97)% 49 Miscellaneous 3,500 3,500 679 901 613 (2,887) 18% 33% (32)% Total Operating Expenses 145,802 142,617 201,594 158,401 121,544 (21,073) 83% (21)% (23)% - Total Expenses 2,147,558 1,621,798 1,614,320 1,721,521 1,624,431 2,633 76% 7% (6)% Percent of year completed 75.00% 49 POLICE PATROL YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 2,645,681 2,665,263 2,540,306 2,592,495 (53,186) 72% (5)% 2% 13 Overtime 553,184 392,965 355,136 290,393 367,031 (25,933) 66% (18)% 26% 15 Holiday Pay 201,063 78,772 - 81,469 79,930 1,157 40% - (2)% 21 FICA 325,928 234,386 230,209 223,029 232,352 (2,035) 71% (3)% 4% 22 Pension-LEOFF 224,945 160,492 154,318 149,359 158,340 (2,152) 70% (3)% 6% 23 Pension-PERS/PSERS 6,110 4,561 2,488 4,031 4,408 (153) 72% 62% 9% 24 Industrial Insurance 131,570 91,152 69,590 74,235 69,470 (21,682) 53% 7% (6)% 25 Medical & Dental 843,096 630,424 667,278 687,969 630,643 219 75% 3% (8)% 26 Unemployment -- 31 Supplies - - (332) (332) - - - Total Salaries & Benefits 5,885,870 4,238,433 4,144,282 4,050,793 4,134,338 (104,096) 70% (2)% 2% 31 Supplies 59,450 59,450 36,885 61,891 103,982 44,532 175% 68% 68% 35 Small Tools 600 600 7,592 358 245 (355) 41% (95)% (32)% 41 Professional Services 8,000 5,958 1,557 3,702 3,058 (2,901) 38% 138% (17)% 42 Communication -- 45 Rentals and Leases 35,113 35,237 5,292 5,292 - 0% (85)% 43 Travel 500 500 280 349 170 (330) 34% 25% (51)% 45 Rentals and Leases 482,337 482,337 501,835 562,102 365,153 (117,184) 76% 12% (35)% 48 Repairs and Maintenance 65,404 57,174 51,452 34,302 687 (56,487) 1% (33)% (98)% 49 Miscellaneous 4,100 2,311 8,769 3,525 1,322 (990) 32% (60)% (63)% Total Operating Expenses 620,391 608,330 643,483 701,465 479,907 (128,423) 77% 9% (32)% 15% (0)% Total Expenses 6,506,261 4,846,764 4,787,764 4,752,258 4,614,245 (232,519) 71% (1)% (3)% Percent of year completed POLICE RECORDS/EVIDENCE 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 590,377 456,785 534,053 542,647 (47,730) 69% 17% 2% 13 Overtime 32,248 18,532 51,809 25,978 28,005 9,474 87% (50)% 8% 21 FICA 60,929 45,126 38,416 42,281 43,177 (1,949) 71% 10% 2% 23 Pension-PERS/PSERS 97,109 71,843 47,950 62,131 65,365 (6,478) 67% 30% 5% 24 Industrial Insurance 4,975 3,522 1,987 2,400 2,314 (1,208) 47% 21% (4)% 25 Medical & Dental 167,376 127,691 92,402 110,961 110,392 (17,299) 66% 20% (1)% 26 Unemployment -- 143 9,599 1,285 1,285 - 6609% (87)% Total Salaries & Benefits 1,147,812 857,090 689,492 787,403 793,185 (63,905) 69% 14% 1% 31 Supplies 29,400 25,779 17,073 28,468 10,939 (14,839) 37% 67% (62)% 35 Small Tools 15,000 8,358 -- 8,358 - 56% - - 41 Professional Services 9,000 8,701 5,374 6,026 284 (8,417) 3% 12% (95)% 42 Communication - - 5,964 1,642 4,342 4,342 - (72)% 164% 43 Travel - - - 1,165 1,175 1,175 - - 1% 45 Rentals and Leases - - 3,760 4,328 1,390 1,390 - 15% (68)% 48 Repairs and Maintenance 13,500 7,130 6,108 6,362 5,122 (2,008) 38% 4% (19)% 49 Miscellaneous 2,500 2,500 342 670 8,796 6,296 352% 96% 1213% Total Operating Expenses 69,400 52,468 38,620 48,662 40,406 (12,061) 58% 26% (17)% Total Expenses 1,217,212 909,558 728,112 836,065 833,591 (75,967) 68% 15% (0)% Percent of year completed 50 75.00% POLICE ANTI-CRIME YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 395,445 366,005 286,146 344,178 (51,267) 70% (22)% 20% 13 Overtime 58,459 58,459 69,301 37,572 70,319 11,860 120% (46)% 87% 21 FICA 42,311 33,521 33,232 24,732 31,665 (1,857) 75% (26)% 28% 22 Pension-LEOFF 29,563 23,473 22,701 16,878 21,909 (1,564) 74% (26)% 30% 24 Industrial Insurance 16,666 12,593 8,832 7,476 8,577 (4,015) 51% (15)% 15% 25 Medical & Dental 105,001 84,168 73,781 62,635 72,036 (12,132) 69% (15)% 15% Total Salaries & Benefits 747,212 607,660 573,852 435,438 548,684 (58,976) 73% (24)% 26% 31 Supplies 2,000 1,663 643 1,813 902 (761) 45% 182% (50)% 42 Communication -- 8,300 730 2,450 3,349 3,349 - 236% 37% 43 Travel - - - 68 124 124 - - 83% 45 Rentals and Leases 86,522 86,522 87,918 94,129 58,928 (27,594) 68% 7% (37)% 48 Repairs and Maintenance 1,000 - 64 - - - - - - 49 Miscellaneous 10,000 3,514 4,630 4,451 3,145 (370) 31% (4)% (29)% Total Operating Expenses 99,522 91,700 93,985 102,911 66,447 (25,253) 67% 9% (35)% 48 Repairs and Maintenance 1,000 1,000 1,806 547 42 (958) 4% (70)% (92)% Total Expenses 846,734 699,360 667,837 538,350 615,131 (84,229) 73% (19)% 14% Percent of year completed POLICE PROFESSIONAL STANDARDS 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 1,025,515 753,370 819,995 726,371 (299,145) 52% 9% (11)% 13 Overtime 45,303 45,303 106,089 103,712 69,790 24,487 154% (2)% (33)% 21 FICA 110,001 81,132 65,498 70,466 60,770 (20,362) 55% 8% (14)% 22 Pension-LEOFF 72,707 53,011 38,812 44,526 38,567 (14,444) 53% 15% (13)% 23 Pension-PERS/PSERS 10,201 7,766 11,286 7,723 7,511 (256) 74% (32)% (3)% 24 Industrial lnsurance 44,361 30,858 16,066 20,292 17,220 (13,638) 39% 26% (15)% 25 Medical & Dental 308,300 231,893 147,910 174,906 158,156 (73,737) 51% 18% (10)% Total Salaries & Benefits 1,987,133 1,475,480 1,139,033 1,241,620 1,078,385 (397,095) 54% 9% (13)% 31 Supplies 8,300 8,300 15,757 15,397 16,574 8,274 200% (2)% 8% 42 Communication - - 2,264 3,649 2,625 2,625 - 61% (28)% 43 Travel - - 1,215 1,679 (15) (15) - 38% (101)% 44 Advertising 400 400 - - 453 53 113% - - 45 Rentals and Leases 19,854 19,854 93,283 85,175 14,891 (4,964) 75% (9)% (83)% 47 Public Utilities -- 810 1,122 1,196 1,196 - 39% 7% 48 Repairs and Maintenance 1,000 1,000 1,806 547 42 (958) 4% (70)% (92)% 49 Miscellaneous 4,600 4,600 50 2,182 130 (4,470) 3% 4269% (94)% Total Operating Expenses 34,154 34,154 115,184 109,751 35,894 1,740 105% (5)% (67)% Total Expenses 2,021,287 1,509,634 1,254,216 1,351,371 1,114,279 (395,355) 55% 8% (18)% Percent of year completed 75.00% 51 POLICE TRAINING YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 74,939 72,440 74,045 74,045 (895) 74% 2% 0% 13 Overtime 15,500 11,756 18,282 16,725 7,050 (4,706) 45% (9)% (58)% 21 FICA 8,667 6,530 6,917 6,806 6,075 (455) 70% (2)% (11)% 22 Pension-LEOFF 6,174 4,640 4,732 4,734 4,282 (358) 69% 0% (10)% 24 Industrial Insurance 3,413 2,447 1,717 1,960 1,698 (749) 50% 14% (13)% 25 Medical & Dental 20,038 15,020 10,380 13,950 13,667 (1,353) 68% 34% (2)% Total Salaries & Benefits 153,981 115,333 114,468 118,220 106,817 (8,516) 69% 3% (10)% 31 Supplies 41,100 41,100 34,694 39,557 43,352 2,252 105% 14% 10% 41 Professional Services 9,000 567 6,377- 567 - 6% - - 42 Communication - - 530 - 1,225 1,225 - - - 43 Travel 26,380 26,380 17,342 24,492 28,483 2,103 108% 41% 16% 45 Rentals and Leases 5,200 5,200 4,979 1,150 739 (4,461) 14% (77)% (36)% 48 Repairs and Maintenance 2,500 2,500 276 306 - (2,500) - 11% - 49 Miscellaneous 48,941 37,015 49,077 33,260 36,075 (940) 74% (32)% 8% Total Operating Expenses 133,121 112,762 113,275 98,764 110,442 (2,321) 83% (13)% 12% Total Expenses 287,102 228,095 227,743 216,984 217,258 (10,837) 76% (5)% 0% Percent of year completed POLICE FACILITIES 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 Percent of year completed 52 75.00% BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY BY EXPENDITURE ACTUAL TYPE 2017 OVER/(UNDER) % CHANGE ALLOCATED 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 45 Rentals and Leases 120,000 81,229 -- 81,229 - 68% - - 47 Public Utilities - - - - 651 651 - - - 49 Miscellaneous - - - - 1,106 1,106 - - - Total Operating Expenses 120,000 81,229 -- 82,987 1,758 69% - - Total Expenses 120,000 81,229 - - 82,987 1,758 69% - - Percent of year completed 52 75.00% POLICE TRAFFIC YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 352,202 267,652 345,471 262,252 (89,951) 70% 29% (24)% 13 Overtime 47,336 47,336 30,968 38,304 19,799 (27,537) 42% 24% (48)% 21 FICA 32,182 30,544 22,636 29,157 21,346 (9,198) 66% 29% (27)% 22 Pension-LEOFF 19,075 18,726 12,988 17,320 13,085 (5,641) 69% 33% (24)% 23 Pension-PERS/PSERS 7,858 5,805 5,344 5,921 3,921 (1,884) 50% 11% (34)% 24 Industrial Insurance 12,901 11,645 6,892 9,544 6,146 (5,499) 48% 38% (36)% 25 Medical & Dental 70,723 58,797 48,290 54,644 49,593 (9,205) 70% 13% (9)% Total Salaries & Benefits 566,930 525,055 394,770 500,361 376,140 (148,915) 66% 27% (25)% 31 Supplies 4,600 4,125 4,246 6,805 4,034 (92) 88% 60% (41)% 42 Communication -- - 35 - - - - - 45 Rentals and Leases 9,150 7,058 20,583 20,741 6,863 (195) 75% 1% (67)% 48 Repairs and Maintenance 10,000 10,000 3,011 1,804 1,294 (8,706) 13% (40)% (28)% 49 Miscellaneous 500 500 366 24 1,989 1,489 398% (93)% 8187% Total Operating Expenses 24,250 21,683 28,207 29,410 14,179 (7,504) 58% 4% (52)% Total Expenses 591,180 546,738 422,977 529,771 390,319 (156,419) 66% 25% (26)% Percent of year completed 75.00% 53 POLICE PRISONER CARE & CUSTODY YTD THROUGH PERIOD 9 10/31/2017 10:48 Percent of year completed POLICE ANIMAL SERVICES 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY BY EXPENDITURE 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ACTUAL TYPE % CHANGE 2017 51 King County Animal Control 118,852 58,180 OVER/(UNDER) 52,935 % CHANGE ALLOCATED 44% 56% (1)% Total Operating Expenses 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 56% 2016/2017 41 Monitoring of Prisoners 25,000 21,839 20,569 30,639 8,890 (12,949) 36% 49% (71)% 51 Score Jail 1,484,914 1,113,686 924,320 983,052 1,100,222 (13,463) 74% 6% 12% Total Operating Expenses 1,509,914 1,135,525 944,889 1,013,691 1,109,112 (26,413) 73% 7% 9% Percent of year completed POLICE ANIMAL SERVICES 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 % CHANGE 2016/2017 51 King County Animal Control 118,852 58,180 33,860 52,935 52,310 (5,870) 44% 56% (1)% Total Operating Expenses 118,852 58,180 33,860 52,935 52,310 (5,870) 44% 56% (1)% Percent of year completed POLICE COMMUNICATION, DISPATCH 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 939,465 748,253 845,838 914,109 (25,356) 81% 13% - 8% Total Operating Expenses 1,127,358 939,465 748,253 845,838 914,109 (25,356) 81% 13% 8% Percent of year completed POLICE SPECIAL SERVICES UNIT 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 54 75.00% FIRE CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) ALLOCATED BDGT % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 6,888,744 5,071,741 • 5,090,167 5,195,265 5,373,826 - 302,085 78% 2% 3% 12 Extra Labor - - 5,123 11,083 3,746 3,746 - 116% (66)% 13 Overtime 650,648 523,322 550,866 392,924 468,894 (54,428) 72% (29)% 19% 15 Holiday Pay 324,520 2,076 4,767 1,465 - (2,076) - (69)% - 21 FICA 125,292 94,602 88,291 89,615 99,434 4,831 79% 1% 11% 22 Pension-LEOFF 2 377,176 263,146 271,915 273,247 289,668 26,522 77% 0% 6% 23 Pension-PERS/PSERS 44,621 33,494 27,463 31,118 32,796 (698) 73% 13% 5% 24 Industrial Insurance 368,655 258,623 175,866 200,341 205,433 (53,190) 56% 14% 3% 25 Medical & Dental 1,454,547 1,088,557 1,168,059 1,212,710 1,130,155 41,598 78% 4% (7)% 28 Uniform/Clothing - - 1,712 - - - - - - Total Salaries & Benefits 10,234,203 7,335,560 7,384,230 7,407,770 7,603,950 268,390 74% 0% 3% 31 Supplies 234,477 171,993 251,185 174,364 121,454 (50,540) 52% (31)% (30)% 35 Small Tools 37,268 28,496 227,143 1,973 4,228 (24,268) 11% (99)% 114% 41 Professional Services 81,000 74,225 56,234 42,937 20,550 (53,676) 25% (24)% (52)% 42 Communication 32,170 23,771 37,705 27,685 31,402 7,631 98% (27)% 13% 43 Travel 7,000 5,750 12,341 6,731 11,929 6,179 170% (45)% 77% 45 Rentals and Leases 587,241 567,687 446,478 401,961 442,998 (124,689) 75% (10)% 10% 46 Insurance 173,286 173,286 90,000 90,000 173,286 - 100% 0% 93% 47 Public Utilities 73,360 52,262 52,780 54,089 63,414 11,152 86% 2% 17% 48 Repairs and Maintenance 41,921 33,614 34,716 44,893 39,723 6,109 95% 29% (12)% 49 Miscellaneous 148,874 110,801 57,069 58,701 102,150 (8,651) 69% 3% 74% 51 Inter -Governmental 211,768 176,473 128,876 159,158 166,683 (9,791) 79% 23% 5% 64 Machinery & Equipment - -- - 7,934 7,934 - - - Total Operating Expenses 1,628,365 1,418,358 1,394,526 1,062,492 1,185,750 (232,609) 73% (24)% 12% Total Expenses 11,862,568 8,753,918 8,778,756 8,470,262 8,789,700 35,781 74% (4)% 4% Percent of year completed FIRE DIVISION SUMMARY 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 867,812 708,905 566,084 601,673 665,090 (43,815) 77% 6% 11% SUPPRESSION 8,944,102 6,516,218 6,635,949 6,455,026 6,553,358 37,140 73% (3)% 2% PREVENTION 833,040 624,021 639,688 600,356 653,202 29,181 78% (6)% 9% TRAINING 448,048 327,374 282,211 274,125 348,604 21,230 78% (3)% 27% EMERGENCY PREPAREDNESS 351,305 261,868 394,781 257,754 266,947 5,079 76% (35)% 4% FIRE FACILITIES 110,860 81,026 70,918 66,789 77,314 (3,711) 70% (6)% 16% HAZARDOUS MATERIALS UNIT 39,883 37,883 33,037 30,586 23,359 (14,524) 59% (7)% (24)% RESCUE TEAM 13,250 157 3,531 - 157 - 1% - - RESCUE AND EMERGENCY AID 42,500 19,993 23,682 24,796 34,986 14,993 82% 5% 41% COMMUNICATION -DISPATCH 211,768 176,473 128,876 159,158 166,683 (9,791) 79% 23% 5% Total Expenses 11,862,568 8,753,918 8,778,756 8,470,262 8,789,700 35,781 74% (4)% 4% Percent of year completed 75.00% 55 FIRE ADMINISTRATION YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL ACTUAL COMPARISON OF RESULTS COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2016 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries I 442,193 341,836 T 321,479 342,645 313,601 / (28,235) 71% 7% (8)% 12 Extra Labor I - - 321,472 1,876 4,473 112 112 - 138% (97)% 13 Overtime 464 - - 25 - - - - - - 21 FICA 14,064 14,064 596 10,477 11,148 16,565 2,501 118% 6% 49% 22 Pension-LEOFF 15,763 2,161 77% 11,610 11,103 11,236 9,075 71% (4)% 1% 23 Pension-PERS/PSERS 15,956 11,993 14% 9,508 11,094 11,537 (455) 72% 17% 4% 24 Industrial Insurance 9,186 6,162 (9)% 4,665 4,981 5,324 (838) 58% 7% 7% 25 Medical & Dental 76,702 55,375 Total Salaries & Benefits 53,044 49,724 59,773 4,399 78% (6)% 20% Total Salaries & Benefits - 574,328 431,590 - 412,684 435,168 418,148 (13,441) 73% 5% (4)% 31 Supplies 10,877 9,250 108,332 7,571 9,276 8,508 (742) 78% 23% (8)% 41 Professional Services 25,000 25,000 93,804 2,660 2,137 - (25,000) - (20)% - 42 Communication 23,170 16,593 20,901 18,809 18,918 21,421 4,828 92% 1% 13% 43 Travel 2,250 2,250 11 429 12 1,538 (712) 68% (97)% 12495% 45 Rentals and Leases 1 25,897 25,897 - 16,108 16,050 19,639 (6,258) 76% (0)% 22% 46 Insurance 173,286 173,286 75% 90,000 90,000 173,286 - 100% 0% 93% 48 Repairs and Maintenance 20,421 13,614 68% 15,013 13,565 10,450 (3,164) 51% (10)% (23)% 49 Miscellaneous I 12,583 11,426 32% 2,809 4,968 4,166 (7,260) 33% 77% (16)% 64 Machinery & Equipment- (25)% - - 11,578 7,934 7,934 - - (31)% Total Operating Expenses 293,484 277,316 8,944,102 153,399 166,505 246,941 (30,374) • 84% 9% 48% 2% Total Expenses 867,812 708,905 1 566,084 601,673 665,090 1 (43,815) 77% 6% 11% Percent of year completed FIRE SUPPRESSION 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 3,996,180 4,033,684 4,106,651 4,257,668 261,489 78% 2% 4% 13 Overtime 560,822 439,100 468,386 321,472 372,063 (67,037) 66% (31)% 16% 15 Holiday Pay 324,520 2,076 4,767 1,465 - (2,076) - (69)% - 21 FICA 84,525 60,165 57,429 58,124 60,761 596 72% 1% 5% 22 Pension-LEOFF 318,206 229,124 228,724 230,046 244,746 15,621 77% 1% 6% 24 Industrial Insurance 328,667 231,313 156,059 177,619 181,903 (49,410) 55% 14% 2% 25 Medical & Dental 1,210,861 909,474 1,003,589 1,048,180 956,558 47,084 79% 4% (9)% 28 Uniform/Clothing -- 1,712 - - - - - - Total Salaries & Benefits 8,262,251 5,867,433 5,954,350 5,943,558 6,073,699 206,267 74% (0)% 2% ' 31 Supplies 129,100 108,332 172,695 102,853 58,311 (50,020) 45% (40)% (43)% 35 Small Tools 12,000 4,228 93,804 - 4,228 - 35% - - 41 Professional Services 26,500 21,975 31,715 20,901 7,458 (14,517) 28% (34)% (64)% 42 Communication -- 71 10 11 11 - (86)% 5% 43 Travel -- 6,637 28 - - - (100)% - 45 Rentals and Leases 471,460 471,460 340,920 336,268 353,745 (117,715) 75% (1)% 5% 48 Repairs and Maintenance 20,000 20,000 18,463 30,971 28,943 8,943 145% 68% (7)% 49 Miscellaneous 22,791 22,791 17,293 20,438 26,962 4,171 118% 18% 32% Total Operating Expenses 681,851 648,785 681,598 511,468 479,658 - (169,127) 70% (25)% (6)% I Total Expenses 8,944,102 6,516,218 - 6,635,949 6,455,026 6,553,358 • 37,140 73% (3)% 2% Percent of year completed 56 75.00% FIRE PREVENTION/INVESTIGATION YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS I 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 1 558,405 407,046 410,520 409,277 411,804 4,758 74% (0)% 1% 12 Extra Labor - - - - 1,782 1,782 - - - 13 Overtime 61,143 61,143 47,884 47,289 78,160 17,017 128% (1)% 65% 21 FICA 18,205 13,491 13,817 13,955 14,583 1,091 80% 1% 5% 22 Pension-LEOFF 23,426 17,030 16,265 16,461 18,096 1,066 77% 1% 10% 23 Pension-PERS/PSERS 18,383 13,780 11,485 13,275 13,923 143 76% 16% 5% 24 Industrial Insurance 17,123 11,457 8,136 9,124 10,229 (1,228) 60% 12% 12% 25 Medical & Dental 87,040 63,636 55,403 58,519 64,213 578 74% 6% 10% Total Salaries & Benefits 783,725 587,583 563,509 567,899 612,790 25,207 78% 1% 8% 42 Communication- - ' 720 627 , - 0% (13)% 31 Supplies 12,000 8,792 13,469 10,435 8,422 (370) 70% (23)% (19)% 41 Professional Services 5,000 5,000 1,655 739 - (5,000) - (55)% - 42 Communication - - 927 1,207 1,936 1,936 - 30% 60% 43 Travel 1,500 1,500 326 721 2,224 724 148% 121% 208% 45 Rentals and Leases 23,815 14,146 58,003 16,887 20,062 5,916 84% (71)% 19% 48 Repairs and Maintenance- 448,048 - 244 84 330 330 - (65)% 292% 49 Miscellaneous 7,000 7,000 1,555 2,384 7,438 438 106% 53% 212% Total Operating Expenses 49,315 36,438 76,179 32,457 40,412 3,974 82% (57)% 25% Total Expenses 833,040 624,021 639,688 600,356 653,202 29,181 78% (6)% 9% Percent of year completed FIRE TRAINING 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 169,315 170,903 174,104 202,270 32,956 86% 2% 16% 13 Overtime 18,813 15,201 14,707 5,118 15,041 (159) 80% (65)% 194% 21 FICA 1,818 1,818 1,349 1,259 2,577 759 142% (7)% 105% 22 Pension-LEOFF 12,678 9,339 9,655 9,321 10,044 704 79% (3)% 8% 24 Industrial Insurance 8,884 6,207 4,388 5,189 5,367 (840) 60% 18% 3% 25 Medical & Dental 43,357 32,380 30,122 29,744 22,137 (10,243) 51% (1)% (26)% Total Salaries & Benefits 320,230 234,260 231,125 224,736 257,437 23,177 80% (3)% 15% 31 Supplies 8,500 6,518 3,447 2,969 3,960 (2,558) 47% (14)% 33% 41 Professional Services 4,500 2,250 2,800 1,400 2,800 550 62% (50)% 100% 42 Communication- - 720 720 627 627 - 0% (13)% 43 Travel 2,000 2,000 2,338 5,556 8,153 6,153 408% 138% 47% 45 Rentals and Leases 16,818 13,086 8,732 8,907 12,614 (473) 75% 2% 42% 49 Miscellaneous 96,000 69,261 33,049 29,837 63,014 (6,247) 66% (10)% 111% Total Operating Expenses 127,818 93,115 51,086 49,389 91,168 (1,947) 71% (3)% 85% Total Expenses 448,048 327,374 282,211 274,125 348,604 21,230 78% (3)% 27% Percent of year completed 75.00% 57 FIRE EMERGENCY PREPAREDNESS YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 218,816 157,365 T 153,581 162,588 188,483 31,118 86% 6% 16% 12 Extra Labor 1 - - 3,247 6,610 1,852 1,852 - 104% (72)% 13 Overtime 9,406 7,878 19,864 19,045 3,629 (4,249) 39% (4)% (81)% 21 FICA 6,680 5,064 5,219 5,130 4,948 (116) 74% (2)% (4)% 22 Pension-LEOFF 7,103 5,492 5,660 6,316 5,546 55 78% 12% (12)% 23 Pension-PERS/PSERS 10,282 7,721 6,471 6,749 7,336 (385) 71% 4% 9% 24 Industrial Insurance 4,795 3,484 2,618 3,429 2,610 (874) 54% 31% (24)% 25 Medical & Dental 36,587 27,692 25,902 26,543 27,472 (220) 75% 2% 3% Total Salaries & Benefits - 293,669 214,695 222,561 236,410 241,875 27,180 82% 6% 2% 31 Supplies 12,000 6,213 13,423 19,037 6,594 381 55% 42% (65)% 35 Small Tools 24,268 24,268 133,158 1,973 - (24,268) - (99)% - 42 Communication - - 15,476 5,081 5,618 5,618 - (67)% 11% 43 Travel - - 2,610 414 14 14 - (84)% (97)% 45 Rentals and Leases 16,368 16,368 5,380 5,650 12,276 (4,092) 75% 5% 117% 48 Repairs and Maintenance- - 756 272 - - - (64)% - 49 Miscellaneous 5,000 324 1,416 495 570 246 11% (65)% 15% 64 Machinery & Equipment - - - (11,578) - - - - - Total Operating Expenses 57,636 47,173 172,220 21,344 25,072 (22,101) 44% (88)% 17% Total Expenses 351,305 261,868 394,781 257,754 266,947 5,079 76% (35)% 4% Percent of year completed FIRE FACILITIES 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 SUMMARY BY BUDGET _ ACTUAL COMPARISON OF RESULTS ACTUAL EXPENDITURE TYPE 2017 OVER/(UNDER) °A CHANGE ALLOCATED 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 31 Supplies ' 28,500 21,586 16,436 10,372 12,111 (9,475) 42% (37)% 17% 42 Communication 9,000 7,178 1,702 1,748 1,789 (5,389) 20% 3% 2% 47 Public Utilities 73,360 52,262 52,780 54,089 63,414 11,152 86% 2% 17% 49 Miscellaneous- - - 579 - - - - - Total Operating Expenses 110,860 81,026 70,918 66,789 77,314 (3,711) 70% (6)% 16% Total Expenses 110,860 81,026 70,918 66,789 77,314 (3,711) 70% (6)% 16% Percent of year completed 58 75.00° FIRE HAZARDOUS MATERIALS UNIT YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 SUMMARY BY BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY BY ACTUAL EXPENDITURE TYPE EXPENDITURE TYPE EXPENDITURE TYPE OVER/(UNDER) OVER/(UNDER) °A CHANGE ALLOCATED ALLOCATED % CHANGE ALLOCATED 2017 ANNUAL 2017 2015 2017 2017 BDGT 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 31 Supplies 2,000 - 1 2,049 - - ( - - - - 35 Small Tools -- -- 181 - - - - - - 41 Professional Services 20,000 20,000 17,404 17,760 9,947 (10,053) 50% 2% (44)% 45 Rentals and Leases 17,883 17,883 12,215 12,826 13,412 (4,471) 75% 5% 5% 48 Repairs and Maintenance - - 241 - - - - - - 49 Miscellaneous -- - 947 - - - - - - Total Operating Expenses 39,883 37,883 33,037 30,586 23,359 (14,524) 59% (7)% (24)% - 1% - - Total Expenses 39,883 37,883 - 33,037 30,586 23,359 (14,524) 59% (7)% (24)% Percent of year completed FIRE RESCUE TEAM 75.00° YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 Percent of year completed FIRE RESCUE AND EMERGENCY AID 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY BY ACTUAL EXPENDITURE TYPE EXPENDITURE TYPE OVER/(UNDER) OVER/(UNDER) ALLOCATED % CHANGE ALLOCATED 2017 ANNUAL ALLOCATED 2015 2017 2017 BDGT % SPEND 2015/2016 2016/2017 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 31 Supplies 5,000 157 3,531 - 157 - 3% - - 35 Small Tools 1,000 -- 8,846 - - - - - - 43 Travel 1,250 -- - - - - - - - 48 Repairs and Maintenance 500 -- 19,993 - - - - - - 49 Miscellaneous 5,500 - - - - -- - Total Operating Expenses 13,250 157 3,531 - 157 - 1% - - 5% 41% Total Expenses 13,250 157 3,531 - 157 - 1% - - Percent of year completed FIRE RESCUE AND EMERGENCY AID 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 Percent of year completed 75.00% 59 BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY BY ACTUAL EXPENDITURE TYPE 2017 OVER/(UNDER) % CHANGE ALLOCATED 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 31 Supplies 1 26,500 11,147 18,563 19,421 23,391 12,245 88% 5% 20% 41 Professional Services - - - - 344 344 - - - 45 Rentals and Leases 15,000 8,846 5,119 5,375 11,250 2,404 75% 5% 109% 48 Repairs and Maintenance 1,000 - - - - - - - - Total Operating Expenses 42,500 19,993 23,682 24,796 34,986 14,993 82% 5% 41% Total Expenses 42,500 19,993 23,682 24,796 34,986 14,993 82% 5% 41% Percent of year completed 75.00% 59 FIRE COMMUNICATIONS, ALARMS AND DISPATCH YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 176,473 128,876 159,158 166,683 (9,791) 79% 23% 5% Total Operating Expenses 211,768 176,473 128,876 159,158 166,683 (9,791) 79% 23% 5% Total Expenses 211,768 176,473 128,876 159,158 166,683 (9,791) 79% 23% 5% Percent of year completed 60 75.00% TECHNOLOGY & INNOVATION SERVICES CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 681,698 394,071 509,626 528,135 (153,564) 61% 29% 4% 12 Extra Labor 2,500 2,500 10,538 1,057 4,147 1,647 166% (90)% 292% 13 Overtime - - 15,165 26,420 64,226 64,226 - 74% 143% 21 FICA 63,632 48,817 31,323 40,214 44,976 (3,842) 71% 28% 12% 22 Pension-LEOFF 2 - - - 3,488 - - - - - 23 Pension-PERS/PSERS 104,269 74,873 41,173 46,259 69,414 (5,459) 67% 12% 50% 24 Industrial lnsurance 3,176 2,476 1,879 2,363 1,683 (793) 53% 26% (29)% 25 Medical & Dental 194,560 149,675 84,549 99,810 106,169 (43,506) 55% 18% 6% 26 Unemployment - - - 8,632 - - - - - Total Salaries & Benefits 1,237,429 960,040 578,698 737,869 818,749 (141,291) 66% 28% 11% 31 Supplies 6,266 . 6,266 5,736 16,914 23,020 16,754 367% 195% 36% 35 Small Tools - - 23,905 31,370 45,891 45,891 - 31% 46% 41 Professional Services 304,686 9,728 30,213 4,408 79,471 69,742 26% (85)% 1703% 42 Communication 120,900 63,161 82,550 67,691 74,891 11,730 62% (18)% 11% 43 Travel 11,500 1,196 139 242 7,216 6,020 63% 73% 2884% 45 Rentals and Leases 153,839 85,391 4,698 4,863 142,296 56,905 92% 4% 2826% 48 Repairs and Maintenance 2,000 2,000 14,170 20,120 11,750 9,750 588% 42% (42)% 49 Miscellaneous 147,200 59,445 19,167 15,624 46,774 (12,671) 32% (18)% 199% 64 Machinery & Equipment 43,000 6,000 9,341 - 6,000 - 14% - - Total Operating Expenses 789,391 233,1881 189,920 161,232 437,310 204,122 55% (15)% 171% Total Expenses 2,026,820 1,193,228 768,618 899,101 1,256,059 62,831 62% 17% 40% Percent of year completed 75.00% 61 PUBLIC WORKS CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF SEPTEMBER 30, 2017 10/31/2017 15:18 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 1,446,589 1,383,712 1,428,891 1,324,786 ( (121,803) 69% 3% (7)% 12 Extra Labor -- - - 1,878 1,878 - - - 13 Overtime 10,000 10,000 16,994 9,308 15,750 5,750 157% (45)% 69% 21 FICA 141,515 109,342 105,580 107,565 99,291 (10,051) 70% 2% (8)% 23 Pension-PERS/PSERS 229,639 173,453 136,480 158,325 152,062 (21,391) 66% 16% (4)% 24 Industrial Insurance 36,725 26,154 17,025 19,760 17,231 (8,922) 47% 16% (13)% 25 Medical & Dental 377,031 283,599 234,967 258,428 261,386 (22,214) 69% 10% 1% 26 Unemployment -- (39,731) - 10,547 - - - - - 28 Uniform/Clothing 3,200 1,441 565 674 565 (876) 18% 19% (16)% Total Salaries & Benefits 2,710,771 2,050,578 1,895,323 1,993,498 1,872,949 (177,629) 69% 5% (6)% 31 Supplies 110,950 81,864 58,114 80,363 65,503 (16,361) 59% 38% (18)% 35 Small Tools 4,250 2,992 107 1,234 630 (2,361) 15% 1051% (49)% 41 Professional Services 30,900 29,478 27,115 17,781 28,887 (591) 93% (34)% 62% 42 Communication 9,150 8,014 5,509 5,552 8,200 186 90% 1% 48% 43 Travel 2,000 1,816 2,486 336 828 (988) 41% (86)% 146% 44 Advertising -- - 463 - - - - - 45 Rentals and Leases 162,978 118,644 120,534 115,551 115,396 (3,248) 71% (4)% (0)% 46 Insurance 106,805 106,805 - 106,805 107,271 466 100% - 0% 47 Public Utilities 375,000 265,777 243,988 258,412 282,274 16,497 75% 6% 9% 48 Repairs and Maintenance 252,300 156,353 153,593 148,339 144,329 (12,023) 57% (3)% (3)% 49 Miscellaneous 30,035 21,926 6,127 8,418 11,928 (9,998) 40% 37% 42% 64 Machinery & Equipment 7,500 6,890 -- 6,890 - 92% - - Total Operating Expenses 1,091,868 800,558 617,574 743,255 772,137 (28,422) 71% 20% 4% Total Expenses 3,802,639 2,851,137 2,512,897 2,736,753 2,645,086 (206,051) 70% 9% (3)% PUBLIC WORKS DIVISION SUMMARY Percent of year expired 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 15:18 Percent of year expired 62 75.00% 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 459,200 367,275 414,403 443,590 366,739 (536) 80% 7% (17)% MAINTENANCE ADMINISTRATION 393,700 292,570 273,586 281,139 285,901 (6,669) 73% 3% 2% PUBLIC WORKS DEVELOPMENT 486,910 367,484 343,144 349,957 368,014 531 76% 2% 5% ENGINEERING PLANS AND SERVICE: 643,476 482,825 394,248 382,650 323,179 (159,645) 50% (3)% (16)% FACILITY MAINTENANCE 1,819,353 1,340,984 1,087,516 1,279,417 1,301,253 (39,731) 72% 18% 2% Total Expenses 3,802,639 2,851,137 2,512,897 2,736,753 2,645,086 (206,051) 70% 9% (3)% Percent of year expired 62 75.00% PUBLIC WORKS ADMINISTRATION YTD AS OF SEPTEMBER 30, 2017 10/31/2017 15:18 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 256,694 310,566 328,697 266,673 9,979 84% 6% (19)% 12 Extra Labor -- 14,323 - - 1,878 1,878 - - - 21 FICA 21,520 18,525 23,143 23,590 18,138 (386) 84% 2% (23)% 23 Pension-PERS/PSERS 38,030 30,467 30,355 34,654 27,072 (3,395) 71% 14% (22)% 24 Industrial Insurance 1,059 782 743 722 557 (225) 53% (3)% (23)% 25 Medical & Dental 37,880 29,418 34,406 37,320 34,013 4,595 90% 8% (9)% Total Salaries & Benefits 415,272 335,886 399,214 424,982 348,332 12,446 84% 6% (18)% 31 Supplies 9,000 7,221 6,071 9,526 5,578 (1,643) 62% 57% (41)% 41 Professional Services -- - 3,645 4,723 - - - 30% - 42 Communication 1,500 1,062 1,161 829 400 (662) 27% (29)% (52)% 43 Travel 200 200 194 2 8 (192) 4% (99)% 312% 45 Rentals and Leases 3,428 2,327 2,490 2,277 2,293 (34) 67% (9)% 1% 48 Repairs and Maintenance 1,300 799 977 720 630 (169) 48% (26)% (13)% 49 Miscellaneous 21,000 12,891 650 530 2,608 (10,283) 12% (18)% 392% 64 Machinery & Equipment 7,500 6,890 -- 6,890 - 92% - - Total Operating Expenses 43,928 31,390 15,189 18,607 18,408 (12,982) 42% 23% (1)% Total Expenses 459,200 367,275 414,403 443,590 366,739 (536) 80% 7% (17)% PUBLIC WORKS MAINTENANCE ADMINISTRATION Percent of year expired 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 15:18 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 194,559 189,225 191,225 193,432 (1,127) 75% 1% 1% 21 FICA 18,422 14,323 14,250 14,180 14,436 113 78% (0)% 2% 23 Pension-PERS/PSERS 31,120 23,340 18,547 21,317 22,488 (852) 72% 15% 5% 24 Industrial Insurance 1,059 762 505 630 560 (202) 53% 25% (11)% 25 Medical & Dental 63,466 47,563 41,039 44,087 47,546 (17) 75% 7% 8% Total Salaries & Benefits 373,292 280,547 263,567 271,441 278,462 (2,085) 75% 3% 3% 31 Supplies 4,250 1,957 2,515 1,017 501 (1,456) 12% (60)% (51)% 35 Small Tools 750 750 - 219 - (750)- - - 41 Professional Services 500 - - - - - - - - 42 Communication 750 517 554 500 581 64 77% (10)% 16% 43 Travel 300 300 233 213 738 438 246% (9)% 247% 45 Rentals and Leases 11,823 6,463 5,843 5,820 4,784 (1,679) 40% (0)% (18)% 49 Miscellaneous 2,035 2,035 875 1,930 835 (1,200) 41% 121% (57)% Total Operating Expenses 20,408 12,023 10,019 9,699 7,439 (4,584) 36% (3)% (23)% Total Expenses 393,700 292,570 273,586 281,139 285,901 (6,669) 73% 3% 2% Percent of year expired 75.00% 63 PUBLIC WORKS PUBLIC WORKS DEVELOPMENT YTD AS OF SEPTEMBER 30, 2017 10/31/2017 15:18 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED % SPEND 2015/2016 2016/2017 11 Salaries 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 11 Salaries 334,218 250,735 243,483 246,106 246,160 (4,575) 74% 1% 0% 13 Overtime 9,000 9,000 6,234 3,500 14,271 5,271 159% (44)% 308% 21 FICA 26,120 19,622 18,888 18,972 19,767 144 76% 0% 4% 23 Pension-PERS/PSERS 40,123 30,140 24,573 27,875 30,386 247 76% 13% 9% 24 Industrial Insurance 3,793 2,715 2,280 2,248 2,236 (478) 59% (1)% (1)% 25 Medical & Dental 73,406 55,022 47,507 51,076 55,014 (8) 75% 8% 8% 28 Uniform/Clothing 250 250 180 180 180 (70) 72% 0% 0% Total Salaries & Benefits 486,910 367,484 343,144 349,957 368,014 531 76% 2% 5% Total Expenses 486,910 367,484 343,144 349,957 368,014 531 76% 2% 5% PUBLIC WORKS ENGINEERING PLANS AND SERVICES Percent of year expired 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 15:18 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 311,873 263,252 258,853 195,914 (115,959) 47% (2)% (24)% 21 FICA 30,825 23,636 19,926 19,581 14,749 (8,887) 48% (2)% (25)% 23 Pension-PERS/PSERS 50,370 37,388 25,917 28,782 22,703 (14,684) 45% 11% (21)% 24 Industrial Insurance 6,174 4,299 1,830 1,769 1,412 (2,888) 23% (3)% (20)% 25 Medical & Dental 73,401 55,553 38,744 39,252 30,682 (24,871) 42% 1% (22)% 28 Uniform/Clothing 950 - - - - - - - - Total Salaries & Benefits 581,295 432,749 349,668 348,237 265,461 (167,288) 46% (0)% (24)% 31 Supplies 7,000 4,573 4,083 4,357 4,637 64 66% 7% 6% 35 Small Tools 1,000 - - - - - - - - 41 Professional Services 28,400 28,400 22,614 12,230 28,768 368 101% (46)% 135% 42 Communication 2,300 1,835 1,536 1,351 986 (849) 43% (12)% (27)% 43 Travel 1,500 1,316 2,058 122 81 (1,235) 5% (94)% (33)% 44 Advertising -- - 463 - - - - - 45 Rentals and Leases 14,981 6,951 9,229 9,613 11,236 4,285 75% 4% 17% 48 Repairs and Maintenance 1,000 1,000 695 1,052 4,558 3,558 456% 51% 333% 49 Miscellaneous 6,000 6,000 4,365 5,226 7,453 1,453 124% 20% 43% Total Operating Expenses 62,181 50,075 44,580 34,413 57,719 7,643 93% (23)% 68% Total Expenses 643,476 482,825 394,248 382,650 323,179 (159,645) 50% (3)% (16)% Percent of year expired 64 75.00% PUBLIC WORKS FACILITY MAINTENANCE YTD AS OF SEPTEMBER 30, 2017 10/31/2017 15:18 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 432,728 377,186 404,010 422,608 (10,120) 73% 7% 5% 13 Overtime 1,000 1,000 10,760 5,807 1,478 478 148% (46)% (75)% 21 FICA 44,628 33,236 29,372 31,242 32,200 (1,036) 72% 6% 3% 23 Pension-PERS/PSERS 69,996 52,119 37,089 45,697 49,412 (2,707) 71% 23% 8% 24 Industrial Insurance 24,640 17,595 11,668 14,391 12,466 (5,129) 51% 23% (13)% 25 Medical & Dental 128,878 96,044 73,271 86,692 94,131 (1,913) 73% 18% 9% 26 Unemployment -- - 10,547 - - - - - 28 Uniform/Clothing 2,000 1,191 385 494 385 (806) 19% 28% (22)% Total Salaries & Benefits 854,002 633,913 539,731 598,881 612,681 (21,232) 72% 11% 2% 31 Supplies 90,700 68,113 45,445 65,462 54,787 (13,325) 60% 44% (16)% 35 Small Tools 2,500 2,242 107 1,015 630 (1,611) 25% 847% (38)% 41 Professional Services 2,000 1,078 856 829 119 (959) 6% (3)% (86)% 42 Communication 4,600 4,600 2,259 2,872 6,233 1,633 136% 27% 117% 45 Rentals and Leases 132,746 102,902 102,973 97,841 97,083 (5,819) 73% (5)% (1)% 46 Insurance 106,805 106,805 - 106,805 107,271 466 100% - 0% 47 Public Utilities 375,000 265,777 243,988 258,412 282,274 16,497 75% 6% 9% 48 Repairs and Maintenance 250,000 154,554 151,921 146,568 139,142 (15,412) 56% (4)% (5)% 49 Miscellaneous 1,000 1,000 237 732 1,031 31 103% 210% 41% Total Operating Expenses 965,351 707,071 547,785 680,537 688,572 (18,499) 71% 24% 1% Total Expenses 1,819,353 1,340,984 1,087,516 1,279,417 1,301,253 (39,731) 72% 18% 2% Percent of year expired 75.00% 65 PARK MAINTENANCE CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 423,409 443,696 382,241 410,253 (13,156) 71% (14)% 7% 12 Extra Labor 20,000 20,000 14,151 20,870 24,049 4,049 120% 47% 15% 13 Overtime 2,137 2,137 2,627 2,841 1,669 (468) 78% 8% (41)% 21 FICA 45,954 34,055 35,014 30,968 33,276 (779) 72% (12)% 7% 23 Pension-PERS/PSERS 69,438 50,896 43,947 42,954 48,008 (2,888) 69% (2)% 12% 24 Industrial Insurance 23,807 16,944 13,517 13,684 12,958 (3,986) 54% 1% (5)% 25 Medical & Dental 135,009 97,804 88,141 82,815 98,376 572 73% (6)% 19% 28 Uniform/Clothing 1,680 493 454 288 316 (177) 19% (37)% 10% Total Salaries & Benefits 876,433 645,738 641,547 576,661 628,905 , (16,832) 72% (10)% 9% 31 Supplies 53,800 53,800 37,564 80,440 66,094 12,294 123% 114% (18)% 35 Small Tools 7,500 3,145 3,072 4,183 5,318 2,173 71% 36% 27% 41 Professional Services 61,200 21,183 26,059 38,230 47,265 26,081 77% 47% 24% 42 Communication - -- 1,397 1,705 1,705 - - 22% 43 Travel 225 225 149 3,308 1,214 989 540% 2126% (63)% 45 Rentals and Leases 101,992 90,070 89,636 94,564 87,076 (2,995) 85% 5% (8)% 47 Public Utilities 290,610 242,383 227,217 207,345 225,547 (16,836) 78% (9)% 9% 48 Repairs and Maintenance 23,000 7,550 14,695 14,625 8,392 842 36% (0)% (43)% 49 Miscellaneous 4,000 4,000 8,802 4,540 7,414 3,414 185% (48)% 63% Total Operating Expenses 542,327 422,356 407,193 448,631 450,022 27,666 83% 10% 0% Total Expenses 1,418,760 1,068,094 1,048,740 1,025,292 1,078,928 10,834 76% (2)% 5% Percent of year expired 66 75.00% STREET MAINTENANCE & OPERATIONS CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) ALLOCATED BDGT % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 801,234 608,423 487,037 598,929 576,726 (31,697) 72% 23% (4)% 12 Extra Labor 45,000 45,000 19,530 33,128 45,630 630 101% 70% 38% 13 Overtime 11,000 7,383 4,102 6,210 10,259 2,876 93% 51% 65% 21 FICA 65,181 49,398 40,245 48,493 49,074 (324) 75% 20% 1% 23 Pension-PERS/PSERS 96,207 72,477 51,547 69,578 74,053 1,576 77% 35% 6% 24 Industrial lnsurance 31,445 21,998 15,210 18,842 19,601 (2,397) 62% 24% 4% 25 Medical & Dental 198,694 148,455 101,031 127,460 158,839 10,384 80% 26% 25% 26 Unemployment - - 1,004 465 970 970 - (54)% 109% 28 Uniform/Clothing 2,375 1,643 681 1,390 669 (974) 28% 104% (52)% Total Salaries & Benefits 1,251,136 954,776 720,388 904,493 935,821 (18,955) 75% 26% 3% 31 Supplies 297,300 197,223 157,896 147,613 138,751 (58,472) 47% (7)% (6)% 35 Small Tools 13,200 9,984 3,494 17,262 6,724 (3,259) 51% 394% (61)% 41 Professional Services 4,000 3,448 2,360 1,860 6,327 2,879 158% (21)% 240% 42 Communication 4,300 1,350 905 1,080 1,200 (150) 28% 19% 11% 43 Travel 2,700 2,100 66 175 3,110 1,010 115% 165% 1679% 44 Advertising 1,500 - 438 - - - - - - 45 Rentals and Leases 297,801 296,262 325,803 296,126 220,908 (75,354) 74% (9)% (25)% 46 Insurance 24,755 24,755 - 35,455 24,755 - 100% - (30)% 47 Public Utilities 1,152,100 1,017,101 837,719 997,986 1,069,569 52,467 93% 19% 7% 48 Repairs and Maintenance 27,100 22,480 4,711 15,001 6,712 (15,768) 25% 218% (55)% 49 Miscellaneous 5,200 5,200 5,627 2,775 7,464 2,264 144% (51)% 169% 53 Ext Taxes, Oper Assess - - 43 8 8 8- (82)% 11% 64 Machinery & Equipment 28,500 - - - - - - - - Total Operating Expenses 1,858,456 1,579,904 1,339,061 1,515,340 1,485,529 (94,374) 80% 13% (2)% Total Expenses 3,109,592 2,534,680 2,059,449 2,419,833 2,421,350 (113,330) 78% 17% 0% STREET MAINTENANCE & OPERATIONS DIVISION SUMMARY Percent of year expired 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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,252,136 955,488 720,973 905,580 936,984 11 (18,504) 75% 26% 3% GENERAL SERVICES 339,956 330,560 338,374 337,636 258,398 (72,162) 76% (0)% (23)% ROADWAY 810,800 790,263 632,512 755,985 788,571 (1,691) 97% 20% 4% STRUCTURES 2,500 2,500 - 2,137 6,712 4,212 268% - 214% LIGHTING 296,100 188,521 151,496 204,177 254,040 65,519 86% 35% 24% TRAFFIC CONTROL 271,500 200,893 170,698 159,902 111,976 (88,917) 41% (6)% (30)% SNOW & ICE CONTROL 10,300 10,000 440 871 14,155 4,155 137% 98% 1525% STREET CLEANING 62,000 48,259 42,941 35,860 48,570 311 78% (16)% 35% VIDEO & FIBER 33,500 6,303 1,972 8,908 49 (6,254) 0% 352% (99)% SIDEWALKS 2,300 1,893 42 8,777 1,893 - 82% 20753% (78)% Total Expenses 3,081,092 2,534,680 2,059,449 2,419,833 2,421,350 (113,330) 79% 17% 0% Percent of year expired 75.00% 67 STREET MAINTENANCE & OPERATIONS ADMINISTRATION YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 608,423 487,037 598,929 576,726 I (31,697) 72% 23% (4)% 12 Extra Labor 45,000 45,000 19,530 33,128 45,630 630 101% 70% 38% 13 Overtime 11,000 7,383 4,102 6,210 10,259 2,876 93% 51% 65% 21 FICA 65,181 49,398 40,245 48,493 49,074 (324) 75% 20% 1% 23 Pension-PERS/PSERS 96,207 72,477 51,547 69,578 74,053 1,576 77% 35% 6% 24 Industrial Insurance 31,445 21,998 15,210 18,842 19,601 (2,397) 62% 24% 4% 25 Medical & Dental 198,694 148,455 101,031 127,460 158,839 10,384 80% 26% 25% 26 Unemployment -- 220,801 1,004 465 970 970 - (54)% 109% 28 Uniform/Clothing 2,375 1,643 681 1,390 669 (974) 28% 104% (52)% Total Salaries & Benefits 1,251,136 954,776 720,388 904,493 935,821 - (18,955) 75% 26% 3% 31 Supplies 1,000 712 195 697 722 9 72% 258% 3% 41 Professional Services -- 330,560 390 390 442 442 - 0% 13% Total Operating Expenses 1,000 712 585 1,087 1,164 451 116% 86% 7% Total Expenses 339,956 330,560 338,374 337,636 258,398 (72,162) 76% (0)% (23)% Total Expenses 1,252,136 955,488 720,973 905,580 936,984 (18,504) 75% 26% 3% STREET MAINTENANCE & OPERATIONS GENERAL SERVICES Percent of year expired 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 3,378 5,536 3,056 2,088 (1,289) 42% (45)% (32)% 35 Small Tools 3,000 - 613 - - - - - - 41 Professional Services 1,100 826 291 654 396 (430) 36% 125% (39)% 42 Communication 2,500 - - - - - - - - 43 Travel 2,000 2,000 66 175 2,893 893 145% 165% 1556% 44 Advertising 1,500 - 438 - - - - - - 45 Rentals and Leases 294,401 294,401 325,803 295,521 220,801 (73,600) 75% (9)% (25)% 46 Insurance 24,755 24,755 - 35,455 24,755 - 100% - (30)% 48 Repairs and Maintenance 500 - - - - - - - - 49 Miscellaneous 5,200 5,200 5,627 2,775 7,464 2,264 144% (51)% 169% Total Operating Expenses 339,956 330,560 338,374 337,636 258,398 (72,162) 76% (0)% (23)% Total Expenses 339,956 330,560 338,374 337,636 258,398 (72,162) 76% (0)% (23)% Percent of year expired 68 75.00% STREET MAINTENANCE & OPERATIONS ROADWAY YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 STREET MAINTENANCE & OPERATIONS STRUCTURES Percent of year expired 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 1,000 1,500 2017 - - 2,137 - - 6,712 OVER/(UNDER) - 447% % CHANGE ALLOCATED 2,500 2,500 - 2,137 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 31 Supplies 39,000 32,542 29,871 17,578 29,087 (3,455) 75% (41)% 65% 35 Small Tools 4,000 4,000 174 11,515 28 (3,972) 1% 6515% (100)% 41 Professional Services 100 - - - - -- 35% - - 43 Travel 100 100 -- 254,040 216 116 216% - - 45 Rentals and Leases 3,400 1,861 - 605 107 (1,754) 3% - (82)% 47 Public Utilities 764,100 751,759 602,468 726,287 759,132 7,372 99% 21% 5% 48 Repairs and Maintenance 100 - - - - -- - - Total Operating Expenses 810,800 790,263 632,512 755,985 788,571 (1,691) 97% 20% 4% Total Expenses 810,800 790,263 632,512 755,985 788,571 (1,691) 97% 20% 4% STREET MAINTENANCE & OPERATIONS STRUCTURES Percent of year expired 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 1,000 1,500 1,000 1,500 - - 2,137 - - 6,712 (1,000) 5,212 - 447% - - - - Total Operating Expenses 2,500 2,500 - 2,137 6,712 4,212 268% - 214% 57% - - 41 Professional Services 500 322 352 339 398 Total Expenses 2,500 2,500 - 2,137 6,712 4,212 268% - 214% STREET MAINTENANCE & OPERATIONS LIGHTING Percent of year expired 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 25,000 2,846 1,278 1,402 18,453 15,607 74% 10% 1216% 35 Small Tools 500 284 - - 284 - 57% - - 41 Professional Services 500 322 352 339 398 76 80% (3)% 17% 43 Travel 100 - - - - - - - - 47 Public Utilities 270,000 185,069 149,866 202,435 234,906 49,837 87% 35% 16% Total Operating Expenses 296,100 188,521 151,496 204,177 254,040 65,515 86% 35% 24% Total Expenses 296,100 188,521 151,496 204,177 254,040 65,519 86% 35% 24% Percent of year expired 75.00% 69 STREET MAINTENANCE & OPERATIONS TRAFFIC CONTROL YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 STREET MAINTENANCE & OPERATIONS SNOW & ICE CONTROL Percent of year expired 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 2017 440 - 871 - 14,155 - OVER/(UNDER) 142% - % CHANGE ALLOCATED 10,300 10,000 440 871 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 31 Supplies 166,000 122,549 114,302 104,607 51,566 (70,983) 31% (8)% (51)% 35 Small Tools 2,500 2,500 2,621 2,157 4,704 2,204 188% (18)% 118% 41 Professional Services 100 100 230 252 1,281 1,181 1281% 10% 409% 42 Communication 1,800 1,350 905 1,080 1,200 (150) 67% 19% 11% 43 Travel 100 - - - - - - - - 47 Public Utilities 81,000 54,394 51,706 47,519 53,225 (1,169) 66% (8)% 12% 48 Repairs and Maintenance 20,000 20,000 935 4,286 - (20,000) - 359% - Total Operating Expenses 271,500 200,893 170,698 159,902 111,976 (88,917) 41% (6)% (30)%, Total Expenses 271,500 200,893 170,698 159,902 111,976 (88,917) 41% (6)% (30)% STREET MAINTENANCE & OPERATIONS SNOW & ICE CONTROL Percent of year expired 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 10,000 - 440 - 871 - 14,155 - 4,155 - 142% - 98% 1525% - - Total Operating Expenses 10,300 10,000 440 871 14,155 4,155 137% 98% 1525% 142% 141% 727% 41 Professional Services 2,200 2,200 1,098 225 3,810 Total Expenses 10,300 10,000 440 871 14,155 4,155 137% 98% 1525% I STREET MAINTENANCE & OPERATIONS STREET CLEANING Percent of year expired 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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 18,000 18,000 5,815 11,740 20,737 1 2,737 115% 102% 77% 35 Small Tools 1,200 1,200 86 207 1,709 509 142% 141% 727% 41 Professional Services 2,200 2,200 1,098 225 3,810 1,610 173% (80)% 1593% 43 Travel 100 - - - - - - - - 47 Public Utilities 37,000 25,879 33,679 21,744 22,306 (3,573) 60% (35)% 3% 48 Repairs and Maintenance 3,500 980 2,221 1,937 - (980) - (13)% - 53 Ext Taxes, Assessments - - 43 8 8 8 - (82)% 11 Total Operating Expenses 62,000 48,259 42,941 35,860 48,570 311 78% (16)% 35% Total Expenses 62,000 48,259 42,941 35,860 48,570 A 311 78% (16)% 35% Percent of year expired 70 75.00% STREET MAINTENANCE & OPERATIONS VIDEO & FIBER YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 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 4,303 2,000 - 416 - 1,556 5,524 3,384 - - 8,777 49 - - (4,254) (2,000) - 0% - - 1226% (99)% - - - - Total Operating Expenses 33,500 6,303 1,972 8,908 8,777 49 (6,254) 0% 352% (99)% Total Expenses 33,500 6,303 1,972 8,908 8,777 49 (6,254) 0% 352% (99)% STREET MAINTENANCE & OPERATIONS SIDEWALKS Percent of year expired 75.00% YTD AS OF SEPTEMBER 30, 2017 10/31/2017 10:48 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,893 - 42 - - 8,777 1,893 - - - 82% - - - - - Total Operating Expenses 2,300 1,893 42 8,777 1,893 - 82% 20753% (78)% Total Expenses 2,300 1,893 42 8,777 1,893 - 82% 20753% (78)% Percent of year expired 75.00% 71 City of Tukwila Contingency Fund 105 - Revenue and Expenditures As of September 30 2017 % of year expired 75.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance ** Budget Revenue Miscellaneous Revenue Investment Earnings $ 20,000 $ 15,000 $ 33,653 $ 18,653 168.26% Total Miscellaneous Revenue 20,000 15,000 33,653 18,653 168.26% Total Revenue 20,000 15,000 33,653 18,653 168.26% Total Expenditures Change in Fund Balance 20,000 15,000 33,653 18,653 168.26% Beginning Fund Balance 5,716,048 5,716,048 6,050,624 334,576 105.85% Ending Fund Balance $ 5,736,048 $ 5,731,048 $ 6,084,277 $ 353,229 106.07% Cash and investments $ 6,081,579 ** Variance = Actual over (under) prorated budget Fund 105 72 City of Tukwila Hotel/Motel Tax Fund 101 - Revenue and Expenditures As of September 30 2017 of year expired 75.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance ** Budget Revenue General Revenue Hotel/Motel Taxes $ 733,000 $ 549,750 $ 518,280 $ (31,470) 70.71% Total General Revenue 733,000 549,750 518,280 (31,470) 70.71% Miscellaneous Revenue Investment Earnings 3,000 2,250 1,270 (980) 42.34% Total Revenue 736,000 552,000 519,551 (32,449) 70.59% Expenditures 31 Office & Operating Supplies 5,000 3,750 30 (3,720) 0.61% 41 Professional Services 370,000 277,500 170,500 (107,000) 46.08% 42 Communication - - (6,393) (6,393) Transfers Out 10,000 7,500 317 (7,183) 3.17% 44 Advertising - 75 75 - 49 Miscellaneous 20,000 15,000 9,939 (5,061) 49.70% Total Hotel/Motel Tax Fund 405,000 303,750 174,469 (129,281) 43.08% Indirect cost allocation 35,700 26,775 26,775 - 75.00% Total Expenditures 440,700 330,525 201,244 (129,281) 45.66% Change in Fund Balance 295,300 221,475 318,307 96,832 107.79% Beginning Fund Balance 906,875 906,875 912,558 5,683 100.63% Ending Fund Balance $ 1,202,175 $ 1,128,350 $ 1,230,865 $ 102,515 102.39% Cash and investments $ 1,146,549 ** Variance = Actual over (under) prorated budget Fund 101 73 City of Tukwila Drug Seizure Fund 109 - Revenue and Expenditures As of September 30 2017 % of year expired 75.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance ** Budget Revenue Miscellaneous Revenue Investment Earnings $ - $ $ 33 $ 33 - Seizure Revenue 60,000 45,000 31,962 (13,038) 53.27% Total Miscellaneous Revenue 60,000 45,000 31,996 (13,004) 53.33% Total Revenue 60,000 45,000 31,996 (13,004) 53.33% Expenditures 31 Office & Operating Supplies 3,000 2.250 72,144 69,894 2404.80% 35 Small Tools & Minor Equipment - 23,130 23,130 - 41 Professional Services 10,000 7,500 184,859 177,359 1848.59% 42 Communication - 1,307 1,307 - 43 Travel 21,782 21,782 45 Operating Rentals & Leases - 2,290 2,290 48 Repairs & Maintenance - 892 892 - 49 Miscellaneous 2,000 1,500 8,483 6,983 424.17% 51 Intergovernmental Prof Svcs 30,000 22,500 - (22,500) - 64 Capital Outlay - - 33,919 33,919 Total Drug Seizure Fund 45,000 33,750 348,805 315,055 775.12% Total Expenditures 45,000 33,750 348,805 315,055 775.12% Change in Fund Balance 15,000 11,250 (316,810) (328,060) -2112.06% Beginning Fund Balance 461,635 461,635 553,539 91,904 119.91% Ending Fund Balance $ 476,635 $ 472,885 $ 236,729 $ (236,156) 49.67% Cash and investments $ 237,259 ** Variance = Actual over (under) prorated budget Fund 109 74 City of Tukwila Street Fund 103 - Revenue and Expenditures As of September 30 2017 % of year expired 75.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance ** Budget Revenue Intergovernmental Revenue State Grant -Cascade View $ 1,894,000 $ 1,420,500 $ 802,533 $ (617,967) 42.37% Total Intergovernmental Revenue $ 1,894,000 $ 1,420,500 $ 802,533 $ (617,967) 42.37% Miscellaneous Revenue Investment Earnings 1,500 1,125 2,295 1,170 153.01% Plan/Development Contributions 1,902,000 1,426,500 - (1,902,000) - Total Miscellaneous Revenue 1,903,500 1,427,625 2,295 (1,900,830) 0.12% Bond proceeds 5,600,000 4,200,000 8,536,839 2,936,839 152.44% Transfers In - Total Revenue 9,397,500 7,048,125 9,341,667 418,042 99.41% Expenditures 11 Salaries 95,281 95,281 - 21 FICA 7,225 7,225 23 PERS 11,235 11,235 - 24 Industrial Insurance 1,197 1,197 25 Medical, Dental, Life, Optical 13,506 13,506 - 41 Professional Services 75,000 56,250 257 (55,993) 0.34% 64 Capital Outlay 9,278,000 6,958,500 940,992 (6,017,508) 10.14% 81 Debt Service Costs - - 113,120 113,120 - Total Streets Fund 9,353,000 7,014,750 1,182,813 (5,831,937) 12.65% Total Expenditures 9,353,000 7,014,750 1,182,813 (5,831,937) 12.65% Change in Fund Balance Beginning Fund Balance 44,500 33,375 8,158,854 6,249,979 18334.50% 833,331 833,331 658,932 (174,399) 79.07% Ending Fund Balance $ 877,831 $ 866,706 $ 8,817,786 $ 6,075,580 1004.50% Cash and investments $ 8,803,439 ** Variance = Actual over (under) prorated budget Fund 103 75 City of Tukwila Arterial Street Fund 104 - Revenue and Expenditures As of September 30 2017 % of year expired 75.00% 2017 Annual Budget Prorated Budget Actual Year -To -Date Variance ** % of Annual Budget Revenue General Revenue Parking Taxes MVFT Cities Real Estate Excise Taxes Total General Revenue Charges for Services Park Impact Fees Traffic Impact Fees Total Charges for Services Intergovernmental Revenue Dept of Transportation -Tukwila Boeing Access Bridge Fed Trnst Cap Inv Grnts-Trnst WSDOT Reg Mobility Grant-Bridg State Grant -S 144th (TIB 43rd) State Grant-APW State Grant-Interurb Ave S Stat Multimodal Transportation -City Total Intergovernmental Revenue Miscellaneous Revenue Investment Earnings Contributions/Donations Total Miscellaneous Revenue Transfer In $ 200,000 $ 128,000 400,000 728,000 600,000 321,000 921,000 3,186,000 8,677,000 2,618,000 4,289,000 964,000 1,173,000 150,000 96,000 300,000 546,000 450,000 240,750 690,750 2,389,500 6,507,750 1,963,500 3,216,750 723,000 879,750 20,907,000 15,680,250 5,000 3,750 1,037,000 777,750 1,042,000 781,500 1,800,000 1,350,000 $ 163,752 $ 99,364 872,805 1,135,921 286,421 218,793 505,214 13,752 3,364 572,805 589,921 (313,579) (102,207) (415,786) 156,335 (2,233,165) 42,107 (6,465,643) (1,963,500) (975,322) (220,898) (879,750) 14,057 4,334 2,241,428 502,102 14,057 4,334 2,960,364 5,479 24,405 (12,719,886) 1,729 (753,345) 29,883 (751,617) (1,350,000) 81.88% 77.63% 218.20% 156.03% 47.74% 68.16% 54.85% 4.91% 0.49% 52.26% 52.09% 14.16% 109.57% 2.35% 2.87% Total Revenue 25, 398, 000 19, 048, 500 4,631,382 (14,647,368) 18.24% Expenditures 11 Salaries 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical T 31 Office & Operating Supplies 41 Professional Services 43 Travel 44 Advertising 45 Operating Rentals & Leases 47 Public Utility Services 48 Repairs & Maintenance 49 Miscellaneous 64 Capital Outlay Total Arterial Streets 104 Total Expenditures Change in Fund Balance Beginning Fund Balance 332,953 249,715 25,232 18,924 39,971 29,978 5,821 4,366 32,602 24,452 1,380,000 1,035,000 5,176,000 3,882,000 16,608,750 22,145,000 29,137,579 21,853,184 291,004 1,338 22,246 34,304 3,914 36,844 337 253,184 115 691 743 2,509 94,496 150 4,459,618 41,289 1,338 3,322 4,326 (452) 12,393 337 (781,816) 115 691 743 2,509 (3,787,504) 150 (12,149,132) 5,201,495 (16,651,690) 87.40% 88.17% 85.82% 67.24% 113.01% 18.35% 1.83% 20.14% 17.85% 29,137,579 21,853,184 5,201,495 (16,651,690) 17.85% (3,739,579) 3,786,923 (2,804,684) 3,786,923 (570,112) 2,004,322 3,999,376 212,453 15.25% 105.61% Ending Fund Balance $ 47,344 $ 982,239 $ 3,429,264 $ 2,216,775 7243.29% Cash and investments ** Variance = Actual over (under) prorated budget 76 Fund 104 $ 3,203,969 City of Tukwila Land Acquisition, Rec and Park Development Fund 301 - Revenue and Expenditures As of September 30 2017 % of year expired 75.00% 2017 Annual Prorated Year -To - Budget Budget Date Variance ** % of Annual Budget Revenue General Revenue Excess Prop Tax Levy-Dwmsh Hill $ $ Real Estate Excise Taxes 400,000 300,000 Total General Revenue 400,000 Charges for Services $ 31,439 $ 31,439 872,805 572,805 300,000 904,245 218.20% 604,245 226.06% Intergovernmental Revenue Duwamish Gardens Acquisition - 13,436 13,436 State Agencies-Duwamish Hill Pres 131,000 98,250 - (98,250) Total Intergovernmental Revenue 131,000 98,250 13,436 (84,814) 10.26% Miscellaneous Revenue Investment Earnings 1,000 750 1,591 841 159.14% Transfers In 184,000 138,000 (138,000) Total Revenue 716,000 537,000 919,272 382,272 128.39% Expenditures 11 Salaries 12 Extra Labor 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 31 Office & Operating Supplies 41 Professional Services 42 Communication 43 Travel 44 Advertising 'el 45 Operating Rentals & Leases 47 Public Utility Services 48 Repairs & Maintenance 64 Capital Outlay Total Park Acquisition Fund 185,000 138,750 954,000 715,500 1,139,000 854,250 14,203 14,203 2,124 2,124 1,256 1,256 1,332 1,332 1,930 1,930 556 556 4,170 4,170 24,374 24,374 78,278 (60,472) 29 29 36 36 21 21 155 155 350 350 26,277 26,277 84,734 (630,766) 239,823 (614,427) 42.31% 8.88% 21.06% Total Expenditures 1,139,000 854,250 239,823 (614,427) 21.06% Change in Fund Balance (423,000) (317,250) 679,449 996,699 -160.63% Beginning Fund Balance Ending Fund Balance Cash and investments 2,713,123 2,713,123 3,352,113 638,990 $ 2,290,123 $ 2,395,873 4,031,562 $ 1,635,689 ** Variance = Actual over (under) prorated budget Fund 301 $ 3,557,731 123.55% 176.04% 77 City of Tukwila Facility Replacement Fund 302 - Revenue and Expenditures As of September 30 2017 of year expired 75.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance ** Budget Revenue Miscellaneous Revenue Investment Earnings $ 3,600 $ 2,700 $ 2,072 $ (628) Total Miscellaneous Revenue 3,600 2,700 2,072 (628) Sale of Capital Assets (Property) 3,483,000 2,612,250 - (3,483,000) 57.55% 57.55% Total Revenue 3,486,600 2,614,950 2,072 (3,483,628) 0.06% Expenditures 11 Salaries - - - 41 Professional Services 25,000 18,750 38,121 19,371 152.48% 47 Public Utility Services - 10,539 10,539 49 Miscellaneous - 5,521 5,521 - 64 Capital Outlay 35,000 26,250 - (26,250) - Total Expenditures 60,000 45,000 54,181 9,181 90.30% Transfer to General Fund 1,800,000 1,350,000 - (1,350,000) - Total Expenditures 1,860,000 1,395,000 54,181 (1,340,819) 2.91% Change in Fund Balance Beginning Fund Balance 1,626,600 370,706 1,219,950 370,706 (52,109) (2,142,809) 295,040 (75,666) -3.20% 79.59% Ending Fund Balance $ 1,997,306 $ 1,590,656 $ 242,931 $ (2,218,475) 12.16% Cash and investments $ 2,580,495 ** Variance = Actual over (under) prorated budget Fund 302 78 City of Tukwila General Government Improvements 303 - Revenue and Expenditures As of September 30 2017 of year expired 75.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance ** Budget Revenue Miscellaneous Revenue Investment Earnings $ 500 $ 375 $ 1,087 $ 712 217.30% Total Miscellaneous Revenue 500 375 1,087 712 217.30% Transfers In 200,000 150,000 150,000 - 75.00% Total Revenue 200,500 150,375 151,087 712 75.35% Expenditures 11 Salaries 105,085 78,814 37,513 (41,301) 35.70% 13 Overtime - - 790 790 21 FICA 8,039 6,029 2,927 (3,103) 36.41% 23 PERS 12,615 9,461 4,466 (4,995) 35.40% 24 Industrial Insurance 2,734 2,051 643 (1,408) 23.52% 25 Medical, Dental, Life, Optical 12,321 9,241 6,800 (2,441) 55.19% 41 Professional Services 20,000 15,000 1,680 (13,320) 8.40% 48 Repairs & Maintenance - - 70,764 70,764 64 Capital Outlay 130,000 97,500 54,012 (43,488) 41.55% Total Gen Government Improve 290,794 218,096 179,595 (38,501) 61.76% Total Expenditures 290,794 218,096 179,595 (38,501) 61.76% Change in Fund Balance Beginning Fund Balance (90,294) (67,721) (28,508) 39,212 31.57% 334,349 334,349 391,903 57,554 117.21% Ending Fund Balance $ 244,055 $ 266,629 $ 363,395 $ 96,766 148.90% Cash and investments $ 366,450 ** Variance = Actual over (under) prorated budget Fund 303 79 City of Tukwila Fire Impact Fees 304 - Revenue and Expenditures As of September 30 2017 % of year expired 75.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance ** Budget Revenue Charges for Services Fire Impact Fees Total Charges for Services Investment Earnings Total Miscellaneous Revenue $ 32,000 $ 24,000 $ 276,734 $ 252,734 864.79% 32,000 24,000 276,734 252,734 864.79% 100 75 1,143 1,068 1143.36% 100 75 1,143 1,068 1143.36% Total Revenue 32,100 24,075 277,877 253,802 865.66% Total Expenditures Change in Fund Balance 32,100 Beginning Fund Balance 645,631 24,075 277,877 645,631 736,518 253,802 865.66% 90,887 114.08% Ending Fund Balance $ 677,731 $ 669,706 $ 1,014,395 $ 344,689 149.68% Cash and investments $ 1,014,395 ** Variance = Actual over (under) prorated budget Fund 304 80 City of Tukwila Public Safety Plan 305 - Revenue and Expenditures As of September 30 2017 % of year expired 75.00% 2017 Annual Budget Prorated Budget Actual Year -To -Date Variance ** % of Annual Budget Revenue General Revenue: Mitigation Fees (Tukwila South) Miscellaneous Revenue Investment Earnings Bond proceeds Total Miscellaneous Revenue $ 500,000 $ 375,000 $ $ - 23,343,000 $ - 17,507,250 23,343,000 17,507,250 $ 64,453 $ (500,000) $ 64,453 (17,507,250) 64,453 (17,442,797) 0.28% Total Revenue 23,843,000 17,882,250 64,453 (17,942,797) 0.27% Expenditures 35 Small Tools & Minor Equipment 41 Professional Services 64 Capital Outlay Total Gen Government Improve Transfers Out Total Expenditures 2,588,000 1,941,000 11,139,000 8,354,250 13, 727, 000 10, 295, 250 460,000 345,000 61,101 362,015 61,101 (1,941,000) (7,992,235) 423,116 (9,872,134) (345,000) 3.25% 3.08% 14,187,000 10,640,250 423,116 (10,217,134) 2.98% Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments 9,656,000 7,242,000 (358,663) (7,725,663) - - 36,513,127 36,513,127 -3.71% $ 9,656,000 $7,242,000 $ 36,154,464 $ 28,787,464 374.42% ** Variance = Actual over (under) prorated budget Fund 305 $ 36,154,275 81 City of Tukwila City Facilities 306 - Revenue and Expenditures As of September 30 2017 % of year expired 75.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance ** Budget Revenue Miscellaneous Revenue Bond proceeds Total Miscellaneous Revenue 6,150,000 4,612,500 6,150,000 4,612,500 (4,612,500) (4,612,500) Total Revenue 6,150,000 4,612,500 (4,612,500) Expenditures 41 Professional Services 64 Capital Outlay Total Gen Government Improve 150,000 112,500 6,000,000 4,500,000 6,150,000 4,612,500 142,027 142,027 (112,500) (4,357,973) 2.37% (4,470,473) 2.31% Total Expenditures 6,150,000 4,612,500 142,027 (4,470,473) 2.31% Change in Fund Balance Beginning Fund Balance (142,027) (142,027) Ending Fund Balance $ $ $ (142,027) $ (142,027) Cash and investments $ (142,027) ** Variance = Actual over (under) prorated budget Fund 306 82 City of Tukwila Water Fund 401 - Revenue and Expenditures As of September 30 2017 % of year expired 75.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance ** Budget Revenue Charges for Services Water Sales $ 6,858,000 $ 5,143,500 $ 5,330,424 $ 186,924.01 Security 1,000 750 300 (450) Total Charges for Services 6,859,000 5,144,250 5,330,724 186,474 Miscellaneous Revenue Investment Earnings Connection Fees Other Misc Revenue Total Miscellaneous Revenue Sale of Capital Assets 21,000 15,750 29,291 13,541 25,000 18,750 155,834 137,084 - - 3,984 3,984 46,000 34,500 189,109 77.73% 30.00% 77.72% 139.48% 623.34% 154,609 411.11% 4 4 Total Revenue 6,905,000 5,178,750 5,519,837 341,087 79.94% Operating Expenses 11 Salaries 589,968 442,476 411,621 (30,855) 69.77% 12 Extra Labor 4,000 3,000 - (3,000) 13 Overtime 7,000 5,250 4,576 (674) 65.37% 21 FICA 45,855 34,391 32,248 (2,143) 70.33% 23 PERS 70,837 53,128 48,597 (4,530) 68.60% 24 Industrial Insurance 20,507 15,380 10,185 (5,196) 49.66% 25 Medical, Dental, Life, Optical 119,295 89,471 88,343 (1,128) 74.05% 28 Uniform Clothing 1,330 998 - (998) 31 Office & Operating Supplies 144,300 108,225 98,001 (10,224) 67.91% 33 Water Purchased for Resale 2,610,000 1,957,500 2,130,220 172,720 81.62% 35 Small Tools & Minor Equipment 11,000 8,250 1,619 (6,631) 14.72% 41 Professional Services 9,500 7,125 908 (6,217) 9.55% 42 Communication 2,500 1,875 1,520 (355) 60.82% 43 Travel 1,500 1,125 707 (418) 47.11% 45 Operating Rentals & Leases 183,381 137,536 136,411 (1,125) 74.39% 46 Insurance 14,853 11,140 14,853 3,713 100.00% 47 Public Utility Services 24,400 18,300 13,530 (4,770) 55.45% 48 Repairs & Maintenance 17,096 12,822 9,003 (3,819) 52.66% 49 Miscellaneous 37,000 27,750 41,036 13,286 110.91% 53 Excise Taxes 280,000 210,000 212,009 2,009 75.72% 54 Interfund utility taxes 688,000 516,000 533,136 17,136 77.49% Total Operating Expenses 4,882,322 3,661,742 3,788,521 126,780 77.60% Capital Expenses 64 Capital Outlay 3,195,000 2,396,250 1,892,925 (503,325) 59.25% 80 Debt Service Principal 132,334 99,251 95,080 (4,171) 71.85% 81 Debt Service Interest 15,881 11,911 8,447 (3,464) 53.19% Total Capital Expenses 3,343,215 2,507,411 1,996,452 (510,960) 59.72% Indirect cost allocation Total Expenses 616,053 462,040 462,040 - 75.00% 8,841,590 6,631,193 6,247,013 (384,180) 70.65% Change in Fund Balance (1,936,590) (1,452,443) (727,176) 725,267 37.55% Beginning Fund Balance 4,178,561 4,178,561 6,692,750 2,514,189 160.17% Ending Fund Balance $ 2,241,971 $ 2,726,119 $ 5,965,574 $ 3,239,456 266.09% Cash and investments $ 5,731,687 ** Variance = Actual over (under) prorated budget Fund 401 83 City of Tukwila Sewer Fund 402 - Revenue and Expenditures As of September 30 2017 % of year expired 75.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance ** Budget Revenue Charges for Services Sewer Sales Total Charges for Services Miscellaneous Revenue Investment Earnings Connection fees Total Miscellaneous Revenue $ 8,524,000 $ 6,393,000 $ 7,274,680 $ 881,680 85.34% 8,524,000 6,393,000 7,274,680 881,680 85.34% 25,000 18,750 34,940 16,190 139.76% 125,000 93,750 286,533 192,783 229.23% 150,000 112,500 321,473 208,973 214.32% Total Revenue 8,674,000 6,505,500 7,596,153 1,090,653 87.57% Operating Expenses 11 Salaries 355,341 266,506 220,468 (46,037) 62.04% 13 Overtime 4,442 3,332 1,688 (1,644) 38.00% 21 FICA 27,483 20,612 17,070 (3,542) 62.11% 23 PERS 42,668 32,001 26,030 (5,971) 61.01% 24 Industrial lnsurance 12,304 9,228 5,093 (4,135) 41.40% 25 Medical, Dental, Life, Optical 71,620 53,715 58,339 4,624 81.46% 28 Uniform Clothing 570 428 - (428) 31 Office & Operating Supplies 21,600 16,200 8,023 (8,177) 37.14% 33 Metro Sewage Treatment 4,200,000 3,150,000 3,404,140 254,140 81.05% 35 Small Tools & Minor Equipment 2,500 1,875 1,435 (440) 57.40% 41 Professional Services 2,600 1,950 3,075 1,125 118.25% 42 Communication 2,500 1,875 480 (1,395) 19.21% 43 Travel 2,000 1,500 2,076 576 103.80% 44 Advertising 150 113 - (113) 45 Operating Rentals & Leases 103,926 77,945 76,453 (1,492) 73.56% 46 Insurance 4,952 3,714 4,952 1,238 100.00% 47 Public Utility Services 38,000 28,500 26,112 (2,388) 68.71% 48 Repairs & Maintenance 49,000 36,750 12,268 (24,482) 25.04% 49 Miscellaneous 55,000 41,250 38,411 (2,839) 69.84% 53 Excise Taxes 135,000 101,250 101,636 386 75.29% 54 Interfund utility tax 855,000 641,250 727,577 86,327 85.10% Transfers Out 5,986,656 4,489,992 4,735,326 245,334 79.10% Capital Expenses 64 Capital Outlay 4,353,500 3,265,125 1,491,038 (1,774,087) 34.25% 80 Debt Service Principal 322,271 241,703 233,436 (8,267) 72.43% 81 Debt Service Interest 36,794 27,596 22,574 (5,021) 61.35% Total Capital Expenses 4,712,565 3,534,424 1,747,048 (1,787,376) 37.07% Indirect cost allocation 469,302 351,977 351,977 Total Expenses 11,168,523 8,376,392 6,834,351 (1,542,042) Change in Fund Balance (2,494,523) (1,870,892) 761,803 2,632,695 Beginning Fund Balance 9,009,091 9,009,091 7,826,985 (1,182,106) Ending Fund Balance $ 6,514,568 $ 7,138,199 $ 8,588,788 $ 1,450,589 Cash and investments $ 7,773,295 ** Variance = Actual over (under) prorated budget Fund 402 84 75.00% 61.19% -30.54% 86.88% 131.84% City of Tukwila Foster Golf Course 411- Revenue and Expenditures As of September 30 2017 % of year expired 75.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance ** Budget Revenue General Revenue Excise Taxes Total General Revenue Charges for Services Sale of Merchandise Greens Fees, Instruction Total Charges for Services $ 3,900 $ 2,925 $ 1,522 $ (1,403) 39.04% 3,900 2,925 1,522 (1,403) 39.04% 151,000 113,250 107,458 (5,792) 71.16% 1,095,650 821,738 825,430 3,693 75.34% 1,246,650 934,988 932,888 (2,100) 74.83% Miscellaneous Revenue Investment Earnings 1,000 750 2,235 1,485 223.55% Rents and Concessions 306,000 229,500 227,403 (2,097) 74.31% Other Misc Revenue 7,000 5,250 7,965 2,715 113.79% Total Miscellaneous Revenue 314,000 235,500 237,603 2,103 75.67% Transfers In 300,000 225,000 225,000 - 75.00% Total Revenue 1,864,550 1,398,413 1,397,014 (1,399) 74.92% Expenses 11 Salaries 603,021 452,266 411,831 (40,435) 68.29% 12 Extra Labor 112,000 84,000 92,702 8,702 82.77% 13 Overtime 2,040 1,530 1,612 82 79.01% 21 FICA 55,680 41,760 38,009 (3,751) 68.26% 23 PERS 75,399 56,549 55,434 (1,115) 73.52% 24 Industrial Insurance 26,475 19,856 16,458 (3,398) 62.17% 25 Medical, Dental, Life, Optical 141,258 105,944 100,691 (5,253) 71.28% 26 Unemployment Compensation 6,120 4,590 1,438 (3,152) 23.50% 28 Uniform Clothing 1,187 890 379 (511) 31.93% 31 Office & Operating Supplies 102,815 77,111 104,365 27,253 101.51% 34 Items Purchased for Resale 96,600 72,450 75,918 3,468 78.59% 35 Small Tools & Minor Equipment 4,000 3,000 5,361 2,361 134.02% 41 Professional Services 9,400 7,050 3,281 (3,769) 34.90% 42 Communication 5,671 4,253 4,330 77 76.35% 43 Travel 500 375 - (375) - 44 Advertising 4,000 3,000 5,461 2,461 136.52% 45 Operating Rentals & Leases 146,160 109,620 110,645 1,025 75.70% 46 Insurance 20,424 15,318 20,424 5,106 100.00% 47 Public Utility Services 63,400 47,550 53,730 6,180 84.75% 48 Repairs & Maintenance 39,000 29,250 60,130 30,880 154.18% 49 Miscellaneous 38,500 28,875 37,086 8,211 96.33% 53 Excise Taxes 6,400 4,800 4,539 (261) 70.93% 54 Interfund admissions tax 60,000 45,000 41,670 (3,330) 69.45% 64 Capital Outlay 50,000 37,500 16,043 (21,457) 32.09% Total Foster Golf Course Fund 1,670,050 1,252,538 1,261,535 8,998 75.54% Indirect cost allocation 180,899 135,674 135,674 0 75.00% Total Expenses 1,850,949 1,388,212 1,397,210 8,998 75.49% Change in Fund Balance 13,601 10,201 (196) (10,397) -1.44% Beginning Fund Balance 23,174 23,174 117,982 94,808 509.11% Ending Fund Balance $ 36,775 $ 33,375 $ 117,786 $ 84,411 320.29% Cash and investments $ 787,496 ** Variance = Actual over (under) prorated budget Fund 411 85 City of Tukwila Surface Water Fund 412 - Revenue and Expenditures As of September 30 2017 % of year expired 75.00% 2017 Prorated Actual Annual Annual Budget Budget Year -To -Date Variance ** Budget Revenue Charges for Services Surface Water Sales Total Charges for Services Intergovernmental Revenue $ 6,133,000 $ 4,599,750 $ 6,149,268 $1,549,518 100.27% 6,133,000 4,599,750 6,149,268 1,549,518 100.27% 1,256,000 942,000 (942,000) Miscellaneous Revenue Investment Earnings 24,000 18,000 28,110 10,110 117.12% Other Misc Revenue - - 120 120 - Total Miscellaneous Revenue 24,000 18,000 28,230 10,230 117.62% Total Revenue 7,413,000 5,559,750 6,177,498 617,748 83.33% Operating Expenses 11 Salaries 1,007,855 755,891 499,852 (256,040) 49.60% 12 Extra Labor 8,000 6,000 2,490 (3,510) 31.13% 13 Overtime 9,000 6,750 4,050 (2,700) 45.00% 21 FICA 78,048 58,536 38,753 (19,783) 49.65% 23 PERS 121,038 90,779 58,448 (32,330) 48.29% 24 Industrial Insurance 31,798 23,849 10,574 (13,275) 33.25% 25 Medical, Dental, Life, Optical 236,299 177,224 120,082 (57,142) 50.82% 28 Uniform Clothing 1,425 1,069 225 (844) 15.79% 31 Office & Operating Supplies 41,500 31,125 17,298 (13,827) 41.68% 35 Small Tools & Minor Equipment 5,000 3,750 2,086 (1,664) 41.71% 41 Professional Services 3,600 2,700 4,108 1,408 114.11% 42 Communication 2,000 1,500 1,381 (119) 69.05% 43 Travel 2,000 1,500 1,139 (361) 56.95% 44 Advertising 500 375 - (375) - 45 Operating Rentals & Leases 332,620 249,465 248,125 (1,340) 74.60% 46 Insurance 22,279 16,709 22,278 5,569 100.00% 47 Public Utility Services 107,000 80,250 20,756 (59,494) 19.40% 48 Repairs & Maintenance 36,572 27,429 5,228 (22,201) 14.30% 49 Miscellaneous 23,500 17,625 20,247 2,622 86.16% 53 Excise Taxes 50,000 37,500 56,448 18,948 112.90% 54 Interfund utility tax 618,000 463,500 616,444 152,944 99.75% Total Operating Expenses 2,738,034 2,053,526 1,750,012 (303,514) 63.91% Capital Expenses 64 Capital Outlay 4,573,500 3,430,125 856,959 (2,573,166) 18.74% 80 Debt Service Principal 288,148 216,111 270,953 54,842 94.03% 81 Debt Service Interest 15,659 11,744 12,907 1,163 82.43% Total Capital Expenses 4,877,307 3,657,980 1,140,819 (2,517,161) 23.39% Indirect Cost Allocation Total Expenses Change in Fund Balance Beginning Fund Balance 518,528 388,896 388,896 0 75.00% 8,133,869 6,100,402 3,279,726 (2,820,675) 40.32% (720,869) (540,652) 2,897,771 3,438,423 401.98% 4,273,828 4,273,828 2,602,903 (1,670,925) 60.90% Ending Fund Balance $ 3,552,959 $ 3,733,176 $ 5,500,674 $1,767,498 154.82% Cash and investments $ 5,843,512 ** Variance = Actual over (under) prorated budget Fund 412 86 City of Tukwila Equipment Rental/Replacement Fund 501 As of September 30 2017 Revenue and Expenditures % of year expired 75.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance ** Budget Revenue Charges for Services ERR O&M Dept Charges $ 1,946,304 $ 1,459,728 $ 1,455,228 $ (4,500) 74.77% Equipment Replacement Charges 690,596 517,947 517,947 0 75.00% Transportation 150 113 - (113) Total Charges for Services 2,637,050 1,977,788 1,973,175 (4,612) 74.83% Miscellaneous Revenue Investment Earnings 14,269 10,702 29,189 18,487 204.56% Other Misc Revenue - - 300 300 Total Miscellaneous Revenue 14,269 10,702 29,489 18,788 206.67% Sale of Capital Assets 30,000 22,500 5,811 (16,689) 19.37% Transfers In 460,000 345.000 (460,000) Total Revenue 3,141,319 2,355,989 2,008,476 (462,514) 63.94% Expenses 11 Salaries 384,003 288,002 283,575 (4,427) 73.85% 12 Extra Labor 15,000 11,250 8,736 (2,514) 58.24% 13 Overtime 1,858 1,394 - (1,394) 21 FICA 30,344 22,758 22,020 (738) 72.57% 23 PERS 46,100 34,575 34,161 (414) 74.10% 24 Industrial Insurance 14,851 11,138 7,447 (3,691) 50.15% 25 Medical, Dental, Life, Optical 99,899 74,924 74,540 (384) 74.62% 28 Uniform Clothing 950 713 431 (282) 45.34% 31 Office & Operating Supplies 3,000 2,250 2,755 505 91.82% 34 Items Purchased for Resale 750,000 562,500 390,278 (172,222) 52.04% 35 Small Tools & Minor Equipment 5,000 3,750 2,841 (909) 56.81% 41 Professional Services 1,750 1,313 2,302 990 131.57% 42 Communication 2,000 1,500 1,042 (458) 52.12% 43 Travel 1,500 1,125 420 (705) 27.98% 45 Operating Rentals & Leases 77,227 57,920 57,869 (51) 74.93% 46 Insurance 65,574 49,181 66,567 17,387 101.51% 48 Repairs & Maintenance 120,000 90,000 45,140 (44,860) 37.62% 49 Miscellaneous 12,000 9,000 11,132 2,132 92.76% 53 Ext Taxes & Operating Assessme - - 1 1 64 Capital Outlay 1,999,000 1,499,250 387,385 (1,111,865) 19.38% Total Equipment Rental Fund 3,630,056 2,722,542 1,398,643 (1,323,899) 38.53% Indirect Cost Allocation Total Expenses 322,910 242,183 242,183 - 75.00% 3,952,966 2,964,725 1,640,826 (1,323,899) 41.51% Change in Fund Balance Beginning Fund Balance (811,647) (608,735) 367,650 861,385 -45.30% 5,592,380 5,592,380 4,393,334 (1,199,046) 78.56% Ending Fund Balance $ 4,780,733 $ 4,983,645 $ 4,760,984 $ (337,661) 99.59% Cash and investments $ 5,095,767 ** Variance = Actual over (under) prorated budget Fund 501 87 City of Tukwila Insurance Fund 502 - Revenue and Expenditures As of September 30 2017 % of year expired 75.00% 2017 Annual Prorated Year -To - Budget Budget Date Variance ** of Annual Budget Revenue Charges for Services Employee Benefit Programs $ 1,200 $ 900 $ 1,281 $ 381 106.73% Total Charges for Services 1,200 900 1,281 381 106.73% Miscellaneous Revenue Investment Earnings 96,000 72,000 73,199 1,199 76.25% Employer Trust Contributions 5,999,527 4,499,645 4,304,813 (194,833) 71.75% Employee Contributions 77,000 57,750 88,697 30,947 115.19% Total Miscellaneous Revenue 6,172,527 4,629,395 4,466,709 (162,686) 72.36% Total Revenue 6,173,727 4,630,295 4,467,990 (162,306) 72.37% Expenses 25 Medical, Dental, Life, Optical 6,662,500 4,996,875 4,523,323 (473,552) 67.89% 41 Professional Services 32,000 24,000 22,852 (1,148) 71.41% 49 Miscellaneous 25,000 18,750 5,283 (13,467) 21.13% Total 6,719,500 5,039,625 4,551,458 (488,167) 67.74% Indirect cost allocation 123,117 Total Expenses 92,338 92,338 - 75.00% 6,842,617 5,131,963 4,643,796 (488,167) 67.87% Change in Fund Balance Beginning Fund Balance (668,890) 1,175, 682 (501,668) 1,175,682 (175,806) 325,861 26.28% 1,494,823 319,141 127.15% Ending Fund Balance $ 506,792 $ 674,015 $ 1,319,017 $ 645,002 260.27% Cash and investments $ 3,153,352 ** Variance = Actual over (under) prorated budget Fund 502 88 City of Tukwila LEOFF Insurance Fund 503 - Revenue and Expenditures As of September 30 2017 % of year expired 75.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance ** Budget Revenue Miscellaneous Revenue Investment Earnings $ 3,340 $ 2,505 $ 700 $ (1,805) Employer Trust Contributions 265,000 198,750 190,872 (7,878) Total Miscellaneous Revenue 268,340 201,255 191,572 (9,683) 20.95% 72.03% 71.39% Total Revenue 268,340 201,255 191,572 (9,683) 71.39% Expenses 25 Medical, Dental, Life, Optical 575,250 431,438 315,310 (116,127) 54.81% 41 Professional Services 18,000 13,500 3,510 (9,990) 19.50% 49 Miscellaneous 500 375 - (375) - Total 593,750 445,313 318,820 (126,492) 53.70% Indirect Cost Allocation 12,549 9,412 9,412 75.00% Total Expenses 606,299 454,724 328,232 (126,492) 54.14% Change in Fund Balance (337,959) (253,469) (136,660) 116,809 40.44% Beginning Fund Balance 1,210,204 1,210,204 882,478 (327,726) 72.92% Ending Fund Balance $ 872,245 $ 956,735 $ 745,818 $ (210,917) 85.51% Cash and investments $ 937,068 ** Variance = Actual over (under) prorated budget Fund 503 89 90 2017 3rd Quarter Financial Report City of Tukwila November 13, 2017 3rd Quarter Financial Highlights ■ Departmental budgets (in total) within budget. Revenues, $42.28 Expenditures, $42.90 20 $25 $30 35 $40 45 November 13, 2017 2017 3rd Quarter Financial Report Millions 2 • General Fund Revenue ■ Sales tax below budget by $1.14 million ■ Not experiencing growth as budgeted, 1St and 2nd quarter revenue consistent with previous year ■ 3rd quarter saw decline in revenue compared to 2016 ■ Year over year declines by NAICS category ■ Manufacturing down $55 thousand, or 26% ■ Wholesale down $300 thousand, or 27% ■ General Retail down $98 thousand, or 1% ■ Services down $137 thousand, or 3% ■ Other NAICS categories either flat or slightly up November 13, 2017 2017 3rd Quarter Financial Report General Fund Revenue ■ Gambling tax exceeding budget by $241 thousand. ■ RGRL fee below budget by $147 thousand. Major employer shifted employees out of city. ■ Security (Court) below budget by $52 thousand, changes in law require ability to pay to be considered before imposing cost. ■ Transportation below budget by $58 thousand, less damage to City property occurring. November 13, 2017 2017 3rd Quarter Financial Report • Overall, Expenditures Within Budget ■ Excluding Dept. 20, expenditures are at 71% of allocated budget. ■ All departments except for Fire, Technology & Innovation Services, and Parks Maintenance are below allocated budget. ■ Fire Department only department expected to require budget amendment. ■ Department 20 transfers to capital project funds only as needed. November 13, 2017 2017 3rd Quarter Financial Report 5 Highlights of Other Funds ■ 42nd Ave S Phase 111, 53rd Ave S street projects: $8.8 million bond proceeds received in July. ■ REET revenue exceeding budget: $873 thousand each in land acquisition and arterial street funds. ■ City Facilities (fund 306): preliminary siting for Public Works shops. ■ Andover Park E water/sewer main replacement project: significant work in both water and sewer funds. ■ Through September, self-insured healthcare for employee expenses at 67% of budget. November 13, 2017 2017 3rd Quarter Financial Report • Looking Forward ■ Continued regular monitoring of Fire department. ■ Transfers to capital projects funds if needed. ■ Continued enhancement of reporting to departments and Council. ■ Long-range financial planning tool coming soon. November 13, 2017 2017 3rd Quarter Financial Report November 13, 2017 Q&A The city of opportunity, the community of choice. 2017 3rd Quarter Financial Report 8 • Preliminary Projected Year -End General Fund J Projected Revenue $61,931,082 Expenditure 61, 770, 909 Change in Fund Balance $160,174 ■ Represents a conservative projection. November 13, 2017 2017 3rd Quarter Financial Report 9