Skip Headers
Oracle® Retail Price Management Oracle® Retail Price Management User Guide
Release 14.1
E54702-01
  Go To Table Of Contents
Contents

Previous
Previous
 
Next
Next
 

5 Pricing Strategies

Maintain Pricing Strategies

Pricing strategies allow you to define how prices are proposed when pricing worksheets are generated. You can define pricing strategies at the department, class, or subclass level to identify the items that are affected by the strategy. The lowest merchandise level you can define for a pricing strategy is determined by the aggregation levels defined for the department. An item/location can be on multiple regular pricing strategies as long as the review periods within the calendar assigned do not overlap (clearance, competitive, or margin) and one maintain margin pricing strategy which can overlap with a (clearance, competitive, or margin) strategy.

After you have created a pricing strategy, you can maintain different aspects of the pricing strategy.


Note:

Updates to pricing strategies affect only future worksheets. Current worksheets will not be updated.

Area Differential Pricing

Area differential pricing allows you to set prices for items at a particular zone or zone group differently than another zone or zone group. The price differential is based on the rules you define. Area differentials can be used when you create a price change to ensure consistent pricing. These price changes are generated by selecting Price Changes for Area Differentials within the Price Change task pad dialog. These price changes are generated by selecting Price Changes for Area Differentials within the Price Change task pad dialog. Differential pricing cannot be applied to other pricing events, such as clearances or promotions.

When creating an area differential:

  • You first establish a primary area, by defining the merchandise hierarchy and zone hierarchy for the primary area.

  • Next, select the zones that fall within the secondary area.

  • Then define how prices for the items in the hierarchy will differ in the secondary areas from the prices in the primary area. You can choose to price the item higher or lower by percent, or set the price to the same as the primary area.

  • You can choose to exclude certain items in the merchandise hierarchy from the secondary area differential prices.

  • You can choose to create and associate a competitive pricing strategy with the secondary area differential.

Area differentials are applied when price changes are created manually in the Price Change Dialog or from the Create Price Changes for Area Differentials dialog. They are also created in the worksheet if there are item/zone combinations brought into the worksheet that are part of the primary area on an area differential strategy. When competitive information is associated with an area differential, the worksheet chooses the lower of the retails proposed by the strategies.

If you set up the secondary area to be auto-approved, secondary area price changes are conflict checked, and if no conflict exists, created in approved status. If conflicts exist, the secondary area price change is created in worksheet status. If you set up the secondary are to not be auto-approved, secondary area price changes are created in worksheet status. See "Change the Status of a Price Change" for additional information about status changes and conflict checking.

Create an Area Differential Pricing Strategy

Navigate: From the Task Pad, select Pricing Strategy > Create Pricing Strategy. The Create Pricing Strategy workspace opens with the Strategy Maintenance pane.

Figure 5-1 Strategy Maintenance Pane


  1. In the Type field, select Area Differential.

  2. Click Next. Additional fields appear.

    Figure 5-2 Strategy Maintenance - Area Differential


  3. Enter the ID of the merchandise level you want to apply the area differential to, or click the LOV button and select the appropriate merchandise level.


    Note:

    You must enter a department. Subsequent merchandise levels are enabled as you add the level above, if the definition of the department in the aggregation level dialog allows it.

  4. Select the zones that define the primary area:

    • Zone Group - Enter the ID of the zone group that contains the locations to add to the area differential price strategy, or click the LOV button and select a zone group.

    • Zone - Enter the ID of the zone to add to the area differential price strategy, or click the LOV button and select a zone.

  5. Click Define Secondary Areas. The Area Differential Strategy Details pane opens.

    Figure 5-3 Area Differential Strategy Details Pane


Define Secondary Areas

  1. Click New to enable the fields.

  2. In the Price Zone field, enter the ID of the zone that you want to add to the secondary area of the area differential price strategy, or click the LOV button and select a zone.

  3. In the Price Guides field, enter the ID of the price guide you want to apply to the differential pricing, or click the LOV button and select a price guide.


    Note:

    Only price guides associated with the selected departments can be selected.

  4. In the Differential field, select how the price differs from the primary area:

    • Price Higher - The items at the specified secondary area are priced higher by the percentage entered in the Percent field.

    • Price Lower - The items at the specified secondary area are priced lower by the percentage entered in the Percent field.

    • Price Equal - The items at the specified secondary area are priced the same as the items in the primary area.

  5. In the Percent field, enter the percent by which the secondary area price is different from the primary area price.

  6. Select the Auto Approve checkbox to indicate price changes for the area differential should be created in Approved status.

