Weekly Alcohol Perpetual Inventory

Weekly Alcohol Perpetual Inventory

If  you are consistently losing money or alcohol from your restaurant and you are not sure why some much product is missing your storage rooms then the Alcohol Perpetual Inventory is perfect for you. Using the alcohol perpetual inventory will help pinpoint the shortage that may have occurred and who may have been involved. Make a list of the top 5 or 10 of the potential items that people will steal from you. Normally it will be the most convenient and most expensive items that you have in your inventory. People who steal will try to conceal the item in an area that will not be noticed. They will also try to get the stolen item out of the building during the busiest time because you are too busy to notice them.

How to use the weekly alcohol perpetual inventory system

Enter the top 5 or 10 Alcohol items into the system make sure you add to the system bottle and can sizes and prices. Do the math to figure out the break down into ounces. Use the Alcohol by ounces chats to determine how much alcohol ounces is in a certain bottle or can.  Complete the alcohol perpetual inventory before the shift and after the shift. For best results, you should vary the time you do the inventory, and do it several times a day to see if there is a pattern of when the item went missing. See who was working during the shortages. Process of elimination will pinpoint who was responsible for the shortage. If Steve was the only cook on during all the shortages than it is safe to say that Steve is the problem whether is was theft, a mistake or a training issue. Either way you are losing money due to Steve. It is easy to set up the alcohol perpetual inventory system. Go to the product list page and enter in all the information. See the example below.

A the beginning of each month you will need to print out a new copy of the perpetual inventory system from the master copy.

Make sure that you entered all the information on the product page master copy. As you open a new inventory each month the information will still be on the product page.

 

Other Spreadsheets:

 

Follow the Instructions button that is located on the home page for more information.
 

WAS $39.99

For a Limited Time $19.99

A $20.00 Savings

Weekly Alcohol Product List Page

View Larger Image



Once the system is correctly set up on the product page then you are ready to begin your perpetual inventory.

The information that you have entered on the product page will automatically populate to various other pages with-in the system. 

This is not a full inventory system, Choose the top five or ten products that are either the most expensive,  convenient or used the most. You might even want to inventory more then ten products. 

At the beginning of each week:

  • Print out the above beginning restaurant inventory count sheet on place it on a clip board.
  • Do a walk-through and record how many bottles or cans you have in each area. The total beginning inventory column will automatically calculate based on the figures you have entered on this sheet.
  • The beginning inventory column counts will automatically transfer to the corresponding weeks final inventory sheets.

             Weekly Alcohol Beginning Inventory Count Printout and Input Page

View Larger Image



At the end of the week:

  • Print out the above Ending Inventory restaurant inventory count sheet on place it on a clip board.
  • Do a walk-through and record how many bottles or cans you have in each area.
  • The total beginning inventory column will automatically calculate based on the figures you have entered on this sheet.
  • The beginning inventory column counts will automatically transfer to the corresponding weeks final inventory sheets.

Alcohol Ending Perpetual Inventory Page

View Larger Image







Once you have completed the beginning and ending inventories for that particular week, go to the final week inventory page.

You will need to enter figures into the white shaded cells. The colored cells are protected.  Once you have entered all the numbers into the white shaded cells..

At a glance you will see how many total servings used versus the POS readout.
It will show the difference between what was used versus what was actually sold.
You also will be able to see the variance on how much product was used and the total dollar amount attached to that product. In the fantasy world you would want no overage or no shortage.  In the real world you would want to tighten the gap as close as possible to reduce losses. The Alcohol Perpetual Inventory system will help tighten the gap if used consistently.

                                                 

Alcohol Weekly Final Input Page

View Larger Image

perpetual inventory


At a Glance Alcohol Perpetual Inventory

View Larger Image


The weekly alcohol at a glance sheet is a great tool to help pinpoint the shortages by comparing the actual week that you are on versus the previous week results. Look for consistent shortages from week 1 to week five.

Find out when the product went missing and who might be responsible. Check the schedules and see which employee is tied to the shortages with-in that particular time frame.