The URL can be used to link to this page

Home My WebLink AboutCOW 2017-08-28 Item 4D - Report - 2017 2nd Quarter Financial ReportCOUNCIL AGENDA SYNOPSIS ------ ---------------------- Meeting Date Prepared by Mayor's review Council review 08/28/17 VC ❑ Motion ditg Date i1_.. ❑ Ordinance Aftg Dale ❑ Bid Award Mtg Date ❑ Public Hearing Mtg Date ❑ Other Mfg Date C.t"['iSC; RY r1 Discussion elitg Date SPONSOR ❑Council ❑:1fcgor ❑HR ❑DCD ElFinance •Fire ❑TS DP&R ❑Police . Pr UCourt SPONS( )R'S Review of the 2017 Financial Status Report SUMMARY REV IEWr':D BY ❑ C.O.W. Mtg. ❑ CDN Comm ❑ Trans &Infrastructure ❑ Arts Comm. DATE: 8/22/17 !1 Finance Comm. ❑ Public Safety Comm. Comm. [] Planning Comm. CHAIR: SEAL ❑ Parks COMMITTEE ITEM INFORMATION ITEM No. 4.D. 61 S'I'AIT SPONSOR: VICKY CARLSEN ORIGINAL AGENDA DATE: 8/28/17 AGENDA I'IT,PVI TITLE 2ND Quarter 2017 Financial Status Report 8/28/17 ❑ Motion ditg Date ❑ Resolution AN Date ❑ Ordinance Aftg Dale ❑ Bid Award Mtg Date ❑ Public Hearing Mtg Date ❑ Other Mfg Date C.t"['iSC; RY r1 Discussion elitg Date SPONSOR ❑Council ❑:1fcgor ❑HR ❑DCD ElFinance •Fire ❑TS DP&R ❑Police . Pr UCourt SPONS( )R'S Review of the 2017 Financial Status Report SUMMARY REV IEWr':D BY ❑ C.O.W. Mtg. ❑ CDN Comm ❑ Trans &Infrastructure ❑ Arts Comm. DATE: 8/22/17 !1 Finance Comm. ❑ Public Safety Comm. Comm. [] Planning Comm. CHAIR: SEAL ❑ Parks COMMITTEE RECOMMENDATIONS: SPONSOR/ADMIN. COMM Finance I ITEF: Forward to 8/28 C.O.W. Meeting COST IMPACT / FUND SOURCE EXPENDITURE REQUIRI,D AMOUNT BUDGETED APPROPRIATION REQUIRED $ $ Fund Source: Comments: MTG. DATE RECORD OF COUNCIL ACTION MTG. DATE ATTACHMENTS 8/28/17 Informational Memorandum dated 8/8/17 2017 2nd QuarterFinancial Report Powerpoint presentation Minutes from Finance Committee meeting of 8/22/17 61 62 City of Tukwila INFORMATIONAL MEMORANDUM TO: Councilmembers CC: Mayor Ekberg FROM: Peggy McCarthy, Finance Director BY: Craig Zellerhoff, Fiscal Coordinator DATE: August 8, 2017 SUBJECT: 2017 2' 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 second quarter status report is based on financial data available as of August 7th, 2017 for the reporting period ending June 30, 2017. Revenues are below allocated budget by $737 thousand and expenditures are below budget by $2.81 million. Revenues Expenditures General Fund 2017 Revenues vs Expenditures (Through June 2017) Actual $31.50 Budget Actual $28.43 Budget $26 $27 828 $29 $30 $31.24 $32.23 $31 $32 $33 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. 63 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. ss W6 $4 53 62 $1 50 General Fund Rolling 14 month Revenue and Expense Summary 1dulrlIIE1Iblt1Iii:iIh....111 1 Map -16 Jun -16 Jul -16 Aug -16 Sep -16 Oct -16 Nov -16 Dec -16 Jan -17 17 Mar -17 Apr -17 May -17 Jun -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. 64 INFORMATIONAL MEMO Page 3 Revenues Through June 2017, general fund revenues totaled $31.50 million compared to an allocated budget of $32.23 million and were $834 thousand higher than revenues collected for the same period in 2016. Notable variances to budget for the first quarter include: Property Taxes Sales & Use Taxes Admissions Tax Utility Tax Interfund Utility Tax Gambling & Excise Tax Licenses and Permits Intergovernmental Charges for Services Fines & Penalites Misc Indirect Cost Allocation Tukwila Village Year -to -Date General Fund Revenues Compared to Budget (Through June 2017) 57, 872 58,021 a$375 5387 $2,217 52 168 51,062 51,018 51,967 51,808 53,176 53,281 52,664 $2,634 $956 51,146 15116 5109 $500 5476 $1,140 51,140 50 50 50 $2,000 54,000 $6,000 58,000 • Year to Date • Budget 9 454 510,048 510.000 $12,000 Thousands • Sales and use taxes, which includes local retail sales and use tax, natural gas tax, and criminal justice sales tax, totaled $9.46 million, which is below budget by $594 thousand and is lower in collections for the same period last year by $21 thousand. • Gambling and excise taxes through the end of June totaled $1.97 million and exceed allocated budget by $158 thousand. • RGRL fees which are reported on the Licenses and Permits line is $140 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 $70 thousand below budget. • Property tax collections are $149 thousand below budget through June. 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. 65 INFORMATIONAL MEMO Page 4 Expenditures General fund expenditures through the end of June 2017 totaled $28.4 million as compared to an allocated budget of $31.2 million, which is $2.8 million below budget. Notable variances are as follows - Year to Date Department Expenditures Compared to Allocated Budget. (Through June 2017) Cry 1"ouncr III 5169 5197 Mayor Human Resources 5324 5376 Finance Attorney 15215 5303 Recreation Community Dev Municipal Court IM 5596 5640 Police Fi re Tech & innovation Public Works Parts Maintenance Street Maui & Ops Dept 20 Si 766 51.840 51,330 51.524 $1.486 51 519 51 .607 S1.786 5781 5846 $1.774 51 .869 l' 5684 _ $628 =1151 459 51.597 51.493 52,821 55.947 55.858 58.799 59.421 50 St 000 52.000 53.000 54 000 55.000 56 000 57 000 58 000 59,000 510 000 Thousands ■Year to Dale • ^,dincated 8+rdgel • Fire department has exceeded budget by $79 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 three thousand year-to-date. Additionally, $41 thousand for bunker gear will be moved from the fire department expenditures to the public safety play. Bunker gear is equipment identified to be paid for by the voter approved bond. • Park department has exceeded budget by $56 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. 66 INFORMATIONAL MEMO Page 5 Fund Summary The chart below is a summary of ending balances for each of the fund types as of June 31,2017. Fund Summary General Special Revenue Capital Projects Enterprise Internal Service Debt Beginning Fund Balance 17,890260 1,466,097 45,947,009 17240,620 6770,635 1,292,357 Revenues 31,513,794 315760 4,173,403 11,690,686 4,463,647 1277256 E renditures (28.430,680) (187,100) (3,568,389) (11.248,837) (4,093223) (595.021) Ending Fund Balance 20,973,374 1,594,757 46,552,023 17,682,469 7,140,959 2,074,592 Genera I/Continpenc General Fund General Contingency Beginning Fund Balance 11839,636 6,050.624 Rewnues 31,498,013 15.781 Evenditures (28,430.680) - Ending Fund Balance 14,906,969 6866,405 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 June 2017, revenues exceeded expenditures in the Lodging tax fund. Expenditures for the Seizure fund are greater than revenue by $92 thousand. In 2017 expenditures in the Seizure fund will exceed revenues due to arnounts received in 2016 from the Motel raid in 2013. Special Revenue Funds Lodging Tax Seizure Beginning Fund Balance 912,558 553,539 Revenues 284,726 31,034 Expenditures (63,904) (123,195) Ending Fund Balance 1,133,379 461,378 67 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 liesidential Streets arteerlei Streets Land kq, F ec, � Park Des, Faciity Replacement Gee Govt lmprowments Fre Impact Fees Public Safety Plan QF9c ilkies Beginning Fund Balance 658,932 3,999.376 3,352,113 295,040 391,993 736,518 36513.127 - Retienues 178,535 3,058.670 672,331 1281 541 225.595 36.450 Evendilures (340.665) (2,729.685) (148,044) (15663) (95,173) - (159,949) (79,210) BdingfundBalance 496,802 4,328,361 3676,400 280658 297,271 962,113 36,389,628 (79,210) Residential Streets: Major projects include 42nd Ave S Phase Ili and 53rd Ave S street improvement projects. Through June, $208 thousand has been spent on 42"d Ave and 53rd had expenditures of $99 thousand. Bonds of $8.8 million were issued in July. Arterial Streets: Through June 2017, major projects in the arterial street fund include the TUC Pedestrian/Bicycle Bridge project, which had expenditures of $1.8 million and S 144th St Phase II which had expenditures of $367 thousand. Several other projects had activity as well during the first half of the year. Additionally, the arterial streets fund has received $626 thousand in REET and $1.6 million from WSDOT for the regional mobility grant. Land Acq, Recreation & Parks Development: Through June, $626 thousand in REET revenue has been received. Just under $71 thousand has been spent on the Duwamish Hill Preserve project and $51 thousand on the Duwamish Gardens project. Public Safety Plan: Just under $160 thousand has been spent through June on preliminary work on fire stations and the justice center. City Facilities: Through June, $79 thousand has been spent on preliminary siting for the Public Works shops facility. Budgeted revenue for this fund is bond proceeds. It is unlikely that bonds will be sold in 2017 so an operating transfer to cover these costs will need to be included in the 2017 budget amendments. 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 2,983,837 4,923,204 690,367 3,093,278 Expenditures (3,861,017) (4,481,751) (875,360) (2,030,709) Ending Fund Balance 5,815,569 8,268,437 (67,011) 3,665,472 Water: Through June, $1.2 million has been spent on the Andover Pk E Water Main Replacement project. Sewer: Through June, $850 thousand has been spent on the Andover Pk E Water Main Replacement project. 68 INFORMATIONAL MEMO Page 7 Surface Water: Revenue through June is at $3.1 million, or 42% of budget while expenses are at $2 million, or 25% of budget. Revenue for the golf course is weather dependent and is typically lower during the winter months while expenditures remain consistent throughout the year. Internal Service Funds Internal service funds provide services to other City departments and include functions such as employee and LEOFF 1 retiree medical insurance as well as equipment rental and replacement. Through the end of June, all internal service funds have sufficient funds to meet expenses. 69 Self Insured ' Self Insured internal Service Funds Fleet Healthcare - Healthcare - Actives Retirees Beginning Fund Balance 4,393,334 1494,823 882,478 Revenues 1,344,283 2,990,029 129,335 Expenditures (968,046) (2 942,467) (182,810) Ending Fund Balance 4,769,571 1,542,385 829,003 69 70 GENERAL FUND CITY OF TUKWILA GENERAL FUND REVENUES YTD AS OF JUNE 30, 2017 8114/2017 9:28 SUMMARY BY REVENUE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 2017 ANNUAL ALLOCATED 2015 2016 2017 OVER!(UNOER) % CHANGE ALLOCATED EMT % RECD 2016/2016 2016/2017 PROPERTY TAX 14,906,636 8,020.893 7,576.868 7,799.265 7,872,347 (148,546) 53% 3% 1% SALES TAX 20,026,555 10,047.904 9,139,292 9,474,472 9,453,723 (594,181) 47% 4% (0)% ADMISSIONS TAX 760,000 386.923 310,399 352,284 375,163 (11,760) 49% 13% 614 UTILITY TAX 4,118,053 2,167,995 2,057,472 2,122,520 2,217,480 49,484 54% 3% 496 INTERFUND UTILITY TAX 2,161,000 1,017,711 962,210 1,012,244 1,061,752 44,041 49% 5% 514 GAMBLING & EXCISE TAX 3,931,400 1,808,350 1,440,159 1,745,709 1.966,648 158,298 50% 2154 13% TOTAL GENERAL REVENUE 45,903,644 23,449,775 21,486,402 22,506,495 22,947,111 (502,664) 50% 5% 2% RGRL 1.900,000 1,860,475 1,810,512 1,771,925 1.720,487 (139,988) 91% (2)% (3)% BUSINESS LICENSES 873,640 658,985 637,722 614,366 603,962 (55,023) 69°% (4)% (2)% RENTAL HOUSING 45,000 36,353 38,600 36,830 40,570 4,217 90% (5)% 10% BUILDING PERMITS 1,389,600 724,923 718,252 674,976 811,024 86,101 58% (6)14 20% TOTAL LICENSES AND PERMITS 4,208,240 3,280,736 3,205,086 3,098,097 3,176,043 (104,693) 75% (3)% 3% SALES TAX MITIGATION 1,140,000 575.798 586,433 566,726 551,309 (24,489) 48% 0% (3)% FRANCHISE FEE 2,199,500 1,180,714 1,107,245 1,123,539 1,111,149 (69,566) 51% 1% (1)0% GRANT 553,591 164,214 152,019 197,973 327,514 1 163,300 5954 3036 65% STATE ENTITLEMENTS 416,533 214.799 182.212 153,438 223,694 8,895 54% (16)% 4614 INTERGOVERNMENTAL 553,626 498,475 25.934 53,309 449,859 (48,616) 81% 10654 744% TOTAL INTERGOVERNMENTAL REVENUE 4,663,250 2,634,000 2,033,843 2,094,985 2,663,525 29,525 55% 3% 27% GENERAL GOVERNMENT 35,265 17,832 29,313 18,417 21,915 4,083 62% (37)% 19% SECURITY 685,726 297.933 235.878 301,497 284,442 (13,491) 41% 28% (6)% TRANSPORTATION 109,000 37,962 3.045 22,550 6,281 (31.681) 6"% 641°% (72)% PLAN CHECK AND REVIEW FEES 905,090 516,225 684.688 478,369 382,039 (134.186) 42°% (30)% (20)% CULTURE AND REC FEES 636,840 276,183 266,781 301,410 261,199 (14,984) 41% 13% (13)% TOTAL CHARGES FOR SERVICES 2,371,921 1,146,135 1,219,704 1,122,242 955,877 (190,258) 40% (8)% (15)% FINES & PENALTIES 266,829 108,736 90,501 111,869 115,647 6.911 43% 24% 3% MISC 972,749 475,704 445,673 612,170 500,281 24,577 51°6 37% (18)% INDIRECT COST ALLOCATION 2,279,058 1,139.529 1,127.660 1,116,738 1,139,529 0 50% (1)0% 2"% TOTAL OTHER INCOME 3,518,636 1,723,969 1,663,833 1,840,777 1,755,457 31,488 145% 80% -13% TOTAL OPERATING REVENUE 60,865,691 32,234,615 29,608,869 30,662,595 31,498,013 (736,602) 5296 4% 3% TRANSFERS IN (TUKWLA VILLAGE) 1,800.000 - - - - - 0°% 0% 00% TOTAL REVENUE 62,665,691 32,234,615 29,608,869 30,662,595 31,496,013 (736,602) 50°4 414 314 71 GENERAL FUND CITY OF TUKWILA GENERAL FUND EXPENDITURES YTO AS OF JUNE 30, 2017 8114)2017 9:28 SUMMARY OF EXPENDITURES BY DEPARTMENT BUDGET ACTUAL COMPARISON OF RESULTS 1 26117 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVERI(UNDER) % CHANGE ALLOCATED BDGT % SPENT 201512016 2016/2017 01 City Council 366,016 197,419 162,493 169,503 168,933 (28,486) 46% 4% (0)% 03 Mayor 4,079,582 1,840,118 1,602,874 1,790,259 1,766,428 (73,690) 43% 12% (1)% 04 Human Resources 706,208 376,124 298,877 337,675 324,015 (52,109) 46% 13% (4)% 05 Finance 2,638,813 1,523,810 1,430,054 1,264,811 1,330,415 (193,394) 50% (12)% 5% 06 Attorney 716,955 302,677 248,509 224,271 215,424 (87,253) 30% (10)% (4)% 07 Recreation 3,384,688 1,518,803 1,345,985 1,429,881 1,485,518 (33,285) 44% 6% 4% 08 Community Development 3,693,338 1,788,207 1,421,224 1,539,530 1.607,468 (180,739) 44% 8% 4% 09 Municipal Court 1,307,808 639,574 547,139 571,555 595,773 (43,800) 46% 4% 4% 10 Police 18,288,092 9,420,630 8,604,677 9,101,296 8,799,247 (621,384) 48% 6% (3)°I° 11 Fire 11,862,568 5,868,026 5,806,447 5,637,308 5,946,696 78,670 5014 (3)% 5% 12 Technology & Innovation Svcs 2,026,820 846,187 522,289 594,490 780,887 (65,299) 39% 14% 31% 13 Public Works 3,802,639 1,869,067 1,688,085 1,821,101 1.774,366 (94,701) 47% 8% (3)% 15 Park Maintenance 1,418160 627,914 595,969 568,432 683,848 55,934 48% (5)% 20% 16 Street Maintenance & Operations 3,109,592 1,597,247 1,256,794 1,490,764 1,458,659 (138,588) 47% 19% (2)% 20 Dept 20 5,237,691 2,820,624 2,479,923 2,563,114 1,493,002 (1,327,622) 29% 3% (42)% Total Expenditures 62,639570 31,236,426 28,011,338 29,103,989 28,430,680 (2,805,747) 45% 444 (2)% Percent of year completed 72 50.0014 GENERAL FUND CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF JUNE 30, 2017 811412017 9,28 SUMMARY OF SALARIES AND BENEFITS BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVERI(UNDER) % CHANGE ALLOCATED BDGT % SPENT 201512015 2018/2017 11 Salanes 27.560,991 13,842,067 12,782,495 13,200,954 13.442,632 (399,436) 49% 3% 2% 12 Extra Labor 777,897 296,474 234,027 290.979 278,306 (18,157) 36% 24% (4)% 13 Overtime 1,632,035 745,954 882,008 655,729 834,294 88,340 51% (26)% 27% 15 Holiday Pay 525,583 77,373 4,767 79,341 74,2201 (3,153) 14% 1564% (6)% 21 FICA 1,809.260 908,527 826,942 855,265 882,387 (26,140) 49% 3% 30% 22 Pension-LEOFF 2 849,253 404,434 390,856 396,304 404,422 (12) 48% 1% 2% 23 Pension-PERSIPSERS 1,580.986 787,325 549,982 690,084 716,661 (70,664) 45% 25% 4% 24 Industrial Insurance 864,098 393,834 277,606 315,495 302,907 (90,928) 35% 14% (4)% 25 Medical & Dental 5.903,094 2,972,815 2,628,883 2,816,652 2,815.157 (157,658) 48% 7% (0)% 26 Unemployment 13,000 - 1,285 19,276 471 471 4% 1400% (98)% 28 Uniform/Clothing 10,460 2,965 1,557 1,731 1,178 (1,787) 11°1 11% (32)% Total Salaries and Benefits 41,526,657 20,431,768 18,580,409 19,321,810 19,752,633 (679,135) 48°% 4% 2% Percent of year completed 50.00% SUMMARY OF SUPPLIES, SERVICES, AND CAPITAL BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED BDGT % SPENT 2015/2016 2016/2017 Transfers 5,237,691 2,820,624 2,479,923 2,563,114 1,493,002 (1,327,622) 29% 3% (42)% 31 Supplies 1,164,823 594,900 558,301 541,264 636,616 41,716 55% (3)% 18% 34 Items Purchased for resale 22,000 15,187 13,461 15,203 14,001 (1,186) 640/, 13°1 (8) % 35 Small Tools 99,818 23,711 189,054 30,840 40,432 16,721 41% (84)°% 31% 41 Professional Services 3,266,711 1,163,109 1,027,933 998,812 1,016,728 (146,381) 31% (3)% 2% 42 Communication 449,970 184,083 166.753 166,010 177,996 (6,087) 40% (0)% 7% 43 Travel 192,380 111,271 71,677 75,062 102,643 (8,828) 53% 5% 37% 44 Advertising 51,500 19,910 10,176 11,870 9,932 (9,978) 19% 17% (16) % 45 Rentals and Leases 2,314,372 1,542,110 1,308,999 1,308,261 1,073,148 (468,962) 46% (0)14 (18)% 46 Insurance 886,895 886,895 785,581 810,799 887,617 722 100% 314 9% 47 Public Utilities 1,893,570 842.467 699,332 819,837 903,702 61,235 48% 17% 10% 48 Repairs and Maintenance 732,613 330,804 346,433 308,226 244,682 (88,122) 33% (11)°% (21)% 49 Miscellaneous 1,562,773 764,389 568,638 503,410 581,393 (182,996) 37% (11)% 15% 51 Inter -Governmental 3,003.792 1,484,217 1,195,293 1.261,325 1,454,234 (29,983) 48% 6% 15% 53 Ext Taxes, Oper. Assess 5 - 33 7 115 115 2308% (77) % 1445% 64 Machinery & Equipment 234,000 20,983 9,341 368,336 41,807 20,824 18% 3843% (89)°% Total Supplies, Services, and Capital 21,112,913 10,804,659 9,430,929 9,782,377 8,678,047 (2,126,612) 41% 4% (11)"% Percent of year completed 50.00% 73 CITY COUNCIL CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF JUNE 30, 2017 8114/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL QVER!(UNDER) % CHANGE ALLOCATED BDGT % SPEND 201512016 201612017 11 Salaries 199,767 98,903 90,807 95,969 99,101 198 505' 6% 3% 21 FICA 15,680 7,766 7,129 7,541 7,800 34 50% 6% 3% 23 Pension-PERS/PEERS 11,386 5,616 3,860 4,937 5210 (406) 46% 28% 6°% 24 Industrial Insurance 2,823 1,327 1,142 1,173 1,098 (228) 39% 3% (6)% 25 Medical & Dental 59,090 29,211 27,206 26,780 29,520 309 50% (2)% 10% Total Salaries & Benefits 288,746 142,823 130,144 136,400 142,729 (94) 49% 5°% 5°% 31 Supplies 4,370 2,489 2,180 2,235 830 (1,659) 19©% 3% (63)% 41 Professional Services 16,500 16,500 6,284 1,865 - (16,500) - (70)% - 42 Communication 6,000 3,485 2,024 2,622 296 (3.189) 5% 30% (89)% 43 Travel 40,000 25,475 18,058 19,736 21273 (4,203) 53% 9% 8% 49 Miscellaneous 10,400 6,647 3,804 6,645 3,806 (2,841) 37% 75% -43% Total Operating Expenses 77,270 54L596. 32,349 33,103 26,204w 128,3921 34% 2% (21)% Total Expenses 366,016 197,419 _ 162,493 169,503 168,933 (28,486) 46% 4% (0)% Percent of year completed 74 50.00% MAYOR CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVERI(UNDER) 1 CHANGE ALLOCATED BDGT 1 SPEND 2015/2016 2016/2017 11 Salaries 1,508,785 771.432 717,512 750,434 735,026 (36,407) 49% 5% (2)% 12 Extra Labor 53,500 8,989 2,142 1,000 8,581 (408) 16% (53)% 758% 13 Overt me 532 - - - - (28)% - - - 21 FICA 112,437 59,305 54,180 56.793 56,861 (2,424) 51% 5% 0% 23 Pension-PERSIPSERS 180,721 91,045 65,746 80,286 78,764 (12,281) 44% 22% (2)% 24 Industrial Insurance 5,647 3,089 2,193 2,258 2,448 (640) 43% 3% 8% 25 Medical & Dental 295,280 149,856 123,246 137,371 142,249 (7,607) 48% 11% 4% Total Salaries & Benefits 2,156,902 1,083,116 965,019 1,028,142 1,023,948 (59,768) 470 7% (0)% 31 Supplies 59.544 27,416 26,840 20.796 15,963 ' (11,453) 27% (23)% (23)% 35 Small Tools 5,500 - 1,852 1,239 - - - (33)% - 41 Professional Services 1,169.970 427,228 412.538 397,358 453,328 26,100 39% (4)% 14% 42 Communication 112,600 40,859 20,997 33,100 23,966 (16,893) 21% 58% (28)% 43 Travel 41,550 25,890 14,675 16,090 11,838 (14,052) 28% 10% (26)% 44 Advertising 19,750 7,755 3,890 2,758 3,609 (4,145) 181 (29)% 31% 45 Rentals and Leases 39.580 13,888 13.211 11,568 19,612 5,725 50% (12)1 70% 48 Repairs and Maintenance 32.460 8,862 1,254 17,407 1,166 (7,697) 4% 12881 (93)% 49 Miscellaneous 404,726 201,628 140,473 202,141 210,039 8,411 52% 44% 4% 51 Inter -Governmental 37.000 2,878 2,122 2.959 2,959 81 8% 39% (0)% 53 Ext Taxes, Oper Assess - - 2 0 0 0 - (72)% (88)% 64 Machinery & Equipment - - - 56,700 _ - - - - Total Operating Expenses 1,922,680 756,402 637,855 762,117 742,480 (13,922) 39% 191 (3)% Total Expenses 4,079,582 1,840,118 1,602,874 1,790,259 1,766,428 (73,690) 43% 12% (1)1 Percent of year completed MAYOR DIVISION SUMMARY 50.00% YTD AS OF JUNE 30, 2017 8/1412017 9:28 SUMMARY BY DIVISION BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2018 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED BDGT X SPEND 2015/2016 2016/2017 ADMINISTRATION 937,912 436,890 613,753 425,841 450,691 13,800 48% (31)1 6% ECONOMIC DEVELOPMENT 374,142 240,595 16,308 273,044 202,807 (37,788) 54% 1574% (26)% CITY CLERK 762,873 345,180 291,633 381,262 276,323 (68,857) 36% 31% (28)% COMMUNICATIONS 629,027 286.491 182,795 196,726 268,187 (18,303) 43% 8% 36% HUMAN SERVICES 813.515 304.489 296,677 303,949 367,827 63.338 45% 2% 21% COURT DEFENDER 477.000 198.331 185,435 192,150 191,318 (7,013) 40% 41 (0)1 SISTER CITIES COMM. 6.475 5,550 - 4,613 - (5,550) -- - PLANNING COMMISSION 3,750 2,891 4,172 549 570 (2,321) 15% (87)% 4% EQUITY & DIVERSITY COMMISSION 3,200 2,044 480 30 44 (2,000) 1% (94)% 46% ARTS COMMISSPON 5,000 2,527 2,122 2,596 2,612 85 52% 22% 1% PARKS COMMISSION 3,688 3,291 1,678 2,126 1,030 (2,261) 28% 27% (52)% LIBRARY ADVISORY BOARD 5,000 1,519 751 1,064 840 (679) 17% 42% (21)% COMMUNITY PROMOTION 26,000 9,969 7,070 5,946 3,833 (6,136) 15% (16)% (36)1 VOTER REGISTRATION COSTS 32,000 351 - 364 347 (4) 1% - (5)% Total Expenses 4,079,582 1,840,118 1,602,874 1,790,259 1,766,428 (73,690) 43°1 121 (1)% Percent of year completed 50 00% 75 MAYOR ADMINISTRATION YTD AS OF JUNE 30, 2017 8(1412017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED BOLT % SPEND 2015/2016 2016/2017 11 Salaries 356,437 176,991 335,369 172,992 177,761 769 50% (48)% 3% 12 Extra Labor 5,000 2,119 - 1,000 1,711 (408) 34% - 71% 21 FICA 23,751 13,202 25,348 14,196 14,785 1,583 62% (44)% 4% 23 Pension-PERS/PSERS 42,361 19,440 30,722 17,723 19,001 (440) 45% (42)% 7% 24 Industrial Insurance 1,059 505 838 453 386 (119) 36% (46)% (15)% 25 Medical & Dental 75,374 37,606 44,789 35,442 38,014 408 50% (21)% 7% Total Salaries & Benefits 503,982 249,864 437,065 241,805 251,657 1,793 50% (45)% 4% 31 Supplies 17,200 7,517 17,812 7.799 5,192 (2,325) 30% (56)% (33)% 41 Professional Services 190,000 46,390 60,879 40,806 64,328 17,939 34% (33)% 58% 42 Communication - - 168 - 58 58 - - - 43 Travel 20,000 10,528 10,472 7.290 6.373 (4,155) 32% (30)% (13)% 45 Rentals and Leases 25,480 8,848 7,755 8.017 12,998 4,149 51% 3% 62% 48 Repairs and Maintenance 3,250 - - - - - - - - 49 Miscellaneous 178.000 113,743 79,600 120.124 110,085 (3,659) 62% 51% (8)% 53 Ext Taxes, Oper Assess - - 2 0 0 0 - (72)% (88)% Total Operating Expenses 433,930 187,026 176,688 184,036 10031 12,007 46% 4% 8°% Total Expenses 937,912 436,890 613,753 425,841 450,691 13,800 48% (31)% 6% Percent of year completed MAYOR ECONOMIC DEVELOPMENT 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 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 150,413 - 188,562 123,364 (27,049) 50% - (35)% 12 Extra Labor 8,000 6,450 - - 6,450 - 81% - - 21 FICA 17,741 11,225 - 13,651 9.729 (1,496) 55% - (29)% 23 Pension-PERS/PSERS 29,655 17,433 - 19,314 13,781 (3,653) 46% - (29)% 24 Industrial Insurance 706 706 - 416 730 24 103% - 75% 25 Medical & Dental 21,269 13,641 17.660 10,423 (3,218) 49%- (41)% Total Salaries &Benefits 324,392 199,869 239,605 164,471 (35,392) 51% - (31)% 31 Supplies 1,000 557 250 665 294 (263) 29% 166% (56)% 41 Professional Services 16,000 16,000 5,500 6,100 27,295 11.295 171% 11% 347% 43 Travel 6,000 1.660 1,697 245 574 (1,086) 10% (86)% 134% 44 Advertising 2,000 - 346 - - - - - - 49 Miscellaneous 24,750 22,508 8,515 26,429 10,165 (12,343) 41% 210% (62)% Total Operating Expenses 49,750 40,726 16,308 33,440 38,330 (2,396) 77% 105% 15% Total Expenses 374,142 240,595 16,308 273,044 202,807 (37,788) 54% 1574% (26)% Percent of year completed 76 50.00 % MAYOR CITY CLERK YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED BDGT % SPEND 201512016 2016/2017 11 Salaries 371,475 186,801 180,465 182,819 162,462 (24,340) 44% 1% (11)% 12 Extra Labor 35,000 - - - - - 420 - - 21 FICA 30,511 15,466 13,485 13,633 12,125 (3,341) 40% 1% (11)% 23 Pension-PERS/PSERS 44,598 23,379 16,554 20,356 18,087 (5,291) 41% 23% (11)% 24 Industrial Insurance 1,764 873 668 685 578 (295) 33% 3% (16)% 25 Medical & Dental 92,996 46,483 40,091 43,130 45.458 (1,025) 49% 816 5°/0 Total Salaries & Benefits 576,344 273,002 251,263 260,624 238,710 (34,292) 41% 4% (8)0h 31 Supplies 12,308 6,313 3.596 5,212 5,115 (1,198) 42% 45% (2)% 41 Professional Services 6,000 3,000 1,561 1,048 909 (2,091) 15%4 (33)% (13)% 42 Communication 72,600 20,018 19.084 18,945 15,945 (4,073) 22% (1)% (16)% 43 Travel 5,500 4,875 438 1,801 1.397 (3,478) 2516 311% (22)% 44 Advertising 12,300 7,305 3,544 2,707 3,609 (3,695) 29% (24)16 33% 45 Rentals and Leases 10,100 3,372 3.824 1,919 3.826 453 38% (50)% 99% 48 Repairs and Maintenance 24,710 8,862 1.254 17,407 1,166 (7,697) 5% 1288% (93)% 49 Miscellaneous 43,011 18,432 7.068 14,899 5.646 (12,786) 13% 11116 (62)% 64 Machinery & Equipment - 49 Miscellaneous - 56,700- 11,218 - - - - Total Operating Expenses 186,529 72,178 40,370 120,63B 37,613 {34,565) a 20 % 199 % (69) % 38% 20% Total Expenses 762,873 345,180 291,633 361,262 276,323 (68,857) 3616 311 (28) Percent of year completed MAYOR COMMUNICATIONS 50.00% YTD AS OF JUNE 30, 2017 8114/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED BDGT 16 SPEND 2015/2016 201612017 11 Salaries 359,745 169,910 115,737 119.366 167,397 (2,512) 47% 316 40% 12 Extra Labor 5,000 420 2,142 - 420 - 8% - - 21 FICA 27,176 12,792 8,878 8,804 12,407 (385) 46% (1)16 41% 23 Pension-PERS/PSERS 43,205 20,353 10,599 13,279 18,653 (1,699) 43% 25% 40% 24 Industrial Insurance 1,412 671 422 429 517 (153) 37% 2% 21% 25 Medical & Dental _ 72,989 35.807 24,142 25,986 34,191 (1,616) 47/0 8% 32% Total Salaries & Benefits 509,527 239,952 161,919 167,863 233,586 (6,366) 46% 4!/ 39% 31 Supplies 1 9.000 1,275 2.456 2,127 1,153 (122) 13% (13)°/0 (46)% 35 Small Tools 5,500 - 1.852 - - - - - - 41 Professional Services 35,000 13,671 - - 13,671 - 39% - - 42 Communication 40,000 20,841 1,746 14,155 7,963 (12,877) 20% 711% (44)% 43 Travel 4,000 3,298 1,972 2,408 3,494 196 879/0 22% 45% 44 Advertising 5,000 - - - - - - - - 45 Rentals and Leases 4,000 1,667 1,632 1,632 2,789 1,123 70% 0% 71% 48 Repairs and Maintenance 2,000 - - - - - - - - 49 Miscellaneous 15,000 5,788 11,218 8.541 5,531 (257) 37% (24)% (35)% Total Operating Expenses 119,500 46,539 20,876 28,863 34,601 (11,938) 29% 38% 20% Total Expenses 629,027 286,491 182,795 196,726 268,187 (18,303) 4314 8% 36% Percent of year completed 50.00% 77 MAYOR HUMAN SERVICES YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVERf(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 201612017 11 Salaries 174,107 87,317 85,942 86,696 104,042 16,725 60% 1% 201 12 Extra Labor 500 - - - - - - - - 13 Overtime 532 - - - - -- Total Expenses - 21 FICA 13,258 6,620 6,469 6,509 7,835 1,215 59% 1% 20% 23 Pension-PERS/PSERS 20,902 10,440 7,871 9,613 9,242 (1,198) 44% 22% (4)% 24 Industrial Insurance 706 334 265 275 237 (96) 34% 4% (14)% 25 Medical & Dental 32,652 16,319 14,224 15,153 14,162 (2.156) 43% 7% (7)% Total Salaries & Benefits 242,657 121,028 114,771 118,245 135,518 14,489 56% 3% 15% 31 Supplies 1,688 596 470 379 366 (230) 22% (19)% (3)% 41 Professional Services 433,470 149,586 154,938 157.254 156,031 6,445 36% 1% (1)1 43 Travel 500 479 96 233 - (479) - 142% 49 Miscellaneous 135,200 32,799 26,402 27.839 75,912 43,113 56% 5% 173% Total Operating Expenses 570,858 183,461 181,906 185,704 232,309 48,648 41% 2% 25% Total Expenses 813,515 304,489 296,677 303,949 367,827 63,338 45% 2% 21% Percent of year completed MAYOR COURT DEFENDER 50.00% YTD AS OF JUNE 30, 2017 811412017 9:28 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 201612017 31 Supplies 41 Professional Services - 477,000 - 198,331 -- 185,435 192,150 475 190,844 475 (7,487) - 40% - 4% - (1)% Total Operating Expenses 47/,000 198,331 185,435 192,150 191,318 (7,013) 401 4% (0)1 Total Expenses 6,475 5,550 - Total Expenses 477,000 198,331 185,435 192,150 191,318 (7,013) 40% 4% (0)% Percent of year completed MAYOR SISTER CITIES COMM. 50.00% YTD AS OF JUNE 30, 2017 8114/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) 1 CHANGE ALLOCATED BDGT 1 SPEND 201512016 201612017 31 Supplies 41 Professional Services 43 Travel 49 Miscellaneous 425 500 5,050 50D - - 5,050 500 - -- - - 4,113 50D - - - - (5,050) (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 78 50.00% MAYOR PLANNING COMMISSION YTD AS OF JUNE 30, 2017 8114/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) 2017 % CHANGE ALLOdATED BDGT °% SPEND 2015/2016 20/6/2017 31 Supplies 43 Travel 49 Miscellaneous 1,000 500 2,250 641 - 2,250 347 - 3,825 99 - 450 - - 570 (641) - (1,680) - - 25% (72)% - - (88)% 27% Total Operating Expenses 3,750 2,891 4,172 549 570 (2,321) 15% (87)% 4% 2,596 30 85 44 (2,000) 1% (94)% 46% Total Expenses 3,750 2,891 4,172 549 570 (2,321) 15% (87)% 4% t Percent of year completed MAYOR EQUITY & DIVERSITY COMMISSION 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 • SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 2017 ACTUAL OVER/{UNDER) % CHANGE ALLOCATED BDGT %SPEND 201512016 2016/2017 31 Supplies 49 Miscellaneous 1,200 2,000 44 2,000 480 - 2.596 - 30 85 44 - - (2,000) 4% - - - Total Operating Expenses 3,200 2,044 480 2,596 30 85 44 (2,000) 1% (94)% 46% Total Expenses 3,200 2,044 480 2,596 30 85 44 (2,000) 1% (94)% 46% Percent of year completed MAYOR ARTS COMMISSION 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL UVER!(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 51 Inter -Governmental 5,000 2,527 2.122 2.596 2.612 85 52% 22% 1% Total Operating Expenses 5,000 2,527 2,122 2,596 2,612 85 52% 22% 1% Total Expenses 5,000 2,527 2,122 2,596 2,612 85 52% 22% 1% Percent of year completed 50.00% 79 MAYOR PARKS COMMISSION YTD AS OF JUNE 30, 2017 8114/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2018 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED BDGT %SPEND 201512016 201612017 31 Supplies 49 Miscellaneous 1,688 2,000 1,448 1,843 503 1,175 372 1,754 380 650 (1,068) (1,193) 23% 33% (26)% 49% 2% (63)% Total Operating Expenses 3,%S8 3,291 1,678 2,125 1,030 (2,261) 28% 27% (52)% %SPEND 201512016 2018/2017 31 Supplies 9,035 7,506 400 3,080 Total Expenses 5,000 Total Expenses 3,688 3,291 1,678 2,126 1,030 (2,261) 28% 27% (52)% Percent of year completed MAYOR LIBRARY ADVISORY BOARD 50.00% YTD AS OF JUNE 30, 2017 811412017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) ACTUAL % CHANGE ALLOCATED BDGT % SPEND 201512016 201612017 31 Supplies 41 Professional Services 5,000 - 1,519 - 526 225 1,064 840 - (679) - 17% - 102% (21)% - - Total Operating Expenses 5,0615 1,519 751 1,064 840 (679) 17% 42% (21)% BDGT %SPEND 201512016 2018/2017 31 Supplies 9,035 7,506 400 3,080 Total Expenses 5,000 1,519 751 1,064 840 (679) 17% 42% (21)% Percent of year completed MAYOR COMMUNITY PROMOTION 50-00%a YTD AS OF JUNE 30, 2017 8114/2017 9:28 Percent of year completed MAYOR VOTER REGISTRATION COSTS 50.00% YTD AS OF JUNE 30, 2017 8114/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY BY EXPENDITURE 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) ACTUAL % CHANGE ALLOCATED 8007 % SPEND TYPE 51 Inter -Governmental 2017 351 _ - 364 OVER/(UNDER) (4) % CHANGE ALLOCCTEb Total Operating Expenses 32,000 351 - 2017 ANNUAL ALLOCATED 2015 2018 2017 BDGT %SPEND 201512016 2018/2017 31 Supplies 9,035 7,506 400 3,080 2,103 (5,403) 23% 670% (32)% 35 Small Tools - - - 1,239 - - - - - 41 ProfessionalServices 12,000 250 4,000 - 250 - 2% - 44 Advertising 450 450 - 51 - (450) - - - 48 Repairs and Maintenance 2,500 - - - - - - - - 49 Miscellaneous 2,015 1,763 2,670 1.575 1,480 (283) 73% (41)% (6)% Total Operating Expenses 26,000 9,969 7,070 5,946 3,83'3 (6,136) 15% (16)% (36)% Total Expenses 26,000 9,969 7,070 5,946 3,833 (6,136) 15% (16)% (36)% Percent of year completed MAYOR VOTER REGISTRATION COSTS 50.00% YTD AS OF JUNE 30, 2017 8114/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED 8007 % SPEND 201512016 201612017 51 Inter -Governmental 32,000 351 _ - 364 347 (4) 1% - (5)% Total Operating Expenses 32,000 351 - 364 3471 (4) 1% - (5)% Total Expenses- 32,000 351 - 364 347 (4) 1% - (5)% Percent of year completed 80 50.00% HUMAN RESOURCES CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED BDGT % SPEND 201512016 2016/2017 11 Salaries 405299 210,459 202,658 206,203 203,530 (6,929) 50% 2% (1)% 12 Extra Labor 6,000- _ _ - _ - - - 21 FICA 28,947 15,668 14,918 15,150 14,930 (738) 52% 2% (1)% 23 Pension-PERS/PSERS 48,653 25,911 18,542 22,873 22,578 (3,334) 46% 23% (1)% 24 Industrial Insurance 1,417 708 530 550 515 (192) 36% 4% (6)% 25 Medical & Dental 77,642 42,174 32,032 34,428 31,233 (10,941) 40% 7% (9)% Total Salaries & Benefits 567,958 294,921, 268,679 279,204 272,787 (22,134) 48% 4% (2)% 31 Supplies 14,817 5,567 4,087 3,508 7,869 2,303 53% (14)% 124% 41 Professional Services 90,575 47,825 6,494 43,984 29,772 (18,053) 33% 577% (32)% 42 Communication 50 -- - - - - - - 43 Travel 3.000 1,880 1,723 591 677 (1,204) 23% (66)% 155 44 Advertising 6,250 4,037 1,800 4,225 1,733 (2,304) 28% 135% (59)% 45 Rentals and Leases 5,108 3.444 2,445 2,520 872 (2,572) 17% 3% (65)% 48 Repairs and Maintenance 14,000 14,000 12,062 2,790 - (14,000) - (77)% - 49 Miscellaneous 4,450 4.450 1,587 854 10,305 5,855 232% (46)% 1106% Total Operating Expenses 138,250 81,202 30,197 58,472 51,228 (29,974) 37% 94% (12)% Total Expenses 706,208 376,124 298,877 337,675 324,015 (52,109) 46% 13% (4)% Percent of year completed 50.00% 81 FINANCE CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET i ACTUAL COMPARISON OF RESULTS 2077 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVERI(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 1,053,485 542,234 490,527 507,570 518,237 (23,997) 49% 3% 2% 12 Extra Labor 60,000 5,920 4,213 - 5,920 - 10% - - 13 Overtime 9,289 472 1,181 380 3,939 3,467 4214 (68)% 938% 21 FICA 79,621 41,527 37,231 38,336 40,024 (1,504) 5014 3% 414 23 Pension-PERSIPSERS 127,773 65,256 44,360 56,676 57,251 (8,005) 45% 28% 1% 24 Industrial Insurance 4,235 2,028 1,553 1,564 1,503 (525) 35% 1% (4)% 25 Medical & Dental 223,559 114,352 90.047 96,396 106,117 (8,234) 47% 7% 1014 26 Unemployment 13,000 - -- - - - - Total Salaries & Benefits 1,570,962 771,790 569,111 700,920 732,991 (3099) 47% 5/0 5% 31 Supplies 19,000 4,464 6,564 6,180 4,091 (372) 22% (6)14 (34)% 35 Small Tools 5,000 3,372 - 4,048 - (3,372) - - - 41 Professional Services 170,000 37,432 44,374 30,907 50,852 13,420 30%4 (30)% 65% 42 Communication 1,000 7 79 - 7 - 1%4 - - 43 Travel 10,000 7,007 1,465 3,217 6,159 (848) 62% 120% 91% 45 Rentals and Leases 3,500 1,458 1,368 1,368 1,098 (361) 31% 0% (20)% 46 Insurance 351,826 351,826 455,581 338,340 352,082 256 10 VA (26)% 4% 48 Repairs and Maintenance 65,625 65,625 57,278 59,781 66,785 1,160 102% 4% 12% 49 Miscellaneous 441,900 280,829 194,233 120,048 116,349 (164,480) 26% (38)% (3)14 53 Ext Taxes, Caper. Assess - - 1- 2 2 - - - Total Operating Expenses 1,067,851 752,020 760,943 563,891 597,425 (154,596) 561 (26)% fi I Total Expenses 2,638,813 1,523,810 1,430,054 1,264,811 1,330,415 (193,394) 50% (12)14 5% Percent of year completed 82 50.00% ATTORNEY CITY OFTUKWILA GENERAL FUND EXPENDITURES YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/{UNDER) % CHANGE ALLOCATED BDGT %SPEND 201512016 - 2016!2017 12 Extra Labor 5,000 2,596 1254 1,302 1272 (1,324) 25% 4% (2)% 21 FICA 355 184 96 100 97 (87) 27% 4% (2)% 24 Industrial Insurance 100 52 16 17 15 (37) 15% 8% (9)% Total Salaries & Benefits 5,455 2,832 1,365 1,418 1,384 , (1„447j _ 25% 4% (2)% 31 Supplies 6,000 2,498 2,283 2,011 1,396 (1,102) 23% (12)% (31)% 41 Professional Services 701,000 295,913 244,860 220,842 211,208 (84,704) 30% (10)% (4)% 45 Rentals and Leases 2,100 1,435 - - 1,435 - 68% - - 48 Repairs and Maintenance 1,400 - - - - - - - - 49 Miscellaneous 1,000 - - - - - - - - Total Operating Expenses 711,500 299,845 247,144 222,853 214,039 (85,806) 30% (10)% (4)% Total Expenses 716,955 302,677 248,509 224,271 215,424 (87,253) 30% (10)% (4)% Percent of year completed 50.00% 83 RECREATION DEPARTMENT CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF JUNE 30, 2017 8114)2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVERI(UNDER) %CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016)2017 11 Salaries 1,400,656 710,985 642,234 658,188 706,932 (4.052) 50% 2% 7% 12 Extra Labor 530,643 219,662 174,414 217,591 205,021 (14,641) 39% 25% (6)% 13 Overtime 4,179 876 2.320 2,407 16 (860) 0°10 4% (99)% 21 FICA 145,838 70,046 61,671 66,372 68,491 (1,555) 47% 8% 3% 23 Pension-PERS/PSERS 168,165 86,432 63,851 82,206 87,267 835 52% 29% 6% 24 Industrial Insurance 84,822 30,712 29,352 33,930 27,587 (3.125) 33% 16% (19)% 25 Medical & Dental 320,924 157,721 138.922 148,235 163,956 6,235 51% 7% 11% 26 Unemployment - - 138 (2,894) 404 404 - (2199)% (114)% 28 Uniform/Clothing 230 225 197 - 225 - _ 98% - - Total Salaries & Benefits 2,655,457 1,276,659 1,113,100 1,206,035 1,259,898 (16,751) 47% 8°,k 4% 31 Supplies 125.986 58,333 62,124 59,132 57,946 (387) 46% (5)% (2)% 34 Items Purchased for resale 22,000 15,187 13,461 15,203 14,001 (1,186) 64% 13% (8)% 35 Small Tools 11,000 1,631 -- 1.631 - 15% - - 41 Professional Services 208,480 74,230 62,137 69,341 52,241 (21.988) 25% 12% (25)% 42 Communication 12,150 3,718 3,970 5,458 2,878 (840) 24% 37% (47)% 43 Travel 8,725 6,378 2,395 2,720 10,458 4,080 120% 14% 285% 44 Advertising 22,500 7,718 4,486 4,424 4,137 (3,581) 18% (1)°/o (6)% 45 Rentals and Leases 48,590 21,105 24,178 24,978 21,690 585 45% 3% (13)% 48 Repairs and Maintenance 30,400 1,734 12,665 9,892 986 (749) 3% (22)% (90)% 49 Miscellaneous 109,400 31,126 47,470 32,699 38,669 7,543 35% (31)% 18°I6 64 Machinery & Equipment 130,000 20,983 - - 20,983 - 16% - - Total Operating Expenses 729,231 242,144 232,885 223,846 �$a, 2O (16,524) 31% (4)% 1% • Total Expenses 3,384,688 1,518,803 1,345,985 1,429,881 1,485,518 (33,285) 44% 6% 4% Percent of year completed RECREATION DIVISION SUMMARY 50.D0% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY DIVISION BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2015 2017 ACTUAL QVERI(uNDER) % CHANGE ALLOCATED BOST °k SPEND 2015/2016 2016/2417 ADMINISTRATION 481,514 189,180 171,428 136,130 199.898 10,718 42% (21)% 47% RECREATION 462,343 215,093 716,848 793,705 214,284 (809) 46% 11% (73)% PRESCHOOL PROGRAM 79,776 46.546 - - 46.737 191 59% - - YOUTH PROGRAMS 564,781 206,600 -- 206,605 5 37% - - TEEN PROGRAMS 201,780 84.002 - - 90,235 6,234 45% - - YOUTH WELLNESS AND ENRICHMEN 148,978 72.413 - 75,463 3,050 51% - - ADULT WELLNESS AND ENRICHMEA 215,044 85.457 65,779 322 40p/0 SENIOR ADULT PROGRAMS 176,287 87,067- - 87,067 - 49% - - COMMUNITY EVENTS AND VOLUNTE 281,660 155,491 153,314 136,847 100,749 (54,743) 36% (11)% (26)% PLANNING AND BUSINESS OPS 460,559 214,100 - - 214,100 - 46% - - RENTAL OPERATIONS 311.966 162,853 I 304,395 363,199 164,600 1,747 53% 19% (55)% Total Expenses 3,384,688 1,518,803 1,345,985 1,429,881 1,485,518 (33,285) 44% 6% 4% Percent of year completed 84 50.00 RECREATION ADMINISTRATION YTD AS OF JUNE 30, 2017 8114/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL _ COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNOER) 1 CHANGE ALLOCATED BDGT % SPEND 2015/2016 2015/2017 11 Salaries 248,194 117,013 116,378 97,248 123,317 6,305 50% (16)% 27% 12 Extra Labor 5,000 2,774 - 553 1,786 (989) 36% - 223% 13 Overtime 464 - - - - - - - - 21 FICA 16,870 8,821 8,635 7,103 9,075 255 54% (18)% 28% 23 Pension-PERS/PSERS 29,797 13,972 10,718 10,764 13,592 (381) 46% 0% 26% 24 Industrial Insurance 1,189 566 269 283 409 (158) 34% 5% 44% 25 Medical & ©ental 32,833 16,864 17,771 15,108 22,580 5.716 69% (15)% 49% Total Salaries & Benefits 334,347 160,010 153,772 131,060 170,759 10,749 51% (15)% 30% 31 Supplies 5.917 1,154 9,002 1.369 4,749 3,595 80% (85)% 247% 41 Professional Services 2,500 1,020 3.030- 14,520 1,020 - 41% - - 42 Communication - - 987 305 53 53 - (69)% (82)% 43 Travel 2,500 2.109 379 305 723 (1,386) 29% (19)% 137% 45 Rentals and Leases -- Professional Services 1,062 1,062 - - - 0% - 48 Repairs and Maintenance 2,000 - - - - - - - - 49 Miscellaneous 4,250 3,904 3,197 2,028 1,611 (2,293) 38% (37)% (21)1 64 Machinery & Equipment 130,000 20.983 - - 20,983 - 16% - - Total Operating Expenses 147,167 29,170 17,657 5,069 29,139 (31) 20% (71)% 475% - (94)% - 48 Repairs and Maintenance -- 422 - - - Total Expenses 481,514 189,180 171,428 136,130 199,898 10,718 421 (21)% 47% Percent at year completed RECREATION RECREATION 50.00% YTD AS OF JUNE 30, 2017 8/1412017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED BDGT % SPEND 201512016 2016/2017 11 Salaries 193,608 96,248 275,101 329,700 94,920 (1,328) 49% 20% (71)% 12 Extra Labor 70,220 33,600 174,414 184,940 30,268 (3,332) 43% 6% (64)1 13 Overtime - - 21 - 11 11 - - - 21 FICA 20,093 9,824 34,014 39,147 9,532 (292) 47% 15% (76)% 23 Pension-PERS/PSERS 23,243 11,388 1 29,990 43,621 12,107 719 52% 45% (72)% 24 Industrial Insurance 12,256 5,555 24,971 27,159 4,020 (1,535) 33% 9% (85)% 25 Medical & Dental 39,424 19,647 63,748 79,288 19,721 75 50% 24% (75)% 26 Unemployment -- 138 (2,894) 404 404 - (2199)% (114)% Total Salaries & Benefits 358,844 176,261 602,397 700,951 170,982 (5,279) 481 16% (76)% 31 Supplies 27,919 14,520 ' 32,509 33,995 8.706 (5.813) 31% 5% (74)% 34 Items Purchased for resale - - 7,694 (974)- - - (113)% - 35 Small Tools 11,000 1.631 - - 1,631 - 15% - - 41 Professional Services 22,930 8,587 28,548 37,297 18,474 9,886 81% 31% (50)% 42 Communication 2.850 1,498 1,208 1,727 547 (952) 19% 43% (68)% 43 Travel 1.800 1,800 1,636 2.246 2,123 323 118% 37% (5)% 44 Advertising 4,800 421 75 110 260 (161) 5% 46% 137% 45 Rentals and Leases -- 1,507 85 - - - (94)% - 48 Repairs and Maintenance -- 422 - - - - - - 49 Miscellaneous 32,200 10,375 40,854 18,258 11,562 1,187 36% (55)% (37)% Total Operating Expenses 103499 38,832 114,452 92,744 43,303 4,470 42% (19)% (53)1 Total Expenses 462,343 215,093 716,848 793,705 214,284 (809) 46% 11% (73)% Percent of year completed 50.00%. 85 RECREATION PRESCHOOL PROGRAM YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 OVER1{UNDER) % CHANGE ALLOCATED BDGT % SPEND 201512016 2018/2017 11 Salaries 37,245 17,815 - - 17,815 - 48% - - 12 Extra Labor 20,900 14,080 - - 14,080 - 67% - - 21 FICA 4,397 2,438 - 2,438 1 - 55% - 23 Pension-PERS/PSERS 4,479 3,170 - - 3.170 - 71% - - 24 Industrial Insurance 2,285 1,129 - - 1.129 - 49% - - 25 Medical & Dental 370 205 - - 205 - 56% - - Total Salaries & Benefits 69,676 38,838 - 38,838 - 564/4 - - 31 Supplies 8,600 7,208 -- 7,208 - 84% - 41 Professional Services 1,000 - - - - - - - - 49 Miscellaneous 500 500 - - 691 191 138% - - Total Operating Expenses 10,100 7,708 -- 7,899 191 781/4 - - Total Operating Expenses 61,100 9,392 - - 9,392 - 151/4 - - Total Expenses 79,776 46,546 -- 46,737 191 59414 - - Percent of year completed RECREATION YOUTH PROGRAMS 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 OVER/(UNDER) % CHANGE ALLOCATED BDGT % SPEND 201612016 2016/2017 11 Salaries 148,265 73,599 - - 73,599 - 50% - - 12 Extra Labor 230,203 69,521 - - 69,521 - 30% - - 13 Overtime - 5 5 - 21 FICA 30,327 10,858 - - 10,858 - 36% - - 23 Pension-PERSIPSERS 17,799 11,605 - - 11,605- 65% - - 24 Industrial Insurance 29.562 7,882- - 7,882 - 271 - - 25 Medical & Dental 47.525 23,743 - 23,743 - 501 - - Total Salaries & Benefits 503,681 197,208 - - 197,214 5 39% - - 31 Supplies 20.600 8.364- - 8,364 - 41% - - 41 Professional Services 24,500 1.010 - - 1,010 - 4% - - 49 Miscellaneous 16,000 18 - - 18 - 0'/4 - - Total Operating Expenses 61,100 9,392 - - 9,392 - 151/4 - - Total Expenses 564,781 206,600 - - 206,605 _ 5 37% - - Percenl of year completed 86 50.00% RECREATION TEEN PROGRAMS YTD AS OF JUNE 30, 2017 8(1412017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 OVERI(UNDER) %CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 66,466 32,520 - - 32,520 - 49% - - 12 Extra Labor 63,850 19,963 - 19,963 - 31% - 21 FICA 9.969 4,015 - 4,015 - 40% - - 23 Pension-PERS/PSERS 7,980 4.378 - - 4,378 - 55% - - 24 Industrial Insurance 8.906 2.671 - - 2,671 - 30% - - 25 Medical & Dental 23,729 11,856 - - 11,856 - 50% - - Total Salaries & Benefits 180,900 75,404 - - 75,404 - 42% - 31 Supplies 7,650 2.987 - - 2,987 - 39% - - 41 Professional Services 5,050 4.259 - - 4,259 - 84% - - 43 Travel - - - - 5,067 5,067 - - - 45 Rentals and Leases 180 180 - - 1,346 1,166 748% - - 49 Miscellaneous 8,000 1,173 - - 1,173 - 15% - _ - Total Operating Expenses 20,880 8,598 -- 14,832 6,234 71% - - 1 Total Expenses 201,780 84,002 - - 90,235 6,234 45% - - Percent of year completed RECREATION YOUTH WELLNESS AND ENRICHMENT 50.00% YTD AS OF JUNE 30, 2017 8(1412017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 OVER/ UNDER) % CHANGE ALI ATED BOLT % SPEND 2015/2016 2016/2017 11 Salaries 66,598 32,658 - - 32,658 - 49% - - 12 Extra Labor 12,700 12,700 - - 15,750 3,050 124% - - 21 FICA 6,067 3,703 - - 3,703 - 61% - 23 Pension-PERS/PSERS 7,995 4,592 - - 4,592 - 57% - 24 Industrial Insurance 3,962 1,946 - - 1,946 - 49% - - 25 Medical & Dental 16,456 8,220 - - 8,220 - 50% - - Total Salaries & Benefits 113,778 63,819 - - 66,869 3,050 59% - - 31 Supplies 5,600 5,036 - - 5,038 - 90% - - 41 Professional Services 28,900 3,558 - - 3.558 - 12% - - 49 Miscellaneous700 - - - - - - - Total Operating Expenses 35,200 8,594 -- 8,594 - 24% - Total Expenses 148,978 72,413 -- 75,463 3,050 51% - - Percent of year completed 50 00% 87 RECREATION ADULT WELLNESS AND ENRICHMENT YTD AS OF JUNE 30, 2017 811412017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET _ ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 OVER1(UNDER) %CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 81.942 40,194 - - 40.194 - 49% - - 12 Extra Labor 24,000 12.521 - - 12,521 • 52% - - 21 FICA 7.914 3,941 - - 3,941 - 50% 23 Pension-PERS/PSERS 9.837 5.099 - 5,099 - 52% - - 24 Industrial Insurance 5.054 1,840 - - 1,840 - 36% - - 25 Medical & Dental 23.797 11,887 - - 11,887 - 50% - - Total Salaries & Benefits 152,544 75,482 -- 75,482 - 49% - 31 Supplies 4,200 897 - 897 - 21% - - 41 Professional Services 50.900 8,331 - - 8,331 - 16% - - 48 Repairs and Maintenance 7.200 548 - - 548 - 8% - - 49 Miscellaneous _ 200 200 - 522 322 261% - - Total Operating Expenses 62,500 9,975 - 10,297 322 16% Total Expenses 1 215,044 85,457 - - 85,779 322 40% - Percent of year completed 88 50 OD% RECREATION SENIOR ADULT PROGRAMS YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET 1 ACTUAL COMPARISON OF RESULTS 2017 2017 ANNUAL ALLOCATED 2015 2018 2017 ACTUAL OVER/(uNDER) % CHANGE ALLOCATED MGT % SPEND 201512016 201612017 11 Salaries 82,253 40,344 - - 40,344 - 49% - - 12 Extra Labor 27,000 12,731 - - 12,731 - 47% - - 21 FICA 8,298 4,026 - - 4.026 - 49% - - 23 Pension-PERSIPSERS 9,875 5,468 - - 5.468 - 55% - - 24 Industrial Insurance 5,344 1,903 - - 1,903 - 36% - - 25 Medical & Dental20,517 10,247 - - 10,247 - 50% - - Total Salaries & Benefits 153,287 74,718 -- 147111 - 49% - - 31 Supplies 3,000 2,387 - - 2.387 - 80% - - 41 Professional Services 5,900 260 - - 260 - 4% - - 43 Travel 2,100 1,166 - - 1.166 - 56% - - 49 Miscellaneous 12,000 8,536- - 8.536 - 71% - - Total Operating Expenses 23,000 12,349 - - 12,349 - 54% - - (1,202) 40% (7)% (28)% Total Expenses 176,287 87,067 87,067 - 49% - - Percent of year completed RECREATION COMMUNITY EVENTS AND VOLUNTEERS 50.00% YTD AS OF JUNE 30, 2017 8114/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2018 2017 ACTUAL OVER1(UNDER) % CHANGE ALLOCATED SDGT % SPEND 2015/2016 201612017 11 Salaries 111.432 61,987 75,964 65.216 51,454 (10,533) 46% (14)% (21)% 12 Extra Labor 15,150 8,325 - 4,414 1,872 (6,453) 12% - (58)% 13 Overtime 2,322 386 187 188 - (386) - 1% - 21 FICA 9.467 4,978 5,676 5,273 3,776 (1,202) 40% (7)% (28)% 23 Pension-PERS/PSERS 13,377 6.976 6.844 6.729 5,868 (1,108) 44% (2)% (13)% 24 Industrial Insurance 3,780 1,616 1,532 1,464 1,646 29 44% (4)% 12%m 25 Medical & Dental 21,382 10,423 16.498 11,795 10,736 313 50% (29)% (9)% Total Salaries & Benefits 176,6110 94,692 106,700 95,078 7552 (19,340) 43% (11)% (21)% 31 Supplies 25,400 9,029 12,028 7,955 7,019 (2,010) 28% (34)% (12)% 41 Professional Services 58,400 44,499 30,559 30,407 15,178 (29,321) 26% (0)% (50)% 42 Communication 500 - 328 - - - - - - 43 Travel 600 106 25 - 106 - 18% - - 44 Advertising 10,500 4,770 1,931 1,979 1,509 (3,261) 14% 2% (24)% 45 Rentals and Leases 6,800 1,179 885 905 688 (490) 10% 2% (24)% 49 Miscellaneous 2,550 1,216 858 521 896 (320) 35% (39)% 72% Total Operating Expenses 104,750 60,799 46,614 41,769 25,3t7(35,402) - 24% (10)% (39)% Total Expenses 281,660 155,491 153,314 136,847 100,749 - (54,743) 36% (11)% (26)% Percent of year completed 50.00% 89 RECREATION PLANNING AND BUSINESS OPERATIONS YTD AS OF JUNE 30, 2017 8/1412017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 2017 ANNUAL ALLOCATED 2015 2016 2017 OVER/{UNDER) % CHANGE ALLOTTED BDGT % SPEND 2015120/6 2016/2017 11 Salaries 237,624 136.066 136,066 - 57% - - 13 Overtime 464 - - - - - - - - 21 FICA 18,119 10.293 - 10,293 - 57% - - 23 Pension-PERS/PSERS 28.529 12,226 - 12,226 - 43% - - 24 Industrial Insurance 3,440 1,110 - - 1,110 - 32% - 25 Medical & Dental 63.043 28.820 - - 28,820 - 46% - - 28 Uniform/Clothing 230 225 - 225 - 98% - - Total Salaries & Benefits 351,449 188,740 - 188,740 - 54% - - 31 Supplies 6,800 2,205 - - 2,205 - 32% - 41 Professional Services 3,000 151 - - 151 - 5% - 42 Communication 8,800 2,220 - - 2,220 - 25% - - 43 Travel 1.400 1,008 - - 1,008 - 72% - - 44 Advertising 500 - - - - - - - 45 Rentals and Leases 39.610 17,832 - 17,832 - 45% - 48 Repairs and Maintenance 19.700 438 - - 438 2% - - 49 Miscellaneous 29,300 1,506) - - _ 1,506 - 5% - Total Operating Expenses 109,110 25,360 - - 25,360 - 23% - - 4,493 2,580 5,023 3.031 Total Expenses 460,559 214,100 - - 214,100 - 46% - - Percent of year completed RECREATION RENTAL OPERATIONS 50.00% YTD AS OF JUNE 30, 2017 8/1412017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 OVER!(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 127,029 62.542 174.792 166,025 64,045 1,503 50% (5)% (61)% 12 Extra Labor 61,620 33,447 - 27,684 26,529 (6,918) 43% - (4)% 13 Overtime 929 490 2,113 2,218 - (490) - 5% - 21 FICA 14,317 7,148 13,347 14,849 6,834 (315) 48% 11% (54)% 23 Pension-PERS/PSERS 15,254 7,558 16,298 21,093 9,163 1,605 60% 29% (57)% 24 Industrial Insurance 9,044 4,493 2,580 5,023 3.031 (1.462) 34% 95% (40)%, 25 Medical & Dental 31,848 15,809 40,905 42,044 15:940 131 50% 3% (62)% 28 Uniforrn/Clathing - - 197 - - _ - Total Salaries & Benefits 260,041 131,487 250,232 278,935 125,541 (5,946) 48% 11% (55)% 31 Supplies 10,300 4,547 8,586 15,812 8,388 3,841 81% 84% (47)% 34 (terns Purchased for resale 22.000 15,187 5,767 16,177 14,001 (1,186) 64% 181% (13)% 41 Professional Services 5,400 2,554 - 1,636 - (2,554) - - - 42 Communication -- 1,447 3,426 58 58 - 137% (98)% 43 Travel 325 188 355 169 264 76 81% (52)% 56% 44 Advertising 6,700 2,526 2,480 2,335 2,368 (159) 35% (6)% 1% 45 Rentais and Leases 2.000 1.915 20,724 22,925 1,824 (91) 91% 11% (92)% 48 Repairs and Maintenance 1,500 749 12,243 9.892 - (749) - (19)% - 49 Miscellaneous 3,700 3,700 2,561 11,892 12,156 8.456 329% 364% 2% Total Operating Expenses 51,925 31,366 54,163 84,264 39,058 7,692 75% 56% (54)% Total Expenses 311,966 162,853 304,395 363,199 164,600 1,747 53% 1996 (55)% Percent of year completed 90 50 00% COMMUNITY DEVELOPMENT CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF JUNE 30, 2017 8/14/2017 9:28 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,076,994 874,360 962,442 1,050,843 (26,151) 48% 10% 9°10 12 Extra Labor 51,074 33,246 40,941 32,934 24,677 (8,568) 48% (20)% (25)% 13 Overtime 11,094 4,134 2,713 1,632 2,947 (1,187) 27% (40)% 81% 21 FICA 171,664 85,914 69,582 75,467 81,952 (3,962) 48% 8% 9% 23 Pension-PERS/PSERS 263,447 129,920 81,868 108,990 117,754 (12,166) 45% 33% 8% 24 Industrial Insurance 23,960 10,698 5,907 7,109 8,085 (2.614) 34% 20% 14% 25 Medical & Dental 447,425 221,349 143,709 172,600 193,082 (28,268) 43% 20% 12% 28 Uniform/Clothing 2,975 172 99 142 203 31 7% 44% 43% Total Salaries & Benefits 3,154,696 1,562,428 1,219,179 1,361,316 1,479,542 (82,885) 47% 12% 9% 31 Supplies 37,180 21,431 25,118 16,868 34,635 13,205 93% (33)% 105% 35 Small Tools 500 181 - - 181 - 36% - - 41 Professional Services 253,400 109,860 111,182 98,079 54,920 (54,940) 22% (12)% (44)% 42 Communication 6,500 1,771 1,495 2,212 372 (1,399) 6% 48% (83)% 43 Travel 13,800 2,136 811 848 1,010 (1,127) 7% 5% 19% 45 Rentals and Leases 12,800 9,682 12,285 13,003 7,173 (2,509) 56% 6% (45)% 47 Public Utilities 2,500 860 598 586 2,023 1,163 81% (2)% 245% 48 Repairs and Maintenance 51,185 12,872 8,595 8,862 9,040 (3,832) 18% 3% 2% 49 Miscellaneous 152,777 63.167 38,239 37,754 14,645 (48,522) 10% (1)% (61)% 51 Inter -Governmental 8,000 3.821 3,722 - 3,821 - 48% - - 53 Ext Taxes, riper Assess - - - 1 107 107 - - 8855% Total Operating Expenses 538,642 225,779 202,045 178,214 127,926 (97,853) 24% (12)% (28)% Total Expenses 3,693,338 1,788,207 ' 1,421,224 1,539,530 1,607,468 (180,739) 44% 8% 4% Percentof year completed COMMUNITY DEVELOPMENT DIVISION SUMMARY 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY DIVISION BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2011 ALLOCATED 2015 2.016 2017 ACTUAL OVER1(UNDER) % CHANGE ALLOCATED BDGT %SPEND 2015/2016 201812017 ADMINISTRATION 363,988 173.603 184,859 167,783 173,508 (95) 48% (9)% 3°% CODE ENFORCEMENT 519,030 278,156 175,911 217,169 207,311 (70.846) 40% 23% (5)% PERMIT CENTER 399,556 181,069 177,782 199,832 162,960 (18,110) 41% 12% (18)% BUILDING. PERMIT AND PLAN REVIEV% 849.025 376,163 202,040 321,740 371,760 (4,403) 44% 59% 16% PLANNING 1,269.970 674,615 626,257 536,191 545,739 (124,877) 43% (14)% 214 RECYCLING PROGRAM 46,000 26,137 33,313 26,098 19,800 (6,337) 43% (22)% (24)% TDM PROGRAM 245,769 82,463 21,062 74,719 126.392 43,929 51% 23614 79% Total Expenses 3,693,338 1,788,207 1,421,224 1,539,530 1,607,468 (180,739) 44% 814 4% Percent of year completed 50.0D% 91 COMMUNITY DEVELOPMENT ADMINISTRATION YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 _ _ ACTUAL OVERIIUNDER) % CHANGE ALLOCATED BDGT %SPEND 201512016 2016/2017 11 Salaries 230,470 115,707 112,240 113,915 116.067 359 50% 1% 2% 13 Overtime 1,114 661 725 - 661 ' - 59% - - 21 FICA 15,422 8,600 8,413 8,474 8,695 95 56% 1% 3% 23 Pension-PERSIPSERS 27,668 13,827 10,312 12,619 12,950 (877) 47% 22% 3% 24 industrial Insurance 706 339 268 280 253 (85) 36% 454 (9)% 25 Medical & Dental 48,628 26,602 24,055 23,875 20,793 (5,809) 43% (1)% (13)%' Total Salaries & Benefits 324,008 165,736 156,013- 159,162 159,418 (6,318) 49% 2% 00 31 Supplies 9,680 2,431 13,638 4.044 7,405 4,974 76% (70)% 83% 41 Professional Services 13,000 - 11,258 - -- 205,859 202,982 (50,010) 45% 43 Travel 500 16 57 64 83 67 17% 12% 30% 45 Rentals and Leases 4,800 2,000 2,241 3,162 3,173 1,173 66% 41% 0% 48 Repairs and Maintenance 500 500 463 759 566 66 113% 64% (25)% 49 Miscellaneous 11,500 2,920 1,190 590 2,755 (165) 24% (50)% 367% 53 Ext Taxes, Assessments- - - - 1 107 - - 107 - - 8855% Total Operating Expenses 39,680 7,86Y 28,846 8,620 14,090 6,223 35% (70)% 63% (2)% 245% 49 Miscellaneous 53,427 18,566 68 382 35 (18,531) 001 Total Expenses 363,988 173,603 184,859 167,783 173,508 (95) 48% (9)% 3% Percent of year completed COMMUNITY DEVELOPMENT CODE ENFORCEMENT 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVERI(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 302,047 174,819 111,870 140,145 138,433 (36,386) 46% 25% (1)% 12 Extra Labor 5,574 2,441 - 7,680 980 (1,461) 18% - (87)% 13 Overtime 2,786 131 133 - 131 - 5% - - 21 FICA 23,746 13,518 8,568 11,309 10,937 (2,581) 46% 32% (3)% 23 Pension-PERSIPSERS 36,266 19,808 10,235 15,388 14,194 (5,615) 39% 50% (8)%. 24 IndustrialInsurance 8,732 4,688 2,530 3,411 2,719 (1,969) 31% 35% (20)% 25 Medical & Dental 75,628 37,415 18,196 27,783 35,386 (2,029) 47% 53% 27%1 28 Uniform/Clothin2 475 172 - 142 203 31 43% - 43% Total Salaries & Benefits 455,254 252,992 151,533 205,859 202,982 (50,010) 45% 36% (1)% 31 Supplies 500 242 (3,221) 950 156 (86) 31% (130)% (84)54 41 Professional Services - - 21,210 3,578 - - - (83)% - 42 Communication 3,000 1,466 1,440 1,496 240 (1,226) 8% 4% (84)% 43 Travel 600 600 32 39 - (600) - 22% - 45 Rentals and Leases 3,749 3,431 4,251 4.278 1,875 (1,556) 50% 1% (56)% 47 Public Utilities 2,500 860 598 586 2,023 1,163 81% (2)% 245% 49 Miscellaneous 53,427 18,566 68 382 35 (18,531) 001 462% (91)% Total Operating Expenses 63,776 25,164 ' 24,378 11,310 4,328 (20,836) 7% (54)% (62)% Total Expenses 519,030 278,156 175,911 217,169 207,311 (70,846) 40% 23°A (5)% Percent of year completed 92 50.00% COMMUNITY DEVELOPMENT PERMIT CENTER YTD AS OF JUNE 30, 2017 8/14/2017 9:28 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 2018/2017 11 Salaries 205.279 106,133 118,006 127,747 100,752 (5,381) 49% 8% (21)% 13 Overtime 1,847 - - - - 1,062 - - - 21 FICA 15,857 8,194 9,027 9,773 7,708 (487) 49% 8% (21)% 23 Pension-PERSIPSERS 24,651 12,687 10,591 14,046 11,264 (1.423) 46% 33% (20)% 24 Industrial lnsurance 1,059 555 470 527 371 (184) 35% 12% (30)% 25 Medical & Dental 60,663 31,183 25,739 33,757 30,271 (912) 50% 31% (10)% Total Salaries & Benefits 309,356 158,752 163,833 185,849 150,365 (8,386) 49% 13% (19)% 31 Supplies 3,000 941 165 699 1,182 241 39% 324% 69% 41 Professional Services 10,000 429 391 301 4,124 3,695 41% (23)% 1271% 42 Communication- (61)% 35 Small Tools - 110 - - - - - 43 Travel 3,700 24 472 - 24 68,648 1% - - 48 Repairs and Maintenance 42.000 4,237 - - 4,237 - 10% - - 49 Miscellaneous 31.500 16,687, 12.922 12,873 3,027 (13,660) 10% (0)% (76)% Total Operating Expenses 90,200 22,318 i1319 13,982 12,594 (9,724) 14% 0% (10)% (4)% (62)% 48 Repairs and Maintenance 550 - - - - - - Total Expenses 399,556 181,069 177,782 199,832 162,960 (18,110) 41% 12% (18)% Percent of year completed COMMUNITY DEVELOPMENT BUILDING, PERMIT AND PLAN REVIEW 50.00% YTD AS OF JUNE 30, 2017 8114/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2018 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED 8DGT %SPEND 2015/2016 2018/2017 11 Salaries 514.054 224,252 146,268 170,099 242.339 18,087 474 16% 42% 13 Overtime 3.500 1,496 1,381 1,062 1.762 266 50% (23)% 66% 21 FICA 39,527 17,206 11,120 12.913 18.509 1,303 47% 16% 43% 23 Pension-PERSIPSERS 63,053 27,856 13.445 19,136 26,505 (1,351) 42% 42% 39% 24 Industrial Insurance 9,261 3,158 1,383 1,502 3,216 58 35% 9% 114% 25 Medical & Dental 114,579 52,615 26.081 32,188 46,262 (6,352) 40% 23% 44% 28 Uniform/Clothing 2,500 - 99_ - - - - - - Total Salaries & Benefits 746,474 326,583 199,777 236,899 338,593 12,010 45% 19% 43% 31 Supplies 3,000 2,569 1,082 4,700 1,845 (724) 61% 334% (61)% 35 Small Tools 500 181 - - 181 - 36% - - 41 Professional Services 83,400 39,479 (19,153) 68,648 25,794 (13.685) 31% (458)% (62)% 42 Communication 500 305 55 606 132 (174) 26% 1008% (78)% 43 Travel 1,500 1,214 62 661 135 (1,078) 9% 969% (80)% 45 Rentals and Leases 4,251 4,251 5,794 5,563 2,126 (2,126) 50% (4)% (62)% 48 Repairs and Maintenance 550 - - - - - - - 49 Miscellaneous 8.850 1,582 14,424 4,662 2,955 1,373 33% (68)% (37)% Total Operating Expenses 102,551 49,580 2,263 84,840 33,166 (16,413) 32% 3649% (61)% Total Expenses 849,025 376,163 202,040 321,740 371,760 (4,403) 44% 59% 16% Percent of year completed 50.00% 93 COMMUNITY DEVELOPMENT PLANNING YTD AS OF JUNE 30, 2017 8114/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET r ACTUAL ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) 2017 % CHANGE ALLOCATED BDGT % SPEND 2015/2016 201612017 11 Salaries 814,661 410,830 379,628 372,765 392,855 (17,975) 48% (2)% 5°% 12 Extra Labor 45.500 30,805 26,709 8,797 4,107 (26,698) 9% (67)% (53)% 13 Overtime 1,847 1,847 474 570 393 (1,454) 21% 20% (31)% 21 FICA 68,197 34,710 30,916 28,917 30,053 (4,657) 44% (6)% 4%, 23 Pension-PERS/PSERS 97,819 49,993 35.390 41,739 43,899 (6,095) 45% 18% 5% 24 Industrial Insurance 3,000 1,506 1,181 1,128 1,141 (365) 38% (5)% 1% 25 Medical & Dental 129,811 66,966 49.014 51,183 54,863 (12,103) 42% 4% 7% Total Salaries & Benefits 1,160,835 596,657 523,312 505,099 527,311 (69,347) 45% (3)% 4%- 31 Supplies 8,000 2,521 2.127 1.554 2,721 199 34% (27)% 75% 41 Professional Services 64,000 45,629 85.335 14,174 5,550 (40,079) 9% (83)% (61)% 42 Communication 3,000- 46,000 - - - - - - 36% 43 Travel 2,000 123 188 46 689 566 34% (75)% 1395% 48 Repairs and Maintenance 8.135 8,135 8.132 8,104 4,237 (3,898) 52% (0)% (48)% 49 Miscellaneous 24,000 17,550 7,163 7,215 5,232 (12,318) 22% 1% (27)% Total Operating Expenses 109,135 73,958 102,945 31,092 18,428 (55,530) 17% (70)% (41)% Total Expenses 1,269,970 670,615 626,257 536,191 545,739 (124,877) 43% (14)% 2% Percent of year completed COMMUNITY DEVELOPMENT RECYCLING PROGRAM 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 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- - 6,348 7,152 2,777 2,777 - 13% (61)% '21 FICA - - 449 481 205 205 7% (57)% 23 Pension-PERSIPSERS - - 585 800 311 311 - 37% (61)% 24 Industrial Insurance- - 20 23 8 8 - 14% (64)% 25 Medical & Dental - - 625 895 22 22 - 43% (97)% Total Salaries & Benefits - 8,026 9,350 3,324 3,324 - 16% (64)% 31 Supplies 9,000 8,726 11,328 3,887 5.187 (3,540) 58% (66)% 33% 41 Professional Services 30,000 15,562 12,142 11,378 10,692 (4,871) 36% (6)% (6)% 49 Miscellaneous 7,000 1,848 1,817 1,484 598 (1,250) 9% (18)% (60)% Total Operating Expenses 46,000 26,137 ' 25,287 16,748 16,4 6 (9,66) 36% (34)% (2)% Total Expenses 46,090 26,137 33,313 26,098 19,800 (6,337) 43% (22)% (24)% Percent of year completed 94 50.00% COMMUNITY DEVELOPMENT TDM PROGRAM YTD AS OF JUNE 30, 2017 8/1412017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2018 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED BDGT %SPEND 2015/2016 2016/2017 11 Salaries 116,546 45,252- 30,620 57,620 12,368 49% - 88% 12 Extra Labor - 14,231 16,457 19,590 19,590 - 16% 19% 21 FICA 8,915 3,686 1,089 3,601 5,846 2.160 6614 231% 62% 23 Pension-PERS/PSERS 13,990 5,748 1,311 5,263 8,632 2,884 62% 302% 64% 24 Industrial Insurance 1,202 453 55 237 375 (77) 31% 332% 58% 25 Medical & Dental 18,116 6,569 - 2,919 5,485 (1,084) 30% - 88% Total Salaries & Benefits 158,769 61,708 16,686 59,098 97,549 35,841 61% 2540% 65% 31 Supplies 4,000 4.000 - 1,034 16,140 12.140 404% - 1460% 41 Professional Services 53,000 8,761 -- 8,761 - 17% - - 43 Traver 5,500 160 - 38 79 (81) 1% - 107% 49 Miscellaneous 16,500 4,014 654 10,548 43 (3.971) 096 1512% (100)0/ 51 Enter -Governmental 8,000 3,821 3,722 - 3,821 - 4896 - - Total Operating Expenses 87,000 20,756 4,376 11,621 28,843 8,088 33% 166°% 148°% Total Expenses 245,769 82,463 21,062 70,719 126,392 ' 43,929 51% 236% 79% Percent of year completed 50.00 % 95 MUNICIPAL COURT CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF JUNE 30, 2017 8114/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2019 2017 ACTUAL OWER!{UNDER) % CHANGE ALLOCATED BDOT %SPEND 2015/2016 2016/2017 11 Salaries 756,312 380,826 346,943 352,691 367,242 (13,584) 49% 2% 4% 12 Extra Labor 4,180 1,234 - 6,066 558 (676) 13% - (91)% 13 Overtime 4,661 592 434 320 - (592) - (26)% 21 FICA 57,112 28,728 25,931 27,089 27,702 (1,027) 49% 4% 2% 23 Pension-PERS/PSERS 90,616 45,051 32,594 40,310 41,285 (3,767) 46% 24% 2% 24 Industrial Insurance 3,477 1,607 1,238 1,275 1,321 (286) 38% 3% 4% 25 Medical & Dental 185,542 94,917 70,665 77,896 80,144 (14,773) 43% 10% 3% 26 Unemployment - - - _ 1,930 - - - - - Total Salaries & Benefits 1,101,900 552,956 477,805 507,577 518,252 (34,704) 47% 6% 2% 31 Supplies 14,283 6,417 5,544 5,592 9,243 2,827 65% 1% 65% 35 Small Tools - - 2,932 - 953 953 - - - 41 Professional Services 105,000 46,163 35,199 43,054 43,463 (2,700) 4154, 22% 1% 42 Communication 24,150 8,910 4,161 1,913 2,666 (6,244) 11% (54)% 39% 43 Travel 10,000 9,233 5,745 3,156 7,229 (2,004) 72% (45)% 129% 45 Rentals and Leases 2,000 2,000 872 872 3,404 1,404 170%0 0% 290% 48 Repairs and Maintenance 2,300 2,300 294 521 348 (1,952) 15% 77% (33)% 49 Miscellaneous 23,170 11,595 14,585 8,869 10.215 (1.380) 44% (39)% 15% 53 Ext Taxes, Assessments 5 - 2 - - - - - 64 Miscellaneous 25,000 - - - - - - - - Total Operating Expenses 205,908 86,617 69,335 63,978 77,521 (9,096) 38% (8)% 21% Total Expenses 1,307,808 639,574 547,139 571,555 595,773 (43,800) 46% 4% 4% Percent of year completed 96 50.00 % POLICE CITY OF TUKWILA GENERAL FUND EXPENDITURES YTO AS OF JUNE 30, 2017 8/14/2017 9:28 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 201512016 2016/2017 11 Salaries 9,003,291 4,529,523 4,177,926 4,233,834 4,309,912 (219.611) 48❑% 1% 2% 13 Overtime 928,495 433,647 525,198 403747 477,984 44,337 51% (23)% 18% 15 Holiday/Kelly Payoff 201,063 75297 - 77,875 74,220 (1,078) 37% - (5)% 21 FICA 756,032 378,821 356,951 357,418 370,027 (8793) 49% 0% 4% 22 Pension-LEOFF 2 472,077 230,828 212.317 211,992 216,053 (14,775) 46% (0)% 2❑% 23 Pension-PERS/PSERS 146,051 72,694 52,827 64,835 68.457 (4,236) 47% 23% 6% 24 Industrial Insurance 273,809 130,349 89,333 101,018 91.395 (38,953) 33% 13%❑ (10)% 25 Medical & Dental 1,933,791 984,903 876,059 936,581 895.899 (89,004) 46% 7% (4)% 26 Unemployment- - - 143 9,434 68 68 - _ _ 6493% (99)% Total Salaries & Benefits 13,714,609 6,836,063 6,290,754 6,396,734 6,504,016 (332,647) 47% 2% 2% 31 Supplies 180,850 121,230 94,062 132,232 146,490 25260 81% 41% 11% 35 Small Tools 15,600 3,541 7,800 358 3,186 (355) 20% (95)% 7911/4 41 Professional Services 70,000 29,138 26,620 30,173 22.619 (6,520) 32% 13%❑ (25)% 42 Communication 121,000 60,603 41,383 49,345 23,538 (37,065) 19% 19% (52)% 43 Travel 41,880 20,137 17,013 23,487 25,858 5,720 62% 38❑% 101/4 44 Advertising 1,500 400 - - 453 53 30% _ _ 45 Rentals and Leases 896,843 610,335 627,262 646,209 435.790 (174,545) 49% 3% (33)% 46 Insurance 230,223 230,223 240,000 240,000 230223 - 100% 0% (4)% 47 Public Utilities- - 1,159 1,097 1,488 1,488 - (5)% 36% 48 Repairs and Maintenance 188,922 97,880 89,286 73,596 24,392 (73,487) 13% (18)% (67)% 49 Miscellaneous 79,641 39,447 57,215 33,559 33.751 (5,696) 42% (41)% 1% 51 Inter -Governmental 2,747.024 1,371,634 1,112,124 1,162,871 1,347.445 (24,189) 49% 5% 16% 64 Machinery & Equipment- - - 311,636 - - - - Total Operating Expenses 4,573,483 -2,S84,5g8 2,313,923 2,704,562 2,295,231 (289,337) 50% 17% (15)% Total Expenses 18,288,092 9,420,630 8,604,677 9,101,296 8,799,247 (621,384) 48% 6% (3)% Percent of year completed POLICE DIVISION SUMMARY 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY DIVISION i BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER1(UNDER) % CHANGE ALLOCATED BDGT ° SPEND 2015/2016 2018)2017 ADMINISTRATION 1,794,634 1,011,996 952,773 1,236,607 1,034,447 22,451 58% 30% (16)% INVESTIGATION 2,147,558 1.070,782 1,069,824 1,127,770 1,147,446 76,664 53%❑ 51/4 2% PATROL 6,506.261 3.270,437 3,266,244 3,225,744 3,067,215 (203,222) 47% (1)% (5)% RECORDS/EVIDENCE 1,217,212 602,142 495,808 557,629 536,798 (65,345) 441/4 121/4 (4)% ANTI-CRIME 846,734 478,649 476,971 364,146 399,107 (79,542) 47% (24)% 10% PROFESSIONAL STANDARDS 2,021,287 1,022,515 779,185 888,884 774,121 (248,394) 380/0 14% (13)0/4 TRAINING 287,102 164,019 164,316 155,211 164.318 299 57% (6)%❑ 6% TRAFFIC 591,180 365,956 285.285 354,949 273,389 (92,567) 46% 24% (23)% FACILITIES 120,000 53.542 - - 55,300 1,758 46% - - PRISONERCARE & CUSTODY 1.509,914 757.331 628.445 676,234 739,058 (18,273) 49% 81/4 9'1/4 ANIMAL SERVICES 118,852 59.582 36,875 - 59,582 - 50% - - COMMUNICATION,DISPATCH 1,127,358 563,679 448,952 507,503 548,465 (15214) 49% 13% 8% SPECIAL SERVICES UNIT- - 6.619 - - - - - Total Expenses 18,288,092 9,420,630 8,604,677 9,101,296 8,799,247 (621,384) 48% 6% (3)%Z Percent of year completed 50.00% 97 POLICE ADMINISTRATION YTD AS OF JUNE 30, 2017 8/1412017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2016 2016 2017 ACTUAL OVERT{UNDER} % CHANGE ALLOCATED BDGT % SPEND 2016/2016 201612017 11 Salaries 929,989 460,853 457,824 448,316 559,370 98,517 60% (2)% 25% 13 Overtime 2,923 - 1,849 - - - - - - 21 FICA 62,064 34,088 34,268 32,488 40,922 6,834 66% (5)% 26% 22 Pension-LEOFF 46,693 21,816 21,700 19,260 21,537 (279) 46% (11)% 12% 23 Pension-PERSIPSERS 8.855 4,427 3,446 4.035 8,155 3,728 92% 17% 102% 24 Industrial Insurance 18,294 8.365 5,759 5.966 5,570 (2,795) 30% 4% (7)% 25 Medical & Dental 155.097 73,070 65,359 60.545 77,851 4,781 50% (7)% 29% Total Salaries & Benefits 1,223,915 602,619 590,206 570,609 713,406 110,787 58% (3)% 25% 31 Supplies 24,000 15,081 12,457 13.462 12,543 (2,538) 52% 8% (7)% 41 Professional Services 15,000 7,248 3,734 5.267 7,496 248 50% 41% 42% 42 Communication 121,000 60,603 12,350 19.300 8,043 (52,560) 7% 56% (58)% 43 Travel 10,000 5,060 3,675 2.769 2,483 (2,577) 25% (25)% (10)% 44 Advertising 1,100 - - - - 1 - - - - 45 Rentals and Leases 61,478 48,863 40,361 44,146 29,304 (19,559) 48% 9% (34)% 46 Insurance 230,223 230.223 240,000 240,000 230,223 - 100% 0% (4)% 48 Repairs and Maintenance 86.518 34,059 36,823 33.958 22,368 (11,691) 26% (8)% (34)% 49 Miscellaneous 5,500 2,324 3,084 2,081 2,665 341 48% (33)% 28% 51 Inter -Governmental 15.900 5,916 10,084 - 5,916- `Total Operating Expenses 37% - - 64 Machinery & Equipment 106,664 - - 305,016 - - - - - Total Operating Expenses 570,719 409,377 362,567 665,998 321,042 (88,335) 56% 84% (52)% 2,147,558 1,070,782 1,069,824 1,127,770 1,147,446 76,664 53% 5% 2% ITvtal Expenses 1,794,634 1,011,996 952,773 1,236,607 1,034,447 22,451 58% 30% (16)% Percent of year completed POLICE INVESTIGATION 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED BDGT % SPEND 201512016 201612017 11 Salaries 1,319,637 647,038 635,521 688,277 727,939 80,901 55% 8% 6% 13 Overtime 173.542 67,564 77,839 83,206 82,547 14,982 48% 7% (1)% 21 FICA 113.950 55,121 54,002 58,620 62,509 7,389 55% 9% 7% 22 Pension-LEOFF 72,920 34,610 33,778 36,724 37,742 3,132 52% 9% 3% 23 Pension-PERS/PSERS 15,918 7,945 5,908 7,280 7,295 (650) 46% 23% 01/4 24 industrial Insurance 41,629 19,325 13,473 16,831 15,247 (4,077) 37% 25% (9)% 25 Medical & Dental 264,160 137,678 116,551 130,166 129,414 (8,264) 49% 12% _ (1)% Total Salaries & Benefits 2,001,756 969,281 937,070 1,021,106 1,062,93 93,41 53% 9% 4% 31 Supplies 12,000 12,000 7,958 4,829 17,647 5.647 147% (39)% 265% 41 Professional Services 4,000 4,000 101 2,081 6,795 2.795 170% 1961% 227% 42 Communication- - 984 333 1,700 1,700 - (66)% 411% 43 Travel 5.000 3,472 4,177 4,410 790 (2,682) 16% 6% (82)% 45 Rentals and Leases 112.302 74,989 116,280 87,805 56,906 (18,083) 51% (24)% (35)% 47 Public Utilities - - 640 585 714 714 - (9)% 22% 48 Repairs and Maintenance 9,000 3,776 2.573 5,781 - (3,776) - 125% - 49 Miscellaneous 3,500 3,265 40 840 2013,064 6% 2000% (76)% `Total Operating Expenses ' 145,802 101,501 132,754 106,664 84,753 (6,748) 58% (20)% (21)% Total Expenses 2,147,558 1,070,782 1,069,824 1,127,770 1,147,446 76,664 53% 5% 2% Percent of year completed 98 50 00% POLICE PATROL YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2417 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER1(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 201612017 11 Salaries 3,599,974 1,792,944 1,819,467 1,721,533 1,702,455 (90,489) 47% (5)% (1)% 13 Overtime 553,184 241.903 246,300 178,762 256,734 14,831 46% (27)% 44% 15 Holiday Pay 201,063 75,297 - 77,875 74,220 (1,078) 37% - (5)°10 21 FICA 325,928 158,686 157.403 150,997 155,673 (3,013) 48% (4)% 3% 22 Pension-LEOFF 224,945 108,404 104.661 100,885 104.403 (4,001) 46% (4)% 3°10 23 Pension-PERS/PSERS 6,110 3,020 2,488 2,669 2,819 (200) 46% 7% 6% 24 Industrial Insurance 131,570 61,854 46,599 50,375 45,589 (16,265) 35% 8% (10)% 25 Medical & Dental 843,096 427.421 448,025 466,436 416,580 (10,841) 49% 4% (11)% Total Salaries & Benefits 5,885,870 2,869,529 2,824,943 2,749,531 2,758,473 (111,057) 47% (3)% 0°I0 31 Supplies 59,450 25.752 27.110 45,605 55,101 29,349 93% 68% 21% 35 Small Tools 600 600 7.800 358 245 (355) 41% (95)% (32)% 41 Professional Services 8,000 1.824 1.278 1,133 2,595 772 32% (11)% 129% 42 Communication - - 22.734 26,087 5,279 5,279 - 15% (80)% 43 Travel 500 396 91 276 170 (226) 34% 204% (39)% 45 Rentals and Leases 482,337 328,053 329.639 374,454 244.569 (83,484) 51% 14% (35)% 48 Repairs and Maintenance 65,404 42,411 44.294 25,445 26 (42,384) 0% (43)% (100)% 49 Miscellaneous 4,100 1,872 8.355 2,855 757 (1,115) 18% (66)% (73)°!0 Total Operating Expenses 620,301 400,907 441,301 476,213 308,742 (92,166) 50% 8% (35)% Total Expenses 1,217,212 602,142 495,808 557,629 536,798 (65,345) 44% Total Expenses 6,506,261 3,270,437 3,266,244 3,225,744 3,067,215 (203,222) 47% (1)% (6)1 Percent of year completed POLICE RECORDS/EVIDENCE 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVERI(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2018 2016/2017 11 Salaries 785.175 397,300 309,616 359,397 356,748 (40,552) 45% 16% (1)% 13 Overtime 32,248 11,959 41,503 16,764 19,223 7,264 60% (60)% 15% 21 FICA 60.929 30,260 26,480 28,352 28,428 (1,832) 47% 7% 0% 23 Pension-PERS/PSERS 97,109 48,073 30,403 41,574 41,526 (6,547) 43% 37% (0)1 24 Industrial Insurance 4,975 2,352 1,304 1.603 1,538 (814) 31% 23% (4)% 25 Medical & Dental 167.376 85,956 64,094 74,694 73,145 (12,812) 44% 17% (2)% 26 Unemployment- - 143 9,434 68 68 - 6493% (99)% Total Salaries & Benefits 1,147,812 575,899 473,544 531,818 520,016 (55,224) 45% 12% (2)% 31 Supplies 29,400 13.337 13,713 14,729 7,756 (5,581) 26% 7% (47)% 35 Small Tools 15,000 2,941 - - 2,941 - 20% - - 41 Professional Services 9,000 1,193 2,898 826 156 (1,037) 2% (71)% (81)% 42 Communication- - 2,971 472 2,882 2,882 - (84)% 511% 43 Travel - - - - 560 560 - - 45 Rentals and Leases- - 1,902 2.973 1,049 1,049 - 56% (65)% 48 Repairs and Maintenance 13.500 7,130 438 6,362 682 (6,448) 5% 1353% (89)1 49 Miscellaneous 2,500 1,642 _ 342 449 96 ! _ (1545) 4% 31% (78)% Total Operating Expenses 69,400 26,243 22,265 25,811 16,122 (10,121) 23% 161 (38)% Total Expenses 1,217,212 602,142 495,808 557,629 536,798 (65,345) 44% 12% (4)% Percent of year completed 50.00°1 99 POLICE ANTI-CRIME YTD AS OF JUNE 30, 2017 811412017 9:28 SUMMARY BY EXPENDITURE TYPEOVER/(UNDER) BUDGET ACTUAL COMPARISON OF RESULTS 2077 ANNUAL 2017 ALLOCATED 2015 2016 ' 2017 ACTUAL °f CHANGE ALLOCATED BOLT % SPEND 2016/2016 2016)2017 11 Salaries 495,212 267,859 262,841 193,824 221,348 (46,511) 45% (26)% 14% 13 Overtime 58,459 29,203 53,224 25,052 51,606 22;403 88% (53)% 106% 21 FICA 42,311 22,664 24,133 16,721 20,859 (1,804) 49% (31)% 25% 22 Pension-LEOFF 29,563 15,848 16,465 11,395 14,223 (1,624) 48% (31)% 25% 24 Industrial Insurance 16,666 8,547 6,594 5.074 5,722 (2,825) 34% (23)% 13% 25 Medical & Dental 105,001 56,121 52,712 41,763 45,736 (10,384) 44% (21)% 10% Total Salaries & Benefits 747,212 400,241 415,969 293,829 359,404 (40,746) 48% (29)% 22% 31 Supplies 2,000 1,602 510 1,745 567 (1,035) 28% 242% (68)% 42 Communication - - 141 1,348 2,890 2,890 - 853% 114% 43 Travel- - - - - 120 120 - - - 45 Rentals and Leases 86,522 75,149 58,273 65,123 35,179 (39,970) 41% 12% (46)% 48 Repairs and Maintenance 1,000 400- 64 - - - - - - 49 Miscellaneous 10,000 1,658 2,013 2.100 857 (801) 9% 4% (59)% Total Operating Expenses 99,522 7&409 61,002 70,316 39,613 (38, 95) 40% 15% (44)% 48 Repairs and Maintenance 1,000 820 1,606 449 42 (778) 4% (75)% (91)% Total Expenses 846,734 478,649 476,971 364,146 399,107 (79,542) 47% (24)% 10% Percent of year completed POLICE PROFESSIONAL STANDARDS 50.00% YTD AS OF JUNE 30, 2017 8/1412017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2018 2017 ACTUAL OVERI(UNDER) % CHANGE _ - ALLOCATED BDGT % SPEND 2015/2016 2018/2017 11 Salaries 1.396,260 678,366 465,487 542.417 506,481 (171,886) 36% 17% (7)% 13 Overtime 45,303 45,303 68,756 65,197 50,367 5.064 111% (5)% (23)% 21 FICA 110,001 53,402 40,707 46.381 42,503 (10,899) 39% 14% (8)% 22 Pension-LEOFF 72,707 34,671 23,795 29.122 26,756 (7,915) 37% 22% (8)% 23 Pension-PERS/PSERS 10.201 5,382 7,029 5,352 4,741 (641) 46% (24)% (11)% 24 Industrial Insurance 44.361 20,451 9,806 13.448 12,144 (8,306) 27% 37% (10)% 25 Medical & Dental 308,300 155,436 90,222 117,238 109,283 (46,153) 35% 30% (7)% Total Salaries & Benefits 1,987,133 993,01i 705,803 819,155 752375 (240,737) 38% 16°1. (8)% 31 Supplies 8,300 8,300 5,397 8,552 9.689 1,389 117% 58% 13% 42 Communication - - 2,202 1,770 1,519 1,519 - (20)% (14)% 43 Travel - - 1,132 1,659 (35) (35) - 47% (102)% 44 Advertising 400 400- 453 53 113% - - 45 Rentals and Leases 19,854 19,854 62,277 56.787 9,927 (9,927) 50% (9)% (83)% 47 Public Utilities - - 519 512 123 123 - (1)% (76)% 48 Repairs and Maintenance 1,000 820 1,606 449 42 (778) 4% (75)% (91)% 49 Miscellaneous 4.600 130 50- 130 - 3% - - Total Operating Expenses 34,154 29,504 '73,382 69,728 21,847 (7,657) 64% (5)% (89)% Total Expenses 2,021,287 1,022,515 779,185 888,884 774,121 (248,394) 38% 14°A° (13)% Percent of year completed 100 50.00% POLICE TRAINING YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL_ COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/GAGER) % CHANGE ALLOCATED BDGT % SPEW] 2015/2016 2016/2017 11 Salaries 100.189 50,044 48.385 49,447 49.447 (597) 49% 2% 0% 13 Overtime15,500 2015 7,042 14.082 10,018 4,507 (2,535) 29% (29)% (55)% 21 FICA 8,667 4,276 4,763 4,457 4,041 (235) 47% (6)% (9)% 22 Pension-LEOFF 6.174 3,035 3,254 3,097 2,809 (227) 45% (5)% (9)% 24 Industrial Insurance 3,413 1,540 1,150 1,234 1,097 (444) 32% 7% (11)% 25 Medical & Dental 20,038 10,015 6,917 9,302 9,127 (888)46% 34% (2)% Total Salaries & Benefits 153,981 73,953 78,550 77,555 71,027 (d,93$ 46% (1)% (8)% 31 Supplies 41,100 41,100 22,880 36.618 41,619 519 101% 60% 14% 41 Professional Services 9.000 - 6.377 - - - - - - 42 Communication - - - 1,225 1,225 - - - 43 Travel 26.380 11,209 7,938 14,373 21,769 10,560 83% 81% 51% 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 28,057 43,316 25,210 27,939 (118) 57% (42)% 11% Total Operating Expenses 133,121 88,066 85,766 77,656 93,291 5,22 70% (9)% 20% Total Expenses 287,102 164,019 164,316 155,211 164,318 299 57% (6)% 6% Percent of year completed POLICE FACILITIES 50.00 YTD AS OF JUNE 30, 2017 811 4/201 7 9:28 SUMMARY BY EXPENDITURE BUDGET ACTUAL COMPARISON OF RESULTS ACTUAL TYPE 2017 OVER/(UNDER) % CHANGE ALLOCATED 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 20/512016 201612017 45 Rentals and Leases 120,000 53,542 - - 53,542 - 45% - - 47 Public Utilities - - - - 651 651 - - - 49 Miscellaneous - - - - 1,106 1,106 - - - Total Operating Expenses 120,000 53,542 - - 55,300 1,758 46% Total Expenses 120,000 53,542 - - - 55,300 1,758 46% - - Percent of year completed 50.00% 101 POLICE TRAFFIC YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET i ACTUAL , COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL -OVER/(UNDER) % CHANGE ALLOCATED MGT % SPEND 201512016 201612017 11 Salaries 376,855 235.118 178,785 230,625 186,125 (48,993) 49% 29% (19)% 13 Overtime 47,336 30,673 21.645 24,747 13.001 (17,672) 27% 14% (47)% 21 FICA 32,182 20.324 15,194 19,401 15,091 (5,233) 47% 28% (22)% 22 Pension-LEOFF 19,075 12.444 8,665 11,510 8,583 (3,862) 45% 33% (25)% 23 Pension-PERSIPSERS 7,858 3.846 3,553 3,924 3,921 74 50% 10% (0)% 24 Industrial Insurance 12,901 7.916 4,649 6,488 4,489 (3,427) 35% 40% (31)%a, 25 Medical & Dental 70„723 39.206 32,179 36,437 34,763 (4,444) 49% 13% (5)% Total Salaries & Benefits 566,930 349,529 264,670 333,131 265,972 (83,557) 47% 26% (20)% 31 Supplies 4,600 4.057 4.038 6,693 1,568 (2,489) 34% 66% (77)% 42 Communication - - - 35 - - - - - 45 Rentals and Leases 9,150 4,686 13.551 13,770 4.575 (111) 50% 2% (67)% 48 Repairs and Maintenance 10,000 7.185 3.011 1,296 1.274 (5,911) 13% (57)% (2)% 49 Miscellaneous 500 500 15 24 - (500)- 57% - Total Operating Expenses 24,250 16,428 20,615 21,818 7,417 (9,011 31% 6% (66)% Total Expenses 4 591,180 365,956 285,285 354,949 273,389 (92,567) 46% 24% (23)% Percent of year completed 102 50.00% POLICE PRISONER CARE & CUSTODY YTD THROUGH PERIOD 6 8/14/2017 9:28 Percent of year completed POLICE ANIMAL SERVICES 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY BY EXPENDITURE 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ACTUAL TYPE 2015/2016 2016/2017 2017 118.852 59.582 36.875 OVERI(UNDER) 59.582 % CHANGE ALLOCATED - lTotal Operating Expenses 118,852 59,582 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 41 Monitoring of Prisoners 25.000 14,874 12.232 20,866 5.576 (9,297) 22% 71% (73)% 51 Score Jail 1.484.914 742,457 616.214 655,368 733.482 (8,975) 49% 6% 12% Total Operating Expenses 1,509,914 757,331 628,445 676,234 739,058 (18,273) 49°% 8% 9% Percent of year completed POLICE ANIMAL SERVICES 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 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 King County Animal Control 118.852 59.582 36.875 - 59.582 - 50°I - lTotal Operating Expenses 118,852 59,582 36,875 - 59,582 - 50% - Percent of year completed POLICE COMMUNICATION, DISPATCH 50,00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 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 1,127,358 563,679 563,679 _ 448,952 448,952 507.503 507,503 548,465 548,465 (15,214) (15,214) 491 49% 13% 13% - 8% a% Total Operating Expenses Percent of year completed POLICE SPECIAL SERVICES UNIT 50 00'' YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) °% CHANGE ALLOCATED BDGT % SPEND 201512016 2016/2017 64 Machinery & Equipment - - - 6.619 - - - Total Operating Expenses- - - 6,619 - - Percent of year completed 50 00'V, 103 FIRE CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER1(UNDER) % CHANGE ALLOCATED SOOT % SPEND 201512016 2046/2017 11 Salaries 6,888,744 3,384,881 3.416,826 3,467,487 3,583,376 198,495 52% 1% 3% 12 Extra Labor - - 340 8,416 1,852 1,852 - 2375% (78)% 13 Overtime 650,648 291,769 330,463 222,969 288,604 (3,165) 44% (33)% 29% 15 Holiday Pay 324,520 2.076 4,767 1,465 - (2.076) - (69)% - 21 FICA 125,292 58.865 58,134 59,020 65.717 6,851 52% 2% 11% 22 Pension-LEOFF 2 377,176 173,606 178,539 180,824 188,369 14,763 50% 1% 4% 23 Pension-PERS/PSERS 44,621 22.395 16,691 20,806 21,025 (1,370) 47% 25% 1% 24 Industrial Insurance 368.655 170,495 115,972 132,064 135,153 (35,341) 37% 14% 2% 25 Medical & Dental 1,454,547 727,965 784.487 810,478 754,635 26,670 52% 3% (7)% Total Salaries & Benefits 10,234,203 4,832,050_ 4,906,219 4,903,529 5,038,731 206,681 49% (0)% 3% 31 Supplies 234,477 120.947 148,097 122,307 134,808 13,861 57% (17)% 10% 35 Small Tools 37,268 4,228 156,408 - 4,228 - 11% - - 41 Professional Services 81,000 54,373 22,354 26,287 10,414 (43,960) 13% 18% (60)% 42 Communication 32,170 16,077 27,767 19,395 6,179 (9,897) 19% (30)% (68)% 43 Travel 7,000 4,059 8,866 4,415 9,938 5,879 142% (50)% 125% 45 Rentals and Leases 587,241 420.963 269,813 267,784 294,999 (125.964) 50% (1)% 10% 46 Insurance 173,286 173.286 90,000 90,000 173,286 - 100% 0% 93% 47 Public Utilities 73.360 33,487 33,643 34,658 42,898 9,410 58% 3% 24% 48 Repairs and Maintenance 41,921 28,509 23,159 32,164 31,091 2,582 74% 39% (3)% 49 Miscellaneous 148,874 74,164 42.796 41,275 86,183 12,019 58% (4)% 109% 51 Inter -Governmental 211,768 105,884 77,326 95.495 100,010 (5,875) 47% 23% 5% 64 Machinery & Equipment- - - 13,934 13,934 - - Total Operating Expenses 1,628,365 1,035,976 900,228 733,779 907,966 (128,010) 56% (18)% 24% Total Expenses _ 11,862,568 5,868,026 5,,806,447 5,637,308 5,946,696 78,670 50% (3)% 5% Percent of year completed FIRE DIVISION SUMMARY 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY DIVISION BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2018 2017 ACTUAL OVER►(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 201512017 ADMINISTRATION 867,812 527,711 422,155 428.897 498,069 (29,643) 57% 2% 16% SUPPRESSION 8,944,102 4.350,068 4,376,662 4,285,947 4,407,559 57,491 49% (2)% 3% PREVENTION 833,040 396,562 389,195 393,125 415,589 19,027 50% 1% 6°/u TRAINING 448,048 233.647 191.972 189,421 261,857 28,210 58% (1)% 38% EMERGENCY PREPAREDNESS 351,305 158.215 283,039 162,611 175,874 17,659 50% (43)% 8% FIRE FACILITIES 110,860 48.308 41,125 40,705 53,195 4,887 48% (1)% 31% HAZARDOUS MATERIALS UNIT 39,883 35,139 9,580 26,311 8,942 (26,198) 22% 175% (66)% RESCUE TEAM 13,250 157 120 - 157 - 1% - - RESCUE AND EMERGENCY AID 42.500 12,334 15,274 14,797 25.447 13,113 60%© (3)% 72% COMMUNICATION - DISPATCH 211,768 105,884 77,326 95,495 100,010 (5,875) 47% 23% 5% Total Expenses 11,862,568 5,868,026 5,806,447 5,637,308 5,946,696 _ 78,670 50% (3)% 5% Percent of year completed 104 50.00% FIRE ADMINISTRATION YTD AS OF JUNE 30, 2017 8/1412017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVERI(UNOER) ACTUAL OVER/(UNDER)CHANGE o CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 11 Salaries 442,193 221,022 215.342 221,545 209,703 (11.318) 47% 3% (5)% 12 Extra Labor- 13 Overtime - - 4,473 - - - - - 13 Overtime 464 - 25 4,767 - - - - - 21 FICA 14,064 6,103 6,896 7.253 11,042 4,939 79% 5% 52% 22 Pension-LEOFF 15,763 1,561 7,738 8,022 7,381 5,820 47% 4% (8)% 23 Pension-PERS/PSERS 15,956 8,040 5,917 7,438 7,358 (682) 46% 26% (1)% 24 Industrial Insurance 9,186 4,414 3,136 3,568 3,579 (836) 39% 14% 0% 25 Medical& Dental 76,702 38,877 36,781 34,910 40,177 1,300 52% (5)% 15% Total Salaries & Benefits 574,328 2$0,018 273,$36 23'7,209 279,240 (777) 49% 4% (3)% 31 Supplies 10,877 3,876 18,138 3.887 3,708 (169) 34% (79)% (5)% 41 Professional Services 25,000 25,000 2,660 2.137 - (25,000) - (20)% - 42 Communication 23.170 11,540 12,479 13.157 2,467 (9.073) 11% 5% (81)% 43 Travel 2,250 559 15 - 559 - 25% - - 45 Rentals and Leases 25,897 20,573 10,658 10.558 12,414 (8,160) 48% (1)% 18% 46 Insurance 173,286 173,286 90.000 90,000 173,286 - 100% 0% 93% 48 Repairs and Maintenance 20,421 8,509 9,760 8,478 8,496 (13) 42% (13)% 0% 49 Miscellaneous 12,583 4,350 2,609 1,892 3,966 (385) 32% (27)% 110% 64 Machinery & Equipment - - - 11.578 13,934 13,934 - 20% Total Operating Expenses 293,484 247,694 146,319 144,688 218,828 (28,865) 75% (3)% 54% 3% Total Expenses 867,812 527,711 422,155 428,897 498,069 (29,643) 57% 2% 16% Percent of year completed FIRE SUPPRESSION 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER)CHANGE ALLOCATED BDGT % SPEND 2016/2016 2016/2017 11 Salaries 5,434,650 2,674,811 2.709,496 2,748,755 2,824,876 150,064 52% 1% 3% 13 Overtime 560.822 251,981 288,965 184,479 246,180 (5,801) 44% (36)% 33% 15 Holiday Pay i 324.520 2,076 4,767 1,465 - (2,076) - (69)% - 21 FICA 84.525 39,679 38,152 38,333 40.212 533 48% 0% 5% 22 Pension-LEOFF 318,206 151,356 150,288 151,965 159,964 8,608 50% 1% 5% 24 Industrial Insurance 328,667 152,373 102,831 117.003 119,531 (32,842) 36% 14% 2% 25 Medical & Dental 1,210,861 606,117 673.452 698.557 637,886 31,769 53% 4% (9)% Total Salaries & Benefits 8,262,251 3,878,393 3,981,931 3,940,557 4,028,649 150,257 49% (1)% 2% 31 Supplies 129,100 85,137 103,812 80,831 90,953 5,816 70% (22)% 13% 35 Small Tools 12,000 4.228 30,924 - 4,228 - 35% - - 41 Professional Services 26,500 4,901 16,639 4,661 7,269 2,368 27% (72)% 56% 42 Communication- - 38 10 11 11 - (73)% 5% 43 Travel - - 6,202- - - - - - 45 Rentals and Leases 471,460 348,472 227,311 224,178 235,880 (112,592) 50% (1)% 5% 48 Repairs and Maintenance 20,000 20,000 12,400 23,330 22,265 2,265 111% 88% (5)% 49 Miscellaneous 22.791 8,938 11,385 12,380 18,305 9,367 80% 9% 48% Total Operating Expenses 681,851 471,676 408,711 345,391 378,910 (92,765) 56% (15)% 10% Total Expenses 8,944,102 4,350,068 4,376,662 4,285,947 4,407,559 57,491 49% (2)% 3% Percent of year completed 50.00% 105 FIRE PREVENTION/INVESTIGATION YTD AS OF JUNE 30, 2017 8/14/2017 9:28 1 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNaE} ALLOCATED EDGT % CHANGE ALLOCATED BDGT '% SPEND 2015/2016 2016!2017 11 Salaries 558,405 272,018 275,453 273.509 276,404 4,386 49% (1)% 11/4 13 Overtime 61,143 23,128 27,992 23,693 33,146 10,019 54% (15)% 40% 21 FICA 18,205 8,898 9,210 9203 9,446 549 52% (0)% 3% 22 Pension-LEOFF 23,426 10,919 10,593 10,554 10,811 (107) 46% (0)% 2% 23 Pension-PERSIPSERS i 18.383 9,194 7,197 8,857 9,002 (192) 491/4 23% 2% 24 Industrial Insurance 17,123 7,353 5,391 5,855 6,558 (795) 38% 9% 12% 25 Medical & Dental 87,040 42,223 36,870 38,828 43,176 954 50% 5% 11% Total Salaries & Benefits 783,725 373,73'1 372,704 370,499 388,545 14,813 50% (1)% 5°% 2,250 1,400 1,400 2,800 550 A 0% 100% 42 Communication- 31 Supplies 12,000 6,075 1,466 7,211 4,289 (1,786) 36% 392% (41)% 41 Professional Services 5,000 2,222 1,655 329 - (2,222)- 107% (80)% - 42 Communication - - 713 1,080 63 63 - 51% (94)% 43 Travel 1,500 1,500 303 721 2,132 632 142% 138% 195% 45 Rentals and Leases 23,815 9.390 10,879 11,209 13.670 4,281 57% 3% 22% 48 Repairs and Maintenance - - 244 84 330 330 - (65)% 292% 49 Miscellaneous 7,000 3.643 1,230 1,992 6,559 2,917 94% 62% 229% Total Operating Expenses 49,315 22,830 16,490 22,626 27,044 4,214 55% 37% 20% Total Expenses 833,040 396,562 389,195 393,125 415,589 19,027 50% 1% 6% Percent of year completed FIRE TRAINING 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVERT(UNDER) % CHANGE ALLOCATED EDGT % SPEND 2015/2016 2015/2017 11 Salaries 234,680 113,257 114,114 116,461 146.489 ' 33.232 62% 2% 26% 13 Overtime 18.813 12,245 9,106 4,123 8.530 (3,715) 45% (55)% 107% 21 FICA 1.818 835 865 837 1,680 846 92% (3)% 101% 22 Pension-LEOFF 12,678 6,266 6,392 6.254 6,661 395 53% (2)% 7% 24 Industrial Insurance 8,884 4,158 3,055 3.477 3,822 (337) 43% 14% 10% 25 Medical & Dental 43,357 21,905 20,074 20,122 15,175 (6,731) 35% 0% (25)% Total Salaries & Benefits 320,230 158,667 153,Mr 151,273 182,356 23,689 57% (2)% 21% 31 Supplies 8,500 5,098 2.317 2,322 3,722 (1,376) 44% 0% 60% 41 Professional Services 4,500 2,250 1,400 1,400 2,800 550 62% 0% 100% 42 Communication- - 480 480 80 80 - 0% (83)% 43 Travel 2,000 2,000 2,038 3,491 7,234 5,234 362% 71% 107% 45 Rentals and Leases 16,818 8.724 5,822 5,938 8,409 (315) 50% 2% 42% 49 Miscellaneous 96,000 56.909 26,310 24,516 57,257 348 60% (7)% 134%_ Total Operating Expenses 127,818 74,981 38,366 38,148 79,501 4,520 62% (1)% 108% Total Expenses 448,048 233,647 191,972 189,421 261,857 L 28,210 58% (1)% 38% Percent of year completed 50.00% 106 FIRE EMERGENCY PREPAREDNESS YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET r ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER(UNDER) %CHANGE ALLOCATED BDGT %, SPEND 201512016 2016/2017 11 Salaries 218,816 103,773 102,421 107,218 125,905 22,131 58% 5% 17% 12 Extra Labor - - 340 3,943 1,852 1,852 - 1060% (53)% 13 Overtime 9,406 4,415 4,374 10,674 748 (3,667) 8% 144% (93)% 21 FICA 6,680 3,350 3.013 3,394 3,335 (15) 50% 13% (2)% 22 Pension-LEOFF 7,103 3,504 3,52.8 4.030 3,552 48 50% 14% (12)% 23 Pension-PERS/PSER5 10,282 5,160 3.577 4.510 4,665 (495) 45% 26% 3% 24 Industrial Insurance 4,795 2,196 1,560 2.161 1,664 (532) 35% 39% (23)% 25 Medical & Dental 36,587 18,843 17,310 18,061 18,221 (623) 50% 4% 1% Total Salaries & Benefits 293,669 141,241 136,122 153,991 159,941 -1 b9 54% 13% 4% 31 Supplies 12,000 3,884 3,366 11,900 5,179 1,295 43% 253% (56)% 35 Small Tools 24,268 - 125,303 - - - - - 42 Communication - - 12,790 3,562 2,461 2,461 - (72)% (31)% 43 Travel - - 308 202 14 14 - (34)% (93)% 45 Rentals and Leases 16,368 12,766 3,587 3,767 8,184 (4,582) 50% 5% 117% 48 Repairs and Maintenance - - 756 272 - - - (64)% - 49 Miscellaneous 5.000 324 806 495 96 (228) 2% (39)% (81)% 64 Machinery &'Equipment - - - (11,578) - - - - - Total Operating Expenses , 57,636 16,974 146,917 8,620 15,933 OW) 28% (94)% 85% Total Expenses 1 351,305 158,215 283,039 162,611 175,874 17,659 50% (43)% 8°10 , Pereent of year completed FIRE FACILITIES 50.00% YTD AS OF JUNE 30, 2017 8114)2017 9:28 Percent of year completed 50.00% 107 BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY BY ACTUAL EXPENDITURE TYPE 2017 OVER1(UNDER) % CHANGE ALLOCATED 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 201612017 31 Supplies 28,500 10.285 6,214 4,942 9,199 (1,085) 32% (20)% 86% 42 Communication 9,000 4,536 1,267 1,105 1,098 (3,439) 12% (13)% (1)% 47 Public Utilities 73,360 33.487 33,643 34,658 42,898 9,410 58% 316 24% Total Operating Expenses 110,860 48,308 41,125 40,705 53,195 4,887 48% (1)% 31% Total Expenses 110,860 48,308 41,125 40,705 53,195 4,887 4816 (1)% 31% Percent of year completed 50.00% 107 FIRE HAZARDOUS MATERIALS UNIT YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL oVERI[UNDERj %CHANGE ALLOCATED BDGT % SPEND 201512016 201612017 31 Supplies 35 Small Tools 41 Professional Services 45 Rentals and Leases 49 Miscellaneous 2,000 20.000 17,883 - - - 20,000 15,139 - 800 181- - 8,14-4 455 - 17,760 8.550 - - - - 8,942 - - (20,000) (6,198) - - - - 50% - - - - 5% - - - - 5% - Total Operating Expenses 39,883 35,139 9,580 26,311 8,942 (26,198) 22% 175% (66)% BDGT % SPEND 2015/2016 2016/2017 31 Supplies 5,000 157 120 - 157 - Total Expenses 39,883 35,139 9,580 26,311 8,942 (26,198) 22% 175% (66)% Percent of year completed FIRE RESCUE TEAM 50.00% YTD AS OF JUNE 30, 2017 811412017 9:28 r SUMMARY BY BUDGET ACTUAL COMPARISON OF RESULTS ACTUAL EXPENDITURE TYPE 2017 OVERT€UNDER} % CHANGE ALLOCATED 2017 ALLOCATED 2015 2016 2017 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016/2017 31 Supplies 5,000 157 120 - 157 - 3% - - 35 Small Tools 1,000 - - - - - - - - 43 Travel 1,250 - - - - - - - - 48 Repairs and Maintenance 500 - - - - - - - 49 Miscellaneous 5,500- 12,334 - - - - - - - Total Operating Expenses 13,250 157 120 - 157 - 1% - - Total Expenses 42,500 12,334 15,274 14,797 25,447 13,113 Total Expenses 13,250 157 120 - 157 - 1% - - Percent of year completed FIRE RESCUE AND EMERGENCY AID 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY BUDGET ACTUAL COMPARISON OF RESULTS ACTUAL EXPENDITURE TYPE 2017 OV£RRUNDERJ % CHANGE ALLOCATED 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 201512016 201612017 31 Supplies 26.500 6,436 11,861 11.214 17,602 11,166 66% (5)% 57% 41 Professional Services - - - - 344 344 - - - 45 Rentals and Leases 15,000 5,898 3.413 3,583 7,500 1,602 50% 5% 109% 48 Repairs and Maintenance 1,000 - - - - - - - Total Operating Expenses 42,500 12,334 15,27 14,797 25,447 13,113 60% (3)% 72% Total Expenses 42,500 12,334 15,274 14,797 25,447 13,113 60% (3)% 72% Percent of year completed 108 50.00% FIRE COMMUNICATIONS, ALARMS AND DISPATCH YTD AS OF JUNE 30, 2017 8114/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2016 2016 2017 ,ACTUAL OVERAUNDER) % CHANGE ALLOCATED BDGT % SPEND 201512016 2016/2017 51 Inter -Governmental 211.768 105.884 77,326 95.495 100.010 (5.875) 47% 23% 5% Total Operating Expenses 211,768 105,884 77,326 95,495 100,010 (5,875) 47% 23% 5% Tota! Expenses 211,768 105,884 77,326 95,495 100,010 (5,875) 47% 23% 5% Percent of year completed 50.00! 109 TECHNOLOGY & INNOVATION SERVICES CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) °% CHANGE ALLOCATED BDGT %SPEND 201512016 2016/2017 11 Salaries 869,292 495,486 259,426 370,417 341.596 (153,891) 39% 43% (8)% 12 Extra Labor 2,500 2,500 7,651 1,057 - (2,500) (86)% - 13 Overtime - - 9,598 12.513 41,004 41,004 - 30% 228% 21 FICA 63,632 34.870 20,710 28,725 28,858 (6,012) 4596 3914 0% 22 Pension-LEOFF 2 - - - 3,488 - - - - - 23 Pension-PERSIPSERS 104,269 47,166 25,174 29,141 42,775 (4,392) 4196 16°/0 47% 24 Industrial Insurance 3,176 1,998 1,238 1,906 1,063 (935) 33% 54°% (44)% 25 Medical & Dental 194,560 104,987 55,841 70,010 69,829 (35,158) 36% 25% (0)96 Total Salaries_& Benefits _ 1,237,429 _687,008 379,638 517,257 525,124 (161,883) 42% 36% 2°% 31 Supplies 6,266 6,266 4,908 2,435 22,048 15,782 352% (50)% 806% 35 Small Tools - - 15.868 8,035 17,895 17,895 - (49)% 123%c 41 Professional Services 304,686 7,579 23.454 3,434 44,684 37,104 15% (85)% 1201%. 42 Communication 120.900 44,796 61.867 48,009 114,798 70,002 95% (22)% 139% 43 Travel 11,500 6,151 - - 6,151 - 53% - - 45 Rentals and Leases 153,839 56,869 3.129 3,239 3,327 (53.543) 2% 4%6 3% 48 Repairs and Maintenance 2,000 2,000 12,209 2,747 8,996 6,996 450% (78)% 227% 49 Miscellaneous 147,200 35,516 11.875 9,335 37,865 2,348 26% (21)% 306% 64 Machinery & Equipment 43,000 - 9,341 - - - - - - Total Operating Expenses 789,391 159,179 142,651 77,233 255,763 96,584 3294 (46)% 231% Total Expenses 2,026,820 846,187 522,289 594,490 780,887 (65,299) 3914 14% 3196 Percent of year completed 110 50.00% PUBLIC WORKS CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/{UNDER) % CHANGE ALLOCATED BDGT % SPEND 201512016 2016/2017 11 Salaries 1,912,661 954,216 936,610 942,309 866,537 (67,679) 45% 1% (8)% 13 Overtime 10,000 10,000 7,270 7,806 10,438 438 104% 7% 34% 21 FICA 141,515 72,619 70,960 71,550 66,001 (6,619) 47% 1% (8)% 23 Pension-PERS/PSERS 229,639 115,470 85,407 105,604 97,447 (18,023) 42% 24% (8)% 24 Industrial Insurance 36,725 17,557 11,505 13,223 11,798 (5,759) 32% 15% (11)% 25 Medical & Dental 377,031 187,460 159,861 171,010 174,700 (12.759) 46% 7% 2% 26 Unemployment - - - 10,547 - - - - - 28 Uniform/Clothing 3,200 1,230 421 586 180 (1.049) 6% 39% (69)% Total Salaries & Benefits 2,710,771 1,358,551 1,272,034 1,322,636 1,227,102 (131,450) 45% 4% (7)% 31 Supplies 110,950 51,525 37,667 50,078 47254 (4,271) 43% 33% (6)% 35 Small Tools 4,250 814 107 369 602 (212) 14% 244% 63% 41 Professional Services 30,900 1,746 16,572 8,036 8,330 6,584 27% (52)% 4% 42 Communication 9,150 2,957 2,452 2,454 3,000 43 33% 0% 22% 43 Travel 2,000 1,513 777 308 475 (1,037) 24% (60)% 54% 44 Advertising -- 463 - - - 45 Rentals and Leases 162,978 78,341 78,719 76,317 76,803 (1,538) 47% (3)% 1% 46 Insurance 106,805 106,805 - 106,805 107,271 466 100% - 0% 47 Public Utilities 375,000 162,875 152,058 158,361 191,306 28,431 51% 4% 21% 48 Repairs and Maintenance 252,300 93,983 121,552 88,667 94,814 831 38% (27)% 7% 49 Miscellaneous 30,035 9,956 6,147 6,607 10,518 561 35% 7% 59% 64 Machinery & Equipment 7,500 - - - 6,890 6,890 92% - - Operating Expenses 1,091,868 510,516. 416,051 498,465 547,264 36,749 50% 20/ 10% ,Total Total Expenses 3,802,639 1,869,067 1,688,085 1,821,101 1,774,366 (94,701) 47% 8% (3)% Percent of year expired PUBLIC WORKS DIVISION SUMMARY 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 ' BUDGET ACTUAL COMPARISON OF RESULTS ACTUAL SUMMARY BY DIVISION OVER/{UNDER) % CHANGE 2017 ALLOCATED 2017 ANNUAL ALLOCATED 2015 2016 2017 SOOT 'I SPEND 2015/2016 2016/2017 ADMINISTRATION 451,700 229,057 276,383 291,681 215,728 (13,329) 48% 6% (26)% MAINTENANCE ADMINISTRATION 393,700 194,719 182,580 187,587 189,718 (5.001) 48% 3% 1% PUBLIC WORKS DEVELOPMENT 486,910 248,045 229,060 233,015 245,496 (2,549) 50% 2% 5% ENGINEERING PLANS AND SERVICE: 643,476 302,789 255,540 247,479 208,873 (93,916) 32% (3)% (16)% FACILITY MAINTENANCE 1.819,353 894,457 744,521 861,339 907,661 13,204 50% 16% 5% Total Expenses 3,795,139 1,869,067 1,688,085 1,821,101 1,767,476 (101,591) 47% 8% (3)% Percent of year expired 50.00% 111 PUBLIC WORKS ADMINISTRATION YTD AS OF JUNE 30, 2017 8/1412017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2015 2017 ACTUAL OVER1(UNDER) ACTUAL OVERIIUNDER) % CHANGE ALLOCATED 9DGT % SPEND 2015/2016 2016/2017 11 Salaries 316,783 168,272 207,721 215,473 155,767 (12,505) 49% 4% (28)% 21 FICA 21,520 12,588 15,402 16,030 11,593 (996) 54% 4% (28)% 23 Pension-PERSIPSERS 38,030 20,961 18,857 23,842 17,249 (3,712) 45% 26% (28)% 24 Industrial Insurance 1,059 575 489 531 364 (211) 34% 9% (31)% 25 Medical & Dental 37,880 19,627 23,105 24,899 22,712 3,085 60% 8% (9)% Total Salaries & Benefits 415,272 222,024 265,5Td"- 280,775 207,681^ (14,339) 50% 6% (26)% 31 Supplies 9,000 2,755 3,300 3,634 4,327 1,572 48% 10% 19% 41 Professional Services -- (77)°% 3,645 4,723 - - - 30% - 42 Communication 1.500 761 864 594 40 (721) 3% (31)% (93)% 43 Travel 200 200 194 2 8 (192) 4% (99)% 312% 45 Rentals and Leases 3.428 1,479 1,447 1,447 1,454 (25) 42% 0% 0% 48 Repairs and Maintenance 1.300 499 707 450 360 (139) 28% (36)% (20)% 49 Miscellaneous 21,000 1,338 650 55 1,853 515 9°% (92)% 3269°.4 Total Operating Expenses 36,428 7,032 10,809 10,906 8,042 -- 1,010 22% 1%m (26)% Total Expenses Total Expenses 451,700 229,057 276,383 291,681 215,728 (13,329) 48% 6% (26)% Percent of year expired PUBLIC WORKS MAINTENANCE ADMINISTRATION 50 00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVERIIUNDER) % CHANGE - ALIOCATED BDGT %SPEND 201512016 2016/2017 11 Salaries 259,225 129,893 126,685 127,667 129,292 (601) 5054 154 1% 21 FICA 18,422 9,549 9,510 9,454 9,624 75 52% (1)54 2% 23 Pension-PERS)PSERS 31.120 15,560 11,555 14,212 14,342 (1,218) 46% 23°% 1% 24 Industrial Insurance 1.059 513 315 424 371 (141) 35% 35% (12)% 25 Medical & Dental 63,466 31,697 27,349 29,381 31,694 -185,323 (3) 50°/° 7% 8% Total Salaries & Benefits 373,292 187,211 175,414 181,137 (1,888) 50% 3% 2% Y- 31 Supplies 4,250 940 2,154 488 241 (699) 6% (77)°% (51)% 35 Small Tools 750 - - - - - - - - 41 Professional Services 500 42 Communication 750 402 387 389 58 (344) 8% 0% (85)% 43 Travel 300 300 21 213 412 112 137% 913% 94% 45 Rentals and Leases 11,823 4,247 3,729 3,825 3,244 (1,003) 27% 3% (15)% 49 Miscellaneous 2,035 1,618 875 1,535 440 (1,178) 22°10 75% (71)% Total Operating Expenses _ 20,408 7,508 /JP 6,449 4,395 (3,113) 22°10 (10)% (32)% Total Expenses 393,700 194,719 182,580 187,587 189,718 (5,001) 48% 3% 154 Percent of year expired 112 50.00% PUBLIC WORKS PUBLIC WORKS DEVELOPMENT YTD AS OF JUNE 30, 2017 8(1412017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 2015 2016 2017 ACTUAL OVERI(UNDER) % CHANGE ALLOCATED % SPEND 201512016 2016/2017 11 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 2016(2017 11 Salaries 334,218 167.252 162,458 164,164 164,218 (3,034) 49% 1% 0% 13 Overtime 9,000 9,000 5,172 1,999 10,192 1,192 113% (61)% 4105/0 21 FICA 26,120 13,055 12,668 12,622 13,230 175 51% (0)% 5% 23 Pension-PERS/PEERS 40,123 20,053 15,395 18,546 19,462 (591) 49% 20% 5% 24 Industrial Insurance 3,793 1,748 1,529 1,448 1,544 (204) 41% (5)% 7/0 25 Medical & Dental 73,406 36,688 31,657 34,057 36,672 (16) 50% 8% 8% 28 Uniform/Clothing 250 250 180 180 180 (70) 72% 0% 0% Total Salaries & Benefits 486,910 248,045 229,060 ' 233,015 245,496 (2,549) 50% 2% 5% Total Expenses 486,910 248,045 229,060 233,015 245,496 (2,549) 50% 2% 5% Percent of year expired PUBLIC WORKS ENGINEERING PLANS AND SERVICES 50.00% YTD AS OF JUNE 30, 2017 8/1412017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED BDGT % SPEND 201512016 2016/2017 11 Salaries 419,575 206,043 172,822 171,015 132,845 (73,198) 32% (1)% (22)% 21 FICA 30,825 15,577 13,048 12,904 9,969 (5,608) 32% (1)% (23)% 23 Pension-PERSIPSERS 50,370 24,631 15,806 18,962 14,694 (9,938) 29%m 20% (23)% 24 Industrial Insurance 6.174 3,002 1,301 1,235 1,018 (1,984) 16% (5)% (18)% 25 Medical & Dental 73,401 36,169 25,517 25,556 20,125 (16,043) 27% 0% (21)% 28 Uniform/Clothing 950 - - - - - - - - Total Salaries & Benefits 581,295 285,422 228,494 229,672 178,651 (106,771) 31% 1% (22)% 31 Supplies 7,000 1,740 1,808 1,658 2,897 1,158 41% (8)% 75% 35 Small Tools 1,000 - - - - - - - - 41 Professional Services 28,400 1,625 ' 12.687 3,220 8.211 6.586 29% (75)% 155% 42 Communication 2,300 1,355 1,009 998 100 (1,255) 4% (1)% (90)% 43 Travel 1,500 1.013 561 94 55 (957) 4% (83)% (41)% 44 Advertising - - - 463 - - - - - 45 Rentals and Leases 14,981 4,634 6,152 6.408 7,491 2,856 50% 4% 17% 48 Repairs and Maintenance 1,000 1,000 463 512 4,275 3,275 427% 11% 734% 49 Miscellaneous 6,000 6,000 4,365 4,454 7,193 1,193 120% 2% 61% Total Operating Expenses 62,181 17367 27,046 17,807 30,222 12,855 49% (34)% 70% Total Expenses 643,476 302,789 255,540_ _ 247,479 208,873 (93,916) 321 (3)% (16)% Percent of year expired 50.00% 113 PUBLIC WORKS FACILITY MAINTENANCE YTD AS OF JUNE 30, 2017 8114/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVERJ(UNOER) % CHANGE ALLOCATED BDGT % SPEND 201512016 201612017 11 Salaries 582,860 282,756 266,924 263,990 284,415 1,659 49% (1)% 8% 13 Overtime 1,000 1,000 2,098 5,807 247 (753) 25% 177% (96)% 21 FICA 44,628 21,850 20,332 20,540 21,585 (265) 48% 1% 5% 23 Pension-PERS/PSERS 69,996 34,265 23,793 30,043 31,702 (2,563) 45% 26% 6% 24 industrial Insurance 24,640 11,720 7,870 9,586 8,501 (3,219) 35% 22% (11)% 25 Medical & Dental 128,878 63,279 52,233 57,117 63,497 218 49% 9% 11% 26 Unemployment - - - 10,547 - - - - 28 Uniform/Clothing 2,000 980 241 406 - (980) - 69% - Total Salaries & Benefits 854,002 x1$,848 373;492 398,036 409,946 (5,903) 4801 7% 3% 31 Supplies 90.700 46,091 30,405 44,297 39.789 (6,302) 44% 460% (10)% 35 Small Tools 2,500 814 107 369 602 (212) 24% 244% 63% 41 Professional Services 2.000 121 240 93 119 (2) 6% (61)% 28% 42 Communication 4.600 439 191 473 2.803 2,364 61% 147% 493% 45 Rentals and Leases 132,746 67.981 57,390 64,637 64.615 (3,366) 49% (4)% (0)% 46 Insurance 106.805 106,805 - 106,805 107,271 466 100% - 0% 47 Public Utilities 375,000 162,875 152,058 158.361 191.306 28,431 51% 4% 21% 48 Repairs and Maintenance 250,000 92,484 120,381 87.705 90.179 (2,304) 36% (27)% 3% 49 Miscellaneous 1,000 1,000 257 563 1,031 31 103% 119% 83% Total Operating Expenses 965,351 478,609 371,029 463,302 497,7133 19,106 52% 25% 7% - - Total Expenses 1,819,353 894,457 744,521 861,339 907,661 13,204 50% 16% 5% Percent of year expired 114 50.00% PARK MAINTENANCE Cf TY QF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF JUNE 30, 2017 8/1412017 9:28 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 269,658 294,363 243,439 275,635 5,977 48% (17)% 13% 12 Extra Labor 20,000 5,463 1,932 6,107 11,211 5,748 56% 216% 84% 13 Overtime 2,137 411 362 547 63 (349) 3% 51% (89)% 21 FICA 45,954 20,943 22,528 19,044 21,873 930 48% (15)% 15% 23 Pension-PERSIPSERS 69,438 32,159 27,054 27,141 30,708 (1,452) 44% 0% 13%, 24 Industrial Insurance 23,807 9,716 8,222 7,847 8,461 (1,255) 360% (5)% 8% , 25 Medical & Dental 135,009 60,740 58,726 51,432 67.080 6,339 50% (12)% 30% 28 Uniform/Clothing 1,680 493 160 288 126 (367) 7% 80% (55)% Total Salaries & Benefits 876,433 399,584 413,347 355,844 415,155 15,572 47°% (14)% 17% 31 Supplies 53,800 53,800 20,614 38,197 63,284 9,484 118% 85% 66% 35 Small Tools 7,500 245 1,046 326 5.318 5,073 71% (69)35 1533% 41 Professional Services 61,200 13,485 14,620 24,337 32,114 18,629 52% 66010 32% 42 Communication - - - 783 176 176 -- (78)% 43 Travel 225 225 84 319 1,390 1.155 618% 279% 336% 45 Rentals and Leases 101,992 59,899 58,515 62,888 59,637 (263) 58% 7% (5)% 47 Public Utilities 290,610 96,116 77,186 82,222 97,148 1,032 33% 7% 18% 48 Repairs and Maintenance 23,000 560 3,366 1,085 3,257 2,697 14°% (68)% 200% 49 Miscellaneous 4,000 4.000 7,191 2,432 6,368 2,368 159% (66)% 162°! Total Operating Expenses 542,327 228,330 182,622 212,587 268,692 40,362 50% 16% 26% Total Expenses 1,418,760 627,914 595,969 568,432 683,848_ 55,934 4884 45196 2096 Percent of year expired 50.00% 115 STREET MAINTENANCE & OPERATIONS CITY OF TUKWILA GENERAL FUND EXPENDITURES YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED BDGT % SPEND 201512016 2016/2017 11 Salaries 801,234 416,470 332,302 409,972 384,666 (31,804) 48% 23% (6)% 12 Extra Labor 45,000 16,864 1,140 16,508 19,215 2,351 43% 1348% 16% 13 Overtime 11,000 4,052 2,469 3,408 9,299 5,247 85% 38% 173% 221 FICA 65,181 33.269 26,921 32.659 32,034 (1,235) 49% 2194 (2)% 23 Pension-PERS/PSERS 96,207 48,209 32,009 46,281 46,141 (2,068) 48% 45% (0)% 24 Industrial Insurance 31,445 13,500 9,407 11.563 12,463 (1,037) 40% 23% 8% 25 Medical & Dental 198,694 97,178 68.082 83,435 106,713 9,534 54% 23% 28% 26 Unemployment - - 1.004 258 - - - (74)% - 28 Uniform/Clothing 2,375 845 681 715 444 (401) 19% 5% (38)% Total Salaries & Benefits 1,251,136 630,388 474,016 604,798 610,974 (19,414) 49% 28% 196 31 Supplies 297,300 112,519 118,213 79,695 90,758 (21,760) 3194 (33)% 1494 35 Small Tools 13,200 9,700 3,043 16.466 6.441 (3,259) 49% 441% (61)% 41 Professional Services 4,000 1,638 1,246 1,116 2.782 1,145 70% (10)% 149% 42 Communication 4,300 900 558 720 120 (780) 3% 29% (83)% 43 Travel 2,700 1,186 66 175 187 (999) 7% 165% 794 44 Advertising 1,500 - - - - - - - - 45 Rentals and Leases 297,801 262.690 217.202 197.514 147,308 (115.382) 49% (9)% (25)94 46 Insurance 24,755 24,755 - 35,455 24,755 - 100% - (30)% 47 Public Utilities 1,152,100 549,129 434,688 542,913 568,839 19,710 49% 25% 5% 48 Repairs and Maintenance 27,100 2,480 4,711 10.715 3.808 1,328 14% 127% (64)%0 49 Miscellaneous 5,200 1.864 3,023 1,192 2,681 817 52% (61)% 125% 53 Ext Taxes, Oper Assess - - 29 6 6 6 - (80)% (1)%° 64 Machinery & Equipment 28,500 - - - - - - - - Total Operating Expenses 1,858,456 966,859 782,779 885,966 _ 847,685 (119,174) 46°% 13% (4)% Total Expenses 3,109,592 1,597,247 1,256,794 1,490,764 1,458,659 (138,588) 47% 19% (2)14 Percent of year expired STREET MAINTENANCE & OPERATIONS DIVISION SUMMARY 50 00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY DIVISION BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED BDGT % SPEND 201512016 2016/2017 ADMINISTRATION 1,252,136 630,388 474.406 605,188 611,416 (18,972) 49% 28% 1°/a GENERAL SERVICES 339,956 292.699 222,852 237.144 176,693 (116.007) 52% 6% (25)94 ROADWAY 810.800 412,205 324,305 393,151 387,615 (24,590) 48% 21% (1)% STRUCTURES2,500 2,052 - 1,181 3,808 1,756 152% - 223% LIGHTING 296,100 131,476 93,724 142,096 164,460 32,985 56% 52% 16% TRAFFIC CONTROL 271,500 96,769 122,948 82.425 76,756 (20,013) 28% (33)% (7)% SNOW & ICE CONTROL 10,300 10,000 440 871 14,155 4,155 137% 98% 1525% STREET CLEANING 62,000 17,703 16,399 16,469 21,862 4,159 35% 0% 33% VIDEO & FIBER 33,500 2,061 1,720 3,462 - (2,061) - 101% - SIDEWALKS 2,300 1,893 - 8,777 1,893 - 82%° - (78)94 Total Expenses 3,081,092 1,597,247 1,256,794 1,490,764 1,458,659 (138,588) 4796 19% (2)% Percent of year expired 116 50.00% STREET MAINTENANCE & OPERATIONS ADMINISTRATION YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVERT{UNDER) % CHANGE ALLOLr6 BDGT % SPEND 201512016 201612017 11 Salaries 801,234 416,470 332,302 409,972 384,666 (31,804) 48% 23% (6)% 12 Extra Labor 45,000 16,864 1,140 16,508 19,215 2,351 43% 1348% 16% 13 Overtime 11,000 4,052 2,469 3,408 9,299 5,247 85% 38% 173% 21 FICA 65,181 33.269 26.921 32,659 32,034 (1,235) 49% 21% (2)% 23 Pension-PERSIPSERS 96,207 48.209 32,009 46,281 46,141 (2,068) 48% 45% (0)% 24 Industrial Insurance 31.445 13,500 9.407 11,563 12,463 (1,037) 40% 23% 8% 25 Medical & Dental 198,694 97.178 68,082 83,435 106,713 9,534 54% 23% 28% 26 Unemployment -- 147,201 1,004 258 - - - (74)% - 28 Uniform/Clothing 2,375 845 681 715 444 (401) 19% 5% (38)% 'Total Salaries & Benefits 1,251,136 630,388 474,016 604,798 610,974 (19,414) 49% 28% 1% 31 Supplies 1.000- 1,864 - 1,192 - - - - 125% 41 Professional Services - - 390 390 442 442 - 0% 13% Total Operating Expenses 1,000 - 390 390 442 442 44% 0% 13% Total Expenses 339,956 292,699 222,852 237,144 176,693 (116,007) 52% 6% (25)% Total Expenses 1,252,136 630,388 474,406 605,188 611,416 (18,972) 49% 28% 1% Percent of year expired STREET MAINTENANCE & OPERATIONS GENERAL SERVICES 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED BDGT % SPEND 201512016 2016/2017 31 Supplies 5,000 3,043 1,848 2,754 1.671 (1,371) 33% 49% (39)% 35 Small Tools 3,000 - 613 - - - - - - 41 Professional Services 1,100 701 99 555 198 (503) 18% 461% (64)% 42 Communication 2,500 - - - - - - - - 43 Travel 2,000 1,186 66 175 167 (999) 9% 165% 7% 44 Advertising 1,500 - - - - - - - - 45 Rentals and Leases 294,401 261,151 217,202 197,014 147,201 (113,951) 50% (9)% (25)% 46 Insurance 24,755 24,755 - 35,455 24,755 - 100% - (30)% 48 Repairs and Maintenance 500 - - - - - - - - 49 Miscellaneous 5,200 1,864 3,023 1,192 2,681 817 52% (61)% 125% Total Operating Expenses 339,956 292,699 222,852 237,144 176,693')16,007) 52% 6% (25)% Total Expenses 339,956 292,699 222,852 237,144 176,693 (116,007) 52% 6% (25)% Percent of year expired 50.0014 117 STREET MAINTENANCE & OPERATIONS ROADWAY YTD AS OF JUNE 30, 2017 8/1412017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 2015 2016 2017 ACTUAL OVERI(UNDER) % CHANGE ALLOCATED % CHANGE ALLOCATED BDGT % SPEND 2015/2016 2016/2017 31 Supplies 48 Repairs and Maintenance 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 2015/2016 201612917 31 Supplies 39.000 27,587 23,915 14,902 5.191 (22,396) 13% (38)% (65)% 35 Small Tools 4.000 4,000 174 11,515 28 (3,972) 1% 6515% (100)% 41 Professional Services 100 - - - - - - - - 43 Travel 100 - - - - - - - - 45 Rentals and Leases 3.400 1,539 - 500 107 (1,431) 3% - (79)% 47 Public Utilities i 764,100 379,079 300.217 366,234 382,288 3,209 50% 22% 4% 48 Repairs and Maintenance 100 - - - - - - - - Total Operating Expenses 810,800 412,205 , 324,305 393,151 387,615 124,590) 48% 21% (1)% 32,985 56% 52% 16% (Tota1 Expenses 810,800 412,205 324,305 393,151 387,615 (24,590) 48% 21% (1 )4/;' Percent of year expired STREET MAINTENANCE & OPERATIONS STRUCTURES 50.00% YTD AS OF JUNE 30, 2017 8114/2017 9:28 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 552 1,500 - - 1,181 - - 3,808 (552) 2,308 - 254% - - - - Total Operating Expenses 2,500 2,052 - 1,181 3,808 1,756 152% - 223% BDGT %. SPEND 2015/2016 2016/2017 31 Supplies 25,000 2,846 747 1,402 18,156 Total Expenses 2,500 2,052 - 1,181 3,808 1,756 152% - 223% Percent of year expired STREET MAINTENANCE & OPERATIONS LIGHTING 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 Percent of year expired 118 50.00% BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY BY EXPENDITURE ACTUAL TYPE 2017 OVERI(UNDER) % CHANGE ALLOCATED 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT %. SPEND 2015/2016 2016/2017 31 Supplies 25,000 2,846 747 1,402 18,156 15,310 73% 88% 1195% 35 Small Tools 500 - - - - - - - - 41 Professional Services 500 162 212 171 186 24 37% (20)% 9% 43 Travel 100 - - - - - - - - 47 Public Utilities 270,000 128,468 92.765 140,523 146,118 17,650 54°I 51% 4% Total Operating Expenses 296,100 131,476 93,724 142,096 164,460 2,985 561° 52% 16% Total Expenses 296,100 131,476 93,724 142,096 164,460 32,985 56% 52% 16% Percent of year expired 118 50.00% STREET MAINTENANCE & OPERATIONS TRAFFIC CONTROL YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 2015 2016 2017 ACTUAL OVER/(UNDER) % CHANGE ALLOCATED % SPEND 2015/2016 201612017 31 Supplies 43 Travel 10,000 300 10,000 - 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT % SPEND 201512016 2016/2017 31 Supplies 166,000 56,803 86.467 48,487 33,448 (23,355) 20% (44)% (31)°/u 35 Small Tools 2,500 2,500 2,170 1,361 4,704 2,204 188% (37)% 246% 41 Professional Services 100 100 230 - 1,281 1.181 1281% - - 42 Communication 1,800 900 558 720 120 (780) 7% 29% (83)% 43 Travel 100 - - - - - - - - 47 Public Utilities 81,000 36.466 32,589 31,857 37,203 737 46% (2)% 17% 48 Repairs and Maintenance 20,000 - 935 - - - - - - Total Operating Expenses 271,500 96,769 122,948 82,425 76,756 (20,0131 28% (33)% (7)% Total Expenses 62,000 17,703 16,399 16,469 21,862 4,159 35% 0% Total Expenses 271,500 96,769 122,948 82,425 76,756 (20,013) 28% (33)% (7)% Percent of year expired STREET MAINTENANCE & OPERATIONS SNOW & ICE CONTROL 50.00% YTD AS OF JUNE 30, 2017 8/14/2017 9:28 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 201612017 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% 86 207 1,709 509 142% 141% 727% 41 Professional Services Total Expenses 10,300 10,000 440 871 14,155 4,155 137% 98% 1525% Percent of year expired STREET MAINTENANCE & OPERATIONS STREET CLEANING 50.00% YTD AS OF JUNE 30, 2017 8114/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVERI(UNDER) % CHANGE ALLOCATED BDGT %SPEND 2015)2016 201612017/ 31 Supplies 18,000 9,732 4,632 10,020 16,242 6,510 90% 116% 62% 35 Small Tools 1.200 1,200 86 207 1,709 509 142% 141% 727% 41 Professional Services 2.200 675 315 - 675 - 31%- - 43 Travel 100 - - - - - - - - 47 Public Utilities 37,000 5,116 9,117 4,299 3,231 (1.886) 9% (53)% (25)% 48 Repairs and Maintenance 3.500 980 2,221 1,937 - (980) - (13)% - 53 Ext Taxes, Assessments - 29 6 6 6 - (80)% (1)% Total Operating Expenses 62,000 17,703 15,399 16,469 21,862 4,159 35/ 0% 33% Total Expenses 62,000 17,703 16,399 16,469 21,862 4,159 35% 0% 33% Percent of year expired 50.00% 119 STREET MAINTENANCE & OPERATIONS VIDEO & FIBER YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL CVER/(UNDER) % CHANGE ALLOCATED BDGT % SPEND 2015/2016 201612017 31 Supplies 35 Small Tools 48 Repairs and Maintenance 1 30,000 2,000 1,500 61 2,000 - 164 - 1,556 79 3,384 - - - - (61) (2,000) - - - - (52)% - - - - Total Operating Expenses 33,500 2,061 1,720 3,462 - (2,061) 82% 101% - Total Expenses 33,500 2,061 1,720 3,462 - (2,061) - 101% Percent of year expired STREET MAINTENANCE & OPERATIONS SIDEWALKS 50.00! YTD AS OF JUNE 30, 2017 8/14/2017 9:28 SUMMARY BY EXPENDITURE TYPE BUDGET ACTUAL COMPARISON OF RESULTS 2017 ANNUAL 2017 ALLOCATED 2015 2016 2017 ACTUAL OVER1(UNDER) % CHANGE ALLOCATED BDGT % SPEND 201512016 201612017 31 Supplies 48 Repairs and Maintenance 2,300 - 1,893 - - - 8,777 1,893 - - 82% - - - - - Total Operating Expenses 2,300 1,893 - 8,777 1,1193 82% - (78)% Total Expenses 2,300 1,893 - 8,777 1,893 - 82% - (78)% Percent of year expired 120 50.00% City of Tukwila Hotel/Motel Tax Fund 101 - Revenue and Expenditures As of June 302017 % of year expired 50.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance'* Budget Revenue General Revenue Hote(IMotel Taxes Total General Revenue Miscellaneous Revenue Investment Earnings $ 733,000 $ 366,500 $ 284,165 $ (82,335) 38.77% 733,000 366.500 284,165 (82,335) 38.77% 3,000 1,500 561 (939) 18.69% Total Revenue 736,000 368,000 - - - 284,726 - 183,274) 38.69% Expenditures 31 Office & Operating Supplies 41 Professional Services Transfers Out 49 Miscellaneous Total Hotel/Motel Tax Fund Indirect cost allocation Total Expenditures 5,000 2,500 - (2,500) - 370,000 185,000 41,500 (143,500) 11.22% 10,000 5,000 (5,000) 20,000 10,000 4,554 (5,446) 22.77% 405.000 202,500 46,054 (156,446) 11.37% 35,700 17,850 17,850 50.00% 440,700 220,350 83,904 (156,446) 14.50% Change in Fund Balance 295,300 Beginning Fund Balance 906,875 147,650 220,821 906,875 912,558 73,171 74.78% 5,683 100.63% Ending Fund Balance $ 1,202,175 $ 1,054,525 $ 1,133,379 $ 78,854 94.28% Cash and investments $ 1,049,063 '• Variance = Actual over (under) prorated budget Fund 101 121 City of Tukwila Street Fund 103 Revenue and Expenditures As of June 30 2017 % of year expired 50.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance " Budget Revenue Intergovernmental Revenue State Grant-Thorndyke Total Intergovernmental Revenue Miscellaneous Revenue Investment Earnings Plan/Development Contributions Total Miscellaneous Revenue $ 1,894,000 $ 1,894,000 947,000 $ 177,212 $ (769,788) 9.36% 947,000 $ 177,212 $ (769,788) 9.36% 1,500 750 1,902,000 951,000 1,903,500 951,750 1,323 573 (1,902,000) 88.19% 1,323 (1,901,427) 0.07% Bond proceeds 5,600,000 2,800,000 - (5,600,000) Transfers In - - Total Revenue 9,397,500 4,698,750 178,535 (8,271,215) 1.90% Expenditures 11 Salaries 56,966 56,966 21 FICA - - 4,310 4,310 23 PERS 6,369 6.369 - 24 Industrial Insurance 537 537 25 Medical, Dental, Life, Optical - 6,385 6,385 41 Professional Services 75,000 37,500 - (37,500) 64 Capital Outlay 9,278,000 4,639,000 266,097 (4,372,903) 2.87% Total Streets Fund 9,353.000 4,676,500 340,665 (4,335,835) 3.64% Total Expenditures 9,353,000 4,676,800 340,665 (4,335,835) - - - 3.64% Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments 44,500 22,250 (162,130) (3,935,380) -364.34% 833,331 833,331 658,932 (174,399) 79.07% $ 877,831 3 855,581 $ 496,802 $ (4,109,779) 56.59% •• Variance = Actual over (under) prorated budget Fund 103 122 481,005 City of Tukwila Arterial Street Fund 104 - Revenue and Expenditures As of June 30 2017 % of year expired 50.00% 2017 Annual Prorated Actual 1 of Annual Budget Budget Year -To -Date Varriance" 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 200,000 $ 100,000 $ 116,058 $ 16,058 58.03% 128.000 64,000 62,997 (1,003) 49.22% 400,000 200,000 626,666 426,666 156.67% 728,000 364,000 805,721 441,721 110.68% 600,000 300,000 254,563 (345,437) 42.43% 321,000 160,500 151,920 (169,080) 47.33% Intergovernmental Revenue Dept of Transportation -Tukwila Boeing Access Bridge Fed Tmst Cap Inv Gmts-Trnst WSDOT Reg Mobility Grant-8ridg State Grant -S 144th (TIB 43rd) State Grant-APW State Grant-Interurb Ave 5 Stat Multimodal Transportation -City Total Intergovernmental Revenue Miscellaneous Revenue Investment Earnings Contributions/Donations Total Miscellaneaus Revenue Transfer In Total Revenue 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 921,000 460,500 406,483 (514,517) 44.14% 3,186,000 1,593,000 48,829 (1,544,171) 1.53% 8,677,000 4,338,500 34,494 (4,304,006) 0.40% 2,618,000 1,309,000 (1,309,000) - 4,289,000 2,144,500 1,649,121 (495,379) 38.45% 964,000 482,000 96,021 (385,979) 9.96% 1,173,000 586,500 (586,500) - - 7,775 7,775 2,093 2,093 - 20,907,000 10,453,500 1.838.332 (8.615,168) 8.79% 5,000 2.500 2,934 434 58.67% 1,037,000 518.500 5.200 (513,300) 0.50% 1,042,000 521.000 8,134 (512,866) 0.78% 1,800,000 900,000 (900,000) 25,398,000 12,699,000 3,058,670 (10,100,830) 12.041 332,953 166,477 25,232 12,616 39,971 19,986 5,821 2,911 32,602 16,301 1,380,000 690.000 5,176,000 2,588,000 22,145,000 11,072, 500 29,137,579 183,906 17,429 55.23% 37 37 - 14,000 1,384 55.49% 20,537 552 51.38% 2,515 (395) 43.21% 24,621 8,320 75.52% 210 210 146,154 (543,846) 10.59% 115 115 691 691 446 446 - 1,255 1,255 67,458 (2,520,542) 1.30% 150 150 - 2,267,589 (8,804,911) 10.24% 14,568,790 2,729,685 (11,839,104) 9.37% 29,137,579 14,568,790 2,729,685 (11,839,104) 9.371 (3,739,579) 3,786,923 (1.869,790) 3,786,923 328,985 3,999,376 1,738,275 -8.80% 212,453 105.61% Ending Fund Balance $ 47,344 $ 1,917,134 $ 4,328,361 $ 1,950,728 9142.361 Cash and investments $ 4,266,171'—�� " Variance = Actual over (under) prorated budget Fund 104 123 City of Tukwila Contingency Fund 105 - Revenue and Expenditures As of June 30 2017 Revenue Miscellaneous Revenue Investment Earnings Total Miscellaneous Revenue Transfers In 124 % of year expired 50.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance" Budget $ 20,000 $ 10,000 20,000 10,000 15,781 $ 5,781 78.90% 15,781 5,781 78.90% Total Revenue 20,000 10,000 15,781 5,781 78.90% Total Expenditures - - Change in Fund Balance 20,000 10,000 15781 5,781 78.90% Beginning Fund Balance 5,716,048 5,716,048 6.050,624 334,576 105.85% Ending Fund Balance $ 5,736,048 $ 5,726,048 $ 6,066,405 $ 340,357 105.76% Cash and investments $ 6,063,707 `* Variance = Actual over Runder) prorated budget Fund 105 City of Tukwila Drug Seizure Fund 109 - Revenue and Expenditures As of June 30 2017 % of year expired 50.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance " Budget Revenue Miscellaneous Revenue Investment Earnings Seizure Revenue Total Miscellaneous Revenue $ 18 $ 18 60,000 30,000 31,017 1,017 60,000 30,000 31,034 1,034 51.69% 51.72% Total Revenue 60,000 30,000 31,034 1,034 51.72% Expenditures 31 Office & Operating Supplies 3,000 1,500 67,289 65,789 2242.98% 35 Small Tools & Minor Equipment - 7,783 7,783 41 Professional Services 10,000 5,000 39,847 34,847 398.47% 43 Travel - 4,909 4,909 45 Operating Rentals & Leases - 750 750 49 Miscellaneous 2,000 1,000 2,617 1,617 130.85% 51 Intergovernmental Prof Svcs 30,000 15,000 - (15,000) - Total Drug Seizure Fund 45,000 22,500 123,195 100,695 273.77% Total Expenditures 45,000 22,500 123,195 100,695 273.77% Change in Fund Balance 15,000 7,500 (92,161) (99,661) -614.41% Beginning Fund Balance 461,635 461,635 553,539 91,904 119.91% Ending Fund Balance $ 476,635 $ 469,135 $ 461,378 $ (7,757) 96.80% Cash and investments $ 461.907 " Variance = Actual over (under) prorated budget Fund 109 125 Total Expenditures Change in Fund Balance City of Tukwila Land Acquisition, Rec and Park Development Fund 301 - Revenue and Expenditures As of June 30 2017 % of year expired 50.00% 2017 Annual Prorated Year -To - Budget Budget Date Variance" % of Annual Budget Revenue General Revenue Excess Prop Tax Levy-Dwmsh Hill $ - $ - $ 31,439 $ 31,439 - Real Estate Excise Taxes 400,000 200,000 626,666 426,666 156.67% Total General Revenue 400,000 200,000 658,106 458,106 164.53% Charges for Services Intergovernmental Revenue Duwamish Gardens Acquisition State Agencies-Duwamish Hill Pres Total Intergovernmental Revenue 13,436 13,436 131,000 65,500 - (65,500) 131,000 65,500 13,436 (52,064) 10.26% Miscellaneous Revenue Investment Earnings 1,000 500 789 289 78.88% Transfers In Total Revenue 184,000 92,000 - (92,000) - (c) 716,000 358,000 672,331 314,331 93.90% Expenditures 11 Salaries 5,286 5,286 12 Extra Labor - 187 187 21 FICA - - 411 411 23 PERS - 591 591 - 24 Industrial Insurance - 110 110 - 41 Professional Services 185,000 92.500 56,689 (35,811) 30.64% 43 Travel 36 36 64 Capital Outlay 954,000 477,000 84,734 (392,266) 8.88% Total Park Acquisition Fund 1,139,000 569,500 148,044 (421,456) 13.00% 126 1,139,000 569,500 148,044 (421,456) 13.00% (423,000) (211,500) 524,287 735,787 -123.94% Beginning Fund Balance 2,713,123 2,713,123 3,352,113 638,990 123.55% Ending Fund Balance S 2,290,123 $ 2,501,623 3,876,400 S 1,374,777 169.27% Cash and investments $ 3.379.154 "• Variance = Actual over (under) prorated budget Fund 301 City of Tukwila Facility Replacement Fund 302 - Revenue and Expenditures As of June 302017 2017 % of year expired 50.00% Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance" Budget Revenue Miscellaneous Revenue Investment Earnings $ 3,600 $ 1,800 $ 1,281 $ (519) Total Miscellaneous Revenue 3,600 1,800 1,281 (519) Sale of Capital Assets 3,483,000 1,741,500 (3,483,000) Total Revenue 35.59% 35.59% 3,486,600 1,743,300 1,281 (3,483,519) 0.04% Expenditures 11 Salaries - - - 41 Professional Services 25,000 12,500 9,994 (2,506) 39.98% 47 Public Utility Services - 5,670 5,670 - 64 Capital Outlay 35,000 17,500 - (17,500) - Total Expenditures 60,000 30,000 15,663 (14,337) 26.11% Transfer to General Fund 1,800,000 900,000 (900,000) Total Expenditures 1,860,000 930,000 15,663 - (914,337) 0.84% Change in Fund Balance Beginning Fund Balance 1,626,600 813,300 370.706 370,706 (14,382) (2,569,182) 295,040 (75,666) -0.88% 79.59% Ending Fund Balance $ 1,997,305 $ 1,184,006 $ 280,658 $ (2,644,848)6 14.05% Cash and investments $ 409,708 "" Variance = Actual over (under) prorated budget Fund 302 127 City of Tukwila General Government improvements 303 - Revenue and Expenditures As of June 30 2017 % of year expired 50.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance" Budget Revenue Miscellaneous Revenue Investment Earnings $ 500 $ 250 $ 541 $ 291 108.11% Total Miscellaneous Revenue 500 250 541 291 108.11% Transfers In 200,000 100,000 - (100,000) Total Revenue 200,500 100,250 541 (99,709) 0.27% Expenditures 11 Salaries 105,085 52,543 26,004 (26,539) 24.75% 13 Overtime 213 213 21 FICA 8,039 4,020 2,003 (2,016) 24.92% 23 PERS 12,615 6,308 2,931 (3,376) 23.23% 24 Industrial lnsurance 2;734 1,367 401 (966) 14.66% 25 Medical, Dental, Life, Optical 12,321 6,161 3,923 (2,238) 31.84% 41 Professional Services 20,000 10,000 1,680 (8,320) 8.40% 48 Repairs & Maintenance - 30,041 30,041 64 Capital Outlay 130,000 65,000 27,977 (37,023) 21.52% Total Gen Government Improve 290,794 145,397 95,173 (50,224) 32.73% Total Expenditures Change in Fund Balance 290,794 145,397 95,173 (50,224) 32/3% (90,294) (45,147) (94,632) (49,485) 104.80% Beginning Fund Balance 334,349 334,349 391,903 57,554 117.21 % Ending Fund Balance $ 244,055 $ 289,202 $ 297,271 $ 8,069 121,80% Cash and investments $ 300,935 .. Variance = Actual over (under) prorated budget Fund 303 128 City of Tukwila Fire Impact Fees 304 - Revenue and Expenditures As of June 30 2017 % of year expired 50.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance " Budget Revenue Charges for Services Fire Impact Fees $ 32,000 $ 16,000 $ 225,027 $ 209,027 703.21% Total Charges for Services 32,000 16,000 225,027 209,027 703.21% Investment Earnings Total Miscellaneous Revenue 100 50 569 519 568.82% 100 50 569 519 568.82% Total Revenue 32,100 16,050 226,595 209,545 702.79% Total Expenditures Change in Fund Balance Beginning Fund Balance 32,100 16,050 225,595 209,545 702.79% 645,631 645.631 736.518 90,887 114.08% Ending Fund Balance $ 677,731 $ 661,681 $ 962,113 $ 300,432 141.96% Cash and investments $ 962,113 ** Variance = Actual over (under) prorated budget Fund 304 129 City of Tukwila Public Safety Plan 305 - Revenue and Expenditures As of June 30 2017 % of year expired 50.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 Total Revenue Expenditures 41 Professional Services 64 Capital Outlay Total Gen Government improve Transfers Out Total Expenditures Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments 500,000 250,000 (500,000) $ $ $ 36,450 $ 36.450 23,343,000 11,671,500 23,343,000 11,671,500 23,843,000 11,921,500 2,588,000 11,139, 000 1,294,000 5,569,500 13,727,000 6,863,500 460.000 230,000 14,187,000 7,093,500 (11,671,500) 36,450 (11,635,050) 36,450 (12,135,050) 159,949 (1,294,000) (5,409,551) 159,949 (6,703.551) (230,000) 159,949 (6,933,551) 9,656,000 4,828,000 (123,499) (5,201,499) 36,513,127 36,513,127 $ 9,656,000 $4,828,000 $ 36,389,628 $ 31,311,628 •* Variance = Actual over (under} prorated budget Fund 305 130 $ 34,3$9,439 0.16% 0.15% 1.13% -1.26% 376.86% City of Tukwila City Facilities 306 - Revenue and Expenditures As of June 30 2017 Revenue Miscellaneous Revenue Bond proceeds Total Miscellaneous Revenue Total Revenue Expenditures 41 Professional Services 64 Capital Outlay Total Gen Government Improve % of year expired 50.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance ** Budget 6,150,000 3,075,000 6,150,000 3,075,000 6,150,000 3,075,000 150,000 75,000 6,000,000 3,000,000 6,150,000 3,075,000 (3,075,000) 79,210 79,210 (3,075, 000) (3,075,000) (75, 000) - (2,920,790) 1.32% (2,995,790) 1.29% Total Expenditures 6,150,000 _ 3,075,000 79,210 (2,995,790) 1.29% Change in Fund Balance Beginning Fund Balance Ending Fund Balance (79,210) (79,210) - $ (79,210) $ (79,210) - Cash and investments $ (79,210) ** Variance = Actual over (under) prorated budget Fund 306 131 City of Tukwila Water Fund 401 - Revenue and Expenditures As of June 30 2017 Revenue Charges for Services Water Sales Security Total Charges for Services Miscellaneous Revenue Investment Earnings Connection Fees Other Misc Revenue Total Miscellaneous Revenue Total Revenue Operating Expenses 11 Salaries 12 Extra Labor 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Medical, Dental, Life, Optical 28 Uniform Clothing 31 Office & Operating Supplies 33 Water Purchased for Resale 35 Small Tools & Minor Equipment 41 Professional Services 42 Communication 43 Travel 45 Operating Rentals & Leases 46 Insurance 47 Public Utility Services 48 Repairs & Maintenance 49 Miscellaneous 53 Excise Taxes 54 Interfund utility taxes Total Operating Expenses Capital Expenses 64 Capital Outlay 80 Debt Service Principal 81 Debt Service Interest Total Capital Expenses Indirect cost allocation Total Expenses Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments V. of year expired 2017 50.00% Annual Budget $ 6,858,000 1,000 6,859,000 Prorated Budget Actual Year -To -Date Variance ** % of Annual Budget $ 3,429,000 $ 2,837,539 $ (591,460,76) 41.38% 500 270 (230) 27.00% 3,429,500 2,837,809 (591,691) 41.37% 21,000 10,500 13,945 3,445 66.40% 25,000 12,500 128,229 115,729 512.91 % - - 3,854 3,854 46,000 23,000 146,027 123,027 317.45% 6,905,000 3,452,500 2,983,837 (468,663) 43,21% 589,968 294,984 272.115 (22,869) 46.12% 4.000 2,000 (2,000) 7,000 3,500 3.781 281 54.02% 45,855 22,928 21.370 (1,558) 46.60% 70,837 35,419 30,779 (4,640) 43.45% 20,507 10,254 6,897 (3,356) 33.63% 119,295 59,648 58,647 (1,000) 49.16% 1,330 665 - (665) 144,300 72,150 61,037 (11.113) 42.30% 2,610,000 1.305,000 1,253,151 (51.849) 48.01% 11,000 5,500 827 (4.673) 7.52% 9,500 4,750 696 (4,054) 7.33% 2,500 1,250 80 (1,170) 320% 1,500 750 654 (96) 43.57% 183,381 91,691 90,941 (750) 49.59% 14,853 7,427 14,853 7,427 100.00% 24,400 12,200 9,255 (2,945) 37.93% 17,096 8,548 9,003 455 52.66% 37,000 18,500 28.523 10,023 77.09% 280,000 140,000 130.516 (9,484) 46.61% 688,000 344,000 283.658 (60,342) 41.23% 4,882,322 2,441,161 2,276,782 (164,379) 46.63% 3,195,000 1,597,500 1,197,219 (400,281) 37.47% 132,334 66,167 80,625 14,458 60.93% 15,881 7,941 (1,635) (9,576) -10.30% 3,343,215 1,671,608 1,276,209 (395,399) 38.17% 616.053 308,027 308,027 50.00% 8,841,590 4,420,795 3,861,017 (559,778) 43.67% (1,936,590) (968,295) (877,181) 91,114 45.30% 4,178,561 4,178.561 6,692,750 2,514,189 160.17% 2,241,971 $ 3,210,266 $ 5,815,569 $ 2,605,303 259.40% Variance = Actual over (under) prorated budget Fund 401 132 $ 5,848,537 City of Tukwila Sewer Fund 402 - Revenue and Expenditures As of June 30 2017 % of year expired 50.00% 2017 Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance" Budget Revenue Charges for Services Sewer Sales Total Charges for Services Intergovernmental Revenue Miscellaneous Revenue Investment Earnings Connection fees Total Miscellaneous Revenue $ 8,524,000 $ 4.262,000 $ 4,692,661 $ 430,661 55.05% 8,524,000 4,262,000 4,692,661 430.661 55.05% 25,000 12,500 25.609 13,109 102.44% 125.000 62,500 204,933 142,433 163.95% 150,000 75,000 230,542 155.542 153.69% Total Revenue 8,674,000 4,337,000 4,923,204 586,204 56.76% Operating Expenses 11 Salaries 355,341 177,671 141,442 (36.229) 39.80% 12 Extra Labor 13 Overtime 4,442 2,221 1,280 (941) 28.81% 21 FICA 27,483 13,742 11,035 (2,707) 40.15% 23 PERS 42,668 21,334 16,171 (5,163) 37.90% 24 Industrial Insurance 12,304 6,152 3.306 (2.846) 26.87% 25 Medical, Dental, Life, Optical 71,620 35,810 37,667 1,857 52.59% 28 Uniform Clothing 570 285 - (285) - 31 Office & Operating Supplies 21,600 10,800 5,808 (4,992) 26.89% 33 Metro Sewage Treatment 4,200,000 2,100,000 2.258,927 158,927 53.78% 35 Small Tools & Minor Equipment 2,500 1,250 1,353 103 54.10% 41 Professional Services 2,600 1,300 2,863 1,563 110.12% 42 Communication 2,500 1,250 120 (1,130) 4.80% 43 Travel 2.000 1,000 1.959 959 97.95% 44 Advertising 150 75 - (75) 45 Operating Rentals & Leases 103,926 51,963 50,966 (997) 49.04% 46 Insurance 4,952 2,476 4,952 2,476 10000% 47 Public Utility Services 38,000 19,000 18,298 (702) 48.15°4 48 Repairs & Maintenance 49,000 24.500 11,278 (13,222) 23.02% 49 Miscellaneous 55,000 27,500 24,619 (2,881) 44.76% 53 Excise Taxes 135,000 67,500 68,138 638 50.47% 54 Interfund utility tax 855,000 427,500 469,330 41,830 54.89% Transfers Out 5,986,656 2,993,328 3,129,509 136,181 52.27% Capital Expenses 64 Capital Outlay 4,353,500 2.176,750 884,761 (1,291,989) 20.32% 80 Debt Service Principal 322,271 161,136 233,436 72.300 72.43% 81 Debt Service Interest 36.794 18,397 (605) (19.002) -1.65% Total Capital Expenses 4,712,565 2,356,283 1,117,591 (1,238,692) 23.72% Indirect cost allocation Total Expenses Change in Fund Balance Beginning Fund Balance Ending Fund Balance 469.302 234,651 234,651 5000% 11,168,523 5,584,262 4,481,751 (1,102,5101 40.13% (2,494,523) (1,247,262) 441,452 1,688,714 -17.70% 9,009,091 9,009,091 7,826,985 (1,182,106) 86.88% $ 6,514,568 $ 7,761,830 $ 8,268,437 $ 506,608 126.92% Cash and investments $ 7,603,571 " Variance = Actual over (under) prorated budget Fund 402 133 City of Tukwila Foster Golf Course 411 • Revenue and Expenditures As of June 302017 2017 % of year expired 50,00% Annual Prorated Actual % of Annual Budget Budget Year -To -Date Variance" Budget Revenue General Revenue Excise Taxes $ 3,900 $ 1,950 $ 1,522 $ (428) 39.04% Total General Revenue 3,900 1,950 1,522 (428) 39.04% Charges for Services Sale of Merchandise 151,000 75,500 56,875 (18,625) 37.67% Greens Fees, Instruction 1,095,650 547,825 369,100 (178,725) 33.69% Total Charges for Services 1,246,650 623,325 425,974 (197,351) 34.17% Miscellaneous Revenue Investment Eamings 1,000 500 1,327 827 132.66% Rents and Concessions 306,000 153,000 103,875 (49,125) 33.95% Other Misc Revenue 7,000 3,500 7,669 4,169 109.55% Total Miscellaneous Revenue 314,000 157,000 112,870 (44,130) 35.95% Transfers In 300,000 150,000 150,000 - 50.00% Total Revenue 1,864,550 932,275 690,367 (241,908) 37.03% Expenses 11 Salaries 603.021 301,511 270,087 (31,424) 44.79% 12 Extra Labor 112,000 56,000 45,909 (10,091) 40.99% 13 Overtime 2.040 1,020 1,230 210 60.27% 21 FICA 55,680 27,840 23,749 (4,091) 42.65% 23 PERS 75.399 37,700 33,498 (4,202) 44.43% 24 Industrial Insurance 26,475 13.238 9,485 (3,753) 35.83% 25 Medical, Dental, Life, Optical 141.258 70,629 65,417 (5,213) 46.31% 26 Unemployment Compensation 6.120 3,060 - (3,060) - 28 Uniform Clothing 1,187 594 154 (440) 12.97% 31 Office & Operating Supplies 102,815 51,408 64,463 13,056 62.70% 34 Items Purchased for Resale 96,600 48.300 52,909 4,609 54.77% 35 Small Tools & Minor Equipment 4,000 2,000 4.740 2,740 118.51% 41 Professional Services 9,400 4,700 2.986 (1,714) 31.77% 42 Communication 5,671 2.836 1,954 (882) 34.45% 43 Travel 500 250 - (250) - 44 Advertising 4,000 2,000 2,397 397 59.93% 45 Operating Rentals & Leases 146,160 73,080 73,037 (43) 49.97% 46 Insurance 20,424 10,212 20,424 10.212 100.00% 47 Public Utility Services 63,400 31,700 28,181 (3,519) 44.45% 48 Repairs &Maintenance 39,000 19,500 30,052 10,552 77.06% 49 Miscellaneous 38,500 19,250 15,324 (3,926) 39.80% 53 Excise Taxes 6,400 3,200 1,442 (1,758) 22.53% 54 Interfund admissions tax 60,000 30,000 21,429 (8,571) 35.71% 64 Capital Outlay 50,000 25,000 16,043 (8,957) 32.09% Total Foster Golf Course Fund 1,670,050 835,025 784,910 (50,115) 47.00% Indirect cost allocation 180,899 90,450 90,450 0 50.00% Total Expenses 1,850,949 925,475 875,360 (50,115) 47.29% Change in Fund Balance 13,601 6,801 (184,993) (191,793) -1360.14% Beginning Fund Balance 23,174 23,174 117,982 94,808 509.11% Ending Fund Balance $ 36,775 $ 29,975 _$,..11 ±_19±31M -182.22% Cash and investments $ 604,950 •• Variance = Actual over (under) prorated budget Fund 411 134 City of Tukwila Surface Water Fund 412 - Revenue and Expenditures As of June 30 2017 % of year expired 50.00% 2017 Prorated Annual Budget Budget Actual Annual Year -To -Date Variance's Budget Revenue Charges for Services Surface Water Safes Total Charges for Services Intergovernmental Revenue Miscellaneous Revenue investment Earnings Other Misc Revenue Total Miscellaneous Revenue $ 6,133,000 $ 3.066,500 $ 3,077,912 $ 11,412 6,133,000 3,066,500 1,256,000 628,000 (628,000) 24,000 12,000 3,077,912 11,412 50.19% 50.19% 15,326 3,326 63.86% 40 40 - 24,000 12,000 15,366 3,366 64.03% Total Revenue 7,413,000 3,706,500 3,093,278 (613,222) 41.73% Operating Expenses 11 Salaries 12 Extra Labor 13 Overtime 21 FICA 23 PERS 24 Industrial Insurance 25 Medical. Dental, Life, Optical 28 Uniform Clothing 31 Office & Operating Supplies 35 Small Tools & Minor Equipment 41 Professional Services 42 Communication 43 Travel 44 Advertising 45 Operating Rentals & Leases 46 Insurance 47 Public Utility Services 48 Repairs & Maintenance 49 Miscellaneous 53 Excise Taxes 54 Interfund utility tax Total Operating Expenses Capital Expenses 64 Capital Outlay 80 Debt Service Principal 81 Debt Service Interest Total Capital Expenses Indirect Cost Allocation Total Expenses Change in Fund Balance Beginning Fund Balance Ending Fund Balance Cash and investments 1,007,855 503,928 8,000 4.000 9,000 4.500 78,048 39,024 121.038 60,519 31,798 15,899 236,299 118,150 1,425 713 41,500 20,750 5,000 2,500 3,600 1,800 2.000 1.000 2,000 1,000 500 250 332,620 166,310 22.279 11.140 107.000 53,500 36.572 18.286 23,500 11,750 50,000 25,000 618,000 309,000 2,738,034 1,369,017 4,573,500 2,286.750 288,148 144,074 15,659 7,830 333,386 (170.541) 33.08% 1,245 (2,755) 15.56% 3.080 (1,420) 34.22% 25,872 (13,152) 33.15% 37.011 (23,508) 30.58% 6.984 (8,915) 21.96% 79,238 (38,911) 33.53% (713) 10.988 (9,762) 26.48% 1.858 (642) 37.16% 3.896 2,096 108.23% 138 (862) 6.90% 1,059 59 52.96% (250) 164.434 (1,876) 49.44% 22.278 11,139 100.00% 10.735 (42,765) 10.03% 4.238 (14.048) 11.59% 15.980 4.230 68.00% 35,827 10.827 71.65% 308,764 (236) 49.96% 1,067,013 (302,004) 38.97% 436,945 (1.849.805) 9.55% 259,356 115,282 90.01% 8,131 302 51.93% 4,877,307 2,438,654 518,528 259,264 8,133,869 4,066,935 704,432 (1,734,221) 14.44% 259.264 0 50.00% 2,030,709 (2,036,226) 24.97% (720,869) (360,435) 1,062,569 1.423,004 147.40% 4,273,828 4,273.828 2,602.903 (1,670,925) 60.90% $ 3,552,959 $ 3,913,394 $ 3,665,472 $ (247,921) 103.17% variance = Actual over (under) prorated budget Fund 412 4,160,905 135 City of Tukwila Equipment Rental/Replacement Fund 501 - Revenue and Expenditures As of June 302017 % of year expired 50.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 $ 973,152 $ 973,152 $ - 50.00% Equipment Replacement Charges 690,596 345,298 345,298 0 50.00% Transportation 150 75 - (75) - Total Charges for Services 2,637,050 1,318,525 1,318,450 (75) 50.00% Miscellaneous Revenue Investment Earnings 14,269 7,135 19,873 12,739 139.28% Other Mise Revenue - 214 214 - Total Miscellaneous Revenue 14,269 7,135 20,088 12,953 140.78% Sale of Capital Assets Transfers In Total Revenue 30,000 15,000 5,746 (9,254) 19.15% 460,000 230,000 - (460,000) - 3,141,319 1,570,660 1,344,283 (456,376) 42.79% Expenses 11 Salaries 384.003 192,002 188,852 (3,149) 49.18% 12 Extra Labor 15,000 7,500 6,032 (1,468) 40.21% 13 Overtime 1,858 929 - (929) 21 FICA 30,344 15,172 14,681 (491) 48.38% 23 PERS 46,100 23,050 21,788 (1,262) 47.26% 24 Industrial Insurance 14,851 7,426 5.077 (2,348) 34.19% 25 Medical, Dental, Life, Optical 99,899 49,950 49,648 (301) 49.70% 28 Uniform Clothing 950 475 - (475) 31 Office & Operating Supplies 3,000 1,500 940 (560) 31.35% 34 Items Purchased for Resale 750,000 375,000 255.628 (119,372) 34.08% 35 Small Tools & Minor Equipment 5,000 2,500 2,231 (269) 44.63% 41 Professional Services 1,750 875 1,417 542 81.00% 42 Communication 2,000 1,000 448 (552) 22.42% 43 Travel 1,500 750 8 (742) 0.53% 45 Operating Rentals & Leases 77,227 38,614 38,492 (121) 49.84% 46 Insurance 65,574 32,787 66,567 33,780 101.51% 48 Repairs & Maintenance 120,000 60,000 41,138 (18,862) 34.28% 49 Miscellaneous 12,000 6,000 4,445 (1,555) 37.04% 53 Ext Taxes & Operating Assessme 1 1 - 64 Capital Outlay 1,999,000 999,500 109,196 (890,304) 5.46% Total Equipment Rental Fund 3,630,056 1,815,028 806,591 (1,008,437) 22.22% Indirect Cost Allocation Total Expenses 322,910 161,455 161.455 50.00% 3,952,966 1,976,483 968,046 (1,008,437) 24.49%. Change in Fund Balance (811,647) (405,824) 376,237 552,060 -46.35% Beginning Fund Balance 5,592,380 5,592.380 4,393,334 _(1,199,046) 78.56% Ending Fund Balance .$ 4,760,733 $ 5,186,557 $ 4,769,571 $ (646,986 99.77% Cash and investments $ 5,104,647 "• Variance = Actual over (under) prorated budget Fund 501 136 City of Tukwila Insurance Fund 502 - Revenue and Expenditures As of June 30 2017 2017 % of year expired 50.00% Annual Prorated Year -To- % of Annual Budget Budget Date Variance" Budget Revenue Charges for Services Employee Benefit Programs $ 1,200 $ 600 $ 943 $ 343 78.59% Total Charges for Services 1,200 600 943 343 78.59% Miscellaneous Revenue Investment Earnings 96,000 48,000 49.481 1,481 51.54% Employer Trust Contributions 5,999,527 2,999,764 2,875,347 (124,417) 47.93% Employee Contributions 77,000 38,500 64,258 25,758 83.45% Other Misc Revenue - - - - - Total Miscellaneous Revenue 6,172,527 3,086,264 2,989,086 (97,178) 48.43% Total Revenue Expenses 25 Medical, Dental, Life, Optical 41 Professional Services 49 Miscellaneous Total Indirect cost allocation Total Expenses Change in Fund Balance Beginning Fund Balance Ending Fund Balance 6,173,727 3.086,864 2,990,029 (98,834) 48.43% 6,662,500 32,000 25,000 6,719,500 3,331,250 16,000 12,500 2,865,606 13.795 1,507 3,359,750 2,880,908 123,117 61,559 (465,644) (2,205) (10,993) 43.01% 43.11% 6.03% (478,842) 42.87% 61,559 50.00% 6,842,817 3,421,309 2,942,467 (478,842) 43.00% (668,890) 1.175,682 (334,445) 1,175,682 47,562 1,494,823 382,007 -7.11% 319,141 127.15% $ 508,792 $ 841,237 $ 1,542,385 $ 701,148 304.34% Cash and investments $ 3,376,720 **Variance = Actual over (under) prorated budget Fund 502 137 City of Tukwila LEOFF Insurance Fund 503 - Revenue and Expenditures As of June 30 2017 %a of year expired 50.00% 2017 Annual Prorated Actual 1 of Annual Budget Budget Year -To -Date Variance '• Budget Revenue Miscellaneous Revenue Investment Earnings $ 3,340 $ 1,670 $ 404 $ (1,266) Employer Trust Contributions 265,000 132,500 128,931 (3,569) Total Miscellaneous Revenue 268,340 134,170 129,335 (4,835) 12.11% 48.65% 48.20% Total Revenue 268,340 134,170 129,335 (4,835) 48.201 Expenses 25 Medical, Dental, Life, Optical 575,250 287,625 173,611 (114,014) 30.18% 41 Professional Services 18,000 9,000 2.925 (6,075) 16.25% 49 Miscellaneous 500 250 (250) - Total 593,750 296,875 176,536 (120,339) 29.73% Indirect Cost Allocation 12,549 6,275 6,275 Total Expenses 606,299 303,150 182,810 (120,334 Change in Fund Balance Beginning Fund Balance (337,959) (168,980) (53,475) 115,504 1,210,204 1,210,204 882,478 (327,726) 50.00% 30.15% 15.82% 72.92% Ending Fund Balance $ 872,245 $ 1,0 1,225 829,003 $ (212,222) 95.041 Cash and investments $ 1,020,253 " Variance = Actual over (under) prorated budget Fund 503 138 2017 2"d Quarter Financial Report City of Tukwila August 28, 2017 2nd Quarter Financial Highlights ■ General fund ongoing revenues exceeding departmental expenditures. ■ Departmental budgets (in total) within budget. ■ Revenues, $31.50 Expenditures, $28.43 50 55 $10 $15 $ 20 25 $ 30 $ 35 August 28, 2017 2017 2nd Quarter Financial Report (Millions 2 • Overall, Expenditures Within Budget ■ Excluding Dept. 20 expenditures are at 47% of allocated budget. ■ All departments except for Fire and Parks Maintenance are below allocated budget. ■ Fire exceeds budget by $79 thousand. Semi-monthly monitoring in place, plan to address overage. ■ Parks Maintenance exceeds budget by $56 thousand. Department is fully staffed, change in spending pattern to gear up for summer. August 28, 2017 2017 2nd Quarter Financial Report 3 Highlights of Other Funds ■ 42nd Ave S Phase III, 52nd Ave S street projects: $8.8 million bond proceeds received in July. ■ REET revenue exceeding budget: $626 thousand each in land acquisition and arterial street funds. ■ City Facilities (fund 306): preliminary siting for Public Works shops. ■ Andover Park E water main replacement project: significant work in both water and sewer funds. ■ Through June, self-insured healthcare for employee expenses at 43% of budget. August 28, 2017 2017 2nd Quarter Financial Report • Looking Forward ■ Continue monitoring of general fund revenues and expenditures. ■ Close monitoring of Fire department. ■ Transfers to capital projects funds if needed. ■ Continued enhancement of reporting to departments and Council. ■ Line of credit options. August 28, 2017 2017 2nd Quarter Financial Report Q&A The city of opportunity, the community of choice. August 28, 2017 2017 2nd Quarter Financial Report 6 FINANCE COMMITTEE Meeting Minutes City of Tukwila City Council Finance Committee August 22, 2017 - 5:30 p. m. - Hazelnut Conference Room, City Hall Councilmembers: Verna Seal, Chair; Kathy Hougardy, Thomas McLeod Staff: David Cline, Peggy McCarthy, Vicky Carlsen, Richard Takechi, Cindy Wilkins, Mia Navarro, Gail Labanara, Brandon Miles, Laurel Humphrey CALL TO ORDER: Chair Seal called the meeting to order at 5:30 p.m. I. PRESENTATIONS 11. BUSINESS AGENDA A. Draft Equity Policy Staff is seeking Council input on a draft Equity Policy to guide the work of City employees in achieving equity in the provision of government services. The draft policy was developed by an interdepartmental staff group, reviewed by department heads, and then by the Equity and Social Justice Commission. Staff intends to brief the Committee of the Whole and then conduct a series of brown bag meetings for City employees to provide comment on the draft. Once that feedback has been incorporated, the draft will return to the Equity and Social Justice Commission and then again to Council for possible adoption. Once the policy is adopted an implementation and evaluation team will convene. Councilmember Hougardy noted Equity and Social Justice Commission was very support of the policy and that their edits have been incorporated. Councilmember McLeod asked about enforcement and staff replied that that will be evaluated during the implementation phase. FORWARD TO AUGUST 28, 2017 COMMITTEE OF THE WHOLE. B. 2017 2nd Quarter Financial Report *Staff presented the Committee with the City's 2017 2nd Quarter Financial Report which captures the general state of financial affairs and highlights significant items and trends. For the period ending March 31, 2017 revenues are below allocated budget by $737 thousand and expenditures are below budget by $2.81 million. FORWARD TO AUGUST 28, 2017 COMMITTEE OF THE WHOLE. C. Fire and Park Impact Fees Staff updated the Committee on a project to update the Fire and Park Impact fees. Impact fees are authorized by state law as a revenue source to help fund new or expanded public facilities resulting from development. The City enacted the initial impact fee legislation in 2008 and staff has determined it is time for a refreshed evaluation of the program. An interdepartmental committee convened to discuss this project and determined that external technical assistance 145