The CFO’s Guide to Outcome KPIs — Margin, Cash, DSO/DIH/DPO, Elasticity, Churn

A practical playbook for Caribbean finance leaders to turn metrics into money

When volatility is the norm—FX swings, import lead times, climate seasonality, and shifting buyer expectations—outcome KPIs become the CFO’s operating system. This guide shows how to design, measure, and use five essential levers that move P&L and cash in the Caribbean context:

• Margin (gross & contribution) — price, cost, and mix you can actually manage.

• Cash (the full cash conversion cycle) — DSO/DIH/DPO tuned to your supply and customer reality.

• Price Elasticity — where a 1–3% price change lifts profit more than a 10% volume push.

• Churn — why saving the right 5% of customers beats acquiring the next 20%.

• Decision Rituals — a weekly cadence that converts dashboards into dollars.

You’ll get precise formulas, normalization rules (seasonality, FX, mix), dashboard designs, and action plays that your teams can run next week—plus a 90-day activation plan to make the KPIs stick.

 Want these KPIs wired into an Executive Command Center (with your data) in 6–8 weeks?
📧 [email protected] | 📱 WhatsApp Global: +1 555 795 9071

1) Designing KPIs for Outcomes (Not Reports)

Rules of the road

1. One definition, everywhere. Publish a KPI dictionary with formulas, data sources, refresh cadence. No dueling spreadsheets.

2. Traceable to transactions. Every KPI must drill from scorecard → ledger/SKU/order/customer.

3. Normalized for reality. Separate price, volume, mix, FX, and seasonality or you’ll argue, not act.

4. Owner and playbooks. Every KPI has a single owner, thresholds, and “if X then Y” actions.

5. Decide in the meeting. Weekly 30–60 minutes; actions logged live (owner + date).

Caribbean context to bake in

• FX: Express revenue/cost in a reference currency or show FX impact as its own line.

• Seasonality: Use prior-year season curves; align by week-of-year and key events (tourism peaks, school terms, carnival, cruise schedules).

• Shipping/Customs: Model lead-time variance; affects safety stock and DIH targets.

• Concentration risk: A few large buyers can skew averages—track segment and key-account KPIs.

2) Margin: From Points to Plays

2.1 Core Definitions

 

Use CM for promo/discount decisions; GM% for overall mix and sourcing.

• Price–Volume–Mix (PVM) Bridge
  Period-over-period margin delta decomposed into Price, Volume, Mix, Cost (and FX if relevant). This explains why margin moved.

2.2 What to Instrument

• SKU/channel/site GM% and CM%

• Discount leakage (discounts not tied to rules)

• Promo ROI = (Incremental Gross Profit ÷ Promo Spend)

• Landed cost components (FX, freight, duties, supplier price)

• Mix index (weight of A-SKU/priority margin sets)

2.3 Thresholds & Alerts (examples)

• Discount leakage > 1.0–1.5 pts of revenue → trigger price guardrails review

• Promo ROI < 1.2× for 2 weeks → stop/retarget promo

• Landed cost ↑ >3% MoM → auto-review price bands or pack sizes

2.4 Plays You Can Run

• Guardrail pricing: Minimum margin by SKU family/channel; dynamic guardrails adjust with landed cost/FX.

• Promo targeting: Use price elasticity (see Section 4) to select SKUs/customers where discounts convert profitably; avoid blanket promos.

• Supplier mix: Shift volume to vendors with better landed-cost stability; renegotiate freight terms.

• Assortment rationalization: Trim long-tail SKUs that destroy CP (contribution profit) unless strategic.

3) Cash: Build the Muscle Around DSO/DIH/DPO

3.1 Core Formulas

 

Tip: For seasonality, compute rolling 13-week averages and compare to prior-year same-week.

3.2 What to Instrument

• AR aging ladder (0–30, 31–60, 61–90, 90+) by customer segment

• Collections Priority Score (amount × lateness × risk) → call queue

• Inventory health: A-SKU stockouts; dead stock % (no movement in X days)

• AP terms: early-pay discounts vs. borrowing cost

3.3 Thresholds & Alerts (examples)

