How-To: Adding Ingredient Costs in Genesis R&D Foods | ESHA Research

One of the more underused features of Genesis R&D Foods is the cost entry option. With it, you can enter costs at the Ingredient level and the program will calculate the total and/or per-serving cost of your Recipe. This blog will show you:

• How to Enter Ingredient Costs
• How to View and Override the Calculated Recipe Costs
• How to View the Total Cost for Each Ingredient
• How to View the Total Cost for the Recipe on the Recipe Formulation Screen
• How to View the Per-Serving Cost for Each Ingredient in the Spreadsheet Report

Enter Ingredient Costs

Ingredient costs can be assigned to both user-added Ingredients and ESHA database Ingredients. You can add costs to the Ingredients before or after adding the Ingredients to a Recipe. In this example, we are using a Recipe that has already been created, and the Ingredients do not yet have costs.

For an existing Recipe, it’s easiest to open the Ingredients from within that Recipe.

1. With the Recipe open, right-click on the Ingredient and select Open Item. This opens the Ingredient record.
2. Click Cost in the left-hand menu.
3. Select the item you want to enter a Cost for and click the Edit button.
   
4. Enter the cost of your item. When you enter the cost of your item, the program will automatically convert the cost based on the measurement you use in your Recipe and/or scale the cost per the amount of the Ingredient. (In this example, we entered a cost of $.69 per 1 pound.) 
   
5. Click OK.
6. Save and close the Ingredient.
7. Continue doing the same for all of the other Ingredients in the Recipe.

Note: To clear the cost, highlight the row and click the Clear button.

View and Override the Calculated Recipe Costs

Genesis R&D will calculate your per-serving Recipe cost based on the costs of the Ingredients entered. If your calculations have come up with a different total Recipe cost, you can override the calculated cost.

1. With your Recipe open, click Edit Recipe and select Cost. Here you see the Recipe’s cost per serving.
   
2. If you would like to override the Recipe cost, click Edit and enter in a new cost. (In this example, we entered $.60 per serving.)
   
3. Click OK. You’ll see both the calculated and overridden costs. The overridden cost is now active.
   
4. To revert to the Calculated Cost, you will need to remove the Overridden Cost. To do so, highlight the Overridden field and click Remove.

View the Total Cost for Each Ingredient

1. With your Recipe open, right-click on the recipe window and select Display Columns.
2. Under the list of Primary Columns, check the Cost box.
3. Click OK. Here you see the total cost for each ingredient, scaled to the amount entered in your Recipe. Remember that the bananas were entered into the Recipe with the “each” measure, but the cost was entered per pound. Genesis R&D converted the cost automatically.
   

View the Total Recipe Cost on the Recipe Formulation Screen

1. From the top ribbon, click on the Home Tab and select My Preferences.
2. Select the General tab, and under Display, check Show Costs.
   
3. Click OK.
4. Total Recipe cost and cost per serving (in parenthesis) are displayed at the top.
   

View the Per-Serving Cost for Each Ingredient in the Spreadsheet Report

In order to view costs in the Spreadsheet report, you must first make sure your Nutrients to View list includes Cost as a nutrient.

1. With your Recipe open, click the Reports tab.
2. Select Spreadsheet.
3. At the bottom of the report, you will see the total Per Serving Cost for the whole Recipe. You can also see the breakdown by ingredient.  If your Recipe contains another Recipe, you will see the contributing cost of the nested recipe.
   

Watch the Tutorial

This tutorial goes over these steps in a video format: