

Gross Profit of a cocktail is calculated by subtracting the total cost of a cocktail from its retail cost. What is the gross profit & gross profit margins? The total cost and the unit wise cost of a drink is specified under different measures. This is calculated using the Beverage Price list spreadsheet. How to calculate Cost of a cocktail?Ī cocktail is a mix of varied drinks mixed in different proportions so in order to determine the cost, you need to know the cost of a per unit of each drink poured to be able to calculate the right cost of a cocktail.

You can calculate the cost of any cocktail accurately using the spreadsheet. This helps the cocktail business in earning gross profit margins and monitoring shrinkages which is important for the success of a flourishing business. This template provides the exact cost incurred in the preparation of a cocktail and serves as a guide for actual preparation. The template can be easily introduced into the business and the workforce be trained to use it. The cost calculator sheet helps you in calculating the retail price of the cocktail, its total cost, gross profit earned for the cocktail and total gross profit margin earned. Once the beverage price list is successfully created, you can use the Cocktail Cost Calculator to determine the gross profit and gross profit margin %. Whereas the garnish list provides the name of the garnish, its total size, UOM, total cost, portions and cost per portion. Every available drink is added to the list along with its size, UOM (unit of measure), total cost and the cost under different per unit measures. The table provides a detailed description of the cost and measure of all the drinks and other ingredient separately. The list is divided under the various categories like regular beverage, mixing beverage, fizz beverage, mixes, juices and garnish. Once the settings are specified a beverage price list can be created. It also has a volume conversion table that will help you in calculating the cost of a cocktail in spite of the fact that different mixes show different measures for a single bottle. This template provides a provision to select the default currency by selecting a country currency from the drop down menu of the currency symbol under the country specific settings. Begin by downloading the template and setting up your company.
