Ideal vs. Actual (IvA) Reporting

Ideal vs. Actual usage is recommended for use by restaurant managers as it focuses on quantity wasted, not the dollar amount of waste.

 

For example, instead of "$50 of wasted chicken wings," IvA displays 60 wings wasted.

What

Formula

Ideal vs Actual (IvA)

Ideal vs Actual is the amount actually used compared to the ideal amount used.  This is found by using the following formula:

(Beginning Inventory + Purchases) - Ending Inventory = Actual usage

Actual usage - Ideal usage = Variance

Ideal Usage

Ideal usage, or the quantity used if 0 product was wasted, is calculated directly from product mix reporting pulled from the POS System.

 

All Food IvA

All Food IvA displays the variance of every food item set up in Decision Logic and selected for the IvA Report. It organizes products by category and by highest variance based on cost value within the categories.

Navigate to Reports > Cost and Variance > All Food IvA

These reports are printable. Users can export to CSV.

 

All Food IvA Example Results_2024.png

 

Top 20 Food IvA

Top 20 Food IvA shows the 20 food products with the highest Ideal vs. Actual variance based on cost value of variance and likely need attention.

Navigate to Reports > Cost and Variance > Top 20 Food IvA

These reports are printable. Users can export to CSV.

 

Top 20 Food IvA Report example.png

 

Beverage IvA

Beverage IvA displays the variance of every item that is set up as a beverage in Decision Logic.  This is managed in Ingredient Management.

Navigate to Reports > Cost and Variance > Beverage IvA

These reports are printable. Users can export to CSV.

 

 

 

Negative Food IvA

Negative Food IvA allows the manager to see the 20 highest negative usage products in order by cost value of variance.

Navigate to Reports > Cost and Variance > Negative Food IvA

These reports are printable. Users can export to CSV.

 

 

Non-IvA Usage

Non-IvA Usage allows a user to see the usage for products that are not selected for the IvA Report. Non-IvA items are typically items a kitchen manager cannot control a guest's usage, are not built into recipes, or are just a cost of business. i.e. Ketchup bottles, pop syrup, fryer oil

Navigate to Reports > Cost and Variance > Non-IVA Usage

 

 

 

Duplicate IvA Reporting on an Ingredient

If several different Recipe Multipliers (RMX) are set up for an ingredient and you run the IvA report for ALL stores, you will see the ingredient reporting as many times as there is an additional RMX set up on the bid files mapped to that ingredient. 

This can usually be found in the Beverage IvA report, where stores order different pack sizes of liquor. If three stores order three different size bottles of house vodka, for example, and the report is run by ALL stores, then the house vodka ingredient will report three times. If you run the report by individual stores, it will only report once if that store only orders one pack size. 

Likewise, if one location has orders in the same week for two different pack sizes, which are both mapped to the same ingredient, then that location will see double reporting on their IvA. We suggest ordering only one pack size within a week to avoid this when possible.

 

Ideal Usage is Not Reporting

You will want to ensure that there is a recipe set up that includes the Ingredient that is not reporting Ideal usage.

If you have recently created a new ingredient that is replacing an older ingredient, you will want to ensure that the recipes also get updated. 

Once the Recipe has been updated, you will want to run a DL Update > to your IvA for any prior weeks you want the new recipe to report Ideal usage in.

 

If the recipe was changed mid-week, you might see a slight variance for that week while you are transitioning to the new product. 

You will want to ensure that all of your locations are inventorying the new ingredient to meet the Shelf Extension requirement of two consecutive weeks of inventory for complete reporting. 


© 2024 Knowledge Management Systems, LLC. Decision Logic. All Rights Reserved.

Table of Contents

For additional questions or assistance, please submit a support ticket by visiting the Decision Logic Service Center.



If you'd like to receive news on software releases and product updates, please sign up for our email list.