MIS MANAGER

Job Purpose

• Production Data Management & Reporting
• Develop, implement, and manage daily, weekly, and monthly MIS reports covering:
• Production output (planned vs. actual)
• Raw material consumption and variance (as per standard recipe norms)
• Wastage and rejections (batch-wise, product-wise)
• Labour utilization and productivity metrics
• Frozen product production and dispatch data
• Rework, yield, and recovery ratios
• Consolidate data from Central Kitchen, Frozen Division, and individual outlets into a unified dashboard.
• Ensure 100% data accuracy through regular validation and reconciliation with store, purchase, and finance data.
• Planning & Coordination
• Support the Production Head in daily and weekly production planning by providing:
• Historical consumption and yield trends
• Material availability and pending indents
• Frozen stock status for dispatch planning
• Coordinate closely with:
• Stores Team – for raw material inflow and issue reconciliation
• Purchase Team – for timely procurement as per production schedule
• Quality Team – for non-conformance and wastage reporting
• Outlet Operations Team – for monitoring frozen product usage and returns
• Cost Control & Variance Analysis
• Monitor and report key cost drivers:
• Material cost per kg / per product
• Manpower cost per batch / shift
• Energy and utilities cost per unit of output
• Identify abnormal consumption or negative yield trends and alert the Production Head.
• Assist in implementing cost-saving initiatives by providing data insights.
• System Development & Process Automation
• Develop and automate Excel/ERP/Zoho-based dashboards for real-time visibility of production performance.
• Work with the IT team to enhance the ERP module for:
• Batch production entry
• Recipe adherence
• Yield tracking
• Dispatch and frozen inventory
• Train supervisors, data entry operators, and production executives on MIS recording and data accuracy standards.
• Review & Decision Support
• Present summarized MIS reports during weekly and monthly management review meetings.
• Provide analytical insights to support decisions related to production scheduling, resource optimization, wastage reduction, and process efficiency improvement.
• Maintain a historical trend analysis dashboard to track improvements and identify recurring issues.
  

Requirements

• Advanced MS Excel (Pivot Tables, Power Query, Macros, Dashboards)
• Experience in Zoho, Tally, or ERP systems (preferably production modules)
• Working knowledge of Power BI / Tableau (advantageous)
• Understanding of food manufacturing KPIs — yield, wastage, batch control, cost variance
• Familiarity with frozen product management and shelf-life tracking
  

• Strong analytical and detail-oriented mindset
• Effective communicator with cross-functional coordination ability
• Discipline in timelines and accuracy
• Problem-solving attitude with a continuous improvement approach
• High integrity and process orientation
  

• Graduate in Commerce / Science / Engineering (Mandatory)
• MBA (Operations / Systems / Data Analytics) preferred
• 5–8 years of experience in MIS or Production Data Analysis in a Bakery / Food Manufacturing / FMCG / QSR environment
• Prior experience in yield analysis and frozen product monitoring will be an added advantage