A toy store's list has three jobs that a general shop's can skip. It has to cope with a season: the shop in this example sells more than four times as many board games a week from October to December as in the rest of the year, so a reorder level that's right in March is wrong in November. It has to be wide: many items, a few of each. And it has to hold the batch on each delivery, because when a recall notice names a batch, the shop has to know which boxes are that batch. So a toy store inventory list has a row for each toy a customer can buy, with on hand, a reorder level that changes by season, what one cost, and where it is, and a second sheet where each delivery's batch or tracking label is written down. Below is a list for a made-up neighborhood toy store, how to set levels for the holidays, what to record for recalls, and the file.
The short version
- One row for each toy a customer can buy, down to size and edition.
- Unit cost is what you paid, not the price on the shelf.
- Two reorder levels: one for the holiday season, one for the rest of the year.
- Write the batch or tracking label from each delivery.
- Count a section a week. Count everything in January.
- Summer and holiday toys sit at zero in the off season.
- TaroStack keeps stock by lot and counts on a phone. More below.
An example list
Counted in the second week of November.
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Building blocks, 100 piece set | each | 14 | 12 | $11.50 | $161.00 | OK |
| Wooden train set | each | 6 | 6 | $22.00 | $132.00 | REORDER |
| Plush bear, 12 in | each | 22 | 15 | $6.40 | $140.80 | OK |
| Jigsaw puzzle, 500 piece | each | 9 | 10 | $9.60 | $86.40 | REORDER |
| Board game, family | each | 11 | 8 | $15.80 | $173.80 | OK |
| Card game, kids | each | 30 | 20 | $4.90 | $147.00 | OK |
Ten rows in all, $1,072.05 at cost, with four to reorder: train sets, puzzles, marker sets and slime kits. The kite on the list has four on hand and a level of zero. Nobody buys a kite in November, and it'll get a level in March.
Holiday levels
| Family board game | Jan to Sep | Oct to Dec |
|---|---|---|
| Sold in a week | 2 | 9 |
| Weeks to get a delivery | 2 | 3 |
| Sold while waiting | 4 | 27 |
| Cushion | 4 | 9 |
| Reorder at | 8 | 36 |
The numbers are this shop's own. Two things change in the season, not one: the game sells more than four times as fast, and the distributor takes a week longer. The level goes from 8 to 36. The list above still shows 8, which is the mistake to catch: with 11 on hand it reads OK, and at nine a week it's just over a week from empty with a three-week wait.
Set the season's levels in September, from last year's sales by week, and put the date on the calendar. The sum is in reorder point example. Ask each supplier for its last order date for delivery before the holidays, and put that on the calendar too.
Batches, for recalls
| Received | Item | Lot or tracking label | Quantity | Use by | Note |
|---|---|---|---|---|---|
| Nov 9 | Plush bear, 12 in | Tracking label PB-2609-A | 24 | Batch from the label sewn into the seam | |
| Nov 12 | Slime kit | Lot SK-1147 | 12 | Jun 1, 2028 | Use-by printed on the box |
| Oct 28 | Building blocks, 100 piece set | Tracking label BB-2608 | 18 |
A product made mainly for children 12 and under carries a tracking label that says who made it, where, when and in which batch. When a recall names a batch, a shop that wrote that label down at receiving can go straight to the right boxes, and can say how many it had and how many are left. A shop that didn't pulls every bear in the building. What the label is and where to find it is in CPSIA tracking label requirements.
Some stock has a date as well. This shop's slime kits carry a use-by. Write the date where there is one.
Counting
Count a wall or a shelf a week, in the order of the list. In January, after the returns, count everything: it's the opening number for the year and the one the accountant wants. The file's count sheet takes what the list said and what you found, and works out the difference at cost. A general shop's version is in store inventory sheet, and a count plan in cycle count form.
Get the list
Download the toy store inventory. Four sheets: inventory with value and REORDER, deliveries with tracking labels and dates, a count sheet that works out each difference and what it's worth, 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
In December nobody subtracts a day's sales from a spreadsheet at nine at night. So in the weeks when knowing what's left matters most, the list is furthest from true, and reorders are made by walking the floor.
How TaroStack does it
TaroStack keeps the list current through the season.
Receiving adds each delivery as a lot, with its tracking label or batch, at what you paid.
Counting works on a phone with no signal, in the back room. A count shows what each difference is worth.
A reorder list in days of cover, with each supplier's lead time and minimum, and reorder points suggested from how stock actually moves.
One report for a lot: how many came in, and how many are left. Starting a recall holds what's still in stock.
Barcodes by phone camera or scanner, for counting and receiving.
| The recall notice | Paper | In TaroStack |
|---|---|---|
| Do we have that batch | Open every box | Search the lot |
| How many came in, how many are left | Unknown | The lot's stock |
| Stop selling them now | Tell everyone | Starting a recall holds the lot |
| What to reorder this week | Walk the floor | A reorder list |
TaroStack doesn't run the register. It connects to Square. Stock, lots, counts and reordering are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). 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.
