Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add FNB Calculations (Drinks + Stock Take) to your Wishlist.

Add to Wishlist

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
Created by Ales Olasz
Last updated 1/2016
30-Day Money-Back Guarantee
  • 1 hour on-demand video
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

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!

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.
Students Who Viewed This Course Also Viewed
What Will I Learn?
Deliver basic FNB calculations & understand its importance
Cocktail Price
Gross Profit Menu Testing
Stock Take
Implementation into Business
View Curriculum
  • You should be familiar with working in table spreadsheets such as Mac Numbers or MS Excel
Curriculum For This Course
Expand All 8 Lectures Collapse All 8 Lectures 01:12:18
FNB Calculations (hospitality)
8 Lectures 01:12:18

Very basic overview of what we need to be focus on to start making our calculations

Preview 03:59

We will create price calculation of mixed drink, include gross profit & VAT. Legend attached

Preview 13:07

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

Gross Profit Testing

Creating stock take spreadsheet - part 1. - SPIRITS

Legend attached

Stock Take - Part 1

Creating stock take spreadsheet - part 2 - WINES, SOFT DRINKS

Stock Take - Part 2

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.

Stock Take - Part 3

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

About the Instructor
5.0 Average rating
1 Review
8 Students
2 Courses
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.

Report Abuse