Product Cost Misalignment Agent (Formula Expressions)

The weighted average unit cost over the selected period, computed as total cost divided by total quantity. This yields a per‑unit cost figure that accounts for varying transaction volumes.

The weighted average unit selling price over the selected period, computed as total invoice price divided by total quantity. This yields a per‑unit price figure that accounts for varying transaction volumes.

The rate of change in the average unit cost from the previous period (P1) to the recent period (P2). A positive value indicates costs increased between periods; a negative value indicates costs decreased.

• s1 – Series 1 (Previous Period)

• s2 – Series 2 (Current Period)

The rate of change in the average unit price from the previous period (P1) to the recent period (P2). A positive value indicates prices increased between periods; a negative value indicates prices decreased.

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

A hypothetical revenue level that realigns price changes with cost changes for the recent period, computed by normalizing recent revenue by the observed price change and scaling it by the observed cost change between periods.

A hypothetical profit-impact proxy derived by applying the same realignment logic used for Revenue Potential, using recent revenue normalized by price change and scaled by cost change between periods. As listed in the tutorial, it uses the same formula structure as Revenue Potential.

The weighted average list price per unit over the previous period. This metric is calculated by dividing the total list price value by the total quantity sold, providing a per-unit list price that accounts for varying transaction volumes.

The weighted average list price per unit over the current period. This metric is calculated by dividing the total list price value by the total quantity sold, providing a per-unit list price that accounts for varying transaction volumes.

The rate of change in the average list price per unit from the previous period to the current period. A positive value indicates that list prices increased between periods; a negative value indicates that list prices decreased. This metric helps quantify how list pricing has evolved over time, accounting for changes in transaction volumes.

A recommended list price for the current period, calculated by normalizing the current list price by the observed price change and scaling it by the observed cost change between periods. This metric estimates what the list price should be if it were adjusted to reflect both price and cost changes from the previous period to the current period.

A hypothetical price level for the current period, normalized by the observed rate of change in average price and scaled by the observed rate of change in average cost between periods. This metric estimates what the current average price would be if it were adjusted to reflect both price and cost changes from the previous period, providing a counterfactual benchmark for price alignment with cost movements.