Course contents
Practitioner · Course 4: Build and Review the Final Price · Lesson 5 of 5

Building a complete, negotiation-ready costing sheet for an order

Level: PractitionerTime: 50 minutesOrder used: A (the T-shirt), reused for a hybrid domestic order at Delta GarmentsTool: Final costing sheet
This lesson is for anyone who must bring every piece of a costing sheet together into one document ready for a real negotiation: a merchandiser, a factory owner, a buyer, or a student. Lessons 4.1 through 4.4 are helpful but not required. Money figures are teaching examples in US dollars.
FactoryDelta Garments (hybrid MTO and MTS lines)
Domestic customerCedar & Co. (12 shops, Make to Stock)
Reference figuresOrder A's own fixed cost components, reused as the base
Asking priceUSD 3.20 per piece, ex-factory
Illustrative target priceUSD 3.00 per piece, teaching example
Business modelHybrid (export MTO and domestic MTS lines)
02Opening

This page is for anyone who must bring every piece of costing work together into one negotiation-ready sheet

Building a complete, negotiation-ready costing sheet means combining everything this course has taught, the assembled five components (lesson 4.1), the comparison against a buyer's target figure (lesson 4.2), the flex points already checked (lesson 4.3), and the evidence for any price change already explained (lesson 4.4), into one document that is ready to defend in front of a buyer without further preparation. This lesson mainly teaches the money flow of an order: the point where every separate skill in this course becomes one finished tool. Without this final assembly, a merchandiser walks into a negotiation holding four separate pieces of work instead of one coherent sheet, and has to reconstruct the argument on the spot instead of simply presenting it. This page shows you the general rule for finishing a negotiation-ready sheet, the shapes this takes in real life, and one worked case, Delta Garments building a complete sheet for a hybrid domestic order with Cedar & Co.

03Before you start

What you need, and what this lesson does not cover

You need: everything from lessons 4.1 to 4.4: an assembled costing sheet, a stated price gap against a target figure, checked flex points, and evidence for any changed component. You do not need any new calculation here; this lesson only teaches how to bring existing work together into one finished document.

By the end of this lesson you can:

  • list the four pieces a negotiation-ready costing sheet must include;
  • check that every figure in the finished sheet still traces back to a formula, never a typed number;
  • present the asking price, the target figure, the price gap, and the flex already found, in one coherent document;
  • adapt the same finished sheet to an export FOB order or a domestic ex-factory order;
  • explain why a negotiation-ready sheet is judged by what it lets the other side verify, not by how confident it sounds.

Not covered here: this is the final lesson of the course; earlier lessons cover assembly (4.1), comparison (4.2), flex (4.3) and evidence (4.4) in full.

04Key terms

Words you will meet in this lesson

TermMeaning
Cost componentOne part of a garment's total price: fabric, trims, making, overhead, or profit.
Share of priceOne cost component's dollar value divided by the total price, usually shown as a percentage.
FormulaAn instruction in a spreadsheet cell that calculates a value from other cells, instead of a value typed in by hand.
Target figureThe figure a person aims for going into a negotiation, more favourable than the walk-away position.
Walk-away positionThe least favourable figure a person will still accept before ending the negotiation without an agreement.
Negotiating positionThe target figure, walk-away figure and concession options a person prepares before a negotiation, rather than deciding them during the call.
Ex-factory priceWhat the buyer pays the factory for the finished goods, at the factory's own gate, before any delivery cost is added.
Hybrid production modelA company that runs Make to Order and Make to Stock lines side by side, usually split by customer, product line or channel.
05Teaching
The rule

A negotiation-ready costing sheet contains four things together, not any one of them alone

