# Garment Costing Sheet Excel Template (Free)

> A free garment costing sheet for Excel: BOM per style, CMT, overhead, FOB and landed cost, wholesale and retail price with a margin or markup toggle.

Source: https://softwiro.com/templates/garment-costing-sheet
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Garment Costing Sheet for Excel

A free garment costing sheet for an apparel brand, a designer or a small cut-and-sew factory. Keep one library of fabrics and trims with their prices, build each style as a bill of materials (BOM) with fabric consumption and waste, add CMT (cut, make, trim) and any washing, embroidery or printing, and the sheet builds the cost up to FOB and landed cost, then compares it with the wholesale and retail price you plan to charge. Pick a style on the Cost Sheet and see the whole build-up on one page, or put two styles side by side. Orders are costed by size run. It opens in Excel, LibreOffice and Google Sheets, and it works in any currency, in yards or metres.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-garment-costing-sheet.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-garment-costing-sheet-blank.xlsx)

Excel file (.xlsx) · 111 KB · 9 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| Pricing target | 50.0% | Margin | Change the target, margin or markup basis, overhead and freight on the Settings sheet. |  |  |
| --- | --- | --- | --- | --- | --- |
|  |  |  |  |  |  |
| Styles listed | 10 |  | Orders |  | 9 |
| Priced styles | 9 |  | Units ordered |  | 1,700 |
| Below target | 3 |  | Order cost (landed) |  | 32,979.02 |
| Margin, all priced styles | 49.8% |  | Order revenue |  | 63,700.00 |
| Highest margin style | JK-7001 |  | Order profit |  | 31,473.76 |
| Lowest margin style | DR-6001 |  | Order margin |  | 49.4% |
| Style | Landed cost | Wholesale price | Margin / markup | Target | Profit per unit |
| TS-1001 | 11.12 | 22.50 | 50.6% | 50.0% | 11.38 |
| TS-1002 | 12.55 |  |  | 50.0% |  |
| HD-2001 | 25.97 | 54.00 | 51.9% | 50.0% | 28.03 |
| JG-3001 | 18.84 | 38.00 | 50.4% | 50.0% | 19.16 |
| WS-4001 | 20.27 | 38.00 | 46.7% | 50.0% | 17.73 |
| CH-5001 | 21.83 | 42.00 | 48.0% | 50.0% | 20.17 |
| DR-6001 | 39.08 | 72.00 | 45.7% | 50.0% | 32.92 |
| JK-7001 | 21.22 | 46.00 | 53.9% | 50.0% | 24.78 |
| PL-8001 | 14.08 | 30.00 | 53.1% | 50.0% | 15.92 |
| SW-9001 | 7.26 | 15.00 | 51.6% | 50.0% | 7.74 |
|  |  |  |  |  |  |
|  |  |  |  |  |  |
| Average cost per unit | Per unit | Share of landed |  | Size | Units |
| Fabric | 9.45 | 47.3% |  | XS | 105 |
| Trims and packaging | 1.05 | 5.3% |  | S | 425 |
| CMT | 5.32 | 26.7% |  | M | 580 |
| Washing, embroidery, print | 0.51 | 2.5% |  | L | 425 |
| Other | 0.18 | 0.9% |  | XL | 165 |
| Overhead | 1.32 | 6.6% |  |  |  |
| Freight and duty | 2.14 | 10.7% |  |  |  |

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

## What is inside

- Dashboard: Styles listed, priced and below target, the margin across all priced styles, the highest and lowest margin style, and order totals (orders, units, cost, revenue, profit, margin). A table of the first 12 styles, ranked tables of the five highest and five lowest margins, and four charts: landed cost against wholesale price, margin or markup against the target, where the landed cost goes, and units ordered by size.
- Cost Sheet: Pick a style and see its cost build-up per piece: fabric, trims and packaging, CMT, washing or embroidery or printing, other, overhead, freight and duty, FOB cost, landed cost, suggested and actual wholesale price, profit, margin, markup and retail price. Each line also shows its share of the landed cost. Pick a second style to compare line by line. Below, the style's bill of materials with quantity, waste and line cost.
- Styles: One row per style: description, category, season, MOQ, CMT, processes, other cost, wholesale price and retail price. The sheet adds fabric and trims from the BOM, overhead, FOB, freight, landed cost, suggested wholesale price, margin, markup, profit per unit, a status (On target, Below target, No price, No BOM) and a margin rank. Room for 60 styles.
- BOM: One row per material in a garment: pick the style and the material, type the quantity per garment and the waste %. The type, unit, price and line cost come from the Materials sheet, and a Check column catches a style or material that is not on your lists. Room for 500 lines.
- Materials: Your fabric and trims library: type (fabric, trim or packaging), unit, price per unit, supplier and supplier MOQ. Fabric is priced per yard or metre depending on your setting, and the sheet counts how many BOM lines use each material. Room for 100 materials.
- Orders: One row per order: customer, style and a size run (XS to XL). The sheet adds total units, landed cost and price per unit, total cost, total revenue, profit and margin, and flags an order that is below the style MOQ or has no price. You can type an agreed price that differs from the list wholesale price. Room for 100 orders.
- Settings: Business name, currency symbol, fabric unit (yards or metres), overhead %, freight and duty %, and the pricing target: a margin or a markup, and the percentage.

