Optimizing a formula using the Optimization Modeler

  1. Select Develop > Formula. The Formula form is displayed.
  2. Select the required formula.
  3. Select the Run Optimization icon from the toolbar. The Launch Optimization window is displayed.
  4. Select the required value in the Optimization Modeler field.
  5. Select the Run Initial Optimization check box.
  6. Click Start. The Run tab is displayed.
    Note: 
    • The Run tab is displayed only if the Run Initial Optimization check box is selected.
    • You can also use the Pre Optimization Calc and the Post Optimization Calc fields on the Main to pre-define the custom equations while performing the optimization process.
    • If the Hide Unchanged rows check box is selected, the value specified in Ingredient and Parameter grids are compared with the values in the Run tab and the unchanged rows are hidden.
    • You can modify the UOM field in the Item grid. The values in the Qty, Quantity Lo, Quantity Hi columns are populated from the value specified in the UOM field.
    • You can select Sort by Cost option in the Optimization Filter field to sort the data on the Run tab in the descending order, based on the cost values of the cost parameter selected in the Optimization Modeler.
    • The Items or Parameters are displayed in the Optimization Modeler window only if the Optimization Participant is set to Yes or Optional for the Item or Parameter specified on the Item Lines tab or Parameters tab in the Formula form. These items or parameters are selected by default if the Optimization Participant is set to Yes. However, you can modify this setting.
    • The column totals are displayed in the summary row for all columns specified in the Formula.Ingr.Totalcolumns profile attribute if MATERIAL_PCT;QTY_MASS;QTY_VOL;ACTIVE_QUANTITY;RELQTY_PCT AND ATTRIBUTE1-50 values are included. If no values exist for the profile attribute, the application calculates sum of all the above mentioned columns.
  7. Modify the required values.
  8. Click the Re-optimize icon. A new Run tab is displayed.
    Note: 
    • If the Compare Results check box is selected, the result in the Run tabs is compared and displayed in these colours:
      • Red: If the quantity is increased than the base quantity
      • Green: If the quantity is decreased than the base quantity
    • You can use the Delete option to remove the selected record.
    • You can use the Swap to edit option to move the Run tab as Source Formula which then becomes an input for re-optimizing the formula.
  9. Click the Send result into Formula icon. The Confirm window is displayed.
  10. Click Yes. The confirmation message is displayed in the Alerts window.
  11. Click OK.
  12. Click the Perform Calculation icon to:
    • Update the calculated from the Ingredients grid in the Optimization Modeler to the Item Lines tab on the Formula form.
    • Update the calculated from the Parameters grid in the Optimization Modeler to the Parameters tab on the Formula form.