C Appendix: Regular Pricing Optimization Rules
This table provides information about the Regular Pricing Optimization rules.
| Rule Sub Category | Rule Name | Rule Description | Rule Datatype | Requires Forecast? |
|---|---|---|---|---|
| Pack Pricing | RPO_SIMPLE_PACK_SELLABLE | Total price of the simple pack (multiple units of the same item) should be lower than the total price of the single item but at least this fixed value. | NUMBER | N/F |
| RPO_SIMPLE_PACK_SELLABLE_PCT | Total price of the simple pack (multiple units of the same item) should be lower than the total price of the single item but at least this percentage value of the total price of the single item. | PERCENTAGE | N/F | |
| RPO_COMPLEX_PACK_SELLABLE | Total price of the complex pack should be lower the total price of its components by at least this fixed value. | NUMBER | N/F | |
| RPO_COMPLEX_PACK_SELLABLE_PCT | Total price of the complex pack should be lower than the total price of its components by at least this percentage value of the total price of its components. | PERCENTAGE | N/F | |
| Competitor and CPI | RPO_COMP_MATCH_HIGHER | Price of the item needs to be higher than the competitor price by this value. | NUMBER | N/F |
| RPO_COMP_MATCH_HIGHER_PCT | Price of the item will need to be this much percentage higher than the competitor price. | PERCENTAGE | N/F | |
| RPO_COMP_MATCH_LOWER | Price of the item needs to be lower than the competitor price by this value. | NUMBER | N/F | |
| RPO_COMP_MATCH_LOWER_PCT | Price of the item will need to be this much percentage lower than the competitor price. | PERCENTAGE | N/F | |
| RPO_CPI_PCT_CHANGE_MAX | Consumer Price Index will need to be within this maximum percentage tolerance of a base historical CPI (e.g. previous year). | PERCENTAGE | F | |
| RPO_CPI_PCT_CHANGE_MIN | Consumer Price Index will need to be within this minimum percentage tolerance of a base historical CPI (e.g. previous year). | PERCENTAGE | F | |
| Cost Change | RPO_COST_CHANGE | If the cost of the item increases/decreases by this amount, regular price for the item must increase or decrease accordingly. | NUMBER | N/F |
| RPO_COST_PCT_CHANGE | Percentage of the cost change passed on to the regular price for the item. 100% means the regular price of the item must reflect the entire cost increase/decrease | PERCENTAGE | N/F | |
| Goal | RPO_OPTIMIZATION_OBJECTIVE | Optimization goal for pricing. Required for running optimization. RULE_VALUE should be set as one of the following: MAX_MARGIN, MAX_REVENUE, MAX_VOLUME. | TEXT | F |
| Inter-Item | RPO_INTER_ITEM_DIFF_MAX | Products in Set A need a price less or equal than this value compared to items in Set B. | NUMBER | N/F |
| RPO_INTER_ITEM_DIFF_MAX_PCT | Products in Set A need a price percentage less or equal than this value compared to items in Set B. | PERCENTAGE | N/F | |
| RPO_INTER_ITEM_DIFF_MIN | Products in Set A need a price greater or equal than this value compared to items in Set B. | NUMBER | N/F | |
| RPO_INTER_ITEM_DIFF_MIN_PCT | Products in Set A need a price percentage greater or equal than this value compared to items in Set B. | PERCENTAGE | N/F | |
| Inter-Loc/PZ | RPO_INTER_LOC_DIFF_MAX | Regular price for the same product in location A need a price less or equal by this value compared to same product in location B. | NUMBER | N/F |
| RPO_INTER_LOC_DIFF_MAX_PCT | Regular price for the same product in location A need a percentage price less or equal by this value compared to same product in location B. | PERCENTAGE | N/F | |
| RPO_INTER_LOC_DIFF_MIN | Regular price for the same product in location A need a price greater or equal by this value compared to same product in location B. | NUMBER | N/F | |
| RPO_INTER_LOC_DIFF_MIN_PCT | Regular price for the same product in location A need a percentage price greater or equal by this value compared to same product in location B. | PERCENTAGE | N/F | |
| Margin for Item | RPO_LIST_MARGIN_ITEM_MAX | List Margin for each item in the group/product hierarchy node needs to be less or equal than this value. | NUMBER | N/F |
| RPO_LIST_MARGIN_ITEM_MAX_PCT | List Margin for each item in the group/product hierarchy node needs to be less or equal than this percentage value. | PERCENTAGE | N/F | |
| RPO_LIST_MARGIN_ITEM_MIN | List Margin for each item in the group/product hierarchy node needs to be greater or equal than this value. | NUMBER | N/F | |
| RPO_LIST_MARGIN_ITEM_MIN_PCT | List Margin for each item in the group/product hierarchy node needs to be greater or equal than this percentage value. | PERCENTAGE | N/F | |
| RPO_MARGIN_ITEM_MAX | Margin for each item in the group/product hierarchy node needs to be less or equal than this value. | NUMBER | F | |
| RPO_MARGIN_ITEM_MAX_PCT | Margin for each item in the group/product hierarchy node needs to be less or equal than this percentage value. | PERCENTAGE | F | |
| RPO_MARGIN_ITEM_MIN | Margin for each item in the group/product hierarchy node needs to be greater or equal than this value. | NUMBER | F | |
| RPO_MARGIN_ITEM_MIN_PCT | Margin for each item in the group/product hierarchy node needs to be greater or equal than this percentage value. | PERCENTAGE | F | |
| RPO_MARGIN_ITEM_PCT_CHANGE_MAX | Margin for each item in the group/product hierarchy node needs to have a maximum percentage increase compared to base period (e.g. last year, last quarter). | PERCENTAGE | F | |
| RPO_MARGIN_ITEM_PCT_CHANGE_MIN | Margin for each item in the group/product hierarchy node needs to have a minimum percentage increase compared to base period (e.g. last year, last quarter). | PERCENTAGE | F | |
| Margin for Group | RPO_LIST_MARGIN_MAX | List Margin for group of items needs to be less or equal than this value. | NUMBER | N/F |
| RPO_LIST_MARGIN_MAX_PCT | List Margin for group of items needs to be less or equal than this percentage value. | PERCENTAGE | N/F | |
| RPO_LIST_MARGIN_MIN | List Margin for group of items needs to be greater or equal than this value. | NUMBER | N/F | |
| RPO_LIST_MARGIN_MIN_PCT | List Margin for group of items needs to be greater or equal than this percentage value. | PERCENTAGE | N/F | |
| RPO_MARGIN_MAX | Margin for group of items needs to be less or equal than this value. | PERCENTAGE | F | |
| RPO_MARGIN_MAX_PCT | Margin for group of items needs to be less or equal than this percentage value. | PERCENTAGE | F | |
| RPO_MARGIN_MIN | Margin for group of items needs to be greater or equal than this value. | NUMBER | F | |
| RPO_MARGIN_MIN_PCT | Margin for group of items needs to be greater or equal than this percentage value. | NUMBER | F | |
| RPO_MARGIN_PCT_CHANGE_MAX | Margin for group of items needs to have a maximum percentage increase compared to base period (e.g. last year, last quarter). | PERCENTAGE | F | |
| RPO_MARGIN_PCT_CHANGE_MIN | Margin for group of items needs to have a minimum percentage increase compared to base period (e.g. last year, last quarter). | PERCENTAGE | F | |
| Price Range | RPO_LAST_REG_PRICE_MAX_CHANGE | Item needs to have a maximum price change equal to this value compared to the last known regular price of the same item or a similar item. | NUMBER | N/F |
| RPO_LAST_REG_PRICE_MAX_PCT_CHANGE | Item needs to have a maximum percentage price change equal to this value compared to the last known regular price of the same item or a similar item. | PERCENTAGE | N/F | |
| RPO_LAST_REG_PRICE_MIN_CHANGE | Item needs to have a minimum price change equal to this value compared to the last known regular price of the same item or a similar item. | NUMBER | N/F | |
| RPO_LAST_REG_PRICE_MIN_PCT_CHANGE | Item needs to have a minimum percentage price change equal to this value compared to the last known regular price of the same item or a similar item. | PERCENTAGE | N/F | |
| RPO_PRICE_MAX | Price of item needs to be less or equal than this value. | NUMBER | N/F | |
| RPO_PRICE_MIN | Price of item needs to be greater or equal than this value. | NUMBER | N/F | |
| Pricing Group | RPO_WTHN_GROUP_AVERAGE_TOLERANCE | Price for the products within the group must be the average current regular price of the group, subject to tolerance equal to this value. To set equal to the average, tolerance should be set to 0. | NUMBER | N/F |
| RPO_WTHN_GROUP_AVERAGE_TOLERANCE_PCT | Price for the products within the group must be the average current regular price of the group, subject to tolerance as percentage of the average price. To set equal to the average, tolerance should be set to 0. | PERCENTAGE | N/F | |
| RPO_WTHN_GROUP_DIFF_TOLERANCE | Products within a single group need to have similar price with a tolerance equal to this value. To set equality within the group, tolerance should be set to 0. | NUMBER | N/F | |
| RPO_WTHN_GROUP_DIFF_TOLERANCE_PCT | Products within a single group need to have similar price with a percentage tolerance equal to this value. To set equality within the group, tolerance should be set to 0. | PERCENTAGE | N/F | |
| RPO_WTHN_GROUP_HIGHEST_TOLERANCE | Price for the products within the group must be the highest current regular price of the group, subject to tolerance equal to this value. To set equal to the highest, tolerance should be set to 0. | NUMBER | N/F | |
| RPO_WTHN_GROUP_HIGHEST_TOLERANCE_PCT | Price for the products within the group must be the highest current regular price of the group, subject to tolerance as percentage of the highest price. To set equal to the highest, tolerance should be set to 0. | PERCENTAGE | N/F | |
| RPO_WTHN_GROUP_LOWEST_TOLERANCE | Price for the products within the group must be the lowest current regular price of the group, subject to tolerance equal to this value. To set equal to the lowest, tolerance should be set to 0. | NUMBER | N/F | |
| RPO_WTHN_GROUP_LOWEST_TOLERANCE_PCT | Price for the products within the group must be the lowest current regular price of the group, subject to tolerance as percentage of the lowest price. To set equal to the lowest, tolerance should be set to 0. | PERCENTAGE | N/F | |
| RPO_WTHN_ZONE_DIFF_TOLERANCE | Locations within a single group need to have similar prices, subject to a tolerance level equal to this amount. Equality within the group, tolerance should be set to 0. | NUMBER | N/F | |
| RPO_WTHN_ZONE_DIFF_TOLERANCE_PCT | Locations within a single group need to have similar prices, subject to a tolerance percentage level equal to this amount. Equality within the group, tolerance should be set to 0. | PERCENTAGE | N/F | |
| Revenue for Item | RPO_REVENUE_ITEM_MAX | Revenue for each item in the group/product hierarchy node needs to be less or equal than this value. | NUMBER | F |
| RPO_REVENUE_ITEM_MIN | Revenue for each item in the group/product hierarchy node needs to be greater or equal than this value. | NUMBER | F | |
| RPO_REVENUE_ITEM_PCT_CHANGE_MAX | Revenue for each item in the group/product hierarchy node needs to have a maximum percentage increase compared to base period (e.g. last year, last quarter). | PERCENTAGE | F | |
| RPO_REVENUE_ITEM_PCT_CHANGE_MIN | Revenue for each item in the group/product hierarchy node needs to have a minimum percentage increase compared to base period (e.g. last year, last quarter). | PERCENTAGE | F | |
| Revenue for Group | RPO_REVENUE_MAX | Revenue for group of items needs to be less or equal than this value. | NUMBER | F |
| RPO_REVENUE_MIN | Revenue for group of items needs to be greater or equal than this value. | NUMBER | F | |
| RPO_REVENUE_PCT_CHANGE_MAX | Revenue for group of items needs to have a maximum percentage increase compared to base period (e.g. last year, last quarter). | PERCENTAGE | F | |
| RPO_REVENUE_PCT_CHANGE_MIN | Revenue for group of items needs to have a minimum percentage increase compared to base period (e.g. last year, last quarter). | PERCENTAGE | F | |
| Volume for Item | RPO_VOLUME_ITEM_MAX | Volume for each item in the group/product hierarchy node to be less or equal than this value. | INTEGER | F |
| RPO_VOLUME_ITEM_MIN | Volume for each item in the group/product hierarchy node needs to be greater or equal than this value. | INTEGER | F | |
| RPO_VOLUME_ITEM_PCT_CHANGE_MAX | Volume for each item in the group/product hierarchy node needs to have a maximum percentage increase compared to base period (e.g. last year, last quarter). | PERCENTAGE | F | |
| RPO_VOLUME_ITEM_PCT_CHANGE_MIN | Volume for each item in the group/product hierarchy node needs to have a minimum percentage increase compared to base period (e.g. last year, last quarter). | PERCENTAGE | F | |
| Volume for Group | RPO_VOLUME_MAX | Volume for group of items needs to be less or equal than this value. | INTEGER | F |
| RPO_VOLUME_MIN | Volume for group of items needs to be greater or equal than this value. | INTEGER | F | |
| RPO_VOLUME_PCT_CHANGE_MAX | Volume for group of items needs to have a maximum percentage increase compared to base period (e.g. last year, last quarter). | PERCENTAGE | F | |
| RPO_VOLUME_PCT_CHANGE_MIN | Volume for group of items needs to have a minimum percentage increase compared to base period (e.g. last year, last quarter). | PERCENTAGE | F |