Cost Pass-Through Agent (Formula Expressions)

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

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

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

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

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

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

The period-over-period rate of change in the average unit cost, comparing the recent period to the previous period. A positive value indicates that costs increased, a negative value indicates that costs decreased.

• s1 – Series 1 (Current Period)

• s2 – Series 2 (Previous Period)

The period-over-period rate of change in the average unit price, comparing the recent period to the previous period. A positive value indicates that prices increased, a negative value indicates that prices decreased.

The difference between the period-over-period rate of change in average unit price and the rate of change in average unit cost. This metric quantifies whether price increases (or decreases) are keeping pace with cost changes between the current and previous periods. A positive value indicates that prices have increased more (or decreased less) than costs, suggesting margin improvement; a negative value indicates costs have outpaced price changes, suggesting margin compression.

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.

The margin gap in percentage points between the previous period and the current period, i.e., the target margin‑rate delta to be recovered via pass‑through. Positive values indicate the current margin rate is below the previous margin rate by that number of percentage points.

A recalculated previous period price, adjusted to reflect the change in unit cost from the previous period to the current period. This metric estimates what the previous price would be if it had changed in direct proportion to the cost change, holding the previous price as the base.

Estimates the additional revenue that could be realized in the current period if the previous period’s price were adjusted proportionally to the change in unit cost, then applied to the current quantity. The result is the difference between this hypothetical revenue and the actual current revenue, quantifying the revenue impact of not fully passing cost changes through to price.