Counting by Pallets, Cartons and Pieces Without Unit Errors

A pallet of 48 cartons, each holding 12 pieces, is 576 pieces. That is simple arithmetic, and still a surprising number of counts go wrong at exactly this point. One person writes "4 pallets", another writes "29 cartons", a third writes "7", and the total at the bottom of the sheet is 40 of something. The books, meanwhile, are kept in pieces. Most unit errors are not mistakes in counting but mistakes in what was being counted, and they are easy to prevent with a little preparation.

Start with a conversion table

Before the count, write for every item how its units relate to one another. A conversion table can be as plain as this: item 4417, 1 carton = 12 pieces, 1 pallet = 48 cartons = 6 layers of 8 cartons, so 1 pallet = 576 pieces. Do not copy these figures from the supplier's catalogue alone. Check them by counting one full pallet on the floor, because suppliers change pack sizes, and a pallet may hold 48 cartons of 12 in one delivery and 50 cartons of 10 in the next.

Count in the unit on the shelf, convert later

The counter should record what he sees in the unit he sees: pallets, cartons and pieces in three separate columns, never in one number. The conversion is then done in the spreadsheet, not in the head of a tired person at six in the evening. This also leaves a trail. If the total looks wrong, anyone can go back to the sheet and see "4 full pallets, 29 cartons, 7 pieces" and judge it for themselves.

Partial layers and open cartons

Full pallets are the easy part. The mistakes appear at the edges:

• Partial pallets: count the full layers, multiply by the number of cartons per layer, then add the cartons on the unfinished top layer.
• Open cartons: count the loose pieces inside, and record them as pieces, not as a carton.
• Sealed cartons that look wrong, such as a light or crushed one: record them as sealed at the nominal quantity and add a note. Do not open them without the owner's permission.
• Mixed pallets: record each item on the pallet separately and mark the pallet as mixed.
• Cartons of different sizes within one item: list them as separate lines, each with its own conversion.

Add a quick cross-check for partial pallets. If the label on the pallet says 48 cartons and your layer count gives 49 or 46, recount before you write anything down. Either the label is wrong or the pallet was repacked, and both facts belong in the notes. For high-value items, have a second person count the partial pallet separately and compare the two results.

An example (conditional figures)

The conversion for item 4417 is 12 pieces per carton and 48 cartons per pallet, which is 6 layers of 8 cartons. The counter finds 4 full pallets, which is 2,304 pieces. A fifth pallet is incomplete: 3 full layers, which is 24 cartons, and 5 cartons on the fourth layer, making 29 cartons or 348 pieces. Beside it stands one open carton with 7 loose pieces. The total is 2,304 + 348 + 7 = 2,659 pieces. The books say 2,664, so the difference is 5 pieces, small enough to be explained by a late posting. Had the counter simply added 4 + 29 + 7, the sheet would have shown "40", and nobody could have made sense of it.

Keep the same unit from shelf to report

Choose one base unit for each item, usually the smallest unit in which the books are kept, and state it at the top of the report. Show the breakdown as well, so that a reader can see 4 pallets, 29 cartons and 7 pieces behind the 2,659. Make sure the books and the count use the same base unit before you compare them; a book in cartons set against a count in pieces will produce a difference that exists only on paper. If the pack size changed during the year, say from which batch, and keep each pack size on its own line.

In short

Unit errors cost very little to prevent and a lot of time to untangle. WarehouseDepo records quantities in the unit found on the shelf, converts them through an agreed table and matches the result with your books, with every difference explained by item and batch.