What and where is the Negative Food IvA report?

This article shows users where to find the Negative Food IvA report and what it means.

Overview

Negative Food IvA is when an item’s actual usage is less than the ideal usage.  Actual Usage is determined based on orders received and how much inventory is counted for that item.  Ideal Usage is based on Recipes and Menu Item sales. 

Items with the “IvA” box checked inside Ingredient Management are eligible to appear on this report if they have Negative Actual Usage. Ingredients are managed in Ingredient Management for users with “change” permissions, such as a Decision Logic Administrator.

Common causes for Negative IvA Variance:

• Under portioning.

• Incorrect inventory counts.

• Incorrect received amounts.

• Credits received on the incorrect week.

• Recipe portions are higher than they should be.

• Prepped item yields are incorrect.

Here’s an example of Negative Food IvA due to under portioning:

If the recipe calls for 6oz of cheese but the employee only portions or uses 5oz of cheese, each sale for the menu item is short 1oz.  This results in negative variance, meaning there is more product on hand than is ideal or expected.

Table of Contents

View Negative Food IvA

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

Reports > Cost and Variance > Negative Food 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. Users can toggle Usage Efficiency if applicable.

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

5. Click Apply.

   Open

   

    

If users do not toggle usage Efficiency when running the report, the results will appear in order from the highest variance based on Cost. Additionally, users can click on an individual item to display the Product Details, 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 the negative variance.

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 above.

The goal is to strive for 100% usage efficiency for Store(s) and Company Efficiency.

Calculations

Print or Export Report

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

Reports > Cost and Variance > Top 20 Food IvA

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

2. Click View X Store.

3. Select a Date Range.

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

4. Users can toggle Usage Efficiency if applicable.

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

5. Click Apply.

6. Click Export CSV or Print.

What and where is the Beverage IvA report?

What and where is the All 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.