The bottle story

Four steps.
One clear stock take.

Tap a step. Watch bottles arrive, leave the shelf and turn into stock cost.

Sample data · $10 per bottle

Purchases
Stock cost
Still on shelf
Try it with your own sample numbers

Count what is there.

One full bottle = 1 point. A 17.5 oz net remainder in a bottle with 35 oz full contents = 0.5 points. Cans use whole numbers.

Use matching measurement units. If weighing with glass, subtract the empty bottle weight.

Know what the numbers mean.

Stock cost = (opening + received − ending) × unit purchase cost.

COGS % = stock cost ÷ category sales × 100. Purchases are what arrived; stock cost is what left inventory.

Counts alone cannot tell sales from loss. Enter independent usage to check discrepancies.