Lists out configured business rules for auto-creating Blend Sheets. The following rules are the rules followed while selecting input lots to produce the blend:

Pick Order - Picks input lots based on one of the following rules

  1. FIFO - First In First Out - The input lot which is received first is selected first.
  2. FEFO - First Expired First Out - The input lot which will expire first is selected first. Suppose 2 input lots "A" and "B" are present. "A" will expire after one year and "B" will expire after two years. In this scenario, "A" is selected first.
  3. LIFO - Last In First Out - The input lot which is received last is selected first.
  4. LEFO - Last Expired First Out - The input lot which will expire last is selected first. Considering the same example given in FEFO, in this scenario, B is selected first.

Is Quality Data Applicable?

  1. if it is "Yes", Quality Capture of the input lots are done at the point where samples are received. Suppose 2 input materials A and B which have lots A1, A2 and B1, B2 respectively are required to produce a blend (output material) which has a standard Density range of 100-200. The median ((Max.Value + Min. Value)/2) of this range is 150. Best Combination of lots (A1 B1, A1 B2, A2 B1, A2 B2) are selected automatically by the system based on the absolute difference of the density values of the input lots with respect to the median of the Density range of the output material.

    CombinationA1B1A1B2A2B1A2B2
    Weighted Average139140149159
    Median150150150150
    Deviation (Difference between Weighted Average and Median201019

    According to the above table, the combination A2 B1 is selected to produce the blend as it is nearest to the median.

    NOTE: When two combination of lots have the same quality deviation with respect to the median, then the next quality parameter is considered for selection. In case, all the quality parameters fail, then the next business rule will be considered.

  2. If it is "No", Lots are selected based on Pick Order

Is Cost Applicable?

  1. Yes - The least expensive lot is selected first
  2. No - Lots are selected based on Pick Order



  • No labels