A costing sheet is ready for a real negotiation only once it shows the assembled components with their formula-driven shares (lesson 4.1), the asking price compared against a stated target figure with the gap named (lesson 4.2), the flex points already checked in the order cheapest-first (lesson 4.3), and, if any component has already changed, the evidence for that change shown as an old-value-to-new-value comparison (lesson 4.4). A sheet missing any one of these four pieces is not yet negotiation-ready: an assembled sheet with no target comparison cannot answer "is this price fair"; a target comparison with no flex check cannot answer "what can move"; a flex check with no evidence trail cannot answer "why did this number change." Bringing all four together, on one document, using only formulas, is what this final lesson finishes.

Order A's asking price, assembled: fabric 1.15 + trims 0.20 + making 1.10 = 2.45, plus overhead 0.49 + profit 0.26 = 3.20
What you meet in real life

The same four-piece structure applies to every negotiation-ready sheet, but which market and which business model it serves differs

What can differThe shapes you will meetWhy it matters to you
Export or domestic finished sheetAn export negotiation-ready sheet ends in an FOB asking price, compared against an overseas buyer's target figure. A domestic negotiation-ready sheet, such as Delta Garments' own sheet for Cedar & Co., ends in an ex-factory price, compared against a domestic customer's own target figure.The four-piece structure is identical; only the price label and which company sits on the buyer side of the comparison change.
Make to Order, Make to Stock, or hybrid finished sheetA Make to Order sheet is built fresh for one confirmed order. A Make to Stock sheet is built once and reused across repeat orders of the same style. A factory running a hybrid production model, like Delta Garments serving both Northline Apparel's Make to Order export line and Cedar & Co.'s Make to Stock domestic line, keeps two separate negotiation-ready sheets from the same underlying cost components.The four pieces of a negotiation-ready sheet do not change with the business model; only how often the sheet is rebuilt, and how many versions exist at once, does.
A sheet with no flex needed or a sheet with flex already usedSome negotiations close at the first asking price, with no gap to flex. Others, like Cedar & Co.'s in lesson 4.3, have already absorbed part of a gap through a flex point before the sheet is finalised.A finished sheet should show whether flex was needed and used, not hide that history; a buyer trusts a sheet more when it shows its own working, not just its final numbers.
A sheet needing evidence for a change or one that does notA first-time quote needs no evidence section, since nothing has changed yet. A revised quote, like the fabric price rise in lesson 4.4, needs the old-value-to-new-value comparison included, not just the new total.A negotiation-ready sheet adapts to what stage the negotiation is at; it always contains the same four pieces, but not every piece has content to show on every occasion.
The case we follow

Delta Garments builds a complete negotiation-ready sheet for a hybrid domestic order with Cedar & Co.

Delta Garments, running a hybrid production model, builds a domestic negotiation-ready sheet for Cedar & Co.'s repeat Make to Stock order, reusing Order A's own fixed cost components as the base: fabric 1.15, trims 0.20, making 1.10, overhead 0.49, profit 0.26, an ex-factory asking price of 3.20. Against Cedar & Co.'s illustrative target figure of 3.00, a price gap of 0.20 exists (lesson 4.2). Lesson 4.3 already found that a lower-cost trim can absorb 0.05 of that gap, leaving profit to absorb only 0.15, not the full 0.20. No component has changed since the original quote, so no evidence section is needed this time. Delta Garments assembles all of this into one finished sheet before its next conversation with Cedar & Co.

Piece of the sheetWhat it shows for this order
Assembled components (4.1)Fabric 1.15, trims 0.20, making 1.10, overhead 0.49, profit 0.26; total 3.20, all formula-driven
Comparison against target (4.2)Asking price 3.20 vs illustrative target 3.00; price gap 0.20
Flex already checked (4.3)Trims flex of 0.05 found; profit absorbs the remaining 0.15, leaving 0.11 profit standing
Evidence for any change (4.4)Not needed this time; no component has changed since the original quote
The worked number

The finished sheet's own numbers must still reconcile exactly, component by component

