The URL can be used to link to this page

Council PKT 11-07-2017 Special4% CITY OF t Federal Way Centered on Opportunity CITY COUNCIL SPECIAL MEETING /STUDY SESSION AGENDA Council Chambers - City Hall November 7, 2017 — 5:00 p.m. 1. CALL MEETING TO ORDER 2. STUDY SESSION a. 2017/2018 Mid - Biennial Budget Adjustmert & 2018 Property Tax Rate • Staff Presentation: Ade Ariwoola, Finance Director • Citizen Comments — 3 minutes each • Council Discussion /Questions 3. ADJOURNMENT City Council Meetings are wheelchair accessible; and assisted listening devices for use in the Council Chambers are available upon request to the City Clerk. Regular Meetings are recorded and televised live on Government Access Channel 21. To view Council Meetings online please visit www.cityoffederalway.com. CITY OF �... Federal Way Centered on Opportunity 2017 Budget Adjustments by Fund Table of Contents Page GENERAL FUND (FUND 001) General Fund 3 SPECIAL REVENUE FUNDS (FUNDS 10015) Street 5 Arterial Street 5 Utility Tax 6 Solid Waste & Recycling 6 Special Studies /Contracts 6 Hotel /Motel Lodging Tax 7 FWCC Fund 7 Traffic Safety Fund 8 REETFund 8 Prop 1 Utax Fund 9 PAEC Operating Fund 9 Transportation Benefit District Fund 10 Community Development Block Grant Fund 10 Paths & Trails Fund 10 Strategic Reserve Fund 10 Parks Reserve Fund 11 DEBT FUNDS (FUNDS 200'S) Debt Service Fund 13 CAPITAL PROJECT FUNDS (FUNDS 30015) Downtown Redevelopment Fund 15 Municipal Facilities Fund 15 Parks CIP Fund 16 SWM CIP Fund 16 Transportation CIP Fund 17 Capital Project Reserve Fund 18 PAEC CIP Fund 18 ENTERPRISE FUNDS (FUNDS 400'S) SWM Operations Fund 20 DBC Fund 20 INTERNAL SERVICES FUNDS (FUNDS 500'S) Risk Fund 22 Information Technology Fund 22, 23 Mail & Duplication Fund 23 Fleet & Equipment Fund 23 Buildings & Furnishings Fund 24 Health Ins Fund 24 Unemployment Ins Fund 24 2017 Budget Adjustments 1 of 24 November 7, 2017 GENERAL FUND (FUND 001) 2017 Budget Adjustments 2 of 24 November 7, 2017 2017/18 Budget Adjustments Additions General Fund Impact 2017 Beginning Fund Balance - Current Budget 10,034,954 Adjustment to Beginning Fund Balance 1,055,315 Beginning Fund Balance - Adjusted Budget 11,090,269 Revenue - Current Budget 48,668,287 Sales Tax Decrease (115,000) Criminal Justice Sales Tax 50,000 Liquor Excise Tax 110,000 State Shared Revenue 105,000 Business License Revenue (200,000) Police Grant Revenue 150,000 Police Overtime Contract Revenue 100,000 Parks Recreation Revenue 75,000 Court Revenue Decrease (150,000) Transfer In from Utility Tax 1,000,000 Department of Commerce Grant Revenue for Day Shelter Services 50,000 Port of Seattle Grant Revenue for Economic Development 22,587 Revenue - Adjusted Budget 49,865,874 Expenditure - Current Budget 48,751,194 ED - Port of Seattle Grant Expenditures for Economic Development 22,587 CD - Department of Commerce Grant Expenditures for Day Shelter Services 50,000 Law - Book Price Increase 100 Law - Adobe License & Supplies 400 Law - Required Attendance at Luncheon Events 60 Law - Laptop Purchase 1,500 Law - Investigation Services 900 Law - Legal Professional Services for Non - Litigation 75,000 PD - Contractual Vacation Payout for Labor Groups /Sworn Personnel 110,000 PD - Restore Fleet & Equipment Replacement Reserves to Original Levels 357,693 PK - PROS Plan Professional Services (1 -time) 20,000 IT - Police Department Cellular Services Cost Increase (In 502 IT Fund) 6,471 IT - King County Radio Services Cost Increase (In 502 IT Fund) 6,469 IT - Police Department Microsoft License /Office Software License (In 502 IT Fund) 9,950 IT - Reduce 1.5 FTE IT Application Specialist & IT Equipment for Police Officers (131,166) NON -DEPT - Transfer Out to Street Fund 930,000 Expenditure - Adjusted Budget 50,211,158 Ending Fund Balance - Current Budget 9,952,047 Adjustment to Ending Fund Balance 792,938 Ending Fund Balance - Adjusted Budget 10,744,985 3 of 24 2017 Budget Adjustments November 7, 2017 SPECIAL REVENUE FUNDS (FUNDS 100'S) 2017 Budget Adjustments 4 of 24 November 7, 2017 Street Fund 2017 Beginning Fund Balance - Current Budget 500,000 Adjustment to Beginning Fund Balance 26,510 Beginning Fund Balance - Adjusted Budget 526,510 Revenue - Current Budget 4,148,199 WSDOT Grant Revenue for Dash Point Road Mud Slide 92,636 Commute Trip Reduction Grant Revenue 25,535 Reduce Transer in from Transportation Benefite District Fund (930,000) Transfer in from General Fund 930,000 Transfer in from Utility Tax Fund 40,091 Revenue - Adjusted Budget 4,306,461 Expenditure - Current Budget 4,092,470 Temporary Help 10,000 WSDOT Grant Use for Additional Salt Storage Facilities 92,636 Operation & Maintenance of New Traffic Infrastructure 32,700 Electricity Rate Increase 26,806 Commute Trip Reduction Grant Expenditure 25,535 Neighborhood Traffic Safety Program (37,000) Expenditure - Adjusted Budget 4,243,147 Ending Fund Balance - Current Budget 555,729 Adjustment to Ending Fund Balance 34,095 Ending Fund Balance - Adj Budget 589,824 Arterial Street Fund 2017 Beginning Fund Balance - Current Budget 100,000 Adjustment to Beginning Fund Balance 145,970 Beginning Fund Balance - Adjusted Budget 245,970 Revenue - Current Budget 1,515,410 Mitigation Impact Fees 40,000 Puget Sound Energy Contribution 288,682 Revenue - Adjusted Budget 1,844,092 Expenditure - Current Budget 1,515,410 Annual Asphalt Overlay Project Costs 438,682 Expenditure - Adjusted Budget 1,954,092 Ending Fund Balance - Current Budget 100,000 Adjustment to Ending Fund Balance 35,970 Ending Fund Balance - Adj Budget 135,970 2017 Budget Adjustments 5 of 24 November 7, 2017 Utility Tax Fund 2017 Beginning Fund Balance - Current Budget 1,842,718 Adjustment to Beginning Fund Balance 614,969 Beginning Fund Balance - Adjusted Budget 2,457,687 Revenue - Current Budget 8,918,924 Utility Tax Revenue 510,368 Revenue - Adjusted Budget 9,429,292 Expenditure - Current Budget 9,261,642 Transfer Out to General Fund 1,000,000 Transfer Out to Street Fund 40,091 Transfer Out to Federal Way Community Center Fund 76,836 Transfer Out to Performing Arts & Event Center Fund 8,410 Expenditure - Adjusted Budget 10,386,979 Ending Fund Balance - Current Budget 1,500,000 Adjustment to Ending Fund Balance 0 Ending Fund Balance - Adj Budget 1,500,000 Solid Waste & Recycling Fund 2017 Beginning Fund Balance - Current Budget 175,352 Adjustment to Beginning Fund Balance 957 Beginning Fund Balance - Adjusted Budget 176,309 Revenue - Current Budget 431,117 Revenue - Adjusted Budget 431,117 Expenditure - Current Budget 503,121 Hauler Procurement Process Professional Services Agreement (22,000) Expenditure - Adjusted Budget 481,121 Ending Fund Balance - Current Budget 103,348 Adjustment to Ending Fund Balance 22,957 Ending Fund Balance - Adj Budget 126,305 Special Studies /Contracts Fund 2017 Beginning Fund Balance - Current Budget 408,356 Adjustment to Beginning Fund Balance 117,072 Beginning Fund Balance - Adjusted Budget 525,428 _ _ Revenue - Current Budget - Revenue - Adjusted Budget - Expenditure - Current Budget - Expenditure - Adjusted Budget - Ending Fund Balance - Current Budget 408,356 Adjustment to Ending Fund Balance 117,072 Ending Fund Balance - Adj Budget 525,428 6 of 24 2017 Budget Adjustments November 7, 2017 Hotel /Motel Lodging Tax Fund 2017 Beginning Fund Balance - Current Budget 501,765 Adjustment to Beginning Fund Balance 235,610 Beginning Fund Balance - Adjusted Budget 737,375 Revenue - Current Budget 225,700 Increase in FWCC Revenue 42,950 Revenue - Adjusted Budget 225,700 Expenditure - Current Budget 224,700 Revenue - Adjusted Budget 2,278,455 Expenditure - Adjusted Budget 224,700 Ending Fund Balance - Current Budget 502,765 Adjustment to Ending Fund Balance 235,610 Ending Fund Balance - Adj Budget 738,375 FWCC Fund 2017 Beginning Fund Balance - Current Budget 1,516,500 Adjustment to Beginning Fund Balance (0) Beginning Fund Balance - Adjusted Budget 1,516,500 Revenue - Current Budget 2,200,350 Increase in FWCC Revenue 42,950 Decrease of FWCC Revenue due to Bad Debt write -off (account charge errors) (41,681) Transfer in from Utility Tax Fund 76,836 Revenue - Adjusted Budget 2,278,455 Expenditure - Current Budget 2,216,850 Temporary Help, Instructors, Seasonal Help, Overtime, & Benefits Increase 179,345 Maintenance Supplies Increase 5,750 Professional Services Decrease (49,700) Utilities Decrease (42,300) Taxes /Assessments Decrease (14,990) Expenditure - Adjusted Budget 2,294,955 Ending Fund Balance - Current Budget 1,500,000 Adjustment to Ending Fund Balance (0) Ending Fund Balance - Adj Budget 1,500,000 2017 Budget Adjustments 7 of 24 November 7, 2017 Traffic Safety Fund 2017 Beginning Fund Balance - Current Budget 2,558,371 Adjustment to Beginning Fund Balance (7,092) Beginning Fund Balance - Adjusted Budget 2,551,279 Revenue - Current Budget 3,140,374 Traffic Safety (Red Light Photo) Revenue 200,000 Revenue - Adjusted Budget 3,340,374 Expenditure - Current Budget 3,495,761 Traffic Count Program Professional Services (moved from 101 Street Fund) 10,000 KC Traffic Maintenance Rate Increase (moved from 101 Street Fund) 13,285 Traffic Signal Communication Upgrade (moved from 101 Street Fund) 104,600 Expenditure - Adjusted Budget 3,623,646 Ending Fund Balance - Current Budget 2,202,984 Adjustment to Ending Fund Balance 65,023 Ending Fund Balance - Adj Budget 2,268,007 REET Fund 2017 Beginning Fund Balance - Current Budget 3,078,496 Adjustment to Beginning Fund Balance 1,878,537 Beginning Fund Balance - Adjusted Budget 4,957,033 Revenue - Current Budget 3,200,000 REET 1 & 2 Tax 1,101,594 Revenue - Adjusted Budget 4,301,594 Expenditure - Current Budget 3,739,023 _ Transfer out to Parks Reserve Fund 500,000 Transfer out to Debt Service Fund 1,200,000 Transfer out to Dumas Bay Centre Fund 500,000 Transfer out to Information Technology Fund for PAEC IT Equipment (Moved from 115 PAEC Fund) 109,338 Expenditure - Adjusted Budget 6,048,361 Ending Fund Balance - Current Budget 2,539,473 Adjustment to Ending Fund Balance 670,793 Ending Fund Balance - Adj Budget 3,210,266 2017 Budget Adjustments 8 of 24 November 7, 2017 Prop 1 Utax Fund 2017 Beginning Fund Balance - Current Budget 1,077,462 Adjustment to Beginning Fund Balance 212,771 Beginning Fund Balance - Adjusted Budget 1,290,233 Revenue - Current Budget 2,921,481 Prop 1 Utility Tax Revenue 100,000 Revenue - Adjusted Budget 3,021,481 Expenditure - Current Budget 2,998,943 Contributed Revenue - Membership /Corporations (10,000) Expenditure - Adjusted Budget _ 2,998,943 Ending Fund Balance - Current Budget 1,000,000 Adjustment to Ending Fund Balance 312,771 Ending Fund Balance -Adj Budget 1,312,771 PAEC Operating Fund 2017 Beginning Fund Balance - Current Budget - Adjustment to Beginning Fund Balance 177,413 Beginning Fund Balance - Adjusted Budget 177,413 Revenue - Current Budget 937,546 Ticketing Sales & Fees Revenue (9,472) Theatre Rental Revenue (19,328) Advertising Revenue (25,000) Contributed Revenue - Membership /Corporations (10,000) Contributed Revenue - Foundations /Govt (10,000) Contributed Revenue - Fundraising (15,000) Transfer in from Utility Tax Fund 8,410 NMTC Donation & Interest Income 161,593 Revenue - Adjusted Budget 1,018,749 _ Expenditure - Current Budget 937,546 Food & Beverage - Hospitality for Guest Artists 910 Electricity Increase 20,459 Water Increase 2,958 Sewer Increase 1,229 Gas Increase 3,324 Waste Disposal & Recycling Increase 1,583 PAEC IT - Building Wi -Fi, Copy /Printer, Desktop, Phones, Alarm, Box Office Ticketing Hardware, Fiber Connectivity, Networking, & Security Surveillance (1 -time) (In 502 IT Fund) (2017 - moved $109,338 to be funded by REET) 56,734 PAEC IT - Annual Service for Two Century Link POTS Lines (In 502 IT Fund) 466 PAEC IT - Annual Maintenance of CISCO IP Phone System (In 502 IT Fund) 5,483 Annual Copy & Printer costs (In 503 Mail & Duplication Fund) 3,300 NMTC Rent 162,170 Expenditure - Adjusted Budget 1,196,162 Ending Fund Balance - Current Budget - Adjustment to Ending Fund Balance - Ending Fund Balance - Adj Budget - 9 of 24 2017 Budget Adjustments November 7, 2017 Transportation Benefit District Fund 2017 Beginning Fund Balance - Current Budget - _ Revenue - Current Budget 930,000 Eliminate Transportation Benefit District Fund Revenue (930,000) Revenue - Adjusted Budget - Expenditure - Current Budget 930,000 Reduce Transfer Out to Street Fund (930,000) Expenditure - Adjusted Budget - Ending Fund Balance - Adj Budget - Community Development Block Grant Fund 2017 Beginning Fund Balance - Current Budget 40,441 Adjustment to Beginning Fund Balance 25,387 Beginning Fund Balance - Adjusted Budget 65,828 Revenue - Current Budget 1,237,103 Revenue - Adjusted Budget 169,000 Revenue - Adjusted Budget 1,237,103 Expenditure - Current Budget 1,277,541 Ending Fund Balance - Current Budget 722,356 Expenditure - Adjusted Budget 1,277,541 Ending Fund Balance - Current Budget 3 Adjustment to Ending Fund Balance 25,387 Ending Fund Balance - Adj Budget 25,390 Paths & Trails Fund 2017 Beginning Fund Balance - Current Budget 553,356 Adjustment to Beginning Fund Balance 15,366 Beginning Fund Balance - Adjusted Budget 568,722 Revenue - Current Budget 169,000 Revenue - Adjusted Budget 169,000 Expenditure - Current Budget - Expenditure - Adjusted Budget - Ending Fund Balance - Current Budget 722,356 Adjustment to Ending Fund Balance 15,366 Ending Fund Balance - Adj Budget 737,722 Strategic Reserve Fund 2017 Beginning Fund Balance - Current Budget 3,000,000 Adjustment to Beginning Fund Balance 21,716 Beginning Fund Balance - Adjusted Budget 3,021,716 Ending Fund Balance - Current Budget 3,000,000 Adjustment to Ending Fund Balance 21,716 Ending Fund Balance - Adj Budget 3,021,716 10 of 24 2017 Budget Adjustments November 7, 2017 Parks Reserve Fund 2017 Beginning Fund Balance - Current Budget 750,000 Adjustment to Beginning Fund Balance 2,652 Beginning Fund Balance - Adjusted Budget 752,652 Revenue - Current Budget - Transfer in from REET 500,000 Revenue - Adjusted Budget 500,000 Expenditure - Current Budget - Transfer out to 504 Fleet & Equipment Fund for Turf Equipment for Fields 128,806 Expenditure - Adjusted Budget 128,806 Ending Fund Balance - Current Budget 750,000 Adjustment to Ending Fund Balance 373,846 Ending Fund Balance - Adj Budget 1,123,846 2017 Budget Adjustments 11 of 24 November 7, 2017 DEBT SERVICE FUNDS (FUNDS 200's) 2017 Budget Adjustments 12 of 24 November 7, 2017 Debt Service Fund 2017 Beginning Fund Balance - Current Budget 2,499,999 Adjustment to Beginning Fund Balance 8,515 Beginning Fund Balance - Adjusted Budget 2,508,514 Revenue - Current Budget 10,345,926 Transfer in from REET 1,200,000 Debt Refunding 6,000,000 Reduce Sale Proceeds (6,759,862) Revenue - Adjusted Budget 10,786,064 Expenditure - Current Budget 10,082,279 Fees for Servicing Debt 2,000 Expenditure - Adjusted Budget 10,084,279 Ending Fund Balance - Current Budget 2,763,646 Adjustment to Ending Fund Balance 446,653 Ending Fund Balance - Adj Budget 3,210,299 2017 Budget Adjustments 13 of 24 November 7, 2017 CAPITAL PROJECT FUNDS (FUNDS 300'S) 2017 Budget Adjustments 14 of 24 November 7, 2017 Downtown Redevelopment Fund 2017 Beginning Fund Balance - Current Budget 1,912,244 Adjustment to Beginning Fund Balance 206,855 Beginning Fund Balance - Adjusted Budget 2,119,099 Revenue - Current Budget 1,000,000 Revenue - Adjusted Budget 1,000,000 Expenditure - Current Budget 500,000 Transfer out LIFT to Transportation CIP Project 21st Ave S Sidewalks 175,000 Transfer out LIFT to Transportation CIP Grand Staircase Project 1,500,000 On -Call Surveying Services 5,000 Expenditure - Adjusted Budget 2,180,000 Ending Fund Balance - Current Budget 2,412,244 Adjustment to Ending Fund Balance (1,473,145) Ending Fund Balance - Adj Budget 939,099 Municipal Facilities Fund 2017 Beginning Fund Balance - Current Budget 53,232 Adjustment to Beginning Fund Balance (23,639) Beginning Fund Balance - Adjusted Budget 29,593 Ending Fund Balance - Current Budget 53,232 Adjustment to Ending Fund Balance (23,639) Ending Fund Balance - Adj Budget 29,593 2017 Budget Adjustments 15 of 24 November 7, 2017 Parks CIP Fund 2017 Beginning Fund Balance - Current Budget 2,143,499 Adjustment to Beginning Fund Balance (7,910) Beginning Fund Balance - Adjusted Budget 2,135,589 Revenue - Current Budget 300,000 Mitigation Impact Fees 70,000 Revenue - Adjusted Budget 370,000 Expenditure - Current Budget 2,367,163 Town Square Park Capital Expenditure 63,043 Expenditure - Adjusted Budget 2,430,206 Ending Fund Balance - Current Budget 76,336 Adjustment to Ending Fund Balance (953) Ending Fund Balance - Adj Budget 75,383 SWM CIP Fund 2017 Beginning Fund Balance - Current Budget 4,234,329 Adjustment to Beginning Fund Balance (126,415) Beginning Fund Balance - Adjusted Budget 4,107,914 Revenue - Current Budget 540,000 West Hylebos Trail Spring Valley Grant (60,000) West Hylebos Educational Center & Trail Grant (80,000) Revenue - Adjusted Budget 400,000 Expense - Current Budget 3,209,988 West Hylebos Conservation Property Acquisition (279,988) West Hylebos Basin Land Acquistion (226,000) West Hylebos Basin Regional Flow Control Alternative Analysis (78,000) S 336th St Water Quality Facility 100,000 Marine Hills Conveyance System Repairs (981,000) Lakota Wetland Berm Repair 53,000 W Hylebos WetlandsTrail (Brooklake Connection) 50,000 West Hylebos Trail Spring Valley (100,000) West Hylebos Educational Center & Trail (108,000) Bridges Property Culvert Removal & Replacement (75,000) Expense - Adjusted Budget 1,565,000 Ending Fund Balance - Current Budget 1,564,341 Adjustment to Ending Fund Balance 1,378,573 Ending Fund Balance - Adj Budget 2,942,914 2017 Budget Adjustments 16 of 24 November 7, 2017 Transportation CIP Fund 2017 Beginning Fund Balance - Current Budget 4,420,026 Adjustment to Beginning Fund Balance 5,569,586 Beginning Fund Balance - Adjusted Budget 9,989,612 Revenue - Current Budget 16,915,000 SW 336th Way /SW 340th St: 26th PI SW - Hoyt Rd / /REET 867,458 S 356th St: SR99 - SR161 /Grant (118,327) S 356th St: SR99 - SR161 /REET (867,458) Citywide Pedestrian Crossing Improvements /MVFT (230,859) Steel Lake Park to Downtown Trail Project /MVFT 230,859 21st Ave S Sidewalks /Transfer in from LIFT 175,000 Street Light LED Conversion Project /Grant 350,000 Street Light LED Conversion Project /Utility Rebate 400,000 Street Light LED Conversion Project /Interfund Loan 2,500,000 SW Campus Preservation Project /Grant 952,000 SW Campus Preservation Project /Transfer In from Asphalt Overlay - 16th Ave South Preservation Project /Grant 692,000 16th Ave South Preservation Project /Transfer In from Asphalt Overlay - Military Rd & S 298th St Compacted Roundabout Project /Grant 723,093 Grand Staircase Project /LIFT 1,500,000 Grand Staircase Project /Traffic Impact Fee (1,500,000) Revenue - Adjusted Budget 22,588,766 Expenditure - Current Budget 20,036,000 S 320th Street @ 20th Ave South (612,000) SW 336th Way /SW 340th St: 26th PI SW - Hoyt Rd / /REET 1,860,788 S 352nd Street Extension from SR99 to SR161 (242,131) S 356th St: SR99 - SR161 /Grant (1,609,701) S 356th St: SR99 - SR161 /REET - Citywide Pedestrian Crossing Improvements /MVFT 177,845 Steel Lake Park to Downtown Trail Project /MVFT 413,859 21st Ave S Sidewalks /Transfer in from LIFT 175,000 Street Light LED Conversion Project /Grant 350,000 Street Light LED Conversion Project /Utility Rebate 40,000 Street Light LED Conversion Project / Interfund Loan 2,500,000 SW Campus Preservation Project /Grant 952,000 SW Campus Preservation Project /Transfer In from Asphalt Overlay - 16th Ave South Preservation Project /Grant 692,000 16th Ave South Preservation Project /Transfer In from Asphalt Overlay - Military Rd & S 298th St Compacted Roundabout Project /Grant 806,436 SR99 HOV Lanes Ph V 4,662,016 School Zone Enhancements 65,200 Sacajawea Safe Routes to Schools 279,558 Citywide Flashing Yellow Arrow Retrofit Project 2,114 S 314th St: 20th Ave S - 23rd Ave S - Install New Sidewalks 11,520 Expenditure - Adjusted Budget 30,560,504 Ending Fund Balance - Current Budget 1,299,026 Adjustment to Ending Fund Balance 718,848 Ending Fund Balance - Adj Budget 2,017,874 17 of 24 2017 Budget Adjustments November 7, 2017 Capital Project Reserve Fund 2017 Beginning Fund Balance - Current Budget 481,703 Adjustment to Beginning Fund Balance 1,014 Beginning Fund Balance - Adjusted Budget 482,717 Expenditure - Current Budget 129,382 Expenditure - Adjusted Budget 129,382 Ending Fund Balance - Current Budget 352,321 Adjustment to Ending Fund Balance 1,014 Ending Fund Balance - Adj Budget 353,335 PAEC CIP Fund Beginning Fund Balance - Current Budget Adjustment to Beginning Fund Balance Beginning Fund Balance - Adjusted Budget Revenue - Current Budget PAEC Revenue - Interfund Loan Revenue - Adjusted Budget Expenditure - Current Budget Performing Arts & Event Center Capital Expenditure Expenditure - Adjusted Budget Ending Fund Balance - Current Budget 2017 1,372,864 1,372,864 11,278,902 245,061 11,523,963 11,278,902 1,617,925 12,896,827 Adjustment to Ending Fund Balance Ending Fund Balance - Adj Budget _1 2017 Budget Adjustments 18 of 24 November 7, 2017 ENTERPRISE FUNDS (FUNDS 400'S) 2017 Budget Adjustments 19 of 24 November 7, 2017 SWM Operations Fund 2017 Beginning Fund Balance - Current Budget 1,082,868 Adjustment to Beginning Fund Balance 576,808 Beginning Fund Balance - Adjusted Budget 1,659,676 Revenue - Current Budget 4,070,820 NPDES Permit Department of Ecology Grant Revenue 50,000 Revenue - Adjusted Budget 4,120,820 Expense - Current Budget 3,999,912 Surface Water Vactor Services Increase 30,000 On -call Services for 811 call before you dig 1,500 NPDES Permit Department of Ecology Grant Expenditure 50,000 Expense - Adjusted Budget 4,081,412 Ending Fund Balance - Current Budget 1,153,776 Adjustment to Ending Fund Balance 545,308 Ending Fund Balance - Adj Budget 1,699,084 DBC Fund 2017 Beginning Fund Balance - Current Budget 648,669 Beginning Fund Balance - Adjusted Budget 648,669 Revenue - Current Budget 747,251 Dumas Bay Centre Revenue Increase 330,852 Transfer in from REET Fund 500,000 Revenue - Adjusted Budget 1,578,103 Expense - Current Budget 925,014 Temp Help /Overtime Pay /Benefits Increase for Kitchen & Business Operations Staff 86,356 Food & Beverage Increase for Rentals 58,586 Custodial Services Increase 27,325 Repairs & Maintenance Services Increase 16,204 Centerstage Management Contract Services Increase 24,199 Utility Billings Increase 6,028 Expense - Adjusted Budget 1,143,712 Ending Fund Balance - Current Budget 470,906 Adjustment to Ending Fund Balance 612,154 Ending Fund Balance - Adj Budget 1,083,060 2017 Budget Adjustments 20 of 24 November 7, 2017 INTERNAL SERVICES FUNDS (FUNDS 500'S) 2017 Budget Adjustments 21 of 24 November 7, 2017 Information Technology Fund Risk Fund 2017 Beginning Fund Balance - Current Budget _ Adjustment to Beginning Fund Balance 846,398 Adjustment to Beginning Fund Balance _ 247,434 Beginning Fund Balance - Adjusted Budget Police Department Cellular Services Cost Increase (Funded by 001 GF) (2018 - $8,820) 1,093,832 Revenue - Current Budget 6,469 1,567,843 Recovery Revenue (131,166) 60,000 Revenue - Adjusted Budget Transfer in from REET for PAEC IT equipment installed in PAEC 1,627,843 Expense - Current Budget 466 _ 1,567,843 Expense - Adjusted Budget Revenue - Adjusted Budget 1,567,843 Ending Fund Balance - Current Budget 2,159,270 846,398 Adjustment to Ending Fund Balance King County Radio Services Cost Increase (2018 - $6,469) 307,434 Ending Fund Balance - Adj Budget 9,950 1,153,832 22,000 Fund Balance Reserve Policy $ 894,191 Information Technology Fund 2017 Beginning Fund Balance - Current Budget 3,098,470 _ Adjustment to Beginning Fund Balance 391,627 Beginning Fund Balance - Adjusted Budget 3,490,097 Revenue - Current Budget 2,212,755 Police Department Cellular Services Cost Increase (Funded by 001 GF) (2018 - $8,820) 6,471 King County Radio Services Cost Increase (Funded by 001 GF) (2018 - $6,469) 6,469 Police Department Microsoft License /Office Software License (Funded by 001 GF) (2018 - $9,950) Reduce 1.5 FTE IT Application Specialist & IT Equipment for Police Officers (Funded by 001 GF) 9,950 (131,166) PAEC IT - Building Wi -Fi, Copy /Printer, Desktop, Phones, Alarm, Box Office Ticketing Hardware, Fiber Connectivity, Networking, & Security Surveillance (1 -time) (Funded by 115 PAEC) 56,734 Transfer in from REET for PAEC IT equipment installed in PAEC 109,338 PAEC IT - Annual Service for Two Century Link POTS Lines (Funded by 115 PAEC) 466 PAEC IT - Annual Maintenance of CISCO IP Phone System (Funded by 115 PAEC) 5,483 Revenue - Adjusted Budget 2,276,500 Expense - Current Budget 2,159,270 Police Department Cellular Services Cost Increase (2018 - $8,820) 6,471 King County Radio Services Cost Increase (2018 - $6,469) 6,469 Police Department Microsoft License /Office Software License (2018 - $9,950) 9,950 Phone Upgrade (1 -time Replacement Reserves) 22,000 Amanda Permit IVR System (1 -time Replacement Reserves) 36,000 2017 Budget Adjustments 22 of 24 November 7, 2017 Information Technology Fund Continued 2017 Amanda Upgrade CD (1 -time Replacement Reserves) 48,000 Portable Radios (1 -time Replacement Reserves) 18,614 Reduce 1.5 FTE IT Application Specialist & IT Equipment for Police Officers (131,166) PAEC IT - Building Wi -Fi, Copy /Printer, Desktop, Phones, Alarm, Box Office Ticketing Hardware, Fiber Connectivity, Networking, & Security Surveillance (1 -time) 166,072 PAEC IT - Annual Service for Two Century Link POTS Lines 466 PAEC IT - Annual Maintenance of CISCO IP Phone System 5,483 Expense - Adjusted Budget 2,347,629 Ending Fund Balance - Current Budget 3,151,955 Adjustment to Ending Fund Balance 267,013 Ending Fund Balance - Adj Budget 3,418,968 Mail & Duplication Fund 2017 Beginning Fund Balance - Current Budget 209,252 Adjustment to Beginning Fund Balance 1,744 Beginning Fund Balance - Adjusted Budget 210,996 Revenue - Current Budget 128,707 PAEC IT - Annual Copy & Printer costs (Funded by 115 PAEC Operations Fund) 3,300 Revenue - Adjusted Budget 132,007 Expense - Current Budget 151,507 PAEC IT - Annual Copy & Printer costs 3,300 Expense - Adjusted Budget 154,807 Ending Fund Balance - Current Budget 186,452 Adjustment to Ending Fund Balance 1,744 Ending Fund Balance - Adj Budget 188,196 Fleet & Equipment Fund 2017 Beginning Fund Balance - Current Budget 5,707,512 Adjustment to Beginning Fund Balance 626,660 Beginning Fund Balance - Adjusted Budget 6,334,172 Revenue - Current Budget 1,800,811 Restore Fleet & Equipment Replacement Reserves to Original Levels 357,693 Turf Equipment for Fields (Transfer in from Parks Reserve Fund) 128,806 Revenue - Adjusted Budget 2,287,310 _ Expense - Current Budget 1,413,330 5 Community Development Fleet Vehicles (Replacement Reserves) 145,000 3 Parks Trucks (Replacement Reserves) 84,000 Turf Equipment for Fields (Transfer in from Parks Reserve Fund) 128,806 Expense - Adjusted Budget 1,771,136 _ Ending Fund Balance - Current Budget 6,094,993 Adjustment to Ending Fund Balance 755,353 Ending Fund Balance - Adj Budget 6,850,346 23 of 24 2017 Budget Adjustments November 7, 2017 Buildings & Furnishings Fund 2017 2017 Beginning Fund Balance - Current Budget Adjustment to Beginning Fund Balance 2,021,140 Adjustment to Beginning Fund Balance 2,020,466 (0) Beginning Fund Balance - Adjusted Budget Investment Interest 2,021,140 Revenue - Current Budget 240,000 483,912 57,000 Revenue - Adjusted Budget 4,507,800 Revenue - Adjusted Budget 4,180,000 483,912 Expense - Current Budget Medical Services 483,912 Health Insurance (not added during 17/18 budget) 4,380,000 20,000 Expense - Adjusted Budget Adjustment to Ending Fund Balance 503,912 Ending Fund Balance - Current Budget 2,021,140 Adjustment to Ending Fund Balance (20,000) Ending Fund Balance - Adj Budget 2,001,140 Fund Balance Reserve Policy $ 2,000,000 Health Ins Fund 2017 Beginning Fund Balance - Current Budget 2,249,828 Adjustment to Beginning Fund Balance (229,362) _ Beginning Fund Balance - Adjusted Budget 2,020,466 Revenue - Current Budget 4,203,500 Investment Interest 7,300 Health Insurance Contributions 240,000 Stop Loss 57,000 Revenue - Adjusted Budget 4,507,800 Expense - Current Budget 4,180,000 Prescription Services (180,000) Medical Services 380,000 Expense - Adjusted Budget 4,380,000 Ending Fund Balance - Current Budget 2,273,328 Adjustment to Ending Fund Balance (125,062) Ending Fund Balance - Adj Budget 2,148,266 Unemployment Ins Fund 2017 Beginning Fund Balance - Current Budget 1,309,124 Adjustment to Beginning Fund Balance 68,685 Beginning Fund Balance - Adjusted Budget 1,377,809 Revenue - Current Budget 268,000 Revenue - Adjusted Budget 268,000 Expense - Current Budget 1,050,000 Expense - Adjusted Budget 1,050,000 _ Ending Fund Balance - Current Budget 527,124 Adjustment to Ending Fund Balance 68,685 Ending Fund Balance - Adj Budget 595,809 24 of 24 2017 Budget Adjustments November 7, 2017