A print shop's raw material is plastic by weight, so a filament inventory tracker counts grams, not spools. Each material and color gets a row with the grams left, a reorder amount, and a cost a gram. Since your slicer tells you the grams in every part, the tracker can answer the question that matters before you accept an order: is there enough terracotta PLA on the shelf for 40 planters? Below is a tracker with a made-up shop's stock in it, and the file.
The short version
- One row for each material and color, counted in grams.
- Cost a gram: spool price ÷ 1,000 for a 1 kg spool.
- Reorder amount: what you print during your supplier's shipping time, and a spool more.
- Weigh open spools to count: total weight less the empty spool.
- TaroStack takes the grams off stock for every batch of parts you record. More below.
An example tracker
Snake River Print Lab is a made-up shop in Boise, Idaho, running five printers:
| Item | Unit | On hand | Reorder at | Cost a kg | Value | Status |
|---|---|---|---|---|---|---|
| PLA, black, 1.75 mm | g | 3,400 | 2,000 | $19 | $64.60 | OK |
| PLA, white, 1.75 mm | g | 1,150 | 2,000 | $19 | $21.85 | REORDER |
| PLA, terracotta, 1.75 mm | g | 2,600 | 1,000 | $22 | $57.20 | OK |
| PETG, clear, 1.75 mm | g | 1,900 | 1,000 | $24 | $45.60 | OK |
| TPU, black, 1.75 mm | g | 620 | 500 | $38 | $23.56 | OK |
| Nozzles, 0.4 mm brass | each | 6 | 4 | $2.10 each | $12.60 | OK |
Build plates, shipping boxes and 18 finished planters round it out to $536.03. White PLA is under its reorder amount.
Grams into parts
The shop's 5-inch planter takes 120 g of PLA, supports and purge included.
| Terracotta on hand | 2,600 g |
| Planters that prints (2,600 ÷ 120) | 21 |
| Order on the table | 40 |
| Filament needed | 4,800 g |
| Short by | 2,200 g, so three spools |
That's the check to run before saying yes. It takes ten seconds with the tracker and saves the mid-run color mismatch that comes from finishing an order on a different spool lot.
Allow for failures. If one print in twelve fails, plan on 130 g a good planter, not 120. Your own failure rate is in your print log if you keep one. Terracotta at 2.2 cents a gram makes the 120 g planter $2.64 in plastic; the rest of its cost is machine time and yours, worked through in how to price 3D prints.
Counting open spools
Weigh an empty spool of each brand once and write it down (many are around 200 g, but check yours). Then:
| Open spool on the scale | 742 g |
| Empty spool | 205 g |
| Filament left | 537 g |
Sealed spools count as 1,000 g each. A monthly weigh-in of the open ones keeps the tracker honest.
Spool lots and moisture
| Received | Item | Lot | Quantity | Note |
|---|---|---|---|---|
| Oct 14 | PLA, black | BK-2510-A7 | 5,000 g | Five spools; one open |
| Aug 3 | PLA, white | WH-2507-C2 | 3,000 g | Opened Aug 20: keep dry |
Color varies a little between production lots. For a matched set or a repeat customer, print the whole order from one lot and write it down. And note when a spool was opened: PETG and TPU take on moisture and print badly after weeks in open air.
Get the tracker
Download the filament inventory tracker. Four sheets: inventory with value and REORDER, spool 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. Counting stock of any kind is covered in how to count inventory.
Where this stops working
Five printers run all day. Each finished plate used some grams of something, and nobody subtracts 86 grams from a spreadsheet forty times a day. The tracker is right after the monthly weigh-in and wrong by the next afternoon.
How TaroStack does it
TaroStack subtracts the grams as the parts are made.
Each part is a recipe. The planter: 120 g of terracotta PLA and a box. Record a batch of 12 finished and 1,440 g comes off the filament, from the oldest lot first.
Failed prints are waste with a reason. Record the scrap, and filament lost to failures becomes a number by month.
It answers the order question. "What could I make right now" shows how many planters the filament on hand prints.
The reorder list. White PLA shows up on it before a customer does.
Selling online. Connect your Shopify store, and we set it up with you.
| The job | Tracker | In TaroStack |
|---|---|---|
| Grams after each plate | Nobody subtracts | Come off with the batch |
| Enough for 40 planters? | A sum | Shown for you |
| Filament lost to failures | Unknown | Waste, by reason |
| Finished parts on the shelf | A separate count | Stock, by lot |
Recipes, batches and the reorder list 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.
