Role & responsibilities To support business decisions by managing MIS and analysis related to product contribution margins and channel-wise profitability, with a strong focus on Modern Trade (MT) and E-commerce channels, using SAP and BI as the primary profitability reporting tool.
Key Responsibilities: MIS & SAP Reporting :
- Prepare monthly MIS reports using SAP, BI and Excel.
- Report contribution margins (CM1 / CM3 / Net Margin) in MIS and maintain structured MIS dashboards for management and leadership reviews.
- Derive cost to serve across channels
Product Contribution Analysis
- Analyze SKU-wise / brand-wise contribution margins, for GT, MT and E-commerce and compare inter channel margins
- Track impact of pricing, visibility spends, and cost changes on margins.
- Monitor profitability of exclusive SKUs, and online-only products.
- Highlight margin leakages and contribution changes.
Channel Profitability MT & E-commerce Focus
- Prepare channel-wise P&L; for Up-to-date Trade and E-commerce accounts.
- Allocate trade schemes, visibility spends, listing fees, platform commissions, logistics, and returns by channel/account.
- Analyze profitability by key MT accounts and E-commerce platforms.
Budgeting, Forecasting & Controls
- Assist in annual budgeting and monthly planning for product contributions and channel wise margins taking into account all spends and costs MT & E-commerce margins.
- Track budget vs actual for trade spends, contributions and visibility costs.
- Support different brand teams with the data points required from time to time.
Cross-Functional Coordination
Work closely with MT Sales, E-commerce, Brand and Finance teams
Preferred candidate profile
- Hands-on exposure to SAP
- Advanced MS Excel skills (Pivot Tables, lookups)
- Knowledge of trade spends, visibility , and platform costs
- Strong analytical skills with attention to detail
Role: MIS Executive, Industry Type: FMCG, Department: Finance & Accounting, Employment Type: Full Time, Permanent Role Category: Finance Education UG: B.Com in Any Specialization, B.B.A. / B.M.S. in Finance, Accounting PG: MBA/PGDM in Any Specialization Key Skills Skills highlighted with ‘‘ are preferred keyskills SAPMISMIS Reporting MS Office
📌 We are Hiring For MIS Executive || For Kolkata Location ||
🏢 Emami
📍 Kolkata