Exclude Items From the Area Differential


Note:

Expand the Item Exclusion section of the Area Differentials pane to complete the procedure.

  1. Enter or select criteria ID of the items you want to exclude.

  2. Click Add. The information is added to the item exclusion table.

  3. To remove an item from the item exclusion table:

    1. Select an item.

    2. Click Remove. The item is removed from the item exclusion table.

Complete the Area Differential

  1. Click Apply. Any changes are added to the table.

  2. Click Done to save your changes and close the window.

Edit an Area Differential Pricing Strategy

Navigate: From the Task Pad, select Pricing Strategy > Maintain Pricing Strategy. The Pricing Strategy Search workspace opens.

Figure 5-4 Pricing Strategy Search Workspace


  1. Enter criteria as needed to limit your search.

  2. Click Search. The results of your search are listed in the Pricing Strategies List.

    Figure 5-5 Pricing Strategies List Window


  3. From the Pricing Strategies List, select the area differential strategy you want to maintain.

  4. Click Edit, or double-click the strategy selected. A Strategy Maintenance editing pane opens, and the fields that can be changed are enabled.

    Figure 5-6 Strategy Maintenance Edit - Area Differential


  5. If you selected an area differential strategy, select the location you want to update.

Remove a Zone From an Area Differential Strategy

  1. Select the zone you want to delete.

  2. Click Delete. The zone is removed from the table.

Exclude Items From the Area Differential


Note:

Expand the Item Exclusion section of the Area Differentials pane to complete the procedure.

  1. Enter or select criteria ID of the items you want to exclude.

  2. Click Add. The information is added to the item exclusion table.

  3. To remove an item from the item exclusion table:

    1. Select an item.

    2. Click Remove. The item is removed from the item exclusion table.

Complete the Area Differential

  1. Click Apply. Any changes are added to the table.

  2. Click Done to save your changes and close the window.

Clearance Pricing

A clearance pricing strategy allows you to define the method used to mark down items.

Create a Clearance Pricing Strategy

Navigate: From the Task Pad, select Price Strategy > Create Price Strategy. The Create Pricing Strategy workspace opens with the Strategy Maintenance pane.

Figure 5-7 Strategy Maintenance Pane


  1. In the Type field, select Clearance.

  2. Click Next. Additional fields appear.

    Figure 5-8 Strategy Maintenance Details


  3. Enter the ID of the merchandise level you want to apply the strategy to, or click the LOV button and select the appropriate merchandise level.


    Note:

    You must enter a department. Subsequent merchandise levels are enabled as you add the level above, if the definition of the department in the aggregation level dialog allows it.

  4. Select the zones for the strategy:

    • Zone Group - Enter the ID of the zone group that contains the locations to add to the price strategy, or click the LOV button and select a zone group.

    • Zone - Enter the ID of the zone to add to the price strategy, or click the LOV button and select a zone.

  5. In the Price Guides field, enter the ID of the Price Guide field, or click the LOV button and select a price guide.


    Note:

    Only price guides associated with the selected departments can be selected.

  6. In the Calendar field, enter the ID of the calendar you want to associate with the strategy, or click the LOV button and select a calendar.

  7. In the Suspend field, select the checkbox to indicate that reviews of the existing strategy are stopped.


    Note:

    Clear the checkbox to indicate the review periods should begin with the next review period.

  8. In the New Calendar field, enter the ID of the calendar you want to associate with the strategy, or click the LOV button and select a calendar.


    Note:

    You must select the Suspend checkbox before you can add a new calendar

  9. Click Define Strategy Details. The Clearance Strategy Details pane opens.

Define Clearance Strategy Details

  1. In the Markdown Percent field, select the price from which the clearance price is calculated.

  2. Click Add Row.

  3. In the Discount Percent field, enter the percent of the markdown.

  4. Click Apply.


    Note:

    If the price from which the clearance price is calculated is Regular Retail, the Discount Percent fields must increase with each markdown added.

Edit a Clearance Pricing Strategy

Navigate: From the Task Pad, select Price Strategy > Maintain Price Strategy. The Pricing Strategy Search workspace opens.

