← charliekodatt.com
Demo company: Anytown Comfort Co. Sample data.

Who is your best tech?

Rank under a sales-only scorecard vs. the scorecard you set

Rises 2+ placesFalls 2+ placesMoves less

What the scorecard rewards

Build your own. Download the Excel template, put in your own techs and numbers, and see how many of the 10 measures you can fill. If you can't fill half the columns, that's the finding.
Download the template (.xlsx)

The scorecard, last 90 days

TechFlagsRevenueRev vs. call mixCallback rateRenewal rateCancels / 100 membersSurveyProof shownSales-only rankScoreRankNet value

Select a tech to see how the score and net value are built. Net value = gross profit, minus the truck cost of callbacks, plus or minus the lifetime profit of members renewed above or below the team's rate. Callbacks count the truck only, so that line is a low estimate: it leaves out the paying call the slot could have run. Members come and go for many reasons, so set how much of a lost member you put on the visit.

Assumptions

Sample values for the demo company, the same ones used across this series: $517 of gross profit per member a year, and 3.6 years per member at a 72% renewal rate. Truck cost varies a lot by market. Set your own.

Edit the sample techs, or paste in your own numbers

How each part is scored

Each measure scores 0 at the floor and 100 at the target, in a straight line between. A part's score is the average of its measures. The total is the weighted average of the five parts. Techs with few calls are pulled toward the team average, as if they had 40 more calls at the team rate, so one good stretch on a light schedule can't top the board.