A direct-to-film shop runs on four consumables and one stack of blanks: film, ink in five colors, adhesive powder, cleaning supplies, and shirts. Run out of any one and the printer stops, and they don't run out together. A shop can have months of yellow ink and three days of white. So the inventory is a list of everything the printer and the press use up, with a level to reorder at, and a column a plain list lacks: weeks of cover, what's on hand divided by what's used in a week. A second sheet records the lot of each delivery, because when prints start cracking or colors drift, the first question from any supplier is which batch. Below is a list for a made-up DTF shop, the weeks-of-cover sum, lots, and the file. The usage figures are the example's own.
The short version
- List what gets used up: film, each ink, powder, cleaning solution, blanks, mailers.
- Count in the unit you buy: rolls, bottles, bags. Write an opened one as a fraction.
- Weeks of cover = on hand ÷ used a week. Do it for each ink on its own.
- Set reorder levels from use and the supplier's delivery time.
- Keep a spare of anything that stops the printer and takes days to arrive.
- Write the lot or batch of ink, film and powder at delivery.
- TaroStack keeps a reorder list in days of cover and takes materials off as jobs are recorded. More below.
An example list
Counted in mid November.
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| DTF film, 24 in x 328 ft roll | roll | 3 | 2 | $96.00 | $288.00 | OK |
| Adhesive powder, white, 2.2 lb | bag | 5 | 4 | $19.00 | $95.00 | OK |
| Ink, white, 1 liter | bottle | 2 | 3 | $62.00 | $124.00 | REORDER |
| Ink, cyan, 1 liter | bottle | 2 | 1 | $48.00 | $96.00 | OK |
| Ink, magenta, 1 liter | bottle | 2 | 1 | $48.00 | $96.00 | OK |
| Ink, yellow, 1 liter | bottle | 3 | 1 | $48.00 | $144.00 | OK |
Twelve rows in all, $2,125.00 at cost, with two to reorder: white ink and white shirts. The other six rows are black ink, cleaning solution, a spare print head, black and white blank shirts, and mailers.
Weeks of cover
| Supply | Used a week | On hand | Weeks of cover |
|---|---|---|---|
| Film | 0.5 roll | 3 rolls | 6.0 |
| Adhesive powder | 1 bag | 5 bags | 5.0 |
| Ink, white | 0.75 liter | 2 liters | 2.7 |
| Ink, cyan | 0.25 liter | 2 liters | 8.0 |
| Ink, yellow | 0.25 liter | 3 liters | 12.0 |
| Shirts, black | 60 | 140 | 2.3 |
| Shirts, white | 45 | 60 | 1.3 |
White ink goes three times as fast as any color in this shop, because it prints a white layer under every design on a dark shirt. It has the highest reorder level for that reason, and it's the one that ran out. A shop that reorders "ink" as one item, when the cyan gets low, will always be out of white first.
Three months of yellow is money on a shelf. Twelve weeks of cover on a liquid with a use-by date. Buying the color set as a bundle is how that happens. Order each ink to its own use.
Blanks are the shortest cover on the page. 1.3 weeks of white shirts. Blanks come in sizes, and the count of 60 hides that there may be four mediums. A size run is its own list: see t-shirt inventory template.
Setting the level. Weeks of use while you wait for a delivery, plus a cushion. White ink takes this shop's supplier a week to deliver, and the shop wants three weeks in hand on top: four weeks at 0.75 liter is 3 liters, which is the level on the list. The sum is in reorder point example and the cushion in safety stock formula.
The spare that isn't stock
The list has one row that doesn't behave like the rest: a spare print head, one on hand, reorder level zero, $420. It isn't used up week by week. It's there because the day the print head fails, the shop is closed until a new one arrives. Whether to hold a spare is a sum: what a replacement costs to keep on the shelf against what the shop loses each day it can't print. This shop takes in about $600 a day and its supplier quotes four days, so the spare paid for itself before it was ever fitted.
Deliveries, with their lots
| Received | Item | Lot or batch | Quantity | Use by | Note |
|---|---|---|---|---|---|
| Nov 5 | Ink, white, 1 liter | Batch W-2610-44 | 4 | Apr 30, 2027 | Shake before use. Opened one 11/10 |
| Nov 5 | DTF film, 24 in x 328 ft roll | Lot F-88213 | 2 | Hot peel | |
| Nov 12 | Adhesive powder, white, 2.2 lb | Lot P-5507 | 6 | Medium grade |
When transfers start cracking after a wash, or a color shifts, there are several suspects: the ink, the film, the powder, the cure, the press. With the lot of each consumable written at delivery, and the date a new bottle or roll was started, the shop can see whether the trouble began with a new batch of something. Without that, every one of them gets blamed in turn, and the supplier will ask for a batch number before talking about a replacement.
Write the use-by date where the bottle has one, and use the oldest first.
Counting
Count every week, on the same day, before ordering. Twelve rows takes a few minutes. Count ink in bottles and estimate the one in the printer as a fraction. The file's count sheet takes what the list said and what you found, and works out the difference at cost. A plan for what to count when is in cycle count form. Pricing the finished shirt is in how to price t-shirts, and a neighboring trade's numbers in screen printing profit margin.
Get the template
Download the DTF printing inventory template. The supply list with values and a status for each row, a deliveries sheet with lots and dates, 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.
Where this stops working
The weeks-of-cover table rests on "used a week", which is an average somebody typed. A week with two big dark-shirt orders uses twice the white ink, and the table doesn't notice. The list is right on counting day and wrong by Wednesday. And nothing on it connects an order to what it will use, so a forty-shirt job is accepted on Thursday without anyone checking there's ink for it.
How TaroStack does it
TaroStack works the cover out from what's actually used.
A reorder list in days of cover, on every plan, with reorder points suggested from how stock really moves.
A printed shirt can be a recipe: a blank, a length of film, a share of ink and powder. Recording the job takes them off the shelf.
"What could I make right now" checks a job against the blanks and consumables on hand before you say yes.
Receiving records the lot and any use-by date, and the oldest is used first by default.
Suppliers with lead times and minimums, checked against how long deliveries really take.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Weeks of cover | An average, typed in | Days of cover, from real use |
| Can we take this order | Look at the shelf | What could I make right now |
| Which batch of ink is in the printer | A note, if kept | The lot in use |
| What to order this week | Compare two columns | The reorder list |
Stock, lots and the reorder list are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). Recipes are on every plan too: 5 on Starter, 50 on Growth. 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.
