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 HK-1195HK-1195 — Table Lamp Exclusive Brand 2-Pack

Table Lamp Exclusive Brand 2-Pack

Last 28 days revenue moved by $4,031 vs the prior 28 days. The dominant driver was lb volume movement; gross profit changed by $706 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:17:53.563263+00:00
Posture: GrowingLifecycle: MatureClassification: VariableProtein: Home & Kitchen Target status: Materially below minimum Gross margin gates: min 30.0% · target 38.0% Meat Manager cost/lb: $20.01Effective cost/lb: $20.03Min price/lb: $29.80Target price/lb: $33.65ASP/lb: $17.94Top customer: Unknown · $4,326.38Lead region: Texas & Gulf · $12,661.47Cost coverage: 100.0%Last sold: Jun 25, 2026Data confidence: Medium
What is happening
Last 28 days revenue moved by $4,031 vs the prior 28 days. The dominant driver was lb volume movement; gross profit changed by $706 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
Summit Market offers up to $2,056 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
$51,162.68
Gross margin -11.7% · Contribution 0.6%
Weight & movement
2,853 lb
Avg 40.2 lb/order · 71.8 lb/wk
Primary risk
Margin recovery needed
100.0% of revenue sits below the target margin threshold.
Best next move
Pricing recovery
Summit Market offers up to $2,056 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$51,162.68
Gross Margin $$-5,986.16
Margin %-11.7%
Contribution Share0.6%
28D Revenue Δ$4,030.68 / 169.7%
28D Weight Δ217.3 / 169.2%
Demand & Movement
Units, shipped lb, cadence, movement efficiency, and stability.
Orders71
Customers44
Units217.0
Shipped lb2,852.6
Avg units / order3.06
Avg lb / order40.18
Avg lb / unit13.15
Demand stability0
Pricing & Margin
ASP/lb-first pricing view with price dispersion and margin exposure.
ASP/lb$17.94
Meat Manager cost / lb$20.01
Effective cost / lb$20.03
Minimum price / lb$29.80
Target price / lb$33.65
ASP/lb gap to minimum$-11.87
ASP/lb gap to target$-15.71
ASP/unit$235.77
Profit / lb$-2.10
Current gross margin %-11.7%
Minimum gross margin %30.0%
Target gross margin %38.0%
Target achievement53.3%
Price P10 / P50 / P90$16.57 / $18.29 / $20.06
Dispersion ratio1.21
Margin-risk exposure100.0%
Price-outlier revenue1.9%
Customer Reach & Planning
Penetration, repeat quality, lifecycle status, and planning confidence.
Repeat customer share43.2%
New customer share9.1%
Recent repeat revenue share20.1%
Customer cadence68.0 d
Lifecycle stageMature
Seasonality strength74
Forecastability29 · 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
Summit Market offers up to $2,056 of margin uplift to target.
Use the latest 28-day readout
Last 28 days revenue moved by $4,031 vs the prior 28 days. The dominant driver was lb volume movement; gross profit changed by $706 and margin compressed.
Re-engage at-risk customers
Summit Market has not bought in 202 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 74; demand planning should follow seasonal peaks and troughs.
Forecast uncertainty
Low forecast confidence using damped_ma with 9 history points.
Top opportunities
Pricing recovery
Summit Market offers up to $2,056 of margin uplift to target.
Basket expansion
HW-1177 — Toothpaste Exclusive Brand Bulk shows lift 4.83 with paired revenue 2,140.
Weight efficiency play
Top heavy orders drive 37.9% 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 $4,031 vs the prior 28 days. The dominant driver was lb volume movement; gross profit changed by $706 and margin compressed.

