Resin is sold in two parts that have to be used together, in a set ratio, before they age. A resin inventory spreadsheet counts part A and part B separately, in fluid ounces, because the one you have less of decides how much you can pour. It keeps the lot and the date for each jug, since old hardener yellows and old resin can cure soft. And it lists pigments, molds, findings and boxes, with finished pieces by batch. Below is a sheet filled in for a made-up resin studio, with the file.
The short version
- Resin and hardener on two rows, in ounces. The lower one limits you.
- A lot and a use-by for each jug, from the maker's own guidance.
- Pigments by weight, molds and findings in eaches.
- Finished pieces by batch, noting the resin lots used.
- TaroStack takes both parts off stock in the right ratio with every batch. More below.
An example sheet
Tidewater Resin Studio is a made-up Charleston studio making coasters, trays and earrings:
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Epoxy resin, part A | fl oz | 256 | 128 | $0.45 | $115.20 | OK |
| Epoxy hardener, part B | fl oz | 192 | 128 | $0.45 | $86.40 | OK |
| Mica powder, pearl white | g | 40 | 25 | $0.24 | $9.60 | OK |
| Mica powder, ocean blue | g | 18 | 25 | $0.24 | $4.32 | REORDER |
| Alcohol ink, gold | fl oz | 3 | 2 | $4.20 | $12.60 | OK |
| Coaster molds, silicone | each | 12 | 8 | $6.50 | $78.00 | OK |
With cork backings, gift boxes and nine finished coaster sets, the studio holds $550.44. Ocean blue mica and gift boxes are under their amounts.
The lower part decides
This resin mixes one to one by volume. There are 256 oz of part A and 192 oz of part B.
| Mixed resin the stock can make (twice the lower part) | 384 fl oz |
| Part A left over when B runs out | 64 fl oz |
| A set of four coasters takes | 12 fl oz mixed |
| Sets the resin on hand can pour | 32 |
Sixty-four ounces of resin with nothing to cure it is $28.80 sitting on the shelf getting older. The usual cause is a spill or a mis-measured pour that used more of one part. When you reorder, buy to even the two rows up, not a matched kit by habit. And if your resin mixes two to one, the sum changes: check the label.
Lots and dates
| Received or made | Item | Lot | Quantity | Use by |
|---|---|---|---|---|
| Sep 15 | Epoxy resin, part A | A-250902 | 384 fl oz | Sep 15, 2027 |
| Sep 15 | Epoxy hardener, part B | B-250903 | 384 fl oz | Sep 15, 2027 |
| Nov 8 | Coaster set of four, ocean | CS-1108 | 12 sets |
The use-by is what this resin's maker says for unopened jugs; yours will have its own. Hardener is the part that yellows, so the oldest jug gets used first, and a clear casting waits for fresh stock. The sheet flags a jug USE FIRST inside 60 days of its date.
Write the resin lots on each batch of finished pieces (lot codes are explained in how to create lot numbers). CS-1108 was poured from A-250902 and B-250903. If those coasters stay tacky or yellow in a customer's window, you'll want to know what else came out of the same jugs.
Molds wear out. This studio retires a coaster mold after about 40 pours, when the surface dulls. Twelve molds at three pours a week each is about 13 weeks of life, so molds are a supply to reorder, not a tool you buy once.
Get the spreadsheet
Download the resin inventory spreadsheet. Four sheets: inventory with value and REORDER, lots with days left, 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. Pricing the finished pieces is in how to price resin art.
Where this stops working
Every pour uses a little of five or six things: both parts, two pigments, a backing, a box. Updating six rows after each session doesn't happen, and the two resin rows drift apart from the truth fastest of all.
How TaroStack does it
TaroStack moves all six rows when you record the pour.
A piece is a recipe. A coaster set: 6 oz of part A, 6 oz of part B, grams of mica, four cork backings, a box. Record a batch of 12 sets and everything comes off stock, in the ratio the recipe holds.
Lots on the batch. Which jugs were used is noted automatically, oldest first.
What can I pour? "What could I make right now" shows how many sets the stock allows and what runs out first, which is how you'd spot 64 oz of stranded resin.
Dates and reorders. Jugs near their date are flagged, and the reorder list shows pigments and boxes before a show weekend.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Both parts after a pour | Two subtractions | Come off with the batch |
| What the stock can make | A sum | Shown for you |
| Which jugs made this batch | A note | On the batch record |
| Old hardener | Read the dates | An alert |
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.
