Blog · Topic
Scenarios, fairness, headcount and the arithmetic behind a plan finance will sign.
Why paying reps on activity measures produces activity and paying them only on outcomes produces sandbagging, the three tests a measure passes before it goes into a plan, the rep controls it, it cannot be gamed by logging, and it reconciles to a ledger, which coverage and outcome measures pass, which fail, the coverage-at-cadence exception that passes all three, and the identity that every credited dollar in a plan is a ledger dollar once.
16 Sept 20263 min readThe capacity model behind a defensible sales headcount plan: reps times calls times weeks less ramp on one side, accounts times required frequency on the other, the gap in reps per territory, and the scenario table that lands on a cost finance can put in the plan.
16 Sept 20263 min readHow a trading desk tiers its clients from the RFQ log and the blotter rather than from the coverage list: two axes, notional traded and hit ratio, four tiers that follow, the clients with high inquiry volume and low hit ratio who consume pricing effort for little, the clients with high hit ratio and modest flow who would trade more if shown more, and the quarterly re-tiering that moves clients on their own numbers.
16 Sept 20262 min readHow an accounting firm turns its engagement list and filing calendar into a load curve per manager: filings due per week, the hours each typically takes from the firm's own time entries, the hours available from the roster, the weeks where load exceeds capacity months ahead, and the reassignments and early starts that flatten the peak before the season does it the hard way.
16 Sept 20263 min readHow a customer service leader finds the tickets that a help article, a product change or an onboarding step would have prevented, from the ticket export: tickets by category and sub-category, the share that are how-to against fault, the how-to questions that recur across accounts, whether a help article exists for each and whether it was viewed before the ticket, the handling time consumed, and the deflection list ranked by hours a month.
16 Sept 20262 min readHow a commercial bank reads utilisation of its committed credit facilities per customer from the facility register and the balance file: drawn against limit, the trend over four quarters, the customers at persistently low utilisation paying commitment fees on lines they do not use, the customers near the limit who will ask for more or go elsewhere, and the relationship reading each pattern supports.
16 Sept 20263 min readFive checks a sales leader runs on a proposed territory design before it goes live, all from the ledger, the customer master and the universe file: potential balance across territories, load balance in weighted accounts, account continuity with the current owners, travel or cluster sanity where it applies, and the quota identity that the new map's quotas sum to the company's. Each with the test, the tolerance and the failure it catches.
16 Sept 20263 min readFive checks a sales operations team runs on the crediting data before commissions are calculated: credited revenue equals the ledger, every split sums to one, every credited line has an assignment in force on its date, overlay credit sits apart from split credit, and every rate and threshold is on the current plan version. Each with the failure it catches, the exception list it produces, and why a payout corrected afterwards costs more than the check.
16 Sept 20262 min readFive ratios that together describe whether a sales team is effective, each computed from exports the company holds: coverage at cadence, meeting-to-opportunity conversion, win rate by segment, revenue per touch, and share of wallet against the norm. Why activity counts and quota attainment are not among them, how the five are read together per rep, and the one-page view that replaces the activity dashboard.
16 Sept 20263 min readA method for assigning accounts to tiers from the ledger and the norm rather than from who owns them: two axes, current revenue and gap at norm, four tiers that follow, the touch cadence each tier gets, the identity that keeps the tiers summing to the book, and the quarterly re-tiering that moves accounts on evidence rather than on argument.
16 Sept 20263 min readHow a sales leader compares inside and field coverage on the same book from the activity log and the ledger: touches per account by channel, cost per touch from the roster at stated rates, revenue per touch by channel and tier, the tiers where field touches return more than they cost and the tiers where inside touches return the same for a fifth of the cost, and the reallocation the numbers support.
16 Sept 20263 min readHow a supply chain team measures actual lead time and its variability per supplier per site per item from purchase orders and receipts, why the spread drives safety stock more than the mean, the suppliers whose variability rose while their average held, and the inventory that a tighter supplier or a corrected lead time parameter would release.
16 Sept 20263 min readHow a hotel group measures its meetings and events space from the function diary: sold hours over available hours per room per property, revenue per available square metre, the day-of-week and month pattern, the properties whose function space sells out on Tuesdays and sits empty on Fridays, the group bookings that took space without rooms, and the identity that function revenue in the diary equals function revenue in the ledger.
16 Sept 20262 min readHow a sales operations team moves accounts between reps mid-year and keeps the numbers whole: dating every move, splitting each moved account's year-to-date and remaining expectation, adjusting quota by the same amount on both sides, and the identity that proves the company's total did not change. With a worked example of three moves and the reconciliation after them.
16 Sept 20262 min readHow a commercial insurance broker measures each account executive's book by where its premium comes from: renewals, growth at existing clients, new clients, and the split of new clients by source, from the placement ledger and the client master. The executives whose books are all renewal, the ones whose new business does not stay past the first renewal, the norm from the broker's own attainers, and the two questions the mix answers about hiring and about pricing.
16 Sept 20262 min readHow a supply chain team turns receipt and purchase order data into an on-time-in-full figure per supplier per site, why the trend matters more than the level, the three-month rule that separates a bad month from a deteriorating supplier, and the watch list that goes to the category manager.
16 Sept 20262 min readHow a distributor finds the accounts whose delivery frequency is out of proportion to their order size, from the delivery log and the invoice lines: drops per week against value per drop, the norm from accounts of the same size and type, the accounts on daily drops that similar accounts serve twice a week, the cost of the extra drops, and the offer that consolidates without losing the account.
16 Sept 20262 min readHow a CPG brand measures the uplift from a promotion per retail account from sell-out data: the account's own pre-promo baseline, the lift during, the dip after, the net lift that remains, and the accounts where a promotion moved volume forward rather than adding it, so that trade spend goes where the lift is real.
16 Sept 20262 min readThree ways to set territory quotas, top-down allocation by last year's revenue, bottom-up from rep commitments, and share of potential from the ledger and the norms, what each rewards and punishes, a worked comparison on the same four territories, the identity that the quotas sum to the company target under every method, and why the third method is the only one a rep can check.
16 Sept 20263 min readHow a sales leader turns a headcount plan into a capacity plan from the team's own data: the ramp curve measured from past hires' attainment by month of tenure, the attrition rate by tenure band, the productive capacity each month that results, and the hiring dates that produce the number in the year, not the year after.
16 Sept 20263 min readHow an oilfield services or equipment rental company measures utilisation of its fleet per equipment class per basin from the rental ledger and the fleet register, the operators whose rental days fell against their own history while their activity did not, the idle classes in one basin that another basin is short of, and the identity that ties rental days to invoiced rental revenue.
16 Sept 20263 min readHow a sales leader measures the load on each rep from the CRM export, accounts and open opportunities weighted by expected effort, sets the norm from the team's own best-performing reps, and finds the two failure modes the headcount plan hides: reps with too many accounts to touch and reps with too few to hit number.
16 Sept 20262 min readFour handoffs in a revenue operation and the measure for each, from exports the company holds: lead to meeting, meeting to opportunity, opportunity to closed, and closed to renewed, with the conversion, the time and the leakage at each, per segment and per source, the identity that ties the funnel's counts to the ledger, and the one page that shows where the revenue operation loses the most.
16 Sept 20263 min readWhy the coverage model, which says which accounts each rep touches at what cadence, and the capacity plan, which says how many touches each rep can make, are the same arithmetic from two ends, how to check that they agree, the identity that touches required equal touches available within a stated tolerance, the two ways they usually disagree, cadence set without hours and hours set without accounts, and the reconciliation that fixes both.
16 Sept 20263 min readHow a sales operations team writes crediting rules so that credited revenue reconciles to the ledger: the difference between attainment credit and revenue, splits that sum to one, overlay credit kept in its own column, the dated assignment that decides who is credited, the identity that every credited dollar is a ledger dollar once, and the exception list that replaces the end-of-quarter dispute.
16 Sept 20262 min readA method for territory planning where every scenario adds up: the four inputs, the fairness measures, the identity that must hold before two plans can be compared, and a worked comparison of moving two reps between regions.
16 Sept 20264 min readHow a pharmaceutical commercial team relates sample drops to prescription change per account and per territory, from the sample log and prescription data: the account's own baseline, the change in the weeks after sampling against accounts of the same tier not sampled, the territories where sampling moves nothing, and the honest wording that keeps a correlation from being reported as a cause.
16 Sept 20262 min readHow a hotel group's commercial team builds room-night mix per property by segment from the property management export, sets each property's expected mix from its own comparable set, and lists the properties whose corporate or group share has drifted from where properties like them sit, without ever comparing a resort to an airport hotel.
16 Sept 20262 min readThe difference between a segment, which describes what a customer is from fields on the master and sets which norm it is compared to, and a tier, which describes what a customer gets from the company, a cadence and an owner, set from its revenue and its gap, why the two are often confused, the rule that segments define norms and tiers define effort, how a customer moves between each, and the two mistakes, tiering by segment and segmenting by tier.
16 Sept 20263 min readHow a consulting or advisory firm reconciles its sales pipeline to delivery capacity by practice and by month: sold and weighted-pipeline hours against available hours from the roster, the months where sold work exceeds the bench and the months where the bench exceeds sold work, and why the two failures need opposite responses from the same report.
16 Sept 20262 min readHow a sales operations team measures coverage, revenue and quota in a model where some reps hold geographic territories and others hold named accounts that sit inside those territories: the precedence rule that puts every account under exactly one owner, the carve-out list the territory rep sees, the identity that territory plus named revenue equals the region's ledger, and the two reports each kind of rep needs.
16 Sept 20262 min readHow to compute the potential of a sales territory from data the company holds, current revenue plus the gap at norm across the accounts in it, plus the universe accounts not yet buying valued at the segment norm, why that beats a market-size estimate for assigning quota, the identity that keeps territory potentials summing to the company's, and a worked comparison of two territories with the same revenue and very different potential.
16 Sept 20263 min readHow a pharmaceutical commercial team redraws territories from access-weighted potential rather than raw prescriber counts: each account's category volume times its access status, summed per candidate territory, the balance across territories, the accounts moved and the continuity of rep relationships, the calls released from blocked accounts, and the identity that the territories' weighted potential sums to the region's.
16 Sept 20262 min readWhat an account plan looks like when every line on it is computed from the ledger, the CRM and the norm: the account's share and gap by product, its trend, its contact recency, its tier and cadence, its concentration in the rep's book, and the three actions that follow. Why it is produced for every account rather than written for twenty, and how the rep's judgement is added on top rather than typed in underneath.
16 Sept 20263 min readA structure for a weekly or fortnightly sales one-to-one in which the manager and the rep look at the same six computed numbers, coverage at cadence, untouched revenue, share of wallet against norm, pipeline coverage by stage, slipped deals, and the data quality score, and make three decisions: which accounts get the week, which deals get moved or dropped, and which measure the rep commits to moving. Why it replaces the pipeline review, and the version that turns into an interrogation.
16 Sept 20263 min readThe complete sales crediting calculation on ten invoice lines, small enough to check by hand: the dated assignment in force on each invoice date, the two lines with splits, the overlay specialist's credit in its own column, credited revenue per rep, the line whose splits sum to 1.4 and the line with no assignment on its date, the exception list, and the identity that split credit sums to the ledger while overlay credit is reported beside it, so a reader can reproduce every figure and then run it on their own exports.
17 Sept 20263 min readThe complete promotional net lift calculation on one SKU at one retail account over sixteen weeks, small enough to check by hand: the eight pre-promotion weeks and their median as the baseline, the two promotion weeks and the gross lift, the four post-promotion weeks and the dip, net lift, trade spend, cost per net unit, the same mechanic at a second account for comparison, and the assertion that the account's weekly sell-out sums to the retailer's total, so a reader can reproduce every figure and then run it on their own sell-out files.
17 Sept 20262 min readThe complete on-time-in-full calculation on ten purchase order lines from two suppliers to two sites, small enough to check by hand: the confirmed due date and the tolerance window, the receipt date and quantity, on time and in full per line, the over-receipt that fails the assertion, OTIF per supplier and per supplier-site, why the supplier figure hides the site, the three-month trend that makes a watch list, and the identity that receipts join to lines, so a reader can reproduce every figure and then run it on their own exports.
17 Sept 20263 min readA template for a sales territory plan that a rep can write in a day and a manager can check in ten minutes: the territory in numbers, the accounts tiered by value and potential, the coverage the tiers are owed against the time available, the growth list of named gaps, the retention list of named risks, and the target built up from those lists. This page gives each table, where its figures come from, the arithmetic that ties the plan to the quota, and a copyable one-page outline.
17 Sept 20265 min readThe complete territory potential and quota calculation on four territories, small enough to check by hand: current revenue per territory, the gap at norm across its current accounts, the universe accounts not buying valued at the segment norm and discounted by a stated realisation factor, potential per territory, the share of potential that reaches the company target, the quota per territory, the balance check, and the identity that quotas sum to the target, so a reader can reproduce every figure and then run it on their own ledger and universe file.
17 Sept 20263 min read