Planning hierarchies example

An example of a planning hierarchy of the type Item. For each hierarchy level, a code list with a linked parent and description is required. This diagram shows the process to setup an item planning hierarchy:

Table 1. Code List 1 - Items
Code (Item) Description (Family) Key Spreading factor
GOO-500 GOO 500ml GOO 50
GOO-330 GOO 330ml GOO 50
WIDGET-500 Widget 500g WIDGET 60
WIDGET-275 Widget 275g WIDGET 40
Table 2. Code List 2 - Item Family
Code (Family) Description (All) Key Spreading factor
GOO GOO Family AllItems 2
WIDGET Widget Family AllItems
Table 3. Code List 3 - All Items
Code (All) Description
AllItems All Items
Table 4. Item Planning Hierarchy
Level Name Code List Description Attribute Parent Attribute Spreading Factor Attribute
All Items AllItems AllDescription
Item Family ItemFamily FamilyDesc AllItemKey FamilyShare
Items ItemMaster ItemDesc FamilyKey ItemShare