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 GR-1168GR-1168 — Bottled Water National Brand 2-Pack

Bottled Water National Brand 2-Pack

Last 28 days revenue moved by $261 vs the prior 28 days. The dominant driver was lb volume movement; gross profit changed by $32 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:14:11.727640+00:00
Posture: GrowingLifecycle: DecliningClassification: VariableProtein: Grocery Target status: Materially below minimum Gross margin gates: min 18.0% · target 24.0% Meat Manager cost/lb: $3.28Effective cost/lb: $3.36Min price/lb: $5.03Target price/lb: $5.43ASP/lb: $2.91Top customer: Unknown · $172.58Lead region: Southeast · $573.81Cost coverage: 100.0%Last sold: Jul 4, 2026Data confidence: Medium
What is happening
Last 28 days revenue moved by $261 vs the prior 28 days. The dominant driver was lb volume movement; gross profit changed by $32 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
HW-1178 — Shampoo Premium Label Club Pack shows lift 4.06 with paired revenue 2,544.
Next: Click any action card, customer row, margin-risk row, basket row, or chart point to inspect context without leaving the page.
Commercial outcome
$2,417.10
Gross margin -15.5% · Contribution 0.0%
Weight & movement
830 lb
Avg 9.8 lb/order · 20.9 lb/wk
Primary risk
Margin recovery needed
100.0% of revenue sits below the target margin threshold.
Best next move
Basket expansion
HW-1178 — Shampoo Premium Label Club Pack shows lift 4.06 with paired revenue 2,544.
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$2,417.10
Gross Margin $$-373.73
Margin %-15.5%
Contribution Share0.0%
28D Revenue Δ$260.80 / 447.9%
28D Weight Δ90.7 / 451.8%
Demand & Movement
Units, shipped lb, cadence, movement efficiency, and stability.
Orders85
Customers52
Units245.0
Shipped lb829.5
Avg units / order2.88
Avg lb / order9.76
Avg lb / unit3.39
Demand stability26
Pricing & Margin
ASP/lb-first pricing view with price dispersion and margin exposure.
ASP/lb$2.91
Meat Manager cost / lb$3.28
Effective cost / lb$3.36
Minimum price / lb$5.03
Target price / lb$5.43
ASP/lb gap to minimum$-2.12
ASP/lb gap to target$-2.52
ASP/unit$9.87
Profit / lb$-0.45
Current gross margin %-15.5%
Minimum gross margin %18.0%
Target gross margin %24.0%
Target achievement53.7%
Price P10 / P50 / P90$2.68 / $2.99 / $3.27
Dispersion ratio1.22
Margin-risk exposure100.0%
Price-outlier revenue7.0%
Customer Reach & Planning
Penetration, repeat quality, lifecycle status, and planning confidence.
Repeat customer share44.2%
New customer share5.8%
Recent repeat revenue share60.9%
Customer cadence84.0 d
Lifecycle stageDeclining
Seasonality strength83
Forecastability28 · 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
HW-1178 — Shampoo Premium Label Club Pack shows lift 4.06 with paired revenue 2,544.
Reset the lifecycle plan
Declining stage with 10 active months. Recent 3-month revenue is down 47.5% vs prior 3 months; customer adoption is narrowing.
Re-engage at-risk customers
Riverbend Plaza has not bought in 60 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.
Lifecycle Declining
Declining stage with 10 active months. Recent 3-month revenue is down 47.5% vs prior 3 months; customer adoption is narrowing.
Top opportunities
Basket expansion
HW-1178 — Shampoo Premium Label Club Pack shows lift 4.06 with paired revenue 2,544.
Pricing recovery
Meadowbrook Exchange offers up to $71 of margin uplift to target.
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.
Healthy

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

