HomeMy WebLinkAboutOrdinance 26726-02-2024 (2)Ordinance No. 26726-02-2024
AN ORDINANCE ADJUSTING ESTIMATED RECEIPTS AND
APPROPRIATIONS IN THE ITS CAPITAL FUND I N THE AMOUNT
OF $90,081..00, BY DECREASING ESTIMATED RECEIPTS AND
APPROPRIATIONS IN THE TECHNOLOGY INFRASTRUCTURE -IT
PROGRAMMABLE PROJECT (CITY PROTECT NO. P00038) AND
INCREASING ESTIMATED RECEIPTS AND APPROPRIATIONS IN THE
ERP IT PROGRAMMABLE PROJECT (CITY PROJECT NO. P00093) BY
THE SAME AMOUNT; 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 ITS Capital Fund decreasing the Technology Infrastructure -IT Programmable project
(City Project No. P00038) in the amount of $90,081.00 and increasing estimated receipts and appropriations
in the ERP IT Programmable project (City Project No. P00093) by the same amount.
SECTION 2.
That should any portion, section or part of 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:
Denis C. McElroy
Assistant City Attorney
ADOPTED AND EFFECTIVE: February 27, 2024
CITY SECRETARY
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 M of the Public Safety Payroll Solution Project; Amend the Fiscal Year 2024 Adopted Budget and Fiscal Years 2024-2028 Capital Improvement
Program
RECOMMENDATION:
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.
DISCUSS)QN:
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 III). 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
Amount
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,
$ 365,000.00
Funding is budgeted and available in the Other Contractual Services and Consultant & Other Professional Services accounts within the General Fund far the Fire &
Human Resources Departments, in the Info Technology Systems Fund far the IT Solutions Department and in the Technology Infrastructure -IT and ERP IT
programmable projects for the purpose of funding the FY2i 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.
FJSCAL INFORMATION / CERTIFICATION:
The 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
FT 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_bw Reginald Zeno 8517
Originating BM ' ess U i ad: Reginald Zeno 8517
AddMonailnformatign Contapt Anthony Rousseau 8338
Expedited
rOVemerts 09date
_.,�.
XX XV" v
p aNj T O
_ � va\erie was0ri3t0 ^
�ra"ld°a�a WON�
I Po`� �Co
xt � 4
a� 0 2
e,�rU
Payroll Facts
. ......
FY2024 payroll budget (s,alaries and benefits) is,$945,131210007,or 37% of
$2.6 billion City budget.
9% Of General Fund5budget
Police and Fire rep.
resent 6 e,
.. .............
cithas about 7,150, active employees, Pubtic safety repre. sents 57% of
y
General Fund. -employees
payrotl transactions
-In FY20237 c,jty processed 184,000
e more
�dtob
Xs tome�ts?
and ��vf o JVOX
ec de
wppprp
part
do POV%cerhose o . �.
why ,eX tha
co� _..h�gheC Cafes
NJ aft I(N IV e&TOe Cow
• 010 ,five
F ���7u c C 4�� t\oC'►
aTge o� p�►� b0V a c reV
e6"(3N PTO
fee
3
menu
Depa�
�ess�ng��ount�n9
ay�o\\ pC��o`� taX and S
P vowed �n Paxa\, Pay ee vecoTd
is �n es; fi n emP�oy
en c Ge, s
m
as Ma eval groe es t�rc�e a�`out n a payrO�� Sys�e ocess
JNu'�a� Res �eChno�ogy 5 ayro\1 p1
J�nf�rmat�on ode �n 'P
�mehts P\2►ya a appco�a\
. pal CAId'ePg t�me,Keepx�ost cortco1
J Shed avagem
✓B\d9et m
4
12
`, ,bask VoTce
C
IS O, Vxce
ow -Aver
eCnen '
.�t� an
. F `nanC�a auroes o�ut�°ns
an �Vecbvxdes o\og'� 5
for�a��an
. 1n
FW�ab
ire lice officers
R
• ,forth Po ociatiorl
• Fob y�,tion .onat Ass
Assoc 1nternat�
oea� �q�0x ter�� .� ��n�a� 2��4
. j, !re high !task Force �
of f ..n the Pavr°t
*+nyited to joi
5
my
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
0
pui3lic Safe
pa
,roll Project
&�Joos
osed C'Ovl
EXamp`es
�► PTOP Re'
`$r '� ties k,oVk
Project Phased Approach
Identify and document Integrate PeopleSoft and Concurrent with FY25 Improved shift scheduling
payroll process UKG business processes budget development
Align process to policy
Align technology to
process
Identify manual processes
and opportunities to
automate
Question current practices
and mitigate
Configure improvements
identified in analysis phase
Reduce complexity
Question current practices
and mitigate — change
management
Drive continuous
improvement (ask why!)
Completed by July 2024
Ensure solution meets
business needs & project
goals
Automated pay type
categorization
Reduction of payroll
related errors due to
complexity
Continue change
management, Training,
and Go Live Readiness
Payroll Project History: IRs and M&Cs �
IR 10360 January 28, 2020 r� Payroll Task Force Update
ID 7.1-1r1r-')C " Arrarrc+I I )1 D-n\irnll Drnrocc I InAnIFn
11\ Li iVVS�.J t� I--1VbM..IL wJ, �.VLi � 4 Url V11 1 1 V4.�4.J.T V�r./4AU LL
- - -- + September 28 �� - -- - - -- - - - -- -- - - -
1 R 21-10680 it 2021 f Public Safety Payroll Solution Recommendation
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
Authorize Coop Agreement and spend authority for Staff Augmentation Services for IT
M&C 21- September 28, Solutions (a portion of ,which to support the Public Safety Payroll Solution project - UKG
0733 2021 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 .irnplernentation),
I 23-011 January 24, 2023 Update on Police and Fire Payroll Improvements
r ay s v» 1111 pr uvernents i o Vate
• Pay advice re-designlsimplification
• 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
a� Te
Stir9
' g 111— FunCt�� a�me�tFebruary
Phan Fire pep q.
NeXt phase System builMa��h Zp24) the ��nt� JU,e POD ed
ndor to cOo p ekpepa'�me�� � yes for 5 y°a Cu►at�ons as
Z02A� and P a� testm9 a� ro�ess�ng p
'�UnCt10'� stem is p
\nitGoa,15 to �on�irm SY
12
PPPP,PP-
roll P�'°ject Budget
updated Pay pr`verlJustif
— ,., ant
0Ct u ets
ota1 PCOI ental budg
evlsed T: atm
. . n resources within deP
of maintena,CejVicenses.
ed from eX�stt 9
fund oing ost
ect is being ong c
*Notes' d cost to extend t does not include
1 _ estimate total Protect bu 5
2 - vIevised
Summary of Upcoming Council Actions
• Actions to be taken by City Council:
✓February 27:
M&C approving the
reallocation of funds
($365,000)
participating
department budgets
to extend the project
into testing,
from
h6o
✓Au ust 6: City staff to bring forward recommendation on the next phase
of the project
✓August TBQ: City Manager presents recommended FY2025 budget to
include Phase IV of this project as appropriate
14