SequelOrtho — Project InsightsProject Insights

Resource Contention

Derived from the inventory — PMs double-booked within a sprint, and per-sprint demand on the shared IT / Analytics teams. Active projects only.

PM double-bookings (12)

Project ManagerSprint#Concurrent projects
McDonald, ShannonSprint 3 (May 4 - Jun 12)6
Kristina MillerSprint 4 (Jun 29 - Aug 7)4
Anna BeckerSprint 2 (Mar 9 - Apr 10)2
Bill CitroSprint 1 (Jan 12 - Feb 20)2
Chrissy CattauSprint 5 (Aug 24 - Oct 2)2
Kristina MillerSprint 3 (May 4 - Jun 12)2
McDonald, ShannonSprint 2 (Mar 9 - Apr 10)2
Michael RobertsSprint 1 (Jan 12 - Feb 20)2
Michael RobertsSprint 2 (Mar 9 - Apr 10)2
Michelle HestonSprint 1 (Jan 12 - Feb 20)2
Miranda HarrahillSprint 1 (Jan 12 - Feb 20)2
Nate HengSprint 3 (May 4 - Jun 12)2

Team capacity (from the workbook resource sheets)

Analytics
6 people · 48 project-work hrs/week
IT
12 people · 140 project-work hrs/week

Sprint demand vs capacity

Active projects flagged IT / Analytics required per sprint. Utilization assumes ~3hrs/week per flagged project (the workbook’s “medium” sizing) against each team’s weekly project-work hours.

SprintWindowActive projectsIT requiredIT util.Analytics requiredAnalytics util.
Sprint 1 (Jan 12 - Feb 20)Jan 12 – Feb 2016919%319%
Sprint 2 (Mar 9 - Apr 10)Mar 9 – Apr 10201021%16%
Sprint 3 (May 4 - Jun 12)May 4 – Jun 1218511%213%
Sprint 4 (Jun 29 - Aug 7)Jun 29 – Aug 71236%00%
Sprint 5 (Aug 24 - Oct 2)Aug 24 – Oct 2412%16%
Sprint 0224%16%