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.