CORPORATE - MOUNT FRANKLIN FOODS LLC
Job Details
Level Experienced
Job Location Chicago - Hodgkins, IL
Position Type Full Time
Salary Range $65000.00 - $70000.00 Salary/year
Job Shift Day
Description
Summary of Job
The MRP Buyer Analyst is responsible for executing purchasing activities based on MRP signals from the Infor M3 ERP system, ensuring on-time procurement, optimal inventory levels, cost control, and supplier performance. This role requires strong analytical capabilities, advanced Excel proficiency (pivot tables, charts, macros), and a solid understanding of supply and demand dynamics within the food and beverage industry.
The position is KPI-driven, requiring familiarity with both industry-standard metrics and internal company performance indicators. The MRP Buyer Analyst plays a key role in maintaining supply continuity, supporting strategic decision making, and driving continuous improvement across procurement operations.
Essential Functions and Responsibilities
MRP Execution & Purchasing
- Process MRP messages including Pull-in, Push-out, and Cancellations. - Generate and manage purchase orders based on system demand and forecasted requirements. - Ensure Purchase order on time delivery from suppliers. - Monitor and act on shortage reports, past due reports, and supply & demand reports.
Cost & Price Management
- Track and analyze Purchase Price Variance (PPV) - Support cost control initiatives and identify opportunities for savings.
Inventory & Obsolescence Control (E&O)
- Monitor inventory levels to avoid excess stock, obsolete materials, and stockouts. - Support inventory health through proactive MRP Messages execution
- Monitor Expiration ingredients Inventory Reports - Participate in inventory reviews internally and with customers.
Data Analysis & Reporting
- Develop and maintain Excel based tools for analysis and projections using pivot tables, charts, and macros. - Ensure data integrity across procurement reports and ERP entries. - Provide visibility into purchasing trends, supplier performance, and forecast accuracy.
Internal & External Communication
- Maintain active communication with internal stakeholders (planning, operations, warehouse finance) and external customers/suppliers. - Ensure alignment on material needs, delivery schedules (BluJay), and service expectations.
KPI Ownership & Continuous Improvement
Own and track key performance indicators such as: • On time delivery rate (Past Due Reports accuracy) • Purchase order accuracy • Inventory turnover • PPV/FPPV trends
• System Data integrity Maintenance (LT updates, Delivery Terms, ETA Accuracy, etc)
Food Safety Responsibilities: Follow all relevant food safety rules including SQF, cGMPs, and Food Defense. Report any observed food safety violations to your supervisor immediately.
Education and Qualifications
Required Skills & Qualifications
- Bachelor's degree in supply chain, Business, Engineering, or related field. - Minimum 3 years of experience in MRP-based purchasing, preferably in food & beverage. - Strong knowledge of ERP systems ( Oracle, SAP, BAAN,etc), ideally Infor M3. - Advanced Excel skills: pivot tables, VLOOKUP, charts, macros (Essential). - Strong analytical mindset with ability to interpret large datasets and generate actionable insights. - Excellent communication and negotiation skills. - Detail oriented, organized, and proactive.
Preferred Qualifications
- Experience with supplier scorecards, cost analysis, and forecast modeling. - Knowledge of food safety regulations and quality standards.
Level Experienced
Job Location Chicago - Hodgkins, IL
Position Type Full Time
Salary Range $65000.00 - $70000.00 Salary/year
Job Shift Day
Description
Summary of Job
The MRP Buyer Analyst is responsible for executing purchasing activities based on MRP signals from the Infor M3 ERP system, ensuring on-time procurement, optimal inventory levels, cost control, and supplier performance. This role requires strong analytical capabilities, advanced Excel proficiency (pivot tables, charts, macros), and a solid understanding of supply and demand dynamics within the food and beverage industry.
The position is KPI-driven, requiring familiarity with both industry-standard metrics and internal company performance indicators. The MRP Buyer Analyst plays a key role in maintaining supply continuity, supporting strategic decision making, and driving continuous improvement across procurement operations.
Essential Functions and Responsibilities
MRP Execution & Purchasing
- Process MRP messages including Pull-in, Push-out, and Cancellations. - Generate and manage purchase orders based on system demand and forecasted requirements. - Ensure Purchase order on time delivery from suppliers. - Monitor and act on shortage reports, past due reports, and supply & demand reports.
Cost & Price Management
- Track and analyze Purchase Price Variance (PPV) - Support cost control initiatives and identify opportunities for savings.
Inventory & Obsolescence Control (E&O)
- Monitor inventory levels to avoid excess stock, obsolete materials, and stockouts. - Support inventory health through proactive MRP Messages execution
- Monitor Expiration ingredients Inventory Reports - Participate in inventory reviews internally and with customers.
Data Analysis & Reporting
- Develop and maintain Excel based tools for analysis and projections using pivot tables, charts, and macros. - Ensure data integrity across procurement reports and ERP entries. - Provide visibility into purchasing trends, supplier performance, and forecast accuracy.
Internal & External Communication
- Maintain active communication with internal stakeholders (planning, operations, warehouse finance) and external customers/suppliers. - Ensure alignment on material needs, delivery schedules (BluJay), and service expectations.
KPI Ownership & Continuous Improvement
Own and track key performance indicators such as: • On time delivery rate (Past Due Reports accuracy) • Purchase order accuracy • Inventory turnover • PPV/FPPV trends
• System Data integrity Maintenance (LT updates, Delivery Terms, ETA Accuracy, etc)
Food Safety Responsibilities: Follow all relevant food safety rules including SQF, cGMPs, and Food Defense. Report any observed food safety violations to your supervisor immediately.
Education and Qualifications
Required Skills & Qualifications
- Bachelor's degree in supply chain, Business, Engineering, or related field. - Minimum 3 years of experience in MRP-based purchasing, preferably in food & beverage. - Strong knowledge of ERP systems ( Oracle, SAP, BAAN,etc), ideally Infor M3. - Advanced Excel skills: pivot tables, VLOOKUP, charts, macros (Essential). - Strong analytical mindset with ability to interpret large datasets and generate actionable insights. - Excellent communication and negotiation skills. - Detail oriented, organized, and proactive.
Preferred Qualifications
- Experience with supplier scorecards, cost analysis, and forecast modeling. - Knowledge of food safety regulations and quality standards.