An Excel workbook — a cover sheet plus five working tabs — and two companion guides built for independent shop owners and service managers. Track technician productivity daily, see your real effective labour rate, score your advisors, and catch menu prices that have fallen behind your door rate — using tools you can run on Monday morning, with no DMS overhaul.
Secure checkout through Square. Digital product — no tax charged. Delivered by email within 24 hours.
After more than 25 years in fixed operations and fleet management, the same three leaks show up in shop after shop. The Vault is built to measure each one with your own numbers.
Technicians on the clock but not on a job. It rarely looks dramatic in a day — and it is paid for at full wage, every day.
Your posted door rate is not what you collect. Discounts at the counter quietly pull the effective labour rate below it.
Menu prices set years ago while the door rate moved on. Every oil change and rotation sold at the old price leaves the difference behind.
One workbook, five working tabs, and a guide for each half of the system. Sample data is fictional and labelled as such on every tab — replace it with your shop's totals before use. Benchmarks are starting points to calibrate, not promises.
Excel · Opens with a cover sheet, then the five working tabs below · Consistent headings, blank input rows ready for your figures
The Daily Tech Tracker and ELR & Leakage Calculator, explained end to end.
The Advisor Scorecard, Monday Review, and Menu Price Review, explained end to end.
This is the executive summary from the Daily Tech Tracker, with the workbook's own sample figures. It is the first thing you see — and the first thing you replace with your own totals.
| Executive summary metric | Sample value | Fixed ops benchmark | Operational status |
|---|---|---|---|
| Shop Productivity (Labour Time Applied) | 87.5% | 85% – 90% | Healthy dispatch flow |
| Technician Efficiency (Labour Sold vs Worked) | 110.0% | 115% – 125% | Proficiency target |
| Overall Shop Proficiency (Sold vs Clocked) | 96.3% | 100%+ | Billing rate capacity |
| Shop Effective Labour Rate (ELR) | $137.14 | $130.00+ (vs $140 door) | Discounting check |
| Total Unapplied Labour Loss (cost at $35/hr) | $175.00 | < $100 / day | Direct wage leak |
Door rate benchmark used in the sample: $140.00/hr. Shop daily totals in the sample: 40.0 clock hours, 35.0 hours applied, 38.5 hours sold across five technicians.
The same arithmetic the ELR & Leakage Calculator does with your real figures. Try it with rough numbers — most owners have never priced their unapplied time before.
This is paid time producing no sold labour — before any lost gross on the work those hours could have carried. The Vault's calculator does this with your actual tracker figures, tech by tech, instead of one shop-wide estimate.
No account, no subscription, no software to install beyond Excel.
One payment of $149 CAD at the secure Square checkout. An email address is required — that's where your package is sent.
Your workbook and both guides are delivered by email within 24 hours of purchase.
Copy your shop's figures into the blank input rows, read the two guides alongside the tabs, and run your first Monday Review.
I help independent auto shop owners and service managers improve profit, productivity, and customer satisfaction — without a DMS overhaul or a consulting engagement.
I know where the money leaks because I've managed it: unapplied technician time, discounting at the service counter, and menu prices that haven't kept up with the door rate. At Glassford Auto Group, my work included Hyundai Signature Certification three years running, with NPS and Fixed Right The First Time improving every year, and technician productivity turned into profit.
The Vault is that experience in workbook form — the trackers and reviews I wish every service manager had on their desk on Monday morning.
Want hands-on help instead? The Shop Profit Audit ($895 CAD) is a one-on-one review of your shop using these same measures. Ask about it at warren@roundtableconsultingservices.com.
The same terms shown on the Square listing, in full.
No. The sample data is fictional and labelled as such on every tab. It's there so you can see exactly how the formulas and benchmarks work before you enter your own totals.
Microsoft Excel. The workbook is a standard .xlsx file with the formulas built in — you type your figures into the blank input rows and the summaries calculate themselves.
By email, within 24 hours of your Square purchase, to the email address you provide at checkout. The package is the workbook (cover sheet plus five working tabs) plus Guide 1 and Guide 2 as PDFs.
No. The Square listing is set with no tax on this digital product — $149 CAD is the total you pay at checkout.
No — and be wary of anyone who promises that. Benchmarks in the Vault are starting points to calibrate against your shop. What the Vault guarantees is visibility: you'll know your productivity, your real ELR, and your unapplied-time cost in dollars, every day.
The licence covers a single facility. If you run more than one shop, get in touch at warren@roundtableconsultingservices.com and we'll sort out the right arrangement.
Shop Performance Vault — Guides 1 & 2. The workbook (cover sheet plus five working tabs), both companion guides, free updates to Guides 1 & 2 on request, delivered by email within 24 hours.
Buy the Vault through SquareQuestions first? Email warren@roundtableconsultingservices.com or call (226) 349-4881.