Country List Update template

Objective

Use the recommendations in this template to update country factors, including product discounts and overrides, and review the impact to the country price list.

Example flow

Edit data

1. Open the Manage Country Prices scenario workbook.
   When you created the scenario, this workbook was loaded with data from base and decision support workbooks.
2. Open the Country Price Updates worksheet.
3. In the Discount Override, Price Override, or Margin Override columns, enter values or upsert data from a CSV file. (If the columns aren't visible, select > to expand the Adjustments column.)

This calculates the Proposed Price or Proposed Discount values, as applicable.

4. In the Proposed Start Date column, update the date. (If the column isn't visible, select > to expand the Publish Info column.)

The following information shows how other columns, column groups, and KPI cards in this worksheet are calculated. Use this information for additional decision support.

Price at Margin Override

CASE 
    WHEN 1 - COALESCE ({Margin Override}, 0) = 0 THEN NULL 
    ELSE {Country Cost} / (1 - {Margin Override}) 
END

Proposed Price

COALESCE ({Price at Margin Override}, {Override}, {Discounted Price}, {Country Price})

Price Change

CASE 
    WHEN COALESCE ({Country Price}, 0) = 0 THEN NULL 
    ELSE ({Proposed Price} - {Country Price}) / {Country Price} 
END

New Discount

CASE 
    WHEN COALESCE ({Country List}, 0) = 0 THEN NULL 
    ELSE 1 - ({Proposed Price} / {Country List}) 
END

Discounted Price

{Country List} * (1 - COALESCE ({Discount Override}, {Current Discount}))

New Margin

CASE 
    WHEN COALESCE ({Proposed Price}, 0) = 0 THEN NULL 
    ELSE ({Proposed Price} - {Country Cost}) / {Proposed Price} 
END

5. In the Proposed Discounts and Price Overrides worksheets, review a summary of discounts and overrides. By default, these worksheets are filtered to show only records with values.

   Update data in these worksheets as needed.

Publish data

1. In the Country Price Updates worksheet, select the Publish checkbox for records that represent updated and final data. These records will be published back to the base and master data workbooks.
2. From the Actions menu, select Publish.

The selected records are synchronized with the Country Discounts and Country Overrides waterfall element workbooks.