FNB Calculations (Drinks + Stock Take)
5.0 (2 ratings)
8 students enrolled
Wishlisted Wishlist

FNB Calculations (Drinks + Stock Take)

Basic guide to determine cocktail price calculation, gross profit, stock taking and testing.
5.0 (2 ratings)
8 students enrolled
Created by Ales Olasz
Last updated 1/2016
English
Price: \$30
30-Day Money-Back Guarantee
Includes:
• 1 hour on-demand video
• 5 Supplemental Resources
• Access on mobile and TV
• Certificate of Completion
What Will I Learn?
• Deliver basic FNB calculations & understand its importance
• Cocktail Price
• Stock Take
View Curriculum
Requirements
• You should be familiar with working in table spreadsheets such as Mac Numbers or MS Excel
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!

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
Curriculum For This Course
8 Lectures
01:12:18
+
FNB Calculations (hospitality)
8 Lectures 01:12:18
Preview 01:00

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
10:28

Creating stock take spreadsheet - part 1. - SPIRITS

Legend attached

Stock Take - Part 1
12:01

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

Stock Take - Part 2
09:58

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
09:47

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

https://itunes.apple.com/gb/app/ifnb/id328979438?mt=8&uo=4