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.
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:
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.
| Term | Meaning |
|---|---|
| Cost component | One part of a garment's total price: fabric, trims, making, overhead, or profit. |
| Share of price | One cost component's dollar value divided by the total price, usually shown as a percentage. |
| Formula | An instruction in a spreadsheet cell that calculates a value from other cells, instead of a value typed in by hand. |
| Target figure | The figure a person aims for going into a negotiation, more favourable than the walk-away position. |
| Walk-away position | The least favourable figure a person will still accept before ending the negotiation without an agreement. |
| Negotiating position | The target figure, walk-away figure and concession options a person prepares before a negotiation, rather than deciding them during the call. |
| Ex-factory price | 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 | A company that runs Make to Order and Make to Stock lines side by side, usually split by customer, product line or channel. |
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.
| What can differ | The shapes you will meet | Why it matters to you |
|---|---|---|
| Export or domestic finished sheet | An 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 sheet | A 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 used | Some 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 not | A 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. |
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 sheet | What 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 |
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.
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.
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:
Is sending only this line as good as sending it with the full costing sheet attached? Decide before opening the answer.
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.
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.
Keeping the complete, four-piece sheet on file, rather than only the final number, is what avoids paying this same cost repeatedly.
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)
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?
| EN | AR | FR | TR | Meaning |
|---|---|---|---|---|
| Cost component | عنصر التكلفة | Élément de coût | Maliyet bileşeni | One part of a garment's total price: fabric, trims, making, overhead, or profit. |
| Share of price | نسبة السعر | Part du prix | Fiyat payı | One cost component's dollar value divided by the total price, usually shown as a percentage. |
| Formula | صيغة حسابية | Formule | Formül | An instruction in a spreadsheet cell that calculates a value from other cells, instead of a value typed in by hand. |
| Target figure | الرقم المستهدف | Chiffre cible | Hedef rakam | The figure a person aims for going into a negotiation, more favourable than the walk-away position. |
| Walk-away position | موقف الانسحاب | Position de repli | Çekilme pozisyonu | The least favourable figure a person will still accept before ending the negotiation without an agreement. |
| Negotiating position | موقف تفاوضي | Position de négociation | Müzakere pozisyonu | The 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 usine | Fabrika çı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 hybride | Hibrit üretim modeli | A company that runs Make to Order and Make to Stock lines side by side, usually split by customer, product line or channel. |
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