Friday, August 17, 2012

Increase Your Sales Using A Liquor Inventory Spreadsheet


Hitting the sales targets of your restaurant is not just about being able to serve your customers right but also making sure that you have control and monitoring over the products that you sell including liquor. This is the reason why you need a liquor inventory spreadsheet to assist you in your monitoring activity.

Check out the following benefits of having a liquor inventory spreadsheet.

1. Minimize your restaurant's liquor shrinkage. Shrinkage is a form of loss to the restaurant whereby your liquor inventory diminishes with no definite kind of measurement to determine such loss. Shrinkage happens when your staff will not be able to control what amount of liquor should he give to the customers. Your bartender may pour too much liquor to the customer giving you losses or pour too little amount giving you customer complaints.

Being able to monitor what goes in and what goes out especially when you deal with liquor products is hard to determine. With a liquor inventory spreadsheet, your bartender would be able to specify the exact amount of liquor that should be provided to the customer equivalent to what he paid. This procedure will lessen your restaurant's shrinkage. Eventually, you will notice that your restaurant is earning profit rather than increasing its shrinkage percentage.

2. Prevent liquor spillage and theft. You should be aware that your restaurant operates almost 24 hours. In the middle of an entire shift, your bartender's attention to detail goes down especially when he is sleepy. This causes liquor spillage. When your bartender notice that there is no longer enough wine to offer to the customers, he will get another bottle from the storage without your permission to fill in the gap. You lose so much amount when theft occurs everyday.

With a liquor inventory spreadsheet, all your liquor will counted and monitored accordingly. You will know how many are on the shelf for the day and how many in the storage. In this way your bartenders will refrain from stealing because they know that all the bottles are counted.

3. Increased sales. When you avoid spillage, shrikage and theft percentage to rise or completely eliminate them, you will be able to augment your sales. These are important factors to consider as they form part of your regular expense. Curtailing them on a daily basis will give you higher returns.

You can only curtail these expense items when you acquire a liquor inventory spreadsheet. This monitoring system for your liquor will enable you to manage and take control over your inventory and at the same time avoid unnecessary expense items.

These are some of the benefits that you can get from using a liquor inventory spreadsheet. Once you have set up your system, you can follow these steps:

1. Organize your spreadsheet according to liquor type. Tally in the spreadsheet the exact number of bottles you have.

2. Put another column in your spreadsheet to tally bottles of liquor in use.

3. Sum up the bottle count on each column and counter check with those in the shelf.

4. Update our liquor inventory spreadsheet once a week.