Cost to serve dashboard

100-customer demo · 2 trucks per day · Fictional history: 21 May–20 Nov 2026

From date
To date
Period revenue
$425,811
325 matched deliveries
True gross margin
28.8%
incl. $14,537 supplier rebates
Cost to serve
$37,443
8.8%
CTS profit
$85,328
20.0%
Avg net per drop
$262.55
7 loss-making customers

Customer ranking

Example thresholds · CTS net margin after all four service cost buckets · excludes separate corporate overhead
Platinum
6666.0%

≥15% · protect & retain

Sales
$333,767
CTS profit
$79,536
Review accounts
Gold
1313.0%

10–<15% · grow toward Platinum

Sales
$21,976
CTS profit
$2,812
Review accounts
Silver
77.0%

6–<10% · improve toward Gold

Sales
$25,488
CTS profit
$2,238
Review accounts
Bronze
77.0%

>0–<6% · agree an improvement plan

Sales
$27,870
CTS profit
$1,187
Review accounts
Tin
77.0%

≤0% · turnaround or exit review

Sales
$16,711
CTS profit
-$446
Review accounts

Bronze and Tin: agree a turnaround plan or review an orderly exit. Silver and Gold: grow toward Platinum. No sales or missing profit data: unranked (0).

Team incentive scorecard

Primary KPI: net customer upgrades. Supporting measures: sales growth and profit growth.

Current: 2026-11-02 – 2026-11-20 (19 days) · Comparison: 2026-10-14 – 2026-11-01 (19 days). Equal calendar length. Same source and filters · 100 prior accounts · 100 comparable accounts with unchanged rep ownership.

Fictional demo results · 21 May–20 November 2026 · includes improvements and declines, not your Pronto sales or earned incentives.

Net customer upgrades · #1 KPI
5
14 upgrades · 9 downgrades
Bronze / Tin to Silver+
1
Recovered profitable accounts
Sales growth
25.7%
$87,156 equivalent-period change
CTS profit improvement
$24,576
Period change, not a forecast

Customer tiers · baseline vs current

Grey: baseline · Blue: current · All observed accounts; upgrades require matching ownership.

Trading history · monthly daily averages

Blue: sales (left scale) · Red: CTS profit (right scale) · Partial months use covered calendar days.

Sales repNet upgradesSilver+ recoveriesSales growthProfit changeCoverageReview status
Casey Smith (demo)2↑3 ↓1034.2%$6,71725 matched · 0 newly observed · 0 not observed · 0 reassignedIncentive review
Alex Morgan (demo)2↑4 ↓2022.4%$5,84925 matched · 0 newly observed · 0 not observed · 0 reassignedIncentive review
Sam Taylor (demo)1↑4 ↓3121.4%$5,11425 matched · 0 newly observed · 0 not observed · 0 reassignedIncentive review
Jordan Lee (demo)0↑3 ↓3025.9%$6,89525 matched · 0 newly observed · 0 not observed · 0 reassignedImprovement focus
Customer ranking changes · 23 accounts
Customer / repBaselineCurrentMovementProfit change / day
Fig Hotel 3
Alex Morgan (demo)
SilverGold↑ Upgrade$11.69
Basil Grill 4
Casey Smith (demo)
GoldPlatinum↑ Upgrade$6.38
Olive Canteen 3
Jordan Lee (demo)
GoldPlatinum↑ Upgrade$5.54
Blue Kitchen
Sam Taylor (demo)
GoldPlatinum↑ Upgrade$9.09
Northside Pub
Sam Taylor (demo)
GoldPlatinum↑ Upgrade$8.27
Basil Bakery 2
Casey Smith (demo)
GoldPlatinum↑ Upgrade$1.37
Olive Eatery 2
Jordan Lee (demo)
GoldPlatinum↑ Upgrade$3.79
Copper Canteen
Alex Morgan (demo)
SilverGold↑ Upgrade$3.48
Riverside Café 5
Casey Smith (demo)
SilverGold↑ Upgrade$3.20
Golden Bistro
Sam Taylor (demo)
BronzeSilver↑ Upgrade$4.33
Fig Hotel 4
Alex Morgan (demo)
SilverGold↑ Upgrade$3.77
Ember Bakery 2
Jordan Lee (demo)
SilverGold↑ Upgrade$3.77
Market Eatery
Alex Morgan (demo)
SilverGold↑ Upgrade$1.02
Blue Hotel 4
Sam Taylor (demo)
SilverGold↑ Upgrade$1.89
Laneway Kitchen 2
Jordan Lee (demo)
SilverBronze↓ Downgrade-$13.75
Corner Kitchen 2
Alex Morgan (demo)
GoldSilver↓ Downgrade-$4.89
Juniper Bistro 4
Casey Smith (demo)
GoldSilver↓ Downgrade$7.84
Saffron Deli 3
Sam Taylor (demo)
GoldSilver↓ Downgrade-$4.78
Laneway Deli 4
Jordan Lee (demo)
PlatinumGold↓ Downgrade$9.13
Corner Diner
Alex Morgan (demo)
GoldSilver↓ Downgrade-$5.65
Saffron Grill
Sam Taylor (demo)
SilverBronze↓ Downgrade$2.48
Saffron Eatery 2
Sam Taylor (demo)
SilverBronze↓ Downgrade-$4.51
Laneway Diner
Jordan Lee (demo)
BronzeTin↓ Downgrade-$0.39

Incentive review requires positive net upgrades, sales growth and CTS profit growth. New, reassigned and unobserved accounts do not count as upgrades or exits. Finance must validate coverage and cost-rate changes. No bonus amounts or payouts are configured.

AI margin opportunities

Internal · rep review required

Where the margin goes · selected period

Invoice margin
$108,234.67
+ Supplier rebates
$14,536.96
True gross margin
$122,771.63
Order taking & admin
-$1,256.50
Credit terms
-$2,624.09
Picking
-$12,627.60
Split cases
-$1,994.00
Fuel & distance
-$2,323.69
Driver & truck transit
-$7,638.31
Stop & dwell time
-$8,979.25
True net profit
$85,328.19

Net profit by dated route

Whale curve · cumulative period profit

Lowest customer contributions

CustomerSales repNet/dropPeriod net
Juniper DinerCasey Smith (demo)-$26.26-$158
Juniper Pub 5Casey Smith (demo)-$29.08-$87
Laneway Grill 3Jordan Lee (demo)-$39.38-$79
Juniper Bistro 2Casey Smith (demo)-$19.94-$60
Laneway Kitchen 5Jordan Lee (demo)-$10.41-$31
Corner Eatery 4Alex Morgan (demo)-$9.40-$28
Laneway DinerJordan Lee (demo)-$1.03-$3
Juniper Club 3Casey Smith (demo)$2.60$8
See all customers →