Weekly count and order list · Otherworld Labs · printed
Two counts of one shelf, a week apart, work out the figure a reorder-point calculator asks you to supply: how fast each line moves. From those two counts this page prints what to order this week on every line it has a usage figure for, in whole packs, against that line's own floor and its supplier's minimum; a line whose usage it cannot work out gets a marker instead of a number. Five things can be true of a line and the table says which one each of yours is. Nothing you type leaves your browser.
This page is inventory bookkeeping on one count sheet: stock on hand, SKU by SKU, and what to order from your supplier this week. It is not about shares, securities or anything traded, no figure it works out is a price, a cost, a margin or a cash-flow figure — the one money figure anywhere on the page is the price of the kit it offers at the end — and it gives no financial, tax or business advice. It sets no par level and no lead time for you; those are figures you type.
The walkthrough is on. Each part says what its figures mean and where to find them. Turn it off at the top once you know your way around. The lines already in the sheet are a worked example from a small pet-supply shop: it is worked right through on the lines it has a usage figure for, and the rest are waiting on a figure, so you can see both states before you touch it; type over them with your own.
3 of the 8 lines on this sheet have no usage figure yet, so the week's totals print no figure: a total that leaves a line out understates the order. Each of those lines says which figure is missing.
One card per line of your count sheet. Counted now is today's count; last week's count is the one you took a week ago, off your paper sheet or kept by this page from your last visit. Those two counts, with anything that came in between them, are what the usage figure is worked out from, and that is the figure a reorder-point calculator asks you to supply.
| Lines on this week's sheet 1 to 30 |
Units received, where your only record of this week's delivery is one total for the whole shipment: fill this in only on the lines you can read off the packing slip, and leave it blank on the rest. A blank is read as not known, so that line gets no usage figure, no order and a marker. An unknown delivery is never read as nothing received, and this page never splits a shipment total across lines, because a total discards which units were which.
Or paste the sheet in. One line per row, tab- or comma-separated, in the order of the cards above: name, counted now, last week's count, units received, target cover in weeks, floor, lead time in days, pack size, supplier minimum. Leave a field empty to leave it empty; the box types the fields and works nothing out of its own.
Kept counts never leave this browser and are never sent anywhere: they are written into this browser's own storage on this page's address, under one key, and the Forget button removes them. Next week, open the page and today's counts will be sitting in last week's column, with the count and delivery boxes for the new week empty and every line waiting for a usage figure until you count it.
This week's order for each line is the cover you want less what you counted, rounded up to whole packs, and every figure is shown with its working. Where a line used nothing last week, or where its floor or its supplier minimum sets the size instead, the page names what decided the order rather than folding it into the figure. Five things can be true of a line and the page says which one each of yours is.
Dog food 15kg bags: no usage figure this week, so no order is printed for this line. The units received on this line were left blank, which reads as not known rather than as nothing received.
Cat litter 20lb: this week's order is 48 units in 4 packs, which is 4 more than the 44 the week needs. It lands at 3.1 weeks on hand.
Dog treats small bags: this week's order is 48 units in 2 packs, which is 33 more than the 15 the week needs. One pack is 24 units and the week needs 15, so the order steps up to a whole pack. The supplier will not take an order below 48 units, so it then steps up to the supplier's minimum. It lands at 6.3 weeks on hand.
Cat food cans by the case: nothing was used last week, so weeks on hand is not a number here. With nothing used last week the floor you set is the only basis for an order: the floor, 24 units, is above the 15 you counted, and the order is 12 units in 1 pack. One pack is 12 units and the week needs 9, so the order steps up to a whole pack.
Puppy pads: no usage figure this week, so no order is printed for this line. The count rose from 70 to 100 with no delivery recorded, so the two counts disagree.
Bird seed 5kg: no usage figure this week, so no order is printed for this line. No count was kept from last week, so there is nothing to work the usage from.
Fish food flakes: this week's order is 114 units in 19 packs, which is 5 more than the 109 the week needs. It lands at 7.8 weeks on hand.
Aquarium filter cartridges: you counted 50 units and this line wants 50 for the cover you asked for, so there is nothing to order this week. That is 10.0 weeks on hand.
The same table, written out for anything reading this page rather than looking at it: api.json beside this page carries every input with the range this form offers, every output, the arithmetic line by line, this worked sheet, and a list of what the calculation leaves out.
| Line | Counted now | Last week | Received | Used, units a week | Weeks on hand | Verdict | Order, units | Order, packs | Pack rounding adds | What decided the order, or why there is none | Weeks on hand once it arrives |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Dog food 15kg bags | 42 | 50 | — | — | — | no usage figure | — | — | — | the delivery on this line is not known | — |
| Cat litter 20lb | 30 | 40 | 15 | 25 | 1.2 | order it | 48 | 4 | 4 | the target you set | 3.1 |
| Dog treats small bags | 15 | 20 | 5 | 10 | 1.5 | order, decided for you | 48 | 2 | 9 | a whole pack, the supplier minimum | 6.3 |
| Cat food cans by the case | 15 | 15 | 0 | 0 | — | nothing used | 12 | 1 | 3 | the floor you set, a whole pack | — |
| Puppy pads | 100 | 70 | 0 | — | — | no usage figure | — | — | — | the count rose with no delivery recorded | — |
| Bird seed 5kg | 5 | — | 0 | — | — | no usage figure | — | — | — | no count kept from last week | — |
| Fish food flakes | 18 | 25 | 10 | 17 | 1.1 | order it | 114 | 19 | 5 | the target you set | 7.8 |
| Aquarium filter cartridges | 50 | 55 | 0 | 5 | 10.0 | nothing to order | nil | nil | 0 | already at the target you set | 10.0 |
| This week, the whole sheet | — | — | — | — | — | still being filled in | still being filled in | still being filled in | — | — | — |
A dash is not a figure of nothing: it means that cell is not a number on that line. Nil is not a dash: it means the page had a figure to work out, worked it out, and there was nothing there, as on a line with nothing to order. A plain zero is a figure the arithmetic produced, as in the units a pack rounding adds on a line where it adds none. The rule, in one line: the rows that say how much to do — the two shortfalls, the week's need and the order itself — print nil when the working came to nothing, and a row that is only one of those figures taken from another prints the zero it worked out. A line with no usage figure has no weeks on hand, no order and no place in the week's totals, which is why the totals say how many lines they are short of rather than printing a figure that would understate the order.
Every figure in the table, worked from the figures printed beside it. Units are whole, because a supplier ships whole units; weeks are printed to one decimal; the cover a line wants is worked to two decimals and then taken up to the next whole unit, because part of a unit is not a unit you can hold.
The usage line is the one worth reading twice. It is not a guess and it is not typed: it is last week's count, plus anything that came in since, less what is on the shelf today. That is why this page asks for two counts a week apart instead of asking you how fast a line sells.
What this page leaves out. It holds no prices of yours and works out no money figure, the one money figure on it being the price of the kit it offers, so it says nothing about what an order costs, what the inventory is worth, or anything to do with cash. It does not model demand, seasons, promotions, shelf life or a supplier who is out of stock on hand of their own. It does not compute an economic order quantity: that model rests on assumptions about ordering cost and holding cost that this page cannot check for you. It is one week against the week before, which is all two counts can tell you, and a line whose sales swing week to week needs more weeks than this sheet holds before its usage figure means much.
This page keeps only last week's count, one week at a time, in this browser if you ask it to, and each new week it keeps replaces the one it had. The kit is the record itself: a workbook with a line per SKU and a new row for every week you count, so the usage figure is derived from your own successive counts for as long as you keep counting, and a printed document for the decisions the arithmetic cannot make.
One payment, no subscription, no account on this site. A spreadsheet and a PDF; files, not software. Nothing on this page needs it, and the page stays free and complete without it.
Reorder short and you are out of stock in the week you needed it. This page reads one line. Where you hold hundreds of lines, each with its own usage, lead time and a minimum you set yourself, send the columns you already keep and what you need totalled, and a workbook is built to the lines you hold. Free to ask.