Flavor Profiles

Rolling 30-day jug build vs waste mix per store, compared to the target mix inflavor_mix. Net % = share of consumed jugs (built − wasted). Δ vs target shows where actual demand diverges from what we plan to build.

Built (L30)

—

Wasted (L30)

—

Net Consumed

—

Range

—

Build % — this flavor's share of all jugs built in the window: built / total_built.

Waste % — per-flavor waste rate: wasted / built for that flavor.

Net % — this flavor's share of jugs that were actually consumed (built minus wasted): (built − wasted) / Σ(built − wasted). Best read of real customer demand by flavor.

Target % (DB) — what we plan to build for this flavor, from the flavor_mix table. Per-store for a single store, build-volume-weighted average for All Stores.

Δ vs Target — Net % minus Target %. Δ > 0 means actual demand exceeds the planned mix (consider building more). Δ < 0 means we're overbuilding relative to demand (trim).

By State / By Store — Net % is recomputed within that scope: each column sums to ~100% of its own net consumption. Avg column = simple mean of present cells. Total row at the bottom is the column sum (sanity check; should land near 100%).