04Build 04 · Quote vs actual
Style 2231 was quoted at 14%. It is running at 6.8%, and 38% of it is still uncut.
The costing sheet is typed once, at quote time. The dyer’s new rate arrives as a WhatsApp, the yarn price in a Tally purchase, the wastage in a cutting report — and nobody puts them back against the quote until the year is over.
- quoted margin, actual margin
- 14.0% → 6.8%
- lost on this order if nothing changes
- ₹2.29 L
- of the order still uncut, still fixable
- 38%
Every actual is a dial on the “Style P&L” tab. Push the dyer’s rate to 125 or the rejections to 8% and watch the margin, the loss on the order and the repeat price move.
Priya Nair’s phone
18:12
Pawan · Hindon Dye Works
last seen today at 18:30
22 SEPTEMBER
Costing · style 2231 · Hafenmode GmbH · PO 4471
FileEditViewInsertFormatDataTools
D3fx
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Cost head | Unit | Quoted (Jul) | Actual | Δ | Source of actual |
| 2 | Yarn · organic 30s combed | ₹/kg | 420 | |||
| 3 | Knitting (job work) | ₹/kg | 28 | |||
| 4 | Dyeing · reactive, medium | ₹/kg | 95 | |||
| 5 | Compacting | ₹/kg | 10 | |||
| 6 | Process loss | % | 12.0 | |||
| 7 | Consumption | kg/pc | 0.260 | |||
| 8 | Screen print · 1 colour | ₹/pc | 12.00 | |||
| 9 | Cut, make, trim (in-house) | ₹/pc | 78.00 | |||
| 10 | Labels, hangtag, polybag, carton share | ₹/pc | 30.00 | |||
| 11 | Finishing & pressing | ₹/pc | 9.00 | |||
| 12 | Testing & inspection | ₹/pc | 4.00 | |||
| 13 | Inland freight, CHA, port | ₹/pc | 8.00 | |||
| 14 | Factory overhead | ₹/pc | 58.00 | |||
| 15 | Finance cost (LC at sight) | ₹/pc | 10.00 | |||
| 16 | Rejection allowance | % | 3.0 | |||
| 17 | Cost per piece | ₹/pc | 383.9 | |||
| 18 | FOB EUR 4.40 × ₹101.40 | ₹/pc | 446.2 | |||
| 19 | Margin | % | 14.0% |
+
Tue 14 JulStep 01 / 11
July: Priya costs style 2231 for Hafenmode GmbH at EUR 4.40 a piece. At ₹101.4 to the euro, that is a 14.0% margin. The sheet is filed and nobody opens it again.
01 · Reads
- Inbound RFQs and the costing template
- Actual consumption from your sheets or Tally
- Job-work rates as they change
02 · Checks
- Quoted consumption versus actual, per style
- Did a dyeing or trim rate move after the quote went out?
- Which live orders are now below their quoted margin?
03 · Tells
- The merchandiser, while the order can still be corrected
- You, with a ranked list of the styles losing money
Already out there, said honestly: Garment ERPs do this properly — if you adopt one. For a firm running on Tally plus Excel, this bridges the two without a migration nobody has time for.
The paper in this scene · open, print or download
Next · Build 05Certificate vault→