ERP
ERP DemoReports PortalEA
ERP_ADMIN
Production
Executive Dashboard
Real-time business performance across all ERP modules
Revenue YTD
₹437 Cr
▲ 12.4%
Gross Margin
42.8%
▲ 1.2pp
Net Income
₹57 Cr
▲ 41.9%
DSO
34.2d
▼ 2.1d
Inventory
₹156 Cr
▲ 5.4%
On-Time Del
93.1%
▲ 0.8%
OEE
87.3%
▲ 2.1%
Headcount
2,340
▲ 12 YTD
Monthly Revenue vs Target (₹ Cr)
Module-Wise Spend Distribution
Explore Module Reports
FI
Financial Accounting
5 Reports →
CO
Controlling
4 Reports →
SD
Sales & Distribution
5 Reports →
MM
Materials Management
5 Reports →
PP
Production Planning
4 Reports →
HR
Human Capital
4 Reports →
FI — Financial Accounting
General Ledger, Accounts Receivable, Accounts Payable, Cash Management
Total Revenue
₹437.4 Cr
▲ 12.4% vs PY
Gross Profit
₹187.2 Cr
▲ 13.5% vs PY
EBITDA
₹92.8 Cr
▲ 18.7% vs PY
Net Income
₹56.9 Cr
▲ 41.9% vs Budget
Profit & Loss Statement — YTD Dec 2024 (INR Crores)
| GL Account | Description | Dec 2024 | Nov 2024 | YTD Actual | YTD Budget | Variance | Var % |
|---|---|---|---|---|---|---|---|
| 400000 | Revenue — Product Sales | ₹6,870 | ₹5,933 | ₹35,742 | ₹33,333 | +₹2,409 | 7.2% |
| 410000 | Revenue — Services | ₹1,575 | ₹1,375 | ₹7,998 | ₹7,667 | +₹331 | 4.3% |
| Total Revenue | ₹8,445 | ₹7,308 | ₹43,740 | ₹41,000 | +₹2,740 | 6.7% | |
| 500000 | COGS — Raw Materials | (₹2,748) | (₹2,492) | (₹14,295) | (₹14,000) | (₹295) | 2.1% |
| 510000 | COGS — Direct Labor | (₹1,374) | (₹1,246) | (₹7,148) | (₹7,000) | (₹148) | 2.1% |
| 520000 | Manufacturing Overhead | (₹687) | (₹623) | (₹3,574) | (₹3,500) | (₹74) | 2.1% |
| Gross Profit | ₹3,636 | ₹2,947 | ₹18,723 | ₹16,500 | +₹2,223 | 13.5% | |
| 600000 | Selling & Distribution | (₹743) | (₹704) | (₹4,252) | (₹4,100) | (₹152) | 3.7% |
| 610000 | General & Admin | (₹510) | (₹499) | (₹3,062) | (₹3,000) | (₹62) | 2.1% |
| 620000 | Research & Development | (₹354) | (₹342) | (₹2,125) | (₹2,000) | (₹125) | 6.3% |
| 630000 | Depreciation | (₹258) | (₹254) | (₹1,550) | (₹1,500) | (₹50) | 3.3% |
| Operating Income (EBIT) | ₹1,771 | ₹1,148 | ₹7,734 | ₹5,900 | +₹1,834 | 31.1% | |
| NET INCOME | ₹1,251 | ₹769 | ₹5,695 | ₹4,012 | +₹1,683 | 41.9% |
Assets
| Account | Description | Amount (₹ Cr) |
|---|---|---|
| 100000 | Cash & Cash Equivalents | ₹701 |
| 110000 | Accounts Receivable | ₹1,040 |
| 120000 | Inventories | ₹1,560 |
| 130000 | Prepaid Expenses | ₹104 |
| Total Current Assets | ₹3,405 | |
| 150000 | Property, Plant & Equipment | ₹2,704 |
| 160000 | Accumulated Depreciation | (₹1,186) |
| 170000 | Intangible Assets | ₹343 |
| TOTAL ASSETS | ₹5,266 |
Liabilities & Equity
| Account | Description | Amount (₹ Cr) |
|---|---|---|
| 200000 | Accounts Payable | ₹693 |
| 210000 | Short-Term Debt | ₹292 |
| 220000 | Accrued Liabilities | ₹407 |
| 230000 | Deferred Revenue | ₹175 |
| Total Current Liabilities | ₹1,567 | |
| 250000 | Long-Term Debt | ₹701 |
| 260000 | Other Liabilities | ₹158 |
| 300000 | Shareholder Equity | ₹2,257 |
| 310000 | Retained Earnings | ₹569 |
| TOTAL LIAB. & EQUITY | ₹5,266 |
Total AR
₹1,040 Cr
Current
₹603 Cr
1–30 Days Past Due
₹258 Cr
>90 Days Past Due
₹70 Cr
AR Aging Distribution
Top Overdue Customers (₹ Cr)
Customer AR Detail
| Customer | Region | Current | 1–30d | 31–60d | 61–90d | >90d | Total | Risk |
|---|---|---|---|---|---|---|---|---|
| C10001 — Tata Steel Ltd | East 🇮🇳 | ₹104 Cr | ₹27 Cr | ₹0 | ₹0 | ₹0 | ₹131 Cr | Low |
| C10042 — Reliance Ind. | West 🇮🇳 | ₹74 Cr | ₹38 Cr | ₹10 Cr | ₹0 | ₹0 | ₹122 Cr | Medium |
| C50034 — Mahindra Group | West 🇮🇳 | ₹18 Cr | ₹28 Cr | ₹23 Cr | ₹15 Cr | ₹34 Cr | ₹118 Cr | High |
| C20015 — L&T Ltd | South 🇮🇳 | ₹56 Cr | ₹23 Cr | ₹16 Cr | ₹7 Cr | ₹4 Cr | ₹106 Cr | Medium |
| C60012 — Infosys Ltd | South 🇮🇳 | ₹82 Cr | ₹13 Cr | ₹0 | ₹0 | ₹0 | ₹95 Cr | Low |
Total AP
₹693 Cr
Current
₹428 Cr
1–30 Days Past Due
₹177 Cr
>90 Days Past Due
₹32 Cr
Vendor AP Aging Detail
| Vendor | Location | Payment Terms | Current | 1–30d | 31–60d | >60d | Total | Status |
|---|---|---|---|---|---|---|---|---|
| V10001 — JSW Steel | Maharashtra | Net 30 | ₹103 Cr | ₹15 Cr | ₹0 | ₹0 | ₹118 Cr | On Track |
| V10042 — Hindalco Ind. | Uttar Pradesh | Net 45 | ₹74 Cr | ₹28 Cr | ₹10 Cr | ₹0 | ₹112 Cr | Watch |
| V20015 — Tata Steel | Jharkhand | Net 60 | ₹56 Cr | ₹34 Cr | ₹16 Cr | ₹15 Cr | ₹121 Cr | Overdue |
| V30078 — Bharat Forge | Pune | Net 30 | ₹93 Cr | ₹8 Cr | ₹0 | ₹0 | ₹101 Cr | On Track |
| V50034 — Vedanta Ltd | Goa | Net 45 | ₹35 Cr | ₹32 Cr | ₹17 Cr | ₹17 Cr | ₹101 Cr | Overdue |
Operating Cash Flow
₹866 Cr
▲ 14.2% vs PY
Investing Cash Flow
(₹300 Cr)
CAPEX: ₹350 Cr · Proceeds: ₹50 Cr
Financing Cash Flow
(₹158 Cr)
Debt Repayment · Dividends
Cash Flow Statement — YTD Dec 2024 (₹ Cr)
CO — Controlling
Cost Center Accounting, Profit Center, Product Costing, Budget Management
Budget vs Actual by Cost Center (₹ Cr)
Cost Center Variance
| Cost Center | Manager | Budget | Actual | Variance | Status |
|---|---|---|---|---|---|
| CC-1000 Production | R. Sharma | ₹350 Cr | ₹375 Cr | +₹25 Cr | Over |
| CC-2000 Logistics | A. Gupta | ₹175 Cr | ₹171 Cr | -₹4 Cr | Under |
| CC-3000 Quality | K. Verma | ₹117 Cr | ₹121 Cr | +₹4 Cr | Watch |
| CC-4000 Maintenance | T. Reddy | ₹150 Cr | ₹142 Cr | -₹8 Cr | Under |
| CC-5000 R&D | M. Patel | ₹167 Cr | ₹188 Cr | +₹21 Cr | Over |
| CC-6000 Admin | S. Kumar | ₹125 Cr | ₹124 Cr | -₹1 Cr | Under |
Profit Center — Segment Profitability (₹ Cr)
| Profit Center | Segment | Revenue | Direct Cost | Contribution | Margin % |
|---|---|---|---|---|---|
| PC-100 | Industrial Equipment | ₹1,867 Cr | (₹1,120 Cr) | ₹747 Cr | 40.0% |
| PC-200 | Consumer Products | ₹1,267 Cr | (₹811 Cr) | ₹456 Cr | 36.0% |
| PC-300 | Professional Services | ₹799 Cr | (₹440 Cr) | ₹359 Cr | 45.0% |
| PC-400 | Aftermarket Parts | ₹441 Cr | (₹220 Cr) | ₹221 Cr | 50.0% |
Product Costing — Standard vs Actual Variance
| Material | Description | Plant | Std Cost | Actual Cost | Variance | Var % | Type |
|---|---|---|---|---|---|---|---|
| MAT-10001 | Turbine Blade Assembly | 1000 | ₹2,04,200 | ₹2,09,400 | +₹5,200 | 2.5% | Material |
| MAT-10042 | Control Valve Unit | 1000 | ₹1,57,500 | ₹1,53,800 | -₹3,700 | 2.4% | Favorable |
| MAT-50022 | PLC Controller Module | 1000 | ₹2,67,500 | ₹2,78,500 | +₹11,000 | 4.1% | Labor |
| MAT-20105 | Hydraulic Pump Motor | 1200 | ₹56,500 | ₹57,950 | +₹1,450 | 2.6% | Overhead |
| MAT-30078 | Bearing Kit Standard | 1000 | ₹10,375 | ₹10,160 | -₹215 | 2.1% | Favorable |
Budget vs Actual — Monthly Trend (₹ Cr)
SD — Sales & Distribution
Order-to-Cash, Pricing, Billing, Delivery, Returns
Revenue YTD
₹437 Cr
▲ 12.4% vs PY
Avg Order Value
₹7.01 L
▲ 4.8% vs PY
Win Rate
72.3%
▲ 3.1pp vs PY
Monthly Revenue vs Forecast (₹ Cr)
Revenue by Sales Organization
Order Fulfillment — By Distribution Channel
| Sales Org | Channel | # Orders | Value (₹ Cr) | On-Time % | Avg Cycle | Return % | SLA |
|---|---|---|---|---|---|---|---|
| 1000 — North | Direct Sales | 3,245 | ₹1,535 | 96.2% | 4.1d | 1.8% | ✓ Met |
| 1000 — North | Distributor | 1,876 | ₹1,056 | 93.8% | 6.3d | 2.4% | ✓ Met |
| 2000 — South | Direct Sales | 2,104 | ₹1,186 | 88.1% | 7.8d | 3.2% | ⚠ Risk |
| 3000 — West | Direct Sales | 987 | ₹597 | 82.4% | 11.2d | 5.1% | ✗ Missed |
Top 10 Customers by Revenue (₹ Cr)
Pricing Condition Analysis — Discount Usage
| Condition | Description | Type | # Applied | Total Value (₹ Cr) | Avg % | Impact |
|---|---|---|---|---|---|---|
| PR00 | Base Price | Price | 8,247 | ₹437 | 100% | Baseline |
| K004 | Customer Discount | Discount | 5,120 | (₹26) | 6.0% | Monitor |
| K005 | Material Discount | Discount | 3,890 | (₹18) | 4.0% | Normal |
| MWST | GST | Tax | 8,247 | ₹35 | 18% | Statutory |
| KF00 | Freight Surcharge | Surcharge | 4,210 | ₹13 | 3.0% | Revenue |
Return Rate
3.2%
Industry Avg: 4.5%
Return Value YTD
₹14 Cr
264 Returns processed
Top Reason
Defective
38% of all returns
Returns by Reason Code
MM — Materials Management
Procure-to-Pay, Inventory, Vendor Evaluation, Stock Analysis
Total Stock Value
₹156 Cr
▲ 5.4% above target
Dead Stock
₹12 Cr
No movement >365 days
Avg Turnover
5.8x
▲ 0.6x vs PY
ABC Classification
Material Stock — ABC/XYZ
| Material | Description | ABC | XYZ | Value (₹ Cr) | Turnover | Status |
|---|---|---|---|---|---|---|
| MAT-10001 | Turbine Blade Assembly | A | X | ₹20.4 | 8.2x | Optimal |
| MAT-50022 | PLC Controller Module | A | X | ₹26.8 | 9.7x | Optimal |
| MAT-20105 | Hydraulic Pump Motor | B | Y | ₹5.7 | 3.1x | Slow |
| MAT-45001 | Custom Gasket Set | C | Z | ₹0.4 | 0.8x | Dead Stock |
Vendor Performance Scorecard
| Vendor | Location | Spend YTD (₹ Cr) | On-Time % | Quality | Price Var | Invoice Acc | Rating |
|---|---|---|---|---|---|---|---|
| V10001 — JSW Steel | Maharashtra | ₹402 | 98.2% | 97/100 | +0.3% | 99.1% | ⭐⭐⭐⭐⭐ |
| V10042 — Hindalco Ind. | Uttar Pradesh | ₹304 | 95.1% | 92/100 | -1.2% | 97.8% | ⭐⭐⭐⭐ |
| V30078 — Bharat Forge | Pune | ₹177 | 96.8% | 94/100 | +1.8% | 98.5% | ⭐⭐⭐⭐ |
| V20015 — Tata Steel | Jharkhand | ₹241 | 88.7% | 85/100 | -3.4% | 94.2% | ⭐⭐⭐ |
| V50034 — Vedanta Ltd | Goa | ₹165 | 78.3% | 76/100 | -4.1% | 89.7% | ⭐⭐ |
Purchase Order Cycle Time — Avg Days by Process Step
Stock Aging Profile (₹ Cr)
Material Consumption — Monthly Trend (₹ Cr)
PP — Production Planning
Manufacturing Orders, Capacity, OEE, Production Variances
OEE
87.3%
Target: 85%
Availability
93.2%
Downtime: 4.8hrs
Performance
94.8%
Speed loss: 3.1hrs
Quality
98.7%
Scrap: 1.3%
OEE by Work Center
Production Orders — Status Summary
| Order | Material | Plant | Qty | Target Date | Status | Actual Cost (₹ L) | Variance |
|---|---|---|---|---|---|---|---|
| 40000123 | MAT-10001 Turbine Blade | 1000 | 500 | Dec 15 | Completed | ₹1,02,100 | +₹2,595 |
| 40000124 | MAT-50022 PLC Controller | 1000 | 200 | Dec 18 | Completed | ₹53,500 | -₹1,070 |
| 40000125 | MAT-20105 Hydraulic Pump | 1200 | 150 | Dec 22 | In Progress | ₹7,475 | — |
| 40000126 | MAT-10042 Control Valve | 1000 | 300 | Dec 28 | Released | — | — |
| 40000127 | MAT-30078 Bearing Kit | 1000 | 1000 | Dec 20 | Delayed | ₹5,208 | +₹678 |
Capacity Utilization by Work Center (%)
Production Variance Analysis (₹ L)
HR — Human Capital Management
Headcount, Payroll, Attrition, Organization
Total HC
2,340
▲ 12 YTD
New Hires
142
YTD 2024
Exits
89
YTD 2024
Open Positions
34
Avg time to fill: 42d
Headcount by Department
Headcount Trend — Monthly
Payroll Summary — December 2024 (₹ Lacs)
| Department | HC | Base Salary | Overtime | Benefits | TDS | Total Cost |
|---|---|---|---|---|---|---|
| Engineering | 420 | ₹2,800 | ₹118 | ₹700 | ₹896 | ₹4,514 |
| Manufacturing | 680 | ₹2,833 | ₹260 | ₹708 | ₹907 | ₹4,708 |
| Sales & Marketing | 310 | ₹2,067 | ₹40 | ₹517 | ₹661 | ₹3,285 |
| Finance & Admin | 190 | ₹1,267 | ₹18 | ₹317 | ₹405 | ₹2,007 |
| R&D | 240 | ₹1,800 | ₹57 | ₹450 | ₹576 | ₹2,883 |
| Supply Chain | 180 | ₹900 | ₹45 | ₹225 | ₹288 | ₹1,458 |
| HR & Legal | 120 | ₹800 | ₹10 | ₹200 | ₹256 | ₹1,266 |
| Total | 2,140 | ₹12,467 | ₹548 | ₹3,117 | ₹3,989 | ₹20,121 |
Attrition Rate — Monthly Trend
Attrition by Department
Organization Structure — Span of Control
| Department | Head | Direct Reports | Total HC | Span | Avg CTC (₹ L) | Cost/HC (₹ L) |
|---|---|---|---|---|---|---|
| Engineering | VP — A. Iyer | 6 | 420 | 1:70 | ₹24.0 | ₹38.6 |
| Manufacturing | VP — S. Das | 8 | 680 | 1:85 | ₹15.0 | ₹24.9 |
| Sales & Marketing | VP — P. Joshi | 5 | 310 | 1:62 | ₹24.0 | ₹38.1 |
| R&D | VP — K. Nair | 4 | 240 | 1:60 | ₹27.0 | ₹43.2 |
| Finance & Admin | CFO — R. Menon | 5 | 190 | 1:38 | ₹24.0 | ₹38.0 |
| Supply Chain | VP — D. Rao | 4 | 180 | 1:45 | ₹18.0 | ₹29.2 |
| HR & Legal | CHRO — L. Pillai | 3 | 120 | 1:40 | ₹24.0 | ₹38.0 |