Versions Compared
Version | Old Version 18 | New Version 19 |
---|---|---|
Changes made by | ||
Saved on |
Key
- This line was added.
- This line was removed.
- Formatting was changed.
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 the item has 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
Table of Contents | ||||
---|---|---|---|---|
|
Info |
---|
For additional questions or assistance, please submit a support ticket by visiting the Decision Logic Service Center. |
Info |
---|
Unable to access this feature in the Decision Logic platform?
|
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, and or Store.
Click View X Store.
Image Added
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.
Image Removed
Image Added
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.
Image Removed
Image Added
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.
Image Removed
Image Added
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, and or Store.
Click View X Store.
Image Added
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.
Image Removed
Image Added
Info |
---|
Check out these helpful links. |
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.