NIBD / Sales Mix Pricing Methodology

Business OpsNovember 14, 2018

Why Use the NIBD / Sales Mix Pricing Methodology

Army MWR business activities have been employing the COG Method of Pricing, which is where the invoice price of the liquor and garnish is divided by the desired COG%.    The COG Method is good for developing a quick starting point to what the final Sales price should be.  However, there may be many faults with this method.

The NIBD/Sales Mix Pricing Methodology more accurately represents the reality of business.  For example, selling a well drink and premium call drink will cost essentially the same Labor Cost; since it does not take any longer to pour from the different bottles.   The NIBD/Sales Mix Pricing Methodology captures this relationship accurately by assigning a fixed labor cost to each drink.  The COG Method assumes the labor percent will stay consistent; i.e. 40% Labor is $0.80 on a $2 drink and a $1.60 on a $4 drink.

Another factor to consider is having a lower COG% does not equate to maximizing bar profits.  Premium Call drinks will normally have a higher COG%; yet, they result in the most profit per drink.   The NIBD/Sales Mix Pricing Methodology allows the user to see this relationship and adjust their sale’s strategy accordingly (See Bartender / Wait Staff Scripts).

Note:  Specialty Drinks are not addressed with this pricing methodology and need to be priced specifically to how they are prepared.

How to Use the Worksheet

There are only 8 different types of raw data needed.  Each of these input areas have a corresponding instruction / example.  These instructions are color coded to allow for easier association between the data input area and its corresponding block of instruction.  The types of data needed are as follows:

  1. Invoice Price per Bottle (Landed Cost)
  2. Number of ounces in that bottle
  3. Sales Mix (estimated) within a specific type of liquor category [Well, Call or Premium Call]
  4. Sales Mix across all 8 liquor types (See Sales Mix Data Calculations)
  5. Average Cost of Garnish / Mixer
  6. Number of Drinks Sold
  7. Cost of Labor
  8. Cost of Other Operating Expenses

Once this information is put into the spreadsheet, the desired NIBD % for each tier needs to be entered in the results section.   Changing these percentages will automatically update the Sales prices and other financial information.   It is important to note, at this point, the relationships between the calculated NIBD %, COG % and Labor %.   The realism of these relationships is where this pricing methodology is far superior to the COG Pricing Method.

Now that the Sales prices are calculated, it is time to see what happens if they are adjusted.   Manually adjusting the Sales prices in the following section will show how the financial information would be affected.  This is a great way to show Leadership how their request for price changes will affect the NIBD.

Other Uses

This spreadsheet can continue to be used after prices are established.  First, put the established Sales prices in the ‘manually Sales price entry’ section.  After this, different pieces of data can be modified to see how it will affect the financial information.  The following is one of many different uses: 

A unit deploys and sales are expected to drop by 35%.  Assume labor and OOE are fixed due to already being at staffing minimums.  By lowering the number in ‘Number of Drinks Sold’ by 35%, the labor % and OOE% increases per drink; even though, the actual dollar value of these numbers is the same.  The most important thing to note; however, is the substantial drop in profit per drink and NIBD %. 

Sales Mix Data Calculations

This is a relatively easy methodology to use; once the sales mix data is calculated.  Activities utilizing an automated POS system, like Mircros or RecTrac, should be able to easily acquire this information directly from the POS.  Those activities without this information will need to pull and tally the daily inventory sheets over a sufficient time period (a minimum of 1 month) to accurately reflect the average bar sales.   The sales mix percentage is then calculated with the following formula: 

(# of vodka drinks sold) / (# of total liquor drinks sold)

This calculation will need to be done for each of the eight types of liquor; with the ‘# of total liquor drinks sold’ being the same for all eight calculations.  An error in calculation has occurred if the sum of these 8 percentages does not equal 100%.  These percentages are very important to this method of pricing and should be as accurate as possible.  Note:  These percentages should be based on number of drinks sold and not dollar value of drinks sold.

Latest News

Take_2.png

Historical Documents and Videos

Added by SSG Mackall, Cody - DA BOSS RepresentativeAugust 17, 2022

We love to share ideas, no matter what year they are from!

BOSS.png

BOSS Executive Summary (EXSUM)

Added by SSG Mackall, Cody - DA BOSS RepresentativeFebruary 15, 2022

  DA Executive Summary Directorates Executive Summary April 2022 April 2022 May 2022 May 2022 June 2022 June 2022 July...

November 04, 2021

Life Skills

Life Skills events are designed specifically to educate or certify Soldiers in a wide variety of abilities for adaptive and positive behavior....

October 18, 2021

Soldier Showdown Resources

Click here for all Soldier Showdown Social Media Content and Links to Registration!

October 06, 2021

Continuity Book

These resources will allow you to take the products provided below, and make them fit to your Garrison!  There are many different documents,...

October 06, 2021

Resources

Click here for a full list of useful resources pertaining to BOSS!

October 04, 2021

Post Restaurant Survey

The following survey has been designed to gather information from our customers to assist in making better business decisions. The survey is...

October 01, 2021

BPAA Bowling Training

The following training  links are Army Bowling Center Managers. There are presentations, sample handouts, and marketing materials to help...

March 30, 2020

Home Based Business (HBB)

People are Always My #1 Priority. -          General James C. McConville, Army Chief of...

February 18, 2020

Sample SOP

Sample SOP