The file opens on a start tab (“Start here”) that explains how to use it.

## What makes it different

Most garment cost sheets are a single page where you type every number again for every style. This one keeps materials, styles and orders on separate sheets, so changing the price of a fabric updates every style that uses it, and changing your freight % updates every landed cost. A switch on Settings decides whether your target is a margin or a markup, because mixing the two up is one of the most common pricing mistakes. The sample is a small brand with 21 materials, 10 styles and 9 orders.

## How do I calculate the cost of a garment in Excel?

Start with the bill of materials. For each material, multiply the quantity per garment by the price, allowing for waste: in the sample, the Heavyweight hoodie (HD-2001) uses 1.95 yards of fleece at 6.20 with 5% waste, which is 12.69, plus 0.30 yards of jersey for the hood lining. Fabric comes to 13.99 and trims and packaging to 1.18.

Add CMT (5.20 for cutting, making and trimming), the embroidery or washing cost (0.90) and other costs (0.20), then overhead as a percentage of those lines (8% gives 1.72). That is the FOB cost: 23.18. Add freight, duty and handling (12% of FOB, 2.78) and you have a landed cost of 25.97 per hoodie. Every line is a separate cell, so you can see which one moves the total.

## What is the difference between margin and markup, and how do I set a wholesale price?

Markup is profit as a share of cost. Margin is profit as a share of the selling price. The hoodie sells at 54.00 wholesale, so profit is 28.03: a margin of 51.9% and a markup of 108.0%. A 50% margin is the same as a 100% markup, which is why people who mix the two end up with prices that are too low. On Settings you choose which one your target uses; both are shown on every style.

The suggested wholesale price is the landed cost divided by (1 - target margin), or the landed cost times (1 + target markup). For the hoodie at a 50% margin that is 51.93. It is a starting point: round it to a price you will quote, then check the margin and your retail price. Three styles in the sample, the shirt, the chino and the dress, sit below the 50% target, and the Dashboard shows them in red.

## How do I cost an order by size run, and what about MOQ?

On the Orders sheet type the quantity for each size. The sheet adds the units, multiplies by the landed cost for total cost and by the wholesale price for total revenue, and shows profit and margin. In the sample, nine orders add up to 1,700 units with 63,700.00 of revenue on the eight priced orders, and units split 105 / 425 / 580 / 425 / 165 across XS to XL.

Each style has an MOQ. An order under it, such as 120 coach jackets against an MOQ of 150, shows Below MOQ so you can decide whether to ask for more, accept a higher price or push back on the factory. Your real MOQs depend on your factory and fabric supplier; check them before you commit. For the stock side of a clothing business, see the [clothing store inventory](https://softwiro.com/templates/clothing-store-inventory-tracker) template, and for money in and out the [cash flow forecast](https://softwiro.com/templates/cash-flow-forecast).

## How to use it

1. On the Settings sheet type your business name, the fabric unit you buy in (yards or metres), your overhead %, freight and duty % and your target margin. Choose whether the target is a margin or a markup.
2. On the Materials sheet list every fabric, trim and packaging item with its price per unit. Fabric is priced per yard or per metre, whichever you set.
3. On the Styles sheet list each style number with its description, MOQ, CMT (cut, make, trim) cost per piece, any washing, embroidery or printing cost, and the wholesale and retail price you plan to charge.
4. On the BOM sheet build each style: pick the style and the material, type the quantity per garment (fabric consumption in yards or metres) and the waste or wastage %.
5. On the Cost Sheet pick a style to see the full cost build-up and the pricing, and pick a second style to compare them line by line.
6. On the Orders sheet type each order with its size run. The sheet works out total units, total cost, total revenue and profit, and flags an order below the style MOQ.

**Before you start:**

- Capacity: 100 materials, 60 styles, 500 bill of materials lines (the Cost Sheet lists the first 15 lines of a style, but the totals count all of them) and 100 orders.
- Overhead % is applied to fabric, trims, CMT, processes and other cost. Freight, duty and handling % is applied to the FOB cost to give the landed cost.
- Margin means profit as a share of the selling price. Markup means profit as a share of cost. The toggle on Settings decides which one your target and the Dashboard use; both are shown for every style.
- The suggested wholesale price is the landed cost divided by (1 - target margin), or the landed cost times (1 + target markup). Round it to a price you will quote.
- The fabric unit on Settings is only a label: type consumption and price in the same unit. Use one currency in one workbook.
- The Dashboard charts show the first 12 styles on the Styles sheet.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-garment-costing-sheet.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-garment-costing-sheet-blank.xlsx)

