Tabellab
Business & Operations Intermediate

Professional Services Metrics: Utilisation, Realisation & Project Margin

Run the numbers of a consulting firm: utilisation by role, standard value and blended rates, realisation and write-offs, leverage and profit per partner, project budget vs actuals, fixed fee vs T&M, a bench forecast and a rate card built for a target margin – every cell checked as you go.

8 lessons 8 labs 2 h Certificate

The first lesson is free — no account needed.

About this course

A professional services metrics course that runs the numbers of one fictional consulting firm in a spreadsheet, for consulting, accounting, legal and agency managers, practice leads, finance staff and anyone billing by the hour. You turn capacity into available hours and calculate utilisation (chargeability) per consultant, role and firm, value billable hours at standard rates and work out the blended rate, measure realisation and write-offs per engagement and flag those below the review threshold, calculate leverage, revenue per head and profit per partner, compare a project's budget with actuals and forecast the final fees, compare margins on fixed-fee and time-and-materials work, forecast six months of demand from booked work and a weighted pipeline against capacity and the bench, and build next year's rate card from cost for a target margin. The first lab is free.

Lessons

  1. Available vs Billable Hours & Utilisation by RoleLab15 minFree
  2. Bill Rates & Standard Value: Pricing the HoursLab14 min Pro
  3. Realisation & Write-Offs: Billed ÷ StandardLab14 min Pro
  4. Revenue per Consultant, Leverage & Profit per PartnerLab15 min Pro
  5. Project Budget vs Actuals: Hours, Fees & Earned Value-LiteLab15 min Pro
  6. Fixed Fee vs Time & Materials: Who Carries the Overrun?Lab15 min Pro
  7. Capacity & Bench Forecast: Will We Have Enough Work?Lab16 min Pro
  8. Rate Card Pricing for a Target MarginLab16 min Pro