AnalystBuilt home Etsy shop

Sewing & Apparel

Sewing Factory Complete

Costing, fabric stock, wholesale orders, production plan, tech packs, size grading and piece-rate pay: seven spreadsheets for one sewing factory

Sewing Factory Complete: Costing, fabric, orders, planning, tech packs, sizes and payroll
Costing, fabric, orders, planning, tech packs, sizes and payroll
  • Sewing Factory Complete: Costing, fabric, orders, planning, tech packs, sizes and payroll
  • One production cycle, seven tools: Quote it, stock it, book it, plan it, sew it, size it, pay for it
  • Is this quote below target? Suggested price at your margin vs the price the client wants
  • See what is really available: On hand − reserved for open orders = free to use, plus what's on order
  • Catch delays before the due date: A stage date turns red the day it misses its plan
  • Your orders on a calendar: Start, finish, due date — late days in red, holidays skipped
  • A tech pack for every style: Style, client, sizes and tier — time, cost and checks at a glance
  • Short and Tall from one rule: One length change per measurement, added to every size

from $59 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.

Run a small sewing factory from seven spreadsheets: what a batch costs and what to quote, the fabric and trims on your shelves, every wholesale order from sample to shipping, when each batch will finish, the tech pack for the floor, the size spec for every size and fit, and what each operator earned.

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. Built by a data analyst together with a working cut-and-sew workshop.

What's included

  • Garment Costing & Batch Quote

    Cost per unit for a whole batch: fabric by consumption and cutting waste, trims, labor from operation seconds, decoration and overhead. Price at your margin, three finishing tiers side by side and a one-page client quote. 11 tabs.

  • Fabric & Trims Inventory

    Rolls and dye lots, zips, labels and packaging; receipts, issues to cutting, stock reserved per order, a reorder list and stock counts. 10 tabs.

  • Wholesale Production Order Tracker

    Orders with their size runs, stage dates from sample to shipping, deposits and balances, a production board and size totals that show what to cut and buy next. 11 tabs.

  • Sewing Production Planner

    Minutes per day for each machine group, a schedule board with finish dates and the bottleneck, 12 weeks of load and a line balance with takt time. 11 tabs.

  • Tech Pack & Operation Breakdown

    One style per file: cover with sketch frames, bill of materials, operations in seconds with SMV and labor per tier, measurements, construction, labels, revisions and a print page. 9 tabs.

  • Size Chart & Grading

    Grade rules per point of measure, a spec table for every size from XS to 6XL in Short, Regular and Tall, a client size chart in cm and inches and a sample check. 9 tabs.

  • Piece-Rate Payroll for Sewing Workers

    Rates per operation, daily output, attendance, advances and deductions, payroll with an hourly floor and a pay slip for every worker. 11 tabs.

Why you'll like it

  • One production cycle: quote it → stock it → book the order → plan it → sew it → size it → pay for it
  • Styles, operations and materials use the same columns in every file, so you type them once and paste them across
  • Seconds per operation drive costing, planning and piece rates, and Economy / Standard / Premium tiers work the same way everywhere
  • Sizes XS to 6XL with Short and Tall fits, fabric in kg, m or yd, measurements in cm or inches
  • Every file shows what needs your attention first, with one shared sample factory you can clear in minutes
  • Made by a data analyst: every number is a formula you can trace. No subscription, no app

How you get it

  1. Download on Etsy

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

    How to download

  2. Make a copy

    Click each MAKE A COPY button in the PDF, one per spreadsheet: your copies are saved to your Google Drive. Prefer Excel? Open the .xlsx files.

    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 links + quick guide
  • sewing-factory-complete-excel.zip — Excel versions, one folder per template

Good to know

  • Seven separate files that each work on their own; nothing is linked between them.
  • Already own some of them? Each template is also sold on its own in the Sewing & Apparel Business section.
  • Sample times, prices and rates are examples only: type your own.
  • Piece-Rate Payroll is a record-keeping tool — check local wage and tax rules.
  • Best on a computer; the Google Sheets phone app is fine for checking numbers.
  • Using a Mac?
  • For use in one business. Please do not resell or share the files.
  • Listing images show real screenshots of these templates with sample data.

Planning and record-keeping tools, not legal, tax or financial advice.

Designed by me with the help of AI tools.

View Sewing Factory Complete on Etsy

Templates in this set

More templates