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.
Formula
s2.PreviousListPrice * (s1.CurrentCostPerUnit / NULLIF(s2.PreviousCostPerUnit,0))*s1.CurrentQuantity - 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.
Formula
s2.PreviousListPrice * (s1.CurrentCostPerUnit / NULLIF(s2.PreviousCostPerUnit,0))*s1.CurrentQuantity - 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.
Formula
(s2.PreviousListPrice * (s1.CurrentCostPerUnit / NULLIF(s2.PreviousCostPerUnit,0))*s1.CurrentQuantity - s1.CurrentRevenue) / NULLIF(s1.CurrentRevenue,0) - s1.CurrentMarginRate
Price Change %
Definition
Percentage change between the current realized price and the previous realized price, comparing the recent period to the previous period.
Formula
(s1.CurrentPrice / NULLIF( s2.PreviousPrice,0)-1)*100