Ingredient Management

Decision Logic offers the ability to view cost and variance reporting across all distribution centers with Ingredient Management.

• Create ingredients for all inventoried items

• Ingredients will be used in 

  • Prepped Items

  • Menu Items

  • Bid Files

• Start by Navigating to Maintenance > Product > Ingredient Management or search "Ingredient Management".

Open

Recipe Cost flag:

When checked:

• The ingredient will be included in the Recipe Cost on the TvA Store Summary report.

• The ingredient will report as normal on the Cost & Variance report.

When unchecked:

• The ingredient will be included in Non-Recipe Cost on the TvA Store Summary.

• The ingredient will have zero Variance on the Cost & Variance report.

• The ingredient will have a Non-Rec icon on the Cost & Variance report.

IvA flag solely governs whether an ingredient is included in IvA reporting.

When checked:

• The ingredient will be included on IvA reporting.

When unchecked:

• The ingredient will be removed from IvA reporting.
  
  

Table of Contents

Creating a New Ingredient

Begin by navigating to:

Maintenance > Product > Ingredient Management

1. Click New Ingredient.

   Open

   

2. Define the Ingredient information:

   1. Ingredient Name

   2. Type

   3. Account

   4. Show on IvA by checking the box.

   5. Treat as Recipe Cost is defaulted as checked. Uncheck if necessary.

   6. Allow Credits by checking the box.

3. Define the Measures:

   1. Recipe by the…

   2. Inventory by the…

   3. Click Show Measure to define the measurements in more details.

      1. Check or uncheck the appropriate Recipe and Inventory boxes.

      2. Click New Measure to add new measurement.

         1. Define the Measure Name, check the appropriate Recipe and Inventory boxes, and Save.

4. Select the Ingredient Group.

   1. Click Show Ingredient Group to view group details.

      1. Click New Group to create a new group.

      2. Enter the Group Name and Save.

5. Click Save.

Search Ingredient

Users can search for individual items in the Search Bar and click Go. The search will populate a list of ingredients matching the search word entered. Right click on any ingredient to view Mapping Info, Show Recipes, Edit, or Delete that item.

View Mapping Info

Users can right-click to on an ingredient and click Mapping Info to view mapping info.

Users can dive deeper by clicking on an item in this view to see Edit the Bid File Item. The information displayed may vary depending on the ingredient.

Example 1

Example 2

• Bid File Mapping- All the bid file items that are mapped the ingredient by the distributor, including Account, Pk\Sz\Price\Rec Ms\Inv Ms\Broken Case Flag (on or off)\Catch Weight\Shrink

• Order Guide Mapping - will show you the Order Guide Name the ingredient is on, which bid file item that order guide is using, and which Distributor that bid file item comes from.

• Inventory Sets – details on set name, hot item flag, and comments.

Show Recipes

Users can right click on an ingredient to Show Recipe details.

Edit Ingredient 

Users can right click on an ingredient to access the Edit feature and Save their changes.

If you change measures, you will also need to update your bid file multipliers accordingly. 

Delete an Ingredient

By design, our system does allow you to delete data that has historical reporting. Instead, we recommend that you change the name for prepped items or ingredients with a preface of X or DNU or Do Not Use.

Users can right click on an ingredient to Delete the item. Users will select Yes to confirm the deletion.

FAQ Keg Credits

If you need to have both credits AND deposits tracking as separate line items on a single receive you will need to create 2 ingredients and 2 bid files (one for the credit and one for the deposit). Then be sure to put the ingredient on the inventory set and bid file items on the order guides for a Manual Receive. 

If you want to manage these as a single line item:

• Create a single ingredient called keg credit/deposit.

• Create a bid file item under each distributor as a single item number with a positive price.

• put the ingredient on the inventory set.

• put the dc item # on the order guide.

When doing manual receive:

• Credits should be entered as a negative quantity.  

• Deposits should be entered as a positive quantity.

We want to ensure that all customers have access to our most current templates for the bulk import of data into Decision Logic.  We can generate the following templates for you at any time. These can be returned via email to helpdesk@decisionlogic.co

Import Templates  

• Ingredients

• Bid file Items

• Menu items 

How it works:

1. Start with the Ingredient Template. Fill that out with any items we need to set up for inventory and send it back to helpdesk@decisionlogic.co

2. Once we import ingredients for you, you can ask we generate a new version of the attached bid file template that will contain all the new ingredients we just imported to help you quickly complete bid file mapping

3. Fill out 1 Bid File Template for each mydlweb.com (Restaurant website) for each Distributor, we are adding items for and sending them back to us. 

Example: If we are adding bid files to 5 different distributors, you would send back 5 different excel files, each named by the Distributor. 

4. Once we import, the next steps for you would be:

• Add new Ingredients to Inventory Set.

• Add bid file items to Order Guides.

• Build Recipes in Recipe Book.

•  Bulk Menu Item Import. For those using Recipe Book, this feature is currently disabled on your sites in the user interface but we can still import items via the database with the templates. 

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