Know what an order really costs, decide whether to take it, and give every department the same instructions. One Excel workbook for small factories and clothing brands.
US$24 · One-time digital download · Excel (.xlsx), imports into Google Sheets
Gumroad emails your receipt and download links for both Excel files after checkout.
When an enquiry arrives you need three answers fast: what does it cost me, what should I charge, and can I afford to start? After that, everyone who works on the order needs the same instructions. This workbook does both in one place. "MO" means master order: the one sheet that holds the cost, the price and the decision for an order.
Problem: you quote a price and find out later you lost money.
Fix: the MO shows the estimated profit and margin before you reply. Check that the quote and all supplier costs are entered before using the verdict.
Problem: a supplier raised a price, so your old quote is wrong.
Fix: change it once in the Price Book. Stale prices are flagged and every MO updates.
Problem: you need to know how much of the materials and trims you must fund after the customer deposit.
Fix: the MO compares that buy list with the deposit.
Problem: every department gets a slightly different brief.
Fix: one Work Order per product, built from the same numbers, with size pack, specs, routing and QC.
Problem: orders slip, and unpaid balances get forgotten.
Fix: the Orders sheet flags what is late, due soon and still to collect.
1. An enquiry arrives. 2. Cost it in the MO from your Price Book. 3. Check your inputs, margin and materials cash gap before deciding whether to quote. 4. Accepted? Fill a Work Order and hand it to each department. 5. Buy materials against the Purchasing budget and enter what you really paid. 6. Track the order until delivered and paid, and compare the latest estimate with your plan.
1. Price Book. Every material, trim and service with pack price, unit price, previous price and a flag when a price has gone stale.
2. MO (master order). Build the cost of each product from the Price Book, set your price, and get COGS per piece, price at target margin, estimated profit, the materials cash gap after the deposit, and the verdict for a completed quote.
3. Work Order. One page per product: spec, size pack checked against the MO quantity, fabric to buy, measurement spec, department routing with late flags, and QC checkpoints.
4. Purchasing. Budget filled from the MO. Enter what you really paid and see projected profit against plan.
5. Orders. Every order in one log with late, due soon and balance still to collect.
6. Guide. What to tell each department, common mistakes, and a weekly price routine.
The full illustrative order has 250 pieces across two products and US$140.31 in materials and trims still to fund after the deposit.
Fictional client and prices. You enter your own.
Two Excel files: a filled example workbook so you can see every sheet working, and a blank starter workbook for your own orders. Plain formulas, no macros.
Start in Excel or import both files into Google Sheets. Compare the first order with the filled example and read the margin values directly. Sheets import can omit the low-margin highlight in Orders.
Small factories, tailors and clothing brands that quote jobs, buy materials and brief several departments or vendors. If prices change often and quotes live in your head or in scattered files, this puts them in one place.
It is a planning and control sheet. Your results depend on the prices and specs you enter, and every estimate should be confirmed with your suppliers.
Where can I buy it? Buy the Garment Master Order System on Gumroad for a one-time US$24 payment.
Do I need to know Excel? Start with the filled example. In the starter, enter the quantities and quote price, then check each material, trim and service price before using the result.
Can I change the margins, waste and deposit? Yes, all in the Settings sheet. You can also test a scenario, for example plus 8 percent on materials.
Is it only for T-shirts? No. It works for any cut-and-sew product (bags, jackets, uniforms) because you build the cost lines yourself.
More questions? See Support.