Pricing Reference Points
The following is a list of the pricing reference groups available for use in pricing policies. Click a pricing reference group for a list of pricing reference points within the group.
• Current Costs
• Current Margin
• Current Prices
• Direct Pricing
• Dynamic Price Buckets
• Dynamic Targets
• Eff Current Costs
• Eff Current Margin
• Eff Current Prices
• Eff Part Chain Relationship
• Eff Part Kit
• Maintain Current Margin
• Max Profit Price
• New Margin
• Part Chain Relationships
• Part Group Relationships
• Part Kit Relationships
• Price Adjustment Factors
• Ref Loc Current Costs
• Ref Loc Current Margins
• Ref Loc Current Prices
• Ref Loc Eff Current Costs
• Ref Loc Eff Current Margins
• Ref Loc Eff Current Prices
• Ref Loc New Rec Margins
• Ref Loc New Rec Prices
Current Costs
For pricing:
The formula for Current Costs reference points is:
IPCS_COST.X value for the current cost record
where X = reference point cost.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Current Cost
|
IPCS_COST record based on PP.CostDate.
|
Price Alignment
|
|
Custom Cost (1-5)
|
IPCS_COST.customcost[1-5] value for the current cost record.
|
Price Alignment
|
|
Damaged Cost
|
IPCS_COST.damagedcost value for the current cost record.
|
Price Alignment
|
|
Expedite Cost
|
IPCS_COST.expeditecost value for the current cost record.
|
Price Alignment
|
|
Refurbished Cost
|
IPCS_COST.refurbishedcost value for the current cost record.
|
Price Alignment
|
|
Supplier Cost
|
IPCS_COST.suppliercost value for the current cost record.
|
Price Alignment
|
|
Volume Cost
|
IPCS_COST.volumecost value for the current cost record.
|
Price Alignment
|
Current Margin
For pricing:
Current Margin uses the IPCS_COST record based on PP.CostDate and the IPCS_PRICE record based on PP.PriceDate.
The formula for Current Margin reference points is:
X / (1 - [(( (Selected Price - X ) / Selected Price) + Adjustment)])
where X = reference point cost.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Current Margin using Custom Cost 1
|
Custom Cost 1 / (1 - [(( (Selected Price - Custom Cost 1) / Selected Price) + Adjustment)])
|
Margin Plus
|
|
Current Margin using Custom Cost 2
|
Custom Cost 2 / (1 - [(( (Selected Price - Custom Cost 2) / Selected Price) + Adjustment)])
|
Margin Plus
|
|
Current Margin using Custom Cost 3
|
Custom Cost 3 / (1 - [(( (Selected Price - Custom Cost 3) / Selected Price) + Adjustment)])
|
Margin Plus
|
|
Current Margin using Custom Cost 4
|
Custom Cost 4 / (1 - [(( (Selected Price - Custom Cost 4) / Selected Price) + Adjustment)])
|
Margin Plus
|
|
Current Margin using Custom Cost 5
|
Custom Cost 5 / (1 - [(( (Selected Price - Custom Cost 5) / Selected Price) + Adjustment)])
|
Margin Plus
|
|
Current Margin using Damaged Cost
|
Damaged Cost / (1 - [(( (Selected Price - Damaged Cost) / Selected Price) + Adjustment)])
|
Margin Plus
|
|
Current Margin using Expedite Cost
|
Expedite Cost / (1 - [(( (Selected Price - Expedite Cost) / Selected Price) + Adjustment)])
|
Margin Plus
|
|
Current Margin using Refurbished Cost
|
Refurbished Cost / (1 - [(( (Selected Price - Refurbished Cost) / Selected Price) + Adjustment)])
|
Margin Plus
|
|
Current Margin using Supplier Cost
|
Supplier Cost / (1 - [(( (Selected Price - Supplier Cost) / Selected Price) + Adjustment)])
|
Margin Plus
|
|
Current Margin using Standard Cost
|
Standard Cost / (1 - [(( (Selected Price - Standard Cost) / Selected Price) + Adjustment)])
|
Margin Plus
|
|
Current Margin using Volume Cost
|
Volume Cost / (1 - [(( (Selected Price - Volume Cost) / Selected Price) + Adjustment)])
|
Margin Plus
|
Current Prices
For pricing:
The formula for Current Prices reference points is:
IPCS_PRICE.X value for the current price record
where X = reference point price.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Current Price
|
IPCS_PRICE record based on PP.PriceDate
|
Price Alignment
|
|
Custom Price (1-20)
|
IPCS_PRICE.customprice[1-20] value for the current price record.
|
Price Alignment
|
|
Damaged Price
|
IPCS_PRICE.damagedprice value for the current price record.
|
Price Alignment
|
|
Expedite Price
|
IPCS_PRICE.expediteprice value for the current price record.
|
Price Alignment
|
|
Refurbished Price
|
IPCS_PRICE.refurbishedprice value for the current price record.
|
Price Alignment
|
|
Volume Price
|
IPCS_PRICE.volumeprice value for the current price record.
|
Price Alignment
|
Direct Pricing
Direct Pricing reference points use an input value where the user enters an exact price to be used as a reference point.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Direct Pricing
|
User input value. Enter an exact price to be used as a reference point. For example, if the user selects Direct Pricing
and enters
10
in the
Adjustment
field, $10 will be used as the reference point during the simulation process calculations for new prices (assuming US dollar is the currency being used).
|
Price Plus
|
Dynamic Price Buckets
 |
