This 1h course covers the basic calculations needed for hospitality. We will create spreadsheets with complete cocktail price calculation, explain gross profit, stock takes and pricing of items in stock, plus gross profit of the cocktail menu testing.
In each calculation lecture simple legend in PDF format is attached, to remind the functionality of the tables created. In the last course we will have a look on the business side and why are all these calculations so important. In this lecture there is also attachment of the complete spreadsheet with the calculations for MAC and WIN platforms.
Are you creating cocktail or drink menu? Do it professionally with all the calculations, testing and targets. This course will get you started!
Very basic overview of what we need to be focus on to start making our calculations
We will create price calculation of mixed drink, include gross profit & VAT. Legend attached
Testing the gross profit performance of the drinks menu by simulating sales and seeing overall gross profit in percentage and currency, total sales and total costs. Great tool to predict, if your menu can get you in to the cash flow problems. Legend attached
Creating stock take spreadsheet - part 1. - SPIRITS
Creating stock take spreadsheet - part 2 - WINES, SOFT DRINKS
Creating stock take spreadsheet - part 3. HOME-MADE items such as barrels, pre-made volumes etc, and TOTAL VALUE of stock
Complete spreadsheet for MAC and WIN attached.
Linking all the calculations from all the previous lectures and why we need them to run a business - basic logic.
If you want to have these calculations and many more on hand, you can download my iOS app iFNB
I am working in hospitality industry for 18 years now and in the past decade I was working in one of the London's finest cocktail bars - Montgomery Place, holding several positions including general manager. I have studied hospitality school back in my country (Czech Republic) together with economic post graduate. I do also photography and mobile app development. With my business partner we have opened UK based company Viral Ides ltd and recently we have launched our first product.