MIS Reporting & Analyst

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