Prerendered snapshot. Every figure below was computed at build time from the synthetic dataset. Open the live app for filter combinations outside the presets, the returns workflow, and admin — it runs on a free instance and can take ~20s to wake.
Prerendered snapshot · no server request
Product Intelligence Workspace
SKU DF-1196DF-1196 — Whole Milk Northgate Select Value Bundle

Whole Milk Northgate Select Value Bundle

Last 28 days revenue moved by $216 vs the prior 28 days. The dominant driver was lb volume movement; gross profit changed by $3 and margin improved.
Current scoped window: Oct 1, 2025 – Jul 5, 2026. Rolling 28-day diagnostics compare 2026-06-08 to 2026-07-05 against 2026-05-11 to 2026-06-07. · Refreshed 2026-08-15T20:18:01.763552+00:00
Posture: DecliningLifecycle: DecliningClassification: VariableProtein: Dairy & Frozen Target status: Materially below minimum Gross margin gates: min 18.0% · target 24.0% Meat Manager cost/lb: $2.46Effective cost/lb: $2.49Min price/lb: $4.04Target price/lb: $4.36ASP/lb: $2.51Top customer: Unknown · $586.58Lead region: Southeast · $1,584.66Cost coverage: 100.0%Last sold: Jul 3, 2026Data confidence: Medium
What is happening
Last 28 days revenue moved by $216 vs the prior 28 days. The dominant driver was lb volume movement; gross profit changed by $3 and margin improved.
Next: Rolling 28-day diagnostics compare 2026-06-08 to 2026-07-05 against 2026-05-11 to 2026-06-07.
Why it matters
100.0% of revenue sits below the target margin threshold.
Next: Use the risk, pricing, and customer sections to confirm whether the issue is concentration, margin, or demand quality.
What to do next
Fairview Market offers up to $151 of margin uplift to target.
Next: Click any action card, customer row, margin-risk row, basket row, or chart point to inspect context without leaving the page.
Commercial outcome
$6,779.05
Gross margin 0.8% · Contribution 0.1%
Weight & movement
2,706 lb
Avg 36.1 lb/order · 68.1 lb/wk
Primary risk
Margin recovery needed
100.0% of revenue sits below the target margin threshold.
Best next move
Pricing recovery
Fairview Market offers up to $151 of margin uplift to target.
Interactive detail
Context
Click a card, row, or chart point to inspect what changed, why it matters, and where to go next.

Executive Scorecard

Commercial outcome, demand movement, pricing quality, customer reach, and trust indicators for the active scoped window.

Rolling 28-day diagnostics compare 2026-06-08 to 2026-07-05 against 2026-05-11 to 2026-06-07. Use this layer to decide whether this SKU matters because of commercial scale, weight importance, pricing leakage, or customer dependency.
Export scorecard
Commercial Outcome
Revenue, gross margin, contribution, and recent movement.
Revenue$6,779.05
Gross Margin $$53.96
Margin %0.8%
Contribution Share0.1%
28D Revenue Δ$-216.21 / -23.8%
28D Weight Δ-95.5 / -26.7%
Demand & Movement
Units, shipped lb, cadence, movement efficiency, and stability.
Orders75
Customers53
Units242.0
Shipped lb2,705.7
Avg units / order3.23
Avg lb / order36.08
Avg lb / unit11.18
Demand stability15
Pricing & Margin
ASP/lb-first pricing view with price dispersion and margin exposure.
ASP/lb$2.51
Meat Manager cost / lb$2.46
Effective cost / lb$2.49
Minimum price / lb$4.04
Target price / lb$4.36
ASP/lb gap to minimum$-1.53
ASP/lb gap to target$-1.85
ASP/unit$28.01
Profit / lb$0.02
Current gross margin %0.8%
Minimum gross margin %18.0%
Target gross margin %24.0%
Target achievement57.5%
Price P10 / P50 / P90$2.31 / $2.60 / $2.90
Dispersion ratio1.26
Margin-risk exposure100.0%
Price-outlier revenue3.9%
Customer Reach & Planning
Penetration, repeat quality, lifecycle status, and planning confidence.
Repeat customer share34.0%
New customer share9.4%
Recent repeat revenue share38.0%
Customer cadence63.0 d
Lifecycle stageDeclining
Seasonality strength83
Forecastability25 · Low
Decision Layer
Immediate actions based on current risk, opportunity, and recent movement. Click a card to open the supporting context.
Address the primary risk
100.0% of revenue sits below the target margin threshold.
Pursue the highest-value opportunity
Fairview Market offers up to $151 of margin uplift to target.
Reset the lifecycle plan
Declining stage with 10 active months. Recent 3-month revenue is down 43.6% vs prior 3 months; customer adoption is narrowing.
Re-engage at-risk customers
Trailside Square has not bought in 107 days.
Risk & Opportunity
Top enterprise signals across concentration, pricing, seasonality, lifecycle, and planning.
Primary risks
Margin recovery needed
100.0% of revenue sits below the target margin threshold.
Seasonality risk
Seasonality strength score is 83; demand planning should follow seasonal peaks and troughs.
Forecast uncertainty
Low forecast confidence using damped_ma with 10 history points.
Top opportunities
Pricing recovery
Fairview Market offers up to $151 of margin uplift to target.
Basket expansion
DF-1171 — Frozen Vegetables Premium Label Single shows lift 4.35 with paired revenue 1,610.
Weight efficiency play
Top heavy orders drive 36.7% of shipped lb; review freight and pack economics for those accounts.
Performance Story
What changed in the last 28 days, which lever mattered most, and what to do next. Rolling 28-day diagnostics compare 2026-06-08 to 2026-07-05 against 2026-05-11 to 2026-06-07.
At risk

