Table of Contents

METHOD09 - Mixed Method

Overview

The Mixed Method calculates handling unit quantity using a hybrid approach: full handling units are calculated based on capacity, while any remaining quantity uses volume-based calculation for pick handling units. This method combines the precision of capacity-based full handling units with the flexibility of volume-based partial handling units.

Purpose

This method calculates the Expected Shipment Handling Unit Qty. by:

  1. Calculating full handling units based on Qty. per UOM Code capacity
  2. Calculating remaining quantity after full handling units
  3. Calculating pick handling units for remaining quantity using volume (cubage)
  4. Optionally dividing pick handling unit volume by a factor
  5. Summing full handling units and pick handling units

Parameters

Parameter Name Type Description Default
PICKCUBFACTOR Decimal Divide pick cubage calculation with this factor (empty)

Algorithm

Step 1: Determine Handling Unit Type

Determine which handling unit type to use:

  1. Get first shipment handling unit type from conditions
  2. If empty, use DocumentLine."Handling Unit Type Code"
  3. If empty, get from Customer Item (Shipment or Receipt)
  4. If empty, get from Handling Unit Content table

Go to Step 2

Step 2: Get Handling Unit Type UOM

Retrieve the Handling Unit Type Unit of Measure:

  • Look up CarrierTypeUOM for customer item, unit of measure, and handling unit type
  • If not found, try handling unit type group

Go to Step 3

Step 3: Calculate Full Handling Units

If CarrierTypeUOM."Handling Unit Type Code" is not empty:

  • Calculate full handling units: 
    FullCarriers = Quantity div CarrierTypeUOM."Qty. per UOM Code"
RestQty = Quantity mod CarrierTypeUOM."Qty. per UOM Code"
  • Go to Step 4

Else:

  • No handling unit type UOM setup found
  • FullCarriers = 0
  • RestQty = Quantity
  • Go to Step 4

Step 4: Calculate Pick Handling Units (if RestQty > 0)

If RestQty > 0:

  1. Get Unit of Measure for the customer item

  2. Validate that UnitOfMeasure.Cubage is set

  3. Calculate pick handling units volume:

    PickCarriers = Round(UnitOfMeasure.Cubage × RestQty, 0.001, '>')

  4. If PICKCUBFACTOR > 0:

    • Divide pick handling units by the factor: 
      PickCarriers = PickCarriers / PICKCUBFACTOR

Go to Step 5

Step 5: Calculate Final Result

Result = FullCarriers + PickCarriers

Calculation Steps

Variable Definitions

  • A = Full handling units (integer)
  • B = Remaining quantity (RestQty)
  • C = Pick handling units volume (before factor)
  • D = Pick handling units (after factor, if applicable)
  • E = Final result

Step-by-Step Formula

  1. Calculate full handling units:

    A = Quantity div CarrierTypeUOM."Qty. per UOM Code"
B = Quantity mod CarrierTypeUOM."Qty. per UOM Code"

  2. If B > 0, calculate pick handling units:

    C = Round(UnitOfMeasure.Cubage × B, 0.001, '>')

  3. Apply pick cubage factor (if PICKCUBFACTOR > 0):

    D = C / PICKCUBFACTOR

    Else:

    D = C

  4. Calculate final result:

    E = A + D

Examples

Example 1: Basic Mixed Calculation

Scenario:

  • Quantity = 175 pieces
  • CarrierTypeUOM."Qty. per UOM Code" = 50 pieces per handling unit
  • UnitOfMeasure.Cubage = 0.05 m³ per piece
  • No PICKCUBFACTOR

Calculation:

  1. Full handling units: A = 175 div 50 = 3 handling units (150 pieces)
  2. Remaining quantity: B = 175 mod 50 = 25 pieces
  3. Pick handling units volume: C = Round(0.05 × 25, 0.001, '>') = 1.25 m³
  4. Pick handling units: D = 1.25 (no factor)
  5. Result: E = 3 + 1.25 = 4.25 handling units

Result: 4.25 handling units

Example 2: With Pick Cubage Factor

Scenario:

  • Quantity = 200 pieces
  • CarrierTypeUOM."Qty. per UOM Code" = 60 pieces per handling unit
  • UnitOfMeasure.Cubage = 0.04 m³ per piece
  • PICKCUBFACTOR = 0.5 m³ per handling unit

Calculation:

  1. Full handling units: A = 200 div 60 = 3 handling units (180 pieces)
  2. Remaining quantity: B = 200 mod 60 = 20 pieces
  3. Pick handling units volume: C = Round(0.04 × 20, 0.001, '>') = 0.8 m³
  4. Apply factor: D = 0.8 / 0.5 = 1.6 handling units
  5. Result: E = 3 + 1.6 = 4.6 handling units

Result: 4.6 handling units

Example 3: No Handling Unit Type UOM Setup

Scenario:

  • Quantity = 100 pieces
  • No Handling Unit Type UOM setup found
  • UnitOfMeasure.Cubage = 0.06 m³ per piece
  • PICKCUBFACTOR = 1.0 m³ per handling unit

Calculation:

  1. Full handling units: A = 0 (no setup)
  2. Remaining quantity: B = 100 pieces (all quantity)
  3. Pick handling units volume: C = Round(0.06 × 100, 0.001, '>') = 6.0 m³
  4. Apply factor: D = 6.0 / 1.0 = 6.0 handling units
  5. Result: E = 0 + 6.0 = 6.0 handling units

Result: 6.0 handling units

Example 4: Exact Full Handling Units

Scenario:

  • Quantity = 150 pieces
  • CarrierTypeUOM."Qty. per UOM Code" = 50 pieces per handling unit
  • UnitOfMeasure.Cubage = 0.05 m³ per piece

Calculation:

  1. Full handling units: A = 150 div 50 = 3 handling units (150 pieces)
  2. Remaining quantity: B = 150 mod 50 = 0 pieces
  3. Pick handling units: D = 0 (no remainder)
  4. Result: E = 3 + 0 = 3 handling units

Result: 3 handling units

Important Notes

  • Full handling units use capacity-based calculation (more precise)
  • Pick handling units use volume-based calculation (more flexible)
  • The PICKCUBFACTOR allows you to convert volume to handling unit count
  • If no Handling Unit Type UOM is set up, all quantity becomes pick handling units
  • The method combines the best of both capacity and volume approaches
Edit this page