Product Cost Pass-Through Agent (Formula Expression)

This page provides summary of the Formula Expressions used in the Product Cost Pass-Through Agent (Reference).

Cost Change %

Definition

:question_mark:

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

:question_mark:

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

:question_mark:

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

:question_mark:

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

:question_mark:

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

:question_mark:

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

:question_mark:

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

:question_mark:

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