KPI Dashboard for Steel Manufacturers: A CFO's Guide for Mid-Sized Indian Plants

Most mid-sized Indian steel manufacturers run two dashboards that never talk to each other. One lives on the shop floor — OEE, downtime, yield, tapped from PLC data or, more often, from a shift supervisor's WhatsApp message. The other lives in the finance function — EBITDA, working capital days, ITC claimed, built from Tally exports and Excel. By the time the CFO sees a cost overrun, the quarter is closed and the explanation is a rounding error away from useless.

This gap costs real money. At a 2 MTPA plant, a single point of OEE improvement is worth roughly ₹10 crore in additional annual production — a figure that only shows up if someone is actually measuring OEE correctly and tying it to cost per tonne in near real time (source: ifactory.ai). Most integrated plants in India run OEE between 60-75%, well short of the 85%+ that world-class operations hit (source: ifactory.ai). This gap represents significant hidden losses from inaccurate KPI measurement, a figure many steel CFOs may not be tracking with sufficient rigor.

This article lays out a KPI framework built specifically for the constraints Indian steel CFOs actually operate under: high financing costs, import-dependent inputs, a fast-changing compliance regime, and margin pressure from cheap imports.

Why does India's steel growth story not automatically translate into steel company profitability?

India became the world's second-largest steel producer by 2025, at nearly 9% of global output, trailing only China (source: CSEP). Crude steel production hit roughly 164.89 million tonnes in 2025, a 10.36% jump over 2024 (source: Statbase), and capacity climbed to 200.33 MT in FY25 against a National Steel Policy target of 300 MTPA by 2030-31 (source: IBEF). Demand is projected to nearly double by 2035, with India and Southeast Asia absorbing most of the world's incremental steel demand (source: McKinsey).

Set against this, the Indian steel market was valued at USD 140.5 billion in 2025, heading to USD 227.38 billion by 2032 at roughly 7.12% CAGR (source: MarkNtel Advisors). Industry-wide EBITDA margins have averaged 15% of sales over 2000-2025 — 3-4 points above other Indian manufacturing sectors and global steel peers (source: CSEP).

The catch: those averages hide a bifurcated industry. Large integrated players capture scale economics and financing terms that mid-sized and SME producers cannot match. SMEs account for nearly half of India's total steel output but have taken the brunt of cheap import competition, with several mills suspending operations as margins compressed (source: Angel One). If you run a mid-sized rolling mill or a sponge iron unit, the national growth story is real, but it's not automatically yours. Your dashboard has to isolate the controllable variables — cost per tonne, financing spread, compliance drag — from the macro tailwind.

Which financial KPIs should a steel CFO actually watch every week?

Monthly MIS is too slow for an industry where input costs move daily. A weekly (not monthly) financial cockpit should track:

1. Cost per tonne of finished steel, split into raw material, power & fuel, labour, and conversion cost — reconciled against the previous week, not the previous month.
2. Contribution margin per product SKU (TMT bars vs. HR coil vs. billets), because product mix shifts can mask a genuine cost problem.
3. Interest cost as a % of EBITDA. India's REPO rate sat at 6.5% as of mid-2023 against China's 2-2.5% (source: Avalon Consulting). On a ₹150 crore working capital facility, that spread alone can mean an extra ₹6-7 crore in annual interest versus a Chinese competitor with comparable scale — a structural disadvantage no amount of operational excellence fully offsets, but one your dashboard should size precisely rather than gesture at.
4. Debtor days and creditor days, tracked against your GST filing cycle — a mismatch here is often where working capital actually leaks.
5. Input Tax Credit (ITC) claimed vs. ITC eligible. Most steel products attract 18% GST, and businesses can claim ITC on raw materials, transport, and processing costs (source: Busy Accounting). On ₹40 crore of monthly raw material purchases, a 2% ITC leakage from mismatched invoices or vendor non-filing is ₹80 lakh a month walking out the door. We've written separately about how invoice matching automation protects ITC and cash flow — the mechanics apply directly to a steel mill's scrap and ore purchase ledger.

