Per Unit Cost Pass-Through Agent (Formula Expressions)

This page provides summary of the Formula Expressions used in the .

Current Margin Rate

Definition

:question_mark:

The weighted current gross margin percentage. Total margin divided by total revenue.

Formula

SUM(GrossMargin) / NULLIF(SUM(InvoicePrice),0)

Current Price

Definition

:question_mark:

The average unit price in the current period. Sum of invoice price divided by sum of quantity.

Formula

SUM(InvoicePrice) / NULLIF(SUM(Quantity),0)

Current Cost Per Unit

Definition

:question_mark:

The average unit cost in the current period. Per‑unit cost derived by dividing the cost by quantity.

Formula

SUM(InvoicePrice) / NULLIF(SUM(Quantity),0)

Previous Cost Per Unit

Definition

:question_mark:

The average unit cost in the previous period. Per‑unit cost derived by dividing the cost by quantity.

Formula

SUM(TotalCosts) / NULLIF(SUM(Quantity),0)

Previous Margin Rate

Definition

:question_mark:

The weighted gross margin percentage in the previous period. Previous total margin divided by previous total revenue.

Formula

SUM(GrossMargin) / NULLIF(SUM(InvoicePrice),0)

Previous Price

Definition

:question_mark:

The average unit price in the previous period. Sum of invoice price divided by sum of quantity for previous period.

Formula

SUM(InvoicePrice) / NULLIF(SUM(Quantity),0)

Cost Change Abs

Definition

:question_mark:

The period-over-period absolute change in average unit cost (current minus previous). Positive values indicate costs increased. Negative values indicate costs decreased.

Formula

s1.CurrentCostPerUnit - s2.PreviousCostPerUnit
  • s1 –

  • s2 –

Price Change Abs

Definition

:question_mark:

The period-over-period absolute change in average unit price (current minus previous). Positive values indicate prices increased. Negative values indicate prices decreased.

Formula

s1.CurrentPrice - s2.PreviousPrice

Pass Through Ratio

Definition

:question_mark:

The ratio of the period-over-period price change to the period-over-period cost change. It quantifies how effectively price movements reflect underlying cost movements between the previous period and the recent period.

Formula

if ( 
round(s1.CurrentCostPerUnit -  s2.PreviousCostPerUnit,3) <= 0,
0,
(s1.CurrentPrice -  s2.PreviousPrice) / ( s1.CurrentCostPerUnit -  s2.PreviousCostPerUnit)
)

Margin Potential

Definition

:question_mark:

The monetary amount of margin that could be recovered in the current period if the margin rate were restored to the previous period’s margin rate (apply previous margin % to current revenue). This expresses the theoretical margin uplift tied to correcting insufficient pass‑through.

Formula

if (
(s1.CurrentCostPerUnit -  s2.PreviousCostPerUnit) - (s1.CurrentPrice -  s2.PreviousPrice) <= 0,
0,
s1.CurrentQuantity * ( (s1.CurrentCostPerUnit -  s2.PreviousCostPerUnit) - (s1.CurrentPrice -  s2.PreviousPrice) )
)

Margin Delta (Percentage Points)

Definition

:question_mark:

The period-over-period change in gross margin rate, expressed in percentage points (pp). Calculated as current margin rate minus previous margin rate. Positive values indicate margin rate improved, negative values indicate it declined.

Formula

s1.CurrentMarginRate - s2.PreviousMarginRate

Cost Delta

Definition

:question_mark:

The period-over-period absolute change in average unit cost (current minus previous). Positive values indicate costs increased. Negative values indicate costs decreased.

Formula

s1.CurrentCostPerUnit - s2.PreviousCostPerUnit

Price Delta

Definition

:question_mark:

The period-over-period absolute change in average unit price (current minus previous). Positive values indicate prices increased. Negative values indicate prices decreased.

Formula

s1.CurrentPrice - s2.PreviousPrice

Suggested Price

Definition

:question_mark:

Calculates the sum of the current period’s average unit price and current period’s average unit cost, then subtracts the previous period’s average unit cost. This metric can be used to assess whether current pricing and cost changes are aligned with historical cost baselines.

Formula

s1.CurrentPrice + s1.CurrentCostPerUnit - s2.PreviousCostPerUnit

Revenue Uplift

Definition

:question_mark:

Estimates the monetary impact resulting from the difference between the change in unit cost and the change in unit price between the current and previous periods. If the increase in cost per unit exceeds the increase in price per unit, the formula quantifies the total negative impact on margin for the current quantity sold. If the price increase matches or exceeds the cost increase, the impact is zero.

Formula

if (
(s1.CurrentCostPerUnit -  s2.PreviousCostPerUnit) - (s1.CurrentPrice -  s2.PreviousPrice) <= 0,
0,
s1.CurrentQuantity * ( (s1.CurrentCostPerUnit -  s2.PreviousCostPerUnit) - (s1.CurrentPrice -  s2.PreviousPrice) )
)