Sample document

Redbud Fabrication, Inc. does not exist, and its revenue, part numbers and margins are invented. The producer price movements driving the cost restatement are real — BLS series WPU101 and WPU102, pulled 19 July 2026. This is not client work and describes no real engagement.

Pricing & Margin Analysis

Where the margin actually went

Prepared for Redbud Fabrication, Inc.

Prepared by
Michael Hopper
Firm
Decision Insight Partners
Issued
July 2026
Data period
Jul 2025 – Jun 2026

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.

38% → 34%
contribution margin, restated at replacement cost
10.6 pts
gap between work quoted before and after December 2025
6%
of part numbers carrying 47% of the total shortfall
$1.29M
annual margin recovered by repricing 40 parts
Recommendation

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:

The question

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:

Producer price index movement between the January 2026 cost roll and June 2026. Source: BLS series WPU101 and WPU102.
InputJan 2026Jun 2026Change
Iron and steel329.8366.3+11.1%
Nonferrous metals503.0533.8+6.1%

Applied to Redbud's material mix, that understates cost of goods by a specific and calculable amount:

Material cost understatement at June 2026 replacement cost. Material runs 42% of revenue at standard.
ComponentAt standardIndex moveUnderstated 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,240held
Annual material cost not reflected in reported margin$1,533,077
The finding

$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:

$0 $2M $4M $6M $8M $10M 10–15 15–20 20–25 25–30 30–35 35–40 40–45 45–50 50–55 realized contribution margin, %
Annual revenue by realized contribution margin band, valued at June 2026 replacement cost.
last quoted before Dec 2025 quoted since Dec 2025

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 orders10th25th50th75th90th
Realized contribution margin23.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:

Parts grouped by the date their current price was set.
Quote vintagePartsRevenueShareRealized margin
Last quoted before Dec 2025400$22,964,30259.8%29.8%
Quoted since Dec 2025240$15,435,69840.2%40.4%
Gap10.6 pts
The finding

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.

0% 25% 50% 75% 100% if spread evenly 40 parts = 46.5% of the shortfall 0 160 320 480 640 part numbers, ranked by shortfall
Cumulative share of the $2,782,215 annual shortfall, by part number ranked largest first. The dashed diagonal is what the curve would look like if the shortfall were spread evenly across the catalogue.
Reprice the top…Revenue touched% of revenueMargin recovered% of shortfall
10 parts$4,223,34111.0%$634,73922.8%
18 parts$6,809,26017.7%$868,46631.2%
40 parts$10,310,34526.8%$1,292,41946.5%
60 parts$12,693,57333.1%$1,547,08355.6%
100 parts$17,016,61744.3%$1,890,49667.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

MeasureTargeted (40 parts)Across the board
Part numbers affected40 of 640 · 6.2%640 · 100%
Revenue affected$10,310,345 · 26.8%$38,400,000 · 100%
Average price increase12.5%7.2%
Customers receiving an increaseA subsetEvery one
Annual margin recovered$1,292,419$2,782,215
Contribution margin after37.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

Recommended path

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.

WeeksActionMeasure of done
1Validate the index move against twelve months of steel invoicesActual purchase inflation within 2 points of 11.1%
1–2Account managers review the forty parts, flag any where volume is genuinely at riskA final list, with exclusions documented and quantified
2Rebuild the standard cost roll at June 2026 replacement costReported margin drops to ~34% — the number was always this
3–6Issue revised pricing with 30 days' notice, referencing the published indexRevised prices effective, retention tracked by part
7+Quarterly cost roll refresh and a standing report of parts unquoted for 9 monthsNo 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

EngagementScopeFixed price
Pricing & Margin AnalysisOrder-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.

Data with integrity makes the best decisions

When did you last requote a part that's still running?

For most companies the honest answer is that nobody knows. That's usually where the money is. Bring it to a free 20-minute call.

Book a free call