Loading...
HomeMy WebLinkAboutOrdinance 26724-02-2024Ordinance No. 26724-02•-2024 AN ORDINANCE ADJUSTING ESTIMATED RECEIPTS AND APPROPRIATIONS IN THE GENERAL FUND BY (I) DECREASING THE FIRE DEPARTMENT OPERATING BUDGET IN THE AMOUNT OF $39,340.00 AND THE HUMAN RESOURCES OPERATING BUDGET IN THE AMOUNT OF $109,885.00 AND (II) INCREASING THE TRANSFERS TO IT CAPITAL IN THE AMOUNT OF $149,225.00 FOR THE ERP IT PROGRAMMABLE PROJECT (CITY PROJECT NO.- P00093); PROVIDING FOR A SEVERABILITY CLAUSE; MAKING THIS ORDINANCE CUMULATIVE OF PRIOR ORDINANCES; REPEALING ALL ORDINANCES IN CONFLICT HEREWITH; AND PROVIDING AN EFFECTIVE DATE. BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF FORT WORTH, TEXAS: SECTION 1. That the budget of the City of Fort Worth for Fiscal Year 2023-2024, as enacted by Ordinance 26453-09- 2023, as amended, is hereby further amended to make the following adjustments to the estimated receipts and appropriations in the General Fund: decreasing the Fire Department operating budget in the amount of $39,340.00 and decreasing the Human Resources Department operating budget in the amount of $109,885.00 and increasing the Transfers to IT Capital in the amount of $149,225.00 for the ERP IT Programmable Project (City Project No. P00093). SECTION 2. That should any portion, section or part of a section of this ordinance be declared invalid, inoperative or void for any reason by a court of competent jurisdiction, such decision, opinion or judgment shall in no way impair the remaining portions, sections, or parts of sections of this ordinance, which said remaining provisions shall be and remain in full force and effect. SECTION 3. That this ordinance shall be cumulative of Ordinance 26453-09-2023 and all other ordinances and appropriations amending the same except in those instances where the provisions of this ordinance are in direct conflict with such other ordinances and appropriations, in which instance said conflicting provisions of said prior ordinances and appropriations are hereby expressly repealed. SECTION 4. This ordinance shall take effect upon adoption. APPROVED AS TO FORM AND LEGALITY: -�)P- Mrs - Denis C. McElroy Assistant City Attorney ADOPTED AND EFFECTIVE: February 27, 2024 CITY SECRETARY ?,... f Jannette S. Goodall City Secretary City of Fort Worth, Texas Mayor and Council Communication DATE: 02/27/24 M&C FILE NUMBER: M&C 24-0150 LOG NAME: 13PUBLIC SAFETY PAYROLL PROJ PHASEIII FUNDING SUBJECT (ALL) Adopt Appropriation Ordinances Authorizing the Reallocation & Transfer of Available Funds from within the Fiscal Year 2024 Adopted Budget for the Purpose of Funding Phase III of the Public Safety Payroll Solution Project; Amend the Fiscal Year 2024 Adopted Budget and Fiscal Years 2024-2028 Capital Improvement Program It is recommended that City Council: 1. Adopt the attached appropriation ordinance adjusting appropriations in the General Fund by (i) decreasing the Fire Department operating budget in the amount of $39,340.00 and the Human Resources Department operating budget in the amount of $109,885.00 and increasing the Transfers to IT Capital by $149,225.00 for the ERP IT programmable project; 2. Adopt the attached appropriation ordinance adjusting appropriations in the Information Technology Systems Fund by decreasing the IT Solutions Department budget in the amount of $40,640.00 and increasing the Transfer to IT Capital by the same amount for the ERP IT programmable project within the ITS Capital Fund; 3. Adopt the attached appropriation ordinance adjusting estimated receipts and appropriations in the ITS Capital Fund by decreasing the ERP IT programmable project (City Project No. P00038) in the amount of $90,081.00 and increasing the Technology Infrastructure -IT programmable project (City Project No. P00093) by the same amount; 4. Adopt the attached appropriation ordinance increasing estimated receipts and appropriations in the ERP IT programmable project (City Project No. P00093) in the ITS Capital Fund in the amount of $189,865.00, transferred from the General Fund and Information Technology Systems Fund ; and 5. Amend the Fiscal Year 2024 Adopted Budget and Fiscal Years 2024-2028 Capital Improvement Program. DISCUSSION: The purpose of this Mayor and Council Communication (M&C) is to adopt appropriation ordinances authorizing the transfer and reallocation of available funds from Within the fiscal year 2024 adopted budget for the purpose of funding phase III of the Public Safety Payroll Solution project (City Project No. 103603) as a subproject under ERP IT programmable project (City Project No. P00093). At the February 6, 2024 City Council Work Session, staff presented an update on efforts to improve the payroll process with an emphasis on improving the process relating to public safety pay. In that presentation, staff laid out a phased approach to the Public Safety Payroll Solution project and indicated a forthcoming M&C would be required to approve the re -allocation (transfer) of funds totaling $365,000.00, from participating department budgets, to extend the project into the testing phase (phase Ill). This M&C provides the actions necessary to reallocate the funding as described in the presentation, a copy of which is attached to this M&C. The table below summarizes the available funding source by department. The amount associated with the Financial Management Services Department is already available within the ERP IT programmable project in the ITS Capital Fund and does not require Council action to reallocate to the Public Safety Payroll Solution project. Department 'Alnoririf, Funding Source Police $ 90,081.00 Utilize surplus funds set aside for CCPD funded CAD licenses from within the IT capital program Fire $ 39,340.00 Re -allocation of FY24 operating budget funds Human Resources $ 109,885.00 Deferment of employee engagement survey in the FY24 operating budget Financial Management Services $ 85,054.00 Re -prioritization of FY24 approved IT capital program funds set aside for expanding the inventory module Information Technology Solutions $ 40,640.00 Re -allocation of FY24 operating budget funds set aside for consulting services Total $,3650000.00 ` Funding is budgeted and available in the Other Contractual Services and Consultant & Other Professional Services accounts within the General Fund for the Fire & Human Resources Departments, in the Info Technology Systems Fund for the IT Solutions Department and in the Technology Infrastructure -IT and ERP IT programmable projects for the purpose of funding the FY21 Public Safety Payroll Solution project. A Form 1295 is not required because: This M&C does not request approval of a contract with a business entity. FISCAL INFORMATION / CERTIFICATION: Thr Director of Finance certifies that funds are currently available in the General Fund, Info Technology Systems Fund and in the Technology Infrastructure -IT and ERP IT programmable projects within the ITS Capital Fund and upon approval of the above recommendations and adoption of the attached appropriation ordinances, funds will be available in the ITS Captial Fund for the FY21 Public Safety Payroll Sol project. Prior to any expenditure being incurred, the IT Solutions Department has the responsibility to validate the availability of funds. Submitted for City Manager's Office by Reginald Zeno 8517 Originating Business Unit Head: Reginald Zeno 8517 Additional Information Contact: Anthony Rousseau 8338 Expedited -�rove'merts X 3 Ipp date al �m�` — wash�r9�O�- ., pia\erne_. _ to anu , ice ovoe a�rd� ° �ac3ef parr ��ty o�,tea Pay} oit uoo rayroii racts FY2024 pay�ro[I `budget: (salaries and; b.enefits);is $94.5,3'[2;000,of- $2.6 billion.. City budget. Vol i.ce and: F°ire re,pres a nt S % �. �of Gene ra"t-Fun-d< <bu,d�g'et City has about 7,,150 actisve ne:mpl`o.ye.essvPubllc safety re�presents.'5:7%. �w General: Fund employees In FY2;023;, C:it rocessed''184;0;00 payr611-transa�cti.ons Y` p , e more ' tend to b � C° a�ments ,mpppppr � aidFire Pa*l deP obi � chose°�6txiev wry do?bra tes � . h�ghec Ca - OTv � ,�°u Inc OT ,�eert' �tat\o�, PT �xa\ PTOper su . ape \,O,\j° b vivtmevlts ocos acceu ro�� pC pax ar �Ovj �,��p �,pa� raco e ert a �ce� ,ice ex tevrs �rt� ert S da c�� sus p���'►a c0aX �a� e�,•, ��me o�ut�orrs �F�nar pesO ., c oho ' To\\ pC u oar -�ec�r pM Alliovro tio\JxrcNa\ ert� �' and app e ��� eep�r�l �rQ\ sty d , p Me-� Cole, c°r' • P►�� �' u��n�t� eat, co � ached apager� POPP,- `` ,bask F ore oavr naEo ,���e e�nte�koes a,, qe5ke anc:ka\ ees desoUr0 S©w�k°f\s toy ��" a1 �ud�t re . . . . Po` e eo � f africc� ers ��Te h Poll �atlon Fob Wo��* aoG Ass°ciatiolter�at+opal � LoC81440i mJanuary2024 of Fire Fighters 10 06to join teapays!,TasK Why was this Project Needed • Resolve repeated challenges associated with Fire and Police payroll processing • Improve time and absence tracking/visibility • optimize payroll time calculations for Fire and Police personnel (civil service and civilian) • Reduce or eliminate payroll errors, including overpayments and underpayments to employees • Rectify inconsistent application of policies • Ensure contract compliance with labor agreements Public Safety Payroll Project Goals Accu'ra.tle and effi,cion tprocessing.' ft- "00,ugh automatic n Simp, e,,, easy; prreadl pay advices, m", .P,I,,o, ye e. ,accountability, kl proved end -.user ex,perfence �Strea; mvllnedi butiness, proce88es flocs d co rt's 0 J►se . V S M �. ���'' see N Identify and document payroll process Align process to policy Align technology to process Identify manual processes and opportunities to automate Question current practices and mitigate Project Phased Approach Integrate PeopleSoft and UKG business processes Configure improvements identified in analysis phase Reduce complexity Question current practices and mitigate — change management Drive continuous improvement (ask why!) Concurrent with FY25 budget development Completed by July 2024 Ensure solution meets business needs & project goals Improved shift scheduling Automated pay type categorization Reduction of payroll related errors due to complexity Continue change management, Training, and Go Live Readiness 9 hia Payroll Project History: Rs'and M&Cs -,,,11R IR 10360 January 28, 2020 Payroll Task Force Update I 21-10625 August 3, 2021 Payroll Process Update .t . l September 28, I 21-10680 2021111 Public"Safety'Payroll Solution 'Recommendation a M&C 21- September 28, Authorize initial funding of $2,109,400 to implement the Public Safety:Payroll Solution 0731 2021 project - UKG system 'M&C 21- September 28, Authorize Coop Agreement w/:Immix Technology to .purchase and implement the Public 0732 2021 Safety Payroll Solution,project -'.UKG system M&C 21- September 28, Authorize Coop Agreement and spend authority for Staff Augmentation Services for lT .0733 2021 Solutions (a• portion of which to support the Public Safety Payroll Solution project - UKG system implementation) M&C 21- September 28, Authorize Agreement and spend authority for temporary staffing (a portion of which to 0734 2021 --[support the Public Safety Payroll Solution project - -UKG system implementation) I 23-011 January 24, 2023 'Update on Police and Fire Payroll Improvements Payroll Improvements To Date Pay advice re-design/simplification • Improved coordination and communication Reduction in payroll errors • Developing strategies to handle system workarounds • Police Department rookie officer transition • Improved K9 scheduling and processing • Significant reduction in hours associated with the biweekly processing of payroll 11 rah -besting � uhCt�O F ebrua'�1 Phase 1�� `re Depa'�r�'ent � 4l eXt base 0090 Stem buy\d JOT �6?41 \nto2�� ed � o �om'P�e�'e epart'rr�ent � esc for 5 m0 a�cu Lions as exp . JeVIdOT 4a d P oUc a Dest�n9 a stproCessing PaY 2 funGt�on system Gt�a` ,S to confirm 12 + dget prolect tlJusi� date d PayrO pave rJ re ao n �,�anoeMo� fun ded from st of rn being ongoing o0 extend prod dogs not;nGlud� ,11gote$" ed cost to budget total project Summary of Upcoming Council Actions • Actions to be taken by City Council: -/February 27: M&C approving the reallocation of funds ($365,000) from participating department budgets to extend the project into testing. August 6: City staff to bring forward recommendation on the next phase of the project ✓August TBD: City Manager presents recommended FY2025 budget to include Phase IV of this project as appropriate 14 Questions? . m P§ J ,