AnalystBuilt home Etsy shop

Sewing & Apparel

Garment Costing & Batch Quote

Batch cost per unit, finishing tiers, size mix, margin and a printable client quote

Garment Costing & Batch Quote: Cost a whole batch and quote it in minutes
Cost a whole batch and quote it in minutes
  • Garment Costing & Batch Quote: Cost a whole batch and quote it in minutes
  • Is this quote below target? Suggested price at your margin vs the price the client wants
  • Economy, Standard or Premium? Seconds, trims, cost and price side by side
  • All your quotes at a glance: Open and accepted value · margin by quote · cost drivers
  • Every size and fit in the batch: XS to 6XL × Short, Regular, Tall — fabric use follows the mix
  • Labor from your operation times: Seconds per operation × cost per minute, or piece rates
  • A clean quote for your client: Sizes, unit price, pattern and sample fees, deposit — no costs
  • Every quote, costed the same way: Fabric, trims, labor, decoration, overhead, margin, deposit

from $12.99 on Etsy

Price on Etsy may vary (sales, your currency).

View on Etsy
  • Google Sheets + Excel versions included
  • Instant digital download, nothing is shipped
  • Sample data and a Start Here tab
  • One-time purchase, no subscription

Works in Google Sheets (free Google account) and Microsoft Excel 2016 or newer.

Know what a batch really costs before you quote it. This garment costing calculator works out the cost of every unit in a production batch: fabric by consumption and cutting waste, trims and packaging from each style's bill of materials, sewing labor from the seconds of every operation, decoration and overhead. Then it gives you the price per unit at your target margin, the markup, the batch total and the deposit, and prints a clean one-page quote for your client.

Made for small cut-and-sew and CMT factories that sew batches of tees, long sleeves, hoodies, zip hoodies, sweatshirts and joggers for wholesale clients and clothing brands, and for brand owners who want to check a factory price. Built by a data analyst together with a working cut-and-sew workshop.

What's inside

  • Start Here

    Quick guide, your factory details for quotes and your settings: labor cost per minute and line efficiency or piece rates, overhead, target margin, margin floor, deposit, rush surcharge, fabric unit (kg, m or yd)

  • Dashboard

    Open and accepted quotes, average margin, quotes below your floor, margin by quote, price per unit by style and finishing tier, where the money goes and what needs attention

  • Batch Quote

    Pick a quote and see the size breakdown, unit cost line by line (cutting waste shown on its own), suggested and agreed price, margin, markup, batch total and deposit

  • Tier Compare

    Economy, Standard and Premium side by side for the same batch: seconds, labor, trims, cost and price, plus the operations and trims that change

  • Quote Print

    A one-page client quote with sizes, unit price, pattern and sample fees, deposit and balance (no costs shown)

  • Quote Log

    Every quote with client, style, tier, fabric, color, decoration, fees, stage and a status

  • Size Breakdown

    Quantities by size XS to 6XL, with Short, Regular and Tall fits

  • Styles

    Your style list with default fabric, consumption, cutting waste and a price list per tier

  • Operations

    The operation breakdown of each style: section, equipment, seam width, seconds and which tiers include it

  • Style Trims

    Zips, drawcords, eyelets, rib, labels and poly bags per style and tier

  • Materials

    Fabrics, trims, labels and packaging with unit prices and suppliers

Why you'll like it

  • Costs the whole batch, not one sample: bigger sizes and Tall fits use more fabric, and the size mix moves the fabric cost
  • Labor from your own operation times, at a rate per minute adjusted for your line efficiency, or from piece rates if you pay per operation
  • Three finishing tiers on one style: see what Premium adds in seconds, trims and price before the client asks
  • Decoration done in-house or supplied by the client, each costed the right way; CMT-only quotes when the client sends the fabric
  • Pattern development and samples stay separate lines, so they never hide inside the unit price
  • Flags a size split that doesn't match the batch, a style with no operations, waste above your limit and margins below your floor
  • Every number is a formula you can trace. No subscription, no app

How you get it

  1. Download on Etsy

    Buy the template on Etsy, then download START-HERE.pdf and the Excel .zip from your Purchases.

    How to download

  2. Make a copy

    Click MAKE A COPY in the PDF: your own Google Sheet is saved to your Google Drive. Prefer Excel? Open the .xlsx.

    How to make your copy

  3. Start

    Follow the Start Here tab. Type in the cream cells; the gray cells do the math for you.

    Clearing the sample data

You receive:

  • START-HERE.pdf — Google Sheets link + quick guide
  • garment-costing-calculator-excel.zip — Excel version

Good to know

  • Comes with a sample factory (6 styles, 8 quotes for 4 clients) so you can see every status first; Start Here shows how to clear it.
  • Sample times, consumptions and prices are made-up starting points. Replace them with your own.
  • Any currency; fabric in kg, meters or yards.
  • Up to 60 styles, 1,000 operations, 200 materials and 200 quotes.
  • Best used on a computer; you can view it in the Google Sheets app on your phone.
  • Using a Mac?
  • For use in one business. Please do not resell or share the files.

A costing tool, not tax, legal or financial advice.

Designed by me with the help of AI tools.

View Garment Costing & Batch Quote on Etsy

More in Sewing & Apparel