Recommended action: Hold course and monitor core customers.
ASP/lb Effect
$3.90
LB Volume Effect
$4,020.17
Mix / Interaction
$6.61
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
Mature
Trend direction
Growing
Months active
9
Forecastability
29
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 strength74
Best monthsMay, Oct, Nov
Worst monthsApr, Mar, 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$17.94
Profit / lb$-2.10
Avg lb / customer64.8
Top heavy-order share37.9%
Top-5 customer weight share36.3%
Weight intensity change-2.8%
Order weight P10 / P50 / P9012.5 / 26.3 / 90.4
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
Summit Market262.09.2%$4,326.38$16.523
Maple Grove Landing216.67.6%$3,879.23$17.911
Prairie View Gateway195.86.9%$3,616.33$18.472
Copper Ridge Market 84183.16.4%$3,174.14$17.343
Cedar Park Depot177.16.2%$2,993.40$16.901
Ridgeway Junction163.35.7%$2,550.18$15.621
Fox Run Exchange121.24.2%$2,420.66$19.974
Lakeview Village109.63.8%$2,166.08$19.762
Riverbend Station84.12.9%$1,685.60$20.042
Ridgeway Plaza71.32.5%$1,205.51$16.922
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.30
Avg lb / order
40.2
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 $16.57, P50 $18.29, P90 $20.06 · Price-outlier revenue share 1.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 -8.3579, correlation -0.298. 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
44
Target 38.0%
Revenue at risk
$51,162.68
Margin uplift to target
$25,427.13
CustomerRevenueWeight lbProfitMargin %Gap (pp)Uplift to TargetOrdersCadence (d)Last order
Summit Market$4,326.38262$-411.62-9.5%47.5$2,055.64330Dec 5, 2025
Cedar Park Depot$2,993.4177.1$-690.57-23.1%61.1$1,828.071Jun 20, 2026
Maple Grove Landing$3,879.23216.6$-330.91-8.5%46.5$1,805.021May 6, 2026
Copper Ridge Market 84$3,174.14183.1$-511.54-16.1%54.1$1,717.71377.5May 9, 2026
Prairie View Gateway$3,616.33195.8$-331.58-9.2%47.2$1,705.792157May 3, 2026
Ridgeway Junction$2,550.18163.3$-607.64-23.8%61.8$1,576.711Feb 12, 2026
Fox Run Exchange$2,420.66121.2$-213.54-8.8%46.8$1,133.4468Jun 13, 2026
Lakeview Village$2,166.08109.6$-203.34-9.4%47.4$1,026.45264Jan 29, 2026
Riverbend Station$1,685.684.1$-157.67-9.4%47.4$798.192118Mar 25, 2026
Riverbend Plaza$1,131.2866.5$-184.97-16.4%54.4$614.861Dec 5, 2025
Ridgeway Plaza$1,205.5171.3$-111.6-9.3%47.3$569.692150Mar 10, 2026
Oakmont Crossing$845.5549.6$-207.62-24.6%62.6$528.931Oct 24, 2025
Fairview Square$912.8348.7$-140.34-15.4%53.4$487.221Jun 3, 2026
Summit Supercenter$953.355.2$-99.87-10.5%48.5$462.131Dec 8, 2025
Cedar Park Plaza$958.4353.5$-95.59-10.0%48$459.82203May 20, 2026
Clearwater Market$960.3948.8$-92.78-9.7%47.7$457.731Oct 14, 2025
Harvest Point Exchange$963.7450.2$-90.29-9.4%47.4$456.512117Feb 22, 2026
Vista Park Crossing$966.3451.3$-87.68-9.1%47.1$454.89216Feb 28, 2026
Clearwater Marketplace$972.6954.1$-82.19-8.4%46.4$451.813113May 23, 2026
Prairie View Supercenter$971.742$-81.47-8.4%46.4$450.721Jun 16, 2026
Stonegate Exchange$971.7952.3$-81.38-8.4%46.4$450.661Jun 18, 2026
Trailside Depot$977.4152$-76.62-7.8%45.8$448.03240Apr 11, 2026
Brookfield Galleria$1,006.0449.8$-49.68-4.9%42.9$431.98442Jun 25, 2026
Fairview Depot$681.0842.2$-109.01-16.0%54$367.821Feb 14, 2026
Fox Run Commons$681.3440$-108.75-16.0%54$367.661Feb 22, 2026
Harvest Point Town Center$712.7545.6$-77.35-10.9%48.9$348.191Oct 4, 2025
Oakmont Center 68$720.0138.9$-70.08-9.7%47.7$343.681May 4, 2026
Clearwater Plaza$726.5240.8$-63.57-8.7%46.7$339.651Apr 12, 2026
Fairview Crossing$729.5143$-61.43-8.4%46.4$338.64292Feb 10, 2026
Vista Park Supercenter$730.2942.2$-60.65-8.3%46.3$338.16278Jan 28, 2026
Fox Run Exchange 75$731.5438.8$-59.4-8.1%46.1$337.39217Feb 18, 2026
Silver Lake Square$734.9639.2$-56.84-7.7%45.7$336.12325Jun 9, 2026
Highland Center$453.7525.5$-73.26-16.1%54.1$245.691Jan 31, 2026
Clearwater Square$477.5428$-49.47-10.4%48.4$230.941Jan 16, 2026
Ironwood Gateway$484.8124.1$-42.2-8.7%46.7$226.431Oct 6, 2025
Oakmont Exchange$486.1227.2$-40.9-8.4%46.4$225.621Dec 1, 2025
Lakeview Supercenter$488.9127.1$-38.95-8.0%46$224.73244Apr 22, 2026
Sunfield Marketplace$500.9626.5$-26.9-5.4%43.4$217.26256Jan 15, 2026
Riverbend Village$239.0712.7$-24.86-10.4%48.4$115.711Feb 11, 2026
Silver Lake Town Center$240.1312.6$-23.8-9.9%47.9$115.051Oct 17, 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
Summit Market$4,326.38262.0$-411.62-9.5%$16.52330.0 dDec 5, 2025At risk
Maple Grove Landing$3,879.23216.6$-330.91-8.5%$17.911 dMay 6, 2026At risk
Prairie View Gateway$3,616.33195.8$-331.58-9.2%$18.472157.0 dMay 3, 2026Active
Copper Ridge Market 84$3,174.14183.1$-511.54-16.1%$17.34377.5 dMay 9, 2026Active
Cedar Park Depot$2,993.40177.1$-690.57-23.1%$16.901 dJun 20, 2026Active
Ridgeway Junction$2,550.18163.3$-607.64-23.8%$15.621 dFeb 12, 2026At risk
Fox Run Exchange$2,420.66121.2$-213.54-8.8%$19.97468.0 dJun 13, 2026Active
Lakeview Village$2,166.08109.6$-203.34-9.4%$19.76264.0 dJan 29, 2026At risk
Riverbend Station$1,685.6084.1$-157.67-9.4%$20.042118.0 dMar 25, 2026Active
Ridgeway Plaza$1,205.5171.3$-111.60-9.3%$16.922150.0 dMar 10, 2026Active
Riverbend Plaza$1,131.2866.5$-184.97-16.4%$17.021 dDec 5, 2025At risk
Brookfield Galleria$1,006.0449.8$-49.68-4.9%$20.19442.0 dJun 25, 2026Active
Trailside Depot$977.4152.0$-76.62-7.8%$18.81240.0 dApr 11, 2026At risk
Clearwater Marketplace$972.6954.1$-82.19-8.4%$17.983113.0 dMay 23, 2026Active
Stonegate Exchange$971.7952.3$-81.38-8.4%$18.591 dJun 18, 2026Active
Prairie View Supercenter$971.7042.0$-81.47-8.4%$23.121 dJun 16, 2026Active
Vista Park Crossing$966.3451.3$-87.68-9.1%$18.83216.0 dFeb 28, 2026At risk
Harvest Point Exchange$963.7450.2$-90.29-9.4%$19.222117.0 dFeb 22, 2026Active
Clearwater Market$960.3948.8$-92.78-9.7%$19.681 dOct 14, 2025At risk
Cedar Park Plaza$958.4353.5$-95.59-10.0%$17.912203.0 dMay 20, 2026Active
Summit Supercenter$953.3055.2$-99.87-10.5%$17.261 dDec 8, 2025At risk
Fairview Square$912.8348.7$-140.34-15.4%$18.741 dJun 3, 2026Active
Oakmont Crossing$845.5549.6$-207.62-24.6%$17.041 dOct 24, 2025At risk
Silver Lake Square$734.9639.2$-56.84-7.7%$18.75325.0 dJun 9, 2026Active
Fox Run Exchange 75$731.5438.8$-59.40-8.1%$18.84217.0 dFeb 18, 2026At risk
Customer Concentration
Revenue, weight, and repeat structure for the current customer base.
Top 1 revenue share
8.5%
Top 5 revenue share
35.2%
Top 5 weight share
36.3%
HHI (0-10k)
404
Repeat customer share
43.2%
New customer share
9.1%
Customer Activity & Churn Risk
Active customer trend with at-risk accounts requiring follow-up.
Customer activity chart
At-risk customers
  • 202 days since last order
  • 50 days since last order
  • 133 days since last order
  • 147 days since last order
  • 202 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: 71 · 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
