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 FP-1271FP-1271 — Bananas Northgate Select Travel Size

Bananas Northgate Select Travel Size

Last 28 days revenue moved by $247 vs the prior 28 days. The dominant driver was lb volume movement; gross profit changed by $24 and margin compressed.
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:28:19.181856+00:00
Posture: GrowingLifecycle: DecliningClassification: VariableProtein: Fresh & Produce Target status: Materially below minimum Gross margin gates: min 26.0% · target 33.0% Meat Manager cost/lb: $2.23Effective cost/lb: $2.26Min price/lb: $4.16Target price/lb: $4.60ASP/lb: $1.97Top customer: Unknown · $345.78Lead region: Midwest · $870.48Cost coverage: 100.0%Last sold: Jul 3, 2026Data confidence: Medium
What is happening
Last 28 days revenue moved by $247 vs the prior 28 days. The dominant driver was lb volume movement; gross profit changed by $24 and margin compressed.
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
Cedar Park Depot offers up to $157 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
$3,346.67
Gross margin -14.6% · Contribution 0.0%
Weight & movement
1,695 lb
Avg 25.3 lb/order · 42.7 lb/wk
Primary risk
Margin recovery needed
100.0% of revenue sits below the target margin threshold.
Best next move
Pricing recovery
Cedar Park Depot offers up to $157 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$3,346.67
Gross Margin $$-487.81
Margin %-14.6%
Contribution Share0.0%
28D Revenue Δ$246.55 / 123.6%
28D Weight Δ119.4 / 129.0%
Demand & Movement
Units, shipped lb, cadence, movement efficiency, and stability.
Orders67
Customers47
Units211.0
Shipped lb1,694.8
Avg units / order3.15
Avg lb / order25.30
Avg lb / unit8.03
Demand stability28
Pricing & Margin
ASP/lb-first pricing view with price dispersion and margin exposure.
ASP/lb$1.97
Meat Manager cost / lb$2.23
Effective cost / lb$2.26
Minimum price / lb$4.16
Target price / lb$4.60
ASP/lb gap to minimum$-2.19
ASP/lb gap to target$-2.62
ASP/unit$15.86
Profit / lb$-0.29
Current gross margin %-14.6%
Minimum gross margin %26.0%
Target gross margin %33.0%
Target achievement43.0%
Price P10 / P50 / P90$1.81 / $2.06 / $2.21
Dispersion ratio1.22
Margin-risk exposure100.0%
Price-outlier revenue2.8%
Customer Reach & Planning
Penetration, repeat quality, lifecycle status, and planning confidence.
Repeat customer share38.3%
New customer share2.1%
Recent repeat revenue share90.0%
Customer cadence71.5 d
Lifecycle stageDeclining
Seasonality strength83
Forecastability26 · 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
Cedar Park Depot offers up to $157 of margin uplift to target.
Reset the lifecycle plan
Declining stage with 10 active months. Recent 3-month revenue is down 46.3% vs prior 3 months; customer adoption is narrowing.
Re-engage at-risk customers
Cedar Park Depot has not bought in 105 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
Cedar Park Depot offers up to $157 of margin uplift to target.
Basket expansion
HK-1135 — Bed Sheet Set Northgate Select Value Bundle shows lift 4.73 with paired revenue 3,875.
Weight efficiency play
Top heavy orders drive 36.0% 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.
Mixed

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

