This page provides summary of the Formula Expressions used in the Product Cost Pass-Through Agent (Reference).
Cost Change %
Definition
Percentage change in average unit cost from the previous period to the current period.
Formula
(s1.CurrentCostPerUnit / NULLIF(s2.PreviousCostPerUnit,0) -1)*100
List Price Change %
Definition
Percentage change in list price from the previous period to the current period.
Formula
(s1.CurrentListPrice / NULLIF( s2.PreviousListPrice,0)-1)*100
Cost Pass Through Variance
Definition
Difference between the period‑over‑period rate of change in average list price and the rate of change in average unit cost. Indicates whether price movements keep pace with cost changes between current and previous periods.
Formula
(s1.CurrentListPrice / NULLIF( s2.PreviousListPrice,0)-1) - (s1.CurrentCostPerUnit / NULLIF(s2.PreviousCostPerUnit,0) -1)
Suggested List Price
Definition
Recommended list price obtained by applying the observed cost change to the previous list price, so the list price fully reflects the cost increase (or decrease).
Formula
s2.PreviousListPrice * (s1.CurrentCostPerUnit / NULLIF(s2.PreviousCostPerUnit,0))
Revenue Uplift
Definition
Incremental revenue expected in the current period if the suggested list price were applied instead of the current list price, given current volume. The calculation keeps the current price realization, which is the current revenue divided by the current list price multiplied by the current quantity.
Formula
s2.PreviousListPrice * (s1.CurrentCostPerUnit / NULLIF(s2.PreviousCostPerUnit,0)) * s1.CurrentQuantity * s1.CurrentRevenue / NULLIF(s1.CurrentListPrice * s1.CurrentQuantity,0) - s1.CurrentRevenue
Margin Potential
Definition
Additional gross margin that could be recovered in the current period if the suggested list price were applied instead of the current list price, given current volume. The calculation keeps the current price realization, which is the current revenue divided by the current list price multiplied by the current quantity.
Formula
s2.PreviousListPrice * (s1.CurrentCostPerUnit / NULLIF(s2.PreviousCostPerUnit,0)) * s1.CurrentQuantity * s1.CurrentRevenue / NULLIF(s1.CurrentListPrice * s1.CurrentQuantity,0) - s1.CurrentRevenue
Margin Potential (pp)
Definition
Expected improvement in margin rate, expressed in percentage points, if the suggested list price were applied instead of the current list price. The value is the margin rate at the suggested list price minus the current margin rate.
Formula
(s1.CurrentMargin + s2.PreviousListPrice * (s1.CurrentCostPerUnit / NULLIF(s2.PreviousCostPerUnit,0)) * s1.CurrentQuantity * s1.CurrentRevenue / NULLIF(s1.CurrentListPrice * s1.CurrentQuantity,0) - s1.CurrentRevenue) / NULLIF(s2.PreviousListPrice * (s1.CurrentCostPerUnit / NULLIF(s2.PreviousCostPerUnit,0)) * s1.CurrentQuantity * s1.CurrentRevenue / NULLIF(s1.CurrentListPrice * s1.CurrentQuantity,0),0) - s1.CurrentMarginRate
Suggested List Price Change
Definition
Ratio of the suggested list price to the current list price. A value above 1 means that the suggested list price is higher than the current list price.
Formula
(s1.CurrentPrice / NULLIF( s2.PreviousPrice,0)-1)*100