Creating User-Defined Breakpoints

Product Ranking is used to compare the activity of a product to all other products within the same price line, a group of price lines, or all price lines. By default, the system sets product ranking breakpoints by percentage only. These breakpoints are displayed in the Ranking Breakpoints area of the Product Ranking Report. These percentages apply to all product ranking methods. You can adjust the percentages, as needed. However, if the percentages alone do not assist your forecasting, you can add breakpoint rules to include ranges and percentages of totals to further define each rank.

For example, Rank#1 is set to Hits. However, the standard breakpoints based on the cumulative % might not be what you consider an ”r;A” ranked item. The low moving line could have an ”r;A” ranked item with just six (6) hits for example, based on the cumulative %.

With the Advanced Ranking you can set a different rule for each rank.  If a rule is not set, the system uses the standard break points.  In the example of Hits, a user can specify the absolute value for the number of hits required for a product to be classified as an ”r;A” ranked product. For example, a rule for Hits could be that ”r;A” ranked products must have 50 or more hits or 20% of the cumulative and still have at least 30 hits. The additional ”r;or” statement adds additional flexibility to this and does not have to be used.

The system uses standard product ranks or any user-defined ranks you have defined. Any user-defined breakpoints override the Ranking Breakpoints. Use user-defined product ranks in conjunction with user-defined product breakpoints to tailor your ranking and best suit your warehouse set up.

To create a user-defined breakpoint:

  1. From the Purchase > Forecasting menu, select Product Ranking.

  2. In the Ranking ID field, enter the rank to which you want to add user-defined ranks and press Enter.

  3. In the Ranking Method area, select the method you want to edit and from the Edit menu, select Edit Advance Ranking Breakpoints to display the Advanced Ranking for <method> window.

You can also right-click the method you want to update and select Edit Advance Ranking Breakpoints.

  1. Use the columns to add or adjust the column values to refine your selected rank.

Note: Alt-Delete clears the values in the table for the line the cursor is on.

  1. Save your changes and exit the window.

The system automatically displays an indicator when a user-defined breakpoint exists:. Click here to see how this indicator looks on the window.

Note: After making changes you must reschedule the Product Ranking Program for the system to apply the changes.

See Also:

Creating User-Defined Breakpoints

Viewing Product Ranks

Product Ranking Method and Breakpoint Rules