Product relationships
When reviewing an pricing scenario’s results, you can easily access the Relationships panel of the Product Analyzer to research a selected product.
For example, you may be interested in the product’s attributes, cost data, competitor data, or other items in the same Brand or Size Family. Select and right-click on a product in the Scenario Results, Scenario Price Approval, and Production Price Approval pages of the Price application (at the SKU levels) to open the Relationships panel directly.
The left-side of the panel lists the product attributes, such as the category, UPC, Demand Group, brand name, new and current prices, and cost.
Expand the following panels to see detailed information. In these panels, you can rearrange columns by dragging and dropping the column heading to a new position.
*
Product Group - Shows all the product groups (both static and dynamic) that are used in the scenario and contain the currently selected product.
*
Competitive Information - Lists the competitor names, latest competitive prices, current to competitive price differences, and effective dates.
*
Line Members, Brand Family Members, Size Family Members, Other1/Other2 Family & Class - Shows all the products that belong to that family or line, unit price (volume-weighted average of the new price at the SKU/Store level), and the equivalent price calculated as unit price divided by size at the SKU/Store level.
*
Product or Line Relationship Information - If the Product or Line Relationship rule was defined with the currently selected product, the Relationship Driver column will show the driver product for each driven product or line group in the report, the Relationship Value column will show the coefficient between the driver and the driven product/line group, and the Relationship Type column will indicate if the coefficient is a multiplier or relative value. The Product or Line Relationship rule sets the price �of the second product or line group in a pair based on a multiplier or relative value applied to the last optimized price of the first product or line group (the “driver”), as shown in these equations:
Price of UPC(2) = Price of UPC(1) x Multiplier Value
Price of UPC(2) = Price of UPC(1) + Relative Value
Prices in Line(2) = Prices in Line(1) x Multiplier Value
Prices in Line(2) = Prices in Line(1) + Relative Value
*