...
Implementation ideas
Example 1: Spreadsheets
Rolled-up summaries, useful to detect variability or trends
Time period | Chemistry: Average tickets per month | Chemistry: Average tickets per day | Physics: Average tickets per month | Physics: Average tickets per day |
---|---|---|---|---|
April 2017 | 100 | 5.0 | 15.0 | 0.75 |
8 months: 04/01/2016 to 01/01/2017 | 123 | 6.3 | 15.5 | 0.8 |
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.
- 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.
Total flow summary: There is an average of over ?? tickets resolved by our group each workday,.
- We averaged ??? 115 resolved tickets per month for both Chemistry and Physics.
- Per above assumption, 19.6 At 20 workdays per month: ??? 115 / 19.6 = ~???? ~5.75 resolved tickets per workday.
Chemistry, for this mm month period:
Flow summary: xx 100 tickets per month averages to yy 5 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 | 53 | 9 | 0.45 | 9% |
Michael E Hint | 36 | 7 | 59 | 2.9 | 58% |
Oliver B Habicht | 13 | 22 | 31 | 1.55 | 31% |
All others: | 1 | 18 | 2 | 0.1 | 2% |
Total | 52 | 48 | 100 | 5 |
Physics, for this mm month period:
Flow summary: xy 15 tickets per month averages to about yx 0.75 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 | 4 | 3 | 7 | 0.35 | 47% |
Michael E Hint | 2 | 3 | 5 | 0.25 | 33% |
Oliver B Habicht | 0 | 3 | 3 | 0.15 | 20% |
All others: | 0 | 0 | 0 | - | - |
Total | 6 | 9 | 15 | 0.75 |
---------------------------------------------------------------
...
Chemistry, for this 8 month period:
Flow summary: 123 tickets per month averages to 6.3 tickets resolved per day.
...
Physics, for this 8 month period:
Flow summary: 15.5 tickets per month averages to about 0.8 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 |
Lulu Zhu | 2 | 1 | 3 | - | - |
Michael E Hint | 34 | 35 | 69 | 8.6 | 56% |
Oliver B Habicht | 21 | 14 | 35 | 4.4 | 28% |
All others: | 9 | 12 | 21 | 2.6 | 17% |
Total | 68 | 56 | 124 | 15.5 |
...