Work in progress is everything you've started and can't sell yet: sauce fermenting, soap curing, bottles waiting for labels. A WIP tracker has one row for each unfinished batch, with its stage, the date it entered that stage, and the days that stage should take. From those it works out days in stage and raises a flag when a batch has been sitting longer than it should. It also carries the materials tied up in each batch, because WIP is money you've spent and can't yet get back. The flag is the reason to keep it. Batches don't fail loudly. They stall, behind a missing label or a full shelf, and the tracker is how you notice on day four and not day eleven. Below is a tracker for a made-up hot sauce maker, and the file.
The short version
- One row for each batch that's started and not finished.
- A stage, the date it got there, and the days that stage should take.
- Flag anything over its days. Ask what it's waiting for.
- Add up the materials in WIP. It's cash on a shelf.
- Delete the row when the batch becomes finished goods.
- TaroStack keeps each stage as a batch, with what it used and what it cost. More below.
A tracker
A made-up hot sauce maker, as of November 20.
| Batch | Product | Stage | Entered | Allowed | In stage | In all | Stuck? | Materials so far |
|---|---|---|---|---|---|---|---|---|
| HS-1028 | Habanero, 60 L | Fermenting | Oct 28 | 30 | 23 | 23 | OK | $214 |
| HS-1104 | Jalapeño, 60 L | Fermenting | Nov 4 | 30 | 16 | 16 | OK | $168 |
| HS-1014 | Habanero, 58 L | Blended, resting | Nov 12 | 7 | 8 | 37 | STUCK | $231 |
| HS-1007 | Garlic chili, 380 bottles | Bottled, no labels | Nov 9 | 3 | 11 | 44 | STUCK | $612 |
| HS-0930 | Habanero, 372 bottles | Labeled, to case | Nov 18 | 3 | 2 | 51 | OK | $655 |
Five batches, $1,880 of materials in progress, two stuck.
What the flags found
HS-1007: eleven days without labels. The stage should take three. The note says the labels are being reprinted and are due on the 21st. Meanwhile $612 of sauce and glass is finished in every way but one, and the order it was meant for was due on the 17th. The fix isn't in production. It's ordering labels when the batch starts, not when it's bottled.
HS-1014: one day over. Blended on the 12th, pH checked, and waiting for bottles to arrive. One day over a seven-day rest isn't a crisis. It's flagged so someone asks, and the answer (bottles on the truck) is written in the notes.
The two fermenting batches aren't flagged, at 23 and 16 days, because fermenting is allowed 30. That's why the days allowed sit on each row. One limit for every stage would either cry wolf about every ferment or never notice the labels.
Stages
Write down your stages once, in order, with how long each should take.
| Stage | Should take | What ends it |
|---|---|---|
| Fermenting | About 28 days | pH at target |
| Blended, resting | Up to 7 days | Bottles and a free bottling day |
| Bottled, no labels | Up to 3 days | Labels on |
| Labeled, to case | Up to 3 days | Cased, counted, into finished stock |
Four is plenty. The test of a stage is that something has to arrive or be decided before the batch can leave it. "Waiting" stages are the useful ones, because that's where batches get stuck. A soap maker's would be poured, curing, trimmed, wrapped. A potter's are greenware, bisque, glazed: see pottery inventory tracker.
The money column
Materials so far is what's gone into the batch at cost: peppers, salt and vinegar at first, then bottles and caps, then labels. It climbs as the batch moves.
| In ferment | $382 |
| Blended | $231 |
| Bottled and labeled, not yet in finished stock | $1,267 |
| Work in progress | $1,880 |
Two-thirds of the money is in batches that are almost done. That's usual, and it's why the last stages matter most: a delay there holds up the most cash and is closest to a customer. For the books, WIP is its own line between raw materials and finished goods. The accounting sum is in work in process inventory formula.
Using it
Update it when a batch moves, not on a schedule: change the stage, the date and the days allowed. Type today's date on the Limits sheet when you open it, and the days recount. Read the stuck column every morning. It takes ten seconds, and it's the list of things to chase.
When a batch is cased and counted, delete its row. A tracker full of finished batches is a history, and nobody reads those. The plan that decides what to start next is in production schedule example, and the cost of a batch in batch cost calculator.
Get the template
Download the WIP tracking template. Two sheets and a read-me: the tracker, where days in stage, days in all and the stuck flag work themselves out, and a Limits sheet where you type today's date. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The tracker is one more thing to update, by hand, at the moment a batch moves, which is the moment everyone is busy. And "materials so far" is a figure someone has to work out. So the stages lag by a few days, the money column is last week's, and the two numbers an owner most wants (what's stuck, and how much is tied up) are the two least likely to be current.
How TaroStack does it
TaroStack tracks the batch because the batch is how the work is recorded.
A production order has a status: planned, approved, started, completed. Recording the batch takes the ingredients from stock, from the lots you used.
Steps as batches. Ferment, blend and bottle can each be a recipe that uses the one before, so the sauce shows as fermenting stock, then blended stock, then bottles.
What it's waiting for. "What could I make right now" says whether the bottles, caps and labels for the next step are on the shelf, before the batch is ready for them.
The cost so far is the batch's own. Each step is costed from what it used, so the value of what's in progress isn't worked out by hand.
Alerts for production orders that are due, and for plans that will fall short.
| The job | WIP tracker | In TaroStack |
|---|---|---|
| Which stage is it in | Typed when someone remembers | Stock of each stage: fermenting, blended, bottled |
| Stuck for lack of labels | Found on day eleven | What could I make right now, on day one |
| Materials tied up | Worked out by hand | The cost of each batch |
| What's due | A date column | An alert |
Recipes and batches are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes); planning is 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.
