ABC-XYZ Categorizations Worksheet lists all products with Current ABC-XYZ and System Recommended ABC -XYZ segmentation classifications.  

Use this information to see if you need to make any adjustments in the source systems.

ParametersValues
Current ABC

These values are dependent on a parameter in D1000 - Global Demand Parameters. The current segmentation values are one of these options:

  • Master data from the Enterprise Resource Planning (ERP) system.
  • A value calculated in the application at a particular point in time and stored. 
  • A live calculated segmentation.
System Recommended ABCThese values are system-generated segmentation values without user override values.
Current XYZ

These values are dependent on a parameter in D1000 - Global Demand Parameters. The current segmentation values are one of these options:

  • Master data from the Enterprise Resource Planning (ERP) system.
  • A value calculated in the application at a particular point in time and stored. 
  • A live calculated segmentation.
System recommended XYZThese values are system-generated segmentation values without user override values.
Current ABC-XYZDisplays the current combined segmentation values.
System Recommended ABC-XYZDisplays the system-generated combined segmentation values.

Select the product group cell in the table to display the ABC-XYZ categorization values for both current and system-generated values by product group.

Legend contains a key to the color-coding in the main worksheet.

If the cell has a clear background, this shows the current categorization is system recommended. If the cell is highlighted yellow, this shows the current categorization isn't system recommended.

To show the charts in the main content, select the icon in the top-right hand corner.

To view the ABC-XYZ categorization values for both the current and system generated values in the charts by product group, select a product group cell in the table.