Recommended action: Hold course and monitor core customers.
ASP/lb Effect
$-0.41
LB Volume Effect
$263.04
Mix / Interaction
$-1.84
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
28
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, Apr, Jun
Worst monthsJul, Jan, Nov
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.91
Profit / lb$-0.45
Avg lb / customer16.0
Top heavy-order share34.1%
Top-5 customer weight share33.8%
Weight intensity change2.3%
Order weight P10 / P50 / P903.3 / 6.5 / 20.3
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
Meadowbrook Exchange59.97.2%$142.96$2.392
Trailside Center56.26.8%$163.59$2.913
Fairview Depot55.66.7%$172.58$3.102
Fox Run Commons55.56.7%$152.92$2.752
Riverbend Plaza52.76.3%$143.91$2.733
Silver Lake Square33.64.0%$102.73$3.064
Kingsport Square27.73.3%$77.01$2.781
Silver Lake Town Center27.53.3%$81.60$2.962
Ridgeway Pointe25.63.1%$70.69$2.762
Copper Ridge Market 8425.43.1%$67.13$2.653
Weight Relationship Diagnostics
How strongly weight ties to revenue, units, and pricing under this product’s order pattern.
Weight ↔ Revenue
0.99
Weight ↔ Units
0.99
ASP/lb ↔ Weight
-0.31
Avg lb / order
9.8
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.68, P50 $2.99, P90 $3.27 · Price-outlier revenue share 7.0%
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 -11.8818, correlation -0.313. 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
52
Target 24.0%
Revenue at risk
$2,417.10
Margin uplift to target
$953.84
CustomerRevenueWeight lbProfitMargin %Gap (pp)Uplift to TargetOrdersCadence (d)Last order
Meadowbrook Exchange$142.9659.9$-36.22-25.3%49.3$70.532158Apr 2, 2026
Fairview Depot$172.5855.6$-28.79-16.7%40.7$70.212177Apr 27, 2026
Fox Run Commons$152.9255.5$-26.26-17.2%41.2$62.972110Feb 22, 2026
Riverbend Plaza$143.9152.7$-25.03-17.4%41.4$59.57322.5May 5, 2026
Trailside Center$163.5956.2$-16.44-10.1%34.1$55.71384Jun 23, 2026
Silver Lake Square$102.7333.6$-11.6-11.3%35.3$36.25481May 27, 2026
Oakmont Crossing$71.6125.1$-17.98-25.1%49.1$35.171Jan 22, 2026
Kingsport Square$77.0127.7$-13.44-17.4%41.4$31.921Jun 10, 2026
Copper Ridge Market 84$67.1325.4$-13.07-19.5%43.5$29.18321Apr 23, 2026
Silver Lake Town Center$81.627.5$-8.84-10.8%34.8$28.43259Apr 18, 2026
Westfield Village$72.2123.9$-8.84-12.2%36.2$26.17490Jun 30, 2026
Ridgeway Pointe$70.6925.6$-8.66-12.2%36.2$25.62269Apr 30, 2026
Summit Market$60.8819.7$-6.52-10.7%34.7$21.141Dec 1, 2025
Clearwater Plaza$61.3320.7$-6.08-9.9%33.9$20.81May 3, 2026
Summit Supercenter$50.3716.9$-8.5-16.9%40.9$20.58437Apr 26, 2026
Meadowbrook Commons$51.2515.6$-6.76-13.2%37.2$19.063100Apr 24, 2026
Vista Park Landing$50.8616$-6.3-12.4%36.4$18.51246Feb 10, 2026
Ironwood Gateway$51.3516.2$-5.81-11.3%35.3$18.142128Mar 31, 2026
Oakmont Exchange 109$40.6311.3$-4.59-11.3%35.3$14.341Dec 21, 2025
Stonegate Exchange$40.7713.3$-4.46-10.9%34.9$14.241Mar 2, 2026
Sunfield Landing$40.7814.8$-4.44-10.9%34.9$14.231Mar 10, 2026
Ridgeway Plaza$40.813.3$-4.42-10.8%34.8$14.221Mar 18, 2026
Fox Run Square$40.8914.2$-4.33-10.6%34.6$14.141May 6, 2026
Ridgeway Junction$26.9910$-7.14-26.4%50.4$13.611May 8, 2026
Fairview Market$27.069.6$-7.07-26.1%50.1$13.561Jul 4, 2026
Redbud Pointe$28.819.4$-6.17-21.4%45.4$13.082144Jun 10, 2026
Meadowbrook Depot$29.8510.2$-5.13-17.2%41.2$12.29250Dec 30, 2025
Harvest Point Town Center$30.279.7$-4.71-15.6%39.6$11.97262Mar 23, 2026
Cedar Park Plaza$30.310.1$-4.68-15.4%39.4$11.952204May 30, 2026
Vista Park Town Center 76$30.59.4$-4.48-14.7%38.7$11.828Jan 16, 2026
Fox Run Exchange$30.519.7$-4.47-14.6%38.6$11.79291Mar 18, 2026
Prairie View Gateway$30.629.1$-3.5-11.4%35.4$10.851Apr 5, 2026
Vista Park Supercenter$30.9410.3$-3.19-10.3%34.3$10.621Apr 9, 2026
Prairie View Galleria$187.1$-5.04-28.0%52$9.361May 15, 2026
Fairview Square$19.226.3$-4.67-24.3%48.3$9.28266Jun 3, 2026
Lakeview Supercenter$20.537.2$-3.36-16.4%40.4$8.292145Mar 13, 2026
Willow Creek Station$20.066.4$-2.98-14.8%38.8$7.791Oct 28, 2025
Sunfield Marketplace$21.217.1$-2.67-12.6%36.6$7.762195Jun 23, 2026
Granite Falls Crossing$20.427.2$-2.62-12.8%36.8$7.521Apr 4, 2026
Clearwater Marketplace$20.446.3$-2.59-12.7%36.7$7.51Oct 7, 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
Fairview Depot$172.5855.6$-28.79-16.7%$3.102177.0 dApr 27, 2026Active
Trailside Center$163.5956.2$-16.44-10.1%$2.91384.0 dJun 23, 2026Active
Fox Run Commons$152.9255.5$-26.26-17.2%$2.752110.0 dFeb 22, 2026Active
Riverbend Plaza$143.9152.7$-25.03-17.4%$2.73322.5 dMay 5, 2026At risk
Meadowbrook Exchange$142.9659.9$-36.22-25.3%$2.392158.0 dApr 2, 2026Active
Silver Lake Square$102.7333.6$-11.60-11.3%$3.06481.0 dMay 27, 2026Active
Silver Lake Town Center$81.6027.5$-8.84-10.8%$2.96259.0 dApr 18, 2026Active
Kingsport Square$77.0127.7$-13.44-17.4%$2.781 dJun 10, 2026Active
Westfield Village$72.2123.9$-8.84-12.2%$3.02490.0 dJun 30, 2026Active
Oakmont Crossing$71.6125.1$-17.98-25.1%$2.861 dJan 22, 2026At risk
Ridgeway Pointe$70.6925.6$-8.66-12.2%$2.76269.0 dApr 30, 2026Active
Copper Ridge Market 84$67.1325.4$-13.07-19.5%$2.65321.0 dApr 23, 2026At risk
Clearwater Plaza$61.3320.7$-6.08-9.9%$2.961 dMay 3, 2026At risk
Summit Market$60.8819.7$-6.52-10.7%$3.091 dDec 1, 2025At risk
Ironwood Gateway$51.3516.2$-5.81-11.3%$3.172128.0 dMar 31, 2026Active
Meadowbrook Commons$51.2515.6$-6.76-13.2%$3.283100.0 dApr 24, 2026Active
Vista Park Landing$50.8616.0$-6.30-12.4%$3.17246.0 dFeb 10, 2026At risk
Summit Supercenter$50.3716.9$-8.50-16.9%$2.98437.0 dApr 26, 2026At risk
Fox Run Square$40.8914.2$-4.33-10.6%$2.891 dMay 6, 2026At risk
Ridgeway Plaza$40.8013.3$-4.42-10.8%$3.061 dMar 18, 2026At risk
Sunfield Landing$40.7814.8$-4.44-10.9%$2.761 dMar 10, 2026At risk
Stonegate Exchange$40.7713.3$-4.46-10.9%$3.061 dMar 2, 2026At risk
Oakmont Exchange 109$40.6311.3$-4.59-11.3%$3.591 dDec 21, 2025At risk
Vista Park Supercenter$30.9410.3$-3.19-10.3%$3.011 dApr 9, 2026At risk
Prairie View Gateway$30.629.1$-3.50-11.4%$3.381 dApr 5, 2026At risk
Customer Concentration
Revenue, weight, and repeat structure for the current customer base.
Top 1 revenue share
7.1%
Top 5 revenue share
32.1%
Top 5 weight share
33.8%
HHI (0-10k)
348
Repeat customer share
44.2%
New customer share
5.8%
Customer Activity & Churn Risk
Active customer trend with at-risk accounts requiring follow-up.
Customer activity chart
At-risk customers
  • 60 days since last order
  • 163 days since last order
  • 72 days since last order
  • 62 days since last order
  • 215 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: 85 · 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-1178 — Shampoo Premium Label Club Pack0.19%9.41%4.06$2,544.05
