Garment Costing Sheet

What this template does#

The costing sheet turns a list of cost elements into a quotation. You enter quantities per dozen and unit prices; the sheet calculates cost per dozen and per piece for each line, totals the manufacturing cost, adds commercial cost and profit, and shows FOB per dozen, FOB per piece and the order value.

It follows the method in garment costing. The example rows are for a basic T-shirt so you can see how each line works; replace them with your own.

When to use it#

• At enquiry stage, to prepare a first quotation.
• After sampling, to update the cost with final consumption, trims and SMV.
• After shipment, to compare quoted costs with actual costs.

How to complete it#

1. Fill in the header: buyer, style, currency and order quantity.
2. Add fabric lines. Calculate consumption per dozen first, with the T-shirt consumption calculator or from the marker. Enter it with the price per kg or per meter.
3. Add every trim from the bill of materials. For items bought per garment, the quantity per dozen is 12 (or 24 for two per garment).
4. Add CM as one line with quantity 1 dozen and the CM per dozen as the unit price. Use the CM cost calculator to work it out.
5. Add processes and testing: printing, embroidery, washing and the test cost spread over the order.
6. Set commercial and profit percentages in the summary.
7. Check the totals: compare fabric share, trims share and CM with similar styles you have produced.

Common mistakes#

• Entering quantity per piece in the "Qty per dozen" column. Multiply by 12.
• Forgetting packing materials and the carton share.
• Leaving an old fabric price after the buyer changes the quality.
• Overwriting the grey calculated cells, which breaks the totals.

Download formats#

The Excel workbook includes all formulas, drop-down lists for categories and a print layout that fits one page wide. The CSV contains the column headings and example rows only, for importing into other systems.