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 Weekly 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.

weekly alcohol perpetual inventory

What is it for?

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. Then, determine the break down into ounces. Includes an “Alcohol by Ounces” chart 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. The process of elimination will pinpoint who was responsible for the shortage.

For Example:

If Steve was the only cook on during all the shortages than it is safe to say that Steve is the problem whether it 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 all the information. See the example below.

What do I do?

At 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.

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

Weekly Alcohol Perpetual Inventory  
Product Home Page WAS $39.99

For a Limited Time $19.99

A $20.00 Savings

Your cart is empty
Visit The Shop

weekly alcohol perpetual inventory home
click on the image to view a larger version

The home page shows all the other pages in the system so that you can easily find the items you are looking for.

Weekly Perpetual Alcohol Inventory – Product List Page

weekly alcohol perpetual inventory home
click on the image to view a larger version

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 within the system.

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

Input sheets for the Weekly Alcohol Perpetual Inventory

Perpetual Inventory record
click on the image to view a larger version
At the beginning of the week:

Print out the above beginning restaurant inventory count sheet and place it on a clipboard. Then walk-through each area and record how many bottles or cans you have in that area. Use the information to enter the figures onto the spreadsheet. The beginning inventory column counts will automatically transfer to the corresponding week’s final inventory sheets. The total beginning inventory column will automatically calculate based on the figures you have entered on this sheet.

At the end of the week:

Print out the related Ending Inventory restaurant inventory count sheet and place it on a clipboard. Then go to the areas where the items are stored and record how many bottles or cans you have in each area.

Come back and enter the information into the spreadsheet and the ending counts will automatically transfer to the corresponding week’s final inventory sheets.

Key Product Usage – Weekly Alcohol Perpetual Inventory

weekly alcohol perpetual inventory home
click on the image to view a larger version

Once you have completed the beginning and ending inventories for that particular week, go to the Weekly Product Usage page. You will need to enter figures into the white shaded cells. The shaded cells are protected. Once you have entered all the numbers into the white shaded cells.

Information at a Glance

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.

Alcohol Month at a Glance Page

weekly alcohol perpetual inventory home
click on the image to view a larger version

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.

Financial Tracking systems:
Inventory and Inventory/Sales Systems
Food Order Systems
Combinations of Inventory, Labor and Timekeeping Systems

©2012-2024 Copyright Workplace Wizards Restaurant Consulting Schim Enterprises LLC