Stock Management

for Opyos Beverages

Stock Management

for Opyos Beverages

Opyos Stock Management

Our friends at Opyos Beverages produce high-quality spirits
"Made in Luxembourg".

As they are constantly expanding their range, they naturally also have to take care of the stocks of ingredients. The young entrepreneurs had a concrete idea of how the whole thing should look and had already worked out a good basis. The only problem was that the solution did not allow them to automatically remove all the ingredients of a recipe from the stock.

To avoid having to deliver all the ingredients individually each time, we needed an extended solution and this is where we got talking.

The specifications:

Excel

The solution should be in Excel

Remove

It must be possible to remove individual ingredients from the stock

Add

It must be possible to add individual ingredients to the stock 

Remove all ingredients

It must be possible to remove all ingredients stored in a recipe from the stock at once

Expandable

The solution must be expandable to add new recipes

Simple

Operation should be simple

The result

After a short pondering, I implemented the requirements in Excel and now the three friends can remove all ingredients of a recipe, with just one click, from their stock and thus have more time to tinker with new recipes and make tasty drinks.

Visit the Luxembourg gin distillers on their website or on Facebook.

We would like to thank Opyos Beverages for your trust!

Would you like further information?