Figure 5-9 Pricing Strategy Search Workspace


  1. Enter criteria as needed to limit your search.

  2. Click Search. The results of your search are listed in the Pricing Strategy Search List window.

    Figure 5-10 Pricing Strategy List Window


  3. From the Pricing Strategies List, select the clearance strategy you want to maintain.

  4. Click Edit, or double-click the strategy selected. A second Strategy Maintenance pane opens and the fields that can be changed are enabled.

    Figure 5-11 Strategy Maintenance - Edit Clearance


  5. Make necessary changes.

  6. Click Apply.

Edit a Price Guide

Change or enter a price guide name, or click the LOV button and select the appropriate price guide if necessary.

Change Calendars


Note:

Before you can specify a new calendar, the existing calendar must be suspended.

  1. Select the Suspend checkbox.

  2. Enter a calendar name, or click the LOV button and select a calendar.

Edit a Markdown

  1. Select the Markdown number from the Clearance Strategies table.

  2. Click Edit. The Discount Percent field is enabled.

  3. Edit the discount percent.

  4. Click Apply.

Delete a Markdown

  1. Select the highest Markdown number from the Clearance Strategies table.

  2. Click Remove Markdown.

  3. Click Apply.

Clearance Defaults Pricing

A clearance defaults pricing strategy allows you to set up a strategy for generating subsequent markdowns after an initial clearance event.

Create a Clearance Defaults Pricing Strategy

Navigate: From the Task Pad, select Price Strategy > Create Price Strategy. The Create Pricing Strategy workspace opens with the Strategy Maintenance pane.

Figure 5-12 Strategy Maintenance Pane


  1. In the Type field, select Clearance Defaults.

  2. Click Next. Additional Strategy fields appear.

    Figure 5-13 Strategy Maintenance - Clearance Defaults


  3. Enter the ID of the merchandise level you want to apply the strategy to, or click the LOV button and select the appropriate merchandise level.


    Note:

    You must enter a department. Subsequent merchandise levels are enabled as you add the level above, if the definition of the department in the aggregation level dialog allows it.

  4. Click Define Strategy Details. The Clearance Defaults Strategy Details pane opens.

    Figure 5-14 Clearance Defaults Strategy Details Window


Define Clearance Strategy Details
  1. Enter the percent of the first markdown after the initial markdown in the Discount Percent field.

  2. Enter how many days after the first markdown that this markdown should be taken in the Days after First field.

  3. Enter when to reset the price to regular price in the Reset Price this many days after out of stock date field.

  4. Click Apply. A row is added to the table.

Add Subsequent Markdowns
  1. Click Add Row.

  2. Enter a percent in the Discount Percent field.


    Note:

    Subsequent markdown percents must be greater than the previous.

  3. Enter a number of days in the Days after First field.

  4. Click Apply. The markdown is added to the table.

Edit a Clearance Defaults Price Strategy

Navigate: From the Task Pad, select Price Strategy > Maintain Price Strategy. The Pricing Strategy Search workspace opens.

Figure 5-15 Pricing Strategy Search Window


  1. Enter criteria as needed to limit your search.

  2. Click Search. The results of your search are listed in the Pricing Strategies List.

    Figure 5-16 Pricing Strategies List Window


  3. From the Pricing Strategies List, select the clearance defaults strategy you want to maintain.

  4. Click Edit, or double-click the strategy selected. A Strategy Maintenance pane opens and the fields that can be changed are enabled.

    Figure 5-17 Strategy Maintenance Clearance Defaults Window


  5. Make necessary changes.

Add Subsequent Markdowns
  1. Select the row before which you want to add the markdown.

  2. Click Add Row.

  3. Enter a percent in the Discount Percent field.


    Note:

    Subsequent markdown percents must be greater than the previous.

  4. Enter a number of days in the Days after First field.

  5. Click Apply. The markdown is added to the table.

Edit a Markdown
  1. Select the Markdown number from the Clearance Strategies table.

  2. Click Edit. The Discount Percent and Days after First fields are enabled.

  3. Edit the discount percent and days after first values.

  4. Click Apply.

Delete a Markdown
  1. Select the highest Markdown number from the Clearance Strategies table.

  2. Click Remove Markdown.

  3. Click Apply.

Competitive Pricing

A competitive pricing strategy allows you to define your pricing strategy for items based on your primary competitor's prices.

Note that all locations in a competitive pricing strategy must use the same currency.

You can also assign reference competitors to a competitive pricing strategy. This information allows you to compare the proposed prices to the prices available from other retailers. If the proposed prices vary from the target percentages defined for the reference competitors, you are prompted by the system, so that you can adjust the price in the pricing worksheet.

