Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Decision Logic offers numerous avenues for Supply Chain analysis.

  • Dig into trends and results, track revenue at every level and from multiple perspectives.
  • Gain valuable insight into your product usage, waste, and efficiencies through detailed inventory analysis.
  • Empower your managers with the information needed to make time-saving decisions, pinpoint gaps, and control food costs.

Find the following tools and more in the Decision Logic site menu under Reports > Cost and Variance.

Supply Chain Variance

Navigate to Reports> Cost and Variance> Usages Efficiency (IvA) 

We've also added a useful metric called Usage Efficiency. To learn more on this feature visit the Usage Efficiency page.

 

Ideal vs Actual (IvA)

Navigate to Reports> Cost and Variance> there are several IvA reports to choose from.

Find more detail on IvA Reports on the Ideal vs. Actual (IvA) Reporting page.

Style

Description

Reports

Ideal vs Actual (IvA)

Ideal vs Actual usage is recommended for use by restaurant managers as it focuses on quantity wasted, not the dollar amount of waste.  Example, instead of $50 of wasted chicken wings IvA displays 60 wings wasted

Ideal vs Actual is the amount actually used compared to the ideal amount used.  This is found by using the following /wiki/spaces/CST/pages/7897288:

Beginning Inventory + Purchases - Ending Inventory = Actual usage

Actual usage - Ideal usage = Variance

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

  • IvA Home

  • Top 20 Food IvA

  • All Food IvA

  • Beverage IvA

  • Non-IvA Usage

Multimedia
nameIVA.mp4
width600
height350

Table of Contents:

Table of Contents

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

Hot Item Reporting:

Hot Item IvA

Navigate to Reports> Cost and Variance> Hot Item IvA

Hot Item IvA displays the same variance reporting as IvA but for the daily hot item inventory

(lightbulb) Drill into specific food items to see the detail of the selected item


Theoretical vs Actual Reporting (TvA)

Navigate to Reports> Cost and Variance> there are several TvA reports to choose from 

Style

Description

Reports

Theoretical vs Actual (TvA)

Theoretical vs Actual usage is recommended for use by restaurant overhead as it focuses on dollar amount wasted, not quantity.  

Theoretical vs Actual is the dollar amount of actually used product compared to the dollar amount of ideally used product.  This is found by using the following /wiki/spaces/CST/pages/7897288:

Beginning Inventory + Purchases - Ending Inventory = Actual usage

Actual usage - Theoretical usage = Variance

Theoretical usage or the dollar amount used if zero product was wasted is calculated directly from product mix reporting that is pulled from the POS System

TvA Store Summary

Tva Rollup

TvA Store Summary

TvA Store Summary displays a store level view of the TvA Report.  The TvA Report includes a recipe category, non-recipe category, and non-inventoried category.

  • Recipe Category: Includes detail for ingredients that are in recipes and are inventoried
  • Non-recipe Category: Includes detail for ingredients that are not in recipes but are inventoried
  • Non-Inventoried: Includes detail for ingredients that are not inventoried or in recipes 

(warning) To set up non-inventoried items be sure the recipe measure is set to zero in the bid file.

(lightbulb) Drill into the category detail by selecting the category 

TvA Rollup

TvA Rollup displays a roll-up view of the TvA detail including Sales, Theoretical percentage, Actual percentage, Variance in dollars and variance in percentage.

TvA Ranking

TvA Ranking displays a ranking of each store selected in best highest variance to lowest variance in the form of Sales, Theoretical percentage, Actual percentage, Variance in dollars and variance in percentage.


Cost of Goods Sold (COGS)

Navigate to Reports> Cost and Variance> Cost of Goods Sold

StyleDescriptionReports
Cost of Goods Sold

Cost of Goods Sold is recommended for use by both restaurant overhead and store managers as it focuses on the percentage of salesCost of Goods Sold percentage is the percentage of sales of a product that was wasted in a specific time period. This is found by using the following /wiki/spaces/CST/pages/7897288

Beginning Inventory + Purchases - Ending Inventory = Cost of goods / Sales = Cost of Goods % of Sales

Cost of Goods Sold

COGS Report Descriptions and Usage:

Cost of Goods reports shows a store level or a roll-up of the cost of goods formula.

 (star) Note, COGS Sales is the Net Sales.

(lightbulb) Drill into the COGS category detail by selecting the category.

Multimedia
nameCOGS.mp4
width600
height350

COGS Extended Price

COGS total extended price is calculated by taking the Inventory Quantity divided by the Inventory multiplier and then multiplied by the Case price in the bid.  


COGS FAQ

Researching Variance Issues

When reviewing variance reporting it is best to research as soon as possible after an inventory is recorded and entered into Decision Logic. 

When users find items with a large variance take the following steps to help find a solution:

  • Find high variance items in Decision Logic 
  • Confirm both beginning inventory and ending inventory values are correct 
  • Review purchases to be sure all product was received at the correct quantities and price
  • Review ideal usage to be sure all product is depleting at the correct quantities (reminder: ideal usage is calculated directly from product mix reporting that is pulled from the POS System, depletion quantities are entered into menu maintenance in DL)
  • If all data entered into Decision Logic is correct and all values are depleting properly take into consideration the following:
    • over portioning
    • under portioning
    • theft
    • waste issues

COGS has missing sales data

If your sales data is not reporting on my COGS report, the cause is that Decision Logic had not received the sales data for the end of the week at the time that inventory was posted.

The steps to correct this are:

  • Validate you have sales in the DSR for Cogs week 
    Open your inventory
    Go to Inventory Home > Enter Inventory > and post your inventory again

(star) Note, posting inventory will cause an auto Cogs update to run for that current week, therefore you will not need to run a DL Update.