The URL can be used to link to this page

Home My WebLink AboutReg 2014-10-06 Item 5.13 - 2015-2016 Biennial Budget - Internal Service Funds2015 - 2016 Biennial Budget City of Tukwila, Washington INTERNAL SERVICE FUNDS Internal service funds provide services City -wide supporting both governmental and enterprise activities. The City has three internal service funds: 1. Equipment rental and replacement (ER &R) - All rolling stock equipment, including fire apparatus, is purchased, maintained and scheduled for replacement through this fund. Activity units such as general fund departments and utility funds are charged for the cost of repairing, maintaining and insuring existing equipment and for eventual replacement of the equipment through an annual replacement charge that is prorated over the estimated useful life of the equipment. 2. Employee healthcare plan - The City administers a self - insured healthcare plan as a benefit to its employees. The plan includes medical, pharmacy, vision and dental benefits. The Washington State Insurance Commission oversees the plan. Plan costs are analyzed and projected forward three years by an actuary. The City's reserve policy stipulates a funding reserve equal to 2.5 times the incurred by not reported (IBNR) claims. The projection is reviewed annually and the premiums are adjusted to cover the projected costs and the reserve for the forthcoming year. Premiums are paid by the City through charges to the general fund departments and other funds with employees. 3. LEOFF 1 Retiree Healthcare Plan - The City manages a self- insured healthcare plan for retired law enforcement officers and fire fighters that are members of the LEOFF 1 (Law Enforcement Officers and Fire Fighters) retirement plan. Membership is limited to eligible law enforcement officers and fire fighters hired prior to the March 1, 1970 establishment of LEOFF, as well as eligible members of LEOFF hired prior to October 1, 1977. The City has 40 retirees and 1 active LEOFF 1 member. The health benefits for the active LEOFF 1 member are paid from the Fund 502 Employee Healthcare Plan until retirement. The general fund Police and Fire departments pay the premiums for this plan. 323 2015 - 2016 Biennial Budget City of Tukwila, Washington Internal Service Fund - Financial Summary Internal Service Funds - 2015 Equipment Rental & Replacement (ERR) Employee Healthcare Leoff 1 Retiree Healthcare Total Internal Service Funds Operating Revenue Charges for Services ERR O &M charges ERR replacement Employer trust contributions Employee contributions Total Charges for Services Miscellaneous Revenue Investment Earnings Sale of capital assets Other Misc Revenue Total Miscellaneous Revenue Total Revenue $ 1,853,707 $ 1,302,126 3,155,833 14,269 442,791 150 457,210 3,613,043 5,015,071 74,093 5,089,164 95,565 2,200 97,765 5,186,929 $ 1,853,707 1,302,126 700,511 5,715,582 74,093 700,511 8,945,508 3,340 113,174 442,791 2,350 3,340 558,315 703,851 9,503,823 Operating Expenses 10 Salaries & Wages 20 Personnel Benefits 30 Supplies 40 Services 50 Intergov't Services & Taxes 388,492 163,767 6,165,438 746,979 237,674 56,600 388,492 931,649 7,260,854 746,979 300,257 5,983 Total Operating Expenses Capital Expenses XX Capital Project Expenses Total Capital Expenses Indirect cost allocation 1,536,912 6,222,038 1,708,000 1,708,000 310,431 119,964 937,632 8,696,582 1,708,000 1,708,000 11,186 441,582 Total Expenses 3,555,343 6,342,002 Change in Fund Balance Beginning Fund Balance 57,700 4,500,000 Ending Fund Balance $ 4,557,700 (1,155,073) 3,500,000 $ 2,344,927 $ 948,819 10,846,164 (244,968) (1,342,341) 500,000 8,500,000 255,032 $ 7,157,659 324 2015 - 2016 Biennial Budget City of Tukwila, Washington Internal Service Funds - 2016 Equipment Rental & Replacement (ERR) Employee Healthcare Leoff 1 Retiree Healthcare Total Internal Service Funds Operating Revenue Charges for Services ERR O &M charges ERR replacement Employer trust contributions Employee contributions Total Charges for Services Miscellaneous Revenue Investment Earnings Sale of capital assets Other Misc Revenue Total Miscellaneous Revenue Total Revenue $ 1,885,680 $ 1,111,203 2,996,883 14,269 442,791 150 457,210 3,454,093 5,416,244 80,020 5,496,264 95,565 2,200 97,765 5,594,029 565,000 $ 1,885,680 1,111,203 5,981,244 80,020 565,000 9,058,147 3,340 113,174 442,791 2,350 3,340 558,315 568,340 9,616,462 Operating Expenses 10 Salaries & Wages 20 Personnel Benefits 30 Supplies 40 Services 50 Intergov't Services & Taxes 397,996 176,209 6,166,938 746,979 239,190 56,600 397,996 600,000 6,943,147 746,979 301,773 5,983 Total Operating Expenses Capital Expenses XX Capital Project Expenses Total Capital Expenses Indirect cost allocation 1,560,374 6,223,538 533,000 533,000 316,578 120,703 Total Expenses 2,409,952 6,344,241 605,983 8,389,895 533,000 533,000 11,408 448,689 617,391 9,371,584 Change in Fund Balance Beginning Fund Balance 1,044,141 4,557,700 Ending Fund Balance $ 5,601,841 (750,212) 2,344,927 $ 1,594,715 $ (49,051) 244,878 255,032 7,157,659 205,981 $ 7,402,537 325 2015 - 2016 Biennial Budget City of Tukwila, Washington This page intentionally left blank 326 2015 - 2016 Biennial Budget City of Tukwila, Washington DEPARTMENT: Public Works FUND: Equipment Rental & Replacement RESPONSIBLE MANAGER: Bob Giberson FUND NUMBER: 501 POSITION: Director Description The mission of the Equipment Rental unit is to provide a fleet of vehicles and equipment with an operation maintenance and replacement program and to supply the City with adequate, safe, economical and on- demand operational cars, trucks and specialty equipment. Services are provided through in -house labor and contracted services. The current fleet consists of approximately 193 vehicles and 134 other pieces of equipment. 2013 -2014 Accomplishments ♦ Reduced City's unfunded fleet liability status to 0% fleet unfunded. ♦ Identified efficiencies in inventory lists resulting in elimination of 47 units. ♦ Updated TMC to reflect improved fleet management and funding practices. ♦ Insourced some of the costly, heavy apparatus services with the procurement of heavy -duty lifts. ♦ Absorbed 107 funded fire equipment into funding program. ♦ Reduced low -use vehicles by 14 units. ♦ Incorporated new patrol vehicle platform into fleet. ♦ Updated Fire technology equipment in apparatus. 2015 -2016 Indicators of Success ♦ Continue to promote the pool car program for maximum use of shared resources. ♦ Evaluate and adjust replacement plan for cost effective and appropriate replacement solutions. 327 2015 - 2016 Biennial Budget City of Tukwila, Washington Performance Measures Public Works - Equipment Rental (Fleet) 2012 Actual 2013 Actual 2014 Estimated 2015 Projection 2016 Projection Improve fleet service Work orders issued (number of service tickets) 1,560 1,676 1,684 1,692 1,700 Preventive Maintenance (PM) Completed 385 359 392 394 396 Gallons of Fuel Consumed 128,612 130,571 138,400 145,320 152,000 Number of Accidents 74 70 77 78 78 Capital Number of new patrol vehicles purchased 0 3 3 3 3 Average Age of Fleet 9 years 9.2 years 10 years 10 years 10 years Inventory Number of passenger vehicles 127 152 154 154 154 Number of motorcycles 7 6 6 6 6 Number of pieces of medium /heavy equipment (dump trucks, etc) 63 64 65 65 65 Number of miscellaneous equipment (mowers, etc) 137 123 124 124 124 328 2015 - 2016 Biennial Budget City of Tukwila, Washington Revenue and Expense Summary Equipment Rental & Replacement Fund 2012 2013 2014 2015 2016 2014 -2015 2015 -2016 Actual Actual Budget Budget Budget % Change % Change Operating Revenue Charges for Services ERR O&M Dept Charges $1,666,423 $1,560,249 $1,390,902 $1,853,707 $1,885,680 33.27% 1.72% Equipment Replacement Charges 717,452 1,032,088 989,190 1,302,126 1,111,203 31.64% - 14.66% Transportation - - - 0.00% 0.00% Total Charges for Services 2,383,875 2,592,337 2,380,092 3,155,833 2,996,883 32.59% - 5.04% Intergovernmental Revenue 10,783 0.00% 0.00% Miscellaneous Revenue Investment Earnings 47,672 12,882 14,269 14,269 14,269 0.00% 0.00% Capital Contributions -Other Funds 1,257,928 - - 0.00% 0.00% OtherMiscRevenue 252 6,918 150 150 150 0.00% 0.00% Total Miscellaneous Revenue 47,923 1,277,728 14,419 14,419 14,419 0.00% 0.00% Sale of Capital Assets 59,790 65,943 442,791 442,791 442,791 0.00% 0.00% Transfers In - Fund 107 1,030,000 - - 0.00% 0.00% Total Operating Revenue 2,502,372 4,966,008 2,837,302 3,613,043 3,454,093 27.34 % - 4.40% Total Revenue 2,502,372 4,966,008 2,837,302 3,613,043 3,454,093 27.34% -4.40% Operating Expenses 10 Salaries & Wages 368,108 379,198 390,032 388,492 397,996 -0.39% 2.45% 20 Personnel Benefits 141,900 149,163 153,471 163,767 176,209 6.71% 7.60% 30 Supplies 675,002 653,244 684,479 746,979 746,979 9.13% 0.00% 40 Services 166,207 93,734 173,040 237,674 239,190 3735% 0.64% Total Operating Expenses 1,351,217 1,275,339 1,401,022 1,536,912 1,560,374 9.70% 1.53% Capital Expenses 60 Capital Outlay 70 Principal 80 Interest Total Capital Expenses Indirect cost allocation Total Expenses 241,246 2,044,013 871,681 1,708,000 533,000 95.94% - 68.79% - - - 0.00% 0.00% - - - 0.00% 0.00% 241,246 2,044,013 871,681 1,708,000 533,000 95.94% - 68.79% 309,667 291,838 298,930 310,431 316,578 3.85% 1.98% 1,902,130 3,611,190 2,571,633 3,555,343 2,409,952 38.25% - 32.22% Change in Fund Balance Beginning Fund Balance 600,243 1,354,818 265,669 57,700 1,044,141 - 78.28% 1709.61% 6,054,118 6,178,154 4,096,520 4,500,000 4,557,700 9.85% 1.28% Ending Fund Balance $ 6,654,361 $ 7,532,972 $ 4,362,189 $ 4,557,700 $ 5,601,841 4.48 % 22.91 % 329 2015 - 2016 Biennial Budget City of Tukwila, Washington Schedule of New and Replacement Purchases in 2015 -2016 CURRENT UNIT UNIT # PURCHASEYEAR Estimated Replacement Year REPLACEMENT UNIT 2015 2016 1 POLICE: L 1 1 1 (a) Cargo Van 1275 i t $ 60,000 2030 Cargo Van, High Roof Extended Area 2 Detective Sedan 1120 30,000 i 2025 Detective Sedan 3 _ Detective Sedan 1123 30,000 2025 Detective Sedan � t 4 Detective Sedan 1141 30,000 2025 Detective Sedan 5 Detective Sedan 1116 30,000 2026 Detective Sedan 6 Detective Sedan 1163 30,000 2026 Detective Sedan 7 Detective, Sniper 3900 63,000 2022 Detective, Sniper 8 Admin Sedan, ER Admin 1717 54,000 2022 Admin Sedan, ER Admin 9 Patrol Vehicle 1715 I 66,000 2020 Patrol Vehicle t t ---- 1 10 Patrol Vehicle 1728 66,000 2020 Patrol Vehicle 11 Patrol Vehicle 1729 66,000 2020 Patrol Vehicle 12 Patrol Vehicle 1185 1 66,000 2021 Patrol Vehicle 13 Patrol Vehicle 1724 66,000 2021 Patrol Vehicle t 14 Patrol Vehicle, K -9 1722 I-� 73,000 2021 Patrol Vehicle, K -9 SHARED COSTS (25% ST /SE /SW/WA): - -� 1 t 15 Dump Truck, 10 yd. 1380 320,000 1 2030 Dump Truck, 10 yd. 16 (new) 95,000 2030 Mini Excavator w/ Trailer (d) SHARED COSTS (50% SE/WA): 117 Vactor 1309 600,000 2030 Vactor STREET: j 18 1380 25,000 2030 De -icer Spray Tank (e) SHARED COSTS (50% SE /SW): Add Camera to Video 19 { 2900 22,000 2020 Inspection Vehicle (e) SURFACE WATER: 1 20 (new) 38,000 2025 Pickup, 3/4 -ton (d) WATER: 21 Cargo Van 1228 50,000 2025 Pickup, Service Truck PARKS: 22 � M ower, front deck 1680 40,000 2025 M ower, front deck 123 Mower, front deck 1677 + 45,000 F 2031 Mower, front deck I 24 Trailer 1011 20,000 2036 Trailer 330 2015 - 2016 Biennial Budget City of Tukwila, Washington CURRENT UNIT UNIT # PURCHASE YEAR Estimated Year REPLACEMENT UNIT 2015 2016 GOLF: I Top Dresser Cart, Utility 1 25 Top Dresser 26 Cart, Utility 1474 1062 + 18,000 10,000 2030 2025 27 Mower, Greens 1649 1 40,000 2026 Core Harvester PLANNING 28 Mower, Reelmaster 6605 85,000 2026 Mower, Reelmaster (DCD): (new) 23,000 2030 Code Enf Admin Sedan(d) 29 j B UILDING MAINTENANCE: 1898 25,000 2035 Manlift 30 1Manlift, Genie Lift 23" EQUIPMENT RENTAL: 31 Hoost P) rtable Heavy Duty 9611 25,000 2040 Tool, Portable Heavy Duty Total by YEAR I $ 1,693,000 I $518,000 Grand Total $ 2,211,000 (a)Re- purpose /re- assign low use unit # 1275 to Custodians eliminating purchase budgeted in 2014 (b) Adds value to existing units (c) Purchase De -icer tank instead of new Sander for dual response abilities (d) Purchase dependent upon approval 331 2015 - 2016 Biennial Budget City of Tukwila, Washington Expenditure Detail - Salaries and Benefits Salaries for budgeted positions are based on actual costs for existing positions and include a cost of living adjustment per contract agreements. Eauinment Rental & Replacement Fund Position Description 2014 FTE 2015 FTE 2015 Budgeted Salaries Benefits 2016 FTE 2016 Budgeted Salaries Benefits Maint & Ops Superintendent 1 1 $ 96,552 $ 33,689 1 $ 98,928 $ 36,274 Fleet Technician 4 4 275,940 129,128 4 283,068 138,985 Extra Labor 14,000 - 14,000 - Overtime 2,000 - 2,000 - Clothing Allowance - 950 - 950 Department Total 5 5 $ 388,492 $ 163,767 5 $ 397,996 $ 176,209 332 2015 - 2016 Biennial Budget City of Tukwila, Washington Expenditure Detail - Supplies, Services, and Other Supplies include office supplies as well as repair and maintenance parts for vehicles maintained by the City and small tools. Services include equipment repair and replacement charges, liability insurance, and fleet repairs by outside vendors, among others. Capital includes equipment replacement purchases schedule for the 2015 -2016 biennium. Eauivment Rental & Re lacement Fund Account Number Purpose 2012 Actual 2013 Actual 2014 Budget 2015 Budget 2016 Budget Supplies 501.01.548.650.31.00 Supplies - Office & Operating $ 970 $ 1,829 $ 2,979 $ 2,979 $ 2,979 501.01.548.650.31.90 Supplies - Central 400 - - - - 501.01.548.650.34.01 Supplies - Repair & Maintenance 166,462 156,948 150,000 200,000 200,000 501.01.548.650.34.02 Supplies - Inventory /Resale Items 48,317 54,123 55,000 55,000 55,000 501.01.548.650.34.03 Supplies - Fuel 454,368 436,643 474,000 485,000 485,000 501.01.548.650.35.00 Small Tools & Minor Equipment -Tools 4,484 3,700 2,500 4,000 4,000 Total Supplies 675,002 653,244 684,479 746,979 746,979 Services 501.01.548.650.41.00 Prof Svcs - DOT health exams, drug screening, audiology tests 1,652 1,531 1,000 1,750 1,750 501.01.548.650.42.00 Communication - Phone charges, Nextels, and UPS shipping fees 1,294 1,318 2,000 1,000 1,000 501.01.548.650.43.00 Travel - Parking, mileage 144 - - - - 501.01.548.650.44.00 Advertising - Ads - 373 - - - 501.01.548.650.45.00 Rental - Equipment lease 392 861 1,050 1,050 1,050 501.01.548.650.45.94 Rental - Equipment Replacement 12,113 15,528 16,568 27,899 29,045 501.01.548.650.45.95 Rental - Equipment 0 & M 20,699 21,992 13,511 14,011 14,019 501.01.548.650.46.00 Insurance - Liability and property program assessment allocation to WCIA 10,130 10,828 10,130 62,183 62,545 501.01.548.650.48.00 R &M - Fleet repairs by outside vendors 111,371 34,171 120,781 120,781 120,781 501.01.548.650.49.00 Misc - Reg., trng, memberships, laundry svc, vehicle lic., sub. 8,413 7,132 8,000 9,000 9,000 Total Services 166,207 93,734 173,040 237,674 239,190 Other 501.01.594.480.64.00 Capital - Machinery & equipment - - 15,000 15,000 15,000 501.02.594.480.64.00 Capital - Machinery & equipment 241,246 2,044,013 856,681 1,693,000 518,000 Total Other 241,246 2,044,013 871,681 1,708,000 533,000 Total Supplies, Services and Other $ 1,082,455 $ 2,790,991 $ 1,729,200 $ 2,692,653 $ 1,519,169 333 2015 - 2016 Biennial Budget City of Tukwila, Washington This page intentionally left blank 334 2015 - 2016 Biennial Budget City of Tukwila, Washington DEPARTMENT: Finance FUND: Self Insured Healthcare Plan RESPONSIBLE MANAGER: Peggy McCarthy FUND NUMBER: 502 POSITION: Director Description This fund accounts for the City's self - insured healthcare plan. This fund receives contributions on behalf of the employees through premiums charged to their respective organization units. Healthcare claims, program administrative fees and a Wellness Program are expensed in this fund. 2013 - 2014 Accomplishments ♦ Made plan changes consistent with the Affordable Care Act including offering participation in the plan to Councilmembers. ♦ Adopted an actuarial based rate setting and reserve funding policy and procedures in response to changes in state law governing self - insured healthcare plans. ♦ Made changes in funding level to reduce plan overfunding and achieve balance between annual premium charges and maintenance of reserve levels. 2015 -2016 Outcome Goals ♦ Continue to respond to, and in comply, with the Patient Protection and Affordable Care Act (PPACA). ♦ Review and adjust plan benefit structure to avoid paying the "Cadillac tax ", an annual 40% excise tax on plans with premiums exceeding $10,200 for individuals or $27,500 for families (not including vision and dental benefits) starting in 2018. 2015 -2016 Indicators of Success ♦ A premium structure that adequately funds the plan and maintains a smooth and predictable premium trajectory is achieved. ♦ Plan is structured such that the PPACA excise tax is not assessed. ♦ A balance is maintained between Plan benefits and City priorities. 335 2015 - 2016 Biennial Budget City of Tukwila, Washington Revenue and Expense Summary Self Insured Healthcare Plan Fund 2012 2013 2014 2015 2016 2014 -2015 2015 -2016 Actual Actual Budget Budget Budget % Change % Change Operating Revenue Charges for Services Employee Benefit Programs $ 748 $ 711 $ 1,200 $ 1,200 $ 1,200 0.00% 0.00% Total Charges for Services 748 711 1,200 1,200 1,200 0.00% 0.00% Miscellaneous Revenue Investment Earnings 261,668 (34,954) 96,000 95,565 95,565 -0.45% 0.00% Employer Trust Contributions 4,329,483 4,375,649 4,483,192 5,015,071 5,416,244 11.86% 8.00% Employee Contributions 63,766 70,225 78,000 74,093 80,020 -5.01 % 8.00 % Other Misc Revenue - - 1,000 1,000 1,000 0.00% 0.00% Total Miscellaneous Revenue 4,654,916 4,410,919 4,658,192 5,185,729 5,592,829 11.32% 7.85% Total Revenue 4,655,664 4,411,630 4,659,392 5,186,929 5,594,029 11.32% 7.85% Operating Expenses 10 Salaries & Wages 0.00% 0.00% 20 Personnel Benefits 4,713,591 4,628,141 5,252,006 6,165,438 6,166,938 17.39% 0.02% 30 Supplies 0.00% 0.00% 40 Services 50,863 43,822 45,500 56,600 56,600 24.40% 0.00% 50 Intergov't Services & Taxes - - - 0.00% 0.00% Total Operating Expenses 4,764,454 4,671,963 5,297,506 6,222,038 6,223,538 17.45% 0.02% Indirect cost allocation 80,305 73,709 75,500 119,964 120,703 58.89% 0.62% Total Expenses 4,844,759 4,745,672 5,373,006 6,342,002 6,344,241 18.03% 0.04% Change in Fund Balance Beginning Fund Balance (189,094) (334,042) (713,614) (1,155,073) (750,212) 61.86% - 35.05% 4,983,480 4,794,386 4,147,243 3,500,000 2,344,927 - 15.61% - 33.00% Ending Fund Balance $ 4,794,386 $ 4,460,344 $ 3,433,629 $ 2,344,927 $1,594,715 - 31.71% - 31.99% 336 2015 - 2016 Biennial Budget City of Tukwila, Washington Expenditure Detail - Supplies, Services, and Other Employee benefits costs include medical, vision, and dental claims for all employees and dependents. Services includes broker fees, other healthcare plan fees, and Wellness program costs. Self Insured Health Care Plan Fund Account Number Purpose 2012 Actual 2013 Actual 2014 Budget 2015 Budget 2016 Budget Employee Benefits 502.00.517.370.25.00 Benefits - Self insured medical claims 3,389,662 2,948,537 3,300,000 4,365,218 4,365,218 502.00.517.370.25.01 Benefits - Dental claims 520,650 561,299 634,329 506,213 506,213 502.00.517.370.25.02 Benefits - Prescription claims 641,466 790,179 680,551 680,551 680,551 502.00.517.370.25.03 Benefits - Vision claims 20,148 24,373 27,040 21,710 21,710 502.00.517.370.25.04 Benefits - Stop loss reimbursements (273,186) (77,342) (75,000) (75,000) (75,000) 502.00.517.370.25.05 Benefits - Prescription fees (589) - - - - 502.00.517.370.25.06 Benefits - TPD Admin fees 126,644 143,321 166,211 184,061 184,061 502.00.517.370.25.07 Benefits - Excess loss premiums 288,795 237,774 330,625 407,185 407,185 502.00.517.370.25.10 Benefits - IBNR adjustment - - 188,250 75,500 77,000 Total Supplies 4,713,591 4,628,141 5,252,006 6,165,438 6,166,938 Services 502.00.517.370.41.00 Prof Svcs - Broker fees 34,354 28,510 25,000 31,900 31,900 502.00.517.370.49.00 Misc - Other healthcare plan fees 2,855 2,505 2,500 6,700 6,700 502.00.517.900.49.01 Misc - Wellness program 13,654 12,807 18,000 18,000 18,000 Total Services 50,863 43,822 45,500 56,600 56,600 Total Supplies, Services and Other $ 4,764,454 $ 4,671,963 $ 5,297,506 $ 6,222,038 $ 6,223,538 337 2015 - 2016 Biennial Budget City of Tukwila, Washington This page intentionally left blank 338 2015 - 2016 Biennial Budget City of Tukwila, Washington DEPARTMENT: Finance FUND: LEOFF I Retiree Self- Insured Healthcare Plan RESPONSIBLE MANAGER: Peggy McCarthy DIVISION: N/A FUND NUMBER: 503 POSITION: Director Description This fund accounts for the City's self- insured healthcare plan for Law Enforcement Officers and Fire Fighters (LEOFF I) retirees. This fund receives contributions on behalf of retired LEOFF I employees through their respective organization units. Healthcare claims and program administrative fees are expensed in this fund. 2013 - 2014 Accomplishments ♦ Made plan changes consistent with the Affordable Care Act including offering participation in the plan to Councilmembers. ♦ Adopted an actuarial based rate setting and reserve funding policy and procedures in response to changes in state law governing self- insured healthcare plans. ♦ Made changes in funding level to reduce plan overfunding and achieve balance between annual premium charges and maintenance of reserve levels. 2015 -2016 Outcome Goals ♦ Optimize use of medicare insurance coverage to manage plan costs. ♦ Continue to analyze and revise funding structure to achieve a smooth and predicable premium trend. 2015 -2016 Indicators of Success ♦ A smooth funding trend is achieved. ♦ Reserves levels are maintained. ♦ Costs are managed and stabilized. 339 2015 - 2016 Biennial Budget City of Tukwila, Washington Revenue and Expense Summary LEOFF I Retiree Self - Insured Healthcare Plan Fund 2012 2013 2014 2015 2016 2014 -2015 2015 -2016 Actual Actual Budget Budget Budget % Change % Change Operating Revenue Miscellaneous Revenue Investment Earnings $ 3,565 $ 2,707 $ 3,340 $ 3,340 $ 3,340 0.00% 0.00% Trust Contributions - Employer 467,007 - - 700,511 565,000 0.00% -19.34% Total Miscellaneous Revenue 470,572 2,707 3,340 703,851 568,340 20973.38% - 19.25% Total Revenue 470,572 2,707 3,340 703,851 568,340 20973.38% - 19.25% Operating Expenses 20 Personnel Benefits 380,867 802,848 523,672 931,649 600,000 77.91% - 35.60% 30 Supplies - - 0.00% 0.00% 40 Services 2,540 4,890 19,500 5,983 5,983 - 69.32% 0.00% Total Operating Expenses 383,407 807,738 543,172 937,632 605,983 72.62% - 35.37% Indirect cost allocation Total Expenses 4,619 9,619 9,906 11,186 11,408 12.92% 1.99% 388,026 817,357 553,078 948,819 617,391 71.55% - 34.93% Change in Fund Balance Beginning Fund Balance 82,546 (814,650) (549,738) (244,968) (49,051) - 55.44% - 79.98% 1,628,987 1,711,532 1,094,849 500,000 255,032 -54.33% -48.99% Ending Fund Balance $ 1,711,533 $ 896,882 $ 545,111 $ 255,032 $ 205,981 - 53.21% - 19.23% 340 2015 - 2016 Biennial Budget City of Tukwila, Washington Expenditure Detail - Supplies, Services, and Other Employee benefits costs include medical, vision, and dental claims for LEOFF I members. Services includes broker fees and other healthcare plan fees. LEOFF I Retiree Self - Insured Healthcare Plan Fund Account Number Purpose 2012 Actual 2013 Actual 2014 Budget 2015 Budget 2016 Budget Employee Benefits 503.00.517.370.25.00 Benefits - Self- insured medical & dental 632,790 184,147 272,102 608,093 264,183 503.00.517.370.25.01 Benefits - Dental claims 34,312 34,687 36,799 33,874 33,874 503.00.517.370.25.02 Benefits - Prescription claims 142,159 111,944 133,803 147,183 147,183 503.00.517.370.25.03 Benefits - Vision claims 7,628 11,535 10,816 6,499 6,499 503.00.517.370.25.04 Benefits - Stop loss reimbursements (52,717) - - - 503.00.517.370.25.05 Benefits - Prescription fees - (133) - - - 503.00.517.370.25.06 Benefits - TPA admin fees 16,272 15,728 30,853 18,196 18,196 503.00.517.370.25.07 Benefits - Excess loss premiums 13,868 14,424 16,639 22,819 25,101 503.00.517.370.25.08 Benefits - Long term care 8,535 8,535 9,410 22,785 25,064 503.00.517.370.25.10 Benefits - IBNR adjustment - - 13,250 24,200 27,100 503.00.517.370.25.20 Benefits - Medical,dental,life,optical - - - 18,000 19,800 503.00.517.370.25.21 Benefits - Medical,dental,life,optical - - - 30,000 33,000 Total Supplies 802,848 380,867 523,672 931,649 600,000 Services 503.00.517.370.41.00 Prof Svcs - Broker fees 4,390 1,870 19,500 5,183 5,183 503.00.517.370.49.00 Misc - Plan document fees 500 670 - 800 800 Total Services 4,890 2,540 19,500 5,983 5,983 Total Supplies, Services and Other $ 807,738 $ 383,407 $ 543,172 $ 937,632 $ 605,983 341 2015 - 2016 Biennial Budget City of Tukwila, Washington This page intentionally left blank 342 2015 - 2016 Biennial Budget City of Tukwila, Washington DEPARTMENT: N/A FUND: Firemen's Pension RESPONSIBLE MANAGER: Peggy McCarthy DIVISION: N/A FUND NUMBER: 611 POSITION: Director Description This fund essentially exists to support eleven (11) firefighters who qualify for a City pension system prior to 1971. Firemen's Pension Fund 611 - Revenue and Expenditures 2012 2013 2014 2015 2016 2014 -2015 2015 -2016 Actual Actual Budget Budget Budget % Change % Change Operating Revenue Fire Insurance Premium Tax $ 52,249 $ 56,962 $ 56,650 $ 56,650 $ 56,650 0.00% 0.00% Interest 2,770 2,421 2,000 2,000 2,000 0.00% 0.00% 55,019 59,383 58,650 58,650 58,650 0.00% 0.00% Total Revenue Operating Expenses 20 Personnel Benefits 118,532 114,853 107,727 107,727 107,727 0.00% 0.00% 40 Services 4,650 15,575 25,000 25,000 25,000 0.00% 0.00% Total Expenses 123,182 130,428 132,727 132,727 132,727 0.00% 0.00% Change in Fund Balance (68,162) (71,045) (74,077) (74,077) (74,077) 0.00% 0.00% Beginning Fund Balance 1,407,750 1,500,000 1,425,923 6.55% - 4.94% Ending Fund Balance $ (68,162) $ (71,045) $ 1,333,673 $ 1,425,923 $ 1,351,846 6.92% -5.20% 343 2015 - 2016 Biennial Budget City of Tukwila, Washington This page intentionally left blank 344