Vinyl comes on rolls, and a roll is never the number on its label for long. So a vinyl inventory counts feet left on each roll, one row for each type, color and finish: permanent or removable adhesive vinyl, heat transfer vinyl, glitter, metallic. Beside the rolls it counts sheets by the each, transfer tape by the foot, and the blanks the vinyl goes onto: tumblers, shirts, signs. Each row has a level to reorder at and a cost for one foot, so that a quote is based on what the material costs you and an order isn't accepted for vinyl you don't have. The hard part is knowing what's left on a roll without unrolling it, and the answer is a tally on the core. Below is a sheet for a made-up decal and shirt maker, the tally, and the file.
The short version
- One row for each type, color and finish. Black matte permanent and black matte removable are two rows.
- Count rolls in feet left. Sheets and blanks by the each.
- Keep a tally on the roll's core: start length, minus each cut.
- A reorder level in feet: what your biggest usual job takes, plus a margin.
- Cost for one foot, so jobs can be priced.
- TaroStack takes the vinyl off the roll when you record the job. More below.
An example sheet
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Permanent adhesive, black, matte, 12 in | ft | 38 | 15 | $0.62 | $23.56 | OK |
| Permanent adhesive, gold, metallic, 12 in | ft | 6 | 10 | $1.10 | $6.60 | REORDER |
| Heat transfer, white, 12 in | ft | 9 | 15 | $1.35 | $12.15 | REORDER |
| Heat transfer, glitter rose gold, 12 x 20 in | sheet | 3 | 4 | $3.90 | $11.70 | REORDER |
| Transfer tape, 12 in | ft | 55 | 30 | $0.21 | $11.55 | OK |
| Tumbler, 20 oz, stainless, white | each | 16 | 12 | $6.25 | $100.00 | OK |
Twelve rows in all, $345.64 of stock. Three are flagged. Notice where the money is: $180 of it is tumblers and shirts. The blanks, not the vinyl, are most of what's tied up.
The tally on the core
Unroll a new roll against a tape measure once, or trust the label, and write the length inside the core or on a tag: "30 ft". Every time you cut, cross it out and write what's left.
| Roll | Start | Cut | Left |
|---|---|---|---|
| Gold metallic, bought Oct 20 | 30 ft | 6 ft, tumbler order | 24 ft |
| 10 ft, wedding signs | 14 ft | ||
| 8 ft, test cuts and a misfeed | 6 ft |
At count time you read the cores. It takes ten minutes for a rack of rolls, and you never unroll anything.
The last line of that tally matters. Eight feet went to test cuts and a misfeed, a quarter of the roll. Waste is part of what vinyl costs, and a tally is the only place you'll see it.
Will the job fit?
A 24-decal order in gold, each decal 3.5 inches wide and 4 inches tall, on a 12 inch roll.
| Decals across the roll (12 in wide, with margins) | 3 |
| Rows needed (24 ÷ 3) | 8 |
| Length a row (4 in tall, plus a gap) | 4.5 in |
| Vinyl for the decals | 3 ft |
| Lead-in, weeding border and a spare row | 1 ft |
| Vinyl needed | 4 ft |
Four feet for this one. Now take a larger decal: 10 inches wide, one across, 24 rows of 4 inches, eight feet. Same count of decals, twice the vinyl. Work it out before you say yes, and check it against the tally, not the label on the roll.
Costing a job
| Per decal | |
|---|---|
| Gold vinyl, 4 ft at $1.10 ÷ 24 | $0.18 |
| Transfer tape, 3 ft at $0.21 ÷ 24 | $0.03 |
| Materials | $0.21 |
Materials are small. Your time weeding and taping is the real cost, and it's the part people leave out. The full sum is in how to price vinyl decals, and for shirts and tumblers in how to price tumblers.
Blanks and sizes
Shirts are a size run: a row for each size, or you'll find you have 21 black shirts and no mediums. The same goes for tumbler colors. The layout for that is in t-shirt inventory template, and for dye-sublimation blanks in sublimation inventory template.
Offcuts
Pieces too small to go back on the roll and too big to bin go in a scrap box by color. They're not on the sheet. Use them for test cuts and small one-off jobs, and empty the box when it won't close.
Get the spreadsheet
Download the vinyl inventory spreadsheet. Four sheets: inventory with value and a REORDER flag, a lots sheet for rolls with what's been cut from each, a count sheet to print, 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
A team order comes in: thirty shirts, two colors of heat transfer, names on the back. That's shirts in five sizes, white vinyl, black vinyl and a carrier sheet, all to take off the sheet by hand when the job's done, on a Friday night. It doesn't happen. The next order is quoted against numbers that are thirty shirts and nine feet out.
How TaroStack does it
TaroStack takes the materials off when the job is recorded.
A design is a recipe. A shirt, so many inches of white vinyl, so many of black. Record thirty made and the shirts and the vinyl go down by exactly that, with inches converted from feet on the roll.
Scrap is part of the recipe. Put a scrap percentage on the vinyl and misfeeds are allowed for.
"What could I make right now" says how many of a design your blanks and vinyl allow, and which runs out first.
The job's cost is real, from what that roll actually cost.
A reorder list in days of cover, so the gold is ordered before the order that needs it.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Take vinyl and blanks off after a job | By hand, if you remember | Record the batch |
| Is there enough for this order | Read the cores, do the sum | What could I make right now |
| What did the job cost | Work it out | The batch's cost |
| When to reorder | A flag after a count | The reorder list |
Starter, at $9.99 a month, holds 50 items and 5 recipes. A range of designs and colors wants Growth: 3,000 items and 50 recipes at $39 a month. 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.
