How do I build an item hierarchy for a brewery pallet?

Describing a brewery pallet – example

A brewery pallet consists of a full pallet with two half pallets on it. On each half pallet there are two trays with 24 bottles in each. Four layers of trays and bottles are stacked on each other. At the top of each stack there is an empty tray which locks the upper layer of bottles. The bottles, trays and pallets have deposits which must be given in trade item information. Each item can have information on one or more deposits. Each deposit can be associated with a given quantity.

The item hierarchy consists of three levels:

Pallet level

  • The pallet level is the full pallet.
  • Dimensions and weight include the full pallet’s height and weight
  • Packaging type: pallet.
  • If a returnable full pallet with deposit is used, the deposit code for a returnable full pallet is given.

Case level

  • The case level is the half pallets with the two stacks.
  • For a mixed pallet, the item hierarchy has several items at case level
  • Dimensions and weight include the half pallet’s height and weight
  • Packaging type: pallet.
  • If a returnable half pallet the deposit is used, the deposit code play a returnable half pallet is given.
  • The case level item also includes the deposit for the 10 trays on each half pallet

Base unit level

  • The lowest level of the item hierarchy is the base unit level, which in this case is a 1½ litre PET- bottle with beverage
  • For a mixed pallet, the item hierarchy has several items at base unit level
  • Deposit code for 1½ litre PET is given.

This is how an item hierarchy with deposits looks for a homogeneous and mixed pallet:

Homogeneous pallet

Item level

 Item Contained item   Number of contained items Deposit/Quantity
Pallet level Full pallet Half pallet 2 Deposit code for returnable full pallet / 1
Case level  Half pallet Bottle 192 Deposit code for returnable half pallet / 1
Deposit code for tray /10
Base unit level    Bottle Deposit for PET 1½ l / 1

Mixed pallet

Item level  

 Item Contained item Number of contained items Deposit/Quantity

Pallet level

Full pallet Half pallet A
Half pallet B
1
1
 Deposit code for returnable full pallet / 1

Case level 

Half pallet A Bottle A 192

Deposit code for returnable half pallet / 1

Deposit code for tray /10

Case level Half pallet B Bottle B 192

Deposit code for returnable half pallet / 1

Deposit code for tray /10

Base unit level Bottle A Deposit for PET 1½ l / 1
Base unit level Bottle B Deposit for PET 1½ l / 1