Costing Sheet · live data trace
Style #K-2208 · PO 4471
Crew-neck tee · 8,400 pcs · Buyer A (export)
Buyer pays
₹340/pc
🔒 locked on the order
Your data sources
🗄️
ERP / system
live · reconciled
📄
Spreadsheet
manual · unverified
✎
Manual allocation
estimated
Cost component₹/pc
Knitted fabric₹128
Cutting₹12
Dyeing & wet process₹54
Sewing — labour (SAM)₹62
Trims & packing₹18
Finishing₹14
Overhead (allocated)₹24
Total cost / pc₹312+₹55 · from 3 manual lines
Buyer ₹340 − cost ₹312 =
+₹28you keep · +8%
Ships at a lossspreadsheet ≠ actual
✓Costed and on plan — quoted at +8% margin.Every line is sourced from your ERP and your spreadsheets. Looks healthy… until you reconcile.
⚠ Every line bleeding your margin comes from a spreadsheet — not your ERP.
Dye-lot and labour SAM are typed by hand and never reconcile to actuals — so this PO of 8,400 pcs is quietly ~₹2.3 lakh in the red. Move those two lines into the system and the loss shows up the day it happens.
Illustrative · representative model, not a client.