Stock
🔴 CriticalAt a Glance
Dead Stock Value
₹3.2L
Sitting 90+ days, not moving
Items Affected
47
SKUs with zero sales in 90 days
Storage Space Used
18%
Of total shelf / warehouse space
Avg Days Sitting
127
Days since last sale — these items
Top 3 Slow-Moving Items
| # | Item | Qty in Stock | Stock Value | Last Sold | Days Idle |
|---|---|---|---|---|---|
| 1 | Finolex CPVC 1" Pipe (3m length) | 214 pcs | ₹98,000 | Oct 2024 | |
| 2 | Asian Paints Primer 20L (exterior) | 38 tins | ₹76,000 | Nov 2024 | |
| 3 | M-Sand Plaster Grade (50kg bag) | 310 bags | ₹62,000 | Dec 2024 |
What You Should Do
Run a 3-day clearance offer on CPVC pipes and exterior primer — WhatsApp your regular contractor list with a 12–15% discount. ₹1.5L of dead stock can move in one week if the right 5 contractors see it.
Stop reordering M-Sand plaster grade until current stock clears. Your supplier is sending the next batch next week — call and defer by 30 days. This stops the pile-up.
Sales
🟡 Review NeededThis Month vs Last Month
February 2025
₹8.4L
Total sales revenue
March 2025 (till 15th)
₹5.1L ↑ On Track
Projected ₹9.2L if pace holds
Gross Margin (Feb)
17.4%
Target: 22% — gap of 4.6%
Avg Bill Size
₹4,820
Per transaction, Feb 2025
No. of Bills
174
Feb 2025 (145 in Jan)
Top 3 Products by Revenue
| # | Product | Revenue (Feb) | Margin | Trend |
|---|---|---|---|---|
| 1 | TMT Steel Bars (Fe 500) | ₹2.18L | 11% | ↑ +8% |
| 2 | Ultratech OPC 53 Cement (50kg) | ₹1.74L | 9% | ↑ +3% |
| 3 | Kajaria Wall Tiles (600×300mm) | ₹1.22L | 26% | ↓ −5% |
Bottom 3 — Dragging Your Margin
| # | Product | Revenue (Feb) | Margin | Problem |
|---|---|---|---|---|
| 1 | Finolex CPVC 1" Pipe | ₹18,400 | 4% | Over-discounting to move slow stock |
| 2 | Asian Paints Exterior Primer 20L | ₹22,800 | 6% | Purchased at peak price, selling below cost |
| 3 | Holcim Wall Putty (20kg bag) | ₹31,500 | 8% | New competitor nearby selling cheaper |
What You Should Do
Kajaria tiles are your best margin product at 26% — but sales dropped 5% last month. Ask your top 3 tile-buying customers why. A small contractor discount or sample offer could recover ₹30–40K in monthly margin.
Cash & Receivables
🟢 HealthyOutstanding Summary
Total Outstanding
₹1.8L
Across 11 credit customers
Overdue (60+ days)
₹72,000
3 customers — needs follow-up
Due in 30 Days
₹1.08L
8 customers — within terms
Collection Rate
91%
Last 6 months — good track record
Top 3 Overdue Customers
| # | Customer | Amount Due | Overdue Since | Also Buying Slow Stock? |
|---|---|---|---|---|
| 1 | Suresh Constructions, Irinjalakuda | ₹31,500 | 78 days | ⚠️ Yes — CPVC pipes (₹8,200) |
| 2 | Anish Builders (Contractor) | ₹24,800 | 62 days | ⚠️ Yes — exterior primer (₹5,600) |
| 3 | K.R. Pradeep (Individual) | ₹15,700 | 44 days | ✅ No — regular tile buyer |
What You Should Do
Call Suresh Constructions and Anish Builders this week. Both have been buying on credit and are also sitting on slow-moving items you gave them — this means two problems with the same customer. Set a clear 15-day repayment plan before allowing any new credit.
⚠️ Disclaimer: All business names, figures, product names, and financial data in this report are entirely sample/synthetic and created for demonstration purposes only. They do not represent any real business, individual, or actual financial situation.