Create a Competitive Pricing Strategy

Navigate: From the Task Pad, select Price Strategy > Create Price Strategy. The Create Pricing Strategy workspace opens with the Strategy Maintenance pane.

Figure 5-18 Strategy Maintenance Pane


  1. In the Type field, select Competitive.

  2. Click Next. Additional strategy fields appear.

    Figure 5-19 Strategy Maintenance - Competitive


  3. Enter the ID of the merchandise level you want to apply the strategy to, or click the LOV button and select the appropriate merchandise level.


    Note:

    You must enter a department. Subsequent merchandise levels are enabled as you add the level above, if the definition of the department in the aggregation level dialog allows it.

  4. Select the zones for the strategy:

    • Zone Group - Enter the ID of the zone group that contains the locations to add to the price strategy, or click the LOV button and select a zone group.

    • Zone - Enter the ID of the zone to add to the price strategy, or click the LOV button and select a zone.

  5. In the Price Guides field, enter the ID of the Price Guide field, or click the LOV button and select a price guide.


    Note:

    Only price guides associated with the selected departments can be selected.

  6. In the Calendar field, enter the ID of the calendar you want to associate with the strategy, or click the LOV button and select a calendar.

  7. In the Suspend field, select the checkbox to indicate that reviews of the existing strategy are stopped.


    Note:

    Clear the checkbox to indicate the review periods should begin with the next review period.

  8. In the New Calendar field, enter the ID of the new calendar you want to associate with the strategy, or click the LOV button and select a calendar.


    Note:

    You must select the Suspend checkbox before you can add a new calendar.

  9. Click Define Strategy Details. The Competitive Strategy Details pane opens.

    Figure 5-20 Competitive Strategy Details Window


Define Competitive Strategy Details

  1. In the Competitor field, enter the ID of the primary competitor or click the LOV button and select a competitor.

  2. In the Competitor Store field, enter the ID of the store that proposed retails are being compared against.


    Note:

    The currency at the competitor store must be the same as the zones previously selected.

  3. In the Compete Type, select how the price strategy determines the prices:

    • Match - Prices are proposed to be the same as the primary competitor's prices.

    • Price Above - Prices are proposed to be a percentage above the primary competitor's prices.

    • Price Below - Prices are proposed to be a percentage below the primary competitor's prices.

    • Price by Code - Prices are proposed by the market basket code for the merchandise hierarchy/zone.

Define Match Strategy Details

  1. Define reference competitors as necessary.

  2. Click Done to save any changes and close the workspace.

Define Price Above or Price Below Strategy Details

  1. In the Compete Percent field, enter the percent above or below the primary competitor's price that the new price is set at.

  2. Set up the acceptable range:


    Note:

    Acceptable range is the amount by percentage that a retail price can vary from a primary competitor before a price change is proposed.

    1. In the Acceptable Range From field, enter the bottom of the range.

    2. In the Acceptable Range To field, enter the top of the range.

  3. Define reference competitors as necessary.

  4. Click Done to save any changes and close the workspace.

Define Price by Code Strategy Details

  1. In the Code field, select the competitive market basket code you want to use to set the price.

  2. In the Compete Type, select how the price strategy determines the prices:

    • Match - Prices are proposed to be the same as the primary competitor's prices.

    • Price Above - Prices are proposed to be a percentage above the primary competitor's prices.

    • Price Below - Prices are proposed to be a percentage below the primary competitor's prices.

  3. In the Compete Percent field, enter the percent above or below the primary competitor's price that the new price is set at.

  4. Set up the acceptable range:


    Note:

    Acceptable range is the amount by percentage that a retail price can vary from a primary competitor before a price change is proposed.

    1. In the Acceptable Range From field, enter the bottom of the range.

    2. In the Acceptable Range To field, enter the top of the range.

  5. Define reference competitors as necessary.

  6. Click Done to save any changes and close the workspace.

Define Reference Competitors

  1. In the Reference Competitors section, enter the ID of the competitor in the Competitor field, or click the LOV button and select a competitor.

  2. In the Competitor Store field, enter the ID of the store, or click the LOV button and select a store.

  3. In the Compete Type, select how to compare prices to the reference competitors:

    • Match - A pass or fail indicator appears on the worksheet depending on if the proposed price matches the referenced competitors price.

    • Price Above - A pass or fail indicator appears on the worksheet depending on if the proposed price is at least the specified percent above the referenced competitor's price.

    • Price Below - A pass or fail indicator appears on the worksheet depending on if the proposed price is at least the specified percent below the referenced competitor's price.

  4. If you selected Price Above or Price Below, enter the percent above or below the competitor's price that the new price is compared.

  5. Click Done to save any changes and close the workspace.