Cost before profit after the trims flex: fabric 1.15 + trims 0.15 (0.20 minus the 0.05 flex) = 1.30
Cost before profit: 1.30 + making 1.10 = 2.40
Cost before profit: 2.40 + overhead 0.49 = 2.89
Final price after flexing profit to 0.11: 2.89 + 0.11 = 3.00, exactly matching Cedar & Co.'s illustrative target figure
Original asking price: 3.20 USDFabric, trims, making, overhead, profitFinal negotiated price: 3.00 USDTrims flexed 0.05, profit flexed 0.15
The finished sheet shows exactly how 3.20 became 3.00. Every dollar of the reduction traces to a named flex point, not an unexplained discount.
The method

Assemble a negotiation-ready costing sheet in five steps

  1. Confirm the assembled sheet's five components and its formula-driven total (lesson 4.1).
  2. State the asking price against the buyer's target figure, with the price gap named in dollars and as a percentage (lesson 4.2).
  3. List every flex point already checked, cheapest-first, and how much of the gap each one absorbs (lesson 4.3).
  4. Attach an old-value-to-new-value comparison for any component that has genuinely changed, if this is a revised rather than a first quote (lesson 4.4).
  5. Check that every number across all four pieces reconciles: the flexed total must equal the asking price minus every flex applied, with no unexplained gap remaining.
The trap

A common mistake is presenting a final number without the four pieces that make it verifiable

A common mistake is walking into a negotiation with only a final price in mind, having done the assembly, the comparison, and the flex-finding work mentally rather than on the sheet itself. This leaves a merchandiser unable to show why the final number is what it is the moment a buyer asks, forcing an improvised explanation instead of a document the buyer can check line by line.

Final number only (wrong way)Complete four-piece sheet (right way)Buyer asks "why is it 3.00, not 3.20?"Merchandiser improvises an answerBuyer asks "why is it 3.00, not 3.20?"Merchandiser points to the sheet's own rowsThe answer may differ each time it is asked,weakening trust in the number itself.The same document gives the same answerevery time, to anyone who asks.
A number alone invites improvisation; a complete sheet invites verification. The same final price is trusted more when it comes with its own working attached.
06In plain words

A costing sheet is ready for a real negotiation once it shows four things together: the five cost parts added up by formula, the asking price compared against what the buyer wants to pay, which parts could move and by how much, and, if anything already changed, the old number next to the new one. Missing any of these leaves a merchandiser unable to answer a buyer's questions on the spot. Bringing all four onto one sheet, with every number checked by formula, means the same document answers every question a buyer might ask, instead of an answer being invented fresh each time.

07Quick check
  • A negotiation-ready sheet needs the assembled components, the target comparison, the flex check, and evidence for any change, all together.
  • Every number on the finished sheet should still trace to a formula, never a typed value.
  • The same four-piece structure works for an export FOB sheet and a domestic ex-factory sheet alike.
  • A sheet with flex already applied should show that flex, not hide it behind a single final number.
  • A sheet needs an evidence section only when something has actually changed since the last quote.
  • A final number without its own working forces an improvised explanation instead of a document the buyer can check.
08Workplace scenario

Mona is asked to quote Cedar & Co.'s renewed Make to Stock order with just a final number, no sheet attached

Karim tells Mona to simply send Cedar & Co. a one-line message stating the renewed order's price is USD 3.00 per piece, without attaching the underlying costing sheet showing the trims flex and the profit flex behind that number.

Here is the message Karim suggested:

Message to Cedar & Co., suggested by Karim. "Confirming the renewed order at USD 3.00 per piece, same terms as before."

Is sending only this line as good as sending it with the full costing sheet attached? Decide before opening the answer.

Show decision

Not as good, even though the number itself is correct. Two facts decide this.

First, the number alone gives Cedar & Co. no way to check it against its own expectations. Omar may ask why 3.00 and not the original 3.20, and Mona would need to reconstruct the trims-flex-plus-profit-flex explanation from memory instead of pointing to a document.

