Product ABC Stratification Setup field descriptions

Fields are presented in alphabetical order.

GMROI Percent for Rank

Specify the parameters for calculating the GMROI stratification group. The default stratification logic ranks the GMROI greater than 200% as A, over 100% as B, over 0% as C, and anything else is D. You specify the first three values, and the system calculates the fourth.

Hits Percent by Rank

Specify the parameters for calculating the hits stratification group. The default stratification logic ranks the top 60% of hits as A, the next 20% as B, the next 10% as C, and the remaining 10% as D. The total must equal 100. You specify the first three values, and the system calculates the fourth.

Relative ABC Weighting Between Groups

Use these fields to adjust the stratification groups (sales, GMROI, and hits) to determine a final rank. The relative weighting percentage of the groups must equal 100%. Specify a relative weighting percentage in the first two fields, and the system derives the Hits %.

Relative Importance of Each Ranking

Relative importance specifies the importance of each rank - A, B, C, and D. The total must equal 100. You specify the first three values and the system calculates the fourth.

Relative Spread of Products Across Ranks

Use this field to set up the percentage of spread among each of the stratification ranks. The total must equal 100. You specify the first three values and the system calculates the fourth.

Sales Percent by Rank

Type the parameters for calculating the sales stratification group. The default stratification logic ranks the top 60% as A, the next 20% as B, the next 10% as C, and the remaining 10% as D. The total must equal 100. You type the first three values, and the system calculates the fourth.

Type

Whether you are searching for or creating a record, select the type of product the stratification logic applies to. The options are Stock or Order as Needed.

User Fields

Your system administrator sets up the fields in this section for reporting purposes. Contact your system administrator for information on these fields.

Warehouse

Whether you are searching for or creating a record, specify the warehouse to which the stratification logic applies.