Create a Competitive Pricing Strategy Associated with an Area Differential


Note:

Expand the Competitor section of the Area Differentials pane to complete the procedure.

  1. In the Competitor field, enter the ID of the competitor or click the LOV button and select a competitor.

  2. In the Competitor Store field, enter the ID of the store that proposed retails are being compared against or click the LOV button and select a store.


    Note:

    The currency at the competitor store must be the same as the zones previously selected.

  3. In the Compete Type, select how the price strategy determines the prices:

    • Match - Prices are proposed to be the same as the competitor's prices.

    • Price Above - Prices are proposed to be a percentage above the competitor's prices.

    • Price Below - Prices are proposed to be a percentage below the competitor's prices.

    • Price by Code - Prices are proposed by the market basket code for the merchandise hierarchy/zone.

Define Match Strategy Details

  1. Define reference competitors as necessary.

  2. Click Done to save any changes and close the workspace.

Define Price Above or Price Below Strategy Details

  1. In the Compete Percent field, enter the percent above or below the competitor's price that the new price is set at.

  2. Set up the acceptable range:


    Note:

    Acceptable range is the amount by percentage that a retail price can vary from a competitor before a price change is proposed.

    1. In the Acceptable Range From field, enter the bottom of the range.

    2. In the Acceptable Range To field, enter the top of the range.

  3. Define reference competitors as necessary.

  4. Click Done to save any changes and close the workspace.

Define Price by Code Strategy Details

  1. In the Code field, select the competitive market basket code you want to use to set the price.

  2. In the Compete Type, select how the price strategy determines the prices:

    • Match - Prices are proposed to be the same as the competitor's prices.

    • Price Above - Prices are proposed to be a percentage above the competitor's prices.

    • Price Below - Prices are proposed to be a percentage below the competitor's prices.

  3. In the Compete Percent field, enter the percent above or below the competitor's price that the new price is set at.

  4. Set up the acceptable range:


    Note:

    Acceptable range is the amount by percentage that a retail price can vary from a competitor before a price change is proposed.

    1. In the Acceptable Range From field, enter the bottom of the range.

    2. In the Acceptable Range To field, enter the top of the range.

  5. Define reference competitors as necessary.

  6. Click Done to save any changes and close the workspace.

Define Reference Competitors


Note:

Expand the Reference Competitor section of the Area Differentials pane to complete the procedure.

  1. In the Reference Competitors section, enter the ID of the competitor in the Competitor field, or click the LOV button and select a competitor.

  2. In the Competitor Store field, enter the ID of the store, or click the LOV button and select a store.

  3. In the Compete Type, select how to compare prices to the reference competitors:

    • Match - A pass or fail indicator appears on the worksheet depending on if the proposed price matches the referenced competitors price.

    • Price Above - A pass or fail indicator appears on the worksheet depending on if the proposed price is at least the specified percent above the referenced competitor's price.

    • Price Below - A pass or fail indicator appears on the worksheet depending on if the proposed price is at least the specified percent below the referenced competitor's price.

  4. If you selected Price Above or Price Below, enter the percent above or below the competitor's price that the new price is compared.

  5. Click Done to save any changes and close the workspace.

Edit a Competitive Pricing Strategy

Navigate: From the Task Pad, select Price Strategy > Maintain Price Strategy. The Pricing Strategy Search workspace opens.

Figure 5-21 Pricing Strategy Search Workspace


  1. Enter criteria as needed to limit your search.

  2. Click Search. The results of your search are listed in the Pricing Strategies List.

    Figure 5-22 Pricing Strategies List Window


  3. From the Pricing Strategies List, select the competitive strategy you want to maintain.

  4. Click Edit, or double-click the strategy selected. A second Strategy Maintenance pane opens and the fields that can be changed are enabled.

    Figure 5-23 Strategy Maintenance Competitive Window


  5. Make necessary changes.

Edit a Price Guide

To edit a price guide:

  • Enter the price guide name, or click the LOV button and select the appropriate price guide.

Change Calendars


Note:

In order to specify a new calendar, the existing calendar must be suspended.

  1. Select the Suspend checkbox.

  2. Enter a calendar name, or click the LOV button and select a calendar.

Edit a Competitor

  1. In the Competitor field, enter or change the competitor ID, or click the LOV button and select the appropriate competitor.

  2. In the Competitor Store field, enter a competitor store ID, or click the LOV button and select the appropriate store.

  3. In the Compete Type drop-down field, select the compete type.

  4. For Price Above and Price Below compete types, set up the acceptable range:


    Note:

    Acceptable range is the amount by percentage that a retail price can vary from a competitor before a price change is proposed.

    1. In the Acceptable Range From field, enter the bottom of the range.

    2. In the Acceptable Range To field, enter the top of the range.

Edit Reference Competitors

Define reference competitors as necessary.

Complete the Competitive Price Strategy

  1. Click Save + Repeat to commit your changes.

  2. Click Done to save any changes and close the workspace.

Margin Pricing

A margin pricing strategy allows you to define the pricing strategy for items based on margin targets.

Create a Margin Pricing Strategy

Navigate: From the Task Pad, select Price Strategy > Create Price Strategy. The Create Pricing Strategy workspace opens with the Strategy Maintenance pane.

Figure 5-24 Strategy Maintenance Pane


  1. In the Type field, select Margin.

  2. Click Next. Additional strategy fields appear.

    Figure 5-25 Strategy Maintenance Margin


  3. Enter the ID of the merchandise level you want to apply the strategy to, or click the LOV button and select the appropriate merchandise level.


    Note:

    You must enter a department. Subsequent merchandise levels are enabled as you add the level above, if the definition of the department in the aggregation level dialog allows it.

  4. Select the zones for the strategy:

    • Zone Group - Enter the ID of the zone group that contains the locations to add to the price strategy, or click the LOV button and select a zone group.

    • Zone - Enter the ID of the zone to add to the price strategy, or click the LOV button and select a zone.

  5. In the Price Guides field, enter the ID of the Price Guide field, or click the LOV button and select a price guide.


    Note:

    Only price guides associated with the selected departments can be selected.

  6. In the Calendar field, enter the ID of the calendar you want to associate with the strategy, or click the LOV button and select a calendar.

  7. In the Suspend field, select the checkbox to indicate that reviews of the existing strategy are stopped.


    Note:

    Clear the checkbox to indicate the review periods should begin in the next period.

  8. In the New Calendar field, enter the ID of the calendar you want to associate with the strategy, or click the LOV button and select a calendar.


    Note:

    You must select the Suspend checkbox before you can add a new calendar.

  9. Click Define Strategy Details. The Margin Strategy Details pane opens.

    Figure 5-26 Margin Strategy Details


Define Margin Strategy Details

  1. In the Code field, select the margin market basket code you want to use to set the price.

  2. In the Margin Target field, enter the percent of margin you want to earn on the item/zone.

  3. Set up the acceptable range:


    Note:

    Acceptable range is the amount by percentage that a margin can vary from the target before a price change is proposed.

    1. In the Acceptable Range From field, enter the bottom of the range.

    2. In the Acceptable Range To field, enter the top of the range.

  4. Click Apply. An entry is added to the Margin Strategy Details table.

  5. Define reference competitors as necessary.

  6. Click Done to save any changes and close the workspace.

Edit a Margin Pricing Strategy

Navigate: From the Task Pad, select Price Strategy > Maintain Price Strategy. The Pricing Strategy Search workspace opens.

Figure 5-27 Pricing Strategy Search Window


  1. Enter criteria as needed to limit your search.

  2. Click Search. The results of your search are listed in the Pricing Strategies List.

    Figure 5-28 Pricing Strategies List Window


  3. From the Pricing Strategies List, select the margin strategy you want to maintain.

  4. Click Edit, or double-click the strategy selected. A Strategy Maintenance pane opens and the fields that can be changed are enabled.

    Figure 5-29 Strategy Maintenance Margin Window


  5. Make necessary changes.

Edit a Price Guide

To edit a price guide:

  • Enter the price guide name, or click the LOV button and select the appropriate price guide.

Change Calendars


Note:

Before you can specify a new calendar, the existing calendar must be suspended.

  1. Select the Suspend checkbox.

  2. Enter a calendar name, or click the LOV button and select a calendar.