Second, a sheet Cedar & Co. can keep on file protects both sides on the next renewal. Without the sheet, the next time this style is reordered, neither side has a written record of exactly which components flexed and by how much, risking the same negotiation happening again from scratch.

Sending the full sheet alongside the one-line confirmation costs Mona little extra effort and leaves both sides with a shared, checkable record of exactly how 3.20 became 3.00.

09What it costs

Sending a bare number without the sheet risks repeating the same negotiation from scratch next time

If Cedar & Co. reorders this style again next season without a written record of the trims flex and profit flex already agreed, Delta Garments may need to spend time re-explaining and re-justifying the same USD 0.20 gap it already closed once.

If re-explaining the same gap costs an extra half-day of merchandiser time at each reorder, across four reorders a year: half a day × 4 = two full days per year spent re-proving a gap that a saved sheet would have already answered

Keeping the complete, four-piece sheet on file, rather than only the final number, is what avoids paying this same cost repeatedly.

10Working template

Final costing sheet: assemble the complete, negotiation-ready version for your own order

Using the Final costing sheet, complete all four pieces for your own order: the assembled components with their formulas, the comparison against your buyer's target figure, every flex point checked in order, and, if anything has changed since an earlier quote, the old-value-to-new-value comparison. Confirm the finished sheet's total reconciles exactly with every flex and change applied, before presenting it in any real negotiation.

[Download the Final costing sheet](../../templates/T12-C04-final-costing-sheet.xlsx)

Download the Final costing sheet (Excel)

11Check yourself

1. What four pieces must a negotiation-ready costing sheet bring together?

2. Delta Garments' original asking price is 3.20. A trims flex of 0.05 and a profit flex of 0.15 are applied. What is the final negotiated price?

3. Order B, the jeans, has a fixed asking price of USD 9.80. If a washing-cost flex of 0.10 and a making flex of 0.05 are both applied, what is the final negotiated price?

12Glossary
ENARFRTRMeaning
Cost componentعنصر التكلفةÉlément de coûtMaliyet bileşeniOne part of a garment's total price: fabric, trims, making, overhead, or profit.
Share of priceنسبة السعرPart du prixFiyat payıOne cost component's dollar value divided by the total price, usually shown as a percentage.
Formulaصيغة حسابيةFormuleFormülAn instruction in a spreadsheet cell that calculates a value from other cells, instead of a value typed in by hand.
Target figureالرقم المستهدفChiffre cibleHedef rakamThe figure a person aims for going into a negotiation, more favourable than the walk-away position.
Walk-away positionموقف الانسحابPosition de repliÇekilme pozisyonuThe least favourable figure a person will still accept before ending the negotiation without an agreement.
Negotiating positionموقف تفاوضيPosition de négociationMüzakere pozisyonuThe target figure, walk-away figure and concession options a person prepares before a negotiation, rather than deciding them during the call.
Ex-factory priceسعر خروج المصنعPrix départ usineFabrika çıkış fiyatıWhat the buyer pays the factory for the finished goods, at the factory's own gate, before any delivery cost is added.
Hybrid production modelنموذج إنتاج مختلطModèle de production hybrideHibrit üretim modeliA company that runs Make to Order and Make to Stock lines side by side, usually split by customer, product line or channel.
13Next

End of Track 12

This is the final lesson of Course 4 and of Track 12, Costing and Pricing. You can now build, compare, flex and defend a complete costing sheet for any order you meet, export or domestic, Make to Order, Make to Stock, or hybrid, from the first cost component to a finished, negotiation-ready price. Back to the course map

14Ladder

RecognizeName the four pieces a negotiation-ready costing sheet must include.
ConnectSee how the finished sheet's total reconciles the original price with every flex applied.
CompareTell a bare final number from a complete, checkable costing sheet.
DecideJudge whether a sheet is ready to present, or still missing one of its four pieces.