Last 28 days revenue moved by $216 vs the prior 28 days. The dominant driver was lb volume movement; gross profit changed by $3 and margin improved.

Recommended action: Review price execution, cadence, and at-risk customers before volume erosion deepens.
ASP/lb Effect
$35.13
LB Volume Effect
$-241.98
Mix / Interaction
$-9.36
Customer Movers
Largest 28-day revenue movers within this product’s customer base. Click a customer to inspect the change and open drilldown.
Top gainers
Top decliners

Trend, Lifecycle & Seasonality

Revenue, profit, weight, ASP/lb, lifecycle stage, and seasonal demand shape with clearer planning context.

Use this layer to separate sustained demand shifts from seasonality. Monthly charts show the active scoped history; seasonality uses the full available pattern for this SKU.
Export time series
Revenue, Profit & Shipped lb Trend
Monthly commercial outcome with weight context and rolling revenue average.
Outcome trend chart
Lifecycle & Price Quality
ASP/lb, margin quality, lifecycle stage, and planning confidence.
ASP/lb and margin trend
Lifecycle stage
Declining
Trend direction
Declining
Months active
10
Forecastability
25
Seasonality Heatmap
Year-over-year revenue intensity by month with shipped lb in hover context.
Seasonality heatmap
Seasonality Profile
Strength, best months, worst months, and normalized seasonal shape.
Seasonality profile
Seasonality strength83
Best monthsMar, Dec, Apr
Worst monthsJul, Oct, Feb
Seasonality is directional only; fewer than 12 months are available.

Weight Analytics

Weight is treated as a first-class commercial and operational signal, not a secondary diagnostic.

Use this section when the SKU matters because of shipped lb, pack economics, or heavy-account exposure. Protect high-weight strategic items even when units alone look flat.
Export weight series
Weight, Revenue/lb & Profit/lb Trend
How shipped lb and per-lb economics are moving over time, with pack intensity kept in summary diagnostics.
Weight analytics chart
Weight Summary
Operational weight profile, order concentration, and signal quality.
Revenue / lb$2.51
Profit / lb$0.02
Avg lb / customer51.1
Top heavy-order share36.7%
Top-5 customer weight share35.2%
Weight intensity change-3.9%
Order weight P10 / P50 / P9010.9 / 22.1 / 86.2
Weight and unit movement are moving together.
Top Customers by Weight
The accounts that matter most when the product is analyzed in shipped lb rather than units alone. Click a row to inspect dependence and open customer drilldown.
Export
CustomerWeight lbWeight shareRevenueASP/lbOrders
Fairview Market231.28.5%$491.16$2.122
Trailside Square220.78.2%$464.65$2.111
Lakeview Commons218.58.1%$586.58$2.683
Meadowbrook Exchange165.66.1%$361.59$2.182
Redbud Pointe116.64.3%$303.37$2.601
Silver Lake Junction97.23.6%$249.35$2.572
Sunfield Landing95.13.5%$262.88$2.762
Ridgeway Junction93.23.4%$205.20$2.201
Fairview Depot90.33.3%$220.17$2.442
Prairie View Galleria86.23.2%$205.34$2.381
Weight Relationship Diagnostics
How strongly weight ties to revenue, units, and pricing under this product’s order pattern.
Weight ↔ Revenue
0.98
Weight ↔ Units
0.99
ASP/lb ↔ Weight
-0.29
Avg lb / order
36.1
Use these diagnostics to separate volume quality from simple unit movement. If weight and units diverge, pack mix or order composition is shifting.

