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.

View All Food IvA Report

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

Reports > Cost and Variance > All 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 represents the beginning of a store’s inventory cycle. When multiple stores are selected, users may see multiple labor calendars.

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

Calculations

Table of Contents

Print or Export Report

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

Reports > Cost and Variance > All 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. Toggle By Category, Usage Efficiency, or both.

   1. By Category: This shows the breakdown of food by category.

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

Export Example

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