Tool Stack Costs: Cost per Active User, Seat Utilisation, Unused Spend and Low-Use Flags
Lessons in this course
- Campaign Request Intake: Requested Lead Time, Minimum Lead Time by Size and Rush Flags per TeamFree
- Triage Scoring: Weighted Priority Scores with SUMPRODUCT, Ranks and an Approve or Waitlist Decision Locked
- Sprint Capacity: Available Days, Net Hours after Leave and Overhead, and Capacity per Role Locked
- Utilisation and Load: Project Utilisation, Total Load and Overload Flags Locked
- Sprint Planning: Plannable Hours, Running Totals, Commit or Carry Over and Carry-Over Hours Locked
- Sprint Velocity: Completion Rates, a Moving Average, a Linear Forecast and Sprints to Clear the Backlog Locked
- Turnaround SLAs: Targets per Request Type, Met or Missed, Days over the SLA and SLA Attainment Locked
- Turnaround Distribution: Mean, Median, 90th Percentile and the Share within the SLA Locked
- Approval Rounds and Rework: Hours per Round, Rework Hours, First-Pass Rate and Rework Share Locked
- Campaign QA: Errors per 100 Checks, a Target Status, the Overall Error Rate and the Share of Clean Launches Locked
- QA Escapes: Escape Rate per Launch, the Overall Escape Rate and a Pareto Analysis of Defect Categories Locked
- QA Control Limits: Weekly Error Proportions, a Centre Line, Upper Control Limits and Signals Locked
- Backlog Ageing: Age in Days, Age Bands with an Approximate Lookup, Counts per Band and Waiting Time Locked
- Backlog Flow: Arrivals, Completions, Net Flow, Backlog Trend and Little's Law Waiting Time Locked
- Tool Stack Costs: Cost per Active User, Seat Utilisation, Unused Spend and Low-Use Flags Locked
- Seat Right-Sizing: Right-Sized Licences with ROUNDUP, Savings per Tool and a Renewal Window Locked
- Cost Allocation: User and Request Shares, Allocated Tool Cost per Team and Cost per Active User Locked
- Capacity vs Demand: Demand Hours by Request Type, Utilisation Needed and a Growth-by-Headcount Scenario Grid Locked
- Load and Quality: Correlation, Regression Slope, R-Squared and a Forecast of Errors at a Higher Load Locked
- Final Project: A Marketing Operations Scorecard with SLA, Utilisation, QA and Tool-Cost KPIs Locked