A sewing business's fabric inventory comes down to yards on bolts, and two facts about each bolt that a simple list forgets: what it cost a yard and which roll and dye lot it is. Cost a yard is your product cost. The dye lot is why the navy bag sewn in August doesn't quite match the navy bag sewn in November. A fabric inventory spreadsheet tracks both, with notions (zippers, webbing, thread, labels) on the same sheet and finished goods at the bottom. Here's one for a made-up maker of canvas bags.
The short version
- One row for each fabric, color and width, counted in yards.
- Cost a yard, shipping included.
- Each roll received gets a row with the mill's roll number and dye lot.
- Notions in yards or eaches, with reorder amounts.
- TaroStack takes the yards off the bolt for every batch you cut and sew. More below.
An example sheet
Driftwood Canvas Co. is a made-up maker in Portsmouth, New Hampshire. Six of its nine rows:
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Canvas, 10 oz natural, 60 in | yd | 46 | 30 | $14.00 | $644.00 | OK |
| Canvas, 10 oz navy, 60 in | yd | 18 | 20 | $14.50 | $261.00 | REORDER |
| Waxed canvas, olive, 58 in | yd | 12 | 10 | $22.00 | $264.00 | OK |
| Cotton lining, stripe, 44 in | yd | 30 | 15 | $6.25 | $187.50 | OK |
| Webbing, cotton, 1.5 in | yd | 85 | 60 | $0.85 | $72.25 | OK |
| Zippers, brass, 9 in | each | 64 | 50 | $1.10 | $70.40 | OK |
Thread, woven labels and 22 finished totes bring it to $2,051.41. Navy canvas is under its reorder amount.
Yards into products
A tote takes 0.6 yard of 60-inch canvas, with the handles cut from the same piece.
| Natural | Navy | |
|---|---|---|
| Yards on hand | 46 | 18 |
| Totes that cuts (÷ 0.6) | 76 | 30 |
| Wholesale order on the table | 36 navy | |
| Short by | 6 totes, 3.6 yd |
So the navy order can't be cut from what's here. That's worth knowing before you promise a ship date, and it leads straight into the next problem.
Dye lots
| Received | Item | Roll and dye lot | Yards | Note |
|---|---|---|---|---|
| Oct 6 | Canvas, natural | Roll 4471, dye lot N-88 | 50 | |
| Aug 18 | Canvas, navy | Roll 4102, dye lot B-31 | 40 | Next roll may not match |
| Nov 3 | Waxed canvas, olive | Roll W-209 | 15 |
Mills dye in batches, and two rolls of "navy" from different batches can differ by a shade you only see when the bags sit side by side in a shop. The fix for the 36-tote order is to cut all 36 from the new roll and use the 18 yards of B-31 for single orders, not to cut 30 from the old and 6 from the new. You can only make that call if the dye lot was written down when the roll came in.
For matched sets (a tote and a pouch sold together), cut both from one roll and note it. The idea is the same as a food maker's lot: see what is lot tracking.
What isn't counted
Scraps. This maker doesn't count pieces under half a yard; they go in a bin for zipper pulls and samples. Decide your own cutoff and stick to it, or the count takes all day. The cost of what's wasted in cutting is already in the 0.6 yard a tote, which includes the offcuts. How that's worked out is in how to calculate cost per inch of fabric.
Get the spreadsheet
Download the fabric inventory spreadsheet. Four sheets: inventory with value and REORDER, rolls and dye lots, a count sheet, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. A plan for a bag business is in tote bag business plan.
Where this stops working
Cutting day takes yards from four bolts, plus zippers, webbing and labels, and nobody measures a bolt after cutting to update a sheet. By the time the count is wrong enough to notice, there's a wholesale order riding on it.
How TaroStack does it
TaroStack takes the yards off as the bags are made.
Each product is a recipe. A tote: 0.6 yd of canvas, 0.4 yd of lining, 1.5 yd of webbing, a label. Record a batch of 36 and 21.6 yards of canvas come off the roll you cut from.
Rolls are lots. Each roll is received with its roll number and dye lot. The batch record notes which roll it was cut from, so a set stays a set.
It answers the order question. "What could I make right now" shows how many totes the fabric and notions on hand allow, and what runs out first.
Cost follows the roll. When the next roll costs $15.25 a yard, totes cut from it cost more, and margins by product show it.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Yards left after cutting | Measure and retype | Come off with the batch |
| Enough navy for 36 totes? | A sum | Shown for you |
| Which roll a bag came from | Not recorded | On the batch record |
| Zippers and webbing | Watch for red | A reorder list |
Recipes, batches and lots are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
