Bar Inventory Spreadsheet

If you have stored the bar code of your products in a file, you can take advantage of this information for when you have to take inventory and use the barcode reader to write down all the products that are being counted much faster than doing it manually. We can do inventory with the barcode reader in many different ways but today we propose to do it on a spreadsheet (it can be Excel, Openoffice Calc, Google … but in our case we will use the Openoffice Calc, of free license). To do the inventory you only have to have a spreadsheet prepared so that you can go “pistoleando” the products and pointing out the quantities that you are finding. If you put in the spreadsheet the necessary information,…

Liquor Inventory Spreadsheet

If you are in the hotel business you will know that selling alcohol can leave a lot of room, and many will think that running a bar is easy, but you know it is not. There are factors to take into account and if we do not manage properly we can leave more losses than profits. How to control the inventory of liquors and alcoholic beverages of your establishment? Inventory Control Tools For example, when faced with the dilemma of what types of alcoholic beverages to offer and which alcoholic beverage providers to turn to, we realize that making the decision has some difficulty because of: The immense variety of spirits from which to choose. In some cases the rotation of certain types of inventories is low so the…