How to fill a customer's cost breakdown form
The award is conditional and the condition is a spreadsheet. Eleven tabs, locked formulas, a material section wanting price per kilogram, a labour section wanting minutes per operation, and an overhead field that will not accept the number you actually use.
Cost breakdown forms exist to find margin. That is not cynicism, it is the stated purpose of open book costing, and understanding it is the difference between filling the form well and filling it honestly badly.
What a cost breakdown form is actually for
A buyer with 40 suppliers cannot compare 40 different quote formats, so they impose one. That is the benign reason and it is real. The form makes your number comparable to everybody else’s and to their own should-cost model.
The other reason is that a decomposed price is negotiable in a way that a single number is not. A quote saying $1.014 invites one argument. A quote showing material at $0.240 and margin at $0.396 invites 8, and every line becomes a place to push.
Neither reason means you should refuse. Refusing a cost form on a program worth having is usually the end of the conversation, and plenty of suppliers fill them without harm. The harm comes from filling them inconsistently.
Consistency is the defence.
Which sections get scrutinised
Material and margin get read first and hardest. Material because the buyer can look up a mill price and check you, and margin because it is the only line on the form that is not a cost.
Material is where most suppliers lose ground unnecessarily. If you enter the price per kilogram of the bar and they compare it to a published index, you look expensive, because your figure includes freight, cut to length and the drop you paid for. Enter the delivered cost of the material consumed per good piece, and say so in the notes.
Labour gets checked against the cycle times you stated. A form showing 4.6 seconds on an operation and a burdened rate of $95 gives them the same arithmetic you did, which is fine as long as the rate is defensible.
Overhead is where the disagreements live. Their form usually wants a percentage applied to labour, and your costing probably allocates overhead inside the rate. Entering it twice inflates you. Entering it nowhere makes your rate look impossibly low, which invites a different question.
Making the numbers reconcile to your own quote
The single most important property of a completed form is that it totals to the price you quoted. A form summing to $0.98 against a quote of $1.014 tells the buyer your quote had $0.034 of something you did not want to declare.
Where the form has no row for something you carry, do not drop it. Put it in the closest row and note what you did. Tooling amortisation, packaging, freight and PPAP recovery are the usual orphans, and each one silently deleted is margin you have given away in a document you signed.
Keep a mapping document beside the form. Every row, the quote line or lines it draws from, and any judgement you made. When the same customer sends the same form for the next part, the mapping is done and the exercise takes an hour instead of a day.
That mapping also protects you when a different person at your company fills the next one. Two suppliers cannot be inconsistent with each other, but 2 estimators at the same supplier easily can, and the buyer will notice.
The total has to match.
The rate you enter has to be the rate you actually use, which is the rate built from the ground up rather than a figure chosen to make the form look reasonable. A rate invented for a form is a number you will be asked to justify at the next price-down, and it will not reconcile to anything.
When their format does not match how you cost
Do not restructure your costing to fit somebody’s form. The form is a view of your costs, not a replacement for them, and a supplier who starts costing the way one customer’s spreadsheet wants will price every other job slightly wrong.
Translate instead. Your bill of materials and routing produce the truth. The form is an export of it, and the translation rules should be written down once and reused.
Some fields genuinely will not fit. A form assuming one machine per part on a routing with 7 operations, or wanting a single labour rate on a part touching 4 work centers, is asking for an average that misrepresents the job. Fill it with a weighted average and note the weighting.
Where a field is locked and wrong, say so in writing rather than forcing a number. A note saying the overhead field cannot accept our allocation method and the figure entered is equivalent at this volume is a professional answer that survives an audit.
What to hold back, and what not to
Give them cost. Do not give them your process advantage. A form asking for cycle time by operation is asking a reasonable question. A form asking for your speeds, feeds, tooling selection and fixture design is asking for the thing that makes you competitive.
The line is usually clear in practice. Costs and times are fair game. Methods are yours. A polite note saying the process detail is proprietary and the cost is as stated is rarely challenged, because the buyer wants the number rather than the method.
Costs are fair. Methods are yours.
There is one exception worth volunteering. If your cost is low on a line because you found a genuinely better route, saying so converts a suspicious number into a competitive advantage the buyer can defend internally. A figure 20 percent below the pack with no explanation reads as an error and gets queried.
Be careful with rate disclosure across customers. If your form to one customer shows a $95 rate and another shows $110 for the same work, and both buyers sit in the same industry, that is a conversation you may eventually have. Consistency again, for the same reason.
Never enter a number you cannot support from your own records. The form is a document you are attesting to, and a should-cost tool in their hands will find the line that does not fit the others. The defence against every question on a cost form is the same. It is what the work actually costs you, and you can show where the figure came from.