Skip to content

About this spreadsheet

Seven numbers per location per week in, and a scorecard, a thirteen-week trend and a late-numbers flag out. A library of 38 metric definitions that each state what their numerator and denominator leave out, a sixty-minute meeting agenda with a facilitator script, an issues list and a meeting record.

A weekly scorecard is the simplest management tool there is and the most often abandoned, usually for one of two reasons: the numbers arrive late, or two locations turn out to mean different things by the same word. This pack is built against both. Seven raw numbers are typed per location per week — revenue, appointments booked and completed, direct labor cost, redos, new reviews, and how many customers rebooked before leaving. Every rate is then calculated, so there is no percentage anywhere that somebody worked out by hand.

The metric library is the part that matters. All 38 definitions state what is in and what is out of both the numerator and the denominator, where the number comes from and which week it belongs to. Labor cost ships as two separately identified metrics — direct hourly wages, and all-in with burden — because they are not comparable and the difference is large. Rates are recalculated from summed parts at every level rather than averaged, so a small location cannot outvote a large one. The pack prints no benchmark figures at all, and the guide explains why: published labor benchmarks for service businesses span a third to two thirds of revenue, and most of that spread is different denominators rather than different businesses.

Highlights

  • Seven numbers in, every rate calculated — no hand-worked percentages
  • 38 metric definitions stating what each one excludes, not just its formula
  • Rates recalculated from summed parts, never averaged across locations
  • Sixty-minute meeting kit with a facilitator script and an issues list

Questions

Pairs well with

Related products