...
| Time period | Chemistry: Average tickets per month | Chemistry: Average tickets per day | Physics: Average tickets per month | Physics: Average tickets per day | ||
|---|---|---|---|---|---|---|
| July 2017 (20 work days) | 87 | 4.85 | 10 | 0.50 | ||
| June 2017 (22 work days) | 100 | 4.54 | 17 | 0.77 | ||
| May 2017 (22 work days) | 92 | 4.2 | 13 | 0.59 | ||
| April 2017 (20 work days) | 100 | 5.0 | 15.0 | 0.75 | ||
| 8 months: 04/01/2016 to 01/01/2017 | 123 | 6.3 | 15.5 | 0.8 |
...
Total flow summary: There is an average of over xx 4.85 tickets resolved by our group each workday, for both Chemistry and Physics.
- We averaged xx had 97 resolved tickets per this month for both Chemistry and Physics.
- At 20 workdays per this month: xx 97 / 20 = ~xx ~4.85 resolved tickets per workday.
...
Flow summary: 87 tickets per month averages to 4.35 tickets resolved per day.
| Resolved within 1 day | Resolved in more than 1 day | Total | Oliver's analysis: Avg. per month | Oliver's analysis: Percent of volume |
Lulu Zhu | 2 | 8 | 10 | 0.45 | 11.5% |
Michael E Hint | 28 | 25 | 53 | 2.65 | 60.9% |
Oliver B Habicht | 10 | 14 | 24 | 1.2 | 27.6% |
All others: | 0 | 0 | 0 | - | - |
Total | 40 | 47 | 87 | 4.35 |
Physics, for this 1 month period:
Flow summary: 13 10 tickets per month averages to about 0.5950 tickets per day.
| Resolved within 1 day | Resolved in more than 1 day | Total | Oliver's analysis: Avg. per month | Oliver's analysis: Percent of volume |
Kelly Brower | 1 | 3 | 4 |
2
| 0.20 | 40% | |||
| Lulu Zhu | 1 | 0 | 1 | 0. |
| 05 |
| 10% |
Michael E Hint |
1 |
4 |
5 | 0. |
| 25 |
| 40% |
Oliver B Habicht |
0 |
0 |
0 |
| - |
| - | |||||
All others: | 0 | 0 | 0 | - | - |
Total |
9
4
13
3 | 7 | 10 | 0.50 |
---------------------------------------------------------------
Tickets resolved in June 2017
- From Frank, 7/13/17
Assumptions for analysis portion
- Since JUST the month of June, simply counted the work days, taking into account staff holidays this month (none): 22 work days.
- See prior analysis if care to have numbers for average number of work days over several months.
Total flow summary: There is an average of over 5.32 tickets resolved by our group each workday, for both Chemistry and Physics.
- We had 117 resolved tickets this month for both Chemistry and Physics.
- At 22 workdays this month: 117 / 22 = ~5.32 resolved tickets per workday.
Chemistry, for this 1 month period:
Flow summary: 100 tickets per month averages to 4.54 tickets resolved per day.
| Resolved within 1 day | Resolved in more than 1 day | Total | Oliver's analysis: Avg. per month | Oliver's analysis: Percent of volume |
Lulu Zhu | 3 | 11 | 14 | 0.64 | 14.0% |
Michael E Hint | 37 | 24 | 61 | 2.77 | 61.0% |
Oliver B Habicht | 10 | 14 | 24 | 1.1 | 24.0% |
All others: | 0 | 1 | 1 | 0.04 | 1.0% |
Total | 50 | 50 | 100 | 4.35 |
Physics, for this 1 month period:
Flow summary: 17 tickets per month averages to about 0.77 tickets per day.
| Resolved within 1 day | Resolved in more than 1 day | Total | Oliver's analysis: Avg. per month | Oliver's analysis: Percent of volume |
Kelly Brower | 2 | 1 | 3 | 0.14 | 17.6% |
| Lulu Zhu | 1 | 0 | 1 | 0.04 | 0.06% |
Michael E Hint | 4 | 4 | 8 | 0.36 | 0.47% |
Oliver B Habicht | 0 | 5 | 5 | 0.23 | 0.07% |
All others: | 0 | 0 | 0 | - | - |
Total | 7 | 10 | 17 | 0.77 |
---------------------------------------------------------------
Tickets resolved in May 2017
- From Frank, 6/2/17
Assumptions for analysis portion
- Since JUST the month of May, simply counted the work days, taking into account staff holidays this month (Mon. 5/29: Memorial Day): 22 work days.
- See prior work if care to have numbers for average number of work days over several months.
...
| Resolved within 1 day | Resolved in more than 1 day | Total | Oliver's analysis: Avg. per month | Oliver's analysis: Percent of volume |
Lulu Zhu | 2 | 7 | 9 | 0.41 | 10% |
Michael E Hint | 34 | 25 | 59 | 2.7 | 64% |
Oliver B Habicht | 10 | 13 | 23 | 1.04 | 25% |
All others: | 1 | 1 | 0.04 | 1% | |
Total | 46 | 46 | 92 | 4.2 |
...
Tickets resolved in April 2017
- From Frank, 5/2/17
Assumptions for analysis portion
- Since JUST the month of April, simply counted the work days, taking into account no staff holidays this month: 20 work days.
- See prior work if care to have numbers for average number of work days over several months.
...
| Resolved within 1 day | Resolved in more than 1 day | Total | Oliver's analysis: Avg. per month | Oliver's analysis: Percent of volume |
Lulu Zhu | 2 | 7 | 9 | 0.45 | 9% |
Michael E Hint | 36 | 23 | 59 | 2.9 | 58% |
Oliver B Habicht | 13 | 18 | 31 | 1.55 | 31% |
All others: | 1 | 0 | 1 | 0.1 | 2% |
Total | 52 | 48 | 100 | 5 |
...
From Frank, 1/30/17, "Resolved Time Summary per Assignee: 04/01/2016 to 01/01/2017"
Assumptions for analysis portion
- In a year, 52 weeks * 5 workdays = 260 workdays/yr. Assume staff have 3 weeks vacation, and 2 weeks University Holidays, so 5 weeks * 5 days = 25 workdays. Thus 235 workdays per year (=260-25).
- 19.6 workdays per month (=235/12). This represents the available FTEs.
...
| Resolved within 1 day | Resolved in more than 1 day | Total | Oliver's analysis: Avg. per month | Oliver's analysis: Percent of volume |
Lulu Zhu | 38 | 53 | 91 | 11.4 | 9% |
Michael E Hint | 285 | 247 | 532 | 66.5 | 54% |
Oliver B Habicht | 132 | 104 | 236 | 29.5 | 24% |
All others: | 66 | 58 | 124 | 15.5 | 13% |
Total | 521 | 462 | 983 | 123 |
...