• DSO ↑ >5 days vs baseline → Collections blitz (call-queue + dispute resolution)

• DIH ↑ >10% with rising dead stock → Markdown plan on obsolete sets

• DPO ↓ >4 days due to early payments → justify via discount capture vs. WACC

3.4 Plays You Can Run

• Collections queue logic: Rank AR daily; assign calls; automate reminders; track promise-to-pay.

• Safety-stock tuning: Use lead-time variability and service-level targets to set reorder points by SKU/site.

• AP optimization: Capture early-pay discounts when cost of capital justifies; otherwise maintain DPO.

4) Price Elasticity: The Small Lever with Outsized Profit

4.1 Concept & Quick Math

• Own-price elasticity (ε):

 

4.2 How to Estimate, Practically

• Experimental (best): A/B test price bands by store/channel/segment (short windows).

• Quasi-experimental: Staggered price changes across similar stores (difference-in-differences).

• Econometric: Regress quantity on price with controls (seasonality, promo, competitor index, stock levels).

• Heuristics: Start with contribution margin; trial +1–3% on low-elastic SKUs/segments; watch weekly CM$.

4.3 Instrumentation

• Elasticity bands per SKU/segment: Low, Medium, High

• “Do-not-discount” lists for inelastic winners

• Promo cannibalization: track uplift on target SKUs vs. dip on adjacent SKUs

• Stock awareness: never discount if you’re supply-constrained

4.4 Plays You Can Run

• Micro price lifts on low-elastic items (+1–3%); monitor CM$ weekly.

• Targeted promos on high-elastic SKUs with inventory headroom.

• Pack architecture: Offer slightly larger packs with better CM% to avoid list-price hikes.

• Channel-specific pricing: Different elasticity online vs. wholesale vs. tourist segments.

5) Churn: Save the Right Customers (Not Every Customer)

5.1 Definitions

 

5.2 What to Instrument

• Churn risk score by account (recency/frequency/value, complaints, service interactions, credit risk).

• Save-plays library: offer, credit, service fix, executive call.

• Win-back rate and cost; expansion rate (cross-sell/upsell).

• Unit economics: Save only when CLV-at-risk > save-cost.

5.3 Thresholds & Alerts (examples)

• Risk score > 0.7 for high-value account → escalate to executive call

• Silent churn (no activity) for 30 days (segment-dependent) → nudge + call

• Collection disputes + repeat service tickets → service remediation before discounting

5.4 Plays You Can Run

• Save-play sequencing: 1) Fix root cause (service/credit), 2) Right-sized incentive, 3) Manager follow-up.

• CX “red flag” alerts: Trigger within 24 hours; measure save rate.

• Pricing for retention: Protect loyal, inelastic segments; focus promos on high-risk, high-value accounts.

6) Scorecards & Dashboards: What the CFO Should See

Executive Command Center (one screen)

• Margin & Mix: GM%, CM$, discount leakage, promo ROI (trend + variance)

• Cash: DSO, DIH, DPO, CCC (rolling 13-week)

• Elasticity: % of revenue in low/med/high bands; price changes executed; CM$ impact

• Churn: Logo & revenue churn; at-risk revenue; save rate; CLV delta

• Risk/Assurance: Evidence completeness; AML false-positive rate; audit exceptions

• Alerts: Top 5 actions this week (auto-generated)

Design principles

• 8–10 KPIs max; traffic lights.

• Drill-throughs to transaction level.

• Buttons for plays (“Reprice SKUs”, “Launch Save-Play”, “Call these 20 AR accounts”).

• Inline glossary for KPI formulas.

7) Normalization & Attribution: Prevent the Wrong Fights

• Seasonality: Compare Week-X vs. Week-X ly; include event calendars (tourism, festivals).

• FX: Show an FX bridge line item so leaders see “operational” vs. “currency” effect.

• Mix: Use PVM to isolate whether margin moved because of richer mix or actual pricing/cost.

• Supply shocks: Track lead-time variance; note when stockouts—not pricing—drove sales dips.

• Governance: Publish a 1-page Attribution Protocol: what’s adjusted, what’s not, and who signs off.