Excel file (.xlsx) · 111 KB · 9 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Still running this on Excel?

This sheet gives you an estimated cost before production starts. ProTrack ties every stage of an order to its actual cost and to the contract, so a cost overrun shows up while you can still fix it.

| In this sheet | In ProTrack |
| --- | --- |
| The cost here is an estimate made before production starts. | It compares the cost of each stage (materials, labor, machine hours, subcontractor) with what was estimated in the quotation, and works out the cost per piece. |
| You find out the cost exceeded the price after the order is finished. | It calculates expected and actual profit as the work progresses, and alerts you when cost passes 80% and then 100% of the contract value. |
| You phone the departments to find out where each order stands. | Workers log their output from their phones with a simple code, and you see each order's current stage and progress percentage on your own phone. |
| Pieces sent out to the laundry or the print shop are tracked from memory. | It records what went out, what came back, what was rejected and what is still outside, and adds the cost to the order. |

[See ProTrack](https://softwiro.com/product/protrack) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| You estimate the cost before production starts | Estimated and actual cost side by side for every order |
| You find out the margin slipped after the order ships | Alerts while there is still time to act |
| You phone the floor to see where an order stands | Stage and progress visible on your phone |
| Washing and print jobs are tracked from memory | What went out, came back and was rejected, with the cost |
| One person edits the file at a time | A login for every team member |

### Extra features in the app

- Cost of each production stage compared with the quotation, while the order runs
- Actual cost per piece worked out as workers log their output from their phones
- Expected and actual profit, with an alert when cost passes 80% and then 100% of the contract value
- Pieces sent to the laundry or print shop tracked out and back, with rejects and cost added to the order
- Current stage and progress of every order on your own phone
- A login for each merchandiser, planner and supervisor

[Ask for your custom system](https://softwiro.com/contact)

## Frequently asked questions

### Is this garment costing sheet free?

Yes. Download it, use it for your brand or factory and change anything you like. Nothing to sign up for to open the file.

### Can I use metres instead of yards?

Yes. Choose yards or metres on Settings. It is a label, so type fabric consumption and fabric price in the same unit and the maths works either way.

### Does it work in Google Sheets and LibreOffice?

Yes. It uses ordinary formulas such as SUMIFS, COUNTIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets.

### Where do I put washing, embroidery or printing?

In the washing, embroidery, print column on the Styles sheet, as a cost per piece. Overhead is then added on top of it. If a laundry or print shop charges per piece, type that charge.

### How many styles and BOM lines can it hold?

60 styles, 100 materials, 500 BOM lines and 100 orders. The Cost Sheet lists the first 15 BOM lines of a style but the totals count every line.

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

All the templates in this group: [Factory management sheets: production, cost and quality](https://softwiro.com/templates/for-factories)

More free templates for: Garment factories

## More free templates

- Piece Rate Payroll Calculator for Excel
- Fabric requirements and marker sheet
- Garment printing shop sheet in Excel: DTF and screen print orders and cost
- Poultry Flock Tracker for Excel: Eggs, Feed, Mortality and Profit
- Dental Practice Treatment Plan Tracker for Excel
- Travel Agency Booking Tracker for Excel
- Generator Maintenance Log Template for Excel
- Equipment Inspection Log Template for Excel
- Coffee Roasting Log and Costing Spreadsheet for Excel
- Hotel Guest Folio Template for Excel (Rooms, Reservations, Billing)
- Auto Parts Inventory and Sales Spreadsheet for Excel

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
