HomeMy WebLinkAboutIR 9349 INFORMAL REPORT TO CITY COUNCIL MEMBERS No. 9349
TEy{O To the Mayor and Members of the City Council January 25, 2011
Page 1 of 3
a
• SUBJECT: ENTERPRISE RESOURCE PLANNING (ERP) PROJECT - PHASE I
UPDATE
The purpose of this Informal Report is to provide an update on the current status of payroll
performance and corrections.
Pay Correction Checks Paid Citywide: The chart and table below depict the number of pay
correction checks issued.
Paycheck Correction Checks Paid Citywide(as of January 24,2011 at 10:00am)
"E'-Ponce '*'"Fire '-A-,WaterwW �Tra sporiation Public Works
"20 —
98
Y0 83
71
57 54 56
40
1
2
2C D
14
13
8 SW6
0
Oct 2Ah Nov 12t` Nov 241h Dec 70th Dec 24th Jan 71h Jan 21st
Notes:The number in Police increased as expected as the backlog is being worked;the number in Fire increased primarily due to Holiday
inquiries/corrections.Also note that the low numbers of correction checks for PP2(Jan 21st)is in part because it is only a few days after the pay
date.
Other City Departments Not Shown Above
Oct 29th Nov 12th Nov 24th Dec 10th Dec 24th Jan 71th Jan 21st
Parks and Community Services 10 6 3 7 4 10
Municipal Court 1 6 3 5 4 7 2
Code Compliance 4 2 3 3 1 1 1
City Manager 0 0 1 7 0 0
Planning and Development 3 1 1 2 1 3 4
City Secretary 2 01 0 1 0 0
Equipment Services 2 0 1 0 2 0
Financial Management Services 0 0 2 1 0 2
Housing and Economic Develop 1 1 1 0 2 0 1
Library 2 1 0 0 0 2
Public Events 3 0 0 0 0 0
Information Technology 0 01 1 1 01 1
Community Relations1 0 0 0 0 0
Human Resources 1 01 0 0 11 1
Internal Audit 0 01 0 0 11 1
ISSUED BY THE CITY MANAGER FORT WORTH, TEXAS
INFORMAL REPORT TO CITY COUNCIL MEMBERS No. 9349
11TEex
To the Mayor and Members of the City Council January 25, 2011
Page2of3
SUBJECT: ENTERPRISE RESOURCE PLANNING (ERP) PROJECT - PHASE 1
I UPDATE
Analysis of Dollar Values of Corrections: The following table provides a breakdown of the
correction checks by dollar categories for each pay period.
Pay Period
Check Amount Oct 29th Nov 12th Nov 24th Dec 10th Dec 24th Jan 7th Jan 21 at Total
less than$50 32 6 0 14 15 16 4 83
between$50 and$100 22 9 2 26 13 26 14 98
between$100 and$250 54 39 37 47 45 67 7 289
between$250 and$500 22 21 22 44 48 69 5 226
between$500 and$750 5 11 6 151 7 18 0 62
between$750 and$1000 6 5 2 6 6 7 2 32
between$1000 and$1500 3 3 5 5 5 5 1 26
between$1500 and$2000 2 0 4 6 2 2 1 16
between$2000 and$2500 1 21 0 0 2 01 1 0 5
greater than$2500 0 0 4 2 0 0 01
6
Police Paycheck Inquiries: The following table tracks the number of paycheck inquiries
submitted to the Central Payroll Processing Team (CPPT) in Police. These inquiries are
researched by the task force of CPPT and ERP Support Team members to determine the
appropriate resolution. The resolutions of the inquiries can be payment of a shortage, reduction
of subsequent check due to overage, adjustments to leave balance, and/or confirmation that
policies enforced by the system are functioning properly and the paycheck is correct.
29-Oct- 12-Nov- 24-Nov- 10-Dec- 24-Dec- 7-Jan- 21-Jan- Total
10 10 10 10 10 11 11
PP22 PP23 PP24 PP25 PP26 PP01 PP02
Total inquiries rcvd by CPPT 238 266 168 252 163 164 8'• 1255
Total inquiries researched completed -235 -264 -164 -249 -112 -96 -6 -1126
Total Remaining to be researched 1 • 2• 4 3 51 68 0 129
PD reported additional inquiries since the last report
Please note that the low numbers of correction checks for PP2(Jan 21st)is in part because it is just a few days after the pay date.
ISSUED BY THE CITY MANAGER FORT WORTH, TEXAS
INFORMAL REPORT TO CITY COUNCIL MEMBERS No. 9349
To the Mayor and Members of the City Council January 25, 2011
d"'"T`•t• Page 3 of 3
SUBJECT: ENTERPRISE RESOURCE PLANNING (ERP) PROJECT - PHASE 1
UPDATE
Update on Deployment of Resources to Assist Police: On January 4, 2011, City Council
approved the addition of contract resources for support of Police, implemented as follows:
• Continued the support of three consultants provided prior to support Police payroll
correction inquiries and verification.
• Four additional time entry resources deployed on January 12th at ERP to address volume
of Police time entry.
The next IR update will be provided to Council on February 1, 2011.
If you have any questions, please contact Pete Anderson, Director, IT Solutions Department at
817-392-8781.
Tom Higg*
Interim City Manager
ISSUED BY THE CITY MANAGER FORT WORTH, TEXAS