Customer service · Original fictional case
Review a response queue with explicit paused time
A support lead needs a breach summary for open tickets. Use the supplied elapsed and paused minutes to determine which open tickets exceed the internal response target.
Related work: Customer Service Representatives · O*NET task 2580.
Your source data
| ticket | priority | state | elapsed minutes | paused minutes |
|---|---|---|---|---|
| T1 | P1 | open | 75 | 20 |
| T2 | P1 | open | 90 | 10 |
| T3 | P2 | open | 260 | 40 |
| T4 | P2 | open | 300 | 30 |
| T5 | P1 | closed | 200 | 0 |
The rules
- This fictional policy allows 60 active minutes for P1 and 240 for P2. Exactly at the target is not a breach.
- Active minutes = elapsed − paused. All intervals are already measured in calendar minutes.
- Exclude closed tickets from the open queue. Maximum overage is max(active − target, 0) among open tickets.
A method you can reuse
- Compute active time as T1 55, T2 80, T3 220 and T4 270. Do not use raw elapsed minutes when valid pauses exist.
- Compare each ticket against its own priority target. T2 exceeds 60 by 20 minutes; T4 exceeds 240 by 30.
- Exclude T5 even though its elapsed time is large: it is not part of the requested open queue.
A common wrong turn
Treating every ticket as P1 or including closed tickets changes the requested denominator and can produce a misleading escalation list.
Use it in a handoff
Before using a similar report at work, define permitted pause reasons, business hours and time-zone treatment. The exercise supplies elapsed intervals so those rules are not guessed.
Check your calculation
Enter numbers without currency or percent symbols. A matching result confirms this exercise’s calculation; keep the method in your review note.
See the worked answer
Open tickets: 4
T1–T4 are open.
Open breached tickets: 2
T2 and T4 exceed their priority targets.
Largest breach overage (minutes): 30
T4 has 270 active minutes against a 240-minute target.
Source and practice material
Occupational context uses the O*NET® 31.0 Database from the U.S. Department of Labor, Employment and Training Administration, under CC BY 4.0. View the occupation.
Skill Workbench selected and adapted the occupational information and added its own fictional cases, calculations, guidance and worksheets. USDOL/ETA has not approved, endorsed or tested these additions. O*NET® is a trademark of USDOL/ETA.