Loading...
HomeMy WebLinkAboutReg 2014-10-06 Item 5.08 - 2015-2016 Biennial Budget - General Fund Departments: Support Services2015 - 2016 Biennial Budget City of Tukwila, Washington Human Resources Human Resources Director Human Resources Technician Human Resources Assistant Human Resources Analyst 2 225 2015 - 2016 Biennial Budget City of Tukwila, Washington DEPARTMENT: Human Resources (04) FUND: General RESPONSIBLE MANAGER: Stephanie Brown FUND NUMBER: 000 POSITION: Director Description: The Human Resources Department provides support services in the areas of classification /compensation, benefit administration, labor and employee relations, civil service, recruitment and hiring, performance management, organizational development, training and professional development. 2013 -2014 Accomplishments ♦ Negotiated and settled five (5) labor agreements (Fire, Police Non - Commissioned, and Teamsters (3 groups). Strategic Goal 4. ♦ Conducted comprehensive review and revision to the Civil Service Rules adopted by the Civil Service Commission. Strategic Goal 4. ♦ Streamlined in -house facilitation of promotional test process for Police and Fire Departments. Strategic Goal 4. ♦ Implemented an on -line recruitment software program NEOGOV to streamline the recruitment process Citywide. Strategic Goal 4. 2015 -2016 Outcome Goals ♦ Create a Leadership Development Program. Strategic Goal 4. ♦ Develop a refresher and new Supervisor Training Program. Strategic Goal 4. 2015 -2016 Indicators of Success ♦ Provide leadership development training to 10 employees as part of Citywide Succession Plan by end of fourth quarter 2016. ♦ Improved supervisor's skills for compliance with Federal, State and Local regulations. Completion of training to job classified managers and supervisors by the end of the fourth quarter 2015. ♦ Improved risk management practices resulting in decreased grievance filings, arbitrations, hearings, and litigation. Performance Measures Human Resources 2014 Estimated 2015 Projected 2016 Projected Vacancies Advertised 37 30 25 Applications Processed 1,100 800 650 226 2015 - 2016 Biennial Budget City of Tukwila, Washington Budget Changes by Expenditure Type Human Services Budget Change Percentages Human Services 01 Salaries 02 Benefits 03 Supplies 04 Services 05 Intergov't 06 Capital Total 2014 Budget $ 400,814 $ 123,572 $ 4,642 $ 164,788 $ - $ - $ 693,816 Base Services 7,924 10,594 2,875 (58,800) - - (37,407) Revenue Backed - - - - - - - Proposals - - - - - - - Transfers - - - - - - - 2015 Budget $ 408,738 $ 134,166 $ 7,517 $ 105,988 $ - $ - $ 656,409 Base Services 8,070 9,850 - - - - 17,920 Revenue Backed - - - - - - - Proposals - - - - - - - Transfers - - - - - - - 2016 Budget $ 416,808 $ 144,015 $ 7,517 $ 105,988 $ - $ - $ 674,328 Budget Change Percentages Human Services Budget Change Discussion: Base Services. Budget changes for the Human Resources department include step increases and COLA increases for salaries, healthcare cost changes and increases in other employee benefits, increase in supplies, services decreased due to the removal of one -time funds for a compensation study completed in 2014. 227 01 Salaries 02 Benefits 03 Supplies 04 Services 05 Intergov't 06 Capital Total 2015 Changes Base Services 2.0% 8.6% 61.9% - 35.7% 0.0% 0.0% -5.4% Revenue Backed 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Proposals 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Transfers 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 2016 Changes Base Services 2.0% 7.3% 0.0% 0.0% 0.0% 0.0% 2.7% Revenue Backed 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Proposals 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Transfers 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Budget Change Discussion: Base Services. Budget changes for the Human Resources department include step increases and COLA increases for salaries, healthcare cost changes and increases in other employee benefits, increase in supplies, services decreased due to the removal of one -time funds for a compensation study completed in 2014. 227 2015 - 2016 Biennial Budget City of Tukwila, Washington Expenditure Summary Human Resources Expenditures By Type 2012 2013 2014 2015 2016 2014 -15 2015 -16 Actual Actual Budget Budget Budget % Chg % Chg 10 Salaries & Wages $ 359,647 $ 382,209 $ 400,814 $ 408,738 $ 416,808 1.98% 1.97% 20 Personnel Benefits 109,240 118,092 123,572 134,166 144,015 8.57% 7.34% 30 Supplies 5,620 6,414 4,642 7,517 7,517 61.93% 0.00% 40 Services 40,129 95,437 164,788 105,988 105,988 - 35.68% 0.00% Department Total $ 514,637 $ 602,151 $ 693,816 $ 656,409 $ 674,328 -5.39% 2.73% Expenditure Detail - Salaries and Benefits Salaries are based on actual costs for existing positions and include a cost of living adjustment per contract agreements. Human Resources Position Description 2014 FTE 2015 FTE 2015 Budgeted Salaries Benefits 2016 FTE 2016 Budgeted Salaries Benefits Human Resources Director 1 1 $146,496 $ 35,550 1 $ 149,376 $ 38,022 Human Resources Analyst 1 1 96,744 38,003 1 98,664 40,837 Human Resources Assistant 1 1 92,346 34,307 1 94,296 36,884 Human Resources Technician 1 1 67,152 26,305 1 68,472 28,272 Extra Labor 6,000 - 6,000 - Department Total 4 4 $ 408,738 $134,166 4 $ 416,808 $144,015 228 2015 - 2016 Biennial Budget City of Tukwila, Washington Expenditure Detail - Supplies, Services and Other Supplies include office and safety supplies; services include labor relations professional services, employee assistance program, software maintenance, equipment repair, travel, subscriptions and memberships, among others. Human Resources - Administration Account Number Purpose 2012 Actual 2013 Actual 2014 Budget 2015 Budget 2016 Budget Supplies 000.04.516.200.31.00 Supplies - Office $ 3,522 $ 4,763 $ 2,417 $ 3,417 $ 3,417 000.04.516.200.31.02 Supplies - Safety 1,785 980 1,100 1,500 1,500 000.04.516.200.31.90 Supplies - Central 313 - - - - Total Supplies 5,620 5,743 3,517 4,917 4,917 Services 000.04.516.200.41.00 Prof Svcs -Misc training, investigations, and background check and fees 4,738 5,096 39,700 13,000 13,000 000.04.516.200.41.02 Prof Svcs - General safety and training 840 866 2,350 2,000 2,000 000.04.516.200.41.03 Prof Svcs - Labor relations, negotiations /mediations for bargaining units and potential grievances and /or 13,841 27,386 60,000 30,000 30,000 Civil Service hearings 000.04.516.200.41.04 Prof Svcs - Employee Assistance Program 8,411 7,845 9,075 9,075 9,075 (EA') 000.04.516.200.41.05 Prof Svcs - NEOGOV Software 23,725 8,500 9,500 9,500 000.04.516.200.42.00 Communication - Postage 6 9 - - - 000.04.516.200.43.00 Travel - Meals, Parking, Mileage, Lodging for WAPELRA and NPELRA 1,209 1,022 1,500 1,500 1,500 000.04.516.200.44.00 Advertising - Advertising job openings 5,269 1,720 6,000 1,000 1,000 000.04.516.200.45.00 Rental - Rentals /leases 400 2,087 2,108 2,108 2,108 000.04.516.200.48.00 R &M - Eden software, copier 200 2,532 5,105 5,105 5,105 000.04.516.200.49.00 Misc - Citywide anti- harassment training 1,215 584 - - - 000.04.516.200.49.01 Misc - Annual memberships for various organizations 1,166 839 1,800 1,000 1,000 000.04.516.200.49.02 Misc - Printing of department forms and new employee packets 824 864 650 1,450 1,450 000.04.516.200.49.03 Misc - Registrations for conferences and training 2,012 3,105 2,750 2,000 2,000 Total Services 40,129 77,680 139,538 77,738 77,738 Total Supplies, Services and Other $ 45,749 $ 83,423 $ 143,055 $ 82,655 $ 82,655 229 2015 - 2016 Biennial Budget City of Tukwila, Washington Expenditure Detail - Supplies, Services and Other Supplies include office supplies and meals or refreshments for meetings; services include public safety testing, travel, rental, and registrations, among others. Human Resources - Civil Service Account Number Purpose 2012 Actual 2013 Actual 2014 Budget 2015 Budget 2016 Budget Supplies 000.04.516.202.31.00 Supplies - Office and Operating $ - $ 671 $ 1,125 $ 1,400 $ 1,400 000.04.516.202.31.43 Supplies -Meals and Refreshments - - - 1,200 1,200 Total Supplies - 671 1,125 2,600 2,600 Services 000.04.516.202.41.00 Prof Svcs - Public Safety Testing quarterly fees, Promotional Testing Fees, Legal Fees - 16,283 18,000 22,500 22,500 000.04.516.202.44.00 Advertising - Advertising for non- commissioned, lateral police and firefighters positions - 450 1,000 1,000 1,000 000.04.516.202.45.00 Rental - Room rentals and other expenses for testing for non - commissioned positions - 975 1,000 4,000 4,000 000.04.516.202.49.00 Misc - Conference registration for - 49 750 750 750 Commissioners 000.04.516.202.49.01 Misc - Printing of brochures and recruitment cards - - 4,500 - - Total Services - 17,757 25,250 28,250 28,250 Total Supplies, Services and Other $ - $ 18,427 $ 26,375 $ 30,850 $ 30,850 230 2015 - 2016 Biennial Budget City of Tukwila, Washington Finance Finance Director Deputy Finance Director Payroll & Accounts Payable Utilities & Treasury Fiscal Coordinator (Claims, Payroll) Fiscal Specialist - (Payroll) Fiscal Specialist (Claims) Fiscal Coordinator Fiscal Fiscal Specialist Specialist (Treasury) (Utilities) Senior Fiscal Coordinator Fiscal Coordinator Fiscal Support Technician Fiscal Specialist (Business Licenses 231 2015 - 2016 Biennial Budget City of Tukwila, Washington DEPARTMENT: Finance (05) FUND: General RESPONSIBLE MANAGER: Peggy McCarthy FUND NUMBER : 000 POSITION: Director Description The Finance department provides an array of services that include financial data processing, treasury cash control, utility billing and collection, payroll, accounts payable, accounts receivable, business licenses, preparation of the biennial budget and Comprehensive Annual Financial Report, (CAFR) and risk management. The Finance Department also serves as liaison to the State Auditor's Office during the annual audit of the City's compliance with legal and financial reporting requirements. 2013 -2014 Accomplishments ♦ Completed Klickitat LID assessment and bond issuance. Strategic Goal 1. ♦ Supported HPO and Diversity training, which was attended by all Finance staff; implemented LEAN and HPO methodologies and streamlined data input process by: developing auto upload templates for journal entries and daily revenue reports, improved timesheet entry and PCard transaction tracking, instituted new CAFR and budget preparation process allowing flexibility and improving accuracy, and completed a comprehensive review of all purchasing policies and procedures and revised to create a more efficient purchasing model. Strategic Goal 4. ♦ Involved the Tukwila community in the budget process by holding community meetings and providing information in the Tukwila Reporter and Hazelnut newspapers. Strategic Goal 2. ♦ Obtained debt funding for the Tukwila Metropolitan Park District; developed and adopted a debt policy that will help guide the City in long -term planning for capital projects. Strategic Goal 4. ♦ Participated in the Fire Exploratory Committee, which reviewed options available for the City's Fire department including annexing into an existing Regional Fire Authority. Strategic Goal 4. ♦ Achieved GFOA budget award and Comprehensive Annual Financial Report (CAFR) award. Strategic Goal 4. 2015 -2016 Outcome Goals ♦ Support the Tukwila International Boulevard transformation by securing financing for the redevelopment project. Strategic Goal 1. ♦ Continue to implement LEAN and HPO methods to enhance efficiencies and service levels especially with fixed asset accounting and indirect cost allocation model. Strategic Goal 4. ♦ Assure continuity of operations through succession planning, staff training and development, and policies and procedure documentation. Strategic Goal 4. ♦ Support Regional Fire Authority exploratory committee. Strategic Goal 4. ♦ Review fees and update as necessary including utility and other billing late fees and penalties, and credit card usage fee, if feasible. Migrate fee adoption and approval legislation from ordinances to resolutions. Strategic Goal 4. ♦ Implement new industry standards for transaction processing including compliance with new requirements regarding chipped credit cards. Strategic Goal 4. 232 2015 - 2016 Biennial Budget City of Tukwila, Washington 2015 -2016 Indicators of Success ♦ Financing is obtained and managed for the Tukwila International Boulevard redevelopment project. ♦ Indirect cost allocation is equitable, complies with best practices and is easy to update requiring fewer than 40 staff hours to do so. Costs that can be directly charged to departments and funds are so charged instead of using the allocation. Fixed asset records are easy to access, provide necessary information and updating requires fewer staff hours. ♦ Expanded knowledge within department of each major financial function; ability to perform functions by more than one person. ♦ Financial considerations of joining the Kent Regional Fire Authority are fully vetted resulting in sound conclusions. ♦ Credit card usage fee is adopted if feasible; utility billing late fees and penalties are updated; all fee legislation resides in resolutions rather than ordinances. ♦ Credit card processing equipment complies with new requirements and is in place, tested, and working no later than September 30, 2015. Performance Measures Finance 2012 Actual 2013 Actual 2014 Estimated 2015 Projection 2016 Projection Customer Service Number of utility accounts served 7,424 7,445 7,460 7,775 7,790 Number of utility bills generated 36,828 36,902 37,000 37,100 37,200 Accounts Payable and Accounts Receivable # of voucher payments 3,061 2,588 2,700 2,700 2,700 Average # of calendar days for AP to review, approve, and pay vouchers 7 7 7 7 7 # of accounts receivable invoices issued 637 755 646 650 650 Average days from revenue recognition to collection 32 24 27 25 25 Effectiveness, outcomes, and efficiency % monthly financial reports issued by the middle of the subsequent month (expenditure reports) 92% 92% 92% 100% 100% Vendor checks voided due to Finance Dept error 7 5 8 6 6 233 2015 - 2016 Biennial Budget City of Tukwila, Washington Budget Changes by Expenditure Type Finance Budget Change Percentages Finance 01 Salaries 02 Benefits 03 Supplies 04 Services 05 Intergov't 06 Capital Total 2014 Budget $ 1,065,103 $ 374,266 $ 19,296 $ 835,468 $ - $ - $ 2,294,133 Base Services 3,135 18,948 - 161,000 - - 183,083 Revenue Backed - - - - - - - Proposals - - - - - - - Transfers - - - - - - - 2015 Budget $ 1,068,238 $ 393,214 $ 19,296 $ 996,468 $ - $ - $ 2,477,216 Base Services 31,004 29,780 - 17,000 - - 77,784 Revenue Backed - - - - - - - Proposals - - - - - - - Transfers - - - - - - - 2016 Budget $ 1,099,242 $ 422,994 $ 19,296 $ 1,013,468 $ - $ - $ 2,555,000 Budget Change Percentages Finance Budget Change Discussion: Base Services. Budget changes for the Finance department include, step increases and COLA increases for salaries, healthcare cost changes and increases in other employee benefits, service increases include additional budget for liability insurance, claims & judgments, and unemployment compensation. 234 01 Salaries 02 Benefits 03 Supplies 04 Services 05 Intergov't 06 Capital Total 2015 Changes Base Services 0.3% 5.1% 0.0% 19.3% 0.0% 0.0% 8.0% Revenue Backed 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Proposals 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Transfers 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 2016 Changes Base Services 2.9% 7.6% 0.0% 1.7% 0.0% 0.0% 3.1% Revenue Backed 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Proposals 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Transfers 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Budget Change Discussion: Base Services. Budget changes for the Finance department include, step increases and COLA increases for salaries, healthcare cost changes and increases in other employee benefits, service increases include additional budget for liability insurance, claims & judgments, and unemployment compensation. 234 2015 - 2016 Biennial Budget City of Tukwila, Washington Expenditure Summary Finance 2012 2013 2014 2015 2016 2014 -15 2015 -16 Expenditures By Type Actual Actual Budget Budget Budget % Chg % Chg 10 Salaries & Wages $ 905,015 $ 979,474 $ 1,065,103 $ 1,068,238 $ 1,099,242 0.29% 2.90% 20 Personnel Benefits 317,711 369,712 374,266 393,214 422,994 5.06% 7.57% 30 Supplies 12,581 11,347 19,296 19,296 19,296 0.00% 0.00% 40 Services 833,301 894,450 835,468 996,468 1,013,468 19.27% 1.71% 50 Intergovt. Svcs & Taxes 2 12 - - - 0.00% 0.00% Department Total $ 2,068,611 $ 2,254,995 $ 2,294,133 $ 2,477,216 $ 2,555,000 7.98% 3.14% Expenditure Detail - Salaries and Benefits Salaries are based on actual costs for existing positions and include a cost of living adjustment per contract agreements. Finance Position Description 2014 FTE 2015 FTE 2015 Budgeted Salaries Benefits 2016 FTE 2016 Budgeted Salaries Benefits Finance Director 1 1 $ 143,898 $ 38,988 \--+ r-+ cn Ln ,—+ $ 148,176 $ 41,895 Deputy Finance Director 1 1 107,289 33,747 114,348 37,156 Senior Fiscal Coordinator 1 1 102,936 38,923 105,504 41,888 Fiscal Coordinator 3 3 290,715 97,842 298,008 105,213 Fiscal Specialist 5 5 326,088 146,101 334,203 157,306 Fiscal Support Technician 1 1 57,312 24,613 59,003 26,537 Extra Labor 30,000 - 30,000 - Overtime 10,000 - 10,000 - City -wide Unemployment - 13,000 - 13,000 Compensation Department Total 12 12 $ 1,068,238 $ 393,214 12 $ 1,099,242 $ 422,994 235 2015 - 2016 Biennial Budget City of Tukwila, Washington Expenditure Detail - Supplies, Services and Other Supplies include miscellaneous office supplies; services include annual audit fees, liability insurance, software maintenance costs, travel, claims & judgments, subscriptions, and memberships, among others. Finance Account Number Purpose 2012 Actual 2013 Actual 2014 Budget 2015 Budget 2016 Budget Supplies 000.05.514.230.31.00 Supplies - Office $ 9,311 $ 11,347 $ 19,296 $ 19,296 $ 19,296 000.05.514.230.31.90 Supplies - Central Supplies 3,270 - - - - Total Supplies 12,581 11,347 19,296 19,296 19,296 Services 000.05.514.230.41.00 Prof Svcs - Annual audit from State of WA 132,491 77,259 170,000 105,000 105,000 Auditor's Office, Misc training, Consulting services 000.05.514.230.41.01 Prof Svcs - Microflex sales tax auditing program 2,519 2,484 5,000 5,000 5,000 000.05.514.230.42.00 Communications - Postage, delivery service, shipping 5,587 144 1,000 1,000 1,000 000.05.514.230.43.00 Travel - Meals, parking, mileage for 2,139 2,378 5,000 5,000 5,000 WFOA, PSFOA, software training 000.05.514.230.45.00 Rental - Copier lease - 1,275 2,700 2,700 2,700 000.05.514.230.46.00 Insurance - City -wide liability insurance 229,213 218,402 252,000 338,000 355,000 000.05.514.230.48.00 R &M - Folding maching, other equipment, vault, software annual maintenance 352 55,260 2,500 62,500 62,500 000.05.514.230.49.00 Misc - Annual memberships, subscriptions for financial publications, registrations 13,866 13,393 21,900 21,900 21,900 000.05.514.230.49.03 Misc - Claims & judgments 440,285 519,959 370,000 450,000 450,000 000.05.514.230.49.08 Misc - PPI credit card fees 6,849 3,896 5,368 5,368 5,368 Total Services 833,301 894,450 835,468 996,468 1,013,468 Intergovernmental 000.05.514.230.53.00 Ext Taxes & Assmnts - Excise Taxes 2 12 - - - Total Intergovernmental 2 12 - - - Total Supplies, Services and Other $ 845,884 $ 905,809 $ 854,764 $1,015,764 $1,032,764 236 2015 - 2016 Biennial Budget City of Tukwila, Washington DEPARTMENT: Non - Departmental Expenses (20) FUND: General RESPONSIBLE MANAGER: Peggy McCarthy FUND NUMBER: 000 POSITION: Finance Director Description This department had been utilized to pay unemployment claims for General Fund employees, pay City -wide insurance assessments and claims and judgments through 2012. These are now budgeted in Finance. General transfers to other funds are recorded here. Department 20 2012 2013 2014 2015 2016 2014 -15 2015 -16 Expenditures By Type Actual Actual Budget Budget Budget % Chg % Chg 20 Personnel Benefits 50 Intergovt. Svcs & Taxes 60 Capital Outlays $ 14,944 $ 658,706 5,618,587 - $ - $ - $ - 0.00% 0.00% 9,529,163 8,386,050 4,959,846 7,153,791 - 40.86% 0.00% 0.00% 44.23% Department Total $ 6,292,238 $ 9,529,163 $ 8,386,050 $ 4,959,846 $ 7,153,791 - 40.86% 44.23% TRANSFERS OUT -- From the General Fund to the Following Funds: 2012 Actual 2013 2014 Actual Budget 2015 2016 Budget Budget 103 Residential Street 104 Arterial Street 105 Contingency 107 Fire Equipment Reserve 109 Drug Seizure 2 ** Debt Service 301 Land & Park Acquisition 303 General Government Improvements 401 Water - Hydrant Rental 411 Golf Course 1,314,132 2,770,995 1,210,000 98,460 225,000 $ 230,000 1,650,000 4,225,000 83,919 $ 100,000 $ - $ 200,000 1,850,000 1,700,000 3,151,000 2,200,000 75,000 2,940,244 3,428,650 2,759,846 3,302,791 212,000 - - 500,000 200,000 200,000 400,000 600,000 300,000 300,000 TOTAL $ 5,618,587 $ 9,529,163 $ 8,965,650 $ 4,959,846 $ 7,153,791 237 2015 - 2016 Biennial Budget City of Tukwila, Washington This page intentionally left blank 238 2015 - 2016 Biennial Budget City of Tukwila, Washington Information Technology Information Technology Director 1 1 Database Systems Administrator Systems Administrator r Senior Information Technology Specialist (X2) Information Technology Specialist 239 2015 - 2016 Biennial Budget City of Tukwila, Washington DEPARTMENT: Information Technology (12) FUND: General RESPONSIBLE MANAGER: Mary Miotke FUND NUMBER: 000 POSITION: Director Description: The Information Technology Department provides support for the City's information and communication infrastructure to assist the City in delivering the highest quality services and information for internal and external customers in an efficient, effective and fiscally responsible manner. The IT Department oversees all technology systems for the City, including the City's network, system administration, computer hardware and software and telecommunications - both internal VoIP phone system and mobile phones/ devices. 2013 -2014 Accomplishments ♦ Offsite data storage and disaster recovery hot site put into place for redundancy and timely recovery of the City's systems. Strategic Goal 4. ♦ Worked with Police & Fire to fully implement within the defined schedule the Valley Communications dispatch and communications upgrades for Public Safety. Strategic Goal 1. ♦ Participated in the implementation of the City's new permit tracking software system by working closely with key staff in multiple departments and the software vendor to install, configure, test and bring the system to live production within scheduled timeline. Strategic Goal 4 and 5. ♦ Improved outreach efforts to citizens by installing videotaping and streaming equipment for the broadcast of City Council Meetings. Strategic Goal 5. ♦ Installed centrally managed enterprise -class wireless network equipment to securely connect mobile devices to network. Strategic Goal 4. ♦ Collaborated with Public Works to roll -out a new pipeline inspection camera truck using technology designed for asset -based architecture with seamless integration into the City's databases and geographic information systems. Strategic Goal 4. ♦ Facilitated and installed the technology infrastructure and communication connectivity for the Police Department's new publicly - accessible Community Resource Center at Southcenter Mall. Strategic Goal 1 and 5. 2015 -2016 Outcome Goals ♦ Collaborate with staff in Community Development, Fire and other departments to enhance the significant capabilities of Trakit, including eTrakit online services for citizens and iTrakit field inspection services for staff. Strategic Goal 4 and 5. ♦ Optimize Public Safety field mobility communication network for quality of service, efficiency and dependability. Strategic Goal 1 and 4. ♦ Redeem Microsoft technical training vouchers included in Microsoft's Enterprise Licensing Agreement for applicable technical training for IT staff. Strategic Goal 4. ♦ Formalize Technology Stakeholders group to meet quarterly to prioritize and discuss status on current and future IT projects that benefit the City. Strategic Goal 4. 240 2015 - 2016 Biennial Budget City of Tukwila, Washington 2015 -2016 Indicators of Success ♦ Relevant modules of Trakit in full production for DCD and FD, with online services for citizens and field inspection capabilities in use. ♦ Field mobility communication optimized for Police and Fire department communication, with all vehicles connected to system (95% uptime) and secure mobile connectivity to internal and off -site data. ♦ Applicable training classes identified for remaining vouchers and training completed by IT staff. ♦ Technology Stakeholders group meetings held every quarter with priority projects incorporated into IT work plan. 241 2015 - 2016 Biennial Budget Information Technology Department - Budget Changes by Expenditure Type Information Technology City of Tukwila, Washington Information Technology Department - Budget Change Percentages Information Technolo 01 Salaries 02 Benefits 03 Supplies 04 Services 05 Intergov't 06 Capital Total 2014 Budget $ 649,959 $ 241,616 $ 127,766 $ 311,216 $ - $ 32,000 $ 1,362,557 Base Services 3,287 21,180 10,500 11,709 - (22,000) 24,676 Revenue Backed - - - - - - - Proposals - - - - - - - Transfers (130,080) (50,406) - (45,000) - - (225,486) 2015 Budget $ 523,166 $ 212,390 $ 138,266 $ 277,925 $ - $ 10,000 $ 1,161,747 Base Services 14,006 15,781 - 220 - - 30,007 Revenue Backed - - - - - - - Proposals - - - - - - - Transfers - - - - - - - 2016 Budget $ 537,172 $ 228,171 $ 138,266 $ 278,145 $ - $ 10,000 $ 1,191,754 Information Technology Department - Budget Change Percentages Information Technolo Budget Change Discussion: Base Services: Budget changes include step increases and COLA increases for salaries, healthcare cost changes and increases in other employee benefits, increase for network equipment, increase for network equipment services, and reduction in capital. Budget was moved from capital to supplies and services. 242 01 Salaries 02 Benefits 03 Supplies 04 Services 05 Intergov't 06 Capital Total 2015 Changes Base Services 0.5% 8.8% 8.2% 3.8% 0.0% -68.8% 1.8% Revenue Backed 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Proposals 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Transfers -20.0% -20.9% 0.0% - 14.5% 0.0% 0.0% - 16.5% 2016 Changes Base Services 2.7% 7.4% 0.0% 0.1% 0.0% 0.0% 2.6% Revenue Backed 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Proposals 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Transfers 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Budget Change Discussion: Base Services: Budget changes include step increases and COLA increases for salaries, healthcare cost changes and increases in other employee benefits, increase for network equipment, increase for network equipment services, and reduction in capital. Budget was moved from capital to supplies and services. 242 2015 - 2016 Biennial Budget City of Tukwila, Washington Transfers: 2 staff positions and related benefits were transferred to the Mayor's Office Communications division. Services related to communications was transferred as well. Expenditure & Revenue Summary Information Technology Expenditures By Type 2012 Actual 2013 Actual 2014 Budget 2015 Budget 2016 Budget 2014 -15 % Chg 2015 -16 % Chg 10 Salaries & Wages $ 589,534 $ 632,000 $ 649,959 $ 523,166 $ 537,172 - 19.51% 2.68% 20 Personnel Benefits 218,257 221,254 241,616 212,390 228,171 - 12.10% 7.43% 30 Supplies 107,353 120,153 127,766 138,266 138,266 822% 0.00% 40 Services 171,011 271,949 311,216 277,925 278,145 - 10.70% 0.08% 60 Capital Outlays 19,984 - 32,000 10,000 10,000 - 68.75% 0.00% Department Total $ 1,106,138 $ 1,245,356 $ 1,362,557 $ 1,161,747 $ 1,191,754 - 14.74% 2.58% Expenditure Detail - Salaries and Benefits Salaries are based on actual costs for existing positions and include a cost of living adjustment per contract agreements. Information Technolo Position Description 2014 FTE 2015 FTE 2015 Budgeted Salaries Benefits 2016 FTE 2016 Budgeted Salaries Benefits IT Director 1 1 $146,184 $ 39,245 1 $149,064 $ 42,012 Systems Administrator 1 1 92,184 37,165 1 94,008 39,941 Senior Info Technology Specialist 2 3 200,530 100,696 3 207,792 108,244 Database Administrator 1 1 81,768 35,283 1 83,808 37,975 Admin Support Coordinator 2 0 - - 0 - - Info Technology Assistant 1 0 - - 0 - - Extra Labor 2,500 - 2,500 - Department Total 8 6 $ 523,166 $ 212,390 6 $ 537,172 $ 228,171 243 2015 - 2016 Biennial Budget City of Tukwila, Washington Expenditure Detail - Supplies, Services and Other Supplies include office supplies, computer supplies and network supplies; services include connectivity services, cell phone services, televising Council meetings, hardware and software maintenance, travel and training, and registrations, among others. Capital includes capital computer equipment, as needed. Information Technolo Account Number Purpose 2012 Actual 2013 Actual 2014 Budget 2015 Budget 2016 Budget Supplies 000.12.518.880.31.00 Supplies - Office & Operating $ 2,143 $ 2,358 $ 3,766 $ 3,500 $ 3,500 000.12.518.880.31.01 Supplies- Repair 1,137 1,114 2,000 2,000 2,000 000.12.518.880.31.43 Supplies -Food - - - 266 1 266 000.12.518.880.31.44 Supplies- Training - - - 500 500 000.12.518.880.35.00 Small Tools & Minor Equipment - 69,964 86,942 87,500 87,500 87,500 Computer parts 000.12.518.880.35.01 Small Tools - Nextel 821 - 1,500 1,500 1,500 000.12.518.880.35.02 Small Tools - Network 33,287 29,739 33,000 43,000 43,000 Total Supplies 107,353 120,153 127,766 138,266 138,266 Services 000.12.518.880.41.01 Prof Svcs - Technical support 1,451 4,445 1,000 1,000 1,000 000.12.518.880.42.00 Communication - connectivity expense, repair & maintenance for technology items 11,280 592 27,700 7,700 7,700 000.12.518.880.42.01 Communication - City -wide cell phone service 55,903 45,983 40,000 40,000 40,000 000.12.518.880.42.02 Communication - telephone charges - 58,096 60,000 60,000 60,000 000.12.518.880.42.03 Communication - 2,053 1,000 - - 000.12.518.880.43.00 Travel - Meals, Parking, Mileage, Lodging for conferences: ACCIS, Active, Accela 1,352 414 1,500 1,500 1,500 000.12.518.880.45.00 Rental - Misc 39 39 - - - 000.12.518.880.45.94 Rental - Equipment Replacement Fund - 1,833 1,833 1,833 1,833 000.12.518.880.45.95 Rental - Equipment Rental 0 & M 896 5,029 4,183 4,392 4,612 000.12.518.880.48.00 R &M - Office & Network Equipment 12,327 1,461 3,000 3,000 3,000 000.12.518.880.48.01 R &M - Telephone maintenance - 1,080 28,500 28,500 28,500 000.12.518.880.48.02 R &M - Puget Sound Access (Televise - 15,178 25,000 25,000 25,000 Council Meeting) 000.12.518.880.49.00 Misc - Computer system component upgrades 21,570 35,017 27,000 15,000 15,000 000.12.518.880.49.01 Misc - Standard software new and upgrade purchases, Microsoft Enterprise 2,640 99,726 88,000 88,000 88,000 License 000.12.518.880.49.03 Misc - Registrations for conferences and training 1,313 1,004 2,500 500 500 000.12.518.880.49.44 Misc - Training - - - 1,500 1,500 244 2015 - 2016 Biennial Budget Expenditure Detail - Supplies, Services and Other, Continued Information Technologu Con't City of Tukwila, Washington 000.12.518.881.42.02 Communication 1,269 - - - - 000.12.528.800.42.00 Communication 60,398 - - - - 000.12.528.800.48.00 R &M 573 - - - - Total Services 171,011 271,949 311,216 277,925 278,145 Other 000.12.594.180.64.02 Capital - Machinery & equipment 19,984 - 32,000 10,000 10,000 Total Other 19,984 - 32,000 10,000 10,000 Total Supplies, Services and Other $ 298,347 $ 392,102 $ 470,982 $ 426,191 $ 426,411 245 2015 - 2016 Biennial Budget City of Tukwila, Washington This page intentionally left blank 246