1 - Title
Name of the product
2 - Bottle Price
The wholesale price of the product
3 - $/oz
Price of the product divided by the bottle size to get your per ounce price
4 - Previous Inventory (Date + time)
This column shows the stock level based on the previous full inventory you completed. In the image above it was completed January 8th 2019.
5 - Inventory Receivings (Bottles)
This columns adds all orders received for the product since the previous inventory date and the current inventory. In the image above it includes all orders received between January 8th 10:57am and January 14th 12:09pm.
6 - Current Inventory (Date + time)
This columns shows the stock level based on the most recent inventory you completed. In the image above it was completed January 14th.
7 - Consumption (Bottles)
Previous inventory + Inventory receivings – Current inventory i.e What has been used/consumed.
Example: Baltika 7 Lager
Jan 8th stock showed as 47 bottles
Jan 10th received 10 bottles and Jan 14th received 50 bottles
Jan 14th stock showed as 50 bottles
Therefore: 47+60-50= 57 bottles consumed.
You should never have a (-) negative number in this column, the causes could be one or a combination of the following:
- Previous inventory could have counted too few bottles (units) or counted as another product
- Orders are missing (i.e. a delivery may have been received, stock purchased outside normal delivery at a store and it was not recorded, an order was received and not counted correctly)
- Current inventory could have counted too many bottles (possibly counted another product as the product in question)
Example: Krombacher Pils Baltika on Jan 8th had 12 bottles, no orders for Krombacher recorded, finally 52 bottles were in stock Jan 14th. 12+0-52= -40 bottles consumed.
8 - Consumption (oz)
Same as Consumption (Bottles) but converted to oz based on products volume.
9 - Consumption ($)
The total value of how much was consumed of the product.