This category is only available for pricing threshold , pricing final threshold, auto upload, and pricing review rules for pricing policies.
|
In Servigistics, you have the ability to set up to 20 prices for a SKU using price stream values. The Dynamic Price Buckets reference point category lets you use these price stream values as reference points for pricing threshold, final threshold, auto upload, and pricing review rules.
The Dynamic Price Buckets reference point category lets you set the value for any price stream value using the dynamic price of the price stream value. The dynamic price is the price for the price stream value that was output from the previous rule in the pricing policy. For example, if Dynamic Price Bucket is set to Standard Price in the pricing threshold rule, then the standard price that was output by the previous rule in the policy, which was the Strategy Code (Main) rule, is used for pricing the price stream value.
When setting up the rule, select the price stream value from the drop-down list that you want to use as a reference point. Only price stream values with an assigned value will display in the drop-down list.
Dynamic Targets
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Dynamic Target Margin %
|
Looks up the Dynamic Target Margin % adjustment factor for the part's SKU and applies it on top of the part's current price to get a new recommended price.
|
Price Plus
|
|
Dynamic Target Price
|
Looks up the Dynamic Target Price adjustment factor for the part's SKU and applies it on top of the part's current price to get a new recommended price.
|
Price Plus
|
Eff Current Costs
Eff Current Costs reference points use the effective current cost data that is derived during processing.
The formula for Eff Current Costs reference points is:
Effective Current X Cost
where X = reference point cost.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Eff Current Standard Cost
|
Effective current standard cost that is derived during processing.
|
Price Alignment
|
|
Eff Current Volume Cost
|
Effective current volume cost that is derived during processing.
|
Price Alignment
|
|
Eff Current Expedite Cost
|
Effective current expedite cost that is derived during processing.
|
Price Alignment
|
|
Eff Current Refurbished Cost
|
Effective current refurbished cost that is derived during processing.
|
Price Alignment
|
|
Eff Current Damaged Cost
|
Effective current damaged cost that is derived during processing.
|
Price Alignment
|
|
Eff Current Supplier Cost
|
Effective current supplier cost that is derived during processing.
|
Price Alignment
|
|
Eff Current Custom Cost (1-5)
|
Effective current custom cost (1-5) that is derived during processing.
|
Price Alignment
|
Eff Current Margin
Eff Current Margin reference points use the effective current cost and the effective current price data that is derived during processing.
The formula for Eff Current Margin reference points is:
X / (1 - [(( (Selected Price - X ) / Selected Price) + Adjustment)])
where X= reference point effective cost.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Eff Margin using Standard Cost
|
Effective current standard cost margin that is derived during processing.
|
Price Alignment
|
|
Eff Margin using Volume Cost
|
Effective current volume cost margin that is derived during processing.
|
Price Alignment
|
|
Eff Margin using Expedite Cost
|
Effective current expedite cost margin that is derived during processing.
|
Price Alignment
|
|
Eff Margin using Refurbished Cost
|
Effective current refurbished cost margin that is derived during processing.
|
Price Alignment
|
|
Eff Margin using Damaged Cost
|
Effective current damaged cost margin that is derived during processing.
|
Price Alignment
|
|
Eff Margin using Supplier Cost
|
Effective current supplier cost margin that is derived during processing.
|
Price Alignment
|
|
Eff Margin using Custom Cost (1-5)
|
Effective current custom cost margin (1-5) that is derived during processing.
|
Price Alignment
|
Eff Current Prices
Eff Current Prices reference points use the effective current price data that is derived during processing.
The formula for Eff Current Prices reference points is:
Effective Current X Price
where X = reference point effective price.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Eff Current Standard Price
|
Effective current standard price that is derived during processing.
|
Price Alignment
|
|
Eff Current Volume Price
|
Effective current volume price that is derived during processing.
|
Price Alignment
|
|
Eff Current Expedite Price
|
Effective current expedite price that is derived during processing.
|
Price Alignment
|
|
Eff Current Refurbished Price
|
Effective current refurbished price that is derived during processing.
|
Price Alignment
|
|
Eff Current Damaged Price
|
Effective current damaged price that is derived during processing.
|
Price Alignment
|
|
Eff Current Custom Price (1-20)
|
Effective current custom price (1-20) that is derived during processing.
|
Price Alignment
|
Eff Part Chain Relationship
Eff Part Relationship reference points use the effective current costs and the effective current price data that is derived during processing.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Replaced Part Eff Total Markup
|
Effective replaced part total markup price that is derived during processing.
|
Price Alignment
|
|
Replaced Part Eff Minimum Markup
|
Effective replaced part minimum markup price that is derived during processing.
|
Price Alignment
|
|
Replaced Part Eff Maximum Markup
|
Effective replaced part maximum markup price that is derived during processing.
|
Price Alignment
|
|
Replaced Part Eff Average Markup
|
Effective replaced part average markup price that is derived during processing.
|
Price Alignment
|
|
Replaced Part Eff Total Price
|
Effective replaced part total price that is derived during processing.
|
Price Alignment
|
|
Replaced Part Eff Minimum Price
|
Effective replaced part minimum price that is derived during processing.
|
Price Alignment
|
|
Replaced Part Eff Maximum Price
|
Effective replaced part maximum price that is derived during processing.
|
Price Alignment
|
|
Replaced Part Eff Average Price
|
Effective replaced part average price that is derived during processing.
|
Price Alignment
|
|
Part Chain Eff Max Price
|
Effective part chain maximum price that is derived during processing.
|
Price Alignment
|
|
Part Chain Eff Max Markup
|
Effective part chain maximum markup price that is derived during processing.
|
Price Alignment
|
|
Part Chain Eff Top Most Part Price
|
Effective part chain top most part price that is derived during processing.
|
Price Alignment
|
|
Part Chain Eff Top Most Part Markup
|
Effective part chain top most part markup price that is derived during processing.
|
Price Alignment
|
|
Part Chain Eff Max Inventory Price
|
Effective part chain maximum inventory price that is derived during processing.
|
Price Alignment
|
Eff Part Kit
Eff Part Kit reference points use the effective current price data that is derived during processing.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Part Kit - Eff Current Prices
|
Effective part kit current prices.
|
Price Alignment
|
Maintain Current Margin
The Maintain Current Margin group of reference points finds today’s current margin and then maintains that margin moving forward in time, while taking into account a change in cost. The final result derives what the new recommended price must be to maintain the margin with a changing cost.
The formula for Maintain Current Margin reference points is:
[X / (1 - [(((Selected Price - Y) / Selected Price) + Adjustment %)])] + Adjustment Amount
where X = Effective Reference Point Cost
and Y= Current Reference Point Cost.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Maintain Current Margin Using Effective Custom Cost 1
|
[Effective Custom Cost 1 / (1 - [(( (Selected Price – Current Custom Cost 1) / Selected Price) + Adjustment % )])] + Adjustment Amount
|
Margin Plus
|
|
Maintain Current Margin Using Effective Custom Cost 2
|
[Effective Custom Cost 2 / (1 - [(( (Selected Price - Current Custom Cost 2) / Selected Price) + Adjustment % )])] + Adjustment Amount
|
Margin Plus
|
|
Maintain Current Margin Using Effective Custom Cost 3
|
[Effective Custom Cost 3 / (1 - [(( (Selected Price - Current Custom Cost 3) / Selected Price) + Adjustment % )])] + Adjustment Amount
|
Margin Plus
|
|
Maintain Current Margin Using Effective Custom Cost 4
|
[Effective Custom Cost 4 / (1 - [(( (Selected Price - Current Custom Cost 4) / Selected Price) + Adjustment % )])] + Adjustment Amount
|
Margin Plus
|
|
Maintain Current Margin Using Effective Custom Cost 5
|
[Effective Custom Cost 5 / (1 - [(( (Selected Price - Current Custom Cost 5) / Selected Price) + Adjustment % )])] + Adjustment Amount
|
Margin Plus
|
|
Maintain Current Margin Using Effective Damaged Cost
|
[Effective Damaged Cost / (1 - [(( (Selected Price - Current Damaged Cost) / Selected Price) + Adjustment % )])] + Adjustment Amount
|
Margin Plus
|
|
Maintain Current Margin Using Effective Expedite Cost
|
[Effective Expedite Cost / (1 - [(( (Selected Price - Current Expedite Cost) / Selected Price) + Adjustment % )])] + Adjustment Amount
|
Margin Plus
|
|
Maintain Current Margin Using Effective Refurbished Cost
|
[Effective Refurbished Cost / (1 - [(( (Selected Price - Current Refurbished Cost) / Selected Price) + Adjustment % )])] + Adjustment Amount
|
Margin Plus
|
|
Maintain Current Margin Using Effective Supplier Cost
|
[Effective Supplier Cost / (1 - [(( (Selected Price - Current Supplier Cost) / Selected Price) + Adjustment % )])] + Adjustment Amount
|
Margin Plus
|
|
Maintain Current Margin Using Effective Standard Cost
|
[Effective Standard Cost / (1 - [(( (Selected Price - Current Standard Cost) / Selected Price) + Adjustment % )])] + Adjustment Amount
|
Margin Plus
|
|
Maintain Current Margin Using Effective Volume Cost
|
[Effective Volume Cost / (1 - [(( (Selected Price - Current
Volume Cost) / Selected Price) + Adjustment % )])] + Adjustment Amount
|
Margin Plus
|
Max Profit Price
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Distance to Max Profit Consolidated
|
The maximum combined profits of distributors and part suppliers. Represents the distance between Current Price and Max Profit. The percentage determines how close (0 to 100%) you want to approach the maximum price from current, or even exceed it (>100%).
|
Price Elasticity
|
|
Distance to Max Profit Local
|
The maximum combined profits of distributors (local) and part suppliers. Represents the distance between Current Price and Max Profit. The percentage determines how close (0 to 100%) you want to approach the maximum price from current, or even exceed it (>100%).
|
Price Elasticity
|
|
Max Profit Price - Consolidated
|
The value from IPCS_PRICE_REFOPT.MPPCosolidated column for a SKU. The elasticity process updates this value.
|
Price Elasticity
|
|
Max Profit Price - Local
|
The value from IPCS_PRICE_REFOPT.MPPLocal column for a SKU. The elasticity process updates this value.
|
Price Elasticity
|
New Margin
 |