HE-1032 — Air Freshener Exclusive Brand Club Pack0.17%8.24%3.63$1,638.50
GR-1025 — Snack Crackers Exclusive Brand Travel Size0.14%7.06%3.32$1,556.62
FP-1126 — Potatoes Everyday Basics Club Pack0.14%7.06%3.60$595.86
DF-1170 — Frozen Vegetables National Brand Family Size0.12%5.88%2.54$1,074.36
GR-1250 — Condiments National Brand Multipack0.12%5.88%2.80$830.76
GR-1120 — Canned Soup Exclusive Brand Bulk0.12%5.88%2.86$796.45
GR-1167 — Soda 12pk Northgate Select Club Pack0.12%5.88%3.16$754.20
GR-1253 — Breakfast Cereal Exclusive Brand Multipack0.12%5.88%3.04$744.95
GR-1073 — Snack Crackers Northgate Value Single0.12%5.88%3.00$276.28
GR-1210 — Canned Soup Everyday Basics Value Bundle0.12%5.88%3.47$128.75
EL-1277 — Bluetooth Headphones Northgate Value 2-Pack0.10%4.71%2.26$15,603.96
HW-1148 — Razors Everyday Basics Travel Size0.10%4.71%2.37$2,121.09
HE-1300 — Dish Soap Premium Label Family Size0.10%4.71%2.49$1,614.67
HW-1292 — Vitamins Northgate Select Travel Size0.10%4.71%2.66$1,429.82
GR-1280 — Baking Mix Premium Label Value Bundle0.10%4.71%2.46$1,235.07
GR-1233 — Soda 12pk Exclusive Brand 2-Pack0.10%4.71%2.19$1,192.26
HW-1131 — First Aid Exclusive Brand Club Pack0.10%4.71%3.08$1,169.43
HW-1072 — Toothpaste Premium Label Club Pack0.10%4.71%1.97$1,105.15
HW-1206 — Vitamins National Brand Club Pack0.10%4.71%2.32$952.94
GR-1274 — Baking Mix Northgate Value Bulk0.10%4.71%2.34$904.19
GR-1316 — Condiments Northgate Select Family Size0.10%4.71%2.66$822.48
GR-1203 — Condiments National Brand Multipack0.10%4.71%2.46$807.65
DF-1055 — Frozen Vegetables Premium Label Travel Size0.10%4.71%2.29$742.82
GR-1077 — Breakfast Cereal Northgate Select Bulk0.10%4.71%2.32$637.89

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
28
Confidence
Low
Forecast chart
Method: damped_ma · History points: 10 · Revenue sMAPE: 84.5% · Weight sMAPE: 84.5% · Forecastability: 28