SCM Data Analysis & MIS
Collect, validate, consolidate and analyze SCM data from ERP/HMS and other systems.
Prepare daily, weekly and monthly SCM MIS reports.
Develop management dashboards and analytical reports for senior management.
Identify trends, variances, exceptions and abnormal transactions.
Provide data-driven insights and recommendations to SCM management.
Cost & Margin Analysis
Analyze procurement cost, selling price, MRP and margin data.
Identify prospects for procurement cost reduction.
Prepare product/item-wise margin analysis.
Analyze price changes and their impact on profitability.
Support management with cost-saving and margin-improvement analysis.
Procurement Analytics
Analyze Purchase Orders (PO), GRNs, invoices and purchase rates.
Monitor PO rate vs. GRN rate vs. invoice rate and identify discrepancies.
Analyze vendor-wise and item-wise purchase trends.
Track price variations and support procurement teams in identifying cost-saving opportunities.
Analyze quotation history and changes in approved purchase prices.
Monitor procurement volumes, purchase frequency and vendor dependency.
Inventory Analytics
Analyze inventory levels, stock movement and inventory ageing.
Prepare reports on non-moving, slow-moving, rapid-moving and critical/vital items.
Monitor stock coverage and identify excess or shortage risks.
Analyze inventory turnover and working capital impact.
Support inventory optimization initiatives.
Identify near-expiry and expired stock trends.
Vendor Performance Analytics
Prepare vendor-wise performance reports.
Analyze purchase value, pricing, supply frequency and delivery performance.
Track vendor rate variations and compliance with approved PO rates.
Identify vendors/items requiring corrective action.
Support vendor evaluation and performance review.
Data Quality & Controls
Validate SCM data before publishing management reports.
Identify data discrepan