Inventory Planning > Inventory Families & Groupings > Families and Groupings - Details

Families and Groupings - Details

The information displayed in the various Details panes of the Families and Groupings program, relates to the node currently highlighted in the Collection Structure tree view.

Contents

Collection Contents pane

This indicates the contents of the currently highlighted node in the Collection Structure tree view. Sub-collections are indicated by a folder icon.

Column Description
Wh The warehouse for the item.

'--' indicates that all warehouses for the item are consolidated.

Stock code The code of the stock item.
Rev For ECC-controlled items, this indicates the revision of the stock item.
Rel For ECC-controlled items, this indicates the release of the stock item.
Uom The unit of measure for the stock item.
Product class The product class defined against the stock item.
Supplier The supplier defined against the stock item.
Planner The planner defined against the stock item.
Buyer The buyer defined against the stock item.

SKUs

SKUs pane

This displays information on the stock items contained in the collection. This is the same information that is displayed for SKUs on the Contents tab.

Stock Code Information pane

The following information is displayed for each stock item in the SKUs list view:

Column Description
Stock code
  • Stock Code Quick View
  • Query
  • Stock Code Setup
  • Multimedia
Rev/Rel For ECC-controlled items, this indicates the revision/release of the stock item.
Warehouse
  • Warehouse Quick View
  • Warehouses
Unit of measure The stocking unit of measure defined against the stock item.
Product class  
Cost The current inventory cost in the selected warehouse for the stock item.
List price The list price defined against the stock item.
Supplier
  • Supplier Quick View
  • Query
  • Supplier Setup
  • Multimedia
Replenishment item This indicates whether the item is defined as a replenishment item.
Forecast calendar  
Default lead time The lead time defined against the stock item.
Stock on hand  
Stock on order  
Stock on backorder  

Where Used

Where-Used pane

This indicates the collection(s) in which the currently highlighted collection or SKU occurs in the hierarchy.

Column Description
Collection The collection in which the item occurs.
Instance The instance of the collection in which the item occurs.
Description The description for the collection in which the item occurs.
Calendar The calendar to use for the collection in which the item occurs.
U/m The unit of measure defined against the collection in which the item occurs.
Consolidated Whether warehouses are consolidated in the collection in which the item occurs.
Algorithm The algorithm to use for the collection in which the item occurs.
Agg. Date The date on which the item was last aggregated.
Agg. Time The time on the date on which the item was last aggregated.

Pareto Analysis

Pareto analysis is performed for the collection currently highlighted in the Collection Structure tree view each time you select this tab.

The analysis is performed according to the parameters you defined and the results are displayed in the Pareto Summary, Pareto Graph and Pareto panes.

Pareto Summary pane

Column Description
Totals
Number of SKUs The number of stock items included in the analysis.
Number of hits  
Quantity The total quantity of the items included in the analysis.
Cost The total cost value of items included in the analysis.
Sales value The total sales value of items included in the analysis.
Profit The total profit value of items included in the analysis.
On hand value  
Parameters
Analysis base

The basis used for the analysis. It can be one of the following:

  • 1 - Sales value
  • 2 - Gross profit
  • 3 - Cost
  • 4 - Quantity
  • 5 - Hits
Analysis months The number of months used for the analysis.
Replenishment items only Yes indicates that the analysis included replenishment items only. No indicates that all items were included.
Include forecast adj Yes indicates that the analysis included sales adjustments.
Percentage breaks The percentage breaks used for the item types.
Include The item types included in the analysis.

Pareto Graph pane

This displays a graphical representation of the analysis.

Pareto pane

This displays information on the stock items included in the analysis.

Demand History

The panes on this tab indicate the sales history for the selected node in the tree view, accumulated into the forecasting periods as defined by the calendar in use.

The information is displayed in the Demand History Graph and Demand History list view.

Demand History Graph pane

This is a graphical representation of the demand history for the selected node in the Collection Structure tree view.

Forecasting

You use this to indicate the data sets to view, the year for which to display sales history and whether to display the current and draft forecasts. The panes on this tab display the forecasting information for the selected node in the tree view.

Menu options

This list view displays forecasting information for the currently highlighted node in the Collection Structure tree view.

Forecasting Graph pane

This is a graphical representation of the forecasts for the selected node in the Collection Structure tree view pane.

You use the options from the Forecasting menu to indicate the data sets to include on the graph, the year for which you want to display sales history and whether to display the current and draft forecasts.

[Note]

There is a limit on the number of data sets that can be graphed simultaneously. This limit depends on the number of periods being graphed as follows:

  • If the number of periods is greater than 36, then the maximum number of data sets that can be graphed is four.

  • If the number of periods is less than or equal to 36, then up to eight data sets can be graphed.

Forecasting Information pane

Column Description
Forecast basis The basis of the forecast values (quantity, sales or cost value).

You can select this option to change the basis and display the forecast values based on your selection.

Forecast algorithm The forecast algorithm on which the forecast values are based.

You can select this option to change the algorithm and display the forecast values based on your selection.

Algorithm used The algorithm to use as defined against the selected collection.
Competition measure The measure used for selecting the 'winning' algorithm when Competition is selected.
Months for competition The number of months to use for the Competition algorithm as defined against the selected collection.

The number of months into the past used to calculate the forecast error when choosing the 'winning' algorithm if Competition is used.

Forecast calendar The forecast calendar to use as defined against the selected collection.
Cumulative forecast error The calculated cumulative forecast error.
Mean absolute deviation The calculated mean absolute deviation.
Mean square deviation The calculated mean square deviation (also known as the mean square error).
Mean absolute % error The calculated mean absolute percentage error.
Tracking signal The calculated tracking signal.