A Bill of Materials for A Cocktail Party 

Oleg Shilovitsky
Oleg Shilovitsky
8 October, 2019 | 3 min for reading
A Bill of Materials for A Cocktail Party 

Food is one of the best examples to illustrate the Bill of Materials Management and manufacturing. If you think about it more, any restaurant is practically a manufacturing shop floor. You have products (dishes) that must be manufactured (cooked). To make them, you need to buy standard parts and outsource work (food ingredients and other instruments). Many questions in restaurant planning such as pre-cooked components, timing of orders, demand and supply, scrap, etc. can be modeled in the same way as you do in the manufacturing business. 

Earlier today, I’ve got a question via OpenBOM website chat asking about how to create a bill of materials for a cocktail, manage ingredients orders and capacity. The question was too important to miss. Since my first blog about Thanksgiving Turkey BOM, I was looking at how to create a more mature example of a Bill of Materials for food. So, a cocktail is a great example and opportunity. 

Here is what I did. I grabbed a cocktail recipe online for “Midnight Cocktail”. 

As a next step, I created a catalog of ingredients that will be included in my bar inventory. The catalog includes information about each item – Part Number, Image, Description, Cost, Link to suppliers. Etc. 

An important element of the catalog is the Unit of Measure and conversion multiplier to convert from units of measures of stock item to the unit of measure for part usage (recipe). 

After that, I create a BOM for a single cocktail – Midnight Special. Here is a snapshot. 

I created a few formulas. The first formula for Quantity- to calculate Quantity in a unit of measure we plan to buy ingredients. The second formula is to calculate Extended Cost (Quantity x Cost), including total calculation. So, now I know what is the cost of a single cocktail.

And I used this BOM to simulate “Order BOM” for two batches of cocktail parties – for 30 cocktails and for 50 cocktails. And I learned that I have enough materials (ingredients) for 30 cocktails, but I will be running out of rum if I will attempt to make 50 cocktails party. 

The video below shows you the story. 

Conclusion

OpenBOM has a simple and powerful mechanism to manage parts (Items) and usage of these parts in the Bill of Materials. We call it the instance reference model at OpenBOM. The model is extremely robust and allows us to manage a variety of information (even a cocktail BOM :)). Cost calucation including rollups can be easily done. Catalog and order BOM planning mechanism allows you to plan purchases and estimation if you have enough parts in stock. 

I hope you loved the example. You can project how this use case can be applied to your company or team to produce catalog and bill of materials. 

If you have questions or ideas for future videos, please reach out to me. 

Best, Oleg @ openbom dot com.

Let’s get to know each other better. If you live in the Greater Boston area, I invite you for a coffee together (coffee is on me). If not nearby, let’s have a virtual coffee session — I will figure out how to send you a real coffee.

Want to learn more about PLM? Check out my Beyond PLM blog and PLM Book website

Related Posts

Also on OpenBOM

4 6
4 September, 2025

In the last few weeks, we’ve been building in public and sharing the progress of OpenBOM BOM Excel MCP —...

3 September, 2025

We live in a digital world and data has become the most valuable business asset. Whether you are designing a...

29 August, 2025

Digital BOM is a foundation of all OpenBOM to ERP integrations. From the very early days of PLM, the connection...

28 August, 2025

In 2025, the push for better design-to-manufacturing integration is stronger than ever. But for many companies, this still gets reduced...

27 August, 2025

For decades, PDM meant file vaults, check-in/check-out, and revision control. But today’s products span mechanical, electronic, and software domains, with...

26 August, 2025

This article is part of OpenBOM BOM Excel MCP building in public. For the next few weeks, we are going...

22 August, 2025

In yesterday’s article – Understanding OpenBOM’s Multi-Tenant Data Model and System Configuration, I shared some insights about OpenBOM’s multi-tenant data...

21 August, 2025

In today’s manufacturing and engineering world, the term multi-tenant triggers both questions and confusion. Product Lifecycle Management (PLM) has historically...

20 August, 2025

Since the very beginning of OpenBOM, our mission has been to help engineers, manufacturers, and teams organize product information and...

To the top