{"product_id":"bp-practice-kpi-workbook-spreadsheet","title":"Dental Practice KPI Workbook \u0026 Spreadsheet 2026","description":"\u003cp\u003eA complete, two-tool KPI tracking and analysis system for Australian dental practices — a 24-page companion workbook and a pre-built Excel spreadsheet with 6 automated KPI tabs, a benchmarks reference, and a monthly review summary. Built on Resolve Dental Consultancy's proven Continual Improvement Cycle.\u003c\/p\u003e\n\u003cp\u003eYou can't manage what you don't measure. You can't improve what you don't manage.\u003c\/p\u003e\n\u003cp\u003eMost Practice Managers have a gut feel for how the practice is performing. This system replaces gut feel with data — and data with action. Enter your monthly figures, the spreadsheet calculates your KPIs automatically, and the workbook guides you through what the numbers mean and what to do about them.\u003c\/p\u003e\n\u003cp\u003e✔ Microsoft Word workbook + Microsoft Excel spreadsheet — two files included\u003cbr\u003e✔ 24-page companion workbook — analysis questions, worksheets, and action planning for every KPI\u003cbr\u003e✔ 6-tab Excel spreadsheet — automated KPI calculations with Resolve Dental Consultancy benchmarks built in\u003cbr\u003e✔ Includes a full industry benchmarks reference tab\u003cbr\u003e✔ 2026-compliant\u003cbr\u003e✔ Instant digital download\u003cbr\u003e✔ Single-practice licence\u003c\/p\u003e\n\u003cp\u003eThe 6 Essential KPIs\u003c\/p\u003e\n\u003cp\u003eKPI 1 — Dentist Productivity\u003cbr\u003eTrack monthly income, contracted hours, lost time (absence, FTAs, equipment breakdown), and active hourly rate per dentist. Benchmark: $600–$1,000+\/hr active.\u003c\/p\u003e\n\u003cp\u003eKPI 2 — Hygienist Productivity\u003cbr\u003eMeasure whether your hygiene service is commercially viable — does the active hourly rate exceed the combined cost of the hygienist and nurse? Benchmark: $300–$500+\/hr active.\u003c\/p\u003e\n\u003cp\u003eKPI 3 — Surgery Utilisation\u003cbr\u003eTrack available vs actual hours used per surgery, per session, per day. Benchmark: 85–95% utilisation. Includes a revenue loss calculator — even 2 hours of unused surgery time per week costs $62,400–$104,000 per year.\u003c\/p\u003e\n\u003cp\u003eKPI 4 — New Patient Activity\u003cbr\u003eTrack new patients by provider and type (children, adult comprehensive, adult emergency, referrals in). Benchmark: 20–50+ adult comprehensive new patients per provider per month.\u003c\/p\u003e\n\u003cp\u003eKPI 5 — Recall Efficiency\u003cbr\u003eTrack pre-booking rate, reminders sent, confirmation rate, and outstanding recalls to chase. Benchmark: 80%+ pre-booked and 80%+ confirmed by month end.\u003c\/p\u003e\n\u003cp\u003eKPI 6 — Expenses vs Income\u003cbr\u003eTrack every major expense category as a percentage of gross fees and compare against Resolve benchmarks. Benchmark: consumables 6–8%, salaries 25–30%, labs 6–10%, marketing 2–3%, total expenses 60–70%, profit margin 30–40%.\u003c\/p\u003e\n\u003cp\u003eWhat's in the Workbook\u003cbr\u003eFor each KPI: a plain-language explanation, the Resolve benchmark, analysis questions to diagnose what your results are telling you, a monthly worksheet, and action planning prompts. Includes a Monthly KPI Scorecard, Top 3 Priorities framework, and a structured Action Plan template to bring to your monthly business meeting.\u003c\/p\u003e\n\u003cp\u003eWhat's in the Spreadsheet\u003cbr\u003e6 automated KPI tabs (Dentists, Hygienists, Surgery, New Patients, Recalls, Expenses), a Benchmarks reference tab with 25+ industry benchmarks, and automatic month-linking across all tabs. Enter your data once — the spreadsheet does the rest.\u003cbr\u003e\u003c\/p\u003e","brand":"Resolve Dental Consultancy","offers":[{"title":"Default Title","offer_id":53694112104812,"sku":null,"price":199.0,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0988\/9657\/6876\/files\/product_kpi_workbook.png?v=1777705679","url":"https:\/\/www.resolvedentalconsultancy.com.au\/products\/bp-practice-kpi-workbook-spreadsheet","provider":"Resolve Dental Consultancy","version":"1.0","type":"link"}