What and where is the Beverage IvA report?

This article provides insight into the Beverage IvA report and where to find it.

Overview

The Beverage IvA report allows users to dive into beverage ideal usages versus actual usage quantities.  Insight into beverage usage can help leverage food menu prices to stay competitive, determine which items are moving off the shelf but not being accounted for, and more.  

It displays the variance of items set up as a “beverage” in Decision Logic.  For example, beverage items may be labeled as Liquor for the Type of ingredient and must have the “IvA” box checked to appear on this report.  Ingredients are managed in Ingredient Management for users with “change” permissions, such as a Decision Logic Administrator.

Check with your organization on how they have labeled beverages.

Additionally, users can print or export the Beverage IvA report.

Table of Contents

View Beverage IvA Report

Once logged into Decision Logic from a web browser, navigate to:

Reports > Cost and Variance > Beverage IvA

1. Select the Company, Region, Area, or Store.

2. Click View X Store.

   Open

   

3. Select a Date Range.

   1. The green dot under a date represent an inventory cycle and will default to the current week.

   2. Period Start is the beginning of that store’s period.

4. Toggle By Category, Usage Efficiency, or both.

   1. By Category: This shows the breakdown of beverages by Category.

   2. Usage Efficiency: This shows the select store(s) usage efficiency and the company’s efficiency for each item.

5. Click Apply.

   Open

   

    

By Category

By Category, results show a breakdown of each category and the items that fall within it. Clicking on an individual item will pull up the Product Details page, which provides a more in-depth look at the calculations for the item.

The report displays the Recipe Variance, Inventory Variance, Cost Variance, and % of Sales affected.

The Cost is the market value of how much it would cost to replace the item.

Product Details

Usage Efficiency

Usage Efficiency is a visualization of the dollar variance as a percentage of Ideal Usage. In addition, the report shows a bar graph for Store(s) Efficiency and a vertical line for Company Efficiency. These metrics are a comparison between the store selected and other stores.

Clicking on an individual item will pull up the Product Details page, which provides a more in-depth look at the calculations for the item. Check out the image in By Category above.

The report also displays the Recipe Variance, Inventory Variance, Cost Variance, and % of Sales affected.

The goal is to strive for 100% usage efficiency for Store(s) and Company Efficiency. Some ways managers can increase efficiency are:

• Pour tests for bartenders.

• Proper usage of utensils, such as jiggers instead of free-pouring.

• Pre-measured beverages.

Calculations

Print or Export Report

After logging into the web-based application, navigate to:

Reports > Cost and Variance > Beverage IvA

1. Select the Company, Region, Area, and Store.

2. Select a Date Range.

   1. The dots under a date represent an inventory cycle and will default to the current week.

3. Toggle By Category, Usage Efficiency, or both.

   1. By Category:  Shows the breakdown of beverages by category.

   2. Usage Efficiency:  Shows the usage efficiency for the select store(s) and the company’s efficiency for each item.

4. Click Apply.

5. Click Export CSV or Print.

    

Export Example

What and where is the All Food IvA report?

What and where is the Negative Food IvA report?

What and where is the Top 20 Food IvA report?

What and where is the Non-IvA Usage report?

What and where is the Cost and Variance report, and how do I customize or export it?

What and where is the Payroll Report?

What and where is the TvA Store Summary report?

What and where is the Cost of Goods Sold (COGS) report?

© 2024 Knowledge Management Systems, LLC. Decision Logic. All Rights Reserved.