None of these numbers mean much in isolation. The dashboard's job is to show cost per tonne trending against interest cost and ITC leakage on the same screen, so a controller can see in one glance whether a margin dip is operational, financial, or compliance-driven.

How should GST, TDS and MCA changes show up on the dashboard, not just in the tax file?

This is where most steel dashboards fall short — they treat compliance as a back-office reporting exercise instead of a live financial variable.

GST TDS on scrap purchases. Effective October 10, 2024, buyers of metal scrap under Chapters 72-81 of the Customs Tariff Act must deduct 2% TDS under GST from registered suppliers when the taxable value crosses ₹2,50,000 per transaction (source: Certicom). For a mid-sized EAF or induction furnace unit sourcing 60-70% of its charge mix from scrap, this isn't a footnote — it's a cash flow timing issue on every large scrap invoice. Your dashboard needs a scrap-purchase TDS tracker that flags transactions above the threshold before the invoice is booked, not after the return is filed.

TDS on iron ore and coking coal. Under Section 393(1) Sl. 8(ii) of the Income-tax Act 2025, buyers with prior-year turnover above ₹10 crore must deduct 0.1% TDS on iron ore and coking coal purchases exceeding ₹50 lakh per vendor PAN annually (source: Terrain Insight). Run a simple check: if your plant buys ₹8 crore of coking coal annually from a single vendor, you're deducting roughly ₹8 lakh in TDS across the year — money that needs to reconcile against Form 26AS and the vendor's own claims. A dashboard tile showing vendor-wise cumulative purchase value against the ₹50 lakh threshold, updated in real time, prevents the scramble every March to figure out which vendors crossed the line.

MCA annual filing disclosures. From July 14, 2025, AOC-4 and MGT-7 filings for FY 2024-25 require expanded disclosures, including workplace harassment data and workforce composition (source: Lexology). These aren't finance KPIs in the traditional sense, but for a CFO signing off on the annual return, having HR headcount and grievance data flow into the same reporting layer as financials saves weeks of last-minute compilation.

The common thread: compliance deadlines and thresholds should trigger dashboard alerts, not calendar reminders in someone's inbox. If you're evaluating what a well-built compliance layer looks like more broadly, our piece on common dashboard mistakes costing Indian CFOs money covers the structural errors — stale data, no drill-down, single point of failure — that apply here just as much as in FMCG or pharma.

What operational KPIs actually move the profit needle on the shop floor?

Three metrics deserve dashboard-level attention, tracked shift-wise, not month-wise:

Overall Equipment Effectiveness (OEE). World-class plants target 85%+; most Indian integrated plants sit at 60-75% (source: ifactory.ai). Worked example: a 2 MTPA plant running at 68% OEE that improves to 71% — a 3-point gain — is worth roughly ₹30 crore in additional annual output value at current realizations, assuming the extra tonnes find a market. That's not a rounding error; that's often bigger than the plant's entire annual capex budget. The catch is measurement integrity — if downtime is logged manually by shift supervisors rather than pulled from PLC/SCADA data, the OEE number your dashboard shows can be 10-15 points optimistic versus reality, and every decision built on it is wrong in the same direction.

Yield loss and rejection rate, tracked by furnace/mill and by shift, not aggregated monthly. A 1% yield improvement on a 3,00,000 tonne annual rolling mill output, at an average realization of ₹55,000/tonne, is worth roughly ₹16.5 crore in recovered value — money that's currently being scrapped, literally.

Energy and fuel cost per tonne. Power and fuel typically run 15-20% of conversion cost in an Indian EAF or induction furnace operation. A dashboard that flags per-tonne energy cost deviation beyond 3% week-on-week catches equipment inefficiency or tariff category errors before they compound into a quarterly miss.

The practitioner pain point here is data lineage. If OEE on the dashboard is manually keyed in by a shift engineer at day-end, it's already stale and prone to rounding for optics. The fix isn't a fancier dashboard tool — it's wiring PLC/SCADA output directly into whatever BI layer you use, so the number on the CFO's screen is the same number the plant manager is fighting with in real time.

