Articles

How do you build a should-cost model for a supplier's price?

Material net of scrap, conversion at a machine rate, reject allowance, SG&A and a fair profit, then the gap attributed driver by driver.

A should-cost model rebuilds a supplier's price from the bottom up: material net of scrap, machine time at a machine rate, labour, bought-in parts, then reject allowance, overheads and a fair profit, each on the layer beneath it. On an illustrative machined housing quoted at 102.03, the should-cost is 88.50, a gap of 13.53 a unit or 541,185 a year on 40,000 units. Three quarters of the gap comes from one input: a cycle time of 27 minutes where the part needs 21.

Worked in full in Contract Management by Julian R. Sterling, with every figure reproduced in a free workbook.See the book on Amazon →

The point of a should-cost is not to tell the supplier what to charge. It is to replace an argument about the price, which the buyer cannot win, with an argument about the drivers, which can be checked: kilograms, minutes, rates and percentages. A buyer who says "too expensive" gets a token discount. A buyer who says "your cycle time is six minutes longer than the operation needs" gets a conversation about the machining.

The assumptions

Should-cost inputs for one housing, against the supplier's disclosed cost breakdown. All figures illustrative.
DriverShould-costSupplier breakdown
Aluminium bar, gross kg per part6.006.00
Aluminium price per kg3.203.40
Swarf recovered, kg at 1.401.501.50
CNC cycle time, hours (minutes)0.35 (21)0.45 (27)
Machine rate per hour, including factory overhead85.0085.00
Set-up, hours per batch of 5002.002.00
Assembly and inspection, hours at 38.000.250.25
Bought-in parts / outsourced anodising9.40 / 4.809.40 / 4.80
Reject and rework allowance2%2%
SG&A on factory cost10%12%
Profit on total cost8%8%
Packaging and freight per part2.602.60

The should-cost inputs come from three places: the drawing (weights, operations), published or index prices (the metal), and engineering judgment (cycle times, from a CAM simulation or a time study on a comparable part). The 8 per cent profit is deliberately the same in both columns. A should-cost that squeezes the supplier's margin to nothing is a negotiating position, not a model.

The calculation, step by step

Material = gross kg × price per kg − scrap kg × scrap price

Conversion = cycle hours × machine rate + set-up hours × rate / batch + labour hours × labour rate

Price = manufacturing cost × (1 + reject) × (1 + SG&A) × (1 + profit) + freight

In Excel, keep each driver in its own cell and build the price as =Mfg*(1+Reject)*(1+SGA)*(1+Profit)+Freight, so that one change in a driver flows through every mark-up.

Should-cost against the supplier's breakdown, per unit.
LineShould-costSupplierGap
Material: 19.20 of bar less 2.10 of swarf17.1018.301.20
Bought-in parts9.409.400.00
CNC machining29.7538.258.50
Set-up0.340.340.00
Assembly and inspection9.509.500.00
Anodising4.804.800.00
Manufacturing cost70.8980.599.70
Reject allowance1.421.610.19
SG&A7.239.862.63
Profit6.367.371.01
Packaging and freight2.602.600.00
Price per unit88.50102.0313.53

The result

The supplier's price is 15.3 per cent above the should-cost (the gap is 13.3 per cent of the quote). On 40,000 units a year, 4,081,252 of spend, that is 541,185 a year. Changing one driver at a time from the should-cost to the supplier's figure, cumulatively and in the order metal, cycle time, SG&A, attributes the gap:

The negotiation now has an agenda. The metal price can be checked against the index and, better, written into a price adjustment clause so that neither side carries it. The SG&A rate is a policy question. The cycle time is an engineering question, and it is where the money is.

Notice that the six extra minutes cost 8.50 at the machine but 10.30 in the price. Every cost gap passes through the reject allowance, the SG&A and the profit, a combined factor of 1.2118 here. Negotiating the mark-ups on a bloated cost base concedes the larger number.

What if: the two drivers that matter

Should-cost price by cycle time and by aluminium price, other inputs unchanged.
Cycle timeShould-costAluminium per kgShould-cost
18 minutes83.352.8085.59
21 minutes88.503.2088.50
24 minutes93.653.6091.41
27 minutes98.80

Each minute of cycle time is worth 1.72 on the price; each 0.40 move in the aluminium price is worth 2.91. The buyer's estimate of cycle time therefore deserves more scrutiny than any other input. If the supplier can show why the part needs 24 minutes, perhaps a second set-up for the bore, the target moves to 93.65 and the model has done its job: the gap left is the one the supplier cannot explain.

The common mistake

The common mistake is to treat the should-cost as the price to demand. It is the price an efficient supplier could charge at a fair margin, and the supplier you have may not be that supplier this year. Use it to set a target and a sequence: close the explained gaps by clause (metal indexation), the policy gaps by negotiation (SG&A), and the efficiency gaps by a dated improvement plan with the price stepping down as the cycle time does. The second mistake is to build the should-cost without the swarf credit or the reject allowance. Both are small per unit and both are real, and a model that misses them loses the supplier's trust in the first five minutes.

Takeaway

A should-cost sets the target price; the clauses decide whether the price holds. How a metal index should be weighted from the same cost breakdown is worked in how a price adjustment formula works, and how to compare the result with a second bid in how to compare two supplier bids on total cost. The book prices every clause of two real bids as money, in the free workbook for this case on the Contract Management companion page.

Questions readers ask

What is the difference between should-cost and cost-plus?

Cost-plus starts from the supplier's actual costs and adds a margin, so inefficiency is paid for. Should-cost starts from what the part ought to cost an efficient producer. In the illustrative case the supplier's own breakdown gives 102.03 while the should-cost, at the same 8 per cent profit, is 88.50: the 13.53 difference is the inefficiency a cost-plus price would have accepted.

How accurate does a should-cost model need to be?

Accurate on the drivers that move the price, approximate elsewhere. In the illustrative case one minute of cycle time is worth 1.72 a unit and a 0.40 move in the aluminium price 2.91, while set-up adds only 0.34 in total. Spend the engineering effort on cycle time and material, and accept rough figures on the small lines.

Should a buyer share the should-cost model with the supplier?

Usually the drivers, not the spreadsheet. Saying the operation should take 21 minutes, not 27, invites the supplier to explain or improve; that one driver is 10.30 of a 13.53 gap. Handing over the whole model invites an argument about every cell, including the profit margin, which the buyer has set equal to the supplier's on purpose.

Read the whole case

This article is one calculation from Contract Management. The book takes the same case from first principles to the decision, chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.

Get the book on Amazon →Free companion files

Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada

Also on this site

Reading guide: business operations: cost, contracts, pricing and supply chain → · All 1340 articles →

If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.