Formula Calculations

The following formulas are used to support the program Formula screen.

1. Serving Weight: This is the sum of the Amount Per Serving column.
2. Formula Cost: The unit for the Formula Cost field can be set in the Cost Unit field in the ribbon. Values for the Formula Cost column are rounded to two decimal places, but the program uses the unrounded numbers for calculating the total Serving Cost. (Unit weight removed) (Serving cost removed)
3. Batch Weight: This field is calculated using the following formula:
   Batch Weight = (Serving Weight x Servings per Container) x Number of Containers
4. Batch Cost: This field is calculated using the following formula:
   Batch Cost = Ingredient cost x Batch Weight
5. Percent Organic Total: This is the percent organic total for the formula
   Percent Organic Total = Sum of (Percent Organic amount entered at the ingredient level x the ingredient's percent of the the parent formula by weight)
6. Component Label Claim: This field reports the dry weight component amount, adjusted for the amount of moisture in the ingredient. It is calculated using the following formula:
   
   1. Definitions:
      Component Amount: the amount of component that corresponds to the ingredient label claim amount, before the moisture adjustment
      Component Label Claim: the amount of component that is displayed in the Label Claim column, after the moisture adjustment
   2. Formula Steps
      1. Adjusted Component Amount (adjusted for moisture loss) = 
         [component amount x ((100 – moisture loss) / 100)]

      2. Scale Factor =
         (component amount / adjusted component amount)

      3. Component Label Claim =
         (scale factor x component amount)

7. Amount Per Serving: This field reports the weight of ingredient that is needed to provide the label claim amount, adjusted for the amount of moisture in the ingredient and the reported overage. It is calculated using the following formula:

1. 1. Definitions
      Ingredient Label Claim: the amount of ingredient that is reported on the label, and is displayed in the Label Claim column
      Amount Per Serving: the amount of ingredient that is displayed in the Amount Per Serving column, after the moisture and overage adjustments have been made
   2. Formula steps
      1. Adjusted Ingredient Amount (adjusted for moisture loss and overage) =
         [ingredient label claim x ((100 – moisture loss) / 100)] x [(100 – overage ) /100]
      2.  Scale Factor = 
         (ingredient label claim / adjusted ingredient amount)
      3.  Amount Per Serving = 
         (scale factor x ingredient label claim)