Recommended action: Hold course and monitor core customers.
ASP/lb Effect
$-4.69
LB Volume Effect
$257.29
Mix / Interaction
$-6.05
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
26
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, Oct, Jan
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$1.97
Profit / lb$-0.29
Avg lb / customer36.1
Top heavy-order share36.0%
Top-5 customer weight share34.0%
Weight intensity change2.1%
Order weight P10 / P50 / P907.5 / 9.0 / 64.7
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
Prairie View Supercenter160.39.5%$345.78$2.163
Cedar Park Depot152.49.0%$275.25$1.811
Prairie View Galleria98.75.8%$188.52$1.911
Fox Run Commons84.85.0%$170.53$2.012
Fairview Market80.14.7%$144.83$1.811
Copper Ridge Market 8478.24.6%$139.64$1.792
Ridgeway Galleria74.94.4%$165.00$2.202
Maple Grove Exchange73.84.4%$148.74$2.022
Prairie View Gateway64.33.8%$131.50$2.051
Silver Lake Square63.03.7%$132.18$2.102
Weight Relationship Diagnostics
How strongly weight ties to revenue, units, and pricing under this product’s order pattern.
Weight ↔ Revenue
0.99
Weight ↔ Units
1.00
ASP/lb ↔ Weight
-0.37
Avg lb / order
25.3
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 $1.81, P50 $2.06, P90 $2.21 · Price-outlier revenue share 2.8%
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 -72.0979, correlation -0.372. 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
47
Target 33.0%
Revenue at risk
$3,346.67
Margin uplift to target
$1,590.51
CustomerRevenueWeight lbProfitMargin %Gap (pp)Uplift to TargetOrdersCadence (d)Last order
Cedar Park Depot$275.25152.4$-65.76-23.9%56.9$156.591Mar 20, 2026
Prairie View Supercenter$345.78160.3$-32.73-9.5%42.5$146.843103Jun 16, 2026
Prairie View Galleria$188.5298.7$-45.07-23.9%56.9$107.281Apr 10, 2026
Fox Run Commons$170.5384.8$-28.11-16.5%49.5$84.3827Apr 28, 2026
Fairview Market$144.8380.1$-35.05-24.2%57.2$82.851Mar 14, 2026
Ridgeway Galleria$165.0174.9$-15.72-9.5%42.5$70.18228May 16, 2026
Copper Ridge Market 84$139.6478.2$-23.19-16.6%49.6$69.27255Jul 3, 2026
Maple Grove Exchange$148.7473.8$-14.09-9.5%42.5$63.17271Jun 10, 2026
Silver Lake Square$132.1863$-12.74-9.6%42.6$56.36219Nov 16, 2025
Prairie View Gateway$131.564.3$-12.58-9.6%42.6$55.971Feb 16, 2026
Redbud Pointe$108.2859.6$-18.74-17.3%50.3$54.47268Mar 31, 2026
Maple Grove Landing$114.6658.4$-12.36-10.8%43.8$50.2277Dec 17, 2025
Riverbend Plaza$93.0656.3$-15.2-16.3%49.3$45.911May 8, 2026
Fox Run Exchange$98.6652$-9.61-9.7%42.7$42.171Feb 23, 2026
Ridgeway Plaza$82.0842.9$-9.13-11.1%44.1$36.22260Mar 10, 2026
Stonegate Exchange$82.1739.9$-8.19-10.0%43$35.311Feb 13, 2026
Meadowbrook Exchange$57.6531.3$-14.82-25.7%58.7$33.841Dec 1, 2025
Lakeview Plaza$66.1733.3$-7.14-10.8%43.8$28.982162Jul 3, 2026
Highland Galleria$66.731.7$-6.61-9.9%42.9$28.62272Jun 6, 2026
Ridgeway Junction$43.4725.4$-11.09-25.5%58.5$25.441Mar 23, 2026
Meadowbrook Commons$49.7424$-6.52-13.1%46.1$22.94326Feb 5, 2026
Summit Supercenter$48.723.1$-6.71-13.8%46.8$22.782118Feb 6, 2026
Clearwater Plaza$49.5924.3$-4.97-10.0%43$21.331Jun 15, 2026
Trailside Depot$49.8423.2$-4.72-9.5%42.5$21.171Mar 2, 2026
Highland Center$30.9115.4$-6.6-21.3%54.3$16.8226Mar 5, 2026
Meadowbrook Depot$32.0915.9$-5.42-16.9%49.9$16.01275Dec 30, 2025
Vista Park Supercenter$33.2216.9$-4.28-12.9%45.9$15.252167May 23, 2026
Willow Creek Station$32.6515.6$-4.01-12.3%45.3$14.781Apr 24, 2026
Vista Park Crossing$32.7415.3$-3.92-12.0%45$14.721Nov 21, 2025
Granite Falls Crossing$32.7915.8$-3.86-11.8%44.8$14.681Dec 27, 2025
Sunfield Landing$32.9116.8$-3.75-11.4%44.4$14.611Mar 11, 2026
Ridgeway Square$34.1915.2$-3.32-9.7%42.7$14.62167May 10, 2026
Sunfield Marketplace$34.2316$-3.28-9.6%42.6$14.572186Jun 14, 2026
Silver Lake Junction$15.397.4$-3.36-21.9%54.9$8.441Nov 24, 2025
Copper Ridge Market$16.098.1$-2.66-16.6%49.6$7.971Jan 21, 2026
Meadowbrook Gateway$16.158.7$-2.61-16.1%49.1$7.931Apr 8, 2026
Ridgeway Pointe$16.249$-2.51-15.5%48.5$7.871Jan 7, 2026
Harvest Point Town Center$16.37.7$-2.45-15.0%48$7.831Mar 23, 2026
Fairview Crossing$16.527.6$-2.23-13.5%46.5$7.681Nov 6, 2025
Fox Run Exchange 75$16.587.5$-2.17-13.1%46.1$7.641Jan 19, 2026

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
Prairie View Supercenter$345.78160.3$-32.73-9.5%$2.163103.0 dJun 16, 2026Active
Cedar Park Depot$275.25152.4$-65.76-23.9%$1.811 dMar 20, 2026At risk
Prairie View Galleria$188.5298.7$-45.07-23.9%$1.911 dApr 10, 2026At risk
Fox Run Commons$170.5384.8$-28.11-16.5%$2.0127.0 dApr 28, 2026At risk
Ridgeway Galleria$165.0074.9$-15.72-9.5%$2.20228.0 dMay 16, 2026At risk
Maple Grove Exchange$148.7473.8$-14.09-9.5%$2.02271.0 dJun 10, 2026Active
Fairview Market$144.8380.1$-35.05-24.2%$1.811 dMar 14, 2026At risk
Copper Ridge Market 84$139.6478.2$-23.19-16.6%$1.79255.0 dJul 3, 2026Active
Silver Lake Square$132.1863.0$-12.74-9.6%$2.10219.0 dNov 16, 2025At risk
Prairie View Gateway$131.5064.3$-12.58-9.6%$2.051 dFeb 16, 2026At risk
Maple Grove Landing$114.6658.4$-12.36-10.8%$1.96277.0 dDec 17, 2025At risk
Redbud Pointe$108.2859.6$-18.74-17.3%$1.82268.0 dMar 31, 2026Active
Fox Run Exchange$98.6652.0$-9.61-9.7%$1.901 dFeb 23, 2026At risk
Riverbend Plaza$93.0656.3$-15.20-16.3%$1.651 dMay 8, 2026At risk
Stonegate Exchange$82.1739.9$-8.19-10.0%$2.061 dFeb 13, 2026At risk
Ridgeway Plaza$82.0842.9$-9.13-11.1%$1.92260.0 dMar 10, 2026At risk
Highland Galleria$66.7031.7$-6.61-9.9%$2.10272.0 dJun 6, 2026Active
Lakeview Plaza$66.1733.3$-7.14-10.8%$1.992162.0 dJul 3, 2026Active
Meadowbrook Exchange$57.6531.3$-14.82-25.7%$1.841 dDec 1, 2025At risk
Trailside Depot$49.8423.2$-4.72-9.5%$2.151 dMar 2, 2026At risk
Meadowbrook Commons$49.7424.0$-6.52-13.1%$2.07326.0 dFeb 5, 2026At risk
Clearwater Plaza$49.5924.3$-4.97-10.0%$2.041 dJun 15, 2026Active
Summit Supercenter$48.7023.1$-6.71-13.8%$2.112118.0 dFeb 6, 2026Active
Ridgeway Junction$43.4725.4$-11.09-25.5%$1.711 dMar 23, 2026At risk
Sunfield Marketplace$34.2316.0$-3.28-9.6%$2.142186.0 dJun 14, 2026Active
Customer Concentration
Revenue, weight, and repeat structure for the current customer base.
Top 1 revenue share
10.3%
Top 5 revenue share
34.2%
Top 5 weight share
34.0%
HHI (0-10k)
427
Repeat customer share
38.3%
New customer share
2.1%
Customer Activity & Churn Risk
Active customer trend with at-risk accounts requiring follow-up.
Customer activity chart
At-risk customers
  • 105 days since last order
  • 84 days since last order
  • 66 days since last order
  • 48 days since last order
  • 111 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: 67 · 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