GR-1250 — Condiments National Brand Multipack0.14%8.45%4.02$856.45
HW-1177 — Toothpaste Exclusive Brand Bulk0.12%7.04%4.83$2,139.64
GR-1012 — Baby Formula National Brand Single0.12%7.04%3.59$898.79
GR-1200 — Baby Formula Everyday Basics Club Pack0.12%7.04%3.43$893.09
DF-1080 — Butter Northgate Select Single0.12%7.04%3.35$296.94
HK-1313 — Coffee Maker Premium Label Club Pack0.10%5.63%2.81$4,028.55
MS-1038 — Salmon Fillet Premium Label Travel Size0.10%5.63%2.74$1,116.05
HW-1106 — Pain Relief Northgate Value Single0.10%5.63%2.71$1,108.01
GR-1221 — Canned Soup Exclusive Brand Travel Size0.10%5.63%2.46$800.00
MS-1110 — Bacon Northgate Select Club Pack0.10%5.63%3.47$574.47
FP-1271 — Bananas Northgate Select Travel Size0.10%5.63%3.52$339.17
GR-1042 — Soda 12pk Everyday Basics Club Pack0.10%5.63%2.62$335.35
GR-1051 — Coffee Premium Label Single0.10%5.63%2.51$317.39
GR-1078 — Condiments Exclusive Brand Club Pack0.10%5.63%3.19$238.21
GR-1031 — Baking Mix Northgate Select 2-Pack0.10%5.63%3.27$220.04
EL-1151 — Streaming Stick Premium Label Multipack0.07%4.23%2.16$13,006.10
EL-1034 — Tablet Everyday Basics 2-Pack0.07%4.23%2.56$7,024.57
HW-1191 — First Aid Northgate Value Family Size0.07%4.23%3.21$4,123.79
HK-1231 — Cookware Set Northgate Value 2-Pack0.07%4.23%2.08$3,820.71
MS-1128 — Bacon Northgate Select Multipack0.07%4.23%1.92$2,985.03
TS-1197 — Ride-On Toy National Brand Multipack0.07%4.23%2.24$2,761.66
MS-1010 — Shrimp Northgate Select Single0.07%4.23%1.84$2,495.72
HW-1287 — Vitamins National Brand Travel Size0.07%4.23%1.90$2,333.68
AP-1160 — Kids Hoodie Exclusive Brand Travel Size0.07%4.23%2.21$2,297.32
AP-1189 — Sleepwear Set Northgate Value Travel Size0.07%4.23%2.10$1,978.61

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 9 history points.
Method
damped_ma
History points
9
Forecastability
29
Confidence
Low
Forecast chart
Method: damped_ma · History points: 9 · Revenue sMAPE: 78.1% · Weight sMAPE: 74.4% · Forecastability: 29