Tabellab

Budget vs Actual: Variances and Lines to Review

Lesson 2 of 20 Lab 🔒 Locked

Lessons in this course

  1. Team Cost Budget: Salaries, On-Costs and Cost per FTELabFree
  2. Budget vs Actual: Variances and Lines to ReviewLab Locked
  3. Shift Rota: Coverage per Day with COUNTIF and COUNTIFSLab Locked
  4. Holiday Requests: Workdays and Overlap CheckLab Locked
  5. Workload and Capacity: Who Is Overloaded?Lab Locked
  6. KPI Tracker: Targets, Scores and Traffic LightsLab Locked
  7. Performance Reviews: Weighted Scores and Rating BandsLab Locked
  8. 1:1 Meeting Tracker: Days Since and Overdue CheckLab Locked
  9. Training Budget: Prioritise Requests Within the BudgetLab Locked
  10. Overtime Cost Check: Hourly Rates, Premium and BudgetLab Locked
  11. Hiring Cost and Time to ProductivityLab Locked
  12. Mid-course Project: Monthly Team Report – Unit Costs, Productivity and a ChartLab Locked
  13. Staffing by Hour: Contacts, Handle Time, Advisors Needed & the Gap to the RotaLab Locked
  14. Next Year’s Team Budget: a Pay Rise from April, a New Hire from May & Monthly PhasingLab Locked
  15. What Meetings Cost: Person-Hours, Money per Year & the Share of Team TimeLab Locked
  16. Team Absence Rate: Available FTE Days, Monthly Rates, a Rolling Three Months & Year to DateLab Locked
  17. Complaint Reasons: Shares, Cumulative Share & the Vital Few That Cause 80%Lab Locked
  18. Backlog Burn-Down: New vs Closed Tickets, the Backlog Trend & Weeks to ClearLab Locked
  19. Fair Weekend Rota: Saturdays Worked, a Fair Share by FTE & Who Is Asked NextLab Locked
  20. Final Project: The Quarterly Team Pack – Service Level, Cost per Ticket & Absence vs TargetsLab Locked