time earn = task uints*length/60;
work output = task units*length;
prod = workoutput/(time work-np time);
eff=(time work-np time)/time work;
staff = np time2/time work;
troughtput = kv comp*60/time work.
task Uints means sum of core task units (taskType equals 1)
time work means sum of work time(taskType equals 2)(roster+Borrow+Overtime+Flexitime-Sick Leave-Annual Leave-Unpaid Leave-Special Leave-Loan)
np time means sum of non-production tasks(taskType equals 3)
np time2 means sum of a sub non-production tasks (Meetings+Training+Coaching+One on One Meeting)
when calc the upper data,you can construct the follow variable.
time earn = task uints*length/60;
work output = task units*length;
prod = workoutput/(time work-np time);
eff=(time work-np time)/time work;
staff = np time2/time work;
troughtput = kv comp*60/time work.
sht =workOutput/kv completed
paid fte=time work/2250
Key Volume Completed
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
AP Review
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
AP SAHS
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Key Volume IN
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
AP Review
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
AP SAHS
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Key Volume Backlog
50.00
50.00
50.00
50.00
50.00
50.00
50.00
50.00
AP Review
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
AP SAHS
30.00
30.00
30.00
30.00
30.00
30.00
30.00
30.00
Time Earned
2.1
1.7
1.5
2.2
1.9
1.1
0.9
11.4
Phone Call
9.00
8.00
7.00
12.00
10.00
8.00
9.00
63.00
Invoice Processed
10.00
9.00
8.00
11.00
10.00
8.00
8.00
64.00
Invoice Cancellations
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Chq register
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
AP Vendor Creation/Maintenance
8.00
7.00
6.00
8.00
7.00
3.00
2.00
41.00
AP Phone Call
7.00
3.00
2.00
5.00
4.00
2.00
0.00
23.00
AP SAHS Pharmacy Uploads TIME TASK (in mins)
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Collector
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Core Task Backlog
8.00
8.00
8.00
6.00
7.00
9.00
3.00
3.00
Chq register
5.00
6.00
3.00
2.00
5.00
6.00
2.00
2.00
Collector
3.00
2.00
5.00
4.00
2.00
3.00
1.00
1.00
Non Production Time
2.5
4.0
3.0
2.0
3.0
0.0
0.0
14.5
One on One Meeting
1.5
1.0
1.0
0.0
0.0
0.0
0.0
3.5
System Outage
1.0
1.0
0.0
2.0
2.0
0.0
0.0
6.0
Coaching
0.0
2.0
2.0
0.0
1.0
0.0
0.0
5.0
Roster
16.0
16.0
16.0
16.0
16.0
16.0
9.0
105.0
Overtime
0.0
1.0
3.0
8.0
1.0
2.0
0.0
15.0
Flexitime
2.0
3.0
1.0
2.0
5.0
4.0
1.0
18.0
Total Time Worked
18.0
20.0
20.0
26.0
22.0
22.0
10.0
138.0
Productivity
13.66%
10.68%
8.53%
9.13%
9.91%
5.00%
9.17%
9.20%
AP Review
10.00%
8.93%
6.11%
5.83%
10.71%
6.00%
8.13%
7.54%
AP SAHS
16.67%
12.04%
11.25%
14.63%
9.44%
4.17%
13.33%
10.94%
Efficiency
86.11%
80.00%
85.00%
92.31%
86.36%
100.00%
100.00%
89.49%
AP Review
87.50%
77.78%
81.82%
93.75%
77.78%
100.00%
100.00%
88.73%
AP SAHS
85.00%
81.82%
88.89%
90.00%
92.31%
100.00%
100.00%
90.30%
Staff Care Ratio
8.33%
15.00%
15.00%
0.00%
4.55%
0.00%
0.00%
6.16%
AP Review
0.00%
22.22%
18.18%
0.00%
11.11%
0.00%
0.00%
7.04%
AP SAHS
15.00%
9.09%
11.11%
0.00%
0.00%
0.00%
0.00%
5.22%
Standard Handle Time
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
AP Review
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
AP SAHS
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Throughput
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
AP Review
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
AP SAHS
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Paid FTE
2.40
2.67
2.67
3.47
2.93
2.93
1.33
3.68
AP Review
1.07
1.20
1.47
2.13
1.20
1.33
1.07
1.89
AP SAHS
1.33
1.47
1.20
1.33
1.73
1.60
0.27
1.79