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
For additional questions or assistance, please submit a support ticket by visiting the Decision Logic Service Center.
Unable to access this feature in the Decision Logic platform?
Contact your Decision Logic Administrator to make Scope and Security adjustments to your user profile or add new features.
Some features are client-specific.
View Negative Food IvA
Once logged into Decision Logic from a web browser, navigate to:
Reports > Cost and Variance > Negative Food IvA
Select the Company, Region, Area, or Store.
Click View X Store.
Select a Date Range.
The green dot under a date represent an inventory cycle and will default to the current week.
Period Start is the beginning of that store’s period.
Users can toggle Usage Efficiency if applicable.
Usage Efficiency: Shows the usage efficiency for the select store(s) and the company’s efficiency for each item
Click Apply.
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.
If a single-store is selected in the parameters and is missing an inventory during the date range selected, an alert will appear and the page will not show data.
Above-store users who have access to multiple locations will have a clear view of only stores that have posted all inventories during the date range selected to provide accurate data. A message will appear, and the user can click View Stores to see the locations that do not have inventories posted.
Clicking View Stores populates a side panel displaying the stores excluded from the results. This means that the store(s) do not have posted all inventories for the selected timeframe and are omitted from reporting.
Example.
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
Metric Name | Calculation |
Recipe Total | Recipe Units x Units Sold |
Recipe Mx | Conversion between Ingredient’s Inventory Measure and its Recipe Measure. Example: 1 Case = 4 Each. 1 Each = 6 LBs. |
Ideal Usage | Recipe Total / Recipe Mx; sum of all inventory unit totals |
Actual Usage | Beginning Inventory + Orders Received - Ending Inventory Orders Received includes credits and Inter Unit Transfers (IUT) |
Variance | Actual Usage - Ideal Usage |
Usage Efficiency | 1 - (Recipe Variance / Ideal Usage) |
Print or Export Report
After logging into the web-based application, navigate to:
Reports > Cost and Variance > Top 20 Food IvA
Select the Company, Region, Area, or Store.
Click View X Store.
Select a Date Range.
The dots under a date represent an inventory cycle and will default to the current week.
Users can toggle Usage Efficiency if applicable.
Usage Efficiency: This shows the select store(s) usage efficiency and the company’s efficiency for each item.
Click Apply.
Click Export CSV or Print.
© 2025 Knowledge Management Systems, LLC. Decision Logic. All Rights Reserved.