New Margin uses the effective current cost that is derived during processing.
|
The formula for New Margin reference points is:
X / (1 - Adjustment)
where X = reference point cost.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
New Margin using Custom Cost 1
|
Custom Cost 1 / (1 - Adjustment)
|
Margin Plus
|
|
New Margin using Custom Cost 2
|
Custom Cost 2 / (1 - Adjustment)
|
Margin Plus
|
|
New Margin using Custom Cost 3
|
Custom Cost 3 / (1 - Adjustment)
|
Margin Plus
|
|
New Margin using Custom Cost 4
|
Custom Cost 4 / (1 - Adjustment)
|
Margin Plus
|
|
New Margin using Custom Cost 5
|
Custom Cost 5 / (1 - Adjustment)
|
Margin Plus
|
|
New Margin using Damaged Cost
|
Damaged Cost / (1 - Adjustment)
|
Margin Plus
|
|
New Margin using Expedite Cost
|
Expedite Cost / (1 - Adjustment)
|
Margin Plus
|
|
New Margin using Refurbished Cost
|
Refurbished Cost / (1 - Adjustment)
|
Margin Plus
|
|
New Margin using Supplier Cost
|
Supplier Cost / (1 - Adjustment)
|
Margin Plus
|
|
New Margin using Standard Cost
|
Standard Cost / (1 - Adjustment)
|
Margin Plus
|
|
New Margin using Volume Cost
|
Volume Cost / (1 - Adjustment)
|
Margin Plus
|
Part Chain Relationships
|
|
Part Chain Relationships use IPCS_COST records based on PP.CostDate and IPCS_PRICE records based on PP.PriceDate.
Markup for a part is calculated by Price / Cost.
NOTE: Markup for a part is calculated by Price / Cost.
Markup for a part is calculated by Price / Cost.
Markup for a part is calculated by Price / Cost.
|
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Part Chain Max Inventory Price
|
The price of the part within the part chain with the highest inventory level.
|
Price Alignment
|
|
Part Chain Top Most Part Price
|
The top most part price in a part chain. When used in a rule, all the parts to which the rule is applied will be assigned the top most part price of the part chain.
|
Price Alignment
|
|
Part Chain Top Most Part Markup
|
The top most part markup in the part chain. When used in a rule, all the parts to which the rule is applied will be assigned the same markup as the top most part markup of the part chain. Markup for a part is calculated by Price / Cost.
|
Price Alignment
|
|
Part Chain Max Price
|
The maximum price of a part in a part chain. When used in a rule, all the parts to which the rule is applied will be assigned the same price which is the maximum price of the chain.
|
Price Alignment
|
|
Part Chain Max Markup
|
The maximum markup of a part in the part chain. When used in a rule, all the parts to which the rule is applied will be assigned the same markup which is the maximum markup of the chain. Markup for a part is calculated by Price / Cost.
|
Price Alignment
|
|
Replaced Part Maximum Price
|
The maximum price of a part of all the replaced parts in the part chain. When used in a rule, all the parts to which the rule is applied will be assigned the same price, which is the maximum price of a part of all the replaced parts in the chain.
|
Price Alignment
|
|
Replaced Part Average Price
|
The average price of all the replaced parts in a part chain. When used in a rule, all the parts to which the rule is applied will be assigned the same price, which is the average price of all the replaced parts in a chain.
For example, if Part A, Part B, and Part C are the replaced parts in a chain, then:
Replaced Part Average Price = (Part A Price + Part B Price + Part C Price) / 3
|
Price Alignment
|
|
Replaced Part Minimum Price
|
The minimum price of a part of all the replaced parts in the part chain. When used in a rule, all the parts to which the rule is applied will be assigned the same price, which is the minimum price of a part of all the replaced parts in the chain.
|
Price Alignment
|
|
Replaced Part Total Price
|
The total price of all the replaced parts in the part chain. When used in a rule, all the parts to which the rule is applied will be assigned the same price, which is the total price of all the replaced parts in the chain.
For example, if Part A, Part B, and Part C are the replaced parts in a chain, then:
Replaced Part Total Price = (Part A Price + Part B Price + Part C Price)
|
Price Alignment
|
|
Replaced Part Maximum Markup
|
The maximum markup of a part of all the replaced parts in a chain. When used in a rule, all the parts to which the rule is applied will be assigned the same markup, which is the maximum markup of replaced parts in the part chain.
|
Price Alignment
|
|
Replaced Part Average Markup
|
The average markup of all the replaced parts in the part chain. When used in a rule, all the parts to which the rule is applied will be assigned the same markup, which is the Average Markup of replaced parts in the part chain.
For example, if Part A, Part B, and Part C are the replaced parts in a chain, then:
Replaced Part Average Markup =
(Part A Markup + Part B Markup + Part C Markup) /3
|
Price Alignment
|
|
Replaced Part Minimum Markup
|
The minimum markup of a part of all the replaced parts in a chain. When used in a rule, all the parts to which the rule is applied will be assigned the same markup, which is the minimum markup of replaced parts in the part chain.
|
Price Alignment
|
|
Replaced Part Total Markup
|
The total markup of all the replaced parts in the part chain. When used in a rule, all the parts to which the rule is applied will be assigned the same markup, which is the total markup of replaced parts in the part chain.
For example, if Part A, Part B, and Part C are the replaced parts in a chain, then:
Replaced Part Total Markup = (Part A Markup + Part B Markup + Part C Markup)
|
Price Alignment
|
Part Group Relationships
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
||
|---|---|---|---|---|
|
Part Family Avg Price
|
The average price of all the parts that have the same part family as defined by part master record. When used in a pricing policy rule, all the parts to which the rule is applied will be assigned the same average price of the part family plus any adjustment factor that exists.
For example, assume parts A, B, and C are in the same part family on their part master records. Then:
Part Family Avg Price =
(Price for part A + Price for part B + Price for part C) / 3
|
Price Alignment
|
||
|
Part Family Wtd Avg Price
|
The weighted average price of all the parts that have the same part family as defined by part master record. When used in a pricing policy rule, all the parts to which the rule is applied will be assigned the same weighted average price of the part family plus any adjustment factor that exists.
|
Price Alignment
|
||
|
Part Family Avg Margin
|
The average price margin of the parts that have the same part family as defined by part master record. When used in a pricing policy rule, all the parts to which the rule is applied will be assigned the same average price margin of the part family plus any adjustment factor that exists.
For example, assume parts A, B, and C are in the same part family. Then:
Part Family Avg Margin =
(Price Margin for part A + Price Margin for part B + Price Margin for part C) / 3
|
Price Alignment
|
||
|
Part Family Wtd Avg Margin
|
The weighted average price margin of the parts that have the same part family as defined by part master record. When used in a pricing policy rule, all the parts to which the rule is applied will be assigned the same weighted average price margin of the part family plus any adjustment factor that exists.
N
OTE: Margin for each SKU is calculated by: (Price - Cost) / Price.
|
Price Alignment
|
||
|
Part Family Max Inventory Price
|
The price of the part within the part family with the highest inventory level.
Setting price within this part group to the part that has the highest inventory level will ensure that the part with the inventory (and potentially greatest demand) will not be priced above the other parts and result in stranded, unsold inventory.
|
Price Alignment
|
||
|
Part Type Avg Price
|
The average price of all the parts that have the same part type as defined by part master record. When used in a pricing policy rule, all the parts to which the rule is applied will be assigned the same average price of the part type plus any adjustment factor that exists.
For example, assume parts A, B, and C are of the same part type on their part master records. Then:
Part Type Avg Price =
(Price for part A + Price for part B + Price for part C) / 3
|
Price Alignment
|
||
|
Part Type Wtd Avg Price
|
The weighted average price of all the parts that have the same part type as defined by part master record. When used in a pricing policy rule, all the parts to which the rule is applied will be assigned the same weighted average price of the part type plus any adjustment factor that exists.
|
Price Alignment
|
||
|
Part Type Avg Margin
|
The average price margin of the parts that have the same part type as defined by part master record. When used in a pricing policy rule, all the parts to which the rule is applied will be assigned the same average price margin of the part type plus any adjustment factor that exists.
For example, assume parts A, B, and C are of the same part type. Then:
Part Type Avg Margin =
(Price Margin for part A + Price Margin for part B + Price Margin for part C) / 3
|
Price Alignment
|
||
|
Part Type Wtd Avg Margin
|
The weighted average price margin of the parts that have the same part type as defined by part master record. When used in a pricing policy rule, all the parts to which the rule is applied will be assigned the same weighted average price margin of the part type plus any adjustment factor that exists.
N
OTE: Margin for each SKU is calculated by: (Price - Cost) / Price.
|
Price Alignment
|
||
|
Part Type Max Inventory Price
|
The price of the part within the part type with the highest inventory level.
Setting price within this part group to the part that has the highest inventory level will ensure that the part with the inventory (and potentially greatest demand) will not be priced above the other parts and result in stranded, unsold inventory.
|
Price Alignment
|
||
|
Part Class Avg Price
|
The average price of all the parts that have the same part class as defined by part master record. When used in a pricing policy rule, all the parts to which the rule is applied will be assigned the same average price of the part class plus any adjustment factor that exists.
For example, assume parts A, B, and C are of the same part class on their part master records. Then:
Part Class Avg Price =
(Price for part A + Price for part B + Price for part C) / 3
|
Price Alignment
|
||
|
Part Class Wtd Avg Price
|
The weighted average price of all the parts that have the same part class as defined by part master record. When used in a pricing policy rule, all the parts to which the rule is applied will be assigned the same weighted average price of the part class plus any adjustment factor that exists.
|
Price Alignment
|
||
|
Part Class Avg Margin
|
The average price margin of the parts that have the same part class as defined by part master record. When used in a pricing policy rule, all the parts to which the rule is applied will be assigned the same average price margin of the part class plus any adjustment factor that exists.
For example, assume parts A, B, and C are of the same part class. Then:
Part Class Avg Margin =
(Price Margin for part A + Price Margin for part B + Price Margin for part C) / 3
|
Price Alignment
|
||
|
Part Class Wtd Avg Margin
|
The weighted average price margin of the parts that have the same part class as defined by part master record. When used in a pricing policy rule, all the parts to which the rule is applied will be assigned the same weighted average price margin of the part class plus any adjustment factor that exists.
N
OTE: Margin for each SKU is calculated by: (Price - Cost) / Price.
|
Price Alignment
|
||
|
Part Class Max Inventory Price
|
The price of the part within the part class with the highest inventory level.
Setting price within this part group to the part that has the highest inventory level will ensure that the part with the inventory (and potentially greatest demand) will not be priced above the other parts and result in stranded, unsold inventory.
|
Price Alignment
|
||
|
Part Line Avg Price
|
The average price of all the parts that have the same part line as defined by part master record. When used in a pricing policy rule, all the parts to which the rule is applied will be assigned the same average price of the part line plus any adjustment factor that exists.
For example, assume parts A, B, and C are in the same part line on their part master records. Then:
Part Line Avg Price =
(Price for part A + Price for part B + Price for part C) / 3
|
Price Alignment
|
||
|
Part Line Wtd Avg Price
|
The weighted average price of all the parts that have the same part line as defined by part master record. When used in a pricing policy rule, all the parts to which the rule is applied will be assigned the same weighted average price of the part line plus any adjustment factor that exists.
|
Price Alignment
|
||
|
Part Line Avg Margin
|
The average price margin of the parts that have the same part line as defined by part master record. When used in a pricing policy rule, all the parts to which the rule is applied will be assigned the same average price margin of the part line plus any adjustment factor that exists.
For example, assume parts A, B, and C are in the same part line. Then:
Part Line Avg Margin =
(Price Margin for part A + Price Margin for part B + Price Margin for part C) / 3
|
Price Alignment
|
||
|
Part Line Wtd Avg Margin
|
The weighted average price margin of the parts that have the same part line as defined by part master record. When used in a pricing policy rule, all the parts to which the rule is applied will be assigned the same weighted average price margin of the part line plus any adjustment factor that exists.
For example, assume parts A, B, and C are in the same part line. Then:
|
Price Alignment
|
||
|
Part Line Max Inventory Price
|
The price of the part within the part line with
the highest inventory level.
Setting price within this part group to the part that has the highest inventory level will ensure that the part with the inventory (and potentially greatest demand) will not be priced above the other parts and result in stranded, unsold inventory.
|
Price Alignment
|
||
|
Part Family Price Uplift %
|
Looks up the price percentage adjustment factor for the part family to which the part belongs and applies it on top of the part's current price to get a new recommended price.
|
Price Plus
|
||
|
Part Type Price Uplift %
|
Looks up the price percentage adjustment factor for the part type to which the part belongs and applies it on top of the part's current price to get a new recommended price.
|
Price Plus
|
||
|
Part Class Price Uplift %
|
Looks up the price percentage adjustment factor for the part class to which the part belongs and applies it on top of the part's current price to get a new recommended price.
|
Price Plus
|
||
|
Part Line Price Uplift %
|
Looks up the price percentage adjustment factor for the part line to which the part belongs and applies it on top of the part's current price to get a new recommended price.
|
Price Plus
|
||
|
Part SKU Price Uplift % A
Part SKU Price Uplift % B
|
Looks up the price percentage adjustment factor for the part's SKU and applies it on top of the part's current price to get a new recommended price.
Note that two versions of the pricing reference point are provided (A and B). This allows you to apply two different adjustment factors to the same SKU to be used in a pricing policy.
|
Price Plus
|
Part Kit Relationships
|
|
Part Kit Relationships use IPCS_PRICE records based on PP.PriceDate.
If part kit components are not contained on the pricing policy or are not price active, they will not get a recommended price and will not be included in the kit pricing decision. If no component prices are available, the kit price reference point will be null and no new kit price will be recommended.
|
Price Adjustment Factors
Price Adjustment Factors reference points look up the price percentage adjustment factor for the X group to which the part belongs and applies it on top of the part's current price to get a new recommended price, where X = part family/class/type/line.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Part Family Price Uplift %
|
Looks up the price percentage adjustment factor for the part family to which the part belongs and applies it on top of the part's current price to get a new recommended price.
|
Price Plus
|
|
Part Type Price Uplift %
|
Looks up the price percentage adjustment factor for the part type to which the part belongs and applies it on top of the part's current price to get a new recommended price.
|
Price Plus
|
|
Part Class Price Uplift %
|
Looks up the price percentage adjustment factor for the part class to which the part belongs and applies it on top of the part's current price to get a new recommended price.
|
Price Plus
|
|
Part Line Price Uplift %
|
Looks up the price percentage adjustment factor for the part line to which the part belongs and applies it on top of the part's current price to get a new recommended price.
|
Price Plus
|
|
Part SKU Price Uplift % A
Part SKU Price Uplift % B
|
Looks up the price percentage adjustment factor for part's SKU and applies it on top of the part's current price to get a new recommended price.
Note that two versions of the pricing reference point are provided (A and B). This allows you to apply two different adjustment factors to the same SKU to be used in a pricing policy.
|
Price Plus
|
Ref Loc Current Costs
The formula for Ref Loc Current Costs reference points is:
IPCS_COST.X value for the current cost record
where X = reference point cost for the reference location.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Ref Loc Current Standard Cost
|
Current standard cost of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Current Custom Cost (1-5)
|
Current custom cost (1-5) of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Current Volume Cost
|
Current volume cost of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Current Expedite Cost
|
Current expedite cost of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Current Refurbished Cost
|
Current refurbished cost of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Current Damaged Cost
|
Current damaged cost of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Current Supplier Cost
|
Current supplier cost of the user selected reference location.
|
Price Alignment
|
Ref Loc Current Margins
The formula for Ref Loc Current Margins reference points is:
X / (1 - [(( (Selected Price - X ) / Selected Price) + Adjustment)])
where X= reference point cost at reference location.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Ref Loc Margin Using Standard Cost
|
Current standard cost margin of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Margin Using Custom Cost (1-5)
|
Current custom cost margin (1-5) of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Margin Using Volume Cost
|
Current volume cost margin of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Margin Using Expedite Cost
|
Current expedite cost margin of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Margin Using Refurbished Cost
|
Current refurbished cost margin of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Margin Using Damaged Cost
|
Current damaged cost margin of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Margin Using Supplier Cost
|
Current supplier cost margin of the user selected reference location.
|
Price Alignment
|
Ref Loc Current Prices
The formula for Ref Loc Current Prices reference points is:
IPCS_PRICE.X value for the current price record
where X = reference point price at the reference location.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Ref Loc Current Standard Price
|
Current standard price of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Current Custom Price (1-20)
|
Current custom price (1-20) of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Current Volume Price
|
Current volume price of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Current Expedite Price
|
Current expedite price of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Current Refurbished Price
|
Current refurbished price of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Current Damaged Price
|
Current damaged price of the user selected reference location.
|
Price Alignment
|
Ref Loc Eff Current Costs
The formula for Ref Loc Eff Current Costs reference points is:
Effective Current X Cost
where X = reference point cost at reference location.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Ref Loc Eff Current Standard Cost
|
Effective current standard cost based on the policy effective date of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Eff Current Custom Cost (1-5)
|
Effective current custom cost (1-5) based on the policy effective date of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Eff Current Volume Cost
|
Effective current volume cost based on the policy effective date of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Eff Current Expedite Cost
|
Effective current expedite cost based on the policy effective date of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Eff Current Refurbished Cost
|
Effective current refurbished cost based on the policy effective date of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Eff Current Damaged Cost
|
Effective current damaged cost based on the policy effective date of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Eff Current Supplier Cost
|
Effective current supplier cost based on the policy effective date of the user selected reference location.
|
Price Alignment
|
Ref Loc Eff Current Margins
The formula for Ref Loc Eff Current Margins reference points is:
X / (1 - [(( (Selected Price - X ) / Selected Price) + Adjustment)])
where X = reference point effective cost at reference location.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Ref Loc Eff Current Margin Using Standard Cost
|
Effective current standard cost margin based on the policy effective date of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Eff Current Margin Using Custom Cost (1-5)
|
Effective current custom cost margin (1-5) based on the policy effective date of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Eff Current Margin Using Volume Cost
|
Effective current volume cost margin based on the policy effective date of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Eff Current Margin Using Expedite Cost
|
Effective current expedite cost margin based on the policy effective date of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Eff Current Margin Using Refurbished Cost
|
Effective current refurbished cost margin based on the policy effective date of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Eff Current Margin Using Damaged Cost
|
Effective current damaged cost margin based on the policy effective date of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Eff Current Margin Using Supplier Cost
|
Effective current supplier cost margin based on the policy effective date of the user selected reference location.
|
Price Alignment
|
Ref Loc Eff Current Prices
The formula for Ref Loc Eff Current Prices reference points is:
Effective Current X Price
where X = reference point effective price at the reference location.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Ref Loc Eff Current Standard Price
|
Effective current standard price based on the policy effective date of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Eff Current Custom Price (1-20)
|
Effective current custom price (1-20) based on the policy effective date of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Eff Current Volume Price
|
Effective current volume price based on the policy effective date of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Eff Current Expedite Price
|
Effective current expedite price based on the policy effective date of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Eff Current Refurbished Price
|
Effective current refurbished price based on the policy effective date of the user selected reference location.
|
Price Alignment
|
|
Ref Loc Eff Current Damaged Price
|
Effective current damaged price based on the policy effective date of the user selected reference location.
|
Price Alignment
|
Ref Loc New Rec Margins
The formula for Ref Loc New Rec Margins reference points is:
New recommended X cost margin from the Price Actions table where Status = Approved for upload of reference location
where X = reference point cost.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Ref Loc New Rec Margin Using Standard Cost
|
New recommended standard cost margin from the Price Actions table where Status = Approved for upload of reference location.
|
Price Alignment
|
|
Ref Loc New Rec Margin Using Custom Cost (1-5)
|
New recommended custom cost margin (1-5) from the Price Actions table where Status = Approved for upload of reference location.
|
Price Alignment
|
|
Ref Loc New Rec Margin Using Volume Cost
|
New recommended volume cost margin from the Price Actions table where Status = Approved for upload of reference location.
|
Price Alignment
|
|
Ref Loc New Rec Margin Using Expedite Cost
|
New recommended expedite cost margin from the Price Actions table where Status = Approved for upload of reference location.
|
Price Alignment
|
|
Ref Loc New Rec Margin Using Refurbished Cost
|
New recommended refurbished cost margin from the Price Actions table where Status = Approved for upload of reference location.
|
Price Alignment
|
|
Ref Loc New Rec Margin Using Damaged Cost
|
New recommended damaged cost margin from the Price Actions table where Status = Approved for upload of reference location.
|
Price Alignment
|
|
Ref Loc New Rec Margin Using Supplier Cost
|
New recommended supplier cost margin from the Price Actions table where Status = Approved for upload of reference location.
|
Price Alignment
|
Ref Loc New Rec Prices
The formula for Ref Loc New Prices reference points is:
New recommended X price from the Price Actions table where Status = Approved for upload of the reference location
where X = reference point price.
|
Reference Point
|
Sets Price to...
|
Pricing Methodology Used
|
|---|---|---|
|
Ref Loc New Rec Standard Price
|
New recommended standard price from the Price Actions table where Status = Approved for upload of the reference location.
|
Price Alignment
|
|
Ref Loc New Rec Custom Price (1-20)
|
New recommended custom price (1-20) from the Price Actions table where Status = Approved for upload of the reference location.
|
Price Alignment
|
|
Ref Loc New Rec Volume Price
|
New recommended volume price from the Price Actions table where Status = Approved for upload of the reference location.
|
Price Alignment
|
|
Ref Loc New Rec Expedite Price
|
New recommended expedite price from the Price Actions table where Status = Approved for upload of the reference location.
|
Price Alignment
|
|
Ref Loc New Rec Refurbished Price
|
New recommended refurbished price from the Price Actions table where Status = Approved for upload of the reference location.
|
Price Alignment
|
|
Ref Loc New Rec Damaged Price
|
New recommended damaged price from the Price Actions table where Status = Approved for upload of the reference location.
|
Price Alignment
|