Tabellab

Sprint Planning: Plannable Hours, Running Totals, Commit or Carry Over and Carry-Over Hours

Lesson 5 of 20 Lab 🔒 Locked

Lessons in this course

  1. Campaign Request Intake: Requested Lead Time, Minimum Lead Time by Size and Rush Flags per TeamLabFree
  2. Triage Scoring: Weighted Priority Scores with SUMPRODUCT, Ranks and an Approve or Waitlist DecisionLab Locked
  3. Sprint Capacity: Available Days, Net Hours after Leave and Overhead, and Capacity per RoleLab Locked
  4. Utilisation and Load: Project Utilisation, Total Load and Overload FlagsLab Locked
  5. Sprint Planning: Plannable Hours, Running Totals, Commit or Carry Over and Carry-Over HoursLab Locked
  6. Sprint Velocity: Completion Rates, a Moving Average, a Linear Forecast and Sprints to Clear the BacklogLab Locked
  7. Turnaround SLAs: Targets per Request Type, Met or Missed, Days over the SLA and SLA AttainmentLab Locked
  8. Turnaround Distribution: Mean, Median, 90th Percentile and the Share within the SLALab Locked
  9. Approval Rounds and Rework: Hours per Round, Rework Hours, First-Pass Rate and Rework ShareLab Locked
  10. Campaign QA: Errors per 100 Checks, a Target Status, the Overall Error Rate and the Share of Clean LaunchesLab Locked
  11. QA Escapes: Escape Rate per Launch, the Overall Escape Rate and a Pareto Analysis of Defect CategoriesLab Locked
  12. QA Control Limits: Weekly Error Proportions, a Centre Line, Upper Control Limits and SignalsLab Locked
  13. Backlog Ageing: Age in Days, Age Bands with an Approximate Lookup, Counts per Band and Waiting TimeLab Locked
  14. Backlog Flow: Arrivals, Completions, Net Flow, Backlog Trend and Little's Law Waiting TimeLab Locked
  15. Tool Stack Costs: Cost per Active User, Seat Utilisation, Unused Spend and Low-Use FlagsLab Locked
  16. Seat Right-Sizing: Right-Sized Licences with ROUNDUP, Savings per Tool and a Renewal WindowLab Locked
  17. Cost Allocation: User and Request Shares, Allocated Tool Cost per Team and Cost per Active UserLab Locked
  18. Capacity vs Demand: Demand Hours by Request Type, Utilisation Needed and a Growth-by-Headcount Scenario GridLab Locked
  19. Load and Quality: Correlation, Regression Slope, R-Squared and a Forecast of Errors at a Higher LoadLab Locked
  20. Final Project: A Marketing Operations Scorecard with SLA, Utilisation, QA and Tool-Cost KPIsLab Locked