Document Salem_doc_90b14b6191

Assessor Mission Statement - Whv We Exist The duties and responsibilities of the Assessing Department remain essentially the same from year to year. The Assessors are required by Massachusetts General Law to value all real and personal property as well as prepare tax-billing commitments for both motor vehicle and boat excise tax. The Assessing Department also receives and processes several hundred exemption requests and tax abatement applications. The office is open to the public and the staff is required to maintain the extensive databases needed to accomplish its mission. Sienificant Budset & Staffine Chanses for FY 2014 With the new CPA voted in November 2012 we will need to have our second clerk full time in the Assessors Of,fice to help implement the CPA application process.. With the loss of Paul Tierney at the end of FY 2012, Jim Bond was promoted from field inspector to Assistant Director of Assessing. In November, we hired Stephen Cortes, an experìenced Assessor formerly of Worcester, to be the field assessor. With a full complement of three Assessors and two clerks, the office staff is able to complete all necessary requirements promulgated by the Massachusetts Department of Revenue. Recent Accomolishments o Received timely approval of our valuation as part of the three year Recertification required by the Department of Revenue for Fiscal Year 2013. Patriot Property Appraisers were hired to review the software components and support the office with the recertification process. rùy'e were able to upgrade our GIS application in our assessing software to help with the overall city review required by the Department of Revenue in the recertification year. o Added a GIS component into our Patriot Property assessing software. We can now globally add and update information that can be utilized by us and other departments. ¡ We completed our DOR required inspection program and have implemented an annual re inspection plan to inspect approximately 750 to 1,000 properties per year beyond the annual sales verification and building permit inspection already in place. o Completion of several courses in the MAAO certification program, as well as continuing education by all assessors to maintain or achieve MAAO certification. o We have eliminated all residential and commercial Appellate Tax Board cases and only have the state valued utility cases left unsettled. o Worked with Harbormaster, Collector, and Finance Departments to implement a revised Mooring/Boat billing and abatement program that has proper checks and balances and reconciliations of fees collected and abated, as well as proper documentation of those boats that have been bought and sold. ---PAGE BREAK--- a a o FY 20l4Goals & Obiectives To have all assessors as certified Massachusetts Accredited Assessor's Organization (MAAO) designation. This accreditation requires significant training and education. The various courses of the MAAO accreditation program offer in-depth training to those individuals that strive to obtain the knowledge and background that is required to perform the duties of an Assessor in a professional and competent manner. Producing high quality work and implementing and conducting an aggressive database maintenance program still remain our principal tasks. Since these elements are essential in maintaining the level of professionalism expected by Department of Revenue, the City Administration and the public atlarge, it is the primary objective and continuous goal of the Department to achieve both. Train the Assistant Assessing Director on valuing Personal Property, which requires an initial steep learning curve. This training involves working closely with our software provider, Patriot Property. Outcomes and Performance Measurers Actual FY 2011 Actual FY 2012 Estimated FY 2013 Estimated FY 2014 13.781 890 33,000 975 450 250 975 75 1,400 13,710 900 33,000 1,r00 450 250 900 75 1,400 I 3736 871 33,700 1104 451 99 975 73 1 380 12.780 890 32,707 1 ,106 479 128 990 71 1.405 Real Estate Billi ng - Bills done quarterly Personal Property Bills- Billing done quarterlv Auto Excise Boat Excise Exemptions Abatements Personal Property inventory forms (required by law for abatements) ABC Forms - Tax exempts (required by law to qualify for status) lncome & Expense Statements How FY 2014 D Relate to Ci 's Overall Through education and in house seminars we always strive to improve communication and deliver exceptional services to the public. In order to keep improving upon this goal, all Assessors in the office are working toward having their MAAO designation, which indicates a certain level of knowledge and expertise in the Assessing field.. The additional education and completion of all required courses by all assessors has reduced the need for potential outside help in defending Appellate Tax Board cases. With our new GIS enhancement to our Patriot Properly assessing software, we will be able to deliver enhanced services to the general public as well as throughout the different departments. S a a ---PAGE BREAK--- CITY OF SALEM - FY 2014 OPERATII{G BUDGET Expenditures Adopted Budget Adjusted Budget Y-T-D Expenses Department FY 2012 FY 2013 FY 2013 FY 2013 Fy 2014 Mayor FY 2014 Council FY 2014 Assessors-Personnel l14II 5II1 SALARIES-FULL TIME I14I I 5I50 FRINGE/STIPENDS Total Assessors-Personnel Assessors-Expenses 11412 5242 OFFICE EQUIPMENT REP 11412 5303 LEGAL/REGISTRY SERVICES 11412 5308 CONTRACTED SERVICES 11412 5381 PRINTING AND BINDING t1412 5421 OFFICE SUPPLIES (cEN 11412 57IO IN STATE TRAVEL/MEETINGS rr412 5860 EQUIPMENT Total Assessors-Expenses 227,144.46 4,819.13 232,023.59 250,499.00 8,300.00 258,799.00 253,501.00 8,300.00 261,801.00 200.00 0.00 19,500.00 r,700.00 3,277.00 2,500.00 500.00 27,677.00 223,265.86 5,845.79 229,111.65 99.00 0.00 14,442.50 1,343.15 2,059.93 1,846.65 474.33 20,265.56 266,005.00 6,000.00 272,005.00 269,418.00 6,000.00 275,418.00 200.00 800.00 25,500.00 1,500.00 2,611.00 2,500.00 500.00 33,677.00 269,418.00 6,000.00 275,418.00 99.00 500.00 57,943.13 1,020.50 2,076.05 1,958.20 0.00 63,596.88 200.00 800.00 19,500.00 1,500.00 2,677.00 2,500.00 500.00 27,677.00 200.00 800.00 25,500.00 1,500.00 2,677.00 2,500.00 500.00 33,677.00 200.00 800.00 25,500.00 I,500.00 2,671.00 2,500.00 500.00 33,677.00 010 l4l Department Total 295,620.47 286,476.00 289,478.00 249,377.21 305,6g2.00 309,095.00 309,095.00 ---PAGE BREAK--- FY 2014 MANAGEMENT, BOARD MEMBERS AND PART-TIME SALARIES Council Voted FY 2014 Mayor FY 2014 s2.2 Mayor Rate FY 20't4 2.Oo/; Dept Request FY 20',t4 32.2 Prop Rate FY 2014 0-0% Curent Rate FY 2013 2.Oo/" # Board Meetings # Houß WklY = 1 F T E Cod( Voted By Counc¡l FY 2013 s2 Hire Date Job Desc Ors/Obj Dept Name Name BATES BOND JACKSON JAGOLTA JOHNSON FORGIONI TIERNEY CORTES DONALD JAMES DEBORAH RICHARD DAMIAN CLAUDIA PAUL STEPHEN 010 010 0't0 010 010 010 010 010 ASSESSORS ASSESSORS ASSESSORS ASSESSORS ASSESSORS ASSESSORS ASSESSORS ASSESSORS 11411-5't11 1't41't-5111 11411-5111 11411-511'l 114't1-5111 11411-5111 11411-5111 1'1411-5111 BOARD MEMBER ASST ASSESSOR OIR ASSESSING BOARD MEMBER BOARO MEMBER BOARD CLERK ASST ASSESSOR ASSÍ ASSESSOR 9t19t2011 9t22t09 4t1t20'12 10t10t12 3,000 00 B 42,49192 77,314 66 3,000 00 B 3,000 00 B 1,500 00 B 50jU 17 70,007.57 250,498.32 3,000 00 2,070 00 3,000 00 20 5.0 Total Full Time - 5ll1 '1 0 10 00 10 4 lOOo/o 100% 4 4 4 100% 100% 20 20 750 00 965 08 'I,486 82 750 00 750 00 375 00 3,000 00 't,150 00 1,500 00 750 00 965 08 1,446 A2 750 00 750 00 375 00 1,000 00 I,500 00 3,000 00 50,377't8 77,6'1202 3,000 00 3,000 00 1,500 00 984 38 1,516 56 750 00 750 00 375 00 3,000 00 'l,500 00 3,000 00 5't,38472 79,'16426 3,000 00 3,000 00 1,500 00 3,000 00 3,000 00 6_000-oo 275.417.39 3,000 00 51,38/.72 79,16426 3,000 00 3,000 00 1,500 00 3,000 00 3 000 00 6 000 00 275.417.39 a17 15 417 15 42,65523 833 49 43,508 33 43,508 33 Total AFSCME 1818 84,860 07 84,860 07 84,860 07 266.004.50 269.417.39 269.417 -39 01O ASSESSORS 01O ASSESSORS 01O ASSESSORS 1 1 411 -51 50 cedried Æsessor stiFnds 1 1411-5150 AFSMEsipend 11411-5150 Mileage Reimburcement-Asessos 3,000 00 3,000.00 8,070.00 Total Frinqe - 5150 254,794.32 5-0 Department Total FY 2012 FY 20'13 FY 2014 Variance FulÈTime Equivaleil Employæs: 4A 4A 50 02 6.000-00 272,OO4.50 ---PAGE BREAK--- FY 2014 AFSCME 1818 Union Employee Rates Counc¡l FY 2014 42.2 Mayot FY 2014 52-2 Dept Requel FY 2014 s2.2 STEP INCREASES Date Rate # Wks Old Neu Rate FY 2014 2.Oolo Rate FY 2013 o_0% F T E Voted By Coqncil FY 2013 g2 H¡re Date o*,oono lr"o T¡tle Department EMPLOYEE NAME FELIX FORGIONI DELLORFANO GLORIA CLAUDIA DELINDA O1O ASSESSORS O1O ASSESSORS 01O ASSESSORS 1't411-5111 1141't-511'l 1141't-5111 PRINCIPAL CLERK III SR CLERK TYPIST I/II SR CLERK TYPIST I/II 03221 993 4t1t12 1213t2013 462.71 74207 7'1916 879 96 756 91 730 33 121312013 lOOo/o oo/" 75691 220 302 1000Á 42,069 53 27,93A 04 1.0 o0 '1 0 45,934 13 45,934.13 45,934.13 38,925 94 38 925 94 38 925 94 84,860.07 84,860.07 84.860.07 70,oo7.57 2.O ---PAGE BREAK--- FY 2014 DETAILED BUDGET REPORT EXPENSES ASSESSORS - 010 ORG OBJECT 11412 TOTAL 1't412 TOTAL 11412 5308 TOTAL '11412 TOTAL 114't2 TOTAL 11412 571 0 TOTAL 1't4't2 TOTAL IUIAL I'KUP(JI'tsL' DESCRIPTION 5242 OFFICE EQUIPMENT REP Computer, Copier, Printers, Fax & routine care & maintenance 5303 LEGAL SERVICES Primarily used to pay for deeds and other legal papers needed to maintain the Department's legal file. Dept Request Mayor 18,000 Council 200 200 800 800 18,000 I,500 6,000 25,500 1,500 1,500 2,677 2.677 2,500 2,500 33,677 200 200 18,000 1,500 6,000 25.500 1,500 6,000 25,500 2,677 2.677 2,500 2,500 33,677 200 200 800 800 800 800 CONTRACTED SERVICES Primarily used to fund services of professional appraisers or consultants necessary to support the Department's ATB cases and valuation functions. Annual GIS Enhancement contract addition Appreisals for two 1214 properties coming back to rolls 5381 PRINTING AND BINDING Used to pay for binding and printing of tax commitment books. il21 OFFTCE SUPPLTES (GENERAL) General office supplies as needed ,500 ,s00 1 1,500 1,500 IN STATE TRAVEUMEETINGS Used to pay for professional meetings throughout the year. Eg., Mass. Assessors Association and Essex County Assessors Association, and Assessing Clerk's meetings. 2,677 2.677 2,500 2,500 33,677 5860 EQUIPMENT Used to purchase m¡ssion related small equipment. 500 500 500 500 500 500 ---PAGE BREAK--- Collector Mission Statement- Whv We Exist The Collector's Office serves as the portal for all revenues billed and received by the City of Salem. All bills for Real Estate & Personal Property Taxes, Motor Vehicle Excise Taxes, Personal Property Taxes, Boat Excise Tax, Water and Sewer Bills, Trash fees, City Ordinance tickets, and all other receivables committed by the Board of Assessors are the responsibility of the Collector. Parking tickets are also paid at the Collector's Upon receipt óf a written request and the applicable payment, the Collector's office will research and produce a Municipal Lien Certificate (MLC). The Collector's Office also procesies passport Applications and issues and tracks resident parking stickers and processes slip and mooring payments on behalf of the Harbormasters Office. &S for FY 2014 There is no significant budget or staffing changes for FY 2014 Recent Accomplishments Collectors has worked closely with the Harbormasters Office to transfer the billing system for moorings and slips to Kelley and Ryan which has resulted in a more efhcient means to track payments, stickers and renewals Both the Collector and Asst Collector worked with the parking implementation committee to implement the new parking ordinances. FY 2014 Goals & Obiectives o Maintain high collection rate ¡ Continue to enhance online payment system and continue to provide public education to increase usage of the system o Maintain quality service. o Continue educating members of the Collector's Office a a ---PAGE BREAK--- Outcomes and Performance Measurers Actual FY 2011 Actual FY 2012 Estimated FY 2013 Estimated FY 2014 250 2,500 50 1,200 9,000 7,250 150 4r,000 1,700 44,000 1.250 32,000 2,500 5,000 1s0 1.200 6,500 250 2,500 50 1,400 6,500 7.250 190 45,000 2,500 50,000 1,250 30,000 2,500 4,500 125 1,000 4,500 359 2,385 80 1,000 9,588 7,638 151 41,028 1,748 44.937 1.611 35,117 2,690 5.137 147 1,225 6,866 333 2,695 75 1 350 9,045 8,1 86 198 46.546 2,430 57,717 1049 26,1 58 2,505 5,037 119 1,213 5.522 Passports Processed Resident Parking StickersA/isitor Passes Email Correspondence Municipal Lien Certificates Processed Bills Payments Processed ln-House: Excise Tax Parking Tickets Boat Excise Tax Real Estate Personal Property Water/Sewer & Trash Mooring/Slips (Began collecting in March 201 1) Lockbox Payments Real Estate / Personal Propertv / Water & Sewer / Trash (Lockbox beqan June 2006) Online Payments - UniBank Real Estate Water/Sewer Personal Property Trash (Began billing in November 2006) Excise Tax How FY 2014 Departmental Goals Relate to City's Overall Lons & Short Term Goals a Keep collections current so the City has funds available to help maintain financial stability. ---PAGE BREAK--- CITY OF SALEM - FY 2OI4 OPERATING BUDGET Expenditures Adopted Budget Adjusted Budget Y-T-D Expenses Department FY 2012 Fy 2013 Fy 2013 Fy 2013 Fy 2014 Mayor FY 2014 Council FY 2014 Collector-Personnel 11461 5I11 SALAzuES-FULL TIME 11461 5131 OVERTIME (GENERAL) 11461 5I5O FRINGE/STIPENDS Total Collector-Personnel Collector-Expenses 11462 s242 OFFICE EQUTPMENT REP 11462 5311 EDUCATIONAL TRAINING 11462 538I PRINTING AND BINDING 11462 5421 OFFTCE SUPPLTES (cEN Total Collector-Expenses I 89,003.12 946.62 1,449.95 197,399.69 95.00 310.00 1,988.36 2,806.92 5,200.28 193,605.00 1,000.00 7,450.00 202,055.00 500.00 1,000.00 2,000.00 3,000.00 6,500.00 198,349.00 1,740.00 1,450.00 207,539.00 0.00 1,000.00 2,000.00 3,500.00 6,500.00 t85,228.12 I,139 .11 6,490.00 193,457.23 0.00 853.50 1,883.19 3,265.08 6,001.77 202,533.00 I,000.00 4,000.00 207,533.00 203,829.00 1,000.00 4,000.00 208,829.00 0.00 1,000.00 2,500.00 3,000.00 6,500.00 203,829.00 1,000.00 4,000.00 208,829.00 0.00 1,000.00 2,500.00 3,000.00 6,500.00 0.00 I,000.00 2,500.00 3,000.00 6,500.00 040 146 Department Total 202,599.97 208,555.00 214,039.00 199,459.00 214,033.00 2t5,329.00 215,329.00 ---PAGE BREAK--- FY 2014 MANAGEMENT, BOARD MEMBERS AND PART-TIME SALARIES Council Voted FY 2014 Mayor FY 20't4 52.2 Mayor Rate FY 2014 2.Oolo Dept Request FY 20'14 52.2 Prop Rate FY 2014 o.oo/" CuÍefìt Rate FY 20't3 # Board Meet¡ngs # Hours WklY = 1 F T E Êodr Voted By Council FY 20't3 s2 H¡re Date JoÞ Desc Org/Ob¡ Dept Name Name CELI BONNIE O4O COLLECTOR 11461-5111 clfl coLLEcroR 'l 1461-5150 ceÉird coiledor stipends 1 1 461-51 50 RES STCKER stiænd 'l 1 461-5150 AFSCME stipend 11461-5131 owRnME 10 100% 30 4.0 Total Full T¡me - 5111 Total Frinqe - 5'150 'l 12 30 1,000 00 250 00 1,150 00 1,000 00 250 00 2o1t2004 64,580 97 129,023 19 193,604.16 1,000 00 3,000 00 3,450 00 7,450.00 1,241 94 '1,241 94 Total AFSCME 1818 66,125 85 137,702 83 64,429 27 137,702_83 202,532.10 1,000 00 3,000 00 4.000.00 1,000 00 207,532.10 1,2æ78 .1,000 00 250 00 203,828.68 't,000,00 3,000 00 4.000_00 1,000 00 208.828.68 66,.125 85 137,702 83 203.828.68 1,000.00 3,000 00 4_000_00 1,000 00 208.828.68 O4O COLLECTOR O4O COLLECTOR O4O COLLECTOR O4O COLLECTOR 1,000 00 202,054.16 4.0 Department Total FY 2012 FY 2013 FY 20'14 Variance Full-l¡me Equ¡velent EmÞlovæs: 40 40 40 00 ---PAGE BREAK--- FY 2014 AFSCME l8l8 Union Employee Rates Counc¡l FY 2014 s2-2 Mayor FY 2014 52-2 Dept Request FY 2014 s2.2 STEP INCREASES Date Rate # Wks Old Nêu Rate FY 2014 2.00/6 Rate FY 2013 0.0% F T E voted t'y Counc¡l FY 20't3 52 H¡re Date Job Title Org/Object Department EiIPLOYEE NAME HUTCHINSON DAVIS MORAN VASSY SARAH MAUREEN KAREN MARCIE O4O COLLECTOR O4O COLLECTOR O4O COLLECTOR O4O COLLECTOR 1'1461-511'l 't1461-5't1'l 11461-5111 '11461-5111 '11to8t2004 4t24t2007 gt'l4to9 7t18t12 100% 1000/6 100./. 60 462 1000/0 ASSISTANT COLLECTOR PRINCIPAL CLERK SR ACCOUNT CLERK SR ACCOUNT CLERK I/II 47,O1A 92 42,069 83 40,088,03 959 79 æ271 978 99 879 96 51,103 06 45,9U 13 To Engineering 40 665 64 147 702 83 10 1.0 00 l0 76376 77904 At1At2013 807 5ô 51,103 06 51,103.00 45,934 13 45,934 13 To Eng¡neering To Eng¡neering 40 665 64 40 665 64 137 702 A3 137 742 A3 129-023.19 3.0 ---PAGE BREAK--- FY 2014 BUDGET DETAIL EXPENSES EXPENSES DESCRIPTION CoLLECTOR - 040 ORG OBJECT 11462 Dept Request I,000 Mayor by 1,000 Approved by Council 1,000 5317 EducationalTraining certification courses for collectors staff TOTAL TOTAL 11462 TOTAL TOTAL PROPOSED ng lnserts for real estate tax bills print resident parking stickers - reorder zone stickers and visitor passes Print passes for pass zone (100 per month) 91 .00 per pass 2,500 2,500 3,000 3,000 6,500 2,500 2.500 3,000 3,000 6,500 1 2,500 2.500 3,000 3,000 6.500 Uz'l Office Supplies General office supplies as needed 1 ---PAGE BREAK--- lnformation Technology Seryices (ITS) Mission Statement-Whv We Exist The Information Technology Services (ITS) Department continuously strives for excellence by providing cost effective, innovative information management and technological solutions that support the business strategies and decision-making process of the City of Sãlem. We work to provide a secure environmènt for data integrity, accessibility, system availability and delivery of information resources to the employees of the City of Salem and the citizens they serve. Budset & Staffins es for FY 2014 Under the restructuring and streamlining of the Data Processing and GIS Department adopted for FY 2012, aIl functions performed by these two departments have been merged into a new department, the Information Technology Services Department. The FY 2013 budget reflects thã continuation of this restructuring effort. Items that were on the Contracted Services line (Org-Obj 11552-5320) have been moved over to the Fixed Costs line (Org-Obj 11562-5243) in the amount of $8,476.00 As the demand on the GIS program is slowly increasing, there will be additional software maintenance costs in the amount of $t,SóO.OO, as shown on the Fixed Costs line (Org-Obj 11562-5243) Recent Accomplishments Performed migration of all physical servers in our department to a virtual environment. This allows us to better manage our servers and storage environment, and operate on a lower power-consumption budget Upgrade of the main firewall and several remote firewalls that are used to protect our network Upgraded security software on all servers and workstations Upgraded security on some of our wireless hotspots Prepared for and completed the upgrade from Munis release version 7.5 to version 9.2; work included installing new client versions city-wide, training all end- users, updating Reports, testing with all departments, and writing documentation. Performed various tasks, including creating and running custom reports in Munis Setup two extra Exchange servers to balance email load and provide better access for mobile devices Responded to all un-categorized WebQA/Citizen's Request emails Responded to all CodeRED / reverse-91I calls and email requests Provided website / Virtual Town Hall support a a a a a ---PAGE BREAK--- a Setup network infrastructure to support several different types of communication devices with email access, such as Android-based phones, iPhones, iPads and BlackBerrys Assisted the Parking Department with their evaluation and implementation of "smart" parking meters Continued to provide technical support and guidance for the Cþ-wide AMR (Automatic Meter Read) program Assisted the Purchasing Agent with the evaluation of our phone system Installed and configured a GlS-tracking and accountability program for the Department of Public Services (DPS) Replaced older Windows 2000 and Windows XP computers with new Windows 7 computers Completed the re-drawing of City wards and precincts in GIS, based on the 2010 United States Census Bureau data; provided support to City Council and City Clerk's office, produced ne\ry maps to reflect changes in said wards and precincts Provided mapping support and data management for several City departments and their contractors, including Planning & Community Development, Engineering, Water & Sewer, the Mayor's Office, Public Health, Assessing, Public Services, School Department, Police, Fire, and Building Assisted with the successful implementation of the City's new reverse-91I program Updated assessor parcel maps for FYl2 in-house, resulting in significant cost savings Supervised and mentored two interns from the Salem State University Geography department Updated all data acquired from MassGIS to reflect the most recently available data Obtained new (April 2012)high resolution oblique aerial photographs to be used with both Pictometry, Inc.'s EFS software, and ATcGIS software Continued to provide the City Assessor's Office and Planning & Community Development Office with training and support for Pictometry, Inc.'s Electronic Field Study (EFS) software Provided the Police Department and Planning & Community Development office with ArcView 9.3.1 licenses and technical support Worked with Applied Geographics to develop scope of work to upgrade the City's web-based GIS portal's functionality and performance. FY 2014 Goals & Obiectives o Implement a help desk system to expedite requests of the department(s), create troubleshooting tickets and track progress . Upgrade remainder of outdated firewalls at remote sites . Update City's network use policy and require acceptance/adherence to said policy ¡ Create network storage guidelines and best practices . Update Disaster Recovery Program and test it on a regular basis ¡ Evaluate current and future email needs, plan for upgrade o Evaluate network security: o Wireless hotspots - Internet access o "Smart" Devices - Internet / Email access o Growing trend of employees bringing in their personal devices o Evaluate virtualization of desktops, cloud computing andlor private hosting of the City's data and prepare migration plan o Centralize all licenses for permitting allowing the city to use price leveraging a a a ---PAGE BREAK--- . Investigate City-wide document storage needs and methods o Look into and pursue grant funding if available o Add additional staff to take on current and additional work/projects o Evaluate City's website needs o Continue to replace older computers with new ones and/or upgrade existing computers with more memory o Start to upgrade Windows XP computers to V/indows 7 as Microsoft will be retiring the Windows XP operating system in April of 2014 ¡ Continue to train staffand take advantage of professional training and education when available o Implement Munis paper-less PAF system o Re-organize GIS server data structure o Implement AToGIS Server software now that servers have been virtualized o Continue to maintain and update, as necessary, all spatial data including parcels, easements, street centerlines and road conditions ¡ Continue to provide mapping support and GIS data management for departments City-wide o Migrate GIS software from version 9.3.I to version l0.l o Standardize address data input between different software products used in various departments to enable creation of a master address file ¡ Determine the level of need for additional ArcView licenses and employees or interns under the GIS umbrella to further the City's GIS initiatives . Setup database between the City's GIS and its various consultants o Collect and update drainage, se\ver and other data as necessary using GPS unit at higher accuracy with new equipment o Work with and provide mentoring to Salem State University interns o Develop custom web mapping applications for departmental use, utilizing AToGIS Server 9.3.1/10.1 Outcomes and Performance Measurers We have found that previous performance measures are inadequate for our newly re-organized department, and that the old measurers cannot accurately, or fully capture all of our duties and responsibilities. Therefore, our first objective for FY 2013 is to implement a help desk system, which will allow us to track all of our user requests and related response times. With this system in place, we will be able to anallyze all requests, prioritize them, bring new focus to the department and increase responsiveness both internally and publicly. We expect next year's report to positively reflect these changes. In the meantime, please look to our recent accomplishments for indicators of our progress. Outcomes and Performance Measurers Actual FY 20',11 Actual FY 2012 Estimated FY 2013 Estimated FY 20'14 N/A N/A Help Desk Calls ---PAGE BREAK--- How FY 2014 Deoartmental Goals Relate to Citv's Overall Lons & Short Term Goals The ITS Department remains committed to making the City of Salem a healthier place to live, work, and do business in. To that extent, we have implemented as many "green" initiatives as possible, and our recent migration from physical to virtual servers helps lower our energy footprint for the City. 'We will continue to seek out as many innovative approaches as possible to serve up data effectively, reliably, and safely, *irit" ré¿u.ing our impact on the environment. Continuing GIS and mapping support for City departments aids in the progress of various projects planned to sustain and increase the 'livability, of Salem for its residents, businesses, and visitors. Projects and studies that are currently receiving support include, but are not limited to, City bike path mapping, the bike path extension project, the re-development of the Dominion power plant site, the re-development of the "Blubber Hollow" areä, and ih" Cunâi Stieelsalem State University Flood Mitigation project. Our department continues its mission to serve all City departments, its users, and the City's constituents by looking at ways to uniff our address and permitting data, and develop a functional master address database. This endeavor will aid in the de-duplication of City efforts, resulting in streamlining our flow of information. We are committed to not only maintain, but increase public access to as many constituent services as possible through our website. As the GIS infrastructure becomes more integrated into the City's business practices, we strive to support all new initiatives. Continued geospatial data maintenance and acquisition will allow the City's GIS to remain a robust and up-to-date information delivery and retrieval system. a a a a ---PAGE BREAK--- CITY OF SALEM - FY 2OI4 OPERATII{G BUDGET Expenditures Adopted Budget Adjusted Budget Y-T-D Expenses Department FY 2012 Fy 2013 Fy 2013 Fy 2013 Fy 2014 Mayor FY 2014 Council FY 2014 D ata Proc IT/GIS/-Personnel I155I 51 I I SALAzuES-FULL TIME II55I 5113 SALARIES-PARTTIME Total Data Proc IT/GIS/-Personnel Data Proc IT/GIS-Expenses 11552 5311 EDUCATIONAL TRAINING 11552 5320 CONTRACTED SERVICES ttss2 s42r oFFrcE SUPPLTES (cEN 11552 5520 SOFTWARE SUPPORT/ENHANCEMEI 11552 5582 DATA PROCESSING SUPP 11552 5710 IN STATE TRAVELiMEETINGS Total Data Proc IT/GIS-Expenses 146,008. l5 tl,775.00 r57,783.15 101,028.00 13,000.00 I14,028.00 130,940.00 7,088.00 138,028.00 i23,109.01 7,562.50 130,671.51 2,085.00 0.00 915.35 4,5t4.80 ) 4gg 48.06 10,062-43 153,616.00 0.00 153,616.00 166,928.00 0.00 166,928.00 166928.00 0.00 166,928.00 4,139.26 8,416.00 1,521.96 4,086.73 3,052.05 56.78 21,932.78 6,100.00 0.00 2,874.00 5,500.00 5,500.00 1,475.00 21,449.00 6,100.00 0.00 2,874.00 5,500.00 5,500.00 1,475.00 21,449.00 6,100.00 0.00 2,874.00 5,500.00 5,500.00 1,475.00 2t,449.00 6,100.00 0.00 2,874.00 5,500.00 5,500.00 1,415.00 21,449.00 6,100.00 0.00 2,874.00 5,500.00 5,500.00 1,47 s.00 21,449.00 070 155 D rtment Total 179,715.93 135,477.00 159,477.00 140,733.94 175,065.00 1gg,377.00 1gg,377.00 ---PAGE BREAK--- FY 2014 MANAGEMENT, BOARD MEMBERS AND PART-TIME SALARIES Counc¡l Voted FY 2014 Mayor Propsed FY 2014 s2.2 Mayor Rate FY 2014 2.00/6 Dept Request FY 2014 s2.2 Prop Rale FY 2014 o.o% Curent Rate FY 2013 2.O% # Board Meetings # HouF WklY = 1 F T E Codr Voted By Council FY 2013 52 H¡re Date Job Desc Org/Obj Dept Name Name DUIJVESIEIJN GROCKI GAUDE-T OLLE KEVIN JAMES 070 lnfomation Tech-GlS 070 lnfomation Tech-GlS 070 lnfomal¡on Tech-GlS 09201993 '1o112t2010 7t1t2012 CLAY RUST NINA JOANNE 070 lnfomatlonTech-GlS 11551-5111 coMpUTERANALYST 1 1551-51 1 1 tT-crs Director 1.1551-5111 tudr Mts pay '1 1 551-51 I 1 CoMPUTER ANALYST 070 lnfomat¡onTech-GlS 11551-5111 consurtant 56,836 93 38,534 09 5,656 19 10 1000/o '1,093 02 1,093 02 57,O55U 1,11488 58.196 65 58,196 65 06 01 10 1 60% 1000/0 100% 1,235.07 10a 77 I,000 00 39,455 94 5,791 50 63,483 55 39,455 94 5,79't 50 63,483 55 1,235 07 10477 1,000 00 38,682 30 5,677 94 52,200 00 't53.6't5.78 To Finance Budget 153,615.78 1,259 77 11095 1,21616 101,O27.21 2.7 Total Full T¡me - 5ll'l 13,000 00 P 13,000.00 Total Part T¡me - 5l13 114,027.21 2.7 Department Total FY 2012 FY 20'13 FY 20'14 Variance FulLIme Eduivalent Emdovë: 27 17 10 166.927.64 16Êp27.64 16Ê.927.Ê1 166,927-64 Total DUIJVESTEIJN OLLE lrìfomat¡on Tech-GlS SEWER WATER 11551-5111 tf-Grs Diredor [PHONE REDACTED] 610131-51 11 060 60% 1,259 77 1,259 77 39,455 94 13,151 98 13,151 98 o20 200Á o20 200/o 65,759 91 ---PAGE BREAK--- FY 20'14 DETAILED BUDGET REPORT EXPENSES DATA PROC/MIS/GIS/IT . O7O ORG OBJECT 11552 5317 TOTAL 11552 5320 RECURRING FIXED COSTS TOTAL DESCRIPTION ng Munis Training as needed 4 days at $1,275 ESRI GIS Training as needed Contracted Services FIXED Gosts: Contractual Agreements for GIS services MOVED TO 11562-5243 Council 5,1 00 1,000 6,100 5,100 1,000 6,100 5,1 00 1,000 6,100 TOTAL 11552 5520 TOTAL 't1552 TOTAL TOTAL PROPOSED General office supplies as needed Softwa re S u pport/En ha ncem ents DELUASAP State Contract Misc network software and licensing fees Desktop Extension Pictometry lnternational lmagery Update for 2012 General lT/GlS Supplies as needed 2,500 2,500 500 2,500 2,500 500 2,874 2,874 5,500 5,500 1,475 1,475 :z1.449 2,874 2,874 5,500 5,500 1,475 1,475 21.449 2,874 2,874 2,500 2,500 500 5,500 5,500 1,475 1,475 21.4tt9 TOTAL 5,500 5,500 5,500 11552 5582 lT/GlS Supplies 5710 ln State Travel, meetings lT/GlS Meetings & Conferences; Registration, Travel & Gas ---PAGE BREAK--- CITY OF SALEM - FY 2OI4 OPERATII{G BUDGET Expenditures Adopted Budget Adjusted Budget Y-T-D Fxpenses Department FY 2012 FY 2013 Fy 2013 Fy 2013 Fy 2014 Mayor FY 2014 Council FY 2014 IT/GIS-Fixed Costs 11562 5243 IT/GIS MAINTENANCE 11562 5341 PHONE/DSL/COMMUNICATIONS Total IT/GIS-FixedCosts 294,136.14 9,116.63 303,252.77 320,136.00 11,980.00 332,116.00 296,136.00 1 1,980.00 308,116.00 280,293.26 9,749.36 290,042.62 342,979.00 15,580.00 358,559.00 342,979.00 15,580.00 358,559.00 342,979.00 15,580.00 358,559.00 070 156 Department Total 303,252.77 332,116.00 308,116.00 290,042.62 35g,559.00 358,559.00 358,559.00 ---PAGE BREAK--- FY 2014 DETAILED BUDGET REPORT EXPENSES DATA PROC/MIS/GIS/IT - O7O . FIXED COSTS ORG OBJECT 'l'1562 5243 RECURRING NON-RECURRING 500 1,436 48 4,943 1,500 275 8,481 500 1,436 48 4,943 1,500 275 8,48'l 500 1,436 48 4,943 1,500 275 8,481 5,000 7,000 1,680 3,000 960 3,000 2,500 3,000 1,500 5,000 7,000 1,680 3,000 960 3,000 2,500 3,000 1,500 Dept Request Approved by Mayor Approved by Council DESCRIPTION IT/GIS MAINTENANCE Tyler Tech. Munis ASP Annual Fee includes OSDBA and Disaster Recovery Support RetroFit 9 Servers, 68 Printer and 195 PC maintenance $ 8,247 x 4 quarters RetroFit Time + Material for Printer Kits (printer = $350.00 x 15 kits) Backup and Disaster Recovery Services for 9 MS Windows Servers with on-site virtualization and Server image/data stored at both East and West Coast data centers Essex Craftsman A,/C cleaning for 2 units Formax Sealer Maintenance GoDaddy.com to keep salemferry.com + salemfilmoffice + salem.com + ci.salem.ma us Building lnspectors and Health Dept GEOTMS Annual Maint GeoTms update Assessors to Patr¡ot files recurring maintenance support lron Mountain Escrow Service for Munis Source Code Firewall Maintenance / Anti-Virus for 9 Servers includes Email Security Device and 8 remote site firewalls Network Project Consulting Virtual Town Hall Annual application services and hosting for 22 users Texthelp for salem.com browsealoud Citizens Requests support, hosting at $250.00 per month Alloy Software Help Desk and lnventory Applied Geographics, lnc. Annual Web Hosting fee ESRI Server license Annual Maintenance ESRI Desktop concurrent license Annual Maintenance ESRI Desktop Extensions license Annual Maintenance *new item based on GIS program expansion* ESRI ArcPad license Annual Maintenance Hardware for citywide permit management program: 30 tablets @ $300 = $9,000 Hardware for citywide permit management program: 5 kiosk computers @ $1,000 = $5,000 Tyler Technologies - GoDocs Software Module and Configuration 203,787 32,726 5,250 19,992 203,787 32,726 5,250 19,992 276 9,000 5,000 9,375 203,787 32,726 5,250 19,992 276 9,000 5,000 9,375 5 7 1 J 3 2 5 000 000 680 000 960 000 500 000 500 276 9,000 5,000 9,375 Tech Self Service Software Module Comcast for 931120 Washington @231 .90 per month COA/Library/Electrical/Cemetery/DPW Comcast 5 sites @ $81 90 mo = $409 50 per month Electric Dept Comcast to control cameras and lights $74.90 mo Electric Dept AT&T Wireless for Traffic Controller at Essex/Federal/Bridge Street Digital Transport Adaptors for 93 Washington Street 6.45X'12 Parking Dept DSL to Salem network at $90.90 mo x 12 = $1 ,090.80 Parking Dept DSL to Automated Meters Dryloop $90.90 mo x 12 months = $1090.80 Misc Charges for ComcaslVerizon/AT&T not covered 750 2,783 4,914 899 720 77 1,091 I,091 405 2,783 4,9't4 899 720 77 1,091 1,091 405 750 2,783 4,914 899 720 77 1,091 1,091 [PHONE REDACTED] Ver¡zon Wireless Cellular Service for rmit ram tablets mox12= 600 3 ---PAGE BREAK--- Finance Mission Statement-Whv We Exist The mission of the Finance Department is to present a complete and accurate statement of the City's financial condition. It is responsible for all financial and accounting activities in the City of Salem. Many of these activities are prescribed by Massachusetts General Laws to insure the fair assessment and collection of revenues and the proper disbursement of funds to meet approved expenditures. These activities are guided by the City Charter and Ordinances, sound financial and accounting business practices, and adherence to the Massachusetts General Laws. Sienif,lcant Budeet & Staffing Chanses for FY 2014 The Finance Director resigned in January 2013. A new Finance Director, Sarah Stanton, was hired in March 2013 Recent Accomplishments Received the GFOA Distinguished Budget Presentation Award for the FY 2013 budget (5th consecutive year). Received the GFOA Certificate of Achievement for Excellence in Financial Reporting FY 2012 budget (7th consecutive year). Active participation on the School Building Committee, serving as a member of both the Committee and attending all Executive Committee meetings with the Mayor and Superintendent with the focus on maximizing our 78.26%o expense reimbursement from the Massachusetts School Building Authorþ (MSBA). Continued participation on the City's Parking Plan Implementation Committee, putting forth the recommendations of the Nelson/Nyberg report Increased the City's stabilization fund to $3.9 million dollars through sound fiscal policy on use of free cash. Continue to assist new Superintendent and new School Business Manager in the development of the FY2014 budget. Negotiated new contracts for police, fire and AFSCME unions. a a a a a a a Worked with Human Resource department and IT Department to implement "Total Compensation Reports" through the MIINIS software system. ---PAGE BREAK--- FY2 &o ectiv ¡ Continue with payroll audit at the School department and to implement Time and Attendance module in the School Business Office. o Completion of a citywide fraud risk assessment to ensure that the City's cash and assets are safeguarded. o Implement a citywide Citi-Stat program, using performance indicators to improve city-wide efficiency and transparency. o Continue to improve the GFOA budget as per recommendations by review committee. ¡ Work with HR, Solicitor and Mayor's office to negotiate new contracts for police, fire, and AFSCME unions for 2015 to 2017. ¡ Finalize implementation of the Parking Plan, which will add new technologies to the parking operation, as well as the implementation of new parking passes and other modification to the existing way we do business. ¡ Implement new citywide permitting software that will connect all departments to one system, which will create efficiencies, give better data to end users, and professionalize the way the City conducts its permitting business. ¡ Review all departmental revenues with each department and make recommendations to the Mayor for potential revenue enhancements. o Review all departmental expenditures with each department and make recommendations to the Mayor for potential cost savings. o Work with city departments to write policies and procedures for administrative and financial functions per management letter. ¡ Work to more clearly define the methodologies for charging indirect costs to enterprise funds per management letter. ¡ Address all recommendation of the auditors in the management letter. ¡ Continue to encourage training and continuing education for both the Finance offrce as well as those departments that report to the Finance Director. Actual FY 2011 Actual FY 2012 Estimated FY 2013 Estimated FY 2014 Outcomes and Performance Measurers 35,000 100o/o 100To 100% 100Yo 100% 34,000 100Yo 100o/o 100o/o 100% 100o/o 33065 100% 100o/o 100o/o 100% 100% 30,889 1jjo/o 100% 100o/o 100Yo 100o/o # Accounts Payable lnvoices Processed Annual ly To DOR Deadline ScheduleA-Due10/31 Snow & lce - Due 9i15 Schedule of lndebtedness - Due 9/30 to CouncilWithin l5 of clos Administration & Finance Committee Council Month Re Financial Policies ---PAGE BREAK--- 400,000 200,000 600,000 505,1 65 252.582 850,000 649.875 324,924 400,000 150j22 50,000 850,000 20% ol Free Cash certified to ect Fund* ent *Nofe - FY 2012 amounts are actual amounts transferred 10o/o of Free Cash certified to OPEB Liabi Fund Retirement Stabilization Fund 20o/o of Free Cash certified to Stabilization Fund* 1 122 649.875 How FY 2014 Departmental Goals Relate to City's Overall Lons & Short Term Goals The Finance Department will continue to work with the Mayor and Human Resource Director oversee health care reform that will help the City manage it's fixed costs budget, while providing top shelf health plans to its employees and retirees. The Finance Department will work with the Mayor to implement sound fiscal policies and procedures, including adherence to the City's funding of the Stabilization, OPEB Liability and Capital Improvement Fund to ensure long term sustainabilþ. The Finance Department will work with departments to conceptualize ways to regionalize services with other communities as it has with the Town of Swampscott with the purchasing department and inspectional services department, with the goal to create synergies and improve delivery of services to all. The Finance Department will work closely with the School department on all financial matters to ensure all requirements are met in a responsible manner. The Finance Department will work with all departments in developing and implementing Capital Improvement Programs that will not only maintain and upgrade City buildings, infrastructure, and vehicle fleet, but also maximize the use of grant dollars and other cost offsetting opportunities to ensure all City's assets are maintained and preserved. 165 400 a o a I I¡ I + ,i I g 1 I ü t lrt¡ , * S* at G It't'ttrî T ---PAGE BREAK--- CITY OF SALEM - FY 2OI4 OPERATING BUDGBT Expenditures Adopted Budget Adjusted Budget Y-T-D Expenses Department FY 2012 FY 2013 FY 2013 FY 2013 FY 2014 Mayor FY 2014 Council FY 2014 Finance-Personnel 1I351 51 I I SALAzuES-FULL TIME 11351 51I3 SALARIES-PART TIME 11351 5131 OVERTTME (GENERAL) I I35I 5I5O FRINGE/STIPENDS Total Finance-Personnel Finance-Expenses 11352 5320 CONTRACTED SERVICES 11352 5381 PRINTING AND BINDING 113s2 s42r OFFTCE SUPPLIES (GEN 11352 5423 BUDGET PREPARATION 11352 5710 IN STATE TRAVEL/MEETINGS 11352 5730 DUES AND SUB Total Finance-Expenses 240,441.14 0.00 190.70 I, 150.00 241,782.44 23,945.00 200.00 2,599.35 2,557.42 2,958.38 883.00 33,143.15 250,633.00 0.00 200.00 l,150.00 251,983.00 252,486.00 0.00 205.00 1,150.00 253,841.00 232,250.42 0.00 0.00 1, I 50.00 233,400.42 261,123.00 13,000.00 200.00 0.00 274,323.00 265,427.00 13,000.00 200.00 0.00 278,627.00 265,427.00 13,000.00 200.00 0.00 278,627.00 30,000.00 200.00 3,s00.00 2,400.00 3,500.00 1 , 100.00 40,700.00 27,000.00 200.00 4,300.00 2,400.00 5,700.00 1,100.00 40,700.00 10,865.96 170.00 2,843.94 1,850.85 4,136.87 993.00 2r,460.62 30,000.00 200.00 3,500.00 2,400.00 3,500.00 1,100.00 40,700.00 30,000.00 200.00 3,500.00 2,400.00 3,500.00 1,100.00 40,700.00 30,000.00 200.00 3,500.00 2,400.00 3,500.00 1,100.00 40,700.00 090 135 Department Total 274,925.59 292,683.00 294,54t.00 254,961.04 315,023.00 319,327.00 3t9,327.00 ---PAGE BREAK--- FY 2014 MANAGEMENT, BOARD MEMBERS AND PART-TIME SALARIES Counc¡l Voted FY 2014 Mayor FY 2014 52.2 Mayor Rate FY 2014 2-Oo/" Dept Request FY 2014 52.2 Prop Rate FY 2014 0.0% Current Rate FY 2013 # Board Meet¡ngs # Houß WklY = 1 F T E ;odr Voted By Council FY 2013 52 Hire Date Job Desc Orq/Ob¡ Dept Name Name BRIDGMAN FULL VISCAY STANTON NINA DIANNE RICHARD SARAH O9O FINANCUAUDITING O9O FIMNCE/AUDITING O9O FINANCgAUDITING O9O FINANCE,/AUDITING 1'1351-51 I 1 FINANoE DtR 1'1351-5111 oFFrcE MNAGER 1.1351-51 1 1 FTNANoE DtR/AUDtToR '1 1351-51 1 1 FTNANoE DIR/AUDTToR 07061982 1'l.1112004 3/6/06 3t2512013 10 1,0 0.0 't0 'lo0% '100% ''tooo/o 'to0% 6A,027 36 49,336 82 91,198 44 'l 1 0 1 1,308.22 '1,308.22 948 78 948 78 1,865 38 1,865 38 Total AFSCME 1818 68,289 00 49,526 58 Res¡gned 97,372U 45,934 13 261,122.55 '13,000 00 13.000.00 200 00 274.322.55 1,334 38 7.76 1,902 69 69,654 78 50,517 11 99,320,29 45,934 13 69,654 78 50,517 11 99,320 29 45,934.13 42,069 61 250,632.23 Frcm lT Budget P 10 4-O RUST JOANNE 090 FINANCE/AUDITING .11351-5113consunant 265,426.32 265,426.32 13,000 00 13,000 00 13.000.00 13.000.00 200 00 200 00 278.626.32 278, Ê2â a2 Total Part T¡me . 5113 O9O FINANCE/AUDITING O9O FINANCE/AUDIIING 11351-5131 @¿dime 1 1351-5'150 AFSME stipend 200 00 1.150 00 10 1,150 00 251.942.23 DeDaÉmenl FY 2012 FY 2013 FY 2014 Va.iance :ull-f ¡me Equ¡valeil EmÞlovæs: 40 40 0 0 ---PAGE BREAK--- FY 2014 AFSCME 1818 Union Employee Rates Council FY 2014 s2.2 Mayor FY 20't4 52.2 Dept Requesi FY 2014 52.2 STEP INCREASES Date Rate # Wks Old Ner Rate FY 2014 2.O./o Rate FY 20',t3 0.0% F T E voted Ey Council FY 2013 52 H¡rc Date oroono l.o T'rtle fÞpârtment EMPLOYEE NAME GIUNÏA JUDITH O9O FINANCE/AUDITING 11351-5111 06171 996 42,069 61 1,0 A6271 879 96 42,069.61 1.0 100% 45,934 13 45,934 13 45,934.13 45,934.13 ¡Í5.934.13 ¡llt.934.13 ---PAGE BREAK--- FY 2014 DETAILED BUDGET REPORT EXPENSES t'n"n"" o"o"nt"nt - oto ,ÞÞruouu ut ooÞruouu u, ORG OBJECT DESCRIPTION DeptRequest Mavor Council 11352 5320 Contracted Services Funds to be used for ôperational audits of department to ensure compliance with Fed State, and Local requlations and sound business practices. Fund actuarial report for GASB 45 - OPEB Bl-Annual report. Fraud Risk Audits per management letter 10,000 20,000 30,000 3,500 3,500 3,000 3,500 10,000 20,000 30,000 200 200 3,500 3,500 10,000 20,000 30,000 3,500 3,500 3,000 3,500 TOTAL 11352 TOTAL 11352 5/21 TOTAL 11352 5423 TOTAL 11352 TOTAL 11352 5730 TOTAL 5381 Printing & Binding Letter Head, Envelopes, Writing Pads 200 200 200 200 Budget Preparation Binders For Budget Dividers/Cover Papers/File Folders/Labels/Pocket Folders Toner Cartridges - Printer/Copier 3 @ 304. 00 Misc Supplies 5710 lnstate Travel/ Meeting Seminars and Training as needed - MUNIS, GFOA online classes, NEGFOA, MMA, etc. Accounting School - Finance Director and Asst Finance Director Mileage, tolls, etc. Office Suppl¡es Misc offìce supplies as needed. Dues and Subscr¡pt¡ons Eastern Massachusetts Municipal of Auditors/Accountants Publications - Financial, GASB, GAO, MMA, MGFOA, etc. MMA¡AA membership GFOA Membership 340 300 912 848 2,400 60 500 260 280 100 340 300 912 848 2,400 340 300 I't2 848 2,400 500 500 3.000 500 3,500 1 60 500 260 280 100 1 60 500 260 280 100 ---PAGE BREAK--- Parking Missi t V/e Exis Provide pleasant and secure parking services to customers, while maintaining courteous and helpful assistance to the general public. Sisnificant Budeet & Staffine Chanses for FY 2014 Increase in electrical line item due to rate increases, extended hours of operation in the garages and addition of lighting fixtures. Increase in maintenance line item due to the need to purchase spare parts for the new credit card meters. Increase part time salary to accommodate and implement the new parking plan to include two new part-time meter control officers and one new part-time assistant meter collector. Recent Accomplishments CITY OF SALEM, MA o Hand held ticketing devices upgraded to take pictures. . Expanded hours of operation resulting in additional security and revenue. o Updated paid by space at the Bridge and Church Street lots. o Malfunctioning meters repaired within 24 hours. o Initiated garage structure survey. o Maintained preventative maintenance schedule. o Expanded security in both garages o monitor security cameras in both garages o Painted stairwells and exterior metal trim at S H garuge. o Steamed cleaned and painted all Museum Place garage stairwells. . Replaced banners at the Museum Place garage. o Survey M P garage to outline and repair drainage, electrical and structural issues. 2014 Goals & O a Initiate new meter control coin pick up KIMBERLEY DR¡SCOLL, RICHARD V¡5CAY, JAMES HACKER ---PAGE BREAK--- I t a a a New equipment to automate garages. Water proof M P garage and steam clean Increase revenue / increase collection with poor economy and budget restraints. Implement new down town parking program and monitor Improve technology at both garages. Obtain a grant to install and accommodate electric vehicle charging stations Install smart meters on Washington Street Repair electrical, drainage, and structural issues at the MP Garage Updat and improve the kiosk system Outcomes and Performance Measurers Actual FY 2011 Actual FY 2012 Estimated FY 2013 Estimated FY 2014 $ 900,000 $ 1,000,000 $1,400,000 25,000 $625,000 $ 900,000 $ 1.200.000 $1,100,000 25,000 $ 630,000 $911,111 $1.227.724 $1.044.905 36,893 $567.573 $ 957,070 $ '1,341, 606 $ 991,870 40,974 $ 658,400 Parking Fines collected Parking Garage revenue Parking Lot / Meter revenue Parkinq citations issued Parki citation dollar value How FY 2014 Departmental Goals Relate to CiW's Overall Lone & Short Term Goals The Parking Department Strives to provide safe and cost effective parking to support down town business, visitors, cultural events and residents. Our goal is to generate revenue to cover expenses and return revenue to the general fund to assist in stabilizing the tax rate. Review parking fees and fines Update garage technologies (CIP) Water proof Museum Place garage (CIP) ---PAGE BREAK--- CITY OF SALEM . FY 2OI4 OPERATTNG BUDGET Expenditures Adopted Budget Adjusted Budget Y-T-D Expenses Department FY 2012 FY 2013 Fy 2013 Fy 2013 Fy 2014 Mayor FY 2014 Council FY 2014 Parking 1481 I l48l I 1481 I 1481 I Total Parking 14812 t4812 14812 14812 14812 148t2 14812 14812 t4812 Total Department-Personnel 5II1 SALAzuES-FULL TIME 5I 13 SALAzuES-PART TIME 513r OVERTIME(GENERAL) 5I50 FRINGE/STIPENDS Parking Department-Personnel Department-Expenses 5211 ELECTRICITY 5255 BUILDING/EQUIPMAINT s284 EQUTPEMENT LEASE 5341 TELEPHONE 5381 PRINTING AND BINDING s421 OFFICE SUPPLIES (cEN 5521 PARKING TICKETS 57IO IN STATE TRAVEL/MEETINGS 5860 EQUIPMENT Parking Department-Expenses 391,516.81 130,050.30 691.34 8,050.00 530,314.45 83,996.99 48,9t8.82 0.00 6,784.28 5,999.19 2,500.00 0.00 0.00 8,320.97 156,520.85 394,686.00 173,816.00 1,500.00 8,050.00 578,052.00 422,736.00 152,069.25 8,172.75 8,050.00 591,028.00 391,882.30 130,t23.21 7 ,639.58 8,050.00 543,695.09 462,346.00 t87,516.00 1,500.00 0.00 651,422-00 470,121.00 178,116.00 I,500.00 0.00 650,403.00 470,727.00 178,t76.00 1,500.00 0.00 650,403.00 86,000.00 50,000.00 0.00 15,000.00 6,000.00 2,500.00 500.00 1,000.00 3,500.00 164,500.00 19,023.00 58,477.00 0.00 15,000.00 6,000.00 2,500.00 0.00 0.00 3,500.00 164,500.00 19,023.00 47,566.35 0.00 14,353.32 5,999.9s 2,499.92 0.00 0.00 3,262.45 I52,703.89 90,000.00 73,544.00 25,512.00 15,000.00 6,000.00 2,500.00 500.00 1,000.00 3,500.00 217,616.00 90,000.00 74,500.00 25,512.00 15,000.00 6,000.00 3,000.00 0.00 500.00 3,000.00 217,572.00 90,000.00 74,500.00 25,512.00 15,000.00 6,000.00 3,000.00 0.00 500.00 3,000.00 217,572.00 180 481 D Total 686,835.30 742,552.00 755,528.00 696,398.98 g69,03g.00 867,975.00 967,975.00 ---PAGE BREAK--- FY 2014 MANAGEMENT, BOARD MEMBERS AND PART-TIME SALARIES Counc¡l Voted FY 20'14 Mayor Propsed FY 2014 s2.2 Mayor Rate FY 2014 2.Oo/. Dept Request FY 2014 52-2 Prop Rate FY 2014 o.oolo Curent Rate FY 2013 2.Oolo # Board Meet¡ngs # HouF WklY = 1 F T E Voted By Counc¡l FY 2013 s2 Hire Date Job Desc Orq/Ob¡ Depû Name Name HACKER SULLAWAY GUY O'KEEFE PZENEY MILLETT JAMES ALAN JANE ROBERT DAVID MARY PARKING DEPT PARKING DEPT PARKING DEPT PARKING DEPT PARKING DEPT PARKING DEPT 14A11-5111 14811-5111 148't1-5111 14811-5111 '14811-511 1 't4811-5111 PARKING DIRECTOR ASST PARKING DIRECTOR BOÆD CLERK SHIFT SUPERVISOR SHIFT SUPERVISOR SHIfl SUPERVISOR 05012001 09/04/03 07061987 9120110 6t201'l 180 180 180 180 180 180 180 PARKING DEPT 59,426 47 38,46372 840 00 B 32,463 42 31,654 27 231,437.52 394,685-/O 10,077 60 P 110,853 60 P 19,760 00 P 20,280 00 P 12,84400 P 173,415.20 I,500 00 8,050 00 578,050.60 80 12.O Total Full T¡me - 51l l 19 11 15 19 Total Part Time - 5113 70 12.O Department Total 10 10 't0 0.0 10 'loo.Á 1000Â 12 lOOo/o lOOo/o 100% 1,150 51 1,150 51 739 69 739 69 624 30 624.30 608 74 60874 Total AFSCME 1818 'lo 20 '10 20 20,232 72 60,056 57 38,61 1 65 840 00 32,58A 2A Resigned 31,776 02 298,473.19 442345.71 111,279 96 9,918 00 20,358 00 25,786 80 147,S7S.4A .1,500 00 651,421-19 1,173 52 852 56 636 78 620 91 61,257 70 44,503 63 840 00 33,240 04 113,505 56 1 0,1 16,36 61,257 70 44,503 63 840 00 33,240 04 1.13,505 56 10,116 36 32,411 54 32,411 54 298,473 19 298,473 19 470,72Ê.1'l 470.726.',t1 10 40 20,637 37 20,637 37 180 PARKING DEPT 180 PARKING DEPT 1481 1-51 1 3 cAsHrER/MATNTENANCE 1 481 1 -51 13 sasoN[ woRKER 180 PARKING DEPT 180 PARKING DEPT 14811-5113 METERcoNTRoL 14811.5113 ASSISTANT METER coLLEcToR 180 PARKING DEPT 180 PARKING DEPT .14811-5113 sEcuRrry 14811-5131 ovERïME 1481'l-5150 AFSCME stiænd 19 19 'to 20 10 00 10 20 10 00 10 40 10 20 2 13 00 13 00 13 00 't3 00 20,76516 13,15't_27 13 26 13 26 20,76516 13,15't.27 178,'175.72 17A,175.72 'I,500 00 I,500.00 650.401.83 650.401.83 1.'150 00 FY 2012 110 FY 2013 110 FY 2014 120 Variance Full-T¡mê Eou¡€lent EmDlov€: '1 0 ---PAGE BREAK--- FY 2014 AFSCME 1818 Union Employee Rates Counc¡l Ff 2014 s2.2 Mayor FY 2014 s2.2 Dept Request FY 2014 52.2 STEP INCRÊASES Date Rate # Wks Old Neu Rate FY 2014 2.0% Rate FY 2013 o.oo/o F T E voted ay Counc¡l FY 20t3 52 H¡re Date Org/Object Title Department EMPLOYEE NAME BATES DELIGIANIDIS DELIGIANIDIS GRENADER KIRNOS KIRNOS MERRIL MERRIL RAMSDELL STWEART WONG MARK 180 PARKING DEPT ZACH 180 PARKING DEPT Shn D¡fferent¡al-WEEKENDS BELA 180 PARKING DEPT MICHAEL 180 PARKING DEPT Shift Different¡al-N IGHTS GLORIA ,I8O PARKING DEPT Shifr Different¡al-WEEKENDS DAWNE 180 PARKING DEPT JOYCE 180 PARKING DEPT I\¡ICHAEL 18O PARKING DEPT 14A11-5111 METER REPAIR PERSON 14811-5111 PKGARAGE MAINT 2t't4t2000 12t22012 836.84 70434 853 58 71443 1222013 7t14tO4 40,750.81 24,99490 24,9947A 1,999 58 34,520 14 't0 10 .t0 'I 0 100% 26.2 260 1000h 1000k 100% 1000/0 1000/0 1000k '100% 1000h 100% [PHONE REDACTED]/0 44,556 71 38,181 34 420 00 28,101 12 28,101.12 2,24809 42227 2A 208.00 42,227 28 28,101 12 M,101.13 44,5æ71 38,'t81 34 420 00 28,101.12 24,101 12 2,248 09 42,227.28 208 00 42,227.28 28,10't 12 44,101 13 44,5û71 38,18'l 34 420 00 28,101.12 24,101 12 2,24409 42,227 28 208 00 42,227 28 28,101.12 44,101 13 1481 1-51 1 1 148''t'1-5111 CASHIER STEP CASHIER STEP Base Rate X 9% METER CONTROL 527.78 527.78 4222 793 09 538 34 538 34 43 07 808 95 01021992 12301991 744 56 853 57 '14811-5111 10 10 10 10 14811-5111 1481 1-511't 1481 1-51 1 1 METER CONTROL CASHIER STEP METER REPAIR 0831 1998 01021 992 711912007 793 09 527 7A 807 08 æ8 95 538 34 82322 10115t2013 3A,520.37 24,994 90 36,662.04 231,437.52 8.0 294,47X-19 294,473.'t9 29A,473.19 ---PAGE BREAK--- FY 2014 DETAILED BUDGET REPORT EXPENSES - 180 ORG OBJECT TOTAL 14812 5255 DESCRIPTION Museum Place South Harbor Church St Sewall St. Delandes Charter & Crombie Lot BUILDING/EQUIP MAINT Roto Rooter Amano/McGann Misc. Repairs / Updates (Older equipment) Misc. Meter Supplies Lighting Meterial Elevator monitering contract Meter Batteries Elevator Contract Elevator repairs (Older equipment) Daily MainVrepairs Paint - Traffìc strip - white, yellow, blue ma¡ntenance and supplies General custodial supplies driveway sealer vehicle maint meter/pole repairs power washing & garage repairs annual kiosk moniter¡ng annual smart meter monitering 50,500 25,250 4,000 2,750 3,750 3,750 90,000 50,500 25,250 4,000 2,750 3,750 3,750 90,000 Council 50,500 25,250 4,000 2,750 3,750 3,750 90,000 2,225 3,500 1,164 1,000 1,500 3,400 10,011 2,000 1,500 't,525 3,000 2,615 60 2,000 1,500 13,000 3,240 20,304 2,225 3,500 1,164 1,000 1,500 3,400 10,01 1 2,000 1,500 1,525 3,000 2,615 60 2,000 1,500 13,000 3,240 21,260 2,225 3,500 1j64 1,000 1,500 3,400 10,01 1 2,000 '1 ,500 1,525 3,000 2,615 60 2,000 1,500 13,000 3,240 21 ,260 TOTAL TOTAL '14812 5341 pment Lease Kiosks at Bridge St Lot and Church St Lot - 2,131. X 12 Months TELEPHONE At&T$200.00 Verizon Telephone repairs (Responsible for dept. phone repairs) 2 Modems credit cards Verizion Meter Fees for Single Space Meters 2,400 1,600 500 1,200 1,900 7,400 2,400 1,600 500 1,200 1,900 7,400 2,400 1,600 500 1,200 r,900 7,400 25,572 25,572 25,572 25,572 25,572 25,572 TOTAL TOTAL 14812 TOTAL Garage/Lot Tickets: Discount Parking Stamps: 1 0,000 12 hour parking stamps 5,000 t hour parking stamps il21 OFFICE SUPPLIES General Offìce Supplies 1 2,000 2,274 1,726 6,000 2,500 2,500 2,000 2,274 1,726 6,000 3,000 3,000 2,000 2,274 1,726 6,000 3,000 3,000 ---PAGE BREAK--- FY 2014 DETAILED BUDGET REPORT EXPENSES - 180 ORG OBJECT 't48't2 TOTAL 14812 TOTAL 14812 TOTAL lotal proposed DESCRIPTION Dept Request Mayor 500 1,000 1,000 3,500 3.500 217,616 Council 5521 PARKING TICKETS Parking Tickets for Police department 5710 ln State Travel/Meet¡ng Training and meetings 5860 Equipment Misc office equipment replacement as needed Shelters for Kiosks 500 500 500 500 3,000 3.000 217,572 3,000 3.000 217,572 ---PAGE BREAK--- S Purchasing Mission Statement - Whv We Exist The mission of the Purchasing Department is to acquire and dispose of, all supplies, services and real property at the best value to the Cþ, while ensuring compliance with all state laws, regulations and City ordinances. B &S for FY 2014 There are no significant Budget or Staffing changes anticipated in FY 2014. Recent Accomolishments o Effectively issued and managed competitive procurements for the City of Salem and Town of Swampscott. o Ensured that Requisitions and Purchase Orders were processed in compliance with procurement laws, and in a timely manner. o Drafted 'Procurement Manual' which outlined policies, procedures and responsibilities of all parties involved in competitive procurement, requisitions, purchase orders, and contract administration. o Transfened City cellphone service to Verizon Vy'ireless in order to address service limitations and other complaints and issues directed towards previous provider. ¡ Continued working with the School Department to comply with the 'Consent Order' issued by the Attorney General's Office. o Joined and attended meetings and conferences of the Massachusetts Association of Public Purchasing Officials (MAPPO). o Attended continuing education courses provided by the Massachusetts Office of the Inspector General's Massachusetts Certified Public Purchasing Officials (MCPPO) Program. ¡ Participated in several cooperative and joint solicitations to encourage regionalization and take advantage of higher volume pricing rates. o Served on City Hall Renovation Building Committee. o Updated routing process ofcontracts, change orders and other legal documents to encourage efficiency. o Worked with Data Processing to analyze the City's current copy machine agreements and usages to ensure that the equipment and terms are in line with the users' needs. FY 2014 Goals & Obiectives Goal: Increase City awareness of current contracts held by the various departments, statewide contracts and other purchasing options (ex. cooperative purchasing) through distribution of a master contract list for the City and State. o ---PAGE BREAK--- o Goal: Provide a line of communication between Departments making similar procurements so that purchases may be consolidated and savings realized. ¡ Goal: Lobby to update legislation regarding procurement thresholds and other out of date requirements that increase costs. . Goal: Continue to explore ways to make the Purchasing Department webpage more efficient, user-friendly and informative. - Research other Purchasing web pages to review what information they include on their own webpage. - Work with City web provider, Virtual Town Hall, to implement new ideas. ¡ Goal: Attend Massachusetts Association of Public Purchasing Official meetings to keep current with the Commonwealth's Purchasing Guidelines, Requirements, Laws, and obtain credits towards certification requirements as a Massachusetts Certified Public Purchasing Officer. o Goal: Work to conserve resources by implementing paperless record keeping systems, when possible. o Goal: Continue to participate in cooperative bidding initiatives. Outcomes and Performance Measurers Actual FY 2011 Actual FY 2012 Estimated FY 2013 Estimated FY 2014 70 6 7,850 70 6 7,850 62 I 7,806 5 1 b 7,833 Bids and RFP's of Salem Town of Swa Purchase Orders a How FY 2014 Departmental Goals Relate to City's Overall Lone & Short Term Goals Goal: Improve communication with citizens - Updating the website to include features such as an "awarded contract" page will allow citizens to view the bidding process from beginning to end, encouraging transparency and the transmission of accurate information Goal: Implement regionalized services to enhance services while saving taxpayer dollars. - The Purchasing Department has engaged in, and will continue to seek opportunities to take advantage of group purchasing options. The Department also continues to work with the Town of Swampscott, preparing solicitations for competitively procured goods and services. Goal: Incorporate more public art throughout the City. - The Purchasing Department was heavily involved in the solicitation of proposals for the creation of a public art master plan, and will continue to be involved in future efforts. Goal: Enter into new five year agreement on collection and disposal of solid waste - The Purchasing Department assisted in drafting the new contraclscope of services, drafted and issued the Invitation for Bids (a joint effort with the City of Beverly) and awarded and executed the contract. o ---PAGE BREAK--- CITY OF SALBM - FY 2OI4 OPERATING BUDGET Expenditures Adopted Budget Adjusted Budget Y-T-D Expenses Department FY 2012 FY 2013 FY 2013 Fy 2013 Fy 2014 Mayor FY 2014 Council FY 2014 Purchasing-Personnel 11381 5I I I SALAzuES-FULL TIME 1138I 5113 SALAzuES-PART TIME I I381 5150 FRINGE/STIPENDS Total Purchasing-Personnel Purchasing-Expenses T1382 5306 ADVERTISING I1382 538I PRINTING AND BINDING 11382 s421 OFFICE SUPPLIES (cEN 11382 57IO IN STATE TRAVEL/MEETINGS 11382 5730 DUES AND SUB 11382 5851 OFFTCE EQUIPMENT Total Purchasing-Expenses 97,2t2.11 0.00 1,900.00 99,ttz.ll 98,6 16.00 1,600.00 2,150.00 102,366.00 100,470.00 1,200.00 2,150.00 103,820.00 15,000.00 289.00 1,250.00 250.00 255.00 0.00 17,044.00 94,596.90 1,200.00 1,900.00 97,696.90 102,698.00 1,600.00 1,000.00 105,298.00 103,833.00 1,600.00 1,000.00 106,433.00 103,833.00 1,600.00 1,000.00 106,433.00 15,000.00 243.00 1,086.19 294.66 539.00 145.80 17,309.25 15,000.00 500.00 1,250.00 600.00 700.00 300.00 18,350.00 13,920.41 289.00 926.0s 250.00 205.00 0.00 15,590.46 15,000.00 500.00 1,250.00 8s0.00 350.00 300.00 18,250.00 15,000.00 500.00 1,2s0.00 850.00 350.00 300.00 18,250.00 15,000.00 500.00 1,250.00 850.00 350.00 300.00 18,250.00 240 138 Department Total 116,42r.36 120,716.00 120,864.00 t13,287.36 123,54g.00 124,683.00 124,683.00 ---PAGE BREAK--- FY 20'14 MANAGEMENT, BOARD MEMBERS AND PART-TIME SALARIES Counc¡l Voted FY 2014 Mayor Propsed FY 2014 52.2 Mayor Rate FY 2014 2.Oolo Dept Request FY 2014 s2.2 Prop Rate FY 20't4 0.0% Curent Rate FY 2013 2-Oo/" # Board Meet¡ngs # Houre WklY = 1 F T E Voted By Council FY 2013 52 H¡re Date Job Desc Org/Obj Dept Name Name WATKINS HASKELL THOMAS WHITTNEY 240 PURCHASING 240 PURCHASING 1 1381-5'l'1 1 PURCHASTNG AGENT 'I 1381-51 11 PURoHAS¡NG AGENT 9t2Z09 10t9t12 56,545 94 42,069 61 98-615-55 'I 600 00 1.600.00 1,150 00 1 000 00 00 10 1.0 2-O Total Full Time - Slll 160 Total Part T¡me - 51'13 'lOOo/o 100% 1,087 42 1,O47 42 't0 10 1.150 00 Total AFSCME 1818 45,934.13 102-697.46 10 00 10 00 1,109 17 1 600 00 10 00 1,600.00 'l 000.00 1 000 00 1,000.00 1.000.00 105.297.Æ '1,087 42 1,OA7 42 Resìgned 56,763 32 Res¡gned 57,898 59 45,934.13 103.432-72 1 600 00 1,600.00 't 000 00 1,000.00 106.432.72 57,898 59 45,934 13 103.432.72 1 600 00 1.600.00 I O00 00 't.0(X,.00 106.432.72 240 PURCHASING 11381-5113 11381-5150 AFSCME-Fr¡nse 1 1381-5150 clerk sipend forAdd'l worktrom 240 PURCHASING 24O PURCHASING 't 000 00 I 000 00 2.150.00 Total Part Time - 5150 102.365.55 2.O DeDartment Total FY 2012 FY 2013 FY 2014 Variance FUILT¡me Equ¡valent Employ€: 20 20 00 ---PAGE BREAK--- FY 2014 AFSCME l8l8 Union Employee Rates Counc¡l FY 2014 92.2 Mayor FY 2014 s2-2 Dept Request FY 2014 52.2 STEP INCREASES Date Rate # Wks Old Neu Rate FY 2014 2.O% Rate FY 2013 0.0% F f E voted Ey Counc¡l FY 20t3 52 H¡re Date otoo,* Iro Title Department EMPLOYEE NAME FOLEY ELIZABETH 240 PURCHASING 11381-51 11 PRINCIPAICLERKÍt 09151 986 42,069 61 I 0 86271 879 96 42,069.61 1.0 1000/o 45,934 13 45,934_'13 45,93413 45,934.13 ¿15,934.13 45.934. t3 ---PAGE BREAK--- FY 2014 DETAIL BUDGET REPORT EXPENSES PURCHASING - 240 by Approved by Council ORG OBJECT DESCRIPTION uest 15,000 15,000 15,000 Requirement to solicit bids and proposals TOTAL TOTAL 11 1 500 500 1,250 1 000 1,250 500 500 1,250 Office Envelopes Varies every year according to amount of correspondence, bid packages and memos to all departments 5421 Office Supplies (General) File folders hanging folders, envelopes, pens, pencils, large envelopes for bid and proposal packages, binder clips, ink cartridges for fax machine & toner for HP Printer located in Purchasino = 500 s00 TOTAL 571 TOTAL TOTAL 't1 TOTAL TOTAL PROPOSED 1 ngs Professional Organizations and State sponsored courses to sustain Purchasing Certification Massachusetts Association of Public Puchasing Ofücials Meetings located in different Towns and Cities of the Commonwealth. 5730 Dues and Subscriptions Goods and Services Bulletin and any other necessary publications, est = MAPPO yearly membership payable each May 5851 Office Equipment Misc. office equipment as needed 700 150 850 700 150 850 100 250 350 't ü,25u 700 r00 250 150 850 100 250 350 300 18,259 300 300 300 350 'r ö,25u 300 300 ---PAGE BREAK--- CITY OF SALEM - FY 2OI4 OPERATING BUDGET Expenditures Adopted Budget Adjusted Budget Y-T-D Expenses Department FY 2012 FY 2013 FY 2013 FY 2013 FY 2014 Mayor FY 2014 Council FY 2014 Purchasing-Fixed Costs 11392 5341 TELEPHONE-NEXTELS 11392 5422 COPIERS & SUPPLIES Total Purchasing-FixedCosts 20,999.70 29,198.20 50,797.90 21,000.00 29,726.00 50,726.00 24,706.00 27,126.00 52,432-00 24,357.33 22,133.37 46,490.70 27,600.00 28,980.00 56,580.00 27,600.00 28,980.00 56,580.00 21,600.00 28,980.00 56,580.00 240 139 Department Total 50,797.90 50,726.00 52,432.00 46,490.70 56,5g0.00 56,5g0.00 56,5g0.00 ---PAGE BREAK--- FY 2014 DETAIL BUDGET REPORT EXPENSES PURCHASING - FIXED COSTS 240 Approved þy Approved by Council ORG OBJECT TOTAL 11392 il22 TOTAL tutAL t-Kut-(JìtEU DESCRIPTION Verizon - Cemetery, City Clerk, Electrical, Engineer, Finance, Health, Legal, Mayor, Park, Parking, Planning, Public Property, Public Services, Veterans Photocopy Machine Model: Canon 1R3025, Location DPW Garage, Lease Payment 91 17lmonth X 1 2 months= Model: Canon 1RC2880, Location: Mayor's Office, Lease Payment: 9195/month x 12 months= Model: Canon 1RC5240, Location: 3rd Floor, F¡nance Office, Lease Payment: $330/month X 12 months= Model: Canon 1R3235, Location: Assesors Office, Lease Payment: $153/month x 12 months= Model: Canon lR1025lF, Location: Collectors Office, Lease Payment: 942/month X 12 months= Model: Canon 1RC3235, Location: Treasurers Office, Lease Payment: 9153/month X 12 months= Model: Xerox W5150PY, Location: 3rd Floor, Annex, Lease Payment: 9195/month x 12 months= Model: Xerox W5150PT, Location: Clerk Rm 'l , Lease Payment: $195/month x 12 months= Model: Xerox W5638PT, Location: Clerk Rm 3, Payment: $9O/month x l2 months= Model: Xerox WC7132, Location: 2nd Floor, Finance, Payment: 970/month x 12 months= Toner, Staples and PaperAnnual estimate= OVERAGE CHARGES IN FY 2014 Budget 27.600 27.600 1,404 2,340 3,960 1,836 504 1,836 2,340 2,340 1,080 4,500 28,980 56,580 27,600 27,600 1,404 2,340 3,960 1,836 504 1,836 2,340 2,340 1,080 840 6,000 4,500 28,980 56,580 27,600 27,600 840 000 6 1,404 2,340 3,960 1,836 504 1,836 2,340 2,340 1,080 840 6,000 4,500 28.980 56.5E0 ---PAGE BREAK--- Treasurer - General Admin Mission Statement - Whv We Exist The primary function of the Treasurer's Office is to preserve, protect and manage the financial resources of the City. The Treasurer is responsible for the receipt, deposit and disbursement of City funds, the accurate accounting and prudent investment of City funds in order to maximize yields while maintaining adequate liquidity and ensure compliance with Massachusetts General Laws, with the Charter and Ordinances of the City of Salem. The Treasurer prepares and submits quarterly employmenttax forms to the State and Federal governments. The Treasurer undertakes continual maintenance of the City's operating and investment funds and completes a reconciliation of the City's bank and cash accounts. The Treasurer in conjunction with the Finance Director negotiates municipal borrowings (both long and short term) for capital related projects. The Department is also responsible for accounts and properties in the Tax Title process, and for the public auction of foreclosed properties. The Treasurer for the City of Salem is also the Treasurer for the Salem Contributory Retirement system and the Salem/Beverly Water Supply Board. Sienificant Budset & Staffins Chanses for FY 2014 There are no staffing changes anticipated for FY 2014 A budget change anticipated for FY 20l4could is an increase in credit card fees as the City looks to implement additional smart meters and Unibank ACH fees Recent Accomnlishments Transitioned Payroll Coordinator to the Treasurer's Office from Information Technologies Supervised payroll functions for weekly and bi-weekly payroll Streamlined the paying of various employee deductions Advisory Board of the Massachusetts Municipal Depository Trust Participated on the Procurement Management Team with the Office of the State Treasurer and Receiver General, reviewing the Request for Response for an Investment Manager to the Massachusetts Municipal Depository Trust Instrumental in initiating advantage for lump sum payment from MSBA resulting in a 2 million dollar savings to the City of Salem over the next ten years Participated in the Cities review process resulting in a upgraded bond rating from Standard & Poors Implemented E-Payables with Bank of America for electronic vendor payments O o o ---PAGE BREAK--- FY 2014 Goals & Obiectives Continue to upgrade on-line banking and employee deduction reporting systems and vendor Strive to maintain quality fiscal management and reporting. Continue to train staff, and to take advantage of professional training and education when available and practical. Continue to maximize investment earnings by working with current and new financial institutions. Review debt management policies and make recommendations and updates as needed Continued to improve efficiencies and controls Review tax title accounts and identify if they would generate funds to the City of Salem. Address gaps in the process to best utilize staff expertise and contribute to sustaining positive staff morale and productivity Obtain treasurer certification through the Massachusetts Collectors and Treasurers Association. FY 2014D artmental R & Short Term Goals o To take advantage of all opportunities, through upgrading or education, to become sufficiently knowledgeable and efficient in order to meet current challenges. o Strive to maintain quality fiscal management and reporting. o In conjunction with the Finance Director review financing for the replacement, repair and acquisition of capital assets as prudent planning and funding of its capital infrastructure ensures the City can continue to provide quality public services in a financially sound manner o To work with the Finance Director to prioritize funding in order be within the limitations of the City's budget o Maximize investment earnings o Review tax title accounts and identiff source of funds ) ---PAGE BREAK--- CITY OF SALEM - FY 2OI4 OPERATING BUDGET Expenditures Adopted Budget Adjusted Budget Y-T-D Expenses Department FY 20t2 FY 2013 FY 2013 FY 2013 FY 2014 Mayor FY 2014 Council FY 20t4 Treasurer-Personnel 1145I 5I 1 I SALARIES-FULL TIME I145I 5150 FRINGE/STIPENDS Total Treasurer-Personnel Treasurer-Expenses 11452 5317 EDUCATIONAL TRAINING 11452 5320 CONTRACTED SERVICES 11452 5388 TAXFORECLOSURESERV 11452 5421 OFFICE SUPPLIES (GEN 11452 5425 CHECKS/FORMS 11452 5709 CREDIT CARD/EFT FEES 11452 5130 DUES AND SUB Total Treasurer-Expenses 156,681.42 1,150.00 157,831.42 610.19 0.00 8,000.00 1,454.92 5,214.00 40,100.00 145.00 55,524.11 206,360.00 2,150.00 208,510.00 650.00 1,400.00 8,000.00 1,500.00 6,500.00 55,100.00 160.00 73,310.00 208,214.00 2,150.00 210,364.00 196,151.7 6 1,150.00 197,301.76 639.20 0.00 8,000.00 881.47 3,649.89 53,661.20 145.00 66,982.76 210,857.00 1,000.00 211,857.00 650.00 1,400.00 8,000.00 1,500.00 6,500.00 82,850.00 160.00 101,060.00 220,825.00 1,000.00 221,825.00 220,825.00 1,000.00 22t,825.00 650.00 1,400.00 8,000.00 1,500.00 6,500.00 55,100.00 160.00 73,310.00 650.00 1,400.00 8,000.00 1,500.00 6,500.00 82,850.00 160.00 101,060.00 650.00 I,400.00 8,000.00 1,500.00 6,500.00 82,850.00 160.00 101,060.00 270 145 D Total 213,355.53 281,820.00 283,674.00 264,294.52 312,917.00 322,885.00 322,885.00 ---PAGE BREAK--- FY 2014 MANAGEMENT, BOARD MEMBERS AND PART-TIME SALARIES Counc¡l Voted FY 2014 Mayor Propsed FY 20'14 52.2 Mayor Rate FY 2014 2.Oolo Dept Request FY 2014 s2.2 Prop Rate FY 2014 0-0% Curent Rate FY 20't3 # Board Meet¡nqs # HouF WklY = 1 F T E Cod( Voted By Council FY 2013 52 H¡re Date Job Desc Org/Obj Dept Name Name FABIZEWSKI LEBLANC MCMAHON KATHY SHERRIE KATHLEEN 270 TREASURER 270 TREASURER 270 TREASURER 1 1 451-51 1 1 TREASURER 1 1451-5111 Payroll Coordìnator 1'l 451 -5'l 1'l TRilSURER 7t'I2010 2t'1t2010 [PHONE REDACTED] 4A,521 66 47 ,988 75 67,779 A4 42,069 61 206,359.85 1,000 00 I,1 50_00 1,000 00 1,'t50 00 10 1_0 10 10 '100% 100% 100% 933 11 933'11 922æ 92246 1,303 46 1,303 46 48,7083/' 48,17329 68,040 61 95't 77 941.32 1,457 30 49,682 51 49,136 76 76,071 06 49,682 51 49,136 76 76,071 06 4-0 Total Full T¡me - 5l1 l Total AFSCME 1818 45,934 13 2'10,856.38 45,934 13 45,934.13 220,824.ß 220.824.6 270 Certified Treasure/s St¡pe 11451-5150 270 AFSCME Fringe 11451-5'150 1,000 00 1,000 00 1,000 00 1,000 00 1,000 00 10 2,150.00 Total Fringe - 5150 1,000.00 1,000.00 1,000.00 208,509.85 4.0 Department Total 211,856.38 22'1,824.46 221,824.46 FY 2012 FY 2013 FY 20'14 Variance FulLf ¡me Equ¡valent EmÞlove€: JU 40 40 00 ---PAGE BREAK--- FY 2014 AFSCME l8l8 Union Employee Rates Counc¡l FY 2014 52.2 Mayor FY 2014 52.2 Dept Request FY 2014 52.2 STEP INCREASES Date Rate # Wks Old Neu Rate FY 2014 2.O% Rate FY 2013 0.0% F T E voted 8y Council FY 2013 52 H¡rc Date o*,oono lr.o T¡tle Department EMPLOYEE NAME cooK ELAINE 270 TRÊASURER 1'1451 -51'11 CLERK 3/1 1/96 42,069 61 1 0 A6271 879 96 ¿2 06Ít 6l lo 100% 45,934 13 45,934 13 45,9U13 ¡t5-93¿-13 ¡f5-934-13 4!i-93¿_13 ---PAGE BREAK--- FY 2014 DETAILED BUDGET REPORT EXPENSES TREASURER - 270 ORG OBJECT EXPENSE TITLE 11452 5317 Professional Training/Education TOTAL 11452 TOTAL 11452 TOTAL Dept Request Approved by Mayor Approved by Council TOTAL 1,400 1,400 1,400 11452 5388 Tax Foreclosure Service 5320 ContractedServices Financial Consulting Serv¡ces 20 Hrs @ 70.00 Cost of Required Advertising General supplies Misc Copy Paper 10 Cases @ 40.00 lnk toner for fax machine 2 @25.00 toner for munis pr¡nter 2 @ 175.0O 5425 Checks/Forms A,/P and PYR checks 42 cases of pressure seal direct deposit forms@ $51.OO/case 50 cases pressure seal green checks @ $62.00 Frieght $13.6S/case Bank fees associated with cred¡t card machines located throughout the City Based on Prior Period Actual Costs(Smart Meters $5.75 per month + 3 per transaction) Bank Fees associated with credit card machines for Parking Meters estimated as follows: Off season $1 ,000 X 6 High Season $2,200 X 6 Unibank ACH Fees (15,000 x 25) Smart Meter Credit Card Fees 2000.00 per mont Treasurer's Association dues Eastern Mass Treasurer's Collector's Assoc¡ation MCTA 650 650 1,400 8,000 650 650 1,400 8,000 35,900 650 650 1,400 8,000 35,900 TOTAL 8,000 8,000 8,000 65 95 160 65 95 160 700 400 50 350 1,500 700 400 50 350 1,s00 700 400 50 350 1,500 2,',t42 3,1 00 1,258 2,'t42 3,1 00 1,258 2,142 3,100 1,258 TOTAL 6,500 6,500 6,500 11452 5709 Credit Card/EFT Fees 35,900 6,000 13,200 3,750 24,000 6,000 13,200 3,750 24,000 6,000 13,200 3,750 24,000 65 95 160 TOTAL 82,850 82,850 82,850 11452 5730 Dues and Subscriptions ---PAGE BREAK--- Treasurer - Long Term Debt Seryice This expenditure covers the cost of the principal and interest payments of the City's General Fund bonded debt. Short-term debt service and Water & Sewer Enterprise Fund debt service appear separately in the Treasurer's budget. In FYl4, the City's total Long-Term Debt Service is $5,943,518. This includes principal payments of $4,199,119 and interest payments of $1,744,399. The majority of bonding has been directed to finance School remodeling projects, with smaller amounts financing City Hall Renovations, the Police Department, and various capital improvement projects and equipment. In FY 1l the City $15,373,000 of long-term debt, the proceeds were used to retire $4,589,000 of governmental BANs, $5,389,000 of water BANs and $1,641,000 of sewer BANs outstanding. The remaining $3,754,000 of proceeds is allocated for $1,630,000 in governmental expenditures, $2,075,000 in water expenditures and $49,000 in sewer expenditures In FY 13 the City received a lump sum payment from the Massachusetts School Building Authority for $15,901,131 to take advantage of a refunding opportunity. The refinancing of bonds dated lll5l2003 for the Bowditch, Carlton and Bates Schools gave the city a total savings of over 2 million dollars over the next ten years. Per the Municipal Finance Oversight Board of the Commonwealth of Massachusetts the City in accordance with provisions of Chapter 44A of the General Laws is entitled to issue state qualified bonds from time to time in increments not to exceed sixty-two million twenty four thousand eight hundred fifty nine dollars ($62,024,859) Treasurer - Sho rt Term Debt Service This expenditure covers the cost of the City's Short-term borrowing, including principal and interest on any Bond Anticipation Notes, Tax Anticipation Notes, Revenue Anticipation Notes, Grant Anticipation Notes and State Aid Anticipation Note. In FYl3, the City bonded 51,795,677 as part of the $18,191,000 which incorporated the existing Blaney Street land improvements Note: A Bond Anticipation Note (BAN) is a short-term debt instrument used to generate cash for initial project costs and with the expectation that the debt will be replaced later by permanent bonding. Typically issued for a term of less than one year, BANs may be reissued for up to five years, provided principal repayment begins after two years (MGL Ch. 44 Sl7). Principal payments on school-related BANs may be deferred up to seven years if has an approved project on the Massachusetts School Building Authority (MSBA) priority list. BANs are full faith and credit obligations. ---PAGE BREAK--- Treasurer - North Shore Regional Voc A portion (30%) of the funding for the North Shore Regional Vocational comes from the State through Chapter 70 School Aid. The majority (10%) is made up by assessments from each of the 16 member communities in the school district. The amount of a communit¡l's assessment is determined by the size of its enrollment. As of February 2013, Salem had 150 students in the Regional system. There will be debt service interest payment FY14. Treasurer - Súaúe Assessnrenús (Cherry Sheeú) The State assess the municipalities for certain functions including Mass Teachers Retirement, Air Pollution Control, Mosquito Control, MBTA, Metropolitan Area Planning Council, RMV Non Renewal Surcharges, And tuition for Essex Aggie, School Choice Charger Schools and Special Ed. A complete description of each assessment can be found on the DOR website. Treasu rer - Contributory Retirement The Salem Contributory Retirement System includes employees of the City of Salem, the South Essex Sewer District, the SalemÆeverly Water Supply Board and the Salem Housing Authority. It provides pension and annuity payments to 670 retirees, and collects pension contributions from 876 active employees and l7 4 inactive or on leave members as of January I,2013. Treas u rer - N o n-Co ntri b utory Pensions As of February 14,2013, the City provides pension benefits for a limited group of seven non-contributory retirees. This includes five pension payments paid weekly and two pension payments paid Treasurer - Medicare The Medicare budget calculation is based on prior year number of employees and is adjusted for inflation. There is no indication that there will be enough of a change in the empioyment level for FY14, an adjustment was made in the Medicare budget as it has been underfunded in the past. Thus, FY14 is based on the average of prior year actual and the projected FY 13 actual plus Treasurer - Municipal Insurance The City's Liabilþ lnsurance is currently with Massachusetts Inter-local Insurance Association (MIIA). ---PAGE BREAK--- CITY OF SALEM - FY 2OI4 OPERATING BUDGET Expenditures Adopted Budget Adjusted Budget Y-T-D Expenses Department FY 2012 FY 2013 FY 2013 Fy 2013 Fy 2014 Mayor FY 2014 Council FY 2014 Debt 17102 17102 17 102 17 102 17t02 t7t02 17102 t7102 t] 102 17102 ttt02 17102 17 102 17102 17102 17t02 t7102 17 102 17 102 17t02 17102 17 102 t] t02 ttt02 17 102 t7 102 17102 17102 17102 17102 17102 17102 17r02 11t02 17102 612,000.00 805,000.00 435,000.00 85,000.00 465,000.00 75,000.00 95,000.00 30,000.00 345,000.00 293,000.00 80,000.00 60,000.00 80,000.00 100,000.00 617,300.00 32,000.00 40,700.00 0.00 0.00 0.00 5,860.00 15,400.00 23,350.00 12,240.00 540,100.00 291,328.76 39,655.00 27,675.00 27,800.00 55,561.26 16,707.50 233,118.76 33,750.00 12,150.00 203,858.50 0.00 840,000.00 455,000.00 90,000.00 460,000.00 75,000.00 95,000.00 30,000.00 345,000.00 0.00 80,000.00 60,000.00 80,000.00 90,000.00 639,000.00 31,000.00 0.00 81,244.00 154,854.00 30,000.00 0.00 11,400.00 20,350.00 0.00 509,913.00 215,016.00 36,468.00 10,350.00 25,250.00 52,331.00 15,688.00 215,869.00 32,150.00 10,250.00 19t,295.00 0.00 840,000.00 455,000.00 90,000.00 460,000.00 75,000.00 95,000.00 30,000.00 345,000.00 0.00 80,000.00 60,000.00 80,000.00 90,000.00 639,000.00 3 1,000.00 0.00 573.00 54.00 30,000.00 0.00 11,400.00 20,350.00 0.00 509,913.00 215,0t6.00 36,468.00 10,350.00 25,250.00 52,331.00 15,688.00 2 15,869.00 32,150.00 10,250.00 191,295.50 0.00 840,000.00 455,000.00 90,000.00 460,000.00 75,000.00 95,000.00 30,000.00 345,000.00 0.00 80,000.00 60,000.00 80,000.00 90,000.00 639,000.00 31,000.00 0.00 0.00 0.00 0.00 0.00 I 1,400.00 20,350.00 0.00 509,913.00 275,0t6.00 36,468.00 10,3 50.00 2s,250.00 52,331.00 15,688.00 215,869.00 32,150.00 10,250.00 19t,295.50 0.00 75,000.00 50,000.00 0.00 0.00 75,000.00 95,000.00 30,000.00 345,000.00 0.00 80,000.00 60,000.00 6 15,000.00 85,000.00 670,000.00 30,000.00 0.00 71,244.00 t34,854.00 30,000.00 0.00 7,800.00 17,650.00 0.00 39,143.00 27,690.00 0.00 0.00 21,500.00 41,582.00 14,188.00 200,344.00 15,97 5.00 7,225.00 168,155.00 0.00 75,000.00 50,000.00 0.00 0.00 75,000.00 95,000.00 30,000.00 345,000.00 0.00 80,000.00 60,000.00 6 r 5,000.00 85,000.00 670,000.00 30,000.00 0.00 11,244.00 134,854.00 30,000.00 0.00 7,800.00 17,650.00 0.00 39,143.00 27,690.00 0.00 0.00 21,500.00 47,582.00 14,188.00 200,344.00 15,915.00 1,225.00 168,155.00 0.00 75,000.00 50,000.00 0.00 0.00 75,000.00 95,000.00 30,000.00 345,000.00 0.00 80,000.00 60,000.00 615,000.00 85,000.00 670,000.00 30,000.00 0.00 11,244.00 134,854.00 30,000.00 0.00 7,800.00 17,650.00 0.00 39,143.00 21,690.00 0.00 0.00 21,500.00 47,582.00 14,188.00 200,344.00 15,975.00 7,225.00 168,155.00 Service-Expenses 5903 O8-SCHL PROJ REF-PzuN (00) 5908A O9-BOWDITCH SCHL-PRIN (03) 59088 lO-CARLTON SCHL-PRIN (03) 5908C l l-BATES SCHL-PRIN (03) 5908D 12-SCHL PROJ REF-PRIN (03) 5908E 13-PARKING GARAGE-PzuN (05) 5908F (05) 5908G l5-CARLTON-PRrN (0s) 5908H r6-HIGH SCHOOL-PRrN (07) 5910 O7-POLICE (00) 59r0A 17-POLTCE EQUrP-PRrN (07) 5918 l8-FERRY-PRrN(07) 5919A 1g-SCHL REMODEL-PRIN (10) 59198 2O-SCHL RENOV-PRrN (10) 5919C 21-BATES SCHL-PRrN (r0) s9l9D 22-GOLF PRIN (10) 59198 POOL PRrN (10) 5919F SALTONSTALL PRrN (2013) 5919G COLLINS PRIN (2013) s9l9H MCGRATH PRrN (2013) 5930 07-POLTCE REF-rNT (01) 59304 l7-POLTCE EQUrP-rNT (07) 5938 l8-FERRY-rNT (07) s943 O8-SCHL PROJ REF (00) 59484 09-BOWDITCH SCHL-rNT (03) s9488 10-CARLTON SCHL-INT (03) s948C 1I-BATES SCHL-rNT (03) 5948D l2-SCHL PROJ REF-INT (03) 5948E GARAGE-rNT (05) 5948F 5948G l5-CARLTON-rNT (05) s948H l6-HrGH SCHOOL-rNT (07) s948r lg-SCHL REMODEL-rNT (10) s948J 2O-SCHL RENOV-rNT (r0) 5948K 2I-BATES SCHL-rNT (10) ---PAGE BREAK--- CITY OF SALEM - FY 2OI4 OPERATING BUDGET Expenditures Adopted Budget Adjusted Budget Y-T-D Expenses Department FY 2012 FY 2013 Fy 2013 Fy 2013 Fy 2014 Mayor FY 2014 Council FY 2014 17102 t7102 17 102 t] 102 17102 17r02 17102 17102 r7102 11102 t7 102 11102 17102 Total 4,810.00 407.00 0.00 0.00 0.00 64,525.00 143,760.00 245,000.00 394,000.50 0.00 0.00 0.00 0.00 6,641,057.28 4,180.00 0.00 119,627.00 217,112.00 45,853.00 57 ,115.00 80,575.00 245,000.00 245,000.00 20,925.00 4s,000.00 221,000.00 106,671.00 6,456,546.00 4,180.00 0.00 s5,496.50 98,7 13 .00 45,853.00 57 ,17 5 .00 80,575.00 245,000.00 245,000.00 20,925.00 45,000.00 0.00 s0,033.00 5,754,908.00 4,180.00 0.00 51,047.34 92,780.45 19,458.54 57,175.00 80,575.00 245,000.00 245,000.00 20,925.00 45,000.00 0.00 49,662.35 5,687,134.18 3,120.00 0.00 1 1 8,263.00 214,867.00 45,038.00 49,975.00 73,300.00 235,000.00 240,000.00 19,515.00 45,000.00 217,500.00 112,832.00 4,387,820.00 3,120.00 0.00 I 1 8,263.00 214,861.00 45,03 9.00 49,915.00 73,300.00 235,000.00 240,000.00 19,57 5.00 45,000.00 217,500.00 112,832.00 4,387,820.00 3,120.00 0.00 1 18,263.00 214,867.00 45,039.00 49,975.00 73,300.00 23 5,000.00 240,000.00 19,575.00 45,000.00 217,500.00 112,832.00 4,387,820.00 s948L 22-GOLF CLUBHS-INT (10) 5948M POOL-rNT (10) s948N SALTONSTALL rNT (2013) 59480 INT (2013) 5948P MCGRATH INT (2013) s9494 CrP 2009-INT (l l) s9498 CIP 2010-rNT (l l) s949C CIP 2009-PRrN (12) 5949D CrP 2010-PRrN (12) 59498 CIP 2OI1 INT 5949F CIP 20I1-PRIN 5949G CIP 2012-PzuN 5949H CIP 2012-INT Debt Service-Expenses 270 7t0 artment Total 6,641,057.28 6,456,546.00 5,754,908.00 5,6g7,134.1g 4,3g7,920.00 4,3g7,g20.00 4,3g7,g20.00 ---PAGE BREAK--- TREASURER - Fixed Costs 270 ORG OBJECT TREASURER - Lonq Term Debt GF - 270 17102 TOTAL TOTAL PROPOSED FY 2014 DETAILED BUDGET REPORT EXPENSES EXPENSE TITLE DEBT SERVICE Debt Service Figures from Debt Schedule provided by First Southwest Deot Request Approved by Mavor 4,387,820 4,387,820 4.387.820 4.387.820 4,3ö1,öZU 4,3ö7,ö21) Approved by Council 4,387,820 4.387.820 4,3öt.8Zg ---PAGE BREAK--- CITY OF SALEM . FY 2OI4 OPERATING BUDGET Expenditures Adopted Budget Adjusted Budget Y-T-D Expenses Department FY 2012 Fy 2013 Fy 2013 Fy 2013 Fy 2014 Mayor FY 2014 Council FY 2014 Short Term Debt Int-Expense 17522 5270 LEASE PAYMENTS 17522 5304 PROF SERVICESiFEES 17522 5925 INTEREST ON BANS 17522 5926 INTEREST ON OTHER SHORT TERM 17522 5926A INTEREST ON OTHER-ENSATS 17522 5927 INTEREST ON LEASES Total Short Term Debt Int-Expense 0.00 t2,277.18 513.00 25,400.00 0.00 0.00 38,190.18 0.00 15,000.00 0.00 24,797.00 0.00 0.00 39,797.00 0.00 15,000.00 0.00 24,791.00 0.00 0.00 39,797.00 0.00 14,450.00 0.00 45,631.36 0.00 0.00 60,081.36 157,500.00 15,000.00 149,824.00 0.00 259,906.00 9,821.00 592,051.00 157,500.00 15,000.00 210,000.00 0.00 259,906.00 9,821.00 652,227.00 157,500.00 15,000.00 210,000.00 0.00 259,906.00 9,821.00 652,227.00 270 752 Department Total 38,190.18 39,797.00 39,797.00 60,0g1.36 592,051.00 652,227.00 652,227.00 ---PAGE BREAK--- FY 2014 DETAILED BUDGET REPORT EXPENSES TREASURER - Fixed Costs 270 5925 lnterest on BANS lnterest on Bans Additional money needed for CIP 2013, Salts, Coll¡ns, Bertram 5926 lnterest on Other Short Term Estimated lnterest for borrowing short term State Aid Revenue Anticipation Notes TOTAL 17522 59264 lnterest on BAN ENSATS Estimated Capital Lease Payment for 2014 leases with Century Approved Dy Approved by ORG OBJECT EXPENSE TITLE Dept Request Mayor Council TREASURER - Short Term Debt GF -270 17522 5270 Lease Payments Lease Payments 157,500 157,500 157,500 TOTAL 157,500 157,500 157,500 17522 5304 Professional Fees Fees for First Southwest and Legal Services 15,000 1 5,000 15,000 TOTAL 15,000 15,000 15,000 17522 TOTAL 17522 149,824 149,824 259,906 9,821 149,824 60,176 21 0,000 259,906 9,821 149,824 60,r 76 210,000 259,906 9,821 TOTAL 259,906 259,906 259,906 17522 5927 Capital Lease Payments TOTAL 821 821 ---PAGE BREAK--- CITY OF SALEM - FY 2OI4 OPERATING BUDGET Expenditures Adopted Budget Adjusted Budget Y-T-D Expenses Department FY 2012 FY 2013 Fy 2013 Fy 2013 Fy 2014 Mayor FY 2014 Council FY 2014 School Assessments 18202 5641 NSRS ASSESSMENT Total SchoolAssessments r,574,316.00 1,574,316.00 1,603,586.00 1,603,586.00 1,603,586.00 1,603,586.00 1,583,485.00 1,583,485.00 1,900,409.00 1,900,409.00 1,945,039.00 1,945,039.00 I,945,039.00 1,945,039.00 270 820 Department Total 1,574,316.00 1,603,586.00 1,603,586.00 1,5g3,4g5.00 1,900,409.00 1,945,039.00 1,945,039.00 ---PAGE BREAK--- FY 2014 DETAILED BUDGET REPORT EXPENSES TREASURER - Fixed Costs 270 ORG OBJECT EXPENSE TITLE TREASURER - SCHOOL ASSESSMENT - 270 Assessment North Shore Regional Vocational School Assessment As of 0224/13 - Before State Legislature Approval Enrollment increased from 113 to 134 with a per capita of approximately $17,000 per student resulting in over a $300,000 ¡ncrease Additional funds required due to CH70 cuts TOTAL TOTAL PROPOSED Dept Request 1,900,409 1,900,409 1.900.409 Approved by Mayor Approved by Council 18202 5641 1,900,409 1,900,409 44,630 1.945.039 1.945.039 44,630 1.945.039 1.945.039 ---PAGE BREAK--- CITY OF SALEM - FY 2OI4 OPERATII{G BUDGET Expenditures Adopted Budget Adjusted Budget Y-T-D Expenses Department FY 2012 FY 2013 FY 2013 Fy 2013 Fy 2014 Mayor FY 2014 Council FY 2014 State Assessments-Expenses 18302 5381 DEP FEES 18302 5622 ESSEX AGRICULTURAL TUITION 18302 5630 MBTA T8302 5631 SPECIAL EDUCATION I8302 5635 RETIRED MLIN TEACHERS 18302 5637 AIR POLLUTION CONTR 18302 5638 MET AREA PLANNING CO 18302 5640 RMV NONRENEWAL SUR 18302 5643 SCHOOL CHOICE 18302 5644 CHARTERSCHOOLS 18302 s646 NE MASS MOSQUTTO CON Total StateAssessments-Expenses 2r,7 55.00 368,156.00 830,711.00 37,095.00 1,931,725.00 10,633.00 12,585.00 119,760.00 188,290.00 2,771,312.00 38,760.00 6,390,908.00 0.00 261,976.00 873,554.00 36,923.00 0.00 10,940.00 13,023.00 179,760.00 176,441.00 3,917,437.00 40,661.00 5,510,721.00 0.00 261,976.00 873,554.00 36,923.00 0.00 10,940.00 13,023.00 t79,160.00 176,441.00 3,917,437.00 40,667.00 5,510,721.00 0.00 196,482.00 655,166.00 0.00 0.00 8,205.00 9,768.00 141,000.00 182,170.00 2,555,639.00 30,530.00 3,778,960.00 0.00 200,850.00 883,027.00 4,182.00 0.00 1 1, r 14.00 13,349.00 188,000.00 213,255.00 4,t01 ,235.00 44,155.00 5,725,167.00 0.00 200,850.00 883,027.00 4,182.00 0.00 I1,114.00 13,349.00 188,000.00 273,255.00 4,026,516.00 44,t55.00 5,644,448.00 0.00 200,850.00 883,027.00 4,182.00 0.00 11,114.00 13,349.00 188,000.00 273,255.00 4,026,516.00 44,155.00 5,644,448.00 270 830 Department Total 6,390,908.00 5,510,721.00 5,510,72r.00 3,77g,960.00 5,725,167.00 5,644,449.00 5,644,44g.00 ---PAGE BREAK--- FY 2014 DETAILED BUDGET REPORT EXPENSES TREASURER - Fixed Costs 270 ORG OBJECT EXPENSE TITLE TREASURER. STATE ASSESSMENTS - 270 State Assessments State Assessment amounts are derived from Massachusetts Department of Revenue Cherry Sheet Assessment Report. TOTAL TOTAL PROPOSED 18302 Dept Request 5,725,167 5,725,167 Approved by Mayor 5,644,448 5.W.448 Approved by Council 5,644,448 5,644,448 ---PAGE BREAK--- CITY OF SALEM . FY 2OI4 OPERATING BUDGBT Expenditures Adopted Budget Adjusted Budget Y-T-D Expenses Department FY 2012 FY 2013 Fy 2013 Fy 2013 Fy 2014 Mayor FY 2014 Council FY 2014 Contrib Retirement - Personnel 19101 sr78 PENSTON ASSES (CONTR Total Contrib Retirement - Personnel 8,113,799.81 8,773,799.81 9,167 ,161 .00 9,167,161.00 9,167 ,16l .00 9,167,161.00 9,203,876.66 9,203,876.66 9,686,094.00 9,686,094.00 9,526,094.00 9,526,094.00 9,526,094.00 9,526,094.00 270 910 Department Total 8,773,799.81 9,167,161.00 9,167,16r.00 9,203,976.66 9,6g6,094.00 9,526,094.00 9,526,094.00 ---PAGE BREAK--- FY 2014 DETAILED BUDGET REPORT EXPENSES TREASURER - Fixed Costs 270 ORG OBJECT EXPENSE TITLE TREASURER - CONTRIBUTORY RETIREMENT - 270 5178 Contributory Retirement City Contributory Retirement Less other entity re¡mbursements (CDBG/NSWI B/Other G rants) TOTAL TOTAL PROPOSED Dept Request 9,686,094 9.686.094 9.686.094 Approveo Þy Mayor Approveo Dy Council 1910'l 9,686,094 (1 60,000) 9.526.094 9.526.094 9,686,094 (160,000) 9.526.094 9.526.094 ---PAGE BREAK--- CITY OF SALEM - FY 2OI4 OPERATING BUDGET Expenditures Adopted Budget Adjusted Budget Y-T-D Expenses Department FY 2012 FY 2013 FY 2013 FY 2013 Fy 2014 Mayor FY 2014 Council FY 2014 Non-Contrib Retire-Personnel 19II1 5176 PENSIONS-NON CONTzuB Total Non-Contrib Retire-Personnel 69,474.33 69,474.33 72,650.00 72,650.00 72,650.00 72,650.00 62,916.40 62,976.40 14,408.00 74,408.00 74,408.00 74,408.00 74,408.00 74,408.00 270 911 D Total 69,474.33 72,650.00 72,650.00 62,976.40 74,409.00 74,408.00 74,408.00 ---PAGE BREAK--- FY 2014 DETAILED BUDGET REPORT EXPENSES TREASURER - Fixed Costs 270 ORG OBJECT EXPENSE TITLE TREASURER - NON-CONTRIBUTORY RETIREMENT . 270 Pension Non-Contributory City Non-Contributory Retirement based on current payments annualized $793.56 X 12 months Weekly $1 ,247.79 X 52 weeks Less COLA Reimbursements from state TOTAL IOTAL PROPOSED Dept Request Approveo Þy Mayor Approved by Council 19111 51 76 9,523 64,885 74,408 74.408 9,523 64,885 74,408 74.408 9,523 64,885 74.408 74.408 ---PAGE BREAK--- CITY OF SALEM . FY 2OI4 OPERATING BUDGET Expenditures Adopted Budget Adjusted Budget Y-T-D Expenses Department FY 2012 Fy 2013 Fy 2013 Fy 2013 Fy 2014 Mayor FY 2014 Council FY 2014 Medicare-Personnel I9I9I 5177 MEDICARE Total Medicare-Personnel 852,215.08 852,215.08 191,239.00 797,239.00 797,239.00 797,239.00 850,929.99 850,929.99 832,974.00 832,974.00 832,974.00 832,974.00 832,974.00 832,974.00 270 919 D Total 852,215.08 797,239.00 797,239.00 850,929.99 832,974.00 832,974.00 832,974.00 ---PAGE BREAK--- FY 2014 DETAILED BUDGET REPORT EXPENSES ORG OBJECT TREASURER - MEDICARE - 270 TREASURER - Fixed Costs 270 19191 5177 TOTAL PROPOSED Approvecl by Approved by 832,974 832,974 832,974 832.974 The medicare budget is based on the number of employees and there is no indication that there will be enough of a change in the employment level for FY 14. Thus FY 14 is funded based on the average ofthe prior year actual plus 1% and the projected FY 13 actual. 832.974 832,974 ---PAGE BREAK--- CITY OF SALEM - FY 2OI4 OPERATING BUDGET Expenditures Adopted Budget Adjusted Budget Y-T-D Expenses Department FY 2012 FY 2013 Fy 2013 Fy 2013 Fy 2014 Mayor FY 2014 Council FY 2014 Municipal Insurance-Expense 19452 5740 INSURANCE PREMIUMS 19452 5140A Insurance Deductibles Total Municipallnsurance-Expense 244,813.82 4,87 5.00 249,688.82 297,500.00 5,000.00 302,500.00 258,184.00 5,000.00 263,184.00 166,444.50 5,000.00 171,444.50 312,375.00 5,000.00 317,375.00 312,375.00 5,000.00 317,375.00 312,375.00 5,000.00 317,375.00 270 945 Department Total 249,688.82 302,500.00 263,184.00 171,444.50 317,375.00 317,375.00 317,375.00 ---PAGE BREAK--- FY 2014 DETAILED BUDGET REPORT EXPENSES TREASURER - Fixed Costs 270 19452 5740 Municipallnsurance Annual municipal insurance costs 5% increase over FY 13 TOTAL 19191 5740A lnsurance Deductibles Deductibles - estimated Level Funded TOTAL TOTÂL PROPOSED Approved by Approved by ORG OBJECT EXP TREASURER - MUNICIPAL INSURANCE - 270 312,375 3't2.375 5,000 5.000 317.375 312,375 312.375 5,000 5,000 317.375 312.375 312.375 5,000 5.000 317.375