Edit Margin Details

  1. Select a row in the Margin Strategy Details table.

  2. In the Margin Target field, enter the percent of margin you want to earn on the item/zone.


    Note:

    Acceptable range is the amount by percentage that a margin can vary from the target before a price change is proposed.

  3. In the Acceptable Range From field, enter the bottom of the range.

  4. In the Acceptable Range To field, enter the bottom of the range.

  5. Click Apply.

Delete Margin Details

  1. Select the margin detail from the Margin Strategy Details table.

  2. Click Delete. The row is removed from the table.

Edit Reference Competitors

Define reference competitors as necessary.

Complete the Margin Price Strategy

  1. Click Save + Repeat to commit your changes.

  2. Click Done to save any changes and close the workspace.

Maintain Margin Pricing

The maintain margin pricing strategy allows you to define the pricing strategy for items based on future cost changes. The proposed retails can be based on current or market basket margin percentages. Reference competitors may be assigned for comparison purposes.

Create a Maintain Margin Pricing Strategy

Navigate: From the Task Pad, select Price Strategy > Create Price Strategy. The Create Pricing Strategy workspace opens with the Strategy Maintenance pane.

Figure 5-30 Strategy Maintenance Pane


  1. In the Type field, select Maintain Margin.

  2. Click Next. Additional strategy fields appear.

  3. Enter the ID of the merchandise level you want to apply the strategy to, or click the LOV button and select the appropriate merchandise level.


    Note:

    You must enter a department. Subsequent merchandise levels are enabled as you add the level above, if the definition of the department in the aggregation level dialog allows it.

  4. Select the zones for the strategy:

    • Zone Group - Enter the ID of the zone group that contains the locations to add to the price strategy, or click the LOV button and select a zone group.

    • Zone - Enter the ID of the zone to add to the price strategy, or click the LOV button and select a zone.

  5. In the Price Guides field, enter the ID of the Price Guide field, or click the LOV button and select a price guide.


    Note:

    Only price guides associated with the selected departments can be selected.

  6. In the Calendar field, enter the ID of the calendar you want to associate with the strategy, or click the LOV button and select a calendar.

  7. In the Suspend field, select the checkbox to indicate that reviews of the existing strategy are stopped.


    Note:

    Clear the checkbox to indicate the review periods should begin in the next period.

  8. In the New Calendar field, enter the ID of the calendar you want to associate with the strategy, or click the LOV button and select a calendar.


    Note:

    You must select the Suspend checkbox before you can add a new calendar.

  9. Click Define Strategy Details. The Maintain Margin Strategy Details pane opens.

    Figure 5-31 Maintain Margin Strategy Details Window


Define Maintain Margin Strategy Details

  1. Select the Auto Approve checkbox to indicate price changes should be created in Approved status.

  2. In the Cost Change Forward Days, enter the number of days into the next review period that the strategy will consider cost changes when proposing price changes.


    Note:

    Cost Change Forward Days should not exceed the length of a review period.

  3. Select the method for the strategy:

    • Market Basket Margin - Select to have the margin for the item's market basket applied to the item's new cost. A new Margin Strategy Details area appears.

      Figure 5-32 Margin Strategy Details Window


    • Current Margin - Select to have the current margin applied to the item's new cost. The current margin fields are enabled.

Define Market Basket Margin

  1. In the Code drop-down field, select the margin market basket code you want to use to set the price.

  2. In the Margin Target field, enter the percent of margin you want to earn on the item/zone.

  3. Set up the acceptable range:


    Note:

    Acceptable range is the amount by percentage that a margin can vary from the target before a price change is proposed.

    1. In the Acceptable Range From field, enter the bottom of the range.

    2. In the Acceptable Range To field, enter the top of the range.

  4. Click Apply. An entry is added to the Maintain Strategy Details table.

  5. Define reference competitors as necessary.

  6. Click Done to save any changes and close the workspace.

Define Current Margin

  1. Select how the strategy will apply an increase in margin to a proposed retail:

    • Margin % - Select to have the percent of the cost change added to the basis retail to determine the proposed retail.

    • Change by Cost Change Amount - Select to have the amount of the cost change added to the basis retail.

  2. Select how the strategy will apply a decrease in margin to a proposed retail:

    • Margin % - Select to have the percent of the cost change subtracted from the basis retail to determine the proposed retail.

    • Change by Cost Change Amount - Select to have the amount of the cost change subtracted from the basis retail.

  3. Click Done to save any changes and close the workspace.

