Loss-making SKUs
5
−$2.1K drag
From revenue to profit
Profit bridge
Where every dollar of revenue ends up this month ($K)
Margin drivers
Margin % by category
Highest- and lowest-margin lines
Gross margin trend
Last 6 months
What makes (and loses) money
Profit by product
Top earners and the money-losers (red)
Where profit comes from
Share of gross profit by department
🤖 Insights
- After COGS and overhead, you keep ~18¢ of every revenue dollar.
- Prepared foods (48%) & eggs (41%) are the margin engines; top 6 products = 71% of gross profit.
- 5 SKUs lose money every sale (−$2.1K); bulk ice is worst at −12%.
✅ Recommended actions
- Raise prices ~8% on the 5 loss-makers, or drop them.
- Promote high-margin prepared foods (placement & specials).
- Re-quote suppliers on the lowest-margin categories.
🗄️ Data sources
- POS / sales — units & revenue by product
- Supplier costs — COGS per item
- Accounting — operating expenses (overhead)
📐 Definitions & methodology
- Gross margin = (price − unit cost) ÷ price
- Net margin = net profit ÷ revenue (after overhead)
- Profit contribution = (price − cost) × units sold