Pricing, Margin & Elasticity

ASP/lb-first diagnostics for distribution, demand response, margin risk, and recovery opportunity.

Use pricing diagnostics to separate broad price dispersion from specific below-target customers. Margin-risk rows rank recoverable uplift to the department-specific target inside the current scoped window.
Export pricing base
ASP/lb Distribution
Transaction-level ASP/lb with guardrails and price-outlier bounds.
ASP/lb distribution histogram
Guardrails: P10 $2.31, P50 $2.60, P90 $2.90 · Price-outlier revenue share 3.9%
Price vs Demand Relationship
Directional elasticity proxy using ASP/lb against the relevant demand basis.
Price vs demand scatter
Elasticity proxy on ASP/lb vs Shipped lb: slope -44.3171, correlation -0.294. Indicative only.
Margin at Risk by Customer
Below-target gross-margin accounts ranked by recoverable uplift and recency. Click a row to inspect the account and open customer drilldown.
Below-target customers
53
Target 24.0%
Revenue at risk
$6,779.05
Margin uplift to target
$1,573.01
CustomerRevenueWeight lbProfitMargin %Gap (pp)Uplift to TargetOrdersCadence (d)Last order
Fairview Market$491.16231.2$-33.54-6.8%30.8$151.42269May 23, 2026
Trailside Square$464.65220.7$-31.67-6.8%30.8$143.191Mar 18, 2026
Meadowbrook Exchange$361.59165.6$-25.47-7.0%31$112.26248Apr 2, 2026
Lakeview Commons$586.58218.5$33.515.7%18.3$107.273104May 23, 2026
Redbud Pointe$303.37116.6$-0.27-0.1%24.1$73.081Mar 22, 2026
Ridgeway Junction$205.293.2$-15.86-7.7%31.7$65.111Nov 5, 2025
Prairie View Galleria$205.3486.2$-15.72-7.7%31.7$651Nov 19, 2025
Silver Lake Junction$249.3597.2$-0.09-0.0%24$59.9323Jun 26, 2026
Fairview Depot$220.1790.3$-1.74-0.8%24.8$54.582150May 11, 2026
Sunfield Landing$262.8895.1$13.445.1%18.9$49.65217Dec 28, 2025
Riverbend Plaza$192.5976.7$-2.64-1.4%25.4$48.86377.5Apr 28, 2026
Vista Park Crossing$262.9178$14.325.4%18.6$48.771Dec 21, 2025
Ridgeway Pointe$204.0375.2$9.644.7%19.3$39.322100Jun 17, 2026
Brookfield Village$177.4162$10.555.9%18.1$32.022239Jun 4, 2026
Copper Ridge Market 84$109.546$-1.46-1.3%25.3$27.741Oct 17, 2025
Kingsport Square$110.5147.1$-0.44-0.4%24.4$26.971Apr 28, 2026
Fox Run Square$147.1755.5$8.695.9%18.1$26.631May 29, 2026
Riverbend Village$116.2448$3.583.1%20.9$24.32395.5Jun 19, 2026
Oakmont Center 68$115.8442.6$4.033.5%20.5$23.77257Mar 2, 2026
Summit Market$117.1645$4.53.8%20.2$23.62326Mar 6, 2026
Clearwater Market$116.8841.2$5.074.3%19.7$22.98220Jan 5, 2026
Prairie View Supercenter$117.0545.3$5.244.5%19.5$22.85210Feb 2, 2026
Vista Park Supercenter$118.0643.6$6.265.3%18.7$22.08213Jan 1, 2026
Prairie View Gateway$117.243.4$6.245.3%18.7$21.891Feb 21, 2026
Cedar Park Square$117.347.3$6.345.4%18.6$21.811Mar 11, 2026
Summit Village$86.7432$2.462.8%21.2$18.362126Mar 9, 2026
Harvest Point Pointe$87.6633.4$4.234.8%19.2$16.811Dec 26, 2025
Stonegate Exchange$87.9534.7$4.525.1%18.9$16.591Mar 6, 2026
Harvest Point Exchange$88.335$4.885.5%18.5$16.321May 29, 2026
Fox Run Exchange 75$59.2822.2$2.534.3%19.7$11.72158Jun 14, 2026
Fox Run Exchange$58.3822.4$2.474.2%19.8$11.541Dec 4, 2025
Silver Lake Town Center$58.6422.5$2.744.7%19.3$11.331Mar 9, 2026
Oakmont Exchange 109$58.6725$2.774.7%19.3$11.311Mar 19, 2026
Bayside Center$58.7122.1$2.814.8%19.2$11.281Apr 2, 2026
Riverbend Gateway$58.9619.1$3.065.2%18.8$11.091Jun 30, 2026
Ironwood Gateway$59.219.2$3.35.6%18.4$10.911Feb 26, 2026
Brookfield Galleria$61.3223.4$4.567.4%16.6$10.1524Jul 3, 2026
Cedar Park Depot$25.8411.2$-2.53-9.8%33.8$8.741Apr 11, 2026
Fox Run Commons$27.4511.4$-0.93-3.4%27.4$7.521Dec 11, 2025
Meadowbrook Gateway$28.549.9$0.170.6%23.4$6.681Oct 19, 2025

