A production tracking board is the one place that shows every batch in the building and where it stands. It can be a whiteboard by the door or a spreadsheet on a screen. Either way it has a row for each batch, and each row says what it is, how many were planned, which stage it's at, when it's due, and, if it has stopped, what it's waiting for. A schedule says what should happen this week. A board says what is happening now, and its whole value is in the rows that aren't moving. Below is a board for a made-up granola maker, how to choose stages, the rules that keep a board honest, and the file.
The short version
- One row for each batch that's waiting, in work or just finished.
- A few stages, named after real steps on your floor.
- A due date on every row.
- "Blocked" is a stage, and it always comes with a reason.
- The person who moves the batch moves the row.
- Clear finished rows at the end of the day.
- TaroStack shows each batch's state from its record. More below.
An example board
November 20, mid-morning.
| Batch | Product | Planned | Stage | Due | Done | Status | Note |
|---|---|---|---|---|---|---|---|
| B-1117 | Energy bites | 600 | Done | Nov 19 | 100% | DONE | |
| B-1118 | Granola, honey almond | 480 | Packing | Nov 20 | 75% | IN WORK | |
| B-1119 | Granola, maple pecan | 320 | Baking | Nov 21 | 0% | IN WORK | |
| B-1120 | Trail mix | 240 | Blocked | Nov 21 | 0% | BLOCKED | Bags not delivered. Supplier says the 21st, in the morning |
| B-1121 | Granola bars | 400 | Queued | Nov 23 | 0% | QUEUED |
Five rows tell the day. Honey almond is three quarters packed, 360 of 480 bags, and due today. Maple pecan is in the ovens. The bars haven't started and don't need to yet.
The row that matters is B-1120. The trail mix is mixed and can't be bagged, because the bags haven't come. On the board, that's visible to everyone who walks past, including the person who can phone the supplier. Off the board, it's a tub on a rack that each person assumes someone else is dealing with.
Choosing stages
| Stage | What it means | Who moves the batch on |
|---|---|---|
| Queued | Planned, not started. Materials checked | Planner |
| Mixing | Weighed and mixed. Lots written on the batch sheet | Mixer |
| Baking | In the ovens or cooling on racks | Baker |
| Packing | Being bagged, sealed, labeled and cased | Packer |
| Blocked | Stopped, waiting for something named in the note | Whoever stopped it |
| Done | Counted, lot coded and put away | Packer |
These are this maker's stages. Yours are the steps a batch really passes through, where it changes hands or changes place. Four to six is plenty. A stage nobody can see the start or end of, such as "in progress", tells you nothing.
"Queued" means ready. This maker doesn't put a batch on the board until its materials have been checked. If it had done that check for the trail mix on the 19th, the bags would have been chased a day sooner. What to check is in MRP spreadsheet template.
Rules that keep it honest
- The person who moves the batch moves the row. A board kept by a manager from memory is a day behind.
- A blocked row names what it's waiting for and who is chasing it.
- Every row has a due date, so a batch that's merely slow shows up too.
- Done rows come off at the end of the day, after someone has checked the count and the lot code.
- Look at it together once a day. Five minutes at the board each morning, starting with the blocked rows.
A whiteboard or a spreadsheet?
A whiteboard wins on the floor: everyone sees it without opening anything, and a marker is faster than a laptop with floury hands. A spreadsheet wins when someone who isn't on the floor needs to know, when you want to see what was blocked last month and why, or when the floor is two rooms. This maker uses both: the board on the wall, and a typed copy at the end of the day.
A board shows today. How long each batch has sat in its stage, and the money tied up in it, is a different sheet: see WIP tracking Excel template. Cards that travel with the work are in kanban card template. The day's output and rejects go on a production report template, and the week's plan on a production schedule Gantt chart.
Get the board
Download the production tracking board. Two sheets and a read-me: a board that works out how much of each batch is done and marks a blocked one, and a list of stages to change to your own. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
A board knows a batch's stage because someone told it. It doesn't know that B-1120 can't be packed until that person finds out and writes it up. It can't say which lots of oats went into B-1118, or whether there are almonds for tomorrow's batch. It's a picture of the floor, kept by hand, and it's only as current as the last person who touched it.
How TaroStack does it
In TaroStack a batch's state comes from its own record.
Each batch is a record that is planned, started and finished, so what's waiting and what's in work is a list you don't have to keep.
"What could I make right now" says which batches the materials on hand will cover, before one is started.
Planning, on Growth, names what will run short or arrive too late, in plain words, days ahead.
The batch notes the lots it used, automatically, and your own checks are fields on its record.
Barcodes by phone camera or scanner for recording a batch on the floor.
| The question | Whiteboard | In TaroStack |
|---|---|---|
| What's in work now | Read the board | The batches that are started |
| Can tomorrow's batch be made | Find out tomorrow | What could I make right now |
| What will run short this week | Unknown | Planning, on Growth |
| Which lots went into B-1118 | The batch sheet, if it's filled in | On the batch record |
TaroStack doesn't replace a board on the wall for a crew that likes one. Recipes, batches and lots are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes, with planning). 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.
