Item Rating Setup
Item Rating Setup lets you configure the weights and the rating levels limits for the metrics.
General FastTab
Rating Levels FastTab
See also
The weight can vary between 0 to 3. The more important the metrics are, the higher weights they should have.
Tip: You can deactivate any metric by setting its value to 0.
You can use the Reset Parameters to Default Values action on the Item Rating Setup page to reset all the setup fields to their default values.
The following table describes the fields of Item Rating Setup:
General FastTab
Default Rating Levels Limits
Field |
Description |
Default Low Level Limit %
|
Specifies the percentage used to calculate the low level threshold. An item will be given a rating Low for a particular metric, if the item's metrics value is below or equal to this threshold. |
Default Medium Level Limit %
|
Specifies the percentage used to calculate the medium level threshold. An item will be given a rating Medium for a particular metric, if the item's metrics value is below or equal to this threshold but higher than the low level threshold. |
Default High Level Limit %
|
Specifies the percentage used to calculate the high level threshold. An item will be given a rating High for a particular metric, if the item's metrics value is below or equal to this threshold but higher than the medium level threshold. |
Daily Sales Weights
Field |
Description |
Average Daily Sales Weight
|
Specifies the factor that will be multiplied with the rating of the Average Daily Sales metric to form the weighted score. |
Daily Sales Frequency Weight
|
Specifies the factor that will be multiplied with the rating of the Daily Sales Frequency metric to form the weighted score. |
Daily Sales Standard Deviation Weight
|
Specifies the factor that will be multiplied with the rating of the Daily Sales Standard Deviation metric to form the weighted score. |
Weekly Sales Weights
Field |
Description |
Average Weekly Sales Weight
|
Specifies the factor that will be multiplied with the rating of the Average Weekly Sales metric to form the weighted score. |
Weekly Sales Frequency Weight
|
Specifies the factor that will be multiplied with the rating of the Weekly Sales Frequency metric to form the weighted score. |
Weekly Sales Standard Deviation Weight
|
Specifies the factor that will be multiplied with the rating of the Weekly Sales Standard Deviation metric to form the weighted score. |
Monthly Sales Weights
Field |
Description |
Average Monthly Sales Weight
|
Specifies the factor that will be multiplied with the rating of the Average Monthly Sales metric to form the weighted score. |
Monthly Sales Frequency Weight
|
Specifies the factor that will be multiplied with the rating of the Monthly Sales Frequency metric to form the weighted score. |
Monthly Sales Standard Deviation Weight
|
Specifies the factor that will be multiplied with the rating of the Monthly Sales Standard Deviation metric to form the weighted score. |
Other Weights
Field |
Description |
Out-of-stock Weight
|
Specifies the factor that will be multiplied with the rating of the Out-of-stock metric to form the weighted score. |
ABC Sales Weight
|
Specifies the factor that will be multiplied with the rating of the ABC Sales metric to form the weighted score. |
ABC Profit Weight
|
Specifies the factor that will be multiplied with the rating of the ABC Profit metric to form the weighted score. |
Unit Price Weight
|
Specifies the factor that will be multiplied with the rating of the Unit Price metric to form the weighted score. |
LS Forecast Score
Field |
Description |
Minimum Score
|
Specifies the minimum possible Score. This value is calculated based on the weights of all metrics and the lowest possible rating level (1). |
Maximum Score
|
Specifies the maximum possible Score. This value is calculated based on the weights of all metrics and the highest possible rating level (3). |
No. of activated Metrics
|
Specifies how many metrics are currently activated i.e. having non-zero weights. |
Threshold Percent
|
Specifies the percentage value used to calculate the Score Threshold based on the minimum possible Score and the maximum possible Score. |
Score Threshold
|
Specifies the threshold used to decide the Total Rating. Items having Total Score equal to or above the threshold are classified as Good candidates for LS Forecast. Refer to Rating Phase for more details on how these values are calculated. |
Rating Levels FastTab
Unit Price
Field |
Description |
Use Default Limits
|
Specifies if the Low, Medium, and High percentages are equal to the default values. When you reactivate this check box, the Low, Medium and High percentages will be reset to the default values. |
Low level Limit %
|
Specifies the percentage used to calculate the low level threshold. If Use Default Limits is not selected, you can change this value. |
Medium Level Limit %
|
Specifies the percentage used to calculate the medium level threshold. If Use Default Limits is not selected, you can change this value. |
High Level Limit %
|
Specifies the percentage used to calculate the high level threshold. |
Average Daily Sales
Field |
Description |
Use Default Limits
|
Specifies if the Low, Medium, and High percentages are equal to the default values. When you reactivate this check box, the Low, Medium and High percentages will be reset to the default values. |
Low level Limit %
|
Specifies the percentage used to calculate the low level threshold. If Use Default Limits is not selected, you can change this value. |
Medium Level Limit %
|
Specifies the percentage used to calculate the medium level threshold. If Use Default Limits is not selected, you can change this value. |
High Level Limit %
|
Specifies the percentage used to calculate the high level threshold. |
Daily Sales Frequency
Field |
Description |
Use Default Limits
|
Specifies if the Low, Medium, and High percentages are equal to the default values. When you reactivate this check box, the Low, Medium and High percentages will be reset to the default values. |
Low level Limit %
|
Specifies the percentage used to calculate the low level threshold. If Use Default Limits is not selected, you can change this value. |
Medium Level Limit %
|
Specifies the percentage used to calculate the medium level threshold. If Use Default Limits is not selected, you can change this value. |
High Level Limit %
|
Specifies the percentage used to calculate the high level threshold. |
Daily Sales Standard Deviation
Field |
Description |
Use Default Limits
|
Specifies if the Low, Medium, and High percentages are equal to the default values. When you reactivate this check box, the Low, Medium and High percentages will be reset to the default values. |
Low level Limit %
|
Specifies the percentage used to calculate the low level threshold. If Use Default Limits is not selected, you can change this value. |
Medium Level Limit %
|
Specifies the percentage used to calculate the medium level threshold. If Use Default Limits is not selected, you can change this value. |
High Level Limit %
|
Specifies the percentage used to calculate the high level threshold. |
Average Weekly Sales
Field |
Description |
Use Default Limits
|
Specifies if the Low, Medium, and High percentages are equal to the default values. When you reactivate this check box, the Low, Medium and High percentages will be reset to the default values. |
Low level Limit %
|
Specifies the percentage used to calculate the low level threshold. If Use Default Limits is not selected, you can change this value. |
Medium Level Limit %
|
Specifies the percentage used to calculate the medium level threshold. If Use Default Limits is not selected, you can change this value. |
High Level Limit %
|
Specifies the percentage used to calculate the high level threshold. |
Weekly Sales Frequency
Field |
Description |
Use Default Limits
|
Specifies if the Low, Medium, and High percentages are equal to the default values. When you reactivate this check box, the Low, Medium, and High percentages will be reset to the default values. |
Low level Limit %
|
Specifies the percentage used to calculate the low level threshold. If Use Default Limits is not selected, you can change this value. |
Medium Level Limit %
|
Specifies the percentage used to calculate the medium level threshold. If Use Default Limits is not selected, you can change this value. |
High Level Limit %
|
Specifies the percentage used to calculate the high level threshold. |
Weekly Sales Standard Deviation
Field |
Description |
Use Default Limits
|
Specifies if the Low, Medium, and High percentages are equal to the default values. When you reactivate this check box, the Low, Medium, and High percentages will be reset to the default values. |
Low level Limit %
|
Specifies the percentage used to calculate the low level threshold. If Use Default Limits is not selected, you can change this value. |
Medium Level Limit %
|
Specifies the percentage used to calculate the medium level threshold. If Use Default Limits is not selected, you can change this value. |
High Level Limit %
|
Specifies the percentage used to calculate the high level threshold. |
Average Monthly Sales
Field |
Description |
Use Default Limits
|
Specifies if the Low, Medium, and High percentages are equal to the default values. When you reactivate this check box, the Low, Medium, and High percentages will be reset to the default values. |
Low level Limit %
|
Specifies the percentage used to calculate the low level threshold. If Use Default Limits is not selected, you can change this value. |
Medium Level Limit %
|
Specifies the percentage used to calculate the medium level threshold. If Use Default Limits is not selected, you can change this value. |
High Level Limit %
|
Specifies the percentage used to calculate the high level threshold. |
Monthly Sales Frequency
Field |
Description |
Use Default Limits
|
Specifies if the Low, Medium, and High percentages are equal to the default values. When you reactivate this check box, the Low, Medium, and High percentages will be reset to the default values. |
Low level Limit %
|
Specifies the percentage used to calculate the low level threshold. If Use Default Limits is not selected, you can change this value. |
Medium Level Limit %
|
Specifies the percentage used to calculate the medium level threshold. If Use Default Limits is not selected, you can change this value. |
High Level Limit %
|
Specifies the percentage used to calculate the high level threshold. |
Monthly Sales Standard Deviation
Field |
Description |
Use Default Limits
|
Specifies if the Low, Medium, and High percentages are equal to the default values. When you reactivate this check box, the Low, Medium, and High percentages will be reset to the default values. |
Low level Limit %
|
Specifies the percentage used to calculate the low level threshold. If Use Default Limits is not selected, you can change this value. |
Medium Level Limit %
|
Specifies the percentage used to calculate the medium level threshold. If Use Default Limits is not selected, you can change this value. |
High Level Limit %
|
Specifies the percentage used to calculate the high level threshold. |
See also
Item Suggestion
Basic Item Suggestion Setup