How do coking coal dependence and logistics costs show up as trackable KPIs?

Indian steel plants import roughly 85% of their coking coal requirement, and the associated import duties create a structural cost disadvantage against global competitors (source: Kearney). This isn't an abstract macro risk — it's a line item your dashboard should isolate and hedge against.

Track imported coking coal cost as a % of total input cost, alongside a landed cost variance tracker comparing budgeted landed cost (freight + duty + forex) against actual, updated with every shipment. A 5% adverse forex movement on a ₹20 crore quarterly coking coal import bill is a ₹1 crore swing that a monthly dashboard catches too late to hedge.

Logistics compounds this. Poor infrastructure means Indian inland transportation distances for raw materials and finished goods run significantly higher than in China or South Korea (source: Kearney). A logistics cost per tonne (inbound and outbound, tracked separately) metric, benchmarked quarter-over-quarter, tells you whether a new dispatch route or a renegotiated freight contract is actually saving money or just shifting the cost elsewhere in the P&L.

How does inventory management fit into the steel KPI dashboard?

Steel is a working-capital-heavy business — iron ore, coking coal, scrap, and finished goods all sit as inventory for weeks at a time, tying up cash at 6.5%+ borrowing costs.

Three inventory KPIs deserve dashboard placement:

• Raw material days of cover, by input type (ore, coal, scrap) — too high ties up cash; too low risks a production halt if a single shipment is delayed.
• Finished goods inventory turnover, tracked against order book, to catch overproduction into a softening market — relevant given the cheap-import pressure many SME steel producers already face (source: Angel One).
• Slow-moving/obsolete stock as % of total inventory value — for a mid-sized plant carrying ₹60-80 crore of raw material and finished stock, even a 3% obsolescence rate is ₹2+ crore of value that should have triggered a write-down conversation months earlier.

If your ERP already has this data but it's trapped in module-specific reports, the fix is reporting discipline, not new software. Our ERP reporting best practices guide walks through how to restructure ERP outputs into a usable finance cockpit, which applies directly to steel inventory and procurement modules.

What should a mid-sized steel CFO's dashboard structure actually look like?

Rather than a flat list of 40 KPIs no one looks at consistently, structure the dashboard in three tiers:

Tier 1 — Daily/shift-level operational tiles: OEE, yield, rejection rate, energy cost/tonne, downtime by cause — sourced directly from PLC/SCADA, no manual entry.

Tier 2 — Weekly financial tiles: cost per tonne by product, contribution margin by SKU, raw material days of cover, landed cost variance on imports, GST TDS threshold tracker for scrap and mineral purchases.

Tier 3 — Monthly/quarterly strategic tiles: EBITDA margin trend, interest cost as % of EBITDA, ITC leakage %, debtor/creditor days, MCA compliance calendar status, cost take-out program tracking.

On that last point — large players have shown what's possible. Tata Steel has publicly targeted roughly ₹11,500 crore in cost take-outs across geographies through operational efficiency, supply chain optimization, and fixed cost reduction (source: Livemint). A mid-sized plant won't have that scale of program, but the discipline — a tracked, numbered list of cost initiatives with owners and monthly savings targets — is directly replicable at 1/50th the scale, and belongs as its own dashboard tile rather than buried in a strategy deck reviewed once a year.

For CFOs weighing whether AI tools can help build or maintain this kind of dashboard faster, it's worth reading our comparison on AI coding tools for finance automation — several of the low-code approaches discussed there apply well to stitching PLC data with Tally/SAP exports without a full ERP overhaul.

How BiPivot helps

BiPivot works with mid-sized Indian steel manufacturers to connect shop-floor data (PLC/SCADA) with financial systems (Tally, SAP, GST/TDS filings) into a single real-time dashboard, so OEE, cost per tonne, and compliance thresholds are visible on one screen instead of three. If your finance team is still reconciling operational and financial KPIs manually at month-end, visit bipivot.com to see how we've built these dashboards for plants your size).