Customer Dependence & Reach

Which customers drive the product, how concentrated the mix is, and where churn risk is emerging.

This layer shows whether the SKU is broadly adopted or overly dependent on a few accounts. Concentration risk matters even when topline revenue still looks healthy.
Export customers
Top Customers
Revenue, weight, pricing, cadence, and profitability in one scanning-friendly table. Click a row to inspect dependence and open customer drilldown.
CustomerRevenueWeight lbProfitMargin %ASP/lbOrdersCadenceLast orderStatus
Lakeview Commons$586.58218.5$33.515.7%$2.683104.0 dMay 23, 2026Active
Fairview Market$491.16231.2$-33.54-6.8%$2.12269.0 dMay 23, 2026Active
Trailside Square$464.65220.7$-31.67-6.8%$2.111 dMar 18, 2026At risk
Meadowbrook Exchange$361.59165.6$-25.47-7.0%$2.18248.0 dApr 2, 2026At risk
Redbud Pointe$303.37116.6$-0.27-0.1%$2.601 dMar 22, 2026At risk
Vista Park Crossing$262.9178.0$14.325.4%$3.371 dDec 21, 2025At risk
Sunfield Landing$262.8895.1$13.445.1%$2.76217.0 dDec 28, 2025At risk
Silver Lake Junction$249.3597.2$-0.09-0.0%$2.5723.0 dJun 26, 2026Active
Fairview Depot$220.1790.3$-1.74-0.8%$2.442150.0 dMay 11, 2026Active
Prairie View Galleria$205.3486.2$-15.72-7.7%$2.381 dNov 19, 2025At risk
Ridgeway Junction$205.2093.2$-15.86-7.7%$2.201 dNov 5, 2025At risk
Ridgeway Pointe$204.0375.2$9.644.7%$2.712100.0 dJun 17, 2026Active
Riverbend Plaza$192.5976.7$-2.64-1.4%$2.51377.5 dApr 28, 2026Active
Brookfield Village$177.4162.0$10.555.9%$2.862239.0 dJun 4, 2026Active
Fox Run Square$147.1755.5$8.695.9%$2.651 dMay 29, 2026Active
Vista Park Supercenter$118.0643.6$6.265.3%$2.71213.0 dJan 1, 2026At risk
Cedar Park Square$117.3047.3$6.345.4%$2.481 dMar 11, 2026At risk
Prairie View Gateway$117.2043.4$6.245.3%$2.701 dFeb 21, 2026At risk
Summit Market$117.1645.0$4.503.8%$2.60326.0 dMar 6, 2026At risk
Prairie View Supercenter$117.0545.3$5.244.5%$2.59210.0 dFeb 2, 2026At risk
Clearwater Market$116.8841.2$5.074.3%$2.83220.0 dJan 5, 2026At risk
Riverbend Village$116.2448.0$3.583.1%$2.42395.5 dJun 19, 2026Active
Oakmont Center 68$115.8442.6$4.033.5%$2.72257.0 dMar 2, 2026At risk
Kingsport Square$110.5147.1$-0.44-0.4%$2.351 dApr 28, 2026At risk
Copper Ridge Market 84$109.5046.0$-1.46-1.3%$2.381 dOct 17, 2025At risk
Customer Concentration
Revenue, weight, and repeat structure for the current customer base.
Top 1 revenue share
8.7%
Top 5 revenue share
32.6%
Top 5 weight share
35.2%
HHI (0-10k)
369
Repeat customer share
34.0%
New customer share
9.4%
Customer Activity & Churn Risk
Active customer trend with at-risk accounts requiring follow-up.
Customer activity chart
At-risk customers
  • 107 days since last order
  • 92 days since last order
  • 103 days since last order
  • 194 days since last order
  • 187 days since last order

