HomeMy WebLinkAboutIR 9350INFORMAL REPORT TO CITY COUNCIL MEMBERS No. 9350
To the Mayor and Members of the City Council February 8, 2011
cdv"`�e
Page 1 of 3
WX SUBJECT: ENTERPRISE RESOURCE PLANNING (ERP) PROJECT - PHASE I
I UPDATE
The purpose of this Informal Report is to provide an update on the status of payroll performance
and corrections as of January 31, 2011 at 11:00 am.
Pay Correction Checks Paid Citywide: The chart and table below depict the number of pay
correction checks issued.
120
100
80
60
40
20
0
Paycheck Correction Checks Paid Citywide (as of January 31, 2011 at 11:00am)
t —Pogce -,W-Fire —A Water/WW —*—Trensporta8on Pubic Works
Oct 29th Nov 12th Nov 24th Dec 10th Dec 24th
Other City Departments Not Shown Above
Jan 7th Jan 21st
Oct 29th
Nov 12th
Nov 24th
Dec 10th
Dec 24th
Jan 7th
Jan 21st
Parks and Community Services
10
83
3
7
4
10
11
Municipal Court
1
6
3
5
4
7
3
71
4
2
3
3
1
57
5
54
0
58
1
7
0
0
0
1
3
1
1
2
1
3
9
City Secretary
2
0
0
1
24
0
2
Equipment Services
2
0
1
20
2
0
1
Financial Management Services
0
0
2
1
0
2
23
14
1
1
1
0
2
0
3
18
13
1
0
9
11
2
2
Public Events
3
0
0
0
0
0
0
Information Technology
0
9
1
8
0
1
0
Community Relations
1
0
0
0
0
5
0
Human Resources
1
0
0
0
Oct 29th Nov 12th Nov 24th Dec 10th Dec 24th
Other City Departments Not Shown Above
Jan 7th Jan 21st
ISSUED BY THE CITY MANAGER
FORT WORTH, TEXAS
Oct 29th
Nov 12th
Nov 24th
Dec 10th
Dec 24th
Jan 7th
Jan 21st
Parks and Community Services
10
6
3
7
4
10
11
Municipal Court
1
6
3
5
4
7
3
Code Compliance
4
2
3
3
1
1
5
City Mana er
0
0
1
7
0
0
0
Planning and Development
3
1
1
2
1
3
9
City Secretary
2
0
0
1
0
0
2
Equipment Services
2
0
1
0
2
0
1
Financial Management Services
0
0
2
1
0
2
1
Housing and Economic Develop
1
1
1
0
2
0
3
Library
2
1
0
0
0
2
2
Public Events
3
0
0
0
0
0
0
Information Technology
0
0
1
1
0
1
0
Community Relations
1
0
0
0
0
0
0
Human Resources
1
0
0
0
1
1
1
Internal Audit
0
0
0
0
1
1
0
ISSUED BY THE CITY MANAGER
FORT WORTH, TEXAS
INFORMAL REPORT TO CITY COUNCIL MEMBERS
To the Mayor and Members of the City Council
No. 9350
February 8, 2011
Page 2 of 3
SUBJECT: ENTERPRISE RESOURCE PLANNING (ERP) PROJECT - PHASE 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 21st
Total
less than $50
32
6
0
14
15
16
15
98
between $50 and $100
22
9
2
26
13
26
28
126
between $100 and $250
54
39
37
47
45
67
67
356
between $250 and $500
22
21
22
44
48
69
69
295
between $500 and $750
5
11
6
15
7
18
18
80
between $750 and $1000
6
5
2
6
6
7
7
39
between $1000 and $1500
3
3
5
5
5
5
5
31
between $1500 and $2000
2
0
4
61
21
2
2
18
between $2000 and $2500
2
0
0
21
0
1
0
5
greater than $2500
0
0
4
21
01
0
0
6
The total number of checks/advices produced since 18 Oct 2010 is 48,303. The total number of off cycle checks is
951 which is 0.019 %.
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.
* PD reported additional inquiries since the last report.
ISSUED BY THE CITY MANAGER
FORT WORTH, TEXAS
29 -Oct-
12- Nov -
24 -Nov-
10- Dec -
23 -Dec-
7-Jan-
21 -Jan-
10
10
I
10
10
10
11
11
Total
PP22
PP23
PP24
PP25
PP26
PP01
PP02
Total inquiries rcvd by
CPPT
237
254
165
249
168
143
109
1325
Total inquiries researched
completed
-235
-246
-161
-243
-126
-94
-12
-1117
Total Remaining to be
researched
2-
8-
4
6
42
49
97 '
208
* PD reported additional inquiries since the last report.
ISSUED BY THE CITY MANAGER
FORT WORTH, TEXAS
INFORMAL REPORT TO CITY COUNCIL MEMBERS
.mot
To the Mayor and Members of the City Council
No. 9350
February 8, 2011
Page 3 of 3
SUBJECT: ENTERPRISE RESOURCE PLANNING (ERP) PROJECT - PHASE I
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.
• Added one consultant (for a total of four) to provide support for Police payroll correction
inquiries and verification
• Continued use of four 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 15, 2011.
If you have any questions, please contact Pete Anderson, Director, IT Solutions Department at
817- 392 -8781.
Higgins
Interim City Manager
ISSUED BY THE CITY MANAGER
FORT WORTH, TEXAS