Define Reference Competitors

  1. In the Reference Competitors section, enter the ID of the competitor in the Competitor field, or click the LOV button and select a competitor.

  2. In the Competitor Store field, enter the ID of the store, or click the LOV button and select a store.

  3. In the Compete Type, select how to compare prices to the reference competitors:

    • Match - A pass or fail indicator appears on the worksheet depending on if the proposed price matches the referenced competitors price.

    • Price Above - A pass or fail indicator appears on the worksheet depending on if the proposed price is at least the specified percent above the referenced competitor's price.

    • Price Below - A pass or fail indicator appears on the worksheet depending on if the proposed price is at least the specified percent below the referenced competitor's price.

  4. If you selected Price Above or Price Below, enter the percent above or below the competitor's price that the new price is compared.

  5. Click Done to save any changes and close the workspace.

Edit a Maintain Margin Pricing Strategy

Navigate: From the Task Pad, select Price Strategy > Maintain Price Strategy. The Pricing Strategy Search workspace opens.

Figure 5-33 Pricing Strategy Search Window


  1. Enter criteria as needed to limit your search.

  2. Click Search. The results of your search are listed in the Pricing Strategies List.

    Figure 5-34 Pricing strategies List Window


  3. From the Pricing Strategies List, select the maintain margin strategy you want to maintain.

  4. Click Edit, or double-click the strategy selected. Another Strategy Maintenance pane opens and the fields that can be changed are enabled.

    Figure 5-35 Strategy Maintenance Maintain Margin


  5. Make necessary changes.

Edit a Price Guide

To edit a price guide:

  • Enter the price guide name, or click the LOV button and select the appropriate price guide.

Change Calendars


Note:

Before you can specify a new calendar, the existing calendar must be suspended.

  1. Select the Suspend checkbox.

  2. Enter a calendar name, or click the LOV button and select a calendar.

Edit Maintain Margin Details

  1. Select the Auto Approve checkbox to indicate price changes should be created in Approved status.

  2. In the Cost Change Forward Days, enter the number of days into the next review period that the strategy will consider cost changes when proposing price changes.


    Note:

    Cost Change Forward Days should not exceed the length of a review period.

  3. Select the method for the strategy:

    • Market Basket Margin - Select to have the margin for the item's market basket applied to the item's new cost. A new Margin Strategy Details area appears.

      Figure 5-36 Margin Strategy Details Window


    • Current Margin - Select to have the current margin applied to the item's new cost.

Edit Market Basket Margin

  1. In the Code drop-down field, select the margin market basket code you want to use to set the price.

  2. In the Margin Target field, enter the percent of margin you want to earn on the item/zone.

  3. Set up the acceptable range:


    Note:

    Acceptable range is the amount by percentage that a margin can vary from the target before a price change is proposed.

    1. In the Acceptable Range From field, enter the bottom of the range.

    2. In the Acceptable Range To field, enter the top of the range.

  4. Click Apply. An entry is added to the Maintain Strategy Details table.

  5. Define reference competitors as necessary.

  6. Click Done to save any changes and close the workspace.

Edit Current Margin

  1. Select how the strategy will apply an increase in margin to a proposed retail:

    • Margin % - Select to have the percent of the cost change added to the basis retail to determine the proposed retail.

    • Change by Cost Change Amount - Select to have the amount of the cost change added to the basis retail.

  2. Select how the strategy will apply a decrease in margin to a proposed retail:

    • Margin % - Select to have the percent of the cost change subtracted from the basis retail to determine the proposed retail.

    • Change by Cost Change Amount - Select to have the amount of the cost change subtracted from the basis retail.

  3. Click Done to save any changes and close the workspace.

Edit Reference Competitors

Define reference competitors as necessary.

Complete the Margin Price Strategy

  1. Click Save + Repeat to commit your changes.

  2. Click Done to save any changes and close the workspace.

Delete a Pricing Strategy

Navigate: From the Task Pad, select Pricing Strategy > Maintain Pricing Strategy. The Pricing Strategy Search workspace opens.

Figure 5-37 Pricing Strategy Search Window


  1. Enter criteria as needed to limit your search.

  2. Click Search. The search results are listed in the Pricing Strategies List.

    Figure 5-38 Pricing Strategies List Window


  3. From the list, select the price strategy you want to delete.

  4. Click Delete. You are prompted to confirm your decision.

  5. Click Yes.

  6. Click Done to close the window.