Historical Ingestion
3 Yrs
36-Month Full HorizonReal-Time Processing
100%
Sub-800ms Query RenderAvg Identified Savings
15%+
Realized BenchmarkFaster Conversion
3x
Advisory to SaaS Lock-inEnd-to-End Processing Pipeline & Architecture
Module 1: Document Ingestion & Multi-Currency ETLMulti-Currency FX Engine Active
Multi-ERP Ingestion & Normalization Engine
Ingests multiple foreign currencies (USD, EUR, GBP, AED, JPY, SGD), applies historical time-series FX conversion rates, and normalizes all spend into INR in Crores (₹ Cr).
Live FX Benchmark Conversion Rates to INR:
USD/INR:₹83.80EUR/INR:₹91.40GBP/INR:₹106.50AED/INR:₹22.80JPY/INR:₹0.56SGD/INR:₹63.20
Enterprise Client:Apex Industrial Dynamics (Fortune 500)
|Industry Sector:Chemical & Petrochemicals - Specialty Chemicals
|Dataset Type:Purchase History
|Evaluation Window:36 Months (FY24 - FY26: 1 Apr 2023 - 31 Mar 2026)
|Reporting Base:INR in Crores (₹ Cr)
Upload Purchase History (Multi-Currency)
Max 2GBUpload Purchase History for Apex Industrial Dynamics
AI automatically detects currencies & converts to INR in Crores (₹ Cr)
Uploaded Procurement File Details
Verified dataset with record count strictly excluding header row
3 years data.xlsxFormat: XLSX • Size: 9.55 MB • Uploaded: 2026-08-24 09:14:22
100% Completed
Total Ingested Records (Data Rows):
42,765 RecordsExcluding Header Row
Calculated Total Spend from File:₹8066.86 Cr
Spend Formula:∑ (Order Quantity × Net Price × Currency in INR)
Detected Currencies:INR
ID: DOC-9041Preliminary Savings Potential Detected
Savings Available: YES
Our autonomous diagnostics have detected immediate EBITDA savings opportunities in your uploaded dataset. Upgrade to Silver or Gold to unlock the detailed breakdown.
Uploaded Document SummaryMulti-Currency Data Aggregation
Client Ingestion Data Summary & Spend Dimensions
Consolidated summary of uploaded dataset "3 years data.xlsx" (42,765 records) across Material Groups, Facilities & Billing Months.
Spend Currency:
Total Evaluated Spend
₹8066.86 Cr
Base INR in CroresTotal Line Items
42,765
Across 36 Billing MonthsUnique Items
7,357
Distinct SKUs / MaterialsUnique Vendors
1,073
Active Master SuppliersMaterial Groups
274 Groups
Direct & ConsumablesOperating Plants
24 Facilities
Across Operational HubsMaterial Groups Reconciliation & Scope Note0.00 Variance Reconciled
Scope Filter:
Scope Details: Showing Top 10 Material Groups representing ₹7305.66 Cr (90.6% of evaluated spend) out of 274 Material Groups (₹8066.86 Cr). Balance groups account for remaining spend.
Deviation / Gap: ₹0.00 Cr (0.00%)— 100% spend accounted for
| Group Code | Material Group Name | Sample Item / SKU | Unique Items | Unique Vendors | Line Items | Spend (₹ Cr) | Spend Share | 3-Year Trend (FY24 / FY25 / FY26) |
|---|---|---|---|---|---|---|---|---|
| FERRO | Ferro Alloys & Noble Metals (FERRO) | FERRO NICKEL - NI% 10 - 14 | 33 | 84 | 2,136 | ₹4135.60 Cr | 51.3% | FY24: ₹935.1FY25: ₹1502.1FY26: ₹1698.4 |
| SCRAP | Stainless Steel & Melting Scrap (SCRAP) | STAINLESS STEEL MELTING SCRAP 316 | 93 | 133 | 1,353 | ₹2305.96 Cr | 28.6% | FY24: ₹734.1FY25: ₹820.0FY26: ₹751.9 |
| SCRAP-RM | Shredded Raw Material Scrap (SCRAP-RM) | STAINLESS STEEL SHREDDED SCRAP 316 (SHD) | 16 | 42 | 207 | ₹161.71 Cr | 2.0% | FY24: ₹54.5FY25: ₹29.3FY26: ₹77.8 |
| RFR0001 | Refractories & Ramming Masses (RFR0001) | DOLORAM I | 89 | 10 | 507 | ₹125.94 Cr | 1.6% | FY24: ₹35.8FY25: ₹43.9FY26: ₹46.3 |
| ACD0001 | Process Lubricants, Acids & Chemicals (ACD0001) | LUBRICANT DRY POWDER,REF:VICAFIL TN 4392 | 128 | 64 | 2,184 | ₹113.38 Cr | 1.4% | FY24: ₹40.1FY25: ₹38.6FY26: ₹34.7 |
| SMS0002 | Steel Melting Shop Consumables (SMS0002) | LIME,HYDRATED,CAOH2 ≥ 92%,SIZE ≤ 90MICR | 27 | 59 | 554 | ₹112.33 Cr | 1.4% | FY24: ₹26.9FY25: ₹28.9FY26: ₹56.5 |
| FLG0003 | Forged Flanges & Pipe Fittings (FLG0003) | GAS,REFRIGERATION,R 22 | 20 | 23 | 1,003 | ₹97.15 Cr | 1.2% | FY24: ₹34.6FY25: ₹21.1FY26: ₹41.4 |
| SCR0MS | Mild Steel Melting Scrap (SCR0MS) | LOW PHOS HEAVY MELTING SCRAP | 6 | 32 | 204 | ₹88.07 Cr | 1.1% | FY24: ₹33.5FY25: ₹30.6FY26: ₹24.0 |
| FLG0001 | Industrial Heavy Flanges (FLG0001) | OIL,DIESEL,HS | 4 | 10 | 193 | ₹83.71 Cr | 1.0% | FY24: ₹39.2FY25: ₹21.7FY26: ₹22.8 |
| BLT316 | Stainless Steel Billets 316 (BLT316) | SFG SS BLT 316L20 140MM 4.65M | 54 | 10 | 94 | ₹81.81 Cr | 1.0% | FY24: ₹0.0FY25: ₹66.6FY26: ₹15.2 |
| BAL-5 | Balance / Other 5 Material Groups | Consolidated remaining 5 long-tail material groups | — | — | — | ₹761.20 Cr | 9.4% | Balance Commodity Categories |
| Grand Total | Reconciled total across all 15 material groups (100.0% spend accounted for) | 7,357 | 1,073 | 42,765 | ₹8066.86 Cr | 100.0% | 0.00 Variance Reconciled | |
Document summary validated across 42,765 line items
Pareto 80/20 RuleExcel Pivot Layout
Top 80% Spend Pareto Hierarchy
Collapsible item & vendor breakdown accounting for 80% of total spend portfolio.
Cumulative Spend: ₹6,467.09 Cr
Supplier Name | Short Text(collapsible) | Sum of Total In Crs |
|---|---|---|
+JINDAL STAINLESS LIMITED | [+] 3 items (click to expand) | ₹ 2,450.80 |
+VALE INTERNATIONAL SA | [+] 2 items (click to expand) | ₹ 1,530.65 |
+TRAFIGURA INDIA PRIVATE LIMITED | [+] 3 items (click to expand) | ₹ 1,259.19 |
+GLENCORE INTERNATIONAL AG | [+] 3 items (click to expand) | ₹ 1,226.45 |
Showing 4 entities (83.6% of spend, cumulative Pareto threshold)
80% Spend Cutoff Boundary Reached — Remaining Long-Tail Suppliers / Items Excluded Below
Multi-Currency Validation & Line Item Pre-Check (FR-ING-03)
Line-item data cleansing pre-flight check. Converts multi-currency items to Base INR in Crores, highlights unresolved anomalies, and updates active spend in real time.
Total File Spend
₹6.11 Cr
7 Sample Records Evaluated
Validated Spend (Active)
₹1.44 Cr
3 of 7 Records Cleared
Pending Issues (Excluded)
₹4.67 Cr
4 Anomalies Excluded from Analytics
Quality Index
42.9%
Remediation in Progress
| Record & Year | PO & Line Item Description | Category & Column L Code | Vendor Entity | Order Qty (Q) | Net Price (P) | Currency & FX Rate | Line Spend (₹ Cr) | Inclusion & ETL Status | Action |
|---|---|---|---|---|---|---|---|---|---|
| REC-8841 20242024-05-18 | PO-2024-99812High Density Polyethylene Granules (25kg Bags) | Direct MaterialsCol L: 13101502 | Continental Polymer S.A. | 1,000 | EUR 145.00 | ₹90.801 EURYahoo Fin API | ₹1.32 Cr | Missing Currency Code⚠️ Excluded until resolved | |
| REC-8842 20252025-02-14 | PO-2025-11029Cross-Border Air Express & Customs Clearance Fee | Logistics & FreightCol L: 78101801 | DHL Logistics GmbH / DHL Express US | 320 | USD 120.00 | ₹84.801 USDYahoo Fin API | ₹0.33 Cr | Unmapped Supplier Name⚠️ Excluded until resolved | |
| REC-8843 20252025-09-04 | PO-2025-44910Double Wall Corrugated Pallet Container 48x40x36 | Packaging MaterialsCol L: 14121506 | Amcor Packaging Group | 2,000 | USD 44.60 | ₹84.801 USDYahoo Fin API | ₹0.76 Cr | Passed CleanActive in Spend (₹0.76 Cr) | Ready |
| REC-8844 20232023-11-20 | PO-2023-77123Hydrochloric Acid 37% Tech Grade Bulk Tanker | Direct MaterialsCol L: 12352204 | Acme Chemical Co. LLC | 650 | GBP 300.00 | ₹102.801 GBPYahoo Fin API | ₹2.00 Cr | Tax Discrepancy⚠️ Excluded until resolved | |
| REC-8845 20232023-08-11 | PO-2023-33901Emergency Centrifugal Pump Impeller Re-machining | Indirect & MROCol L: 40151501 | Flowserve Industrial Services | 50 | AED 850.00 | ₹22.501 AEDYahoo Fin API | ₹0.10 Cr | Passed CleanActive in Spend (₹0.10 Cr) | Ready |
| REC-8846 20262026-01-16 | PO-2026-10022Reinforced Shipping Cartons Heavy Duty 32ECT | Packaging MaterialsCol L: 14121506 | Crown Paper Box Corp | 10,000 | USD 6.73 | ₹86.501 USDYahoo Fin API | ₹0.58 Cr | Passed CleanActive in Spend (₹0.58 Cr) | Ready |
| REC-8847 20242024-07-22 | PO-2024-55190HDPE Granules Grade B - 25kg Pack | Direct MaterialsCol L: 13101502 | Continental Polymer S.A. | 800 | EUR 140.00 | ₹91.401 EURYahoo Fin API | ₹1.02 Cr | Duplicate Item Description⚠️ Excluded until resolved |
Ready to trigger Public & Enterprise QUA AI UNSPSC Taxonomy Engine (INR Base)