Free Garment Cost Sheet Template (Excel)

List your materials and labor, and see the cost of one garment, the landed cost and your wholesale and retail prices.

By Apparel Search · Updated October 2026

This one-sheet Excel template calculates the cost per garment from your materials (with a waste allowance on each), labor and overhead. Add duty, freight, insurance and other costs to get the landed cost per garment, then set a wholesale margin and retailer markup to see wholesale and suggested retail prices. All the formulas are built in, and the example figures are placeholders.

Free downloadDownload Excel template (.xlsx)Free to use in your own business. Please do not sell or republish the file as your own. Opens in Microsoft Excel, and can also be opened in Google Sheets or LibreOffice, though some formatting may differ. The sheets are protected without a password so formulas and the Apparel Search credit are not overwritten by accident. To customize, choose Review > Unprotect Sheet.

Want it in your browser? Use the free Garment Cost Sheet and Landed Cost Calculator.

1. Enter your order details

Fill in the style, the number of garments, overhead and profit percentage, duty rate, freight, insurance, other landed costs, wholesale margin and retailer markup.

2. List the materials

For each material, enter the quantity per garment, unit, price and waste percentage. Cost per garment = quantity x (1 + waste) x price.

3. Add labor and processing

Enter cut, make and trim (CMT), finishing and any other per-garment costs.

4. Read the results

The results block shows the factory cost per garment and per order, then the landed cost, wholesale price and suggested retail price.

Common mistakes

Using a selling price where the factory cost belongs.
Leaving out waste, so fabric cost is understated.
Forgetting freight, duty and fees.
Entering percentages as whole numbers instead of percent values.

Questions

Is this garment cost sheet template free?

Yes. It is free to use in your own business. Please do not sell or republish the file as your own.

How is cost per garment calculated?

Each material costs quantity x (1 + waste %) x price. The sheet adds materials, labor and overhead to get the factory cost per garment.

Does it include duty and freight?

Yes. The landed cost section applies your duty rate to the goods value and adds freight, insurance and other costs. Use current rates from your customs broker.

How is the wholesale price calculated?

Wholesale price = landed cost / (1 - wholesale margin). The suggested retail price multiplies the wholesale price by your retailer markup.

Keep going

For general information only. These templates are starting points for general use and are not legal, financial or compliance advice. Confirm specifications and requirements with your factory and qualified professionals. Apparel Search does not endorse any company listed in its directory. See our Legal page.