MIS Executive

Daily Responsibilities

• Prepare daily outlet-wise and franchise-wise sales reports.
• Compare sales against targets and previous year/month.
• Track daily collections, bank deposits, and outstanding receivables.
• Monitor 8% royalty calculations and identify pending royalty collections.
• Prepare daily dashboard for management before the start of the day.
• Highlight low-performing outlets and major sales variances.

Weekly Responsibilities

• Outlet-wise profitability analysis.
• Food cost and recipe cost variance reports.
• Central kitchen sales and material supply reports.
• Inventory consumption and stock variance analysis.
• Swiggy, Zomato, and dine-in sales comparison.
• Marketing campaign performance analysis.

Monthly Responsibilities

• Franchise-wise P&L.
• Royalty collection summary.
• Outstanding debtors report.
• Budget vs actual expenditure.
• Cost centre-wise expense analysis.
• Cash flow and working capital reports.
• Vendor purchase analysis.
• Menu engineering report (best sellers and low sellers).

ERP & Data Management

• Ensure all purchases are entered in the ERP/Petpooja.
• Maintain item master, recipe master, and price master.
• Verify daily sales uploads from all outlets.
• Check data accuracy before reports are shared.

Dashboard Management

Develop And Maintain Dashboards For

• Daily sales
• Outlet ranking
• Franchise ranking
• Royalty collections
• CK sales
• Inventory
• Food cost
• EBITDA and profitability
• New outlet opening progress

Analysis & Decision Support

• Identify revenue leakages.
• Suggest cost-saving opportunities.
• Analyze slow-moving inventory.
• Recommend menu price revisions based on costs.
• Identify outlets requiring management intervention.

Coordination

• Work with Accounts for month-end closing.
• Coordinate with Purchase for vendor and material reports.
• Coordinate with Operations for sales and inventory issues.
• Coordinate with Franchise Managers for pending data and collections.

Key KPIs

100% on-time MIS reports.

99%+ report accuracy.

Daily dashboard shared

Month-end MIS completed within 3 working days.

Automated reporting wherever possible.

Actionable insights provided every week to improve sales or reduce costs.