What and where is the All Food IvA report?
This article shows managers where to find the All Food IvA report and what is on it.
Overview
The All Food IvA report allows users to compare ideal usage quantities to actual usage quantities. In addition, insight into food variance can help users better manage food costs by investigating which items have the largest variance. Managers can often mitigate large variances by daily counting, calibrating weights, and portioning correctly.
Items labeled as “Food” for the Type of ingredient and have the “IvA” box checked inside Ingredient Management will display on the All Food IvA report. Ingredients are managed in Ingredient Management for users with “change” permissions, such as a Decision Logic Administrator.
The All Food IvA report has similar concepts and layout as the Beverage IvA report.
View All Food IvA Report
Once logged into Decision Logic from a web browser, navigate to:
Reports > Cost and Variance > All Food IvA
Select the Company, Region, Area, or Store.
Click View X Store.
Select a Date Range.
The green dot under a date represents the beginning of a store’s inventory cycle. When multiple stores are selected, users may see multiple labor calendars.
Period Start is the beginning of that store’s period.
Toggle By Category, Usage Efficiency, or both.
By Category: This shows the breakdown of food by Category.
Usage Efficiency: This shows the select store(s) usage efficiency and the company’s efficiency for each item.
Click Apply.
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
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.
Low efficiency percentage indicates the store is not efficient. High efficiency percentage Indicates the store is efficient. The goal is to be at 100% efficiency which means the store has used the product they should have.
If a store’s efficiency is higher than the company’s efficiency, then the store is doing better at managing that ingredient than compared to the rest of stores on the system.
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.
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) |
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.
Print or Export Report
After logging into the web-based application, navigate to:
Reports > Cost and Variance > All 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.
Toggle By Category, Usage Efficiency, or both.
By Category: This shows the breakdown of food by category.
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.
Export Example
© 2025 Knowledge Management Systems, LLC. Decision Logic. All Rights Reserved.