Clothing-Cost-Sheet.xlsxExample values
B21=IF(COUNT(B19:B20)=2,SUM(B19:B20),"")
AB
13Cut, make and trim (CMT) per piece2.50
14Decoration per piece1.50
15Packaging per piece0.40
16Inbound freight per piece0.30
17Overhead %8%
18COST PER UNIT
19Direct cost per piece7.59
20Overhead per piece0.61
21Total cost per piece8.20Your real unit cost
22PRICING
23Target wholesale margin %50%
24Wholesale price16.39
27Suggested retail price32.78
Start HereCost SheetMOQ Tiers
Clothing-Cost-Sheet.xlsxExample values
F7=IFERROR(IF(AND(COUNT(D7,$E$3)=2,$E$3>0,$E$3<=1),D7/(B7*$E$3),""),"")
ABCDFG
3Sell-through %80%
4One-off costs per order150.00
6TierQtyQuoteCash neededPer sold pcLowest?
7Tier 14810.00630.0016.41
8Tier 21449.801,561.2013.55
9Tier 33008.402,670.0011.13
10Tier 45008.004,150.0010.38Lowest
Cheapest per piece you sell, but it needs 4,150.00 in cash. The sheet shows both so you can decide.
Start HereCost SheetMOQ Tiers
Garment-Master-Order-System.xlsxFilled example
K10=IF(OR($C10="",N(J10)<=0),"",CEILING(J10/(1-set_target),set_round))
CEJKLR
9ProductQtyCOGS / pcTarget priceYour priceVerdict
10Canvas tote bag1508.0912.5011.00Below target
11Ringer tee, long sleeve1007.7112.0014.00OK
15ORDER TOTAL25035% margin
DECISION
NEGOTIATE. Margin is above your minimum but below your target. Aim for the price at target margin in the table.
Deposit (30%)915.00Materials still to fund after deposit140.31
Price BookMOWork OrderPurchasingOrders
Garment-Master-Order-System.xlsxFilled example
P17=IF(B17="","",IF(OR(K17="Delivered",K17="Closed",K17="Lost"),"",IF(O17<0,"LATE",…)))
Active orders3
Active revenue10,010
Late orders1
Balance to collect5,615
14Order no.ProductDeadlineBalance dueFlag
15MO-2026-014Canvas tote bag + 110 Dec2,135On track
16MO-2026-012Hoodie, embroidered20 Nov2,100On track
17MO-2026-011Jersey set01 Nov1,380LATE
MOWork OrderPurchasingOrdersGuide