Inventory and replenishment
Excel inventory: setup, receipts and reordering
Start with product records, opening stock and a daily movement log. Then connect receipts, incoming stock and count snapshots in the working sample.
Reorder points, MOQ and pack sizes
Work through inventory position, a reorder trigger, target stock, minimum order quantities and pack rounding.
A practical cycle counting workflow
Choose count priorities, schedule SKU/location tasks within capacity and reconcile physical counts with a book snapshot.
Freight and loading
CBM and container loading: a worked workflow
Measure packed cartons, add mixed shipment volume, compare chargeable weight and check the separate geometry and payload limits.
Codes and labels
Warehouse labels: bin codes, barcodes and QR
Choose the right identifier, generate a location sequence and check each barcode or QR before printing a batch.
About these guides
Warelium Tools publishes these guides alongside its free browser tools and Excel inventory kit. Worked examples use synthetic data and explicit inputs; they explain the calculations and limits implemented by the linked tools.
Use the tools for estimates and record preparation. Loading restraints, carrier charges, stock adjustments and purchase approvals still need the checks appropriate to your operation. Nothing here posts a transaction to an ERP.