Margin Leak Report
Acme Steel
29,796 quote lines from 2025-11-03 to 2026-10-30 (11.9 months; figures annualized ×1.01). 0 rows dropped as unparseable. Replacement cost: index-adjusted (FRED producer price indexes).
Recoverable gross profit / yr
$492K
1.20 margin points on won revenue
Won revenue / yr
$41.10M
Margin on replacement cost
13.4%
Quote win rate
44%
What we found
- $392K/yr from pricing up low quotes. 7,194 of 29,363 won and lost lines (25%) were priced more than 2 points below the margin your own win curve supports for that segment (capped at your median winning margin). Pricing quotes like these at that margin is worth this much a year, after the deals you'd lose at the higher price.
- $100K/yr from winnable business priced too high. 9,251 lines were priced above the top quarter of your winning margins for the segment. Bringing them down to the segment's best margin wins enough extra business to be worth this much, net of the lower price.
- Book cost is hiding the real margin. 980 won lines looked fine on book cost but sold under an 8% margin on replacement cost ($137K/yr short of that floor). Over the period, $1.16M/yr of reported gross profit was inventory price movement rather than pricing.
- Discounting is concentrated. The top two reps by leakage account for 63% of the money left on the table; Rep D alone prices 5.9 pts below segment medians.
- Speed wins. Quotes out in under an hour win 48% vs. 12% after a day.
Your win curve
Win rate by margin on replacement cost, across all quotes. Every point of margin costs some win rate; the highlighted band earns the most gross profit per quote.
Where the money is
Segments ranked by recoverable gross profit. "Best margin" is the margin that maximizes expected gross profit given your own win curve.
| Segment | Lines quoted | Win rate | Median won margin | Best margin | Underpriced wins | Overpriced losses | Total / yr |
|---|---|---|---|---|---|---|---|
| aluminum · 1–5K lb · tier A | 1,112 | 46% | 11.9% | 15.3% | $40K | $20K | $59K |
| aluminum · 5–15K lb · tier A | 320 | 43% | 8.8% | 13.4% | $43K | $4K | $48K |
| carbon · 1–5K lb · tier A | 5,327 | 45% | 13.3% | 16.0% | $37K | $10K | $47K |
| carbon · 5–15K lb · tier A | 1,515 | 37% | 10.4% | 14.4% | $30K | $4K | $34K |
| stainless · 1–5K lb · tier A | 1,085 | 43% | 14.7% | 16.0% | $14K | $9K | $23K |
| aluminum · 1–5K lb · tier C | 500 | 43% | 16.4% | 18.8% | $14K | $9K | $23K |
| carbon · 15K+ lb · tier A | 291 | 45% | 6.8% | 14.3% | $23K | $-40 | $23K |
| carbon · 1–5K lb · tier B | 3,074 | 41% | 16.4% | 19.5% | $18K | $4K | $22K |
| aluminum · 1–5K lb · tier B | 627 | 41% | 15.3% | 21.3% | $19K | $2K | $22K |
| carbon · 5–15K lb · tier B | 927 | 35% | 12.7% | 15.1% | $13K | $7K | $19K |
Pricing by salesperson
Margin on won quotes compared with the median for the same metal, order size and customer tier. Negative means the rep prices below what the market is accepting from others.
| Salesperson | Won revenue / yr | Win rate | Margin vs. segment | Left on table / yr |
|---|---|---|---|---|
| Rep D | $4.46M | 61% | -5.9 pts | $139K |
| Rep G | $4.55M | 61% | -5.1 pts | $110K |
| Rep C | $3.69M | 47% | +0.1 pts | $24K |
| Rep K | $3.64M | 46% | -0.2 pts | $23K |
| Rep A | $3.16M | 43% | +0.7 pts | $19K |
| Rep E | $3.56M | 45% | +0.8 pts | $19K |
| Rep J | $3.37M | 45% | +0.9 pts | $18K |
| Rep H | $2.46M | 34% | +0.7 pts | $16K |
| Rep L | $3.53M | 41% | +1.9 pts | $12K |
| Rep B | $3.06M | 38% | +2.0 pts | $8K |
| Rep F | $2.87M | 35% | +2.8 pts | $4K |
| Rep I | $2.73M | 29% | +5.6 pts | $956 |
Customers priced below their tier
Accounts whose won quotes average at least 4 points under the segment median, usually legacy pricing nobody revisited.
| Customer | Tier | Won lines | Won revenue / yr | Margin vs. segment | Left on table / yr |
|---|---|---|---|---|---|
| C-0260 | B | 52 | $103K | -4.6 pts | $3K |
| C-0623 | B | 42 | $106K | -6.0 pts | $2K |
| C-0454 | C | 11 | $42K | -7.9 pts | $1K |
| C-0615 | C | 10 | $74K | -4.6 pts | $995 |
| C-0594 | C | 11 | $17K | -5.3 pts | $988 |
| C-0349 | C | 10 | $44K | -6.1 pts | $959 |
| C-0068 | C | 12 | $19K | -7.1 pts | $941 |
| C-0131 | B | 15 | $52K | -4.3 pts | $898 |
| C-0553 | C | 10 | $45K | -5.2 pts | $886 |
| C-0452 | C | 19 | $70K | -4.3 pts | $725 |
| C-0031 | C | 18 | $41K | -5.9 pts | $702 |
| C-0334 | C | 10 | $43K | -4.7 pts | $521 |
Speed to quote
Win rate by time from request received to quote sent.
Lines answered in under an hour won 48% of the time vs. 12% for those taking over a day.
Largest single underpriced wins
| Quote | Date | Customer | Product | Lbs | Price / cwt | Margin | Supported margin | Left on table |
|---|---|---|---|---|---|---|---|---|
| Q-108813 | 2026-05-26 | C-0380 | aluminum bar | 12,668 | $282.68 | 1.2% | 13.6% | $2K |
| Q-115303 | 2026-04-13 | C-0230 | aluminum extrusion | 9,411 | $297.11 | -2.2% | 8.8% | $2K |
| Q-107481 | 2026-04-15 | C-0459 | aluminum bar | 7,109 | $251.86 | -4.9% | 8.8% | $2K |
| Q-110277 | 2026-04-22 | C-0075 | aluminum extrusion | 13,666 | $299.06 | 1.6% | 8.8% | $1K |
| Q-103372 | 2026-10-07 | C-0148 | carbon tube | 25,809 | $74.18 | -4.3% | 6.8% | $1K |
| Q-104546 | 2026-03-13 | C-0462 | aluminum bar | 9,101 | $261.42 | 0.6% | 11.9% | $1K |
| Q-102403 | 2026-07-20 | C-0566 | aluminum extrusion | 10,960 | $311.26 | 1.8% | 8.8% | $1K |
| Q-108249 | 2026-05-15 | C-0459 | aluminum extrusion | 6,510 | $316.09 | -0.6% | 8.8% | $1K |
| Q-110574 | 2026-02-19 | C-0170 | aluminum extrusion | 5,671 | $282.79 | -2.2% | 8.8% | $1K |
| Q-115472 | 2026-02-11 | C-0075 | aluminum extrusion | 5,464 | $275.42 | -2.6% | 8.8% | $1K |
| Q-116802 | 2026-04-16 | C-0532 | aluminum plate | 9,113 | $266.20 | 0.5% | 8.8% | $1K |
| Q-116208 | 2026-06-25 | C-0158 | aluminum sheet | 6,865 | $245.40 | -1.7% | 8.8% | $993 |
What this data can't see
- Replacement cost is estimated, not quoted. It is your book cost moved by the change in the US producer price index for that product (FRED / BLS) versus the prior three months. Indexes are monthly and published about a month late, and stainless uses the stainless pipe and tube index for all forms. Mill price quotes or your own replacement cost column would be more exact.
- Everything the export doesn't hold. Lead time, stock on hand, processing and freight (unless included), the customer relationship, and what competitors quoted all affect wins. Where reps price up because they know a customer will pay, the data can't tell that apart from luck.
- These are estimates. The way to prove them is a live pilot: new pricing on most customers, a holdout group priced as today, and gross profit compared between the two.
How this was calculated
- All prices converted to $/cwt. Margin is measured against replacement cost (index-adjusted (FRED producer price indexes)), not book cost.
- Segments are metal × order size × customer tier (tiers from your own quoted volume: A = customers making up the top 50% of pounds, B = next 30%, C = rest).
- A win-probability curve is fitted per segment (logistic regression on margin) from your won and lost quotes.
- A segment is used only when price clearly moves win rate there (the curve's slope is at least 2.5 standard errors below zero). The best margin is kept inside the range your own winning quotes cover (10th to 90th percentile).
- Low quotes are priced up only to the lower of the segment's best margin and its median winning margin, and only when they sat more than 2 points below it. High quotes are priced down only to the best margin. Each estimate is expected gross profit at the new price minus expected gross profit at the old one, so deals lost at a higher price are counted.
- When the same quote line appears more than once, only the latest version is used.
- Figures are estimates from historical data. A live pilot with a holdout group is how the number gets proven.