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 opportunities 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