Pricing & Margin Analysis
Where the margin actually went
Prepared for Redbud Fabrication, Inc.
00Summary of findings
Redbud reports a 38% contribution margin. That figure is calculated against a standard cost roll dated January 2026. Steel has risen 11.1% since that roll was set.
Restating material at replacement cost puts actual contribution margin at 34%. Redbud has been quoting, and congratulating itself, on four points of margin that no longer exist. On $38.4 million of revenue that gap is $1.53 million a year.
The second finding is more useful than the first. The shortfall is not spread evenly. Work quoted before December 2025 earns 29.8%; work quoted since earns 40.4% — a 10.6-point gap that has nothing to do with customer, volume or negotiation, and everything to do with when the price was last set.
Forty part numbers out of 640 — 6% of the catalogue — carry 47% of the shortfall. Repricing those forty recovers $1.29 million a year and touches 27% of revenue. Getting the same result with an across-the-board increase would take 7.2% on every part and every customer Redbud has.
Do not raise prices across the board. Requote the forty part numbers identified in section 06 at an average increase of 12.5%, and rebuild the standard cost roll on a quarterly cycle so this does not recur. A blanket 7.2% would annoy every customer Redbud has in order to fix a problem that lives in 6% of the catalogue.
01The question
The March Constraint Analysis valued lost throughput using Redbud's stated 38% contribution margin, and flagged the figure as untested: it came from a standard cost roll that predated a sharp move in steel. The July Market Analysis then established that the whole industry is under-repriced — fabricated metal output prices rose 5.3% over the past year against 14.2% steel inflation — and recommended requoting the cost roll before pursuing new work.
This analysis is that requote, extended into the question it raises:
What is Redbud's real margin at today's material cost, where is it being lost, and what is the smallest price change that recovers it?
The emphasis is on smallest. Every price increase spends customer goodwill. The object is to spend as little of it as possible.
02Method and data
Twelve months of closed orders were extracted at line level — 2,174 orders across 640 active part numbers — with revenue, quoted price, material issued, and labor hours booked against each. Quote dates came from the quoting system and were matched to orders by part number and revision.
Material was then revalued two ways: at the January 2026 standard cost roll, which is what Redbud's reporting uses, and at replacement cost as of June 2026. The gap between those two numbers is the whole of section 03.
Replacement cost movement is not estimated. It is taken from the Bureau of Labor Statistics producer price indexes for iron and steel (WPU101) and nonferrous metals (WPU102), which are public, monthly, and free.
Labor and overhead were held at standard throughout. Both have moved, but far less than metal, and holding them constant keeps this analysis about the thing that actually changed.
03What the cost roll misses
Redbud's standard cost roll was set in January 2026. Since then:
| Input | Jan 2026 | Jun 2026 | Change |
|---|---|---|---|
| Iron and steel | 329.8 | 366.3 | +11.1% |
| Nonferrous metals | 503.0 | 533.8 | +6.1% |
Applied to Redbud's material mix, that understates cost of goods by a specific and calculable amount:
| Component | At standard | Index move | Understated by |
|---|---|---|---|
| Steel — 78% of material | $12,579,840 | +11.1% | $1,394,916 |
| Aluminum — 14% of material | $2,257,920 | +6.1% | $138,161 |
| Other — 8% of material | $1,290,240 | held | — |
| Annual material cost not reflected in reported margin | $1,533,077 | ||
$1,533,077 on $38.4 million of revenue is 4.0 points of margin. Reported contribution margin of 38% is actually 34% at replacement cost. Every quote Redbud has issued since January has been built on a cost that is too low, and every margin report since January has been too high by the same amount.
Two things follow, and they pull in opposite directions. Redbud is less profitable than it believes, which is bad. And Redbud has been winning work at prices that looked comfortable and were not, which means the pricing lever has more room in it than the sales team currently thinks — because competitors are quoting off the same stale assumptions.
A note on method: this top-down restatement puts actual margin at 34.0%. The bottom-up rebuild from 2,174 individual orders in section 04 puts it at 34.06%. Two independent routes to the same number within a sixteenth of a point is the check worth running — if they had disagreed by two points, everything after this section would be unreliable.
04The spread
A 34% average is not a useful management number, because almost none of Redbud's work earns 34%. Revenue by realized margin band, with each part colored by when it was last quoted:
The distribution runs from 10% to 55%, with the tenth and ninetieth percentiles 20.1 points apart. That spread is the finding. A business with a 34% average and a 20-point spread is not one business — it is a portfolio of good work subsidising work that should have been requoted a year ago.
| Percentile of orders | 10th | 25th | 50th | 75th | 90th |
|---|---|---|---|---|---|
| Realized contribution margin | 23.5% | 28.5% | 33.7% | 39.0% | 43.6% |
Only $79,743 of revenue — two tenths of one percent — sits below a 15% margin. This is not a business giving work away. It is a business whose prices are, in specific and identifiable places, roughly a year out of date.
05The mechanism
The colors in the chart above are the answer. Splitting the catalogue by when each part was last quoted:
| Quote vintage | Parts | Revenue | Share | Realized margin |
|---|---|---|---|---|
| Last quoted before Dec 2025 | 400 | $22,964,302 | 59.8% | 29.8% |
| Quoted since Dec 2025 | 240 | $15,435,698 | 40.2% | 40.4% |
| Gap | 10.6 pts | |||
Redbud's quoting is not broken. Work priced since December 2025 earns 40.4% — comfortably above the 34% average and above the 38% the company believes it makes overall. The problem is that 60% of revenue runs on prices nobody has revisited, because a part already in production does not generate a quote request. It just keeps shipping at the price it was given.
This is worth stating plainly because it changes who owns the fix. Nothing here suggests the estimators are pricing badly or that salespeople are discounting too freely. The failure is that Redbud has no process which ever revisits the price of an active part. Work quoted in a low-steel period keeps its low-steel price indefinitely, and the longer a part runs, the more out of date it becomes.
It also explains why the problem is invisible in the monthly reporting. Blended margin drifts down a fraction of a point at a time as stale parts take a larger share of the mix. No month ever looks alarming.
06Where the money actually is
Bringing every stale part up to the 40.4% that current quoting achieves would be worth $2,782,215 a year. That is the theoretical maximum, and it is not the recommendation — some of those parts are priced where they are for competitive reasons that a spreadsheet cannot see.
The practical question is how much of that $2.78 million sits in how few parts.
| Reprice the top… | Revenue touched | % of revenue | Margin recovered | % of shortfall |
|---|---|---|---|---|
| 10 parts | $4,223,341 | 11.0% | $634,739 | 22.8% |
| 18 parts | $6,809,260 | 17.7% | $868,466 | 31.2% |
| 40 parts | $10,310,345 | 26.8% | $1,292,419 | 46.5% |
| 60 parts | $12,693,573 | 33.1% | $1,547,083 | 55.6% |
| 100 parts | $17,016,617 | 44.3% | $1,890,496 | 67.9% |
Forty is the recommended stopping point, and the reason is the shape of the curve rather than the size of the number. Between 40 and 60 parts, each additional part repriced returns progressively less while adding another customer conversation. The curve has flattened by then; the cheap recovery is already taken.
07What repricing forty parts does
| Measure | Targeted (40 parts) | Across the board |
|---|---|---|
| Part numbers affected | 40 of 640 · 6.2% | 640 · 100% |
| Revenue affected | $10,310,345 · 26.8% | $38,400,000 · 100% |
| Average price increase | 12.5% | 7.2% |
| Customers receiving an increase | A subset | Every one |
| Annual margin recovered | $1,292,419 | $2,782,215 |
| Contribution margin after | 37.4% | 41.3% |
The across-the-board column recovers more money on paper. It is still the worse option, for a reason that does not appear in the table: it raises prices on the 40% of revenue already earning 40.4%, which is work Redbud is winning at healthy margin and would rather not put in play. A 7.2% increase on a well-priced part invites the customer to requote it elsewhere. That risk does not show up in a margin calculation and is the most likely way this exercise destroys value rather than creating it.
The targeted increase averages 12.5%, which is higher per part and will be noticed. It is defensible in a way a blanket increase is not: these are parts whose prices were set before an 11.1% steel move, and the increase can be explained with a published index the customer can look up themselves. That conversation is much easier than justifying why a part quoted last month also went up.
08How to challenge this
Assumptions worth arguing about
- That replacement cost is the right basis. If Redbud holds six months of steel bought at the old price, the margin on that inventory is real while it lasts. It is still the right basis for pricing — a quote commits to metal not yet bought — but the $1.53M is a forward-looking exposure, not a hole in last year's earnings. Check: current inventory turns and whether any of it is hedged or contracted.
- That published indexes track what Redbud actually pays. WPU101 is a national index across all iron and steel. A shop buying one gauge from one service center on a contract may have seen more or less than 11.1%. Check: compare against twelve months of actual invoices before committing to the number. This is the single highest-value verification in the document and takes about two hours.
- That the 40.4% earned on recent quotes is achievable on the stale parts. Some of those forty are priced low because a competitor is aggressive on them. Repricing those risks the volume rather than recovering the margin. Check: the account manager for each of the forty should mark any part where a 12.5% increase puts the business genuinely at risk, before any letter goes out.
- That labor and overhead standards still hold. They were deliberately held constant here. Sector average hourly earnings rose 3.0% over the past year, so the true position is modestly worse than stated — which makes the case stronger, not weaker, and is not worth re-cutting the analysis for.
09Recommendation
Reprice forty part numbers at an average of 12.5%, and put the standard cost roll on a quarterly cycle. The repricing recovers $1.29 million a year. The quarterly cycle is what stops this from happening again — without it, Redbud will be back in the same position within eighteen months.
| Weeks | Action | Measure of done |
|---|---|---|
| 1 | Validate the index move against twelve months of steel invoices | Actual purchase inflation within 2 points of 11.1% |
| 1–2 | Account managers review the forty parts, flag any where volume is genuinely at risk | A final list, with exclusions documented and quantified |
| 2 | Rebuild the standard cost roll at June 2026 replacement cost | Reported margin drops to ~34% — the number was always this |
| 3–6 | Issue revised pricing with 30 days' notice, referencing the published index | Revised prices effective, retention tracked by part |
| 7+ | Quarterly cost roll refresh and a standing report of parts unquoted for 9 months | No part running more than four quarters on an unreviewed price |
The last row is the one that matters in two years. Everything above it is a correction; that row is the change that prevents the next correction. A standing list of parts whose price has not been reviewed in nine months costs nothing to produce and would have caught this in March.
10Scope and fee
| Engagement | Scope | Fixed price |
|---|---|---|
| Pricing & Margin Analysis | Order-level extraction, cost restatement, dispersion and concentration analysis, the ranked reprice list, this document and a working session | $9,500 |
| Repricing support (optional) | Customer communication templates, account-manager briefing, and retention tracking through the first quarter after the increase | $12,000 |
| Total if both are taken | $21,500 | |
Against $1.29 million of recovered annual margin, the full engagement returns roughly sixty times its cost in the first year. That ratio is unusually high and is a function of how long the problem went unnoticed rather than any cleverness in the analysis — the arithmetic here is not difficult. Nobody had run it.