FNB Calculations (Drinks + Stock Take)

Basic guide to determine cocktail price calculation, gross profit, stock taking and testing.
5.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
8 students enrolled
Instructed by Ales Olasz Business / Operations
Take This Course
  • Lectures 8
  • Length 1 hour
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2015 English

Course Description

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!

What are the requirements?

  • You should be familiar with working in table spreadsheets such as Mac Numbers or MS Excel

What am I going to get from this course?

  • Deliver basic FNB calculations & understand its importance
  • Cocktail Price
  • Gross Profit Menu Testing
  • Stock Take
  • Implementation into Business

Who is the target audience?

  • This course is meant to be for newbies in FNB calculations, but any level is welcome. No prior knowledge is needed, except the basics of working in spread sheets.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: FNB Calculations (hospitality)

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

Legend attached


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


Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Ales Olasz, Founder of Viral Ideas ltd

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.

Ready to start learning?
Take This Course