Key Result Areas/Accountabilities

Supporting Actions

Regular Sales MIS reporting

- Prepare Monthly Customer Invoice level volume, gross sales, net sales and realization (NCR).
- Monthly Reconciliation of NCR with Trail balance – NCR Tally.
- Prepare Product-wise / sales area wise / segment wise contribution
- Prepare variance analysis against budget, forecast, and previous periods
- Present data related to sales volume performance, revenue trends, and other key metrics to seniors.
- Analyze sales trends, pricing impact, realization, discounts, and schemes.
- Prepare presentations for Business Head/CEO reporting
- Provide insight-driven analysis to support strategic and tactical decision-making.

Reports for Business review meeting/ Corporate finance cell – Quarterly reports
- Prepare details for pre-decided volume and revenue formats
- Arrange 2 players’ market share
- Prepare Urban and Rural performance report
- Prepare trade and non-trade performance
- Prepare presentations

Budget and latest estimate working
- Prepare revenue and logistic cost as per given volume
- Assist in budgeting process across departments. Coordinate with department heads to collect and consolidate budget data.




- Support management in revised forecasts and rolling budgets.
- Identify and explain price, volume, mix.

Additional various data preparation
- Sales and Marketing reports-

- Prepare related party transaction details based on revenue model
- Arrange requisite sales data for govt statistical department
- Calculate and Maintain inter unit valuable transfer rate
- Identify the lower contribution areas and report
- Timely incorporation of changes in schemes and price circulars in NCR as implemented by management
- Arrange revenue related data to auditors
- Support in tax assessment related data preparation
- Track actual performance against approved budgets on a monthly/quarterly basis.
- Prepare supply and distributions reports to show logistic and depot effectiveness.
- Depot landing cost comparison for optimum plant supply allocation
- Work out imported cement contribution
- Provide ad-hoc analysis as required by leadership

Automated / BI report
- Improve reporting efficiency through Power BI, Excel automation, SAP reports, and analytical tools.
- Work with SAP/TM1 team on report automation
- BI based report

📌 MIS Reporting & Analyst (Maharashtra)
🏢 UltraTech Cement
📍 Maharashtra