Retail Market Command Center

Family Market · this month
SAMPLE DATA
Sales (MTD)
$128.4K
▲ 8%
Gross margin
34%
▲ 1 pt
Shrink (produce)
4.0%
▲ 0.8 pt
Avg basket
$24.10
— flat
Transactions
5,320
▲ 6%
Below reorder
6
SKUs
8-week performance

Sales & gross margin

Weekly sales (left, $K) vs. gross margin (right, %)
What's selling

Top categories by revenue

This month

Sales mix by department

Share of revenue
Where money leaks & when it's busy

Shrink by category

Inventory loss · dashed line = 2.5% target

Sales by day of week

Where to staff up

🤖 Insights

  • Sales up 8% and margin holding at 34% — healthy momentum.
  • Produce shrink hit 4.0%, well above the 2.5% target (≈$1.2K lost).
  • Fri–Sat drive 41% of weekly sales; 6 SKUs are below reorder.

✅ Recommended actions

  • Re-quote the produce supplier; tighten leafy-greens ordering.
  • Restock the 6 below-reorder SKUs before the weekend rush.
  • Add weekend floor staff to match the Fri–Sat peak.

🗄️ Data sources

  • POS — sales by item, department & hour
  • Inventory counts — on-hand stock & shrink
  • Supplier invoices — cost of goods

📐 Definitions & methodology

  • Shrink % = (expected − counted) ÷ expected inventory
  • Gross margin = (sales − COGS) ÷ sales
  • Avg basket = total sales ÷ transactions
Built by Advanced Timing Co. · advancedtiming.ai · Sample data for demonstration.