Price Curves
Price Curves are the pricing of parts using a competitor margin. Price Curves are managed on the
Price Curves page.
In the case that a part does not have competitive data, the competitive data of similar parts are grouped together and a price curve is developed for the group of parts. Once the price curve is established, the target price for any part can be calculated.
A price curve is established between the margin (y-axis) and natural log of the part cost (x-axis). This curve is developed by applying simple linear regression on the existing competitive price data. The price curve generates a logarithmic curve, but the equation is represented in linear form (y = mx + c) only, and a slope (m) and an intercept (c) are calculated.
Once the price curve is established, the price for any part can be derived from Target Margin using the following formulas:
Target Margin = m * ln(Cost) + c
(where m is the slope and c is the intercept for the cost curve)
Price = (1 / (1 - (m * ln(Cost) + c))) * Cost
(or Price = 1 / (1 - Target Margin) * Cost)
Price curves are eventually used to make price recommendations within a pricing policy. Since the SKUs associated with a price curve are assigned through segments, it is possible (even likely) that a SKU will be associated with more than one price curve. Price curve sequencing is used to establish precedence for SKUs that belong to more than one price curve.
If a SKU is in two price curves, the pricing policy uses the price curve for the SKU that has the higher order.
Follow these steps to use Price Curves:
1. Create price curves
2. Change price curve sequence
3. Process price curves
4. Review price curve processing results
5. Use price curves in pricing policies to price SKUs