AP-1070 — Mens Tee Exclusive Brand Family Size0.14%8.96%4.68$3,840.18
GR-1255 — Coffee Premium Label Travel Size0.14%8.96%4.57$734.86
FP-1130 — Fresh Herbs National Brand Value Bundle0.14%8.96%4.68$727.14
AP-1160 — Kids Hoodie Exclusive Brand Travel Size0.12%7.46%3.90$6,405.78
HW-1103 — Allergy Relief National Brand Value Bundle0.12%7.46%3.22$5,018.86
HK-1135 — Bed Sheet Set Northgate Select Value Bundle0.12%7.46%4.73$3,875.44
GR-1303 — Soda 12pk Premium Label Single0.12%7.46%3.67$584.63
FP-1245 — Avocados Premium Label Travel Size0.12%7.46%4.22$492.83
HK-1195 — Table Lamp Exclusive Brand 2-Pack0.10%5.97%3.52$2,869.13
HK-1066 — Cookware Set Premium Label Single0.10%5.97%2.87$1,578.85
MS-1057 — Salmon Fillet National Brand Single0.10%5.97%2.58$1,128.84
HE-1158 — Bath Tissue Northgate Select Single0.10%5.97%2.81$598.07
GR-1250 — Condiments National Brand Multipack0.10%5.97%2.84$497.58
FP-1275 — Tomatoes Everyday Basics Value Bundle0.10%5.97%2.69$458.68
FP-1279 — Onions Exclusive Brand Club Pack0.10%5.97%3.62$424.09
FP-1266 — Onions National Brand Club Pack0.10%5.97%3.47$416.68
DF-1169 — Frozen Pizza Everyday Basics Travel Size0.10%5.97%3.16$264.12
FP-1122 — Apples Premium Label 2-Pack0.10%5.97%3.08$242.86
DF-1068 — Butter Premium Label Bulk0.10%5.97%3.01$141.88
GR-1168 — Bottled Water National Brand 2-Pack0.10%5.97%2.94$60.75
HK-1204 — Storage Bin Exclusive Brand Multipack0.07%4.48%2.23$14,504.89
HE-1152 — Paper Towels Everyday Basics Travel Size0.07%4.48%2.88$2,203.91
MS-1269 — Ribeye Steak Everyday Basics 2-Pack0.07%4.48%2.53$2,063.07
HW-1148 — Razors Everyday Basics Travel Size0.07%4.48%2.26$1,649.67
HW-1141 — Skin Care Everyday Basics Multipack0.07%4.48%1.93$1,540.05

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