Basket & Cross-Sell Intelligence

Associated products, lift, support, confidence, and a lightweight suggestion workflow for commercial follow-up.

Basket metrics are evidence, not guarantees. Prioritize pairs with both lift and meaningful paired revenue, then inspect the SKU and account context before you push a bundle.
Export basket
How to use this
Support is the share of scoped orders containing the pair. Confidence is the share of this SKU’s orders that also contain the paired item. Lift compares that confidence against the paired item’s usual prevalence.
Next: Select likely pairs, inspect the associated SKU, then build a commercial suggestion list for follow-up.
Basket lift chart
Base orders: 75 · Total scoped orders: 4,184
Support is the share of scoped orders containing the pair. Confidence is the share of this product’s orders that also contain the paired item. Lift compares that confidence against the paired item’s normal prevalence.
No associated products selected.
Associated productCo-ordersSupportConfidenceLiftPaired revenue
HW-1136 — Toothpaste Northgate Select Bulk0.14%8.00%4.13$1,789.77
DF-1171 — Frozen Vegetables Premium Label Single0.14%8.00%4.35$1,610.15
GR-1227 — Pasta Everyday Basics Multipack0.14%8.00%3.85$974.76
EL-1034 — Tablet Everyday Basics 2-Pack0.12%6.67%4.04$40,629.96
GR-1221 — Canned Soup Exclusive Brand Travel Size0.12%6.67%2.91$2,528.29
HW-1182 — Cold & Flu Exclusive Brand Travel Size0.12%6.67%3.58$2,308.71
HW-1291 — Skin Care Northgate Value 2-Pack0.12%6.67%3.40$1,637.73
GR-1316 — Condiments Northgate Select Family Size0.12%6.67%3.77$920.85
HW-1072 — Toothpaste Premium Label Club Pack0.10%5.33%2.23$2,371.43
HW-1124 — Cold & Flu Premium Label Single0.10%5.33%2.75$2,246.57
TS-1234 — Building Blocks Northgate Value Club Pack0.10%5.33%2.59$1,576.03
MS-1005 — Ribeye Steak National Brand Value Bundle0.10%5.33%3.06$1,216.83
GR-1159 — Soda 12pk Northgate Select Single0.10%5.33%2.69$1,132.09
HE-1149 — Surface Cleaner Exclusive Brand Club Pack0.10%5.33%2.79$1,023.26
GR-1215 — Baby Formula Northgate Select Multipack0.10%5.33%2.59$737.54
GR-1077 — Breakfast Cereal Northgate Select Bulk0.10%5.33%2.63$602.16
GR-1051 — Coffee Premium Label Single0.10%5.33%2.37$537.85
DF-1084 — Eggs Northgate Select Family Size0.10%5.33%2.69$496.25
GR-1015 — Breakfast Cereal Northgate Value Travel Size0.10%5.33%2.56$451.64
GR-1211 — Coffee Premium Label Travel Size0.10%5.33%2.45$426.28
DF-1119 — Shredded Cheese Premium Label Bulk0.10%5.33%2.63$329.71
HK-1082 — Bed Sheet Set Northgate Value Family Size0.07%4.00%2.04$6,267.95
HW-1113 — Allergy Relief Everyday Basics 2-Pack0.07%4.00%2.09$4,215.34
HK-1214 — Bed Sheet Set Premium Label Club Pack0.07%4.00%2.26$2,596.21
EL-1063 — Tablet Premium Label Single0.07%4.00%1.99$2,563.99

Forecast & Planning

Planning view with method labeling, confidence framing, weight-aware forecast output, and sparse-history safeguards.

Forecast is advisory, not autopilot. Confidence depends on usable history, repeatability, and noise in the active scoped series.
Export forecast
Revenue & Weight Forecast
Low forecast confidence using damped_ma with 10 history points.
Method
damped_ma
History points
10
Forecastability
25
Confidence
Low
Forecast chart
Method: damped_ma · History points: 10 · Revenue sMAPE: 95.7% · Weight sMAPE: 100.2% · Forecastability: 25