MIS Executive

Cogneesol; Sahibzada Ajit Singh Nagar; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Cogneesol in Mohali is seeking an MIS/Data Analyst to own daily, weekly, and monthly performance reporting for our franchise network. You will maintain ERP data, build dashboards, and present actionable insights to improve sales and margins across outlets.

Responsibilities include variance analysis, royalty tracking, cash flow and working capital reporting, and coordination with accounts, operations, and franchise managers. This role drives data accuracy and timely MIS delivery.

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.
• 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.
• 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).
• 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.
• 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
• Identify revenue leakages.
• Suggest cost-saving opportunities.
• Analyze slow-moving inventory.
• Recommend menu price revisions based on costs.
• Identify outlets requiring management intervention.
• 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.
• 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.

Job description

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.