SKU wise Visibility Dashboard
Demand Supply Balance Analytics
Total Demand Plan
-
Units
SKU Opening Stock
-
Units
Goods in Transit
-
Units
Final Balance to Produce
-
Units
Opening Stock Jan Month
-
Units
Balance to Invoice
-
Units
Inventory Matrix - Live Data
Complete inventory overview: track stock levels, weekly plans, and production requirements for each SKU model
Data Filters
� Invoicing Velocity shows how fast products are selling. Higher % = products moving quickly, Lower % = slow-moving inventory that may need attention
🟢 High (>80%):
Fast-selling, ensure adequate stock
🟡 Medium
(50-80%): Moderate demand, monitor trends
🔴 Low (<50%):
Slow-moving, consider promotions or production adjustments
�📝 Column Guide:
SKU: Product model code
Ton: Cooling capacity
Star Rating: Energy efficiency (1-5 stars)
Branch: Sales branch/region
Opening Stock: Starting inventory
S.Plan WK1-4: Weekly sales targets
Avl Stock: Ready to ship
Transit: On the way from factory
Coverage %: How long stock will last
Balance to Invoice: Units remaining to sell
Balance to Produce: Units to manufacture
Invoicing Velocity: Sales speed % (higher = faster)
Availability: Stock + Transit combined
| Models | Star Rating | Ton | Technology | Branch | SKU Month Opening stock | S.Plan WK1 | S.Plan WK2 | S.Plan WK3 | S.Plan WK4 | Total Month Plan | Available stock as on date | Transit stock | Month to date Invoice | Balance to Invoice | Invoicing Velocity | Availability | %Coverage Month Plan | Balance to despatch | Balance to Produce | Next Month opening Stock | Sri city Factory Stock | Neemrana Factory Stock |
|---|
Showing 0-0 of 0
models
Page 1 of
1
SKU Visibility Dashboard
Monthly SKU Metrics
Total Demand Plan
-
Units
SKU Opening Stock
-
Units
Goods in Transit
-
Units