B Appendix: Promotion and Markdown Pricing Optimization Rules
This table provides information about the Promotion and Markdown Pricing Optimization rules.
| Rule Category | RULE_NAME | Rule Description | Type |
|---|---|---|---|
| Budget | PRO_BUDGET_FLG | Allocate Budget | SWITCH - Yes/No |
| SWITCH - Yes/No | Planned Promotions Included in Budget | SWITCH - Yes/No | |
| PRO_BASE_TOTAL_BUDGET | Total Budget for Base Scenarios | NUMBER | |
| Exit Date | ABSOLUTE_EXIT_DATE | Date that an item must exit by. | DATE |
| REFERENCE_DATE_TYPE_FOR_EXIT |
Reference Date (Choose Options)
Final Shipment Date |
RADIO BUTTON | |
| EXIT_FISCAL_WEEK |
Specify the weeks to exit or fiscal week for exit (Choose Options)
Exit Fiscal Week |
RADIO BUTTON, followed by NUMBER depending on the option chosen | |
| Goal | PRO_PRICING_OBJECTIVE |
Choose one of the objectives:
Maximize Gross Margin from Salvage |
RADIO BUTTON |
| Post-Processing | PRO_RUNG_TIER_DISC_PCT | The descriptions and ranges for the discount tier labels | PERCENTAGE |
| Sell-Through | MIN_OH_INV_PCT | Minimum on hand inventory threshold percentage for the item to be eligible for a recommendation | PERCENTAGE |
| PRO_SALVAGE_VALUE | Salvage value of the product after the season ends (default is 0) | PERCENTAGE | |
| PRO_ST_HARD_TGT_FLG | Default value for sell-through hard target flag | Yes/No | |
| PRO_ST_END_REGULAR_SEASON | Percentage of sell-through for each individual product at end of regular periods | PERCENTAGE | |
| PRO_ST_END_CLEARANCE_SEASON | Percentage of sell-through for each product at end of clearance season | PERCENTAGE | |
| Targeted Offer | PRO_OFFERMAX | Maximum No. of Offers | NUMBER |
| Temporal | PRO_TR_NO_TOUCH_END_LIFE | No touch period at the end of life | NUMBER (1-52) |
| PRO_TR_NO_TOUCH_AFTER_LANDING | No touch period after landing | NUMBER(1-52) | |
| Pricing Group | MKDN_ALL_NOTHING | Markdown all or nothing | Yes/No |
| MKDN_NONE | No markdown | Yes/No | |
| PROM_ALL_NOTHING |
Promote all or nothing |
Yes/No | |
| PROM_ATMOST_ONE | Promote at most one | Yes/No | |
| SAME_PROMO_MKDN_DISC | Impose same promotion and markdown discount | Yes/No | |
| PRO_SAME_PRICING_TOLERANCE | Percentage difference allowed between two or more product for same Pricing Group |
PERCENTAGE |
|
| SAME_MKDN_DISC | Impose same markdown discount | Yes/No | |
| SAME_PROMO_DISC | Impose same promotion discount | Yes/No | |
| PROM_NONE | No promotion | Yes/No | |
| Markdown | PRO_MAX_ABSOLUTE_MKDN | Absolute maximum discount percentage for markdowns over the entire season | PERCENTAGE |
| PRO_MR_MKDN_START_DAY | Day of the week markdown starts | DAYS OF THE WEEK | |
| PRO_TR_LENGTH_OF_MKDN | Length of markdown as a percentage of the whole season | percentage | |
| PRO_MR_MIN_COST | Markdown recommendations at least equal to the cost of the product | Yes/No | |
| PRO_MR_ABS_MAX_MKDN_DISC_PCT | Maximum absolute markdown discount percentage | PERCENTAGE | |
| PRO_MR_OTHER_MKDN_MAX_DISC_PCT | Maximum discount percentage for markdowns other than the first one | PERCENTAGE | |
| PRO_MR_FIRST_MKDN_MAX_DISC_PCT | Maximum discount percentage for the first markdown | PERCENTAGE | |
| PRO_MR_MAX_NUM_MKDN | Maximum number of markdowns allowed for an item in the life or season | NUMBER | |
| PRO_MR_OTHER_MKDN_MAX_DISC_PCT | Minimum discount percentage for markdowns other than the first one | PERCENTAGE | |
| PRO_MR_FIRST_MKDN_MIN_DISC_PCT | Minimum discount percentage for the first markdown | percentage | |
| PRO_MIN_NUM_OF_MKDN_ITEMS | Minimum number of markdown items | NUMBER | |
| PRO_MR_MIN_TIME_BETWEEN_MKDN | Minimum time separation between any two consecutive markdowns | NUMBER | |
| Promotion | PRO_PR_PROMO_END_DAY | Day of the week promotions ends | DAYS OF THE WEEK |
| PRO_PR_PROMO_START_DAY | Day of the week promotions starts | DAYS OF THE WEEK | |
| PRO_PR_FIRST_PROMO_MAX_DISC_PCT | Default maximum discount percentage for the first promotion | percentage | |
| PRO_PR_FIRST_PROMO_MIN_DISC_PCT | Default minimum discount percentage for the first promotion | PERCENTAGE | |
| PRO_TR_LENGTH_OF_PROMOTIONS | Length of promotion as a percentage of the whole season | PERCENTAGE | |
| PRO_PR_OTHER_PROMO_MAX_DISC_PCT | Maximum discount percentage for promotions other than the first one | PERCENTAGE | |
| PRO_TR_MAX_LENGTH_OF_PROMOTION | Maximum length (weeks) of a promotion | NUMBER | |
| PRO_PR_MAX_NUM_PROMO | Maximum number of promotions allowed for an item in the life or season | NUMBER | |
| PRO_PR_OTHER_PROMO_MIN_DISC_PCT | Minimum discount percentage for promotions other than the first one | PERCENTAGE | |
| PRO_MIN_NUM_OF_PROMO_ITEMS | Minimum number of promotion items | NUMBER | |
| PRO_PR_MIN_TIME_BETWEEN_PROMOS | Minimum time separation between any two consecutive promotions | NUMBER | |
| PRO_PR_MIN_COST | Promotions recommendations cannot be lower than the cost of the product. | Yes/No |