Back

5 key steps to facilitate inventory and better manage your inventory

How can you simplify your inventories so that they're finally done on a regular basis? Here's our advice on how to establish a new routine, optimize inventory management, and quickly identify margin losses.

Hugo Prevot

Hugo Prevot

16

Nov 2023

5 key steps to make inventory easier and better manage your restaurants' inventory
In this article :

For restaurateurs and managers alike, stocktaking is often a nightmare. 

And yet, regular inventories are essential to optimize your production costs, better manage supplier orders and meet demand without running out of stock.

From set-up tooperation, here's our advice on how to save time, establish a new routine and set up efficient procedures for stress-free inventory management.

1. Define and organize your storage areas

This is the first step towards optimal organization. Good planning of storage areas reduces errors and facilitates product counting.

Identify your zones, here are a few examples: fresh, frozen, dry, hygiene, etc.

Then segment into sub-zones, e.g. for fresh : 

  • Fees
  • Fruits and vegetables
  • Creamery
  • Meat
  • Fish
  • etc.

When it comes to organization, follow these key principles:

  • Sort by BBD using the FIFO(first in, first out) method to avoid losses and waste.
  • Place heavy items within easy reach to optimize the process.
  • Make sure storage areas are easily accessible. Avoid overhead storage (or provide easy access).

2. Optimize storage for each type of stock

Well-organized storage areas facilitate permanent inventories and stock control.

  • Create a plan of the storage areas.
  • Adapt your displays to the characteristics of each area (humidity, cold, etc.). For example, if it's cold or damp, use plastic or metal supports.
  • Finally, plan a specific display for your strategic products (high use and/or high value) with, for example, different colors.

This organization facilitates counting procedures and reduces errors. Once you've organized your stock, it's time to check it.

3. Plan your inventories according to needs and item types

Recurrent and regular stocktaking is an essential part of running your restaurant: only by having a clear view of your inventory can you improve your food cost. 

  • At least one stock point every month. 
  • A weekly inventory for your strategic and high-value products in order to identify overconsumption of raw materials. These inventory reports, coupled with real-time inventory movements, allow for a detailed analysis of losses, a visualization of discrepancies and the detection of anomalies directly at the source.
  • A fortnightly inventory for products you order at least once a week.

Case study for a burger restaurant:

  • Weekly: steak (or other protein), cheese, buns...
  • Bi-Monthly: sauces, vegetables...
  • Monthly: beverages, packaging...

Finally, define a time of day when inventories are taken: this can be before the start of the service or at the end of it. Choose a time when the inventory will not be interrupted in order to limit the risk of error.

Now that you know when you're going to do your inventory, decide how you're going to track it.  

{{banner_leadmagnet}}

4. Set up a tool to report your stock and track its evolution

The use of management software enables you to digitize the tracking and optimization of your goods flows. It enables you to keep track of data and analyze it to adapt your orders. 

Remember to detail your inventories with the most relevant information:

  • All the references of your mercurial
  • Storage areas for each of the references
  • The recurrence of inventory for each product 
  • The different packaging of the product (unit, pack, carton, kg...) 

Finally, get a scale to make it easier to report the products you order by weight.

Organization and rigor will be the central elements of the success of your inventories. These same inventories will give you a clear vision of your stocks and you will then be able to place the most accurate orders. 

Excel spreadsheets are difficult to fill in, and create errors in inventory returns. By simplifying your inventories with a tool like Inpulseit's no longer a headache to carry out an inventory, and it's finally possible to set up regular stock feedback.

Discover the multi-unit inventory functionality available in the Inpulse application. Request an appointment with an expert.

5. Add value to your stock and analyze it

Now that your inventory is done, it is important to go further into the analysis of your inventory. Here are some questions to ask yourself: 

  • Has my inventory increased in value and quantity?
  • Has my loss percentage increased or decreased?
  • What is the difference between my theoretical consumption and my actual consumption?

The analysis of your stock is to be carried out with at least 2 stock points opposite

The variation in stock quantity (+15 Steak for example) must be taken into account. This variation is weighted by the quantity ordered between the two inventories. Otherwise, the inventory value evolves according to the quantity (logical), but also to the product price evolution.

Example: I have 22 steaks (+15) in my stock compared to the previous week, and the price of my steak has increased from 1€ to 1,10€. So I go from a valuation of my steak stock of 7€ to 27,50€ (instead of 25€ if the value of the product had not increased).

Analysis track: The stock of steaks increases both in quantity and in value. I should adjust my orders so that the stock does not increase again and avoid losses.

The inventory also allows you to quantify your losses

The idea is also to see the quantity and value of your losses and to follow the evolution from one inventory to another.

Example: I threw away 2 kg of lettuce at S-1 and 1 kg this week. The price remained the same, €2/kg.

Analysis track: I adjusted the ordered quantities and limited the losses.

The last element is key to refining the analysis of the first two. First of all, you need to define your theoretical consumption, which is based on your technical data sheets.

Example for a cheeseburger:

  • 1 Bun
  • 2 slices of Cheddar cheese
  • 1 Steak
  • 10g of Ketchup
  • 5g of onions
  • 3 Gherkins

If I sell 10 cheeseburgers, my theoretical consumption is as follows: 

  • 10 Buns
  • 20 Slices of Cheddar cheese
  • 10 Steaks
  • 100g of Ketchup
  • 50g of onions
  • 30 Pickles

My Stock at S-1 was 7 Steaks. I ordered 30, that is to say a Stock for my week of 37. My theoretical consumption is 10 Steaks, that is to say a theoretical stock of 27, but I have 22 left (real consumption).

So I have a differential of 5 to analyze with my teams (lost, burned, fallen steak...). The price of the steak being 1€20, there is also a differential of 11€ in value.

By following these 5 steps, you can improve your inventory processes, reduce shrinkage and ensure effective stock optimization. Adopt the right management tools to monitor stock levels regularly and accurately.

While inventory valuation may seem complicated, Inpulse Inpulse makes it easy to access your inventory data and interpret these analyses in minutes. You can analyze by store: current inventory status, projected inventory, variance of theoretical and actual inventory, inventory transfer, finished goods shrinkage analysis to identify margin losses and take steps to reduce them.

We hope that this article will help you to understand your inventories in all serenity. We recently organized a webinar with Pitaya to share concrete advice on how to improve inventory management. Speakers will deliver their best practices for regular inventories.

Here is an excerpt from the webinar, to see the replay in its entirety, it is here.

To go further

More than 3,000 restaurants and stores use Inpulse on a daily basis