The Logistics Quantity Structure (LMG) forms the data basis for logistics planning with ipolog 4 Material Flow.
Structure of import file
In this article we will present the columns of the LMG. Pleaes use the headers of each column as defined in the following table. Please also read carefully the hints we have listed up.
- Please do not change the name of the spreadsheet "IPO LMG" from the template
- Please do not change the column names (for cells A - AK) or remove columns from the logistics quantitiy framework.
- To create your own logistics quantity framework, please use the file "LMG_Customer-Template-New" from the attachment. The mandatory fields have to be filled in. In order to identify these fields more easily, please refer to the following table overview (column Mandatory and Optional)
|A||LOG-ID||x||Unique identifier for distinguishing part numbers and their attributes.||LOG-001|
|B||Module||x||As of Release 2019-07: Usually equals to the name of mutliple assembled single parts or subassemblies.||safety belt|
|C||Part Group||x||Multiple part numbers can be combined into a part group using any alphanumeric value.||Spiegel|
|D||Part Number||x||Mostly numerical identification of the part, also referred to as part number (PNR), article number or material number.||A0123456789|
|E||Part Name||x||Description of the part||Kotflügel rechts|
|F||Parts per Product||x||Specifies the quantity that is installed per finished product, for example, 4 M6 screws are installed per vehicle.||4|
|G||Part weight [kg]||x||As of Release 2019-07: Equals to the weight of the part, given in kg.||5,450|
|H||Assembly Rate [%]||x||indicates how often the part is assembled per product. The assembly rate is given in %. An assembly rate of 50 % means that the part is assembled in every second product.||50%|
|I||Number of Variants||x||Specifies the number of variants of a part. This specification can be used, for example, as a deciding factor for assigning parts to standard supply chains.||25|
|J||Supplier rate [%]||x||Indicates the percentage of a part supplied by a supplier, e.g. 100 % delivery rate means that the part is supplied by one supplier.||100%|
|K||Supplier||x||Name of the supplier||HELLO Scheinwerfer AG|
|L||Loading Unit-ID||x||Unique identifier for the technical differentiation of loading units. The loading unit ID must match the key in the resources.||LEGB-001235|
|M||Loading Unit-Name||x||Name of the loading unit, may differ from the value of the loading unit ID, but does not have to be||KLT-Gebinde|
|N||Loading Unit Width [mm]||x||Width of loading unit in mm||1200|
|O||Loading Unit Depth[mm]||x||Depth of loading unit in mm||800|
|P||Loading Unit Height [mm]||x||Height of loading unit in mm||1000|
|Q||Parts per Loading Unit||x||Number of parts in the loading unit||2500|
|R||Loading Unit Stacking Factor||x||Maximum number of loading units that can be stacked on top of each other. A stacking factor of 5 means that 5 loading units are stacked on top of each other.||5|
|S||Load Carrier ID||x||Unique identifier for the technical differentiation of load carriers. The load carrier ID must match the key in the resources.||K5123652|
|T||Load Carrier Name||x||Name of the load carrier, may differ from the value of the load carrier ID, but does not have to. This is the delivery and staging load carrier at the assembly point.||VDA-KLT-R-6419|
|U||Load Carrier Type||x||Classification characteristic for grouping specific load carriers/unit loads||KLT, GLT, SLT|
|V||Load Carrier Width [mm]||x||Width of the load carrier in mm||600|
|W||Load Carrier Depth [mm]||x||Depth of the load carrier in mm||400|
|X||Load Carrier Height [mm]||x||Height of the load carrier in mm||280|
|Y||Load Carrier Stacking Factor||x||Maximum number of load carriers that can be stacked on top of each other. A stacking factor of 10 means that 10 load carriers are stacked on top of each other.||10|
|Z||Load Carrier per Loading Unit||x||Maximum number of load carriers on a load unit||40|
|AA||Parts per load carrier||x||Number of parts in the load carrier. Also often referred to as load carrier content (LT content).||100|
|AB||Grouping Chain Name||x||Definition of the default grouping chain per part / part number.|
|AC||Grouping Load Carrier ID||x||Unique identifier for the technical differentiation of grouping load carriers. The grouping load carrier ID must match the key in the resources.|
|AD||Grouping Load Carrier Name||x||Name of the grouping load carrier, may differ from the value of the grouping load carrier ID, but does not have to.|
|AE||Grouping Load Carrier Width [mm]||x||Width of the grouping load carrier in mm|
|AF||Grouping Load Carrier Depth [mm]||x||Depth of the grouping load carrier in mm|
|AG||Grouping Load Carrier Height [mm]||x||Height of the grouping load carrier in mm|
|AH||Number of Compartmens per Grouping Load Carrier||x||The number of available compartments per carrier can be defined here|
|AI||Grouping Loading Unit ID||x||Unique identifier for the technical differentiation of grouping loading units. The grouping loading unit ID must match the key in the resources.|
|AJ||Grouping Loading Unit Name||x||Name of the grouping loading unit, may differ from the value of the grouping loading unit ID, but does not have to.|
|AK||Grouping Loading Unit Width [mm]||x||Width of the grouping loading unit in mm|
|AL||Grouping Loading Unit Depth [mm]||x||Depth of the grouping loading unit in mm|
|AM||Grouping Loading Unit Height [mm]||x||Height of the grouping loading unit in mm|
|AN||Number of Grouping Load Carriers per Grouping Loading Unit||x||The number of grouping load carriers per grouping loading unit can be set here|
|AO||Default Supply Chain Name||
|Definition of the standard supply chain per part / part number. Can be used, for example, as a decision criterion in the decision tree.||GLT-Blocklager, JIS, JIT|
|AP||Delivery Type Inbound||x||
A delivery type for inbound can be defined here so that a dock evaluation can be calculated.
Valid values are: Milkrun, Shuttle, General Cargo, Tour, Rail Transport, Sea Container, Other
|AQ||Station||x||Name of the assembly station from the imported layout (jsn)||BM-VHA-0002|
|Material Area 10 - 1
Material area disposal chain 10 - 1
|x||Name of the material area for supply and disposal chains||BM-VH-002-ML|
|Custom Column1 - 25||x||
Possible definition of customer-specific columns (e.g. supplier number). The customer-specific description must always start with "Custom".
Various products can also be added here, which are observed in the production data. More information here.
Custom supplier number
(as column header)
(as cell value)
If the custom columns are to be imported and read by the software, the predefined column names (custom 1 - 25) must be changed and values must be defined for the individual cells.
It is not possible to import more than 25 custom columns.
The columns AB - AK as well as the columns AL - BJ (if imported) can be shown and hidden:
- With this button the material areas can be hidden. All columns that are hidden by activating this function are highlighted in purple.
- With this button the custom columns can be hidden. All columns that are hidden by activating this function are highlighted in purple.
Error message during import:
If errors occur, the logistics quantity framework cannot be imported. Warnings inform the user that different data statuses exist here. An import of the logistics quantity framework is then possible despite warning messages.
|LOG-ID as a duplicate|
|Assembly rate >100%|
|Supplier rate >100%|
Different values Loading carrier ID / grouping load carrier ID
Different values Load unit ID / grouping loading unit ID
Values for parts per LU / parts per LC / parts per product are decimals
calculated weight of loading carrier > permitted weight of loading carrier
calculated weight of loading unit > permitted weight of loading unit
|Part names are the same for identical values in the Part Number column.|
|Different load unit names in the imported logistics quantity framework and in resource management for the same load unit ID|
|Different load carrier names in the imported logistics quantity framework and in resource management for the same loading carrier ID|
|Different specifications of length, width and height for a loading unit / grouping loading unit in the imported imported logistics quantity framework and in resource management for the same load unit ID / grouping loading unit ID|
|Different specifications of length, width and height for a loading carrier / grouping load carrier in the imported imported logistics quantity framework and in resource management for the same loading carrier ID / grouping load carrier ID|
Diff Report for Reimport
An already imported logistics quantity framework can be replaced in the software via reimport. The user is shown which changes have occurred compared to the previous version.
The individual cells can have four different values:
|green||This line is new in comparison to the previous version.|
|yellow||Individual values were changed here. The previous value for these cells is always in parentheses after the new value.|
|red||This entry has been deleted compared to the previous logistics quantity framework. Only whole lines are displayed in red.|
|white||No changes have been made here.|
The basis for the colored background of the columns in the colors green and red is always the LOG-ID.
In order to ensure as much transparency as possible for part groupings, four right rectangles are displayed before each part grouping in the Diff report. Each rectangle describes a different state that the values can assume. The number of changed rows of this part grouping is entered in this rectangle.
This could look like the following:
Here this means that the LOG-112 is the only one that has been added to this part grouping (green background).
The LOG-111 has been removed from the parts grouping (highlighted in red). For this reason, there is a red rectangle with the number 1 in front of the parts grouping.
The LOG-106 has been updated. Thus the number 1 is displayed in the yellow rectangle.
In this example, no part number of this parts grouping has remained unchanged. For this reason, a 0 is entered for each part grouping in the rightmost rectangle in the overview of changes.
Columns "Calculated data" - blue background
The calculation of the columns "Parts per day", "Load carriers per day" and "Load units per day" is based on the products per day.
This value is calculated in the software using one of the following options:
- When generating provision requirements in the software, the output is calculated and displayed in the Production Data submodule.
- The output, i.e. the products per day, is also calculated when importing exported provisioning requirements into the software ipolog 4 Material Flow from ipolog 4 Workspace.
In the software, the output is represented as follows:
As already mentioned, this output forms the basis for the calculation of the columns mentioned above. This looks as follows:
|Parts per day||Output * parts per product * assembly rate * supplier rate|
|Load carriers per day||Output * parts per product * assembly rate * supplier rate / parts per loading carrier|
|Loading units per day||Output * parts per product * assembly rate * supplier rate / parts per load unit|
The calculation is always based on LOG-IDs.
Weight of loading carriers and loading units
The columns "Loading carrier weight" and "Loading unit weight" are calculated on the basis of the part weight of the parts contained and the loading carrier or loading unit weight. The calculation looks as follows:
|Loading carrier weight||weight loading carrier + (number of parts per loading carrier * part weight [kg])|
|Loading unit weight||weight loading unit + (number of parts per loading unit * part weight [kg])|