Costing & FinanceFree worksheetPDF, Excel, Word exportTextile and Apparel

Garment Costing Worksheet (Excel Export)

A style cost sheet is the document a merchandiser and a plant manager argue over before every order. This worksheet lists each cost line with consumption, rate and wastage, then totals the cost per garment and shows two common quoting methods.

Download:

Cost item	Group	UoM	Consumption per garment	Rate	Wastage %	Cost per garment
						$6
						$0
						$0
						$0
						$1
						$0
						$0

Total cost per garment

Quote price at 12% margin on price

Quote price at 15% cost plus

Cost lines

Margin on price divides cost by (1 minus margin). Cost plus multiplies cost by (1 plus markup). The two give different prices for the same percentage, so state which one your buyer expects.

Costing data from your ERP

Optional: a short note on pre-filling style cost sheets from BOM, routing and purchase prices.

Optional. The tool and every export work without this. No spam.

How to fill it in

Add one row per cost item. For materials enter consumption per garment and the purchase rate. For labour enter the standard minute value of the style and the cost per minute of your line. Put wastage on each row, because trims and fabric waste at different rates. The extended column multiplies consumption, rate and one plus wastage. Edit, add or delete rows, then export to Excel to send to the buyer or finance.

Use SAM from your time study for CMT lines, not a rough guess.
Convert thread to metres per garment from the stitch length and seam length.
Keep overhead as its own group so it can be challenged separately.

Quote price methods

Many apparel buyers ask for FOB price built from cost plus a target margin. Margin on price divides the cost by (1 minus margin), so a 12 percent margin on price needs a bigger uplift than 12 percent markup. Cost plus applies a straight multiplier. The summary shows both so you can see the gap before you quote.

Common mistakes

The most common error is costing at 100 percent efficiency, then running the line at 60 percent. Use the CMT rate that reflects your real line efficiency or load the difference into overhead. Others include forgetting wash and finishing, leaving out freight to the buyer's port, and using last season's fabric rate after a price change.

Refresh rates from the latest purchase order before every quote.
Record the cost basis date and currency in the file name.
Re-cost the style after the first production cut report.

ERP notes

In ERP the same cost structure is a BOM plus routing with standard cost roll-up. If the standard cost rolled up from the system differs sharply from this sheet, check that routing minutes, scrap percentages and overhead rates match what the costing team assumes.

Frequently Asked Questions

What does a garment cost sheet include?

Fabric, trims, labour or cut-make-trim, packing, washing or finishing, overhead, freight and a profit margin. Each material line carries a consumption and a wastage allowance so the true cost per garment is visible.

How do I calculate CMT cost per garment?

Multiply the standard minute value of the garment by your cost per sewing minute. Cost per minute is total line labour and running cost divided by the productive minutes available at your actual efficiency.

Margin or markup, which should I quote?

Follow what the buyer or your finance team defines. A 15 percent markup on cost and a 15 percent margin on price are different numbers, and mixing them is a frequent source of dispute.

How often should I update the sheet?

Update it whenever fabric, trim or labour rates change, and again after the first production cut report shows actual consumption. Treat it as a living document tied to the style.

If costing sheets are rebuilt in Excel for every order, Netray can help pull BOM, routing and latest PO prices from your ERP so the sheet starts pre-filled.

Talk to an Expert Explore More Free Tools

Related Tools

Industry Templates

More Costing & Finance tools

See all

Back to All Tools