8) Case Snapshots (Illustrative)

Retail & E-Com (Jamaica + OECS)

• Issues: A-SKU stockouts; margin erosion via blanket discounts.

• Moves: Safety-stock tuning; elasticity-based price lifts; promo ROI targeting.

• Results (12 months): Stockouts ↓ 41%; dead stock ↓ 22%; GM +2.4 pts; cash variance ↓ 55%.

Distributor (120 accounts, two islands)

• Issues: DSO drift; small-acct churn.

• Moves: Collections queue logic; save-plays; segment pricing guardrails.

• Results (9 months): DSO ↓ 11 days; churn ↓ 19%; forecast accuracy ±6%.

Hospitality (2 hotels, 3 F&B)

• Issues: Occupancy volatility; overtime spikes.

• Moves: Segment demand forecast; rate guidance; staffing model; channel mix.

• Results (2 seasons): RevPAR +12%; overtime –15%; marketing ROI +25%.

Figures are indicative; live programs baseline, normalize for seasonality/FX, and verify jointly.

9) Weekly Decision Ritual (Agenda Template, 45–60 min)

1. Scoreboard: 8–10 KPIs (traffic lights; 5-minute scan)

2. Exceptions deep dive: top 2 only (10 minutes each)

3. Plays: pricing, promo, replenishment, collections, save-plays (15 minutes)

4. Action log: owner + date (5 minutes)

5. Close: confirm blockers removed; next week’s focus (2 minutes)

Rules

• No static decks; use live dashboards.

• Decide in the meeting.

• Track insight → action → outcome; celebrate wins monthly.

10) 90-Day Activation Plan

Weeks 0–2 — Orientation & KPI Dictionary

• Choose 2–3 value levers (e.g., margin via guardrails, DSO via queue, churn via save-plays).

• Publish definitions, baselines, normalization rules (seasonality/FX/mix).

• Schedule weekly ritual; assign KPI owners.

Weeks 2–6 — Foundation Live

• Connect systems (accounting/ERP, POS/CRM, e-com, HR/payroll, PSP/banking).

• Launch Executive Command Center + two functional dashboards.

• Start alerts and action log.

Weeks 6–10 — Models & Plays

• Switch on demand, cash-flow, and churn models; elasticities for top 100 SKUs.

• Execute first price lift and collections queue; measure CM$ and DSO.

Weeks 10–12 — Verify & Roadmap

• Reconcile KPI deltas to P&L/cash; issue evidence pack.

• Plan Q2 sprints (promo ROI, staffing, ESG/assurance flows).

11) FAQs (CFO Edition)

Q: Our data isn’t perfect—start anyway?
Yes. Start with a lean model focused on your top levers; improve feeds as value shows.

Q: What’s a good KPI velocity?
One meaningful KPI move per month (e.g., DSO –2 days, GM +0.3–0.5 pts, stockouts –5–8%). Compound from there.

Q: How to avoid “analysis paralysis”?
Cap the KPI canon, enforce the weekly ritual, and attach every discussion to an action owner with a date.

Q: Will teams adopt this?
If views are role-specific, the ritual is short, and leaders reward insight → action → outcome, adoption follows.

12) What Dawgen Global Brings

• Borderless, high-quality delivery: analytics, finance, CX, and assurance talent aligned to your sector.

• AaaS backbone: governed data, predictive models, and alerting—no heavy IT build.

• Outcome cadence: we run the weekly ritual with you until it becomes habit.

• Assurance-grade evidence: lineage, logs, and packs for auditors, lenders, and buyers.

Make KPIs the Engine of Cash and Margin

KPIs don’t create value—decisions do. When margin, cash, elasticity, and churn are correctly defined, normalized, and tied to weekly plays, results compound. This is how CFOs steer through volatility and build resilient P&L and cash profiles in the Caribbean.

See these KPIs in a live Executive Command Center with your data.
📧 [email protected] | 📱 +1 555 795 9071

Book a 30-minute workshop to map your KPI canon, thresholds, and first three plays.
Email [email protected] or WhatsApp +1 555 795 9071.

 

About Dawgen Global